From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carol Walter <walterc@indiana.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database in use?
Date: Mon, 02 Mar 2009 20:31:21 -0500
Message-ID: <1730.1236043881@sss.pgh.pa.us> (raw)
In-Reply-To: <27F905C5-A238-446A-A0E8-21174783E46C@indiana.edu>
References: <EA6C319D-9983-438C-8CB9-5424605A5CE1@indiana.edu>
<23817.1236025942@sss.pgh.pa.us>
<91CFD986-3CF6-4419-9908-2FEF9C469441@indiana.edu>
<28543.1236029013@sss.pgh.pa.us>
<27F905C5-A238-446A-A0E8-21174783E46C@indiana.edu>
Carol Walter <walterc@indiana.edu> writes:
> I'm not sure I understand. If there is a lag time between when
> someone exits the database and when the database "knows" that no one
> is still in it, then that shouldn't be the problem here. I tried a
> number of time over the course of 24 hours to rename the database and
> it always reported that the database was in use. No one was logged in
> but me, but the database still reported that the database was in use.
Hmph. Are you sure nothing was connected? One thing that frequently
trips people up here is uncommitted prepared transactions --- look in
pg_prepared_xacts.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, walterc@indiana.edu
Subject: Re: Database in use?
In-Reply-To: <1730.1236043881@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox