Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0ODLP099329 for ; Wed, 24 Jan 2001 08:21:25 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from resu1.ulb.ac.be (resu1.ulb.ac.be [164.15.59.200]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OC6P092691 for ; Wed, 24 Jan 2001 07:06:25 -0500 (EST) (envelope-from mlennert@ulb.ac.be) Received: from mach.vub.ac.be (mach.ulb.ac.be [164.15.128.3]) by resu1.ulb.ac.be (8.8.8/3.17.0.ap (resu)) id NAA15058; Wed, 24 Jan 2001 13:02:16 +0100 (MET) for From: mlennert@ulb.ac.be Received: from paf-linux.ulb.ac.be (geog-pc30.ulb.ac.be [164.15.134.94]) by mach.vub.ac.be (8.9.3/3.13.2.ap (mach)) id NAA28273; Wed, 24 Jan 2001 13:06:11 +0100 (MET) for Received: from localhost ([127.0.0.1] helo=paf-linux.ulb.ac.be ident=mlennert) by paf-linux.ulb.ac.be with esmtp (Exim 3.20 #1 (Debian)) id 14LOkH-0000d5-00 for ; Wed, 24 Jan 2001 13:09:49 +0100 X-Mailer: exmh version 2.2 06/23/2000 (debian 2.2-1) with nmh-1.0.4+dev To: pgsql-interfaces@postgresql.org Subject: problems connecting to postgresql with unixodbc Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Wed, 24 Jan 2001 13:09:49 +0100 Message-Id: X-Archive-Number: 200101/275 X-Sequence-Number: 893 Hello, I'm running postgresql 7.0.3-4, on debian unstable, and I have trouble connecting to databases via odbc. I use unixodbc 2.0.3-1, and I can see the data source in the DataManager, but when I try to connect I get the following error: '[unixODBC]Could not connect to the server; Could not connect to remote socket.' People have suggested to me that the problem might be that the postmaster was not started with the -i option. I verified the postmaster.init file and PGALLOWTCPIP=yes is set. My pg_hba.conf file reads: local all password host all 127.0.0.1 255.255.255.255 password Can someone help me ? Moritz