Re: PGPASSWORD

Mr. Dan написа:
> 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.
>

See the paragraph about "PGPASSWORD" at
http://www.postgresql.org/docs/8.1/static/libpq-envars.html - it
recommends the use of "~/.pgpass" file.


BTW I can't seem to find any reference to a "-P" parameter related to
supplying a password.


--
Milen A. Radev