From: | "Bender, Cheryl" <cbender(at)mriresearch(dot)org> |
---|---|
To: | "Maurice Menefee" <maurice(dot)menefee(at)briteskies(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: I neen help establishing a connection to my PostgreSQL database. |
Date: | 2005-02-02 00:20:24 |
Message-ID: | 12A8E91E9D5E804DA82CA5199BC4C56211ED7F@exchtemp.mri-kc.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Maurice Menefee
Sent: Monday, January 31, 2005 2:28 PM
To: pgsql-admin(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Vieglais | 2005-02-02 00:42:59 | client authentication problem |
Previous Message | Pallav Kalva | 2005-02-01 19:47:40 | Re: Online Backup and WAL archives |