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.
