Can you connect to it OK using psql on the server's console?
If you can, try dumping the database using pg_dump, then restore it as a
different database and try connecting via PgAdmin to the new copy.
Matt Busby wrote:
>
> 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
>
> !DSPAM:37,45b5078b118211361817358!
