Thread: Socket error - Could not connect to PostgreSQL serve

Socket error - Could not connect to PostgreSQL serve

From
"bhaskar"
Date:
 Hi,
        I have installed PostgreSQL 7.4.8 in Linux machine. I have tried to connect my PostgreSql Database using a client application (SQL Server 2000 - DTS). I have done the followings:
 
1.Used psqlODBC for ODBC provider
2. In pg_hba.config i have added my machines IP address.
3. In postgresql.conf file changed tcpip_socket=true.
 
Still I am getting the error like 'Could not Connect to Server; Could not Connect to remote socket'.
Not sure whether it's installation error or something else.
 
Please help me!!
 
Thanks in Advance