hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ruilong Huo <r...@pivotal.io>
Subject Re: Connect to postgresql from PL/Python procedure
Date Fri, 05 Aug 2016 10:14:33 GMT
Thanks Lei. I will take a look at it and update my finding there in JIRA.

Best regards,
Ruilong Huo

On Fri, Aug 5, 2016 at 5:39 PM, Lei Chang <lei_chang@apache.org> wrote:

>
> A JIRA is started to track this: https://issues.apache.
> org/jira/browse/HAWQ-982
>
> Thanks
> Lei
>
>
>
>
> On Fri, Aug 5, 2016 at 4:38 PM, Dominik Choma <dominik.choma@gmail.com>
> wrote:
>
>>
>> Hi,
>>
>>
>> my code below:
>>
>> CREATE OR REPLACE FUNCTION dchoma.connection_test( ) RETURNS text AS
>> $$
>> import psycopg2
>>
>> try:
>>     conn = psycopg2.connect("dbname='database_name' user='user'
>> host='remote_host' password='pass' port=5432")
>>     return "Connection successful "
>> except Exception , msg :
>>     return "Exception: {m}".format(m=msg)
>> $$
>> LANGUAGE 'plpythonu' VOLATILE;
>>
>> select * from dchoma.connection_test();
>>
>>
>> HAWQ version 2.0.1.0 build dev ( compiled from github)
>> Remote database version:  PostgreSQL 9.2.15 on x86_64-redhat-linux-gnu,
>> compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4), 64-bit
>> OS: CentOS 7-1511
>>
>> i found similar issiue here, but the problem is not solved.
>> https://discuss.zendesk.com/hc/en-us/community/posts/2007933
>> 68-greenplum-dblink-postgresql-remote-is-error
>>
>> Thanks
>>
>> Dominik
>>
>> 2016-08-05 2:23 GMT+02:00 Lei Chang <lei_chang@apache.org>:
>>
>>>
>>> Hi Dominik,
>>>
>>> Can you shared your code for us to reproduce the issue?
>>>
>>> Thanks
>>> Lei
>>>
>>>
>>> On Thu, Aug 4, 2016 at 10:11 PM, Dominik Choma <dominik.choma@gmail.com>
>>> wrote:
>>>
>>>> Hi All,
>>>>
>>>> For one use case I want to connect to external postgreSQL database from
>>>> HAWQ PL/Python procedure.
>>>> I use python psycopg2 library.
>>>> Remote postgreSQL server reject connecion from HAWQ  with
>>>> this error :  FATAL  unsupported frontend protocol 28675.0: server
>>>> supports 1.0 to 3.0.
>>>> The same python code is running well from OS level.
>>>>
>>>> I wonder if  it is  HAWQ or PostgreSQL PL/Python interpreter related
>>>> issiue.
>>>> Any help or pointers would be great.
>>>>
>>>> Dominik
>>>>
>>>
>>>
>>
>

Mime
View raw message