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" <ml_gupta@hotmail.com> 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