I could not find a tool like DACPAC for PostgresSQL, so I did one. It's named pgpackage and supports DSC-style workflows for PostgresSQL. Still in beta test, so do not use on production unless you have a backup 😉 magnusopera.github.io/pgpackage/
DACPAC-style desired state for PostgreSQL | pgpackage
Treat PostgreSQL schema as desired state in Git, then let pgpackage diff and apply it safely.
magnusopera.github.io