From: | "Milen A(dot) Radev" <milen(at)radev(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: PGPASSWORD |
Date: | 2006-02-23 20:43:08 |
Message-ID: | 43FE1E5C.7010604@radev.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mr. Dan | 2006-02-23 20:55:28 | Re: PGPASSWORD |
Previous Message | Tomeh, Husam | 2006-02-23 20:30:25 | Re: problems to install PostgreSQL |