Re: Cannot connect to one specific postgres database on a server

["Melvin Davidson" <mdavidson(at)cctus(dot)com>]

I cannot tell you what is specificially wrong, but try the following:

 

Can you telnet to that database and query?

 

Is the postmaster running for that database?

 

Do you get any errors returned when you try to connect via telnet? What are they?

 

Is it possible your database is corrupted and you need to restore/rebuild?

---

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Matt Busby
Sent: Monday, January 22, 2007 9:37 AM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Cannot connect to one specific postgres database on a server

Hello,

I am having trouble connecting to one specific database on my server. I can connect to the server via pgadmin and have pgadmin display 7 or 8 databases I have running on the server. I can successfully connect to all of the databases except one. This particular database I am trying to connect to will just cause pgadmin to hang/crash

 

I have been using pgadmin for over 2 years to connect to this particular database that wont connect now. This just started happening a week ago and is frustrating me so bad! I have installed/reinstalled/uninstalled about every version on pgadmin with no success. I restarted postgres on the server with no success…

 

My server is running linux, and I am using windows version of pgadmin…

 

I WOULD REALLY APPRECIATE ANY HELP!!! THANKS SO MUCH!!!

 

Matt Busby