| From: | kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> |
|---|---|
| To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Frequent failover |
| Date: | 2023-11-06 08:04:41 |
| Message-ID: | CA+427g9qkZB4ptN6SS6OhkkeHh1HzK6Ojx9Y5rfpffP-wFFzCQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)dba09(at)gmail(dot)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..
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl O. Pinc | 2023-11-06 15:16:55 | Re: pgadmin for ubuntu 23.10 (mantic) |
| Previous Message | Aditya Toshniwal | 2023-11-06 04:54:08 | Re: pgadmin for ubuntu 23.10 (mantic) |