Date: Wed, 15 Jun 2005 07:24:14 +1200 From: Jonathan Chen <jonc@chen.org.nz> To: "Joseph Koenig (jWeb)" <joe@jwebmedia.com> Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP Message-ID: <20050614192414.GB84823@osiris.chen.org.nz> In-Reply-To: <BED45C51.1F46E%joe@jwebmedia.com> References: <BED45C51.1F46E%joe@jwebmedia.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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. -- Jonathan Chen <jonc@chen.org.nz> ---------------------------------------------------------------------- When all else fails, RTFM
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050614192414.GB84823>