Re: WAL replay asking for very old WAL

From: MirrorX <mirrorx(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL replay asking for very old WAL
Date: 2016-03-07 17:01:11
Message-ID: 1457370071685-5891083.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armand Pirvu (home) 2016-03-07 17:55:59 pg_dump and pg_restore relative to the schema
Previous Message Stephen Kuntz 2016-03-07 16:38:40 Re: WAL replay asking for very old WAL