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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: dblink not working in FC5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Invalid Page Headers