PostgreSQL 15 don't start because of conflicts with another extensions.
Tiago-Anastacio opened this issue · 7 comments
Hello,
I am using plpgsql check release 2.3 and PostgreSQL 13,14 and 15
From PostgreSQL 15, there is an incompatibility with plpgsql_check and some extensions => PostgreSQL just don't start
Some of these extensions are very important : pglogical
I know that from PostgresQL 15 , there is a change on the way hooks are handled in shared memory, But I don't know exactly how
Thanks
plpgsql_check uses correct handling of shared memory now. Do you have latest version of plpgsql_check? There was some bugfixes in this area - 8327afb
I am using this package from community repository:
https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/plpgsql_check_15-2.3.4-1.sles15.1.x86_64.rpm
also have these packages available:
https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/plpgsql_check_15-2.3.1-1.sles15.x86_64.rpm 21-Feb-2023 10:09 266504
https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/plpgsql_check_15-2.3.2-1.sles15.x86_64.rpm) 10-May-2023 20:17 267096
plpgsql_check_15-2.3.4-1.sles15.1.x86_64.rpm 04-Jun-2023 01:23 270048
https://download.postgresql.org/pub/repos/zypp/15/suse/sles-15.4-x86_64/plpgsql_check_15-2.3.4-1.sles15.x86_64.rpm 18-Apr-2023 15:53 270376
Unfortunately, plpgsql_check uses badly named global variables - same issue is in pglogical. It should be fixed by b55a8a1
Thanks Pavel.
Could you please ask Devrim to package new releases 2.4 and 2.5 (they are not in the community repositery) ?
If I ask it will take much more time...
Thank you
The community packages are updated https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-9-x86_64/