Re: WAL replay asking for very old WAL

Поиск
Список
Период
Сортировка
От Stephen Kuntz
Тема Re: WAL replay asking for very old WAL
Дата
Msg-id DM2PR0401MB1088E182F085EE5C1533246FACB10@DM2PR0401MB1088.namprd04.prod.outlook.com
обсуждение исходный текст
Ответ на Re: WAL replay asking for very old WAL  (MirrorX <mirrorx@gmail.com>)
Список pgsql-admin
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
enablethe '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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Armand Pirvu (home)"
Дата:
Сообщение: Re: pg_dump and pg_restore relative to the schema
Следующее
От: Chris Lajoie
Дата:
Сообщение: Re: Getting OOM errors from PostgreSQL