0s autopkgtest [12:27:13]: starting date and time: 2025-04-25 12:27:13+0000 0s autopkgtest [12:27:13]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [12:27:13]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.g_crkm1p/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-16 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025b-0ubuntu0.24.04.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-17.secgroup --name adt-noble-amd64-postgresql-16-20250425-122712-juju-7f2275-prod-proposed-migration-environment-15-79d5c58d-d90e-4ad1-a329-371a71712a78 --image adt/ubuntu-noble-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 77s autopkgtest [12:28:30]: testbed dpkg architecture: amd64 77s autopkgtest [12:28:30]: testbed apt version: 2.7.14build2 77s autopkgtest [12:28:30]: @@@@@@@@@@@@@@@@@@@@ test bed setup 77s autopkgtest [12:28:30]: testbed release detected to be: None 78s autopkgtest [12:28:31]: updating testbed package index (apt update) 78s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 79s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 79s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 79s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 79s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6316 B] 79s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [62.8 kB] 79s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [49.2 kB] 79s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [15.8 kB] 79s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [211 kB] 79s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [42.9 kB] 79s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [2248 B] 79s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [258 kB] 79s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [9304 B] 79s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [116 B] 79s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [337 kB] 79s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [467 kB] 79s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [7448 B] 79s Get:18 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [11.0 kB] 79s Get:19 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [2412 B] 79s Get:20 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [116 B] 84s Fetched 1747 kB in 1s (1947 kB/s) 85s Reading package lists... 85s autopkgtest [12:28:38]: upgrading testbed (apt dist-upgrade and autopurge) 85s Reading package lists... 86s Building dependency tree... 86s Reading state information... 86s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 86s Starting 2 pkgProblemResolver with broken count: 0 86s Done 87s Entering ResolveByKeep 87s 87s The following packages will be upgraded: 87s tzdata 87s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s Need to get 276 kB of archives. 87s After this operation, 0 B of additional disk space will be used. 87s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 tzdata all 2025b-0ubuntu0.24.04.1 [276 kB] 88s Preconfiguring packages ... 88s Fetched 276 kB in 0s (689 kB/s) 88s (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 ... 106231 files and directories currently installed.) 88s Preparing to unpack .../tzdata_2025b-0ubuntu0.24.04.1_all.deb ... 88s Unpacking tzdata (2025b-0ubuntu0.24.04.1) over (2025b-0ubuntu0.24.04) ... 88s Setting up tzdata (2025b-0ubuntu0.24.04.1) ... 88s 88s Current default time zone: 'Etc/UTC' 88s Local time is now: Fri Apr 25 12:28:41 UTC 2025. 88s Universal Time is now: Fri Apr 25 12:28:41 UTC 2025. 88s Run 'dpkg-reconfigure tzdata' if you wish to change it. 88s 89s Reading package lists... 89s Building dependency tree... 89s Reading state information... 89s Starting pkgProblemResolver with broken count: 0 89s Starting 2 pkgProblemResolver with broken count: 0 89s Done 90s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s autopkgtest [12:28:45]: testbed running kernel: Linux 6.8.0-58-generic #60-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 14 18:29:48 UTC 2025 94s autopkgtest [12:28:47]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-16 103s Get:1 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (dsc) [4329 B] 103s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (tar) [32.8 MB] 103s Get:3 http://ftpmaster.internal/ubuntu noble-updates/main postgresql-16 16.8-0ubuntu0.24.04.1 (diff) [35.2 kB] 103s gpgv: Signature made Fri Feb 28 19:08:43 2025 UTC 103s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 103s gpgv: Can't check signature: No public key 103s dpkg-source: warning: cannot verify inline signature for ./postgresql-16_16.8-0ubuntu0.24.04.1.dsc: no acceptable signature found 105s autopkgtest [12:28:58]: testing package postgresql-16 version 16.8-0ubuntu0.24.04.1 106s autopkgtest [12:28:59]: build not needed 113s autopkgtest [12:29:06]: test run-testsuite: preparing testbed 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 114s Starting pkgProblemResolver with broken count: 0 114s Starting 2 pkgProblemResolver with broken count: 0 114s Done 115s The following NEW packages will be installed: 115s autoconf automake autopoint autotools-dev build-essential clang-17 cpp 115s cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 115s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 115s fakeroot g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-13 115s gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext 115s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 115s libatomic1 libcc1-0 libclang-common-17-dev libclang-cpp17t64 libclang1-17t64 115s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 115s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 115s libhwasan0 libicu-dev libisl23 libitm1 libjson-perl libllvm17t64 liblsan0 115s libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 115s libpq5 libquadmath0 libssl-dev libstdc++-13-dev libsub-override-perl 115s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 115s libz3-dev llvm-17 llvm-17-dev llvm-17-linker-tools llvm-17-runtime 115s llvm-17-tools locales-all m4 po-debconf postgresql-16 postgresql-client-16 115s postgresql-client-common postgresql-common postgresql-doc-16 115s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 115s postgresql-server-dev-16 ssl-cert 115s 0 upgraded, 93 newly installed, 0 to remove and 0 not upgraded. 115s Need to get 238 MB of archives. 115s After this operation, 1319 MB of additional disk space will be used. 115s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 115s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-common all 257build1.1 [36.4 kB] 115s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 115s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-common all 257build1.1 [161 kB] 115s Get:5 http://ftpmaster.internal/ubuntu noble/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 115s Get:6 http://ftpmaster.internal/ubuntu noble/main amd64 autoconf all 2.71-3 [339 kB] 115s Get:7 http://ftpmaster.internal/ubuntu noble/main amd64 autotools-dev all 20220109.1 [44.9 kB] 115s Get:8 http://ftpmaster.internal/ubuntu noble/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 115s Get:9 http://ftpmaster.internal/ubuntu noble/main amd64 autopoint all 0.21-14ubuntu2 [422 kB] 115s Get:10 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-base amd64 13.3.0-6ubuntu2~24.04 [51.5 kB] 115s Get:11 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libisl23 amd64 0.26-3build1.1 [680 kB] 115s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libmpc3 amd64 1.3.1-1build1.1 [54.6 kB] 115s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [10.7 MB] 116s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13 amd64 13.3.0-6ubuntu2~24.04 [1038 B] 116s Get:15 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 116s Get:16 http://ftpmaster.internal/ubuntu noble/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 116s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libcc1-0 amd64 14.2.0-4ubuntu2~24.04 [48.0 kB] 116s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgomp1 amd64 14.2.0-4ubuntu2~24.04 [148 kB] 116s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libitm1 amd64 14.2.0-4ubuntu2~24.04 [29.7 kB] 116s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libatomic1 amd64 14.2.0-4ubuntu2~24.04 [10.5 kB] 116s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libasan8 amd64 14.2.0-4ubuntu2~24.04 [3031 kB] 116s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main amd64 liblsan0 amd64 14.2.0-4ubuntu2~24.04 [1322 kB] 116s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libtsan2 amd64 14.2.0-4ubuntu2~24.04 [2772 kB] 116s Get:24 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libubsan1 amd64 14.2.0-4ubuntu2~24.04 [1184 kB] 116s Get:25 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libhwasan0 amd64 14.2.0-4ubuntu2~24.04 [1641 kB] 116s Get:26 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libquadmath0 amd64 14.2.0-4ubuntu2~24.04 [153 kB] 116s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgcc-13-dev amd64 13.3.0-6ubuntu2~24.04 [2681 kB] 116s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [21.1 MB] 117s Get:29 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13 amd64 13.3.0-6ubuntu2~24.04 [494 kB] 117s Get:30 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 117s Get:31 http://ftpmaster.internal/ubuntu noble/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 117s Get:32 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libstdc++-13-dev amd64 13.3.0-6ubuntu2~24.04 [2420 kB] 117s Get:33 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [12.2 MB] 117s Get:34 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13 amd64 13.3.0-6ubuntu2~24.04 [16.1 kB] 117s Get:35 http://ftpmaster.internal/ubuntu noble/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 117s Get:36 http://ftpmaster.internal/ubuntu noble/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 117s Get:37 http://ftpmaster.internal/ubuntu noble/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 117s Get:38 http://ftpmaster.internal/ubuntu noble/main amd64 libllvm17t64 amd64 1:17.0.6-9ubuntu1 [26.2 MB] 118s Get:39 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-cpp17t64 amd64 1:17.0.6-9ubuntu1 [12.9 MB] 118s Get:40 http://ftpmaster.internal/ubuntu noble/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 118s Get:41 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc4 amd64 14.2.0-4ubuntu2~24.04 [47.0 kB] 118s Get:42 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc-13-dev amd64 13.3.0-6ubuntu2~24.04 [194 kB] 118s Get:43 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-common-17-dev amd64 1:17.0.6-9ubuntu1 [690 kB] 118s Get:44 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-linker-tools amd64 1:17.0.6-9ubuntu1 [1308 kB] 118s Get:45 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang1-17t64 amd64 1:17.0.6-9ubuntu1 [7353 kB] 118s Get:46 http://ftpmaster.internal/ubuntu noble/universe amd64 clang-17 amd64 1:17.0.6-9ubuntu1 [78.6 kB] 118s Get:47 http://ftpmaster.internal/ubuntu noble/main amd64 libdebhelper-perl all 13.14.1ubuntu5 [89.8 kB] 118s Get:48 http://ftpmaster.internal/ubuntu noble/main amd64 libtool all 2.4.7-7build1 [166 kB] 118s Get:49 http://ftpmaster.internal/ubuntu noble/main amd64 dh-autoreconf all 20 [16.1 kB] 118s Get:50 http://ftpmaster.internal/ubuntu noble/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 118s Get:51 http://ftpmaster.internal/ubuntu noble/main amd64 libsub-override-perl all 0.10-1 [10.0 kB] 118s Get:52 http://ftpmaster.internal/ubuntu noble/main amd64 libfile-stripnondeterminism-perl all 1.13.1-1 [18.1 kB] 118s Get:53 http://ftpmaster.internal/ubuntu noble/main amd64 dh-strip-nondeterminism all 1.13.1-1 [5362 B] 118s Get:54 http://ftpmaster.internal/ubuntu noble/main amd64 debugedit amd64 1:5.0-5build2 [46.1 kB] 118s Get:55 http://ftpmaster.internal/ubuntu noble/main amd64 dwz amd64 0.15-1build6 [115 kB] 118s Get:56 http://ftpmaster.internal/ubuntu noble/main amd64 gettext amd64 0.21-14ubuntu2 [864 kB] 118s Get:57 http://ftpmaster.internal/ubuntu noble/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 118s Get:58 http://ftpmaster.internal/ubuntu noble/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 118s Get:59 http://ftpmaster.internal/ubuntu noble/main amd64 debhelper all 13.14.1ubuntu5 [869 kB] 118s Get:60 http://ftpmaster.internal/ubuntu noble/main amd64 emacsen-common all 3.0.5 [12.1 kB] 118s Get:61 http://ftpmaster.internal/ubuntu noble/main amd64 dictionaries-common all 1.29.7 [188 kB] 118s Get:62 http://ftpmaster.internal/ubuntu noble/main amd64 libfakeroot amd64 1.33-1 [32.4 kB] 118s Get:63 http://ftpmaster.internal/ubuntu noble/main amd64 fakeroot amd64 1.33-1 [67.2 kB] 118s Get:64 http://ftpmaster.internal/ubuntu noble/main amd64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 118s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main amd64 icu-devtools amd64 74.2-1ubuntu3.1 [212 kB] 118s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpgtypes3 amd64 16.8-0ubuntu0.24.04.1 [44.5 kB] 118s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq5 amd64 16.8-0ubuntu0.24.04.1 [142 kB] 118s Get:68 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg6 amd64 16.8-0ubuntu0.24.04.1 [44.6 kB] 118s Get:69 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-compat3 amd64 16.8-0ubuntu0.24.04.1 [12.4 kB] 118s Get:70 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libssl-dev amd64 3.0.13-0ubuntu3.5 [2408 kB] 119s Get:71 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq-dev amd64 16.8-0ubuntu0.24.04.1 [151 kB] 119s Get:72 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-dev amd64 16.8-0ubuntu0.24.04.1 [266 kB] 119s Get:73 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libicu-dev amd64 74.2-1ubuntu3.1 [11.9 MB] 119s Get:74 http://ftpmaster.internal/ubuntu noble/main amd64 libncurses-dev amd64 6.4+20240113-1ubuntu2 [384 kB] 119s Get:75 http://ftpmaster.internal/ubuntu noble/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 119s Get:76 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3.2 [780 kB] 119s Get:77 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 119s Get:78 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-runtime amd64 1:17.0.6-9ubuntu1 [529 kB] 119s Get:79 http://ftpmaster.internal/ubuntu noble/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 119s Get:80 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17 amd64 1:17.0.6-9ubuntu1 [23.8 MB] 120s Get:81 http://ftpmaster.internal/ubuntu noble/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 120s Get:82 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-tools amd64 1:17.0.6-9ubuntu1 [518 kB] 120s Get:83 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 120s Get:84 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 120s Get:85 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-dev amd64 1:17.0.6-9ubuntu1 [43.4 MB] 122s Get:86 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 locales-all amd64 2.39-0ubuntu8.4 [10.9 MB] 123s Get:87 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-16 amd64 16.8-0ubuntu0.24.04.1 [1292 kB] 123s Get:88 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-16 amd64 16.8-0ubuntu0.24.04.1 [15.5 MB] 124s Get:89 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-doc-16 all 16.8-0ubuntu0.24.04.1 [2126 kB] 124s Get:90 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plperl-16 amd64 16.8-0ubuntu0.24.04.1 [68.7 kB] 124s Get:91 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plpython3-16 amd64 16.8-0ubuntu0.24.04.1 [76.9 kB] 124s Get:92 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-pltcl-16 amd64 16.8-0ubuntu0.24.04.1 [31.8 kB] 124s Get:93 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 postgresql-server-dev-16 amd64 16.8-0ubuntu0.24.04.1 [1227 kB] 124s Preconfiguring packages ... 124s Fetched 238 MB in 9s (26.4 MB/s) 124s Selecting previously unselected package libjson-perl. 124s (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 ... 106231 files and directories currently installed.) 124s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 124s Unpacking libjson-perl (4.10000-1) ... 124s Selecting previously unselected package postgresql-client-common. 124s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 124s Unpacking postgresql-client-common (257build1.1) ... 125s Selecting previously unselected package ssl-cert. 125s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 125s Unpacking ssl-cert (1.1.2ubuntu1) ... 125s Selecting previously unselected package postgresql-common. 125s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 125s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 125s Unpacking postgresql-common (257build1.1) ... 125s Selecting previously unselected package m4. 125s Preparing to unpack .../04-m4_1.4.19-4build1_amd64.deb ... 125s Unpacking m4 (1.4.19-4build1) ... 125s Selecting previously unselected package autoconf. 125s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 125s Unpacking autoconf (2.71-3) ... 125s Selecting previously unselected package autotools-dev. 125s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 125s Unpacking autotools-dev (20220109.1) ... 125s Selecting previously unselected package automake. 125s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 125s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 125s Selecting previously unselected package autopoint. 125s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 125s Unpacking autopoint (0.21-14ubuntu2) ... 125s Selecting previously unselected package gcc-13-base:amd64. 125s Preparing to unpack .../09-gcc-13-base_13.3.0-6ubuntu2~24.04_amd64.deb ... 125s Unpacking gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 125s Selecting previously unselected package libisl23:amd64. 125s Preparing to unpack .../10-libisl23_0.26-3build1.1_amd64.deb ... 125s Unpacking libisl23:amd64 (0.26-3build1.1) ... 125s Selecting previously unselected package libmpc3:amd64. 125s Preparing to unpack .../11-libmpc3_1.3.1-1build1.1_amd64.deb ... 125s Unpacking libmpc3:amd64 (1.3.1-1build1.1) ... 125s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 125s Preparing to unpack .../12-cpp-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 125s Unpacking cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 125s Selecting previously unselected package cpp-13. 125s Preparing to unpack .../13-cpp-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 125s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 125s Selecting previously unselected package cpp-x86-64-linux-gnu. 125s Preparing to unpack .../14-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 125s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 125s Selecting previously unselected package cpp. 125s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 125s Unpacking cpp (4:13.2.0-7ubuntu1) ... 125s Selecting previously unselected package libcc1-0:amd64. 125s Preparing to unpack .../16-libcc1-0_14.2.0-4ubuntu2~24.04_amd64.deb ... 125s Unpacking libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 125s Selecting previously unselected package libgomp1:amd64. 125s Preparing to unpack .../17-libgomp1_14.2.0-4ubuntu2~24.04_amd64.deb ... 125s Unpacking libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 125s Selecting previously unselected package libitm1:amd64. 125s Preparing to unpack .../18-libitm1_14.2.0-4ubuntu2~24.04_amd64.deb ... 125s Unpacking libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 125s Selecting previously unselected package libatomic1:amd64. 125s Preparing to unpack .../19-libatomic1_14.2.0-4ubuntu2~24.04_amd64.deb ... 125s Unpacking libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 125s Selecting previously unselected package libasan8:amd64. 125s Preparing to unpack .../20-libasan8_14.2.0-4ubuntu2~24.04_amd64.deb ... 125s Unpacking libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 125s Selecting previously unselected package liblsan0:amd64. 126s Preparing to unpack .../21-liblsan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 126s Unpacking liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 126s Selecting previously unselected package libtsan2:amd64. 126s Preparing to unpack .../22-libtsan2_14.2.0-4ubuntu2~24.04_amd64.deb ... 126s Unpacking libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 126s Selecting previously unselected package libubsan1:amd64. 126s Preparing to unpack .../23-libubsan1_14.2.0-4ubuntu2~24.04_amd64.deb ... 126s Unpacking libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 126s Selecting previously unselected package libhwasan0:amd64. 126s Preparing to unpack .../24-libhwasan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 126s Unpacking libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 126s Selecting previously unselected package libquadmath0:amd64. 126s Preparing to unpack .../25-libquadmath0_14.2.0-4ubuntu2~24.04_amd64.deb ... 126s Unpacking libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 126s Selecting previously unselected package libgcc-13-dev:amd64. 126s Preparing to unpack .../26-libgcc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 126s Unpacking libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 126s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 126s Preparing to unpack .../27-gcc-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 126s Unpacking gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 126s Selecting previously unselected package gcc-13. 126s Preparing to unpack .../28-gcc-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 126s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 126s Selecting previously unselected package gcc-x86-64-linux-gnu. 126s Preparing to unpack .../29-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 126s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 126s Selecting previously unselected package gcc. 126s Preparing to unpack .../30-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 126s Unpacking gcc (4:13.2.0-7ubuntu1) ... 126s Selecting previously unselected package libstdc++-13-dev:amd64. 126s Preparing to unpack .../31-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 126s Unpacking libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 127s Selecting previously unselected package g++-13-x86-64-linux-gnu. 127s Preparing to unpack .../32-g++-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 127s Unpacking g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 127s Selecting previously unselected package g++-13. 127s Preparing to unpack .../33-g++-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 127s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 127s Selecting previously unselected package g++-x86-64-linux-gnu. 127s Preparing to unpack .../34-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 127s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 127s Selecting previously unselected package g++. 127s Preparing to unpack .../35-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 127s Unpacking g++ (4:13.2.0-7ubuntu1) ... 127s Selecting previously unselected package build-essential. 127s Preparing to unpack .../36-build-essential_12.10ubuntu1_amd64.deb ... 127s Unpacking build-essential (12.10ubuntu1) ... 127s Selecting previously unselected package libllvm17t64:amd64. 127s Preparing to unpack .../37-libllvm17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 127s Unpacking libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 127s Selecting previously unselected package libclang-cpp17t64. 127s Preparing to unpack .../38-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 127s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 128s Selecting previously unselected package libgc1:amd64. 128s Preparing to unpack .../39-libgc1_1%3a8.2.6-1build1_amd64.deb ... 128s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 128s Selecting previously unselected package libobjc4:amd64. 128s Preparing to unpack .../40-libobjc4_14.2.0-4ubuntu2~24.04_amd64.deb ... 128s Unpacking libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 128s Selecting previously unselected package libobjc-13-dev:amd64. 128s Preparing to unpack .../41-libobjc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 128s Unpacking libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 128s Selecting previously unselected package libclang-common-17-dev:amd64. 128s Preparing to unpack .../42-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 128s Unpacking libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 128s Selecting previously unselected package llvm-17-linker-tools. 128s Preparing to unpack .../43-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 128s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 128s Selecting previously unselected package libclang1-17t64. 128s Preparing to unpack .../44-libclang1-17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 128s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 128s Selecting previously unselected package clang-17. 128s Preparing to unpack .../45-clang-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 128s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 128s Selecting previously unselected package libdebhelper-perl. 128s Preparing to unpack .../46-libdebhelper-perl_13.14.1ubuntu5_all.deb ... 128s Unpacking libdebhelper-perl (13.14.1ubuntu5) ... 128s Selecting previously unselected package libtool. 128s Preparing to unpack .../47-libtool_2.4.7-7build1_all.deb ... 128s Unpacking libtool (2.4.7-7build1) ... 128s Selecting previously unselected package dh-autoreconf. 128s Preparing to unpack .../48-dh-autoreconf_20_all.deb ... 128s Unpacking dh-autoreconf (20) ... 128s Selecting previously unselected package libarchive-zip-perl. 128s Preparing to unpack .../49-libarchive-zip-perl_1.68-1_all.deb ... 128s Unpacking libarchive-zip-perl (1.68-1) ... 128s Selecting previously unselected package libsub-override-perl. 128s Preparing to unpack .../50-libsub-override-perl_0.10-1_all.deb ... 128s Unpacking libsub-override-perl (0.10-1) ... 128s Selecting previously unselected package libfile-stripnondeterminism-perl. 128s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... 128s Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... 128s Selecting previously unselected package dh-strip-nondeterminism. 128s Preparing to unpack .../52-dh-strip-nondeterminism_1.13.1-1_all.deb ... 128s Unpacking dh-strip-nondeterminism (1.13.1-1) ... 129s Selecting previously unselected package debugedit. 129s Preparing to unpack .../53-debugedit_1%3a5.0-5build2_amd64.deb ... 129s Unpacking debugedit (1:5.0-5build2) ... 129s Selecting previously unselected package dwz. 129s Preparing to unpack .../54-dwz_0.15-1build6_amd64.deb ... 129s Unpacking dwz (0.15-1build6) ... 129s Selecting previously unselected package gettext. 129s Preparing to unpack .../55-gettext_0.21-14ubuntu2_amd64.deb ... 129s Unpacking gettext (0.21-14ubuntu2) ... 129s Selecting previously unselected package intltool-debian. 129s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 129s Unpacking intltool-debian (0.35.0+20060710.6) ... 129s Selecting previously unselected package po-debconf. 129s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 129s Unpacking po-debconf (1.0.21+nmu1) ... 129s Selecting previously unselected package debhelper. 129s Preparing to unpack .../58-debhelper_13.14.1ubuntu5_all.deb ... 129s Unpacking debhelper (13.14.1ubuntu5) ... 129s Selecting previously unselected package emacsen-common. 129s Preparing to unpack .../59-emacsen-common_3.0.5_all.deb ... 129s Unpacking emacsen-common (3.0.5) ... 129s Selecting previously unselected package dictionaries-common. 129s Preparing to unpack .../60-dictionaries-common_1.29.7_all.deb ... 129s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 129s Unpacking dictionaries-common (1.29.7) ... 129s Selecting previously unselected package libfakeroot:amd64. 129s Preparing to unpack .../61-libfakeroot_1.33-1_amd64.deb ... 129s Unpacking libfakeroot:amd64 (1.33-1) ... 129s Selecting previously unselected package fakeroot. 129s Preparing to unpack .../62-fakeroot_1.33-1_amd64.deb ... 129s Unpacking fakeroot (1.33-1) ... 129s Selecting previously unselected package hunspell-en-us. 129s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 129s Unpacking hunspell-en-us (1:2020.12.07-2) ... 129s Selecting previously unselected package icu-devtools. 129s Preparing to unpack .../64-icu-devtools_74.2-1ubuntu3.1_amd64.deb ... 129s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 129s Selecting previously unselected package libpgtypes3:amd64. 129s Preparing to unpack .../65-libpgtypes3_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libpgtypes3:amd64 (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libpq5:amd64. 129s Preparing to unpack .../66-libpq5_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libpq5:amd64 (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libecpg6:amd64. 129s Preparing to unpack .../67-libecpg6_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libecpg6:amd64 (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libecpg-compat3:amd64. 129s Preparing to unpack .../68-libecpg-compat3_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libecpg-compat3:amd64 (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libssl-dev:amd64. 129s Preparing to unpack .../69-libssl-dev_3.0.13-0ubuntu3.5_amd64.deb ... 129s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu3.5) ... 129s Selecting previously unselected package libpq-dev. 129s Preparing to unpack .../70-libpq-dev_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libpq-dev (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libecpg-dev. 129s Preparing to unpack .../71-libecpg-dev_16.8-0ubuntu0.24.04.1_amd64.deb ... 129s Unpacking libecpg-dev (16.8-0ubuntu0.24.04.1) ... 129s Selecting previously unselected package libicu-dev:amd64. 129s Preparing to unpack .../72-libicu-dev_74.2-1ubuntu3.1_amd64.deb ... 129s Unpacking libicu-dev:amd64 (74.2-1ubuntu3.1) ... 130s Selecting previously unselected package libncurses-dev:amd64. 130s Preparing to unpack .../73-libncurses-dev_6.4+20240113-1ubuntu2_amd64.deb ... 130s Unpacking libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 130s Selecting previously unselected package libtcl8.6:amd64. 130s Preparing to unpack .../74-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 130s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 130s Selecting previously unselected package libxml2-dev:amd64. 130s Preparing to unpack .../75-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.2_amd64.deb ... 130s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.2) ... 130s Selecting previously unselected package libxslt1.1:amd64. 130s Preparing to unpack .../76-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_amd64.deb ... 130s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 130s Selecting previously unselected package llvm-17-runtime. 130s Preparing to unpack .../77-llvm-17-runtime_1%3a17.0.6-9ubuntu1_amd64.deb ... 130s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 130s Selecting previously unselected package libpfm4:amd64. 130s Preparing to unpack .../78-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 130s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 130s Selecting previously unselected package llvm-17. 130s Preparing to unpack .../79-llvm-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 130s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 131s Selecting previously unselected package libffi-dev:amd64. 131s Preparing to unpack .../80-libffi-dev_3.4.6-1build1_amd64.deb ... 131s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 131s Selecting previously unselected package llvm-17-tools. 131s Preparing to unpack .../81-llvm-17-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 131s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 131s Selecting previously unselected package libz3-4:amd64. 131s Preparing to unpack .../82-libz3-4_4.8.12-3.1build1_amd64.deb ... 131s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 131s Selecting previously unselected package libz3-dev:amd64. 131s Preparing to unpack .../83-libz3-dev_4.8.12-3.1build1_amd64.deb ... 131s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 131s Selecting previously unselected package llvm-17-dev. 131s Preparing to unpack .../84-llvm-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 131s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 132s Selecting previously unselected package locales-all. 132s Preparing to unpack .../85-locales-all_2.39-0ubuntu8.4_amd64.deb ... 132s Unpacking locales-all (2.39-0ubuntu8.4) ... 134s Selecting previously unselected package postgresql-client-16. 134s Preparing to unpack .../86-postgresql-client-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 134s Unpacking postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 134s Selecting previously unselected package postgresql-16. 134s Preparing to unpack .../87-postgresql-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 134s Unpacking postgresql-16 (16.8-0ubuntu0.24.04.1) ... 135s Selecting previously unselected package postgresql-doc-16. 135s Preparing to unpack .../88-postgresql-doc-16_16.8-0ubuntu0.24.04.1_all.deb ... 135s Unpacking postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 135s Selecting previously unselected package postgresql-plperl-16. 135s Preparing to unpack .../89-postgresql-plperl-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 135s Unpacking postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 135s Selecting previously unselected package postgresql-plpython3-16. 135s Preparing to unpack .../90-postgresql-plpython3-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 135s Unpacking postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 135s Selecting previously unselected package postgresql-pltcl-16. 135s Preparing to unpack .../91-postgresql-pltcl-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 135s Unpacking postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 135s Selecting previously unselected package postgresql-server-dev-16. 135s Preparing to unpack .../92-postgresql-server-dev-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 135s Unpacking postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 135s Setting up postgresql-client-common (257build1.1) ... 135s Setting up libpgtypes3:amd64 (16.8-0ubuntu0.24.04.1) ... 135s Setting up libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 135s Setting up postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 136s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 136s Setting up libarchive-zip-perl (1.68-1) ... 136s Setting up libdebhelper-perl (13.14.1ubuntu5) ... 136s Setting up libpq5:amd64 (16.8-0ubuntu0.24.04.1) ... 136s Setting up m4 (1.4.19-4build1) ... 136s Setting up libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 136s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 136s Setting up locales-all (2.39-0ubuntu8.4) ... 136s Setting up libfakeroot:amd64 (1.33-1) ... 136s Setting up fakeroot (1.33-1) ... 136s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 136s Setting up autotools-dev (20220109.1) ... 136s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 136s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 136s Setting up gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 136s Setting up libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 136s Setting up emacsen-common (3.0.5) ... 136s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 136s Setting up ssl-cert (1.1.2ubuntu1) ... 136s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 137s Setting up libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libssl-dev:amd64 (3.0.13-0ubuntu3.5) ... 137s Setting up libmpc3:amd64 (1.3.1-1build1.1) ... 137s Setting up libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 137s Setting up autopoint (0.21-14ubuntu2) ... 137s Setting up icu-devtools (74.2-1ubuntu3.1) ... 137s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 137s Setting up autoconf (2.71-3) ... 137s Setting up libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 137s Setting up dwz (0.15-1build6) ... 137s Setting up libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 137s Setting up libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libjson-perl (4.10000-1) ... 137s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 137s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 137s Setting up debugedit (1:5.0-5build2) ... 137s Setting up libecpg6:amd64 (16.8-0ubuntu0.24.04.1) ... 137s Setting up libsub-override-perl (0.10-1) ... 137s Setting up libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libisl23:amd64 (0.26-3build1.1) ... 137s Setting up libicu-dev:amd64 (74.2-1ubuntu3.1) ... 137s Setting up libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up automake (1:1.16.5-1.3ubuntu1) ... 137s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 137s Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... 137s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 137s Setting up gettext (0.21-14ubuntu2) ... 137s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 137s Setting up libecpg-compat3:amd64 (16.8-0ubuntu0.24.04.1) ... 137s Setting up dictionaries-common (1.29.7) ... 137s Setting up cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 137s Setting up postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 137s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 137s Setting up libpq-dev (16.8-0ubuntu0.24.04.1) ... 137s Setting up libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 137s Setting up libecpg-dev (16.8-0ubuntu0.24.04.1) ... 137s Setting up intltool-debian (0.35.0+20060710.6) ... 137s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 137s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.2) ... 137s Setting up postgresql-common (257build1.1) ... 138s 138s Creating config file /etc/postgresql-common/createcluster.conf with new version 138s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 138s en_us 138s Removing obsolete dictionary files: 139s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 139s Setting up dh-strip-nondeterminism (1.13.1-1) ... 139s Setting up libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 139s Setting up hunspell-en-us (1:2020.12.07-2) ... 139s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 139s Setting up libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 139s Setting up libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 139s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 139s Setting up postgresql-16 (16.8-0ubuntu0.24.04.1) ... 139s Creating new PostgreSQL cluster 16/main ... 139s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 139s The files belonging to this database system will be owned by user "postgres". 139s This user must also own the server process. 139s 139s The database cluster will be initialized with locale "C.UTF-8". 139s The default database encoding has accordingly been set to "UTF8". 139s The default text search configuration will be set to "english". 139s 139s Data page checksums are disabled. 139s 139s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 139s creating subdirectories ... ok 139s selecting dynamic shared memory implementation ... posix 139s selecting default max_connections ... 100 139s selecting default shared_buffers ... 128MB 139s selecting default time zone ... Etc/UTC 139s creating configuration files ... ok 140s running bootstrap script ... ok 140s performing post-bootstrap initialization ... ok 140s syncing data to disk ... ok 144s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 144s Setting up gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 144s Setting up po-debconf (1.0.21+nmu1) ... 144s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 144s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 144s Setting up postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 144s Setting up cpp (4:13.2.0-7ubuntu1) ... 144s Setting up postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 144s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 144s Setting up postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 144s Setting up g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 144s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 144s Setting up libtool (2.4.7-7build1) ... 144s Setting up gcc (4:13.2.0-7ubuntu1) ... 144s Setting up dh-autoreconf (20) ... 144s Setting up postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 144s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 144s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 144s Setting up debhelper (13.14.1ubuntu5) ... 144s Setting up g++ (4:13.2.0-7ubuntu1) ... 144s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 144s Setting up build-essential (12.10ubuntu1) ... 144s Processing triggers for libc-bin (2.39-0ubuntu8.4) ... 144s Processing triggers for systemd (255.4-1ubuntu8.6) ... 144s Processing triggers for man-db (2.12.0-4build2) ... 146s Processing triggers for install-info (7.1-3build2) ... 146s Processing triggers for dictionaries-common (1.29.7) ... 149s autopkgtest [12:29:42]: test run-testsuite: [----------------------- 150s ====== Running all tests with umask 077 ======= 150s ### PostgreSQL test 001_packages.t ### 150s 1..22 150s ok 1 - /etc/os-release exists 150s ok 2 - OS is ubuntu 150s ok 3 - OS version is 24.04 150s # PostgreSQL versions installed: 16 150s ok 4 - postgresql-16 installed 150s ok 5 # skip No python2 support 150s ok 6 - postgresql-plpython3-16 installed 150s ok 7 - postgresql-plperl-16 installed 150s ok 8 - postgresql-pltcl-16 installed 150s ok 9 - postgresql-server-dev-16 installed 150s ok 10 # skip No postgresql-contrib-16 package for version 16 150s # postgresql-doc-16 installed 150s ok 11 - At least one doc package installed 150s ok 12 - libecpg-dev installed 150s ok 13 - procps installed 150s ok 14 - netcat-openbsd installed 150s ok 15 - hunspell-en-us installed 150s ok 16 - system has a default UTF-8 locale 150s ok 17 - locale ru_RU exists 150s ok 18 - locale ru_RU.UTF-8 exists 150s ok 19 - user postgres in the UNIX group ssl-cert 150s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 150s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 150s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 150s ### End test 001_packages.t ### 150s 150s ### PostgreSQL test 002_existing_clusters.t ### 150s 1..8 150s # Cleanup 150s ok 1 - Cleanup: No clusters left behind 150s ok 2 - No postgres processes left behind 150s ok 3 - No files in /etc/postgresql left behind 150s ok 4 - No files in /var/lib/postgresql left behind 150s ok 5 - No files in /var/run/postgresql left behind 150s ok 6 - No files in /var/log/postgresql left behind 150s ok 7 - PostgreSQL TCP ports are closed 150s ok 8 - Next free port is 5432 150s ### End test 002_existing_clusters.t ### 150s 150s ### PostgreSQL test 003_alternatives.t ### 150s 1..9 150s # Newest PG version installed is 16 150s ok 1 - psql.1.gz link group 150s ok 2 - postmaster.1.gz link group does not exist 150s ok 3 - psql.1.gz alternative 150s ok 4 - pg_dump.1.gz alternative 150s ok 5 - postgres.1.gz alternative 150s ok 6 - pg_ctl.1.gz alternative 150s # Newest PG doc version installed is 16 150s ok 7 - SPI_connect.3.gz link group 150s ok 8 - SPI_connect.3.gz alternative 150s ok 9 - SPI_exec.3.gz alternative 150s ### End test 003_alternatives.t ### 150s 150s ### PostgreSQL test 005_PgCommon.t ### 150s 1..24 150s ok 1 - correctly parsed line 'local all postgres ident sameuser' 150s ok 2 - correctly parsed line 'local foo nobody trust' 150s ok 3 - correctly parsed line 'local foo nobody crypt' 150s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 150s ok 5 - correctly parsed line 'local foo,bar nobody ident' 150s ok 6 - correctly parsed line 'local all +foogrp password' 150s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 150s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 150s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 150s ok 10 - @expected_records has correct number of entries 150s ok 11 - returned read_pg_hba array has correct number of records 150s ok 12 - line 'foo all all md5' parsed as invalid 150s ok 13 - line 'local all all foo' parsed as invalid 150s ok 14 - line 'host all all foo' parsed as invalid 150s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 150s ok 16 - line 'host all all md5' parsed as invalid 150s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 150s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 150s ok 19 - read_conf_file returns empty dict for nonexisting file 150s ok 20 - read_conf_file() parsing 150s ok 21 - read_conf_file() parsing with include directives 150s ok 22 - set_conf_value 150s ok 23 - disable_conf_value 150s ok 24 - replace_conf_value 150s ### End test 005_PgCommon.t ### 150s 150s ### PostgreSQL test 006_next_free_port.t ### 150s 1..5 150s ok 1 - next_free_port is 5432 151s ok 2 - next_free_port detects localhost ipv4 socket 152s ok 3 - next_free_port detects wildcard ipv4 socket 153s ok 4 - next_free_port detects localhost ipv6 socket 154s ok 5 - next_free_port detects wildcard ipv6 socket 154s ### End test 006_next_free_port.t ### 154s 154s ### PostgreSQL test 007_pg_conftool.t ### 154s 1..41 154s # test without cluster 154s ok 1 - pg_conftool show all 154s ok 2 - correct output of pg_conftool show all 154s ok 3 - pg_conftool foo.conf show all 154s ok 4 - correct output of pg_conftool foo.conf show all 154s ok 5 - pg_conftool /tmp/S59uJqmzSb/different.conf show all 154s ok 6 - correct output of pg_conftool /tmp/S59uJqmzSb/different.conf show all 154s ok 7 - pg_conftool 9.7 main show all 154s ok 8 - correct output of pg_conftool 9.7 main show all 154s # test show 154s ok 9 - pg_conftool show all 154s ok 10 - correct output of pg_conftool show all 154s ok 11 - pg_conftool other.conf show all 154s ok 12 - correct output of pg_conftool other.conf show all 154s ok 13 - pg_conftool /tmp/S59uJqmzSb/different.conf show all 154s ok 14 - correct output of pg_conftool /tmp/S59uJqmzSb/different.conf show all 155s ok 15 - pg_conftool 16 main show all 155s ok 16 - correct output of pg_conftool 16 main show all 155s ok 17 - pg_conftool 16 main other.conf show all 155s ok 18 - correct output of pg_conftool 16 main other.conf show all 155s ok 19 - pg_conftool show a 155s ok 20 - correct output of pg_conftool show a 155s ok 21 - pg_conftool -s show a 155s ok 22 - correct output of pg_conftool -s show a 155s # test set 155s ok 23 - pg_conftool set c 7 155s ok 24 - correct output of pg_conftool set c 7 155s ok 25 - file contains new setting 155s ok 26 - pg_conftool set a 8 155s ok 27 - correct output of pg_conftool set a 8 155s ok 28 - file contains updated setting 155s ok 29 - pg_conftool /tmp/S59uJqmzSb/different.conf set a 9 155s ok 30 - correct output of pg_conftool /tmp/S59uJqmzSb/different.conf set a 9 155s ok 31 - file with path contains updated setting 155s # test remove 155s ok 32 - pg_conftool remove a 155s ok 33 - correct output of pg_conftool remove a 155s ok 34 - setting removed from file 155s ok 35 - pg_conftool /tmp/S59uJqmzSb/different.conf remove a 155s ok 36 - correct output of pg_conftool /tmp/S59uJqmzSb/different.conf remove a 155s ok 37 - setting removed from file with path 155s # test edit 155s ok 38 - pg_conftool edit 155s ok 39 - correct output of pg_conftool edit 155s ok 40 - pg_conftool /tmp/S59uJqmzSb/different.conf edit 155s ok 41 - correct output of pg_conftool /tmp/S59uJqmzSb/different.conf edit 155s ### End test 007_pg_conftool.t ### 155s 155s ### PostgreSQL test 010_defaultport_cluster.t ### 155s 1..14 155s ok 1 - psql --version 155s ok 2 - pg_wrapper selects highest available version number 155s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 155s ok 4 - connecting to localhost fails with no clusters 155s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 155s ok 6 - pg_wrapper uses host and port from PGCLUSTER 155s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 155s ok 8 - pg_wrapper uses --cluster from the command line 155s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 155s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 155s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 155s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 155s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 155s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 155s ### End test 010_defaultport_cluster.t ### 155s 155s ### PostgreSQL test 015_start_stop.t ### 155s 1..71 155s # We are running systemd 155s # Running tests for 16 155s # Cluster does not exist yet 155s ok 1 - cluster 16 main does not exist 155s ok 2 - service postgresql@16-main does not exist 155s ok 3 - systemctl start postgresql 155s ok 4 - cluster 16 main does not exist 155s ok 5 - service postgresql@16-main does not exist 155s ok 6 - systemctl start postgresql@16-main 155s ok 7 - cluster 16 main does not exist 155s ok 8 - service postgresql@16-main does not exist 155s # Start/stop postgresql using system tools 156s ok 9 - pg_createcluster 16 main 156s ok 10 - cluster 16 main is stopped 156s ok 11 - service postgresql@16-main is stopped 159s ok 12 - systemctl start postgresql 159s ok 13 - cluster 16 main is running 159s ok 14 - service postgresql@16-main is running 159s ok 15 - systemctl start postgresql 159s ok 16 - cluster 16 main is already running 159s ok 17 - service postgresql@16-main is already running 159s ok 18 - systemctl stop postgresql 165s ok 19 - cluster 16 main is stopped 165s ok 20 - service postgresql@16-main is stopped 165s ok 21 - systemctl stop postgresql 165s ok 22 - cluster 16 main is already stopped 165s ok 23 - service postgresql@16-main is already stopped 165s # Start/stop specific cluster using system tools 167s ok 24 - systemctl start postgresql@16-main 167s ok 25 - cluster 16 main is running 167s ok 26 - service postgresql@16-main is running 167s ok 27 - systemctl start postgresql@16-main 167s ok 28 - cluster 16 main is running 167s ok 29 - service postgresql@16-main is running 170s ok 30 - systemctl restart postgresql@16-main 170s ok 31 - cluster 16 main is running 170s ok 32 - service postgresql@16-main is running 170s ok 33 - systemctl stop postgresql@16-main 170s ok 34 - cluster 16 main is stopped 170s ok 35 - service postgresql@16-main is stopped 170s ok 36 - systemctl stop postgresql@16-main 170s ok 37 - cluster 16 main is already stopped 170s ok 38 - service postgresql@16-main is already stopped 171s ok 39 - pg_dropcluster 16 main 171s ok 40 - cluster 16 main does not exist 171s ok 41 - service postgresql@16-main does not exist 171s # Start/stop specific cluster using pg_*cluster 171s ok 42 - pg_ctlcluster start 16 main 172s ok 43 - cluster 16 main does not exist 172s ok 44 - service postgresql@16-main does not exist 175s ok 45 - pg_createcluster 16 main --start 175s ok 46 - cluster 16 main is running 175s ok 47 - service postgresql@16-main is running 175s ok 48 - pg_ctlcluster 16 main start 175s ok 49 - cluster 16 main is already running 175s ok 50 - service postgresql@16-main is already running 177s ok 51 - pg_ctlcluster 16-main restart 177s ok 52 - cluster 16 main is running 177s ok 53 - service postgresql@16-main is running 178s ok 54 - pg_ctlcluster 16 main stop 178s ok 55 - cluster 16 main is stopped 178s ok 56 - service postgresql@16-main is stopped 178s ok 57 - pg_ctlcluster 16 main stop 178s ok 58 - cluster 16 main is already stopped 178s ok 59 - service postgresql@16-main is already stopped 180s ok 60 - pg_ctlcluster start 16-main 180s ok 61 - cluster 16 main is running 180s ok 62 - service postgresql@16-main is running 181s ok 63 - pg_dropcluster 16 main --stop 181s # Cleanup 182s ok 64 - Cleanup: No clusters left behind 182s ok 65 - No postgres processes left behind 182s ok 66 - No files in /etc/postgresql left behind 182s ok 67 - No files in /var/lib/postgresql left behind 182s ok 68 - No files in /var/run/postgresql left behind 182s ok 69 - No files in /var/log/postgresql left behind 182s ok 70 - PostgreSQL TCP ports are closed 182s ok 71 - Next free port is 5432 182s ### End test 015_start_stop.t ### 182s 182s ### PostgreSQL test 020_create_sql_remove.t ### 182s 1..147 182s # Running tests for 16 185s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.v8eOX3 185s ok 2 - pg_createcluster 16 main 185s ok 3 - Socket and pid file are in /var/run/postgresql/ 185s ok 4 - xlog/wal directory /tmp/16.xlog.v8eOX3 was created 185s ok 5 - local method in pg_hba.conf is peer 185s ok 6 - host method in pg_hba.conf is scram-sha-256 185s ok 7 - Exactly one postgres master process running 187s ok 8 - pg_ctlcluster 16 main restart 188s ok 9 - cluster restarts with new environment file 188s ok 10 - Exactly one postgres master process running 188s ok 11 - correct value of PGEXTRAVAR1 in environment 188s ok 12 - correct value of PGEXTRAVAR2 in environment 188s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 188s ok 14 - createdb --version 188s ok 15 - pg_wrapper+createdb selects version number of cluster 188s ok 16 - psql --version 188s ok 17 - pg_wrapper+psql selects version 16 188s ok 18 - pg_lscluster reports online cluster on port 5432 188s ok 19 - log file is actually used 188s ok 20 - /etc/postgresql is owned by user "postgres" 188s ok 21 - version configuration directory file is owned by user "postgres" 188s ok 22 - configuration directory file is owned by user "postgres" 188s ok 23 - version data directory file is owned by user "postgres" 188s ok 24 - data directory file is owned by user "postgres" 188s ok 25 - log file has 0640 permissions 188s ok 26 - log file is owned by user "postgres" 188s ok 27 - log file is owned by group "adm" 188s ok 28 - no log symlink by default 188s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 188s ok 30 - pg_lsclusters -h 188s ok 31 - correct output of pg_lsclusters -h 188s ok 32 - stopping cluster 190s ok 33 - restarting cluster with nondefault log symlink 190s ok 34 - log target is used as log file 190s ok 35 - default log is not used 190s ok 36 - pg_lsclusters -h 190s ok 37 - correct output of pg_lsclusters -h 190s ok 38 - stopping cluster 193s ok 39 - restarting cluster with explicitly configured log file 193s ok 40 - default log is not used 193s ok 41 - log symlink target is used for startup message 193s ok 42 - exactly one log file 193s ok 43 - custom log is actually used 193s ok 44 - pg_lsclusters -h 193s ok 45 - correct output of pg_lsclusters -h 193s ok 46 - stopping cluster 193s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 193s ok 48 - /etc/postgres-hack was not created 196s ok 49 - restarting cluster 196s ok 50 - ps -o tty -U postgres h 196s ok 51 - postgres processes do not have an associated terminal 196s ok 52 - Server is linked with SSL support 196s ok 53 - SSL is enabled in postgresql.conf 196s ok 54 - psql -l fails for nobody 196s ok 55 - createuser nobody 196s ok 56 - createdb nobodydb 196s ok 57 - psql -ltA succeeds for nobody 196s ok 58 - psql -ltA output 196s ok 59 - SQL command: create table 196s ok 60 - SQL command: insert into table values 196s ok 61 - SQL command: insert into table values 196s ok 62 - primary key violation 196s ok 63 - psql -tAc "select * from phone order by name" nobodydb 196s ok 64 - SQL command output: select -tA 196s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 196s ok 66 - SQL command output: select -tx 196s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 196s ok 68 - SQL command output: select -tAx 196s ok 69 - CREATE EXTENSION plperlu fails for user nobody 196s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 196s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 196s ok 72 - creating PL/PerlU function as user nobody fails 196s ok 73 - creating unsafe PL/Perl function as user postgres fails 196s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 196s ok 75 - creating PL/PerlU function as user postgres succeeds 196s ok 76 - psql nobodydb -Atc "select read_file()" 196s ok 77 - calling PL/PerlU function 197s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 197s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 197s ok 80 - creating unsafe PL/Perl function as user nobody fails 197s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 197s ok 82 - creating PL/Perl function as user nobody succeeds 197s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 197s ok 84 - calling PL/Perl function 197s ok 85 # skip No python2 support 197s ok 86 # skip No python2 support 197s ok 87 # skip No python2 support 197s ok 88 # skip No python2 support 197s ok 89 # skip No python2 support 197s ok 90 # skip No python2 support 197s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 197s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 197s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 197s ok 94 - creating PL/Python3 function as user postgres succeeds 197s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 197s ok 96 - calling PL/Python function 197s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 197s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 197s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 197s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 197s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 197s ok 102 - creating PL/Tcl function as user nobody succeeds 197s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 197s ok 104 - creating PL/TclU function as user postgres succeeds 197s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 197s ok 106 - calling PL/Tcl function 197s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 197s ok 108 - calling PL/TclU function 197s ok 109 - stopping cluster 197s ok 110 - pg_ctlcluster 16 main start 197s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 200s ok 112 - pg_ctlcluster 16 main start 200s ok 113 - cluster restarts with pgdata symlink 200s ok 114 - postgres master has OOM killer protection 200s ok 115 - postgres client backend has no OOM adjustment 200s ok 116 - ps h 7243 200s ok 117 - process title is idle 201s ok 118 - ps h 7243 201s ok 119 - process title is idle in transaction 201s ok 120 - stopping cluster 203s ok 121 - starting cluster as postgres works without a log file 203s ok 122 - log file got recreated and used 203s ok 123 - creating a directory in spc2 203s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.vLZQpO'" 203s ok 125 - creating tablespace spc1 203s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 203s ok 127 - creating a table in spc1 203s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.gScraL'" 203s ok 129 - creating tablespace spc2 203s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 203s ok 131 - creating a table in spc2 203s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 203s ok 133 - Correct apt NeverAutoRemove config 205s ok 134 - pg_dropcluster removes cluster 205s ok 135 - xlog/wal directory /tmp/16.xlog.v8eOX3 was deleted 205s ok 136 - tablespace spc1 was emptied 205s ok 137 - tablespace spc2 was emptied 205s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 205s ok 139 - Correct apt NeverAutoRemove config 205s # Cleanup 205s ok 140 - Cleanup: No clusters left behind 205s ok 141 - No postgres processes left behind 205s ok 142 - No files in /etc/postgresql left behind 205s ok 143 - No files in /var/lib/postgresql left behind 205s ok 144 - No files in /var/run/postgresql left behind 205s ok 145 - No files in /var/log/postgresql left behind 205s ok 146 - PostgreSQL TCP ports are closed 205s ok 147 - Next free port is 5432 205s ### End test 020_create_sql_remove.t ### 205s 205s ### PostgreSQL test 021_pg_renamecluster.t ### 205s 1..20 208s ok 1 - pg_createcluster 16 main 211s ok 2 - pg_renamecluster 16 main donau 211s ok 3 - psql -tAc "show data_directory" 211s ok 4 - cluster is running and data_directory was moved 211s ok 5 - pg_hba.conf location updated 211s ok 6 - pg_ident.conf location updated 211s ok 7 - external_pid_file location updated 211s ok 8 - external_pid_file exists 211s ok 9 # skip no stats_temp_directory in 16 211s ok 10 # skip no stats_temp_directory in 16 211s ok 11 - cluster_name is updated 212s ok 12 - pg_dropcluster removes cluster 212s # Cleanup 212s ok 13 - Cleanup: No clusters left behind 212s ok 14 - No postgres processes left behind 212s ok 15 - No files in /etc/postgresql left behind 212s ok 16 - No files in /var/lib/postgresql left behind 212s ok 17 - No files in /var/run/postgresql left behind 212s ok 18 - No files in /var/log/postgresql left behind 213s ok 19 - PostgreSQL TCP ports are closed 213s ok 20 - Next free port is 5432 213s ### End test 021_pg_renamecluster.t ### 213s 213s ### PostgreSQL test 022_recovery.t ### 213s 1..17 213s # Running tests for 16 216s ok 1 - pg_createcluster 16 main --start >/dev/null 216s ok 2 - pg_ctlcluster 16 main stop -m i 218s ok 3 - pg_ctlcluster 16 main start 218s ok 4 - psql -c '' 218s ok 5 - pg_ctlcluster 16 main stop -m i 218s ok 6 - create write-protected file in data directory 221s ok 7 - pg_ctlcluster 16 main start 221s ok 8 - psql -c '' 223s ok 9 - pg_dropcluster removes cluster 223s # Cleanup 223s ok 10 - Cleanup: No clusters left behind 223s ok 11 - No postgres processes left behind 223s ok 12 - No files in /etc/postgresql left behind 223s ok 13 - No files in /var/lib/postgresql left behind 223s ok 14 - No files in /var/run/postgresql left behind 223s ok 15 - No files in /var/log/postgresql left behind 223s ok 16 - PostgreSQL TCP ports are closed 223s ok 17 - Next free port is 5432 223s ### End test 022_recovery.t ### 223s 223s ### PostgreSQL test 025_logging.t ### 223s 1..55 223s # Logging to /var/log/syslog works 223s # Running tests for 16 228s ok 1 - pg_createcluster 16 main 228s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 228s ok 3 - psql -qc "'foobar_16_8422'" 228s ok 4 - log an error 228s ok 5 - grep --binary-files=text foobar_16_8422 /var/log/postgresql/postgresql-16-main.log 228s ok 6 - error appears in logfile 228s ok 7 - pg_conftool 16 main set log_destination syslog 228s ok 8 - set log_destination syslog 228s ok 9 - pg_ctlcluster 16 main reload 228s ok 10 - 16 main reload 228s ok 11 - psql -Atc "show log_destination" 228s ok 12 - log_destination is syslog 228s ok 13 - pg_lscluster reports syslog 229s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 229s ok 15 - error appears in /var/log/syslog 229s ok 16 - pg_conftool 16 main set logging_collector on 229s ok 17 - set logging_collector on 229s ok 18 - pg_conftool 16 main set log_destination csvlog 229s ok 19 - set log_destination csvlog 231s ok 20 - pg_ctlcluster 16 main restart 231s ok 21 - 16 main restart 231s ok 22 - psql -Atc "show logging_collector" 231s ok 23 - logging_collector is on 231s ok 24 - psql -Atc "show log_destination" 231s ok 25 - log_destination is csvlog 231s ok 26 - pg_lscluster reports csvlog 231s ok 27 - psql -qc "'barbaz_16_8422'" 231s ok 28 - log an error 232s ok 29 - grep --binary-files=text barbaz_16_8422 /var/lib/postgresql/16/main/log/*.csv 232s ok 30 - error appears in log/*.csv 232s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 232s ok 32 - set log_destination stderr,syslog,csvlog 232s ok 33 - pg_ctlcluster 16 main reload 232s ok 34 - 16 main reload 232s ok 35 - psql -Atc "show log_destination" 232s ok 36 - log_destination is stderr,syslog,csvlog 232s ok 37 - pg_lscluster reports stderr,syslog,csvlog 232s ok 38 - psql -qc "'moo_16_8422'" 232s ok 39 - log an error 233s ok 40 - grep --binary-files=text moo_16_8422 /var/lib/postgresql/16/main/log/*.log 233s ok 41 - error appears in log/*.log 233s ok 42 - grep --binary-files=text 'postgres.*moo_16_8422' /var/log/syslog 233s ok 43 - error appears in /var/log/syslog 233s ok 44 - grep --binary-files=text moo_16_8422 /var/lib/postgresql/16/main/log/*.csv 233s ok 45 - error appears in log/*.csv 235s ok 46 - pg_dropcluster 16 main --stop 235s ok 47 - pg_dropcluster removes cluster 235s # Cleanup 235s ok 48 - Cleanup: No clusters left behind 235s ok 49 - No postgres processes left behind 235s ok 50 - No files in /etc/postgresql left behind 235s ok 51 - No files in /var/lib/postgresql left behind 235s ok 52 - No files in /var/run/postgresql left behind 235s ok 53 - No files in /var/log/postgresql left behind 235s ok 54 - PostgreSQL TCP ports are closed 235s ok 55 - Next free port is 5432 235s ### End test 025_logging.t ### 235s 235s ### PostgreSQL test 030_errors.t ### 235s 1..156 235s ok 1 - pg_lscluster reports cluster without binaries 236s ok 2 - pg_dropcluster 6.3 main 237s ok 3 - pg_createcluster --socketdir 237s ok 4 - pg_lsclusters -h 237s ok 5 - cluster was created 237s ok 6 - Port of created cluster is 5432 237s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 237s ok 8 - pg_createcluster on existing cluster 237s ok 9 - pg_lsclusters -h 237s ok 10 - original cluster still exists 237s ok 11 - pg_createcluster 16 test -p foo 237s ok 12 - pg_createcluster -p checks that port option is numeric 237s ok 13 - pg_createcluster 16 test -p 42 237s ok 14 - pg_createcluster -p checks valid port range 237s ok 15 - pg_ctlcluster 16 main start 237s ok 16 - pg_ctlcluster refuses to start root-owned cluster 237s ok 17 - pg_ctlcluster 16 main start 237s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 237s ok 19 - pg_ctlcluster 16 main start 237s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 237s ok 21 - pg_ctlcluster 16 main start 237s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 239s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 239s ok 24 - No sockets in /var/run/postgresql 239s ok 25 - Socket is in /tmp/postgresql-testsuite/ 239s ok 26 - cluster stops with custom unix_socket_dir 239s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 242s ok 28 - cluster starts after removing unix_socket_dir 242s ok 29 - Socket is in default dir /var/run/postgresql 242s ok 30 - No sockets in /tmp/postgresql-testsuite/ 242s ok 31 - pg_ctlcluster 16 main stop 242s ok 32 - pg_ctlcluster fails with corrupted PID file 242s ok 33 - pg_lsclusters -h 242s ok 34 - cluster is still online 242s ok 35 - pg_ctlcluster succeeds with restored PID file 242s ok 36 - pg_lsclusters -h 242s ok 37 - cluster is down 242s ok 38 - pg_ctlcluster 16 main stop 242s ok 39 - pg_ctlcluster stop fails on stopped cluster 244s ok 40 - pg_ctlcluster 16 main start 244s ok 41 - pg_ctlcluster succeeds with already existing PID file 244s ok 42 - pg_lsclusters -h 244s ok 43 - cluster is online 244s ok 44 - pg_ctlcluster stop succeeds 244s ok 45 - pg_lsclusters -h 244s ok 46 - cluster is down 244s ok 47 - no pid file left 244s ok 48 - pg_ctlcluster 16 main stop 244s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 244s ok 50 - pid file was cleaned up 244s ok 51 - pg_ctlcluster --force 16 main stop 244s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 244s ok 53 - pid file was cleaned up 245s ok 54 - pg_ctlcluster 16 main stop 245s ok 55 - pg_ctlcluster stop succeeds with stale PID file 245s ok 56 - pid file was cleaned up 245s ok 57 - pg_ctlcluster --force 16 main stop 245s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 245s ok 59 - pid file was cleaned up 245s ok 60 - pg_ctlcluster --force 16 main stop 245s ok 61 - pg_ctlcluster stop succeeds with empty PID file 245s ok 62 - pid file was cleaned up 247s ok 63 - pg_ctlcluster 16 main start 247s ok 64 - pg_ctlcluster succeeds with corrupted PID file 247s ok 65 - pg_lsclusters -h 247s ok 66 - cluster is online 247s ok 67 - pg_ctlcluster 16 main start 247s ok 68 - pg_ctlcluster start fails on running cluster 247s ok 69 - pg_ctlcluster stop 247s ok 70 - pg_ctlcluster 16 main start 247s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 247s ok 72 - pg_ctlcluster 16 main stop 247s ok 73 - stopping cluster 253s ok 74 - pg_ctlcluster 16 main start 253s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 254s ok 76 - pg_ctlcluster 16 main stop 254s ok 77 - stopping cluster 254s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 254s ok 79 - pg_dropcluster 16 main 254s ok 80 - pg_dropcluster works as user postgres 255s ok 81 - pg_createcluster succeeds 255s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 255s ok 83 - proper error message for nonexisting /var/lib/postgresql 257s ok 84 - pg_ctlcluster 16 main start 257s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 257s ok 86 - pg_ctlcluster 16 main stop 257s ok 87 - stopping cluster 258s ok 88 - pg_createcluster other 260s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 263s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 263s ok 91 263s ok 92 - pg_ctlcluster 16 other start 263s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 263s ok 94 - pg_ctlcluster 16 main stop 263s ok 95 - stopping main cluster 265s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 266s ok 97 - pg_dropcluster other 269s ok 98 - pg_dropcluster 269s ok 99 - No sockets any more 269s ok 100 - 'pg_lsclusters 4.5 foo' fails 269s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 269s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 269s ok 103 - 'psql --cluster 4.5/foo' fails 269s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 269s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 269s ok 106 - 'psql --cluster 16/foo' fails 269s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 269s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 269s ok 109 - 'pg_dropcluster 4.5 foo' fails 269s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 269s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 269s ok 112 - 'pg_dropcluster 16 foo' fails 269s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 269s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 269s ok 115 - 'pg_upgradecluster 4.5 foo' fails 269s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 269s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 269s ok 118 - 'pg_upgradecluster 16 foo' fails 269s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 269s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 269s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 269s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 269s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 269s ok 124 - 'pg_ctlcluster 16 foo stop' fails 269s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 269s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 269s # Cleanup 269s ok 127 - Cleanup: No clusters left behind 269s ok 128 - No postgres processes left behind 269s ok 129 - No files in /etc/postgresql left behind 269s ok 130 - No files in /var/lib/postgresql left behind 269s ok 131 - No files in /var/run/postgresql left behind 269s ok 132 - No files in /var/log/postgresql left behind 269s ok 133 - PostgreSQL TCP ports are closed 269s ok 134 - Next free port is 5432 269s ok 135 - pg_dropcluster 16 broken 269s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 269s # Cleanup 269s ok 137 - Cleanup: No clusters left behind 269s ok 138 - No postgres processes left behind 269s ok 139 - No files in /etc/postgresql left behind 269s ok 140 - No files in /var/lib/postgresql left behind 269s ok 141 - No files in /var/run/postgresql left behind 269s ok 142 - No files in /var/log/postgresql left behind 269s ok 143 - PostgreSQL TCP ports are closed 269s ok 144 - Next free port is 5432 270s ok 145 - pg_dropcluster 16 broken 270s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 270s ok 147 - /etc/postgresql/16 was removed 270s ok 148 - /var/lib/postgresql/16 was removed 270s # Cleanup 270s ok 149 - Cleanup: No clusters left behind 270s ok 150 - No postgres processes left behind 270s ok 151 - No files in /etc/postgresql left behind 270s ok 152 - No files in /var/lib/postgresql left behind 270s ok 153 - No files in /var/run/postgresql left behind 270s ok 154 - No files in /var/log/postgresql left behind 270s ok 155 - PostgreSQL TCP ports are closed 270s ok 156 - Next free port is 5432 270s ### End test 030_errors.t ### 270s 270s ### PostgreSQL test 031_errors_disk_full.t ### 270s 1..22 270s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 272s ok 1 - script failed 272s ok 2 - pg_createcluster fails due to insufficient disk space 272s ok 3 - does not leave files behind 272s # Cleanup 272s ok 4 - Cleanup: No clusters left behind 272s ok 5 - No postgres processes left behind 272s ok 6 - No files in /etc/postgresql left behind 272s ok 7 - No files in /var/lib/postgresql left behind 272s ok 8 - No files in /var/run/postgresql left behind 272s ok 9 - No files in /var/log/postgresql left behind 272s ok 10 - PostgreSQL TCP ports are closed 272s ok 11 - Next free port is 5432 272s # check disk full conditions on startup 274s ok 12 - script failed 274s ok 13 - pg_ctlcluster prints error message 274s ok 14 - log file has error message 274s # Cleanup 274s ok 15 - Cleanup: No clusters left behind 274s ok 16 - No postgres processes left behind 274s ok 17 - No files in /etc/postgresql left behind 274s ok 18 - No files in /var/lib/postgresql left behind 274s ok 19 - No files in /var/run/postgresql left behind 274s ok 20 - No files in /var/log/postgresql left behind 274s ok 21 - PostgreSQL TCP ports are closed 274s ok 22 - Next free port is 5432 274s ### End test 031_errors_disk_full.t ### 274s 274s ### PostgreSQL test 032_ssl_key_permissions.t ### 274s 1..22 274s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 274s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 274s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 274s # 16 (16.8-0ubuntu0.24.04.1) 275s ok 4 - pg_createcluster 16 main 275s ok 5 - pg_ctlcluster 16 main start 275s ok 6 - ssl key owned by nobody refused 275s ok 7 - pg_ctlcluster 16 main start 275s ok 8 - ssl key with permissions root:root 0644 refused 275s ok 9 - pg_ctlcluster 16 main start 275s ok 10 - ssl key with permissions postgres:postgres 0640 refused 277s ok 11 - pg_dropcluster 16 main --stop 277s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 277s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 277s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 277s # Cleanup 277s ok 15 - Cleanup: No clusters left behind 277s ok 16 - No postgres processes left behind 277s ok 17 - No files in /etc/postgresql left behind 277s ok 18 - No files in /var/lib/postgresql left behind 277s ok 19 - No files in /var/run/postgresql left behind 277s ok 20 - No files in /var/log/postgresql left behind 277s ok 21 - PostgreSQL TCP ports are closed 277s ok 22 - Next free port is 5432 277s ### End test 032_ssl_key_permissions.t ### 277s 277s ### PostgreSQL test 040_upgrade.t ### 277s 1..1 277s ok 1 - only one major version installed, skipping upgrade tests 277s ### End test 040_upgrade.t ### 277s 277s ### PostgreSQL test 041_upgrade_custompaths.t ### 277s 1..1 277s ok 1 - only one major version installed, skipping upgrade tests 277s ### End test 041_upgrade_custompaths.t ### 277s 277s ### PostgreSQL test 042_upgrade_rename.t ### 277s 1..15 277s # PostgreSQL 16 280s ok 1 - pg_createcluster 16 main --start 286s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 286s ok 3 - pg_lsclusters -h 286s ok 4 - correct output of pg_lsclusters -h 287s ok 5 - pg_dropcluster 16 main --stop 289s ok 6 - pg_dropcluster 16 upgr --stop 289s ok 7 - Cleaning pg_upgrade log files 289s # Cleanup 289s ok 8 - Cleanup: No clusters left behind 289s ok 9 - No postgres processes left behind 289s ok 10 - No files in /etc/postgresql left behind 289s ok 11 - No files in /var/lib/postgresql left behind 289s ok 12 - No files in /var/run/postgresql left behind 289s ok 13 - No files in /var/log/postgresql left behind 289s ok 14 - PostgreSQL TCP ports are closed 289s ok 15 - Next free port is 5432 289s ### End test 042_upgrade_rename.t ### 289s 289s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 289s 1..1 289s ok 1 - only one major version installed, skipping upgrade tests 289s ### End test 043_upgrade_ssl_cert.t ### 289s 289s ### PostgreSQL test 045_backup.t ### 289s # We are running systemd 289s # PostgreSQL 16 289s # create cluster 292s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 292s ok 2 - pg_lsclusters -h 292s ok 3 - correct output of pg_lsclusters -h 292s ok 4 - pg_conftool 16 main set work_mem 11MB 292s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 292s ok 6 - psql -c 'alter database mydb set search_path=public' 292s ok 7 - psql -c 'create table foo (t text)' mydb 292s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 292s ok 9 - psql -c 'CREATE USER myuser' 292s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 293s ok 11 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 293s ok 12 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 293s # create directory 293s ok 13 - pg_backupcluster 16 main createdirectory 293s ok 14 - /var/backups/postgresql/16-main owned by uid postgres 293s ok 15 - /var/backups/postgresql/16-main owned by gid postgres 293s # dump 293s ok 16 - systemctl start pg_dump@16-main 293s ok 17 - dump created in /var/backups/postgresql/16-main/2025-04-25T123206Z.dump 293s ok 18 - /var/backups/postgresql/16-main/2025-04-25T123206Z.dump owned by uid postgres 293s ok 19 - /var/backups/postgresql/16-main/2025-04-25T123206Z.dump owned by gid postgres 293s # basebackup 293s ok 20 - systemctl start pg_receivewal@16-main 293s ok 21 - psql -c 'create table poke_receivewal (t text)' mydb 294s ok 22 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 484s ok 23 - systemctl start pg_basebackup@16-main 484s ok 24 - dump created in /var/backups/postgresql/16-main/2025-04-25T123207Z.backup 484s ok 25 - /var/backups/postgresql/16-main/2025-04-25T123207Z.backup owned by uid postgres 484s ok 26 - /var/backups/postgresql/16-main/2025-04-25T123207Z.backup owned by gid postgres 484s # list 484s ok 27 - pg_backupcluster 16 main list 484s ok 28 - correct output of pg_backupcluster 16 main list 484s # more database changes 484s ok 29 - psql -c "insert into foo values ('data later deleted')" mydb 484s ok 30 - psql -c "insert into foo values ('data from archive')" mydb 484s ok 31 - retrieve recovery timestamp 484s ok 32 - psql -c "delete from foo where t = 'data later deleted'" mydb 485s ok 33 - systemctl stop pg_receivewal@16-main 485s # restore /var/backups/postgresql/16-main/2025-04-25T123206Z.dump 486s ok 34 - pg_dropcluster 16 main --stop 490s ok 35 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123206Z.dump --start --datadir /var/lib/postgresql/16/snowflake 490s ok 36 - pg_lsclusters -h 490s ok 37 - correct output of pg_lsclusters -h 490s ok 38 - psql -XAtl 490s ok 39 - mydb locales 490s ok 40 - myicudb locales 490s ok 41 - psql -XAtc 'show work_mem' 490s ok 42 - correct output of psql -XAtc 'show work_mem' 490s ok 43 - psql -XAtc 'select * from foo' mydb 490s ok 44 - correct output of psql -XAtc 'select * from foo' mydb 490s ok 45 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 490s ok 46 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 490s ok 47 - psql -XAtc '\drds' 490s ok 48 - correct output of psql -XAtc '\drds' 490s # restore /var/backups/postgresql/16-main/2025-04-25T123207Z.backup 492s ok 49 - pg_dropcluster 16 main --stop 495s ok 50 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123207Z.backup --start --datadir /var/lib/postgresql/16/snowflake 495s ok 51 - pg_lsclusters -h 495s ok 52 - correct output of pg_lsclusters -h 495s ok 53 - psql -XAtl 495s ok 54 - mydb locales 495s ok 55 - myicudb locales 495s ok 56 - psql -XAtc 'show work_mem' 495s ok 57 - correct output of psql -XAtc 'show work_mem' 495s ok 58 - psql -XAtc 'select * from foo' mydb 495s ok 59 - correct output of psql -XAtc 'select * from foo' mydb 495s ok 60 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 495s ok 61 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 495s ok 62 - psql -XAtc '\drds' 495s ok 63 - correct output of psql -XAtc '\drds' 495s # restore /var/backups/postgresql/16-main/2025-04-25T123207Z.backup with WAL archive 497s ok 64 - pg_dropcluster 16 main --stop 500s ok 65 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123207Z.backup --start --archive --port 5430 500s ok 66 - pg_lsclusters -h 500s ok 67 - correct output of pg_lsclusters -h 500s ok 68 - psql -XAtc 'select * from foo order by t' mydb 500s ok 69 - correct output of psql -XAtc 'select * from foo order by t' mydb 500s # restore /var/backups/postgresql/16-main/2025-04-25T123207Z.backup with PITR 502s ok 70 - pg_dropcluster 16 main --stop 505s ok 71 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-04-25T123207Z.backup --start --pitr '2025-04-25 12:35:17.491047+00 505s # ' 505s ok 72 - pg_lsclusters -h 505s ok 73 - correct output of pg_lsclusters -h 506s ok 74 - psql -XAtc 'select * from foo order by t' mydb 506s ok 75 - correct output of psql -XAtc 'select * from foo order by t' mydb 507s ok 76 - pg_dropcluster 16 main --stop 507s # Cleanup 507s ok 77 - Cleanup: No clusters left behind 507s ok 78 - No postgres processes left behind 507s ok 79 - No files in /etc/postgresql left behind 507s ok 80 - No files in /var/lib/postgresql left behind 507s ok 81 - No files in /var/run/postgresql left behind 507s ok 82 - No files in /var/log/postgresql left behind 507s ok 83 - PostgreSQL TCP ports are closed 507s ok 84 - Next free port is 5432 507s 1..84 507s ### End test 045_backup.t ### 507s 507s ### PostgreSQL test 050_encodings.t ### 507s 1..60 507s # Checking 16 ru_RU 511s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 512s ok 2 - psql -l succeeds 512s ok 3 - template1 is not UTF-8 encoded 512s ok 4 - creating test database 512s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 512s # create table t (x varchar); copy t from stdin" test 512s ok 6 - creating table with ISO-8859-5 characters 512s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 512s ok 8 - correct string in UTF-8 512s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 512s ok 10 - correct string in ISO-8859-5 512s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 512s # delete from t; copy t from stdin" test 512s ok 12 - creating table with UTF-8 characters 512s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 512s ok 14 - correct string in UTF-8 512s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 512s ok 16 - correct string in ISO-8859-1 512s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 512s ok 18 - Server error message has correct language and encoding 514s ok 19 - pg_ctlcluster 16 ru_RU restart 514s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 516s ok 21 - Dropping cluster 516s # Checking 16 ru_RU.UTF-8 519s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 520s ok 23 - psql -l succeeds 520s ok 24 - template1 is UTF-8 encoded 520s ok 25 - creating test database 520s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 520s # create table t (x varchar); copy t from stdin" test 520s ok 27 - creating table with ISO-8859-5 characters 520s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 520s ok 29 - correct string in UTF-8 520s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 520s ok 31 - correct string in ISO-8859-5 520s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 520s # delete from t; copy t from stdin" test 520s ok 33 - creating table with UTF-8 characters 520s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 520s ok 35 - correct string in UTF-8 520s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 520s ok 37 - correct string in ISO-8859-1 520s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 520s ok 39 - Server error message has correct language and encoding 523s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 523s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 523s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 523s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 523s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 523s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 523s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 523s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 524s ok 48 - Dropping cluster 524s # Check 16 locale environment variables 528s ok 49 - pg_createcluster: LC_ALL dominates LANG 528s ok 50 - psql -Atl --cluster 16/main 528s ok 51 - template1 is ASCII encoded 529s ok 52 - Dropping cluster 529s # Cleanup 529s ok 53 - Cleanup: No clusters left behind 529s ok 54 - No postgres processes left behind 529s ok 55 - No files in /etc/postgresql left behind 529s ok 56 - No files in /var/lib/postgresql left behind 529s ok 57 - No files in /var/run/postgresql left behind 529s ok 58 - No files in /var/log/postgresql left behind 529s ok 59 - PostgreSQL TCP ports are closed 529s ok 60 - Next free port is 5432 529s ### End test 050_encodings.t ### 529s 529s ### PostgreSQL test 052_upgrade_encodings.t ### 529s 1..1 529s ok 1 - only one major version installed, skipping upgrade tests 529s ### End test 052_upgrade_encodings.t ### 529s 529s ### PostgreSQL test 060_obsolete_confparams.t ### 530s ok 1 - only one major version installed, skipping upgrade tests 530s 1..1 530s ### End test 060_obsolete_confparams.t ### 530s 530s ### PostgreSQL test 070_non_postgres_clusters.t ### 530s 1..40 530s ok 1 - pg_createcluster 16 main for owner nobody 530s ok 2 - pg_ctlcluster 16 main start 530s ok 3 - start refused when config and data owners mismatch 533s ok 4 - pg_ctlcluster succeeds with owner nobody 533s ok 5 - pg_lsclusters -h 533s ok 6 - pg_lsclusters shows running cluster 533s ok 7 - postgres is running as user nobody 533s ok 8 - ls /tmp/.s.PGSQL.* 533s ok 9 - socket is in /tmp 533s ok 10 - /var/run/postgresql is empty 533s ok 11 - conf dir is owned by user 533s ok 12 - conf dir is owned by user's primary group 533s ok 13 - files are owned by user 533s ok 14 - files are owned by user's primary group 533s ok 15 - log file has 0640 permissions 533s ok 16 - log file is owned by user 533s ok 17 - log file is owned by user's primary group 533s ok 18 - only one major version installed, skipping upgrade test 533s ok 19 - ... 533s ok 20 - ... 533s ok 21 - ... 533s ok 22 - ... 533s ok 23 - ... 533s ok 24 - ... 533s ok 25 - ... 533s ok 26 - ... 533s ok 27 - ... 533s ok 28 - ... 534s ok 29 - pg_dropcluster 534s ok 30 - pg_lsclusters -h 534s ok 31 - No clusters left 534s ok 32 - No postgres processes left 534s # Cleanup 534s ok 33 - Cleanup: No clusters left behind 534s ok 34 - No postgres processes left behind 534s ok 35 - No files in /etc/postgresql left behind 534s ok 36 - No files in /var/lib/postgresql left behind 534s ok 37 - No files in /var/run/postgresql left behind 534s ok 38 - No files in /var/log/postgresql left behind 534s ok 39 - PostgreSQL TCP ports are closed 534s ok 40 - Next free port is 5432 534s ### End test 070_non_postgres_clusters.t ### 534s 534s ### PostgreSQL test 080_start.conf.t ### 534s 1..73 535s ok 1 - pg_createcluster 16 main 535s # start.conf auto 535s ok 2 - get_cluster_start_conf returns auto 535s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 535s ok 4 - start.conf contains auto 535s ok 5 - systemd generator links cluster 535s ok 6 - systemd generator links correct service file 537s ok 7 - /etc/init.d/postgresql start 16 537s ok 8 - correct output of /etc/init.d/postgresql start 16 537s ok 9 - pg_lsclusters -h 537s ok 10 - cluster is online 537s ok 11 - /etc/init.d/postgresql stop 16 537s ok 12 - correct output of /etc/init.d/postgresql stop 16 540s ok 13 - pg_lsclusters -h 540s ok 14 - cluster is down 540s # start.conf manual 540s ok 15 - get_cluster_start_conf returns manual 540s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 540s ok 17 - start.conf contains manual 541s ok 18 - systemd generator doesn't link cluster 541s ok 19 - /etc/init.d/postgresql start 16 541s ok 20 - correct output of /etc/init.d/postgresql start 16 541s ok 21 - pg_lsclusters -h 541s ok 22 - cluster is down 543s ok 23 - pg_ctlcluster 16 main start 543s ok 24 - correct output of pg_ctlcluster 16 main start 543s ok 25 - pg_lsclusters -h 543s ok 26 - cluster is online 543s ok 27 - pg_ctlcluster 16 main stop 543s ok 28 - correct output of pg_ctlcluster 16 main stop 543s ok 29 - pg_lsclusters -h 543s ok 30 - cluster is down 543s # start.conf disabled 543s ok 31 - get_cluster_start_conf returns disabled 543s ok 32 - systemd generator doesn't link cluster 544s ok 33 - /etc/init.d/postgresql start 16 544s ok 34 - correct output of /etc/init.d/postgresql start 16 544s ok 35 - pg_lsclusters -h 544s ok 36 - cluster is down 544s ok 37 - pg_ctlcluster 16 main start 544s ok 38 - correct output of pg_ctlcluster 16 main start 544s ok 39 - pg_lsclusters -h 544s ok 40 - cluster is down 546s ok 41 - pg_ctlcluster 16 main start 546s ok 42 - correct output of pg_ctlcluster 16 main start 546s ok 43 - pg_lsclusters -h 546s ok 44 - cluster is online 546s ok 45 - pg_ctlcluster 16 main stop 546s ok 46 - correct output of pg_ctlcluster 16 main stop 546s ok 47 - pg_lsclusters -h 546s ok 48 - cluster is down 548s ok 49 - pg_ctlcluster 16 main start 548s ok 50 - correct output of pg_ctlcluster 16 main start 548s ok 51 - pg_lsclusters -h 548s ok 52 - cluster is online 548s # test upgrade 548s ok 53 - only one major version installed, skipping upgrade test 548s ok 54 - ... 548s ok 55 - get_cluster_start_conf for old cluster returns manual 548s ok 56 - get_cluster_start_conf for new cluster returns manual 548s ok 57 - ... 550s ok 58 - dropping upgraded cluster 550s ok 59 - pg_lsclusters -h 550s ok 60 - no clusters any more 550s ok 61 - pg_createcluster 16 main --start-conf foo 550s ok 62 - pg_createcluster checks --start-conf validity 550s ok 63 - pg_createcluster checks --start-conf manual 550s ok 64 - get_cluster_start_conf returns manual 551s ok 65 - dropping cluster 551s # Cleanup 551s ok 66 - Cleanup: No clusters left behind 551s ok 67 - No postgres processes left behind 551s ok 68 - No files in /etc/postgresql left behind 551s ok 69 - No files in /var/lib/postgresql left behind 551s ok 70 - No files in /var/run/postgresql left behind 551s ok 71 - No files in /var/log/postgresql left behind 551s ok 72 - PostgreSQL TCP ports are closed 551s ok 73 - Next free port is 5432 551s ### End test 080_start.conf.t ### 551s 551s ### PostgreSQL test 085_pg_ctl.conf.t ### 551s 1..33 551s ok 1 - prlimit --core=0:unlimited --pid=16553 551s ok 2 - set core file size to unlimited 551s ok 3 - sh -c 'ulimit -Hc' 551s ok 4 - core file size is unlimited 552s ok 5 - pg_createcluster 16 main 552s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 555s ok 7 - pg_ctlcluster 16 main start 555s ok 8 - starting cluster as root 555s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 555s ok 10 - soft core size is 0 555s # hard core file size limit of root-started postgres process is unlimited 555s ok 11 - set pg_ctl default option to -c 557s ok 12 - pg_ctlcluster 16 main restart 557s ok 13 - restarting cluster as root 557s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 557s ok 15 - soft core size is unlimited 557s ok 16 - pg_ctlcluster 16 main stop 557s ok 17 - stopping cluster 557s ok 18 - restored pg_ctl default option 559s ok 19 - pg_ctlcluster 16 main start -- -c 559s ok 20 - starting cluster with -c on the command line as postgres 559s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 559s ok 22 - soft core size is unlimited 559s ok 23 - pg_ctlcluster 16 main stop 559s ok 24 - stopping cluster 561s ok 25 - dropping cluster 561s # Cleanup 561s ok 26 - Cleanup: No clusters left behind 561s ok 27 - No postgres processes left behind 561s ok 28 - No files in /etc/postgresql left behind 561s ok 29 - No files in /var/lib/postgresql left behind 561s ok 30 - No files in /var/run/postgresql left behind 561s ok 31 - No files in /var/log/postgresql left behind 561s ok 32 - PostgreSQL TCP ports are closed 561s ok 33 - Next free port is 5432 561s ### End test 085_pg_ctl.conf.t ### 561s 561s ### PostgreSQL test 090_multicluster.t ### 561s 1..125 562s ok 1 - pg_createcluster 16 old 563s ok 2 - pg_createcluster 16 new1 564s ok 3 - pg_createcluster 16 new2 566s ok 4 - starting cluster 16/old 568s ok 5 - starting cluster 16/new1 570s ok 6 - starting cluster 16/new2 570s ok 7 - pg_lsclusters -h | sort -k3 570s ok 8 - clusters have the correct ports, skipping used 5433 570s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 570s ok 10 - createdb --version 570s ok 11 - pg_wrapper selects port 5432 as default cluster 570s ok 12 - createdb --cluster 16/new1 --version 570s ok 13 - pg_wrapper --cluster works 571s ok 14 - createdb --cluster 16/foo --version 571s ok 15 - pg_wrapper --cluster errors out for invalid cluster 571s ok 16 - createdb --cluster 16/new1 test 571s ok 17 - correct output of createdb --cluster 16/new1 test 571s ok 18 - psql -Atl --cluster 16/new1 571s ok 19 - test db appears in cluster new1 571s ok 20 - psql -Atl --cluster 16/new2 571s ok 21 - test db does not appear in cluster new2 571s ok 22 - psql -Atl 571s ok 23 - test db does not appear in default cluster 571s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 571s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 571s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 571s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 571s ok 28 - psql -Atl --cluster 16/localhost:5434 571s ok 29 - test db appears in cluster 16/localhost:5434 571s ok 30 - psql -Atl --cluster 16/localhost:5440 571s ok 31 - test db does not appear in cluster 16/localhost:5440 571s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 571s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 571s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 571s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 571s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 571s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 571s ok 38 - psql -Atl --cluster 6.4/localhost: 571s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 571s ok 40 - psql -Atl 571s ok 41 - PGCLUSTER selection (1) 571s ok 42 - psql -Atl 571s ok 43 - PGCLUSTER selection (2) 571s ok 44 - psql -l 571s ok 45 - invalid PGCLUSTER value 571s ok 46 - createdb --version 571s ok 47 - PGCLUSTER network cluster selection (1) 571s ok 48 - psql -Atl 571s ok 49 - PGCLUSTER network cluster selection (2) 571s ok 50 - psql -Atl 571s ok 51 - PGCLUSTER network cluster selection (3) 571s ok 52 - LC_MESSAGES=C psql -Atl 571s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 571s ok 54 - psql -Atc "show port" template1 571s ok 55 - PGPORT selection (1) 571s ok 56 - psql -Atc "show port" template1 571s ok 57 - PGPORT selection (2) 571s ok 58 - createdb --version 571s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 572s ok 60 - psql -Atc "show port" template1 572s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 572s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 572s ok 63 - PGDATABASE environment variable works 572s ok 64 - createdb --version 572s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 572s ok 66 - createdb --cluster 16/new1 --version 572s ok 67 - pg_wrapper --cluster works with empty user_clusters 572s ok 68 - createdb --version 572s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 572s ok 70 - psql -Atc "select current_database()" 572s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 572s ok 72 - psql -Atc 'select current_database()' 572s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 572s ok 74 - createdb --version 572s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 572s ok 76 - createdb --version 572s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 572s ok 78 - createdb --version 572s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 572s ok 80 - createdb --version 572s ok 81 - pg_wrapper selects correct version with per-user user_clusters 572s ok 82 - createdb --version 572s ok 83 - pg_wrapper selects correct version with per-user user_clusters 572s ok 84 - createdb --version 572s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 572s ok 86 - psql -Atl 572s ok 87 - $PGHOST overrides user_clusters 572s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 572s ok 89 - --cluster overrides $PGHOST 572s ok 90 - createdb --version 572s ok 91 - pg_wrapper ignores invalid lines in user_clusters 572s ok 92 - psql -Atc 'select current_database()' 572s ok 93 - pg_service conf selection 1 572s ok 94 - psql -Atc 'select current_database()' 572s ok 95 - pg_service conf selection 2 572s ok 96 - psql -Atc 'select current_database()' 572s ok 97 - pg_service conf selection 3 572s ok 98 - stopping cluster 16/old 575s ok 99 - restarting cluster 16/old 575s ok 100 - pg_lsclusters -h | sort -k3 575s ok 101 - port of first cluster was successfully changed 575s ok 102 - psql -l 575s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 575s ok 104 - psql -Atl --cluster 16/new1 575s ok 105 - --cluster selects appropriate cluster 575s ok 106 - psql -Atl -p 5434 575s ok 107 - -p selects appropriate cluster 575s ok 108 - psql -Atlp 5434 575s ok 109 - -Atlp selects appropriate cluster 575s ok 110 - psql -Atl --port 5434 575s ok 111 - --port selects appropriate cluster 575s ok 112 - env PGPORT=5434 psql -Atl 575s ok 113 - $PGPORT selects appropriate cluster 575s ok 114 - Restoring original /etc/postgresql-common/user_clusters 576s ok 115 - dropping 16/new1 578s ok 116 - dropping 16/new2 579s ok 117 - dropping 16/old 579s # Cleanup 579s ok 118 - Cleanup: No clusters left behind 579s ok 119 - No postgres processes left behind 579s ok 120 - No files in /etc/postgresql left behind 579s ok 121 - No files in /var/lib/postgresql left behind 579s ok 122 - No files in /var/run/postgresql left behind 579s ok 123 - No files in /var/log/postgresql left behind 579s ok 124 - PostgreSQL TCP ports are closed 579s ok 125 - Next free port is 5432 579s ### End test 090_multicluster.t ### 579s 579s ### PostgreSQL test 110_integrate_cluster.t ### 579s 1..32 580s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/vEJ4pUHSTQ/c/postgres 580s ok 2 - creating raw initdb cluster for user postgres 580s ok 3 - pg_createcluster 16 postgres -d /tmp/vEJ4pUHSTQ/c/postgres 580s ok 4 - integrating postgres cluster 581s ok 5 - pg_lsclusters 581s ok 6 - correct pg_lsclusters output 583s ok 7 - pg_ctlcluster 16 postgres start 583s ok 8 - starting cluster postgres 583s ok 9 - pg_lsclusters 583s ok 10 - correct pg_lsclusters output 584s ok 11 - dropping cluster postgres 584s ok 12 - No files in temporary cluster dir left behind 585s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/vEJ4pUHSTQ/c/nobody 585s ok 14 - creating raw initdb cluster for user nobody 586s ok 15 - pg_createcluster 16 nobody -d /tmp/vEJ4pUHSTQ/c/nobody 586s ok 16 - integrating nobody cluster 586s ok 17 - pg_lsclusters 586s ok 18 - correct pg_lsclusters output 588s ok 19 - pg_ctlcluster 16 nobody start 588s ok 20 - starting cluster nobody 588s ok 21 - pg_lsclusters 588s ok 22 - correct pg_lsclusters output 589s ok 23 - dropping cluster nobody 589s ok 24 - No files in temporary cluster dir left behind 589s # Cleanup 589s ok 25 - Cleanup: No clusters left behind 589s ok 26 - No postgres processes left behind 589s ok 27 - No files in /etc/postgresql left behind 589s ok 28 - No files in /var/lib/postgresql left behind 589s ok 29 - No files in /var/run/postgresql left behind 589s ok 30 - No files in /var/log/postgresql left behind 589s ok 31 - PostgreSQL TCP ports are closed 589s ok 32 - Next free port is 5432 589s ### End test 110_integrate_cluster.t ### 589s 589s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 589s 1..1 589s ok 1 - only one major version installed, skipping upgrade tests 589s ### End test 120_pg_upgradecluster_scripts.t ### 589s 589s ### PostgreSQL test 130_nonroot_admin.t ### 590s 1..22 592s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 592s ok 2 - pg_lsclusters -h 592s ok 3 - correct output of pg_lsclusters -h 592s ok 4 - psql -Atl 592s ok 5 - correct output of psql -Atl 593s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 593s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 593s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 593s # Cleanup 593s ok 15 - Cleanup: No clusters left behind 593s ok 16 - No postgres processes left behind 593s ok 17 - No files in /etc/postgresql left behind 593s ok 18 - No files in /var/lib/postgresql left behind 593s ok 19 - No files in /var/run/postgresql left behind 593s ok 20 - No files in /var/log/postgresql left behind 593s ok 21 - PostgreSQL TCP ports are closed 593s ok 22 - Next free port is 5432 593s ### End test 130_nonroot_admin.t ### 593s 593s ### PostgreSQL test 135_pg_virtualenv.t ### 593s 1..20 597s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 597s ok 2 - running pg_virtualenv as root 601s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 601s ok 4 - running pg_virtualenv as postgres 604s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 604s ok 6 - running pg_virtualenv as nobody 607s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 607s ok 8 - running fakeroot pg_virtualenv as root 610s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 610s ok 10 - running fakeroot pg_virtualenv as postgres 613s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 613s ok 12 - running fakeroot pg_virtualenv as nobody 613s # Cleanup 613s ok 13 - Cleanup: No clusters left behind 614s ok 14 - No postgres processes left behind 614s ok 15 - No files in /etc/postgresql left behind 614s ok 16 - No files in /var/lib/postgresql left behind 614s ok 17 - No files in /var/run/postgresql left behind 614s ok 18 - No files in /var/log/postgresql left behind 614s ok 19 - PostgreSQL TCP ports are closed 614s ok 20 - Next free port is 5432 614s ### End test 135_pg_virtualenv.t ### 614s 614s ### PostgreSQL test 140_pg_config.t ### 614s 1..38 614s # Multiarch is enabled 614s # checking version specific output for 16 614s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 614s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 614s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 614s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 614s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 614s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 614s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 614s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 614s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 614s # checking pg_config output (should behave like version 16) 614s ok 15 - pg_config 614s ok 16 - correct output of pg_config 614s ok 17 - pg_config --help 614s ok 18 - correct output of pg_config --help 614s ok 19 - pg_config --pgxs 614s ok 20 - correct output of pg_config --pgxs 614s ok 21 - pg_config --libdir 614s ok 22 - correct output of pg_config --libdir 614s ok 23 - pg_config --pkglibdir 614s ok 24 - correct output of pg_config --pkglibdir 614s ok 25 - pg_config --bindir 614s ok 26 - correct output of pg_config --bindir 614s # checking pg_config.libpq-dev output (should behave like version 16) 614s ok 27 - pg_config.libpq-dev 614s ok 28 - correct output of pg_config.libpq-dev 614s ok 29 - pg_config.libpq-dev --help 614s ok 30 - correct output of pg_config.libpq-dev --help 614s ok 31 - pg_config.libpq-dev --pgxs 614s ok 32 - correct output of pg_config.libpq-dev --pgxs 614s ok 33 - pg_config.libpq-dev --libdir 614s ok 34 - correct output of pg_config.libpq-dev --libdir 614s ok 35 - pg_config.libpq-dev --pkglibdir 614s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 614s ok 37 - pg_config.libpq-dev --bindir 614s ok 38 - correct output of pg_config.libpq-dev --bindir 614s ### End test 140_pg_config.t ### 614s 614s ### PostgreSQL test 150_tsearch_stemming.t ### 614s 1..37 614s ok 1 - pg_updatedicts succeeded 614s ok 2 - pg_updatedicts created en_us.affix 614s ok 3 - pg_updatedicts created en_us.dict 614s ok 4 - pg_updatedicts created 16 en_us.affix symlink 614s ok 5 - pg_updatedicts created 16 en_us.dict symlink 617s ok 6 - pg_createcluster 16 main 617s ok 7 - createdb fts 617s ok 8 - correct output of createdb fts 617s ok 9 - creating en_US full text search configuration 617s ok 10 - creating data table and search index 617s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 617s ok 12 - stem search of correct word 618s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 618s ok 14 - stem search of correct word 618s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 618s ok 16 - stem search of unknown word 618s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 618s ok 18 - full text search, exact word 618s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 618s ok 20 - full text search for word stem 618s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 618s ok 22 - full text search for word substring fails 618s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 618s ok 24 - full text search, exact unicode word 618s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 618s ok 26 - full text search for unicode word stem 618s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 618s ok 28 - full text search for unicode word substring fails 619s ok 29 619s # Cleanup 619s ok 30 - Cleanup: No clusters left behind 619s ok 31 - No postgres processes left behind 619s ok 32 - No files in /etc/postgresql left behind 619s ok 33 - No files in /var/lib/postgresql left behind 619s ok 34 - No files in /var/run/postgresql left behind 619s ok 35 - No files in /var/log/postgresql left behind 619s ok 36 - PostgreSQL TCP ports are closed 619s ok 37 - Next free port is 5432 619s ### End test 150_tsearch_stemming.t ### 619s 619s ### PostgreSQL test 160_alternate_confroot.t ### 619s 1..28 622s ok 1 622s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 622s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 623s ok 4 - pg_lsclusters -h 623s ok 5 - correct output of pg_lsclusters -h 623s ok 6 - psql -Atl 623s ok 7 - correct output of psql -Atl 623s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 623s ok 9 - ... 623s ok 10 - ... 623s ok 11 - ... 623s ok 12 - ... 623s ok 13 - ... 623s ok 14 - ... 623s ok 15 - pg_dropcluster 16 test --stop 623s ok 16 - correct output of pg_dropcluster 16 test --stop 623s ok 17 - pg_lsclusters -h 623s ok 18 - correct output of pg_lsclusters -h 623s ok 19 - No files in root/data left behind 623s ok 20 - No cruft in root dir left behind 623s # Cleanup 623s ok 21 - Cleanup: No clusters left behind 623s ok 22 - No postgres processes left behind 623s ok 23 - No files in /etc/postgresql left behind 623s ok 24 - No files in /var/lib/postgresql left behind 623s ok 25 - No files in /var/run/postgresql left behind 623s ok 26 - No files in /var/log/postgresql left behind 623s ok 27 - PostgreSQL TCP ports are closed 623s ok 28 - Next free port is 5432 623s ### End test 160_alternate_confroot.t ### 623s 623s ### PostgreSQL test 170_extensions.t ### 623s # Running tests for 16 626s ok 1 - pg_createcluster 16 main 626s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 626s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 626s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 626s ok 5 - extension adminpack installs without error 626s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 626s ok 7 - extension adminpack removes without error 626s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 626s ok 9 - extension amcheck installs without error 626s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 626s ok 11 - extension amcheck removes without error 626s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 626s ok 13 - extension autoinc installs without error 626s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 626s ok 15 - extension autoinc removes without error 626s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 626s ok 17 - extension bloom installs without error 626s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 626s ok 19 - extension bloom removes without error 626s ok 20 - psql -qc 'CREATE EXTENSION plperl' 626s ok 21 - bool_plperl dependency plperl installs without error 627s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 627s ok 23 - extension bool_plperl installs without error 627s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 627s ok 25 - extension bool_plperl removes without error 627s ok 26 - psql -qc 'DROP EXTENSION plperl' 627s ok 27 - bool_plperl dependency extension plperl removes without error 627s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 627s ok 29 - bool_plperlu dependency plperlu installs without error 627s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 627s ok 31 - extension bool_plperlu installs without error 627s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 627s ok 33 - extension bool_plperlu removes without error 627s ok 34 - psql -qc 'DROP EXTENSION plperlu' 627s ok 35 - bool_plperlu dependency extension plperlu removes without error 627s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 627s ok 37 - extension btree_gin installs without error 627s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 627s ok 39 - extension btree_gin removes without error 627s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 627s ok 41 - extension btree_gist installs without error 627s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 627s ok 43 - extension btree_gist removes without error 627s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 627s ok 45 - extension citext installs without error 627s ok 46 - psql -qc 'DROP EXTENSION "citext"' 627s ok 47 - extension citext removes without error 627s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 627s ok 49 - extension cube installs without error 627s ok 50 - psql -qc 'DROP EXTENSION "cube"' 627s ok 51 - extension cube removes without error 627s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 627s ok 53 - extension dblink installs without error 627s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 627s ok 55 - extension dblink removes without error 627s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 627s ok 57 - extension dict_int installs without error 627s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 627s ok 59 - extension dict_int removes without error 627s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 627s ok 61 - extension dict_xsyn installs without error 627s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 627s ok 63 - extension dict_xsyn removes without error 627s ok 64 - psql -qc 'CREATE EXTENSION cube' 628s ok 65 - earthdistance dependency cube installs without error 628s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 628s ok 67 - extension earthdistance installs without error 628s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 628s ok 69 - extension earthdistance removes without error 628s ok 70 - psql -qc 'DROP EXTENSION cube' 628s ok 71 - earthdistance dependency extension cube removes without error 628s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 628s ok 73 - extension file_fdw installs without error 628s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 628s ok 75 - extension file_fdw removes without error 628s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 628s ok 77 - extension fuzzystrmatch installs without error 628s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 628s ok 79 - extension fuzzystrmatch removes without error 628s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 628s ok 81 - extension hstore installs without error 628s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 628s ok 83 - extension hstore removes without error 628s ok 84 - psql -qc 'CREATE EXTENSION hstore' 628s ok 85 - hstore_plperl dependency hstore installs without error 628s ok 86 - psql -qc 'CREATE EXTENSION plperl' 628s ok 87 - hstore_plperl dependency plperl installs without error 628s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 628s ok 89 - extension hstore_plperl installs without error 628s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 628s ok 91 - extension hstore_plperl removes without error 628s ok 92 - psql -qc 'DROP EXTENSION hstore' 628s ok 93 - hstore_plperl dependency extension hstore removes without error 628s ok 94 - psql -qc 'DROP EXTENSION plperl' 628s ok 95 - hstore_plperl dependency extension plperl removes without error 628s ok 96 - psql -qc 'CREATE EXTENSION hstore' 628s ok 97 - hstore_plperlu dependency hstore installs without error 628s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 628s ok 99 - hstore_plperlu dependency plperlu installs without error 628s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 628s ok 101 - extension hstore_plperlu installs without error 628s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 628s ok 103 - extension hstore_plperlu removes without error 629s ok 104 - psql -qc 'DROP EXTENSION hstore' 629s ok 105 - hstore_plperlu dependency extension hstore removes without error 629s ok 106 - psql -qc 'DROP EXTENSION plperlu' 629s ok 107 - hstore_plperlu dependency extension plperlu removes without error 629s ok 108 - psql -qc 'CREATE EXTENSION hstore' 629s ok 109 - hstore_plpython3u dependency hstore installs without error 629s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 629s ok 111 - hstore_plpython3u dependency plpython3u installs without error 629s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 629s ok 113 - extension hstore_plpython3u installs without error 629s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 629s ok 115 - extension hstore_plpython3u removes without error 629s ok 116 - psql -qc 'DROP EXTENSION hstore' 629s ok 117 - hstore_plpython3u dependency extension hstore removes without error 629s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 629s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 629s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 629s ok 121 - extension insert_username installs without error 629s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 629s ok 123 - extension insert_username removes without error 629s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 629s ok 125 - extension intagg installs without error 629s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 629s ok 127 - extension intagg removes without error 629s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 629s ok 129 - extension intarray installs without error 629s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 629s ok 131 - extension intarray removes without error 629s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 629s ok 133 - extension isn installs without error 629s ok 134 - psql -qc 'DROP EXTENSION "isn"' 629s ok 135 - extension isn removes without error 629s ok 136 - psql -qc 'CREATE EXTENSION plperl' 629s ok 137 - jsonb_plperl dependency plperl installs without error 629s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 629s ok 139 - extension jsonb_plperl installs without error 629s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 629s ok 141 - extension jsonb_plperl removes without error 629s ok 142 - psql -qc 'DROP EXTENSION plperl' 629s ok 143 - jsonb_plperl dependency extension plperl removes without error 629s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 629s ok 145 - jsonb_plperlu dependency plperlu installs without error 629s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 629s ok 147 - extension jsonb_plperlu installs without error 630s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 630s ok 149 - extension jsonb_plperlu removes without error 630s ok 150 - psql -qc 'DROP EXTENSION plperlu' 630s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 630s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 630s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 630s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 630s ok 155 - extension jsonb_plpython3u installs without error 630s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 630s ok 157 - extension jsonb_plpython3u removes without error 630s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 630s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 630s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 630s ok 161 - extension lo installs without error 630s ok 162 - psql -qc 'DROP EXTENSION "lo"' 630s ok 163 - extension lo removes without error 630s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 630s ok 165 - extension ltree installs without error 630s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 630s ok 167 - extension ltree removes without error 630s ok 168 - psql -qc 'CREATE EXTENSION ltree' 630s ok 169 - ltree_plpython3u dependency ltree installs without error 630s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 630s ok 171 - ltree_plpython3u dependency plpython3u installs without error 630s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 630s ok 173 - extension ltree_plpython3u installs without error 630s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 630s ok 175 - extension ltree_plpython3u removes without error 630s ok 176 - psql -qc 'DROP EXTENSION ltree' 630s ok 177 - ltree_plpython3u dependency extension ltree removes without error 630s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 630s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 630s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 630s ok 181 - extension moddatetime installs without error 630s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 630s ok 183 - extension moddatetime removes without error 630s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 630s ok 185 - extension old_snapshot installs without error 630s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 630s ok 187 - extension old_snapshot removes without error 630s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 630s ok 189 - extension pageinspect installs without error 631s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 631s ok 191 - extension pageinspect removes without error 631s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 631s ok 193 - extension pg_buffercache installs without error 631s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 631s ok 195 - extension pg_buffercache removes without error 631s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 631s ok 197 - extension pg_freespacemap installs without error 631s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 631s ok 199 - extension pg_freespacemap removes without error 631s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 631s ok 201 - extension pg_prewarm installs without error 631s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 631s ok 203 - extension pg_prewarm removes without error 631s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 631s ok 205 - extension pg_stat_statements installs without error 631s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 631s ok 207 - extension pg_stat_statements removes without error 631s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 631s ok 209 - extension pg_surgery installs without error 631s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 631s ok 211 - extension pg_surgery removes without error 631s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 631s ok 213 - extension pg_trgm installs without error 631s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 631s ok 215 - extension pg_trgm removes without error 631s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 631s ok 217 - extension pg_visibility installs without error 631s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 631s ok 219 - extension pg_visibility removes without error 631s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 631s ok 221 - extension pg_walinspect installs without error 631s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 631s ok 223 - extension pg_walinspect removes without error 631s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 631s ok 225 - extension pgcrypto installs without error 631s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 631s ok 227 - extension pgcrypto removes without error 631s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 631s ok 229 - extension pgrowlocks installs without error 631s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 631s ok 231 - extension pgrowlocks removes without error 631s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 631s ok 233 - extension pgstattuple installs without error 632s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 632s ok 235 - extension pgstattuple removes without error 632s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 632s ok 237 - extension plperl installs without error 632s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 632s ok 239 - extension plperl removes without error 632s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 632s ok 241 - extension plperlu installs without error 632s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 632s ok 243 - extension plperlu removes without error 632s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 632s ok 245 - extension plpython3u installs without error 632s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 632s ok 247 - extension plpython3u removes without error 632s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 632s ok 249 - extension pltcl installs without error 632s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 632s ok 251 - extension pltcl removes without error 632s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 632s ok 253 - extension pltclu installs without error 632s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 632s ok 255 - extension pltclu removes without error 632s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 632s ok 257 - extension postgres_fdw installs without error 632s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 632s ok 259 - extension postgres_fdw removes without error 632s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 632s ok 261 - extension refint installs without error 632s ok 262 - psql -qc 'DROP EXTENSION "refint"' 632s ok 263 - extension refint removes without error 632s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 632s ok 265 - extension seg installs without error 632s ok 266 - psql -qc 'DROP EXTENSION "seg"' 632s ok 267 - extension seg removes without error 632s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 632s ok 269 - extension sslinfo installs without error 632s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 632s ok 271 - extension sslinfo removes without error 632s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 632s ok 273 - extension tablefunc installs without error 632s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 632s ok 275 - extension tablefunc removes without error 632s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 632s ok 277 - extension tcn installs without error 632s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 632s ok 279 - extension tcn removes without error 633s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 633s ok 281 - extension tsm_system_rows installs without error 633s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 633s ok 283 - extension tsm_system_rows removes without error 633s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 633s ok 285 - extension tsm_system_time installs without error 633s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 633s ok 287 - extension tsm_system_time removes without error 633s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 633s ok 289 - extension unaccent installs without error 633s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 633s ok 291 - extension unaccent removes without error 633s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 633s ok 293 - extension uuid-ossp installs without error 633s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 633s ok 295 - extension uuid-ossp removes without error 633s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 633s ok 297 - extension xml2 installs without error 633s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 633s ok 299 - extension xml2 removes without error 635s ok 300 - pg_dropcluster 16 main 635s # Cleanup 635s ok 301 - Cleanup: No clusters left behind 635s ok 302 - No postgres processes left behind 635s ok 303 - No files in /etc/postgresql left behind 635s ok 304 - No files in /var/lib/postgresql left behind 635s ok 305 - No files in /var/run/postgresql left behind 635s ok 306 - No files in /var/log/postgresql left behind 635s ok 307 - PostgreSQL TCP ports are closed 635s ok 308 - Next free port is 5432 635s 1..308 635s ### End test 170_extensions.t ### 635s 635s ### PostgreSQL test 180_ecpg.t ### 635s 1..14 635s ok 1 - ecpg test.pgc 635s ok 2 - ecpg processing 635s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 635s ok 4 - compiling ecpg output 642s ok 5 - pg_virtualenv /tmp/tmp.rxTpNli440/test 642s ok 6 - test program runs and gives correct output 642s # Cleanup 642s ok 7 - Cleanup: No clusters left behind 642s ok 8 - No postgres processes left behind 642s ok 9 - No files in /etc/postgresql left behind 642s ok 10 - No files in /var/lib/postgresql left behind 642s ok 11 - No files in /var/run/postgresql left behind 642s ok 12 - No files in /var/log/postgresql left behind 642s ok 13 - PostgreSQL TCP ports are closed 642s ok 14 - Next free port is 5432 642s ### End test 180_ecpg.t ### 642s 642s ### PostgreSQL test 190_pg_buildext.t ### 642s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 642s 1..1 642s ### End test 190_pg_buildext.t ### 642s 642s ### PostgreSQL test 200_maintscripts.t ### 642s 1..15 642s # We are running systemd 645s ok 1 - pg_createcluster 16 main --start 645s ok 2 - postmaster PID is 21494 647s ok 3 - apt-get update -q 647s # postgresql-common: 647s # Installed: 257build1.1 647s # Candidate: 257build1.1 647s # Version table: 647s # *** 257build1.1 500 647s # 500 http://ftpmaster.internal/ubuntu noble-updates/main amd64 Packages 647s # 500 http://ftpmaster.internal/ubuntu noble-updates/main i386 Packages 647s # 100 /var/lib/dpkg/status 647s # 257build1 500 647s # 500 http://ftpmaster.internal/ubuntu noble/main amd64 Packages 647s # 500 http://ftpmaster.internal/ubuntu noble/main i386 Packages 650s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 650s # postgresql-common: 650s # Installed: 257build1.1 650s # Candidate: 257build1.1 650s # Version table: 650s # *** 257build1.1 500 650s # 500 http://ftpmaster.internal/ubuntu noble-updates/main amd64 Packages 650s # 500 http://ftpmaster.internal/ubuntu noble-updates/main i386 Packages 650s # 100 /var/lib/dpkg/status 650s # 257build1 500 650s # 500 http://ftpmaster.internal/ubuntu noble/main amd64 Packages 650s # 500 http://ftpmaster.internal/ubuntu noble/main i386 Packages 650s ok 5 - postmaster PID is 21494 650s ok 6 - postmaster was not restarted 651s ok 7 - pg_dropcluster 16 main --stop 651s # Cleanup 651s ok 8 - Cleanup: No clusters left behind 651s ok 9 - No postgres processes left behind 651s ok 10 - No files in /etc/postgresql left behind 651s ok 11 - No files in /var/lib/postgresql left behind 651s ok 12 - No files in /var/run/postgresql left behind 651s ok 13 - No files in /var/log/postgresql left behind 651s ok 14 - PostgreSQL TCP ports are closed 651s ok 15 - Next free port is 5432 651s ### End test 200_maintscripts.t ### 651s 652s autopkgtest [12:38:05]: test run-testsuite: -----------------------] 652s run-testsuite PASS 652s autopkgtest [12:38:05]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 653s autopkgtest [12:38:06]: test installcheck: preparing testbed 720s autopkgtest [12:39:13]: testbed dpkg architecture: amd64 721s autopkgtest [12:39:14]: testbed apt version: 2.7.14build2 721s autopkgtest [12:39:14]: @@@@@@@@@@@@@@@@@@@@ test bed setup 721s autopkgtest [12:39:14]: testbed release detected to be: noble 722s autopkgtest [12:39:15]: updating testbed package index (apt update) 722s Get:1 http://ftpmaster.internal/ubuntu noble-proposed InRelease [265 kB] 722s Hit:2 http://ftpmaster.internal/ubuntu noble InRelease 722s Hit:3 http://ftpmaster.internal/ubuntu noble-updates InRelease 723s Hit:4 http://ftpmaster.internal/ubuntu noble-security InRelease 723s Get:5 http://ftpmaster.internal/ubuntu noble-proposed/restricted Sources [15.8 kB] 723s Get:6 http://ftpmaster.internal/ubuntu noble-proposed/main Sources [49.2 kB] 723s Get:7 http://ftpmaster.internal/ubuntu noble-proposed/multiverse Sources [6316 B] 723s Get:8 http://ftpmaster.internal/ubuntu noble-proposed/universe Sources [62.8 kB] 723s Get:9 http://ftpmaster.internal/ubuntu noble-proposed/main i386 Packages [42.9 kB] 723s Get:10 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 Packages [211 kB] 723s Get:11 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 c-n-f Metadata [2248 B] 723s Get:12 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 Packages [258 kB] 723s Get:13 http://ftpmaster.internal/ubuntu noble-proposed/restricted i386 Packages [9304 B] 723s Get:14 http://ftpmaster.internal/ubuntu noble-proposed/restricted amd64 c-n-f Metadata [116 B] 723s Get:15 http://ftpmaster.internal/ubuntu noble-proposed/universe i386 Packages [337 kB] 723s Get:16 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 Packages [467 kB] 723s Get:17 http://ftpmaster.internal/ubuntu noble-proposed/universe amd64 c-n-f Metadata [7448 B] 723s Get:18 http://ftpmaster.internal/ubuntu noble-proposed/multiverse i386 Packages [2412 B] 723s Get:19 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 Packages [11.0 kB] 723s Get:20 http://ftpmaster.internal/ubuntu noble-proposed/multiverse amd64 c-n-f Metadata [116 B] 726s Fetched 1747 kB in 1s (1960 kB/s) 727s Reading package lists... 728s autopkgtest [12:39:21]: upgrading testbed (apt dist-upgrade and autopurge) 728s Reading package lists... 728s Building dependency tree... 728s Reading state information... 729s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 729s Starting 2 pkgProblemResolver with broken count: 0 729s Done 729s Entering ResolveByKeep 729s 729s The following packages will be upgraded: 729s tzdata 729s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 729s Need to get 276 kB of archives. 729s After this operation, 0 B of additional disk space will be used. 729s Get:1 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 tzdata all 2025b-0ubuntu0.24.04.1 [276 kB] 730s Preconfiguring packages ... 730s Fetched 276 kB in 1s (549 kB/s) 730s (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 ... 106231 files and directories currently installed.) 730s Preparing to unpack .../tzdata_2025b-0ubuntu0.24.04.1_all.deb ... 730s Unpacking tzdata (2025b-0ubuntu0.24.04.1) over (2025b-0ubuntu0.24.04) ... 730s Setting up tzdata (2025b-0ubuntu0.24.04.1) ... 730s 730s Current default time zone: 'Etc/UTC' 730s Local time is now: Fri Apr 25 12:39:23 UTC 2025. 730s Universal Time is now: Fri Apr 25 12:39:23 UTC 2025. 730s Run 'dpkg-reconfigure tzdata' if you wish to change it. 730s 731s Reading package lists... 731s Building dependency tree... 731s Reading state information... 731s Starting pkgProblemResolver with broken count: 0 731s Starting 2 pkgProblemResolver with broken count: 0 731s Done 732s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 734s Reading package lists... 735s Building dependency tree... 735s Reading state information... 735s Starting pkgProblemResolver with broken count: 0 735s Starting 2 pkgProblemResolver with broken count: 0 735s Done 735s The following NEW packages will be installed: 735s build-essential clang-17 cpp cpp-13 cpp-13-x86-64-linux-gnu 735s cpp-x86-64-linux-gnu g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu 735s gcc gcc-13 gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu 735s icu-devtools libasan8 libatomic1 libcc1-0 libclang-common-17-dev 735s libclang-cpp17t64 libclang1-17t64 libecpg-compat3 libecpg-dev libecpg6 735s libffi-dev libgc1 libgcc-13-dev libgomp1 libhwasan0 libicu-dev libisl23 735s libitm1 libjson-perl libllvm17t64 liblsan0 libmpc3 libncurses-dev 735s libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libquadmath0 735s libssl-dev libstdc++-13-dev libtcl8.6 libtsan2 libubsan1 libxml2-dev 735s libxslt1.1 libz3-4 libz3-dev llvm-17 llvm-17-dev llvm-17-linker-tools 735s llvm-17-runtime llvm-17-tools postgresql-16 postgresql-client-16 735s postgresql-client-common postgresql-common postgresql-doc-16 735s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 735s postgresql-server-dev-16 ssl-cert tzdata-legacy 735s 0 upgraded, 70 newly installed, 0 to remove and 0 not upgraded. 735s Need to get 222 MB of archives. 735s After this operation, 1068 MB of additional disk space will be used. 735s Get:1 http://ftpmaster.internal/ubuntu noble/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 736s Get:2 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-common all 257build1.1 [36.4 kB] 736s Get:3 http://ftpmaster.internal/ubuntu noble/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 736s Get:4 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-common all 257build1.1 [161 kB] 736s Get:5 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-base amd64 13.3.0-6ubuntu2~24.04 [51.5 kB] 736s Get:6 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libisl23 amd64 0.26-3build1.1 [680 kB] 736s Get:7 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libmpc3 amd64 1.3.1-1build1.1 [54.6 kB] 736s Get:8 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [10.7 MB] 736s Get:9 http://ftpmaster.internal/ubuntu noble-updates/main amd64 cpp-13 amd64 13.3.0-6ubuntu2~24.04 [1038 B] 736s Get:10 http://ftpmaster.internal/ubuntu noble/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 736s Get:11 http://ftpmaster.internal/ubuntu noble/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 736s Get:12 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libcc1-0 amd64 14.2.0-4ubuntu2~24.04 [48.0 kB] 736s Get:13 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgomp1 amd64 14.2.0-4ubuntu2~24.04 [148 kB] 736s Get:14 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libitm1 amd64 14.2.0-4ubuntu2~24.04 [29.7 kB] 736s Get:15 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libatomic1 amd64 14.2.0-4ubuntu2~24.04 [10.5 kB] 736s Get:16 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libasan8 amd64 14.2.0-4ubuntu2~24.04 [3031 kB] 736s Get:17 http://ftpmaster.internal/ubuntu noble-updates/main amd64 liblsan0 amd64 14.2.0-4ubuntu2~24.04 [1322 kB] 736s Get:18 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libtsan2 amd64 14.2.0-4ubuntu2~24.04 [2772 kB] 736s Get:19 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libubsan1 amd64 14.2.0-4ubuntu2~24.04 [1184 kB] 736s Get:20 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libhwasan0 amd64 14.2.0-4ubuntu2~24.04 [1641 kB] 736s Get:21 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libquadmath0 amd64 14.2.0-4ubuntu2~24.04 [153 kB] 736s Get:22 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libgcc-13-dev amd64 13.3.0-6ubuntu2~24.04 [2681 kB] 736s Get:23 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [21.1 MB] 737s Get:24 http://ftpmaster.internal/ubuntu noble-updates/main amd64 gcc-13 amd64 13.3.0-6ubuntu2~24.04 [494 kB] 737s Get:25 http://ftpmaster.internal/ubuntu noble/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 737s Get:26 http://ftpmaster.internal/ubuntu noble/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 737s Get:27 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libstdc++-13-dev amd64 13.3.0-6ubuntu2~24.04 [2420 kB] 737s Get:28 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13-x86-64-linux-gnu amd64 13.3.0-6ubuntu2~24.04 [12.2 MB] 737s Get:29 http://ftpmaster.internal/ubuntu noble-updates/main amd64 g++-13 amd64 13.3.0-6ubuntu2~24.04 [16.1 kB] 737s Get:30 http://ftpmaster.internal/ubuntu noble/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 737s Get:31 http://ftpmaster.internal/ubuntu noble/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 737s Get:32 http://ftpmaster.internal/ubuntu noble/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 737s Get:33 http://ftpmaster.internal/ubuntu noble/main amd64 libllvm17t64 amd64 1:17.0.6-9ubuntu1 [26.2 MB] 738s Get:34 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-cpp17t64 amd64 1:17.0.6-9ubuntu1 [12.9 MB] 740s Get:35 http://ftpmaster.internal/ubuntu noble/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 740s Get:36 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc4 amd64 14.2.0-4ubuntu2~24.04 [47.0 kB] 740s Get:37 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 libobjc-13-dev amd64 13.3.0-6ubuntu2~24.04 [194 kB] 740s Get:38 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang-common-17-dev amd64 1:17.0.6-9ubuntu1 [690 kB] 740s Get:39 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-linker-tools amd64 1:17.0.6-9ubuntu1 [1308 kB] 740s Get:40 http://ftpmaster.internal/ubuntu noble/universe amd64 libclang1-17t64 amd64 1:17.0.6-9ubuntu1 [7353 kB] 740s Get:41 http://ftpmaster.internal/ubuntu noble/universe amd64 clang-17 amd64 1:17.0.6-9ubuntu1 [78.6 kB] 740s Get:42 http://ftpmaster.internal/ubuntu noble-updates/main amd64 icu-devtools amd64 74.2-1ubuntu3.1 [212 kB] 740s Get:43 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpgtypes3 amd64 16.8-0ubuntu0.24.04.1 [44.5 kB] 740s Get:44 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq5 amd64 16.8-0ubuntu0.24.04.1 [142 kB] 740s Get:45 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg6 amd64 16.8-0ubuntu0.24.04.1 [44.6 kB] 740s Get:46 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-compat3 amd64 16.8-0ubuntu0.24.04.1 [12.4 kB] 740s Get:47 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libssl-dev amd64 3.0.13-0ubuntu3.5 [2408 kB] 740s Get:48 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libpq-dev amd64 16.8-0ubuntu0.24.04.1 [151 kB] 740s Get:49 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libecpg-dev amd64 16.8-0ubuntu0.24.04.1 [266 kB] 740s Get:50 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libicu-dev amd64 74.2-1ubuntu3.1 [11.9 MB] 740s Get:51 http://ftpmaster.internal/ubuntu noble/main amd64 libncurses-dev amd64 6.4+20240113-1ubuntu2 [384 kB] 740s Get:52 http://ftpmaster.internal/ubuntu noble/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 740s Get:53 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3.2 [780 kB] 740s Get:54 http://ftpmaster.internal/ubuntu noble-updates/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu0.24.04.2 [167 kB] 740s Get:55 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-runtime amd64 1:17.0.6-9ubuntu1 [529 kB] 740s Get:56 http://ftpmaster.internal/ubuntu noble/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 740s Get:57 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17 amd64 1:17.0.6-9ubuntu1 [23.8 MB] 741s Get:58 http://ftpmaster.internal/ubuntu noble/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 741s Get:59 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-tools amd64 1:17.0.6-9ubuntu1 [518 kB] 741s Get:60 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 741s Get:61 http://ftpmaster.internal/ubuntu noble/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 741s Get:62 http://ftpmaster.internal/ubuntu noble/universe amd64 llvm-17-dev amd64 1:17.0.6-9ubuntu1 [43.4 MB] 743s Get:63 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-client-16 amd64 16.8-0ubuntu0.24.04.1 [1292 kB] 743s Get:64 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-16 amd64 16.8-0ubuntu0.24.04.1 [15.5 MB] 744s Get:65 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-doc-16 all 16.8-0ubuntu0.24.04.1 [2126 kB] 744s Get:66 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plperl-16 amd64 16.8-0ubuntu0.24.04.1 [68.7 kB] 744s Get:67 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-plpython3-16 amd64 16.8-0ubuntu0.24.04.1 [76.9 kB] 744s Get:68 http://ftpmaster.internal/ubuntu noble-updates/main amd64 postgresql-pltcl-16 amd64 16.8-0ubuntu0.24.04.1 [31.8 kB] 744s Get:69 http://ftpmaster.internal/ubuntu noble-updates/universe amd64 postgresql-server-dev-16 amd64 16.8-0ubuntu0.24.04.1 [1227 kB] 744s Get:70 http://ftpmaster.internal/ubuntu noble-proposed/main amd64 tzdata-legacy all 2025b-0ubuntu0.24.04.1 [94.8 kB] 744s Preconfiguring packages ... 744s Fetched 222 MB in 9s (25.1 MB/s) 744s Selecting previously unselected package libjson-perl. 745s (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 ... 106231 files and directories currently installed.) 745s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 745s Unpacking libjson-perl (4.10000-1) ... 745s Selecting previously unselected package postgresql-client-common. 745s Preparing to unpack .../01-postgresql-client-common_257build1.1_all.deb ... 745s Unpacking postgresql-client-common (257build1.1) ... 745s Selecting previously unselected package ssl-cert. 745s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 745s Unpacking ssl-cert (1.1.2ubuntu1) ... 745s Selecting previously unselected package postgresql-common. 745s Preparing to unpack .../03-postgresql-common_257build1.1_all.deb ... 745s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 745s Unpacking postgresql-common (257build1.1) ... 745s Selecting previously unselected package gcc-13-base:amd64. 745s Preparing to unpack .../04-gcc-13-base_13.3.0-6ubuntu2~24.04_amd64.deb ... 745s Unpacking gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 745s Selecting previously unselected package libisl23:amd64. 745s Preparing to unpack .../05-libisl23_0.26-3build1.1_amd64.deb ... 745s Unpacking libisl23:amd64 (0.26-3build1.1) ... 745s Selecting previously unselected package libmpc3:amd64. 745s Preparing to unpack .../06-libmpc3_1.3.1-1build1.1_amd64.deb ... 745s Unpacking libmpc3:amd64 (1.3.1-1build1.1) ... 745s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 745s Preparing to unpack .../07-cpp-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 745s Unpacking cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 745s Selecting previously unselected package cpp-13. 745s Preparing to unpack .../08-cpp-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 745s Unpacking cpp-13 (13.3.0-6ubuntu2~24.04) ... 745s Selecting previously unselected package cpp-x86-64-linux-gnu. 745s Preparing to unpack .../09-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 745s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 745s Selecting previously unselected package cpp. 745s Preparing to unpack .../10-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 745s Unpacking cpp (4:13.2.0-7ubuntu1) ... 745s Selecting previously unselected package libcc1-0:amd64. 745s Preparing to unpack .../11-libcc1-0_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libgomp1:amd64. 745s Preparing to unpack .../12-libgomp1_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libitm1:amd64. 745s Preparing to unpack .../13-libitm1_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libatomic1:amd64. 745s Preparing to unpack .../14-libatomic1_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libasan8:amd64. 745s Preparing to unpack .../15-libasan8_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package liblsan0:amd64. 745s Preparing to unpack .../16-liblsan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libtsan2:amd64. 745s Preparing to unpack .../17-libtsan2_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libubsan1:amd64. 745s Preparing to unpack .../18-libubsan1_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libhwasan0:amd64. 745s Preparing to unpack .../19-libhwasan0_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libquadmath0:amd64. 745s Preparing to unpack .../20-libquadmath0_14.2.0-4ubuntu2~24.04_amd64.deb ... 745s Unpacking libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 745s Selecting previously unselected package libgcc-13-dev:amd64. 745s Preparing to unpack .../21-libgcc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 745s Unpacking libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 746s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 746s Preparing to unpack .../22-gcc-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 746s Unpacking gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 746s Selecting previously unselected package gcc-13. 746s Preparing to unpack .../23-gcc-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 746s Unpacking gcc-13 (13.3.0-6ubuntu2~24.04) ... 746s Selecting previously unselected package gcc-x86-64-linux-gnu. 746s Preparing to unpack .../24-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 746s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 746s Selecting previously unselected package gcc. 746s Preparing to unpack .../25-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 746s Unpacking gcc (4:13.2.0-7ubuntu1) ... 746s Selecting previously unselected package libstdc++-13-dev:amd64. 746s Preparing to unpack .../26-libstdc++-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 746s Unpacking libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 746s Selecting previously unselected package g++-13-x86-64-linux-gnu. 746s Preparing to unpack .../27-g++-13-x86-64-linux-gnu_13.3.0-6ubuntu2~24.04_amd64.deb ... 746s Unpacking g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 746s Selecting previously unselected package g++-13. 746s Preparing to unpack .../28-g++-13_13.3.0-6ubuntu2~24.04_amd64.deb ... 746s Unpacking g++-13 (13.3.0-6ubuntu2~24.04) ... 747s Selecting previously unselected package g++-x86-64-linux-gnu. 747s Preparing to unpack .../29-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 747s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 747s Selecting previously unselected package g++. 747s Preparing to unpack .../30-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 747s Unpacking g++ (4:13.2.0-7ubuntu1) ... 747s Selecting previously unselected package build-essential. 747s Preparing to unpack .../31-build-essential_12.10ubuntu1_amd64.deb ... 747s Unpacking build-essential (12.10ubuntu1) ... 747s Selecting previously unselected package libllvm17t64:amd64. 747s Preparing to unpack .../32-libllvm17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 747s Unpacking libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 747s Selecting previously unselected package libclang-cpp17t64. 747s Preparing to unpack .../33-libclang-cpp17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 747s Unpacking libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 747s Selecting previously unselected package libgc1:amd64. 747s Preparing to unpack .../34-libgc1_1%3a8.2.6-1build1_amd64.deb ... 747s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 747s Selecting previously unselected package libobjc4:amd64. 747s Preparing to unpack .../35-libobjc4_14.2.0-4ubuntu2~24.04_amd64.deb ... 747s Unpacking libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 748s Selecting previously unselected package libobjc-13-dev:amd64. 748s Preparing to unpack .../36-libobjc-13-dev_13.3.0-6ubuntu2~24.04_amd64.deb ... 748s Unpacking libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 748s Selecting previously unselected package libclang-common-17-dev:amd64. 748s Preparing to unpack .../37-libclang-common-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 748s Unpacking libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 748s Selecting previously unselected package llvm-17-linker-tools. 748s Preparing to unpack .../38-llvm-17-linker-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 748s Unpacking llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 748s Selecting previously unselected package libclang1-17t64. 748s Preparing to unpack .../39-libclang1-17t64_1%3a17.0.6-9ubuntu1_amd64.deb ... 748s Unpacking libclang1-17t64 (1:17.0.6-9ubuntu1) ... 748s Selecting previously unselected package clang-17. 748s Preparing to unpack .../40-clang-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 748s Unpacking clang-17 (1:17.0.6-9ubuntu1) ... 748s Selecting previously unselected package icu-devtools. 748s Preparing to unpack .../41-icu-devtools_74.2-1ubuntu3.1_amd64.deb ... 748s Unpacking icu-devtools (74.2-1ubuntu3.1) ... 748s Selecting previously unselected package libpgtypes3:amd64. 748s Preparing to unpack .../42-libpgtypes3_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libpgtypes3:amd64 (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libpq5:amd64. 748s Preparing to unpack .../43-libpq5_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libpq5:amd64 (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libecpg6:amd64. 748s Preparing to unpack .../44-libecpg6_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libecpg6:amd64 (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libecpg-compat3:amd64. 748s Preparing to unpack .../45-libecpg-compat3_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libecpg-compat3:amd64 (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libssl-dev:amd64. 748s Preparing to unpack .../46-libssl-dev_3.0.13-0ubuntu3.5_amd64.deb ... 748s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu3.5) ... 748s Selecting previously unselected package libpq-dev. 748s Preparing to unpack .../47-libpq-dev_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libpq-dev (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libecpg-dev. 748s Preparing to unpack .../48-libecpg-dev_16.8-0ubuntu0.24.04.1_amd64.deb ... 748s Unpacking libecpg-dev (16.8-0ubuntu0.24.04.1) ... 748s Selecting previously unselected package libicu-dev:amd64. 748s Preparing to unpack .../49-libicu-dev_74.2-1ubuntu3.1_amd64.deb ... 748s Unpacking libicu-dev:amd64 (74.2-1ubuntu3.1) ... 748s Selecting previously unselected package libncurses-dev:amd64. 748s Preparing to unpack .../50-libncurses-dev_6.4+20240113-1ubuntu2_amd64.deb ... 748s Unpacking libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 748s Selecting previously unselected package libtcl8.6:amd64. 748s Preparing to unpack .../51-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 748s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 749s Selecting previously unselected package libxml2-dev:amd64. 749s Preparing to unpack .../52-libxml2-dev_2.9.14+dfsg-1.3ubuntu3.2_amd64.deb ... 749s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.2) ... 749s Selecting previously unselected package libxslt1.1:amd64. 749s Preparing to unpack .../53-libxslt1.1_1.1.39-0exp1ubuntu0.24.04.2_amd64.deb ... 749s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 749s Selecting previously unselected package llvm-17-runtime. 749s Preparing to unpack .../54-llvm-17-runtime_1%3a17.0.6-9ubuntu1_amd64.deb ... 749s Unpacking llvm-17-runtime (1:17.0.6-9ubuntu1) ... 749s Selecting previously unselected package libpfm4:amd64. 749s Preparing to unpack .../55-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 749s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 749s Selecting previously unselected package llvm-17. 749s Preparing to unpack .../56-llvm-17_1%3a17.0.6-9ubuntu1_amd64.deb ... 749s Unpacking llvm-17 (1:17.0.6-9ubuntu1) ... 749s Selecting previously unselected package libffi-dev:amd64. 749s Preparing to unpack .../57-libffi-dev_3.4.6-1build1_amd64.deb ... 749s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 749s Selecting previously unselected package llvm-17-tools. 749s Preparing to unpack .../58-llvm-17-tools_1%3a17.0.6-9ubuntu1_amd64.deb ... 749s Unpacking llvm-17-tools (1:17.0.6-9ubuntu1) ... 749s Selecting previously unselected package libz3-4:amd64. 749s Preparing to unpack .../59-libz3-4_4.8.12-3.1build1_amd64.deb ... 749s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 749s Selecting previously unselected package libz3-dev:amd64. 749s Preparing to unpack .../60-libz3-dev_4.8.12-3.1build1_amd64.deb ... 749s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 750s Selecting previously unselected package llvm-17-dev. 750s Preparing to unpack .../61-llvm-17-dev_1%3a17.0.6-9ubuntu1_amd64.deb ... 750s Unpacking llvm-17-dev (1:17.0.6-9ubuntu1) ... 751s Selecting previously unselected package postgresql-client-16. 751s Preparing to unpack .../62-postgresql-client-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 751s Unpacking postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 751s Selecting previously unselected package postgresql-16. 751s Preparing to unpack .../63-postgresql-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 751s Unpacking postgresql-16 (16.8-0ubuntu0.24.04.1) ... 751s Selecting previously unselected package postgresql-doc-16. 751s Preparing to unpack .../64-postgresql-doc-16_16.8-0ubuntu0.24.04.1_all.deb ... 751s Unpacking postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 752s Selecting previously unselected package postgresql-plperl-16. 752s Preparing to unpack .../65-postgresql-plperl-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 752s Unpacking postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 752s Selecting previously unselected package postgresql-plpython3-16. 752s Preparing to unpack .../66-postgresql-plpython3-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 752s Unpacking postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 752s Selecting previously unselected package postgresql-pltcl-16. 752s Preparing to unpack .../67-postgresql-pltcl-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 752s Unpacking postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 752s Selecting previously unselected package postgresql-server-dev-16. 752s Preparing to unpack .../68-postgresql-server-dev-16_16.8-0ubuntu0.24.04.1_amd64.deb ... 752s Unpacking postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 752s Selecting previously unselected package tzdata-legacy. 752s Preparing to unpack .../69-tzdata-legacy_2025b-0ubuntu0.24.04.1_all.deb ... 752s Unpacking tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 752s Setting up postgresql-client-common (257build1.1) ... 752s Setting up libpgtypes3:amd64 (16.8-0ubuntu0.24.04.1) ... 752s Setting up libncurses-dev:amd64 (6.4+20240113-1ubuntu2) ... 752s Setting up postgresql-doc-16 (16.8-0ubuntu0.24.04.1) ... 752s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 752s Setting up libpq5:amd64 (16.8-0ubuntu0.24.04.1) ... 752s Setting up libgomp1:amd64 (14.2.0-4ubuntu2~24.04) ... 752s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 752s Setting up tzdata-legacy (2025b-0ubuntu0.24.04.1) ... 752s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 752s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 752s Setting up gcc-13-base:amd64 (13.3.0-6ubuntu2~24.04) ... 752s Setting up libllvm17t64:amd64 (1:17.0.6-9ubuntu1) ... 752s Setting up libclang1-17t64 (1:17.0.6-9ubuntu1) ... 752s Setting up ssl-cert (1.1.2ubuntu1) ... 753s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 753s Setting up libquadmath0:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libssl-dev:amd64 (3.0.13-0ubuntu3.5) ... 753s Setting up libmpc3:amd64 (1.3.1-1build1.1) ... 753s Setting up libatomic1:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 753s Setting up icu-devtools (74.2-1ubuntu3.1) ... 753s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 753s Setting up libubsan1:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up llvm-17-tools (1:17.0.6-9ubuntu1) ... 753s Setting up libclang-common-17-dev:amd64 (1:17.0.6-9ubuntu1) ... 753s Setting up libhwasan0:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libasan8:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libjson-perl (4.10000-1) ... 753s Setting up llvm-17-runtime (1:17.0.6-9ubuntu1) ... 753s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu0.24.04.2) ... 753s Setting up libecpg6:amd64 (16.8-0ubuntu0.24.04.1) ... 753s Setting up libtsan2:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libisl23:amd64 (0.26-3build1.1) ... 753s Setting up libicu-dev:amd64 (74.2-1ubuntu3.1) ... 753s Setting up libcc1-0:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up liblsan0:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libitm1:amd64 (14.2.0-4ubuntu2~24.04) ... 753s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 753s Setting up llvm-17-linker-tools (1:17.0.6-9ubuntu1) ... 753s Setting up libecpg-compat3:amd64 (16.8-0ubuntu0.24.04.1) ... 753s Setting up cpp-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 753s Setting up postgresql-client-16 (16.8-0ubuntu0.24.04.1) ... 754s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 754s Setting up libpq-dev (16.8-0ubuntu0.24.04.1) ... 754s Setting up libobjc4:amd64 (14.2.0-4ubuntu2~24.04) ... 754s Setting up libecpg-dev (16.8-0ubuntu0.24.04.1) ... 754s Setting up libclang-cpp17t64 (1:17.0.6-9ubuntu1) ... 754s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3.2) ... 754s Setting up postgresql-common (257build1.1) ... 754s 754s Creating config file /etc/postgresql-common/createcluster.conf with new version 754s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 754s Removing obsolete dictionary files: 755s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 755s Setting up libgcc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 755s Setting up llvm-17 (1:17.0.6-9ubuntu1) ... 755s Setting up libobjc-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 755s Setting up libstdc++-13-dev:amd64 (13.3.0-6ubuntu2~24.04) ... 755s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 755s Setting up postgresql-16 (16.8-0ubuntu0.24.04.1) ... 755s Creating new PostgreSQL cluster 16/main ... 755s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 756s The files belonging to this database system will be owned by user "postgres". 756s This user must also own the server process. 756s 756s The database cluster will be initialized with locale "C.UTF-8". 756s The default database encoding has accordingly been set to "UTF8". 756s The default text search configuration will be set to "english". 756s 756s Data page checksums are disabled. 756s 756s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 756s creating subdirectories ... ok 756s selecting dynamic shared memory implementation ... posix 756s selecting default max_connections ... 100 756s selecting default shared_buffers ... 128MB 756s selecting default time zone ... Etc/UTC 756s creating configuration files ... ok 756s running bootstrap script ... ok 756s performing post-bootstrap initialization ... ok 756s syncing data to disk ... ok 760s Setting up cpp-13 (13.3.0-6ubuntu2~24.04) ... 760s Setting up gcc-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 760s Setting up clang-17 (1:17.0.6-9ubuntu1) ... 760s Setting up gcc-13 (13.3.0-6ubuntu2~24.04) ... 760s Setting up postgresql-plpython3-16 (16.8-0ubuntu0.24.04.1) ... 760s Setting up cpp (4:13.2.0-7ubuntu1) ... 760s Setting up postgresql-plperl-16 (16.8-0ubuntu0.24.04.1) ... 760s Setting up llvm-17-dev (1:17.0.6-9ubuntu1) ... 760s Setting up postgresql-pltcl-16 (16.8-0ubuntu0.24.04.1) ... 760s Setting up g++-13-x86-64-linux-gnu (13.3.0-6ubuntu2~24.04) ... 760s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 760s Setting up gcc (4:13.2.0-7ubuntu1) ... 760s Setting up postgresql-server-dev-16 (16.8-0ubuntu0.24.04.1) ... 760s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 760s Setting up g++-13 (13.3.0-6ubuntu2~24.04) ... 760s Setting up g++ (4:13.2.0-7ubuntu1) ... 760s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 760s Setting up build-essential (12.10ubuntu1) ... 760s Processing triggers for libc-bin (2.39-0ubuntu8.4) ... 760s Processing triggers for systemd (255.4-1ubuntu8.6) ... 760s Processing triggers for man-db (2.12.0-4build2) ... 761s Processing triggers for install-info (7.1-3build2) ... 804s autopkgtest [12:40:37]: test installcheck: [----------------------- 804s + dpkg-parsechangelog -SSource 805s + SOURCE=postgresql-16 805s + MAJOR=16 805s + top_srcdir=/tmp/autopkgtest.UBXPJJ/build.eaY/src 805s + cd src/test/regress 805s + make -f /tmp/autopkgtest.UBXPJJ/build.eaY/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/16/bin/pg_config with_llvm=no 805s 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 -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.UBXPJJ/build.eaY/src/debian/tests/ -I/usr/include/postgresql/16/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 805s 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 -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 -L/usr/lib/llvm-17/lib -Wl,--as-needed -fvisibility=hidden 806s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.UBXPJJ/build.eaY/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/stats.sql sql/stats_ext.sql sql/strings.sql sql/subscription.sql sql/subselect.sql sql/sysviews.sql sql/tablesample.sql sql/tablespace.sql sql/temp.sql sql/test_setup.sql sql/text.sql sql/tid.sql sql/tidrangescan.sql sql/tidscan.sql sql/time.sql sql/timestamp.sql sql/timestamptz.sql sql/timetz.sql sql/transactions.sql sql/triggers.sql sql/truncate.sql sql/tsdicts.sql sql/tsearch.sql sql/tsrf.sql sql/tstypes.sql sql/tuplesort.sql sql/txid.sql sql/type_sanity.sql sql/typed_table.sql sql/unicode.sql sql/union.sql sql/updatable_views.sql sql/update.sql sql/uuid.sql sql/vacuum.sql sql/vacuum_parallel.sql sql/varchar.sql sql/window.sql sql/with.sql sql/write_parallel.sql sql/xid.sql sql/xml.sql sql/xmlmap.sql expected/advisory_lock.out expected/aggregates.out expected/alter_generic.out expected/alter_operator.out expected/alter_table.out expected/amutils.out expected/arrays.out expected/async.out expected/bit.out expected/bitmapops.out expected/boolean.out expected/box.out expected/brin.out expected/brin_bloom.out expected/brin_multi.out expected/btree_index.out expected/case.out expected/char.out expected/char_1.out expected/char_2.out expected/circle.out expected/cluster.out expected/collate.icu.utf8.out expected/collate.icu.utf8_1.out expected/collate.linux.utf8.out expected/collate.linux.utf8_1.out expected/collate.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/matview.out expected/md5.out expected/memoize.out expected/merge.out expected/misc.out expected/misc_functions.out expected/misc_sanity.out expected/money.out expected/multirangetypes.out expected/mvcc.out expected/name.out expected/namespace.out expected/numeric.out expected/numeric_big.out expected/numerology.out expected/object_address.out expected/oid.out expected/oidjoins.out expected/opr_sanity.out expected/partition_aggregate.out expected/partition_info.out expected/partition_join.out expected/partition_prune.out expected/password.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/stats.out expected/stats_ext.out expected/strings.out expected/subscription.out expected/subselect.out expected/sysviews.out expected/tablesample.out expected/tablespace.out expected/temp.out expected/test_setup.out expected/text.out expected/tid.out expected/tidrangescan.out expected/tidscan.out expected/time.out expected/timestamp.out expected/timestamptz.out expected/timetz.out expected/transactions.out expected/triggers.out expected/truncate.out expected/tsdicts.out expected/tsearch.out expected/tsrf.out expected/tstypes.out expected/tuplesort.out expected/txid.out expected/type_sanity.out expected/typed_table.out expected/unicode.out expected/unicode_1.out expected/union.out expected/updatable_views.out expected/update.out expected/uuid.out expected/vacuum.out expected/vacuum_parallel.out expected/varchar.out expected/varchar_1.out expected/varchar_2.out expected/window.out expected/with.out expected/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 806s + id -u 806s + [ 1000 = 0 ] 806s + SU=sh 806s + sh 806s + mktemp -d /tmp/regress.XXXXXX 806s + OUTPUT=/tmp/regress.RHRaD0 806s + trap rm -rf /tmp/regress.RHRaD0 EXIT 806s + pg_virtualenv -v 16 /usr/lib/postgresql/16/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.RHRaD0 --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 806s Creating new PostgreSQL cluster 16/regress ... 808s # using postmaster on localhost, port 5433 809s ok 1 - test_setup 160 ms 809s # parallel group (20 tests): char text int2 int4 varchar oid name pg_lsn txid uuid float4 float8 money int8 regproc enum boolean bit numeric rangetypes 809s ok 2 + boolean 536 ms 809s ok 3 + char 144 ms 809s ok 4 + name 258 ms 809s ok 5 + varchar 240 ms 809s ok 6 + text 168 ms 810s ok 7 + int2 198 ms 810s ok 8 + int4 210 ms 810s ok 9 + int8 335 ms 810s ok 10 + oid 251 ms 810s ok 11 + float4 312 ms 810s ok 12 + float8 316 ms 810s ok 13 + bit 533 ms 810s ok 14 + numeric 601 ms 810s ok 15 + txid 250 ms 810s ok 16 + uuid 292 ms 810s ok 17 + enum 327 ms 810s ok 18 + money 303 ms 810s ok 19 + rangetypes 743 ms 810s ok 20 + pg_lsn 244 ms 810s ok 21 + regproc 325 ms 811s # parallel group (20 tests): lseg line md5 macaddr macaddr8 circle path timetz time numerology inet date interval strings timestamp point timestamptz polygon multirangetypes box 811s ok 22 + strings 484 ms 811s ok 23 + md5 171 ms 811s ok 24 + numerology 254 ms 811s ok 25 + point 572 ms 811s ok 26 + lseg 136 ms 811s ok 27 + line 150 ms 811s ok 28 + box 1103 ms 811s ok 29 + path 204 ms 811s ok 30 + polygon 825 ms 811s ok 31 + circle 185 ms 811s ok 32 + date 344 ms 811s ok 33 + time 237 ms 811s ok 34 + timetz 207 ms 811s ok 35 + timestamp 555 ms 811s ok 36 + timestamptz 609 ms 811s ok 37 + interval 405 ms 811s ok 38 + inet 300 ms 811s ok 39 + macaddr 165 ms 811s ok 40 + macaddr8 170 ms 811s ok 41 + multirangetypes 940 ms 811s # parallel group (13 tests): comments unicode misc_sanity mvcc xid tstypes expressions type_sanity geometry opr_sanity database horology regex 811s ok 42 + geometry 368 ms 811s ok 43 + horology 663 ms 811s ok 44 + tstypes 265 ms 811s ok 45 + regex 689 ms 811s ok 46 + type_sanity 323 ms 811s ok 47 + opr_sanity 523 ms 811s ok 48 + misc_sanity 152 ms 811s ok 49 + comments 97 ms 811s ok 50 + expressions 263 ms 811s ok 51 + unicode 142 ms 811s ok 52 + xid 233 ms 811s ok 53 + mvcc 198 ms 811s ok 54 + database 607 ms 812s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 812s ok 55 + copy 127 ms 812s ok 56 + copyselect 70 ms 812s ok 57 + copydml 78 ms 812s ok 58 + insert 291 ms 812s ok 59 + insert_conflict 147 ms 812s # parallel group (7 tests): create_operator create_function_c create_procedure create_schema create_misc create_type create_table 812s ok 60 + create_function_c 73 ms 812s ok 61 + create_misc 130 ms 812s ok 62 + create_operator 70 ms 812s ok 63 + create_procedure 109 ms 812s ok 64 + create_table 338 ms 812s ok 65 + create_type 129 ms 812s ok 66 + create_schema 114 ms 813s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 813s ok 67 + create_index 917 ms 813s ok 68 + create_index_spgist 838 ms 813s ok 69 + create_view 381 ms 813s ok 70 + index_including 223 ms 813s ok 71 + index_including_gist 283 ms 814s # parallel group (16 tests): create_cast hash_func errors roleattributes create_aggregate typed_table drop_if_exists create_function_sql create_am constraints infinite_recurse select vacuum updatable_views inherit triggers 814s ok 72 + create_aggregate 260 ms 814s ok 73 + create_function_sql 399 ms 814s ok 74 + create_cast 161 ms 814s ok 75 + constraints 548 ms 814s ok 76 + triggers 1214 ms 814s ok 77 + select 664 ms 814s ok 78 + inherit 1041 ms 814s ok 79 + typed_table 278 ms 814s ok 80 + vacuum 776 ms 814s ok 81 + drop_if_exists 333 ms 814s ok 82 + updatable_views 981 ms 814s ok 83 + roleattributes 226 ms 814s ok 84 + create_am 496 ms 814s ok 85 + hash_func 167 ms 814s ok 86 + errors 207 ms 814s ok 87 + infinite_recurse 645 ms 814s ok 88 - sanity_check 76 ms 816s # parallel group (20 tests): case namespace select_implicit select_distinct_on select_having random delete prepared_xacts select_into transactions union portals select_distinct subselect arrays hash_index update aggregates btree_index join 816s ok 89 + select_into 333 ms 816s ok 90 + select_distinct 677 ms 816s ok 91 + select_distinct_on 205 ms 816s ok 92 + select_implicit 201 ms 816s ok 93 + select_having 210 ms 816s ok 94 + subselect 729 ms 816s ok 95 + union 610 ms 816s ok 96 + case 193 ms 816s ok 97 + join 1839 ms 816s ok 98 + aggregates 1637 ms 816s ok 99 + transactions 458 ms 816s ok 100 + random 213 ms 816s ok 101 + portals 619 ms 816s ok 102 + arrays 877 ms 816s ok 103 + btree_index 1660 ms 816s ok 104 + hash_index 965 ms 816s ok 105 + update 1218 ms 816s ok 106 + delete 243 ms 816s ok 107 + namespace 179 ms 816s ok 108 + prepared_xacts 296 ms 822s # parallel group (20 tests): init_privs drop_operator security_label lock tablesample object_address password replica_identity matview identity spgist generated collate rowsecurity gist groupingsets gin brin join_hash privileges 822s ok 109 + brin 5110 ms 822s ok 110 + gin 2061 ms 822s ok 111 + gist 1790 ms 822s ok 112 + spgist 1418 ms 822s ok 113 + privileges 5402 ms 822s ok 114 + init_privs 117 ms 822s ok 115 + security_label 317 ms 822s ok 116 + collate 1448 ms 822s ok 117 + matview 1198 ms 822s ok 118 + lock 450 ms 822s ok 119 + replica_identity 689 ms 822s ok 120 + rowsecurity 1781 ms 822s ok 121 + object_address 496 ms 822s ok 122 + tablesample 458 ms 822s ok 123 + groupingsets 2026 ms 822s ok 124 + drop_operator 204 ms 822s ok 125 + password 619 ms 822s ok 126 + identity 1192 ms 822s ok 127 + generated 1418 ms 822s ok 128 + join_hash 5102 ms 822s # parallel group (2 tests): brin_bloom brin_multi 822s ok 129 + brin_bloom 57 ms 822s ok 130 + brin_multi 121 ms 823s # parallel group (16 tests): dbsize alter_operator async tsrf tid tidscan create_role sysviews alter_generic misc_functions tidrangescan create_table_like merge incremental_sort collate.icu.utf8 misc 823s ok 131 + create_table_like 617 ms 823s ok 132 + alter_generic 366 ms 823s ok 133 + alter_operator 118 ms 823s ok 134 + misc 877 ms 823s ok 135 + async 121 ms 823s ok 136 + dbsize 104 ms 823s ok 137 + merge 626 ms 823s ok 138 + misc_functions 370 ms 823s ok 139 + sysviews 348 ms 823s ok 140 + tsrf 175 ms 823s ok 141 + tid 205 ms 823s ok 142 + tidscan 201 ms 823s ok 143 + tidrangescan 492 ms 823s ok 144 + collate.icu.utf8 851 ms 823s ok 145 + incremental_sort 635 ms 823s ok 146 + create_role 297 ms 823s # parallel group (7 tests): collate.linux.utf8 collate.windows.win1252 amutils psql_crosstab psql rules stats_ext 823s ok 147 + rules 376 ms 823s ok 148 + psql 347 ms 823s ok 149 + psql_crosstab 85 ms 823s ok 150 + amutils 65 ms 823s ok 151 + stats_ext 845 ms 823s ok 152 + collate.linux.utf8 51 ms 823s ok 153 + collate.windows.win1252 63 ms 826s ok 154 - select_parallel 2379 ms 826s ok 155 - write_parallel 104 ms 826s ok 156 - vacuum_parallel 83 ms 828s # parallel group (2 tests): subscription publication 828s ok 157 + publication 1450 ms 828s ok 158 + subscription 106 ms 829s # parallel group (17 tests): portals_p2 combocid xmlmap advisory_lock functional_deps guc dependency equivclass tsdicts select_views bitmapops window cluster indirect_toast foreign_data foreign_key tsearch 829s ok 159 + select_views 417 ms 829s ok 160 + portals_p2 208 ms 829s ok 161 + foreign_key 1159 ms 829s ok 162 + cluster 756 ms 829s ok 163 + dependency 308 ms 829s ok 164 + guc 305 ms 829s ok 165 + bitmapops 705 ms 829s ok 166 + combocid 211 ms 829s ok 167 + tsearch 1609 ms 829s ok 168 + tsdicts 314 ms 829s ok 169 + foreign_data 1019 ms 829s ok 170 + window 726 ms 829s ok 171 + xmlmap 216 ms 829s ok 172 + functional_deps 276 ms 829s ok 173 + advisory_lock 229 ms 829s ok 174 + indirect_toast 812 ms 829s ok 175 + equivclass 305 ms 829s # parallel group (7 tests): jsonpath_encoding json_encoding jsonpath sqljson jsonb_jsonpath json jsonb 829s ok 176 + json 159 ms 829s ok 177 + jsonb 255 ms 829s ok 178 + json_encoding 72 ms 829s ok 179 + jsonpath 98 ms 829s ok 180 + jsonpath_encoding 52 ms 829s ok 181 + jsonb_jsonpath 153 ms 829s ok 182 + sqljson 113 ms 831s # parallel group (18 tests): prepare limit returning plancache conversion with copy2 temp rowtypes polymorphism sequence largeobject truncate domain xml rangefuncs plpgsql alter_table 831s ok 183 + plancache 372 ms 831s ok 184 + limit 307 ms 831s ok 185 + plpgsql 1280 ms 831s ok 186 + copy2 737 ms 831s ok 187 + temp 742 ms 831s ok 188 + domain 985 ms 831s ok 189 + rangefuncs 1206 ms 831s ok 190 + prepare 237 ms 831s ok 191 + conversion 411 ms 831s ok 192 + truncate 948 ms 831s ok 193 + alter_table 1772 ms 831s ok 194 + sequence 866 ms 831s ok 195 + polymorphism 837 ms 831s ok 196 + rowtypes 806 ms 831s ok 197 + returning 313 ms 831s ok 198 + largeobject 892 ms 831s ok 199 + with 684 ms 831s ok 200 + xml 1106 ms 833s # parallel group (12 tests): hash_part partition_info explain reloptions compression memoize partition_aggregate tuplesort partition_join indexing stats partition_prune 833s ok 201 + partition_join 1559 ms 833s ok 202 + partition_prune 1846 ms 833s ok 203 + reloptions 249 ms 833s ok 204 + hash_part 175 ms 833s ok 205 + indexing 1576 ms 833s ok 206 + partition_aggregate 1447 ms 833s ok 207 + partition_info 242 ms 833s ok 208 + tuplesort 1558 ms 833s ok 209 + explain 248 ms 833s ok 210 + compression 431 ms 833s ok 211 + memoize 1001 ms 833s ok 212 + stats 1708 ms 833s # parallel group (2 tests): event_trigger oidjoins 833s ok 213 + event_trigger 81 ms 833s ok 214 + oidjoins 136 ms 833s ok 215 - fast_default 86 ms 834s ok 216 - tablespace 207 ms 834s 1..216 834s # All 216 tests passed. 834s Dropping cluster 16/regress ... 834s + rm -rf /tmp/regress.RHRaD0 834s autopkgtest [12:41:07]: test installcheck: -----------------------] 835s autopkgtest [12:41:08]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 835s installcheck PASS 835s autopkgtest [12:41:08]: @@@@@@@@@@@@@@@@@@@@ summary 835s run-testsuite PASS 835s installcheck PASS 840s nova [W] Skipping flock for amd64 840s Creating nova instance adt-noble-amd64-postgresql-16-20250425-122712-juju-7f2275-prod-proposed-migration-environment-15-79d5c58d-d90e-4ad1-a329-371a71712a78 from image adt/ubuntu-noble-amd64-server-20250425.img (UUID e974e8b5-afe3-4fc7-89d2-42e65080f8e5)... 840s nova [W] Timed out waiting for 8e42c090-d708-434b-90c4-3f97c9308c2f to get deleted. 840s nova [W] Skipping flock for amd64 840s Creating nova instance adt-noble-amd64-postgresql-16-20250425-122712-juju-7f2275-prod-proposed-migration-environment-15-79d5c58d-d90e-4ad1-a329-371a71712a78 from image adt/ubuntu-noble-amd64-server-20250425.img (UUID e974e8b5-afe3-4fc7-89d2-42e65080f8e5)... 840s nova [W] Timed out waiting for 6100556b-119e-450c-b8de-7d6590aaa48a to get deleted.