Postgres Pro
Downloads
Home   >   mailing lists

Thread: Socket error - Could not connect to PostgreSQL server

Socket error - Could not connect to PostgreSQL server

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'.
 
Please help me!!
 
Thanks in Advance
Bhaskar

Re: Socket error - Could not connect to PostgreSQL server

From
Joshua Marsh
Date:


On 11/14/05, bhaskar <bhaskar.sarma@blr.corpus.com> wrote:
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.


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.