postgresql dblink not working in FC5

Recently, I upgraded one of my servers to FC5 from FC4. This upgrade also upgraded postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get dblink to work in postgresql. I created two fresh databases and tried... still no luck. I keep getting the following error:

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?

My pg_hba.conf is as follows:
----------------------
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 password
host all all 192.168.0.0/24 password
host all all 10.1.2.0/24 password

# IPv6 local connections:
host all all ::1/128 sameuser
--------------------

The error seems to be like client authentication error. I researched and found that the message "could not establish connection" seems to defined in dblink.c, and it gets triggred when it is unable to create connection to the database. I though this may be happening because libpq is not working properly. So, I compiled a simple program, written in C, that uses libpq and it seems to work fine.

I have kind of hit the roadblock. Any help would be appreciated.

Thanks

Manish


"An informed citizenry is the bulwark of a democracy"
http://www.SUNITI.org : Self-governance for an informed citizen


--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Relevant Pages

  • Re: XP Pro workstations are disconnect for 2003 server
    ... Since the upgrade 2 of the 5 PC's are ... They drop their connection to the ... server after several hours off no activity. ... I also believe there is a net command you can try on the workstation, ...
    (microsoft.public.windows.server.sbs)
  • Re: ES2003 from Exchange 5.5
    ... You need to upgrade your domain to Win2003 before starting your ... > and powerful servers that came with Windows Server 2003 pre-installed. ... > I've also read a lot about problems with LDAP ports and connection ... > connection agreements, and do I have to revert back to the default ...
    (microsoft.public.exchange.setup)
  • Re: internet connection
    ... >Can you ping your DNS server? ... IE worked fine before the upgrade and now, ... We have a DSL connection. ... >> a proxy server? ...
    (microsoft.public.win2000.networking)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)