Postgres Pro
Downloads
Home   >   mailing lists

Re: password option in pg_dumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: password option in pg_dumpall
Date
Msg-id 20160.1202433687@sss.pgh.pa.us
Whole thread Raw
In response to password option in pg_dumpall  ("rkmr.em@gmail.com" <rkmr.em@gmail.com>)
List pgsql-general
Tree view 
"rkmr.em@gmail.com" <rkmr.em@gmail.com> writes:
> is there anyway of specifying password in the command line interface
> of pg_dumpall??

No, and you wouldn't want to use it if there was (hint: putting a
password on a command line is insecure).

The recommended procedure to avoid a lot of password prompts is to
set up a ~/.pgpass file:
http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html

            regards, tom lane

pgsql-general by date:

Previous
From: "rkmr.em@gmail.com"
Date:
Subject: password option in pg_dumpall
Next
From: "Satoru Fukushima"
Date:
Subject: How can exe files such as 'pg_dump' be called from stored functions?