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

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

From

Michael Moore

Date:

11 May 2016, 02:26:01

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.

Thanks,

Mike

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

From

Adrian Klaver

Date:

11 May 2016, 02:36:05

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

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

From

Michael Moore

Date:

11 May 2016, 02:51:34

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

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

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

From

Adrian Klaver

Date:

11 May 2016, 03:07:10

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

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

From

Michael Moore

Date:

11 May 2016, 21:43:09

<div dir="ltr">I followed your instructions and got python2 running. I was hoping for python3, but python2 should be
justfine to learn on . Thanks for your help.</div><div class="gmail_extra"><br /><div class="gmail_quote">On Tue, May
10,2016 at 5:07 PM, Adrian Klaver <span dir="ltr"><<a href="mailto:adrian.klaver@aklaver.com"
target="_blank">adrian.klaver@aklaver.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px#ccc solid;padding-left:1ex"><span class="">On 05/10/2016 04:51 PM, Michael Moore wrote:<br
/></span><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class=""><br/> On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver<br /></span><span class=""> <<a
href="mailto:adrian.klaver@aklaver.com"target="_blank">adrian.klaver@aklaver.com</a> <mailto:<a
href="mailto:adrian.klaver@aklaver.com"target="_blank">adrian.klaver@aklaver.com</a>>> wrote:<br /><br />     On
05/10/201604:25 PM, Michael Moore wrote:<br /><br />         I think I've tried every combination of postgres 9.4 and
9.5<br/>         and psycopg2 and python. I've used Dependency Walker to examine<br />         dlls and<br />        
readcountless web pages. My current error is "ERROR:  could not<br />         load<br />         library "C:/Program
Files/PostgreSQL/9.4/lib/plpython3.dll":The<br />         specified procedure could not be found." Many people have<br
/>        encountered<br />         this error and there seems to be no shortage of "solutions". So my<br />        
questionis, does anybody have a clean set of instructions on<br />         how to get<br />         python working on a
windowsinstall of postgres; any version. I'm<br />         flexible, I can start fresh, I don't care which versions,
I<br/>         don't care<br />         if it's 32 bit or 64 bit. I just want to try it out.<br /><br /><br />     How
didyou install Postgres and from what source?<br /><br />     Where and when are you getting the error message?<br
/><br/><br />         Thanks,<br />         Mike<br /><br /><br /><br />     --<br />     Adrian Klaver<br /></span>  
 <a href="mailto:adrian.klaver@aklaver.com" target="_blank">adrian.klaver@aklaver.com</a> <mailto:<a
href="mailto:adrian.klaver@aklaver.com"target="_blank">adrian.klaver@aklaver.com</a>><span class=""><br /><br /><br
/>Hi, I installed postgres from <a href="http://www.postgresql.org/" rel="noreferrer"
target="_blank">http://www.postgresql.org/</a>. I have<br /> version 94 and 95 installed and running on my windows 7
machinein 64<br /> bit. I use pgAdmin and these installs are  running with no problems. I<br /> get the aforementioned
errormessage when  I execute: "<br /> CREATE EXTENSION plpython3u<br />   SCHEMA pg_catalog<br />   VERSION "1.0";'<br
/><br/> Also when I try "CREATE PROCEDURAL LANGUAGE 'plpython3u', same<br /> result.Dependency walker shows a
dependencyon PYTHON33.DLL and there is<br /> no such file as that either in /lib or /bin. So, according to various<br
/>"solution", I should be able to download this missing DLL . I've not<br /> done this yet because 1) it seems
suspiciousthat a DLL is missing from<br /> the install and 2) I don't tend to trust sites that offer free DLLs.<br />
Viruscity.<br /></span></blockquote><br /> Do not play in Windows much, but I believe you have to use the StackBuilder
thatis installed along with with the database. Select it and then look for the Language Pack section.<br /><br />
Another,recently announced option(though it means uninstalling your current cluster, I believe):<br /><br /><a
href="http://www.postgresql.org/message-id/CAKq0gv+Gc0i8j=ktQSkMkLJmmTqUHAm=Eza7zLv+MdXCB6H+Bw@mail.gmail.com"
rel="noreferrer"
target="_blank">http://www.postgresql.org/message-id/CAKq0gv+Gc0i8j=ktQSkMkLJmmTqUHAm=Eza7zLv+MdXCB6H+Bw@mail.gmail.com</a><br
/><br/><a href="http://www.bigsql.org/" rel="noreferrer" target="_blank">http://www.bigsql.org/</a><br /><br /> I have
nottried the above yet, so I can offer no practical advice. Also Python is at 2.7.11(<a
href="http://www.bigsql.org/components.jsp"rel="noreferrer"
target="_blank">http://www.bigsql.org/components.jsp</a>).<divclass="HOEnZb"><div class="h5"><br /><br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br /> Mike<br /><br /><br
/></blockquote><br/><br /> -- <br /> Adrian Klaver<br /><a href="mailto:adrian.klaver@aklaver.com"
target="_blank">adrian.klaver@aklaver.com</a><br/></div></div></blockquote></div><br /></div>

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

From

Adrian Klaver

Date:

11 May 2016, 23:39:03

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

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

From

Michael Moore

Date:

12 May 2016, 00:10:33

On Wed, May 11, 2016 at 1:38 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

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

I'm pretty sure it was BigSQL which installed all of the extension in a sub directory:
C:\Postgres95\PostgreSQL\pg95\share\postgresql\extension

this is the location of file plpython2u.control which Postgres tries to find when you do the CREATE LANGUAGE command. I don't know if this is the standard place where Postgres looks for this .control file or if it is part of the BigSQL install.

Postgres95 is a folder that I created for the install target.

After the install I still needed to so
CREATE EXTENSION 'plpython2u'; and

CREATE PROCEDURAL LANGUAGE 'plpythonu'

HANDLER plpython_call_handler

INLINE plpython_inline_handler

VALIDATOR plpython_validator;

I don't think that the EnterpriseDB languagepack had anything to do with it unless the install did some magic that I was not aware of.