Pg_dump : Can I specify the Password ?
Hello,
I'm doing automated database dump and want to be able to specify
Username and Passowrd in my shell script for pg_dump.
When I do man pg_dump there are no options for password. There is -U
username to specify username which actually doesn't work for me, I
still get prompted for username, but there is nothing to specify
password.
Is there anyway of going around this? I need to automate everything
and forego prompting.
Thanks in advance.
N.K.
On Wed, Aug 27, 2003 at 12:28:18PM -0700, N.K. wrote:
I'm doing automated database dump and want to be able to specify
Username and Passowrd in my shell script for pg_dump.
What PG version are you using? If you are on 7.3 or later you can use
the ~/.pgpass file. If you are using an earlier version, try the
PGPASSWORD environment variable.
They are both documented in the "libpq" section of the docs, IIRC.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso." (Ernesto Hern�ndez-Novich)