-----Original Message----- From: Alban Hertroys [mailto:haramrae@xxxxxxxxx] Sent: Monday, May 26, 2014 10:21 AM To: Khangelani Gama Cc: Thomas Kellerer; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] postgreSQL : duplicate DB names On 26 May 2014, at 10:09, Khangelani Gama <kgama@xxxxxxxxxxxx> wrote: >> Khangelani Gama, 26.05.2014 09:20: >>> Hi >>> >>> Something wrong happened in our server, for some strange and unknown >>> reason (s) the server created another DB, there is two same DB names >>> in one server. >>> >>> Name | Owner | Encoding >>> ---------+----------+---------- >>> a9004 | postgres | UNICODE >>> a9004 | postgres | UNICODE >>> >> >> Maybe there are some trailing spaces at one of the names. >> >> What do you see when you run this: >> >> select '"'||datname||'"' as name >> from pg_database >> >> By adding the quotes, you can see if there are any trailing (or >> leading) in the name. >> >> Regards >> Thomas > Hi, > > I get: > > name > -------------- > "a9004" > "template1" > "template0" > "a9004" > (4 rows) Looks like you might have some index corruption, do those databases have the same oid?: select datname, oid from pg_database What version of the database are you running? What OS? Did anything of notice happen on that server before this showed up? P.S. Please don't top-post on this list. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. It's psql 8.0.4, OS is Red Hat Linux release 9 (Shrike datname | oid ------------+------------ a9004 | 4215680815 template1 | 1 template0 | 17229 a9004 | 1335509510 (4 rows) CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.
