"Manish Gupta" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq