Re: Open Source tool to deploy/promote PostgreSQL DDL

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL
Date: 2018-07-11 20:36:53
Message-ID: dd884065-0191-b6d6-3559-cd0824167098@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/11/2018 03:21 PM, Christopher Browne wrote:
> I have built one that I call Mahout
> (https://github.com/cbbrowne/mahout) which has the merit of involving
> just two shell scripts, one of which is an auditing tool (pgcmp).
>
> It implements a "little language" to indicate dependencies between the
> SQL scripts that implement the DDL changes.
>
> The notable thing that I have seen "downthread" that it does not
> attempt to implement is "rollback scripts." I find that "necessity"
> to be a ruby-on-rails dogma that does not seem to fit what I see
> people doing.

Where I work, the requirement to have rollback scripts is part of the ITIL
requirement for Changes to have a backout procedure.

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2018-07-11 20:39:38 Re: Open Source tool to deploy/promote PostgreSQL DDL
Previous Message David Gauthier 2018-07-11 20:34:39 Re: timestamp (military) at time zone without the suffix