Thread: Pg_dump and password
Hi Folks! Is it possible to call pg_dump not only with -U username but also with the user's password? Walter
Στις Friday 08 February 2008 10:04:46 ο/η Pleyer, Walter έγραψε: > Hi Folks! > > Is it possible to call pg_dump not only with -U username but also with the user's password? No, you should use the PGPASSWORD env variable. > > Walter > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Achilleas Mantzios
Achilleas Mantzios написа: > Στις Friday 08 February 2008 10:04:46 ο/η Pleyer, Walter έγραψε: >> Hi Folks! >> >> Is it possible to call pg_dump not only with -U username but also with the user's password? > No, you should use the PGPASSWORD env variable. >> Walter Actually the recommended method for passing a password to a libpq-linked programme is by using the .pgpass file (http://www.postgresql.org/docs/8.3/static/libpq-envars.html and http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html). -- Milen A. Radev
> From: Walter.Pleyer@lfrz.at
> To: pgsql-admin@postgresql.org
> Date: Fri, 8 Feb 2008 09:04:46 +0100
> Subject: [ADMIN] Pg_dump and password
>
> Hi Folks!
>
> Is it possible to call pg_dump not only with -U username but also with the user's password?
Yes you can use -W option along with -U option while calling pg_dump. -W would enforce password prompt, once authenticated it would take the dump.
>
> Walter
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
- Vishal
Live the life in style with MSN Lifestyle. Check out! Try it now!