Thread: I neen help establishing a connection to my PostgreSQL database.

Any help that you could give would be greatly appreciated.

I’m running PostgreSQL 8.0 on Windows 2003.

When I attempt to connect to the database using Access and ODBC from a Windows 2000 host I get:

            “Could not connect to remote socket”

I believe that this problem is due to the fact that postmaster was not ran with the –i option.

How do I run postmaster with the -i option on Windows 2003?

 Thanks.

By default the postmaster in Windows listens for TCP/IP connections only on the loopback interface.  

Take a look at your conf files (postgresql.conf and pg_hba.conf).  Postgresql.conf probably needs to have a line added something like this:

listen_addresses = '*'     # what IP interface(s) to listen on;

                                                # defaults to localhost, '*' = any

I suspect when you try to connect via ODBC it is not using ‘Localhost’ even if it is on the same machine.

Any help that you could give would be greatly appreciated.

I’m running PostgreSQL 8.0 on Windows 2003.

When I attempt to connect to the database using Access and ODBC from a Windows 2000 host I get:

            “Could not connect to remote socket”

I believe that this problem is due to the fact that postmaster was not ran with the –i option.

How do I run postmaster with the -i option on Windows 2003?

 Thanks.