0s autopkgtest [23:43:08]: starting date and time: 2025-11-13 23:43:08+0000 0s autopkgtest [23:43:08]: git checkout: 508d4a25 a-v-ssh wait_for_ssh: demote "ssh connection failed" to a debug message 0s autopkgtest [23:43:08]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ts5apjje/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_proxy=127.0.0.1,127.0.1.1,localhost,localdomain,internal,login.ubuntu.com,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com\n" >> /etc/environment' --apt-pocket=proposed=src:curl --apt-upgrade postgresql-18 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=curl/8.17.0-1ubuntu1 -- lxd -r lxd-armhf-10.145.243.52 lxd-armhf-10.145.243.52:autopkgtest/ubuntu/resolute/armhf 21s autopkgtest [23:43:29]: testbed dpkg architecture: armhf 23s autopkgtest [23:43:31]: testbed apt version: 3.1.11 27s autopkgtest [23:43:35]: @@@@@@@@@@@@@@@@@@@@ test bed setup 29s autopkgtest [23:43:37]: testbed release detected to be: None 36s autopkgtest [23:43:44]: updating testbed package index (apt update) 38s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 39s Get:2 http://ftpmaster.internal/ubuntu resolute InRelease [87.8 kB] 39s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 39s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 39s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 39s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.4 kB] 39s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [81.8 kB] 39s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [769 kB] 39s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf Packages [137 kB] 39s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/restricted armhf Packages [940 B] 39s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/universe armhf Packages [402 kB] 39s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse armhf Packages [9140 B] 39s Get:13 http://ftpmaster.internal/ubuntu resolute/universe Sources [21.3 MB] 42s Get:14 http://ftpmaster.internal/ubuntu resolute/multiverse Sources [312 kB] 42s Get:15 http://ftpmaster.internal/ubuntu resolute/main Sources [1412 kB] 42s Get:16 http://ftpmaster.internal/ubuntu resolute/main armhf Packages [1369 kB] 42s Get:17 http://ftpmaster.internal/ubuntu resolute/universe armhf Packages [15.2 MB] 43s Get:18 http://ftpmaster.internal/ubuntu resolute/multiverse armhf Packages [184 kB] 46s Fetched 41.4 MB in 7s (5530 kB/s) 47s Reading package lists... 53s autopkgtest [23:44:01]: upgrading testbed (apt dist-upgrade and autopurge) 55s Reading package lists... 55s Building dependency tree... 55s Reading state information... 55s Calculating upgrade... 56s The following packages will be upgraded: 56s cron cron-daemon-common curl fwupd libcap2 libcap2-bin libcurl3t64-gnutls 56s libcurl4t64 libfwupd3 libpam-cap liburcu8t64 libxml2-16 lto-disabled-list 56s 13 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 56s Need to get 3437 kB of archives. 56s After this operation, 74.8 kB of additional disk space will be used. 56s Get:1 http://ftpmaster.internal/ubuntu resolute/main armhf cron armhf 3.0pl1-200ubuntu1 [85.3 kB] 56s Get:2 http://ftpmaster.internal/ubuntu resolute/main armhf libcap2 armhf 1:2.75-10ubuntu1 [26.9 kB] 56s Get:3 http://ftpmaster.internal/ubuntu resolute/main armhf libpam-cap armhf 1:2.75-10ubuntu1 [11.8 kB] 56s Get:4 http://ftpmaster.internal/ubuntu resolute/main armhf libcap2-bin armhf 1:2.75-10ubuntu1 [31.8 kB] 56s Get:5 http://ftpmaster.internal/ubuntu resolute/main armhf libxml2-16 armhf 2.15.1+dfsg-0.3 [515 kB] 56s Get:6 http://ftpmaster.internal/ubuntu resolute/main armhf cron-daemon-common all 3.0pl1-200ubuntu1 [15.7 kB] 56s Get:7 http://ftpmaster.internal/ubuntu resolute/main armhf liburcu8t64 armhf 0.15.5-1 [58.2 kB] 56s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf curl armhf 8.17.0-1ubuntu1 [262 kB] 57s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf libcurl4t64 armhf 8.17.0-1ubuntu1 [370 kB] 57s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf libcurl3t64-gnutls armhf 8.17.0-1ubuntu1 [363 kB] 57s Get:11 http://ftpmaster.internal/ubuntu resolute/main armhf fwupd armhf 2.0.17-6 [1557 kB] 57s Get:12 http://ftpmaster.internal/ubuntu resolute/main armhf libfwupd3 armhf 2.0.17-6 [129 kB] 57s Get:13 http://ftpmaster.internal/ubuntu resolute/main armhf lto-disabled-list all 72 [12.4 kB] 58s Fetched 3437 kB in 1s (2897 kB/s) 58s (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 ... 65904 files and directories currently installed.) 58s Preparing to unpack .../cron_3.0pl1-200ubuntu1_armhf.deb ... 58s Unpacking cron (3.0pl1-200ubuntu1) over (3.0pl1-196ubuntu2) ... 58s Preparing to unpack .../libcap2_1%3a2.75-10ubuntu1_armhf.deb ... 58s Unpacking libcap2:armhf (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 58s Setting up libcap2:armhf (1:2.75-10ubuntu1) ... 58s (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 ... 65904 files and directories currently installed.) 58s Preparing to unpack .../00-libpam-cap_1%3a2.75-10ubuntu1_armhf.deb ... 58s Unpacking libpam-cap:armhf (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 58s Preparing to unpack .../01-libcap2-bin_1%3a2.75-10ubuntu1_armhf.deb ... 58s Unpacking libcap2-bin (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 58s Preparing to unpack .../02-libxml2-16_2.15.1+dfsg-0.3_armhf.deb ... 58s Unpacking libxml2-16:armhf (2.15.1+dfsg-0.3) over (2.14.5+dfsg-0.2build1) ... 58s Preparing to unpack .../03-cron-daemon-common_3.0pl1-200ubuntu1_all.deb ... 58s Unpacking cron-daemon-common (3.0pl1-200ubuntu1) over (3.0pl1-196ubuntu2) ... 58s Preparing to unpack .../04-liburcu8t64_0.15.5-1_armhf.deb ... 58s Unpacking liburcu8t64:armhf (0.15.5-1) over (0.15.4-1) ... 58s Preparing to unpack .../05-curl_8.17.0-1ubuntu1_armhf.deb ... 58s Unpacking curl (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 58s Preparing to unpack .../06-libcurl4t64_8.17.0-1ubuntu1_armhf.deb ... 58s Unpacking libcurl4t64:armhf (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 58s Preparing to unpack .../07-libcurl3t64-gnutls_8.17.0-1ubuntu1_armhf.deb ... 58s Unpacking libcurl3t64-gnutls:armhf (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 58s Preparing to unpack .../08-fwupd_2.0.17-6_armhf.deb ... 59s Unpacking fwupd (2.0.17-6) over (2.0.17-2) ... 59s Preparing to unpack .../09-libfwupd3_2.0.17-6_armhf.deb ... 59s Unpacking libfwupd3:armhf (2.0.17-6) over (2.0.17-2) ... 59s Preparing to unpack .../10-lto-disabled-list_72_all.deb ... 59s Unpacking lto-disabled-list (72) over (71) ... 59s Setting up liburcu8t64:armhf (0.15.5-1) ... 59s Setting up lto-disabled-list (72) ... 59s Setting up libcurl4t64:armhf (8.17.0-1ubuntu1) ... 59s Setting up libxml2-16:armhf (2.15.1+dfsg-0.3) ... 59s Setting up libcurl3t64-gnutls:armhf (8.17.0-1ubuntu1) ... 59s Setting up libfwupd3:armhf (2.0.17-6) ... 59s Setting up libcap2-bin (1:2.75-10ubuntu1) ... 59s Setting up curl (8.17.0-1ubuntu1) ... 59s Setting up libpam-cap:armhf (1:2.75-10ubuntu1) ... 59s Setting up fwupd (2.0.17-6) ... 60s fwupd-refresh.service is a disabled or a static unit not running, not starting it. 60s fwupd.service is a disabled or a static unit not running, not starting it. 60s Setting up cron-daemon-common (3.0pl1-200ubuntu1) ... 60s Setting up cron (3.0pl1-200ubuntu1) ... 61s Processing triggers for dbus (1.16.2-2ubuntu2) ... 61s Processing triggers for libc-bin (2.42-2ubuntu2) ... 61s Processing triggers for man-db (2.13.1-1) ... 64s Reading package lists... 65s Building dependency tree... 65s Reading state information... 65s Solving dependencies... 66s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 67s autopkgtest [23:44:15]: rebooting testbed after setup commands that affected boot 108s autopkgtest [23:44:56]: testbed running kernel: Linux 6.8.0-86-generic #87~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 29 09:26:46 UTC 2 133s autopkgtest [23:45:21]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-18 194s Get:1 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (dsc) [4420 B] 194s Get:2 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (tar) [22.4 MB] 194s Get:3 http://ftpmaster.internal/ubuntu resolute/universe postgresql-18 18.0-1 (diff) [22.9 kB] 194s gpgv: Signature made Fri Sep 26 07:48:05 2025 UTC 194s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 194s gpgv: Can't check signature: No public key 194s dpkg-source: warning: cannot verify inline signature for ./postgresql-18_18.0-1.dsc: no acceptable signature found 202s autopkgtest [23:46:30]: testing package postgresql-18 version 18.0-1 205s autopkgtest [23:46:33]: build not needed 215s autopkgtest [23:46:43]: test run-testsuite: preparing testbed 217s Reading package lists... 217s Building dependency tree... 217s Reading state information... 218s Solving dependencies... 218s The following NEW packages will be installed: 218s autoconf automake autopoint autotools-dev build-essential cpp cpp-15 218s cpp-15-arm-linux-gnueabihf cpp-arm-linux-gnueabihf debhelper debugedit 218s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 218s fakeroot g++ g++-15 g++-15-arm-linux-gnueabihf g++-arm-linux-gnueabihf gcc 218s gcc-15 gcc-15-arm-linux-gnueabihf gcc-arm-linux-gnueabihf gettext 218s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libc-dev-bin 218s libc6-dev libcc1-0 libcrypt-dev libdebhelper-perl libdw1t64 libecpg-compat3 218s libecpg-dev libecpg6 libfakeroot libfile-stripnondeterminism-perl 218s libgcc-15-dev libgomp1 libio-pty-perl libipc-run-perl libisl23 libjson-perl 218s libmpc3 libpgtypes3 libpq-dev libpq-oauth libpq5 libpython3.13 libssl-dev 218s libstdc++-15-dev libtcl8.6 libtool libubsan1 liburing2 libxslt1.1 218s linux-libc-dev locales-all m4 po-debconf postgresql-18 postgresql-client-18 218s postgresql-client-common postgresql-common postgresql-common-dev 218s postgresql-doc-18 postgresql-plperl-18 postgresql-plpython3-18 218s postgresql-pltcl-18 postgresql-server-dev-18 rpcsvc-proto ssl-cert 219s 0 upgraded, 76 newly installed, 0 to remove and 0 not upgraded. 219s Need to get 90.5 MB of archives. 219s After this operation, 509 MB of additional disk space will be used. 219s Get:1 http://ftpmaster.internal/ubuntu resolute/main armhf libjson-perl all 4.10000-1 [81.9 kB] 219s Get:2 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-client-common all 282ubuntu1 [48.8 kB] 219s Get:3 http://ftpmaster.internal/ubuntu resolute/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 219s Get:4 http://ftpmaster.internal/ubuntu resolute/main armhf libipc-run-perl all 20250809.0-1 [94.4 kB] 219s Get:5 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-common-dev all 282ubuntu1 [73.9 kB] 219s Get:6 http://ftpmaster.internal/ubuntu resolute/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 219s Get:7 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-common all 282ubuntu1 [101 kB] 219s Get:8 http://ftpmaster.internal/ubuntu resolute/main armhf m4 armhf 1.4.20-2 [212 kB] 219s Get:9 http://ftpmaster.internal/ubuntu resolute/main armhf autoconf all 2.72-3.1ubuntu1 [384 kB] 219s Get:10 http://ftpmaster.internal/ubuntu resolute/main armhf autotools-dev all 20240727.1 [43.4 kB] 219s Get:11 http://ftpmaster.internal/ubuntu resolute/main armhf automake all 1:1.18.1-2 [581 kB] 220s Get:12 http://ftpmaster.internal/ubuntu resolute/main armhf autopoint all 0.23.1-2build2 [619 kB] 220s Get:13 http://ftpmaster.internal/ubuntu resolute/main armhf libc-dev-bin armhf 2.42-2ubuntu2 [21.8 kB] 220s Get:14 http://ftpmaster.internal/ubuntu resolute/main armhf linux-libc-dev armhf 6.17.0-5.5 [1771 kB] 220s Get:15 http://ftpmaster.internal/ubuntu resolute/main armhf libcrypt-dev armhf 1:4.4.38-1build1 [120 kB] 220s Get:16 http://ftpmaster.internal/ubuntu resolute/main armhf rpcsvc-proto armhf 1.4.3-1 [62.3 kB] 220s Get:17 http://ftpmaster.internal/ubuntu resolute/main armhf libc6-dev armhf 2.42-2ubuntu2 [1416 kB] 220s Get:18 http://ftpmaster.internal/ubuntu resolute/main armhf libisl23 armhf 0.27-1 [546 kB] 221s Get:19 http://ftpmaster.internal/ubuntu resolute/main armhf libmpc3 armhf 1.3.1-2 [47.0 kB] 221s Get:20 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [10.1 MB] 222s Get:21 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-15 armhf 15.2.0-7ubuntu1 [1030 B] 222s Get:22 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [5756 B] 222s Get:23 http://ftpmaster.internal/ubuntu resolute/main armhf cpp armhf 4:15.2.0-4ubuntu1 [22.4 kB] 222s Get:24 http://ftpmaster.internal/ubuntu resolute/main armhf libcc1-0 armhf 15.2.0-7ubuntu1 [43.5 kB] 222s Get:25 http://ftpmaster.internal/ubuntu resolute/main armhf libgomp1 armhf 15.2.0-7ubuntu1 [129 kB] 222s Get:26 http://ftpmaster.internal/ubuntu resolute/main armhf libasan8 armhf 15.2.0-7ubuntu1 [2950 kB] 222s Get:27 http://ftpmaster.internal/ubuntu resolute/main armhf libubsan1 armhf 15.2.0-7ubuntu1 [1187 kB] 222s Get:28 http://ftpmaster.internal/ubuntu resolute/main armhf libgcc-15-dev armhf 15.2.0-7ubuntu1 [898 kB] 222s Get:29 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [19.5 MB] 223s Get:30 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-15 armhf 15.2.0-7ubuntu1 [493 kB] 223s Get:31 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [1220 B] 223s Get:32 http://ftpmaster.internal/ubuntu resolute/main armhf gcc armhf 4:15.2.0-4ubuntu1 [5022 B] 223s Get:33 http://ftpmaster.internal/ubuntu resolute/main armhf libstdc++-15-dev armhf 15.2.0-7ubuntu1 [2637 kB] 223s Get:34 http://ftpmaster.internal/ubuntu resolute/main armhf g++-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [11.4 MB] 223s Get:35 http://ftpmaster.internal/ubuntu resolute/main armhf g++-15 armhf 15.2.0-7ubuntu1 [23.7 kB] 223s Get:36 http://ftpmaster.internal/ubuntu resolute/main armhf g++-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [968 B] 223s Get:37 http://ftpmaster.internal/ubuntu resolute/main armhf g++ armhf 4:15.2.0-4ubuntu1 [1086 B] 223s Get:38 http://ftpmaster.internal/ubuntu resolute/main armhf build-essential armhf 12.12ubuntu1 [5088 B] 223s Get:39 http://ftpmaster.internal/ubuntu resolute/main armhf libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 223s Get:40 http://ftpmaster.internal/ubuntu resolute/main armhf libtool all 2.5.4-7 [169 kB] 223s Get:41 http://ftpmaster.internal/ubuntu resolute/main armhf dh-autoreconf all 21 [12.5 kB] 223s Get:42 http://ftpmaster.internal/ubuntu resolute/main armhf libarchive-zip-perl all 1.68-1 [90.2 kB] 223s Get:43 http://ftpmaster.internal/ubuntu resolute/main armhf libfile-stripnondeterminism-perl all 1.15.0-1 [20.5 kB] 223s Get:44 http://ftpmaster.internal/ubuntu resolute/main armhf dh-strip-nondeterminism all 1.15.0-1 [5090 B] 223s Get:45 http://ftpmaster.internal/ubuntu resolute/main armhf libdw1t64 armhf 0.194-1 [254 kB] 223s Get:46 http://ftpmaster.internal/ubuntu resolute/main armhf debugedit armhf 1:5.2-3 [48.9 kB] 223s Get:47 http://ftpmaster.internal/ubuntu resolute/main armhf dwz armhf 0.16-2 [114 kB] 223s Get:48 http://ftpmaster.internal/ubuntu resolute/main armhf gettext armhf 0.23.1-2build2 [1059 kB] 223s Get:49 http://ftpmaster.internal/ubuntu resolute/main armhf intltool-debian all 0.35.0+20060710.6 [23.2 kB] 223s Get:50 http://ftpmaster.internal/ubuntu resolute/main armhf po-debconf all 1.0.21+nmu1 [233 kB] 223s Get:51 http://ftpmaster.internal/ubuntu resolute/main armhf debhelper all 13.24.2ubuntu1 [896 kB] 224s Get:52 http://ftpmaster.internal/ubuntu resolute/main armhf emacsen-common all 3.0.8 [13.9 kB] 224s Get:53 http://ftpmaster.internal/ubuntu resolute/main armhf dictionaries-common all 1.30.11 [178 kB] 224s Get:54 http://ftpmaster.internal/ubuntu resolute/main armhf libfakeroot armhf 1.37.1.2-1 [29.7 kB] 224s Get:55 http://ftpmaster.internal/ubuntu resolute/main armhf fakeroot armhf 1.37.1.2-1 [69.5 kB] 224s Get:56 http://ftpmaster.internal/ubuntu resolute/main armhf hunspell-en-us all 1:2020.12.07-4 [585 kB] 224s Get:57 http://ftpmaster.internal/ubuntu resolute/main armhf libpgtypes3 armhf 18.0-1 [39.0 kB] 224s Get:58 http://ftpmaster.internal/ubuntu resolute/main armhf libpq5 armhf 18.0-1 [261 kB] 224s Get:59 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg6 armhf 18.0-1 [53.5 kB] 224s Get:60 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg-compat3 armhf 18.0-1 [10.8 kB] 224s Get:61 http://ftpmaster.internal/ubuntu resolute/main armhf libssl-dev armhf 3.5.3-1ubuntu2 [2550 kB] 224s Get:62 http://ftpmaster.internal/ubuntu resolute/main armhf libpq-dev armhf 18.0-1 [163 kB] 224s Get:63 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg-dev armhf 18.0-1 [268 kB] 224s Get:64 http://ftpmaster.internal/ubuntu resolute/universe armhf libpq-oauth armhf 18.0-1 [31.5 kB] 224s Get:65 http://ftpmaster.internal/ubuntu resolute/main armhf libpython3.13 armhf 3.13.9-1 [2123 kB] 224s Get:66 http://ftpmaster.internal/ubuntu resolute/main armhf libtcl8.6 armhf 8.6.17+dfsg-1 [918 kB] 224s Get:67 http://ftpmaster.internal/ubuntu resolute/main armhf liburing2 armhf 2.11-1 [22.1 kB] 224s Get:68 http://ftpmaster.internal/ubuntu resolute/main armhf libxslt1.1 armhf 1.1.43-0.3 [146 kB] 224s Get:69 http://ftpmaster.internal/ubuntu resolute/main armhf locales-all armhf 2.42-2ubuntu2 [11.1 MB] 225s Get:70 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-client-18 armhf 18.0-1 [2159 kB] 225s Get:71 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-18 armhf 18.0-1 [7268 kB] 225s Get:72 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-doc-18 all 18.0-1 [2176 kB] 225s Get:73 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-plperl-18 armhf 18.0-1 [67.5 kB] 225s Get:74 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-plpython3-18 armhf 18.0-1 [92.2 kB] 225s Get:75 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-pltcl-18 armhf 18.0-1 [39.3 kB] 225s Get:76 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-server-dev-18 armhf 18.0-1 [1430 kB] 226s Preconfiguring packages ... 226s Fetched 90.5 MB in 7s (13.1 MB/s) 226s Selecting previously unselected package libjson-perl. 226s (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 ... 65903 files and directories currently installed.) 226s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 226s Unpacking libjson-perl (4.10000-1) ... 226s Selecting previously unselected package postgresql-client-common. 226s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 226s Unpacking postgresql-client-common (282ubuntu1) ... 226s Selecting previously unselected package libio-pty-perl. 226s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 226s Unpacking libio-pty-perl (1:1.20-1build3) ... 226s Selecting previously unselected package libipc-run-perl. 226s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 226s Unpacking libipc-run-perl (20250809.0-1) ... 226s Selecting previously unselected package postgresql-common-dev. 226s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 226s Unpacking postgresql-common-dev (282ubuntu1) ... 226s Selecting previously unselected package ssl-cert. 226s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 226s Unpacking ssl-cert (1.1.3ubuntu1) ... 226s Selecting previously unselected package postgresql-common. 226s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 226s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 226s Unpacking postgresql-common (282ubuntu1) ... 226s Selecting previously unselected package m4. 226s Preparing to unpack .../07-m4_1.4.20-2_armhf.deb ... 226s Unpacking m4 (1.4.20-2) ... 226s Selecting previously unselected package autoconf. 226s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 226s Unpacking autoconf (2.72-3.1ubuntu1) ... 227s Selecting previously unselected package autotools-dev. 227s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 227s Unpacking autotools-dev (20240727.1) ... 227s Selecting previously unselected package automake. 227s Preparing to unpack .../10-automake_1%3a1.18.1-2_all.deb ... 227s Unpacking automake (1:1.18.1-2) ... 227s Selecting previously unselected package autopoint. 227s Preparing to unpack .../11-autopoint_0.23.1-2build2_all.deb ... 227s Unpacking autopoint (0.23.1-2build2) ... 227s Selecting previously unselected package libc-dev-bin. 227s Preparing to unpack .../12-libc-dev-bin_2.42-2ubuntu2_armhf.deb ... 227s Unpacking libc-dev-bin (2.42-2ubuntu2) ... 227s Selecting previously unselected package linux-libc-dev:armhf. 227s Preparing to unpack .../13-linux-libc-dev_6.17.0-5.5_armhf.deb ... 227s Unpacking linux-libc-dev:armhf (6.17.0-5.5) ... 227s Selecting previously unselected package libcrypt-dev:armhf. 227s Preparing to unpack .../14-libcrypt-dev_1%3a4.4.38-1build1_armhf.deb ... 227s Unpacking libcrypt-dev:armhf (1:4.4.38-1build1) ... 227s Selecting previously unselected package rpcsvc-proto. 227s Preparing to unpack .../15-rpcsvc-proto_1.4.3-1_armhf.deb ... 227s Unpacking rpcsvc-proto (1.4.3-1) ... 227s Selecting previously unselected package libc6-dev:armhf. 227s Preparing to unpack .../16-libc6-dev_2.42-2ubuntu2_armhf.deb ... 227s Unpacking libc6-dev:armhf (2.42-2ubuntu2) ... 227s Selecting previously unselected package libisl23:armhf. 227s Preparing to unpack .../17-libisl23_0.27-1_armhf.deb ... 227s Unpacking libisl23:armhf (0.27-1) ... 227s Selecting previously unselected package libmpc3:armhf. 227s Preparing to unpack .../18-libmpc3_1.3.1-2_armhf.deb ... 227s Unpacking libmpc3:armhf (1.3.1-2) ... 227s Selecting previously unselected package cpp-15-arm-linux-gnueabihf. 227s Preparing to unpack .../19-cpp-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 227s Unpacking cpp-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 227s Selecting previously unselected package cpp-15. 227s Preparing to unpack .../20-cpp-15_15.2.0-7ubuntu1_armhf.deb ... 227s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 227s Selecting previously unselected package cpp-arm-linux-gnueabihf. 228s Preparing to unpack .../21-cpp-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 228s Unpacking cpp-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 228s Selecting previously unselected package cpp. 228s Preparing to unpack .../22-cpp_4%3a15.2.0-4ubuntu1_armhf.deb ... 228s Unpacking cpp (4:15.2.0-4ubuntu1) ... 228s Selecting previously unselected package libcc1-0:armhf. 228s Preparing to unpack .../23-libcc1-0_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking libcc1-0:armhf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package libgomp1:armhf. 228s Preparing to unpack .../24-libgomp1_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking libgomp1:armhf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package libasan8:armhf. 228s Preparing to unpack .../25-libasan8_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking libasan8:armhf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package libubsan1:armhf. 228s Preparing to unpack .../26-libubsan1_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking libubsan1:armhf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package libgcc-15-dev:armhf. 228s Preparing to unpack .../27-libgcc-15-dev_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking libgcc-15-dev:armhf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package gcc-15-arm-linux-gnueabihf. 228s Preparing to unpack .../28-gcc-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking gcc-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package gcc-15. 228s Preparing to unpack .../29-gcc-15_15.2.0-7ubuntu1_armhf.deb ... 228s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 228s Selecting previously unselected package gcc-arm-linux-gnueabihf. 228s Preparing to unpack .../30-gcc-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 228s Unpacking gcc-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 229s Selecting previously unselected package gcc. 229s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_armhf.deb ... 229s Unpacking gcc (4:15.2.0-4ubuntu1) ... 229s Selecting previously unselected package libstdc++-15-dev:armhf. 229s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-7ubuntu1_armhf.deb ... 229s Unpacking libstdc++-15-dev:armhf (15.2.0-7ubuntu1) ... 229s Selecting previously unselected package g++-15-arm-linux-gnueabihf. 229s Preparing to unpack .../33-g++-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 229s Unpacking g++-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 229s Selecting previously unselected package g++-15. 229s Preparing to unpack .../34-g++-15_15.2.0-7ubuntu1_armhf.deb ... 229s Unpacking g++-15 (15.2.0-7ubuntu1) ... 229s Selecting previously unselected package g++-arm-linux-gnueabihf. 229s Preparing to unpack .../35-g++-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 229s Unpacking g++-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 229s Selecting previously unselected package g++. 229s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_armhf.deb ... 229s Unpacking g++ (4:15.2.0-4ubuntu1) ... 229s Selecting previously unselected package build-essential. 229s Preparing to unpack .../37-build-essential_12.12ubuntu1_armhf.deb ... 229s Unpacking build-essential (12.12ubuntu1) ... 229s Selecting previously unselected package libdebhelper-perl. 229s Preparing to unpack .../38-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 229s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 229s Selecting previously unselected package libtool. 229s Preparing to unpack .../39-libtool_2.5.4-7_all.deb ... 229s Unpacking libtool (2.5.4-7) ... 229s Selecting previously unselected package dh-autoreconf. 229s Preparing to unpack .../40-dh-autoreconf_21_all.deb ... 229s Unpacking dh-autoreconf (21) ... 229s Selecting previously unselected package libarchive-zip-perl. 229s Preparing to unpack .../41-libarchive-zip-perl_1.68-1_all.deb ... 229s Unpacking libarchive-zip-perl (1.68-1) ... 230s Selecting previously unselected package libfile-stripnondeterminism-perl. 230s Preparing to unpack .../42-libfile-stripnondeterminism-perl_1.15.0-1_all.deb ... 230s Unpacking libfile-stripnondeterminism-perl (1.15.0-1) ... 230s Selecting previously unselected package dh-strip-nondeterminism. 230s Preparing to unpack .../43-dh-strip-nondeterminism_1.15.0-1_all.deb ... 230s Unpacking dh-strip-nondeterminism (1.15.0-1) ... 230s Selecting previously unselected package libdw1t64:armhf. 230s Preparing to unpack .../44-libdw1t64_0.194-1_armhf.deb ... 230s Unpacking libdw1t64:armhf (0.194-1) ... 230s Selecting previously unselected package debugedit. 230s Preparing to unpack .../45-debugedit_1%3a5.2-3_armhf.deb ... 230s Unpacking debugedit (1:5.2-3) ... 230s Selecting previously unselected package dwz. 230s Preparing to unpack .../46-dwz_0.16-2_armhf.deb ... 230s Unpacking dwz (0.16-2) ... 230s Selecting previously unselected package gettext. 230s Preparing to unpack .../47-gettext_0.23.1-2build2_armhf.deb ... 230s Unpacking gettext (0.23.1-2build2) ... 230s Selecting previously unselected package intltool-debian. 230s Preparing to unpack .../48-intltool-debian_0.35.0+20060710.6_all.deb ... 230s Unpacking intltool-debian (0.35.0+20060710.6) ... 230s Selecting previously unselected package po-debconf. 230s Preparing to unpack .../49-po-debconf_1.0.21+nmu1_all.deb ... 230s Unpacking po-debconf (1.0.21+nmu1) ... 230s Selecting previously unselected package debhelper. 230s Preparing to unpack .../50-debhelper_13.24.2ubuntu1_all.deb ... 230s Unpacking debhelper (13.24.2ubuntu1) ... 230s Selecting previously unselected package emacsen-common. 230s Preparing to unpack .../51-emacsen-common_3.0.8_all.deb ... 230s Unpacking emacsen-common (3.0.8) ... 230s Selecting previously unselected package dictionaries-common. 230s Preparing to unpack .../52-dictionaries-common_1.30.11_all.deb ... 230s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 230s Unpacking dictionaries-common (1.30.11) ... 230s Selecting previously unselected package libfakeroot:armhf. 230s Preparing to unpack .../53-libfakeroot_1.37.1.2-1_armhf.deb ... 230s Unpacking libfakeroot:armhf (1.37.1.2-1) ... 230s Selecting previously unselected package fakeroot. 230s Preparing to unpack .../54-fakeroot_1.37.1.2-1_armhf.deb ... 230s Unpacking fakeroot (1.37.1.2-1) ... 230s Selecting previously unselected package hunspell-en-us. 230s Preparing to unpack .../55-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 230s Unpacking hunspell-en-us (1:2020.12.07-4) ... 230s Selecting previously unselected package libpgtypes3:armhf. 230s Preparing to unpack .../56-libpgtypes3_18.0-1_armhf.deb ... 230s Unpacking libpgtypes3:armhf (18.0-1) ... 230s Selecting previously unselected package libpq5:armhf. 230s Preparing to unpack .../57-libpq5_18.0-1_armhf.deb ... 230s Unpacking libpq5:armhf (18.0-1) ... 230s Selecting previously unselected package libecpg6:armhf. 230s Preparing to unpack .../58-libecpg6_18.0-1_armhf.deb ... 230s Unpacking libecpg6:armhf (18.0-1) ... 230s Selecting previously unselected package libecpg-compat3:armhf. 230s Preparing to unpack .../59-libecpg-compat3_18.0-1_armhf.deb ... 230s Unpacking libecpg-compat3:armhf (18.0-1) ... 230s Selecting previously unselected package libssl-dev:armhf. 230s Preparing to unpack .../60-libssl-dev_3.5.3-1ubuntu2_armhf.deb ... 230s Unpacking libssl-dev:armhf (3.5.3-1ubuntu2) ... 231s Selecting previously unselected package libpq-dev. 231s Preparing to unpack .../61-libpq-dev_18.0-1_armhf.deb ... 231s Unpacking libpq-dev (18.0-1) ... 231s Selecting previously unselected package libecpg-dev. 231s Preparing to unpack .../62-libecpg-dev_18.0-1_armhf.deb ... 231s Unpacking libecpg-dev (18.0-1) ... 231s Selecting previously unselected package libpq-oauth:armhf. 231s Preparing to unpack .../63-libpq-oauth_18.0-1_armhf.deb ... 231s Unpacking libpq-oauth:armhf (18.0-1) ... 231s Selecting previously unselected package libpython3.13:armhf. 231s Preparing to unpack .../64-libpython3.13_3.13.9-1_armhf.deb ... 231s Unpacking libpython3.13:armhf (3.13.9-1) ... 231s Selecting previously unselected package libtcl8.6:armhf. 231s Preparing to unpack .../65-libtcl8.6_8.6.17+dfsg-1_armhf.deb ... 231s Unpacking libtcl8.6:armhf (8.6.17+dfsg-1) ... 231s Selecting previously unselected package liburing2:armhf. 231s Preparing to unpack .../66-liburing2_2.11-1_armhf.deb ... 231s Unpacking liburing2:armhf (2.11-1) ... 231s Selecting previously unselected package libxslt1.1:armhf. 231s Preparing to unpack .../67-libxslt1.1_1.1.43-0.3_armhf.deb ... 231s Unpacking libxslt1.1:armhf (1.1.43-0.3) ... 231s Selecting previously unselected package locales-all. 231s Preparing to unpack .../68-locales-all_2.42-2ubuntu2_armhf.deb ... 231s Unpacking locales-all (2.42-2ubuntu2) ... 233s Selecting previously unselected package postgresql-client-18. 233s Preparing to unpack .../69-postgresql-client-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-client-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-18. 233s Preparing to unpack .../70-postgresql-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-doc-18. 233s Preparing to unpack .../71-postgresql-doc-18_18.0-1_all.deb ... 233s Unpacking postgresql-doc-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-plperl-18. 233s Preparing to unpack .../72-postgresql-plperl-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-plperl-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-plpython3-18. 233s Preparing to unpack .../73-postgresql-plpython3-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-plpython3-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-pltcl-18. 233s Preparing to unpack .../74-postgresql-pltcl-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-pltcl-18 (18.0-1) ... 233s Selecting previously unselected package postgresql-server-dev-18. 233s Preparing to unpack .../75-postgresql-server-dev-18_18.0-1_armhf.deb ... 233s Unpacking postgresql-server-dev-18 (18.0-1) ... 234s Setting up libpython3.13:armhf (3.13.9-1) ... 234s Setting up postgresql-client-common (282ubuntu1) ... 234s Setting up libpgtypes3:armhf (18.0-1) ... 234s Setting up postgresql-doc-18 (18.0-1) ... 234s 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 234s Setting up libio-pty-perl (1:1.20-1build3) ... 234s Setting up libarchive-zip-perl (1.68-1) ... 234s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 234s Setting up libpq5:armhf (18.0-1) ... 234s Setting up linux-libc-dev:armhf (6.17.0-5.5) ... 234s Setting up m4 (1.4.20-2) ... 234s Setting up libgomp1:armhf (15.2.0-7ubuntu1) ... 234s Setting up locales-all (2.42-2ubuntu2) ... 234s Setting up libfakeroot:armhf (1.37.1.2-1) ... 234s Setting up libdw1t64:armhf (0.194-1) ... 234s Setting up fakeroot (1.37.1.2-1) ... 234s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 234s Setting up autotools-dev (20240727.1) ... 234s Setting up rpcsvc-proto (1.4.3-1) ... 234s Setting up emacsen-common (3.0.8) ... 234s Setting up ssl-cert (1.1.3ubuntu1) ... 235s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 235s Setting up libssl-dev:armhf (3.5.3-1ubuntu2) ... 235s Setting up libmpc3:armhf (1.3.1-2) ... 235s Setting up libtcl8.6:armhf (8.6.17+dfsg-1) ... 235s Setting up autopoint (0.23.1-2build2) ... 235s Setting up libipc-run-perl (20250809.0-1) ... 235s Setting up autoconf (2.72-3.1ubuntu1) ... 235s Setting up libubsan1:armhf (15.2.0-7ubuntu1) ... 235s Setting up dwz (0.16-2) ... 235s Setting up libcrypt-dev:armhf (1:4.4.38-1build1) ... 235s Setting up libasan8:armhf (15.2.0-7ubuntu1) ... 235s Setting up libjson-perl (4.10000-1) ... 235s Setting up libxslt1.1:armhf (1.1.43-0.3) ... 235s Setting up debugedit (1:5.2-3) ... 235s Setting up libecpg6:armhf (18.0-1) ... 235s Setting up liburing2:armhf (2.11-1) ... 235s Setting up libisl23:armhf (0.27-1) ... 235s Setting up libc-dev-bin (2.42-2ubuntu2) ... 235s Setting up cpp-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 235s Setting up libcc1-0:armhf (15.2.0-7ubuntu1) ... 235s Setting up cpp-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 235s Setting up postgresql-common-dev (282ubuntu1) ... 235s Setting up automake (1:1.18.1-2) ... 235s update-alternatives: using /usr/bin/automake-1.18 to provide /usr/bin/automake (automake) in auto mode 235s Setting up libfile-stripnondeterminism-perl (1.15.0-1) ... 235s Setting up gettext (0.23.1-2build2) ... 235s Setting up libgcc-15-dev:armhf (15.2.0-7ubuntu1) ... 235s Setting up libecpg-compat3:armhf (18.0-1) ... 235s Setting up gcc-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 235s Setting up postgresql-client-18 (18.0-1) ... 236s 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 236s Setting up dictionaries-common (1.30.11) ... 236s Setting up libpq-oauth:armhf (18.0-1) ... 236s Setting up libpq-dev (18.0-1) ... 236s Setting up libecpg-dev (18.0-1) ... 236s Setting up intltool-debian (0.35.0+20060710.6) ... 236s Setting up postgresql-common (282ubuntu1) ... 237s Creating config file /etc/postgresql-common/createcluster.conf with new version 237s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 237s en_us 237s Removing obsolete dictionary files: 238s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 239s Setting up dh-strip-nondeterminism (1.15.0-1) ... 239s Setting up cpp-15 (15.2.0-7ubuntu1) ... 239s Setting up cpp (4:15.2.0-4ubuntu1) ... 239s Setting up hunspell-en-us (1:2020.12.07-4) ... 239s Setting up libc6-dev:armhf (2.42-2ubuntu2) ... 239s Setting up gcc-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 239s Setting up po-debconf (1.0.21+nmu1) ... 239s Setting up postgresql-18 (18.0-1) ... 240s Creating new PostgreSQL cluster 18/main ... 240s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 240s The files belonging to this database system will be owned by user "postgres". 240s This user must also own the server process. 240s 240s The database cluster will be initialized with locale "C.UTF-8". 240s The default database encoding has accordingly been set to "UTF8". 240s The default text search configuration will be set to "english". 240s 240s Data page checksums are enabled. 240s 240s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 240s creating subdirectories ... ok 240s selecting dynamic shared memory implementation ... posix 240s selecting default "max_connections" ... 100 240s selecting default "shared_buffers" ... 128MB 240s selecting default time zone ... Etc/UTC 240s creating configuration files ... ok 240s running bootstrap script ... ok 241s performing post-bootstrap initialization ... ok 241s syncing data to disk ... ok 244s Setting up postgresql-server-dev-18 (18.0-1) ... 244s Setting up gcc-15 (15.2.0-7ubuntu1) ... 244s Setting up libstdc++-15-dev:armhf (15.2.0-7ubuntu1) ... 244s Setting up postgresql-plpython3-18 (18.0-1) ... 244s Setting up postgresql-plperl-18 (18.0-1) ... 244s Setting up postgresql-pltcl-18 (18.0-1) ... 244s Setting up libtool (2.5.4-7) ... 244s Setting up g++-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 244s Setting up gcc (4:15.2.0-4ubuntu1) ... 244s Setting up dh-autoreconf (21) ... 244s Setting up g++-15 (15.2.0-7ubuntu1) ... 244s Setting up g++-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 244s Setting up debhelper (13.24.2ubuntu1) ... 244s Setting up g++ (4:15.2.0-4ubuntu1) ... 244s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 244s Setting up build-essential (12.12ubuntu1) ... 244s Processing triggers for libc-bin (2.42-2ubuntu2) ... 244s Processing triggers for man-db (2.13.1-1) ... 245s Processing triggers for install-info (7.2-5) ... 245s Processing triggers for dictionaries-common (1.30.11) ... 278s autopkgtest [23:47:46]: test run-testsuite: [----------------------- 281s ====== Running all tests with umask 077 ======= 281s ### PostgreSQL test 001_packages.t ### 281s 1..23 281s ok 1 - /etc/os-release exists 281s ok 2 - OS is ubuntu 281s ok 3 - OS version is 26.04 281s # PostgreSQL versions installed: 18 281s # 18 281s ok 4 - postgresql-18 installed 281s ok 5 - postgresql-plpython3-18 installed 281s ok 6 - postgresql-plperl-18 installed 281s ok 7 - postgresql-pltcl-18 installed 281s ok 8 # skip No postgresql-18-jit package on this architecture 281s ok 9 - postgresql-server-dev-18 installed 281s ok 10 # skip No postgresql-contrib-18 package for version 18 281s # postgresql-doc-18 installed 281s ok 11 - At least one doc package installed 281s ok 12 - libecpg-dev installed 281s ok 13 - postgresql-common-dev installed 281s ok 14 - procps installed 281s ok 15 - netcat-openbsd installed 281s ok 16 - hunspell-en-us installed 281s ok 17 - system has a default UTF-8 locale 281s ok 18 - locale ru_RU exists 281s ok 19 - locale ru_RU.UTF-8 exists 281s ok 20 - user postgres in the UNIX group ssl-cert 281s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 281s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 281s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 281s ### End test 001_packages.t ### 281s 281s ### PostgreSQL test 002_existing_clusters.t ### 281s 1..8 281s # Cleanup 281s ok 1 - Cleanup: No clusters left behind 281s ok 2 - No postgres processes left behind 281s ok 3 - No files in /etc/postgresql left behind 281s ok 4 - No files in /var/lib/postgresql left behind 281s ok 5 - No files in /var/run/postgresql left behind 281s ok 6 - No files in /var/log/postgresql left behind 281s ok 7 - PostgreSQL TCP ports are closed 281s ok 8 - Next free port is 5432 281s ### End test 002_existing_clusters.t ### 281s 281s ### PostgreSQL test 003_alternatives.t ### 281s 1..9 281s # Newest PG version installed is 18 281s ok 1 - psql.1.gz link group 281s ok 2 - postmaster.1.gz link group does not exist 281s ok 3 - psql.1.gz alternative 281s ok 4 - pg_dump.1.gz alternative 281s ok 5 - postgres.1.gz alternative 281s ok 6 - pg_ctl.1.gz alternative 281s # Newest PG doc version installed is 18 281s ok 7 - SPI_connect.3.gz link group 281s ok 8 - SPI_connect.3.gz alternative 281s ok 9 - SPI_exec.3.gz alternative 281s ### End test 003_alternatives.t ### 281s 281s ### PostgreSQL test 005_PgCommon.t ### 282s 1..24 282s ok 1 - correctly parsed line 'local all postgres ident sameuser' 282s ok 2 - correctly parsed line 'local foo nobody trust' 282s ok 3 - correctly parsed line 'local foo nobody crypt' 282s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 282s ok 5 - correctly parsed line 'local foo,bar nobody ident' 282s ok 6 - correctly parsed line 'local all +foogrp password' 282s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 282s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 282s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 282s ok 10 - @expected_records has correct number of entries 282s ok 11 - returned read_pg_hba array has correct number of records 282s ok 12 - line 'foo all all md5' parsed as invalid 282s ok 13 - line 'local all all foo' parsed as invalid 282s ok 14 - line 'host all all foo' parsed as invalid 282s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 282s ok 16 - line 'host all all md5' parsed as invalid 282s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 282s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 282s ok 19 - read_conf_file returns empty dict for nonexisting file 282s ok 20 - read_conf_file() parsing 282s ok 21 - read_conf_file() parsing with include directives 282s ok 22 - set_conf_value 282s ok 23 - disable_conf_value 282s ok 24 - replace_conf_value 282s ### End test 005_PgCommon.t ### 282s 282s ### PostgreSQL test 006_next_free_port.t ### 282s 1..5 282s ok 1 - next_free_port is 5432 283s ok 2 - next_free_port detects localhost ipv4 socket 284s ok 3 - next_free_port detects wildcard ipv4 socket 285s ok 4 - next_free_port detects localhost ipv6 socket 286s ok 5 - next_free_port detects wildcard ipv6 socket 286s ### End test 006_next_free_port.t ### 286s 286s ### PostgreSQL test 007_pg_conftool.t ### 286s 1..41 286s # test without cluster 286s ok 1 - pg_conftool show all 286s ok 2 - correct output of pg_conftool show all 286s ok 3 - pg_conftool foo.conf show all 286s ok 4 - correct output of pg_conftool foo.conf show all 286s ok 5 - pg_conftool /tmp/ZPyNFphurN/different.conf show all 286s ok 6 - correct output of pg_conftool /tmp/ZPyNFphurN/different.conf show all 286s ok 7 - pg_conftool 9.7 main show all 286s ok 8 - correct output of pg_conftool 9.7 main show all 286s # test show 286s ok 9 - pg_conftool show all 286s ok 10 - correct output of pg_conftool show all 286s ok 11 - pg_conftool other.conf show all 286s ok 12 - correct output of pg_conftool other.conf show all 286s ok 13 - pg_conftool /tmp/ZPyNFphurN/different.conf show all 286s ok 14 - correct output of pg_conftool /tmp/ZPyNFphurN/different.conf show all 286s ok 15 - pg_conftool 18 main show all 286s ok 16 - correct output of pg_conftool 18 main show all 286s ok 17 - pg_conftool 18 main other.conf show all 286s ok 18 - correct output of pg_conftool 18 main other.conf show all 286s ok 19 - pg_conftool show a 286s ok 20 - correct output of pg_conftool show a 286s ok 21 - pg_conftool -s show a 286s ok 22 - correct output of pg_conftool -s show a 286s # test set 286s ok 23 - pg_conftool set c 7 286s ok 24 - correct output of pg_conftool set c 7 286s ok 25 - file contains new setting 286s ok 26 - pg_conftool set a 8 286s ok 27 - correct output of pg_conftool set a 8 286s ok 28 - file contains updated setting 286s ok 29 - pg_conftool /tmp/ZPyNFphurN/different.conf set a 9 286s ok 30 - correct output of pg_conftool /tmp/ZPyNFphurN/different.conf set a 9 286s ok 31 - file with path contains updated setting 286s # test remove 286s ok 32 - pg_conftool remove a 286s ok 33 - correct output of pg_conftool remove a 286s ok 34 - setting removed from file 287s ok 35 - pg_conftool /tmp/ZPyNFphurN/different.conf remove a 287s ok 36 - correct output of pg_conftool /tmp/ZPyNFphurN/different.conf remove a 287s ok 37 - setting removed from file with path 287s # test edit 287s ok 38 - pg_conftool edit 287s ok 39 - correct output of pg_conftool edit 287s ok 40 - pg_conftool /tmp/ZPyNFphurN/different.conf edit 287s ok 41 - correct output of pg_conftool /tmp/ZPyNFphurN/different.conf edit 287s ### End test 007_pg_conftool.t ### 287s 287s ### PostgreSQL test 010_defaultport_cluster.t ### 287s 1..14 287s ok 1 - psql --version 287s ok 2 - pg_wrapper selects highest available version number 287s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 287s ok 4 - connecting to localhost fails with no clusters 287s ok 5 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -l 287s ok 6 - pg_wrapper uses host and port from PGCLUSTER 287s ok 7 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --cluster 18/127.0.0.3:5430 -l 287s ok 8 - pg_wrapper uses --cluster from the command line 287s ok 9 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql -h 127.0.0.3 -l 287s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 287s ok 11 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 psql --host 127.0.0.3 -l 287s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 287s ok 13 - env LC_MESSAGES=C PGCLUSTER=18/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 287s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 287s ### End test 010_defaultport_cluster.t ### 287s 287s ### PostgreSQL test 015_start_stop.t ### 287s 1..71 287s # We are running systemd 287s # Running tests for 18 287s # Cluster does not exist yet 287s ok 1 - cluster 18 main does not exist 287s ok 2 - service postgresql@18-main does not exist 287s ok 3 - systemctl start postgresql 287s ok 4 - cluster 18 main does not exist 287s ok 5 - service postgresql@18-main does not exist 287s ok 6 - systemctl start postgresql@18-main 287s ok 7 - cluster 18 main does not exist 287s ok 8 - service postgresql@18-main does not exist 287s # Start/stop postgresql using system tools 289s ok 9 - pg_createcluster 18 main 289s ok 10 - cluster 18 main is stopped 289s ok 11 - service postgresql@18-main is stopped 291s ok 12 - systemctl start postgresql 291s ok 13 - cluster 18 main is running 291s ok 14 - service postgresql@18-main is running 291s ok 15 - systemctl start postgresql 291s ok 16 - cluster 18 main is already running 291s ok 17 - service postgresql@18-main is already running 291s ok 18 - systemctl stop postgresql 297s ok 19 - cluster 18 main is stopped 297s ok 20 - service postgresql@18-main is stopped 297s ok 21 - systemctl stop postgresql 297s ok 22 - cluster 18 main is already stopped 297s ok 23 - service postgresql@18-main is already stopped 297s # Start/stop specific cluster using system tools 300s ok 24 - systemctl start postgresql@18-main 300s ok 25 - cluster 18 main is running 300s ok 26 - service postgresql@18-main is running 300s ok 27 - systemctl start postgresql@18-main 300s ok 28 - cluster 18 main is running 300s ok 29 - service postgresql@18-main is running 302s ok 30 - systemctl restart postgresql@18-main 302s ok 31 - cluster 18 main is running 302s ok 32 - service postgresql@18-main is running 303s ok 33 - systemctl stop postgresql@18-main 303s ok 34 - cluster 18 main is stopped 303s ok 35 - service postgresql@18-main is stopped 303s ok 36 - systemctl stop postgresql@18-main 303s ok 37 - cluster 18 main is already stopped 303s ok 38 - service postgresql@18-main is already stopped 304s ok 39 - pg_dropcluster 18 main 304s ok 40 - cluster 18 main does not exist 304s ok 41 - service postgresql@18-main does not exist 304s # Start/stop specific cluster using pg_*cluster 304s ok 42 - pg_ctlcluster start 18 main 304s ok 43 - cluster 18 main does not exist 304s ok 44 - service postgresql@18-main does not exist 308s ok 45 - pg_createcluster 18 main --start 308s ok 46 - cluster 18 main is running 308s ok 47 - service postgresql@18-main is running 308s ok 48 - pg_ctlcluster 18 main start 308s ok 49 - cluster 18 main is already running 308s ok 50 - service postgresql@18-main is already running 311s ok 51 - pg_ctlcluster 18-main restart 311s ok 52 - cluster 18 main is running 311s ok 53 - service postgresql@18-main is running 311s ok 54 - pg_ctlcluster 18 main stop 311s ok 55 - cluster 18 main is stopped 311s ok 56 - service postgresql@18-main is stopped 311s ok 57 - pg_ctlcluster 18 main stop 311s ok 58 - cluster 18 main is already stopped 311s ok 59 - service postgresql@18-main is already stopped 314s ok 60 - pg_ctlcluster start 18-main 314s ok 61 - cluster 18 main is running 314s ok 62 - service postgresql@18-main is running 315s ok 63 - pg_dropcluster 18 main --stop 315s # Cleanup 316s ok 64 - Cleanup: No clusters left behind 316s ok 65 - No postgres processes left behind 316s ok 66 - No files in /etc/postgresql left behind 316s ok 67 - No files in /var/lib/postgresql left behind 316s ok 68 - No files in /var/run/postgresql left behind 316s ok 69 - No files in /var/log/postgresql left behind 316s ok 70 - PostgreSQL TCP ports are closed 316s ok 71 - Next free port is 5432 316s ### End test 015_start_stop.t ### 316s 316s ### PostgreSQL test 020_create_sql_remove.t ### 316s 1..141 316s # Running tests for 18 320s ok 1 - pg_createcluster 18 main --start -- -X /tmp/18.xlog.nhIDxV 320s ok 2 - pg_createcluster 18 main 320s ok 3 - Socket and pid file are in /var/run/postgresql/ 320s ok 4 - xlog/wal directory /tmp/18.xlog.nhIDxV was created 320s ok 5 - local method in pg_hba.conf is peer 320s ok 6 - host method in pg_hba.conf is scram-sha-256 320s ok 7 - Exactly one postgres master process running 323s ok 8 - pg_ctlcluster 18 main restart 323s ok 9 - cluster restarts with new environment file 323s ok 10 - Exactly one postgres master process running 323s ok 11 - correct value of PGEXTRAVAR1 in environment 323s ok 12 - correct value of PGEXTRAVAR2 in environment 323s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 323s ok 14 - createdb --version 323s ok 15 - pg_wrapper+createdb selects version number of cluster 323s ok 16 - psql --version 323s ok 17 - pg_wrapper+psql selects version 18 323s ok 18 - pg_lscluster reports online cluster on port 5432 323s ok 19 - log file is actually used 323s ok 20 - /etc/postgresql is owned by user "postgres" 323s ok 21 - version configuration directory file is owned by user "postgres" 323s ok 22 - configuration directory file is owned by user "postgres" 323s ok 23 - version data directory file is owned by user "postgres" 323s ok 24 - data directory file is owned by user "postgres" 323s ok 25 - log file has 0640 permissions 323s ok 26 - log file is owned by user "postgres" 323s ok 27 - log file is owned by group "adm" 323s ok 28 - no log symlink by default 323s ok 29 - /var/log/postgresql/postgresql-18-main.log is the default log if log symlink is missing 323s ok 30 - pg_lsclusters -h 323s ok 31 - correct output of pg_lsclusters -h 323s ok 32 - stopping cluster 325s ok 33 - restarting cluster with nondefault log symlink 325s ok 34 - log target is used as log file 325s ok 35 - default log is not used 325s ok 36 - pg_lsclusters -h 325s ok 37 - correct output of pg_lsclusters -h 325s ok 38 - stopping cluster 328s ok 39 - restarting cluster with explicitly configured log file 328s ok 40 - default log is not used 328s ok 41 - log symlink target is used for startup message 328s ok 42 - exactly one log file 328s ok 43 - custom log is actually used 328s ok 44 - pg_lsclusters -h 328s ok 45 - correct output of pg_lsclusters -h 328s ok 46 - stopping cluster 328s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 328s ok 48 - /etc/postgres-hack was not created 331s ok 49 - restarting cluster 331s ok 50 - ps -o tty -U postgres h 331s ok 51 - postgres processes do not have an associated terminal 331s ok 52 - Server is linked with SSL support 331s ok 53 - SSL is enabled in postgresql.conf 331s ok 54 - psql -l fails for nobody 331s ok 55 - createuser nobody 331s ok 56 - createdb nobodydb 331s ok 57 - psql -ltA succeeds for nobody 331s ok 58 - psql -ltA output 331s ok 59 - SQL command: create table 331s ok 60 - SQL command: insert into table values 331s ok 61 - SQL command: insert into table values 331s ok 62 - primary key violation 331s ok 63 - psql -tAc "select * from phone order by name" nobodydb 331s ok 64 - SQL command output: select -tA 331s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 331s ok 66 - SQL command output: select -tx 331s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 331s ok 68 - SQL command output: select -tAx 331s ok 69 - CREATE EXTENSION plperlu fails for user nobody 331s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 331s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 331s ok 72 - creating PL/PerlU function as user nobody fails 331s ok 73 - creating unsafe PL/Perl function as user postgres fails 332s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 332s ok 75 - creating PL/PerlU function as user postgres succeeds 332s ok 76 - psql nobodydb -Atc "select read_file()" 332s ok 77 - calling PL/PerlU function 332s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 332s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 332s ok 80 - creating unsafe PL/Perl function as user nobody fails 332s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 332s ok 82 - creating PL/Perl function as user nobody succeeds 332s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 332s ok 84 - calling PL/Perl function 332s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 332s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 332s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 332s ok 88 - creating PL/Python3 function as user postgres succeeds 332s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 332s ok 90 - calling PL/Python function 332s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 332s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 332s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 332s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 332s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 332s ok 96 - creating PL/Tcl function as user nobody succeeds 332s 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;" 332s ok 98 - creating PL/TclU function as user postgres succeeds 332s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 332s ok 100 - calling PL/Tcl function 332s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 332s ok 102 - calling PL/TclU function 333s ok 103 - stopping cluster 333s ok 104 - pg_ctlcluster 18 main start 333s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 335s ok 106 - pg_ctlcluster 18 main start 335s ok 107 - cluster restarts with pgdata symlink 335s ok 108 # skip skipping postmaster OOM killer adjustment in container 335s ok 109 - postgres client backend has no OOM adjustment 335s ok 110 - ps h 6307 335s ok 111 - process title is idle 336s ok 112 - ps h 6307 336s ok 113 - process title is idle in transaction 336s ok 114 - stopping cluster 338s ok 115 - starting cluster as postgres works without a log file 338s ok 116 - log file got recreated and used 338s ok 117 - creating a directory in spc2 338s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/18.spc1.qzBFJN'" 338s ok 119 - creating tablespace spc1 338s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 338s ok 121 - creating a table in spc1 339s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/18.spc2.orbPwf'" 339s ok 123 - creating tablespace spc2 339s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 339s ok 125 - creating a table in spc2 339s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 339s ok 127 - Correct apt NeverAutoRemove config 340s ok 128 - pg_dropcluster removes cluster 340s ok 129 - xlog/wal directory /tmp/18.xlog.nhIDxV was deleted 340s ok 130 - tablespace spc1 was emptied 340s ok 131 - tablespace spc2 was emptied 340s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 340s ok 133 - Correct apt NeverAutoRemove config 340s # Cleanup 340s ok 134 - Cleanup: No clusters left behind 340s ok 135 - No postgres processes left behind 340s ok 136 - No files in /etc/postgresql left behind 340s ok 137 - No files in /var/lib/postgresql left behind 340s ok 138 - No files in /var/run/postgresql left behind 340s ok 139 - No files in /var/log/postgresql left behind 340s ok 140 - PostgreSQL TCP ports are closed 340s ok 141 - Next free port is 5432 340s ### End test 020_create_sql_remove.t ### 340s 340s ### PostgreSQL test 021_pg_renamecluster.t ### 340s 1..20 344s ok 1 - pg_createcluster 18 main 347s ok 2 - pg_renamecluster 18 main donau 347s ok 3 - psql -tAc "show data_directory" 347s ok 4 - cluster is running and data_directory was moved 347s ok 5 - pg_hba.conf location updated 347s ok 6 - pg_ident.conf location updated 347s ok 7 - external_pid_file location updated 347s ok 8 - external_pid_file exists 347s ok 9 # skip no stats_temp_directory in 18 347s ok 10 # skip no stats_temp_directory in 18 347s ok 11 - cluster_name is updated 349s ok 12 - pg_dropcluster removes cluster 349s # Cleanup 349s ok 13 - Cleanup: No clusters left behind 349s ok 14 - No postgres processes left behind 349s ok 15 - No files in /etc/postgresql left behind 349s ok 16 - No files in /var/lib/postgresql left behind 349s ok 17 - No files in /var/run/postgresql left behind 349s ok 18 - No files in /var/log/postgresql left behind 349s ok 19 - PostgreSQL TCP ports are closed 349s ok 20 - Next free port is 5432 349s ### End test 021_pg_renamecluster.t ### 349s 349s ### PostgreSQL test 022_recovery.t ### 349s 1..17 349s # Running tests for 18 352s ok 1 - pg_createcluster 18 main --start >/dev/null 353s ok 2 - pg_ctlcluster 18 main stop -m i 355s ok 3 - pg_ctlcluster 18 main start 355s ok 4 - psql -c '' 355s ok 5 - pg_ctlcluster 18 main stop -m i 355s ok 6 - create write-protected file in data directory 358s ok 7 - pg_ctlcluster 18 main start 358s ok 8 - psql -c '' 360s ok 9 - pg_dropcluster removes cluster 360s # Cleanup 360s ok 10 - Cleanup: No clusters left behind 360s ok 11 - No postgres processes left behind 360s ok 12 - No files in /etc/postgresql left behind 360s ok 13 - No files in /var/lib/postgresql left behind 360s ok 14 - No files in /var/run/postgresql left behind 360s ok 15 - No files in /var/log/postgresql left behind 360s ok 16 - PostgreSQL TCP ports are closed 360s ok 17 - Next free port is 5432 360s ### End test 022_recovery.t ### 360s 360s ### PostgreSQL test 025_logging.t ### 360s 1..55 360s # Logging to /var/log/syslog works 360s # Running tests for 18 364s ok 1 - pg_createcluster 18 main 364s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-18-main.log 364s ok 3 - psql -qc "'foobar_18_7493'" 364s ok 4 - log an error 364s ok 5 - grep --binary-files=text foobar_18_7493 /var/log/postgresql/postgresql-18-main.log 364s ok 6 - error appears in logfile 364s ok 7 - pg_conftool 18 main set log_destination syslog 364s ok 8 - set log_destination syslog 365s ok 9 - pg_ctlcluster 18 main reload 365s ok 10 - 18 main reload 365s ok 11 - psql -Atc "show log_destination" 365s ok 12 - log_destination is syslog 365s ok 13 - pg_lscluster reports syslog 365s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 365s ok 15 - error appears in /var/log/syslog 365s ok 16 - pg_conftool 18 main set logging_collector on 365s ok 17 - set logging_collector on 365s ok 18 - pg_conftool 18 main set log_destination csvlog 365s ok 19 - set log_destination csvlog 368s ok 20 - pg_ctlcluster 18 main restart 368s ok 21 - 18 main restart 368s ok 22 - psql -Atc "show logging_collector" 368s ok 23 - logging_collector is on 368s ok 24 - psql -Atc "show log_destination" 368s ok 25 - log_destination is csvlog 368s ok 26 - pg_lscluster reports csvlog 368s ok 27 - psql -qc "'barbaz_18_7493'" 368s ok 28 - log an error 368s ok 29 - grep --binary-files=text barbaz_18_7493 /var/lib/postgresql/18/main/log/*.csv 368s ok 30 - error appears in log/*.csv 368s ok 31 - pg_conftool 18 main set log_destination stderr,syslog,csvlog 368s ok 32 - set log_destination stderr,syslog,csvlog 369s ok 33 - pg_ctlcluster 18 main reload 369s ok 34 - 18 main reload 369s ok 35 - psql -Atc "show log_destination" 369s ok 36 - log_destination is stderr,syslog,csvlog 369s ok 37 - pg_lscluster reports stderr,syslog,csvlog 369s ok 38 - psql -qc "'moo_18_7493'" 369s ok 39 - log an error 369s ok 40 - grep --binary-files=text moo_18_7493 /var/lib/postgresql/18/main/log/*.log 369s ok 41 - error appears in log/*.log 370s ok 42 - grep --binary-files=text 'postgres.*moo_18_7493' /var/log/syslog 370s ok 43 - error appears in /var/log/syslog 370s ok 44 - grep --binary-files=text moo_18_7493 /var/lib/postgresql/18/main/log/*.csv 370s ok 45 - error appears in log/*.csv 371s ok 46 - pg_dropcluster 18 main --stop 371s ok 47 - pg_dropcluster removes cluster 371s # Cleanup 371s ok 48 - Cleanup: No clusters left behind 372s ok 49 - No postgres processes left behind 372s ok 50 - No files in /etc/postgresql left behind 372s ok 51 - No files in /var/lib/postgresql left behind 372s ok 52 - No files in /var/run/postgresql left behind 372s ok 53 - No files in /var/log/postgresql left behind 372s ok 54 - PostgreSQL TCP ports are closed 372s ok 55 - Next free port is 5432 372s ### End test 025_logging.t ### 372s 372s ### PostgreSQL test 027_jit.t ### 372s ok 1 - No JIT tests on this architecture 372s 1..1 372s ### End test 027_jit.t ### 372s 372s ### PostgreSQL test 030_errors.t ### 372s 1..156 372s ok 1 - pg_lscluster reports cluster without binaries 373s ok 2 - pg_dropcluster 6.3 main 374s ok 3 - pg_createcluster --socketdir 374s ok 4 - pg_lsclusters -h 374s ok 5 - cluster was created 374s ok 6 - Port of created cluster is 5432 374s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 18 main 374s ok 8 - pg_createcluster on existing cluster 374s ok 9 - pg_lsclusters -h 374s ok 10 - original cluster still exists 375s ok 11 - pg_createcluster 18 test -p foo 375s ok 12 - pg_createcluster -p checks that port option is numeric 375s ok 13 - pg_createcluster 18 test -p 42 375s ok 14 - pg_createcluster -p checks valid port range 375s ok 15 - pg_ctlcluster 18 main start 375s ok 16 - pg_ctlcluster refuses to start root-owned cluster 375s ok 17 - pg_ctlcluster 18 main start 375s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 375s ok 19 - pg_ctlcluster 18 main start 375s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 375s ok 21 - pg_ctlcluster 18 main start 375s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 377s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 377s ok 24 - No sockets in /var/run/postgresql 377s ok 25 - Socket is in /tmp/postgresql-testsuite/ 377s ok 26 - cluster stops with custom unix_socket_dir 377s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 380s ok 28 - cluster starts after removing unix_socket_dir 380s ok 29 - Socket is in default dir /var/run/postgresql 380s ok 30 - No sockets in /tmp/postgresql-testsuite/ 380s ok 31 - pg_ctlcluster 18 main stop 380s ok 32 - pg_ctlcluster fails with corrupted PID file 380s ok 33 - pg_lsclusters -h 380s ok 34 - cluster is still online 380s ok 35 - pg_ctlcluster succeeds with restored PID file 380s ok 36 - pg_lsclusters -h 380s ok 37 - cluster is down 380s ok 38 - pg_ctlcluster 18 main stop 380s ok 39 - pg_ctlcluster stop fails on stopped cluster 382s ok 40 - pg_ctlcluster 18 main start 382s ok 41 - pg_ctlcluster succeeds with already existing PID file 382s ok 42 - pg_lsclusters -h 382s ok 43 - cluster is online 383s ok 44 - pg_ctlcluster stop succeeds 383s ok 45 - pg_lsclusters -h 383s ok 46 - cluster is down 383s ok 47 - no pid file left 383s ok 48 - pg_ctlcluster 18 main stop 383s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 383s ok 50 - pid file was cleaned up 383s ok 51 - pg_ctlcluster --force 18 main stop 383s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 383s ok 53 - pid file was cleaned up 383s ok 54 - pg_ctlcluster 18 main stop 383s ok 55 - pg_ctlcluster stop succeeds with stale PID file 383s ok 56 - pid file was cleaned up 383s ok 57 - pg_ctlcluster --force 18 main stop 383s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 383s ok 59 - pid file was cleaned up 383s ok 60 - pg_ctlcluster --force 18 main stop 383s ok 61 - pg_ctlcluster stop succeeds with empty PID file 383s ok 62 - pid file was cleaned up 385s ok 63 - pg_ctlcluster 18 main start 385s ok 64 - pg_ctlcluster succeeds with corrupted PID file 385s ok 65 - pg_lsclusters -h 385s ok 66 - cluster is online 385s ok 67 - pg_ctlcluster 18 main start 385s ok 68 - pg_ctlcluster start fails on running cluster 385s ok 69 - pg_ctlcluster stop 386s ok 70 - pg_ctlcluster 18 main start 386s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 386s ok 72 - pg_ctlcluster 18 main stop 386s ok 73 - stopping cluster 392s ok 74 - pg_ctlcluster 18 main start 392s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 392s ok 76 - pg_ctlcluster 18 main stop 392s ok 77 - stopping cluster 392s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 392s ok 79 - pg_dropcluster 18 main 392s ok 80 - pg_dropcluster works as user postgres 393s ok 81 - pg_createcluster succeeds 393s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 393s ok 83 - proper error message for nonexisting /var/lib/postgresql 396s ok 84 - pg_ctlcluster 18 main start 396s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 396s ok 86 - pg_ctlcluster 18 main stop 396s ok 87 - stopping cluster 397s ok 88 - pg_createcluster other 399s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 402s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 402s ok 91 402s ok 92 - pg_ctlcluster 18 other start 402s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 402s ok 94 - pg_ctlcluster 18 main stop 402s ok 95 - stopping main cluster 404s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 406s ok 97 - pg_dropcluster other 407s ok 98 - pg_dropcluster 407s ok 99 - No sockets any more 407s ok 100 - 'pg_lsclusters 4.5 foo' fails 407s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 407s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 408s ok 103 - 'psql --cluster 4.5/foo' fails 408s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 408s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 408s ok 106 - 'psql --cluster 18/foo' fails 408s ok 107 - psql --cluster 18/foo gives error message about nonexisting cluster 408s ok 108 - psql --cluster 18/foo does not print 'invalid symbolic link' gibberish 408s ok 109 - 'pg_dropcluster 4.5 foo' fails 408s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 408s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 408s ok 112 - 'pg_dropcluster 18 foo' fails 408s ok 113 - pg_dropcluster 18 foo gives error message about nonexisting cluster 408s ok 114 - pg_dropcluster 18 foo does not print 'invalid symbolic link' gibberish 408s ok 115 - 'pg_upgradecluster 4.5 foo' fails 408s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 408s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 408s ok 118 - 'pg_upgradecluster 18 foo' fails 408s ok 119 - pg_upgradecluster 18 foo gives error message about nonexisting cluster 408s ok 120 - pg_upgradecluster 18 foo does not print 'invalid symbolic link' gibberish 408s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 408s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 408s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 408s ok 124 - 'pg_ctlcluster 18 foo stop' fails 408s ok 125 - pg_ctlcluster 18 foo stop gives error message about nonexisting cluster 408s ok 126 - pg_ctlcluster 18 foo stop does not print 'invalid symbolic link' gibberish 408s # Cleanup 408s ok 127 - Cleanup: No clusters left behind 408s ok 128 - No postgres processes left behind 408s ok 129 - No files in /etc/postgresql left behind 408s ok 130 - No files in /var/lib/postgresql left behind 408s ok 131 - No files in /var/run/postgresql left behind 408s ok 132 - No files in /var/log/postgresql left behind 408s ok 133 - PostgreSQL TCP ports are closed 408s ok 134 - Next free port is 5432 409s ok 135 - pg_dropcluster 18 broken 409s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 409s # Cleanup 409s ok 137 - Cleanup: No clusters left behind 409s ok 138 - No postgres processes left behind 409s ok 139 - No files in /etc/postgresql left behind 409s ok 140 - No files in /var/lib/postgresql left behind 409s ok 141 - No files in /var/run/postgresql left behind 409s ok 142 - No files in /var/log/postgresql left behind 409s ok 143 - PostgreSQL TCP ports are closed 409s ok 144 - Next free port is 5432 411s ok 145 - pg_dropcluster 18 broken 411s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 411s ok 147 - /etc/postgresql/18 was removed 411s ok 148 - /var/lib/postgresql/18 was removed 411s # Cleanup 411s ok 149 - Cleanup: No clusters left behind 411s ok 150 - No postgres processes left behind 411s ok 151 - No files in /etc/postgresql left behind 411s ok 152 - No files in /var/lib/postgresql left behind 411s ok 153 - No files in /var/run/postgresql left behind 411s ok 154 - No files in /var/log/postgresql left behind 411s ok 155 - PostgreSQL TCP ports are closed 411s ok 156 - Next free port is 5432 411s ### End test 030_errors.t ### 411s 411s ### PostgreSQL test 031_errors_disk_full.t ### 411s 1..22 411s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 413s ok 1 - script failed 413s ok 2 - pg_createcluster fails due to insufficient disk space 413s ok 3 - does not leave files behind 413s # Cleanup 413s ok 4 - Cleanup: No clusters left behind 413s ok 5 - No postgres processes left behind 413s ok 6 - No files in /etc/postgresql left behind 413s ok 7 - No files in /var/lib/postgresql left behind 413s ok 8 - No files in /var/run/postgresql left behind 413s ok 9 - No files in /var/log/postgresql left behind 413s ok 10 - PostgreSQL TCP ports are closed 413s ok 11 - Next free port is 5432 413s # check disk full conditions on startup 416s ok 12 - script failed 416s ok 13 - pg_ctlcluster prints error message 416s ok 14 - log file has error message 416s # Cleanup 416s ok 15 - Cleanup: No clusters left behind 416s ok 16 - No postgres processes left behind 416s ok 17 - No files in /etc/postgresql left behind 416s ok 18 - No files in /var/lib/postgresql left behind 416s ok 19 - No files in /var/run/postgresql left behind 416s ok 20 - No files in /var/log/postgresql left behind 416s ok 21 - PostgreSQL TCP ports are closed 416s ok 22 - Next free port is 5432 416s ### End test 031_errors_disk_full.t ### 416s 416s ### PostgreSQL test 032_ssl_key_permissions.t ### 416s 1..22 416s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 416s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 416s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 417s ok 4 - pg_createcluster 18 main 417s ok 5 - pg_ctlcluster 18 main start 417s ok 6 - ssl key owned by nobody refused 418s ok 7 - pg_ctlcluster 18 main start 418s ok 8 - ssl key with permissions root:root 0644 refused 418s ok 9 - pg_ctlcluster 18 main start 418s ok 10 - ssl key with permissions postgres:postgres 0640 refused 419s ok 11 - pg_dropcluster 18 main --stop 419s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 419s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 419s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 419s # Cleanup 419s ok 15 - Cleanup: No clusters left behind 419s ok 16 - No postgres processes left behind 419s ok 17 - No files in /etc/postgresql left behind 419s ok 18 - No files in /var/lib/postgresql left behind 419s ok 19 - No files in /var/run/postgresql left behind 419s ok 20 - No files in /var/log/postgresql left behind 419s ok 21 - PostgreSQL TCP ports are closed 419s ok 22 - Next free port is 5432 419s ### End test 032_ssl_key_permissions.t ### 419s 419s ### PostgreSQL test 040_upgrade.t ### 419s 1..1 419s ok 1 - only one major version installed, skipping upgrade tests 419s ### End test 040_upgrade.t ### 419s 419s ### PostgreSQL test 041_upgrade_custompaths.t ### 419s 1..1 419s ok 1 - only one major version installed, skipping upgrade tests 419s ### End test 041_upgrade_custompaths.t ### 419s 419s ### PostgreSQL test 042_upgrade_rename.t ### 420s 1..15 420s # PostgreSQL 18 423s ok 1 - pg_createcluster 18 main --start 430s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/18/bin -v 18 --rename upgr 18 main 430s ok 3 - pg_lsclusters -h 430s ok 4 - correct output of pg_lsclusters -h 431s ok 5 - pg_dropcluster 18 main --stop 433s ok 6 - pg_dropcluster 18 upgr --stop 433s ok 7 - Cleaning pg_upgrade log files 433s # Cleanup 433s ok 8 - Cleanup: No clusters left behind 433s ok 9 - No postgres processes left behind 433s ok 10 - No files in /etc/postgresql left behind 433s ok 11 - No files in /var/lib/postgresql left behind 433s ok 12 - No files in /var/run/postgresql left behind 433s ok 13 - No files in /var/log/postgresql left behind 433s ok 14 - PostgreSQL TCP ports are closed 433s ok 15 - Next free port is 5432 433s ### End test 042_upgrade_rename.t ### 433s 433s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 433s 1..1 433s ok 1 - only one major version installed, skipping upgrade tests 433s ### End test 043_upgrade_ssl_cert.t ### 433s 433s ### PostgreSQL test 045_backup.t ### 433s # We are running systemd 433s # PostgreSQL 18 433s # create cluster 438s ok 1 - pg_createcluster --locale en_US.UTF-8 18 main --start 438s ok 2 - pg_lsclusters -h 438s ok 3 - correct output of pg_lsclusters -h 438s ok 4 - pg_conftool 18 main set work_mem 11MB 438s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 438s ok 6 - psql -c 'alter database mydb set search_path=public' 438s ok 7 - psql -c 'create table foo (t text)' mydb 438s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 438s ok 9 - psql -c 'CREATE USER myuser' 438s ok 10 - psql -c 'grant create on database mydb to myuser' 438s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 438s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 438s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 438s # create directory 438s ok 14 - pg_backupcluster 18 main createdirectory 438s ok 15 - /var/backups/postgresql/18-main owned by uid postgres 438s ok 16 - /var/backups/postgresql/18-main owned by gid postgres 438s # dump 439s ok 17 - systemctl start pg_dump@18-main 439s ok 18 - dump created in /var/backups/postgresql/18-main/2025-11-13T235026Z.dump 439s ok 19 - /var/backups/postgresql/18-main/2025-11-13T235026Z.dump owned by uid postgres 439s ok 20 - /var/backups/postgresql/18-main/2025-11-13T235026Z.dump owned by gid postgres 439s # basebackup 439s ok 21 - systemctl start pg_receivewal@18-main 439s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 440s # Expected directory contents: [000000010000000000000001.gz.partial], actual contents: [000000010000000000000002.gz.partial] 440s not ok 23 - /var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 440s # Failed test '/var/backups/postgresql/18-main/wal contains 000000010000000000000001.gz.partial' 440s # at t/TestLib.pm line 171. 440s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 440s ok 25 - psql -c 'select pg_reload_conf()' 468s ok 26 - systemctl start pg_basebackup@18-main 468s ok 27 - dump created in /var/backups/postgresql/18-main/2025-11-13T235028Z.backup 468s ok 28 - /var/backups/postgresql/18-main/2025-11-13T235028Z.backup owned by uid postgres 468s ok 29 - /var/backups/postgresql/18-main/2025-11-13T235028Z.backup owned by gid postgres 468s # list 468s ok 30 - pg_backupcluster 18 main list 468s ok 31 - correct output of pg_backupcluster 18 main list 468s # more database changes 468s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 468s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 468s ok 34 - retrieve recovery timestamp 468s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 469s ok 36 - systemctl stop pg_receivewal@18-main 469s # restore /var/backups/postgresql/18-main/2025-11-13T235026Z.dump 470s ok 37 - pg_dropcluster 18 main --stop 475s ok 38 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-13T235026Z.dump --start --datadir /var/lib/postgresql/18/snowflake 475s ok 39 - pg_lsclusters -h 475s ok 40 - correct output of pg_lsclusters -h 475s ok 41 - psql -XAtl 475s ok 42 - mydb locales 475s ok 43 - mydb grants 475s ok 44 - myicudb locales 475s ok 45 - psql -XAtc 'show work_mem' 475s ok 46 - correct output of psql -XAtc 'show work_mem' 475s ok 47 - psql -XAtc 'select * from foo' mydb 475s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 476s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 476s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 476s ok 51 - psql -XAtc '\drds' 476s ok 52 - correct output of psql -XAtc '\drds' 476s # restore /var/backups/postgresql/18-main/2025-11-13T235028Z.backup 478s ok 53 - pg_dropcluster 18 main --stop 481s ok 54 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-13T235028Z.backup --start --datadir /var/lib/postgresql/18/snowflake 481s ok 55 - pg_lsclusters -h 481s ok 56 - correct output of pg_lsclusters -h 481s ok 57 - psql -XAtl 481s ok 58 - mydb locales 481s ok 59 - mydb grants 481s ok 60 - myicudb locales 481s ok 61 - psql -XAtc 'show work_mem' 481s ok 62 - correct output of psql -XAtc 'show work_mem' 482s ok 63 - psql -XAtc 'select * from foo' mydb 482s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 482s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 482s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 482s ok 67 - psql -XAtc '\drds' 482s ok 68 - correct output of psql -XAtc '\drds' 482s # restore /var/backups/postgresql/18-main/2025-11-13T235028Z.backup with WAL archive 483s ok 69 - pg_dropcluster 18 main --stop 487s ok 70 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-13T235028Z.backup --start --archive --port 5430 487s ok 71 - pg_lsclusters -h 487s ok 72 - correct output of pg_lsclusters -h 487s ok 73 - psql -XAtc 'select * from foo order by t' mydb 487s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 487s # restore /var/backups/postgresql/18-main/2025-11-13T235028Z.backup with PITR 489s ok 75 - pg_dropcluster 18 main --stop 493s ok 76 - pg_restorecluster 18 main /var/backups/postgresql/18-main/2025-11-13T235028Z.backup --start --pitr '2025-11-13 23:50:56.431468+00 493s # ' 493s ok 77 - pg_lsclusters -h 493s ok 78 - correct output of pg_lsclusters -h 493s ok 79 - psql -XAtc 'select * from foo order by t' mydb 493s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 495s ok 81 - pg_dropcluster 18 main --stop 495s # Cleanup 495s ok 82 - Cleanup: No clusters left behind 495s ok 83 - No postgres processes left behind 495s ok 84 - No files in /etc/postgresql left behind 495s ok 85 - No files in /var/lib/postgresql left behind 495s ok 86 - No files in /var/run/postgresql left behind 495s ok 87 - No files in /var/log/postgresql left behind 495s ok 88 - PostgreSQL TCP ports are closed 495s ok 89 - Next free port is 5432 495s 1..89 495s ### End test 045_backup.t ### 495s 495s ### PostgreSQL test 050_encodings.t ### 495s 1..60 495s # Checking 18 ru_RU 499s ok 1 - pg_createcluster version 18 for ru_RU without --encoding succeeded 500s ok 2 - psql -l succeeds 500s ok 3 - template1 is not UTF-8 encoded 500s ok 4 - creating test database 500s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 500s # create table t (x varchar); copy t from stdin" test 500s ok 6 - creating table with ISO-8859-5 characters 500s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 500s ok 8 - correct string in UTF-8 500s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 500s ok 10 - correct string in ISO-8859-5 500s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 500s # delete from t; copy t from stdin" test 500s ok 12 - creating table with UTF-8 characters 500s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 500s ok 14 - correct string in UTF-8 500s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 500s ok 16 - correct string in ISO-8859-1 500s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 500s ok 18 - Server error message has correct language and encoding 503s ok 19 - pg_ctlcluster 18 ru_RU restart 503s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 505s ok 21 - Dropping cluster 505s # Checking 18 ru_RU.UTF-8 508s ok 22 - pg_createcluster version 18 for ru_RU.UTF-8 without --encoding succeeded 509s ok 23 - psql -l succeeds 509s ok 24 - template1 is UTF-8 encoded 509s ok 25 - creating test database 509s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 509s # create table t (x varchar); copy t from stdin" test 509s ok 27 - creating table with ISO-8859-5 characters 509s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 509s ok 29 - correct string in UTF-8 509s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 509s ok 31 - correct string in ISO-8859-5 509s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 509s # delete from t; copy t from stdin" test 509s ok 33 - creating table with UTF-8 characters 510s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 510s ok 35 - correct string in UTF-8 510s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 510s ok 37 - correct string in ISO-8859-1 510s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 510s ok 39 - Server error message has correct language and encoding 512s ok 40 - pg_ctlcluster 18 ru_RU.UTF8 restart 512s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 512s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 512s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 512s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 512s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 512s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 512s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 514s ok 48 - Dropping cluster 514s # Check 18 locale environment variables 518s ok 49 - pg_createcluster: LC_ALL dominates LANG 518s ok 50 - psql -Atl --cluster 18/main 518s ok 51 - template1 is ASCII encoded 519s ok 52 - Dropping cluster 519s # Cleanup 519s ok 53 - Cleanup: No clusters left behind 519s ok 54 - No postgres processes left behind 519s ok 55 - No files in /etc/postgresql left behind 519s ok 56 - No files in /var/lib/postgresql left behind 519s ok 57 - No files in /var/run/postgresql left behind 519s ok 58 - No files in /var/log/postgresql left behind 519s ok 59 - PostgreSQL TCP ports are closed 519s ok 60 - Next free port is 5432 519s ### End test 050_encodings.t ### 519s 519s ### PostgreSQL test 052_upgrade_encodings.t ### 520s 1..1 520s ok 1 - only one major version installed, skipping upgrade tests 520s ### End test 052_upgrade_encodings.t ### 520s 520s ### PostgreSQL test 060_obsolete_confparams.t ### 520s ok 1 - only one major version installed, skipping upgrade tests 520s 1..1 520s ### End test 060_obsolete_confparams.t ### 520s 520s ### PostgreSQL test 070_non_postgres_clusters.t ### 520s 1..40 521s ok 1 - pg_createcluster 18 main for owner nobody 521s ok 2 - pg_ctlcluster 18 main start 521s ok 3 - start refused when config and data owners mismatch 523s ok 4 - pg_ctlcluster succeeds with owner nobody 523s ok 5 - pg_lsclusters -h 523s ok 6 - pg_lsclusters shows running cluster 523s ok 7 - postgres is running as user nobody 523s ok 8 - ls /tmp/.s.PGSQL.* 523s ok 9 - socket is in /tmp 523s ok 10 - /var/run/postgresql is empty 523s ok 11 - conf dir is owned by user 523s ok 12 - conf dir is owned by user's primary group 523s ok 13 - files are owned by user 523s ok 14 - files are owned by user's primary group 523s ok 15 - log file has 0640 permissions 523s ok 16 - log file is owned by user 523s ok 17 - log file is owned by user's primary group 523s ok 18 - only one major version installed, skipping upgrade test 523s ok 19 - ... 523s ok 20 - ... 523s ok 21 - ... 523s ok 22 - ... 523s ok 23 - ... 523s ok 24 - ... 523s ok 25 - ... 523s ok 26 - ... 523s ok 27 - ... 523s ok 28 - ... 525s ok 29 - pg_dropcluster 525s ok 30 - pg_lsclusters -h 525s ok 31 - No clusters left 525s ok 32 - No postgres processes left 525s # Cleanup 525s ok 33 - Cleanup: No clusters left behind 525s ok 34 - No postgres processes left behind 525s ok 35 - No files in /etc/postgresql left behind 525s ok 36 - No files in /var/lib/postgresql left behind 525s ok 37 - No files in /var/run/postgresql left behind 525s ok 38 - No files in /var/log/postgresql left behind 525s ok 39 - PostgreSQL TCP ports are closed 525s ok 40 - Next free port is 5432 525s ### End test 070_non_postgres_clusters.t ### 525s 525s ### PostgreSQL test 080_start.conf.t ### 525s 1..73 526s ok 1 - pg_createcluster 18 main 526s # start.conf auto 526s ok 2 - get_cluster_start_conf returns auto 526s ok 3 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 526s ok 4 - start.conf contains auto 526s ok 5 - systemd generator links cluster 526s ok 6 - systemd generator links correct service file 529s ok 7 - /etc/init.d/postgresql start 18 529s ok 8 - correct output of /etc/init.d/postgresql start 18 529s ok 9 - pg_lsclusters -h 529s ok 10 - cluster is online 529s ok 11 - /etc/init.d/postgresql stop 18 529s ok 12 - correct output of /etc/init.d/postgresql stop 18 532s ok 13 - pg_lsclusters -h 532s ok 14 - cluster is down 532s # start.conf manual 532s ok 15 - get_cluster_start_conf returns manual 532s ok 16 - grep '^[^\\s\#]' /etc/postgresql/18/main/start.conf 532s ok 17 - start.conf contains manual 532s ok 18 - systemd generator doesn't link cluster 532s ok 19 - /etc/init.d/postgresql start 18 532s ok 20 - correct output of /etc/init.d/postgresql start 18 532s ok 21 - pg_lsclusters -h 532s ok 22 - cluster is down 535s ok 23 - pg_ctlcluster 18 main start 535s ok 24 - correct output of pg_ctlcluster 18 main start 535s ok 25 - pg_lsclusters -h 535s ok 26 - cluster is online 535s ok 27 - pg_ctlcluster 18 main stop 535s ok 28 - correct output of pg_ctlcluster 18 main stop 535s ok 29 - pg_lsclusters -h 535s ok 30 - cluster is down 535s # start.conf disabled 535s ok 31 - get_cluster_start_conf returns disabled 535s ok 32 - systemd generator doesn't link cluster 535s ok 33 - /etc/init.d/postgresql start 18 535s ok 34 - correct output of /etc/init.d/postgresql start 18 535s ok 35 - pg_lsclusters -h 535s ok 36 - cluster is down 535s ok 37 - pg_ctlcluster 18 main start 535s ok 38 - correct output of pg_ctlcluster 18 main start 535s ok 39 - pg_lsclusters -h 535s ok 40 - cluster is down 538s ok 41 - pg_ctlcluster 18 main start 538s ok 42 - correct output of pg_ctlcluster 18 main start 538s ok 43 - pg_lsclusters -h 538s ok 44 - cluster is online 538s ok 45 - pg_ctlcluster 18 main stop 538s ok 46 - correct output of pg_ctlcluster 18 main stop 538s ok 47 - pg_lsclusters -h 538s ok 48 - cluster is down 540s ok 49 - pg_ctlcluster 18 main start 540s ok 50 - correct output of pg_ctlcluster 18 main start 540s ok 51 - pg_lsclusters -h 540s ok 52 - cluster is online 540s # test upgrade 540s ok 53 - only one major version installed, skipping upgrade test 540s ok 54 - ... 540s ok 55 - get_cluster_start_conf for old cluster returns manual 540s ok 56 - get_cluster_start_conf for new cluster returns manual 540s ok 57 - ... 542s ok 58 - dropping upgraded cluster 542s ok 59 - pg_lsclusters -h 542s ok 60 - no clusters any more 542s ok 61 - pg_createcluster 18 main --start-conf foo 542s ok 62 - pg_createcluster checks --start-conf validity 543s ok 63 - pg_createcluster checks --start-conf manual 543s ok 64 - get_cluster_start_conf returns manual 544s ok 65 - dropping cluster 544s # Cleanup 544s ok 66 - Cleanup: No clusters left behind 544s ok 67 - No postgres processes left behind 544s ok 68 - No files in /etc/postgresql left behind 544s ok 69 - No files in /var/lib/postgresql left behind 544s ok 70 - No files in /var/run/postgresql left behind 544s ok 71 - No files in /var/log/postgresql left behind 544s ok 72 - PostgreSQL TCP ports are closed 544s ok 73 - Next free port is 5432 544s ### End test 080_start.conf.t ### 544s 544s ### PostgreSQL test 085_pg_ctl.conf.t ### 544s 1..33 544s ok 1 - prlimit --core=0:unlimited --pid=15882 544s ok 2 - set core file size to unlimited 544s ok 3 - sh -c 'ulimit -Hc' 544s ok 4 - core file size is unlimited 545s ok 5 - pg_createcluster 18 main 545s ok 6 - /etc/postgresql/18/main/pg_ctl.conf exists 548s ok 7 - pg_ctlcluster 18 main start 548s ok 8 - starting cluster as root 548s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 548s ok 10 - soft core size is 0 548s # hard core file size limit of root-started postgres process is unlimited 548s ok 11 - set pg_ctl default option to -c 550s ok 12 - pg_ctlcluster 18 main restart 550s ok 13 - restarting cluster as root 550s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 550s ok 15 - soft core size is unlimited 550s ok 16 - pg_ctlcluster 18 main stop 550s ok 17 - stopping cluster 550s ok 18 - restored pg_ctl default option 553s ok 19 - pg_ctlcluster 18 main start -- -c 553s ok 20 - starting cluster with -c on the command line as postgres 553s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/18-main.pid 553s ok 22 - soft core size is unlimited 553s ok 23 - pg_ctlcluster 18 main stop 553s ok 24 - stopping cluster 554s ok 25 - dropping cluster 554s # Cleanup 554s ok 26 - Cleanup: No clusters left behind 554s ok 27 - No postgres processes left behind 554s ok 28 - No files in /etc/postgresql left behind 554s ok 29 - No files in /var/lib/postgresql left behind 554s ok 30 - No files in /var/run/postgresql left behind 554s ok 31 - No files in /var/log/postgresql left behind 554s ok 32 - PostgreSQL TCP ports are closed 554s ok 33 - Next free port is 5432 554s ### End test 085_pg_ctl.conf.t ### 554s 554s ### PostgreSQL test 090_multicluster.t ### 554s 1..125 556s ok 1 - pg_createcluster 18 old 557s ok 2 - pg_createcluster 18 new1 558s ok 3 - pg_createcluster 18 new2 560s ok 4 - starting cluster 18/old 563s ok 5 - starting cluster 18/new1 565s ok 6 - starting cluster 18/new2 565s ok 7 - pg_lsclusters -h | sort -k3 565s ok 8 - clusters have the correct ports, skipping used 5433 565s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 565s ok 10 - createdb --version 565s ok 11 - pg_wrapper selects port 5432 as default cluster 565s ok 12 - createdb --cluster 18/new1 --version 565s ok 13 - pg_wrapper --cluster works 565s ok 14 - createdb --cluster 18/foo --version 565s ok 15 - pg_wrapper --cluster errors out for invalid cluster 565s ok 16 - createdb --cluster 18/new1 test 565s ok 17 - correct output of createdb --cluster 18/new1 test 565s ok 18 - psql -Atl --cluster 18/new1 565s ok 19 - test db appears in cluster new1 565s ok 20 - psql -Atl --cluster 18/new2 565s ok 21 - test db does not appear in cluster new2 565s ok 22 - psql -Atl 565s ok 23 - test db does not appear in default cluster 566s ok 24 - psql --cluster 18/127.0.0.1: -Atc 'show port' template1 566s ok 25 - psql --cluster 18/127.0.0.1: defaults to port 5432 566s ok 26 - createdb --cluster 18/127.0.0.1:5432 --version 566s ok 27 - createdb --cluster 18/127.0.0.1:5432 uses latest client version 566s ok 28 - psql -Atl --cluster 18/localhost:5434 566s ok 29 - test db appears in cluster 18/localhost:5434 566s ok 30 - psql -Atl --cluster 18/localhost:5440 566s ok 31 - test db does not appear in cluster 18/localhost:5440 566s ok 32 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:5435 566s ok 33 - psql --cluster 18/localhost:5435 fails due to nonexisting port 566s ok 34 - LC_MESSAGES=C psql -Atl --cluster 18/localhost:a 566s ok 35 - psql --cluster 18/localhost:a fails due to invalid syntax 566s ok 36 - LC_MESSAGES=C psql -Atl --cluster 18/doesnotexi.st 566s ok 37 - psql --cluster 18/doesnotexi.st fails due to invalid syntax 566s ok 38 - psql -Atl --cluster 6.4/localhost: 566s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 566s ok 40 - psql -Atl 566s ok 41 - PGCLUSTER selection (1) 566s ok 42 - psql -Atl 566s ok 43 - PGCLUSTER selection (2) 566s ok 44 - psql -l 566s ok 45 - invalid PGCLUSTER value 566s ok 46 - createdb --version 566s ok 47 - PGCLUSTER network cluster selection (1) 566s ok 48 - psql -Atl 566s ok 49 - PGCLUSTER network cluster selection (2) 566s ok 50 - psql -Atl 566s ok 51 - PGCLUSTER network cluster selection (3) 566s ok 52 - LC_MESSAGES=C psql -Atl 566s ok 53 - psql --cluster 18/localhost:5435 fails due to nonexisting port 566s ok 54 - psql -Atc "show port" template1 566s ok 55 - PGPORT selection (1) 566s ok 56 - psql -Atc "show port" template1 566s ok 57 - PGPORT selection (2) 566s ok 58 - createdb --version 566s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 566s ok 60 - psql -Atc "show port" template1 566s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 566s ok 62 - psql --cluster 18/new1 -Atc 'select current_database()' 566s ok 63 - PGDATABASE environment variable works 566s ok 64 - createdb --version 566s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 566s ok 66 - createdb --cluster 18/new1 --version 566s ok 67 - pg_wrapper --cluster works with empty user_clusters 567s ok 68 - createdb --version 567s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 18 new1 *' 567s ok 70 - psql -Atc "select current_database()" 567s ok 71 - pg_wrapper selects correct database with user_clusters '* * 18 new1 test' 567s ok 72 - psql -Atc 'select current_database()' 567s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 567s ok 74 - createdb --version 567s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 567s ok 76 - createdb --version 567s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 567s ok 78 - createdb --version 567s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 567s ok 80 - createdb --version 567s ok 81 - pg_wrapper selects correct version with per-user user_clusters 567s ok 82 - createdb --version 567s ok 83 - pg_wrapper selects correct version with per-user user_clusters 567s ok 84 - createdb --version 567s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 567s ok 86 - psql -Atl 567s ok 87 - $PGHOST overrides user_clusters 567s ok 88 - psql --cluster 18/localhost:5434 -Atc 'select current_database()' test 567s ok 89 - --cluster overrides $PGHOST 567s ok 90 - createdb --version 567s ok 91 - pg_wrapper ignores invalid lines in user_clusters 567s ok 92 - psql -Atc 'select current_database()' 567s ok 93 - pg_service conf selection 1 567s ok 94 - psql -Atc 'select current_database()' 567s ok 95 - pg_service conf selection 2 567s ok 96 - psql -Atc 'select current_database()' 567s ok 97 - pg_service conf selection 3 567s ok 98 - stopping cluster 18/old 570s ok 99 - restarting cluster 18/old 570s ok 100 # skip rust coreutils sort -k option regression. See LP: #2125504 570s ok 101 # skip rust coreutils sort -k option regression. See LP: #2125504 570s ok 102 - psql -l 570s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 570s ok 104 - psql -Atl --cluster 18/new1 570s ok 105 - --cluster selects appropriate cluster 570s ok 106 - psql -Atl -p 5434 570s ok 107 - -p selects appropriate cluster 570s ok 108 - psql -Atlp 5434 570s ok 109 - -Atlp selects appropriate cluster 570s ok 110 - psql -Atl --port 5434 570s ok 111 - --port selects appropriate cluster 570s ok 112 - env PGPORT=5434 psql -Atl 570s ok 113 - $PGPORT selects appropriate cluster 570s ok 114 - Restoring original /etc/postgresql-common/user_clusters 572s ok 115 - dropping 18/new1 574s ok 116 - dropping 18/new2 575s ok 117 - dropping 18/old 575s # Cleanup 575s ok 118 - Cleanup: No clusters left behind 575s ok 119 - No postgres processes left behind 575s ok 120 - No files in /etc/postgresql left behind 575s ok 121 - No files in /var/lib/postgresql left behind 575s ok 122 - No files in /var/run/postgresql left behind 575s ok 123 - No files in /var/log/postgresql left behind 575s ok 124 - PostgreSQL TCP ports are closed 575s ok 125 - Next free port is 5432 575s ### End test 090_multicluster.t ### 575s 575s ### PostgreSQL test 110_integrate_cluster.t ### 575s 1..32 578s ok 1 - /usr/lib/postgresql/18/bin/initdb /tmp/6XQAQUfVQ1/c/postgres 578s ok 2 - creating raw initdb cluster for user postgres 578s ok 3 - pg_createcluster 18 postgres -d /tmp/6XQAQUfVQ1/c/postgres 578s ok 4 - integrating postgres cluster 578s ok 5 - pg_lsclusters 578s ok 6 - correct pg_lsclusters output 580s ok 7 - pg_ctlcluster 18 postgres start 580s ok 8 - starting cluster postgres 580s ok 9 - pg_lsclusters 580s ok 10 - correct pg_lsclusters output 582s ok 11 - dropping cluster postgres 582s ok 12 - No files in temporary cluster dir left behind 584s ok 13 - /usr/lib/postgresql/18/bin/initdb /tmp/6XQAQUfVQ1/c/nobody 584s ok 14 - creating raw initdb cluster for user nobody 585s ok 15 - pg_createcluster 18 nobody -d /tmp/6XQAQUfVQ1/c/nobody 585s ok 16 - integrating nobody cluster 585s ok 17 - pg_lsclusters 585s ok 18 - correct pg_lsclusters output 587s ok 19 - pg_ctlcluster 18 nobody start 587s ok 20 - starting cluster nobody 587s ok 21 - pg_lsclusters 587s ok 22 - correct pg_lsclusters output 589s ok 23 - dropping cluster nobody 589s ok 24 - No files in temporary cluster dir left behind 589s # Cleanup 589s ok 25 - Cleanup: No clusters left behind 589s ok 26 - No postgres processes left behind 589s ok 27 - No files in /etc/postgresql left behind 589s ok 28 - No files in /var/lib/postgresql left behind 589s ok 29 - No files in /var/run/postgresql left behind 589s ok 30 - No files in /var/log/postgresql left behind 589s ok 31 - PostgreSQL TCP ports are closed 589s ok 32 - Next free port is 5432 589s ### End test 110_integrate_cluster.t ### 589s 589s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 589s 1..1 589s ok 1 - only one major version installed, skipping upgrade tests 589s ### End test 120_pg_upgradecluster_scripts.t ### 589s 589s ### PostgreSQL test 130_nonroot_admin.t ### 589s 1..22 592s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 592s ok 2 - pg_lsclusters -h 592s ok 3 - correct output of pg_lsclusters -h 592s ok 4 - psql -Atl 592s ok 5 - correct output of psql -Atl 593s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 593s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 593s # Cleanup 593s ok 15 - Cleanup: No clusters left behind 593s ok 16 - No postgres processes left behind 593s ok 17 - No files in /etc/postgresql left behind 593s ok 18 - No files in /var/lib/postgresql left behind 593s ok 19 - No files in /var/run/postgresql left behind 593s ok 20 - No files in /var/log/postgresql left behind 593s ok 21 - PostgreSQL TCP ports are closed 593s ok 22 - Next free port is 5432 593s ### End test 130_nonroot_admin.t ### 593s 593s ### PostgreSQL test 135_pg_virtualenv.t ### 593s 1..20 598s ok 1 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 598s ok 2 - running pg_virtualenv as root 601s ok 3 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 601s ok 4 - running pg_virtualenv as postgres 605s ok 5 - pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 605s ok 6 - running pg_virtualenv as nobody 608s ok 7 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 608s ok 8 - running fakeroot pg_virtualenv as root 612s ok 9 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 612s ok 10 - running fakeroot pg_virtualenv as postgres 615s ok 11 - fakeroot pg_virtualenv -v 18 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 615s ok 12 - running fakeroot pg_virtualenv as nobody 615s # Cleanup 615s ok 13 - Cleanup: No clusters left behind 615s ok 14 - No postgres processes left behind 615s ok 15 - No files in /etc/postgresql left behind 615s ok 16 - No files in /var/lib/postgresql left behind 615s ok 17 - No files in /var/run/postgresql left behind 615s ok 18 - No files in /var/log/postgresql left behind 615s ok 19 - PostgreSQL TCP ports are closed 615s ok 20 - Next free port is 5432 615s ### End test 135_pg_virtualenv.t ### 615s 615s ### PostgreSQL test 140_pg_config.t ### 615s 1..38 616s # Multiarch is enabled 616s # checking version specific output for 18 616s ok 1 - /usr/lib/postgresql/18/bin/pg_config --pgxs 616s ok 2 - correct output of /usr/lib/postgresql/18/bin/pg_config --pgxs 616s ok 3 - /usr/lib/postgresql/18/bin/pg_config --libdir 616s ok 4 - correct output of /usr/lib/postgresql/18/bin/pg_config --libdir 616s ok 5 - /usr/lib/postgresql/18/bin/pg_config --pkglibdir 616s ok 6 - correct output of /usr/lib/postgresql/18/bin/pg_config --pkglibdir 616s ok 7 - /usr/lib/postgresql/18/bin/pg_config --bindir 616s ok 8 - correct output of /usr/lib/postgresql/18/bin/pg_config --bindir 616s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/18/lib/pgxs/src/Makefile.global 616s # checking pg_config output (should behave like version 18) 616s ok 15 - pg_config 616s ok 16 - correct output of pg_config 616s ok 17 - pg_config --help 616s ok 18 - correct output of pg_config --help 616s ok 19 - pg_config --pgxs 616s ok 20 - correct output of pg_config --pgxs 616s ok 21 - pg_config --libdir 616s ok 22 - correct output of pg_config --libdir 616s ok 23 - pg_config --pkglibdir 616s ok 24 - correct output of pg_config --pkglibdir 616s ok 25 - pg_config --bindir 616s ok 26 - correct output of pg_config --bindir 616s # checking pg_config.libpq-dev output (should behave like version 18) 616s ok 27 - pg_config.libpq-dev 616s ok 28 - correct output of pg_config.libpq-dev 616s ok 29 - pg_config.libpq-dev --help 616s ok 30 - correct output of pg_config.libpq-dev --help 616s ok 31 - pg_config.libpq-dev --pgxs 616s ok 32 - correct output of pg_config.libpq-dev --pgxs 616s ok 33 - pg_config.libpq-dev --libdir 616s ok 34 - correct output of pg_config.libpq-dev --libdir 616s ok 35 - pg_config.libpq-dev --pkglibdir 616s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 616s ok 37 - pg_config.libpq-dev --bindir 616s ok 38 - correct output of pg_config.libpq-dev --bindir 616s ### End test 140_pg_config.t ### 616s 616s ### PostgreSQL test 150_tsearch_stemming.t ### 616s 1..37 616s ok 1 - pg_updatedicts succeeded 616s ok 2 - pg_updatedicts created en_us.affix 616s ok 3 - pg_updatedicts created en_us.dict 616s ok 4 - pg_updatedicts created 18 en_us.affix symlink 616s ok 5 - pg_updatedicts created 18 en_us.dict symlink 620s ok 6 - pg_createcluster 18 main 620s ok 7 - createdb fts 620s ok 8 - correct output of createdb fts 620s ok 9 - creating en_US full text search configuration 620s ok 10 - creating data table and search index 620s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 620s ok 12 - stem search of correct word 620s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 620s ok 14 - stem search of correct word 620s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 620s ok 16 - stem search of unknown word 620s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 620s ok 18 - full text search, exact word 620s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 620s ok 20 - full text search for word stem 621s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 621s ok 22 - full text search for word substring fails 621s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 621s ok 24 - full text search, exact unicode word 621s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 621s ok 26 - full text search for unicode word stem 621s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 621s ok 28 - full text search for unicode word substring fails 622s ok 29 622s # Cleanup 622s ok 30 - Cleanup: No clusters left behind 622s ok 31 - No postgres processes left behind 622s ok 32 - No files in /etc/postgresql left behind 622s ok 33 - No files in /var/lib/postgresql left behind 622s ok 34 - No files in /var/run/postgresql left behind 622s ok 35 - No files in /var/log/postgresql left behind 622s ok 36 - PostgreSQL TCP ports are closed 622s ok 37 - Next free port is 5432 622s ### End test 150_tsearch_stemming.t ### 622s 622s ### PostgreSQL test 160_alternate_confroot.t ### 622s 1..28 627s ok 1 627s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 627s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 627s ok 4 - pg_lsclusters -h 627s ok 5 - correct output of pg_lsclusters -h 627s ok 6 - psql -Atl 627s ok 7 - correct output of psql -Atl 627s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 627s ok 9 - ... 627s ok 10 - ... 627s ok 11 - ... 627s ok 12 - ... 627s ok 13 - ... 627s ok 14 - ... 627s ok 15 - pg_dropcluster 18 test --stop 627s ok 16 - correct output of pg_dropcluster 18 test --stop 627s ok 17 - pg_lsclusters -h 627s ok 18 - correct output of pg_lsclusters -h 627s ok 19 - No files in root/data left behind 627s ok 20 - No cruft in root dir left behind 627s # Cleanup 627s ok 21 - Cleanup: No clusters left behind 627s ok 22 - No postgres processes left behind 627s ok 23 - No files in /etc/postgresql left behind 627s ok 24 - No files in /var/lib/postgresql left behind 627s ok 25 - No files in /var/run/postgresql left behind 627s ok 26 - No files in /var/log/postgresql left behind 627s ok 27 - PostgreSQL TCP ports are closed 627s ok 28 - Next free port is 5432 627s ### End test 160_alternate_confroot.t ### 627s 627s ### PostgreSQL test 170_extensions.t ### 627s # Running tests for 18 631s ok 1 - pg_createcluster 18 main 631s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 631s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 631s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 631s ok 5 - extension amcheck installs without error 631s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 631s ok 7 - extension amcheck removes without error 631s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 631s ok 9 - extension autoinc installs without error 631s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 631s ok 11 - extension autoinc removes without error 631s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 631s ok 13 - extension bloom installs without error 631s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 631s ok 15 - extension bloom removes without error 631s ok 16 - psql -qc 'CREATE EXTENSION plperl' 631s ok 17 - bool_plperl dependency plperl installs without error 631s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 631s ok 19 - extension bool_plperl installs without error 631s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 631s ok 21 - extension bool_plperl removes without error 631s ok 22 - psql -qc 'DROP EXTENSION plperl' 631s ok 23 - bool_plperl dependency extension plperl removes without error 631s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 631s ok 25 - bool_plperlu dependency plperlu installs without error 631s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 631s ok 27 - extension bool_plperlu installs without error 631s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 631s ok 29 - extension bool_plperlu removes without error 631s ok 30 - psql -qc 'DROP EXTENSION plperlu' 631s ok 31 - bool_plperlu dependency extension plperlu removes without error 631s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 631s ok 33 - extension btree_gin installs without error 632s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 632s ok 35 - extension btree_gin removes without error 632s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 632s ok 37 - extension btree_gist installs without error 632s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 632s ok 39 - extension btree_gist removes without error 632s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 632s ok 41 - extension citext installs without error 632s ok 42 - psql -qc 'DROP EXTENSION "citext"' 632s ok 43 - extension citext removes without error 632s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 632s ok 45 - extension cube installs without error 632s ok 46 - psql -qc 'DROP EXTENSION "cube"' 632s ok 47 - extension cube removes without error 632s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 632s ok 49 - extension dblink installs without error 632s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 632s ok 51 - extension dblink removes without error 632s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 632s ok 53 - extension dict_int installs without error 632s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 632s ok 55 - extension dict_int removes without error 632s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 632s ok 57 - extension dict_xsyn installs without error 632s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 632s ok 59 - extension dict_xsyn removes without error 632s ok 60 - psql -qc 'CREATE EXTENSION cube' 632s ok 61 - earthdistance dependency cube installs without error 632s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 632s ok 63 - extension earthdistance installs without error 632s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 632s ok 65 - extension earthdistance removes without error 632s ok 66 - psql -qc 'DROP EXTENSION cube' 632s ok 67 - earthdistance dependency extension cube removes without error 632s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 632s ok 69 - extension file_fdw installs without error 633s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 633s ok 71 - extension file_fdw removes without error 633s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 633s ok 73 - extension fuzzystrmatch installs without error 633s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 633s ok 75 - extension fuzzystrmatch removes without error 633s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 633s ok 77 - extension hstore installs without error 633s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 633s ok 79 - extension hstore removes without error 633s ok 80 - psql -qc 'CREATE EXTENSION hstore' 633s ok 81 - hstore_plperl dependency hstore installs without error 633s ok 82 - psql -qc 'CREATE EXTENSION plperl' 633s ok 83 - hstore_plperl dependency plperl installs without error 633s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 633s ok 85 - extension hstore_plperl installs without error 633s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 633s ok 87 - extension hstore_plperl removes without error 633s ok 88 - psql -qc 'DROP EXTENSION hstore' 633s ok 89 - hstore_plperl dependency extension hstore removes without error 633s ok 90 - psql -qc 'DROP EXTENSION plperl' 633s ok 91 - hstore_plperl dependency extension plperl removes without error 633s ok 92 - psql -qc 'CREATE EXTENSION hstore' 633s ok 93 - hstore_plperlu dependency hstore installs without error 633s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 633s ok 95 - hstore_plperlu dependency plperlu installs without error 633s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 633s ok 97 - extension hstore_plperlu installs without error 633s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 633s ok 99 - extension hstore_plperlu removes without error 633s ok 100 - psql -qc 'DROP EXTENSION hstore' 633s ok 101 - hstore_plperlu dependency extension hstore removes without error 633s ok 102 - psql -qc 'DROP EXTENSION plperlu' 633s ok 103 - hstore_plperlu dependency extension plperlu removes without error 633s ok 104 - psql -qc 'CREATE EXTENSION hstore' 633s ok 105 - hstore_plpython3u dependency hstore installs without error 633s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 633s ok 107 - hstore_plpython3u dependency plpython3u installs without error 633s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 633s ok 109 - extension hstore_plpython3u installs without error 633s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 633s ok 111 - extension hstore_plpython3u removes without error 634s ok 112 - psql -qc 'DROP EXTENSION hstore' 634s ok 113 - hstore_plpython3u dependency extension hstore removes without error 634s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 634s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 634s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 634s ok 117 - extension insert_username installs without error 634s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 634s ok 119 - extension insert_username removes without error 634s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 634s ok 121 - extension intagg installs without error 634s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 634s ok 123 - extension intagg removes without error 634s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 634s ok 125 - extension intarray installs without error 634s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 634s ok 127 - extension intarray removes without error 634s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 634s ok 129 - extension isn installs without error 634s ok 130 - psql -qc 'DROP EXTENSION "isn"' 634s ok 131 - extension isn removes without error 634s ok 132 - psql -qc 'CREATE EXTENSION plperl' 634s ok 133 - jsonb_plperl dependency plperl installs without error 634s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 634s ok 135 - extension jsonb_plperl installs without error 634s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 634s ok 137 - extension jsonb_plperl removes without error 634s ok 138 - psql -qc 'DROP EXTENSION plperl' 634s ok 139 - jsonb_plperl dependency extension plperl removes without error 634s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 634s ok 141 - jsonb_plperlu dependency plperlu installs without error 634s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 634s ok 143 - extension jsonb_plperlu installs without error 634s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 634s ok 145 - extension jsonb_plperlu removes without error 634s ok 146 - psql -qc 'DROP EXTENSION plperlu' 634s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 634s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 634s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 635s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 635s ok 151 - extension jsonb_plpython3u installs without error 635s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 635s ok 153 - extension jsonb_plpython3u removes without error 635s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 635s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 635s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 635s ok 157 - extension lo installs without error 635s ok 158 - psql -qc 'DROP EXTENSION "lo"' 635s ok 159 - extension lo removes without error 635s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 635s ok 161 - extension ltree installs without error 635s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 635s ok 163 - extension ltree removes without error 635s ok 164 - psql -qc 'CREATE EXTENSION ltree' 635s ok 165 - ltree_plpython3u dependency ltree installs without error 635s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 635s ok 167 - ltree_plpython3u dependency plpython3u installs without error 635s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 635s ok 169 - extension ltree_plpython3u installs without error 635s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 635s ok 171 - extension ltree_plpython3u removes without error 635s ok 172 - psql -qc 'DROP EXTENSION ltree' 635s ok 173 - ltree_plpython3u dependency extension ltree removes without error 635s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 635s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 635s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 635s ok 177 - extension moddatetime installs without error 635s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 635s ok 179 - extension moddatetime removes without error 635s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 635s ok 181 - extension pageinspect installs without error 635s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 635s ok 183 - extension pageinspect removes without error 635s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 635s ok 185 - extension pg_buffercache installs without error 635s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 635s ok 187 - extension pg_buffercache removes without error 635s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 635s ok 189 - extension pg_freespacemap installs without error 636s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 636s ok 191 - extension pg_freespacemap removes without error 636s ok 192 - psql -qc 'CREATE EXTENSION "pg_logicalinspect"' 636s ok 193 - extension pg_logicalinspect installs without error 636s ok 194 - psql -qc 'DROP EXTENSION "pg_logicalinspect"' 636s ok 195 - extension pg_logicalinspect removes without error 636s ok 196 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 636s ok 197 - extension pg_prewarm installs without error 636s ok 198 - psql -qc 'DROP EXTENSION "pg_prewarm"' 636s ok 199 - extension pg_prewarm removes without error 636s ok 200 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 636s ok 201 - extension pg_stat_statements installs without error 636s ok 202 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 636s ok 203 - extension pg_stat_statements removes without error 636s ok 204 - psql -qc 'CREATE EXTENSION "pg_surgery"' 636s ok 205 - extension pg_surgery installs without error 636s ok 206 - psql -qc 'DROP EXTENSION "pg_surgery"' 636s ok 207 - extension pg_surgery removes without error 636s ok 208 - psql -qc 'CREATE EXTENSION "pg_trgm"' 636s ok 209 - extension pg_trgm installs without error 636s ok 210 - psql -qc 'DROP EXTENSION "pg_trgm"' 636s ok 211 - extension pg_trgm removes without error 636s ok 212 - psql -qc 'CREATE EXTENSION "pg_visibility"' 636s ok 213 - extension pg_visibility installs without error 636s ok 214 - psql -qc 'DROP EXTENSION "pg_visibility"' 636s ok 215 - extension pg_visibility removes without error 636s ok 216 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 636s ok 217 - extension pg_walinspect installs without error 636s ok 218 - psql -qc 'DROP EXTENSION "pg_walinspect"' 636s ok 219 - extension pg_walinspect removes without error 636s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 636s ok 221 - extension pgcrypto installs without error 636s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 636s ok 223 - extension pgcrypto removes without error 636s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 636s ok 225 - extension pgrowlocks installs without error 636s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 636s ok 227 - extension pgrowlocks removes without error 636s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 636s ok 229 - extension pgstattuple installs without error 637s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 637s ok 231 - extension pgstattuple removes without error 637s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 637s ok 233 - extension plperl installs without error 637s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 637s ok 235 - extension plperl removes without error 637s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 637s ok 237 - extension plperlu installs without error 637s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 637s ok 239 - extension plperlu removes without error 637s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 637s ok 241 - extension plpython3u installs without error 637s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 637s ok 243 - extension plpython3u removes without error 637s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 637s ok 245 - extension pltcl installs without error 637s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 637s ok 247 - extension pltcl removes without error 637s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 637s ok 249 - extension pltclu installs without error 637s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 637s ok 251 - extension pltclu removes without error 637s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 637s ok 253 - extension postgres_fdw installs without error 637s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 637s ok 255 - extension postgres_fdw removes without error 637s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 637s ok 257 - extension refint installs without error 637s ok 258 - psql -qc 'DROP EXTENSION "refint"' 637s ok 259 - extension refint removes without error 637s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 637s ok 261 - extension seg installs without error 637s ok 262 - psql -qc 'DROP EXTENSION "seg"' 637s ok 263 - extension seg removes without error 637s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 637s ok 265 - extension sslinfo installs without error 637s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 637s ok 267 - extension sslinfo removes without error 637s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 637s ok 269 - extension tablefunc installs without error 638s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 638s ok 271 - extension tablefunc removes without error 638s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 638s ok 273 - extension tcn installs without error 638s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 638s ok 275 - extension tcn removes without error 638s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 638s ok 277 - extension tsm_system_rows installs without error 638s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 638s ok 279 - extension tsm_system_rows removes without error 638s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 638s ok 281 - extension tsm_system_time installs without error 638s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 638s ok 283 - extension tsm_system_time removes without error 638s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 638s ok 285 - extension unaccent installs without error 638s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 638s ok 287 - extension unaccent removes without error 638s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 638s ok 289 - extension uuid-ossp installs without error 638s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 638s ok 291 - extension uuid-ossp removes without error 638s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 638s ok 293 - extension xml2 installs without error 638s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 638s ok 295 - extension xml2 removes without error 640s ok 296 - pg_dropcluster 18 main 640s # Cleanup 640s ok 297 - Cleanup: No clusters left behind 640s ok 298 - No postgres processes left behind 640s ok 299 - No files in /etc/postgresql left behind 640s ok 300 - No files in /var/lib/postgresql left behind 640s ok 301 - No files in /var/run/postgresql left behind 640s ok 302 - No files in /var/log/postgresql left behind 640s ok 303 - PostgreSQL TCP ports are closed 640s ok 304 - Next free port is 5432 640s 1..304 640s ### End test 170_extensions.t ### 640s 640s ### PostgreSQL test 180_ecpg.t ### 640s 1..14 640s ok 1 - ecpg test.pgc 640s ok 2 - ecpg processing 640s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 640s ok 4 - compiling ecpg output 648s ok 5 - pg_virtualenv /tmp/tmp.dKj07SBWlk/test 648s ok 6 - test program runs and gives correct output 648s # Cleanup 648s ok 7 - Cleanup: No clusters left behind 648s ok 8 - No postgres processes left behind 648s ok 9 - No files in /etc/postgresql left behind 648s ok 10 - No files in /var/lib/postgresql left behind 648s ok 11 - No files in /var/run/postgresql left behind 648s ok 12 - No files in /var/log/postgresql left behind 648s ok 13 - PostgreSQL TCP ports are closed 648s ok 14 - Next free port is 5432 648s ### End test 180_ecpg.t ### 648s 648s ### PostgreSQL test 190_pg_buildext.t ### 648s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 648s 1..1 648s ### End test 190_pg_buildext.t ### 648s 648s ### PostgreSQL test 200_maintscripts.t ### 648s 1..15 648s # We are running systemd 651s ok 1 - pg_createcluster 18 main --start 651s ok 2 - postmaster PID is 20971 653s ok 3 - apt-get update -q 653s # postgresql-common: 653s # Installed: 282ubuntu1 653s # Candidate: 282ubuntu1 653s # Version table: 653s # *** 282ubuntu1 500 653s # 500 http://ftpmaster.internal/ubuntu resolute/main armhf Packages 653s # 100 /var/lib/dpkg/status 656s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 657s # postgresql-common: 657s # Installed: 282ubuntu1 657s # Candidate: 282ubuntu1 657s # Version table: 657s # *** 282ubuntu1 500 657s # 500 http://ftpmaster.internal/ubuntu resolute/main armhf Packages 657s # 100 /var/lib/dpkg/status 657s ok 5 - postmaster PID is 20971 657s ok 6 - postmaster was not restarted 658s ok 7 - pg_dropcluster 18 main --stop 658s # Cleanup 658s ok 8 - Cleanup: No clusters left behind 658s ok 9 - No postgres processes left behind 658s ok 10 - No files in /etc/postgresql left behind 658s ok 11 - No files in /var/lib/postgresql left behind 658s ok 12 - No files in /var/run/postgresql left behind 658s ok 13 - No files in /var/log/postgresql left behind 658s ok 14 - PostgreSQL TCP ports are closed 658s ok 15 - Next free port is 5432 658s ### End test 200_maintscripts.t ### 658s 659s autopkgtest [23:54:07]: test run-testsuite: -----------------------] 663s autopkgtest [23:54:11]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 663s run-testsuite PASS 667s autopkgtest [23:54:15]: test installcheck: preparing testbed 689s autopkgtest [23:54:37]: testbed dpkg architecture: armhf 691s autopkgtest [23:54:39]: testbed apt version: 3.1.11 694s autopkgtest [23:54:42]: @@@@@@@@@@@@@@@@@@@@ test bed setup 696s autopkgtest [23:54:44]: testbed release detected to be: resolute 704s autopkgtest [23:54:52]: updating testbed package index (apt update) 705s Get:1 http://ftpmaster.internal/ubuntu resolute-proposed InRelease [87.8 kB] 706s Get:2 http://ftpmaster.internal/ubuntu resolute InRelease [87.8 kB] 706s Hit:3 http://ftpmaster.internal/ubuntu resolute-updates InRelease 706s Hit:4 http://ftpmaster.internal/ubuntu resolute-security InRelease 706s Get:5 http://ftpmaster.internal/ubuntu resolute-proposed/restricted Sources [9848 B] 706s Get:6 http://ftpmaster.internal/ubuntu resolute-proposed/main Sources [81.8 kB] 706s Get:7 http://ftpmaster.internal/ubuntu resolute-proposed/universe Sources [769 kB] 706s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse Sources [22.4 kB] 706s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf Packages [137 kB] 706s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/restricted armhf Packages [940 B] 706s Get:11 http://ftpmaster.internal/ubuntu resolute-proposed/universe armhf Packages [402 kB] 706s Get:12 http://ftpmaster.internal/ubuntu resolute-proposed/multiverse armhf Packages [9140 B] 706s Get:13 http://ftpmaster.internal/ubuntu resolute/multiverse Sources [312 kB] 706s Get:14 http://ftpmaster.internal/ubuntu resolute/main Sources [1412 kB] 706s Get:15 http://ftpmaster.internal/ubuntu resolute/universe Sources [21.3 MB] 707s Get:16 http://ftpmaster.internal/ubuntu resolute/main armhf Packages [1369 kB] 707s Get:17 http://ftpmaster.internal/ubuntu resolute/universe armhf Packages [15.2 MB] 708s Get:18 http://ftpmaster.internal/ubuntu resolute/multiverse armhf Packages [184 kB] 711s Fetched 41.4 MB in 5s (7674 kB/s) 712s Reading package lists... 717s autopkgtest [23:55:05]: upgrading testbed (apt dist-upgrade and autopurge) 719s Reading package lists... 719s Building dependency tree... 719s Reading state information... 719s Calculating upgrade... 720s The following packages will be upgraded: 720s cron cron-daemon-common curl fwupd libcap2 libcap2-bin libcurl3t64-gnutls 720s libcurl4t64 libfwupd3 libpam-cap liburcu8t64 libxml2-16 lto-disabled-list 720s 13 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 720s Need to get 3437 kB of archives. 720s After this operation, 74.8 kB of additional disk space will be used. 720s Get:1 http://ftpmaster.internal/ubuntu resolute/main armhf cron armhf 3.0pl1-200ubuntu1 [85.3 kB] 720s Get:2 http://ftpmaster.internal/ubuntu resolute/main armhf libcap2 armhf 1:2.75-10ubuntu1 [26.9 kB] 720s Get:3 http://ftpmaster.internal/ubuntu resolute/main armhf libpam-cap armhf 1:2.75-10ubuntu1 [11.8 kB] 720s Get:4 http://ftpmaster.internal/ubuntu resolute/main armhf libcap2-bin armhf 1:2.75-10ubuntu1 [31.8 kB] 720s Get:5 http://ftpmaster.internal/ubuntu resolute/main armhf libxml2-16 armhf 2.15.1+dfsg-0.3 [515 kB] 720s Get:6 http://ftpmaster.internal/ubuntu resolute/main armhf cron-daemon-common all 3.0pl1-200ubuntu1 [15.7 kB] 720s Get:7 http://ftpmaster.internal/ubuntu resolute/main armhf liburcu8t64 armhf 0.15.5-1 [58.2 kB] 720s Get:8 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf curl armhf 8.17.0-1ubuntu1 [262 kB] 720s Get:9 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf libcurl4t64 armhf 8.17.0-1ubuntu1 [370 kB] 720s Get:10 http://ftpmaster.internal/ubuntu resolute-proposed/main armhf libcurl3t64-gnutls armhf 8.17.0-1ubuntu1 [363 kB] 721s Get:11 http://ftpmaster.internal/ubuntu resolute/main armhf fwupd armhf 2.0.17-6 [1557 kB] 721s Get:12 http://ftpmaster.internal/ubuntu resolute/main armhf libfwupd3 armhf 2.0.17-6 [129 kB] 721s Get:13 http://ftpmaster.internal/ubuntu resolute/main armhf lto-disabled-list all 72 [12.4 kB] 721s Fetched 3437 kB in 1s (4898 kB/s) 721s (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 ... 65904 files and directories currently installed.) 721s Preparing to unpack .../cron_3.0pl1-200ubuntu1_armhf.deb ... 721s Unpacking cron (3.0pl1-200ubuntu1) over (3.0pl1-196ubuntu2) ... 721s Preparing to unpack .../libcap2_1%3a2.75-10ubuntu1_armhf.deb ... 721s Unpacking libcap2:armhf (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 721s Setting up libcap2:armhf (1:2.75-10ubuntu1) ... 721s (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 ... 65904 files and directories currently installed.) 721s Preparing to unpack .../00-libpam-cap_1%3a2.75-10ubuntu1_armhf.deb ... 721s Unpacking libpam-cap:armhf (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 722s Preparing to unpack .../01-libcap2-bin_1%3a2.75-10ubuntu1_armhf.deb ... 722s Unpacking libcap2-bin (1:2.75-10ubuntu1) over (1:2.75-7ubuntu2) ... 722s Preparing to unpack .../02-libxml2-16_2.15.1+dfsg-0.3_armhf.deb ... 722s Unpacking libxml2-16:armhf (2.15.1+dfsg-0.3) over (2.14.5+dfsg-0.2build1) ... 722s Preparing to unpack .../03-cron-daemon-common_3.0pl1-200ubuntu1_all.deb ... 722s Unpacking cron-daemon-common (3.0pl1-200ubuntu1) over (3.0pl1-196ubuntu2) ... 722s Preparing to unpack .../04-liburcu8t64_0.15.5-1_armhf.deb ... 722s Unpacking liburcu8t64:armhf (0.15.5-1) over (0.15.4-1) ... 722s Preparing to unpack .../05-curl_8.17.0-1ubuntu1_armhf.deb ... 722s Unpacking curl (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 722s Preparing to unpack .../06-libcurl4t64_8.17.0-1ubuntu1_armhf.deb ... 722s Unpacking libcurl4t64:armhf (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 722s Preparing to unpack .../07-libcurl3t64-gnutls_8.17.0-1ubuntu1_armhf.deb ... 722s Unpacking libcurl3t64-gnutls:armhf (8.17.0-1ubuntu1) over (8.14.1-2ubuntu1) ... 722s Preparing to unpack .../08-fwupd_2.0.17-6_armhf.deb ... 722s Unpacking fwupd (2.0.17-6) over (2.0.17-2) ... 722s Preparing to unpack .../09-libfwupd3_2.0.17-6_armhf.deb ... 722s Unpacking libfwupd3:armhf (2.0.17-6) over (2.0.17-2) ... 722s Preparing to unpack .../10-lto-disabled-list_72_all.deb ... 722s Unpacking lto-disabled-list (72) over (71) ... 722s Setting up liburcu8t64:armhf (0.15.5-1) ... 722s Setting up lto-disabled-list (72) ... 722s Setting up libcurl4t64:armhf (8.17.0-1ubuntu1) ... 722s Setting up libxml2-16:armhf (2.15.1+dfsg-0.3) ... 722s Setting up libcurl3t64-gnutls:armhf (8.17.0-1ubuntu1) ... 722s Setting up libfwupd3:armhf (2.0.17-6) ... 722s Setting up libcap2-bin (1:2.75-10ubuntu1) ... 722s Setting up curl (8.17.0-1ubuntu1) ... 722s Setting up libpam-cap:armhf (1:2.75-10ubuntu1) ... 722s Setting up fwupd (2.0.17-6) ... 723s fwupd-refresh.service is a disabled or a static unit not running, not starting it. 723s fwupd.service is a disabled or a static unit not running, not starting it. 723s Setting up cron-daemon-common (3.0pl1-200ubuntu1) ... 723s Setting up cron (3.0pl1-200ubuntu1) ... 724s Processing triggers for dbus (1.16.2-2ubuntu2) ... 724s Processing triggers for libc-bin (2.42-2ubuntu2) ... 724s Processing triggers for man-db (2.13.1-1) ... 727s Reading package lists... 727s Building dependency tree... 727s Reading state information... 727s Solving dependencies... 728s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 730s autopkgtest [23:55:18]: rebooting testbed after setup commands that affected boot 793s Reading package lists... 793s Building dependency tree... 793s Reading state information... 794s Solving dependencies... 794s The following NEW packages will be installed: 794s build-essential cpp cpp-15 cpp-15-arm-linux-gnueabihf 794s cpp-arm-linux-gnueabihf g++ g++-15 g++-15-arm-linux-gnueabihf 794s g++-arm-linux-gnueabihf gcc gcc-15 gcc-15-arm-linux-gnueabihf 794s gcc-arm-linux-gnueabihf libasan8 libc-dev-bin libc6-dev libcc1-0 794s libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libgcc-15-dev libgomp1 794s libio-pty-perl libipc-run-perl libisl23 libjson-perl libmpc3 libpgtypes3 794s libpq-dev libpq-oauth libpq5 libpython3.13 libssl-dev libstdc++-15-dev 794s libtcl8.6 libubsan1 liburing2 libxslt1.1 linux-libc-dev postgresql-18 794s postgresql-client-18 postgresql-client-common postgresql-common 794s postgresql-common-dev postgresql-doc-18 postgresql-plperl-18 794s postgresql-plpython3-18 postgresql-pltcl-18 postgresql-server-dev-18 794s rpcsvc-proto ssl-cert tzdata-legacy 794s 0 upgraded, 53 newly installed, 0 to remove and 0 not upgraded. 794s Need to get 73.7 MB of archives. 794s After this operation, 252 MB of additional disk space will be used. 794s Get:1 http://ftpmaster.internal/ubuntu resolute/main armhf libjson-perl all 4.10000-1 [81.9 kB] 795s Get:2 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-client-common all 282ubuntu1 [48.8 kB] 795s Get:3 http://ftpmaster.internal/ubuntu resolute/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 795s Get:4 http://ftpmaster.internal/ubuntu resolute/main armhf libipc-run-perl all 20250809.0-1 [94.4 kB] 795s Get:5 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-common-dev all 282ubuntu1 [73.9 kB] 795s Get:6 http://ftpmaster.internal/ubuntu resolute/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 795s Get:7 http://ftpmaster.internal/ubuntu resolute/main armhf postgresql-common all 282ubuntu1 [101 kB] 795s Get:8 http://ftpmaster.internal/ubuntu resolute/main armhf libc-dev-bin armhf 2.42-2ubuntu2 [21.8 kB] 795s Get:9 http://ftpmaster.internal/ubuntu resolute/main armhf linux-libc-dev armhf 6.17.0-5.5 [1771 kB] 795s Get:10 http://ftpmaster.internal/ubuntu resolute/main armhf libcrypt-dev armhf 1:4.4.38-1build1 [120 kB] 795s Get:11 http://ftpmaster.internal/ubuntu resolute/main armhf rpcsvc-proto armhf 1.4.3-1 [62.3 kB] 795s Get:12 http://ftpmaster.internal/ubuntu resolute/main armhf libc6-dev armhf 2.42-2ubuntu2 [1416 kB] 795s Get:13 http://ftpmaster.internal/ubuntu resolute/main armhf libisl23 armhf 0.27-1 [546 kB] 795s Get:14 http://ftpmaster.internal/ubuntu resolute/main armhf libmpc3 armhf 1.3.1-2 [47.0 kB] 795s Get:15 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [10.1 MB] 795s Get:16 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-15 armhf 15.2.0-7ubuntu1 [1030 B] 795s Get:17 http://ftpmaster.internal/ubuntu resolute/main armhf cpp-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [5756 B] 795s Get:18 http://ftpmaster.internal/ubuntu resolute/main armhf cpp armhf 4:15.2.0-4ubuntu1 [22.4 kB] 795s Get:19 http://ftpmaster.internal/ubuntu resolute/main armhf libcc1-0 armhf 15.2.0-7ubuntu1 [43.5 kB] 795s Get:20 http://ftpmaster.internal/ubuntu resolute/main armhf libgomp1 armhf 15.2.0-7ubuntu1 [129 kB] 795s Get:21 http://ftpmaster.internal/ubuntu resolute/main armhf libasan8 armhf 15.2.0-7ubuntu1 [2950 kB] 795s Get:22 http://ftpmaster.internal/ubuntu resolute/main armhf libubsan1 armhf 15.2.0-7ubuntu1 [1187 kB] 795s Get:23 http://ftpmaster.internal/ubuntu resolute/main armhf libgcc-15-dev armhf 15.2.0-7ubuntu1 [898 kB] 796s Get:24 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [19.5 MB] 796s Get:25 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-15 armhf 15.2.0-7ubuntu1 [493 kB] 796s Get:26 http://ftpmaster.internal/ubuntu resolute/main armhf gcc-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [1220 B] 796s Get:27 http://ftpmaster.internal/ubuntu resolute/main armhf gcc armhf 4:15.2.0-4ubuntu1 [5022 B] 796s Get:28 http://ftpmaster.internal/ubuntu resolute/main armhf libstdc++-15-dev armhf 15.2.0-7ubuntu1 [2637 kB] 796s Get:29 http://ftpmaster.internal/ubuntu resolute/main armhf g++-15-arm-linux-gnueabihf armhf 15.2.0-7ubuntu1 [11.4 MB] 796s Get:30 http://ftpmaster.internal/ubuntu resolute/main armhf g++-15 armhf 15.2.0-7ubuntu1 [23.7 kB] 796s Get:31 http://ftpmaster.internal/ubuntu resolute/main armhf g++-arm-linux-gnueabihf armhf 4:15.2.0-4ubuntu1 [968 B] 796s Get:32 http://ftpmaster.internal/ubuntu resolute/main armhf g++ armhf 4:15.2.0-4ubuntu1 [1086 B] 796s Get:33 http://ftpmaster.internal/ubuntu resolute/main armhf build-essential armhf 12.12ubuntu1 [5088 B] 796s Get:34 http://ftpmaster.internal/ubuntu resolute/main armhf libpgtypes3 armhf 18.0-1 [39.0 kB] 796s Get:35 http://ftpmaster.internal/ubuntu resolute/main armhf libpq5 armhf 18.0-1 [261 kB] 796s Get:36 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg6 armhf 18.0-1 [53.5 kB] 796s Get:37 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg-compat3 armhf 18.0-1 [10.8 kB] 796s Get:38 http://ftpmaster.internal/ubuntu resolute/main armhf libssl-dev armhf 3.5.3-1ubuntu2 [2550 kB] 796s Get:39 http://ftpmaster.internal/ubuntu resolute/main armhf libpq-dev armhf 18.0-1 [163 kB] 797s Get:40 http://ftpmaster.internal/ubuntu resolute/main armhf libecpg-dev armhf 18.0-1 [268 kB] 797s Get:41 http://ftpmaster.internal/ubuntu resolute/universe armhf libpq-oauth armhf 18.0-1 [31.5 kB] 797s Get:42 http://ftpmaster.internal/ubuntu resolute/main armhf libpython3.13 armhf 3.13.9-1 [2123 kB] 797s Get:43 http://ftpmaster.internal/ubuntu resolute/main armhf libtcl8.6 armhf 8.6.17+dfsg-1 [918 kB] 797s Get:44 http://ftpmaster.internal/ubuntu resolute/main armhf liburing2 armhf 2.11-1 [22.1 kB] 797s Get:45 http://ftpmaster.internal/ubuntu resolute/main armhf libxslt1.1 armhf 1.1.43-0.3 [146 kB] 797s Get:46 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-client-18 armhf 18.0-1 [2159 kB] 797s Get:47 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-18 armhf 18.0-1 [7268 kB] 797s Get:48 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-doc-18 all 18.0-1 [2176 kB] 797s Get:49 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-plperl-18 armhf 18.0-1 [67.5 kB] 797s Get:50 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-plpython3-18 armhf 18.0-1 [92.2 kB] 797s Get:51 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-pltcl-18 armhf 18.0-1 [39.3 kB] 797s Get:52 http://ftpmaster.internal/ubuntu resolute/universe armhf postgresql-server-dev-18 armhf 18.0-1 [1430 kB] 797s Get:53 http://ftpmaster.internal/ubuntu resolute/main armhf tzdata-legacy all 2025b-5ubuntu1 [99.3 kB] 797s Preconfiguring packages ... 797s Fetched 73.7 MB in 3s (25.7 MB/s) 797s Selecting previously unselected package libjson-perl. 798s (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 ... 65903 files and directories currently installed.) 798s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 798s Unpacking libjson-perl (4.10000-1) ... 798s Selecting previously unselected package postgresql-client-common. 798s Preparing to unpack .../01-postgresql-client-common_282ubuntu1_all.deb ... 798s Unpacking postgresql-client-common (282ubuntu1) ... 798s Selecting previously unselected package libio-pty-perl. 798s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 798s Unpacking libio-pty-perl (1:1.20-1build3) ... 798s Selecting previously unselected package libipc-run-perl. 798s Preparing to unpack .../03-libipc-run-perl_20250809.0-1_all.deb ... 798s Unpacking libipc-run-perl (20250809.0-1) ... 798s Selecting previously unselected package postgresql-common-dev. 798s Preparing to unpack .../04-postgresql-common-dev_282ubuntu1_all.deb ... 798s Unpacking postgresql-common-dev (282ubuntu1) ... 798s Selecting previously unselected package ssl-cert. 798s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 798s Unpacking ssl-cert (1.1.3ubuntu1) ... 798s Selecting previously unselected package postgresql-common. 798s Preparing to unpack .../06-postgresql-common_282ubuntu1_all.deb ... 798s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 798s Unpacking postgresql-common (282ubuntu1) ... 798s Selecting previously unselected package libc-dev-bin. 798s Preparing to unpack .../07-libc-dev-bin_2.42-2ubuntu2_armhf.deb ... 798s Unpacking libc-dev-bin (2.42-2ubuntu2) ... 798s Selecting previously unselected package linux-libc-dev:armhf. 798s Preparing to unpack .../08-linux-libc-dev_6.17.0-5.5_armhf.deb ... 798s Unpacking linux-libc-dev:armhf (6.17.0-5.5) ... 798s Selecting previously unselected package libcrypt-dev:armhf. 798s Preparing to unpack .../09-libcrypt-dev_1%3a4.4.38-1build1_armhf.deb ... 798s Unpacking libcrypt-dev:armhf (1:4.4.38-1build1) ... 798s Selecting previously unselected package rpcsvc-proto. 798s Preparing to unpack .../10-rpcsvc-proto_1.4.3-1_armhf.deb ... 798s Unpacking rpcsvc-proto (1.4.3-1) ... 798s Selecting previously unselected package libc6-dev:armhf. 798s Preparing to unpack .../11-libc6-dev_2.42-2ubuntu2_armhf.deb ... 798s Unpacking libc6-dev:armhf (2.42-2ubuntu2) ... 798s Selecting previously unselected package libisl23:armhf. 798s Preparing to unpack .../12-libisl23_0.27-1_armhf.deb ... 798s Unpacking libisl23:armhf (0.27-1) ... 798s Selecting previously unselected package libmpc3:armhf. 798s Preparing to unpack .../13-libmpc3_1.3.1-2_armhf.deb ... 798s Unpacking libmpc3:armhf (1.3.1-2) ... 798s Selecting previously unselected package cpp-15-arm-linux-gnueabihf. 798s Preparing to unpack .../14-cpp-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 798s Unpacking cpp-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 798s Selecting previously unselected package cpp-15. 798s Preparing to unpack .../15-cpp-15_15.2.0-7ubuntu1_armhf.deb ... 798s Unpacking cpp-15 (15.2.0-7ubuntu1) ... 798s Selecting previously unselected package cpp-arm-linux-gnueabihf. 798s Preparing to unpack .../16-cpp-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 798s Unpacking cpp-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 798s Selecting previously unselected package cpp. 798s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_armhf.deb ... 798s Unpacking cpp (4:15.2.0-4ubuntu1) ... 798s Selecting previously unselected package libcc1-0:armhf. 798s Preparing to unpack .../18-libcc1-0_15.2.0-7ubuntu1_armhf.deb ... 798s Unpacking libcc1-0:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package libgomp1:armhf. 799s Preparing to unpack .../19-libgomp1_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking libgomp1:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package libasan8:armhf. 799s Preparing to unpack .../20-libasan8_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking libasan8:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package libubsan1:armhf. 799s Preparing to unpack .../21-libubsan1_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking libubsan1:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package libgcc-15-dev:armhf. 799s Preparing to unpack .../22-libgcc-15-dev_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking libgcc-15-dev:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package gcc-15-arm-linux-gnueabihf. 799s Preparing to unpack .../23-gcc-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking gcc-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package gcc-15. 799s Preparing to unpack .../24-gcc-15_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking gcc-15 (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package gcc-arm-linux-gnueabihf. 799s Preparing to unpack .../25-gcc-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 799s Unpacking gcc-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 799s Selecting previously unselected package gcc. 799s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_armhf.deb ... 799s Unpacking gcc (4:15.2.0-4ubuntu1) ... 799s Selecting previously unselected package libstdc++-15-dev:armhf. 799s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking libstdc++-15-dev:armhf (15.2.0-7ubuntu1) ... 799s Selecting previously unselected package g++-15-arm-linux-gnueabihf. 799s Preparing to unpack .../28-g++-15-arm-linux-gnueabihf_15.2.0-7ubuntu1_armhf.deb ... 799s Unpacking g++-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 800s Selecting previously unselected package g++-15. 800s Preparing to unpack .../29-g++-15_15.2.0-7ubuntu1_armhf.deb ... 800s Unpacking g++-15 (15.2.0-7ubuntu1) ... 800s Selecting previously unselected package g++-arm-linux-gnueabihf. 800s Preparing to unpack .../30-g++-arm-linux-gnueabihf_4%3a15.2.0-4ubuntu1_armhf.deb ... 800s Unpacking g++-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 800s Selecting previously unselected package g++. 800s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_armhf.deb ... 800s Unpacking g++ (4:15.2.0-4ubuntu1) ... 800s Selecting previously unselected package build-essential. 800s Preparing to unpack .../32-build-essential_12.12ubuntu1_armhf.deb ... 800s Unpacking build-essential (12.12ubuntu1) ... 800s Selecting previously unselected package libpgtypes3:armhf. 800s Preparing to unpack .../33-libpgtypes3_18.0-1_armhf.deb ... 800s Unpacking libpgtypes3:armhf (18.0-1) ... 800s Selecting previously unselected package libpq5:armhf. 800s Preparing to unpack .../34-libpq5_18.0-1_armhf.deb ... 800s Unpacking libpq5:armhf (18.0-1) ... 800s Selecting previously unselected package libecpg6:armhf. 800s Preparing to unpack .../35-libecpg6_18.0-1_armhf.deb ... 800s Unpacking libecpg6:armhf (18.0-1) ... 800s Selecting previously unselected package libecpg-compat3:armhf. 800s Preparing to unpack .../36-libecpg-compat3_18.0-1_armhf.deb ... 800s Unpacking libecpg-compat3:armhf (18.0-1) ... 800s Selecting previously unselected package libssl-dev:armhf. 800s Preparing to unpack .../37-libssl-dev_3.5.3-1ubuntu2_armhf.deb ... 800s Unpacking libssl-dev:armhf (3.5.3-1ubuntu2) ... 800s Selecting previously unselected package libpq-dev. 800s Preparing to unpack .../38-libpq-dev_18.0-1_armhf.deb ... 800s Unpacking libpq-dev (18.0-1) ... 800s Selecting previously unselected package libecpg-dev. 800s Preparing to unpack .../39-libecpg-dev_18.0-1_armhf.deb ... 800s Unpacking libecpg-dev (18.0-1) ... 800s Selecting previously unselected package libpq-oauth:armhf. 800s Preparing to unpack .../40-libpq-oauth_18.0-1_armhf.deb ... 800s Unpacking libpq-oauth:armhf (18.0-1) ... 800s Selecting previously unselected package libpython3.13:armhf. 800s Preparing to unpack .../41-libpython3.13_3.13.9-1_armhf.deb ... 800s Unpacking libpython3.13:armhf (3.13.9-1) ... 800s Selecting previously unselected package libtcl8.6:armhf. 800s Preparing to unpack .../42-libtcl8.6_8.6.17+dfsg-1_armhf.deb ... 800s Unpacking libtcl8.6:armhf (8.6.17+dfsg-1) ... 800s Selecting previously unselected package liburing2:armhf. 800s Preparing to unpack .../43-liburing2_2.11-1_armhf.deb ... 800s Unpacking liburing2:armhf (2.11-1) ... 800s Selecting previously unselected package libxslt1.1:armhf. 800s Preparing to unpack .../44-libxslt1.1_1.1.43-0.3_armhf.deb ... 800s Unpacking libxslt1.1:armhf (1.1.43-0.3) ... 800s Selecting previously unselected package postgresql-client-18. 800s Preparing to unpack .../45-postgresql-client-18_18.0-1_armhf.deb ... 800s Unpacking postgresql-client-18 (18.0-1) ... 800s Selecting previously unselected package postgresql-18. 800s Preparing to unpack .../46-postgresql-18_18.0-1_armhf.deb ... 800s Unpacking postgresql-18 (18.0-1) ... 801s Selecting previously unselected package postgresql-doc-18. 801s Preparing to unpack .../47-postgresql-doc-18_18.0-1_all.deb ... 801s Unpacking postgresql-doc-18 (18.0-1) ... 801s Selecting previously unselected package postgresql-plperl-18. 801s Preparing to unpack .../48-postgresql-plperl-18_18.0-1_armhf.deb ... 801s Unpacking postgresql-plperl-18 (18.0-1) ... 801s Selecting previously unselected package postgresql-plpython3-18. 801s Preparing to unpack .../49-postgresql-plpython3-18_18.0-1_armhf.deb ... 801s Unpacking postgresql-plpython3-18 (18.0-1) ... 801s Selecting previously unselected package postgresql-pltcl-18. 801s Preparing to unpack .../50-postgresql-pltcl-18_18.0-1_armhf.deb ... 801s Unpacking postgresql-pltcl-18 (18.0-1) ... 801s Selecting previously unselected package postgresql-server-dev-18. 801s Preparing to unpack .../51-postgresql-server-dev-18_18.0-1_armhf.deb ... 801s Unpacking postgresql-server-dev-18 (18.0-1) ... 801s Selecting previously unselected package tzdata-legacy. 801s Preparing to unpack .../52-tzdata-legacy_2025b-5ubuntu1_all.deb ... 801s Unpacking tzdata-legacy (2025b-5ubuntu1) ... 801s Setting up libpython3.13:armhf (3.13.9-1) ... 801s Setting up postgresql-client-common (282ubuntu1) ... 801s Setting up libpgtypes3:armhf (18.0-1) ... 801s Setting up postgresql-doc-18 (18.0-1) ... 801s 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 802s Setting up libio-pty-perl (1:1.20-1build3) ... 802s Setting up libpq5:armhf (18.0-1) ... 802s Setting up linux-libc-dev:armhf (6.17.0-5.5) ... 802s Setting up libgomp1:armhf (15.2.0-7ubuntu1) ... 802s Setting up tzdata-legacy (2025b-5ubuntu1) ... 802s Setting up rpcsvc-proto (1.4.3-1) ... 802s Setting up ssl-cert (1.1.3ubuntu1) ... 802s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 802s Setting up libssl-dev:armhf (3.5.3-1ubuntu2) ... 802s Setting up libmpc3:armhf (1.3.1-2) ... 802s Setting up libtcl8.6:armhf (8.6.17+dfsg-1) ... 802s Setting up libipc-run-perl (20250809.0-1) ... 802s Setting up libubsan1:armhf (15.2.0-7ubuntu1) ... 802s Setting up libcrypt-dev:armhf (1:4.4.38-1build1) ... 802s Setting up libasan8:armhf (15.2.0-7ubuntu1) ... 802s Setting up libjson-perl (4.10000-1) ... 802s Setting up libxslt1.1:armhf (1.1.43-0.3) ... 802s Setting up libecpg6:armhf (18.0-1) ... 802s Setting up liburing2:armhf (2.11-1) ... 802s Setting up libisl23:armhf (0.27-1) ... 802s Setting up libc-dev-bin (2.42-2ubuntu2) ... 802s Setting up cpp-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 802s Setting up libcc1-0:armhf (15.2.0-7ubuntu1) ... 802s Setting up cpp-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 802s Setting up postgresql-common-dev (282ubuntu1) ... 802s Setting up libgcc-15-dev:armhf (15.2.0-7ubuntu1) ... 802s Setting up libecpg-compat3:armhf (18.0-1) ... 802s Setting up gcc-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 802s Setting up postgresql-client-18 (18.0-1) ... 803s 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 803s Setting up libpq-oauth:armhf (18.0-1) ... 803s Setting up libpq-dev (18.0-1) ... 803s Setting up libecpg-dev (18.0-1) ... 803s Setting up postgresql-common (282ubuntu1) ... 803s Creating config file /etc/postgresql-common/createcluster.conf with new version 804s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 804s Removing obsolete dictionary files: 804s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 805s Setting up cpp-15 (15.2.0-7ubuntu1) ... 805s Setting up cpp (4:15.2.0-4ubuntu1) ... 805s Setting up libc6-dev:armhf (2.42-2ubuntu2) ... 805s Setting up gcc-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 805s Setting up postgresql-18 (18.0-1) ... 806s Creating new PostgreSQL cluster 18/main ... 806s /usr/lib/postgresql/18/bin/initdb -D /var/lib/postgresql/18/main --auth-local peer --auth-host scram-sha-256 --no-instructions 806s The files belonging to this database system will be owned by user "postgres". 806s This user must also own the server process. 806s 806s The database cluster will be initialized with locale "C.UTF-8". 806s The default database encoding has accordingly been set to "UTF8". 806s The default text search configuration will be set to "english". 806s 806s Data page checksums are enabled. 806s 806s fixing permissions on existing directory /var/lib/postgresql/18/main ... ok 806s creating subdirectories ... ok 806s selecting dynamic shared memory implementation ... posix 806s selecting default "max_connections" ... 100 806s selecting default "shared_buffers" ... 128MB 806s selecting default time zone ... Etc/UTC 806s creating configuration files ... ok 806s running bootstrap script ... ok 806s performing post-bootstrap initialization ... ok 806s syncing data to disk ... ok 809s Setting up postgresql-server-dev-18 (18.0-1) ... 809s Setting up gcc-15 (15.2.0-7ubuntu1) ... 809s Setting up libstdc++-15-dev:armhf (15.2.0-7ubuntu1) ... 809s Setting up postgresql-plpython3-18 (18.0-1) ... 809s Setting up postgresql-plperl-18 (18.0-1) ... 809s Setting up postgresql-pltcl-18 (18.0-1) ... 809s Setting up g++-15-arm-linux-gnueabihf (15.2.0-7ubuntu1) ... 809s Setting up gcc (4:15.2.0-4ubuntu1) ... 809s Setting up g++-15 (15.2.0-7ubuntu1) ... 809s Setting up g++-arm-linux-gnueabihf (4:15.2.0-4ubuntu1) ... 809s Setting up g++ (4:15.2.0-4ubuntu1) ... 809s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 809s Setting up build-essential (12.12ubuntu1) ... 809s Processing triggers for man-db (2.13.1-1) ... 810s Processing triggers for libc-bin (2.42-2ubuntu2) ... 857s autopkgtest [23:57:25]: test installcheck: [----------------------- 858s + dpkg-parsechangelog -SSource 859s + SOURCE=postgresql-18 859s + MAJOR=18 859s + top_srcdir=/tmp/autopkgtest.MTCUaK/build.WcL/src 859s + cd src/test/regress 859s + make -f /tmp/autopkgtest.MTCUaK/build.WcL/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/18/bin/pg_config with_llvm=no 859s 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 -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -DSTAP_SDT_ARG_CONSTRAINT=g -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.MTCUaK/build.WcL/src/debian/tests/ -I/usr/include/postgresql/18/server -I/usr/include/postgresql/internal -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_TIME_BITS=64 -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 859s 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 -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -DSTAP_SDT_ARG_CONSTRAINT=g -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/arm-linux-gnueabihf -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -fvisibility=hidden 859s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.MTCUaK/build.WcL/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 860s + id -u 860s + [ 1000 = 0 ] 860s + SU=sh 860s + sh 860s + mktemp -d /tmp/regress.XXXXXX 860s + OUTPUT=/tmp/regress.N9yCAH 860s + trap rm -rf /tmp/regress.N9yCAH EXIT 860s + pg_virtualenv -v 18 /usr/lib/postgresql/18/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.N9yCAH --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 860s Creating new PostgreSQL cluster 18/regress ... 863s # using postmaster on localhost, port 5433 863s ok 1 - test_setup 223 ms 863s # parallel group (20 tests): varchar oid char txid name pg_lsn int2 float4 int4 text boolean int8 regproc bit enum money float8 uuid numeric rangetypes 863s ok 2 + boolean 112 ms 863s ok 3 + char 72 ms 863s ok 4 + name 77 ms 863s ok 5 + varchar 61 ms 863s ok 6 + text 101 ms 863s ok 7 + int2 90 ms 863s ok 8 + int4 96 ms 863s ok 9 + int8 113 ms 863s ok 10 + oid 59 ms 863s ok 11 + float4 91 ms 863s ok 12 + float8 121 ms 863s ok 13 + bit 113 ms 863s ok 14 + numeric 371 ms 863s ok 15 + txid 68 ms 863s ok 16 + uuid 122 ms 863s ok 17 + enum 113 ms 863s ok 18 + money 115 ms 863s ok 19 + rangetypes 384 ms 863s ok 20 + pg_lsn 77 ms 863s ok 21 + regproc 111 ms 864s # parallel group (20 tests): md5 lseg timetz path time line circle macaddr numerology point macaddr8 inet date interval strings polygon box multirangetypes timestamp timestamptz 864s ok 22 + strings 183 ms 864s ok 23 + md5 32 ms 864s ok 24 + numerology 84 ms 864s ok 25 + point 88 ms 864s ok 26 + lseg 52 ms 864s ok 27 + line 67 ms 864s ok 28 + box 220 ms 864s ok 29 + path 65 ms 864s ok 30 + polygon 191 ms 864s ok 31 + circle 68 ms 864s ok 32 + date 130 ms 864s ok 33 + time 63 ms 864s ok 34 + timetz 61 ms 864s ok 35 + timestamp 379 ms 864s ok 36 + timestamptz 430 ms 864s ok 37 + interval 160 ms 864s ok 38 + inet 103 ms 864s ok 39 + macaddr 73 ms 864s ok 40 + macaddr8 91 ms 864s ok 41 + multirangetypes 270 ms 864s # parallel group (14 tests): comments unicode misc_sanity tstypes expressions mvcc xid type_sanity geometry horology stats_import database opr_sanity regex 864s ok 42 + geometry 125 ms 864s ok 43 + horology 155 ms 864s ok 44 + tstypes 68 ms 864s ok 45 + regex 286 ms 864s ok 46 + type_sanity 108 ms 864s ok 47 + opr_sanity 282 ms 864s ok 48 + misc_sanity 49 ms 864s ok 49 + comments 34 ms 864s ok 50 + expressions 87 ms 864s ok 51 + unicode 35 ms 864s ok 52 + xid 100 ms 864s ok 53 + mvcc 89 ms 864s ok 54 + database 237 ms 864s ok 55 + stats_import 165 ms 865s # parallel group (6 tests): copyencoding copyselect copydml copy insert_conflict insert 865s ok 56 + copy 122 ms 865s ok 57 + copyselect 49 ms 865s ok 58 + copydml 51 ms 865s ok 59 + copyencoding 31 ms 865s ok 60 + insert 350 ms 865s ok 61 + insert_conflict 177 ms 865s # parallel group (7 tests): create_function_c create_operator create_type create_misc create_procedure create_schema create_table 865s ok 62 + create_function_c 23 ms 865s ok 63 + create_misc 59 ms 865s ok 64 + create_operator 35 ms 865s ok 65 + create_procedure 74 ms 865s ok 66 + create_table 394 ms 865s ok 67 + create_type 56 ms 865s ok 68 + create_schema 100 ms 866s # parallel group (5 tests): index_including_gist index_including create_view create_index_spgist create_index 866s ok 69 + create_index 751 ms 866s ok 70 + create_index_spgist 393 ms 866s ok 71 + create_view 309 ms 866s ok 72 + index_including 221 ms 866s ok 73 + index_including_gist 219 ms 868s # parallel group (16 tests): create_cast create_aggregate roleattributes hash_func select errors typed_table drop_if_exists create_am create_function_sql vacuum infinite_recurse updatable_views constraints inherit triggers 868s ok 74 + create_aggregate 69 ms 868s ok 75 + create_function_sql 237 ms 868s ok 76 + create_cast 32 ms 868s ok 77 + constraints 684 ms 868s ok 78 + triggers 1819 ms 868s ok 79 + select 100 ms 868s ok 80 + inherit 1040 ms 868s ok 81 + typed_table 136 ms 868s ok 82 + vacuum 425 ms 868s ok 83 + drop_if_exists 143 ms 868s ok 84 + updatable_views 662 ms 868s ok 85 + roleattributes 88 ms 868s ok 86 + create_am 177 ms 868s ok 87 + hash_func 82 ms 868s ok 88 + errors 97 ms 868s ok 89 + infinite_recurse 439 ms 868s ok 90 - sanity_check 213 ms 869s # parallel group (20 tests): select_distinct_on select_having delete select_implicit random namespace case select_into prepared_xacts select_distinct union portals transactions subselect arrays update hash_index join aggregates btree_index 869s ok 91 + select_into 184 ms 869s ok 92 + select_distinct 206 ms 869s ok 93 + select_distinct_on 59 ms 869s ok 94 + select_implicit 101 ms 869s ok 95 + select_having 86 ms 869s ok 96 + subselect 328 ms 869s ok 97 + union 221 ms 869s ok 98 + case 147 ms 869s ok 99 + join 707 ms 869s ok 100 + aggregates 953 ms 869s ok 101 + transactions 261 ms 869s ok 102 + random 100 ms 869s ok 103 + portals 245 ms 869s ok 104 + arrays 377 ms 869s ok 105 + btree_index 1215 ms 869s ok 106 + hash_index 614 ms 869s ok 107 + update 439 ms 869s ok 108 + delete 80 ms 869s ok 109 + namespace 118 ms 869s ok 110 + prepared_xacts 191 ms 872s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password replica_identity collate groupingsets identity matview spgist gin generated_stored gist rowsecurity join_hash brin privileges 872s ok 111 + brin 1942 ms 872s ok 112 + gin 870 ms 872s ok 113 + gist 922 ms 872s ok 114 + spgist 749 ms 872s ok 115 + privileges 2450 ms 872s ok 116 + init_privs 40 ms 872s ok 117 + security_label 107 ms 872s ok 118 + collate 338 ms 872s ok 119 + matview 651 ms 872s ok 120 + lock 226 ms 872s ok 121 + replica_identity 321 ms 872s ok 122 + rowsecurity 924 ms 872s ok 123 + object_address 246 ms 872s ok 124 + tablesample 159 ms 872s ok 125 + groupingsets 481 ms 872s ok 126 + drop_operator 59 ms 872s ok 127 + password 249 ms 872s ok 128 + identity 634 ms 872s ok 129 + generated_stored 884 ms 872s ok 130 + join_hash 1916 ms 872s # parallel group (2 tests): brin_bloom brin_multi 872s ok 131 + brin_bloom 100 ms 872s ok 132 + brin_multi 418 ms 873s # parallel group (19 tests): async tsrf dbsize collate.utf8 alter_operator tidrangescan tidscan tid misc create_role sysviews incremental_sort misc_functions alter_generic create_table_like collate.icu.utf8 generated_virtual merge without_overlaps 873s ok 133 + create_table_like 404 ms 873s ok 134 + alter_generic 293 ms 873s ok 135 + alter_operator 112 ms 873s ok 136 + misc 187 ms 873s ok 137 + async 65 ms 873s ok 138 + dbsize 87 ms 873s ok 139 + merge 659 ms 873s ok 140 + misc_functions 288 ms 873s ok 141 + sysviews 234 ms 873s ok 142 + tsrf 66 ms 873s ok 143 + tid 126 ms 873s ok 144 + tidscan 114 ms 873s ok 145 + tidrangescan 111 ms 873s ok 146 + collate.utf8 100 ms 873s ok 147 + collate.icu.utf8 460 ms 873s ok 148 + incremental_sort 243 ms 873s ok 149 + create_role 197 ms 873s ok 150 + without_overlaps 784 ms 873s ok 151 + generated_virtual 577 ms 874s # parallel group (8 tests): amutils collate.windows.win1252 collate.linux.utf8 psql_crosstab psql_pipeline rules psql stats_ext 874s ok 152 + rules 361 ms 874s ok 153 + psql 498 ms 874s ok 154 + psql_crosstab 55 ms 874s ok 155 + psql_pipeline 83 ms 874s ok 156 + amutils 28 ms 874s ok 157 + stats_ext 1583 ms 874s ok 158 + collate.linux.utf8 33 ms 874s ok 159 + collate.windows.win1252 30 ms 876s ok 160 - select_parallel 1285 ms 876s ok 161 - write_parallel 150 ms 876s ok 162 - vacuum_parallel 125 ms 876s ok 163 - maintain_every 34 ms 877s # parallel group (2 tests): subscription publication 877s ok 164 + publication 493 ms 877s ok 165 + subscription 70 ms 878s # parallel group (17 tests): combocid advisory_lock portals_p2 functional_deps xmlmap tsdicts guc dependency select_views equivclass bitmapops window tsearch indirect_toast cluster foreign_data foreign_key 878s ok 166 + select_views 244 ms 878s ok 167 + portals_p2 107 ms 878s ok 168 + foreign_key 1537 ms 878s ok 169 + cluster 636 ms 878s ok 170 + dependency 237 ms 878s ok 171 + guc 221 ms 878s ok 172 + bitmapops 370 ms 878s ok 173 + combocid 48 ms 878s ok 174 + tsearch 389 ms 878s ok 175 + tsdicts 181 ms 878s ok 176 + foreign_data 703 ms 878s ok 177 + window 371 ms 878s ok 178 + xmlmap 138 ms 878s ok 179 + functional_deps 121 ms 878s ok 180 + advisory_lock 85 ms 878s ok 181 + indirect_toast 383 ms 878s ok 182 + equivclass 226 ms 878s # parallel group (9 tests): jsonpath_encoding json_encoding sqljson_jsontable sqljson jsonpath sqljson_queryfuncs jsonb_jsonpath json jsonb 878s ok 183 + json 267 ms 878s ok 184 + jsonb 299 ms 878s ok 185 + json_encoding 56 ms 878s ok 186 + jsonpath 129 ms 878s ok 187 + jsonpath_encoding 33 ms 878s ok 188 + jsonb_jsonpath 199 ms 878s ok 189 + sqljson 121 ms 878s ok 190 + sqljson_queryfuncs 181 ms 878s ok 191 + sqljson_jsontable 111 ms 880s # parallel group (18 tests): prepare plancache conversion limit largeobject returning rowtypes temp truncate polymorphism copy2 sequence domain with rangefuncs plpgsql xml alter_table 880s ok 192 + plancache 147 ms 880s ok 193 + limit 202 ms 880s ok 194 + plpgsql 841 ms 880s ok 195 + copy2 482 ms 880s ok 196 + temp 438 ms 880s ok 197 + domain 546 ms 880s ok 198 + rangefuncs 615 ms 880s ok 199 + prepare 93 ms 880s ok 200 + conversion 176 ms 880s ok 201 + truncate 443 ms 880s ok 202 + alter_table 1813 ms 880s ok 203 + sequence 502 ms 880s ok 204 + polymorphism 465 ms 880s ok 205 + rowtypes 395 ms 880s ok 206 + returning 334 ms 880s ok 207 + largeobject 318 ms 880s ok 208 + with 569 ms 880s ok 209 + xml 1279 ms 881s # parallel group (14 tests): hash_part reloptions predicate numa explain memoize partition_info compression partition_aggregate tuplesort partition_join stats partition_prune indexing 881s ok 210 + partition_join 903 ms 881s ok 211 + partition_prune 992 ms 881s ok 212 + reloptions 93 ms 881s ok 213 + hash_part 68 ms 881s ok 214 + indexing 1008 ms 881s ok 215 + partition_aggregate 613 ms 881s ok 216 + partition_info 197 ms 881s ok 217 + tuplesort 829 ms 881s ok 218 + explain 166 ms 881s ok 219 + compression 324 ms 881s ok 220 + memoize 182 ms 881s ok 221 + stats 954 ms 881s ok 222 + predicate 109 ms 881s ok 223 + numa 140 ms 882s # parallel group (2 tests): oidjoins event_trigger 882s ok 224 + oidjoins 227 ms 882s ok 225 + event_trigger 261 ms 882s ok 226 - event_trigger_login 64 ms 882s ok 227 - fast_default 190 ms 882s ok 228 - tablespace 448 ms 882s 1..228 882s # All 228 tests passed. 882s Dropping cluster 18/regress ... 883s + rm -rf /tmp/regress.N9yCAH 883s autopkgtest [23:57:51]: test installcheck: -----------------------] 887s installcheck PASS 887s autopkgtest [23:57:55]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 891s autopkgtest [23:57:59]: @@@@@@@@@@@@@@@@@@@@ summary 891s run-testsuite PASS 891s installcheck PASS