Re: Frequent failover

Поиск
Список
Период
Сортировка
От kaido vaikla
Тема Re: Frequent failover
Дата
Msg-id CA+427g9qkZB4ptN6SS6OhkkeHh1HzK6Ojx9Y5rfpffP-wFFzCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Frequent failover  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Ответы Re: Frequent failover  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Hi
First of all, read a logs.
$PGDATA/log
#journalctl -u patroni
I had once failover flapping, because of master heavy load, caused by apliccation change. So, find a pattern.

If physical replication, after failover you don't need run a vacuum manually if autovacuum is enabled.

br
Kaido

On Mon, 6 Nov 2023 at 04:53, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi,

When I issue command patronictl history, I can see frequent failover. Like atleast weekly once.

Every time this happened we have to do vacuum analyse for all dba.

So, I need assistance in how to avoid frequent failovers and what is the solution for vacuum part we r doing..

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

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Frequent failover
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: unrecognized configuration parameter "ldapbinddn" in file "/var/lib/pgsql/data/postgresql.conf"