0s autopkgtest [11:20:03]: starting date and time: 2025-05-03 11:20:03+0000 0s autopkgtest [11:20:03]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [11:20:03]: host juju-7f2275-prod-proposed-migration-environment-21; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ett36qhk/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:libzstd --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=libzstd/1.5.7+dfsg-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-21@bos03-ppc64el-2.secgroup --name adt-questing-ppc64el-postgresql-17-20250503-112003-juju-7f2275-prod-proposed-migration-environment-21-d03ee94a-e83d-4464-ba87-caebcc06aa1e --image adt/ubuntu-questing-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-21 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 100s autopkgtest [11:21:43]: testbed dpkg architecture: ppc64el 100s autopkgtest [11:21:43]: testbed apt version: 3.0.0 100s autopkgtest [11:21:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 101s autopkgtest [11:21:44]: testbed release detected to be: None 101s autopkgtest [11:21:44]: updating testbed package index (apt update) 102s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 102s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 102s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 102s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 102s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.6 kB] 102s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1655 kB] 103s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [155 kB] 103s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el Packages [187 kB] 103s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe ppc64el Packages [1285 kB] 103s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse ppc64el Packages [14.1 kB] 103s Fetched 3452 kB in 2s (2137 kB/s) 104s Reading package lists... 105s autopkgtest [11:21:48]: upgrading testbed (apt dist-upgrade and autopurge) 105s Reading package lists... 105s Building dependency tree... 105s Reading state information... 106s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 106s Starting 2 pkgProblemResolver with broken count: 0 106s Done 107s Entering ResolveByKeep 107s 107s Calculating upgrade... 107s The following packages will be upgraded: 107s debianutils libnftnl11 libzstd1 python3-lazr.restfulclient zstd 107s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s Need to get 1443 kB of archives. 107s After this operation, 1024 B of additional disk space will be used. 107s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el debianutils ppc64el 5.22 [93.9 kB] 108s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el libzstd1 ppc64el 1.5.7+dfsg-1 [410 kB] 108s Get:3 http://ftpmaster.internal/ubuntu questing/main ppc64el libnftnl11 ppc64el 1.2.9-1 [77.1 kB] 108s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 108s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el zstd ppc64el 1.5.7+dfsg-1 [811 kB] 109s Fetched 1443 kB in 1s (1362 kB/s) 109s (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 ... 107205 files and directories currently installed.) 109s Preparing to unpack .../debianutils_5.22_ppc64el.deb ... 109s Unpacking debianutils (5.22) over (5.21) ... 109s Setting up debianutils (5.22) ... 109s (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 ... 107205 files and directories currently installed.) 109s Preparing to unpack .../libzstd1_1.5.7+dfsg-1_ppc64el.deb ... 109s Unpacking libzstd1:ppc64el (1.5.7+dfsg-1) over (1.5.6+dfsg-2) ... 109s Setting up libzstd1:ppc64el (1.5.7+dfsg-1) ... 109s (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 ... 107205 files and directories currently installed.) 109s Preparing to unpack .../libnftnl11_1.2.9-1_ppc64el.deb ... 109s Unpacking libnftnl11:ppc64el (1.2.9-1) over (1.2.8-1) ... 109s Preparing to unpack .../python3-lazr.restfulclient_0.14.6-3_all.deb ... 110s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 110s Preparing to unpack .../zstd_1.5.7+dfsg-1_ppc64el.deb ... 110s Unpacking zstd (1.5.7+dfsg-1) over (1.5.6+dfsg-2) ... 110s Setting up libnftnl11:ppc64el (1.2.9-1) ... 110s Setting up python3-lazr.restfulclient (0.14.6-3) ... 110s Setting up zstd (1.5.7+dfsg-1) ... 110s Processing triggers for man-db (2.13.0-1) ... 111s Processing triggers for libc-bin (2.41-6ubuntu1) ... 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 112s Starting 2 pkgProblemResolver with broken count: 0 112s Done 113s Solving dependencies... 113s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 116s autopkgtest [11:21:59]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 14:52:42 UTC 2025 116s autopkgtest [11:21:59]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 128s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (dsc) [4245 B] 128s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (tar) [21.5 MB] 128s Get:3 http://ftpmaster.internal/ubuntu questing/main postgresql-17 17.4-1 (diff) [27.2 kB] 128s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 128s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 128s gpgv: Can't check signature: No public key 128s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 133s autopkgtest [11:22:16]: testing package postgresql-17 version 17.4-1 134s autopkgtest [11:22:17]: build not needed 141s autopkgtest [11:22:24]: test run-testsuite: preparing testbed 141s Reading package lists... 141s Building dependency tree... 141s Reading state information... 142s Starting pkgProblemResolver with broken count: 0 142s Starting 2 pkgProblemResolver with broken count: 0 142s Done 142s The following NEW packages will be installed: 142s autoconf automake autopoint autotools-dev binutils-gold 142s binutils-gold-powerpc64le-linux-gnu build-essential clang-20 cpp cpp-14 142s cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu debhelper debugedit 142s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 142s fakeroot g++ g++-14 g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu 142s gcc gcc-14 gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu gettext 142s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libcc1-0 142s libclang-common-20-dev libclang-cpp20 libclang1-20 libdebhelper-perl 142s libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 142s libfile-stripnondeterminism-perl libgc1 libgcc-14-dev libgomp1 142s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl libllvm20 142s liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpgtypes3 142s libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev libtcl8.6 libtool 142s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 142s llvm-20-linker-tools llvm-20-runtime llvm-20-tools locales-all m4 po-debconf 142s postgresql-17 postgresql-client-17 postgresql-client-common 142s postgresql-common postgresql-common-dev postgresql-doc-17 142s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 142s postgresql-server-dev-17 ssl-cert 142s 0 upgraded, 90 newly installed, 0 to remove and 0 not upgraded. 142s Need to get 238 MB of archives. 142s After this operation, 1405 MB of additional disk space will be used. 142s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 143s Get:2 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-common all 274 [47.6 kB] 143s Get:3 http://ftpmaster.internal/ubuntu questing/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 143s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 143s Get:5 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common-dev all 274 [73.0 kB] 143s Get:6 http://ftpmaster.internal/ubuntu questing/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 143s Get:7 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common all 274 [101 kB] 143s Get:8 http://ftpmaster.internal/ubuntu questing/main ppc64el m4 ppc64el 1.4.19-7 [279 kB] 143s Get:9 http://ftpmaster.internal/ubuntu questing/main ppc64el autoconf all 2.72-3ubuntu1 [383 kB] 143s Get:10 http://ftpmaster.internal/ubuntu questing/main ppc64el autotools-dev all 20220109.1 [44.9 kB] 143s Get:11 http://ftpmaster.internal/ubuntu questing/main ppc64el automake all 1:1.17-3ubuntu1 [572 kB] 143s Get:12 http://ftpmaster.internal/ubuntu questing/main ppc64el autopoint all 0.23.1-1 [619 kB] 143s Get:13 http://ftpmaster.internal/ubuntu questing/main ppc64el binutils-gold-powerpc64le-linux-gnu ppc64el 2.44-2 [1638 kB] 143s Get:14 http://ftpmaster.internal/ubuntu questing/main ppc64el binutils-gold ppc64el 2.44-2 [2176 B] 143s Get:15 http://ftpmaster.internal/ubuntu questing/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 143s Get:16 http://ftpmaster.internal/ubuntu questing/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 143s Get:17 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [10.5 MB] 145s Get:18 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-14 ppc64el 14.2.0-19ubuntu2 [1036 B] 145s Get:19 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [5566 B] 145s Get:20 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp ppc64el 4:14.2.0-1ubuntu1 [22.4 kB] 145s Get:21 http://ftpmaster.internal/ubuntu questing/main ppc64el libcc1-0 ppc64el 15-20250404-0ubuntu1 [48.6 kB] 145s Get:22 http://ftpmaster.internal/ubuntu questing/main ppc64el libgomp1 ppc64el 15-20250404-0ubuntu1 [168 kB] 145s Get:23 http://ftpmaster.internal/ubuntu questing/main ppc64el libitm1 ppc64el 15-20250404-0ubuntu1 [32.3 kB] 145s Get:24 http://ftpmaster.internal/ubuntu questing/main ppc64el libasan8 ppc64el 15-20250404-0ubuntu1 [3007 kB] 146s Get:25 http://ftpmaster.internal/ubuntu questing/main ppc64el liblsan0 ppc64el 15-20250404-0ubuntu1 [1374 kB] 146s Get:26 http://ftpmaster.internal/ubuntu questing/main ppc64el libtsan2 ppc64el 15-20250404-0ubuntu1 [2732 kB] 146s Get:27 http://ftpmaster.internal/ubuntu questing/main ppc64el libubsan1 ppc64el 15-20250404-0ubuntu1 [1232 kB] 147s Get:28 http://ftpmaster.internal/ubuntu questing/main ppc64el libquadmath0 ppc64el 15-20250404-0ubuntu1 [160 kB] 147s Get:29 http://ftpmaster.internal/ubuntu questing/main ppc64el libgcc-14-dev ppc64el 14.2.0-19ubuntu2 [1618 kB] 147s Get:30 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [20.6 MB] 151s Get:31 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-14 ppc64el 14.2.0-19ubuntu2 [540 kB] 151s Get:32 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [1226 B] 151s Get:33 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc ppc64el 4:14.2.0-1ubuntu1 [5012 B] 151s Get:34 http://ftpmaster.internal/ubuntu questing/main ppc64el libstdc++-14-dev ppc64el 14.2.0-19ubuntu2 [2679 kB] 152s Get:35 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [12.0 MB] 155s Get:36 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-14 ppc64el 14.2.0-19ubuntu2 [23.0 kB] 155s Get:37 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [966 B] 155s Get:38 http://ftpmaster.internal/ubuntu questing/main ppc64el g++ ppc64el 4:14.2.0-1ubuntu1 [1088 B] 155s Get:39 http://ftpmaster.internal/ubuntu questing/main ppc64el build-essential ppc64el 12.12ubuntu1 [5094 B] 155s Get:40 http://ftpmaster.internal/ubuntu questing/main ppc64el libllvm20 ppc64el 1:20.1.2-0ubuntu1 [32.0 MB] 161s Get:41 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang-cpp20 ppc64el 1:20.1.2-0ubuntu1 [15.0 MB] 163s Get:42 http://ftpmaster.internal/ubuntu questing/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 163s Get:43 http://ftpmaster.internal/ubuntu questing/universe ppc64el libobjc4 ppc64el 15-20250404-0ubuntu1 [53.6 kB] 163s Get:44 http://ftpmaster.internal/ubuntu questing/universe ppc64el libobjc-14-dev ppc64el 14.2.0-19ubuntu2 [202 kB] 163s Get:45 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang-common-20-dev ppc64el 1:20.1.2-0ubuntu1 [782 kB] 163s Get:46 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-linker-tools ppc64el 1:20.1.2-0ubuntu1 [1405 kB] 163s Get:47 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang1-20 ppc64el 1:20.1.2-0ubuntu1 [9064 kB] 165s Get:48 http://ftpmaster.internal/ubuntu questing/universe ppc64el clang-20 ppc64el 1:20.1.2-0ubuntu1 [80.9 kB] 165s Get:49 http://ftpmaster.internal/ubuntu questing/main ppc64el libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 165s Get:50 http://ftpmaster.internal/ubuntu questing/main ppc64el libtool all 2.5.4-4 [168 kB] 165s Get:51 http://ftpmaster.internal/ubuntu questing/main ppc64el dh-autoreconf all 20 [16.1 kB] 165s Get:52 http://ftpmaster.internal/ubuntu questing/main ppc64el libarchive-zip-perl all 1.68-1 [90.2 kB] 165s Get:53 http://ftpmaster.internal/ubuntu questing/main ppc64el libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 165s Get:54 http://ftpmaster.internal/ubuntu questing/main ppc64el dh-strip-nondeterminism all 1.14.1-2 [5064 B] 165s Get:55 http://ftpmaster.internal/ubuntu questing/main ppc64el debugedit ppc64el 1:5.1-2 [52.4 kB] 165s Get:56 http://ftpmaster.internal/ubuntu questing/main ppc64el dwz ppc64el 0.15-1build6 [142 kB] 165s Get:57 http://ftpmaster.internal/ubuntu questing/main ppc64el gettext ppc64el 0.23.1-1 [1155 kB] 165s Get:58 http://ftpmaster.internal/ubuntu questing/main ppc64el intltool-debian all 0.35.0+20060710.6 [23.2 kB] 165s Get:59 http://ftpmaster.internal/ubuntu questing/main ppc64el po-debconf all 1.0.21+nmu1 [233 kB] 165s Get:60 http://ftpmaster.internal/ubuntu questing/main ppc64el debhelper all 13.24.1ubuntu2 [895 kB] 165s Get:61 http://ftpmaster.internal/ubuntu questing/main ppc64el emacsen-common all 3.0.7 [13.0 kB] 165s Get:62 http://ftpmaster.internal/ubuntu questing/main ppc64el dictionaries-common all 1.30.10 [178 kB] 165s Get:63 http://ftpmaster.internal/ubuntu questing/main ppc64el libfakeroot ppc64el 1.37.1-1 [36.0 kB] 165s Get:64 http://ftpmaster.internal/ubuntu questing/main ppc64el fakeroot ppc64el 1.37.1-1 [70.5 kB] 165s Get:65 http://ftpmaster.internal/ubuntu questing/main ppc64el hunspell-en-us all 1:2020.12.07-4 [585 kB] 165s Get:66 http://ftpmaster.internal/ubuntu questing/main ppc64el libpgtypes3 ppc64el 17.4-1 [50.4 kB] 165s Get:67 http://ftpmaster.internal/ubuntu questing/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 165s Get:68 http://ftpmaster.internal/ubuntu questing/main ppc64el libecpg6 ppc64el 17.4-1 [55.4 kB] 165s Get:69 http://ftpmaster.internal/ubuntu questing/main ppc64el libecpg-compat3 ppc64el 17.4-1 [14.0 kB] 165s Get:70 http://ftpmaster.internal/ubuntu questing/main ppc64el libssl-dev ppc64el 3.4.1-1ubuntu3 [3140 kB] 165s Get:71 http://ftpmaster.internal/ubuntu questing/main ppc64el libpq-dev ppc64el 17.4-1 [177 kB] 166s Get:72 http://ftpmaster.internal/ubuntu questing/main ppc64el libecpg-dev ppc64el 17.4-1 [287 kB] 166s Get:73 http://ftpmaster.internal/ubuntu questing/main ppc64el libncurses-dev ppc64el 6.5+20250216-2 [484 kB] 166s Get:74 http://ftpmaster.internal/ubuntu questing/main ppc64el libtcl8.6 ppc64el 8.6.16+dfsg-1 [1201 kB] 166s Get:75 http://ftpmaster.internal/ubuntu questing/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg+really2.9.14-0.4 [916 kB] 166s Get:76 http://ftpmaster.internal/ubuntu questing/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu4 [191 kB] 166s Get:77 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-runtime ppc64el 1:20.1.2-0ubuntu1 [601 kB] 166s Get:78 http://ftpmaster.internal/ubuntu questing/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 166s Get:79 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20 ppc64el 1:20.1.2-0ubuntu1 [21.5 MB] 167s Get:80 http://ftpmaster.internal/ubuntu questing/main ppc64el libffi-dev ppc64el 3.4.7-1 [67.7 kB] 167s Get:81 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-tools ppc64el 1:20.1.2-0ubuntu1 [600 kB] 167s Get:82 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-dev ppc64el 1:20.1.2-0ubuntu1 [50.8 MB] 170s Get:83 http://ftpmaster.internal/ubuntu questing/universe ppc64el locales-all ppc64el 2.41-6ubuntu1 [11.2 MB] 171s Get:84 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 171s Get:85 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 172s Get:86 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-doc-17 all 17.4-1 [2131 kB] 172s Get:87 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-plperl-17 ppc64el 17.4-1 [74.6 kB] 172s Get:88 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-plpython3-17 ppc64el 17.4-1 [80.1 kB] 172s Get:89 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-pltcl-17 ppc64el 17.4-1 [31.8 kB] 172s Get:90 http://ftpmaster.internal/ubuntu questing/universe ppc64el postgresql-server-dev-17 ppc64el 17.4-1 [1440 kB] 172s Preconfiguring packages ... 173s Fetched 238 MB in 30s (8018 kB/s) 173s Selecting previously unselected package libjson-perl. 173s (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 ... 107205 files and directories currently installed.) 173s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 173s Unpacking libjson-perl (4.10000-1) ... 173s Selecting previously unselected package postgresql-client-common. 173s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 173s Unpacking postgresql-client-common (274) ... 173s Selecting previously unselected package libio-pty-perl. 173s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 173s Unpacking libio-pty-perl (1:1.20-1build3) ... 173s Selecting previously unselected package libipc-run-perl. 173s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 173s Unpacking libipc-run-perl (20231003.0-2) ... 173s Selecting previously unselected package postgresql-common-dev. 173s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 173s Unpacking postgresql-common-dev (274) ... 173s Selecting previously unselected package ssl-cert. 173s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 173s Unpacking ssl-cert (1.1.3ubuntu1) ... 173s Selecting previously unselected package postgresql-common. 173s Preparing to unpack .../06-postgresql-common_274_all.deb ... 173s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 173s Unpacking postgresql-common (274) ... 173s Selecting previously unselected package m4. 173s Preparing to unpack .../07-m4_1.4.19-7_ppc64el.deb ... 173s Unpacking m4 (1.4.19-7) ... 173s Selecting previously unselected package autoconf. 173s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 173s Unpacking autoconf (2.72-3ubuntu1) ... 173s Selecting previously unselected package autotools-dev. 173s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 173s Unpacking autotools-dev (20220109.1) ... 173s Selecting previously unselected package automake. 173s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 173s Unpacking automake (1:1.17-3ubuntu1) ... 173s Selecting previously unselected package autopoint. 173s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 173s Unpacking autopoint (0.23.1-1) ... 173s Selecting previously unselected package binutils-gold-powerpc64le-linux-gnu. 173s Preparing to unpack .../12-binutils-gold-powerpc64le-linux-gnu_2.44-2_ppc64el.deb ... 173s Unpacking binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 173s Selecting previously unselected package binutils-gold. 173s Preparing to unpack .../13-binutils-gold_2.44-2_ppc64el.deb ... 173s Unpacking binutils-gold (2.44-2) ... 173s Selecting previously unselected package libisl23:ppc64el. 173s Preparing to unpack .../14-libisl23_0.27-1_ppc64el.deb ... 173s Unpacking libisl23:ppc64el (0.27-1) ... 173s Selecting previously unselected package libmpc3:ppc64el. 173s Preparing to unpack .../15-libmpc3_1.3.1-1build2_ppc64el.deb ... 173s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 173s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 173s Preparing to unpack .../16-cpp-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 173s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 174s Selecting previously unselected package cpp-14. 174s Preparing to unpack .../17-cpp-14_14.2.0-19ubuntu2_ppc64el.deb ... 174s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 174s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 174s Preparing to unpack .../18-cpp-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 174s Unpacking cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 174s Selecting previously unselected package cpp. 174s Preparing to unpack .../19-cpp_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 174s Unpacking cpp (4:14.2.0-1ubuntu1) ... 174s Selecting previously unselected package libcc1-0:ppc64el. 174s Preparing to unpack .../20-libcc1-0_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libgomp1:ppc64el. 174s Preparing to unpack .../21-libgomp1_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libgomp1:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libitm1:ppc64el. 174s Preparing to unpack .../22-libitm1_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libitm1:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libasan8:ppc64el. 174s Preparing to unpack .../23-libasan8_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libasan8:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package liblsan0:ppc64el. 174s Preparing to unpack .../24-liblsan0_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking liblsan0:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libtsan2:ppc64el. 174s Preparing to unpack .../25-libtsan2_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libtsan2:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libubsan1:ppc64el. 174s Preparing to unpack .../26-libubsan1_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libubsan1:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libquadmath0:ppc64el. 174s Preparing to unpack .../27-libquadmath0_15-20250404-0ubuntu1_ppc64el.deb ... 174s Unpacking libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 174s Selecting previously unselected package libgcc-14-dev:ppc64el. 174s Preparing to unpack .../28-libgcc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 174s Unpacking libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 174s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 174s Preparing to unpack .../29-gcc-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 174s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 175s Selecting previously unselected package gcc-14. 175s Preparing to unpack .../30-gcc-14_14.2.0-19ubuntu2_ppc64el.deb ... 175s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 175s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 175s Preparing to unpack .../31-gcc-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 175s Unpacking gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 175s Selecting previously unselected package gcc. 175s Preparing to unpack .../32-gcc_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 175s Unpacking gcc (4:14.2.0-1ubuntu1) ... 175s Selecting previously unselected package libstdc++-14-dev:ppc64el. 175s Preparing to unpack .../33-libstdc++-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 175s Unpacking libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 175s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 175s Preparing to unpack .../34-g++-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 175s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 175s Selecting previously unselected package g++-14. 175s Preparing to unpack .../35-g++-14_14.2.0-19ubuntu2_ppc64el.deb ... 175s Unpacking g++-14 (14.2.0-19ubuntu2) ... 175s Selecting previously unselected package g++-powerpc64le-linux-gnu. 175s Preparing to unpack .../36-g++-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 175s Unpacking g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 175s Selecting previously unselected package g++. 175s Preparing to unpack .../37-g++_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 175s Unpacking g++ (4:14.2.0-1ubuntu1) ... 175s Selecting previously unselected package build-essential. 175s Preparing to unpack .../38-build-essential_12.12ubuntu1_ppc64el.deb ... 175s Unpacking build-essential (12.12ubuntu1) ... 175s Selecting previously unselected package libllvm20:ppc64el. 175s Preparing to unpack .../39-libllvm20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 175s Unpacking libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 176s Selecting previously unselected package libclang-cpp20. 176s Preparing to unpack .../40-libclang-cpp20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 176s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 176s Selecting previously unselected package libgc1:ppc64el. 176s Preparing to unpack .../41-libgc1_1%3a8.2.8-1_ppc64el.deb ... 176s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 176s Selecting previously unselected package libobjc4:ppc64el. 176s Preparing to unpack .../42-libobjc4_15-20250404-0ubuntu1_ppc64el.deb ... 176s Unpacking libobjc4:ppc64el (15-20250404-0ubuntu1) ... 176s Selecting previously unselected package libobjc-14-dev:ppc64el. 176s Preparing to unpack .../43-libobjc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 176s Unpacking libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 176s Selecting previously unselected package libclang-common-20-dev:ppc64el. 176s Preparing to unpack .../44-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 176s Unpacking libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 176s Selecting previously unselected package llvm-20-linker-tools. 176s Preparing to unpack .../45-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 176s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 177s Selecting previously unselected package libclang1-20. 177s Preparing to unpack .../46-libclang1-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 177s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 177s Selecting previously unselected package clang-20. 177s Preparing to unpack .../47-clang-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 177s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 177s Selecting previously unselected package libdebhelper-perl. 177s Preparing to unpack .../48-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 177s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 177s Selecting previously unselected package libtool. 177s Preparing to unpack .../49-libtool_2.5.4-4_all.deb ... 177s Unpacking libtool (2.5.4-4) ... 177s Selecting previously unselected package dh-autoreconf. 177s Preparing to unpack .../50-dh-autoreconf_20_all.deb ... 177s Unpacking dh-autoreconf (20) ... 177s Selecting previously unselected package libarchive-zip-perl. 177s Preparing to unpack .../51-libarchive-zip-perl_1.68-1_all.deb ... 177s Unpacking libarchive-zip-perl (1.68-1) ... 177s Selecting previously unselected package libfile-stripnondeterminism-perl. 177s Preparing to unpack .../52-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 177s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 177s Selecting previously unselected package dh-strip-nondeterminism. 177s Preparing to unpack .../53-dh-strip-nondeterminism_1.14.1-2_all.deb ... 177s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 177s Selecting previously unselected package debugedit. 177s Preparing to unpack .../54-debugedit_1%3a5.1-2_ppc64el.deb ... 177s Unpacking debugedit (1:5.1-2) ... 177s Selecting previously unselected package dwz. 177s Preparing to unpack .../55-dwz_0.15-1build6_ppc64el.deb ... 177s Unpacking dwz (0.15-1build6) ... 177s Selecting previously unselected package gettext. 177s Preparing to unpack .../56-gettext_0.23.1-1_ppc64el.deb ... 177s Unpacking gettext (0.23.1-1) ... 177s Selecting previously unselected package intltool-debian. 177s Preparing to unpack .../57-intltool-debian_0.35.0+20060710.6_all.deb ... 177s Unpacking intltool-debian (0.35.0+20060710.6) ... 177s Selecting previously unselected package po-debconf. 177s Preparing to unpack .../58-po-debconf_1.0.21+nmu1_all.deb ... 177s Unpacking po-debconf (1.0.21+nmu1) ... 177s Selecting previously unselected package debhelper. 177s Preparing to unpack .../59-debhelper_13.24.1ubuntu2_all.deb ... 177s Unpacking debhelper (13.24.1ubuntu2) ... 177s Selecting previously unselected package emacsen-common. 177s Preparing to unpack .../60-emacsen-common_3.0.7_all.deb ... 177s Unpacking emacsen-common (3.0.7) ... 177s Selecting previously unselected package dictionaries-common. 177s Preparing to unpack .../61-dictionaries-common_1.30.10_all.deb ... 177s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 177s Unpacking dictionaries-common (1.30.10) ... 177s Selecting previously unselected package libfakeroot:ppc64el. 177s Preparing to unpack .../62-libfakeroot_1.37.1-1_ppc64el.deb ... 177s Unpacking libfakeroot:ppc64el (1.37.1-1) ... 177s Selecting previously unselected package fakeroot. 177s Preparing to unpack .../63-fakeroot_1.37.1-1_ppc64el.deb ... 177s Unpacking fakeroot (1.37.1-1) ... 177s Selecting previously unselected package hunspell-en-us. 177s Preparing to unpack .../64-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 177s Unpacking hunspell-en-us (1:2020.12.07-4) ... 177s Selecting previously unselected package libpgtypes3:ppc64el. 177s Preparing to unpack .../65-libpgtypes3_17.4-1_ppc64el.deb ... 177s Unpacking libpgtypes3:ppc64el (17.4-1) ... 177s Selecting previously unselected package libpq5:ppc64el. 177s Preparing to unpack .../66-libpq5_17.4-1_ppc64el.deb ... 177s Unpacking libpq5:ppc64el (17.4-1) ... 178s Selecting previously unselected package libecpg6:ppc64el. 178s Preparing to unpack .../67-libecpg6_17.4-1_ppc64el.deb ... 178s Unpacking libecpg6:ppc64el (17.4-1) ... 178s Selecting previously unselected package libecpg-compat3:ppc64el. 178s Preparing to unpack .../68-libecpg-compat3_17.4-1_ppc64el.deb ... 178s Unpacking libecpg-compat3:ppc64el (17.4-1) ... 178s Selecting previously unselected package libssl-dev:ppc64el. 178s Preparing to unpack .../69-libssl-dev_3.4.1-1ubuntu3_ppc64el.deb ... 178s Unpacking libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 178s Selecting previously unselected package libpq-dev. 178s Preparing to unpack .../70-libpq-dev_17.4-1_ppc64el.deb ... 178s Unpacking libpq-dev (17.4-1) ... 178s Selecting previously unselected package libecpg-dev. 178s Preparing to unpack .../71-libecpg-dev_17.4-1_ppc64el.deb ... 178s Unpacking libecpg-dev (17.4-1) ... 178s Selecting previously unselected package libncurses-dev:ppc64el. 178s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2_ppc64el.deb ... 178s Unpacking libncurses-dev:ppc64el (6.5+20250216-2) ... 178s Selecting previously unselected package libtcl8.6:ppc64el. 178s Preparing to unpack .../73-libtcl8.6_8.6.16+dfsg-1_ppc64el.deb ... 178s Unpacking libtcl8.6:ppc64el (8.6.16+dfsg-1) ... 178s Selecting previously unselected package libxml2-dev:ppc64el. 178s Preparing to unpack .../74-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4_ppc64el.deb ... 178s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4) ... 178s Selecting previously unselected package libxslt1.1:ppc64el. 178s Preparing to unpack .../75-libxslt1.1_1.1.39-0exp1ubuntu4_ppc64el.deb ... 178s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 178s Selecting previously unselected package llvm-20-runtime. 178s Preparing to unpack .../76-llvm-20-runtime_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 178s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 178s Selecting previously unselected package libpfm4:ppc64el. 178s Preparing to unpack .../77-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 178s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 178s Selecting previously unselected package llvm-20. 178s Preparing to unpack .../78-llvm-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 178s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 179s Selecting previously unselected package libffi-dev:ppc64el. 179s Preparing to unpack .../79-libffi-dev_3.4.7-1_ppc64el.deb ... 179s Unpacking libffi-dev:ppc64el (3.4.7-1) ... 179s Selecting previously unselected package llvm-20-tools. 179s Preparing to unpack .../80-llvm-20-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 179s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 179s Selecting previously unselected package llvm-20-dev. 179s Preparing to unpack .../81-llvm-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 179s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 181s Selecting previously unselected package locales-all. 181s Preparing to unpack .../82-locales-all_2.41-6ubuntu1_ppc64el.deb ... 181s Unpacking locales-all (2.41-6ubuntu1) ... 183s Selecting previously unselected package postgresql-client-17. 183s Preparing to unpack .../83-postgresql-client-17_17.4-1_ppc64el.deb ... 183s Unpacking postgresql-client-17 (17.4-1) ... 183s Selecting previously unselected package postgresql-17. 183s Preparing to unpack .../84-postgresql-17_17.4-1_ppc64el.deb ... 183s Unpacking postgresql-17 (17.4-1) ... 184s Selecting previously unselected package postgresql-doc-17. 184s Preparing to unpack .../85-postgresql-doc-17_17.4-1_all.deb ... 184s Unpacking postgresql-doc-17 (17.4-1) ... 184s Selecting previously unselected package postgresql-plperl-17. 184s Preparing to unpack .../86-postgresql-plperl-17_17.4-1_ppc64el.deb ... 184s Unpacking postgresql-plperl-17 (17.4-1) ... 184s Selecting previously unselected package postgresql-plpython3-17. 184s Preparing to unpack .../87-postgresql-plpython3-17_17.4-1_ppc64el.deb ... 184s Unpacking postgresql-plpython3-17 (17.4-1) ... 184s Selecting previously unselected package postgresql-pltcl-17. 184s Preparing to unpack .../88-postgresql-pltcl-17_17.4-1_ppc64el.deb ... 184s Unpacking postgresql-pltcl-17 (17.4-1) ... 184s Selecting previously unselected package postgresql-server-dev-17. 184s Preparing to unpack .../89-postgresql-server-dev-17_17.4-1_ppc64el.deb ... 184s Unpacking postgresql-server-dev-17 (17.4-1) ... 184s Setting up postgresql-client-common (274) ... 184s Setting up libpgtypes3:ppc64el (17.4-1) ... 184s Setting up libncurses-dev:ppc64el (6.5+20250216-2) ... 184s Setting up libio-pty-perl (1:1.20-1build3) ... 184s Setting up libarchive-zip-perl (1.68-1) ... 184s Setting up libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 184s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 184s Setting up postgresql-doc-17 (17.4-1) ... 185s 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 185s Setting up libpq5:ppc64el (17.4-1) ... 185s Setting up m4 (1.4.19-7) ... 185s Setting up libgomp1:ppc64el (15-20250404-0ubuntu1) ... 185s Setting up libffi-dev:ppc64el (3.4.7-1) ... 185s Setting up locales-all (2.41-6ubuntu1) ... 185s Setting up libfakeroot:ppc64el (1.37.1-1) ... 185s Setting up fakeroot (1.37.1-1) ... 185s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 185s Setting up binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 185s Setting up autotools-dev (20220109.1) ... 185s Setting up libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4) ... 185s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 185s Setting up emacsen-common (3.0.7) ... 185s Setting up ssl-cert (1.1.3ubuntu1) ... 186s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 186s Setting up libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 186s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 186s Setting up libtcl8.6:ppc64el (8.6.16+dfsg-1) ... 186s Setting up autopoint (0.23.1-1) ... 186s Setting up libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 186s Setting up libipc-run-perl (20231003.0-2) ... 186s Setting up libgc1:ppc64el (1:8.2.8-1) ... 186s Setting up autoconf (2.72-3ubuntu1) ... 186s Setting up libubsan1:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up dwz (0.15-1build6) ... 186s Setting up libasan8:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up libjson-perl (4.10000-1) ... 186s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 186s Setting up debugedit (1:5.1-2) ... 186s Setting up libecpg6:ppc64el (17.4-1) ... 186s Setting up libtsan2:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up libisl23:ppc64el (0.27-1) ... 186s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 186s Setting up libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up liblsan0:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up libitm1:ppc64el (15-20250404-0ubuntu1) ... 186s Setting up postgresql-common-dev (274) ... 186s Setting up automake (1:1.17-3ubuntu1) ... 186s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 186s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 186s Setting up gettext (0.23.1-1) ... 186s Setting up libecpg-compat3:ppc64el (17.4-1) ... 186s Setting up dictionaries-common (1.30.10) ... 187s Setting up postgresql-client-17 (17.4-1) ... 187s 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 187s Setting up binutils-gold (2.44-2) ... 187s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 187s Setting up libpq-dev (17.4-1) ... 187s Setting up libobjc4:ppc64el (15-20250404-0ubuntu1) ... 187s Setting up libecpg-dev (17.4-1) ... 187s Setting up intltool-debian (0.35.0+20060710.6) ... 187s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 187s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 187s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 187s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 187s Setting up postgresql-common (274) ... 188s Creating config file /etc/postgresql-common/createcluster.conf with new version 188s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 188s en_us 188s Removing obsolete dictionary files: 189s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 190s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 190s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 190s Setting up cpp-14 (14.2.0-19ubuntu2) ... 190s Setting up dh-strip-nondeterminism (1.14.1-2) ... 190s Setting up hunspell-en-us (1:2020.12.07-4) ... 190s Setting up libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 190s Setting up libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 190s Setting up cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 190s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 190s Setting up postgresql-17 (17.4-1) ... 191s Creating new PostgreSQL cluster 17/main ... 191s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 191s The files belonging to this database system will be owned by user "postgres". 191s This user must also own the server process. 191s 191s The database cluster will be initialized with locale "C.UTF-8". 191s The default database encoding has accordingly been set to "UTF8". 191s The default text search configuration will be set to "english". 191s 191s Data page checksums are disabled. 191s 191s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 191s creating subdirectories ... ok 191s selecting dynamic shared memory implementation ... posix 191s selecting default "max_connections" ... 100 191s selecting default "shared_buffers" ... 128MB 191s selecting default time zone ... Etc/UTC 191s creating configuration files ... ok 191s running bootstrap script ... ok 192s performing post-bootstrap initialization ... ok 192s syncing data to disk ... ok 195s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 195s Setting up po-debconf (1.0.21+nmu1) ... 195s Setting up libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 195s Setting up gcc-14 (14.2.0-19ubuntu2) ... 195s Setting up gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 195s Setting up postgresql-plpython3-17 (17.4-1) ... 195s Setting up postgresql-plperl-17 (17.4-1) ... 195s Setting up cpp (4:14.2.0-1ubuntu1) ... 195s Setting up g++-14 (14.2.0-19ubuntu2) ... 195s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 195s Setting up g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 195s Setting up postgresql-pltcl-17 (17.4-1) ... 195s Setting up libtool (2.5.4-4) ... 195s Setting up gcc (4:14.2.0-1ubuntu1) ... 195s Setting up dh-autoreconf (20) ... 195s Setting up postgresql-server-dev-17 (17.4-1) ... 195s Setting up g++ (4:14.2.0-1ubuntu1) ... 195s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 195s Setting up build-essential (12.12ubuntu1) ... 195s Setting up debhelper (13.24.1ubuntu2) ... 195s Processing triggers for man-db (2.13.0-1) ... 197s Processing triggers for install-info (7.1.1-1) ... 197s Processing triggers for libc-bin (2.41-6ubuntu1) ... 197s Processing triggers for systemd (257.4-1ubuntu3) ... 197s Processing triggers for dictionaries-common (1.30.10) ... 200s autopkgtest [11:23:23]: test run-testsuite: [----------------------- 201s ====== Running all tests with umask 077 ======= 201s ### PostgreSQL test 001_packages.t ### 202s 1..22 202s ok 1 - /etc/os-release exists 202s ok 2 - OS is ubuntu 202s ok 3 - OS version is 25.10 202s # PostgreSQL versions installed: 17 202s ok 4 - postgresql-17 installed 202s ok 5 - postgresql-plpython3-17 installed 202s ok 6 - postgresql-plperl-17 installed 202s ok 7 - postgresql-pltcl-17 installed 202s ok 8 - postgresql-server-dev-17 installed 202s ok 9 # skip No postgresql-contrib-17 package for version 17 202s # postgresql-doc-17 installed 202s ok 10 - At least one doc package installed 202s ok 11 - libecpg-dev installed 202s ok 12 - postgresql-common-dev installed 202s ok 13 - procps installed 202s ok 14 - netcat-openbsd installed 202s ok 15 - hunspell-en-us installed 202s ok 16 - system has a default UTF-8 locale 202s ok 17 - locale ru_RU exists 202s ok 18 - locale ru_RU.UTF-8 exists 202s ok 19 - user postgres in the UNIX group ssl-cert 202s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 202s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 202s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 202s ### End test 001_packages.t ### 202s 202s ### PostgreSQL test 002_existing_clusters.t ### 202s 1..8 202s # Cleanup 202s ok 1 - Cleanup: No clusters left behind 202s ok 2 - No postgres processes left behind 202s ok 3 - No files in /etc/postgresql left behind 202s ok 4 - No files in /var/lib/postgresql left behind 202s ok 5 - No files in /var/run/postgresql left behind 202s ok 6 - No files in /var/log/postgresql left behind 202s ok 7 - PostgreSQL TCP ports are closed 202s ok 8 - Next free port is 5432 202s ### End test 002_existing_clusters.t ### 202s 202s ### PostgreSQL test 003_alternatives.t ### 202s 1..9 202s # Newest PG version installed is 17 202s ok 1 - psql.1.gz link group 202s ok 2 - postmaster.1.gz link group does not exist 202s ok 3 - psql.1.gz alternative 202s ok 4 - pg_dump.1.gz alternative 202s ok 5 - postgres.1.gz alternative 202s ok 6 - pg_ctl.1.gz alternative 202s # Newest PG doc version installed is 17 202s ok 7 - SPI_connect.3.gz link group 202s ok 8 - SPI_connect.3.gz alternative 202s ok 9 - SPI_exec.3.gz alternative 202s ### End test 003_alternatives.t ### 202s 202s ### PostgreSQL test 005_PgCommon.t ### 202s 1..24 202s ok 1 - correctly parsed line 'local all postgres ident sameuser' 202s ok 2 - correctly parsed line 'local foo nobody trust' 202s ok 3 - correctly parsed line 'local foo nobody crypt' 202s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 202s ok 5 - correctly parsed line 'local foo,bar nobody ident' 202s ok 6 - correctly parsed line 'local all +foogrp password' 202s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 202s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 202s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 202s ok 10 - @expected_records has correct number of entries 202s ok 11 - returned read_pg_hba array has correct number of records 202s ok 12 - line 'foo all all md5' parsed as invalid 202s ok 13 - line 'local all all foo' parsed as invalid 202s ok 14 - line 'host all all foo' parsed as invalid 202s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 202s ok 16 - line 'host all all md5' parsed as invalid 202s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 202s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 202s ok 19 - read_conf_file returns empty dict for nonexisting file 202s ok 20 - read_conf_file() parsing 202s ok 21 - read_conf_file() parsing with include directives 202s ok 22 - set_conf_value 202s ok 23 - disable_conf_value 202s ok 24 - replace_conf_value 202s ### End test 005_PgCommon.t ### 202s 202s ### PostgreSQL test 006_next_free_port.t ### 202s 1..5 202s ok 1 - next_free_port is 5432 203s ok 2 - next_free_port detects localhost ipv4 socket 204s ok 3 - next_free_port detects wildcard ipv4 socket 205s ok 4 - next_free_port detects localhost ipv6 socket 206s ok 5 - next_free_port detects wildcard ipv6 socket 206s ### End test 006_next_free_port.t ### 206s 206s ### PostgreSQL test 007_pg_conftool.t ### 206s 1..41 206s # test without cluster 207s ok 1 - pg_conftool show all 207s ok 2 - correct output of pg_conftool show all 207s ok 3 - pg_conftool foo.conf show all 207s ok 4 - correct output of pg_conftool foo.conf show all 207s ok 5 - pg_conftool /tmp/NNgRRqseQO/different.conf show all 207s ok 6 - correct output of pg_conftool /tmp/NNgRRqseQO/different.conf show all 207s ok 7 - pg_conftool 9.7 main show all 207s ok 8 - correct output of pg_conftool 9.7 main show all 207s # test show 207s ok 9 - pg_conftool show all 207s ok 10 - correct output of pg_conftool show all 207s ok 11 - pg_conftool other.conf show all 207s ok 12 - correct output of pg_conftool other.conf show all 207s ok 13 - pg_conftool /tmp/NNgRRqseQO/different.conf show all 207s ok 14 - correct output of pg_conftool /tmp/NNgRRqseQO/different.conf show all 207s ok 15 - pg_conftool 17 main show all 207s ok 16 - correct output of pg_conftool 17 main show all 207s ok 17 - pg_conftool 17 main other.conf show all 207s ok 18 - correct output of pg_conftool 17 main other.conf show all 207s ok 19 - pg_conftool show a 207s ok 20 - correct output of pg_conftool show a 207s ok 21 - pg_conftool -s show a 207s ok 22 - correct output of pg_conftool -s show a 207s # test set 207s ok 23 - pg_conftool set c 7 207s ok 24 - correct output of pg_conftool set c 7 207s ok 25 - file contains new setting 207s ok 26 - pg_conftool set a 8 207s ok 27 - correct output of pg_conftool set a 8 207s ok 28 - file contains updated setting 207s ok 29 - pg_conftool /tmp/NNgRRqseQO/different.conf set a 9 207s ok 30 - correct output of pg_conftool /tmp/NNgRRqseQO/different.conf set a 9 207s ok 31 - file with path contains updated setting 207s # test remove 207s ok 32 - pg_conftool remove a 207s ok 33 - correct output of pg_conftool remove a 207s ok 34 - setting removed from file 207s ok 35 - pg_conftool /tmp/NNgRRqseQO/different.conf remove a 207s ok 36 - correct output of pg_conftool /tmp/NNgRRqseQO/different.conf remove a 207s ok 37 - setting removed from file with path 207s # test edit 207s ok 38 - pg_conftool edit 207s ok 39 - correct output of pg_conftool edit 207s ok 40 - pg_conftool /tmp/NNgRRqseQO/different.conf edit 207s ok 41 - correct output of pg_conftool /tmp/NNgRRqseQO/different.conf edit 207s ### End test 007_pg_conftool.t ### 207s 207s ### PostgreSQL test 010_defaultport_cluster.t ### 208s 1..14 208s ok 1 - psql --version 208s ok 2 - pg_wrapper selects highest available version number 208s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 208s ok 4 - connecting to localhost fails with no clusters 208s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 208s ok 6 - pg_wrapper uses host and port from PGCLUSTER 208s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 208s ok 8 - pg_wrapper uses --cluster from the command line 208s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 208s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 208s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 208s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 208s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 208s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 208s ### End test 010_defaultport_cluster.t ### 208s 208s ### PostgreSQL test 015_start_stop.t ### 208s 1..71 208s # We are running systemd 208s # Running tests for 17 208s # Cluster does not exist yet 208s ok 1 - cluster 17 main does not exist 208s ok 2 - service postgresql@17-main does not exist 208s ok 3 - systemctl start postgresql 208s ok 4 - cluster 17 main does not exist 208s ok 5 - service postgresql@17-main does not exist 208s ok 6 - systemctl start postgresql@17-main 208s ok 7 - cluster 17 main does not exist 208s ok 8 - service postgresql@17-main does not exist 208s # Start/stop postgresql using system tools 210s ok 9 - pg_createcluster 17 main 210s ok 10 - cluster 17 main is stopped 210s ok 11 - service postgresql@17-main is stopped 212s ok 12 - systemctl start postgresql 212s ok 13 - cluster 17 main is running 212s ok 14 - service postgresql@17-main is running 212s ok 15 - systemctl start postgresql 212s ok 16 - cluster 17 main is already running 212s ok 17 - service postgresql@17-main is already running 212s ok 18 - systemctl stop postgresql 218s ok 19 - cluster 17 main is stopped 218s ok 20 - service postgresql@17-main is stopped 218s ok 21 - systemctl stop postgresql 218s ok 22 - cluster 17 main is already stopped 218s ok 23 - service postgresql@17-main is already stopped 218s # Start/stop specific cluster using system tools 221s ok 24 - systemctl start postgresql@17-main 221s ok 25 - cluster 17 main is running 221s ok 26 - service postgresql@17-main is running 221s ok 27 - systemctl start postgresql@17-main 221s ok 28 - cluster 17 main is running 221s ok 29 - service postgresql@17-main is running 223s ok 30 - systemctl restart postgresql@17-main 223s ok 31 - cluster 17 main is running 223s ok 32 - service postgresql@17-main is running 224s ok 33 - systemctl stop postgresql@17-main 224s ok 34 - cluster 17 main is stopped 224s ok 35 - service postgresql@17-main is stopped 224s ok 36 - systemctl stop postgresql@17-main 224s ok 37 - cluster 17 main is already stopped 224s ok 38 - service postgresql@17-main is already stopped 226s ok 39 - pg_dropcluster 17 main 226s ok 40 - cluster 17 main does not exist 226s ok 41 - service postgresql@17-main does not exist 226s # Start/stop specific cluster using pg_*cluster 226s ok 42 - pg_ctlcluster start 17 main 226s ok 43 - cluster 17 main does not exist 226s ok 44 - service postgresql@17-main does not exist 230s ok 45 - pg_createcluster 17 main --start 230s ok 46 - cluster 17 main is running 230s ok 47 - service postgresql@17-main is running 230s ok 48 - pg_ctlcluster 17 main start 230s ok 49 - cluster 17 main is already running 230s ok 50 - service postgresql@17-main is already running 233s ok 51 - pg_ctlcluster 17-main restart 233s ok 52 - cluster 17 main is running 233s ok 53 - service postgresql@17-main is running 233s ok 54 - pg_ctlcluster 17 main stop 233s ok 55 - cluster 17 main is stopped 233s ok 56 - service postgresql@17-main is stopped 233s ok 57 - pg_ctlcluster 17 main stop 233s ok 58 - cluster 17 main is already stopped 233s ok 59 - service postgresql@17-main is already stopped 236s ok 60 - pg_ctlcluster start 17-main 236s ok 61 - cluster 17 main is running 236s ok 62 - service postgresql@17-main is running 238s ok 63 - pg_dropcluster 17 main --stop 238s # Cleanup 238s ok 64 - Cleanup: No clusters left behind 238s ok 65 - No postgres processes left behind 238s ok 66 - No files in /etc/postgresql left behind 238s ok 67 - No files in /var/lib/postgresql left behind 238s ok 68 - No files in /var/run/postgresql left behind 238s ok 69 - No files in /var/log/postgresql left behind 238s ok 70 - PostgreSQL TCP ports are closed 238s ok 71 - Next free port is 5432 238s ### End test 015_start_stop.t ### 238s 238s ### PostgreSQL test 020_create_sql_remove.t ### 238s 1..141 238s # Running tests for 17 242s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.NyMKBV 242s ok 2 - pg_createcluster 17 main 242s ok 3 - Socket and pid file are in /var/run/postgresql/ 242s ok 4 - xlog/wal directory /tmp/17.xlog.NyMKBV was created 242s ok 5 - local method in pg_hba.conf is peer 242s ok 6 - host method in pg_hba.conf is scram-sha-256 242s ok 7 - Exactly one postgres master process running 244s ok 8 - pg_ctlcluster 17 main restart 244s ok 9 - cluster restarts with new environment file 244s ok 10 - Exactly one postgres master process running 244s ok 11 - correct value of PGEXTRAVAR1 in environment 244s ok 12 - correct value of PGEXTRAVAR2 in environment 244s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 244s ok 14 - createdb --version 244s ok 15 - pg_wrapper+createdb selects version number of cluster 244s ok 16 - psql --version 244s ok 17 - pg_wrapper+psql selects version 17 244s ok 18 - pg_lscluster reports online cluster on port 5432 244s ok 19 - log file is actually used 244s ok 20 - /etc/postgresql is owned by user "postgres" 244s ok 21 - version configuration directory file is owned by user "postgres" 244s ok 22 - configuration directory file is owned by user "postgres" 244s ok 23 - version data directory file is owned by user "postgres" 244s ok 24 - data directory file is owned by user "postgres" 244s ok 25 - log file has 0640 permissions 244s ok 26 - log file is owned by user "postgres" 244s ok 27 - log file is owned by group "adm" 244s ok 28 - no log symlink by default 244s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 244s ok 30 - pg_lsclusters -h 244s ok 31 - correct output of pg_lsclusters -h 245s ok 32 - stopping cluster 247s ok 33 - restarting cluster with nondefault log symlink 247s ok 34 - log target is used as log file 247s ok 35 - default log is not used 247s ok 36 - pg_lsclusters -h 247s ok 37 - correct output of pg_lsclusters -h 248s ok 38 - stopping cluster 250s ok 39 - restarting cluster with explicitly configured log file 250s ok 40 - default log is not used 250s ok 41 - log symlink target is used for startup message 250s ok 42 - exactly one log file 250s ok 43 - custom log is actually used 251s ok 44 - pg_lsclusters -h 251s ok 45 - correct output of pg_lsclusters -h 251s ok 46 - stopping cluster 251s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 251s ok 48 - /etc/postgres-hack was not created 253s ok 49 - restarting cluster 253s ok 50 - ps -o tty -U postgres h 253s ok 51 - postgres processes do not have an associated terminal 253s ok 52 - Server is linked with SSL support 253s ok 53 - SSL is enabled in postgresql.conf 254s ok 54 - psql -l fails for nobody 254s ok 55 - createuser nobody 254s ok 56 - createdb nobodydb 254s ok 57 - psql -ltA succeeds for nobody 254s ok 58 - psql -ltA output 254s ok 59 - SQL command: create table 254s ok 60 - SQL command: insert into table values 254s ok 61 - SQL command: insert into table values 254s ok 62 - primary key violation 254s ok 63 - psql -tAc "select * from phone order by name" nobodydb 254s ok 64 - SQL command output: select -tA 254s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 254s ok 66 - SQL command output: select -tx 254s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 254s ok 68 - SQL command output: select -tAx 254s ok 69 - CREATE EXTENSION plperlu fails for user nobody 254s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 254s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 254s ok 72 - creating PL/PerlU function as user nobody fails 254s ok 73 - creating unsafe PL/Perl function as user postgres fails 255s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 255s ok 75 - creating PL/PerlU function as user postgres succeeds 255s ok 76 - psql nobodydb -Atc "select read_file()" 255s ok 77 - calling PL/PerlU function 255s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 255s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 255s ok 80 - creating unsafe PL/Perl function as user nobody fails 255s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 255s ok 82 - creating PL/Perl function as user nobody succeeds 255s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 255s ok 84 - calling PL/Perl function 255s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 255s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 255s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 255s ok 88 - creating PL/Python3 function as user postgres succeeds 255s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 255s ok 90 - calling PL/Python function 255s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 255s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 256s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 256s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 256s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 256s ok 96 - creating PL/Tcl function as user nobody succeeds 256s 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;" 256s ok 98 - creating PL/TclU function as user postgres succeeds 256s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 256s ok 100 - calling PL/Tcl function 256s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 256s ok 102 - calling PL/TclU function 256s ok 103 - stopping cluster 256s ok 104 - pg_ctlcluster 17 main start 256s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 258s ok 106 - pg_ctlcluster 17 main start 258s ok 107 - cluster restarts with pgdata symlink 259s ok 108 - postgres master has OOM killer protection 259s ok 109 - postgres client backend has no OOM adjustment 259s ok 110 - ps h 7162 259s ok 111 - process title is idle 259s ok 112 - ps h 7162 259s ok 113 - process title is idle in transaction 260s ok 114 - stopping cluster 262s ok 115 - starting cluster as postgres works without a log file 262s ok 116 - log file got recreated and used 262s ok 117 - creating a directory in spc2 262s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.ITv4FX'" 262s ok 119 - creating tablespace spc1 262s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 262s ok 121 - creating a table in spc1 262s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.Dd8qF7'" 262s ok 123 - creating tablespace spc2 262s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 262s ok 125 - creating a table in spc2 262s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 262s ok 127 - Correct apt NeverAutoRemove config 265s ok 128 - pg_dropcluster removes cluster 265s ok 129 - xlog/wal directory /tmp/17.xlog.NyMKBV was deleted 265s ok 130 - tablespace spc1 was emptied 265s ok 131 - tablespace spc2 was emptied 265s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 265s ok 133 - Correct apt NeverAutoRemove config 265s # Cleanup 265s ok 134 - Cleanup: No clusters left behind 265s ok 135 - No postgres processes left behind 265s ok 136 - No files in /etc/postgresql left behind 265s ok 137 - No files in /var/lib/postgresql left behind 265s ok 138 - No files in /var/run/postgresql left behind 265s ok 139 - No files in /var/log/postgresql left behind 265s ok 140 - PostgreSQL TCP ports are closed 265s ok 141 - Next free port is 5432 265s ### End test 020_create_sql_remove.t ### 265s 265s ### PostgreSQL test 021_pg_renamecluster.t ### 265s 1..20 269s ok 1 - pg_createcluster 17 main 272s ok 2 - pg_renamecluster 17 main donau 272s ok 3 - psql -tAc "show data_directory" 272s ok 4 - cluster is running and data_directory was moved 272s ok 5 - pg_hba.conf location updated 272s ok 6 - pg_ident.conf location updated 272s ok 7 - external_pid_file location updated 272s ok 8 - external_pid_file exists 272s ok 9 # skip no stats_temp_directory in 17 272s ok 10 # skip no stats_temp_directory in 17 272s ok 11 - cluster_name is updated 274s ok 12 - pg_dropcluster removes cluster 274s # Cleanup 274s ok 13 - Cleanup: No clusters left behind 274s ok 14 - No postgres processes left behind 274s ok 15 - No files in /etc/postgresql left behind 274s ok 16 - No files in /var/lib/postgresql left behind 274s ok 17 - No files in /var/run/postgresql left behind 274s ok 18 - No files in /var/log/postgresql left behind 274s ok 19 - PostgreSQL TCP ports are closed 274s ok 20 - Next free port is 5432 274s ### End test 021_pg_renamecluster.t ### 274s 274s ### PostgreSQL test 022_recovery.t ### 274s 1..17 274s # Running tests for 17 278s ok 1 - pg_createcluster 17 main --start >/dev/null 278s ok 2 - pg_ctlcluster 17 main stop -m i 281s ok 3 - pg_ctlcluster 17 main start 281s ok 4 - psql -c '' 281s ok 5 - pg_ctlcluster 17 main stop -m i 281s ok 6 - create write-protected file in data directory 284s ok 7 - pg_ctlcluster 17 main start 284s ok 8 - psql -c '' 286s ok 9 - pg_dropcluster removes cluster 286s # Cleanup 286s ok 10 - Cleanup: No clusters left behind 286s ok 11 - No postgres processes left behind 286s ok 12 - No files in /etc/postgresql left behind 286s ok 13 - No files in /var/lib/postgresql left behind 286s ok 14 - No files in /var/run/postgresql left behind 286s ok 15 - No files in /var/log/postgresql left behind 286s ok 16 - PostgreSQL TCP ports are closed 286s ok 17 - Next free port is 5432 286s ### End test 022_recovery.t ### 286s 286s ### PostgreSQL test 025_logging.t ### 286s 1..55 287s # Logging to /var/log/syslog works 287s # Running tests for 17 291s ok 1 - pg_createcluster 17 main 291s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 291s ok 3 - psql -qc "'foobar_17_8389'" 291s ok 4 - log an error 292s ok 5 - grep --binary-files=text foobar_17_8389 /var/log/postgresql/postgresql-17-main.log 292s ok 6 - error appears in logfile 292s ok 7 - pg_conftool 17 main set log_destination syslog 292s ok 8 - set log_destination syslog 292s ok 9 - pg_ctlcluster 17 main reload 292s ok 10 - 17 main reload 292s ok 11 - psql -Atc "show log_destination" 292s ok 12 - log_destination is syslog 292s ok 13 - pg_lscluster reports syslog 293s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 293s ok 15 - error appears in /var/log/syslog 293s ok 16 - pg_conftool 17 main set logging_collector on 293s ok 17 - set logging_collector on 293s ok 18 - pg_conftool 17 main set log_destination csvlog 293s ok 19 - set log_destination csvlog 295s ok 20 - pg_ctlcluster 17 main restart 295s ok 21 - 17 main restart 295s ok 22 - psql -Atc "show logging_collector" 295s ok 23 - logging_collector is on 296s ok 24 - psql -Atc "show log_destination" 296s ok 25 - log_destination is csvlog 296s ok 26 - pg_lscluster reports csvlog 296s ok 27 - psql -qc "'barbaz_17_8389'" 296s ok 28 - log an error 296s ok 29 - grep --binary-files=text barbaz_17_8389 /var/lib/postgresql/17/main/log/*.csv 296s ok 30 - error appears in log/*.csv 296s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 296s ok 32 - set log_destination stderr,syslog,csvlog 296s ok 33 - pg_ctlcluster 17 main reload 296s ok 34 - 17 main reload 296s ok 35 - psql -Atc "show log_destination" 296s ok 36 - log_destination is stderr,syslog,csvlog 297s ok 37 - pg_lscluster reports stderr,syslog,csvlog 297s ok 38 - psql -qc "'moo_17_8389'" 297s ok 39 - log an error 297s ok 40 - grep --binary-files=text moo_17_8389 /var/lib/postgresql/17/main/log/*.log 297s ok 41 - error appears in log/*.log 298s ok 42 - grep --binary-files=text 'postgres.*moo_17_8389' /var/log/syslog 298s ok 43 - error appears in /var/log/syslog 298s ok 44 - grep --binary-files=text moo_17_8389 /var/lib/postgresql/17/main/log/*.csv 298s ok 45 - error appears in log/*.csv 300s ok 46 - pg_dropcluster 17 main --stop 300s ok 47 - pg_dropcluster removes cluster 300s # Cleanup 300s ok 48 - Cleanup: No clusters left behind 300s ok 49 - No postgres processes left behind 300s ok 50 - No files in /etc/postgresql left behind 300s ok 51 - No files in /var/lib/postgresql left behind 300s ok 52 - No files in /var/run/postgresql left behind 300s ok 53 - No files in /var/log/postgresql left behind 300s ok 54 - PostgreSQL TCP ports are closed 300s ok 55 - Next free port is 5432 300s ### End test 025_logging.t ### 300s 300s ### PostgreSQL test 027_jit.t ### 300s # 17 304s ok 1 - pg_createcluster 17 main --start 304s ok 2 - psql -Xatc 'show jit' 304s ok 3 - JIT is on by default 304s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 304s ok 5 - No JIT on cheap query 304s ok 6 - pg_conftool 17 main set seq_page_cost 100000 304s ok 7 - pg_conftool 17 main set random_page_cost 100000 304s ok 8 - pg_ctlcluster 17 main reload 304s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 304s ok 10 - Expensive query is JITed 306s ok 11 - pg_dropcluster --stop 17 main 306s # Cleanup 306s ok 12 - Cleanup: No clusters left behind 306s ok 13 - No postgres processes left behind 306s ok 14 - No files in /etc/postgresql left behind 306s ok 15 - No files in /var/lib/postgresql left behind 306s ok 16 - No files in /var/run/postgresql left behind 306s ok 17 - No files in /var/log/postgresql left behind 306s ok 18 - PostgreSQL TCP ports are closed 306s ok 19 - Next free port is 5432 306s 1..19 306s ### End test 027_jit.t ### 306s 306s ### PostgreSQL test 030_errors.t ### 306s 1..156 306s ok 1 - pg_lscluster reports cluster without binaries 308s ok 2 - pg_dropcluster 6.3 main 309s ok 3 - pg_createcluster --socketdir 309s ok 4 - pg_lsclusters -h 309s ok 5 - cluster was created 309s ok 6 - Port of created cluster is 5432 309s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 309s ok 8 - pg_createcluster on existing cluster 309s ok 9 - pg_lsclusters -h 309s ok 10 - original cluster still exists 309s ok 11 - pg_createcluster 17 test -p foo 309s ok 12 - pg_createcluster -p checks that port option is numeric 309s ok 13 - pg_createcluster 17 test -p 42 309s ok 14 - pg_createcluster -p checks valid port range 309s ok 15 - pg_ctlcluster 17 main start 309s ok 16 - pg_ctlcluster refuses to start root-owned cluster 309s ok 17 - pg_ctlcluster 17 main start 309s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 310s ok 19 - pg_ctlcluster 17 main start 310s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 310s ok 21 - pg_ctlcluster 17 main start 310s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 312s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 312s ok 24 - No sockets in /var/run/postgresql 312s ok 25 - Socket is in /tmp/postgresql-testsuite/ 312s ok 26 - cluster stops with custom unix_socket_dir 312s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 315s ok 28 - cluster starts after removing unix_socket_dir 315s ok 29 - Socket is in default dir /var/run/postgresql 315s ok 30 - No sockets in /tmp/postgresql-testsuite/ 315s ok 31 - pg_ctlcluster 17 main stop 315s ok 32 - pg_ctlcluster fails with corrupted PID file 315s ok 33 - pg_lsclusters -h 315s ok 34 - cluster is still online 315s ok 35 - pg_ctlcluster succeeds with restored PID file 315s ok 36 - pg_lsclusters -h 315s ok 37 - cluster is down 315s ok 38 - pg_ctlcluster 17 main stop 315s ok 39 - pg_ctlcluster stop fails on stopped cluster 318s ok 40 - pg_ctlcluster 17 main start 318s ok 41 - pg_ctlcluster succeeds with already existing PID file 318s ok 42 - pg_lsclusters -h 318s ok 43 - cluster is online 318s ok 44 - pg_ctlcluster stop succeeds 318s ok 45 - pg_lsclusters -h 318s ok 46 - cluster is down 318s ok 47 - no pid file left 318s ok 48 - pg_ctlcluster 17 main stop 318s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 318s ok 50 - pid file was cleaned up 318s ok 51 - pg_ctlcluster --force 17 main stop 318s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 318s ok 53 - pid file was cleaned up 318s ok 54 - pg_ctlcluster 17 main stop 318s ok 55 - pg_ctlcluster stop succeeds with stale PID file 318s ok 56 - pid file was cleaned up 318s ok 57 - pg_ctlcluster --force 17 main stop 318s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 318s ok 59 - pid file was cleaned up 318s ok 60 - pg_ctlcluster --force 17 main stop 318s ok 61 - pg_ctlcluster stop succeeds with empty PID file 318s ok 62 - pid file was cleaned up 321s ok 63 - pg_ctlcluster 17 main start 321s ok 64 - pg_ctlcluster succeeds with corrupted PID file 321s ok 65 - pg_lsclusters -h 321s ok 66 - cluster is online 321s ok 67 - pg_ctlcluster 17 main start 321s ok 68 - pg_ctlcluster start fails on running cluster 321s ok 69 - pg_ctlcluster stop 321s ok 70 - pg_ctlcluster 17 main start 321s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 321s ok 72 - pg_ctlcluster 17 main stop 321s ok 73 - stopping cluster 328s ok 74 - pg_ctlcluster 17 main start 328s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 328s ok 76 - pg_ctlcluster 17 main stop 328s ok 77 - stopping cluster 328s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 328s ok 79 - pg_dropcluster 17 main 328s ok 80 - pg_dropcluster works as user postgres 329s ok 81 - pg_createcluster succeeds 329s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 329s ok 83 - proper error message for nonexisting /var/lib/postgresql 332s ok 84 - pg_ctlcluster 17 main start 332s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 332s ok 86 - pg_ctlcluster 17 main stop 332s ok 87 - stopping cluster 333s ok 88 - pg_createcluster other 335s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 337s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 338s ok 91 338s ok 92 - pg_ctlcluster 17 other start 338s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 338s ok 94 - pg_ctlcluster 17 main stop 338s ok 95 - stopping main cluster 340s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 342s ok 97 - pg_dropcluster other 344s ok 98 - pg_dropcluster 344s ok 99 - No sockets any more 344s ok 100 - 'pg_lsclusters 4.5 foo' fails 344s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 344s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 103 - 'psql --cluster 4.5/foo' fails 344s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 344s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 344s ok 106 - 'psql --cluster 17/foo' fails 344s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 344s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 344s ok 109 - 'pg_dropcluster 4.5 foo' fails 344s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 344s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 112 - 'pg_dropcluster 17 foo' fails 344s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 344s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 344s ok 115 - 'pg_upgradecluster 4.5 foo' fails 344s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 344s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 344s ok 118 - 'pg_upgradecluster 17 foo' fails 344s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 344s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 344s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 344s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 344s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 344s ok 124 - 'pg_ctlcluster 17 foo stop' fails 344s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 344s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 344s # Cleanup 344s ok 127 - Cleanup: No clusters left behind 344s ok 128 - No postgres processes left behind 344s ok 129 - No files in /etc/postgresql left behind 344s ok 130 - No files in /var/lib/postgresql left behind 344s ok 131 - No files in /var/run/postgresql left behind 344s ok 132 - No files in /var/log/postgresql left behind 344s ok 133 - PostgreSQL TCP ports are closed 344s ok 134 - Next free port is 5432 346s ok 135 - pg_dropcluster 17 broken 346s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 346s # Cleanup 346s ok 137 - Cleanup: No clusters left behind 346s ok 138 - No postgres processes left behind 346s ok 139 - No files in /etc/postgresql left behind 346s ok 140 - No files in /var/lib/postgresql left behind 346s ok 141 - No files in /var/run/postgresql left behind 346s ok 142 - No files in /var/log/postgresql left behind 346s ok 143 - PostgreSQL TCP ports are closed 346s ok 144 - Next free port is 5432 348s ok 145 - pg_dropcluster 17 broken 348s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 348s ok 147 - /etc/postgresql/17 was removed 348s ok 148 - /var/lib/postgresql/17 was removed 348s # Cleanup 348s ok 149 - Cleanup: No clusters left behind 348s ok 150 - No postgres processes left behind 348s ok 151 - No files in /etc/postgresql left behind 348s ok 152 - No files in /var/lib/postgresql left behind 348s ok 153 - No files in /var/run/postgresql left behind 348s ok 154 - No files in /var/log/postgresql left behind 348s ok 155 - PostgreSQL TCP ports are closed 348s ok 156 - Next free port is 5432 348s ### End test 030_errors.t ### 348s 348s ### PostgreSQL test 031_errors_disk_full.t ### 348s 1..22 348s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 349s ok 1 - script failed 349s ok 2 - pg_createcluster fails due to insufficient disk space 349s ok 3 - does not leave files behind 349s # Cleanup 349s ok 4 - Cleanup: No clusters left behind 350s ok 5 - No postgres processes left behind 350s ok 6 - No files in /etc/postgresql left behind 350s ok 7 - No files in /var/lib/postgresql left behind 350s ok 8 - No files in /var/run/postgresql left behind 350s ok 9 - No files in /var/log/postgresql left behind 350s ok 10 - PostgreSQL TCP ports are closed 350s ok 11 - Next free port is 5432 350s # check disk full conditions on startup 353s ok 12 - script failed 353s ok 13 - pg_ctlcluster prints error message 353s ok 14 - log file has error message 353s # Cleanup 353s ok 15 - Cleanup: No clusters left behind 353s ok 16 - No postgres processes left behind 353s ok 17 - No files in /etc/postgresql left behind 353s ok 18 - No files in /var/lib/postgresql left behind 353s ok 19 - No files in /var/run/postgresql left behind 353s ok 20 - No files in /var/log/postgresql left behind 353s ok 21 - PostgreSQL TCP ports are closed 353s ok 22 - Next free port is 5432 353s ### End test 031_errors_disk_full.t ### 353s 353s ### PostgreSQL test 032_ssl_key_permissions.t ### 353s 1..22 353s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 353s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 353s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 354s ok 4 - pg_createcluster 17 main 354s ok 5 - pg_ctlcluster 17 main start 354s ok 6 - ssl key owned by nobody refused 354s ok 7 - pg_ctlcluster 17 main start 354s ok 8 - ssl key with permissions root:root 0644 refused 354s ok 9 - pg_ctlcluster 17 main start 354s ok 10 - ssl key with permissions postgres:postgres 0640 refused 356s ok 11 - pg_dropcluster 17 main --stop 356s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 356s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 356s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 356s # Cleanup 356s ok 15 - Cleanup: No clusters left behind 356s ok 16 - No postgres processes left behind 356s ok 17 - No files in /etc/postgresql left behind 356s ok 18 - No files in /var/lib/postgresql left behind 356s ok 19 - No files in /var/run/postgresql left behind 356s ok 20 - No files in /var/log/postgresql left behind 356s ok 21 - PostgreSQL TCP ports are closed 356s ok 22 - Next free port is 5432 356s ### End test 032_ssl_key_permissions.t ### 356s 356s ### PostgreSQL test 040_upgrade.t ### 356s 1..1 356s ok 1 - only one major version installed, skipping upgrade tests 356s ### End test 040_upgrade.t ### 356s 356s ### PostgreSQL test 041_upgrade_custompaths.t ### 356s 1..1 356s ok 1 - only one major version installed, skipping upgrade tests 356s ### End test 041_upgrade_custompaths.t ### 356s 356s ### PostgreSQL test 042_upgrade_rename.t ### 356s 1..15 356s # PostgreSQL 17 360s ok 1 - pg_createcluster 17 main --start 367s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 367s ok 3 - pg_lsclusters -h 367s ok 4 - correct output of pg_lsclusters -h 368s ok 5 - pg_dropcluster 17 main --stop 370s ok 6 - pg_dropcluster 17 upgr --stop 370s ok 7 - Cleaning pg_upgrade log files 370s # Cleanup 370s ok 8 - Cleanup: No clusters left behind 370s ok 9 - No postgres processes left behind 370s ok 10 - No files in /etc/postgresql left behind 370s ok 11 - No files in /var/lib/postgresql left behind 370s ok 12 - No files in /var/run/postgresql left behind 370s ok 13 - No files in /var/log/postgresql left behind 370s ok 14 - PostgreSQL TCP ports are closed 370s ok 15 - Next free port is 5432 370s ### End test 042_upgrade_rename.t ### 370s 370s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 370s 1..1 370s ok 1 - only one major version installed, skipping upgrade tests 370s ### End test 043_upgrade_ssl_cert.t ### 370s 370s ### PostgreSQL test 045_backup.t ### 371s # We are running systemd 371s # PostgreSQL 17 371s # create cluster 374s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 374s ok 2 - pg_lsclusters -h 374s ok 3 - correct output of pg_lsclusters -h 374s ok 4 - pg_conftool 17 main set work_mem 11MB 374s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 374s ok 6 - psql -c 'alter database mydb set search_path=public' 374s ok 7 - psql -c 'create table foo (t text)' mydb 374s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 375s ok 9 - psql -c 'CREATE USER myuser' 375s ok 10 - psql -c 'grant create on database mydb to myuser' 375s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 375s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 375s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 375s # create directory 375s ok 14 - pg_backupcluster 17 main createdirectory 375s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 375s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 375s # dump 376s ok 17 - systemctl start pg_dump@17-main 376s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-03T112618Z.dump 376s ok 19 - /var/backups/postgresql/17-main/2025-05-03T112618Z.dump owned by uid postgres 376s ok 20 - /var/backups/postgresql/17-main/2025-05-03T112618Z.dump owned by gid postgres 376s # basebackup 376s ok 21 - systemctl start pg_receivewal@17-main 376s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 376s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 376s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 376s ok 25 - psql -c 'select pg_reload_conf()' 405s ok 26 - systemctl start pg_basebackup@17-main 405s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-03T112620Z.backup 405s ok 28 - /var/backups/postgresql/17-main/2025-05-03T112620Z.backup owned by uid postgres 405s ok 29 - /var/backups/postgresql/17-main/2025-05-03T112620Z.backup owned by gid postgres 405s # list 405s ok 30 - pg_backupcluster 17 main list 405s ok 31 - correct output of pg_backupcluster 17 main list 405s # more database changes 405s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 405s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 405s ok 34 - retrieve recovery timestamp 405s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 406s ok 36 - systemctl stop pg_receivewal@17-main 406s # restore /var/backups/postgresql/17-main/2025-05-03T112618Z.dump 408s ok 37 - pg_dropcluster 17 main --stop 414s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T112618Z.dump --start --datadir /var/lib/postgresql/17/snowflake 414s ok 39 - pg_lsclusters -h 414s ok 40 - correct output of pg_lsclusters -h 414s ok 41 - psql -XAtl 414s ok 42 - mydb locales 414s ok 43 - mydb grants 414s ok 44 - myicudb locales 414s ok 45 - psql -XAtc 'show work_mem' 414s ok 46 - correct output of psql -XAtc 'show work_mem' 414s ok 47 - psql -XAtc 'select * from foo' mydb 414s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 414s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 414s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 414s ok 51 - psql -XAtc '\drds' 414s ok 52 - correct output of psql -XAtc '\drds' 414s # restore /var/backups/postgresql/17-main/2025-05-03T112620Z.backup 416s ok 53 - pg_dropcluster 17 main --stop 420s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T112620Z.backup --start --datadir /var/lib/postgresql/17/snowflake 420s ok 55 - pg_lsclusters -h 420s ok 56 - correct output of pg_lsclusters -h 420s ok 57 - psql -XAtl 420s ok 58 - mydb locales 420s ok 59 - mydb grants 420s ok 60 - myicudb locales 420s ok 61 - psql -XAtc 'show work_mem' 420s ok 62 - correct output of psql -XAtc 'show work_mem' 420s ok 63 - psql -XAtc 'select * from foo' mydb 420s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 420s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 420s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 421s ok 67 - psql -XAtc '\drds' 421s ok 68 - correct output of psql -XAtc '\drds' 421s # restore /var/backups/postgresql/17-main/2025-05-03T112620Z.backup with WAL archive 423s ok 69 - pg_dropcluster 17 main --stop 427s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T112620Z.backup --start --archive --port 5430 427s ok 71 - pg_lsclusters -h 427s ok 72 - correct output of pg_lsclusters -h 428s ok 73 - psql -XAtc 'select * from foo order by t' mydb 428s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 428s # restore /var/backups/postgresql/17-main/2025-05-03T112620Z.backup with PITR 430s ok 75 - pg_dropcluster 17 main --stop 435s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-03T112620Z.backup --start --pitr '2025-05-03 11:26:48.625741+00 435s # ' 435s ok 77 - pg_lsclusters -h 435s ok 78 - correct output of pg_lsclusters -h 435s ok 79 - psql -XAtc 'select * from foo order by t' mydb 435s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 437s ok 81 - pg_dropcluster 17 main --stop 437s # Cleanup 437s ok 82 - Cleanup: No clusters left behind 437s ok 83 - No postgres processes left behind 437s ok 84 - No files in /etc/postgresql left behind 437s ok 85 - No files in /var/lib/postgresql left behind 437s ok 86 - No files in /var/run/postgresql left behind 437s ok 87 - No files in /var/log/postgresql left behind 437s ok 88 - PostgreSQL TCP ports are closed 437s ok 89 - Next free port is 5432 437s 1..89 437s ### End test 045_backup.t ### 437s 437s ### PostgreSQL test 050_encodings.t ### 437s 1..60 437s # Checking 17 ru_RU 440s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 441s ok 2 - psql -l succeeds 441s ok 3 - template1 is not UTF-8 encoded 442s ok 4 - creating test database 442s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 442s # create table t (x varchar); copy t from stdin" test 442s ok 6 - creating table with ISO-8859-5 characters 442s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 442s ok 8 - correct string in UTF-8 442s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 442s ok 10 - correct string in ISO-8859-5 442s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 442s # delete from t; copy t from stdin" test 442s ok 12 - creating table with UTF-8 characters 442s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 442s ok 14 - correct string in UTF-8 442s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 442s ok 16 - correct string in ISO-8859-1 442s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 442s ok 18 - Server error message has correct language and encoding 444s ok 19 - pg_ctlcluster 17 ru_RU restart 444s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 447s ok 21 - Dropping cluster 447s # Checking 17 ru_RU.UTF-8 451s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 452s ok 23 - psql -l succeeds 452s ok 24 - template1 is UTF-8 encoded 452s ok 25 - creating test database 452s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 452s # create table t (x varchar); copy t from stdin" test 452s ok 27 - creating table with ISO-8859-5 characters 452s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 452s ok 29 - correct string in UTF-8 452s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 452s ok 31 - correct string in ISO-8859-5 452s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 452s # delete from t; copy t from stdin" test 452s ok 33 - creating table with UTF-8 characters 452s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 452s ok 35 - correct string in UTF-8 452s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 452s ok 37 - correct string in ISO-8859-1 452s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 452s ok 39 - Server error message has correct language and encoding 455s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 455s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 455s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 455s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 455s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 455s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 455s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 455s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 457s ok 48 - Dropping cluster 457s # Check 17 locale environment variables 460s ok 49 - pg_createcluster: LC_ALL dominates LANG 461s ok 50 - psql -Atl --cluster 17/main 461s ok 51 - template1 is ASCII encoded 462s ok 52 - Dropping cluster 462s # Cleanup 463s ok 53 - Cleanup: No clusters left behind 463s ok 54 - No postgres processes left behind 463s ok 55 - No files in /etc/postgresql left behind 463s ok 56 - No files in /var/lib/postgresql left behind 463s ok 57 - No files in /var/run/postgresql left behind 463s ok 58 - No files in /var/log/postgresql left behind 463s ok 59 - PostgreSQL TCP ports are closed 463s ok 60 - Next free port is 5432 463s ### End test 050_encodings.t ### 463s 463s ### PostgreSQL test 052_upgrade_encodings.t ### 463s 1..1 463s ok 1 - only one major version installed, skipping upgrade tests 463s ### End test 052_upgrade_encodings.t ### 463s 463s ### PostgreSQL test 060_obsolete_confparams.t ### 463s ok 1 - only one major version installed, skipping upgrade tests 463s 1..1 463s ### End test 060_obsolete_confparams.t ### 463s 463s ### PostgreSQL test 070_non_postgres_clusters.t ### 463s 1..40 464s ok 1 - pg_createcluster 17 main for owner nobody 464s ok 2 - pg_ctlcluster 17 main start 464s ok 3 - start refused when config and data owners mismatch 466s ok 4 - pg_ctlcluster succeeds with owner nobody 466s ok 5 - pg_lsclusters -h 466s ok 6 - pg_lsclusters shows running cluster 466s ok 7 - postgres is running as user nobody 466s ok 8 - ls /tmp/.s.PGSQL.* 466s ok 9 - socket is in /tmp 466s ok 10 - /var/run/postgresql is empty 466s ok 11 - conf dir is owned by user 466s ok 12 - conf dir is owned by user's primary group 466s ok 13 - files are owned by user 466s ok 14 - files are owned by user's primary group 467s ok 15 - log file has 0640 permissions 467s ok 16 - log file is owned by user 467s ok 17 - log file is owned by user's primary group 467s ok 18 - only one major version installed, skipping upgrade test 467s ok 19 - ... 467s ok 20 - ... 467s ok 21 - ... 467s ok 22 - ... 467s ok 23 - ... 467s ok 24 - ... 467s ok 25 - ... 467s ok 26 - ... 467s ok 27 - ... 467s ok 28 - ... 469s ok 29 - pg_dropcluster 469s ok 30 - pg_lsclusters -h 469s ok 31 - No clusters left 469s ok 32 - No postgres processes left 469s # Cleanup 469s ok 33 - Cleanup: No clusters left behind 469s ok 34 - No postgres processes left behind 469s ok 35 - No files in /etc/postgresql left behind 469s ok 36 - No files in /var/lib/postgresql left behind 469s ok 37 - No files in /var/run/postgresql left behind 469s ok 38 - No files in /var/log/postgresql left behind 469s ok 39 - PostgreSQL TCP ports are closed 469s ok 40 - Next free port is 5432 469s ### End test 070_non_postgres_clusters.t ### 469s 469s ### PostgreSQL test 080_start.conf.t ### 469s 1..73 471s ok 1 - pg_createcluster 17 main 471s # start.conf auto 471s ok 2 - get_cluster_start_conf returns auto 471s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 471s ok 4 - start.conf contains auto 471s ok 5 - systemd generator links cluster 471s ok 6 - systemd generator links correct service file 474s ok 7 - /etc/init.d/postgresql start 17 474s ok 8 - correct output of /etc/init.d/postgresql start 17 474s ok 9 - pg_lsclusters -h 474s ok 10 - cluster is online 474s ok 11 - /etc/init.d/postgresql stop 17 474s ok 12 - correct output of /etc/init.d/postgresql stop 17 477s ok 13 - pg_lsclusters -h 477s ok 14 - cluster is down 477s # start.conf manual 477s ok 15 - get_cluster_start_conf returns manual 477s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 477s ok 17 - start.conf contains manual 477s ok 18 - systemd generator doesn't link cluster 477s ok 19 - /etc/init.d/postgresql start 17 477s ok 20 - correct output of /etc/init.d/postgresql start 17 477s ok 21 - pg_lsclusters -h 477s ok 22 - cluster is down 480s ok 23 - pg_ctlcluster 17 main start 480s ok 24 - correct output of pg_ctlcluster 17 main start 480s ok 25 - pg_lsclusters -h 480s ok 26 - cluster is online 480s ok 27 - pg_ctlcluster 17 main stop 480s ok 28 - correct output of pg_ctlcluster 17 main stop 480s ok 29 - pg_lsclusters -h 480s ok 30 - cluster is down 480s # start.conf disabled 480s ok 31 - get_cluster_start_conf returns disabled 480s ok 32 - systemd generator doesn't link cluster 480s ok 33 - /etc/init.d/postgresql start 17 480s ok 34 - correct output of /etc/init.d/postgresql start 17 481s ok 35 - pg_lsclusters -h 481s ok 36 - cluster is down 481s ok 37 - pg_ctlcluster 17 main start 481s ok 38 - correct output of pg_ctlcluster 17 main start 481s ok 39 - pg_lsclusters -h 481s ok 40 - cluster is down 483s ok 41 - pg_ctlcluster 17 main start 483s ok 42 - correct output of pg_ctlcluster 17 main start 483s ok 43 - pg_lsclusters -h 483s ok 44 - cluster is online 483s ok 45 - pg_ctlcluster 17 main stop 483s ok 46 - correct output of pg_ctlcluster 17 main stop 483s ok 47 - pg_lsclusters -h 483s ok 48 - cluster is down 486s ok 49 - pg_ctlcluster 17 main start 486s ok 50 - correct output of pg_ctlcluster 17 main start 486s ok 51 - pg_lsclusters -h 486s ok 52 - cluster is online 486s # test upgrade 486s ok 53 - only one major version installed, skipping upgrade test 486s ok 54 - ... 486s ok 55 - get_cluster_start_conf for old cluster returns manual 486s ok 56 - get_cluster_start_conf for new cluster returns manual 486s ok 57 - ... 488s ok 58 - dropping upgraded cluster 488s ok 59 - pg_lsclusters -h 488s ok 60 - no clusters any more 488s ok 61 - pg_createcluster 17 main --start-conf foo 488s ok 62 - pg_createcluster checks --start-conf validity 489s ok 63 - pg_createcluster checks --start-conf manual 489s ok 64 - get_cluster_start_conf returns manual 491s ok 65 - dropping cluster 491s # Cleanup 491s ok 66 - Cleanup: No clusters left behind 491s ok 67 - No postgres processes left behind 491s ok 68 - No files in /etc/postgresql left behind 491s ok 69 - No files in /var/lib/postgresql left behind 491s ok 70 - No files in /var/run/postgresql left behind 491s ok 71 - No files in /var/log/postgresql left behind 491s ok 72 - PostgreSQL TCP ports are closed 491s ok 73 - Next free port is 5432 491s ### End test 080_start.conf.t ### 491s 491s ### PostgreSQL test 085_pg_ctl.conf.t ### 491s 1..33 491s ok 1 - prlimit --core=0:unlimited --pid=17317 491s ok 2 - set core file size to unlimited 491s ok 3 - sh -c 'ulimit -Hc' 491s ok 4 - core file size is unlimited 492s ok 5 - pg_createcluster 17 main 492s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 495s ok 7 - pg_ctlcluster 17 main start 495s ok 8 - starting cluster as root 495s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 495s ok 10 - soft core size is 0 495s # hard core file size limit of root-started postgres process is unlimited 495s ok 11 - set pg_ctl default option to -c 497s ok 12 - pg_ctlcluster 17 main restart 497s ok 13 - restarting cluster as root 497s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 497s ok 15 - soft core size is unlimited 498s ok 16 - pg_ctlcluster 17 main stop 498s ok 17 - stopping cluster 498s ok 18 - restored pg_ctl default option 500s ok 19 - pg_ctlcluster 17 main start -- -c 500s ok 20 - starting cluster with -c on the command line as postgres 500s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 500s ok 22 - soft core size is unlimited 500s ok 23 - pg_ctlcluster 17 main stop 500s ok 24 - stopping cluster 502s ok 25 - dropping cluster 502s # Cleanup 502s ok 26 - Cleanup: No clusters left behind 502s ok 27 - No postgres processes left behind 502s ok 28 - No files in /etc/postgresql left behind 502s ok 29 - No files in /var/lib/postgresql left behind 502s ok 30 - No files in /var/run/postgresql left behind 502s ok 31 - No files in /var/log/postgresql left behind 502s ok 32 - PostgreSQL TCP ports are closed 502s ok 33 - Next free port is 5432 502s ### End test 085_pg_ctl.conf.t ### 502s 502s ### PostgreSQL test 090_multicluster.t ### 502s 1..125 504s ok 1 - pg_createcluster 17 old 505s ok 2 - pg_createcluster 17 new1 506s ok 3 - pg_createcluster 17 new2 508s ok 4 - starting cluster 17/old 511s ok 5 - starting cluster 17/new1 513s ok 6 - starting cluster 17/new2 513s ok 7 - pg_lsclusters -h | sort -k3 513s ok 8 - clusters have the correct ports, skipping used 5433 513s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 513s ok 10 - createdb --version 513s ok 11 - pg_wrapper selects port 5432 as default cluster 513s ok 12 - createdb --cluster 17/new1 --version 513s ok 13 - pg_wrapper --cluster works 513s ok 14 - createdb --cluster 17/foo --version 513s ok 15 - pg_wrapper --cluster errors out for invalid cluster 513s ok 16 - createdb --cluster 17/new1 test 513s ok 17 - correct output of createdb --cluster 17/new1 test 513s ok 18 - psql -Atl --cluster 17/new1 513s ok 19 - test db appears in cluster new1 514s ok 20 - psql -Atl --cluster 17/new2 514s ok 21 - test db does not appear in cluster new2 514s ok 22 - psql -Atl 514s ok 23 - test db does not appear in default cluster 514s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 514s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 514s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 514s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 514s ok 28 - psql -Atl --cluster 17/localhost:5434 514s ok 29 - test db appears in cluster 17/localhost:5434 514s ok 30 - psql -Atl --cluster 17/localhost:5440 514s ok 31 - test db does not appear in cluster 17/localhost:5440 514s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 514s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 514s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 514s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 514s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 514s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 514s ok 38 - psql -Atl --cluster 6.4/localhost: 514s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 514s ok 40 - psql -Atl 514s ok 41 - PGCLUSTER selection (1) 514s ok 42 - psql -Atl 514s ok 43 - PGCLUSTER selection (2) 514s ok 44 - psql -l 514s ok 45 - invalid PGCLUSTER value 514s ok 46 - createdb --version 514s ok 47 - PGCLUSTER network cluster selection (1) 514s ok 48 - psql -Atl 514s ok 49 - PGCLUSTER network cluster selection (2) 514s ok 50 - psql -Atl 514s ok 51 - PGCLUSTER network cluster selection (3) 514s ok 52 - LC_MESSAGES=C psql -Atl 514s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 515s ok 54 - psql -Atc "show port" template1 515s ok 55 - PGPORT selection (1) 515s ok 56 - psql -Atc "show port" template1 515s ok 57 - PGPORT selection (2) 515s ok 58 - createdb --version 515s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 515s ok 60 - psql -Atc "show port" template1 515s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 515s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 515s ok 63 - PGDATABASE environment variable works 515s ok 64 - createdb --version 515s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 515s ok 66 - createdb --cluster 17/new1 --version 515s ok 67 - pg_wrapper --cluster works with empty user_clusters 515s ok 68 - createdb --version 515s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 515s ok 70 - psql -Atc "select current_database()" 515s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 515s ok 72 - psql -Atc 'select current_database()' 515s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 515s ok 74 - createdb --version 515s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 515s ok 76 - createdb --version 515s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 515s ok 78 - createdb --version 515s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 515s ok 80 - createdb --version 515s ok 81 - pg_wrapper selects correct version with per-user user_clusters 515s ok 82 - createdb --version 515s ok 83 - pg_wrapper selects correct version with per-user user_clusters 515s ok 84 - createdb --version 515s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 515s ok 86 - psql -Atl 515s ok 87 - $PGHOST overrides user_clusters 515s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 515s ok 89 - --cluster overrides $PGHOST 515s ok 90 - createdb --version 515s ok 91 - pg_wrapper ignores invalid lines in user_clusters 516s ok 92 - psql -Atc 'select current_database()' 516s ok 93 - pg_service conf selection 1 516s ok 94 - psql -Atc 'select current_database()' 516s ok 95 - pg_service conf selection 2 516s ok 96 - psql -Atc 'select current_database()' 516s ok 97 - pg_service conf selection 3 516s ok 98 - stopping cluster 17/old 518s ok 99 - restarting cluster 17/old 518s ok 100 - pg_lsclusters -h | sort -k3 518s ok 101 - port of first cluster was successfully changed 518s ok 102 - psql -l 518s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 518s ok 104 - psql -Atl --cluster 17/new1 518s ok 105 - --cluster selects appropriate cluster 519s ok 106 - psql -Atl -p 5434 519s ok 107 - -p selects appropriate cluster 519s ok 108 - psql -Atlp 5434 519s ok 109 - -Atlp selects appropriate cluster 519s ok 110 - psql -Atl --port 5434 519s ok 111 - --port selects appropriate cluster 519s ok 112 - env PGPORT=5434 psql -Atl 519s ok 113 - $PGPORT selects appropriate cluster 519s ok 114 - Restoring original /etc/postgresql-common/user_clusters 521s ok 115 - dropping 17/new1 523s ok 116 - dropping 17/new2 525s ok 117 - dropping 17/old 525s # Cleanup 525s ok 118 - Cleanup: No clusters left behind 525s ok 119 - No postgres processes left behind 525s ok 120 - No files in /etc/postgresql left behind 525s ok 121 - No files in /var/lib/postgresql left behind 525s ok 122 - No files in /var/run/postgresql left behind 525s ok 123 - No files in /var/log/postgresql left behind 525s ok 124 - PostgreSQL TCP ports are closed 525s ok 125 - Next free port is 5432 525s ### End test 090_multicluster.t ### 525s 525s ### PostgreSQL test 110_integrate_cluster.t ### 525s 1..32 526s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/0uCaaOq_08/c/postgres 526s ok 2 - creating raw initdb cluster for user postgres 527s ok 3 - pg_createcluster 17 postgres -d /tmp/0uCaaOq_08/c/postgres 527s ok 4 - integrating postgres cluster 527s ok 5 - pg_lsclusters 527s ok 6 - correct pg_lsclusters output 529s ok 7 - pg_ctlcluster 17 postgres start 529s ok 8 - starting cluster postgres 529s ok 9 - pg_lsclusters 529s ok 10 - correct pg_lsclusters output 532s ok 11 - dropping cluster postgres 532s ok 12 - No files in temporary cluster dir left behind 533s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/0uCaaOq_08/c/nobody 533s ok 14 - creating raw initdb cluster for user nobody 533s ok 15 - pg_createcluster 17 nobody -d /tmp/0uCaaOq_08/c/nobody 533s ok 16 - integrating nobody cluster 533s ok 17 - pg_lsclusters 533s ok 18 - correct pg_lsclusters output 535s ok 19 - pg_ctlcluster 17 nobody start 535s ok 20 - starting cluster nobody 535s ok 21 - pg_lsclusters 535s ok 22 - correct pg_lsclusters output 537s ok 23 - dropping cluster nobody 537s ok 24 - No files in temporary cluster dir left behind 537s # Cleanup 538s ok 25 - Cleanup: No clusters left behind 538s ok 26 - No postgres processes left behind 538s ok 27 - No files in /etc/postgresql left behind 538s ok 28 - No files in /var/lib/postgresql left behind 538s ok 29 - No files in /var/run/postgresql left behind 538s ok 30 - No files in /var/log/postgresql left behind 538s ok 31 - PostgreSQL TCP ports are closed 538s ok 32 - Next free port is 5432 538s ### End test 110_integrate_cluster.t ### 538s 538s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 538s 1..1 538s ok 1 - only one major version installed, skipping upgrade tests 538s ### End test 120_pg_upgradecluster_scripts.t ### 538s 538s ### PostgreSQL test 130_nonroot_admin.t ### 538s 1..22 541s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 541s ok 2 - pg_lsclusters -h 541s ok 3 - correct output of pg_lsclusters -h 541s ok 4 - psql -Atl 541s ok 5 - correct output of psql -Atl 541s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 541s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 541s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 541s # Cleanup 541s ok 15 - Cleanup: No clusters left behind 541s ok 16 - No postgres processes left behind 541s ok 17 - No files in /etc/postgresql left behind 541s ok 18 - No files in /var/lib/postgresql left behind 541s ok 19 - No files in /var/run/postgresql left behind 541s ok 20 - No files in /var/log/postgresql left behind 542s ok 21 - PostgreSQL TCP ports are closed 542s ok 22 - Next free port is 5432 542s ### End test 130_nonroot_admin.t ### 542s 542s ### PostgreSQL test 135_pg_virtualenv.t ### 542s 1..20 548s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 548s ok 2 - running pg_virtualenv as root 551s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 551s ok 4 - running pg_virtualenv as postgres 555s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 555s ok 6 - running pg_virtualenv as nobody 559s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 559s ok 8 - running fakeroot pg_virtualenv as root 563s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 563s ok 10 - running fakeroot pg_virtualenv as postgres 567s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 567s ok 12 - running fakeroot pg_virtualenv as nobody 567s # Cleanup 567s ok 13 - Cleanup: No clusters left behind 567s ok 14 - No postgres processes left behind 567s ok 15 - No files in /etc/postgresql left behind 567s ok 16 - No files in /var/lib/postgresql left behind 567s ok 17 - No files in /var/run/postgresql left behind 567s ok 18 - No files in /var/log/postgresql left behind 567s ok 19 - PostgreSQL TCP ports are closed 567s ok 20 - Next free port is 5432 567s ### End test 135_pg_virtualenv.t ### 567s 567s ### PostgreSQL test 140_pg_config.t ### 568s 1..38 568s # Multiarch is enabled 568s # checking version specific output for 17 568s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 568s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 568s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 568s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 568s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 568s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 568s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 568s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 568s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 568s # checking pg_config output (should behave like version 17) 568s ok 15 - pg_config 568s ok 16 - correct output of pg_config 568s ok 17 - pg_config --help 568s ok 18 - correct output of pg_config --help 568s ok 19 - pg_config --pgxs 568s ok 20 - correct output of pg_config --pgxs 568s ok 21 - pg_config --libdir 568s ok 22 - correct output of pg_config --libdir 568s ok 23 - pg_config --pkglibdir 568s ok 24 - correct output of pg_config --pkglibdir 568s ok 25 - pg_config --bindir 568s ok 26 - correct output of pg_config --bindir 568s # checking pg_config.libpq-dev output (should behave like version 17) 568s ok 27 - pg_config.libpq-dev 568s ok 28 - correct output of pg_config.libpq-dev 568s ok 29 - pg_config.libpq-dev --help 568s ok 30 - correct output of pg_config.libpq-dev --help 568s ok 31 - pg_config.libpq-dev --pgxs 568s ok 32 - correct output of pg_config.libpq-dev --pgxs 568s ok 33 - pg_config.libpq-dev --libdir 568s ok 34 - correct output of pg_config.libpq-dev --libdir 568s ok 35 - pg_config.libpq-dev --pkglibdir 568s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 568s ok 37 - pg_config.libpq-dev --bindir 568s ok 38 - correct output of pg_config.libpq-dev --bindir 568s ### End test 140_pg_config.t ### 568s 568s ### PostgreSQL test 150_tsearch_stemming.t ### 568s 1..37 568s ok 1 - pg_updatedicts succeeded 568s ok 2 - pg_updatedicts created en_us.affix 568s ok 3 - pg_updatedicts created en_us.dict 568s ok 4 - pg_updatedicts created 17 en_us.affix symlink 568s ok 5 - pg_updatedicts created 17 en_us.dict symlink 572s ok 6 - pg_createcluster 17 main 572s ok 7 - createdb fts 572s ok 8 - correct output of createdb fts 572s ok 9 - creating en_US full text search configuration 572s ok 10 - creating data table and search index 572s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 572s ok 12 - stem search of correct word 573s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 573s ok 14 - stem search of correct word 573s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 573s ok 16 - stem search of unknown word 573s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 573s ok 18 - full text search, exact word 573s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 573s ok 20 - full text search for word stem 573s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 573s ok 22 - full text search for word substring fails 573s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 573s ok 24 - full text search, exact unicode word 573s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 573s ok 26 - full text search for unicode word stem 573s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 573s ok 28 - full text search for unicode word substring fails 575s ok 29 575s # Cleanup 575s ok 30 - Cleanup: No clusters left behind 575s ok 31 - No postgres processes left behind 575s ok 32 - No files in /etc/postgresql left behind 575s ok 33 - No files in /var/lib/postgresql left behind 575s ok 34 - No files in /var/run/postgresql left behind 575s ok 35 - No files in /var/log/postgresql left behind 575s ok 36 - PostgreSQL TCP ports are closed 575s ok 37 - Next free port is 5432 575s ### End test 150_tsearch_stemming.t ### 575s 575s ### PostgreSQL test 160_alternate_confroot.t ### 576s 1..28 579s ok 1 579s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 579s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 579s ok 4 - pg_lsclusters -h 579s ok 5 - correct output of pg_lsclusters -h 579s ok 6 - psql -Atl 579s ok 7 - correct output of psql -Atl 579s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 579s ok 9 - ... 579s ok 10 - ... 579s ok 11 - ... 579s ok 12 - ... 579s ok 13 - ... 579s ok 14 - ... 579s ok 15 - pg_dropcluster 17 test --stop 579s ok 16 - correct output of pg_dropcluster 17 test --stop 580s ok 17 - pg_lsclusters -h 580s ok 18 - correct output of pg_lsclusters -h 580s ok 19 - No files in root/data left behind 580s ok 20 - No cruft in root dir left behind 580s # Cleanup 580s ok 21 - Cleanup: No clusters left behind 580s ok 22 - No postgres processes left behind 580s ok 23 - No files in /etc/postgresql left behind 580s ok 24 - No files in /var/lib/postgresql left behind 580s ok 25 - No files in /var/run/postgresql left behind 580s ok 26 - No files in /var/log/postgresql left behind 580s ok 27 - PostgreSQL TCP ports are closed 580s ok 28 - Next free port is 5432 580s ### End test 160_alternate_confroot.t ### 580s 580s ### PostgreSQL test 170_extensions.t ### 580s # Running tests for 17 584s ok 1 - pg_createcluster 17 main 584s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 584s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 584s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 584s ok 5 - extension amcheck installs without error 584s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 584s ok 7 - extension amcheck removes without error 584s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 584s ok 9 - extension autoinc installs without error 584s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 584s ok 11 - extension autoinc removes without error 584s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 584s ok 13 - extension bloom installs without error 584s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 584s ok 15 - extension bloom removes without error 585s ok 16 - psql -qc 'CREATE EXTENSION plperl' 585s ok 17 - bool_plperl dependency plperl installs without error 585s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 585s ok 19 - extension bool_plperl installs without error 585s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 585s ok 21 - extension bool_plperl removes without error 585s ok 22 - psql -qc 'DROP EXTENSION plperl' 585s ok 23 - bool_plperl dependency extension plperl removes without error 585s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 585s ok 25 - bool_plperlu dependency plperlu installs without error 585s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 585s ok 27 - extension bool_plperlu installs without error 585s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 585s ok 29 - extension bool_plperlu removes without error 585s ok 30 - psql -qc 'DROP EXTENSION plperlu' 585s ok 31 - bool_plperlu dependency extension plperlu removes without error 585s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 585s ok 33 - extension btree_gin installs without error 585s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 585s ok 35 - extension btree_gin removes without error 585s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 585s ok 37 - extension btree_gist installs without error 586s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 586s ok 39 - extension btree_gist removes without error 586s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 586s ok 41 - extension citext installs without error 586s ok 42 - psql -qc 'DROP EXTENSION "citext"' 586s ok 43 - extension citext removes without error 586s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 586s ok 45 - extension cube installs without error 586s ok 46 - psql -qc 'DROP EXTENSION "cube"' 586s ok 47 - extension cube removes without error 586s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 586s ok 49 - extension dblink installs without error 586s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 586s ok 51 - extension dblink removes without error 586s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 586s ok 53 - extension dict_int installs without error 586s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 586s ok 55 - extension dict_int removes without error 586s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 586s ok 57 - extension dict_xsyn installs without error 587s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 587s ok 59 - extension dict_xsyn removes without error 587s ok 60 - psql -qc 'CREATE EXTENSION cube' 587s ok 61 - earthdistance dependency cube installs without error 587s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 587s ok 63 - extension earthdistance installs without error 587s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 587s ok 65 - extension earthdistance removes without error 587s ok 66 - psql -qc 'DROP EXTENSION cube' 587s ok 67 - earthdistance dependency extension cube removes without error 587s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 587s ok 69 - extension file_fdw installs without error 587s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 587s ok 71 - extension file_fdw removes without error 587s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 587s ok 73 - extension fuzzystrmatch installs without error 587s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 587s ok 75 - extension fuzzystrmatch removes without error 587s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 587s ok 77 - extension hstore installs without error 587s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 587s ok 79 - extension hstore removes without error 587s ok 80 - psql -qc 'CREATE EXTENSION hstore' 587s ok 81 - hstore_plperl dependency hstore installs without error 587s ok 82 - psql -qc 'CREATE EXTENSION plperl' 587s ok 83 - hstore_plperl dependency plperl installs without error 588s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 588s ok 85 - extension hstore_plperl installs without error 588s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 588s ok 87 - extension hstore_plperl removes without error 588s ok 88 - psql -qc 'DROP EXTENSION hstore' 588s ok 89 - hstore_plperl dependency extension hstore removes without error 588s ok 90 - psql -qc 'DROP EXTENSION plperl' 588s ok 91 - hstore_plperl dependency extension plperl removes without error 588s ok 92 - psql -qc 'CREATE EXTENSION hstore' 588s ok 93 - hstore_plperlu dependency hstore installs without error 588s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 588s ok 95 - hstore_plperlu dependency plperlu installs without error 588s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 588s ok 97 - extension hstore_plperlu installs without error 588s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 588s ok 99 - extension hstore_plperlu removes without error 588s ok 100 - psql -qc 'DROP EXTENSION hstore' 588s ok 101 - hstore_plperlu dependency extension hstore removes without error 588s ok 102 - psql -qc 'DROP EXTENSION plperlu' 588s ok 103 - hstore_plperlu dependency extension plperlu removes without error 588s ok 104 - psql -qc 'CREATE EXTENSION hstore' 588s ok 105 - hstore_plpython3u dependency hstore installs without error 588s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 588s ok 107 - hstore_plpython3u dependency plpython3u installs without error 588s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 588s ok 109 - extension hstore_plpython3u installs without error 588s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 588s ok 111 - extension hstore_plpython3u removes without error 588s ok 112 - psql -qc 'DROP EXTENSION hstore' 588s ok 113 - hstore_plpython3u dependency extension hstore removes without error 589s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 589s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 589s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 589s ok 117 - extension insert_username installs without error 589s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 589s ok 119 - extension insert_username removes without error 589s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 589s ok 121 - extension intagg installs without error 589s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 589s ok 123 - extension intagg removes without error 589s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 589s ok 125 - extension intarray installs without error 589s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 589s ok 127 - extension intarray removes without error 589s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 589s ok 129 - extension isn installs without error 589s ok 130 - psql -qc 'DROP EXTENSION "isn"' 589s ok 131 - extension isn removes without error 589s ok 132 - psql -qc 'CREATE EXTENSION plperl' 589s ok 133 - jsonb_plperl dependency plperl installs without error 589s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 589s ok 135 - extension jsonb_plperl installs without error 589s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 589s ok 137 - extension jsonb_plperl removes without error 589s ok 138 - psql -qc 'DROP EXTENSION plperl' 589s ok 139 - jsonb_plperl dependency extension plperl removes without error 589s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 589s ok 141 - jsonb_plperlu dependency plperlu installs without error 589s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 589s ok 143 - extension jsonb_plperlu installs without error 590s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 590s ok 145 - extension jsonb_plperlu removes without error 590s ok 146 - psql -qc 'DROP EXTENSION plperlu' 590s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 590s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 590s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 590s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 590s ok 151 - extension jsonb_plpython3u installs without error 590s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 590s ok 153 - extension jsonb_plpython3u removes without error 590s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 590s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 590s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 590s ok 157 - extension lo installs without error 590s ok 158 - psql -qc 'DROP EXTENSION "lo"' 590s ok 159 - extension lo removes without error 590s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 590s ok 161 - extension ltree installs without error 590s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 590s ok 163 - extension ltree removes without error 590s ok 164 - psql -qc 'CREATE EXTENSION ltree' 590s ok 165 - ltree_plpython3u dependency ltree installs without error 590s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 590s ok 167 - ltree_plpython3u dependency plpython3u installs without error 590s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 590s ok 169 - extension ltree_plpython3u installs without error 590s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 590s ok 171 - extension ltree_plpython3u removes without error 590s ok 172 - psql -qc 'DROP EXTENSION ltree' 590s ok 173 - ltree_plpython3u dependency extension ltree removes without error 590s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 590s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 590s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 590s ok 177 - extension moddatetime installs without error 591s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 591s ok 179 - extension moddatetime removes without error 591s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 591s ok 181 - extension pageinspect installs without error 591s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 591s ok 183 - extension pageinspect removes without error 591s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 591s ok 185 - extension pg_buffercache installs without error 591s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 591s ok 187 - extension pg_buffercache removes without error 591s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 591s ok 189 - extension pg_freespacemap installs without error 591s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 591s ok 191 - extension pg_freespacemap removes without error 591s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 591s ok 193 - extension pg_prewarm installs without error 591s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 591s ok 195 - extension pg_prewarm removes without error 591s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 591s ok 197 - extension pg_stat_statements installs without error 591s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 591s ok 199 - extension pg_stat_statements removes without error 591s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 591s ok 201 - extension pg_surgery installs without error 591s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 591s ok 203 - extension pg_surgery removes without error 591s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 591s ok 205 - extension pg_trgm installs without error 591s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 591s ok 207 - extension pg_trgm removes without error 591s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 591s ok 209 - extension pg_visibility installs without error 591s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 591s ok 211 - extension pg_visibility removes without error 592s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 592s ok 213 - extension pg_walinspect installs without error 592s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 592s ok 215 - extension pg_walinspect removes without error 592s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 592s ok 217 - extension pgcrypto installs without error 592s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 592s ok 219 - extension pgcrypto removes without error 592s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 592s ok 221 - extension pgrowlocks installs without error 592s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 592s ok 223 - extension pgrowlocks removes without error 592s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 592s ok 225 - extension pgstattuple installs without error 592s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 592s ok 227 - extension pgstattuple removes without error 592s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 592s ok 229 - extension plperl installs without error 592s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 592s ok 231 - extension plperl removes without error 592s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 592s ok 233 - extension plperlu installs without error 592s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 592s ok 235 - extension plperlu removes without error 592s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 592s ok 237 - extension plpython3u installs without error 592s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 592s ok 239 - extension plpython3u removes without error 592s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 592s ok 241 - extension pltcl installs without error 592s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 592s ok 243 - extension pltcl removes without error 592s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 592s ok 245 - extension pltclu installs without error 592s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 592s ok 247 - extension pltclu removes without error 592s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 592s ok 249 - extension postgres_fdw installs without error 593s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 593s ok 251 - extension postgres_fdw removes without error 593s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 593s ok 253 - extension refint installs without error 593s ok 254 - psql -qc 'DROP EXTENSION "refint"' 593s ok 255 - extension refint removes without error 593s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 593s ok 257 - extension seg installs without error 593s ok 258 - psql -qc 'DROP EXTENSION "seg"' 593s ok 259 - extension seg removes without error 593s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 593s ok 261 - extension sslinfo installs without error 593s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 593s ok 263 - extension sslinfo removes without error 593s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 593s ok 265 - extension tablefunc installs without error 593s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 593s ok 267 - extension tablefunc removes without error 593s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 593s ok 269 - extension tcn installs without error 593s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 593s ok 271 - extension tcn removes without error 593s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 593s ok 273 - extension tsm_system_rows installs without error 593s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 593s ok 275 - extension tsm_system_rows removes without error 593s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 593s ok 277 - extension tsm_system_time installs without error 593s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 593s ok 279 - extension tsm_system_time removes without error 593s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 593s ok 281 - extension unaccent installs without error 593s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 593s ok 283 - extension unaccent removes without error 593s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 593s ok 285 - extension uuid-ossp installs without error 594s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 594s ok 287 - extension uuid-ossp removes without error 594s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 594s ok 289 - extension xml2 installs without error 594s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 594s ok 291 - extension xml2 removes without error 596s ok 292 - pg_dropcluster 17 main 596s # Cleanup 596s ok 293 - Cleanup: No clusters left behind 596s ok 294 - No postgres processes left behind 596s ok 295 - No files in /etc/postgresql left behind 596s ok 296 - No files in /var/lib/postgresql left behind 596s ok 297 - No files in /var/run/postgresql left behind 596s ok 298 - No files in /var/log/postgresql left behind 596s ok 299 - PostgreSQL TCP ports are closed 596s ok 300 - Next free port is 5432 596s 1..300 596s ### End test 170_extensions.t ### 596s 596s ### PostgreSQL test 180_ecpg.t ### 596s 1..14 596s ok 1 - ecpg test.pgc 596s ok 2 - ecpg processing 597s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 597s ok 4 - compiling ecpg output 604s ok 5 - pg_virtualenv /tmp/tmp.ArTyLZmOvD/test 604s ok 6 - test program runs and gives correct output 604s # Cleanup 604s ok 7 - Cleanup: No clusters left behind 604s ok 8 - No postgres processes left behind 604s ok 9 - No files in /etc/postgresql left behind 604s ok 10 - No files in /var/lib/postgresql left behind 604s ok 11 - No files in /var/run/postgresql left behind 604s ok 12 - No files in /var/log/postgresql left behind 604s ok 13 - PostgreSQL TCP ports are closed 604s ok 14 - Next free port is 5432 604s ### End test 180_ecpg.t ### 604s 604s ### PostgreSQL test 190_pg_buildext.t ### 605s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 605s 1..1 605s ### End test 190_pg_buildext.t ### 605s 605s ### PostgreSQL test 200_maintscripts.t ### 605s 1..15 605s # We are running systemd 608s ok 1 - pg_createcluster 17 main --start 608s ok 2 - postmaster PID is 22395 610s ok 3 - apt-get update -q 610s # postgresql-common: 610s # Installed: 274 610s # Candidate: 274 610s # Version table: 610s # 277 100 610s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el Packages 610s # *** 274 500 610s # 500 http://ftpmaster.internal/ubuntu questing/main ppc64el Packages 610s # 100 /var/lib/dpkg/status 615s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 615s # postgresql-common: 615s # Installed: 274 615s # Candidate: 274 615s # Version table: 615s # 277 100 615s # 100 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el Packages 615s # *** 274 500 615s # 500 http://ftpmaster.internal/ubuntu questing/main ppc64el Packages 615s # 100 /var/lib/dpkg/status 615s ok 5 - postmaster PID is 22395 615s ok 6 - postmaster was not restarted 618s ok 7 - pg_dropcluster 17 main --stop 618s # Cleanup 618s ok 8 - Cleanup: No clusters left behind 618s ok 9 - No postgres processes left behind 618s ok 10 - No files in /etc/postgresql left behind 618s ok 11 - No files in /var/lib/postgresql left behind 618s ok 12 - No files in /var/run/postgresql left behind 618s ok 13 - No files in /var/log/postgresql left behind 618s ok 14 - PostgreSQL TCP ports are closed 618s ok 15 - Next free port is 5432 618s ### End test 200_maintscripts.t ### 618s 619s autopkgtest [11:30:22]: test run-testsuite: -----------------------] 619s autopkgtest [11:30:22]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 619s run-testsuite PASS 619s autopkgtest [11:30:22]: test installcheck: preparing testbed 735s autopkgtest [11:32:18]: testbed dpkg architecture: ppc64el 735s autopkgtest [11:32:18]: testbed apt version: 3.0.0 735s autopkgtest [11:32:18]: @@@@@@@@@@@@@@@@@@@@ test bed setup 736s autopkgtest [11:32:19]: testbed release detected to be: questing 736s autopkgtest [11:32:19]: updating testbed package index (apt update) 737s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [110 kB] 737s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 737s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 737s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 737s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [44.6 kB] 737s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [1655 kB] 738s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [155 kB] 738s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el Packages [187 kB] 738s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/universe ppc64el Packages [1285 kB] 738s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/multiverse ppc64el Packages [14.1 kB] 738s Fetched 3452 kB in 1s (2406 kB/s) 739s Reading package lists... 740s autopkgtest [11:32:23]: upgrading testbed (apt dist-upgrade and autopurge) 740s Reading package lists... 740s Building dependency tree... 740s Reading state information... 741s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 741s Starting 2 pkgProblemResolver with broken count: 0 741s Done 741s Entering ResolveByKeep 741s 741s Calculating upgrade... 742s The following packages will be upgraded: 742s debianutils libnftnl11 libzstd1 python3-lazr.restfulclient zstd 742s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 742s Need to get 1443 kB of archives. 742s After this operation, 1024 B of additional disk space will be used. 742s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el debianutils ppc64el 5.22 [93.9 kB] 742s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el libzstd1 ppc64el 1.5.7+dfsg-1 [410 kB] 742s Get:3 http://ftpmaster.internal/ubuntu questing/main ppc64el libnftnl11 ppc64el 1.2.9-1 [77.1 kB] 742s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el python3-lazr.restfulclient all 0.14.6-3 [51.0 kB] 742s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/main ppc64el zstd ppc64el 1.5.7+dfsg-1 [811 kB] 743s Fetched 1443 kB in 1s (2617 kB/s) 743s (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 ... 107205 files and directories currently installed.) 743s Preparing to unpack .../debianutils_5.22_ppc64el.deb ... 743s Unpacking debianutils (5.22) over (5.21) ... 743s Setting up debianutils (5.22) ... 743s (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 ... 107205 files and directories currently installed.) 743s Preparing to unpack .../libzstd1_1.5.7+dfsg-1_ppc64el.deb ... 743s Unpacking libzstd1:ppc64el (1.5.7+dfsg-1) over (1.5.6+dfsg-2) ... 743s Setting up libzstd1:ppc64el (1.5.7+dfsg-1) ... 743s (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 ... 107205 files and directories currently installed.) 743s Preparing to unpack .../libnftnl11_1.2.9-1_ppc64el.deb ... 743s Unpacking libnftnl11:ppc64el (1.2.9-1) over (1.2.8-1) ... 743s Preparing to unpack .../python3-lazr.restfulclient_0.14.6-3_all.deb ... 743s Unpacking python3-lazr.restfulclient (0.14.6-3) over (0.14.6-2) ... 743s Preparing to unpack .../zstd_1.5.7+dfsg-1_ppc64el.deb ... 743s Unpacking zstd (1.5.7+dfsg-1) over (1.5.6+dfsg-2) ... 743s Setting up libnftnl11:ppc64el (1.2.9-1) ... 743s Setting up python3-lazr.restfulclient (0.14.6-3) ... 743s Setting up zstd (1.5.7+dfsg-1) ... 743s Processing triggers for man-db (2.13.0-1) ... 745s Processing triggers for libc-bin (2.41-6ubuntu1) ... 745s Reading package lists... 745s Building dependency tree... 745s Reading state information... 746s Starting pkgProblemResolver with broken count: 0 746s Starting 2 pkgProblemResolver with broken count: 0 746s Done 746s Solving dependencies... 746s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 749s Reading package lists... 749s Building dependency tree... 749s Reading state information... 750s Starting pkgProblemResolver with broken count: 0 750s Starting 2 pkgProblemResolver with broken count: 0 750s Done 751s The following NEW packages will be installed: 751s binutils-gold binutils-gold-powerpc64le-linux-gnu build-essential clang-20 751s cpp cpp-14 cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu g++ g++-14 751s g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-14 751s gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu libasan8 libcc1-0 751s libclang-common-20-dev libclang-cpp20 libclang1-20 libffi-dev libgc1 751s libgcc-14-dev libgomp1 libio-pty-perl libipc-run-perl libisl23 libitm1 751s libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev libobjc-14-dev 751s libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev 751s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 751s llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 751s postgresql-client-17 postgresql-client-common postgresql-common 751s postgresql-common-dev postgresql-server-dev-17 ssl-cert tzdata-legacy 751s 0 upgraded, 59 newly installed, 0 to remove and 0 not upgraded. 751s Need to get 217 MB of archives. 751s After this operation, 1120 MB of additional disk space will be used. 751s Get:1 http://ftpmaster.internal/ubuntu questing/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 751s Get:2 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-common all 274 [47.6 kB] 751s Get:3 http://ftpmaster.internal/ubuntu questing/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 751s Get:4 http://ftpmaster.internal/ubuntu questing/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 751s Get:5 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common-dev all 274 [73.0 kB] 751s Get:6 http://ftpmaster.internal/ubuntu questing/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 751s Get:7 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-common all 274 [101 kB] 751s Get:8 http://ftpmaster.internal/ubuntu questing/main ppc64el binutils-gold-powerpc64le-linux-gnu ppc64el 2.44-2 [1638 kB] 751s Get:9 http://ftpmaster.internal/ubuntu questing/main ppc64el binutils-gold ppc64el 2.44-2 [2176 B] 751s Get:10 http://ftpmaster.internal/ubuntu questing/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 751s Get:11 http://ftpmaster.internal/ubuntu questing/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 751s Get:12 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [10.5 MB] 752s Get:13 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-14 ppc64el 14.2.0-19ubuntu2 [1036 B] 752s Get:14 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [5566 B] 752s Get:15 http://ftpmaster.internal/ubuntu questing/main ppc64el cpp ppc64el 4:14.2.0-1ubuntu1 [22.4 kB] 752s Get:16 http://ftpmaster.internal/ubuntu questing/main ppc64el libcc1-0 ppc64el 15-20250404-0ubuntu1 [48.6 kB] 752s Get:17 http://ftpmaster.internal/ubuntu questing/main ppc64el libgomp1 ppc64el 15-20250404-0ubuntu1 [168 kB] 752s Get:18 http://ftpmaster.internal/ubuntu questing/main ppc64el libitm1 ppc64el 15-20250404-0ubuntu1 [32.3 kB] 752s Get:19 http://ftpmaster.internal/ubuntu questing/main ppc64el libasan8 ppc64el 15-20250404-0ubuntu1 [3007 kB] 752s Get:20 http://ftpmaster.internal/ubuntu questing/main ppc64el liblsan0 ppc64el 15-20250404-0ubuntu1 [1374 kB] 752s Get:21 http://ftpmaster.internal/ubuntu questing/main ppc64el libtsan2 ppc64el 15-20250404-0ubuntu1 [2732 kB] 752s Get:22 http://ftpmaster.internal/ubuntu questing/main ppc64el libubsan1 ppc64el 15-20250404-0ubuntu1 [1232 kB] 752s Get:23 http://ftpmaster.internal/ubuntu questing/main ppc64el libquadmath0 ppc64el 15-20250404-0ubuntu1 [160 kB] 752s Get:24 http://ftpmaster.internal/ubuntu questing/main ppc64el libgcc-14-dev ppc64el 14.2.0-19ubuntu2 [1618 kB] 752s Get:25 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [20.6 MB] 753s Get:26 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-14 ppc64el 14.2.0-19ubuntu2 [540 kB] 753s Get:27 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [1226 B] 753s Get:28 http://ftpmaster.internal/ubuntu questing/main ppc64el gcc ppc64el 4:14.2.0-1ubuntu1 [5012 B] 753s Get:29 http://ftpmaster.internal/ubuntu questing/main ppc64el libstdc++-14-dev ppc64el 14.2.0-19ubuntu2 [2679 kB] 753s Get:30 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [12.0 MB] 753s Get:31 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-14 ppc64el 14.2.0-19ubuntu2 [23.0 kB] 753s Get:32 http://ftpmaster.internal/ubuntu questing/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [966 B] 753s Get:33 http://ftpmaster.internal/ubuntu questing/main ppc64el g++ ppc64el 4:14.2.0-1ubuntu1 [1088 B] 753s Get:34 http://ftpmaster.internal/ubuntu questing/main ppc64el build-essential ppc64el 12.12ubuntu1 [5094 B] 753s Get:35 http://ftpmaster.internal/ubuntu questing/main ppc64el libllvm20 ppc64el 1:20.1.2-0ubuntu1 [32.0 MB] 754s Get:36 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang-cpp20 ppc64el 1:20.1.2-0ubuntu1 [15.0 MB] 754s Get:37 http://ftpmaster.internal/ubuntu questing/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 754s Get:38 http://ftpmaster.internal/ubuntu questing/universe ppc64el libobjc4 ppc64el 15-20250404-0ubuntu1 [53.6 kB] 754s Get:39 http://ftpmaster.internal/ubuntu questing/universe ppc64el libobjc-14-dev ppc64el 14.2.0-19ubuntu2 [202 kB] 754s Get:40 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang-common-20-dev ppc64el 1:20.1.2-0ubuntu1 [782 kB] 754s Get:41 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-linker-tools ppc64el 1:20.1.2-0ubuntu1 [1405 kB] 754s Get:42 http://ftpmaster.internal/ubuntu questing/universe ppc64el libclang1-20 ppc64el 1:20.1.2-0ubuntu1 [9064 kB] 755s Get:43 http://ftpmaster.internal/ubuntu questing/universe ppc64el clang-20 ppc64el 1:20.1.2-0ubuntu1 [80.9 kB] 755s Get:44 http://ftpmaster.internal/ubuntu questing/main ppc64el libncurses-dev ppc64el 6.5+20250216-2 [484 kB] 755s Get:45 http://ftpmaster.internal/ubuntu questing/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 755s Get:46 http://ftpmaster.internal/ubuntu questing/main ppc64el libssl-dev ppc64el 3.4.1-1ubuntu3 [3140 kB] 755s Get:47 http://ftpmaster.internal/ubuntu questing/main ppc64el libpq-dev ppc64el 17.4-1 [177 kB] 755s Get:48 http://ftpmaster.internal/ubuntu questing/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg+really2.9.14-0.4 [916 kB] 755s Get:49 http://ftpmaster.internal/ubuntu questing/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu4 [191 kB] 755s Get:50 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-runtime ppc64el 1:20.1.2-0ubuntu1 [601 kB] 755s Get:51 http://ftpmaster.internal/ubuntu questing/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 755s Get:52 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20 ppc64el 1:20.1.2-0ubuntu1 [21.5 MB] 755s Get:53 http://ftpmaster.internal/ubuntu questing/main ppc64el libffi-dev ppc64el 3.4.7-1 [67.7 kB] 755s Get:54 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-tools ppc64el 1:20.1.2-0ubuntu1 [600 kB] 755s Get:55 http://ftpmaster.internal/ubuntu questing/universe ppc64el llvm-20-dev ppc64el 1:20.1.2-0ubuntu1 [50.8 MB] 757s Get:56 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 757s Get:57 http://ftpmaster.internal/ubuntu questing/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 757s Get:58 http://ftpmaster.internal/ubuntu questing/universe ppc64el postgresql-server-dev-17 ppc64el 17.4-1 [1440 kB] 757s Get:59 http://ftpmaster.internal/ubuntu questing/main ppc64el tzdata-legacy all 2025b-1ubuntu1 [99.2 kB] 758s Preconfiguring packages ... 758s Fetched 217 MB in 7s (32.6 MB/s) 758s Selecting previously unselected package libjson-perl. 758s (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 ... 107205 files and directories currently installed.) 758s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 758s Unpacking libjson-perl (4.10000-1) ... 758s Selecting previously unselected package postgresql-client-common. 758s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 758s Unpacking postgresql-client-common (274) ... 758s Selecting previously unselected package libio-pty-perl. 758s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 758s Unpacking libio-pty-perl (1:1.20-1build3) ... 758s Selecting previously unselected package libipc-run-perl. 758s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 758s Unpacking libipc-run-perl (20231003.0-2) ... 758s Selecting previously unselected package postgresql-common-dev. 758s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 758s Unpacking postgresql-common-dev (274) ... 758s Selecting previously unselected package ssl-cert. 758s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 758s Unpacking ssl-cert (1.1.3ubuntu1) ... 758s Selecting previously unselected package postgresql-common. 758s Preparing to unpack .../06-postgresql-common_274_all.deb ... 758s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 758s Unpacking postgresql-common (274) ... 758s Selecting previously unselected package binutils-gold-powerpc64le-linux-gnu. 758s Preparing to unpack .../07-binutils-gold-powerpc64le-linux-gnu_2.44-2_ppc64el.deb ... 758s Unpacking binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 758s Selecting previously unselected package binutils-gold. 758s Preparing to unpack .../08-binutils-gold_2.44-2_ppc64el.deb ... 758s Unpacking binutils-gold (2.44-2) ... 758s Selecting previously unselected package libisl23:ppc64el. 758s Preparing to unpack .../09-libisl23_0.27-1_ppc64el.deb ... 758s Unpacking libisl23:ppc64el (0.27-1) ... 758s Selecting previously unselected package libmpc3:ppc64el. 758s Preparing to unpack .../10-libmpc3_1.3.1-1build2_ppc64el.deb ... 758s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 758s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 758s Preparing to unpack .../11-cpp-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 758s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package cpp-14. 759s Preparing to unpack .../12-cpp-14_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 759s Preparing to unpack .../13-cpp-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 759s Unpacking cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 759s Selecting previously unselected package cpp. 759s Preparing to unpack .../14-cpp_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 759s Unpacking cpp (4:14.2.0-1ubuntu1) ... 759s Selecting previously unselected package libcc1-0:ppc64el. 759s Preparing to unpack .../15-libcc1-0_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libgomp1:ppc64el. 759s Preparing to unpack .../16-libgomp1_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libgomp1:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libitm1:ppc64el. 759s Preparing to unpack .../17-libitm1_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libitm1:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libasan8:ppc64el. 759s Preparing to unpack .../18-libasan8_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libasan8:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package liblsan0:ppc64el. 759s Preparing to unpack .../19-liblsan0_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking liblsan0:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libtsan2:ppc64el. 759s Preparing to unpack .../20-libtsan2_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libtsan2:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libubsan1:ppc64el. 759s Preparing to unpack .../21-libubsan1_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libubsan1:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libquadmath0:ppc64el. 759s Preparing to unpack .../22-libquadmath0_15-20250404-0ubuntu1_ppc64el.deb ... 759s Unpacking libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 759s Selecting previously unselected package libgcc-14-dev:ppc64el. 759s Preparing to unpack .../23-libgcc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 759s Preparing to unpack .../24-gcc-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package gcc-14. 759s Preparing to unpack .../25-gcc-14_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 759s Preparing to unpack .../26-gcc-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 759s Unpacking gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 759s Selecting previously unselected package gcc. 759s Preparing to unpack .../27-gcc_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 759s Unpacking gcc (4:14.2.0-1ubuntu1) ... 759s Selecting previously unselected package libstdc++-14-dev:ppc64el. 759s Preparing to unpack .../28-libstdc++-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 759s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 759s Preparing to unpack .../29-g++-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 759s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 760s Selecting previously unselected package g++-14. 760s Preparing to unpack .../30-g++-14_14.2.0-19ubuntu2_ppc64el.deb ... 760s Unpacking g++-14 (14.2.0-19ubuntu2) ... 760s Selecting previously unselected package g++-powerpc64le-linux-gnu. 760s Preparing to unpack .../31-g++-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 760s Unpacking g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 760s Selecting previously unselected package g++. 760s Preparing to unpack .../32-g++_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 760s Unpacking g++ (4:14.2.0-1ubuntu1) ... 760s Selecting previously unselected package build-essential. 760s Preparing to unpack .../33-build-essential_12.12ubuntu1_ppc64el.deb ... 760s Unpacking build-essential (12.12ubuntu1) ... 760s Selecting previously unselected package libllvm20:ppc64el. 760s Preparing to unpack .../34-libllvm20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 760s Unpacking libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 760s Selecting previously unselected package libclang-cpp20. 760s Preparing to unpack .../35-libclang-cpp20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 760s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 761s Selecting previously unselected package libgc1:ppc64el. 761s Preparing to unpack .../36-libgc1_1%3a8.2.8-1_ppc64el.deb ... 761s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 761s Selecting previously unselected package libobjc4:ppc64el. 761s Preparing to unpack .../37-libobjc4_15-20250404-0ubuntu1_ppc64el.deb ... 761s Unpacking libobjc4:ppc64el (15-20250404-0ubuntu1) ... 761s Selecting previously unselected package libobjc-14-dev:ppc64el. 761s Preparing to unpack .../38-libobjc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 761s Unpacking libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 761s Selecting previously unselected package libclang-common-20-dev:ppc64el. 761s Preparing to unpack .../39-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 761s Unpacking libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 761s Selecting previously unselected package llvm-20-linker-tools. 761s Preparing to unpack .../40-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 761s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 761s Selecting previously unselected package libclang1-20. 761s Preparing to unpack .../41-libclang1-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 761s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 761s Selecting previously unselected package clang-20. 761s Preparing to unpack .../42-clang-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 761s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 761s Selecting previously unselected package libncurses-dev:ppc64el. 761s Preparing to unpack .../43-libncurses-dev_6.5+20250216-2_ppc64el.deb ... 761s Unpacking libncurses-dev:ppc64el (6.5+20250216-2) ... 761s Selecting previously unselected package libpq5:ppc64el. 761s Preparing to unpack .../44-libpq5_17.4-1_ppc64el.deb ... 761s Unpacking libpq5:ppc64el (17.4-1) ... 761s Selecting previously unselected package libssl-dev:ppc64el. 761s Preparing to unpack .../45-libssl-dev_3.4.1-1ubuntu3_ppc64el.deb ... 761s Unpacking libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 761s Selecting previously unselected package libpq-dev. 761s Preparing to unpack .../46-libpq-dev_17.4-1_ppc64el.deb ... 761s Unpacking libpq-dev (17.4-1) ... 761s Selecting previously unselected package libxml2-dev:ppc64el. 761s Preparing to unpack .../47-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4_ppc64el.deb ... 761s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4) ... 762s Selecting previously unselected package libxslt1.1:ppc64el. 762s Preparing to unpack .../48-libxslt1.1_1.1.39-0exp1ubuntu4_ppc64el.deb ... 762s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 762s Selecting previously unselected package llvm-20-runtime. 762s Preparing to unpack .../49-llvm-20-runtime_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 762s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 762s Selecting previously unselected package libpfm4:ppc64el. 762s Preparing to unpack .../50-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 762s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 762s Selecting previously unselected package llvm-20. 762s Preparing to unpack .../51-llvm-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 762s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 762s Selecting previously unselected package libffi-dev:ppc64el. 762s Preparing to unpack .../52-libffi-dev_3.4.7-1_ppc64el.deb ... 762s Unpacking libffi-dev:ppc64el (3.4.7-1) ... 762s Selecting previously unselected package llvm-20-tools. 762s Preparing to unpack .../53-llvm-20-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 762s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 762s Selecting previously unselected package llvm-20-dev. 762s Preparing to unpack .../54-llvm-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 762s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 764s Selecting previously unselected package postgresql-client-17. 764s Preparing to unpack .../55-postgresql-client-17_17.4-1_ppc64el.deb ... 764s Unpacking postgresql-client-17 (17.4-1) ... 764s Selecting previously unselected package postgresql-17. 764s Preparing to unpack .../56-postgresql-17_17.4-1_ppc64el.deb ... 764s Unpacking postgresql-17 (17.4-1) ... 765s Selecting previously unselected package postgresql-server-dev-17. 765s Preparing to unpack .../57-postgresql-server-dev-17_17.4-1_ppc64el.deb ... 765s Unpacking postgresql-server-dev-17 (17.4-1) ... 765s Selecting previously unselected package tzdata-legacy. 765s Preparing to unpack .../58-tzdata-legacy_2025b-1ubuntu1_all.deb ... 765s Unpacking tzdata-legacy (2025b-1ubuntu1) ... 765s Setting up postgresql-client-common (274) ... 765s Setting up libncurses-dev:ppc64el (6.5+20250216-2) ... 765s Setting up libio-pty-perl (1:1.20-1build3) ... 765s Setting up libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 765s Setting up libpq5:ppc64el (17.4-1) ... 765s Setting up libgomp1:ppc64el (15-20250404-0ubuntu1) ... 765s Setting up libffi-dev:ppc64el (3.4.7-1) ... 765s Setting up tzdata-legacy (2025b-1ubuntu1) ... 765s Setting up binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 765s Setting up libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4) ... 765s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 765s Setting up ssl-cert (1.1.3ubuntu1) ... 766s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 766s Setting up libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 766s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 766s Setting up libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 766s Setting up libipc-run-perl (20231003.0-2) ... 766s Setting up libgc1:ppc64el (1:8.2.8-1) ... 766s Setting up libubsan1:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up libasan8:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up libjson-perl (4.10000-1) ... 766s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 766s Setting up libtsan2:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up libisl23:ppc64el (0.27-1) ... 766s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 766s Setting up libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up liblsan0:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up libitm1:ppc64el (15-20250404-0ubuntu1) ... 766s Setting up postgresql-common-dev (274) ... 766s Setting up postgresql-client-17 (17.4-1) ... 767s 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 767s Setting up binutils-gold (2.44-2) ... 767s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 767s Setting up libpq-dev (17.4-1) ... 767s Setting up libobjc4:ppc64el (15-20250404-0ubuntu1) ... 767s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 767s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 767s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 767s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 767s Setting up postgresql-common (274) ... 767s Creating config file /etc/postgresql-common/createcluster.conf with new version 767s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 767s Removing obsolete dictionary files: 768s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 769s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 769s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 769s Setting up cpp-14 (14.2.0-19ubuntu2) ... 769s Setting up libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 769s Setting up libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 769s Setting up cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 769s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 769s Setting up postgresql-17 (17.4-1) ... 770s Creating new PostgreSQL cluster 17/main ... 770s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 770s The files belonging to this database system will be owned by user "postgres". 770s This user must also own the server process. 770s 770s The database cluster will be initialized with locale "C.UTF-8". 770s The default database encoding has accordingly been set to "UTF8". 770s The default text search configuration will be set to "english". 770s 770s Data page checksums are disabled. 770s 770s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 770s creating subdirectories ... ok 770s selecting dynamic shared memory implementation ... posix 770s selecting default "max_connections" ... 100 770s selecting default "shared_buffers" ... 128MB 770s selecting default time zone ... Etc/UTC 770s creating configuration files ... ok 770s running bootstrap script ... ok 771s performing post-bootstrap initialization ... ok 771s syncing data to disk ... ok 774s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 774s Setting up libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 774s Setting up gcc-14 (14.2.0-19ubuntu2) ... 774s Setting up gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 774s Setting up cpp (4:14.2.0-1ubuntu1) ... 774s Setting up g++-14 (14.2.0-19ubuntu2) ... 774s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 774s Setting up g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 774s Setting up gcc (4:14.2.0-1ubuntu1) ... 774s Setting up postgresql-server-dev-17 (17.4-1) ... 774s Setting up g++ (4:14.2.0-1ubuntu1) ... 774s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 774s Setting up build-essential (12.12ubuntu1) ... 774s Processing triggers for libc-bin (2.41-6ubuntu1) ... 774s Processing triggers for systemd (257.4-1ubuntu3) ... 774s Processing triggers for man-db (2.13.0-1) ... 775s Processing triggers for install-info (7.1.1-1) ... 796s autopkgtest [11:33:19]: test installcheck: [----------------------- 797s + dpkg-parsechangelog -SSource 797s + SOURCE=postgresql-17 797s + MAJOR=17 797s + top_srcdir=/tmp/autopkgtest.A5wHh1/build.tNG/src 797s + cd src/test/regress 797s + make -f /tmp/autopkgtest.A5wHh1/build.tNG/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 797s 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 -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -fdebug-prefix-map=/build/postgresql-17-CjRP9C/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -I. -I/tmp/autopkgtest.A5wHh1/build.tNG/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 798s 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 -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-stack-clash-protection -fdebug-prefix-map=/build/postgresql-17-CjRP9C/postgresql-17-17.4=/usr/src/postgresql-17-17.4-1 -fPIC -fvisibility=hidden -shared -o regress.so regress.o -L/usr/lib/powerpc64le-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 798s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.A5wHh1/build.tNG/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 799s + id -u 799s + [ 1000 = 0 ] 799s + SU=sh 799s + sh 799s + mktemp -d /tmp/regress.XXXXXX 799s + OUTPUT=/tmp/regress.KGXNPg 799s + trap rm -rf /tmp/regress.KGXNPg EXIT 799s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.KGXNPg --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 799s Creating new PostgreSQL cluster 17/regress ... 802s # using postmaster on localhost, port 5433 802s ok 1 - test_setup 204 ms 803s # parallel group (20 tests): money varchar char text name pg_lsn int4 int2 txid oid float4 uuid int8 regproc float8 enum bit boolean numeric rangetypes 803s ok 2 + boolean 872 ms 803s ok 3 + char 418 ms 803s ok 4 + name 438 ms 803s ok 5 + varchar 405 ms 803s ok 6 + text 429 ms 803s ok 7 + int2 485 ms 803s ok 8 + int4 462 ms 803s ok 9 + int8 530 ms 803s ok 10 + oid 495 ms 803s ok 11 + float4 515 ms 803s ok 12 + float8 570 ms 803s ok 13 + bit 858 ms 803s ok 14 + numeric 951 ms 803s ok 15 + txid 469 ms 803s ok 16 + uuid 503 ms 803s ok 17 + enum 598 ms 803s ok 18 + money 347 ms 803s ok 19 + rangetypes 991 ms 803s ok 20 + pg_lsn 434 ms 803s ok 21 + regproc 513 ms 804s # parallel group (20 tests): line time lseg md5 timetz path circle macaddr macaddr8 date numerology inet strings interval timestamp point timestamptz polygon multirangetypes box 804s ok 22 + strings 495 ms 804s ok 23 + md5 208 ms 804s ok 24 + numerology 327 ms 804s ok 25 + point 667 ms 804s ok 26 + lseg 206 ms 804s ok 27 + line 173 ms 804s ok 28 + box 1410 ms 804s ok 29 + path 252 ms 804s ok 30 + polygon 1034 ms 804s ok 31 + circle 259 ms 804s ok 32 + date 312 ms 804s ok 33 + time 163 ms 804s ok 34 + timetz 214 ms 804s ok 35 + timestamp 626 ms 804s ok 36 + timestamptz 678 ms 804s ok 37 + interval 556 ms 804s ok 38 + inet 334 ms 804s ok 39 + macaddr 268 ms 804s ok 40 + macaddr8 264 ms 804s ok 41 + multirangetypes 1129 ms 805s # parallel group (13 tests): misc_sanity comments unicode type_sanity xid expressions tstypes geometry mvcc database regex opr_sanity horology 805s ok 42 + geometry 432 ms 805s ok 43 + horology 799 ms 805s ok 44 + tstypes 409 ms 805s ok 45 + regex 752 ms 805s ok 46 + type_sanity 355 ms 805s ok 47 + opr_sanity 769 ms 805s ok 48 + misc_sanity 156 ms 805s ok 49 + comments 219 ms 805s ok 50 + expressions 369 ms 805s ok 51 + unicode 223 ms 805s ok 52 + xid 358 ms 805s ok 53 + mvcc 489 ms 805s ok 54 + database 740 ms 806s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 806s ok 55 + copy 222 ms 806s ok 56 + copyselect 128 ms 806s ok 57 + copydml 142 ms 806s ok 58 + insert 447 ms 806s ok 59 + insert_conflict 293 ms 806s # parallel group (7 tests): create_operator create_function_c create_type create_procedure create_misc create_schema create_table 806s ok 60 + create_function_c 136 ms 806s ok 61 + create_misc 198 ms 806s ok 62 + create_operator 124 ms 806s ok 63 + create_procedure 185 ms 806s ok 64 + create_table 414 ms 806s ok 65 + create_type 183 ms 806s ok 66 + create_schema 206 ms 808s # parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 808s ok 67 + create_index 1533 ms 808s ok 68 + create_index_spgist 1368 ms 808s ok 69 + create_view 598 ms 808s ok 70 + index_including 430 ms 808s ok 71 + index_including_gist 629 ms 809s # parallel group (16 tests): infinite_recurse create_aggregate create_cast errors hash_func roleattributes drop_if_exists typed_table create_function_sql create_am select constraints vacuum updatable_views triggers inherit 809s ok 72 + create_aggregate 215 ms 809s ok 73 + create_function_sql 457 ms 809s ok 74 + create_cast 220 ms 809s ok 75 + constraints 627 ms 809s ok 76 + triggers 1247 ms 809s ok 77 + select 574 ms 809s ok 78 + inherit 1260 ms 809s ok 79 + typed_table 369 ms 809s ok 80 + vacuum 732 ms 809s ok 81 + drop_if_exists 337 ms 809s ok 82 + updatable_views 937 ms 809s ok 83 + roleattributes 265 ms 809s ok 84 + create_am 492 ms 809s ok 85 + hash_func 247 ms 809s ok 86 + errors 229 ms 809s ok 87 + infinite_recurse 145 ms 809s ok 88 - sanity_check 79 ms 812s # parallel group (20 tests): case select_distinct_on delete select_having select_implicit namespace select_into prepared_xacts random portals transactions select_distinct union subselect arrays update hash_index aggregates join btree_index 812s ok 89 + select_into 415 ms 812s ok 90 + select_distinct 698 ms 812s ok 91 + select_distinct_on 280 ms 812s ok 92 + select_implicit 315 ms 812s ok 93 + select_having 303 ms 812s ok 94 + subselect 933 ms 812s ok 95 + union 774 ms 812s ok 96 + case 277 ms 812s ok 97 + join 2472 ms 812s ok 98 + aggregates 2258 ms 812s ok 99 + transactions 631 ms 812s ok 100 + random 463 ms 812s ok 101 + portals 580 ms 812s ok 102 + arrays 950 ms 812s ok 103 + btree_index 2809 ms 812s ok 104 + hash_index 1630 ms 812s ok 105 + update 1450 ms 812s ok 106 + delete 294 ms 812s ok 107 + namespace 321 ms 812s ok 108 + prepared_xacts 444 ms 819s # parallel group (20 tests): init_privs drop_operator security_label lock tablesample object_address replica_identity password matview identity collate generated spgist rowsecurity gist groupingsets gin brin join_hash privileges 819s ok 109 + brin 6437 ms 819s ok 110 + gin 2857 ms 819s ok 111 + gist 2526 ms 819s ok 112 + spgist 2093 ms 819s ok 113 + privileges 6886 ms 819s ok 114 + init_privs 180 ms 819s ok 115 + security_label 364 ms 819s ok 116 + collate 1791 ms 819s ok 117 + matview 1549 ms 819s ok 118 + lock 441 ms 819s ok 119 + replica_identity 822 ms 819s ok 120 + rowsecurity 2252 ms 819s ok 121 + object_address 544 ms 819s ok 122 + tablesample 456 ms 819s ok 123 + groupingsets 2575 ms 819s ok 124 + drop_operator 207 ms 819s ok 125 + password 1008 ms 819s ok 126 + identity 1625 ms 819s ok 127 + generated 1934 ms 819s ok 128 + join_hash 6443 ms 819s # parallel group (2 tests): brin_bloom brin_multi 819s ok 129 + brin_bloom 94 ms 819s ok 130 + brin_multi 252 ms 820s # parallel group (17 tests): async dbsize collate.utf8 tid tidscan alter_operator tsrf create_role alter_generic sysviews misc_functions tidrangescan create_table_like merge incremental_sort collate.icu.utf8 misc 820s ok 131 + create_table_like 919 ms 820s ok 132 + alter_generic 559 ms 820s ok 133 + alter_operator 380 ms 820s ok 134 + misc 1336 ms 820s ok 135 + async 213 ms 820s ok 136 + dbsize 223 ms 820s ok 137 + merge 931 ms 820s ok 138 + misc_functions 822 ms 820s ok 139 + sysviews 776 ms 820s ok 140 + tsrf 391 ms 820s ok 141 + tid 330 ms 820s ok 142 + tidscan 338 ms 820s ok 143 + tidrangescan 854 ms 820s ok 144 + collate.utf8 278 ms 820s ok 145 + collate.icu.utf8 1283 ms 820s ok 146 + incremental_sort 1014 ms 820s ok 147 + create_role 457 ms 822s # parallel group (7 tests): amutils collate.linux.utf8 collate.windows.win1252 psql_crosstab rules psql stats_ext 822s ok 148 + rules 421 ms 822s ok 149 + psql 481 ms 822s ok 150 + psql_crosstab 95 ms 822s ok 151 + amutils 54 ms 822s ok 152 + stats_ext 1595 ms 822s ok 153 + collate.linux.utf8 73 ms 822s ok 154 + collate.windows.win1252 77 ms 825s ok 155 - select_parallel 3054 ms 825s ok 156 - write_parallel 141 ms 825s ok 157 - vacuum_parallel 130 ms 827s # parallel group (2 tests): subscription publication 827s ok 158 + publication 2028 ms 827s ok 159 + subscription 59 ms 830s # parallel group (17 tests): portals_p2 advisory_lock combocid xmlmap equivclass tsdicts functional_deps dependency guc select_views cluster bitmapops window indirect_toast foreign_data foreign_key tsearch 830s ok 160 + select_views 634 ms 830s ok 161 + portals_p2 272 ms 830s ok 162 + foreign_key 1982 ms 830s ok 163 + cluster 1244 ms 830s ok 164 + dependency 539 ms 830s ok 165 + guc 550 ms 830s ok 166 + bitmapops 1308 ms 830s ok 167 + combocid 410 ms 830s ok 168 + tsearch 2695 ms 830s ok 169 + tsdicts 495 ms 830s ok 170 + foreign_data 1548 ms 830s ok 171 + window 1359 ms 830s ok 172 + xmlmap 418 ms 830s ok 173 + functional_deps 502 ms 830s ok 174 + advisory_lock 346 ms 830s ok 175 + indirect_toast 1511 ms 830s ok 176 + equivclass 460 ms 831s # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson_jsontable sqljson json jsonb_jsonpath sqljson_queryfuncs jsonb 831s ok 177 + json 297 ms 831s ok 178 + jsonb 473 ms 831s ok 179 + json_encoding 166 ms 831s ok 180 + jsonpath 212 ms 831s ok 181 + jsonpath_encoding 110 ms 831s ok 182 + jsonb_jsonpath 326 ms 831s ok 183 + sqljson 281 ms 831s ok 184 + sqljson_queryfuncs 335 ms 831s ok 185 + sqljson_jsontable 264 ms 833s # parallel group (18 tests): prepare returning limit plancache polymorphism sequence conversion copy2 temp with truncate rowtypes domain largeobject xml rangefuncs plpgsql alter_table 833s ok 186 + plancache 574 ms 833s ok 187 + limit 551 ms 833s ok 188 + plpgsql 1916 ms 833s ok 189 + copy2 1016 ms 833s ok 190 + temp 1154 ms 833s ok 191 + domain 1486 ms 833s ok 192 + rangefuncs 1674 ms 833s ok 193 + prepare 304 ms 833s ok 194 + conversion 956 ms 833s ok 195 + truncate 1307 ms 833s ok 196 + alter_table 2374 ms 833s ok 197 + sequence 870 ms 833s ok 198 + polymorphism 770 ms 833s ok 199 + rowtypes 1332 ms 833s ok 200 + returning 390 ms 833s ok 201 + largeobject 1509 ms 833s ok 202 + with 1276 ms 833s ok 203 + xml 1584 ms 835s # parallel group (13 tests): hash_part reloptions partition_info explain predicate compression memoize partition_aggregate partition_join indexing stats tuplesort partition_prune 835s ok 204 + partition_join 1980 ms 835s ok 205 + partition_prune 2443 ms 835s ok 206 + reloptions 168 ms 835s ok 207 + hash_part 145 ms 835s ok 208 + indexing 2017 ms 835s ok 209 + partition_aggregate 1971 ms 835s ok 210 + partition_info 211 ms 835s ok 211 + tuplesort 2103 ms 836s ok 212 + explain 358 ms 836s ok 213 + compression 622 ms 836s ok 214 + memoize 1518 ms 836s ok 215 + stats 2095 ms 836s ok 216 + predicate 414 ms 836s # parallel group (2 tests): oidjoins event_trigger 836s ok 217 + oidjoins 305 ms 836s ok 218 + event_trigger 327 ms 836s ok 219 - event_trigger_login 83 ms 836s ok 220 - fast_default 148 ms 836s ok 221 - tablespace 341 ms 836s 1..221 836s # All 221 tests passed. 836s Dropping cluster 17/regress ... 837s + rm -rf /tmp/regress.KGXNPg 837s autopkgtest [11:34:00]: test installcheck: -----------------------] 838s autopkgtest [11:34:01]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 838s installcheck PASS 838s autopkgtest [11:34:01]: @@@@@@@@@@@@@@@@@@@@ summary 838s run-testsuite PASS 838s installcheck PASS 856s nova [W] Using flock in prodstack6-ppc64el 856s Creating nova instance adt-questing-ppc64el-postgresql-17-20250503-112003-juju-7f2275-prod-proposed-migration-environment-21-d03ee94a-e83d-4464-ba87-caebcc06aa1e from image adt/ubuntu-questing-ppc64el-server-20250503.img (UUID 1e63be20-33d6-474d-9c56-b247a2188377)... 856s nova [W] Timed out waiting for 780d81ae-08d2-4307-935e-abe339dabee9 to get deleted. 856s nova [W] Using flock in prodstack6-ppc64el 856s Creating nova instance adt-questing-ppc64el-postgresql-17-20250503-112003-juju-7f2275-prod-proposed-migration-environment-21-d03ee94a-e83d-4464-ba87-caebcc06aa1e from image adt/ubuntu-questing-ppc64el-server-20250503.img (UUID 1e63be20-33d6-474d-9c56-b247a2188377)... 856s nova [W] Timed out waiting for 445cb9a3-c721-4ce3-829b-907d88dd5861 to get deleted.