Re: python install defies all efforts and leaves programmer a broken shell of a man

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: python install defies all efforts and leaves programmer a broken shell of a man
Date: 2016-05-11 18:43:03
Message-ID: CACpWLjNWiZ7pYmZ=5zBCwTt+_6Ch7-1FkE9zzvetMYZE1Gtmtg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I followed your instructions and got python2 running. I was hoping for
python3, but python2 should be just fine to learn on . Thanks for your help.

On Tue, May 10, 2016 at 5:07 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 05/10/2016 04:51 PM, Michael Moore wrote:
>
>>
>> On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver
>> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 05/10/2016 04:25 PM, Michael Moore wrote:
>>
>> I think I've tried every combination of postgres 9.4 and 9.5
>> and psycopg2 and python. I've used Dependency Walker to examine
>> dlls and
>> read countless web pages. My current error is "ERROR: could not
>> load
>> library "C:/Program Files/PostgreSQL/9.4/lib/plpython3.dll": The
>> specified procedure could not be found." Many people have
>> encountered
>> this error and there seems to be no shortage of "solutions". So my
>> question is, does anybody have a clean set of instructions on
>> how to get
>> python working on a windows install of postgres; any version. I'm
>> flexible, I can start fresh, I don't care which versions, I
>> don't care
>> if it's 32 bit or 64 bit. I just want to try it out.
>>
>>
>> How did you install Postgres and from what source?
>>
>> Where and when are you getting the error message?
>>
>>
>> Thanks,
>> Mike
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>> Hi, I installed postgres from http://www.postgresql.org/ . I have
>> version 94 and 95 installed and running on my windows 7 machine in 64
>> bit. I use pgAdmin and these installs are running with no problems. I
>> get the aforementioned error message when I execute: "
>> CREATE EXTENSION plpython3u
>> SCHEMA pg_catalog
>> VERSION "1.0";'
>>
>> Also when I try "CREATE PROCEDURAL LANGUAGE 'plpython3u', same
>> result.Dependency walker shows a dependency on PYTHON33.DLL and there is
>> no such file as that either in /lib or /bin. So, according to various
>> "solution", I should be able to download this missing DLL . I've not
>> done this yet because 1) it seems suspicious that a DLL is missing from
>> the install and 2) I don't tend to trust sites that offer free DLLs.
>> Virus city.
>>
>
> Do not play in Windows much, but I believe you have to use the
> StackBuilder that is installed along with with the database. Select it and
> then look for the Language Pack section.
>
> Another, recently announced option(though it means uninstalling your
> current cluster, I believe):
>
>
> http://www.postgresql.org/message-id/CAKq0gv+Gc0i8j=ktQSkMkLJmmTqUHAm=Eza7zLv+MdXCB6H+Bw@mail.gmail.com
>
> http://www.bigsql.org/
>
> I have not tried the above yet, so I can offer no practical advice. Also
> Python is at 2.7.11(http://www.bigsql.org/components.jsp).
>
>
>
>> Mike
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2016-05-11 20:38:55 Re: python install defies all efforts and leaves programmer a broken shell of a man
Previous Message Adrian Klaver 2016-05-11 14:22:15 Re: Create a trigger only for certain users