X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C5D5611F8C67 for ; Mon, 24 Apr 2006 15:14:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 50268-03 for ; Mon, 24 Apr 2006 15:14:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hotmail.com (bay101-f34.bay101.hotmail.com [64.4.56.44]) by postgresql.org (Postfix) with ESMTP id 5011311F8FF8 for ; Mon, 24 Apr 2006 11:18:48 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 24 Apr 2006 07:18:48 -0700 Message-ID: Received: from 64.4.56.200 by by101fd.bay101.hotmail.msn.com with HTTP; Mon, 24 Apr 2006 14:18:47 GMT X-Originating-IP: [68.100.190.181] X-Originating-Email: [ml_gupta@hotmail.com] X-Sender: ml_gupta@hotmail.com In-Reply-To: <5237.1145490343@sss.pgh.pa.us> From: "Manish Gupta" To: tgl@sss.pgh.pa.us Cc: pgsql-admin@postgresql.org Subject: Re: dblink not working in FC5 (Solved) Date: Mon, 24 Apr 2006 10:18:47 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 24 Apr 2006 14:18:48.0892 (UTC) FILETIME=[0133EFC0:01C667AA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/242 X-Sequence-Number: 21411 Hello Tom, I have filed a bug (# 189764) with fedoraproject. I tried with unix sockets with same results. So, for the time being disabling SELinux seems to be the only solution. Thanks for all the help. Manish > >"Manish Gupta" writes: > > I was able to solve this issue by disabling SELinux. > > Still, there has got to be a way to use dblink with SELinux. > >Please file a bugzilla entry at bugzilla.redhat.com against the >selinux-policy-targeted component (or whichever policy you're using) >(NOT against postgresql, else I'll just have to relabel it ...) > >Also, did you try a non-TCP connection? > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match