Hi Tom, > On 26. Sep, 2020, at 16:07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > If you had plpythonu installed before, that's a plausible thing > to do. (There was discussion some time ago about making the > python-2-to-3 transition less painful for users, but we failed > to come to any consensus about how; so manual fixes like this > are going to be needed for a lot of people.) that's one of the things I very much don't like about Python. This version 2 and 3 gibberish has been going on for years now wherever it's used, be it packaging with operating systems or integrated into applications. > However, I don't understand how "drop extension plpythonu" > worked for you, given your previous query showing that > that extension wasn't installed. that is exactly what I don't understand too. It should have shown up in the query, but it didn't. The PostgreSQL 12.4 software was compiled exactly the same way, only without ICU support. The other configure options were the same. Other than that, I didn't change anything in my build script. For your reference, below are the two configs: PostgreSQL 12.4: $ pg_config BINDIR = /data/postgres/12.4/bin DOCDIR = /data/postgres/12.4/share/doc HTMLDIR = /data/postgres/12.4/share/doc INCLUDEDIR = /data/postgres/12.4/include PKGINCLUDEDIR = /data/postgres/12.4/include INCLUDEDIR-SERVER = /data/postgres/12.4/include/server LIBDIR = /data/postgres/12.4/lib64 PKGLIBDIR = /data/postgres/12.4/lib64 LOCALEDIR = /data/postgres/12.4/share/locale MANDIR = /data/postgres/12.4/share/man SHAREDIR = /data/postgres/12.4/share SYSCONFDIR = /data/postgres/12.4/etc PGXS = /data/postgres/12.4/lib64/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/data/postgres/12.4' '--enable-nls' '--with-perl' '--with-python' '--with-openssl' '--with-ldap' '--with-libxml' '--with-tclconfig=/usr/lib64' CC = gcc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -O2 CFLAGS_SL = -fPIC LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/data/postgres/12.4/lib64',--enable-new-dtags LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgcommon -lpgport -lpthread -lxml2 -lssl -lcrypto -lz -lreadline -lrt -lcrypt -ldl -lm VERSION = PostgreSQL 12.4 PostgreSQL 13.0: $ pg_config BINDIR = /data/postgres/13.0/bin DOCDIR = /data/postgres/13.0/share/doc HTMLDIR = /data/postgres/13.0/share/doc INCLUDEDIR = /data/postgres/13.0/include PKGINCLUDEDIR = /data/postgres/13.0/include INCLUDEDIR-SERVER = /data/postgres/13.0/include/server LIBDIR = /data/postgres/13.0/lib64 PKGLIBDIR = /data/postgres/13.0/lib64 LOCALEDIR = /data/postgres/13.0/share/locale MANDIR = /data/postgres/13.0/share/man SHAREDIR = /data/postgres/13.0/share SYSCONFDIR = /data/postgres/13.0/etc PGXS = /data/postgres/13.0/lib64/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--prefix=/data/postgres/13.0' '--enable-nls' '--with-icu' '--with-perl' '--with-python' '--with-openssl' '--with-ldap' '--with-libxml' '--with-tclconfig=/usr/lib64' CC = gcc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -O2 CFLAGS_SL = -fPIC LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/data/postgres/13.0/lib64',--enable-new-dtags LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgcommon -lpgport -lpthread -lxml2 -lssl -lcrypto -lz -lreadline -lrt -ldl -lm VERSION = PostgreSQL 13.0 Cheers, Paul
