Re: backup software for postgresql - Mailing list pgsql-admin

From Chris Browne
Subject Re: backup software for postgresql
Date
Msg-id 60ek70lzsc.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to backup software for postgresql  ("Robert Ngo" <robertngo@perridot.com>)
List pgsql-admin
robertngo@perridot.com ("Robert Ngo") writes:
> Which backup software out there work well with postgresql, I cannot
> find one with backup agent for postgres.:p>

You don't need one.

You can simply schedule a job that runs "pg_dump" every so often
(daily is common) to save data to a file.  Most competent backup
systems can backup data in files, so can pull the pg_dump output...
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://www3.sympatico.ca/cbbrowne/backup.html
"sic transit discus mundi"
-- From the System Administrator's Guide, by Lars Wirzenius

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: two instances of Postgres in the same server
Next
From: "Adriano Gaspar"
Date:
Subject: System Tables