| From: | Krzysztof Barlik <kbarlik(at)wp(dot)pl> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall asking for password for each database |
| Date: | 2008-07-05 00:39:46 |
| Message-ID: | 200807050239.46251.kbarlik@wp.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> What version are you running? IIRC it should remember the password
> between databases.
8.4.0 on Linux/x86_64. It does not, and man page clearly says:
"pg_dumpall needs to connect several times to the
PostgreSQL server (once per database). If you use password
authentication it will ask for a password each time."
Is there any specific reason for this behaviour ?
Thanks for Scott and Joshua - I read documentation about
.pgpass and PGPASSWORD, I just thought it would be a bit
more convenient and possibly safer to do it without
storing password in files or environment variables.
Thanks,
Krzysztof
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaromír Talíř | 2008-07-05 10:12:04 | AT TIME ZONE and DST in UTC<->CET conversion |
| Previous Message | dushy | 2008-07-04 20:23:50 | Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ? |