| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: schema change tracking |
| Date: | 2019-05-16 19:01:53 |
| Message-ID: | CAGrpgQ_kO-=7i3pHj3A0dCizR427t4HTfJexQ1D2Hs4-GQ=PpA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 16, 2019 at 9:41 AM Benedict Holland <
benedict(dot)m(dot)holland(at)gmail(dot)com> wrote:
> I need a tool that can track schema changes in a postgesql database, write
> scripts to alter the tables, and store those changes in git. Are there
> tools that exist that can do this?
>
For dev and QA, my company is using Migra (
https://github.com/djrobstep/migra) as part of the developer workflow to
track DDL changes. The generated changes are then put into git as patches.
Migra itself is just used for the diff'ing capabilities it provides, and
will require some glue code if you want to use it for any CI/CD work.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daulat Ram | 2019-05-17 06:54:59 | FATAL: SMgrRelation hashtable corrupted |
| Previous Message | Adrian Klaver | 2019-05-16 17:58:51 | Re: schema change tracking |