Re: Help automate pg_dump

>>>>> "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/