From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stored procedure version control |
Date: | 2016-07-02 12:19:34 |
Message-ID: | 20160702121934.GA21879@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jun 30, 2016 at 09:16:49AM -0500, Merlin Moncure wrote:
> It's not really necessary to create version down scripts. In five
> years of managing complex database environments we've never had to
> roll a version back and likely never will; in the event of a disaster
> it's probably better to restore from backup anyways.
Also, a very robust approach to rollback is to clone the
existing databse before upgrading the schema (if feasible due
to size). This is the approach GNUmed uses - migration
scripts are up only, as many of them as possible are
idempotent, and we clone the existing database into a new one
before the upgrade is run. That way, users can go back to the
previous database immediately anytime and reattempt the
upgrade when convenient.
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2016-07-02 13:27:54 | Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins |
Previous Message | Rob Sargent | 2016-07-02 00:22:50 | Re: Stored procedure version control |