pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Install postgresql-plpython for postgres 11 3+ messages / 2 participants [nested] [flat]
* Install postgresql-plpython for postgres 11 @ 2019-06-11 12:14 Srikar Vankadaru <srikar@opsveda.com> 2019-06-11 14:48 ` Re: Install postgresql-plpython for postgres 11 Jakub Olczyk <jwo@disroot.org> 0 siblings, 1 reply; 3+ messages in thread From: Srikar Vankadaru @ 2019-06-11 12:14 UTC (permalink / raw) To: pgsql-admin Hello Experts, I wanted to install PL/Python (package name: postgresql-plpython) on Postgres 11.2 version running on AWS with Centos 7. Is there any way to add this language for my running postgres server ? As we have used the source package to install Postgresql 11 without giving option --with-python I tried to find for packages in Centos 7 repo, but found this one and it needs the dependency to install postgresql-server. postgresql-plpython x86_64 9.2.24-1.el7_5 base Can you please advise on how to go about this ? Regards, Srikar ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Install postgresql-plpython for postgres 11 2019-06-11 12:14 Install postgresql-plpython for postgres 11 Srikar Vankadaru <srikar@opsveda.com> @ 2019-06-11 14:48 ` Jakub Olczyk <jwo@disroot.org> 2019-06-11 16:19 ` RE: Install postgresql-plpython for postgres 11 Srikar Vankadaru <srikar@opsveda.com> 0 siblings, 1 reply; 3+ messages in thread From: Jakub Olczyk @ 2019-06-11 14:48 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org Hi Srikar! On 11/06/2019 14:14, Srikar Vankadaru wrote: > I wanted to install PL/Python (package name: postgresql-plpython) on > Postgres 11.2 version running on AWS with Centos 7. > > Is there any way to add this language for my running postgres server ? > As we have used the source package to install Postgresql 11 without > giving option |--with-python| As I understand you have compiled the binaries yourself. In that case I think the only option is to recompile from the same sources with different configuration (this should be fairly fast unless you removed the object files). I don't know if there is a smooth way to use prepackaged (in form of RPM) version of PL/Python in this case. > I tried to find for packages in Centos 7 repo, but found this one and it > needs the dependency to install postgresql-server. > > postgresql-plpython > x86_64 > 9.2.24-1.el7_5 base This is version of the PL/Python for the base system version of PostgreSQL. This version is very old and not supported anymore by the developers. You need to have matching version of Postgres server and PL/Python. Maybe others can give more insight if marrying compiled and packaged extension can work. I'd use the packaged version of Postgres server and PL/Python from official repository here: http://yum.postgresql.org Cheers! jwo ^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Install postgresql-plpython for postgres 11 2019-06-11 12:14 Install postgresql-plpython for postgres 11 Srikar Vankadaru <srikar@opsveda.com> 2019-06-11 14:48 ` Re: Install postgresql-plpython for postgres 11 Jakub Olczyk <jwo@disroot.org> @ 2019-06-11 16:19 ` Srikar Vankadaru <srikar@opsveda.com> 0 siblings, 0 replies; 3+ messages in thread From: Srikar Vankadaru @ 2019-06-11 16:19 UTC (permalink / raw) To: 'Jakub Olczyk' <jwo@disroot.org>; pgsql-admin@lists.postgresql.org Hi Jwo, I am sorry, we have built Postgresql from the Centos 7 repository. Not from the source. Is there any option to add this Language now ? If I need to rebuild with this option, what is the procedure to do that ? Thanks, Srikar -----Original Message----- From: Jakub Olczyk [mailto:jwo@disroot.org] Sent: Tuesday, June 11, 2019 20:18 To: pgsql-admin@lists.postgresql.org Subject: Re: Install postgresql-plpython for postgres 11 Hi Srikar! On 11/06/2019 14:14, Srikar Vankadaru wrote: > I wanted to install PL/Python (package name: postgresql-plpython) on > Postgres 11.2 version running on AWS with Centos 7. > > Is there any way to add this language for my running postgres server ? > As we have used the source package to install Postgresql 11 without > giving option |--with-python| As I understand you have compiled the binaries yourself. In that case I think the only option is to recompile from the same sources with different configuration (this should be fairly fast unless you removed the object files). I don't know if there is a smooth way to use prepackaged (in form of RPM) version of PL/Python in this case. > I tried to find for packages in Centos 7 repo, but found this one and > it needs the dependency to install postgresql-server. > > postgresql-plpython > x86_64 > 9.2.24-1.el7_5 base This is version of the PL/Python for the base system version of PostgreSQL. This version is very old and not supported anymore by the developers. You need to have matching version of Postgres server and PL/Python. Maybe others can give more insight if marrying compiled and packaged extension can work. I'd use the packaged version of Postgres server and PL/Python from official repository here: http://yum.postgresql.org Cheers! jwo ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2019-06-11 16:19 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-06-11 12:14 Install postgresql-plpython for postgres 11 Srikar Vankadaru <srikar@opsveda.com> 2019-06-11 14:48 ` Jakub Olczyk <jwo@disroot.org> 2019-06-11 16:19 ` Srikar Vankadaru <srikar@opsveda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox