Received: from beagle.cs.appstate.edu (beagle.cs.appstate.edu [152.10.40.6]) by hub.org (8.9.1/8.9.1) with ESMTP id IAA05742 for ; Sun, 3 Jan 1999 08:50:01 -0500 (EST) (envelope-from khj@beagle.cs.appstate.edu) Received: (from khj@localhost) by beagle.cs.appstate.edu (8.9.1/8.9.1) id IAA11647; Sun, 3 Jan 1999 08:51:20 -0500 (EST) Sender: khj@beagle.cs.appstate.edu To: pgsql-interfaces@hub.org Subject: 'pgaccess' - Can't Connect to Backend Reply-To: khj@cs.appstate.edu From: Kenneth Jacker Date: 03 Jan 1999 08:51:20 -0500 Message-ID: Lines: 45 X-Mailer: Gnus v5.6.44/Emacs 20.2 Configuration ------------- MkLinux postgresql-6.3.2 pgaccess-{0.86,0.91,0.93} Problem ------- I can connect to the backend via 'psql' but not 'pgaccess'. Both 'pgaccess' and 'postgreSQL' are running on the same machine. Pgaccess gives the message: Error connecting database Connection to database failed connectDB() failed: Is the postmaster running and accepting TCP/IP (with -i) connections at 'localhost' on port '5432'? Observations ------------ Here's the relevant process info (in particular, note the '-i' option): /usr/bin/postmaster -i -S -D/var/lib/pgsql /usr/bin/postgres -p -Q -P5 -v 65536 collection Also, the following 'netstat' output (corresponding to the 'psql' connection) shows that port '5432' is, in fact, being used: Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 2 cs:3123 localhost:5432 CLOSE I've used 'pgaccess' successfully before, but I must have changed something (permissions, etc.) during an OS upgrade. Any help will be appreciated! -Prof Kenneth H Jacker khj@cs.appstate.edu -Computer Science Dept www.cs.appstate.edu/~khj -Appalachian State Univ -Boone, NC 28608 USA