pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I 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