Re: Help with PITR in PostgreSQL 8.4

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Nestor A(dot) Diaz" <nestor(at)tiendalinux(dot)com>
Cc: gilberto(dot)castillo(at)etecsa(dot)cu, pgsql-admin(at)postgresql(dot)org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: 2013-07-17 17:26:55
Message-ID: 45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu
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)
>

See you:
http://www.postgresql.org.es/node/238
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html

Saludos,
Gilberto Castillo
La Habana, Cuba

Attachment Content-Type Size
unknown_filename text/plain 179 bytes

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ketana Patel 2013-07-17 20:08:39 Re: comparison schema/data
Previous Message etharani 2013-07-17 17:15:29 Re: Migration from Sybase to Postgresql