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(at)iol(dot)ie