Re: Help automate pg_dump - Mailing list pgsql-general

From nothanks@nowhere.com
Subject Re: Help automate pg_dump
Date
Msg-id 3d124517.56416250@news.gv.shawcable.net
Whole thread Raw
In response to Help automate pg_dump  (nothanks@nowhere.com)
List pgsql-general

On 18 Jun 2002 12:48:15 -0400, Vivek Khera <khera@kcilink.com> wrote:

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

We, that might be the case, and I thank you for your answer, however,
on some platforms, the ps command can be used to view processes and
thier environment variables, making this solution quite insecure.
Perhaps another solution should be investigated by the postgres team.

Thanks again.

Evan

pgsql-general by date:

Previous
From: "Gianfranco Masia - Eprom s.r.l."
Date:
Subject: Is it possible compile Pg 7.1.3 to run under Win98?
Next
From: Doug Fields
Date:
Subject: Re: Idea for the statistics collector