I'm trying to connect to a remote psql database. Before I added the pg_hba.conf entry with the client's IP address, I was getting an error message :
xdev@xdevbox:~$ psql -U postgres testdb -h 10.1.1.47
psql: FATAL: no pg_hba.conf entry for host "10.201.50.71", user "postgres", database "testdb", SSL off
I added the client's IP with trust settings. I also changed the listen address in postgres.conf on the server to listen to "*".
Then I restarted the database server using /etc/init.d/postgresql restart command.
Now when I try to connect, I get the following error message:
psql: could not connect to server: Connection refused
Is the server running on host "10.1.1.47" and accepting
TCP/IP connections on port 5432?
in postgresql.conf, the port is set to 5432.
I'm not sure what else to check.
Thanks
Best Answer
You have to configure the following two files
pg_hba.conf
postgresql.conf
You have to check if the port 5432 is open: http://www.yougetsignal.com/tools/open-ports/
If it's not then add a rule to your
iptables
:0/0: If you want anybody to access it. You can change it to a specific IP address or range of IP addresses.