Re: Handling load of servers during backups

[Edke]

Hello.

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