0s autopkgtest [14:41:13]: starting date and time: 2025-05-03 14:41:13+0000 0s autopkgtest [14:41:13]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [14:41:13]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ko84kodg/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/277 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-19.secgroup --name adt-questing-amd64-postgresql-17-20250503-144113-juju-7f2275-prod-proposed-migration-environment-15-65114648-f150-468a-911c-a4abe234d10b --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 90s autopkgtest [14:42:43]: testbed dpkg architecture: amd64 90s autopkgtest [14:42:43]: testbed apt version: 3.0.0 90s autopkgtest [14:42:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 90s autopkgtest [14:42:43]: testbed release detected to be: None 91s autopkgtest [14:42:44]: updating testbed package index (apt update) 91s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 92s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 92s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 92s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 92s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [38.8 kB] 92s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1597 kB] 92s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [150 kB] 92s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [145 kB] 92s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [202 kB] 92s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [1515 kB] 92s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [615 kB] 92s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [25.3 kB] 92s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [54.1 kB] 93s Fetched 4453 kB in 1s (3897 kB/s) 93s Reading package lists... 94s autopkgtest [14:42:47]: upgrading testbed (apt dist-upgrade and autopurge) 94s Reading package lists... 94s Building dependency tree... 94s Reading state information... 95s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 95s Entering ResolveByKeep 96s 96s Calculating upgrade... 96s The following packages will be upgraded: 96s debianutils libmbim-glib4 libmbim-proxy libnftnl11 libqmi-glib5 libqmi-proxy 96s python3-lazr.restfulclient 96s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 96s Need to get 1378 kB of archives. 96s After this operation, 139 kB disk space will be freed. 96s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 debianutils amd64 5.22 [93.0 kB] 96s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 libnftnl11 amd64 1.2.9-1 [69.1 kB] 96s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-proxy amd64 1.32.0-1 [6276 B] 96s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-glib4 amd64 1.32.0-1 [233 kB] 96s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-proxy amd64 1.36.0-1 [6220 B] 96s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-glib5 amd64 1.36.0-1 [920 kB] 96s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 97s Fetched 1378 kB in 1s (2528 kB/s) 97s (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.) 97s Preparing to unpack .../debianutils_5.22_amd64.deb ... 97s Unpacking debianutils (5.22) over (5.21) ... 97s Setting up debianutils (5.22) ... 97s (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.) 97s Preparing to unpack .../0-libnftnl11_1.2.9-1_amd64.deb ... 97s Unpacking libnftnl11:amd64 (1.2.9-1) over (1.2.8-1) ... 97s Preparing to unpack .../1-libmbim-proxy_1.32.0-1_amd64.deb ... 97s Unpacking libmbim-proxy (1.32.0-1) over (1.31.2-0ubuntu4) ... 97s Preparing to unpack .../2-libmbim-glib4_1.32.0-1_amd64.deb ... 97s Unpacking libmbim-glib4:amd64 (1.32.0-1) over (1.31.2-0ubuntu4) ... 97s Preparing to unpack .../3-libqmi-proxy_1.36.0-1_amd64.deb ... 97s Unpacking libqmi-proxy (1.36.0-1) over (1.35.6-1) ... 97s Preparing to unpack .../4-libqmi-glib5_1.36.0-1_amd64.deb ... 97s Unpacking libqmi-glib5:amd64 (1.36.0-1) over (1.35.6-1) ... 97s Preparing to unpack .../5-python3-lazr.restfulclient_0.14.6-3_all.deb ... 97s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 97s Setting up libnftnl11:amd64 (1.2.9-1) ... 97s Setting up python3-lazr.restfulclient (0.14.6-3) ... 98s Setting up libmbim-glib4:amd64 (1.32.0-1) ... 98s Setting up libmbim-proxy (1.32.0-1) ... 98s Setting up libqmi-glib5:amd64 (1.36.0-1) ... 98s Setting up libqmi-proxy (1.36.0-1) ... 98s Processing triggers for libc-bin (2.41-6ubuntu1) ... 98s Processing triggers for man-db (2.13.0-1) ... 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s Starting pkgProblemResolver with broken count: 0 100s Starting 2 pkgProblemResolver with broken count: 0 100s Done 100s Solving dependencies... 100s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s autopkgtest [14:42:56]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 103s autopkgtest [14:42:56]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 111s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (dsc) [4245 B] 111s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (tar) [21.5 MB] 111s Get:3 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (diff) [27.2 kB] 111s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 111s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 111s gpgv: Can't check signature: No public key 111s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 116s autopkgtest [14:43:09]: testing package postgresql-17 version 17.4-1 117s autopkgtest [14:43:10]: build not needed 123s autopkgtest [14:43:16]: test run-testsuite: preparing testbed 124s Reading package lists... 124s Building dependency tree... 124s Reading state information... 124s Starting pkgProblemResolver with broken count: 0 124s Starting 2 pkgProblemResolver with broken count: 0 124s Done 125s The following NEW packages will be installed: 125s autoconf automake autopoint autotools-dev binutils-gold 125s binutils-gold-x86-64-linux-gnu build-essential clang-20 cpp cpp-14 125s cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 125s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 125s fakeroot g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 125s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 125s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-20-dev 125s libclang-cpp20 libclang1-20 libdebhelper-perl libecpg-compat3 libecpg-dev 125s libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 125s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 125s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 125s libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libquadmath0 125s libssl-dev libstdc++-14-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev 125s libxslt1.1 llvm-20 llvm-20-dev llvm-20-linker-tools llvm-20-runtime 125s llvm-20-tools locales-all m4 po-debconf postgresql-17 postgresql-client-17 125s postgresql-client-common postgresql-common postgresql-common-dev 125s postgresql-doc-17 postgresql-plperl-17 postgresql-plpython3-17 125s postgresql-pltcl-17 postgresql-server-dev-17 ssl-cert 125s 0 upgraded, 91 newly installed, 0 to remove and 0 not upgraded. 125s Need to get 239 MB of archives. 125s After this operation, 1355 MB of additional disk space will be used. 125s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 125s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-client-common all 277 [48.0 kB] 125s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 125s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 125s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common-dev all 277 [73.4 kB] 125s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 125s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common all 277 [101 kB] 125s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 m4 amd64 1.4.19-7 [263 kB] 125s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 autoconf all 2.72-3ubuntu1 [383 kB] 125s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 autotools-dev all 20220109.1 [44.9 kB] 125s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 automake all 1:1.17-3ubuntu1 [572 kB] 125s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 autopoint all 0.23.1-1 [619 kB] 125s Get:13 http://ftpmaster.internal/ubuntu questing/main amd64 binutils-gold-x86-64-linux-gnu amd64 2.44-2 [1278 kB] 126s Get:14 http://ftpmaster.internal/ubuntu questing/main amd64 binutils-gold amd64 2.44-2 [2208 B] 126s Get:15 http://ftpmaster.internal/ubuntu questing/main amd64 libisl23 amd64 0.27-1 [685 kB] 126s Get:16 http://ftpmaster.internal/ubuntu questing/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 126s Get:17 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [11.9 MB] 126s Get:18 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14 amd64 14.2.0-19ubuntu2 [1030 B] 126s Get:19 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [5586 B] 126s Get:20 http://ftpmaster.internal/ubuntu questing/main amd64 cpp amd64 4:14.2.0-1ubuntu1 [22.4 kB] 126s Get:21 http://ftpmaster.internal/ubuntu questing/main amd64 libcc1-0 amd64 15-20250404-0ubuntu1 [47.1 kB] 126s Get:22 http://ftpmaster.internal/ubuntu questing/main amd64 libgomp1 amd64 15-20250404-0ubuntu1 [151 kB] 126s Get:23 http://ftpmaster.internal/ubuntu questing/main amd64 libitm1 amd64 15-20250404-0ubuntu1 [29.5 kB] 126s Get:24 http://ftpmaster.internal/ubuntu questing/main amd64 libasan8 amd64 15-20250404-0ubuntu1 [3076 kB] 126s Get:25 http://ftpmaster.internal/ubuntu questing/main amd64 liblsan0 amd64 15-20250404-0ubuntu1 [1362 kB] 126s Get:26 http://ftpmaster.internal/ubuntu questing/main amd64 libtsan2 amd64 15-20250404-0ubuntu1 [2760 kB] 126s Get:27 http://ftpmaster.internal/ubuntu questing/main amd64 libubsan1 amd64 15-20250404-0ubuntu1 [1211 kB] 126s Get:28 http://ftpmaster.internal/ubuntu questing/main amd64 libhwasan0 amd64 15-20250404-0ubuntu1 [1687 kB] 126s Get:29 http://ftpmaster.internal/ubuntu questing/main amd64 libquadmath0 amd64 15-20250404-0ubuntu1 [153 kB] 126s Get:30 http://ftpmaster.internal/ubuntu questing/main amd64 libgcc-14-dev amd64 14.2.0-19ubuntu2 [2815 kB] 126s Get:31 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [23.3 MB] 127s Get:32 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14 amd64 14.2.0-19ubuntu2 [540 kB] 127s Get:33 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [1208 B] 127s Get:34 http://ftpmaster.internal/ubuntu questing/main amd64 gcc amd64 4:14.2.0-1ubuntu1 [5004 B] 127s Get:35 http://ftpmaster.internal/ubuntu questing/main amd64 libstdc++-14-dev amd64 14.2.0-19ubuntu2 [2510 kB] 127s Get:36 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [13.4 MB] 127s Get:37 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14 amd64 14.2.0-19ubuntu2 [23.0 kB] 127s Get:38 http://ftpmaster.internal/ubuntu questing/main amd64 g++-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [968 B] 127s Get:39 http://ftpmaster.internal/ubuntu questing/main amd64 g++ amd64 4:14.2.0-1ubuntu1 [1100 B] 127s Get:40 http://ftpmaster.internal/ubuntu questing/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 127s Get:41 http://ftpmaster.internal/ubuntu questing/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 128s Get:42 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-cpp20 amd64 1:20.1.2-0ubuntu1 [14.2 MB] 128s Get:43 http://ftpmaster.internal/ubuntu questing/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 128s Get:44 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc4 amd64 15-20250404-0ubuntu1 [47.8 kB] 128s Get:45 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc-14-dev amd64 14.2.0-19ubuntu2 [195 kB] 128s Get:46 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-common-20-dev amd64 1:20.1.2-0ubuntu1 [782 kB] 128s Get:47 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-linker-tools amd64 1:20.1.2-0ubuntu1 [1337 kB] 128s Get:48 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang1-20 amd64 1:20.1.2-0ubuntu1 [8255 kB] 128s Get:49 http://ftpmaster.internal/ubuntu questing/universe amd64 clang-20 amd64 1:20.1.2-0ubuntu1 [77.6 kB] 128s Get:50 http://ftpmaster.internal/ubuntu questing/main amd64 libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 128s Get:51 http://ftpmaster.internal/ubuntu questing/main amd64 libtool all 2.5.4-4 [168 kB] 128s Get:52 http://ftpmaster.internal/ubuntu questing/main amd64 dh-autoreconf all 20 [16.1 kB] 128s Get:53 http://ftpmaster.internal/ubuntu questing/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 128s Get:54 http://ftpmaster.internal/ubuntu questing/main amd64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 128s Get:55 http://ftpmaster.internal/ubuntu questing/main amd64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 128s Get:56 http://ftpmaster.internal/ubuntu questing/main amd64 debugedit amd64 1:5.1-2 [47.0 kB] 128s Get:57 http://ftpmaster.internal/ubuntu questing/main amd64 dwz amd64 0.15-1build6 [115 kB] 128s Get:58 http://ftpmaster.internal/ubuntu questing/main amd64 gettext amd64 0.23.1-1 [1086 kB] 128s Get:59 http://ftpmaster.internal/ubuntu questing/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 128s Get:60 http://ftpmaster.internal/ubuntu questing/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 128s Get:61 http://ftpmaster.internal/ubuntu questing/main amd64 debhelper all 13.24.1ubuntu2 [895 kB] 129s Get:62 http://ftpmaster.internal/ubuntu questing/main amd64 emacsen-common all 3.0.7 [13.0 kB] 129s Get:63 http://ftpmaster.internal/ubuntu questing/main amd64 dictionaries-common all 1.30.10 [178 kB] 129s Get:64 http://ftpmaster.internal/ubuntu questing/main amd64 libfakeroot amd64 1.37.1-1 [33.9 kB] 129s Get:65 http://ftpmaster.internal/ubuntu questing/main amd64 fakeroot amd64 1.37.1-1 [68.1 kB] 129s Get:66 http://ftpmaster.internal/ubuntu questing/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 129s Get:67 http://ftpmaster.internal/ubuntu questing/main amd64 libpgtypes3 amd64 17.4-1 [46.3 kB] 129s Get:68 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.4-1 [155 kB] 129s Get:69 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg6 amd64 17.4-1 [51.7 kB] 129s Get:70 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-compat3 amd64 17.4-1 [13.2 kB] 129s Get:71 http://ftpmaster.internal/ubuntu questing/main amd64 libssl-dev amd64 3.4.1-1ubuntu3 [2872 kB] 129s Get:72 http://ftpmaster.internal/ubuntu questing/main amd64 libpq-dev amd64 17.4-1 [158 kB] 129s Get:73 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-dev amd64 17.4-1 [277 kB] 129s Get:74 http://ftpmaster.internal/ubuntu questing/main amd64 libncurses-dev amd64 6.5+20250216-2 [424 kB] 129s Get:75 http://ftpmaster.internal/ubuntu questing/main amd64 libtcl8.6 amd64 8.6.16+dfsg-1 [1086 kB] 129s Get:76 http://ftpmaster.internal/ubuntu questing/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.4 [785 kB] 129s Get:77 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 129s Get:78 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-runtime amd64 1:20.1.2-0ubuntu1 [560 kB] 129s Get:79 http://ftpmaster.internal/ubuntu questing/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 129s Get:80 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20 amd64 1:20.1.2-0ubuntu1 [19.7 MB] 129s Get:81 http://ftpmaster.internal/ubuntu questing/main amd64 libffi-dev amd64 3.4.7-1 [65.5 kB] 129s Get:82 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-tools amd64 1:20.1.2-0ubuntu1 [513 kB] 129s Get:83 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-dev amd64 1:20.1.2-0ubuntu1 [50.5 MB] 131s Get:84 http://ftpmaster.internal/ubuntu questing/universe amd64 locales-all amd64 2.41-6ubuntu1 [11.2 MB] 131s Get:85 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 131s Get:86 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 132s Get:87 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-doc-17 all 17.4-1 [2131 kB] 132s Get:88 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plperl-17 amd64 17.4-1 [71.2 kB] 132s Get:89 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plpython3-17 amd64 17.4-1 [78.3 kB] 132s Get:90 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-pltcl-17 amd64 17.4-1 [31.3 kB] 132s Get:91 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-17 amd64 17.4-1 [1417 kB] 132s Preconfiguring packages ... 132s Fetched 239 MB in 7s (34.0 MB/s) 132s Selecting previously unselected package libjson-perl. 132s (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.) 132s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 132s Unpacking libjson-perl (4.10000-1) ... 132s Selecting previously unselected package postgresql-client-common. 132s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 132s Unpacking postgresql-client-common (277) ... 133s Selecting previously unselected package libio-pty-perl. 133s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 133s Unpacking libio-pty-perl (1:1.20-1build3) ... 133s Selecting previously unselected package libipc-run-perl. 133s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 133s Unpacking libipc-run-perl (20231003.0-2) ... 133s Selecting previously unselected package postgresql-common-dev. 133s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 133s Unpacking postgresql-common-dev (277) ... 133s Selecting previously unselected package ssl-cert. 133s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 133s Unpacking ssl-cert (1.1.3ubuntu1) ... 133s Selecting previously unselected package postgresql-common. 133s Preparing to unpack .../06-postgresql-common_277_all.deb ... 133s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 133s Unpacking postgresql-common (277) ... 133s Selecting previously unselected package m4. 133s Preparing to unpack .../07-m4_1.4.19-7_amd64.deb ... 133s Unpacking m4 (1.4.19-7) ... 133s Selecting previously unselected package autoconf. 133s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 133s Unpacking autoconf (2.72-3ubuntu1) ... 133s Selecting previously unselected package autotools-dev. 133s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 133s Unpacking autotools-dev (20220109.1) ... 133s Selecting previously unselected package automake. 133s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 133s Unpacking automake (1:1.17-3ubuntu1) ... 133s Selecting previously unselected package autopoint. 133s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 133s Unpacking autopoint (0.23.1-1) ... 133s Selecting previously unselected package binutils-gold-x86-64-linux-gnu. 133s Preparing to unpack .../12-binutils-gold-x86-64-linux-gnu_2.44-2_amd64.deb ... 133s Unpacking binutils-gold-x86-64-linux-gnu (2.44-2) ... 133s Selecting previously unselected package binutils-gold. 133s Preparing to unpack .../13-binutils-gold_2.44-2_amd64.deb ... 133s Unpacking binutils-gold (2.44-2) ... 133s Selecting previously unselected package libisl23:amd64. 133s Preparing to unpack .../14-libisl23_0.27-1_amd64.deb ... 133s Unpacking libisl23:amd64 (0.27-1) ... 133s Selecting previously unselected package libmpc3:amd64. 133s Preparing to unpack .../15-libmpc3_1.3.1-1build2_amd64.deb ... 133s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 133s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 133s Preparing to unpack .../16-cpp-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 133s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 133s Selecting previously unselected package cpp-14. 133s Preparing to unpack .../17-cpp-14_14.2.0-19ubuntu2_amd64.deb ... 133s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 133s Selecting previously unselected package cpp-x86-64-linux-gnu. 133s Preparing to unpack .../18-cpp-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 133s Unpacking cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 133s Selecting previously unselected package cpp. 133s Preparing to unpack .../19-cpp_4%3a14.2.0-1ubuntu1_amd64.deb ... 133s Unpacking cpp (4:14.2.0-1ubuntu1) ... 133s Selecting previously unselected package libcc1-0:amd64. 133s Preparing to unpack .../20-libcc1-0_15-20250404-0ubuntu1_amd64.deb ... 133s Unpacking libcc1-0:amd64 (15-20250404-0ubuntu1) ... 133s Selecting previously unselected package libgomp1:amd64. 133s Preparing to unpack .../21-libgomp1_15-20250404-0ubuntu1_amd64.deb ... 133s Unpacking libgomp1:amd64 (15-20250404-0ubuntu1) ... 133s Selecting previously unselected package libitm1:amd64. 133s Preparing to unpack .../22-libitm1_15-20250404-0ubuntu1_amd64.deb ... 133s Unpacking libitm1:amd64 (15-20250404-0ubuntu1) ... 133s Selecting previously unselected package libasan8:amd64. 133s Preparing to unpack .../23-libasan8_15-20250404-0ubuntu1_amd64.deb ... 133s Unpacking libasan8:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package liblsan0:amd64. 134s Preparing to unpack .../24-liblsan0_15-20250404-0ubuntu1_amd64.deb ... 134s Unpacking liblsan0:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package libtsan2:amd64. 134s Preparing to unpack .../25-libtsan2_15-20250404-0ubuntu1_amd64.deb ... 134s Unpacking libtsan2:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package libubsan1:amd64. 134s Preparing to unpack .../26-libubsan1_15-20250404-0ubuntu1_amd64.deb ... 134s Unpacking libubsan1:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package libhwasan0:amd64. 134s Preparing to unpack .../27-libhwasan0_15-20250404-0ubuntu1_amd64.deb ... 134s Unpacking libhwasan0:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package libquadmath0:amd64. 134s Preparing to unpack .../28-libquadmath0_15-20250404-0ubuntu1_amd64.deb ... 134s Unpacking libquadmath0:amd64 (15-20250404-0ubuntu1) ... 134s Selecting previously unselected package libgcc-14-dev:amd64. 134s Preparing to unpack .../29-libgcc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 134s Unpacking libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 134s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 134s Preparing to unpack .../30-gcc-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 134s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 134s Selecting previously unselected package gcc-14. 134s Preparing to unpack .../31-gcc-14_14.2.0-19ubuntu2_amd64.deb ... 134s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 134s Selecting previously unselected package gcc-x86-64-linux-gnu. 134s Preparing to unpack .../32-gcc-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 134s Unpacking gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 134s Selecting previously unselected package gcc. 134s Preparing to unpack .../33-gcc_4%3a14.2.0-1ubuntu1_amd64.deb ... 134s Unpacking gcc (4:14.2.0-1ubuntu1) ... 134s Selecting previously unselected package libstdc++-14-dev:amd64. 134s Preparing to unpack .../34-libstdc++-14-dev_14.2.0-19ubuntu2_amd64.deb ... 134s Unpacking libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 135s Selecting previously unselected package g++-14-x86-64-linux-gnu. 135s Preparing to unpack .../35-g++-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 135s Unpacking g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 135s Selecting previously unselected package g++-14. 135s Preparing to unpack .../36-g++-14_14.2.0-19ubuntu2_amd64.deb ... 135s Unpacking g++-14 (14.2.0-19ubuntu2) ... 135s Selecting previously unselected package g++-x86-64-linux-gnu. 135s Preparing to unpack .../37-g++-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 135s Unpacking g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 135s Selecting previously unselected package g++. 135s Preparing to unpack .../38-g++_4%3a14.2.0-1ubuntu1_amd64.deb ... 135s Unpacking g++ (4:14.2.0-1ubuntu1) ... 135s Selecting previously unselected package build-essential. 135s Preparing to unpack .../39-build-essential_12.12ubuntu1_amd64.deb ... 135s Unpacking build-essential (12.12ubuntu1) ... 135s Selecting previously unselected package libllvm20:amd64. 135s Preparing to unpack .../40-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 135s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 136s Selecting previously unselected package libclang-cpp20. 136s Preparing to unpack .../41-libclang-cpp20_1%3a20.1.2-0ubuntu1_amd64.deb ... 136s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 136s Selecting previously unselected package libgc1:amd64. 136s Preparing to unpack .../42-libgc1_1%3a8.2.8-1_amd64.deb ... 136s Unpacking libgc1:amd64 (1:8.2.8-1) ... 136s Selecting previously unselected package libobjc4:amd64. 136s Preparing to unpack .../43-libobjc4_15-20250404-0ubuntu1_amd64.deb ... 136s Unpacking libobjc4:amd64 (15-20250404-0ubuntu1) ... 136s Selecting previously unselected package libobjc-14-dev:amd64. 136s Preparing to unpack .../44-libobjc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 136s Unpacking libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 136s Selecting previously unselected package libclang-common-20-dev:amd64. 136s Preparing to unpack .../45-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 136s Unpacking libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 136s Selecting previously unselected package llvm-20-linker-tools. 136s Preparing to unpack .../46-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 136s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 136s Selecting previously unselected package libclang1-20. 136s Preparing to unpack .../47-libclang1-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 136s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 137s Selecting previously unselected package clang-20. 137s Preparing to unpack .../48-clang-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 137s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 137s Selecting previously unselected package libdebhelper-perl. 137s Preparing to unpack .../49-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 137s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 137s Selecting previously unselected package libtool. 137s Preparing to unpack .../50-libtool_2.5.4-4_all.deb ... 137s Unpacking libtool (2.5.4-4) ... 137s Selecting previously unselected package dh-autoreconf. 137s Preparing to unpack .../51-dh-autoreconf_20_all.deb ... 137s Unpacking dh-autoreconf (20) ... 137s Selecting previously unselected package libarchive-zip-perl. 137s Preparing to unpack .../52-libarchive-zip-perl_1.68-1_all.deb ... 137s Unpacking libarchive-zip-perl (1.68-1) ... 137s Selecting previously unselected package libfile-stripnondeterminism-perl. 137s Preparing to unpack .../53-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 137s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 137s Selecting previously unselected package dh-strip-nondeterminism. 137s Preparing to unpack .../54-dh-strip-nondeterminism_1.14.1-2_all.deb ... 137s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 137s Selecting previously unselected package debugedit. 137s Preparing to unpack .../55-debugedit_1%3a5.1-2_amd64.deb ... 137s Unpacking debugedit (1:5.1-2) ... 137s Selecting previously unselected package dwz. 137s Preparing to unpack .../56-dwz_0.15-1build6_amd64.deb ... 137s Unpacking dwz (0.15-1build6) ... 137s Selecting previously unselected package gettext. 137s Preparing to unpack .../57-gettext_0.23.1-1_amd64.deb ... 137s Unpacking gettext (0.23.1-1) ... 137s Selecting previously unselected package intltool-debian. 137s Preparing to unpack .../58-intltool-debian_0.35.0+20060710.6_all.deb ... 137s Unpacking intltool-debian (0.35.0+20060710.6) ... 137s Selecting previously unselected package po-debconf. 137s Preparing to unpack .../59-po-debconf_1.0.21+nmu1_all.deb ... 137s Unpacking po-debconf (1.0.21+nmu1) ... 137s Selecting previously unselected package debhelper. 137s Preparing to unpack .../60-debhelper_13.24.1ubuntu2_all.deb ... 137s Unpacking debhelper (13.24.1ubuntu2) ... 137s Selecting previously unselected package emacsen-common. 137s Preparing to unpack .../61-emacsen-common_3.0.7_all.deb ... 137s Unpacking emacsen-common (3.0.7) ... 137s Selecting previously unselected package dictionaries-common. 137s Preparing to unpack .../62-dictionaries-common_1.30.10_all.deb ... 137s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 137s Unpacking dictionaries-common (1.30.10) ... 137s Selecting previously unselected package libfakeroot:amd64. 137s Preparing to unpack .../63-libfakeroot_1.37.1-1_amd64.deb ... 137s Unpacking libfakeroot:amd64 (1.37.1-1) ... 137s Selecting previously unselected package fakeroot. 137s Preparing to unpack .../64-fakeroot_1.37.1-1_amd64.deb ... 137s Unpacking fakeroot (1.37.1-1) ... 137s Selecting previously unselected package hunspell-en-us. 137s Preparing to unpack .../65-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 137s Unpacking hunspell-en-us (1:2020.12.07-4) ... 137s Selecting previously unselected package libpgtypes3:amd64. 137s Preparing to unpack .../66-libpgtypes3_17.4-1_amd64.deb ... 137s Unpacking libpgtypes3:amd64 (17.4-1) ... 137s Selecting previously unselected package libpq5:amd64. 137s Preparing to unpack .../67-libpq5_17.4-1_amd64.deb ... 137s Unpacking libpq5:amd64 (17.4-1) ... 137s Selecting previously unselected package libecpg6:amd64. 137s Preparing to unpack .../68-libecpg6_17.4-1_amd64.deb ... 137s Unpacking libecpg6:amd64 (17.4-1) ... 137s Selecting previously unselected package libecpg-compat3:amd64. 137s Preparing to unpack .../69-libecpg-compat3_17.4-1_amd64.deb ... 137s Unpacking libecpg-compat3:amd64 (17.4-1) ... 137s Selecting previously unselected package libssl-dev:amd64. 137s Preparing to unpack .../70-libssl-dev_3.4.1-1ubuntu3_amd64.deb ... 137s Unpacking libssl-dev:amd64 (3.4.1-1ubuntu3) ... 138s Selecting previously unselected package libpq-dev. 138s Preparing to unpack .../71-libpq-dev_17.4-1_amd64.deb ... 138s Unpacking libpq-dev (17.4-1) ... 138s Selecting previously unselected package libecpg-dev. 138s Preparing to unpack .../72-libecpg-dev_17.4-1_amd64.deb ... 138s Unpacking libecpg-dev (17.4-1) ... 138s Selecting previously unselected package libncurses-dev:amd64. 138s Preparing to unpack .../73-libncurses-dev_6.5+20250216-2_amd64.deb ... 138s Unpacking libncurses-dev:amd64 (6.5+20250216-2) ... 138s Selecting previously unselected package libtcl8.6:amd64. 138s Preparing to unpack .../74-libtcl8.6_8.6.16+dfsg-1_amd64.deb ... 138s Unpacking libtcl8.6:amd64 (8.6.16+dfsg-1) ... 138s Selecting previously unselected package libxml2-dev:amd64. 138s Preparing to unpack .../75-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4_amd64.deb ... 138s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4) ... 138s Selecting previously unselected package libxslt1.1:amd64. 138s Preparing to unpack .../76-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 138s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 138s Selecting previously unselected package llvm-20-runtime. 138s Preparing to unpack .../77-llvm-20-runtime_1%3a20.1.2-0ubuntu1_amd64.deb ... 138s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 138s Selecting previously unselected package libpfm4:amd64. 138s Preparing to unpack .../78-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 138s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 138s Selecting previously unselected package llvm-20. 138s Preparing to unpack .../79-llvm-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 138s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 138s Selecting previously unselected package libffi-dev:amd64. 138s Preparing to unpack .../80-libffi-dev_3.4.7-1_amd64.deb ... 138s Unpacking libffi-dev:amd64 (3.4.7-1) ... 138s Selecting previously unselected package llvm-20-tools. 138s Preparing to unpack .../81-llvm-20-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 138s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 138s Selecting previously unselected package llvm-20-dev. 138s Preparing to unpack .../82-llvm-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 139s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 140s Selecting previously unselected package locales-all. 140s Preparing to unpack .../83-locales-all_2.41-6ubuntu1_amd64.deb ... 140s Unpacking locales-all (2.41-6ubuntu1) ... 142s Selecting previously unselected package postgresql-client-17. 142s Preparing to unpack .../84-postgresql-client-17_17.4-1_amd64.deb ... 142s Unpacking postgresql-client-17 (17.4-1) ... 142s Selecting previously unselected package postgresql-17. 142s Preparing to unpack .../85-postgresql-17_17.4-1_amd64.deb ... 142s Unpacking postgresql-17 (17.4-1) ... 142s Selecting previously unselected package postgresql-doc-17. 142s Preparing to unpack .../86-postgresql-doc-17_17.4-1_all.deb ... 142s Unpacking postgresql-doc-17 (17.4-1) ... 142s Selecting previously unselected package postgresql-plperl-17. 142s Preparing to unpack .../87-postgresql-plperl-17_17.4-1_amd64.deb ... 142s Unpacking postgresql-plperl-17 (17.4-1) ... 143s Selecting previously unselected package postgresql-plpython3-17. 143s Preparing to unpack .../88-postgresql-plpython3-17_17.4-1_amd64.deb ... 143s Unpacking postgresql-plpython3-17 (17.4-1) ... 143s Selecting previously unselected package postgresql-pltcl-17. 143s Preparing to unpack .../89-postgresql-pltcl-17_17.4-1_amd64.deb ... 143s Unpacking postgresql-pltcl-17 (17.4-1) ... 143s Selecting previously unselected package postgresql-server-dev-17. 143s Preparing to unpack .../90-postgresql-server-dev-17_17.4-1_amd64.deb ... 143s Unpacking postgresql-server-dev-17 (17.4-1) ... 143s Setting up postgresql-client-common (277) ... 143s Setting up libpgtypes3:amd64 (17.4-1) ... 143s Setting up binutils-gold-x86-64-linux-gnu (2.44-2) ... 143s Setting up libncurses-dev:amd64 (6.5+20250216-2) ... 143s Setting up libio-pty-perl (1:1.20-1build3) ... 143s Setting up libarchive-zip-perl (1.68-1) ... 143s Setting up binutils-gold (2.44-2) ... 143s Setting up libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 143s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 143s Setting up postgresql-doc-17 (17.4-1) ... 143s 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 143s Setting up libpq5:amd64 (17.4-1) ... 143s Setting up m4 (1.4.19-7) ... 143s Setting up libgomp1:amd64 (15-20250404-0ubuntu1) ... 143s Setting up libffi-dev:amd64 (3.4.7-1) ... 143s Setting up locales-all (2.41-6ubuntu1) ... 143s Setting up libfakeroot:amd64 (1.37.1-1) ... 143s Setting up fakeroot (1.37.1-1) ... 143s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 143s Setting up autotools-dev (20220109.1) ... 143s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4) ... 143s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 143s Setting up emacsen-common (3.0.7) ... 143s Setting up ssl-cert (1.1.3ubuntu1) ... 143s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 144s Setting up libquadmath0:amd64 (15-20250404-0ubuntu1) ... 144s Setting up libssl-dev:amd64 (3.4.1-1ubuntu3) ... 144s Setting up libmpc3:amd64 (1.3.1-1build2) ... 144s Setting up libtcl8.6:amd64 (8.6.16+dfsg-1) ... 144s Setting up autopoint (0.23.1-1) ... 144s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 144s Setting up libipc-run-perl (20231003.0-2) ... 144s Setting up libgc1:amd64 (1:8.2.8-1) ... 144s Setting up autoconf (2.72-3ubuntu1) ... 144s Setting up libubsan1:amd64 (15-20250404-0ubuntu1) ... 144s Setting up dwz (0.15-1build6) ... 144s Setting up libhwasan0:amd64 (15-20250404-0ubuntu1) ... 144s Setting up libasan8:amd64 (15-20250404-0ubuntu1) ... 144s Setting up libjson-perl (4.10000-1) ... 144s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 144s Setting up debugedit (1:5.1-2) ... 144s Setting up libecpg6:amd64 (17.4-1) ... 144s Setting up libtsan2:amd64 (15-20250404-0ubuntu1) ... 144s Setting up libisl23:amd64 (0.27-1) ... 144s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 144s Setting up libcc1-0:amd64 (15-20250404-0ubuntu1) ... 144s Setting up liblsan0:amd64 (15-20250404-0ubuntu1) ... 144s Setting up libitm1:amd64 (15-20250404-0ubuntu1) ... 144s Setting up postgresql-common-dev (277) ... 144s Setting up automake (1:1.17-3ubuntu1) ... 144s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 144s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 144s Setting up gettext (0.23.1-1) ... 144s Setting up libecpg-compat3:amd64 (17.4-1) ... 144s Setting up dictionaries-common (1.30.10) ... 144s Setting up postgresql-client-17 (17.4-1) ... 145s 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 145s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 145s Setting up libpq-dev (17.4-1) ... 145s Setting up libobjc4:amd64 (15-20250404-0ubuntu1) ... 145s Setting up libecpg-dev (17.4-1) ... 145s Setting up intltool-debian (0.35.0+20060710.6) ... 145s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 145s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 145s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 145s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 145s Setting up postgresql-common (277) ... 145s Creating config file /etc/postgresql-common/createcluster.conf with new version 145s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 145s en_us 145s Removing obsolete dictionary files: 146s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 146s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 146s Setting up cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 146s Setting up cpp-14 (14.2.0-19ubuntu2) ... 146s Setting up dh-strip-nondeterminism (1.14.1-2) ... 146s Setting up hunspell-en-us (1:2020.12.07-4) ... 146s Setting up libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 146s Setting up libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 146s Setting up cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 146s Setting up postgresql-17 (17.4-1) ... 147s Creating new PostgreSQL cluster 17/main ... 147s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 147s The files belonging to this database system will be owned by user "postgres". 147s This user must also own the server process. 147s 147s The database cluster will be initialized with locale "C.UTF-8". 147s The default database encoding has accordingly been set to "UTF8". 147s The default text search configuration will be set to "english". 147s 147s Data page checksums are disabled. 147s 147s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 147s creating subdirectories ... ok 147s selecting dynamic shared memory implementation ... posix 147s selecting default "max_connections" ... 100 147s selecting default "shared_buffers" ... 128MB 147s selecting default time zone ... Etc/UTC 147s creating configuration files ... ok 147s running bootstrap script ... ok 148s performing post-bootstrap initialization ... ok 148s syncing data to disk ... ok 151s Setting up po-debconf (1.0.21+nmu1) ... 151s Setting up libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 151s Setting up postgresql-plpython3-17 (17.4-1) ... 151s Setting up postgresql-plperl-17 (17.4-1) ... 151s Setting up cpp (4:14.2.0-1ubuntu1) ... 151s Setting up gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 151s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 151s Setting up postgresql-pltcl-17 (17.4-1) ... 151s Setting up gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 151s Setting up libtool (2.5.4-4) ... 151s Setting up gcc-14 (14.2.0-19ubuntu2) ... 151s Setting up dh-autoreconf (20) ... 151s Setting up postgresql-server-dev-17 (17.4-1) ... 151s Setting up g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 151s Setting up g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 151s Setting up g++-14 (14.2.0-19ubuntu2) ... 151s Setting up debhelper (13.24.1ubuntu2) ... 151s Setting up gcc (4:14.2.0-1ubuntu1) ... 151s Setting up g++ (4:14.2.0-1ubuntu1) ... 151s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 151s Setting up build-essential (12.12ubuntu1) ... 151s Processing triggers for libc-bin (2.41-6ubuntu1) ... 151s Processing triggers for systemd (257.4-1ubuntu3) ... 151s Processing triggers for man-db (2.13.0-1) ... 152s Processing triggers for install-info (7.1.1-1) ... 152s Processing triggers for dictionaries-common (1.30.10) ... 155s autopkgtest [14:43:48]: test run-testsuite: [----------------------- 156s ====== Running all tests with umask 077 ======= 156s ### PostgreSQL test 001_packages.t ### 156s 1..23 156s ok 1 - /etc/os-release exists 156s ok 2 - OS is ubuntu 156s ok 3 - OS version is 25.10 156s # PostgreSQL versions installed: 17 156s # 17 156s ok 4 - postgresql-17 installed 156s ok 5 - postgresql-plpython3-17 installed 156s ok 6 - postgresql-plperl-17 installed 156s ok 7 - postgresql-pltcl-17 installed 156s ok 8 # skip No postgresql-17-jit package for version 17 156s ok 9 - postgresql-server-dev-17 installed 156s ok 10 # skip No postgresql-contrib-17 package for version 17 156s # postgresql-doc-17 installed 156s ok 11 - At least one doc package installed 156s ok 12 - libecpg-dev installed 156s ok 13 - postgresql-common-dev installed 156s ok 14 - procps installed 156s ok 15 - netcat-openbsd installed 156s ok 16 - hunspell-en-us installed 156s ok 17 - system has a default UTF-8 locale 156s ok 18 - locale ru_RU exists 156s ok 19 - locale ru_RU.UTF-8 exists 156s ok 20 - user postgres in the UNIX group ssl-cert 156s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 156s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 156s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 156s ### End test 001_packages.t ### 156s 156s ### PostgreSQL test 002_existing_clusters.t ### 156s 1..8 156s # Cleanup 156s ok 1 - Cleanup: No clusters left behind 156s ok 2 - No postgres processes left behind 156s ok 3 - No files in /etc/postgresql left behind 156s ok 4 - No files in /var/lib/postgresql left behind 156s ok 5 - No files in /var/run/postgresql left behind 156s ok 6 - No files in /var/log/postgresql left behind 156s ok 7 - PostgreSQL TCP ports are closed 156s ok 8 - Next free port is 5432 156s ### End test 002_existing_clusters.t ### 156s 156s ### PostgreSQL test 003_alternatives.t ### 156s 1..9 156s # Newest PG version installed is 17 156s ok 1 - psql.1.gz link group 156s ok 2 - postmaster.1.gz link group does not exist 156s ok 3 - psql.1.gz alternative 156s ok 4 - pg_dump.1.gz alternative 156s ok 5 - postgres.1.gz alternative 156s ok 6 - pg_ctl.1.gz alternative 156s # Newest PG doc version installed is 17 156s ok 7 - SPI_connect.3.gz link group 156s ok 8 - SPI_connect.3.gz alternative 156s ok 9 - SPI_exec.3.gz alternative 156s ### End test 003_alternatives.t ### 156s 156s ### PostgreSQL test 005_PgCommon.t ### 156s 1..24 156s ok 1 - correctly parsed line 'local all postgres ident sameuser' 156s ok 2 - correctly parsed line 'local foo nobody trust' 156s ok 3 - correctly parsed line 'local foo nobody crypt' 156s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 156s ok 5 - correctly parsed line 'local foo,bar nobody ident' 156s ok 6 - correctly parsed line 'local all +foogrp password' 156s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 156s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 156s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 156s ok 10 - @expected_records has correct number of entries 156s ok 11 - returned read_pg_hba array has correct number of records 156s ok 12 - line 'foo all all md5' parsed as invalid 156s ok 13 - line 'local all all foo' parsed as invalid 156s ok 14 - line 'host all all foo' parsed as invalid 156s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 156s ok 16 - line 'host all all md5' parsed as invalid 156s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 156s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 156s ok 19 - read_conf_file returns empty dict for nonexisting file 156s ok 20 - read_conf_file() parsing 156s ok 21 - read_conf_file() parsing with include directives 156s ok 22 - set_conf_value 156s ok 23 - disable_conf_value 156s ok 24 - replace_conf_value 156s ### End test 005_PgCommon.t ### 156s 156s ### PostgreSQL test 006_next_free_port.t ### 156s 1..5 156s ok 1 - next_free_port is 5432 157s ok 2 - next_free_port detects localhost ipv4 socket 158s ok 3 - next_free_port detects wildcard ipv4 socket 159s ok 4 - next_free_port detects localhost ipv6 socket 160s ok 5 - next_free_port detects wildcard ipv6 socket 160s ### End test 006_next_free_port.t ### 160s 160s ### PostgreSQL test 007_pg_conftool.t ### 160s 1..41 160s # test without cluster 161s ok 1 - pg_conftool show all 161s ok 2 - correct output of pg_conftool show all 161s ok 3 - pg_conftool foo.conf show all 161s ok 4 - correct output of pg_conftool foo.conf show all 161s ok 5 - pg_conftool /tmp/2jhciFS8M_/different.conf show all 161s ok 6 - correct output of pg_conftool /tmp/2jhciFS8M_/different.conf show all 161s ok 7 - pg_conftool 9.7 main show all 161s ok 8 - correct output of pg_conftool 9.7 main show all 161s # test show 161s ok 9 - pg_conftool show all 161s ok 10 - correct output of pg_conftool show all 161s ok 11 - pg_conftool other.conf show all 161s ok 12 - correct output of pg_conftool other.conf show all 161s ok 13 - pg_conftool /tmp/2jhciFS8M_/different.conf show all 161s ok 14 - correct output of pg_conftool /tmp/2jhciFS8M_/different.conf show all 161s ok 15 - pg_conftool 17 main show all 161s ok 16 - correct output of pg_conftool 17 main show all 161s ok 17 - pg_conftool 17 main other.conf show all 161s ok 18 - correct output of pg_conftool 17 main other.conf show all 161s ok 19 - pg_conftool show a 161s ok 20 - correct output of pg_conftool show a 161s ok 21 - pg_conftool -s show a 161s ok 22 - correct output of pg_conftool -s show a 161s # test set 161s ok 23 - pg_conftool set c 7 161s ok 24 - correct output of pg_conftool set c 7 161s ok 25 - file contains new setting 161s ok 26 - pg_conftool set a 8 161s ok 27 - correct output of pg_conftool set a 8 161s ok 28 - file contains updated setting 161s ok 29 - pg_conftool /tmp/2jhciFS8M_/different.conf set a 9 161s ok 30 - correct output of pg_conftool /tmp/2jhciFS8M_/different.conf set a 9 161s ok 31 - file with path contains updated setting 161s # test remove 161s ok 32 - pg_conftool remove a 161s ok 33 - correct output of pg_conftool remove a 161s ok 34 - setting removed from file 161s ok 35 - pg_conftool /tmp/2jhciFS8M_/different.conf remove a 161s ok 36 - correct output of pg_conftool /tmp/2jhciFS8M_/different.conf remove a 161s ok 37 - setting removed from file with path 161s # test edit 161s ok 38 - pg_conftool edit 161s ok 39 - correct output of pg_conftool edit 161s ok 40 - pg_conftool /tmp/2jhciFS8M_/different.conf edit 161s ok 41 - correct output of pg_conftool /tmp/2jhciFS8M_/different.conf edit 161s ### End test 007_pg_conftool.t ### 161s 161s ### PostgreSQL test 010_defaultport_cluster.t ### 161s 1..14 161s ok 1 - psql --version 161s ok 2 - pg_wrapper selects highest available version number 161s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 161s ok 4 - connecting to localhost fails with no clusters 161s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 161s ok 6 - pg_wrapper uses host and port from PGCLUSTER 161s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 161s ok 8 - pg_wrapper uses --cluster from the command line 161s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 161s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 161s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 161s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 161s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 161s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 161s ### End test 010_defaultport_cluster.t ### 161s 161s ### PostgreSQL test 015_start_stop.t ### 162s 1..71 162s # We are running systemd 162s # Running tests for 17 162s # Cluster does not exist yet 162s ok 1 - cluster 17 main does not exist 162s ok 2 - service postgresql@17-main does not exist 162s ok 3 - systemctl start postgresql 162s ok 4 - cluster 17 main does not exist 162s ok 5 - service postgresql@17-main does not exist 162s ok 6 - systemctl start postgresql@17-main 162s ok 7 - cluster 17 main does not exist 162s ok 8 - service postgresql@17-main does not exist 162s # Start/stop postgresql using system tools 163s ok 9 - pg_createcluster 17 main 163s ok 10 - cluster 17 main is stopped 163s ok 11 - service postgresql@17-main is stopped 165s ok 12 - systemctl start postgresql 165s ok 13 - cluster 17 main is running 165s ok 14 - service postgresql@17-main is running 165s ok 15 - systemctl start postgresql 165s ok 16 - cluster 17 main is already running 165s ok 17 - service postgresql@17-main is already running 165s ok 18 - systemctl stop postgresql 171s ok 19 - cluster 17 main is stopped 171s ok 20 - service postgresql@17-main is stopped 171s ok 21 - systemctl stop postgresql 171s ok 22 - cluster 17 main is already stopped 171s ok 23 - service postgresql@17-main is already stopped 171s # Start/stop specific cluster using system tools 174s ok 24 - systemctl start postgresql@17-main 174s ok 25 - cluster 17 main is running 174s ok 26 - service postgresql@17-main is running 174s ok 27 - systemctl start postgresql@17-main 174s ok 28 - cluster 17 main is running 174s ok 29 - service postgresql@17-main is running 176s ok 30 - systemctl restart postgresql@17-main 176s ok 31 - cluster 17 main is running 176s ok 32 - service postgresql@17-main is running 176s ok 33 - systemctl stop postgresql@17-main 176s ok 34 - cluster 17 main is stopped 176s ok 35 - service postgresql@17-main is stopped 176s ok 36 - systemctl stop postgresql@17-main 177s ok 37 - cluster 17 main is already stopped 177s ok 38 - service postgresql@17-main is already stopped 178s ok 39 - pg_dropcluster 17 main 178s ok 40 - cluster 17 main does not exist 178s ok 41 - service postgresql@17-main does not exist 178s # Start/stop specific cluster using pg_*cluster 178s ok 42 - pg_ctlcluster start 17 main 178s ok 43 - cluster 17 main does not exist 178s ok 44 - service postgresql@17-main does not exist 182s ok 45 - pg_createcluster 17 main --start 182s ok 46 - cluster 17 main is running 182s ok 47 - service postgresql@17-main is running 182s ok 48 - pg_ctlcluster 17 main start 182s ok 49 - cluster 17 main is already running 182s ok 50 - service postgresql@17-main is already running 184s ok 51 - pg_ctlcluster 17-main restart 184s ok 52 - cluster 17 main is running 184s ok 53 - service postgresql@17-main is running 184s ok 54 - pg_ctlcluster 17 main stop 185s ok 55 - cluster 17 main is stopped 185s ok 56 - service postgresql@17-main is stopped 185s ok 57 - pg_ctlcluster 17 main stop 185s ok 58 - cluster 17 main is already stopped 185s ok 59 - service postgresql@17-main is already stopped 187s ok 60 - pg_ctlcluster start 17-main 187s ok 61 - cluster 17 main is running 187s ok 62 - service postgresql@17-main is running 189s ok 63 - pg_dropcluster 17 main --stop 189s # Cleanup 189s ok 64 - Cleanup: No clusters left behind 189s ok 65 - No postgres processes left behind 189s ok 66 - No files in /etc/postgresql left behind 189s ok 67 - No files in /var/lib/postgresql left behind 189s ok 68 - No files in /var/run/postgresql left behind 189s ok 69 - No files in /var/log/postgresql left behind 189s ok 70 - PostgreSQL TCP ports are closed 189s ok 71 - Next free port is 5432 189s ### End test 015_start_stop.t ### 189s 189s ### PostgreSQL test 020_create_sql_remove.t ### 189s 1..141 189s # Running tests for 17 192s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.J1hehp 192s ok 2 - pg_createcluster 17 main 192s ok 3 - Socket and pid file are in /var/run/postgresql/ 192s ok 4 - xlog/wal directory /tmp/17.xlog.J1hehp was created 192s ok 5 - local method in pg_hba.conf is peer 192s ok 6 - host method in pg_hba.conf is scram-sha-256 192s ok 7 - Exactly one postgres master process running 194s ok 8 - pg_ctlcluster 17 main restart 194s ok 9 - cluster restarts with new environment file 194s ok 10 - Exactly one postgres master process running 194s ok 11 - correct value of PGEXTRAVAR1 in environment 194s ok 12 - correct value of PGEXTRAVAR2 in environment 194s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 195s ok 14 - createdb --version 195s ok 15 - pg_wrapper+createdb selects version number of cluster 195s ok 16 - psql --version 195s ok 17 - pg_wrapper+psql selects version 17 195s ok 18 - pg_lscluster reports online cluster on port 5432 195s ok 19 - log file is actually used 195s ok 20 - /etc/postgresql is owned by user "postgres" 195s ok 21 - version configuration directory file is owned by user "postgres" 195s ok 22 - configuration directory file is owned by user "postgres" 195s ok 23 - version data directory file is owned by user "postgres" 195s ok 24 - data directory file is owned by user "postgres" 195s ok 25 - log file has 0640 permissions 195s ok 26 - log file is owned by user "postgres" 195s ok 27 - log file is owned by group "adm" 195s ok 28 - no log symlink by default 195s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 195s ok 30 - pg_lsclusters -h 195s ok 31 - correct output of pg_lsclusters -h 195s ok 32 - stopping cluster 198s ok 33 - restarting cluster with nondefault log symlink 198s ok 34 - log target is used as log file 198s ok 35 - default log is not used 198s ok 36 - pg_lsclusters -h 198s ok 37 - correct output of pg_lsclusters -h 198s ok 38 - stopping cluster 200s ok 39 - restarting cluster with explicitly configured log file 200s ok 40 - default log is not used 200s ok 41 - log symlink target is used for startup message 200s ok 42 - exactly one log file 200s ok 43 - custom log is actually used 200s ok 44 - pg_lsclusters -h 200s ok 45 - correct output of pg_lsclusters -h 201s ok 46 - stopping cluster 201s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 201s ok 48 - /etc/postgres-hack was not created 203s ok 49 - restarting cluster 203s ok 50 - ps -o tty -U postgres h 203s ok 51 - postgres processes do not have an associated terminal 203s ok 52 - Server is linked with SSL support 203s ok 53 - SSL is enabled in postgresql.conf 203s ok 54 - psql -l fails for nobody 203s ok 55 - createuser nobody 203s ok 56 - createdb nobodydb 203s ok 57 - psql -ltA succeeds for nobody 203s ok 58 - psql -ltA output 203s ok 59 - SQL command: create table 203s ok 60 - SQL command: insert into table values 203s ok 61 - SQL command: insert into table values 203s ok 62 - primary key violation 203s ok 63 - psql -tAc "select * from phone order by name" nobodydb 203s ok 64 - SQL command output: select -tA 203s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 203s ok 66 - SQL command output: select -tx 203s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 203s ok 68 - SQL command output: select -tAx 203s ok 69 - CREATE EXTENSION plperlu fails for user nobody 204s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 204s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 204s ok 72 - creating PL/PerlU function as user nobody fails 204s ok 73 - creating unsafe PL/Perl function as user postgres fails 204s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 204s ok 75 - creating PL/PerlU function as user postgres succeeds 204s ok 76 - psql nobodydb -Atc "select read_file()" 204s ok 77 - calling PL/PerlU function 204s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 204s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 204s ok 80 - creating unsafe PL/Perl function as user nobody fails 204s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 204s ok 82 - creating PL/Perl function as user nobody succeeds 204s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 204s ok 84 - calling PL/Perl function 204s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 204s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 204s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 204s ok 88 - creating PL/Python3 function as user postgres succeeds 204s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 204s ok 90 - calling PL/Python function 204s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 204s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 204s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 204s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 204s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 204s ok 96 - creating PL/Tcl function as user nobody succeeds 204s 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;" 204s ok 98 - creating PL/TclU function as user postgres succeeds 204s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 204s ok 100 - calling PL/Tcl function 205s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 205s ok 102 - calling PL/TclU function 205s ok 103 - stopping cluster 205s ok 104 - pg_ctlcluster 17 main start 205s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 207s ok 106 - pg_ctlcluster 17 main start 207s ok 107 - cluster restarts with pgdata symlink 207s ok 108 - postgres master has OOM killer protection 207s ok 109 - postgres client backend has no OOM adjustment 207s ok 110 - ps h 7007 207s ok 111 - process title is idle 208s ok 112 - ps h 7007 208s ok 113 - process title is idle in transaction 208s ok 114 - stopping cluster 210s ok 115 - starting cluster as postgres works without a log file 210s ok 116 - log file got recreated and used 210s ok 117 - creating a directory in spc2 210s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.hzAYE0'" 210s ok 119 - creating tablespace spc1 210s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 210s ok 121 - creating a table in spc1 211s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.aTWl9O'" 211s ok 123 - creating tablespace spc2 211s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 211s ok 125 - creating a table in spc2 211s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 211s ok 127 - Correct apt NeverAutoRemove config 212s ok 128 - pg_dropcluster removes cluster 212s ok 129 - xlog/wal directory /tmp/17.xlog.J1hehp was deleted 212s ok 130 - tablespace spc1 was emptied 212s ok 131 - tablespace spc2 was emptied 212s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 212s ok 133 - Correct apt NeverAutoRemove config 212s # Cleanup 212s ok 134 - Cleanup: No clusters left behind 212s ok 135 - No postgres processes left behind 212s ok 136 - No files in /etc/postgresql left behind 212s ok 137 - No files in /var/lib/postgresql left behind 212s ok 138 - No files in /var/run/postgresql left behind 212s ok 139 - No files in /var/log/postgresql left behind 212s ok 140 - PostgreSQL TCP ports are closed 212s ok 141 - Next free port is 5432 212s ### End test 020_create_sql_remove.t ### 212s 212s ### PostgreSQL test 021_pg_renamecluster.t ### 212s 1..20 216s ok 1 - pg_createcluster 17 main 218s ok 2 - pg_renamecluster 17 main donau 218s ok 3 - psql -tAc "show data_directory" 218s ok 4 - cluster is running and data_directory was moved 218s ok 5 - pg_hba.conf location updated 218s ok 6 - pg_ident.conf location updated 218s ok 7 - external_pid_file location updated 218s ok 8 - external_pid_file exists 218s ok 9 # skip no stats_temp_directory in 17 218s ok 10 # skip no stats_temp_directory in 17 218s ok 11 - cluster_name is updated 220s ok 12 - pg_dropcluster removes cluster 220s # Cleanup 220s ok 13 - Cleanup: No clusters left behind 220s ok 14 - No postgres processes left behind 220s ok 15 - No files in /etc/postgresql left behind 220s ok 16 - No files in /var/lib/postgresql left behind 220s ok 17 - No files in /var/run/postgresql left behind 220s ok 18 - No files in /var/log/postgresql left behind 220s ok 19 - PostgreSQL TCP ports are closed 220s ok 20 - Next free port is 5432 220s ### End test 021_pg_renamecluster.t ### 220s 220s ### PostgreSQL test 022_recovery.t ### 220s 1..17 220s # Running tests for 17 223s ok 1 - pg_createcluster 17 main --start >/dev/null 224s ok 2 - pg_ctlcluster 17 main stop -m i 226s ok 3 - pg_ctlcluster 17 main start 226s ok 4 - psql -c '' 226s ok 5 - pg_ctlcluster 17 main stop -m i 226s ok 6 - create write-protected file in data directory 229s ok 7 - pg_ctlcluster 17 main start 229s ok 8 - psql -c '' 230s ok 9 - pg_dropcluster removes cluster 230s # Cleanup 231s ok 10 - Cleanup: No clusters left behind 231s ok 11 - No postgres processes left behind 231s ok 12 - No files in /etc/postgresql left behind 231s ok 13 - No files in /var/lib/postgresql left behind 231s ok 14 - No files in /var/run/postgresql left behind 231s ok 15 - No files in /var/log/postgresql left behind 231s ok 16 - PostgreSQL TCP ports are closed 231s ok 17 - Next free port is 5432 231s ### End test 022_recovery.t ### 231s 231s ### PostgreSQL test 025_logging.t ### 231s 1..55 231s # Logging to /var/log/syslog works 231s # Running tests for 17 234s ok 1 - pg_createcluster 17 main 234s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 234s ok 3 - psql -qc "'foobar_17_8219'" 234s ok 4 - log an error 235s ok 5 - grep --binary-files=text foobar_17_8219 /var/log/postgresql/postgresql-17-main.log 235s ok 6 - error appears in logfile 235s ok 7 - pg_conftool 17 main set log_destination syslog 235s ok 8 - set log_destination syslog 235s ok 9 - pg_ctlcluster 17 main reload 235s ok 10 - 17 main reload 235s ok 11 - psql -Atc "show log_destination" 235s ok 12 - log_destination is syslog 235s ok 13 - pg_lscluster reports syslog 236s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 236s ok 15 - error appears in /var/log/syslog 236s ok 16 - pg_conftool 17 main set logging_collector on 236s ok 17 - set logging_collector on 236s ok 18 - pg_conftool 17 main set log_destination csvlog 236s ok 19 - set log_destination csvlog 239s ok 20 - pg_ctlcluster 17 main restart 239s ok 21 - 17 main restart 239s ok 22 - psql -Atc "show logging_collector" 239s ok 23 - logging_collector is on 239s ok 24 - psql -Atc "show log_destination" 239s ok 25 - log_destination is csvlog 239s ok 26 - pg_lscluster reports csvlog 239s ok 27 - psql -qc "'barbaz_17_8219'" 239s ok 28 - log an error 239s ok 29 - grep --binary-files=text barbaz_17_8219 /var/lib/postgresql/17/main/log/*.csv 239s ok 30 - error appears in log/*.csv 239s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 239s ok 32 - set log_destination stderr,syslog,csvlog 239s ok 33 - pg_ctlcluster 17 main reload 239s ok 34 - 17 main reload 239s ok 35 - psql -Atc "show log_destination" 239s ok 36 - log_destination is stderr,syslog,csvlog 239s ok 37 - pg_lscluster reports stderr,syslog,csvlog 239s ok 38 - psql -qc "'moo_17_8219'" 239s ok 39 - log an error 240s ok 40 - grep --binary-files=text moo_17_8219 /var/lib/postgresql/17/main/log/*.log 240s ok 41 - error appears in log/*.log 240s ok 42 - grep --binary-files=text 'postgres.*moo_17_8219' /var/log/syslog 240s ok 43 - error appears in /var/log/syslog 240s ok 44 - grep --binary-files=text moo_17_8219 /var/lib/postgresql/17/main/log/*.csv 240s ok 45 - error appears in log/*.csv 242s ok 46 - pg_dropcluster 17 main --stop 242s ok 47 - pg_dropcluster removes cluster 242s # Cleanup 242s ok 48 - Cleanup: No clusters left behind 242s ok 49 - No postgres processes left behind 242s ok 50 - No files in /etc/postgresql left behind 242s ok 51 - No files in /var/lib/postgresql left behind 242s ok 52 - No files in /var/run/postgresql left behind 242s ok 53 - No files in /var/log/postgresql left behind 242s ok 54 - PostgreSQL TCP ports are closed 242s ok 55 - Next free port is 5432 242s ### End test 025_logging.t ### 242s 242s ### PostgreSQL test 027_jit.t ### 242s # 17 245s ok 1 - pg_createcluster 17 main --start 245s ok 2 - psql -Xatc 'show jit' 245s ok 3 - JIT is on by default 245s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 245s ok 5 - No JIT on cheap query 245s ok 6 - pg_conftool 17 main set seq_page_cost 100000 245s ok 7 - pg_conftool 17 main set random_page_cost 100000 245s ok 8 - pg_ctlcluster 17 main reload 246s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 246s ok 10 - Expensive query is JITed 247s ok 11 - pg_dropcluster --stop 17 main 247s # Cleanup 247s ok 12 - Cleanup: No clusters left behind 247s ok 13 - No postgres processes left behind 247s ok 14 - No files in /etc/postgresql left behind 247s ok 15 - No files in /var/lib/postgresql left behind 247s ok 16 - No files in /var/run/postgresql left behind 247s ok 17 - No files in /var/log/postgresql left behind 247s ok 18 - PostgreSQL TCP ports are closed 247s ok 19 - Next free port is 5432 247s 1..19 247s ### End test 027_jit.t ### 247s 247s ### PostgreSQL test 030_errors.t ### 247s 1..156 247s ok 1 - pg_lscluster reports cluster without binaries 249s ok 2 - pg_dropcluster 6.3 main 250s ok 3 - pg_createcluster --socketdir 250s ok 4 - pg_lsclusters -h 250s ok 5 - cluster was created 250s ok 6 - Port of created cluster is 5432 250s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 250s ok 8 - pg_createcluster on existing cluster 250s ok 9 - pg_lsclusters -h 250s ok 10 - original cluster still exists 250s ok 11 - pg_createcluster 17 test -p foo 250s ok 12 - pg_createcluster -p checks that port option is numeric 250s ok 13 - pg_createcluster 17 test -p 42 250s ok 14 - pg_createcluster -p checks valid port range 250s ok 15 - pg_ctlcluster 17 main start 250s ok 16 - pg_ctlcluster refuses to start root-owned cluster 250s ok 17 - pg_ctlcluster 17 main start 250s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 250s ok 19 - pg_ctlcluster 17 main start 250s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 250s ok 21 - pg_ctlcluster 17 main start 250s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 252s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 252s ok 24 - No sockets in /var/run/postgresql 252s ok 25 - Socket is in /tmp/postgresql-testsuite/ 253s ok 26 - cluster stops with custom unix_socket_dir 253s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 255s ok 28 - cluster starts after removing unix_socket_dir 255s ok 29 - Socket is in default dir /var/run/postgresql 255s ok 30 - No sockets in /tmp/postgresql-testsuite/ 255s ok 31 - pg_ctlcluster 17 main stop 255s ok 32 - pg_ctlcluster fails with corrupted PID file 255s ok 33 - pg_lsclusters -h 255s ok 34 - cluster is still online 255s ok 35 - pg_ctlcluster succeeds with restored PID file 255s ok 36 - pg_lsclusters -h 255s ok 37 - cluster is down 255s ok 38 - pg_ctlcluster 17 main stop 255s ok 39 - pg_ctlcluster stop fails on stopped cluster 258s ok 40 - pg_ctlcluster 17 main start 258s ok 41 - pg_ctlcluster succeeds with already existing PID file 258s ok 42 - pg_lsclusters -h 258s ok 43 - cluster is online 258s ok 44 - pg_ctlcluster stop succeeds 258s ok 45 - pg_lsclusters -h 258s ok 46 - cluster is down 258s ok 47 - no pid file left 258s ok 48 - pg_ctlcluster 17 main stop 258s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 258s ok 50 - pid file was cleaned up 258s ok 51 - pg_ctlcluster --force 17 main stop 258s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 258s ok 53 - pid file was cleaned up 258s ok 54 - pg_ctlcluster 17 main stop 258s ok 55 - pg_ctlcluster stop succeeds with stale PID file 258s ok 56 - pid file was cleaned up 258s ok 57 - pg_ctlcluster --force 17 main stop 258s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 258s ok 59 - pid file was cleaned up 258s ok 60 - pg_ctlcluster --force 17 main stop 258s ok 61 - pg_ctlcluster stop succeeds with empty PID file 258s ok 62 - pid file was cleaned up 260s ok 63 - pg_ctlcluster 17 main start 260s ok 64 - pg_ctlcluster succeeds with corrupted PID file 260s ok 65 - pg_lsclusters -h 260s ok 66 - cluster is online 260s ok 67 - pg_ctlcluster 17 main start 260s ok 68 - pg_ctlcluster start fails on running cluster 260s ok 69 - pg_ctlcluster stop 261s ok 70 - pg_ctlcluster 17 main start 261s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 261s ok 72 - pg_ctlcluster 17 main stop 261s ok 73 - stopping cluster 267s ok 74 - pg_ctlcluster 17 main start 267s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 267s ok 76 - pg_ctlcluster 17 main stop 267s ok 77 - stopping cluster 267s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 267s ok 79 - pg_dropcluster 17 main 267s ok 80 - pg_dropcluster works as user postgres 268s ok 81 - pg_createcluster succeeds 268s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 268s ok 83 - proper error message for nonexisting /var/lib/postgresql 270s ok 84 - pg_ctlcluster 17 main start 270s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 271s ok 86 - pg_ctlcluster 17 main stop 271s ok 87 - stopping cluster 272s ok 88 - pg_createcluster other 274s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 276s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 276s ok 91 276s ok 92 - pg_ctlcluster 17 other start 276s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 277s ok 94 - pg_ctlcluster 17 main stop 277s ok 95 - stopping main cluster 279s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 280s ok 97 - pg_dropcluster other 282s ok 98 - pg_dropcluster 282s ok 99 - No sockets any more 282s ok 100 - 'pg_lsclusters 4.5 foo' fails 282s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 282s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 282s ok 103 - 'psql --cluster 4.5/foo' fails 282s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 282s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 282s ok 106 - 'psql --cluster 17/foo' fails 282s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 282s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 282s ok 109 - 'pg_dropcluster 4.5 foo' fails 282s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 282s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 282s ok 112 - 'pg_dropcluster 17 foo' fails 282s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 282s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 282s ok 115 - 'pg_upgradecluster 4.5 foo' fails 282s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 282s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 282s ok 118 - 'pg_upgradecluster 17 foo' fails 282s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 282s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 282s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 282s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 282s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 282s ok 124 - 'pg_ctlcluster 17 foo stop' fails 282s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 282s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 282s # Cleanup 282s ok 127 - Cleanup: No clusters left behind 282s ok 128 - No postgres processes left behind 282s ok 129 - No files in /etc/postgresql left behind 282s ok 130 - No files in /var/lib/postgresql left behind 282s ok 131 - No files in /var/run/postgresql left behind 282s ok 132 - No files in /var/log/postgresql left behind 282s ok 133 - PostgreSQL TCP ports are closed 282s ok 134 - Next free port is 5432 283s ok 135 - pg_dropcluster 17 broken 283s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 283s # Cleanup 283s ok 137 - Cleanup: No clusters left behind 283s ok 138 - No postgres processes left behind 283s ok 139 - No files in /etc/postgresql left behind 283s ok 140 - No files in /var/lib/postgresql left behind 283s ok 141 - No files in /var/run/postgresql left behind 283s ok 142 - No files in /var/log/postgresql left behind 283s ok 143 - PostgreSQL TCP ports are closed 283s ok 144 - Next free port is 5432 285s ok 145 - pg_dropcluster 17 broken 285s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 285s ok 147 - /etc/postgresql/17 was removed 285s ok 148 - /var/lib/postgresql/17 was removed 285s # Cleanup 285s ok 149 - Cleanup: No clusters left behind 285s ok 150 - No postgres processes left behind 285s ok 151 - No files in /etc/postgresql left behind 285s ok 152 - No files in /var/lib/postgresql left behind 285s ok 153 - No files in /var/run/postgresql left behind 285s ok 154 - No files in /var/log/postgresql left behind 285s ok 155 - PostgreSQL TCP ports are closed 285s ok 156 - Next free port is 5432 285s ### End test 030_errors.t ### 285s 285s ### PostgreSQL test 031_errors_disk_full.t ### 285s 1..22 285s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 286s ok 1 - script failed 286s ok 2 - pg_createcluster fails due to insufficient disk space 286s ok 3 - does not leave files behind 286s # Cleanup 286s ok 4 - Cleanup: No clusters left behind 286s ok 5 - No postgres processes left behind 286s ok 6 - No files in /etc/postgresql left behind 286s ok 7 - No files in /var/lib/postgresql left behind 286s ok 8 - No files in /var/run/postgresql left behind 286s ok 9 - No files in /var/log/postgresql left behind 286s ok 10 - PostgreSQL TCP ports are closed 286s ok 11 - Next free port is 5432 286s # check disk full conditions on startup 289s ok 12 - script failed 289s ok 13 - pg_ctlcluster prints error message 289s ok 14 - log file has error message 289s # Cleanup 289s ok 15 - Cleanup: No clusters left behind 289s ok 16 - No postgres processes left behind 289s ok 17 - No files in /etc/postgresql left behind 289s ok 18 - No files in /var/lib/postgresql left behind 289s ok 19 - No files in /var/run/postgresql left behind 289s ok 20 - No files in /var/log/postgresql left behind 289s ok 21 - PostgreSQL TCP ports are closed 289s ok 22 - Next free port is 5432 289s ### End test 031_errors_disk_full.t ### 289s 289s ### PostgreSQL test 032_ssl_key_permissions.t ### 289s 1..22 289s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 289s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 289s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 290s ok 4 - pg_createcluster 17 main 290s ok 5 - pg_ctlcluster 17 main start 290s ok 6 - ssl key owned by nobody refused 291s ok 7 - pg_ctlcluster 17 main start 291s ok 8 - ssl key with permissions root:root 0644 refused 291s ok 9 - pg_ctlcluster 17 main start 291s ok 10 - ssl key with permissions postgres:postgres 0640 refused 292s ok 11 - pg_dropcluster 17 main --stop 292s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 292s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 292s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 292s # Cleanup 292s ok 15 - Cleanup: No clusters left behind 292s ok 16 - No postgres processes left behind 292s ok 17 - No files in /etc/postgresql left behind 292s ok 18 - No files in /var/lib/postgresql left behind 292s ok 19 - No files in /var/run/postgresql left behind 292s ok 20 - No files in /var/log/postgresql left behind 292s ok 21 - PostgreSQL TCP ports are closed 292s ok 22 - Next free port is 5432 292s ### End test 032_ssl_key_permissions.t ### 292s 292s ### PostgreSQL test 040_upgrade.t ### 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s ### End test 040_upgrade.t ### 292s 292s ### PostgreSQL test 041_upgrade_custompaths.t ### 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s ### End test 041_upgrade_custompaths.t ### 292s 292s ### PostgreSQL test 042_upgrade_rename.t ### 293s 1..15 293s # PostgreSQL 17 296s ok 1 - pg_createcluster 17 main --start 302s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 302s ok 3 - pg_lsclusters -h 302s ok 4 - correct output of pg_lsclusters -h 304s ok 5 - pg_dropcluster 17 main --stop 305s ok 6 - pg_dropcluster 17 upgr --stop 305s ok 7 - Cleaning pg_upgrade log files 305s # Cleanup 305s ok 8 - Cleanup: No clusters left behind 305s ok 9 - No postgres processes left behind 305s ok 10 - No files in /etc/postgresql left behind 305s ok 11 - No files in /var/lib/postgresql left behind 305s ok 12 - No files in /var/run/postgresql left behind 305s ok 13 - No files in /var/log/postgresql left behind 305s ok 14 - PostgreSQL TCP ports are closed 305s ok 15 - Next free port is 5432 305s ### End test 042_upgrade_rename.t ### 305s 305s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 305s 1..1 305s ok 1 - only one major version installed, skipping upgrade tests 305s ### End test 043_upgrade_ssl_cert.t ### 305s 305s ### PostgreSQL test 045_backup.t ### 305s # We are running systemd 305s # PostgreSQL 17 305s # create cluster 309s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 309s ok 2 - pg_lsclusters -h 309s ok 3 - correct output of pg_lsclusters -h 309s ok 4 - pg_conftool 17 main set work_mem 11MB 309s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 309s ok 6 - psql -c 'alter database mydb set search_path=public' 309s ok 7 - psql -c 'create table foo (t text)' mydb 309s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 309s ok 9 - psql -c 'CREATE USER myuser' 309s ok 10 - psql -c 'grant create on database mydb to myuser' 309s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 309s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 309s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 309s # create directory 309s ok 14 - pg_backupcluster 17 main createdirectory 309s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 309s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 309s # dump 310s ok 17 - systemctl start pg_dump@17-main 310s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-03T144622Z.dump 310s ok 19 - /var/backups/postgresql/17-main/2025-05-03T144622Z.dump owned by uid postgres 310s ok 20 - /var/backups/postgresql/17-main/2025-05-03T144622Z.dump owned by gid postgres 310s # basebackup 310s ok 21 - systemctl start pg_receivewal@17-main 310s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 310s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 311s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 311s ok 25 - psql -c 'select pg_reload_conf()' 339s ok 26 - systemctl start pg_basebackup@17-main 339s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-03T144624Z.backup 339s ok 28 - /var/backups/postgresql/17-main/2025-05-03T144624Z.backup owned by uid postgres 339s ok 29 - /var/backups/postgresql/17-main/2025-05-03T144624Z.backup owned by gid postgres 339s # list 339s ok 30 - pg_backupcluster 17 main list 339s ok 31 - correct output of pg_backupcluster 17 main list 339s # more database changes 339s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 339s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 339s ok 34 - retrieve recovery timestamp 339s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 340s ok 36 - systemctl stop pg_receivewal@17-main 340s # restore /var/backups/postgresql/17-main/2025-05-03T144622Z.dump 341s ok 37 - pg_dropcluster 17 main --stop 346s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T144622Z.dump --start --datadir /var/lib/postgresql/17/snowflake 346s ok 39 - pg_lsclusters -h 346s ok 40 - correct output of pg_lsclusters -h 346s ok 41 - psql -XAtl 346s ok 42 - mydb locales 346s ok 43 - mydb grants 346s ok 44 - myicudb locales 346s ok 45 - psql -XAtc 'show work_mem' 346s ok 46 - correct output of psql -XAtc 'show work_mem' 346s ok 47 - psql -XAtc 'select * from foo' mydb 346s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 346s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 346s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 346s ok 51 - psql -XAtc '\drds' 346s ok 52 - correct output of psql -XAtc '\drds' 346s # restore /var/backups/postgresql/17-main/2025-05-03T144624Z.backup 348s ok 53 - pg_dropcluster 17 main --stop 351s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T144624Z.backup --start --datadir /var/lib/postgresql/17/snowflake 351s ok 55 - pg_lsclusters -h 351s ok 56 - correct output of pg_lsclusters -h 351s ok 57 - psql -XAtl 351s ok 58 - mydb locales 351s ok 59 - mydb grants 351s ok 60 - myicudb locales 351s ok 61 - psql -XAtc 'show work_mem' 351s ok 62 - correct output of psql -XAtc 'show work_mem' 351s ok 63 - psql -XAtc 'select * from foo' mydb 351s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 351s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 351s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 351s ok 67 - psql -XAtc '\drds' 351s ok 68 - correct output of psql -XAtc '\drds' 351s # restore /var/backups/postgresql/17-main/2025-05-03T144624Z.backup with WAL archive 353s ok 69 - pg_dropcluster 17 main --stop 356s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T144624Z.backup --start --archive --port 5430 356s ok 71 - pg_lsclusters -h 356s ok 72 - correct output of pg_lsclusters -h 356s ok 73 - psql -XAtc 'select * from foo order by t' mydb 356s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 356s # restore /var/backups/postgresql/17-main/2025-05-03T144624Z.backup with PITR 358s ok 75 - pg_dropcluster 17 main --stop 362s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T144624Z.backup --start --pitr '2025-05-03 14:46:52.427549+00 362s # ' 362s ok 77 - pg_lsclusters -h 362s ok 78 - correct output of pg_lsclusters -h 362s ok 79 - psql -XAtc 'select * from foo order by t' mydb 362s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 364s ok 81 - pg_dropcluster 17 main --stop 364s # Cleanup 364s ok 82 - Cleanup: No clusters left behind 364s ok 83 - No postgres processes left behind 364s ok 84 - No files in /etc/postgresql left behind 364s ok 85 - No files in /var/lib/postgresql left behind 364s ok 86 - No files in /var/run/postgresql left behind 364s ok 87 - No files in /var/log/postgresql left behind 364s ok 88 - PostgreSQL TCP ports are closed 364s ok 89 - Next free port is 5432 364s 1..89 364s ### End test 045_backup.t ### 364s 364s ### PostgreSQL test 050_encodings.t ### 364s 1..60 364s # Checking 17 ru_RU 367s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 368s ok 2 - psql -l succeeds 368s ok 3 - template1 is not UTF-8 encoded 368s ok 4 - creating test database 368s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 368s # create table t (x varchar); copy t from stdin" test 368s ok 6 - creating table with ISO-8859-5 characters 368s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 368s ok 8 - correct string in UTF-8 368s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 368s ok 10 - correct string in ISO-8859-5 368s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 368s # delete from t; copy t from stdin" test 368s ok 12 - creating table with UTF-8 characters 368s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 368s ok 14 - correct string in UTF-8 368s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 368s ok 16 - correct string in ISO-8859-1 369s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 369s ok 18 - Server error message has correct language and encoding 371s ok 19 - pg_ctlcluster 17 ru_RU restart 371s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 373s ok 21 - Dropping cluster 373s # Checking 17 ru_RU.UTF-8 376s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 377s ok 23 - psql -l succeeds 377s ok 24 - template1 is UTF-8 encoded 377s ok 25 - creating test database 377s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 377s # create table t (x varchar); copy t from stdin" test 377s ok 27 - creating table with ISO-8859-5 characters 377s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 377s ok 29 - correct string in UTF-8 377s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 377s ok 31 - correct string in ISO-8859-5 377s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 377s # delete from t; copy t from stdin" test 377s ok 33 - creating table with UTF-8 characters 377s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 377s ok 35 - correct string in UTF-8 377s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 377s ok 37 - correct string in ISO-8859-1 377s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 377s ok 39 - Server error message has correct language and encoding 380s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 380s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 380s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 380s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 380s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 380s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 380s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 380s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 382s ok 48 - Dropping cluster 382s # Check 17 locale environment variables 385s ok 49 - pg_createcluster: LC_ALL dominates LANG 385s ok 50 - psql -Atl --cluster 17/main 385s ok 51 - template1 is ASCII encoded 387s ok 52 - Dropping cluster 387s # Cleanup 387s ok 53 - Cleanup: No clusters left behind 387s ok 54 - No postgres processes left behind 387s ok 55 - No files in /etc/postgresql left behind 387s ok 56 - No files in /var/lib/postgresql left behind 387s ok 57 - No files in /var/run/postgresql left behind 387s ok 58 - No files in /var/log/postgresql left behind 387s ok 59 - PostgreSQL TCP ports are closed 387s ok 60 - Next free port is 5432 387s ### End test 050_encodings.t ### 387s 387s ### PostgreSQL test 052_upgrade_encodings.t ### 387s 1..1 387s ok 1 - only one major version installed, skipping upgrade tests 387s ### End test 052_upgrade_encodings.t ### 387s 387s ### PostgreSQL test 060_obsolete_confparams.t ### 387s ok 1 - only one major version installed, skipping upgrade tests 387s 1..1 387s ### End test 060_obsolete_confparams.t ### 387s 387s ### PostgreSQL test 070_non_postgres_clusters.t ### 387s 1..40 388s ok 1 - pg_createcluster 17 main for owner nobody 388s ok 2 - pg_ctlcluster 17 main start 388s ok 3 - start refused when config and data owners mismatch 390s ok 4 - pg_ctlcluster succeeds with owner nobody 390s ok 5 - pg_lsclusters -h 390s ok 6 - pg_lsclusters shows running cluster 390s ok 7 - postgres is running as user nobody 390s ok 8 - ls /tmp/.s.PGSQL.* 390s ok 9 - socket is in /tmp 390s ok 10 - /var/run/postgresql is empty 390s ok 11 - conf dir is owned by user 390s ok 12 - conf dir is owned by user's primary group 390s ok 13 - files are owned by user 390s ok 14 - files are owned by user's primary group 390s ok 15 - log file has 0640 permissions 390s ok 16 - log file is owned by user 390s ok 17 - log file is owned by user's primary group 390s ok 18 - only one major version installed, skipping upgrade test 390s ok 19 - ... 390s ok 20 - ... 390s ok 21 - ... 390s ok 22 - ... 390s ok 23 - ... 390s ok 24 - ... 390s ok 25 - ... 390s ok 26 - ... 390s ok 27 - ... 390s ok 28 - ... 392s ok 29 - pg_dropcluster 392s ok 30 - pg_lsclusters -h 392s ok 31 - No clusters left 392s ok 32 - No postgres processes left 392s # Cleanup 392s ok 33 - Cleanup: No clusters left behind 392s ok 34 - No postgres processes left behind 392s ok 35 - No files in /etc/postgresql left behind 392s ok 36 - No files in /var/lib/postgresql left behind 392s ok 37 - No files in /var/run/postgresql left behind 392s ok 38 - No files in /var/log/postgresql left behind 392s ok 39 - PostgreSQL TCP ports are closed 392s ok 40 - Next free port is 5432 392s ### End test 070_non_postgres_clusters.t ### 392s 392s ### PostgreSQL test 080_start.conf.t ### 392s 1..73 393s ok 1 - pg_createcluster 17 main 393s # start.conf auto 393s ok 2 - get_cluster_start_conf returns auto 393s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 393s ok 4 - start.conf contains auto 393s ok 5 - systemd generator links cluster 393s ok 6 - systemd generator links correct service file 396s ok 7 - /etc/init.d/postgresql start 17 396s ok 8 - correct output of /etc/init.d/postgresql start 17 396s ok 9 - pg_lsclusters -h 396s ok 10 - cluster is online 396s ok 11 - /etc/init.d/postgresql stop 17 396s ok 12 - correct output of /etc/init.d/postgresql stop 17 399s ok 13 - pg_lsclusters -h 399s ok 14 - cluster is down 399s # start.conf manual 399s ok 15 - get_cluster_start_conf returns manual 399s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 399s ok 17 - start.conf contains manual 399s ok 18 - systemd generator doesn't link cluster 399s ok 19 - /etc/init.d/postgresql start 17 399s ok 20 - correct output of /etc/init.d/postgresql start 17 399s ok 21 - pg_lsclusters -h 399s ok 22 - cluster is down 401s ok 23 - pg_ctlcluster 17 main start 401s ok 24 - correct output of pg_ctlcluster 17 main start 401s ok 25 - pg_lsclusters -h 401s ok 26 - cluster is online 401s ok 27 - pg_ctlcluster 17 main stop 401s ok 28 - correct output of pg_ctlcluster 17 main stop 402s ok 29 - pg_lsclusters -h 402s ok 30 - cluster is down 402s # start.conf disabled 402s ok 31 - get_cluster_start_conf returns disabled 402s ok 32 - systemd generator doesn't link cluster 402s ok 33 - /etc/init.d/postgresql start 17 402s ok 34 - correct output of /etc/init.d/postgresql start 17 402s ok 35 - pg_lsclusters -h 402s ok 36 - cluster is down 402s ok 37 - pg_ctlcluster 17 main start 402s ok 38 - correct output of pg_ctlcluster 17 main start 402s ok 39 - pg_lsclusters -h 402s ok 40 - cluster is down 404s ok 41 - pg_ctlcluster 17 main start 404s ok 42 - correct output of pg_ctlcluster 17 main start 404s ok 43 - pg_lsclusters -h 404s ok 44 - cluster is online 404s ok 45 - pg_ctlcluster 17 main stop 404s ok 46 - correct output of pg_ctlcluster 17 main stop 404s ok 47 - pg_lsclusters -h 404s ok 48 - cluster is down 407s ok 49 - pg_ctlcluster 17 main start 407s ok 50 - correct output of pg_ctlcluster 17 main start 407s ok 51 - pg_lsclusters -h 407s ok 52 - cluster is online 407s # test upgrade 407s ok 53 - only one major version installed, skipping upgrade test 407s ok 54 - ... 407s ok 55 - get_cluster_start_conf for old cluster returns manual 407s ok 56 - get_cluster_start_conf for new cluster returns manual 407s ok 57 - ... 408s ok 58 - dropping upgraded cluster 408s ok 59 - pg_lsclusters -h 408s ok 60 - no clusters any more 408s ok 61 - pg_createcluster 17 main --start-conf foo 408s ok 62 - pg_createcluster checks --start-conf validity 409s ok 63 - pg_createcluster checks --start-conf manual 409s ok 64 - get_cluster_start_conf returns manual 410s ok 65 - dropping cluster 410s # Cleanup 410s ok 66 - Cleanup: No clusters left behind 410s ok 67 - No postgres processes left behind 410s ok 68 - No files in /etc/postgresql left behind 410s ok 69 - No files in /var/lib/postgresql left behind 410s ok 70 - No files in /var/run/postgresql left behind 410s ok 71 - No files in /var/log/postgresql left behind 410s ok 72 - PostgreSQL TCP ports are closed 410s ok 73 - Next free port is 5432 410s ### End test 080_start.conf.t ### 410s 410s ### PostgreSQL test 085_pg_ctl.conf.t ### 410s 1..33 410s ok 1 - prlimit --core=0:unlimited --pid=17108 410s ok 2 - set core file size to unlimited 410s ok 3 - sh -c 'ulimit -Hc' 410s ok 4 - core file size is unlimited 411s ok 5 - pg_createcluster 17 main 411s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 414s ok 7 - pg_ctlcluster 17 main start 414s ok 8 - starting cluster as root 414s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 414s ok 10 - soft core size is 0 414s # hard core file size limit of root-started postgres process is unlimited 414s ok 11 - set pg_ctl default option to -c 416s ok 12 - pg_ctlcluster 17 main restart 416s ok 13 - restarting cluster as root 416s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 416s ok 15 - soft core size is unlimited 416s ok 16 - pg_ctlcluster 17 main stop 416s ok 17 - stopping cluster 416s ok 18 - restored pg_ctl default option 419s ok 19 - pg_ctlcluster 17 main start -- -c 419s ok 20 - starting cluster with -c on the command line as postgres 419s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 419s ok 22 - soft core size is unlimited 419s ok 23 - pg_ctlcluster 17 main stop 419s ok 24 - stopping cluster 420s ok 25 - dropping cluster 420s # Cleanup 420s ok 26 - Cleanup: No clusters left behind 420s ok 27 - No postgres processes left behind 420s ok 28 - No files in /etc/postgresql left behind 420s ok 29 - No files in /var/lib/postgresql left behind 420s ok 30 - No files in /var/run/postgresql left behind 420s ok 31 - No files in /var/log/postgresql left behind 420s ok 32 - PostgreSQL TCP ports are closed 420s ok 33 - Next free port is 5432 420s ### End test 085_pg_ctl.conf.t ### 420s 420s ### PostgreSQL test 090_multicluster.t ### 420s 1..125 421s ok 1 - pg_createcluster 17 old 423s ok 2 - pg_createcluster 17 new1 424s ok 3 - pg_createcluster 17 new2 426s ok 4 - starting cluster 17/old 428s ok 5 - starting cluster 17/new1 431s ok 6 - starting cluster 17/new2 431s ok 7 - pg_lsclusters -h | sort -k3 431s ok 8 - clusters have the correct ports, skipping used 5433 431s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 431s ok 10 - createdb --version 431s ok 11 - pg_wrapper selects port 5432 as default cluster 431s ok 12 - createdb --cluster 17/new1 --version 431s ok 13 - pg_wrapper --cluster works 431s ok 14 - createdb --cluster 17/foo --version 431s ok 15 - pg_wrapper --cluster errors out for invalid cluster 431s ok 16 - createdb --cluster 17/new1 test 431s ok 17 - correct output of createdb --cluster 17/new1 test 431s ok 18 - psql -Atl --cluster 17/new1 431s ok 19 - test db appears in cluster new1 431s ok 20 - psql -Atl --cluster 17/new2 431s ok 21 - test db does not appear in cluster new2 431s ok 22 - psql -Atl 431s ok 23 - test db does not appear in default cluster 431s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 431s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 431s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 431s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 431s ok 28 - psql -Atl --cluster 17/localhost:5434 431s ok 29 - test db appears in cluster 17/localhost:5434 431s ok 30 - psql -Atl --cluster 17/localhost:5440 431s ok 31 - test db does not appear in cluster 17/localhost:5440 431s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 431s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 431s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 431s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 431s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 431s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 431s ok 38 - psql -Atl --cluster 6.4/localhost: 431s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 431s ok 40 - psql -Atl 431s ok 41 - PGCLUSTER selection (1) 431s ok 42 - psql -Atl 431s ok 43 - PGCLUSTER selection (2) 431s ok 44 - psql -l 431s ok 45 - invalid PGCLUSTER value 431s ok 46 - createdb --version 431s ok 47 - PGCLUSTER network cluster selection (1) 431s ok 48 - psql -Atl 431s ok 49 - PGCLUSTER network cluster selection (2) 432s ok 50 - psql -Atl 432s ok 51 - PGCLUSTER network cluster selection (3) 432s ok 52 - LC_MESSAGES=C psql -Atl 432s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 432s ok 54 - psql -Atc "show port" template1 432s ok 55 - PGPORT selection (1) 432s ok 56 - psql -Atc "show port" template1 432s ok 57 - PGPORT selection (2) 432s ok 58 - createdb --version 432s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 432s ok 60 - psql -Atc "show port" template1 432s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 432s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 432s ok 63 - PGDATABASE environment variable works 432s ok 64 - createdb --version 432s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 432s ok 66 - createdb --cluster 17/new1 --version 432s ok 67 - pg_wrapper --cluster works with empty user_clusters 432s ok 68 - createdb --version 432s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 432s ok 70 - psql -Atc "select current_database()" 432s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 432s ok 72 - psql -Atc 'select current_database()' 432s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 432s ok 74 - createdb --version 432s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 432s ok 76 - createdb --version 432s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 432s ok 78 - createdb --version 432s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 432s ok 80 - createdb --version 432s ok 81 - pg_wrapper selects correct version with per-user user_clusters 432s ok 82 - createdb --version 432s ok 83 - pg_wrapper selects correct version with per-user user_clusters 432s ok 84 - createdb --version 432s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 432s ok 86 - psql -Atl 432s ok 87 - $PGHOST overrides user_clusters 432s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 432s ok 89 - --cluster overrides $PGHOST 432s ok 90 - createdb --version 432s ok 91 - pg_wrapper ignores invalid lines in user_clusters 432s ok 92 - psql -Atc 'select current_database()' 432s ok 93 - pg_service conf selection 1 433s ok 94 - psql -Atc 'select current_database()' 433s ok 95 - pg_service conf selection 2 433s ok 96 - psql -Atc 'select current_database()' 433s ok 97 - pg_service conf selection 3 433s ok 98 - stopping cluster 17/old 435s ok 99 - restarting cluster 17/old 435s ok 100 - pg_lsclusters -h | sort -k3 435s ok 101 - port of first cluster was successfully changed 435s ok 102 - psql -l 435s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 435s ok 104 - psql -Atl --cluster 17/new1 435s ok 105 - --cluster selects appropriate cluster 435s ok 106 - psql -Atl -p 5434 435s ok 107 - -p selects appropriate cluster 435s ok 108 - psql -Atlp 5434 435s ok 109 - -Atlp selects appropriate cluster 435s ok 110 - psql -Atl --port 5434 435s ok 111 - --port selects appropriate cluster 435s ok 112 - env PGPORT=5434 psql -Atl 435s ok 113 - $PGPORT selects appropriate cluster 435s ok 114 - Restoring original /etc/postgresql-common/user_clusters 437s ok 115 - dropping 17/new1 439s ok 116 - dropping 17/new2 440s ok 117 - dropping 17/old 440s # Cleanup 440s ok 118 - Cleanup: No clusters left behind 440s ok 119 - No postgres processes left behind 440s ok 120 - No files in /etc/postgresql left behind 440s ok 121 - No files in /var/lib/postgresql left behind 440s ok 122 - No files in /var/run/postgresql left behind 440s ok 123 - No files in /var/log/postgresql left behind 440s ok 124 - PostgreSQL TCP ports are closed 440s ok 125 - Next free port is 5432 440s ### End test 090_multicluster.t ### 440s 440s ### PostgreSQL test 110_integrate_cluster.t ### 441s 1..32 441s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/AGJwAhve5f/c/postgres 441s ok 2 - creating raw initdb cluster for user postgres 442s ok 3 - pg_createcluster 17 postgres -d /tmp/AGJwAhve5f/c/postgres 442s ok 4 - integrating postgres cluster 442s ok 5 - pg_lsclusters 442s ok 6 - correct pg_lsclusters output 444s ok 7 - pg_ctlcluster 17 postgres start 444s ok 8 - starting cluster postgres 444s ok 9 - pg_lsclusters 444s ok 10 - correct pg_lsclusters output 445s ok 11 - dropping cluster postgres 445s ok 12 - No files in temporary cluster dir left behind 446s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/AGJwAhve5f/c/nobody 446s ok 14 - creating raw initdb cluster for user nobody 447s ok 15 - pg_createcluster 17 nobody -d /tmp/AGJwAhve5f/c/nobody 447s ok 16 - integrating nobody cluster 447s ok 17 - pg_lsclusters 447s ok 18 - correct pg_lsclusters output 449s ok 19 - pg_ctlcluster 17 nobody start 449s ok 20 - starting cluster nobody 449s ok 21 - pg_lsclusters 449s ok 22 - correct pg_lsclusters output 451s ok 23 - dropping cluster nobody 451s ok 24 - No files in temporary cluster dir left behind 451s # Cleanup 451s ok 25 - Cleanup: No clusters left behind 451s ok 26 - No postgres processes left behind 451s ok 27 - No files in /etc/postgresql left behind 451s ok 28 - No files in /var/lib/postgresql left behind 451s ok 29 - No files in /var/run/postgresql left behind 451s ok 30 - No files in /var/log/postgresql left behind 451s ok 31 - PostgreSQL TCP ports are closed 451s ok 32 - Next free port is 5432 451s ### End test 110_integrate_cluster.t ### 451s 451s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 451s 1..1 451s ok 1 - only one major version installed, skipping upgrade tests 451s ### End test 120_pg_upgradecluster_scripts.t ### 451s 451s ### PostgreSQL test 130_nonroot_admin.t ### 451s 1..22 454s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 454s ok 2 - pg_lsclusters -h 454s ok 3 - correct output of pg_lsclusters -h 454s ok 4 - psql -Atl 454s ok 5 - correct output of psql -Atl 454s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 454s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 454s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 454s # Cleanup 454s ok 15 - Cleanup: No clusters left behind 454s ok 16 - No postgres processes left behind 454s ok 17 - No files in /etc/postgresql left behind 454s ok 18 - No files in /var/lib/postgresql left behind 454s ok 19 - No files in /var/run/postgresql left behind 454s ok 20 - No files in /var/log/postgresql left behind 454s ok 21 - PostgreSQL TCP ports are closed 454s ok 22 - Next free port is 5432 454s ### End test 130_nonroot_admin.t ### 454s 454s ### PostgreSQL test 135_pg_virtualenv.t ### 454s 1..20 459s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 459s ok 2 - running pg_virtualenv as root 462s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 462s ok 4 - running pg_virtualenv as postgres 466s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 466s ok 6 - running pg_virtualenv as nobody 469s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 469s ok 8 - running fakeroot pg_virtualenv as root 472s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 472s ok 10 - running fakeroot pg_virtualenv as postgres 475s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 475s ok 12 - running fakeroot pg_virtualenv as nobody 475s # Cleanup 475s ok 13 - Cleanup: No clusters left behind 475s ok 14 - No postgres processes left behind 475s ok 15 - No files in /etc/postgresql left behind 475s ok 16 - No files in /var/lib/postgresql left behind 475s ok 17 - No files in /var/run/postgresql left behind 475s ok 18 - No files in /var/log/postgresql left behind 475s ok 19 - PostgreSQL TCP ports are closed 475s ok 20 - Next free port is 5432 475s ### End test 135_pg_virtualenv.t ### 475s 475s ### PostgreSQL test 140_pg_config.t ### 476s 1..38 476s # Multiarch is enabled 476s # checking version specific output for 17 476s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 476s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 476s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 476s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 476s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 476s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 476s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 476s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 476s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 476s # checking pg_config output (should behave like version 17) 476s ok 15 - pg_config 476s ok 16 - correct output of pg_config 476s ok 17 - pg_config --help 476s ok 18 - correct output of pg_config --help 476s ok 19 - pg_config --pgxs 476s ok 20 - correct output of pg_config --pgxs 476s ok 21 - pg_config --libdir 476s ok 22 - correct output of pg_config --libdir 476s ok 23 - pg_config --pkglibdir 476s ok 24 - correct output of pg_config --pkglibdir 476s ok 25 - pg_config --bindir 476s ok 26 - correct output of pg_config --bindir 476s # checking pg_config.libpq-dev output (should behave like version 17) 476s ok 27 - pg_config.libpq-dev 476s ok 28 - correct output of pg_config.libpq-dev 476s ok 29 - pg_config.libpq-dev --help 476s ok 30 - correct output of pg_config.libpq-dev --help 476s ok 31 - pg_config.libpq-dev --pgxs 476s ok 32 - correct output of pg_config.libpq-dev --pgxs 476s ok 33 - pg_config.libpq-dev --libdir 476s ok 34 - correct output of pg_config.libpq-dev --libdir 476s ok 35 - pg_config.libpq-dev --pkglibdir 476s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 476s ok 37 - pg_config.libpq-dev --bindir 476s ok 38 - correct output of pg_config.libpq-dev --bindir 476s ### End test 140_pg_config.t ### 476s 476s ### PostgreSQL test 150_tsearch_stemming.t ### 476s 1..37 476s ok 1 - pg_updatedicts succeeded 476s ok 2 - pg_updatedicts created en_us.affix 476s ok 3 - pg_updatedicts created en_us.dict 476s ok 4 - pg_updatedicts created 17 en_us.affix symlink 476s ok 5 - pg_updatedicts created 17 en_us.dict symlink 479s ok 6 - pg_createcluster 17 main 479s ok 7 - createdb fts 479s ok 8 - correct output of createdb fts 479s ok 9 - creating en_US full text search configuration 479s ok 10 - creating data table and search index 479s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 479s ok 12 - stem search of correct word 480s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 480s ok 14 - stem search of correct word 480s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 480s ok 16 - stem search of unknown word 480s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 480s ok 18 - full text search, exact word 480s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 480s ok 20 - full text search for word stem 480s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 480s ok 22 - full text search for word substring fails 480s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 480s ok 24 - full text search, exact unicode word 480s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 480s ok 26 - full text search for unicode word stem 480s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 480s ok 28 - full text search for unicode word substring fails 482s ok 29 482s # Cleanup 482s ok 30 - Cleanup: No clusters left behind 482s ok 31 - No postgres processes left behind 482s ok 32 - No files in /etc/postgresql left behind 482s ok 33 - No files in /var/lib/postgresql left behind 482s ok 34 - No files in /var/run/postgresql left behind 482s ok 35 - No files in /var/log/postgresql left behind 482s ok 36 - PostgreSQL TCP ports are closed 482s ok 37 - Next free port is 5432 482s ### End test 150_tsearch_stemming.t ### 482s 482s ### PostgreSQL test 160_alternate_confroot.t ### 482s 1..28 485s ok 1 485s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 485s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 485s ok 4 - pg_lsclusters -h 485s ok 5 - correct output of pg_lsclusters -h 485s ok 6 - psql -Atl 485s ok 7 - correct output of psql -Atl 485s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 485s ok 9 - ... 485s ok 10 - ... 485s ok 11 - ... 485s ok 12 - ... 485s ok 13 - ... 485s ok 14 - ... 485s ok 15 - pg_dropcluster 17 test --stop 485s ok 16 - correct output of pg_dropcluster 17 test --stop 485s ok 17 - pg_lsclusters -h 485s ok 18 - correct output of pg_lsclusters -h 485s ok 19 - No files in root/data left behind 485s ok 20 - No cruft in root dir left behind 485s # Cleanup 485s ok 21 - Cleanup: No clusters left behind 485s ok 22 - No postgres processes left behind 485s ok 23 - No files in /etc/postgresql left behind 485s ok 24 - No files in /var/lib/postgresql left behind 485s ok 25 - No files in /var/run/postgresql left behind 485s ok 26 - No files in /var/log/postgresql left behind 485s ok 27 - PostgreSQL TCP ports are closed 485s ok 28 - Next free port is 5432 485s ### End test 160_alternate_confroot.t ### 485s 485s ### PostgreSQL test 170_extensions.t ### 485s # Running tests for 17 489s ok 1 - pg_createcluster 17 main 489s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 489s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 489s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 489s ok 5 - extension amcheck installs without error 489s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 489s ok 7 - extension amcheck removes without error 489s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 489s ok 9 - extension autoinc installs without error 489s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 489s ok 11 - extension autoinc removes without error 489s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 489s ok 13 - extension bloom installs without error 489s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 489s ok 15 - extension bloom removes without error 489s ok 16 - psql -qc 'CREATE EXTENSION plperl' 489s ok 17 - bool_plperl dependency plperl installs without error 489s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 489s ok 19 - extension bool_plperl installs without error 489s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 489s ok 21 - extension bool_plperl removes without error 489s ok 22 - psql -qc 'DROP EXTENSION plperl' 489s ok 23 - bool_plperl dependency extension plperl removes without error 489s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 489s ok 25 - bool_plperlu dependency plperlu installs without error 489s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 489s ok 27 - extension bool_plperlu installs without error 489s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 489s ok 29 - extension bool_plperlu removes without error 490s ok 30 - psql -qc 'DROP EXTENSION plperlu' 490s ok 31 - bool_plperlu dependency extension plperlu removes without error 490s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 490s ok 33 - extension btree_gin installs without error 490s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 490s ok 35 - extension btree_gin removes without error 490s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 490s ok 37 - extension btree_gist installs without error 490s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 490s ok 39 - extension btree_gist removes without error 490s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 490s ok 41 - extension citext installs without error 490s ok 42 - psql -qc 'DROP EXTENSION "citext"' 490s ok 43 - extension citext removes without error 490s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 490s ok 45 - extension cube installs without error 490s ok 46 - psql -qc 'DROP EXTENSION "cube"' 490s ok 47 - extension cube removes without error 490s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 490s ok 49 - extension dblink installs without error 490s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 490s ok 51 - extension dblink removes without error 490s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 490s ok 53 - extension dict_int installs without error 490s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 490s ok 55 - extension dict_int removes without error 490s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 490s ok 57 - extension dict_xsyn installs without error 490s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 490s ok 59 - extension dict_xsyn removes without error 490s ok 60 - psql -qc 'CREATE EXTENSION cube' 490s ok 61 - earthdistance dependency cube installs without error 490s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 490s ok 63 - extension earthdistance installs without error 490s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 490s ok 65 - extension earthdistance removes without error 490s ok 66 - psql -qc 'DROP EXTENSION cube' 490s ok 67 - earthdistance dependency extension cube removes without error 491s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 491s ok 69 - extension file_fdw installs without error 491s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 491s ok 71 - extension file_fdw removes without error 491s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 491s ok 73 - extension fuzzystrmatch installs without error 491s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 491s ok 75 - extension fuzzystrmatch removes without error 491s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 491s ok 77 - extension hstore installs without error 491s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 491s ok 79 - extension hstore removes without error 491s ok 80 - psql -qc 'CREATE EXTENSION hstore' 491s ok 81 - hstore_plperl dependency hstore installs without error 491s ok 82 - psql -qc 'CREATE EXTENSION plperl' 491s ok 83 - hstore_plperl dependency plperl installs without error 491s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 491s ok 85 - extension hstore_plperl installs without error 491s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 491s ok 87 - extension hstore_plperl removes without error 491s ok 88 - psql -qc 'DROP EXTENSION hstore' 491s ok 89 - hstore_plperl dependency extension hstore removes without error 491s ok 90 - psql -qc 'DROP EXTENSION plperl' 491s ok 91 - hstore_plperl dependency extension plperl removes without error 491s ok 92 - psql -qc 'CREATE EXTENSION hstore' 491s ok 93 - hstore_plperlu dependency hstore installs without error 491s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 491s ok 95 - hstore_plperlu dependency plperlu installs without error 491s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 491s ok 97 - extension hstore_plperlu installs without error 491s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 491s ok 99 - extension hstore_plperlu removes without error 491s ok 100 - psql -qc 'DROP EXTENSION hstore' 491s ok 101 - hstore_plperlu dependency extension hstore removes without error 491s ok 102 - psql -qc 'DROP EXTENSION plperlu' 491s ok 103 - hstore_plperlu dependency extension plperlu removes without error 491s ok 104 - psql -qc 'CREATE EXTENSION hstore' 491s ok 105 - hstore_plpython3u dependency hstore installs without error 491s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 491s ok 107 - hstore_plpython3u dependency plpython3u installs without error 491s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 491s ok 109 - extension hstore_plpython3u installs without error 492s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 492s ok 111 - extension hstore_plpython3u removes without error 492s ok 112 - psql -qc 'DROP EXTENSION hstore' 492s ok 113 - hstore_plpython3u dependency extension hstore removes without error 492s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 492s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 492s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 492s ok 117 - extension insert_username installs without error 492s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 492s ok 119 - extension insert_username removes without error 492s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 492s ok 121 - extension intagg installs without error 492s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 492s ok 123 - extension intagg removes without error 492s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 492s ok 125 - extension intarray installs without error 492s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 492s ok 127 - extension intarray removes without error 492s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 492s ok 129 - extension isn installs without error 492s ok 130 - psql -qc 'DROP EXTENSION "isn"' 492s ok 131 - extension isn removes without error 492s ok 132 - psql -qc 'CREATE EXTENSION plperl' 492s ok 133 - jsonb_plperl dependency plperl installs without error 492s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 492s ok 135 - extension jsonb_plperl installs without error 492s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 492s ok 137 - extension jsonb_plperl removes without error 492s ok 138 - psql -qc 'DROP EXTENSION plperl' 492s ok 139 - jsonb_plperl dependency extension plperl removes without error 492s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 492s ok 141 - jsonb_plperlu dependency plperlu installs without error 492s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 492s ok 143 - extension jsonb_plperlu installs without error 493s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 493s ok 145 - extension jsonb_plperlu removes without error 493s ok 146 - psql -qc 'DROP EXTENSION plperlu' 493s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 493s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 493s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 493s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 493s ok 151 - extension jsonb_plpython3u installs without error 493s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 493s ok 153 - extension jsonb_plpython3u removes without error 493s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 493s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 493s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 493s ok 157 - extension lo installs without error 493s ok 158 - psql -qc 'DROP EXTENSION "lo"' 493s ok 159 - extension lo removes without error 493s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 493s ok 161 - extension ltree installs without error 493s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 493s ok 163 - extension ltree removes without error 493s ok 164 - psql -qc 'CREATE EXTENSION ltree' 493s ok 165 - ltree_plpython3u dependency ltree installs without error 493s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 493s ok 167 - ltree_plpython3u dependency plpython3u installs without error 493s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 493s ok 169 - extension ltree_plpython3u installs without error 493s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 493s ok 171 - extension ltree_plpython3u removes without error 493s ok 172 - psql -qc 'DROP EXTENSION ltree' 493s ok 173 - ltree_plpython3u dependency extension ltree removes without error 493s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 493s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 493s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 493s ok 177 - extension moddatetime installs without error 493s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 493s ok 179 - extension moddatetime removes without error 493s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 493s ok 181 - extension pageinspect installs without error 493s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 493s ok 183 - extension pageinspect removes without error 493s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 493s ok 185 - extension pg_buffercache installs without error 494s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 494s ok 187 - extension pg_buffercache removes without error 494s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 494s ok 189 - extension pg_freespacemap installs without error 494s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 494s ok 191 - extension pg_freespacemap removes without error 494s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 494s ok 193 - extension pg_prewarm installs without error 494s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 494s ok 195 - extension pg_prewarm removes without error 494s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 494s ok 197 - extension pg_stat_statements installs without error 494s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 494s ok 199 - extension pg_stat_statements removes without error 494s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 494s ok 201 - extension pg_surgery installs without error 494s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 494s ok 203 - extension pg_surgery removes without error 494s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 494s ok 205 - extension pg_trgm installs without error 494s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 494s ok 207 - extension pg_trgm removes without error 494s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 494s ok 209 - extension pg_visibility installs without error 494s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 494s ok 211 - extension pg_visibility removes without error 494s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 494s ok 213 - extension pg_walinspect installs without error 494s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 494s ok 215 - extension pg_walinspect removes without error 494s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 494s ok 217 - extension pgcrypto installs without error 494s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 494s ok 219 - extension pgcrypto removes without error 494s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 494s ok 221 - extension pgrowlocks installs without error 494s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 494s ok 223 - extension pgrowlocks removes without error 494s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 494s ok 225 - extension pgstattuple installs without error 495s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 495s ok 227 - extension pgstattuple removes without error 495s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 495s ok 229 - extension plperl installs without error 495s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 495s ok 231 - extension plperl removes without error 495s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 495s ok 233 - extension plperlu installs without error 495s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 495s ok 235 - extension plperlu removes without error 495s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 495s ok 237 - extension plpython3u installs without error 495s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 495s ok 239 - extension plpython3u removes without error 495s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 495s ok 241 - extension pltcl installs without error 495s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 495s ok 243 - extension pltcl removes without error 495s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 495s ok 245 - extension pltclu installs without error 495s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 495s ok 247 - extension pltclu removes without error 495s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 495s ok 249 - extension postgres_fdw installs without error 495s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 495s ok 251 - extension postgres_fdw removes without error 495s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 495s ok 253 - extension refint installs without error 495s ok 254 - psql -qc 'DROP EXTENSION "refint"' 495s ok 255 - extension refint removes without error 495s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 495s ok 257 - extension seg installs without error 495s ok 258 - psql -qc 'DROP EXTENSION "seg"' 495s ok 259 - extension seg removes without error 495s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 495s ok 261 - extension sslinfo installs without error 495s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 495s ok 263 - extension sslinfo removes without error 495s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 495s ok 265 - extension tablefunc installs without error 495s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 495s ok 267 - extension tablefunc removes without error 496s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 496s ok 269 - extension tcn installs without error 496s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 496s ok 271 - extension tcn removes without error 496s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 496s ok 273 - extension tsm_system_rows installs without error 496s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 496s ok 275 - extension tsm_system_rows removes without error 496s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 496s ok 277 - extension tsm_system_time installs without error 496s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 496s ok 279 - extension tsm_system_time removes without error 496s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 496s ok 281 - extension unaccent installs without error 496s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 496s ok 283 - extension unaccent removes without error 496s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 496s ok 285 - extension uuid-ossp installs without error 496s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 496s ok 287 - extension uuid-ossp removes without error 496s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 496s ok 289 - extension xml2 installs without error 496s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 496s ok 291 - extension xml2 removes without error 498s ok 292 - pg_dropcluster 17 main 498s # Cleanup 498s ok 293 - Cleanup: No clusters left behind 498s ok 294 - No postgres processes left behind 498s ok 295 - No files in /etc/postgresql left behind 498s ok 296 - No files in /var/lib/postgresql left behind 498s ok 297 - No files in /var/run/postgresql left behind 498s ok 298 - No files in /var/log/postgresql left behind 498s ok 299 - PostgreSQL TCP ports are closed 498s ok 300 - Next free port is 5432 498s 1..300 498s ### End test 170_extensions.t ### 498s 498s ### PostgreSQL test 180_ecpg.t ### 498s 1..14 498s ok 1 - ecpg test.pgc 498s ok 2 - ecpg processing 498s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 498s ok 4 - compiling ecpg output 505s ok 5 - pg_virtualenv /tmp/tmp.UnvY96oFYZ/test 505s ok 6 - test program runs and gives correct output 505s # Cleanup 505s ok 7 - Cleanup: No clusters left behind 505s ok 8 - No postgres processes left behind 505s ok 9 - No files in /etc/postgresql left behind 505s ok 10 - No files in /var/lib/postgresql left behind 505s ok 11 - No files in /var/run/postgresql left behind 505s ok 12 - No files in /var/log/postgresql left behind 505s ok 13 - PostgreSQL TCP ports are closed 505s ok 14 - Next free port is 5432 505s ### End test 180_ecpg.t ### 505s 505s ### PostgreSQL test 190_pg_buildext.t ### 505s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 505s 1..1 505s ### End test 190_pg_buildext.t ### 505s 505s ### PostgreSQL test 200_maintscripts.t ### 505s 1..15 505s # We are running systemd 509s ok 1 - pg_createcluster 17 main --start 509s ok 2 - postmaster PID is 22154 515s ok 3 - apt-get update -q 515s # postgresql-common: 515s # Installed: 277 515s # Candidate: 277 515s # Version table: 515s # *** 277 995 515s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages 515s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages 515s # 100 /var/lib/dpkg/status 515s # 274 500 515s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 515s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 518s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 518s # postgresql-common: 518s # Installed: 277 518s # Candidate: 277 518s # Version table: 518s # *** 277 995 518s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages 518s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages 518s # 100 /var/lib/dpkg/status 518s # 274 500 518s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 518s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 518s ok 5 - postmaster PID is 22154 518s ok 6 - postmaster was not restarted 520s ok 7 - pg_dropcluster 17 main --stop 520s # Cleanup 520s ok 8 - Cleanup: No clusters left behind 520s ok 9 - No postgres processes left behind 520s ok 10 - No files in /etc/postgresql left behind 520s ok 11 - No files in /var/lib/postgresql left behind 520s ok 12 - No files in /var/run/postgresql left behind 520s ok 13 - No files in /var/log/postgresql left behind 520s ok 14 - PostgreSQL TCP ports are closed 520s ok 15 - Next free port is 5432 520s ### End test 200_maintscripts.t ### 520s 521s autopkgtest [14:49:54]: test run-testsuite: -----------------------] 521s run-testsuite PASS 521s autopkgtest [14:49:54]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 521s autopkgtest [14:49:54]: test installcheck: preparing testbed 612s autopkgtest [14:51:25]: testbed dpkg architecture: amd64 612s autopkgtest [14:51:25]: testbed apt version: 3.0.0 613s autopkgtest [14:51:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 613s autopkgtest [14:51:26]: testbed release detected to be: questing 614s autopkgtest [14:51:27]: updating testbed package index (apt update) 614s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 614s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 614s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 614s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 614s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [33.5 kB] 614s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [150 kB] 614s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1538 kB] 615s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [141 kB] 615s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [199 kB] 615s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [1473 kB] 615s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [603 kB] 615s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [23.1 kB] 615s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [49.1 kB] 615s Fetched 4320 kB in 1s (4051 kB/s) 616s Reading package lists... 616s autopkgtest [14:51:29]: upgrading testbed (apt dist-upgrade and autopurge) 616s Reading package lists... 617s Building dependency tree... 617s Reading state information... 617s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 617s Starting 2 pkgProblemResolver with broken count: 0 617s Done 617s Entering ResolveByKeep 618s 618s Calculating upgrade... 618s The following packages will be upgraded: 618s debianutils libmbim-glib4 libmbim-proxy libnftnl11 libqmi-glib5 libqmi-proxy 618s python3-lazr.restfulclient 618s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 618s Need to get 1378 kB of archives. 618s After this operation, 139 kB disk space will be freed. 618s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 debianutils amd64 5.22 [93.0 kB] 618s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 libnftnl11 amd64 1.2.9-1 [69.1 kB] 618s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-proxy amd64 1.32.0-1 [6276 B] 618s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libmbim-glib4 amd64 1.32.0-1 [233 kB] 618s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-proxy amd64 1.36.0-1 [6220 B] 618s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 libqmi-glib5 amd64 1.36.0-1 [920 kB] 618s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 619s Fetched 1378 kB in 1s (2486 kB/s) 619s (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.) 619s Preparing to unpack .../debianutils_5.22_amd64.deb ... 619s Unpacking debianutils (5.22) over (5.21) ... 619s Setting up debianutils (5.22) ... 619s (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.) 619s Preparing to unpack .../0-libnftnl11_1.2.9-1_amd64.deb ... 619s Unpacking libnftnl11:amd64 (1.2.9-1) over (1.2.8-1) ... 619s Preparing to unpack .../1-libmbim-proxy_1.32.0-1_amd64.deb ... 619s Unpacking libmbim-proxy (1.32.0-1) over (1.31.2-0ubuntu4) ... 619s Preparing to unpack .../2-libmbim-glib4_1.32.0-1_amd64.deb ... 619s Unpacking libmbim-glib4:amd64 (1.32.0-1) over (1.31.2-0ubuntu4) ... 619s Preparing to unpack .../3-libqmi-proxy_1.36.0-1_amd64.deb ... 619s Unpacking libqmi-proxy (1.36.0-1) over (1.35.6-1) ... 619s Preparing to unpack .../4-libqmi-glib5_1.36.0-1_amd64.deb ... 619s Unpacking libqmi-glib5:amd64 (1.36.0-1) over (1.35.6-1) ... 619s Preparing to unpack .../5-python3-lazr.restfulclient_0.14.6-3_all.deb ... 619s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 619s Setting up libnftnl11:amd64 (1.2.9-1) ... 619s Setting up python3-lazr.restfulclient (0.14.6-3) ... 619s Setting up libmbim-glib4:amd64 (1.32.0-1) ... 619s Setting up libmbim-proxy (1.32.0-1) ... 619s Setting up libqmi-glib5:amd64 (1.36.0-1) ... 619s Setting up libqmi-proxy (1.36.0-1) ... 619s Processing triggers for libc-bin (2.41-6ubuntu1) ... 620s Processing triggers for man-db (2.13.0-1) ... 621s Reading package lists... 621s Building dependency tree... 621s Reading state information... 621s Starting pkgProblemResolver with broken count: 0 621s Starting 2 pkgProblemResolver with broken count: 0 621s Done 622s Solving dependencies... 622s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 625s Reading package lists... 625s Building dependency tree... 625s Reading state information... 625s Starting pkgProblemResolver with broken count: 0 625s Starting 2 pkgProblemResolver with broken count: 0 625s Done 626s The following NEW packages will be installed: 626s binutils-gold binutils-gold-x86-64-linux-gnu build-essential clang-20 cpp 626s cpp-14 cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu g++ g++-14 626s g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 626s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu libasan8 libcc1-0 626s libclang-common-20-dev libclang-cpp20 libclang1-20 libffi-dev libgc1 626s libgcc-14-dev libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 626s libitm1 libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev 626s libobjc-14-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev 626s libstdc++-14-dev libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 626s llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 626s postgresql-client-17 postgresql-client-common postgresql-common 626s postgresql-common-dev postgresql-server-dev-17 ssl-cert tzdata-legacy 626s 0 upgraded, 60 newly installed, 0 to remove and 0 not upgraded. 626s Need to get 219 MB of archives. 626s After this operation, 1073 MB of additional disk space will be used. 626s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 626s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-client-common all 277 [48.0 kB] 626s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 626s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 626s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common-dev all 277 [73.4 kB] 626s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 626s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 postgresql-common all 277 [101 kB] 626s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 binutils-gold-x86-64-linux-gnu amd64 2.44-2 [1278 kB] 626s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 binutils-gold amd64 2.44-2 [2208 B] 626s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 libisl23 amd64 0.27-1 [685 kB] 626s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 626s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [11.9 MB] 627s Get:13 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14 amd64 14.2.0-19ubuntu2 [1030 B] 627s Get:14 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [5586 B] 627s Get:15 http://ftpmaster.internal/ubuntu questing/main amd64 cpp amd64 4:14.2.0-1ubuntu1 [22.4 kB] 627s Get:16 http://ftpmaster.internal/ubuntu questing/main amd64 libcc1-0 amd64 15-20250404-0ubuntu1 [47.1 kB] 627s Get:17 http://ftpmaster.internal/ubuntu questing/main amd64 libgomp1 amd64 15-20250404-0ubuntu1 [151 kB] 627s Get:18 http://ftpmaster.internal/ubuntu questing/main amd64 libitm1 amd64 15-20250404-0ubuntu1 [29.5 kB] 627s Get:19 http://ftpmaster.internal/ubuntu questing/main amd64 libasan8 amd64 15-20250404-0ubuntu1 [3076 kB] 627s Get:20 http://ftpmaster.internal/ubuntu questing/main amd64 liblsan0 amd64 15-20250404-0ubuntu1 [1362 kB] 627s Get:21 http://ftpmaster.internal/ubuntu questing/main amd64 libtsan2 amd64 15-20250404-0ubuntu1 [2760 kB] 627s Get:22 http://ftpmaster.internal/ubuntu questing/main amd64 libubsan1 amd64 15-20250404-0ubuntu1 [1211 kB] 627s Get:23 http://ftpmaster.internal/ubuntu questing/main amd64 libhwasan0 amd64 15-20250404-0ubuntu1 [1687 kB] 627s Get:24 http://ftpmaster.internal/ubuntu questing/main amd64 libquadmath0 amd64 15-20250404-0ubuntu1 [153 kB] 627s Get:25 http://ftpmaster.internal/ubuntu questing/main amd64 libgcc-14-dev amd64 14.2.0-19ubuntu2 [2815 kB] 627s Get:26 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [23.3 MB] 628s Get:27 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14 amd64 14.2.0-19ubuntu2 [540 kB] 628s Get:28 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [1208 B] 628s Get:29 http://ftpmaster.internal/ubuntu questing/main amd64 gcc amd64 4:14.2.0-1ubuntu1 [5004 B] 628s Get:30 http://ftpmaster.internal/ubuntu questing/main amd64 libstdc++-14-dev amd64 14.2.0-19ubuntu2 [2510 kB] 628s Get:31 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-19ubuntu2 [13.4 MB] 629s Get:32 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14 amd64 14.2.0-19ubuntu2 [23.0 kB] 629s Get:33 http://ftpmaster.internal/ubuntu questing/main amd64 g++-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [968 B] 629s Get:34 http://ftpmaster.internal/ubuntu questing/main amd64 g++ amd64 4:14.2.0-1ubuntu1 [1100 B] 629s Get:35 http://ftpmaster.internal/ubuntu questing/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 629s Get:36 http://ftpmaster.internal/ubuntu questing/main amd64 libllvm20 amd64 1:20.1.2-0ubuntu1 [30.5 MB] 630s Get:37 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-cpp20 amd64 1:20.1.2-0ubuntu1 [14.2 MB] 631s Get:38 http://ftpmaster.internal/ubuntu questing/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 631s Get:39 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc4 amd64 15-20250404-0ubuntu1 [47.8 kB] 631s Get:40 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc-14-dev amd64 14.2.0-19ubuntu2 [195 kB] 631s Get:41 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-common-20-dev amd64 1:20.1.2-0ubuntu1 [782 kB] 631s Get:42 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-linker-tools amd64 1:20.1.2-0ubuntu1 [1337 kB] 631s Get:43 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang1-20 amd64 1:20.1.2-0ubuntu1 [8255 kB] 631s Get:44 http://ftpmaster.internal/ubuntu questing/universe amd64 clang-20 amd64 1:20.1.2-0ubuntu1 [77.6 kB] 631s Get:45 http://ftpmaster.internal/ubuntu questing/main amd64 libncurses-dev amd64 6.5+20250216-2 [424 kB] 631s Get:46 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.4-1 [155 kB] 631s Get:47 http://ftpmaster.internal/ubuntu questing/main amd64 libssl-dev amd64 3.4.1-1ubuntu3 [2872 kB] 631s Get:48 http://ftpmaster.internal/ubuntu questing/main amd64 libpq-dev amd64 17.4-1 [158 kB] 631s Get:49 http://ftpmaster.internal/ubuntu questing/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.4 [785 kB] 631s Get:50 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu4 [176 kB] 631s Get:51 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-runtime amd64 1:20.1.2-0ubuntu1 [560 kB] 631s Get:52 http://ftpmaster.internal/ubuntu questing/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 631s Get:53 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20 amd64 1:20.1.2-0ubuntu1 [19.7 MB] 632s Get:54 http://ftpmaster.internal/ubuntu questing/main amd64 libffi-dev amd64 3.4.7-1 [65.5 kB] 632s Get:55 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-tools amd64 1:20.1.2-0ubuntu1 [513 kB] 632s Get:56 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-dev amd64 1:20.1.2-0ubuntu1 [50.5 MB] 634s Get:57 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.4-1 [1425 kB] 634s Get:58 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.4-1 [16.6 MB] 635s Get:59 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-17 amd64 17.4-1 [1417 kB] 635s Get:60 http://ftpmaster.internal/ubuntu questing/main amd64 tzdata-legacy all 2025b-1ubuntu1 [99.2 kB] 635s Preconfiguring packages ... 635s Fetched 219 MB in 9s (24.3 MB/s) 635s Selecting previously unselected package libjson-perl. 635s (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.) 635s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 635s Unpacking libjson-perl (4.10000-1) ... 635s Selecting previously unselected package postgresql-client-common. 635s Preparing to unpack .../01-postgresql-client-common_277_all.deb ... 635s Unpacking postgresql-client-common (277) ... 635s Selecting previously unselected package libio-pty-perl. 635s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 635s Unpacking libio-pty-perl (1:1.20-1build3) ... 635s Selecting previously unselected package libipc-run-perl. 635s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 635s Unpacking libipc-run-perl (20231003.0-2) ... 635s Selecting previously unselected package postgresql-common-dev. 636s Preparing to unpack .../04-postgresql-common-dev_277_all.deb ... 636s Unpacking postgresql-common-dev (277) ... 636s Selecting previously unselected package ssl-cert. 636s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 636s Unpacking ssl-cert (1.1.3ubuntu1) ... 636s Selecting previously unselected package postgresql-common. 636s Preparing to unpack .../06-postgresql-common_277_all.deb ... 636s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 636s Unpacking postgresql-common (277) ... 636s Selecting previously unselected package binutils-gold-x86-64-linux-gnu. 636s Preparing to unpack .../07-binutils-gold-x86-64-linux-gnu_2.44-2_amd64.deb ... 636s Unpacking binutils-gold-x86-64-linux-gnu (2.44-2) ... 636s Selecting previously unselected package binutils-gold. 636s Preparing to unpack .../08-binutils-gold_2.44-2_amd64.deb ... 636s Unpacking binutils-gold (2.44-2) ... 636s Selecting previously unselected package libisl23:amd64. 636s Preparing to unpack .../09-libisl23_0.27-1_amd64.deb ... 636s Unpacking libisl23:amd64 (0.27-1) ... 636s Selecting previously unselected package libmpc3:amd64. 636s Preparing to unpack .../10-libmpc3_1.3.1-1build2_amd64.deb ... 636s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 636s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 636s Preparing to unpack .../11-cpp-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 636s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 636s Selecting previously unselected package cpp-14. 636s Preparing to unpack .../12-cpp-14_14.2.0-19ubuntu2_amd64.deb ... 636s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 636s Selecting previously unselected package cpp-x86-64-linux-gnu. 636s Preparing to unpack .../13-cpp-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 636s Unpacking cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 636s Selecting previously unselected package cpp. 636s Preparing to unpack .../14-cpp_4%3a14.2.0-1ubuntu1_amd64.deb ... 636s Unpacking cpp (4:14.2.0-1ubuntu1) ... 636s Selecting previously unselected package libcc1-0:amd64. 636s Preparing to unpack .../15-libcc1-0_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libcc1-0:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libgomp1:amd64. 636s Preparing to unpack .../16-libgomp1_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libgomp1:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libitm1:amd64. 636s Preparing to unpack .../17-libitm1_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libitm1:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libasan8:amd64. 636s Preparing to unpack .../18-libasan8_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libasan8:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package liblsan0:amd64. 636s Preparing to unpack .../19-liblsan0_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking liblsan0:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libtsan2:amd64. 636s Preparing to unpack .../20-libtsan2_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libtsan2:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libubsan1:amd64. 636s Preparing to unpack .../21-libubsan1_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libubsan1:amd64 (15-20250404-0ubuntu1) ... 636s Selecting previously unselected package libhwasan0:amd64. 636s Preparing to unpack .../22-libhwasan0_15-20250404-0ubuntu1_amd64.deb ... 636s Unpacking libhwasan0:amd64 (15-20250404-0ubuntu1) ... 637s Selecting previously unselected package libquadmath0:amd64. 637s Preparing to unpack .../23-libquadmath0_15-20250404-0ubuntu1_amd64.deb ... 637s Unpacking libquadmath0:amd64 (15-20250404-0ubuntu1) ... 637s Selecting previously unselected package libgcc-14-dev:amd64. 637s Preparing to unpack .../24-libgcc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 637s Preparing to unpack .../25-gcc-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package gcc-14. 637s Preparing to unpack .../26-gcc-14_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package gcc-x86-64-linux-gnu. 637s Preparing to unpack .../27-gcc-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 637s Unpacking gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 637s Selecting previously unselected package gcc. 637s Preparing to unpack .../28-gcc_4%3a14.2.0-1ubuntu1_amd64.deb ... 637s Unpacking gcc (4:14.2.0-1ubuntu1) ... 637s Selecting previously unselected package libstdc++-14-dev:amd64. 637s Preparing to unpack .../29-libstdc++-14-dev_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package g++-14-x86-64-linux-gnu. 637s Preparing to unpack .../30-g++-14-x86-64-linux-gnu_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package g++-14. 637s Preparing to unpack .../31-g++-14_14.2.0-19ubuntu2_amd64.deb ... 637s Unpacking g++-14 (14.2.0-19ubuntu2) ... 637s Selecting previously unselected package g++-x86-64-linux-gnu. 638s Preparing to unpack .../32-g++-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 638s Unpacking g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 638s Selecting previously unselected package g++. 638s Preparing to unpack .../33-g++_4%3a14.2.0-1ubuntu1_amd64.deb ... 638s Unpacking g++ (4:14.2.0-1ubuntu1) ... 638s Selecting previously unselected package build-essential. 638s Preparing to unpack .../34-build-essential_12.12ubuntu1_amd64.deb ... 638s Unpacking build-essential (12.12ubuntu1) ... 638s Selecting previously unselected package libllvm20:amd64. 638s Preparing to unpack .../35-libllvm20_1%3a20.1.2-0ubuntu1_amd64.deb ... 638s Unpacking libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 638s Selecting previously unselected package libclang-cpp20. 638s Preparing to unpack .../36-libclang-cpp20_1%3a20.1.2-0ubuntu1_amd64.deb ... 638s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package libgc1:amd64. 639s Preparing to unpack .../37-libgc1_1%3a8.2.8-1_amd64.deb ... 639s Unpacking libgc1:amd64 (1:8.2.8-1) ... 639s Selecting previously unselected package libobjc4:amd64. 639s Preparing to unpack .../38-libobjc4_15-20250404-0ubuntu1_amd64.deb ... 639s Unpacking libobjc4:amd64 (15-20250404-0ubuntu1) ... 639s Selecting previously unselected package libobjc-14-dev:amd64. 639s Preparing to unpack .../39-libobjc-14-dev_14.2.0-19ubuntu2_amd64.deb ... 639s Unpacking libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 639s Selecting previously unselected package libclang-common-20-dev:amd64. 639s Preparing to unpack .../40-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package llvm-20-linker-tools. 639s Preparing to unpack .../41-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package libclang1-20. 639s Preparing to unpack .../42-libclang1-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package clang-20. 639s Preparing to unpack .../43-clang-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package libncurses-dev:amd64. 639s Preparing to unpack .../44-libncurses-dev_6.5+20250216-2_amd64.deb ... 639s Unpacking libncurses-dev:amd64 (6.5+20250216-2) ... 639s Selecting previously unselected package libpq5:amd64. 639s Preparing to unpack .../45-libpq5_17.4-1_amd64.deb ... 639s Unpacking libpq5:amd64 (17.4-1) ... 639s Selecting previously unselected package libssl-dev:amd64. 639s Preparing to unpack .../46-libssl-dev_3.4.1-1ubuntu3_amd64.deb ... 639s Unpacking libssl-dev:amd64 (3.4.1-1ubuntu3) ... 639s Selecting previously unselected package libpq-dev. 639s Preparing to unpack .../47-libpq-dev_17.4-1_amd64.deb ... 639s Unpacking libpq-dev (17.4-1) ... 639s Selecting previously unselected package libxml2-dev:amd64. 639s Preparing to unpack .../48-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4_amd64.deb ... 639s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4) ... 639s Selecting previously unselected package libxslt1.1:amd64. 639s Preparing to unpack .../49-libxslt1.1_1.1.39-0exp1ubuntu4_amd64.deb ... 639s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 639s Selecting previously unselected package llvm-20-runtime. 639s Preparing to unpack .../50-llvm-20-runtime_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 639s Selecting previously unselected package libpfm4:amd64. 639s Preparing to unpack .../51-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 639s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 639s Selecting previously unselected package llvm-20. 639s Preparing to unpack .../52-llvm-20_1%3a20.1.2-0ubuntu1_amd64.deb ... 639s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 640s Selecting previously unselected package libffi-dev:amd64. 640s Preparing to unpack .../53-libffi-dev_3.4.7-1_amd64.deb ... 640s Unpacking libffi-dev:amd64 (3.4.7-1) ... 640s Selecting previously unselected package llvm-20-tools. 640s Preparing to unpack .../54-llvm-20-tools_1%3a20.1.2-0ubuntu1_amd64.deb ... 640s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 640s Selecting previously unselected package llvm-20-dev. 640s Preparing to unpack .../55-llvm-20-dev_1%3a20.1.2-0ubuntu1_amd64.deb ... 640s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 641s Selecting previously unselected package postgresql-client-17. 641s Preparing to unpack .../56-postgresql-client-17_17.4-1_amd64.deb ... 641s Unpacking postgresql-client-17 (17.4-1) ... 641s Selecting previously unselected package postgresql-17. 641s Preparing to unpack .../57-postgresql-17_17.4-1_amd64.deb ... 641s Unpacking postgresql-17 (17.4-1) ... 642s Selecting previously unselected package postgresql-server-dev-17. 642s Preparing to unpack .../58-postgresql-server-dev-17_17.4-1_amd64.deb ... 642s Unpacking postgresql-server-dev-17 (17.4-1) ... 642s Selecting previously unselected package tzdata-legacy. 642s Preparing to unpack .../59-tzdata-legacy_2025b-1ubuntu1_all.deb ... 642s Unpacking tzdata-legacy (2025b-1ubuntu1) ... 642s Setting up postgresql-client-common (277) ... 642s Setting up binutils-gold-x86-64-linux-gnu (2.44-2) ... 642s Setting up libncurses-dev:amd64 (6.5+20250216-2) ... 642s Setting up libio-pty-perl (1:1.20-1build3) ... 642s Setting up binutils-gold (2.44-2) ... 642s Setting up libclang-common-20-dev:amd64 (1:20.1.2-0ubuntu1) ... 642s Setting up libpq5:amd64 (17.4-1) ... 642s Setting up libgomp1:amd64 (15-20250404-0ubuntu1) ... 642s Setting up libffi-dev:amd64 (3.4.7-1) ... 642s Setting up tzdata-legacy (2025b-1ubuntu1) ... 642s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.4) ... 642s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 642s Setting up ssl-cert (1.1.3ubuntu1) ... 642s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 643s Setting up libquadmath0:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libssl-dev:amd64 (3.4.1-1ubuntu3) ... 643s Setting up libmpc3:amd64 (1.3.1-1build2) ... 643s Setting up libllvm20:amd64 (1:20.1.2-0ubuntu1) ... 643s Setting up libipc-run-perl (20231003.0-2) ... 643s Setting up libgc1:amd64 (1:8.2.8-1) ... 643s Setting up libubsan1:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libhwasan0:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libasan8:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libjson-perl (4.10000-1) ... 643s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu4) ... 643s Setting up libtsan2:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libisl23:amd64 (0.27-1) ... 643s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 643s Setting up libcc1-0:amd64 (15-20250404-0ubuntu1) ... 643s Setting up liblsan0:amd64 (15-20250404-0ubuntu1) ... 643s Setting up libitm1:amd64 (15-20250404-0ubuntu1) ... 643s Setting up postgresql-common-dev (277) ... 643s Setting up postgresql-client-17 (17.4-1) ... 643s 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 643s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 643s Setting up libpq-dev (17.4-1) ... 643s Setting up libobjc4:amd64 (15-20250404-0ubuntu1) ... 643s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 643s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 643s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 643s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 643s Setting up postgresql-common (277) ... 644s Creating config file /etc/postgresql-common/createcluster.conf with new version 644s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 644s Removing obsolete dictionary files: 644s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 645s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 645s Setting up cpp-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 645s Setting up cpp-14 (14.2.0-19ubuntu2) ... 645s Setting up libgcc-14-dev:amd64 (14.2.0-19ubuntu2) ... 645s Setting up libstdc++-14-dev:amd64 (14.2.0-19ubuntu2) ... 645s Setting up cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 645s Setting up postgresql-17 (17.4-1) ... 646s Creating new PostgreSQL cluster 17/main ... 646s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 646s The files belonging to this database system will be owned by user "postgres". 646s This user must also own the server process. 646s 646s The database cluster will be initialized with locale "C.UTF-8". 646s The default database encoding has accordingly been set to "UTF8". 646s The default text search configuration will be set to "english". 646s 646s Data page checksums are disabled. 646s 646s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 646s creating subdirectories ... ok 646s selecting dynamic shared memory implementation ... posix 646s selecting default "max_connections" ... 100 646s selecting default "shared_buffers" ... 128MB 646s selecting default time zone ... Etc/UTC 646s creating configuration files ... ok 646s running bootstrap script ... ok 646s performing post-bootstrap initialization ... ok 646s syncing data to disk ... ok 649s Setting up libobjc-14-dev:amd64 (14.2.0-19ubuntu2) ... 649s Setting up cpp (4:14.2.0-1ubuntu1) ... 649s Setting up gcc-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 649s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 649s Setting up gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 649s Setting up gcc-14 (14.2.0-19ubuntu2) ... 649s Setting up postgresql-server-dev-17 (17.4-1) ... 649s Setting up g++-14-x86-64-linux-gnu (14.2.0-19ubuntu2) ... 649s Setting up g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 649s Setting up g++-14 (14.2.0-19ubuntu2) ... 649s Setting up gcc (4:14.2.0-1ubuntu1) ... 649s Setting up g++ (4:14.2.0-1ubuntu1) ... 649s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 649s Setting up build-essential (12.12ubuntu1) ... 649s Processing triggers for libc-bin (2.41-6ubuntu1) ... 649s Processing triggers for systemd (257.4-1ubuntu3) ... 649s Processing triggers for man-db (2.13.0-1) ... 650s Processing triggers for install-info (7.1.1-1) ... 665s autopkgtest [14:52:18]: test installcheck: [----------------------- 665s + dpkg-parsechangelog -SSource 665s + SOURCE=postgresql-17 665s + MAJOR=17 665s + top_srcdir=/tmp/autopkgtest.ZyxIw0/build.yAP/src 665s + cd src/test/regress 665s + make -f /tmp/autopkgtest.ZyxIw0/build.yAP/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 665s 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.ZyxIw0/build.yAP/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 665s 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 666s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.ZyxIw0/build.yAP/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 666s + id -u 666s + [ 1000 = 0 ] 666s + SU=sh 666s + sh 666s + mktemp -d /tmp/regress.XXXXXX 666s + OUTPUT=/tmp/regress.rsB9CZ 666s + trap rm -rf /tmp/regress.rsB9CZ EXIT 666s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.rsB9CZ --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 666s Creating new PostgreSQL cluster 17/regress ... 669s # using postmaster on localhost, port 5433 669s ok 1 - test_setup 151 ms 670s # parallel group (20 tests): varchar char name int4 text int2 txid oid int8 pg_lsn float4 float8 money uuid enum regproc boolean bit numeric rangetypes 670s ok 2 + boolean 478 ms 670s ok 3 + char 153 ms 670s ok 4 + name 171 ms 670s ok 5 + varchar 146 ms 670s ok 6 + text 196 ms 670s ok 7 + int2 198 ms 670s ok 8 + int4 185 ms 670s ok 9 + int8 250 ms 670s ok 10 + oid 244 ms 670s ok 11 + float4 270 ms 670s ok 12 + float8 274 ms 670s ok 13 + bit 490 ms 670s ok 14 + numeric 584 ms 670s ok 15 + txid 222 ms 670s ok 16 + uuid 273 ms 670s ok 17 + enum 287 ms 670s ok 18 + money 264 ms 670s ok 19 + rangetypes 660 ms 670s ok 20 + pg_lsn 241 ms 670s ok 21 + regproc 286 ms 671s # parallel group (20 tests): md5 path lseg line circle time macaddr macaddr8 timetz numerology inet date strings interval point timestamp timestamptz polygon multirangetypes box 671s ok 22 + strings 427 ms 671s ok 23 + md5 130 ms 671s ok 24 + numerology 241 ms 671s ok 25 + point 485 ms 671s ok 26 + lseg 145 ms 671s ok 27 + line 160 ms 671s ok 28 + box 1044 ms 671s ok 29 + path 129 ms 671s ok 30 + polygon 726 ms 671s ok 31 + circle 168 ms 671s ok 32 + date 298 ms 671s ok 33 + time 193 ms 671s ok 34 + timetz 207 ms 671s ok 35 + timestamp 552 ms 671s ok 36 + timestamptz 565 ms 671s ok 37 + interval 426 ms 671s ok 38 + inet 252 ms 671s ok 39 + macaddr 193 ms 671s ok 40 + macaddr8 194 ms 671s ok 41 + multirangetypes 862 ms 672s # parallel group (13 tests): comments misc_sanity unicode xid tstypes expressions mvcc type_sanity geometry opr_sanity horology regex database 672s ok 42 + geometry 369 ms 672s ok 43 + horology 578 ms 672s ok 44 + tstypes 207 ms 672s ok 45 + regex 589 ms 672s ok 46 + type_sanity 297 ms 672s ok 47 + opr_sanity 557 ms 672s ok 48 + misc_sanity 108 ms 672s ok 49 + comments 100 ms 672s ok 50 + expressions 221 ms 672s ok 51 + unicode 120 ms 672s ok 52 + xid 158 ms 672s ok 53 + mvcc 224 ms 672s ok 54 + database 604 ms 672s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 672s ok 55 + copy 132 ms 672s ok 56 + copyselect 85 ms 672s ok 57 + copydml 90 ms 672s ok 58 + insert 311 ms 672s ok 59 + insert_conflict 169 ms 672s # parallel group (7 tests): create_function_c create_type create_operator create_procedure create_misc create_schema create_table 672s ok 60 + create_function_c 38 ms 672s ok 61 + create_misc 128 ms 672s ok 62 + create_operator 105 ms 672s ok 63 + create_procedure 116 ms 672s ok 64 + create_table 308 ms 672s ok 65 + create_type 97 ms 672s ok 66 + create_schema 116 ms 673s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 673s ok 67 + create_index 925 ms 673s ok 68 + create_index_spgist 850 ms 673s ok 69 + create_view 349 ms 673s ok 70 + index_including 218 ms 673s ok 71 + index_including_gist 297 ms 674s # parallel group (16 tests): create_cast create_aggregate hash_func errors roleattributes typed_table drop_if_exists create_function_sql create_am select constraints infinite_recurse vacuum updatable_views triggers inherit 674s ok 72 + create_aggregate 185 ms 674s ok 73 + create_function_sql 408 ms 674s ok 74 + create_cast 110 ms 674s ok 75 + constraints 546 ms 674s ok 76 + triggers 1032 ms 674s ok 77 + select 521 ms 674s ok 78 + inherit 1040 ms 674s ok 79 + typed_table 280 ms 674s ok 80 + vacuum 648 ms 674s ok 81 + drop_if_exists 312 ms 674s ok 82 + updatable_views 817 ms 674s ok 83 + roleattributes 217 ms 674s ok 84 + create_am 401 ms 674s ok 85 + hash_func 177 ms 674s ok 86 + errors 193 ms 674s ok 87 + infinite_recurse 609 ms 674s ok 88 - sanity_check 63 ms 676s # parallel group (20 tests): select_having delete select_distinct_on select_implicit case select_into random namespace prepared_xacts transactions portals union select_distinct subselect arrays update hash_index btree_index join aggregates 676s ok 89 + select_into 278 ms 676s ok 90 + select_distinct 682 ms 676s ok 91 + select_distinct_on 186 ms 676s ok 92 + select_implicit 264 ms 676s ok 93 + select_having 155 ms 676s ok 94 + subselect 742 ms 676s ok 95 + union 665 ms 676s ok 96 + case 266 ms 676s ok 97 + join 1882 ms 676s ok 98 + aggregates 1886 ms 676s ok 99 + transactions 420 ms 676s ok 100 + random 290 ms 676s ok 101 + portals 602 ms 676s ok 102 + arrays 816 ms 676s ok 103 + btree_index 1730 ms 676s ok 104 + hash_index 1247 ms 676s ok 105 + update 1183 ms 676s ok 106 + delete 137 ms 676s ok 107 + namespace 276 ms 676s ok 108 + prepared_xacts 321 ms 682s # parallel group (20 tests): init_privs security_label drop_operator tablesample object_address lock password replica_identity matview identity spgist collate generated gist rowsecurity groupingsets gin join_hash brin privileges 682s ok 109 + brin 4996 ms 682s ok 110 + gin 2099 ms 682s ok 111 + gist 1724 ms 682s ok 112 + spgist 1442 ms 682s ok 113 + privileges 5347 ms 682s ok 114 + init_privs 160 ms 682s ok 115 + security_label 205 ms 682s ok 116 + collate 1583 ms 682s ok 117 + matview 1152 ms 682s ok 118 + lock 403 ms 682s ok 119 + replica_identity 602 ms 682s ok 120 + rowsecurity 1764 ms 682s ok 121 + object_address 394 ms 682s ok 122 + tablesample 360 ms 682s ok 123 + groupingsets 1960 ms 682s ok 124 + drop_operator 190 ms 682s ok 125 + password 516 ms 682s ok 126 + identity 1289 ms 682s ok 127 + generated 1583 ms 682s ok 128 + join_hash 4969 ms 682s # parallel group (2 tests): brin_bloom brin_multi 682s ok 129 + brin_bloom 74 ms 682s ok 130 + brin_multi 201 ms 683s # parallel group (17 tests): async dbsize collate.utf8 alter_operator tidscan tid tsrf create_role alter_generic sysviews misc_functions tidrangescan create_table_like merge incremental_sort misc collate.icu.utf8 683s ok 131 + create_table_like 697 ms 683s ok 132 + alter_generic 447 ms 683s ok 133 + alter_operator 219 ms 683s ok 134 + misc 970 ms 683s ok 135 + async 99 ms 683s ok 136 + dbsize 133 ms 683s ok 137 + merge 719 ms 683s ok 138 + misc_functions 553 ms 683s ok 139 + sysviews 530 ms 683s ok 140 + tsrf 255 ms 683s ok 141 + tid 244 ms 683s ok 142 + tidscan 232 ms 683s ok 143 + tidrangescan 659 ms 683s ok 144 + collate.utf8 178 ms 683s ok 145 + collate.icu.utf8 976 ms 683s ok 146 + incremental_sort 777 ms 683s ok 147 + create_role 288 ms 684s # parallel group (7 tests): psql_crosstab amutils collate.linux.utf8 collate.windows.win1252 rules psql stats_ext 684s ok 148 + rules 264 ms 684s ok 149 + psql 356 ms 684s ok 150 + psql_crosstab 45 ms 684s ok 151 + amutils 63 ms 684s ok 152 + stats_ext 948 ms 684s ok 153 + collate.linux.utf8 64 ms 684s ok 154 + collate.windows.win1252 68 ms 687s ok 155 - select_parallel 3109 ms 687s ok 156 - write_parallel 122 ms 687s ok 157 - vacuum_parallel 70 ms 688s # parallel group (2 tests): subscription publication 688s ok 158 + publication 1236 ms 688s ok 159 + subscription 62 ms 690s # parallel group (17 tests): portals_p2 dependency advisory_lock combocid xmlmap tsdicts functional_deps equivclass guc select_views bitmapops window cluster indirect_toast foreign_data foreign_key tsearch 690s ok 160 + select_views 427 ms 690s ok 161 + portals_p2 168 ms 690s ok 162 + foreign_key 1498 ms 690s ok 163 + cluster 802 ms 690s ok 164 + dependency 222 ms 690s ok 165 + guc 347 ms 690s ok 166 + bitmapops 683 ms 690s ok 167 + combocid 243 ms 690s ok 168 + tsearch 1553 ms 690s ok 169 + tsdicts 305 ms 690s ok 170 + foreign_data 1010 ms 690s ok 171 + window 741 ms 690s ok 172 + xmlmap 259 ms 690s ok 173 + functional_deps 301 ms 690s ok 174 + advisory_lock 213 ms 690s ok 175 + indirect_toast 842 ms 690s ok 176 + equivclass 325 ms 690s # parallel group (9 tests): json_encoding jsonpath_encoding jsonpath sqljson sqljson_jsontable json sqljson_queryfuncs jsonb_jsonpath jsonb 690s ok 177 + json 264 ms 690s ok 178 + jsonb 352 ms 690s ok 179 + json_encoding 55 ms 690s ok 180 + jsonpath 129 ms 690s ok 181 + jsonpath_encoding 84 ms 690s ok 182 + jsonb_jsonpath 296 ms 690s ok 183 + sqljson 163 ms 690s ok 184 + sqljson_queryfuncs 269 ms 690s ok 185 + sqljson_jsontable 201 ms 692s # parallel group (18 tests): prepare returning limit conversion plancache temp polymorphism sequence copy2 largeobject truncate rowtypes domain with rangefuncs plpgsql xml alter_table 692s ok 186 + plancache 443 ms 692s ok 187 + limit 388 ms 692s ok 188 + plpgsql 1239 ms 692s ok 189 + copy2 790 ms 692s ok 190 + temp 612 ms 692s ok 191 + domain 956 ms 692s ok 192 + rangefuncs 1094 ms 692s ok 193 + prepare 219 ms 692s ok 194 + conversion 414 ms 692s ok 195 + truncate 807 ms 692s ok 196 + alter_table 1663 ms 692s ok 197 + sequence 748 ms 692s ok 198 + polymorphism 685 ms 692s ok 199 + rowtypes 805 ms 692s ok 200 + returning 259 ms 692s ok 201 + largeobject 774 ms 692s ok 202 + with 999 ms 692s ok 203 + xml 1287 ms 694s # parallel group (13 tests): hash_part reloptions predicate explain partition_info compression memoize partition_aggregate partition_join indexing stats tuplesort partition_prune 694s ok 204 + partition_join 1594 ms 694s ok 205 + partition_prune 1996 ms 694s ok 206 + reloptions 259 ms 694s ok 207 + hash_part 173 ms 694s ok 208 + indexing 1626 ms 694s ok 209 + partition_aggregate 1426 ms 694s ok 210 + partition_info 306 ms 694s ok 211 + tuplesort 1653 ms 694s ok 212 + explain 302 ms 694s ok 213 + compression 497 ms 694s ok 214 + memoize 1185 ms 694s ok 215 + stats 1640 ms 694s ok 216 + predicate 260 ms 694s # parallel group (2 tests): oidjoins event_trigger 694s ok 217 + oidjoins 157 ms 694s ok 218 + event_trigger 173 ms 694s ok 219 - event_trigger_login 47 ms 695s ok 220 - fast_default 91 ms 695s ok 221 - tablespace 218 ms 695s 1..221 695s # All 221 tests passed. 695s Dropping cluster 17/regress ... 695s + rm -rf /tmp/regress.rsB9CZ 695s autopkgtest [14:52:48]: test installcheck: -----------------------] 696s installcheck PASS 696s autopkgtest [14:52:49]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 696s autopkgtest [14:52:49]: @@@@@@@@@@@@@@@@@@@@ summary 696s run-testsuite PASS 696s installcheck PASS 701s nova [W] Skipping flock for amd64 701s Creating nova instance adt-questing-amd64-postgresql-17-20250503-144113-juju-7f2275-prod-proposed-migration-environment-15-65114648-f150-468a-911c-a4abe234d10b from image adt/ubuntu-questing-amd64-server-20250503.img (UUID 57b7c1b6-ad80-4bdb-b031-36f045f7f3b3)... 701s nova [W] Timed out waiting for 99a531fa-7a31-4593-97e1-de38f6c1fdf8 to get deleted. 701s nova [W] Skipping flock for amd64 701s Creating nova instance adt-questing-amd64-postgresql-17-20250503-144113-juju-7f2275-prod-proposed-migration-environment-15-65114648-f150-468a-911c-a4abe234d10b from image adt/ubuntu-questing-amd64-server-20250503.img (UUID 57b7c1b6-ad80-4bdb-b031-36f045f7f3b3)... 701s nova [W] Timed out waiting for 2c970fab-bf55-42b4-b6e2-0a54ace354f8 to get deleted.