Re: Automated Database Backups - Mailing list pgsql-general

From Gary Chambers
Subject Re: Automated Database Backups
Date
Msg-id AANLkTimmNwT_8uXEhfXwrLrHRxMxL0PbTnHsShmZ1MyX@mail.gmail.com
Whole thread Raw
In response to Automated Database Backups  (John Iliffe <john.iliffe@iliffe.ca>)
List pgsql-general
John,

> 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 can use the .pgpass file in the backup owner's home directory:

*:5432:*:postgres:MyPassword
*:5432:*:xxxx:XsPassword

-- Gary Chambers

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Automated Database Backups
Next
From: Rob Sargent
Date:
Subject: Re: installing from source in Windows