Sorry for the confusion, I am by no means a postgresql guru.
In my other slave servers I don't have the message:
2016-03-07 16:23:36 UTC ERROR: cannot execute UNLISTEN during recovery
2016-03-07 16:23:36 UTC STATEMENT: unlisten *
In the logs once they are caught up to the master. It also doesn't seem to switch to standby mode properly and stream
fromthe master. When I restart, it replays the WAL files since the last restart from the archive. This data should have
beenstreamed from the master, no?
standby_mode = 'on'
primary_conninfo = 'user=<replicationuser> password=<mypassword> host=masterserver port=5432 sslmode=prefer
sslcompression=1krbsrvname=postgres'
restore_command = 'copy "\\\\archivefileserver\\BACKUP\\DatabaseBackups\\wal_archive\\%f" "%p"'
Stephen Kuntz | Systems Administrator
Pelmorex Media Inc.
T: 905.829.1159 x1376
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of MirrorX
Sent: Monday, March 7, 2016 11:13 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] WAL replay asking for very old WAL
sorry i don't follow.
the server will stay in recovery mode as long as a recovery.conf file exists and the host is set up to receive xlogs
viastreaming from the master. this seems to be the case according to the logs, if i am not wrong.
what it is you want to happen? the server to stop applying records and come online in r/w mode?
in this case you could promote the server. or if you want just to apply some wal files and then come online then i
thinkyou have misconfigured your recovery.conf. i would suggest you paste here what your recovery.conf contains and
whatthe objective is
Best,
--
View this message in context: http://postgresql.nabble.com/WAL-replay-asking-for-very-old-WAL-tp5891050p5891074.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin