Are extensions downgrade-safe?

Robert Pang <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAJhEC04iTp_RhuYJC_JnA2HW=ewftz70LoeQEREZnU7B-kAk6A@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.