From: | stan <stanb(at)panix(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Issue upgrading from V11 to V12 on Debian |
Date: | 2019-12-03 16:46:22 |
Message-ID: | 20191203164622.GA3615@panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 03, 2019 at 11:13:55AM -0500, Tom Lane wrote:
> stan <stanb(at)panix(dot)com> writes:
> > 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?
>
> Yes, but in this context, "install" only means "add the files to the
> filesystem". You don't need to do CREATE EXTENSION in the new
> database; pg_upgrade will handle that when it transfers the data.
Sorry, I am back again :-(
So, I have V12 running as the default on the machine I am testing this on
now:
Ver Cluster Port Status Owner Data directory Log file
11 main 5433 down postgres /var/lib/postgresql/11/main
/var/log/postgresql/postgresql-11-main.log
12 main 5432 online postgres /var/lib/postgresql/12/main
/var/log/postgresql/postgresql-12-main.log
BUT, I went to the directory where I have the exentsion's source, did a
make clean ; make ; make install, and the files were still installed in the
V11 tree. How can I instruct the system to put these in the V12 tree?
The extension in question is pgemailaddr if this matters, BTW.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Jungwirth | 2019-12-03 16:58:58 | Re: Issue upgrading from V11 to V12 on Debian |
Previous Message | Alexander Farber | 2019-12-03 16:24:13 | Re: Syntax error for UPDATE ... RETURNING INTO STRICT |