Обсуждение: how to install plprofiler
Hello,
I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below error
could not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32
Could you please let me know how to install plprofiler on version 13 to pass this error.
OS is Ubuntu
-- Shashidhar
Hi
so 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:
Hello,I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below errorcould not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32Could you please let me know how to install plprofiler on version 13 to pass this error.
Did you install plprofiler for PostgreSQL 13?
If yes, then you need to uninstall plprofiler before upgrade. Some extensions doesn't support upgrade between major versions, or doesn't supports upgrade Postgres and upgrade the extension in one step.
Regards
Pavel
OS is Ubuntu--Shashidhar
Pavel,
After Uninstall plprofiler where can find this to install again.
On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com> wrote:
Hiso 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:Hello,I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below errorcould not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32Could you please let me know how to install plprofiler on version 13 to pass this error.Did you install plprofiler for PostgreSQL 13?If yes, then you need to uninstall plprofiler before upgrade. Some extensions doesn't support upgrade between major versions, or doesn't supports upgrade Postgres and upgrade the extension in one step.RegardsPavelOS is Ubuntu--Shashidhar
I am sorry I have not installed it for version 13 as I am not able to find the source
On Sat, 29 Oct, 2022, 12:55 pm shashidhar Reddy, <shashidharreddy001@gmail.com> wrote:
Pavel,After Uninstall plprofiler where can find this to install again.On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com> wrote:Hiso 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:Hello,I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below errorcould not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32Could you please let me know how to install plprofiler on version 13 to pass this error.Did you install plprofiler for PostgreSQL 13?If yes, then you need to uninstall plprofiler before upgrade. Some extensions doesn't support upgrade between major versions, or doesn't supports upgrade Postgres and upgrade the extension in one step.RegardsPavelOS is Ubuntu--Shashidhar
so 29. 10. 2022 v 9:25 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:
Pavel,After Uninstall plprofiler where can find this to install again.
On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com> wrote:Hiso 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:Hello,I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below errorcould not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32Could you please let me know how to install plprofiler on version 13 to pass this error.Did you install plprofiler for PostgreSQL 13?If yes, then you need to uninstall plprofiler before upgrade. Some extensions doesn't support upgrade between major versions, or doesn't supports upgrade Postgres and upgrade the extension in one step.RegardsPavelOS is Ubuntu--Shashidhar
Thank you Pavel it worked for me.
On Sat, 29 Oct, 2022, 12:59 pm Pavel Stehule, <pavel.stehule@gmail.com> wrote:
so 29. 10. 2022 v 9:25 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:Pavel,After Uninstall plprofiler where can find this to install again.On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com> wrote:Hiso 29. 10. 2022 v 8:44 odesílatel shashidhar Reddy <shashidharreddy001@gmail.com> napsal:Hello,I am in a process of upgrading postgresql 12 to version 13, when I am testing it getting the below errorcould not load library $carlib/plprofiler "/usr/lib/postgresql/13/lib/plprofiler.so": /usr/lib/postgresql/13/lib/plprofiler.so: undefined symbol: hash_uint32Could you please let me know how to install plprofiler on version 13 to pass this error.Did you install plprofiler for PostgreSQL 13?If yes, then you need to uninstall plprofiler before upgrade. Some extensions doesn't support upgrade between major versions, or doesn't supports upgrade Postgres and upgrade the extension in one step.RegardsPavelOS is Ubuntu--Shashidhar