August 4th, 2003, 12:10 PM
I installed PostgreSQL 7.3.4 on red Hat Linux 8.0.
I mounted clusters and started database server using initdb and pg_ctl tools. Everything looks fine, following message appears.
postmaster successfully started.
Whem I try to access database server using psql tool, following error occurs:
could not connect to server: Connection refused.
Is the server running on host xxx.xx.xx.xx and accepting TCP/IP connections on port 5432?
I don't know what could be happening?
I appreciate some help
August 4th, 2003, 12:57 PM
What's the exact command you type at the prompt for psql?
Also, just some prelims to check:
1)Do a ps -aux | grep postgres to make sure postmaster is running
2)Check your postgres.conf to see if you're enabling access through tcp. Port 5432 should be the default PG port so unless you've changed that you shouldn't need to mess with it.
3)Check to make sure if you have a firewall setup that you're not blocking port 5432.
PostgreSQL, it's what's for dinner...
August 4th, 2003, 01:18 PM
or mayby try to connect to postgres trought unix socket (local).