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'.
2. In pg_hba.config i have added my machines IP address.
3. In postgresql.conf file changed tcpip_socket=true.
Did you restart the PostgreSQL server or reload it? can you post your postgresql.conf file? There could be hundreds of things that prevent this, include many that have nothing to do with PostgreSQL itself.