From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Pang <robertpang@google.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Are extensions downgrade-safe?
Date: Tue, 13 Aug 2019 15:23:01 -0400
Message-ID: <13169.1565724181@sss.pgh.pa.us> (raw)
In-Reply-To: <CAJhEC04iTp_RhuYJC_JnA2HW=ewftz70LoeQEREZnU7B-kAk6A@mail.gmail.com>
References: <CAJhEC04iTp_RhuYJC_JnA2HW=ewftz70LoeQEREZnU7B-kAk6A@mail.gmail.com>
Robert Pang <robertpang@google.com> writes:
> In PostgreSQL, there are times where a new version of an extension is
> included in a minor-version upgrade. If I do a minor-version upgrade of my
> PG database, upgrade the version of the extension and then have a need to
> revert (downgrade) to the old PG minor version, what should I do with the
> extension?
It'd really depend on what the particular extension upgrade script did.
A lot of the time you wouldn't have any issue, but there are probably
cases where reversing the effect of the upgrade script would be advisable.
We don't prepare downgrade scripts for the contrib modules; the question
comes up so seldom that it doesn't seem worth the maintenance effort.
But you could likely make one by studying the upgrade script and reversing
whatever it did.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, robertpang@google.com, pgsql-admin@lists.postgresql.org
Subject: Re: Are extensions downgrade-safe?
In-Reply-To: <13169.1565724181@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox