Automated Database Backups

Поиск
Список
Период
Сортировка
От John Iliffe
Тема Automated Database Backups
Дата
Msg-id 1287177170.4390.30.camel@linuxprod2
обсуждение
Ответы Re: Automated Database Backups
Re: Automated Database Backups
Re: Automated Database Backups
Список pgsql-general
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 по дате отправления: