Re: can't connect to postmaster from other machine - Mailing list pgsql-novice

From FOlkeN
Subject Re: can't connect to postmaster from other machine
Date
Msg-id 0A96170D-1BDB-11D6-98CD-003065BDA84A@mac.com
Whole thread Raw
In response to Re: can't connect to postmaster from other machine  (Walter Hop <walter@binity.com>)
List pgsql-novice
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@cs.helsinki.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@binity.com>
>  Updated contact information: http://www.binity.com/~walter/


pgsql-novice by date:

Previous
From: Rob
Date:
Subject: Cursors in PL/pgSQL
Next
From: Frank Bax
Date:
Subject: Re: COPY FROM function