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 database.
Hope you will consider this.
Thanks, John Griffiths
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
