From: | stan <stanb(at)panix(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Issue upgrading from V11 to V12 on Debian |
Date: | 2019-12-03 15:53:47 |
Message-ID: | 20191203155347.GA15007@panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-12-03 16:13:55 | Re: Issue upgrading from V11 to V12 on Debian |
Previous Message | Adrian Klaver | 2019-12-03 15:29:10 | Re: Syntax error for UPDATE ... RETURNING INTO STRICT |