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 9661ccd5-fe28-26fc-043b-680e020e6455@gmail.com
Whole thread Raw
In response to Re: Open Source tool to deploy/promote PostgreSQL DDL  (Christopher Browne <cbbrowne@gmail.com>)
Responses Re: Open Source tool to deploy/promote PostgreSQL DDL
List pgsql-general
On 07/11/2018 04:10 PM, Christopher Browne wrote:
[snip]
> ITIL surely does NOT specify the use of database rollback scripts as
> THE SPECIFIED MECHANISM for a backout procedure.
>
> In practice, we tend to take database snapshots using filesystem
> tools, as that represents a backout procedure that will work regardless
> of the complexity of an upgrade.
>
> It is quite possible for an upgrade script to not be reversible.
>
> After all, not all matrices are invertible; there are a surprisingly large
> number of preconditions that are required for that in linear algebra.
>
> And in databases, not all upgrades may be reversed via rollback scripts.

Does "rollback script" truly mean undoing what you just did in a 
transaction-like manner?

-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Tim Cross
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL
Next
From: Adrian Klaver
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL