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