Paul Jones <p...@cmicdo.com> writes: > pg_upgrade complains about not being able to find $libdir/plpython3 > when upgrading a 9.4 cluster that has both python2 and python3 used.
No, that's not what the error message says: > Could not load library "$libdir/plpython3" > FATAL: Python major version mismatch in session > DETAIL: This session has previously used Python major version 2, and it is > now attempting to use Python major version 3. > HINT: Start a new session to use a different Python major version. This is a restriction we put in place because libpython2 and libpython3 don't coexist nicely in the same address space. Unfortunately, it makes it problematic to restore a dump that contains references to both python2 and python3 functions. It looks like pg_upgrade tries to load all libraries from functions in any database in the old cluster into a single session in the new cluster, which will fail in a scenario like this even if you keep python2 and python3 functions rigorously separated into distinct databases. I'm not sure if we could weaken that test enough to work. > I dropped the python2 database but still got the problem. You must still have at least one database that contains references to python2 (check pg_language to be sure). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general