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!
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
