Postgres Pro
Downloads
Home   >   mailing lists

Locked out of database - Mailing list pgsql-admin

From terry@trance.co.uk (Terry Cox)
Subject Locked out of database
Date
Msg-id memo.20020315004110.100Q@trance.co.uk
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Syslog
Next
From: Eric Scroger
Date:
Subject: Postgres 6.4, gmake, d: command not found