Are extensions downgrade-safe? - Mailing list pgsql-admin

From Robert Pang
Subject Are extensions downgrade-safe?
Date
Msg-id CAJhEC04iTp_RhuYJC_JnA2HW=ewftz70LoeQEREZnU7B-kAk6A@mail.gmail.com
Whole thread Raw
Responses Re: Are extensions downgrade-safe?
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Bikram MAJUMDAR
Date:
Subject: RE: Question on pgwatch
Next
From: Tom Lane
Date:
Subject: Re: Are extensions downgrade-safe?