pg_upgrade + Extensions - Mailing list pgsql-hackers

From David E. Wheeler
Subject pg_upgrade + Extensions
Date
Msg-id 0B4E170C-D94D-4E5A-AF54-C8421E541185@justatheory.com
Whole thread Raw
Responses Re: pg_upgrade + Extensions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hackers,

My co-workers tell me that pg_upgrade told them to drop the colnames and hostname extensions before upgrading from 9.3
to9.4. Fortunately, Postgres had  not recorded any dependencies on functions from these extensions (not sure why not,
sincewe do user them, but for the moment grateful), so it wasn’t a big deal to drop them and then add them back after
finishingthe upgrade. But frankly I don’t understand why this was necessary. It’s true that they’re C extensions with
sharedlibraries, but there are separate .so files for the 9.3 and 9.4 installs. 

Would there be a way to convince pg_upgrade that extensions don’t need to be dropped before upgrading?

Thanks,

David


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: polymorphic types - enforce casting to most common type automatically
Next
From: "Joshua D. Drake"
Date:
Subject: pg_upgrade + Ubuntu