Postgres Pro
Downloads
Home   >   mailing lists

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

From Jerry Sievers
Subject Re: Determine which query prevents applying WALs on standby
Date
Msg-id 87worywseu.fsf@jsievers.enova.com
Whole thread Raw
In response to Determine which query prevents applying WALs on standby  (Andrey Zhidenkov <andrey.zhidenkov@gmail.com>)
Responses 答复: Determine which query prevents applying WALs on standby
List pgsql-admin
Tree view 
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: Jerry Sievers
Date:
Subject: Re: recovery.conf not getting changed to recovery.done after PITR
Next
From: Poul Kristensen
Date:
Subject: Postgresql jdbc driver for PG version 9.5