Re: Help with PITR in PostgreSQL 8.4 - Mailing list pgsql-admin

From Nestor A. Diaz
Subject Re: Help with PITR in PostgreSQL 8.4
Date
Msg-id 51E6C8EB.60308@tiendalinux.com
Whole thread Raw
In response to Re: Help with PITR in PostgreSQL 8.4  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Responses Re: Help with PITR in PostgreSQL 8.4  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Re: Help with PITR in PostgreSQL 8.4  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-admin
> 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


--
Typed on my key64.org keyboard

Nestor A. Diaz
T: +57-1-485-3020,211
M: +57-316-227-3593
nestor@tiendalinux.com
www.tiendalinux.com



pgsql-admin by date:

Previous
From: "Gilberto Castillo"
Date:
Subject: Re: Help with PITR in PostgreSQL 8.4
Next
From: "Gilberto Castillo"
Date:
Subject: Re: Help with PITR in PostgreSQL 8.4