Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16
Date
Msg-id a1ead53f-8348-4dbd-b9f1-6e9c4f2633f0@aklaver.com
Whole thread Raw
In response to Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16
List pgsql-general
On 9/3/24 09:37, Adrian Klaver wrote:
> On 9/3/24 09:25, Muhammad Usman Khan wrote:
>> Hi,
>> You need to install plpython3u on your new server and also make sure 
>> to use python3. You need to make changes to your functions also to 
>> make them compatible with python3
> 
> That only works if the dump from the old server is outputting 
> plpython3u. If the plpythonu is the only version installed on the old 
> server then that is what will be in the dump file. As of Postgres 15 
> plpythonu is no longer available:
> 
> https://www.postgresql.org/docs/15/plpython-python23.html
> 
> This means if you are moving to 15+ you can't have any references to 
> plpythonu.
> 

In previous post I should have added:

https://www.postgresql.org/docs/15/release-15.html


Remove server-side language plpython2u and generic Python language 
plpythonu (Andres Freund)

Python 2.x is no longer supported. While the original intent of 
plpythonu was that it could eventually refer to plpython3u, changing it 
now seems more likely to cause problems than solve them, so it's just 
been removed.


Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16
Next
From: Ron Johnson
Date:
Subject: Re: Table and data comparison