| From: | Janning Vygen <vygen(at)gmx(dot)de> | 
|---|---|
| To: | "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Why is there no option -U with pg_dump? | 
| Date: | 2001-11-08 10:05:56 | 
| Message-ID: | 0111081105560A.05323@janning | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Why is there no option -U with pg_dump?
when i call psql i can connect as another user and i usually dont 
need a password because i trust all local users via hba.conf, right?
thats the way it works on my host. but why cant i connect via pg_dump?
i need this because every devolper gets his own database and 
sometimes a developer wants to mirror the production database. i 
tried to write a little shell script which drops and recreates your 
user databse and then uses the dump of the production database to 
create schema and fill teh rows. useful option is --no-owner to 
supress the connect statements. 
But i cant connect without user input. because the option -U ask for 
username and password.
Any workaround or suggestions?
janning
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tuckheng | 2001-11-08 10:34:15 | "Relation does not exist" error | 
| Previous Message | Bo Lorentsen | 2001-11-08 08:20:42 | Re: Caching query plan... |