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