0s autopkgtest [05:53:11]: starting date and time: 2025-01-17 05:53:11+0000 0s autopkgtest [05:53:11]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [05:53:11]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.eqnk__8s/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:ucf --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=ucf/3.0048 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-ppc64el-1.secgroup --name adt-plucky-ppc64el-postgresql-common-20250117-055311-juju-7f2275-prod-proposed-migration-environment-20-f2805f81-5dbf-4ac1-8786-79d048907ee9 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 82s autopkgtest [05:54:33]: testbed dpkg architecture: ppc64el 82s autopkgtest [05:54:33]: testbed apt version: 2.9.18 83s autopkgtest [05:54:34]: @@@@@@@@@@@@@@@@@@@@ test bed setup 83s autopkgtest [05:54:34]: testbed release detected to be: None 84s autopkgtest [05:54:35]: updating testbed package index (apt update) 84s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 84s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 84s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 84s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 84s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [908 kB] 85s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.4 kB] 85s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 85s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [168 kB] 85s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [293 kB] 85s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [756 B] 85s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [1045 kB] 85s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [16.7 kB] 86s Fetched 2530 kB in 2s (1433 kB/s) 87s Reading package lists... 87s Reading package lists... 87s Building dependency tree... 87s Reading state information... 88s Calculating upgrade... 88s The following packages will be upgraded: 88s libgudev-1.0-0 88s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 88s Need to get 15.7 kB of archives. 88s After this operation, 1024 B of additional disk space will be used. 88s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgudev-1.0-0 ppc64el 1:238-6 [15.7 kB] 88s Fetched 15.7 kB in 0s (75.2 kB/s) 89s (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 ... 74045 files and directories currently installed.) 89s Preparing to unpack .../libgudev-1.0-0_1%3a238-6_ppc64el.deb ... 89s Unpacking libgudev-1.0-0:ppc64el (1:238-6) over (1:238-5ubuntu1) ... 89s Setting up libgudev-1.0-0:ppc64el (1:238-6) ... 89s Processing triggers for libc-bin (2.40-4ubuntu1) ... 89s Reading package lists... 89s Building dependency tree... 89s Reading state information... 90s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 90s autopkgtest [05:54:41]: upgrading testbed (apt dist-upgrade and autopurge) 90s Reading package lists... 90s Building dependency tree... 90s Reading state information... 91s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 91s Starting 2 pkgProblemResolver with broken count: 0 91s Done 91s Entering ResolveByKeep 91s 92s The following packages will be upgraded: 92s ucf 92s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s Need to get 42.8 kB of archives. 92s After this operation, 0 B of additional disk space will be used. 92s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el ucf all 3.0048 [42.8 kB] 92s Preconfiguring packages ... 92s Fetched 42.8 kB in 0s (154 kB/s) 92s (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 ... 74045 files and directories currently installed.) 92s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 92s Unpacking ucf (3.0048) over (3.0046) ... 92s Setting up ucf (3.0048) ... 92s Processing triggers for man-db (2.13.0-1) ... 94s Reading package lists... 94s Building dependency tree... 94s Reading state information... 95s Starting pkgProblemResolver with broken count: 0 95s Starting 2 pkgProblemResolver with broken count: 0 95s Done 95s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 98s autopkgtest [05:54:49]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 13:49:23 UTC 2024 98s autopkgtest [05:54:49]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 103s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (dsc) [2383 B] 103s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (tar) [219 kB] 103s gpgv: Signature made Thu Nov 21 11:03:28 2024 UTC 103s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 103s gpgv: Can't check signature: No public key 103s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_267.dsc: no acceptable signature found 103s autopkgtest [05:54:54]: testing package postgresql-common version 267 104s autopkgtest [05:54:55]: build not needed 104s autopkgtest [05:54:55]: test default-psql: preparing testbed 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 105s Starting pkgProblemResolver with broken count: 0 105s Starting 2 pkgProblemResolver with broken count: 0 105s Done 105s The following NEW packages will be installed: 105s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 105s postgresql-17 postgresql-client-17 postgresql-client-common 105s postgresql-common ssl-cert 105s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 105s Need to get 19.4 MB of archives. 105s After this operation, 66.0 MB of additional disk space will be used. 105s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 105s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 105s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 105s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 267 [37.1 kB] 105s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 105s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 267 [162 kB] 105s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.2-1 [173 kB] 106s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 106s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.2-1 [1464 kB] 106s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.2-1 [17.1 MB] 108s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql all 17+267 [12.2 kB] 109s Preconfiguring packages ... 109s Fetched 19.4 MB in 3s (5684 kB/s) 109s Selecting previously unselected package libjson-perl. 109s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 74045 files and directories currently installed.) 109s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 109s Unpacking libjson-perl (4.10000-1) ... 109s Selecting previously unselected package libio-pty-perl. 109s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 109s Unpacking libio-pty-perl (1:1.20-1build3) ... 109s Selecting previously unselected package libipc-run-perl. 109s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 109s Unpacking libipc-run-perl (20231003.0-2) ... 109s Selecting previously unselected package postgresql-client-common. 109s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 109s Unpacking postgresql-client-common (267) ... 109s Selecting previously unselected package ssl-cert. 109s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 109s Unpacking ssl-cert (1.1.3ubuntu1) ... 109s Selecting previously unselected package postgresql-common. 109s Preparing to unpack .../05-postgresql-common_267_all.deb ... 109s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 109s Unpacking postgresql-common (267) ... 109s Selecting previously unselected package libpq5:ppc64el. 109s Preparing to unpack .../06-libpq5_17.2-1_ppc64el.deb ... 109s Unpacking libpq5:ppc64el (17.2-1) ... 109s Selecting previously unselected package libxslt1.1:ppc64el. 109s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 109s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 109s Selecting previously unselected package postgresql-client-17. 109s Preparing to unpack .../08-postgresql-client-17_17.2-1_ppc64el.deb ... 109s Unpacking postgresql-client-17 (17.2-1) ... 109s Selecting previously unselected package postgresql-17. 109s Preparing to unpack .../09-postgresql-17_17.2-1_ppc64el.deb ... 109s Unpacking postgresql-17 (17.2-1) ... 109s Selecting previously unselected package postgresql. 109s Preparing to unpack .../10-postgresql_17+267_all.deb ... 109s Unpacking postgresql (17+267) ... 109s Setting up libio-pty-perl (1:1.20-1build3) ... 109s Setting up libpq5:ppc64el (17.2-1) ... 109s Setting up ssl-cert (1.1.3ubuntu1) ... 110s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 110s Setting up libipc-run-perl (20231003.0-2) ... 110s Setting up libjson-perl (4.10000-1) ... 110s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 110s Setting up postgresql-client-common (267) ... 110s Setting up postgresql-client-17 (17.2-1) ... 111s 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 111s Setting up postgresql-common (267) ... 112s Creating config file /etc/postgresql-common/createcluster.conf with new version 112s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 112s Removing obsolete dictionary files: 113s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 113s Setting up postgresql-17 (17.2-1) ... 113s Creating new PostgreSQL cluster 17/main ... 113s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 113s The files belonging to this database system will be owned by user "postgres". 113s This user must also own the server process. 113s 113s The database cluster will be initialized with locale "C.UTF-8". 113s The default database encoding has accordingly been set to "UTF8". 113s The default text search configuration will be set to "english". 113s 113s Data page checksums are disabled. 113s 113s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 113s creating subdirectories ... ok 113s selecting dynamic shared memory implementation ... posix 113s selecting default "max_connections" ... 100 113s selecting default "shared_buffers" ... 128MB 114s selecting default time zone ... Etc/UTC 114s creating configuration files ... ok 114s running bootstrap script ... ok 114s performing post-bootstrap initialization ... ok 114s syncing data to disk ... ok 118s Setting up postgresql (17+267) ... 118s Processing triggers for man-db (2.13.0-1) ... 120s Processing triggers for libc-bin (2.40-4ubuntu1) ... 121s autopkgtest [05:55:12]: test default-psql: [----------------------- 121s autopkgtest [05:55:12]: test default-psql: -----------------------] 122s autopkgtest [05:55:13]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 122s default-psql PASS 122s autopkgtest [05:55:13]: test run-testsuite: preparing testbed 210s autopkgtest [05:56:41]: testbed dpkg architecture: ppc64el 210s autopkgtest [05:56:41]: testbed apt version: 2.9.18 211s autopkgtest [05:56:42]: @@@@@@@@@@@@@@@@@@@@ test bed setup 211s autopkgtest [05:56:42]: testbed release detected to be: plucky 212s autopkgtest [05:56:43]: updating testbed package index (apt update) 212s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 212s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 212s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 212s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 212s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [908 kB] 213s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 213s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [168 kB] 213s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.4 kB] 213s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [293 kB] 213s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [756 B] 213s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [1045 kB] 213s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [16.7 kB] 213s Fetched 2530 kB in 1s (2193 kB/s) 214s Reading package lists... 215s Reading package lists... 215s Building dependency tree... 215s Reading state information... 215s Calculating upgrade... 215s The following packages will be upgraded: 215s libgudev-1.0-0 215s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 215s Need to get 15.7 kB of archives. 215s After this operation, 1024 B of additional disk space will be used. 215s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgudev-1.0-0 ppc64el 1:238-6 [15.7 kB] 216s Fetched 15.7 kB in 0s (63.1 kB/s) 217s (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 ... 74045 files and directories currently installed.) 217s Preparing to unpack .../libgudev-1.0-0_1%3a238-6_ppc64el.deb ... 217s Unpacking libgudev-1.0-0:ppc64el (1:238-6) over (1:238-5ubuntu1) ... 217s Setting up libgudev-1.0-0:ppc64el (1:238-6) ... 217s Processing triggers for libc-bin (2.40-4ubuntu1) ... 217s Reading package lists... 217s Building dependency tree... 217s Reading state information... 217s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 217s autopkgtest [05:56:48]: upgrading testbed (apt dist-upgrade and autopurge) 218s Reading package lists... 218s Building dependency tree... 218s Reading state information... 218s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 218s Starting 2 pkgProblemResolver with broken count: 0 218s Done 219s Entering ResolveByKeep 219s 219s The following packages will be upgraded: 219s ucf 219s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 219s Need to get 42.8 kB of archives. 219s After this operation, 0 B of additional disk space will be used. 219s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el ucf all 3.0048 [42.8 kB] 220s Preconfiguring packages ... 220s Fetched 42.8 kB in 0s (145 kB/s) 220s (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 ... 74045 files and directories currently installed.) 220s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 220s Unpacking ucf (3.0048) over (3.0046) ... 220s Setting up ucf (3.0048) ... 220s Processing triggers for man-db (2.13.0-1) ... 222s Reading package lists... 222s Building dependency tree... 222s Reading state information... 222s Starting pkgProblemResolver with broken count: 0 222s Starting 2 pkgProblemResolver with broken count: 0 222s Done 223s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 226s Reading package lists... 227s Building dependency tree... 227s Reading state information... 227s Starting pkgProblemResolver with broken count: 0 227s Starting 2 pkgProblemResolver with broken count: 0 227s Done 227s The following NEW packages will be installed: 227s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 227s cpp-14 cpp-14-powerpc64le-linux-gnu cpp-powerpc64le-linux-gnu debhelper 227s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 227s emacsen-common fakeroot g++ g++-14 g++-14-powerpc64le-linux-gnu 227s g++-powerpc64le-linux-gnu gcc gcc-14 gcc-14-powerpc64le-linux-gnu 227s gcc-powerpc64le-linux-gnu gettext hunspell-en-us intltool-debian 227s libarchive-zip-perl libasan8 libcc1-0 libclang-common-19-dev libclang-cpp19 227s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 227s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev libgomp1 227s libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl liblsan0 227s libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 227s libpq5 libquadmath0 libssl-dev libstdc++-14-dev libtcl8.6 libtool libtsan2 227s libubsan1 libxml2-dev libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools 227s llvm-19-runtime llvm-19-tools locales-all m4 po-debconf postgresql-17 227s postgresql-all postgresql-client-17 postgresql-client-common 227s postgresql-common postgresql-doc postgresql-doc-17 postgresql-plperl-17 227s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 227s postgresql-server-dev-all ssl-cert 227s 0 upgraded, 88 newly installed, 0 to remove and 0 not upgraded. 227s Need to get 188 MB of archives. 227s After this operation, 1136 MB of additional disk space will be used. 227s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 228s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 228s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 228s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 267 [37.1 kB] 228s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 228s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 267 [162 kB] 228s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el m4 ppc64el 1.4.19-4build1 [278 kB] 228s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el autoconf all 2.72-3 [382 kB] 228s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el autotools-dev all 20220109.1 [44.9 kB] 228s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el automake all 1:1.16.5-1.3ubuntu1 [558 kB] 228s Get:11 http://ftpmaster.internal/ubuntu plucky/main ppc64el autopoint all 0.22.5-3 [616 kB] 228s Get:12 http://ftpmaster.internal/ubuntu plucky/main ppc64el libisl23 ppc64el 0.27-1 [882 kB] 228s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el libmpc3 ppc64el 1.3.1-1build2 [62.1 kB] 228s Get:14 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14-powerpc64le-linux-gnu ppc64el 14.2.0-12ubuntu1 [10.5 MB] 228s Get:15 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-14 ppc64el 14.2.0-12ubuntu1 [1038 B] 228s Get:16 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [5456 B] 228s Get:17 http://ftpmaster.internal/ubuntu plucky/main ppc64el cpp ppc64el 4:14.1.0-2ubuntu1 [22.5 kB] 228s Get:18 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcc1-0 ppc64el 14.2.0-12ubuntu1 [48.1 kB] 228s Get:19 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgomp1 ppc64el 14.2.0-12ubuntu1 [161 kB] 228s Get:20 http://ftpmaster.internal/ubuntu plucky/main ppc64el libitm1 ppc64el 14.2.0-12ubuntu1 [32.1 kB] 228s Get:21 http://ftpmaster.internal/ubuntu plucky/main ppc64el libasan8 ppc64el 14.2.0-12ubuntu1 [2945 kB] 228s Get:22 http://ftpmaster.internal/ubuntu plucky/main ppc64el liblsan0 ppc64el 14.2.0-12ubuntu1 [1322 kB] 229s Get:23 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtsan2 ppc64el 14.2.0-12ubuntu1 [2695 kB] 229s Get:24 http://ftpmaster.internal/ubuntu plucky/main ppc64el libubsan1 ppc64el 14.2.0-12ubuntu1 [1191 kB] 229s Get:25 http://ftpmaster.internal/ubuntu plucky/main ppc64el libquadmath0 ppc64el 14.2.0-12ubuntu1 [158 kB] 229s Get:26 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgcc-14-dev ppc64el 14.2.0-12ubuntu1 [1620 kB] 229s Get:27 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14-powerpc64le-linux-gnu ppc64el 14.2.0-12ubuntu1 [20.6 MB] 230s Get:28 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-14 ppc64el 14.2.0-12ubuntu1 [533 kB] 230s Get:29 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [1222 B] 230s Get:30 http://ftpmaster.internal/ubuntu plucky/main ppc64el gcc ppc64el 4:14.1.0-2ubuntu1 [5006 B] 230s Get:31 http://ftpmaster.internal/ubuntu plucky/main ppc64el libstdc++-14-dev ppc64el 14.2.0-12ubuntu1 [2675 kB] 230s Get:32 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14-powerpc64le-linux-gnu ppc64el 14.2.0-12ubuntu1 [12.0 MB] 230s Get:33 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-14 ppc64el 14.2.0-12ubuntu1 [20.2 kB] 230s Get:34 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++-powerpc64le-linux-gnu ppc64el 4:14.1.0-2ubuntu1 [968 B] 230s Get:35 http://ftpmaster.internal/ubuntu plucky/main ppc64el g++ ppc64el 4:14.1.0-2ubuntu1 [1090 B] 230s Get:36 http://ftpmaster.internal/ubuntu plucky/main ppc64el build-essential ppc64el 12.10ubuntu1 [4936 B] 230s Get:37 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-cpp19 ppc64el 1:19.1.6-1ubuntu1 [15.2 MB] 231s Get:38 http://ftpmaster.internal/ubuntu plucky/main ppc64el libgc1 ppc64el 1:8.2.8-1 [112 kB] 231s Get:39 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc4 ppc64el 14.2.0-12ubuntu1 [52.7 kB] 231s Get:40 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libobjc-14-dev ppc64el 14.2.0-12ubuntu1 [202 kB] 231s Get:41 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libclang-common-19-dev ppc64el 1:19.1.6-1ubuntu1 [743 kB] 231s Get:42 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-linker-tools ppc64el 1:19.1.6-1ubuntu1 [1383 kB] 231s Get:43 http://ftpmaster.internal/ubuntu plucky/universe ppc64el clang-19 ppc64el 1:19.1.6-1ubuntu1 [82.3 kB] 231s Get:44 http://ftpmaster.internal/ubuntu plucky/main ppc64el libdebhelper-perl all 13.20ubuntu1 [94.2 kB] 231s Get:45 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtool all 2.4.7-8 [166 kB] 231s Get:46 http://ftpmaster.internal/ubuntu plucky/main ppc64el dh-autoreconf all 20 [16.1 kB] 231s Get:47 http://ftpmaster.internal/ubuntu plucky/main ppc64el libarchive-zip-perl all 1.68-1 [90.2 kB] 231s Get:48 http://ftpmaster.internal/ubuntu plucky/main ppc64el libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 231s Get:49 http://ftpmaster.internal/ubuntu plucky/main ppc64el dh-strip-nondeterminism all 1.14.0-1 [5058 B] 231s Get:50 http://ftpmaster.internal/ubuntu plucky/main ppc64el debugedit ppc64el 1:5.1-1 [52.1 kB] 231s Get:51 http://ftpmaster.internal/ubuntu plucky/main ppc64el dwz ppc64el 0.15-1build6 [142 kB] 231s Get:52 http://ftpmaster.internal/ubuntu plucky/main ppc64el gettext ppc64el 0.22.5-3 [1083 kB] 231s Get:53 http://ftpmaster.internal/ubuntu plucky/main ppc64el intltool-debian all 0.35.0+20060710.6 [23.2 kB] 231s Get:54 http://ftpmaster.internal/ubuntu plucky/main ppc64el po-debconf all 1.0.21+nmu1 [233 kB] 231s Get:55 http://ftpmaster.internal/ubuntu plucky/main ppc64el debhelper all 13.20ubuntu1 [893 kB] 231s Get:56 http://ftpmaster.internal/ubuntu plucky/main ppc64el emacsen-common all 3.0.5 [12.1 kB] 231s Get:57 http://ftpmaster.internal/ubuntu plucky/main ppc64el dictionaries-common all 1.30.2 [176 kB] 231s Get:58 http://ftpmaster.internal/ubuntu plucky/main ppc64el libfakeroot ppc64el 1.36.2-1 [35.7 kB] 231s Get:59 http://ftpmaster.internal/ubuntu plucky/main ppc64el fakeroot ppc64el 1.36.2-1 [70.2 kB] 231s Get:60 http://ftpmaster.internal/ubuntu plucky/main ppc64el hunspell-en-us all 1:2020.12.07-3 [586 kB] 231s Get:61 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpgtypes3 ppc64el 17.2-1 [49.1 kB] 231s Get:62 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.2-1 [173 kB] 231s Get:63 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg6 ppc64el 17.2-1 [55.5 kB] 231s Get:64 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg-compat3 ppc64el 17.2-1 [13.9 kB] 231s Get:65 http://ftpmaster.internal/ubuntu plucky/main ppc64el libssl-dev ppc64el 3.4.0-1ubuntu2 [3141 kB] 232s Get:66 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq-dev ppc64el 17.2-1 [176 kB] 232s Get:67 http://ftpmaster.internal/ubuntu plucky/main ppc64el libecpg-dev ppc64el 17.2-1 [286 kB] 232s Get:68 http://ftpmaster.internal/ubuntu plucky/main ppc64el libncurses-dev ppc64el 6.5-2 [480 kB] 232s Get:69 http://ftpmaster.internal/ubuntu plucky/main ppc64el libtcl8.6 ppc64el 8.6.15+dfsg-2 [1201 kB] 232s Get:70 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxml2-dev ppc64el 2.12.7+dfsg+really2.9.14-0.2ubuntu2 [917 kB] 232s Get:71 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 232s Get:72 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-runtime ppc64el 1:19.1.6-1ubuntu1 [590 kB] 232s Get:73 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libpfm4 ppc64el 4.13.0+git83-g91970fe-1 [181 kB] 232s Get:74 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19 ppc64el 1:19.1.6-1ubuntu1 [19.5 MB] 233s Get:75 http://ftpmaster.internal/ubuntu plucky/main ppc64el libffi-dev ppc64el 3.4.6-1build1 [67.5 kB] 233s Get:76 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-tools ppc64el 1:19.1.6-1ubuntu1 [619 kB] 233s Get:77 http://ftpmaster.internal/ubuntu plucky/universe ppc64el llvm-19-dev ppc64el 1:19.1.6-1ubuntu1 [45.4 MB] 235s Get:78 http://ftpmaster.internal/ubuntu plucky/universe ppc64el locales-all ppc64el 2.40-4ubuntu1 [11.1 MB] 235s Get:79 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.2-1 [1464 kB] 235s Get:80 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.2-1 [17.1 MB] 236s Get:81 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-17 ppc64el 17.2-1 [1438 kB] 236s Get:82 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-server-dev-all ppc64el 267 [21.3 kB] 236s Get:83 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-plperl-17 ppc64el 17.2-1 [72.9 kB] 236s Get:84 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-plpython3-17 ppc64el 17.2-1 [78.1 kB] 236s Get:85 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-pltcl-17 ppc64el 17.2-1 [30.6 kB] 236s Get:86 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-all all 267 [1710 B] 236s Get:87 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-doc-17 all 17.2-1 [2122 kB] 236s Get:88 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-doc all 17+267 [12.2 kB] 236s Preconfiguring packages ... 236s Fetched 188 MB in 9s (21.3 MB/s) 236s Selecting previously unselected package libjson-perl. 237s (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 ... 74045 files and directories currently installed.) 237s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 237s Unpacking libjson-perl (4.10000-1) ... 237s Selecting previously unselected package libio-pty-perl. 237s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 237s Unpacking libio-pty-perl (1:1.20-1build3) ... 237s Selecting previously unselected package libipc-run-perl. 237s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 237s Unpacking libipc-run-perl (20231003.0-2) ... 237s Selecting previously unselected package postgresql-client-common. 237s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 237s Unpacking postgresql-client-common (267) ... 237s Selecting previously unselected package ssl-cert. 237s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 237s Unpacking ssl-cert (1.1.3ubuntu1) ... 237s Selecting previously unselected package postgresql-common. 237s Preparing to unpack .../05-postgresql-common_267_all.deb ... 237s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 237s Unpacking postgresql-common (267) ... 237s Selecting previously unselected package m4. 237s Preparing to unpack .../06-m4_1.4.19-4build1_ppc64el.deb ... 237s Unpacking m4 (1.4.19-4build1) ... 237s Selecting previously unselected package autoconf. 237s Preparing to unpack .../07-autoconf_2.72-3_all.deb ... 237s Unpacking autoconf (2.72-3) ... 237s Selecting previously unselected package autotools-dev. 237s Preparing to unpack .../08-autotools-dev_20220109.1_all.deb ... 237s Unpacking autotools-dev (20220109.1) ... 237s Selecting previously unselected package automake. 237s Preparing to unpack .../09-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 237s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 237s Selecting previously unselected package autopoint. 237s Preparing to unpack .../10-autopoint_0.22.5-3_all.deb ... 237s Unpacking autopoint (0.22.5-3) ... 237s Selecting previously unselected package libisl23:ppc64el. 237s Preparing to unpack .../11-libisl23_0.27-1_ppc64el.deb ... 237s Unpacking libisl23:ppc64el (0.27-1) ... 237s Selecting previously unselected package libmpc3:ppc64el. 237s Preparing to unpack .../12-libmpc3_1.3.1-1build2_ppc64el.deb ... 237s Unpacking libmpc3:ppc64el (1.3.1-1build2) ... 237s Selecting previously unselected package cpp-14-powerpc64le-linux-gnu. 237s Preparing to unpack .../13-cpp-14-powerpc64le-linux-gnu_14.2.0-12ubuntu1_ppc64el.deb ... 237s Unpacking cpp-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 237s Selecting previously unselected package cpp-14. 237s Preparing to unpack .../14-cpp-14_14.2.0-12ubuntu1_ppc64el.deb ... 237s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package cpp-powerpc64le-linux-gnu. 238s Preparing to unpack .../15-cpp-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 238s Unpacking cpp-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 238s Selecting previously unselected package cpp. 238s Preparing to unpack .../16-cpp_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 238s Unpacking cpp (4:14.1.0-2ubuntu1) ... 238s Selecting previously unselected package libcc1-0:ppc64el. 238s Preparing to unpack .../17-libcc1-0_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libcc1-0:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libgomp1:ppc64el. 238s Preparing to unpack .../18-libgomp1_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libgomp1:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libitm1:ppc64el. 238s Preparing to unpack .../19-libitm1_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libitm1:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libasan8:ppc64el. 238s Preparing to unpack .../20-libasan8_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libasan8:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package liblsan0:ppc64el. 238s Preparing to unpack .../21-liblsan0_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking liblsan0:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libtsan2:ppc64el. 238s Preparing to unpack .../22-libtsan2_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libtsan2:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libubsan1:ppc64el. 238s Preparing to unpack .../23-libubsan1_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libubsan1:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libquadmath0:ppc64el. 238s Preparing to unpack .../24-libquadmath0_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libquadmath0:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package libgcc-14-dev:ppc64el. 238s Preparing to unpack .../25-libgcc-14-dev_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking libgcc-14-dev:ppc64el (14.2.0-12ubuntu1) ... 238s Selecting previously unselected package gcc-14-powerpc64le-linux-gnu. 238s Preparing to unpack .../26-gcc-14-powerpc64le-linux-gnu_14.2.0-12ubuntu1_ppc64el.deb ... 238s Unpacking gcc-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 239s Selecting previously unselected package gcc-14. 239s Preparing to unpack .../27-gcc-14_14.2.0-12ubuntu1_ppc64el.deb ... 239s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 239s Selecting previously unselected package gcc-powerpc64le-linux-gnu. 239s Preparing to unpack .../28-gcc-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 239s Unpacking gcc-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 239s Selecting previously unselected package gcc. 239s Preparing to unpack .../29-gcc_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 239s Unpacking gcc (4:14.1.0-2ubuntu1) ... 239s Selecting previously unselected package libstdc++-14-dev:ppc64el. 239s Preparing to unpack .../30-libstdc++-14-dev_14.2.0-12ubuntu1_ppc64el.deb ... 239s Unpacking libstdc++-14-dev:ppc64el (14.2.0-12ubuntu1) ... 239s Selecting previously unselected package g++-14-powerpc64le-linux-gnu. 239s Preparing to unpack .../31-g++-14-powerpc64le-linux-gnu_14.2.0-12ubuntu1_ppc64el.deb ... 239s Unpacking g++-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 239s Selecting previously unselected package g++-14. 239s Preparing to unpack .../32-g++-14_14.2.0-12ubuntu1_ppc64el.deb ... 239s Unpacking g++-14 (14.2.0-12ubuntu1) ... 239s Selecting previously unselected package g++-powerpc64le-linux-gnu. 239s Preparing to unpack .../33-g++-powerpc64le-linux-gnu_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 239s Unpacking g++-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 239s Selecting previously unselected package g++. 239s Preparing to unpack .../34-g++_4%3a14.1.0-2ubuntu1_ppc64el.deb ... 239s Unpacking g++ (4:14.1.0-2ubuntu1) ... 239s Selecting previously unselected package build-essential. 239s Preparing to unpack .../35-build-essential_12.10ubuntu1_ppc64el.deb ... 239s Unpacking build-essential (12.10ubuntu1) ... 239s Selecting previously unselected package libclang-cpp19. 239s Preparing to unpack .../36-libclang-cpp19_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 239s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 240s Selecting previously unselected package libgc1:ppc64el. 240s Preparing to unpack .../37-libgc1_1%3a8.2.8-1_ppc64el.deb ... 240s Unpacking libgc1:ppc64el (1:8.2.8-1) ... 240s Selecting previously unselected package libobjc4:ppc64el. 240s Preparing to unpack .../38-libobjc4_14.2.0-12ubuntu1_ppc64el.deb ... 240s Unpacking libobjc4:ppc64el (14.2.0-12ubuntu1) ... 240s Selecting previously unselected package libobjc-14-dev:ppc64el. 240s Preparing to unpack .../39-libobjc-14-dev_14.2.0-12ubuntu1_ppc64el.deb ... 240s Unpacking libobjc-14-dev:ppc64el (14.2.0-12ubuntu1) ... 240s Selecting previously unselected package libclang-common-19-dev:ppc64el. 240s Preparing to unpack .../40-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 240s Unpacking libclang-common-19-dev:ppc64el (1:19.1.6-1ubuntu1) ... 240s Selecting previously unselected package llvm-19-linker-tools. 240s Preparing to unpack .../41-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 240s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 240s Selecting previously unselected package clang-19. 240s Preparing to unpack .../42-clang-19_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 240s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 241s Selecting previously unselected package libdebhelper-perl. 241s Preparing to unpack .../43-libdebhelper-perl_13.20ubuntu1_all.deb ... 241s Unpacking libdebhelper-perl (13.20ubuntu1) ... 241s Selecting previously unselected package libtool. 241s Preparing to unpack .../44-libtool_2.4.7-8_all.deb ... 241s Unpacking libtool (2.4.7-8) ... 241s Selecting previously unselected package dh-autoreconf. 241s Preparing to unpack .../45-dh-autoreconf_20_all.deb ... 241s Unpacking dh-autoreconf (20) ... 241s Selecting previously unselected package libarchive-zip-perl. 241s Preparing to unpack .../46-libarchive-zip-perl_1.68-1_all.deb ... 241s Unpacking libarchive-zip-perl (1.68-1) ... 241s Selecting previously unselected package libfile-stripnondeterminism-perl. 241s Preparing to unpack .../47-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 241s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 241s Selecting previously unselected package dh-strip-nondeterminism. 241s Preparing to unpack .../48-dh-strip-nondeterminism_1.14.0-1_all.deb ... 241s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 241s Selecting previously unselected package debugedit. 241s Preparing to unpack .../49-debugedit_1%3a5.1-1_ppc64el.deb ... 241s Unpacking debugedit (1:5.1-1) ... 241s Selecting previously unselected package dwz. 241s Preparing to unpack .../50-dwz_0.15-1build6_ppc64el.deb ... 241s Unpacking dwz (0.15-1build6) ... 241s Selecting previously unselected package gettext. 241s Preparing to unpack .../51-gettext_0.22.5-3_ppc64el.deb ... 241s Unpacking gettext (0.22.5-3) ... 241s Selecting previously unselected package intltool-debian. 241s Preparing to unpack .../52-intltool-debian_0.35.0+20060710.6_all.deb ... 241s Unpacking intltool-debian (0.35.0+20060710.6) ... 241s Selecting previously unselected package po-debconf. 241s Preparing to unpack .../53-po-debconf_1.0.21+nmu1_all.deb ... 241s Unpacking po-debconf (1.0.21+nmu1) ... 241s Selecting previously unselected package debhelper. 241s Preparing to unpack .../54-debhelper_13.20ubuntu1_all.deb ... 241s Unpacking debhelper (13.20ubuntu1) ... 241s Selecting previously unselected package emacsen-common. 241s Preparing to unpack .../55-emacsen-common_3.0.5_all.deb ... 241s Unpacking emacsen-common (3.0.5) ... 241s Selecting previously unselected package dictionaries-common. 241s Preparing to unpack .../56-dictionaries-common_1.30.2_all.deb ... 241s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 241s Unpacking dictionaries-common (1.30.2) ... 241s Selecting previously unselected package libfakeroot:ppc64el. 241s Preparing to unpack .../57-libfakeroot_1.36.2-1_ppc64el.deb ... 241s Unpacking libfakeroot:ppc64el (1.36.2-1) ... 241s Selecting previously unselected package fakeroot. 241s Preparing to unpack .../58-fakeroot_1.36.2-1_ppc64el.deb ... 241s Unpacking fakeroot (1.36.2-1) ... 241s Selecting previously unselected package hunspell-en-us. 241s Preparing to unpack .../59-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 241s Unpacking hunspell-en-us (1:2020.12.07-3) ... 241s Selecting previously unselected package libpgtypes3:ppc64el. 241s Preparing to unpack .../60-libpgtypes3_17.2-1_ppc64el.deb ... 241s Unpacking libpgtypes3:ppc64el (17.2-1) ... 241s Selecting previously unselected package libpq5:ppc64el. 241s Preparing to unpack .../61-libpq5_17.2-1_ppc64el.deb ... 241s Unpacking libpq5:ppc64el (17.2-1) ... 241s Selecting previously unselected package libecpg6:ppc64el. 241s Preparing to unpack .../62-libecpg6_17.2-1_ppc64el.deb ... 241s Unpacking libecpg6:ppc64el (17.2-1) ... 241s Selecting previously unselected package libecpg-compat3:ppc64el. 241s Preparing to unpack .../63-libecpg-compat3_17.2-1_ppc64el.deb ... 241s Unpacking libecpg-compat3:ppc64el (17.2-1) ... 241s Selecting previously unselected package libssl-dev:ppc64el. 241s Preparing to unpack .../64-libssl-dev_3.4.0-1ubuntu2_ppc64el.deb ... 241s Unpacking libssl-dev:ppc64el (3.4.0-1ubuntu2) ... 241s Selecting previously unselected package libpq-dev. 241s Preparing to unpack .../65-libpq-dev_17.2-1_ppc64el.deb ... 241s Unpacking libpq-dev (17.2-1) ... 242s Selecting previously unselected package libecpg-dev. 242s Preparing to unpack .../66-libecpg-dev_17.2-1_ppc64el.deb ... 242s Unpacking libecpg-dev (17.2-1) ... 242s Selecting previously unselected package libncurses-dev:ppc64el. 242s Preparing to unpack .../67-libncurses-dev_6.5-2_ppc64el.deb ... 242s Unpacking libncurses-dev:ppc64el (6.5-2) ... 242s Selecting previously unselected package libtcl8.6:ppc64el. 242s Preparing to unpack .../68-libtcl8.6_8.6.15+dfsg-2_ppc64el.deb ... 242s Unpacking libtcl8.6:ppc64el (8.6.15+dfsg-2) ... 242s Selecting previously unselected package libxml2-dev:ppc64el. 242s Preparing to unpack .../69-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu2_ppc64el.deb ... 242s Unpacking libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 242s Selecting previously unselected package libxslt1.1:ppc64el. 242s Preparing to unpack .../70-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 242s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 242s Selecting previously unselected package llvm-19-runtime. 242s Preparing to unpack .../71-llvm-19-runtime_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 242s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 242s Selecting previously unselected package libpfm4:ppc64el. 242s Preparing to unpack .../72-libpfm4_4.13.0+git83-g91970fe-1_ppc64el.deb ... 242s Unpacking libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 242s Selecting previously unselected package llvm-19. 242s Preparing to unpack .../73-llvm-19_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 242s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 242s Selecting previously unselected package libffi-dev:ppc64el. 242s Preparing to unpack .../74-libffi-dev_3.4.6-1build1_ppc64el.deb ... 242s Unpacking libffi-dev:ppc64el (3.4.6-1build1) ... 242s Selecting previously unselected package llvm-19-tools. 242s Preparing to unpack .../75-llvm-19-tools_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 242s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 242s Selecting previously unselected package llvm-19-dev. 242s Preparing to unpack .../76-llvm-19-dev_1%3a19.1.6-1ubuntu1_ppc64el.deb ... 242s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 245s Selecting previously unselected package locales-all. 245s Preparing to unpack .../77-locales-all_2.40-4ubuntu1_ppc64el.deb ... 245s Unpacking locales-all (2.40-4ubuntu1) ... 248s Selecting previously unselected package postgresql-client-17. 248s Preparing to unpack .../78-postgresql-client-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-client-17 (17.2-1) ... 248s Selecting previously unselected package postgresql-17. 248s Preparing to unpack .../79-postgresql-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-17 (17.2-1) ... 248s Selecting previously unselected package postgresql-server-dev-17. 248s Preparing to unpack .../80-postgresql-server-dev-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-server-dev-17 (17.2-1) ... 248s Selecting previously unselected package postgresql-server-dev-all:ppc64el. 248s Preparing to unpack .../81-postgresql-server-dev-all_267_ppc64el.deb ... 248s Unpacking postgresql-server-dev-all:ppc64el (267) ... 248s Selecting previously unselected package postgresql-plperl-17. 248s Preparing to unpack .../82-postgresql-plperl-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-plperl-17 (17.2-1) ... 248s Selecting previously unselected package postgresql-plpython3-17. 248s Preparing to unpack .../83-postgresql-plpython3-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-plpython3-17 (17.2-1) ... 248s Selecting previously unselected package postgresql-pltcl-17. 248s Preparing to unpack .../84-postgresql-pltcl-17_17.2-1_ppc64el.deb ... 248s Unpacking postgresql-pltcl-17 (17.2-1) ... 249s Selecting previously unselected package postgresql-all. 249s Preparing to unpack .../85-postgresql-all_267_all.deb ... 249s Unpacking postgresql-all (267) ... 249s Selecting previously unselected package postgresql-doc-17. 249s Preparing to unpack .../86-postgresql-doc-17_17.2-1_all.deb ... 249s Unpacking postgresql-doc-17 (17.2-1) ... 249s Selecting previously unselected package postgresql-doc. 249s Preparing to unpack .../87-postgresql-doc_17+267_all.deb ... 249s Unpacking postgresql-doc (17+267) ... 249s Setting up libpgtypes3:ppc64el (17.2-1) ... 249s Setting up libncurses-dev:ppc64el (6.5-2) ... 249s Setting up libio-pty-perl (1:1.20-1build3) ... 249s Setting up libclang-common-19-dev:ppc64el (1:19.1.6-1ubuntu1) ... 249s Setting up libarchive-zip-perl (1.68-1) ... 249s Setting up libdebhelper-perl (13.20ubuntu1) ... 249s Setting up postgresql-doc-17 (17.2-1) ... 249s 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 249s Setting up libpq5:ppc64el (17.2-1) ... 249s Setting up m4 (1.4.19-4build1) ... 249s Setting up libgomp1:ppc64el (14.2.0-12ubuntu1) ... 249s Setting up libffi-dev:ppc64el (3.4.6-1build1) ... 249s Setting up locales-all (2.40-4ubuntu1) ... 249s Setting up libfakeroot:ppc64el (1.36.2-1) ... 249s Setting up fakeroot (1.36.2-1) ... 249s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 249s Setting up autotools-dev (20220109.1) ... 249s Setting up libxml2-dev:ppc64el (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 249s Setting up libpfm4:ppc64el (4.13.0+git83-g91970fe-1) ... 249s Setting up emacsen-common (3.0.5) ... 249s Setting up ssl-cert (1.1.3ubuntu1) ... 250s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 250s Setting up libquadmath0:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up libssl-dev:ppc64el (3.4.0-1ubuntu2) ... 250s Setting up libmpc3:ppc64el (1.3.1-1build2) ... 250s Setting up libtcl8.6:ppc64el (8.6.15+dfsg-2) ... 250s Setting up autopoint (0.22.5-3) ... 250s Setting up libipc-run-perl (20231003.0-2) ... 250s Setting up libgc1:ppc64el (1:8.2.8-1) ... 250s Setting up autoconf (2.72-3) ... 250s Setting up libubsan1:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up dwz (0.15-1build6) ... 250s Setting up libasan8:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up libjson-perl (4.10000-1) ... 250s Setting up postgresql-doc (17+267) ... 250s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 250s Setting up debugedit (1:5.1-1) ... 250s Setting up libecpg6:ppc64el (17.2-1) ... 250s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 250s Setting up libtsan2:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up libisl23:ppc64el (0.27-1) ... 250s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 250s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 250s Setting up libcc1-0:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up liblsan0:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up libitm1:ppc64el (14.2.0-12ubuntu1) ... 250s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 250s Setting up automake (1:1.16.5-1.3ubuntu1) ... 250s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 250s Setting up postgresql-client-common (267) ... 250s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 250s Setting up gettext (0.22.5-3) ... 250s Setting up libecpg-compat3:ppc64el (17.2-1) ... 250s Setting up dictionaries-common (1.30.2) ... 251s Setting up postgresql-client-17 (17.2-1) ... 251s 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 251s Setting up libpq-dev (17.2-1) ... 251s Setting up libobjc4:ppc64el (14.2.0-12ubuntu1) ... 251s Setting up libecpg-dev (17.2-1) ... 251s Setting up intltool-debian (0.35.0+20060710.6) ... 251s Setting up postgresql-common (267) ... 252s Creating config file /etc/postgresql-common/createcluster.conf with new version 252s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 252s en_us 252s Removing obsolete dictionary files: 253s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 253s Setting up cpp-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 253s Setting up cpp-14 (14.2.0-12ubuntu1) ... 253s Setting up dh-strip-nondeterminism (1.14.0-1) ... 253s Setting up hunspell-en-us (1:2020.12.07-3) ... 253s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 253s Setting up libgcc-14-dev:ppc64el (14.2.0-12ubuntu1) ... 253s Setting up libstdc++-14-dev:ppc64el (14.2.0-12ubuntu1) ... 253s Setting up cpp-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 253s Setting up gcc-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 253s Setting up postgresql-17 (17.2-1) ... 254s Creating new PostgreSQL cluster 17/main ... 254s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 254s The files belonging to this database system will be owned by user "postgres". 254s This user must also own the server process. 254s 254s The database cluster will be initialized with locale "C.UTF-8". 254s The default database encoding has accordingly been set to "UTF8". 254s The default text search configuration will be set to "english". 254s 254s Data page checksums are disabled. 254s 254s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 254s creating subdirectories ... ok 254s selecting dynamic shared memory implementation ... posix 254s selecting default "max_connections" ... 100 254s selecting default "shared_buffers" ... 128MB 254s selecting default time zone ... Etc/UTC 254s creating configuration files ... ok 254s running bootstrap script ... ok 255s performing post-bootstrap initialization ... ok 255s syncing data to disk ... ok 258s Setting up g++-14-powerpc64le-linux-gnu (14.2.0-12ubuntu1) ... 258s Setting up po-debconf (1.0.21+nmu1) ... 258s Setting up libobjc-14-dev:ppc64el (14.2.0-12ubuntu1) ... 258s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 258s Setting up gcc-14 (14.2.0-12ubuntu1) ... 258s Setting up gcc-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 258s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 258s Setting up postgresql-plpython3-17 (17.2-1) ... 258s Setting up postgresql-plperl-17 (17.2-1) ... 258s Setting up cpp (4:14.1.0-2ubuntu1) ... 259s Setting up g++-14 (14.2.0-12ubuntu1) ... 259s Setting up g++-powerpc64le-linux-gnu (4:14.1.0-2ubuntu1) ... 259s Setting up postgresql-pltcl-17 (17.2-1) ... 259s Setting up libtool (2.4.7-8) ... 259s Setting up gcc (4:14.1.0-2ubuntu1) ... 259s Setting up dh-autoreconf (20) ... 259s Setting up postgresql-server-dev-17 (17.2-1) ... 259s Setting up g++ (4:14.1.0-2ubuntu1) ... 259s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 259s Setting up build-essential (12.10ubuntu1) ... 259s Setting up postgresql-server-dev-all:ppc64el (267) ... 259s Setting up debhelper (13.20ubuntu1) ... 259s Setting up postgresql-all (267) ... 259s Processing triggers for install-info (7.1.1-1) ... 259s Processing triggers for libc-bin (2.40-4ubuntu1) ... 259s Processing triggers for systemd (257-2ubuntu1) ... 259s Processing triggers for man-db (2.13.0-1) ... 262s Processing triggers for dictionaries-common (1.30.2) ... 264s autopkgtest [05:57:35]: test run-testsuite: [----------------------- 265s ====== Running all tests with umask 077 ======= 265s ### PostgreSQL test 001_packages.t ### 265s 1..21 265s ok 1 - /etc/os-release exists 265s ok 2 - OS is ubuntu 265s ok 3 - OS version is 25.04 265s # PostgreSQL versions installed: 17 265s ok 4 - postgresql-17 installed 265s ok 5 - postgresql-plpython3-17 installed 265s ok 6 - postgresql-plperl-17 installed 266s ok 7 - postgresql-pltcl-17 installed 266s ok 8 - postgresql-server-dev-17 installed 266s ok 9 # skip No postgresql-contrib-17 package for version 17 266s # postgresql-doc-17 installed 266s ok 10 - At least one doc package installed 266s ok 11 - libecpg-dev installed 266s ok 12 - procps installed 266s ok 13 - netcat-openbsd installed 266s ok 14 - hunspell-en-us installed 266s ok 15 - system has a default UTF-8 locale 266s ok 16 - locale ru_RU exists 266s ok 17 - locale ru_RU.UTF-8 exists 266s ok 18 - user postgres in the UNIX group ssl-cert 266s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 266s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 266s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 266s ### End test 001_packages.t ### 266s 266s ### PostgreSQL test 002_existing_clusters.t ### 266s 1..8 266s # Cleanup 266s ok 1 - Cleanup: No clusters left behind 266s ok 2 - No postgres processes left behind 266s ok 3 - No files in /etc/postgresql left behind 266s ok 4 - No files in /var/lib/postgresql left behind 266s ok 5 - No files in /var/run/postgresql left behind 266s ok 6 - No files in /var/log/postgresql left behind 266s ok 7 - PostgreSQL TCP ports are closed 266s ok 8 - Next free port is 5432 266s ### End test 002_existing_clusters.t ### 266s 266s ### PostgreSQL test 003_alternatives.t ### 266s 1..9 266s # Newest PG version installed is 17 266s ok 1 - psql.1.gz link group 266s ok 2 - postmaster.1.gz link group does not exist 266s ok 3 - psql.1.gz alternative 266s ok 4 - pg_dump.1.gz alternative 266s ok 5 - postgres.1.gz alternative 266s ok 6 - pg_ctl.1.gz alternative 266s # Newest PG doc version installed is 17 266s ok 7 - SPI_connect.3.gz link group 266s ok 8 - SPI_connect.3.gz alternative 266s ok 9 - SPI_exec.3.gz alternative 266s ### End test 003_alternatives.t ### 266s 266s ### PostgreSQL test 005_PgCommon.t ### 266s 1..24 266s ok 1 - correctly parsed line 'local all postgres ident sameuser' 266s ok 2 - correctly parsed line 'local foo nobody trust' 266s ok 3 - correctly parsed line 'local foo nobody crypt' 266s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 266s ok 5 - correctly parsed line 'local foo,bar nobody ident' 266s ok 6 - correctly parsed line 'local all +foogrp password' 266s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 266s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 266s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 266s ok 10 - @expected_records has correct number of entries 266s ok 11 - returned read_pg_hba array has correct number of records 266s ok 12 - line 'foo all all md5' parsed as invalid 266s ok 13 - line 'local all all foo' parsed as invalid 266s ok 14 - line 'host all all foo' parsed as invalid 266s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 266s ok 16 - line 'host all all md5' parsed as invalid 266s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 266s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 266s ok 19 - read_conf_file returns empty dict for nonexisting file 266s ok 20 - read_conf_file() parsing 266s ok 21 - read_conf_file() parsing with include directives 266s ok 22 - set_conf_value 266s ok 23 - disable_conf_value 266s ok 24 - replace_conf_value 266s ### End test 005_PgCommon.t ### 266s 266s ### PostgreSQL test 006_next_free_port.t ### 266s 1..5 266s ok 1 - next_free_port is 5432 267s ok 2 - next_free_port detects localhost ipv4 socket 268s ok 3 - next_free_port detects wildcard ipv4 socket 269s ok 4 - next_free_port detects localhost ipv6 socket 270s ok 5 - next_free_port detects wildcard ipv6 socket 270s ### End test 006_next_free_port.t ### 270s 270s ### PostgreSQL test 007_pg_conftool.t ### 270s 1..41 270s # test without cluster 270s ok 1 - pg_conftool show all 270s ok 2 - correct output of pg_conftool show all 270s ok 3 - pg_conftool foo.conf show all 270s ok 4 - correct output of pg_conftool foo.conf show all 270s ok 5 - pg_conftool /tmp/Y3W2tq2g2h/different.conf show all 270s ok 6 - correct output of pg_conftool /tmp/Y3W2tq2g2h/different.conf show all 270s ok 7 - pg_conftool 9.7 main show all 270s ok 8 - correct output of pg_conftool 9.7 main show all 270s # test show 270s ok 9 - pg_conftool show all 270s ok 10 - correct output of pg_conftool show all 271s ok 11 - pg_conftool other.conf show all 271s ok 12 - correct output of pg_conftool other.conf show all 271s ok 13 - pg_conftool /tmp/Y3W2tq2g2h/different.conf show all 271s ok 14 - correct output of pg_conftool /tmp/Y3W2tq2g2h/different.conf show all 271s ok 15 - pg_conftool 17 main show all 271s ok 16 - correct output of pg_conftool 17 main show all 271s ok 17 - pg_conftool 17 main other.conf show all 271s ok 18 - correct output of pg_conftool 17 main other.conf show all 271s ok 19 - pg_conftool show a 271s ok 20 - correct output of pg_conftool show a 271s ok 21 - pg_conftool -s show a 271s ok 22 - correct output of pg_conftool -s show a 271s # test set 271s ok 23 - pg_conftool set c 7 271s ok 24 - correct output of pg_conftool set c 7 271s ok 25 - file contains new setting 271s ok 26 - pg_conftool set a 8 271s ok 27 - correct output of pg_conftool set a 8 271s ok 28 - file contains updated setting 271s ok 29 - pg_conftool /tmp/Y3W2tq2g2h/different.conf set a 9 271s ok 30 - correct output of pg_conftool /tmp/Y3W2tq2g2h/different.conf set a 9 271s ok 31 - file with path contains updated setting 271s # test remove 271s ok 32 - pg_conftool remove a 271s ok 33 - correct output of pg_conftool remove a 271s ok 34 - setting removed from file 271s ok 35 - pg_conftool /tmp/Y3W2tq2g2h/different.conf remove a 271s ok 36 - correct output of pg_conftool /tmp/Y3W2tq2g2h/different.conf remove a 271s ok 37 - setting removed from file with path 271s # test edit 271s ok 38 - pg_conftool edit 271s ok 39 - correct output of pg_conftool edit 271s ok 40 - pg_conftool /tmp/Y3W2tq2g2h/different.conf edit 271s ok 41 - correct output of pg_conftool /tmp/Y3W2tq2g2h/different.conf edit 271s ### End test 007_pg_conftool.t ### 271s 271s ### PostgreSQL test 010_defaultport_cluster.t ### 271s 1..14 271s ok 1 - psql --version 271s ok 2 - pg_wrapper selects highest available version number 271s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 271s ok 4 - connecting to localhost fails with no clusters 271s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 271s ok 6 - pg_wrapper uses host and port from PGCLUSTER 271s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 271s ok 8 - pg_wrapper uses --cluster from the command line 271s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 271s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 271s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 271s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 271s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 271s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 271s ### End test 010_defaultport_cluster.t ### 271s 271s ### PostgreSQL test 015_start_stop.t ### 272s 1..71 272s # We are running systemd 272s # Running tests for 17 272s # Cluster does not exist yet 272s ok 1 - cluster 17 main does not exist 272s ok 2 - service postgresql@17-main does not exist 272s ok 3 - systemctl start postgresql 272s ok 4 - cluster 17 main does not exist 272s ok 5 - service postgresql@17-main does not exist 272s ok 6 - systemctl start postgresql@17-main 272s ok 7 - cluster 17 main does not exist 272s ok 8 - service postgresql@17-main does not exist 272s # Start/stop postgresql using system tools 273s ok 9 - pg_createcluster 17 main 273s ok 10 - cluster 17 main is stopped 273s ok 11 - service postgresql@17-main is stopped 275s ok 12 - systemctl start postgresql 275s ok 13 - cluster 17 main is running 275s ok 14 - service postgresql@17-main is running 275s ok 15 - systemctl start postgresql 275s ok 16 - cluster 17 main is already running 275s ok 17 - service postgresql@17-main is already running 275s ok 18 - systemctl stop postgresql 281s ok 19 - cluster 17 main is stopped 281s ok 20 - service postgresql@17-main is stopped 281s ok 21 - systemctl stop postgresql 282s ok 22 - cluster 17 main is already stopped 282s ok 23 - service postgresql@17-main is already stopped 282s # Start/stop specific cluster using system tools 284s ok 24 - systemctl start postgresql@17-main 284s ok 25 - cluster 17 main is running 284s ok 26 - service postgresql@17-main is running 284s ok 27 - systemctl start postgresql@17-main 284s ok 28 - cluster 17 main is running 284s ok 29 - service postgresql@17-main is running 286s ok 30 - systemctl restart postgresql@17-main 286s ok 31 - cluster 17 main is running 286s ok 32 - service postgresql@17-main is running 287s ok 33 - systemctl stop postgresql@17-main 287s ok 34 - cluster 17 main is stopped 287s ok 35 - service postgresql@17-main is stopped 287s ok 36 - systemctl stop postgresql@17-main 287s ok 37 - cluster 17 main is already stopped 287s ok 38 - service postgresql@17-main is already stopped 289s ok 39 - pg_dropcluster 17 main 289s ok 40 - cluster 17 main does not exist 289s ok 41 - service postgresql@17-main does not exist 289s # Start/stop specific cluster using pg_*cluster 289s ok 42 - pg_ctlcluster start 17 main 289s ok 43 - cluster 17 main does not exist 289s ok 44 - service postgresql@17-main does not exist 292s ok 45 - pg_createcluster 17 main --start 292s ok 46 - cluster 17 main is running 292s ok 47 - service postgresql@17-main is running 292s ok 48 - pg_ctlcluster 17 main start 292s ok 49 - cluster 17 main is already running 292s ok 50 - service postgresql@17-main is already running 295s ok 51 - pg_ctlcluster 17-main restart 295s ok 52 - cluster 17 main is running 295s ok 53 - service postgresql@17-main is running 295s ok 54 - pg_ctlcluster 17 main stop 295s ok 55 - cluster 17 main is stopped 295s ok 56 - service postgresql@17-main is stopped 295s ok 57 - pg_ctlcluster 17 main stop 295s ok 58 - cluster 17 main is already stopped 296s ok 59 - service postgresql@17-main is already stopped 298s ok 60 - pg_ctlcluster start 17-main 298s ok 61 - cluster 17 main is running 298s ok 62 - service postgresql@17-main is running 300s ok 63 - pg_dropcluster 17 main --stop 300s # Cleanup 300s ok 64 - Cleanup: No clusters left behind 300s ok 65 - No postgres processes left behind 300s ok 66 - No files in /etc/postgresql left behind 300s ok 67 - No files in /var/lib/postgresql left behind 300s ok 68 - No files in /var/run/postgresql left behind 300s ok 69 - No files in /var/log/postgresql left behind 300s ok 70 - PostgreSQL TCP ports are closed 300s ok 71 - Next free port is 5432 300s ### End test 015_start_stop.t ### 300s 300s ### PostgreSQL test 020_create_sql_remove.t ### 300s 1..141 300s # Running tests for 17 303s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.Dr2yE8 303s ok 2 - pg_createcluster 17 main 303s ok 3 - Socket and pid file are in /var/run/postgresql/ 303s ok 4 - xlog/wal directory /tmp/17.xlog.Dr2yE8 was created 303s ok 5 - local method in pg_hba.conf is peer 303s ok 6 - host method in pg_hba.conf is scram-sha-256 303s ok 7 - Exactly one postgres master process running 306s ok 8 - pg_ctlcluster 17 main restart 306s ok 9 - cluster restarts with new environment file 306s ok 10 - Exactly one postgres master process running 306s ok 11 - correct value of PGEXTRAVAR1 in environment 306s ok 12 - correct value of PGEXTRAVAR2 in environment 306s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 306s ok 14 - createdb --version 306s ok 15 - pg_wrapper+createdb selects version number of cluster 306s ok 16 - psql --version 306s ok 17 - pg_wrapper+psql selects version 17 306s ok 18 - pg_lscluster reports online cluster on port 5432 306s ok 19 - log file is actually used 306s ok 20 - /etc/postgresql is owned by user "postgres" 306s ok 21 - version configuration directory file is owned by user "postgres" 306s ok 22 - configuration directory file is owned by user "postgres" 306s ok 23 - version data directory file is owned by user "postgres" 306s ok 24 - data directory file is owned by user "postgres" 306s ok 25 - log file has 0640 permissions 306s ok 26 - log file is owned by user "postgres" 306s ok 27 - log file is owned by group "adm" 306s ok 28 - no log symlink by default 306s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 306s ok 30 - pg_lsclusters -h 306s ok 31 - correct output of pg_lsclusters -h 306s ok 32 - stopping cluster 309s ok 33 - restarting cluster with nondefault log symlink 309s ok 34 - log target is used as log file 309s ok 35 - default log is not used 309s ok 36 - pg_lsclusters -h 309s ok 37 - correct output of pg_lsclusters -h 309s ok 38 - stopping cluster 312s ok 39 - restarting cluster with explicitly configured log file 312s ok 40 - default log is not used 312s ok 41 - log symlink target is used for startup message 312s ok 42 - exactly one log file 312s ok 43 - custom log is actually used 312s ok 44 - pg_lsclusters -h 312s ok 45 - correct output of pg_lsclusters -h 312s ok 46 - stopping cluster 312s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 312s ok 48 - /etc/postgres-hack was not created 314s ok 49 - restarting cluster 314s ok 50 - ps -o tty -U postgres h 314s ok 51 - postgres processes do not have an associated terminal 314s ok 52 - Server is linked with SSL support 314s ok 53 - SSL is enabled in postgresql.conf 314s ok 54 - psql -l fails for nobody 314s ok 55 - createuser nobody 315s ok 56 - createdb nobodydb 315s ok 57 - psql -ltA succeeds for nobody 315s ok 58 - psql -ltA output 315s ok 59 - SQL command: create table 315s ok 60 - SQL command: insert into table values 315s ok 61 - SQL command: insert into table values 315s ok 62 - primary key violation 315s ok 63 - psql -tAc "select * from phone order by name" nobodydb 315s ok 64 - SQL command output: select -tA 315s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 315s ok 66 - SQL command output: select -tx 315s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 315s ok 68 - SQL command output: select -tAx 315s ok 69 - CREATE EXTENSION plperlu fails for user nobody 315s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 315s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 315s ok 72 - creating PL/PerlU function as user nobody fails 315s ok 73 - creating unsafe PL/Perl function as user postgres fails 315s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 315s ok 75 - creating PL/PerlU function as user postgres succeeds 315s ok 76 - psql nobodydb -Atc "select read_file()" 315s ok 77 - calling PL/PerlU function 315s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 315s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 315s ok 80 - creating unsafe PL/Perl function as user nobody fails 316s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 316s ok 82 - creating PL/Perl function as user nobody succeeds 316s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 316s ok 84 - calling PL/Perl function 316s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 316s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 316s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 316s ok 88 - creating PL/Python3 function as user postgres succeeds 316s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 316s ok 90 - calling PL/Python function 316s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 316s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 316s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 316s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 316s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 316s ok 96 - creating PL/Tcl function as user nobody succeeds 316s 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;" 316s ok 98 - creating PL/TclU function as user postgres succeeds 316s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 316s ok 100 - calling PL/Tcl function 316s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 316s ok 102 - calling PL/TclU function 316s ok 103 - stopping cluster 316s ok 104 - pg_ctlcluster 17 main start 316s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 319s ok 106 - pg_ctlcluster 17 main start 319s ok 107 - cluster restarts with pgdata symlink 319s ok 108 - postgres master has OOM killer protection 319s ok 109 - postgres client backend has no OOM adjustment 319s ok 110 - ps h 6572 319s ok 111 - process title is idle 320s ok 112 - ps h 6572 320s ok 113 - process title is idle in transaction 320s ok 114 - stopping cluster 322s ok 115 - starting cluster as postgres works without a log file 322s ok 116 - log file got recreated and used 322s ok 117 - creating a directory in spc2 322s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.5lPBSM'" 322s ok 119 - creating tablespace spc1 322s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 322s ok 121 - creating a table in spc1 322s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.gILx8d'" 322s ok 123 - creating tablespace spc2 322s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 322s ok 125 - creating a table in spc2 322s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 322s ok 127 - Correct apt NeverAutoRemove config 324s ok 128 - pg_dropcluster removes cluster 324s ok 129 - xlog/wal directory /tmp/17.xlog.Dr2yE8 was deleted 324s ok 130 - tablespace spc1 was emptied 324s ok 131 - tablespace spc2 was emptied 324s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 324s ok 133 - Correct apt NeverAutoRemove config 324s # Cleanup 324s ok 134 - Cleanup: No clusters left behind 324s ok 135 - No postgres processes left behind 324s ok 136 - No files in /etc/postgresql left behind 324s ok 137 - No files in /var/lib/postgresql left behind 324s ok 138 - No files in /var/run/postgresql left behind 324s ok 139 - No files in /var/log/postgresql left behind 324s ok 140 - PostgreSQL TCP ports are closed 324s ok 141 - Next free port is 5432 324s ### End test 020_create_sql_remove.t ### 324s 324s ### PostgreSQL test 021_pg_renamecluster.t ### 325s 1..20 328s ok 1 - pg_createcluster 17 main 331s ok 2 - pg_renamecluster 17 main donau 331s ok 3 - psql -tAc "show data_directory" 331s ok 4 - cluster is running and data_directory was moved 331s ok 5 - pg_hba.conf location updated 331s ok 6 - pg_ident.conf location updated 331s ok 7 - external_pid_file location updated 331s ok 8 - external_pid_file exists 331s ok 9 # skip no stats_temp_directory in 17 331s ok 10 # skip no stats_temp_directory in 17 331s ok 11 - cluster_name is updated 333s ok 12 - pg_dropcluster removes cluster 333s # Cleanup 333s ok 13 - Cleanup: No clusters left behind 333s ok 14 - No postgres processes left behind 333s ok 15 - No files in /etc/postgresql left behind 333s ok 16 - No files in /var/lib/postgresql left behind 333s ok 17 - No files in /var/run/postgresql left behind 333s ok 18 - No files in /var/log/postgresql left behind 333s ok 19 - PostgreSQL TCP ports are closed 333s ok 20 - Next free port is 5432 333s ### End test 021_pg_renamecluster.t ### 333s 333s ### PostgreSQL test 022_recovery.t ### 333s 1..17 333s # Running tests for 17 337s ok 1 - pg_createcluster 17 main --start >/dev/null 337s ok 2 - pg_ctlcluster 17 main stop -m i 339s ok 3 - pg_ctlcluster 17 main start 339s ok 4 - psql -c '' 340s ok 5 - pg_ctlcluster 17 main stop -m i 340s ok 6 - create write-protected file in data directory 342s ok 7 - pg_ctlcluster 17 main start 342s ok 8 - psql -c '' 346s ok 9 - pg_dropcluster removes cluster 346s # Cleanup 346s ok 10 - Cleanup: No clusters left behind 346s ok 11 - No postgres processes left behind 346s ok 12 - No files in /etc/postgresql left behind 346s ok 13 - No files in /var/lib/postgresql left behind 346s ok 14 - No files in /var/run/postgresql left behind 346s ok 15 - No files in /var/log/postgresql left behind 346s ok 16 - PostgreSQL TCP ports are closed 346s ok 17 - Next free port is 5432 346s ### End test 022_recovery.t ### 346s 346s ### PostgreSQL test 025_logging.t ### 346s 1..55 346s # Logging to /var/log/syslog works 346s # Running tests for 17 348s ok 1 - pg_createcluster 17 main 348s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 348s ok 3 - psql -qc "'foobar_17_7790'" 348s ok 4 - log an error 349s ok 5 - grep --binary-files=text foobar_17_7790 /var/log/postgresql/postgresql-17-main.log 349s ok 6 - error appears in logfile 349s ok 7 - pg_conftool 17 main set log_destination syslog 349s ok 8 - set log_destination syslog 349s ok 9 - pg_ctlcluster 17 main reload 349s ok 10 - 17 main reload 349s ok 11 - psql -Atc "show log_destination" 349s ok 12 - log_destination is syslog 349s ok 13 - pg_lscluster reports syslog 349s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 349s ok 15 - error appears in /var/log/syslog 349s ok 16 - pg_conftool 17 main set logging_collector on 349s ok 17 - set logging_collector on 349s ok 18 - pg_conftool 17 main set log_destination csvlog 349s ok 19 - set log_destination csvlog 352s ok 20 - pg_ctlcluster 17 main restart 352s ok 21 - 17 main restart 352s ok 22 - psql -Atc "show logging_collector" 352s ok 23 - logging_collector is on 352s ok 24 - psql -Atc "show log_destination" 352s ok 25 - log_destination is csvlog 352s ok 26 - pg_lscluster reports csvlog 352s ok 27 - psql -qc "'barbaz_17_7790'" 352s ok 28 - log an error 353s ok 29 - grep --binary-files=text barbaz_17_7790 /var/lib/postgresql/17/main/log/*.csv 353s ok 30 - error appears in log/*.csv 353s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 353s ok 32 - set log_destination stderr,syslog,csvlog 353s ok 33 - pg_ctlcluster 17 main reload 353s ok 34 - 17 main reload 353s ok 35 - psql -Atc "show log_destination" 353s ok 36 - log_destination is stderr,syslog,csvlog 353s ok 37 - pg_lscluster reports stderr,syslog,csvlog 353s ok 38 - psql -qc "'moo_17_7790'" 353s ok 39 - log an error 353s ok 40 - grep --binary-files=text moo_17_7790 /var/lib/postgresql/17/main/log/*.log 353s ok 41 - error appears in log/*.log 354s ok 42 - grep --binary-files=text 'postgres.*moo_17_7790' /var/log/syslog 354s ok 43 - error appears in /var/log/syslog 354s ok 44 - grep --binary-files=text moo_17_7790 /var/lib/postgresql/17/main/log/*.csv 354s ok 45 - error appears in log/*.csv 356s ok 46 - pg_dropcluster 17 main --stop 356s ok 47 - pg_dropcluster removes cluster 356s # Cleanup 356s ok 48 - Cleanup: No clusters left behind 356s ok 49 - No postgres processes left behind 356s ok 50 - No files in /etc/postgresql left behind 356s ok 51 - No files in /var/lib/postgresql left behind 356s ok 52 - No files in /var/run/postgresql left behind 356s ok 53 - No files in /var/log/postgresql left behind 356s ok 54 - PostgreSQL TCP ports are closed 356s ok 55 - Next free port is 5432 356s ### End test 025_logging.t ### 356s 356s ### PostgreSQL test 027_jit.t ### 356s # 17 360s ok 1 - pg_createcluster 17 main --start 360s ok 2 - psql -Xatc 'show jit' 360s ok 3 - JIT is on by default 360s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 360s ok 5 - No JIT on cheap query 360s ok 6 - pg_conftool 17 main set seq_page_cost 100000 360s ok 7 - pg_conftool 17 main set random_page_cost 100000 360s ok 8 - pg_ctlcluster 17 main reload 360s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 360s ok 10 - Expensive query is JITed 362s ok 11 - pg_dropcluster --stop 17 main 362s # Cleanup 362s ok 12 - Cleanup: No clusters left behind 362s ok 13 - No postgres processes left behind 362s ok 14 - No files in /etc/postgresql left behind 362s ok 15 - No files in /var/lib/postgresql left behind 362s ok 16 - No files in /var/run/postgresql left behind 362s ok 17 - No files in /var/log/postgresql left behind 362s ok 18 - PostgreSQL TCP ports are closed 362s ok 19 - Next free port is 5432 362s 1..19 362s ### End test 027_jit.t ### 362s 362s ### PostgreSQL test 030_errors.t ### 362s 1..156 363s ok 1 - pg_lscluster reports cluster without binaries 364s ok 2 - pg_dropcluster 6.3 main 365s ok 3 - pg_createcluster --socketdir 365s ok 4 - pg_lsclusters -h 365s ok 5 - cluster was created 365s ok 6 - Port of created cluster is 5432 365s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 365s ok 8 - pg_createcluster on existing cluster 365s ok 9 - pg_lsclusters -h 365s ok 10 - original cluster still exists 365s ok 11 - pg_createcluster 17 test -p foo 365s ok 12 - pg_createcluster -p checks that port option is numeric 365s ok 13 - pg_createcluster 17 test -p 42 365s ok 14 - pg_createcluster -p checks valid port range 365s ok 15 - pg_ctlcluster 17 main start 365s ok 16 - pg_ctlcluster refuses to start root-owned cluster 366s ok 17 - pg_ctlcluster 17 main start 366s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 366s ok 19 - pg_ctlcluster 17 main start 366s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 366s ok 21 - pg_ctlcluster 17 main start 366s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 368s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 368s ok 24 - No sockets in /var/run/postgresql 368s ok 25 - Socket is in /tmp/postgresql-testsuite/ 368s ok 26 - cluster stops with custom unix_socket_dir 368s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 371s ok 28 - cluster starts after removing unix_socket_dir 371s ok 29 - Socket is in default dir /var/run/postgresql 371s ok 30 - No sockets in /tmp/postgresql-testsuite/ 371s ok 31 - pg_ctlcluster 17 main stop 371s ok 32 - pg_ctlcluster fails with corrupted PID file 371s ok 33 - pg_lsclusters -h 371s ok 34 - cluster is still online 371s ok 35 - pg_ctlcluster succeeds with restored PID file 371s ok 36 - pg_lsclusters -h 371s ok 37 - cluster is down 371s ok 38 - pg_ctlcluster 17 main stop 371s ok 39 - pg_ctlcluster stop fails on stopped cluster 373s ok 40 - pg_ctlcluster 17 main start 373s ok 41 - pg_ctlcluster succeeds with already existing PID file 373s ok 42 - pg_lsclusters -h 373s ok 43 - cluster is online 374s ok 44 - pg_ctlcluster stop succeeds 374s ok 45 - pg_lsclusters -h 374s ok 46 - cluster is down 374s ok 47 - no pid file left 374s ok 48 - pg_ctlcluster 17 main stop 374s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 374s ok 50 - pid file was cleaned up 374s ok 51 - pg_ctlcluster --force 17 main stop 374s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 374s ok 53 - pid file was cleaned up 374s ok 54 - pg_ctlcluster 17 main stop 374s ok 55 - pg_ctlcluster stop succeeds with stale PID file 374s ok 56 - pid file was cleaned up 374s ok 57 - pg_ctlcluster --force 17 main stop 374s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 374s ok 59 - pid file was cleaned up 374s ok 60 - pg_ctlcluster --force 17 main stop 374s ok 61 - pg_ctlcluster stop succeeds with empty PID file 374s ok 62 - pid file was cleaned up 376s ok 63 - pg_ctlcluster 17 main start 376s ok 64 - pg_ctlcluster succeeds with corrupted PID file 376s ok 65 - pg_lsclusters -h 376s ok 66 - cluster is online 376s ok 67 - pg_ctlcluster 17 main start 376s ok 68 - pg_ctlcluster start fails on running cluster 377s ok 69 - pg_ctlcluster stop 377s ok 70 - pg_ctlcluster 17 main start 377s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 377s ok 72 - pg_ctlcluster 17 main stop 377s ok 73 - stopping cluster 383s ok 74 - pg_ctlcluster 17 main start 383s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 383s ok 76 - pg_ctlcluster 17 main stop 383s ok 77 - stopping cluster 383s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 383s ok 79 - pg_dropcluster 17 main 383s ok 80 - pg_dropcluster works as user postgres 385s ok 81 - pg_createcluster succeeds 385s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 385s ok 83 - proper error message for nonexisting /var/lib/postgresql 387s ok 84 - pg_ctlcluster 17 main start 387s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 387s ok 86 - pg_ctlcluster 17 main stop 387s ok 87 - stopping cluster 389s ok 88 - pg_createcluster other 391s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 393s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 393s ok 91 393s ok 92 - pg_ctlcluster 17 other start 393s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 393s ok 94 - pg_ctlcluster 17 main stop 393s ok 95 - stopping main cluster 396s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 398s ok 97 - pg_dropcluster other 400s ok 98 - pg_dropcluster 400s ok 99 - No sockets any more 400s ok 100 - 'pg_lsclusters 4.5 foo' fails 400s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 400s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 400s ok 103 - 'psql --cluster 4.5/foo' fails 400s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 400s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 400s ok 106 - 'psql --cluster 17/foo' fails 400s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 400s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 400s ok 109 - 'pg_dropcluster 4.5 foo' fails 400s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 400s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 400s ok 112 - 'pg_dropcluster 17 foo' fails 400s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 400s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 400s ok 115 - 'pg_upgradecluster 4.5 foo' fails 400s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 400s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 400s ok 118 - 'pg_upgradecluster 17 foo' fails 400s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 400s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 400s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 400s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 400s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 400s ok 124 - 'pg_ctlcluster 17 foo stop' fails 400s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 400s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 400s # Cleanup 400s ok 127 - Cleanup: No clusters left behind 400s ok 128 - No postgres processes left behind 400s ok 129 - No files in /etc/postgresql left behind 400s ok 130 - No files in /var/lib/postgresql left behind 400s ok 131 - No files in /var/run/postgresql left behind 400s ok 132 - No files in /var/log/postgresql left behind 400s ok 133 - PostgreSQL TCP ports are closed 400s ok 134 - Next free port is 5432 402s ok 135 - pg_dropcluster 17 broken 402s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 402s # Cleanup 402s ok 137 - Cleanup: No clusters left behind 402s ok 138 - No postgres processes left behind 402s ok 139 - No files in /etc/postgresql left behind 402s ok 140 - No files in /var/lib/postgresql left behind 402s ok 141 - No files in /var/run/postgresql left behind 402s ok 142 - No files in /var/log/postgresql left behind 402s ok 143 - PostgreSQL TCP ports are closed 402s ok 144 - Next free port is 5432 404s ok 145 - pg_dropcluster 17 broken 404s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 404s ok 147 - /etc/postgresql/17 was removed 404s ok 148 - /var/lib/postgresql/17 was removed 404s # Cleanup 404s ok 149 - Cleanup: No clusters left behind 404s ok 150 - No postgres processes left behind 404s ok 151 - No files in /etc/postgresql left behind 404s ok 152 - No files in /var/lib/postgresql left behind 404s ok 153 - No files in /var/run/postgresql left behind 404s ok 154 - No files in /var/log/postgresql left behind 404s ok 155 - PostgreSQL TCP ports are closed 404s ok 156 - Next free port is 5432 404s ### End test 030_errors.t ### 404s 404s ### PostgreSQL test 031_errors_disk_full.t ### 404s 1..22 404s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 405s ok 1 - script failed 405s ok 2 - pg_createcluster fails due to insufficient disk space 405s ok 3 - does not leave files behind 405s # Cleanup 405s ok 4 - Cleanup: No clusters left behind 405s ok 5 - No postgres processes left behind 405s ok 6 - No files in /etc/postgresql left behind 405s ok 7 - No files in /var/lib/postgresql left behind 405s ok 8 - No files in /var/run/postgresql left behind 405s ok 9 - No files in /var/log/postgresql left behind 405s ok 10 - PostgreSQL TCP ports are closed 405s ok 11 - Next free port is 5432 405s # check disk full conditions on startup 409s ok 12 - script failed 409s ok 13 - pg_ctlcluster prints error message 409s ok 14 - log file has error message 409s # Cleanup 409s ok 15 - Cleanup: No clusters left behind 409s ok 16 - No postgres processes left behind 409s ok 17 - No files in /etc/postgresql left behind 409s ok 18 - No files in /var/lib/postgresql left behind 409s ok 19 - No files in /var/run/postgresql left behind 409s ok 20 - No files in /var/log/postgresql left behind 409s ok 21 - PostgreSQL TCP ports are closed 409s ok 22 - Next free port is 5432 409s ### End test 031_errors_disk_full.t ### 409s 409s ### PostgreSQL test 032_ssl_key_permissions.t ### 409s 1..22 409s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 409s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 409s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 409s # 17 (17.2-1) 410s ok 4 - pg_createcluster 17 main 410s ok 5 - pg_ctlcluster 17 main start 410s ok 6 - ssl key owned by nobody refused 411s ok 7 - pg_ctlcluster 17 main start 411s ok 8 - ssl key with permissions root:root 0644 refused 411s ok 9 - pg_ctlcluster 17 main start 411s ok 10 - ssl key with permissions postgres:postgres 0640 refused 413s ok 11 - pg_dropcluster 17 main --stop 413s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 413s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 413s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 413s # Cleanup 413s ok 15 - Cleanup: No clusters left behind 413s ok 16 - No postgres processes left behind 413s ok 17 - No files in /etc/postgresql left behind 413s ok 18 - No files in /var/lib/postgresql left behind 413s ok 19 - No files in /var/run/postgresql left behind 413s ok 20 - No files in /var/log/postgresql left behind 413s ok 21 - PostgreSQL TCP ports are closed 413s ok 22 - Next free port is 5432 413s ### End test 032_ssl_key_permissions.t ### 413s 413s ### PostgreSQL test 040_upgrade.t ### 413s 1..1 413s ok 1 - only one major version installed, skipping upgrade tests 413s ### End test 040_upgrade.t ### 413s 413s ### PostgreSQL test 041_upgrade_custompaths.t ### 413s 1..1 413s ok 1 - only one major version installed, skipping upgrade tests 413s ### End test 041_upgrade_custompaths.t ### 413s 413s ### PostgreSQL test 042_upgrade_rename.t ### 413s 1..15 413s # PostgreSQL 17 417s ok 1 - pg_createcluster 17 main --start 424s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 424s ok 3 - pg_lsclusters -h 424s ok 4 - correct output of pg_lsclusters -h 425s ok 5 - pg_dropcluster 17 main --stop 427s ok 6 - pg_dropcluster 17 upgr --stop 427s ok 7 - Cleaning pg_upgrade log files 427s # Cleanup 428s ok 8 - Cleanup: No clusters left behind 428s ok 9 - No postgres processes left behind 428s ok 10 - No files in /etc/postgresql left behind 428s ok 11 - No files in /var/lib/postgresql left behind 428s ok 12 - No files in /var/run/postgresql left behind 428s ok 13 - No files in /var/log/postgresql left behind 428s ok 14 - PostgreSQL TCP ports are closed 428s ok 15 - Next free port is 5432 428s ### End test 042_upgrade_rename.t ### 428s 428s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 428s 1..1 428s ok 1 - only one major version installed, skipping upgrade tests 428s ### End test 043_upgrade_ssl_cert.t ### 428s 428s ### PostgreSQL test 045_backup.t ### 428s # We are running systemd 428s # PostgreSQL 17 428s # create cluster 431s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 431s ok 2 - pg_lsclusters -h 431s ok 3 - correct output of pg_lsclusters -h 431s ok 4 - pg_conftool 17 main set work_mem 11MB 432s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 432s ok 6 - psql -c 'alter database mydb set search_path=public' 432s ok 7 - psql -c 'create table foo (t text)' mydb 432s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 432s ok 9 - psql -c 'CREATE USER myuser' 432s ok 10 - psql -c 'grant create on database mydb to myuser' 432s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 432s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 432s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 432s # create directory 432s ok 14 - pg_backupcluster 17 main createdirectory 432s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 432s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 432s # dump 433s ok 17 - systemctl start pg_dump@17-main 433s ok 18 - dump created in /var/backups/postgresql/17-main/2025-01-17T060023Z.dump 433s ok 19 - /var/backups/postgresql/17-main/2025-01-17T060023Z.dump owned by uid postgres 433s ok 20 - /var/backups/postgresql/17-main/2025-01-17T060023Z.dump owned by gid postgres 433s # basebackup 433s ok 21 - systemctl start pg_receivewal@17-main 433s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 434s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 434s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 434s ok 25 - psql -c 'select pg_reload_conf()' 462s ok 26 - systemctl start pg_basebackup@17-main 462s ok 27 - dump created in /var/backups/postgresql/17-main/2025-01-17T060025Z.backup 462s ok 28 - /var/backups/postgresql/17-main/2025-01-17T060025Z.backup owned by uid postgres 462s ok 29 - /var/backups/postgresql/17-main/2025-01-17T060025Z.backup owned by gid postgres 462s # list 462s ok 30 - pg_backupcluster 17 main list 462s ok 31 - correct output of pg_backupcluster 17 main list 462s # more database changes 462s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 462s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 463s ok 34 - retrieve recovery timestamp 463s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 463s ok 36 - systemctl stop pg_receivewal@17-main 463s # restore /var/backups/postgresql/17-main/2025-01-17T060023Z.dump 465s ok 37 - pg_dropcluster 17 main --stop 470s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-17T060023Z.dump --start --datadir /var/lib/postgresql/17/snowflake 470s ok 39 - pg_lsclusters -h 470s ok 40 - correct output of pg_lsclusters -h 470s ok 41 - psql -XAtl 470s ok 42 - mydb locales 470s ok 43 - mydb grants 470s ok 44 - myicudb locales 470s ok 45 - psql -XAtc 'show work_mem' 470s ok 46 - correct output of psql -XAtc 'show work_mem' 470s ok 47 - psql -XAtc 'select * from foo' mydb 470s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 470s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 470s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 471s ok 51 - psql -XAtc '\drds' 471s ok 52 - correct output of psql -XAtc '\drds' 471s # restore /var/backups/postgresql/17-main/2025-01-17T060025Z.backup 473s ok 53 - pg_dropcluster 17 main --stop 477s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-17T060025Z.backup --start --datadir /var/lib/postgresql/17/snowflake 477s ok 55 - pg_lsclusters -h 477s ok 56 - correct output of pg_lsclusters -h 477s ok 57 - psql -XAtl 477s ok 58 - mydb locales 477s ok 59 - mydb grants 477s ok 60 - myicudb locales 477s ok 61 - psql -XAtc 'show work_mem' 477s ok 62 - correct output of psql -XAtc 'show work_mem' 477s ok 63 - psql -XAtc 'select * from foo' mydb 477s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 477s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 477s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 477s ok 67 - psql -XAtc '\drds' 477s ok 68 - correct output of psql -XAtc '\drds' 477s # restore /var/backups/postgresql/17-main/2025-01-17T060025Z.backup with WAL archive 479s ok 69 - pg_dropcluster 17 main --stop 483s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-17T060025Z.backup --start --archive --port 5430 483s ok 71 - pg_lsclusters -h 483s ok 72 - correct output of pg_lsclusters -h 483s ok 73 - psql -XAtc 'select * from foo order by t' mydb 483s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 483s # restore /var/backups/postgresql/17-main/2025-01-17T060025Z.backup with PITR 486s ok 75 - pg_dropcluster 17 main --stop 490s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-17T060025Z.backup --start --pitr '2025-01-17 06:00:53.981319+00 490s # ' 490s ok 77 - pg_lsclusters -h 490s ok 78 - correct output of pg_lsclusters -h 490s ok 79 - psql -XAtc 'select * from foo order by t' mydb 490s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 492s ok 81 - pg_dropcluster 17 main --stop 492s # Cleanup 492s ok 82 - Cleanup: No clusters left behind 492s ok 83 - No postgres processes left behind 492s ok 84 - No files in /etc/postgresql left behind 492s ok 85 - No files in /var/lib/postgresql left behind 492s ok 86 - No files in /var/run/postgresql left behind 492s ok 87 - No files in /var/log/postgresql left behind 492s ok 88 - PostgreSQL TCP ports are closed 492s ok 89 - Next free port is 5432 492s 1..89 492s ### End test 045_backup.t ### 492s 492s ### PostgreSQL test 050_encodings.t ### 493s 1..60 493s # Checking 17 ru_RU 496s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 497s ok 2 - psql -l succeeds 497s ok 3 - template1 is not UTF-8 encoded 497s ok 4 - creating test database 497s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 497s # create table t (x varchar); copy t from stdin" test 497s ok 6 - creating table with ISO-8859-5 characters 497s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 497s ok 8 - correct string in UTF-8 497s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 497s ok 10 - correct string in ISO-8859-5 497s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 497s # delete from t; copy t from stdin" test 497s ok 12 - creating table with UTF-8 characters 498s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 498s ok 14 - correct string in UTF-8 498s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 498s ok 16 - correct string in ISO-8859-1 498s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 498s ok 18 - Server error message has correct language and encoding 500s ok 19 - pg_ctlcluster 17 ru_RU restart 500s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 502s ok 21 - Dropping cluster 502s # Checking 17 ru_RU.UTF-8 506s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 507s ok 23 - psql -l succeeds 507s ok 24 - template1 is UTF-8 encoded 507s ok 25 - creating test database 507s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 507s # create table t (x varchar); copy t from stdin" test 507s ok 27 - creating table with ISO-8859-5 characters 507s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 507s ok 29 - correct string in UTF-8 507s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 507s ok 31 - correct string in ISO-8859-5 507s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 507s # delete from t; copy t from stdin" test 507s ok 33 - creating table with UTF-8 characters 507s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 507s ok 35 - correct string in UTF-8 507s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 507s ok 37 - correct string in ISO-8859-1 507s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 507s ok 39 - Server error message has correct language and encoding 510s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 510s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 510s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 510s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 510s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 510s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 510s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 510s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 512s ok 48 - Dropping cluster 512s # Check 17 locale environment variables 516s ok 49 - pg_createcluster: LC_ALL dominates LANG 516s ok 50 - psql -Atl --cluster 17/main 516s ok 51 - template1 is ASCII encoded 518s ok 52 - Dropping cluster 518s # Cleanup 518s ok 53 - Cleanup: No clusters left behind 518s ok 54 - No postgres processes left behind 518s ok 55 - No files in /etc/postgresql left behind 518s ok 56 - No files in /var/lib/postgresql left behind 518s ok 57 - No files in /var/run/postgresql left behind 518s ok 58 - No files in /var/log/postgresql left behind 518s ok 59 - PostgreSQL TCP ports are closed 518s ok 60 - Next free port is 5432 518s ### End test 050_encodings.t ### 518s 518s ### PostgreSQL test 052_upgrade_encodings.t ### 518s 1..1 518s ok 1 - only one major version installed, skipping upgrade tests 518s ### End test 052_upgrade_encodings.t ### 518s 518s ### PostgreSQL test 060_obsolete_confparams.t ### 518s ok 1 - only one major version installed, skipping upgrade tests 518s 1..1 518s ### End test 060_obsolete_confparams.t ### 518s 518s ### PostgreSQL test 070_non_postgres_clusters.t ### 518s 1..40 520s ok 1 - pg_createcluster 17 main for owner nobody 520s ok 2 - pg_ctlcluster 17 main start 520s ok 3 - start refused when config and data owners mismatch 522s ok 4 - pg_ctlcluster succeeds with owner nobody 522s ok 5 - pg_lsclusters -h 522s ok 6 - pg_lsclusters shows running cluster 522s ok 7 - postgres is running as user nobody 522s ok 8 - ls /tmp/.s.PGSQL.* 522s ok 9 - socket is in /tmp 522s ok 10 - /var/run/postgresql is empty 522s ok 11 - conf dir is owned by user 522s ok 12 - conf dir is owned by user's primary group 522s ok 13 - files are owned by user 522s ok 14 - files are owned by user's primary group 522s ok 15 - log file has 0640 permissions 522s ok 16 - log file is owned by user 522s ok 17 - log file is owned by user's primary group 522s ok 18 - only one major version installed, skipping upgrade test 522s ok 19 - ... 522s ok 20 - ... 522s ok 21 - ... 522s ok 22 - ... 522s ok 23 - ... 522s ok 24 - ... 522s ok 25 - ... 522s ok 26 - ... 522s ok 27 - ... 522s ok 28 - ... 524s ok 29 - pg_dropcluster 524s ok 30 - pg_lsclusters -h 524s ok 31 - No clusters left 524s ok 32 - No postgres processes left 524s # Cleanup 524s ok 33 - Cleanup: No clusters left behind 524s ok 34 - No postgres processes left behind 524s ok 35 - No files in /etc/postgresql left behind 524s ok 36 - No files in /var/lib/postgresql left behind 524s ok 37 - No files in /var/run/postgresql left behind 524s ok 38 - No files in /var/log/postgresql left behind 524s ok 39 - PostgreSQL TCP ports are closed 524s ok 40 - Next free port is 5432 524s ### End test 070_non_postgres_clusters.t ### 524s 524s ### PostgreSQL test 080_start.conf.t ### 524s 1..73 525s ok 1 - pg_createcluster 17 main 525s # start.conf auto 525s ok 2 - get_cluster_start_conf returns auto 525s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 525s ok 4 - start.conf contains auto 525s ok 5 - systemd generator links cluster 525s ok 6 - systemd generator links correct service file 527s ok 7 - /etc/init.d/postgresql start 17 527s ok 8 - correct output of /etc/init.d/postgresql start 17 528s ok 9 - pg_lsclusters -h 528s ok 10 - cluster is online 528s ok 11 - /etc/init.d/postgresql stop 17 528s ok 12 - correct output of /etc/init.d/postgresql stop 17 531s ok 13 - pg_lsclusters -h 531s ok 14 - cluster is down 531s # start.conf manual 531s ok 15 - get_cluster_start_conf returns manual 531s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 531s ok 17 - start.conf contains manual 531s ok 18 - systemd generator doesn't link cluster 531s ok 19 - /etc/init.d/postgresql start 17 531s ok 20 - correct output of /etc/init.d/postgresql start 17 531s ok 21 - pg_lsclusters -h 531s ok 22 - cluster is down 533s ok 23 - pg_ctlcluster 17 main start 533s ok 24 - correct output of pg_ctlcluster 17 main start 533s ok 25 - pg_lsclusters -h 533s ok 26 - cluster is online 533s ok 27 - pg_ctlcluster 17 main stop 533s ok 28 - correct output of pg_ctlcluster 17 main stop 534s ok 29 - pg_lsclusters -h 534s ok 30 - cluster is down 534s # start.conf disabled 534s ok 31 - get_cluster_start_conf returns disabled 534s ok 32 - systemd generator doesn't link cluster 534s ok 33 - /etc/init.d/postgresql start 17 534s ok 34 - correct output of /etc/init.d/postgresql start 17 534s ok 35 - pg_lsclusters -h 534s ok 36 - cluster is down 534s ok 37 - pg_ctlcluster 17 main start 534s ok 38 - correct output of pg_ctlcluster 17 main start 534s ok 39 - pg_lsclusters -h 534s ok 40 - cluster is down 536s ok 41 - pg_ctlcluster 17 main start 536s ok 42 - correct output of pg_ctlcluster 17 main start 536s ok 43 - pg_lsclusters -h 536s ok 44 - cluster is online 537s ok 45 - pg_ctlcluster 17 main stop 537s ok 46 - correct output of pg_ctlcluster 17 main stop 537s ok 47 - pg_lsclusters -h 537s ok 48 - cluster is down 539s ok 49 - pg_ctlcluster 17 main start 539s ok 50 - correct output of pg_ctlcluster 17 main start 539s ok 51 - pg_lsclusters -h 539s ok 52 - cluster is online 539s # test upgrade 539s ok 53 - only one major version installed, skipping upgrade test 539s ok 54 - ... 539s ok 55 - get_cluster_start_conf for old cluster returns manual 539s ok 56 - get_cluster_start_conf for new cluster returns manual 539s ok 57 - ... 541s ok 58 - dropping upgraded cluster 541s ok 59 - pg_lsclusters -h 541s ok 60 - no clusters any more 541s ok 61 - pg_createcluster 17 main --start-conf foo 541s ok 62 - pg_createcluster checks --start-conf validity 542s ok 63 - pg_createcluster checks --start-conf manual 542s ok 64 - get_cluster_start_conf returns manual 543s ok 65 - dropping cluster 543s # Cleanup 543s ok 66 - Cleanup: No clusters left behind 543s ok 67 - No postgres processes left behind 543s ok 68 - No files in /etc/postgresql left behind 543s ok 69 - No files in /var/lib/postgresql left behind 543s ok 70 - No files in /var/run/postgresql left behind 543s ok 71 - No files in /var/log/postgresql left behind 543s ok 72 - PostgreSQL TCP ports are closed 543s ok 73 - Next free port is 5432 543s ### End test 080_start.conf.t ### 543s 543s ### PostgreSQL test 085_pg_ctl.conf.t ### 543s 1..33 543s ok 1 - prlimit --core=0:unlimited --pid=16698 543s ok 2 - set core file size to unlimited 543s ok 3 - sh -c 'ulimit -Hc' 543s ok 4 - core file size is unlimited 544s ok 5 - pg_createcluster 17 main 544s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 547s ok 7 - pg_ctlcluster 17 main start 547s ok 8 - starting cluster as root 547s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 547s ok 10 - soft core size is 0 547s # hard core file size limit of root-started postgres process is unlimited 547s ok 11 - set pg_ctl default option to -c 549s ok 12 - pg_ctlcluster 17 main restart 549s ok 13 - restarting cluster as root 549s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 549s ok 15 - soft core size is unlimited 549s ok 16 - pg_ctlcluster 17 main stop 549s ok 17 - stopping cluster 549s ok 18 - restored pg_ctl default option 552s ok 19 - pg_ctlcluster 17 main start -- -c 552s ok 20 - starting cluster with -c on the command line as postgres 552s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 552s ok 22 - soft core size is unlimited 552s ok 23 - pg_ctlcluster 17 main stop 552s ok 24 - stopping cluster 554s ok 25 - dropping cluster 554s # Cleanup 554s ok 26 - Cleanup: No clusters left behind 554s ok 27 - No postgres processes left behind 554s ok 28 - No files in /etc/postgresql left behind 554s ok 29 - No files in /var/lib/postgresql left behind 554s ok 30 - No files in /var/run/postgresql left behind 554s ok 31 - No files in /var/log/postgresql left behind 554s ok 32 - PostgreSQL TCP ports are closed 554s ok 33 - Next free port is 5432 554s ### End test 085_pg_ctl.conf.t ### 554s 554s ### PostgreSQL test 090_multicluster.t ### 554s 1..125 555s ok 1 - pg_createcluster 17 old 557s ok 2 - pg_createcluster 17 new1 558s ok 3 - pg_createcluster 17 new2 560s ok 4 - starting cluster 17/old 563s ok 5 - starting cluster 17/new1 565s ok 6 - starting cluster 17/new2 565s ok 7 - pg_lsclusters -h | sort -k3 565s ok 8 - clusters have the correct ports, skipping used 5433 565s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 565s ok 10 - createdb --version 565s ok 11 - pg_wrapper selects port 5432 as default cluster 565s ok 12 - createdb --cluster 17/new1 --version 565s ok 13 - pg_wrapper --cluster works 565s ok 14 - createdb --cluster 17/foo --version 565s ok 15 - pg_wrapper --cluster errors out for invalid cluster 566s ok 16 - createdb --cluster 17/new1 test 566s ok 17 - correct output of createdb --cluster 17/new1 test 566s ok 18 - psql -Atl --cluster 17/new1 566s ok 19 - test db appears in cluster new1 566s ok 20 - psql -Atl --cluster 17/new2 566s ok 21 - test db does not appear in cluster new2 566s ok 22 - psql -Atl 566s ok 23 - test db does not appear in default cluster 566s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 566s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 566s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 566s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 566s ok 28 - psql -Atl --cluster 17/localhost:5434 566s ok 29 - test db appears in cluster 17/localhost:5434 566s ok 30 - psql -Atl --cluster 17/localhost:5440 566s ok 31 - test db does not appear in cluster 17/localhost:5440 566s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 566s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 566s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 566s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 566s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 566s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 566s ok 38 - psql -Atl --cluster 6.4/localhost: 566s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 566s ok 40 - psql -Atl 566s ok 41 - PGCLUSTER selection (1) 567s ok 42 - psql -Atl 567s ok 43 - PGCLUSTER selection (2) 567s ok 44 - psql -l 567s ok 45 - invalid PGCLUSTER value 567s ok 46 - createdb --version 567s ok 47 - PGCLUSTER network cluster selection (1) 567s ok 48 - psql -Atl 567s ok 49 - PGCLUSTER network cluster selection (2) 567s ok 50 - psql -Atl 567s ok 51 - PGCLUSTER network cluster selection (3) 567s ok 52 - LC_MESSAGES=C psql -Atl 567s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 567s ok 54 - psql -Atc "show port" template1 567s ok 55 - PGPORT selection (1) 567s ok 56 - psql -Atc "show port" template1 567s ok 57 - PGPORT selection (2) 567s ok 58 - createdb --version 567s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 567s ok 60 - psql -Atc "show port" template1 567s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 567s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 567s ok 63 - PGDATABASE environment variable works 567s ok 64 - createdb --version 567s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 567s ok 66 - createdb --cluster 17/new1 --version 567s ok 67 - pg_wrapper --cluster works with empty user_clusters 567s ok 68 - createdb --version 567s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 567s ok 70 - psql -Atc "select current_database()" 567s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 567s ok 72 - psql -Atc 'select current_database()' 567s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 567s ok 74 - createdb --version 567s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 567s ok 76 - createdb --version 567s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 567s ok 78 - createdb --version 567s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 568s ok 80 - createdb --version 568s ok 81 - pg_wrapper selects correct version with per-user user_clusters 568s ok 82 - createdb --version 568s ok 83 - pg_wrapper selects correct version with per-user user_clusters 568s ok 84 - createdb --version 568s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 568s ok 86 - psql -Atl 568s ok 87 - $PGHOST overrides user_clusters 568s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 568s ok 89 - --cluster overrides $PGHOST 568s ok 90 - createdb --version 568s ok 91 - pg_wrapper ignores invalid lines in user_clusters 568s ok 92 - psql -Atc 'select current_database()' 568s ok 93 - pg_service conf selection 1 568s ok 94 - psql -Atc 'select current_database()' 568s ok 95 - pg_service conf selection 2 568s ok 96 - psql -Atc 'select current_database()' 568s ok 97 - pg_service conf selection 3 568s ok 98 - stopping cluster 17/old 571s ok 99 - restarting cluster 17/old 571s ok 100 - pg_lsclusters -h | sort -k3 571s ok 101 - port of first cluster was successfully changed 571s ok 102 - psql -l 571s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 571s ok 104 - psql -Atl --cluster 17/new1 571s ok 105 - --cluster selects appropriate cluster 571s ok 106 - psql -Atl -p 5434 571s ok 107 - -p selects appropriate cluster 571s ok 108 - psql -Atlp 5434 571s ok 109 - -Atlp selects appropriate cluster 571s ok 110 - psql -Atl --port 5434 571s ok 111 - --port selects appropriate cluster 571s ok 112 - env PGPORT=5434 psql -Atl 571s ok 113 - $PGPORT selects appropriate cluster 571s ok 114 - Restoring original /etc/postgresql-common/user_clusters 573s ok 115 - dropping 17/new1 575s ok 116 - dropping 17/new2 577s ok 117 - dropping 17/old 577s # Cleanup 577s ok 118 - Cleanup: No clusters left behind 577s ok 119 - No postgres processes left behind 577s ok 120 - No files in /etc/postgresql left behind 577s ok 121 - No files in /var/lib/postgresql left behind 577s ok 122 - No files in /var/run/postgresql left behind 577s ok 123 - No files in /var/log/postgresql left behind 577s ok 124 - PostgreSQL TCP ports are closed 577s ok 125 - Next free port is 5432 577s ### End test 090_multicluster.t ### 577s 577s ### PostgreSQL test 110_integrate_cluster.t ### 577s 1..32 578s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/8FDptyrtfi/c/postgres 578s ok 2 - creating raw initdb cluster for user postgres 578s ok 3 - pg_createcluster 17 postgres -d /tmp/8FDptyrtfi/c/postgres 578s ok 4 - integrating postgres cluster 578s ok 5 - pg_lsclusters 578s ok 6 - correct pg_lsclusters output 581s ok 7 - pg_ctlcluster 17 postgres start 581s ok 8 - starting cluster postgres 581s ok 9 - pg_lsclusters 581s ok 10 - correct pg_lsclusters output 583s ok 11 - dropping cluster postgres 583s ok 12 - No files in temporary cluster dir left behind 584s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/8FDptyrtfi/c/nobody 584s ok 14 - creating raw initdb cluster for user nobody 584s ok 15 - pg_createcluster 17 nobody -d /tmp/8FDptyrtfi/c/nobody 584s ok 16 - integrating nobody cluster 584s ok 17 - pg_lsclusters 584s ok 18 - correct pg_lsclusters output 586s ok 19 - pg_ctlcluster 17 nobody start 586s ok 20 - starting cluster nobody 586s ok 21 - pg_lsclusters 586s ok 22 - correct pg_lsclusters output 588s ok 23 - dropping cluster nobody 588s ok 24 - No files in temporary cluster dir left behind 588s # Cleanup 588s ok 25 - Cleanup: No clusters left behind 588s ok 26 - No postgres processes left behind 588s ok 27 - No files in /etc/postgresql left behind 588s ok 28 - No files in /var/lib/postgresql left behind 588s ok 29 - No files in /var/run/postgresql left behind 588s ok 30 - No files in /var/log/postgresql left behind 588s ok 31 - PostgreSQL TCP ports are closed 588s ok 32 - Next free port is 5432 588s ### End test 110_integrate_cluster.t ### 588s 588s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 588s 1..1 588s ok 1 - only one major version installed, skipping upgrade tests 588s ### End test 120_pg_upgradecluster_scripts.t ### 588s 588s ### PostgreSQL test 130_nonroot_admin.t ### 588s 1..22 592s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 592s ok 2 - pg_lsclusters -h 592s ok 3 - correct output of pg_lsclusters -h 592s ok 4 - psql -Atl 592s ok 5 - correct output of psql -Atl 592s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 592s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 592s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 592s # Cleanup 592s ok 15 - Cleanup: No clusters left behind 592s ok 16 - No postgres processes left behind 592s ok 17 - No files in /etc/postgresql left behind 592s ok 18 - No files in /var/lib/postgresql left behind 592s ok 19 - No files in /var/run/postgresql left behind 592s ok 20 - No files in /var/log/postgresql left behind 592s ok 21 - PostgreSQL TCP ports are closed 592s ok 22 - Next free port is 5432 592s ### End test 130_nonroot_admin.t ### 592s 592s ### PostgreSQL test 135_pg_virtualenv.t ### 592s 1..20 597s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 597s ok 2 - running pg_virtualenv as root 601s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 601s ok 4 - running pg_virtualenv as postgres 604s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 604s ok 6 - running pg_virtualenv as nobody 608s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 608s ok 8 - running fakeroot pg_virtualenv as root 611s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 611s ok 10 - running fakeroot pg_virtualenv as postgres 615s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 615s ok 12 - running fakeroot pg_virtualenv as nobody 615s # Cleanup 615s ok 13 - Cleanup: No clusters left behind 615s ok 14 - No postgres processes left behind 615s ok 15 - No files in /etc/postgresql left behind 615s ok 16 - No files in /var/lib/postgresql left behind 615s ok 17 - No files in /var/run/postgresql left behind 615s ok 18 - No files in /var/log/postgresql left behind 615s ok 19 - PostgreSQL TCP ports are closed 615s ok 20 - Next free port is 5432 615s ### End test 135_pg_virtualenv.t ### 615s 615s ### PostgreSQL test 140_pg_config.t ### 615s 1..38 615s # Multiarch is enabled 615s # checking version specific output for 17 615s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 615s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 615s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 615s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 615s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 615s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 615s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 615s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 615s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 615s # checking pg_config output (should behave like version 17) 615s ok 15 - pg_config 615s ok 16 - correct output of pg_config 615s ok 17 - pg_config --help 615s ok 18 - correct output of pg_config --help 615s ok 19 - pg_config --pgxs 615s ok 20 - correct output of pg_config --pgxs 615s ok 21 - pg_config --libdir 615s ok 22 - correct output of pg_config --libdir 615s ok 23 - pg_config --pkglibdir 615s ok 24 - correct output of pg_config --pkglibdir 615s ok 25 - pg_config --bindir 615s ok 26 - correct output of pg_config --bindir 615s # checking pg_config.libpq-dev output (should behave like version 17) 615s ok 27 - pg_config.libpq-dev 615s ok 28 - correct output of pg_config.libpq-dev 615s ok 29 - pg_config.libpq-dev --help 615s ok 30 - correct output of pg_config.libpq-dev --help 615s ok 31 - pg_config.libpq-dev --pgxs 615s ok 32 - correct output of pg_config.libpq-dev --pgxs 615s ok 33 - pg_config.libpq-dev --libdir 615s ok 34 - correct output of pg_config.libpq-dev --libdir 615s ok 35 - pg_config.libpq-dev --pkglibdir 615s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 615s ok 37 - pg_config.libpq-dev --bindir 615s ok 38 - correct output of pg_config.libpq-dev --bindir 615s ### End test 140_pg_config.t ### 615s 615s ### PostgreSQL test 150_tsearch_stemming.t ### 615s 1..37 615s ok 1 - pg_updatedicts succeeded 615s ok 2 - pg_updatedicts created en_us.affix 615s ok 3 - pg_updatedicts created en_us.dict 615s ok 4 - pg_updatedicts created 17 en_us.affix symlink 615s ok 5 - pg_updatedicts created 17 en_us.dict symlink 619s ok 6 - pg_createcluster 17 main 619s ok 7 - createdb fts 619s ok 8 - correct output of createdb fts 619s ok 9 - creating en_US full text search configuration 619s ok 10 - creating data table and search index 619s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 619s ok 12 - stem search of correct word 619s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 619s ok 14 - stem search of correct word 620s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 620s ok 16 - stem search of unknown word 620s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 620s ok 18 - full text search, exact word 620s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 620s ok 20 - full text search for word stem 620s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 620s ok 22 - full text search for word substring fails 620s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 620s ok 24 - full text search, exact unicode word 620s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 620s ok 26 - full text search for unicode word stem 620s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 620s ok 28 - full text search for unicode word substring fails 622s ok 29 622s # Cleanup 622s ok 30 - Cleanup: No clusters left behind 622s ok 31 - No postgres processes left behind 622s ok 32 - No files in /etc/postgresql left behind 622s ok 33 - No files in /var/lib/postgresql left behind 622s ok 34 - No files in /var/run/postgresql left behind 622s ok 35 - No files in /var/log/postgresql left behind 622s ok 36 - PostgreSQL TCP ports are closed 622s ok 37 - Next free port is 5432 622s ### End test 150_tsearch_stemming.t ### 622s 622s ### PostgreSQL test 160_alternate_confroot.t ### 622s 1..28 625s ok 1 625s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 625s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 625s ok 4 - pg_lsclusters -h 625s ok 5 - correct output of pg_lsclusters -h 625s ok 6 - psql -Atl 625s ok 7 - correct output of psql -Atl 625s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 625s ok 9 - ... 625s ok 10 - ... 625s ok 11 - ... 625s ok 12 - ... 625s ok 13 - ... 625s ok 14 - ... 626s ok 15 - pg_dropcluster 17 test --stop 626s ok 16 - correct output of pg_dropcluster 17 test --stop 626s ok 17 - pg_lsclusters -h 626s ok 18 - correct output of pg_lsclusters -h 626s ok 19 - No files in root/data left behind 626s ok 20 - No cruft in root dir left behind 626s # Cleanup 626s ok 21 - Cleanup: No clusters left behind 626s ok 22 - No postgres processes left behind 626s ok 23 - No files in /etc/postgresql left behind 626s ok 24 - No files in /var/lib/postgresql left behind 626s ok 25 - No files in /var/run/postgresql left behind 626s ok 26 - No files in /var/log/postgresql left behind 626s ok 27 - PostgreSQL TCP ports are closed 626s ok 28 - Next free port is 5432 626s ### End test 160_alternate_confroot.t ### 626s 626s ### PostgreSQL test 170_extensions.t ### 626s # Running tests for 17 629s ok 1 - pg_createcluster 17 main 629s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 629s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 629s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 629s ok 5 - extension amcheck installs without error 630s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 630s ok 7 - extension amcheck removes without error 630s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 630s ok 9 - extension autoinc installs without error 630s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 630s ok 11 - extension autoinc removes without error 630s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 630s ok 13 - extension bloom installs without error 630s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 630s ok 15 - extension bloom removes without error 630s ok 16 - psql -qc 'CREATE EXTENSION plperl' 630s ok 17 - bool_plperl dependency plperl installs without error 630s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 630s ok 19 - extension bool_plperl installs without error 630s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 630s ok 21 - extension bool_plperl removes without error 630s ok 22 - psql -qc 'DROP EXTENSION plperl' 630s ok 23 - bool_plperl dependency extension plperl removes without error 630s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 630s ok 25 - bool_plperlu dependency plperlu installs without error 630s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 630s ok 27 - extension bool_plperlu installs without error 630s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 630s ok 29 - extension bool_plperlu removes without error 630s ok 30 - psql -qc 'DROP EXTENSION plperlu' 630s ok 31 - bool_plperlu dependency extension plperlu removes without error 630s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 630s ok 33 - extension btree_gin installs without error 630s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 630s ok 35 - extension btree_gin removes without error 631s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 631s ok 37 - extension btree_gist installs without error 631s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 631s ok 39 - extension btree_gist removes without error 631s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 631s ok 41 - extension citext installs without error 631s ok 42 - psql -qc 'DROP EXTENSION "citext"' 631s ok 43 - extension citext removes without error 631s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 631s ok 45 - extension cube installs without error 631s ok 46 - psql -qc 'DROP EXTENSION "cube"' 631s ok 47 - extension cube removes without error 631s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 631s ok 49 - extension dblink installs without error 631s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 631s ok 51 - extension dblink removes without error 631s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 631s ok 53 - extension dict_int installs without error 631s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 631s ok 55 - extension dict_int removes without error 631s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 631s ok 57 - extension dict_xsyn installs without error 631s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 631s ok 59 - extension dict_xsyn removes without error 631s ok 60 - psql -qc 'CREATE EXTENSION cube' 631s ok 61 - earthdistance dependency cube installs without error 631s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 631s ok 63 - extension earthdistance installs without error 631s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 631s ok 65 - extension earthdistance removes without error 632s ok 66 - psql -qc 'DROP EXTENSION cube' 632s ok 67 - earthdistance dependency extension cube removes without error 632s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 632s ok 69 - extension file_fdw installs without error 632s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 632s ok 71 - extension file_fdw removes without error 632s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 632s ok 73 - extension fuzzystrmatch installs without error 632s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 632s ok 75 - extension fuzzystrmatch removes without error 632s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 632s ok 77 - extension hstore installs without error 632s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 632s ok 79 - extension hstore removes without error 632s ok 80 - psql -qc 'CREATE EXTENSION hstore' 632s ok 81 - hstore_plperl dependency hstore installs without error 632s ok 82 - psql -qc 'CREATE EXTENSION plperl' 632s ok 83 - hstore_plperl dependency plperl installs without error 632s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 632s ok 85 - extension hstore_plperl installs without error 632s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 632s ok 87 - extension hstore_plperl removes without error 632s ok 88 - psql -qc 'DROP EXTENSION hstore' 632s ok 89 - hstore_plperl dependency extension hstore removes without error 632s ok 90 - psql -qc 'DROP EXTENSION plperl' 632s ok 91 - hstore_plperl dependency extension plperl removes without error 632s ok 92 - psql -qc 'CREATE EXTENSION hstore' 632s ok 93 - hstore_plperlu dependency hstore installs without error 632s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 632s ok 95 - hstore_plperlu dependency plperlu installs without error 633s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 633s ok 97 - extension hstore_plperlu installs without error 633s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 633s ok 99 - extension hstore_plperlu removes without error 633s ok 100 - psql -qc 'DROP EXTENSION hstore' 633s ok 101 - hstore_plperlu dependency extension hstore removes without error 633s ok 102 - psql -qc 'DROP EXTENSION plperlu' 633s ok 103 - hstore_plperlu dependency extension plperlu removes without error 633s ok 104 - psql -qc 'CREATE EXTENSION hstore' 633s ok 105 - hstore_plpython3u dependency hstore installs without error 633s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 633s ok 107 - hstore_plpython3u dependency plpython3u installs without error 633s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 633s ok 109 - extension hstore_plpython3u installs without error 633s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 633s ok 111 - extension hstore_plpython3u removes without error 633s ok 112 - psql -qc 'DROP EXTENSION hstore' 633s ok 113 - hstore_plpython3u dependency extension hstore removes without error 633s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 633s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 633s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 633s ok 117 - extension insert_username installs without error 633s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 633s ok 119 - extension insert_username removes without error 633s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 633s ok 121 - extension intagg installs without error 633s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 633s ok 123 - extension intagg removes without error 633s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 633s ok 125 - extension intarray installs without error 633s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 633s ok 127 - extension intarray removes without error 634s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 634s ok 129 - extension isn installs without error 634s ok 130 - psql -qc 'DROP EXTENSION "isn"' 634s ok 131 - extension isn removes without error 634s ok 132 - psql -qc 'CREATE EXTENSION plperl' 634s ok 133 - jsonb_plperl dependency plperl installs without error 634s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 634s ok 135 - extension jsonb_plperl installs without error 634s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 634s ok 137 - extension jsonb_plperl removes without error 634s ok 138 - psql -qc 'DROP EXTENSION plperl' 634s ok 139 - jsonb_plperl dependency extension plperl removes without error 634s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 634s ok 141 - jsonb_plperlu dependency plperlu installs without error 634s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 634s ok 143 - extension jsonb_plperlu installs without error 634s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 634s ok 145 - extension jsonb_plperlu removes without error 634s ok 146 - psql -qc 'DROP EXTENSION plperlu' 634s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 634s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 634s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 634s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 634s ok 151 - extension jsonb_plpython3u installs without error 634s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 634s ok 153 - extension jsonb_plpython3u removes without error 634s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 634s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 634s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 634s ok 157 - extension lo installs without error 635s ok 158 - psql -qc 'DROP EXTENSION "lo"' 635s ok 159 - extension lo removes without error 635s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 635s ok 161 - extension ltree installs without error 635s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 635s ok 163 - extension ltree removes without error 635s ok 164 - psql -qc 'CREATE EXTENSION ltree' 635s ok 165 - ltree_plpython3u dependency ltree installs without error 635s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 635s ok 167 - ltree_plpython3u dependency plpython3u installs without error 635s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 635s ok 169 - extension ltree_plpython3u installs without error 635s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 635s ok 171 - extension ltree_plpython3u removes without error 635s ok 172 - psql -qc 'DROP EXTENSION ltree' 635s ok 173 - ltree_plpython3u dependency extension ltree removes without error 635s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 635s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 635s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 635s ok 177 - extension moddatetime installs without error 635s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 635s ok 179 - extension moddatetime removes without error 635s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 635s ok 181 - extension pageinspect installs without error 635s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 635s ok 183 - extension pageinspect removes without error 635s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 635s ok 185 - extension pg_buffercache installs without error 635s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 635s ok 187 - extension pg_buffercache removes without error 636s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 636s ok 189 - extension pg_freespacemap installs without error 636s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 636s ok 191 - extension pg_freespacemap removes without error 636s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 636s ok 193 - extension pg_prewarm installs without error 636s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 636s ok 195 - extension pg_prewarm removes without error 636s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 636s ok 197 - extension pg_stat_statements installs without error 636s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 636s ok 199 - extension pg_stat_statements removes without error 636s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 636s ok 201 - extension pg_surgery installs without error 636s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 636s ok 203 - extension pg_surgery removes without error 636s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 636s ok 205 - extension pg_trgm installs without error 636s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 636s ok 207 - extension pg_trgm removes without error 636s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 636s ok 209 - extension pg_visibility installs without error 636s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 636s ok 211 - extension pg_visibility removes without error 636s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 636s ok 213 - extension pg_walinspect installs without error 636s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 636s ok 215 - extension pg_walinspect removes without error 636s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 636s ok 217 - extension pgcrypto installs without error 637s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 637s ok 219 - extension pgcrypto removes without error 637s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 637s ok 221 - extension pgrowlocks installs without error 637s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 637s ok 223 - extension pgrowlocks removes without error 637s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 637s ok 225 - extension pgstattuple installs without error 637s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 637s ok 227 - extension pgstattuple removes without error 637s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 637s ok 229 - extension plperl installs without error 637s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 637s ok 231 - extension plperl removes without error 637s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 637s ok 233 - extension plperlu installs without error 637s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 637s ok 235 - extension plperlu removes without error 637s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 637s ok 237 - extension plpython3u installs without error 637s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 637s ok 239 - extension plpython3u removes without error 637s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 637s ok 241 - extension pltcl installs without error 637s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 637s ok 243 - extension pltcl removes without error 637s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 637s ok 245 - extension pltclu installs without error 637s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 637s ok 247 - extension pltclu removes without error 638s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 638s ok 249 - extension postgres_fdw installs without error 638s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 638s ok 251 - extension postgres_fdw removes without error 638s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 638s ok 253 - extension refint installs without error 638s ok 254 - psql -qc 'DROP EXTENSION "refint"' 638s ok 255 - extension refint removes without error 638s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 638s ok 257 - extension seg installs without error 638s ok 258 - psql -qc 'DROP EXTENSION "seg"' 638s ok 259 - extension seg removes without error 638s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 638s ok 261 - extension sslinfo installs without error 638s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 638s ok 263 - extension sslinfo removes without error 638s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 638s ok 265 - extension tablefunc installs without error 638s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 638s ok 267 - extension tablefunc removes without error 638s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 638s ok 269 - extension tcn installs without error 638s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 638s ok 271 - extension tcn removes without error 638s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 638s ok 273 - extension tsm_system_rows installs without error 638s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 638s ok 275 - extension tsm_system_rows removes without error 638s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 638s ok 277 - extension tsm_system_time installs without error 638s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 638s ok 279 - extension tsm_system_time removes without error 638s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 638s ok 281 - extension unaccent installs without error 639s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 639s ok 283 - extension unaccent removes without error 639s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 639s ok 285 - extension uuid-ossp installs without error 639s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 639s ok 287 - extension uuid-ossp removes without error 639s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 639s ok 289 - extension xml2 installs without error 639s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 639s ok 291 - extension xml2 removes without error 641s ok 292 - pg_dropcluster 17 main 641s # Cleanup 641s ok 293 - Cleanup: No clusters left behind 641s ok 294 - No postgres processes left behind 641s ok 295 - No files in /etc/postgresql left behind 641s ok 296 - No files in /var/lib/postgresql left behind 641s ok 297 - No files in /var/run/postgresql left behind 641s ok 298 - No files in /var/log/postgresql left behind 641s ok 299 - PostgreSQL TCP ports are closed 641s ok 300 - Next free port is 5432 641s 1..300 641s ### End test 170_extensions.t ### 641s 641s ### PostgreSQL test 180_ecpg.t ### 641s 1..14 641s ok 1 - ecpg test.pgc 641s ok 2 - ecpg processing 641s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 641s ok 4 - compiling ecpg output 649s ok 5 - pg_virtualenv /tmp/tmp.oYPzJlcIvc/test 649s ok 6 - test program runs and gives correct output 649s # Cleanup 649s ok 7 - Cleanup: No clusters left behind 649s ok 8 - No postgres processes left behind 649s ok 9 - No files in /etc/postgresql left behind 649s ok 10 - No files in /var/lib/postgresql left behind 649s ok 11 - No files in /var/run/postgresql left behind 649s ok 12 - No files in /var/log/postgresql left behind 649s ok 13 - PostgreSQL TCP ports are closed 649s ok 14 - Next free port is 5432 649s ### End test 180_ecpg.t ### 649s 649s ### PostgreSQL test 190_pg_buildext.t ### 649s ok 1 - make clean 649s ok 2 - make tar 649s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 649s # testing 'dh --with pgxs' 653s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 653s ok 5 - postgresql-17-foo_123-1_ppc64el.deb was built 661s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 661s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 661s ok 8 - dpkg -i postgresql-17-foo_123-1_ppc64el.deb 669s ok 9 - cd foo-123 && pg_buildext installcheck 669s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 676s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 676s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 684s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 684s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 684s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 684s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 684s ok 17 - dpkg -r postgresql-17-foo 684s # testing 'dh --with pgxs_loop' 684s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 688s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 688s ok 20 - postgresql-17-foo_123-1_ppc64el.deb was built 688s ok 21 - make clean 688s # testing pg_buildext updatecontrol 688s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 688s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 688s 1..23 688s ### End test 190_pg_buildext.t ### 688s 688s ### PostgreSQL test 200_maintscripts.t ### 688s 1..15 688s # We are running systemd 692s ok 1 - pg_createcluster 17 main --start 692s ok 2 - postmaster PID is 23191 693s ok 3 - apt-get update -q 693s # postgresql-common: 693s # Installed: 267 693s # Candidate: 267 693s # Version table: 693s # *** 267 500 693s # 500 http://ftpmaster.internal/ubuntu plucky/main ppc64el Packages 693s # 100 /var/lib/dpkg/status 697s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 697s # postgresql-common: 697s # Installed: 267 697s # Candidate: 267 697s # Version table: 697s # *** 267 500 697s # 500 http://ftpmaster.internal/ubuntu plucky/main ppc64el Packages 697s # 100 /var/lib/dpkg/status 697s ok 5 - postmaster PID is 23191 697s ok 6 - postmaster was not restarted 699s ok 7 - pg_dropcluster 17 main --stop 699s # Cleanup 699s ok 8 - Cleanup: No clusters left behind 699s ok 9 - No postgres processes left behind 699s ok 10 - No files in /etc/postgresql left behind 699s ok 11 - No files in /var/lib/postgresql left behind 699s ok 12 - No files in /var/run/postgresql left behind 699s ok 13 - No files in /var/log/postgresql left behind 699s ok 14 - PostgreSQL TCP ports are closed 699s ok 15 - Next free port is 5432 699s ### End test 200_maintscripts.t ### 699s 699s autopkgtest [06:04:50]: test run-testsuite: -----------------------] 700s autopkgtest [06:04:51]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 700s run-testsuite PASS 700s autopkgtest [06:04:51]: @@@@@@@@@@@@@@@@@@@@ summary 700s default-psql PASS 700s run-testsuite PASS 705s nova [W] Using flock in prodstack6-ppc64el 705s Creating nova instance adt-plucky-ppc64el-postgresql-common-20250117-055311-juju-7f2275-prod-proposed-migration-environment-20-f2805f81-5dbf-4ac1-8786-79d048907ee9 from image adt/ubuntu-plucky-ppc64el-server-20250117.img (UUID fc4495f7-ff1c-4a92-a3fe-ee8c580d771a)... 705s nova [W] Timed out waiting for 480e4964-3962-4296-bea1-547efcae383e to get deleted. 705s nova [W] Using flock in prodstack6-ppc64el 705s Creating nova instance adt-plucky-ppc64el-postgresql-common-20250117-055311-juju-7f2275-prod-proposed-migration-environment-20-f2805f81-5dbf-4ac1-8786-79d048907ee9 from image adt/ubuntu-plucky-ppc64el-server-20250117.img (UUID fc4495f7-ff1c-4a92-a3fe-ee8c580d771a)... 705s nova [W] Timed out waiting for de38ed0b-4b4a-4c7b-9e7e-422cb21bd1ab to get deleted.