Search Postgresql Archives

Re: Postgres incremental database updates thru CI/CD

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux