Re: Help automate pg_dump - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Help automate pg_dump
Date
Msg-id 20020619204238.C8069@svana.org
Whole thread Raw
In response to Re: Help automate pg_dump  (Tycho Fruru <tycho@fruru.com>)
Responses Re: Help automate pg_dump
List pgsql-general
On Wed, Jun 19, 2002 at 12:32:29PM +0200, Tycho Fruru wrote:
> 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

Hmm, on linux this only shows the environment for your own processes. Does
this work differently on other systems?

$ cat /proc/1/environ
cat: /proc/1/environ: Permission denied

and if you're root, who cares?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

pgsql-general by date:

Previous
From: Tycho Fruru
Date:
Subject: Re: Help automate pg_dump
Next
From: Joseph Maxwell
Date:
Subject: Re: cannot initdb