Re: Help automate pg_dump - Mailing list pgsql-general

From Vivek Khera
Subject Re: Help automate pg_dump
Date
Msg-id x7k7owildc.fsf@onceler.kciLink.com
Whole thread Raw
In response to Help automate pg_dump  (nothanks@nowhere.com)
Responses Re: Help automate pg_dump  (Tycho Fruru <tycho@fruru.com>)
List pgsql-general
>>>>> "n" == nothanks  <nothanks@nowhere.com> writes:

n> If the username/password must be interactive, how can I script backup
n> of the server?

It honors the standard environment variables for user/password, so
just set them.  And make sure your script is not readable by anyone
else, or your security is moot.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-general by date:

Previous
From: terry@greatgulfhomes.com
Date:
Subject: Re: db grows and grows
Next
From: Bill Moran
Date:
Subject: Re: db grows and grows