Re: PITR Questions - Mailing list pgsql-general

From Wayne Conrad
Subject Re: PITR Questions
Date
Msg-id 20060804133603.GA11428@yagni.com
Whole thread Raw
In response to PITR Questions  ("Matthew T. O'Connor" <matthew@zeut.net>)
Responses Re: PITR Questions  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
On Thu, Aug 03, 2006 at 05:03:35PM -0400, Matthew T. O'Connor wrote:
> I have it set as follows:
> archive_command = 'rsync -a %p backup_server:/pgsql_pitr/%f'
>
> Any comments as to whether or not this is a *good* choice?

Are you also doing the dance with pg_start_backup(), doing a file copy
of main, and then pg_stop_backup()?  That's your full backup; the PITR
files are something like incremental backups and need the copy of main
to play against.

        Wayne Conrad

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Best Procedural Language?
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: pg_dump sequence problem