Re: PITR Questions - Mailing list pgsql-general

From Matthew T. O'Connor
Subject Re: PITR Questions
Date
Msg-id 44D361E3.2090105@zeut.net
Whole thread Raw
In response to Re: PITR Questions  (Wayne Conrad <wconrad@yagni.com>)
Responses Re: PITR Questions  (Wayne Conrad <wconrad@yagni.com>)
List pgsql-general
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?

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Importance of re-index
Next
From: Tom Lane
Date:
Subject: Re: pg_dump sequence problem