Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrey Zhidenkov
Subject Determine which query prevents applying WALs on standby
Date
Msg-id CAJw4d1WDwy9CBvuagZDfHbjWmU3smfBR4X2uxL698e7m5JZzxQ@mail.gmail.com
Whole thread Raw
Responses Re: Determine which query prevents applying WALs on standby  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-admin
Tree view 
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.

--
With best regards, Andrey Zhidenkov.

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: User to get locked after three wrong login attempts.
Next
From: Jerry Sievers
Date:
Subject: Re: recovery.conf not getting changed to recovery.done after PITR