Postgres Pro
Downloads
Home   >   mailing lists

Re: Dropped database still shows in the database list. - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Dropped database still shows in the database list.
Date
Msg-id CAKFQuwb+Wbg=HGFo3f=2fDcSmbMLaVCof8HX3YzEJLgUVM2Uyg@mail.gmail.com
Whole thread Raw
In response to Dropped database still shows in the database list.  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: Dropped database still shows in the database list.
List pgsql-admin
Tree view
On Thursday, May 21, 2015, girish R G peetle <giri.anamika0@gmail.com> wrote:
Hi,
Dropped database 'RestoreDB' is still being listed in pg_database. 
Any idea why this behavior is seen ? Also I don't see any open connections to this database. 


Try removing your where clause on the select,

"RestoreDB" and RestoreDB are two different databases.  The later is case-folded to be equivalent to "restoredb".

The double quotes I'm using are significant.

David J.

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Dropped database still shows in the database list.
Next
From: Glyn Astill
Date:
Subject: Re: Performances issues with SSD volume ?