Wayne Conrad wrote:
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.
Yes, of course. Is there another way?