Re: Postgres incremental database updates thru CI/CD

There are no built in tools for this in Postgres.

There are other tools like the one mentioned that you can use instead. I've
used Liquibase for migrations for multiple companies now and it works well
enough.
If you have to support rollbacks for your deployments, that is a pretty
manual process for any serious migration (especially migrations requiring
data movement) in my experience. Also set up something that requires all
PRs to be able to apply update, rollback, and apply update again and still
be in the same state as if you only applied the update once.

For my current project, I have my liquibase integrated with my Spring Boot
backend, and CI/CD just deploys that artifact and on startup of the backend
the migrations are run. At my last company the liquibase portion was
standalone because we had a single database that had multiple products
interacting with it and we needed to be able to handle migrations
separately than any one specific app, so that was deployed directly through
CI/CD.