0s autopkgtest [08:23:20]: starting date and time: 2025-11-19 08:23:20+0000 0s autopkgtest [08:23:20]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [08:23:20]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.xknl69oh/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:systemd,src:dhcpcd --apt-upgrade postgresql-18 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=systemd/259~rc1-1ubuntu1 dhcpcd/1:10.3.0-1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-2.secgroup --name adt-resolute-amd64-postgresql-18-20251119-082320-juju-7f2275-prod-proposed-migration-environment-15-98cbe719-fe88-46d2-bfd1-aed3fa72fb0f --image adt/ubuntu-resolute-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 3s Creating nova instance adt-resolute-amd64-postgresql-18-20251119-082320-juju-7f2275-prod-proposed-migration-environment-15-98cbe719-fe88-46d2-bfd1-aed3fa72fb0f from image adt/ubuntu-resolute-amd64-server-20251119.img (UUID fc1a7209-2cef-4daf-9d3e-e01e6f7c6db2)... 64s autopkgtest [08:24:24]: testbed dpkg architecture: amd64 64s autopkgtest [08:24:24]: testbed apt version: 3.1.12 65s autopkgtest [08:24:25]: @@@@@@@@@@@@@@@@@@@@ test bed setup 65s autopkgtest [08:24:25]: testbed release detected to be: None 66s autopkgtest [08:24:26]: updating testbed package index (apt update) 66s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 66s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 66s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 66s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 67s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.8 kB] 67s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 67s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [67.3 kB] 67s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [823 kB] 67s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [96.8 kB] 67s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [138 kB] 67s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3028 B] 67s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.9 kB] 67s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [4040 B] 67s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 67s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [239 kB] 68s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [556 kB] 68s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [18.5 kB] 68s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [6880 B] 68s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [13.7 kB] 68s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [680 B] 70s Fetched 2153 kB in 2s (1086 kB/s) 71s Reading package lists... 72s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 72s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 72s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 72s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 73s Reading package lists... 73s Reading package lists... 73s Building dependency tree... 73s Reading state information... 73s Calculating upgrade... 73s The following packages will be upgraded: 73s dhcpcd-base libnss-systemd libpam-systemd libsystemd-shared libsystemd0 73s libudev1 python3-requests systemd systemd-cryptsetup systemd-resolved 73s systemd-sysv udev 74s 12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 74s Need to get 9041 kB of archives. 74s After this operation, 1782 kB of additional disk space will be used. 74s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd0 amd64 259~rc1-1ubuntu1 [542 kB] 74s Get:2 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-sysv amd64 259~rc1-1ubuntu1 [9256 B] 74s Get:3 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-resolved amd64 259~rc1-1ubuntu1 [298 kB] 74s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libnss-systemd amd64 259~rc1-1ubuntu1 [183 kB] 74s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libpam-systemd amd64 259~rc1-1ubuntu1 [272 kB] 75s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd-shared amd64 259~rc1-1ubuntu1 [2512 kB] 75s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd amd64 259~rc1-1ubuntu1 [3125 kB] 76s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-cryptsetup amd64 259~rc1-1ubuntu1 [124 kB] 76s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 udev amd64 259~rc1-1ubuntu1 [1483 kB] 76s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libudev1 amd64 259~rc1-1ubuntu1 [212 kB] 76s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 dhcpcd-base amd64 1:10.3.0-1 [228 kB] 76s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 python3-requests all 2.32.5+dfsg-1ubuntu1 [53.1 kB] 77s dpkg-preconfigure: unable to re-open stdin: No such file or directory 77s Fetched 9041 kB in 3s (2961 kB/s) 77s (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 ... 82963 files and directories currently installed.) 77s Preparing to unpack .../libsystemd0_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking libsystemd0:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 77s Setting up libsystemd0:amd64 (259~rc1-1ubuntu1) ... 77s (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 ... 82963 files and directories currently installed.) 77s Preparing to unpack .../systemd-sysv_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking systemd-sysv (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 77s Preparing to unpack .../systemd-resolved_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking systemd-resolved (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 77s Preparing to unpack .../libnss-systemd_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking libnss-systemd:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 77s Preparing to unpack .../libpam-systemd_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking libpam-systemd:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 77s Preparing to unpack .../libsystemd-shared_259~rc1-1ubuntu1_amd64.deb ... 77s Unpacking libsystemd-shared:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 78s Setting up libsystemd-shared:amd64 (259~rc1-1ubuntu1) ... 78s (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 ... 82962 files and directories currently installed.) 78s Preparing to unpack .../systemd_259~rc1-1ubuntu1_amd64.deb ... 78s Unpacking systemd (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 78s Preparing to unpack .../systemd-cryptsetup_259~rc1-1ubuntu1_amd64.deb ... 78s Unpacking systemd-cryptsetup (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 78s Preparing to unpack .../udev_259~rc1-1ubuntu1_amd64.deb ... 78s Unpacking udev (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 78s Preparing to unpack .../libudev1_259~rc1-1ubuntu1_amd64.deb ... 78s Unpacking libudev1:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 78s Setting up libudev1:amd64 (259~rc1-1ubuntu1) ... 78s (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 ... 83045 files and directories currently installed.) 78s Preparing to unpack .../dhcpcd-base_1%3a10.3.0-1_amd64.deb ... 78s Unpacking dhcpcd-base (1:10.3.0-1) over (1:10.2.4-4) ... 78s Preparing to unpack .../python3-requests_2.32.5+dfsg-1ubuntu1_all.deb ... 78s Unpacking python3-requests (2.32.5+dfsg-1ubuntu1) over (2.32.3+dfsg-5ubuntu2) ... 78s Setting up systemd (259~rc1-1ubuntu1) ... 78s Installing new version of config file /etc/systemd/journald.conf ... 78s Installing new version of config file /etc/systemd/logind.conf ... 78s Installing new version of config file /etc/systemd/networkd.conf ... 78s Installing new version of config file /etc/systemd/system.conf ... 78s Installing new version of config file /etc/systemd/user.conf ... 78s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 79s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 79s Setting up systemd-cryptsetup (259~rc1-1ubuntu1) ... 79s Setting up python3-requests (2.32.5+dfsg-1ubuntu1) ... 80s Setting up udev (259~rc1-1ubuntu1) ... 80s Setting up dhcpcd-base (1:10.3.0-1) ... 80s Installing new version of config file /etc/dhcpcd.conf ... 80s Creating group 'dhcpcd' with GID 986. 80s Setting up systemd-resolved (259~rc1-1ubuntu1) ... 80s Installing new version of config file /etc/systemd/resolved.conf ... 81s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-monitor.socket' → '/usr/lib/systemd/system/systemd-resolved-monitor.socket'. 81s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-varlink.socket' → '/usr/lib/systemd/system/systemd-resolved-varlink.socket'. 81s Could not execute systemctl: at /usr/bin/deb-systemd-invoke line 148. 81s Setting up systemd-sysv (259~rc1-1ubuntu1) ... 81s Setting up libnss-systemd:amd64 (259~rc1-1ubuntu1) ... 81s Setting up libpam-systemd:amd64 (259~rc1-1ubuntu1) ... 81s Processing triggers for libc-bin (2.42-2ubuntu2) ... 81s Processing triggers for man-db (2.13.1-1) ... 83s Processing triggers for dbus (1.16.2-2ubuntu2) ... 83s Processing triggers for shared-mime-info (2.4-5build2) ... 86s Processing triggers for procps (2:4.0.4-8ubuntu3) ... 86s Processing triggers for initramfs-tools (0.150ubuntu5) ... 86s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 93s autopkgtest [08:24:53]: upgrading testbed (apt dist-upgrade and autopurge) 93s Reading package lists... 93s Building dependency tree... 93s Reading state information... 93s Calculating upgrade... 93s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 94s Reading package lists... 94s Building dependency tree... 94s Reading state information... 94s Solving dependencies... 94s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 94s autopkgtest [08:24:54]: rebooting testbed after setup commands that affected boot 115s autopkgtest [08:25:15]: testbed running kernel: Linux 6.17.0-5-generic #5-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 22 10:00:33 UTC 2025 118s autopkgtest [08:25:18]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-18 129s Get:1 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.1-1 (dsc) [4443 B] 129s Get:2 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.1-1 (tar) [22.4 MB] 129s Get:3 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.1-1 (diff) [23.7 kB] 129s gpgv: Signature made Thu Nov 13 09:37:49 2025 UTC 129s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 129s gpgv: Can't check signature: No public key 129s dpkg-source: warning: cannot verify inline signature for ./postgresql-18_18.1-1.dsc: no acceptable signature found 134s autopkgtest [08:25:34]: testing package postgresql-18 version 18.1-1 136s autopkgtest [08:25:36]: build not needed 144s autopkgtest [08:25:44]: test run-testsuite: preparing testbed 144s Reading package lists... 144s Building dependency tree... 144s Reading state information... 144s Solving dependencies... 144s The following NEW packages will be installed: 144s autoconf automake autopoint autotools-dev build-essential clang-21 cpp 144s cpp-15 cpp-15-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 144s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 144s fakeroot g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-15 144s gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 144s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-21-dev 144s libclang-cpp21 libclang1-21 libdebhelper-perl libecpg-compat3 libecpg-dev 144s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 144s libgcc-15-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 144s libitm1 libjson-perl libllvm21 liblsan0 liblzma-dev libmpc3 libncurses-dev 144s libobjc-15-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq-oauth libpq5 144s libquadmath0 libssl-dev libstdc++-15-dev libtcl8.6 libtool libtsan2 144s libubsan1 liburing2 libxml2-dev libxslt1.1 llvm-21 llvm-21-dev 144s llvm-21-linker-tools llvm-21-runtime llvm-21-tools locales-all m4 po-debconf 144s postgresql-18 postgresql-18-jit postgresql-client-18 144s postgresql-client-common postgresql-common postgresql-common-dev 144s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 144s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert zlib1g-dev 145s 0 upgraded, 94 newly installed, 0 to remove and 0 not upgraded. 145s Need to get 247 MB of archives. 145s After this operation, 1367 MB of additional disk space will be used. 145s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 145s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 145s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 145s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20250809.0-1 [94.4 kB] 145s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 145s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 145s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 145s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 m4 amd64 1.4.20-2 [217 kB] 145s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 146s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 autotools-dev all 20240727.1 [43.4 kB] 146s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 automake all 1:1.18.1-3 [582 kB] 146s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 autopoint all 0.23.2-1 [620 kB] 146s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 146s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-2 [54.8 kB] 146s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [12.9 MB] 148s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-8ubuntu1 [1030 B] 148s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 148s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 148s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-8ubuntu1 [47.4 kB] 148s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-8ubuntu1 [151 kB] 148s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-8ubuntu1 [29.7 kB] 148s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-8ubuntu1 [3071 kB] 148s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-8ubuntu1 [1360 kB] 148s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-8ubuntu1 [2757 kB] 149s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-8ubuntu1 [1210 kB] 149s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-8ubuntu1 [1685 kB] 149s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-8ubuntu1 [153 kB] 149s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-8ubuntu1 [2864 kB] 149s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [25.4 MB] 150s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-8ubuntu1 [525 kB] 150s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 150s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 150s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-8ubuntu1 [2573 kB] 150s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [14.4 MB] 151s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-8ubuntu1 [24.1 kB] 151s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 151s Get:37 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 151s Get:38 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 151s Get:39 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 153s Get:40 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 154s Get:41 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 154s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-8ubuntu1 [47.8 kB] 154s Get:43 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-8ubuntu1 [196 kB] 154s Get:44 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 154s Get:45 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 155s Get:46 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 155s Get:47 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 155s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 155s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libtool all 2.5.4-7 [169 kB] 155s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-autoreconf all 21 [12.5 kB] 155s Get:51 http://ftpmaster.internal/ubuntu resolute/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 155s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libfile-stripnondeterminism-perl all 1.15.0-1 [20.5 kB] 155s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 dh-strip-nondeterminism all 1.15.0-1 [5090 B] 155s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 debugedit amd64 1:5.2-3 [49.9 kB] 155s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 dwz amd64 0.16-2 [115 kB] 155s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 gettext amd64 0.23.2-1 [1019 kB] 156s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 156s Get:58 http://ftpmaster.internal/ubuntu resolute/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 156s Get:59 http://ftpmaster.internal/ubuntu resolute/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 156s Get:60 http://ftpmaster.internal/ubuntu resolute/main amd64 emacsen-common all 3.0.8 [13.9 kB] 156s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 dictionaries-common all 1.30.11 [178 kB] 156s Get:62 http://ftpmaster.internal/ubuntu resolute/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 156s Get:63 http://ftpmaster.internal/ubuntu resolute/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 156s Get:64 http://ftpmaster.internal/ubuntu resolute/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 156s Get:65 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.1-1 [42.1 kB] 156s Get:66 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.1-1 [275 kB] 156s Get:67 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.1-1 [59.6 kB] 156s Get:68 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.1-1 [12.5 kB] 156s Get:69 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 156s Get:70 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.1-1 [175 kB] 156s Get:71 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.1-1 [281 kB] 156s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 156s Get:73 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.1-1 [34.4 kB] 156s Get:74 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 156s Get:75 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 156s Get:76 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-2 [179 kB] 156s Get:77 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 156s Get:78 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.15.1+dfsg-0.3 [741 kB] 156s Get:79 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 156s Get:80 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 156s Get:81 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 156s Get:82 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 158s Get:83 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 158s Get:84 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 158s Get:85 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 163s Get:86 http://ftpmaster.internal/ubuntu resolute/main amd64 locales-all amd64 2.42-2ubuntu2 [11.1 MB] 164s Get:87 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.1-1 [2215 kB] 164s Get:88 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.1-1 [8208 kB] 165s Get:89 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.1-1 [10.4 MB] 166s Get:90 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.1-1 [2180 kB] 166s Get:91 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.1-1 [71.6 kB] 166s Get:92 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.1-1 [98.0 kB] 166s Get:93 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.1-1 [42.5 kB] 166s Get:94 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.1-1 [1459 kB] 166s Preconfiguring packages ... 167s Fetched 247 MB in 21s (11.5 MB/s) 167s Selecting previously unselected package libjson-perl. 167s (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 ... 83046 files and directories currently installed.) 167s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 167s Unpacking libjson-perl (4.10000-1) ... 167s Selecting previously unselected package postgresql-client-common. 167s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 167s Unpacking postgresql-client-common (282ubuntu1) ... 167s Selecting previously unselected package libio-pty-perl. 167s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 167s Unpacking libio-pty-perl (1:1.20-1build3) ... 167s Selecting previously unselected package libipc-run-perl. 167s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 167s Unpacking libipc-run-perl (20250809.0-1) ... 167s Selecting previously unselected package postgresql-common-dev. 167s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 167s Unpacking postgresql-common-dev (282ubuntu1) ... 167s Selecting previously unselected package ssl-cert. 167s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 167s Unpacking ssl-cert (1.1.3ubuntu1) ... 167s Selecting previously unselected package postgresql-common. 167s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 167s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 167s Unpacking postgresql-common (282ubuntu1) ... 167s Selecting previously unselected package m4. 167s Preparing to unpack .../07-m4_1.4.20-2_amd64.deb ... 167s Unpacking m4 (1.4.20-2) ... 167s Selecting previously unselected package autoconf. 167s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 167s Unpacking autoconf (2.72-3.1ubuntu1) ... 167s Selecting previously unselected package autotools-dev. 167s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 167s Unpacking autotools-dev (20240727.1) ... 167s Selecting previously unselected package automake. 167s Preparing to unpack .../10-automake_1%3a1.18.1-3_all.deb ... 167s Unpacking automake (1:1.18.1-3) ... 167s Selecting previously unselected package autopoint. 167s Preparing to unpack .../11-autopoint_0.23.2-1_all.deb ... 167s Unpacking autopoint (0.23.2-1) ... 167s Selecting previously unselected package libisl23:amd64. 167s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 167s Unpacking libisl23:amd64 (0.27-1) ... 167s Selecting previously unselected package libmpc3:amd64. 167s Preparing to unpack .../13-libmpc3_1.3.1-2_amd64.deb ... 167s Unpacking libmpc3:amd64 (1.3.1-2) ... 167s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 167s Preparing to unpack .../14-cpp-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 167s Selecting previously unselected package cpp-15. 167s Preparing to unpack .../15-cpp-15_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking cpp-15 (15.2.0-8ubuntu1) ... 167s Selecting previously unselected package cpp-x86-64-linux-gnu. 167s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 167s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 167s Selecting previously unselected package cpp. 167s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 167s Unpacking cpp (4:15.2.0-4ubuntu1) ... 167s Selecting previously unselected package libcc1-0:amd64. 167s Preparing to unpack .../18-libcc1-0_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking libcc1-0:amd64 (15.2.0-8ubuntu1) ... 167s Selecting previously unselected package libgomp1:amd64. 167s Preparing to unpack .../19-libgomp1_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking libgomp1:amd64 (15.2.0-8ubuntu1) ... 167s Selecting previously unselected package libitm1:amd64. 167s Preparing to unpack .../20-libitm1_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking libitm1:amd64 (15.2.0-8ubuntu1) ... 167s Selecting previously unselected package libasan8:amd64. 167s Preparing to unpack .../21-libasan8_15.2.0-8ubuntu1_amd64.deb ... 167s Unpacking libasan8:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package liblsan0:amd64. 168s Preparing to unpack .../22-liblsan0_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking liblsan0:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package libtsan2:amd64. 168s Preparing to unpack .../23-libtsan2_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libtsan2:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package libubsan1:amd64. 168s Preparing to unpack .../24-libubsan1_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libubsan1:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package libhwasan0:amd64. 168s Preparing to unpack .../25-libhwasan0_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libhwasan0:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package libquadmath0:amd64. 168s Preparing to unpack .../26-libquadmath0_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libquadmath0:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package libgcc-15-dev:amd64. 168s Preparing to unpack .../27-libgcc-15-dev_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libgcc-15-dev:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 168s Preparing to unpack .../28-gcc-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package gcc-15. 168s Preparing to unpack .../29-gcc-15_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking gcc-15 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package gcc-x86-64-linux-gnu. 168s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 168s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 168s Selecting previously unselected package gcc. 168s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 168s Unpacking gcc (4:15.2.0-4ubuntu1) ... 168s Selecting previously unselected package libstdc++-15-dev:amd64. 168s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking libstdc++-15-dev:amd64 (15.2.0-8ubuntu1) ... 168s Selecting previously unselected package g++-15-x86-64-linux-gnu. 168s Preparing to unpack .../33-g++-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 168s Unpacking g++-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 169s Selecting previously unselected package g++-15. 169s Preparing to unpack .../34-g++-15_15.2.0-8ubuntu1_amd64.deb ... 169s Unpacking g++-15 (15.2.0-8ubuntu1) ... 169s Selecting previously unselected package g++-x86-64-linux-gnu. 169s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 169s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 169s Selecting previously unselected package g++. 169s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 169s Unpacking g++ (4:15.2.0-4ubuntu1) ... 169s Selecting previously unselected package build-essential. 169s Preparing to unpack .../37-build-essential_12.12ubuntu1_amd64.deb ... 169s Unpacking build-essential (12.12ubuntu1) ... 169s Selecting previously unselected package libllvm21:amd64. 169s Preparing to unpack .../38-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 169s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 169s Selecting previously unselected package libclang-cpp21. 169s Preparing to unpack .../39-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 169s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 170s Selecting previously unselected package libgc1:amd64. 170s Preparing to unpack .../40-libgc1_1%3a8.2.10-1_amd64.deb ... 170s Unpacking libgc1:amd64 (1:8.2.10-1) ... 170s Selecting previously unselected package libobjc4:amd64. 170s Preparing to unpack .../41-libobjc4_15.2.0-8ubuntu1_amd64.deb ... 170s Unpacking libobjc4:amd64 (15.2.0-8ubuntu1) ... 170s Selecting previously unselected package libobjc-15-dev:amd64. 170s Preparing to unpack .../42-libobjc-15-dev_15.2.0-8ubuntu1_amd64.deb ... 170s Unpacking libobjc-15-dev:amd64 (15.2.0-8ubuntu1) ... 170s Selecting previously unselected package libclang-common-21-dev:amd64. 170s Preparing to unpack .../43-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 170s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 170s Selecting previously unselected package llvm-21-linker-tools. 170s Preparing to unpack .../44-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 170s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 170s Selecting previously unselected package libclang1-21. 170s Preparing to unpack .../45-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 170s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 170s Selecting previously unselected package clang-21. 170s Preparing to unpack .../46-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 170s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 170s Selecting previously unselected package libdebhelper-perl. 170s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 170s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 170s Selecting previously unselected package libtool. 170s Preparing to unpack .../48-libtool_2.5.4-7_all.deb ... 170s Unpacking libtool (2.5.4-7) ... 170s Selecting previously unselected package dh-autoreconf. 170s Preparing to unpack .../49-dh-autoreconf_21_all.deb ... 170s Unpacking dh-autoreconf (21) ... 170s Selecting previously unselected package libarchive-zip-perl. 170s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 170s Unpacking libarchive-zip-perl (1.68-1) ... 170s Selecting previously unselected package libfile-stripnondeterminism-perl. 170s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... 170s Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... 170s Selecting previously unselected package dh-strip-nondeterminism. 170s Preparing to unpack .../52-dh-strip-nondeterminism_1.15.0-1_all.deb ... 170s Unpacking dh-strip-nondeterminism (1.15.0-1) ... 170s Selecting previously unselected package debugedit. 170s Preparing to unpack .../53-debugedit_1%3a5.2-3_amd64.deb ... 170s Unpacking debugedit (1:5.2-3) ... 170s Selecting previously unselected package dwz. 170s Preparing to unpack .../54-dwz_0.16-2_amd64.deb ... 170s Unpacking dwz (0.16-2) ... 170s Selecting previously unselected package gettext. 170s Preparing to unpack .../55-gettext_0.23.2-1_amd64.deb ... 170s Unpacking gettext (0.23.2-1) ... 170s Selecting previously unselected package intltool-debian. 170s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 170s Unpacking intltool-debian (0.35.0+20060710.6) ... 170s Selecting previously unselected package po-debconf. 170s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 170s Unpacking po-debconf (1.0.21+nmu1) ... 170s Selecting previously unselected package debhelper. 170s Preparing to unpack .../58-debhelper_13.24.2ubuntu1_all.deb ... 170s Unpacking debhelper (13.24.2ubuntu1) ... 170s Selecting previously unselected package emacsen-common. 170s Preparing to unpack .../59-emacsen-common_3.0.8_all.deb ... 170s Unpacking emacsen-common (3.0.8) ... 170s Selecting previously unselected package dictionaries-common. 170s Preparing to unpack .../60-dictionaries-common_1.30.11_all.deb ... 170s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 170s Unpacking dictionaries-common (1.30.11) ... 170s Selecting previously unselected package libfakeroot:amd64. 170s Preparing to unpack .../61-libfakeroot_1.37.1.2-1_amd64.deb ... 170s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 170s Selecting previously unselected package fakeroot. 170s Preparing to unpack .../62-fakeroot_1.37.1.2-1_amd64.deb ... 170s Unpacking fakeroot (1.37.1.2-1) ... 170s Selecting previously unselected package hunspell-en-us. 170s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 170s Unpacking hunspell-en-us (1:2020.12.07-4) ... 171s Selecting previously unselected package libpgtypes3:amd64. 171s Preparing to unpack .../64-libpgtypes3_18.1-1_amd64.deb ... 171s Unpacking libpgtypes3:amd64 (18.1-1) ... 171s Selecting previously unselected package libpq5:amd64. 171s Preparing to unpack .../65-libpq5_18.1-1_amd64.deb ... 171s Unpacking libpq5:amd64 (18.1-1) ... 171s Selecting previously unselected package libecpg6:amd64. 171s Preparing to unpack .../66-libecpg6_18.1-1_amd64.deb ... 171s Unpacking libecpg6:amd64 (18.1-1) ... 171s Selecting previously unselected package libecpg-compat3:amd64. 171s Preparing to unpack .../67-libecpg-compat3_18.1-1_amd64.deb ... 171s Unpacking libecpg-compat3:amd64 (18.1-1) ... 171s Selecting previously unselected package libssl-dev:amd64. 171s Preparing to unpack .../68-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 171s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 171s Selecting previously unselected package libpq-dev. 171s Preparing to unpack .../69-libpq-dev_18.1-1_amd64.deb ... 171s Unpacking libpq-dev (18.1-1) ... 171s Selecting previously unselected package libecpg-dev. 171s Preparing to unpack .../70-libecpg-dev_18.1-1_amd64.deb ... 171s Unpacking libecpg-dev (18.1-1) ... 171s Selecting previously unselected package libncurses-dev:amd64. 171s Preparing to unpack .../71-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 171s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 171s Selecting previously unselected package libpq-oauth:amd64. 171s Preparing to unpack .../72-libpq-oauth_18.1-1_amd64.deb ... 171s Unpacking libpq-oauth:amd64 (18.1-1) ... 171s Selecting previously unselected package libtcl8.6:amd64. 171s Preparing to unpack .../73-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 171s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 171s Selecting previously unselected package liburing2:amd64. 171s Preparing to unpack .../74-liburing2_2.11-1_amd64.deb ... 171s Unpacking liburing2:amd64 (2.11-1) ... 171s Selecting previously unselected package liblzma-dev:amd64. 171s Preparing to unpack .../75-liblzma-dev_5.8.1-2_amd64.deb ... 171s Unpacking liblzma-dev:amd64 (5.8.1-2) ... 171s Selecting previously unselected package zlib1g-dev:amd64. 171s Preparing to unpack .../76-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 171s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 171s Selecting previously unselected package libxml2-dev:amd64. 171s Preparing to unpack .../77-libxml2-dev_2.15.1+dfsg-0.3_amd64.deb ... 171s Unpacking libxml2-dev:amd64 (2.15.1+dfsg-0.3) ... 171s Selecting previously unselected package libxslt1.1:amd64. 171s Preparing to unpack .../78-libxslt1.1_1.1.43-0.3_amd64.deb ... 171s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 171s Selecting previously unselected package llvm-21-runtime. 171s Preparing to unpack .../79-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 171s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 171s Selecting previously unselected package libpfm4:amd64. 171s Preparing to unpack .../80-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 171s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 171s Selecting previously unselected package llvm-21. 171s Preparing to unpack .../81-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 171s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 171s Selecting previously unselected package libffi-dev:amd64. 171s Preparing to unpack .../82-libffi-dev_3.5.2-2_amd64.deb ... 171s Unpacking libffi-dev:amd64 (3.5.2-2) ... 171s Selecting previously unselected package llvm-21-tools. 172s Preparing to unpack .../83-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 172s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 172s Selecting previously unselected package llvm-21-dev. 172s Preparing to unpack .../84-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 172s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 173s Selecting previously unselected package locales-all. 173s Preparing to unpack .../85-locales-all_2.42-2ubuntu2_amd64.deb ... 173s Unpacking locales-all (2.42-2ubuntu2) ... 174s Selecting previously unselected package postgresql-client-18. 174s Preparing to unpack .../86-postgresql-client-18_18.1-1_amd64.deb ... 174s Unpacking postgresql-client-18 (18.1-1) ... 174s Selecting previously unselected package postgresql-18. 174s Preparing to unpack .../87-postgresql-18_18.1-1_amd64.deb ... 174s Unpacking postgresql-18 (18.1-1) ... 175s Selecting previously unselected package postgresql-18-jit. 175s Preparing to unpack .../88-postgresql-18-jit_18.1-1_amd64.deb ... 175s Unpacking postgresql-18-jit (18.1-1) ... 175s Selecting previously unselected package postgresql-doc-18. 175s Preparing to unpack .../89-postgresql-doc-18_18.1-1_all.deb ... 175s Unpacking postgresql-doc-18 (18.1-1) ... 175s Selecting previously unselected package postgresql-plperl-18. 175s Preparing to unpack .../90-postgresql-plperl-18_18.1-1_amd64.deb ... 175s Unpacking postgresql-plperl-18 (18.1-1) ... 175s Selecting previously unselected package postgresql-plpython3-18. 175s Preparing to unpack .../91-postgresql-plpython3-18_18.1-1_amd64.deb ... 175s Unpacking postgresql-plpython3-18 (18.1-1) ... 175s Selecting previously unselected package postgresql-pltcl-18. 175s Preparing to unpack .../92-postgresql-pltcl-18_18.1-1_amd64.deb ... 175s Unpacking postgresql-pltcl-18 (18.1-1) ... 175s Selecting previously unselected package postgresql-server-dev-18. 175s Preparing to unpack .../93-postgresql-server-dev-18_18.1-1_amd64.deb ... 175s Unpacking postgresql-server-dev-18 (18.1-1) ... 175s Setting up postgresql-client-common (282ubuntu1) ... 175s Setting up libpgtypes3:amd64 (18.1-1) ... 175s Setting up postgresql-doc-18 (18.1-1) ... 175s 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 175s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 175s Setting up libio-pty-perl (1:1.20-1build3) ... 175s Setting up libarchive-zip-perl (1.68-1) ... 175s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 175s Setting up libpq5:amd64 (18.1-1) ... 175s Setting up m4 (1.4.20-2) ... 175s Setting up libgomp1:amd64 (15.2.0-8ubuntu1) ... 175s Setting up libffi-dev:amd64 (3.5.2-2) ... 175s Setting up locales-all (2.42-2ubuntu2) ... 175s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 175s Setting up fakeroot (1.37.1.2-1) ... 175s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 175s Setting up autotools-dev (20240727.1) ... 175s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 175s Setting up emacsen-common (3.0.8) ... 175s Setting up ssl-cert (1.1.3ubuntu1) ... 176s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 176s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 176s Setting up libquadmath0:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 176s Setting up libmpc3:amd64 (1.3.1-2) ... 176s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 176s Setting up autopoint (0.23.2-1) ... 176s Setting up libipc-run-perl (20250809.0-1) ... 176s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 176s Setting up libgc1:amd64 (1:8.2.10-1) ... 176s Setting up autoconf (2.72-3.1ubuntu1) ... 176s Setting up liblzma-dev:amd64 (5.8.1-2) ... 176s Setting up libubsan1:amd64 (15.2.0-8ubuntu1) ... 176s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 176s Setting up dwz (0.16-2) ... 176s Setting up libhwasan0:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libasan8:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libjson-perl (4.10000-1) ... 176s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 176s Setting up debugedit (1:5.2-3) ... 176s Setting up libecpg6:amd64 (18.1-1) ... 176s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 176s Setting up libtsan2:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 176s Setting up liburing2:amd64 (2.11-1) ... 176s Setting up libisl23:amd64 (0.27-1) ... 176s Setting up libcc1-0:amd64 (15.2.0-8ubuntu1) ... 176s Setting up liblsan0:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libitm1:amd64 (15.2.0-8ubuntu1) ... 176s Setting up postgresql-common-dev (282ubuntu1) ... 176s Setting up automake (1:1.18.1-3) ... 176s update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode 176s Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... 176s Setting up gettext (0.23.2-1) ... 176s Setting up libgcc-15-dev:amd64 (15.2.0-8ubuntu1) ... 176s Setting up libecpg-compat3:amd64 (18.1-1) ... 176s Setting up postgresql-client-18 (18.1-1) ... 176s 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 176s Setting up dictionaries-common (1.30.11) ... 177s Setting up libpq-oauth:amd64 (18.1-1) ... 177s Setting up libpq-dev (18.1-1) ... 177s Setting up libobjc4:amd64 (15.2.0-8ubuntu1) ... 177s Setting up cpp-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 177s Setting up libecpg-dev (18.1-1) ... 177s Setting up intltool-debian (0.35.0+20060710.6) ... 177s Setting up gcc-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 177s Setting up libxml2-dev:amd64 (2.15.1+dfsg-0.3) ... 177s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 177s Setting up libstdc++-15-dev:amd64 (15.2.0-8ubuntu1) ... 177s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 177s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 177s Setting up postgresql-common (282ubuntu1) ... 177s Creating config file /etc/postgresql-common/createcluster.conf with new version 177s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 177s en_us 177s Removing obsolete dictionary files: 178s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 178s Setting up dh-strip-nondeterminism (1.15.0-1) ... 178s Setting up cpp-15 (15.2.0-8ubuntu1) ... 178s Setting up hunspell-en-us (1:2020.12.07-4) ... 178s Setting up libobjc-15-dev:amd64 (15.2.0-8ubuntu1) ... 178s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 178s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 178s Setting up g++-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 178s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 178s Setting up po-debconf (1.0.21+nmu1) ... 178s Setting up postgresql-18 (18.1-1) ... 179s Creating new PostgreSQL cluster 18/main ... 179s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 179s The files belonging to this database system will be owned by user "postgres". 179s This user must also own the server process. 179s 179s The database cluster will be initialized with locale "C.UTF-8". 179s The default database encoding has accordingly been set to "UTF8". 179s The default text search configuration will be set to "english". 179s 179s Data page checksums are enabled. 179s 179s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 179s creating subdirectories ... ok 179s selecting dynamic shared memory implementation ... posix 179s selecting default "max_connections" ... 100 179s selecting default "shared_buffers" ... 128MB 179s selecting default time zone ... Etc/UTC 179s creating configuration files ... ok 179s running bootstrap script ... ok 179s performing post-bootstrap initialization ... ok 179s syncing data to disk ... ok 182s Setting up postgresql-18-jit (18.1-1) ... 182s Setting up gcc-15 (15.2.0-8ubuntu1) ... 182s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 182s Setting up postgresql-plpython3-18 (18.1-1) ... 182s Setting up cpp (4:15.2.0-4ubuntu1) ... 182s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 182s Setting up postgresql-plperl-18 (18.1-1) ... 182s Setting up g++-15 (15.2.0-8ubuntu1) ... 182s Setting up postgresql-pltcl-18 (18.1-1) ... 182s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 182s Setting up libtool (2.5.4-7) ... 182s Setting up postgresql-server-dev-18 (18.1-1) ... 182s Setting up gcc (4:15.2.0-4ubuntu1) ... 182s Setting up dh-autoreconf (21) ... 182s Setting up g++ (4:15.2.0-4ubuntu1) ... 182s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 182s Setting up build-essential (12.12ubuntu1) ... 182s Setting up debhelper (13.24.2ubuntu1) ... 182s Processing triggers for man-db (2.13.1-1) ... 184s Processing triggers for install-info (7.2-5) ... 184s Processing triggers for libc-bin (2.42-2ubuntu2) ... 184s Processing triggers for systemd (259~rc1-1ubuntu1) ... 184s Processing triggers for dictionaries-common (1.30.11) ... 188s autopkgtest [08:26:28]: test run-testsuite: [----------------------- 189s ====== Running all tests with umask 077 ======= 189s ### PostgreSQL test 001_packages.t ### 189s 1..23 189s ok 1 - /etc/os-release exists 189s ok 2 - OS is ubuntu 189s ok 3 - OS version is 26.04 189s # PostgreSQL versions installed: 18 189s # 18 189s ok 4 - postgresql-18 installed 189s ok 5 - postgresql-plpython3-18 installed 189s ok 6 - postgresql-plperl-18 installed 189s ok 7 - postgresql-pltcl-18 installed 189s ok 8 - postgresql-18-jit installed 189s ok 9 - postgresql-server-dev-18 installed 189s ok 10 # skip No postgresql-contrib-18 package for version 18 189s # postgresql-doc-18 installed 189s ok 11 - At least one doc package installed 189s ok 12 - libecpg-dev installed 189s ok 13 - postgresql-common-dev installed 189s ok 14 - procps installed 189s ok 15 - netcat-openbsd installed 189s ok 16 - hunspell-en-us installed 189s ok 17 - system has a default UTF-8 locale 189s ok 18 - locale ru_RU exists 189s ok 19 - locale ru_RU.UTF-8 exists 189s ok 20 - user postgres in the UNIX group ssl-cert 189s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 189s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 189s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 189s ### End test 001_packages.t ### 189s 189s ### PostgreSQL test 002_existing_clusters.t ### 189s 1..8 189s # Cleanup 189s ok 1 - Cleanup: No clusters left behind 189s ok 2 - No postgres processes left behind 189s ok 3 - No files in /etc/postgresql left behind 189s ok 4 - No files in /var/lib/postgresql left behind 189s ok 5 - No files in /var/run/postgresql left behind 189s ok 6 - No files in /var/log/postgresql left behind 189s ok 7 - PostgreSQL TCP ports are closed 189s ok 8 - Next free port is 5432 189s ### End test 002_existing_clusters.t ### 189s 189s ### PostgreSQL test 003_alternatives.t ### 190s 1..9 190s # Newest PG version installed is 18 190s ok 1 - psql.1.gz link group 190s ok 2 - postmaster.1.gz link group does not exist 190s ok 3 - psql.1.gz alternative 190s ok 4 - pg_dump.1.gz alternative 190s ok 5 - postgres.1.gz alternative 190s ok 6 - pg_ctl.1.gz alternative 190s # Newest PG doc version installed is 18 190s ok 7 - SPI_connect.3.gz link group 190s ok 8 - SPI_connect.3.gz alternative 190s ok 9 - SPI_exec.3.gz alternative 190s ### End test 003_alternatives.t ### 190s 190s ### PostgreSQL test 005_PgCommon.t ### 190s 1..24 190s ok 1 - correctly parsed line 'local all postgres ident sameuser' 190s ok 2 - correctly parsed line 'local foo nobody trust' 190s ok 3 - correctly parsed line 'local foo nobody crypt' 190s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 190s ok 5 - correctly parsed line 'local foo,bar nobody ident' 190s ok 6 - correctly parsed line 'local all +foogrp password' 190s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 190s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 190s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 190s ok 10 - @expected_records has correct number of entries 190s ok 11 - returned read_pg_hba array has correct number of records 190s ok 12 - line 'foo all all md5' parsed as invalid 190s ok 13 - line 'local all all foo' parsed as invalid 190s ok 14 - line 'host all all foo' parsed as invalid 190s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 190s ok 16 - line 'host all all md5' parsed as invalid 190s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 190s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 190s ok 19 - read_conf_file returns empty dict for nonexisting file 190s ok 20 - read_conf_file() parsing 190s ok 21 - read_conf_file() parsing with include directives 190s ok 22 - set_conf_value 190s ok 23 - disable_conf_value 190s ok 24 - replace_conf_value 190s ### End test 005_PgCommon.t ### 190s 190s ### PostgreSQL test 006_next_free_port.t ### 190s 1..5 190s ok 1 - next_free_port is 5432 191s ok 2 - next_free_port detects localhost ipv4 socket 192s ok 3 - next_free_port detects wildcard ipv4 socket 193s ok 4 - next_free_port detects localhost ipv6 socket 194s ok 5 - next_free_port detects wildcard ipv6 socket 194s ### End test 006_next_free_port.t ### 194s 194s ### PostgreSQL test 007_pg_conftool.t ### 194s 1..41 194s # test without cluster 194s ok 1 - pg_conftool show all 194s ok 2 - correct output of pg_conftool show all 194s ok 3 - pg_conftool foo.conf show all 194s ok 4 - correct output of pg_conftool foo.conf show all 194s ok 5 - pg_conftool /tmp/XYd3ueRvjS/different.conf show all 194s ok 6 - correct output of pg_conftool /tmp/XYd3ueRvjS/different.conf show all 194s ok 7 - pg_conftool 9.7 main show all 194s ok 8 - correct output of pg_conftool 9.7 main show all 194s # test show 194s ok 9 - pg_conftool show all 194s ok 10 - correct output of pg_conftool show all 194s ok 11 - pg_conftool other.conf show all 194s ok 12 - correct output of pg_conftool other.conf show all 194s ok 13 - pg_conftool /tmp/XYd3ueRvjS/different.conf show all 194s ok 14 - correct output of pg_conftool /tmp/XYd3ueRvjS/different.conf show all 194s ok 15 - pg_conftool 18 main show all 194s ok 16 - correct output of pg_conftool 18 main show all 194s ok 17 - pg_conftool 18 main other.conf show all 194s ok 18 - correct output of pg_conftool 18 main other.conf show all 194s ok 19 - pg_conftool show a 194s ok 20 - correct output of pg_conftool show a 194s ok 21 - pg_conftool -s show a 194s ok 22 - correct output of pg_conftool -s show a 194s # test set 194s ok 23 - pg_conftool set c 7 194s ok 24 - correct output of pg_conftool set c 7 194s ok 25 - file contains new setting 194s ok 26 - pg_conftool set a 8 194s ok 27 - correct output of pg_conftool set a 8 194s ok 28 - file contains updated setting 194s ok 29 - pg_conftool /tmp/XYd3ueRvjS/different.conf set a 9 194s ok 30 - correct output of pg_conftool /tmp/XYd3ueRvjS/different.conf set a 9 194s ok 31 - file with path contains updated setting 194s # test remove 195s ok 32 - pg_conftool remove a 195s ok 33 - correct output of pg_conftool remove a 195s ok 34 - setting removed from file 195s ok 35 - pg_conftool /tmp/XYd3ueRvjS/different.conf remove a 195s ok 36 - correct output of pg_conftool /tmp/XYd3ueRvjS/different.conf remove a 195s ok 37 - setting removed from file with path 195s # test edit 195s ok 38 - pg_conftool edit 195s ok 39 - correct output of pg_conftool edit 195s ok 40 - pg_conftool /tmp/XYd3ueRvjS/different.conf edit 195s ok 41 - correct output of pg_conftool /tmp/XYd3ueRvjS/different.conf edit 195s ### End test 007_pg_conftool.t ### 195s 195s ### PostgreSQL test 010_defaultport_cluster.t ### 195s 1..14 195s ok 1 - psql --version 195s ok 2 - pg_wrapper selects highest available version number 195s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 195s ok 4 - connecting to localhost fails with no clusters 195s ok 5 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -l 195s ok 6 - pg_wrapper uses host and port from PGCLUSTER 195s ok 7 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --cluster 18/127.0.0.3:5430 -l 195s ok 8 - pg_wrapper uses --cluster from the command line 195s ok 9 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -h 127.0.0.3 -l 195s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 195s ok 11 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --host 127.0.0.3 -l 195s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 195s ok 13 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 195s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 195s ### End test 010_defaultport_cluster.t ### 195s 195s ### PostgreSQL test 015_start_stop.t ### 195s 1..71 195s # We are running systemd 195s # Running tests for 18 195s # Cluster does not exist yet 195s ok 1 - cluster 18 main does not exist 195s ok 2 - service postgresql@18-main does not exist 195s ok 3 - systemctl start postgresql 195s ok 4 - cluster 18 main does not exist 195s ok 5 - service postgresql@18-main does not exist 195s ok 6 - systemctl start postgresql@18-main 195s ok 7 - cluster 18 main does not exist 195s ok 8 - service postgresql@18-main does not exist 195s # Start/stop postgresql using system tools 196s ok 9 - pg_createcluster 18 main 196s ok 10 - cluster 18 main is stopped 196s ok 11 - service postgresql@18-main is stopped 198s ok 12 - systemctl start postgresql 199s ok 13 - cluster 18 main is running 199s ok 14 - service postgresql@18-main is running 199s ok 15 - systemctl start postgresql 199s ok 16 - cluster 18 main is already running 199s ok 17 - service postgresql@18-main is already running 199s ok 18 - systemctl stop postgresql 205s ok 19 - cluster 18 main is stopped 205s ok 20 - service postgresql@18-main is stopped 205s ok 21 - systemctl stop postgresql 205s ok 22 - cluster 18 main is already stopped 205s ok 23 - service postgresql@18-main is already stopped 205s # Start/stop specific cluster using system tools 207s ok 24 - systemctl start postgresql@18-main 207s ok 25 - cluster 18 main is running 207s ok 26 - service postgresql@18-main is running 207s ok 27 - systemctl start postgresql@18-main 207s ok 28 - cluster 18 main is running 207s ok 29 - service postgresql@18-main is running 209s ok 30 - systemctl restart postgresql@18-main 210s ok 31 - cluster 18 main is running 210s ok 32 - service postgresql@18-main is running 210s ok 33 - systemctl stop postgresql@18-main 210s ok 34 - cluster 18 main is stopped 210s ok 35 - service postgresql@18-main is stopped 210s ok 36 - systemctl stop postgresql@18-main 210s ok 37 - cluster 18 main is already stopped 210s ok 38 - service postgresql@18-main is already stopped 211s ok 39 - pg_dropcluster 18 main 211s ok 40 - cluster 18 main does not exist 211s ok 41 - service postgresql@18-main does not exist 211s # Start/stop specific cluster using pg_*cluster 211s ok 42 - pg_ctlcluster start 18 main 211s ok 43 - cluster 18 main does not exist 211s ok 44 - service postgresql@18-main does not exist 214s ok 45 - pg_createcluster 18 main --start 214s ok 46 - cluster 18 main is running 214s ok 47 - service postgresql@18-main is running 215s ok 48 - pg_ctlcluster 18 main start 215s ok 49 - cluster 18 main is already running 215s ok 50 - service postgresql@18-main is already running 217s ok 51 - pg_ctlcluster 18-main restart 217s ok 52 - cluster 18 main is running 217s ok 53 - service postgresql@18-main is running 217s ok 54 - pg_ctlcluster 18 main stop 217s ok 55 - cluster 18 main is stopped 217s ok 56 - service postgresql@18-main is stopped 217s ok 57 - pg_ctlcluster 18 main stop 217s ok 58 - cluster 18 main is already stopped 218s ok 59 - service postgresql@18-main is already stopped 220s ok 60 - pg_ctlcluster start 18-main 220s ok 61 - cluster 18 main is running 220s ok 62 - service postgresql@18-main is running 221s ok 63 - pg_dropcluster 18 main --stop 221s # Cleanup 221s ok 64 - Cleanup: No clusters left behind 221s ok 65 - No postgres processes left behind 221s ok 66 - No files in /etc/postgresql left behind 221s ok 67 - No files in /var/lib/postgresql left behind 221s ok 68 - No files in /var/run/postgresql left behind 221s ok 69 - No files in /var/log/postgresql left behind 221s ok 70 - PostgreSQL TCP ports are closed 221s ok 71 - Next free port is 5432 221s ### End test 015_start_stop.t ### 221s 221s ### PostgreSQL test 020_create_sql_remove.t ### 222s 1..141 222s # Running tests for 18 225s ok 1 - pg_createcluster 18 main --start -- -X /tmp/18.xlog.kqYPGF 225s ok 2 - pg_createcluster 18 main 225s ok 3 - Socket and pid file are in /var/run/postgresql/ 225s ok 4 - xlog/wal directory /tmp/18.xlog.kqYPGF was created 225s ok 5 - local method in pg_hba.conf is peer 225s ok 6 - host method in pg_hba.conf is scram-sha-256 225s ok 7 - Exactly one postgres master process running 227s ok 8 - pg_ctlcluster 18 main restart 227s ok 9 - cluster restarts with new environment file 227s ok 10 - Exactly one postgres master process running 227s ok 11 - correct value of PGEXTRAVAR1 in environment 227s ok 12 - correct value of PGEXTRAVAR2 in environment 227s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 227s ok 14 - createdb --version 227s ok 15 - pg_wrapper+createdb selects version number of cluster 227s ok 16 - psql --version 227s ok 17 - pg_wrapper+psql selects version 18 227s ok 18 - pg_lscluster reports online cluster on port 5432 227s ok 19 - log file is actually used 227s ok 20 - /etc/postgresql is owned by user "postgres" 227s ok 21 - version configuration directory file is owned by user "postgres" 227s ok 22 - configuration directory file is owned by user "postgres" 227s ok 23 - version data directory file is owned by user "postgres" 227s ok 24 - data directory file is owned by user "postgres" 227s ok 25 - log file has 0640 permissions 227s ok 26 - log file is owned by user "postgres" 227s ok 27 - log file is owned by group "adm" 227s ok 28 - no log symlink by default 227s ok 29 - /var/log/postgresql/postgresql-18-main.log is the default log if log symlink is missing 227s ok 30 - pg_lsclusters -h 227s ok 31 - correct output of pg_lsclusters -h 227s ok 32 - stopping cluster 230s ok 33 - restarting cluster with nondefault log symlink 230s ok 34 - log target is used as log file 230s ok 35 - default log is not used 230s ok 36 - pg_lsclusters -h 230s ok 37 - correct output of pg_lsclusters -h 230s ok 38 - stopping cluster 233s ok 39 - restarting cluster with explicitly configured log file 233s ok 40 - default log is not used 233s ok 41 - log symlink target is used for startup message 233s ok 42 - exactly one log file 233s ok 43 - custom log is actually used 233s ok 44 - pg_lsclusters -h 233s ok 45 - correct output of pg_lsclusters -h 233s ok 46 - stopping cluster 233s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 233s ok 48 - /etc/postgres-hack was not created 235s ok 49 - restarting cluster 235s ok 50 - ps -o tty -U postgres h 235s ok 51 - postgres processes do not have an associated terminal 235s ok 52 - Server is linked with SSL support 235s ok 53 - SSL is enabled in postgresql.conf 235s ok 54 - psql -l fails for nobody 235s ok 55 - createuser nobody 235s ok 56 - createdb nobodydb 235s ok 57 - psql -ltA succeeds for nobody 235s ok 58 - psql -ltA output 235s ok 59 - SQL command: create table 236s ok 60 - SQL command: insert into table values 236s ok 61 - SQL command: insert into table values 236s ok 62 - primary key violation 236s ok 63 - psql -tAc "select * from phone order by name" nobodydb 236s ok 64 - SQL command output: select -tA 236s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 236s ok 66 - SQL command output: select -tx 236s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 236s ok 68 - SQL command output: select -tAx 236s ok 69 - CREATE EXTENSION plperlu fails for user nobody 236s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 236s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 236s ok 72 - creating PL/PerlU function as user nobody fails 236s ok 73 - creating unsafe PL/Perl function as user postgres fails 236s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 236s ok 75 - creating PL/PerlU function as user postgres succeeds 236s ok 76 - psql nobodydb -Atc "select read_file()" 236s ok 77 - calling PL/PerlU function 236s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 236s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 236s ok 80 - creating unsafe PL/Perl function as user nobody fails 236s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 236s ok 82 - creating PL/Perl function as user nobody succeeds 236s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 236s ok 84 - calling PL/Perl function 236s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 236s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 236s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 236s ok 88 - creating PL/Python3 function as user postgres succeeds 236s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 236s ok 90 - calling PL/Python function 236s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 236s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 237s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 237s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 237s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 237s ok 96 - creating PL/Tcl function as user nobody succeeds 237s 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;" 237s ok 98 - creating PL/TclU function as user postgres succeeds 237s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 237s ok 100 - calling PL/Tcl function 237s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 237s ok 102 - calling PL/TclU function 237s ok 103 - stopping cluster 237s ok 104 - pg_ctlcluster 18 main start 237s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 239s ok 106 - pg_ctlcluster 18 main start 239s ok 107 - cluster restarts with pgdata symlink 240s ok 108 - postgres master has OOM killer protection 240s ok 109 - postgres client backend has no OOM adjustment 240s ok 110 - ps h 7090 240s ok 111 - process title is idle 240s ok 112 - ps h 7090 240s ok 113 - process title is idle in transaction 240s ok 114 - stopping cluster 242s ok 115 - starting cluster as postgres works without a log file 242s ok 116 - log file got recreated and used 242s ok 117 - creating a directory in spc2 243s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/18.spc1.dm3Qj5'" 243s ok 119 - creating tablespace spc1 243s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 243s ok 121 - creating a table in spc1 243s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/18.spc2.7RBoQf'" 243s ok 123 - creating tablespace spc2 243s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 243s ok 125 - creating a table in spc2 243s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 243s ok 127 - Correct apt NeverAutoRemove config 244s ok 128 - pg_dropcluster removes cluster 244s ok 129 - xlog/wal directory /tmp/18.xlog.kqYPGF was deleted 244s ok 130 - tablespace spc1 was emptied 244s ok 131 - tablespace spc2 was emptied 244s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 244s ok 133 - Correct apt NeverAutoRemove config 244s # Cleanup 244s ok 134 - Cleanup: No clusters left behind 244s ok 135 - No postgres processes left behind 244s ok 136 - No files in /etc/postgresql left behind 244s ok 137 - No files in /var/lib/postgresql left behind 244s ok 138 - No files in /var/run/postgresql left behind 244s ok 139 - No files in /var/log/postgresql left behind 244s ok 140 - PostgreSQL TCP ports are closed 244s ok 141 - Next free port is 5432 244s ### End test 020_create_sql_remove.t ### 244s 244s ### PostgreSQL test 021_pg_renamecluster.t ### 244s 1..20 247s ok 1 - pg_createcluster 18 main 250s ok 2 - pg_renamecluster 18 main donau 250s ok 3 - psql -tAc "show data_directory" 250s ok 4 - cluster is running and data_directory was moved 250s ok 5 - pg_hba.conf location updated 250s ok 6 - pg_ident.conf location updated 250s ok 7 - external_pid_file location updated 250s ok 8 - external_pid_file exists 250s ok 9 # skip no stats_temp_directory in 18 250s ok 10 # skip no stats_temp_directory in 18 250s ok 11 - cluster_name is updated 252s ok 12 - pg_dropcluster removes cluster 252s # Cleanup 252s ok 13 - Cleanup: No clusters left behind 252s ok 14 - No postgres processes left behind 252s ok 15 - No files in /etc/postgresql left behind 252s ok 16 - No files in /var/lib/postgresql left behind 252s ok 17 - No files in /var/run/postgresql left behind 252s ok 18 - No files in /var/log/postgresql left behind 252s ok 19 - PostgreSQL TCP ports are closed 252s ok 20 - Next free port is 5432 252s ### End test 021_pg_renamecluster.t ### 252s 252s ### PostgreSQL test 022_recovery.t ### 252s 1..17 252s # Running tests for 18 255s ok 1 - pg_createcluster 18 main --start >/dev/null 255s ok 2 - pg_ctlcluster 18 main stop -m i 257s ok 3 - pg_ctlcluster 18 main start 257s ok 4 - psql -c '' 258s ok 5 - pg_ctlcluster 18 main stop -m i 258s ok 6 - create write-protected file in data directory 260s ok 7 - pg_ctlcluster 18 main start 260s ok 8 - psql -c '' 261s ok 9 - pg_dropcluster removes cluster 261s # Cleanup 261s ok 10 - Cleanup: No clusters left behind 261s ok 11 - No postgres processes left behind 261s ok 12 - No files in /etc/postgresql left behind 261s ok 13 - No files in /var/lib/postgresql left behind 261s ok 14 - No files in /var/run/postgresql left behind 261s ok 15 - No files in /var/log/postgresql left behind 261s ok 16 - PostgreSQL TCP ports are closed 261s ok 17 - Next free port is 5432 261s ### End test 022_recovery.t ### 261s 261s ### PostgreSQL test 025_logging.t ### 261s 1..55 262s # Logging to /var/log/syslog works 262s # Running tests for 18 265s ok 1 - pg_createcluster 18 main 265s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-18-main.log 265s ok 3 - psql -qc "'foobar_18_8402'" 265s ok 4 - log an error 266s ok 5 - grep --binary-files=text foobar_18_8402 /var/log/postgresql/postgresql-18-main.log 266s ok 6 - error appears in logfile 266s ok 7 - pg_conftool 18 main set log_destination syslog 266s ok 8 - set log_destination syslog 266s ok 9 - pg_ctlcluster 18 main reload 266s ok 10 - 18 main reload 266s ok 11 - psql -Atc "show log_destination" 266s ok 12 - log_destination is syslog 266s ok 13 - pg_lscluster reports syslog 266s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 266s ok 15 - error appears in /var/log/syslog 266s ok 16 - pg_conftool 18 main set logging_collector on 266s ok 17 - set logging_collector on 266s ok 18 - pg_conftool 18 main set log_destination csvlog 266s ok 19 - set log_destination csvlog 269s ok 20 - pg_ctlcluster 18 main restart 269s ok 21 - 18 main restart 269s ok 22 - psql -Atc "show logging_collector" 269s ok 23 - logging_collector is on 269s ok 24 - psql -Atc "show log_destination" 269s ok 25 - log_destination is csvlog 269s ok 26 - pg_lscluster reports csvlog 269s ok 27 - psql -qc "'barbaz_18_8402'" 269s ok 28 - log an error 270s ok 29 - grep --binary-files=text barbaz_18_8402 /var/lib/postgresql/18/main/log/*.csv 270s ok 30 - error appears in log/*.csv 270s ok 31 - pg_conftool 18 main set log_destination stderr,syslog,csvlog 270s ok 32 - set log_destination stderr,syslog,csvlog 270s ok 33 - pg_ctlcluster 18 main reload 270s ok 34 - 18 main reload 270s ok 35 - psql -Atc "show log_destination" 270s ok 36 - log_destination is stderr,syslog,csvlog 270s ok 37 - pg_lscluster reports stderr,syslog,csvlog 270s ok 38 - psql -qc "'moo_18_8402'" 270s ok 39 - log an error 270s ok 40 - grep --binary-files=text moo_18_8402 /var/lib/postgresql/18/main/log/*.log 270s ok 41 - error appears in log/*.log 271s ok 42 - grep --binary-files=text 'postgres.*moo_18_8402' /var/log/syslog 271s ok 43 - error appears in /var/log/syslog 271s ok 44 - grep --binary-files=text moo_18_8402 /var/lib/postgresql/18/main/log/*.csv 271s ok 45 - error appears in log/*.csv 272s ok 46 - pg_dropcluster 18 main --stop 272s ok 47 - pg_dropcluster removes cluster 272s # Cleanup 272s ok 48 - Cleanup: No clusters left behind 272s ok 49 - No postgres processes left behind 272s ok 50 - No files in /etc/postgresql left behind 272s ok 51 - No files in /var/lib/postgresql left behind 272s ok 52 - No files in /var/run/postgresql left behind 272s ok 53 - No files in /var/log/postgresql left behind 272s ok 54 - PostgreSQL TCP ports are closed 272s ok 55 - Next free port is 5432 272s ### End test 025_logging.t ### 272s 272s ### PostgreSQL test 027_jit.t ### 272s # 18 276s ok 1 - pg_createcluster 18 main --start 276s ok 2 - psql -Xatc 'show jit' 276s ok 3 - JIT is on by default 276s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 276s ok 5 - No JIT on cheap query 276s ok 6 - pg_conftool 18 main set seq_page_cost 100000 276s ok 7 - pg_conftool 18 main set random_page_cost 100000 276s ok 8 - pg_ctlcluster 18 main reload 276s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 276s ok 10 - Expensive query is JITed 277s ok 11 - pg_dropcluster --stop 18 main 277s # Cleanup 277s ok 12 - Cleanup: No clusters left behind 277s ok 13 - No postgres processes left behind 277s ok 14 - No files in /etc/postgresql left behind 277s ok 15 - No files in /var/lib/postgresql left behind 277s ok 16 - No files in /var/run/postgresql left behind 277s ok 17 - No files in /var/log/postgresql left behind 277s ok 18 - PostgreSQL TCP ports are closed 277s ok 19 - Next free port is 5432 277s 1..19 277s ### End test 027_jit.t ### 277s 277s ### PostgreSQL test 030_errors.t ### 277s 1..156 277s ok 1 - pg_lscluster reports cluster without binaries 279s ok 2 - pg_dropcluster 6.3 main 279s ok 3 - pg_createcluster --socketdir 279s ok 4 - pg_lsclusters -h 279s ok 5 - cluster was created 279s ok 6 - Port of created cluster is 5432 279s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 18 main 279s ok 8 - pg_createcluster on existing cluster 279s ok 9 - pg_lsclusters -h 279s ok 10 - original cluster still exists 280s ok 11 - pg_createcluster 18 test -p foo 280s ok 12 - pg_createcluster -p checks that port option is numeric 280s ok 13 - pg_createcluster 18 test -p 42 280s ok 14 - pg_createcluster -p checks valid port range 280s ok 15 - pg_ctlcluster 18 main start 280s ok 16 - pg_ctlcluster refuses to start root-owned cluster 280s ok 17 - pg_ctlcluster 18 main start 280s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 280s ok 19 - pg_ctlcluster 18 main start 280s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 280s ok 21 - pg_ctlcluster 18 main start 280s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 282s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 282s ok 24 - No sockets in /var/run/postgresql 282s ok 25 - Socket is in /tmp/postgresql-testsuite/ 282s ok 26 - cluster stops with custom unix_socket_dir 282s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 284s ok 28 - cluster starts after removing unix_socket_dir 286s ok 29 - Socket is in default dir /var/run/postgresql 286s ok 30 - No sockets in /tmp/postgresql-testsuite/ 286s ok 31 - pg_ctlcluster 18 main stop 286s ok 32 - pg_ctlcluster fails with corrupted PID file 286s ok 33 - pg_lsclusters -h 286s ok 34 - cluster is still online 286s ok 35 - pg_ctlcluster succeeds with restored PID file 286s ok 36 - pg_lsclusters -h 286s ok 37 - cluster is down 286s ok 38 - pg_ctlcluster 18 main stop 286s ok 39 - pg_ctlcluster stop fails on stopped cluster 287s ok 40 - pg_ctlcluster 18 main start 287s ok 41 - pg_ctlcluster succeeds with already existing PID file 287s ok 42 - pg_lsclusters -h 287s ok 43 - cluster is online 287s ok 44 - pg_ctlcluster stop succeeds 287s ok 45 - pg_lsclusters -h 287s ok 46 - cluster is down 287s ok 47 - no pid file left 287s ok 48 - pg_ctlcluster 18 main stop 287s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 287s ok 50 - pid file was cleaned up 287s ok 51 - pg_ctlcluster --force 18 main stop 287s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 287s ok 53 - pid file was cleaned up 287s ok 54 - pg_ctlcluster 18 main stop 287s ok 55 - pg_ctlcluster stop succeeds with stale PID file 287s ok 56 - pid file was cleaned up 287s ok 57 - pg_ctlcluster --force 18 main stop 287s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 287s ok 59 - pid file was cleaned up 288s ok 60 - pg_ctlcluster --force 18 main stop 288s ok 61 - pg_ctlcluster stop succeeds with empty PID file 288s ok 62 - pid file was cleaned up 290s ok 63 - pg_ctlcluster 18 main start 290s ok 64 - pg_ctlcluster succeeds with corrupted PID file 290s ok 65 - pg_lsclusters -h 290s ok 66 - cluster is online 290s ok 67 - pg_ctlcluster 18 main start 290s ok 68 - pg_ctlcluster start fails on running cluster 290s ok 69 - pg_ctlcluster stop 290s ok 70 - pg_ctlcluster 18 main start 290s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 290s ok 72 - pg_ctlcluster 18 main stop 290s ok 73 - stopping cluster 296s ok 74 - pg_ctlcluster 18 main start 296s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 297s ok 76 - pg_ctlcluster 18 main stop 297s ok 77 - stopping cluster 297s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 297s ok 79 - pg_dropcluster 18 main 297s ok 80 - pg_dropcluster works as user postgres 298s ok 81 - pg_createcluster succeeds 298s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 298s ok 83 - proper error message for nonexisting /var/lib/postgresql 300s ok 84 - pg_ctlcluster 18 main start 300s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 300s ok 86 - pg_ctlcluster 18 main stop 300s ok 87 - stopping cluster 301s ok 88 - pg_createcluster other 303s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 305s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 305s ok 91 305s ok 92 - pg_ctlcluster 18 other start 305s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 306s ok 94 - pg_ctlcluster 18 main stop 306s ok 95 - stopping main cluster 308s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 310s ok 97 - pg_dropcluster other 310s ok 98 - pg_dropcluster 310s ok 99 - No sockets any more 310s ok 100 - 'pg_lsclusters 4.5 foo' fails 310s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 310s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 311s ok 103 - 'psql --cluster 4.5/foo' fails 311s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 311s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 311s ok 106 - 'psql --cluster 18/foo' fails 311s ok 107 - psql --cluster 18/foo gives error message about nonexisting cluster 311s ok 108 - psql --cluster 18/foo does not print 'invalid symbolic link' gibberish 311s ok 109 - 'pg_dropcluster 4.5 foo' fails 311s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 311s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 311s ok 112 - 'pg_dropcluster 18 foo' fails 311s ok 113 - pg_dropcluster 18 foo gives error message about nonexisting cluster 311s ok 114 - pg_dropcluster 18 foo does not print 'invalid symbolic link' gibberish 311s ok 115 - 'pg_upgradecluster 4.5 foo' fails 311s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 311s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 311s ok 118 - 'pg_upgradecluster 18 foo' fails 311s ok 119 - pg_upgradecluster 18 foo gives error message about nonexisting cluster 311s ok 120 - pg_upgradecluster 18 foo does not print 'invalid symbolic link' gibberish 311s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 311s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 311s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 311s ok 124 - 'pg_ctlcluster 18 foo stop' fails 311s ok 125 - pg_ctlcluster 18 foo stop gives error message about nonexisting cluster 311s ok 126 - pg_ctlcluster 18 foo stop does not print 'invalid symbolic link' gibberish 311s # Cleanup 311s ok 127 - Cleanup: No clusters left behind 311s ok 128 - No postgres processes left behind 311s ok 129 - No files in /etc/postgresql left behind 311s ok 130 - No files in /var/lib/postgresql left behind 311s ok 131 - No files in /var/run/postgresql left behind 311s ok 132 - No files in /var/log/postgresql left behind 311s ok 133 - PostgreSQL TCP ports are closed 311s ok 134 - Next free port is 5432 312s ok 135 - pg_dropcluster 18 broken 312s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 312s # Cleanup 312s ok 137 - Cleanup: No clusters left behind 312s ok 138 - No postgres processes left behind 312s ok 139 - No files in /etc/postgresql left behind 312s ok 140 - No files in /var/lib/postgresql left behind 312s ok 141 - No files in /var/run/postgresql left behind 312s ok 142 - No files in /var/log/postgresql left behind 312s ok 143 - PostgreSQL TCP ports are closed 312s ok 144 - Next free port is 5432 313s ok 145 - pg_dropcluster 18 broken 313s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 313s ok 147 - /etc/postgresql/18 was removed 313s ok 148 - /var/lib/postgresql/18 was removed 313s # Cleanup 313s ok 149 - Cleanup: No clusters left behind 313s ok 150 - No postgres processes left behind 313s ok 151 - No files in /etc/postgresql left behind 313s ok 152 - No files in /var/lib/postgresql left behind 313s ok 153 - No files in /var/run/postgresql left behind 313s ok 154 - No files in /var/log/postgresql left behind 313s ok 155 - PostgreSQL TCP ports are closed 313s ok 156 - Next free port is 5432 313s ### End test 030_errors.t ### 313s 313s ### PostgreSQL test 031_errors_disk_full.t ### 313s 1..22 313s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 315s ok 1 - script failed 315s ok 2 - pg_createcluster fails due to insufficient disk space 315s ok 3 - does not leave files behind 315s # Cleanup 315s ok 4 - Cleanup: No clusters left behind 315s ok 5 - No postgres processes left behind 315s ok 6 - No files in /etc/postgresql left behind 315s ok 7 - No files in /var/lib/postgresql left behind 315s ok 8 - No files in /var/run/postgresql left behind 315s ok 9 - No files in /var/log/postgresql left behind 315s ok 10 - PostgreSQL TCP ports are closed 315s ok 11 - Next free port is 5432 315s # check disk full conditions on startup 317s ok 12 - script failed 317s ok 13 - pg_ctlcluster prints error message 317s ok 14 - log file has error message 317s # Cleanup 317s ok 15 - Cleanup: No clusters left behind 317s ok 16 - No postgres processes left behind 317s ok 17 - No files in /etc/postgresql left behind 317s ok 18 - No files in /var/lib/postgresql left behind 317s ok 19 - No files in /var/run/postgresql left behind 317s ok 20 - No files in /var/log/postgresql left behind 317s ok 21 - PostgreSQL TCP ports are closed 317s ok 22 - Next free port is 5432 317s ### End test 031_errors_disk_full.t ### 317s 317s ### PostgreSQL test 032_ssl_key_permissions.t ### 317s 1..22 317s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 317s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 317s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 318s ok 4 - pg_createcluster 18 main 318s ok 5 - pg_ctlcluster 18 main start 318s ok 6 - ssl key owned by nobody refused 318s ok 7 - pg_ctlcluster 18 main start 318s ok 8 - ssl key with permissions root:root 0644 refused 319s ok 9 - pg_ctlcluster 18 main start 319s ok 10 - ssl key with permissions postgres:postgres 0640 refused 320s ok 11 - pg_dropcluster 18 main --stop 320s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 320s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 320s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 320s # Cleanup 320s ok 15 - Cleanup: No clusters left behind 320s ok 16 - No postgres processes left behind 320s ok 17 - No files in /etc/postgresql left behind 320s ok 18 - No files in /var/lib/postgresql left behind 320s ok 19 - No files in /var/run/postgresql left behind 320s ok 20 - No files in /var/log/postgresql left behind 320s ok 21 - PostgreSQL TCP ports are closed 320s ok 22 - Next free port is 5432 320s ### End test 032_ssl_key_permissions.t ### 320s 320s ### PostgreSQL test 040_upgrade.t ### 320s 1..1 320s ok 1 - only one major version installed, skipping upgrade tests 320s ### End test 040_upgrade.t ### 320s 320s ### PostgreSQL test 041_upgrade_custompaths.t ### 320s 1..1 320s ok 1 - only one major version installed, skipping upgrade tests 320s ### End test 041_upgrade_custompaths.t ### 320s 320s ### PostgreSQL test 042_upgrade_rename.t ### 320s 1..15 320s # PostgreSQL 18 323s ok 1 - pg_createcluster 18 main --start 329s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/18/bin -v 18 --rename upgr 18 main 329s ok 3 - pg_lsclusters -h 329s ok 4 - correct output of pg_lsclusters -h 330s ok 5 - pg_dropcluster 18 main --stop 332s ok 6 - pg_dropcluster 18 upgr --stop 332s ok 7 - Cleaning pg_upgrade log files 332s # Cleanup 332s ok 8 - Cleanup: No clusters left behind 332s ok 9 - No postgres processes left behind 332s ok 10 - No files in /etc/postgresql left behind 332s ok 11 - No files in /var/lib/postgresql left behind 332s ok 12 - No files in /var/run/postgresql left behind 332s ok 13 - No files in /var/log/postgresql left behind 332s ok 14 - PostgreSQL TCP ports are closed 332s ok 15 - Next free port is 5432 332s ### End test 042_upgrade_rename.t ### 332s 332s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 332s 1..1 332s ok 1 - only one major version installed, skipping upgrade tests 332s ### End test 043_upgrade_ssl_cert.t ### 332s 332s ### PostgreSQL test 045_backup.t ### 332s # We are running systemd 332s # PostgreSQL 18 332s # create cluster 335s ok 1 - pg_createcluster --locale en_US.UTF-8 18 main --start 335s ok 2 - pg_lsclusters -h 335s ok 3 - correct output of pg_lsclusters -h 335s ok 4 - pg_conftool 18 main set work_mem 11MB 335s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 335s ok 6 - psql -c 'alter database mydb set search_path=public' 335s ok 7 - psql -c 'create table foo (t text)' mydb 335s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 335s ok 9 - psql -c 'CREATE USER myuser' 335s ok 10 - psql -c 'grant create on database mydb to myuser' 335s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 335s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 335s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 335s # create directory 335s ok 14 - pg_backupcluster 18 main createdirectory 335s ok 15 - /var/backups/postgresql/18-main owned by uid postgres 335s ok 16 - /var/backups/postgresql/18-main owned by gid postgres 335s # dump 336s ok 17 - systemctl start pg_dump@18-main 336s ok 18 - dump created in /var/backups/postgresql/18-main/2025-11-19T082855Z.dump 336s ok 19 - /var/backups/postgresql/18-main/2025-11-19T082855Z.dump owned by uid postgres 336s ok 20 - /var/backups/postgresql/18-main/2025-11-19T082855Z.dump owned by gid postgres 336s # basebackup 336s ok 21 - systemctl start pg_receivewal@18-main 336s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 337s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [000000010000000000000002.gz.partial] 337s not ok 23 - /var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 337s # Failed test '/var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial' 337s # at t/TestLib.pm line 171. 337s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 337s ok 25 - psql -c 'select pg_reload_conf()' 365s ok 26 - systemctl start pg_basebackup@18-main 365s ok 27 - dump created in /var/backups/postgresql/18-main/2025-11-19T082857Z.backup 365s ok 28 - /var/backups/postgresql/18-main/2025-11-19T082857Z.backup owned by uid postgres 365s ok 29 - /var/backups/postgresql/18-main/2025-11-19T082857Z.backup owned by gid postgres 365s # list 365s ok 30 - pg_backupcluster 18 main list 365s ok 31 - correct output of pg_backupcluster 18 main list 365s # more database changes 365s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 365s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 365s ok 34 - retrieve recovery timestamp 365s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 366s ok 36 - systemctl stop pg_receivewal@18-main 366s # restore /var/backups/postgresql/18-main/2025-11-19T082855Z.dump 367s ok 37 - pg_dropcluster 18 main --stop 371s ok 38 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-19T082855Z.dump --start --datadir /var/lib/postgresql/18/snowflake 371s ok 39 - pg_lsclusters -h 371s ok 40 - correct output of pg_lsclusters -h 371s ok 41 - psql -XAtl 371s ok 42 - mydb locales 371s ok 43 - mydb grants 371s ok 44 - myicudb locales 371s ok 45 - psql -XAtc 'show work_mem' 371s ok 46 - correct output of psql -XAtc 'show work_mem' 371s ok 47 - psql -XAtc 'select * from foo' mydb 371s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 371s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 371s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 371s ok 51 - psql -XAtc '\drds' 371s ok 52 - correct output of psql -XAtc '\drds' 371s # restore /var/backups/postgresql/18-main/2025-11-19T082857Z.backup 373s ok 53 - pg_dropcluster 18 main --stop 376s ok 54 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-19T082857Z.backup --start --datadir /var/lib/postgresql/18/snowflake 376s ok 55 - pg_lsclusters -h 376s ok 56 - correct output of pg_lsclusters -h 376s ok 57 - psql -XAtl 376s ok 58 - mydb locales 376s ok 59 - mydb grants 376s ok 60 - myicudb locales 376s ok 61 - psql -XAtc 'show work_mem' 376s ok 62 - correct output of psql -XAtc 'show work_mem' 376s ok 63 - psql -XAtc 'select * from foo' mydb 376s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 377s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 377s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 377s ok 67 - psql -XAtc '\drds' 377s ok 68 - correct output of psql -XAtc '\drds' 377s # restore /var/backups/postgresql/18-main/2025-11-19T082857Z.backup with WAL archive 378s ok 69 - pg_dropcluster 18 main --stop 381s ok 70 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-19T082857Z.backup --start --archive --port 5430 381s ok 71 - pg_lsclusters -h 381s ok 72 - correct output of pg_lsclusters -h 382s ok 73 - psql -XAtc 'select * from foo order by t' mydb 382s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 382s # restore /var/backups/postgresql/18-main/2025-11-19T082857Z.backup with PITR 383s ok 75 - pg_dropcluster 18 main --stop 386s ok 76 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-19T082857Z.backup --start --pitr '2025-11-19 08:29:25.37196+00 386s # ' 387s ok 77 - pg_lsclusters -h 387s ok 78 - correct output of pg_lsclusters -h 387s ok 79 - psql -XAtc 'select * from foo order by t' mydb 387s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 388s ok 81 - pg_dropcluster 18 main --stop 388s # Cleanup 388s ok 82 - Cleanup: No clusters left behind 388s ok 83 - No postgres processes left behind 388s ok 84 - No files in /etc/postgresql left behind 388s ok 85 - No files in /var/lib/postgresql left behind 388s ok 86 - No files in /var/run/postgresql left behind 388s ok 87 - No files in /var/log/postgresql left behind 388s ok 88 - PostgreSQL TCP ports are closed 388s ok 89 - Next free port is 5432 388s 1..89 388s ### End test 045_backup.t ### 388s 388s ### PostgreSQL test 050_encodings.t ### 388s 1..60 388s # Checking 18 ru_RU 391s ok 1 - pg_createcluster version 18 for ru_RU without --encoding succeeded 392s ok 2 - psql -l succeeds 392s ok 3 - template1 is not UTF-8 encoded 392s ok 4 - creating test database 393s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 393s # create table t (x varchar); copy t from stdin" test 393s ok 6 - creating table with ISO-8859-5 characters 393s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 393s ok 8 - correct string in UTF-8 393s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 393s ok 10 - correct string in ISO-8859-5 393s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 393s # delete from t; copy t from stdin" test 393s ok 12 - creating table with UTF-8 characters 393s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 393s ok 14 - correct string in UTF-8 393s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 393s ok 16 - correct string in ISO-8859-1 393s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 393s ok 18 - Server error message has correct language and encoding 395s ok 19 - pg_ctlcluster 18 ru_RU restart 395s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 397s ok 21 - Dropping cluster 397s # Checking 18 ru_RU.UTF-8 400s ok 22 - pg_createcluster version 18 for ru_RU.UTF-8 without --encoding succeeded 401s ok 23 - psql -l succeeds 401s ok 24 - template1 is UTF-8 encoded 401s ok 25 - creating test database 401s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 401s # create table t (x varchar); copy t from stdin" test 401s ok 27 - creating table with ISO-8859-5 characters 401s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 401s ok 29 - correct string in UTF-8 401s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 401s ok 31 - correct string in ISO-8859-5 401s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 401s # delete from t; copy t from stdin" test 401s ok 33 - creating table with UTF-8 characters 401s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 401s ok 35 - correct string in UTF-8 401s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 401s ok 37 - correct string in ISO-8859-1 401s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 401s ok 39 - Server error message has correct language and encoding 404s ok 40 - pg_ctlcluster 18 ru_RU.UTF8 restart 404s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 404s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 404s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 404s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 404s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 404s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 404s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 405s ok 48 - Dropping cluster 405s # Check 18 locale environment variables 408s ok 49 - pg_createcluster: LC_ALL dominates LANG 408s ok 50 - psql -Atl --cluster 18/main 408s ok 51 - template1 is ASCII encoded 410s ok 52 - Dropping cluster 410s # Cleanup 410s ok 53 - Cleanup: No clusters left behind 410s ok 54 - No postgres processes left behind 410s ok 55 - No files in /etc/postgresql left behind 410s ok 56 - No files in /var/lib/postgresql left behind 410s ok 57 - No files in /var/run/postgresql left behind 410s ok 58 - No files in /var/log/postgresql left behind 410s ok 59 - PostgreSQL TCP ports are closed 410s ok 60 - Next free port is 5432 410s ### End test 050_encodings.t ### 410s 410s ### PostgreSQL test 052_upgrade_encodings.t ### 410s 1..1 410s ok 1 - only one major version installed, skipping upgrade tests 410s ### End test 052_upgrade_encodings.t ### 410s 410s ### PostgreSQL test 060_obsolete_confparams.t ### 410s ok 1 - only one major version installed, skipping upgrade tests 410s 1..1 410s ### End test 060_obsolete_confparams.t ### 410s 410s ### PostgreSQL test 070_non_postgres_clusters.t ### 410s 1..40 411s ok 1 - pg_createcluster 18 main for owner nobody 411s ok 2 - pg_ctlcluster 18 main start 411s ok 3 - start refused when config and data owners mismatch 413s ok 4 - pg_ctlcluster succeeds with owner nobody 413s ok 5 - pg_lsclusters -h 413s ok 6 - pg_lsclusters shows running cluster 413s ok 7 - postgres is running as user nobody 413s ok 8 - ls /tmp/.s.PGSQL.* 413s ok 9 - socket is in /tmp 413s ok 10 - /var/run/postgresql is empty 413s ok 11 - conf dir is owned by user 413s ok 12 - conf dir is owned by user's primary group 413s ok 13 - files are owned by user 413s ok 14 - files are owned by user's primary group 413s ok 15 - log file has 0640 permissions 413s ok 16 - log file is owned by user 413s ok 17 - log file is owned by user's primary group 413s ok 18 - only one major version installed, skipping upgrade test 413s ok 19 - ... 413s ok 20 - ... 413s ok 21 - ... 413s ok 22 - ... 413s ok 23 - ... 413s ok 24 - ... 413s ok 25 - ... 413s ok 26 - ... 413s ok 27 - ... 413s ok 28 - ... 415s ok 29 - pg_dropcluster 415s ok 30 - pg_lsclusters -h 415s ok 31 - No clusters left 415s ok 32 - No postgres processes left 415s # Cleanup 415s ok 33 - Cleanup: No clusters left behind 415s ok 34 - No postgres processes left behind 415s ok 35 - No files in /etc/postgresql left behind 415s ok 36 - No files in /var/lib/postgresql left behind 415s ok 37 - No files in /var/run/postgresql left behind 415s ok 38 - No files in /var/log/postgresql left behind 415s ok 39 - PostgreSQL TCP ports are closed 415s ok 40 - Next free port is 5432 415s ### End test 070_non_postgres_clusters.t ### 415s 415s ### PostgreSQL test 080_start.conf.t ### 415s 1..73 416s ok 1 - pg_createcluster 18 main 416s # start.conf auto 416s ok 2 - get_cluster_start_conf returns auto 416s ok 3 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 416s ok 4 - start.conf contains auto 416s ok 5 - systemd generator links cluster 416s ok 6 - systemd generator links correct service file 418s ok 7 - /etc/init.d/postgresql start 18 418s ok 8 - correct output of /etc/init.d/postgresql start 18 418s ok 9 - pg_lsclusters -h 418s ok 10 - cluster is online 418s ok 11 - /etc/init.d/postgresql stop 18 418s ok 12 - correct output of /etc/init.d/postgresql stop 18 421s ok 13 - pg_lsclusters -h 421s ok 14 - cluster is down 421s # start.conf manual 421s ok 15 - get_cluster_start_conf returns manual 421s ok 16 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 421s ok 17 - start.conf contains manual 421s ok 18 - systemd generator doesn't link cluster 421s ok 19 - /etc/init.d/postgresql start 18 421s ok 20 - correct output of /etc/init.d/postgresql start 18 422s ok 21 - pg_lsclusters -h 422s ok 22 - cluster is down 424s ok 23 - pg_ctlcluster 18 main start 424s ok 24 - correct output of pg_ctlcluster 18 main start 424s ok 25 - pg_lsclusters -h 424s ok 26 - cluster is online 424s ok 27 - pg_ctlcluster 18 main stop 424s ok 28 - correct output of pg_ctlcluster 18 main stop 424s ok 29 - pg_lsclusters -h 424s ok 30 - cluster is down 424s # start.conf disabled 424s ok 31 - get_cluster_start_conf returns disabled 424s ok 32 - systemd generator doesn't link cluster 424s ok 33 - /etc/init.d/postgresql start 18 424s ok 34 - correct output of /etc/init.d/postgresql start 18 424s ok 35 - pg_lsclusters -h 424s ok 36 - cluster is down 424s ok 37 - pg_ctlcluster 18 main start 424s ok 38 - correct output of pg_ctlcluster 18 main start 424s ok 39 - pg_lsclusters -h 424s ok 40 - cluster is down 427s ok 41 - pg_ctlcluster 18 main start 427s ok 42 - correct output of pg_ctlcluster 18 main start 427s ok 43 - pg_lsclusters -h 427s ok 44 - cluster is online 427s ok 45 - pg_ctlcluster 18 main stop 427s ok 46 - correct output of pg_ctlcluster 18 main stop 427s ok 47 - pg_lsclusters -h 427s ok 48 - cluster is down 429s ok 49 - pg_ctlcluster 18 main start 429s ok 50 - correct output of pg_ctlcluster 18 main start 429s ok 51 - pg_lsclusters -h 429s ok 52 - cluster is online 429s # test upgrade 429s ok 53 - only one major version installed, skipping upgrade test 429s ok 54 - ... 429s ok 55 - get_cluster_start_conf for old cluster returns manual 429s ok 56 - get_cluster_start_conf for new cluster returns manual 429s ok 57 - ... 430s ok 58 - dropping upgraded cluster 430s ok 59 - pg_lsclusters -h 430s ok 60 - no clusters any more 430s ok 61 - pg_createcluster 18 main --start-conf foo 430s ok 62 - pg_createcluster checks --start-conf validity 431s ok 63 - pg_createcluster checks --start-conf manual 431s ok 64 - get_cluster_start_conf returns manual 432s ok 65 - dropping cluster 432s # Cleanup 432s ok 66 - Cleanup: No clusters left behind 432s ok 67 - No postgres processes left behind 432s ok 68 - No files in /etc/postgresql left behind 432s ok 69 - No files in /var/lib/postgresql left behind 432s ok 70 - No files in /var/run/postgresql left behind 432s ok 71 - No files in /var/log/postgresql left behind 432s ok 72 - PostgreSQL TCP ports are closed 432s ok 73 - Next free port is 5432 432s ### End test 080_start.conf.t ### 432s 432s ### PostgreSQL test 085_pg_ctl.conf.t ### 432s 1..33 432s ok 1 - prlimit --core=0:unlimited --pid=17950 432s ok 2 - set core file size to unlimited 432s ok 3 - sh -c 'ulimit -Hc' 432s ok 4 - core file size is unlimited 433s ok 5 - pg_createcluster 18 main 433s ok 6 - /etc/postgresql/18/main/pg_ctl.conf exists 435s ok 7 - pg_ctlcluster 18 main start 435s ok 8 - starting cluster as root 435s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 435s ok 10 - soft core size is 0 435s # hard core file size limit of root-started postgres process is unlimited 435s ok 11 - set pg_ctl default option to -c 438s ok 12 - pg_ctlcluster 18 main restart 438s ok 13 - restarting cluster as root 438s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 438s ok 15 - soft core size is unlimited 438s ok 16 - pg_ctlcluster 18 main stop 438s ok 17 - stopping cluster 438s ok 18 - restored pg_ctl default option 440s ok 19 - pg_ctlcluster 18 main start -- -c 440s ok 20 - starting cluster with -c on the command line as postgres 440s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 440s ok 22 - soft core size is unlimited 440s ok 23 - pg_ctlcluster 18 main stop 440s ok 24 - stopping cluster 441s ok 25 - dropping cluster 441s # Cleanup 442s ok 26 - Cleanup: No clusters left behind 442s ok 27 - No postgres processes left behind 442s ok 28 - No files in /etc/postgresql left behind 442s ok 29 - No files in /var/lib/postgresql left behind 442s ok 30 - No files in /var/run/postgresql left behind 442s ok 31 - No files in /var/log/postgresql left behind 442s ok 32 - PostgreSQL TCP ports are closed 442s ok 33 - Next free port is 5432 442s ### End test 085_pg_ctl.conf.t ### 442s 442s ### PostgreSQL test 090_multicluster.t ### 442s 1..125 442s ok 1 - pg_createcluster 18 old 443s ok 2 - pg_createcluster 18 new1 444s ok 3 - pg_createcluster 18 new2 447s ok 4 - starting cluster 18/old 449s ok 5 - starting cluster 18/new1 451s ok 6 - starting cluster 18/new2 451s ok 7 - pg_lsclusters -h | sort -k3 451s ok 8 - clusters have the correct ports, skipping used 5433 451s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 451s ok 10 - createdb --version 451s ok 11 - pg_wrapper selects port 5432 as default cluster 451s ok 12 - createdb --cluster 18/new1 --version 451s ok 13 - pg_wrapper --cluster works 451s ok 14 - createdb --cluster 18/foo --version 451s ok 15 - pg_wrapper --cluster errors out for invalid cluster 451s ok 16 - createdb --cluster 18/new1 test 451s ok 17 - correct output of createdb --cluster 18/new1 test 451s ok 18 - psql -Atl --cluster 18/new1 451s ok 19 - test db appears in cluster new1 451s ok 20 - psql -Atl --cluster 18/new2 451s ok 21 - test db does not appear in cluster new2 451s ok 22 - psql -Atl 451s ok 23 - test db does not appear in default cluster 451s ok 24 - psql --cluster 18/127.0.0.1: -Atc 'show port' template1 451s ok 25 - psql --cluster 18/127.0.0.1: defaults to port 5432 451s ok 26 - createdb --cluster 18/127.0.0.1:5432 --version 451s ok 27 - createdb --cluster 18/127.0.0.1:5432 uses latest client version 452s ok 28 - psql -Atl --cluster 18/localhost:5434 452s ok 29 - test db appears in cluster 18/localhost:5434 452s ok 30 - psql -Atl --cluster 18/localhost:5440 452s ok 31 - test db does not appear in cluster 18/localhost:5440 452s ok 32 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:5435 452s ok 33 - psql --cluster 18/localhost:5435 fails due to nonexisting port 452s ok 34 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:a 452s ok 35 - psql --cluster 18/localhost:a fails due to invalid syntax 452s ok 36 - LC_MESSAGES=C psql -Atl --cluster 18/doesnotexi.st 452s ok 37 - psql --cluster 18/doesnotexi.st fails due to invalid syntax 452s ok 38 - psql -Atl --cluster 6.4/localhost: 452s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 452s ok 40 - psql -Atl 452s ok 41 - PGCLUSTER selection (1) 452s ok 42 - psql -Atl 452s ok 43 - PGCLUSTER selection (2) 452s ok 44 - psql -l 452s ok 45 - invalid PGCLUSTER value 452s ok 46 - createdb --version 452s ok 47 - PGCLUSTER network cluster selection (1) 452s ok 48 - psql -Atl 452s ok 49 - PGCLUSTER network cluster selection (2) 452s ok 50 - psql -Atl 452s ok 51 - PGCLUSTER network cluster selection (3) 452s ok 52 - LC_MESSAGES=C psql -Atl 452s ok 53 - psql --cluster 18/localhost:5435 fails due to nonexisting port 452s ok 54 - psql -Atc "show port" template1 452s ok 55 - PGPORT selection (1) 452s ok 56 - psql -Atc "show port" template1 452s ok 57 - PGPORT selection (2) 452s ok 58 - createdb --version 452s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 452s ok 60 - psql -Atc "show port" template1 452s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 452s ok 62 - psql --cluster 18/new1 -Atc 'select current_database()' 452s ok 63 - PGDATABASE environment variable works 452s ok 64 - createdb --version 452s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 452s ok 66 - createdb --cluster 18/new1 --version 452s ok 67 - pg_wrapper --cluster works with empty user_clusters 452s ok 68 - createdb --version 452s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 18 new1 *' 452s ok 70 - psql -Atc "select current_database()" 452s ok 71 - pg_wrapper selects correct database with user_clusters '* * 18 new1 test' 452s ok 72 - psql -Atc 'select current_database()' 452s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 452s ok 74 - createdb --version 452s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 452s ok 76 - createdb --version 452s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 452s ok 78 - createdb --version 452s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 452s ok 80 - createdb --version 452s ok 81 - pg_wrapper selects correct version with per-user user_clusters 452s ok 82 - createdb --version 452s ok 83 - pg_wrapper selects correct version with per-user user_clusters 453s ok 84 - createdb --version 453s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 453s ok 86 - psql -Atl 453s ok 87 - $PGHOST overrides user_clusters 453s ok 88 - psql --cluster 18/localhost:5434 -Atc 'select current_database()' test 453s ok 89 - --cluster overrides $PGHOST 453s ok 90 - createdb --version 453s ok 91 - pg_wrapper ignores invalid lines in user_clusters 453s ok 92 - psql -Atc 'select current_database()' 453s ok 93 - pg_service conf selection 1 453s ok 94 - psql -Atc 'select current_database()' 453s ok 95 - pg_service conf selection 2 453s ok 96 - psql -Atc 'select current_database()' 453s ok 97 - pg_service conf selection 3 453s ok 98 - stopping cluster 18/old 455s ok 99 - restarting cluster 18/old 455s ok 100 # skip rust coreutils sort -k option regression. See LP: #2125504 455s ok 101 # skip rust coreutils sort -k option regression. See LP: #2125504 455s ok 102 - psql -l 455s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 455s ok 104 - psql -Atl --cluster 18/new1 455s ok 105 - --cluster selects appropriate cluster 455s ok 106 - psql -Atl -p 5434 455s ok 107 - -p selects appropriate cluster 455s ok 108 - psql -Atlp 5434 455s ok 109 - -Atlp selects appropriate cluster 455s ok 110 - psql -Atl --port 5434 455s ok 111 - --port selects appropriate cluster 455s ok 112 - env PGPORT=5434 psql -Atl 455s ok 113 - $PGPORT selects appropriate cluster 455s ok 114 - Restoring original /etc/postgresql-common/user_clusters 457s ok 115 - dropping 18/new1 458s ok 116 - dropping 18/new2 460s ok 117 - dropping 18/old 460s # Cleanup 460s ok 118 - Cleanup: No clusters left behind 460s ok 119 - No postgres processes left behind 460s ok 120 - No files in /etc/postgresql left behind 460s ok 121 - No files in /var/lib/postgresql left behind 460s ok 122 - No files in /var/run/postgresql left behind 460s ok 123 - No files in /var/log/postgresql left behind 460s ok 124 - PostgreSQL TCP ports are closed 460s ok 125 - Next free port is 5432 460s ### End test 090_multicluster.t ### 460s 460s ### PostgreSQL test 110_integrate_cluster.t ### 460s 1..32 460s ok 1 - /usr/lib/postgresql/18/bin/initdb /tmp/t5ZHovbsUy/c/postgres 460s ok 2 - creating raw initdb cluster for user postgres 461s ok 3 - pg_createcluster 18 postgres -d /tmp/t5ZHovbsUy/c/postgres 461s ok 4 - integrating postgres cluster 461s ok 5 - pg_lsclusters 461s ok 6 - correct pg_lsclusters output 463s ok 7 - pg_ctlcluster 18 postgres start 463s ok 8 - starting cluster postgres 463s ok 9 - pg_lsclusters 463s ok 10 - correct pg_lsclusters output 464s ok 11 - dropping cluster postgres 464s ok 12 - No files in temporary cluster dir left behind 465s ok 13 - /usr/lib/postgresql/18/bin/initdb /tmp/t5ZHovbsUy/c/nobody 465s ok 14 - creating raw initdb cluster for user nobody 465s ok 15 - pg_createcluster 18 nobody -d /tmp/t5ZHovbsUy/c/nobody 465s ok 16 - integrating nobody cluster 465s ok 17 - pg_lsclusters 465s ok 18 - correct pg_lsclusters output 468s ok 19 - pg_ctlcluster 18 nobody start 468s ok 20 - starting cluster nobody 468s ok 21 - pg_lsclusters 468s ok 22 - correct pg_lsclusters output 469s ok 23 - dropping cluster nobody 469s ok 24 - No files in temporary cluster dir left behind 469s # Cleanup 469s ok 25 - Cleanup: No clusters left behind 469s ok 26 - No postgres processes left behind 469s ok 27 - No files in /etc/postgresql left behind 469s ok 28 - No files in /var/lib/postgresql left behind 469s ok 29 - No files in /var/run/postgresql left behind 469s ok 30 - No files in /var/log/postgresql left behind 469s ok 31 - PostgreSQL TCP ports are closed 469s ok 32 - Next free port is 5432 469s ### End test 110_integrate_cluster.t ### 469s 469s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 469s 1..1 469s ok 1 - only one major version installed, skipping upgrade tests 469s ### End test 120_pg_upgradecluster_scripts.t ### 469s 469s ### PostgreSQL test 130_nonroot_admin.t ### 469s 1..22 472s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 472s ok 2 - pg_lsclusters -h 472s ok 3 - correct output of pg_lsclusters -h 472s ok 4 - psql -Atl 472s ok 5 - correct output of psql -Atl 472s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 472s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 472s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 472s # Cleanup 472s ok 15 - Cleanup: No clusters left behind 473s ok 16 - No postgres processes left behind 473s ok 17 - No files in /etc/postgresql left behind 473s ok 18 - No files in /var/lib/postgresql left behind 473s ok 19 - No files in /var/run/postgresql left behind 473s ok 20 - No files in /var/log/postgresql left behind 473s ok 21 - PostgreSQL TCP ports are closed 473s ok 22 - Next free port is 5432 473s ### End test 130_nonroot_admin.t ### 473s 473s ### PostgreSQL test 135_pg_virtualenv.t ### 473s 1..20 477s ok 1 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 477s ok 2 - running pg_virtualenv as root 480s ok 3 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 480s ok 4 - running pg_virtualenv as postgres 483s ok 5 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 483s ok 6 - running pg_virtualenv as nobody 486s ok 7 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 486s ok 8 - running fakeroot pg_virtualenv as root 489s ok 9 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 489s ok 10 - running fakeroot pg_virtualenv as postgres 493s ok 11 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 493s ok 12 - running fakeroot pg_virtualenv as nobody 493s # Cleanup 493s ok 13 - Cleanup: No clusters left behind 493s ok 14 - No postgres processes left behind 493s ok 15 - No files in /etc/postgresql left behind 493s ok 16 - No files in /var/lib/postgresql left behind 493s ok 17 - No files in /var/run/postgresql left behind 493s ok 18 - No files in /var/log/postgresql left behind 493s ok 19 - PostgreSQL TCP ports are closed 493s ok 20 - Next free port is 5432 493s ### End test 135_pg_virtualenv.t ### 493s 493s ### PostgreSQL test 140_pg_config.t ### 493s 1..38 493s # Multiarch is enabled 493s # checking version specific output for 18 493s ok 1 - /usr/lib/postgresql/18/bin/pg_config --pgxs 493s ok 2 - correct output of /usr/lib/postgresql/18/bin/pg_config --pgxs 493s ok 3 - /usr/lib/postgresql/18/bin/pg_config --libdir 493s ok 4 - correct output of /usr/lib/postgresql/18/bin/pg_config --libdir 493s ok 5 - /usr/lib/postgresql/18/bin/pg_config --pkglibdir 493s ok 6 - correct output of /usr/lib/postgresql/18/bin/pg_config --pkglibdir 493s ok 7 - /usr/lib/postgresql/18/bin/pg_config --bindir 493s ok 8 - correct output of /usr/lib/postgresql/18/bin/pg_config --bindir 493s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 493s # checking pg_config output (should behave like version 18) 493s ok 15 - pg_config 493s ok 16 - correct output of pg_config 493s ok 17 - pg_config --help 493s ok 18 - correct output of pg_config --help 493s ok 19 - pg_config --pgxs 493s ok 20 - correct output of pg_config --pgxs 493s ok 21 - pg_config --libdir 493s ok 22 - correct output of pg_config --libdir 493s ok 23 - pg_config --pkglibdir 493s ok 24 - correct output of pg_config --pkglibdir 493s ok 25 - pg_config --bindir 493s ok 26 - correct output of pg_config --bindir 493s # checking pg_config.libpq-dev output (should behave like version 18) 493s ok 27 - pg_config.libpq-dev 493s ok 28 - correct output of pg_config.libpq-dev 493s ok 29 - pg_config.libpq-dev --help 493s ok 30 - correct output of pg_config.libpq-dev --help 493s ok 31 - pg_config.libpq-dev --pgxs 493s ok 32 - correct output of pg_config.libpq-dev --pgxs 493s ok 33 - pg_config.libpq-dev --libdir 493s ok 34 - correct output of pg_config.libpq-dev --libdir 493s ok 35 - pg_config.libpq-dev --pkglibdir 493s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 493s ok 37 - pg_config.libpq-dev --bindir 493s ok 38 - correct output of pg_config.libpq-dev --bindir 493s ### End test 140_pg_config.t ### 493s 493s ### PostgreSQL test 150_tsearch_stemming.t ### 493s 1..37 493s ok 1 - pg_updatedicts succeeded 493s ok 2 - pg_updatedicts created en_us.affix 493s ok 3 - pg_updatedicts created en_us.dict 493s ok 4 - pg_updatedicts created 18 en_us.affix symlink 493s ok 5 - pg_updatedicts created 18 en_us.dict symlink 496s ok 6 - pg_createcluster 18 main 496s ok 7 - createdb fts 496s ok 8 - correct output of createdb fts 496s ok 9 - creating en_US full text search configuration 497s ok 10 - creating data table and search index 497s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 497s ok 12 - stem search of correct word 497s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 497s ok 14 - stem search of correct word 497s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 497s ok 16 - stem search of unknown word 497s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 497s ok 18 - full text search, exact word 497s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 497s ok 20 - full text search for word stem 497s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 497s ok 22 - full text search for word substring fails 497s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 497s ok 24 - full text search, exact unicode word 497s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 497s ok 26 - full text search for unicode word stem 497s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 497s ok 28 - full text search for unicode word substring fails 499s ok 29 499s # Cleanup 499s ok 30 - Cleanup: No clusters left behind 499s ok 31 - No postgres processes left behind 499s ok 32 - No files in /etc/postgresql left behind 499s ok 33 - No files in /var/lib/postgresql left behind 499s ok 34 - No files in /var/run/postgresql left behind 499s ok 35 - No files in /var/log/postgresql left behind 499s ok 36 - PostgreSQL TCP ports are closed 499s ok 37 - Next free port is 5432 499s ### End test 150_tsearch_stemming.t ### 499s 499s ### PostgreSQL test 160_alternate_confroot.t ### 499s 1..28 502s ok 1 502s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 502s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 502s ok 4 - pg_lsclusters -h 502s ok 5 - correct output of pg_lsclusters -h 502s ok 6 - psql -Atl 502s ok 7 - correct output of psql -Atl 502s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 502s ok 9 - ... 502s ok 10 - ... 502s ok 11 - ... 502s ok 12 - ... 502s ok 13 - ... 502s ok 14 - ... 503s ok 15 - pg_dropcluster 18 test --stop 503s ok 16 - correct output of pg_dropcluster 18 test --stop 503s ok 17 - pg_lsclusters -h 503s ok 18 - correct output of pg_lsclusters -h 503s ok 19 - No files in root/data left behind 503s ok 20 - No cruft in root dir left behind 503s # Cleanup 503s ok 21 - Cleanup: No clusters left behind 503s ok 22 - No postgres processes left behind 503s ok 23 - No files in /etc/postgresql left behind 503s ok 24 - No files in /var/lib/postgresql left behind 503s ok 25 - No files in /var/run/postgresql left behind 503s ok 26 - No files in /var/log/postgresql left behind 503s ok 27 - PostgreSQL TCP ports are closed 503s ok 28 - Next free port is 5432 503s ### End test 160_alternate_confroot.t ### 503s 503s ### PostgreSQL test 170_extensions.t ### 503s # Running tests for 18 507s ok 1 - pg_createcluster 18 main 507s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 507s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 507s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 507s ok 5 - extension amcheck installs without error 507s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 507s ok 7 - extension amcheck removes without error 507s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 507s ok 9 - extension autoinc installs without error 507s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 507s ok 11 - extension autoinc removes without error 507s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 507s ok 13 - extension bloom installs without error 507s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 507s ok 15 - extension bloom removes without error 507s ok 16 - psql -qc 'CREATE EXTENSION plperl' 507s ok 17 - bool_plperl dependency plperl installs without error 507s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 507s ok 19 - extension bool_plperl installs without error 507s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 507s ok 21 - extension bool_plperl removes without error 507s ok 22 - psql -qc 'DROP EXTENSION plperl' 507s ok 23 - bool_plperl dependency extension plperl removes without error 507s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 507s ok 25 - bool_plperlu dependency plperlu installs without error 507s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 507s ok 27 - extension bool_plperlu installs without error 507s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 507s ok 29 - extension bool_plperlu removes without error 507s ok 30 - psql -qc 'DROP EXTENSION plperlu' 507s ok 31 - bool_plperlu dependency extension plperlu removes without error 507s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 507s ok 33 - extension btree_gin installs without error 507s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 507s ok 35 - extension btree_gin removes without error 507s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 507s ok 37 - extension btree_gist installs without error 507s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 507s ok 39 - extension btree_gist removes without error 507s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 507s ok 41 - extension citext installs without error 508s ok 42 - psql -qc 'DROP EXTENSION "citext"' 508s ok 43 - extension citext removes without error 508s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 508s ok 45 - extension cube installs without error 508s ok 46 - psql -qc 'DROP EXTENSION "cube"' 508s ok 47 - extension cube removes without error 508s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 508s ok 49 - extension dblink installs without error 508s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 508s ok 51 - extension dblink removes without error 508s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 508s ok 53 - extension dict_int installs without error 508s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 508s ok 55 - extension dict_int removes without error 508s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 508s ok 57 - extension dict_xsyn installs without error 508s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 508s ok 59 - extension dict_xsyn removes without error 508s ok 60 - psql -qc 'CREATE EXTENSION cube' 508s ok 61 - earthdistance dependency cube installs without error 508s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 508s ok 63 - extension earthdistance installs without error 508s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 508s ok 65 - extension earthdistance removes without error 508s ok 66 - psql -qc 'DROP EXTENSION cube' 508s ok 67 - earthdistance dependency extension cube removes without error 508s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 508s ok 69 - extension file_fdw installs without error 508s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 508s ok 71 - extension file_fdw removes without error 508s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 508s ok 73 - extension fuzzystrmatch installs without error 508s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 508s ok 75 - extension fuzzystrmatch removes without error 508s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 508s ok 77 - extension hstore installs without error 508s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 508s ok 79 - extension hstore removes without error 508s ok 80 - psql -qc 'CREATE EXTENSION hstore' 508s ok 81 - hstore_plperl dependency hstore installs without error 508s ok 82 - psql -qc 'CREATE EXTENSION plperl' 508s ok 83 - hstore_plperl dependency plperl installs without error 508s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 508s ok 85 - extension hstore_plperl installs without error 508s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 508s ok 87 - extension hstore_plperl removes without error 509s ok 88 - psql -qc 'DROP EXTENSION hstore' 509s ok 89 - hstore_plperl dependency extension hstore removes without error 509s ok 90 - psql -qc 'DROP EXTENSION plperl' 509s ok 91 - hstore_plperl dependency extension plperl removes without error 509s ok 92 - psql -qc 'CREATE EXTENSION hstore' 509s ok 93 - hstore_plperlu dependency hstore installs without error 509s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 509s ok 95 - hstore_plperlu dependency plperlu installs without error 509s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 509s ok 97 - extension hstore_plperlu installs without error 509s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 509s ok 99 - extension hstore_plperlu removes without error 509s ok 100 - psql -qc 'DROP EXTENSION hstore' 509s ok 101 - hstore_plperlu dependency extension hstore removes without error 509s ok 102 - psql -qc 'DROP EXTENSION plperlu' 509s ok 103 - hstore_plperlu dependency extension plperlu removes without error 509s ok 104 - psql -qc 'CREATE EXTENSION hstore' 509s ok 105 - hstore_plpython3u dependency hstore installs without error 509s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 509s ok 107 - hstore_plpython3u dependency plpython3u installs without error 509s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 509s ok 109 - extension hstore_plpython3u installs without error 509s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 509s ok 111 - extension hstore_plpython3u removes without error 509s ok 112 - psql -qc 'DROP EXTENSION hstore' 509s ok 113 - hstore_plpython3u dependency extension hstore removes without error 509s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 509s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 509s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 509s ok 117 - extension insert_username installs without error 509s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 509s ok 119 - extension insert_username removes without error 509s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 509s ok 121 - extension intagg installs without error 509s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 509s ok 123 - extension intagg removes without error 509s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 509s ok 125 - extension intarray installs without error 509s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 509s ok 127 - extension intarray removes without error 509s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 509s ok 129 - extension isn installs without error 509s ok 130 - psql -qc 'DROP EXTENSION "isn"' 510s ok 131 - extension isn removes without error 510s ok 132 - psql -qc 'CREATE EXTENSION plperl' 510s ok 133 - jsonb_plperl dependency plperl installs without error 510s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 510s ok 135 - extension jsonb_plperl installs without error 510s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 510s ok 137 - extension jsonb_plperl removes without error 510s ok 138 - psql -qc 'DROP EXTENSION plperl' 510s ok 139 - jsonb_plperl dependency extension plperl removes without error 510s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 510s ok 141 - jsonb_plperlu dependency plperlu installs without error 510s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 510s ok 143 - extension jsonb_plperlu installs without error 510s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 510s ok 145 - extension jsonb_plperlu removes without error 510s ok 146 - psql -qc 'DROP EXTENSION plperlu' 510s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 510s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 510s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 510s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 510s ok 151 - extension jsonb_plpython3u installs without error 510s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 510s ok 153 - extension jsonb_plpython3u removes without error 510s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 510s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 510s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 510s ok 157 - extension lo installs without error 510s ok 158 - psql -qc 'DROP EXTENSION "lo"' 510s ok 159 - extension lo removes without error 510s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 510s ok 161 - extension ltree installs without error 510s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 510s ok 163 - extension ltree removes without error 510s ok 164 - psql -qc 'CREATE EXTENSION ltree' 510s ok 165 - ltree_plpython3u dependency ltree installs without error 510s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 510s ok 167 - ltree_plpython3u dependency plpython3u installs without error 510s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 510s ok 169 - extension ltree_plpython3u installs without error 510s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 510s ok 171 - extension ltree_plpython3u removes without error 510s ok 172 - psql -qc 'DROP EXTENSION ltree' 510s ok 173 - ltree_plpython3u dependency extension ltree removes without error 510s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 510s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 510s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 510s ok 177 - extension moddatetime installs without error 511s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 511s ok 179 - extension moddatetime removes without error 511s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 511s ok 181 - extension pageinspect installs without error 511s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 511s ok 183 - extension pageinspect removes without error 511s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 511s ok 185 - extension pg_buffercache installs without error 511s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 511s ok 187 - extension pg_buffercache removes without error 511s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 511s ok 189 - extension pg_freespacemap installs without error 511s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 511s ok 191 - extension pg_freespacemap removes without error 511s ok 192 - psql -qc 'CREATE EXTENSION "pg_logicalinspect"' 511s ok 193 - extension pg_logicalinspect installs without error 511s ok 194 - psql -qc 'DROP EXTENSION "pg_logicalinspect"' 511s ok 195 - extension pg_logicalinspect removes without error 511s ok 196 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 511s ok 197 - extension pg_prewarm installs without error 511s ok 198 - psql -qc 'DROP EXTENSION "pg_prewarm"' 511s ok 199 - extension pg_prewarm removes without error 511s ok 200 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 511s ok 201 - extension pg_stat_statements installs without error 511s ok 202 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 511s ok 203 - extension pg_stat_statements removes without error 511s ok 204 - psql -qc 'CREATE EXTENSION "pg_surgery"' 511s ok 205 - extension pg_surgery installs without error 511s ok 206 - psql -qc 'DROP EXTENSION "pg_surgery"' 511s ok 207 - extension pg_surgery removes without error 511s ok 208 - psql -qc 'CREATE EXTENSION "pg_trgm"' 511s ok 209 - extension pg_trgm installs without error 511s ok 210 - psql -qc 'DROP EXTENSION "pg_trgm"' 511s ok 211 - extension pg_trgm removes without error 511s ok 212 - psql -qc 'CREATE EXTENSION "pg_visibility"' 511s ok 213 - extension pg_visibility installs without error 511s ok 214 - psql -qc 'DROP EXTENSION "pg_visibility"' 511s ok 215 - extension pg_visibility removes without error 511s ok 216 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 511s ok 217 - extension pg_walinspect installs without error 511s ok 218 - psql -qc 'DROP EXTENSION "pg_walinspect"' 511s ok 219 - extension pg_walinspect removes without error 511s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 511s ok 221 - extension pgcrypto installs without error 511s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 511s ok 223 - extension pgcrypto removes without error 511s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 511s ok 225 - extension pgrowlocks installs without error 511s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 511s ok 227 - extension pgrowlocks removes without error 512s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 512s ok 229 - extension pgstattuple installs without error 512s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 512s ok 231 - extension pgstattuple removes without error 512s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 512s ok 233 - extension plperl installs without error 512s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 512s ok 235 - extension plperl removes without error 512s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 512s ok 237 - extension plperlu installs without error 512s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 512s ok 239 - extension plperlu removes without error 512s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 512s ok 241 - extension plpython3u installs without error 512s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 512s ok 243 - extension plpython3u removes without error 512s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 512s ok 245 - extension pltcl installs without error 512s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 512s ok 247 - extension pltcl removes without error 512s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 512s ok 249 - extension pltclu installs without error 512s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 512s ok 251 - extension pltclu removes without error 512s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 512s ok 253 - extension postgres_fdw installs without error 512s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 512s ok 255 - extension postgres_fdw removes without error 512s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 512s ok 257 - extension refint installs without error 512s ok 258 - psql -qc 'DROP EXTENSION "refint"' 512s ok 259 - extension refint removes without error 512s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 512s ok 261 - extension seg installs without error 512s ok 262 - psql -qc 'DROP EXTENSION "seg"' 512s ok 263 - extension seg removes without error 512s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 512s ok 265 - extension sslinfo installs without error 512s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 512s ok 267 - extension sslinfo removes without error 513s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 513s ok 269 - extension tablefunc installs without error 513s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 513s ok 271 - extension tablefunc removes without error 513s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 513s ok 273 - extension tcn installs without error 513s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 513s ok 275 - extension tcn removes without error 513s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 513s ok 277 - extension tsm_system_rows installs without error 513s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 513s ok 279 - extension tsm_system_rows removes without error 513s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 513s ok 281 - extension tsm_system_time installs without error 513s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 513s ok 283 - extension tsm_system_time removes without error 513s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 513s ok 285 - extension unaccent installs without error 513s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 513s ok 287 - extension unaccent removes without error 513s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 513s ok 289 - extension uuid-ossp installs without error 513s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 513s ok 291 - extension uuid-ossp removes without error 513s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 513s ok 293 - extension xml2 installs without error 513s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 513s ok 295 - extension xml2 removes without error 515s ok 296 - pg_dropcluster 18 main 515s # Cleanup 515s ok 297 - Cleanup: No clusters left behind 515s ok 298 - No postgres processes left behind 515s ok 299 - No files in /etc/postgresql left behind 515s ok 300 - No files in /var/lib/postgresql left behind 515s ok 301 - No files in /var/run/postgresql left behind 515s ok 302 - No files in /var/log/postgresql left behind 515s ok 303 - PostgreSQL TCP ports are closed 515s ok 304 - Next free port is 5432 515s 1..304 515s ### End test 170_extensions.t ### 515s 515s ### PostgreSQL test 180_ecpg.t ### 515s 1..14 515s ok 1 - ecpg test.pgc 515s ok 2 - ecpg processing 515s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 515s ok 4 - compiling ecpg output 522s ok 5 - pg_virtualenv /tmp/tmp.SXVOnq2M43/test 522s ok 6 - test program runs and gives correct output 522s # Cleanup 522s ok 7 - Cleanup: No clusters left behind 522s ok 8 - No postgres processes left behind 522s ok 9 - No files in /etc/postgresql left behind 522s ok 10 - No files in /var/lib/postgresql left behind 522s ok 11 - No files in /var/run/postgresql left behind 522s ok 12 - No files in /var/log/postgresql left behind 522s ok 13 - PostgreSQL TCP ports are closed 522s ok 14 - Next free port is 5432 522s ### End test 180_ecpg.t ### 522s 522s ### PostgreSQL test 190_pg_buildext.t ### 522s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 522s 1..1 522s ### End test 190_pg_buildext.t ### 522s 522s ### PostgreSQL test 200_maintscripts.t ### 522s 1..15 522s # We are running systemd 525s ok 1 - pg_createcluster 18 main --start 525s ok 2 - postmaster PID is 23372 527s ok 3 - apt-get update -q 527s # postgresql-common: 527s # Installed: 282ubuntu1 527s # Candidate: 282ubuntu1 527s # Version table: 527s # *** 282ubuntu1 500 527s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 527s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 527s # 100 /var/lib/dpkg/status 529s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 529s # postgresql-common: 529s # Installed: 282ubuntu1 529s # Candidate: 282ubuntu1 529s # Version table: 529s # *** 282ubuntu1 500 529s # 500 http://ftpmaster.internal/ubuntu resolute/main amd64 Packages 529s # 500 http://ftpmaster.internal/ubuntu resolute/main i386 Packages 529s # 100 /var/lib/dpkg/status 529s ok 5 - postmaster PID is 23372 529s ok 6 - postmaster was not restarted 531s ok 7 - pg_dropcluster 18 main --stop 531s # Cleanup 531s ok 8 - Cleanup: No clusters left behind 531s ok 9 - No postgres processes left behind 531s ok 10 - No files in /etc/postgresql left behind 531s ok 11 - No files in /var/lib/postgresql left behind 531s ok 12 - No files in /var/run/postgresql left behind 531s ok 13 - No files in /var/log/postgresql left behind 531s ok 14 - PostgreSQL TCP ports are closed 531s ok 15 - Next free port is 5432 531s ### End test 200_maintscripts.t ### 531s 532s autopkgtest [08:32:12]: test run-testsuite: -----------------------] 532s autopkgtest [08:32:12]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 532s run-testsuite PASS 533s autopkgtest [08:32:13]: test installcheck: preparing testbed 554s Creating nova instance adt-resolute-amd64-postgresql-18-20251119-082320-juju-7f2275-prod-proposed-migration-environment-15-98cbe719-fe88-46d2-bfd1-aed3fa72fb0f from image adt/ubuntu-resolute-amd64-server-20251119.img (UUID fc1a7209-2cef-4daf-9d3e-e01e6f7c6db2)... 615s autopkgtest [08:33:35]: testbed dpkg architecture: amd64 615s autopkgtest [08:33:35]: testbed apt version: 3.1.12 616s autopkgtest [08:33:36]: @@@@@@@@@@@@@@@@@@@@ test bed setup 616s autopkgtest [08:33:36]: testbed release detected to be: resolute 617s autopkgtest [08:33:37]: updating testbed package index (apt update) 617s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 617s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 617s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 617s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 617s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 617s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [823 kB] 618s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.8 kB] 618s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [67.3 kB] 618s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 Packages [138 kB] 618s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main i386 Packages [96.8 kB] 618s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 c-n-f Metadata [3028 B] 618s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 Packages [64.9 kB] 618s Get:13 http://ftpmaster.internal/ubuntu resolute-proposed/restricted i386 Packages [4040 B] 618s Get:14 http://ftpmaster.internal/ubuntu resolute-proposed/restricted amd64 c-n-f Metadata [336 B] 618s Get:15 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 Packages [556 kB] 618s Get:16 http://ftpmaster.internal/ubuntu resolute-proposed/universe i386 Packages [239 kB] 618s Get:17 http://ftpmaster.internal/ubuntu resolute-proposed/universe amd64 c-n-f Metadata [18.5 kB] 618s Get:18 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 Packages [13.7 kB] 618s Get:19 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse i386 Packages [6880 B] 618s Get:20 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse amd64 c-n-f Metadata [680 B] 620s Fetched 2153 kB in 1s (1991 kB/s) 621s Reading package lists... 622s Hit:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease 622s Hit:2 http://ftpmaster.internal/ubuntu resolute InRelease 622s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 622s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 623s Reading package lists... 623s Reading package lists... 623s Building dependency tree... 623s Reading state information... 623s Calculating upgrade... 623s The following packages will be upgraded: 623s dhcpcd-base libnss-systemd libpam-systemd libsystemd-shared libsystemd0 623s libudev1 python3-requests systemd systemd-cryptsetup systemd-resolved 623s systemd-sysv udev 623s 12 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 623s Need to get 9041 kB of archives. 623s After this operation, 1782 kB of additional disk space will be used. 623s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd0 amd64 259~rc1-1ubuntu1 [542 kB] 624s Get:2 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-sysv amd64 259~rc1-1ubuntu1 [9256 B] 624s Get:3 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-resolved amd64 259~rc1-1ubuntu1 [298 kB] 624s Get:4 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libnss-systemd amd64 259~rc1-1ubuntu1 [183 kB] 624s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libpam-systemd amd64 259~rc1-1ubuntu1 [272 kB] 624s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libsystemd-shared amd64 259~rc1-1ubuntu1 [2512 kB] 625s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd amd64 259~rc1-1ubuntu1 [3125 kB] 625s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 systemd-cryptsetup amd64 259~rc1-1ubuntu1 [124 kB] 625s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 udev amd64 259~rc1-1ubuntu1 [1483 kB] 625s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 libudev1 amd64 259~rc1-1ubuntu1 [212 kB] 625s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/main amd64 dhcpcd-base amd64 1:10.3.0-1 [228 kB] 626s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 python3-requests all 2.32.5+dfsg-1ubuntu1 [53.1 kB] 626s dpkg-preconfigure: unable to re-open stdin: No such file or directory 626s Fetched 9041 kB in 2s (3864 kB/s) 626s (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 ... 82963 files and directories currently installed.) 626s Preparing to unpack .../libsystemd0_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking libsystemd0:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Setting up libsystemd0:amd64 (259~rc1-1ubuntu1) ... 626s (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 ... 82963 files and directories currently installed.) 626s Preparing to unpack .../systemd-sysv_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking systemd-sysv (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Preparing to unpack .../systemd-resolved_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking systemd-resolved (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Preparing to unpack .../libnss-systemd_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking libnss-systemd:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Preparing to unpack .../libpam-systemd_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking libpam-systemd:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Preparing to unpack .../libsystemd-shared_259~rc1-1ubuntu1_amd64.deb ... 626s Unpacking libsystemd-shared:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 626s Setting up libsystemd-shared:amd64 (259~rc1-1ubuntu1) ... 627s (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 ... 82962 files and directories currently installed.) 627s Preparing to unpack .../systemd_259~rc1-1ubuntu1_amd64.deb ... 627s Unpacking systemd (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 627s Preparing to unpack .../systemd-cryptsetup_259~rc1-1ubuntu1_amd64.deb ... 627s Unpacking systemd-cryptsetup (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 627s Preparing to unpack .../udev_259~rc1-1ubuntu1_amd64.deb ... 627s Unpacking udev (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 627s Preparing to unpack .../libudev1_259~rc1-1ubuntu1_amd64.deb ... 627s Unpacking libudev1:amd64 (259~rc1-1ubuntu1) over (257.9-0ubuntu2) ... 627s Setting up libudev1:amd64 (259~rc1-1ubuntu1) ... 627s (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 ... 83045 files and directories currently installed.) 627s Preparing to unpack .../dhcpcd-base_1%3a10.3.0-1_amd64.deb ... 627s Unpacking dhcpcd-base (1:10.3.0-1) over (1:10.2.4-4) ... 627s Preparing to unpack .../python3-requests_2.32.5+dfsg-1ubuntu1_all.deb ... 627s Unpacking python3-requests (2.32.5+dfsg-1ubuntu1) over (2.32.3+dfsg-5ubuntu2) ... 627s Setting up systemd (259~rc1-1ubuntu1) ... 627s Installing new version of config file /etc/systemd/journald.conf ... 627s Installing new version of config file /etc/systemd/logind.conf ... 627s Installing new version of config file /etc/systemd/networkd.conf ... 627s Installing new version of config file /etc/systemd/system.conf ... 627s Installing new version of config file /etc/systemd/user.conf ... 627s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 627s /usr/lib/tmpfiles.d/legacy.conf:14: Duplicate line for path "/run/lock", ignoring. 628s Setting up systemd-cryptsetup (259~rc1-1ubuntu1) ... 628s Setting up python3-requests (2.32.5+dfsg-1ubuntu1) ... 628s Setting up udev (259~rc1-1ubuntu1) ... 629s Setting up dhcpcd-base (1:10.3.0-1) ... 629s Installing new version of config file /etc/dhcpcd.conf ... 629s Creating group 'dhcpcd' with GID 986. 629s Setting up systemd-resolved (259~rc1-1ubuntu1) ... 629s Installing new version of config file /etc/systemd/resolved.conf ... 629s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-monitor.socket' → '/usr/lib/systemd/system/systemd-resolved-monitor.socket'. 629s Created symlink '/etc/systemd/system/sockets.target.wants/systemd-resolved-varlink.socket' → '/usr/lib/systemd/system/systemd-resolved-varlink.socket'. 630s Setting up systemd-sysv (259~rc1-1ubuntu1) ... 630s Setting up libnss-systemd:amd64 (259~rc1-1ubuntu1) ... 630s Setting up libpam-systemd:amd64 (259~rc1-1ubuntu1) ... 630s Processing triggers for libc-bin (2.42-2ubuntu2) ... 630s Processing triggers for man-db (2.13.1-1) ... 631s Processing triggers for dbus (1.16.2-2ubuntu2) ... 631s Processing triggers for shared-mime-info (2.4-5build2) ... 633s Processing triggers for procps (2:4.0.4-8ubuntu3) ... 633s Processing triggers for initramfs-tools (0.150ubuntu5) ... 633s update-initramfs: Generating /boot/initrd.img-6.17.0-5-generic 640s autopkgtest [08:34:00]: upgrading testbed (apt dist-upgrade and autopurge) 640s Reading package lists... 640s Building dependency tree... 640s Reading state information... 640s Calculating upgrade... 640s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 641s Reading package lists... 641s Building dependency tree... 641s Reading state information... 641s Solving dependencies... 641s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 641s autopkgtest [08:34:01]: rebooting testbed after setup commands that affected boot 664s Reading package lists... 665s Building dependency tree... 665s Reading state information... 665s Solving dependencies... 665s The following NEW packages will be installed: 665s build-essential clang-21 cpp cpp-15 cpp-15-x86-64-linux-gnu 665s cpp-x86-64-linux-gnu g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu 665s gcc gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 665s libclang-common-21-dev libclang-cpp21 libclang1-21 libecpg-compat3 665s libecpg-dev libecpg6 libffi-dev libgc1 libgcc-15-dev libgomp1 libhwasan0 665s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl libllvm21 665s liblsan0 liblzma-dev libmpc3 libncurses-dev libobjc-15-dev libobjc4 libpfm4 665s libpgtypes3 libpq-dev libpq-oauth libpq5 libquadmath0 libssl-dev 665s libstdc++-15-dev libtcl8.6 libtsan2 libubsan1 liburing2 libxml2-dev 665s libxslt1.1 llvm-21 llvm-21-dev llvm-21-linker-tools llvm-21-runtime 665s llvm-21-tools postgresql-18 postgresql-18-jit postgresql-client-18 665s postgresql-client-common postgresql-common postgresql-common-dev 665s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 665s postgresql-pltcl-18 postgresql-server-dev-18 ssl-cert tzdata-legacy 665s zlib1g-dev 665s 0 upgraded, 72 newly installed, 0 to remove and 0 not upgraded. 665s Need to get 231 MB of archives. 665s After this operation, 1110 MB of additional disk space will be used. 665s Get:1 http://ftpmaster.internal/ubuntu resolute/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 665s Get:2 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-client-common all 282ubuntu1 [48.8 kB] 665s Get:3 http://ftpmaster.internal/ubuntu resolute/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 665s Get:4 http://ftpmaster.internal/ubuntu resolute/main amd64 libipc-run-perl all 20250809.0-1 [94.4 kB] 665s Get:5 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common-dev all 282ubuntu1 [73.9 kB] 666s Get:6 http://ftpmaster.internal/ubuntu resolute/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 666s Get:7 http://ftpmaster.internal/ubuntu resolute/main amd64 postgresql-common all 282ubuntu1 [101 kB] 666s Get:8 http://ftpmaster.internal/ubuntu resolute/main amd64 libisl23 amd64 0.27-1 [685 kB] 666s Get:9 http://ftpmaster.internal/ubuntu resolute/main amd64 libmpc3 amd64 1.3.1-2 [54.8 kB] 666s Get:10 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [12.9 MB] 669s Get:11 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-15 amd64 15.2.0-8ubuntu1 [1030 B] 669s Get:12 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 669s Get:13 http://ftpmaster.internal/ubuntu resolute/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 669s Get:14 http://ftpmaster.internal/ubuntu resolute/main amd64 libcc1-0 amd64 15.2.0-8ubuntu1 [47.4 kB] 669s Get:15 http://ftpmaster.internal/ubuntu resolute/main amd64 libgomp1 amd64 15.2.0-8ubuntu1 [151 kB] 669s Get:16 http://ftpmaster.internal/ubuntu resolute/main amd64 libitm1 amd64 15.2.0-8ubuntu1 [29.7 kB] 669s Get:17 http://ftpmaster.internal/ubuntu resolute/main amd64 libasan8 amd64 15.2.0-8ubuntu1 [3071 kB] 670s Get:18 http://ftpmaster.internal/ubuntu resolute/main amd64 liblsan0 amd64 15.2.0-8ubuntu1 [1360 kB] 670s Get:19 http://ftpmaster.internal/ubuntu resolute/main amd64 libtsan2 amd64 15.2.0-8ubuntu1 [2757 kB] 670s Get:20 http://ftpmaster.internal/ubuntu resolute/main amd64 libubsan1 amd64 15.2.0-8ubuntu1 [1210 kB] 670s Get:21 http://ftpmaster.internal/ubuntu resolute/main amd64 libhwasan0 amd64 15.2.0-8ubuntu1 [1685 kB] 670s Get:22 http://ftpmaster.internal/ubuntu resolute/main amd64 libquadmath0 amd64 15.2.0-8ubuntu1 [153 kB] 670s Get:23 http://ftpmaster.internal/ubuntu resolute/main amd64 libgcc-15-dev amd64 15.2.0-8ubuntu1 [2864 kB] 671s Get:24 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [25.4 MB] 674s Get:25 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-15 amd64 15.2.0-8ubuntu1 [525 kB] 676s Get:26 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 676s Get:27 http://ftpmaster.internal/ubuntu resolute/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 676s Get:28 http://ftpmaster.internal/ubuntu resolute/main amd64 libstdc++-15-dev amd64 15.2.0-8ubuntu1 [2573 kB] 676s Get:29 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-8ubuntu1 [14.4 MB] 676s Get:30 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-15 amd64 15.2.0-8ubuntu1 [24.1 kB] 676s Get:31 http://ftpmaster.internal/ubuntu resolute/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 676s Get:32 http://ftpmaster.internal/ubuntu resolute/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 676s Get:33 http://ftpmaster.internal/ubuntu resolute/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 676s Get:34 http://ftpmaster.internal/ubuntu resolute/main amd64 libllvm21 amd64 1:21.1.2-2ubuntu6 [30.7 MB] 676s Get:35 http://ftpmaster.internal/ubuntu resolute/main amd64 libclang-cpp21 amd64 1:21.1.2-2ubuntu6 [13.7 MB] 676s Get:36 http://ftpmaster.internal/ubuntu resolute/main amd64 libgc1 amd64 1:8.2.10-1 [97.9 kB] 676s Get:37 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc4 amd64 15.2.0-8ubuntu1 [47.8 kB] 676s Get:38 http://ftpmaster.internal/ubuntu resolute/universe amd64 libobjc-15-dev amd64 15.2.0-8ubuntu1 [196 kB] 676s Get:39 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang-common-21-dev amd64 1:21.1.2-2ubuntu6 [796 kB] 676s Get:40 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-linker-tools amd64 1:21.1.2-2ubuntu6 [1302 kB] 676s Get:41 http://ftpmaster.internal/ubuntu resolute/universe amd64 libclang1-21 amd64 1:21.1.2-2ubuntu6 [8155 kB] 676s Get:42 http://ftpmaster.internal/ubuntu resolute/universe amd64 clang-21 amd64 1:21.1.2-2ubuntu6 [78.9 kB] 676s Get:43 http://ftpmaster.internal/ubuntu resolute/main amd64 libpgtypes3 amd64 18.1-1 [42.1 kB] 676s Get:44 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq5 amd64 18.1-1 [275 kB] 676s Get:45 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg6 amd64 18.1-1 [59.6 kB] 676s Get:46 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-compat3 amd64 18.1-1 [12.5 kB] 676s Get:47 http://ftpmaster.internal/ubuntu resolute/main amd64 libssl-dev amd64 3.5.3-1ubuntu2 [2936 kB] 676s Get:48 http://ftpmaster.internal/ubuntu resolute/main amd64 libpq-dev amd64 18.1-1 [175 kB] 676s Get:49 http://ftpmaster.internal/ubuntu resolute/main amd64 libecpg-dev amd64 18.1-1 [281 kB] 676s Get:50 http://ftpmaster.internal/ubuntu resolute/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 676s Get:51 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpq-oauth amd64 18.1-1 [34.4 kB] 676s Get:52 http://ftpmaster.internal/ubuntu resolute/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 676s Get:53 http://ftpmaster.internal/ubuntu resolute/main amd64 liburing2 amd64 2.11-1 [24.7 kB] 676s Get:54 http://ftpmaster.internal/ubuntu resolute/main amd64 liblzma-dev amd64 5.8.1-2 [179 kB] 676s Get:55 http://ftpmaster.internal/ubuntu resolute/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 676s Get:56 http://ftpmaster.internal/ubuntu resolute/main amd64 libxml2-dev amd64 2.15.1+dfsg-0.3 [741 kB] 676s Get:57 http://ftpmaster.internal/ubuntu resolute/main amd64 libxslt1.1 amd64 1.1.43-0.3 [172 kB] 676s Get:58 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-runtime amd64 1:21.1.2-2ubuntu6 [565 kB] 676s Get:59 http://ftpmaster.internal/ubuntu resolute/universe amd64 libpfm4 amd64 4.13.0+git106-g3e4031b-1 [438 kB] 676s Get:60 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21 amd64 1:21.1.2-2ubuntu6 [20.0 MB] 676s Get:61 http://ftpmaster.internal/ubuntu resolute/main amd64 libffi-dev amd64 3.5.2-2 [64.5 kB] 676s Get:62 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-tools amd64 1:21.1.2-2ubuntu6 [543 kB] 676s Get:63 http://ftpmaster.internal/ubuntu resolute/universe amd64 llvm-21-dev amd64 1:21.1.2-2ubuntu6 [51.7 MB] 679s Get:64 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-client-18 amd64 18.1-1 [2215 kB] 679s Get:65 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18 amd64 18.1-1 [8208 kB] 680s Get:66 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-18-jit amd64 18.1-1 [10.4 MB] 680s Get:67 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-doc-18 all 18.1-1 [2180 kB] 680s Get:68 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plperl-18 amd64 18.1-1 [71.6 kB] 680s Get:69 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-plpython3-18 amd64 18.1-1 [98.0 kB] 680s Get:70 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-pltcl-18 amd64 18.1-1 [42.5 kB] 680s Get:71 http://ftpmaster.internal/ubuntu resolute/universe amd64 postgresql-server-dev-18 amd64 18.1-1 [1459 kB] 680s Get:72 http://ftpmaster.internal/ubuntu resolute/main amd64 tzdata-legacy all 2025b-5ubuntu1 [99.3 kB] 681s Preconfiguring packages ... 681s Fetched 231 MB in 16s (14.9 MB/s) 681s Selecting previously unselected package libjson-perl. 681s (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 ... 83046 files and directories currently installed.) 681s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 681s Unpacking libjson-perl (4.10000-1) ... 681s Selecting previously unselected package postgresql-client-common. 681s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 681s Unpacking postgresql-client-common (282ubuntu1) ... 681s Selecting previously unselected package libio-pty-perl. 681s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 681s Unpacking libio-pty-perl (1:1.20-1build3) ... 681s Selecting previously unselected package libipc-run-perl. 681s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 681s Unpacking libipc-run-perl (20250809.0-1) ... 681s Selecting previously unselected package postgresql-common-dev. 681s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 681s Unpacking postgresql-common-dev (282ubuntu1) ... 681s Selecting previously unselected package ssl-cert. 681s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 681s Unpacking ssl-cert (1.1.3ubuntu1) ... 681s Selecting previously unselected package postgresql-common. 681s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 681s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 681s Unpacking postgresql-common (282ubuntu1) ... 681s Selecting previously unselected package libisl23:amd64. 681s Preparing to unpack .../07-libisl23_0.27-1_amd64.deb ... 681s Unpacking libisl23:amd64 (0.27-1) ... 681s Selecting previously unselected package libmpc3:amd64. 681s Preparing to unpack .../08-libmpc3_1.3.1-2_amd64.deb ... 681s Unpacking libmpc3:amd64 (1.3.1-2) ... 681s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 681s Preparing to unpack .../09-cpp-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package cpp-15. 681s Preparing to unpack .../10-cpp-15_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking cpp-15 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package cpp-x86-64-linux-gnu. 681s Preparing to unpack .../11-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 681s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 681s Selecting previously unselected package cpp. 681s Preparing to unpack .../12-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 681s Unpacking cpp (4:15.2.0-4ubuntu1) ... 681s Selecting previously unselected package libcc1-0:amd64. 681s Preparing to unpack .../13-libcc1-0_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libcc1-0:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libgomp1:amd64. 681s Preparing to unpack .../14-libgomp1_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libgomp1:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libitm1:amd64. 681s Preparing to unpack .../15-libitm1_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libitm1:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libasan8:amd64. 681s Preparing to unpack .../16-libasan8_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libasan8:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package liblsan0:amd64. 681s Preparing to unpack .../17-liblsan0_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking liblsan0:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libtsan2:amd64. 681s Preparing to unpack .../18-libtsan2_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libtsan2:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libubsan1:amd64. 681s Preparing to unpack .../19-libubsan1_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libubsan1:amd64 (15.2.0-8ubuntu1) ... 681s Selecting previously unselected package libhwasan0:amd64. 681s Preparing to unpack .../20-libhwasan0_15.2.0-8ubuntu1_amd64.deb ... 681s Unpacking libhwasan0:amd64 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package libquadmath0:amd64. 682s Preparing to unpack .../21-libquadmath0_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking libquadmath0:amd64 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package libgcc-15-dev:amd64. 682s Preparing to unpack .../22-libgcc-15-dev_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking libgcc-15-dev:amd64 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 682s Preparing to unpack .../23-gcc-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package gcc-15. 682s Preparing to unpack .../24-gcc-15_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking gcc-15 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package gcc-x86-64-linux-gnu. 682s Preparing to unpack .../25-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 682s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 682s Selecting previously unselected package gcc. 682s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 682s Unpacking gcc (4:15.2.0-4ubuntu1) ... 682s Selecting previously unselected package libstdc++-15-dev:amd64. 682s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking libstdc++-15-dev:amd64 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package g++-15-x86-64-linux-gnu. 682s Preparing to unpack .../28-g++-15-x86-64-linux-gnu_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking g++-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package g++-15. 682s Preparing to unpack .../29-g++-15_15.2.0-8ubuntu1_amd64.deb ... 682s Unpacking g++-15 (15.2.0-8ubuntu1) ... 682s Selecting previously unselected package g++-x86-64-linux-gnu. 682s Preparing to unpack .../30-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 682s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 682s Selecting previously unselected package g++. 682s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 682s Unpacking g++ (4:15.2.0-4ubuntu1) ... 682s Selecting previously unselected package build-essential. 682s Preparing to unpack .../32-build-essential_12.12ubuntu1_amd64.deb ... 682s Unpacking build-essential (12.12ubuntu1) ... 682s Selecting previously unselected package libllvm21:amd64. 682s Preparing to unpack .../33-libllvm21_1%3a21.1.2-2ubuntu6_amd64.deb ... 682s Unpacking libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package libclang-cpp21. 683s Preparing to unpack .../34-libclang-cpp21_1%3a21.1.2-2ubuntu6_amd64.deb ... 683s Unpacking libclang-cpp21 (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package libgc1:amd64. 683s Preparing to unpack .../35-libgc1_1%3a8.2.10-1_amd64.deb ... 683s Unpacking libgc1:amd64 (1:8.2.10-1) ... 683s Selecting previously unselected package libobjc4:amd64. 683s Preparing to unpack .../36-libobjc4_15.2.0-8ubuntu1_amd64.deb ... 683s Unpacking libobjc4:amd64 (15.2.0-8ubuntu1) ... 683s Selecting previously unselected package libobjc-15-dev:amd64. 683s Preparing to unpack .../37-libobjc-15-dev_15.2.0-8ubuntu1_amd64.deb ... 683s Unpacking libobjc-15-dev:amd64 (15.2.0-8ubuntu1) ... 683s Selecting previously unselected package libclang-common-21-dev:amd64. 683s Preparing to unpack .../38-libclang-common-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 683s Unpacking libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package llvm-21-linker-tools. 683s Preparing to unpack .../39-llvm-21-linker-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 683s Unpacking llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package libclang1-21. 683s Preparing to unpack .../40-libclang1-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 683s Unpacking libclang1-21 (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package clang-21. 683s Preparing to unpack .../41-clang-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 683s Unpacking clang-21 (1:21.1.2-2ubuntu6) ... 683s Selecting previously unselected package libpgtypes3:amd64. 683s Preparing to unpack .../42-libpgtypes3_18.1-1_amd64.deb ... 683s Unpacking libpgtypes3:amd64 (18.1-1) ... 683s Selecting previously unselected package libpq5:amd64. 683s Preparing to unpack .../43-libpq5_18.1-1_amd64.deb ... 683s Unpacking libpq5:amd64 (18.1-1) ... 683s Selecting previously unselected package libecpg6:amd64. 683s Preparing to unpack .../44-libecpg6_18.1-1_amd64.deb ... 683s Unpacking libecpg6:amd64 (18.1-1) ... 683s Selecting previously unselected package libecpg-compat3:amd64. 683s Preparing to unpack .../45-libecpg-compat3_18.1-1_amd64.deb ... 683s Unpacking libecpg-compat3:amd64 (18.1-1) ... 683s Selecting previously unselected package libssl-dev:amd64. 683s Preparing to unpack .../46-libssl-dev_3.5.3-1ubuntu2_amd64.deb ... 683s Unpacking libssl-dev:amd64 (3.5.3-1ubuntu2) ... 683s Selecting previously unselected package libpq-dev. 683s Preparing to unpack .../47-libpq-dev_18.1-1_amd64.deb ... 683s Unpacking libpq-dev (18.1-1) ... 683s Selecting previously unselected package libecpg-dev. 683s Preparing to unpack .../48-libecpg-dev_18.1-1_amd64.deb ... 683s Unpacking libecpg-dev (18.1-1) ... 683s Selecting previously unselected package libncurses-dev:amd64. 683s Preparing to unpack .../49-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 683s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 683s Selecting previously unselected package libpq-oauth:amd64. 683s Preparing to unpack .../50-libpq-oauth_18.1-1_amd64.deb ... 683s Unpacking libpq-oauth:amd64 (18.1-1) ... 683s Selecting previously unselected package libtcl8.6:amd64. 683s Preparing to unpack .../51-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 683s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 683s Selecting previously unselected package liburing2:amd64. 684s Preparing to unpack .../52-liburing2_2.11-1_amd64.deb ... 684s Unpacking liburing2:amd64 (2.11-1) ... 684s Selecting previously unselected package liblzma-dev:amd64. 684s Preparing to unpack .../53-liblzma-dev_5.8.1-2_amd64.deb ... 684s Unpacking liblzma-dev:amd64 (5.8.1-2) ... 684s Selecting previously unselected package zlib1g-dev:amd64. 684s Preparing to unpack .../54-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 684s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 684s Selecting previously unselected package libxml2-dev:amd64. 684s Preparing to unpack .../55-libxml2-dev_2.15.1+dfsg-0.3_amd64.deb ... 684s Unpacking libxml2-dev:amd64 (2.15.1+dfsg-0.3) ... 684s Selecting previously unselected package libxslt1.1:amd64. 684s Preparing to unpack .../56-libxslt1.1_1.1.43-0.3_amd64.deb ... 684s Unpacking libxslt1.1:amd64 (1.1.43-0.3) ... 684s Selecting previously unselected package llvm-21-runtime. 684s Preparing to unpack .../57-llvm-21-runtime_1%3a21.1.2-2ubuntu6_amd64.deb ... 684s Unpacking llvm-21-runtime (1:21.1.2-2ubuntu6) ... 684s Selecting previously unselected package libpfm4:amd64. 684s Preparing to unpack .../58-libpfm4_4.13.0+git106-g3e4031b-1_amd64.deb ... 684s Unpacking libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 684s Selecting previously unselected package llvm-21. 684s Preparing to unpack .../59-llvm-21_1%3a21.1.2-2ubuntu6_amd64.deb ... 684s Unpacking llvm-21 (1:21.1.2-2ubuntu6) ... 684s Selecting previously unselected package libffi-dev:amd64. 684s Preparing to unpack .../60-libffi-dev_3.5.2-2_amd64.deb ... 684s Unpacking libffi-dev:amd64 (3.5.2-2) ... 684s Selecting previously unselected package llvm-21-tools. 684s Preparing to unpack .../61-llvm-21-tools_1%3a21.1.2-2ubuntu6_amd64.deb ... 684s Unpacking llvm-21-tools (1:21.1.2-2ubuntu6) ... 684s Selecting previously unselected package llvm-21-dev. 684s Preparing to unpack .../62-llvm-21-dev_1%3a21.1.2-2ubuntu6_amd64.deb ... 684s Unpacking llvm-21-dev (1:21.1.2-2ubuntu6) ... 685s Selecting previously unselected package postgresql-client-18. 685s Preparing to unpack .../63-postgresql-client-18_18.1-1_amd64.deb ... 685s Unpacking postgresql-client-18 (18.1-1) ... 685s Selecting previously unselected package postgresql-18. 685s Preparing to unpack .../64-postgresql-18_18.1-1_amd64.deb ... 685s Unpacking postgresql-18 (18.1-1) ... 686s Selecting previously unselected package postgresql-18-jit. 686s Preparing to unpack .../65-postgresql-18-jit_18.1-1_amd64.deb ... 686s Unpacking postgresql-18-jit (18.1-1) ... 686s Selecting previously unselected package postgresql-doc-18. 686s Preparing to unpack .../66-postgresql-doc-18_18.1-1_all.deb ... 686s Unpacking postgresql-doc-18 (18.1-1) ... 686s Selecting previously unselected package postgresql-plperl-18. 686s Preparing to unpack .../67-postgresql-plperl-18_18.1-1_amd64.deb ... 686s Unpacking postgresql-plperl-18 (18.1-1) ... 686s Selecting previously unselected package postgresql-plpython3-18. 686s Preparing to unpack .../68-postgresql-plpython3-18_18.1-1_amd64.deb ... 686s Unpacking postgresql-plpython3-18 (18.1-1) ... 686s Selecting previously unselected package postgresql-pltcl-18. 686s Preparing to unpack .../69-postgresql-pltcl-18_18.1-1_amd64.deb ... 686s Unpacking postgresql-pltcl-18 (18.1-1) ... 686s Selecting previously unselected package postgresql-server-dev-18. 686s Preparing to unpack .../70-postgresql-server-dev-18_18.1-1_amd64.deb ... 686s Unpacking postgresql-server-dev-18 (18.1-1) ... 686s Selecting previously unselected package tzdata-legacy. 686s Preparing to unpack .../71-tzdata-legacy_2025b-5ubuntu1_all.deb ... 686s Unpacking tzdata-legacy (2025b-5ubuntu1) ... 686s Setting up postgresql-client-common (282ubuntu1) ... 686s Setting up libpgtypes3:amd64 (18.1-1) ... 686s Setting up postgresql-doc-18 (18.1-1) ... 686s 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 686s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 686s Setting up libio-pty-perl (1:1.20-1build3) ... 686s Setting up libpq5:amd64 (18.1-1) ... 686s Setting up libgomp1:amd64 (15.2.0-8ubuntu1) ... 686s Setting up libffi-dev:amd64 (3.5.2-2) ... 686s Setting up tzdata-legacy (2025b-5ubuntu1) ... 686s Setting up libpfm4:amd64 (4.13.0+git106-g3e4031b-1) ... 686s Setting up ssl-cert (1.1.3ubuntu1) ... 687s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 687s Setting up libllvm21:amd64 (1:21.1.2-2ubuntu6) ... 687s Setting up libquadmath0:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libssl-dev:amd64 (3.5.3-1ubuntu2) ... 687s Setting up libmpc3:amd64 (1.3.1-2) ... 687s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 687s Setting up libipc-run-perl (20250809.0-1) ... 687s Setting up llvm-21-linker-tools (1:21.1.2-2ubuntu6) ... 687s Setting up libgc1:amd64 (1:8.2.10-1) ... 687s Setting up liblzma-dev:amd64 (5.8.1-2) ... 687s Setting up libubsan1:amd64 (15.2.0-8ubuntu1) ... 687s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 687s Setting up libhwasan0:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libasan8:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libjson-perl (4.10000-1) ... 687s Setting up libxslt1.1:amd64 (1.1.43-0.3) ... 687s Setting up libecpg6:amd64 (18.1-1) ... 687s Setting up libclang-common-21-dev:amd64 (1:21.1.2-2ubuntu6) ... 687s Setting up libtsan2:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libclang1-21 (1:21.1.2-2ubuntu6) ... 687s Setting up liburing2:amd64 (2.11-1) ... 687s Setting up libisl23:amd64 (0.27-1) ... 687s Setting up libcc1-0:amd64 (15.2.0-8ubuntu1) ... 687s Setting up liblsan0:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libitm1:amd64 (15.2.0-8ubuntu1) ... 687s Setting up postgresql-common-dev (282ubuntu1) ... 687s Setting up libgcc-15-dev:amd64 (15.2.0-8ubuntu1) ... 687s Setting up libecpg-compat3:amd64 (18.1-1) ... 687s Setting up postgresql-client-18 (18.1-1) ... 687s 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 687s Setting up libpq-oauth:amd64 (18.1-1) ... 687s Setting up libpq-dev (18.1-1) ... 687s Setting up libobjc4:amd64 (15.2.0-8ubuntu1) ... 687s Setting up cpp-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 687s Setting up libecpg-dev (18.1-1) ... 687s Setting up gcc-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 687s Setting up libxml2-dev:amd64 (2.15.1+dfsg-0.3) ... 687s Setting up libclang-cpp21 (1:21.1.2-2ubuntu6) ... 687s Setting up libstdc++-15-dev:amd64 (15.2.0-8ubuntu1) ... 687s Setting up llvm-21-tools (1:21.1.2-2ubuntu6) ... 687s Setting up llvm-21-runtime (1:21.1.2-2ubuntu6) ... 687s Setting up postgresql-common (282ubuntu1) ... 688s Creating config file /etc/postgresql-common/createcluster.conf with new version 688s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 688s Removing obsolete dictionary files: 688s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 689s Setting up cpp-15 (15.2.0-8ubuntu1) ... 689s Setting up libobjc-15-dev:amd64 (15.2.0-8ubuntu1) ... 689s Setting up clang-21 (1:21.1.2-2ubuntu6) ... 689s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 689s Setting up g++-15-x86-64-linux-gnu (15.2.0-8ubuntu1) ... 689s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 689s Setting up postgresql-18 (18.1-1) ... 689s Creating new PostgreSQL cluster 18/main ... 689s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 689s The files belonging to this database system will be owned by user "postgres". 689s This user must also own the server process. 689s 689s The database cluster will be initialized with locale "C.UTF-8". 689s The default database encoding has accordingly been set to "UTF8". 689s The default text search configuration will be set to "english". 689s 689s Data page checksums are enabled. 689s 689s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 689s creating subdirectories ... ok 689s selecting dynamic shared memory implementation ... posix 689s selecting default "max_connections" ... 100 689s selecting default "shared_buffers" ... 128MB 689s selecting default time zone ... Etc/UTC 689s creating configuration files ... ok 689s running bootstrap script ... ok 690s performing post-bootstrap initialization ... ok 690s syncing data to disk ... ok 693s Setting up postgresql-18-jit (18.1-1) ... 693s Setting up gcc-15 (15.2.0-8ubuntu1) ... 693s Setting up llvm-21 (1:21.1.2-2ubuntu6) ... 693s Setting up postgresql-plpython3-18 (18.1-1) ... 693s Setting up cpp (4:15.2.0-4ubuntu1) ... 693s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 693s Setting up postgresql-plperl-18 (18.1-1) ... 693s Setting up g++-15 (15.2.0-8ubuntu1) ... 693s Setting up postgresql-pltcl-18 (18.1-1) ... 693s Setting up llvm-21-dev (1:21.1.2-2ubuntu6) ... 693s Setting up postgresql-server-dev-18 (18.1-1) ... 693s Setting up gcc (4:15.2.0-4ubuntu1) ... 693s Setting up g++ (4:15.2.0-4ubuntu1) ... 693s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 693s Setting up build-essential (12.12ubuntu1) ... 693s Processing triggers for libc-bin (2.42-2ubuntu2) ... 693s Processing triggers for systemd (259~rc1-1ubuntu1) ... 693s Processing triggers for man-db (2.13.1-1) ... 695s Processing triggers for install-info (7.2-5) ... 726s autopkgtest [08:35:26]: test installcheck: [----------------------- 726s + dpkg-parsechangelog -SSource 726s + SOURCE=postgresql-18 726s + MAJOR=18 726s + top_srcdir=/tmp/autopkgtest.d1d7KU/build.y43/src 726s + cd src/test/regress 726s + make -f /tmp/autopkgtest.d1d7KU/build.y43/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config with_llvm=no 726s 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.d1d7KU/build.y43/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 727s 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 727s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.d1d7KU/build.y43/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 727s + id -u 727s + [ 1000 = 0 ] 727s + SU=sh 727s + sh 727s + mktemp -d /tmp/regress.XXXXXX 727s + OUTPUT=/tmp/regress.1QburA 727s + trap rm -rf /tmp/regress.1QburA EXIT 727s + pg_virtualenv -v 18 /usr/lib/postgresql/18/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.1QburA --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 728s Creating new PostgreSQL cluster 18/regress ... 730s # using postmaster on localhost, port 5433 730s ok 1 - test_setup 160 ms 731s # parallel group (20 tests): oid char varchar float4 text txid int2 money pg_lsn int4 name float8 regproc int8 enum uuid bit boolean numeric rangetypes 731s ok 2 + boolean 486 ms 731s ok 3 + char 160 ms 731s ok 4 + name 231 ms 731s ok 5 + varchar 163 ms 731s ok 6 + text 204 ms 731s ok 7 + int2 208 ms 731s ok 8 + int4 223 ms 731s ok 9 + int8 268 ms 731s ok 10 + oid 153 ms 731s ok 11 + float4 165 ms 731s ok 12 + float8 231 ms 731s ok 13 + bit 445 ms 731s ok 14 + numeric 590 ms 731s ok 15 + txid 206 ms 731s ok 16 + uuid 343 ms 731s ok 17 + enum 339 ms 731s ok 18 + money 185 ms 731s ok 19 + rangetypes 610 ms 731s ok 20 + pg_lsn 189 ms 731s ok 21 + regproc 222 ms 732s # parallel group (20 tests): md5 lseg circle line time macaddr timetz path numerology macaddr8 inet date strings interval polygon point box timestamp multirangetypes timestamptz 732s ok 22 + strings 358 ms 732s ok 23 + md5 100 ms 732s ok 24 + numerology 174 ms 732s ok 25 + point 418 ms 732s ok 26 + lseg 110 ms 732s ok 27 + line 132 ms 732s ok 28 + box 443 ms 732s ok 29 + path 159 ms 732s ok 30 + polygon 390 ms 732s ok 31 + circle 123 ms 732s ok 32 + date 250 ms 732s ok 33 + time 135 ms 732s ok 34 + timetz 152 ms 732s ok 35 + timestamp 484 ms 732s ok 36 + timestamptz 511 ms 732s ok 37 + interval 378 ms 732s ok 38 + inet 222 ms 732s ok 39 + macaddr 148 ms 732s ok 40 + macaddr8 183 ms 732s ok 41 + multirangetypes 502 ms 732s # parallel group (14 tests): comments misc_sanity unicode tstypes expressions xid mvcc type_sanity stats_import geometry horology opr_sanity database regex 732s ok 42 + geometry 384 ms 732s ok 43 + horology 515 ms 732s ok 44 + tstypes 209 ms 732s ok 45 + regex 603 ms 732s ok 46 + type_sanity 292 ms 732s ok 47 + opr_sanity 541 ms 732s ok 48 + misc_sanity 117 ms 732s ok 49 + comments 102 ms 732s ok 50 + expressions 201 ms 732s ok 51 + unicode 124 ms 732s ok 52 + xid 215 ms 732s ok 53 + mvcc 235 ms 732s ok 54 + database 588 ms 732s ok 55 + stats_import 353 ms 733s # parallel group (6 tests): copyencoding copyselect copydml copy insert_conflict insert 733s ok 56 + copy 147 ms 733s ok 57 + copyselect 57 ms 733s ok 58 + copydml 84 ms 733s ok 59 + copyencoding 48 ms 733s ok 60 + insert 292 ms 733s ok 61 + insert_conflict 162 ms 733s # parallel group (7 tests): create_function_c create_type create_operator create_misc create_schema create_procedure create_table 733s ok 62 + create_function_c 37 ms 733s ok 63 + create_misc 81 ms 733s ok 64 + create_operator 64 ms 733s ok 65 + create_procedure 104 ms 733s ok 66 + create_table 272 ms 733s ok 67 + create_type 58 ms 733s ok 68 + create_schema 87 ms 735s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 735s ok 69 + create_index 580 ms 735s ok 70 + create_index_spgist 447 ms 735s ok 71 + create_view 302 ms 735s ok 72 + index_including 282 ms 735s ok 73 + index_including_gist 299 ms 735s # parallel group (16 tests): create_cast create_aggregate roleattributes errors hash_func select drop_if_exists create_function_sql create_am typed_table infinite_recurse vacuum constraints updatable_views triggers inherit 735s ok 74 + create_aggregate 130 ms 735s ok 75 + create_function_sql 321 ms 735s ok 76 + create_cast 101 ms 735s ok 77 + constraints 953 ms 735s ok 78 + triggers 1129 ms 735s ok 79 + select 230 ms 735s ok 80 + inherit 1169 ms 735s ok 81 + typed_table 340 ms 735s ok 82 + vacuum 793 ms 735s ok 83 + drop_if_exists 238 ms 735s ok 84 + updatable_views 961 ms 735s ok 85 + roleattributes 134 ms 735s ok 86 + create_am 321 ms 735s ok 87 + hash_func 201 ms 735s ok 88 + errors 198 ms 735s ok 89 + infinite_recurse 399 ms 735s ok 90 - sanity_check 63 ms 736s # parallel group (20 tests): select_having delete select_distinct_on select_implicit case select_into namespace prepared_xacts random transactions portals union select_distinct arrays subselect update hash_index aggregates btree_index join 736s ok 91 + select_into 257 ms 736s ok 92 + select_distinct 701 ms 736s ok 93 + select_distinct_on 221 ms 736s ok 94 + select_implicit 221 ms 736s ok 95 + select_having 138 ms 736s ok 96 + subselect 833 ms 736s ok 97 + union 598 ms 736s ok 98 + case 231 ms 736s ok 99 + join 1714 ms 736s ok 100 + aggregates 1384 ms 736s ok 101 + transactions 497 ms 736s ok 102 + random 338 ms 736s ok 103 + portals 522 ms 736s ok 104 + arrays 773 ms 736s ok 105 + btree_index 1657 ms 736s ok 106 + hash_index 1073 ms 736s ok 107 + update 1033 ms 736s ok 108 + delete 177 ms 736s ok 109 + namespace 276 ms 736s ok 110 + prepared_xacts 327 ms 742s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password collate replica_identity matview identity spgist rowsecurity generated_stored gist groupingsets gin join_hash brin privileges 742s ok 111 + brin 4778 ms 742s ok 112 + gin 1958 ms 742s ok 113 + gist 1756 ms 742s ok 114 + spgist 1239 ms 742s ok 115 + privileges 5073 ms 742s ok 116 + init_privs 99 ms 742s ok 117 + security_label 175 ms 742s ok 118 + collate 473 ms 742s ok 119 + matview 1079 ms 742s ok 120 + lock 376 ms 742s ok 121 + replica_identity 628 ms 742s ok 122 + rowsecurity 1541 ms 742s ok 123 + object_address 372 ms 742s ok 124 + tablesample 325 ms 742s ok 125 + groupingsets 1839 ms 742s ok 126 + drop_operator 123 ms 742s ok 127 + password 425 ms 742s ok 128 + identity 1134 ms 742s ok 129 + generated_stored 1624 ms 742s ok 130 + join_hash 4753 ms 742s # parallel group (2 tests): brin_bloom brin_multi 742s ok 131 + brin_bloom 55 ms 742s ok 132 + brin_multi 152 ms 743s # parallel group (19 tests): async dbsize tid collate.utf8 tidscan tidrangescan tsrf alter_operator create_role alter_generic incremental_sort sysviews misc_functions merge create_table_like generated_virtual misc collate.icu.utf8 without_overlaps 743s ok 133 + create_table_like 890 ms 743s ok 134 + alter_generic 474 ms 743s ok 135 + alter_operator 241 ms 743s ok 136 + misc 1163 ms 743s ok 137 + async 121 ms 743s ok 138 + dbsize 145 ms 743s ok 139 + merge 845 ms 743s ok 140 + misc_functions 580 ms 743s ok 141 + sysviews 531 ms 743s ok 142 + tsrf 224 ms 743s ok 143 + tid 195 ms 743s ok 144 + tidscan 216 ms 743s ok 145 + tidrangescan 217 ms 743s ok 146 + collate.utf8 203 ms 743s ok 147 + collate.icu.utf8 1163 ms 743s ok 148 + incremental_sort 496 ms 743s ok 149 + create_role 300 ms 743s ok 150 + without_overlaps 1170 ms 743s ok 151 + generated_virtual 1076 ms 744s # parallel group (8 tests): amutils collate.linux.utf8 collate.windows.win1252 psql_crosstab psql_pipeline rules psql stats_ext 744s ok 152 + rules 289 ms 744s ok 153 + psql 476 ms 744s ok 154 + psql_crosstab 82 ms 744s ok 155 + psql_pipeline 91 ms 744s ok 156 + amutils 47 ms 744s ok 157 + stats_ext 1138 ms 744s ok 158 + collate.linux.utf8 47 ms 744s ok 159 + collate.windows.win1252 50 ms 746s ok 160 - select_parallel 1976 ms 746s ok 161 - write_parallel 104 ms 746s ok 162 - vacuum_parallel 74 ms 746s ok 163 - maintain_every 20 ms 748s # parallel group (2 tests): subscription publication 748s ok 164 + publication 1487 ms 748s ok 165 + subscription 45 ms 750s # parallel group (17 tests): xmlmap portals_p2 advisory_lock combocid guc functional_deps equivclass dependency tsdicts select_views window bitmapops cluster tsearch indirect_toast foreign_data foreign_key 750s ok 166 + select_views 364 ms 750s ok 167 + portals_p2 149 ms 750s ok 168 + foreign_key 1243 ms 750s ok 169 + cluster 701 ms 750s ok 170 + dependency 285 ms 750s ok 171 + guc 245 ms 750s ok 172 + bitmapops 691 ms 750s ok 173 + combocid 210 ms 750s ok 174 + tsearch 732 ms 750s ok 175 + tsdicts 294 ms 750s ok 176 + foreign_data 914 ms 750s ok 177 + window 669 ms 750s ok 178 + xmlmap 82 ms 750s ok 179 + functional_deps 268 ms 750s ok 180 + advisory_lock 178 ms 750s ok 181 + indirect_toast 772 ms 750s ok 182 + equivclass 272 ms 750s # parallel group (9 tests): json_encoding jsonpath_encoding jsonpath sqljson_jsontable sqljson_queryfuncs sqljson json jsonb_jsonpath jsonb 750s ok 183 + json 227 ms 750s ok 184 + jsonb 331 ms 750s ok 185 + json_encoding 63 ms 750s ok 186 + jsonpath 119 ms 750s ok 187 + jsonpath_encoding 67 ms 750s ok 188 + jsonb_jsonpath 237 ms 750s ok 189 + sqljson 183 ms 750s ok 190 + sqljson_queryfuncs 166 ms 750s ok 191 + sqljson_jsontable 134 ms 751s # parallel group (18 tests): prepare plancache limit conversion returning copy2 sequence rowtypes polymorphism truncate temp largeobject with domain rangefuncs xml plpgsql alter_table 751s ok 192 + plancache 366 ms 751s ok 193 + limit 372 ms 751s ok 194 + plpgsql 1258 ms 751s ok 195 + copy2 714 ms 751s ok 196 + temp 839 ms 751s ok 197 + domain 977 ms 751s ok 198 + rangefuncs 1104 ms 751s ok 199 + prepare 199 ms 751s ok 200 + conversion 401 ms 751s ok 201 + truncate 823 ms 751s ok 202 + alter_table 1841 ms 751s ok 203 + sequence 713 ms 751s ok 204 + polymorphism 792 ms 751s ok 205 + rowtypes 764 ms 751s ok 206 + returning 459 ms 751s ok 207 + largeobject 858 ms 751s ok 208 + with 940 ms 751s ok 209 + xml 1104 ms 753s # parallel group (14 tests): hash_part reloptions predicate partition_info numa explain memoize compression partition_aggregate stats partition_join tuplesort indexing partition_prune 753s ok 210 + partition_join 1441 ms 753s ok 211 + partition_prune 1809 ms 753s ok 212 + reloptions 183 ms 753s ok 213 + hash_part 135 ms 753s ok 214 + indexing 1683 ms 753s ok 215 + partition_aggregate 1365 ms 753s ok 216 + partition_info 269 ms 753s ok 217 + tuplesort 1511 ms 753s ok 218 + explain 315 ms 753s ok 219 + compression 560 ms 753s ok 220 + memoize 535 ms 753s ok 221 + stats 1374 ms 753s ok 222 + predicate 256 ms 753s ok 223 + numa 287 ms 753s # parallel group (2 tests): oidjoins event_trigger 753s ok 224 + oidjoins 175 ms 753s ok 225 + event_trigger 191 ms 753s ok 226 - event_trigger_login 44 ms 753s ok 227 - fast_default 112 ms 754s ok 228 - tablespace 322 ms 754s 1..228 754s # All 228 tests passed. 754s Dropping cluster 18/regress ... 754s + rm -rf /tmp/regress.1QburA 754s autopkgtest [08:35:54]: test installcheck: -----------------------] 755s autopkgtest [08:35:55]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 755s installcheck PASS 755s autopkgtest [08:35:55]: @@@@@@@@@@@@@@@@@@@@ summary 755s run-testsuite PASS 755s installcheck PASS