From: Kenneth Jacker <khj@cs.appstate.edu>
To: pgsql-interfaces@hub.org
Subject: 'pgaccess' - Can't Connect to Backend
Date: 03 Jan 1999 08:51:20 -0500
Message-ID: <eyanka2hz.fsf@beagle.cs.appstate.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: khj@cs.appstate.edu, pgsql-interfaces@hub.org
Subject: Re: 'pgaccess' - Can't Connect to Backend
In-Reply-To: <eyanka2hz.fsf@beagle.cs.appstate.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox