Re: unattended backups - Mailing list pgsql-novice

From Alan Hodgson
Subject Re: unattended backups
Date
Msg-id 200708271332.15430@hal.medialogik.com
Whole thread Raw
In response to unattended backups  ("Andrew C. Uselton" <acuselton@lbl.gov>)
List pgsql-novice
On Monday 27 August 2007 13:18, "Andrew C. Uselton" <acuselton@lbl.gov>
wrote:
> I'd like to stick a "pg_dumpall" in a
> cron job, and supply it with the password.  I don't mind having the
> administrative password somewhere readable by root, but I am stumped how
> to carry this out.

Put it in root's .pgpass file.

--
99 percent of lawyers give the rest a bad name


pgsql-novice by date:

Previous
From: "Andrew C. Uselton"
Date:
Subject: unattended backups
Next
From: Mija Lee
Date:
Subject: using system catalogs