Re: [GENERAL] pg_upgrade -u - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [GENERAL] pg_upgrade -u
Date
Msg-id 51CE5BBE.3010801@gmx.net
Whole thread Raw
In response to Re: [GENERAL] pg_upgrade -u  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [GENERAL] pg_upgrade -u
List pgsql-hackers
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?




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: MVCC catalog access
Next
From: Fabien COELHO
Date:
Subject: Re: New regression test time