From owner-freebsd-questions@FreeBSD.ORG  Tue Jan 25 07:24:13 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id D98C716A4CE
	for <freebsd-questions@freebsd.org>;
	Tue, 25 Jan 2005 07:24:13 +0000 (GMT)
Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net
	[194.217.242.92])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6CE6A43D3F
	for <freebsd-questions@freebsd.org>;
	Tue, 25 Jan 2005 07:24:13 +0000 (GMT)
	(envelope-from timh@contentspace.demon.co.uk)
Received: from contentspace.demon.co.uk ([80.177.161.24])
	by anchor-post-34.mail.demon.net with esmtp (Exim 4.42)
	id 1CtL3c-000MMT-Dd
	for freebsd-questions@freebsd.org; Tue, 25 Jan 2005 07:24:12 +0000
From: Tim Hawkins <timh@contentspace.demon.co.uk>
Organization: Contentspace LLP
To: freebsd-questions@freebsd.org
Date: Tue, 25 Jan 2005 07:24:08 +0000
User-Agent: KMail/1.7.2
References: <41F719A2.8000004@cwazy.co.uk>
In-Reply-To: <41F719A2.8000004@cwazy.co.uk>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200501250724.08973.timh@contentspace.demon.co.uk>
Subject: Re: PostgreSQL TCP sockets access?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 25 Jan 2005 07:24:14 -0000

On Wednesday 26 Jan 2005 04:16, SigmaX wrote:
> Hey;
> I have a fairly fresh installation of FreeBSD 5.3 running PostGreSQL.  I
> enabled TCP socket connection in the
> /usr/local/pgsql/data/postgresql.conf file ("tcpip_socket = true"), and
> allowed all hosts in pg_hba.conf ("host all all 0.0.0.0 0.0.0.0
> trust")... but I still get a "connection refused" error when trying to
> access the server.
>        Any help?
>            SigmaX

Do you have the firewall installed, and if so have you opened up ports for 
your connections.