Heads up: alter system is disabled by default

[samip5]

in CloudNativePG version 1.22 and onwards, the default configuration disables the use of ALTER SYSTEM on new Postgres clusters. This decision is rooted in the recognition of potential risks associated with this command. To enable the use of ALTER SYSTEM, you can explicitly set .spec.postgresql.enableAlterSystem to true.

https://cloudnative-pg.io/documentation/1.22/postgresql_conf/#enabling-alter-system

[bo0tzz]

Perhaps we should move away from using ALTER SYSTEM in the postInitSQL and just set the search_path through the postgresql config spec just like shared_preload_libraries? I'm not sure what the complete implications of that would be though.