0s autopkgtest [12:27:57]: starting date and time: 2025-04-25 12:27:57+0000 0s autopkgtest [12:27:57]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [12:27:57]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.w5n7oipn/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-16 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025b-0ubuntu0.24.04.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-arm64-16.secgroup --name adt-noble-arm64-postgresql-16-20250425-122757-juju-7f2275-prod-proposed-migration-environment-20-4189470e-2940-4c79-aa47-2c44366beaf1 --image adt/ubuntu-noble-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 141s autopkgtest [12:30:18]: testbed dpkg architecture: arm64 141s autopkgtest [12:30:18]: testbed apt version: 2.7.14build2 141s autopkgtest [12:30:18]: @@@@@@@@@@@@@@@@@@@@ test bed setup 142s autopkgtest [12:30:19]: testbed release detected to be: None 142s autopkgtest [12:30:19]: updating testbed package index (apt update) 143s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 143s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 143s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 143s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 143s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6316 B] 143s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [15.8 kB] 143s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [49.2 kB] 143s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [62.8 kB] 143s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [193 kB] 143s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [2180 B] 143s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [341 kB] 143s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 143s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [419 kB] 143s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [5940 B] 143s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [16.5 kB] 143s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 147s Fetched 1377 kB in 1s (1370 kB/s) 148s Reading package lists... 149s autopkgtest [12:30:26]: upgrading testbed (apt dist-upgrade and autopurge) 149s Reading package lists... 149s Building dependency tree... 149s Reading state information... 150s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 150s Starting 2 pkgProblemResolver with broken count: 0 150s Done 150s Entering ResolveByKeep 151s 151s The following packages will be upgraded: 151s tzdata 151s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 151s Need to get 276 kB of archives. 151s After this operation, 0 B of additional disk space will be used. 151s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 tzdata all 2025b-0ubuntu0.24.04.1 [276 kB] 152s Preconfiguring packages ... 152s Fetched 276 kB in 0s (652 kB/s) 152s (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 ... 113204 files and directories currently installed.) 152s Preparing to unpack .../tzdata_2025b-0ubuntu0.24.04.1_all.deb ... 152s Unpacking tzdata (2025b-0ubuntu0.24.04.1) over (2025b-0ubuntu0.24.04) ... 152s Setting up tzdata (2025b-0ubuntu0.24.04.1) ... 153s 153s Current default time zone: 'Etc/UTC' 153s Local time is now: Fri Apr 25 12:30:29 UTC 2025. 153s Universal Time is now: Fri Apr 25 12:30:29 UTC 2025. 153s Run 'dpkg-reconfigure tzdata' if you wish to change it. 153s 153s Reading package lists... 153s Building dependency tree... 153s Reading state information... 154s Starting pkgProblemResolver with broken count: 0 154s Starting 2 pkgProblemResolver with broken count: 0 154s Done 155s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 157s autopkgtest [12:30:34]: testbed running kernel: Linux 6.8.0-58-generic #60-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 14 18:09:50 UTC 2025 157s autopkgtest [12:30:34]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-16 171s Get:1 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (dsc) [4329 B] 171s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (tar) [32.8 MB] 171s Get:3 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (diff) [35.2 kB] 171s gpgv: Signature made Fri Feb 28 19:08:43 2025 UTC 171s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 171s gpgv: Can't check signature: No public key 171s dpkg-source: warning: cannot verify inline signature for ./postgresql-16_16.8-0ubuntu0.24.04.1.dsc: no acceptable signature found 172s autopkgtest [12:30:49]: testing package postgresql-16 version 16.8-0ubuntu0.24.04.1 174s autopkgtest [12:30:51]: build not needed 185s autopkgtest [12:31:02]: test run-testsuite: preparing testbed 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 186s Starting pkgProblemResolver with broken count: 0 186s Starting 2 pkgProblemResolver with broken count: 0 186s Done 187s The following NEW packages will be installed: 187s autoconf automake autopoint autotools-dev build-essential clang-17 cpp 187s cpp-13 cpp-13-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 187s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 187s fakeroot g++ g++-13 g++-13-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 187s gcc-13 gcc-13-aarch64-linux-gnu gcc-13-base gcc-aarch64-linux-gnu gettext 187s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 187s libatomic1 libcc1-0 libclang-common-17-dev libclang-cpp17t64 libclang1-17t64 187s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 187s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 187s libhwasan0 libicu-dev libisl23 libitm1 libjson-perl libllvm17t64 liblsan0 187s libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 187s libpq5 libssl-dev libstdc++-13-dev libsub-override-perl libtcl8.6 libtool 187s libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev llvm-17 187s llvm-17-dev llvm-17-linker-tools llvm-17-runtime llvm-17-tools locales-all 187s m4 po-debconf postgresql-16 postgresql-client-16 postgresql-client-common 187s postgresql-common postgresql-doc-16 postgresql-plperl-16 187s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 187s ssl-cert 187s 0 upgraded, 92 newly installed, 0 to remove and 0 not upgraded. 187s Need to get 226 MB of archives. 187s After this operation, 1284 MB of additional disk space will be used. 187s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 187s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-client-common all 257build1.1 [36.4 kB] 187s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 187s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-common all 257build1.1 [161 kB] 187s Get:5 http://ftpmaster.internal/ubuntu noble/main arm64 m4 arm64 1.4.19-4build1 [240 kB] 187s Get:6 http://ftpmaster.internal/ubuntu noble/main arm64 autoconf all 2.71-3 [339 kB] 188s Get:7 http://ftpmaster.internal/ubuntu noble/main arm64 autotools-dev all 20220109.1 [44.9 kB] 188s Get:8 http://ftpmaster.internal/ubuntu noble/main arm64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 188s Get:9 http://ftpmaster.internal/ubuntu noble/main arm64 autopoint all 0.21-14ubuntu2 [422 kB] 188s Get:10 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13-base arm64 13.3.0-6ubuntu2~24.04 [51.5 kB] 188s Get:11 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libisl23 arm64 0.26-3build1.1 [669 kB] 188s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libmpc3 arm64 1.3.1-1build1.1 [56.4 kB] 188s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main arm64 cpp-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [9556 kB] 190s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main arm64 cpp-13 arm64 13.3.0-6ubuntu2~24.04 [1036 B] 190s Get:15 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [5316 B] 190s Get:16 http://ftpmaster.internal/ubuntu noble/main arm64 cpp arm64 4:13.2.0-7ubuntu1 [22.4 kB] 190s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libcc1-0 arm64 14.2.0-4ubuntu2~24.04 [49.7 kB] 190s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libgomp1 arm64 14.2.0-4ubuntu2~24.04 [145 kB] 190s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libitm1 arm64 14.2.0-4ubuntu2~24.04 [28.1 kB] 190s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libatomic1 arm64 14.2.0-4ubuntu2~24.04 [11.6 kB] 190s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libasan8 arm64 14.2.0-4ubuntu2~24.04 [2930 kB] 190s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main arm64 liblsan0 arm64 14.2.0-4ubuntu2~24.04 [1289 kB] 190s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libtsan2 arm64 14.2.0-4ubuntu2~24.04 [2696 kB] 191s Get:24 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libubsan1 arm64 14.2.0-4ubuntu2~24.04 [1157 kB] 191s Get:25 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libhwasan0 arm64 14.2.0-4ubuntu2~24.04 [1605 kB] 191s Get:26 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libgcc-13-dev arm64 13.3.0-6ubuntu2~24.04 [2473 kB] 191s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [18.7 MB] 192s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13 arm64 13.3.0-6ubuntu2~24.04 [484 kB] 192s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1198 B] 192s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 gcc arm64 4:13.2.0-7ubuntu1 [5018 B] 192s Get:31 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libstdc++-13-dev arm64 13.3.0-6ubuntu2~24.04 [2397 kB] 192s Get:32 http://ftpmaster.internal/ubuntu noble-updates/main arm64 g++-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [10.9 MB] 192s Get:33 http://ftpmaster.internal/ubuntu noble-updates/main arm64 g++-13 arm64 13.3.0-6ubuntu2~24.04 [16.0 kB] 192s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 g++-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [962 B] 192s Get:35 http://ftpmaster.internal/ubuntu noble/main arm64 g++ arm64 4:13.2.0-7ubuntu1 [1082 B] 192s Get:36 http://ftpmaster.internal/ubuntu noble/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 192s Get:37 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17t64 arm64 1:17.0.6-9ubuntu1 [25.0 MB] 193s Get:38 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang-cpp17t64 arm64 1:17.0.6-9ubuntu1 [12.7 MB] 193s Get:39 http://ftpmaster.internal/ubuntu noble/main arm64 libgc1 arm64 1:8.2.6-1build1 [89.1 kB] 193s Get:40 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 libobjc4 arm64 14.2.0-4ubuntu2~24.04 [45.3 kB] 193s Get:41 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 libobjc-13-dev arm64 13.3.0-6ubuntu2~24.04 [190 kB] 193s Get:42 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang-common-17-dev arm64 1:17.0.6-9ubuntu1 [690 kB] 193s Get:43 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-linker-tools arm64 1:17.0.6-9ubuntu1 [1227 kB] 193s Get:44 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang1-17t64 arm64 1:17.0.6-9ubuntu1 [7142 kB] 194s Get:45 http://ftpmaster.internal/ubuntu noble/universe arm64 clang-17 arm64 1:17.0.6-9ubuntu1 [77.4 kB] 194s Get:46 http://ftpmaster.internal/ubuntu noble/main arm64 libdebhelper-perl all 13.14.1ubuntu5 [89.8 kB] 194s Get:47 http://ftpmaster.internal/ubuntu noble/main arm64 libtool all 2.4.7-7build1 [166 kB] 194s Get:48 http://ftpmaster.internal/ubuntu noble/main arm64 dh-autoreconf all 20 [16.1 kB] 194s Get:49 http://ftpmaster.internal/ubuntu noble/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 194s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 libsub-override-perl all 0.10-1 [10.0 kB] 194s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 194s Get:52 http://ftpmaster.internal/ubuntu noble/main arm64 dh-strip-nondeterminism all 1.13.1-1 [5362 B] 194s Get:53 http://ftpmaster.internal/ubuntu noble/main arm64 debugedit arm64 1:5.0-5build2 [45.3 kB] 194s Get:54 http://ftpmaster.internal/ubuntu noble/main arm64 dwz arm64 0.15-1build6 [113 kB] 194s Get:55 http://ftpmaster.internal/ubuntu noble/main arm64 gettext arm64 0.21-14ubuntu2 [845 kB] 194s Get:56 http://ftpmaster.internal/ubuntu noble/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 194s Get:57 http://ftpmaster.internal/ubuntu noble/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 194s Get:58 http://ftpmaster.internal/ubuntu noble/main arm64 debhelper all 13.14.1ubuntu5 [869 kB] 194s Get:59 http://ftpmaster.internal/ubuntu noble/main arm64 emacsen-common all 3.0.5 [12.1 kB] 194s Get:60 http://ftpmaster.internal/ubuntu noble/main arm64 dictionaries-common all 1.29.7 [188 kB] 194s Get:61 http://ftpmaster.internal/ubuntu noble/main arm64 libfakeroot arm64 1.33-1 [32.5 kB] 194s Get:62 http://ftpmaster.internal/ubuntu noble/main arm64 fakeroot arm64 1.33-1 [66.9 kB] 194s Get:63 http://ftpmaster.internal/ubuntu noble/main arm64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 194s Get:64 http://ftpmaster.internal/ubuntu noble-updates/main arm64 icu-devtools arm64 74.2-1ubuntu3.1 [209 kB] 194s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpgtypes3 arm64 16.8-0ubuntu0.24.04.1 [44.7 kB] 194s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpq5 arm64 16.8-0ubuntu0.24.04.1 [140 kB] 194s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg6 arm64 16.8-0ubuntu0.24.04.1 [42.9 kB] 194s Get:68 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg-compat3 arm64 16.8-0ubuntu0.24.04.1 [12.1 kB] 194s Get:69 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libssl-dev arm64 3.0.13-0ubuntu3.5 [2337 kB] 194s Get:70 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpq-dev arm64 16.8-0ubuntu0.24.04.1 [153 kB] 194s Get:71 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg-dev arm64 16.8-0ubuntu0.24.04.1 [260 kB] 194s Get:72 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libicu-dev arm64 74.2-1ubuntu3.1 [11.9 MB] 194s Get:73 http://ftpmaster.internal/ubuntu noble/main arm64 libncurses-dev arm64 6.4+20240113-1ubuntu2 [385 kB] 194s Get:74 http://ftpmaster.internal/ubuntu noble/main arm64 libtcl8.6 arm64 8.6.14+dfsg-1build1 [978 kB] 194s Get:75 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libxml2-dev arm64 2.9.14+dfsg-1.3ubuntu3.2 [798 kB] 194s Get:76 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 194s Get:77 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-runtime arm64 1:17.0.6-9ubuntu1 [513 kB] 194s Get:78 http://ftpmaster.internal/ubuntu noble/universe arm64 libpfm4 arm64 4.13.0+git32-g0d4ed0e-1 [59.6 kB] 194s Get:79 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17 arm64 1:17.0.6-9ubuntu1 [22.9 MB] 195s Get:80 http://ftpmaster.internal/ubuntu noble/main arm64 libffi-dev arm64 3.4.6-1build1 [59.5 kB] 195s Get:81 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-tools arm64 1:17.0.6-9ubuntu1 [519 kB] 195s Get:82 http://ftpmaster.internal/ubuntu noble/universe arm64 libz3-4 arm64 4.8.12-3.1build1 [5492 kB] 195s Get:83 http://ftpmaster.internal/ubuntu noble/universe arm64 libz3-dev arm64 4.8.12-3.1build1 [72.2 kB] 195s Get:84 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-dev arm64 1:17.0.6-9ubuntu1 [40.3 MB] 197s Get:85 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 locales-all arm64 2.39-0ubuntu8.4 [10.9 MB] 197s Get:86 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-client-16 arm64 16.8-0ubuntu0.24.04.1 [1282 kB] 197s Get:87 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-16 arm64 16.8-0ubuntu0.24.04.1 [15.3 MB] 197s Get:88 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-doc-16 all 16.8-0ubuntu0.24.04.1 [2126 kB] 198s Get:89 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-plperl-16 arm64 16.8-0ubuntu0.24.04.1 [67.8 kB] 198s Get:90 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-plpython3-16 arm64 16.8-0ubuntu0.24.04.1 [75.1 kB] 198s Get:91 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-pltcl-16 arm64 16.8-0ubuntu0.24.04.1 [31.2 kB] 198s Get:92 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 postgresql-server-dev-16 arm64 16.8-0ubuntu0.24.04.1 [1228 kB] 198s Preconfiguring packages ... 198s Fetched 226 MB in 11s (20.7 MB/s) 198s Selecting previously unselected package libjson-perl. 199s (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 ... 113204 files and directories currently installed.) 199s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 199s Unpacking libjson-perl (4.10000-1) ... 199s Selecting previously unselected package postgresql-client-common. 199s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 199s Unpacking postgresql-client-common (257build1.1) ... 199s Selecting previously unselected package ssl-cert. 199s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 199s Unpacking ssl-cert (1.1.2ubuntu1) ... 199s Selecting previously unselected package postgresql-common. 199s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 199s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 199s Unpacking postgresql-common (257build1.1) ... 199s Selecting previously unselected package m4. 199s Preparing to unpack .../04-m4_1.4.19-4build1_arm64.deb ... 199s Unpacking m4 (1.4.19-4build1) ... 199s Selecting previously unselected package autoconf. 199s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 199s Unpacking autoconf (2.71-3) ... 199s Selecting previously unselected package autotools-dev. 199s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 199s Unpacking autotools-dev (20220109.1) ... 199s Selecting previously unselected package automake. 199s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 199s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 199s Selecting previously unselected package autopoint. 199s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 199s Unpacking autopoint (0.21-14ubuntu2) ... 199s Selecting previously unselected package gcc-13-base:arm64. 199s Preparing to unpack .../09-gcc-13-base_13.3.0-6ubuntu2~24.04_arm64.deb ... 199s Unpacking gcc-13-base:arm64 (13.3.0-6ubuntu2~24.04) ... 199s Selecting previously unselected package libisl23:arm64. 199s Preparing to unpack .../10-libisl23_0.26-3build1.1_arm64.deb ... 199s Unpacking libisl23:arm64 (0.26-3build1.1) ... 199s Selecting previously unselected package libmpc3:arm64. 199s Preparing to unpack .../11-libmpc3_1.3.1-1build1.1_arm64.deb ... 199s Unpacking libmpc3:arm64 (1.3.1-1build1.1) ... 199s Selecting previously unselected package cpp-13-aarch64-linux-gnu. 199s Preparing to unpack .../12-cpp-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 199s Unpacking cpp-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 200s Selecting previously unselected package cpp-13. 200s Preparing to unpack .../13-cpp-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 200s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 200s Selecting previously unselected package cpp-aarch64-linux-gnu. 200s Preparing to unpack .../14-cpp-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 200s Unpacking cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 200s Selecting previously unselected package cpp. 200s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_arm64.deb ... 200s Unpacking cpp (4:13.2.0-7ubuntu1) ... 200s Selecting previously unselected package libcc1-0:arm64. 200s Preparing to unpack .../16-libcc1-0_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libcc1-0:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libgomp1:arm64. 200s Preparing to unpack .../17-libgomp1_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libgomp1:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libitm1:arm64. 200s Preparing to unpack .../18-libitm1_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libitm1:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libatomic1:arm64. 200s Preparing to unpack .../19-libatomic1_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libatomic1:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libasan8:arm64. 200s Preparing to unpack .../20-libasan8_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libasan8:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package liblsan0:arm64. 200s Preparing to unpack .../21-liblsan0_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking liblsan0:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libtsan2:arm64. 200s Preparing to unpack .../22-libtsan2_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libtsan2:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libubsan1:arm64. 200s Preparing to unpack .../23-libubsan1_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libubsan1:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libhwasan0:arm64. 200s Preparing to unpack .../24-libhwasan0_14.2.0-4ubuntu2~24.04_arm64.deb ... 200s Unpacking libhwasan0:arm64 (14.2.0-4ubuntu2~24.04) ... 200s Selecting previously unselected package libgcc-13-dev:arm64. 200s Preparing to unpack .../25-libgcc-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 200s Unpacking libgcc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 200s Selecting previously unselected package gcc-13-aarch64-linux-gnu. 200s Preparing to unpack .../26-gcc-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 200s Unpacking gcc-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 201s Selecting previously unselected package gcc-13. 201s Preparing to unpack .../27-gcc-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 201s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 201s Selecting previously unselected package gcc-aarch64-linux-gnu. 201s Preparing to unpack .../28-gcc-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 201s Unpacking gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 201s Selecting previously unselected package gcc. 201s Preparing to unpack .../29-gcc_4%3a13.2.0-7ubuntu1_arm64.deb ... 201s Unpacking gcc (4:13.2.0-7ubuntu1) ... 201s Selecting previously unselected package libstdc++-13-dev:arm64. 201s Preparing to unpack .../30-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 201s Unpacking libstdc++-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 201s Selecting previously unselected package g++-13-aarch64-linux-gnu. 201s Preparing to unpack .../31-g++-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 201s Unpacking g++-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 201s Selecting previously unselected package g++-13. 201s Preparing to unpack .../32-g++-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 201s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 201s Selecting previously unselected package g++-aarch64-linux-gnu. 201s Preparing to unpack .../33-g++-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 201s Unpacking g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 201s Selecting previously unselected package g++. 201s Preparing to unpack .../34-g++_4%3a13.2.0-7ubuntu1_arm64.deb ... 201s Unpacking g++ (4:13.2.0-7ubuntu1) ... 201s Selecting previously unselected package build-essential. 201s Preparing to unpack .../35-build-essential_12.10ubuntu1_arm64.deb ... 201s Unpacking build-essential (12.10ubuntu1) ... 201s Selecting previously unselected package libllvm17t64:arm64. 201s Preparing to unpack .../36-libllvm17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 201s Unpacking libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 202s Selecting previously unselected package libclang-cpp17t64. 202s Preparing to unpack .../37-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 202s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 202s Selecting previously unselected package libgc1:arm64. 203s Preparing to unpack .../38-libgc1_1%3a8.2.6-1build1_arm64.deb ... 203s Unpacking libgc1:arm64 (1:8.2.6-1build1) ... 203s Selecting previously unselected package libobjc4:arm64. 203s Preparing to unpack .../39-libobjc4_14.2.0-4ubuntu2~24.04_arm64.deb ... 203s Unpacking libobjc4:arm64 (14.2.0-4ubuntu2~24.04) ... 203s Selecting previously unselected package libobjc-13-dev:arm64. 203s Preparing to unpack .../40-libobjc-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 203s Unpacking libobjc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 203s Selecting previously unselected package libclang-common-17-dev:arm64. 203s Preparing to unpack .../41-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_arm64.deb ... 203s Unpacking libclang-common-17-dev:arm64 (1:17.0.6-9ubuntu1) ... 203s Selecting previously unselected package llvm-17-linker-tools. 203s Preparing to unpack .../42-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_arm64.deb ... 203s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 203s Selecting previously unselected package libclang1-17t64. 203s Preparing to unpack .../43-libclang1-17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 203s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 203s Selecting previously unselected package clang-17. 203s Preparing to unpack .../44-clang-17_1%3a17.0.6-9ubuntu1_arm64.deb ... 203s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 203s Selecting previously unselected package libdebhelper-perl. 203s Preparing to unpack .../45-libdebhelper-perl_13.14.1ubuntu5_all.deb ... 203s Unpacking libdebhelper-perl (13.14.1ubuntu5) ... 203s Selecting previously unselected package libtool. 203s Preparing to unpack .../46-libtool_2.4.7-7build1_all.deb ... 203s Unpacking libtool (2.4.7-7build1) ... 203s Selecting previously unselected package dh-autoreconf. 203s Preparing to unpack .../47-dh-autoreconf_20_all.deb ... 203s Unpacking dh-autoreconf (20) ... 203s Selecting previously unselected package libarchive-zip-perl. 203s Preparing to unpack .../48-libarchive-zip-perl_1.68-1_all.deb ... 203s Unpacking libarchive-zip-perl (1.68-1) ... 203s Selecting previously unselected package libsub-override-perl. 203s Preparing to unpack .../49-libsub-override-perl_0.10-1_all.deb ... 203s Unpacking libsub-override-perl (0.10-1) ... 203s Selecting previously unselected package libfile-stripnondeterminism-perl. 203s Preparing to unpack .../50-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 203s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 203s Selecting previously unselected package dh-strip-nondeterminism. 203s Preparing to unpack .../51-dh-strip-nondeterminism_1.13.1-1_all.deb ... 203s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 203s Selecting previously unselected package debugedit. 203s Preparing to unpack .../52-debugedit_1%3a5.0-5build2_arm64.deb ... 203s Unpacking debugedit (1:5.0-5build2) ... 203s Selecting previously unselected package dwz. 203s Preparing to unpack .../53-dwz_0.15-1build6_arm64.deb ... 203s Unpacking dwz (0.15-1build6) ... 203s Selecting previously unselected package gettext. 203s Preparing to unpack .../54-gettext_0.21-14ubuntu2_arm64.deb ... 203s Unpacking gettext (0.21-14ubuntu2) ... 203s Selecting previously unselected package intltool-debian. 204s Preparing to unpack .../55-intltool-debian_0.35.0+20060710.6_all.deb ... 204s Unpacking intltool-debian (0.35.0+20060710.6) ... 204s Selecting previously unselected package po-debconf. 204s Preparing to unpack .../56-po-debconf_1.0.21+nmu1_all.deb ... 204s Unpacking po-debconf (1.0.21+nmu1) ... 204s Selecting previously unselected package debhelper. 204s Preparing to unpack .../57-debhelper_13.14.1ubuntu5_all.deb ... 204s Unpacking debhelper (13.14.1ubuntu5) ... 204s Selecting previously unselected package emacsen-common. 204s Preparing to unpack .../58-emacsen-common_3.0.5_all.deb ... 204s Unpacking emacsen-common (3.0.5) ... 204s Selecting previously unselected package dictionaries-common. 204s Preparing to unpack .../59-dictionaries-common_1.29.7_all.deb ... 204s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 204s Unpacking dictionaries-common (1.29.7) ... 204s Selecting previously unselected package libfakeroot:arm64. 204s Preparing to unpack .../60-libfakeroot_1.33-1_arm64.deb ... 204s Unpacking libfakeroot:arm64 (1.33-1) ... 204s Selecting previously unselected package fakeroot. 204s Preparing to unpack .../61-fakeroot_1.33-1_arm64.deb ... 204s Unpacking fakeroot (1.33-1) ... 204s Selecting previously unselected package hunspell-en-us. 204s Preparing to unpack .../62-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 204s Unpacking hunspell-en-us (1:2020.12.07-2) ... 204s Selecting previously unselected package icu-devtools. 204s Preparing to unpack .../63-icu-devtools_74.2-1ubuntu3.1_arm64.deb ... 204s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 204s Selecting previously unselected package libpgtypes3:arm64. 204s Preparing to unpack .../64-libpgtypes3_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libpgtypes3:arm64 (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libpq5:arm64. 204s Preparing to unpack .../65-libpq5_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libpq5:arm64 (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libecpg6:arm64. 204s Preparing to unpack .../66-libecpg6_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libecpg6:arm64 (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libecpg-compat3:arm64. 204s Preparing to unpack .../67-libecpg-compat3_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libecpg-compat3:arm64 (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libssl-dev:arm64. 204s Preparing to unpack .../68-libssl-dev_3.0.13-0ubuntu3.5_arm64.deb ... 204s Unpacking libssl-dev:arm64 (3.0.13-0ubuntu3.5) ... 204s Selecting previously unselected package libpq-dev. 204s Preparing to unpack .../69-libpq-dev_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libpq-dev (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libecpg-dev. 204s Preparing to unpack .../70-libecpg-dev_16.8-0ubuntu0.24.04.1_arm64.deb ... 204s Unpacking libecpg-dev (16.8-0ubuntu0.24.04.1) ... 204s Selecting previously unselected package libicu-dev:arm64. 204s Preparing to unpack .../71-libicu-dev_74.2-1ubuntu3.1_arm64.deb ... 204s Unpacking libicu-dev:arm64 (74.2-1ubuntu3.1) ... 205s Selecting previously unselected package libncurses-dev:arm64. 205s Preparing to unpack .../72-libncurses-dev_6.4+20240113-1ubuntu2_arm64.deb ... 205s Unpacking libncurses-dev:arm64 (6.4+20240113-1ubuntu2) ... 205s Selecting previously unselected package libtcl8.6:arm64. 205s Preparing to unpack .../73-libtcl8.6_8.6.14+dfsg-1build1_arm64.deb ... 205s Unpacking libtcl8.6:arm64 (8.6.14+dfsg-1build1) ... 205s Selecting previously unselected package libxml2-dev:arm64. 205s Preparing to unpack .../74-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.2_arm64.deb ... 205s Unpacking libxml2-dev:arm64 (2.9.14+dfsg-1.3ubuntu3.2) ... 205s Selecting previously unselected package libxslt1.1:arm64. 205s Preparing to unpack .../75-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_arm64.deb ... 205s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu0.24.04.2) ... 205s Selecting previously unselected package llvm-17-runtime. 205s Preparing to unpack .../76-llvm-17-runtime_1%3a17.0.6-9ubuntu1_arm64.deb ... 205s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 205s Selecting previously unselected package libpfm4:arm64. 205s Preparing to unpack .../77-libpfm4_4.13.0+git32-g0d4ed0e-1_arm64.deb ... 205s Unpacking libpfm4:arm64 (4.13.0+git32-g0d4ed0e-1) ... 205s Selecting previously unselected package llvm-17. 205s Preparing to unpack .../78-llvm-17_1%3a17.0.6-9ubuntu1_arm64.deb ... 205s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 206s Selecting previously unselected package libffi-dev:arm64. 206s Preparing to unpack .../79-libffi-dev_3.4.6-1build1_arm64.deb ... 206s Unpacking libffi-dev:arm64 (3.4.6-1build1) ... 206s Selecting previously unselected package llvm-17-tools. 206s Preparing to unpack .../80-llvm-17-tools_1%3a17.0.6-9ubuntu1_arm64.deb ... 206s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 206s Selecting previously unselected package libz3-4:arm64. 206s Preparing to unpack .../81-libz3-4_4.8.12-3.1build1_arm64.deb ... 206s Unpacking libz3-4:arm64 (4.8.12-3.1build1) ... 206s Selecting previously unselected package libz3-dev:arm64. 206s Preparing to unpack .../82-libz3-dev_4.8.12-3.1build1_arm64.deb ... 206s Unpacking libz3-dev:arm64 (4.8.12-3.1build1) ... 206s Selecting previously unselected package llvm-17-dev. 206s Preparing to unpack .../83-llvm-17-dev_1%3a17.0.6-9ubuntu1_arm64.deb ... 206s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 208s Selecting previously unselected package locales-all. 208s Preparing to unpack .../84-locales-all_2.39-0ubuntu8.4_arm64.deb ... 208s Unpacking locales-all (2.39-0ubuntu8.4) ... 209s Selecting previously unselected package postgresql-client-16. 209s Preparing to unpack .../85-postgresql-client-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 209s Unpacking postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-16. 210s Preparing to unpack .../86-postgresql-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 210s Unpacking postgresql-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-doc-16. 210s Preparing to unpack .../87-postgresql-doc-16_16.8-0ubuntu0.24.04.1_all.deb ... 210s Unpacking postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-plperl-16. 210s Preparing to unpack .../88-postgresql-plperl-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 210s Unpacking postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-plpython3-16. 210s Preparing to unpack .../89-postgresql-plpython3-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 210s Unpacking postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-pltcl-16. 210s Preparing to unpack .../90-postgresql-pltcl-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 210s Unpacking postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 210s Selecting previously unselected package postgresql-server-dev-16. 210s Preparing to unpack .../91-postgresql-server-dev-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 210s Unpacking postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 211s Setting up postgresql-client-common (257build1.1) ... 211s Setting up libpgtypes3:arm64 (16.8-0ubuntu0.24.04.1) ... 211s Setting up libncurses-dev:arm64 (6.4+20240113-1ubuntu2) ... 211s Setting up postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 211s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 211s Setting up libarchive-zip-perl (1.68-1) ... 211s Setting up libdebhelper-perl (13.14.1ubuntu5) ... 211s Setting up libpq5:arm64 (16.8-0ubuntu0.24.04.1) ... 211s Setting up m4 (1.4.19-4build1) ... 211s Setting up libgomp1:arm64 (14.2.0-4ubuntu2~24.04) ... 211s Setting up libffi-dev:arm64 (3.4.6-1build1) ... 211s Setting up locales-all (2.39-0ubuntu8.4) ... 211s Setting up libfakeroot:arm64 (1.33-1) ... 211s Setting up fakeroot (1.33-1) ... 211s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 211s Setting up autotools-dev (20220109.1) ... 211s Setting up libz3-4:arm64 (4.8.12-3.1build1) ... 211s Setting up libpfm4:arm64 (4.13.0+git32-g0d4ed0e-1) ... 211s Setting up gcc-13-base:arm64 (13.3.0-6ubuntu2~24.04) ... 211s Setting up libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 211s Setting up emacsen-common (3.0.5) ... 211s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 211s Setting up ssl-cert (1.1.2ubuntu1) ... 212s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 212s Setting up libssl-dev:arm64 (3.0.13-0ubuntu3.5) ... 212s Setting up libmpc3:arm64 (1.3.1-1build1.1) ... 212s Setting up libatomic1:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up libtcl8.6:arm64 (8.6.14+dfsg-1build1) ... 212s Setting up autopoint (0.21-14ubuntu2) ... 212s Setting up icu-devtools (74.2-1ubuntu3.1) ... 212s Setting up libgc1:arm64 (1:8.2.6-1build1) ... 212s Setting up autoconf (2.71-3) ... 212s Setting up libubsan1:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 212s Setting up dwz (0.15-1build6) ... 212s Setting up libclang-common-17-dev:arm64 (1:17.0.6-9ubuntu1) ... 212s Setting up libhwasan0:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up libasan8:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up libjson-perl (4.10000-1) ... 212s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 212s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu0.24.04.2) ... 212s Setting up debugedit (1:5.0-5build2) ... 212s Setting up libecpg6:arm64 (16.8-0ubuntu0.24.04.1) ... 212s Setting up libsub-override-perl (0.10-1) ... 212s Setting up libtsan2:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up libisl23:arm64 (0.26-3build1.1) ... 212s Setting up libicu-dev:arm64 (74.2-1ubuntu3.1) ... 212s Setting up libcc1-0:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up liblsan0:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up libitm1:arm64 (14.2.0-4ubuntu2~24.04) ... 212s Setting up automake (1:1.16.5-1.3ubuntu1) ... 212s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 212s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 212s Setting up libz3-dev:arm64 (4.8.12-3.1build1) ... 212s Setting up gettext (0.21-14ubuntu2) ... 212s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 212s Setting up libecpg-compat3:arm64 (16.8-0ubuntu0.24.04.1) ... 212s Setting up cpp-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 212s Setting up dictionaries-common (1.29.7) ... 212s Setting up postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 213s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 213s Setting up libpq-dev (16.8-0ubuntu0.24.04.1) ... 213s Setting up libobjc4:arm64 (14.2.0-4ubuntu2~24.04) ... 213s Setting up libecpg-dev (16.8-0ubuntu0.24.04.1) ... 213s Setting up intltool-debian (0.35.0+20060710.6) ... 213s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 213s Setting up cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 213s Setting up libxml2-dev:arm64 (2.9.14+dfsg-1.3ubuntu3.2) ... 213s Setting up postgresql-common (257build1.1) ... 213s 213s Creating config file /etc/postgresql-common/createcluster.conf with new version 213s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 213s en_us 214s Removing obsolete dictionary files: 214s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 214s Setting up dh-strip-nondeterminism (1.13.1-1) ... 214s Setting up libgcc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 214s Setting up hunspell-en-us (1:2020.12.07-2) ... 215s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 215s Setting up libobjc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 215s Setting up libstdc++-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 215s Setting up postgresql-16 (16.8-0ubuntu0.24.04.1) ... 215s Creating new PostgreSQL cluster 16/main ... 215s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 215s The files belonging to this database system will be owned by user "postgres". 215s This user must also own the server process. 215s 215s The database cluster will be initialized with locale "C.UTF-8". 215s The default database encoding has accordingly been set to "UTF8". 215s The default text search configuration will be set to "english". 215s 215s Data page checksums are disabled. 215s 215s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 215s creating subdirectories ... ok 215s selecting dynamic shared memory implementation ... posix 215s selecting default max_connections ... 100 215s selecting default shared_buffers ... 128MB 215s selecting default time zone ... Etc/UTC 215s creating configuration files ... ok 215s running bootstrap script ... ok 216s performing post-bootstrap initialization ... ok 216s syncing data to disk ... ok 219s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 219s Setting up po-debconf (1.0.21+nmu1) ... 219s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 219s Setting up gcc-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 219s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 219s Setting up postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 219s Setting up cpp (4:13.2.0-7ubuntu1) ... 219s Setting up postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 219s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 219s Setting up g++-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 219s Setting up gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 219s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 219s Setting up postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 219s Setting up libtool (2.4.7-7build1) ... 219s Setting up gcc (4:13.2.0-7ubuntu1) ... 219s Setting up dh-autoreconf (20) ... 219s Setting up postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 219s Setting up g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 219s Setting up debhelper (13.14.1ubuntu5) ... 219s Setting up g++ (4:13.2.0-7ubuntu1) ... 219s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 219s Setting up build-essential (12.10ubuntu1) ... 219s Processing triggers for libc-bin (2.39-0ubuntu8.4) ... 219s Processing triggers for systemd (255.4-1ubuntu8.6) ... 219s Processing triggers for man-db (2.12.0-4build2) ... 221s Processing triggers for install-info (7.1-3build2) ... 221s Processing triggers for dictionaries-common (1.29.7) ... 225s autopkgtest [12:31:42]: test run-testsuite: [----------------------- 226s ====== Running all tests with umask 077 ======= 226s ### PostgreSQL test 001_packages.t ### 226s 1..22 226s ok 1 - /etc/os-release exists 226s ok 2 - OS is ubuntu 226s ok 3 - OS version is 24.04 226s # PostgreSQL versions installed: 16 226s ok 4 - postgresql-16 installed 226s ok 5 # skip No python2 support 226s ok 6 - postgresql-plpython3-16 installed 226s ok 7 - postgresql-plperl-16 installed 226s ok 8 - postgresql-pltcl-16 installed 226s ok 9 - postgresql-server-dev-16 installed 226s ok 10 # skip No postgresql-contrib-16 package for version 16 226s # postgresql-doc-16 installed 226s ok 11 - At least one doc package installed 226s ok 12 - libecpg-dev installed 226s ok 13 - procps installed 226s ok 14 - netcat-openbsd installed 226s ok 15 - hunspell-en-us installed 226s ok 16 - system has a default UTF-8 locale 226s ok 17 - locale ru_RU exists 226s ok 18 - locale ru_RU.UTF-8 exists 226s ok 19 - user postgres in the UNIX group ssl-cert 226s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 226s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 226s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 226s ### End test 001_packages.t ### 226s 226s ### PostgreSQL test 002_existing_clusters.t ### 226s 1..8 226s # Cleanup 226s ok 1 - Cleanup: No clusters left behind 226s ok 2 - No postgres processes left behind 226s ok 3 - No files in /etc/postgresql left behind 226s ok 4 - No files in /var/lib/postgresql left behind 226s ok 5 - No files in /var/run/postgresql left behind 226s ok 6 - No files in /var/log/postgresql left behind 226s ok 7 - PostgreSQL TCP ports are closed 226s ok 8 - Next free port is 5432 226s ### End test 002_existing_clusters.t ### 226s 226s ### PostgreSQL test 003_alternatives.t ### 226s 1..9 226s # Newest PG version installed is 16 226s ok 1 - psql.1.gz link group 226s ok 2 - postmaster.1.gz link group does not exist 226s ok 3 - psql.1.gz alternative 226s ok 4 - pg_dump.1.gz alternative 226s ok 5 - postgres.1.gz alternative 226s ok 6 - pg_ctl.1.gz alternative 226s # Newest PG doc version installed is 16 226s ok 7 - SPI_connect.3.gz link group 226s ok 8 - SPI_connect.3.gz alternative 226s ok 9 - SPI_exec.3.gz alternative 226s ### End test 003_alternatives.t ### 226s 226s ### PostgreSQL test 005_PgCommon.t ### 226s 1..24 226s ok 1 - correctly parsed line 'local all postgres ident sameuser' 226s ok 2 - correctly parsed line 'local foo nobody trust' 226s ok 3 - correctly parsed line 'local foo nobody crypt' 226s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 226s ok 5 - correctly parsed line 'local foo,bar nobody ident' 226s ok 6 - correctly parsed line 'local all +foogrp password' 226s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 226s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 226s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 226s ok 10 - @expected_records has correct number of entries 226s ok 11 - returned read_pg_hba array has correct number of records 226s ok 12 - line 'foo all all md5' parsed as invalid 226s ok 13 - line 'local all all foo' parsed as invalid 226s ok 14 - line 'host all all foo' parsed as invalid 226s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 226s ok 16 - line 'host all all md5' parsed as invalid 226s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 226s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 226s ok 19 - read_conf_file returns empty dict for nonexisting file 226s ok 20 - read_conf_file() parsing 226s ok 21 - read_conf_file() parsing with include directives 226s ok 22 - set_conf_value 226s ok 23 - disable_conf_value 226s ok 24 - replace_conf_value 226s ### End test 005_PgCommon.t ### 226s 226s ### PostgreSQL test 006_next_free_port.t ### 226s 1..5 226s ok 1 - next_free_port is 5432 227s ok 2 - next_free_port detects localhost ipv4 socket 228s ok 3 - next_free_port detects wildcard ipv4 socket 229s ok 4 - next_free_port detects localhost ipv6 socket 230s ok 5 - next_free_port detects wildcard ipv6 socket 230s ### End test 006_next_free_port.t ### 230s 230s ### PostgreSQL test 007_pg_conftool.t ### 230s 1..41 230s # test without cluster 230s ok 1 - pg_conftool show all 230s ok 2 - correct output of pg_conftool show all 230s ok 3 - pg_conftool foo.conf show all 230s ok 4 - correct output of pg_conftool foo.conf show all 230s ok 5 - pg_conftool /tmp/QsI0DnGDmL/different.conf show all 230s ok 6 - correct output of pg_conftool /tmp/QsI0DnGDmL/different.conf show all 230s ok 7 - pg_conftool 9.7 main show all 230s ok 8 - correct output of pg_conftool 9.7 main show all 230s # test show 230s ok 9 - pg_conftool show all 230s ok 10 - correct output of pg_conftool show all 230s ok 11 - pg_conftool other.conf show all 230s ok 12 - correct output of pg_conftool other.conf show all 231s ok 13 - pg_conftool /tmp/QsI0DnGDmL/different.conf show all 231s ok 14 - correct output of pg_conftool /tmp/QsI0DnGDmL/different.conf show all 231s ok 15 - pg_conftool 16 main show all 231s ok 16 - correct output of pg_conftool 16 main show all 231s ok 17 - pg_conftool 16 main other.conf show all 231s ok 18 - correct output of pg_conftool 16 main other.conf show all 231s ok 19 - pg_conftool show a 231s ok 20 - correct output of pg_conftool show a 231s ok 21 - pg_conftool -s show a 231s ok 22 - correct output of pg_conftool -s show a 231s # test set 231s ok 23 - pg_conftool set c 7 231s ok 24 - correct output of pg_conftool set c 7 231s ok 25 - file contains new setting 231s ok 26 - pg_conftool set a 8 231s ok 27 - correct output of pg_conftool set a 8 231s ok 28 - file contains updated setting 231s ok 29 - pg_conftool /tmp/QsI0DnGDmL/different.conf set a 9 231s ok 30 - correct output of pg_conftool /tmp/QsI0DnGDmL/different.conf set a 9 231s ok 31 - file with path contains updated setting 231s # test remove 231s ok 32 - pg_conftool remove a 231s ok 33 - correct output of pg_conftool remove a 231s ok 34 - setting removed from file 231s ok 35 - pg_conftool /tmp/QsI0DnGDmL/different.conf remove a 231s ok 36 - correct output of pg_conftool /tmp/QsI0DnGDmL/different.conf remove a 231s ok 37 - setting removed from file with path 231s # test edit 231s ok 38 - pg_conftool edit 231s ok 39 - correct output of pg_conftool edit 231s ok 40 - pg_conftool /tmp/QsI0DnGDmL/different.conf edit 231s ok 41 - correct output of pg_conftool /tmp/QsI0DnGDmL/different.conf edit 231s ### End test 007_pg_conftool.t ### 231s 231s ### PostgreSQL test 010_defaultport_cluster.t ### 231s 1..14 231s ok 1 - psql --version 231s ok 2 - pg_wrapper selects highest available version number 231s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 231s ok 4 - connecting to localhost fails with no clusters 231s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 231s ok 6 - pg_wrapper uses host and port from PGCLUSTER 231s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 231s ok 8 - pg_wrapper uses --cluster from the command line 231s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 231s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 231s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 231s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 231s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 231s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 231s ### End test 010_defaultport_cluster.t ### 231s 231s ### PostgreSQL test 015_start_stop.t ### 231s 1..71 231s # We are running systemd 231s # Running tests for 16 231s # Cluster does not exist yet 231s ok 1 - cluster 16 main does not exist 231s ok 2 - service postgresql@16-main does not exist 231s ok 3 - systemctl start postgresql 231s ok 4 - cluster 16 main does not exist 231s ok 5 - service postgresql@16-main does not exist 232s ok 6 - systemctl start postgresql@16-main 232s ok 7 - cluster 16 main does not exist 232s ok 8 - service postgresql@16-main does not exist 232s # Start/stop postgresql using system tools 233s ok 9 - pg_createcluster 16 main 233s ok 10 - cluster 16 main is stopped 233s ok 11 - service postgresql@16-main is stopped 235s ok 12 - systemctl start postgresql 235s ok 13 - cluster 16 main is running 235s ok 14 - service postgresql@16-main is running 235s ok 15 - systemctl start postgresql 235s ok 16 - cluster 16 main is already running 235s ok 17 - service postgresql@16-main is already running 235s ok 18 - systemctl stop postgresql 241s ok 19 - cluster 16 main is stopped 241s ok 20 - service postgresql@16-main is stopped 241s ok 21 - systemctl stop postgresql 241s ok 22 - cluster 16 main is already stopped 241s ok 23 - service postgresql@16-main is already stopped 241s # Start/stop specific cluster using system tools 243s ok 24 - systemctl start postgresql@16-main 244s ok 25 - cluster 16 main is running 244s ok 26 - service postgresql@16-main is running 244s ok 27 - systemctl start postgresql@16-main 244s ok 28 - cluster 16 main is running 244s ok 29 - service postgresql@16-main is running 246s ok 30 - systemctl restart postgresql@16-main 246s ok 31 - cluster 16 main is running 246s ok 32 - service postgresql@16-main is running 246s ok 33 - systemctl stop postgresql@16-main 246s ok 34 - cluster 16 main is stopped 246s ok 35 - service postgresql@16-main is stopped 246s ok 36 - systemctl stop postgresql@16-main 246s ok 37 - cluster 16 main is already stopped 246s ok 38 - service postgresql@16-main is already stopped 248s ok 39 - pg_dropcluster 16 main 248s ok 40 - cluster 16 main does not exist 248s ok 41 - service postgresql@16-main does not exist 248s # Start/stop specific cluster using pg_*cluster 248s ok 42 - pg_ctlcluster start 16 main 248s ok 43 - cluster 16 main does not exist 248s ok 44 - service postgresql@16-main does not exist 251s ok 45 - pg_createcluster 16 main --start 251s ok 46 - cluster 16 main is running 251s ok 47 - service postgresql@16-main is running 251s ok 48 - pg_ctlcluster 16 main start 251s ok 49 - cluster 16 main is already running 251s ok 50 - service postgresql@16-main is already running 254s ok 51 - pg_ctlcluster 16-main restart 254s ok 52 - cluster 16 main is running 254s ok 53 - service postgresql@16-main is running 254s ok 54 - pg_ctlcluster 16 main stop 254s ok 55 - cluster 16 main is stopped 254s ok 56 - service postgresql@16-main is stopped 254s ok 57 - pg_ctlcluster 16 main stop 254s ok 58 - cluster 16 main is already stopped 254s ok 59 - service postgresql@16-main is already stopped 256s ok 60 - pg_ctlcluster start 16-main 256s ok 61 - cluster 16 main is running 256s ok 62 - service postgresql@16-main is running 258s ok 63 - pg_dropcluster 16 main --stop 258s # Cleanup 258s ok 64 - Cleanup: No clusters left behind 258s ok 65 - No postgres processes left behind 258s ok 66 - No files in /etc/postgresql left behind 258s ok 67 - No files in /var/lib/postgresql left behind 258s ok 68 - No files in /var/run/postgresql left behind 258s ok 69 - No files in /var/log/postgresql left behind 258s ok 70 - PostgreSQL TCP ports are closed 258s ok 71 - Next free port is 5432 258s ### End test 015_start_stop.t ### 258s 258s ### PostgreSQL test 020_create_sql_remove.t ### 258s 1..147 258s # Running tests for 16 261s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.6pRwkr 261s ok 2 - pg_createcluster 16 main 261s ok 3 - Socket and pid file are in /var/run/postgresql/ 261s ok 4 - xlog/wal directory /tmp/16.xlog.6pRwkr was created 261s ok 5 - local method in pg_hba.conf is peer 261s ok 6 - host method in pg_hba.conf is scram-sha-256 261s ok 7 - Exactly one postgres master process running 264s ok 8 - pg_ctlcluster 16 main restart 264s ok 9 - cluster restarts with new environment file 264s ok 10 - Exactly one postgres master process running 264s ok 11 - correct value of PGEXTRAVAR1 in environment 264s ok 12 - correct value of PGEXTRAVAR2 in environment 264s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 264s ok 14 - createdb --version 264s ok 15 - pg_wrapper+createdb selects version number of cluster 264s ok 16 - psql --version 264s ok 17 - pg_wrapper+psql selects version 16 264s ok 18 - pg_lscluster reports online cluster on port 5432 264s ok 19 - log file is actually used 264s ok 20 - /etc/postgresql is owned by user "postgres" 264s ok 21 - version configuration directory file is owned by user "postgres" 264s ok 22 - configuration directory file is owned by user "postgres" 264s ok 23 - version data directory file is owned by user "postgres" 264s ok 24 - data directory file is owned by user "postgres" 264s ok 25 - log file has 0640 permissions 264s ok 26 - log file is owned by user "postgres" 264s ok 27 - log file is owned by group "adm" 264s ok 28 - no log symlink by default 264s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 264s ok 30 - pg_lsclusters -h 264s ok 31 - correct output of pg_lsclusters -h 264s ok 32 - stopping cluster 267s ok 33 - restarting cluster with nondefault log symlink 267s ok 34 - log target is used as log file 267s ok 35 - default log is not used 267s ok 36 - pg_lsclusters -h 267s ok 37 - correct output of pg_lsclusters -h 267s ok 38 - stopping cluster 270s ok 39 - restarting cluster with explicitly configured log file 270s ok 40 - default log is not used 270s ok 41 - log symlink target is used for startup message 270s ok 42 - exactly one log file 270s ok 43 - custom log is actually used 270s ok 44 - pg_lsclusters -h 270s ok 45 - correct output of pg_lsclusters -h 270s ok 46 - stopping cluster 270s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 270s ok 48 - /etc/postgres-hack was not created 272s ok 49 - restarting cluster 272s ok 50 - ps -o tty -U postgres h 272s ok 51 - postgres processes do not have an associated terminal 272s ok 52 - Server is linked with SSL support 272s ok 53 - SSL is enabled in postgresql.conf 272s ok 54 - psql -l fails for nobody 272s ok 55 - createuser nobody 272s ok 56 - createdb nobodydb 272s ok 57 - psql -ltA succeeds for nobody 272s ok 58 - psql -ltA output 272s ok 59 - SQL command: create table 272s ok 60 - SQL command: insert into table values 272s ok 61 - SQL command: insert into table values 273s ok 62 - primary key violation 273s ok 63 - psql -tAc "select * from phone order by name" nobodydb 273s ok 64 - SQL command output: select -tA 273s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 273s ok 66 - SQL command output: select -tx 273s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 273s ok 68 - SQL command output: select -tAx 273s ok 69 - CREATE EXTENSION plperlu fails for user nobody 273s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 273s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 273s ok 72 - creating PL/PerlU function as user nobody fails 273s ok 73 - creating unsafe PL/Perl function as user postgres fails 273s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 273s ok 75 - creating PL/PerlU function as user postgres succeeds 273s ok 76 - psql nobodydb -Atc "select read_file()" 273s ok 77 - calling PL/PerlU function 273s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 273s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 273s ok 80 - creating unsafe PL/Perl function as user nobody fails 273s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 273s ok 82 - creating PL/Perl function as user nobody succeeds 273s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 273s ok 84 - calling PL/Perl function 273s ok 85 # skip No python2 support 273s ok 86 # skip No python2 support 273s ok 87 # skip No python2 support 273s ok 88 # skip No python2 support 273s ok 89 # skip No python2 support 273s ok 90 # skip No python2 support 273s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 273s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 273s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 273s ok 94 - creating PL/Python3 function as user postgres succeeds 273s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 273s ok 96 - calling PL/Python function 274s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 274s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 274s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 274s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 274s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 274s ok 102 - creating PL/Tcl function as user nobody succeeds 274s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 274s ok 104 - creating PL/TclU function as user postgres succeeds 274s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 274s ok 106 - calling PL/Tcl function 274s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 274s ok 108 - calling PL/TclU function 274s ok 109 - stopping cluster 274s ok 110 - pg_ctlcluster 16 main start 274s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 276s ok 112 - pg_ctlcluster 16 main start 276s ok 113 - cluster restarts with pgdata symlink 277s ok 114 - postgres master has OOM killer protection 277s ok 115 - postgres client backend has no OOM adjustment 277s ok 116 - ps h 7219 277s ok 117 - process title is idle 277s ok 118 - ps h 7219 277s ok 119 - process title is idle in transaction 277s ok 120 - stopping cluster 280s ok 121 - starting cluster as postgres works without a log file 280s ok 122 - log file got recreated and used 280s ok 123 - creating a directory in spc2 280s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.XY3lCG'" 280s ok 125 - creating tablespace spc1 280s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 280s ok 127 - creating a table in spc1 280s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.f7TKek'" 280s ok 129 - creating tablespace spc2 280s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 280s ok 131 - creating a table in spc2 280s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 280s ok 133 - Correct apt NeverAutoRemove config 281s ok 134 - pg_dropcluster removes cluster 281s ok 135 - xlog/wal directory /tmp/16.xlog.6pRwkr was deleted 281s ok 136 - tablespace spc1 was emptied 281s ok 137 - tablespace spc2 was emptied 281s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 281s ok 139 - Correct apt NeverAutoRemove config 281s # Cleanup 281s ok 140 - Cleanup: No clusters left behind 281s ok 141 - No postgres processes left behind 281s ok 142 - No files in /etc/postgresql left behind 281s ok 143 - No files in /var/lib/postgresql left behind 281s ok 144 - No files in /var/run/postgresql left behind 281s ok 145 - No files in /var/log/postgresql left behind 281s ok 146 - PostgreSQL TCP ports are closed 281s ok 147 - Next free port is 5432 281s ### End test 020_create_sql_remove.t ### 281s 281s ### PostgreSQL test 021_pg_renamecluster.t ### 281s 1..20 285s ok 1 - pg_createcluster 16 main 287s ok 2 - pg_renamecluster 16 main donau 287s ok 3 - psql -tAc "show data_directory" 287s ok 4 - cluster is running and data_directory was moved 287s ok 5 - pg_hba.conf location updated 287s ok 6 - pg_ident.conf location updated 287s ok 7 - external_pid_file location updated 287s ok 8 - external_pid_file exists 287s ok 9 # skip no stats_temp_directory in 16 287s ok 10 # skip no stats_temp_directory in 16 287s ok 11 - cluster_name is updated 289s ok 12 - pg_dropcluster removes cluster 289s # Cleanup 289s ok 13 - Cleanup: No clusters left behind 289s ok 14 - No postgres processes left behind 289s ok 15 - No files in /etc/postgresql left behind 289s ok 16 - No files in /var/lib/postgresql left behind 289s ok 17 - No files in /var/run/postgresql left behind 289s ok 18 - No files in /var/log/postgresql left behind 289s ok 19 - PostgreSQL TCP ports are closed 289s ok 20 - Next free port is 5432 289s ### End test 021_pg_renamecluster.t ### 289s 289s ### PostgreSQL test 022_recovery.t ### 289s 1..17 289s # Running tests for 16 292s ok 1 - pg_createcluster 16 main --start >/dev/null 292s ok 2 - pg_ctlcluster 16 main stop -m i 295s ok 3 - pg_ctlcluster 16 main start 295s ok 4 - psql -c '' 295s ok 5 - pg_ctlcluster 16 main stop -m i 295s ok 6 - create write-protected file in data directory 297s ok 7 - pg_ctlcluster 16 main start 299s ok 8 - psql -c '' 299s ok 9 - pg_dropcluster removes cluster 299s # Cleanup 299s ok 10 - Cleanup: No clusters left behind 299s ok 11 - No postgres processes left behind 299s ok 12 - No files in /etc/postgresql left behind 299s ok 13 - No files in /var/lib/postgresql left behind 299s ok 14 - No files in /var/run/postgresql left behind 299s ok 15 - No files in /var/log/postgresql left behind 299s ok 16 - PostgreSQL TCP ports are closed 299s ok 17 - Next free port is 5432 299s ### End test 022_recovery.t ### 299s 299s ### PostgreSQL test 025_logging.t ### 299s 1..55 299s # Logging to /var/log/syslog works 299s # Running tests for 16 303s ok 1 - pg_createcluster 16 main 303s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 303s ok 3 - psql -qc "'foobar_16_8369'" 303s ok 4 - log an error 303s ok 5 - grep --binary-files=text foobar_16_8369 /var/log/postgresql/postgresql-16-main.log 303s ok 6 - error appears in logfile 303s ok 7 - pg_conftool 16 main set log_destination syslog 303s ok 8 - set log_destination syslog 303s ok 9 - pg_ctlcluster 16 main reload 303s ok 10 - 16 main reload 303s ok 11 - psql -Atc "show log_destination" 303s ok 12 - log_destination is syslog 303s ok 13 - pg_lscluster reports syslog 304s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 304s ok 15 - error appears in /var/log/syslog 304s ok 16 - pg_conftool 16 main set logging_collector on 304s ok 17 - set logging_collector on 304s ok 18 - pg_conftool 16 main set log_destination csvlog 304s ok 19 - set log_destination csvlog 306s ok 20 - pg_ctlcluster 16 main restart 306s ok 21 - 16 main restart 306s ok 22 - psql -Atc "show logging_collector" 306s ok 23 - logging_collector is on 307s ok 24 - psql -Atc "show log_destination" 307s ok 25 - log_destination is csvlog 307s ok 26 - pg_lscluster reports csvlog 307s ok 27 - psql -qc "'barbaz_16_8369'" 307s ok 28 - log an error 307s ok 29 - grep --binary-files=text barbaz_16_8369 /var/lib/postgresql/16/main/log/*.csv 307s ok 30 - error appears in log/*.csv 307s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 307s ok 32 - set log_destination stderr,syslog,csvlog 307s ok 33 - pg_ctlcluster 16 main reload 307s ok 34 - 16 main reload 307s ok 35 - psql -Atc "show log_destination" 307s ok 36 - log_destination is stderr,syslog,csvlog 307s ok 37 - pg_lscluster reports stderr,syslog,csvlog 307s ok 38 - psql -qc "'moo_16_8369'" 307s ok 39 - log an error 308s ok 40 - grep --binary-files=text moo_16_8369 /var/lib/postgresql/16/main/log/*.log 308s ok 41 - error appears in log/*.log 308s ok 42 - grep --binary-files=text 'postgres.*moo_16_8369' /var/log/syslog 308s ok 43 - error appears in /var/log/syslog 308s ok 44 - grep --binary-files=text moo_16_8369 /var/lib/postgresql/16/main/log/*.csv 308s ok 45 - error appears in log/*.csv 310s ok 46 - pg_dropcluster 16 main --stop 310s ok 47 - pg_dropcluster removes cluster 310s # Cleanup 310s ok 48 - Cleanup: No clusters left behind 310s ok 49 - No postgres processes left behind 310s ok 50 - No files in /etc/postgresql left behind 310s ok 51 - No files in /var/lib/postgresql left behind 310s ok 52 - No files in /var/run/postgresql left behind 310s ok 53 - No files in /var/log/postgresql left behind 310s ok 54 - PostgreSQL TCP ports are closed 310s ok 55 - Next free port is 5432 310s ### End test 025_logging.t ### 310s 310s ### PostgreSQL test 030_errors.t ### 310s 1..156 310s ok 1 - pg_lscluster reports cluster without binaries 311s ok 2 - pg_dropcluster 6.3 main 312s ok 3 - pg_createcluster --socketdir 312s ok 4 - pg_lsclusters -h 312s ok 5 - cluster was created 312s ok 6 - Port of created cluster is 5432 312s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 312s ok 8 - pg_createcluster on existing cluster 312s ok 9 - pg_lsclusters -h 312s ok 10 - original cluster still exists 312s ok 11 - pg_createcluster 16 test -p foo 312s ok 12 - pg_createcluster -p checks that port option is numeric 312s ok 13 - pg_createcluster 16 test -p 42 312s ok 14 - pg_createcluster -p checks valid port range 312s ok 15 - pg_ctlcluster 16 main start 312s ok 16 - pg_ctlcluster refuses to start root-owned cluster 312s ok 17 - pg_ctlcluster 16 main start 312s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 312s ok 19 - pg_ctlcluster 16 main start 312s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 313s ok 21 - pg_ctlcluster 16 main start 313s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 315s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 315s ok 24 - No sockets in /var/run/postgresql 315s ok 25 - Socket is in /tmp/postgresql-testsuite/ 315s ok 26 - cluster stops with custom unix_socket_dir 315s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 317s ok 28 - cluster starts after removing unix_socket_dir 317s ok 29 - Socket is in default dir /var/run/postgresql 317s ok 30 - No sockets in /tmp/postgresql-testsuite/ 317s ok 31 - pg_ctlcluster 16 main stop 317s ok 32 - pg_ctlcluster fails with corrupted PID file 317s ok 33 - pg_lsclusters -h 317s ok 34 - cluster is still online 318s ok 35 - pg_ctlcluster succeeds with restored PID file 318s ok 36 - pg_lsclusters -h 318s ok 37 - cluster is down 318s ok 38 - pg_ctlcluster 16 main stop 318s ok 39 - pg_ctlcluster stop fails on stopped cluster 320s ok 40 - pg_ctlcluster 16 main start 320s ok 41 - pg_ctlcluster succeeds with already existing PID file 320s ok 42 - pg_lsclusters -h 320s ok 43 - cluster is online 320s ok 44 - pg_ctlcluster stop succeeds 320s ok 45 - pg_lsclusters -h 320s ok 46 - cluster is down 320s ok 47 - no pid file left 320s ok 48 - pg_ctlcluster 16 main stop 320s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 320s ok 50 - pid file was cleaned up 320s ok 51 - pg_ctlcluster --force 16 main stop 320s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 320s ok 53 - pid file was cleaned up 320s ok 54 - pg_ctlcluster 16 main stop 320s ok 55 - pg_ctlcluster stop succeeds with stale PID file 320s ok 56 - pid file was cleaned up 320s ok 57 - pg_ctlcluster --force 16 main stop 320s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 320s ok 59 - pid file was cleaned up 320s ok 60 - pg_ctlcluster --force 16 main stop 320s ok 61 - pg_ctlcluster stop succeeds with empty PID file 320s ok 62 - pid file was cleaned up 323s ok 63 - pg_ctlcluster 16 main start 323s ok 64 - pg_ctlcluster succeeds with corrupted PID file 323s ok 65 - pg_lsclusters -h 323s ok 66 - cluster is online 323s ok 67 - pg_ctlcluster 16 main start 323s ok 68 - pg_ctlcluster start fails on running cluster 323s ok 69 - pg_ctlcluster stop 323s ok 70 - pg_ctlcluster 16 main start 323s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 323s ok 72 - pg_ctlcluster 16 main stop 323s ok 73 - stopping cluster 329s ok 74 - pg_ctlcluster 16 main start 329s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 329s ok 76 - pg_ctlcluster 16 main stop 329s ok 77 - stopping cluster 329s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 329s ok 79 - pg_dropcluster 16 main 329s ok 80 - pg_dropcluster works as user postgres 330s ok 81 - pg_createcluster succeeds 331s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 331s ok 83 - proper error message for nonexisting /var/lib/postgresql 333s ok 84 - pg_ctlcluster 16 main start 333s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 333s ok 86 - pg_ctlcluster 16 main stop 333s ok 87 - stopping cluster 334s ok 88 - pg_createcluster other 336s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 338s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 338s ok 91 338s ok 92 - pg_ctlcluster 16 other start 338s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 339s ok 94 - pg_ctlcluster 16 main stop 339s ok 95 - stopping main cluster 341s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 342s ok 97 - pg_dropcluster other 344s ok 98 - pg_dropcluster 344s ok 99 - No sockets any more 344s ok 100 - 'pg_lsclusters 4.5 foo' fails 344s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 344s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 103 - 'psql --cluster 4.5/foo' fails 344s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 344s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 344s ok 106 - 'psql --cluster 16/foo' fails 344s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 344s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 344s ok 109 - 'pg_dropcluster 4.5 foo' fails 344s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 344s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 112 - 'pg_dropcluster 16 foo' fails 344s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 344s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 344s ok 115 - 'pg_upgradecluster 4.5 foo' fails 344s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 344s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 118 - 'pg_upgradecluster 16 foo' fails 344s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 344s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 344s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 344s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 344s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 344s ok 124 - 'pg_ctlcluster 16 foo stop' fails 344s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 344s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 344s # Cleanup 344s ok 127 - Cleanup: No clusters left behind 344s ok 128 - No postgres processes left behind 344s ok 129 - No files in /etc/postgresql left behind 344s ok 130 - No files in /var/lib/postgresql left behind 344s ok 131 - No files in /var/run/postgresql left behind 344s ok 132 - No files in /var/log/postgresql left behind 344s ok 133 - PostgreSQL TCP ports are closed 344s ok 134 - Next free port is 5432 345s ok 135 - pg_dropcluster 16 broken 345s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 345s # Cleanup 345s ok 137 - Cleanup: No clusters left behind 345s ok 138 - No postgres processes left behind 345s ok 139 - No files in /etc/postgresql left behind 345s ok 140 - No files in /var/lib/postgresql left behind 345s ok 141 - No files in /var/run/postgresql left behind 345s ok 142 - No files in /var/log/postgresql left behind 345s ok 143 - PostgreSQL TCP ports are closed 345s ok 144 - Next free port is 5432 346s ok 145 - pg_dropcluster 16 broken 346s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 346s ok 147 - /etc/postgresql/16 was removed 346s ok 148 - /var/lib/postgresql/16 was removed 346s # Cleanup 347s ok 149 - Cleanup: No clusters left behind 347s ok 150 - No postgres processes left behind 347s ok 151 - No files in /etc/postgresql left behind 347s ok 152 - No files in /var/lib/postgresql left behind 347s ok 153 - No files in /var/run/postgresql left behind 347s ok 154 - No files in /var/log/postgresql left behind 347s ok 155 - PostgreSQL TCP ports are closed 347s ok 156 - Next free port is 5432 347s ### End test 030_errors.t ### 347s 347s ### PostgreSQL test 031_errors_disk_full.t ### 347s 1..22 347s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 348s ok 1 - script failed 348s ok 2 - pg_createcluster fails due to insufficient disk space 348s ok 3 - does not leave files behind 348s # Cleanup 348s ok 4 - Cleanup: No clusters left behind 348s ok 5 - No postgres processes left behind 348s ok 6 - No files in /etc/postgresql left behind 348s ok 7 - No files in /var/lib/postgresql left behind 348s ok 8 - No files in /var/run/postgresql left behind 348s ok 9 - No files in /var/log/postgresql left behind 348s ok 10 - PostgreSQL TCP ports are closed 348s ok 11 - Next free port is 5432 348s # check disk full conditions on startup 350s ok 12 - script failed 350s ok 13 - pg_ctlcluster prints error message 350s ok 14 - log file has error message 350s # Cleanup 350s ok 15 - Cleanup: No clusters left behind 350s ok 16 - No postgres processes left behind 350s ok 17 - No files in /etc/postgresql left behind 350s ok 18 - No files in /var/lib/postgresql left behind 350s ok 19 - No files in /var/run/postgresql left behind 350s ok 20 - No files in /var/log/postgresql left behind 350s ok 21 - PostgreSQL TCP ports are closed 350s ok 22 - Next free port is 5432 350s ### End test 031_errors_disk_full.t ### 350s 350s ### PostgreSQL test 032_ssl_key_permissions.t ### 351s 1..22 351s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 351s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 351s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 351s # 16 (16.8-0ubuntu0.24.04.1) 352s ok 4 - pg_createcluster 16 main 352s ok 5 - pg_ctlcluster 16 main start 352s ok 6 - ssl key owned by nobody refused 352s ok 7 - pg_ctlcluster 16 main start 352s ok 8 - ssl key with permissions root:root 0644 refused 352s ok 9 - pg_ctlcluster 16 main start 352s ok 10 - ssl key with permissions postgres:postgres 0640 refused 353s ok 11 - pg_dropcluster 16 main --stop 353s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 353s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 353s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 353s # Cleanup 353s ok 15 - Cleanup: No clusters left behind 353s ok 16 - No postgres processes left behind 353s ok 17 - No files in /etc/postgresql left behind 353s ok 18 - No files in /var/lib/postgresql left behind 353s ok 19 - No files in /var/run/postgresql left behind 353s ok 20 - No files in /var/log/postgresql left behind 353s ok 21 - PostgreSQL TCP ports are closed 353s ok 22 - Next free port is 5432 353s ### End test 032_ssl_key_permissions.t ### 353s 353s ### PostgreSQL test 040_upgrade.t ### 354s 1..1 354s ok 1 - only one major version installed, skipping upgrade tests 354s ### End test 040_upgrade.t ### 354s 354s ### PostgreSQL test 041_upgrade_custompaths.t ### 354s 1..1 354s ok 1 - only one major version installed, skipping upgrade tests 354s ### End test 041_upgrade_custompaths.t ### 354s 354s ### PostgreSQL test 042_upgrade_rename.t ### 354s 1..15 354s # PostgreSQL 16 357s ok 1 - pg_createcluster 16 main --start 363s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 363s ok 3 - pg_lsclusters -h 363s ok 4 - correct output of pg_lsclusters -h 364s ok 5 - pg_dropcluster 16 main --stop 366s ok 6 - pg_dropcluster 16 upgr --stop 366s ok 7 - Cleaning pg_upgrade log files 366s # Cleanup 366s ok 8 - Cleanup: No clusters left behind 366s ok 9 - No postgres processes left behind 366s ok 10 - No files in /etc/postgresql left behind 366s ok 11 - No files in /var/lib/postgresql left behind 366s ok 12 - No files in /var/run/postgresql left behind 366s ok 13 - No files in /var/log/postgresql left behind 366s ok 14 - PostgreSQL TCP ports are closed 366s ok 15 - Next free port is 5432 366s ### End test 042_upgrade_rename.t ### 366s 366s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 366s 1..1 366s ok 1 - only one major version installed, skipping upgrade tests 366s ### End test 043_upgrade_ssl_cert.t ### 366s 366s ### PostgreSQL test 045_backup.t ### 366s # We are running systemd 366s # PostgreSQL 16 366s # create cluster 369s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 369s ok 2 - pg_lsclusters -h 369s ok 3 - correct output of pg_lsclusters -h 369s ok 4 - pg_conftool 16 main set work_mem 11MB 370s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 370s ok 6 - psql -c 'alter database mydb set search_path=public' 370s ok 7 - psql -c 'create table foo (t text)' mydb 370s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 370s ok 9 - psql -c 'CREATE USER myuser' 370s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 370s ok 11 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 370s ok 12 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 370s # create directory 370s ok 13 - pg_backupcluster 16 main createdirectory 370s ok 14 - /var/backups/postgresql/16-main owned by uid postgres 370s ok 15 - /var/backups/postgresql/16-main owned by gid postgres 370s # dump 371s ok 16 - systemctl start pg_dump@16-main 371s ok 17 - dump created in /var/backups/postgresql/16-main/2025-04-25T123407Z.dump 371s ok 18 - /var/backups/postgresql/16-main/2025-04-25T123407Z.dump owned by uid postgres 371s ok 19 - /var/backups/postgresql/16-main/2025-04-25T123407Z.dump owned by gid postgres 371s # basebackup 371s ok 20 - systemctl start pg_receivewal@16-main 371s ok 21 - psql -c 'create table poke_receivewal (t text)' mydb 371s ok 22 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 561s ok 23 - systemctl start pg_basebackup@16-main 561s ok 24 - dump created in /var/backups/postgresql/16-main/2025-04-25T123408Z.backup 561s ok 25 - /var/backups/postgresql/16-main/2025-04-25T123408Z.backup owned by uid postgres 561s ok 26 - /var/backups/postgresql/16-main/2025-04-25T123408Z.backup owned by gid postgres 561s # list 562s ok 27 - pg_backupcluster 16 main list 562s ok 28 - correct output of pg_backupcluster 16 main list 562s # more database changes 562s ok 29 - psql -c "insert into foo values ('data later deleted')" mydb 562s ok 30 - psql -c "insert into foo values ('data from archive')" mydb 562s ok 31 - retrieve recovery timestamp 562s ok 32 - psql -c "delete from foo where t = 'data later deleted'" mydb 562s ok 33 - systemctl stop pg_receivewal@16-main 562s # restore /var/backups/postgresql/16-main/2025-04-25T123407Z.dump 564s ok 34 - pg_dropcluster 16 main --stop 568s ok 35 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123407Z.dump --start --datadir /var/lib/postgresql/16/snowflake 568s ok 36 - pg_lsclusters -h 568s ok 37 - correct output of pg_lsclusters -h 569s ok 38 - psql -XAtl 569s ok 39 - mydb locales 569s ok 40 - myicudb locales 569s ok 41 - psql -XAtc 'show work_mem' 569s ok 42 - correct output of psql -XAtc 'show work_mem' 569s ok 43 - psql -XAtc 'select * from foo' mydb 569s ok 44 - correct output of psql -XAtc 'select * from foo' mydb 569s ok 45 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 569s ok 46 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 569s ok 47 - psql -XAtc '\drds' 569s ok 48 - correct output of psql -XAtc '\drds' 569s # restore /var/backups/postgresql/16-main/2025-04-25T123408Z.backup 572s ok 49 - pg_dropcluster 16 main --stop 575s ok 50 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123408Z.backup --start --datadir /var/lib/postgresql/16/snowflake 575s ok 51 - pg_lsclusters -h 575s ok 52 - correct output of pg_lsclusters -h 575s ok 53 - psql -XAtl 575s ok 54 - mydb locales 575s ok 55 - myicudb locales 575s ok 56 - psql -XAtc 'show work_mem' 575s ok 57 - correct output of psql -XAtc 'show work_mem' 575s ok 58 - psql -XAtc 'select * from foo' mydb 575s ok 59 - correct output of psql -XAtc 'select * from foo' mydb 575s ok 60 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 575s ok 61 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 575s ok 62 - psql -XAtc '\drds' 575s ok 63 - correct output of psql -XAtc '\drds' 575s # restore /var/backups/postgresql/16-main/2025-04-25T123408Z.backup with WAL archive 577s ok 64 - pg_dropcluster 16 main --stop 580s ok 65 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123408Z.backup --start --archive --port 5430 580s ok 66 - pg_lsclusters -h 580s ok 67 - correct output of pg_lsclusters -h 580s ok 68 - psql -XAtc 'select * from foo order by t' mydb 580s ok 69 - correct output of psql -XAtc 'select * from foo order by t' mydb 580s # restore /var/backups/postgresql/16-main/2025-04-25T123408Z.backup with PITR 582s ok 70 - pg_dropcluster 16 main --stop 585s ok 71 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123408Z.backup --start --pitr '2025-04-25 12:37:19.208466+00 585s # ' 585s ok 72 - pg_lsclusters -h 585s ok 73 - correct output of pg_lsclusters -h 585s ok 74 - psql -XAtc 'select * from foo order by t' mydb 585s ok 75 - correct output of psql -XAtc 'select * from foo order by t' mydb 587s ok 76 - pg_dropcluster 16 main --stop 587s # Cleanup 587s ok 77 - Cleanup: No clusters left behind 587s ok 78 - No postgres processes left behind 587s ok 79 - No files in /etc/postgresql left behind 587s ok 80 - No files in /var/lib/postgresql left behind 587s ok 81 - No files in /var/run/postgresql left behind 587s ok 82 - No files in /var/log/postgresql left behind 587s ok 83 - PostgreSQL TCP ports are closed 587s ok 84 - Next free port is 5432 587s 1..84 587s ### End test 045_backup.t ### 587s 587s ### PostgreSQL test 050_encodings.t ### 587s 1..60 587s # Checking 16 ru_RU 590s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 592s ok 2 - psql -l succeeds 592s ok 3 - template1 is not UTF-8 encoded 592s ok 4 - creating test database 592s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 592s # create table t (x varchar); copy t from stdin" test 592s ok 6 - creating table with ISO-8859-5 characters 592s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 592s ok 8 - correct string in UTF-8 592s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 592s ok 10 - correct string in ISO-8859-5 592s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 592s # delete from t; copy t from stdin" test 592s ok 12 - creating table with UTF-8 characters 592s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 592s ok 14 - correct string in UTF-8 592s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 592s ok 16 - correct string in ISO-8859-1 592s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 592s ok 18 - Server error message has correct language and encoding 594s ok 19 - pg_ctlcluster 16 ru_RU restart 594s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 595s ok 21 - Dropping cluster 595s # Checking 16 ru_RU.UTF-8 599s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 600s ok 23 - psql -l succeeds 600s ok 24 - template1 is UTF-8 encoded 600s ok 25 - creating test database 600s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 600s # create table t (x varchar); copy t from stdin" test 600s ok 27 - creating table with ISO-8859-5 characters 600s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 600s ok 29 - correct string in UTF-8 600s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 600s ok 31 - correct string in ISO-8859-5 600s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 600s # delete from t; copy t from stdin" test 600s ok 33 - creating table with UTF-8 characters 600s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 600s ok 35 - correct string in UTF-8 600s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 600s ok 37 - correct string in ISO-8859-1 600s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 600s ok 39 - Server error message has correct language and encoding 603s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 603s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 603s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 603s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 603s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 603s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 603s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 603s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 604s ok 48 - Dropping cluster 604s # Check 16 locale environment variables 608s ok 49 - pg_createcluster: LC_ALL dominates LANG 608s ok 50 - psql -Atl --cluster 16/main 608s ok 51 - template1 is ASCII encoded 609s ok 52 - Dropping cluster 609s # Cleanup 609s ok 53 - Cleanup: No clusters left behind 609s ok 54 - No postgres processes left behind 609s ok 55 - No files in /etc/postgresql left behind 609s ok 56 - No files in /var/lib/postgresql left behind 609s ok 57 - No files in /var/run/postgresql left behind 609s ok 58 - No files in /var/log/postgresql left behind 609s ok 59 - PostgreSQL TCP ports are closed 609s ok 60 - Next free port is 5432 609s ### End test 050_encodings.t ### 609s 609s ### PostgreSQL test 052_upgrade_encodings.t ### 609s 1..1 609s ok 1 - only one major version installed, skipping upgrade tests 609s ### End test 052_upgrade_encodings.t ### 609s 609s ### PostgreSQL test 060_obsolete_confparams.t ### 609s ok 1 - only one major version installed, skipping upgrade tests 609s 1..1 609s ### End test 060_obsolete_confparams.t ### 609s 609s ### PostgreSQL test 070_non_postgres_clusters.t ### 609s 1..40 610s ok 1 - pg_createcluster 16 main for owner nobody 610s ok 2 - pg_ctlcluster 16 main start 610s ok 3 - start refused when config and data owners mismatch 612s ok 4 - pg_ctlcluster succeeds with owner nobody 613s ok 5 - pg_lsclusters -h 613s ok 6 - pg_lsclusters shows running cluster 613s ok 7 - postgres is running as user nobody 613s ok 8 - ls /tmp/.s.PGSQL.* 613s ok 9 - socket is in /tmp 613s ok 10 - /var/run/postgresql is empty 613s ok 11 - conf dir is owned by user 613s ok 12 - conf dir is owned by user's primary group 613s ok 13 - files are owned by user 613s ok 14 - files are owned by user's primary group 613s ok 15 - log file has 0640 permissions 613s ok 16 - log file is owned by user 613s ok 17 - log file is owned by user's primary group 613s ok 18 - only one major version installed, skipping upgrade test 613s ok 19 - ... 613s ok 20 - ... 613s ok 21 - ... 613s ok 22 - ... 613s ok 23 - ... 613s ok 24 - ... 613s ok 25 - ... 613s ok 26 - ... 613s ok 27 - ... 613s ok 28 - ... 614s ok 29 - pg_dropcluster 614s ok 30 - pg_lsclusters -h 614s ok 31 - No clusters left 614s ok 32 - No postgres processes left 614s # Cleanup 614s ok 33 - Cleanup: No clusters left behind 614s ok 34 - No postgres processes left behind 614s ok 35 - No files in /etc/postgresql left behind 614s ok 36 - No files in /var/lib/postgresql left behind 614s ok 37 - No files in /var/run/postgresql left behind 614s ok 38 - No files in /var/log/postgresql left behind 614s ok 39 - PostgreSQL TCP ports are closed 614s ok 40 - Next free port is 5432 614s ### End test 070_non_postgres_clusters.t ### 614s 614s ### PostgreSQL test 080_start.conf.t ### 614s 1..73 615s ok 1 - pg_createcluster 16 main 615s # start.conf auto 615s ok 2 - get_cluster_start_conf returns auto 615s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 615s ok 4 - start.conf contains auto 615s ok 5 - systemd generator links cluster 615s ok 6 - systemd generator links correct service file 617s ok 7 - /etc/init.d/postgresql start 16 617s ok 8 - correct output of /etc/init.d/postgresql start 16 617s ok 9 - pg_lsclusters -h 617s ok 10 - cluster is online 617s ok 11 - /etc/init.d/postgresql stop 16 617s ok 12 - correct output of /etc/init.d/postgresql stop 16 620s ok 13 - pg_lsclusters -h 620s ok 14 - cluster is down 620s # start.conf manual 620s ok 15 - get_cluster_start_conf returns manual 620s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 620s ok 17 - start.conf contains manual 621s ok 18 - systemd generator doesn't link cluster 621s ok 19 - /etc/init.d/postgresql start 16 621s ok 20 - correct output of /etc/init.d/postgresql start 16 621s ok 21 - pg_lsclusters -h 621s ok 22 - cluster is down 623s ok 23 - pg_ctlcluster 16 main start 623s ok 24 - correct output of pg_ctlcluster 16 main start 623s ok 25 - pg_lsclusters -h 623s ok 26 - cluster is online 623s ok 27 - pg_ctlcluster 16 main stop 623s ok 28 - correct output of pg_ctlcluster 16 main stop 623s ok 29 - pg_lsclusters -h 623s ok 30 - cluster is down 623s # start.conf disabled 623s ok 31 - get_cluster_start_conf returns disabled 623s ok 32 - systemd generator doesn't link cluster 623s ok 33 - /etc/init.d/postgresql start 16 623s ok 34 - correct output of /etc/init.d/postgresql start 16 624s ok 35 - pg_lsclusters -h 624s ok 36 - cluster is down 624s ok 37 - pg_ctlcluster 16 main start 624s ok 38 - correct output of pg_ctlcluster 16 main start 624s ok 39 - pg_lsclusters -h 624s ok 40 - cluster is down 626s ok 41 - pg_ctlcluster 16 main start 626s ok 42 - correct output of pg_ctlcluster 16 main start 626s ok 43 - pg_lsclusters -h 626s ok 44 - cluster is online 626s ok 45 - pg_ctlcluster 16 main stop 626s ok 46 - correct output of pg_ctlcluster 16 main stop 626s ok 47 - pg_lsclusters -h 626s ok 48 - cluster is down 628s ok 49 - pg_ctlcluster 16 main start 628s ok 50 - correct output of pg_ctlcluster 16 main start 628s ok 51 - pg_lsclusters -h 628s ok 52 - cluster is online 628s # test upgrade 628s ok 53 - only one major version installed, skipping upgrade test 628s ok 54 - ... 628s ok 55 - get_cluster_start_conf for old cluster returns manual 628s ok 56 - get_cluster_start_conf for new cluster returns manual 628s ok 57 - ... 629s ok 58 - dropping upgraded cluster 630s ok 59 - pg_lsclusters -h 630s ok 60 - no clusters any more 630s ok 61 - pg_createcluster 16 main --start-conf foo 630s ok 62 - pg_createcluster checks --start-conf validity 630s ok 63 - pg_createcluster checks --start-conf manual 630s ok 64 - get_cluster_start_conf returns manual 632s ok 65 - dropping cluster 632s # Cleanup 632s ok 66 - Cleanup: No clusters left behind 632s ok 67 - No postgres processes left behind 632s ok 68 - No files in /etc/postgresql left behind 632s ok 69 - No files in /var/lib/postgresql left behind 632s ok 70 - No files in /var/run/postgresql left behind 632s ok 71 - No files in /var/log/postgresql left behind 632s ok 72 - PostgreSQL TCP ports are closed 632s ok 73 - Next free port is 5432 632s ### End test 080_start.conf.t ### 632s 632s ### PostgreSQL test 085_pg_ctl.conf.t ### 632s 1..33 632s ok 1 - prlimit --core=0:unlimited --pid=16422 632s ok 2 - set core file size to unlimited 632s ok 3 - sh -c 'ulimit -Hc' 632s ok 4 - core file size is unlimited 633s ok 5 - pg_createcluster 16 main 633s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 635s ok 7 - pg_ctlcluster 16 main start 635s ok 8 - starting cluster as root 635s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 635s ok 10 - soft core size is 0 635s # hard core file size limit of root-started postgres process is unlimited 635s ok 11 - set pg_ctl default option to -c 637s ok 12 - pg_ctlcluster 16 main restart 637s ok 13 - restarting cluster as root 637s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 637s ok 15 - soft core size is unlimited 638s ok 16 - pg_ctlcluster 16 main stop 638s ok 17 - stopping cluster 638s ok 18 - restored pg_ctl default option 640s ok 19 - pg_ctlcluster 16 main start -- -c 640s ok 20 - starting cluster with -c on the command line as postgres 640s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 640s ok 22 - soft core size is unlimited 640s ok 23 - pg_ctlcluster 16 main stop 640s ok 24 - stopping cluster 641s ok 25 - dropping cluster 641s # Cleanup 641s ok 26 - Cleanup: No clusters left behind 641s ok 27 - No postgres processes left behind 641s ok 28 - No files in /etc/postgresql left behind 641s ok 29 - No files in /var/lib/postgresql left behind 641s ok 30 - No files in /var/run/postgresql left behind 641s ok 31 - No files in /var/log/postgresql left behind 641s ok 32 - PostgreSQL TCP ports are closed 641s ok 33 - Next free port is 5432 641s ### End test 085_pg_ctl.conf.t ### 641s 641s ### PostgreSQL test 090_multicluster.t ### 641s 1..125 642s ok 1 - pg_createcluster 16 old 643s ok 2 - pg_createcluster 16 new1 644s ok 3 - pg_createcluster 16 new2 647s ok 4 - starting cluster 16/old 649s ok 5 - starting cluster 16/new1 651s ok 6 - starting cluster 16/new2 651s ok 7 - pg_lsclusters -h | sort -k3 651s ok 8 - clusters have the correct ports, skipping used 5433 651s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 651s ok 10 - createdb --version 651s ok 11 - pg_wrapper selects port 5432 as default cluster 651s ok 12 - createdb --cluster 16/new1 --version 651s ok 13 - pg_wrapper --cluster works 651s ok 14 - createdb --cluster 16/foo --version 651s ok 15 - pg_wrapper --cluster errors out for invalid cluster 651s ok 16 - createdb --cluster 16/new1 test 651s ok 17 - correct output of createdb --cluster 16/new1 test 651s ok 18 - psql -Atl --cluster 16/new1 651s ok 19 - test db appears in cluster new1 651s ok 20 - psql -Atl --cluster 16/new2 651s ok 21 - test db does not appear in cluster new2 651s ok 22 - psql -Atl 651s ok 23 - test db does not appear in default cluster 651s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 651s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 652s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 652s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 652s ok 28 - psql -Atl --cluster 16/localhost:5434 652s ok 29 - test db appears in cluster 16/localhost:5434 652s ok 30 - psql -Atl --cluster 16/localhost:5440 652s ok 31 - test db does not appear in cluster 16/localhost:5440 652s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 652s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 652s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 652s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 652s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 652s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 652s ok 38 - psql -Atl --cluster 6.4/localhost: 652s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 652s ok 40 - psql -Atl 652s ok 41 - PGCLUSTER selection (1) 652s ok 42 - psql -Atl 652s ok 43 - PGCLUSTER selection (2) 652s ok 44 - psql -l 652s ok 45 - invalid PGCLUSTER value 652s ok 46 - createdb --version 652s ok 47 - PGCLUSTER network cluster selection (1) 652s ok 48 - psql -Atl 652s ok 49 - PGCLUSTER network cluster selection (2) 652s ok 50 - psql -Atl 652s ok 51 - PGCLUSTER network cluster selection (3) 652s ok 52 - LC_MESSAGES=C psql -Atl 652s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 652s ok 54 - psql -Atc "show port" template1 652s ok 55 - PGPORT selection (1) 652s ok 56 - psql -Atc "show port" template1 652s ok 57 - PGPORT selection (2) 652s ok 58 - createdb --version 652s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 652s ok 60 - psql -Atc "show port" template1 652s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 652s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 652s ok 63 - PGDATABASE environment variable works 652s ok 64 - createdb --version 652s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 652s ok 66 - createdb --cluster 16/new1 --version 652s ok 67 - pg_wrapper --cluster works with empty user_clusters 652s ok 68 - createdb --version 652s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 652s ok 70 - psql -Atc "select current_database()" 652s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 652s ok 72 - psql -Atc 'select current_database()' 652s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 653s ok 74 - createdb --version 653s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 653s ok 76 - createdb --version 653s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 653s ok 78 - createdb --version 653s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 653s ok 80 - createdb --version 653s ok 81 - pg_wrapper selects correct version with per-user user_clusters 653s ok 82 - createdb --version 653s ok 83 - pg_wrapper selects correct version with per-user user_clusters 653s ok 84 - createdb --version 653s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 653s ok 86 - psql -Atl 653s ok 87 - $PGHOST overrides user_clusters 653s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 653s ok 89 - --cluster overrides $PGHOST 653s ok 90 - createdb --version 653s ok 91 - pg_wrapper ignores invalid lines in user_clusters 653s ok 92 - psql -Atc 'select current_database()' 653s ok 93 - pg_service conf selection 1 653s ok 94 - psql -Atc 'select current_database()' 653s ok 95 - pg_service conf selection 2 653s ok 96 - psql -Atc 'select current_database()' 653s ok 97 - pg_service conf selection 3 653s ok 98 - stopping cluster 16/old 655s ok 99 - restarting cluster 16/old 656s ok 100 - pg_lsclusters -h | sort -k3 656s ok 101 - port of first cluster was successfully changed 656s ok 102 - psql -l 656s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 656s ok 104 - psql -Atl --cluster 16/new1 656s ok 105 - --cluster selects appropriate cluster 656s ok 106 - psql -Atl -p 5434 656s ok 107 - -p selects appropriate cluster 658s ok 108 - psql -Atlp 5434 658s ok 109 - -Atlp selects appropriate cluster 658s ok 110 - psql -Atl --port 5434 658s ok 111 - --port selects appropriate cluster 658s ok 112 - env PGPORT=5434 psql -Atl 658s ok 113 - $PGPORT selects appropriate cluster 658s ok 114 - Restoring original /etc/postgresql-common/user_clusters 658s ok 115 - dropping 16/new1 659s ok 116 - dropping 16/new2 661s ok 117 - dropping 16/old 661s # Cleanup 661s ok 118 - Cleanup: No clusters left behind 661s ok 119 - No postgres processes left behind 661s ok 120 - No files in /etc/postgresql left behind 661s ok 121 - No files in /var/lib/postgresql left behind 661s ok 122 - No files in /var/run/postgresql left behind 661s ok 123 - No files in /var/log/postgresql left behind 661s ok 124 - PostgreSQL TCP ports are closed 661s ok 125 - Next free port is 5432 661s ### End test 090_multicluster.t ### 661s 661s ### PostgreSQL test 110_integrate_cluster.t ### 661s 1..32 662s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/XOK1wCGY8Y/c/postgres 662s ok 2 - creating raw initdb cluster for user postgres 662s ok 3 - pg_createcluster 16 postgres -d /tmp/XOK1wCGY8Y/c/postgres 662s ok 4 - integrating postgres cluster 662s ok 5 - pg_lsclusters 662s ok 6 - correct pg_lsclusters output 664s ok 7 - pg_ctlcluster 16 postgres start 664s ok 8 - starting cluster postgres 664s ok 9 - pg_lsclusters 664s ok 10 - correct pg_lsclusters output 666s ok 11 - dropping cluster postgres 666s ok 12 - No files in temporary cluster dir left behind 666s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/XOK1wCGY8Y/c/nobody 666s ok 14 - creating raw initdb cluster for user nobody 667s ok 15 - pg_createcluster 16 nobody -d /tmp/XOK1wCGY8Y/c/nobody 667s ok 16 - integrating nobody cluster 667s ok 17 - pg_lsclusters 667s ok 18 - correct pg_lsclusters output 669s ok 19 - pg_ctlcluster 16 nobody start 669s ok 20 - starting cluster nobody 669s ok 21 - pg_lsclusters 669s ok 22 - correct pg_lsclusters output 671s ok 23 - dropping cluster nobody 671s ok 24 - No files in temporary cluster dir left behind 671s # Cleanup 671s ok 25 - Cleanup: No clusters left behind 671s ok 26 - No postgres processes left behind 671s ok 27 - No files in /etc/postgresql left behind 671s ok 28 - No files in /var/lib/postgresql left behind 671s ok 29 - No files in /var/run/postgresql left behind 671s ok 30 - No files in /var/log/postgresql left behind 671s ok 31 - PostgreSQL TCP ports are closed 671s ok 32 - Next free port is 5432 671s ### End test 110_integrate_cluster.t ### 671s 671s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 671s 1..1 671s ok 1 - only one major version installed, skipping upgrade tests 671s ### End test 120_pg_upgradecluster_scripts.t ### 671s 671s ### PostgreSQL test 130_nonroot_admin.t ### 671s 1..22 674s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 674s ok 2 - pg_lsclusters -h 674s ok 3 - correct output of pg_lsclusters -h 674s ok 4 - psql -Atl 674s ok 5 - correct output of psql -Atl 674s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 674s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 674s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 674s # Cleanup 674s ok 15 - Cleanup: No clusters left behind 674s ok 16 - No postgres processes left behind 674s ok 17 - No files in /etc/postgresql left behind 674s ok 18 - No files in /var/lib/postgresql left behind 674s ok 19 - No files in /var/run/postgresql left behind 674s ok 20 - No files in /var/log/postgresql left behind 674s ok 21 - PostgreSQL TCP ports are closed 674s ok 22 - Next free port is 5432 674s ### End test 130_nonroot_admin.t ### 674s 674s ### PostgreSQL test 135_pg_virtualenv.t ### 674s 1..20 679s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 679s ok 2 - running pg_virtualenv as root 682s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 682s ok 4 - running pg_virtualenv as postgres 685s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 685s ok 6 - running pg_virtualenv as nobody 689s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 689s ok 8 - running fakeroot pg_virtualenv as root 692s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 692s ok 10 - running fakeroot pg_virtualenv as postgres 695s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 695s ok 12 - running fakeroot pg_virtualenv as nobody 695s # Cleanup 695s ok 13 - Cleanup: No clusters left behind 695s ok 14 - No postgres processes left behind 695s ok 15 - No files in /etc/postgresql left behind 695s ok 16 - No files in /var/lib/postgresql left behind 695s ok 17 - No files in /var/run/postgresql left behind 695s ok 18 - No files in /var/log/postgresql left behind 695s ok 19 - PostgreSQL TCP ports are closed 695s ok 20 - Next free port is 5432 695s ### End test 135_pg_virtualenv.t ### 695s 695s ### PostgreSQL test 140_pg_config.t ### 695s 1..38 695s # Multiarch is enabled 695s # checking version specific output for 16 695s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 695s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 695s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 695s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 695s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 695s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 695s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 695s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 695s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 695s # checking pg_config output (should behave like version 16) 695s ok 15 - pg_config 695s ok 16 - correct output of pg_config 695s ok 17 - pg_config --help 695s ok 18 - correct output of pg_config --help 695s ok 19 - pg_config --pgxs 695s ok 20 - correct output of pg_config --pgxs 695s ok 21 - pg_config --libdir 695s ok 22 - correct output of pg_config --libdir 695s ok 23 - pg_config --pkglibdir 695s ok 24 - correct output of pg_config --pkglibdir 695s ok 25 - pg_config --bindir 695s ok 26 - correct output of pg_config --bindir 695s # checking pg_config.libpq-dev output (should behave like version 16) 695s ok 27 - pg_config.libpq-dev 695s ok 28 - correct output of pg_config.libpq-dev 695s ok 29 - pg_config.libpq-dev --help 695s ok 30 - correct output of pg_config.libpq-dev --help 695s ok 31 - pg_config.libpq-dev --pgxs 695s ok 32 - correct output of pg_config.libpq-dev --pgxs 695s ok 33 - pg_config.libpq-dev --libdir 695s ok 34 - correct output of pg_config.libpq-dev --libdir 695s ok 35 - pg_config.libpq-dev --pkglibdir 695s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 695s ok 37 - pg_config.libpq-dev --bindir 695s ok 38 - correct output of pg_config.libpq-dev --bindir 695s ### End test 140_pg_config.t ### 695s 695s ### PostgreSQL test 150_tsearch_stemming.t ### 696s 1..37 696s ok 1 - pg_updatedicts succeeded 696s ok 2 - pg_updatedicts created en_us.affix 696s ok 3 - pg_updatedicts created en_us.dict 696s ok 4 - pg_updatedicts created 16 en_us.affix symlink 696s ok 5 - pg_updatedicts created 16 en_us.dict symlink 699s ok 6 - pg_createcluster 16 main 699s ok 7 - createdb fts 699s ok 8 - correct output of createdb fts 699s ok 9 - creating en_US full text search configuration 699s ok 10 - creating data table and search index 699s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 699s ok 12 - stem search of correct word 699s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 699s ok 14 - stem search of correct word 700s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 700s ok 16 - stem search of unknown word 700s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 700s ok 18 - full text search, exact word 700s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 700s ok 20 - full text search for word stem 700s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 700s ok 22 - full text search for word substring fails 700s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 700s ok 24 - full text search, exact unicode word 700s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 700s ok 26 - full text search for unicode word stem 700s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 700s ok 28 - full text search for unicode word substring fails 701s ok 29 701s # Cleanup 701s ok 30 - Cleanup: No clusters left behind 701s ok 31 - No postgres processes left behind 701s ok 32 - No files in /etc/postgresql left behind 701s ok 33 - No files in /var/lib/postgresql left behind 701s ok 34 - No files in /var/run/postgresql left behind 701s ok 35 - No files in /var/log/postgresql left behind 701s ok 36 - PostgreSQL TCP ports are closed 701s ok 37 - Next free port is 5432 701s ### End test 150_tsearch_stemming.t ### 701s 701s ### PostgreSQL test 160_alternate_confroot.t ### 701s 1..28 704s ok 1 705s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 705s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 705s ok 4 - pg_lsclusters -h 705s ok 5 - correct output of pg_lsclusters -h 705s ok 6 - psql -Atl 705s ok 7 - correct output of psql -Atl 705s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 705s ok 9 - ... 705s ok 10 - ... 705s ok 11 - ... 705s ok 12 - ... 705s ok 13 - ... 705s ok 14 - ... 705s ok 15 - pg_dropcluster 16 test --stop 705s ok 16 - correct output of pg_dropcluster 16 test --stop 705s ok 17 - pg_lsclusters -h 705s ok 18 - correct output of pg_lsclusters -h 705s ok 19 - No files in root/data left behind 705s ok 20 - No cruft in root dir left behind 705s # Cleanup 705s ok 21 - Cleanup: No clusters left behind 705s ok 22 - No postgres processes left behind 705s ok 23 - No files in /etc/postgresql left behind 705s ok 24 - No files in /var/lib/postgresql left behind 705s ok 25 - No files in /var/run/postgresql left behind 705s ok 26 - No files in /var/log/postgresql left behind 705s ok 27 - PostgreSQL TCP ports are closed 705s ok 28 - Next free port is 5432 705s ### End test 160_alternate_confroot.t ### 705s 705s ### PostgreSQL test 170_extensions.t ### 705s # Running tests for 16 708s ok 1 - pg_createcluster 16 main 708s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 708s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 708s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 708s ok 5 - extension adminpack installs without error 708s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 708s ok 7 - extension adminpack removes without error 708s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 708s ok 9 - extension amcheck installs without error 708s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 708s ok 11 - extension amcheck removes without error 709s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 709s ok 13 - extension autoinc installs without error 709s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 709s ok 15 - extension autoinc removes without error 709s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 709s ok 17 - extension bloom installs without error 709s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 709s ok 19 - extension bloom removes without error 709s ok 20 - psql -qc 'CREATE EXTENSION plperl' 709s ok 21 - bool_plperl dependency plperl installs without error 709s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 709s ok 23 - extension bool_plperl installs without error 709s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 709s ok 25 - extension bool_plperl removes without error 709s ok 26 - psql -qc 'DROP EXTENSION plperl' 709s ok 27 - bool_plperl dependency extension plperl removes without error 709s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 709s ok 29 - bool_plperlu dependency plperlu installs without error 709s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 709s ok 31 - extension bool_plperlu installs without error 709s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 709s ok 33 - extension bool_plperlu removes without error 709s ok 34 - psql -qc 'DROP EXTENSION plperlu' 709s ok 35 - bool_plperlu dependency extension plperlu removes without error 709s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 709s ok 37 - extension btree_gin installs without error 709s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 709s ok 39 - extension btree_gin removes without error 709s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 709s ok 41 - extension btree_gist installs without error 709s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 709s ok 43 - extension btree_gist removes without error 709s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 709s ok 45 - extension citext installs without error 709s ok 46 - psql -qc 'DROP EXTENSION "citext"' 709s ok 47 - extension citext removes without error 709s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 709s ok 49 - extension cube installs without error 709s ok 50 - psql -qc 'DROP EXTENSION "cube"' 709s ok 51 - extension cube removes without error 710s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 710s ok 53 - extension dblink installs without error 710s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 710s ok 55 - extension dblink removes without error 710s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 710s ok 57 - extension dict_int installs without error 710s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 710s ok 59 - extension dict_int removes without error 710s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 710s ok 61 - extension dict_xsyn installs without error 710s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 710s ok 63 - extension dict_xsyn removes without error 710s ok 64 - psql -qc 'CREATE EXTENSION cube' 710s ok 65 - earthdistance dependency cube installs without error 710s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 710s ok 67 - extension earthdistance installs without error 710s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 710s ok 69 - extension earthdistance removes without error 710s ok 70 - psql -qc 'DROP EXTENSION cube' 710s ok 71 - earthdistance dependency extension cube removes without error 710s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 710s ok 73 - extension file_fdw installs without error 710s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 710s ok 75 - extension file_fdw removes without error 710s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 710s ok 77 - extension fuzzystrmatch installs without error 710s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 710s ok 79 - extension fuzzystrmatch removes without error 710s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 710s ok 81 - extension hstore installs without error 710s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 710s ok 83 - extension hstore removes without error 710s ok 84 - psql -qc 'CREATE EXTENSION hstore' 710s ok 85 - hstore_plperl dependency hstore installs without error 710s ok 86 - psql -qc 'CREATE EXTENSION plperl' 710s ok 87 - hstore_plperl dependency plperl installs without error 710s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 710s ok 89 - extension hstore_plperl installs without error 710s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 710s ok 91 - extension hstore_plperl removes without error 711s ok 92 - psql -qc 'DROP EXTENSION hstore' 711s ok 93 - hstore_plperl dependency extension hstore removes without error 711s ok 94 - psql -qc 'DROP EXTENSION plperl' 711s ok 95 - hstore_plperl dependency extension plperl removes without error 711s ok 96 - psql -qc 'CREATE EXTENSION hstore' 711s ok 97 - hstore_plperlu dependency hstore installs without error 711s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 711s ok 99 - hstore_plperlu dependency plperlu installs without error 711s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 711s ok 101 - extension hstore_plperlu installs without error 711s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 711s ok 103 - extension hstore_plperlu removes without error 711s ok 104 - psql -qc 'DROP EXTENSION hstore' 711s ok 105 - hstore_plperlu dependency extension hstore removes without error 711s ok 106 - psql -qc 'DROP EXTENSION plperlu' 711s ok 107 - hstore_plperlu dependency extension plperlu removes without error 711s ok 108 - psql -qc 'CREATE EXTENSION hstore' 711s ok 109 - hstore_plpython3u dependency hstore installs without error 711s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 711s ok 111 - hstore_plpython3u dependency plpython3u installs without error 711s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 711s ok 113 - extension hstore_plpython3u installs without error 711s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 711s ok 115 - extension hstore_plpython3u removes without error 711s ok 116 - psql -qc 'DROP EXTENSION hstore' 711s ok 117 - hstore_plpython3u dependency extension hstore removes without error 711s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 711s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 711s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 711s ok 121 - extension insert_username installs without error 711s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 711s ok 123 - extension insert_username removes without error 711s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 711s ok 125 - extension intagg installs without error 711s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 711s ok 127 - extension intagg removes without error 711s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 711s ok 129 - extension intarray installs without error 712s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 712s ok 131 - extension intarray removes without error 712s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 712s ok 133 - extension isn installs without error 712s ok 134 - psql -qc 'DROP EXTENSION "isn"' 712s ok 135 - extension isn removes without error 712s ok 136 - psql -qc 'CREATE EXTENSION plperl' 712s ok 137 - jsonb_plperl dependency plperl installs without error 712s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 712s ok 139 - extension jsonb_plperl installs without error 712s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 712s ok 141 - extension jsonb_plperl removes without error 712s ok 142 - psql -qc 'DROP EXTENSION plperl' 712s ok 143 - jsonb_plperl dependency extension plperl removes without error 712s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 712s ok 145 - jsonb_plperlu dependency plperlu installs without error 712s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 712s ok 147 - extension jsonb_plperlu installs without error 712s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 712s ok 149 - extension jsonb_plperlu removes without error 712s ok 150 - psql -qc 'DROP EXTENSION plperlu' 712s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 712s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 712s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 712s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 712s ok 155 - extension jsonb_plpython3u installs without error 712s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 712s ok 157 - extension jsonb_plpython3u removes without error 712s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 712s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 712s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 712s ok 161 - extension lo installs without error 712s ok 162 - psql -qc 'DROP EXTENSION "lo"' 712s ok 163 - extension lo removes without error 712s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 712s ok 165 - extension ltree installs without error 712s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 712s ok 167 - extension ltree removes without error 713s ok 168 - psql -qc 'CREATE EXTENSION ltree' 713s ok 169 - ltree_plpython3u dependency ltree installs without error 713s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 713s ok 171 - ltree_plpython3u dependency plpython3u installs without error 713s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 713s ok 173 - extension ltree_plpython3u installs without error 713s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 713s ok 175 - extension ltree_plpython3u removes without error 713s ok 176 - psql -qc 'DROP EXTENSION ltree' 713s ok 177 - ltree_plpython3u dependency extension ltree removes without error 713s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 713s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 713s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 713s ok 181 - extension moddatetime installs without error 713s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 713s ok 183 - extension moddatetime removes without error 713s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 713s ok 185 - extension old_snapshot installs without error 713s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 713s ok 187 - extension old_snapshot removes without error 713s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 713s ok 189 - extension pageinspect installs without error 713s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 713s ok 191 - extension pageinspect removes without error 713s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 713s ok 193 - extension pg_buffercache installs without error 713s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 713s ok 195 - extension pg_buffercache removes without error 713s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 713s ok 197 - extension pg_freespacemap installs without error 713s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 713s ok 199 - extension pg_freespacemap removes without error 713s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 713s ok 201 - extension pg_prewarm installs without error 713s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 713s ok 203 - extension pg_prewarm removes without error 713s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 713s ok 205 - extension pg_stat_statements installs without error 713s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 713s ok 207 - extension pg_stat_statements removes without error 714s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 714s ok 209 - extension pg_surgery installs without error 714s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 714s ok 211 - extension pg_surgery removes without error 714s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 714s ok 213 - extension pg_trgm installs without error 714s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 714s ok 215 - extension pg_trgm removes without error 714s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 714s ok 217 - extension pg_visibility installs without error 714s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 714s ok 219 - extension pg_visibility removes without error 714s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 714s ok 221 - extension pg_walinspect installs without error 714s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 714s ok 223 - extension pg_walinspect removes without error 714s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 714s ok 225 - extension pgcrypto installs without error 714s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 714s ok 227 - extension pgcrypto removes without error 714s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 714s ok 229 - extension pgrowlocks installs without error 714s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 714s ok 231 - extension pgrowlocks removes without error 714s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 714s ok 233 - extension pgstattuple installs without error 714s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 714s ok 235 - extension pgstattuple removes without error 714s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 714s ok 237 - extension plperl installs without error 714s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 714s ok 239 - extension plperl removes without error 714s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 714s ok 241 - extension plperlu installs without error 714s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 714s ok 243 - extension plperlu removes without error 714s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 714s ok 245 - extension plpython3u installs without error 714s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 714s ok 247 - extension plpython3u removes without error 715s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 715s ok 249 - extension pltcl installs without error 715s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 715s ok 251 - extension pltcl removes without error 715s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 715s ok 253 - extension pltclu installs without error 715s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 715s ok 255 - extension pltclu removes without error 715s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 715s ok 257 - extension postgres_fdw installs without error 715s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 715s ok 259 - extension postgres_fdw removes without error 715s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 715s ok 261 - extension refint installs without error 715s ok 262 - psql -qc 'DROP EXTENSION "refint"' 715s ok 263 - extension refint removes without error 715s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 715s ok 265 - extension seg installs without error 715s ok 266 - psql -qc 'DROP EXTENSION "seg"' 715s ok 267 - extension seg removes without error 715s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 715s ok 269 - extension sslinfo installs without error 715s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 715s ok 271 - extension sslinfo removes without error 715s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 715s ok 273 - extension tablefunc installs without error 715s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 715s ok 275 - extension tablefunc removes without error 715s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 715s ok 277 - extension tcn installs without error 715s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 715s ok 279 - extension tcn removes without error 715s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 715s ok 281 - extension tsm_system_rows installs without error 715s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 715s ok 283 - extension tsm_system_rows removes without error 715s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 715s ok 285 - extension tsm_system_time installs without error 715s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 715s ok 287 - extension tsm_system_time removes without error 716s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 716s ok 289 - extension unaccent installs without error 716s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 716s ok 291 - extension unaccent removes without error 716s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 716s ok 293 - extension uuid-ossp installs without error 716s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 716s ok 295 - extension uuid-ossp removes without error 716s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 716s ok 297 - extension xml2 installs without error 716s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 716s ok 299 - extension xml2 removes without error 717s ok 300 - pg_dropcluster 16 main 717s # Cleanup 717s ok 301 - Cleanup: No clusters left behind 717s ok 302 - No postgres processes left behind 717s ok 303 - No files in /etc/postgresql left behind 717s ok 304 - No files in /var/lib/postgresql left behind 717s ok 305 - No files in /var/run/postgresql left behind 717s ok 306 - No files in /var/log/postgresql left behind 717s ok 307 - PostgreSQL TCP ports are closed 717s ok 308 - Next free port is 5432 717s 1..308 717s ### End test 170_extensions.t ### 717s 717s ### PostgreSQL test 180_ecpg.t ### 717s 1..14 717s ok 1 - ecpg test.pgc 717s ok 2 - ecpg processing 718s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 718s ok 4 - compiling ecpg output 725s ok 5 - pg_virtualenv /tmp/tmp.n7zI8Xi7HS/test 725s ok 6 - test program runs and gives correct output 725s # Cleanup 725s ok 7 - Cleanup: No clusters left behind 725s ok 8 - No postgres processes left behind 725s ok 9 - No files in /etc/postgresql left behind 725s ok 10 - No files in /var/lib/postgresql left behind 725s ok 11 - No files in /var/run/postgresql left behind 725s ok 12 - No files in /var/log/postgresql left behind 725s ok 13 - PostgreSQL TCP ports are closed 725s ok 14 - Next free port is 5432 725s ### End test 180_ecpg.t ### 725s 725s ### PostgreSQL test 190_pg_buildext.t ### 725s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 725s 1..1 725s ### End test 190_pg_buildext.t ### 725s 725s ### PostgreSQL test 200_maintscripts.t ### 725s 1..15 725s # We are running systemd 728s ok 1 - pg_createcluster 16 main --start 728s ok 2 - postmaster PID is 21436 730s ok 3 - apt-get update -q 730s # postgresql-common: 730s # Installed: 257build1.1 730s # Candidate: 257build1.1 730s # Version table: 730s # *** 257build1.1 500 730s # 500 http://ftpmaster.internal/ubuntu noble-updates/main arm64 Packages 730s # 100 /var/lib/dpkg/status 730s # 257build1 500 730s # 500 http://ftpmaster.internal/ubuntu noble/main arm64 Packages 734s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 734s # postgresql-common: 734s # Installed: 257build1.1 734s # Candidate: 257build1.1 734s # Version table: 734s # *** 257build1.1 500 734s # 500 http://ftpmaster.internal/ubuntu noble-updates/main arm64 Packages 734s # 100 /var/lib/dpkg/status 734s # 257build1 500 734s # 500 http://ftpmaster.internal/ubuntu noble/main arm64 Packages 734s ok 5 - postmaster PID is 21436 734s ok 6 - postmaster was not restarted 735s ok 7 - pg_dropcluster 16 main --stop 735s # Cleanup 735s ok 8 - Cleanup: No clusters left behind 735s ok 9 - No postgres processes left behind 735s ok 10 - No files in /etc/postgresql left behind 735s ok 11 - No files in /var/lib/postgresql left behind 735s ok 12 - No files in /var/run/postgresql left behind 735s ok 13 - No files in /var/log/postgresql left behind 735s ok 14 - PostgreSQL TCP ports are closed 735s ok 15 - Next free port is 5432 735s ### End test 200_maintscripts.t ### 735s 736s autopkgtest [12:40:13]: test run-testsuite: -----------------------] 736s run-testsuite PASS 736s autopkgtest [12:40:13]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 737s autopkgtest [12:40:14]: test installcheck: preparing testbed 833s autopkgtest [12:41:50]: testbed dpkg architecture: arm64 833s autopkgtest [12:41:50]: testbed apt version: 2.7.14build2 834s autopkgtest [12:41:51]: @@@@@@@@@@@@@@@@@@@@ test bed setup 834s autopkgtest [12:41:51]: testbed release detected to be: noble 835s autopkgtest [12:41:52]: updating testbed package index (apt update) 835s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 835s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 835s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 835s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 835s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [62.8 kB] 835s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6316 B] 835s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [49.2 kB] 835s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [15.8 kB] 835s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 Packages [193 kB] 836s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 c-n-f Metadata [2180 B] 836s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 Packages [341 kB] 836s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted arm64 c-n-f Metadata [116 B] 836s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 Packages [419 kB] 836s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/universe arm64 c-n-f Metadata [5940 B] 836s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 Packages [16.5 kB] 836s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/multiverse arm64 c-n-f Metadata [116 B] 840s Fetched 1377 kB in 1s (1441 kB/s) 841s Reading package lists... 842s autopkgtest [12:41:59]: upgrading testbed (apt dist-upgrade and autopurge) 842s Reading package lists... 843s Building dependency tree... 843s Reading state information... 844s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 844s Starting 2 pkgProblemResolver with broken count: 0 844s Done 845s Entering ResolveByKeep 845s 846s The following packages will be upgraded: 846s tzdata 846s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 846s Need to get 276 kB of archives. 846s After this operation, 0 B of additional disk space will be used. 846s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 tzdata all 2025b-0ubuntu0.24.04.1 [276 kB] 847s Preconfiguring packages ... 847s Fetched 276 kB in 0s (652 kB/s) 847s (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 ... 113204 files and directories currently installed.) 847s Preparing to unpack .../tzdata_2025b-0ubuntu0.24.04.1_all.deb ... 847s Unpacking tzdata (2025b-0ubuntu0.24.04.1) over (2025b-0ubuntu0.24.04) ... 847s Setting up tzdata (2025b-0ubuntu0.24.04.1) ... 848s 848s Current default time zone: 'Etc/UTC' 848s Local time is now: Fri Apr 25 12:42:05 UTC 2025. 848s Universal Time is now: Fri Apr 25 12:42:05 UTC 2025. 848s Run 'dpkg-reconfigure tzdata' if you wish to change it. 848s 848s Reading package lists... 849s Building dependency tree... 849s Reading state information... 850s Starting pkgProblemResolver with broken count: 0 850s Starting 2 pkgProblemResolver with broken count: 0 850s Done 852s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 855s Reading package lists... 855s Building dependency tree... 855s Reading state information... 856s Starting pkgProblemResolver with broken count: 0 856s Starting 2 pkgProblemResolver with broken count: 0 856s Done 858s The following NEW packages will be installed: 858s build-essential clang-17 cpp cpp-13 cpp-13-aarch64-linux-gnu 858s cpp-aarch64-linux-gnu g++ g++-13 g++-13-aarch64-linux-gnu 858s g++-aarch64-linux-gnu gcc gcc-13 gcc-13-aarch64-linux-gnu gcc-13-base 858s gcc-aarch64-linux-gnu icu-devtools libasan8 libatomic1 libcc1-0 858s libclang-common-17-dev libclang-cpp17t64 libclang1-17t64 libecpg-compat3 858s libecpg-dev libecpg6 libffi-dev libgc1 libgcc-13-dev libgomp1 libhwasan0 858s libicu-dev libisl23 libitm1 libjson-perl libllvm17t64 liblsan0 libmpc3 858s libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 858s libssl-dev libstdc++-13-dev libtcl8.6 libtsan2 libubsan1 libxml2-dev 858s libxslt1.1 libz3-4 libz3-dev llvm-17 llvm-17-dev llvm-17-linker-tools 858s llvm-17-runtime llvm-17-tools postgresql-16 postgresql-client-16 858s postgresql-client-common postgresql-common postgresql-doc-16 858s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 858s postgresql-server-dev-16 ssl-cert tzdata-legacy 858s 0 upgraded, 69 newly installed, 0 to remove and 0 not upgraded. 858s Need to get 210 MB of archives. 858s After this operation, 1031 MB of additional disk space will be used. 858s Get:1 http://ftpmaster.internal/ubuntu noble/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 858s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-client-common all 257build1.1 [36.4 kB] 858s Get:3 http://ftpmaster.internal/ubuntu noble/main arm64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 858s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-common all 257build1.1 [161 kB] 858s Get:5 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13-base arm64 13.3.0-6ubuntu2~24.04 [51.5 kB] 858s Get:6 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libisl23 arm64 0.26-3build1.1 [669 kB] 859s Get:7 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libmpc3 arm64 1.3.1-1build1.1 [56.4 kB] 859s Get:8 http://ftpmaster.internal/ubuntu noble-updates/main arm64 cpp-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [9556 kB] 859s Get:9 http://ftpmaster.internal/ubuntu noble-updates/main arm64 cpp-13 arm64 13.3.0-6ubuntu2~24.04 [1036 B] 859s Get:10 http://ftpmaster.internal/ubuntu noble/main arm64 cpp-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [5316 B] 859s Get:11 http://ftpmaster.internal/ubuntu noble/main arm64 cpp arm64 4:13.2.0-7ubuntu1 [22.4 kB] 859s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libcc1-0 arm64 14.2.0-4ubuntu2~24.04 [49.7 kB] 859s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libgomp1 arm64 14.2.0-4ubuntu2~24.04 [145 kB] 859s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libitm1 arm64 14.2.0-4ubuntu2~24.04 [28.1 kB] 859s Get:15 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libatomic1 arm64 14.2.0-4ubuntu2~24.04 [11.6 kB] 859s Get:16 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libasan8 arm64 14.2.0-4ubuntu2~24.04 [2930 kB] 859s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main arm64 liblsan0 arm64 14.2.0-4ubuntu2~24.04 [1289 kB] 859s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libtsan2 arm64 14.2.0-4ubuntu2~24.04 [2696 kB] 859s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libubsan1 arm64 14.2.0-4ubuntu2~24.04 [1157 kB] 859s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libhwasan0 arm64 14.2.0-4ubuntu2~24.04 [1605 kB] 859s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libgcc-13-dev arm64 13.3.0-6ubuntu2~24.04 [2473 kB] 859s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [18.7 MB] 860s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main arm64 gcc-13 arm64 13.3.0-6ubuntu2~24.04 [484 kB] 860s Get:24 http://ftpmaster.internal/ubuntu noble/main arm64 gcc-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [1198 B] 860s Get:25 http://ftpmaster.internal/ubuntu noble/main arm64 gcc arm64 4:13.2.0-7ubuntu1 [5018 B] 860s Get:26 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libstdc++-13-dev arm64 13.3.0-6ubuntu2~24.04 [2397 kB] 860s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main arm64 g++-13-aarch64-linux-gnu arm64 13.3.0-6ubuntu2~24.04 [10.9 MB] 860s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main arm64 g++-13 arm64 13.3.0-6ubuntu2~24.04 [16.0 kB] 860s Get:29 http://ftpmaster.internal/ubuntu noble/main arm64 g++-aarch64-linux-gnu arm64 4:13.2.0-7ubuntu1 [962 B] 860s Get:30 http://ftpmaster.internal/ubuntu noble/main arm64 g++ arm64 4:13.2.0-7ubuntu1 [1082 B] 860s Get:31 http://ftpmaster.internal/ubuntu noble/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 860s Get:32 http://ftpmaster.internal/ubuntu noble/main arm64 libllvm17t64 arm64 1:17.0.6-9ubuntu1 [25.0 MB] 861s Get:33 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang-cpp17t64 arm64 1:17.0.6-9ubuntu1 [12.7 MB] 861s Get:34 http://ftpmaster.internal/ubuntu noble/main arm64 libgc1 arm64 1:8.2.6-1build1 [89.1 kB] 861s Get:35 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 libobjc4 arm64 14.2.0-4ubuntu2~24.04 [45.3 kB] 861s Get:36 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 libobjc-13-dev arm64 13.3.0-6ubuntu2~24.04 [190 kB] 861s Get:37 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang-common-17-dev arm64 1:17.0.6-9ubuntu1 [690 kB] 861s Get:38 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-linker-tools arm64 1:17.0.6-9ubuntu1 [1227 kB] 861s Get:39 http://ftpmaster.internal/ubuntu noble/universe arm64 libclang1-17t64 arm64 1:17.0.6-9ubuntu1 [7142 kB] 861s Get:40 http://ftpmaster.internal/ubuntu noble/universe arm64 clang-17 arm64 1:17.0.6-9ubuntu1 [77.4 kB] 861s Get:41 http://ftpmaster.internal/ubuntu noble-updates/main arm64 icu-devtools arm64 74.2-1ubuntu3.1 [209 kB] 861s Get:42 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpgtypes3 arm64 16.8-0ubuntu0.24.04.1 [44.7 kB] 861s Get:43 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpq5 arm64 16.8-0ubuntu0.24.04.1 [140 kB] 861s Get:44 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg6 arm64 16.8-0ubuntu0.24.04.1 [42.9 kB] 861s Get:45 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg-compat3 arm64 16.8-0ubuntu0.24.04.1 [12.1 kB] 861s Get:46 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libssl-dev arm64 3.0.13-0ubuntu3.5 [2337 kB] 861s Get:47 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libpq-dev arm64 16.8-0ubuntu0.24.04.1 [153 kB] 861s Get:48 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libecpg-dev arm64 16.8-0ubuntu0.24.04.1 [260 kB] 861s Get:49 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libicu-dev arm64 74.2-1ubuntu3.1 [11.9 MB] 862s Get:50 http://ftpmaster.internal/ubuntu noble/main arm64 libncurses-dev arm64 6.4+20240113-1ubuntu2 [385 kB] 862s Get:51 http://ftpmaster.internal/ubuntu noble/main arm64 libtcl8.6 arm64 8.6.14+dfsg-1build1 [978 kB] 862s Get:52 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libxml2-dev arm64 2.9.14+dfsg-1.3ubuntu3.2 [798 kB] 862s Get:53 http://ftpmaster.internal/ubuntu noble-updates/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 862s Get:54 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-runtime arm64 1:17.0.6-9ubuntu1 [513 kB] 862s Get:55 http://ftpmaster.internal/ubuntu noble/universe arm64 libpfm4 arm64 4.13.0+git32-g0d4ed0e-1 [59.6 kB] 862s Get:56 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17 arm64 1:17.0.6-9ubuntu1 [22.9 MB] 863s Get:57 http://ftpmaster.internal/ubuntu noble/main arm64 libffi-dev arm64 3.4.6-1build1 [59.5 kB] 863s Get:58 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-tools arm64 1:17.0.6-9ubuntu1 [519 kB] 863s Get:59 http://ftpmaster.internal/ubuntu noble/universe arm64 libz3-4 arm64 4.8.12-3.1build1 [5492 kB] 863s Get:60 http://ftpmaster.internal/ubuntu noble/universe arm64 libz3-dev arm64 4.8.12-3.1build1 [72.2 kB] 863s Get:61 http://ftpmaster.internal/ubuntu noble/universe arm64 llvm-17-dev arm64 1:17.0.6-9ubuntu1 [40.3 MB] 864s Get:62 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-client-16 arm64 16.8-0ubuntu0.24.04.1 [1282 kB] 864s Get:63 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-16 arm64 16.8-0ubuntu0.24.04.1 [15.3 MB] 864s Get:64 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-doc-16 all 16.8-0ubuntu0.24.04.1 [2126 kB] 864s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-plperl-16 arm64 16.8-0ubuntu0.24.04.1 [67.8 kB] 864s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-plpython3-16 arm64 16.8-0ubuntu0.24.04.1 [75.1 kB] 864s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main arm64 postgresql-pltcl-16 arm64 16.8-0ubuntu0.24.04.1 [31.2 kB] 864s Get:68 http://ftpmaster.internal/ubuntu noble-updates/universe arm64 postgresql-server-dev-16 arm64 16.8-0ubuntu0.24.04.1 [1228 kB] 865s Get:69 http://ftpmaster.internal/ubuntu noble-proposed/main arm64 tzdata-legacy all 2025b-0ubuntu0.24.04.1 [94.8 kB] 865s Preconfiguring packages ... 865s Fetched 210 MB in 7s (31.9 MB/s) 865s Selecting previously unselected package libjson-perl. 865s (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 ... 113204 files and directories currently installed.) 865s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 865s Unpacking libjson-perl (4.10000-1) ... 865s Selecting previously unselected package postgresql-client-common. 865s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 865s Unpacking postgresql-client-common (257build1.1) ... 865s Selecting previously unselected package ssl-cert. 866s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 866s Unpacking ssl-cert (1.1.2ubuntu1) ... 866s Selecting previously unselected package postgresql-common. 866s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 866s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 866s Unpacking postgresql-common (257build1.1) ... 866s Selecting previously unselected package gcc-13-base:arm64. 866s Preparing to unpack .../04-gcc-13-base_13.3.0-6ubuntu2~24.04_arm64.deb ... 866s Unpacking gcc-13-base:arm64 (13.3.0-6ubuntu2~24.04) ... 866s Selecting previously unselected package libisl23:arm64. 866s Preparing to unpack .../05-libisl23_0.26-3build1.1_arm64.deb ... 866s Unpacking libisl23:arm64 (0.26-3build1.1) ... 866s Selecting previously unselected package libmpc3:arm64. 866s Preparing to unpack .../06-libmpc3_1.3.1-1build1.1_arm64.deb ... 866s Unpacking libmpc3:arm64 (1.3.1-1build1.1) ... 866s Selecting previously unselected package cpp-13-aarch64-linux-gnu. 866s Preparing to unpack .../07-cpp-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 866s Unpacking cpp-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 866s Selecting previously unselected package cpp-13. 866s Preparing to unpack .../08-cpp-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 866s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 866s Selecting previously unselected package cpp-aarch64-linux-gnu. 866s Preparing to unpack .../09-cpp-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 866s Unpacking cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 866s Selecting previously unselected package cpp. 866s Preparing to unpack .../10-cpp_4%3a13.2.0-7ubuntu1_arm64.deb ... 866s Unpacking cpp (4:13.2.0-7ubuntu1) ... 866s Selecting previously unselected package libcc1-0:arm64. 866s Preparing to unpack .../11-libcc1-0_14.2.0-4ubuntu2~24.04_arm64.deb ... 866s Unpacking libcc1-0:arm64 (14.2.0-4ubuntu2~24.04) ... 866s Selecting previously unselected package libgomp1:arm64. 866s Preparing to unpack .../12-libgomp1_14.2.0-4ubuntu2~24.04_arm64.deb ... 866s Unpacking libgomp1:arm64 (14.2.0-4ubuntu2~24.04) ... 866s Selecting previously unselected package libitm1:arm64. 866s Preparing to unpack .../13-libitm1_14.2.0-4ubuntu2~24.04_arm64.deb ... 866s Unpacking libitm1:arm64 (14.2.0-4ubuntu2~24.04) ... 866s Selecting previously unselected package libatomic1:arm64. 866s Preparing to unpack .../14-libatomic1_14.2.0-4ubuntu2~24.04_arm64.deb ... 866s Unpacking libatomic1:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package libasan8:arm64. 867s Preparing to unpack .../15-libasan8_14.2.0-4ubuntu2~24.04_arm64.deb ... 867s Unpacking libasan8:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package liblsan0:arm64. 867s Preparing to unpack .../16-liblsan0_14.2.0-4ubuntu2~24.04_arm64.deb ... 867s Unpacking liblsan0:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package libtsan2:arm64. 867s Preparing to unpack .../17-libtsan2_14.2.0-4ubuntu2~24.04_arm64.deb ... 867s Unpacking libtsan2:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package libubsan1:arm64. 867s Preparing to unpack .../18-libubsan1_14.2.0-4ubuntu2~24.04_arm64.deb ... 867s Unpacking libubsan1:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package libhwasan0:arm64. 867s Preparing to unpack .../19-libhwasan0_14.2.0-4ubuntu2~24.04_arm64.deb ... 867s Unpacking libhwasan0:arm64 (14.2.0-4ubuntu2~24.04) ... 867s Selecting previously unselected package libgcc-13-dev:arm64. 867s Preparing to unpack .../20-libgcc-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 867s Unpacking libgcc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 867s Selecting previously unselected package gcc-13-aarch64-linux-gnu. 867s Preparing to unpack .../21-gcc-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 867s Unpacking gcc-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 868s Selecting previously unselected package gcc-13. 868s Preparing to unpack .../22-gcc-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 868s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 868s Selecting previously unselected package gcc-aarch64-linux-gnu. 868s Preparing to unpack .../23-gcc-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 868s Unpacking gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 868s Selecting previously unselected package gcc. 868s Preparing to unpack .../24-gcc_4%3a13.2.0-7ubuntu1_arm64.deb ... 868s Unpacking gcc (4:13.2.0-7ubuntu1) ... 868s Selecting previously unselected package libstdc++-13-dev:arm64. 868s Preparing to unpack .../25-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 868s Unpacking libstdc++-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 868s Selecting previously unselected package g++-13-aarch64-linux-gnu. 868s Preparing to unpack .../26-g++-13-aarch64-linux-gnu_13.3.0-6ubuntu2~24.04_arm64.deb ... 868s Unpacking g++-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 868s Selecting previously unselected package g++-13. 868s Preparing to unpack .../27-g++-13_13.3.0-6ubuntu2~24.04_arm64.deb ... 868s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 869s Selecting previously unselected package g++-aarch64-linux-gnu. 869s Preparing to unpack .../28-g++-aarch64-linux-gnu_4%3a13.2.0-7ubuntu1_arm64.deb ... 869s Unpacking g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 869s Selecting previously unselected package g++. 869s Preparing to unpack .../29-g++_4%3a13.2.0-7ubuntu1_arm64.deb ... 869s Unpacking g++ (4:13.2.0-7ubuntu1) ... 869s Selecting previously unselected package build-essential. 869s Preparing to unpack .../30-build-essential_12.10ubuntu1_arm64.deb ... 869s Unpacking build-essential (12.10ubuntu1) ... 869s Selecting previously unselected package libllvm17t64:arm64. 869s Preparing to unpack .../31-libllvm17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 869s Unpacking libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 869s Selecting previously unselected package libclang-cpp17t64. 869s Preparing to unpack .../32-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 869s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 870s Selecting previously unselected package libgc1:arm64. 870s Preparing to unpack .../33-libgc1_1%3a8.2.6-1build1_arm64.deb ... 870s Unpacking libgc1:arm64 (1:8.2.6-1build1) ... 870s Selecting previously unselected package libobjc4:arm64. 870s Preparing to unpack .../34-libobjc4_14.2.0-4ubuntu2~24.04_arm64.deb ... 870s Unpacking libobjc4:arm64 (14.2.0-4ubuntu2~24.04) ... 870s Selecting previously unselected package libobjc-13-dev:arm64. 870s Preparing to unpack .../35-libobjc-13-dev_13.3.0-6ubuntu2~24.04_arm64.deb ... 870s Unpacking libobjc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 870s Selecting previously unselected package libclang-common-17-dev:arm64. 870s Preparing to unpack .../36-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_arm64.deb ... 870s Unpacking libclang-common-17-dev:arm64 (1:17.0.6-9ubuntu1) ... 870s Selecting previously unselected package llvm-17-linker-tools. 870s Preparing to unpack .../37-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_arm64.deb ... 870s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 870s Selecting previously unselected package libclang1-17t64. 870s Preparing to unpack .../38-libclang1-17t64_1%3a17.0.6-9ubuntu1_arm64.deb ... 870s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 871s Selecting previously unselected package clang-17. 871s Preparing to unpack .../39-clang-17_1%3a17.0.6-9ubuntu1_arm64.deb ... 871s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 871s Selecting previously unselected package icu-devtools. 871s Preparing to unpack .../40-icu-devtools_74.2-1ubuntu3.1_arm64.deb ... 871s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 871s Selecting previously unselected package libpgtypes3:arm64. 871s Preparing to unpack .../41-libpgtypes3_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libpgtypes3:arm64 (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libpq5:arm64. 871s Preparing to unpack .../42-libpq5_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libpq5:arm64 (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libecpg6:arm64. 871s Preparing to unpack .../43-libecpg6_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libecpg6:arm64 (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libecpg-compat3:arm64. 871s Preparing to unpack .../44-libecpg-compat3_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libecpg-compat3:arm64 (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libssl-dev:arm64. 871s Preparing to unpack .../45-libssl-dev_3.0.13-0ubuntu3.5_arm64.deb ... 871s Unpacking libssl-dev:arm64 (3.0.13-0ubuntu3.5) ... 871s Selecting previously unselected package libpq-dev. 871s Preparing to unpack .../46-libpq-dev_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libpq-dev (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libecpg-dev. 871s Preparing to unpack .../47-libecpg-dev_16.8-0ubuntu0.24.04.1_arm64.deb ... 871s Unpacking libecpg-dev (16.8-0ubuntu0.24.04.1) ... 871s Selecting previously unselected package libicu-dev:arm64. 871s Preparing to unpack .../48-libicu-dev_74.2-1ubuntu3.1_arm64.deb ... 871s Unpacking libicu-dev:arm64 (74.2-1ubuntu3.1) ... 872s Selecting previously unselected package libncurses-dev:arm64. 872s Preparing to unpack .../49-libncurses-dev_6.4+20240113-1ubuntu2_arm64.deb ... 872s Unpacking libncurses-dev:arm64 (6.4+20240113-1ubuntu2) ... 872s Selecting previously unselected package libtcl8.6:arm64. 872s Preparing to unpack .../50-libtcl8.6_8.6.14+dfsg-1build1_arm64.deb ... 872s Unpacking libtcl8.6:arm64 (8.6.14+dfsg-1build1) ... 872s Selecting previously unselected package libxml2-dev:arm64. 872s Preparing to unpack .../51-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.2_arm64.deb ... 872s Unpacking libxml2-dev:arm64 (2.9.14+dfsg-1.3ubuntu3.2) ... 872s Selecting previously unselected package libxslt1.1:arm64. 872s Preparing to unpack .../52-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_arm64.deb ... 872s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu0.24.04.2) ... 872s Selecting previously unselected package llvm-17-runtime. 872s Preparing to unpack .../53-llvm-17-runtime_1%3a17.0.6-9ubuntu1_arm64.deb ... 872s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 872s Selecting previously unselected package libpfm4:arm64. 872s Preparing to unpack .../54-libpfm4_4.13.0+git32-g0d4ed0e-1_arm64.deb ... 872s Unpacking libpfm4:arm64 (4.13.0+git32-g0d4ed0e-1) ... 872s Selecting previously unselected package llvm-17. 872s Preparing to unpack .../55-llvm-17_1%3a17.0.6-9ubuntu1_arm64.deb ... 872s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 873s Selecting previously unselected package libffi-dev:arm64. 873s Preparing to unpack .../56-libffi-dev_3.4.6-1build1_arm64.deb ... 873s Unpacking libffi-dev:arm64 (3.4.6-1build1) ... 873s Selecting previously unselected package llvm-17-tools. 873s Preparing to unpack .../57-llvm-17-tools_1%3a17.0.6-9ubuntu1_arm64.deb ... 873s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 873s Selecting previously unselected package libz3-4:arm64. 873s Preparing to unpack .../58-libz3-4_4.8.12-3.1build1_arm64.deb ... 873s Unpacking libz3-4:arm64 (4.8.12-3.1build1) ... 874s Selecting previously unselected package libz3-dev:arm64. 874s Preparing to unpack .../59-libz3-dev_4.8.12-3.1build1_arm64.deb ... 874s Unpacking libz3-dev:arm64 (4.8.12-3.1build1) ... 874s Selecting previously unselected package llvm-17-dev. 874s Preparing to unpack .../60-llvm-17-dev_1%3a17.0.6-9ubuntu1_arm64.deb ... 874s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 876s Selecting previously unselected package postgresql-client-16. 876s Preparing to unpack .../61-postgresql-client-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 876s Unpacking postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 876s Selecting previously unselected package postgresql-16. 876s Preparing to unpack .../62-postgresql-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 876s Unpacking postgresql-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package postgresql-doc-16. 877s Preparing to unpack .../63-postgresql-doc-16_16.8-0ubuntu0.24.04.1_all.deb ... 877s Unpacking postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package postgresql-plperl-16. 877s Preparing to unpack .../64-postgresql-plperl-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 877s Unpacking postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package postgresql-plpython3-16. 877s Preparing to unpack .../65-postgresql-plpython3-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 877s Unpacking postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package postgresql-pltcl-16. 877s Preparing to unpack .../66-postgresql-pltcl-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 877s Unpacking postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package postgresql-server-dev-16. 877s Preparing to unpack .../67-postgresql-server-dev-16_16.8-0ubuntu0.24.04.1_arm64.deb ... 877s Unpacking postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 877s Selecting previously unselected package tzdata-legacy. 877s Preparing to unpack .../68-tzdata-legacy_2025b-0ubuntu0.24.04.1_all.deb ... 877s Unpacking tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 877s Setting up postgresql-client-common (257build1.1) ... 877s Setting up libpgtypes3:arm64 (16.8-0ubuntu0.24.04.1) ... 877s Setting up libncurses-dev:arm64 (6.4+20240113-1ubuntu2) ... 877s Setting up postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 878s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 878s Setting up libpq5:arm64 (16.8-0ubuntu0.24.04.1) ... 878s Setting up libgomp1:arm64 (14.2.0-4ubuntu2~24.04) ... 878s Setting up libffi-dev:arm64 (3.4.6-1build1) ... 878s Setting up tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 878s Setting up libz3-4:arm64 (4.8.12-3.1build1) ... 878s Setting up libpfm4:arm64 (4.13.0+git32-g0d4ed0e-1) ... 878s Setting up gcc-13-base:arm64 (13.3.0-6ubuntu2~24.04) ... 878s Setting up libllvm17t64:arm64 (1:17.0.6-9ubuntu1) ... 878s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 878s Setting up ssl-cert (1.1.2ubuntu1) ... 879s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 879s Setting up libssl-dev:arm64 (3.0.13-0ubuntu3.5) ... 879s Setting up libmpc3:arm64 (1.3.1-1build1.1) ... 879s Setting up libatomic1:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libtcl8.6:arm64 (8.6.14+dfsg-1build1) ... 879s Setting up icu-devtools (74.2-1ubuntu3.1) ... 879s Setting up libgc1:arm64 (1:8.2.6-1build1) ... 879s Setting up libubsan1:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 879s Setting up libclang-common-17-dev:arm64 (1:17.0.6-9ubuntu1) ... 879s Setting up libhwasan0:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libasan8:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libjson-perl (4.10000-1) ... 879s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 879s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu0.24.04.2) ... 879s Setting up libecpg6:arm64 (16.8-0ubuntu0.24.04.1) ... 879s Setting up libtsan2:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libisl23:arm64 (0.26-3build1.1) ... 879s Setting up libicu-dev:arm64 (74.2-1ubuntu3.1) ... 879s Setting up libcc1-0:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up liblsan0:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libitm1:arm64 (14.2.0-4ubuntu2~24.04) ... 879s Setting up libz3-dev:arm64 (4.8.12-3.1build1) ... 879s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 879s Setting up libecpg-compat3:arm64 (16.8-0ubuntu0.24.04.1) ... 879s Setting up cpp-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 879s Setting up postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 880s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 880s Setting up libpq-dev (16.8-0ubuntu0.24.04.1) ... 880s Setting up libobjc4:arm64 (14.2.0-4ubuntu2~24.04) ... 880s Setting up libecpg-dev (16.8-0ubuntu0.24.04.1) ... 880s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 880s Setting up cpp-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 880s Setting up libxml2-dev:arm64 (2.9.14+dfsg-1.3ubuntu3.2) ... 880s Setting up postgresql-common (257build1.1) ... 880s 880s Creating config file /etc/postgresql-common/createcluster.conf with new version 881s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 881s Removing obsolete dictionary files: 881s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 882s Setting up libgcc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 882s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 882s Setting up libobjc-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 882s Setting up libstdc++-13-dev:arm64 (13.3.0-6ubuntu2~24.04) ... 882s Setting up postgresql-16 (16.8-0ubuntu0.24.04.1) ... 882s Creating new PostgreSQL cluster 16/main ... 882s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 882s The files belonging to this database system will be owned by user "postgres". 882s This user must also own the server process. 882s 882s The database cluster will be initialized with locale "C.UTF-8". 882s The default database encoding has accordingly been set to "UTF8". 882s The default text search configuration will be set to "english". 882s 882s Data page checksums are disabled. 882s 882s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 882s creating subdirectories ... ok 882s selecting dynamic shared memory implementation ... posix 882s selecting default max_connections ... 100 882s selecting default shared_buffers ... 128MB 882s selecting default time zone ... Etc/UTC 882s creating configuration files ... ok 883s running bootstrap script ... ok 883s performing post-bootstrap initialization ... ok 883s syncing data to disk ... ok 887s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 887s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 887s Setting up gcc-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 888s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 888s Setting up postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 888s Setting up cpp (4:13.2.0-7ubuntu1) ... 888s Setting up postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 888s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 888s Setting up g++-13-aarch64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 888s Setting up gcc-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 888s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 888s Setting up postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 888s Setting up gcc (4:13.2.0-7ubuntu1) ... 888s Setting up postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 888s Setting up g++-aarch64-linux-gnu (4:13.2.0-7ubuntu1) ... 888s Setting up g++ (4:13.2.0-7ubuntu1) ... 888s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 888s Setting up build-essential (12.10ubuntu1) ... 888s Processing triggers for libc-bin (2.39-0ubuntu8.4) ... 888s Processing triggers for systemd (255.4-1ubuntu8.6) ... 888s Processing triggers for man-db (2.12.0-4build2) ... 889s Processing triggers for install-info (7.1-3build2) ... 900s autopkgtest [12:42:57]: test installcheck: [----------------------- 900s + dpkg-parsechangelog -SSource 900s + SOURCE=postgresql-16 900s + MAJOR=16 900s + top_srcdir=/tmp/autopkgtest.gHnoqe/build.MUs/src 900s + cd src/test/regress 900s + make -f /tmp/autopkgtest.gHnoqe/build.MUs/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/16/bin/pg_config with_llvm=no 900s 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 -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -moutline-atomics -g -g -O2 -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -mbranch-protection=standard -fdebug-prefix-map=/build/postgresql-16-peYHEM/postgresql-16-16.8=/usr/src/postgresql-16-16.8-0ubuntu0.24.04.1 -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.gHnoqe/build.MUs/src/debian/tests/ -I/usr/include/postgresql/16/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 901s 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 -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -moutline-atomics -g -g -O2 -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -mbranch-protection=standard -fdebug-prefix-map=/build/postgresql-16-peYHEM/postgresql-16-16.8=/usr/src/postgresql-16-16.8-0ubuntu0.24.04.1 -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/aarch64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-17/lib -Wl,--as-needed -fvisibility=hidden 902s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.gHnoqe/build.MUs/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.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/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/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.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/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/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/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.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/stats.sql sql/stats_ext.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/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.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/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/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.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/matview.out expected/md5.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/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/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/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.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/stats.out expected/stats_ext.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/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 902s + id -u 902s + [ 1000 = 0 ] 902s + SU=sh 902s + sh 902s + mktemp -d /tmp/regress.XXXXXX 902s + OUTPUT=/tmp/regress.s5SYJJ 902s + trap rm -rf /tmp/regress.s5SYJJ EXIT 902s + pg_virtualenv -v 16 /usr/lib/postgresql/16/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.s5SYJJ --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 902s Creating new PostgreSQL cluster 16/regress ... 906s # using postmaster on localhost, port 5433 906s ok 1 - test_setup 266 ms 908s # parallel group (20 tests): varchar char name txid oid text pg_lsn uuid int2 int4 float4 money regproc enum int8 float8 boolean bit numeric rangetypes 908s ok 2 + boolean 1292 ms 908s ok 3 + char 355 ms 908s ok 4 + name 399 ms 908s ok 5 + varchar 320 ms 908s ok 6 + text 520 ms 908s ok 7 + int2 628 ms 908s ok 8 + int4 681 ms 908s ok 9 + int8 868 ms 908s ok 10 + oid 423 ms 908s ok 11 + float4 718 ms 908s ok 12 + float8 867 ms 908s ok 13 + bit 1359 ms 908s ok 14 + numeric 1529 ms 908s ok 15 + txid 404 ms 908s ok 16 + uuid 545 ms 908s ok 17 + enum 838 ms 908s ok 18 + money 705 ms 908s ok 19 + rangetypes 1635 ms 908s ok 20 + pg_lsn 511 ms 908s ok 21 + regproc 704 ms 910s # parallel group (20 tests): md5 lseg path line circle numerology time macaddr timetz macaddr8 inet timestamp date interval point strings timestamptz polygon box multirangetypes 910s ok 22 + strings 1393 ms 910s ok 23 + md5 246 ms 910s ok 24 + numerology 534 ms 910s ok 25 + point 1356 ms 910s ok 26 + lseg 416 ms 910s ok 27 + line 454 ms 910s ok 28 + box 2148 ms 910s ok 29 + path 415 ms 910s ok 30 + polygon 2046 ms 910s ok 31 + circle 519 ms 910s ok 32 + date 1044 ms 910s ok 33 + time 570 ms 910s ok 34 + timetz 639 ms 910s ok 35 + timestamp 916 ms 910s ok 36 + timestamptz 1440 ms 910s ok 37 + interval 1301 ms 910s ok 38 + inet 757 ms 910s ok 39 + macaddr 588 ms 910s ok 40 + macaddr8 638 ms 910s ok 41 + multirangetypes 2228 ms 911s # parallel group (13 tests): misc_sanity comments unicode expressions mvcc xid type_sanity tstypes geometry database opr_sanity horology regex 911s ok 42 + geometry 750 ms 911s ok 43 + horology 1320 ms 911s ok 44 + tstypes 703 ms 911s ok 45 + regex 1366 ms 911s ok 46 + type_sanity 620 ms 911s ok 47 + opr_sanity 1270 ms 911s ok 48 + misc_sanity 213 ms 911s ok 49 + comments 225 ms 911s ok 50 + expressions 406 ms 911s ok 51 + unicode 219 ms 911s ok 52 + xid 470 ms 911s ok 53 + mvcc 433 ms 911s ok 54 + database 1250 ms 912s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 912s ok 55 + copy 300 ms 912s ok 56 + copyselect 158 ms 912s ok 57 + copydml 186 ms 912s ok 58 + insert 702 ms 912s ok 59 + insert_conflict 423 ms 913s # parallel group (7 tests): create_function_c create_operator create_schema create_type create_procedure create_misc create_table 913s ok 60 + create_function_c 101 ms 913s ok 61 + create_misc 293 ms 913s ok 62 + create_operator 197 ms 913s ok 63 + create_procedure 290 ms 913s ok 64 + create_table 719 ms 913s ok 65 + create_type 231 ms 913s ok 66 + create_schema 223 ms 915s # parallel group (5 tests): index_including_gist index_including create_view create_index_spgist create_index 915s ok 67 + create_index 1916 ms 915s ok 68 + create_index_spgist 1773 ms 915s ok 69 + create_view 1035 ms 915s ok 70 + index_including 705 ms 915s ok 71 + index_including_gist 575 ms 918s # parallel group (16 tests): create_cast create_aggregate errors hash_func roleattributes drop_if_exists typed_table infinite_recurse create_am create_function_sql select constraints vacuum updatable_views inherit triggers 918s ok 72 + create_aggregate 526 ms 918s ok 73 + create_function_sql 1344 ms 918s ok 74 + create_cast 354 ms 918s ok 75 + constraints 1525 ms 918s ok 76 + triggers 3248 ms 918s ok 77 + select 1480 ms 918s ok 78 + inherit 2882 ms 918s ok 79 + typed_table 912 ms 918s ok 80 + vacuum 1830 ms 918s ok 81 + drop_if_exists 822 ms 918s ok 82 + updatable_views 2375 ms 918s ok 83 + roleattributes 548 ms 918s ok 84 + create_am 1240 ms 918s ok 85 + hash_func 541 ms 918s ok 86 + errors 538 ms 918s ok 87 + infinite_recurse 1000 ms 918s ok 88 - sanity_check 158 ms 923s # parallel group (20 tests): select_distinct_on delete random select_implicit select_having case namespace select_into prepared_xacts transactions select_distinct portals union subselect hash_index arrays update btree_index aggregates join 923s ok 89 + select_into 807 ms 923s ok 90 + select_distinct 1569 ms 923s ok 91 + select_distinct_on 351 ms 923s ok 92 + select_implicit 603 ms 923s ok 93 + select_having 625 ms 923s ok 94 + subselect 2074 ms 923s ok 95 + union 1707 ms 923s ok 96 + case 630 ms 923s ok 97 + join 4186 ms 923s ok 98 + aggregates 3772 ms 923s ok 99 + transactions 1373 ms 923s ok 100 + random 581 ms 923s ok 101 + portals 1644 ms 923s ok 102 + arrays 2141 ms 923s ok 103 + btree_index 3556 ms 923s ok 104 + hash_index 2061 ms 923s ok 105 + update 3457 ms 923s ok 106 + delete 538 ms 923s ok 107 + namespace 646 ms 923s ok 108 + prepared_xacts 972 ms 935s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock password object_address replica_identity spgist identity matview collate gist generated gin rowsecurity groupingsets join_hash brin privileges 935s ok 109 + brin 11606 ms 935s ok 110 + gin 4828 ms 935s ok 111 + gist 3852 ms 935s ok 112 + spgist 2699 ms 935s ok 113 + privileges 12161 ms 935s ok 114 + init_privs 195 ms 935s ok 115 + security_label 651 ms 935s ok 116 + collate 3498 ms 935s ok 117 + matview 3314 ms 935s ok 118 + lock 1065 ms 935s ok 119 + replica_identity 1703 ms 935s ok 120 + rowsecurity 5065 ms 935s ok 121 + object_address 1336 ms 935s ok 122 + tablesample 945 ms 935s ok 123 + groupingsets 5147 ms 935s ok 124 + drop_operator 471 ms 935s ok 125 + password 1129 ms 935s ok 126 + identity 3113 ms 935s ok 127 + generated 4279 ms 935s ok 128 + join_hash 11561 ms 935s # parallel group (2 tests): brin_bloom brin_multi 935s ok 129 + brin_bloom 111 ms 935s ok 130 + brin_multi 344 ms 938s # parallel group (16 tests): async dbsize alter_operator tidscan tid sysviews tsrf create_role misc_functions alter_generic tidrangescan merge incremental_sort create_table_like misc collate.icu.utf8 938s ok 131 + create_table_like 1824 ms 938s ok 132 + alter_generic 876 ms 938s ok 133 + alter_operator 334 ms 938s ok 134 + misc 2300 ms 938s ok 135 + async 150 ms 938s ok 136 + dbsize 288 ms 938s ok 137 + merge 1504 ms 938s ok 138 + misc_functions 823 ms 938s ok 139 + sysviews 642 ms 938s ok 140 + tsrf 651 ms 938s ok 141 + tid 631 ms 938s ok 142 + tidscan 410 ms 938s ok 143 + tidrangescan 1398 ms 938s ok 144 + collate.icu.utf8 2348 ms 938s ok 145 + incremental_sort 1688 ms 938s ok 146 + create_role 682 ms 939s # parallel group (7 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab rules psql stats_ext 939s ok 147 + rules 1220 ms 939s ok 148 + psql 1290 ms 939s ok 149 + psql_crosstab 191 ms 939s ok 150 + amutils 152 ms 939s ok 151 + stats_ext 1596 ms 939s ok 152 + collate.linux.utf8 95 ms 939s ok 153 + collate.windows.win1252 74 ms 944s ok 154 - select_parallel 5190 ms 945s ok 155 - write_parallel 240 ms 945s ok 156 - vacuum_parallel 145 ms 948s # parallel group (2 tests): subscription publication 948s ok 157 + publication 3185 ms 948s ok 158 + subscription 116 ms 951s # parallel group (17 tests): portals_p2 advisory_lock xmlmap combocid guc equivclass select_views functional_deps dependency tsdicts bitmapops window indirect_toast cluster foreign_data foreign_key tsearch 951s ok 159 + select_views 756 ms 951s ok 160 + portals_p2 395 ms 951s ok 161 + foreign_key 2812 ms 951s ok 162 + cluster 1684 ms 951s ok 163 + dependency 833 ms 951s ok 164 + guc 669 ms 951s ok 165 + bitmapops 1395 ms 951s ok 166 + combocid 650 ms 951s ok 167 + tsearch 3317 ms 951s ok 168 + tsdicts 857 ms 951s ok 169 + foreign_data 2224 ms 951s ok 170 + window 1481 ms 951s ok 171 + xmlmap 597 ms 951s ok 172 + functional_deps 786 ms 951s ok 173 + advisory_lock 470 ms 951s ok 174 + indirect_toast 1516 ms 951s ok 175 + equivclass 721 ms 952s # parallel group (7 tests): json_encoding jsonpath_encoding jsonpath sqljson json jsonb_jsonpath jsonb 952s ok 176 + json 363 ms 952s ok 177 + jsonb 626 ms 952s ok 178 + json_encoding 120 ms 952s ok 179 + jsonpath 173 ms 952s ok 180 + jsonpath_encoding 135 ms 952s ok 181 + jsonb_jsonpath 410 ms 952s ok 182 + sqljson 237 ms 956s # parallel group (18 tests): prepare returning limit plancache conversion temp copy2 sequence largeobject rowtypes polymorphism truncate with domain rangefuncs plpgsql xml alter_table 956s ok 183 + plancache 1062 ms 956s ok 184 + limit 897 ms 956s ok 185 + plpgsql 3307 ms 956s ok 186 + copy2 1985 ms 956s ok 187 + temp 1698 ms 956s ok 188 + domain 2595 ms 956s ok 189 + rangefuncs 2888 ms 956s ok 190 + prepare 455 ms 956s ok 191 + conversion 1202 ms 956s ok 192 + truncate 2237 ms 956s ok 193 + alter_table 4271 ms 956s ok 194 + sequence 2032 ms 956s ok 195 + polymorphism 2185 ms 956s ok 196 + rowtypes 2070 ms 956s ok 197 + returning 842 ms 956s ok 198 + largeobject 2047 ms 956s ok 199 + with 2493 ms 956s ok 200 + xml 3381 ms 961s # parallel group (12 tests): hash_part reloptions explain partition_info compression partition_aggregate tuplesort memoize partition_join indexing stats partition_prune 961s ok 201 + partition_join 3203 ms 961s ok 202 + partition_prune 4201 ms 961s ok 203 + reloptions 362 ms 961s ok 204 + hash_part 295 ms 961s ok 205 + indexing 3214 ms 961s ok 206 + partition_aggregate 2414 ms 961s ok 207 + partition_info 626 ms 961s ok 208 + tuplesort 2776 ms 961s ok 209 + explain 543 ms 961s ok 210 + compression 994 ms 961s ok 211 + memoize 2856 ms 961s ok 212 + stats 3357 ms 961s # parallel group (2 tests): event_trigger oidjoins 961s ok 213 + event_trigger 169 ms 961s ok 214 + oidjoins 274 ms 961s ok 215 - fast_default 188 ms 962s ok 216 - tablespace 408 ms 962s 1..216 962s # All 216 tests passed. 962s Dropping cluster 16/regress ... 962s + rm -rf /tmp/regress.s5SYJJ 962s autopkgtest [12:43:59]: test installcheck: -----------------------] 963s installcheck PASS 963s autopkgtest [12:44:00]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 963s autopkgtest [12:44:00]: @@@@@@@@@@@@@@@@@@@@ summary 963s run-testsuite PASS 963s installcheck PASS 1042s nova [W] Using flock in prodstack6-arm64 1042s flock: timeout while waiting to get lock 1042s Creating nova instance adt-noble-arm64-postgresql-16-20250425-122757-juju-7f2275-prod-proposed-migration-environment-20-4189470e-2940-4c79-aa47-2c44366beaf1 from image adt/ubuntu-noble-arm64-server-20250425.img (UUID dcc9558d-3d79-41f0-8887-f452cca9495d)... 1042s nova [W] Timed out waiting for 60660fc8-8fe4-48ad-89ac-2ff861efcb8a to get deleted. 1042s nova [W] Using flock in prodstack6-arm64 1042s Creating nova instance adt-noble-arm64-postgresql-16-20250425-122757-juju-7f2275-prod-proposed-migration-environment-20-4189470e-2940-4c79-aa47-2c44366beaf1 from image adt/ubuntu-noble-arm64-server-20250425.img (UUID dcc9558d-3d79-41f0-8887-f452cca9495d)... 1042s nova [W] Timed out waiting for c7049bbc-19a5-4b73-bd12-2aa32ea738dd to get deleted.