Re: [GENERAL] pg_upgrade -u

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Ray Stell <stellr(at)vt(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] pg_upgrade -u
Date: 2013-06-29 01:58:36
Message-ID: 21507.1372471116@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bhanu udaya 2013-06-29 01:59:47 Re: Postgres case insensitive searches
Previous Message Bruce Momjian 2013-06-29 01:43:35 Re: [GENERAL] pg_upgrade -u

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-06-29 02:04:49 Outputting UTC offset with to_char()
Previous Message Stephen Frost 2013-06-29 01:57:05 Re: New regression test time