Re: 'replication checkpoint has wrong magic' on the newly cloned replicas

From: Alex Kliukin <alexk(at)hintbits(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: 'replication checkpoint has wrong magic' on the newly cloned replicas
Date: 2017-11-30 16:52:59
Message-ID: 1512060779.2961325.1189622728.53C41299@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Nov 30, 2017, at 16:36, Andres Freund wrote:
> Hi,
>
> On 2017-11-30 11:44:29 +0100, Alex Kliukin wrote:
> > max_replication_slots is 5 and logical replication is not used
> > altogether there.
>
> Can you show the results of
> SELECT * FROM pg_replication_origin;
> SELECT * FROM pg_replication_origin_status ;

SELECT * FROM pg_replication_origin;
roident | roname
---------+--------
(0 rows)

SELECT * FROM pg_replication_origin_status ;
local_id | external_id | remote_lsn | local_lsn
----------+-------------+------------+-----------
(0 rows)

--
Sincerely,
Alex

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ghiureai 2017-11-30 17:20:07 PG 10 streaming replication pg_wal question
Previous Message Andres Freund 2017-11-30 15:36:07 Re: 'replication checkpoint has wrong magic' on the newly cloned replicas