Re: Help automate pg_dump - Mailing list pgsql-general

From Tycho Fruru
Subject Re: Help automate pg_dump
Date
Msg-id 1024482752.3368.3.camel@kungfoo.conostix.com
Whole thread Raw
In response to Re: Help automate pg_dump  (Vivek Khera <khera@kcilink.com>)
Responses Re: Help automate pg_dump  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Tue, 2002-06-18 at 18:48, Vivek Khera 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.

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@fruru.com
"Prediction is extremely difficult. Especially about the future."
  - Niels Bohr

Attachment

pgsql-general by date:

Previous
From: "Bjoern Metzdorf"
Date:
Subject: Re: db grows and grows
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Help automate pg_dump