Subject: Re: python install defies all efforts and leaves programmer a
 broken shell of a man
To: Michael Moore <michaeljmoore@gmail.com>
References: 
 <CACpWLjPNiXH+tOFOGkwXaZu3d2NEqpjsh3d9GWRr5RRG+bjYSA@mail.gmail.com>
 <d4e306df-1324-ae58-8bd0-728bee87b0b5@aklaver.com>
 <CACpWLjN5cdkGZ1FOYfrbSh+MDRW+NxMXj7mxPB37Eo_HAAgAwA@mail.gmail.com>
Cc: postgres list <pgsql-sql@postgresql.org>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com>
Date: Tue, 10 May 2016 17:07:00 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.0
MIME-Version: 1.0
In-Reply-To: 
 <CACpWLjN5cdkGZ1FOYfrbSh+MDRW+NxMXj7mxPB37Eo_HAAgAwA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 05/10/2016 04:51 PM, Michael Moore wrote:
>
> On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql