pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pg_dump and password
4+ messages / 4 participants
[nested] [flat]

* Pg_dump and password
@ 2008-02-08 08:04 Pleyer, Walter <Walter.Pleyer@lfrz.at>
  2008-02-08 08:20 ` Re: Pg_dump and password Achilleas Mantzios <achill@matrix.gatewaynet.com>
  2008-02-08 09:01 ` Re: Pg_dump and password Vishal Arora <aroravishal22@hotmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Pleyer, Walter @ 2008-02-08 08:04 UTC (permalink / raw)
  To: pgsql-admin

Hi Folks!

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

Walter






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Pg_dump and password
  2008-02-08 08:04 Pg_dump and password Pleyer, Walter <Walter.Pleyer@lfrz.at>
@ 2008-02-08 08:20 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
  2008-02-08 08:47   ` Re: Pg_dump and password Milen A. Radev <milen@radev.net>
  1 sibling, 1 reply; 4+ messages in thread

From: Achilleas Mantzios @ 2008-02-08 08:20 UTC (permalink / raw)
  To: pgsql-admin

Στις 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Pg_dump and password
  2008-02-08 08:04 Pg_dump and password Pleyer, Walter <Walter.Pleyer@lfrz.at>
  2008-02-08 08:20 ` Re: Pg_dump and password Achilleas Mantzios <achill@matrix.gatewaynet.com>
@ 2008-02-08 08:47   ` Milen A. Radev <milen@radev.net>
  0 siblings, 0 replies; 4+ messages in thread

From: Milen A. Radev @ 2008-02-08 08:47 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Pg_dump and password
  2008-02-08 08:04 Pg_dump and password Pleyer, Walter <Walter.Pleyer@lfrz.at>
@ 2008-02-08 09:01 ` Vishal Arora <aroravishal22@hotmail.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Vishal Arora @ 2008-02-08 09:01 UTC (permalink / raw)
  To: Pleyer, Walter <walter.pleyer@lfrz.at>; 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
_________________________________________________________________
Tried the new MSN Messenger? It’s cool! Download now.
http://messenger.msn.com/Download/Default.aspx?mkt=en-in=

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2008-02-08 09:01 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-08 08:04 Pg_dump and password Pleyer, Walter <Walter.Pleyer@lfrz.at>
2008-02-08 08:20 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2008-02-08 08:47   ` Milen A. Radev <milen@radev.net>
2008-02-08 09:01 ` Vishal Arora <aroravishal22@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox