Skip site navigation (1) Skip section navigation (2)


From: postgresbugs <postgresbugs(at)grifent(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Date: 2005-02-25 14:16:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
I know this is not a bug, but I didn't see a list that I thought this 
would fit into.

I saw in the documentation that PGPASSWORD is deprecated in favor of of 
the .pgpass file for security reasons.

I would like to recommend removing the deprecation flag from PGPASSWORD. 
It is very useful in dynamic setting of passwords by applications to run 
pg_dump and psql and the like from applications. I use it in several 
applications. This way I can give users access to database information 
without giving them access to the database. I also use in an application 
server in a process to make one PostgreSQL database a backup of another 
and then the application server keeps the two in sync.

Without PGPASSWORD or applications like pg_dump and psql accepting a 
password on the command line, I would not be able to do this since the 
user running the application server may not have access to the actual 

Hope you will consider this.

John Griffiths


pgsql-bugs by date

Next:From: Richard HuxtonDate: 2005-02-25 14:37:12
Subject: Re: select clause not according to SQL standard
Previous:From: Klaus ItaDate: 2005-02-25 14:06:59
Subject: select clause not according to SQL standard

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group