PGPASSWORD - Mailing list pgsql-admin

From Mr. Dan
Subject PGPASSWORD
Date
Msg-id BAY102-F239156E2128536C70F414CD1F20@phx.gbl
Whole thread Raw
Responses Re: PGPASSWORD  ("Milen A. Radev" <milen@radev.net>)
Re: PGPASSWORD  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PGPASSWORD  (Andy Shellam <andy.shellam@mailnetwork.co.uk>)
List pgsql-admin
Hi,

When I was running 8.0.X on linux, I didn't have to include the postgres -P
password in my shell scripts(.sh).  After I switched to 8.1.X, I've had to
include the -P PASSWORD ****** in all my scripts.  I'm thinking I'll just
add PGPASSWORD as a postgres environment variable instead.   I did start
running 8.1.X on a port that is different from the default, so I added
PGPORT as an environment variable, so I don't have to include -p PORT
NUMBER.  Has anyone else noticed they had to start including a password for
the postgres user in 8.1.X?  Is there any concern to adding PGPASSWORD as an
environment variable.

Thanks for any feedback,
~DjK



pgsql-admin by date:

Previous
From: Robin Iddon
Date:
Subject: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Next
From: "Sunanda Kumaraguru"
Date:
Subject: ERROR: Cannot determine geometry type (empty table).