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, <[email protected]> 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: [email protected] -- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
