Re: password option in pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: password option in pg_dumpall
Date: 2008-02-08 01:21:27
Message-ID: 20160.1202433687@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Satoru Fukushima 2008-02-08 01:43:43 How can exe files such as 'pg_dump' be called from stored functions?
Previous Message rkmr.em@gmail.com 2008-02-08 01:00:51 password option in pg_dumpall