How to track down locks held by recovery process on a slave?

From: Amador Alvarez <apradopg(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to track down locks held by recovery process on a slave?
Date: 2013-10-04 22:48:37
Message-ID: CA+vGRtg+8wNugVByhLrhZX=SBnb7k9b9zZfOMPNo7nAEoRAu6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there,

I am using a postgres 9.2 slave for some reports and I noticed that
sometimes they are held up because certain activity on the master like
vacuums can affect long queries on a slave .

Looking at pg_locks view , I can see that the recovering process on the
slave is holding some AccessExclusiveLock locks on relations which numbers
that do not mach any pg_class.oid.

Any idea How could I find out which relations are locked by the recovering
process?

Thanks in advance,
A.A.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message reiner peterke 2013-10-05 07:08:37 Re: How to track down locks held by recovery process on a slave?
Previous Message Mike Broers 2013-10-04 19:14:39 Re: ERROR: could not open file "base/125542/12631" Corruption?