MIME-Version: 1.0
From: Sam Son <sam89.g@gmail.com>
Date: Mon, 2 Sep 2024 17:07:58 +0530
Message-ID: <CACW-z_UwPK8RP68ijs5Frn4+iREOSrN99-KFH6g0v3pFVVF1+w@mail.gmail.com>
Subject: Issue with Restore dump with plpythonu, plpython3u installed on postgres16
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000221e880621216019"
Archived-At: <https://www.postgresql.org/message-id/CACW-z_UwPK8RP68ijs5Frn4%2BiREOSrN99-KFH6g0v3pFVVF1%2Bw%40mail.gmail.com>
Precedence: bulk

--000000000000221e880621216019
Content-Type: text/plain; charset="UTF-8"

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, but latest postgres support only plpython3u.

*"pg_restore: error: could not execute query: ERROR:  language "plpythonu"
does not exist"*

How to change plpythonu to plpython3u in the dump file before pg_restore.
or Does postgres have any option to handle directly via config.

Thanks in Advance

Thanks,
Samson G

--000000000000221e880621216019
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Team,<br><br>I am working on a project where we have ap=
plications=C2=A0run on old versions of postgres, we are using=C2=A0<b>plpyt=
honu</b>=C2=A0in all Functions extension,=C2=A0<br><br>Now we have upgraded=
 postgres to latest which does not support plpythonu anymore, So we are fac=
ing an issue while restoring dump which has plpythonu, but latest postgres =
support only plpython3u.=C2=A0<div><div><br></div><div><b>&quot;pg_restore:=
 error: could not execute query: ERROR: =C2=A0language &quot;plpythonu&quot=
; does not exist&quot;</b></div><div><br></div><div><div>How to change plpy=
thonu to plpython3u in the dump file before pg_restore. or Does postgres ha=
ve any option to handle directly via config.=C2=A0</div><div><br></div><div=
>Thanks in Advance<br><br></div><div>Thanks,<br>Samson G</div></div></div><=
/div>

--000000000000221e880621216019--