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.
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.
We want to use psycopg2 in python to connect to other postgresql instances because psycopg2 is the most used library in
pythonto talk to postgres.
Thanks.
--A.
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: Sunday, October 02, 2016 3:09 PM
To: Antonio Gomez <AGomez@EBSCO.COM>; psycopg@postgresql.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.klaver@aklaver.com