John, > Does anyone have a way to run pg_dump from cron in a way that doesn't > require someone to enter the password on every run? I get the following > error even when the backup user has read permissions on all application > databases.
You can use the .pgpass file in the backup owner's home directory: *:5432:*:postgres:MyPassword *:5432:*:xxxx:XsPassword -- Gary Chambers -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
