Re: Cannot connect to one specific postgres database

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: Matt Busby <busby(at)condodomain(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Cannot connect to one specific postgres database
Date: 2007-01-22 19:13:39
Message-ID: 45B50CE3.7040404@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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!

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Hiroshi Saito 2007-01-22 19:21:50 Re: Cannot connect to one specific postgres database
Previous Message Matt Busby 2007-01-22 19:09:36 Re: Cannot connect to one specific postgres database on a server