Re: PostgreSQL logical replication depends on WAL segments? - Mailing list pgsql-general

From Andres Freund
Subject Re: PostgreSQL logical replication depends on WAL segments?
Date
Msg-id 20190122185203.dxv5abjm5dxuh5zz@alap3.anarazel.de
Whole thread Raw
In response to PostgreSQL logical replication depends on WAL segments?  (Josef Machytka <josef.machytka@gmail.com>)
List pgsql-general
Hi,

On 2019-01-22 14:18:12 +0100, Josef Machytka wrote:
> Hello, I already tried to ask on stackoverflow but so far without success.
> (
> https://stackoverflow.com/questions/54292816/postgresql-logical-replication-depends-on-wal-segments
> )
> 
> Could someone help me please?
> 
> ****
> 
> I am successfully using logical replication between 2 PG 11 cloud VMs for
> latest data. But I tried to publish also some older tables to transfer data
> between databases and got strange error about missing WAL segment.

That ought not to happen, logical replication won't start in the past,
and the slot will prevent necessary WAL from being removed.  Are you
manually removing WAL from pg_wal/?


Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Jeremy Finzel
Date:
Subject: Re: PostgreSQL logical replication depends on WAL segments?
Next
From: Andres Freund
Date:
Subject: Re: PostgreSQL logical replication depends on WAL segments?