Red Hat Bugzilla – Bug 147547
cannot connect to a server - localhost port 5432
Last modified: 2007-11-30 17:11:00 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5)
Description of problem:
When trying to connect to a server via file -> add server, I get an
error stating the below response.
An Error occurred:
Is the host running on 127.0.0.1 and accepting TCP/IP connections on
I tried with adding port 5432 to the firewall rules, stopping iptables
and disabling selinux, none of the changes improved the situation.
I am able to createdb <database> and to psql <database> with success.
I cannot connect through this program though. The same user is
selected where there is an actual database.
I tried this on another computer and had the sam results as indicated
Version-Release number of selected component (if applicable):
pgadmin3-1.0.2-3, postgresql-7.4.7-1.FC3.2, wxGTK2-2.4.2-7,
Steps to Reproduce:
1. Start pgadmin3
2. try to connect to server
3. get error as described above
Actual Results: most menu choices were blank, no servers identified
in right pane. Could not connect to an existing databae or postgres
server in general. I could create or manipulate the database thrugh a
Expected Results: Expected to be able to connect to the server and
work with or create database and be able to change the properties of
This is the first time that I have tried this program out. I have used
rhdb before with moderate success. The system defaults are the
configuration settings, only a user and database created by the user
Created attachment 110845 [details]
this is the ~/pgadmin.log
In case this shows errors as to wgy I cannot connect to the server, here it is!
Created attachment 110847 [details]
could not edit logging level with program tool .pgadmin3
Using the GUI menu choice, I could not change my logging level to allow
debugging mode to log. I was able to change the entry with an editor. The
problem is that you select the debugging button on the GUI program. When you
click on the OK button, nothing happens.
Created attachment 110850 [details]
After enabling debugging logging -pgadmin.log
After manually changing the logging options with a test editor, I tried to
connect to the server, then change the logging options. This is the logging
with debugging enbled.
Strange enough, the button selection and pressing OK works now, after the
manual entry change.
Referencing this message, the problem is related to TCP/IP socets being set to
false in reference to the message listed below.
The program seems to react as postgresql does now when trying to use tcp/ip.
You also need to edit pg_hba.conf file to add 127.0.0.1 or your specific IP
address and netmask.
The program is working now, but not initially.
A helpful solution would be to change the error message to point to checking if
postgresql.conf has tcpip_socket set to = true. and you have a pg_hda.conf file
allowing your localhost or IP address information set.
[package owner's e-mail address gives 550 user unknown - reassigning to