Best way to stop Streaming Replication?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Best way to stop Streaming Replication?
Дата
Msg-id CANzqJaAvhK+82KyC=NJ6HGi3VhwHibSUAH2+b2T-3w9Ct4HbXQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Best way to stop Streaming Replication?  (kaido vaikla <kaido.vaikla@gmail.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Md. Ezhar Ansari"
Дата:
Сообщение: Inquiry Regarding PostgreSQL Index Size - Seeking Community Insights
Следующее
От: kaido vaikla
Дата:
Сообщение: Re: Best way to stop Streaming Replication?