| 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: | Whole Thread | Raw Message | 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 |