Re: Automated Database Backups

From: Gary Chambers <gwchamb(at)gmail(dot)com>
To: John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Automated Database Backups
Date: 2010-10-16 16:19:02
Message-ID: AANLkTimmNwT_8uXEhfXwrLrHRxMxL0PbTnHsShmZ1MyX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2010-10-16 16:25:15 Re: installing from source in Windows
Previous Message Raymond O'Donnell 2010-10-16 16:18:04 Re: Automated Database Backups