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.
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Maurice Menefee
Sent: Monday, January 31, 2005 2:28 PM
Subject: [ADMIN] I neen help establishing a connection to my PostgreSQL
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?
pgsql-admin by date
|Next:||From: Dave Vieglais||Date: 2005-02-02 00:42:59|
|Subject: client authentication problem|
|Previous:||From: Pallav Kalva||Date: 2005-02-01 19:47:40|
|Subject: Re: Online Backup and WAL archives|