Re: postgres 8.2.9 can't drop database in single user mode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgres 8.2.9 can't drop database in single user mode
Date: 2009-04-22 03:53:26
Message-ID: 20202.1240372406@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Maria L. Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> writes:
> i'm getting the following error..... any ideas why this would be in
> single user mode??

Maybe you've got some prepared transactions laying about?
Check pg_prepared_xacts ...

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maria L. Wilson 2009-04-22 11:44:21 Re: postgres 8.2.9 can't drop database in single user mode
Previous Message Bruce Momjian 2009-04-21 23:38:21 Re: [ADMIN] License Issue