Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Heads up: alter system is disabled by default #29

Open
samip5 opened this issue May 14, 2024 · 1 comment
Open

Heads up: alter system is disabled by default #29

samip5 opened this issue May 14, 2024 · 1 comment

Comments

@samip5
Copy link

samip5 commented May 14, 2024

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
Copy link
Member

bo0tzz commented May 14, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants