On Tue, 02 Aug 2011 17:13:31 -0400, David F. Skoll wrote: > 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. <snip>
Yes, that's what I do too. Unless the database is gargantuan, it works very well.
