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

<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>