[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] How to track down locks held by recovery process on a slave?
From: reiner peterke <zedaardv () drizzle ! com>
Date: 2013-10-05 7:08:37
Message-ID: FBEFAD41-BFC2-463F-8836-074DB85E1E6A () drizzle ! com
[Download RAW message or body]
First thought is make sure you are looking in the right database.
pg_locks shows data over the entire server, not just the connected database.
pg_class exists for each database so if you are connected to 'my_database' but the \
object is in 'your_database', it won't show up in pg_class on 'my_database'.
check the database value in pg_locks to verify where you should be looking for the \
object.
reiner
On 5 okt 2013, at 00:48, Amador Alvarez <apradopg@gmail.com> wrote:
> 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic