Re: plpython3u extension

On 10/02/2016 03:44 PM, Antonio Gomez wrote:
> Thanks for your reply Adrian.
>
> We installed Postgres 9.6 by downloading the msi package from the Postgres site and running the installer in the normal fashion.

Are you talking about this?:

http://www.enterprisedb.com/products-services-training/pgdownload#windows

If not can you point to the specific location where you got the code?

If so then you should take a look at:

http://get.enterprisedb.com/docs/README-edb-languagepack-9.6.txt

>
> We basically need to make python available in postgresql to create python functions .
> And make psycopg2 available in python to connect python to other postgresql instances.

To add to Federico's answer:

https://www.postgresql.org/docs/9.6/static/postgres-fdw.html

>
> We want to use psycopg2 in python to connect to other postgresql instances because psycopg2 is the most used library in python to talk to postgres.
>
> Thanks.
> --A.
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
> Sent: Sunday, October 02, 2016 3:09 PM
> To: Antonio Gomez <AGomez(at)EBSCO(dot)COM>; psycopg(at)postgresql(dot)org
> Subject: Re: [psycopg] plpython3u extension
>
> On 10/02/2016 09:32 AM, Antonio Gomez wrote:
>>
>>
>> Hi,
>>
>>
>>
>> I have installed PostgreSQL Server 9.6.0 and Python 3.4.2 on Windows
>> 2012 R2 Server. In order to use Psycopg, I need this extension enabled
>> in Postgres: plpython3u
>
> How did you install Postgres 9.6?
>
> Psycopg is not used by plpython3u or vica versa, so you may need to explain why you need to install the extension?
>
>>
>>
>>
>> I copied plpython3.dll to C:/Program Files/PostgreSQL/9.6/lib/ , from
>> the python 3 install folder.
>>
>>
>>
>> The in PostgreSQL I try running this command: CREATE EXTENSION
>> plpython3u;
>>
>>
>>
>> And I receive this message:
>>
>>
>>
>> ERROR: could not load library "C:/Program
>> Files/PostgreSQL/9.6/lib/plpython3.dll": The specified module could
>> not be found.
>>
>>
>>
>> Under this folder: C:\Program Files\PostgreSQL\9.6\share\extension
>> there are plpython3u files.
>>
>>
>>
>> How can I get PostgreSQL to recognize this Python 3 extension? Or is
>> there an installer somewhere that will automatically enable this
>> extension in the Postgres server?
>
> That would depend on the answer to the first question above?
>
>>
>>
>>
>> Thanks!
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com