| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "N(dot)K(dot)" <nadiak(at)parkerglobal(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Pg_dump : Can I specify the Password ? |
| Date: | 2003-08-28 05:26:21 |
| Message-ID: | 20030828052621.GB7382@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 27, 2003 at 12:28:18PM -0700, N.K. wrote:
> I'm doing automated database dump and want to be able to specify
> Username and Passowrd in my shell script for pg_dump.
What PG version are you using? If you are on 7.3 or later you can use
the ~/.pgpass file. If you are using an earlier version, try the
PGPASSWORD environment variable.
They are both documented in the "libpq" section of the docs, IIRC.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso." (Ernesto Hernández-Novich)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2003-08-28 05:31:01 | Re: Problem compiling tablefunc module in contributions |
| Previous Message | Alvaro Herrera | 2003-08-28 05:15:04 | Re: SQL Command - To List Tables ? |