Re: Help with PITR in PostgreSQL 8.4

On 7/17/13 10:40 AM, Nestor A. Diaz wrote:
>> Hello Nestor
>>
>> I use its:
>>
>> standby_mode = 'on'
>> primary_conninfo = 'host=X.X.X.X port=5432 user=XXXX password=YYYYYTT'
>> trigger_file = '/var/pgsql/data/pg_failover_trigger'
>> restore_command = 'cp /wal/%f /var/lib/postgresql/8.4/main/"%p"'
> Ok, but those instructions are for 9.1 not for 8.4, I would like to be
> sure if there is any way to perform countinus archiving then recovery
> then backup and loop over this every day whithout having to rsync every
> time I recover the standby database (8.4)
>
> Slds
>
>
AFAIK The only way to do this in 8.4 is to make a copy of the standby
and bring the copy online. We do it to run backups off the standby like
this:

1) take the standby down (pg_ctl -m fast stop)
2) rsync the standby to the standby-copy
3) restart the standby (it will return to recovery mode)
4) bring the standby copy online (remove it's recovery.conf and start it up)
5) run the backups on the copy
6) shutdown the copy (but leave it in place so the next rsync only has
to copy changed data)
7) rinse and repeat