You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@spamassassin.apache.org by "David F. Skoll" <df...@roaringpenguin.com> on 2011/08/02 23:13:31 UTC

Shutting down PostgreSQL for a backup (was Re: MySQL Bayes - can slow MySql cause other tests not to run?)

On Tue, 02 Aug 2011 19:26:37 +0100
Martin Gregorie <ma...@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.

Re: Shutting down PostgreSQL for a backup (was Re: MySQL Bayes - can slow MySql cause other tests not to run?)

Posted by Walter Hurry <wa...@lavabit.com>.

On Tue, 02 Aug 2011 17:13:31 -0400, David F. Skoll wrote:

> On Tue, 02 Aug 2011 19:26:37 +0100
> Martin Gregorie <ma...@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.