PostgreSQL 8.0.3 + FreeBSD + TCP/IP
Jonathan Chen
jonc at chen.org.nz
Tue Jun 14 19:24:17 GMT 2005
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 at chen.org.nz>
----------------------------------------------------------------------
When all else fails, RTFM
More information about the freebsd-questions
mailing list