Re: WAL accumulating, Logical Replication pg 13

Hi Willy-Bas Loos, On 31.05.21 17:32, Willy-Bas Loos wrote: On Mon, May 31, 2021 at 4:24 PM Vijaykumar Jain > wrote: So I got it all wrong it seems :) Thank you for taking the time to help me! You upgraded to pg13 fine? , but while on pg13 y

Re: WAL accumulating, Logical Replication pg 13

This part. If you can read perl :), https://github.com/postgres/postgres/tree/master/src/test/subscription/t On Mon, May 31, 2021, 9:02 PM Willy-Bas Loos wrote: > > > On Mon, May 31, 2021 at 4:24 PM Vijaykumar Jain < > vijaykumarjain.git...@gmail.com> wrote: > >> So I got it all wrong it seems

Re: WAL accumulating, Logical Replication pg 13

On Mon, May 31, 2021 at 4:24 PM Vijaykumar Jain < vijaykumarjain.git...@gmail.com> wrote: > So I got it all wrong it seems :) > Thank you for taking the time to help me! You upgraded to pg13 fine? , but while on pg13 you have issues with logical > replication ? > Yes, the upgrade went fine. So he

Re: WAL accumulating, Logical Replication pg 13

So I got it all wrong it seems :) You upgraded to pg13 fine? , but while on pg13 you have issues with logical replication ? There is a path in the postgresql source user subscription folder iirc which covers various logical replication scenarios. That may help you just in case. I have tried all k

Re: WAL accumulating, Logical Replication pg 13

Thank you for elaborating those possible causes and for the suggestions you made. 1) if you have an inactive replication slot. There is only 1 replication slot and it is active. So that is not the issue. 2) Do you have archiving enabled? No, i never turned it on and so this is in the settings of