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-10 23:51:29
Message-ID: CACpWLjN5cdkGZ1FOYfrbSh+MDRW+NxMXj7mxPB37Eo_HAAgAwA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver <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

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.

Mike

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2016-05-11 00:07:00 Re: python install defies all efforts and leaves programmer a broken shell of a man
Previous Message Adrian Klaver 2016-05-10 23:30:58 Re: python install defies all efforts and leaves programmer a broken shell of a man