0s autopkgtest [18:36:55]: starting date and time: 2025-05-06 18:36:55+0000 0s autopkgtest [18:36:55]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [18:36:55]: host juju-7f2275-prod-proposed-migration-environment-21; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ymjv5mek/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-17 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025b-1ubuntu1.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-21@bos03-ppc64el-1.secgroup --name adt-plucky-ppc64el-postgresql-17-20250506-183655-juju-7f2275-prod-proposed-migration-environment-21-6f0d5c94-5954-4c72-a600-f5e4a6e5b7bf --image adt/ubuntu-plucky-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/ 119s autopkgtest [18:38:54]: testbed dpkg architecture: ppc64el 120s autopkgtest [18:38:55]: testbed apt version: 3.0.0 120s autopkgtest [18:38:55]: @@@@@@@@@@@@@@@@@@@@ test bed setup 120s autopkgtest [18:38:55]: testbed release detected to be: None 121s autopkgtest [18:38:56]: updating testbed package index (apt update) 121s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 122s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 122s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 122s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 122s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 122s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [5796 B] 122s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el c-n-f Metadata [288 B] 122s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el c-n-f Metadata [120 B] 122s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [20.3 kB] 122s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el c-n-f Metadata [8688 B] 122s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el c-n-f Metadata [172 B] 124s Fetched 306 kB in 1s (440 kB/s) 124s Reading package lists... 125s autopkgtest [18:39:00]: upgrading testbed (apt dist-upgrade and autopurge) 125s Reading package lists... 125s Building dependency tree... 125s Reading state information... 126s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 126s Starting 2 pkgProblemResolver with broken count: 0 126s Done 126s Entering ResolveByKeep 126s 126s Calculating upgrade... 126s The following packages will be upgraded: 126s tzdata 127s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 127s Need to get 198 kB of archives. 127s After this operation, 0 B of additional disk space will be used. 127s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el tzdata all 2025b-1ubuntu1.1 [198 kB] 127s Preconfiguring packages ... 127s Fetched 198 kB in 0s (518 kB/s) 127s (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 ... 78698 files and directories currently installed.) 127s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 127s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 127s Setting up tzdata (2025b-1ubuntu1.1) ... 128s 128s Current default time zone: 'Etc/UTC' 128s Local time is now: Tue May 6 18:39:02 UTC 2025. 128s Universal Time is now: Tue May 6 18:39:02 UTC 2025. 128s Run 'dpkg-reconfigure tzdata' if you wish to change it. 128s 128s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Starting pkgProblemResolver with broken count: 0 128s Starting 2 pkgProblemResolver with broken count: 0 128s Done 129s Solving dependencies... 129s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 131s autopkgtest [18:39:06]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP Sun Apr 6 14:52:42 UTC 2025 131s autopkgtest [18:39:06]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-17 140s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (dsc) [4245 B] 140s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (tar) [21.5 MB] 140s Get:3 http://ftpmaster.internal/ubuntu plucky/main postgresql-17 17.4-1 (diff) [27.2 kB] 140s gpgv: Signature made Thu Feb 20 14:04:49 2025 UTC 140s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 140s gpgv: Can't check signature: No public key 140s dpkg-source: warning: cannot verify inline signature for ./postgresql-17_17.4-1.dsc: no acceptable signature found 144s autopkgtest [18:39:19]: testing package postgresql-17 version 17.4-1 145s autopkgtest [18:39:20]: build not needed 152s autopkgtest [18:39:27]: test run-testsuite: preparing testbed 152s Reading package lists... 152s Building dependency tree... 152s Reading state information... 153s Starting pkgProblemResolver with broken count: 0 153s Starting 2 pkgProblemResolver with broken count: 0 153s Done 153s The following NEW packages will be installed: 153s autoconf automake autopoint autotools-dev binutils-gold 153s binutils-gold-powerpc64le-linux-gnu build-essential clang-20 cpp cpp-14 153s cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu debhelper debugedit 153s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 153s fakeroot g++ g++-14 g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu 153s gcc gcc-14 gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu gettext 153s hunspell-en-us intltool-debian libarchive-zip-perl libasan8 libcc1-0 153s libclang-common-20-dev libclang-cpp20 libclang1-20 libdebhelper-perl 153s libecpg-compat3 libecpg-dev libecpg6 libfakeroot libffi-dev 153s libfile-stripnondeterminism-perl libgc1 libgcc-14-dev libgomp1 153s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl libllvm20 153s liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpgtypes3 153s libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev libtcl8.6 libtool 153s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 153s llvm-20-linker-tools llvm-20-runtime llvm-20-tools locales-all m4 po-debconf 153s postgresql-17 postgresql-client-17 postgresql-client-common 153s postgresql-common postgresql-common-dev postgresql-doc-17 153s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 153s postgresql-server-dev-17 ssl-cert 153s 0 upgraded, 90 newly installed, 0 to remove and 0 not upgraded. 153s Need to get 238 MB of archives. 153s After this operation, 1405 MB of additional disk space will be used. 153s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 153s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 274 [47.6 kB] 153s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 153s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 153s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 274 [73.0 kB] 153s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 153s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 274 [101 kB] 153s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el m4 ppc64el 1.4.19-7 [279 kB] 154s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el autoconf all 2.72-3ubuntu1 [383 kB] 154s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el autotools-dev all 20220109.1 [44.9 kB] 154s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el automake all 1:1.17-3ubuntu1 [572 kB] 154s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el autopoint all 0.23.1-1 [619 kB] 154s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-gold-powerpc64le-linux-gnu ppc64el 2.44-2 [1638 kB] 154s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-gold ppc64el 2.44-2 [2176 B] 154s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 154s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 154s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [10.5 MB] 154s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14 ppc64el 14.2.0-19ubuntu2 [1036 B] 154s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [5566 B] 154s Get:20 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp ppc64el 4:14.2.0-1ubuntu1 [22.4 kB] 154s Get:21 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcc1-0 ppc64el 15-20250404-0ubuntu1 [48.6 kB] 154s Get:22 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgomp1 ppc64el 15-20250404-0ubuntu1 [168 kB] 154s Get:23 http://ftpmaster.internal/ubuntu plucky/main ppc64el libitm1 ppc64el 15-20250404-0ubuntu1 [32.3 kB] 154s Get:24 http://ftpmaster.internal/ubuntu plucky/main ppc64el libasan8 ppc64el 15-20250404-0ubuntu1 [3007 kB] 155s Get:25 http://ftpmaster.internal/ubuntu plucky/main ppc64el liblsan0 ppc64el 15-20250404-0ubuntu1 [1374 kB] 155s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtsan2 ppc64el 15-20250404-0ubuntu1 [2732 kB] 155s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el libubsan1 ppc64el 15-20250404-0ubuntu1 [1232 kB] 155s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el libquadmath0 ppc64el 15-20250404-0ubuntu1 [160 kB] 155s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgcc-14-dev ppc64el 14.2.0-19ubuntu2 [1618 kB] 155s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [20.6 MB] 156s Get:31 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14 ppc64el 14.2.0-19ubuntu2 [540 kB] 156s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [1226 B] 156s Get:33 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc ppc64el 4:14.2.0-1ubuntu1 [5012 B] 156s Get:34 http://ftpmaster.internal/ubuntu plucky/main ppc64el libstdc++-14-dev ppc64el 14.2.0-19ubuntu2 [2679 kB] 156s Get:35 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [12.0 MB] 156s Get:36 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14 ppc64el 14.2.0-19ubuntu2 [23.0 kB] 156s Get:37 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [966 B] 156s Get:38 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++ ppc64el 4:14.2.0-1ubuntu1 [1088 B] 156s Get:39 http://ftpmaster.internal/ubuntu plucky/main ppc64el build-essential ppc64el 12.12ubuntu1 [5094 B] 156s Get:40 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.2-0ubuntu1 [32.0 MB] 157s Get:41 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-cpp20 ppc64el 1:20.1.2-0ubuntu1 [15.0 MB] 157s Get:42 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 157s Get:43 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc4 ppc64el 15-20250404-0ubuntu1 [53.6 kB] 157s Get:44 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc-14-dev ppc64el 14.2.0-19ubuntu2 [202 kB] 157s Get:45 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-common-20-dev ppc64el 1:20.1.2-0ubuntu1 [782 kB] 157s Get:46 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-linker-tools ppc64el 1:20.1.2-0ubuntu1 [1405 kB] 157s Get:47 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang1-20 ppc64el 1:20.1.2-0ubuntu1 [9064 kB] 158s Get:48 http://ftpmaster.internal/ubuntu plucky/universe ppc64el clang-20 ppc64el 1:20.1.2-0ubuntu1 [80.9 kB] 158s Get:49 http://ftpmaster.internal/ubuntu plucky/main ppc64el libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 158s Get:50 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtool all 2.5.4-4 [168 kB] 158s Get:51 http://ftpmaster.internal/ubuntu plucky/main ppc64el dh-autoreconf all 20 [16.1 kB] 158s Get:52 http://ftpmaster.internal/ubuntu plucky/main ppc64el libarchive-zip-perl all 1.68-1 [90.2 kB] 158s Get:53 http://ftpmaster.internal/ubuntu plucky/main ppc64el libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 158s Get:54 http://ftpmaster.internal/ubuntu plucky/main ppc64el dh-strip-nondeterminism all 1.14.1-2 [5064 B] 158s Get:55 http://ftpmaster.internal/ubuntu plucky/main ppc64el debugedit ppc64el 1:5.1-2 [52.4 kB] 158s Get:56 http://ftpmaster.internal/ubuntu plucky/main ppc64el dwz ppc64el 0.15-1build6 [142 kB] 158s Get:57 http://ftpmaster.internal/ubuntu plucky/main ppc64el gettext ppc64el 0.23.1-1 [1155 kB] 158s Get:58 http://ftpmaster.internal/ubuntu plucky/main ppc64el intltool-debian all 0.35.0+20060710.6 [23.2 kB] 158s Get:59 http://ftpmaster.internal/ubuntu plucky/main ppc64el po-debconf all 1.0.21+nmu1 [233 kB] 158s Get:60 http://ftpmaster.internal/ubuntu plucky/main ppc64el debhelper all 13.24.1ubuntu2 [895 kB] 158s Get:61 http://ftpmaster.internal/ubuntu plucky/main ppc64el emacsen-common all 3.0.7 [13.0 kB] 158s Get:62 http://ftpmaster.internal/ubuntu plucky/main ppc64el dictionaries-common all 1.30.10 [178 kB] 158s Get:63 http://ftpmaster.internal/ubuntu plucky/main ppc64el libfakeroot ppc64el 1.37.1-1 [36.0 kB] 158s Get:64 http://ftpmaster.internal/ubuntu plucky/main ppc64el fakeroot ppc64el 1.37.1-1 [70.5 kB] 158s Get:65 http://ftpmaster.internal/ubuntu plucky/main ppc64el hunspell-en-us all 1:2020.12.07-4 [585 kB] 158s Get:66 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpgtypes3 ppc64el 17.4-1 [50.4 kB] 158s Get:67 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 158s Get:68 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg6 ppc64el 17.4-1 [55.4 kB] 158s Get:69 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg-compat3 ppc64el 17.4-1 [14.0 kB] 158s Get:70 http://ftpmaster.internal/ubuntu plucky/main ppc64el libssl-dev ppc64el 3.4.1-1ubuntu3 [3140 kB] 158s Get:71 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq-dev ppc64el 17.4-1 [177 kB] 158s Get:72 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg-dev ppc64el 17.4-1 [287 kB] 158s Get:73 http://ftpmaster.internal/ubuntu plucky/main ppc64el libncurses-dev ppc64el 6.5+20250216-2 [484 kB] 158s Get:74 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtcl8.6 ppc64el 8.6.16+dfsg-1 [1201 kB] 158s Get:75 http://ftpmaster.internal/ubuntu plucky-updates/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [916 kB] 158s Get:76 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu4 [191 kB] 158s Get:77 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-runtime ppc64el 1:20.1.2-0ubuntu1 [601 kB] 158s Get:78 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 158s Get:79 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20 ppc64el 1:20.1.2-0ubuntu1 [21.5 MB] 159s Get:80 http://ftpmaster.internal/ubuntu plucky/main ppc64el libffi-dev ppc64el 3.4.7-1 [67.7 kB] 159s Get:81 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-tools ppc64el 1:20.1.2-0ubuntu1 [600 kB] 159s Get:82 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-dev ppc64el 1:20.1.2-0ubuntu1 [50.8 MB] 160s Get:83 http://ftpmaster.internal/ubuntu plucky/universe ppc64el locales-all ppc64el 2.41-6ubuntu1 [11.2 MB] 160s Get:84 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 160s Get:85 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 161s Get:86 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-doc-17 all 17.4-1 [2131 kB] 161s Get:87 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-plperl-17 ppc64el 17.4-1 [74.6 kB] 161s Get:88 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-plpython3-17 ppc64el 17.4-1 [80.1 kB] 161s Get:89 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-pltcl-17 ppc64el 17.4-1 [31.8 kB] 161s Get:90 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-17 ppc64el 17.4-1 [1440 kB] 161s Preconfiguring packages ... 161s Fetched 238 MB in 8s (30.5 MB/s) 161s Selecting previously unselected package libjson-perl. 161s (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 ... 78698 files and directories currently installed.) 161s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 161s Unpacking libjson-perl (4.10000-1) ... 161s Selecting previously unselected package postgresql-client-common. 161s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 161s Unpacking postgresql-client-common (274) ... 161s Selecting previously unselected package libio-pty-perl. 161s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 161s Unpacking libio-pty-perl (1:1.20-1build3) ... 161s Selecting previously unselected package libipc-run-perl. 161s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 161s Unpacking libipc-run-perl (20231003.0-2) ... 161s Selecting previously unselected package postgresql-common-dev. 161s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 161s Unpacking postgresql-common-dev (274) ... 161s Selecting previously unselected package ssl-cert. 161s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 161s Unpacking ssl-cert (1.1.3ubuntu1) ... 161s Selecting previously unselected package postgresql-common. 161s Preparing to unpack .../06-postgresql-common_274_all.deb ... 161s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 161s Unpacking postgresql-common (274) ... 161s Selecting previously unselected package m4. 161s Preparing to unpack .../07-m4_1.4.19-7_ppc64el.deb ... 161s Unpacking m4 (1.4.19-7) ... 161s Selecting previously unselected package autoconf. 161s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 161s Unpacking autoconf (2.72-3ubuntu1) ... 162s Selecting previously unselected package autotools-dev. 162s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 162s Unpacking autotools-dev (20220109.1) ... 162s Selecting previously unselected package automake. 162s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 162s Unpacking automake (1:1.17-3ubuntu1) ... 162s Selecting previously unselected package autopoint. 162s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 162s Unpacking autopoint (0.23.1-1) ... 162s Selecting previously unselected package binutils-gold-powerpc64le-linux-gnu. 162s Preparing to unpack .../12-binutils-gold-powerpc64le-linux-gnu_2.44-2_ppc64el.deb ... 162s Unpacking binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 162s Selecting previously unselected package binutils-gold. 162s Preparing to unpack .../13-binutils-gold_2.44-2_ppc64el.deb ... 162s Unpacking binutils-gold (2.44-2) ... 162s Selecting previously unselected package libisl23:ppc64el. 162s Preparing to unpack .../14-libisl23_0.27-1_ppc64el.deb ... 162s Unpacking libisl23:ppc64el (0.27-1) ... 162s Selecting previously unselected package libmpc3:ppc64el. 162s Preparing to unpack .../15-libmpc3_1.3.1-1build2_ppc64el.deb ... 162s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 162s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 162s Preparing to unpack .../16-cpp-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 162s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 162s Selecting previously unselected package cpp-14. 162s Preparing to unpack .../17-cpp-14_14.2.0-19ubuntu2_ppc64el.deb ... 162s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 162s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 162s Preparing to unpack .../18-cpp-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 162s Unpacking cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 162s Selecting previously unselected package cpp. 162s Preparing to unpack .../19-cpp_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 162s Unpacking cpp (4:14.2.0-1ubuntu1) ... 162s Selecting previously unselected package libcc1-0:ppc64el. 162s Preparing to unpack .../20-libcc1-0_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libgomp1:ppc64el. 162s Preparing to unpack .../21-libgomp1_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libgomp1:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libitm1:ppc64el. 162s Preparing to unpack .../22-libitm1_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libitm1:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libasan8:ppc64el. 162s Preparing to unpack .../23-libasan8_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libasan8:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package liblsan0:ppc64el. 162s Preparing to unpack .../24-liblsan0_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking liblsan0:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libtsan2:ppc64el. 162s Preparing to unpack .../25-libtsan2_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libtsan2:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libubsan1:ppc64el. 162s Preparing to unpack .../26-libubsan1_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libubsan1:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libquadmath0:ppc64el. 162s Preparing to unpack .../27-libquadmath0_15-20250404-0ubuntu1_ppc64el.deb ... 162s Unpacking libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 162s Selecting previously unselected package libgcc-14-dev:ppc64el. 162s Preparing to unpack .../28-libgcc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 162s Unpacking libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 162s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 162s Preparing to unpack .../29-gcc-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 162s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 163s Selecting previously unselected package gcc-14. 163s Preparing to unpack .../30-gcc-14_14.2.0-19ubuntu2_ppc64el.deb ... 163s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 163s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 163s Preparing to unpack .../31-gcc-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 163s Unpacking gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 163s Selecting previously unselected package gcc. 163s Preparing to unpack .../32-gcc_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 163s Unpacking gcc (4:14.2.0-1ubuntu1) ... 163s Selecting previously unselected package libstdc++-14-dev:ppc64el. 163s Preparing to unpack .../33-libstdc++-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 163s Unpacking libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 163s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 163s Preparing to unpack .../34-g++-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 163s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 163s Selecting previously unselected package g++-14. 163s Preparing to unpack .../35-g++-14_14.2.0-19ubuntu2_ppc64el.deb ... 163s Unpacking g++-14 (14.2.0-19ubuntu2) ... 163s Selecting previously unselected package g++-powerpc64le-linux-gnu. 163s Preparing to unpack .../36-g++-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 163s Unpacking g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 163s Selecting previously unselected package g++. 163s Preparing to unpack .../37-g++_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 163s Unpacking g++ (4:14.2.0-1ubuntu1) ... 163s Selecting previously unselected package build-essential. 163s Preparing to unpack .../38-build-essential_12.12ubuntu1_ppc64el.deb ... 163s Unpacking build-essential (12.12ubuntu1) ... 163s Selecting previously unselected package libllvm20:ppc64el. 163s Preparing to unpack .../39-libllvm20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 163s Unpacking libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package libclang-cpp20. 164s Preparing to unpack .../40-libclang-cpp20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 164s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package libgc1:ppc64el. 164s Preparing to unpack .../41-libgc1_1%3a8.2.8-1_ppc64el.deb ... 164s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 164s Selecting previously unselected package libobjc4:ppc64el. 164s Preparing to unpack .../42-libobjc4_15-20250404-0ubuntu1_ppc64el.deb ... 164s Unpacking libobjc4:ppc64el (15-20250404-0ubuntu1) ... 164s Selecting previously unselected package libobjc-14-dev:ppc64el. 164s Preparing to unpack .../43-libobjc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 164s Unpacking libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 164s Selecting previously unselected package libclang-common-20-dev:ppc64el. 164s Preparing to unpack .../44-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 164s Unpacking libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package llvm-20-linker-tools. 164s Preparing to unpack .../45-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 164s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package libclang1-20. 164s Preparing to unpack .../46-libclang1-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 164s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package clang-20. 164s Preparing to unpack .../47-clang-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 164s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 164s Selecting previously unselected package libdebhelper-perl. 164s Preparing to unpack .../48-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 164s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 164s Selecting previously unselected package libtool. 164s Preparing to unpack .../49-libtool_2.5.4-4_all.deb ... 164s Unpacking libtool (2.5.4-4) ... 164s Selecting previously unselected package dh-autoreconf. 164s Preparing to unpack .../50-dh-autoreconf_20_all.deb ... 164s Unpacking dh-autoreconf (20) ... 164s Selecting previously unselected package libarchive-zip-perl. 164s Preparing to unpack .../51-libarchive-zip-perl_1.68-1_all.deb ... 164s Unpacking libarchive-zip-perl (1.68-1) ... 164s Selecting previously unselected package libfile-stripnondeterminism-perl. 164s Preparing to unpack .../52-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 164s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 164s Selecting previously unselected package dh-strip-nondeterminism. 164s Preparing to unpack .../53-dh-strip-nondeterminism_1.14.1-2_all.deb ... 164s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 164s Selecting previously unselected package debugedit. 164s Preparing to unpack .../54-debugedit_1%3a5.1-2_ppc64el.deb ... 164s Unpacking debugedit (1:5.1-2) ... 164s Selecting previously unselected package dwz. 165s Preparing to unpack .../55-dwz_0.15-1build6_ppc64el.deb ... 165s Unpacking dwz (0.15-1build6) ... 165s Selecting previously unselected package gettext. 165s Preparing to unpack .../56-gettext_0.23.1-1_ppc64el.deb ... 165s Unpacking gettext (0.23.1-1) ... 165s Selecting previously unselected package intltool-debian. 165s Preparing to unpack .../57-intltool-debian_0.35.0+20060710.6_all.deb ... 165s Unpacking intltool-debian (0.35.0+20060710.6) ... 165s Selecting previously unselected package po-debconf. 165s Preparing to unpack .../58-po-debconf_1.0.21+nmu1_all.deb ... 165s Unpacking po-debconf (1.0.21+nmu1) ... 165s Selecting previously unselected package debhelper. 165s Preparing to unpack .../59-debhelper_13.24.1ubuntu2_all.deb ... 165s Unpacking debhelper (13.24.1ubuntu2) ... 165s Selecting previously unselected package emacsen-common. 165s Preparing to unpack .../60-emacsen-common_3.0.7_all.deb ... 165s Unpacking emacsen-common (3.0.7) ... 165s Selecting previously unselected package dictionaries-common. 165s Preparing to unpack .../61-dictionaries-common_1.30.10_all.deb ... 165s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 165s Unpacking dictionaries-common (1.30.10) ... 165s Selecting previously unselected package libfakeroot:ppc64el. 165s Preparing to unpack .../62-libfakeroot_1.37.1-1_ppc64el.deb ... 165s Unpacking libfakeroot:ppc64el (1.37.1-1) ... 165s Selecting previously unselected package fakeroot. 165s Preparing to unpack .../63-fakeroot_1.37.1-1_ppc64el.deb ... 165s Unpacking fakeroot (1.37.1-1) ... 165s Selecting previously unselected package hunspell-en-us. 165s Preparing to unpack .../64-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 165s Unpacking hunspell-en-us (1:2020.12.07-4) ... 165s Selecting previously unselected package libpgtypes3:ppc64el. 165s Preparing to unpack .../65-libpgtypes3_17.4-1_ppc64el.deb ... 165s Unpacking libpgtypes3:ppc64el (17.4-1) ... 165s Selecting previously unselected package libpq5:ppc64el. 165s Preparing to unpack .../66-libpq5_17.4-1_ppc64el.deb ... 165s Unpacking libpq5:ppc64el (17.4-1) ... 165s Selecting previously unselected package libecpg6:ppc64el. 165s Preparing to unpack .../67-libecpg6_17.4-1_ppc64el.deb ... 165s Unpacking libecpg6:ppc64el (17.4-1) ... 165s Selecting previously unselected package libecpg-compat3:ppc64el. 165s Preparing to unpack .../68-libecpg-compat3_17.4-1_ppc64el.deb ... 165s Unpacking libecpg-compat3:ppc64el (17.4-1) ... 165s Selecting previously unselected package libssl-dev:ppc64el. 165s Preparing to unpack .../69-libssl-dev_3.4.1-1ubuntu3_ppc64el.deb ... 165s Unpacking libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 165s Selecting previously unselected package libpq-dev. 165s Preparing to unpack .../70-libpq-dev_17.4-1_ppc64el.deb ... 165s Unpacking libpq-dev (17.4-1) ... 165s Selecting previously unselected package libecpg-dev. 165s Preparing to unpack .../71-libecpg-dev_17.4-1_ppc64el.deb ... 165s Unpacking libecpg-dev (17.4-1) ... 165s Selecting previously unselected package libncurses-dev:ppc64el. 165s Preparing to unpack .../72-libncurses-dev_6.5+20250216-2_ppc64el.deb ... 165s Unpacking libncurses-dev:ppc64el (6.5+20250216-2) ... 165s Selecting previously unselected package libtcl8.6:ppc64el. 165s Preparing to unpack .../73-libtcl8.6_8.6.16+dfsg-1_ppc64el.deb ... 165s Unpacking libtcl8.6:ppc64el (8.6.16+dfsg-1) ... 165s Selecting previously unselected package libxml2-dev:ppc64el. 165s Preparing to unpack .../74-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_ppc64el.deb ... 165s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 165s Selecting previously unselected package libxslt1.1:ppc64el. 165s Preparing to unpack .../75-libxslt1.1_1.1.39-0exp1ubuntu4_ppc64el.deb ... 165s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 165s Selecting previously unselected package llvm-20-runtime. 165s Preparing to unpack .../76-llvm-20-runtime_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 165s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 165s Selecting previously unselected package libpfm4:ppc64el. 165s Preparing to unpack .../77-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 165s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 165s Selecting previously unselected package llvm-20. 165s Preparing to unpack .../78-llvm-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 165s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 166s Selecting previously unselected package libffi-dev:ppc64el. 166s Preparing to unpack .../79-libffi-dev_3.4.7-1_ppc64el.deb ... 166s Unpacking libffi-dev:ppc64el (3.4.7-1) ... 166s Selecting previously unselected package llvm-20-tools. 166s Preparing to unpack .../80-llvm-20-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 166s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 166s Selecting previously unselected package llvm-20-dev. 166s Preparing to unpack .../81-llvm-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 166s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 168s Selecting previously unselected package locales-all. 168s Preparing to unpack .../82-locales-all_2.41-6ubuntu1_ppc64el.deb ... 168s Unpacking locales-all (2.41-6ubuntu1) ... 169s Selecting previously unselected package postgresql-client-17. 169s Preparing to unpack .../83-postgresql-client-17_17.4-1_ppc64el.deb ... 169s Unpacking postgresql-client-17 (17.4-1) ... 169s Selecting previously unselected package postgresql-17. 169s Preparing to unpack .../84-postgresql-17_17.4-1_ppc64el.deb ... 169s Unpacking postgresql-17 (17.4-1) ... 170s Selecting previously unselected package postgresql-doc-17. 170s Preparing to unpack .../85-postgresql-doc-17_17.4-1_all.deb ... 170s Unpacking postgresql-doc-17 (17.4-1) ... 170s Selecting previously unselected package postgresql-plperl-17. 170s Preparing to unpack .../86-postgresql-plperl-17_17.4-1_ppc64el.deb ... 170s Unpacking postgresql-plperl-17 (17.4-1) ... 170s Selecting previously unselected package postgresql-plpython3-17. 170s Preparing to unpack .../87-postgresql-plpython3-17_17.4-1_ppc64el.deb ... 170s Unpacking postgresql-plpython3-17 (17.4-1) ... 170s Selecting previously unselected package postgresql-pltcl-17. 170s Preparing to unpack .../88-postgresql-pltcl-17_17.4-1_ppc64el.deb ... 170s Unpacking postgresql-pltcl-17 (17.4-1) ... 170s Selecting previously unselected package postgresql-server-dev-17. 170s Preparing to unpack .../89-postgresql-server-dev-17_17.4-1_ppc64el.deb ... 170s Unpacking postgresql-server-dev-17 (17.4-1) ... 170s Setting up postgresql-client-common (274) ... 170s Setting up libpgtypes3:ppc64el (17.4-1) ... 170s Setting up libncurses-dev:ppc64el (6.5+20250216-2) ... 170s Setting up libio-pty-perl (1:1.20-1build3) ... 170s Setting up libarchive-zip-perl (1.68-1) ... 170s Setting up libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 170s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 170s Setting up postgresql-doc-17 (17.4-1) ... 170s 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 170s Setting up libpq5:ppc64el (17.4-1) ... 170s Setting up m4 (1.4.19-7) ... 170s Setting up libgomp1:ppc64el (15-20250404-0ubuntu1) ... 170s Setting up libffi-dev:ppc64el (3.4.7-1) ... 170s Setting up locales-all (2.41-6ubuntu1) ... 170s Setting up libfakeroot:ppc64el (1.37.1-1) ... 170s Setting up fakeroot (1.37.1-1) ... 170s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 170s Setting up binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 170s Setting up autotools-dev (20220109.1) ... 170s Setting up libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 170s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 170s Setting up emacsen-common (3.0.7) ... 170s Setting up ssl-cert (1.1.3ubuntu1) ... 171s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 171s Setting up libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 171s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 171s Setting up libtcl8.6:ppc64el (8.6.16+dfsg-1) ... 171s Setting up autopoint (0.23.1-1) ... 171s Setting up libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 171s Setting up libipc-run-perl (20231003.0-2) ... 171s Setting up libgc1:ppc64el (1:8.2.8-1) ... 171s Setting up autoconf (2.72-3ubuntu1) ... 171s Setting up libubsan1:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up dwz (0.15-1build6) ... 171s Setting up libasan8:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up libjson-perl (4.10000-1) ... 171s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 171s Setting up debugedit (1:5.1-2) ... 171s Setting up libecpg6:ppc64el (17.4-1) ... 171s Setting up libtsan2:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up libisl23:ppc64el (0.27-1) ... 171s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 171s Setting up libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up liblsan0:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up libitm1:ppc64el (15-20250404-0ubuntu1) ... 171s Setting up postgresql-common-dev (274) ... 171s Setting up automake (1:1.17-3ubuntu1) ... 171s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 171s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 171s Setting up gettext (0.23.1-1) ... 171s Setting up libecpg-compat3:ppc64el (17.4-1) ... 171s Setting up dictionaries-common (1.30.10) ... 171s Setting up postgresql-client-17 (17.4-1) ... 172s 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 172s Setting up binutils-gold (2.44-2) ... 172s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 172s Setting up libpq-dev (17.4-1) ... 172s Setting up libobjc4:ppc64el (15-20250404-0ubuntu1) ... 172s Setting up libecpg-dev (17.4-1) ... 172s Setting up intltool-debian (0.35.0+20060710.6) ... 172s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 172s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 172s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 172s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 172s Setting up postgresql-common (274) ... 172s Creating config file /etc/postgresql-common/createcluster.conf with new version 172s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 172s en_us 172s Removing obsolete dictionary files: 173s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 173s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 173s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 173s Setting up cpp-14 (14.2.0-19ubuntu2) ... 173s Setting up dh-strip-nondeterminism (1.14.1-2) ... 173s Setting up hunspell-en-us (1:2020.12.07-4) ... 173s Setting up libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 173s Setting up libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 173s Setting up cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 173s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 173s Setting up postgresql-17 (17.4-1) ... 174s Creating new PostgreSQL cluster 17/main ... 174s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 174s The files belonging to this database system will be owned by user "postgres". 174s This user must also own the server process. 174s 174s The database cluster will be initialized with locale "C.UTF-8". 174s The default database encoding has accordingly been set to "UTF8". 174s The default text search configuration will be set to "english". 174s 174s Data page checksums are disabled. 174s 174s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 174s creating subdirectories ... ok 174s selecting dynamic shared memory implementation ... posix 174s selecting default "max_connections" ... 100 174s selecting default "shared_buffers" ... 128MB 174s selecting default time zone ... Etc/UTC 174s creating configuration files ... ok 174s running bootstrap script ... ok 175s performing post-bootstrap initialization ... ok 175s syncing data to disk ... ok 178s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 178s Setting up po-debconf (1.0.21+nmu1) ... 178s Setting up libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 178s Setting up gcc-14 (14.2.0-19ubuntu2) ... 178s Setting up gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 178s Setting up postgresql-plpython3-17 (17.4-1) ... 178s Setting up postgresql-plperl-17 (17.4-1) ... 178s Setting up cpp (4:14.2.0-1ubuntu1) ... 178s Setting up g++-14 (14.2.0-19ubuntu2) ... 178s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 178s Setting up g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 178s Setting up postgresql-pltcl-17 (17.4-1) ... 178s Setting up libtool (2.5.4-4) ... 178s Setting up gcc (4:14.2.0-1ubuntu1) ... 178s Setting up dh-autoreconf (20) ... 178s Setting up postgresql-server-dev-17 (17.4-1) ... 178s Setting up g++ (4:14.2.0-1ubuntu1) ... 178s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 178s Setting up build-essential (12.12ubuntu1) ... 178s Setting up debhelper (13.24.1ubuntu2) ... 178s Processing triggers for man-db (2.13.0-1) ... 180s Processing triggers for install-info (7.1.1-1) ... 180s Processing triggers for libc-bin (2.41-6ubuntu1) ... 180s Processing triggers for systemd (257.4-1ubuntu3) ... 180s Processing triggers for dictionaries-common (1.30.10) ... 182s autopkgtest [18:39:57]: test run-testsuite: [----------------------- 183s ====== Running all tests with umask 077 ======= 183s ### PostgreSQL test 001_packages.t ### 183s 1..22 183s ok 1 - /etc/os-release exists 183s ok 2 - OS is ubuntu 183s ok 3 - OS version is 25.04 183s # PostgreSQL versions installed: 17 183s ok 4 - postgresql-17 installed 183s ok 5 - postgresql-plpython3-17 installed 183s ok 6 - postgresql-plperl-17 installed 183s ok 7 - postgresql-pltcl-17 installed 183s ok 8 - postgresql-server-dev-17 installed 183s ok 9 # skip No postgresql-contrib-17 package for version 17 183s # postgresql-doc-17 installed 183s ok 10 - At least one doc package installed 183s ok 11 - libecpg-dev installed 183s ok 12 - postgresql-common-dev installed 183s ok 13 - procps installed 183s ok 14 - netcat-openbsd installed 183s ok 15 - hunspell-en-us installed 183s ok 16 - system has a default UTF-8 locale 183s ok 17 - locale ru_RU exists 183s ok 18 - locale ru_RU.UTF-8 exists 183s ok 19 - user postgres in the UNIX group ssl-cert 183s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 183s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 183s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 183s ### End test 001_packages.t ### 183s 183s ### PostgreSQL test 002_existing_clusters.t ### 183s 1..8 183s # Cleanup 183s ok 1 - Cleanup: No clusters left behind 183s ok 2 - No postgres processes left behind 183s ok 3 - No files in /etc/postgresql left behind 183s ok 4 - No files in /var/lib/postgresql left behind 183s ok 5 - No files in /var/run/postgresql left behind 183s ok 6 - No files in /var/log/postgresql left behind 183s ok 7 - PostgreSQL TCP ports are closed 183s ok 8 - Next free port is 5432 183s ### End test 002_existing_clusters.t ### 183s 183s ### PostgreSQL test 003_alternatives.t ### 183s 1..9 183s # Newest PG version installed is 17 183s ok 1 - psql.1.gz link group 183s ok 2 - postmaster.1.gz link group does not exist 183s ok 3 - psql.1.gz alternative 183s ok 4 - pg_dump.1.gz alternative 183s ok 5 - postgres.1.gz alternative 183s ok 6 - pg_ctl.1.gz alternative 183s # Newest PG doc version installed is 17 183s ok 7 - SPI_connect.3.gz link group 183s ok 8 - SPI_connect.3.gz alternative 183s ok 9 - SPI_exec.3.gz alternative 183s ### End test 003_alternatives.t ### 183s 183s ### PostgreSQL test 005_PgCommon.t ### 184s 1..24 184s ok 1 - correctly parsed line 'local all postgres ident sameuser' 184s ok 2 - correctly parsed line 'local foo nobody trust' 184s ok 3 - correctly parsed line 'local foo nobody crypt' 184s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 184s ok 5 - correctly parsed line 'local foo,bar nobody ident' 184s ok 6 - correctly parsed line 'local all +foogrp password' 184s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 184s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 184s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 184s ok 10 - @expected_records has correct number of entries 184s ok 11 - returned read_pg_hba array has correct number of records 184s ok 12 - line 'foo all all md5' parsed as invalid 184s ok 13 - line 'local all all foo' parsed as invalid 184s ok 14 - line 'host all all foo' parsed as invalid 184s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 184s ok 16 - line 'host all all md5' parsed as invalid 184s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 184s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 184s ok 19 - read_conf_file returns empty dict for nonexisting file 184s ok 20 - read_conf_file() parsing 184s ok 21 - read_conf_file() parsing with include directives 184s ok 22 - set_conf_value 184s ok 23 - disable_conf_value 184s ok 24 - replace_conf_value 184s ### End test 005_PgCommon.t ### 184s 184s ### PostgreSQL test 006_next_free_port.t ### 184s 1..5 184s ok 1 - next_free_port is 5432 185s ok 2 - next_free_port detects localhost ipv4 socket 186s ok 3 - next_free_port detects wildcard ipv4 socket 187s ok 4 - next_free_port detects localhost ipv6 socket 188s ok 5 - next_free_port detects wildcard ipv6 socket 188s ### End test 006_next_free_port.t ### 188s 188s ### PostgreSQL test 007_pg_conftool.t ### 188s 1..41 188s # test without cluster 188s ok 1 - pg_conftool show all 188s ok 2 - correct output of pg_conftool show all 188s ok 3 - pg_conftool foo.conf show all 188s ok 4 - correct output of pg_conftool foo.conf show all 188s ok 5 - pg_conftool /tmp/_n28HxIhf2/different.conf show all 188s ok 6 - correct output of pg_conftool /tmp/_n28HxIhf2/different.conf show all 188s ok 7 - pg_conftool 9.7 main show all 188s ok 8 - correct output of pg_conftool 9.7 main show all 188s # test show 188s ok 9 - pg_conftool show all 188s ok 10 - correct output of pg_conftool show all 188s ok 11 - pg_conftool other.conf show all 188s ok 12 - correct output of pg_conftool other.conf show all 188s ok 13 - pg_conftool /tmp/_n28HxIhf2/different.conf show all 188s ok 14 - correct output of pg_conftool /tmp/_n28HxIhf2/different.conf show all 188s ok 15 - pg_conftool 17 main show all 188s ok 16 - correct output of pg_conftool 17 main show all 188s ok 17 - pg_conftool 17 main other.conf show all 188s ok 18 - correct output of pg_conftool 17 main other.conf show all 188s ok 19 - pg_conftool show a 188s ok 20 - correct output of pg_conftool show a 188s ok 21 - pg_conftool -s show a 188s ok 22 - correct output of pg_conftool -s show a 188s # test set 188s ok 23 - pg_conftool set c 7 188s ok 24 - correct output of pg_conftool set c 7 188s ok 25 - file contains new setting 188s ok 26 - pg_conftool set a 8 188s ok 27 - correct output of pg_conftool set a 8 188s ok 28 - file contains updated setting 188s ok 29 - pg_conftool /tmp/_n28HxIhf2/different.conf set a 9 188s ok 30 - correct output of pg_conftool /tmp/_n28HxIhf2/different.conf set a 9 188s ok 31 - file with path contains updated setting 188s # test remove 188s ok 32 - pg_conftool remove a 188s ok 33 - correct output of pg_conftool remove a 188s ok 34 - setting removed from file 188s ok 35 - pg_conftool /tmp/_n28HxIhf2/different.conf remove a 188s ok 36 - correct output of pg_conftool /tmp/_n28HxIhf2/different.conf remove a 188s ok 37 - setting removed from file with path 188s # test edit 188s ok 38 - pg_conftool edit 188s ok 39 - correct output of pg_conftool edit 188s ok 40 - pg_conftool /tmp/_n28HxIhf2/different.conf edit 188s ok 41 - correct output of pg_conftool /tmp/_n28HxIhf2/different.conf edit 188s ### End test 007_pg_conftool.t ### 188s 188s ### PostgreSQL test 010_defaultport_cluster.t ### 188s 1..14 189s ok 1 - psql --version 189s ok 2 - pg_wrapper selects highest available version number 189s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 189s ok 4 - connecting to localhost fails with no clusters 189s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 189s ok 6 - pg_wrapper uses host and port from PGCLUSTER 189s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 189s ok 8 - pg_wrapper uses --cluster from the command line 189s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 189s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 189s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 189s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 189s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 189s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 189s ### End test 010_defaultport_cluster.t ### 189s 189s ### PostgreSQL test 015_start_stop.t ### 189s 1..71 189s # We are running systemd 189s # Running tests for 17 189s # Cluster does not exist yet 189s ok 1 - cluster 17 main does not exist 189s ok 2 - service postgresql@17-main does not exist 189s ok 3 - systemctl start postgresql 189s ok 4 - cluster 17 main does not exist 189s ok 5 - service postgresql@17-main does not exist 189s ok 6 - systemctl start postgresql@17-main 189s ok 7 - cluster 17 main does not exist 189s ok 8 - service postgresql@17-main does not exist 189s # Start/stop postgresql using system tools 190s ok 9 - pg_createcluster 17 main 190s ok 10 - cluster 17 main is stopped 190s ok 11 - service postgresql@17-main is stopped 193s ok 12 - systemctl start postgresql 193s ok 13 - cluster 17 main is running 193s ok 14 - service postgresql@17-main is running 193s ok 15 - systemctl start postgresql 193s ok 16 - cluster 17 main is already running 193s ok 17 - service postgresql@17-main is already running 193s ok 18 - systemctl stop postgresql 199s ok 19 - cluster 17 main is stopped 199s ok 20 - service postgresql@17-main is stopped 199s ok 21 - systemctl stop postgresql 199s ok 22 - cluster 17 main is already stopped 199s ok 23 - service postgresql@17-main is already stopped 199s # Start/stop specific cluster using system tools 201s ok 24 - systemctl start postgresql@17-main 201s ok 25 - cluster 17 main is running 201s ok 26 - service postgresql@17-main is running 201s ok 27 - systemctl start postgresql@17-main 201s ok 28 - cluster 17 main is running 201s ok 29 - service postgresql@17-main is running 204s ok 30 - systemctl restart postgresql@17-main 204s ok 31 - cluster 17 main is running 204s ok 32 - service postgresql@17-main is running 204s ok 33 - systemctl stop postgresql@17-main 204s ok 34 - cluster 17 main is stopped 204s ok 35 - service postgresql@17-main is stopped 204s ok 36 - systemctl stop postgresql@17-main 204s ok 37 - cluster 17 main is already stopped 204s ok 38 - service postgresql@17-main is already stopped 205s ok 39 - pg_dropcluster 17 main 205s ok 40 - cluster 17 main does not exist 205s ok 41 - service postgresql@17-main does not exist 205s # Start/stop specific cluster using pg_*cluster 205s ok 42 - pg_ctlcluster start 17 main 206s ok 43 - cluster 17 main does not exist 206s ok 44 - service postgresql@17-main does not exist 209s ok 45 - pg_createcluster 17 main --start 209s ok 46 - cluster 17 main is running 209s ok 47 - service postgresql@17-main is running 209s ok 48 - pg_ctlcluster 17 main start 209s ok 49 - cluster 17 main is already running 209s ok 50 - service postgresql@17-main is already running 211s ok 51 - pg_ctlcluster 17-main restart 211s ok 52 - cluster 17 main is running 212s ok 53 - service postgresql@17-main is running 212s ok 54 - pg_ctlcluster 17 main stop 212s ok 55 - cluster 17 main is stopped 212s ok 56 - service postgresql@17-main is stopped 212s ok 57 - pg_ctlcluster 17 main stop 212s ok 58 - cluster 17 main is already stopped 212s ok 59 - service postgresql@17-main is already stopped 214s ok 60 - pg_ctlcluster start 17-main 214s ok 61 - cluster 17 main is running 214s ok 62 - service postgresql@17-main is running 216s ok 63 - pg_dropcluster 17 main --stop 216s # Cleanup 216s ok 64 - Cleanup: No clusters left behind 216s ok 65 - No postgres processes left behind 216s ok 66 - No files in /etc/postgresql left behind 216s ok 67 - No files in /var/lib/postgresql left behind 216s ok 68 - No files in /var/run/postgresql left behind 216s ok 69 - No files in /var/log/postgresql left behind 216s ok 70 - PostgreSQL TCP ports are closed 216s ok 71 - Next free port is 5432 216s ### End test 015_start_stop.t ### 216s 216s ### PostgreSQL test 020_create_sql_remove.t ### 216s 1..141 216s # Running tests for 17 219s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.fxlAGn 219s ok 2 - pg_createcluster 17 main 219s ok 3 - Socket and pid file are in /var/run/postgresql/ 219s ok 4 - xlog/wal directory /tmp/17.xlog.fxlAGn was created 219s ok 5 - local method in pg_hba.conf is peer 219s ok 6 - host method in pg_hba.conf is scram-sha-256 219s ok 7 - Exactly one postgres master process running 222s ok 8 - pg_ctlcluster 17 main restart 222s ok 9 - cluster restarts with new environment file 222s ok 10 - Exactly one postgres master process running 222s ok 11 - correct value of PGEXTRAVAR1 in environment 222s ok 12 - correct value of PGEXTRAVAR2 in environment 222s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 222s ok 14 - createdb --version 222s ok 15 - pg_wrapper+createdb selects version number of cluster 222s ok 16 - psql --version 222s ok 17 - pg_wrapper+psql selects version 17 222s ok 18 - pg_lscluster reports online cluster on port 5432 222s ok 19 - log file is actually used 222s ok 20 - /etc/postgresql is owned by user "postgres" 222s ok 21 - version configuration directory file is owned by user "postgres" 222s ok 22 - configuration directory file is owned by user "postgres" 222s ok 23 - version data directory file is owned by user "postgres" 222s ok 24 - data directory file is owned by user "postgres" 222s ok 25 - log file has 0640 permissions 222s ok 26 - log file is owned by user "postgres" 222s ok 27 - log file is owned by group "adm" 222s ok 28 - no log symlink by default 222s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 222s ok 30 - pg_lsclusters -h 222s ok 31 - correct output of pg_lsclusters -h 222s ok 32 - stopping cluster 225s ok 33 - restarting cluster with nondefault log symlink 225s ok 34 - log target is used as log file 225s ok 35 - default log is not used 225s ok 36 - pg_lsclusters -h 225s ok 37 - correct output of pg_lsclusters -h 225s ok 38 - stopping cluster 228s ok 39 - restarting cluster with explicitly configured log file 228s ok 40 - default log is not used 228s ok 41 - log symlink target is used for startup message 228s ok 42 - exactly one log file 228s ok 43 - custom log is actually used 228s ok 44 - pg_lsclusters -h 228s ok 45 - correct output of pg_lsclusters -h 228s ok 46 - stopping cluster 228s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 228s ok 48 - /etc/postgres-hack was not created 230s ok 49 - restarting cluster 230s ok 50 - ps -o tty -U postgres h 230s ok 51 - postgres processes do not have an associated terminal 230s ok 52 - Server is linked with SSL support 230s ok 53 - SSL is enabled in postgresql.conf 230s ok 54 - psql -l fails for nobody 230s ok 55 - createuser nobody 230s ok 56 - createdb nobodydb 230s ok 57 - psql -ltA succeeds for nobody 230s ok 58 - psql -ltA output 230s ok 59 - SQL command: create table 231s ok 60 - SQL command: insert into table values 231s ok 61 - SQL command: insert into table values 231s ok 62 - primary key violation 231s ok 63 - psql -tAc "select * from phone order by name" nobodydb 231s ok 64 - SQL command output: select -tA 231s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 231s ok 66 - SQL command output: select -tx 231s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 231s ok 68 - SQL command output: select -tAx 231s ok 69 - CREATE EXTENSION plperlu fails for user nobody 231s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 231s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 231s ok 72 - creating PL/PerlU function as user nobody fails 231s ok 73 - creating unsafe PL/Perl function as user postgres fails 231s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 231s ok 75 - creating PL/PerlU function as user postgres succeeds 231s ok 76 - psql nobodydb -Atc "select read_file()" 231s ok 77 - calling PL/PerlU function 231s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 231s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 231s ok 80 - creating unsafe PL/Perl function as user nobody fails 231s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 231s ok 82 - creating PL/Perl function as user nobody succeeds 231s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 231s ok 84 - calling PL/Perl function 231s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 231s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 231s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 231s ok 88 - creating PL/Python3 function as user postgres succeeds 232s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 232s ok 90 - calling PL/Python function 232s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 232s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 232s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 232s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 232s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 232s ok 96 - creating PL/Tcl function as user nobody succeeds 232s 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;" 232s ok 98 - creating PL/TclU function as user postgres succeeds 232s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 232s ok 100 - calling PL/Tcl function 232s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 232s ok 102 - calling PL/TclU function 232s ok 103 - stopping cluster 232s ok 104 - pg_ctlcluster 17 main start 232s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 234s ok 106 - pg_ctlcluster 17 main start 234s ok 107 - cluster restarts with pgdata symlink 235s ok 108 - postgres master has OOM killer protection 235s ok 109 - postgres client backend has no OOM adjustment 235s ok 110 - ps h 7041 235s ok 111 - process title is idle 235s ok 112 - ps h 7041 235s ok 113 - process title is idle in transaction 235s ok 114 - stopping cluster 238s ok 115 - starting cluster as postgres works without a log file 238s ok 116 - log file got recreated and used 238s ok 117 - creating a directory in spc2 238s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.FoLZZ3'" 238s ok 119 - creating tablespace spc1 238s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 238s ok 121 - creating a table in spc1 238s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.uT3mhl'" 238s ok 123 - creating tablespace spc2 238s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 238s ok 125 - creating a table in spc2 238s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 238s ok 127 - Correct apt NeverAutoRemove config 239s ok 128 - pg_dropcluster removes cluster 239s ok 129 - xlog/wal directory /tmp/17.xlog.fxlAGn was deleted 239s ok 130 - tablespace spc1 was emptied 239s ok 131 - tablespace spc2 was emptied 239s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 239s ok 133 - Correct apt NeverAutoRemove config 239s # Cleanup 239s ok 134 - Cleanup: No clusters left behind 239s ok 135 - No postgres processes left behind 239s ok 136 - No files in /etc/postgresql left behind 239s ok 137 - No files in /var/lib/postgresql left behind 239s ok 138 - No files in /var/run/postgresql left behind 239s ok 139 - No files in /var/log/postgresql left behind 239s ok 140 - PostgreSQL TCP ports are closed 239s ok 141 - Next free port is 5432 239s ### End test 020_create_sql_remove.t ### 239s 239s ### PostgreSQL test 021_pg_renamecluster.t ### 240s 1..20 243s ok 1 - pg_createcluster 17 main 246s ok 2 - pg_renamecluster 17 main donau 246s ok 3 - psql -tAc "show data_directory" 246s ok 4 - cluster is running and data_directory was moved 246s ok 5 - pg_hba.conf location updated 246s ok 6 - pg_ident.conf location updated 246s ok 7 - external_pid_file location updated 246s ok 8 - external_pid_file exists 246s ok 9 # skip no stats_temp_directory in 17 246s ok 10 # skip no stats_temp_directory in 17 246s ok 11 - cluster_name is updated 247s ok 12 - pg_dropcluster removes cluster 247s # Cleanup 247s ok 13 - Cleanup: No clusters left behind 247s ok 14 - No postgres processes left behind 247s ok 15 - No files in /etc/postgresql left behind 247s ok 16 - No files in /var/lib/postgresql left behind 247s ok 17 - No files in /var/run/postgresql left behind 247s ok 18 - No files in /var/log/postgresql left behind 247s ok 19 - PostgreSQL TCP ports are closed 247s ok 20 - Next free port is 5432 247s ### End test 021_pg_renamecluster.t ### 247s 247s ### PostgreSQL test 022_recovery.t ### 247s 1..17 247s # Running tests for 17 251s ok 1 - pg_createcluster 17 main --start >/dev/null 251s ok 2 - pg_ctlcluster 17 main stop -m i 253s ok 3 - pg_ctlcluster 17 main start 253s ok 4 - psql -c '' 254s ok 5 - pg_ctlcluster 17 main stop -m i 254s ok 6 - create write-protected file in data directory 256s ok 7 - pg_ctlcluster 17 main start 256s ok 8 - psql -c '' 258s ok 9 - pg_dropcluster removes cluster 258s # Cleanup 258s ok 10 - Cleanup: No clusters left behind 258s ok 11 - No postgres processes left behind 258s ok 12 - No files in /etc/postgresql left behind 258s ok 13 - No files in /var/lib/postgresql left behind 258s ok 14 - No files in /var/run/postgresql left behind 258s ok 15 - No files in /var/log/postgresql left behind 258s ok 16 - PostgreSQL TCP ports are closed 258s ok 17 - Next free port is 5432 258s ### End test 022_recovery.t ### 258s 258s ### PostgreSQL test 025_logging.t ### 258s 1..55 258s # Logging to /var/log/syslog works 258s # Running tests for 17 262s ok 1 - pg_createcluster 17 main 262s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 262s ok 3 - psql -qc "'foobar_17_8250'" 262s ok 4 - log an error 262s ok 5 - grep --binary-files=text foobar_17_8250 /var/log/postgresql/postgresql-17-main.log 262s ok 6 - error appears in logfile 262s ok 7 - pg_conftool 17 main set log_destination syslog 262s ok 8 - set log_destination syslog 262s ok 9 - pg_ctlcluster 17 main reload 262s ok 10 - 17 main reload 263s ok 11 - psql -Atc "show log_destination" 263s ok 12 - log_destination is syslog 263s ok 13 - pg_lscluster reports syslog 263s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 263s ok 15 - error appears in /var/log/syslog 263s ok 16 - pg_conftool 17 main set logging_collector on 263s ok 17 - set logging_collector on 263s ok 18 - pg_conftool 17 main set log_destination csvlog 263s ok 19 - set log_destination csvlog 266s ok 20 - pg_ctlcluster 17 main restart 266s ok 21 - 17 main restart 266s ok 22 - psql -Atc "show logging_collector" 266s ok 23 - logging_collector is on 266s ok 24 - psql -Atc "show log_destination" 266s ok 25 - log_destination is csvlog 266s ok 26 - pg_lscluster reports csvlog 266s ok 27 - psql -qc "'barbaz_17_8250'" 266s ok 28 - log an error 266s ok 29 - grep --binary-files=text barbaz_17_8250 /var/lib/postgresql/17/main/log/*.csv 266s ok 30 - error appears in log/*.csv 266s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 266s ok 32 - set log_destination stderr,syslog,csvlog 266s ok 33 - pg_ctlcluster 17 main reload 266s ok 34 - 17 main reload 266s ok 35 - psql -Atc "show log_destination" 266s ok 36 - log_destination is stderr,syslog,csvlog 266s ok 37 - pg_lscluster reports stderr,syslog,csvlog 267s ok 38 - psql -qc "'moo_17_8250'" 267s ok 39 - log an error 267s ok 40 - grep --binary-files=text moo_17_8250 /var/lib/postgresql/17/main/log/*.log 267s ok 41 - error appears in log/*.log 268s ok 42 - grep --binary-files=text 'postgres.*moo_17_8250' /var/log/syslog 268s ok 43 - error appears in /var/log/syslog 268s ok 44 - grep --binary-files=text moo_17_8250 /var/lib/postgresql/17/main/log/*.csv 268s ok 45 - error appears in log/*.csv 269s ok 46 - pg_dropcluster 17 main --stop 269s ok 47 - pg_dropcluster removes cluster 269s # Cleanup 269s ok 48 - Cleanup: No clusters left behind 269s ok 49 - No postgres processes left behind 269s ok 50 - No files in /etc/postgresql left behind 269s ok 51 - No files in /var/lib/postgresql left behind 269s ok 52 - No files in /var/run/postgresql left behind 269s ok 53 - No files in /var/log/postgresql left behind 269s ok 54 - PostgreSQL TCP ports are closed 269s ok 55 - Next free port is 5432 269s ### End test 025_logging.t ### 269s 269s ### PostgreSQL test 027_jit.t ### 269s # 17 273s ok 1 - pg_createcluster 17 main --start 273s ok 2 - psql -Xatc 'show jit' 273s ok 3 - JIT is on by default 273s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 273s ok 5 - No JIT on cheap query 273s ok 6 - pg_conftool 17 main set seq_page_cost 100000 273s ok 7 - pg_conftool 17 main set random_page_cost 100000 273s ok 8 - pg_ctlcluster 17 main reload 273s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 273s ok 10 - Expensive query is JITed 275s ok 11 - pg_dropcluster --stop 17 main 275s # Cleanup 275s ok 12 - Cleanup: No clusters left behind 275s ok 13 - No postgres processes left behind 275s ok 14 - No files in /etc/postgresql left behind 275s ok 15 - No files in /var/lib/postgresql left behind 275s ok 16 - No files in /var/run/postgresql left behind 275s ok 17 - No files in /var/log/postgresql left behind 275s ok 18 - PostgreSQL TCP ports are closed 275s ok 19 - Next free port is 5432 275s 1..19 275s ### End test 027_jit.t ### 275s 275s ### PostgreSQL test 030_errors.t ### 275s 1..156 275s ok 1 - pg_lscluster reports cluster without binaries 276s ok 2 - pg_dropcluster 6.3 main 277s ok 3 - pg_createcluster --socketdir 277s ok 4 - pg_lsclusters -h 277s ok 5 - cluster was created 277s ok 6 - Port of created cluster is 5432 277s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 277s ok 8 - pg_createcluster on existing cluster 277s ok 9 - pg_lsclusters -h 277s ok 10 - original cluster still exists 277s ok 11 - pg_createcluster 17 test -p foo 277s ok 12 - pg_createcluster -p checks that port option is numeric 277s ok 13 - pg_createcluster 17 test -p 42 277s ok 14 - pg_createcluster -p checks valid port range 277s ok 15 - pg_ctlcluster 17 main start 277s ok 16 - pg_ctlcluster refuses to start root-owned cluster 277s ok 17 - pg_ctlcluster 17 main start 277s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 277s ok 19 - pg_ctlcluster 17 main start 277s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 277s ok 21 - pg_ctlcluster 17 main start 277s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 280s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 280s ok 24 - No sockets in /var/run/postgresql 280s ok 25 - Socket is in /tmp/postgresql-testsuite/ 280s ok 26 - cluster stops with custom unix_socket_dir 280s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 282s ok 28 - cluster starts after removing unix_socket_dir 282s ok 29 - Socket is in default dir /var/run/postgresql 282s ok 30 - No sockets in /tmp/postgresql-testsuite/ 282s ok 31 - pg_ctlcluster 17 main stop 282s ok 32 - pg_ctlcluster fails with corrupted PID file 282s ok 33 - pg_lsclusters -h 282s ok 34 - cluster is still online 283s ok 35 - pg_ctlcluster succeeds with restored PID file 283s ok 36 - pg_lsclusters -h 283s ok 37 - cluster is down 283s ok 38 - pg_ctlcluster 17 main stop 283s ok 39 - pg_ctlcluster stop fails on stopped cluster 285s ok 40 - pg_ctlcluster 17 main start 285s ok 41 - pg_ctlcluster succeeds with already existing PID file 285s ok 42 - pg_lsclusters -h 285s ok 43 - cluster is online 285s ok 44 - pg_ctlcluster stop succeeds 285s ok 45 - pg_lsclusters -h 285s ok 46 - cluster is down 285s ok 47 - no pid file left 285s ok 48 - pg_ctlcluster 17 main stop 285s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 285s ok 50 - pid file was cleaned up 285s ok 51 - pg_ctlcluster --force 17 main stop 285s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 285s ok 53 - pid file was cleaned up 285s ok 54 - pg_ctlcluster 17 main stop 285s ok 55 - pg_ctlcluster stop succeeds with stale PID file 285s ok 56 - pid file was cleaned up 285s ok 57 - pg_ctlcluster --force 17 main stop 285s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 285s ok 59 - pid file was cleaned up 285s ok 60 - pg_ctlcluster --force 17 main stop 285s ok 61 - pg_ctlcluster stop succeeds with empty PID file 285s ok 62 - pid file was cleaned up 288s ok 63 - pg_ctlcluster 17 main start 288s ok 64 - pg_ctlcluster succeeds with corrupted PID file 288s ok 65 - pg_lsclusters -h 288s ok 66 - cluster is online 288s ok 67 - pg_ctlcluster 17 main start 288s ok 68 - pg_ctlcluster start fails on running cluster 288s ok 69 - pg_ctlcluster stop 288s ok 70 - pg_ctlcluster 17 main start 288s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 288s ok 72 - pg_ctlcluster 17 main stop 288s ok 73 - stopping cluster 294s ok 74 - pg_ctlcluster 17 main start 294s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 294s ok 76 - pg_ctlcluster 17 main stop 294s ok 77 - stopping cluster 294s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 295s ok 79 - pg_dropcluster 17 main 295s ok 80 - pg_dropcluster works as user postgres 296s ok 81 - pg_createcluster succeeds 296s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 296s ok 83 - proper error message for nonexisting /var/lib/postgresql 298s ok 84 - pg_ctlcluster 17 main start 298s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 298s ok 86 - pg_ctlcluster 17 main stop 298s ok 87 - stopping cluster 299s ok 88 - pg_createcluster other 301s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 303s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 303s ok 91 303s ok 92 - pg_ctlcluster 17 other start 303s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 304s ok 94 - pg_ctlcluster 17 main stop 304s ok 95 - stopping main cluster 306s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 308s ok 97 - pg_dropcluster other 309s ok 98 - pg_dropcluster 309s ok 99 - No sockets any more 309s ok 100 - 'pg_lsclusters 4.5 foo' fails 309s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 309s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 309s ok 103 - 'psql --cluster 4.5/foo' fails 309s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 309s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 309s ok 106 - 'psql --cluster 17/foo' fails 309s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 309s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 309s ok 109 - 'pg_dropcluster 4.5 foo' fails 309s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 309s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 309s ok 112 - 'pg_dropcluster 17 foo' fails 309s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 309s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 309s ok 115 - 'pg_upgradecluster 4.5 foo' fails 309s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 309s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 309s ok 118 - 'pg_upgradecluster 17 foo' fails 309s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 309s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 309s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 309s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 309s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 309s ok 124 - 'pg_ctlcluster 17 foo stop' fails 309s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 309s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 309s # Cleanup 309s ok 127 - Cleanup: No clusters left behind 309s ok 128 - No postgres processes left behind 309s ok 129 - No files in /etc/postgresql left behind 309s ok 130 - No files in /var/lib/postgresql left behind 309s ok 131 - No files in /var/run/postgresql left behind 309s ok 132 - No files in /var/log/postgresql left behind 309s ok 133 - PostgreSQL TCP ports are closed 309s ok 134 - Next free port is 5432 311s ok 135 - pg_dropcluster 17 broken 311s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 311s # Cleanup 311s ok 137 - Cleanup: No clusters left behind 311s ok 138 - No postgres processes left behind 311s ok 139 - No files in /etc/postgresql left behind 311s ok 140 - No files in /var/lib/postgresql left behind 311s ok 141 - No files in /var/run/postgresql left behind 311s ok 142 - No files in /var/log/postgresql left behind 311s ok 143 - PostgreSQL TCP ports are closed 311s ok 144 - Next free port is 5432 312s ok 145 - pg_dropcluster 17 broken 312s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 312s ok 147 - /etc/postgresql/17 was removed 312s ok 148 - /var/lib/postgresql/17 was removed 312s # Cleanup 312s ok 149 - Cleanup: No clusters left behind 312s ok 150 - No postgres processes left behind 312s ok 151 - No files in /etc/postgresql left behind 312s ok 152 - No files in /var/lib/postgresql left behind 312s ok 153 - No files in /var/run/postgresql left behind 312s ok 154 - No files in /var/log/postgresql left behind 312s ok 155 - PostgreSQL TCP ports are closed 312s ok 156 - Next free port is 5432 312s ### End test 030_errors.t ### 312s 312s ### PostgreSQL test 031_errors_disk_full.t ### 312s 1..22 312s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 313s ok 1 - script failed 313s ok 2 - pg_createcluster fails due to insufficient disk space 313s ok 3 - does not leave files behind 313s # Cleanup 314s ok 4 - Cleanup: No clusters left behind 314s ok 5 - No postgres processes left behind 314s ok 6 - No files in /etc/postgresql left behind 314s ok 7 - No files in /var/lib/postgresql left behind 314s ok 8 - No files in /var/run/postgresql left behind 314s ok 9 - No files in /var/log/postgresql left behind 314s ok 10 - PostgreSQL TCP ports are closed 314s ok 11 - Next free port is 5432 314s # check disk full conditions on startup 316s ok 12 - script failed 316s ok 13 - pg_ctlcluster prints error message 316s ok 14 - log file has error message 316s # Cleanup 317s ok 15 - Cleanup: No clusters left behind 317s ok 16 - No postgres processes left behind 317s ok 17 - No files in /etc/postgresql left behind 317s ok 18 - No files in /var/lib/postgresql left behind 317s ok 19 - No files in /var/run/postgresql left behind 317s ok 20 - No files in /var/log/postgresql left behind 317s ok 21 - PostgreSQL TCP ports are closed 317s ok 22 - Next free port is 5432 317s ### End test 031_errors_disk_full.t ### 317s 317s ### PostgreSQL test 032_ssl_key_permissions.t ### 317s 1..22 317s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 317s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 317s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 318s ok 4 - pg_createcluster 17 main 318s ok 5 - pg_ctlcluster 17 main start 318s ok 6 - ssl key owned by nobody refused 318s ok 7 - pg_ctlcluster 17 main start 318s ok 8 - ssl key with permissions root:root 0644 refused 318s ok 9 - pg_ctlcluster 17 main start 318s ok 10 - ssl key with permissions postgres:postgres 0640 refused 320s ok 11 - pg_dropcluster 17 main --stop 320s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 320s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 320s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 320s # Cleanup 320s ok 15 - Cleanup: No clusters left behind 320s ok 16 - No postgres processes left behind 320s ok 17 - No files in /etc/postgresql left behind 320s ok 18 - No files in /var/lib/postgresql left behind 320s ok 19 - No files in /var/run/postgresql left behind 320s ok 20 - No files in /var/log/postgresql left behind 320s ok 21 - PostgreSQL TCP ports are closed 320s ok 22 - Next free port is 5432 320s ### End test 032_ssl_key_permissions.t ### 320s 320s ### PostgreSQL test 040_upgrade.t ### 320s 1..1 320s ok 1 - only one major version installed, skipping upgrade tests 320s ### End test 040_upgrade.t ### 320s 320s ### PostgreSQL test 041_upgrade_custompaths.t ### 320s 1..1 320s ok 1 - only one major version installed, skipping upgrade tests 320s ### End test 041_upgrade_custompaths.t ### 320s 320s ### PostgreSQL test 042_upgrade_rename.t ### 320s 1..15 320s # PostgreSQL 17 323s ok 1 - pg_createcluster 17 main --start 329s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 329s ok 3 - pg_lsclusters -h 329s ok 4 - correct output of pg_lsclusters -h 330s ok 5 - pg_dropcluster 17 main --stop 332s ok 6 - pg_dropcluster 17 upgr --stop 332s ok 7 - Cleaning pg_upgrade log files 332s # Cleanup 332s ok 8 - Cleanup: No clusters left behind 332s ok 9 - No postgres processes left behind 332s ok 10 - No files in /etc/postgresql left behind 332s ok 11 - No files in /var/lib/postgresql left behind 332s ok 12 - No files in /var/run/postgresql left behind 332s ok 13 - No files in /var/log/postgresql left behind 332s ok 14 - PostgreSQL TCP ports are closed 332s ok 15 - Next free port is 5432 332s ### End test 042_upgrade_rename.t ### 332s 332s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 332s 1..1 332s ok 1 - only one major version installed, skipping upgrade tests 332s ### End test 043_upgrade_ssl_cert.t ### 332s 332s ### PostgreSQL test 045_backup.t ### 332s # We are running systemd 332s # PostgreSQL 17 332s # create cluster 336s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 336s ok 2 - pg_lsclusters -h 336s ok 3 - correct output of pg_lsclusters -h 336s ok 4 - pg_conftool 17 main set work_mem 11MB 336s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 336s ok 6 - psql -c 'alter database mydb set search_path=public' 336s ok 7 - psql -c 'create table foo (t text)' mydb 336s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 336s ok 9 - psql -c 'CREATE USER myuser' 336s ok 10 - psql -c 'grant create on database mydb to myuser' 336s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 336s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 336s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 336s # create directory 336s ok 14 - pg_backupcluster 17 main createdirectory 336s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 336s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 336s # dump 337s ok 17 - systemctl start pg_dump@17-main 337s ok 18 - dump created in /var/backups/postgresql/17-main/2025-05-06T184231Z.dump 337s ok 19 - /var/backups/postgresql/17-main/2025-05-06T184231Z.dump owned by uid postgres 337s ok 20 - /var/backups/postgresql/17-main/2025-05-06T184231Z.dump owned by gid postgres 337s # basebackup 337s ok 21 - systemctl start pg_receivewal@17-main 337s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 337s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 337s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 337s ok 25 - psql -c 'select pg_reload_conf()' 366s ok 26 - systemctl start pg_basebackup@17-main 366s ok 27 - dump created in /var/backups/postgresql/17-main/2025-05-06T184233Z.backup 366s ok 28 - /var/backups/postgresql/17-main/2025-05-06T184233Z.backup owned by uid postgres 366s ok 29 - /var/backups/postgresql/17-main/2025-05-06T184233Z.backup owned by gid postgres 366s # list 366s ok 30 - pg_backupcluster 17 main list 366s ok 31 - correct output of pg_backupcluster 17 main list 366s # more database changes 366s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 366s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 366s ok 34 - retrieve recovery timestamp 366s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 366s ok 36 - systemctl stop pg_receivewal@17-main 366s # restore /var/backups/postgresql/17-main/2025-05-06T184231Z.dump 368s ok 37 - pg_dropcluster 17 main --stop 373s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184231Z.dump --start --datadir /var/lib/postgresql/17/snowflake 373s ok 39 - pg_lsclusters -h 373s ok 40 - correct output of pg_lsclusters -h 373s ok 41 - psql -XAtl 373s ok 42 - mydb locales 373s ok 43 - mydb grants 373s ok 44 - myicudb locales 373s ok 45 - psql -XAtc 'show work_mem' 373s ok 46 - correct output of psql -XAtc 'show work_mem' 373s ok 47 - psql -XAtc 'select * from foo' mydb 373s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 373s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 373s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 373s ok 51 - psql -XAtc '\drds' 373s ok 52 - correct output of psql -XAtc '\drds' 373s # restore /var/backups/postgresql/17-main/2025-05-06T184233Z.backup 374s ok 53 - pg_dropcluster 17 main --stop 378s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184233Z.backup --start --datadir /var/lib/postgresql/17/snowflake 378s ok 55 - pg_lsclusters -h 378s ok 56 - correct output of pg_lsclusters -h 378s ok 57 - psql -XAtl 378s ok 58 - mydb locales 378s ok 59 - mydb grants 378s ok 60 - myicudb locales 378s ok 61 - psql -XAtc 'show work_mem' 378s ok 62 - correct output of psql -XAtc 'show work_mem' 378s ok 63 - psql -XAtc 'select * from foo' mydb 378s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 378s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 378s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 378s ok 67 - psql -XAtc '\drds' 378s ok 68 - correct output of psql -XAtc '\drds' 378s # restore /var/backups/postgresql/17-main/2025-05-06T184233Z.backup with WAL archive 380s ok 69 - pg_dropcluster 17 main --stop 384s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184233Z.backup --start --archive --port 5430 384s ok 71 - pg_lsclusters -h 384s ok 72 - correct output of pg_lsclusters -h 384s ok 73 - psql -XAtc 'select * from foo order by t' mydb 384s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 384s # restore /var/backups/postgresql/17-main/2025-05-06T184233Z.backup with PITR 386s ok 75 - pg_dropcluster 17 main --stop 389s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-05-06T184233Z.backup --start --pitr '2025-05-06 18:43:01.402536+00 389s # ' 389s ok 77 - pg_lsclusters -h 389s ok 78 - correct output of pg_lsclusters -h 389s ok 79 - psql -XAtc 'select * from foo order by t' mydb 389s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 391s ok 81 - pg_dropcluster 17 main --stop 391s # Cleanup 391s ok 82 - Cleanup: No clusters left behind 391s ok 83 - No postgres processes left behind 391s ok 84 - No files in /etc/postgresql left behind 391s ok 85 - No files in /var/lib/postgresql left behind 391s ok 86 - No files in /var/run/postgresql left behind 391s ok 87 - No files in /var/log/postgresql left behind 391s ok 88 - PostgreSQL TCP ports are closed 391s ok 89 - Next free port is 5432 391s 1..89 391s ### End test 045_backup.t ### 391s 391s ### PostgreSQL test 050_encodings.t ### 391s 1..60 391s # Checking 17 ru_RU 394s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 396s ok 2 - psql -l succeeds 396s ok 3 - template1 is not UTF-8 encoded 396s ok 4 - creating test database 396s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 396s # create table t (x varchar); copy t from stdin" test 396s ok 6 - creating table with ISO-8859-5 characters 396s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 396s ok 8 - correct string in UTF-8 396s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 396s ok 10 - correct string in ISO-8859-5 396s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 396s # delete from t; copy t from stdin" test 396s ok 12 - creating table with UTF-8 characters 396s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 396s ok 14 - correct string in UTF-8 396s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 396s ok 16 - correct string in ISO-8859-1 396s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 396s ok 18 - Server error message has correct language and encoding 398s ok 19 - pg_ctlcluster 17 ru_RU restart 398s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 400s ok 21 - Dropping cluster 400s # Checking 17 ru_RU.UTF-8 403s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 404s ok 23 - psql -l succeeds 404s ok 24 - template1 is UTF-8 encoded 404s ok 25 - creating test database 404s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 404s # create table t (x varchar); copy t from stdin" test 404s ok 27 - creating table with ISO-8859-5 characters 404s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 404s ok 29 - correct string in UTF-8 404s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 404s ok 31 - correct string in ISO-8859-5 405s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 405s # delete from t; copy t from stdin" test 405s ok 33 - creating table with UTF-8 characters 405s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 405s ok 35 - correct string in UTF-8 405s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 405s ok 37 - correct string in ISO-8859-1 405s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 405s ok 39 - Server error message has correct language and encoding 407s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 407s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 407s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 407s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 407s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 407s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 407s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 407s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 409s ok 48 - Dropping cluster 409s # Check 17 locale environment variables 412s ok 49 - pg_createcluster: LC_ALL dominates LANG 412s ok 50 - psql -Atl --cluster 17/main 412s ok 51 - template1 is ASCII encoded 414s ok 52 - Dropping cluster 414s # Cleanup 414s ok 53 - Cleanup: No clusters left behind 414s ok 54 - No postgres processes left behind 414s ok 55 - No files in /etc/postgresql left behind 414s ok 56 - No files in /var/lib/postgresql left behind 414s ok 57 - No files in /var/run/postgresql left behind 414s ok 58 - No files in /var/log/postgresql left behind 414s ok 59 - PostgreSQL TCP ports are closed 414s ok 60 - Next free port is 5432 414s ### End test 050_encodings.t ### 414s 414s ### PostgreSQL test 052_upgrade_encodings.t ### 414s 1..1 414s ok 1 - only one major version installed, skipping upgrade tests 414s ### End test 052_upgrade_encodings.t ### 414s 414s ### PostgreSQL test 060_obsolete_confparams.t ### 414s ok 1 - only one major version installed, skipping upgrade tests 414s 1..1 414s ### End test 060_obsolete_confparams.t ### 414s 414s ### PostgreSQL test 070_non_postgres_clusters.t ### 414s 1..40 415s ok 1 - pg_createcluster 17 main for owner nobody 415s ok 2 - pg_ctlcluster 17 main start 415s ok 3 - start refused when config and data owners mismatch 417s ok 4 - pg_ctlcluster succeeds with owner nobody 417s ok 5 - pg_lsclusters -h 417s ok 6 - pg_lsclusters shows running cluster 417s ok 7 - postgres is running as user nobody 417s ok 8 - ls /tmp/.s.PGSQL.* 417s ok 9 - socket is in /tmp 417s ok 10 - /var/run/postgresql is empty 417s ok 11 - conf dir is owned by user 417s ok 12 - conf dir is owned by user's primary group 417s ok 13 - files are owned by user 417s ok 14 - files are owned by user's primary group 417s ok 15 - log file has 0640 permissions 417s ok 16 - log file is owned by user 417s ok 17 - log file is owned by user's primary group 417s ok 18 - only one major version installed, skipping upgrade test 417s ok 19 - ... 417s ok 20 - ... 417s ok 21 - ... 417s ok 22 - ... 417s ok 23 - ... 417s ok 24 - ... 417s ok 25 - ... 417s ok 26 - ... 417s ok 27 - ... 417s ok 28 - ... 419s ok 29 - pg_dropcluster 419s ok 30 - pg_lsclusters -h 419s ok 31 - No clusters left 419s ok 32 - No postgres processes left 419s # Cleanup 419s ok 33 - Cleanup: No clusters left behind 419s ok 34 - No postgres processes left behind 419s ok 35 - No files in /etc/postgresql left behind 419s ok 36 - No files in /var/lib/postgresql left behind 419s ok 37 - No files in /var/run/postgresql left behind 419s ok 38 - No files in /var/log/postgresql left behind 419s ok 39 - PostgreSQL TCP ports are closed 419s ok 40 - Next free port is 5432 419s ### End test 070_non_postgres_clusters.t ### 419s 419s ### PostgreSQL test 080_start.conf.t ### 419s 1..73 420s ok 1 - pg_createcluster 17 main 420s # start.conf auto 420s ok 2 - get_cluster_start_conf returns auto 420s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 420s ok 4 - start.conf contains auto 420s ok 5 - systemd generator links cluster 420s ok 6 - systemd generator links correct service file 423s ok 7 - /etc/init.d/postgresql start 17 423s ok 8 - correct output of /etc/init.d/postgresql start 17 423s ok 9 - pg_lsclusters -h 423s ok 10 - cluster is online 423s ok 11 - /etc/init.d/postgresql stop 17 423s ok 12 - correct output of /etc/init.d/postgresql stop 17 426s ok 13 - pg_lsclusters -h 426s ok 14 - cluster is down 426s # start.conf manual 426s ok 15 - get_cluster_start_conf returns manual 426s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 426s ok 17 - start.conf contains manual 426s ok 18 - systemd generator doesn't link cluster 426s ok 19 - /etc/init.d/postgresql start 17 426s ok 20 - correct output of /etc/init.d/postgresql start 17 426s ok 21 - pg_lsclusters -h 426s ok 22 - cluster is down 428s ok 23 - pg_ctlcluster 17 main start 428s ok 24 - correct output of pg_ctlcluster 17 main start 428s ok 25 - pg_lsclusters -h 428s ok 26 - cluster is online 428s ok 27 - pg_ctlcluster 17 main stop 428s ok 28 - correct output of pg_ctlcluster 17 main stop 429s ok 29 - pg_lsclusters -h 429s ok 30 - cluster is down 429s # start.conf disabled 429s ok 31 - get_cluster_start_conf returns disabled 429s ok 32 - systemd generator doesn't link cluster 429s ok 33 - /etc/init.d/postgresql start 17 429s ok 34 - correct output of /etc/init.d/postgresql start 17 429s ok 35 - pg_lsclusters -h 429s ok 36 - cluster is down 429s ok 37 - pg_ctlcluster 17 main start 429s ok 38 - correct output of pg_ctlcluster 17 main start 429s ok 39 - pg_lsclusters -h 429s ok 40 - cluster is down 431s ok 41 - pg_ctlcluster 17 main start 431s ok 42 - correct output of pg_ctlcluster 17 main start 431s ok 43 - pg_lsclusters -h 431s ok 44 - cluster is online 431s ok 45 - pg_ctlcluster 17 main stop 431s ok 46 - correct output of pg_ctlcluster 17 main stop 431s ok 47 - pg_lsclusters -h 431s ok 48 - cluster is down 434s ok 49 - pg_ctlcluster 17 main start 434s ok 50 - correct output of pg_ctlcluster 17 main start 434s ok 51 - pg_lsclusters -h 434s ok 52 - cluster is online 434s # test upgrade 434s ok 53 - only one major version installed, skipping upgrade test 434s ok 54 - ... 434s ok 55 - get_cluster_start_conf for old cluster returns manual 434s ok 56 - get_cluster_start_conf for new cluster returns manual 434s ok 57 - ... 435s ok 58 - dropping upgraded cluster 435s ok 59 - pg_lsclusters -h 435s ok 60 - no clusters any more 435s ok 61 - pg_createcluster 17 main --start-conf foo 435s ok 62 - pg_createcluster checks --start-conf validity 436s ok 63 - pg_createcluster checks --start-conf manual 436s ok 64 - get_cluster_start_conf returns manual 437s ok 65 - dropping cluster 437s # Cleanup 437s ok 66 - Cleanup: No clusters left behind 437s ok 67 - No postgres processes left behind 437s ok 68 - No files in /etc/postgresql left behind 437s ok 69 - No files in /var/lib/postgresql left behind 437s ok 70 - No files in /var/run/postgresql left behind 437s ok 71 - No files in /var/log/postgresql left behind 437s ok 72 - PostgreSQL TCP ports are closed 437s ok 73 - Next free port is 5432 437s ### End test 080_start.conf.t ### 437s 437s ### PostgreSQL test 085_pg_ctl.conf.t ### 437s 1..33 437s ok 1 - prlimit --core=0:unlimited --pid=17120 437s ok 2 - set core file size to unlimited 437s ok 3 - sh -c 'ulimit -Hc' 437s ok 4 - core file size is unlimited 438s ok 5 - pg_createcluster 17 main 438s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 441s ok 7 - pg_ctlcluster 17 main start 441s ok 8 - starting cluster as root 441s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 441s ok 10 - soft core size is 0 441s # hard core file size limit of root-started postgres process is unlimited 441s ok 11 - set pg_ctl default option to -c 443s ok 12 - pg_ctlcluster 17 main restart 443s ok 13 - restarting cluster as root 443s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 443s ok 15 - soft core size is unlimited 443s ok 16 - pg_ctlcluster 17 main stop 443s ok 17 - stopping cluster 443s ok 18 - restored pg_ctl default option 445s ok 19 - pg_ctlcluster 17 main start -- -c 445s ok 20 - starting cluster with -c on the command line as postgres 445s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 445s ok 22 - soft core size is unlimited 446s ok 23 - pg_ctlcluster 17 main stop 446s ok 24 - stopping cluster 447s ok 25 - dropping cluster 447s # Cleanup 447s ok 26 - Cleanup: No clusters left behind 447s ok 27 - No postgres processes left behind 447s ok 28 - No files in /etc/postgresql left behind 447s ok 29 - No files in /var/lib/postgresql left behind 447s ok 30 - No files in /var/run/postgresql left behind 447s ok 31 - No files in /var/log/postgresql left behind 447s ok 32 - PostgreSQL TCP ports are closed 447s ok 33 - Next free port is 5432 447s ### End test 085_pg_ctl.conf.t ### 447s 447s ### PostgreSQL test 090_multicluster.t ### 447s 1..125 448s ok 1 - pg_createcluster 17 old 449s ok 2 - pg_createcluster 17 new1 450s ok 3 - pg_createcluster 17 new2 453s ok 4 - starting cluster 17/old 455s ok 5 - starting cluster 17/new1 457s ok 6 - starting cluster 17/new2 457s ok 7 - pg_lsclusters -h | sort -k3 457s ok 8 - clusters have the correct ports, skipping used 5433 457s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 457s ok 10 - createdb --version 457s ok 11 - pg_wrapper selects port 5432 as default cluster 457s ok 12 - createdb --cluster 17/new1 --version 457s ok 13 - pg_wrapper --cluster works 457s ok 14 - createdb --cluster 17/foo --version 457s ok 15 - pg_wrapper --cluster errors out for invalid cluster 457s ok 16 - createdb --cluster 17/new1 test 457s ok 17 - correct output of createdb --cluster 17/new1 test 457s ok 18 - psql -Atl --cluster 17/new1 457s ok 19 - test db appears in cluster new1 457s ok 20 - psql -Atl --cluster 17/new2 457s ok 21 - test db does not appear in cluster new2 457s ok 22 - psql -Atl 457s ok 23 - test db does not appear in default cluster 457s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 457s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 457s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 457s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 457s ok 28 - psql -Atl --cluster 17/localhost:5434 457s ok 29 - test db appears in cluster 17/localhost:5434 458s ok 30 - psql -Atl --cluster 17/localhost:5440 458s ok 31 - test db does not appear in cluster 17/localhost:5440 458s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 458s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 458s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 458s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 458s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 458s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 458s ok 38 - psql -Atl --cluster 6.4/localhost: 458s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 458s ok 40 - psql -Atl 458s ok 41 - PGCLUSTER selection (1) 458s ok 42 - psql -Atl 458s ok 43 - PGCLUSTER selection (2) 458s ok 44 - psql -l 458s ok 45 - invalid PGCLUSTER value 458s ok 46 - createdb --version 458s ok 47 - PGCLUSTER network cluster selection (1) 458s ok 48 - psql -Atl 458s ok 49 - PGCLUSTER network cluster selection (2) 458s ok 50 - psql -Atl 458s ok 51 - PGCLUSTER network cluster selection (3) 458s ok 52 - LC_MESSAGES=C psql -Atl 458s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 458s ok 54 - psql -Atc "show port" template1 458s ok 55 - PGPORT selection (1) 458s ok 56 - psql -Atc "show port" template1 458s ok 57 - PGPORT selection (2) 458s ok 58 - createdb --version 458s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 458s ok 60 - psql -Atc "show port" template1 458s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 458s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 458s ok 63 - PGDATABASE environment variable works 458s ok 64 - createdb --version 458s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 458s ok 66 - createdb --cluster 17/new1 --version 458s ok 67 - pg_wrapper --cluster works with empty user_clusters 458s ok 68 - createdb --version 458s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 458s ok 70 - psql -Atc "select current_database()" 458s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 458s ok 72 - psql -Atc 'select current_database()' 458s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 458s ok 74 - createdb --version 458s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 458s ok 76 - createdb --version 458s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 458s ok 78 - createdb --version 458s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 458s ok 80 - createdb --version 458s ok 81 - pg_wrapper selects correct version with per-user user_clusters 458s ok 82 - createdb --version 458s ok 83 - pg_wrapper selects correct version with per-user user_clusters 459s ok 84 - createdb --version 459s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 459s ok 86 - psql -Atl 459s ok 87 - $PGHOST overrides user_clusters 459s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 459s ok 89 - --cluster overrides $PGHOST 459s ok 90 - createdb --version 459s ok 91 - pg_wrapper ignores invalid lines in user_clusters 459s ok 92 - psql -Atc 'select current_database()' 459s ok 93 - pg_service conf selection 1 459s ok 94 - psql -Atc 'select current_database()' 459s ok 95 - pg_service conf selection 2 459s ok 96 - psql -Atc 'select current_database()' 459s ok 97 - pg_service conf selection 3 459s ok 98 - stopping cluster 17/old 461s ok 99 - restarting cluster 17/old 461s ok 100 - pg_lsclusters -h | sort -k3 461s ok 101 - port of first cluster was successfully changed 461s ok 102 - psql -l 461s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 461s ok 104 - psql -Atl --cluster 17/new1 461s ok 105 - --cluster selects appropriate cluster 461s ok 106 - psql -Atl -p 5434 461s ok 107 - -p selects appropriate cluster 462s ok 108 - psql -Atlp 5434 462s ok 109 - -Atlp selects appropriate cluster 462s ok 110 - psql -Atl --port 5434 462s ok 111 - --port selects appropriate cluster 462s ok 112 - env PGPORT=5434 psql -Atl 462s ok 113 - $PGPORT selects appropriate cluster 462s ok 114 - Restoring original /etc/postgresql-common/user_clusters 463s ok 115 - dropping 17/new1 465s ok 116 - dropping 17/new2 467s ok 117 - dropping 17/old 467s # Cleanup 467s ok 118 - Cleanup: No clusters left behind 467s ok 119 - No postgres processes left behind 467s ok 120 - No files in /etc/postgresql left behind 467s ok 121 - No files in /var/lib/postgresql left behind 467s ok 122 - No files in /var/run/postgresql left behind 467s ok 123 - No files in /var/log/postgresql left behind 467s ok 124 - PostgreSQL TCP ports are closed 467s ok 125 - Next free port is 5432 467s ### End test 090_multicluster.t ### 467s 467s ### PostgreSQL test 110_integrate_cluster.t ### 467s 1..32 468s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/fg5Vg76Fwb/c/postgres 468s ok 2 - creating raw initdb cluster for user postgres 468s ok 3 - pg_createcluster 17 postgres -d /tmp/fg5Vg76Fwb/c/postgres 468s ok 4 - integrating postgres cluster 468s ok 5 - pg_lsclusters 468s ok 6 - correct pg_lsclusters output 470s ok 7 - pg_ctlcluster 17 postgres start 470s ok 8 - starting cluster postgres 470s ok 9 - pg_lsclusters 470s ok 10 - correct pg_lsclusters output 472s ok 11 - dropping cluster postgres 472s ok 12 - No files in temporary cluster dir left behind 473s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/fg5Vg76Fwb/c/nobody 473s ok 14 - creating raw initdb cluster for user nobody 473s ok 15 - pg_createcluster 17 nobody -d /tmp/fg5Vg76Fwb/c/nobody 473s ok 16 - integrating nobody cluster 473s ok 17 - pg_lsclusters 473s ok 18 - correct pg_lsclusters output 475s ok 19 - pg_ctlcluster 17 nobody start 475s ok 20 - starting cluster nobody 475s ok 21 - pg_lsclusters 475s ok 22 - correct pg_lsclusters output 477s ok 23 - dropping cluster nobody 477s ok 24 - No files in temporary cluster dir left behind 477s # Cleanup 477s ok 25 - Cleanup: No clusters left behind 477s ok 26 - No postgres processes left behind 477s ok 27 - No files in /etc/postgresql left behind 477s ok 28 - No files in /var/lib/postgresql left behind 477s ok 29 - No files in /var/run/postgresql left behind 477s ok 30 - No files in /var/log/postgresql left behind 477s ok 31 - PostgreSQL TCP ports are closed 477s ok 32 - Next free port is 5432 477s ### End test 110_integrate_cluster.t ### 477s 477s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 477s 1..1 477s ok 1 - only one major version installed, skipping upgrade tests 477s ### End test 120_pg_upgradecluster_scripts.t ### 477s 477s ### PostgreSQL test 130_nonroot_admin.t ### 477s 1..22 480s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 480s ok 2 - pg_lsclusters -h 480s ok 3 - correct output of pg_lsclusters -h 480s ok 4 - psql -Atl 480s ok 5 - correct output of psql -Atl 480s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 480s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 480s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 480s # Cleanup 481s ok 15 - Cleanup: No clusters left behind 481s ok 16 - No postgres processes left behind 481s ok 17 - No files in /etc/postgresql left behind 481s ok 18 - No files in /var/lib/postgresql left behind 481s ok 19 - No files in /var/run/postgresql left behind 481s ok 20 - No files in /var/log/postgresql left behind 481s ok 21 - PostgreSQL TCP ports are closed 481s ok 22 - Next free port is 5432 481s ### End test 130_nonroot_admin.t ### 481s 481s ### PostgreSQL test 135_pg_virtualenv.t ### 481s 1..20 486s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 486s ok 2 - running pg_virtualenv as root 489s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 489s ok 4 - running pg_virtualenv as postgres 492s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 492s ok 6 - running pg_virtualenv as nobody 495s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 495s ok 8 - running fakeroot pg_virtualenv as root 498s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 498s ok 10 - running fakeroot pg_virtualenv as postgres 502s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 502s ok 12 - running fakeroot pg_virtualenv as nobody 502s # Cleanup 502s ok 13 - Cleanup: No clusters left behind 502s ok 14 - No postgres processes left behind 502s ok 15 - No files in /etc/postgresql left behind 502s ok 16 - No files in /var/lib/postgresql left behind 502s ok 17 - No files in /var/run/postgresql left behind 502s ok 18 - No files in /var/log/postgresql left behind 502s ok 19 - PostgreSQL TCP ports are closed 502s ok 20 - Next free port is 5432 502s ### End test 135_pg_virtualenv.t ### 502s 502s ### PostgreSQL test 140_pg_config.t ### 502s 1..38 502s # Multiarch is enabled 502s # checking version specific output for 17 502s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 502s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 502s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 502s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 502s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 502s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 502s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 502s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 502s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 502s # checking pg_config output (should behave like version 17) 502s ok 15 - pg_config 502s ok 16 - correct output of pg_config 502s ok 17 - pg_config --help 502s ok 18 - correct output of pg_config --help 502s ok 19 - pg_config --pgxs 502s ok 20 - correct output of pg_config --pgxs 502s ok 21 - pg_config --libdir 502s ok 22 - correct output of pg_config --libdir 502s ok 23 - pg_config --pkglibdir 502s ok 24 - correct output of pg_config --pkglibdir 502s ok 25 - pg_config --bindir 502s ok 26 - correct output of pg_config --bindir 502s # checking pg_config.libpq-dev output (should behave like version 17) 502s ok 27 - pg_config.libpq-dev 502s ok 28 - correct output of pg_config.libpq-dev 502s ok 29 - pg_config.libpq-dev --help 502s ok 30 - correct output of pg_config.libpq-dev --help 502s ok 31 - pg_config.libpq-dev --pgxs 502s ok 32 - correct output of pg_config.libpq-dev --pgxs 502s ok 33 - pg_config.libpq-dev --libdir 502s ok 34 - correct output of pg_config.libpq-dev --libdir 502s ok 35 - pg_config.libpq-dev --pkglibdir 502s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 502s ok 37 - pg_config.libpq-dev --bindir 502s ok 38 - correct output of pg_config.libpq-dev --bindir 502s ### End test 140_pg_config.t ### 502s 502s ### PostgreSQL test 150_tsearch_stemming.t ### 502s 1..37 502s ok 1 - pg_updatedicts succeeded 502s ok 2 - pg_updatedicts created en_us.affix 502s ok 3 - pg_updatedicts created en_us.dict 502s ok 4 - pg_updatedicts created 17 en_us.affix symlink 502s ok 5 - pg_updatedicts created 17 en_us.dict symlink 505s ok 6 - pg_createcluster 17 main 505s ok 7 - createdb fts 505s ok 8 - correct output of createdb fts 506s ok 9 - creating en_US full text search configuration 506s ok 10 - creating data table and search index 506s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 506s ok 12 - stem search of correct word 506s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 506s ok 14 - stem search of correct word 506s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 506s ok 16 - stem search of unknown word 506s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 506s ok 18 - full text search, exact word 506s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 506s ok 20 - full text search for word stem 506s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 506s ok 22 - full text search for word substring fails 506s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 506s ok 24 - full text search, exact unicode word 506s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 506s ok 26 - full text search for unicode word stem 506s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 506s ok 28 - full text search for unicode word substring fails 508s ok 29 508s # Cleanup 508s ok 30 - Cleanup: No clusters left behind 508s ok 31 - No postgres processes left behind 508s ok 32 - No files in /etc/postgresql left behind 508s ok 33 - No files in /var/lib/postgresql left behind 508s ok 34 - No files in /var/run/postgresql left behind 508s ok 35 - No files in /var/log/postgresql left behind 508s ok 36 - PostgreSQL TCP ports are closed 508s ok 37 - Next free port is 5432 508s ### End test 150_tsearch_stemming.t ### 508s 508s ### PostgreSQL test 160_alternate_confroot.t ### 508s 1..28 511s ok 1 511s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 511s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 511s ok 4 - pg_lsclusters -h 511s ok 5 - correct output of pg_lsclusters -h 511s ok 6 - psql -Atl 511s ok 7 - correct output of psql -Atl 511s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 511s ok 9 - ... 511s ok 10 - ... 511s ok 11 - ... 511s ok 12 - ... 511s ok 13 - ... 511s ok 14 - ... 512s ok 15 - pg_dropcluster 17 test --stop 512s ok 16 - correct output of pg_dropcluster 17 test --stop 512s ok 17 - pg_lsclusters -h 512s ok 18 - correct output of pg_lsclusters -h 512s ok 19 - No files in root/data left behind 512s ok 20 - No cruft in root dir left behind 512s # Cleanup 512s ok 21 - Cleanup: No clusters left behind 512s ok 22 - No postgres processes left behind 512s ok 23 - No files in /etc/postgresql left behind 512s ok 24 - No files in /var/lib/postgresql left behind 512s ok 25 - No files in /var/run/postgresql left behind 512s ok 26 - No files in /var/log/postgresql left behind 512s ok 27 - PostgreSQL TCP ports are closed 512s ok 28 - Next free port is 5432 512s ### End test 160_alternate_confroot.t ### 512s 512s ### PostgreSQL test 170_extensions.t ### 512s # Running tests for 17 515s ok 1 - pg_createcluster 17 main 515s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 515s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 515s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 515s ok 5 - extension amcheck installs without error 515s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 515s ok 7 - extension amcheck removes without error 515s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 515s ok 9 - extension autoinc installs without error 515s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 515s ok 11 - extension autoinc removes without error 515s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 515s ok 13 - extension bloom installs without error 515s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 515s ok 15 - extension bloom removes without error 515s ok 16 - psql -qc 'CREATE EXTENSION plperl' 515s ok 17 - bool_plperl dependency plperl installs without error 515s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 515s ok 19 - extension bool_plperl installs without error 515s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 515s ok 21 - extension bool_plperl removes without error 515s ok 22 - psql -qc 'DROP EXTENSION plperl' 515s ok 23 - bool_plperl dependency extension plperl removes without error 516s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 516s ok 25 - bool_plperlu dependency plperlu installs without error 516s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 516s ok 27 - extension bool_plperlu installs without error 516s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 516s ok 29 - extension bool_plperlu removes without error 516s ok 30 - psql -qc 'DROP EXTENSION plperlu' 516s ok 31 - bool_plperlu dependency extension plperlu removes without error 516s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 516s ok 33 - extension btree_gin installs without error 516s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 516s ok 35 - extension btree_gin removes without error 516s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 516s ok 37 - extension btree_gist installs without error 516s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 516s ok 39 - extension btree_gist removes without error 516s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 516s ok 41 - extension citext installs without error 516s ok 42 - psql -qc 'DROP EXTENSION "citext"' 516s ok 43 - extension citext removes without error 516s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 516s ok 45 - extension cube installs without error 516s ok 46 - psql -qc 'DROP EXTENSION "cube"' 516s ok 47 - extension cube removes without error 516s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 516s ok 49 - extension dblink installs without error 516s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 516s ok 51 - extension dblink removes without error 516s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 516s ok 53 - extension dict_int installs without error 516s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 516s ok 55 - extension dict_int removes without error 516s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 516s ok 57 - extension dict_xsyn installs without error 516s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 516s ok 59 - extension dict_xsyn removes without error 516s ok 60 - psql -qc 'CREATE EXTENSION cube' 516s ok 61 - earthdistance dependency cube installs without error 516s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 516s ok 63 - extension earthdistance installs without error 516s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 516s ok 65 - extension earthdistance removes without error 517s ok 66 - psql -qc 'DROP EXTENSION cube' 517s ok 67 - earthdistance dependency extension cube removes without error 517s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 517s ok 69 - extension file_fdw installs without error 517s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 517s ok 71 - extension file_fdw removes without error 517s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 517s ok 73 - extension fuzzystrmatch installs without error 517s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 517s ok 75 - extension fuzzystrmatch removes without error 517s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 517s ok 77 - extension hstore installs without error 517s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 517s ok 79 - extension hstore removes without error 517s ok 80 - psql -qc 'CREATE EXTENSION hstore' 517s ok 81 - hstore_plperl dependency hstore installs without error 517s ok 82 - psql -qc 'CREATE EXTENSION plperl' 517s ok 83 - hstore_plperl dependency plperl installs without error 517s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 517s ok 85 - extension hstore_plperl installs without error 517s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 517s ok 87 - extension hstore_plperl removes without error 517s ok 88 - psql -qc 'DROP EXTENSION hstore' 517s ok 89 - hstore_plperl dependency extension hstore removes without error 517s ok 90 - psql -qc 'DROP EXTENSION plperl' 517s ok 91 - hstore_plperl dependency extension plperl removes without error 517s ok 92 - psql -qc 'CREATE EXTENSION hstore' 517s ok 93 - hstore_plperlu dependency hstore installs without error 517s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 517s ok 95 - hstore_plperlu dependency plperlu installs without error 517s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 517s ok 97 - extension hstore_plperlu installs without error 517s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 517s ok 99 - extension hstore_plperlu removes without error 517s ok 100 - psql -qc 'DROP EXTENSION hstore' 517s ok 101 - hstore_plperlu dependency extension hstore removes without error 517s ok 102 - psql -qc 'DROP EXTENSION plperlu' 517s ok 103 - hstore_plperlu dependency extension plperlu removes without error 517s ok 104 - psql -qc 'CREATE EXTENSION hstore' 517s ok 105 - hstore_plpython3u dependency hstore installs without error 517s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 517s ok 107 - hstore_plpython3u dependency plpython3u installs without error 517s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 517s ok 109 - extension hstore_plpython3u installs without error 517s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 517s ok 111 - extension hstore_plpython3u removes without error 518s ok 112 - psql -qc 'DROP EXTENSION hstore' 518s ok 113 - hstore_plpython3u dependency extension hstore removes without error 518s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 518s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 518s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 518s ok 117 - extension insert_username installs without error 518s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 518s ok 119 - extension insert_username removes without error 518s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 518s ok 121 - extension intagg installs without error 518s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 518s ok 123 - extension intagg removes without error 518s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 518s ok 125 - extension intarray installs without error 518s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 518s ok 127 - extension intarray removes without error 518s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 518s ok 129 - extension isn installs without error 518s ok 130 - psql -qc 'DROP EXTENSION "isn"' 518s ok 131 - extension isn removes without error 518s ok 132 - psql -qc 'CREATE EXTENSION plperl' 518s ok 133 - jsonb_plperl dependency plperl installs without error 518s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 518s ok 135 - extension jsonb_plperl installs without error 518s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 518s ok 137 - extension jsonb_plperl removes without error 518s ok 138 - psql -qc 'DROP EXTENSION plperl' 518s ok 139 - jsonb_plperl dependency extension plperl removes without error 518s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 518s ok 141 - jsonb_plperlu dependency plperlu installs without error 518s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 518s ok 143 - extension jsonb_plperlu installs without error 518s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 518s ok 145 - extension jsonb_plperlu removes without error 518s ok 146 - psql -qc 'DROP EXTENSION plperlu' 518s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 518s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 518s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 518s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 518s ok 151 - extension jsonb_plpython3u installs without error 518s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 518s ok 153 - extension jsonb_plpython3u removes without error 518s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 518s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 519s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 519s ok 157 - extension lo installs without error 519s ok 158 - psql -qc 'DROP EXTENSION "lo"' 519s ok 159 - extension lo removes without error 519s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 519s ok 161 - extension ltree installs without error 519s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 519s ok 163 - extension ltree removes without error 519s ok 164 - psql -qc 'CREATE EXTENSION ltree' 519s ok 165 - ltree_plpython3u dependency ltree installs without error 519s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 519s ok 167 - ltree_plpython3u dependency plpython3u installs without error 519s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 519s ok 169 - extension ltree_plpython3u installs without error 519s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 519s ok 171 - extension ltree_plpython3u removes without error 519s ok 172 - psql -qc 'DROP EXTENSION ltree' 519s ok 173 - ltree_plpython3u dependency extension ltree removes without error 519s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 519s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 519s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 519s ok 177 - extension moddatetime installs without error 519s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 519s ok 179 - extension moddatetime removes without error 519s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 519s ok 181 - extension pageinspect installs without error 519s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 519s ok 183 - extension pageinspect removes without error 519s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 519s ok 185 - extension pg_buffercache installs without error 519s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 519s ok 187 - extension pg_buffercache removes without error 519s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 519s ok 189 - extension pg_freespacemap installs without error 519s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 519s ok 191 - extension pg_freespacemap removes without error 519s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 519s ok 193 - extension pg_prewarm installs without error 519s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 519s ok 195 - extension pg_prewarm removes without error 519s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 519s ok 197 - extension pg_stat_statements installs without error 519s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 519s ok 199 - extension pg_stat_statements removes without error 520s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 520s ok 201 - extension pg_surgery installs without error 520s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 520s ok 203 - extension pg_surgery removes without error 520s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 520s ok 205 - extension pg_trgm installs without error 520s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 520s ok 207 - extension pg_trgm removes without error 520s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 520s ok 209 - extension pg_visibility installs without error 520s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 520s ok 211 - extension pg_visibility removes without error 520s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 520s ok 213 - extension pg_walinspect installs without error 520s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 520s ok 215 - extension pg_walinspect removes without error 520s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 520s ok 217 - extension pgcrypto installs without error 520s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 520s ok 219 - extension pgcrypto removes without error 520s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 520s ok 221 - extension pgrowlocks installs without error 520s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 520s ok 223 - extension pgrowlocks removes without error 520s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 520s ok 225 - extension pgstattuple installs without error 520s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 520s ok 227 - extension pgstattuple removes without error 520s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 520s ok 229 - extension plperl installs without error 520s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 520s ok 231 - extension plperl removes without error 520s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 520s ok 233 - extension plperlu installs without error 520s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 520s ok 235 - extension plperlu removes without error 520s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 520s ok 237 - extension plpython3u installs without error 520s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 520s ok 239 - extension plpython3u removes without error 520s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 520s ok 241 - extension pltcl installs without error 520s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 520s ok 243 - extension pltcl removes without error 520s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 520s ok 245 - extension pltclu installs without error 520s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 520s ok 247 - extension pltclu removes without error 520s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 520s ok 249 - extension postgres_fdw installs without error 521s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 521s ok 251 - extension postgres_fdw removes without error 521s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 521s ok 253 - extension refint installs without error 521s ok 254 - psql -qc 'DROP EXTENSION "refint"' 521s ok 255 - extension refint removes without error 521s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 521s ok 257 - extension seg installs without error 521s ok 258 - psql -qc 'DROP EXTENSION "seg"' 521s ok 259 - extension seg removes without error 521s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 521s ok 261 - extension sslinfo installs without error 521s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 521s ok 263 - extension sslinfo removes without error 521s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 521s ok 265 - extension tablefunc installs without error 521s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 521s ok 267 - extension tablefunc removes without error 521s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 521s ok 269 - extension tcn installs without error 521s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 521s ok 271 - extension tcn removes without error 521s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 521s ok 273 - extension tsm_system_rows installs without error 521s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 521s ok 275 - extension tsm_system_rows removes without error 521s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 521s ok 277 - extension tsm_system_time installs without error 521s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 521s ok 279 - extension tsm_system_time removes without error 521s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 521s ok 281 - extension unaccent installs without error 521s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 521s ok 283 - extension unaccent removes without error 521s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 521s ok 285 - extension uuid-ossp installs without error 521s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 521s ok 287 - extension uuid-ossp removes without error 521s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 521s ok 289 - extension xml2 installs without error 521s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 521s ok 291 - extension xml2 removes without error 523s ok 292 - pg_dropcluster 17 main 523s # Cleanup 523s ok 293 - Cleanup: No clusters left behind 523s ok 294 - No postgres processes left behind 523s ok 295 - No files in /etc/postgresql left behind 523s ok 296 - No files in /var/lib/postgresql left behind 523s ok 297 - No files in /var/run/postgresql left behind 523s ok 298 - No files in /var/log/postgresql left behind 523s ok 299 - PostgreSQL TCP ports are closed 523s ok 300 - Next free port is 5432 523s 1..300 523s ### End test 170_extensions.t ### 523s 523s ### PostgreSQL test 180_ecpg.t ### 523s 1..14 523s ok 1 - ecpg test.pgc 523s ok 2 - ecpg processing 523s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 523s ok 4 - compiling ecpg output 531s ok 5 - pg_virtualenv /tmp/tmp.ldryrK2TNA/test 531s ok 6 - test program runs and gives correct output 531s # Cleanup 531s ok 7 - Cleanup: No clusters left behind 531s ok 8 - No postgres processes left behind 531s ok 9 - No files in /etc/postgresql left behind 531s ok 10 - No files in /var/lib/postgresql left behind 531s ok 11 - No files in /var/run/postgresql left behind 531s ok 12 - No files in /var/log/postgresql left behind 531s ok 13 - PostgreSQL TCP ports are closed 531s ok 14 - Next free port is 5432 531s ### End test 180_ecpg.t ### 531s 531s ### PostgreSQL test 190_pg_buildext.t ### 531s ok 1 - Skipping pg_buildext tests, postgresql-server-dev-all is not installed 531s 1..1 531s ### End test 190_pg_buildext.t ### 531s 531s ### PostgreSQL test 200_maintscripts.t ### 531s 1..15 531s # We are running systemd 534s ok 1 - pg_createcluster 17 main --start 534s ok 2 - postmaster PID is 22197 535s ok 3 - apt-get update -q 535s # postgresql-common: 535s # Installed: 274 535s # Candidate: 274 535s # Version table: 535s # *** 274 500 535s # 500 http://ftpmaster.internal/ubuntu plucky/main ppc64el Packages 535s # 100 /var/lib/dpkg/status 539s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 539s # postgresql-common: 539s # Installed: 274 539s # Candidate: 274 539s # Version table: 539s # *** 274 500 539s # 500 http://ftpmaster.internal/ubuntu plucky/main ppc64el Packages 539s # 100 /var/lib/dpkg/status 539s ok 5 - postmaster PID is 22197 539s ok 6 - postmaster was not restarted 540s ok 7 - pg_dropcluster 17 main --stop 540s # Cleanup 541s ok 8 - Cleanup: No clusters left behind 541s ok 9 - No postgres processes left behind 541s ok 10 - No files in /etc/postgresql left behind 541s ok 11 - No files in /var/lib/postgresql left behind 541s ok 12 - No files in /var/run/postgresql left behind 541s ok 13 - No files in /var/log/postgresql left behind 541s ok 14 - PostgreSQL TCP ports are closed 541s ok 15 - Next free port is 5432 541s ### End test 200_maintscripts.t ### 541s 541s autopkgtest [18:45:56]: test run-testsuite: -----------------------] 542s run-testsuite PASS 542s autopkgtest [18:45:57]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 542s autopkgtest [18:45:57]: test installcheck: preparing testbed 626s autopkgtest [18:47:21]: testbed dpkg architecture: ppc64el 627s autopkgtest [18:47:22]: testbed apt version: 3.0.0 627s autopkgtest [18:47:22]: @@@@@@@@@@@@@@@@@@@@ test bed setup 627s autopkgtest [18:47:22]: testbed release detected to be: plucky 628s autopkgtest [18:47:23]: updating testbed package index (apt update) 628s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [265 kB] 629s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 629s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 629s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 629s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [5196 B] 629s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [5796 B] 629s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el c-n-f Metadata [288 B] 629s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el c-n-f Metadata [120 B] 629s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [20.3 kB] 629s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el c-n-f Metadata [8688 B] 629s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el c-n-f Metadata [172 B] 631s Fetched 306 kB in 1s (446 kB/s) 631s Reading package lists... 632s autopkgtest [18:47:27]: upgrading testbed (apt dist-upgrade and autopurge) 632s Reading package lists... 632s Building dependency tree... 632s Reading state information... 632s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 632s Starting 2 pkgProblemResolver with broken count: 0 632s Done 633s Entering ResolveByKeep 633s 633s Calculating upgrade... 633s The following packages will be upgraded: 633s tzdata 633s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 633s Need to get 198 kB of archives. 633s After this operation, 0 B of additional disk space will be used. 633s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el tzdata all 2025b-1ubuntu1.1 [198 kB] 634s Preconfiguring packages ... 634s Fetched 198 kB in 0s (556 kB/s) 634s (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 ... 78698 files and directories currently installed.) 634s Preparing to unpack .../tzdata_2025b-1ubuntu1.1_all.deb ... 634s Unpacking tzdata (2025b-1ubuntu1.1) over (2025b-1ubuntu1) ... 634s Setting up tzdata (2025b-1ubuntu1.1) ... 635s 635s Current default time zone: 'Etc/UTC' 635s Local time is now: Tue May 6 18:47:30 UTC 2025. 635s Universal Time is now: Tue May 6 18:47:30 UTC 2025. 635s Run 'dpkg-reconfigure tzdata' if you wish to change it. 635s 635s Reading package lists... 635s Building dependency tree... 635s Reading state information... 635s Starting pkgProblemResolver with broken count: 0 635s Starting 2 pkgProblemResolver with broken count: 0 635s Done 635s Solving dependencies... 636s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 638s Reading package lists... 638s Building dependency tree... 638s Reading state information... 638s Starting pkgProblemResolver with broken count: 0 638s Starting 2 pkgProblemResolver with broken count: 0 638s Done 639s The following NEW packages will be installed: 639s binutils-gold binutils-gold-powerpc64le-linux-gnu build-essential clang-20 639s cpp cpp-14 cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu g++ g++-14 639s g++-14-powerpc64le-linux-gnu g++-powerpc64le-linux-gnu gcc gcc-14 639s gcc-14-powerpc64le-linux-gnu gcc-powerpc64le-linux-gnu libasan8 libcc1-0 639s libclang-common-20-dev libclang-cpp20 libclang1-20 libffi-dev libgc1 639s libgcc-14-dev libgomp1 libio-pty-perl libipc-run-perl libisl23 libitm1 639s libjson-perl libllvm20 liblsan0 libmpc3 libncurses-dev libobjc-14-dev 639s libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev 639s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-20 llvm-20-dev 639s llvm-20-linker-tools llvm-20-runtime llvm-20-tools postgresql-17 639s postgresql-client-17 postgresql-client-common postgresql-common 639s postgresql-common-dev postgresql-server-dev-17 ssl-cert tzdata-legacy 639s 0 upgraded, 59 newly installed, 0 to remove and 0 not upgraded. 639s Need to get 217 MB of archives. 639s After this operation, 1120 MB of additional disk space will be used. 639s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 639s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 274 [47.6 kB] 639s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 639s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 639s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 274 [73.0 kB] 639s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 639s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 274 [101 kB] 639s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-gold-powerpc64le-linux-gnu ppc64el 2.44-2 [1638 kB] 640s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-gold ppc64el 2.44-2 [2176 B] 640s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 640s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 640s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [10.5 MB] 641s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14 ppc64el 14.2.0-19ubuntu2 [1036 B] 641s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [5566 B] 641s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp ppc64el 4:14.2.0-1ubuntu1 [22.4 kB] 641s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcc1-0 ppc64el 15-20250404-0ubuntu1 [48.6 kB] 641s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgomp1 ppc64el 15-20250404-0ubuntu1 [168 kB] 641s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el libitm1 ppc64el 15-20250404-0ubuntu1 [32.3 kB] 641s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el libasan8 ppc64el 15-20250404-0ubuntu1 [3007 kB] 641s Get:20 http://ftpmaster.internal/ubuntu plucky/main ppc64el liblsan0 ppc64el 15-20250404-0ubuntu1 [1374 kB] 641s Get:21 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtsan2 ppc64el 15-20250404-0ubuntu1 [2732 kB] 641s Get:22 http://ftpmaster.internal/ubuntu plucky/main ppc64el libubsan1 ppc64el 15-20250404-0ubuntu1 [1232 kB] 642s Get:23 http://ftpmaster.internal/ubuntu plucky/main ppc64el libquadmath0 ppc64el 15-20250404-0ubuntu1 [160 kB] 642s Get:24 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgcc-14-dev ppc64el 14.2.0-19ubuntu2 [1618 kB] 642s Get:25 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [20.6 MB] 642s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14 ppc64el 14.2.0-19ubuntu2 [540 kB] 642s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [1226 B] 642s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc ppc64el 4:14.2.0-1ubuntu1 [5012 B] 642s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el libstdc++-14-dev ppc64el 14.2.0-19ubuntu2 [2679 kB] 642s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-19ubuntu2 [12.0 MB] 643s Get:31 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14 ppc64el 14.2.0-19ubuntu2 [23.0 kB] 643s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.2.0-1ubuntu1 [966 B] 643s Get:33 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++ ppc64el 4:14.2.0-1ubuntu1 [1088 B] 643s Get:34 http://ftpmaster.internal/ubuntu plucky/main ppc64el build-essential ppc64el 12.12ubuntu1 [5094 B] 643s Get:35 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.2-0ubuntu1 [32.0 MB] 644s Get:36 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-cpp20 ppc64el 1:20.1.2-0ubuntu1 [15.0 MB] 644s Get:37 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 644s Get:38 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc4 ppc64el 15-20250404-0ubuntu1 [53.6 kB] 644s Get:39 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc-14-dev ppc64el 14.2.0-19ubuntu2 [202 kB] 644s Get:40 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-common-20-dev ppc64el 1:20.1.2-0ubuntu1 [782 kB] 644s Get:41 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-linker-tools ppc64el 1:20.1.2-0ubuntu1 [1405 kB] 644s Get:42 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang1-20 ppc64el 1:20.1.2-0ubuntu1 [9064 kB] 644s Get:43 http://ftpmaster.internal/ubuntu plucky/universe ppc64el clang-20 ppc64el 1:20.1.2-0ubuntu1 [80.9 kB] 644s Get:44 http://ftpmaster.internal/ubuntu plucky/main ppc64el libncurses-dev ppc64el 6.5+20250216-2 [484 kB] 644s Get:45 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 644s Get:46 http://ftpmaster.internal/ubuntu plucky/main ppc64el libssl-dev ppc64el 3.4.1-1ubuntu3 [3140 kB] 645s Get:47 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq-dev ppc64el 17.4-1 [177 kB] 645s Get:48 http://ftpmaster.internal/ubuntu plucky-updates/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg+really2.9.14-0.4ubuntu0.1 [916 kB] 645s Get:49 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu4 [191 kB] 645s Get:50 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-runtime ppc64el 1:20.1.2-0ubuntu1 [601 kB] 645s Get:51 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 645s Get:52 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20 ppc64el 1:20.1.2-0ubuntu1 [21.5 MB] 645s Get:53 http://ftpmaster.internal/ubuntu plucky/main ppc64el libffi-dev ppc64el 3.4.7-1 [67.7 kB] 645s Get:54 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-tools ppc64el 1:20.1.2-0ubuntu1 [600 kB] 645s Get:55 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-20-dev ppc64el 1:20.1.2-0ubuntu1 [50.8 MB] 647s Get:56 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 647s Get:57 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 647s Get:58 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-17 ppc64el 17.4-1 [1440 kB] 647s Get:59 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el tzdata-legacy all 2025b-1ubuntu1.1 [99.2 kB] 647s Preconfiguring packages ... 647s Fetched 217 MB in 9s (25.5 MB/s) 648s Selecting previously unselected package libjson-perl. 648s (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 ... 78698 files and directories currently installed.) 648s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 648s Unpacking libjson-perl (4.10000-1) ... 648s Selecting previously unselected package postgresql-client-common. 648s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 648s Unpacking postgresql-client-common (274) ... 648s Selecting previously unselected package libio-pty-perl. 648s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 648s Unpacking libio-pty-perl (1:1.20-1build3) ... 648s Selecting previously unselected package libipc-run-perl. 648s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 648s Unpacking libipc-run-perl (20231003.0-2) ... 648s Selecting previously unselected package postgresql-common-dev. 648s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 648s Unpacking postgresql-common-dev (274) ... 648s Selecting previously unselected package ssl-cert. 648s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 648s Unpacking ssl-cert (1.1.3ubuntu1) ... 648s Selecting previously unselected package postgresql-common. 648s Preparing to unpack .../06-postgresql-common_274_all.deb ... 648s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 648s Unpacking postgresql-common (274) ... 648s Selecting previously unselected package binutils-gold-powerpc64le-linux-gnu. 648s Preparing to unpack .../07-binutils-gold-powerpc64le-linux-gnu_2.44-2_ppc64el.deb ... 648s Unpacking binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 648s Selecting previously unselected package binutils-gold. 648s Preparing to unpack .../08-binutils-gold_2.44-2_ppc64el.deb ... 648s Unpacking binutils-gold (2.44-2) ... 648s Selecting previously unselected package libisl23:ppc64el. 648s Preparing to unpack .../09-libisl23_0.27-1_ppc64el.deb ... 648s Unpacking libisl23:ppc64el (0.27-1) ... 648s Selecting previously unselected package libmpc3:ppc64el. 648s Preparing to unpack .../10-libmpc3_1.3.1-1build2_ppc64el.deb ... 648s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 648s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 648s Preparing to unpack .../11-cpp-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 648s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 648s Selecting previously unselected package cpp-14. 648s Preparing to unpack .../12-cpp-14_14.2.0-19ubuntu2_ppc64el.deb ... 648s Unpacking cpp-14 (14.2.0-19ubuntu2) ... 648s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 648s Preparing to unpack .../13-cpp-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 648s Unpacking cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 648s Selecting previously unselected package cpp. 648s Preparing to unpack .../14-cpp_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 648s Unpacking cpp (4:14.2.0-1ubuntu1) ... 648s Selecting previously unselected package libcc1-0:ppc64el. 648s Preparing to unpack .../15-libcc1-0_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libgomp1:ppc64el. 648s Preparing to unpack .../16-libgomp1_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libgomp1:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libitm1:ppc64el. 648s Preparing to unpack .../17-libitm1_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libitm1:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libasan8:ppc64el. 648s Preparing to unpack .../18-libasan8_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libasan8:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package liblsan0:ppc64el. 648s Preparing to unpack .../19-liblsan0_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking liblsan0:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libtsan2:ppc64el. 648s Preparing to unpack .../20-libtsan2_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libtsan2:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libubsan1:ppc64el. 648s Preparing to unpack .../21-libubsan1_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libubsan1:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libquadmath0:ppc64el. 648s Preparing to unpack .../22-libquadmath0_15-20250404-0ubuntu1_ppc64el.deb ... 648s Unpacking libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 648s Selecting previously unselected package libgcc-14-dev:ppc64el. 648s Preparing to unpack .../23-libgcc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 648s Unpacking libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 648s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 648s Preparing to unpack .../24-gcc-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 648s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 649s Selecting previously unselected package gcc-14. 649s Preparing to unpack .../25-gcc-14_14.2.0-19ubuntu2_ppc64el.deb ... 649s Unpacking gcc-14 (14.2.0-19ubuntu2) ... 649s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 649s Preparing to unpack .../26-gcc-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 649s Unpacking gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 649s Selecting previously unselected package gcc. 649s Preparing to unpack .../27-gcc_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 649s Unpacking gcc (4:14.2.0-1ubuntu1) ... 649s Selecting previously unselected package libstdc++-14-dev:ppc64el. 649s Preparing to unpack .../28-libstdc++-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 649s Unpacking libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 649s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 649s Preparing to unpack .../29-g++-14-powerpc64le-linux-gnu_14.2.0-19ubuntu2_ppc64el.deb ... 649s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 649s Selecting previously unselected package g++-14. 649s Preparing to unpack .../30-g++-14_14.2.0-19ubuntu2_ppc64el.deb ... 649s Unpacking g++-14 (14.2.0-19ubuntu2) ... 649s Selecting previously unselected package g++-powerpc64le-linux-gnu. 649s Preparing to unpack .../31-g++-powerpc64le-linux-gnu_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 649s Unpacking g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 649s Selecting previously unselected package g++. 649s Preparing to unpack .../32-g++_4%3a14.2.0-1ubuntu1_ppc64el.deb ... 649s Unpacking g++ (4:14.2.0-1ubuntu1) ... 649s Selecting previously unselected package build-essential. 649s Preparing to unpack .../33-build-essential_12.12ubuntu1_ppc64el.deb ... 649s Unpacking build-essential (12.12ubuntu1) ... 649s Selecting previously unselected package libllvm20:ppc64el. 649s Preparing to unpack .../34-libllvm20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 649s Unpacking libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 650s Selecting previously unselected package libclang-cpp20. 650s Preparing to unpack .../35-libclang-cpp20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 650s Unpacking libclang-cpp20 (1:20.1.2-0ubuntu1) ... 650s Selecting previously unselected package libgc1:ppc64el. 650s Preparing to unpack .../36-libgc1_1%3a8.2.8-1_ppc64el.deb ... 650s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 650s Selecting previously unselected package libobjc4:ppc64el. 650s Preparing to unpack .../37-libobjc4_15-20250404-0ubuntu1_ppc64el.deb ... 650s Unpacking libobjc4:ppc64el (15-20250404-0ubuntu1) ... 650s Selecting previously unselected package libobjc-14-dev:ppc64el. 650s Preparing to unpack .../38-libobjc-14-dev_14.2.0-19ubuntu2_ppc64el.deb ... 650s Unpacking libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 650s Selecting previously unselected package libclang-common-20-dev:ppc64el. 650s Preparing to unpack .../39-libclang-common-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 650s Unpacking libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 650s Selecting previously unselected package llvm-20-linker-tools. 650s Preparing to unpack .../40-llvm-20-linker-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 650s Unpacking llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 650s Selecting previously unselected package libclang1-20. 650s Preparing to unpack .../41-libclang1-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 650s Unpacking libclang1-20 (1:20.1.2-0ubuntu1) ... 651s Selecting previously unselected package clang-20. 651s Preparing to unpack .../42-clang-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 651s Unpacking clang-20 (1:20.1.2-0ubuntu1) ... 651s Selecting previously unselected package libncurses-dev:ppc64el. 651s Preparing to unpack .../43-libncurses-dev_6.5+20250216-2_ppc64el.deb ... 651s Unpacking libncurses-dev:ppc64el (6.5+20250216-2) ... 651s Selecting previously unselected package libpq5:ppc64el. 651s Preparing to unpack .../44-libpq5_17.4-1_ppc64el.deb ... 651s Unpacking libpq5:ppc64el (17.4-1) ... 651s Selecting previously unselected package libssl-dev:ppc64el. 651s Preparing to unpack .../45-libssl-dev_3.4.1-1ubuntu3_ppc64el.deb ... 651s Unpacking libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 651s Selecting previously unselected package libpq-dev. 651s Preparing to unpack .../46-libpq-dev_17.4-1_ppc64el.deb ... 651s Unpacking libpq-dev (17.4-1) ... 651s Selecting previously unselected package libxml2-dev:ppc64el. 651s Preparing to unpack .../47-libxml2-dev_2.12.7+dfsg+really2.9.14-0.4ubuntu0.1_ppc64el.deb ... 651s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 651s Selecting previously unselected package libxslt1.1:ppc64el. 651s Preparing to unpack .../48-libxslt1.1_1.1.39-0exp1ubuntu4_ppc64el.deb ... 651s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 651s Selecting previously unselected package llvm-20-runtime. 651s Preparing to unpack .../49-llvm-20-runtime_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 651s Unpacking llvm-20-runtime (1:20.1.2-0ubuntu1) ... 651s Selecting previously unselected package libpfm4:ppc64el. 651s Preparing to unpack .../50-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 651s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 651s Selecting previously unselected package llvm-20. 651s Preparing to unpack .../51-llvm-20_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 651s Unpacking llvm-20 (1:20.1.2-0ubuntu1) ... 651s Selecting previously unselected package libffi-dev:ppc64el. 651s Preparing to unpack .../52-libffi-dev_3.4.7-1_ppc64el.deb ... 651s Unpacking libffi-dev:ppc64el (3.4.7-1) ... 651s Selecting previously unselected package llvm-20-tools. 651s Preparing to unpack .../53-llvm-20-tools_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 651s Unpacking llvm-20-tools (1:20.1.2-0ubuntu1) ... 651s Selecting previously unselected package llvm-20-dev. 651s Preparing to unpack .../54-llvm-20-dev_1%3a20.1.2-0ubuntu1_ppc64el.deb ... 651s Unpacking llvm-20-dev (1:20.1.2-0ubuntu1) ... 653s Selecting previously unselected package postgresql-client-17. 653s Preparing to unpack .../55-postgresql-client-17_17.4-1_ppc64el.deb ... 653s Unpacking postgresql-client-17 (17.4-1) ... 653s Selecting previously unselected package postgresql-17. 653s Preparing to unpack .../56-postgresql-17_17.4-1_ppc64el.deb ... 653s Unpacking postgresql-17 (17.4-1) ... 654s Selecting previously unselected package postgresql-server-dev-17. 654s Preparing to unpack .../57-postgresql-server-dev-17_17.4-1_ppc64el.deb ... 654s Unpacking postgresql-server-dev-17 (17.4-1) ... 654s Selecting previously unselected package tzdata-legacy. 654s Preparing to unpack .../58-tzdata-legacy_2025b-1ubuntu1.1_all.deb ... 654s Unpacking tzdata-legacy (2025b-1ubuntu1.1) ... 654s Setting up postgresql-client-common (274) ... 654s Setting up libncurses-dev:ppc64el (6.5+20250216-2) ... 654s Setting up libio-pty-perl (1:1.20-1build3) ... 654s Setting up libclang-common-20-dev:ppc64el (1:20.1.2-0ubuntu1) ... 654s Setting up libpq5:ppc64el (17.4-1) ... 654s Setting up libgomp1:ppc64el (15-20250404-0ubuntu1) ... 654s Setting up libffi-dev:ppc64el (3.4.7-1) ... 654s Setting up tzdata-legacy (2025b-1ubuntu1.1) ... 654s Setting up binutils-gold-powerpc64le-linux-gnu (2.44-2) ... 654s Setting up libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.4ubuntu0.1) ... 654s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 654s Setting up ssl-cert (1.1.3ubuntu1) ... 654s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 655s Setting up libquadmath0:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up libssl-dev:ppc64el (3.4.1-1ubuntu3) ... 655s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 655s Setting up libllvm20:ppc64el (1:20.1.2-0ubuntu1) ... 655s Setting up libipc-run-perl (20231003.0-2) ... 655s Setting up libgc1:ppc64el (1:8.2.8-1) ... 655s Setting up libubsan1:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up libasan8:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up libjson-perl (4.10000-1) ... 655s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu4) ... 655s Setting up libtsan2:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up libisl23:ppc64el (0.27-1) ... 655s Setting up libclang1-20 (1:20.1.2-0ubuntu1) ... 655s Setting up libcc1-0:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up liblsan0:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up libitm1:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up postgresql-common-dev (274) ... 655s Setting up postgresql-client-17 (17.4-1) ... 655s 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 655s Setting up binutils-gold (2.44-2) ... 655s Setting up llvm-20-runtime (1:20.1.2-0ubuntu1) ... 655s Setting up libpq-dev (17.4-1) ... 655s Setting up libobjc4:ppc64el (15-20250404-0ubuntu1) ... 655s Setting up llvm-20-linker-tools (1:20.1.2-0ubuntu1) ... 655s Setting up llvm-20-tools (1:20.1.2-0ubuntu1) ... 655s Setting up libclang-cpp20 (1:20.1.2-0ubuntu1) ... 655s Setting up llvm-20 (1:20.1.2-0ubuntu1) ... 655s Setting up postgresql-common (274) ... 655s Creating config file /etc/postgresql-common/createcluster.conf with new version 655s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 655s Removing obsolete dictionary files: 656s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 657s Setting up llvm-20-dev (1:20.1.2-0ubuntu1) ... 657s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 657s Setting up cpp-14 (14.2.0-19ubuntu2) ... 657s Setting up libgcc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 657s Setting up libstdc++-14-dev:ppc64el (14.2.0-19ubuntu2) ... 657s Setting up cpp-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 657s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 657s Setting up postgresql-17 (17.4-1) ... 657s Creating new PostgreSQL cluster 17/main ... 657s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 657s The files belonging to this database system will be owned by user "postgres". 657s This user must also own the server process. 657s 657s The database cluster will be initialized with locale "C.UTF-8". 657s The default database encoding has accordingly been set to "UTF8". 657s The default text search configuration will be set to "english". 657s 657s Data page checksums are disabled. 657s 657s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 657s creating subdirectories ... ok 657s selecting dynamic shared memory implementation ... posix 657s selecting default "max_connections" ... 100 657s selecting default "shared_buffers" ... 128MB 657s selecting default time zone ... Etc/UTC 657s creating configuration files ... ok 658s running bootstrap script ... ok 658s performing post-bootstrap initialization ... ok 658s syncing data to disk ... ok 661s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-19ubuntu2) ... 661s Setting up libobjc-14-dev:ppc64el (14.2.0-19ubuntu2) ... 661s Setting up gcc-14 (14.2.0-19ubuntu2) ... 661s Setting up gcc-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 661s Setting up cpp (4:14.2.0-1ubuntu1) ... 661s Setting up g++-14 (14.2.0-19ubuntu2) ... 661s Setting up clang-20 (1:20.1.2-0ubuntu1) ... 661s Setting up g++-powerpc64le-linux-gnu (4:14.2.0-1ubuntu1) ... 661s Setting up gcc (4:14.2.0-1ubuntu1) ... 661s Setting up postgresql-server-dev-17 (17.4-1) ... 661s Setting up g++ (4:14.2.0-1ubuntu1) ... 661s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 661s Setting up build-essential (12.12ubuntu1) ... 661s Processing triggers for libc-bin (2.41-6ubuntu1) ... 661s Processing triggers for systemd (257.4-1ubuntu3) ... 661s Processing triggers for man-db (2.13.0-1) ... 663s Processing triggers for install-info (7.1.1-1) ... 676s autopkgtest [18:48:11]: test installcheck: [----------------------- 676s + dpkg-parsechangelog -SSource 676s + SOURCE=postgresql-17 676s + MAJOR=17 676s + top_srcdir=/tmp/autopkgtest.LuAtja/build.8L6/src 676s + cd src/test/regress 676s + make -f /tmp/autopkgtest.LuAtja/build.8L6/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/17/bin/pg_config with_llvm=no 676s 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.LuAtja/build.8L6/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 677s 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 678s + sed -i -e s;set regresslib :libdir;set regresslib '/tmp/autopkgtest.LuAtja/build.8L6/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 678s + id -u 678s + [ 1000 = 0 ] 678s + SU=sh 678s + sh 678s + mktemp -d /tmp/regress.XXXXXX 678s + OUTPUT=/tmp/regress.qTb0TL 678s + trap rm -rf /tmp/regress.qTb0TL EXIT 678s + pg_virtualenv -v 17 /usr/lib/postgresql/17/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --outputdir=/tmp/regress.qTb0TL --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 678s Creating new PostgreSQL cluster 17/regress ... 681s # using postmaster on localhost, port 5433 681s ok 1 - test_setup 209 ms 682s # parallel group (20 tests): txid char name pg_lsn text varchar oid int2 int4 regproc money uuid float8 float4 int8 enum boolean bit numeric rangetypes 682s ok 2 + boolean 534 ms 682s ok 3 + char 206 ms 682s ok 4 + name 216 ms 682s ok 5 + varchar 224 ms 682s ok 6 + text 221 ms 682s ok 7 + int2 249 ms 682s ok 8 + int4 263 ms 682s ok 9 + int8 332 ms 682s ok 10 + oid 239 ms 682s ok 11 + float4 317 ms 682s ok 12 + float8 312 ms 682s ok 13 + bit 540 ms 682s ok 14 + numeric 647 ms 682s ok 15 + txid 187 ms 682s ok 16 + uuid 301 ms 682s ok 17 + enum 333 ms 682s ok 18 + money 263 ms 682s ok 19 + rangetypes 763 ms 682s ok 20 + pg_lsn 192 ms 682s ok 21 + regproc 258 ms 683s # parallel group (20 tests): lseg md5 circle line time path timetz macaddr numerology macaddr8 inet date strings interval point timestamp timestamptz polygon multirangetypes box 683s ok 22 + strings 427 ms 683s ok 23 + md5 178 ms 683s ok 24 + numerology 262 ms 683s ok 25 + point 528 ms 683s ok 26 + lseg 176 ms 683s ok 27 + line 198 ms 683s ok 28 + box 1173 ms 683s ok 29 + path 211 ms 683s ok 30 + polygon 927 ms 683s ok 31 + circle 189 ms 683s ok 32 + date 315 ms 683s ok 33 + time 195 ms 683s ok 34 + timetz 246 ms 683s ok 35 + timestamp 559 ms 683s ok 36 + timestamptz 626 ms 683s ok 37 + interval 425 ms 683s ok 38 + inet 276 ms 683s ok 39 + macaddr 246 ms 683s ok 40 + macaddr8 258 ms 683s ok 41 + multirangetypes 925 ms 684s # parallel group (13 tests): unicode misc_sanity comments xid expressions tstypes type_sanity mvcc geometry regex horology database opr_sanity 684s ok 42 + geometry 434 ms 684s ok 43 + horology 530 ms 684s ok 44 + tstypes 254 ms 684s ok 45 + regex 469 ms 684s ok 46 + type_sanity 298 ms 684s ok 47 + opr_sanity 595 ms 684s ok 48 + misc_sanity 121 ms 684s ok 49 + comments 130 ms 684s ok 50 + expressions 234 ms 684s ok 51 + unicode 120 ms 684s ok 52 + xid 226 ms 684s ok 53 + mvcc 318 ms 684s ok 54 + database 579 ms 684s # parallel group (5 tests): copyselect copydml copy insert_conflict insert 684s ok 55 + copy 169 ms 684s ok 56 + copyselect 63 ms 684s ok 57 + copydml 69 ms 684s ok 58 + insert 305 ms 684s ok 59 + insert_conflict 173 ms 684s # parallel group (7 tests): create_function_c create_operator create_schema create_type create_misc create_procedure create_table 684s ok 60 + create_function_c 75 ms 684s ok 61 + create_misc 133 ms 684s ok 62 + create_operator 93 ms 684s ok 63 + create_procedure 136 ms 684s ok 64 + create_table 307 ms 684s ok 65 + create_type 110 ms 684s ok 66 + create_schema 110 ms 686s # parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 686s ok 67 + create_index 1217 ms 686s ok 68 + create_index_spgist 1131 ms 686s ok 69 + create_view 447 ms 686s ok 70 + index_including 305 ms 686s ok 71 + index_including_gist 438 ms 687s # parallel group (16 tests): infinite_recurse create_aggregate create_cast errors roleattributes hash_func typed_table drop_if_exists create_function_sql create_am select constraints vacuum updatable_views triggers inherit 687s ok 72 + create_aggregate 141 ms 687s ok 73 + create_function_sql 422 ms 687s ok 74 + create_cast 218 ms 687s ok 75 + constraints 573 ms 687s ok 76 + triggers 1130 ms 687s ok 77 + select 549 ms 687s ok 78 + inherit 1146 ms 687s ok 79 + typed_table 309 ms 687s ok 80 + vacuum 726 ms 687s ok 81 + drop_if_exists 332 ms 687s ok 82 + updatable_views 929 ms 687s ok 83 + roleattributes 245 ms 687s ok 84 + create_am 471 ms 687s ok 85 + hash_func 258 ms 687s ok 86 + errors 208 ms 687s ok 87 + infinite_recurse 119 ms 687s ok 88 - sanity_check 77 ms 690s # parallel group (20 tests): select_distinct_on select_having delete case select_implicit select_into namespace random prepared_xacts transactions portals select_distinct union arrays subselect update hash_index aggregates join btree_index 690s ok 89 + select_into 339 ms 690s ok 90 + select_distinct 744 ms 690s ok 91 + select_distinct_on 200 ms 690s ok 92 + select_implicit 304 ms 690s ok 93 + select_having 252 ms 690s ok 94 + subselect 940 ms 690s ok 95 + union 813 ms 690s ok 96 + case 289 ms 690s ok 97 + join 2495 ms 690s ok 98 + aggregates 2343 ms 690s ok 99 + transactions 622 ms 690s ok 100 + random 433 ms 690s ok 101 + portals 663 ms 690s ok 102 + arrays 896 ms 690s ok 103 + btree_index 2747 ms 690s ok 104 + hash_index 1711 ms 690s ok 105 + update 1494 ms 690s ok 106 + delete 273 ms 690s ok 107 + namespace 419 ms 690s ok 108 + prepared_xacts 444 ms 696s # parallel group (20 tests): init_privs drop_operator security_label tablesample lock object_address password replica_identity identity matview collate generated spgist rowsecurity gist groupingsets gin join_hash brin privileges 696s ok 109 + brin 6325 ms 696s ok 110 + gin 2791 ms 696s ok 111 + gist 2489 ms 696s ok 112 + spgist 2294 ms 696s ok 113 + privileges 6782 ms 696s ok 114 + init_privs 260 ms 696s ok 115 + security_label 295 ms 696s ok 116 + collate 1866 ms 696s ok 117 + matview 1765 ms 696s ok 118 + lock 467 ms 696s ok 119 + replica_identity 935 ms 696s ok 120 + rowsecurity 2328 ms 696s ok 121 + object_address 661 ms 696s ok 122 + tablesample 399 ms 696s ok 123 + groupingsets 2669 ms 696s ok 124 + drop_operator 259 ms 696s ok 125 + password 903 ms 696s ok 126 + identity 1635 ms 696s ok 127 + generated 2257 ms 696s ok 128 + join_hash 6317 ms 697s # parallel group (2 tests): brin_bloom brin_multi 697s ok 129 + brin_bloom 77 ms 697s ok 130 + brin_multi 214 ms 698s # parallel group (17 tests): async dbsize collate.utf8 tidscan alter_operator tid tsrf create_role alter_generic sysviews misc_functions tidrangescan merge create_table_like incremental_sort collate.icu.utf8 misc 698s ok 131 + create_table_like 848 ms 698s ok 132 + alter_generic 482 ms 698s ok 133 + alter_operator 241 ms 698s ok 134 + misc 1129 ms 698s ok 135 + async 166 ms 698s ok 136 + dbsize 174 ms 698s ok 137 + merge 811 ms 698s ok 138 + misc_functions 510 ms 698s ok 139 + sysviews 496 ms 698s ok 140 + tsrf 253 ms 698s ok 141 + tid 236 ms 698s ok 142 + tidscan 201 ms 698s ok 143 + tidrangescan 703 ms 698s ok 144 + collate.utf8 182 ms 698s ok 145 + collate.icu.utf8 1097 ms 698s ok 146 + incremental_sort 834 ms 698s ok 147 + create_role 361 ms 699s # parallel group (7 tests): collate.windows.win1252 collate.linux.utf8 amutils psql_crosstab rules psql stats_ext 699s ok 148 + rules 457 ms 699s ok 149 + psql 497 ms 699s ok 150 + psql_crosstab 90 ms 699s ok 151 + amutils 73 ms 699s ok 152 + stats_ext 1171 ms 699s ok 153 + collate.linux.utf8 66 ms 699s ok 154 + collate.windows.win1252 61 ms 702s ok 155 - select_parallel 2719 ms 702s ok 156 - write_parallel 95 ms 702s ok 157 - vacuum_parallel 131 ms 704s # parallel group (2 tests): subscription publication 704s ok 158 + publication 1839 ms 704s ok 159 + subscription 52 ms 706s # parallel group (17 tests): portals_p2 advisory_lock equivclass combocid tsdicts xmlmap functional_deps dependency guc select_views window cluster bitmapops indirect_toast foreign_data foreign_key tsearch 706s ok 160 + select_views 480 ms 706s ok 161 + portals_p2 239 ms 706s ok 162 + foreign_key 1476 ms 706s ok 163 + cluster 892 ms 706s ok 164 + dependency 420 ms 706s ok 165 + guc 432 ms 706s ok 166 + bitmapops 925 ms 706s ok 167 + combocid 300 ms 706s ok 168 + tsearch 1882 ms 706s ok 169 + tsdicts 313 ms 706s ok 170 + foreign_data 1148 ms 706s ok 171 + window 750 ms 706s ok 172 + xmlmap 344 ms 706s ok 173 + functional_deps 387 ms 706s ok 174 + advisory_lock 273 ms 706s ok 175 + indirect_toast 961 ms 706s ok 176 + equivclass 278 ms 706s # parallel group (9 tests): jsonpath_encoding json_encoding jsonpath sqljson sqljson_jsontable sqljson_queryfuncs json jsonb_jsonpath jsonb 706s ok 177 + json 262 ms 706s ok 178 + jsonb 374 ms 706s ok 179 + json_encoding 104 ms 706s ok 180 + jsonpath 139 ms 706s ok 181 + jsonpath_encoding 89 ms 706s ok 182 + jsonb_jsonpath 265 ms 706s ok 183 + sqljson 192 ms 706s ok 184 + sqljson_queryfuncs 241 ms 706s ok 185 + sqljson_jsontable 197 ms 708s # parallel group (18 tests): prepare returning limit plancache conversion copy2 temp sequence polymorphism rowtypes truncate largeobject with domain rangefuncs xml plpgsql alter_table 708s ok 186 + plancache 462 ms 708s ok 187 + limit 419 ms 708s ok 188 + plpgsql 1328 ms 708s ok 189 + copy2 690 ms 708s ok 190 + temp 699 ms 708s ok 191 + domain 1020 ms 708s ok 192 + rangefuncs 1112 ms 708s ok 193 + prepare 291 ms 708s ok 194 + conversion 502 ms 708s ok 195 + truncate 851 ms 708s ok 196 + alter_table 1887 ms 708s ok 197 + sequence 710 ms 708s ok 198 + polymorphism 774 ms 708s ok 199 + rowtypes 843 ms 708s ok 200 + returning 318 ms 708s ok 201 + largeobject 917 ms 708s ok 202 + with 993 ms 708s ok 203 + xml 1189 ms 710s # parallel group (13 tests): hash_part reloptions partition_info explain predicate compression memoize partition_aggregate partition_join stats indexing tuplesort partition_prune 710s ok 204 + partition_join 1820 ms 710s ok 205 + partition_prune 2259 ms 710s ok 206 + reloptions 237 ms 710s ok 207 + hash_part 220 ms 710s ok 208 + indexing 1895 ms 710s ok 209 + partition_aggregate 1729 ms 710s ok 210 + partition_info 284 ms 710s ok 211 + tuplesort 1965 ms 710s ok 212 + explain 321 ms 710s ok 213 + compression 639 ms 710s ok 214 + memoize 1271 ms 710s ok 215 + stats 1850 ms 710s ok 216 + predicate 322 ms 711s # parallel group (2 tests): oidjoins event_trigger 711s ok 217 + oidjoins 189 ms 711s ok 218 + event_trigger 209 ms 711s ok 219 - event_trigger_login 71 ms 711s ok 220 - fast_default 108 ms 711s ok 221 - tablespace 248 ms 711s 1..221 711s # All 221 tests passed. 711s Dropping cluster 17/regress ... 711s + rm -rf /tmp/regress.qTb0TL 712s autopkgtest [18:48:47]: test installcheck: -----------------------] 712s installcheck PASS 712s autopkgtest [18:48:47]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 713s autopkgtest [18:48:48]: @@@@@@@@@@@@@@@@@@@@ summary 713s run-testsuite PASS 713s installcheck PASS 717s nova [W] Using flock in prodstack6-ppc64el 717s Creating nova instance adt-plucky-ppc64el-postgresql-17-20250506-183655-juju-7f2275-prod-proposed-migration-environment-21-6f0d5c94-5954-4c72-a600-f5e4a6e5b7bf from image adt/ubuntu-plucky-ppc64el-server-20250506.img (UUID e82014c2-f15f-4648-9b79-ce00f56b498f)... 717s nova [W] Timed out waiting for 226e56c3-c332-4da0-89a6-a8ce42c3afdc to get deleted. 717s nova [W] Using flock in prodstack6-ppc64el 717s Creating nova instance adt-plucky-ppc64el-postgresql-17-20250506-183655-juju-7f2275-prod-proposed-migration-environment-21-6f0d5c94-5954-4c72-a600-f5e4a6e5b7bf from image adt/ubuntu-plucky-ppc64el-server-20250506.img (UUID e82014c2-f15f-4648-9b79-ce00f56b498f)... 717s nova [W] Timed out waiting for 15076d26-5554-4679-8df5-af3bb59c39ed to get deleted.