Re: Inactive replication slots - Mailing list pgsql-admin

From Jeff Janes
Subject Re: Inactive replication slots
Date
Msg-id CAMkU=1yEAW0qoNA0hjjmw0H3ddB-R3q9fadgRWWT6aBk=oX75g@mail.gmail.com
Whole thread Raw
In response to Inactive replication slots  (Teja Jakkidi <teja.jakkidi05@gmail.com>)
Responses Re: Inactive replication slots
List pgsql-admin
On Mon, Jun 20, 2022 at 3:12 PM Teja Jakkidi <teja.jakkidi05@gmail.com> wrote:
Hello Everyone,

I have a primary Postgres server with 2 standbys setup using streaming replication. Both the stand by servers are using the replication slots.
Today, when I checked the status of replication slots on primary, they are showing active= ‘f’. The data is replicating with no issues but when the slots are inactive I know that the wal files generated after the restart_lsn will not be deleted and retains the transactions, which is very critical.
I am not sure exactly why the slots are inactive and if there is a way to activate them back?

Is primary_slot_name set on each replica?

Cheers,

Jeff

pgsql-admin by date:

Previous
From: Teja Jakkidi
Date:
Subject: Inactive replication slots
Next
From: Teja Jakkidi
Date:
Subject: Re: Inactive replication slots