From maurice.menefee@briteskies.com Mon Jan 31 20:27:45 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9E6D08B9B7A for ; Mon, 31 Jan 2005 20:27:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53370-01 for ; Mon, 31 Jan 2005 20:27:40 +0000 (GMT) Received: from valiant.cnchost.com (valiant.concentric.net [207.155.252.9]) by svr1.postgresql.org (Postfix) with ESMTP id E41338B9B77 for ; Mon, 31 Jan 2005 20:27:40 +0000 (GMT) Received: from D9D3PS51 ([207.54.171.90]) by valiant.cnchost.com id PAA11628; Mon, 31 Jan 2005 15:27:40 -0500 (EST) [ConcentricHost SMTP Relay 1.17] Message-ID: <200501312027.PAA11628@valiant.cnchost.com> From: "Maurice Menefee" To: Subject: I neen help establishing a connection to my PostgreSQL database. Date: Mon, 31 Jan 2005 15:27:40 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C507A9.67485BF0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcUH00824gqUcAMfTt66DxJ7fWAp/w== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/2 X-Sequence-Number: 16170 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C507A9.67485BF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_0000_01C507A9.67485BF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.

 

 

------=_NextPart_000_0000_01C507A9.67485BF0-- From mha@sollentuna.net Tue Feb 1 10:12:49 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C87DF8B9CF7 for ; Tue, 1 Feb 2005 10:12:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46118-02 for ; Tue, 1 Feb 2005 10:12:37 +0000 (GMT) Received: from mx-2.sollentuna.net (mx-2.sollentuna.net [195.84.163.199]) by svr1.postgresql.org (Postfix) with ESMTP id 17C1E8B9B29 for ; Tue, 1 Feb 2005 10:12:38 +0000 (GMT) Received: from ALGOL.sollentuna.se (janus.sollentuna.se [62.65.68.67]) by mx-2.sollentuna.net (Postfix) with ESMTP id B1E498F286; Tue, 1 Feb 2005 11:12:37 +0100 (CET) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C50846.8D809493" Subject: Re: I neen help establishing a connection to my PostgreSQL database. Date: Tue, 1 Feb 2005 11:12:36 +0100 Message-ID: <6BCB9D8A16AC4241919521715F4D8BCE47675D@algol.sollentuna.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] I neen help establishing a connection to my PostgreSQL database. Thread-Index: AcUH00824gqUcAMfTt66DxJ7fWAp/wAcwQow From: "Magnus Hagander" To: "Maurice Menefee" , X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/4 X-Sequence-Number: 16172 This is a multi-part message in MIME format. ------_=_NextPart_001_01C50846.8D809493 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable You don't need to - it's enabled by default on Windows, since it has no support for unix sockets. =20 //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. =09 =09 Any help that you could give would be greatly appreciated. =20 I'm running PostgreSQL 8.0 on Windows 2003. =20 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" =20 I believe that this problem is due to the fact that postmaster was not ran with the -i option. =20 How do I run postmaster with the -i option on Windows 2003? =20 Thanks. =20 =20 ------_=_NextPart_001_01C50846.8D809493 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
You don't need to - it's enabled by default on = Windows,=20 since it has no support for unix sockets.
 
//Magnus


From: = pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Maurice=20 Menefee
Sent: Monday, January 31, 2005 9:28 PM
To: = pgsql-admin@postgresql.org
Subject: [ADMIN] I neen help = establishing=20 a connection to my PostgreSQL database.

Any help that you could = give would=20 be greatly appreciated.

 

I’m running = PostgreSQL 8.0 on=20 Windows 2003.

 

When I attempt to = connect to the=20 database using Access and ODBC from a Windows 2000 host I=20 get:

           = =20 “Could not connect to remote = socket”

 

I believe that this = problem is due=20 to the fact that postmaster was not ran with the –i=20 option.

 

How do I run postmaster = with the=20 -i option on Windows 2003?

 

 Thanks.

 

 

------_=_NextPart_001_01C50846.8D809493-- From cbender@mriresearch.org Wed Feb 2 00:20:32 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C17FD8B9B64 for ; Wed, 2 Feb 2005 00:20:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29073-09 for ; Wed, 2 Feb 2005 00:20:27 +0000 (GMT) Received: from mail.mriresearch.org (mail.sceptorindustries.com [204.56.4.159]) by svr1.postgresql.org (Postfix) with ESMTP id C411A8B9B53 for ; Wed, 2 Feb 2005 00:20:28 +0000 (GMT) Received: from exch2000.mri-kc.int [10.16.4.49] by mail.mriresearch.org with ESMTP (SMTPD32-8.14) id AA012FEE008A; Tue, 01 Feb 2005 18:08:33 -0600 Received: from EXCHtemp.mri-kc.int ([10.16.4.58]) by exch2000.mri-kc.int with Microsoft SMTPSVC(5.0.2195.6713); Tue, 1 Feb 2005 18:20:24 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C508BC.FD452B30" Subject: Re: I neen help establishing a connection to my PostgreSQL database. Date: Tue, 1 Feb 2005 18:20:24 -0600 Message-ID: <12A8E91E9D5E804DA82CA5199BC4C56211ED7F@exchtemp.mri-kc.int> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] I neen help establishing a connection to my PostgreSQL database. Thread-Index: AcUH00824gqUcAMfTt66DxJ7fWAp/wA6HaCw From: "Bender, Cheryl" To: "Maurice Menefee" , X-OriginalArrivalTime: 02 Feb 2005 00:20:24.0840 (UTC) FILETIME=[FD6A4080:01C508BC] X-Declude-Sender: cbender@mriresearch.org [10.16.4.49] X-Declude-Spoolname: D1a012fee008a25f8.SMD X-Spam-Tests-Failed: HELOBOGUS, SPAMHEADERS [3] X-Note: This E-mail was scanned by DGEORGE using Declude. X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/10 X-Sequence-Number: 16178 This is a multi-part message in MIME format. ------_=_NextPart_001_01C508BC.FD452B30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable By default the postmaster in Windows listens for TCP/IP connections only on the loopback interface. =20 =20 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: =20 listen_addresses =3D '*' # what IP interface(s) to listen on;=20 # defaults to localhost, '*' =3D any =20 I suspect when you try to connect via ODBC it is not using 'Localhost' even if it is on the same machine.=20 =20 Cheryl Bender _____ =20 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. =20 Any help that you could give would be greatly appreciated. =20 I'm running PostgreSQL 8.0 on Windows 2003. =20 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" =20 I believe that this problem is due to the fact that postmaster was not ran with the -i option. =20 How do I run postmaster with the -i option on Windows 2003? =20 Thanks. =20 =20 ------_=_NextPart_001_01C508BC.FD452B30 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D = '*'     # what IP interface(s) to listen on;

      =             &= nbsp;           &n= bsp;           &nb= sp;     # defaults to localhost, '*' =3D 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.

 

 

------_=_NextPart_001_01C508BC.FD452B30--