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

Tooling to facilitate postgres upgrades #186

Open
mzabani opened this issue Mar 15, 2024 · 0 comments
Open

Tooling to facilitate postgres upgrades #186

mzabani opened this issue Mar 15, 2024 · 0 comments

Comments

@mzabani
Copy link
Owner

mzabani commented Mar 15, 2024

If one updates postgres, they currently need to coordinate a PR to upgrade the expected schema.

It will be simpler if we put one folder per major PG version in the expected-schema folder, and at runtime decide which to use.

Users would still need to ensure they update both if they keep multiple versions of postgres in different environments, but that seems inevitable.

However, for an upgrade in all environments, this will make the requirement of coordination simpler, allowing a PR that includes the expected schema of the new version to be merged a bit earlier.

It will also allow reverting the DB more easily if something goes wrong.

This is quite similar to what @TravisCardwell did in https://www.extrema.is/blog/2023/03/28/codd-experiment-2-postgresql-upgrade, IIUC, but would be builtin to codd.

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

1 participant