Date: Sun, 8 Jul 2018 09:18:23 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-performance@postgresql.org>
Subject: Re: where can I download the binaries of plpython extension
Message-ID: <20180708141823.GG10849@telsasoft.com>
References: 
 <CA+t6e1n_E+z1hnr35vWvgPHHVCd+_HXdJRodD66PvpO-jnyhWg@mail.gmail.com>
 <20180708132025.GD10849@telsasoft.com>
 <CA+t6e1ng6Nhvb0KM-cHDfoF9WhjFTkaJfUDX0D4Q8FMEU-Y2NQ@mail.gmail.com>
 <20180708133300.GE10849@telsasoft.com>
 <CA+t6e1nqzYPW+uzbGDM_2QP6HPpBLOiYhu2Z4dyGJ7Ue+fNpgw@mail.gmail.com>
 <20180708134356.GF10849@telsasoft.com>
 <CA+t6e1mj+7qgkyBxmu86JHVQrJRovRtoixSJ=1E72X6Z-f2ALA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+t6e1mj+7qgkyBxmu86JHVQrJRovRtoixSJ=1E72X6Z-f2ALA@mail.gmail.com>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

On Sun, Jul 08, 2018 at 04:46:47PM +0300, Mariel Cherkassky wrote:
> As I mentioned earlier, I already have a running postgresql instance on the
> machibe but on different pathes. I didnt want to install another one with
> the default pathes because I didnt want people to think that the default
> pathes are the correct ones. If I'll install the package to the default
> values then the solution is just coppying the plpythonu.control to my
> instance`s extensions directory ?

I'm not sure about compatibilty of differently compiled binaries (different
--configure flags, different compiler/version, different PG minor versions),
but I think that could work..

As I mentioned, you could also EXTRACT the PGDG postgresql10-plpython files
without installing the -server.

Or you could compile+install the plpython extension.  I'm not sure but I think
that would be ./configure --with-python.

..However if it were me, I'd schedule a time to stop the server, move the
custom-compiled binaries out of the way, and restart using the PGDG binaries
pointing at the original data dir.  I think the only condition for doing this
is keep the same major version (10) and to avoid lower minor versions (eg. once
you start with PGDG 10.4 binaries you should avoid going back and starting with
locally-compiled 10.3 binaries).

Justin