Thread: Pg_dump and password

Pg_dump and password

From
"Pleyer, Walter"
Date:
Hi Folks!

Is it possible to  call pg_dump not only with -U username but also with the user's password?

Walter




Re: Pg_dump and password

From
Achilleas Mantzios
Date:
Στις 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

Re: Pg_dump and password

From
"Milen A. Radev"
Date:
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

Re: Pg_dump and password

From
Vishal Arora
Date:




> 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!