Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b0avM-000628-Vs for pgsql-sql@arkaria.postgresql.org; Wed, 11 May 2016 20:40:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b0avM-0001rq-4I for pgsql-sql@arkaria.postgresql.org; Wed, 11 May 2016 20:40:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b0auM-0000lC-QF for pgsql-sql@postgresql.org; Wed, 11 May 2016 20:39:03 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b0auI-0000Is-K3 for pgsql-sql@postgresql.org; Wed, 11 May 2016 20:39:01 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 04CEF20A35 for ; Wed, 11 May 2016 16:38:57 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute6.internal (MEProxy); Wed, 11 May 2016 16:38:57 -0400 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=aklaver.com; h=cc :content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=Swk401uynLps00+0Q5LO8jGcqzM=; b=SIz0R4 jW4/7UMHRqUCeNryHK6m9HdWopVm3gdXtfmsY10O9cXT+f/klMbiVbraLLczDkL/ CHdGvYEkRnZ69Zc4oTA1nI0yD+SHFgHRWbgxg/AZ6X4vbBVoaiQhZz1g+NLOAciu KDQaLp8CP88RO3kPrPwLGIvPtSXMkx2iUgO1A= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-sasl-enc:x-sasl-enc; s=smtpout; bh=Swk401uynLps00+ 0Q5LO8jGcqzM=; b=fvONfifNBoxWEZV7AOmCvk4uemoFyuqGvDygWBK5VbuMhGy 6epEK5qpKMc2RJSmFm67dYfdmE//m8Z7/Qqr1JhoG+Ob5CFUecCnPMqAIIaKK0Hp IxVwPPy8z45hk58atORmZqyVimN+wXaTmopKRGrGJYq9sKIRagBsz/4h6f4k= X-Sasl-enc: r1mSw/7kjhn8lWTWDhLetQ0AGOhz5TYT1q6/VO/zN7xa 1462999136 Received: from [192.168.1.2] (174-24-160-10.tukw.qwest.net [174.24.160.10]) by mail.messagingengine.com (Postfix) with ESMTPA id 70942C00019; Wed, 11 May 2016 16:38:56 -0400 (EDT) Subject: Re: python install defies all efforts and leaves programmer a broken shell of a man To: Michael Moore References: <9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com> Cc: postgres list From: Adrian Klaver Message-ID: <0fb5b456-0ecf-bf1a-3716-55afef98771a@aklaver.com> Date: Wed, 11 May 2016 13:38:55 -0700 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:45.0) Gecko/20100101 Thunderbird/45.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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 > > wrote: > > On 05/10/2016 04:51 PM, Michael Moore wrote: > > > On Tue, May 10, 2016 at 4:30 PM, Adrian Klaver > > >> 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. > > > 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 > > -- 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