From: Nestor A. Diaz <nestor@tiendalinux.com>
To: gilberto.castillo@etecsa.cu
Cc: pgsql-admin@postgresql.org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: Wed, 17 Jul 2013 11:40:11 -0500
Message-ID: <51E6C8EB.60308@tiendalinux.com> (raw)
In-Reply-To: <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu>
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>
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)
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: nestor@tiendalinux.com, gilberto.castillo@etecsa.cu
Subject: Re: Help with PITR in PostgreSQL 8.4
In-Reply-To: <51E6C8EB.60308@tiendalinux.com>
* 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