Re: Postgres Metrics

2023-04-15 Thread Joe Conway
On 4/15/23 07:04, André Rodrigues wrote: Hello I have just started in the new challenger as dba postgres and I am in charge of enhancing our postgres monitoring( dashboards and alarms ) using Grafana. Could you list me relevant metrics in postgres that I can apply in my environment  ? In

Postgres Metrics

2023-04-15 Thread André Rodrigues
Hello I have just started in the new challenger as dba postgres and I am in charge of enhancing our postgres monitoring( dashboards and alarms ) using Grafana. Could you list me relevant metrics in postgres that I can apply in my environment ? In additional, If someone else has grafana templat

Re: Replication lag due to lagging restart_lsn

2023-04-15 Thread milist ujang
Finally got this useful tool: https://github.com/EnterpriseDB/pg_failover_slots Since I usually do scheduled switchover, this tool really helps a lot. On Tue, Apr 11, 2023 at 10:39 AM milist ujang wrote: > I have a case that master has been restarted many times, restart_lsn not > moved since no