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
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 |