Re: connect to postgres from shell scripts - Mailing list pgsql-admin

From Tom Lane
Subject Re: connect to postgres from shell scripts
Date
Msg-id 19062.1124737141@sss.pgh.pa.us
Whole thread Raw
In response to Re: connect to postgres from shell scripts  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-admin
Devrim GUNDUZ <devrim@gunduz.org> writes:
> psql checks for PGUSER, PGPASSWORD, PGHOST, PGPORT, PGDATABASE and some
> other environmental variables. Export relevant values to the parameters.

PGPASSWORD is deprecated because it is insecure on some platforms
(to wit, those where other users can see a process' environment
variables via ps).  The ~/.pgpass file is the recommended way to go.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jason Minion"
Date:
Subject: Re: connect to postgres from shell scripts
Next
From: Scott Marlowe
Date:
Subject: Re: how to protect root access database