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
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 |