PostgreSQL 8.0.3 + FreeBSD + TCP/IP
lane at cd-solutions.net
Tue Jun 14 21:30:32 GMT 2005
On Tuesday 14 June 2005 15:14, Joseph Koenig (jWeb) wrote:
> > On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote:
> >> Hi,
> >> I'm having a difficulty getting PostgreSQL to accept TCP/IP connections
> >> on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data
> >> directory to set the listen_address (and uncommented it) and have the
> >> port line uncommented and set to the default 5432. I then restarted the
> >> postmaster and tried to connect. I get:
> >> could not connect to server: Connection refused
> >> Is the server running on host "xx.xxx.xx.xxx" and accepting
> >> TCP/IP connections on port 5432?
> >> I can connect from localhost just fine.
> > You need to set listen_addresses, like it says in the comments:
> > listen_addresses = '*'
> > This will allow Postgresql connections from all interfaces.
> I have already tried setting the listen_addresses to * and the actual IP.
> Neither of which has worked. I restarted the postmaster both times using
> the script in /usr/local/etc/rc.d/, and by using pg_ctl. Even tried
> starting postmaster with pg_ctl -i. Nothing seems to be working. I have
> double-checked all of my pg_hba.conf settings, even though the error
> doesn't indicate that is the problem at all.
> Anyone else have any ideas at all? Thanks,
> Joe Koenig
> Production Manager
> jWeb New Media Design
> joe at jWebmedia.com
What do you get when you
telnet localhost 5432
telnet otherserver 5432
Try this to rule out any sort of firewall/tunnelling issues
If it "hangs" and you get no prompt, but drops after you type 2 or 3 letters
then it means postmaster is doing the negotiation (so then you check the
Otherwise you've got gnats in your firewall (or some other kind of bug) to
More information about the freebsd-questions