I can telnet to the
database and query the database…. The site that is using the database is also
running fine
Not sure what
postmaster is…. How can I check if its running? I did a
google search for it, but not sure how to check it on
my postgres db server
I don’t get any errors
using telnet … I can access the db every other way it seems, just using postgres
If I restore/rebuild
the db, will that cause the database to go down at all? I will try anything to
get pgadmin working with the db… it makes my life SOOO
much easier!
Thanks very much for
taking the time to help me with this issue! Much
appreciated!
Matt
-----Original
Message-----
From: Melvin
Davidson [mailto:mdavidson(at)cctus(dot)com]
Sent: Monday, January 22,
2007 2:01
PM
To: Matt Busby
Cc:
pgadmin-support(at)postgresql(dot)org
Subject: RE: [pgadmin-support] Cannot
connect to one specific postgres database on a server
I cannot
tell you what is specificially wrong, but try the
following:
Can you
telnet to that database and query?
Is the
postmaster running for that database?
Do you get
any errors returned when you try to connect via telnet? What are
they?
Is it
possible your database is corrupted and you need to
restore/rebuild?
From:
pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Matt Busby
Sent: Monday, January 22,
2007 9:37
AM
To:
pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Cannot connect
to one specific postgres database on a server
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
