pg_dump and -U flag.

From: speedboy <speedboy(at)nomicrosoft(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump and -U flag.
Date: 2001-09-16 23:46:29
Message-ID: Pine.LNX.4.21.0109170942270.695-100000@b.evark.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am trying to use pg_dump as user root but using another username for the
database.

I set USER="postgres" and exported it. It still tries to login using the
root username. PGPASSWORD can be set and exported, is there a way I can do
this for the username?

Also, could it be possible for someone to program support in pg_dump to
have a -U flag/argument to set the username that pg_dump will use?

p.s. I'd like not to use -S and expect.

Thankyou.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message speedboy 2001-09-16 23:55:27 Re: pg_dump and -U flag.
Previous Message Tom Lane 2001-09-16 23:18:18 Re: pg_dump error - LOCALIZATION PROBLEM