Re: postgreSQL : duplicate DB names

-----Original Message-----
From: Alban Hertroys [mailto:haramrae(at)gmail(dot)com]
Sent: Monday, May 26, 2014 10:21 AM
To: Khangelani Gama
Cc: Thomas Kellerer; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names

On 26 May 2014, at 10:09, Khangelani Gama <kgama(at)argility(dot)com> 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.