Re: Help automate pg_dump

From: Tycho Fruru <tycho(at)fruru(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help automate pg_dump
Date: 2002-06-19 10:32:29
Message-ID: 1024482752.3368.3.camel@kungfoo.conostix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2002-06-18 at 18:48, Vivek Khera 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.

Actually, if you're using environment variables to preset usernames and
passwords your security is moot.

Try " ps exwww " and see the environment variables of all processes

Cheers,
Tycho

--
Tycho Fruru tycho(at)fruru(dot)com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-06-19 10:42:38 Re: Help automate pg_dump
Previous Message Bjoern Metzdorf 2002-06-19 10:21:39 Re: db grows and grows