I finally managed to type the right thing into google to tip me off onto what my poblem was. Apparently 7.4 defaults to not accept TCP socket connection. :-P. Just changed that little line at the top of my postgresql.conf file and I'm good to go. Took me all of 30 seconds.
Tootles one and all,
SigmaX
On 1/15/06, Eric Scott <[EMAIL PROTECTED]> wrote:
Yo; Got a new server (testing) setup. While I was reinstalling my server I made the move from sarge to etch... not sure if that's what cause this or not.
My PostgreSQL-7.4 is acting up. I'm pretty much a novice at all this, and don't know where to start to trouble shoot. The service is running, and webmin/pgsql, however they access it, administer it fine. However when I try to access it via a TCP connection (Yes, port 5432 is open in my firewall; I've tried accessing it with an ASP web service and pgaccess to no avail), I get "connection refused." It's pretty much the stock installation, from "apt-get install postgresql"; I've done nothing to it that I remember 'cept restore a database backup and edit user accounts. "netstat -a | grep tcp" doesn't seem to show it listening, though it may run under xinetd or something by default, I don't know.
Any help would be greatly appreciated.
Cheerio,
SigmaX
--
My home page: http://www.SigmaX.cjb.net
"ttocs laeno cire oshkosh b'gosh fyedernoggersnodden nicht stein bon probiscus"
"Education is what remains after one has forgotten everything he learned in school"
-- Albert Einstein
--
My home page: http://www.SigmaX.cjb.net
"ttocs laeno cire oshkosh b'gosh fyedernoggersnodden nicht stein bon probiscus"
"Education is what remains after one has forgotten everything he learned in school"
-- Albert Einstein