Feedback-ID: i76984098:Fastmail
Message-ID: <a1ead53f-8348-4dbd-b9f1-6e9c4f2633f0@aklaver.com>
Date: Tue, 3 Sep 2024 10:01:21 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Issue with Restore dump with plpythonu, plpython3u installed on
 postgres16
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Muhammad Usman Khan <usman.k@bitnine.net>, Sam Son <sam89.g@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CACW-z_UwPK8RP68ijs5Frn4+iREOSrN99-KFH6g0v3pFVVF1+w@mail.gmail.com>
 <CAPnRvGu-7B7J1i624KcJ-V2nUkuqGLsDT4Ae=EGbAPXJ=8A4fQ@mail.gmail.com>
 <f53c8d83-bf1b-4c04-a2ed-3ae5116aa582@aklaver.com>
Content-Language: en-US
In-Reply-To: <f53c8d83-bf1b-4c04-a2ed-3ae5116aa582@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/a1ead53f-8348-4dbd-b9f1-6e9c4f2633f0%40aklaver.com>
Precedence: bulk

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