[Top][All Lists]

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

Re: Handling load of servers during backups

From: Edke
Subject: Re: Handling load of servers during backups
Date: Tue, 8 Nov 2011 14:50:36 +0100


Really usefull info, I will test this also and will somehow try to
implement this into my rsnapshot pg_dump script.

On Mon, Nov 7, 2011 at 18:01,  <address@hidden> wrote:
> 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' .

s pozdravom do zatvy Edke

E-mail & gtalk: address@hidden

reply via email to

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