From owner-freebsd-questions@FreeBSD.ORG  Fri Sep  9 19:09:24 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: 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 EBB5716A41F
	for <freebsd-questions@freebsd.org>;
	Fri,  9 Sep 2005 19:09:24 +0000 (GMT) (envelope-from stanb@panix.com)
Received: from mail2.panix.com (mail2.panix.com [166.84.1.73])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9380F43D53
	for <freebsd-questions@freebsd.org>;
	Fri,  9 Sep 2005 19:09:24 +0000 (GMT) (envelope-from stanb@panix.com)
Received: from mailspool2.panix.com (mailspool2.panix.com [166.84.1.79])
	by mail2.panix.com (Postfix) with ESMTP id 07DAD9E0C2
	for <freebsd-questions@freebsd.org>;
	Fri,  9 Sep 2005 15:09:24 -0400 (EDT)
Received: from teddy.fas.com (pcp08632294pcs.mplsnt01.sc.comcast.net
	[68.58.232.106])
	by mailspool2.panix.com (Postfix) with ESMTP id 0D7F127F36E
	for <freebsd-questions@freebsd.org>;
	Fri,  9 Sep 2005 15:09:24 -0400 (EDT)
Received: from stan by teddy.fas.com with local (Exim 3.36 #1 (Debian))
	id 1EDoFX-0003jF-00
	for <freebsd-questions@freebsd.org>; Fri, 09 Sep 2005 15:09:23 -0400
Date: Fri, 9 Sep 2005 15:09:23 -0400
From: stan <stanb@panix.com>
To: Free BSD Questions list <freebsd-questions@freebsd.org>
Message-ID: <20050909190923.GA14167@teddy.fas.com>
Mail-Followup-To: Free BSD Questions list <freebsd-questions@freebsd.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-Editor: gVim
X-Operating-System: Debian GNU/Linux
X-Kernel-Version: 2.4.23
X-Uptime: 15:04:11 up 27 days, 18:37, 1 user, load average: 0.14, 0.07, 0.04
User-Agent: Mutt/1.5.4i
Sender: Stan Brown <stanb@panix.com>
Subject: Can't access db with pgaccess
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
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: Fri, 09 Sep 2005 19:09:25 -0000

I'm install postgress V7 on a 5..4-STABLE machine. I;ve installed it from
ports, and I've added myself as a user, and created a database. I can
access this database using "psql dbname" and all works fine.

I can't seem to get pgaccess to connect at all. I;ve checked and sockstat
reports:

pgsql    postgres   485   3  stream /tmp/.s.PGSQL.5432

What am I doing wrong?

-- 
U.S. Encouraged by Vietnam Vote - Officials Cite 83% Turnout Despite Vietcong Terror 
- New York Times 9/3/1967