Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Khangelani Gama
-Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, May 26, 2014 5:35 PM To: Alban Hertroys Cc: Khangelani Gama; Thomas Kellerer; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgreSQL : duplicate DB names Alban Hertroys writes: > On 26 May 2014, at 10

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Tom Lane
Alban Hertroys writes: > On 26 May 2014, at 10:28, Khangelani Gama wrote: >> It's psql 8.0.4, OS is Red Hat Linux release 9 (Shrike > 8.0.4? That went EOL almost 4 years ago and even then you should be running a > version around 8.0.26. You’re 22 bugfix releases behind, which likely > includes

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Khangelani Gama
-Original Message- From: Alban Hertroys [mailto:haram...@gmail.com] Sent: Monday, May 26, 2014 11:11 AM To: Khangelani Gama Cc: Thomas Kellerer; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgreSQL : duplicate DB names On 26 May 2014, at 10:28, Khangelani Gama wrote: > On

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Alban Hertroys
On 26 May 2014, at 10:28, Khangelani Gama wrote: > On 26 May 2014, at 10:09, Khangelani Gama 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 n

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Khangelani Gama
-Original Message- From: Alban Hertroys [mailto:haram...@gmail.com] Sent: Monday, May 26, 2014 10:21 AM To: Khangelani Gama Cc: Thomas Kellerer; pgsql-general@postgresql.org Subject: Re: [GENERAL] postgreSQL : duplicate DB names On 26 May 2014, at 10:09, Khangelani Gama wrote

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Alban Hertroys
On 26 May 2014, at 10:09, Khangelani Gama 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 | Enco

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Khangelani Gama
, May 26, 2014 9:42 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] postgreSQL : duplicate DB names 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

Re: [GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Thomas Kellerer
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 |

[GENERAL] postgreSQL : duplicate DB names

2014-05-26 Thread Khangelani Gama
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. How I can I fix this. Please help Name| Owner | Encoding +--+-- a9004| postgres | UNICODE