logical replication on 12.2: failed to increase restart lsn:

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: logical replication on 12.2: failed to increase restart lsn:
Date: 2020-04-08 11:30:41
Message-ID: F5AB5622-941B-468E-B1E6-92A2FBEA7FEC@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I try to replace a physical by a logical replication and get:
- - -
"serializing snapshot to pg_logical/snapshots/215-746C7C20.snap",,,,,,,,,"meteo"
"updated xmin: 1 restart: 0",,,,,,,,,"meteo"
"failed to increase restart lsn: proposed 215/746C7C20, after 215/746C7C20, current candidate 215/746C7C20, current after 215/746C7C20, flushed up to 215/746C7C20",,,,,,,,,eteo"
- - -
My understanding is, that initial catch up of existing table contents is done auromatically.

Related config on both ends is minimalistic:

publisher:
wal_keep_segments = 400 #!# 6GB in logfile segments, 16MB each; 0 disables
wal_level = logical
hot_standby_feedback = on

subscriber:
wal_keep_segments = 400 #!# 6GB in logfile segments, 16MB each; 0 disables
wal_level = logical
hot_standby_feedback = on

Anny help appreciated,
Axel
---
PGP-Key: CDE74120 ☀ computing @ chaos claudius

Browse pgsql-admin by date

  From Date Subject
Next Message Christophe Courtois 2020-04-08 11:41:26 Re: How to get more than 2^32 BLOBs
Previous Message Donato Marrazzo 2020-04-08 10:12:17 Re: How to get more than 2^32 BLOBs