On Fri, Mar 09, 2007 at 10:29:46AM -0800, D Unit wrote:
> I can't get the .pgpass file working. I think the problem may have to do with
> the fact that the user's home directory is '/'. Is there a way to specify a
> different location for .pgpass other than '~/.pgpass'?
Set the PGPASSFILE environment variable. Also, make sure group and
world have no permissions on the file.
http://www.postgresql.org/docs/8.2/interactive/libpq-pgpass.html
http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html
--
Michael Fuhr