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

From Tom Lane
Subject Re: [GENERAL] pg_upgrade -u
Date
Msg-id 21507.1372471116@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] pg_upgrade -u  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On 6/28/13 6:06 PM, Bruce Momjian wrote:
>> On Wed, May 29, 2013 at 09:44:00AM -0400, Peter Eisentraut wrote:
>>> 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;

But that only works if you've already been able to connect, no?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: New regression test time
Next
From: Bruce Momjian
Date:
Subject: Outputting UTC offset with to_char()