Received: from alb.stockgroup.com (cr735483-a.crdva1.bc.wave.home.com [24.113.103.148]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA25276 for ; Wed, 15 Sep 1999 01:48:56 -0400 (EDT) (envelope-from adrian@stockgroup.com) Received: from stockgroup.com (localhost [127.0.0.1]) by alb.stockgroup.com (8.9.3/8.9.3) with ESMTP id WAA02636 for ; Tue, 14 Sep 1999 22:41:29 -0700 Sender: root@alb.stockgroup.com Message-ID: <37DF3183.B585FE70@stockgroup.com> Date: Tue, 14 Sep 1999 22:41:24 -0700 From: Adrian Alb X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Re: remote database connection References: <199909150300.XAA04368@hub.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > Date: Mon, 13 Sep 1999 20:14:04 -0700 > From: "Eid, Bilal" > Subject: remote database connection > > Hi every one, > > Any help will be appreciated, > > I'm running PosygreSQL 6.4 (that come on the Redhat Linux 6.0 CD) and iodbc > 2.5. > I developed an application to access the database through iodbc; every thing > was fine regarding the database and its applications. > > I tried to trace the error and I got these: > Could not connect to server; > Could not connect to remote socket; > This could be the reason: you are not starting postmaster with -i option or postmaster is listening to a different port than you have specified in your DSN. You can check the postmaster's port by doing: ls -la /tmp/.*PGSQL* and the result should be like: srwxrwxrwx 1 postgres postgres /tmp/.s.PGSQL.5432 where 5432 is the port number (or whatever port you're using). Change your DSN to match this port. If ls result is "no such file ..." you probably didn't start postmaster with -i. Adrian Alb UNIX Sys Admin StockGroup.COM