'pgaccess' - Can't Connect to Backend
От | Kenneth Jacker |
---|---|
Тема | 'pgaccess' - Can't Connect to Backend |
Дата | |
Msg-id | eyanka2hz.fsf@beagle.cs.appstate.edu обсуждение исходный текст |
Ответы |
Re: [INTERFACES] 'pgaccess' - Can't Connect to Backend
|
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: