Re: Issue upgrading from V11 to V12 on Debian

On Tue, Dec 03, 2019 at 11:13:55AM -0500, Tom Lane wrote:
> stan <[email protected]> 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