Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Cassiano, Marco" <mcassiano(at)manord(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
Date: 2010-06-22 16:48:12
Message-ID: 201006221648.o5MGmC218301@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-testers

Cassiano, Marco wrote:
> Hi all,
>
>
>
> it's my first trial with pg_upgrade so I'm surely missing something....
>
> I'm trying to launch pg_upgrade passing my super user name but
> pg_dumpall fails with a permission denied error....
>
> I don't see the username in the pgdumpall call....could it be this the
> problem ?
>
> Thank you (I hope this is the right list to post this)

Turns out I was missing the user name designation. I am attaching the
patch that fixes this, and a pg_ctl issue on Win32.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +

Attachment Content-Type Size
/rtmp/diff text/x-diff 5.4 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-06-22 16:57:36 Re: blocking automatic vacuum
Previous Message Igor Neyman 2010-06-22 16:43:19 Re: parallel option in pg_restore

Browse pgsql-testers by date

  From Date Subject
Next Message Cassiano, Marco 2010-06-23 16:02:32 R: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
Previous Message Cassiano, Marco 2010-06-22 16:13:48 pg_upgrade fails with "permission denied for relation pg_authid"