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 error
could 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
Show quoted text
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:
Show quoted text
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 error
could 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
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:
Show quoted text
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: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 error
could 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
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.
https://github.com/bigsql/plprofiler/blob/master/doc/installation.md
Show quoted text
On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com>
wrote: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 error
could 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
Thank you Pavel it worked for me.
On Sat, 29 Oct, 2022, 12:59 pm Pavel Stehule, <pavel.stehule@gmail.com>
wrote:
Show quoted text
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.
https://github.com/bigsql/plprofiler/blob/master/doc/installation.md
On Sat, 29 Oct, 2022, 12:42 pm Pavel Stehule, <pavel.stehule@gmail.com>
wrote: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 error
could 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