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

2024-09-06 Thread Adrian Klaver
On 9/6/24 05:58, Sam Son wrote: Thanks Adrian, I have tried your previous workaround and it worked fine. I will try this approach as well. If the previous solution(-s/-a) works then my update should work also. I offered it as possible solution should you run into out of sequence issues usin

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 try your modifications a

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

2024-09-04 Thread Adrian Klaver
On 9/4/24 10:46, Sam Son wrote: Hi Adrian, Thanks for your suggestions. I will try your modifications and do benchmarking. I got to thinking and realized I missed an important part about separating the schema and data restores using the -s and -a arguments. This is best explained here: ht

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. > > > > For new I cannot do changes

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

2024-09-04 Thread Adrian Klaver
On 9/4/24 03:48, Sam Son wrote: 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. Both of which d

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

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

2024-09-03 Thread Adrian Klaver
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

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

2024-09-03 Thread Adrian Klaver
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.

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

2024-09-03 Thread Muhammad Usman Khan
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 On Tue, 3 Sept 2024 at 19:31, Sam Son wrote: > Hi Team, > > I am working on a project where we have applications run on o

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

2024-09-03 Thread Adrian Klaver
On 9/2/24 04:37, Sam Son wrote: 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, What versions of Postgres? Now we have upgraded postgres to latest which does not support plpythonu anymore,

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,