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

[Bender, Cheryl]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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.