| 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 23:01:08 |
| Message-ID: | 9661ccd5-fe28-26fc-043b-680e020e6455@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2018-07-11 23:48:40 | Re: Open Source tool to deploy/promote PostgreSQL DDL |
| Previous Message | Tim Cross | 2018-07-11 22:20:13 | Re: Open Source tool to deploy/promote PostgreSQL DDL |