Re: dblink not working in FC5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Manish Gupta" <ml_gupta(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: dblink not working in FC5
Date: 2006-04-19 23:35:44
Message-ID: 5135.1145489744@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Manish Gupta" <ml_gupta(at)hotmail(dot)com> writes:
> 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?

"Permission denied" seems a bit odd here. Just as a wild guess: do you
have SELinux running in enforcement mode, and if so, does switching it
to permissive mode make this work? (See /usr/sbin/getenforce and
setenforce) Another thing to try is a non-TCP connection, ie, leave out
the hostaddr bit.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Manish Gupta 2006-04-19 23:40:19 Re: dblink not working in FC5 (Solved)
Previous Message Thomas F. O'Connell 2006-04-19 22:31:14 Re: Invalid Page Headers