0s autopkgtest [08:27:16]: starting date and time: 2024-06-25 08:27:16+0000 0s autopkgtest [08:27:16]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [08:27:16]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.7eitap2g/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:fakeroot --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=fakeroot/1.35.1-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos01-ppc64el-3.secgroup --name adt-oracular-ppc64el-postgresql-common-20240625-082716-juju-7f2275-prod-proposed-migration-environment-2-52a80986-4c5c-404f-a80f-938c2c617d32 --image adt/ubuntu-oracular-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://us.ports.ubuntu.com/ubuntu-ports/ 149s autopkgtest [08:29:45]: testbed dpkg architecture: ppc64el 150s autopkgtest [08:29:46]: testbed apt version: 2.9.5 150s autopkgtest [08:29:46]: @@@@@@@@@@@@@@@@@@@@ test bed setup 150s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 151s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 151s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 151s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 152s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 152s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main ppc64el Packages [107 kB] 152s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted ppc64el Packages [1860 B] 152s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe ppc64el Packages [371 kB] 152s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse ppc64el Packages [2532 B] 152s Fetched 1100 kB in 2s (631 kB/s) 152s Reading package lists... 155s Reading package lists... 155s Building dependency tree... 155s Reading state information... 155s Calculating upgrade... 155s The following packages will be upgraded: 155s libhogweed6t64 libnettle8t64 156s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 156s Need to get 437 kB of archives. 156s After this operation, 1024 B of additional disk space will be used. 156s Get:1 http://ftpmaster.internal/ubuntu oracular/main ppc64el libnettle8t64 ppc64el 3.10-1 [228 kB] 156s Get:2 http://ftpmaster.internal/ubuntu oracular/main ppc64el libhogweed6t64 ppc64el 3.10-1 [209 kB] 157s Fetched 437 kB in 1s (587 kB/s) 157s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 157s Preparing to unpack .../libnettle8t64_3.10-1_ppc64el.deb ... 157s Unpacking libnettle8t64:ppc64el (3.10-1) over (3.9.1-2.2build1) ... 157s Setting up libnettle8t64:ppc64el (3.10-1) ... 157s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 157s Preparing to unpack .../libhogweed6t64_3.10-1_ppc64el.deb ... 157s Unpacking libhogweed6t64:ppc64el (3.10-1) over (3.9.1-2.2build1) ... 157s Setting up libhogweed6t64:ppc64el (3.10-1) ... 157s Processing triggers for libc-bin (2.39-0ubuntu9) ... 157s Reading package lists... 157s Building dependency tree... 157s Reading state information... 157s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 158s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 158s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 158s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 158s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 159s Reading package lists... 159s Reading package lists... 159s Building dependency tree... 159s Reading state information... 159s Calculating upgrade... 159s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 159s Reading package lists... 160s Building dependency tree... 160s Reading state information... 160s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 162s autopkgtest [08:29:58]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP Sat Apr 20 00:05:55 UTC 2024 163s autopkgtest [08:29:59]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 169s Get:1 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (dsc) [2383 B] 169s Get:2 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (tar) [218 kB] 169s gpgv: Signature made Thu May 9 15:21:37 2024 UTC 169s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 169s gpgv: Can't check signature: No public key 169s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_260.dsc: no acceptable signature found 169s autopkgtest [08:30:05]: testing package postgresql-common version 260 170s autopkgtest [08:30:06]: build not needed 170s autopkgtest [08:30:06]: test default-psql: preparing testbed 172s Reading package lists... 172s Building dependency tree... 172s Reading state information... 173s Starting pkgProblemResolver with broken count: 0 173s Starting 2 pkgProblemResolver with broken count: 0 173s Done 173s The following additional packages will be installed: 173s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 173s postgresql-client-common postgresql-common ssl-cert 173s Suggested packages: 173s postgresql-doc postgresql-doc-16 173s Recommended packages: 173s libjson-xs-perl 173s The following NEW packages will be installed: 173s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 173s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 173s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 173s Need to get 19.0 MB/19.0 MB of archives. 173s After this operation, 63.3 MB of additional disk space will be used. 173s Get:1 /tmp/autopkgtest.UDmZkb/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [704 B] 173s Get:2 http://ftpmaster.internal/ubuntu oracular/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 173s Get:3 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-client-common all 260 [36.4 kB] 173s Get:4 http://ftpmaster.internal/ubuntu oracular/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 174s Get:5 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-common all 260 [162 kB] 174s Get:6 http://ftpmaster.internal/ubuntu oracular/main ppc64el libpq5 ppc64el 16.3-1 [171 kB] 174s Get:7 http://ftpmaster.internal/ubuntu oracular/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1build1 [192 kB] 174s Get:8 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-client-16 ppc64el 16.3-1 [1395 kB] 174s Get:9 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-16 ppc64el 16.3-1 [16.9 MB] 174s Get:10 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql all 16+260 [11.6 kB] 175s Preconfiguring packages ... 175s Fetched 19.0 MB in 1s (14.1 MB/s) 175s Selecting previously unselected package libjson-perl. 175s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 175s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 175s Unpacking libjson-perl (4.10000-1) ... 175s Selecting previously unselected package postgresql-client-common. 175s Preparing to unpack .../1-postgresql-client-common_260_all.deb ... 175s Unpacking postgresql-client-common (260) ... 175s Selecting previously unselected package ssl-cert. 175s Preparing to unpack .../2-ssl-cert_1.1.2ubuntu1_all.deb ... 175s Unpacking ssl-cert (1.1.2ubuntu1) ... 175s Selecting previously unselected package postgresql-common. 175s Preparing to unpack .../3-postgresql-common_260_all.deb ... 175s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 175s Unpacking postgresql-common (260) ... 175s Selecting previously unselected package libpq5:ppc64el. 175s Preparing to unpack .../4-libpq5_16.3-1_ppc64el.deb ... 175s Unpacking libpq5:ppc64el (16.3-1) ... 175s Selecting previously unselected package libxslt1.1:ppc64el. 175s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1build1_ppc64el.deb ... 175s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1build1) ... 175s Selecting previously unselected package postgresql-client-16. 175s Preparing to unpack .../6-postgresql-client-16_16.3-1_ppc64el.deb ... 175s Unpacking postgresql-client-16 (16.3-1) ... 175s Selecting previously unselected package postgresql-16. 175s Preparing to unpack .../7-postgresql-16_16.3-1_ppc64el.deb ... 175s Unpacking postgresql-16 (16.3-1) ... 176s Selecting previously unselected package postgresql. 176s Preparing to unpack .../8-postgresql_16+260_all.deb ... 176s Unpacking postgresql (16+260) ... 176s Selecting previously unselected package autopkgtest-satdep. 176s Preparing to unpack .../9-1-autopkgtest-satdep.deb ... 176s Unpacking autopkgtest-satdep (0) ... 176s Setting up postgresql-client-common (260) ... 176s Setting up libpq5:ppc64el (16.3-1) ... 176s Setting up ssl-cert (1.1.2ubuntu1) ... 176s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 177s Setting up libjson-perl (4.10000-1) ... 177s Setting up libxslt1.1:ppc64el (1.1.39-0exp1build1) ... 177s Setting up postgresql-client-16 (16.3-1) ... 177s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 177s Setting up postgresql-common (260) ... 177s 177s Creating config file /etc/postgresql-common/createcluster.conf with new version 177s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 177s Removing obsolete dictionary files: 178s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 179s Setting up postgresql-16 (16.3-1) ... 179s Creating new PostgreSQL cluster 16/main ... 179s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 179s The files belonging to this database system will be owned by user "postgres". 179s This user must also own the server process. 179s 179s The database cluster will be initialized with locale "C.UTF-8". 179s The default database encoding has accordingly been set to "UTF8". 179s The default text search configuration will be set to "english". 179s 179s Data page checksums are disabled. 179s 179s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 179s creating subdirectories ... ok 179s selecting dynamic shared memory implementation ... posix 179s selecting default max_connections ... 100 179s selecting default shared_buffers ... 128MB 179s selecting default time zone ... Etc/UTC 179s creating configuration files ... ok 179s running bootstrap script ... ok 180s performing post-bootstrap initialization ... ok 180s syncing data to disk ... ok 183s Setting up postgresql (16+260) ... 183s Setting up autopkgtest-satdep (0) ... 183s Processing triggers for man-db (2.12.1-2) ... 185s Processing triggers for libc-bin (2.39-0ubuntu9) ... 189s (Reading database ... 74638 files and directories currently installed.) 189s Removing autopkgtest-satdep (0) ... 190s autopkgtest [08:30:26]: test default-psql: [----------------------- 190s autopkgtest [08:30:26]: test default-psql: -----------------------] 192s autopkgtest [08:30:28]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 192s default-psql PASS 192s autopkgtest [08:30:28]: test run-testsuite: preparing testbed 350s autopkgtest [08:33:06]: testbed dpkg architecture: ppc64el 350s autopkgtest [08:33:06]: testbed apt version: 2.9.5 350s autopkgtest [08:33:06]: @@@@@@@@@@@@@@@@@@@@ test bed setup 351s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 352s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 352s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 352s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 352s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 352s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main ppc64el Packages [107 kB] 352s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted ppc64el Packages [1860 B] 352s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe ppc64el Packages [371 kB] 352s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse ppc64el Packages [2532 B] 352s Fetched 1100 kB in 1s (1309 kB/s) 352s Reading package lists... 354s Reading package lists... 355s Building dependency tree... 355s Reading state information... 355s Calculating upgrade... 355s The following packages will be upgraded: 355s libhogweed6t64 libnettle8t64 355s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 355s Need to get 437 kB of archives. 355s After this operation, 1024 B of additional disk space will be used. 355s Get:1 http://ftpmaster.internal/ubuntu oracular/main ppc64el libnettle8t64 ppc64el 3.10-1 [228 kB] 356s Get:2 http://ftpmaster.internal/ubuntu oracular/main ppc64el libhogweed6t64 ppc64el 3.10-1 [209 kB] 356s Fetched 437 kB in 1s (811 kB/s) 356s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 356s Preparing to unpack .../libnettle8t64_3.10-1_ppc64el.deb ... 356s Unpacking libnettle8t64:ppc64el (3.10-1) over (3.9.1-2.2build1) ... 356s Setting up libnettle8t64:ppc64el (3.10-1) ... 356s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 356s Preparing to unpack .../libhogweed6t64_3.10-1_ppc64el.deb ... 356s Unpacking libhogweed6t64:ppc64el (3.10-1) over (3.9.1-2.2build1) ... 356s Setting up libhogweed6t64:ppc64el (3.10-1) ... 356s Processing triggers for libc-bin (2.39-0ubuntu9) ... 356s Reading package lists... 356s Building dependency tree... 356s Reading state information... 357s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 357s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 358s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 358s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 358s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 359s Reading package lists... 359s Reading package lists... 359s Building dependency tree... 359s Reading state information... 359s Calculating upgrade... 359s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 359s Reading package lists... 359s Building dependency tree... 359s Reading state information... 360s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 364s Reading package lists... 365s Building dependency tree... 365s Reading state information... 365s Starting pkgProblemResolver with broken count: 0 365s Starting 2 pkgProblemResolver with broken count: 0 365s Done 365s The following additional packages will be installed: 365s autoconf automake autopoint autotools-dev build-essential clang-18 cpp 365s cpp-13 cpp-13-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu debhelper 365s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 365s emacsen-common fakeroot g++ g++-13 g++-13-powerpc64le-linux-gnu 365s g++-powerpc64le-linux-gnu gcc gcc-13 gcc-13-base 365s gcc-13-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu gettext 365s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 365s libatomic1 libcc1-0 libclang-common-18-dev libdebhelper-perl libecpg-compat3 365s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 366s libgc1 libgcc-13-dev libgomp1 libicu-dev libisl23 libitm1 libjson-perl 366s liblsan0 libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 366s libpq-dev libpq5 libpython3.12t64 libquadmath0 libssl-dev libstdc++-13-dev 366s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 366s libz3-dev llvm-18 llvm-18-dev llvm-18-linker-tools llvm-18-runtime 366s llvm-18-tools locales-all m4 po-debconf postgresql-16 postgresql-all 366s postgresql-client-16 postgresql-client-common postgresql-common 366s postgresql-doc postgresql-doc-16 postgresql-plperl-16 366s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 366s postgresql-server-dev-all ssl-cert 366s Suggested packages: 366s autoconf-archive gnu-standards autoconf-doc clang-18-doc wasi-libc cpp-doc 366s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 366s gcc-13-doc gcc-multilib manpages-dev flex bison gdb gcc-doc 366s gdb-powerpc64le-linux-gnu gettext-doc libasprintf-dev libgettextpo-dev 366s hunspell openoffice.org-hunspell | openoffice.org-core icu-doc ncurses-doc 366s libssl-doc libstdc++-13-doc tcl8.6 libtool-doc gfortran | fortran95-compiler 366s gcj-jdk pkg-config llvm-18-doc m4-doc libmail-box-perl 366s Recommended packages: 366s libclang-rt-18-dev libarchive-cpio-perl libjson-xs-perl libltdl-dev 366s libmail-sendmail-perl 366s The following NEW packages will be installed: 366s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 366s clang-18 cpp cpp-13 cpp-13-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu 366s debhelper debugedit dh-autoreconf dh-strip-nondeterminism 366s dictionaries-common dwz emacsen-common fakeroot g++ g++-13 366s g++-13-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-13 366s gcc-13-base gcc-13-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu gettext 366s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 366s libatomic1 libcc1-0 libclang-common-18-dev libdebhelper-perl libecpg-compat3 366s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 366s libgc1 libgcc-13-dev libgomp1 libicu-dev libisl23 libitm1 libjson-perl 366s liblsan0 libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 366s libpq-dev libpq5 libpython3.12t64 libquadmath0 libssl-dev libstdc++-13-dev 366s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 366s libz3-dev llvm-18 llvm-18-dev llvm-18-linker-tools llvm-18-runtime 366s llvm-18-tools locales-all m4 po-debconf postgresql-16 postgresql-all 366s postgresql-client-16 postgresql-client-common postgresql-common 366s postgresql-doc postgresql-doc-16 postgresql-plperl-16 366s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 366s postgresql-server-dev-all ssl-cert 366s 0 upgraded, 93 newly installed, 0 to remove and 0 not upgraded. 366s Need to get 198 MB/198 MB of archives. 366s After this operation, 1168 MB of additional disk space will be used. 366s Get:1 /tmp/autopkgtest.UDmZkb/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [800 B] 366s Get:2 http://ftpmaster.internal/ubuntu oracular/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 366s Get:3 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-client-common all 260 [36.4 kB] 366s Get:4 http://ftpmaster.internal/ubuntu oracular/main ppc64el ssl-cert all 1.1.2ubuntu1 [17.8 kB] 366s Get:5 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-common all 260 [162 kB] 366s Get:6 http://ftpmaster.internal/ubuntu oracular/main ppc64el m4 ppc64el 1.4.19-4build1 [278 kB] 366s Get:7 http://ftpmaster.internal/ubuntu oracular/main ppc64el autoconf all 2.71-3 [339 kB] 366s Get:8 http://ftpmaster.internal/ubuntu oracular/main ppc64el autotools-dev all 20220109.1 [44.9 kB] 366s Get:9 http://ftpmaster.internal/ubuntu oracular/main ppc64el automake all 1:1.16.5-1.3ubuntu1 [558 kB] 366s Get:10 http://ftpmaster.internal/ubuntu oracular/main ppc64el autopoint all 0.21-14ubuntu2 [422 kB] 366s Get:11 http://ftpmaster.internal/ubuntu oracular/main ppc64el gcc-13-base ppc64el 13.2.0-23ubuntu4 [49.0 kB] 366s Get:12 http://ftpmaster.internal/ubuntu oracular/main ppc64el libisl23 ppc64el 0.26-3build1 [886 kB] 366s Get:13 http://ftpmaster.internal/ubuntu oracular/main ppc64el libmpc3 ppc64el 1.3.1-1build1 [62.1 kB] 366s Get:14 http://ftpmaster.internal/ubuntu oracular/main ppc64el cpp-13-powerpc64le-linux-gnu ppc64el 13.2.0-23ubuntu4 [10.7 MB] 367s Get:15 http://ftpmaster.internal/ubuntu oracular/main ppc64el cpp-13 ppc64el 13.2.0-23ubuntu4 [1038 B] 367s Get:16 http://ftpmaster.internal/ubuntu oracular/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [5330 B] 367s Get:17 http://ftpmaster.internal/ubuntu oracular/main ppc64el cpp ppc64el 4:13.2.0-7ubuntu1 [22.5 kB] 367s Get:18 http://ftpmaster.internal/ubuntu oracular/main ppc64el libcc1-0 ppc64el 14.1.0-1ubuntu1 [48.1 kB] 367s Get:19 http://ftpmaster.internal/ubuntu oracular/main ppc64el libgomp1 ppc64el 14.1.0-1ubuntu1 [161 kB] 367s Get:20 http://ftpmaster.internal/ubuntu oracular/main ppc64el libitm1 ppc64el 14.1.0-1ubuntu1 [32.4 kB] 367s Get:21 http://ftpmaster.internal/ubuntu oracular/main ppc64el libatomic1 ppc64el 14.1.0-1ubuntu1 [10.7 kB] 367s Get:22 http://ftpmaster.internal/ubuntu oracular/main ppc64el libasan8 ppc64el 14.1.0-1ubuntu1 [2971 kB] 367s Get:23 http://ftpmaster.internal/ubuntu oracular/main ppc64el liblsan0 ppc64el 14.1.0-1ubuntu1 [1328 kB] 367s Get:24 http://ftpmaster.internal/ubuntu oracular/main ppc64el libtsan2 ppc64el 14.1.0-1ubuntu1 [2708 kB] 367s Get:25 http://ftpmaster.internal/ubuntu oracular/main ppc64el libubsan1 ppc64el 14.1.0-1ubuntu1 [1196 kB] 367s Get:26 http://ftpmaster.internal/ubuntu oracular/main ppc64el libquadmath0 ppc64el 14.1.0-1ubuntu1 [158 kB] 367s Get:27 http://ftpmaster.internal/ubuntu oracular/main ppc64el libgcc-13-dev ppc64el 13.2.0-23ubuntu4 [1580 kB] 367s Get:28 http://ftpmaster.internal/ubuntu oracular/main ppc64el gcc-13-powerpc64le-linux-gnu ppc64el 13.2.0-23ubuntu4 [20.6 MB] 368s Get:29 http://ftpmaster.internal/ubuntu oracular/main ppc64el gcc-13 ppc64el 13.2.0-23ubuntu4 [482 kB] 368s Get:30 http://ftpmaster.internal/ubuntu oracular/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [1224 B] 368s Get:31 http://ftpmaster.internal/ubuntu oracular/main ppc64el gcc ppc64el 4:13.2.0-7ubuntu1 [5022 B] 368s Get:32 http://ftpmaster.internal/ubuntu oracular/main ppc64el libstdc++-13-dev ppc64el 13.2.0-23ubuntu4 [2512 kB] 368s Get:33 http://ftpmaster.internal/ubuntu oracular/main ppc64el g++-13-powerpc64le-linux-gnu ppc64el 13.2.0-23ubuntu4 [12.2 MB] 368s Get:34 http://ftpmaster.internal/ubuntu oracular/main ppc64el g++-13 ppc64el 13.2.0-23ubuntu4 [14.5 kB] 368s Get:35 http://ftpmaster.internal/ubuntu oracular/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:13.2.0-7ubuntu1 [968 B] 368s Get:36 http://ftpmaster.internal/ubuntu oracular/main ppc64el g++ ppc64el 4:13.2.0-7ubuntu1 [1086 B] 368s Get:37 http://ftpmaster.internal/ubuntu oracular/main ppc64el build-essential ppc64el 12.10ubuntu1 [4936 B] 368s Get:38 http://ftpmaster.internal/ubuntu oracular/main ppc64el libgc1 ppc64el 1:8.2.6-1build1 [114 kB] 368s Get:39 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libobjc4 ppc64el 14.1.0-1ubuntu1 [52.7 kB] 368s Get:40 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libobjc-13-dev ppc64el 13.2.0-23ubuntu4 [202 kB] 368s Get:41 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libclang-common-18-dev ppc64el 1:18.1.7-1 [735 kB] 368s Get:42 http://ftpmaster.internal/ubuntu oracular/universe ppc64el llvm-18-linker-tools ppc64el 1:18.1.7-1 [1363 kB] 368s Get:43 http://ftpmaster.internal/ubuntu oracular/universe ppc64el clang-18 ppc64el 1:18.1.7-1 [83.2 kB] 368s Get:44 http://ftpmaster.internal/ubuntu oracular/main ppc64el libdebhelper-perl all 13.15.3ubuntu2 [92.3 kB] 368s Get:45 http://ftpmaster.internal/ubuntu oracular/main ppc64el libtool all 2.4.7-7build1 [166 kB] 368s Get:46 http://ftpmaster.internal/ubuntu oracular/main ppc64el dh-autoreconf all 20 [16.1 kB] 368s Get:47 http://ftpmaster.internal/ubuntu oracular/main ppc64el libarchive-zip-perl all 1.68-1 [90.2 kB] 368s Get:48 http://ftpmaster.internal/ubuntu oracular/main ppc64el libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 368s Get:49 http://ftpmaster.internal/ubuntu oracular/main ppc64el dh-strip-nondeterminism all 1.14.0-1 [5058 B] 368s Get:50 http://ftpmaster.internal/ubuntu oracular/main ppc64el debugedit ppc64el 1:5.0-5build2 [51.4 kB] 368s Get:51 http://ftpmaster.internal/ubuntu oracular/main ppc64el dwz ppc64el 0.15-1build6 [142 kB] 368s Get:52 http://ftpmaster.internal/ubuntu oracular/main ppc64el gettext ppc64el 0.21-14ubuntu2 [985 kB] 368s Get:53 http://ftpmaster.internal/ubuntu oracular/main ppc64el intltool-debian all 0.35.0+20060710.6 [23.2 kB] 368s Get:54 http://ftpmaster.internal/ubuntu oracular/main ppc64el po-debconf all 1.0.21+nmu1 [233 kB] 368s Get:55 http://ftpmaster.internal/ubuntu oracular/main ppc64el debhelper all 13.15.3ubuntu2 [878 kB] 368s Get:56 http://ftpmaster.internal/ubuntu oracular/main ppc64el emacsen-common all 3.0.5 [12.1 kB] 368s Get:57 http://ftpmaster.internal/ubuntu oracular/main ppc64el dictionaries-common all 1.29.7 [188 kB] 368s Get:58 http://ftpmaster.internal/ubuntu oracular-proposed/main ppc64el libfakeroot ppc64el 1.35.1-1 [35.2 kB] 368s Get:59 http://ftpmaster.internal/ubuntu oracular-proposed/main ppc64el fakeroot ppc64el 1.35.1-1 [70.0 kB] 368s Get:60 http://ftpmaster.internal/ubuntu oracular/main ppc64el hunspell-en-us all 1:2020.12.07-2 [280 kB] 368s Get:61 http://ftpmaster.internal/ubuntu oracular/main ppc64el icu-devtools ppc64el 74.2-1ubuntu3 [247 kB] 368s Get:62 http://ftpmaster.internal/ubuntu oracular/main ppc64el libpgtypes3 ppc64el 16.3-1 [49.4 kB] 369s Get:63 http://ftpmaster.internal/ubuntu oracular/main ppc64el libpq5 ppc64el 16.3-1 [171 kB] 369s Get:64 http://ftpmaster.internal/ubuntu oracular/main ppc64el libecpg6 ppc64el 16.3-1 [55.2 kB] 369s Get:65 http://ftpmaster.internal/ubuntu oracular/main ppc64el libecpg-compat3 ppc64el 16.3-1 [19.5 kB] 369s Get:66 http://ftpmaster.internal/ubuntu oracular/main ppc64el libssl-dev ppc64el 3.0.13-0ubuntu4 [2648 kB] 369s Get:67 http://ftpmaster.internal/ubuntu oracular/main ppc64el libpq-dev ppc64el 16.3-1 [171 kB] 369s Get:68 http://ftpmaster.internal/ubuntu oracular/main ppc64el libecpg-dev ppc64el 16.3-1 [280 kB] 369s Get:69 http://ftpmaster.internal/ubuntu oracular/main ppc64el libicu-dev ppc64el 74.2-1ubuntu3 [12.5 MB] 369s Get:70 http://ftpmaster.internal/ubuntu oracular/main ppc64el libncurses-dev ppc64el 6.5-2 [480 kB] 369s Get:71 http://ftpmaster.internal/ubuntu oracular/main ppc64el libpython3.12t64 ppc64el 3.12.4-1 [2542 kB] 369s Get:72 http://ftpmaster.internal/ubuntu oracular/main ppc64el libtcl8.6 ppc64el 8.6.14+dfsg-1build1 [1204 kB] 369s Get:73 http://ftpmaster.internal/ubuntu oracular/main ppc64el libxml2-dev ppc64el 2.9.14+dfsg-1.3ubuntu3 [923 kB] 369s Get:74 http://ftpmaster.internal/ubuntu oracular/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1build1 [192 kB] 369s Get:75 http://ftpmaster.internal/ubuntu oracular/universe ppc64el llvm-18-runtime ppc64el 1:18.1.7-1 [574 kB] 369s Get:76 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libpfm4 ppc64el 4.13.0+git32-g0d4ed0e-1 [189 kB] 369s Get:77 http://ftpmaster.internal/ubuntu oracular/universe ppc64el llvm-18 ppc64el 1:18.1.7-1 [27.0 MB] 370s Get:78 http://ftpmaster.internal/ubuntu oracular/main ppc64el libffi-dev ppc64el 3.4.6-1build1 [67.5 kB] 370s Get:79 http://ftpmaster.internal/ubuntu oracular/universe ppc64el llvm-18-tools ppc64el 1:18.1.7-1 [611 kB] 370s Get:80 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libz3-4 ppc64el 4.8.12-3.1build1 [6167 kB] 370s Get:81 http://ftpmaster.internal/ubuntu oracular/universe ppc64el libz3-dev ppc64el 4.8.12-3.1build1 [72.2 kB] 370s Get:82 http://ftpmaster.internal/ubuntu oracular/universe ppc64el llvm-18-dev ppc64el 1:18.1.7-1 [43.2 MB] 371s Get:83 http://ftpmaster.internal/ubuntu oracular/universe ppc64el locales-all ppc64el 2.39-0ubuntu9 [11.0 MB] 372s Get:84 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-client-16 ppc64el 16.3-1 [1395 kB] 372s Get:85 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-16 ppc64el 16.3-1 [16.9 MB] 372s Get:86 http://ftpmaster.internal/ubuntu oracular/universe ppc64el postgresql-server-dev-16 ppc64el 16.3-1 [1267 kB] 372s Get:87 http://ftpmaster.internal/ubuntu oracular/universe ppc64el postgresql-server-dev-all ppc64el 260 [20.6 kB] 372s Get:88 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-plperl-16 ppc64el 16.3-1 [76.2 kB] 372s Get:89 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-plpython3-16 ppc64el 16.3-1 [78.6 kB] 372s Get:90 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-pltcl-16 ppc64el 16.3-1 [31.6 kB] 372s Get:91 http://ftpmaster.internal/ubuntu oracular/universe ppc64el postgresql-all all 260 [1712 B] 372s Get:92 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-doc-16 all 16.3-1 [2098 kB] 373s Get:93 http://ftpmaster.internal/ubuntu oracular/main ppc64el postgresql-doc all 16+260 [11.6 kB] 373s Preconfiguring packages ... 373s Fetched 198 MB in 7s (28.4 MB/s) 373s Selecting previously unselected package libjson-perl. 373s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72697 files and directories currently installed.) 373s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 373s Unpacking libjson-perl (4.10000-1) ... 373s Selecting previously unselected package postgresql-client-common. 373s Preparing to unpack .../01-postgresql-client-common_260_all.deb ... 373s Unpacking postgresql-client-common (260) ... 373s Selecting previously unselected package ssl-cert. 373s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 373s Unpacking ssl-cert (1.1.2ubuntu1) ... 373s Selecting previously unselected package postgresql-common. 373s Preparing to unpack .../03-postgresql-common_260_all.deb ... 373s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 373s Unpacking postgresql-common (260) ... 373s Selecting previously unselected package m4. 373s Preparing to unpack .../04-m4_1.4.19-4build1_ppc64el.deb ... 373s Unpacking m4 (1.4.19-4build1) ... 373s Selecting previously unselected package autoconf. 373s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 373s Unpacking autoconf (2.71-3) ... 373s Selecting previously unselected package autotools-dev. 373s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 373s Unpacking autotools-dev (20220109.1) ... 373s Selecting previously unselected package automake. 373s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 373s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 373s Selecting previously unselected package autopoint. 373s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 373s Unpacking autopoint (0.21-14ubuntu2) ... 373s Selecting previously unselected package gcc-13-base:ppc64el. 373s Preparing to unpack .../09-gcc-13-base_13.2.0-23ubuntu4_ppc64el.deb ... 373s Unpacking gcc-13-base:ppc64el (13.2.0-23ubuntu4) ... 373s Selecting previously unselected package libisl23:ppc64el. 373s Preparing to unpack .../10-libisl23_0.26-3build1_ppc64el.deb ... 373s Unpacking libisl23:ppc64el (0.26-3build1) ... 374s Selecting previously unselected package libmpc3:ppc64el. 374s Preparing to unpack .../11-libmpc3_1.3.1-1build1_ppc64el.deb ... 374s Unpacking libmpc3:ppc64el (1.3.1-1build1) ... 374s Selecting previously unselected package cpp-13-powerpc64le-linux-gnu. 374s Preparing to unpack .../12-cpp-13-powerpc64le-linux-gnu_13.2.0-23ubuntu4_ppc64el.deb ... 374s Unpacking cpp-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 374s Selecting previously unselected package cpp-13. 374s Preparing to unpack .../13-cpp-13_13.2.0-23ubuntu4_ppc64el.deb ... 374s Unpacking cpp-13 (13.2.0-23ubuntu4) ... 374s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 374s Preparing to unpack .../14-cpp-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 374s Unpacking cpp-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 374s Selecting previously unselected package cpp. 374s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 374s Unpacking cpp (4:13.2.0-7ubuntu1) ... 374s Selecting previously unselected package libcc1-0:ppc64el. 374s Preparing to unpack .../16-libcc1-0_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libcc1-0:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libgomp1:ppc64el. 374s Preparing to unpack .../17-libgomp1_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libgomp1:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libitm1:ppc64el. 374s Preparing to unpack .../18-libitm1_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libitm1:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libatomic1:ppc64el. 374s Preparing to unpack .../19-libatomic1_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libatomic1:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libasan8:ppc64el. 374s Preparing to unpack .../20-libasan8_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libasan8:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package liblsan0:ppc64el. 374s Preparing to unpack .../21-liblsan0_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking liblsan0:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libtsan2:ppc64el. 374s Preparing to unpack .../22-libtsan2_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libtsan2:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libubsan1:ppc64el. 374s Preparing to unpack .../23-libubsan1_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libubsan1:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libquadmath0:ppc64el. 374s Preparing to unpack .../24-libquadmath0_14.1.0-1ubuntu1_ppc64el.deb ... 374s Unpacking libquadmath0:ppc64el (14.1.0-1ubuntu1) ... 374s Selecting previously unselected package libgcc-13-dev:ppc64el. 374s Preparing to unpack .../25-libgcc-13-dev_13.2.0-23ubuntu4_ppc64el.deb ... 374s Unpacking libgcc-13-dev:ppc64el (13.2.0-23ubuntu4) ... 374s Selecting previously unselected package gcc-13-powerpc64le-linux-gnu. 374s Preparing to unpack .../26-gcc-13-powerpc64le-linux-gnu_13.2.0-23ubuntu4_ppc64el.deb ... 374s Unpacking gcc-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 375s Selecting previously unselected package gcc-13. 375s Preparing to unpack .../27-gcc-13_13.2.0-23ubuntu4_ppc64el.deb ... 375s Unpacking gcc-13 (13.2.0-23ubuntu4) ... 375s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 375s Preparing to unpack .../28-gcc-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 375s Unpacking gcc-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 375s Selecting previously unselected package gcc. 375s Preparing to unpack .../29-gcc_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 375s Unpacking gcc (4:13.2.0-7ubuntu1) ... 375s Selecting previously unselected package libstdc++-13-dev:ppc64el. 375s Preparing to unpack .../30-libstdc++-13-dev_13.2.0-23ubuntu4_ppc64el.deb ... 375s Unpacking libstdc++-13-dev:ppc64el (13.2.0-23ubuntu4) ... 375s Selecting previously unselected package g++-13-powerpc64le-linux-gnu. 375s Preparing to unpack .../31-g++-13-powerpc64le-linux-gnu_13.2.0-23ubuntu4_ppc64el.deb ... 375s Unpacking g++-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 376s Selecting previously unselected package g++-13. 376s Preparing to unpack .../32-g++-13_13.2.0-23ubuntu4_ppc64el.deb ... 376s Unpacking g++-13 (13.2.0-23ubuntu4) ... 376s Selecting previously unselected package g++-powerpc64le-linux-gnu. 376s Preparing to unpack .../33-g++-powerpc64le-linux-gnu_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 376s Unpacking g++-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 376s Selecting previously unselected package g++. 376s Preparing to unpack .../34-g++_4%3a13.2.0-7ubuntu1_ppc64el.deb ... 376s Unpacking g++ (4:13.2.0-7ubuntu1) ... 376s Selecting previously unselected package build-essential. 376s Preparing to unpack .../35-build-essential_12.10ubuntu1_ppc64el.deb ... 376s Unpacking build-essential (12.10ubuntu1) ... 376s Selecting previously unselected package libgc1:ppc64el. 376s Preparing to unpack .../36-libgc1_1%3a8.2.6-1build1_ppc64el.deb ... 376s Unpacking libgc1:ppc64el (1:8.2.6-1build1) ... 376s Selecting previously unselected package libobjc4:ppc64el. 376s Preparing to unpack .../37-libobjc4_14.1.0-1ubuntu1_ppc64el.deb ... 376s Unpacking libobjc4:ppc64el (14.1.0-1ubuntu1) ... 376s Selecting previously unselected package libobjc-13-dev:ppc64el. 376s Preparing to unpack .../38-libobjc-13-dev_13.2.0-23ubuntu4_ppc64el.deb ... 376s Unpacking libobjc-13-dev:ppc64el (13.2.0-23ubuntu4) ... 376s Selecting previously unselected package libclang-common-18-dev:ppc64el. 376s Preparing to unpack .../39-libclang-common-18-dev_1%3a18.1.7-1_ppc64el.deb ... 376s Unpacking libclang-common-18-dev:ppc64el (1:18.1.7-1) ... 376s Selecting previously unselected package llvm-18-linker-tools. 376s Preparing to unpack .../40-llvm-18-linker-tools_1%3a18.1.7-1_ppc64el.deb ... 376s Unpacking llvm-18-linker-tools (1:18.1.7-1) ... 376s Selecting previously unselected package clang-18. 376s Preparing to unpack .../41-clang-18_1%3a18.1.7-1_ppc64el.deb ... 376s Unpacking clang-18 (1:18.1.7-1) ... 376s Selecting previously unselected package libdebhelper-perl. 376s Preparing to unpack .../42-libdebhelper-perl_13.15.3ubuntu2_all.deb ... 376s Unpacking libdebhelper-perl (13.15.3ubuntu2) ... 376s Selecting previously unselected package libtool. 376s Preparing to unpack .../43-libtool_2.4.7-7build1_all.deb ... 376s Unpacking libtool (2.4.7-7build1) ... 376s Selecting previously unselected package dh-autoreconf. 376s Preparing to unpack .../44-dh-autoreconf_20_all.deb ... 376s Unpacking dh-autoreconf (20) ... 376s Selecting previously unselected package libarchive-zip-perl. 376s Preparing to unpack .../45-libarchive-zip-perl_1.68-1_all.deb ... 376s Unpacking libarchive-zip-perl (1.68-1) ... 376s Selecting previously unselected package libfile-stripnondeterminism-perl. 376s Preparing to unpack .../46-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 376s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 376s Selecting previously unselected package dh-strip-nondeterminism. 376s Preparing to unpack .../47-dh-strip-nondeterminism_1.14.0-1_all.deb ... 376s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 376s Selecting previously unselected package debugedit. 376s Preparing to unpack .../48-debugedit_1%3a5.0-5build2_ppc64el.deb ... 376s Unpacking debugedit (1:5.0-5build2) ... 376s Selecting previously unselected package dwz. 376s Preparing to unpack .../49-dwz_0.15-1build6_ppc64el.deb ... 376s Unpacking dwz (0.15-1build6) ... 376s Selecting previously unselected package gettext. 376s Preparing to unpack .../50-gettext_0.21-14ubuntu2_ppc64el.deb ... 376s Unpacking gettext (0.21-14ubuntu2) ... 376s Selecting previously unselected package intltool-debian. 376s Preparing to unpack .../51-intltool-debian_0.35.0+20060710.6_all.deb ... 376s Unpacking intltool-debian (0.35.0+20060710.6) ... 376s Selecting previously unselected package po-debconf. 376s Preparing to unpack .../52-po-debconf_1.0.21+nmu1_all.deb ... 376s Unpacking po-debconf (1.0.21+nmu1) ... 376s Selecting previously unselected package debhelper. 376s Preparing to unpack .../53-debhelper_13.15.3ubuntu2_all.deb ... 376s Unpacking debhelper (13.15.3ubuntu2) ... 376s Selecting previously unselected package emacsen-common. 376s Preparing to unpack .../54-emacsen-common_3.0.5_all.deb ... 376s Unpacking emacsen-common (3.0.5) ... 376s Selecting previously unselected package dictionaries-common. 376s Preparing to unpack .../55-dictionaries-common_1.29.7_all.deb ... 376s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 376s Unpacking dictionaries-common (1.29.7) ... 376s Selecting previously unselected package libfakeroot:ppc64el. 376s Preparing to unpack .../56-libfakeroot_1.35.1-1_ppc64el.deb ... 376s Unpacking libfakeroot:ppc64el (1.35.1-1) ... 376s Selecting previously unselected package fakeroot. 376s Preparing to unpack .../57-fakeroot_1.35.1-1_ppc64el.deb ... 376s Unpacking fakeroot (1.35.1-1) ... 376s Selecting previously unselected package hunspell-en-us. 377s Preparing to unpack .../58-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 377s Unpacking hunspell-en-us (1:2020.12.07-2) ... 377s Selecting previously unselected package icu-devtools. 377s Preparing to unpack .../59-icu-devtools_74.2-1ubuntu3_ppc64el.deb ... 377s Unpacking icu-devtools (74.2-1ubuntu3) ... 377s Selecting previously unselected package libpgtypes3:ppc64el. 377s Preparing to unpack .../60-libpgtypes3_16.3-1_ppc64el.deb ... 377s Unpacking libpgtypes3:ppc64el (16.3-1) ... 377s Selecting previously unselected package libpq5:ppc64el. 377s Preparing to unpack .../61-libpq5_16.3-1_ppc64el.deb ... 377s Unpacking libpq5:ppc64el (16.3-1) ... 377s Selecting previously unselected package libecpg6:ppc64el. 377s Preparing to unpack .../62-libecpg6_16.3-1_ppc64el.deb ... 377s Unpacking libecpg6:ppc64el (16.3-1) ... 377s Selecting previously unselected package libecpg-compat3:ppc64el. 377s Preparing to unpack .../63-libecpg-compat3_16.3-1_ppc64el.deb ... 377s Unpacking libecpg-compat3:ppc64el (16.3-1) ... 377s Selecting previously unselected package libssl-dev:ppc64el. 377s Preparing to unpack .../64-libssl-dev_3.0.13-0ubuntu4_ppc64el.deb ... 377s Unpacking libssl-dev:ppc64el (3.0.13-0ubuntu4) ... 377s Selecting previously unselected package libpq-dev. 377s Preparing to unpack .../65-libpq-dev_16.3-1_ppc64el.deb ... 377s Unpacking libpq-dev (16.3-1) ... 377s Selecting previously unselected package libecpg-dev. 377s Preparing to unpack .../66-libecpg-dev_16.3-1_ppc64el.deb ... 377s Unpacking libecpg-dev (16.3-1) ... 377s Selecting previously unselected package libicu-dev:ppc64el. 377s Preparing to unpack .../67-libicu-dev_74.2-1ubuntu3_ppc64el.deb ... 377s Unpacking libicu-dev:ppc64el (74.2-1ubuntu3) ... 377s Selecting previously unselected package libncurses-dev:ppc64el. 377s Preparing to unpack .../68-libncurses-dev_6.5-2_ppc64el.deb ... 377s Unpacking libncurses-dev:ppc64el (6.5-2) ... 377s Selecting previously unselected package libpython3.12t64:ppc64el. 377s Preparing to unpack .../69-libpython3.12t64_3.12.4-1_ppc64el.deb ... 377s Unpacking libpython3.12t64:ppc64el (3.12.4-1) ... 377s Selecting previously unselected package libtcl8.6:ppc64el. 377s Preparing to unpack .../70-libtcl8.6_8.6.14+dfsg-1build1_ppc64el.deb ... 377s Unpacking libtcl8.6:ppc64el (8.6.14+dfsg-1build1) ... 377s Selecting previously unselected package libxml2-dev:ppc64el. 377s Preparing to unpack .../71-libxml2-dev_2.9.14+dfsg-1.3ubuntu3_ppc64el.deb ... 377s Unpacking libxml2-dev:ppc64el (2.9.14+dfsg-1.3ubuntu3) ... 378s Selecting previously unselected package libxslt1.1:ppc64el. 378s Preparing to unpack .../72-libxslt1.1_1.1.39-0exp1build1_ppc64el.deb ... 378s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1build1) ... 378s Selecting previously unselected package llvm-18-runtime. 378s Preparing to unpack .../73-llvm-18-runtime_1%3a18.1.7-1_ppc64el.deb ... 378s Unpacking llvm-18-runtime (1:18.1.7-1) ... 378s Selecting previously unselected package libpfm4:ppc64el. 378s Preparing to unpack .../74-libpfm4_4.13.0+git32-g0d4ed0e-1_ppc64el.deb ... 378s Unpacking libpfm4:ppc64el (4.13.0+git32-g0d4ed0e-1) ... 378s Selecting previously unselected package llvm-18. 378s Preparing to unpack .../75-llvm-18_1%3a18.1.7-1_ppc64el.deb ... 378s Unpacking llvm-18 (1:18.1.7-1) ... 379s Selecting previously unselected package libffi-dev:ppc64el. 379s Preparing to unpack .../76-libffi-dev_3.4.6-1build1_ppc64el.deb ... 379s Unpacking libffi-dev:ppc64el (3.4.6-1build1) ... 379s Selecting previously unselected package llvm-18-tools. 379s Preparing to unpack .../77-llvm-18-tools_1%3a18.1.7-1_ppc64el.deb ... 379s Unpacking llvm-18-tools (1:18.1.7-1) ... 379s Selecting previously unselected package libz3-4:ppc64el. 379s Preparing to unpack .../78-libz3-4_4.8.12-3.1build1_ppc64el.deb ... 379s Unpacking libz3-4:ppc64el (4.8.12-3.1build1) ... 379s Selecting previously unselected package libz3-dev:ppc64el. 379s Preparing to unpack .../79-libz3-dev_4.8.12-3.1build1_ppc64el.deb ... 379s Unpacking libz3-dev:ppc64el (4.8.12-3.1build1) ... 379s Selecting previously unselected package llvm-18-dev. 379s Preparing to unpack .../80-llvm-18-dev_1%3a18.1.7-1_ppc64el.deb ... 379s Unpacking llvm-18-dev (1:18.1.7-1) ... 381s Selecting previously unselected package locales-all. 381s Preparing to unpack .../81-locales-all_2.39-0ubuntu9_ppc64el.deb ... 381s Unpacking locales-all (2.39-0ubuntu9) ... 385s Selecting previously unselected package postgresql-client-16. 385s Preparing to unpack .../82-postgresql-client-16_16.3-1_ppc64el.deb ... 385s Unpacking postgresql-client-16 (16.3-1) ... 385s Selecting previously unselected package postgresql-16. 385s Preparing to unpack .../83-postgresql-16_16.3-1_ppc64el.deb ... 385s Unpacking postgresql-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-server-dev-16. 386s Preparing to unpack .../84-postgresql-server-dev-16_16.3-1_ppc64el.deb ... 386s Unpacking postgresql-server-dev-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-server-dev-all:ppc64el. 386s Preparing to unpack .../85-postgresql-server-dev-all_260_ppc64el.deb ... 386s Unpacking postgresql-server-dev-all:ppc64el (260) ... 386s Selecting previously unselected package postgresql-plperl-16. 386s Preparing to unpack .../86-postgresql-plperl-16_16.3-1_ppc64el.deb ... 386s Unpacking postgresql-plperl-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-plpython3-16. 386s Preparing to unpack .../87-postgresql-plpython3-16_16.3-1_ppc64el.deb ... 386s Unpacking postgresql-plpython3-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-pltcl-16. 386s Preparing to unpack .../88-postgresql-pltcl-16_16.3-1_ppc64el.deb ... 386s Unpacking postgresql-pltcl-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-all. 386s Preparing to unpack .../89-postgresql-all_260_all.deb ... 386s Unpacking postgresql-all (260) ... 386s Selecting previously unselected package postgresql-doc-16. 386s Preparing to unpack .../90-postgresql-doc-16_16.3-1_all.deb ... 386s Unpacking postgresql-doc-16 (16.3-1) ... 386s Selecting previously unselected package postgresql-doc. 386s Preparing to unpack .../91-postgresql-doc_16+260_all.deb ... 386s Unpacking postgresql-doc (16+260) ... 386s Selecting previously unselected package autopkgtest-satdep. 386s Preparing to unpack .../92-2-autopkgtest-satdep.deb ... 386s Unpacking autopkgtest-satdep (0) ... 386s Setting up postgresql-client-common (260) ... 386s Setting up libpgtypes3:ppc64el (16.3-1) ... 386s Setting up libncurses-dev:ppc64el (6.5-2) ... 386s Setting up postgresql-doc-16 (16.3-1) ... 386s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 386s Setting up libarchive-zip-perl (1.68-1) ... 386s Setting up libdebhelper-perl (13.15.3ubuntu2) ... 386s Setting up libpq5:ppc64el (16.3-1) ... 386s Setting up m4 (1.4.19-4build1) ... 386s Setting up llvm-18-tools (1:18.1.7-1) ... 386s Setting up libgomp1:ppc64el (14.1.0-1ubuntu1) ... 386s Setting up libffi-dev:ppc64el (3.4.6-1build1) ... 386s Setting up locales-all (2.39-0ubuntu9) ... 386s Setting up libfakeroot:ppc64el (1.35.1-1) ... 386s Setting up fakeroot (1.35.1-1) ... 386s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 386s Setting up libpython3.12t64:ppc64el (3.12.4-1) ... 386s Setting up autotools-dev (20220109.1) ... 386s Setting up libz3-4:ppc64el (4.8.12-3.1build1) ... 387s Setting up libpfm4:ppc64el (4.13.0+git32-g0d4ed0e-1) ... 387s Setting up gcc-13-base:ppc64el (13.2.0-23ubuntu4) ... 387s Setting up emacsen-common (3.0.5) ... 387s Setting up ssl-cert (1.1.2ubuntu1) ... 387s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 388s Setting up libquadmath0:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up libssl-dev:ppc64el (3.0.13-0ubuntu4) ... 388s Setting up libmpc3:ppc64el (1.3.1-1build1) ... 388s Setting up libatomic1:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up libtcl8.6:ppc64el (8.6.14+dfsg-1build1) ... 388s Setting up autopoint (0.21-14ubuntu2) ... 388s Setting up icu-devtools (74.2-1ubuntu3) ... 388s Setting up libclang-common-18-dev:ppc64el (1:18.1.7-1) ... 388s Setting up libgc1:ppc64el (1:8.2.6-1build1) ... 388s Setting up autoconf (2.71-3) ... 388s Setting up llvm-18-linker-tools (1:18.1.7-1) ... 388s Setting up libubsan1:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up dwz (0.15-1build6) ... 388s Setting up libasan8:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up libjson-perl (4.10000-1) ... 388s Setting up postgresql-doc (16+260) ... 388s Setting up libxslt1.1:ppc64el (1.1.39-0exp1build1) ... 388s Setting up debugedit (1:5.0-5build2) ... 388s Setting up libecpg6:ppc64el (16.3-1) ... 388s Setting up libtsan2:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up libisl23:ppc64el (0.26-3build1) ... 388s Setting up cpp-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 388s Setting up llvm-18-runtime (1:18.1.7-1) ... 388s Setting up libicu-dev:ppc64el (74.2-1ubuntu3) ... 388s Setting up libcc1-0:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up liblsan0:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up libitm1:ppc64el (14.1.0-1ubuntu1) ... 388s Setting up cpp-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 388s Setting up automake (1:1.16.5-1.3ubuntu1) ... 388s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 388s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 388s Setting up libz3-dev:ppc64el (4.8.12-3.1build1) ... 388s Setting up gettext (0.21-14ubuntu2) ... 388s Setting up libecpg-compat3:ppc64el (16.3-1) ... 388s Setting up cpp-13 (13.2.0-23ubuntu4) ... 388s Setting up dictionaries-common (1.29.7) ... 388s Setting up postgresql-client-16 (16.3-1) ... 388s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 388s Setting up libpq-dev (16.3-1) ... 388s Setting up libobjc4:ppc64el (14.1.0-1ubuntu1) ... 389s Setting up libecpg-dev (16.3-1) ... 389s Setting up intltool-debian (0.35.0+20060710.6) ... 389s Setting up libxml2-dev:ppc64el (2.9.14+dfsg-1.3ubuntu3) ... 389s Setting up postgresql-common (260) ... 389s 389s Creating config file /etc/postgresql-common/createcluster.conf with new version 389s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 389s en_us 389s Removing obsolete dictionary files: 390s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 391s Setting up dh-strip-nondeterminism (1.14.0-1) ... 391s Setting up libgcc-13-dev:ppc64el (13.2.0-23ubuntu4) ... 391s Setting up llvm-18 (1:18.1.7-1) ... 391s Setting up cpp (4:13.2.0-7ubuntu1) ... 391s Setting up hunspell-en-us (1:2020.12.07-2) ... 391s Setting up libobjc-13-dev:ppc64el (13.2.0-23ubuntu4) ... 391s Setting up libstdc++-13-dev:ppc64el (13.2.0-23ubuntu4) ... 391s Setting up llvm-18-dev (1:18.1.7-1) ... 391s Setting up postgresql-16 (16.3-1) ... 391s Creating new PostgreSQL cluster 16/main ... 391s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 391s The files belonging to this database system will be owned by user "postgres". 391s This user must also own the server process. 391s 391s The database cluster will be initialized with locale "C.UTF-8". 391s The default database encoding has accordingly been set to "UTF8". 391s The default text search configuration will be set to "english". 391s 391s Data page checksums are disabled. 391s 391s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 391s creating subdirectories ... ok 391s selecting dynamic shared memory implementation ... posix 391s selecting default max_connections ... 100 391s selecting default shared_buffers ... 128MB 391s selecting default time zone ... Etc/UTC 391s creating configuration files ... ok 391s running bootstrap script ... ok 392s performing post-bootstrap initialization ... ok 392s syncing data to disk ... ok 395s Setting up po-debconf (1.0.21+nmu1) ... 395s Setting up clang-18 (1:18.1.7-1) ... 395s Setting up gcc-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 395s Setting up gcc-13 (13.2.0-23ubuntu4) ... 395s Setting up postgresql-server-dev-16 (16.3-1) ... 395s Setting up postgresql-plpython3-16 (16.3-1) ... 395s Setting up postgresql-plperl-16 (16.3-1) ... 395s Setting up postgresql-server-dev-all:ppc64el (260) ... 395s Setting up postgresql-pltcl-16 (16.3-1) ... 395s Setting up libtool (2.4.7-7build1) ... 395s Setting up postgresql-all (260) ... 395s Setting up g++-13-powerpc64le-linux-gnu (13.2.0-23ubuntu4) ... 395s Setting up dh-autoreconf (20) ... 395s Setting up gcc-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 395s Setting up g++-powerpc64le-linux-gnu (4:13.2.0-7ubuntu1) ... 395s Setting up g++-13 (13.2.0-23ubuntu4) ... 395s Setting up debhelper (13.15.3ubuntu2) ... 395s Setting up gcc (4:13.2.0-7ubuntu1) ... 395s Setting up g++ (4:13.2.0-7ubuntu1) ... 395s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 395s Setting up build-essential (12.10ubuntu1) ... 395s Setting up autopkgtest-satdep (0) ... 395s Processing triggers for systemd (255.4-1ubuntu8) ... 395s Processing triggers for man-db (2.12.1-2) ... 397s Processing triggers for install-info (7.1-3build2) ... 397s Processing triggers for libc-bin (2.39-0ubuntu9) ... 398s Processing triggers for dictionaries-common (1.29.7) ... 401s (Reading database ... 90908 files and directories currently installed.) 401s Removing autopkgtest-satdep (0) ... 403s autopkgtest [08:33:59]: test run-testsuite: [----------------------- 404s ====== Running all tests with umask 077 ======= 404s ### PostgreSQL test 001_packages.t ### 404s 1..22 404s ok 1 - /etc/os-release exists 404s ok 2 - OS is ubuntu 404s ok 3 - OS version is 24.10 404s # PostgreSQL versions installed: 16 404s ok 4 - postgresql-16 installed 404s ok 5 # skip No python2 support 404s ok 6 - postgresql-plpython3-16 installed 404s ok 7 - postgresql-plperl-16 installed 404s ok 8 - postgresql-pltcl-16 installed 404s ok 9 - postgresql-server-dev-16 installed 404s ok 10 # skip No postgresql-contrib-16 package for version 16 404s # postgresql-doc-16 installed 404s ok 11 - At least one doc package installed 404s ok 12 - libecpg-dev installed 404s ok 13 - procps installed 404s ok 14 - netcat-openbsd installed 404s ok 15 - hunspell-en-us installed 404s ok 16 - system has a default UTF-8 locale 404s ok 17 - locale ru_RU exists 404s ok 18 - locale ru_RU.UTF-8 exists 404s ok 19 - user postgres in the UNIX group ssl-cert 404s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 404s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 404s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 404s ### End test 001_packages.t ### 404s 404s ### PostgreSQL test 002_existing_clusters.t ### 404s 1..8 404s # Cleanup 404s ok 1 - Cleanup: No clusters left behind 404s ok 2 - No postgres processes left behind 404s ok 3 - No files in /etc/postgresql left behind 404s ok 4 - No files in /var/lib/postgresql left behind 404s ok 5 - No files in /var/run/postgresql left behind 404s ok 6 - No files in /var/log/postgresql left behind 404s ok 7 - PostgreSQL TCP ports are closed 404s ok 8 - Next free port is 5432 404s ### End test 002_existing_clusters.t ### 404s 404s ### PostgreSQL test 003_alternatives.t ### 404s 1..9 404s # Newest PG version installed is 16 404s ok 1 - psql.1.gz link group 404s ok 2 - postmaster.1.gz link group does not exist 404s ok 3 - psql.1.gz alternative 404s ok 4 - pg_dump.1.gz alternative 404s ok 5 - postgres.1.gz alternative 404s ok 6 - pg_ctl.1.gz alternative 404s # Newest PG doc version installed is 16 404s ok 7 - SPI_connect.3.gz link group 404s ok 8 - SPI_connect.3.gz alternative 404s ok 9 - SPI_exec.3.gz alternative 404s ### End test 003_alternatives.t ### 404s 404s ### PostgreSQL test 005_PgCommon.t ### 404s 1..24 404s ok 1 - correctly parsed line 'local all postgres ident sameuser' 404s ok 2 - correctly parsed line 'local foo nobody trust' 404s ok 3 - correctly parsed line 'local foo nobody crypt' 404s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 404s ok 5 - correctly parsed line 'local foo,bar nobody ident' 404s ok 6 - correctly parsed line 'local all +foogrp password' 404s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 404s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 404s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 404s ok 10 - @expected_records has correct number of entries 404s ok 11 - returned read_pg_hba array has correct number of records 404s ok 12 - line 'foo all all md5' parsed as invalid 404s ok 13 - line 'local all all foo' parsed as invalid 404s ok 14 - line 'host all all foo' parsed as invalid 404s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 404s ok 16 - line 'host all all md5' parsed as invalid 404s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 404s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 404s ok 19 - read_conf_file returns empty dict for nonexisting file 404s ok 20 - read_conf_file() parsing 404s ok 21 - read_conf_file() parsing with include directives 404s ok 22 - set_conf_value 404s ok 23 - disable_conf_value 404s ok 24 - replace_conf_value 404s ### End test 005_PgCommon.t ### 404s 404s ### PostgreSQL test 006_next_free_port.t ### 404s 1..5 404s ok 1 - next_free_port is 5432 405s ok 2 - next_free_port detects localhost ipv4 socket 406s ok 3 - next_free_port detects wildcard ipv4 socket 407s ok 4 - next_free_port detects localhost ipv6 socket 408s ok 5 - next_free_port detects wildcard ipv6 socket 408s ### End test 006_next_free_port.t ### 408s 408s ### PostgreSQL test 007_pg_conftool.t ### 409s 1..41 409s # test without cluster 409s ok 1 - pg_conftool show all 409s ok 2 - correct output of pg_conftool show all 409s ok 3 - pg_conftool foo.conf show all 409s ok 4 - correct output of pg_conftool foo.conf show all 409s ok 5 - pg_conftool /tmp/FyljE8ljk6/different.conf show all 409s ok 6 - correct output of pg_conftool /tmp/FyljE8ljk6/different.conf show all 409s ok 7 - pg_conftool 9.7 main show all 409s ok 8 - correct output of pg_conftool 9.7 main show all 409s # test show 409s ok 9 - pg_conftool show all 409s ok 10 - correct output of pg_conftool show all 409s ok 11 - pg_conftool other.conf show all 409s ok 12 - correct output of pg_conftool other.conf show all 409s ok 13 - pg_conftool /tmp/FyljE8ljk6/different.conf show all 409s ok 14 - correct output of pg_conftool /tmp/FyljE8ljk6/different.conf show all 409s ok 15 - pg_conftool 16 main show all 409s ok 16 - correct output of pg_conftool 16 main show all 409s ok 17 - pg_conftool 16 main other.conf show all 409s ok 18 - correct output of pg_conftool 16 main other.conf show all 409s ok 19 - pg_conftool show a 409s ok 20 - correct output of pg_conftool show a 409s ok 21 - pg_conftool -s show a 409s ok 22 - correct output of pg_conftool -s show a 409s # test set 409s ok 23 - pg_conftool set c 7 409s ok 24 - correct output of pg_conftool set c 7 409s ok 25 - file contains new setting 409s ok 26 - pg_conftool set a 8 409s ok 27 - correct output of pg_conftool set a 8 409s ok 28 - file contains updated setting 409s ok 29 - pg_conftool /tmp/FyljE8ljk6/different.conf set a 9 409s ok 30 - correct output of pg_conftool /tmp/FyljE8ljk6/different.conf set a 9 409s ok 31 - file with path contains updated setting 409s # test remove 409s ok 32 - pg_conftool remove a 409s ok 33 - correct output of pg_conftool remove a 409s ok 34 - setting removed from file 409s ok 35 - pg_conftool /tmp/FyljE8ljk6/different.conf remove a 409s ok 36 - correct output of pg_conftool /tmp/FyljE8ljk6/different.conf remove a 409s ok 37 - setting removed from file with path 409s # test edit 409s ok 38 - pg_conftool edit 409s ok 39 - correct output of pg_conftool edit 409s ok 40 - pg_conftool /tmp/FyljE8ljk6/different.conf edit 409s ok 41 - correct output of pg_conftool /tmp/FyljE8ljk6/different.conf edit 409s ### End test 007_pg_conftool.t ### 409s 409s ### PostgreSQL test 010_defaultport_cluster.t ### 409s 1..14 409s ok 1 - psql --version 409s ok 2 - pg_wrapper selects highest available version number 410s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 410s ok 4 - connecting to localhost fails with no clusters 410s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 410s ok 6 - pg_wrapper uses host and port from PGCLUSTER 410s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 410s ok 8 - pg_wrapper uses --cluster from the command line 410s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 410s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 410s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 410s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 410s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 410s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 410s ### End test 010_defaultport_cluster.t ### 410s 410s ### PostgreSQL test 015_start_stop.t ### 410s 1..71 410s # We are running systemd 410s # Running tests for 16 410s # Cluster does not exist yet 410s ok 1 - cluster 16 main does not exist 410s ok 2 - service postgresql@16-main does not exist 410s ok 3 - systemctl start postgresql 410s ok 4 - cluster 16 main does not exist 410s ok 5 - service postgresql@16-main does not exist 410s ok 6 - systemctl start postgresql@16-main 410s ok 7 - cluster 16 main does not exist 410s ok 8 - service postgresql@16-main does not exist 410s # Start/stop postgresql using system tools 411s ok 9 - pg_createcluster 16 main 411s ok 10 - cluster 16 main is stopped 411s ok 11 - service postgresql@16-main is stopped 414s ok 12 - systemctl start postgresql 414s ok 13 - cluster 16 main is running 414s ok 14 - service postgresql@16-main is running 414s ok 15 - systemctl start postgresql 414s ok 16 - cluster 16 main is already running 414s ok 17 - service postgresql@16-main is already running 414s ok 18 - systemctl stop postgresql 420s ok 19 - cluster 16 main is stopped 420s ok 20 - service postgresql@16-main is stopped 420s ok 21 - systemctl stop postgresql 420s ok 22 - cluster 16 main is already stopped 420s ok 23 - service postgresql@16-main is already stopped 420s # Start/stop specific cluster using system tools 422s ok 24 - systemctl start postgresql@16-main 422s ok 25 - cluster 16 main is running 422s ok 26 - service postgresql@16-main is running 422s ok 27 - systemctl start postgresql@16-main 422s ok 28 - cluster 16 main is running 422s ok 29 - service postgresql@16-main is running 425s ok 30 - systemctl restart postgresql@16-main 425s ok 31 - cluster 16 main is running 425s ok 32 - service postgresql@16-main is running 425s ok 33 - systemctl stop postgresql@16-main 425s ok 34 - cluster 16 main is stopped 425s ok 35 - service postgresql@16-main is stopped 425s ok 36 - systemctl stop postgresql@16-main 425s ok 37 - cluster 16 main is already stopped 425s ok 38 - service postgresql@16-main is already stopped 427s ok 39 - pg_dropcluster 16 main 427s ok 40 - cluster 16 main does not exist 427s ok 41 - service postgresql@16-main does not exist 427s # Start/stop specific cluster using pg_*cluster 427s ok 42 - pg_ctlcluster start 16 main 427s ok 43 - cluster 16 main does not exist 427s ok 44 - service postgresql@16-main does not exist 431s ok 45 - pg_createcluster 16 main --start 431s ok 46 - cluster 16 main is running 431s ok 47 - service postgresql@16-main is running 431s ok 48 - pg_ctlcluster 16 main start 431s ok 49 - cluster 16 main is already running 431s ok 50 - service postgresql@16-main is already running 433s ok 51 - pg_ctlcluster 16-main restart 433s ok 52 - cluster 16 main is running 433s ok 53 - service postgresql@16-main is running 434s ok 54 - pg_ctlcluster 16 main stop 434s ok 55 - cluster 16 main is stopped 434s ok 56 - service postgresql@16-main is stopped 434s ok 57 - pg_ctlcluster 16 main stop 434s ok 58 - cluster 16 main is already stopped 434s ok 59 - service postgresql@16-main is already stopped 436s ok 60 - pg_ctlcluster start 16-main 436s ok 61 - cluster 16 main is running 436s ok 62 - service postgresql@16-main is running 438s ok 63 - pg_dropcluster 16 main --stop 438s # Cleanup 438s ok 64 - Cleanup: No clusters left behind 438s ok 65 - No postgres processes left behind 438s ok 66 - No files in /etc/postgresql left behind 438s ok 67 - No files in /var/lib/postgresql left behind 438s ok 68 - No files in /var/run/postgresql left behind 438s ok 69 - No files in /var/log/postgresql left behind 438s ok 70 - PostgreSQL TCP ports are closed 438s ok 71 - Next free port is 5432 438s ### End test 015_start_stop.t ### 438s 438s ### PostgreSQL test 020_create_sql_remove.t ### 438s 1..147 438s # Running tests for 16 442s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.X6bjOf 442s ok 2 - pg_createcluster 16 main 442s ok 3 - Socket and pid file are in /var/run/postgresql/ 442s ok 4 - xlog/wal directory /tmp/16.xlog.X6bjOf was created 442s ok 5 - local method in pg_hba.conf is peer 442s ok 6 - host method in pg_hba.conf is scram-sha-256 442s ok 7 - Exactly one postgres master process running 444s ok 8 - pg_ctlcluster 16 main restart 444s ok 9 - cluster restarts with new environment file 444s ok 10 - Exactly one postgres master process running 444s ok 11 - correct value of PGEXTRAVAR1 in environment 444s ok 12 - correct value of PGEXTRAVAR2 in environment 444s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 444s ok 14 - createdb --version 444s ok 15 - pg_wrapper+createdb selects version number of cluster 444s ok 16 - psql --version 444s ok 17 - pg_wrapper+psql selects version 16 444s ok 18 - pg_lscluster reports online cluster on port 5432 444s ok 19 - log file is actually used 444s ok 20 - /etc/postgresql is owned by user "postgres" 444s ok 21 - version configuration directory file is owned by user "postgres" 444s ok 22 - configuration directory file is owned by user "postgres" 444s ok 23 - version data directory file is owned by user "postgres" 444s ok 24 - data directory file is owned by user "postgres" 444s ok 25 - log file has 0640 permissions 444s ok 26 - log file is owned by user "postgres" 444s ok 27 - log file is owned by group "adm" 444s ok 28 - no log symlink by default 444s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 444s ok 30 - pg_lsclusters -h 444s ok 31 - correct output of pg_lsclusters -h 445s ok 32 - stopping cluster 447s ok 33 - restarting cluster with nondefault log symlink 447s ok 34 - log target is used as log file 447s ok 35 - default log is not used 447s ok 36 - pg_lsclusters -h 447s ok 37 - correct output of pg_lsclusters -h 447s ok 38 - stopping cluster 450s ok 39 - restarting cluster with explicitly configured log file 450s ok 40 - default log is not used 450s ok 41 - log symlink target is used for startup message 450s ok 42 - exactly one log file 450s ok 43 - custom log is actually used 450s ok 44 - pg_lsclusters -h 450s ok 45 - correct output of pg_lsclusters -h 450s ok 46 - stopping cluster 452s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 453s ok 48 - /etc/postgres-hack was not created 453s ok 49 - restarting cluster 453s ok 50 - ps -o tty -U postgres h 453s ok 51 - postgres processes do not have an associated terminal 453s ok 52 - Server is linked with SSL support 453s ok 53 - SSL is enabled in postgresql.conf 453s ok 54 - psql -l fails for nobody 453s ok 55 - createuser nobody 453s ok 56 - createdb nobodydb 453s ok 57 - psql -ltA succeeds for nobody 453s ok 58 - psql -ltA output 453s ok 59 - SQL command: create table 453s ok 60 - SQL command: insert into table values 453s ok 61 - SQL command: insert into table values 453s ok 62 - primary key violation 453s ok 63 - psql -tAc "select * from phone order by name" nobodydb 453s ok 64 - SQL command output: select -tA 453s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 453s ok 66 - SQL command output: select -tx 453s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 453s ok 68 - SQL command output: select -tAx 453s ok 69 - CREATE EXTENSION plperlu fails for user nobody 453s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 453s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 453s ok 72 - creating PL/PerlU function as user nobody fails 453s ok 73 - creating unsafe PL/Perl function as user postgres fails 454s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 454s ok 75 - creating PL/PerlU function as user postgres succeeds 454s ok 76 - psql nobodydb -Atc "select read_file()" 454s ok 77 - calling PL/PerlU function 454s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 454s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 454s ok 80 - creating unsafe PL/Perl function as user nobody fails 454s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 454s ok 82 - creating PL/Perl function as user nobody succeeds 454s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 454s ok 84 - calling PL/Perl function 454s ok 85 # skip No python2 support 454s ok 86 # skip No python2 support 454s ok 87 # skip No python2 support 454s ok 88 # skip No python2 support 454s ok 89 # skip No python2 support 454s ok 90 # skip No python2 support 454s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 454s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 454s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 454s ok 94 - creating PL/Python3 function as user postgres succeeds 454s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 454s ok 96 - calling PL/Python function 454s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 454s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 454s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 454s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 454s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 454s ok 102 - creating PL/Tcl function as user nobody succeeds 454s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 454s ok 104 - creating PL/TclU function as user postgres succeeds 454s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 454s ok 106 - calling PL/Tcl function 454s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 454s ok 108 - calling PL/TclU function 454s ok 109 - stopping cluster 455s ok 110 - pg_ctlcluster 16 main start 455s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 457s ok 112 - pg_ctlcluster 16 main start 457s ok 113 - cluster restarts with pgdata symlink 457s ok 114 - postgres master has OOM killer protection 457s ok 115 - postgres client backend has no OOM adjustment 457s ok 116 - ps h 6869 457s ok 117 - process title is idle 458s ok 118 - ps h 6869 458s ok 119 - process title is idle in transaction 458s ok 120 - stopping cluster 460s ok 121 - starting cluster as postgres works without a log file 460s ok 122 - log file got recreated and used 460s ok 123 - creating a directory in spc2 460s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.CIxVCR'" 460s ok 125 - creating tablespace spc1 460s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 460s ok 127 - creating a table in spc1 460s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.u6Dz1a'" 460s ok 129 - creating tablespace spc2 460s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 460s ok 131 - creating a table in spc2 460s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 460s ok 133 - Correct apt NeverAutoRemove config 462s ok 134 - pg_dropcluster removes cluster 462s ok 135 - xlog/wal directory /tmp/16.xlog.X6bjOf was deleted 462s ok 136 - tablespace spc1 was emptied 462s ok 137 - tablespace spc2 was emptied 462s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 462s ok 139 - Correct apt NeverAutoRemove config 462s # Cleanup 462s ok 140 - Cleanup: No clusters left behind 462s ok 141 - No postgres processes left behind 462s ok 142 - No files in /etc/postgresql left behind 462s ok 143 - No files in /var/lib/postgresql left behind 462s ok 144 - No files in /var/run/postgresql left behind 462s ok 145 - No files in /var/log/postgresql left behind 462s ok 146 - PostgreSQL TCP ports are closed 462s ok 147 - Next free port is 5432 462s ### End test 020_create_sql_remove.t ### 462s 462s ### PostgreSQL test 021_pg_renamecluster.t ### 463s 1..20 466s ok 1 - pg_createcluster 16 main 469s ok 2 - pg_renamecluster 16 main donau 469s ok 3 - psql -tAc "show data_directory" 469s ok 4 - cluster is running and data_directory was moved 469s ok 5 - pg_hba.conf location updated 469s ok 6 - pg_ident.conf location updated 469s ok 7 - external_pid_file location updated 469s ok 8 - external_pid_file exists 469s ok 9 # skip no stats_temp_directory in 16 469s ok 10 # skip no stats_temp_directory in 16 469s ok 11 - cluster_name is updated 471s ok 12 - pg_dropcluster removes cluster 471s # Cleanup 471s ok 13 - Cleanup: No clusters left behind 471s ok 14 - No postgres processes left behind 471s ok 15 - No files in /etc/postgresql left behind 471s ok 16 - No files in /var/lib/postgresql left behind 471s ok 17 - No files in /var/run/postgresql left behind 471s ok 18 - No files in /var/log/postgresql left behind 471s ok 19 - PostgreSQL TCP ports are closed 471s ok 20 - Next free port is 5432 471s ### End test 021_pg_renamecluster.t ### 471s 471s ### PostgreSQL test 022_recovery.t ### 471s 1..17 471s # Running tests for 16 475s ok 1 - pg_createcluster 16 main --start >/dev/null 475s ok 2 - pg_ctlcluster 16 main stop -m i 477s ok 3 - pg_ctlcluster 16 main start 477s ok 4 - psql -c '' 477s ok 5 - pg_ctlcluster 16 main stop -m i 477s ok 6 - create write-protected file in data directory 480s ok 7 - pg_ctlcluster 16 main start 480s ok 8 - psql -c '' 482s ok 9 - pg_dropcluster removes cluster 482s # Cleanup 482s ok 10 - Cleanup: No clusters left behind 482s ok 11 - No postgres processes left behind 482s ok 12 - No files in /etc/postgresql left behind 482s ok 13 - No files in /var/lib/postgresql left behind 482s ok 14 - No files in /var/run/postgresql left behind 482s ok 15 - No files in /var/log/postgresql left behind 482s ok 16 - PostgreSQL TCP ports are closed 482s ok 17 - Next free port is 5432 482s ### End test 022_recovery.t ### 482s 482s ### PostgreSQL test 025_logging.t ### 482s 1..55 483s # Logging to /var/log/syslog works 483s # Running tests for 16 486s ok 1 - pg_createcluster 16 main 486s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 486s ok 3 - psql -qc "'foobar_16_8040'" 486s ok 4 - log an error 487s ok 5 - grep --binary-files=text foobar_16_8040 /var/log/postgresql/postgresql-16-main.log 487s ok 6 - error appears in logfile 487s ok 7 - pg_conftool 16 main set log_destination syslog 487s ok 8 - set log_destination syslog 487s ok 9 - pg_ctlcluster 16 main reload 487s ok 10 - 16 main reload 487s ok 11 - psql -Atc "show log_destination" 487s ok 12 - log_destination is syslog 487s ok 13 - pg_lscluster reports syslog 487s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 487s ok 15 - error appears in /var/log/syslog 487s ok 16 - pg_conftool 16 main set logging_collector on 487s ok 17 - set logging_collector on 487s ok 18 - pg_conftool 16 main set log_destination csvlog 487s ok 19 - set log_destination csvlog 490s ok 20 - pg_ctlcluster 16 main restart 490s ok 21 - 16 main restart 490s ok 22 - psql -Atc "show logging_collector" 490s ok 23 - logging_collector is on 490s ok 24 - psql -Atc "show log_destination" 490s ok 25 - log_destination is csvlog 490s ok 26 - pg_lscluster reports csvlog 490s ok 27 - psql -qc "'barbaz_16_8040'" 490s ok 28 - log an error 491s ok 29 - grep --binary-files=text barbaz_16_8040 /var/lib/postgresql/16/main/log/*.csv 491s ok 30 - error appears in log/*.csv 491s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 491s ok 32 - set log_destination stderr,syslog,csvlog 491s ok 33 - pg_ctlcluster 16 main reload 491s ok 34 - 16 main reload 491s ok 35 - psql -Atc "show log_destination" 491s ok 36 - log_destination is stderr,syslog,csvlog 491s ok 37 - pg_lscluster reports stderr,syslog,csvlog 491s ok 38 - psql -qc "'moo_16_8040'" 491s ok 39 - log an error 491s ok 40 - grep --binary-files=text moo_16_8040 /var/lib/postgresql/16/main/log/*.log 491s ok 41 - error appears in log/*.log 492s ok 42 - grep --binary-files=text 'postgres.*moo_16_8040' /var/log/syslog 492s ok 43 - error appears in /var/log/syslog 492s ok 44 - grep --binary-files=text moo_16_8040 /var/lib/postgresql/16/main/log/*.csv 492s ok 45 - error appears in log/*.csv 494s ok 46 - pg_dropcluster 16 main --stop 494s ok 47 - pg_dropcluster removes cluster 494s # Cleanup 494s ok 48 - Cleanup: No clusters left behind 494s ok 49 - No postgres processes left behind 494s ok 50 - No files in /etc/postgresql left behind 494s ok 51 - No files in /var/lib/postgresql left behind 494s ok 52 - No files in /var/run/postgresql left behind 494s ok 53 - No files in /var/log/postgresql left behind 494s ok 54 - PostgreSQL TCP ports are closed 494s ok 55 - Next free port is 5432 494s ### End test 025_logging.t ### 494s 494s ### PostgreSQL test 027_jit.t ### 494s # 16 497s ok 1 - pg_createcluster 16 main --start 497s ok 2 - psql -Xatc 'show jit' 497s ok 3 - JIT is on by default 497s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 497s ok 5 - No JIT on cheap query 498s ok 6 - pg_conftool 16 main set seq_page_cost 100000 498s ok 7 - pg_conftool 16 main set random_page_cost 100000 498s ok 8 - pg_ctlcluster 16 main reload 498s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 498s ok 10 - Expensive query is JITed 500s ok 11 - pg_dropcluster --stop 16 main 500s # Cleanup 500s ok 12 - Cleanup: No clusters left behind 500s ok 13 - No postgres processes left behind 500s ok 14 - No files in /etc/postgresql left behind 500s ok 15 - No files in /var/lib/postgresql left behind 500s ok 16 - No files in /var/run/postgresql left behind 500s ok 17 - No files in /var/log/postgresql left behind 500s ok 18 - PostgreSQL TCP ports are closed 500s ok 19 - Next free port is 5432 500s 1..19 500s ### End test 027_jit.t ### 500s 500s ### PostgreSQL test 030_errors.t ### 500s 1..156 500s ok 1 - pg_lscluster reports cluster without binaries 502s ok 2 - pg_dropcluster 6.3 main 503s ok 3 - pg_createcluster --socketdir 503s ok 4 - pg_lsclusters -h 503s ok 5 - cluster was created 503s ok 6 - Port of created cluster is 5432 503s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 503s ok 8 - pg_createcluster on existing cluster 503s ok 9 - pg_lsclusters -h 503s ok 10 - original cluster still exists 503s ok 11 - pg_createcluster 16 test -p foo 503s ok 12 - pg_createcluster -p checks that port option is numeric 503s ok 13 - pg_createcluster 16 test -p 42 503s ok 14 - pg_createcluster -p checks valid port range 503s ok 15 - pg_ctlcluster 16 main start 503s ok 16 - pg_ctlcluster refuses to start root-owned cluster 503s ok 17 - pg_ctlcluster 16 main start 503s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 503s ok 19 - pg_ctlcluster 16 main start 503s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 503s ok 21 - pg_ctlcluster 16 main start 503s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 506s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 506s ok 24 - No sockets in /var/run/postgresql 506s ok 25 - Socket is in /tmp/postgresql-testsuite/ 506s ok 26 - cluster stops with custom unix_socket_dir 506s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 508s ok 28 - cluster starts after removing unix_socket_dir 508s ok 29 - Socket is in default dir /var/run/postgresql 508s ok 30 - No sockets in /tmp/postgresql-testsuite/ 508s ok 31 - pg_ctlcluster 16 main stop 508s ok 32 - pg_ctlcluster fails with corrupted PID file 508s ok 33 - pg_lsclusters -h 508s ok 34 - cluster is still online 508s ok 35 - pg_ctlcluster succeeds with restored PID file 508s ok 36 - pg_lsclusters -h 508s ok 37 - cluster is down 508s ok 38 - pg_ctlcluster 16 main stop 508s ok 39 - pg_ctlcluster stop fails on stopped cluster 511s ok 40 - pg_ctlcluster 16 main start 511s ok 41 - pg_ctlcluster succeeds with already existing PID file 511s ok 42 - pg_lsclusters -h 511s ok 43 - cluster is online 511s ok 44 - pg_ctlcluster stop succeeds 511s ok 45 - pg_lsclusters -h 511s ok 46 - cluster is down 511s ok 47 - no pid file left 511s ok 48 - pg_ctlcluster 16 main stop 511s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 511s ok 50 - pid file was cleaned up 511s ok 51 - pg_ctlcluster --force 16 main stop 511s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 511s ok 53 - pid file was cleaned up 511s ok 54 - pg_ctlcluster 16 main stop 511s ok 55 - pg_ctlcluster stop succeeds with stale PID file 511s ok 56 - pid file was cleaned up 511s ok 57 - pg_ctlcluster --force 16 main stop 511s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 511s ok 59 - pid file was cleaned up 511s ok 60 - pg_ctlcluster --force 16 main stop 511s ok 61 - pg_ctlcluster stop succeeds with empty PID file 511s ok 62 - pid file was cleaned up 513s ok 63 - pg_ctlcluster 16 main start 513s ok 64 - pg_ctlcluster succeeds with corrupted PID file 513s ok 65 - pg_lsclusters -h 513s ok 66 - cluster is online 514s ok 67 - pg_ctlcluster 16 main start 514s ok 68 - pg_ctlcluster start fails on running cluster 514s ok 69 - pg_ctlcluster stop 514s ok 70 - pg_ctlcluster 16 main start 514s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 514s ok 72 - pg_ctlcluster 16 main stop 514s ok 73 - stopping cluster 520s ok 74 - pg_ctlcluster 16 main start 520s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 520s ok 76 - pg_ctlcluster 16 main stop 520s ok 77 - stopping cluster 520s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 520s ok 79 - pg_dropcluster 16 main 520s ok 80 - pg_dropcluster works as user postgres 522s ok 81 - pg_createcluster succeeds 522s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 522s ok 83 - proper error message for nonexisting /var/lib/postgresql 524s ok 84 - pg_ctlcluster 16 main start 524s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 524s ok 86 - pg_ctlcluster 16 main stop 524s ok 87 - stopping cluster 525s ok 88 - pg_createcluster other 527s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 530s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 530s ok 91 530s ok 92 - pg_ctlcluster 16 other start 530s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 530s ok 94 - pg_ctlcluster 16 main stop 530s ok 95 - stopping main cluster 532s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 534s ok 97 - pg_dropcluster other 536s ok 98 - pg_dropcluster 536s ok 99 - No sockets any more 536s ok 100 - 'pg_lsclusters 4.5 foo' fails 536s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 536s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 536s ok 103 - 'psql --cluster 4.5/foo' fails 536s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 536s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 536s ok 106 - 'psql --cluster 16/foo' fails 536s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 536s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 537s ok 109 - 'pg_dropcluster 4.5 foo' fails 537s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 537s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 537s ok 112 - 'pg_dropcluster 16 foo' fails 537s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 537s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 537s ok 115 - 'pg_upgradecluster 4.5 foo' fails 537s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 537s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 537s ok 118 - 'pg_upgradecluster 16 foo' fails 537s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 537s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 537s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 537s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 537s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 537s ok 124 - 'pg_ctlcluster 16 foo stop' fails 537s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 537s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 537s # Cleanup 537s ok 127 - Cleanup: No clusters left behind 537s ok 128 - No postgres processes left behind 537s ok 129 - No files in /etc/postgresql left behind 537s ok 130 - No files in /var/lib/postgresql left behind 537s ok 131 - No files in /var/run/postgresql left behind 537s ok 132 - No files in /var/log/postgresql left behind 537s ok 133 - PostgreSQL TCP ports are closed 537s ok 134 - Next free port is 5432 538s ok 135 - pg_dropcluster 16 broken 538s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 538s # Cleanup 538s ok 137 - Cleanup: No clusters left behind 538s ok 138 - No postgres processes left behind 538s ok 139 - No files in /etc/postgresql left behind 538s ok 140 - No files in /var/lib/postgresql left behind 538s ok 141 - No files in /var/run/postgresql left behind 538s ok 142 - No files in /var/log/postgresql left behind 538s ok 143 - PostgreSQL TCP ports are closed 538s ok 144 - Next free port is 5432 540s ok 145 - pg_dropcluster 16 broken 540s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 540s ok 147 - /etc/postgresql/16 was removed 540s ok 148 - /var/lib/postgresql/16 was removed 540s # Cleanup 540s ok 149 - Cleanup: No clusters left behind 540s ok 150 - No postgres processes left behind 540s ok 151 - No files in /etc/postgresql left behind 540s ok 152 - No files in /var/lib/postgresql left behind 540s ok 153 - No files in /var/run/postgresql left behind 540s ok 154 - No files in /var/log/postgresql left behind 540s ok 155 - PostgreSQL TCP ports are closed 540s ok 156 - Next free port is 5432 540s ### End test 030_errors.t ### 540s 540s ### PostgreSQL test 031_errors_disk_full.t ### 540s 1..22 540s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 542s ok 1 - script failed 542s ok 2 - pg_createcluster fails due to insufficient disk space 542s ok 3 - does not leave files behind 542s # Cleanup 542s ok 4 - Cleanup: No clusters left behind 542s ok 5 - No postgres processes left behind 542s ok 6 - No files in /etc/postgresql left behind 542s ok 7 - No files in /var/lib/postgresql left behind 542s ok 8 - No files in /var/run/postgresql left behind 542s ok 9 - No files in /var/log/postgresql left behind 542s ok 10 - PostgreSQL TCP ports are closed 542s ok 11 - Next free port is 5432 542s # check disk full conditions on startup 545s ok 12 - script failed 545s ok 13 - pg_ctlcluster prints error message 545s ok 14 - log file has error message 545s # Cleanup 545s ok 15 - Cleanup: No clusters left behind 545s ok 16 - No postgres processes left behind 545s ok 17 - No files in /etc/postgresql left behind 545s ok 18 - No files in /var/lib/postgresql left behind 545s ok 19 - No files in /var/run/postgresql left behind 545s ok 20 - No files in /var/log/postgresql left behind 545s ok 21 - PostgreSQL TCP ports are closed 545s ok 22 - Next free port is 5432 545s ### End test 031_errors_disk_full.t ### 545s 545s ### PostgreSQL test 032_ssl_key_permissions.t ### 545s 1..22 545s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 545s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 545s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 545s # 16 (16.3-1) 546s ok 4 - pg_createcluster 16 main 547s ok 5 - pg_ctlcluster 16 main start 547s ok 6 - ssl key owned by nobody refused 547s ok 7 - pg_ctlcluster 16 main start 547s ok 8 - ssl key with permissions root:root 0644 refused 547s ok 9 - pg_ctlcluster 16 main start 547s ok 10 - ssl key with permissions postgres:postgres 0640 refused 549s ok 11 - pg_dropcluster 16 main --stop 549s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 549s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 549s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 549s # Cleanup 549s ok 15 - Cleanup: No clusters left behind 549s ok 16 - No postgres processes left behind 549s ok 17 - No files in /etc/postgresql left behind 549s ok 18 - No files in /var/lib/postgresql left behind 549s ok 19 - No files in /var/run/postgresql left behind 549s ok 20 - No files in /var/log/postgresql left behind 549s ok 21 - PostgreSQL TCP ports are closed 549s ok 22 - Next free port is 5432 549s ### End test 032_ssl_key_permissions.t ### 549s 549s ### PostgreSQL test 040_upgrade.t ### 549s 1..1 549s ok 1 - only one major version installed, skipping upgrade tests 549s ### End test 040_upgrade.t ### 549s 549s ### PostgreSQL test 041_upgrade_custompaths.t ### 549s 1..1 549s ok 1 - only one major version installed, skipping upgrade tests 549s ### End test 041_upgrade_custompaths.t ### 549s 549s ### PostgreSQL test 042_upgrade_rename.t ### 549s 1..15 549s # PostgreSQL 16 553s ok 1 - pg_createcluster 16 main --start 562s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 562s ok 3 - pg_lsclusters -h 562s ok 4 - correct output of pg_lsclusters -h 562s ok 5 - pg_dropcluster 16 main --stop 563s ok 6 - pg_dropcluster 16 upgr --stop 563s ok 7 - Cleaning pg_upgrade log files 563s # Cleanup 563s ok 8 - Cleanup: No clusters left behind 563s ok 9 - No postgres processes left behind 563s ok 10 - No files in /etc/postgresql left behind 563s ok 11 - No files in /var/lib/postgresql left behind 563s ok 12 - No files in /var/run/postgresql left behind 563s ok 13 - No files in /var/log/postgresql left behind 563s ok 14 - PostgreSQL TCP ports are closed 563s ok 15 - Next free port is 5432 563s ### End test 042_upgrade_rename.t ### 563s 563s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 563s 1..1 563s ok 1 - only one major version installed, skipping upgrade tests 563s ### End test 043_upgrade_ssl_cert.t ### 563s 563s ### PostgreSQL test 045_backup.t ### 563s # We are running systemd 563s # PostgreSQL 16 563s # create cluster 567s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 567s ok 2 - pg_lsclusters -h 567s ok 3 - correct output of pg_lsclusters -h 567s ok 4 - pg_conftool 16 main set work_mem 11MB 567s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 567s ok 6 - psql -c 'alter database mydb set search_path=public' 567s ok 7 - psql -c 'create table foo (t text)' mydb 567s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 567s ok 9 - psql -c 'CREATE USER myuser' 567s ok 10 - psql -c 'grant create on database mydb to myuser' 567s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 567s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 568s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 568s # create directory 568s ok 14 - pg_backupcluster 16 main createdirectory 568s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 568s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 568s # dump 568s ok 17 - systemctl start pg_dump@16-main 568s ok 18 - dump created in /var/backups/postgresql/16-main/2024-06-25T083644Z.dump 568s ok 19 - /var/backups/postgresql/16-main/2024-06-25T083644Z.dump owned by uid postgres 568s ok 20 - /var/backups/postgresql/16-main/2024-06-25T083644Z.dump owned by gid postgres 568s # basebackup 568s ok 21 - systemctl start pg_receivewal@16-main 569s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 573s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 573s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 573s ok 25 - psql -c 'select pg_reload_conf()' 597s ok 26 - systemctl start pg_basebackup@16-main 597s ok 27 - dump created in /var/backups/postgresql/16-main/2024-06-25T083645Z.backup 597s ok 28 - /var/backups/postgresql/16-main/2024-06-25T083645Z.backup owned by uid postgres 597s ok 29 - /var/backups/postgresql/16-main/2024-06-25T083645Z.backup owned by gid postgres 597s # list 597s ok 30 - pg_backupcluster 16 main list 597s ok 31 - correct output of pg_backupcluster 16 main list 597s # more database changes 597s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 597s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 597s ok 34 - retrieve recovery timestamp 597s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 598s ok 36 - systemctl stop pg_receivewal@16-main 598s # restore /var/backups/postgresql/16-main/2024-06-25T083644Z.dump 600s ok 37 - pg_dropcluster 16 main --stop 620s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083644Z.dump --start --datadir /var/lib/postgresql/16/snowflake 620s ok 39 - pg_lsclusters -h 620s ok 40 - correct output of pg_lsclusters -h 620s ok 41 - psql -XAtl 620s ok 42 - mydb locales 620s ok 43 - mydb grants 620s ok 44 - myicudb locales 620s ok 45 - psql -XAtc 'show work_mem' 620s ok 46 - correct output of psql -XAtc 'show work_mem' 620s ok 47 - psql -XAtc 'select * from foo' mydb 620s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 620s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 620s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 620s ok 51 - psql -XAtc '\drds' 620s ok 52 - correct output of psql -XAtc '\drds' 620s # restore /var/backups/postgresql/16-main/2024-06-25T083645Z.backup 620s ok 53 - pg_dropcluster 16 main --stop 620s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083645Z.backup --start --datadir /var/lib/postgresql/16/snowflake 620s ok 55 - pg_lsclusters -h 620s ok 56 - correct output of pg_lsclusters -h 620s ok 57 - psql -XAtl 620s ok 58 - mydb locales 620s ok 59 - mydb grants 620s ok 60 - myicudb locales 620s ok 61 - psql -XAtc 'show work_mem' 620s ok 62 - correct output of psql -XAtc 'show work_mem' 620s ok 63 - psql -XAtc 'select * from foo' mydb 620s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 620s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 620s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 620s ok 67 - psql -XAtc '\drds' 620s ok 68 - correct output of psql -XAtc '\drds' 620s # restore /var/backups/postgresql/16-main/2024-06-25T083645Z.backup with WAL archive 620s ok 69 - pg_dropcluster 16 main --stop 620s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083645Z.backup --start --archive --port 5430 620s ok 71 - pg_lsclusters -h 620s ok 72 - correct output of pg_lsclusters -h 620s ok 73 - psql -XAtc 'select * from foo order by t' mydb 620s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 620s # restore /var/backups/postgresql/16-main/2024-06-25T083645Z.backup with PITR 620s ok 75 - pg_dropcluster 16 main --stop 624s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083645Z.backup --start --pitr '2024-06-25 08:37:13.719629+00 624s # ' 624s ok 77 - pg_lsclusters -h 624s ok 78 - correct output of pg_lsclusters -h 624s ok 79 - psql -XAtc 'select * from foo order by t' mydb 624s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 635s ok 81 - pg_dropcluster 16 main --stop 635s # Cleanup 635s ok 82 - Cleanup: No clusters left behind 635s ok 83 - No postgres processes left behind 635s ok 84 - No files in /etc/postgresql left behind 635s ok 85 - No files in /var/lib/postgresql left behind 635s ok 86 - No files in /var/run/postgresql left behind 635s ok 87 - No files in /var/log/postgresql left behind 635s ok 88 - PostgreSQL TCP ports are closed 635s ok 89 - Next free port is 5432 635s 1..89 635s ### End test 045_backup.t ### 635s 635s ### PostgreSQL test 050_encodings.t ### 635s 1..60 635s # Checking 16 ru_RU 635s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 635s ok 2 - psql -l succeeds 635s ok 3 - template1 is not UTF-8 encoded 635s ok 4 - creating test database 635s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 635s # create table t (x varchar); copy t from stdin" test 635s ok 6 - creating table with ISO-8859-5 characters 635s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 635s ok 8 - correct string in UTF-8 635s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 635s ok 10 - correct string in ISO-8859-5 635s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 635s # delete from t; copy t from stdin" test 635s ok 12 - creating table with UTF-8 characters 635s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 635s ok 14 - correct string in UTF-8 635s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 635s ok 16 - correct string in ISO-8859-1 635s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 635s ok 18 - Server error message has correct language and encoding 635s ok 19 - pg_ctlcluster 16 ru_RU restart 635s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 637s ok 21 - Dropping cluster 637s # Checking 16 ru_RU.UTF-8 640s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 641s ok 23 - psql -l succeeds 641s ok 24 - template1 is UTF-8 encoded 641s ok 25 - creating test database 641s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 641s # create table t (x varchar); copy t from stdin" test 641s ok 27 - creating table with ISO-8859-5 characters 641s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 641s ok 29 - correct string in UTF-8 641s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 641s ok 31 - correct string in ISO-8859-5 641s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 641s # delete from t; copy t from stdin" test 641s ok 33 - creating table with UTF-8 characters 641s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 641s ok 35 - correct string in UTF-8 642s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 642s ok 37 - correct string in ISO-8859-1 642s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 642s ok 39 - Server error message has correct language and encoding 644s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 644s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 644s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 644s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 644s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 644s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 644s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 644s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 646s ok 48 - Dropping cluster 646s # Check 16 locale environment variables 650s ok 49 - pg_createcluster: LC_ALL dominates LANG 650s ok 50 - psql -Atl --cluster 16/main 650s ok 51 - template1 is ASCII encoded 652s ok 52 - Dropping cluster 652s # Cleanup 652s ok 53 - Cleanup: No clusters left behind 652s ok 54 - No postgres processes left behind 652s ok 55 - No files in /etc/postgresql left behind 652s ok 56 - No files in /var/lib/postgresql left behind 652s ok 57 - No files in /var/run/postgresql left behind 652s ok 58 - No files in /var/log/postgresql left behind 652s ok 59 - PostgreSQL TCP ports are closed 652s ok 60 - Next free port is 5432 652s ### End test 050_encodings.t ### 652s 652s ### PostgreSQL test 052_upgrade_encodings.t ### 652s 1..1 652s ok 1 - only one major version installed, skipping upgrade tests 652s ### End test 052_upgrade_encodings.t ### 652s 652s ### PostgreSQL test 060_obsolete_confparams.t ### 652s ok 1 - only one major version installed, skipping upgrade tests 652s 1..1 652s ### End test 060_obsolete_confparams.t ### 652s 652s ### PostgreSQL test 070_non_postgres_clusters.t ### 652s 1..40 654s ok 1 - pg_createcluster 16 main for owner nobody 654s ok 2 - pg_ctlcluster 16 main start 654s ok 3 - start refused when config and data owners mismatch 656s ok 4 - pg_ctlcluster succeeds with owner nobody 656s ok 5 - pg_lsclusters -h 656s ok 6 - pg_lsclusters shows running cluster 656s ok 7 - postgres is running as user nobody 656s ok 8 - ls /tmp/.s.PGSQL.* 656s ok 9 - socket is in /tmp 656s ok 10 - /var/run/postgresql is empty 656s ok 11 - conf dir is owned by user 656s ok 12 - conf dir is owned by user's primary group 656s ok 13 - files are owned by user 656s ok 14 - files are owned by user's primary group 656s ok 15 - log file has 0640 permissions 656s ok 16 - log file is owned by user 656s ok 17 - log file is owned by user's primary group 656s ok 18 - only one major version installed, skipping upgrade test 656s ok 19 - ... 656s ok 20 - ... 656s ok 21 - ... 656s ok 22 - ... 656s ok 23 - ... 656s ok 24 - ... 656s ok 25 - ... 656s ok 26 - ... 656s ok 27 - ... 656s ok 28 - ... 658s ok 29 - pg_dropcluster 658s ok 30 - pg_lsclusters -h 658s ok 31 - No clusters left 658s ok 32 - No postgres processes left 658s # Cleanup 658s ok 33 - Cleanup: No clusters left behind 658s ok 34 - No postgres processes left behind 658s ok 35 - No files in /etc/postgresql left behind 658s ok 36 - No files in /var/lib/postgresql left behind 658s ok 37 - No files in /var/run/postgresql left behind 658s ok 38 - No files in /var/log/postgresql left behind 658s ok 39 - PostgreSQL TCP ports are closed 658s ok 40 - Next free port is 5432 658s ### End test 070_non_postgres_clusters.t ### 658s 658s ### PostgreSQL test 080_start.conf.t ### 658s 1..73 660s ok 1 - pg_createcluster 16 main 660s # start.conf auto 660s ok 2 - get_cluster_start_conf returns auto 660s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 660s ok 4 - start.conf contains auto 660s ok 5 - systemd generator links cluster 660s ok 6 - systemd generator links correct service file 662s ok 7 - /etc/init.d/postgresql start 16 662s ok 8 - correct output of /etc/init.d/postgresql start 16 662s ok 9 - pg_lsclusters -h 662s ok 10 - cluster is online 662s ok 11 - /etc/init.d/postgresql stop 16 662s ok 12 - correct output of /etc/init.d/postgresql stop 16 665s ok 13 - pg_lsclusters -h 665s ok 14 - cluster is down 665s # start.conf manual 665s ok 15 - get_cluster_start_conf returns manual 665s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 665s ok 17 - start.conf contains manual 665s ok 18 - systemd generator doesn't link cluster 665s ok 19 - /etc/init.d/postgresql start 16 665s ok 20 - correct output of /etc/init.d/postgresql start 16 665s ok 21 - pg_lsclusters -h 665s ok 22 - cluster is down 668s ok 23 - pg_ctlcluster 16 main start 668s ok 24 - correct output of pg_ctlcluster 16 main start 668s ok 25 - pg_lsclusters -h 668s ok 26 - cluster is online 668s ok 27 - pg_ctlcluster 16 main stop 668s ok 28 - correct output of pg_ctlcluster 16 main stop 668s ok 29 - pg_lsclusters -h 668s ok 30 - cluster is down 668s # start.conf disabled 668s ok 31 - get_cluster_start_conf returns disabled 668s ok 32 - systemd generator doesn't link cluster 668s ok 33 - /etc/init.d/postgresql start 16 668s ok 34 - correct output of /etc/init.d/postgresql start 16 668s ok 35 - pg_lsclusters -h 668s ok 36 - cluster is down 668s ok 37 - pg_ctlcluster 16 main start 668s ok 38 - correct output of pg_ctlcluster 16 main start 668s ok 39 - pg_lsclusters -h 668s ok 40 - cluster is down 671s ok 41 - pg_ctlcluster 16 main start 671s ok 42 - correct output of pg_ctlcluster 16 main start 671s ok 43 - pg_lsclusters -h 671s ok 44 - cluster is online 671s ok 45 - pg_ctlcluster 16 main stop 671s ok 46 - correct output of pg_ctlcluster 16 main stop 671s ok 47 - pg_lsclusters -h 671s ok 48 - cluster is down 673s ok 49 - pg_ctlcluster 16 main start 673s ok 50 - correct output of pg_ctlcluster 16 main start 673s ok 51 - pg_lsclusters -h 673s ok 52 - cluster is online 673s # test upgrade 673s ok 53 - only one major version installed, skipping upgrade test 673s ok 54 - ... 673s ok 55 - get_cluster_start_conf for old cluster returns manual 673s ok 56 - get_cluster_start_conf for new cluster returns manual 673s ok 57 - ... 675s ok 58 - dropping upgraded cluster 675s ok 59 - pg_lsclusters -h 675s ok 60 - no clusters any more 675s ok 61 - pg_createcluster 16 main --start-conf foo 675s ok 62 - pg_createcluster checks --start-conf validity 676s ok 63 - pg_createcluster checks --start-conf manual 676s ok 64 - get_cluster_start_conf returns manual 678s ok 65 - dropping cluster 678s # Cleanup 678s ok 66 - Cleanup: No clusters left behind 678s ok 67 - No postgres processes left behind 678s ok 68 - No files in /etc/postgresql left behind 678s ok 69 - No files in /var/lib/postgresql left behind 678s ok 70 - No files in /var/run/postgresql left behind 678s ok 71 - No files in /var/log/postgresql left behind 678s ok 72 - PostgreSQL TCP ports are closed 678s ok 73 - Next free port is 5432 678s ### End test 080_start.conf.t ### 678s 678s ### PostgreSQL test 085_pg_ctl.conf.t ### 678s 1..33 678s ok 1 - prlimit --core=0:unlimited --pid=16607 678s ok 2 - set core file size to unlimited 678s ok 3 - sh -c 'ulimit -Hc' 678s ok 4 - core file size is unlimited 679s ok 5 - pg_createcluster 16 main 679s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 681s ok 7 - pg_ctlcluster 16 main start 681s ok 8 - starting cluster as root 681s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 681s ok 10 - soft core size is 0 681s # hard core file size limit of root-started postgres process is unlimited 681s ok 11 - set pg_ctl default option to -c 684s ok 12 - pg_ctlcluster 16 main restart 684s ok 13 - restarting cluster as root 684s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 684s ok 15 - soft core size is unlimited 684s ok 16 - pg_ctlcluster 16 main stop 684s ok 17 - stopping cluster 684s ok 18 - restored pg_ctl default option 686s ok 19 - pg_ctlcluster 16 main start -- -c 686s ok 20 - starting cluster with -c on the command line as postgres 686s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 686s ok 22 - soft core size is unlimited 686s ok 23 - pg_ctlcluster 16 main stop 686s ok 24 - stopping cluster 688s ok 25 - dropping cluster 688s # Cleanup 688s ok 26 - Cleanup: No clusters left behind 688s ok 27 - No postgres processes left behind 688s ok 28 - No files in /etc/postgresql left behind 688s ok 29 - No files in /var/lib/postgresql left behind 688s ok 30 - No files in /var/run/postgresql left behind 688s ok 31 - No files in /var/log/postgresql left behind 688s ok 32 - PostgreSQL TCP ports are closed 688s ok 33 - Next free port is 5432 688s ### End test 085_pg_ctl.conf.t ### 688s 688s ### PostgreSQL test 090_multicluster.t ### 688s 1..125 690s ok 1 - pg_createcluster 16 old 691s ok 2 - pg_createcluster 16 new1 692s ok 3 - pg_createcluster 16 new2 694s ok 4 - starting cluster 16/old 697s ok 5 - starting cluster 16/new1 699s ok 6 - starting cluster 16/new2 699s ok 7 - pg_lsclusters -h | sort -k3 699s ok 8 - clusters have the correct ports, skipping used 5433 699s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 699s ok 10 - createdb --version 699s ok 11 - pg_wrapper selects port 5432 as default cluster 699s ok 12 - createdb --cluster 16/new1 --version 699s ok 13 - pg_wrapper --cluster works 699s ok 14 - createdb --cluster 16/foo --version 699s ok 15 - pg_wrapper --cluster errors out for invalid cluster 699s ok 16 - createdb --cluster 16/new1 test 699s ok 17 - correct output of createdb --cluster 16/new1 test 699s ok 18 - psql -Atl --cluster 16/new1 699s ok 19 - test db appears in cluster new1 699s ok 20 - psql -Atl --cluster 16/new2 699s ok 21 - test db does not appear in cluster new2 699s ok 22 - psql -Atl 699s ok 23 - test db does not appear in default cluster 699s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 699s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 699s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 699s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 699s ok 28 - psql -Atl --cluster 16/localhost:5434 699s ok 29 - test db appears in cluster 16/localhost:5434 700s ok 30 - psql -Atl --cluster 16/localhost:5440 700s ok 31 - test db does not appear in cluster 16/localhost:5440 700s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 700s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 700s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 700s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 700s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 700s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 700s ok 38 - psql -Atl --cluster 6.4/localhost: 700s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 700s ok 40 - psql -Atl 700s ok 41 - PGCLUSTER selection (1) 700s ok 42 - psql -Atl 700s ok 43 - PGCLUSTER selection (2) 700s ok 44 - psql -l 700s ok 45 - invalid PGCLUSTER value 700s ok 46 - createdb --version 700s ok 47 - PGCLUSTER network cluster selection (1) 700s ok 48 - psql -Atl 700s ok 49 - PGCLUSTER network cluster selection (2) 700s ok 50 - psql -Atl 700s ok 51 - PGCLUSTER network cluster selection (3) 700s ok 52 - LC_MESSAGES=C psql -Atl 700s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 700s ok 54 - psql -Atc "show port" template1 700s ok 55 - PGPORT selection (1) 700s ok 56 - psql -Atc "show port" template1 700s ok 57 - PGPORT selection (2) 700s ok 58 - createdb --version 700s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 700s ok 60 - psql -Atc "show port" template1 700s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 700s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 700s ok 63 - PGDATABASE environment variable works 700s ok 64 - createdb --version 700s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 700s ok 66 - createdb --cluster 16/new1 --version 700s ok 67 - pg_wrapper --cluster works with empty user_clusters 700s ok 68 - createdb --version 700s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 700s ok 70 - psql -Atc "select current_database()" 700s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 700s ok 72 - psql -Atc 'select current_database()' 700s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 700s ok 74 - createdb --version 700s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 700s ok 76 - createdb --version 700s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 701s ok 78 - createdb --version 701s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 701s ok 80 - createdb --version 701s ok 81 - pg_wrapper selects correct version with per-user user_clusters 701s ok 82 - createdb --version 701s ok 83 - pg_wrapper selects correct version with per-user user_clusters 701s ok 84 - createdb --version 701s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 701s ok 86 - psql -Atl 701s ok 87 - $PGHOST overrides user_clusters 701s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 701s ok 89 - --cluster overrides $PGHOST 701s ok 90 - createdb --version 701s ok 91 - pg_wrapper ignores invalid lines in user_clusters 701s ok 92 - psql -Atc 'select current_database()' 701s ok 93 - pg_service conf selection 1 701s ok 94 - psql -Atc 'select current_database()' 701s ok 95 - pg_service conf selection 2 701s ok 96 - psql -Atc 'select current_database()' 701s ok 97 - pg_service conf selection 3 701s ok 98 - stopping cluster 16/old 703s ok 99 - restarting cluster 16/old 703s ok 100 - pg_lsclusters -h | sort -k3 703s ok 101 - port of first cluster was successfully changed 704s ok 102 - psql -l 704s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 704s ok 104 - psql -Atl --cluster 16/new1 704s ok 105 - --cluster selects appropriate cluster 704s ok 106 - psql -Atl -p 5434 704s ok 107 - -p selects appropriate cluster 704s ok 108 - psql -Atlp 5434 704s ok 109 - -Atlp selects appropriate cluster 704s ok 110 - psql -Atl --port 5434 704s ok 111 - --port selects appropriate cluster 704s ok 112 - env PGPORT=5434 psql -Atl 704s ok 113 - $PGPORT selects appropriate cluster 704s ok 114 - Restoring original /etc/postgresql-common/user_clusters 706s ok 115 - dropping 16/new1 708s ok 116 - dropping 16/new2 710s ok 117 - dropping 16/old 710s # Cleanup 710s ok 118 - Cleanup: No clusters left behind 711s ok 119 - No postgres processes left behind 711s ok 120 - No files in /etc/postgresql left behind 711s ok 121 - No files in /var/lib/postgresql left behind 711s ok 122 - No files in /var/run/postgresql left behind 711s ok 123 - No files in /var/log/postgresql left behind 711s ok 124 - PostgreSQL TCP ports are closed 711s ok 125 - Next free port is 5432 711s ### End test 090_multicluster.t ### 711s 711s ### PostgreSQL test 110_integrate_cluster.t ### 711s 1..32 712s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/uHgAEz2cXY/c/postgres 712s ok 2 - creating raw initdb cluster for user postgres 712s ok 3 - pg_createcluster 16 postgres -d /tmp/uHgAEz2cXY/c/postgres 712s ok 4 - integrating postgres cluster 712s ok 5 - pg_lsclusters 712s ok 6 - correct pg_lsclusters output 714s ok 7 - pg_ctlcluster 16 postgres start 714s ok 8 - starting cluster postgres 715s ok 9 - pg_lsclusters 715s ok 10 - correct pg_lsclusters output 717s ok 11 - dropping cluster postgres 717s ok 12 - No files in temporary cluster dir left behind 718s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/uHgAEz2cXY/c/nobody 718s ok 14 - creating raw initdb cluster for user nobody 718s ok 15 - pg_createcluster 16 nobody -d /tmp/uHgAEz2cXY/c/nobody 718s ok 16 - integrating nobody cluster 718s ok 17 - pg_lsclusters 718s ok 18 - correct pg_lsclusters output 721s ok 19 - pg_ctlcluster 16 nobody start 721s ok 20 - starting cluster nobody 721s ok 21 - pg_lsclusters 721s ok 22 - correct pg_lsclusters output 723s ok 23 - dropping cluster nobody 723s ok 24 - No files in temporary cluster dir left behind 723s # Cleanup 723s ok 25 - Cleanup: No clusters left behind 723s ok 26 - No postgres processes left behind 723s ok 27 - No files in /etc/postgresql left behind 723s ok 28 - No files in /var/lib/postgresql left behind 723s ok 29 - No files in /var/run/postgresql left behind 723s ok 30 - No files in /var/log/postgresql left behind 723s ok 31 - PostgreSQL TCP ports are closed 723s ok 32 - Next free port is 5432 723s ### End test 110_integrate_cluster.t ### 723s 723s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 723s 1..1 723s ok 1 - only one major version installed, skipping upgrade tests 723s ### End test 120_pg_upgradecluster_scripts.t ### 723s 723s ### PostgreSQL test 130_nonroot_admin.t ### 723s 1..22 726s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 726s ok 2 - pg_lsclusters -h 726s ok 3 - correct output of pg_lsclusters -h 726s ok 4 - psql -Atl 726s ok 5 - correct output of psql -Atl 727s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 727s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 727s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 727s # Cleanup 727s ok 15 - Cleanup: No clusters left behind 727s ok 16 - No postgres processes left behind 727s ok 17 - No files in /etc/postgresql left behind 727s ok 18 - No files in /var/lib/postgresql left behind 727s ok 19 - No files in /var/run/postgresql left behind 727s ok 20 - No files in /var/log/postgresql left behind 727s ok 21 - PostgreSQL TCP ports are closed 727s ok 22 - Next free port is 5432 727s ### End test 130_nonroot_admin.t ### 727s 727s ### PostgreSQL test 135_pg_virtualenv.t ### 727s 1..20 733s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 733s ok 2 - running pg_virtualenv as root 736s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 736s ok 4 - running pg_virtualenv as postgres 739s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 739s ok 6 - running pg_virtualenv as nobody 743s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 743s ok 8 - running fakeroot pg_virtualenv as root 746s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 746s ok 10 - running fakeroot pg_virtualenv as postgres 749s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 749s ok 12 - running fakeroot pg_virtualenv as nobody 749s # Cleanup 749s ok 13 - Cleanup: No clusters left behind 749s ok 14 - No postgres processes left behind 749s ok 15 - No files in /etc/postgresql left behind 749s ok 16 - No files in /var/lib/postgresql left behind 749s ok 17 - No files in /var/run/postgresql left behind 749s ok 18 - No files in /var/log/postgresql left behind 749s ok 19 - PostgreSQL TCP ports are closed 749s ok 20 - Next free port is 5432 749s ### End test 135_pg_virtualenv.t ### 749s 749s ### PostgreSQL test 140_pg_config.t ### 749s 1..38 749s # Multiarch is enabled 749s # checking version specific output for 16 750s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 750s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 750s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 750s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 750s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 750s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 750s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 750s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 750s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 750s # checking pg_config output (should behave like version 16) 750s ok 15 - pg_config 750s ok 16 - correct output of pg_config 750s ok 17 - pg_config --help 750s ok 18 - correct output of pg_config --help 750s ok 19 - pg_config --pgxs 750s ok 20 - correct output of pg_config --pgxs 750s ok 21 - pg_config --libdir 750s ok 22 - correct output of pg_config --libdir 750s ok 23 - pg_config --pkglibdir 750s ok 24 - correct output of pg_config --pkglibdir 750s ok 25 - pg_config --bindir 750s ok 26 - correct output of pg_config --bindir 750s # checking pg_config.libpq-dev output (should behave like version 16) 750s ok 27 - pg_config.libpq-dev 750s ok 28 - correct output of pg_config.libpq-dev 750s ok 29 - pg_config.libpq-dev --help 750s ok 30 - correct output of pg_config.libpq-dev --help 750s ok 31 - pg_config.libpq-dev --pgxs 750s ok 32 - correct output of pg_config.libpq-dev --pgxs 750s ok 33 - pg_config.libpq-dev --libdir 750s ok 34 - correct output of pg_config.libpq-dev --libdir 750s ok 35 - pg_config.libpq-dev --pkglibdir 750s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 750s ok 37 - pg_config.libpq-dev --bindir 750s ok 38 - correct output of pg_config.libpq-dev --bindir 750s ### End test 140_pg_config.t ### 750s 750s ### PostgreSQL test 150_tsearch_stemming.t ### 750s 1..37 750s ok 1 - pg_updatedicts succeeded 750s ok 2 - pg_updatedicts created en_us.affix 750s ok 3 - pg_updatedicts created en_us.dict 750s ok 4 - pg_updatedicts created 16 en_us.affix symlink 750s ok 5 - pg_updatedicts created 16 en_us.dict symlink 753s ok 6 - pg_createcluster 16 main 753s ok 7 - createdb fts 753s ok 8 - correct output of createdb fts 753s ok 9 - creating en_US full text search configuration 754s ok 10 - creating data table and search index 754s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 754s ok 12 - stem search of correct word 754s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 754s ok 14 - stem search of correct word 754s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 754s ok 16 - stem search of unknown word 754s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 754s ok 18 - full text search, exact word 754s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 754s ok 20 - full text search for word stem 754s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 754s ok 22 - full text search for word substring fails 754s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 754s ok 24 - full text search, exact unicode word 754s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 754s ok 26 - full text search for unicode word stem 754s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 754s ok 28 - full text search for unicode word substring fails 757s ok 29 757s # Cleanup 757s ok 30 - Cleanup: No clusters left behind 757s ok 31 - No postgres processes left behind 757s ok 32 - No files in /etc/postgresql left behind 757s ok 33 - No files in /var/lib/postgresql left behind 757s ok 34 - No files in /var/run/postgresql left behind 757s ok 35 - No files in /var/log/postgresql left behind 757s ok 36 - PostgreSQL TCP ports are closed 757s ok 37 - Next free port is 5432 757s ### End test 150_tsearch_stemming.t ### 757s 757s ### PostgreSQL test 160_alternate_confroot.t ### 757s 1..28 760s ok 1 760s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 760s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 760s ok 4 - pg_lsclusters -h 760s ok 5 - correct output of pg_lsclusters -h 761s ok 6 - psql -Atl 761s ok 7 - correct output of psql -Atl 761s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 761s ok 9 - ... 761s ok 10 - ... 761s ok 11 - ... 761s ok 12 - ... 761s ok 13 - ... 761s ok 14 - ... 761s ok 15 - pg_dropcluster 16 test --stop 761s ok 16 - correct output of pg_dropcluster 16 test --stop 761s ok 17 - pg_lsclusters -h 761s ok 18 - correct output of pg_lsclusters -h 761s ok 19 - No files in root/data left behind 761s ok 20 - No cruft in root dir left behind 761s # Cleanup 761s ok 21 - Cleanup: No clusters left behind 761s ok 22 - No postgres processes left behind 761s ok 23 - No files in /etc/postgresql left behind 761s ok 24 - No files in /var/lib/postgresql left behind 761s ok 25 - No files in /var/run/postgresql left behind 761s ok 26 - No files in /var/log/postgresql left behind 761s ok 27 - PostgreSQL TCP ports are closed 761s ok 28 - Next free port is 5432 761s ### End test 160_alternate_confroot.t ### 761s 761s ### PostgreSQL test 170_extensions.t ### 761s # Running tests for 16 765s ok 1 - pg_createcluster 16 main 765s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 765s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 765s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 765s ok 5 - extension adminpack installs without error 765s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 765s ok 7 - extension adminpack removes without error 765s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 765s ok 9 - extension amcheck installs without error 765s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 765s ok 11 - extension amcheck removes without error 765s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 765s ok 13 - extension autoinc installs without error 765s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 765s ok 15 - extension autoinc removes without error 765s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 765s ok 17 - extension bloom installs without error 765s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 765s ok 19 - extension bloom removes without error 765s ok 20 - psql -qc 'CREATE EXTENSION plperl' 765s ok 21 - bool_plperl dependency plperl installs without error 765s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 765s ok 23 - extension bool_plperl installs without error 765s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 765s ok 25 - extension bool_plperl removes without error 765s ok 26 - psql -qc 'DROP EXTENSION plperl' 765s ok 27 - bool_plperl dependency extension plperl removes without error 766s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 766s ok 29 - bool_plperlu dependency plperlu installs without error 766s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 766s ok 31 - extension bool_plperlu installs without error 766s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 766s ok 33 - extension bool_plperlu removes without error 766s ok 34 - psql -qc 'DROP EXTENSION plperlu' 766s ok 35 - bool_plperlu dependency extension plperlu removes without error 766s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 766s ok 37 - extension btree_gin installs without error 766s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 766s ok 39 - extension btree_gin removes without error 766s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 766s ok 41 - extension btree_gist installs without error 766s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 766s ok 43 - extension btree_gist removes without error 766s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 766s ok 45 - extension citext installs without error 766s ok 46 - psql -qc 'DROP EXTENSION "citext"' 766s ok 47 - extension citext removes without error 766s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 766s ok 49 - extension cube installs without error 766s ok 50 - psql -qc 'DROP EXTENSION "cube"' 766s ok 51 - extension cube removes without error 766s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 766s ok 53 - extension dblink installs without error 766s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 766s ok 55 - extension dblink removes without error 766s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 766s ok 57 - extension dict_int installs without error 766s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 766s ok 59 - extension dict_int removes without error 766s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 766s ok 61 - extension dict_xsyn installs without error 767s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 767s ok 63 - extension dict_xsyn removes without error 767s ok 64 - psql -qc 'CREATE EXTENSION cube' 767s ok 65 - earthdistance dependency cube installs without error 767s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 767s ok 67 - extension earthdistance installs without error 767s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 767s ok 69 - extension earthdistance removes without error 767s ok 70 - psql -qc 'DROP EXTENSION cube' 767s ok 71 - earthdistance dependency extension cube removes without error 767s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 767s ok 73 - extension file_fdw installs without error 767s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 767s ok 75 - extension file_fdw removes without error 767s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 767s ok 77 - extension fuzzystrmatch installs without error 767s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 767s ok 79 - extension fuzzystrmatch removes without error 767s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 767s ok 81 - extension hstore installs without error 767s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 767s ok 83 - extension hstore removes without error 767s ok 84 - psql -qc 'CREATE EXTENSION hstore' 767s ok 85 - hstore_plperl dependency hstore installs without error 767s ok 86 - psql -qc 'CREATE EXTENSION plperl' 767s ok 87 - hstore_plperl dependency plperl installs without error 767s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 767s ok 89 - extension hstore_plperl installs without error 767s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 767s ok 91 - extension hstore_plperl removes without error 767s ok 92 - psql -qc 'DROP EXTENSION hstore' 767s ok 93 - hstore_plperl dependency extension hstore removes without error 767s ok 94 - psql -qc 'DROP EXTENSION plperl' 767s ok 95 - hstore_plperl dependency extension plperl removes without error 768s ok 96 - psql -qc 'CREATE EXTENSION hstore' 768s ok 97 - hstore_plperlu dependency hstore installs without error 768s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 768s ok 99 - hstore_plperlu dependency plperlu installs without error 768s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 768s ok 101 - extension hstore_plperlu installs without error 768s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 768s ok 103 - extension hstore_plperlu removes without error 768s ok 104 - psql -qc 'DROP EXTENSION hstore' 768s ok 105 - hstore_plperlu dependency extension hstore removes without error 768s ok 106 - psql -qc 'DROP EXTENSION plperlu' 768s ok 107 - hstore_plperlu dependency extension plperlu removes without error 768s ok 108 - psql -qc 'CREATE EXTENSION hstore' 768s ok 109 - hstore_plpython3u dependency hstore installs without error 768s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 768s ok 111 - hstore_plpython3u dependency plpython3u installs without error 768s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 768s ok 113 - extension hstore_plpython3u installs without error 768s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 768s ok 115 - extension hstore_plpython3u removes without error 768s ok 116 - psql -qc 'DROP EXTENSION hstore' 768s ok 117 - hstore_plpython3u dependency extension hstore removes without error 768s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 768s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 768s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 768s ok 121 - extension insert_username installs without error 768s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 768s ok 123 - extension insert_username removes without error 768s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 768s ok 125 - extension intagg installs without error 768s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 768s ok 127 - extension intagg removes without error 768s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 768s ok 129 - extension intarray installs without error 769s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 769s ok 131 - extension intarray removes without error 769s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 769s ok 133 - extension isn installs without error 769s ok 134 - psql -qc 'DROP EXTENSION "isn"' 769s ok 135 - extension isn removes without error 769s ok 136 - psql -qc 'CREATE EXTENSION plperl' 769s ok 137 - jsonb_plperl dependency plperl installs without error 769s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 769s ok 139 - extension jsonb_plperl installs without error 769s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 769s ok 141 - extension jsonb_plperl removes without error 769s ok 142 - psql -qc 'DROP EXTENSION plperl' 769s ok 143 - jsonb_plperl dependency extension plperl removes without error 769s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 769s ok 145 - jsonb_plperlu dependency plperlu installs without error 769s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 769s ok 147 - extension jsonb_plperlu installs without error 769s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 769s ok 149 - extension jsonb_plperlu removes without error 769s ok 150 - psql -qc 'DROP EXTENSION plperlu' 769s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 769s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 769s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 769s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 769s ok 155 - extension jsonb_plpython3u installs without error 769s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 769s ok 157 - extension jsonb_plpython3u removes without error 769s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 769s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 770s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 770s ok 161 - extension lo installs without error 770s ok 162 - psql -qc 'DROP EXTENSION "lo"' 770s ok 163 - extension lo removes without error 770s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 770s ok 165 - extension ltree installs without error 770s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 770s ok 167 - extension ltree removes without error 770s ok 168 - psql -qc 'CREATE EXTENSION ltree' 770s ok 169 - ltree_plpython3u dependency ltree installs without error 770s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 770s ok 171 - ltree_plpython3u dependency plpython3u installs without error 770s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 770s ok 173 - extension ltree_plpython3u installs without error 770s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 770s ok 175 - extension ltree_plpython3u removes without error 770s ok 176 - psql -qc 'DROP EXTENSION ltree' 770s ok 177 - ltree_plpython3u dependency extension ltree removes without error 770s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 770s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 770s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 770s ok 181 - extension moddatetime installs without error 770s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 770s ok 183 - extension moddatetime removes without error 770s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 770s ok 185 - extension old_snapshot installs without error 770s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 770s ok 187 - extension old_snapshot removes without error 770s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 770s ok 189 - extension pageinspect installs without error 770s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 770s ok 191 - extension pageinspect removes without error 770s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 770s ok 193 - extension pg_buffercache installs without error 771s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 771s ok 195 - extension pg_buffercache removes without error 771s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 771s ok 197 - extension pg_freespacemap installs without error 771s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 771s ok 199 - extension pg_freespacemap removes without error 771s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 771s ok 201 - extension pg_prewarm installs without error 771s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 771s ok 203 - extension pg_prewarm removes without error 771s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 771s ok 205 - extension pg_stat_statements installs without error 771s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 771s ok 207 - extension pg_stat_statements removes without error 771s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 771s ok 209 - extension pg_surgery installs without error 771s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 771s ok 211 - extension pg_surgery removes without error 771s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 771s ok 213 - extension pg_trgm installs without error 771s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 771s ok 215 - extension pg_trgm removes without error 771s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 771s ok 217 - extension pg_visibility installs without error 771s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 771s ok 219 - extension pg_visibility removes without error 771s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 771s ok 221 - extension pg_walinspect installs without error 771s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 771s ok 223 - extension pg_walinspect removes without error 771s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 771s ok 225 - extension pgcrypto installs without error 771s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 771s ok 227 - extension pgcrypto removes without error 771s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 771s ok 229 - extension pgrowlocks installs without error 771s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 771s ok 231 - extension pgrowlocks removes without error 772s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 772s ok 233 - extension pgstattuple installs without error 772s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 772s ok 235 - extension pgstattuple removes without error 772s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 772s ok 237 - extension plperl installs without error 772s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 772s ok 239 - extension plperl removes without error 772s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 772s ok 241 - extension plperlu installs without error 772s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 772s ok 243 - extension plperlu removes without error 772s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 772s ok 245 - extension plpython3u installs without error 772s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 772s ok 247 - extension plpython3u removes without error 772s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 772s ok 249 - extension pltcl installs without error 772s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 772s ok 251 - extension pltcl removes without error 772s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 772s ok 253 - extension pltclu installs without error 772s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 772s ok 255 - extension pltclu removes without error 772s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 772s ok 257 - extension postgres_fdw installs without error 772s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 772s ok 259 - extension postgres_fdw removes without error 772s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 772s ok 261 - extension refint installs without error 772s ok 262 - psql -qc 'DROP EXTENSION "refint"' 772s ok 263 - extension refint removes without error 772s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 772s ok 265 - extension seg installs without error 772s ok 266 - psql -qc 'DROP EXTENSION "seg"' 772s ok 267 - extension seg removes without error 772s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 772s ok 269 - extension sslinfo installs without error 773s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 773s ok 271 - extension sslinfo removes without error 773s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 773s ok 273 - extension tablefunc installs without error 773s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 773s ok 275 - extension tablefunc removes without error 773s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 773s ok 277 - extension tcn installs without error 773s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 773s ok 279 - extension tcn removes without error 773s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 773s ok 281 - extension tsm_system_rows installs without error 773s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 773s ok 283 - extension tsm_system_rows removes without error 773s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 773s ok 285 - extension tsm_system_time installs without error 773s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 773s ok 287 - extension tsm_system_time removes without error 773s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 773s ok 289 - extension unaccent installs without error 773s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 773s ok 291 - extension unaccent removes without error 773s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 773s ok 293 - extension uuid-ossp installs without error 773s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 773s ok 295 - extension uuid-ossp removes without error 773s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 773s ok 297 - extension xml2 installs without error 773s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 773s ok 299 - extension xml2 removes without error 776s ok 300 - pg_dropcluster 16 main 776s # Cleanup 776s ok 301 - Cleanup: No clusters left behind 776s ok 302 - No postgres processes left behind 776s ok 303 - No files in /etc/postgresql left behind 776s ok 304 - No files in /var/lib/postgresql left behind 776s ok 305 - No files in /var/run/postgresql left behind 776s ok 306 - No files in /var/log/postgresql left behind 776s ok 307 - PostgreSQL TCP ports are closed 776s ok 308 - Next free port is 5432 776s 1..308 776s ### End test 170_extensions.t ### 776s 776s ### PostgreSQL test 180_ecpg.t ### 776s 1..14 776s ok 1 - ecpg test.pgc 776s ok 2 - ecpg processing 776s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 776s ok 4 - compiling ecpg output 784s ok 5 - pg_virtualenv /tmp/tmp.OfOGAldp2B/test 784s ok 6 - test program runs and gives correct output 784s # Cleanup 784s ok 7 - Cleanup: No clusters left behind 784s ok 8 - No postgres processes left behind 784s ok 9 - No files in /etc/postgresql left behind 784s ok 10 - No files in /var/lib/postgresql left behind 784s ok 11 - No files in /var/run/postgresql left behind 784s ok 12 - No files in /var/log/postgresql left behind 784s ok 13 - PostgreSQL TCP ports are closed 784s ok 14 - Next free port is 5432 784s ### End test 180_ecpg.t ### 784s 784s ### PostgreSQL test 190_pg_buildext.t ### 784s ok 1 - make clean 784s ok 2 - make tar 784s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 784s # testing 'dh --with pgxs' 788s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 788s ok 5 - postgresql-16-foo_123-1_ppc64el.deb was built 796s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 796s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 796s ok 8 - dpkg -i postgresql-16-foo_123-1_ppc64el.deb 804s ok 9 - cd foo-123 && pg_buildext installcheck 804s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 811s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 811s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 819s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 819s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 819s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 819s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 819s ok 17 - dpkg -r postgresql-16-foo 819s # testing 'dh --with pgxs_loop' 819s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 823s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 823s ok 20 - postgresql-16-foo_123-1_ppc64el.deb was built 823s ok 21 - make clean 823s # testing pg_buildext updatecontrol 823s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 823s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 823s 1..23 823s ### End test 190_pg_buildext.t ### 823s 823s ### PostgreSQL test 200_maintscripts.t ### 823s 1..15 823s # We are running systemd 826s ok 1 - pg_createcluster 16 main --start 826s ok 2 - postmaster PID is 22912 829s ok 3 - apt-get update -q 829s # postgresql-common: 829s # Installed: 260 829s # Candidate: 260 829s # Version table: 829s # *** 260 990 829s # 990 http://ftpmaster.internal/ubuntu oracular/main ppc64el Packages 829s # 100 /var/lib/dpkg/status 833s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 833s # postgresql-common: 833s # Installed: 260 833s # Candidate: 260 833s # Version table: 833s # *** 260 990 833s # 990 http://ftpmaster.internal/ubuntu oracular/main ppc64el Packages 833s # 100 /var/lib/dpkg/status 833s ok 5 - postmaster PID is 22912 833s ok 6 - postmaster was not restarted 836s ok 7 - pg_dropcluster 16 main --stop 836s # Cleanup 836s ok 8 - Cleanup: No clusters left behind 836s ok 9 - No postgres processes left behind 836s ok 10 - No files in /etc/postgresql left behind 836s ok 11 - No files in /var/lib/postgresql left behind 836s ok 12 - No files in /var/run/postgresql left behind 836s ok 13 - No files in /var/log/postgresql left behind 836s ok 14 - PostgreSQL TCP ports are closed 836s ok 15 - Next free port is 5432 836s ### End test 200_maintscripts.t ### 836s 837s autopkgtest [08:41:13]: test run-testsuite: -----------------------] 837s autopkgtest [08:41:13]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 837s run-testsuite PASS 838s autopkgtest [08:41:14]: @@@@@@@@@@@@@@@@@@@@ summary 838s default-psql PASS 838s run-testsuite PASS 852s nova [W] Using flock in scalingstack-bos01-ppc64el 852s flock: timeout while waiting to get lock 852s Creating nova instance adt-oracular-ppc64el-postgresql-common-20240625-082716-juju-7f2275-prod-proposed-migration-environment-2-52a80986-4c5c-404f-a80f-938c2c617d32 from image adt/ubuntu-oracular-ppc64el-server-20240624.img (UUID 2e934ca9-4558-4da2-a99b-54bdb872d71d)... 852s nova [W] Using flock in scalingstack-bos01-ppc64el 852s Creating nova instance adt-oracular-ppc64el-postgresql-common-20240625-082716-juju-7f2275-prod-proposed-migration-environment-2-52a80986-4c5c-404f-a80f-938c2c617d32 from image adt/ubuntu-oracular-ppc64el-server-20240624.img (UUID 2e934ca9-4558-4da2-a99b-54bdb872d71d)...