Re: Help with PITR in PostgreSQL 8.4

> Hi Chiru, I have done archiving on primary server, and recovery on
> standby server, howerver, after the first recovery I am unable to
> recover more wal files on standby server
>
> Can it be possible in 8.4 ? or just in 9.1 ?
>
> This is the recovery I use:
>
> << EOF
>
> restore_command = '/usr/lib/postgresql/8.4/bin/pg_standby -l -d -s 2 -t
> /var/run/postgresql/8.4-main.trigger
> /var/lib/postgresql/8.4/main/wal-archive %f %p %r
> 2>>/var/log/postgresql/postgresql-8.4-main-standby.log'
> recovery_end_command = 'rm -f /var/run/postgresql/8.4-main.trigger'
>
> EOF
>
>
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"'

Saludos,
Gilberto Castillo
La Habana, Cuba