pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg_dump and password
4+ messages / 4 participants
[nested] [flat]
* Pg_dump and password
@ 2008-02-08 08:04 Pleyer, Walter <Walter.Pleyer@lfrz.at>
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:20 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Pleyer, Walter <Walter.Pleyer@lfrz.at>
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:47 Milen A. Radev <milen@radev.net>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
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 09:01 Vishal Arora <aroravishal22@hotmail.com>
parent: Pleyer, Walter <Walter.Pleyer@lfrz.at>
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