Re: connect to database over network

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: aa nn <bmewang(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: connect to database over network
Date: 2003-04-10 17:56:29
Message-ID: 5384.1049997389@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

aa nn <bmewang(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tim Ellis 2003-04-10 18:13:05 Re: PLEASE HELP ME URGENT about choosing only the ones
Previous Message Doug Silver 2003-04-10 17:56:18 Data types mapping