On Tue, 02 Aug 2011 19:26:37 +0100 Martin Gregorie <mar...@gregorie.org> wrote:
> I have an overnight cron job > that shuts down Postgres, takes a backup, and restarts the database. Just out of curiosity: Why do you do it that way? pg_dump lets you take a backup snapshot of the DB without shutting it down. Or (as of Pg 9.0) you can use streaming replication to have a warm-standby server act as a backup. Regards, David.