Best way to stop Streaming Replication?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Best way to stop Streaming Replication?
Date: 2023-12-22 19:49:34
Message-ID: CANzqJaAvhK+82KyC=NJ6HGi3VhwHibSUAH2+b2T-3w9Ct4HbXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PG 14.10 and 15.5, if it matters.

Running pg_terminate_backend() on the walsender pid (and then dropping the
replication slot) seems the canonical solution, based on StackExchange, but
that leaves primary_conninfo in postgresql.auto.conf and standby.signal in
$PGDATA.

Promoting the secondary (and then dropping the replication slot) handles
all those issues, but leaves it in R/W mode, which might cause split brain
issues with cluster managers.

Is there a better way than the two I've described

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message kaido vaikla 2023-12-22 21:11:32 Re: Best way to stop Streaming Replication?
Previous Message Md. Ezhar Ansari 2023-12-22 14:20:22 Inquiry Regarding PostgreSQL Index Size - Seeking Community Insights