[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] WAL replay asking for very old WAL
From:       Stephen Kuntz <Skuntz () pelmorex ! com>
Date:       2016-03-07 18:23:17
Message-ID: DM2PR0401MB1088E182F085EE5C1533246FACB10 () DM2PR0401MB1088 ! namprd04 ! prod ! outlook ! com
[Download RAW message or body]

I guess the only issue I have existed between the keyboard and chair. Thanks for your \
time and patients. 

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 12:01 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] WAL replay asking for very old WAL

this message ->
--
2016-03-07 16:04:56 UTC LOG: started streaming WAL from primary at
581D/84000000 on timeline 1
--

that the server has connected to the master via streaming replication so it should \
get the new xlogs without restarting. you can check that this is happening if you \
check the pg_last_xlog_receive_location() and pg_last_xlog_replay_location().

if the only problem is that the database is not online in read-only mode, then maybe \
the only thing missing is to enable the 'hot_standby = on' in the postgresql.conf






--
View this message in context: \
http://postgresql.nabble.com/WAL-replay-asking-for-very-old-WAL-tp5891050p5891083.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


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


[prev in list] [next in list] [prev in thread] [next in thread]