pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Nestor A. Diaz <nestor@tiendalinux.com>
Cc: gilberto.castillo@etecsa.cu
Cc: pgsql-admin@postgresql.org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: Wed, 17 Jul 2013 12:26:55 -0500 (GMT+5)
Message-ID: <45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <51E6C8EB.60308@tiendalinux.com>
References: <51E4725C.3050609@tiendalinux.com>
	<CA+RSxMj79BMdEwtT0CC6-BDKxH1TbccVJZ3sJ_OVTG1oDGqFtg@mail.gmail.com>
	<51E6BBF6.2000000@tiendalinux.com>
	<37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu>
	<51E6C8EB.60308@tiendalinux.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

view thread (6+ messages)  latest in thread

Message-ID: <45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu>
Permalink:  ../45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu/
Also on:    postgresql.org/message-id/45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gilberto.castillo@etecsa.cu, nestor@tiendalinux.com
  Subject: Re: Help with PITR in PostgreSQL 8.4
  In-Reply-To: <45033.192.168.207.54.1374082015.squirrel@webmail.etecsa.cu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox