Re: connect to database over network - Mailing list pgsql-novice

From Tom Lane
Subject Re: connect to database over network
Date
Msg-id 5384.1049997389@sss.pgh.pa.us
Whole thread Raw
In response to connect to database over network  (aa nn <bmewang@yahoo.com>)
List pgsql-novice
aa nn <bmewang@yahoo.com> writes:
> psql: could not connect to server: Connection reset by peer (0x00002746/10054)
>         Is the server running on host synapse.xxx.xxx.xxx and accepting
>         TCP/IP connections on port 5432?

> The thing is that I started the postermaster with -i option and I already added my client PC's IP to the pg_hba.conf.

"Connection reset by peer" sounds more like a kernel-level rejection,
anyway.  Perhaps you should check the packet filtering setup on the
Linux box to see if traffic to/from port 5432 is allowed in and out.
(At least in recent RHL releases, the default filtering setup doesn't
allow such traffic.)

            regards, tom lane


pgsql-novice by date:

Previous
From: aa nn
Date:
Subject: connect to database over network
Next
From: Doug Silver
Date:
Subject: Data types mapping