| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Josef Machytka <josef(dot)machytka(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL logical replication depends on WAL segments? |
| Date: | 2019-01-22 18:52:03 |
| Message-ID: | 20190122185203.dxv5abjm5dxuh5zz@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2019-01-22 18:52:44 | Re: PostgreSQL logical replication depends on WAL segments? |
| Previous Message | Jeremy Finzel | 2019-01-22 17:57:00 | Re: PostgreSQL logical replication depends on WAL segments? |