Postgres Pro
Downloads
Home   >   mailing lists

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

From girish R G peetle
Subject Re: Dropped database still shows in the database list.
Date
Msg-id CAKKd0655u_adJirUcczyEOXkv-zXYejBiFBjdffQ5DrkYDzvmw@mail.gmail.com
Whole thread Raw
In response to Re: Dropped database still shows in the database list.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Thanks a lot, got it.

Thanks
Girish

On Fri, May 22, 2015 at 1:36 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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: Glyn Astill
Date:
Subject: Re: Performances issues with SSD volume ?
Next
From: "Graeme B. Bell"
Date:
Subject: Re: Performances issues with SSD volume ?