agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Michael Moore <michaeljmoore@gmail.com>
Cc: postgres list <pgsql-sql@postgresql.org>
Subject: Re: python install defies all efforts and leaves programmer a broken shell of a man
Date: Tue, 10 May 2016 17:07:00 -0700
Message-ID: <9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com> (raw)
In-Reply-To: <CACpWLjN5cdkGZ1FOYfrbSh+MDRW+NxMXj7mxPB37Eo_HAAgAwA@mail.gmail.com>
References: <CACpWLjPNiXH+tOFOGkwXaZu3d2NEqpjsh3d9GWRr5RRG+bjYSA@mail.gmail.com>
<d4e306df-1324-ae58-8bd0-728bee87b0b5@aklaver.com>
<CACpWLjN5cdkGZ1FOYfrbSh+MDRW+NxMXj7mxPB37Eo_HAAgAwA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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....
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
view thread (7+ messages) latest in thread
Message-ID: <9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com>
Permalink: ../9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com/
Also on: postgresql.org/message-id/9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, michaeljmoore@gmail.com
Subject: Re: python install defies all efforts and leaves programmer a broken shell of a man
In-Reply-To: <9db31ed2-5523-e49d-59d2-22c6c16c54ef@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox