Re: Cannot connect to one specific postgres database

Hi.

I am one idea.
Please set up a log as the option of pgAdmin and acquire it.
The information on it and the version to be used is required.
we have to avoid hang/crash ......:-(

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Andy Shellam (Mailing Lists)" 


> 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