Postgres Pro
Downloads
Home   >   mailing lists

答复: Determine which query prevents applying WALs on standby - Mailing list pgsql-admin

From For your eyes only...
Subject 答复: Determine which query prevents applying WALs on standby
Date
Msg-id MWHPR14MB1421465E13E7C14533ADCFDDCF000@MWHPR14MB1421.namprd14.prod.outlook.com
Whole thread Raw
In response to Re: Determine which query prevents applying WALs on standby  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-admin
Tree view 
Hi team,

Would please remove me from it.


Beat Regard,
Zhenyu Xu

-----邮件原件-----
发件人: Jerry Sievers <gsievers19@comcast.net> 
发送时间: Thursday, September 6, 2018 23:35
收件人: Andrey Zhidenkov <andrey.zhidenkov@gmail.com>
抄送: pgsql-admin@postgresql.org
主题: Re: Determine which query prevents applying WALs on standby

Andrey Zhidenkov <andrey.zhidenkov@gmail.com> writes:

> Is there a way to detect which query (or queries) on hot standby holds 
> streaming replication? Looked into the sources and found out that 
> function ResolveRecoveryConflictWithVirtualXIDs do that job but have 
> no idea how to do that with SQL.

The pg_locks view on your standby should reveal something.

>
> --
> With best regards, Andrey Zhidenkov.
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800

pgsql-admin by date:

Previous
From: Mike Broers
Date:
Subject: root cause of corruption in hot standby
Next
From: amit tripathi
Date:
Subject: Re: recovery.conf not getting changed to recovery.done after PITR