Search Postgresql Archives

Re: postgreSQL : duplicate DB names

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux