X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 65D4111F68E5 for ; Wed, 19 Apr 2006 19:27:17 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[MSGID_FROM_MTA_HEADER=0] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id zNYHiOQ8Q2kZ for ; Wed, 19 Apr 2006 19:26:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1EB8011F68D1 for ; Wed, 19 Apr 2006 19:26:52 -0300 (ADT) Received: from hotmail.com (bay101-f20.bay101.hotmail.com [64.4.56.30]) by svr4.postgresql.org (Postfix) with ESMTP id 487265AF979 for ; Wed, 19 Apr 2006 22:26:53 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 19 Apr 2006 15:26:48 -0700 Message-ID: Received: from 64.4.56.200 by by101fd.bay101.hotmail.msn.com with HTTP; Wed, 19 Apr 2006 22:26:48 GMT X-Originating-IP: [68.100.190.181] X-Originating-Email: [ml_gupta@hotmail.com] X-Sender: ml_gupta@hotmail.com From: "Manish Gupta" To: pgsql-admin@postgresql.org Subject: dblink not working in FC5 Date: Wed, 19 Apr 2006 18:26:48 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 19 Apr 2006 22:26:48.0684 (UTC) FILETIME=[5940E2C0:01C66400] X-Archive-Number: 200604/189 X-Sequence-Number: 21358 Recently, I upgraded one of my server from FC4 to FC5. This also upgraded postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get dblink to work in this version of postgresql. I created two fresh databases and tried... still no luck. I keep getting the following error: bulbulbo=# select dblink_connect('hostaddr=127.0.0.1 dbname=bulbulfo user=bulbul password=password'); ERROR: could not establish connection DETAIL: could not connect to server: Permission denied Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? bulbulbo=# select dblink_connect('dbname=bulbulfo user=bulbul'); ERROR: could not establish connection DETAIL: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? My pg_hba.conf is as follows: ---------------------- local all all trust # IPv4 local connections: host all all 127.0.0.1/32 password host all all 192.168.0.0/24 password host all all 10.1.2.0/24 password # IPv6 local connections: host all all ::1/128 sameuser -------------------- The error seems to be client authentication error. I researched and found that the message "could not establish connection" seems to coming from dblink.c (inside contrib/dblink), and it gets triggred when it is unable to create connection to the database. I though that this may be happening because libpq is not working properly. So, I compiled a simple program, written in C, that uses libpq and that program works fine. I have kind of hit the roadblock. Any help would be appreciated. Thanks Manish "An informed citizenry is the bulwark of a democracy" http://www.SUNITI.org : Self-governance for an informed citizen