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

I neen help establishing a connection to my PostgreSQL database.

From
"Maurice Menefee"
Date:

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.

 

 

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

From
"Magnus Hagander"
Date:
You don't need to - it's enabled by default on Windows, since it has no support for unix sockets.
 
//Magnus


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Maurice Menefee
Sent: Monday, January 31, 2005 9:28 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] 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.

 

 

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

From
"Bender, Cheryl"
Date:

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.

 

Cheryl Bender


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Maurice Menefee
Sent: Monday, January 31, 2005 2:28 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] 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.