Automated Database Backups

Поиск
Список
Период
Сортировка
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.

The database that fails is part of the PostgreSQL kernel, not my
application data so I'm leery of tampering with permissions here.

The command line I am using is:

/usr/postgres-8.4.2/bin/pg_dump -f /notraid/dbbkup.`date +%Y%m%d` -F
custom -v -U xxxx dbxxxx

Thanks in advance.

John



В списке pgsql-general по дате отправления: