Locked out of database

From: terry(at)trance(dot)co(dot)uk (Terry Cox)
To: pgsql-admin(at)postgresql(dot)org
Cc: terry(at)trance(dot)co(dot)uk
Subject: Locked out of database
Date: 2002-03-15 00:41:00
Message-ID: memo.20020315004110.100Q@trance.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Our replication system appears to have crashed and left locks on all the
tables. How can I unlock the tables for writing again?

I have tried dumping the data and re-importing into a fresh database, but
the locks appear to be stored with the dump.

Terry Cox

Trance Development

Browse pgsql-admin by date

  From Date Subject
Next Message Tony Reina 2002-03-15 01:10:32 New vacuum for 7.2
Previous Message Tom Lane 2002-03-15 00:03:45 Re: [SQL] Syslog