Re: python install defies all efforts and leaves programmer a broken shell of a man - Mailing list pgsql-sql

On 05/11/2016 11:43 AM, Michael Moore wrote:
> 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.

Out of curiosity was that with the EDB installer or the BigSQL one?

>
> On Tue, May 10, 2016 at 5:07 PM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     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>
>         <mailto: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>
>         <mailto: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 <mailto:adrian.klaver@aklaver.com>
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com