> 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
