Re: Automated Database Backups

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@iol.ie