Re: Automated Database Backups
От | John Iliffe |
---|---|
Тема | Re: Automated Database Backups |
Дата | |
Msg-id | 1287341624.5188.11.camel@linuxprod2 обсуждение исходный текст |
Ответ на | Re: Automated Database Backups (Raymond O'Donnell <rod@iol.ie>) |
Список | pgsql-general |
Thanks to those who replied to my post. I tried that and works a treat! Regards. John ====================================================== On Sat, 2010-16-10 at 17:18 +0100, Raymond O'Donnell wrote: > 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 >
В списке pgsql-general по дате отправления: