I am working on upgrading from V11 to V12 on Debian.
My first attempt failed, and I have figured out that this is because I have
added extensions to the V11 DB, at least one of which was not installed
using the Debian packages.
So, it looks like i need to install these before doing the upgrade, correct?
This brings up a chicken or egg issue however. We are creating the
extensions, like this:
CREATE EXTENSION emailaddr with schema ica
So, to accomplish this, I would need to create the ice schema, and the user
it "belongs" to before I run pg_upgradecluster. This raises 2 questions
1) Is it OK to create these before doing the upgrade?
2) Does this flag that creating these extensions "in" a schema may be a
long term "bad idea"?
Thanks for any advice n this.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin