Re: Help automate pg_dump

On 18 Jun 2002 12:48:15 -0400, Vivek Khera <khera(at)kcilink(dot)com> wrote:

>>>>>> "n" == nothanks <nothanks(at)nowhere(dot)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