On Tue, Dec 03, 2019 at 11:13:55AM -0500, Tom Lane wrote:
> stan <stanb@panix.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