pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedI neen help establishing a connection to my PostgreSQL database.
3+ messages / 3 participants
[nested] [flat]
* I neen help establishing a connection to my PostgreSQL database.
@ 2005-01-31 20:27 Maurice Menefee <maurice.menefee@briteskies.com>
0 siblings, 0 replies; 3+ messages in thread
From: Maurice Menefee @ 2005-01-31 20:27 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: I neen help establishing a connection to my PostgreSQL database.
@ 2005-02-01 10:12 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 3+ messages in thread
From: Magnus Hagander @ 2005-02-01 10:12 UTC (permalink / raw)
To: Maurice Menefee <maurice.menefee@briteskies.com>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: I neen help establishing a connection to my PostgreSQL database.
@ 2005-02-02 00:20 Bender, Cheryl <cbender@mriresearch.org>
0 siblings, 0 replies; 3+ messages in thread
From: Bender, Cheryl @ 2005-02-02 00:20 UTC (permalink / raw)
To: Maurice Menefee <maurice.menefee@briteskies.com>; 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@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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-02 00:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-31 20:27 I neen help establishing a connection to my PostgreSQL database. Maurice Menefee <maurice.menefee@briteskies.com>
2005-02-01 10:12 Re: I neen help establishing a connection to my PostgreSQL database. Magnus Hagander <mha@sollentuna.net>
2005-02-02 00:20 Re: I neen help establishing a connection to my PostgreSQL database. Bender, Cheryl <cbender@mriresearch.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox