Re: pg_dumpall asking for password for each database
Started by Krzysztof Barlikalmost 18 years ago1 messagesgeneral
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
Import Notes
Reply to msg id not found: 20091006225959.GT5929@alvh.no-ip.orgReference msg id not found: 200909261832.55653.kbarlik@wp.plReference msg id not found: 200910062259.32192.kbarlik@wp.plReference msg id not found: 20091006225959.GT5929@alvh.no-ip.org