Re: Help with PITR in PostgreSQL 8.4

From: "Nestor A(dot) Diaz" <nestor(at)tiendalinux(dot)com>
To: gilberto(dot)castillo(at)etecsa(dot)cu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: 2013-07-17 16:40:11
Message-ID: 51E6C8EB.60308@tiendalinux.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tiendalinux(dot)com
www.tiendalinux.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message etharani 2013-07-17 17:15:29 Re: Migration from Sybase to Postgresql
Previous Message Gilberto Castillo 2013-07-17 15:54:51 Re: Help with PITR in PostgreSQL 8.4