From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Tycho Fruru <tycho(at)fruru(dot)com> |
Cc: | Vivek Khera <khera(at)kcilink(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Help automate pg_dump |
Date: | 2002-06-19 10:42:38 |
Message-ID: | 20020619204238.C8069@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Maxwell | 2002-06-19 10:48:20 | Re: cannot initdb |
Previous Message | Tycho Fruru | 2002-06-19 10:32:29 | Re: Help automate pg_dump |