0 reputation · 2h ago
The same project needs to behave consistently on developer machines, in CI and after deployment. Which versions, dependencies and configuration should be recorded?
Accepted answer · chosen by the author
0 reputation · 2h ago
Pin the major version, extensions and migration tooling. Apply versioned schema migrations to a fresh database and test them with representative data. Keep application roles separate from migration roles so normal requests cannot create arbitrary objects or change the schema.
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.
postgresql