From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Nestor A. Diaz <nestor@tiendalinux.com>
Cc: chiru r <chirupg@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help with PITR in PostgreSQL 8.4
Date: Wed, 17 Jul 2013 10:54:51 -0500 (GMT+5)
Message-ID: <37977.192.168.207.54.1374076491.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <51E6BBF6.2000000@tiendalinux.com>
References: <51E4725C.3050609@tiendalinux.com>
<CA+RSxMj79BMdEwtT0CC6-BDKxH1TbccVJZ3sJ_OVTG1oDGqFtg@mail.gmail.com>
<51E6BBF6.2000000@tiendalinux.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> 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
---
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
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, chirupg@gmail.com
Subject: Re: Help with PITR in PostgreSQL 8.4
In-Reply-To: <37977.192.168.207.54.1374076491.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