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? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
