Re: Determine which query prevents applying WALs on standby

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Re: Determine which query prevents applying WALs on standby
Дата
Msg-id 87worywseu.fsf@jsievers.enova.com
обсуждение исходный текст
Ответ на Determine which query prevents applying WALs on standby  (Andrey Zhidenkov <andrey.zhidenkov@gmail.com>)
Ответы 答复: Determine which query prevents applying WALs on standby  ("For your eyes only..." <xzyshnok@msn.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: recovery.conf not getting changed to recovery.done after PITR
Следующее
От: Poul Kristensen
Дата:
Сообщение: Postgresql jdbc driver for PG version 9.5