postgresql dblink not working in FC5

[Gordon Messmer]

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