Friday, November 11, 2011

Postgresql - the pgpass file

In this file we can store our access credentials to a database(es) to skip typing them each time. Of course,some security precautions are in order.


30.13. The Password File

The file .pgpass in a user's home directory or the file referenced by PGPASSFILE can contain passwords to be used if the connection requires a password (and no password has been specified otherwise).

This file should contain lines of the following format:

hostname:port:database:username:password



http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html

No comments:

Post a Comment