0s autopkgtest [18:36:27]: starting date and time: 2025-05-06 18:36:27+0000 0s autopkgtest [18:36:27]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [18:36:27]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.hjoaf_13/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025b-1ubuntu1.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-16.secgroup --name adt-plucky-amd64-postgresql-17-20250506-183627-juju-7f2275-prod-proposed-migration-environment-20-8b390674-c941-4e89-b5e3-551388db2c16 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 63s autopkgtest [18:37:30]: testbed dpkg architecture: amd64 63s autopkgtest [18:37:30]: testbed apt version: 3.0.0 63s autopkgtest [18:37:30]: @@@@@@@@@@@@@@@@@@@@ test bed setup 64s autopkgtest [18:37:31]: testbed release detected to be: None 64s autopkgtest [18:37:31]: updating testbed package index (apt update) 65s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 65s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 65s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 65s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 65s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 65s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [5776 B] 65s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [3700 B] 65s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 c-n-f Metadata [288 B] 65s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 c-n-f Metadata [232 B] 65s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [17.3 kB] 65s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [14.8 kB] 65s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 c-n-f Metadata [9496 B] 65s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 c-n-f Metadata [440 B] 67s Fetched 322 kB in 1s (377 kB/s) 67s Reading package lists... 68s autopkgtest [18:37:35]: upgrading testbed (apt dist-upgrade and autopurge) 68s Reading package lists... 68s Building dependency tree... 68s Reading state information... 69s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 69s Starting 2 pkgProblemResolver with broken count: 0 69s Done 69s Entering ResolveByKeep 70s 70s Calculating upgrade... 70s The following packages will be upgraded: 70s tzdata 70s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 70s Need to get 198 kB of archives. 70s After this operation, 0 B of additional disk space will be used. 70s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 tzdata all 2025b-1ubuntu1.1 [198 kB] 71s Preconfiguring packages ... 71s Fetched 198 kB in 0s (497 kB/s) 71s (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 ... 80514 files and directories currently installed.) 71s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 71s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 71s Setting up tzdata (2025b-1ubuntu1.1) ... 71s 71s Current default time zone: 'Etc/UTC' 71s Local time is now: Tue May 6 18:37:38 UTC 2025. 71s Universal Time is now: Tue May 6 18:37:38 UTC 2025. 71s Run 'dpkg-reconfigure tzdata' if you wish to change it. 71s 72s Reading package lists... 72s Building dependency tree... 72s Reading state information... 72s Starting pkgProblemResolver with broken count: 0 72s Starting 2 pkgProblemResolver with broken count: 0 72s Done 72s Solving dependencies... 73s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 75s autopkgtest [18:37:42]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 75s autopkgtest [18:37:42]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 87s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (dsc) [4245 B] 87s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (tar) [21.5 MB] 87s Get:3 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (diff) [27.2 kB] 87s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 87s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 87s gpgv: Can't check signature: No public key 87s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 92s autopkgtest [18:37:59]: testing package postgresql-17 version 17.4-1 94s autopkgtest [18:38:01]: build not needed 101s autopkgtest [18:38:08]: test run-testsuite: preparing testbed 101s Reading package lists... 101s Building dependency tree... 101s Reading state information... 102s Starting pkgProblemResolver with broken count: 0 102s Starting 2 pkgProblemResolver with broken count: 0 102s Done 102s The following NEW packages will be installed: 102s autoconf automake autopoint autotools-dev binutils-gold 102s binutils-gold-x86-64-linux-gnu build-essential clang-20 cpp cpp-14 102s cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 102s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 102s fakeroot g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 102s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 102s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-20-dev 102s libclang-cpp20 libclang1-20 libdebhelper-perl libecpg-compat3 libecpg-dev 102s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 102s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 102s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 102s libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libquadmath0 102s libssl-dev libstdc++-14-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev 102s libxslt1.1 llvm-20 llvm-20-dev llvm-20-linker-tools llvm-20-runtime 102s llvm-20-tools locales-all m4 po-debconf postgresql-17 postgresql-client-17 102s postgresql-client-common postgresql-common postgresql-common-dev 102s postgresql-doc-17 postgresql-plperl-17 postgresql-plpython3-17 102s postgresql-pltcl-17 postgresql-server-dev-17 ssl-cert 102s 0 upgraded, 91 newly installed, 0 to remove and 0 not upgraded. 102s Need to get 239 MB of archives. 102s After this operation, 1355 MB of additional disk space will be used. 102s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 102s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 274 [47.6 kB] 102s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 102s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 103s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common-dev all 274 [73.0 kB] 103s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 103s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 274 [101 kB] 103s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 m4 amd64 1.4.19-7 [263 kB] 103s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 autoconf all 2.72-3ubuntu1 [383 kB] 103s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 autotools-dev all 20220109.1 [44.9 kB] 103s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 automake all 1:1.17-3ubuntu1 [572 kB] 103s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 autopoint all 0.23.1-1 [619 kB] 103s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 binutils-gold-x86-64-linux-gnu amd64 2.44-2 [1278 kB] 103s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 binutils-gold amd64 2.44-2 [2208 B] 103s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 libisl23 amd64 0.27-1 [685 kB] 103s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 103s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [11.9 MB] 104s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14 amd64 14.2.0-19ubuntu2 [1030 B] 104s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [5586 B] 104s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp amd64 4:14.2.0-1ubuntu1 [22.4 kB] 104s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 libcc1-0 amd64 15-20250404-0ubuntu1 [47.1 kB] 104s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 libgomp1 amd64 15-20250404-0ubuntu1 [151 kB] 104s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 libitm1 amd64 15-20250404-0ubuntu1 [29.5 kB] 104s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 libasan8 amd64 15-20250404-0ubuntu1 [3076 kB] 104s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 liblsan0 amd64 15-20250404-0ubuntu1 [1362 kB] 104s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 libtsan2 amd64 15-20250404-0ubuntu1 [2760 kB] 104s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 libubsan1 amd64 15-20250404-0ubuntu1 [1211 kB] 104s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 libhwasan0 amd64 15-20250404-0ubuntu1 [1687 kB] 104s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 libquadmath0 amd64 15-20250404-0ubuntu1 [153 kB] 104s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 libgcc-14-dev amd64 14.2.0-19ubuntu2 [2815 kB] 104s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [23.3 MB] 105s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14 amd64 14.2.0-19ubuntu2 [540 kB] 105s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [1208 B] 105s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc amd64 4:14.2.0-1ubuntu1 [5004 B] 105s Get:35 http://ftpmaster.internal/ubuntu plucky/main amd64 libstdc++-14-dev amd64 14.2.0-19ubuntu2 [2510 kB] 105s Get:36 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [13.4 MB] 106s Get:37 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14 amd64 14.2.0-19ubuntu2 [23.0 kB] 106s Get:38 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [968 B] 106s Get:39 http://ftpmaster.internal/ubuntu plucky/main amd64 g++ amd64 4:14.2.0-1ubuntu1 [1100 B] 106s Get:40 http://ftpmaster.internal/ubuntu plucky/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 106s Get:41 http://ftpmaster.internal/ubuntu plucky/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 107s Get:42 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-cpp20 amd64 1:20.1.2-0ubuntu1 [14.2 MB] 108s Get:43 http://ftpmaster.internal/ubuntu plucky/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 108s Get:44 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc4 amd64 15-20250404-0ubuntu1 [47.8 kB] 108s Get:45 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc-14-dev amd64 14.2.0-19ubuntu2 [195 kB] 108s Get:46 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-common-20-dev amd64 1:20.1.2-0ubuntu1 [782 kB] 108s Get:47 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-linker-tools amd64 1:20.1.2-0ubuntu1 [1337 kB] 108s Get:48 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang1-20 amd64 1:20.1.2-0ubuntu1 [8255 kB] 108s Get:49 http://ftpmaster.internal/ubuntu plucky/universe amd64 clang-20 amd64 1:20.1.2-0ubuntu1 [77.6 kB] 108s Get:50 http://ftpmaster.internal/ubuntu plucky/main amd64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 108s Get:51 http://ftpmaster.internal/ubuntu plucky/main amd64 libtool all 2.5.4-4 [168 kB] 108s Get:52 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-autoreconf all 20 [16.1 kB] 108s Get:53 http://ftpmaster.internal/ubuntu plucky/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 108s Get:54 http://ftpmaster.internal/ubuntu plucky/main amd64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 108s Get:55 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 108s Get:56 http://ftpmaster.internal/ubuntu plucky/main amd64 debugedit amd64 1:5.1-2 [47.0 kB] 108s Get:57 http://ftpmaster.internal/ubuntu plucky/main amd64 dwz amd64 0.15-1build6 [115 kB] 108s Get:58 http://ftpmaster.internal/ubuntu plucky/main amd64 gettext amd64 0.23.1-1 [1086 kB] 109s Get:59 http://ftpmaster.internal/ubuntu plucky/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 109s Get:60 http://ftpmaster.internal/ubuntu plucky/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 109s Get:61 http://ftpmaster.internal/ubuntu plucky/main amd64 debhelper all 13.24.1ubuntu2 [895 kB] 109s Get:62 http://ftpmaster.internal/ubuntu plucky/main amd64 emacsen-common all 3.0.7 [13.0 kB] 109s Get:63 http://ftpmaster.internal/ubuntu plucky/main amd64 dictionaries-common all 1.30.10 [178 kB] 109s Get:64 http://ftpmaster.internal/ubuntu plucky/main amd64 libfakeroot amd64 1.37.1-1 [33.9 kB] 109s Get:65 http://ftpmaster.internal/ubuntu plucky/main amd64 fakeroot amd64 1.37.1-1 [68.1 kB] 109s Get:66 http://ftpmaster.internal/ubuntu plucky/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 109s Get:67 http://ftpmaster.internal/ubuntu plucky/main amd64 libpgtypes3 amd64 17.4-1 [46.3 kB] 109s Get:68 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.4-1 [155 kB] 109s Get:69 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg6 amd64 17.4-1 [51.7 kB] 109s Get:70 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-compat3 amd64 17.4-1 [13.2 kB] 109s Get:71 http://ftpmaster.internal/ubuntu plucky/main amd64 libssl-dev amd64 3.4.1-1ubuntu3 [2872 kB] 109s Get:72 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq-dev amd64 17.4-1 [158 kB] 109s Get:73 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-dev amd64 17.4-1 [277 kB] 109s Get:74 http://ftpmaster.internal/ubuntu plucky/main amd64 libncurses-dev amd64 6.5+20250216-2 [424 kB] 109s Get:75 http://ftpmaster.internal/ubuntu plucky/main amd64 libtcl8.6 amd64 8.6.16+dfsg-1 [1086 kB] 109s Get:76 http://ftpmaster.internal/ubuntu plucky-updates/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [785 kB] 109s Get:77 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 109s Get:78 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-runtime amd64 1:20.1.2-0ubuntu1 [560 kB] 109s Get:79 http://ftpmaster.internal/ubuntu plucky/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 110s Get:80 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20 amd64 1:20.1.2-0ubuntu1 [19.7 MB] 112s Get:81 http://ftpmaster.internal/ubuntu plucky/main amd64 libffi-dev amd64 3.4.7-1 [65.5 kB] 112s Get:82 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-tools amd64 1:20.1.2-0ubuntu1 [513 kB] 112s Get:83 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-dev amd64 1:20.1.2-0ubuntu1 [50.5 MB] 118s Get:84 http://ftpmaster.internal/ubuntu plucky/universe amd64 locales-all amd64 2.41-6ubuntu1 [11.2 MB] 119s Get:85 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 119s Get:86 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 121s Get:87 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-doc-17 all 17.4-1 [2131 kB] 121s Get:88 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plperl-17 amd64 17.4-1 [71.2 kB] 121s Get:89 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plpython3-17 amd64 17.4-1 [78.3 kB] 121s Get:90 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-pltcl-17 amd64 17.4-1 [31.3 kB] 121s Get:91 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-17 amd64 17.4-1 [1417 kB] 122s Preconfiguring packages ... 122s Fetched 239 MB in 19s (12.4 MB/s) 122s Selecting previously unselected package libjson-perl. 122s (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 ... 80514 files and directories currently installed.) 122s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 122s Unpacking libjson-perl (4.10000-1) ... 122s Selecting previously unselected package postgresql-client-common. 122s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 122s Unpacking postgresql-client-common (274) ... 122s Selecting previously unselected package libio-pty-perl. 122s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 122s Unpacking libio-pty-perl (1:1.20-1build3) ... 122s Selecting previously unselected package libipc-run-perl. 122s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 122s Unpacking libipc-run-perl (20231003.0-2) ... 122s Selecting previously unselected package postgresql-common-dev. 122s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 122s Unpacking postgresql-common-dev (274) ... 122s Selecting previously unselected package ssl-cert. 122s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 122s Unpacking ssl-cert (1.1.3ubuntu1) ... 122s Selecting previously unselected package postgresql-common. 122s Preparing to unpack .../06-postgresql-common_274_all.deb ... 122s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 122s Unpacking postgresql-common (274) ... 122s Selecting previously unselected package m4. 122s Preparing to unpack .../07-m4_1.4.19-7_amd64.deb ... 122s Unpacking m4 (1.4.19-7) ... 122s Selecting previously unselected package autoconf. 122s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 122s Unpacking autoconf (2.72-3ubuntu1) ... 122s Selecting previously unselected package autotools-dev. 122s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 122s Unpacking autotools-dev (20220109.1) ... 122s Selecting previously unselected package automake. 122s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 122s Unpacking automake (1:1.17-3ubuntu1) ... 122s Selecting previously unselected package autopoint. 122s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 122s Unpacking autopoint (0.23.1-1) ... 122s Selecting previously unselected package binutils-gold-x86-64-linux-gnu. 122s Preparing to unpack .../12-binutils-gold-x86-64-linux-gnu_2.44-2_amd64.deb ... 122s Unpacking binutils-gold-x86-64-linux-gnu (2.44-2) ... 122s Selecting previously unselected package binutils-gold. 122s Preparing to unpack .../13-binutils-gold_2.44-2_amd64.deb ... 122s Unpacking binutils-gold (2.44-2) ... 122s Selecting previously unselected package libisl23:amd64. 122s Preparing to unpack .../14-libisl23_0.27-1_amd64.deb ... 122s Unpacking libisl23:amd64 (0.27-1) ... 122s Selecting previously unselected package libmpc3:amd64. 122s Preparing to unpack .../15-libmpc3_1.3.1-1build2_amd64.deb ... 122s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 122s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 122s Preparing to unpack .../16-cpp-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 122s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 123s Selecting previously unselected package cpp-14. 123s Preparing to unpack .../17-cpp-14_14.2.0-19ubuntu2_amd64.deb ... 123s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 123s Selecting previously unselected package cpp-x86-64-linux-gnu. 123s Preparing to unpack .../18-cpp-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 123s Unpacking cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 123s Selecting previously unselected package cpp. 123s Preparing to unpack .../19-cpp_4%3a14.2.0-1ubuntu1_amd64.deb ... 123s Unpacking cpp (4:14.2.0-1ubuntu1) ... 123s Selecting previously unselected package libcc1-0:amd64. 123s Preparing to unpack .../20-libcc1-0_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libcc1-0:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libgomp1:amd64. 123s Preparing to unpack .../21-libgomp1_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libgomp1:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libitm1:amd64. 123s Preparing to unpack .../22-libitm1_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libitm1:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libasan8:amd64. 123s Preparing to unpack .../23-libasan8_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libasan8:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package liblsan0:amd64. 123s Preparing to unpack .../24-liblsan0_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking liblsan0:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libtsan2:amd64. 123s Preparing to unpack .../25-libtsan2_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libtsan2:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libubsan1:amd64. 123s Preparing to unpack .../26-libubsan1_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libubsan1:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libhwasan0:amd64. 123s Preparing to unpack .../27-libhwasan0_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libhwasan0:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libquadmath0:amd64. 123s Preparing to unpack .../28-libquadmath0_15-20250404-0ubuntu1_amd64.deb ... 123s Unpacking libquadmath0:amd64 (15-20250404-0ubuntu1) ... 123s Selecting previously unselected package libgcc-14-dev:amd64. 123s Preparing to unpack .../29-libgcc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 123s Unpacking libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 123s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 123s Preparing to unpack .../30-gcc-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 123s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 124s Selecting previously unselected package gcc-14. 124s Preparing to unpack .../31-gcc-14_14.2.0-19ubuntu2_amd64.deb ... 124s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 124s Selecting previously unselected package gcc-x86-64-linux-gnu. 124s Preparing to unpack .../32-gcc-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 124s Unpacking gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 124s Selecting previously unselected package gcc. 124s Preparing to unpack .../33-gcc_4%3a14.2.0-1ubuntu1_amd64.deb ... 124s Unpacking gcc (4:14.2.0-1ubuntu1) ... 124s Selecting previously unselected package libstdc++-14-dev:amd64. 124s Preparing to unpack .../34-libstdc++-14-dev_14.2.0-19ubuntu2_amd64.deb ... 124s Unpacking libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 124s Selecting previously unselected package g++-14-x86-64-linux-gnu. 124s Preparing to unpack .../35-g++-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 124s Unpacking g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 124s Selecting previously unselected package g++-14. 124s Preparing to unpack .../36-g++-14_14.2.0-19ubuntu2_amd64.deb ... 124s Unpacking g++-14 (14.2.0-19ubuntu2) ... 124s Selecting previously unselected package g++-x86-64-linux-gnu. 124s Preparing to unpack .../37-g++-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 124s Unpacking g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 124s Selecting previously unselected package g++. 124s Preparing to unpack .../38-g++_4%3a14.2.0-1ubuntu1_amd64.deb ... 124s Unpacking g++ (4:14.2.0-1ubuntu1) ... 124s Selecting previously unselected package build-essential. 124s Preparing to unpack .../39-build-essential_12.12ubuntu1_amd64.deb ... 124s Unpacking build-essential (12.12ubuntu1) ... 124s Selecting previously unselected package libllvm20:amd64. 124s Preparing to unpack .../40-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 124s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 125s Selecting previously unselected package libclang-cpp20. 125s Preparing to unpack .../41-libclang-cpp20_1%3a20.1.2-0ubuntu1_amd64.deb ... 125s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 125s Selecting previously unselected package libgc1:amd64. 125s Preparing to unpack .../42-libgc1_1%3a8.2.8-1_amd64.deb ... 125s Unpacking libgc1:amd64 (1:8.2.8-1) ... 125s Selecting previously unselected package libobjc4:amd64. 125s Preparing to unpack .../43-libobjc4_15-20250404-0ubuntu1_amd64.deb ... 125s Unpacking libobjc4:amd64 (15-20250404-0ubuntu1) ... 125s Selecting previously unselected package libobjc-14-dev:amd64. 125s Preparing to unpack .../44-libobjc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 125s Unpacking libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 125s Selecting previously unselected package libclang-common-20-dev:amd64. 125s Preparing to unpack .../45-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 125s Unpacking libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 125s Selecting previously unselected package llvm-20-linker-tools. 125s Preparing to unpack .../46-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 125s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 125s Selecting previously unselected package libclang1-20. 125s Preparing to unpack .../47-libclang1-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 125s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 126s Selecting previously unselected package clang-20. 126s Preparing to unpack .../48-clang-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 126s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 126s Selecting previously unselected package libdebhelper-perl. 126s Preparing to unpack .../49-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 126s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 126s Selecting previously unselected package libtool. 126s Preparing to unpack .../50-libtool_2.5.4-4_all.deb ... 126s Unpacking libtool (2.5.4-4) ... 126s Selecting previously unselected package dh-autoreconf. 126s Preparing to unpack .../51-dh-autoreconf_20_all.deb ... 126s Unpacking dh-autoreconf (20) ... 126s Selecting previously unselected package libarchive-zip-perl. 126s Preparing to unpack .../52-libarchive-zip-perl_1.68-1_all.deb ... 126s Unpacking libarchive-zip-perl (1.68-1) ... 126s Selecting previously unselected package libfile-stripnondeterminism-perl. 126s Preparing to unpack .../53-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 126s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 126s Selecting previously unselected package dh-strip-nondeterminism. 126s Preparing to unpack .../54-dh-strip-nondeterminism_1.14.1-2_all.deb ... 126s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 126s Selecting previously unselected package debugedit. 126s Preparing to unpack .../55-debugedit_1%3a5.1-2_amd64.deb ... 126s Unpacking debugedit (1:5.1-2) ... 126s Selecting previously unselected package dwz. 126s Preparing to unpack .../56-dwz_0.15-1build6_amd64.deb ... 126s Unpacking dwz (0.15-1build6) ... 126s Selecting previously unselected package gettext. 126s Preparing to unpack .../57-gettext_0.23.1-1_amd64.deb ... 126s Unpacking gettext (0.23.1-1) ... 126s Selecting previously unselected package intltool-debian. 126s Preparing to unpack .../58-intltool-debian_0.35.0+20060710.6_all.deb ... 126s Unpacking intltool-debian (0.35.0+20060710.6) ... 126s Selecting previously unselected package po-debconf. 126s Preparing to unpack .../59-po-debconf_1.0.21+nmu1_all.deb ... 126s Unpacking po-debconf (1.0.21+nmu1) ... 126s Selecting previously unselected package debhelper. 126s Preparing to unpack .../60-debhelper_13.24.1ubuntu2_all.deb ... 126s Unpacking debhelper (13.24.1ubuntu2) ... 126s Selecting previously unselected package emacsen-common. 126s Preparing to unpack .../61-emacsen-common_3.0.7_all.deb ... 126s Unpacking emacsen-common (3.0.7) ... 126s Selecting previously unselected package dictionaries-common. 126s Preparing to unpack .../62-dictionaries-common_1.30.10_all.deb ... 126s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 126s Unpacking dictionaries-common (1.30.10) ... 126s Selecting previously unselected package libfakeroot:amd64. 126s Preparing to unpack .../63-libfakeroot_1.37.1-1_amd64.deb ... 126s Unpacking libfakeroot:amd64 (1.37.1-1) ... 126s Selecting previously unselected package fakeroot. 126s Preparing to unpack .../64-fakeroot_1.37.1-1_amd64.deb ... 126s Unpacking fakeroot (1.37.1-1) ... 126s Selecting previously unselected package hunspell-en-us. 126s Preparing to unpack .../65-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 126s Unpacking hunspell-en-us (1:2020.12.07-4) ... 126s Selecting previously unselected package libpgtypes3:amd64. 126s Preparing to unpack .../66-libpgtypes3_17.4-1_amd64.deb ... 126s Unpacking libpgtypes3:amd64 (17.4-1) ... 126s Selecting previously unselected package libpq5:amd64. 126s Preparing to unpack .../67-libpq5_17.4-1_amd64.deb ... 126s Unpacking libpq5:amd64 (17.4-1) ... 126s Selecting previously unselected package libecpg6:amd64. 126s Preparing to unpack .../68-libecpg6_17.4-1_amd64.deb ... 126s Unpacking libecpg6:amd64 (17.4-1) ... 126s Selecting previously unselected package libecpg-compat3:amd64. 126s Preparing to unpack .../69-libecpg-compat3_17.4-1_amd64.deb ... 126s Unpacking libecpg-compat3:amd64 (17.4-1) ... 126s Selecting previously unselected package libssl-dev:amd64. 126s Preparing to unpack .../70-libssl-dev_3.4.1-1ubuntu3_amd64.deb ... 126s Unpacking libssl-dev:amd64 (3.4.1-1ubuntu3) ... 126s Selecting previously unselected package libpq-dev. 126s Preparing to unpack .../71-libpq-dev_17.4-1_amd64.deb ... 126s Unpacking libpq-dev (17.4-1) ... 127s Selecting previously unselected package libecpg-dev. 127s Preparing to unpack .../72-libecpg-dev_17.4-1_amd64.deb ... 127s Unpacking libecpg-dev (17.4-1) ... 127s Selecting previously unselected package libncurses-dev:amd64. 127s Preparing to unpack .../73-libncurses-dev_6.5+20250216-2_amd64.deb ... 127s Unpacking libncurses-dev:amd64 (6.5+20250216-2) ... 127s Selecting previously unselected package libtcl8.6:amd64. 127s Preparing to unpack .../74-libtcl8.6_8.6.16+dfsg-1_amd64.deb ... 127s Unpacking libtcl8.6:amd64 (8.6.16+dfsg-1) ... 127s Selecting previously unselected package libxml2-dev:amd64. 127s Preparing to unpack .../75-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_amd64.deb ... 127s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 127s Selecting previously unselected package libxslt1.1:amd64. 127s Preparing to unpack .../76-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 127s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 127s Selecting previously unselected package llvm-20-runtime. 127s Preparing to unpack .../77-llvm-20-runtime_1%3a20.1.2-0ubuntu1_amd64.deb ... 127s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 127s Selecting previously unselected package libpfm4:amd64. 127s Preparing to unpack .../78-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 127s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 127s Selecting previously unselected package llvm-20. 127s Preparing to unpack .../79-llvm-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 127s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 127s Selecting previously unselected package libffi-dev:amd64. 127s Preparing to unpack .../80-libffi-dev_3.4.7-1_amd64.deb ... 127s Unpacking libffi-dev:amd64 (3.4.7-1) ... 127s Selecting previously unselected package llvm-20-tools. 127s Preparing to unpack .../81-llvm-20-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 127s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 127s Selecting previously unselected package llvm-20-dev. 127s Preparing to unpack .../82-llvm-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 127s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 129s Selecting previously unselected package locales-all. 129s Preparing to unpack .../83-locales-all_2.41-6ubuntu1_amd64.deb ... 129s Unpacking locales-all (2.41-6ubuntu1) ... 131s Selecting previously unselected package postgresql-client-17. 131s Preparing to unpack .../84-postgresql-client-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-client-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-17. 131s Preparing to unpack .../85-postgresql-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-doc-17. 131s Preparing to unpack .../86-postgresql-doc-17_17.4-1_all.deb ... 131s Unpacking postgresql-doc-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-plperl-17. 131s Preparing to unpack .../87-postgresql-plperl-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-plperl-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-plpython3-17. 131s Preparing to unpack .../88-postgresql-plpython3-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-plpython3-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-pltcl-17. 131s Preparing to unpack .../89-postgresql-pltcl-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-pltcl-17 (17.4-1) ... 131s Selecting previously unselected package postgresql-server-dev-17. 131s Preparing to unpack .../90-postgresql-server-dev-17_17.4-1_amd64.deb ... 131s Unpacking postgresql-server-dev-17 (17.4-1) ... 132s Setting up postgresql-client-common (274) ... 132s Setting up libpgtypes3:amd64 (17.4-1) ... 132s Setting up binutils-gold-x86-64-linux-gnu (2.44-2) ... 132s Setting up libncurses-dev:amd64 (6.5+20250216-2) ... 132s Setting up libio-pty-perl (1:1.20-1build3) ... 132s Setting up libarchive-zip-perl (1.68-1) ... 132s Setting up binutils-gold (2.44-2) ... 132s Setting up libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 132s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 132s Setting up postgresql-doc-17 (17.4-1) ... 132s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 132s Setting up libpq5:amd64 (17.4-1) ... 132s Setting up m4 (1.4.19-7) ... 132s Setting up libgomp1:amd64 (15-20250404-0ubuntu1) ... 132s Setting up libffi-dev:amd64 (3.4.7-1) ... 132s Setting up locales-all (2.41-6ubuntu1) ... 132s Setting up libfakeroot:amd64 (1.37.1-1) ... 132s Setting up fakeroot (1.37.1-1) ... 132s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 132s Setting up autotools-dev (20220109.1) ... 132s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 132s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 132s Setting up emacsen-common (3.0.7) ... 132s Setting up ssl-cert (1.1.3ubuntu1) ... 132s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 132s Setting up libquadmath0:amd64 (15-20250404-0ubuntu1) ... 132s Setting up libssl-dev:amd64 (3.4.1-1ubuntu3) ... 132s Setting up libmpc3:amd64 (1.3.1-1build2) ... 132s Setting up libtcl8.6:amd64 (8.6.16+dfsg-1) ... 132s Setting up autopoint (0.23.1-1) ... 132s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 132s Setting up libipc-run-perl (20231003.0-2) ... 132s Setting up libgc1:amd64 (1:8.2.8-1) ... 132s Setting up autoconf (2.72-3ubuntu1) ... 132s Setting up libubsan1:amd64 (15-20250404-0ubuntu1) ... 132s Setting up dwz (0.15-1build6) ... 132s Setting up libhwasan0:amd64 (15-20250404-0ubuntu1) ... 132s Setting up libasan8:amd64 (15-20250404-0ubuntu1) ... 132s Setting up libjson-perl (4.10000-1) ... 132s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 132s Setting up debugedit (1:5.1-2) ... 132s Setting up libecpg6:amd64 (17.4-1) ... 132s Setting up libtsan2:amd64 (15-20250404-0ubuntu1) ... 132s Setting up libisl23:amd64 (0.27-1) ... 132s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 133s Setting up libcc1-0:amd64 (15-20250404-0ubuntu1) ... 133s Setting up liblsan0:amd64 (15-20250404-0ubuntu1) ... 133s Setting up libitm1:amd64 (15-20250404-0ubuntu1) ... 133s Setting up postgresql-common-dev (274) ... 133s Setting up automake (1:1.17-3ubuntu1) ... 133s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 133s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 133s Setting up gettext (0.23.1-1) ... 133s Setting up libecpg-compat3:amd64 (17.4-1) ... 133s Setting up dictionaries-common (1.30.10) ... 133s Setting up postgresql-client-17 (17.4-1) ... 133s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 133s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 133s Setting up libpq-dev (17.4-1) ... 133s Setting up libobjc4:amd64 (15-20250404-0ubuntu1) ... 133s Setting up libecpg-dev (17.4-1) ... 133s Setting up intltool-debian (0.35.0+20060710.6) ... 133s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 133s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 133s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 133s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 133s Setting up postgresql-common (274) ... 134s Creating config file /etc/postgresql-common/createcluster.conf with new version 134s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 134s en_us 134s Removing obsolete dictionary files: 134s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 135s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 135s Setting up cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 135s Setting up cpp-14 (14.2.0-19ubuntu2) ... 135s Setting up dh-strip-nondeterminism (1.14.1-2) ... 135s Setting up hunspell-en-us (1:2020.12.07-4) ... 135s Setting up libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 135s Setting up libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 135s Setting up cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 135s Setting up postgresql-17 (17.4-1) ... 136s Creating new PostgreSQL cluster 17/main ... 136s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 136s The files belonging to this database system will be owned by user "postgres". 136s This user must also own the server process. 136s 136s The database cluster will be initialized with locale "C.UTF-8". 136s The default database encoding has accordingly been set to "UTF8". 136s The default text search configuration will be set to "english". 136s 136s Data page checksums are disabled. 136s 136s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 136s creating subdirectories ... ok 136s selecting dynamic shared memory implementation ... posix 136s selecting default "max_connections" ... 100 136s selecting default "shared_buffers" ... 128MB 136s selecting default time zone ... Etc/UTC 136s creating configuration files ... ok 136s running bootstrap script ... ok 137s performing post-bootstrap initialization ... ok 137s syncing data to disk ... ok 139s Setting up po-debconf (1.0.21+nmu1) ... 139s Setting up libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 139s Setting up postgresql-plpython3-17 (17.4-1) ... 139s Setting up postgresql-plperl-17 (17.4-1) ... 140s Setting up cpp (4:14.2.0-1ubuntu1) ... 140s Setting up gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 140s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 140s Setting up postgresql-pltcl-17 (17.4-1) ... 140s Setting up gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 140s Setting up libtool (2.5.4-4) ... 140s Setting up gcc-14 (14.2.0-19ubuntu2) ... 140s Setting up dh-autoreconf (20) ... 140s Setting up postgresql-server-dev-17 (17.4-1) ... 140s Setting up g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 140s Setting up g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 140s Setting up g++-14 (14.2.0-19ubuntu2) ... 140s Setting up debhelper (13.24.1ubuntu2) ... 140s Setting up gcc (4:14.2.0-1ubuntu1) ... 140s Setting up g++ (4:14.2.0-1ubuntu1) ... 140s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 140s Setting up build-essential (12.12ubuntu1) ... 140s Processing triggers for libc-bin (2.41-6ubuntu1) ... 140s Processing triggers for systemd (257.4-1ubuntu3) ... 140s Processing triggers for man-db (2.13.0-1) ... 142s Processing triggers for install-info (7.1.1-1) ... 142s Processing triggers for dictionaries-common (1.30.10) ... 144s autopkgtest [18:38:51]: test run-testsuite: [----------------------- 145s ====== Running all tests with umask 077 ======= 145s ### PostgreSQL test 001_packages.t ### 145s 1..22 145s ok 1 - /etc/os-release exists 145s ok 2 - OS is ubuntu 145s ok 3 - OS version is 25.04 145s # PostgreSQL versions installed: 17 145s ok 4 - postgresql-17 installed 145s ok 5 - postgresql-plpython3-17 installed 145s ok 6 - postgresql-plperl-17 installed 145s ok 7 - postgresql-pltcl-17 installed 145s ok 8 - postgresql-server-dev-17 installed 145s ok 9 # skip No postgresql-contrib-17 package for version 17 145s # postgresql-doc-17 installed 145s ok 10 - At least one doc package installed 145s ok 11 - libecpg-dev installed 145s ok 12 - postgresql-common-dev installed 145s ok 13 - procps installed 145s ok 14 - netcat-openbsd installed 145s ok 15 - hunspell-en-us installed 145s ok 16 - system has a default UTF-8 locale 145s ok 17 - locale ru_RU exists 145s ok 18 - locale ru_RU.UTF-8 exists 145s ok 19 - user postgres in the UNIX group ssl-cert 145s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 145s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 145s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 145s ### End test 001_packages.t ### 145s 145s ### PostgreSQL test 002_existing_clusters.t ### 145s 1..8 145s # Cleanup 145s ok 1 - Cleanup: No clusters left behind 145s ok 2 - No postgres processes left behind 145s ok 3 - No files in /etc/postgresql left behind 145s ok 4 - No files in /var/lib/postgresql left behind 145s ok 5 - No files in /var/run/postgresql left behind 145s ok 6 - No files in /var/log/postgresql left behind 145s ok 7 - PostgreSQL TCP ports are closed 145s ok 8 - Next free port is 5432 145s ### End test 002_existing_clusters.t ### 145s 145s ### PostgreSQL test 003_alternatives.t ### 145s 1..9 145s # Newest PG version installed is 17 145s ok 1 - psql.1.gz link group 145s ok 2 - postmaster.1.gz link group does not exist 145s ok 3 - psql.1.gz alternative 145s ok 4 - pg_dump.1.gz alternative 145s ok 5 - postgres.1.gz alternative 145s ok 6 - pg_ctl.1.gz alternative 145s # Newest PG doc version installed is 17 145s ok 7 - SPI_connect.3.gz link group 145s ok 8 - SPI_connect.3.gz alternative 145s ok 9 - SPI_exec.3.gz alternative 145s ### End test 003_alternatives.t ### 145s 145s ### PostgreSQL test 005_PgCommon.t ### 145s 1..24 145s ok 1 - correctly parsed line 'local all postgres ident sameuser' 145s ok 2 - correctly parsed line 'local foo nobody trust' 145s ok 3 - correctly parsed line 'local foo nobody crypt' 145s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 145s ok 5 - correctly parsed line 'local foo,bar nobody ident' 145s ok 6 - correctly parsed line 'local all +foogrp password' 145s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 145s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 145s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 145s ok 10 - @expected_records has correct number of entries 145s ok 11 - returned read_pg_hba array has correct number of records 145s ok 12 - line 'foo all all md5' parsed as invalid 145s ok 13 - line 'local all all foo' parsed as invalid 145s ok 14 - line 'host all all foo' parsed as invalid 145s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 145s ok 16 - line 'host all all md5' parsed as invalid 145s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 145s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 145s ok 19 - read_conf_file returns empty dict for nonexisting file 145s ok 20 - read_conf_file() parsing 145s ok 21 - read_conf_file() parsing with include directives 145s ok 22 - set_conf_value 145s ok 23 - disable_conf_value 145s ok 24 - replace_conf_value 145s ### End test 005_PgCommon.t ### 145s 145s ### PostgreSQL test 006_next_free_port.t ### 145s 1..5 145s ok 1 - next_free_port is 5432 146s ok 2 - next_free_port detects localhost ipv4 socket 147s ok 3 - next_free_port detects wildcard ipv4 socket 148s ok 4 - next_free_port detects localhost ipv6 socket 149s ok 5 - next_free_port detects wildcard ipv6 socket 149s ### End test 006_next_free_port.t ### 149s 149s ### PostgreSQL test 007_pg_conftool.t ### 149s 1..41 150s # test without cluster 150s ok 1 - pg_conftool show all 150s ok 2 - correct output of pg_conftool show all 150s ok 3 - pg_conftool foo.conf show all 150s ok 4 - correct output of pg_conftool foo.conf show all 150s ok 5 - pg_conftool /tmp/M6Jol3nZhQ/different.conf show all 150s ok 6 - correct output of pg_conftool /tmp/M6Jol3nZhQ/different.conf show all 150s ok 7 - pg_conftool 9.7 main show all 150s ok 8 - correct output of pg_conftool 9.7 main show all 150s # test show 150s ok 9 - pg_conftool show all 150s ok 10 - correct output of pg_conftool show all 150s ok 11 - pg_conftool other.conf show all 150s ok 12 - correct output of pg_conftool other.conf show all 150s ok 13 - pg_conftool /tmp/M6Jol3nZhQ/different.conf show all 150s ok 14 - correct output of pg_conftool /tmp/M6Jol3nZhQ/different.conf show all 150s ok 15 - pg_conftool 17 main show all 150s ok 16 - correct output of pg_conftool 17 main show all 150s ok 17 - pg_conftool 17 main other.conf show all 150s ok 18 - correct output of pg_conftool 17 main other.conf show all 150s ok 19 - pg_conftool show a 150s ok 20 - correct output of pg_conftool show a 150s ok 21 - pg_conftool -s show a 150s ok 22 - correct output of pg_conftool -s show a 150s # test set 150s ok 23 - pg_conftool set c 7 150s ok 24 - correct output of pg_conftool set c 7 150s ok 25 - file contains new setting 150s ok 26 - pg_conftool set a 8 150s ok 27 - correct output of pg_conftool set a 8 150s ok 28 - file contains updated setting 150s ok 29 - pg_conftool /tmp/M6Jol3nZhQ/different.conf set a 9 150s ok 30 - correct output of pg_conftool /tmp/M6Jol3nZhQ/different.conf set a 9 150s ok 31 - file with path contains updated setting 150s # test remove 150s ok 32 - pg_conftool remove a 150s ok 33 - correct output of pg_conftool remove a 150s ok 34 - setting removed from file 150s ok 35 - pg_conftool /tmp/M6Jol3nZhQ/different.conf remove a 150s ok 36 - correct output of pg_conftool /tmp/M6Jol3nZhQ/different.conf remove a 150s ok 37 - setting removed from file with path 150s # test edit 150s ok 38 - pg_conftool edit 150s ok 39 - correct output of pg_conftool edit 150s ok 40 - pg_conftool /tmp/M6Jol3nZhQ/different.conf edit 150s ok 41 - correct output of pg_conftool /tmp/M6Jol3nZhQ/different.conf edit 150s ### End test 007_pg_conftool.t ### 150s 150s ### PostgreSQL test 010_defaultport_cluster.t ### 150s 1..14 150s ok 1 - psql --version 150s ok 2 - pg_wrapper selects highest available version number 150s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 150s ok 4 - connecting to localhost fails with no clusters 150s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 150s ok 6 - pg_wrapper uses host and port from PGCLUSTER 150s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 150s ok 8 - pg_wrapper uses --cluster from the command line 150s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 150s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 151s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 151s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 151s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 151s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 151s ### End test 010_defaultport_cluster.t ### 151s 151s ### PostgreSQL test 015_start_stop.t ### 151s 1..71 151s # We are running systemd 151s # Running tests for 17 151s # Cluster does not exist yet 151s ok 1 - cluster 17 main does not exist 151s ok 2 - service postgresql@17-main does not exist 151s ok 3 - systemctl start postgresql 151s ok 4 - cluster 17 main does not exist 151s ok 5 - service postgresql@17-main does not exist 151s ok 6 - systemctl start postgresql@17-main 151s ok 7 - cluster 17 main does not exist 151s ok 8 - service postgresql@17-main does not exist 151s # Start/stop postgresql using system tools 152s ok 9 - pg_createcluster 17 main 152s ok 10 - cluster 17 main is stopped 152s ok 11 - service postgresql@17-main is stopped 154s ok 12 - systemctl start postgresql 154s ok 13 - cluster 17 main is running 154s ok 14 - service postgresql@17-main is running 154s ok 15 - systemctl start postgresql 154s ok 16 - cluster 17 main is already running 154s ok 17 - service postgresql@17-main is already running 154s ok 18 - systemctl stop postgresql 160s ok 19 - cluster 17 main is stopped 160s ok 20 - service postgresql@17-main is stopped 160s ok 21 - systemctl stop postgresql 160s ok 22 - cluster 17 main is already stopped 160s ok 23 - service postgresql@17-main is already stopped 160s # Start/stop specific cluster using system tools 163s ok 24 - systemctl start postgresql@17-main 163s ok 25 - cluster 17 main is running 163s ok 26 - service postgresql@17-main is running 163s ok 27 - systemctl start postgresql@17-main 163s ok 28 - cluster 17 main is running 163s ok 29 - service postgresql@17-main is running 165s ok 30 - systemctl restart postgresql@17-main 165s ok 31 - cluster 17 main is running 165s ok 32 - service postgresql@17-main is running 166s ok 33 - systemctl stop postgresql@17-main 166s ok 34 - cluster 17 main is stopped 166s ok 35 - service postgresql@17-main is stopped 166s ok 36 - systemctl stop postgresql@17-main 166s ok 37 - cluster 17 main is already stopped 166s ok 38 - service postgresql@17-main is already stopped 167s ok 39 - pg_dropcluster 17 main 167s ok 40 - cluster 17 main does not exist 167s ok 41 - service postgresql@17-main does not exist 167s # Start/stop specific cluster using pg_*cluster 167s ok 42 - pg_ctlcluster start 17 main 167s ok 43 - cluster 17 main does not exist 167s ok 44 - service postgresql@17-main does not exist 171s ok 45 - pg_createcluster 17 main --start 171s ok 46 - cluster 17 main is running 171s ok 47 - service postgresql@17-main is running 171s ok 48 - pg_ctlcluster 17 main start 171s ok 49 - cluster 17 main is already running 171s ok 50 - service postgresql@17-main is already running 173s ok 51 - pg_ctlcluster 17-main restart 173s ok 52 - cluster 17 main is running 173s ok 53 - service postgresql@17-main is running 173s ok 54 - pg_ctlcluster 17 main stop 174s ok 55 - cluster 17 main is stopped 174s ok 56 - service postgresql@17-main is stopped 174s ok 57 - pg_ctlcluster 17 main stop 174s ok 58 - cluster 17 main is already stopped 174s ok 59 - service postgresql@17-main is already stopped 176s ok 60 - pg_ctlcluster start 17-main 176s ok 61 - cluster 17 main is running 176s ok 62 - service postgresql@17-main is running 178s ok 63 - pg_dropcluster 17 main --stop 178s # Cleanup 178s ok 64 - Cleanup: No clusters left behind 178s ok 65 - No postgres processes left behind 178s ok 66 - No files in /etc/postgresql left behind 178s ok 67 - No files in /var/lib/postgresql left behind 178s ok 68 - No files in /var/run/postgresql left behind 178s ok 69 - No files in /var/log/postgresql left behind 178s ok 70 - PostgreSQL TCP ports are closed 178s ok 71 - Next free port is 5432 178s ### End test 015_start_stop.t ### 178s 178s ### PostgreSQL test 020_create_sql_remove.t ### 178s 1..141 178s # Running tests for 17 181s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.e3nbCM 181s ok 2 - pg_createcluster 17 main 181s ok 3 - Socket and pid file are in /var/run/postgresql/ 181s ok 4 - xlog/wal directory /tmp/17.xlog.e3nbCM was created 181s ok 5 - local method in pg_hba.conf is peer 181s ok 6 - host method in pg_hba.conf is scram-sha-256 181s ok 7 - Exactly one postgres master process running 183s ok 8 - pg_ctlcluster 17 main restart 183s ok 9 - cluster restarts with new environment file 183s ok 10 - Exactly one postgres master process running 183s ok 11 - correct value of PGEXTRAVAR1 in environment 183s ok 12 - correct value of PGEXTRAVAR2 in environment 183s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 183s ok 14 - createdb --version 183s ok 15 - pg_wrapper+createdb selects version number of cluster 183s ok 16 - psql --version 183s ok 17 - pg_wrapper+psql selects version 17 183s ok 18 - pg_lscluster reports online cluster on port 5432 183s ok 19 - log file is actually used 183s ok 20 - /etc/postgresql is owned by user "postgres" 183s ok 21 - version configuration directory file is owned by user "postgres" 183s ok 22 - configuration directory file is owned by user "postgres" 183s ok 23 - version data directory file is owned by user "postgres" 183s ok 24 - data directory file is owned by user "postgres" 183s ok 25 - log file has 0640 permissions 183s ok 26 - log file is owned by user "postgres" 183s ok 27 - log file is owned by group "adm" 183s ok 28 - no log symlink by default 183s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 183s ok 30 - pg_lsclusters -h 183s ok 31 - correct output of pg_lsclusters -h 184s ok 32 - stopping cluster 186s ok 33 - restarting cluster with nondefault log symlink 186s ok 34 - log target is used as log file 186s ok 35 - default log is not used 186s ok 36 - pg_lsclusters -h 186s ok 37 - correct output of pg_lsclusters -h 186s ok 38 - stopping cluster 189s ok 39 - restarting cluster with explicitly configured log file 189s ok 40 - default log is not used 189s ok 41 - log symlink target is used for startup message 189s ok 42 - exactly one log file 189s ok 43 - custom log is actually used 189s ok 44 - pg_lsclusters -h 189s ok 45 - correct output of pg_lsclusters -h 189s ok 46 - stopping cluster 189s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 189s ok 48 - /etc/postgres-hack was not created 192s ok 49 - restarting cluster 192s ok 50 - ps -o tty -U postgres h 192s ok 51 - postgres processes do not have an associated terminal 192s ok 52 - Server is linked with SSL support 192s ok 53 - SSL is enabled in postgresql.conf 192s ok 54 - psql -l fails for nobody 192s ok 55 - createuser nobody 192s ok 56 - createdb nobodydb 192s ok 57 - psql -ltA succeeds for nobody 192s ok 58 - psql -ltA output 192s ok 59 - SQL command: create table 192s ok 60 - SQL command: insert into table values 192s ok 61 - SQL command: insert into table values 192s ok 62 - primary key violation 192s ok 63 - psql -tAc "select * from phone order by name" nobodydb 192s ok 64 - SQL command output: select -tA 192s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 192s ok 66 - SQL command output: select -tx 192s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 192s ok 68 - SQL command output: select -tAx 192s ok 69 - CREATE EXTENSION plperlu fails for user nobody 192s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 192s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 192s ok 72 - creating PL/PerlU function as user nobody fails 192s ok 73 - creating unsafe PL/Perl function as user postgres fails 192s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 192s ok 75 - creating PL/PerlU function as user postgres succeeds 193s ok 76 - psql nobodydb -Atc "select read_file()" 193s ok 77 - calling PL/PerlU function 193s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 193s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 193s ok 80 - creating unsafe PL/Perl function as user nobody fails 193s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 193s ok 82 - creating PL/Perl function as user nobody succeeds 193s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 193s ok 84 - calling PL/Perl function 193s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 193s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 193s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 193s ok 88 - creating PL/Python3 function as user postgres succeeds 193s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 193s ok 90 - calling PL/Python function 193s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 193s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 193s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 193s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 193s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 193s ok 96 - creating PL/Tcl function as user nobody succeeds 193s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 193s ok 98 - creating PL/TclU function as user postgres succeeds 193s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 193s ok 100 - calling PL/Tcl function 193s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 193s ok 102 - calling PL/TclU function 193s ok 103 - stopping cluster 193s ok 104 - pg_ctlcluster 17 main start 193s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 196s ok 106 - pg_ctlcluster 17 main start 196s ok 107 - cluster restarts with pgdata symlink 196s ok 108 - postgres master has OOM killer protection 196s ok 109 - postgres client backend has no OOM adjustment 196s ok 110 - ps h 6945 196s ok 111 - process title is idle 197s ok 112 - ps h 6945 197s ok 113 - process title is idle in transaction 197s ok 114 - stopping cluster 199s ok 115 - starting cluster as postgres works without a log file 199s ok 116 - log file got recreated and used 199s ok 117 - creating a directory in spc2 199s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.QxD3lU'" 199s ok 119 - creating tablespace spc1 199s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 199s ok 121 - creating a table in spc1 199s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.Q7WL3_'" 199s ok 123 - creating tablespace spc2 199s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 199s ok 125 - creating a table in spc2 199s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 199s ok 127 - Correct apt NeverAutoRemove config 201s ok 128 - pg_dropcluster removes cluster 201s ok 129 - xlog/wal directory /tmp/17.xlog.e3nbCM was deleted 201s ok 130 - tablespace spc1 was emptied 201s ok 131 - tablespace spc2 was emptied 201s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 201s ok 133 - Correct apt NeverAutoRemove config 201s # Cleanup 201s ok 134 - Cleanup: No clusters left behind 201s ok 135 - No postgres processes left behind 201s ok 136 - No files in /etc/postgresql left behind 201s ok 137 - No files in /var/lib/postgresql left behind 201s ok 138 - No files in /var/run/postgresql left behind 201s ok 139 - No files in /var/log/postgresql left behind 201s ok 140 - PostgreSQL TCP ports are closed 201s ok 141 - Next free port is 5432 201s ### End test 020_create_sql_remove.t ### 201s 201s ### PostgreSQL test 021_pg_renamecluster.t ### 201s 1..20 204s ok 1 - pg_createcluster 17 main 207s ok 2 - pg_renamecluster 17 main donau 207s ok 3 - psql -tAc "show data_directory" 207s ok 4 - cluster is running and data_directory was moved 207s ok 5 - pg_hba.conf location updated 207s ok 6 - pg_ident.conf location updated 207s ok 7 - external_pid_file location updated 207s ok 8 - external_pid_file exists 207s ok 9 # skip no stats_temp_directory in 17 207s ok 10 # skip no stats_temp_directory in 17 207s ok 11 - cluster_name is updated 209s ok 12 - pg_dropcluster removes cluster 209s # Cleanup 209s ok 13 - Cleanup: No clusters left behind 209s ok 14 - No postgres processes left behind 209s ok 15 - No files in /etc/postgresql left behind 209s ok 16 - No files in /var/lib/postgresql left behind 209s ok 17 - No files in /var/run/postgresql left behind 209s ok 18 - No files in /var/log/postgresql left behind 209s ok 19 - PostgreSQL TCP ports are closed 209s ok 20 - Next free port is 5432 209s ### End test 021_pg_renamecluster.t ### 209s 209s ### PostgreSQL test 022_recovery.t ### 209s 1..17 209s # Running tests for 17 212s ok 1 - pg_createcluster 17 main --start >/dev/null 212s ok 2 - pg_ctlcluster 17 main stop -m i 214s ok 3 - pg_ctlcluster 17 main start 214s ok 4 - psql -c '' 215s ok 5 - pg_ctlcluster 17 main stop -m i 215s ok 6 - create write-protected file in data directory 217s ok 7 - pg_ctlcluster 17 main start 217s ok 8 - psql -c '' 219s ok 9 - pg_dropcluster removes cluster 219s # Cleanup 219s ok 10 - Cleanup: No clusters left behind 219s ok 11 - No postgres processes left behind 219s ok 12 - No files in /etc/postgresql left behind 219s ok 13 - No files in /var/lib/postgresql left behind 219s ok 14 - No files in /var/run/postgresql left behind 219s ok 15 - No files in /var/log/postgresql left behind 219s ok 16 - PostgreSQL TCP ports are closed 219s ok 17 - Next free port is 5432 219s ### End test 022_recovery.t ### 219s 219s ### PostgreSQL test 025_logging.t ### 219s 1..55 219s # Logging to /var/log/syslog works 219s # Running tests for 17 223s ok 1 - pg_createcluster 17 main 223s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 223s ok 3 - psql -qc "'foobar_17_8158'" 223s ok 4 - log an error 223s ok 5 - grep --binary-files=text foobar_17_8158 /var/log/postgresql/postgresql-17-main.log 223s ok 6 - error appears in logfile 223s ok 7 - pg_conftool 17 main set log_destination syslog 223s ok 8 - set log_destination syslog 223s ok 9 - pg_ctlcluster 17 main reload 223s ok 10 - 17 main reload 223s ok 11 - psql -Atc "show log_destination" 223s ok 12 - log_destination is syslog 223s ok 13 - pg_lscluster reports syslog 224s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 224s ok 15 - error appears in /var/log/syslog 224s ok 16 - pg_conftool 17 main set logging_collector on 224s ok 17 - set logging_collector on 224s ok 18 - pg_conftool 17 main set log_destination csvlog 224s ok 19 - set log_destination csvlog 226s ok 20 - pg_ctlcluster 17 main restart 226s ok 21 - 17 main restart 227s ok 22 - psql -Atc "show logging_collector" 227s ok 23 - logging_collector is on 227s ok 24 - psql -Atc "show log_destination" 227s ok 25 - log_destination is csvlog 227s ok 26 - pg_lscluster reports csvlog 227s ok 27 - psql -qc "'barbaz_17_8158'" 227s ok 28 - log an error 227s ok 29 - grep --binary-files=text barbaz_17_8158 /var/lib/postgresql/17/main/log/*.csv 227s ok 30 - error appears in log/*.csv 227s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 227s ok 32 - set log_destination stderr,syslog,csvlog 227s ok 33 - pg_ctlcluster 17 main reload 227s ok 34 - 17 main reload 227s ok 35 - psql -Atc "show log_destination" 227s ok 36 - log_destination is stderr,syslog,csvlog 227s ok 37 - pg_lscluster reports stderr,syslog,csvlog 227s ok 38 - psql -qc "'moo_17_8158'" 227s ok 39 - log an error 228s ok 40 - grep --binary-files=text moo_17_8158 /var/lib/postgresql/17/main/log/*.log 228s ok 41 - error appears in log/*.log 228s ok 42 - grep --binary-files=text 'postgres.*moo_17_8158' /var/log/syslog 228s ok 43 - error appears in /var/log/syslog 228s ok 44 - grep --binary-files=text moo_17_8158 /var/lib/postgresql/17/main/log/*.csv 228s ok 45 - error appears in log/*.csv 230s ok 46 - pg_dropcluster 17 main --stop 230s ok 47 - pg_dropcluster removes cluster 230s # Cleanup 230s ok 48 - Cleanup: No clusters left behind 230s ok 49 - No postgres processes left behind 230s ok 50 - No files in /etc/postgresql left behind 230s ok 51 - No files in /var/lib/postgresql left behind 230s ok 52 - No files in /var/run/postgresql left behind 230s ok 53 - No files in /var/log/postgresql left behind 230s ok 54 - PostgreSQL TCP ports are closed 230s ok 55 - Next free port is 5432 230s ### End test 025_logging.t ### 230s 230s ### PostgreSQL test 027_jit.t ### 230s # 17 233s ok 1 - pg_createcluster 17 main --start 233s ok 2 - psql -Xatc 'show jit' 233s ok 3 - JIT is on by default 234s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 234s ok 5 - No JIT on cheap query 234s ok 6 - pg_conftool 17 main set seq_page_cost 100000 234s ok 7 - pg_conftool 17 main set random_page_cost 100000 234s ok 8 - pg_ctlcluster 17 main reload 234s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 234s ok 10 - Expensive query is JITed 235s ok 11 - pg_dropcluster --stop 17 main 235s # Cleanup 235s ok 12 - Cleanup: No clusters left behind 235s ok 13 - No postgres processes left behind 235s ok 14 - No files in /etc/postgresql left behind 235s ok 15 - No files in /var/lib/postgresql left behind 235s ok 16 - No files in /var/run/postgresql left behind 235s ok 17 - No files in /var/log/postgresql left behind 235s ok 18 - PostgreSQL TCP ports are closed 235s ok 19 - Next free port is 5432 235s 1..19 235s ### End test 027_jit.t ### 235s 235s ### PostgreSQL test 030_errors.t ### 235s 1..156 235s ok 1 - pg_lscluster reports cluster without binaries 237s ok 2 - pg_dropcluster 6.3 main 238s ok 3 - pg_createcluster --socketdir 238s ok 4 - pg_lsclusters -h 238s ok 5 - cluster was created 238s ok 6 - Port of created cluster is 5432 238s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 238s ok 8 - pg_createcluster on existing cluster 238s ok 9 - pg_lsclusters -h 238s ok 10 - original cluster still exists 238s ok 11 - pg_createcluster 17 test -p foo 238s ok 12 - pg_createcluster -p checks that port option is numeric 238s ok 13 - pg_createcluster 17 test -p 42 238s ok 14 - pg_createcluster -p checks valid port range 238s ok 15 - pg_ctlcluster 17 main start 238s ok 16 - pg_ctlcluster refuses to start root-owned cluster 238s ok 17 - pg_ctlcluster 17 main start 238s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 238s ok 19 - pg_ctlcluster 17 main start 238s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 238s ok 21 - pg_ctlcluster 17 main start 238s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 240s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 240s ok 24 - No sockets in /var/run/postgresql 240s ok 25 - Socket is in /tmp/postgresql-testsuite/ 240s ok 26 - cluster stops with custom unix_socket_dir 240s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 243s ok 28 - cluster starts after removing unix_socket_dir 243s ok 29 - Socket is in default dir /var/run/postgresql 243s ok 30 - No sockets in /tmp/postgresql-testsuite/ 243s ok 31 - pg_ctlcluster 17 main stop 243s ok 32 - pg_ctlcluster fails with corrupted PID file 243s ok 33 - pg_lsclusters -h 243s ok 34 - cluster is still online 243s ok 35 - pg_ctlcluster succeeds with restored PID file 243s ok 36 - pg_lsclusters -h 243s ok 37 - cluster is down 243s ok 38 - pg_ctlcluster 17 main stop 243s ok 39 - pg_ctlcluster stop fails on stopped cluster 245s ok 40 - pg_ctlcluster 17 main start 245s ok 41 - pg_ctlcluster succeeds with already existing PID file 245s ok 42 - pg_lsclusters -h 245s ok 43 - cluster is online 246s ok 44 - pg_ctlcluster stop succeeds 246s ok 45 - pg_lsclusters -h 246s ok 46 - cluster is down 246s ok 47 - no pid file left 246s ok 48 - pg_ctlcluster 17 main stop 246s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 246s ok 50 - pid file was cleaned up 246s ok 51 - pg_ctlcluster --force 17 main stop 246s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 246s ok 53 - pid file was cleaned up 246s ok 54 - pg_ctlcluster 17 main stop 246s ok 55 - pg_ctlcluster stop succeeds with stale PID file 246s ok 56 - pid file was cleaned up 246s ok 57 - pg_ctlcluster --force 17 main stop 246s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 246s ok 59 - pid file was cleaned up 246s ok 60 - pg_ctlcluster --force 17 main stop 246s ok 61 - pg_ctlcluster stop succeeds with empty PID file 246s ok 62 - pid file was cleaned up 248s ok 63 - pg_ctlcluster 17 main start 248s ok 64 - pg_ctlcluster succeeds with corrupted PID file 248s ok 65 - pg_lsclusters -h 248s ok 66 - cluster is online 248s ok 67 - pg_ctlcluster 17 main start 248s ok 68 - pg_ctlcluster start fails on running cluster 248s ok 69 - pg_ctlcluster stop 249s ok 70 - pg_ctlcluster 17 main start 249s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 249s ok 72 - pg_ctlcluster 17 main stop 249s ok 73 - stopping cluster 255s ok 74 - pg_ctlcluster 17 main start 255s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 255s ok 76 - pg_ctlcluster 17 main stop 255s ok 77 - stopping cluster 255s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 255s ok 79 - pg_dropcluster 17 main 255s ok 80 - pg_dropcluster works as user postgres 256s ok 81 - pg_createcluster succeeds 256s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 256s ok 83 - proper error message for nonexisting /var/lib/postgresql 258s ok 84 - pg_ctlcluster 17 main start 258s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 259s ok 86 - pg_ctlcluster 17 main stop 259s ok 87 - stopping cluster 260s ok 88 - pg_createcluster other 262s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 264s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 264s ok 91 264s ok 92 - pg_ctlcluster 17 other start 264s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 264s ok 94 - pg_ctlcluster 17 main stop 264s ok 95 - stopping main cluster 266s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 268s 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 17/foo' fails 269s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 269s ok 108 - psql --cluster 17/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 17 foo' fails 269s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 269s ok 114 - pg_dropcluster 17 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 270s ok 118 - 'pg_upgradecluster 17 foo' fails 270s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 270s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 270s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 270s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 270s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 270s ok 124 - 'pg_ctlcluster 17 foo stop' fails 270s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 270s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 270s # Cleanup 270s ok 127 - Cleanup: No clusters left behind 270s ok 128 - No postgres processes left behind 270s ok 129 - No files in /etc/postgresql left behind 270s ok 130 - No files in /var/lib/postgresql left behind 270s ok 131 - No files in /var/run/postgresql left behind 270s ok 132 - No files in /var/log/postgresql left behind 270s ok 133 - PostgreSQL TCP ports are closed 270s ok 134 - Next free port is 5432 271s ok 135 - pg_dropcluster 17 broken 271s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 271s # Cleanup 271s ok 137 - Cleanup: No clusters left behind 271s ok 138 - No postgres processes left behind 271s ok 139 - No files in /etc/postgresql left behind 271s ok 140 - No files in /var/lib/postgresql left behind 271s ok 141 - No files in /var/run/postgresql left behind 271s ok 142 - No files in /var/log/postgresql left behind 271s ok 143 - PostgreSQL TCP ports are closed 271s ok 144 - Next free port is 5432 272s ok 145 - pg_dropcluster 17 broken 272s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 272s ok 147 - /etc/postgresql/17 was removed 272s ok 148 - /var/lib/postgresql/17 was removed 272s # Cleanup 272s ok 149 - Cleanup: No clusters left behind 272s ok 150 - No postgres processes left behind 272s ok 151 - No files in /etc/postgresql left behind 272s ok 152 - No files in /var/lib/postgresql left behind 272s ok 153 - No files in /var/run/postgresql left behind 272s ok 154 - No files in /var/log/postgresql left behind 272s ok 155 - PostgreSQL TCP ports are closed 272s ok 156 - Next free port is 5432 272s ### End test 030_errors.t ### 272s 272s ### PostgreSQL test 031_errors_disk_full.t ### 272s 1..22 272s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 274s ok 1 - script failed 274s ok 2 - pg_createcluster fails due to insufficient disk space 274s ok 3 - does not leave files behind 274s # Cleanup 274s ok 4 - Cleanup: No clusters left behind 274s ok 5 - No postgres processes left behind 274s ok 6 - No files in /etc/postgresql left behind 274s ok 7 - No files in /var/lib/postgresql left behind 274s ok 8 - No files in /var/run/postgresql left behind 274s ok 9 - No files in /var/log/postgresql left behind 274s ok 10 - PostgreSQL TCP ports are closed 274s ok 11 - Next free port is 5432 274s # check disk full conditions on startup 276s ok 12 - script failed 276s ok 13 - pg_ctlcluster prints error message 276s ok 14 - log file has error message 276s # Cleanup 276s ok 15 - Cleanup: No clusters left behind 276s ok 16 - No postgres processes left behind 276s ok 17 - No files in /etc/postgresql left behind 276s ok 18 - No files in /var/lib/postgresql left behind 276s ok 19 - No files in /var/run/postgresql left behind 276s ok 20 - No files in /var/log/postgresql left behind 276s ok 21 - PostgreSQL TCP ports are closed 276s ok 22 - Next free port is 5432 276s ### End test 031_errors_disk_full.t ### 276s 276s ### PostgreSQL test 032_ssl_key_permissions.t ### 276s 1..22 276s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 276s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 276s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 277s ok 4 - pg_createcluster 17 main 277s ok 5 - pg_ctlcluster 17 main start 277s ok 6 - ssl key owned by nobody refused 278s ok 7 - pg_ctlcluster 17 main start 278s ok 8 - ssl key with permissions root:root 0644 refused 278s ok 9 - pg_ctlcluster 17 main start 278s ok 10 - ssl key with permissions postgres:postgres 0640 refused 279s ok 11 - pg_dropcluster 17 main --stop 279s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 279s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 279s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 279s # Cleanup 279s ok 15 - Cleanup: No clusters left behind 279s ok 16 - No postgres processes left behind 279s ok 17 - No files in /etc/postgresql left behind 279s ok 18 - No files in /var/lib/postgresql left behind 279s ok 19 - No files in /var/run/postgresql left behind 279s ok 20 - No files in /var/log/postgresql left behind 279s ok 21 - PostgreSQL TCP ports are closed 279s ok 22 - Next free port is 5432 279s ### End test 032_ssl_key_permissions.t ### 279s 279s ### PostgreSQL test 040_upgrade.t ### 279s 1..1 279s ok 1 - only one major version installed, skipping upgrade tests 279s ### End test 040_upgrade.t ### 279s 279s ### PostgreSQL test 041_upgrade_custompaths.t ### 279s 1..1 279s ok 1 - only one major version installed, skipping upgrade tests 279s ### End test 041_upgrade_custompaths.t ### 279s 279s ### PostgreSQL test 042_upgrade_rename.t ### 279s 1..15 279s # PostgreSQL 17 283s ok 1 - pg_createcluster 17 main --start 289s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 289s ok 3 - pg_lsclusters -h 289s ok 4 - correct output of pg_lsclusters -h 290s ok 5 - pg_dropcluster 17 main --stop 291s ok 6 - pg_dropcluster 17 upgr --stop 291s ok 7 - Cleaning pg_upgrade log files 291s # Cleanup 292s ok 8 - Cleanup: No clusters left behind 292s ok 9 - No postgres processes left behind 292s ok 10 - No files in /etc/postgresql left behind 292s ok 11 - No files in /var/lib/postgresql left behind 292s ok 12 - No files in /var/run/postgresql left behind 292s ok 13 - No files in /var/log/postgresql left behind 292s ok 14 - PostgreSQL TCP ports are closed 292s ok 15 - Next free port is 5432 292s ### End test 042_upgrade_rename.t ### 292s 292s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s ### End test 043_upgrade_ssl_cert.t ### 292s 292s ### PostgreSQL test 045_backup.t ### 292s # We are running systemd 292s # PostgreSQL 17 292s # create cluster 295s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 295s ok 2 - pg_lsclusters -h 295s ok 3 - correct output of pg_lsclusters -h 295s ok 4 - pg_conftool 17 main set work_mem 11MB 295s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 295s ok 6 - psql -c 'alter database mydb set search_path=public' 295s ok 7 - psql -c 'create table foo (t text)' mydb 295s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 295s ok 9 - psql -c 'CREATE USER myuser' 295s ok 10 - psql -c 'grant create on database mydb to myuser' 295s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 295s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 295s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 295s # create directory 295s ok 14 - pg_backupcluster 17 main createdirectory 295s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 295s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 295s # dump 296s ok 17 - systemctl start pg_dump@17-main 296s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-06T184123Z.dump 296s ok 19 - /var/backups/postgresql/17-main/2025-05-06T184123Z.dump owned by uid postgres 296s ok 20 - /var/backups/postgresql/17-main/2025-05-06T184123Z.dump owned by gid postgres 296s # basebackup 296s ok 21 - systemctl start pg_receivewal@17-main 296s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 297s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 297s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 297s ok 25 - psql -c 'select pg_reload_conf()' 325s ok 26 - systemctl start pg_basebackup@17-main 325s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-06T184124Z.backup 325s ok 28 - /var/backups/postgresql/17-main/2025-05-06T184124Z.backup owned by uid postgres 325s ok 29 - /var/backups/postgresql/17-main/2025-05-06T184124Z.backup owned by gid postgres 325s # list 325s ok 30 - pg_backupcluster 17 main list 325s ok 31 - correct output of pg_backupcluster 17 main list 325s # more database changes 325s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 325s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 325s ok 34 - retrieve recovery timestamp 325s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 325s ok 36 - systemctl stop pg_receivewal@17-main 325s # restore /var/backups/postgresql/17-main/2025-05-06T184123Z.dump 327s ok 37 - pg_dropcluster 17 main --stop 331s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184123Z.dump --start --datadir /var/lib/postgresql/17/snowflake 331s ok 39 - pg_lsclusters -h 331s ok 40 - correct output of pg_lsclusters -h 331s ok 41 - psql -XAtl 331s ok 42 - mydb locales 331s ok 43 - mydb grants 331s ok 44 - myicudb locales 331s ok 45 - psql -XAtc 'show work_mem' 331s ok 46 - correct output of psql -XAtc 'show work_mem' 331s ok 47 - psql -XAtc 'select * from foo' mydb 331s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 331s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 331s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 331s ok 51 - psql -XAtc '\drds' 331s ok 52 - correct output of psql -XAtc '\drds' 331s # restore /var/backups/postgresql/17-main/2025-05-06T184124Z.backup 333s ok 53 - pg_dropcluster 17 main --stop 336s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184124Z.backup --start --datadir /var/lib/postgresql/17/snowflake 336s ok 55 - pg_lsclusters -h 336s ok 56 - correct output of pg_lsclusters -h 336s ok 57 - psql -XAtl 336s ok 58 - mydb locales 336s ok 59 - mydb grants 336s ok 60 - myicudb locales 336s ok 61 - psql -XAtc 'show work_mem' 336s ok 62 - correct output of psql -XAtc 'show work_mem' 336s ok 63 - psql -XAtc 'select * from foo' mydb 336s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 337s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 337s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 337s ok 67 - psql -XAtc '\drds' 337s ok 68 - correct output of psql -XAtc '\drds' 337s # restore /var/backups/postgresql/17-main/2025-05-06T184124Z.backup with WAL archive 338s ok 69 - pg_dropcluster 17 main --stop 342s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184124Z.backup --start --archive --port 5430 342s ok 71 - pg_lsclusters -h 342s ok 72 - correct output of pg_lsclusters -h 342s ok 73 - psql -XAtc 'select * from foo order by t' mydb 342s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 342s # restore /var/backups/postgresql/17-main/2025-05-06T184124Z.backup with PITR 343s ok 75 - pg_dropcluster 17 main --stop 347s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184124Z.backup --start --pitr '2025-05-06 18:41:52.35533+00 347s # ' 347s ok 77 - pg_lsclusters -h 347s ok 78 - correct output of pg_lsclusters -h 347s ok 79 - psql -XAtc 'select * from foo order by t' mydb 347s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 349s ok 81 - pg_dropcluster 17 main --stop 349s # Cleanup 349s ok 82 - Cleanup: No clusters left behind 349s ok 83 - No postgres processes left behind 349s ok 84 - No files in /etc/postgresql left behind 349s ok 85 - No files in /var/lib/postgresql left behind 349s ok 86 - No files in /var/run/postgresql left behind 349s ok 87 - No files in /var/log/postgresql left behind 349s ok 88 - PostgreSQL TCP ports are closed 349s ok 89 - Next free port is 5432 349s 1..89 349s ### End test 045_backup.t ### 349s 349s ### PostgreSQL test 050_encodings.t ### 349s 1..60 349s # Checking 17 ru_RU 352s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 353s ok 2 - psql -l succeeds 353s ok 3 - template1 is not UTF-8 encoded 353s ok 4 - creating test database 353s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 353s # create table t (x varchar); copy t from stdin" test 353s ok 6 - creating table with ISO-8859-5 characters 353s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 353s ok 8 - correct string in UTF-8 353s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 353s ok 10 - correct string in ISO-8859-5 353s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 353s # delete from t; copy t from stdin" test 353s ok 12 - creating table with UTF-8 characters 353s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 353s ok 14 - correct string in UTF-8 353s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 353s ok 16 - correct string in ISO-8859-1 353s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 353s ok 18 - Server error message has correct language and encoding 356s ok 19 - pg_ctlcluster 17 ru_RU restart 356s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 357s ok 21 - Dropping cluster 357s # Checking 17 ru_RU.UTF-8 361s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 362s ok 23 - psql -l succeeds 362s ok 24 - template1 is UTF-8 encoded 362s ok 25 - creating test database 362s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 362s # create table t (x varchar); copy t from stdin" test 362s ok 27 - creating table with ISO-8859-5 characters 362s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 362s ok 29 - correct string in UTF-8 362s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 362s ok 31 - correct string in ISO-8859-5 362s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 362s # delete from t; copy t from stdin" test 362s ok 33 - creating table with UTF-8 characters 362s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 362s ok 35 - correct string in UTF-8 362s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 362s ok 37 - correct string in ISO-8859-1 362s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 362s ok 39 - Server error message has correct language and encoding 364s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 364s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 364s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 364s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 364s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 364s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 365s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 365s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 366s ok 48 - Dropping cluster 366s # Check 17 locale environment variables 369s ok 49 - pg_createcluster: LC_ALL dominates LANG 369s ok 50 - psql -Atl --cluster 17/main 369s ok 51 - template1 is ASCII encoded 371s ok 52 - Dropping cluster 371s # Cleanup 371s ok 53 - Cleanup: No clusters left behind 371s ok 54 - No postgres processes left behind 371s ok 55 - No files in /etc/postgresql left behind 371s ok 56 - No files in /var/lib/postgresql left behind 371s ok 57 - No files in /var/run/postgresql left behind 371s ok 58 - No files in /var/log/postgresql left behind 371s ok 59 - PostgreSQL TCP ports are closed 371s ok 60 - Next free port is 5432 371s ### End test 050_encodings.t ### 371s 371s ### PostgreSQL test 052_upgrade_encodings.t ### 371s 1..1 371s ok 1 - only one major version installed, skipping upgrade tests 371s ### End test 052_upgrade_encodings.t ### 371s 371s ### PostgreSQL test 060_obsolete_confparams.t ### 371s ok 1 - only one major version installed, skipping upgrade tests 371s 1..1 371s ### End test 060_obsolete_confparams.t ### 371s 371s ### PostgreSQL test 070_non_postgres_clusters.t ### 371s 1..40 372s ok 1 - pg_createcluster 17 main for owner nobody 372s ok 2 - pg_ctlcluster 17 main start 372s ok 3 - start refused when config and data owners mismatch 375s ok 4 - pg_ctlcluster succeeds with owner nobody 375s ok 5 - pg_lsclusters -h 375s ok 6 - pg_lsclusters shows running cluster 375s ok 7 - postgres is running as user nobody 375s ok 8 - ls /tmp/.s.PGSQL.* 375s ok 9 - socket is in /tmp 375s ok 10 - /var/run/postgresql is empty 375s ok 11 - conf dir is owned by user 375s ok 12 - conf dir is owned by user's primary group 375s ok 13 - files are owned by user 375s ok 14 - files are owned by user's primary group 375s ok 15 - log file has 0640 permissions 375s ok 16 - log file is owned by user 375s ok 17 - log file is owned by user's primary group 375s ok 18 - only one major version installed, skipping upgrade test 375s ok 19 - ... 375s ok 20 - ... 375s ok 21 - ... 375s ok 22 - ... 375s ok 23 - ... 375s ok 24 - ... 375s ok 25 - ... 375s ok 26 - ... 375s ok 27 - ... 375s ok 28 - ... 376s ok 29 - pg_dropcluster 376s ok 30 - pg_lsclusters -h 376s ok 31 - No clusters left 376s ok 32 - No postgres processes left 376s # Cleanup 376s ok 33 - Cleanup: No clusters left behind 376s ok 34 - No postgres processes left behind 376s ok 35 - No files in /etc/postgresql left behind 376s ok 36 - No files in /var/lib/postgresql left behind 376s ok 37 - No files in /var/run/postgresql left behind 376s ok 38 - No files in /var/log/postgresql left behind 376s ok 39 - PostgreSQL TCP ports are closed 376s ok 40 - Next free port is 5432 376s ### End test 070_non_postgres_clusters.t ### 376s 376s ### PostgreSQL test 080_start.conf.t ### 376s 1..73 377s ok 1 - pg_createcluster 17 main 377s # start.conf auto 377s ok 2 - get_cluster_start_conf returns auto 377s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 377s ok 4 - start.conf contains auto 377s ok 5 - systemd generator links cluster 377s ok 6 - systemd generator links correct service file 380s ok 7 - /etc/init.d/postgresql start 17 380s ok 8 - correct output of /etc/init.d/postgresql start 17 380s ok 9 - pg_lsclusters -h 380s ok 10 - cluster is online 380s ok 11 - /etc/init.d/postgresql stop 17 380s ok 12 - correct output of /etc/init.d/postgresql stop 17 383s ok 13 - pg_lsclusters -h 383s ok 14 - cluster is down 383s # start.conf manual 383s ok 15 - get_cluster_start_conf returns manual 383s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 383s ok 17 - start.conf contains manual 383s ok 18 - systemd generator doesn't link cluster 383s ok 19 - /etc/init.d/postgresql start 17 383s ok 20 - correct output of /etc/init.d/postgresql start 17 383s ok 21 - pg_lsclusters -h 383s ok 22 - cluster is down 385s ok 23 - pg_ctlcluster 17 main start 385s ok 24 - correct output of pg_ctlcluster 17 main start 385s ok 25 - pg_lsclusters -h 385s ok 26 - cluster is online 386s ok 27 - pg_ctlcluster 17 main stop 386s ok 28 - correct output of pg_ctlcluster 17 main stop 386s ok 29 - pg_lsclusters -h 386s ok 30 - cluster is down 386s # start.conf disabled 386s ok 31 - get_cluster_start_conf returns disabled 386s ok 32 - systemd generator doesn't link cluster 386s ok 33 - /etc/init.d/postgresql start 17 386s ok 34 - correct output of /etc/init.d/postgresql start 17 386s ok 35 - pg_lsclusters -h 386s ok 36 - cluster is down 386s ok 37 - pg_ctlcluster 17 main start 386s ok 38 - correct output of pg_ctlcluster 17 main start 386s ok 39 - pg_lsclusters -h 386s ok 40 - cluster is down 388s ok 41 - pg_ctlcluster 17 main start 388s ok 42 - correct output of pg_ctlcluster 17 main start 388s ok 43 - pg_lsclusters -h 388s ok 44 - cluster is online 388s ok 45 - pg_ctlcluster 17 main stop 388s ok 46 - correct output of pg_ctlcluster 17 main stop 389s ok 47 - pg_lsclusters -h 389s ok 48 - cluster is down 391s ok 49 - pg_ctlcluster 17 main start 391s ok 50 - correct output of pg_ctlcluster 17 main start 391s ok 51 - pg_lsclusters -h 391s ok 52 - cluster is online 391s # test upgrade 391s ok 53 - only one major version installed, skipping upgrade test 391s ok 54 - ... 391s ok 55 - get_cluster_start_conf for old cluster returns manual 391s ok 56 - get_cluster_start_conf for new cluster returns manual 391s ok 57 - ... 392s ok 58 - dropping upgraded cluster 392s ok 59 - pg_lsclusters -h 392s ok 60 - no clusters any more 392s ok 61 - pg_createcluster 17 main --start-conf foo 392s ok 62 - pg_createcluster checks --start-conf validity 393s ok 63 - pg_createcluster checks --start-conf manual 393s ok 64 - get_cluster_start_conf returns manual 394s ok 65 - dropping cluster 394s # Cleanup 394s ok 66 - Cleanup: No clusters left behind 394s ok 67 - No postgres processes left behind 394s ok 68 - No files in /etc/postgresql left behind 394s ok 69 - No files in /var/lib/postgresql left behind 394s ok 70 - No files in /var/run/postgresql left behind 394s ok 71 - No files in /var/log/postgresql left behind 394s ok 72 - PostgreSQL TCP ports are closed 394s ok 73 - Next free port is 5432 394s ### End test 080_start.conf.t ### 394s 394s ### PostgreSQL test 085_pg_ctl.conf.t ### 394s 1..33 394s ok 1 - prlimit --core=0:unlimited --pid=16934 394s ok 2 - set core file size to unlimited 394s ok 3 - sh -c 'ulimit -Hc' 394s ok 4 - core file size is unlimited 395s ok 5 - pg_createcluster 17 main 395s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 398s ok 7 - pg_ctlcluster 17 main start 398s ok 8 - starting cluster as root 398s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 398s ok 10 - soft core size is 0 398s # hard core file size limit of root-started postgres process is unlimited 398s ok 11 - set pg_ctl default option to -c 400s ok 12 - pg_ctlcluster 17 main restart 400s ok 13 - restarting cluster as root 400s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 400s ok 15 - soft core size is unlimited 400s ok 16 - pg_ctlcluster 17 main stop 400s ok 17 - stopping cluster 400s ok 18 - restored pg_ctl default option 402s ok 19 - pg_ctlcluster 17 main start -- -c 402s ok 20 - starting cluster with -c on the command line as postgres 403s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 403s ok 22 - soft core size is unlimited 403s ok 23 - pg_ctlcluster 17 main stop 403s ok 24 - stopping cluster 404s ok 25 - dropping cluster 404s # Cleanup 404s ok 26 - Cleanup: No clusters left behind 404s ok 27 - No postgres processes left behind 404s ok 28 - No files in /etc/postgresql left behind 404s ok 29 - No files in /var/lib/postgresql left behind 404s ok 30 - No files in /var/run/postgresql left behind 404s ok 31 - No files in /var/log/postgresql left behind 404s ok 32 - PostgreSQL TCP ports are closed 404s ok 33 - Next free port is 5432 404s ### End test 085_pg_ctl.conf.t ### 404s 404s ### PostgreSQL test 090_multicluster.t ### 404s 1..125 405s ok 1 - pg_createcluster 17 old 406s ok 2 - pg_createcluster 17 new1 407s ok 3 - pg_createcluster 17 new2 409s ok 4 - starting cluster 17/old 412s ok 5 - starting cluster 17/new1 414s ok 6 - starting cluster 17/new2 414s ok 7 - pg_lsclusters -h | sort -k3 414s ok 8 - clusters have the correct ports, skipping used 5433 414s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 414s ok 10 - createdb --version 414s ok 11 - pg_wrapper selects port 5432 as default cluster 414s ok 12 - createdb --cluster 17/new1 --version 414s ok 13 - pg_wrapper --cluster works 414s ok 14 - createdb --cluster 17/foo --version 414s ok 15 - pg_wrapper --cluster errors out for invalid cluster 414s ok 16 - createdb --cluster 17/new1 test 414s ok 17 - correct output of createdb --cluster 17/new1 test 414s ok 18 - psql -Atl --cluster 17/new1 414s ok 19 - test db appears in cluster new1 414s ok 20 - psql -Atl --cluster 17/new2 414s ok 21 - test db does not appear in cluster new2 414s ok 22 - psql -Atl 414s ok 23 - test db does not appear in default cluster 414s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 414s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 414s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 414s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 414s ok 28 - psql -Atl --cluster 17/localhost:5434 414s ok 29 - test db appears in cluster 17/localhost:5434 414s ok 30 - psql -Atl --cluster 17/localhost:5440 414s ok 31 - test db does not appear in cluster 17/localhost:5440 414s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 414s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 414s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 414s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 414s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 414s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 414s ok 38 - psql -Atl --cluster 6.4/localhost: 414s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 415s ok 40 - psql -Atl 415s ok 41 - PGCLUSTER selection (1) 415s ok 42 - psql -Atl 415s ok 43 - PGCLUSTER selection (2) 415s ok 44 - psql -l 415s ok 45 - invalid PGCLUSTER value 415s ok 46 - createdb --version 415s ok 47 - PGCLUSTER network cluster selection (1) 415s ok 48 - psql -Atl 415s ok 49 - PGCLUSTER network cluster selection (2) 415s ok 50 - psql -Atl 415s ok 51 - PGCLUSTER network cluster selection (3) 415s ok 52 - LC_MESSAGES=C psql -Atl 415s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 415s ok 54 - psql -Atc "show port" template1 415s ok 55 - PGPORT selection (1) 415s ok 56 - psql -Atc "show port" template1 415s ok 57 - PGPORT selection (2) 415s ok 58 - createdb --version 415s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 415s ok 60 - psql -Atc "show port" template1 415s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 415s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 415s ok 63 - PGDATABASE environment variable works 415s ok 64 - createdb --version 415s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 415s ok 66 - createdb --cluster 17/new1 --version 415s ok 67 - pg_wrapper --cluster works with empty user_clusters 415s ok 68 - createdb --version 415s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 415s ok 70 - psql -Atc "select current_database()" 415s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 415s ok 72 - psql -Atc 'select current_database()' 415s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 415s ok 74 - createdb --version 415s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 415s ok 76 - createdb --version 415s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 415s ok 78 - createdb --version 415s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 415s ok 80 - createdb --version 415s ok 81 - pg_wrapper selects correct version with per-user user_clusters 415s ok 82 - createdb --version 415s ok 83 - pg_wrapper selects correct version with per-user user_clusters 415s ok 84 - createdb --version 415s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 415s ok 86 - psql -Atl 415s ok 87 - $PGHOST overrides user_clusters 415s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 415s ok 89 - --cluster overrides $PGHOST 415s ok 90 - createdb --version 415s ok 91 - pg_wrapper ignores invalid lines in user_clusters 416s ok 92 - psql -Atc 'select current_database()' 416s ok 93 - pg_service conf selection 1 416s ok 94 - psql -Atc 'select current_database()' 416s ok 95 - pg_service conf selection 2 416s ok 96 - psql -Atc 'select current_database()' 416s ok 97 - pg_service conf selection 3 416s ok 98 - stopping cluster 17/old 418s ok 99 - restarting cluster 17/old 418s ok 100 - pg_lsclusters -h | sort -k3 418s ok 101 - port of first cluster was successfully changed 418s ok 102 - psql -l 418s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 418s ok 104 - psql -Atl --cluster 17/new1 418s ok 105 - --cluster selects appropriate cluster 418s ok 106 - psql -Atl -p 5434 418s ok 107 - -p selects appropriate cluster 418s ok 108 - psql -Atlp 5434 418s ok 109 - -Atlp selects appropriate cluster 418s ok 110 - psql -Atl --port 5434 418s ok 111 - --port selects appropriate cluster 418s ok 112 - env PGPORT=5434 psql -Atl 418s ok 113 - $PGPORT selects appropriate cluster 418s ok 114 - Restoring original /etc/postgresql-common/user_clusters 420s ok 115 - dropping 17/new1 422s ok 116 - dropping 17/new2 423s ok 117 - dropping 17/old 423s # Cleanup 423s ok 118 - Cleanup: No clusters left behind 423s ok 119 - No postgres processes left behind 423s ok 120 - No files in /etc/postgresql left behind 423s ok 121 - No files in /var/lib/postgresql left behind 423s ok 122 - No files in /var/run/postgresql left behind 423s ok 123 - No files in /var/log/postgresql left behind 423s ok 124 - PostgreSQL TCP ports are closed 423s ok 125 - Next free port is 5432 423s ### End test 090_multicluster.t ### 423s 423s ### PostgreSQL test 110_integrate_cluster.t ### 423s 1..32 424s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/ZWwy3GJaWT/c/postgres 424s ok 2 - creating raw initdb cluster for user postgres 424s ok 3 - pg_createcluster 17 postgres -d /tmp/ZWwy3GJaWT/c/postgres 424s ok 4 - integrating postgres cluster 424s ok 5 - pg_lsclusters 424s ok 6 - correct pg_lsclusters output 427s ok 7 - pg_ctlcluster 17 postgres start 427s ok 8 - starting cluster postgres 427s ok 9 - pg_lsclusters 427s ok 10 - correct pg_lsclusters output 428s ok 11 - dropping cluster postgres 428s ok 12 - No files in temporary cluster dir left behind 429s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/ZWwy3GJaWT/c/nobody 429s ok 14 - creating raw initdb cluster for user nobody 429s ok 15 - pg_createcluster 17 nobody -d /tmp/ZWwy3GJaWT/c/nobody 429s ok 16 - integrating nobody cluster 429s ok 17 - pg_lsclusters 429s ok 18 - correct pg_lsclusters output 432s ok 19 - pg_ctlcluster 17 nobody start 432s ok 20 - starting cluster nobody 432s ok 21 - pg_lsclusters 432s ok 22 - correct pg_lsclusters output 433s ok 23 - dropping cluster nobody 433s ok 24 - No files in temporary cluster dir left behind 433s # Cleanup 433s ok 25 - Cleanup: No clusters left behind 433s ok 26 - No postgres processes left behind 433s ok 27 - No files in /etc/postgresql left behind 433s ok 28 - No files in /var/lib/postgresql left behind 433s ok 29 - No files in /var/run/postgresql left behind 433s ok 30 - No files in /var/log/postgresql left behind 433s ok 31 - PostgreSQL TCP ports are closed 433s ok 32 - Next free port is 5432 433s ### End test 110_integrate_cluster.t ### 433s 433s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 433s 1..1 433s ok 1 - only one major version installed, skipping upgrade tests 433s ### End test 120_pg_upgradecluster_scripts.t ### 433s 433s ### PostgreSQL test 130_nonroot_admin.t ### 433s 1..22 436s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 436s ok 2 - pg_lsclusters -h 436s ok 3 - correct output of pg_lsclusters -h 436s ok 4 - psql -Atl 436s ok 5 - correct output of psql -Atl 437s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 437s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 437s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 437s # Cleanup 437s ok 15 - Cleanup: No clusters left behind 437s ok 16 - No postgres processes left behind 437s ok 17 - No files in /etc/postgresql left behind 437s ok 18 - No files in /var/lib/postgresql left behind 437s ok 19 - No files in /var/run/postgresql left behind 437s ok 20 - No files in /var/log/postgresql left behind 437s ok 21 - PostgreSQL TCP ports are closed 437s ok 22 - Next free port is 5432 437s ### End test 130_nonroot_admin.t ### 437s 437s ### PostgreSQL test 135_pg_virtualenv.t ### 437s 1..20 441s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 441s ok 2 - running pg_virtualenv as root 445s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 445s ok 4 - running pg_virtualenv as postgres 448s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 448s ok 6 - running pg_virtualenv as nobody 451s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 451s ok 8 - running fakeroot pg_virtualenv as root 454s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 454s ok 10 - running fakeroot pg_virtualenv as postgres 457s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 457s ok 12 - running fakeroot pg_virtualenv as nobody 457s # Cleanup 458s ok 13 - Cleanup: No clusters left behind 458s ok 14 - No postgres processes left behind 458s ok 15 - No files in /etc/postgresql left behind 458s ok 16 - No files in /var/lib/postgresql left behind 458s ok 17 - No files in /var/run/postgresql left behind 458s ok 18 - No files in /var/log/postgresql left behind 458s ok 19 - PostgreSQL TCP ports are closed 458s ok 20 - Next free port is 5432 458s ### End test 135_pg_virtualenv.t ### 458s 458s ### PostgreSQL test 140_pg_config.t ### 458s 1..38 458s # Multiarch is enabled 458s # checking version specific output for 17 458s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 458s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 458s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 458s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 458s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 458s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 458s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 458s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 458s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 458s # checking pg_config output (should behave like version 17) 458s ok 15 - pg_config 458s ok 16 - correct output of pg_config 458s ok 17 - pg_config --help 458s ok 18 - correct output of pg_config --help 458s ok 19 - pg_config --pgxs 458s ok 20 - correct output of pg_config --pgxs 458s ok 21 - pg_config --libdir 458s ok 22 - correct output of pg_config --libdir 458s ok 23 - pg_config --pkglibdir 458s ok 24 - correct output of pg_config --pkglibdir 458s ok 25 - pg_config --bindir 458s ok 26 - correct output of pg_config --bindir 458s # checking pg_config.libpq-dev output (should behave like version 17) 458s ok 27 - pg_config.libpq-dev 458s ok 28 - correct output of pg_config.libpq-dev 458s ok 29 - pg_config.libpq-dev --help 458s ok 30 - correct output of pg_config.libpq-dev --help 458s ok 31 - pg_config.libpq-dev --pgxs 458s ok 32 - correct output of pg_config.libpq-dev --pgxs 458s ok 33 - pg_config.libpq-dev --libdir 458s ok 34 - correct output of pg_config.libpq-dev --libdir 458s ok 35 - pg_config.libpq-dev --pkglibdir 458s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 458s ok 37 - pg_config.libpq-dev --bindir 458s ok 38 - correct output of pg_config.libpq-dev --bindir 458s ### End test 140_pg_config.t ### 458s 458s ### PostgreSQL test 150_tsearch_stemming.t ### 458s 1..37 458s ok 1 - pg_updatedicts succeeded 458s ok 2 - pg_updatedicts created en_us.affix 458s ok 3 - pg_updatedicts created en_us.dict 458s ok 4 - pg_updatedicts created 17 en_us.affix symlink 458s ok 5 - pg_updatedicts created 17 en_us.dict symlink 462s ok 6 - pg_createcluster 17 main 462s ok 7 - createdb fts 462s ok 8 - correct output of createdb fts 462s ok 9 - creating en_US full text search configuration 462s ok 10 - creating data table and search index 462s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 462s ok 12 - stem search of correct word 462s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 462s ok 14 - stem search of correct word 462s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 462s ok 16 - stem search of unknown word 462s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 462s ok 18 - full text search, exact word 462s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 462s ok 20 - full text search for word stem 462s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 462s ok 22 - full text search for word substring fails 462s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 462s ok 24 - full text search, exact unicode word 462s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 462s ok 26 - full text search for unicode word stem 462s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 462s ok 28 - full text search for unicode word substring fails 464s ok 29 464s # Cleanup 464s ok 30 - Cleanup: No clusters left behind 464s ok 31 - No postgres processes left behind 464s ok 32 - No files in /etc/postgresql left behind 464s ok 33 - No files in /var/lib/postgresql left behind 464s ok 34 - No files in /var/run/postgresql left behind 464s ok 35 - No files in /var/log/postgresql left behind 464s ok 36 - PostgreSQL TCP ports are closed 464s ok 37 - Next free port is 5432 464s ### End test 150_tsearch_stemming.t ### 464s 464s ### PostgreSQL test 160_alternate_confroot.t ### 464s 1..28 468s ok 1 468s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 468s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 468s ok 4 - pg_lsclusters -h 468s ok 5 - correct output of pg_lsclusters -h 468s ok 6 - psql -Atl 468s ok 7 - correct output of psql -Atl 468s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 468s ok 9 - ... 468s ok 10 - ... 468s ok 11 - ... 468s ok 12 - ... 468s ok 13 - ... 468s ok 14 - ... 468s ok 15 - pg_dropcluster 17 test --stop 468s ok 16 - correct output of pg_dropcluster 17 test --stop 468s ok 17 - pg_lsclusters -h 468s ok 18 - correct output of pg_lsclusters -h 468s ok 19 - No files in root/data left behind 468s ok 20 - No cruft in root dir left behind 468s # Cleanup 468s ok 21 - Cleanup: No clusters left behind 468s ok 22 - No postgres processes left behind 468s ok 23 - No files in /etc/postgresql left behind 468s ok 24 - No files in /var/lib/postgresql left behind 468s ok 25 - No files in /var/run/postgresql left behind 468s ok 26 - No files in /var/log/postgresql left behind 468s ok 27 - PostgreSQL TCP ports are closed 468s ok 28 - Next free port is 5432 468s ### End test 160_alternate_confroot.t ### 468s 468s ### PostgreSQL test 170_extensions.t ### 468s # Running tests for 17 471s ok 1 - pg_createcluster 17 main 471s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 471s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 471s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 471s ok 5 - extension amcheck installs without error 471s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 471s ok 7 - extension amcheck removes without error 471s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 471s ok 9 - extension autoinc installs without error 471s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 471s ok 11 - extension autoinc removes without error 471s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 471s ok 13 - extension bloom installs without error 471s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 471s ok 15 - extension bloom removes without error 471s ok 16 - psql -qc 'CREATE EXTENSION plperl' 471s ok 17 - bool_plperl dependency plperl installs without error 471s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 471s ok 19 - extension bool_plperl installs without error 471s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 471s ok 21 - extension bool_plperl removes without error 471s ok 22 - psql -qc 'DROP EXTENSION plperl' 471s ok 23 - bool_plperl dependency extension plperl removes without error 471s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 471s ok 25 - bool_plperlu dependency plperlu installs without error 471s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 471s ok 27 - extension bool_plperlu installs without error 471s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 471s ok 29 - extension bool_plperlu removes without error 471s ok 30 - psql -qc 'DROP EXTENSION plperlu' 471s ok 31 - bool_plperlu dependency extension plperlu removes without error 471s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 471s ok 33 - extension btree_gin installs without error 472s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 472s ok 35 - extension btree_gin removes without error 472s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 472s ok 37 - extension btree_gist installs without error 472s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 472s ok 39 - extension btree_gist removes without error 472s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 472s ok 41 - extension citext installs without error 472s ok 42 - psql -qc 'DROP EXTENSION "citext"' 472s ok 43 - extension citext removes without error 472s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 472s ok 45 - extension cube installs without error 472s ok 46 - psql -qc 'DROP EXTENSION "cube"' 472s ok 47 - extension cube removes without error 472s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 472s ok 49 - extension dblink installs without error 472s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 472s ok 51 - extension dblink removes without error 472s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 472s ok 53 - extension dict_int installs without error 472s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 472s ok 55 - extension dict_int removes without error 472s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 472s ok 57 - extension dict_xsyn installs without error 472s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 472s ok 59 - extension dict_xsyn removes without error 472s ok 60 - psql -qc 'CREATE EXTENSION cube' 472s ok 61 - earthdistance dependency cube installs without error 472s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 472s ok 63 - extension earthdistance installs without error 472s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 472s ok 65 - extension earthdistance removes without error 472s ok 66 - psql -qc 'DROP EXTENSION cube' 472s ok 67 - earthdistance dependency extension cube removes without error 472s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 472s ok 69 - extension file_fdw installs without error 472s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 472s ok 71 - extension file_fdw removes without error 472s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 472s ok 73 - extension fuzzystrmatch installs without error 472s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 472s ok 75 - extension fuzzystrmatch removes without error 472s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 472s ok 77 - extension hstore installs without error 473s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 473s ok 79 - extension hstore removes without error 473s ok 80 - psql -qc 'CREATE EXTENSION hstore' 473s ok 81 - hstore_plperl dependency hstore installs without error 473s ok 82 - psql -qc 'CREATE EXTENSION plperl' 473s ok 83 - hstore_plperl dependency plperl installs without error 473s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 473s ok 85 - extension hstore_plperl installs without error 473s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 473s ok 87 - extension hstore_plperl removes without error 473s ok 88 - psql -qc 'DROP EXTENSION hstore' 473s ok 89 - hstore_plperl dependency extension hstore removes without error 473s ok 90 - psql -qc 'DROP EXTENSION plperl' 473s ok 91 - hstore_plperl dependency extension plperl removes without error 473s ok 92 - psql -qc 'CREATE EXTENSION hstore' 473s ok 93 - hstore_plperlu dependency hstore installs without error 473s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 473s ok 95 - hstore_plperlu dependency plperlu installs without error 473s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 473s ok 97 - extension hstore_plperlu installs without error 473s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 473s ok 99 - extension hstore_plperlu removes without error 473s ok 100 - psql -qc 'DROP EXTENSION hstore' 473s ok 101 - hstore_plperlu dependency extension hstore removes without error 473s ok 102 - psql -qc 'DROP EXTENSION plperlu' 473s ok 103 - hstore_plperlu dependency extension plperlu removes without error 473s ok 104 - psql -qc 'CREATE EXTENSION hstore' 473s ok 105 - hstore_plpython3u dependency hstore installs without error 473s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 473s ok 107 - hstore_plpython3u dependency plpython3u installs without error 473s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 473s ok 109 - extension hstore_plpython3u installs without error 473s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 473s ok 111 - extension hstore_plpython3u removes without error 473s ok 112 - psql -qc 'DROP EXTENSION hstore' 473s ok 113 - hstore_plpython3u dependency extension hstore removes without error 473s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 473s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 473s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 473s ok 117 - extension insert_username installs without error 473s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 473s ok 119 - extension insert_username removes without error 473s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 473s ok 121 - extension intagg installs without error 474s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 474s ok 123 - extension intagg removes without error 474s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 474s ok 125 - extension intarray installs without error 474s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 474s ok 127 - extension intarray removes without error 474s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 474s ok 129 - extension isn installs without error 474s ok 130 - psql -qc 'DROP EXTENSION "isn"' 474s ok 131 - extension isn removes without error 474s ok 132 - psql -qc 'CREATE EXTENSION plperl' 474s ok 133 - jsonb_plperl dependency plperl installs without error 474s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 474s ok 135 - extension jsonb_plperl installs without error 474s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 474s ok 137 - extension jsonb_plperl removes without error 474s ok 138 - psql -qc 'DROP EXTENSION plperl' 474s ok 139 - jsonb_plperl dependency extension plperl removes without error 474s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 474s ok 141 - jsonb_plperlu dependency plperlu installs without error 474s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 474s ok 143 - extension jsonb_plperlu installs without error 474s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 474s ok 145 - extension jsonb_plperlu removes without error 474s ok 146 - psql -qc 'DROP EXTENSION plperlu' 474s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 474s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 474s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 474s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 474s ok 151 - extension jsonb_plpython3u installs without error 474s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 474s ok 153 - extension jsonb_plpython3u removes without error 474s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 474s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 474s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 474s ok 157 - extension lo installs without error 474s ok 158 - psql -qc 'DROP EXTENSION "lo"' 474s ok 159 - extension lo removes without error 474s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 474s ok 161 - extension ltree installs without error 475s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 475s ok 163 - extension ltree removes without error 475s ok 164 - psql -qc 'CREATE EXTENSION ltree' 475s ok 165 - ltree_plpython3u dependency ltree installs without error 475s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 475s ok 167 - ltree_plpython3u dependency plpython3u installs without error 475s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 475s ok 169 - extension ltree_plpython3u installs without error 475s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 475s ok 171 - extension ltree_plpython3u removes without error 475s ok 172 - psql -qc 'DROP EXTENSION ltree' 475s ok 173 - ltree_plpython3u dependency extension ltree removes without error 475s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 475s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 475s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 475s ok 177 - extension moddatetime installs without error 475s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 475s ok 179 - extension moddatetime removes without error 475s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 475s ok 181 - extension pageinspect installs without error 475s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 475s ok 183 - extension pageinspect removes without error 475s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 475s ok 185 - extension pg_buffercache installs without error 475s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 475s ok 187 - extension pg_buffercache removes without error 475s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 475s ok 189 - extension pg_freespacemap installs without error 475s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 475s ok 191 - extension pg_freespacemap removes without error 475s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 475s ok 193 - extension pg_prewarm installs without error 475s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 475s ok 195 - extension pg_prewarm removes without error 475s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 475s ok 197 - extension pg_stat_statements installs without error 475s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 475s ok 199 - extension pg_stat_statements removes without error 475s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 475s ok 201 - extension pg_surgery installs without error 475s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 475s ok 203 - extension pg_surgery removes without error 475s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 475s ok 205 - extension pg_trgm installs without error 475s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 475s ok 207 - extension pg_trgm removes without error 475s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 475s ok 209 - extension pg_visibility installs without error 476s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 476s ok 211 - extension pg_visibility removes without error 476s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 476s ok 213 - extension pg_walinspect installs without error 476s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 476s ok 215 - extension pg_walinspect removes without error 476s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 476s ok 217 - extension pgcrypto installs without error 476s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 476s ok 219 - extension pgcrypto removes without error 476s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 476s ok 221 - extension pgrowlocks installs without error 476s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 476s ok 223 - extension pgrowlocks removes without error 476s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 476s ok 225 - extension pgstattuple installs without error 476s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 476s ok 227 - extension pgstattuple removes without error 476s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 476s ok 229 - extension plperl installs without error 476s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 476s ok 231 - extension plperl removes without error 476s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 476s ok 233 - extension plperlu installs without error 476s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 476s ok 235 - extension plperlu removes without error 476s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 476s ok 237 - extension plpython3u installs without error 476s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 476s ok 239 - extension plpython3u removes without error 476s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 476s ok 241 - extension pltcl installs without error 476s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 476s ok 243 - extension pltcl removes without error 476s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 476s ok 245 - extension pltclu installs without error 476s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 476s ok 247 - extension pltclu removes without error 476s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 476s ok 249 - extension postgres_fdw installs without error 476s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 476s ok 251 - extension postgres_fdw removes without error 476s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 476s ok 253 - extension refint installs without error 476s ok 254 - psql -qc 'DROP EXTENSION "refint"' 476s ok 255 - extension refint removes without error 477s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 477s ok 257 - extension seg installs without error 477s ok 258 - psql -qc 'DROP EXTENSION "seg"' 477s ok 259 - extension seg removes without error 477s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 477s ok 261 - extension sslinfo installs without error 477s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 477s ok 263 - extension sslinfo removes without error 477s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 477s ok 265 - extension tablefunc installs without error 477s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 477s ok 267 - extension tablefunc removes without error 477s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 477s ok 269 - extension tcn installs without error 477s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 477s ok 271 - extension tcn removes without error 477s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 477s ok 273 - extension tsm_system_rows installs without error 477s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 477s ok 275 - extension tsm_system_rows removes without error 477s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 477s ok 277 - extension tsm_system_time installs without error 477s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 477s ok 279 - extension tsm_system_time removes without error 477s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 477s ok 281 - extension unaccent installs without error 477s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 477s ok 283 - extension unaccent removes without error 477s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 477s ok 285 - extension uuid-ossp installs without error 477s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 477s ok 287 - extension uuid-ossp removes without error 477s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 477s ok 289 - extension xml2 installs without error 477s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 477s ok 291 - extension xml2 removes without error 479s ok 292 - pg_dropcluster 17 main 479s # Cleanup 479s ok 293 - Cleanup: No clusters left behind 479s ok 294 - No postgres processes left behind 479s ok 295 - No files in /etc/postgresql left behind 479s ok 296 - No files in /var/lib/postgresql left behind 479s ok 297 - No files in /var/run/postgresql left behind 479s ok 298 - No files in /var/log/postgresql left behind 479s ok 299 - PostgreSQL TCP ports are closed 479s ok 300 - Next free port is 5432 479s 1..300 479s ### End test 170_extensions.t ### 479s 479s ### PostgreSQL test 180_ecpg.t ### 479s 1..14 479s ok 1 - ecpg test.pgc 479s ok 2 - ecpg processing 479s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 479s ok 4 - compiling ecpg output 486s ok 5 - pg_virtualenv /tmp/tmp.boHoxPCWWe/test 486s ok 6 - test program runs and gives correct output 486s # Cleanup 486s ok 7 - Cleanup: No clusters left behind 486s ok 8 - No postgres processes left behind 486s ok 9 - No files in /etc/postgresql left behind 486s ok 10 - No files in /var/lib/postgresql left behind 486s ok 11 - No files in /var/run/postgresql left behind 486s ok 12 - No files in /var/log/postgresql left behind 486s ok 13 - PostgreSQL TCP ports are closed 486s ok 14 - Next free port is 5432 486s ### End test 180_ecpg.t ### 486s 486s ### PostgreSQL test 190_pg_buildext.t ### 486s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 486s 1..1 486s ### End test 190_pg_buildext.t ### 486s 486s ### PostgreSQL test 200_maintscripts.t ### 487s 1..15 487s # We are running systemd 490s ok 1 - pg_createcluster 17 main --start 490s ok 2 - postmaster PID is 21953 491s ok 3 - apt-get update -q 491s # postgresql-common: 491s # Installed: 274 491s # Candidate: 274 491s # Version table: 491s # *** 274 500 491s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 491s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 491s # 100 /var/lib/dpkg/status 494s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 494s # postgresql-common: 494s # Installed: 274 494s # Candidate: 274 494s # Version table: 494s # *** 274 500 494s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 494s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 494s # 100 /var/lib/dpkg/status 494s ok 5 - postmaster PID is 21953 494s ok 6 - postmaster was not restarted 496s ok 7 - pg_dropcluster 17 main --stop 496s # Cleanup 496s ok 8 - Cleanup: No clusters left behind 496s ok 9 - No postgres processes left behind 496s ok 10 - No files in /etc/postgresql left behind 496s ok 11 - No files in /var/lib/postgresql left behind 496s ok 12 - No files in /var/run/postgresql left behind 496s ok 13 - No files in /var/log/postgresql left behind 496s ok 14 - PostgreSQL TCP ports are closed 496s ok 15 - Next free port is 5432 496s ### End test 200_maintscripts.t ### 496s 496s autopkgtest [18:44:43]: test run-testsuite: -----------------------] 497s run-testsuite PASS 497s autopkgtest [18:44:44]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 497s autopkgtest [18:44:44]: test installcheck: preparing testbed 567s autopkgtest [18:45:54]: testbed dpkg architecture: amd64 567s autopkgtest [18:45:54]: testbed apt version: 3.0.0 567s autopkgtest [18:45:54]: @@@@@@@@@@@@@@@@@@@@ test bed setup 567s autopkgtest [18:45:54]: testbed release detected to be: plucky 568s autopkgtest [18:45:55]: updating testbed package index (apt update) 568s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 569s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 569s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 569s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 569s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 569s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [5776 B] 569s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [3700 B] 569s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 c-n-f Metadata [288 B] 569s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 c-n-f Metadata [232 B] 569s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [14.8 kB] 569s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [17.3 kB] 569s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 c-n-f Metadata [9496 B] 569s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 c-n-f Metadata [440 B] 569s Fetched 322 kB in 1s (447 kB/s) 570s Reading package lists... 571s autopkgtest [18:45:58]: upgrading testbed (apt dist-upgrade and autopurge) 571s Reading package lists... 571s Building dependency tree... 571s Reading state information... 571s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 571s Starting 2 pkgProblemResolver with broken count: 0 571s Done 572s Entering ResolveByKeep 572s 572s Calculating upgrade... 572s The following packages will be upgraded: 572s tzdata 572s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 572s Need to get 198 kB of archives. 572s After this operation, 0 B of additional disk space will be used. 572s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 tzdata all 2025b-1ubuntu1.1 [198 kB] 573s Preconfiguring packages ... 573s Fetched 198 kB in 0s (580 kB/s) 573s (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 ... 80514 files and directories currently installed.) 573s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 573s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 573s Setting up tzdata (2025b-1ubuntu1.1) ... 573s 573s Current default time zone: 'Etc/UTC' 573s Local time is now: Tue May 6 18:46:00 UTC 2025. 573s Universal Time is now: Tue May 6 18:46:00 UTC 2025. 573s Run 'dpkg-reconfigure tzdata' if you wish to change it. 573s 573s Reading package lists... 574s Building dependency tree... 574s Reading state information... 574s Starting pkgProblemResolver with broken count: 0 574s Starting 2 pkgProblemResolver with broken count: 0 574s Done 574s Solving dependencies... 574s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 577s Reading package lists... 577s Building dependency tree... 577s Reading state information... 578s Starting pkgProblemResolver with broken count: 0 578s Starting 2 pkgProblemResolver with broken count: 0 578s Done 578s The following NEW packages will be installed: 578s binutils-gold binutils-gold-x86-64-linux-gnu build-essential clang-20 cpp 578s cpp-14 cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu g++ g++-14 578s g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 578s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 578s libclang-common-20-dev libclang-cpp20 libclang1-20 libffi-dev libgc1 578s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 578s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 578s libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev 578s libstdc++-14-dev libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 578s llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 578s postgresql-client-17 postgresql-client-common postgresql-common 578s postgresql-common-dev postgresql-server-dev-17 ssl-cert tzdata-legacy 578s 0 upgraded, 60 newly installed, 0 to remove and 0 not upgraded. 578s Need to get 219 MB of archives. 578s After this operation, 1073 MB of additional disk space will be used. 578s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 578s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 274 [47.6 kB] 578s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 578s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 578s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common-dev all 274 [73.0 kB] 578s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 578s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 274 [101 kB] 578s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 binutils-gold-x86-64-linux-gnu amd64 2.44-2 [1278 kB] 579s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 binutils-gold amd64 2.44-2 [2208 B] 579s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libisl23 amd64 0.27-1 [685 kB] 579s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 579s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [11.9 MB] 579s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14 amd64 14.2.0-19ubuntu2 [1030 B] 579s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [5586 B] 579s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp amd64 4:14.2.0-1ubuntu1 [22.4 kB] 579s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 libcc1-0 amd64 15-20250404-0ubuntu1 [47.1 kB] 579s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 libgomp1 amd64 15-20250404-0ubuntu1 [151 kB] 579s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libitm1 amd64 15-20250404-0ubuntu1 [29.5 kB] 579s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 libasan8 amd64 15-20250404-0ubuntu1 [3076 kB] 579s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 liblsan0 amd64 15-20250404-0ubuntu1 [1362 kB] 579s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 libtsan2 amd64 15-20250404-0ubuntu1 [2760 kB] 579s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 libubsan1 amd64 15-20250404-0ubuntu1 [1211 kB] 579s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 libhwasan0 amd64 15-20250404-0ubuntu1 [1687 kB] 579s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 libquadmath0 amd64 15-20250404-0ubuntu1 [153 kB] 579s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 libgcc-14-dev amd64 14.2.0-19ubuntu2 [2815 kB] 579s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [23.3 MB] 580s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14 amd64 14.2.0-19ubuntu2 [540 kB] 580s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [1208 B] 580s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc amd64 4:14.2.0-1ubuntu1 [5004 B] 580s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 libstdc++-14-dev amd64 14.2.0-19ubuntu2 [2510 kB] 580s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [13.4 MB] 580s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14 amd64 14.2.0-19ubuntu2 [23.0 kB] 580s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [968 B] 580s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 g++ amd64 4:14.2.0-1ubuntu1 [1100 B] 580s Get:35 http://ftpmaster.internal/ubuntu plucky/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 580s Get:36 http://ftpmaster.internal/ubuntu plucky/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 581s Get:37 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-cpp20 amd64 1:20.1.2-0ubuntu1 [14.2 MB] 581s Get:38 http://ftpmaster.internal/ubuntu plucky/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 581s Get:39 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc4 amd64 15-20250404-0ubuntu1 [47.8 kB] 581s Get:40 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc-14-dev amd64 14.2.0-19ubuntu2 [195 kB] 581s Get:41 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-common-20-dev amd64 1:20.1.2-0ubuntu1 [782 kB] 581s Get:42 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-linker-tools amd64 1:20.1.2-0ubuntu1 [1337 kB] 581s Get:43 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang1-20 amd64 1:20.1.2-0ubuntu1 [8255 kB] 582s Get:44 http://ftpmaster.internal/ubuntu plucky/universe amd64 clang-20 amd64 1:20.1.2-0ubuntu1 [77.6 kB] 582s Get:45 http://ftpmaster.internal/ubuntu plucky/main amd64 libncurses-dev amd64 6.5+20250216-2 [424 kB] 582s Get:46 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.4-1 [155 kB] 582s Get:47 http://ftpmaster.internal/ubuntu plucky/main amd64 libssl-dev amd64 3.4.1-1ubuntu3 [2872 kB] 582s Get:48 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq-dev amd64 17.4-1 [158 kB] 582s Get:49 http://ftpmaster.internal/ubuntu plucky-updates/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [785 kB] 582s Get:50 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 582s Get:51 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-runtime amd64 1:20.1.2-0ubuntu1 [560 kB] 582s Get:52 http://ftpmaster.internal/ubuntu plucky/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 582s Get:53 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20 amd64 1:20.1.2-0ubuntu1 [19.7 MB] 582s Get:54 http://ftpmaster.internal/ubuntu plucky/main amd64 libffi-dev amd64 3.4.7-1 [65.5 kB] 582s Get:55 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-tools amd64 1:20.1.2-0ubuntu1 [513 kB] 582s Get:56 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-20-dev amd64 1:20.1.2-0ubuntu1 [50.5 MB] 583s Get:57 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 583s Get:58 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 584s Get:59 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-17 amd64 17.4-1 [1417 kB] 584s Get:60 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 tzdata-legacy all 2025b-1ubuntu1.1 [99.2 kB] 584s Preconfiguring packages ... 584s Fetched 219 MB in 6s (36.9 MB/s) 584s Selecting previously unselected package libjson-perl. 584s (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 ... 80514 files and directories currently installed.) 584s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 584s Unpacking libjson-perl (4.10000-1) ... 584s Selecting previously unselected package postgresql-client-common. 584s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 584s Unpacking postgresql-client-common (274) ... 584s Selecting previously unselected package libio-pty-perl. 584s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 584s Unpacking libio-pty-perl (1:1.20-1build3) ... 584s Selecting previously unselected package libipc-run-perl. 584s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 584s Unpacking libipc-run-perl (20231003.0-2) ... 584s Selecting previously unselected package postgresql-common-dev. 584s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 584s Unpacking postgresql-common-dev (274) ... 584s Selecting previously unselected package ssl-cert. 584s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 584s Unpacking ssl-cert (1.1.3ubuntu1) ... 584s Selecting previously unselected package postgresql-common. 584s Preparing to unpack .../06-postgresql-common_274_all.deb ... 584s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 584s Unpacking postgresql-common (274) ... 584s Selecting previously unselected package binutils-gold-x86-64-linux-gnu. 584s Preparing to unpack .../07-binutils-gold-x86-64-linux-gnu_2.44-2_amd64.deb ... 584s Unpacking binutils-gold-x86-64-linux-gnu (2.44-2) ... 584s Selecting previously unselected package binutils-gold. 584s Preparing to unpack .../08-binutils-gold_2.44-2_amd64.deb ... 584s Unpacking binutils-gold (2.44-2) ... 584s Selecting previously unselected package libisl23:amd64. 584s Preparing to unpack .../09-libisl23_0.27-1_amd64.deb ... 584s Unpacking libisl23:amd64 (0.27-1) ... 585s Selecting previously unselected package libmpc3:amd64. 585s Preparing to unpack .../10-libmpc3_1.3.1-1build2_amd64.deb ... 585s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 585s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 585s Preparing to unpack .../11-cpp-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 585s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 585s Selecting previously unselected package cpp-14. 585s Preparing to unpack .../12-cpp-14_14.2.0-19ubuntu2_amd64.deb ... 585s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 585s Selecting previously unselected package cpp-x86-64-linux-gnu. 585s Preparing to unpack .../13-cpp-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 585s Unpacking cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 585s Selecting previously unselected package cpp. 585s Preparing to unpack .../14-cpp_4%3a14.2.0-1ubuntu1_amd64.deb ... 585s Unpacking cpp (4:14.2.0-1ubuntu1) ... 585s Selecting previously unselected package libcc1-0:amd64. 585s Preparing to unpack .../15-libcc1-0_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libcc1-0:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libgomp1:amd64. 585s Preparing to unpack .../16-libgomp1_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libgomp1:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libitm1:amd64. 585s Preparing to unpack .../17-libitm1_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libitm1:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libasan8:amd64. 585s Preparing to unpack .../18-libasan8_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libasan8:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package liblsan0:amd64. 585s Preparing to unpack .../19-liblsan0_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking liblsan0:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libtsan2:amd64. 585s Preparing to unpack .../20-libtsan2_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libtsan2:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libubsan1:amd64. 585s Preparing to unpack .../21-libubsan1_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libubsan1:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libhwasan0:amd64. 585s Preparing to unpack .../22-libhwasan0_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libhwasan0:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libquadmath0:amd64. 585s Preparing to unpack .../23-libquadmath0_15-20250404-0ubuntu1_amd64.deb ... 585s Unpacking libquadmath0:amd64 (15-20250404-0ubuntu1) ... 585s Selecting previously unselected package libgcc-14-dev:amd64. 585s Preparing to unpack .../24-libgcc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 585s Unpacking libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 585s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 585s Preparing to unpack .../25-gcc-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 585s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 586s Selecting previously unselected package gcc-14. 586s Preparing to unpack .../26-gcc-14_14.2.0-19ubuntu2_amd64.deb ... 586s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 586s Selecting previously unselected package gcc-x86-64-linux-gnu. 586s Preparing to unpack .../27-gcc-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 586s Unpacking gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 586s Selecting previously unselected package gcc. 586s Preparing to unpack .../28-gcc_4%3a14.2.0-1ubuntu1_amd64.deb ... 586s Unpacking gcc (4:14.2.0-1ubuntu1) ... 586s Selecting previously unselected package libstdc++-14-dev:amd64. 586s Preparing to unpack .../29-libstdc++-14-dev_14.2.0-19ubuntu2_amd64.deb ... 586s Unpacking libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 586s Selecting previously unselected package g++-14-x86-64-linux-gnu. 586s Preparing to unpack .../30-g++-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 586s Unpacking g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 586s Selecting previously unselected package g++-14. 586s Preparing to unpack .../31-g++-14_14.2.0-19ubuntu2_amd64.deb ... 586s Unpacking g++-14 (14.2.0-19ubuntu2) ... 586s Selecting previously unselected package g++-x86-64-linux-gnu. 586s Preparing to unpack .../32-g++-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 586s Unpacking g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 586s Selecting previously unselected package g++. 586s Preparing to unpack .../33-g++_4%3a14.2.0-1ubuntu1_amd64.deb ... 586s Unpacking g++ (4:14.2.0-1ubuntu1) ... 586s Selecting previously unselected package build-essential. 586s Preparing to unpack .../34-build-essential_12.12ubuntu1_amd64.deb ... 586s Unpacking build-essential (12.12ubuntu1) ... 586s Selecting previously unselected package libllvm20:amd64. 586s Preparing to unpack .../35-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 586s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package libclang-cpp20. 587s Preparing to unpack .../36-libclang-cpp20_1%3a20.1.2-0ubuntu1_amd64.deb ... 587s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package libgc1:amd64. 587s Preparing to unpack .../37-libgc1_1%3a8.2.8-1_amd64.deb ... 587s Unpacking libgc1:amd64 (1:8.2.8-1) ... 587s Selecting previously unselected package libobjc4:amd64. 587s Preparing to unpack .../38-libobjc4_15-20250404-0ubuntu1_amd64.deb ... 587s Unpacking libobjc4:amd64 (15-20250404-0ubuntu1) ... 587s Selecting previously unselected package libobjc-14-dev:amd64. 587s Preparing to unpack .../39-libobjc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 587s Unpacking libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 587s Selecting previously unselected package libclang-common-20-dev:amd64. 587s Preparing to unpack .../40-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 587s Unpacking libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package llvm-20-linker-tools. 587s Preparing to unpack .../41-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 587s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package libclang1-20. 587s Preparing to unpack .../42-libclang1-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 587s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package clang-20. 587s Preparing to unpack .../43-clang-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 587s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 587s Selecting previously unselected package libncurses-dev:amd64. 587s Preparing to unpack .../44-libncurses-dev_6.5+20250216-2_amd64.deb ... 587s Unpacking libncurses-dev:amd64 (6.5+20250216-2) ... 587s Selecting previously unselected package libpq5:amd64. 587s Preparing to unpack .../45-libpq5_17.4-1_amd64.deb ... 587s Unpacking libpq5:amd64 (17.4-1) ... 587s Selecting previously unselected package libssl-dev:amd64. 587s Preparing to unpack .../46-libssl-dev_3.4.1-1ubuntu3_amd64.deb ... 587s Unpacking libssl-dev:amd64 (3.4.1-1ubuntu3) ... 588s Selecting previously unselected package libpq-dev. 588s Preparing to unpack .../47-libpq-dev_17.4-1_amd64.deb ... 588s Unpacking libpq-dev (17.4-1) ... 588s Selecting previously unselected package libxml2-dev:amd64. 588s Preparing to unpack .../48-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_amd64.deb ... 588s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 588s Selecting previously unselected package libxslt1.1:amd64. 588s Preparing to unpack .../49-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 588s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 588s Selecting previously unselected package llvm-20-runtime. 588s Preparing to unpack .../50-llvm-20-runtime_1%3a20.1.2-0ubuntu1_amd64.deb ... 588s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 588s Selecting previously unselected package libpfm4:amd64. 588s Preparing to unpack .../51-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 588s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 588s Selecting previously unselected package llvm-20. 588s Preparing to unpack .../52-llvm-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 588s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 588s Selecting previously unselected package libffi-dev:amd64. 588s Preparing to unpack .../53-libffi-dev_3.4.7-1_amd64.deb ... 588s Unpacking libffi-dev:amd64 (3.4.7-1) ... 588s Selecting previously unselected package llvm-20-tools. 588s Preparing to unpack .../54-llvm-20-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 588s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 588s Selecting previously unselected package llvm-20-dev. 588s Preparing to unpack .../55-llvm-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 588s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 590s Selecting previously unselected package postgresql-client-17. 590s Preparing to unpack .../56-postgresql-client-17_17.4-1_amd64.deb ... 590s Unpacking postgresql-client-17 (17.4-1) ... 590s Selecting previously unselected package postgresql-17. 590s Preparing to unpack .../57-postgresql-17_17.4-1_amd64.deb ... 590s Unpacking postgresql-17 (17.4-1) ... 590s Selecting previously unselected package postgresql-server-dev-17. 590s Preparing to unpack .../58-postgresql-server-dev-17_17.4-1_amd64.deb ... 590s Unpacking postgresql-server-dev-17 (17.4-1) ... 590s Selecting previously unselected package tzdata-legacy. 590s Preparing to unpack .../59-tzdata-legacy_2025b-1ubuntu1.1_all.deb ... 590s Unpacking tzdata-legacy (2025b-1ubuntu1.1) ... 590s Setting up postgresql-client-common (274) ... 590s Setting up binutils-gold-x86-64-linux-gnu (2.44-2) ... 590s Setting up libncurses-dev:amd64 (6.5+20250216-2) ... 590s Setting up libio-pty-perl (1:1.20-1build3) ... 590s Setting up binutils-gold (2.44-2) ... 590s Setting up libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 590s Setting up libpq5:amd64 (17.4-1) ... 590s Setting up libgomp1:amd64 (15-20250404-0ubuntu1) ... 590s Setting up libffi-dev:amd64 (3.4.7-1) ... 590s Setting up tzdata-legacy (2025b-1ubuntu1.1) ... 590s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 590s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 590s Setting up ssl-cert (1.1.3ubuntu1) ... 591s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 591s Setting up libquadmath0:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libssl-dev:amd64 (3.4.1-1ubuntu3) ... 591s Setting up libmpc3:amd64 (1.3.1-1build2) ... 591s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 591s Setting up libipc-run-perl (20231003.0-2) ... 591s Setting up libgc1:amd64 (1:8.2.8-1) ... 591s Setting up libubsan1:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libhwasan0:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libasan8:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libjson-perl (4.10000-1) ... 591s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 591s Setting up libtsan2:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libisl23:amd64 (0.27-1) ... 591s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 591s Setting up libcc1-0:amd64 (15-20250404-0ubuntu1) ... 591s Setting up liblsan0:amd64 (15-20250404-0ubuntu1) ... 591s Setting up libitm1:amd64 (15-20250404-0ubuntu1) ... 591s Setting up postgresql-common-dev (274) ... 591s Setting up postgresql-client-17 (17.4-1) ... 591s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 591s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 591s Setting up libpq-dev (17.4-1) ... 591s Setting up libobjc4:amd64 (15-20250404-0ubuntu1) ... 591s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 592s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 592s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 592s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 592s Setting up postgresql-common (274) ... 592s Creating config file /etc/postgresql-common/createcluster.conf with new version 592s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 592s Removing obsolete dictionary files: 593s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 593s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 593s Setting up cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 593s Setting up cpp-14 (14.2.0-19ubuntu2) ... 593s Setting up libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 593s Setting up libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 593s Setting up cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 593s Setting up postgresql-17 (17.4-1) ... 594s Creating new PostgreSQL cluster 17/main ... 594s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 594s The files belonging to this database system will be owned by user "postgres". 594s This user must also own the server process. 594s 594s The database cluster will be initialized with locale "C.UTF-8". 594s The default database encoding has accordingly been set to "UTF8". 594s The default text search configuration will be set to "english". 594s 594s Data page checksums are disabled. 594s 594s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 594s creating subdirectories ... ok 594s selecting dynamic shared memory implementation ... posix 594s selecting default "max_connections" ... 100 594s selecting default "shared_buffers" ... 128MB 594s selecting default time zone ... Etc/UTC 594s creating configuration files ... ok 594s running bootstrap script ... ok 595s performing post-bootstrap initialization ... ok 595s syncing data to disk ... ok 597s Setting up libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 597s Setting up cpp (4:14.2.0-1ubuntu1) ... 597s Setting up gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 597s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 597s Setting up gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 597s Setting up gcc-14 (14.2.0-19ubuntu2) ... 597s Setting up postgresql-server-dev-17 (17.4-1) ... 597s Setting up g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 597s Setting up g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 597s Setting up g++-14 (14.2.0-19ubuntu2) ... 597s Setting up gcc (4:14.2.0-1ubuntu1) ... 597s Setting up g++ (4:14.2.0-1ubuntu1) ... 597s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 597s Setting up build-essential (12.12ubuntu1) ... 597s Processing triggers for libc-bin (2.41-6ubuntu1) ... 597s Processing triggers for systemd (257.4-1ubuntu3) ... 598s Processing triggers for man-db (2.13.0-1) ... 599s Processing triggers for install-info (7.1.1-1) ... 612s autopkgtest [18:46:39]: test installcheck: [----------------------- 612s + dpkg-parsechangelog -SSource 613s + SOURCE=postgresql-17 613s + MAJOR=17 613s + top_srcdir=/tmp/autopkgtest.kwgU0X/build.Hm8/src 613s + cd src/test/regress 613s + make -f /tmp/autopkgtest.kwgU0X/build.Hm8/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 613s 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 -O3 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.kwgU0X/build.Hm8/src/debian/tests/ -I/usr/include/postgresql/17/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=3 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 613s 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 -O3 -Werror=implicit-function-declaration -fno-omit-frame-pointer -mno-omit-leaf-frame-pointer -flto=auto -ffat-lto-objects -fstack-protector-strong -fstack-clash-protection -Wformat -Werror=format-security -fcf-protection -fno-omit-frame-pointer -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/x86_64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-20/lib -Wl,--as-needed -fvisibility=hidden 613s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.kwgU0X/build.Hm8/src/src/test/regress'; sql/advisory_lock.sql sql/aggregates.sql sql/alter_generic.sql sql/alter_operator.sql sql/alter_table.sql sql/amutils.sql sql/arrays.sql sql/async.sql sql/bit.sql sql/bitmapops.sql sql/boolean.sql sql/box.sql sql/brin.sql sql/brin_bloom.sql sql/brin_multi.sql sql/btree_index.sql sql/case.sql sql/char.sql sql/circle.sql sql/cluster.sql sql/collate.icu.utf8.sql sql/collate.linux.utf8.sql sql/collate.sql sql/collate.utf8.sql sql/collate.windows.win1252.sql sql/combocid.sql sql/comments.sql sql/compression.sql sql/constraints.sql sql/conversion.sql sql/copy.sql sql/copy2.sql sql/copydml.sql sql/copyselect.sql sql/create_aggregate.sql sql/create_am.sql sql/create_cast.sql sql/create_function_c.sql sql/create_function_sql.sql sql/create_index.sql sql/create_index_spgist.sql sql/create_misc.sql sql/create_operator.sql sql/create_procedure.sql sql/create_role.sql sql/create_schema.sql sql/create_table.sql sql/create_table_like.sql sql/create_type.sql sql/create_view.sql sql/database.sql sql/date.sql sql/dbsize.sql sql/delete.sql sql/dependency.sql sql/domain.sql sql/drop_if_exists.sql sql/drop_operator.sql sql/enum.sql sql/equivclass.sql sql/errors.sql sql/event_trigger.sql sql/event_trigger_login.sql sql/explain.sql sql/expressions.sql sql/fast_default.sql sql/float4.sql sql/float8.sql sql/foreign_data.sql sql/foreign_key.sql sql/functional_deps.sql sql/generated.sql sql/geometry.sql sql/gin.sql sql/gist.sql sql/groupingsets.sql sql/guc.sql sql/hash_func.sql sql/hash_index.sql sql/hash_part.sql sql/horology.sql sql/identity.sql sql/incremental_sort.sql sql/index_including.sql sql/index_including_gist.sql sql/indexing.sql sql/indirect_toast.sql sql/inet.sql sql/infinite_recurse.sql sql/inherit.sql sql/init_privs.sql sql/insert.sql sql/insert_conflict.sql sql/int2.sql sql/int4.sql sql/int8.sql sql/interval.sql sql/join.sql sql/join_hash.sql sql/json.sql sql/json_encoding.sql sql/jsonb.sql sql/jsonb_jsonpath.sql sql/jsonpath.sql sql/jsonpath_encoding.sql sql/largeobject.sql sql/limit.sql sql/line.sql sql/lock.sql sql/lseg.sql sql/macaddr.sql sql/macaddr8.sql sql/matview.sql sql/md5.sql sql/memoize.sql sql/merge.sql sql/misc.sql sql/misc_functions.sql sql/misc_sanity.sql sql/money.sql sql/multirangetypes.sql sql/mvcc.sql sql/name.sql sql/namespace.sql sql/numeric.sql sql/numeric_big.sql sql/numerology.sql sql/object_address.sql sql/oid.sql sql/oidjoins.sql sql/opr_sanity.sql sql/partition_aggregate.sql sql/partition_info.sql sql/partition_join.sql sql/partition_prune.sql sql/password.sql sql/path.sql sql/pg_lsn.sql sql/plancache.sql sql/plpgsql.sql sql/point.sql sql/polygon.sql sql/polymorphism.sql sql/portals.sql sql/portals_p2.sql sql/predicate.sql sql/prepare.sql sql/prepared_xacts.sql sql/privileges.sql sql/psql.sql sql/psql_crosstab.sql sql/publication.sql sql/random.sql sql/rangefuncs.sql sql/rangetypes.sql sql/regex.sql sql/regproc.sql sql/reindex_catalog.sql sql/reloptions.sql sql/replica_identity.sql sql/returning.sql sql/roleattributes.sql sql/rowsecurity.sql sql/rowtypes.sql sql/rules.sql sql/sanity_check.sql sql/security_label.sql sql/select.sql sql/select_distinct.sql sql/select_distinct_on.sql sql/select_having.sql sql/select_implicit.sql sql/select_into.sql sql/select_parallel.sql sql/select_views.sql sql/sequence.sql sql/spgist.sql sql/sqljson.sql sql/sqljson_jsontable.sql sql/sqljson_queryfuncs.sql sql/stats.sql sql/stats_ext.sql sql/strings.sql sql/subscription.sql sql/subselect.sql sql/sysviews.sql sql/tablesample.sql sql/tablespace.sql sql/temp.sql sql/test_setup.sql sql/text.sql sql/tid.sql sql/tidrangescan.sql sql/tidscan.sql sql/time.sql sql/timestamp.sql sql/timestamptz.sql sql/timetz.sql sql/transactions.sql sql/triggers.sql sql/truncate.sql sql/tsdicts.sql sql/tsearch.sql sql/tsrf.sql sql/tstypes.sql sql/tuplesort.sql sql/txid.sql sql/type_sanity.sql sql/typed_table.sql sql/unicode.sql sql/union.sql sql/updatable_views.sql sql/update.sql sql/uuid.sql sql/vacuum.sql sql/vacuum_parallel.sql sql/varchar.sql sql/window.sql sql/with.sql sql/write_parallel.sql sql/xid.sql sql/xml.sql sql/xmlmap.sql expected/advisory_lock.out expected/aggregates.out expected/alter_generic.out expected/alter_operator.out expected/alter_table.out expected/amutils.out expected/arrays.out expected/async.out expected/bit.out expected/bitmapops.out expected/boolean.out expected/box.out expected/brin.out expected/brin_bloom.out expected/brin_multi.out expected/btree_index.out expected/case.out expected/char.out expected/char_1.out expected/char_2.out expected/circle.out expected/cluster.out expected/collate.icu.utf8.out expected/collate.icu.utf8_1.out expected/collate.linux.utf8.out expected/collate.linux.utf8_1.out expected/collate.out expected/collate.utf8.out expected/collate.utf8_1.out expected/collate.windows.win1252.out expected/collate.windows.win1252_1.out expected/combocid.out expected/comments.out expected/compression.out expected/compression_1.out expected/constraints.out expected/conversion.out expected/copy.out expected/copy2.out expected/copydml.out expected/copyselect.out expected/create_aggregate.out expected/create_am.out expected/create_cast.out expected/create_function_c.out expected/create_function_sql.out expected/create_index.out expected/create_index_spgist.out expected/create_misc.out expected/create_operator.out expected/create_procedure.out expected/create_role.out expected/create_schema.out expected/create_table.out expected/create_table_like.out expected/create_type.out expected/create_view.out expected/database.out expected/date.out expected/dbsize.out expected/delete.out expected/dependency.out expected/domain.out expected/drop_if_exists.out expected/drop_operator.out expected/enum.out expected/equivclass.out expected/errors.out expected/event_trigger.out expected/event_trigger_login.out expected/explain.out expected/expressions.out expected/fast_default.out expected/float4-misrounded-input.out expected/float4.out expected/float8.out expected/foreign_data.out expected/foreign_key.out expected/functional_deps.out expected/generated.out expected/geometry.out expected/gin.out expected/gist.out expected/groupingsets.out expected/guc.out expected/hash_func.out expected/hash_index.out expected/hash_part.out expected/horology.out expected/identity.out expected/incremental_sort.out expected/index_including.out expected/index_including_gist.out expected/indexing.out expected/indirect_toast.out expected/inet.out expected/infinite_recurse.out expected/infinite_recurse_1.out expected/inherit.out expected/init_privs.out expected/insert.out expected/insert_conflict.out expected/int2.out expected/int4.out expected/int8.out expected/interval.out expected/join.out expected/join_hash.out expected/json.out expected/json_encoding.out expected/json_encoding_1.out expected/json_encoding_2.out expected/jsonb.out expected/jsonb_jsonpath.out expected/jsonpath.out expected/jsonpath_encoding.out expected/jsonpath_encoding_1.out expected/jsonpath_encoding_2.out expected/largeobject.out expected/largeobject_1.out expected/limit.out expected/line.out expected/lock.out expected/lseg.out expected/macaddr.out expected/macaddr8.out expected/matview.out expected/md5.out expected/md5_1.out expected/memoize.out expected/merge.out expected/misc.out expected/misc_functions.out expected/misc_sanity.out expected/money.out expected/multirangetypes.out expected/mvcc.out expected/name.out expected/namespace.out expected/numeric.out expected/numeric_big.out expected/numerology.out expected/object_address.out expected/oid.out expected/oidjoins.out expected/opr_sanity.out expected/partition_aggregate.out expected/partition_info.out expected/partition_join.out expected/partition_prune.out expected/password.out expected/password_1.out expected/path.out expected/pg_lsn.out expected/plancache.out expected/plpgsql.out expected/point.out expected/polygon.out expected/polymorphism.out expected/portals.out expected/portals_p2.out expected/predicate.out expected/prepare.out expected/prepared_xacts.out expected/prepared_xacts_1.out expected/privileges.out expected/psql.out expected/psql_crosstab.out expected/publication.out expected/random.out expected/rangefuncs.out expected/rangetypes.out expected/regex.out expected/regproc.out expected/reindex_catalog.out expected/reloptions.out expected/replica_identity.out expected/returning.out expected/roleattributes.out expected/rowsecurity.out expected/rowtypes.out expected/rules.out expected/sanity_check.out expected/security_label.out expected/select.out expected/select_distinct.out expected/select_distinct_on.out expected/select_having.out expected/select_having_1.out expected/select_having_2.out expected/select_implicit.out expected/select_implicit_1.out expected/select_implicit_2.out expected/select_into.out expected/select_parallel.out expected/select_views.out expected/sequence.out expected/spgist.out expected/sqljson.out expected/sqljson_jsontable.out expected/sqljson_queryfuncs.out expected/stats.out expected/stats_ext.out expected/strings.out expected/subscription.out expected/subselect.out expected/sysviews.out expected/tablesample.out expected/tablespace.out expected/temp.out expected/test_setup.out expected/text.out expected/tid.out expected/tidrangescan.out expected/tidscan.out expected/time.out expected/timestamp.out expected/timestamptz.out expected/timetz.out expected/transactions.out expected/triggers.out expected/truncate.out expected/tsdicts.out expected/tsearch.out expected/tsrf.out expected/tstypes.out expected/tuplesort.out expected/txid.out expected/type_sanity.out expected/typed_table.out expected/unicode.out expected/unicode_1.out expected/union.out expected/updatable_views.out expected/update.out expected/uuid.out expected/vacuum.out expected/vacuum_parallel.out expected/varchar.out expected/varchar_1.out expected/varchar_2.out expected/window.out expected/with.out expected/write_parallel.out expected/xid.out expected/xml.out expected/xml_1.out expected/xml_2.out expected/xmlmap.out expected/xmlmap_1.out 614s + id -u 614s + [ 1000 = 0 ] 614s + SU=sh 614s + sh 614s + mktemp -d /tmp/regress.XXXXXX 614s + OUTPUT=/tmp/regress.0R8TxU 614s + trap rm -rf /tmp/regress.0R8TxU EXIT 614s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.0R8TxU --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 614s Creating new PostgreSQL cluster 17/regress ... 616s # using postmaster on localhost, port 5433 617s ok 1 - test_setup 146 ms 617s # parallel group (20 tests): varchar text char oid pg_lsn name txid int2 int4 float4 uuid regproc money int8 float8 enum bit boolean numeric rangetypes 617s ok 2 + boolean 456 ms 617s ok 3 + char 184 ms 617s ok 4 + name 214 ms 617s ok 5 + varchar 165 ms 617s ok 6 + text 165 ms 617s ok 7 + int2 219 ms 617s ok 8 + int4 234 ms 617s ok 9 + int8 299 ms 617s ok 10 + oid 201 ms 617s ok 11 + float4 236 ms 617s ok 12 + float8 299 ms 617s ok 13 + bit 382 ms 617s ok 14 + numeric 553 ms 617s ok 15 + txid 195 ms 617s ok 16 + uuid 234 ms 617s ok 17 + enum 341 ms 617s ok 18 + money 267 ms 617s ok 19 + rangetypes 633 ms 617s ok 20 + pg_lsn 183 ms 617s ok 21 + regproc 245 ms 618s # parallel group (20 tests): lseg md5 path line time circle macaddr timetz numerology macaddr8 inet date point interval strings timestamp timestamptz multirangetypes polygon box 618s ok 22 + strings 457 ms 618s ok 23 + md5 140 ms 618s ok 24 + numerology 235 ms 618s ok 25 + point 434 ms 618s ok 26 + lseg 121 ms 618s ok 27 + line 141 ms 618s ok 28 + box 931 ms 618s ok 29 + path 139 ms 618s ok 30 + polygon 816 ms 618s ok 31 + circle 168 ms 618s ok 32 + date 307 ms 618s ok 33 + time 149 ms 618s ok 34 + timetz 205 ms 618s ok 35 + timestamp 514 ms 618s ok 36 + timestamptz 601 ms 618s ok 37 + interval 406 ms 618s ok 38 + inet 248 ms 618s ok 39 + macaddr 185 ms 618s ok 40 + macaddr8 205 ms 618s ok 41 + multirangetypes 740 ms 619s # parallel group (13 tests): tstypes unicode misc_sanity comments mvcc xid expressions type_sanity geometry opr_sanity horology database regex 619s ok 42 + geometry 363 ms 619s ok 43 + horology 528 ms 619s ok 44 + tstypes 91 ms 619s ok 45 + regex 597 ms 619s ok 46 + type_sanity 272 ms 619s ok 47 + opr_sanity 470 ms 619s ok 48 + misc_sanity 112 ms 619s ok 49 + comments 120 ms 619s ok 50 + expressions 218 ms 619s ok 51 + unicode 107 ms 619s ok 52 + xid 186 ms 619s ok 53 + mvcc 161 ms 619s ok 54 + database 555 ms 619s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 619s ok 55 + copy 120 ms 619s ok 56 + copyselect 89 ms 619s ok 57 + copydml 103 ms 619s ok 58 + insert 298 ms 619s ok 59 + insert_conflict 173 ms 620s # parallel group (7 tests): create_function_c create_operator create_misc create_procedure create_type create_schema create_table 620s ok 60 + create_function_c 60 ms 620s ok 61 + create_misc 89 ms 620s ok 62 + create_operator 70 ms 620s ok 63 + create_procedure 101 ms 620s ok 64 + create_table 268 ms 620s ok 65 + create_type 101 ms 620s ok 66 + create_schema 105 ms 620s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 620s ok 67 + create_index 846 ms 620s ok 68 + create_index_spgist 767 ms 620s ok 69 + create_view 296 ms 620s ok 70 + index_including 196 ms 620s ok 71 + index_including_gist 289 ms 621s # parallel group (16 tests): create_cast create_aggregate roleattributes errors hash_func drop_if_exists typed_table create_function_sql create_am select constraints infinite_recurse vacuum updatable_views inherit triggers 621s ok 72 + create_aggregate 183 ms 621s ok 73 + create_function_sql 381 ms 621s ok 74 + create_cast 135 ms 621s ok 75 + constraints 567 ms 621s ok 76 + triggers 1067 ms 621s ok 77 + select 531 ms 621s ok 78 + inherit 1053 ms 621s ok 79 + typed_table 292 ms 621s ok 80 + vacuum 709 ms 621s ok 81 + drop_if_exists 274 ms 621s ok 82 + updatable_views 839 ms 621s ok 83 + roleattributes 179 ms 621s ok 84 + create_am 474 ms 621s ok 85 + hash_func 208 ms 621s ok 86 + errors 175 ms 621s ok 87 + infinite_recurse 558 ms 622s ok 88 - sanity_check 64 ms 623s # parallel group (20 tests): select_distinct_on delete select_implicit select_having case random namespace select_into prepared_xacts transactions portals select_distinct union arrays subselect hash_index update aggregates btree_index join 623s ok 89 + select_into 325 ms 623s ok 90 + select_distinct 666 ms 623s ok 91 + select_distinct_on 138 ms 623s ok 92 + select_implicit 220 ms 623s ok 93 + select_having 218 ms 623s ok 94 + subselect 805 ms 623s ok 95 + union 732 ms 623s ok 96 + case 243 ms 623s ok 97 + join 1827 ms 623s ok 98 + aggregates 1743 ms 623s ok 99 + transactions 536 ms 623s ok 100 + random 259 ms 623s ok 101 + portals 582 ms 623s ok 102 + arrays 778 ms 623s ok 103 + btree_index 1740 ms 623s ok 104 + hash_index 1112 ms 623s ok 105 + update 1178 ms 623s ok 106 + delete 183 ms 623s ok 107 + namespace 299 ms 623s ok 108 + prepared_xacts 301 ms 629s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password replica_identity identity matview collate spgist gist generated rowsecurity groupingsets gin brin join_hash privileges 629s ok 109 + brin 5057 ms 629s ok 110 + gin 2052 ms 629s ok 111 + gist 1739 ms 629s ok 112 + spgist 1501 ms 629s ok 113 + privileges 5361 ms 629s ok 114 + init_privs 141 ms 629s ok 115 + security_label 213 ms 629s ok 116 + collate 1388 ms 629s ok 117 + matview 1294 ms 629s ok 118 + lock 402 ms 629s ok 119 + replica_identity 647 ms 629s ok 120 + rowsecurity 1768 ms 629s ok 121 + object_address 424 ms 629s ok 122 + tablesample 334 ms 629s ok 123 + groupingsets 1944 ms 629s ok 124 + drop_operator 121 ms 629s ok 125 + password 429 ms 629s ok 126 + identity 1241 ms 629s ok 127 + generated 1718 ms 629s ok 128 + join_hash 5037 ms 629s # parallel group (2 tests): brin_bloom brin_multi 629s ok 129 + brin_bloom 55 ms 629s ok 130 + brin_multi 160 ms 630s # parallel group (17 tests): async dbsize collate.utf8 tidscan tid alter_operator tsrf create_role alter_generic sysviews misc_functions tidrangescan merge create_table_like incremental_sort collate.icu.utf8 misc 630s ok 131 + create_table_like 692 ms 630s ok 132 + alter_generic 385 ms 630s ok 133 + alter_operator 227 ms 630s ok 134 + misc 995 ms 630s ok 135 + async 115 ms 630s ok 136 + dbsize 134 ms 630s ok 137 + merge 678 ms 630s ok 138 + misc_functions 428 ms 630s ok 139 + sysviews 399 ms 630s ok 140 + tsrf 245 ms 630s ok 141 + tid 191 ms 630s ok 142 + tidscan 181 ms 630s ok 143 + tidrangescan 575 ms 630s ok 144 + collate.utf8 163 ms 630s ok 145 + collate.icu.utf8 902 ms 630s ok 146 + incremental_sort 739 ms 630s ok 147 + create_role 280 ms 631s # parallel group (7 tests): amutils collate.linux.utf8 collate.windows.win1252 psql_crosstab rules psql stats_ext 631s ok 148 + rules 369 ms 631s ok 149 + psql 439 ms 631s ok 150 + psql_crosstab 103 ms 631s ok 151 + amutils 54 ms 631s ok 152 + stats_ext 841 ms 631s ok 153 + collate.linux.utf8 62 ms 631s ok 154 + collate.windows.win1252 71 ms 634s ok 155 - select_parallel 2792 ms 634s ok 156 - write_parallel 108 ms 634s ok 157 - vacuum_parallel 65 ms 635s # parallel group (2 tests): subscription publication 635s ok 158 + publication 1373 ms 635s ok 159 + subscription 49 ms 640s # parallel group (17 tests): equivclass tsdicts select_views cluster indirect_toast portals_p2 combocid advisory_lock xmlmap functional_deps dependency window bitmapops foreign_data foreign_key tsearch guc 640s ok 160 + select_views 205 ms 640s ok 161 + portals_p2 3249 ms 640s ok 162 + foreign_key 4150 ms 640s ok 163 + cluster 247 ms 640s ok 164 + dependency 3378 ms 640s ok 165 + guc 5248 ms 640s ok 166 + bitmapops 3546 ms 640s ok 167 + combocid 3254 ms 641s ok 168 + tsearch 4436 ms 641s ok 169 + tsdicts 149 ms 641s ok 170 + foreign_data 3951 ms 641s ok 171 + window 3534 ms 641s ok 172 + xmlmap 3290 ms 641s ok 173 + functional_deps 3327 ms 641s ok 174 + advisory_lock 3265 ms 641s ok 175 + indirect_toast 311 ms 641s ok 176 + equivclass 104 ms 641s # parallel group (9 tests): json_encoding jsonpath_encoding jsonpath sqljson_jsontable sqljson json sqljson_queryfuncs jsonb_jsonpath jsonb 641s ok 177 + json 232 ms 641s ok 178 + jsonb 371 ms 641s ok 179 + json_encoding 83 ms 641s ok 180 + jsonpath 154 ms 641s ok 181 + jsonpath_encoding 83 ms 641s ok 182 + jsonb_jsonpath 263 ms 641s ok 183 + sqljson 179 ms 641s ok 184 + sqljson_queryfuncs 233 ms 641s ok 185 + sqljson_jsontable 168 ms 642s # parallel group (18 tests): prepare plancache returning limit conversion copy2 truncate sequence rowtypes polymorphism domain largeobject with rangefuncs plpgsql temp xml alter_table 642s ok 186 + plancache 323 ms 642s ok 187 + limit 377 ms 642s ok 188 + plpgsql 1068 ms 642s ok 189 + copy2 645 ms 642s ok 190 + temp 1084 ms 643s ok 191 + domain 759 ms 643s ok 192 + rangefuncs 948 ms 643s ok 193 + prepare 271 ms 643s ok 194 + conversion 420 ms 643s ok 195 + truncate 615 ms 643s ok 196 + alter_table 1506 ms 643s ok 197 + sequence 592 ms 643s ok 198 + polymorphism 689 ms 643s ok 199 + rowtypes 684 ms 643s ok 200 + returning 278 ms 643s ok 201 + largeobject 765 ms 643s ok 202 + with 778 ms 643s ok 203 + xml 1188 ms 644s # parallel group (13 tests): hash_part partition_info reloptions predicate explain compression memoize partition_aggregate indexing partition_join stats tuplesort partition_prune 644s ok 204 + partition_join 1498 ms 644s ok 205 + partition_prune 1837 ms 644s ok 206 + reloptions 250 ms 644s ok 207 + hash_part 142 ms 644s ok 208 + indexing 1488 ms 644s ok 209 + partition_aggregate 1265 ms 644s ok 210 + partition_info 149 ms 644s ok 211 + tuplesort 1555 ms 644s ok 212 + explain 278 ms 644s ok 213 + compression 542 ms 644s ok 214 + memoize 1142 ms 644s ok 215 + stats 1513 ms 644s ok 216 + predicate 248 ms 645s # parallel group (2 tests): oidjoins event_trigger 645s ok 217 + oidjoins 134 ms 645s ok 218 + event_trigger 157 ms 645s ok 219 - event_trigger_login 61 ms 645s ok 220 - fast_default 115 ms 645s ok 221 - tablespace 273 ms 645s 1..221 645s # All 221 tests passed. 645s Dropping cluster 17/regress ... 645s + rm -rf /tmp/regress.0R8TxU 646s autopkgtest [18:47:13]: test installcheck: -----------------------] 646s autopkgtest [18:47:13]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 646s installcheck PASS 647s autopkgtest [18:47:14]: @@@@@@@@@@@@@@@@@@@@ summary 647s run-testsuite PASS 647s installcheck PASS 652s nova [W] Skipping flock for amd64 652s Creating nova instance adt-plucky-amd64-postgresql-17-20250506-183627-juju-7f2275-prod-proposed-migration-environment-20-8b390674-c941-4e89-b5e3-551388db2c16 from image adt/ubuntu-plucky-amd64-server-20250506.img (UUID d6b827dd-665a-49fe-9aa5-d220430ba795)... 652s nova [W] Timed out waiting for f0b1fcbe-da03-468b-b93f-56d022283d71 to get deleted. 652s nova [W] Skipping flock for amd64 652s Creating nova instance adt-plucky-amd64-postgresql-17-20250506-183627-juju-7f2275-prod-proposed-migration-environment-20-8b390674-c941-4e89-b5e3-551388db2c16 from image adt/ubuntu-plucky-amd64-server-20250506.img (UUID d6b827dd-665a-49fe-9aa5-d220430ba795)... 652s nova [W] Timed out waiting for ee426c7e-f0dc-49de-801f-39a4d5960d42 to get deleted.