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

Check settings are the same between primary and secondaries #174

Closed
Krysztophe opened this issue Mar 16, 2018 · 2 comments
Closed

Check settings are the same between primary and secondaries #174

Krysztophe opened this issue Mar 16, 2018 · 2 comments

Comments

@Krysztophe
Copy link
Collaborator

In many cases the primary and a secondary must keep the same configuration, in case of a switchover.

In many cases people forget to propagate these changes. So a promoted primary will not archive, its work_mem will be different...

A new service could compare the pg_settings of a primary and a slave and raise a warning if there is a difference.

Optional --exclude option for some parameters that may differ (like cluster_name on Debian)

@frost242 frost242 added this to the release 2.5 milestone Mar 16, 2018
@Krysztophe
Copy link
Collaborator Author

Just wondering if this service should include pg_hba_file_rules (10+) or if it should be another service. IMHO, the latter.

@ioguix ioguix removed this from the release 2.5 milestone Nov 3, 2020
@Krysztophe
Copy link
Collaborator Author

I forgot this and complained again in #283 , with more details, so I close this one.

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

No branches or pull requests

3 participants