Question regarding blocking locks

From: "Kevin Keith" <kevinrkeith(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Question regarding blocking locks
Date: 2005-08-25 14:28:13
Message-ID: BAY108-F30AE11762B669A5598C02BB9AB0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a question regarding blocking locks in the pg database. I ran into a
process which terminated abnormally, and to fully clear the locks it left
behind I had to reboot the system (probably restarting postmaster would have
had the same effect). This was a personal development system so this was no
big deal to reboot it. I would like to know what other options I have so if
this was to occur in a production environment in the future I had a less
drastic measure to take to resolve the issue.

I saw the locks in the pg_locks view (the mode was Exclusivelock),

Can someone point me in the right direction to addressing such a problem
should it occur in the future?

Thanks,

Kevin

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Browne 2005-08-25 14:54:11 Re: size of indexes and tables (more than 1GB)
Previous Message Bruno Wolff III 2005-08-25 13:23:34 Re: size of indexes and tables (more than 1GB)