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 <[EMAIL PROTECTED]> ---------------------------------------------------------------------- When all else fails, RTFM _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"