Use a some tools like patroni. I'm patroni user since 2016 and happy with
it.
br
Kaido
On Fri, 22 Dec 2023, 21:49 Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
> 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
>