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:42:43
Message-ID: 3ddb7a3c-66a7-5063-ce5b-ebb549577f2a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/11/2018 03:39 PM, Ravi Krishna wrote:
>> Where I work, the requirement to have rollback scripts is part of the ITIL requirement for Changes to have a backout procedure.
>>
> Liquibase provides that ability, but IMO rollback for RDBMS is always bit tricky. Certain DDL operations can take long time if it involves
> a table rewrite. PG is actually better than others.

Yeah, that's true.  Sometimes I just dump the whole table, and reload if a
rollback is necessary.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

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