On 15/10/2010 22:12, John Iliffe wrote:
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 need to use a .pgpasss file:
http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html
You can instead specify the password in an environment variable, but
that potentially makes it visible to all users on the system, so the
.pgpass is better.
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
