Bucardo can read .pgpass
files to obtain database connection passwords if trust
authentication is not in use.
The .pgpass
file to read for a given database is specified by the pgpass field in bucardo’s db table. The field should contain the full path and filename of the .pgpass
files to read. The value can be entered either by editing the db table or using the bucardo command line tool to specify a pgpass=
option when adding a database.
File format
hostname:port:database:username:password
Gotchas:
.pgpass
file must be readable by the owner of the postmaster (Postgres server) processs..pgpass
file are not processed by bucardo, although they are by Postgres. You must exactly match the hostname, port, database and username you specified when creating your database in Bucardo for the password lookup to succeed.End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.