postgresql dblink not working in FC5
Gordon Messmer
yinyang at eburg.com
Thu Apr 20 19:39:31 UTC 2006
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
More information about the users
mailing list