Re: [GENERAL] pg_upgrade -u

On Fri, Jun 28, 2013 at 11:59:58PM -0400, Peter Eisentraut wrote:
> On 6/28/13 9:43 PM, Bruce Momjian wrote:
> > On Fri, Jun 28, 2013 at 09:15:31PM -0400, Peter Eisentraut wrote:
> >> On 6/28/13 6:06 PM, Bruce Momjian wrote:
> >>> On Wed, May 29, 2013 at 09:44:00AM -0400, Peter Eisentraut wrote:
> >>>> On 5/28/13 10:55 PM, Bruce Momjian wrote:
> >>>>> Wow, I never realized other tools used -U for user, instead of -u. 
> >>>>> Should I change pg_upgrade to use -U for 9.4?  I can keep supporting -u
> >>>>> as an undocumented option.
> >>>>
> >>>> It seems to me that that option shouldn't be necessary anyway.
> >>>> pg_upgrade should somehow be able to find out by itself what the
> >>>> superuser of the old cluster was.
> >>>
> >>> Uh, any idea how to do that?
> >>
> >> select rolname from pg_authid where oid = 10;
> > 
> > Uh, how do I know what username to connect as to issue that query?
> 
> single-user mode?

Yes, but single-user mode is a whole new set of problems.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +