"Manish Gupta" <ml_gupta@xxxxxxxxxxx> 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
