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