Re: Open Source tool to deploy/promote PostgreSQL DDL - Mailing list pgsql-general

From Ron
Subject Re: Open Source tool to deploy/promote PostgreSQL DDL
Date
Msg-id 3ddb7a3c-66a7-5063-ce5b-ebb549577f2a@gmail.com
Whole thread Raw
In response to Re: Open Source tool to deploy/promote PostgreSQL DDL  (Ravi Krishna <sravikrishna3@gmail.com>)
List 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
longtime 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.


pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL
Next
From: "David G. Johnston"
Date:
Subject: Re: timestamp (military) at time zone without the suffix