Re: Pg_dump and password - Mailing list pgsql-admin

From Vishal Arora
Subject Re: Pg_dump and password
Date
Msg-id BLU110-W23B74BAA7FA18874BCE22FA92F0@phx.gbl
Whole thread Raw
In response to Pg_dump and password  ("Pleyer, Walter" <Walter.Pleyer@lfrz.at>)
List pgsql-admin




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

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Pg_dump and password
Next
From: n0g0013
Date:
Subject: Re: Postgres 8.2 install on solaris 10