Re: postgresql dblink not working in FC5
- From: Gordon Messmer <yinyang@xxxxxxxxx>
- Date: Thu, 20 Apr 2006 12:39:31 -0700
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
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
- Follow-Ups:
- postgres TCP Connection [WAS Re: postgresql dblink not working in FC5]
- From: Mauricio Vergara Ereche
- postgres TCP Connection [WAS Re: postgresql dblink not working in FC5]
- References:
- postgresql dblink not working in FC5
- From: Manish Gupta
- postgresql dblink not working in FC5
- Prev by Date: pam_mount and gdm
- Next by Date: Re: CANNOT Get Remote X to Work -- Guru Needed
- Previous by thread: postgresql dblink not working in FC5
- Next by thread: postgres TCP Connection [WAS Re: postgresql dblink not working in FC5]
- Index(es):
Relevant Pages
|
