pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAre extensions downgrade-safe?
2+ messages / 2 participants
[nested] [flat]
* Are extensions downgrade-safe?
@ 2019-08-13 19:01 Robert Pang <robertpang@google.com>
0 siblings, 1 reply; 2+ messages in thread
From: Robert Pang @ 2019-08-13 19:01 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi everyone
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?
I searched the extensions in contrib and none comes with a downgrade
script. Are extensions that do not come downgrade script downgrade-safe? Or
do I need pg_dump or restore from backup to downgrade safely?
Thanks
Robert
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Are extensions downgrade-safe?
@ 2019-08-13 19:23 Tom Lane <tgl@sss.pgh.pa.us>
parent: Robert Pang <robertpang@google.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2019-08-13 19:23 UTC (permalink / raw)
To: Robert Pang <robertpang@google.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-08-13 19:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-13 19:01 Are extensions downgrade-safe? Robert Pang <robertpang@google.com>
2019-08-13 19:23 ` Tom Lane <tgl@sss.pgh.pa.us>
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