Postgres Pro
Downloads
Home   >   mailing lists

Re: Reporting from Standby - Mailing list pgsql-admin

From Don Seiler
Subject Re: Reporting from Standby
Date
Msg-id CAHJZqBDAeQfwysnnBu07MoZWuSOUD4nZsWNvNb_vcE2Kh0h6hw@mail.gmail.com
Whole thread Raw
In response to Re: Reporting from Standby  (Mahesh Shetty <maheshetty20@gmail.com>)
Responses Re: Reporting from Standby  (Mahesh Shetty <maheshetty20@gmail.com>)
List pgsql-admin
Tree view
On Thu, Dec 1, 2022 at 1:31 PM Mahesh Shetty <maheshetty20@gmail.com> wrote:
What is the replication conflict you are facing - Can you share output from  pg_stat_database_conflicts ?

The errors stopped a few hours ago so I'm not sure if this info is meaningful or not, but here it is. The "foo" database (real name changed) is obviously the app database where all the querying takes place. 

postgres=# select * from pg_stat_database_conflicts;
 datid |  datname  | confl_tablespace | confl_lock | confl_snapshot | confl_bufferpin | confl_deadlock
-------+-----------+------------------+------------+----------------+-----------------+----------------
 17156 | postgres  |                0 |          0 |              0 |               0 |              0
 13399 | template0 |                0 |          0 |              0 |               0 |              0
 16400 | template1 |                0 |          0 |              0 |               0 |              0
 16401 | foo       |                0 |          0 |           6736 |              35 |              0
(4 rows) 

--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Mahesh Shetty
Date:
Subject: Re: Reporting from Standby
Next
From: Mahesh Shetty
Date:
Subject: Re: Reporting from Standby