0s autopkgtest [10:34:39]: starting date and time: 2025-09-24 10:34:39+0000 0s autopkgtest [10:34:39]: git checkout: 4b346b80 nova: make wait_reboot return success even when a no-op 0s autopkgtest [10:34:39]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.nnyk5fdr/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:build-essential --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=build-essential/12.12ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-cpu2-ram4-disk20-amd64 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@sto01-4.secgroup --name adt-questing-amd64-postgresql-17-20250924-103439-juju-7f2275-prod-proposed-migration-environment-15-09b99f8e-6bd4-4ed9-9f98-4838a0a824f6 --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-autopkgtest-workers-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 4s Creating nova instance adt-questing-amd64-postgresql-17-20250924-103439-juju-7f2275-prod-proposed-migration-environment-15-09b99f8e-6bd4-4ed9-9f98-4838a0a824f6 from image adt/ubuntu-questing-amd64-server-20250924.img (UUID f8a6041a-8470-4763-9edd-b0ccb492ef61)... 36s autopkgtest [10:35:15]: testbed dpkg architecture: amd64 36s autopkgtest [10:35:15]: testbed apt version: 3.1.5ubuntu2 37s autopkgtest [10:35:16]: @@@@@@@@@@@@@@@@@@@@ test bed setup 37s autopkgtest [10:35:16]: testbed release detected to be: None 37s autopkgtest [10:35:16]: updating testbed package index (apt update) 38s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [265 kB] 38s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 38s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 38s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 38s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [179 kB] 38s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [33.7 kB] 38s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [5920 B] 38s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [12.5 kB] 38s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [20.7 kB] 38s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [58.5 kB] 38s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 c-n-f Metadata [408 B] 38s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 Packages [43.9 kB] 38s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 c-n-f Metadata [120 B] 38s Get:14 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [146 kB] 38s Get:15 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [65.2 kB] 38s Get:16 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 c-n-f Metadata [8004 B] 38s Get:17 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [4696 B] 38s Get:18 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [2072 B] 38s Get:19 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 c-n-f Metadata [412 B] 39s Fetched 846 kB in 1s (1160 kB/s) 40s Reading package lists... 40s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [265 kB] 40s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 40s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 40s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 40s Fetched 265 kB in 0s (868 kB/s) 41s Reading package lists... 41s Reading package lists... 41s Building dependency tree... 41s Reading state information... 41s Calculating upgrade... 41s The following packages will be upgraded: 41s rust-coreutils 41s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 41s Need to get 3347 kB of archives. 41s After this operation, 48.1 kB of additional disk space will be used. 41s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 rust-coreutils amd64 0.2.2-0ubuntu1 [3347 kB] 42s dpkg-preconfigure: unable to re-open stdin: No such file or directory 42s Fetched 3347 kB in 0s (7078 kB/s) 42s (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 ... 78099 files and directories currently installed.) 42s Preparing to unpack .../rust-coreutils_0.2.2-0ubuntu1_amd64.deb ... 42s Unpacking rust-coreutils (0.2.2-0ubuntu1) over (0.1.0+git20250813.4af2a84-0ubuntu7) ... 42s Setting up rust-coreutils (0.2.2-0ubuntu1) ... 42s Processing triggers for man-db (2.13.1-1) ... 43s autopkgtest [10:35:22]: upgrading testbed (apt dist-upgrade and autopurge) 43s Reading package lists... 43s Building dependency tree... 43s Reading state information... 43s Calculating upgrade... 43s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 43s Reading package lists... 44s Building dependency tree... 44s Reading state information... 44s Solving dependencies... 44s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 46s autopkgtest [10:35:25]: testbed running kernel: Linux 6.17.0-4-generic #4-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 8 16:09:17 UTC 2025 46s autopkgtest [10:35:25]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 52s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.6-1build1 (dsc) [4269 B] 52s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.6-1build1 (tar) [21.6 MB] 52s Get:3 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.6-1build1 (diff) [27.1 kB] 52s gpgv: Signature made Sat Sep 6 15:12:05 2025 UTC 52s gpgv: using RSA key 25E3FF2D7F469DBE7D0D4E50AFCFEC8E669CE1C2 52s gpgv: Can't check signature: No public key 52s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.6-1build1.dsc: no acceptable signature found 57s autopkgtest [10:35:36]: testing package postgresql-17 version 17.6-1build1 58s autopkgtest [10:35:37]: build not needed 65s autopkgtest [10:35:44]: test run-testsuite: preparing testbed 65s Reading package lists... 65s Building dependency tree... 65s Reading state information... 65s Solving dependencies... 65s The following NEW packages will be installed: 65s autoconf automake autopoint autotools-dev build-essential clang-20 cpp 65s cpp-15 cpp-15-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 65s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 65s fakeroot g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu gcc 65s gcc-13-base gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext 65s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libcc1-0 65s libclang-common-20-dev libdebhelper-perl libecpg-compat3 libecpg-dev 65s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 65s libgcc-13-dev libgcc-15-dev libgomp1 libhwasan0 libicu76 libio-pty-perl 65s libipc-run-perl libisl23 libitm1 libjson-perl liblsan0 liblzma-dev libmpc3 65s libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 65s libquadmath0 libssl-dev libstdc++-13-dev libstdc++-15-dev libtcl8.6 libtool 65s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 65s llvm-20-linker-tools llvm-20-runtime llvm-20-tools locales-all m4 po-debconf 65s postgresql-17 postgresql-client-17 postgresql-client-common 65s postgresql-common postgresql-common-dev postgresql-doc-17 65s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 65s postgresql-server-dev-17 ssl-cert zlib1g-dev 65s 0 upgraded, 92 newly installed, 0 to remove and 0 not upgraded. 65s Need to get 206 MB of archives. 65s After this operation, 1197 MB of additional disk space will be used. 65s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 65s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-common all 282 [48.7 kB] 65s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 65s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 65s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common-dev all 282 [73.9 kB] 65s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 65s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common all 282 [101 kB] 65s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 m4 amd64 1.4.19-8 [248 kB] 65s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 65s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 autotools-dev all 20240727.1 [43.4 kB] 65s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 automake all 1:1.17-4ubuntu1 [572 kB] 67s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 autopoint all 0.23.1-2build2 [619 kB] 67s Get:13 http://ftpmaster.internal/ubuntu questing/main amd64 libisl23 amd64 0.27-1 [685 kB] 67s Get:14 http://ftpmaster.internal/ubuntu questing/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 67s Get:15 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [12.9 MB] 68s Get:16 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-15 amd64 15.2.0-4ubuntu4 [1028 B] 68s Get:17 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 68s Get:18 http://ftpmaster.internal/ubuntu questing/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 68s Get:19 http://ftpmaster.internal/ubuntu questing/main amd64 libcc1-0 amd64 15.2.0-4ubuntu4 [47.4 kB] 68s Get:20 http://ftpmaster.internal/ubuntu questing/main amd64 libgomp1 amd64 15.2.0-4ubuntu4 [151 kB] 68s Get:21 http://ftpmaster.internal/ubuntu questing/main amd64 libitm1 amd64 15.2.0-4ubuntu4 [29.3 kB] 68s Get:22 http://ftpmaster.internal/ubuntu questing/main amd64 libasan8 amd64 15.2.0-4ubuntu4 [3071 kB] 68s Get:23 http://ftpmaster.internal/ubuntu questing/main amd64 liblsan0 amd64 15.2.0-4ubuntu4 [1360 kB] 68s Get:24 http://ftpmaster.internal/ubuntu questing/main amd64 libtsan2 amd64 15.2.0-4ubuntu4 [2757 kB] 69s Get:25 http://ftpmaster.internal/ubuntu questing/main amd64 libubsan1 amd64 15.2.0-4ubuntu4 [1210 kB] 69s Get:26 http://ftpmaster.internal/ubuntu questing/main amd64 libhwasan0 amd64 15.2.0-4ubuntu4 [1685 kB] 69s Get:27 http://ftpmaster.internal/ubuntu questing/main amd64 libquadmath0 amd64 15.2.0-4ubuntu4 [153 kB] 69s Get:28 http://ftpmaster.internal/ubuntu questing/main amd64 libgcc-15-dev amd64 15.2.0-4ubuntu4 [2864 kB] 69s Get:29 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [25.4 MB] 69s Get:30 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-15 amd64 15.2.0-4ubuntu4 [521 kB] 69s Get:31 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 69s Get:32 http://ftpmaster.internal/ubuntu questing/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 69s Get:33 http://ftpmaster.internal/ubuntu questing/main amd64 libstdc++-15-dev amd64 15.2.0-4ubuntu4 [2572 kB] 69s Get:34 http://ftpmaster.internal/ubuntu questing/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [14.4 MB] 70s Get:35 http://ftpmaster.internal/ubuntu questing/main amd64 g++-15 amd64 15.2.0-4ubuntu4 [23.3 kB] 70s Get:36 http://ftpmaster.internal/ubuntu questing/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 70s Get:37 http://ftpmaster.internal/ubuntu questing/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 70s Get:38 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 build-essential amd64 12.12ubuntu2 [5256 B] 70s Get:39 http://ftpmaster.internal/ubuntu questing/universe amd64 gcc-13-base amd64 13.4.0-4ubuntu1 [54.7 kB] 70s Get:40 http://ftpmaster.internal/ubuntu questing/universe amd64 libgcc-13-dev amd64 13.4.0-4ubuntu1 [2669 kB] 70s Get:41 http://ftpmaster.internal/ubuntu questing/universe amd64 libstdc++-13-dev amd64 13.4.0-4ubuntu1 [2749 kB] 70s Get:42 http://ftpmaster.internal/ubuntu questing/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 70s Get:43 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc4 amd64 15.2.0-4ubuntu4 [47.8 kB] 70s Get:44 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc-13-dev amd64 13.4.0-4ubuntu1 [194 kB] 70s Get:45 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-common-20-dev amd64 1:20.1.8-0ubuntu4 [778 kB] 70s Get:46 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-linker-tools amd64 1:20.1.8-0ubuntu4 [1332 kB] 70s Get:47 http://ftpmaster.internal/ubuntu questing/universe amd64 clang-20 amd64 1:20.1.8-0ubuntu4 [77.5 kB] 70s Get:48 http://ftpmaster.internal/ubuntu questing/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 70s Get:49 http://ftpmaster.internal/ubuntu questing/main amd64 libtool all 2.5.4-4build1 [169 kB] 70s Get:50 http://ftpmaster.internal/ubuntu questing/main amd64 dh-autoreconf all 20 [16.1 kB] 70s Get:51 http://ftpmaster.internal/ubuntu questing/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 70s Get:52 http://ftpmaster.internal/ubuntu questing/main amd64 libfile-stripnondeterminism-perl all 1.14.2-1 [20.4 kB] 70s Get:53 http://ftpmaster.internal/ubuntu questing/main amd64 dh-strip-nondeterminism all 1.14.2-1 [5098 B] 70s Get:54 http://ftpmaster.internal/ubuntu questing/main amd64 debugedit amd64 1:5.2-3 [49.9 kB] 70s Get:55 http://ftpmaster.internal/ubuntu questing/main amd64 dwz amd64 0.16-2 [115 kB] 70s Get:56 http://ftpmaster.internal/ubuntu questing/main amd64 gettext amd64 0.23.1-2build2 [1043 kB] 70s Get:57 http://ftpmaster.internal/ubuntu questing/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 70s Get:58 http://ftpmaster.internal/ubuntu questing/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 70s Get:59 http://ftpmaster.internal/ubuntu questing/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 70s Get:60 http://ftpmaster.internal/ubuntu questing/main amd64 emacsen-common all 3.0.8 [13.9 kB] 70s Get:61 http://ftpmaster.internal/ubuntu questing/main amd64 dictionaries-common all 1.30.10 [178 kB] 70s Get:62 http://ftpmaster.internal/ubuntu questing/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 70s Get:63 http://ftpmaster.internal/ubuntu questing/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 70s Get:64 http://ftpmaster.internal/ubuntu questing/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 70s Get:65 http://ftpmaster.internal/ubuntu questing/main amd64 libpgtypes3 amd64 17.6-1build1 [46.7 kB] 70s Get:66 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.6-1build1 [150 kB] 70s Get:67 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg6 amd64 17.6-1build1 [45.9 kB] 70s Get:68 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-compat3 amd64 17.6-1build1 [13.1 kB] 70s Get:69 http://ftpmaster.internal/ubuntu questing/main amd64 libssl-dev amd64 3.5.2-1ubuntu1 [3091 kB] 70s Get:70 http://ftpmaster.internal/ubuntu questing/main amd64 libpq-dev amd64 17.6-1build1 [160 kB] 70s Get:71 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-dev amd64 17.6-1build1 [275 kB] 71s Get:72 http://ftpmaster.internal/ubuntu questing/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 71s Get:73 http://ftpmaster.internal/ubuntu questing/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 71s Get:74 http://ftpmaster.internal/ubuntu questing/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 71s Get:75 http://ftpmaster.internal/ubuntu questing/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 71s Get:76 http://ftpmaster.internal/ubuntu questing/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 71s Get:77 http://ftpmaster.internal/ubuntu questing/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2 [757 kB] 71s Get:78 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.43-0.1 [172 kB] 71s Get:79 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-runtime amd64 1:20.1.8-0ubuntu4 [560 kB] 71s Get:80 http://ftpmaster.internal/ubuntu questing/universe amd64 libpfm4 amd64 4.13.0+git99-gc5587f9-1 [437 kB] 71s Get:81 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20 amd64 1:20.1.8-0ubuntu4 [19.7 MB] 71s Get:82 http://ftpmaster.internal/ubuntu questing/main amd64 libffi-dev amd64 3.5.2-1build1 [65.6 kB] 71s Get:83 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-tools amd64 1:20.1.8-0ubuntu4 [512 kB] 72s Get:84 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-dev amd64 1:20.1.8-0ubuntu4 [50.2 MB] 74s Get:85 http://ftpmaster.internal/ubuntu questing/universe amd64 locales-all amd64 2.42-0ubuntu3 [11.2 MB] 74s Get:86 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.6-1build1 [1379 kB] 74s Get:87 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.6-1build1 [16.0 MB] 75s Get:88 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-doc-17 all 17.6-1build1 [2148 kB] 75s Get:89 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plperl-17 amd64 17.6-1build1 [69.2 kB] 75s Get:90 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plpython3-17 amd64 17.6-1build1 [79.5 kB] 75s Get:91 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-pltcl-17 amd64 17.6-1build1 [32.8 kB] 75s Get:92 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-17 amd64 17.6-1build1 [1404 kB] 75s Preconfiguring packages ... 75s Fetched 206 MB in 10s (21.1 MB/s) 75s Selecting previously unselected package libjson-perl. 75s (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 ... 78100 files and directories currently installed.) 75s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 75s Unpacking libjson-perl (4.10000-1) ... 75s Selecting previously unselected package postgresql-client-common. 76s Preparing to unpack .../01-postgresql-client-common_282_all.deb ... 76s Unpacking postgresql-client-common (282) ... 76s Selecting previously unselected package libio-pty-perl. 76s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 76s Unpacking libio-pty-perl (1:1.20-1build3) ... 76s Selecting previously unselected package libipc-run-perl. 76s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 76s Unpacking libipc-run-perl (20231003.0-2) ... 76s Selecting previously unselected package postgresql-common-dev. 76s Preparing to unpack .../04-postgresql-common-dev_282_all.deb ... 76s Unpacking postgresql-common-dev (282) ... 76s Selecting previously unselected package ssl-cert. 76s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 76s Unpacking ssl-cert (1.1.3ubuntu1) ... 76s Selecting previously unselected package postgresql-common. 76s Preparing to unpack .../06-postgresql-common_282_all.deb ... 76s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 76s Unpacking postgresql-common (282) ... 76s Selecting previously unselected package m4. 76s Preparing to unpack .../07-m4_1.4.19-8_amd64.deb ... 76s Unpacking m4 (1.4.19-8) ... 76s Selecting previously unselected package autoconf. 76s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 76s Unpacking autoconf (2.72-3.1ubuntu1) ... 76s Selecting previously unselected package autotools-dev. 76s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 76s Unpacking autotools-dev (20240727.1) ... 76s Selecting previously unselected package automake. 76s Preparing to unpack .../10-automake_1%3a1.17-4ubuntu1_all.deb ... 76s Unpacking automake (1:1.17-4ubuntu1) ... 76s Selecting previously unselected package autopoint. 76s Preparing to unpack .../11-autopoint_0.23.1-2build2_all.deb ... 76s Unpacking autopoint (0.23.1-2build2) ... 76s Selecting previously unselected package libisl23:amd64. 76s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 76s Unpacking libisl23:amd64 (0.27-1) ... 76s Selecting previously unselected package libmpc3:amd64. 76s Preparing to unpack .../13-libmpc3_1.3.1-1build3_amd64.deb ... 76s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 76s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 76s Preparing to unpack .../14-cpp-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package cpp-15. 76s Preparing to unpack .../15-cpp-15_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking cpp-15 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package cpp-x86-64-linux-gnu. 76s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 76s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 76s Selecting previously unselected package cpp. 76s Preparing to unpack .../17-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 76s Unpacking cpp (4:15.2.0-4ubuntu1) ... 76s Selecting previously unselected package libcc1-0:amd64. 76s Preparing to unpack .../18-libcc1-0_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libcc1-0:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libgomp1:amd64. 76s Preparing to unpack .../19-libgomp1_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libgomp1:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libitm1:amd64. 76s Preparing to unpack .../20-libitm1_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libitm1:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libasan8:amd64. 76s Preparing to unpack .../21-libasan8_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libasan8:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package liblsan0:amd64. 76s Preparing to unpack .../22-liblsan0_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking liblsan0:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libtsan2:amd64. 76s Preparing to unpack .../23-libtsan2_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libtsan2:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libubsan1:amd64. 76s Preparing to unpack .../24-libubsan1_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libubsan1:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libhwasan0:amd64. 76s Preparing to unpack .../25-libhwasan0_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libhwasan0:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libquadmath0:amd64. 76s Preparing to unpack .../26-libquadmath0_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libquadmath0:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package libgcc-15-dev:amd64. 76s Preparing to unpack .../27-libgcc-15-dev_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libgcc-15-dev:amd64 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 76s Preparing to unpack .../28-gcc-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package gcc-15. 76s Preparing to unpack .../29-gcc-15_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking gcc-15 (15.2.0-4ubuntu4) ... 76s Selecting previously unselected package gcc-x86-64-linux-gnu. 76s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 76s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 76s Selecting previously unselected package gcc. 76s Preparing to unpack .../31-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 76s Unpacking gcc (4:15.2.0-4ubuntu1) ... 76s Selecting previously unselected package libstdc++-15-dev:amd64. 76s Preparing to unpack .../32-libstdc++-15-dev_15.2.0-4ubuntu4_amd64.deb ... 76s Unpacking libstdc++-15-dev:amd64 (15.2.0-4ubuntu4) ... 77s Selecting previously unselected package g++-15-x86-64-linux-gnu. 77s Preparing to unpack .../33-g++-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 77s Unpacking g++-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 77s Selecting previously unselected package g++-15. 77s Preparing to unpack .../34-g++-15_15.2.0-4ubuntu4_amd64.deb ... 77s Unpacking g++-15 (15.2.0-4ubuntu4) ... 77s Selecting previously unselected package g++-x86-64-linux-gnu. 77s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 77s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 77s Selecting previously unselected package g++. 77s Preparing to unpack .../36-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 77s Unpacking g++ (4:15.2.0-4ubuntu1) ... 77s Selecting previously unselected package build-essential. 77s Preparing to unpack .../37-build-essential_12.12ubuntu2_amd64.deb ... 77s Unpacking build-essential (12.12ubuntu2) ... 77s Selecting previously unselected package gcc-13-base:amd64. 77s Preparing to unpack .../38-gcc-13-base_13.4.0-4ubuntu1_amd64.deb ... 77s Unpacking gcc-13-base:amd64 (13.4.0-4ubuntu1) ... 77s Selecting previously unselected package libgcc-13-dev:amd64. 77s Preparing to unpack .../39-libgcc-13-dev_13.4.0-4ubuntu1_amd64.deb ... 77s Unpacking libgcc-13-dev:amd64 (13.4.0-4ubuntu1) ... 77s Selecting previously unselected package libstdc++-13-dev:amd64. 77s Preparing to unpack .../40-libstdc++-13-dev_13.4.0-4ubuntu1_amd64.deb ... 77s Unpacking libstdc++-13-dev:amd64 (13.4.0-4ubuntu1) ... 77s Selecting previously unselected package libgc1:amd64. 77s Preparing to unpack .../41-libgc1_1%3a8.2.8-1_amd64.deb ... 77s Unpacking libgc1:amd64 (1:8.2.8-1) ... 77s Selecting previously unselected package libobjc4:amd64. 77s Preparing to unpack .../42-libobjc4_15.2.0-4ubuntu4_amd64.deb ... 77s Unpacking libobjc4:amd64 (15.2.0-4ubuntu4) ... 77s Selecting previously unselected package libobjc-13-dev:amd64. 77s Preparing to unpack .../43-libobjc-13-dev_13.4.0-4ubuntu1_amd64.deb ... 77s Unpacking libobjc-13-dev:amd64 (13.4.0-4ubuntu1) ... 77s Selecting previously unselected package libclang-common-20-dev:amd64. 77s Preparing to unpack .../44-libclang-common-20-dev_1%3a20.1.8-0ubuntu4_amd64.deb ... 77s Unpacking libclang-common-20-dev:amd64 (1:20.1.8-0ubuntu4) ... 77s Selecting previously unselected package llvm-20-linker-tools. 77s Preparing to unpack .../45-llvm-20-linker-tools_1%3a20.1.8-0ubuntu4_amd64.deb ... 77s Unpacking llvm-20-linker-tools (1:20.1.8-0ubuntu4) ... 77s Selecting previously unselected package clang-20. 77s Preparing to unpack .../46-clang-20_1%3a20.1.8-0ubuntu4_amd64.deb ... 77s Unpacking clang-20 (1:20.1.8-0ubuntu4) ... 77s Selecting previously unselected package libdebhelper-perl. 77s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 77s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 77s Selecting previously unselected package libtool. 77s Preparing to unpack .../48-libtool_2.5.4-4build1_all.deb ... 77s Unpacking libtool (2.5.4-4build1) ... 77s Selecting previously unselected package dh-autoreconf. 77s Preparing to unpack .../49-dh-autoreconf_20_all.deb ... 77s Unpacking dh-autoreconf (20) ... 77s Selecting previously unselected package libarchive-zip-perl. 77s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 77s Unpacking libarchive-zip-perl (1.68-1) ... 77s Selecting previously unselected package libfile-stripnondeterminism-perl. 77s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.14.2-1_all.deb ... 77s Unpacking libfile-stripnondeterminism-perl (1.14.2-1) ... 77s Selecting previously unselected package dh-strip-nondeterminism. 77s Preparing to unpack .../52-dh-strip-nondeterminism_1.14.2-1_all.deb ... 77s Unpacking dh-strip-nondeterminism (1.14.2-1) ... 77s Selecting previously unselected package debugedit. 77s Preparing to unpack .../53-debugedit_1%3a5.2-3_amd64.deb ... 77s Unpacking debugedit (1:5.2-3) ... 77s Selecting previously unselected package dwz. 77s Preparing to unpack .../54-dwz_0.16-2_amd64.deb ... 77s Unpacking dwz (0.16-2) ... 77s Selecting previously unselected package gettext. 77s Preparing to unpack .../55-gettext_0.23.1-2build2_amd64.deb ... 77s Unpacking gettext (0.23.1-2build2) ... 77s Selecting previously unselected package intltool-debian. 77s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 77s Unpacking intltool-debian (0.35.0+20060710.6) ... 77s Selecting previously unselected package po-debconf. 77s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 77s Unpacking po-debconf (1.0.21+nmu1) ... 77s Selecting previously unselected package debhelper. 77s Preparing to unpack .../58-debhelper_13.24.2ubuntu1_all.deb ... 77s Unpacking debhelper (13.24.2ubuntu1) ... 77s Selecting previously unselected package emacsen-common. 77s Preparing to unpack .../59-emacsen-common_3.0.8_all.deb ... 77s Unpacking emacsen-common (3.0.8) ... 77s Selecting previously unselected package dictionaries-common. 77s Preparing to unpack .../60-dictionaries-common_1.30.10_all.deb ... 77s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 77s Unpacking dictionaries-common (1.30.10) ... 77s Selecting previously unselected package libfakeroot:amd64. 77s Preparing to unpack .../61-libfakeroot_1.37.1.2-1_amd64.deb ... 77s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 77s Selecting previously unselected package fakeroot. 77s Preparing to unpack .../62-fakeroot_1.37.1.2-1_amd64.deb ... 77s Unpacking fakeroot (1.37.1.2-1) ... 77s Selecting previously unselected package hunspell-en-us. 77s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 77s Unpacking hunspell-en-us (1:2020.12.07-4) ... 77s Selecting previously unselected package libpgtypes3:amd64. 77s Preparing to unpack .../64-libpgtypes3_17.6-1build1_amd64.deb ... 77s Unpacking libpgtypes3:amd64 (17.6-1build1) ... 77s Selecting previously unselected package libpq5:amd64. 77s Preparing to unpack .../65-libpq5_17.6-1build1_amd64.deb ... 77s Unpacking libpq5:amd64 (17.6-1build1) ... 77s Selecting previously unselected package libecpg6:amd64. 77s Preparing to unpack .../66-libecpg6_17.6-1build1_amd64.deb ... 77s Unpacking libecpg6:amd64 (17.6-1build1) ... 77s Selecting previously unselected package libecpg-compat3:amd64. 77s Preparing to unpack .../67-libecpg-compat3_17.6-1build1_amd64.deb ... 77s Unpacking libecpg-compat3:amd64 (17.6-1build1) ... 77s Selecting previously unselected package libssl-dev:amd64. 77s Preparing to unpack .../68-libssl-dev_3.5.2-1ubuntu1_amd64.deb ... 77s Unpacking libssl-dev:amd64 (3.5.2-1ubuntu1) ... 77s Selecting previously unselected package libpq-dev. 77s Preparing to unpack .../69-libpq-dev_17.6-1build1_amd64.deb ... 77s Unpacking libpq-dev (17.6-1build1) ... 77s Selecting previously unselected package libecpg-dev. 77s Preparing to unpack .../70-libecpg-dev_17.6-1build1_amd64.deb ... 77s Unpacking libecpg-dev (17.6-1build1) ... 78s Selecting previously unselected package libicu76:amd64. 78s Preparing to unpack .../71-libicu76_76.1-4ubuntu2_amd64.deb ... 78s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 78s Selecting previously unselected package libncurses-dev:amd64. 78s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 78s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 78s Selecting previously unselected package libtcl8.6:amd64. 78s Preparing to unpack .../73-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 78s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 78s Selecting previously unselected package liblzma-dev:amd64. 78s Preparing to unpack .../74-liblzma-dev_5.8.1-1build2_amd64.deb ... 78s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 78s Selecting previously unselected package zlib1g-dev:amd64. 78s Preparing to unpack .../75-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 78s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 78s Selecting previously unselected package libxml2-dev:amd64. 78s Preparing to unpack .../76-libxml2-dev_2.14.5+dfsg-0.2_amd64.deb ... 78s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2) ... 78s Selecting previously unselected package libxslt1.1:amd64. 78s Preparing to unpack .../77-libxslt1.1_1.1.43-0.1_amd64.deb ... 78s Unpacking libxslt1.1:amd64 (1.1.43-0.1) ... 78s Selecting previously unselected package llvm-20-runtime. 78s Preparing to unpack .../78-llvm-20-runtime_1%3a20.1.8-0ubuntu4_amd64.deb ... 78s Unpacking llvm-20-runtime (1:20.1.8-0ubuntu4) ... 78s Selecting previously unselected package libpfm4:amd64. 78s Preparing to unpack .../79-libpfm4_4.13.0+git99-gc5587f9-1_amd64.deb ... 78s Unpacking libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 78s Selecting previously unselected package llvm-20. 78s Preparing to unpack .../80-llvm-20_1%3a20.1.8-0ubuntu4_amd64.deb ... 78s Unpacking llvm-20 (1:20.1.8-0ubuntu4) ... 78s Selecting previously unselected package libffi-dev:amd64. 78s Preparing to unpack .../81-libffi-dev_3.5.2-1build1_amd64.deb ... 78s Unpacking libffi-dev:amd64 (3.5.2-1build1) ... 78s Selecting previously unselected package llvm-20-tools. 78s Preparing to unpack .../82-llvm-20-tools_1%3a20.1.8-0ubuntu4_amd64.deb ... 78s Unpacking llvm-20-tools (1:20.1.8-0ubuntu4) ... 78s Selecting previously unselected package llvm-20-dev. 78s Preparing to unpack .../83-llvm-20-dev_1%3a20.1.8-0ubuntu4_amd64.deb ... 78s Unpacking llvm-20-dev (1:20.1.8-0ubuntu4) ... 79s Selecting previously unselected package locales-all. 79s Preparing to unpack .../84-locales-all_2.42-0ubuntu3_amd64.deb ... 79s Unpacking locales-all (2.42-0ubuntu3) ... 80s Selecting previously unselected package postgresql-client-17. 80s Preparing to unpack .../85-postgresql-client-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-client-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-17. 80s Preparing to unpack .../86-postgresql-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-doc-17. 80s Preparing to unpack .../87-postgresql-doc-17_17.6-1build1_all.deb ... 80s Unpacking postgresql-doc-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-plperl-17. 80s Preparing to unpack .../88-postgresql-plperl-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-plperl-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-plpython3-17. 80s Preparing to unpack .../89-postgresql-plpython3-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-plpython3-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-pltcl-17. 80s Preparing to unpack .../90-postgresql-pltcl-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-pltcl-17 (17.6-1build1) ... 80s Selecting previously unselected package postgresql-server-dev-17. 80s Preparing to unpack .../91-postgresql-server-dev-17_17.6-1build1_amd64.deb ... 80s Unpacking postgresql-server-dev-17 (17.6-1build1) ... 81s Setting up postgresql-client-common (282) ... 81s Setting up libpgtypes3:amd64 (17.6-1build1) ... 81s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 81s Setting up libio-pty-perl (1:1.20-1build3) ... 81s Setting up libarchive-zip-perl (1.68-1) ... 81s Setting up libclang-common-20-dev:amd64 (1:20.1.8-0ubuntu4) ... 81s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 81s Setting up postgresql-doc-17 (17.6-1build1) ... 81s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 81s Setting up libpq5:amd64 (17.6-1build1) ... 81s Setting up m4 (1.4.19-8) ... 81s Setting up llvm-20-runtime (1:20.1.8-0ubuntu4) ... 81s Setting up libgomp1:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libffi-dev:amd64 (3.5.2-1build1) ... 81s Setting up locales-all (2.42-0ubuntu3) ... 81s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 81s Setting up llvm-20-linker-tools (1:20.1.8-0ubuntu4) ... 81s Setting up fakeroot (1.37.1.2-1) ... 81s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 81s Setting up llvm-20-tools (1:20.1.8-0ubuntu4) ... 81s Setting up autotools-dev (20240727.1) ... 81s Setting up libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 81s Setting up gcc-13-base:amd64 (13.4.0-4ubuntu1) ... 81s Setting up emacsen-common (3.0.8) ... 81s Setting up ssl-cert (1.1.3ubuntu1) ... 81s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 81s Setting up libquadmath0:amd64 (15.2.0-4ubuntu4) ... 81s Setting up llvm-20 (1:20.1.8-0ubuntu4) ... 81s Setting up libssl-dev:amd64 (3.5.2-1ubuntu1) ... 81s Setting up libmpc3:amd64 (1.3.1-1build3) ... 81s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 81s Setting up autopoint (0.23.1-2build2) ... 81s Setting up libipc-run-perl (20231003.0-2) ... 81s Setting up libgc1:amd64 (1:8.2.8-1) ... 81s Setting up autoconf (2.72-3.1ubuntu1) ... 81s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 81s Setting up libubsan1:amd64 (15.2.0-4ubuntu4) ... 81s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 81s Setting up dwz (0.16-2) ... 81s Setting up libhwasan0:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libasan8:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libjson-perl (4.10000-1) ... 81s Setting up libxslt1.1:amd64 (1.1.43-0.1) ... 81s Setting up debugedit (1:5.2-3) ... 81s Setting up libecpg6:amd64 (17.6-1build1) ... 81s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 81s Setting up libtsan2:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libisl23:amd64 (0.27-1) ... 81s Setting up libcc1-0:amd64 (15.2.0-4ubuntu4) ... 81s Setting up liblsan0:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libitm1:amd64 (15.2.0-4ubuntu4) ... 81s Setting up postgresql-common-dev (282) ... 81s Setting up automake (1:1.17-4ubuntu1) ... 81s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 81s Setting up libfile-stripnondeterminism-perl (1.14.2-1) ... 81s Setting up gettext (0.23.1-2build2) ... 81s Setting up libgcc-15-dev:amd64 (15.2.0-4ubuntu4) ... 81s Setting up libecpg-compat3:amd64 (17.6-1build1) ... 81s Setting up dictionaries-common (1.30.10) ... 81s Setting up postgresql-client-17 (17.6-1build1) ... 82s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 82s Setting up libpq-dev (17.6-1build1) ... 82s Setting up libobjc4:amd64 (15.2.0-4ubuntu4) ... 82s Setting up cpp-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 82s Setting up libecpg-dev (17.6-1build1) ... 82s Setting up intltool-debian (0.35.0+20060710.6) ... 82s Setting up gcc-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 82s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2) ... 82s Setting up libstdc++-15-dev:amd64 (15.2.0-4ubuntu4) ... 82s Setting up postgresql-common (282) ... 82s Creating config file /etc/postgresql-common/createcluster.conf with new version 82s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 82s en_us 82s Removing obsolete dictionary files: 82s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 83s Setting up llvm-20-dev (1:20.1.8-0ubuntu4) ... 83s Setting up dh-strip-nondeterminism (1.14.2-1) ... 83s Setting up libgcc-13-dev:amd64 (13.4.0-4ubuntu1) ... 83s Setting up cpp-15 (15.2.0-4ubuntu4) ... 83s Setting up hunspell-en-us (1:2020.12.07-4) ... 83s Setting up libobjc-13-dev:amd64 (13.4.0-4ubuntu1) ... 83s Setting up libstdc++-13-dev:amd64 (13.4.0-4ubuntu1) ... 83s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 83s Setting up g++-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 83s Setting up postgresql-17 (17.6-1build1) ... 83s Creating new PostgreSQL cluster 17/main ... 83s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 83s The files belonging to this database system will be owned by user "postgres". 83s This user must also own the server process. 83s 83s The database cluster will be initialized with locale "C.UTF-8". 83s The default database encoding has accordingly been set to "UTF8". 83s The default text search configuration will be set to "english". 83s 83s Data page checksums are disabled. 83s 83s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 83s creating subdirectories ... ok 83s selecting dynamic shared memory implementation ... posix 83s selecting default "max_connections" ... 100 83s selecting default "shared_buffers" ... 128MB 83s selecting default time zone ... Etc/UTC 83s creating configuration files ... ok 83s running bootstrap script ... ok 83s performing post-bootstrap initialization ... ok 83s syncing data to disk ... ok 86s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 86s Setting up po-debconf (1.0.21+nmu1) ... 86s Setting up gcc-15 (15.2.0-4ubuntu4) ... 86s Setting up postgresql-plpython3-17 (17.6-1build1) ... 86s Setting up postgresql-plperl-17 (17.6-1build1) ... 86s Setting up cpp (4:15.2.0-4ubuntu1) ... 86s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 86s Setting up g++-15 (15.2.0-4ubuntu4) ... 86s Setting up clang-20 (1:20.1.8-0ubuntu4) ... 86s Setting up postgresql-pltcl-17 (17.6-1build1) ... 86s Setting up libtool (2.5.4-4build1) ... 86s Setting up gcc (4:15.2.0-4ubuntu1) ... 86s Setting up dh-autoreconf (20) ... 86s Setting up postgresql-server-dev-17 (17.6-1build1) ... 86s Setting up g++ (4:15.2.0-4ubuntu1) ... 86s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 86s Setting up build-essential (12.12ubuntu2) ... 86s Setting up debhelper (13.24.2ubuntu1) ... 86s Processing triggers for man-db (2.13.1-1) ... 87s Processing triggers for install-info (7.1.1-1) ... 87s Processing triggers for libc-bin (2.42-0ubuntu3) ... 87s Processing triggers for systemd (257.9-0ubuntu1) ... 87s Processing triggers for dictionaries-common (1.30.10) ... 90s autopkgtest [10:36:09]: test run-testsuite: [----------------------- 90s ====== Running all tests with umask 077 ======= 90s ### PostgreSQL test 001_packages.t ### 90s 1..23 90s ok 1 - /etc/os-release exists 90s ok 2 - OS is ubuntu 90s ok 3 - OS version is 25.10 90s # PostgreSQL versions installed: 17 90s # 17 90s ok 4 - postgresql-17 installed 90s ok 5 - postgresql-plpython3-17 installed 90s ok 6 - postgresql-plperl-17 installed 90s ok 7 - postgresql-pltcl-17 installed 90s ok 8 # skip No postgresql-17-jit package for version 17 90s ok 9 - postgresql-server-dev-17 installed 90s ok 10 # skip No postgresql-contrib-17 package for version 17 90s # postgresql-doc-17 installed 90s ok 11 - At least one doc package installed 90s ok 12 - libecpg-dev installed 90s ok 13 - postgresql-common-dev installed 90s ok 14 - procps installed 90s ok 15 - netcat-openbsd installed 91s ok 16 - hunspell-en-us installed 91s ok 17 - system has a default UTF-8 locale 91s ok 18 - locale ru_RU exists 91s ok 19 - locale ru_RU.UTF-8 exists 91s ok 20 - user postgres in the UNIX group ssl-cert 91s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 91s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 91s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 91s ### End test 001_packages.t ### 91s 91s ### PostgreSQL test 002_existing_clusters.t ### 91s 1..8 91s # Cleanup 91s ok 1 - Cleanup: No clusters left behind 91s ok 2 - No postgres processes left behind 91s ok 3 - No files in /etc/postgresql left behind 91s ok 4 - No files in /var/lib/postgresql left behind 91s ok 5 - No files in /var/run/postgresql left behind 91s ok 6 - No files in /var/log/postgresql left behind 91s ok 7 - PostgreSQL TCP ports are closed 91s ok 8 - Next free port is 5432 91s ### End test 002_existing_clusters.t ### 91s 91s ### PostgreSQL test 003_alternatives.t ### 91s 1..9 91s # Newest PG version installed is 17 91s ok 1 - psql.1.gz link group 91s ok 2 - postmaster.1.gz link group does not exist 91s ok 3 - psql.1.gz alternative 91s ok 4 - pg_dump.1.gz alternative 91s ok 5 - postgres.1.gz alternative 91s ok 6 - pg_ctl.1.gz alternative 91s # Newest PG doc version installed is 17 91s ok 7 - SPI_connect.3.gz link group 91s ok 8 - SPI_connect.3.gz alternative 91s ok 9 - SPI_exec.3.gz alternative 91s ### End test 003_alternatives.t ### 91s 91s ### PostgreSQL test 005_PgCommon.t ### 91s 1..24 91s ok 1 - correctly parsed line 'local all postgres ident sameuser' 91s ok 2 - correctly parsed line 'local foo nobody trust' 91s ok 3 - correctly parsed line 'local foo nobody crypt' 91s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 91s ok 5 - correctly parsed line 'local foo,bar nobody ident' 91s ok 6 - correctly parsed line 'local all +foogrp password' 91s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 91s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 91s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 91s ok 10 - @expected_records has correct number of entries 91s ok 11 - returned read_pg_hba array has correct number of records 91s ok 12 - line 'foo all all md5' parsed as invalid 91s ok 13 - line 'local all all foo' parsed as invalid 91s ok 14 - line 'host all all foo' parsed as invalid 91s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 91s ok 16 - line 'host all all md5' parsed as invalid 91s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 91s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 91s ok 19 - read_conf_file returns empty dict for nonexisting file 91s ok 20 - read_conf_file() parsing 91s ok 21 - read_conf_file() parsing with include directives 91s ok 22 - set_conf_value 91s ok 23 - disable_conf_value 91s ok 24 - replace_conf_value 91s ### End test 005_PgCommon.t ### 91s 91s ### PostgreSQL test 006_next_free_port.t ### 91s 1..5 91s ok 1 - next_free_port is 5432 92s ok 2 - next_free_port detects localhost ipv4 socket 93s ok 3 - next_free_port detects wildcard ipv4 socket 94s ok 4 - next_free_port detects localhost ipv6 socket 95s ok 5 - next_free_port detects wildcard ipv6 socket 95s ### End test 006_next_free_port.t ### 95s 95s ### PostgreSQL test 007_pg_conftool.t ### 95s 1..41 95s # test without cluster 95s ok 1 - pg_conftool show all 95s ok 2 - correct output of pg_conftool show all 95s ok 3 - pg_conftool foo.conf show all 95s ok 4 - correct output of pg_conftool foo.conf show all 95s ok 5 - pg_conftool /tmp/UeZnsQ7YoT/different.conf show all 95s ok 6 - correct output of pg_conftool /tmp/UeZnsQ7YoT/different.conf show all 95s ok 7 - pg_conftool 9.7 main show all 95s ok 8 - correct output of pg_conftool 9.7 main show all 95s # test show 95s ok 9 - pg_conftool show all 95s ok 10 - correct output of pg_conftool show all 95s ok 11 - pg_conftool other.conf show all 95s ok 12 - correct output of pg_conftool other.conf show all 95s ok 13 - pg_conftool /tmp/UeZnsQ7YoT/different.conf show all 95s ok 14 - correct output of pg_conftool /tmp/UeZnsQ7YoT/different.conf show all 95s ok 15 - pg_conftool 17 main show all 95s ok 16 - correct output of pg_conftool 17 main show all 95s ok 17 - pg_conftool 17 main other.conf show all 95s ok 18 - correct output of pg_conftool 17 main other.conf show all 95s ok 19 - pg_conftool show a 95s ok 20 - correct output of pg_conftool show a 95s ok 21 - pg_conftool -s show a 95s ok 22 - correct output of pg_conftool -s show a 95s # test set 95s ok 23 - pg_conftool set c 7 95s ok 24 - correct output of pg_conftool set c 7 95s ok 25 - file contains new setting 95s ok 26 - pg_conftool set a 8 95s ok 27 - correct output of pg_conftool set a 8 95s ok 28 - file contains updated setting 95s ok 29 - pg_conftool /tmp/UeZnsQ7YoT/different.conf set a 9 95s ok 30 - correct output of pg_conftool /tmp/UeZnsQ7YoT/different.conf set a 9 95s ok 31 - file with path contains updated setting 95s # test remove 95s ok 32 - pg_conftool remove a 95s ok 33 - correct output of pg_conftool remove a 95s ok 34 - setting removed from file 95s ok 35 - pg_conftool /tmp/UeZnsQ7YoT/different.conf remove a 95s ok 36 - correct output of pg_conftool /tmp/UeZnsQ7YoT/different.conf remove a 95s ok 37 - setting removed from file with path 95s # test edit 95s ok 38 - pg_conftool edit 95s ok 39 - correct output of pg_conftool edit 95s ok 40 - pg_conftool /tmp/UeZnsQ7YoT/different.conf edit 95s ok 41 - correct output of pg_conftool /tmp/UeZnsQ7YoT/different.conf edit 95s ### End test 007_pg_conftool.t ### 95s 95s ### PostgreSQL test 010_defaultport_cluster.t ### 95s 1..14 96s ok 1 - psql --version 96s ok 2 - pg_wrapper selects highest available version number 96s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 96s ok 4 - connecting to localhost fails with no clusters 96s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 96s ok 6 - pg_wrapper uses host and port from PGCLUSTER 96s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 96s ok 8 - pg_wrapper uses --cluster from the command line 96s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 96s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 96s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 96s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 96s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 96s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 96s ### End test 010_defaultport_cluster.t ### 96s 96s ### PostgreSQL test 015_start_stop.t ### 96s 1..71 96s # We are running systemd 96s # Running tests for 17 96s # Cluster does not exist yet 96s ok 1 - cluster 17 main does not exist 96s ok 2 - service postgresql@17-main does not exist 96s ok 3 - systemctl start postgresql 96s ok 4 - cluster 17 main does not exist 96s ok 5 - service postgresql@17-main does not exist 96s ok 6 - systemctl start postgresql@17-main 96s ok 7 - cluster 17 main does not exist 96s ok 8 - service postgresql@17-main does not exist 96s # Start/stop postgresql using system tools 97s ok 9 - pg_createcluster 17 main 97s ok 10 - cluster 17 main is stopped 97s ok 11 - service postgresql@17-main is stopped 99s ok 12 - systemctl start postgresql 99s ok 13 - cluster 17 main is running 99s ok 14 - service postgresql@17-main is running 99s ok 15 - systemctl start postgresql 99s ok 16 - cluster 17 main is already running 99s ok 17 - service postgresql@17-main is already running 99s ok 18 - systemctl stop postgresql 105s ok 19 - cluster 17 main is stopped 105s ok 20 - service postgresql@17-main is stopped 105s ok 21 - systemctl stop postgresql 105s ok 22 - cluster 17 main is already stopped 105s ok 23 - service postgresql@17-main is already stopped 105s # Start/stop specific cluster using system tools 107s ok 24 - systemctl start postgresql@17-main 107s ok 25 - cluster 17 main is running 107s ok 26 - service postgresql@17-main is running 107s ok 27 - systemctl start postgresql@17-main 107s ok 28 - cluster 17 main is running 107s ok 29 - service postgresql@17-main is running 111s ok 30 - systemctl restart postgresql@17-main 111s ok 31 - cluster 17 main is running 111s ok 32 - service postgresql@17-main is running 111s ok 33 - systemctl stop postgresql@17-main 111s ok 34 - cluster 17 main is stopped 111s ok 35 - service postgresql@17-main is stopped 111s ok 36 - systemctl stop postgresql@17-main 111s ok 37 - cluster 17 main is already stopped 111s ok 38 - service postgresql@17-main is already stopped 111s ok 39 - pg_dropcluster 17 main 111s ok 40 - cluster 17 main does not exist 111s ok 41 - service postgresql@17-main does not exist 111s # Start/stop specific cluster using pg_*cluster 111s ok 42 - pg_ctlcluster start 17 main 111s ok 43 - cluster 17 main does not exist 111s ok 44 - service postgresql@17-main does not exist 114s ok 45 - pg_createcluster 17 main --start 114s ok 46 - cluster 17 main is running 114s ok 47 - service postgresql@17-main is running 114s ok 48 - pg_ctlcluster 17 main start 114s ok 49 - cluster 17 main is already running 114s ok 50 - service postgresql@17-main is already running 116s ok 51 - pg_ctlcluster 17-main restart 116s ok 52 - cluster 17 main is running 116s ok 53 - service postgresql@17-main is running 117s ok 54 - pg_ctlcluster 17 main stop 117s ok 55 - cluster 17 main is stopped 117s ok 56 - service postgresql@17-main is stopped 117s ok 57 - pg_ctlcluster 17 main stop 117s ok 58 - cluster 17 main is already stopped 117s ok 59 - service postgresql@17-main is already stopped 119s ok 60 - pg_ctlcluster start 17-main 119s ok 61 - cluster 17 main is running 119s ok 62 - service postgresql@17-main is running 120s ok 63 - pg_dropcluster 17 main --stop 120s # Cleanup 120s ok 64 - Cleanup: No clusters left behind 120s ok 65 - No postgres processes left behind 120s ok 66 - No files in /etc/postgresql left behind 120s ok 67 - No files in /var/lib/postgresql left behind 120s ok 68 - No files in /var/run/postgresql left behind 120s ok 69 - No files in /var/log/postgresql left behind 120s ok 70 - PostgreSQL TCP ports are closed 120s ok 71 - Next free port is 5432 120s ### End test 015_start_stop.t ### 120s 120s ### PostgreSQL test 020_create_sql_remove.t ### 120s 1..141 120s # Running tests for 17 123s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.5wfPwG 123s ok 2 - pg_createcluster 17 main 123s ok 3 - Socket and pid file are in /var/run/postgresql/ 123s ok 4 - xlog/wal directory /tmp/17.xlog.5wfPwG was created 123s ok 5 - local method in pg_hba.conf is peer 123s ok 6 - host method in pg_hba.conf is scram-sha-256 123s ok 7 - Exactly one postgres master process running 125s ok 8 - pg_ctlcluster 17 main restart 125s ok 9 - cluster restarts with new environment file 125s ok 10 - Exactly one postgres master process running 125s ok 11 - correct value of PGEXTRAVAR1 in environment 125s ok 12 - correct value of PGEXTRAVAR2 in environment 125s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 125s ok 14 - createdb --version 125s ok 15 - pg_wrapper+createdb selects version number of cluster 125s ok 16 - psql --version 125s ok 17 - pg_wrapper+psql selects version 17 125s ok 18 - pg_lscluster reports online cluster on port 5432 125s ok 19 - log file is actually used 125s ok 20 - /etc/postgresql is owned by user "postgres" 125s ok 21 - version configuration directory file is owned by user "postgres" 125s ok 22 - configuration directory file is owned by user "postgres" 125s ok 23 - version data directory file is owned by user "postgres" 125s ok 24 - data directory file is owned by user "postgres" 125s ok 25 - log file has 0640 permissions 125s ok 26 - log file is owned by user "postgres" 125s ok 27 - log file is owned by group "adm" 125s ok 28 - no log symlink by default 125s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 125s ok 30 - pg_lsclusters -h 125s ok 31 - correct output of pg_lsclusters -h 126s ok 32 - stopping cluster 128s ok 33 - restarting cluster with nondefault log symlink 128s ok 34 - log target is used as log file 128s ok 35 - default log is not used 128s ok 36 - pg_lsclusters -h 128s ok 37 - correct output of pg_lsclusters -h 128s ok 38 - stopping cluster 131s ok 39 - restarting cluster with explicitly configured log file 131s ok 40 - default log is not used 131s ok 41 - log symlink target is used for startup message 131s ok 42 - exactly one log file 131s ok 43 - custom log is actually used 131s ok 44 - pg_lsclusters -h 131s ok 45 - correct output of pg_lsclusters -h 131s ok 46 - stopping cluster 131s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 131s ok 48 - /etc/postgres-hack was not created 134s ok 49 - restarting cluster 134s ok 50 - ps -o tty -U postgres h 134s ok 51 - postgres processes do not have an associated terminal 134s ok 52 - Server is linked with SSL support 134s ok 53 - SSL is enabled in postgresql.conf 134s ok 54 - psql -l fails for nobody 134s ok 55 - createuser nobody 134s ok 56 - createdb nobodydb 134s ok 57 - psql -ltA succeeds for nobody 134s ok 58 - psql -ltA output 134s ok 59 - SQL command: create table 134s ok 60 - SQL command: insert into table values 134s ok 61 - SQL command: insert into table values 134s ok 62 - primary key violation 134s ok 63 - psql -tAc "select * from phone order by name" nobodydb 134s ok 64 - SQL command output: select -tA 134s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 134s ok 66 - SQL command output: select -tx 134s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 134s ok 68 - SQL command output: select -tAx 134s ok 69 - CREATE EXTENSION plperlu fails for user nobody 134s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 134s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 134s ok 72 - creating PL/PerlU function as user nobody fails 134s ok 73 - creating unsafe PL/Perl function as user postgres fails 134s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 134s ok 75 - creating PL/PerlU function as user postgres succeeds 134s ok 76 - psql nobodydb -Atc "select read_file()" 134s ok 77 - calling PL/PerlU function 134s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 134s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 134s ok 80 - creating unsafe PL/Perl function as user nobody fails 134s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 134s ok 82 - creating PL/Perl function as user nobody succeeds 134s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 134s ok 84 - calling PL/Perl function 134s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 134s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 134s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 134s ok 88 - creating PL/Python3 function as user postgres succeeds 134s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 134s ok 90 - calling PL/Python function 134s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 134s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 134s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 134s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 135s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 135s ok 96 - creating PL/Tcl function as user nobody succeeds 135s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 135s ok 98 - creating PL/TclU function as user postgres succeeds 135s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 135s ok 100 - calling PL/Tcl function 135s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 135s ok 102 - calling PL/TclU function 135s ok 103 - stopping cluster 135s ok 104 - pg_ctlcluster 17 main start 135s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 137s ok 106 - pg_ctlcluster 17 main start 137s ok 107 - cluster restarts with pgdata symlink 137s ok 108 - postgres master has OOM killer protection 137s ok 109 - postgres client backend has no OOM adjustment 138s ok 110 - ps h 7171 138s ok 111 - process title is idle 138s ok 112 - ps h 7171 138s ok 113 - process title is idle in transaction 138s ok 114 - stopping cluster 140s ok 115 - starting cluster as postgres works without a log file 140s ok 116 - log file got recreated and used 140s ok 117 - creating a directory in spc2 140s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.JZgLbL'" 140s ok 119 - creating tablespace spc1 140s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 140s ok 121 - creating a table in spc1 140s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.soSwsv'" 140s ok 123 - creating tablespace spc2 140s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 140s ok 125 - creating a table in spc2 140s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 140s ok 127 - Correct apt NeverAutoRemove config 142s ok 128 - pg_dropcluster removes cluster 142s ok 129 - xlog/wal directory /tmp/17.xlog.5wfPwG was deleted 142s ok 130 - tablespace spc1 was emptied 142s ok 131 - tablespace spc2 was emptied 142s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 142s ok 133 - Correct apt NeverAutoRemove config 142s # Cleanup 142s ok 134 - Cleanup: No clusters left behind 142s ok 135 - No postgres processes left behind 142s ok 136 - No files in /etc/postgresql left behind 142s ok 137 - No files in /var/lib/postgresql left behind 142s ok 138 - No files in /var/run/postgresql left behind 142s ok 139 - No files in /var/log/postgresql left behind 142s ok 140 - PostgreSQL TCP ports are closed 142s ok 141 - Next free port is 5432 142s ### End test 020_create_sql_remove.t ### 142s 142s ### PostgreSQL test 021_pg_renamecluster.t ### 142s 1..20 145s ok 1 - pg_createcluster 17 main 147s ok 2 - pg_renamecluster 17 main donau 147s ok 3 - psql -tAc "show data_directory" 147s ok 4 - cluster is running and data_directory was moved 147s ok 5 - pg_hba.conf location updated 147s ok 6 - pg_ident.conf location updated 147s ok 7 - external_pid_file location updated 147s ok 8 - external_pid_file exists 147s ok 9 # skip no stats_temp_directory in 17 147s ok 10 # skip no stats_temp_directory in 17 147s ok 11 - cluster_name is updated 148s ok 12 - pg_dropcluster removes cluster 148s # Cleanup 148s ok 13 - Cleanup: No clusters left behind 148s ok 14 - No postgres processes left behind 148s ok 15 - No files in /etc/postgresql left behind 148s ok 16 - No files in /var/lib/postgresql left behind 148s ok 17 - No files in /var/run/postgresql left behind 148s ok 18 - No files in /var/log/postgresql left behind 148s ok 19 - PostgreSQL TCP ports are closed 148s ok 20 - Next free port is 5432 148s ### End test 021_pg_renamecluster.t ### 148s 148s ### PostgreSQL test 022_recovery.t ### 148s 1..17 148s # Running tests for 17 151s ok 1 - pg_createcluster 17 main --start >/dev/null 152s ok 2 - pg_ctlcluster 17 main stop -m i 154s ok 3 - pg_ctlcluster 17 main start 154s ok 4 - psql -c '' 154s ok 5 - pg_ctlcluster 17 main stop -m i 154s ok 6 - create write-protected file in data directory 156s ok 7 - pg_ctlcluster 17 main start 156s ok 8 - psql -c '' 157s ok 9 - pg_dropcluster removes cluster 157s # Cleanup 158s ok 10 - Cleanup: No clusters left behind 158s ok 11 - No postgres processes left behind 158s ok 12 - No files in /etc/postgresql left behind 158s ok 13 - No files in /var/lib/postgresql left behind 158s ok 14 - No files in /var/run/postgresql left behind 158s ok 15 - No files in /var/log/postgresql left behind 158s ok 16 - PostgreSQL TCP ports are closed 158s ok 17 - Next free port is 5432 158s ### End test 022_recovery.t ### 158s 158s ### PostgreSQL test 025_logging.t ### 158s 1..55 158s # Logging to /var/log/syslog works 158s # Running tests for 17 161s ok 1 - pg_createcluster 17 main 161s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 161s ok 3 - psql -qc "'foobar_17_8357'" 161s ok 4 - log an error 162s ok 5 - grep --binary-files=text foobar_17_8357 /var/log/postgresql/postgresql-17-main.log 162s ok 6 - error appears in logfile 162s ok 7 - pg_conftool 17 main set log_destination syslog 162s ok 8 - set log_destination syslog 162s ok 9 - pg_ctlcluster 17 main reload 162s ok 10 - 17 main reload 162s ok 11 - psql -Atc "show log_destination" 162s ok 12 - log_destination is syslog 162s ok 13 - pg_lscluster reports syslog 162s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 162s ok 15 - error appears in /var/log/syslog 162s ok 16 - pg_conftool 17 main set logging_collector on 162s ok 17 - set logging_collector on 162s ok 18 - pg_conftool 17 main set log_destination csvlog 162s ok 19 - set log_destination csvlog 165s ok 20 - pg_ctlcluster 17 main restart 165s ok 21 - 17 main restart 165s ok 22 - psql -Atc "show logging_collector" 165s ok 23 - logging_collector is on 165s ok 24 - psql -Atc "show log_destination" 165s ok 25 - log_destination is csvlog 165s ok 26 - pg_lscluster reports csvlog 165s ok 27 - psql -qc "'barbaz_17_8357'" 165s ok 28 - log an error 165s ok 29 - grep --binary-files=text barbaz_17_8357 /var/lib/postgresql/17/main/log/*.csv 165s ok 30 - error appears in log/*.csv 165s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 165s ok 32 - set log_destination stderr,syslog,csvlog 165s ok 33 - pg_ctlcluster 17 main reload 165s ok 34 - 17 main reload 165s ok 35 - psql -Atc "show log_destination" 165s ok 36 - log_destination is stderr,syslog,csvlog 165s ok 37 - pg_lscluster reports stderr,syslog,csvlog 166s ok 38 - psql -qc "'moo_17_8357'" 166s ok 39 - log an error 166s ok 40 - grep --binary-files=text moo_17_8357 /var/lib/postgresql/17/main/log/*.log 166s ok 41 - error appears in log/*.log 167s ok 42 - grep --binary-files=text 'postgres.*moo_17_8357' /var/log/syslog 167s ok 43 - error appears in /var/log/syslog 167s ok 44 - grep --binary-files=text moo_17_8357 /var/lib/postgresql/17/main/log/*.csv 167s ok 45 - error appears in log/*.csv 168s ok 46 - pg_dropcluster 17 main --stop 168s ok 47 - pg_dropcluster removes cluster 168s # Cleanup 168s ok 48 - Cleanup: No clusters left behind 168s ok 49 - No postgres processes left behind 168s ok 50 - No files in /etc/postgresql left behind 168s ok 51 - No files in /var/lib/postgresql left behind 168s ok 52 - No files in /var/run/postgresql left behind 168s ok 53 - No files in /var/log/postgresql left behind 168s ok 54 - PostgreSQL TCP ports are closed 168s ok 55 - Next free port is 5432 168s ### End test 025_logging.t ### 168s 168s ### PostgreSQL test 027_jit.t ### 168s # 17 171s ok 1 - pg_createcluster 17 main --start 171s ok 2 - psql -Xatc 'show jit' 171s ok 3 - JIT is on by default 171s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 171s ok 5 - No JIT on cheap query 171s ok 6 - pg_conftool 17 main set seq_page_cost 100000 171s ok 7 - pg_conftool 17 main set random_page_cost 100000 171s ok 8 - pg_ctlcluster 17 main reload 171s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 171s ok 10 - Expensive query is JITed 172s ok 11 - pg_dropcluster --stop 17 main 172s # Cleanup 172s ok 12 - Cleanup: No clusters left behind 172s ok 13 - No postgres processes left behind 172s ok 14 - No files in /etc/postgresql left behind 172s ok 15 - No files in /var/lib/postgresql left behind 172s ok 16 - No files in /var/run/postgresql left behind 172s ok 17 - No files in /var/log/postgresql left behind 172s ok 18 - PostgreSQL TCP ports are closed 172s ok 19 - Next free port is 5432 172s 1..19 172s ### End test 027_jit.t ### 172s 172s ### PostgreSQL test 030_errors.t ### 172s 1..156 172s ok 1 - pg_lscluster reports cluster without binaries 173s ok 2 - pg_dropcluster 6.3 main 174s ok 3 - pg_createcluster --socketdir 174s ok 4 - pg_lsclusters -h 174s ok 5 - cluster was created 174s ok 6 - Port of created cluster is 5432 174s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 174s ok 8 - pg_createcluster on existing cluster 174s ok 9 - pg_lsclusters -h 174s ok 10 - original cluster still exists 174s ok 11 - pg_createcluster 17 test -p foo 174s ok 12 - pg_createcluster -p checks that port option is numeric 174s ok 13 - pg_createcluster 17 test -p 42 174s ok 14 - pg_createcluster -p checks valid port range 174s ok 15 - pg_ctlcluster 17 main start 174s ok 16 - pg_ctlcluster refuses to start root-owned cluster 174s ok 17 - pg_ctlcluster 17 main start 174s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 174s ok 19 - pg_ctlcluster 17 main start 174s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 174s ok 21 - pg_ctlcluster 17 main start 174s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 176s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 176s ok 24 - No sockets in /var/run/postgresql 176s ok 25 - Socket is in /tmp/postgresql-testsuite/ 177s ok 26 - cluster stops with custom unix_socket_dir 177s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 179s ok 28 - cluster starts after removing unix_socket_dir 179s ok 29 - Socket is in default dir /var/run/postgresql 179s ok 30 - No sockets in /tmp/postgresql-testsuite/ 179s ok 31 - pg_ctlcluster 17 main stop 179s ok 32 - pg_ctlcluster fails with corrupted PID file 179s ok 33 - pg_lsclusters -h 179s ok 34 - cluster is still online 179s ok 35 - pg_ctlcluster succeeds with restored PID file 179s ok 36 - pg_lsclusters -h 179s ok 37 - cluster is down 179s ok 38 - pg_ctlcluster 17 main stop 179s ok 39 - pg_ctlcluster stop fails on stopped cluster 181s ok 40 - pg_ctlcluster 17 main start 181s ok 41 - pg_ctlcluster succeeds with already existing PID file 181s ok 42 - pg_lsclusters -h 181s ok 43 - cluster is online 181s ok 44 - pg_ctlcluster stop succeeds 182s ok 45 - pg_lsclusters -h 182s ok 46 - cluster is down 182s ok 47 - no pid file left 182s ok 48 - pg_ctlcluster 17 main stop 182s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 182s ok 50 - pid file was cleaned up 182s ok 51 - pg_ctlcluster --force 17 main stop 182s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 182s ok 53 - pid file was cleaned up 182s ok 54 - pg_ctlcluster 17 main stop 182s ok 55 - pg_ctlcluster stop succeeds with stale PID file 182s ok 56 - pid file was cleaned up 182s ok 57 - pg_ctlcluster --force 17 main stop 182s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 182s ok 59 - pid file was cleaned up 182s ok 60 - pg_ctlcluster --force 17 main stop 182s ok 61 - pg_ctlcluster stop succeeds with empty PID file 182s ok 62 - pid file was cleaned up 184s ok 63 - pg_ctlcluster 17 main start 184s ok 64 - pg_ctlcluster succeeds with corrupted PID file 184s ok 65 - pg_lsclusters -h 184s ok 66 - cluster is online 184s ok 67 - pg_ctlcluster 17 main start 184s ok 68 - pg_ctlcluster start fails on running cluster 184s ok 69 - pg_ctlcluster stop 184s ok 70 - pg_ctlcluster 17 main start 184s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 184s ok 72 - pg_ctlcluster 17 main stop 184s ok 73 - stopping cluster 191s ok 74 - pg_ctlcluster 17 main start 191s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 191s ok 76 - pg_ctlcluster 17 main stop 191s ok 77 - stopping cluster 191s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 191s ok 79 - pg_dropcluster 17 main 191s ok 80 - pg_dropcluster works as user postgres 191s ok 81 - pg_createcluster succeeds 191s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 191s ok 83 - proper error message for nonexisting /var/lib/postgresql 194s ok 84 - pg_ctlcluster 17 main start 194s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 194s ok 86 - pg_ctlcluster 17 main stop 194s ok 87 - stopping cluster 194s ok 88 - pg_createcluster other 197s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 199s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 199s ok 91 199s ok 92 - pg_ctlcluster 17 other start 199s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 199s ok 94 - pg_ctlcluster 17 main stop 199s ok 95 - stopping main cluster 201s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 202s ok 97 - pg_dropcluster other 203s ok 98 - pg_dropcluster 203s ok 99 - No sockets any more 203s ok 100 - 'pg_lsclusters 4.5 foo' fails 203s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 203s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 203s ok 103 - 'psql --cluster 4.5/foo' fails 203s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 203s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 203s ok 106 - 'psql --cluster 17/foo' fails 203s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 203s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 203s ok 109 - 'pg_dropcluster 4.5 foo' fails 203s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 203s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 203s ok 112 - 'pg_dropcluster 17 foo' fails 203s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 203s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 203s ok 115 - 'pg_upgradecluster 4.5 foo' fails 203s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 203s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 204s ok 118 - 'pg_upgradecluster 17 foo' fails 204s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 204s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 204s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 204s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 204s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 204s ok 124 - 'pg_ctlcluster 17 foo stop' fails 204s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 204s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 204s # Cleanup 204s ok 127 - Cleanup: No clusters left behind 204s ok 128 - No postgres processes left behind 204s ok 129 - No files in /etc/postgresql left behind 204s ok 130 - No files in /var/lib/postgresql left behind 204s ok 131 - No files in /var/run/postgresql left behind 204s ok 132 - No files in /var/log/postgresql left behind 204s ok 133 - PostgreSQL TCP ports are closed 204s ok 134 - Next free port is 5432 204s ok 135 - pg_dropcluster 17 broken 204s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 204s # Cleanup 204s ok 137 - Cleanup: No clusters left behind 204s ok 138 - No postgres processes left behind 204s ok 139 - No files in /etc/postgresql left behind 204s ok 140 - No files in /var/lib/postgresql left behind 204s ok 141 - No files in /var/run/postgresql left behind 204s ok 142 - No files in /var/log/postgresql left behind 204s ok 143 - PostgreSQL TCP ports are closed 204s ok 144 - Next free port is 5432 205s ok 145 - pg_dropcluster 17 broken 205s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 205s ok 147 - /etc/postgresql/17 was removed 205s ok 148 - /var/lib/postgresql/17 was removed 205s # Cleanup 205s ok 149 - Cleanup: No clusters left behind 205s ok 150 - No postgres processes left behind 205s ok 151 - No files in /etc/postgresql left behind 205s ok 152 - No files in /var/lib/postgresql left behind 205s ok 153 - No files in /var/run/postgresql left behind 205s ok 154 - No files in /var/log/postgresql left behind 205s ok 155 - PostgreSQL TCP ports are closed 205s ok 156 - Next free port is 5432 205s ### End test 030_errors.t ### 205s 205s ### PostgreSQL test 031_errors_disk_full.t ### 206s 1..22 206s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 206s ok 1 - script failed 206s ok 2 - pg_createcluster fails due to insufficient disk space 206s ok 3 - does not leave files behind 206s # Cleanup 206s ok 4 - Cleanup: No clusters left behind 206s ok 5 - No postgres processes left behind 206s ok 6 - No files in /etc/postgresql left behind 206s ok 7 - No files in /var/lib/postgresql left behind 206s ok 8 - No files in /var/run/postgresql left behind 206s ok 9 - No files in /var/log/postgresql left behind 206s ok 10 - PostgreSQL TCP ports are closed 206s ok 11 - Next free port is 5432 206s # check disk full conditions on startup 208s ok 12 - script failed 208s ok 13 - pg_ctlcluster prints error message 208s ok 14 - log file has error message 208s # Cleanup 208s ok 15 - Cleanup: No clusters left behind 208s ok 16 - No postgres processes left behind 208s ok 17 - No files in /etc/postgresql left behind 208s ok 18 - No files in /var/lib/postgresql left behind 208s ok 19 - No files in /var/run/postgresql left behind 208s ok 20 - No files in /var/log/postgresql left behind 208s ok 21 - PostgreSQL TCP ports are closed 208s ok 22 - Next free port is 5432 208s ### End test 031_errors_disk_full.t ### 208s 208s ### PostgreSQL test 032_ssl_key_permissions.t ### 208s 1..22 208s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 208s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 208s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 209s ok 4 - pg_createcluster 17 main 209s ok 5 - pg_ctlcluster 17 main start 209s ok 6 - ssl key owned by nobody refused 209s ok 7 - pg_ctlcluster 17 main start 209s ok 8 - ssl key with permissions root:root 0644 refused 209s ok 9 - pg_ctlcluster 17 main start 209s ok 10 - ssl key with permissions postgres:postgres 0640 refused 210s ok 11 - pg_dropcluster 17 main --stop 210s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 210s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 210s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 210s # Cleanup 210s ok 15 - Cleanup: No clusters left behind 210s ok 16 - No postgres processes left behind 210s ok 17 - No files in /etc/postgresql left behind 210s ok 18 - No files in /var/lib/postgresql left behind 210s ok 19 - No files in /var/run/postgresql left behind 210s ok 20 - No files in /var/log/postgresql left behind 210s ok 21 - PostgreSQL TCP ports are closed 210s ok 22 - Next free port is 5432 210s ### End test 032_ssl_key_permissions.t ### 210s 210s ### PostgreSQL test 040_upgrade.t ### 211s 1..1 211s ok 1 - only one major version installed, skipping upgrade tests 211s ### End test 040_upgrade.t ### 211s 211s ### PostgreSQL test 041_upgrade_custompaths.t ### 211s 1..1 211s ok 1 - only one major version installed, skipping upgrade tests 211s ### End test 041_upgrade_custompaths.t ### 211s 211s ### PostgreSQL test 042_upgrade_rename.t ### 211s 1..15 211s # PostgreSQL 17 214s ok 1 - pg_createcluster 17 main --start 219s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 219s ok 3 - pg_lsclusters -h 219s ok 4 - correct output of pg_lsclusters -h 220s ok 5 - pg_dropcluster 17 main --stop 221s ok 6 - pg_dropcluster 17 upgr --stop 221s ok 7 - Cleaning pg_upgrade log files 221s # Cleanup 221s ok 8 - Cleanup: No clusters left behind 221s ok 9 - No postgres processes left behind 221s ok 10 - No files in /etc/postgresql left behind 221s ok 11 - No files in /var/lib/postgresql left behind 221s ok 12 - No files in /var/run/postgresql left behind 221s ok 13 - No files in /var/log/postgresql left behind 221s ok 14 - PostgreSQL TCP ports are closed 221s ok 15 - Next free port is 5432 221s ### End test 042_upgrade_rename.t ### 221s 221s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 221s 1..1 221s ok 1 - only one major version installed, skipping upgrade tests 221s ### End test 043_upgrade_ssl_cert.t ### 221s 221s ### PostgreSQL test 045_backup.t ### 221s # We are running systemd 221s # PostgreSQL 17 221s # create cluster 224s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 224s ok 2 - pg_lsclusters -h 224s ok 3 - correct output of pg_lsclusters -h 224s ok 4 - pg_conftool 17 main set work_mem 11MB 224s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 224s ok 6 - psql -c 'alter database mydb set search_path=public' 224s ok 7 - psql -c 'create table foo (t text)' mydb 224s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 224s ok 9 - psql -c 'CREATE USER myuser' 224s ok 10 - psql -c 'grant create on database mydb to myuser' 224s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 224s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 224s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 224s # create directory 224s ok 14 - pg_backupcluster 17 main createdirectory 224s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 224s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 224s # dump 225s ok 17 - systemctl start pg_dump@17-main 225s ok 18 - dump created in /var/backups/postgresql/17-main/2025-09-24T103823Z.dump 225s ok 19 - /var/backups/postgresql/17-main/2025-09-24T103823Z.dump owned by uid postgres 225s ok 20 - /var/backups/postgresql/17-main/2025-09-24T103823Z.dump owned by gid postgres 225s # basebackup 225s ok 21 - systemctl start pg_receivewal@17-main 225s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 225s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 225s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 225s ok 25 - psql -c 'select pg_reload_conf()' 253s ok 26 - systemctl start pg_basebackup@17-main 253s ok 27 - dump created in /var/backups/postgresql/17-main/2025-09-24T103824Z.backup 253s ok 28 - /var/backups/postgresql/17-main/2025-09-24T103824Z.backup owned by uid postgres 253s ok 29 - /var/backups/postgresql/17-main/2025-09-24T103824Z.backup owned by gid postgres 253s # list 253s ok 30 - pg_backupcluster 17 main list 253s ok 31 - correct output of pg_backupcluster 17 main list 253s # more database changes 253s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 253s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 253s ok 34 - retrieve recovery timestamp 253s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 254s ok 36 - systemctl stop pg_receivewal@17-main 254s # restore /var/backups/postgresql/17-main/2025-09-24T103823Z.dump 255s ok 37 - pg_dropcluster 17 main --stop 258s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-09-24T103823Z.dump --start --datadir /var/lib/postgresql/17/snowflake 258s ok 39 - pg_lsclusters -h 258s ok 40 - correct output of pg_lsclusters -h 258s ok 41 - psql -XAtl 258s ok 42 - mydb locales 258s ok 43 - mydb grants 258s ok 44 - myicudb locales 258s ok 45 - psql -XAtc 'show work_mem' 258s ok 46 - correct output of psql -XAtc 'show work_mem' 258s ok 47 - psql -XAtc 'select * from foo' mydb 258s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 259s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 259s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 259s ok 51 - psql -XAtc '\drds' 259s ok 52 - correct output of psql -XAtc '\drds' 259s # restore /var/backups/postgresql/17-main/2025-09-24T103824Z.backup 260s ok 53 - pg_dropcluster 17 main --stop 263s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-09-24T103824Z.backup --start --datadir /var/lib/postgresql/17/snowflake 263s ok 55 - pg_lsclusters -h 263s ok 56 - correct output of pg_lsclusters -h 263s ok 57 - psql -XAtl 263s ok 58 - mydb locales 263s ok 59 - mydb grants 263s ok 60 - myicudb locales 263s ok 61 - psql -XAtc 'show work_mem' 263s ok 62 - correct output of psql -XAtc 'show work_mem' 263s ok 63 - psql -XAtc 'select * from foo' mydb 263s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 263s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 263s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 263s ok 67 - psql -XAtc '\drds' 263s ok 68 - correct output of psql -XAtc '\drds' 263s # restore /var/backups/postgresql/17-main/2025-09-24T103824Z.backup with WAL archive 264s ok 69 - pg_dropcluster 17 main --stop 267s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-09-24T103824Z.backup --start --archive --port 5430 267s ok 71 - pg_lsclusters -h 267s ok 72 - correct output of pg_lsclusters -h 267s ok 73 - psql -XAtc 'select * from foo order by t' mydb 267s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 267s # restore /var/backups/postgresql/17-main/2025-09-24T103824Z.backup with PITR 269s ok 75 - pg_dropcluster 17 main --stop 272s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-09-24T103824Z.backup --start --pitr '2025-09-24 10:38:52.168626+00 272s # ' 272s ok 77 - pg_lsclusters -h 272s ok 78 - correct output of pg_lsclusters -h 272s ok 79 - psql -XAtc 'select * from foo order by t' mydb 272s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 273s ok 81 - pg_dropcluster 17 main --stop 273s # Cleanup 273s ok 82 - Cleanup: No clusters left behind 273s ok 83 - No postgres processes left behind 273s ok 84 - No files in /etc/postgresql left behind 273s ok 85 - No files in /var/lib/postgresql left behind 273s ok 86 - No files in /var/run/postgresql left behind 273s ok 87 - No files in /var/log/postgresql left behind 273s ok 88 - PostgreSQL TCP ports are closed 273s ok 89 - Next free port is 5432 273s 1..89 273s ### End test 045_backup.t ### 273s 273s ### PostgreSQL test 050_encodings.t ### 273s 1..60 273s # Checking 17 ru_RU 276s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 277s ok 2 - psql -l succeeds 277s ok 3 - template1 is not UTF-8 encoded 277s ok 4 - creating test database 277s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 277s # create table t (x varchar); copy t from stdin" test 277s ok 6 - creating table with ISO-8859-5 characters 277s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 277s ok 8 - correct string in UTF-8 277s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 277s ok 10 - correct string in ISO-8859-5 277s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 277s # delete from t; copy t from stdin" test 277s ok 12 - creating table with UTF-8 characters 277s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 277s ok 14 - correct string in UTF-8 277s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 277s ok 16 - correct string in ISO-8859-1 277s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 277s ok 18 - Server error message has correct language and encoding 280s ok 19 - pg_ctlcluster 17 ru_RU restart 280s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 281s ok 21 - Dropping cluster 281s # Checking 17 ru_RU.UTF-8 284s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 285s ok 23 - psql -l succeeds 285s ok 24 - template1 is UTF-8 encoded 285s ok 25 - creating test database 285s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 285s # create table t (x varchar); copy t from stdin" test 285s ok 27 - creating table with ISO-8859-5 characters 285s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 285s ok 29 - correct string in UTF-8 285s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 285s ok 31 - correct string in ISO-8859-5 285s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 285s # delete from t; copy t from stdin" test 285s ok 33 - creating table with UTF-8 characters 285s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 285s ok 35 - correct string in UTF-8 285s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 285s ok 37 - correct string in ISO-8859-1 285s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 285s ok 39 - Server error message has correct language and encoding 287s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 287s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 288s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 288s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 288s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 288s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 288s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 288s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 289s ok 48 - Dropping cluster 289s # Check 17 locale environment variables 292s ok 49 - pg_createcluster: LC_ALL dominates LANG 292s ok 50 - psql -Atl --cluster 17/main 292s ok 51 - template1 is ASCII encoded 293s ok 52 - Dropping cluster 293s # Cleanup 293s ok 53 - Cleanup: No clusters left behind 293s ok 54 - No postgres processes left behind 293s ok 55 - No files in /etc/postgresql left behind 293s ok 56 - No files in /var/lib/postgresql left behind 293s ok 57 - No files in /var/run/postgresql left behind 293s ok 58 - No files in /var/log/postgresql left behind 293s ok 59 - PostgreSQL TCP ports are closed 293s ok 60 - Next free port is 5432 293s ### End test 050_encodings.t ### 293s 293s ### PostgreSQL test 052_upgrade_encodings.t ### 293s 1..1 293s ok 1 - only one major version installed, skipping upgrade tests 293s ### End test 052_upgrade_encodings.t ### 293s 293s ### PostgreSQL test 060_obsolete_confparams.t ### 293s ok 1 - only one major version installed, skipping upgrade tests 293s 1..1 293s ### End test 060_obsolete_confparams.t ### 293s 293s ### PostgreSQL test 070_non_postgres_clusters.t ### 293s 1..40 294s ok 1 - pg_createcluster 17 main for owner nobody 294s ok 2 - pg_ctlcluster 17 main start 294s ok 3 - start refused when config and data owners mismatch 296s ok 4 - pg_ctlcluster succeeds with owner nobody 296s ok 5 - pg_lsclusters -h 296s ok 6 - pg_lsclusters shows running cluster 296s ok 7 - postgres is running as user nobody 296s ok 8 - ls /tmp/.s.PGSQL.* 296s ok 9 - socket is in /tmp 296s ok 10 - /var/run/postgresql is empty 296s ok 11 - conf dir is owned by user 296s ok 12 - conf dir is owned by user's primary group 296s ok 13 - files are owned by user 296s ok 14 - files are owned by user's primary group 296s ok 15 - log file has 0640 permissions 296s ok 16 - log file is owned by user 296s ok 17 - log file is owned by user's primary group 296s ok 18 - only one major version installed, skipping upgrade test 296s ok 19 - ... 296s ok 20 - ... 296s ok 21 - ... 296s ok 22 - ... 296s ok 23 - ... 296s ok 24 - ... 296s ok 25 - ... 296s ok 26 - ... 296s ok 27 - ... 296s ok 28 - ... 297s ok 29 - pg_dropcluster 297s ok 30 - pg_lsclusters -h 297s ok 31 - No clusters left 297s ok 32 - No postgres processes left 297s # Cleanup 297s ok 33 - Cleanup: No clusters left behind 297s ok 34 - No postgres processes left behind 297s ok 35 - No files in /etc/postgresql left behind 297s ok 36 - No files in /var/lib/postgresql left behind 297s ok 37 - No files in /var/run/postgresql left behind 297s ok 38 - No files in /var/log/postgresql left behind 297s ok 39 - PostgreSQL TCP ports are closed 297s ok 40 - Next free port is 5432 297s ### End test 070_non_postgres_clusters.t ### 297s 297s ### PostgreSQL test 080_start.conf.t ### 297s 1..73 298s ok 1 - pg_createcluster 17 main 298s # start.conf auto 298s ok 2 - get_cluster_start_conf returns auto 298s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 298s ok 4 - start.conf contains auto 298s ok 5 - systemd generator links cluster 298s ok 6 - systemd generator links correct service file 300s ok 7 - /etc/init.d/postgresql start 17 300s ok 8 - correct output of /etc/init.d/postgresql start 17 300s ok 9 - pg_lsclusters -h 300s ok 10 - cluster is online 300s ok 11 - /etc/init.d/postgresql stop 17 300s ok 12 - correct output of /etc/init.d/postgresql stop 17 303s ok 13 - pg_lsclusters -h 303s ok 14 - cluster is down 303s # start.conf manual 303s ok 15 - get_cluster_start_conf returns manual 303s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 303s ok 17 - start.conf contains manual 303s ok 18 - systemd generator doesn't link cluster 303s ok 19 - /etc/init.d/postgresql start 17 303s ok 20 - correct output of /etc/init.d/postgresql start 17 303s ok 21 - pg_lsclusters -h 303s ok 22 - cluster is down 306s ok 23 - pg_ctlcluster 17 main start 306s ok 24 - correct output of pg_ctlcluster 17 main start 306s ok 25 - pg_lsclusters -h 306s ok 26 - cluster is online 306s ok 27 - pg_ctlcluster 17 main stop 306s ok 28 - correct output of pg_ctlcluster 17 main stop 306s ok 29 - pg_lsclusters -h 306s ok 30 - cluster is down 306s # start.conf disabled 306s ok 31 - get_cluster_start_conf returns disabled 306s ok 32 - systemd generator doesn't link cluster 306s ok 33 - /etc/init.d/postgresql start 17 306s ok 34 - correct output of /etc/init.d/postgresql start 17 306s ok 35 - pg_lsclusters -h 306s ok 36 - cluster is down 306s ok 37 - pg_ctlcluster 17 main start 306s ok 38 - correct output of pg_ctlcluster 17 main start 306s ok 39 - pg_lsclusters -h 306s ok 40 - cluster is down 308s ok 41 - pg_ctlcluster 17 main start 308s ok 42 - correct output of pg_ctlcluster 17 main start 308s ok 43 - pg_lsclusters -h 308s ok 44 - cluster is online 308s ok 45 - pg_ctlcluster 17 main stop 308s ok 46 - correct output of pg_ctlcluster 17 main stop 308s ok 47 - pg_lsclusters -h 308s ok 48 - cluster is down 312s ok 49 - pg_ctlcluster 17 main start 312s ok 50 - correct output of pg_ctlcluster 17 main start 312s ok 51 - pg_lsclusters -h 312s ok 52 - cluster is online 312s # test upgrade 312s ok 53 - only one major version installed, skipping upgrade test 312s ok 54 - ... 312s ok 55 - get_cluster_start_conf for old cluster returns manual 312s ok 56 - get_cluster_start_conf for new cluster returns manual 312s ok 57 - ... 312s ok 58 - dropping upgraded cluster 312s ok 59 - pg_lsclusters -h 312s ok 60 - no clusters any more 312s ok 61 - pg_createcluster 17 main --start-conf foo 312s ok 62 - pg_createcluster checks --start-conf validity 312s ok 63 - pg_createcluster checks --start-conf manual 312s ok 64 - get_cluster_start_conf returns manual 313s ok 65 - dropping cluster 313s # Cleanup 313s ok 66 - Cleanup: No clusters left behind 313s ok 67 - No postgres processes left behind 313s ok 68 - No files in /etc/postgresql left behind 313s ok 69 - No files in /var/lib/postgresql left behind 313s ok 70 - No files in /var/run/postgresql left behind 313s ok 71 - No files in /var/log/postgresql left behind 313s ok 72 - PostgreSQL TCP ports are closed 313s ok 73 - Next free port is 5432 313s ### End test 080_start.conf.t ### 313s 313s ### PostgreSQL test 085_pg_ctl.conf.t ### 313s 1..33 313s ok 1 - prlimit --core=0:unlimited --pid=17051 313s ok 2 - set core file size to unlimited 313s ok 3 - sh -c 'ulimit -Hc' 313s ok 4 - core file size is unlimited 314s ok 5 - pg_createcluster 17 main 314s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 316s ok 7 - pg_ctlcluster 17 main start 316s ok 8 - starting cluster as root 316s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 316s ok 10 - soft core size is 0 316s # hard core file size limit of root-started postgres process is unlimited 316s ok 11 - set pg_ctl default option to -c 318s ok 12 - pg_ctlcluster 17 main restart 318s ok 13 - restarting cluster as root 318s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 318s ok 15 - soft core size is unlimited 319s ok 16 - pg_ctlcluster 17 main stop 319s ok 17 - stopping cluster 319s ok 18 - restored pg_ctl default option 321s ok 19 - pg_ctlcluster 17 main start -- -c 321s ok 20 - starting cluster with -c on the command line as postgres 321s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 321s ok 22 - soft core size is unlimited 321s ok 23 - pg_ctlcluster 17 main stop 321s ok 24 - stopping cluster 322s ok 25 - dropping cluster 322s # Cleanup 322s ok 26 - Cleanup: No clusters left behind 322s ok 27 - No postgres processes left behind 322s ok 28 - No files in /etc/postgresql left behind 322s ok 29 - No files in /var/lib/postgresql left behind 322s ok 30 - No files in /var/run/postgresql left behind 322s ok 31 - No files in /var/log/postgresql left behind 322s ok 32 - PostgreSQL TCP ports are closed 322s ok 33 - Next free port is 5432 322s ### End test 085_pg_ctl.conf.t ### 322s 322s ### PostgreSQL test 090_multicluster.t ### 322s 1..125 323s ok 1 - pg_createcluster 17 old 323s ok 2 - pg_createcluster 17 new1 324s ok 3 - pg_createcluster 17 new2 326s ok 4 - starting cluster 17/old 328s ok 5 - starting cluster 17/new1 331s ok 6 - starting cluster 17/new2 331s ok 7 - pg_lsclusters -h | sort -k3 331s ok 8 - clusters have the correct ports, skipping used 5433 331s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 331s ok 10 - createdb --version 331s ok 11 - pg_wrapper selects port 5432 as default cluster 331s ok 12 - createdb --cluster 17/new1 --version 331s ok 13 - pg_wrapper --cluster works 331s ok 14 - createdb --cluster 17/foo --version 331s ok 15 - pg_wrapper --cluster errors out for invalid cluster 331s ok 16 - createdb --cluster 17/new1 test 331s ok 17 - correct output of createdb --cluster 17/new1 test 331s ok 18 - psql -Atl --cluster 17/new1 331s ok 19 - test db appears in cluster new1 331s ok 20 - psql -Atl --cluster 17/new2 331s ok 21 - test db does not appear in cluster new2 331s ok 22 - psql -Atl 331s ok 23 - test db does not appear in default cluster 331s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 331s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 331s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 331s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 331s ok 28 - psql -Atl --cluster 17/localhost:5434 331s ok 29 - test db appears in cluster 17/localhost:5434 331s ok 30 - psql -Atl --cluster 17/localhost:5440 331s ok 31 - test db does not appear in cluster 17/localhost:5440 331s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 331s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 331s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 331s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 331s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 331s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 331s ok 38 - psql -Atl --cluster 6.4/localhost: 331s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 331s ok 40 - psql -Atl 331s ok 41 - PGCLUSTER selection (1) 331s ok 42 - psql -Atl 331s ok 43 - PGCLUSTER selection (2) 331s ok 44 - psql -l 331s ok 45 - invalid PGCLUSTER value 331s ok 46 - createdb --version 331s ok 47 - PGCLUSTER network cluster selection (1) 331s ok 48 - psql -Atl 331s ok 49 - PGCLUSTER network cluster selection (2) 331s ok 50 - psql -Atl 331s ok 51 - PGCLUSTER network cluster selection (3) 331s ok 52 - LC_MESSAGES=C psql -Atl 331s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 331s ok 54 - psql -Atc "show port" template1 331s ok 55 - PGPORT selection (1) 331s ok 56 - psql -Atc "show port" template1 331s ok 57 - PGPORT selection (2) 331s ok 58 - createdb --version 331s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 331s ok 60 - psql -Atc "show port" template1 331s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 332s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 332s ok 63 - PGDATABASE environment variable works 332s ok 64 - createdb --version 332s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 332s ok 66 - createdb --cluster 17/new1 --version 332s ok 67 - pg_wrapper --cluster works with empty user_clusters 332s ok 68 - createdb --version 332s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 332s ok 70 - psql -Atc "select current_database()" 332s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 332s ok 72 - psql -Atc 'select current_database()' 332s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 332s ok 74 - createdb --version 332s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 332s ok 76 - createdb --version 332s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 332s ok 78 - createdb --version 332s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 332s ok 80 - createdb --version 332s ok 81 - pg_wrapper selects correct version with per-user user_clusters 332s ok 82 - createdb --version 332s ok 83 - pg_wrapper selects correct version with per-user user_clusters 332s ok 84 - createdb --version 332s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 332s ok 86 - psql -Atl 332s ok 87 - $PGHOST overrides user_clusters 332s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 332s ok 89 - --cluster overrides $PGHOST 332s ok 90 - createdb --version 332s ok 91 - pg_wrapper ignores invalid lines in user_clusters 332s ok 92 - psql -Atc 'select current_database()' 332s ok 93 - pg_service conf selection 1 332s ok 94 - psql -Atc 'select current_database()' 332s ok 95 - pg_service conf selection 2 332s ok 96 - psql -Atc 'select current_database()' 332s ok 97 - pg_service conf selection 3 332s ok 98 - stopping cluster 17/old 334s ok 99 - restarting cluster 17/old 334s ok 100 - pg_lsclusters -h | sort -k3 334s # Failed test 'port of first cluster was successfully changed' 334s # at t/TestLib.pm line 239. 334s # '17 old 5435 online postgres /var/lib/postgresql/17/old /var/log/postgresql/postgresql-17-old.log 334s # 17 new1 5434 online postgres /var/lib/postgresql/17/new1 /var/log/postgresql/postgresql-17-new1.log 334s # 17 new2 5440 online postgres /var/lib/postgresql/17/new2 /var/log/postgresql/postgresql-17-new2.log 334s # ' 334s # doesn't match '(?^s:.*5434.*5435.*5440.*)' 334s not ok 101 - port of first cluster was successfully changed 334s ok 102 - psql -l 334s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 335s ok 104 - psql -Atl --cluster 17/new1 335s ok 105 - --cluster selects appropriate cluster 335s ok 106 - psql -Atl -p 5434 335s ok 107 - -p selects appropriate cluster 335s ok 108 - psql -Atlp 5434 335s ok 109 - -Atlp selects appropriate cluster 335s ok 110 - psql -Atl --port 5434 335s ok 111 - --port selects appropriate cluster 335s ok 112 - env PGPORT=5434 psql -Atl 335s ok 113 - $PGPORT selects appropriate cluster 335s ok 114 - Restoring original /etc/postgresql-common/user_clusters 336s ok 115 - dropping 17/new1 337s ok 116 - dropping 17/new2 338s ok 117 - dropping 17/old 338s # Cleanup 338s ok 118 - Cleanup: No clusters left behind 338s ok 119 - No postgres processes left behind 338s ok 120 - No files in /etc/postgresql left behind 338s ok 121 - No files in /var/lib/postgresql left behind 338s ok 122 - No files in /var/run/postgresql left behind 338s ok 123 - No files in /var/log/postgresql left behind 338s ok 124 - PostgreSQL TCP ports are closed 338s ok 125 - Next free port is 5432 338s # Looks like you failed 1 test of 125. 338s ### End test 090_multicluster.t ### 338s 338s ### PostgreSQL test 110_integrate_cluster.t ### 338s 1..32 339s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/BHpjof3TUi/c/postgres 339s ok 2 - creating raw initdb cluster for user postgres 339s ok 3 - pg_createcluster 17 postgres -d /tmp/BHpjof3TUi/c/postgres 339s ok 4 - integrating postgres cluster 339s ok 5 - pg_lsclusters 339s ok 6 - correct pg_lsclusters output 341s ok 7 - pg_ctlcluster 17 postgres start 341s ok 8 - starting cluster postgres 341s ok 9 - pg_lsclusters 341s ok 10 - correct pg_lsclusters output 342s ok 11 - dropping cluster postgres 342s ok 12 - No files in temporary cluster dir left behind 343s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/BHpjof3TUi/c/nobody 343s ok 14 - creating raw initdb cluster for user nobody 343s ok 15 - pg_createcluster 17 nobody -d /tmp/BHpjof3TUi/c/nobody 343s ok 16 - integrating nobody cluster 343s ok 17 - pg_lsclusters 343s ok 18 - correct pg_lsclusters output 345s ok 19 - pg_ctlcluster 17 nobody start 345s ok 20 - starting cluster nobody 345s ok 21 - pg_lsclusters 345s ok 22 - correct pg_lsclusters output 347s ok 23 - dropping cluster nobody 347s ok 24 - No files in temporary cluster dir left behind 347s # Cleanup 347s ok 25 - Cleanup: No clusters left behind 347s ok 26 - No postgres processes left behind 347s ok 27 - No files in /etc/postgresql left behind 347s ok 28 - No files in /var/lib/postgresql left behind 347s ok 29 - No files in /var/run/postgresql left behind 347s ok 30 - No files in /var/log/postgresql left behind 347s ok 31 - PostgreSQL TCP ports are closed 347s ok 32 - Next free port is 5432 347s ### End test 110_integrate_cluster.t ### 347s 347s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 347s 1..1 347s ok 1 - only one major version installed, skipping upgrade tests 347s ### End test 120_pg_upgradecluster_scripts.t ### 347s 347s ### PostgreSQL test 130_nonroot_admin.t ### 347s 1..22 349s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 349s ok 2 - pg_lsclusters -h 349s ok 3 - correct output of pg_lsclusters -h 349s ok 4 - psql -Atl 349s ok 5 - correct output of psql -Atl 350s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 350s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 350s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 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 130_nonroot_admin.t ### 350s 350s ### PostgreSQL test 135_pg_virtualenv.t ### 350s 1..20 354s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 354s ok 2 - running pg_virtualenv as root 357s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 357s ok 4 - running pg_virtualenv as postgres 359s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 359s ok 6 - running pg_virtualenv as nobody 362s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 362s ok 8 - running fakeroot pg_virtualenv as root 365s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 365s ok 10 - running fakeroot pg_virtualenv as postgres 368s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 368s ok 12 - running fakeroot pg_virtualenv as nobody 368s # Cleanup 368s ok 13 - Cleanup: No clusters left behind 368s ok 14 - No postgres processes left behind 368s ok 15 - No files in /etc/postgresql left behind 368s ok 16 - No files in /var/lib/postgresql left behind 368s ok 17 - No files in /var/run/postgresql left behind 368s ok 18 - No files in /var/log/postgresql left behind 368s ok 19 - PostgreSQL TCP ports are closed 368s ok 20 - Next free port is 5432 368s ### End test 135_pg_virtualenv.t ### 368s 368s ### PostgreSQL test 140_pg_config.t ### 368s 1..38 368s # Multiarch is enabled 368s # checking version specific output for 17 368s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 368s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 368s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 368s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 368s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 368s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 368s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 368s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 368s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 368s # checking pg_config output (should behave like version 17) 368s ok 15 - pg_config 368s ok 16 - correct output of pg_config 368s ok 17 - pg_config --help 368s ok 18 - correct output of pg_config --help 368s ok 19 - pg_config --pgxs 368s ok 20 - correct output of pg_config --pgxs 368s ok 21 - pg_config --libdir 368s ok 22 - correct output of pg_config --libdir 368s ok 23 - pg_config --pkglibdir 368s ok 24 - correct output of pg_config --pkglibdir 368s ok 25 - pg_config --bindir 368s ok 26 - correct output of pg_config --bindir 368s # checking pg_config.libpq-dev output (should behave like version 17) 368s ok 27 - pg_config.libpq-dev 368s ok 28 - correct output of pg_config.libpq-dev 368s ok 29 - pg_config.libpq-dev --help 368s ok 30 - correct output of pg_config.libpq-dev --help 369s ok 31 - pg_config.libpq-dev --pgxs 369s ok 32 - correct output of pg_config.libpq-dev --pgxs 369s ok 33 - pg_config.libpq-dev --libdir 369s ok 34 - correct output of pg_config.libpq-dev --libdir 369s ok 35 - pg_config.libpq-dev --pkglibdir 369s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 369s ok 37 - pg_config.libpq-dev --bindir 369s ok 38 - correct output of pg_config.libpq-dev --bindir 369s ### End test 140_pg_config.t ### 369s 369s ### PostgreSQL test 150_tsearch_stemming.t ### 369s 1..37 369s ok 1 - pg_updatedicts succeeded 369s ok 2 - pg_updatedicts created en_us.affix 369s ok 3 - pg_updatedicts created en_us.dict 369s ok 4 - pg_updatedicts created 17 en_us.affix symlink 369s ok 5 - pg_updatedicts created 17 en_us.dict symlink 372s ok 6 - pg_createcluster 17 main 372s ok 7 - createdb fts 372s ok 8 - correct output of createdb fts 372s ok 9 - creating en_US full text search configuration 372s ok 10 - creating data table and search index 372s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 372s ok 12 - stem search of correct word 372s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 372s ok 14 - stem search of correct word 372s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 372s ok 16 - stem search of unknown word 372s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 372s ok 18 - full text search, exact word 372s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 372s ok 20 - full text search for word stem 372s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 372s ok 22 - full text search for word substring fails 372s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 372s ok 24 - full text search, exact unicode word 372s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 372s ok 26 - full text search for unicode word stem 372s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 372s ok 28 - full text search for unicode word substring fails 373s ok 29 373s # Cleanup 373s ok 30 - Cleanup: No clusters left behind 373s ok 31 - No postgres processes left behind 373s ok 32 - No files in /etc/postgresql left behind 373s ok 33 - No files in /var/lib/postgresql left behind 373s ok 34 - No files in /var/run/postgresql left behind 373s ok 35 - No files in /var/log/postgresql left behind 373s ok 36 - PostgreSQL TCP ports are closed 373s ok 37 - Next free port is 5432 373s ### End test 150_tsearch_stemming.t ### 373s 373s ### PostgreSQL test 160_alternate_confroot.t ### 373s 1..28 376s ok 1 376s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 376s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 376s ok 4 - pg_lsclusters -h 376s ok 5 - correct output of pg_lsclusters -h 376s ok 6 - psql -Atl 376s ok 7 - correct output of psql -Atl 376s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 376s ok 9 - ... 376s ok 10 - ... 376s ok 11 - ... 376s ok 12 - ... 376s ok 13 - ... 376s ok 14 - ... 376s ok 15 - pg_dropcluster 17 test --stop 376s ok 16 - correct output of pg_dropcluster 17 test --stop 376s ok 17 - pg_lsclusters -h 376s ok 18 - correct output of pg_lsclusters -h 376s ok 19 - No files in root/data left behind 376s ok 20 - No cruft in root dir left behind 376s # Cleanup 376s ok 21 - Cleanup: No clusters left behind 376s ok 22 - No postgres processes left behind 376s ok 23 - No files in /etc/postgresql left behind 376s ok 24 - No files in /var/lib/postgresql left behind 376s ok 25 - No files in /var/run/postgresql left behind 376s ok 26 - No files in /var/log/postgresql left behind 377s ok 27 - PostgreSQL TCP ports are closed 377s ok 28 - Next free port is 5432 377s ### End test 160_alternate_confroot.t ### 377s 377s ### PostgreSQL test 170_extensions.t ### 377s # Running tests for 17 379s ok 1 - pg_createcluster 17 main 380s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 380s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 380s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 380s ok 5 - extension amcheck installs without error 380s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 380s ok 7 - extension amcheck removes without error 380s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 380s ok 9 - extension autoinc installs without error 380s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 380s ok 11 - extension autoinc removes without error 380s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 380s ok 13 - extension bloom installs without error 380s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 380s ok 15 - extension bloom removes without error 380s ok 16 - psql -qc 'CREATE EXTENSION plperl' 380s ok 17 - bool_plperl dependency plperl installs without error 380s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 380s ok 19 - extension bool_plperl installs without error 380s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 380s ok 21 - extension bool_plperl removes without error 380s ok 22 - psql -qc 'DROP EXTENSION plperl' 380s ok 23 - bool_plperl dependency extension plperl removes without error 380s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 380s ok 25 - bool_plperlu dependency plperlu installs without error 380s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 380s ok 27 - extension bool_plperlu installs without error 380s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 380s ok 29 - extension bool_plperlu removes without error 380s ok 30 - psql -qc 'DROP EXTENSION plperlu' 380s ok 31 - bool_plperlu dependency extension plperlu removes without error 380s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 380s ok 33 - extension btree_gin installs without error 380s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 380s ok 35 - extension btree_gin removes without error 380s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 380s ok 37 - extension btree_gist installs without error 380s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 380s ok 39 - extension btree_gist removes without error 380s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 380s ok 41 - extension citext installs without error 380s ok 42 - psql -qc 'DROP EXTENSION "citext"' 380s ok 43 - extension citext removes without error 380s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 380s ok 45 - extension cube installs without error 380s ok 46 - psql -qc 'DROP EXTENSION "cube"' 380s ok 47 - extension cube removes without error 380s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 380s ok 49 - extension dblink installs without error 380s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 380s ok 51 - extension dblink removes without error 380s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 380s ok 53 - extension dict_int installs without error 381s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 381s ok 55 - extension dict_int removes without error 381s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 381s ok 57 - extension dict_xsyn installs without error 381s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 381s ok 59 - extension dict_xsyn removes without error 381s ok 60 - psql -qc 'CREATE EXTENSION cube' 381s ok 61 - earthdistance dependency cube installs without error 381s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 381s ok 63 - extension earthdistance installs without error 381s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 381s ok 65 - extension earthdistance removes without error 381s ok 66 - psql -qc 'DROP EXTENSION cube' 381s ok 67 - earthdistance dependency extension cube removes without error 381s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 381s ok 69 - extension file_fdw installs without error 381s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 381s ok 71 - extension file_fdw removes without error 381s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 381s ok 73 - extension fuzzystrmatch installs without error 381s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 381s ok 75 - extension fuzzystrmatch removes without error 381s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 381s ok 77 - extension hstore installs without error 381s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 381s ok 79 - extension hstore removes without error 381s ok 80 - psql -qc 'CREATE EXTENSION hstore' 381s ok 81 - hstore_plperl dependency hstore installs without error 381s ok 82 - psql -qc 'CREATE EXTENSION plperl' 381s ok 83 - hstore_plperl dependency plperl installs without error 381s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 381s ok 85 - extension hstore_plperl installs without error 381s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 381s ok 87 - extension hstore_plperl removes without error 381s ok 88 - psql -qc 'DROP EXTENSION hstore' 381s ok 89 - hstore_plperl dependency extension hstore removes without error 381s ok 90 - psql -qc 'DROP EXTENSION plperl' 381s ok 91 - hstore_plperl dependency extension plperl removes without error 381s ok 92 - psql -qc 'CREATE EXTENSION hstore' 381s ok 93 - hstore_plperlu dependency hstore installs without error 381s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 381s ok 95 - hstore_plperlu dependency plperlu installs without error 381s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 381s ok 97 - extension hstore_plperlu installs without error 381s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 381s ok 99 - extension hstore_plperlu removes without error 381s ok 100 - psql -qc 'DROP EXTENSION hstore' 381s ok 101 - hstore_plperlu dependency extension hstore removes without error 381s ok 102 - psql -qc 'DROP EXTENSION plperlu' 381s ok 103 - hstore_plperlu dependency extension plperlu removes without error 381s ok 104 - psql -qc 'CREATE EXTENSION hstore' 381s ok 105 - hstore_plpython3u dependency hstore installs without error 381s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 381s ok 107 - hstore_plpython3u dependency plpython3u installs without error 381s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 381s ok 109 - extension hstore_plpython3u installs without error 381s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 381s ok 111 - extension hstore_plpython3u removes without error 382s ok 112 - psql -qc 'DROP EXTENSION hstore' 382s ok 113 - hstore_plpython3u dependency extension hstore removes without error 382s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 382s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 382s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 382s ok 117 - extension insert_username installs without error 382s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 382s ok 119 - extension insert_username removes without error 382s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 382s ok 121 - extension intagg installs without error 382s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 382s ok 123 - extension intagg removes without error 382s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 382s ok 125 - extension intarray installs without error 382s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 382s ok 127 - extension intarray removes without error 382s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 382s ok 129 - extension isn installs without error 382s ok 130 - psql -qc 'DROP EXTENSION "isn"' 382s ok 131 - extension isn removes without error 382s ok 132 - psql -qc 'CREATE EXTENSION plperl' 382s ok 133 - jsonb_plperl dependency plperl installs without error 382s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 382s ok 135 - extension jsonb_plperl installs without error 382s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 382s ok 137 - extension jsonb_plperl removes without error 382s ok 138 - psql -qc 'DROP EXTENSION plperl' 382s ok 139 - jsonb_plperl dependency extension plperl removes without error 382s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 382s ok 141 - jsonb_plperlu dependency plperlu installs without error 382s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 382s ok 143 - extension jsonb_plperlu installs without error 382s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 382s ok 145 - extension jsonb_plperlu removes without error 382s ok 146 - psql -qc 'DROP EXTENSION plperlu' 382s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 382s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 382s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 382s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 382s ok 151 - extension jsonb_plpython3u installs without error 382s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 382s ok 153 - extension jsonb_plpython3u removes without error 382s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 382s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 382s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 382s ok 157 - extension lo installs without error 382s ok 158 - psql -qc 'DROP EXTENSION "lo"' 382s ok 159 - extension lo removes without error 382s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 382s ok 161 - extension ltree installs without error 382s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 382s ok 163 - extension ltree removes without error 382s ok 164 - psql -qc 'CREATE EXTENSION ltree' 382s ok 165 - ltree_plpython3u dependency ltree installs without error 382s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 382s ok 167 - ltree_plpython3u dependency plpython3u installs without error 383s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 383s ok 169 - extension ltree_plpython3u installs without error 383s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 383s ok 171 - extension ltree_plpython3u removes without error 383s ok 172 - psql -qc 'DROP EXTENSION ltree' 383s ok 173 - ltree_plpython3u dependency extension ltree removes without error 383s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 383s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 383s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 383s ok 177 - extension moddatetime installs without error 383s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 383s ok 179 - extension moddatetime removes without error 383s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 383s ok 181 - extension pageinspect installs without error 383s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 383s ok 183 - extension pageinspect removes without error 383s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 383s ok 185 - extension pg_buffercache installs without error 383s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 383s ok 187 - extension pg_buffercache removes without error 383s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 383s ok 189 - extension pg_freespacemap installs without error 383s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 383s ok 191 - extension pg_freespacemap removes without error 383s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 383s ok 193 - extension pg_prewarm installs without error 383s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 383s ok 195 - extension pg_prewarm removes without error 383s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 383s ok 197 - extension pg_stat_statements installs without error 383s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 383s ok 199 - extension pg_stat_statements removes without error 383s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 383s ok 201 - extension pg_surgery installs without error 383s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 383s ok 203 - extension pg_surgery removes without error 383s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 383s ok 205 - extension pg_trgm installs without error 383s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 383s ok 207 - extension pg_trgm removes without error 383s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 383s ok 209 - extension pg_visibility installs without error 383s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 383s ok 211 - extension pg_visibility removes without error 383s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 383s ok 213 - extension pg_walinspect installs without error 383s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 383s ok 215 - extension pg_walinspect removes without error 383s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 383s ok 217 - extension pgcrypto installs without error 383s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 383s ok 219 - extension pgcrypto removes without error 383s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 383s ok 221 - extension pgrowlocks installs without error 383s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 383s ok 223 - extension pgrowlocks removes without error 384s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 384s ok 225 - extension pgstattuple installs without error 384s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 384s ok 227 - extension pgstattuple removes without error 384s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 384s ok 229 - extension plperl installs without error 384s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 384s ok 231 - extension plperl removes without error 384s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 384s ok 233 - extension plperlu installs without error 384s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 384s ok 235 - extension plperlu removes without error 384s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 384s ok 237 - extension plpython3u installs without error 384s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 384s ok 239 - extension plpython3u removes without error 384s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 384s ok 241 - extension pltcl installs without error 384s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 384s ok 243 - extension pltcl removes without error 384s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 384s ok 245 - extension pltclu installs without error 384s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 384s ok 247 - extension pltclu removes without error 384s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 384s ok 249 - extension postgres_fdw installs without error 384s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 384s ok 251 - extension postgres_fdw removes without error 384s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 384s ok 253 - extension refint installs without error 384s ok 254 - psql -qc 'DROP EXTENSION "refint"' 384s ok 255 - extension refint removes without error 384s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 384s ok 257 - extension seg installs without error 384s ok 258 - psql -qc 'DROP EXTENSION "seg"' 384s ok 259 - extension seg removes without error 384s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 384s ok 261 - extension sslinfo installs without error 384s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 384s ok 263 - extension sslinfo removes without error 384s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 384s ok 265 - extension tablefunc installs without error 384s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 384s ok 267 - extension tablefunc removes without error 384s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 384s ok 269 - extension tcn installs without error 384s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 384s ok 271 - extension tcn removes without error 384s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 384s ok 273 - extension tsm_system_rows installs without error 384s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 384s ok 275 - extension tsm_system_rows removes without error 384s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 384s ok 277 - extension tsm_system_time installs without error 384s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 384s ok 279 - extension tsm_system_time removes without error 384s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 384s ok 281 - extension unaccent installs without error 385s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 385s ok 283 - extension unaccent removes without error 385s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 385s ok 285 - extension uuid-ossp installs without error 385s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 385s ok 287 - extension uuid-ossp removes without error 385s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 385s ok 289 - extension xml2 installs without error 385s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 385s ok 291 - extension xml2 removes without error 386s ok 292 - pg_dropcluster 17 main 386s # Cleanup 386s ok 293 - Cleanup: No clusters left behind 386s ok 294 - No postgres processes left behind 386s ok 295 - No files in /etc/postgresql left behind 386s ok 296 - No files in /var/lib/postgresql left behind 386s ok 297 - No files in /var/run/postgresql left behind 386s ok 298 - No files in /var/log/postgresql left behind 386s ok 299 - PostgreSQL TCP ports are closed 386s ok 300 - Next free port is 5432 386s 1..300 386s ### End test 170_extensions.t ### 386s 386s ### PostgreSQL test 180_ecpg.t ### 386s 1..14 386s ok 1 - ecpg test.pgc 386s ok 2 - ecpg processing 386s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 386s ok 4 - compiling ecpg output 393s ok 5 - pg_virtualenv /tmp/tmp.kHoKFoqvg9/test 393s ok 6 - test program runs and gives correct output 393s # Cleanup 393s ok 7 - Cleanup: No clusters left behind 393s ok 8 - No postgres processes left behind 393s ok 9 - No files in /etc/postgresql left behind 393s ok 10 - No files in /var/lib/postgresql left behind 393s ok 11 - No files in /var/run/postgresql left behind 393s ok 12 - No files in /var/log/postgresql left behind 393s ok 13 - PostgreSQL TCP ports are closed 393s ok 14 - Next free port is 5432 393s ### End test 180_ecpg.t ### 393s 393s ### PostgreSQL test 190_pg_buildext.t ### 393s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 393s 1..1 393s ### End test 190_pg_buildext.t ### 393s 393s ### PostgreSQL test 200_maintscripts.t ### 393s 1..15 393s # We are running systemd 396s ok 1 - pg_createcluster 17 main --start 396s ok 2 - postmaster PID is 22083 397s ok 3 - apt-get update -q 397s # postgresql-common: 397s # Installed: 282 397s # Candidate: 282 397s # Version table: 397s # *** 282 500 397s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 397s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 397s # 100 /var/lib/dpkg/status 399s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 399s # postgresql-common: 399s # Installed: 282 399s # Candidate: 282 399s # Version table: 399s # *** 282 500 399s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 399s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 399s # 100 /var/lib/dpkg/status 399s ok 5 - postmaster PID is 22083 399s ok 6 - postmaster was not restarted 400s ok 7 - pg_dropcluster 17 main --stop 400s # Cleanup 400s ok 8 - Cleanup: No clusters left behind 400s ok 9 - No postgres processes left behind 400s ok 10 - No files in /etc/postgresql left behind 400s ok 11 - No files in /var/lib/postgresql left behind 400s ok 12 - No files in /var/run/postgresql left behind 400s ok 13 - No files in /var/log/postgresql left behind 400s ok 14 - PostgreSQL TCP ports are closed 400s ok 15 - Next free port is 5432 400s ### End test 200_maintscripts.t ### 400s 400s Failed tests: ./t/090_multicluster.t 400s 401s autopkgtest [10:41:20]: test run-testsuite: -----------------------] 401s autopkgtest [10:41:20]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 401s run-testsuite FAIL non-zero exit status 1 401s autopkgtest [10:41:20]: test run-testsuite: - - - - - - - - - - stderr - - - - - - - - - - 401s # Failed test 'port of first cluster was successfully changed' 401s # at t/TestLib.pm line 239. 401s # '17 old 5435 online postgres /var/lib/postgresql/17/old /var/log/postgresql/postgresql-17-old.log 401s # 17 new1 5434 online postgres /var/lib/postgresql/17/new1 /var/log/postgresql/postgresql-17-new1.log 401s # 17 new2 5440 online postgres /var/lib/postgresql/17/new2 /var/log/postgresql/postgresql-17-new2.log 401s # ' 401s # doesn't match '(?^s:.*5434.*5435.*5440.*)' 401s # Looks like you failed 1 test of 125. 402s autopkgtest [10:41:21]: test installcheck: preparing testbed 421s Creating nova instance adt-questing-amd64-postgresql-17-20250924-103439-juju-7f2275-prod-proposed-migration-environment-15-09b99f8e-6bd4-4ed9-9f98-4838a0a824f6 from image adt/ubuntu-questing-amd64-server-20250924.img (UUID f8a6041a-8470-4763-9edd-b0ccb492ef61)... 454s autopkgtest [10:42:13]: testbed dpkg architecture: amd64 454s autopkgtest [10:42:13]: testbed apt version: 3.1.5ubuntu2 454s autopkgtest [10:42:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 454s autopkgtest [10:42:13]: testbed release detected to be: questing 455s autopkgtest [10:42:14]: updating testbed package index (apt update) 455s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [265 kB] 455s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 455s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 455s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 455s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [179 kB] 455s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [12.5 kB] 456s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [5920 B] 456s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [33.7 kB] 456s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [58.5 kB] 456s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [20.7 kB] 456s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 c-n-f Metadata [408 B] 456s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 Packages [43.9 kB] 456s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 c-n-f Metadata [120 B] 456s Get:14 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [65.2 kB] 456s Get:15 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [146 kB] 456s Get:16 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 c-n-f Metadata [8004 B] 456s Get:17 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [2072 B] 456s Get:18 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [4696 B] 456s Get:19 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 c-n-f Metadata [412 B] 457s Fetched 846 kB in 1s (1049 kB/s) 457s Reading package lists... 458s Hit:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease 458s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 458s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 458s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 458s Reading package lists... 458s Reading package lists... 459s Building dependency tree... 459s Reading state information... 459s Calculating upgrade... 459s The following packages will be upgraded: 459s rust-coreutils 459s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 459s Need to get 3347 kB of archives. 459s After this operation, 48.1 kB of additional disk space will be used. 459s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 rust-coreutils amd64 0.2.2-0ubuntu1 [3347 kB] 459s dpkg-preconfigure: unable to re-open stdin: No such file or directory 459s Fetched 3347 kB in 0s (7490 kB/s) 460s (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 ... 78099 files and directories currently installed.) 460s Preparing to unpack .../rust-coreutils_0.2.2-0ubuntu1_amd64.deb ... 460s Unpacking rust-coreutils (0.2.2-0ubuntu1) over (0.1.0+git20250813.4af2a84-0ubuntu7) ... 460s Setting up rust-coreutils (0.2.2-0ubuntu1) ... 460s Processing triggers for man-db (2.13.1-1) ... 460s autopkgtest [10:42:19]: upgrading testbed (apt dist-upgrade and autopurge) 460s Reading package lists... 461s Building dependency tree... 461s Reading state information... 461s Calculating upgrade... 461s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 461s Reading package lists... 461s Building dependency tree... 461s Reading state information... 461s Solving dependencies... 461s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 463s Reading package lists... 464s Building dependency tree... 464s Reading state information... 464s Solving dependencies... 464s The following NEW packages will be installed: 464s build-essential clang-20 cpp cpp-15 cpp-15-x86-64-linux-gnu 464s cpp-x86-64-linux-gnu g++ g++-15 g++-15-x86-64-linux-gnu g++-x86-64-linux-gnu 464s gcc gcc-13-base gcc-15 gcc-15-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 464s libcc1-0 libclang-common-20-dev libecpg-compat3 libecpg-dev libecpg6 464s libffi-dev libgc1 libgcc-13-dev libgcc-15-dev libgomp1 libhwasan0 libicu76 464s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl liblsan0 464s liblzma-dev libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 464s libpgtypes3 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-13-dev 464s libstdc++-15-dev libtcl8.6 libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 464s llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 464s postgresql-client-17 postgresql-client-common postgresql-common 464s postgresql-common-dev postgresql-doc-17 postgresql-plperl-17 464s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 464s ssl-cert tzdata-legacy zlib1g-dev 464s 0 upgraded, 70 newly installed, 0 to remove and 0 not upgraded. 464s Need to get 190 MB of archives. 464s After this operation, 940 MB of additional disk space will be used. 464s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 464s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-common all 282 [48.7 kB] 464s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 464s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 464s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common-dev all 282 [73.9 kB] 464s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 464s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common all 282 [101 kB] 464s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 libisl23 amd64 0.27-1 [685 kB] 464s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 libmpc3 amd64 1.3.1-1build3 [57.0 kB] 464s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [12.9 MB] 465s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-15 amd64 15.2.0-4ubuntu4 [1028 B] 465s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [5746 B] 465s Get:13 http://ftpmaster.internal/ubuntu questing/main amd64 cpp amd64 4:15.2.0-4ubuntu1 [22.4 kB] 465s Get:14 http://ftpmaster.internal/ubuntu questing/main amd64 libcc1-0 amd64 15.2.0-4ubuntu4 [47.4 kB] 465s Get:15 http://ftpmaster.internal/ubuntu questing/main amd64 libgomp1 amd64 15.2.0-4ubuntu4 [151 kB] 465s Get:16 http://ftpmaster.internal/ubuntu questing/main amd64 libitm1 amd64 15.2.0-4ubuntu4 [29.3 kB] 465s Get:17 http://ftpmaster.internal/ubuntu questing/main amd64 libasan8 amd64 15.2.0-4ubuntu4 [3071 kB] 465s Get:18 http://ftpmaster.internal/ubuntu questing/main amd64 liblsan0 amd64 15.2.0-4ubuntu4 [1360 kB] 465s Get:19 http://ftpmaster.internal/ubuntu questing/main amd64 libtsan2 amd64 15.2.0-4ubuntu4 [2757 kB] 466s Get:20 http://ftpmaster.internal/ubuntu questing/main amd64 libubsan1 amd64 15.2.0-4ubuntu4 [1210 kB] 466s Get:21 http://ftpmaster.internal/ubuntu questing/main amd64 libhwasan0 amd64 15.2.0-4ubuntu4 [1685 kB] 466s Get:22 http://ftpmaster.internal/ubuntu questing/main amd64 libquadmath0 amd64 15.2.0-4ubuntu4 [153 kB] 466s Get:23 http://ftpmaster.internal/ubuntu questing/main amd64 libgcc-15-dev amd64 15.2.0-4ubuntu4 [2864 kB] 466s Get:24 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [25.4 MB] 466s Get:25 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-15 amd64 15.2.0-4ubuntu4 [521 kB] 466s Get:26 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [1208 B] 466s Get:27 http://ftpmaster.internal/ubuntu questing/main amd64 gcc amd64 4:15.2.0-4ubuntu1 [5024 B] 466s Get:28 http://ftpmaster.internal/ubuntu questing/main amd64 libstdc++-15-dev amd64 15.2.0-4ubuntu4 [2572 kB] 466s Get:29 http://ftpmaster.internal/ubuntu questing/main amd64 g++-15-x86-64-linux-gnu amd64 15.2.0-4ubuntu4 [14.4 MB] 467s Get:30 http://ftpmaster.internal/ubuntu questing/main amd64 g++-15 amd64 15.2.0-4ubuntu4 [23.3 kB] 467s Get:31 http://ftpmaster.internal/ubuntu questing/main amd64 g++-x86-64-linux-gnu amd64 4:15.2.0-4ubuntu1 [966 B] 467s Get:32 http://ftpmaster.internal/ubuntu questing/main amd64 g++ amd64 4:15.2.0-4ubuntu1 [1100 B] 467s Get:33 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 build-essential amd64 12.12ubuntu2 [5256 B] 467s Get:34 http://ftpmaster.internal/ubuntu questing/universe amd64 gcc-13-base amd64 13.4.0-4ubuntu1 [54.7 kB] 467s Get:35 http://ftpmaster.internal/ubuntu questing/universe amd64 libgcc-13-dev amd64 13.4.0-4ubuntu1 [2669 kB] 467s Get:36 http://ftpmaster.internal/ubuntu questing/universe amd64 libstdc++-13-dev amd64 13.4.0-4ubuntu1 [2749 kB] 467s Get:37 http://ftpmaster.internal/ubuntu questing/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 467s Get:38 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc4 amd64 15.2.0-4ubuntu4 [47.8 kB] 467s Get:39 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc-13-dev amd64 13.4.0-4ubuntu1 [194 kB] 467s Get:40 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-common-20-dev amd64 1:20.1.8-0ubuntu4 [778 kB] 467s Get:41 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-linker-tools amd64 1:20.1.8-0ubuntu4 [1332 kB] 467s Get:42 http://ftpmaster.internal/ubuntu questing/universe amd64 clang-20 amd64 1:20.1.8-0ubuntu4 [77.5 kB] 467s Get:43 http://ftpmaster.internal/ubuntu questing/main amd64 libpgtypes3 amd64 17.6-1build1 [46.7 kB] 467s Get:44 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.6-1build1 [150 kB] 467s Get:45 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg6 amd64 17.6-1build1 [45.9 kB] 467s Get:46 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-compat3 amd64 17.6-1build1 [13.1 kB] 467s Get:47 http://ftpmaster.internal/ubuntu questing/main amd64 libssl-dev amd64 3.5.2-1ubuntu1 [3091 kB] 467s Get:48 http://ftpmaster.internal/ubuntu questing/main amd64 libpq-dev amd64 17.6-1build1 [160 kB] 467s Get:49 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-dev amd64 17.6-1build1 [275 kB] 467s Get:50 http://ftpmaster.internal/ubuntu questing/main amd64 libicu76 amd64 76.1-4ubuntu2 [11.2 MB] 467s Get:51 http://ftpmaster.internal/ubuntu questing/main amd64 libncurses-dev amd64 6.5+20250216-2build1 [408 kB] 467s Get:52 http://ftpmaster.internal/ubuntu questing/main amd64 libtcl8.6 amd64 8.6.17+dfsg-1 [1036 kB] 467s Get:53 http://ftpmaster.internal/ubuntu questing/main amd64 liblzma-dev amd64 5.8.1-1build2 [184 kB] 467s Get:54 http://ftpmaster.internal/ubuntu questing/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu2 [898 kB] 467s Get:55 http://ftpmaster.internal/ubuntu questing/main amd64 libxml2-dev amd64 2.14.5+dfsg-0.2 [757 kB] 467s Get:56 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.43-0.1 [172 kB] 467s Get:57 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-runtime amd64 1:20.1.8-0ubuntu4 [560 kB] 467s Get:58 http://ftpmaster.internal/ubuntu questing/universe amd64 libpfm4 amd64 4.13.0+git99-gc5587f9-1 [437 kB] 467s Get:59 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20 amd64 1:20.1.8-0ubuntu4 [19.7 MB] 468s Get:60 http://ftpmaster.internal/ubuntu questing/main amd64 libffi-dev amd64 3.5.2-1build1 [65.6 kB] 468s Get:61 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-tools amd64 1:20.1.8-0ubuntu4 [512 kB] 468s Get:62 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-dev amd64 1:20.1.8-0ubuntu4 [50.2 MB] 469s Get:63 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.6-1build1 [1379 kB] 469s Get:64 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.6-1build1 [16.0 MB] 469s Get:65 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-doc-17 all 17.6-1build1 [2148 kB] 469s Get:66 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plperl-17 amd64 17.6-1build1 [69.2 kB] 469s Get:67 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plpython3-17 amd64 17.6-1build1 [79.5 kB] 469s Get:68 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-pltcl-17 amd64 17.6-1build1 [32.8 kB] 469s Get:69 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-17 amd64 17.6-1build1 [1404 kB] 469s Get:70 http://ftpmaster.internal/ubuntu questing/main amd64 tzdata-legacy all 2025b-3ubuntu1 [99.3 kB] 469s Preconfiguring packages ... 469s Fetched 190 MB in 5s (35.2 MB/s) 469s Selecting previously unselected package libjson-perl. 469s (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 ... 78100 files and directories currently installed.) 469s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 469s Unpacking libjson-perl (4.10000-1) ... 469s Selecting previously unselected package postgresql-client-common. 469s Preparing to unpack .../01-postgresql-client-common_282_all.deb ... 469s Unpacking postgresql-client-common (282) ... 469s Selecting previously unselected package libio-pty-perl. 469s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 469s Unpacking libio-pty-perl (1:1.20-1build3) ... 469s Selecting previously unselected package libipc-run-perl. 469s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 469s Unpacking libipc-run-perl (20231003.0-2) ... 469s Selecting previously unselected package postgresql-common-dev. 470s Preparing to unpack .../04-postgresql-common-dev_282_all.deb ... 470s Unpacking postgresql-common-dev (282) ... 470s Selecting previously unselected package ssl-cert. 470s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 470s Unpacking ssl-cert (1.1.3ubuntu1) ... 470s Selecting previously unselected package postgresql-common. 470s Preparing to unpack .../06-postgresql-common_282_all.deb ... 470s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 470s Unpacking postgresql-common (282) ... 470s Selecting previously unselected package libisl23:amd64. 470s Preparing to unpack .../07-libisl23_0.27-1_amd64.deb ... 470s Unpacking libisl23:amd64 (0.27-1) ... 470s Selecting previously unselected package libmpc3:amd64. 470s Preparing to unpack .../08-libmpc3_1.3.1-1build3_amd64.deb ... 470s Unpacking libmpc3:amd64 (1.3.1-1build3) ... 470s Selecting previously unselected package cpp-15-x86-64-linux-gnu. 470s Preparing to unpack .../09-cpp-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking cpp-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package cpp-15. 470s Preparing to unpack .../10-cpp-15_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking cpp-15 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package cpp-x86-64-linux-gnu. 470s Preparing to unpack .../11-cpp-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 470s Unpacking cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 470s Selecting previously unselected package cpp. 470s Preparing to unpack .../12-cpp_4%3a15.2.0-4ubuntu1_amd64.deb ... 470s Unpacking cpp (4:15.2.0-4ubuntu1) ... 470s Selecting previously unselected package libcc1-0:amd64. 470s Preparing to unpack .../13-libcc1-0_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libcc1-0:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libgomp1:amd64. 470s Preparing to unpack .../14-libgomp1_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libgomp1:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libitm1:amd64. 470s Preparing to unpack .../15-libitm1_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libitm1:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libasan8:amd64. 470s Preparing to unpack .../16-libasan8_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libasan8:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package liblsan0:amd64. 470s Preparing to unpack .../17-liblsan0_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking liblsan0:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libtsan2:amd64. 470s Preparing to unpack .../18-libtsan2_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libtsan2:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libubsan1:amd64. 470s Preparing to unpack .../19-libubsan1_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libubsan1:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libhwasan0:amd64. 470s Preparing to unpack .../20-libhwasan0_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libhwasan0:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libquadmath0:amd64. 470s Preparing to unpack .../21-libquadmath0_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libquadmath0:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package libgcc-15-dev:amd64. 470s Preparing to unpack .../22-libgcc-15-dev_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libgcc-15-dev:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package gcc-15-x86-64-linux-gnu. 470s Preparing to unpack .../23-gcc-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking gcc-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package gcc-15. 470s Preparing to unpack .../24-gcc-15_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking gcc-15 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package gcc-x86-64-linux-gnu. 470s Preparing to unpack .../25-gcc-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 470s Unpacking gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 470s Selecting previously unselected package gcc. 470s Preparing to unpack .../26-gcc_4%3a15.2.0-4ubuntu1_amd64.deb ... 470s Unpacking gcc (4:15.2.0-4ubuntu1) ... 470s Selecting previously unselected package libstdc++-15-dev:amd64. 470s Preparing to unpack .../27-libstdc++-15-dev_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking libstdc++-15-dev:amd64 (15.2.0-4ubuntu4) ... 470s Selecting previously unselected package g++-15-x86-64-linux-gnu. 470s Preparing to unpack .../28-g++-15-x86-64-linux-gnu_15.2.0-4ubuntu4_amd64.deb ... 470s Unpacking g++-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 471s Selecting previously unselected package g++-15. 471s Preparing to unpack .../29-g++-15_15.2.0-4ubuntu4_amd64.deb ... 471s Unpacking g++-15 (15.2.0-4ubuntu4) ... 471s Selecting previously unselected package g++-x86-64-linux-gnu. 471s Preparing to unpack .../30-g++-x86-64-linux-gnu_4%3a15.2.0-4ubuntu1_amd64.deb ... 471s Unpacking g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 471s Selecting previously unselected package g++. 471s Preparing to unpack .../31-g++_4%3a15.2.0-4ubuntu1_amd64.deb ... 471s Unpacking g++ (4:15.2.0-4ubuntu1) ... 471s Selecting previously unselected package build-essential. 471s Preparing to unpack .../32-build-essential_12.12ubuntu2_amd64.deb ... 471s Unpacking build-essential (12.12ubuntu2) ... 471s Selecting previously unselected package gcc-13-base:amd64. 471s Preparing to unpack .../33-gcc-13-base_13.4.0-4ubuntu1_amd64.deb ... 471s Unpacking gcc-13-base:amd64 (13.4.0-4ubuntu1) ... 471s Selecting previously unselected package libgcc-13-dev:amd64. 471s Preparing to unpack .../34-libgcc-13-dev_13.4.0-4ubuntu1_amd64.deb ... 471s Unpacking libgcc-13-dev:amd64 (13.4.0-4ubuntu1) ... 471s Selecting previously unselected package libstdc++-13-dev:amd64. 471s Preparing to unpack .../35-libstdc++-13-dev_13.4.0-4ubuntu1_amd64.deb ... 471s Unpacking libstdc++-13-dev:amd64 (13.4.0-4ubuntu1) ... 471s Selecting previously unselected package libgc1:amd64. 471s Preparing to unpack .../36-libgc1_1%3a8.2.8-1_amd64.deb ... 471s Unpacking libgc1:amd64 (1:8.2.8-1) ... 471s Selecting previously unselected package libobjc4:amd64. 471s Preparing to unpack .../37-libobjc4_15.2.0-4ubuntu4_amd64.deb ... 471s Unpacking libobjc4:amd64 (15.2.0-4ubuntu4) ... 471s Selecting previously unselected package libobjc-13-dev:amd64. 471s Preparing to unpack .../38-libobjc-13-dev_13.4.0-4ubuntu1_amd64.deb ... 471s Unpacking libobjc-13-dev:amd64 (13.4.0-4ubuntu1) ... 471s Selecting previously unselected package libclang-common-20-dev:amd64. 471s Preparing to unpack .../39-libclang-common-20-dev_1%3a20.1.8-0ubuntu4_amd64.deb ... 471s Unpacking libclang-common-20-dev:amd64 (1:20.1.8-0ubuntu4) ... 471s Selecting previously unselected package llvm-20-linker-tools. 471s Preparing to unpack .../40-llvm-20-linker-tools_1%3a20.1.8-0ubuntu4_amd64.deb ... 471s Unpacking llvm-20-linker-tools (1:20.1.8-0ubuntu4) ... 471s Selecting previously unselected package clang-20. 471s Preparing to unpack .../41-clang-20_1%3a20.1.8-0ubuntu4_amd64.deb ... 471s Unpacking clang-20 (1:20.1.8-0ubuntu4) ... 471s Selecting previously unselected package libpgtypes3:amd64. 471s Preparing to unpack .../42-libpgtypes3_17.6-1build1_amd64.deb ... 471s Unpacking libpgtypes3:amd64 (17.6-1build1) ... 471s Selecting previously unselected package libpq5:amd64. 471s Preparing to unpack .../43-libpq5_17.6-1build1_amd64.deb ... 471s Unpacking libpq5:amd64 (17.6-1build1) ... 471s Selecting previously unselected package libecpg6:amd64. 471s Preparing to unpack .../44-libecpg6_17.6-1build1_amd64.deb ... 471s Unpacking libecpg6:amd64 (17.6-1build1) ... 471s Selecting previously unselected package libecpg-compat3:amd64. 471s Preparing to unpack .../45-libecpg-compat3_17.6-1build1_amd64.deb ... 471s Unpacking libecpg-compat3:amd64 (17.6-1build1) ... 471s Selecting previously unselected package libssl-dev:amd64. 471s Preparing to unpack .../46-libssl-dev_3.5.2-1ubuntu1_amd64.deb ... 471s Unpacking libssl-dev:amd64 (3.5.2-1ubuntu1) ... 471s Selecting previously unselected package libpq-dev. 471s Preparing to unpack .../47-libpq-dev_17.6-1build1_amd64.deb ... 471s Unpacking libpq-dev (17.6-1build1) ... 471s Selecting previously unselected package libecpg-dev. 471s Preparing to unpack .../48-libecpg-dev_17.6-1build1_amd64.deb ... 471s Unpacking libecpg-dev (17.6-1build1) ... 471s Selecting previously unselected package libicu76:amd64. 471s Preparing to unpack .../49-libicu76_76.1-4ubuntu2_amd64.deb ... 471s Unpacking libicu76:amd64 (76.1-4ubuntu2) ... 471s Selecting previously unselected package libncurses-dev:amd64. 471s Preparing to unpack .../50-libncurses-dev_6.5+20250216-2build1_amd64.deb ... 471s Unpacking libncurses-dev:amd64 (6.5+20250216-2build1) ... 471s Selecting previously unselected package libtcl8.6:amd64. 471s Preparing to unpack .../51-libtcl8.6_8.6.17+dfsg-1_amd64.deb ... 471s Unpacking libtcl8.6:amd64 (8.6.17+dfsg-1) ... 471s Selecting previously unselected package liblzma-dev:amd64. 471s Preparing to unpack .../52-liblzma-dev_5.8.1-1build2_amd64.deb ... 471s Unpacking liblzma-dev:amd64 (5.8.1-1build2) ... 471s Selecting previously unselected package zlib1g-dev:amd64. 471s Preparing to unpack .../53-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu2_amd64.deb ... 471s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 471s Selecting previously unselected package libxml2-dev:amd64. 471s Preparing to unpack .../54-libxml2-dev_2.14.5+dfsg-0.2_amd64.deb ... 471s Unpacking libxml2-dev:amd64 (2.14.5+dfsg-0.2) ... 471s Selecting previously unselected package libxslt1.1:amd64. 471s Preparing to unpack .../55-libxslt1.1_1.1.43-0.1_amd64.deb ... 471s Unpacking libxslt1.1:amd64 (1.1.43-0.1) ... 471s Selecting previously unselected package llvm-20-runtime. 471s Preparing to unpack .../56-llvm-20-runtime_1%3a20.1.8-0ubuntu4_amd64.deb ... 471s Unpacking llvm-20-runtime (1:20.1.8-0ubuntu4) ... 471s Selecting previously unselected package libpfm4:amd64. 471s Preparing to unpack .../57-libpfm4_4.13.0+git99-gc5587f9-1_amd64.deb ... 471s Unpacking libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 471s Selecting previously unselected package llvm-20. 471s Preparing to unpack .../58-llvm-20_1%3a20.1.8-0ubuntu4_amd64.deb ... 471s Unpacking llvm-20 (1:20.1.8-0ubuntu4) ... 472s Selecting previously unselected package libffi-dev:amd64. 472s Preparing to unpack .../59-libffi-dev_3.5.2-1build1_amd64.deb ... 472s Unpacking libffi-dev:amd64 (3.5.2-1build1) ... 472s Selecting previously unselected package llvm-20-tools. 472s Preparing to unpack .../60-llvm-20-tools_1%3a20.1.8-0ubuntu4_amd64.deb ... 472s Unpacking llvm-20-tools (1:20.1.8-0ubuntu4) ... 472s Selecting previously unselected package llvm-20-dev. 472s Preparing to unpack .../61-llvm-20-dev_1%3a20.1.8-0ubuntu4_amd64.deb ... 472s Unpacking llvm-20-dev (1:20.1.8-0ubuntu4) ... 473s Selecting previously unselected package postgresql-client-17. 473s Preparing to unpack .../62-postgresql-client-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-client-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-17. 473s Preparing to unpack .../63-postgresql-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-doc-17. 473s Preparing to unpack .../64-postgresql-doc-17_17.6-1build1_all.deb ... 473s Unpacking postgresql-doc-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-plperl-17. 473s Preparing to unpack .../65-postgresql-plperl-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-plperl-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-plpython3-17. 473s Preparing to unpack .../66-postgresql-plpython3-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-plpython3-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-pltcl-17. 473s Preparing to unpack .../67-postgresql-pltcl-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-pltcl-17 (17.6-1build1) ... 473s Selecting previously unselected package postgresql-server-dev-17. 473s Preparing to unpack .../68-postgresql-server-dev-17_17.6-1build1_amd64.deb ... 473s Unpacking postgresql-server-dev-17 (17.6-1build1) ... 473s Selecting previously unselected package tzdata-legacy. 473s Preparing to unpack .../69-tzdata-legacy_2025b-3ubuntu1_all.deb ... 473s Unpacking tzdata-legacy (2025b-3ubuntu1) ... 473s Setting up postgresql-client-common (282) ... 473s Setting up libpgtypes3:amd64 (17.6-1build1) ... 473s Setting up libncurses-dev:amd64 (6.5+20250216-2build1) ... 473s Setting up libio-pty-perl (1:1.20-1build3) ... 473s Setting up libclang-common-20-dev:amd64 (1:20.1.8-0ubuntu4) ... 473s Setting up postgresql-doc-17 (17.6-1build1) ... 473s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 473s Setting up libpq5:amd64 (17.6-1build1) ... 473s Setting up llvm-20-runtime (1:20.1.8-0ubuntu4) ... 473s Setting up libgomp1:amd64 (15.2.0-4ubuntu4) ... 473s Setting up libffi-dev:amd64 (3.5.2-1build1) ... 473s Setting up tzdata-legacy (2025b-3ubuntu1) ... 473s Setting up llvm-20-linker-tools (1:20.1.8-0ubuntu4) ... 473s Setting up llvm-20-tools (1:20.1.8-0ubuntu4) ... 473s Setting up libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 473s Setting up gcc-13-base:amd64 (13.4.0-4ubuntu1) ... 473s Setting up ssl-cert (1.1.3ubuntu1) ... 473s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 474s Setting up libquadmath0:amd64 (15.2.0-4ubuntu4) ... 474s Setting up llvm-20 (1:20.1.8-0ubuntu4) ... 474s Setting up libssl-dev:amd64 (3.5.2-1ubuntu1) ... 474s Setting up libmpc3:amd64 (1.3.1-1build3) ... 474s Setting up libtcl8.6:amd64 (8.6.17+dfsg-1) ... 474s Setting up libipc-run-perl (20231003.0-2) ... 474s Setting up libgc1:amd64 (1:8.2.8-1) ... 474s Setting up liblzma-dev:amd64 (5.8.1-1build2) ... 474s Setting up libubsan1:amd64 (15.2.0-4ubuntu4) ... 474s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu2) ... 474s Setting up libhwasan0:amd64 (15.2.0-4ubuntu4) ... 474s Setting up libasan8:amd64 (15.2.0-4ubuntu4) ... 474s Setting up libjson-perl (4.10000-1) ... 474s Setting up libxslt1.1:amd64 (1.1.43-0.1) ... 474s Setting up libecpg6:amd64 (17.6-1build1) ... 474s Setting up libicu76:amd64 (76.1-4ubuntu2) ... 474s Setting up libtsan2:amd64 (15.2.0-4ubuntu4) ... 474s Setting up libisl23:amd64 (0.27-1) ... 474s Setting up libcc1-0:amd64 (15.2.0-4ubuntu4) ... 474s Setting up liblsan0:amd64 (15.2.0-4ubuntu4) ... 474s Setting up libitm1:amd64 (15.2.0-4ubuntu4) ... 474s Setting up postgresql-common-dev (282) ... 474s Setting up libgcc-15-dev:amd64 (15.2.0-4ubuntu4) ... 474s Setting up libecpg-compat3:amd64 (17.6-1build1) ... 474s Setting up postgresql-client-17 (17.6-1build1) ... 474s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 474s Setting up libpq-dev (17.6-1build1) ... 474s Setting up libobjc4:amd64 (15.2.0-4ubuntu4) ... 474s Setting up cpp-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 474s Setting up libecpg-dev (17.6-1build1) ... 474s Setting up gcc-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 474s Setting up libxml2-dev:amd64 (2.14.5+dfsg-0.2) ... 474s Setting up libstdc++-15-dev:amd64 (15.2.0-4ubuntu4) ... 474s Setting up postgresql-common (282) ... 474s Creating config file /etc/postgresql-common/createcluster.conf with new version 474s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 474s Removing obsolete dictionary files: 475s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 475s Setting up llvm-20-dev (1:20.1.8-0ubuntu4) ... 475s Setting up libgcc-13-dev:amd64 (13.4.0-4ubuntu1) ... 475s Setting up cpp-15 (15.2.0-4ubuntu4) ... 475s Setting up libobjc-13-dev:amd64 (13.4.0-4ubuntu1) ... 475s Setting up libstdc++-13-dev:amd64 (13.4.0-4ubuntu1) ... 475s Setting up cpp-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 475s Setting up g++-15-x86-64-linux-gnu (15.2.0-4ubuntu4) ... 475s Setting up postgresql-17 (17.6-1build1) ... 475s Creating new PostgreSQL cluster 17/main ... 475s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 475s The files belonging to this database system will be owned by user "postgres". 475s This user must also own the server process. 475s 475s The database cluster will be initialized with locale "C.UTF-8". 475s The default database encoding has accordingly been set to "UTF8". 475s The default text search configuration will be set to "english". 475s 475s Data page checksums are disabled. 475s 475s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 475s creating subdirectories ... ok 475s selecting dynamic shared memory implementation ... posix 475s selecting default "max_connections" ... 100 475s selecting default "shared_buffers" ... 128MB 475s selecting default time zone ... Etc/UTC 475s creating configuration files ... ok 475s running bootstrap script ... ok 476s performing post-bootstrap initialization ... ok 476s syncing data to disk ... ok 478s Setting up gcc-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 478s Setting up gcc-15 (15.2.0-4ubuntu4) ... 478s Setting up postgresql-plpython3-17 (17.6-1build1) ... 478s Setting up postgresql-plperl-17 (17.6-1build1) ... 478s Setting up cpp (4:15.2.0-4ubuntu1) ... 478s Setting up g++-x86-64-linux-gnu (4:15.2.0-4ubuntu1) ... 478s Setting up g++-15 (15.2.0-4ubuntu4) ... 478s Setting up clang-20 (1:20.1.8-0ubuntu4) ... 478s Setting up postgresql-pltcl-17 (17.6-1build1) ... 478s Setting up gcc (4:15.2.0-4ubuntu1) ... 478s Setting up postgresql-server-dev-17 (17.6-1build1) ... 478s Setting up g++ (4:15.2.0-4ubuntu1) ... 478s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 478s Setting up build-essential (12.12ubuntu2) ... 478s Processing triggers for libc-bin (2.42-0ubuntu3) ... 478s Processing triggers for systemd (257.9-0ubuntu1) ... 478s Processing triggers for man-db (2.13.1-1) ... 479s Processing triggers for install-info (7.1.1-1) ... 500s autopkgtest [10:42:59]: test installcheck: [----------------------- 501s + dpkg-parsechangelog -SSource 501s + SOURCE=postgresql-17 501s + MAJOR=17 501s + top_srcdir=/tmp/autopkgtest.xAx2WC/build.6ZO/src 501s + cd src/test/regress 501s + make -f /tmp/autopkgtest.xAx2WC/build.6ZO/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 501s 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 -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.xAx2WC/build.6ZO/src/debian/tests/ -I/usr/include/postgresql/17/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 501s 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 -g -g -O2 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/x86_64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -fvisibility=hidden 502s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.xAx2WC/build.6ZO/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/maintain_every.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/predicate.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/sqljson_jsontable.sql sql/sqljson_queryfuncs.sql sql/stats.sql sql/stats_ext.sql sql/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.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/maintain_every.out expected/matview.out expected/md5.out expected/md5_1.out expected/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/password_1.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/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 502s + id -u 502s + [ 1000 = 0 ] 502s + SU=sh 502s + sh 502s + mktemp -d /tmp/regress.XXXXXX 502s + OUTPUT=/tmp/regress.fCeJua 502s + trap rm -rf /tmp/regress.fCeJua EXIT 502s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.fCeJua --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 502s Creating new PostgreSQL cluster 17/regress ... 504s # using postmaster on localhost, port 5433 504s ok 1 - test_setup 149 ms 505s # parallel group (20 tests): varchar name char text int4 oid pg_lsn txid int2 money uuid regproc float4 int8 float8 enum numeric bit boolean rangetypes 505s ok 2 + boolean 437 ms 505s ok 3 + char 118 ms 505s ok 4 + name 103 ms 505s ok 5 + varchar 91 ms 505s ok 6 + text 120 ms 505s ok 7 + int2 146 ms 505s ok 8 + int4 127 ms 505s ok 9 + int8 192 ms 505s ok 10 + oid 135 ms 505s ok 11 + float4 182 ms 505s ok 12 + float8 200 ms 505s ok 13 + bit 423 ms 505s ok 14 + numeric 384 ms 505s ok 15 + txid 143 ms 505s ok 16 + uuid 153 ms 505s ok 17 + enum 201 ms 505s ok 18 + money 146 ms 505s ok 19 + rangetypes 508 ms 505s ok 20 + pg_lsn 130 ms 505s ok 21 + regproc 157 ms 506s # parallel group (20 tests): md5 path circle lseg line date macaddr time numerology macaddr8 timetz inet strings interval point timestamp timestamptz polygon multirangetypes box 506s ok 22 + strings 243 ms 506s ok 23 + md5 90 ms 506s ok 24 + numerology 155 ms 506s ok 25 + point 336 ms 506s ok 26 + lseg 117 ms 506s ok 27 + line 128 ms 506s ok 28 + box 731 ms 506s ok 29 + path 93 ms 506s ok 30 + polygon 520 ms 506s ok 31 + circle 105 ms 506s ok 32 + date 140 ms 506s ok 33 + time 153 ms 506s ok 34 + timetz 172 ms 506s ok 35 + timestamp 490 ms 506s ok 36 + timestamptz 512 ms 506s ok 37 + interval 291 ms 506s ok 38 + inet 186 ms 506s ok 39 + macaddr 146 ms 506s ok 40 + macaddr8 156 ms 506s ok 41 + multirangetypes 609 ms 506s # parallel group (13 tests): comments unicode misc_sanity xid type_sanity mvcc expressions tstypes geometry horology opr_sanity regex database 506s ok 42 + geometry 251 ms 506s ok 43 + horology 372 ms 506s ok 44 + tstypes 170 ms 506s ok 45 + regex 421 ms 506s ok 46 + type_sanity 157 ms 506s ok 47 + opr_sanity 405 ms 506s ok 48 + misc_sanity 90 ms 506s ok 49 + comments 60 ms 506s ok 50 + expressions 166 ms 506s ok 51 + unicode 70 ms 506s ok 52 + xid 142 ms 506s ok 53 + mvcc 166 ms 506s ok 54 + database 438 ms 506s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 506s ok 55 + copy 66 ms 506s ok 56 + copyselect 49 ms 506s ok 57 + copydml 54 ms 506s ok 58 + insert 176 ms 506s ok 59 + insert_conflict 111 ms 507s # parallel group (7 tests): create_function_c create_schema create_operator create_type create_procedure create_misc create_table 507s ok 60 + create_function_c 21 ms 507s ok 61 + create_misc 78 ms 507s ok 62 + create_operator 56 ms 507s ok 63 + create_procedure 76 ms 507s ok 64 + create_table 202 ms 507s ok 65 + create_type 67 ms 507s ok 66 + create_schema 46 ms 507s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 507s ok 67 + create_index 797 ms 507s ok 68 + create_index_spgist 742 ms 507s ok 69 + create_view 291 ms 507s ok 70 + index_including 140 ms 507s ok 71 + index_including_gist 222 ms 508s # parallel group (16 tests): create_cast create_aggregate hash_func errors roleattributes drop_if_exists typed_table create_function_sql create_am constraints infinite_recurse select vacuum updatable_views triggers inherit 508s ok 72 + create_aggregate 122 ms 508s ok 73 + create_function_sql 286 ms 508s ok 74 + create_cast 116 ms 508s ok 75 + constraints 383 ms 508s ok 76 + triggers 762 ms 508s ok 77 + select 438 ms 508s ok 78 + inherit 809 ms 508s ok 79 + typed_table 241 ms 508s ok 80 + vacuum 523 ms 508s ok 81 + drop_if_exists 181 ms 508s ok 82 + updatable_views 740 ms 508s ok 83 + roleattributes 164 ms 508s ok 84 + create_am 352 ms 508s ok 85 + hash_func 124 ms 508s ok 86 + errors 129 ms 508s ok 87 + infinite_recurse 409 ms 508s ok 88 - sanity_check 42 ms 510s # parallel group (20 tests): select_distinct_on delete select_having select_implicit case namespace select_into prepared_xacts random transactions portals select_distinct union arrays subselect update hash_index join aggregates btree_index 510s ok 89 + select_into 229 ms 510s ok 90 + select_distinct 505 ms 510s ok 91 + select_distinct_on 124 ms 510s ok 92 + select_implicit 162 ms 510s ok 93 + select_having 152 ms 510s ok 94 + subselect 756 ms 510s ok 95 + union 594 ms 510s ok 96 + case 183 ms 510s ok 97 + join 1362 ms 510s ok 98 + aggregates 1468 ms 510s ok 99 + transactions 342 ms 510s ok 100 + random 268 ms 510s ok 101 + portals 431 ms 510s ok 102 + arrays 711 ms 510s ok 103 + btree_index 1531 ms 510s ok 104 + hash_index 885 ms 510s ok 105 + update 874 ms 510s ok 106 + delete 118 ms 510s ok 107 + namespace 197 ms 510s ok 108 + prepared_xacts 236 ms 514s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password replica_identity identity matview generated spgist collate rowsecurity gist groupingsets gin brin join_hash privileges 514s ok 109 + brin 3927 ms 514s ok 110 + gin 1545 ms 514s ok 111 + gist 1370 ms 514s ok 112 + spgist 1144 ms 514s ok 113 + privileges 4154 ms 514s ok 114 + init_privs 88 ms 514s ok 115 + security_label 191 ms 514s ok 116 + collate 1157 ms 514s ok 117 + matview 852 ms 514s ok 118 + lock 265 ms 514s ok 119 + replica_identity 438 ms 514s ok 120 + rowsecurity 1312 ms 514s ok 121 + object_address 299 ms 514s ok 122 + tablesample 237 ms 514s ok 123 + groupingsets 1456 ms 514s ok 124 + drop_operator 111 ms 514s ok 125 + password 341 ms 514s ok 126 + identity 745 ms 514s ok 127 + generated 1101 ms 514s ok 128 + join_hash 3924 ms 514s # parallel group (2 tests): brin_bloom brin_multi 514s ok 129 + brin_bloom 48 ms 514s ok 130 + brin_multi 118 ms 515s # parallel group (17 tests): dbsize async collate.utf8 tid tsrf alter_operator tidscan create_role alter_generic sysviews misc_functions tidrangescan create_table_like merge incremental_sort collate.icu.utf8 misc 515s ok 131 + create_table_like 488 ms 515s ok 132 + alter_generic 273 ms 515s ok 133 + alter_operator 165 ms 515s ok 134 + misc 734 ms 515s ok 135 + async 80 ms 515s ok 136 + dbsize 78 ms 515s ok 137 + merge 547 ms 515s ok 138 + misc_functions 373 ms 515s ok 139 + sysviews 362 ms 515s ok 140 + tsrf 157 ms 515s ok 141 + tid 141 ms 515s ok 142 + tidscan 185 ms 515s ok 143 + tidrangescan 439 ms 515s ok 144 + collate.utf8 114 ms 515s ok 145 + collate.icu.utf8 697 ms 515s ok 146 + incremental_sort 582 ms 515s ok 147 + create_role 174 ms 516s # parallel group (7 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab psql rules stats_ext 516s ok 148 + rules 265 ms 516s ok 149 + psql 232 ms 516s ok 150 + psql_crosstab 54 ms 516s ok 151 + amutils 45 ms 516s ok 152 + stats_ext 743 ms 516s ok 153 + collate.linux.utf8 29 ms 516s ok 154 + collate.windows.win1252 30 ms 518s ok 155 - select_parallel 2136 ms 518s ok 156 - write_parallel 76 ms 518s ok 157 - vacuum_parallel 57 ms 518s ok 158 - maintain_every 16 ms 519s # parallel group (2 tests): subscription publication 519s ok 159 + publication 1028 ms 519s ok 160 + subscription 39 ms 520s # parallel group (17 tests): advisory_lock portals_p2 xmlmap combocid functional_deps equivclass dependency tsdicts select_views guc bitmapops window cluster indirect_toast foreign_data foreign_key tsearch 520s ok 161 + select_views 272 ms 520s ok 162 + portals_p2 146 ms 520s ok 163 + foreign_key 996 ms 520s ok 164 + cluster 624 ms 520s ok 165 + dependency 250 ms 520s ok 166 + guc 298 ms 520s ok 167 + bitmapops 566 ms 520s ok 168 + combocid 196 ms 520s ok 169 + tsearch 1233 ms 520s ok 170 + tsdicts 252 ms 520s ok 171 + foreign_data 769 ms 520s ok 172 + window 599 ms 520s ok 173 + xmlmap 162 ms 520s ok 174 + functional_deps 228 ms 520s ok 175 + advisory_lock 116 ms 520s ok 176 + indirect_toast 708 ms 520s ok 177 + equivclass 231 ms 520s # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson_jsontable sqljson json sqljson_queryfuncs jsonb_jsonpath jsonb 520s ok 178 + json 147 ms 520s ok 179 + jsonb 261 ms 520s ok 180 + json_encoding 65 ms 520s ok 181 + jsonpath 65 ms 520s ok 182 + jsonpath_encoding 51 ms 520s ok 183 + jsonb_jsonpath 206 ms 520s ok 184 + sqljson 137 ms 521s ok 185 + sqljson_queryfuncs 174 ms 521s ok 186 + sqljson_jsontable 125 ms 522s # parallel group (18 tests): prepare returning plancache limit conversion temp sequence truncate rowtypes copy2 polymorphism domain largeobject with rangefuncs plpgsql xml alter_table 522s ok 187 + plancache 295 ms 522s ok 188 + limit 319 ms 522s ok 189 + plpgsql 915 ms 522s ok 190 + copy2 560 ms 522s ok 191 + temp 469 ms 522s ok 192 + domain 698 ms 522s ok 193 + rangefuncs 871 ms 522s ok 194 + prepare 126 ms 522s ok 195 + conversion 335 ms 522s ok 196 + truncate 524 ms 522s ok 197 + alter_table 1241 ms 522s ok 198 + sequence 504 ms 522s ok 199 + polymorphism 586 ms 522s ok 200 + rowtypes 525 ms 522s ok 201 + returning 212 ms 522s ok 202 + largeobject 707 ms 522s ok 203 + with 752 ms 522s ok 204 + xml 907 ms 523s # parallel group (13 tests): hash_part predicate reloptions explain partition_info compression memoize partition_aggregate partition_join indexing stats tuplesort partition_prune 523s ok 205 + partition_join 1138 ms 523s ok 206 + partition_prune 1422 ms 523s ok 207 + reloptions 181 ms 523s ok 208 + hash_part 90 ms 523s ok 209 + indexing 1187 ms 523s ok 210 + partition_aggregate 1063 ms 523s ok 211 + partition_info 193 ms 523s ok 212 + tuplesort 1271 ms 523s ok 213 + explain 182 ms 523s ok 214 + compression 323 ms 523s ok 215 + memoize 859 ms 523s ok 216 + stats 1230 ms 523s ok 217 + predicate 172 ms 523s # parallel group (2 tests): oidjoins event_trigger 523s ok 218 + oidjoins 134 ms 523s ok 219 + event_trigger 147 ms 523s ok 220 - event_trigger_login 30 ms 523s ok 221 - fast_default 71 ms 524s ok 222 - tablespace 162 ms 524s 1..222 524s # All 222 tests passed. 524s Dropping cluster 17/regress ... 524s + rm -rf /tmp/regress.fCeJua 524s autopkgtest [10:43:23]: test installcheck: -----------------------] 525s autopkgtest [10:43:24]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 525s installcheck PASS 525s autopkgtest [10:43:24]: @@@@@@@@@@@@@@@@@@@@ summary 525s run-testsuite FAIL non-zero exit status 1 525s installcheck PASS