0s autopkgtest [22:06:24]: starting date and time: 2025-11-05 22:06:24+0000 0s autopkgtest [22:06:24]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [22:06:24]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.5xtzg9c3/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:iproute2,src:aardvark-dns,src:etcd,src:golang-github-containers-buildah,src:hippotat,src:netavark,src:podman,src:postgresql-17,src:systemd,src:xdp-tools --apt-upgrade postgresql-18 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=iproute2/6.16.0-1ubuntu3 aardvark-dns/1.16.0-2 etcd/3.5.16-8 golang-github-containers-buildah/1.41.5+ds1-4 hippotat/1.2.3 netavark/1.16.1-3 podman/5.6.2+ds1-4 postgresql-17/17.6-1build2 systemd/258.1-2ubuntu1 xdp-tools/1.5.7-3' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-amd64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@sto01-7.secgroup --name adt-resolute-amd64-postgresql-18-20251105-220624-juju-7f2275-prod-proposed-migration-environment-15-50d60b98-6e3f-4097-9e2d-9cd438e99714 --image adt/ubuntu-resolute-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-autopkgtest-workers-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 3s Creating nova instance adt-resolute-amd64-postgresql-18-20251105-220624-juju-7f2275-prod-proposed-migration-environment-15-50d60b98-6e3f-4097-9e2d-9cd438e99714 from image adt/ubuntu-resolute-amd64-server-20251105.img (UUID eb17d881-e071-44a1-b6a3-2a1b60703e11)... 56s autopkgtest [22:07:20]: testbed dpkg architecture: amd64 57s autopkgtest [22:07:21]: testbed apt version: 3.1.11 57s autopkgtest [22:07:21]: @@@@@@@@@@@@@@@@@@@@ test bed setup 57s autopkgtest [22:07:21]: testbed release detected to be: None 58s autopkgtest [22:07:22]: updating testbed package index (apt update) 58s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 58s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 58s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 58s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 58s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [74.3 kB] 58s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 58s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [857 kB] 59s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.4 kB] 59s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [78.2 kB] 59s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [117 kB] 59s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3036 B] 59s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 59s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 59s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 59s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [497 kB] 59s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [222 kB] 59s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [16.2 kB] 59s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [5984 B] 59s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [12.9 kB] 59s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [672 B] 60s Fetched 2073 kB in 1s (1863 kB/s) 60s Reading package lists... 61s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 61s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 61s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 61s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 61s Reading package lists... 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 61s Calculating upgrade... 62s The following packages will be upgraded: 62s bash iproute2 liblzma5 libnss-systemd libpam-systemd libsystemd-shared 62s libsystemd0 libtracefs1 libudev1 libzstd1 systemd systemd-cryptsetup 62s systemd-resolved systemd-sysv udev xz-utils zstd 62s 17 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 62s Need to get 12.2 MB of archives. 62s After this operation, 1203 kB of additional disk space will be used. 62s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 bash amd64 5.3-1ubuntu1 [859 kB] 62s Get:2 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd0 amd64 258.1-2ubuntu1 [540 kB] 62s Get:3 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-sysv amd64 258.1-2ubuntu1 [9250 B] 62s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-resolved amd64 258.1-2ubuntu1 [343 kB] 62s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libnss-systemd amd64 258.1-2ubuntu1 [183 kB] 62s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libpam-systemd amd64 258.1-2ubuntu1 [271 kB] 62s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd-shared amd64 258.1-2ubuntu1 [2392 kB] 63s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd amd64 258.1-2ubuntu1 [3085 kB] 63s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-cryptsetup amd64 258.1-2ubuntu1 [123 kB] 63s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 udev amd64 258.1-2ubuntu1 [1474 kB] 64s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libudev1 amd64 258.1-2ubuntu1 [212 kB] 64s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma5 amd64 5.8.1-2 [144 kB] 64s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libzstd1 amd64 1.5.7+dfsg-2 [308 kB] 64s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 iproute2 amd64 6.16.0-1ubuntu3 [1157 kB] 64s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libtracefs1 amd64 1.8.2-1ubuntu1 [68.0 kB] 64s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 xz-utils amd64 5.8.1-2 [348 kB] 64s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 zstd amd64 1.5.7+dfsg-2 [672 kB] 64s dpkg-preconfigure: unable to re-open stdin: No such file or directory 64s Fetched 12.2 MB in 2s (5507 kB/s) 64s (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 ... 83325 files and directories currently installed.) 64s Preparing to unpack .../bash_5.3-1ubuntu1_amd64.deb ... 64s Unpacking bash (5.3-1ubuntu1) over (5.2.37-2ubuntu5) ... 64s Setting up bash (5.3-1ubuntu1) ... 64s Installing new version of config file /etc/bash.bashrc ... 64s update-alternatives: using /usr/share/man/man7/bash-builtins.7.gz to provide /usr/share/man/man7/builtins.7.gz (builtins.7.gz) in auto mode 64s (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 ... 83325 files and directories currently installed.) 64s Preparing to unpack .../libsystemd0_258.1-2ubuntu1_amd64.deb ... 64s Unpacking libsystemd0:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Setting up libsystemd0:amd64 (258.1-2ubuntu1) ... 64s (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 ... 83325 files and directories currently installed.) 64s Preparing to unpack .../systemd-sysv_258.1-2ubuntu1_amd64.deb ... 64s Unpacking systemd-sysv (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Preparing to unpack .../systemd-resolved_258.1-2ubuntu1_amd64.deb ... 64s Unpacking systemd-resolved (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Preparing to unpack .../libnss-systemd_258.1-2ubuntu1_amd64.deb ... 64s Unpacking libnss-systemd:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Preparing to unpack .../libpam-systemd_258.1-2ubuntu1_amd64.deb ... 64s Unpacking libpam-systemd:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Preparing to unpack .../libsystemd-shared_258.1-2ubuntu1_amd64.deb ... 64s Unpacking libsystemd-shared:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 64s Setting up libsystemd-shared:amd64 (258.1-2ubuntu1) ... 65s (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 ... 83324 files and directories currently installed.) 65s Preparing to unpack .../systemd_258.1-2ubuntu1_amd64.deb ... 65s Unpacking systemd (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 65s Preparing to unpack .../systemd-cryptsetup_258.1-2ubuntu1_amd64.deb ... 65s Unpacking systemd-cryptsetup (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 65s Preparing to unpack .../udev_258.1-2ubuntu1_amd64.deb ... 65s Unpacking udev (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 65s Preparing to unpack .../libudev1_258.1-2ubuntu1_amd64.deb ... 65s Unpacking libudev1:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 65s Setting up libudev1:amd64 (258.1-2ubuntu1) ... 65s (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 ... 83382 files and directories currently installed.) 65s Preparing to unpack .../liblzma5_5.8.1-2_amd64.deb ... 65s Unpacking liblzma5:amd64 (5.8.1-2) over (5.8.1-1build2) ... 65s Setting up liblzma5:amd64 (5.8.1-2) ... 65s (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 ... 83382 files and directories currently installed.) 65s Preparing to unpack .../libzstd1_1.5.7+dfsg-2_amd64.deb ... 65s Unpacking libzstd1:amd64 (1.5.7+dfsg-2) over (1.5.7+dfsg-1build2) ... 65s Setting up libzstd1:amd64 (1.5.7+dfsg-2) ... 65s (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 ... 83382 files and directories currently installed.) 65s Preparing to unpack .../iproute2_6.16.0-1ubuntu3_amd64.deb ... 65s Unpacking iproute2 (6.16.0-1ubuntu3) over (6.16.0-1ubuntu2) ... 65s Preparing to unpack .../libtracefs1_1.8.2-1ubuntu1_amd64.deb ... 65s Unpacking libtracefs1:amd64 (1.8.2-1ubuntu1) over (1.8.1-1ubuntu1) ... 65s Preparing to unpack .../xz-utils_5.8.1-2_amd64.deb ... 65s Unpacking xz-utils (5.8.1-2) over (5.8.1-1build2) ... 65s Preparing to unpack .../zstd_1.5.7+dfsg-2_amd64.deb ... 65s Unpacking zstd (1.5.7+dfsg-2) over (1.5.7+dfsg-1build2) ... 65s Setting up iproute2 (6.16.0-1ubuntu3) ... 65s Setting up systemd (258.1-2ubuntu1) ... 65s Installing new version of config file /etc/systemd/logind.conf ... 65s Installing new version of config file /etc/systemd/networkd.conf ... 65s Installing new version of config file /etc/systemd/system.conf ... 65s Installing new version of config file /etc/systemd/user.conf ... 65s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 65s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 66s Setting up systemd-cryptsetup (258.1-2ubuntu1) ... 66s Setting up xz-utils (5.8.1-2) ... 66s Setting up udev (258.1-2ubuntu1) ... 67s Setting up libtracefs1:amd64 (1.8.2-1ubuntu1) ... 67s Setting up zstd (1.5.7+dfsg-2) ... 67s Setting up systemd-resolved (258.1-2ubuntu1) ... 67s Installing new version of config file /etc/systemd/resolved.conf ... 67s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-monitor.socket' → '/usr/lib/systemd/system/systemd-resolved-monitor.socket'. 67s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-varlink.socket' → '/usr/lib/systemd/system/systemd-resolved-varlink.socket'. 67s Could not execute systemctl: at /usr/bin/deb-systemd-invoke line 148. 67s Setting up systemd-sysv (258.1-2ubuntu1) ... 67s Setting up libnss-systemd:amd64 (258.1-2ubuntu1) ... 67s Setting up libpam-systemd:amd64 (258.1-2ubuntu1) ... 67s Processing triggers for install-info (7.2-5) ... 67s Processing triggers for initramfs-tools (0.150ubuntu4) ... 67s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 72s Processing triggers for libc-bin (2.42-0ubuntu3) ... 72s Processing triggers for man-db (2.13.1-1) ... 73s Processing triggers for dbus (1.16.2-2ubuntu2) ... 73s Processing triggers for shared-mime-info (2.4-5build2) ... 74s Processing triggers for procps (2:4.0.4-8ubuntu3) ... 74s Processing triggers for debianutils (5.23.2) ... 74s autopkgtest [22:07:38]: upgrading testbed (apt dist-upgrade and autopurge) 74s Reading package lists... 75s Building dependency tree... 75s Reading state information... 75s Calculating upgrade... 75s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 75s Reading package lists... 75s Building dependency tree... 75s Reading state information... 75s Solving dependencies... 75s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 75s autopkgtest [22:07:39]: rebooting testbed after setup commands that affected boot 103s autopkgtest [22:08:07]: testbed running kernel: Linux 6.17.0-5-generic #5-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 22 10:00:33 UTC 2025 105s autopkgtest [22:08:09]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-18 111s Get:1 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (dsc) [4420 B] 111s Get:2 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (tar) [22.4 MB] 111s Get:3 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (diff) [22.9 kB] 111s gpgv: Signature made Fri Sep 26 07:48:05 2025 UTC 111s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 111s gpgv: Can't check signature: No public key 111s dpkg-source: warning: cannot verify inline signature for ./postgresql-18_18.0-1.dsc: no acceptable signature found 114s autopkgtest [22:08:18]: testing package postgresql-18 version 18.0-1 115s autopkgtest [22:08:19]: build not needed 123s autopkgtest [22:08:27]: test run-testsuite: preparing testbed 123s Reading package lists... 123s Building dependency tree... 123s Reading state information... 123s Solving dependencies... 123s The following NEW packages will be installed: 123s autoconf automake autopoint autotools-dev build-essential clang-21 cpp 123s cpp-15 cpp-15-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 123s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 123s fakeroot g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-15 123s gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 123s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-21-dev 123s libclang-cpp21 libclang1-21 libdebhelper-perl libecpg-compat3 libecpg-dev 123s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 123s libgcc-15-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 123s libitm1 libjson-perl libllvm21 liblsan0 liblzma-dev libmpc3 libncurses-dev 123s libobjc-15-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq-oauth libpq5 123s libquadmath0 libssl-dev libstdc++-15-dev libtcl8.6 libtool libtsan2 123s libubsan1 liburing2 libxml2-dev libxslt1.1 llvm-21 llvm-21-dev 123s llvm-21-linker-tools llvm-21-runtime llvm-21-tools locales-all m4 po-debconf 123s postgresql-18 postgresql-18-jit postgresql-client-18 123s postgresql-client-common postgresql-common postgresql-common-dev 123s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 123s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert zlib1g-dev 123s 0 upgraded, 94 newly installed, 0 to remove and 0 not upgraded. 123s Need to get 247 MB of archives. 123s After this operation, 1366 MB of additional disk space will be used. 123s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 123s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 123s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 123s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20250809.0-1 [94.4 kB] 123s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 123s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 123s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 123s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 m4 amd64 1.4.20-2 [217 kB] 123s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 123s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 autotools-dev all 20240727.1 [43.4 kB] 123s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 automake all 1:1.18.1-2 [581 kB] 123s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 autopoint all 0.23.1-2build2 [619 kB] 123s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 123s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-2 [54.8 kB] 123s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 124s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 124s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 124s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 124s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 124s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 124s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 124s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 124s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 124s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 124s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 124s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 124s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 124s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 124s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 124s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 124s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 124s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 124s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 124s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 125s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 125s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 125s Get:37 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 125s Get:38 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 125s Get:39 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 125s Get:40 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 126s Get:41 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 126s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 126s Get:43 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 126s Get:44 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 126s Get:45 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 126s Get:46 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 126s Get:47 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 126s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 126s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libtool all 2.5.4-7 [169 kB] 126s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-autoreconf all 21 [12.5 kB] 126s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 126s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [20.5 kB] 126s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-strip-nondeterminism all 1.15.0-1 [5090 B] 126s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 debugedit amd64 1:5.2-3 [49.9 kB] 126s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 dwz amd64 0.16-2 [115 kB] 126s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 gettext amd64 0.23.1-2build2 [1043 kB] 126s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 126s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 126s Get:59 http://ftpmaster.internal/ubuntu resolute/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 126s Get:60 http://ftpmaster.internal/ubuntu resolute/main amd64 emacsen-common all 3.0.8 [13.9 kB] 126s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 dictionaries-common all 1.30.11 [178 kB] 126s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 126s Get:63 http://ftpmaster.internal/ubuntu resolute/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 126s Get:64 http://ftpmaster.internal/ubuntu resolute/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 126s Get:65 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 126s Get:66 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 126s Get:67 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 126s Get:68 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 126s Get:69 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 126s Get:70 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 126s Get:71 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 126s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 127s Get:73 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 127s Get:74 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 127s Get:75 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 127s Get:76 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-2 [179 kB] 127s Get:77 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 127s Get:78 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 127s Get:79 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 127s Get:80 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 127s Get:81 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 127s Get:82 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 128s Get:83 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 128s Get:84 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 128s Get:85 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 129s Get:86 http://ftpmaster.internal/ubuntu resolute/main amd64 locales-all amd64 2.42-0ubuntu3 [11.2 MB] 130s Get:87 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 130s Get:88 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 130s Get:89 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 131s Get:90 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 131s Get:91 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 131s Get:92 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 131s Get:93 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 131s Get:94 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 131s Preconfiguring packages ... 131s Fetched 247 MB in 8s (31.5 MB/s) 131s Selecting previously unselected package libjson-perl. 131s (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 ... 83382 files and directories currently installed.) 131s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 131s Unpacking libjson-perl (4.10000-1) ... 131s Selecting previously unselected package postgresql-client-common. 131s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 131s Unpacking postgresql-client-common (282ubuntu1) ... 131s Selecting previously unselected package libio-pty-perl. 131s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 131s Unpacking libio-pty-perl (1:1.20-1build3) ... 131s Selecting previously unselected package libipc-run-perl. 131s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 131s Unpacking libipc-run-perl (20250809.0-1) ... 131s Selecting previously unselected package postgresql-common-dev. 131s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 131s Unpacking postgresql-common-dev (282ubuntu1) ... 131s Selecting previously unselected package ssl-cert. 131s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 131s Unpacking ssl-cert (1.1.3ubuntu1) ... 131s Selecting previously unselected package postgresql-common. 131s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 131s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 131s Unpacking postgresql-common (282ubuntu1) ... 131s Selecting previously unselected package m4. 131s Preparing to unpack .../07-m4_1.4.20-2_amd64.deb ... 131s Unpacking m4 (1.4.20-2) ... 131s Selecting previously unselected package autoconf. 131s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 131s Unpacking autoconf (2.72-3.1ubuntu1) ... 131s Selecting previously unselected package autotools-dev. 131s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 131s Unpacking autotools-dev (20240727.1) ... 131s Selecting previously unselected package automake. 131s Preparing to unpack .../10-automake_1%3a1.18.1-2_all.deb ... 131s Unpacking automake (1:1.18.1-2) ... 131s Selecting previously unselected package autopoint. 131s Preparing to unpack .../11-autopoint_0.23.1-2build2_all.deb ... 131s Unpacking autopoint (0.23.1-2build2) ... 131s Selecting previously unselected package libisl23:amd64. 131s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 131s Unpacking libisl23:amd64 (0.27-1) ... 131s Selecting previously unselected package libmpc3:amd64. 131s Preparing to unpack .../13-libmpc3_1.3.1-2_amd64.deb ... 131s Unpacking libmpc3:amd64 (1.3.1-2) ... 131s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 131s Preparing to unpack .../14-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 131s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package cpp-15. 132s Preparing to unpack .../15-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package cpp-x86-64-linux-gnu. 132s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package cpp. 132s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking cpp (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package libcc1-0:amd64. 132s Preparing to unpack .../18-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libgomp1:amd64. 132s Preparing to unpack .../19-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libitm1:amd64. 132s Preparing to unpack .../20-libitm1_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libasan8:amd64. 132s Preparing to unpack .../21-libasan8_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package liblsan0:amd64. 132s Preparing to unpack .../22-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libtsan2:amd64. 132s Preparing to unpack .../23-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libubsan1:amd64. 132s Preparing to unpack .../24-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libhwasan0:amd64. 132s Preparing to unpack .../25-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libquadmath0:amd64. 132s Preparing to unpack .../26-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package libgcc-15-dev:amd64. 132s Preparing to unpack .../27-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 132s Preparing to unpack .../28-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package gcc-15. 132s Preparing to unpack .../29-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package gcc-x86-64-linux-gnu. 132s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package gcc. 132s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking gcc (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package libstdc++-15-dev:amd64. 132s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package g++-15-x86-64-linux-gnu. 132s Preparing to unpack .../33-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package g++-15. 132s Preparing to unpack .../34-g++-15_15.2.0-7ubuntu1_amd64.deb ... 132s Unpacking g++-15 (15.2.0-7ubuntu1) ... 132s Selecting previously unselected package g++-x86-64-linux-gnu. 132s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package g++. 132s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 132s Unpacking g++ (4:15.2.0-4ubuntu1) ... 132s Selecting previously unselected package build-essential. 132s Preparing to unpack .../37-build-essential_12.12ubuntu1_amd64.deb ... 132s Unpacking build-essential (12.12ubuntu1) ... 132s Selecting previously unselected package libllvm21:amd64. 132s Preparing to unpack .../38-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 132s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package libclang-cpp21. 133s Preparing to unpack .../39-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 133s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package libgc1:amd64. 133s Preparing to unpack .../40-libgc1_1%3a8.2.10-1_amd64.deb ... 133s Unpacking libgc1:amd64 (1:8.2.10-1) ... 133s Selecting previously unselected package libobjc4:amd64. 133s Preparing to unpack .../41-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 133s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 133s Selecting previously unselected package libobjc-15-dev:amd64. 133s Preparing to unpack .../42-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 133s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 133s Selecting previously unselected package libclang-common-21-dev:amd64. 133s Preparing to unpack .../43-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 133s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package llvm-21-linker-tools. 133s Preparing to unpack .../44-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 133s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package libclang1-21. 133s Preparing to unpack .../45-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 133s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package clang-21. 133s Preparing to unpack .../46-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 133s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 133s Selecting previously unselected package libdebhelper-perl. 133s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 133s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 133s Selecting previously unselected package libtool. 133s Preparing to unpack .../48-libtool_2.5.4-7_all.deb ... 133s Unpacking libtool (2.5.4-7) ... 133s Selecting previously unselected package dh-autoreconf. 133s Preparing to unpack .../49-dh-autoreconf_21_all.deb ... 133s Unpacking dh-autoreconf (21) ... 133s Selecting previously unselected package libarchive-zip-perl. 133s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 133s Unpacking libarchive-zip-perl (1.68-1) ... 133s Selecting previously unselected package libfile-stripnondeterminism-perl. 133s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... 133s Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... 133s Selecting previously unselected package dh-strip-nondeterminism. 133s Preparing to unpack .../52-dh-strip-nondeterminism_1.15.0-1_all.deb ... 133s Unpacking dh-strip-nondeterminism (1.15.0-1) ... 133s Selecting previously unselected package debugedit. 133s Preparing to unpack .../53-debugedit_1%3a5.2-3_amd64.deb ... 133s Unpacking debugedit (1:5.2-3) ... 133s Selecting previously unselected package dwz. 133s Preparing to unpack .../54-dwz_0.16-2_amd64.deb ... 133s Unpacking dwz (0.16-2) ... 133s Selecting previously unselected package gettext. 133s Preparing to unpack .../55-gettext_0.23.1-2build2_amd64.deb ... 133s Unpacking gettext (0.23.1-2build2) ... 133s Selecting previously unselected package intltool-debian. 133s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 133s Unpacking intltool-debian (0.35.0+20060710.6) ... 133s Selecting previously unselected package po-debconf. 133s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 133s Unpacking po-debconf (1.0.21+nmu1) ... 133s Selecting previously unselected package debhelper. 133s Preparing to unpack .../58-debhelper_13.24.2ubuntu1_all.deb ... 133s Unpacking debhelper (13.24.2ubuntu1) ... 133s Selecting previously unselected package emacsen-common. 133s Preparing to unpack .../59-emacsen-common_3.0.8_all.deb ... 133s Unpacking emacsen-common (3.0.8) ... 133s Selecting previously unselected package dictionaries-common. 133s Preparing to unpack .../60-dictionaries-common_1.30.11_all.deb ... 133s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 133s Unpacking dictionaries-common (1.30.11) ... 133s Selecting previously unselected package libfakeroot:amd64. 133s Preparing to unpack .../61-libfakeroot_1.37.1.2-1_amd64.deb ... 133s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 133s Selecting previously unselected package fakeroot. 133s Preparing to unpack .../62-fakeroot_1.37.1.2-1_amd64.deb ... 133s Unpacking fakeroot (1.37.1.2-1) ... 133s Selecting previously unselected package hunspell-en-us. 133s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 133s Unpacking hunspell-en-us (1:2020.12.07-4) ... 133s Selecting previously unselected package libpgtypes3:amd64. 133s Preparing to unpack .../64-libpgtypes3_18.0-1_amd64.deb ... 133s Unpacking libpgtypes3:amd64 (18.0-1) ... 133s Selecting previously unselected package libpq5:amd64. 133s Preparing to unpack .../65-libpq5_18.0-1_amd64.deb ... 133s Unpacking libpq5:amd64 (18.0-1) ... 133s Selecting previously unselected package libecpg6:amd64. 133s Preparing to unpack .../66-libecpg6_18.0-1_amd64.deb ... 133s Unpacking libecpg6:amd64 (18.0-1) ... 133s Selecting previously unselected package libecpg-compat3:amd64. 133s Preparing to unpack .../67-libecpg-compat3_18.0-1_amd64.deb ... 133s Unpacking libecpg-compat3:amd64 (18.0-1) ... 133s Selecting previously unselected package libssl-dev:amd64. 133s Preparing to unpack .../68-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 133s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 134s Selecting previously unselected package libpq-dev. 134s Preparing to unpack .../69-libpq-dev_18.0-1_amd64.deb ... 134s Unpacking libpq-dev (18.0-1) ... 134s Selecting previously unselected package libecpg-dev. 134s Preparing to unpack .../70-libecpg-dev_18.0-1_amd64.deb ... 134s Unpacking libecpg-dev (18.0-1) ... 134s Selecting previously unselected package libncurses-dev:amd64. 134s Preparing to unpack .../71-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 134s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 134s Selecting previously unselected package libpq-oauth:amd64. 134s Preparing to unpack .../72-libpq-oauth_18.0-1_amd64.deb ... 134s Unpacking libpq-oauth:amd64 (18.0-1) ... 134s Selecting previously unselected package libtcl8.6:amd64. 134s Preparing to unpack .../73-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 134s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 134s Selecting previously unselected package liburing2:amd64. 134s Preparing to unpack .../74-liburing2_2.11-1_amd64.deb ... 134s Unpacking liburing2:amd64 (2.11-1) ... 134s Selecting previously unselected package liblzma-dev:amd64. 134s Preparing to unpack .../75-liblzma-dev_5.8.1-2_amd64.deb ... 134s Unpacking liblzma-dev:amd64 (5.8.1-2) ... 134s Selecting previously unselected package zlib1g-dev:amd64. 134s Preparing to unpack .../76-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 134s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 134s Selecting previously unselected package libxml2-dev:amd64. 134s Preparing to unpack .../77-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 134s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 134s Selecting previously unselected package libxslt1.1:amd64. 134s Preparing to unpack .../78-libxslt1.1_1.1.43-0.3_amd64.deb ... 134s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 134s Selecting previously unselected package llvm-21-runtime. 134s Preparing to unpack .../79-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 134s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 134s Selecting previously unselected package libpfm4:amd64. 134s Preparing to unpack .../80-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 134s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 134s Selecting previously unselected package llvm-21. 134s Preparing to unpack .../81-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 134s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 134s Selecting previously unselected package libffi-dev:amd64. 134s Preparing to unpack .../82-libffi-dev_3.5.2-2_amd64.deb ... 134s Unpacking libffi-dev:amd64 (3.5.2-2) ... 134s Selecting previously unselected package llvm-21-tools. 134s Preparing to unpack .../83-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 134s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 134s Selecting previously unselected package llvm-21-dev. 134s Preparing to unpack .../84-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 134s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 135s Selecting previously unselected package locales-all. 135s Preparing to unpack .../85-locales-all_2.42-0ubuntu3_amd64.deb ... 135s Unpacking locales-all (2.42-0ubuntu3) ... 136s Selecting previously unselected package postgresql-client-18. 136s Preparing to unpack .../86-postgresql-client-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-client-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-18. 136s Preparing to unpack .../87-postgresql-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-18-jit. 136s Preparing to unpack .../88-postgresql-18-jit_18.0-1_amd64.deb ... 136s Unpacking postgresql-18-jit (18.0-1) ... 136s Selecting previously unselected package postgresql-doc-18. 136s Preparing to unpack .../89-postgresql-doc-18_18.0-1_all.deb ... 136s Unpacking postgresql-doc-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-plperl-18. 136s Preparing to unpack .../90-postgresql-plperl-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-plperl-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-plpython3-18. 136s Preparing to unpack .../91-postgresql-plpython3-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-plpython3-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-pltcl-18. 136s Preparing to unpack .../92-postgresql-pltcl-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-pltcl-18 (18.0-1) ... 136s Selecting previously unselected package postgresql-server-dev-18. 136s Preparing to unpack .../93-postgresql-server-dev-18_18.0-1_amd64.deb ... 136s Unpacking postgresql-server-dev-18 (18.0-1) ... 136s Setting up postgresql-client-common (282ubuntu1) ... 136s Setting up libpgtypes3:amd64 (18.0-1) ... 136s Setting up postgresql-doc-18 (18.0-1) ... 136s update-alternatives: using /usr/share/postgresql/18/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 136s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 136s Setting up libio-pty-perl (1:1.20-1build3) ... 136s Setting up libarchive-zip-perl (1.68-1) ... 136s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 136s Setting up libpq5:amd64 (18.0-1) ... 136s Setting up m4 (1.4.20-2) ... 136s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 136s Setting up libffi-dev:amd64 (3.5.2-2) ... 136s Setting up locales-all (2.42-0ubuntu3) ... 136s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 136s Setting up fakeroot (1.37.1.2-1) ... 136s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 136s Setting up autotools-dev (20240727.1) ... 136s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 136s Setting up emacsen-common (3.0.8) ... 136s Setting up ssl-cert (1.1.3ubuntu1) ... 137s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 137s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 137s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 137s Setting up libmpc3:amd64 (1.3.1-2) ... 137s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 137s Setting up autopoint (0.23.1-2build2) ... 137s Setting up libipc-run-perl (20250809.0-1) ... 137s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 137s Setting up libgc1:amd64 (1:8.2.10-1) ... 137s Setting up autoconf (2.72-3.1ubuntu1) ... 137s Setting up liblzma-dev:amd64 (5.8.1-2) ... 137s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 137s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 137s Setting up dwz (0.16-2) ... 137s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libjson-perl (4.10000-1) ... 137s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 137s Setting up debugedit (1:5.2-3) ... 137s Setting up libecpg6:amd64 (18.0-1) ... 137s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 137s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 137s Setting up liburing2:amd64 (2.11-1) ... 137s Setting up libisl23:amd64 (0.27-1) ... 137s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 137s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 137s Setting up postgresql-common-dev (282ubuntu1) ... 137s Setting up automake (1:1.18.1-2) ... 137s update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode 137s Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... 137s Setting up gettext (0.23.1-2build2) ... 137s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 137s Setting up libecpg-compat3:amd64 (18.0-1) ... 137s Setting up postgresql-client-18 (18.0-1) ... 137s update-alternatives: using /usr/share/postgresql/18/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 137s Setting up dictionaries-common (1.30.11) ... 137s Setting up libpq-oauth:amd64 (18.0-1) ... 137s Setting up libpq-dev (18.0-1) ... 137s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 137s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 137s Setting up libecpg-dev (18.0-1) ... 137s Setting up intltool-debian (0.35.0+20060710.6) ... 137s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 137s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 137s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 137s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 137s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 137s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 137s Setting up postgresql-common (282ubuntu1) ... 138s Creating config file /etc/postgresql-common/createcluster.conf with new version 138s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 138s en_us 138s Removing obsolete dictionary files: 138s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 138s Setting up dh-strip-nondeterminism (1.15.0-1) ... 138s Setting up cpp-15 (15.2.0-7ubuntu1) ... 138s Setting up hunspell-en-us (1:2020.12.07-4) ... 138s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 138s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 138s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 138s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 138s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 138s Setting up po-debconf (1.0.21+nmu1) ... 138s Setting up postgresql-18 (18.0-1) ... 139s Creating new PostgreSQL cluster 18/main ... 139s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 139s The files belonging to this database system will be owned by user "postgres". 139s This user must also own the server process. 139s 139s The database cluster will be initialized with locale "C.UTF-8". 139s The default database encoding has accordingly been set to "UTF8". 139s The default text search configuration will be set to "english". 139s 139s Data page checksums are enabled. 139s 139s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 139s creating subdirectories ... ok 139s selecting dynamic shared memory implementation ... posix 139s selecting default "max_connections" ... 100 139s selecting default "shared_buffers" ... 128MB 139s selecting default time zone ... Etc/UTC 139s creating configuration files ... ok 139s running bootstrap script ... ok 139s performing post-bootstrap initialization ... ok 139s syncing data to disk ... ok 142s Setting up postgresql-18-jit (18.0-1) ... 142s Setting up gcc-15 (15.2.0-7ubuntu1) ... 142s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 142s Setting up postgresql-plpython3-18 (18.0-1) ... 142s Setting up cpp (4:15.2.0-4ubuntu1) ... 142s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 142s Setting up postgresql-plperl-18 (18.0-1) ... 142s Setting up g++-15 (15.2.0-7ubuntu1) ... 142s Setting up postgresql-pltcl-18 (18.0-1) ... 142s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 142s Setting up libtool (2.5.4-7) ... 142s Setting up postgresql-server-dev-18 (18.0-1) ... 142s Setting up gcc (4:15.2.0-4ubuntu1) ... 142s Setting up dh-autoreconf (21) ... 142s Setting up g++ (4:15.2.0-4ubuntu1) ... 142s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 142s Setting up build-essential (12.12ubuntu1) ... 142s Setting up debhelper (13.24.2ubuntu1) ... 142s Processing triggers for man-db (2.13.1-1) ... 143s Processing triggers for install-info (7.2-5) ... 143s Processing triggers for libc-bin (2.42-0ubuntu3) ... 143s Processing triggers for systemd (258.1-2ubuntu1) ... 143s Processing triggers for dictionaries-common (1.30.11) ... 146s autopkgtest [22:08:50]: test run-testsuite: [----------------------- 147s ====== Running all tests with umask 077 ======= 147s ### PostgreSQL test 001_packages.t ### 147s 1..23 147s ok 1 - /etc/os-release exists 147s ok 2 - OS is ubuntu 147s ok 3 - OS version is 26.04 147s # PostgreSQL versions installed: 18 147s # 18 147s ok 4 - postgresql-18 installed 147s ok 5 - postgresql-plpython3-18 installed 147s ok 6 - postgresql-plperl-18 installed 147s ok 7 - postgresql-pltcl-18 installed 147s ok 8 - postgresql-18-jit installed 147s ok 9 - postgresql-server-dev-18 installed 147s ok 10 # skip No postgresql-contrib-18 package for version 18 147s # postgresql-doc-18 installed 147s ok 11 - At least one doc package installed 147s ok 12 - libecpg-dev installed 147s ok 13 - postgresql-common-dev installed 147s ok 14 - procps installed 147s ok 15 - netcat-openbsd installed 147s ok 16 - hunspell-en-us installed 147s ok 17 - system has a default UTF-8 locale 147s ok 18 - locale ru_RU exists 147s ok 19 - locale ru_RU.UTF-8 exists 147s ok 20 - user postgres in the UNIX group ssl-cert 147s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 147s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 147s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 147s ### End test 001_packages.t ### 147s 147s ### PostgreSQL test 002_existing_clusters.t ### 147s 1..8 147s # Cleanup 147s ok 1 - Cleanup: No clusters left behind 147s ok 2 - No postgres processes left behind 147s ok 3 - No files in /etc/postgresql left behind 147s ok 4 - No files in /var/lib/postgresql left behind 147s ok 5 - No files in /var/run/postgresql left behind 147s ok 6 - No files in /var/log/postgresql left behind 147s ok 7 - PostgreSQL TCP ports are closed 147s ok 8 - Next free port is 5432 147s ### End test 002_existing_clusters.t ### 147s 147s ### PostgreSQL test 003_alternatives.t ### 147s 1..9 147s # Newest PG version installed is 18 147s ok 1 - psql.1.gz link group 147s ok 2 - postmaster.1.gz link group does not exist 147s ok 3 - psql.1.gz alternative 147s ok 4 - pg_dump.1.gz alternative 147s ok 5 - postgres.1.gz alternative 147s ok 6 - pg_ctl.1.gz alternative 147s # Newest PG doc version installed is 18 147s ok 7 - SPI_connect.3.gz link group 147s ok 8 - SPI_connect.3.gz alternative 147s ok 9 - SPI_exec.3.gz alternative 147s ### End test 003_alternatives.t ### 147s 147s ### PostgreSQL test 005_PgCommon.t ### 147s 1..24 147s ok 1 - correctly parsed line 'local all postgres ident sameuser' 147s ok 2 - correctly parsed line 'local foo nobody trust' 147s ok 3 - correctly parsed line 'local foo nobody crypt' 147s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 147s ok 5 - correctly parsed line 'local foo,bar nobody ident' 147s ok 6 - correctly parsed line 'local all +foogrp password' 147s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 147s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 147s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 147s ok 10 - @expected_records has correct number of entries 147s ok 11 - returned read_pg_hba array has correct number of records 147s ok 12 - line 'foo all all md5' parsed as invalid 147s ok 13 - line 'local all all foo' parsed as invalid 147s ok 14 - line 'host all all foo' parsed as invalid 147s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 147s ok 16 - line 'host all all md5' parsed as invalid 147s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 147s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 147s ok 19 - read_conf_file returns empty dict for nonexisting file 147s ok 20 - read_conf_file() parsing 147s ok 21 - read_conf_file() parsing with include directives 147s ok 22 - set_conf_value 147s ok 23 - disable_conf_value 147s ok 24 - replace_conf_value 147s ### End test 005_PgCommon.t ### 147s 147s ### PostgreSQL test 006_next_free_port.t ### 147s 1..5 147s ok 1 - next_free_port is 5432 148s ok 2 - next_free_port detects localhost ipv4 socket 149s ok 3 - next_free_port detects wildcard ipv4 socket 150s ok 4 - next_free_port detects localhost ipv6 socket 151s ok 5 - next_free_port detects wildcard ipv6 socket 151s ### End test 006_next_free_port.t ### 151s 151s ### PostgreSQL test 007_pg_conftool.t ### 151s 1..41 151s # test without cluster 151s ok 1 - pg_conftool show all 151s ok 2 - correct output of pg_conftool show all 151s ok 3 - pg_conftool foo.conf show all 151s ok 4 - correct output of pg_conftool foo.conf show all 151s ok 5 - pg_conftool /tmp/6pYFmo5BK0/different.conf show all 151s ok 6 - correct output of pg_conftool /tmp/6pYFmo5BK0/different.conf show all 151s ok 7 - pg_conftool 9.7 main show all 151s ok 8 - correct output of pg_conftool 9.7 main show all 151s # test show 151s ok 9 - pg_conftool show all 151s ok 10 - correct output of pg_conftool show all 151s ok 11 - pg_conftool other.conf show all 151s ok 12 - correct output of pg_conftool other.conf show all 151s ok 13 - pg_conftool /tmp/6pYFmo5BK0/different.conf show all 151s ok 14 - correct output of pg_conftool /tmp/6pYFmo5BK0/different.conf show all 151s ok 15 - pg_conftool 18 main show all 151s ok 16 - correct output of pg_conftool 18 main show all 151s ok 17 - pg_conftool 18 main other.conf show all 151s ok 18 - correct output of pg_conftool 18 main other.conf show all 151s ok 19 - pg_conftool show a 151s ok 20 - correct output of pg_conftool show a 152s ok 21 - pg_conftool -s show a 152s ok 22 - correct output of pg_conftool -s show a 152s # test set 152s ok 23 - pg_conftool set c 7 152s ok 24 - correct output of pg_conftool set c 7 152s ok 25 - file contains new setting 152s ok 26 - pg_conftool set a 8 152s ok 27 - correct output of pg_conftool set a 8 152s ok 28 - file contains updated setting 152s ok 29 - pg_conftool /tmp/6pYFmo5BK0/different.conf set a 9 152s ok 30 - correct output of pg_conftool /tmp/6pYFmo5BK0/different.conf set a 9 152s ok 31 - file with path contains updated setting 152s # test remove 152s ok 32 - pg_conftool remove a 152s ok 33 - correct output of pg_conftool remove a 152s ok 34 - setting removed from file 152s ok 35 - pg_conftool /tmp/6pYFmo5BK0/different.conf remove a 152s ok 36 - correct output of pg_conftool /tmp/6pYFmo5BK0/different.conf remove a 152s ok 37 - setting removed from file with path 152s # test edit 152s ok 38 - pg_conftool edit 152s ok 39 - correct output of pg_conftool edit 152s ok 40 - pg_conftool /tmp/6pYFmo5BK0/different.conf edit 152s ok 41 - correct output of pg_conftool /tmp/6pYFmo5BK0/different.conf edit 152s ### End test 007_pg_conftool.t ### 152s 152s ### PostgreSQL test 010_defaultport_cluster.t ### 152s 1..14 152s ok 1 - psql --version 152s ok 2 - pg_wrapper selects highest available version number 152s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 152s ok 4 - connecting to localhost fails with no clusters 152s ok 5 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -l 152s ok 6 - pg_wrapper uses host and port from PGCLUSTER 152s ok 7 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --cluster 18/127.0.0.3:5430 -l 152s ok 8 - pg_wrapper uses --cluster from the command line 152s ok 9 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -h 127.0.0.3 -l 152s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 152s ok 11 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --host 127.0.0.3 -l 152s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 152s ok 13 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 152s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 152s ### End test 010_defaultport_cluster.t ### 152s 152s ### PostgreSQL test 015_start_stop.t ### 152s 1..71 152s # We are running systemd 152s # Running tests for 18 152s # Cluster does not exist yet 152s ok 1 - cluster 18 main does not exist 152s ok 2 - service postgresql@18-main does not exist 152s ok 3 - systemctl start postgresql 152s ok 4 - cluster 18 main does not exist 152s ok 5 - service postgresql@18-main does not exist 152s ok 6 - systemctl start postgresql@18-main 152s ok 7 - cluster 18 main does not exist 152s ok 8 - service postgresql@18-main does not exist 152s # Start/stop postgresql using system tools 153s ok 9 - pg_createcluster 18 main 153s ok 10 - cluster 18 main is stopped 153s ok 11 - service postgresql@18-main is stopped 155s ok 12 - systemctl start postgresql 155s ok 13 - cluster 18 main is running 155s ok 14 - service postgresql@18-main is running 155s ok 15 - systemctl start postgresql 155s ok 16 - cluster 18 main is already running 155s ok 17 - service postgresql@18-main is already running 155s ok 18 - systemctl stop postgresql 161s ok 19 - cluster 18 main is stopped 161s ok 20 - service postgresql@18-main is stopped 161s ok 21 - systemctl stop postgresql 161s ok 22 - cluster 18 main is already stopped 161s ok 23 - service postgresql@18-main is already stopped 161s # Start/stop specific cluster using system tools 163s ok 24 - systemctl start postgresql@18-main 163s ok 25 - cluster 18 main is running 163s ok 26 - service postgresql@18-main is running 163s ok 27 - systemctl start postgresql@18-main 163s ok 28 - cluster 18 main is running 163s ok 29 - service postgresql@18-main is running 166s ok 30 - systemctl restart postgresql@18-main 166s ok 31 - cluster 18 main is running 166s ok 32 - service postgresql@18-main is running 166s ok 33 - systemctl stop postgresql@18-main 166s ok 34 - cluster 18 main is stopped 166s ok 35 - service postgresql@18-main is stopped 166s ok 36 - systemctl stop postgresql@18-main 166s ok 37 - cluster 18 main is already stopped 166s ok 38 - service postgresql@18-main is already stopped 167s ok 39 - pg_dropcluster 18 main 167s ok 40 - cluster 18 main does not exist 167s ok 41 - service postgresql@18-main does not exist 167s # Start/stop specific cluster using pg_*cluster 167s ok 42 - pg_ctlcluster start 18 main 167s ok 43 - cluster 18 main does not exist 167s ok 44 - service postgresql@18-main does not exist 170s ok 45 - pg_createcluster 18 main --start 170s ok 46 - cluster 18 main is running 170s ok 47 - service postgresql@18-main is running 170s ok 48 - pg_ctlcluster 18 main start 170s ok 49 - cluster 18 main is already running 170s ok 50 - service postgresql@18-main is already running 172s ok 51 - pg_ctlcluster 18-main restart 172s ok 52 - cluster 18 main is running 172s ok 53 - service postgresql@18-main is running 172s ok 54 - pg_ctlcluster 18 main stop 172s ok 55 - cluster 18 main is stopped 172s ok 56 - service postgresql@18-main is stopped 172s ok 57 - pg_ctlcluster 18 main stop 172s ok 58 - cluster 18 main is already stopped 172s ok 59 - service postgresql@18-main is already stopped 175s ok 60 - pg_ctlcluster start 18-main 175s ok 61 - cluster 18 main is running 175s ok 62 - service postgresql@18-main is running 176s ok 63 - pg_dropcluster 18 main --stop 176s # Cleanup 176s ok 64 - Cleanup: No clusters left behind 176s ok 65 - No postgres processes left behind 176s ok 66 - No files in /etc/postgresql left behind 176s ok 67 - No files in /var/lib/postgresql left behind 176s ok 68 - No files in /var/run/postgresql left behind 176s ok 69 - No files in /var/log/postgresql left behind 176s ok 70 - PostgreSQL TCP ports are closed 176s ok 71 - Next free port is 5432 176s ### End test 015_start_stop.t ### 176s 176s ### PostgreSQL test 020_create_sql_remove.t ### 176s 1..141 176s # Running tests for 18 179s ok 1 - pg_createcluster 18 main --start -- -X /tmp/18.xlog.Sp7ULT 179s ok 2 - pg_createcluster 18 main 179s ok 3 - Socket and pid file are in /var/run/postgresql/ 179s ok 4 - xlog/wal directory /tmp/18.xlog.Sp7ULT was created 179s ok 5 - local method in pg_hba.conf is peer 179s ok 6 - host method in pg_hba.conf is scram-sha-256 179s ok 7 - Exactly one postgres master process running 181s ok 8 - pg_ctlcluster 18 main restart 181s ok 9 - cluster restarts with new environment file 181s ok 10 - Exactly one postgres master process running 181s ok 11 - correct value of PGEXTRAVAR1 in environment 181s ok 12 - correct value of PGEXTRAVAR2 in environment 181s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 181s ok 14 - createdb --version 181s ok 15 - pg_wrapper+createdb selects version number of cluster 181s ok 16 - psql --version 181s ok 17 - pg_wrapper+psql selects version 18 181s ok 18 - pg_lscluster reports online cluster on port 5432 181s ok 19 - log file is actually used 181s ok 20 - /etc/postgresql is owned by user "postgres" 181s ok 21 - version configuration directory file is owned by user "postgres" 181s ok 22 - configuration directory file is owned by user "postgres" 181s ok 23 - version data directory file is owned by user "postgres" 181s ok 24 - data directory file is owned by user "postgres" 181s ok 25 - log file has 0640 permissions 181s ok 26 - log file is owned by user "postgres" 181s ok 27 - log file is owned by group "adm" 181s ok 28 - no log symlink by default 181s ok 29 - /var/log/postgresql/postgresql-18-main.log is the default log if log symlink is missing 181s ok 30 - pg_lsclusters -h 181s ok 31 - correct output of pg_lsclusters -h 181s ok 32 - stopping cluster 184s ok 33 - restarting cluster with nondefault log symlink 184s ok 34 - log target is used as log file 184s ok 35 - default log is not used 184s ok 36 - pg_lsclusters -h 184s ok 37 - correct output of pg_lsclusters -h 184s ok 38 - stopping cluster 187s ok 39 - restarting cluster with explicitly configured log file 187s ok 40 - default log is not used 187s ok 41 - log symlink target is used for startup message 187s ok 42 - exactly one log file 187s ok 43 - custom log is actually used 187s ok 44 - pg_lsclusters -h 187s ok 45 - correct output of pg_lsclusters -h 187s ok 46 - stopping cluster 187s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 187s ok 48 - /etc/postgres-hack was not created 189s ok 49 - restarting cluster 189s ok 50 - ps -o tty -U postgres h 189s ok 51 - postgres processes do not have an associated terminal 189s ok 52 - Server is linked with SSL support 189s ok 53 - SSL is enabled in postgresql.conf 189s ok 54 - psql -l fails for nobody 189s ok 55 - createuser nobody 189s ok 56 - createdb nobodydb 189s ok 57 - psql -ltA succeeds for nobody 189s ok 58 - psql -ltA output 189s ok 59 - SQL command: create table 189s ok 60 - SQL command: insert into table values 189s ok 61 - SQL command: insert into table values 189s ok 62 - primary key violation 189s ok 63 - psql -tAc "select * from phone order by name" nobodydb 189s ok 64 - SQL command output: select -tA 189s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 189s ok 66 - SQL command output: select -tx 189s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 189s ok 68 - SQL command output: select -tAx 189s ok 69 - CREATE EXTENSION plperlu fails for user nobody 189s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 189s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 189s ok 72 - creating PL/PerlU function as user nobody fails 189s ok 73 - creating unsafe PL/Perl function as user postgres fails 189s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 189s ok 75 - creating PL/PerlU function as user postgres succeeds 189s ok 76 - psql nobodydb -Atc "select read_file()" 189s ok 77 - calling PL/PerlU function 189s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 189s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 189s ok 80 - creating unsafe PL/Perl function as user nobody fails 189s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 189s ok 82 - creating PL/Perl function as user nobody succeeds 190s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 190s ok 84 - calling PL/Perl function 190s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 190s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 190s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 190s ok 88 - creating PL/Python3 function as user postgres succeeds 190s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 190s ok 90 - calling PL/Python function 190s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 190s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 190s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 190s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 190s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 190s ok 96 - creating PL/Tcl function as user nobody succeeds 190s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 190s ok 98 - creating PL/TclU function as user postgres succeeds 190s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 190s ok 100 - calling PL/Tcl function 190s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 190s ok 102 - calling PL/TclU function 190s ok 103 - stopping cluster 190s ok 104 - pg_ctlcluster 18 main start 190s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 192s ok 106 - pg_ctlcluster 18 main start 192s ok 107 - cluster restarts with pgdata symlink 193s ok 108 - postgres master has OOM killer protection 193s ok 109 - postgres client backend has no OOM adjustment 193s ok 110 - ps h 7174 193s ok 111 - process title is idle 193s ok 112 - ps h 7174 193s ok 113 - process title is idle in transaction 193s ok 114 - stopping cluster 195s ok 115 - starting cluster as postgres works without a log file 195s ok 116 - log file got recreated and used 195s ok 117 - creating a directory in spc2 195s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/18.spc1.VV34WO'" 195s ok 119 - creating tablespace spc1 195s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 196s ok 121 - creating a table in spc1 196s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/18.spc2.wFeiXh'" 196s ok 123 - creating tablespace spc2 196s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 196s ok 125 - creating a table in spc2 196s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 196s ok 127 - Correct apt NeverAutoRemove config 197s ok 128 - pg_dropcluster removes cluster 197s ok 129 - xlog/wal directory /tmp/18.xlog.Sp7ULT was deleted 197s ok 130 - tablespace spc1 was emptied 197s ok 131 - tablespace spc2 was emptied 197s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 197s ok 133 - Correct apt NeverAutoRemove config 197s # Cleanup 197s ok 134 - Cleanup: No clusters left behind 197s ok 135 - No postgres processes left behind 197s ok 136 - No files in /etc/postgresql left behind 197s ok 137 - No files in /var/lib/postgresql left behind 197s ok 138 - No files in /var/run/postgresql left behind 197s ok 139 - No files in /var/log/postgresql left behind 197s ok 140 - PostgreSQL TCP ports are closed 197s ok 141 - Next free port is 5432 197s ### End test 020_create_sql_remove.t ### 197s 197s ### PostgreSQL test 021_pg_renamecluster.t ### 197s 1..20 199s ok 1 - pg_createcluster 18 main 202s ok 2 - pg_renamecluster 18 main donau 202s ok 3 - psql -tAc "show data_directory" 202s ok 4 - cluster is running and data_directory was moved 202s ok 5 - pg_hba.conf location updated 202s ok 6 - pg_ident.conf location updated 202s ok 7 - external_pid_file location updated 202s ok 8 - external_pid_file exists 202s ok 9 # skip no stats_temp_directory in 18 202s ok 10 # skip no stats_temp_directory in 18 202s ok 11 - cluster_name is updated 203s ok 12 - pg_dropcluster removes cluster 203s # Cleanup 203s ok 13 - Cleanup: No clusters left behind 203s ok 14 - No postgres processes left behind 203s ok 15 - No files in /etc/postgresql left behind 203s ok 16 - No files in /var/lib/postgresql left behind 203s ok 17 - No files in /var/run/postgresql left behind 203s ok 18 - No files in /var/log/postgresql left behind 203s ok 19 - PostgreSQL TCP ports are closed 203s ok 20 - Next free port is 5432 203s ### End test 021_pg_renamecluster.t ### 203s 203s ### PostgreSQL test 022_recovery.t ### 203s 1..17 203s # Running tests for 18 206s ok 1 - pg_createcluster 18 main --start >/dev/null 206s ok 2 - pg_ctlcluster 18 main stop -m i 208s ok 3 - pg_ctlcluster 18 main start 208s ok 4 - psql -c '' 209s ok 5 - pg_ctlcluster 18 main stop -m i 209s ok 6 - create write-protected file in data directory 212s ok 7 - pg_ctlcluster 18 main start 212s ok 8 - psql -c '' 212s ok 9 - pg_dropcluster removes cluster 212s # Cleanup 212s ok 10 - Cleanup: No clusters left behind 212s ok 11 - No postgres processes left behind 212s ok 12 - No files in /etc/postgresql left behind 212s ok 13 - No files in /var/lib/postgresql left behind 212s ok 14 - No files in /var/run/postgresql left behind 212s ok 15 - No files in /var/log/postgresql left behind 212s ok 16 - PostgreSQL TCP ports are closed 212s ok 17 - Next free port is 5432 212s ### End test 022_recovery.t ### 212s 212s ### PostgreSQL test 025_logging.t ### 212s 1..55 212s # Logging to /var/log/syslog works 212s # Running tests for 18 215s ok 1 - pg_createcluster 18 main 215s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-18-main.log 215s ok 3 - psql -qc "'foobar_18_8548'" 215s ok 4 - log an error 216s ok 5 - grep --binary-files=text foobar_18_8548 /var/log/postgresql/postgresql-18-main.log 216s ok 6 - error appears in logfile 216s ok 7 - pg_conftool 18 main set log_destination syslog 216s ok 8 - set log_destination syslog 216s ok 9 - pg_ctlcluster 18 main reload 216s ok 10 - 18 main reload 216s ok 11 - psql -Atc "show log_destination" 216s ok 12 - log_destination is syslog 216s ok 13 - pg_lscluster reports syslog 216s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 216s ok 15 - error appears in /var/log/syslog 216s ok 16 - pg_conftool 18 main set logging_collector on 216s ok 17 - set logging_collector on 216s ok 18 - pg_conftool 18 main set log_destination csvlog 216s ok 19 - set log_destination csvlog 219s ok 20 - pg_ctlcluster 18 main restart 220s ok 21 - 18 main restart 220s ok 22 - psql -Atc "show logging_collector" 220s ok 23 - logging_collector is on 220s ok 24 - psql -Atc "show log_destination" 220s ok 25 - log_destination is csvlog 220s ok 26 - pg_lscluster reports csvlog 220s ok 27 - psql -qc "'barbaz_18_8548'" 220s ok 28 - log an error 220s ok 29 - grep --binary-files=text barbaz_18_8548 /var/lib/postgresql/18/main/log/*.csv 220s ok 30 - error appears in log/*.csv 220s ok 31 - pg_conftool 18 main set log_destination stderr,syslog,csvlog 220s ok 32 - set log_destination stderr,syslog,csvlog 220s ok 33 - pg_ctlcluster 18 main reload 220s ok 34 - 18 main reload 220s ok 35 - psql -Atc "show log_destination" 220s ok 36 - log_destination is stderr,syslog,csvlog 220s ok 37 - pg_lscluster reports stderr,syslog,csvlog 220s ok 38 - psql -qc "'moo_18_8548'" 220s ok 39 - log an error 220s ok 40 - grep --binary-files=text moo_18_8548 /var/lib/postgresql/18/main/log/*.log 220s ok 41 - error appears in log/*.log 221s ok 42 - grep --binary-files=text 'postgres.*moo_18_8548' /var/log/syslog 221s ok 43 - error appears in /var/log/syslog 221s ok 44 - grep --binary-files=text moo_18_8548 /var/lib/postgresql/18/main/log/*.csv 221s ok 45 - error appears in log/*.csv 222s ok 46 - pg_dropcluster 18 main --stop 222s ok 47 - pg_dropcluster removes cluster 222s # Cleanup 222s ok 48 - Cleanup: No clusters left behind 222s ok 49 - No postgres processes left behind 222s ok 50 - No files in /etc/postgresql left behind 222s ok 51 - No files in /var/lib/postgresql left behind 222s ok 52 - No files in /var/run/postgresql left behind 222s ok 53 - No files in /var/log/postgresql left behind 222s ok 54 - PostgreSQL TCP ports are closed 222s ok 55 - Next free port is 5432 222s ### End test 025_logging.t ### 222s 222s ### PostgreSQL test 027_jit.t ### 222s # 18 224s ok 1 - pg_createcluster 18 main --start 225s ok 2 - psql -Xatc 'show jit' 225s ok 3 - JIT is on by default 225s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 225s ok 5 - No JIT on cheap query 225s ok 6 - pg_conftool 18 main set seq_page_cost 100000 225s ok 7 - pg_conftool 18 main set random_page_cost 100000 225s ok 8 - pg_ctlcluster 18 main reload 225s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 225s ok 10 - Expensive query is JITed 226s ok 11 - pg_dropcluster --stop 18 main 226s # Cleanup 226s ok 12 - Cleanup: No clusters left behind 226s ok 13 - No postgres processes left behind 226s ok 14 - No files in /etc/postgresql left behind 226s ok 15 - No files in /var/lib/postgresql left behind 226s ok 16 - No files in /var/run/postgresql left behind 226s ok 17 - No files in /var/log/postgresql left behind 226s ok 18 - PostgreSQL TCP ports are closed 226s ok 19 - Next free port is 5432 226s 1..19 226s ### End test 027_jit.t ### 226s 226s ### PostgreSQL test 030_errors.t ### 226s 1..156 226s ok 1 - pg_lscluster reports cluster without binaries 227s ok 2 - pg_dropcluster 6.3 main 227s ok 3 - pg_createcluster --socketdir 227s ok 4 - pg_lsclusters -h 227s ok 5 - cluster was created 227s ok 6 - Port of created cluster is 5432 227s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 18 main 227s ok 8 - pg_createcluster on existing cluster 227s ok 9 - pg_lsclusters -h 227s ok 10 - original cluster still exists 227s ok 11 - pg_createcluster 18 test -p foo 227s ok 12 - pg_createcluster -p checks that port option is numeric 227s ok 13 - pg_createcluster 18 test -p 42 227s ok 14 - pg_createcluster -p checks valid port range 227s ok 15 - pg_ctlcluster 18 main start 227s ok 16 - pg_ctlcluster refuses to start root-owned cluster 227s ok 17 - pg_ctlcluster 18 main start 227s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 227s ok 19 - pg_ctlcluster 18 main start 227s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 227s ok 21 - pg_ctlcluster 18 main start 227s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 230s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 230s ok 24 - No sockets in /var/run/postgresql 230s ok 25 - Socket is in /tmp/postgresql-testsuite/ 230s ok 26 - cluster stops with custom unix_socket_dir 230s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 232s ok 28 - cluster starts after removing unix_socket_dir 232s ok 29 - Socket is in default dir /var/run/postgresql 232s ok 30 - No sockets in /tmp/postgresql-testsuite/ 232s ok 31 - pg_ctlcluster 18 main stop 232s ok 32 - pg_ctlcluster fails with corrupted PID file 232s ok 33 - pg_lsclusters -h 232s ok 34 - cluster is still online 232s ok 35 - pg_ctlcluster succeeds with restored PID file 232s ok 36 - pg_lsclusters -h 232s ok 37 - cluster is down 232s ok 38 - pg_ctlcluster 18 main stop 232s ok 39 - pg_ctlcluster stop fails on stopped cluster 234s ok 40 - pg_ctlcluster 18 main start 234s ok 41 - pg_ctlcluster succeeds with already existing PID file 234s ok 42 - pg_lsclusters -h 234s ok 43 - cluster is online 235s ok 44 - pg_ctlcluster stop succeeds 235s ok 45 - pg_lsclusters -h 235s ok 46 - cluster is down 235s ok 47 - no pid file left 235s ok 48 - pg_ctlcluster 18 main stop 235s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 235s ok 50 - pid file was cleaned up 235s ok 51 - pg_ctlcluster --force 18 main stop 235s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 235s ok 53 - pid file was cleaned up 235s ok 54 - pg_ctlcluster 18 main stop 235s ok 55 - pg_ctlcluster stop succeeds with stale PID file 235s ok 56 - pid file was cleaned up 235s ok 57 - pg_ctlcluster --force 18 main stop 235s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 235s ok 59 - pid file was cleaned up 235s ok 60 - pg_ctlcluster --force 18 main stop 235s ok 61 - pg_ctlcluster stop succeeds with empty PID file 235s ok 62 - pid file was cleaned up 237s ok 63 - pg_ctlcluster 18 main start 237s ok 64 - pg_ctlcluster succeeds with corrupted PID file 237s ok 65 - pg_lsclusters -h 237s ok 66 - cluster is online 237s ok 67 - pg_ctlcluster 18 main start 237s ok 68 - pg_ctlcluster start fails on running cluster 237s ok 69 - pg_ctlcluster stop 237s ok 70 - pg_ctlcluster 18 main start 237s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 237s ok 72 - pg_ctlcluster 18 main stop 237s ok 73 - stopping cluster 243s ok 74 - pg_ctlcluster 18 main start 243s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 244s ok 76 - pg_ctlcluster 18 main stop 244s ok 77 - stopping cluster 244s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 244s ok 79 - pg_dropcluster 18 main 244s ok 80 - pg_dropcluster works as user postgres 244s ok 81 - pg_createcluster succeeds 244s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 244s ok 83 - proper error message for nonexisting /var/lib/postgresql 246s ok 84 - pg_ctlcluster 18 main start 246s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 246s ok 86 - pg_ctlcluster 18 main stop 246s ok 87 - stopping cluster 247s ok 88 - pg_createcluster other 249s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 251s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 251s ok 91 252s ok 92 - pg_ctlcluster 18 other start 252s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 252s ok 94 - pg_ctlcluster 18 main stop 252s ok 95 - stopping main cluster 254s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 255s ok 97 - pg_dropcluster other 256s ok 98 - pg_dropcluster 256s ok 99 - No sockets any more 256s ok 100 - 'pg_lsclusters 4.5 foo' fails 256s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 256s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 256s ok 103 - 'psql --cluster 4.5/foo' fails 256s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 256s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 256s ok 106 - 'psql --cluster 18/foo' fails 256s ok 107 - psql --cluster 18/foo gives error message about nonexisting cluster 256s ok 108 - psql --cluster 18/foo does not print 'invalid symbolic link' gibberish 256s ok 109 - 'pg_dropcluster 4.5 foo' fails 256s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 256s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 256s ok 112 - 'pg_dropcluster 18 foo' fails 256s ok 113 - pg_dropcluster 18 foo gives error message about nonexisting cluster 256s ok 114 - pg_dropcluster 18 foo does not print 'invalid symbolic link' gibberish 256s ok 115 - 'pg_upgradecluster 4.5 foo' fails 256s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 256s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 256s ok 118 - 'pg_upgradecluster 18 foo' fails 256s ok 119 - pg_upgradecluster 18 foo gives error message about nonexisting cluster 256s ok 120 - pg_upgradecluster 18 foo does not print 'invalid symbolic link' gibberish 256s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 256s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 256s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 256s ok 124 - 'pg_ctlcluster 18 foo stop' fails 256s ok 125 - pg_ctlcluster 18 foo stop gives error message about nonexisting cluster 256s ok 126 - pg_ctlcluster 18 foo stop does not print 'invalid symbolic link' gibberish 256s # Cleanup 256s ok 127 - Cleanup: No clusters left behind 256s ok 128 - No postgres processes left behind 256s ok 129 - No files in /etc/postgresql left behind 256s ok 130 - No files in /var/lib/postgresql left behind 256s ok 131 - No files in /var/run/postgresql left behind 256s ok 132 - No files in /var/log/postgresql left behind 256s ok 133 - PostgreSQL TCP ports are closed 256s ok 134 - Next free port is 5432 257s ok 135 - pg_dropcluster 18 broken 257s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 257s # Cleanup 257s ok 137 - Cleanup: No clusters left behind 257s ok 138 - No postgres processes left behind 257s ok 139 - No files in /etc/postgresql left behind 257s ok 140 - No files in /var/lib/postgresql left behind 257s ok 141 - No files in /var/run/postgresql left behind 257s ok 142 - No files in /var/log/postgresql left behind 257s ok 143 - PostgreSQL TCP ports are closed 257s ok 144 - Next free port is 5432 258s ok 145 - pg_dropcluster 18 broken 258s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 258s ok 147 - /etc/postgresql/18 was removed 258s ok 148 - /var/lib/postgresql/18 was removed 258s # Cleanup 258s ok 149 - Cleanup: No clusters left behind 258s ok 150 - No postgres processes left behind 258s ok 151 - No files in /etc/postgresql left behind 258s ok 152 - No files in /var/lib/postgresql left behind 258s ok 153 - No files in /var/run/postgresql left behind 258s ok 154 - No files in /var/log/postgresql left behind 258s ok 155 - PostgreSQL TCP ports are closed 258s ok 156 - Next free port is 5432 258s ### End test 030_errors.t ### 258s 258s ### PostgreSQL test 031_errors_disk_full.t ### 258s 1..22 258s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 259s ok 1 - script failed 259s ok 2 - pg_createcluster fails due to insufficient disk space 259s ok 3 - does not leave files behind 259s # Cleanup 259s ok 4 - Cleanup: No clusters left behind 259s ok 5 - No postgres processes left behind 259s ok 6 - No files in /etc/postgresql left behind 259s ok 7 - No files in /var/lib/postgresql left behind 259s ok 8 - No files in /var/run/postgresql left behind 259s ok 9 - No files in /var/log/postgresql left behind 259s ok 10 - PostgreSQL TCP ports are closed 259s ok 11 - Next free port is 5432 259s # check disk full conditions on startup 261s ok 12 - script failed 261s ok 13 - pg_ctlcluster prints error message 261s ok 14 - log file has error message 261s # Cleanup 261s ok 15 - Cleanup: No clusters left behind 261s ok 16 - No postgres processes left behind 261s ok 17 - No files in /etc/postgresql left behind 261s ok 18 - No files in /var/lib/postgresql left behind 261s ok 19 - No files in /var/run/postgresql left behind 261s ok 20 - No files in /var/log/postgresql left behind 261s ok 21 - PostgreSQL TCP ports are closed 261s ok 22 - Next free port is 5432 261s ### End test 031_errors_disk_full.t ### 261s 261s ### PostgreSQL test 032_ssl_key_permissions.t ### 261s 1..22 261s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 261s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 261s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 261s ok 4 - pg_createcluster 18 main 261s ok 5 - pg_ctlcluster 18 main start 261s ok 6 - ssl key owned by nobody refused 261s ok 7 - pg_ctlcluster 18 main start 261s ok 8 - ssl key with permissions root:root 0644 refused 262s ok 9 - pg_ctlcluster 18 main start 262s ok 10 - ssl key with permissions postgres:postgres 0640 refused 262s ok 11 - pg_dropcluster 18 main --stop 262s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 262s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 262s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 262s # Cleanup 263s ok 15 - Cleanup: No clusters left behind 263s ok 16 - No postgres processes left behind 263s ok 17 - No files in /etc/postgresql left behind 263s ok 18 - No files in /var/lib/postgresql left behind 263s ok 19 - No files in /var/run/postgresql left behind 263s ok 20 - No files in /var/log/postgresql left behind 263s ok 21 - PostgreSQL TCP ports are closed 263s ok 22 - Next free port is 5432 263s ### End test 032_ssl_key_permissions.t ### 263s 263s ### PostgreSQL test 040_upgrade.t ### 263s 1..1 263s ok 1 - only one major version installed, skipping upgrade tests 263s ### End test 040_upgrade.t ### 263s 263s ### PostgreSQL test 041_upgrade_custompaths.t ### 263s 1..1 263s ok 1 - only one major version installed, skipping upgrade tests 263s ### End test 041_upgrade_custompaths.t ### 263s 263s ### PostgreSQL test 042_upgrade_rename.t ### 263s 1..15 263s # PostgreSQL 18 265s ok 1 - pg_createcluster 18 main --start 270s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/18/bin -v 18 --rename upgr 18 main 270s ok 3 - pg_lsclusters -h 270s ok 4 - correct output of pg_lsclusters -h 271s ok 5 - pg_dropcluster 18 main --stop 272s ok 6 - pg_dropcluster 18 upgr --stop 272s ok 7 - Cleaning pg_upgrade log files 272s # Cleanup 272s ok 8 - Cleanup: No clusters left behind 272s ok 9 - No postgres processes left behind 272s ok 10 - No files in /etc/postgresql left behind 272s ok 11 - No files in /var/lib/postgresql left behind 272s ok 12 - No files in /var/run/postgresql left behind 272s ok 13 - No files in /var/log/postgresql left behind 272s ok 14 - PostgreSQL TCP ports are closed 272s ok 15 - Next free port is 5432 272s ### End test 042_upgrade_rename.t ### 272s 272s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 272s 1..1 272s ok 1 - only one major version installed, skipping upgrade tests 272s ### End test 043_upgrade_ssl_cert.t ### 272s 272s ### PostgreSQL test 045_backup.t ### 272s # We are running systemd 272s # PostgreSQL 18 272s # create cluster 275s ok 1 - pg_createcluster --locale en_US.UTF-8 18 main --start 275s ok 2 - pg_lsclusters -h 275s ok 3 - correct output of pg_lsclusters -h 275s ok 4 - pg_conftool 18 main set work_mem 11MB 275s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 275s ok 6 - psql -c 'alter database mydb set search_path=public' 275s ok 7 - psql -c 'create table foo (t text)' mydb 275s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 275s ok 9 - psql -c 'CREATE USER myuser' 275s ok 10 - psql -c 'grant create on database mydb to myuser' 275s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 275s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 275s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 275s # create directory 275s ok 14 - pg_backupcluster 18 main createdirectory 275s ok 15 - /var/backups/postgresql/18-main owned by uid postgres 275s ok 16 - /var/backups/postgresql/18-main owned by gid postgres 275s # dump 276s ok 17 - systemctl start pg_dump@18-main 276s ok 18 - dump created in /var/backups/postgresql/18-main/2025-11-05T221059Z.dump 276s ok 19 - /var/backups/postgresql/18-main/2025-11-05T221059Z.dump owned by uid postgres 276s ok 20 - /var/backups/postgresql/18-main/2025-11-05T221059Z.dump owned by gid postgres 276s # basebackup 276s ok 21 - systemctl start pg_receivewal@18-main 276s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 276s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [000000010000000000000002.gz.partial] 276s not ok 23 - /var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 276s # Failed test '/var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial' 276s # at t/TestLib.pm line 171. 276s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 276s ok 25 - psql -c 'select pg_reload_conf()' 304s ok 26 - systemctl start pg_basebackup@18-main 304s ok 27 - dump created in /var/backups/postgresql/18-main/2025-11-05T221100Z.backup 304s ok 28 - /var/backups/postgresql/18-main/2025-11-05T221100Z.backup owned by uid postgres 304s ok 29 - /var/backups/postgresql/18-main/2025-11-05T221100Z.backup owned by gid postgres 304s # list 304s ok 30 - pg_backupcluster 18 main list 304s ok 31 - correct output of pg_backupcluster 18 main list 304s # more database changes 304s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 304s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 304s ok 34 - retrieve recovery timestamp 304s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 304s ok 36 - systemctl stop pg_receivewal@18-main 304s # restore /var/backups/postgresql/18-main/2025-11-05T221059Z.dump 305s ok 37 - pg_dropcluster 18 main --stop 309s ok 38 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-05T221059Z.dump --start --datadir /var/lib/postgresql/18/snowflake 309s ok 39 - pg_lsclusters -h 309s ok 40 - correct output of pg_lsclusters -h 309s ok 41 - psql -XAtl 309s ok 42 - mydb locales 309s ok 43 - mydb grants 309s ok 44 - myicudb locales 309s ok 45 - psql -XAtc 'show work_mem' 309s ok 46 - correct output of psql -XAtc 'show work_mem' 309s ok 47 - psql -XAtc 'select * from foo' mydb 309s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 309s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 309s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 309s ok 51 - psql -XAtc '\drds' 309s ok 52 - correct output of psql -XAtc '\drds' 309s # restore /var/backups/postgresql/18-main/2025-11-05T221100Z.backup 310s ok 53 - pg_dropcluster 18 main --stop 313s ok 54 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-05T221100Z.backup --start --datadir /var/lib/postgresql/18/snowflake 313s ok 55 - pg_lsclusters -h 313s ok 56 - correct output of pg_lsclusters -h 313s ok 57 - psql -XAtl 313s ok 58 - mydb locales 313s ok 59 - mydb grants 313s ok 60 - myicudb locales 313s ok 61 - psql -XAtc 'show work_mem' 313s ok 62 - correct output of psql -XAtc 'show work_mem' 313s ok 63 - psql -XAtc 'select * from foo' mydb 313s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 313s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 313s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 313s ok 67 - psql -XAtc '\drds' 313s ok 68 - correct output of psql -XAtc '\drds' 313s # restore /var/backups/postgresql/18-main/2025-11-05T221100Z.backup with WAL archive 314s ok 69 - pg_dropcluster 18 main --stop 317s ok 70 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-05T221100Z.backup --start --archive --port 5430 317s ok 71 - pg_lsclusters -h 317s ok 72 - correct output of pg_lsclusters -h 317s ok 73 - psql -XAtc 'select * from foo order by t' mydb 317s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 317s # restore /var/backups/postgresql/18-main/2025-11-05T221100Z.backup with PITR 318s ok 75 - pg_dropcluster 18 main --stop 322s ok 76 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-05T221100Z.backup --start --pitr '2025-11-05 22:11:27.859024+00 322s # ' 322s ok 77 - pg_lsclusters -h 322s ok 78 - correct output of pg_lsclusters -h 322s ok 79 - psql -XAtc 'select * from foo order by t' mydb 322s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 323s ok 81 - pg_dropcluster 18 main --stop 323s # Cleanup 323s ok 82 - Cleanup: No clusters left behind 323s ok 83 - No postgres processes left behind 323s ok 84 - No files in /etc/postgresql left behind 323s ok 85 - No files in /var/lib/postgresql left behind 323s ok 86 - No files in /var/run/postgresql left behind 323s ok 87 - No files in /var/log/postgresql left behind 323s ok 88 - PostgreSQL TCP ports are closed 323s ok 89 - Next free port is 5432 323s 1..89 323s ### End test 045_backup.t ### 323s 323s ### PostgreSQL test 050_encodings.t ### 323s 1..60 323s # Checking 18 ru_RU 326s ok 1 - pg_createcluster version 18 for ru_RU without --encoding succeeded 327s ok 2 - psql -l succeeds 327s ok 3 - template1 is not UTF-8 encoded 327s ok 4 - creating test database 327s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 327s # create table t (x varchar); copy t from stdin" test 327s ok 6 - creating table with ISO-8859-5 characters 327s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 327s ok 8 - correct string in UTF-8 327s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 327s ok 10 - correct string in ISO-8859-5 327s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 327s # delete from t; copy t from stdin" test 327s ok 12 - creating table with UTF-8 characters 327s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 327s ok 14 - correct string in UTF-8 327s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 327s ok 16 - correct string in ISO-8859-1 327s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 327s ok 18 - Server error message has correct language and encoding 329s ok 19 - pg_ctlcluster 18 ru_RU restart 329s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 330s ok 21 - Dropping cluster 330s # Checking 18 ru_RU.UTF-8 333s ok 22 - pg_createcluster version 18 for ru_RU.UTF-8 without --encoding succeeded 334s ok 23 - psql -l succeeds 334s ok 24 - template1 is UTF-8 encoded 334s ok 25 - creating test database 334s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 334s # create table t (x varchar); copy t from stdin" test 334s ok 27 - creating table with ISO-8859-5 characters 334s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 334s ok 29 - correct string in UTF-8 334s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 334s ok 31 - correct string in ISO-8859-5 334s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 334s # delete from t; copy t from stdin" test 334s ok 33 - creating table with UTF-8 characters 334s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 334s ok 35 - correct string in UTF-8 334s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 334s ok 37 - correct string in ISO-8859-1 334s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 334s ok 39 - Server error message has correct language and encoding 337s ok 40 - pg_ctlcluster 18 ru_RU.UTF8 restart 337s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 337s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 337s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 337s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 337s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 337s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 337s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 338s ok 48 - Dropping cluster 338s # Check 18 locale environment variables 340s ok 49 - pg_createcluster: LC_ALL dominates LANG 340s ok 50 - psql -Atl --cluster 18/main 340s ok 51 - template1 is ASCII encoded 342s ok 52 - Dropping cluster 342s # Cleanup 342s ok 53 - Cleanup: No clusters left behind 342s ok 54 - No postgres processes left behind 342s ok 55 - No files in /etc/postgresql left behind 342s ok 56 - No files in /var/lib/postgresql left behind 342s ok 57 - No files in /var/run/postgresql left behind 342s ok 58 - No files in /var/log/postgresql left behind 342s ok 59 - PostgreSQL TCP ports are closed 342s ok 60 - Next free port is 5432 342s ### End test 050_encodings.t ### 342s 342s ### PostgreSQL test 052_upgrade_encodings.t ### 342s 1..1 342s ok 1 - only one major version installed, skipping upgrade tests 342s ### End test 052_upgrade_encodings.t ### 342s 342s ### PostgreSQL test 060_obsolete_confparams.t ### 342s ok 1 - only one major version installed, skipping upgrade tests 342s 1..1 342s ### End test 060_obsolete_confparams.t ### 342s 342s ### PostgreSQL test 070_non_postgres_clusters.t ### 342s 1..40 342s ok 1 - pg_createcluster 18 main for owner nobody 342s ok 2 - pg_ctlcluster 18 main start 342s ok 3 - start refused when config and data owners mismatch 345s ok 4 - pg_ctlcluster succeeds with owner nobody 345s ok 5 - pg_lsclusters -h 345s ok 6 - pg_lsclusters shows running cluster 345s ok 7 - postgres is running as user nobody 345s ok 8 - ls /tmp/.s.PGSQL.* 345s ok 9 - socket is in /tmp 345s ok 10 - /var/run/postgresql is empty 345s ok 11 - conf dir is owned by user 345s ok 12 - conf dir is owned by user's primary group 345s ok 13 - files are owned by user 345s ok 14 - files are owned by user's primary group 345s ok 15 - log file has 0640 permissions 345s ok 16 - log file is owned by user 345s ok 17 - log file is owned by user's primary group 345s ok 18 - only one major version installed, skipping upgrade test 345s ok 19 - ... 345s ok 20 - ... 345s ok 21 - ... 345s ok 22 - ... 345s ok 23 - ... 345s ok 24 - ... 345s ok 25 - ... 345s ok 26 - ... 345s ok 27 - ... 345s ok 28 - ... 346s ok 29 - pg_dropcluster 346s ok 30 - pg_lsclusters -h 346s ok 31 - No clusters left 346s ok 32 - No postgres processes left 346s # Cleanup 346s ok 33 - Cleanup: No clusters left behind 346s ok 34 - No postgres processes left behind 346s ok 35 - No files in /etc/postgresql left behind 346s ok 36 - No files in /var/lib/postgresql left behind 346s ok 37 - No files in /var/run/postgresql left behind 346s ok 38 - No files in /var/log/postgresql left behind 346s ok 39 - PostgreSQL TCP ports are closed 346s ok 40 - Next free port is 5432 346s ### End test 070_non_postgres_clusters.t ### 346s 346s ### PostgreSQL test 080_start.conf.t ### 346s 1..73 346s ok 1 - pg_createcluster 18 main 346s # start.conf auto 346s ok 2 - get_cluster_start_conf returns auto 346s ok 3 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 346s ok 4 - start.conf contains auto 346s ok 5 - systemd generator links cluster 346s ok 6 - systemd generator links correct service file 349s ok 7 - /etc/init.d/postgresql start 18 349s ok 8 - correct output of /etc/init.d/postgresql start 18 349s ok 9 - pg_lsclusters -h 349s ok 10 - cluster is online 349s ok 11 - /etc/init.d/postgresql stop 18 349s ok 12 - correct output of /etc/init.d/postgresql stop 18 352s ok 13 - pg_lsclusters -h 352s ok 14 - cluster is down 352s # start.conf manual 352s ok 15 - get_cluster_start_conf returns manual 352s ok 16 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 352s ok 17 - start.conf contains manual 352s ok 18 - systemd generator doesn't link cluster 352s ok 19 - /etc/init.d/postgresql start 18 352s ok 20 - correct output of /etc/init.d/postgresql start 18 352s ok 21 - pg_lsclusters -h 352s ok 22 - cluster is down 354s ok 23 - pg_ctlcluster 18 main start 354s ok 24 - correct output of pg_ctlcluster 18 main start 354s ok 25 - pg_lsclusters -h 354s ok 26 - cluster is online 354s ok 27 - pg_ctlcluster 18 main stop 354s ok 28 - correct output of pg_ctlcluster 18 main stop 354s ok 29 - pg_lsclusters -h 354s ok 30 - cluster is down 354s # start.conf disabled 354s ok 31 - get_cluster_start_conf returns disabled 354s ok 32 - systemd generator doesn't link cluster 354s ok 33 - /etc/init.d/postgresql start 18 354s ok 34 - correct output of /etc/init.d/postgresql start 18 354s ok 35 - pg_lsclusters -h 354s ok 36 - cluster is down 354s ok 37 - pg_ctlcluster 18 main start 354s ok 38 - correct output of pg_ctlcluster 18 main start 354s ok 39 - pg_lsclusters -h 354s ok 40 - cluster is down 357s ok 41 - pg_ctlcluster 18 main start 357s ok 42 - correct output of pg_ctlcluster 18 main start 357s ok 43 - pg_lsclusters -h 357s ok 44 - cluster is online 357s ok 45 - pg_ctlcluster 18 main stop 357s ok 46 - correct output of pg_ctlcluster 18 main stop 357s ok 47 - pg_lsclusters -h 357s ok 48 - cluster is down 359s ok 49 - pg_ctlcluster 18 main start 359s ok 50 - correct output of pg_ctlcluster 18 main start 359s ok 51 - pg_lsclusters -h 359s ok 52 - cluster is online 359s # test upgrade 359s ok 53 - only one major version installed, skipping upgrade test 359s ok 54 - ... 359s ok 55 - get_cluster_start_conf for old cluster returns manual 359s ok 56 - get_cluster_start_conf for new cluster returns manual 359s ok 57 - ... 360s ok 58 - dropping upgraded cluster 360s ok 59 - pg_lsclusters -h 360s ok 60 - no clusters any more 360s ok 61 - pg_createcluster 18 main --start-conf foo 360s ok 62 - pg_createcluster checks --start-conf validity 360s ok 63 - pg_createcluster checks --start-conf manual 361s ok 64 - get_cluster_start_conf returns manual 361s ok 65 - dropping cluster 361s # Cleanup 361s ok 66 - Cleanup: No clusters left behind 361s ok 67 - No postgres processes left behind 361s ok 68 - No files in /etc/postgresql left behind 361s ok 69 - No files in /var/lib/postgresql left behind 361s ok 70 - No files in /var/run/postgresql left behind 361s ok 71 - No files in /var/log/postgresql left behind 361s ok 72 - PostgreSQL TCP ports are closed 361s ok 73 - Next free port is 5432 361s ### End test 080_start.conf.t ### 361s 361s ### PostgreSQL test 085_pg_ctl.conf.t ### 361s 1..33 361s ok 1 - prlimit --core=0:unlimited --pid=18366 361s ok 2 - set core file size to unlimited 361s ok 3 - sh -c 'ulimit -Hc' 361s ok 4 - core file size is unlimited 362s ok 5 - pg_createcluster 18 main 362s ok 6 - /etc/postgresql/18/main/pg_ctl.conf exists 364s ok 7 - pg_ctlcluster 18 main start 364s ok 8 - starting cluster as root 364s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 364s ok 10 - soft core size is 0 364s # hard core file size limit of root-started postgres process is unlimited 364s ok 11 - set pg_ctl default option to -c 366s ok 12 - pg_ctlcluster 18 main restart 366s ok 13 - restarting cluster as root 366s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 366s ok 15 - soft core size is unlimited 367s ok 16 - pg_ctlcluster 18 main stop 367s ok 17 - stopping cluster 367s ok 18 - restored pg_ctl default option 369s ok 19 - pg_ctlcluster 18 main start -- -c 369s ok 20 - starting cluster with -c on the command line as postgres 369s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 369s ok 22 - soft core size is unlimited 369s ok 23 - pg_ctlcluster 18 main stop 369s ok 24 - stopping cluster 370s ok 25 - dropping cluster 370s # Cleanup 370s ok 26 - Cleanup: No clusters left behind 370s ok 27 - No postgres processes left behind 370s ok 28 - No files in /etc/postgresql left behind 370s ok 29 - No files in /var/lib/postgresql left behind 370s ok 30 - No files in /var/run/postgresql left behind 370s ok 31 - No files in /var/log/postgresql left behind 370s ok 32 - PostgreSQL TCP ports are closed 370s ok 33 - Next free port is 5432 370s ### End test 085_pg_ctl.conf.t ### 370s 370s ### PostgreSQL test 090_multicluster.t ### 370s 1..125 370s ok 1 - pg_createcluster 18 old 371s ok 2 - pg_createcluster 18 new1 372s ok 3 - pg_createcluster 18 new2 374s ok 4 - starting cluster 18/old 376s ok 5 - starting cluster 18/new1 378s ok 6 - starting cluster 18/new2 378s ok 7 - pg_lsclusters -h | sort -k3 378s ok 8 - clusters have the correct ports, skipping used 5433 378s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 378s ok 10 - createdb --version 378s ok 11 - pg_wrapper selects port 5432 as default cluster 378s ok 12 - createdb --cluster 18/new1 --version 378s ok 13 - pg_wrapper --cluster works 378s ok 14 - createdb --cluster 18/foo --version 378s ok 15 - pg_wrapper --cluster errors out for invalid cluster 378s ok 16 - createdb --cluster 18/new1 test 378s ok 17 - correct output of createdb --cluster 18/new1 test 378s ok 18 - psql -Atl --cluster 18/new1 378s ok 19 - test db appears in cluster new1 378s ok 20 - psql -Atl --cluster 18/new2 378s ok 21 - test db does not appear in cluster new2 378s ok 22 - psql -Atl 378s ok 23 - test db does not appear in default cluster 378s ok 24 - psql --cluster 18/127.0.0.1: -Atc 'show port' template1 378s ok 25 - psql --cluster 18/127.0.0.1: defaults to port 5432 378s ok 26 - createdb --cluster 18/127.0.0.1:5432 --version 378s ok 27 - createdb --cluster 18/127.0.0.1:5432 uses latest client version 378s ok 28 - psql -Atl --cluster 18/localhost:5434 378s ok 29 - test db appears in cluster 18/localhost:5434 378s ok 30 - psql -Atl --cluster 18/localhost:5440 378s ok 31 - test db does not appear in cluster 18/localhost:5440 378s ok 32 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:5435 378s ok 33 - psql --cluster 18/localhost:5435 fails due to nonexisting port 378s ok 34 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:a 378s ok 35 - psql --cluster 18/localhost:a fails due to invalid syntax 378s ok 36 - LC_MESSAGES=C psql -Atl --cluster 18/doesnotexi.st 378s ok 37 - psql --cluster 18/doesnotexi.st fails due to invalid syntax 378s ok 38 - psql -Atl --cluster 6.4/localhost: 378s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 379s ok 40 - psql -Atl 379s ok 41 - PGCLUSTER selection (1) 379s ok 42 - psql -Atl 379s ok 43 - PGCLUSTER selection (2) 379s ok 44 - psql -l 379s ok 45 - invalid PGCLUSTER value 379s ok 46 - createdb --version 379s ok 47 - PGCLUSTER network cluster selection (1) 379s ok 48 - psql -Atl 379s ok 49 - PGCLUSTER network cluster selection (2) 379s ok 50 - psql -Atl 379s ok 51 - PGCLUSTER network cluster selection (3) 379s ok 52 - LC_MESSAGES=C psql -Atl 379s ok 53 - psql --cluster 18/localhost:5435 fails due to nonexisting port 379s ok 54 - psql -Atc "show port" template1 379s ok 55 - PGPORT selection (1) 379s ok 56 - psql -Atc "show port" template1 379s ok 57 - PGPORT selection (2) 379s ok 58 - createdb --version 379s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 379s ok 60 - psql -Atc "show port" template1 379s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 379s ok 62 - psql --cluster 18/new1 -Atc 'select current_database()' 379s ok 63 - PGDATABASE environment variable works 379s ok 64 - createdb --version 379s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 379s ok 66 - createdb --cluster 18/new1 --version 379s ok 67 - pg_wrapper --cluster works with empty user_clusters 379s ok 68 - createdb --version 379s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 18 new1 *' 379s ok 70 - psql -Atc "select current_database()" 379s ok 71 - pg_wrapper selects correct database with user_clusters '* * 18 new1 test' 379s ok 72 - psql -Atc 'select current_database()' 379s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 379s ok 74 - createdb --version 379s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 379s ok 76 - createdb --version 379s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 379s ok 78 - createdb --version 379s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 379s ok 80 - createdb --version 379s ok 81 - pg_wrapper selects correct version with per-user user_clusters 379s ok 82 - createdb --version 379s ok 83 - pg_wrapper selects correct version with per-user user_clusters 379s ok 84 - createdb --version 379s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 379s ok 86 - psql -Atl 379s ok 87 - $PGHOST overrides user_clusters 379s ok 88 - psql --cluster 18/localhost:5434 -Atc 'select current_database()' test 379s ok 89 - --cluster overrides $PGHOST 379s ok 90 - createdb --version 379s ok 91 - pg_wrapper ignores invalid lines in user_clusters 379s ok 92 - psql -Atc 'select current_database()' 379s ok 93 - pg_service conf selection 1 379s ok 94 - psql -Atc 'select current_database()' 379s ok 95 - pg_service conf selection 2 379s ok 96 - psql -Atc 'select current_database()' 379s ok 97 - pg_service conf selection 3 379s ok 98 - stopping cluster 18/old 382s ok 99 - restarting cluster 18/old 382s ok 100 # skip rust coreutils sort -k option regression. See LP: #2125504 382s ok 101 # skip rust coreutils sort -k option regression. See LP: #2125504 382s ok 102 - psql -l 382s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 382s ok 104 - psql -Atl --cluster 18/new1 382s ok 105 - --cluster selects appropriate cluster 382s ok 106 - psql -Atl -p 5434 382s ok 107 - -p selects appropriate cluster 382s ok 108 - psql -Atlp 5434 382s ok 109 - -Atlp selects appropriate cluster 382s ok 110 - psql -Atl --port 5434 382s ok 111 - --port selects appropriate cluster 382s ok 112 - env PGPORT=5434 psql -Atl 382s ok 113 - $PGPORT selects appropriate cluster 382s ok 114 - Restoring original /etc/postgresql-common/user_clusters 383s ok 115 - dropping 18/new1 384s ok 116 - dropping 18/new2 385s ok 117 - dropping 18/old 385s # Cleanup 385s ok 118 - Cleanup: No clusters left behind 385s ok 119 - No postgres processes left behind 385s ok 120 - No files in /etc/postgresql left behind 385s ok 121 - No files in /var/lib/postgresql left behind 385s ok 122 - No files in /var/run/postgresql left behind 385s ok 123 - No files in /var/log/postgresql left behind 385s ok 124 - PostgreSQL TCP ports are closed 385s ok 125 - Next free port is 5432 385s ### End test 090_multicluster.t ### 385s 385s ### PostgreSQL test 110_integrate_cluster.t ### 385s 1..32 388s ok 1 - /usr/lib/postgresql/18/bin/initdb /tmp/d3xr5RaavO/c/postgres 388s ok 2 - creating raw initdb cluster for user postgres 388s ok 3 - pg_createcluster 18 postgres -d /tmp/d3xr5RaavO/c/postgres 388s ok 4 - integrating postgres cluster 388s ok 5 - pg_lsclusters 388s ok 6 - correct pg_lsclusters output 388s ok 7 - pg_ctlcluster 18 postgres start 388s ok 8 - starting cluster postgres 388s ok 9 - pg_lsclusters 388s ok 10 - correct pg_lsclusters output 389s ok 11 - dropping cluster postgres 389s ok 12 - No files in temporary cluster dir left behind 389s ok 13 - /usr/lib/postgresql/18/bin/initdb /tmp/d3xr5RaavO/c/nobody 389s ok 14 - creating raw initdb cluster for user nobody 390s ok 15 - pg_createcluster 18 nobody -d /tmp/d3xr5RaavO/c/nobody 390s ok 16 - integrating nobody cluster 390s ok 17 - pg_lsclusters 390s ok 18 - correct pg_lsclusters output 392s ok 19 - pg_ctlcluster 18 nobody start 392s ok 20 - starting cluster nobody 392s ok 21 - pg_lsclusters 392s ok 22 - correct pg_lsclusters output 393s ok 23 - dropping cluster nobody 393s ok 24 - No files in temporary cluster dir left behind 393s # Cleanup 393s ok 25 - Cleanup: No clusters left behind 393s ok 26 - No postgres processes left behind 393s ok 27 - No files in /etc/postgresql left behind 393s ok 28 - No files in /var/lib/postgresql left behind 393s ok 29 - No files in /var/run/postgresql left behind 393s ok 30 - No files in /var/log/postgresql left behind 393s ok 31 - PostgreSQL TCP ports are closed 393s ok 32 - Next free port is 5432 393s ### End test 110_integrate_cluster.t ### 393s 393s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 393s 1..1 393s ok 1 - only one major version installed, skipping upgrade tests 393s ### End test 120_pg_upgradecluster_scripts.t ### 393s 393s ### PostgreSQL test 130_nonroot_admin.t ### 393s 1..22 396s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 396s ok 2 - pg_lsclusters -h 396s ok 3 - correct output of pg_lsclusters -h 396s ok 4 - psql -Atl 396s ok 5 - correct output of psql -Atl 396s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 396s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 396s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 396s # Cleanup 396s ok 15 - Cleanup: No clusters left behind 396s ok 16 - No postgres processes left behind 396s ok 17 - No files in /etc/postgresql left behind 396s ok 18 - No files in /var/lib/postgresql left behind 396s ok 19 - No files in /var/run/postgresql left behind 396s ok 20 - No files in /var/log/postgresql left behind 396s ok 21 - PostgreSQL TCP ports are closed 396s ok 22 - Next free port is 5432 396s ### End test 130_nonroot_admin.t ### 396s 396s ### PostgreSQL test 135_pg_virtualenv.t ### 396s 1..20 400s ok 1 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 400s ok 2 - running pg_virtualenv as root 403s ok 3 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 403s ok 4 - running pg_virtualenv as postgres 405s ok 5 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 405s ok 6 - running pg_virtualenv as nobody 408s ok 7 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 408s ok 8 - running fakeroot pg_virtualenv as root 411s ok 9 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 411s ok 10 - running fakeroot pg_virtualenv as postgres 414s ok 11 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 414s ok 12 - running fakeroot pg_virtualenv as nobody 414s # Cleanup 414s ok 13 - Cleanup: No clusters left behind 414s ok 14 - No postgres processes left behind 414s ok 15 - No files in /etc/postgresql left behind 414s ok 16 - No files in /var/lib/postgresql left behind 414s ok 17 - No files in /var/run/postgresql left behind 414s ok 18 - No files in /var/log/postgresql left behind 414s ok 19 - PostgreSQL TCP ports are closed 414s ok 20 - Next free port is 5432 414s ### End test 135_pg_virtualenv.t ### 414s 414s ### PostgreSQL test 140_pg_config.t ### 414s 1..38 414s # Multiarch is enabled 414s # checking version specific output for 18 414s ok 1 - /usr/lib/postgresql/18/bin/pg_config --pgxs 414s ok 2 - correct output of /usr/lib/postgresql/18/bin/pg_config --pgxs 414s ok 3 - /usr/lib/postgresql/18/bin/pg_config --libdir 414s ok 4 - correct output of /usr/lib/postgresql/18/bin/pg_config --libdir 414s ok 5 - /usr/lib/postgresql/18/bin/pg_config --pkglibdir 414s ok 6 - correct output of /usr/lib/postgresql/18/bin/pg_config --pkglibdir 414s ok 7 - /usr/lib/postgresql/18/bin/pg_config --bindir 414s ok 8 - correct output of /usr/lib/postgresql/18/bin/pg_config --bindir 414s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 414s # checking pg_config output (should behave like version 18) 414s ok 15 - pg_config 414s ok 16 - correct output of pg_config 414s ok 17 - pg_config --help 414s ok 18 - correct output of pg_config --help 414s ok 19 - pg_config --pgxs 414s ok 20 - correct output of pg_config --pgxs 414s ok 21 - pg_config --libdir 414s ok 22 - correct output of pg_config --libdir 414s ok 23 - pg_config --pkglibdir 414s ok 24 - correct output of pg_config --pkglibdir 414s ok 25 - pg_config --bindir 414s ok 26 - correct output of pg_config --bindir 414s # checking pg_config.libpq-dev output (should behave like version 18) 414s ok 27 - pg_config.libpq-dev 414s ok 28 - correct output of pg_config.libpq-dev 414s ok 29 - pg_config.libpq-dev --help 414s ok 30 - correct output of pg_config.libpq-dev --help 414s ok 31 - pg_config.libpq-dev --pgxs 414s ok 32 - correct output of pg_config.libpq-dev --pgxs 414s ok 33 - pg_config.libpq-dev --libdir 414s ok 34 - correct output of pg_config.libpq-dev --libdir 414s ok 35 - pg_config.libpq-dev --pkglibdir 414s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 414s ok 37 - pg_config.libpq-dev --bindir 414s ok 38 - correct output of pg_config.libpq-dev --bindir 414s ### End test 140_pg_config.t ### 414s 414s ### PostgreSQL test 150_tsearch_stemming.t ### 414s 1..37 414s ok 1 - pg_updatedicts succeeded 414s ok 2 - pg_updatedicts created en_us.affix 414s ok 3 - pg_updatedicts created en_us.dict 414s ok 4 - pg_updatedicts created 18 en_us.affix symlink 414s ok 5 - pg_updatedicts created 18 en_us.dict symlink 417s ok 6 - pg_createcluster 18 main 417s ok 7 - createdb fts 417s ok 8 - correct output of createdb fts 417s ok 9 - creating en_US full text search configuration 417s ok 10 - creating data table and search index 417s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 417s ok 12 - stem search of correct word 417s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 417s ok 14 - stem search of correct word 417s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 417s ok 16 - stem search of unknown word 417s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 417s ok 18 - full text search, exact word 417s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 417s ok 20 - full text search for word stem 417s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 417s ok 22 - full text search for word substring fails 417s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 417s ok 24 - full text search, exact unicode word 417s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 417s ok 26 - full text search for unicode word stem 417s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 417s ok 28 - full text search for unicode word substring fails 418s ok 29 418s # Cleanup 418s ok 30 - Cleanup: No clusters left behind 418s ok 31 - No postgres processes left behind 418s ok 32 - No files in /etc/postgresql left behind 418s ok 33 - No files in /var/lib/postgresql left behind 418s ok 34 - No files in /var/run/postgresql left behind 418s ok 35 - No files in /var/log/postgresql left behind 418s ok 36 - PostgreSQL TCP ports are closed 418s ok 37 - Next free port is 5432 418s ### End test 150_tsearch_stemming.t ### 418s 418s ### PostgreSQL test 160_alternate_confroot.t ### 418s 1..28 421s ok 1 421s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 421s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 421s ok 4 - pg_lsclusters -h 421s ok 5 - correct output of pg_lsclusters -h 421s ok 6 - psql -Atl 421s ok 7 - correct output of psql -Atl 421s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 421s ok 9 - ... 421s ok 10 - ... 421s ok 11 - ... 421s ok 12 - ... 421s ok 13 - ... 421s ok 14 - ... 421s ok 15 - pg_dropcluster 18 test --stop 421s ok 16 - correct output of pg_dropcluster 18 test --stop 421s ok 17 - pg_lsclusters -h 421s ok 18 - correct output of pg_lsclusters -h 421s ok 19 - No files in root/data left behind 421s ok 20 - No cruft in root dir left behind 421s # Cleanup 421s ok 21 - Cleanup: No clusters left behind 421s ok 22 - No postgres processes left behind 421s ok 23 - No files in /etc/postgresql left behind 421s ok 24 - No files in /var/lib/postgresql left behind 421s ok 25 - No files in /var/run/postgresql left behind 421s ok 26 - No files in /var/log/postgresql left behind 421s ok 27 - PostgreSQL TCP ports are closed 421s ok 28 - Next free port is 5432 421s ### End test 160_alternate_confroot.t ### 421s 421s ### PostgreSQL test 170_extensions.t ### 421s # Running tests for 18 424s ok 1 - pg_createcluster 18 main 424s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 424s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 424s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 424s ok 5 - extension amcheck installs without error 424s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 424s ok 7 - extension amcheck removes without error 424s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 424s ok 9 - extension autoinc installs without error 424s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 424s ok 11 - extension autoinc removes without error 424s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 424s ok 13 - extension bloom installs without error 424s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 424s ok 15 - extension bloom removes without error 424s ok 16 - psql -qc 'CREATE EXTENSION plperl' 424s ok 17 - bool_plperl dependency plperl installs without error 424s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 424s ok 19 - extension bool_plperl installs without error 424s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 424s ok 21 - extension bool_plperl removes without error 424s ok 22 - psql -qc 'DROP EXTENSION plperl' 424s ok 23 - bool_plperl dependency extension plperl removes without error 424s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 424s ok 25 - bool_plperlu dependency plperlu installs without error 424s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 424s ok 27 - extension bool_plperlu installs without error 424s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 424s ok 29 - extension bool_plperlu removes without error 425s ok 30 - psql -qc 'DROP EXTENSION plperlu' 425s ok 31 - bool_plperlu dependency extension plperlu removes without error 425s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 425s ok 33 - extension btree_gin installs without error 425s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 425s ok 35 - extension btree_gin removes without error 425s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 425s ok 37 - extension btree_gist installs without error 425s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 425s ok 39 - extension btree_gist removes without error 425s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 425s ok 41 - extension citext installs without error 425s ok 42 - psql -qc 'DROP EXTENSION "citext"' 425s ok 43 - extension citext removes without error 425s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 425s ok 45 - extension cube installs without error 425s ok 46 - psql -qc 'DROP EXTENSION "cube"' 425s ok 47 - extension cube removes without error 425s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 425s ok 49 - extension dblink installs without error 425s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 425s ok 51 - extension dblink removes without error 425s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 425s ok 53 - extension dict_int installs without error 425s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 425s ok 55 - extension dict_int removes without error 425s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 425s ok 57 - extension dict_xsyn installs without error 425s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 425s ok 59 - extension dict_xsyn removes without error 425s ok 60 - psql -qc 'CREATE EXTENSION cube' 425s ok 61 - earthdistance dependency cube installs without error 425s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 425s ok 63 - extension earthdistance installs without error 425s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 425s ok 65 - extension earthdistance removes without error 425s ok 66 - psql -qc 'DROP EXTENSION cube' 425s ok 67 - earthdistance dependency extension cube removes without error 425s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 425s ok 69 - extension file_fdw installs without error 425s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 425s ok 71 - extension file_fdw removes without error 425s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 425s ok 73 - extension fuzzystrmatch installs without error 425s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 425s ok 75 - extension fuzzystrmatch removes without error 425s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 425s ok 77 - extension hstore installs without error 425s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 425s ok 79 - extension hstore removes without error 425s ok 80 - psql -qc 'CREATE EXTENSION hstore' 425s ok 81 - hstore_plperl dependency hstore installs without error 425s ok 82 - psql -qc 'CREATE EXTENSION plperl' 425s ok 83 - hstore_plperl dependency plperl installs without error 425s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 425s ok 85 - extension hstore_plperl installs without error 425s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 425s ok 87 - extension hstore_plperl removes without error 425s ok 88 - psql -qc 'DROP EXTENSION hstore' 425s ok 89 - hstore_plperl dependency extension hstore removes without error 425s ok 90 - psql -qc 'DROP EXTENSION plperl' 425s ok 91 - hstore_plperl dependency extension plperl removes without error 425s ok 92 - psql -qc 'CREATE EXTENSION hstore' 425s ok 93 - hstore_plperlu dependency hstore installs without error 425s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 425s ok 95 - hstore_plperlu dependency plperlu installs without error 425s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 425s ok 97 - extension hstore_plperlu installs without error 425s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 425s ok 99 - extension hstore_plperlu removes without error 425s ok 100 - psql -qc 'DROP EXTENSION hstore' 425s ok 101 - hstore_plperlu dependency extension hstore removes without error 425s ok 102 - psql -qc 'DROP EXTENSION plperlu' 425s ok 103 - hstore_plperlu dependency extension plperlu removes without error 426s ok 104 - psql -qc 'CREATE EXTENSION hstore' 426s ok 105 - hstore_plpython3u dependency hstore installs without error 426s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 426s ok 107 - hstore_plpython3u dependency plpython3u installs without error 426s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 426s ok 109 - extension hstore_plpython3u installs without error 426s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 426s ok 111 - extension hstore_plpython3u removes without error 426s ok 112 - psql -qc 'DROP EXTENSION hstore' 426s ok 113 - hstore_plpython3u dependency extension hstore removes without error 426s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 426s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 426s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 426s ok 117 - extension insert_username installs without error 426s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 426s ok 119 - extension insert_username removes without error 426s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 426s ok 121 - extension intagg installs without error 426s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 426s ok 123 - extension intagg removes without error 426s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 426s ok 125 - extension intarray installs without error 426s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 426s ok 127 - extension intarray removes without error 426s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 426s ok 129 - extension isn installs without error 426s ok 130 - psql -qc 'DROP EXTENSION "isn"' 426s ok 131 - extension isn removes without error 426s ok 132 - psql -qc 'CREATE EXTENSION plperl' 426s ok 133 - jsonb_plperl dependency plperl installs without error 426s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 426s ok 135 - extension jsonb_plperl installs without error 426s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 426s ok 137 - extension jsonb_plperl removes without error 426s ok 138 - psql -qc 'DROP EXTENSION plperl' 426s ok 139 - jsonb_plperl dependency extension plperl removes without error 426s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 426s ok 141 - jsonb_plperlu dependency plperlu installs without error 426s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 426s ok 143 - extension jsonb_plperlu installs without error 426s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 426s ok 145 - extension jsonb_plperlu removes without error 426s ok 146 - psql -qc 'DROP EXTENSION plperlu' 426s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 426s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 426s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 426s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 426s ok 151 - extension jsonb_plpython3u installs without error 426s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 426s ok 153 - extension jsonb_plpython3u removes without error 426s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 426s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 426s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 426s ok 157 - extension lo installs without error 426s ok 158 - psql -qc 'DROP EXTENSION "lo"' 426s ok 159 - extension lo removes without error 426s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 426s ok 161 - extension ltree installs without error 426s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 426s ok 163 - extension ltree removes without error 426s ok 164 - psql -qc 'CREATE EXTENSION ltree' 426s ok 165 - ltree_plpython3u dependency ltree installs without error 426s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 426s ok 167 - ltree_plpython3u dependency plpython3u installs without error 426s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 426s ok 169 - extension ltree_plpython3u installs without error 426s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 426s ok 171 - extension ltree_plpython3u removes without error 426s ok 172 - psql -qc 'DROP EXTENSION ltree' 426s ok 173 - ltree_plpython3u dependency extension ltree removes without error 426s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 426s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 427s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 427s ok 177 - extension moddatetime installs without error 427s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 427s ok 179 - extension moddatetime removes without error 427s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 427s ok 181 - extension pageinspect installs without error 427s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 427s ok 183 - extension pageinspect removes without error 427s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 427s ok 185 - extension pg_buffercache installs without error 427s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 427s ok 187 - extension pg_buffercache removes without error 427s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 427s ok 189 - extension pg_freespacemap installs without error 427s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 427s ok 191 - extension pg_freespacemap removes without error 427s ok 192 - psql -qc 'CREATE EXTENSION "pg_logicalinspect"' 427s ok 193 - extension pg_logicalinspect installs without error 427s ok 194 - psql -qc 'DROP EXTENSION "pg_logicalinspect"' 427s ok 195 - extension pg_logicalinspect removes without error 427s ok 196 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 427s ok 197 - extension pg_prewarm installs without error 427s ok 198 - psql -qc 'DROP EXTENSION "pg_prewarm"' 427s ok 199 - extension pg_prewarm removes without error 427s ok 200 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 427s ok 201 - extension pg_stat_statements installs without error 427s ok 202 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 427s ok 203 - extension pg_stat_statements removes without error 427s ok 204 - psql -qc 'CREATE EXTENSION "pg_surgery"' 427s ok 205 - extension pg_surgery installs without error 427s ok 206 - psql -qc 'DROP EXTENSION "pg_surgery"' 427s ok 207 - extension pg_surgery removes without error 427s ok 208 - psql -qc 'CREATE EXTENSION "pg_trgm"' 427s ok 209 - extension pg_trgm installs without error 427s ok 210 - psql -qc 'DROP EXTENSION "pg_trgm"' 427s ok 211 - extension pg_trgm removes without error 427s ok 212 - psql -qc 'CREATE EXTENSION "pg_visibility"' 427s ok 213 - extension pg_visibility installs without error 427s ok 214 - psql -qc 'DROP EXTENSION "pg_visibility"' 427s ok 215 - extension pg_visibility removes without error 427s ok 216 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 427s ok 217 - extension pg_walinspect installs without error 427s ok 218 - psql -qc 'DROP EXTENSION "pg_walinspect"' 427s ok 219 - extension pg_walinspect removes without error 427s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 427s ok 221 - extension pgcrypto installs without error 427s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 427s ok 223 - extension pgcrypto removes without error 427s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 427s ok 225 - extension pgrowlocks installs without error 427s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 427s ok 227 - extension pgrowlocks removes without error 427s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 427s ok 229 - extension pgstattuple installs without error 427s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 427s ok 231 - extension pgstattuple removes without error 427s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 427s ok 233 - extension plperl installs without error 427s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 427s ok 235 - extension plperl removes without error 427s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 427s ok 237 - extension plperlu installs without error 427s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 427s ok 239 - extension plperlu removes without error 427s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 427s ok 241 - extension plpython3u installs without error 427s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 427s ok 243 - extension plpython3u removes without error 427s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 427s ok 245 - extension pltcl installs without error 427s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 427s ok 247 - extension pltcl removes without error 427s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 427s ok 249 - extension pltclu installs without error 427s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 427s ok 251 - extension pltclu removes without error 427s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 427s ok 253 - extension postgres_fdw installs without error 428s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 428s ok 255 - extension postgres_fdw removes without error 428s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 428s ok 257 - extension refint installs without error 428s ok 258 - psql -qc 'DROP EXTENSION "refint"' 428s ok 259 - extension refint removes without error 428s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 428s ok 261 - extension seg installs without error 428s ok 262 - psql -qc 'DROP EXTENSION "seg"' 428s ok 263 - extension seg removes without error 428s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 428s ok 265 - extension sslinfo installs without error 428s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 428s ok 267 - extension sslinfo removes without error 428s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 428s ok 269 - extension tablefunc installs without error 428s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 428s ok 271 - extension tablefunc removes without error 428s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 428s ok 273 - extension tcn installs without error 428s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 428s ok 275 - extension tcn removes without error 428s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 428s ok 277 - extension tsm_system_rows installs without error 428s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 428s ok 279 - extension tsm_system_rows removes without error 428s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 428s ok 281 - extension tsm_system_time installs without error 428s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 428s ok 283 - extension tsm_system_time removes without error 428s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 428s ok 285 - extension unaccent installs without error 428s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 428s ok 287 - extension unaccent removes without error 428s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 428s ok 289 - extension uuid-ossp installs without error 428s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 428s ok 291 - extension uuid-ossp removes without error 428s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 428s ok 293 - extension xml2 installs without error 428s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 428s ok 295 - extension xml2 removes without error 429s ok 296 - pg_dropcluster 18 main 429s # Cleanup 429s ok 297 - Cleanup: No clusters left behind 429s ok 298 - No postgres processes left behind 429s ok 299 - No files in /etc/postgresql left behind 429s ok 300 - No files in /var/lib/postgresql left behind 429s ok 301 - No files in /var/run/postgresql left behind 429s ok 302 - No files in /var/log/postgresql left behind 429s ok 303 - PostgreSQL TCP ports are closed 429s ok 304 - Next free port is 5432 429s 1..304 429s ### End test 170_extensions.t ### 429s 429s ### PostgreSQL test 180_ecpg.t ### 429s 1..14 429s ok 1 - ecpg test.pgc 429s ok 2 - ecpg processing 429s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 429s ok 4 - compiling ecpg output 436s ok 5 - pg_virtualenv /tmp/tmp.yINvDiHUpi/test 436s ok 6 - test program runs and gives correct output 436s # Cleanup 436s ok 7 - Cleanup: No clusters left behind 436s ok 8 - No postgres processes left behind 436s ok 9 - No files in /etc/postgresql left behind 436s ok 10 - No files in /var/lib/postgresql left behind 436s ok 11 - No files in /var/run/postgresql left behind 436s ok 12 - No files in /var/log/postgresql left behind 436s ok 13 - PostgreSQL TCP ports are closed 436s ok 14 - Next free port is 5432 436s ### End test 180_ecpg.t ### 436s 436s ### PostgreSQL test 190_pg_buildext.t ### 436s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 436s 1..1 436s ### End test 190_pg_buildext.t ### 436s 436s ### PostgreSQL test 200_maintscripts.t ### 436s 1..15 436s # We are running systemd 439s ok 1 - pg_createcluster 18 main --start 439s ok 2 - postmaster PID is 23897 440s ok 3 - apt-get update -q 440s # postgresql-common: 440s # Installed: 282ubuntu1 440s # Candidate: 282ubuntu1 440s # Version table: 440s # *** 282ubuntu1 500 440s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 440s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 440s # 100 /var/lib/dpkg/status 442s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 442s # postgresql-common: 442s # Installed: 282ubuntu1 442s # Candidate: 282ubuntu1 442s # Version table: 442s # *** 282ubuntu1 500 442s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 442s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 442s # 100 /var/lib/dpkg/status 442s ok 5 - postmaster PID is 23897 442s ok 6 - postmaster was not restarted 443s ok 7 - pg_dropcluster 18 main --stop 443s # Cleanup 443s ok 8 - Cleanup: No clusters left behind 443s ok 9 - No postgres processes left behind 443s ok 10 - No files in /etc/postgresql left behind 443s ok 11 - No files in /var/lib/postgresql left behind 443s ok 12 - No files in /var/run/postgresql left behind 443s ok 13 - No files in /var/log/postgresql left behind 443s ok 14 - PostgreSQL TCP ports are closed 443s ok 15 - Next free port is 5432 443s ### End test 200_maintscripts.t ### 443s 443s autopkgtest [22:13:47]: test run-testsuite: -----------------------] 444s autopkgtest [22:13:48]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 444s run-testsuite PASS 444s autopkgtest [22:13:48]: test installcheck: preparing testbed 451s Creating nova instance adt-resolute-amd64-postgresql-18-20251105-220624-juju-7f2275-prod-proposed-migration-environment-15-50d60b98-6e3f-4097-9e2d-9cd438e99714 from image adt/ubuntu-resolute-amd64-server-20251105.img (UUID eb17d881-e071-44a1-b6a3-2a1b60703e11)... 485s autopkgtest [22:14:29]: testbed dpkg architecture: amd64 485s autopkgtest [22:14:29]: testbed apt version: 3.1.11 485s autopkgtest [22:14:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 485s autopkgtest [22:14:29]: testbed release detected to be: resolute 486s autopkgtest [22:14:30]: updating testbed package index (apt update) 486s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 486s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 486s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 486s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 486s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [857 kB] 487s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [74.3 kB] 487s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 487s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.4 kB] 487s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [78.2 kB] 487s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [117 kB] 487s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3036 B] 487s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.6 kB] 487s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [3744 B] 487s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 487s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [497 kB] 487s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [222 kB] 487s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [16.2 kB] 487s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [12.9 kB] 487s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [5984 B] 487s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [672 B] 488s Fetched 2073 kB in 1s (2374 kB/s) 488s Reading package lists... 489s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 489s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 489s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 489s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 489s Reading package lists... 489s Reading package lists... 489s Building dependency tree... 489s Reading state information... 489s Calculating upgrade... 490s The following packages will be upgraded: 490s bash iproute2 liblzma5 libnss-systemd libpam-systemd libsystemd-shared 490s libsystemd0 libtracefs1 libudev1 libzstd1 systemd systemd-cryptsetup 490s systemd-resolved systemd-sysv udev xz-utils zstd 490s 17 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 490s Need to get 12.2 MB of archives. 490s After this operation, 1203 kB of additional disk space will be used. 490s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 bash amd64 5.3-1ubuntu1 [859 kB] 490s Get:2 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd0 amd64 258.1-2ubuntu1 [540 kB] 490s Get:3 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-sysv amd64 258.1-2ubuntu1 [9250 B] 490s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-resolved amd64 258.1-2ubuntu1 [343 kB] 490s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libnss-systemd amd64 258.1-2ubuntu1 [183 kB] 490s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libpam-systemd amd64 258.1-2ubuntu1 [271 kB] 490s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd-shared amd64 258.1-2ubuntu1 [2392 kB] 491s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd amd64 258.1-2ubuntu1 [3085 kB] 491s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-cryptsetup amd64 258.1-2ubuntu1 [123 kB] 491s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 udev amd64 258.1-2ubuntu1 [1474 kB] 492s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libudev1 amd64 258.1-2ubuntu1 [212 kB] 492s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma5 amd64 5.8.1-2 [144 kB] 492s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libzstd1 amd64 1.5.7+dfsg-2 [308 kB] 492s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 iproute2 amd64 6.16.0-1ubuntu3 [1157 kB] 492s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libtracefs1 amd64 1.8.2-1ubuntu1 [68.0 kB] 492s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 xz-utils amd64 5.8.1-2 [348 kB] 492s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 zstd amd64 1.5.7+dfsg-2 [672 kB] 492s dpkg-preconfigure: unable to re-open stdin: No such file or directory 492s Fetched 12.2 MB in 2s (5541 kB/s) 492s (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 ... 83325 files and directories currently installed.) 492s Preparing to unpack .../bash_5.3-1ubuntu1_amd64.deb ... 492s Unpacking bash (5.3-1ubuntu1) over (5.2.37-2ubuntu5) ... 492s Setting up bash (5.3-1ubuntu1) ... 492s Installing new version of config file /etc/bash.bashrc ... 492s update-alternatives: using /usr/share/man/man7/bash-builtins.7.gz to provide /usr/share/man/man7/builtins.7.gz (builtins.7.gz) in auto mode 492s (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 ... 83325 files and directories currently installed.) 492s Preparing to unpack .../libsystemd0_258.1-2ubuntu1_amd64.deb ... 492s Unpacking libsystemd0:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 492s Setting up libsystemd0:amd64 (258.1-2ubuntu1) ... 492s (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 ... 83325 files and directories currently installed.) 492s Preparing to unpack .../systemd-sysv_258.1-2ubuntu1_amd64.deb ... 492s Unpacking systemd-sysv (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 492s Preparing to unpack .../systemd-resolved_258.1-2ubuntu1_amd64.deb ... 492s Unpacking systemd-resolved (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 492s Preparing to unpack .../libnss-systemd_258.1-2ubuntu1_amd64.deb ... 492s Unpacking libnss-systemd:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 492s Preparing to unpack .../libpam-systemd_258.1-2ubuntu1_amd64.deb ... 492s Unpacking libpam-systemd:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 492s Preparing to unpack .../libsystemd-shared_258.1-2ubuntu1_amd64.deb ... 492s Unpacking libsystemd-shared:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 493s Setting up libsystemd-shared:amd64 (258.1-2ubuntu1) ... 493s (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 ... 83324 files and directories currently installed.) 493s Preparing to unpack .../systemd_258.1-2ubuntu1_amd64.deb ... 493s Unpacking systemd (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 493s Preparing to unpack .../systemd-cryptsetup_258.1-2ubuntu1_amd64.deb ... 493s Unpacking systemd-cryptsetup (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 493s Preparing to unpack .../udev_258.1-2ubuntu1_amd64.deb ... 493s Unpacking udev (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 493s Preparing to unpack .../libudev1_258.1-2ubuntu1_amd64.deb ... 493s Unpacking libudev1:amd64 (258.1-2ubuntu1) over (257.9-0ubuntu2) ... 493s Setting up libudev1:amd64 (258.1-2ubuntu1) ... 493s (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 ... 83382 files and directories currently installed.) 493s Preparing to unpack .../liblzma5_5.8.1-2_amd64.deb ... 493s Unpacking liblzma5:amd64 (5.8.1-2) over (5.8.1-1build2) ... 493s Setting up liblzma5:amd64 (5.8.1-2) ... 493s (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 ... 83382 files and directories currently installed.) 493s Preparing to unpack .../libzstd1_1.5.7+dfsg-2_amd64.deb ... 493s Unpacking libzstd1:amd64 (1.5.7+dfsg-2) over (1.5.7+dfsg-1build2) ... 493s Setting up libzstd1:amd64 (1.5.7+dfsg-2) ... 493s (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 ... 83382 files and directories currently installed.) 493s Preparing to unpack .../iproute2_6.16.0-1ubuntu3_amd64.deb ... 493s Unpacking iproute2 (6.16.0-1ubuntu3) over (6.16.0-1ubuntu2) ... 493s Preparing to unpack .../libtracefs1_1.8.2-1ubuntu1_amd64.deb ... 493s Unpacking libtracefs1:amd64 (1.8.2-1ubuntu1) over (1.8.1-1ubuntu1) ... 493s Preparing to unpack .../xz-utils_5.8.1-2_amd64.deb ... 493s Unpacking xz-utils (5.8.1-2) over (5.8.1-1build2) ... 493s Preparing to unpack .../zstd_1.5.7+dfsg-2_amd64.deb ... 493s Unpacking zstd (1.5.7+dfsg-2) over (1.5.7+dfsg-1build2) ... 493s Setting up iproute2 (6.16.0-1ubuntu3) ... 493s Setting up systemd (258.1-2ubuntu1) ... 493s Installing new version of config file /etc/systemd/logind.conf ... 493s Installing new version of config file /etc/systemd/networkd.conf ... 493s Installing new version of config file /etc/systemd/system.conf ... 493s Installing new version of config file /etc/systemd/user.conf ... 493s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 493s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 494s Setting up systemd-cryptsetup (258.1-2ubuntu1) ... 494s Setting up xz-utils (5.8.1-2) ... 494s Setting up udev (258.1-2ubuntu1) ... 495s Setting up libtracefs1:amd64 (1.8.2-1ubuntu1) ... 495s Setting up zstd (1.5.7+dfsg-2) ... 495s Setting up systemd-resolved (258.1-2ubuntu1) ... 495s Installing new version of config file /etc/systemd/resolved.conf ... 495s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-monitor.socket' → '/usr/lib/systemd/system/systemd-resolved-monitor.socket'. 495s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-varlink.socket' → '/usr/lib/systemd/system/systemd-resolved-varlink.socket'. 495s Could not execute systemctl: at /usr/bin/deb-systemd-invoke line 148. 495s Setting up systemd-sysv (258.1-2ubuntu1) ... 495s Setting up libnss-systemd:amd64 (258.1-2ubuntu1) ... 495s Setting up libpam-systemd:amd64 (258.1-2ubuntu1) ... 495s Processing triggers for install-info (7.2-5) ... 495s Processing triggers for initramfs-tools (0.150ubuntu4) ... 495s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 501s Processing triggers for libc-bin (2.42-0ubuntu3) ... 501s Processing triggers for man-db (2.13.1-1) ... 502s Processing triggers for dbus (1.16.2-2ubuntu2) ... 502s Processing triggers for shared-mime-info (2.4-5build2) ... 503s Processing triggers for procps (2:4.0.4-8ubuntu3) ... 503s Processing triggers for debianutils (5.23.2) ... 503s autopkgtest [22:14:47]: upgrading testbed (apt dist-upgrade and autopurge) 503s Reading package lists... 503s Building dependency tree... 503s Reading state information... 503s Calculating upgrade... 503s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 503s Reading package lists... 504s Building dependency tree... 504s Reading state information... 504s Solving dependencies... 504s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 504s autopkgtest [22:14:48]: rebooting testbed after setup commands that affected boot 532s Reading package lists... 533s Building dependency tree... 533s Reading state information... 533s Solving dependencies... 533s The following NEW packages will be installed: 533s build-essential clang-21 cpp cpp-15 cpp-15-x86-64-linux-gnu 533s cpp-x86-64-linux-gnu g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu 533s gcc gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 533s libclang-common-21-dev libclang-cpp21 libclang1-21 libecpg-compat3 533s libecpg-dev libecpg6 libffi-dev libgc1 libgcc-15-dev libgomp1 libhwasan0 533s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl libllvm21 533s liblsan0 liblzma-dev libmpc3 libncurses-dev libobjc-15-dev libobjc4 libpfm4 533s libpgtypes3 libpq-dev libpq-oauth libpq5 libquadmath0 libssl-dev 533s libstdc++-15-dev libtcl8.6 libtsan2 libubsan1 liburing2 libxml2-dev 533s libxslt1.1 llvm-21 llvm-21-dev llvm-21-linker-tools llvm-21-runtime 533s llvm-21-tools postgresql-18 postgresql-18-jit postgresql-client-18 533s postgresql-client-common postgresql-common postgresql-common-dev 533s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 533s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert tzdata-legacy 533s zlib1g-dev 533s 0 upgraded, 72 newly installed, 0 to remove and 0 not upgraded. 533s Need to get 231 MB of archives. 533s After this operation, 1110 MB of additional disk space will be used. 533s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 533s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 533s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 533s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20250809.0-1 [94.4 kB] 533s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 533s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 533s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 533s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 533s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-2 [54.8 kB] 533s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [12.9 MB] 534s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-7ubuntu1 [1026 B] 534s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 534s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 534s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-7ubuntu1 [47.4 kB] 534s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-7ubuntu1 [151 kB] 534s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-7ubuntu1 [29.7 kB] 534s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-7ubuntu1 [3071 kB] 534s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-7ubuntu1 [1360 kB] 534s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-7ubuntu1 [2757 kB] 534s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-7ubuntu1 [1210 kB] 534s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-7ubuntu1 [1685 kB] 534s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-7ubuntu1 [153 kB] 534s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-7ubuntu1 [2864 kB] 534s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [25.4 MB] 534s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-7ubuntu1 [524 kB] 534s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 534s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 535s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-7ubuntu1 [2573 kB] 535s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-7ubuntu1 [14.4 MB] 535s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-7ubuntu1 [23.7 kB] 535s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 535s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 535s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 535s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 535s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 535s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 535s Get:37 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-7ubuntu1 [47.8 kB] 535s Get:38 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-7ubuntu1 [196 kB] 535s Get:39 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 536s Get:40 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 536s Get:41 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 536s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 536s Get:43 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.0-1 [41.7 kB] 536s Get:44 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.0-1 [277 kB] 536s Get:45 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.0-1 [59.6 kB] 536s Get:46 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.0-1 [12.5 kB] 536s Get:47 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 536s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.0-1 [174 kB] 536s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.0-1 [281 kB] 536s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 536s Get:51 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.0-1 [34.4 kB] 536s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 536s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 536s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-2 [179 kB] 536s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 536s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2build1 [725 kB] 536s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 536s Get:58 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 536s Get:59 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 536s Get:60 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 537s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 537s Get:62 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 537s Get:63 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 537s Get:64 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.0-1 [2219 kB] 537s Get:65 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.0-1 [8211 kB] 538s Get:66 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.0-1 [10.3 MB] 538s Get:67 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.0-1 [2176 kB] 538s Get:68 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.0-1 [71.2 kB] 538s Get:69 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.0-1 [97.5 kB] 538s Get:70 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.0-1 [42.0 kB] 538s Get:71 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.0-1 [1458 kB] 538s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 tzdata-legacy all 2025b-5ubuntu1 [99.3 kB] 538s Preconfiguring packages ... 538s Fetched 231 MB in 5s (45.6 MB/s) 538s Selecting previously unselected package libjson-perl. 538s (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 ... 83382 files and directories currently installed.) 538s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 538s Unpacking libjson-perl (4.10000-1) ... 538s Selecting previously unselected package postgresql-client-common. 538s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 538s Unpacking postgresql-client-common (282ubuntu1) ... 538s Selecting previously unselected package libio-pty-perl. 538s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 538s Unpacking libio-pty-perl (1:1.20-1build3) ... 538s Selecting previously unselected package libipc-run-perl. 538s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 538s Unpacking libipc-run-perl (20250809.0-1) ... 538s Selecting previously unselected package postgresql-common-dev. 538s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 538s Unpacking postgresql-common-dev (282ubuntu1) ... 538s Selecting previously unselected package ssl-cert. 538s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 538s Unpacking ssl-cert (1.1.3ubuntu1) ... 538s Selecting previously unselected package postgresql-common. 538s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 538s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 538s Unpacking postgresql-common (282ubuntu1) ... 538s Selecting previously unselected package libisl23:amd64. 538s Preparing to unpack .../07-libisl23_0.27-1_amd64.deb ... 538s Unpacking libisl23:amd64 (0.27-1) ... 538s Selecting previously unselected package libmpc3:amd64. 538s Preparing to unpack .../08-libmpc3_1.3.1-2_amd64.deb ... 538s Unpacking libmpc3:amd64 (1.3.1-2) ... 538s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 538s Preparing to unpack .../09-cpp-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 538s Selecting previously unselected package cpp-15. 538s Preparing to unpack .../10-cpp-15_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 538s Selecting previously unselected package cpp-x86-64-linux-gnu. 538s Preparing to unpack .../11-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 538s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 538s Selecting previously unselected package cpp. 538s Preparing to unpack .../12-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 538s Unpacking cpp (4:15.2.0-4ubuntu1) ... 538s Selecting previously unselected package libcc1-0:amd64. 538s Preparing to unpack .../13-libcc1-0_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking libcc1-0:amd64 (15.2.0-7ubuntu1) ... 538s Selecting previously unselected package libgomp1:amd64. 538s Preparing to unpack .../14-libgomp1_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking libgomp1:amd64 (15.2.0-7ubuntu1) ... 538s Selecting previously unselected package libitm1:amd64. 538s Preparing to unpack .../15-libitm1_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking libitm1:amd64 (15.2.0-7ubuntu1) ... 538s Selecting previously unselected package libasan8:amd64. 538s Preparing to unpack .../16-libasan8_15.2.0-7ubuntu1_amd64.deb ... 538s Unpacking libasan8:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package liblsan0:amd64. 539s Preparing to unpack .../17-liblsan0_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking liblsan0:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package libtsan2:amd64. 539s Preparing to unpack .../18-libtsan2_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libtsan2:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package libubsan1:amd64. 539s Preparing to unpack .../19-libubsan1_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libubsan1:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package libhwasan0:amd64. 539s Preparing to unpack .../20-libhwasan0_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libhwasan0:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package libquadmath0:amd64. 539s Preparing to unpack .../21-libquadmath0_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libquadmath0:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package libgcc-15-dev:amd64. 539s Preparing to unpack .../22-libgcc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 539s Preparing to unpack .../23-gcc-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package gcc-15. 539s Preparing to unpack .../24-gcc-15_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package gcc-x86-64-linux-gnu. 539s Preparing to unpack .../25-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 539s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 539s Selecting previously unselected package gcc. 539s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 539s Unpacking gcc (4:15.2.0-4ubuntu1) ... 539s Selecting previously unselected package libstdc++-15-dev:amd64. 539s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package g++-15-x86-64-linux-gnu. 539s Preparing to unpack .../28-g++-15-x86-64-linux-gnu_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package g++-15. 539s Preparing to unpack .../29-g++-15_15.2.0-7ubuntu1_amd64.deb ... 539s Unpacking g++-15 (15.2.0-7ubuntu1) ... 539s Selecting previously unselected package g++-x86-64-linux-gnu. 539s Preparing to unpack .../30-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 539s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 539s Selecting previously unselected package g++. 539s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 539s Unpacking g++ (4:15.2.0-4ubuntu1) ... 539s Selecting previously unselected package build-essential. 539s Preparing to unpack .../32-build-essential_12.12ubuntu1_amd64.deb ... 539s Unpacking build-essential (12.12ubuntu1) ... 539s Selecting previously unselected package libllvm21:amd64. 539s Preparing to unpack .../33-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 539s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libclang-cpp21. 540s Preparing to unpack .../34-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libgc1:amd64. 540s Preparing to unpack .../35-libgc1_1%3a8.2.10-1_amd64.deb ... 540s Unpacking libgc1:amd64 (1:8.2.10-1) ... 540s Selecting previously unselected package libobjc4:amd64. 540s Preparing to unpack .../36-libobjc4_15.2.0-7ubuntu1_amd64.deb ... 540s Unpacking libobjc4:amd64 (15.2.0-7ubuntu1) ... 540s Selecting previously unselected package libobjc-15-dev:amd64. 540s Preparing to unpack .../37-libobjc-15-dev_15.2.0-7ubuntu1_amd64.deb ... 540s Unpacking libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 540s Selecting previously unselected package libclang-common-21-dev:amd64. 540s Preparing to unpack .../38-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package llvm-21-linker-tools. 540s Preparing to unpack .../39-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libclang1-21. 540s Preparing to unpack .../40-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package clang-21. 540s Preparing to unpack .../41-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libpgtypes3:amd64. 540s Preparing to unpack .../42-libpgtypes3_18.0-1_amd64.deb ... 540s Unpacking libpgtypes3:amd64 (18.0-1) ... 540s Selecting previously unselected package libpq5:amd64. 540s Preparing to unpack .../43-libpq5_18.0-1_amd64.deb ... 540s Unpacking libpq5:amd64 (18.0-1) ... 540s Selecting previously unselected package libecpg6:amd64. 540s Preparing to unpack .../44-libecpg6_18.0-1_amd64.deb ... 540s Unpacking libecpg6:amd64 (18.0-1) ... 540s Selecting previously unselected package libecpg-compat3:amd64. 540s Preparing to unpack .../45-libecpg-compat3_18.0-1_amd64.deb ... 540s Unpacking libecpg-compat3:amd64 (18.0-1) ... 540s Selecting previously unselected package libssl-dev:amd64. 540s Preparing to unpack .../46-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 540s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 540s Selecting previously unselected package libpq-dev. 540s Preparing to unpack .../47-libpq-dev_18.0-1_amd64.deb ... 540s Unpacking libpq-dev (18.0-1) ... 540s Selecting previously unselected package libecpg-dev. 540s Preparing to unpack .../48-libecpg-dev_18.0-1_amd64.deb ... 540s Unpacking libecpg-dev (18.0-1) ... 540s Selecting previously unselected package libncurses-dev:amd64. 540s Preparing to unpack .../49-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 540s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 540s Selecting previously unselected package libpq-oauth:amd64. 540s Preparing to unpack .../50-libpq-oauth_18.0-1_amd64.deb ... 540s Unpacking libpq-oauth:amd64 (18.0-1) ... 540s Selecting previously unselected package libtcl8.6:amd64. 540s Preparing to unpack .../51-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 540s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 540s Selecting previously unselected package liburing2:amd64. 540s Preparing to unpack .../52-liburing2_2.11-1_amd64.deb ... 540s Unpacking liburing2:amd64 (2.11-1) ... 540s Selecting previously unselected package liblzma-dev:amd64. 540s Preparing to unpack .../53-liblzma-dev_5.8.1-2_amd64.deb ... 540s Unpacking liblzma-dev:amd64 (5.8.1-2) ... 540s Selecting previously unselected package zlib1g-dev:amd64. 540s Preparing to unpack .../54-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 540s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 540s Selecting previously unselected package libxml2-dev:amd64. 540s Preparing to unpack .../55-libxml2-dev_2.14.5+dfsg-0.2build1_amd64.deb ... 540s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 540s Selecting previously unselected package libxslt1.1:amd64. 540s Preparing to unpack .../56-libxslt1.1_1.1.43-0.3_amd64.deb ... 540s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 540s Selecting previously unselected package llvm-21-runtime. 540s Preparing to unpack .../57-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libpfm4:amd64. 540s Preparing to unpack .../58-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 540s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 540s Selecting previously unselected package llvm-21. 540s Preparing to unpack .../59-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package libffi-dev:amd64. 540s Preparing to unpack .../60-libffi-dev_3.5.2-2_amd64.deb ... 540s Unpacking libffi-dev:amd64 (3.5.2-2) ... 540s Selecting previously unselected package llvm-21-tools. 540s Preparing to unpack .../61-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 540s Selecting previously unselected package llvm-21-dev. 540s Preparing to unpack .../62-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 540s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 541s Selecting previously unselected package postgresql-client-18. 541s Preparing to unpack .../63-postgresql-client-18_18.0-1_amd64.deb ... 541s Unpacking postgresql-client-18 (18.0-1) ... 541s Selecting previously unselected package postgresql-18. 541s Preparing to unpack .../64-postgresql-18_18.0-1_amd64.deb ... 541s Unpacking postgresql-18 (18.0-1) ... 542s Selecting previously unselected package postgresql-18-jit. 542s Preparing to unpack .../65-postgresql-18-jit_18.0-1_amd64.deb ... 542s Unpacking postgresql-18-jit (18.0-1) ... 542s Selecting previously unselected package postgresql-doc-18. 542s Preparing to unpack .../66-postgresql-doc-18_18.0-1_all.deb ... 542s Unpacking postgresql-doc-18 (18.0-1) ... 542s Selecting previously unselected package postgresql-plperl-18. 542s Preparing to unpack .../67-postgresql-plperl-18_18.0-1_amd64.deb ... 542s Unpacking postgresql-plperl-18 (18.0-1) ... 542s Selecting previously unselected package postgresql-plpython3-18. 542s Preparing to unpack .../68-postgresql-plpython3-18_18.0-1_amd64.deb ... 542s Unpacking postgresql-plpython3-18 (18.0-1) ... 542s Selecting previously unselected package postgresql-pltcl-18. 542s Preparing to unpack .../69-postgresql-pltcl-18_18.0-1_amd64.deb ... 542s Unpacking postgresql-pltcl-18 (18.0-1) ... 542s Selecting previously unselected package postgresql-server-dev-18. 542s Preparing to unpack .../70-postgresql-server-dev-18_18.0-1_amd64.deb ... 542s Unpacking postgresql-server-dev-18 (18.0-1) ... 542s Selecting previously unselected package tzdata-legacy. 542s Preparing to unpack .../71-tzdata-legacy_2025b-5ubuntu1_all.deb ... 542s Unpacking tzdata-legacy (2025b-5ubuntu1) ... 542s Setting up postgresql-client-common (282ubuntu1) ... 542s Setting up libpgtypes3:amd64 (18.0-1) ... 542s Setting up postgresql-doc-18 (18.0-1) ... 542s update-alternatives: using /usr/share/postgresql/18/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 542s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 542s Setting up libio-pty-perl (1:1.20-1build3) ... 542s Setting up libpq5:amd64 (18.0-1) ... 542s Setting up libgomp1:amd64 (15.2.0-7ubuntu1) ... 542s Setting up libffi-dev:amd64 (3.5.2-2) ... 542s Setting up tzdata-legacy (2025b-5ubuntu1) ... 542s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 542s Setting up ssl-cert (1.1.3ubuntu1) ... 542s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 542s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 542s Setting up libquadmath0:amd64 (15.2.0-7ubuntu1) ... 542s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 542s Setting up libmpc3:amd64 (1.3.1-2) ... 542s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 542s Setting up libipc-run-perl (20250809.0-1) ... 542s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 542s Setting up libgc1:amd64 (1:8.2.10-1) ... 542s Setting up liblzma-dev:amd64 (5.8.1-2) ... 542s Setting up libubsan1:amd64 (15.2.0-7ubuntu1) ... 542s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 542s Setting up libhwasan0:amd64 (15.2.0-7ubuntu1) ... 542s Setting up libasan8:amd64 (15.2.0-7ubuntu1) ... 542s Setting up libjson-perl (4.10000-1) ... 542s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 542s Setting up libecpg6:amd64 (18.0-1) ... 542s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 542s Setting up libtsan2:amd64 (15.2.0-7ubuntu1) ... 543s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 543s Setting up liburing2:amd64 (2.11-1) ... 543s Setting up libisl23:amd64 (0.27-1) ... 543s Setting up libcc1-0:amd64 (15.2.0-7ubuntu1) ... 543s Setting up liblsan0:amd64 (15.2.0-7ubuntu1) ... 543s Setting up libitm1:amd64 (15.2.0-7ubuntu1) ... 543s Setting up postgresql-common-dev (282ubuntu1) ... 543s Setting up libgcc-15-dev:amd64 (15.2.0-7ubuntu1) ... 543s Setting up libecpg-compat3:amd64 (18.0-1) ... 543s Setting up postgresql-client-18 (18.0-1) ... 543s update-alternatives: using /usr/share/postgresql/18/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 543s Setting up libpq-oauth:amd64 (18.0-1) ... 543s Setting up libpq-dev (18.0-1) ... 543s Setting up libobjc4:amd64 (15.2.0-7ubuntu1) ... 543s Setting up cpp-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 543s Setting up libecpg-dev (18.0-1) ... 543s Setting up gcc-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 543s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2build1) ... 543s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 543s Setting up libstdc++-15-dev:amd64 (15.2.0-7ubuntu1) ... 543s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 543s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 543s Setting up postgresql-common (282ubuntu1) ... 543s Creating config file /etc/postgresql-common/createcluster.conf with new version 543s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 543s Removing obsolete dictionary files: 543s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 544s Setting up cpp-15 (15.2.0-7ubuntu1) ... 544s Setting up libobjc-15-dev:amd64 (15.2.0-7ubuntu1) ... 544s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 544s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 544s Setting up g++-15-x86-64-linux-gnu (15.2.0-7ubuntu1) ... 544s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 544s Setting up postgresql-18 (18.0-1) ... 544s Creating new PostgreSQL cluster 18/main ... 544s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 544s The files belonging to this database system will be owned by user "postgres". 544s This user must also own the server process. 544s 544s The database cluster will be initialized with locale "C.UTF-8". 544s The default database encoding has accordingly been set to "UTF8". 544s The default text search configuration will be set to "english". 544s 544s Data page checksums are enabled. 544s 544s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 544s creating subdirectories ... ok 544s selecting dynamic shared memory implementation ... posix 544s selecting default "max_connections" ... 100 544s selecting default "shared_buffers" ... 128MB 544s selecting default time zone ... Etc/UTC 544s creating configuration files ... ok 544s running bootstrap script ... ok 544s performing post-bootstrap initialization ... ok 545s syncing data to disk ... ok 547s Setting up postgresql-18-jit (18.0-1) ... 547s Setting up gcc-15 (15.2.0-7ubuntu1) ... 547s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 547s Setting up postgresql-plpython3-18 (18.0-1) ... 547s Setting up cpp (4:15.2.0-4ubuntu1) ... 547s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 547s Setting up postgresql-plperl-18 (18.0-1) ... 547s Setting up g++-15 (15.2.0-7ubuntu1) ... 547s Setting up postgresql-pltcl-18 (18.0-1) ... 547s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 547s Setting up postgresql-server-dev-18 (18.0-1) ... 547s Setting up gcc (4:15.2.0-4ubuntu1) ... 547s Setting up g++ (4:15.2.0-4ubuntu1) ... 547s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 547s Setting up build-essential (12.12ubuntu1) ... 547s Processing triggers for libc-bin (2.42-0ubuntu3) ... 547s Processing triggers for systemd (258.1-2ubuntu1) ... 547s Processing triggers for man-db (2.13.1-1) ... 548s Processing triggers for install-info (7.2-5) ... 554s autopkgtest [22:15:38]: test installcheck: [----------------------- 555s + dpkg-parsechangelog -SSource 555s + SOURCE=postgresql-18 555s + MAJOR=18 555s + top_srcdir=/tmp/autopkgtest.FbZ5vV/build.PpX/src 555s + cd src/test/regress 555s + make -f /tmp/autopkgtest.FbZ5vV/build.PpX/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config with_llvm=no 555s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -Wmissing-variable-declarations -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.FbZ5vV/build.PpX/src/debian/tests/ -I/usr/include/postgresql/18/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 555s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -Wmissing-variable-declarations -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/x86_64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -fvisibility=hidden 555s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.FbZ5vV/build.PpX/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyencoding.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated_stored.sql sql/generated_virtual.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/maintain_every.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numa.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/predicate.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/psql_pipeline.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/sqljson_jsontable.sql sql/sqljson_queryfuncs.sql sql/stats.sql sql/stats_ext.sql sql/stats_import.sql sql/strings.sql sql/subscription.sql sql/subselect.sql sql/sysviews.sql sql/tablesample.sql sql/tablespace.sql sql/temp.sql sql/test_setup.sql sql/text.sql sql/tid.sql sql/tidrangescan.sql sql/tidscan.sql sql/time.sql sql/timestamp.sql sql/timestamptz.sql sql/timetz.sql sql/transactions.sql sql/triggers.sql sql/truncate.sql sql/tsdicts.sql sql/tsearch.sql sql/tsrf.sql sql/tstypes.sql sql/tuplesort.sql sql/txid.sql sql/type_sanity.sql sql/typed_table.sql sql/unicode.sql sql/union.sql sql/updatable_views.sql sql/update.sql sql/uuid.sql sql/vacuum.sql sql/vacuum_parallel.sql sql/varchar.sql sql/window.sql sql/with.sql sql/without_overlaps.sql sql/write_parallel.sql sql/xid.sql sql/xml.sql sql/xmlmap.sql expected/advisory_lock.out expected/aggregates.out expected/alter_generic.out expected/alter_operator.out expected/alter_table.out expected/amutils.out expected/arrays.out expected/async.out expected/bit.out expected/bitmapops.out expected/boolean.out expected/box.out expected/brin.out expected/brin_bloom.out expected/brin_multi.out expected/btree_index.out expected/case.out expected/char.out expected/char_1.out expected/char_2.out expected/circle.out expected/cluster.out expected/collate.icu.utf8.out expected/collate.icu.utf8_1.out expected/collate.linux.utf8.out expected/collate.linux.utf8_1.out expected/collate.out expected/collate.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyencoding.out expected/copyencoding_1.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated_stored.out expected/generated_virtual.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/maintain_every.out expected/matview.out expected/md5.out expected/md5_1.out expected/md5_2.out expected/memoize.out expected/merge.out expected/misc.out expected/misc_functions.out expected/misc_sanity.out expected/money.out expected/multirangetypes.out expected/mvcc.out expected/name.out expected/namespace.out expected/numa.out expected/numa_1.out expected/numeric.out expected/numeric_big.out expected/numerology.out expected/object_address.out expected/oid.out expected/oidjoins.out expected/opr_sanity.out expected/partition_aggregate.out expected/partition_info.out expected/partition_join.out expected/partition_prune.out expected/password.out expected/password_1.out expected/password_2.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/psql_pipeline.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/stats_import.out expected/strings.out expected/subscription.out expected/subselect.out expected/sysviews.out expected/tablesample.out expected/tablespace.out expected/temp.out expected/test_setup.out expected/text.out expected/tid.out expected/tidrangescan.out expected/tidscan.out expected/time.out expected/timestamp.out expected/timestamptz.out expected/timetz.out expected/transactions.out expected/triggers.out expected/truncate.out expected/tsdicts.out expected/tsearch.out expected/tsrf.out expected/tstypes.out expected/tuplesort.out expected/txid.out expected/type_sanity.out expected/typed_table.out expected/unicode.out expected/unicode_1.out expected/union.out expected/updatable_views.out expected/update.out expected/uuid.out expected/vacuum.out expected/vacuum_parallel.out expected/varchar.out expected/varchar_1.out expected/varchar_2.out expected/window.out expected/with.out expected/without_overlaps.out expected/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 555s + id -u 555s + [ 1000 = 0 ] 555s + SU=sh 555s + sh 555s + mktemp -d /tmp/regress.XXXXXX 555s + OUTPUT=/tmp/regress.IzxbVc 555s + trap rm -rf /tmp/regress.IzxbVc EXIT 555s + pg_virtualenv -v 18 /usr/lib/postgresql/18/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.IzxbVc --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 555s Creating new PostgreSQL cluster 18/regress ... 558s # using postmaster on localhost, port 5433 558s ok 1 - test_setup 110 ms 558s # parallel group (20 tests): oid varchar char txid name int2 text money pg_lsn int4 regproc float8 float4 int8 uuid enum boolean bit rangetypes numeric 558s ok 2 + boolean 260 ms 558s ok 3 + char 107 ms 558s ok 4 + name 115 ms 558s ok 5 + varchar 101 ms 558s ok 6 + text 136 ms 558s ok 7 + int2 133 ms 558s ok 8 + int4 148 ms 558s ok 9 + int8 196 ms 558s ok 10 + oid 88 ms 558s ok 11 + float4 173 ms 558s ok 12 + float8 159 ms 558s ok 13 + bit 330 ms 558s ok 14 + numeric 383 ms 558s ok 15 + txid 107 ms 558s ok 16 + uuid 205 ms 558s ok 17 + enum 224 ms 558s ok 18 + money 131 ms 558s ok 19 + rangetypes 362 ms 558s ok 20 + pg_lsn 123 ms 558s ok 21 + regproc 142 ms 559s # parallel group (20 tests): md5 path macaddr macaddr8 lseg line circle time timetz numerology interval inet date strings polygon point multirangetypes box timestamp timestamptz 559s ok 22 + strings 266 ms 559s ok 23 + md5 75 ms 559s ok 24 + numerology 164 ms 559s ok 25 + point 313 ms 559s ok 26 + lseg 111 ms 559s ok 27 + line 113 ms 559s ok 28 + box 321 ms 559s ok 29 + path 89 ms 559s ok 30 + polygon 308 ms 559s ok 31 + circle 114 ms 559s ok 32 + date 192 ms 559s ok 33 + time 116 ms 559s ok 34 + timetz 138 ms 559s ok 35 + timestamp 383 ms 559s ok 36 + timestamptz 433 ms 559s ok 37 + interval 166 ms 559s ok 38 + inet 177 ms 559s ok 39 + macaddr 90 ms 559s ok 40 + macaddr8 96 ms 559s ok 41 + multirangetypes 302 ms 559s # parallel group (14 tests): unicode comments misc_sanity xid expressions mvcc tstypes type_sanity stats_import geometry opr_sanity database horology regex 559s ok 42 + geometry 307 ms 559s ok 43 + horology 392 ms 559s ok 44 + tstypes 169 ms 559s ok 45 + regex 421 ms 559s ok 46 + type_sanity 224 ms 559s ok 47 + opr_sanity 319 ms 559s ok 48 + misc_sanity 72 ms 559s ok 49 + comments 56 ms 559s ok 50 + expressions 120 ms 559s ok 51 + unicode 53 ms 559s ok 52 + xid 110 ms 559s ok 53 + mvcc 138 ms 559s ok 54 + database 358 ms 559s ok 55 + stats_import 216 ms 559s # parallel group (6 tests): copydml copyencoding copyselect copy insert_conflict insert 559s ok 56 + copy 88 ms 559s ok 57 + copyselect 46 ms 559s ok 58 + copydml 35 ms 559s ok 59 + copyencoding 38 ms 559s ok 60 + insert 190 ms 559s ok 61 + insert_conflict 106 ms 560s # parallel group (7 tests): create_function_c create_operator create_type create_schema create_misc create_procedure create_table 560s ok 62 + create_function_c 34 ms 560s ok 63 + create_misc 66 ms 560s ok 64 + create_operator 51 ms 560s ok 65 + create_procedure 70 ms 560s ok 66 + create_table 190 ms 560s ok 67 + create_type 51 ms 560s ok 68 + create_schema 59 ms 560s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 560s ok 69 + create_index 408 ms 560s ok 70 + create_index_spgist 315 ms 560s ok 71 + create_view 249 ms 560s ok 72 + index_including 147 ms 560s ok 73 + index_including_gist 202 ms 561s # parallel group (16 tests): errors create_cast hash_func roleattributes create_aggregate drop_if_exists select typed_table create_am create_function_sql infinite_recurse vacuum updatable_views constraints inherit triggers 561s ok 74 + create_aggregate 136 ms 561s ok 75 + create_function_sql 285 ms 561s ok 76 + create_cast 101 ms 561s ok 77 + constraints 760 ms 561s ok 78 + triggers 840 ms 561s ok 79 + select 183 ms 561s ok 80 + inherit 792 ms 561s ok 81 + typed_table 208 ms 561s ok 82 + vacuum 531 ms 561s ok 83 + drop_if_exists 142 ms 561s ok 84 + updatable_views 691 ms 561s ok 85 + roleattributes 124 ms 561s ok 86 + create_am 244 ms 561s ok 87 + hash_func 105 ms 561s ok 88 + errors 70 ms 561s ok 89 + infinite_recurse 315 ms 561s ok 90 - sanity_check 43 ms 562s # parallel group (20 tests): select_having delete select_distinct_on select_implicit random case namespace select_into prepared_xacts union portals transactions select_distinct arrays subselect hash_index update aggregates btree_index join 562s ok 91 + select_into 237 ms 562s ok 92 + select_distinct 492 ms 562s ok 93 + select_distinct_on 166 ms 562s ok 94 + select_implicit 172 ms 562s ok 95 + select_having 110 ms 562s ok 96 + subselect 657 ms 562s ok 97 + union 340 ms 562s ok 98 + case 198 ms 562s ok 99 + join 1223 ms 562s ok 100 + aggregates 1060 ms 562s ok 101 + transactions 386 ms 562s ok 102 + random 188 ms 562s ok 103 + portals 351 ms 562s ok 104 + arrays 574 ms 562s ok 105 + btree_index 1126 ms 562s ok 106 + hash_index 728 ms 562s ok 107 + update 782 ms 562s ok 108 + delete 122 ms 562s ok 109 + namespace 201 ms 562s ok 110 + prepared_xacts 226 ms 566s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address collate password replica_identity matview identity spgist generated_stored gist rowsecurity gin groupingsets brin join_hash privileges 566s ok 111 + brin 3367 ms 566s ok 112 + gin 1342 ms 566s ok 113 + gist 1282 ms 566s ok 114 + spgist 1067 ms 566s ok 115 + privileges 3579 ms 566s ok 116 + init_privs 82 ms 566s ok 117 + security_label 187 ms 566s ok 118 + collate 372 ms 566s ok 119 + matview 731 ms 566s ok 120 + lock 225 ms 566s ok 121 + replica_identity 449 ms 566s ok 122 + rowsecurity 1283 ms 566s ok 123 + object_address 287 ms 566s ok 124 + tablesample 187 ms 566s ok 125 + groupingsets 1394 ms 566s ok 126 + drop_operator 138 ms 566s ok 127 + password 365 ms 566s ok 128 + identity 958 ms 566s ok 129 + generated_stored 1230 ms 566s ok 130 + join_hash 3368 ms 566s # parallel group (2 tests): brin_bloom brin_multi 566s ok 131 + brin_bloom 42 ms 566s ok 132 + brin_multi 103 ms 567s # parallel group (19 tests): async dbsize tidrangescan tsrf tid tidscan collate.utf8 alter_operator create_role incremental_sort alter_generic sysviews misc_functions merge create_table_like generated_virtual without_overlaps collate.icu.utf8 misc 567s ok 133 + create_table_like 633 ms 567s ok 134 + alter_generic 335 ms 567s ok 135 + alter_operator 172 ms 567s ok 136 + misc 836 ms 567s ok 137 + async 67 ms 567s ok 138 + dbsize 80 ms 567s ok 139 + merge 616 ms 567s ok 140 + misc_functions 428 ms 567s ok 141 + sysviews 390 ms 567s ok 142 + tsrf 144 ms 567s ok 143 + tid 146 ms 567s ok 144 + tidscan 147 ms 567s ok 145 + tidrangescan 133 ms 567s ok 146 + collate.utf8 154 ms 567s ok 147 + collate.icu.utf8 822 ms 567s ok 148 + incremental_sort 301 ms 567s ok 149 + create_role 230 ms 567s ok 150 + without_overlaps 790 ms 567s ok 151 + generated_virtual 753 ms 568s # parallel group (8 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab psql_pipeline psql rules stats_ext 568s ok 152 + rules 289 ms 568s ok 153 + psql 264 ms 568s ok 154 + psql_crosstab 64 ms 568s ok 155 + psql_pipeline 75 ms 568s ok 156 + amutils 50 ms 568s ok 157 + stats_ext 780 ms 568s ok 158 + collate.linux.utf8 37 ms 568s ok 159 + collate.windows.win1252 37 ms 569s ok 160 - select_parallel 1417 ms 569s ok 161 - write_parallel 64 ms 569s ok 162 - vacuum_parallel 47 ms 569s ok 163 - maintain_every 15 ms 570s # parallel group (2 tests): subscription publication 570s ok 164 + publication 1038 ms 570s ok 165 + subscription 46 ms 571s # parallel group (17 tests): portals_p2 xmlmap advisory_lock equivclass combocid tsdicts functional_deps guc dependency select_views tsearch bitmapops window cluster indirect_toast foreign_data foreign_key 571s ok 166 + select_views 247 ms 571s ok 167 + portals_p2 107 ms 571s ok 168 + foreign_key 840 ms 571s ok 169 + cluster 520 ms 571s ok 170 + dependency 233 ms 571s ok 171 + guc 221 ms 571s ok 172 + bitmapops 458 ms 571s ok 173 + combocid 149 ms 571s ok 174 + tsearch 432 ms 571s ok 175 + tsdicts 194 ms 571s ok 176 + foreign_data 651 ms 571s ok 177 + window 488 ms 571s ok 178 + xmlmap 102 ms 571s ok 179 + functional_deps 191 ms 571s ok 180 + advisory_lock 117 ms 571s ok 181 + indirect_toast 544 ms 571s ok 182 + equivclass 129 ms 571s # parallel group (9 tests): json_encoding jsonpath_encoding jsonpath sqljson sqljson_jsontable sqljson_queryfuncs json jsonb_jsonpath jsonb 571s ok 183 + json 151 ms 571s ok 184 + jsonb 222 ms 571s ok 185 + json_encoding 50 ms 571s ok 186 + jsonpath 100 ms 571s ok 187 + jsonpath_encoding 52 ms 571s ok 188 + jsonb_jsonpath 166 ms 571s ok 189 + sqljson 113 ms 571s ok 190 + sqljson_queryfuncs 144 ms 571s ok 191 + sqljson_jsontable 135 ms 573s # parallel group (18 tests): prepare conversion limit plancache returning copy2 sequence rowtypes polymorphism truncate temp with largeobject domain rangefuncs xml plpgsql alter_table 573s ok 192 + plancache 292 ms 573s ok 193 + limit 279 ms 573s ok 194 + plpgsql 844 ms 573s ok 195 + copy2 480 ms 573s ok 196 + temp 592 ms 573s ok 197 + domain 688 ms 573s ok 198 + rangefuncs 701 ms 573s ok 199 + prepare 130 ms 573s ok 200 + conversion 260 ms 573s ok 201 + truncate 571 ms 573s ok 202 + alter_table 1231 ms 573s ok 203 + sequence 504 ms 573s ok 204 + polymorphism 558 ms 573s ok 205 + rowtypes 530 ms 573s ok 206 + returning 346 ms 573s ok 207 + largeobject 642 ms 573s ok 208 + with 637 ms 573s ok 209 + xml 805 ms 574s # parallel group (14 tests): hash_part reloptions explain partition_info predicate numa memoize compression partition_aggregate partition_join tuplesort indexing stats partition_prune 574s ok 210 + partition_join 953 ms 574s ok 211 + partition_prune 1222 ms 574s ok 212 + reloptions 170 ms 574s ok 213 + hash_part 85 ms 574s ok 214 + indexing 1076 ms 574s ok 215 + partition_aggregate 899 ms 574s ok 216 + partition_info 191 ms 574s ok 217 + tuplesort 963 ms 574s ok 218 + explain 175 ms 574s ok 219 + compression 419 ms 574s ok 220 + memoize 292 ms 574s ok 221 + stats 1075 ms 574s ok 222 + predicate 214 ms 574s ok 223 + numa 248 ms 574s # parallel group (2 tests): oidjoins event_trigger 574s ok 224 + oidjoins 111 ms 574s ok 225 + event_trigger 122 ms 574s ok 226 - event_trigger_login 27 ms 574s ok 227 - fast_default 64 ms 574s ok 228 - tablespace 177 ms 574s 1..228 574s # All 228 tests passed. 574s Dropping cluster 18/regress ... 574s + rm -rf /tmp/regress.IzxbVc 575s autopkgtest [22:15:59]: test installcheck: -----------------------] 575s installcheck PASS 575s autopkgtest [22:15:59]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 575s autopkgtest [22:15:59]: @@@@@@@@@@@@@@@@@@@@ summary 575s run-testsuite PASS 575s installcheck PASS