Re: can't connect to postmaster from other machine

I've looked at postgresql.conf and "tcpip_socket" is set to true...

I get the same message when I try to connect with: psql -h 127.0.0.1

El jueves, 7 febrero, 2002, a las 01:58 , Walter Hop escribió:"

> [in reply to ekarttun(at)cs(dot)helsinki(dot)fi, 07/02/2002]
>
>>> psql: PQconnectPoll() -- connect() failed: Operation timed out
>>> Is the postmaster running (with -i) at '192.168.0.21'
>>> and accepting connections on TCP/IP port 5432?
>
> Hmmmm... at second thought, I think the "Operation timed out" might be due
> to firewall rules instead (probably on the server box)?
>
> A missing entry in pg_hba.conf gives this error:
>
> psql: No pg_hba.conf entry for host 1.2.3.4, user walter, database
> walter
>
> And a postmaster that doesn't listen to the TCP port gives:
>
> psql: connectDBStart() -- connect() failed: Connection refused
>
> This on the other hand is a "Operation timed out". FOlkeN, do you perhaps
> have firewall rules in place on the server box? What happens if you use
> psql from the server box to itself via TCP, using ``psql -h 127.0.0.1''?
>
> --
> Walter Hop <walter(at)binity(dot)com>
> Updated contact information: http://www.binity.com/~walter/