Manish Gupta wrote:
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?
So... is postmaster listening on the TCP port? It would need to be, if you're specifying 'hostaddr'.
Use 'netstat -tlnp' to see if port 5432 is open. If not, you'll need to configure Postgres to listen on a TCP socket. You can either specify "PGOPTS=-i" in /etc/sysconfig/pgsql/postgresql, or "tcpip_socket = true" in /var/lib/pgsql/data/postgresql.conf
