Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

2024-09-06 Thread Sam Son
Thanks Adrian, I have tried your previous workaround and it worked fine. I will try this approach as well. Regards, Samson G On Thu, Sep 5, 2024 at 3:50 AM Adrian Klaver wrote: > On 9/4/24 10:46, Sam Son wrote: > > Hi Adrian, > > > > Thanks for your suggestions. I will t

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

2024-09-04 Thread Sam Son
Hi Adrian, Thanks for your suggestions. I will try your modifications and do benchmarking. Thanks, Samson G On Wed, Sep 4, 2024 at 8:34 PM Adrian Klaver wrote: > On 9/4/24 03:48, Sam Son wrote: > > Hi Adrian, Muhammad, > > > > Thanks for the quick response. > > >

Re: Issue with Restore dump with plpythonu, plpython3u installed on postgres16

2024-09-04 Thread Sam Son
Hi Adrian, Muhammad, Thanks for the quick response. For new I cannot do changes in old version DB, since it is deployed remotely and i dont have any access. And it has to be done from multiple servers. As a work around I tried two solutions. *Solution 1:* After downloading and extracting the d

Issue with Restore dump with plpythonu, plpython3u installed on postgres16

2024-09-03 Thread Sam Son
Hi Team, I am working on a project where we have applications run on old versions of postgres, we are using *plpythonu* in all Functions extension, Now we have upgraded postgres to latest which does not support plpythonu anymore, So we are facing an issue while restoring dump which has plpythonu,