Re: dblink not working in FC5 (Solved)
От | Manish Gupta |
---|---|
Тема | Re: dblink not working in FC5 (Solved) |
Дата | |
Msg-id | BAY101-F24454BC566A92A297EAEDEE6C50@phx.gbl обсуждение исходный текст |
Ответ на | dblink not working in FC5 ("Manish Gupta" <ml_gupta@hotmail.com>) |
Ответы |
Re: dblink not working in FC5 (Solved)
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-admin |
I was able to solve this issue by disabling SELinux. Still, there has got to be a way to use dblink with SELinux. Thanks Manish "An informed citizenry is the bulwark of a democracy" http://www.SUNITI.org : Self-governance for an informed citizen >From: "Manish Gupta" <ml_gupta@hotmail.com> >To: pgsql-admin@postgresql.org >Subject: [ADMIN] dblink not working in FC5 >Date: Wed, 19 Apr 2006 18:26:48 -0400 > >Recently, I upgraded one of my server from FC4 to FC5. This also upgraded >postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get >dblink to work in this version of 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? > >bulbulbo=# select dblink_connect('dbname=bulbulfo user=bulbul'); >ERROR: could not establish connection >DETAIL: could not connect to server: Permission denied > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > >My pg_hba.conf is as follows: >---------------------- >local all all trust ># 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 client authentication error. I researched and found >that the message "could not establish connection" seems to coming from >dblink.c (inside contrib/dblink), and it gets triggred when it is unable to >create connection to the database. I though that this may be happening >because libpq is not working properly. So, I compiled a simple program, >written in C, that uses libpq and that program works 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 > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-admin по дате отправления: