When you say "The site that is using the database is also running fine", Do you mean users are accessing that database? If so, that check the port # you are using to connect. You might also try adding a new server connection to that database in pgadmin. postmaster is the postgresql process that is needed to access the database. Telnet to the server and do ps -ef | grep postmaster You should see something like admin 2986 1 0 Jan12 ? 00:00:00 /home/pgsql/postgresql-8.0.6/bin/postmaster You will have a process for each database on a separate port. If all postmaster(s) are running, then perhaps someone or something(gremlins) :) has modified the pg_hba.conf file in the $PGDATA directory? ________________________________
From: Matt Busby [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 12:10 PM To: Melvin Davidson Cc: pgadmin-support@postgresql.org Subject: RE: [pgadmin-support] Cannot connect to one specific postgres database on a server 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:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 2:01 PM To: Matt Busby Cc: pgadmin-support@postgresql.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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Busby Sent: Monday, January 22, 2007 9:37 AM To: pgadmin-support@postgresql.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
