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

Managing PG configuration across major Postgres versions. #33

Open
davissp14 opened this issue Sep 20, 2021 · 0 comments
Open

Managing PG configuration across major Postgres versions. #33

davissp14 opened this issue Sep 20, 2021 · 0 comments
Labels
enhancement New feature or request

Comments

@davissp14
Copy link
Contributor

There are various Postgres configuration options that are added/removed/renamed across major Postgres versions. We need to come up with a sane strategy for organizing and maintaining configuration to accommodate past, present and future generations of Postgres.

Quick example:

In Postgres 12, we have wal_keep_segments which is used to specify the minimum number of past log file segments kept in the pg_wal directory.

In Postgres 13, this has been "renamed" to wal_keep_size.

This determines how much WAL to retain for standby servers. It is specified in megabytes, rather than number of files as with the old parameter. If you previously used wal_keep_segments, the following formula will give you an approximately equivalent setting:
wal_keep_size = wal_keep_segments * wal_segment_size (typically 16MB)

@davissp14 davissp14 added the enhancement New feature or request label Sep 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant