[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Handling load of servers during backups

From: Eric Pailleau
Subject: Re: Handling load of servers during backups
Date: Mon, 07 Nov 2011 16:53:32 +0100
User-agent: Mozilla/5.0 (X11; Linux i686; rv:5.0) Gecko/20110620 Thunderbird/5.0b2

Hi Edke,

In addition to Martin, (sorry not related to monit), you can tell postgresql 
that a backup
is currently running, by a simple pg_start_backup('ID')/pg_stop_backup() 
functions into postgresql.

The postgresql system, in such case, do not change files on disk but only the 
transaction log.
This allow to do a consistent rsnaphot/rsync.
After receiving pg_stop_backup(), the transaction log is dump into database 
files .

pg_dump is a heavy CPU consumming process, especially when compressing, even 
with  'nice' and 'ionice' .

Hope it can help.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]