Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CABFC633559 for ; Mon, 2 Mar 2009 21:31:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21659-01 for ; Mon, 2 Mar 2009 21:31:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id B0A7063378D for ; Mon, 2 Mar 2009 21:31:25 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n231VLER001731; Mon, 2 Mar 2009 20:31:21 -0500 (EST) To: Carol Walter cc: pgsql-admin@postgresql.org Subject: Re: Database in use? In-reply-to: <27F905C5-A238-446A-A0E8-21174783E46C@indiana.edu> References: <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> Comments: In-reply-to Carol Walter message dated "Mon, 02 Mar 2009 16:44:41 -0500" Date: Mon, 02 Mar 2009 20:31:21 -0500 Message-ID: <1730.1236043881@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/28 X-Sequence-Number: 31528 Carol Walter 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