Remote access problem on UBUNTU Server 9.10 installation ?

This message was edited 1 time. Last update was at 3 Mar 2010 11:56:55

Hello,
the postgresql standard server 8.4 cant listen to 5432 by default port when this one was created ?
the error is : psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
my pg_hba.conf file:

postgresql.conf :

My iptables:

My server IP 192.168.144.22 and my client addresse is 192.168.144.18.
Is this the same problem reported on latest ubuntu distribution ?

https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/193696

Thank you in advance.

From your remote system, can you:

--Scottie

Hello,
It's blocked I can't access with telnet on port 5432.
My firewall allow access on port 5432 and telnet on port 23.

If you use:

It just connects to port 5432. All that does is see if the firewall is allowing connections from your client to the database server. If that works, then you know that there is an issue higher up on the stack. This is just verifying that you can connect.... almost like a 'ping' to the port.

--Scottie

This message was edited 2 times. Last update was at 3 Mar 2010 11:48:45

Hello,
So I am going to allow access in both client and server on port 5432.

the result is usually:

OKay, but you still haven't done the test I suggested. Until you test and VERIFY that the port is open, you don't know that it's working.

Hello scottiebo,
The connection is refused by telnet 192.168.144.22:5432
What can I do for that ?
Thank you an advance.