Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with pg_upgrade. - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems with pg_upgrade.
Date
Msg-id 3047.1406652778@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems with pg_upgrade.  (Bror Jonsson <brorfred@gmail.com>)
List pgsql-general
Tree view 
Bror Jonsson <brorfred@gmail.com> writes:
> Is there any way to figure out which the original superuser was?

You got a surplus of superusers?

Anyway, it should be the one with OID 10.

select * from pg_authid where oid = 10;

            regards, tom lane

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Problems with pg_upgrade.
Next
From: "byfei163@163.com"
Date:
Subject: Re: PG_TERMINATE_BACKEND not working.