1s autopkgtest [22:41:47]: starting date and time: 2025-01-02 22:41:47+0000 1s autopkgtest [22:41:47]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [22:41:47]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.hcutcs_5/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:debhelper --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=debhelper/13.23ubuntu1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-27.secgroup --name adt-plucky-arm64-postgresql-common-20250102-224146-juju-7f2275-prod-proposed-migration-environment-2-2708429f-34d1-4bfd-a73e-04085b57947e --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -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/ 156s autopkgtest [22:44:22]: testbed dpkg architecture: arm64 156s autopkgtest [22:44:22]: testbed apt version: 2.9.18 157s autopkgtest [22:44:23]: @@@@@@@@@@@@@@@@@@@@ test bed setup 157s autopkgtest [22:44:23]: testbed release detected to be: None 157s autopkgtest [22:44:23]: updating testbed package index (apt update) 158s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 158s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 158s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 158s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 158s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [10.1 kB] 158s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [652 kB] 158s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [57.4 kB] 158s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 158s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [82.4 kB] 158s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 158s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [516 kB] 159s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [8824 B] 159s Fetched 1467 kB in 1s (1607 kB/s) 159s Reading package lists... 160s Reading package lists... 160s Building dependency tree... 160s Reading state information... 161s Calculating upgrade... 161s The following packages will be upgraded: 161s base-passwd bash-completion 161s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 161s Need to get 267 kB of archives. 161s After this operation, 143 kB of additional disk space will be used. 161s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 base-passwd arm64 3.6.6 [53.6 kB] 162s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 bash-completion all 1:2.16.0-1 [214 kB] 162s Preconfiguring packages ... 162s Fetched 267 kB in 0s (544 kB/s) 163s (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 ... 80060 files and directories currently installed.) 163s Preparing to unpack .../base-passwd_3.6.6_arm64.deb ... 163s Unpacking base-passwd (3.6.6) over (3.6.5) ... 163s Setting up base-passwd (3.6.6) ... 163s (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 ... 80060 files and directories currently installed.) 163s Preparing to unpack .../bash-completion_1%3a2.16.0-1_all.deb ... 163s Unpacking bash-completion (1:2.16.0-1) over (1:2.14.0-2) ... 163s Setting up bash-completion (1:2.16.0-1) ... 163s Processing triggers for man-db (2.13.0-1) ... 165s Reading package lists... 165s Building dependency tree... 165s Reading state information... 165s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 166s autopkgtest [22:44:32]: upgrading testbed (apt dist-upgrade and autopurge) 166s Reading package lists... 166s Building dependency tree... 166s Reading state information... 167s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 167s Starting 2 pkgProblemResolver with broken count: 0 167s Done 167s Entering ResolveByKeep 168s 168s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 168s Reading package lists... 169s Building dependency tree... 169s Reading state information... 169s Starting pkgProblemResolver with broken count: 0 169s Starting 2 pkgProblemResolver with broken count: 0 169s Done 170s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 172s autopkgtest [22:44:38]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 172s autopkgtest [22:44:38]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 177s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (dsc) [2383 B] 177s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (tar) [218 kB] 178s gpgv: Signature made Thu Aug 8 15:27:49 2024 UTC 178s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 178s gpgv: Can't check signature: No public key 178s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_262.dsc: no acceptable signature found 178s autopkgtest [22:44:44]: testing package postgresql-common version 262 178s autopkgtest [22:44:44]: build not needed 179s autopkgtest [22:44:45]: test default-psql: preparing testbed 179s Reading package lists... 180s Building dependency tree... 180s Reading state information... 180s Starting pkgProblemResolver with broken count: 0 180s Starting 2 pkgProblemResolver with broken count: 0 180s Done 181s The following NEW packages will be installed: 181s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 181s postgresql-client-common postgresql-common ssl-cert 181s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 181s Need to get 16.9 MB of archives. 181s After this operation, 54.9 MB of additional disk space will be used. 181s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 181s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 181s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 181s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 181s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.2-1 [141 kB] 181s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 181s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-16 arm64 16.4-3 [1269 kB] 181s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-16 arm64 16.4-3 [15.0 MB] 182s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql all 16+262 [11.8 kB] 182s Preconfiguring packages ... 182s Fetched 16.9 MB in 1s (14.8 MB/s) 182s Selecting previously unselected package libjson-perl. 182s (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 ... 80185 files and directories currently installed.) 182s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 182s Unpacking libjson-perl (4.10000-1) ... 182s Selecting previously unselected package postgresql-client-common. 182s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 182s Unpacking postgresql-client-common (262) ... 182s Selecting previously unselected package ssl-cert. 182s Preparing to unpack .../2-ssl-cert_1.1.3ubuntu1_all.deb ... 182s Unpacking ssl-cert (1.1.3ubuntu1) ... 182s Selecting previously unselected package postgresql-common. 183s Preparing to unpack .../3-postgresql-common_262_all.deb ... 183s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 183s Unpacking postgresql-common (262) ... 183s Selecting previously unselected package libpq5:arm64. 183s Preparing to unpack .../4-libpq5_17.2-1_arm64.deb ... 183s Unpacking libpq5:arm64 (17.2-1) ... 183s Selecting previously unselected package libxslt1.1:arm64. 183s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 183s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 183s Selecting previously unselected package postgresql-client-16. 183s Preparing to unpack .../6-postgresql-client-16_16.4-3_arm64.deb ... 183s Unpacking postgresql-client-16 (16.4-3) ... 183s Selecting previously unselected package postgresql-16. 183s Preparing to unpack .../7-postgresql-16_16.4-3_arm64.deb ... 183s Unpacking postgresql-16 (16.4-3) ... 183s Selecting previously unselected package postgresql. 183s Preparing to unpack .../8-postgresql_16+262_all.deb ... 183s Unpacking postgresql (16+262) ... 183s Setting up postgresql-client-common (262) ... 183s Setting up libpq5:arm64 (17.2-1) ... 183s Setting up ssl-cert (1.1.3ubuntu1) ... 184s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 185s Setting up libjson-perl (4.10000-1) ... 185s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 185s Setting up postgresql-client-16 (16.4-3) ... 185s 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 185s Setting up postgresql-common (262) ... 186s Creating config file /etc/postgresql-common/createcluster.conf with new version 186s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 186s Removing obsolete dictionary files: 187s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 187s Setting up postgresql-16 (16.4-3) ... 187s Creating new PostgreSQL cluster 16/main ... 187s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 188s The files belonging to this database system will be owned by user "postgres". 188s This user must also own the server process. 188s 188s The database cluster will be initialized with locale "C.UTF-8". 188s The default database encoding has accordingly been set to "UTF8". 188s The default text search configuration will be set to "english". 188s 188s Data page checksums are disabled. 188s 188s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 188s creating subdirectories ... ok 188s selecting dynamic shared memory implementation ... posix 188s selecting default max_connections ... 100 188s selecting default shared_buffers ... 128MB 188s selecting default time zone ... Etc/UTC 188s creating configuration files ... ok 188s running bootstrap script ... ok 188s performing post-bootstrap initialization ... ok 188s syncing data to disk ... ok 192s Setting up postgresql (16+262) ... 192s Processing triggers for man-db (2.13.0-1) ... 193s Processing triggers for libc-bin (2.40-4ubuntu1) ... 194s autopkgtest [22:45:00]: test default-psql: [----------------------- 194s autopkgtest [22:45:00]: test default-psql: -----------------------] 195s autopkgtest [22:45:01]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 195s default-psql PASS 195s autopkgtest [22:45:01]: test run-testsuite: preparing testbed 299s autopkgtest [22:46:45]: testbed dpkg architecture: arm64 299s autopkgtest [22:46:45]: testbed apt version: 2.9.18 300s autopkgtest [22:46:46]: @@@@@@@@@@@@@@@@@@@@ test bed setup 300s autopkgtest [22:46:46]: testbed release detected to be: plucky 301s autopkgtest [22:46:47]: updating testbed package index (apt update) 301s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 301s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 301s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 301s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 301s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [652 kB] 302s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [10.1 kB] 302s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 302s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [57.4 kB] 302s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [82.4 kB] 302s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 302s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [516 kB] 302s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [8824 B] 302s Fetched 1467 kB in 1s (1529 kB/s) 303s Reading package lists... 304s Reading package lists... 304s Building dependency tree... 304s Reading state information... 304s Calculating upgrade... 305s The following packages will be upgraded: 305s base-passwd bash-completion 305s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 305s Need to get 267 kB of archives. 305s After this operation, 143 kB of additional disk space will be used. 305s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 base-passwd arm64 3.6.6 [53.6 kB] 305s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 bash-completion all 1:2.16.0-1 [214 kB] 306s Preconfiguring packages ... 306s Fetched 267 kB in 0s (555 kB/s) 306s (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 ... 80060 files and directories currently installed.) 306s Preparing to unpack .../base-passwd_3.6.6_arm64.deb ... 306s Unpacking base-passwd (3.6.6) over (3.6.5) ... 306s Setting up base-passwd (3.6.6) ... 306s (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 ... 80060 files and directories currently installed.) 306s Preparing to unpack .../bash-completion_1%3a2.16.0-1_all.deb ... 306s Unpacking bash-completion (1:2.16.0-1) over (1:2.14.0-2) ... 306s Setting up bash-completion (1:2.16.0-1) ... 306s Processing triggers for man-db (2.13.0-1) ... 308s Reading package lists... 308s Building dependency tree... 308s Reading state information... 309s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 309s autopkgtest [22:46:55]: upgrading testbed (apt dist-upgrade and autopurge) 309s Reading package lists... 309s Building dependency tree... 309s Reading state information... 310s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 310s Starting 2 pkgProblemResolver with broken count: 0 310s Done 311s Entering ResolveByKeep 311s 311s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 312s Reading package lists... 312s Building dependency tree... 312s Reading state information... 312s Starting pkgProblemResolver with broken count: 0 312s Starting 2 pkgProblemResolver with broken count: 0 312s Done 313s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 316s Reading package lists... 316s Building dependency tree... 316s Reading state information... 317s Starting pkgProblemResolver with broken count: 0 317s Starting 2 pkgProblemResolver with broken count: 0 317s Done 318s The following NEW packages will be installed: 318s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 318s cpp-14 cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 318s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 318s fakeroot g++ g++-14 g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 318s gcc-14 gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext hunspell-en-us 318s icu-devtools intltool-debian libarchive-zip-perl libasan8 libcc1-0 318s libclang-common-19-dev libclang-cpp19 libdebhelper-perl libecpg-compat3 318s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 318s libgc1 libgcc-14-dev libgomp1 libhwasan0 libicu-dev libisl23 libitm1 318s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 318s libpgtypes3 libpq-dev libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool 318s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-19 llvm-19-dev 318s llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all m4 po-debconf 318s postgresql-16 postgresql-all postgresql-client-16 postgresql-client-common 318s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 318s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 318s postgresql-server-dev-all ssl-cert 318s 0 upgraded, 88 newly installed, 0 to remove and 0 not upgraded. 318s Need to get 194 MB of archives. 318s After this operation, 1142 MB of additional disk space will be used. 318s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 318s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 318s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 318s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 318s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 m4 arm64 1.4.19-4build1 [240 kB] 318s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 autoconf all 2.72-3 [382 kB] 318s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 autotools-dev all 20220109.1 [44.9 kB] 318s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 318s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 autopoint all 0.22.5-3 [616 kB] 318s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 318s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 318s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [10.6 MB] 319s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-12ubuntu1 [1032 B] 319s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [5452 B] 319s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.1.0-2ubuntu1 [22.5 kB] 319s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 14.2.0-12ubuntu1 [49.6 kB] 319s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 14.2.0-12ubuntu1 [145 kB] 319s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 14.2.0-12ubuntu1 [27.7 kB] 319s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 14.2.0-12ubuntu1 [2896 kB] 319s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 14.2.0-12ubuntu1 [1283 kB] 319s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 14.2.0-12ubuntu1 [2687 kB] 319s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 14.2.0-12ubuntu1 [1152 kB] 319s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 14.2.0-12ubuntu1 [1598 kB] 319s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-12ubuntu1 [2596 kB] 319s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [20.9 MB] 320s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-12ubuntu1 [522 kB] 320s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [1200 B] 320s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.1.0-2ubuntu1 [4994 B] 320s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-12ubuntu1 [2500 kB] 320s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [12.1 MB] 320s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-12ubuntu1 [20.2 kB] 320s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [958 B] 320s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.1.0-2ubuntu1 [1080 B] 320s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 320s Get:35 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp19 arm64 1:19.1.6-1ubuntu1 [13.8 MB] 320s Get:36 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 320s Get:37 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 14.2.0-12ubuntu1 [45.2 kB] 320s Get:38 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-12ubuntu1 [190 kB] 320s Get:39 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-19-dev arm64 1:19.1.6-1ubuntu1 [743 kB] 320s Get:40 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-linker-tools arm64 1:19.1.6-1ubuntu1 [1232 kB] 320s Get:41 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-19 arm64 1:19.1.6-1ubuntu1 [77.2 kB] 320s Get:42 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libdebhelper-perl all 13.23ubuntu1 [95.1 kB] 320s Get:43 http://ftpmaster.internal/ubuntu plucky/main arm64 libtool all 2.4.7-8 [166 kB] 320s Get:44 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-autoreconf all 20 [16.1 kB] 320s Get:45 http://ftpmaster.internal/ubuntu plucky/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 320s Get:46 http://ftpmaster.internal/ubuntu plucky/main arm64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 320s Get:47 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 320s Get:48 http://ftpmaster.internal/ubuntu plucky/main arm64 debugedit arm64 1:5.1-1 [45.9 kB] 320s Get:49 http://ftpmaster.internal/ubuntu plucky/main arm64 dwz arm64 0.15-1build6 [113 kB] 320s Get:50 http://ftpmaster.internal/ubuntu plucky/main arm64 gettext arm64 0.22.5-3 [932 kB] 320s Get:51 http://ftpmaster.internal/ubuntu plucky/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 320s Get:52 http://ftpmaster.internal/ubuntu plucky/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 320s Get:53 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 debhelper all 13.23ubuntu1 [895 kB] 320s Get:54 http://ftpmaster.internal/ubuntu plucky/main arm64 emacsen-common all 3.0.5 [12.1 kB] 320s Get:55 http://ftpmaster.internal/ubuntu plucky/main arm64 dictionaries-common all 1.30.2 [176 kB] 320s Get:56 http://ftpmaster.internal/ubuntu plucky/main arm64 libfakeroot arm64 1.36.2-1 [33.5 kB] 320s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 fakeroot arm64 1.36.2-1 [67.1 kB] 320s Get:58 http://ftpmaster.internal/ubuntu plucky/main arm64 hunspell-en-us all 1:2020.12.07-3 [586 kB] 320s Get:59 http://ftpmaster.internal/ubuntu plucky/main arm64 icu-devtools arm64 74.2-1ubuntu4 [210 kB] 320s Get:60 http://ftpmaster.internal/ubuntu plucky/main arm64 libpgtypes3 arm64 17.2-1 [42.3 kB] 320s Get:61 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.2-1 [141 kB] 320s Get:62 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg6 arm64 17.2-1 [44.0 kB] 320s Get:63 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-compat3 arm64 17.2-1 [12.3 kB] 321s Get:64 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.0-1ubuntu2 [3284 kB] 321s Get:65 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq-dev arm64 17.2-1 [158 kB] 321s Get:66 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-dev arm64 17.2-1 [263 kB] 321s Get:67 http://ftpmaster.internal/ubuntu plucky/main arm64 libicu-dev arm64 74.2-1ubuntu4 [11.9 MB] 321s Get:68 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5-2 [385 kB] 321s Get:69 http://ftpmaster.internal/ubuntu plucky/main arm64 libtcl8.6 arm64 8.6.15+dfsg-2 [987 kB] 321s Get:70 http://ftpmaster.internal/ubuntu plucky/main arm64 libxml2-dev arm64 2.12.7+dfsg+really2.9.14-0.2build1 [806 kB] 321s Get:71 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 321s Get:72 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-runtime arm64 1:19.1.6-1ubuntu1 [532 kB] 321s Get:73 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 321s Get:74 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19 arm64 1:19.1.6-1ubuntu1 [17.1 MB] 321s Get:75 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.6-1build1 [59.5 kB] 321s Get:76 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-tools arm64 1:19.1.6-1ubuntu1 [539 kB] 321s Get:77 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-dev arm64 1:19.1.6-1ubuntu1 [45.1 MB] 322s Get:78 http://ftpmaster.internal/ubuntu plucky/universe arm64 locales-all arm64 2.40-4ubuntu1 [11.1 MB] 323s Get:79 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-16 arm64 16.4-3 [1269 kB] 323s Get:80 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-16 arm64 16.4-3 [15.0 MB] 323s Get:81 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-16 arm64 16.4-3 [1221 kB] 323s Get:82 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-all arm64 262 [20.7 kB] 323s Get:83 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plperl-16 arm64 16.4-3 [61.2 kB] 323s Get:84 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plpython3-16 arm64 16.4-3 [70.5 kB] 323s Get:85 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-pltcl-16 arm64 16.4-3 [26.7 kB] 323s Get:86 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-all all 262 [1710 B] 323s Get:87 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc-16 all 16.4-3 [2098 kB] 323s Get:88 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc all 16+262 [11.8 kB] 323s Preconfiguring packages ... 324s Fetched 194 MB in 5s (35.6 MB/s) 324s Selecting previously unselected package libjson-perl. 324s (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 ... 80185 files and directories currently installed.) 324s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 324s Unpacking libjson-perl (4.10000-1) ... 324s Selecting previously unselected package postgresql-client-common. 324s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 324s Unpacking postgresql-client-common (262) ... 324s Selecting previously unselected package ssl-cert. 324s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 324s Unpacking ssl-cert (1.1.3ubuntu1) ... 324s Selecting previously unselected package postgresql-common. 324s Preparing to unpack .../03-postgresql-common_262_all.deb ... 324s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 324s Unpacking postgresql-common (262) ... 324s Selecting previously unselected package m4. 324s Preparing to unpack .../04-m4_1.4.19-4build1_arm64.deb ... 324s Unpacking m4 (1.4.19-4build1) ... 324s Selecting previously unselected package autoconf. 324s Preparing to unpack .../05-autoconf_2.72-3_all.deb ... 324s Unpacking autoconf (2.72-3) ... 324s Selecting previously unselected package autotools-dev. 324s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 324s Unpacking autotools-dev (20220109.1) ... 324s Selecting previously unselected package automake. 324s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 324s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 324s Selecting previously unselected package autopoint. 324s Preparing to unpack .../08-autopoint_0.22.5-3_all.deb ... 324s Unpacking autopoint (0.22.5-3) ... 324s Selecting previously unselected package libisl23:arm64. 324s Preparing to unpack .../09-libisl23_0.27-1_arm64.deb ... 324s Unpacking libisl23:arm64 (0.27-1) ... 324s Selecting previously unselected package libmpc3:arm64. 324s Preparing to unpack .../10-libmpc3_1.3.1-1build2_arm64.deb ... 324s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 324s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 324s Preparing to unpack .../11-cpp-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 324s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 324s Selecting previously unselected package cpp-14. 324s Preparing to unpack .../12-cpp-14_14.2.0-12ubuntu1_arm64.deb ... 324s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 324s Selecting previously unselected package cpp-aarch64-linux-gnu. 324s Preparing to unpack .../13-cpp-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 324s Unpacking cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 325s Selecting previously unselected package cpp. 325s Preparing to unpack .../14-cpp_4%3a14.1.0-2ubuntu1_arm64.deb ... 325s Unpacking cpp (4:14.1.0-2ubuntu1) ... 325s Selecting previously unselected package libcc1-0:arm64. 325s Preparing to unpack .../15-libcc1-0_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libcc1-0:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libgomp1:arm64. 325s Preparing to unpack .../16-libgomp1_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libgomp1:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libitm1:arm64. 325s Preparing to unpack .../17-libitm1_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libitm1:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libasan8:arm64. 325s Preparing to unpack .../18-libasan8_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libasan8:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package liblsan0:arm64. 325s Preparing to unpack .../19-liblsan0_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking liblsan0:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libtsan2:arm64. 325s Preparing to unpack .../20-libtsan2_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libtsan2:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libubsan1:arm64. 325s Preparing to unpack .../21-libubsan1_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libubsan1:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libhwasan0:arm64. 325s Preparing to unpack .../22-libhwasan0_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libhwasan0:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package libgcc-14-dev:arm64. 325s Preparing to unpack .../23-libgcc-14-dev_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking libgcc-14-dev:arm64 (14.2.0-12ubuntu1) ... 325s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 325s Preparing to unpack .../24-gcc-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 325s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 326s Selecting previously unselected package gcc-14. 326s Preparing to unpack .../25-gcc-14_14.2.0-12ubuntu1_arm64.deb ... 326s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 326s Selecting previously unselected package gcc-aarch64-linux-gnu. 326s Preparing to unpack .../26-gcc-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 326s Unpacking gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 326s Selecting previously unselected package gcc. 326s Preparing to unpack .../27-gcc_4%3a14.1.0-2ubuntu1_arm64.deb ... 326s Unpacking gcc (4:14.1.0-2ubuntu1) ... 326s Selecting previously unselected package libstdc++-14-dev:arm64. 326s Preparing to unpack .../28-libstdc++-14-dev_14.2.0-12ubuntu1_arm64.deb ... 326s Unpacking libstdc++-14-dev:arm64 (14.2.0-12ubuntu1) ... 326s Selecting previously unselected package g++-14-aarch64-linux-gnu. 326s Preparing to unpack .../29-g++-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 326s Unpacking g++-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 326s Selecting previously unselected package g++-14. 326s Preparing to unpack .../30-g++-14_14.2.0-12ubuntu1_arm64.deb ... 326s Unpacking g++-14 (14.2.0-12ubuntu1) ... 326s Selecting previously unselected package g++-aarch64-linux-gnu. 326s Preparing to unpack .../31-g++-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 326s Unpacking g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 326s Selecting previously unselected package g++. 326s Preparing to unpack .../32-g++_4%3a14.1.0-2ubuntu1_arm64.deb ... 326s Unpacking g++ (4:14.1.0-2ubuntu1) ... 326s Selecting previously unselected package build-essential. 326s Preparing to unpack .../33-build-essential_12.10ubuntu1_arm64.deb ... 326s Unpacking build-essential (12.10ubuntu1) ... 326s Selecting previously unselected package libclang-cpp19. 326s Preparing to unpack .../34-libclang-cpp19_1%3a19.1.6-1ubuntu1_arm64.deb ... 326s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 327s Selecting previously unselected package libgc1:arm64. 327s Preparing to unpack .../35-libgc1_1%3a8.2.8-1_arm64.deb ... 327s Unpacking libgc1:arm64 (1:8.2.8-1) ... 327s Selecting previously unselected package libobjc4:arm64. 327s Preparing to unpack .../36-libobjc4_14.2.0-12ubuntu1_arm64.deb ... 327s Unpacking libobjc4:arm64 (14.2.0-12ubuntu1) ... 327s Selecting previously unselected package libobjc-14-dev:arm64. 327s Preparing to unpack .../37-libobjc-14-dev_14.2.0-12ubuntu1_arm64.deb ... 327s Unpacking libobjc-14-dev:arm64 (14.2.0-12ubuntu1) ... 327s Selecting previously unselected package libclang-common-19-dev:arm64. 327s Preparing to unpack .../38-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_arm64.deb ... 327s Unpacking libclang-common-19-dev:arm64 (1:19.1.6-1ubuntu1) ... 327s Selecting previously unselected package llvm-19-linker-tools. 327s Preparing to unpack .../39-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_arm64.deb ... 327s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 327s Selecting previously unselected package clang-19. 327s Preparing to unpack .../40-clang-19_1%3a19.1.6-1ubuntu1_arm64.deb ... 327s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 327s Selecting previously unselected package libdebhelper-perl. 327s Preparing to unpack .../41-libdebhelper-perl_13.23ubuntu1_all.deb ... 327s Unpacking libdebhelper-perl (13.23ubuntu1) ... 327s Selecting previously unselected package libtool. 327s Preparing to unpack .../42-libtool_2.4.7-8_all.deb ... 327s Unpacking libtool (2.4.7-8) ... 327s Selecting previously unselected package dh-autoreconf. 327s Preparing to unpack .../43-dh-autoreconf_20_all.deb ... 327s Unpacking dh-autoreconf (20) ... 327s Selecting previously unselected package libarchive-zip-perl. 327s Preparing to unpack .../44-libarchive-zip-perl_1.68-1_all.deb ... 327s Unpacking libarchive-zip-perl (1.68-1) ... 327s Selecting previously unselected package libfile-stripnondeterminism-perl. 327s Preparing to unpack .../45-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 327s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 327s Selecting previously unselected package dh-strip-nondeterminism. 327s Preparing to unpack .../46-dh-strip-nondeterminism_1.14.0-1_all.deb ... 327s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 327s Selecting previously unselected package debugedit. 327s Preparing to unpack .../47-debugedit_1%3a5.1-1_arm64.deb ... 327s Unpacking debugedit (1:5.1-1) ... 327s Selecting previously unselected package dwz. 327s Preparing to unpack .../48-dwz_0.15-1build6_arm64.deb ... 327s Unpacking dwz (0.15-1build6) ... 327s Selecting previously unselected package gettext. 327s Preparing to unpack .../49-gettext_0.22.5-3_arm64.deb ... 327s Unpacking gettext (0.22.5-3) ... 328s Selecting previously unselected package intltool-debian. 328s Preparing to unpack .../50-intltool-debian_0.35.0+20060710.6_all.deb ... 328s Unpacking intltool-debian (0.35.0+20060710.6) ... 328s Selecting previously unselected package po-debconf. 328s Preparing to unpack .../51-po-debconf_1.0.21+nmu1_all.deb ... 328s Unpacking po-debconf (1.0.21+nmu1) ... 328s Selecting previously unselected package debhelper. 328s Preparing to unpack .../52-debhelper_13.23ubuntu1_all.deb ... 328s Unpacking debhelper (13.23ubuntu1) ... 328s Selecting previously unselected package emacsen-common. 328s Preparing to unpack .../53-emacsen-common_3.0.5_all.deb ... 328s Unpacking emacsen-common (3.0.5) ... 328s Selecting previously unselected package dictionaries-common. 328s Preparing to unpack .../54-dictionaries-common_1.30.2_all.deb ... 328s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 328s Unpacking dictionaries-common (1.30.2) ... 328s Selecting previously unselected package libfakeroot:arm64. 328s Preparing to unpack .../55-libfakeroot_1.36.2-1_arm64.deb ... 328s Unpacking libfakeroot:arm64 (1.36.2-1) ... 328s Selecting previously unselected package fakeroot. 328s Preparing to unpack .../56-fakeroot_1.36.2-1_arm64.deb ... 328s Unpacking fakeroot (1.36.2-1) ... 328s Selecting previously unselected package hunspell-en-us. 328s Preparing to unpack .../57-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 328s Unpacking hunspell-en-us (1:2020.12.07-3) ... 328s Selecting previously unselected package icu-devtools. 328s Preparing to unpack .../58-icu-devtools_74.2-1ubuntu4_arm64.deb ... 328s Unpacking icu-devtools (74.2-1ubuntu4) ... 328s Selecting previously unselected package libpgtypes3:arm64. 328s Preparing to unpack .../59-libpgtypes3_17.2-1_arm64.deb ... 328s Unpacking libpgtypes3:arm64 (17.2-1) ... 328s Selecting previously unselected package libpq5:arm64. 328s Preparing to unpack .../60-libpq5_17.2-1_arm64.deb ... 328s Unpacking libpq5:arm64 (17.2-1) ... 328s Selecting previously unselected package libecpg6:arm64. 328s Preparing to unpack .../61-libecpg6_17.2-1_arm64.deb ... 328s Unpacking libecpg6:arm64 (17.2-1) ... 328s Selecting previously unselected package libecpg-compat3:arm64. 328s Preparing to unpack .../62-libecpg-compat3_17.2-1_arm64.deb ... 328s Unpacking libecpg-compat3:arm64 (17.2-1) ... 328s Selecting previously unselected package libssl-dev:arm64. 328s Preparing to unpack .../63-libssl-dev_3.4.0-1ubuntu2_arm64.deb ... 328s Unpacking libssl-dev:arm64 (3.4.0-1ubuntu2) ... 328s Selecting previously unselected package libpq-dev. 328s Preparing to unpack .../64-libpq-dev_17.2-1_arm64.deb ... 328s Unpacking libpq-dev (17.2-1) ... 328s Selecting previously unselected package libecpg-dev. 328s Preparing to unpack .../65-libecpg-dev_17.2-1_arm64.deb ... 328s Unpacking libecpg-dev (17.2-1) ... 328s Selecting previously unselected package libicu-dev:arm64. 328s Preparing to unpack .../66-libicu-dev_74.2-1ubuntu4_arm64.deb ... 328s Unpacking libicu-dev:arm64 (74.2-1ubuntu4) ... 329s Selecting previously unselected package libncurses-dev:arm64. 329s Preparing to unpack .../67-libncurses-dev_6.5-2_arm64.deb ... 329s Unpacking libncurses-dev:arm64 (6.5-2) ... 329s Selecting previously unselected package libtcl8.6:arm64. 329s Preparing to unpack .../68-libtcl8.6_8.6.15+dfsg-2_arm64.deb ... 329s Unpacking libtcl8.6:arm64 (8.6.15+dfsg-2) ... 329s Selecting previously unselected package libxml2-dev:arm64. 329s Preparing to unpack .../69-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2build1_arm64.deb ... 329s Unpacking libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2build1) ... 329s Selecting previously unselected package libxslt1.1:arm64. 329s Preparing to unpack .../70-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 329s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 329s Selecting previously unselected package llvm-19-runtime. 329s Preparing to unpack .../71-llvm-19-runtime_1%3a19.1.6-1ubuntu1_arm64.deb ... 329s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 329s Selecting previously unselected package libpfm4:arm64. 329s Preparing to unpack .../72-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 329s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 329s Selecting previously unselected package llvm-19. 329s Preparing to unpack .../73-llvm-19_1%3a19.1.6-1ubuntu1_arm64.deb ... 329s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 329s Selecting previously unselected package libffi-dev:arm64. 329s Preparing to unpack .../74-libffi-dev_3.4.6-1build1_arm64.deb ... 329s Unpacking libffi-dev:arm64 (3.4.6-1build1) ... 329s Selecting previously unselected package llvm-19-tools. 329s Preparing to unpack .../75-llvm-19-tools_1%3a19.1.6-1ubuntu1_arm64.deb ... 329s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 330s Selecting previously unselected package llvm-19-dev. 330s Preparing to unpack .../76-llvm-19-dev_1%3a19.1.6-1ubuntu1_arm64.deb ... 330s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 331s Selecting previously unselected package locales-all. 331s Preparing to unpack .../77-locales-all_2.40-4ubuntu1_arm64.deb ... 331s Unpacking locales-all (2.40-4ubuntu1) ... 333s Selecting previously unselected package postgresql-client-16. 333s Preparing to unpack .../78-postgresql-client-16_16.4-3_arm64.deb ... 333s Unpacking postgresql-client-16 (16.4-3) ... 333s Selecting previously unselected package postgresql-16. 333s Preparing to unpack .../79-postgresql-16_16.4-3_arm64.deb ... 333s Unpacking postgresql-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-server-dev-16. 334s Preparing to unpack .../80-postgresql-server-dev-16_16.4-3_arm64.deb ... 334s Unpacking postgresql-server-dev-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-server-dev-all:arm64. 334s Preparing to unpack .../81-postgresql-server-dev-all_262_arm64.deb ... 334s Unpacking postgresql-server-dev-all:arm64 (262) ... 334s Selecting previously unselected package postgresql-plperl-16. 334s Preparing to unpack .../82-postgresql-plperl-16_16.4-3_arm64.deb ... 334s Unpacking postgresql-plperl-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-plpython3-16. 334s Preparing to unpack .../83-postgresql-plpython3-16_16.4-3_arm64.deb ... 334s Unpacking postgresql-plpython3-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-pltcl-16. 334s Preparing to unpack .../84-postgresql-pltcl-16_16.4-3_arm64.deb ... 334s Unpacking postgresql-pltcl-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-all. 334s Preparing to unpack .../85-postgresql-all_262_all.deb ... 334s Unpacking postgresql-all (262) ... 334s Selecting previously unselected package postgresql-doc-16. 334s Preparing to unpack .../86-postgresql-doc-16_16.4-3_all.deb ... 334s Unpacking postgresql-doc-16 (16.4-3) ... 334s Selecting previously unselected package postgresql-doc. 334s Preparing to unpack .../87-postgresql-doc_16+262_all.deb ... 334s Unpacking postgresql-doc (16+262) ... 334s Setting up postgresql-client-common (262) ... 334s Setting up libpgtypes3:arm64 (17.2-1) ... 334s Setting up libncurses-dev:arm64 (6.5-2) ... 334s Setting up libclang-common-19-dev:arm64 (1:19.1.6-1ubuntu1) ... 334s Setting up postgresql-doc-16 (16.4-3) ... 334s 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 334s Setting up libarchive-zip-perl (1.68-1) ... 334s Setting up libdebhelper-perl (13.23ubuntu1) ... 334s Setting up libpq5:arm64 (17.2-1) ... 334s Setting up m4 (1.4.19-4build1) ... 334s Setting up libgomp1:arm64 (14.2.0-12ubuntu1) ... 334s Setting up libffi-dev:arm64 (3.4.6-1build1) ... 334s Setting up locales-all (2.40-4ubuntu1) ... 334s Setting up libfakeroot:arm64 (1.36.2-1) ... 334s Setting up fakeroot (1.36.2-1) ... 335s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 335s Setting up autotools-dev (20220109.1) ... 335s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 335s Setting up emacsen-common (3.0.5) ... 335s Setting up ssl-cert (1.1.3ubuntu1) ... 335s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 335s Setting up libssl-dev:arm64 (3.4.0-1ubuntu2) ... 335s Setting up libmpc3:arm64 (1.3.1-1build2) ... 335s Setting up libtcl8.6:arm64 (8.6.15+dfsg-2) ... 335s Setting up autopoint (0.22.5-3) ... 335s Setting up icu-devtools (74.2-1ubuntu4) ... 335s Setting up libgc1:arm64 (1:8.2.8-1) ... 335s Setting up autoconf (2.72-3) ... 335s Setting up libubsan1:arm64 (14.2.0-12ubuntu1) ... 335s Setting up dwz (0.15-1build6) ... 335s Setting up libhwasan0:arm64 (14.2.0-12ubuntu1) ... 335s Setting up libasan8:arm64 (14.2.0-12ubuntu1) ... 335s Setting up libjson-perl (4.10000-1) ... 335s Setting up postgresql-doc (16+262) ... 335s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 335s Setting up debugedit (1:5.1-1) ... 335s Setting up libecpg6:arm64 (17.2-1) ... 335s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 335s Setting up libtsan2:arm64 (14.2.0-12ubuntu1) ... 335s Setting up libisl23:arm64 (0.27-1) ... 335s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 335s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 335s Setting up libicu-dev:arm64 (74.2-1ubuntu4) ... 335s Setting up libcc1-0:arm64 (14.2.0-12ubuntu1) ... 335s Setting up liblsan0:arm64 (14.2.0-12ubuntu1) ... 335s Setting up libitm1:arm64 (14.2.0-12ubuntu1) ... 335s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 335s Setting up automake (1:1.16.5-1.3ubuntu1) ... 335s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 335s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 335s Setting up gettext (0.22.5-3) ... 335s Setting up libecpg-compat3:arm64 (17.2-1) ... 335s Setting up dictionaries-common (1.30.2) ... 336s Setting up postgresql-client-16 (16.4-3) ... 336s 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 336s Setting up libpq-dev (17.2-1) ... 336s Setting up libobjc4:arm64 (14.2.0-12ubuntu1) ... 336s Setting up libecpg-dev (17.2-1) ... 336s Setting up intltool-debian (0.35.0+20060710.6) ... 336s Setting up libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2build1) ... 336s Setting up postgresql-common (262) ... 337s Creating config file /etc/postgresql-common/createcluster.conf with new version 337s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 337s en_us 337s Removing obsolete dictionary files: 337s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 338s Setting up dh-strip-nondeterminism (1.14.0-1) ... 338s Setting up cpp-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 338s Setting up hunspell-en-us (1:2020.12.07-3) ... 338s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 338s Setting up libgcc-14-dev:arm64 (14.2.0-12ubuntu1) ... 338s Setting up libstdc++-14-dev:arm64 (14.2.0-12ubuntu1) ... 338s Setting up postgresql-16 (16.4-3) ... 338s Creating new PostgreSQL cluster 16/main ... 338s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 338s The files belonging to this database system will be owned by user "postgres". 338s This user must also own the server process. 338s 338s The database cluster will be initialized with locale "C.UTF-8". 338s The default database encoding has accordingly been set to "UTF8". 338s The default text search configuration will be set to "english". 338s 338s Data page checksums are disabled. 338s 338s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 338s creating subdirectories ... ok 338s selecting dynamic shared memory implementation ... posix 338s selecting default max_connections ... 100 338s selecting default shared_buffers ... 128MB 338s selecting default time zone ... Etc/UTC 338s creating configuration files ... ok 338s running bootstrap script ... ok 339s performing post-bootstrap initialization ... ok 339s syncing data to disk ... ok 342s Setting up po-debconf (1.0.21+nmu1) ... 342s Setting up libobjc-14-dev:arm64 (14.2.0-12ubuntu1) ... 342s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 343s Setting up cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 343s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 343s Setting up postgresql-server-dev-16 (16.4-3) ... 343s Setting up cpp-14 (14.2.0-12ubuntu1) ... 343s Setting up postgresql-plpython3-16 (16.4-3) ... 343s Setting up cpp (4:14.1.0-2ubuntu1) ... 343s Setting up postgresql-plperl-16 (16.4-3) ... 343s Setting up gcc-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 343s Setting up postgresql-server-dev-all:arm64 (262) ... 343s Setting up gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 343s Setting up g++-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 343s Setting up postgresql-pltcl-16 (16.4-3) ... 343s Setting up libtool (2.4.7-8) ... 343s Setting up postgresql-all (262) ... 343s Setting up gcc-14 (14.2.0-12ubuntu1) ... 343s Setting up dh-autoreconf (20) ... 343s Setting up g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 343s Setting up g++-14 (14.2.0-12ubuntu1) ... 343s Setting up debhelper (13.23ubuntu1) ... 343s Setting up gcc (4:14.1.0-2ubuntu1) ... 343s Setting up g++ (4:14.1.0-2ubuntu1) ... 343s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 343s Setting up build-essential (12.10ubuntu1) ... 343s Processing triggers for libc-bin (2.40-4ubuntu1) ... 343s Processing triggers for systemd (257-2ubuntu1) ... 343s Processing triggers for man-db (2.13.0-1) ... 344s Processing triggers for install-info (7.1.1-1) ... 344s Processing triggers for dictionaries-common (1.30.2) ... 347s autopkgtest [22:47:33]: test run-testsuite: [----------------------- 347s ====== Running all tests with umask 077 ======= 347s ### PostgreSQL test 001_packages.t ### 347s 1..22 347s ok 1 - /etc/os-release exists 347s ok 2 - OS is ubuntu 347s ok 3 - OS version is 25.04 347s # PostgreSQL versions installed: 16 347s ok 4 - postgresql-16 installed 347s ok 5 # skip No python2 support 347s ok 6 - postgresql-plpython3-16 installed 347s ok 7 - postgresql-plperl-16 installed 347s ok 8 - postgresql-pltcl-16 installed 347s ok 9 - postgresql-server-dev-16 installed 347s ok 10 # skip No postgresql-contrib-16 package for version 16 347s # postgresql-doc-16 installed 347s ok 11 - At least one doc package installed 347s ok 12 - libecpg-dev installed 348s ok 13 - procps installed 348s ok 14 - netcat-openbsd installed 348s ok 15 - hunspell-en-us installed 348s ok 16 - system has a default UTF-8 locale 348s ok 17 - locale ru_RU exists 348s ok 18 - locale ru_RU.UTF-8 exists 348s ok 19 - user postgres in the UNIX group ssl-cert 348s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 348s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 348s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 348s ### End test 001_packages.t ### 348s 348s ### PostgreSQL test 002_existing_clusters.t ### 348s 1..8 348s # Cleanup 348s ok 1 - Cleanup: No clusters left behind 348s ok 2 - No postgres processes left behind 348s ok 3 - No files in /etc/postgresql left behind 348s ok 4 - No files in /var/lib/postgresql left behind 348s ok 5 - No files in /var/run/postgresql left behind 348s ok 6 - No files in /var/log/postgresql left behind 348s ok 7 - PostgreSQL TCP ports are closed 348s ok 8 - Next free port is 5432 348s ### End test 002_existing_clusters.t ### 348s 348s ### PostgreSQL test 003_alternatives.t ### 348s 1..9 348s # Newest PG version installed is 16 348s ok 1 - psql.1.gz link group 348s ok 2 - postmaster.1.gz link group does not exist 348s ok 3 - psql.1.gz alternative 348s ok 4 - pg_dump.1.gz alternative 348s ok 5 - postgres.1.gz alternative 348s ok 6 - pg_ctl.1.gz alternative 348s # Newest PG doc version installed is 16 348s ok 7 - SPI_connect.3.gz link group 348s ok 8 - SPI_connect.3.gz alternative 348s ok 9 - SPI_exec.3.gz alternative 348s ### End test 003_alternatives.t ### 348s 348s ### PostgreSQL test 005_PgCommon.t ### 348s 1..24 348s ok 1 - correctly parsed line 'local all postgres ident sameuser' 348s ok 2 - correctly parsed line 'local foo nobody trust' 348s ok 3 - correctly parsed line 'local foo nobody crypt' 348s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 348s ok 5 - correctly parsed line 'local foo,bar nobody ident' 348s ok 6 - correctly parsed line 'local all +foogrp password' 348s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 348s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 348s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 348s ok 10 - @expected_records has correct number of entries 348s ok 11 - returned read_pg_hba array has correct number of records 348s ok 12 - line 'foo all all md5' parsed as invalid 348s ok 13 - line 'local all all foo' parsed as invalid 348s ok 14 - line 'host all all foo' parsed as invalid 348s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 348s ok 16 - line 'host all all md5' parsed as invalid 348s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 348s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 348s ok 19 - read_conf_file returns empty dict for nonexisting file 348s ok 20 - read_conf_file() parsing 348s ok 21 - read_conf_file() parsing with include directives 348s ok 22 - set_conf_value 348s ok 23 - disable_conf_value 348s ok 24 - replace_conf_value 348s ### End test 005_PgCommon.t ### 348s 348s ### PostgreSQL test 006_next_free_port.t ### 348s 1..5 348s ok 1 - next_free_port is 5432 349s ok 2 - next_free_port detects localhost ipv4 socket 350s ok 3 - next_free_port detects wildcard ipv4 socket 351s ok 4 - next_free_port detects localhost ipv6 socket 352s ok 5 - next_free_port detects wildcard ipv6 socket 352s ### End test 006_next_free_port.t ### 352s 352s ### PostgreSQL test 007_pg_conftool.t ### 352s 1..41 352s # test without cluster 352s ok 1 - pg_conftool show all 352s ok 2 - correct output of pg_conftool show all 352s ok 3 - pg_conftool foo.conf show all 352s ok 4 - correct output of pg_conftool foo.conf show all 352s ok 5 - pg_conftool /tmp/zqf6kwSxem/different.conf show all 352s ok 6 - correct output of pg_conftool /tmp/zqf6kwSxem/different.conf show all 352s ok 7 - pg_conftool 9.7 main show all 352s ok 8 - correct output of pg_conftool 9.7 main show all 352s # test show 352s ok 9 - pg_conftool show all 352s ok 10 - correct output of pg_conftool show all 352s ok 11 - pg_conftool other.conf show all 352s ok 12 - correct output of pg_conftool other.conf show all 352s ok 13 - pg_conftool /tmp/zqf6kwSxem/different.conf show all 352s ok 14 - correct output of pg_conftool /tmp/zqf6kwSxem/different.conf show all 352s ok 15 - pg_conftool 16 main show all 352s ok 16 - correct output of pg_conftool 16 main show all 353s ok 17 - pg_conftool 16 main other.conf show all 353s ok 18 - correct output of pg_conftool 16 main other.conf show all 353s ok 19 - pg_conftool show a 353s ok 20 - correct output of pg_conftool show a 353s ok 21 - pg_conftool -s show a 353s ok 22 - correct output of pg_conftool -s show a 353s # test set 353s ok 23 - pg_conftool set c 7 353s ok 24 - correct output of pg_conftool set c 7 353s ok 25 - file contains new setting 353s ok 26 - pg_conftool set a 8 353s ok 27 - correct output of pg_conftool set a 8 353s ok 28 - file contains updated setting 353s ok 29 - pg_conftool /tmp/zqf6kwSxem/different.conf set a 9 353s ok 30 - correct output of pg_conftool /tmp/zqf6kwSxem/different.conf set a 9 353s ok 31 - file with path contains updated setting 353s # test remove 353s ok 32 - pg_conftool remove a 353s ok 33 - correct output of pg_conftool remove a 353s ok 34 - setting removed from file 353s ok 35 - pg_conftool /tmp/zqf6kwSxem/different.conf remove a 353s ok 36 - correct output of pg_conftool /tmp/zqf6kwSxem/different.conf remove a 353s ok 37 - setting removed from file with path 353s # test edit 353s ok 38 - pg_conftool edit 353s ok 39 - correct output of pg_conftool edit 353s ok 40 - pg_conftool /tmp/zqf6kwSxem/different.conf edit 353s ok 41 - correct output of pg_conftool /tmp/zqf6kwSxem/different.conf edit 353s ### End test 007_pg_conftool.t ### 353s 353s ### PostgreSQL test 010_defaultport_cluster.t ### 353s 1..14 353s ok 1 - psql --version 353s ok 2 - pg_wrapper selects highest available version number 353s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 353s ok 4 - connecting to localhost fails with no clusters 353s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 353s ok 6 - pg_wrapper uses host and port from PGCLUSTER 353s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 353s ok 8 - pg_wrapper uses --cluster from the command line 353s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 353s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 353s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 353s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 353s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 353s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 354s ### End test 010_defaultport_cluster.t ### 354s 354s ### PostgreSQL test 015_start_stop.t ### 354s 1..71 354s # We are running systemd 354s # Running tests for 16 354s # Cluster does not exist yet 354s ok 1 - cluster 16 main does not exist 354s ok 2 - service postgresql@16-main does not exist 354s ok 3 - systemctl start postgresql 354s ok 4 - cluster 16 main does not exist 354s ok 5 - service postgresql@16-main does not exist 354s ok 6 - systemctl start postgresql@16-main 354s ok 7 - cluster 16 main does not exist 354s ok 8 - service postgresql@16-main does not exist 354s # Start/stop postgresql using system tools 355s ok 9 - pg_createcluster 16 main 355s ok 10 - cluster 16 main is stopped 355s ok 11 - service postgresql@16-main is stopped 357s ok 12 - systemctl start postgresql 357s ok 13 - cluster 16 main is running 357s ok 14 - service postgresql@16-main is running 357s ok 15 - systemctl start postgresql 357s ok 16 - cluster 16 main is already running 357s ok 17 - service postgresql@16-main is already running 357s ok 18 - systemctl stop postgresql 363s ok 19 - cluster 16 main is stopped 363s ok 20 - service postgresql@16-main is stopped 363s ok 21 - systemctl stop postgresql 363s ok 22 - cluster 16 main is already stopped 363s ok 23 - service postgresql@16-main is already stopped 363s # Start/stop specific cluster using system tools 366s ok 24 - systemctl start postgresql@16-main 366s ok 25 - cluster 16 main is running 366s ok 26 - service postgresql@16-main is running 366s ok 27 - systemctl start postgresql@16-main 366s ok 28 - cluster 16 main is running 366s ok 29 - service postgresql@16-main is running 368s ok 30 - systemctl restart postgresql@16-main 368s ok 31 - cluster 16 main is running 368s ok 32 - service postgresql@16-main is running 368s ok 33 - systemctl stop postgresql@16-main 369s ok 34 - cluster 16 main is stopped 369s ok 35 - service postgresql@16-main is stopped 369s ok 36 - systemctl stop postgresql@16-main 369s ok 37 - cluster 16 main is already stopped 369s ok 38 - service postgresql@16-main is already stopped 370s ok 39 - pg_dropcluster 16 main 370s ok 40 - cluster 16 main does not exist 370s ok 41 - service postgresql@16-main does not exist 370s # Start/stop specific cluster using pg_*cluster 370s ok 42 - pg_ctlcluster start 16 main 370s ok 43 - cluster 16 main does not exist 370s ok 44 - service postgresql@16-main does not exist 374s ok 45 - pg_createcluster 16 main --start 374s ok 46 - cluster 16 main is running 374s ok 47 - service postgresql@16-main is running 374s ok 48 - pg_ctlcluster 16 main start 374s ok 49 - cluster 16 main is already running 374s ok 50 - service postgresql@16-main is already running 376s ok 51 - pg_ctlcluster 16-main restart 376s ok 52 - cluster 16 main is running 376s ok 53 - service postgresql@16-main is running 377s ok 54 - pg_ctlcluster 16 main stop 377s ok 55 - cluster 16 main is stopped 377s ok 56 - service postgresql@16-main is stopped 377s ok 57 - pg_ctlcluster 16 main stop 377s ok 58 - cluster 16 main is already stopped 377s ok 59 - service postgresql@16-main is already stopped 379s ok 60 - pg_ctlcluster start 16-main 379s ok 61 - cluster 16 main is running 379s ok 62 - service postgresql@16-main is running 381s ok 63 - pg_dropcluster 16 main --stop 381s # Cleanup 381s ok 64 - Cleanup: No clusters left behind 381s ok 65 - No postgres processes left behind 381s ok 66 - No files in /etc/postgresql left behind 381s ok 67 - No files in /var/lib/postgresql left behind 381s ok 68 - No files in /var/run/postgresql left behind 381s ok 69 - No files in /var/log/postgresql left behind 381s ok 70 - PostgreSQL TCP ports are closed 381s ok 71 - Next free port is 5432 381s ### End test 015_start_stop.t ### 381s 381s ### PostgreSQL test 020_create_sql_remove.t ### 381s 1..147 381s # Running tests for 16 385s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.HyjTWK 385s ok 2 - pg_createcluster 16 main 385s ok 3 - Socket and pid file are in /var/run/postgresql/ 385s ok 4 - xlog/wal directory /tmp/16.xlog.HyjTWK was created 385s ok 5 - local method in pg_hba.conf is peer 385s ok 6 - host method in pg_hba.conf is scram-sha-256 385s ok 7 - Exactly one postgres master process running 387s ok 8 - pg_ctlcluster 16 main restart 387s ok 9 - cluster restarts with new environment file 387s ok 10 - Exactly one postgres master process running 387s ok 11 - correct value of PGEXTRAVAR1 in environment 387s ok 12 - correct value of PGEXTRAVAR2 in environment 387s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 387s ok 14 - createdb --version 387s ok 15 - pg_wrapper+createdb selects version number of cluster 387s ok 16 - psql --version 387s ok 17 - pg_wrapper+psql selects version 16 387s ok 18 - pg_lscluster reports online cluster on port 5432 387s ok 19 - log file is actually used 387s ok 20 - /etc/postgresql is owned by user "postgres" 387s ok 21 - version configuration directory file is owned by user "postgres" 387s ok 22 - configuration directory file is owned by user "postgres" 387s ok 23 - version data directory file is owned by user "postgres" 387s ok 24 - data directory file is owned by user "postgres" 387s ok 25 - log file has 0640 permissions 387s ok 26 - log file is owned by user "postgres" 387s ok 27 - log file is owned by group "adm" 387s ok 28 - no log symlink by default 387s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 387s ok 30 - pg_lsclusters -h 387s ok 31 - correct output of pg_lsclusters -h 387s ok 32 - stopping cluster 390s ok 33 - restarting cluster with nondefault log symlink 390s ok 34 - log target is used as log file 390s ok 35 - default log is not used 390s ok 36 - pg_lsclusters -h 390s ok 37 - correct output of pg_lsclusters -h 390s ok 38 - stopping cluster 393s ok 39 - restarting cluster with explicitly configured log file 393s ok 40 - default log is not used 393s ok 41 - log symlink target is used for startup message 393s ok 42 - exactly one log file 393s ok 43 - custom log is actually used 393s ok 44 - pg_lsclusters -h 393s ok 45 - correct output of pg_lsclusters -h 393s ok 46 - stopping cluster 393s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 393s ok 48 - /etc/postgres-hack was not created 396s ok 49 - restarting cluster 396s ok 50 - ps -o tty -U postgres h 396s ok 51 - postgres processes do not have an associated terminal 396s ok 52 - Server is linked with SSL support 396s ok 53 - SSL is enabled in postgresql.conf 396s ok 54 - psql -l fails for nobody 396s ok 55 - createuser nobody 396s ok 56 - createdb nobodydb 396s ok 57 - psql -ltA succeeds for nobody 396s ok 58 - psql -ltA output 396s ok 59 - SQL command: create table 396s ok 60 - SQL command: insert into table values 396s ok 61 - SQL command: insert into table values 396s ok 62 - primary key violation 396s ok 63 - psql -tAc "select * from phone order by name" nobodydb 396s ok 64 - SQL command output: select -tA 396s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 396s ok 66 - SQL command output: select -tx 396s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 396s ok 68 - SQL command output: select -tAx 396s ok 69 - CREATE EXTENSION plperlu fails for user nobody 396s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 396s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 396s ok 72 - creating PL/PerlU function as user nobody fails 396s ok 73 - creating unsafe PL/Perl function as user postgres fails 396s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 396s ok 75 - creating PL/PerlU function as user postgres succeeds 396s ok 76 - psql nobodydb -Atc "select read_file()" 396s ok 77 - calling PL/PerlU function 396s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 396s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 397s ok 80 - creating unsafe PL/Perl function as user nobody fails 397s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 397s ok 82 - creating PL/Perl function as user nobody succeeds 397s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 397s ok 84 - calling PL/Perl function 397s ok 85 # skip No python2 support 397s ok 86 # skip No python2 support 397s ok 87 # skip No python2 support 397s ok 88 # skip No python2 support 397s ok 89 # skip No python2 support 397s ok 90 # skip No python2 support 397s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 397s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 397s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 397s ok 94 - creating PL/Python3 function as user postgres succeeds 397s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 397s ok 96 - calling PL/Python function 397s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 397s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 397s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 397s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 397s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 397s ok 102 - creating PL/Tcl function as user nobody succeeds 397s 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;" 397s ok 104 - creating PL/TclU function as user postgres succeeds 397s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 397s ok 106 - calling PL/Tcl function 397s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 397s ok 108 - calling PL/TclU function 397s ok 109 - stopping cluster 397s ok 110 - pg_ctlcluster 16 main start 397s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 400s ok 112 - pg_ctlcluster 16 main start 400s ok 113 - cluster restarts with pgdata symlink 400s ok 114 - postgres master has OOM killer protection 400s ok 115 - postgres client backend has no OOM adjustment 400s ok 116 - ps h 6460 400s ok 117 - process title is idle 401s ok 118 - ps h 6460 401s ok 119 - process title is idle in transaction 401s ok 120 - stopping cluster 403s ok 121 - starting cluster as postgres works without a log file 403s ok 122 - log file got recreated and used 403s ok 123 - creating a directory in spc2 403s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.anHJHL'" 403s ok 125 - creating tablespace spc1 403s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 403s ok 127 - creating a table in spc1 403s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.9z9_xk'" 403s ok 129 - creating tablespace spc2 403s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 403s ok 131 - creating a table in spc2 403s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 403s ok 133 - Correct apt NeverAutoRemove config 405s ok 134 - pg_dropcluster removes cluster 405s ok 135 - xlog/wal directory /tmp/16.xlog.HyjTWK was deleted 405s ok 136 - tablespace spc1 was emptied 405s ok 137 - tablespace spc2 was emptied 405s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 405s ok 139 - Correct apt NeverAutoRemove config 405s # Cleanup 405s ok 140 - Cleanup: No clusters left behind 405s ok 141 - No postgres processes left behind 405s ok 142 - No files in /etc/postgresql left behind 405s ok 143 - No files in /var/lib/postgresql left behind 405s ok 144 - No files in /var/run/postgresql left behind 405s ok 145 - No files in /var/log/postgresql left behind 405s ok 146 - PostgreSQL TCP ports are closed 405s ok 147 - Next free port is 5432 405s ### End test 020_create_sql_remove.t ### 405s 405s ### PostgreSQL test 021_pg_renamecluster.t ### 405s 1..20 408s ok 1 - pg_createcluster 16 main 411s ok 2 - pg_renamecluster 16 main donau 411s ok 3 - psql -tAc "show data_directory" 411s ok 4 - cluster is running and data_directory was moved 411s ok 5 - pg_hba.conf location updated 411s ok 6 - pg_ident.conf location updated 411s ok 7 - external_pid_file location updated 411s ok 8 - external_pid_file exists 411s ok 9 # skip no stats_temp_directory in 16 411s ok 10 # skip no stats_temp_directory in 16 411s ok 11 - cluster_name is updated 412s ok 12 - pg_dropcluster removes cluster 412s # Cleanup 412s ok 13 - Cleanup: No clusters left behind 412s ok 14 - No postgres processes left behind 412s ok 15 - No files in /etc/postgresql left behind 412s ok 16 - No files in /var/lib/postgresql left behind 412s ok 17 - No files in /var/run/postgresql left behind 412s ok 18 - No files in /var/log/postgresql left behind 412s ok 19 - PostgreSQL TCP ports are closed 412s ok 20 - Next free port is 5432 412s ### End test 021_pg_renamecluster.t ### 412s 412s ### PostgreSQL test 022_recovery.t ### 413s 1..17 413s # Running tests for 16 416s ok 1 - pg_createcluster 16 main --start >/dev/null 416s ok 2 - pg_ctlcluster 16 main stop -m i 418s ok 3 - pg_ctlcluster 16 main start 418s ok 4 - psql -c '' 419s ok 5 - pg_ctlcluster 16 main stop -m i 419s ok 6 - create write-protected file in data directory 421s ok 7 - pg_ctlcluster 16 main start 421s ok 8 - psql -c '' 422s ok 9 - pg_dropcluster removes cluster 422s # Cleanup 422s ok 10 - Cleanup: No clusters left behind 422s ok 11 - No postgres processes left behind 422s ok 12 - No files in /etc/postgresql left behind 422s ok 13 - No files in /var/lib/postgresql left behind 422s ok 14 - No files in /var/run/postgresql left behind 422s ok 15 - No files in /var/log/postgresql left behind 422s ok 16 - PostgreSQL TCP ports are closed 422s ok 17 - Next free port is 5432 422s ### End test 022_recovery.t ### 422s 422s ### PostgreSQL test 025_logging.t ### 423s 1..55 423s # Logging to /var/log/syslog works 423s # Running tests for 16 426s ok 1 - pg_createcluster 16 main 426s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 426s ok 3 - psql -qc "'foobar_16_7682'" 426s ok 4 - log an error 427s ok 5 - grep --binary-files=text foobar_16_7682 /var/log/postgresql/postgresql-16-main.log 427s ok 6 - error appears in logfile 427s ok 7 - pg_conftool 16 main set log_destination syslog 427s ok 8 - set log_destination syslog 427s ok 9 - pg_ctlcluster 16 main reload 427s ok 10 - 16 main reload 427s ok 11 - psql -Atc "show log_destination" 427s ok 12 - log_destination is syslog 427s ok 13 - pg_lscluster reports syslog 428s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 428s ok 15 - error appears in /var/log/syslog 428s ok 16 - pg_conftool 16 main set logging_collector on 428s ok 17 - set logging_collector on 428s ok 18 - pg_conftool 16 main set log_destination csvlog 428s ok 19 - set log_destination csvlog 430s ok 20 - pg_ctlcluster 16 main restart 430s ok 21 - 16 main restart 430s ok 22 - psql -Atc "show logging_collector" 430s ok 23 - logging_collector is on 430s ok 24 - psql -Atc "show log_destination" 430s ok 25 - log_destination is csvlog 430s ok 26 - pg_lscluster reports csvlog 430s ok 27 - psql -qc "'barbaz_16_7682'" 430s ok 28 - log an error 431s ok 29 - grep --binary-files=text barbaz_16_7682 /var/lib/postgresql/16/main/log/*.csv 431s ok 30 - error appears in log/*.csv 431s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 431s ok 32 - set log_destination stderr,syslog,csvlog 431s ok 33 - pg_ctlcluster 16 main reload 431s ok 34 - 16 main reload 431s ok 35 - psql -Atc "show log_destination" 431s ok 36 - log_destination is stderr,syslog,csvlog 431s ok 37 - pg_lscluster reports stderr,syslog,csvlog 431s ok 38 - psql -qc "'moo_16_7682'" 431s ok 39 - log an error 431s ok 40 - grep --binary-files=text moo_16_7682 /var/lib/postgresql/16/main/log/*.log 431s ok 41 - error appears in log/*.log 432s ok 42 - grep --binary-files=text 'postgres.*moo_16_7682' /var/log/syslog 432s ok 43 - error appears in /var/log/syslog 432s ok 44 - grep --binary-files=text moo_16_7682 /var/lib/postgresql/16/main/log/*.csv 432s ok 45 - error appears in log/*.csv 433s ok 46 - pg_dropcluster 16 main --stop 433s ok 47 - pg_dropcluster removes cluster 433s # Cleanup 433s ok 48 - Cleanup: No clusters left behind 433s ok 49 - No postgres processes left behind 433s ok 50 - No files in /etc/postgresql left behind 433s ok 51 - No files in /var/lib/postgresql left behind 433s ok 52 - No files in /var/run/postgresql left behind 433s ok 53 - No files in /var/log/postgresql left behind 433s ok 54 - PostgreSQL TCP ports are closed 433s ok 55 - Next free port is 5432 433s ### End test 025_logging.t ### 433s 433s ### PostgreSQL test 027_jit.t ### 434s # 16 437s ok 1 - pg_createcluster 16 main --start 437s ok 2 - psql -Xatc 'show jit' 437s ok 3 - JIT is on by default 437s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 437s ok 5 - No JIT on cheap query 437s ok 6 - pg_conftool 16 main set seq_page_cost 100000 437s ok 7 - pg_conftool 16 main set random_page_cost 100000 437s ok 8 - pg_ctlcluster 16 main reload 438s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 438s ok 10 - Expensive query is JITed 439s ok 11 - pg_dropcluster --stop 16 main 439s # Cleanup 439s ok 12 - Cleanup: No clusters left behind 439s ok 13 - No postgres processes left behind 439s ok 14 - No files in /etc/postgresql left behind 439s ok 15 - No files in /var/lib/postgresql left behind 439s ok 16 - No files in /var/run/postgresql left behind 439s ok 17 - No files in /var/log/postgresql left behind 439s ok 18 - PostgreSQL TCP ports are closed 439s ok 19 - Next free port is 5432 439s 1..19 439s ### End test 027_jit.t ### 439s 439s ### PostgreSQL test 030_errors.t ### 439s 1..156 439s ok 1 - pg_lscluster reports cluster without binaries 440s ok 2 - pg_dropcluster 6.3 main 441s ok 3 - pg_createcluster --socketdir 441s ok 4 - pg_lsclusters -h 441s ok 5 - cluster was created 441s ok 6 - Port of created cluster is 5432 441s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 441s ok 8 - pg_createcluster on existing cluster 441s ok 9 - pg_lsclusters -h 441s ok 10 - original cluster still exists 441s ok 11 - pg_createcluster 16 test -p foo 441s ok 12 - pg_createcluster -p checks that port option is numeric 442s ok 13 - pg_createcluster 16 test -p 42 442s ok 14 - pg_createcluster -p checks valid port range 442s ok 15 - pg_ctlcluster 16 main start 442s ok 16 - pg_ctlcluster refuses to start root-owned cluster 442s ok 17 - pg_ctlcluster 16 main start 442s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 442s ok 19 - pg_ctlcluster 16 main start 442s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 442s ok 21 - pg_ctlcluster 16 main start 442s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 444s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 444s ok 24 - No sockets in /var/run/postgresql 444s ok 25 - Socket is in /tmp/postgresql-testsuite/ 444s ok 26 - cluster stops with custom unix_socket_dir 444s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 446s ok 28 - cluster starts after removing unix_socket_dir 446s ok 29 - Socket is in default dir /var/run/postgresql 446s ok 30 - No sockets in /tmp/postgresql-testsuite/ 447s ok 31 - pg_ctlcluster 16 main stop 447s ok 32 - pg_ctlcluster fails with corrupted PID file 447s ok 33 - pg_lsclusters -h 447s ok 34 - cluster is still online 447s ok 35 - pg_ctlcluster succeeds with restored PID file 447s ok 36 - pg_lsclusters -h 447s ok 37 - cluster is down 447s ok 38 - pg_ctlcluster 16 main stop 447s ok 39 - pg_ctlcluster stop fails on stopped cluster 449s ok 40 - pg_ctlcluster 16 main start 449s ok 41 - pg_ctlcluster succeeds with already existing PID file 449s ok 42 - pg_lsclusters -h 449s ok 43 - cluster is online 449s ok 44 - pg_ctlcluster stop succeeds 449s ok 45 - pg_lsclusters -h 449s ok 46 - cluster is down 449s ok 47 - no pid file left 449s ok 48 - pg_ctlcluster 16 main stop 449s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 449s ok 50 - pid file was cleaned up 449s ok 51 - pg_ctlcluster --force 16 main stop 449s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 449s ok 53 - pid file was cleaned up 449s ok 54 - pg_ctlcluster 16 main stop 449s ok 55 - pg_ctlcluster stop succeeds with stale PID file 449s ok 56 - pid file was cleaned up 449s ok 57 - pg_ctlcluster --force 16 main stop 449s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 449s ok 59 - pid file was cleaned up 450s ok 60 - pg_ctlcluster --force 16 main stop 450s ok 61 - pg_ctlcluster stop succeeds with empty PID file 450s ok 62 - pid file was cleaned up 452s ok 63 - pg_ctlcluster 16 main start 452s ok 64 - pg_ctlcluster succeeds with corrupted PID file 452s ok 65 - pg_lsclusters -h 452s ok 66 - cluster is online 452s ok 67 - pg_ctlcluster 16 main start 452s ok 68 - pg_ctlcluster start fails on running cluster 452s ok 69 - pg_ctlcluster stop 452s ok 70 - pg_ctlcluster 16 main start 452s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 452s ok 72 - pg_ctlcluster 16 main stop 452s ok 73 - stopping cluster 458s ok 74 - pg_ctlcluster 16 main start 458s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 459s ok 76 - pg_ctlcluster 16 main stop 459s ok 77 - stopping cluster 459s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 459s ok 79 - pg_dropcluster 16 main 459s ok 80 - pg_dropcluster works as user postgres 460s ok 81 - pg_createcluster succeeds 460s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 460s ok 83 - proper error message for nonexisting /var/lib/postgresql 462s ok 84 - pg_ctlcluster 16 main start 462s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 462s ok 86 - pg_ctlcluster 16 main stop 462s ok 87 - stopping cluster 463s ok 88 - pg_createcluster other 465s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 467s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 468s ok 91 468s ok 92 - pg_ctlcluster 16 other start 468s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 468s ok 94 - pg_ctlcluster 16 main stop 468s ok 95 - stopping main cluster 470s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 471s ok 97 - pg_dropcluster other 473s ok 98 - pg_dropcluster 473s ok 99 - No sockets any more 473s ok 100 - 'pg_lsclusters 4.5 foo' fails 473s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 473s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 473s ok 103 - 'psql --cluster 4.5/foo' fails 473s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 473s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 473s ok 106 - 'psql --cluster 16/foo' fails 473s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 473s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 473s ok 109 - 'pg_dropcluster 4.5 foo' fails 473s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 473s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 473s ok 112 - 'pg_dropcluster 16 foo' fails 473s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 473s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 473s ok 115 - 'pg_upgradecluster 4.5 foo' fails 473s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 473s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 473s ok 118 - 'pg_upgradecluster 16 foo' fails 473s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 473s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 473s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 473s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 473s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 473s ok 124 - 'pg_ctlcluster 16 foo stop' fails 473s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 473s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 473s # Cleanup 473s ok 127 - Cleanup: No clusters left behind 473s ok 128 - No postgres processes left behind 473s ok 129 - No files in /etc/postgresql left behind 473s ok 130 - No files in /var/lib/postgresql left behind 473s ok 131 - No files in /var/run/postgresql left behind 473s ok 132 - No files in /var/log/postgresql left behind 473s ok 133 - PostgreSQL TCP ports are closed 473s ok 134 - Next free port is 5432 474s ok 135 - pg_dropcluster 16 broken 474s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 474s # Cleanup 474s ok 137 - Cleanup: No clusters left behind 474s ok 138 - No postgres processes left behind 474s ok 139 - No files in /etc/postgresql left behind 474s ok 140 - No files in /var/lib/postgresql left behind 474s ok 141 - No files in /var/run/postgresql left behind 474s ok 142 - No files in /var/log/postgresql left behind 474s ok 143 - PostgreSQL TCP ports are closed 474s ok 144 - Next free port is 5432 475s ok 145 - pg_dropcluster 16 broken 475s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 475s ok 147 - /etc/postgresql/16 was removed 475s ok 148 - /var/lib/postgresql/16 was removed 475s # Cleanup 475s ok 149 - Cleanup: No clusters left behind 475s ok 150 - No postgres processes left behind 475s ok 151 - No files in /etc/postgresql left behind 475s ok 152 - No files in /var/lib/postgresql left behind 475s ok 153 - No files in /var/run/postgresql left behind 475s ok 154 - No files in /var/log/postgresql left behind 475s ok 155 - PostgreSQL TCP ports are closed 475s ok 156 - Next free port is 5432 475s ### End test 030_errors.t ### 475s 475s ### PostgreSQL test 031_errors_disk_full.t ### 476s 1..22 476s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 477s ok 1 - script failed 477s ok 2 - pg_createcluster fails due to insufficient disk space 477s ok 3 - does not leave files behind 477s # Cleanup 477s ok 4 - Cleanup: No clusters left behind 477s ok 5 - No postgres processes left behind 477s ok 6 - No files in /etc/postgresql left behind 477s ok 7 - No files in /var/lib/postgresql left behind 477s ok 8 - No files in /var/run/postgresql left behind 477s ok 9 - No files in /var/log/postgresql left behind 477s ok 10 - PostgreSQL TCP ports are closed 477s ok 11 - Next free port is 5432 477s # check disk full conditions on startup 479s ok 12 - script failed 479s ok 13 - pg_ctlcluster prints error message 479s ok 14 - log file has error message 479s # Cleanup 479s ok 15 - Cleanup: No clusters left behind 479s ok 16 - No postgres processes left behind 479s ok 17 - No files in /etc/postgresql left behind 479s ok 18 - No files in /var/lib/postgresql left behind 479s ok 19 - No files in /var/run/postgresql left behind 479s ok 20 - No files in /var/log/postgresql left behind 479s ok 21 - PostgreSQL TCP ports are closed 479s ok 22 - Next free port is 5432 479s ### End test 031_errors_disk_full.t ### 479s 479s ### PostgreSQL test 032_ssl_key_permissions.t ### 479s 1..22 479s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 479s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 479s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 479s # 16 (16.4-3) 480s ok 4 - pg_createcluster 16 main 480s ok 5 - pg_ctlcluster 16 main start 480s ok 6 - ssl key owned by nobody refused 481s ok 7 - pg_ctlcluster 16 main start 481s ok 8 - ssl key with permissions root:root 0644 refused 481s ok 9 - pg_ctlcluster 16 main start 481s ok 10 - ssl key with permissions postgres:postgres 0640 refused 482s ok 11 - pg_dropcluster 16 main --stop 482s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 482s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 482s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 482s # Cleanup 482s ok 15 - Cleanup: No clusters left behind 482s ok 16 - No postgres processes left behind 482s ok 17 - No files in /etc/postgresql left behind 482s ok 18 - No files in /var/lib/postgresql left behind 482s ok 19 - No files in /var/run/postgresql left behind 482s ok 20 - No files in /var/log/postgresql left behind 482s ok 21 - PostgreSQL TCP ports are closed 482s ok 22 - Next free port is 5432 482s ### End test 032_ssl_key_permissions.t ### 482s 482s ### PostgreSQL test 040_upgrade.t ### 482s 1..1 482s ok 1 - only one major version installed, skipping upgrade tests 482s ### End test 040_upgrade.t ### 482s 482s ### PostgreSQL test 041_upgrade_custompaths.t ### 482s 1..1 482s ok 1 - only one major version installed, skipping upgrade tests 482s ### End test 041_upgrade_custompaths.t ### 482s 482s ### PostgreSQL test 042_upgrade_rename.t ### 482s 1..15 482s # PostgreSQL 16 486s ok 1 - pg_createcluster 16 main --start 492s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 492s ok 3 - pg_lsclusters -h 492s ok 4 - correct output of pg_lsclusters -h 493s ok 5 - pg_dropcluster 16 main --stop 495s ok 6 - pg_dropcluster 16 upgr --stop 495s ok 7 - Cleaning pg_upgrade log files 495s # Cleanup 495s ok 8 - Cleanup: No clusters left behind 495s ok 9 - No postgres processes left behind 495s ok 10 - No files in /etc/postgresql left behind 495s ok 11 - No files in /var/lib/postgresql left behind 495s ok 12 - No files in /var/run/postgresql left behind 495s ok 13 - No files in /var/log/postgresql left behind 495s ok 14 - PostgreSQL TCP ports are closed 495s ok 15 - Next free port is 5432 495s ### End test 042_upgrade_rename.t ### 495s 495s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 495s 1..1 495s ok 1 - only one major version installed, skipping upgrade tests 495s ### End test 043_upgrade_ssl_cert.t ### 495s 495s ### PostgreSQL test 045_backup.t ### 495s # We are running systemd 495s # PostgreSQL 16 495s # create cluster 498s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 498s ok 2 - pg_lsclusters -h 498s ok 3 - correct output of pg_lsclusters -h 498s ok 4 - pg_conftool 16 main set work_mem 11MB 498s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 498s ok 6 - psql -c 'alter database mydb set search_path=public' 498s ok 7 - psql -c 'create table foo (t text)' mydb 498s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 498s ok 9 - psql -c 'CREATE USER myuser' 498s ok 10 - psql -c 'grant create on database mydb to myuser' 498s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 499s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 499s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 499s # create directory 499s ok 14 - pg_backupcluster 16 main createdirectory 499s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 499s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 499s # dump 499s ok 17 - systemctl start pg_dump@16-main 499s ok 18 - dump created in /var/backups/postgresql/16-main/2025-01-02T225005Z.dump 499s ok 19 - /var/backups/postgresql/16-main/2025-01-02T225005Z.dump owned by uid postgres 499s ok 20 - /var/backups/postgresql/16-main/2025-01-02T225005Z.dump owned by gid postgres 499s # basebackup 499s ok 21 - systemctl start pg_receivewal@16-main 499s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 500s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 500s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 500s ok 25 - psql -c 'select pg_reload_conf()' 528s ok 26 - systemctl start pg_basebackup@16-main 528s ok 27 - dump created in /var/backups/postgresql/16-main/2025-01-02T225006Z.backup 528s ok 28 - /var/backups/postgresql/16-main/2025-01-02T225006Z.backup owned by uid postgres 528s ok 29 - /var/backups/postgresql/16-main/2025-01-02T225006Z.backup owned by gid postgres 528s # list 528s ok 30 - pg_backupcluster 16 main list 528s ok 31 - correct output of pg_backupcluster 16 main list 528s # more database changes 528s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 528s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 528s ok 34 - retrieve recovery timestamp 528s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 528s ok 36 - systemctl stop pg_receivewal@16-main 528s # restore /var/backups/postgresql/16-main/2025-01-02T225005Z.dump 530s ok 37 - pg_dropcluster 16 main --stop 534s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T225005Z.dump --start --datadir /var/lib/postgresql/16/snowflake 534s ok 39 - pg_lsclusters -h 534s ok 40 - correct output of pg_lsclusters -h 534s ok 41 - psql -XAtl 534s ok 42 - mydb locales 534s ok 43 - mydb grants 534s ok 44 - myicudb locales 534s ok 45 - psql -XAtc 'show work_mem' 534s ok 46 - correct output of psql -XAtc 'show work_mem' 534s ok 47 - psql -XAtc 'select * from foo' mydb 534s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 534s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 534s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 534s ok 51 - psql -XAtc '\drds' 534s ok 52 - correct output of psql -XAtc '\drds' 534s # restore /var/backups/postgresql/16-main/2025-01-02T225006Z.backup 536s ok 53 - pg_dropcluster 16 main --stop 539s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T225006Z.backup --start --datadir /var/lib/postgresql/16/snowflake 539s ok 55 - pg_lsclusters -h 539s ok 56 - correct output of pg_lsclusters -h 539s ok 57 - psql -XAtl 539s ok 58 - mydb locales 539s ok 59 - mydb grants 539s ok 60 - myicudb locales 539s ok 61 - psql -XAtc 'show work_mem' 539s ok 62 - correct output of psql -XAtc 'show work_mem' 539s ok 63 - psql -XAtc 'select * from foo' mydb 539s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 539s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 539s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 540s ok 67 - psql -XAtc '\drds' 540s ok 68 - correct output of psql -XAtc '\drds' 540s # restore /var/backups/postgresql/16-main/2025-01-02T225006Z.backup with WAL archive 541s ok 69 - pg_dropcluster 16 main --stop 544s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T225006Z.backup --start --archive --port 5430 545s ok 71 - pg_lsclusters -h 545s ok 72 - correct output of pg_lsclusters -h 545s ok 73 - psql -XAtc 'select * from foo order by t' mydb 545s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 545s # restore /var/backups/postgresql/16-main/2025-01-02T225006Z.backup with PITR 546s ok 75 - pg_dropcluster 16 main --stop 550s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T225006Z.backup --start --pitr '2025-01-02 22:50:34.232459+00 550s # ' 550s ok 77 - pg_lsclusters -h 550s ok 78 - correct output of pg_lsclusters -h 550s ok 79 - psql -XAtc 'select * from foo order by t' mydb 550s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 551s ok 81 - pg_dropcluster 16 main --stop 551s # Cleanup 551s ok 82 - Cleanup: No clusters left behind 551s ok 83 - No postgres processes left behind 551s ok 84 - No files in /etc/postgresql left behind 551s ok 85 - No files in /var/lib/postgresql left behind 551s ok 86 - No files in /var/run/postgresql left behind 551s ok 87 - No files in /var/log/postgresql left behind 551s ok 88 - PostgreSQL TCP ports are closed 551s ok 89 - Next free port is 5432 551s 1..89 551s ### End test 045_backup.t ### 551s 551s ### PostgreSQL test 050_encodings.t ### 552s 1..60 552s # Checking 16 ru_RU 555s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 556s ok 2 - psql -l succeeds 556s ok 3 - template1 is not UTF-8 encoded 556s ok 4 - creating test database 556s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 556s # create table t (x varchar); copy t from stdin" test 556s ok 6 - creating table with ISO-8859-5 characters 556s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 556s ok 8 - correct string in UTF-8 556s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 556s ok 10 - correct string in ISO-8859-5 556s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 556s # delete from t; copy t from stdin" test 556s ok 12 - creating table with UTF-8 characters 556s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 556s ok 14 - correct string in UTF-8 556s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 556s ok 16 - correct string in ISO-8859-1 556s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 556s ok 18 - Server error message has correct language and encoding 559s ok 19 - pg_ctlcluster 16 ru_RU restart 559s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 560s ok 21 - Dropping cluster 560s # Checking 16 ru_RU.UTF-8 564s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 565s ok 23 - psql -l succeeds 565s ok 24 - template1 is UTF-8 encoded 565s ok 25 - creating test database 565s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 565s # create table t (x varchar); copy t from stdin" test 565s ok 27 - creating table with ISO-8859-5 characters 565s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 565s ok 29 - correct string in UTF-8 565s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 565s ok 31 - correct string in ISO-8859-5 565s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 565s # delete from t; copy t from stdin" test 565s ok 33 - creating table with UTF-8 characters 565s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 565s ok 35 - correct string in UTF-8 565s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 565s ok 37 - correct string in ISO-8859-1 565s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 565s ok 39 - Server error message has correct language and encoding 568s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 568s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 568s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 568s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 568s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 568s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 568s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 568s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 569s ok 48 - Dropping cluster 569s # Check 16 locale environment variables 573s ok 49 - pg_createcluster: LC_ALL dominates LANG 573s ok 50 - psql -Atl --cluster 16/main 573s ok 51 - template1 is ASCII encoded 574s ok 52 - Dropping cluster 574s # Cleanup 574s ok 53 - Cleanup: No clusters left behind 574s ok 54 - No postgres processes left behind 574s ok 55 - No files in /etc/postgresql left behind 574s ok 56 - No files in /var/lib/postgresql left behind 574s ok 57 - No files in /var/run/postgresql left behind 574s ok 58 - No files in /var/log/postgresql left behind 574s ok 59 - PostgreSQL TCP ports are closed 574s ok 60 - Next free port is 5432 574s ### End test 050_encodings.t ### 574s 574s ### PostgreSQL test 052_upgrade_encodings.t ### 574s 1..1 574s ok 1 - only one major version installed, skipping upgrade tests 574s ### End test 052_upgrade_encodings.t ### 574s 574s ### PostgreSQL test 060_obsolete_confparams.t ### 574s ok 1 - only one major version installed, skipping upgrade tests 574s 1..1 574s ### End test 060_obsolete_confparams.t ### 574s 574s ### PostgreSQL test 070_non_postgres_clusters.t ### 574s 1..40 575s ok 1 - pg_createcluster 16 main for owner nobody 575s ok 2 - pg_ctlcluster 16 main start 575s ok 3 - start refused when config and data owners mismatch 578s ok 4 - pg_ctlcluster succeeds with owner nobody 578s ok 5 - pg_lsclusters -h 578s ok 6 - pg_lsclusters shows running cluster 578s ok 7 - postgres is running as user nobody 578s ok 8 - ls /tmp/.s.PGSQL.* 578s ok 9 - socket is in /tmp 578s ok 10 - /var/run/postgresql is empty 578s ok 11 - conf dir is owned by user 578s ok 12 - conf dir is owned by user's primary group 578s ok 13 - files are owned by user 578s ok 14 - files are owned by user's primary group 578s ok 15 - log file has 0640 permissions 578s ok 16 - log file is owned by user 578s ok 17 - log file is owned by user's primary group 578s ok 18 - only one major version installed, skipping upgrade test 578s ok 19 - ... 578s ok 20 - ... 578s ok 21 - ... 578s ok 22 - ... 578s ok 23 - ... 578s ok 24 - ... 578s ok 25 - ... 578s ok 26 - ... 578s ok 27 - ... 578s ok 28 - ... 579s ok 29 - pg_dropcluster 579s ok 30 - pg_lsclusters -h 579s ok 31 - No clusters left 579s ok 32 - No postgres processes left 579s # Cleanup 579s ok 33 - Cleanup: No clusters left behind 579s ok 34 - No postgres processes left behind 579s ok 35 - No files in /etc/postgresql left behind 579s ok 36 - No files in /var/lib/postgresql left behind 579s ok 37 - No files in /var/run/postgresql left behind 579s ok 38 - No files in /var/log/postgresql left behind 579s ok 39 - PostgreSQL TCP ports are closed 579s ok 40 - Next free port is 5432 579s ### End test 070_non_postgres_clusters.t ### 579s 579s ### PostgreSQL test 080_start.conf.t ### 579s 1..73 580s ok 1 - pg_createcluster 16 main 580s # start.conf auto 580s ok 2 - get_cluster_start_conf returns auto 580s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 580s ok 4 - start.conf contains auto 580s ok 5 - systemd generator links cluster 580s ok 6 - systemd generator links correct service file 583s ok 7 - /etc/init.d/postgresql start 16 583s ok 8 - correct output of /etc/init.d/postgresql start 16 583s ok 9 - pg_lsclusters -h 583s ok 10 - cluster is online 583s ok 11 - /etc/init.d/postgresql stop 16 583s ok 12 - correct output of /etc/init.d/postgresql stop 16 586s ok 13 - pg_lsclusters -h 586s ok 14 - cluster is down 586s # start.conf manual 586s ok 15 - get_cluster_start_conf returns manual 586s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 586s ok 17 - start.conf contains manual 586s ok 18 - systemd generator doesn't link cluster 586s ok 19 - /etc/init.d/postgresql start 16 586s ok 20 - correct output of /etc/init.d/postgresql start 16 586s ok 21 - pg_lsclusters -h 586s ok 22 - cluster is down 588s ok 23 - pg_ctlcluster 16 main start 588s ok 24 - correct output of pg_ctlcluster 16 main start 588s ok 25 - pg_lsclusters -h 588s ok 26 - cluster is online 589s ok 27 - pg_ctlcluster 16 main stop 589s ok 28 - correct output of pg_ctlcluster 16 main stop 589s ok 29 - pg_lsclusters -h 589s ok 30 - cluster is down 589s # start.conf disabled 589s ok 31 - get_cluster_start_conf returns disabled 589s ok 32 - systemd generator doesn't link cluster 589s ok 33 - /etc/init.d/postgresql start 16 589s ok 34 - correct output of /etc/init.d/postgresql start 16 589s ok 35 - pg_lsclusters -h 589s ok 36 - cluster is down 589s ok 37 - pg_ctlcluster 16 main start 589s ok 38 - correct output of pg_ctlcluster 16 main start 589s ok 39 - pg_lsclusters -h 589s ok 40 - cluster is down 591s ok 41 - pg_ctlcluster 16 main start 591s ok 42 - correct output of pg_ctlcluster 16 main start 591s ok 43 - pg_lsclusters -h 591s ok 44 - cluster is online 591s ok 45 - pg_ctlcluster 16 main stop 591s ok 46 - correct output of pg_ctlcluster 16 main stop 591s ok 47 - pg_lsclusters -h 591s ok 48 - cluster is down 594s ok 49 - pg_ctlcluster 16 main start 594s ok 50 - correct output of pg_ctlcluster 16 main start 594s ok 51 - pg_lsclusters -h 594s ok 52 - cluster is online 594s # test upgrade 594s ok 53 - only one major version installed, skipping upgrade test 594s ok 54 - ... 594s ok 55 - get_cluster_start_conf for old cluster returns manual 594s ok 56 - get_cluster_start_conf for new cluster returns manual 594s ok 57 - ... 595s ok 58 - dropping upgraded cluster 595s ok 59 - pg_lsclusters -h 595s ok 60 - no clusters any more 595s ok 61 - pg_createcluster 16 main --start-conf foo 595s ok 62 - pg_createcluster checks --start-conf validity 596s ok 63 - pg_createcluster checks --start-conf manual 596s ok 64 - get_cluster_start_conf returns manual 597s ok 65 - dropping cluster 597s # Cleanup 597s ok 66 - Cleanup: No clusters left behind 597s ok 67 - No postgres processes left behind 597s ok 68 - No files in /etc/postgresql left behind 597s ok 69 - No files in /var/lib/postgresql left behind 597s ok 70 - No files in /var/run/postgresql left behind 597s ok 71 - No files in /var/log/postgresql left behind 597s ok 72 - PostgreSQL TCP ports are closed 597s ok 73 - Next free port is 5432 597s ### End test 080_start.conf.t ### 597s 597s ### PostgreSQL test 085_pg_ctl.conf.t ### 597s 1..33 597s ok 1 - prlimit --core=0:unlimited --pid=16606 597s ok 2 - set core file size to unlimited 597s ok 3 - sh -c 'ulimit -Hc' 597s ok 4 - core file size is unlimited 598s ok 5 - pg_createcluster 16 main 598s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 600s ok 7 - pg_ctlcluster 16 main start 600s ok 8 - starting cluster as root 600s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 600s ok 10 - soft core size is 0 600s # hard core file size limit of root-started postgres process is unlimited 600s ok 11 - set pg_ctl default option to -c 603s ok 12 - pg_ctlcluster 16 main restart 603s ok 13 - restarting cluster as root 603s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 603s ok 15 - soft core size is unlimited 603s ok 16 - pg_ctlcluster 16 main stop 603s ok 17 - stopping cluster 603s ok 18 - restored pg_ctl default option 605s ok 19 - pg_ctlcluster 16 main start -- -c 605s ok 20 - starting cluster with -c on the command line as postgres 605s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 605s ok 22 - soft core size is unlimited 605s ok 23 - pg_ctlcluster 16 main stop 605s ok 24 - stopping cluster 607s ok 25 - dropping cluster 607s # Cleanup 607s ok 26 - Cleanup: No clusters left behind 607s ok 27 - No postgres processes left behind 607s ok 28 - No files in /etc/postgresql left behind 607s ok 29 - No files in /var/lib/postgresql left behind 607s ok 30 - No files in /var/run/postgresql left behind 607s ok 31 - No files in /var/log/postgresql left behind 607s ok 32 - PostgreSQL TCP ports are closed 607s ok 33 - Next free port is 5432 607s ### End test 085_pg_ctl.conf.t ### 607s 607s ### PostgreSQL test 090_multicluster.t ### 607s 1..125 608s ok 1 - pg_createcluster 16 old 609s ok 2 - pg_createcluster 16 new1 610s ok 3 - pg_createcluster 16 new2 612s ok 4 - starting cluster 16/old 614s ok 5 - starting cluster 16/new1 617s ok 6 - starting cluster 16/new2 617s ok 7 - pg_lsclusters -h | sort -k3 617s ok 8 - clusters have the correct ports, skipping used 5433 617s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 617s ok 10 - createdb --version 617s ok 11 - pg_wrapper selects port 5432 as default cluster 617s ok 12 - createdb --cluster 16/new1 --version 617s ok 13 - pg_wrapper --cluster works 617s ok 14 - createdb --cluster 16/foo --version 617s ok 15 - pg_wrapper --cluster errors out for invalid cluster 617s ok 16 - createdb --cluster 16/new1 test 617s ok 17 - correct output of createdb --cluster 16/new1 test 617s ok 18 - psql -Atl --cluster 16/new1 617s ok 19 - test db appears in cluster new1 617s ok 20 - psql -Atl --cluster 16/new2 617s ok 21 - test db does not appear in cluster new2 617s ok 22 - psql -Atl 617s ok 23 - test db does not appear in default cluster 617s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 617s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 617s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 617s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 617s ok 28 - psql -Atl --cluster 16/localhost:5434 617s ok 29 - test db appears in cluster 16/localhost:5434 617s ok 30 - psql -Atl --cluster 16/localhost:5440 617s ok 31 - test db does not appear in cluster 16/localhost:5440 617s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 617s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 617s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 617s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 617s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 617s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 617s ok 38 - psql -Atl --cluster 6.4/localhost: 617s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 617s ok 40 - psql -Atl 617s ok 41 - PGCLUSTER selection (1) 618s ok 42 - psql -Atl 618s ok 43 - PGCLUSTER selection (2) 618s ok 44 - psql -l 618s ok 45 - invalid PGCLUSTER value 618s ok 46 - createdb --version 618s ok 47 - PGCLUSTER network cluster selection (1) 618s ok 48 - psql -Atl 618s ok 49 - PGCLUSTER network cluster selection (2) 618s ok 50 - psql -Atl 618s ok 51 - PGCLUSTER network cluster selection (3) 618s ok 52 - LC_MESSAGES=C psql -Atl 618s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 618s ok 54 - psql -Atc "show port" template1 618s ok 55 - PGPORT selection (1) 618s ok 56 - psql -Atc "show port" template1 618s ok 57 - PGPORT selection (2) 618s ok 58 - createdb --version 618s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 618s ok 60 - psql -Atc "show port" template1 618s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 618s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 618s ok 63 - PGDATABASE environment variable works 618s ok 64 - createdb --version 618s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 618s ok 66 - createdb --cluster 16/new1 --version 618s ok 67 - pg_wrapper --cluster works with empty user_clusters 618s ok 68 - createdb --version 618s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 618s ok 70 - psql -Atc "select current_database()" 618s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 618s ok 72 - psql -Atc 'select current_database()' 618s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 618s ok 74 - createdb --version 618s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 618s ok 76 - createdb --version 618s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 618s ok 78 - createdb --version 618s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 618s ok 80 - createdb --version 618s ok 81 - pg_wrapper selects correct version with per-user user_clusters 618s ok 82 - createdb --version 618s ok 83 - pg_wrapper selects correct version with per-user user_clusters 618s ok 84 - createdb --version 618s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 618s ok 86 - psql -Atl 618s ok 87 - $PGHOST overrides user_clusters 619s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 619s ok 89 - --cluster overrides $PGHOST 619s ok 90 - createdb --version 619s ok 91 - pg_wrapper ignores invalid lines in user_clusters 619s ok 92 - psql -Atc 'select current_database()' 619s ok 93 - pg_service conf selection 1 619s ok 94 - psql -Atc 'select current_database()' 619s ok 95 - pg_service conf selection 2 619s ok 96 - psql -Atc 'select current_database()' 619s ok 97 - pg_service conf selection 3 619s ok 98 - stopping cluster 16/old 621s ok 99 - restarting cluster 16/old 621s ok 100 - pg_lsclusters -h | sort -k3 621s ok 101 - port of first cluster was successfully changed 621s ok 102 - psql -l 621s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 621s ok 104 - psql -Atl --cluster 16/new1 621s ok 105 - --cluster selects appropriate cluster 621s ok 106 - psql -Atl -p 5434 621s ok 107 - -p selects appropriate cluster 621s ok 108 - psql -Atlp 5434 621s ok 109 - -Atlp selects appropriate cluster 621s ok 110 - psql -Atl --port 5434 621s ok 111 - --port selects appropriate cluster 621s ok 112 - env PGPORT=5434 psql -Atl 621s ok 113 - $PGPORT selects appropriate cluster 621s ok 114 - Restoring original /etc/postgresql-common/user_clusters 623s ok 115 - dropping 16/new1 625s ok 116 - dropping 16/new2 626s ok 117 - dropping 16/old 626s # Cleanup 626s ok 118 - Cleanup: No clusters left behind 626s ok 119 - No postgres processes left behind 626s ok 120 - No files in /etc/postgresql left behind 626s ok 121 - No files in /var/lib/postgresql left behind 626s ok 122 - No files in /var/run/postgresql left behind 626s ok 123 - No files in /var/log/postgresql left behind 626s ok 124 - PostgreSQL TCP ports are closed 626s ok 125 - Next free port is 5432 626s ### End test 090_multicluster.t ### 626s 626s ### PostgreSQL test 110_integrate_cluster.t ### 626s 1..32 627s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/yZDpEiTstu/c/postgres 627s ok 2 - creating raw initdb cluster for user postgres 628s ok 3 - pg_createcluster 16 postgres -d /tmp/yZDpEiTstu/c/postgres 628s ok 4 - integrating postgres cluster 628s ok 5 - pg_lsclusters 628s ok 6 - correct pg_lsclusters output 630s ok 7 - pg_ctlcluster 16 postgres start 630s ok 8 - starting cluster postgres 630s ok 9 - pg_lsclusters 630s ok 10 - correct pg_lsclusters output 631s ok 11 - dropping cluster postgres 631s ok 12 - No files in temporary cluster dir left behind 632s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/yZDpEiTstu/c/nobody 632s ok 14 - creating raw initdb cluster for user nobody 633s ok 15 - pg_createcluster 16 nobody -d /tmp/yZDpEiTstu/c/nobody 633s ok 16 - integrating nobody cluster 633s ok 17 - pg_lsclusters 633s ok 18 - correct pg_lsclusters output 635s ok 19 - pg_ctlcluster 16 nobody start 635s ok 20 - starting cluster nobody 635s ok 21 - pg_lsclusters 635s ok 22 - correct pg_lsclusters output 637s ok 23 - dropping cluster nobody 637s ok 24 - No files in temporary cluster dir left behind 637s # Cleanup 637s ok 25 - Cleanup: No clusters left behind 637s ok 26 - No postgres processes left behind 637s ok 27 - No files in /etc/postgresql left behind 637s ok 28 - No files in /var/lib/postgresql left behind 637s ok 29 - No files in /var/run/postgresql left behind 637s ok 30 - No files in /var/log/postgresql left behind 637s ok 31 - PostgreSQL TCP ports are closed 637s ok 32 - Next free port is 5432 637s ### End test 110_integrate_cluster.t ### 637s 637s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 637s 1..1 637s ok 1 - only one major version installed, skipping upgrade tests 637s ### End test 120_pg_upgradecluster_scripts.t ### 637s 637s ### PostgreSQL test 130_nonroot_admin.t ### 637s 1..22 640s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 640s ok 2 - pg_lsclusters -h 640s ok 3 - correct output of pg_lsclusters -h 640s ok 4 - psql -Atl 640s ok 5 - correct output of psql -Atl 640s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 640s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 640s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 640s # Cleanup 640s ok 15 - Cleanup: No clusters left behind 640s ok 16 - No postgres processes left behind 640s ok 17 - No files in /etc/postgresql left behind 640s ok 18 - No files in /var/lib/postgresql left behind 640s ok 19 - No files in /var/run/postgresql left behind 640s ok 20 - No files in /var/log/postgresql left behind 640s ok 21 - PostgreSQL TCP ports are closed 640s ok 22 - Next free port is 5432 640s ### End test 130_nonroot_admin.t ### 640s 640s ### PostgreSQL test 135_pg_virtualenv.t ### 640s 1..20 645s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 645s ok 2 - running pg_virtualenv as root 648s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 648s ok 4 - running pg_virtualenv as postgres 651s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 651s ok 6 - running pg_virtualenv as nobody 655s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 655s ok 8 - running fakeroot pg_virtualenv as root 658s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 658s ok 10 - running fakeroot pg_virtualenv as postgres 661s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 661s ok 12 - running fakeroot pg_virtualenv as nobody 661s # Cleanup 661s ok 13 - Cleanup: No clusters left behind 661s ok 14 - No postgres processes left behind 661s ok 15 - No files in /etc/postgresql left behind 661s ok 16 - No files in /var/lib/postgresql left behind 661s ok 17 - No files in /var/run/postgresql left behind 661s ok 18 - No files in /var/log/postgresql left behind 661s ok 19 - PostgreSQL TCP ports are closed 661s ok 20 - Next free port is 5432 661s ### End test 135_pg_virtualenv.t ### 661s 661s ### PostgreSQL test 140_pg_config.t ### 661s 1..38 661s # Multiarch is enabled 661s # checking version specific output for 16 661s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 661s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 661s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 661s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 661s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 661s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 661s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 661s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 661s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 661s # checking pg_config output (should behave like version 16) 661s ok 15 - pg_config 661s ok 16 - correct output of pg_config 661s ok 17 - pg_config --help 661s ok 18 - correct output of pg_config --help 661s ok 19 - pg_config --pgxs 661s ok 20 - correct output of pg_config --pgxs 661s ok 21 - pg_config --libdir 661s ok 22 - correct output of pg_config --libdir 661s ok 23 - pg_config --pkglibdir 661s ok 24 - correct output of pg_config --pkglibdir 661s ok 25 - pg_config --bindir 661s ok 26 - correct output of pg_config --bindir 661s # checking pg_config.libpq-dev output (should behave like version 17) 661s ok 27 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 661s ok 28 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 661s ok 29 - pg_config.libpq-dev --help 661s ok 30 - correct output of pg_config.libpq-dev --help 661s ok 31 - pg_config.libpq-dev --pgxs 661s ok 32 - correct output of pg_config.libpq-dev --pgxs 661s ok 33 - pg_config.libpq-dev --libdir 661s ok 34 - correct output of pg_config.libpq-dev --libdir 661s ok 35 - pg_config.libpq-dev --pkglibdir 661s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 662s ok 37 - pg_config.libpq-dev --bindir 662s ok 38 - correct output of pg_config.libpq-dev --bindir 662s ### End test 140_pg_config.t ### 662s 662s ### PostgreSQL test 150_tsearch_stemming.t ### 662s 1..37 662s ok 1 - pg_updatedicts succeeded 662s ok 2 - pg_updatedicts created en_us.affix 662s ok 3 - pg_updatedicts created en_us.dict 662s ok 4 - pg_updatedicts created 16 en_us.affix symlink 662s ok 5 - pg_updatedicts created 16 en_us.dict symlink 665s ok 6 - pg_createcluster 16 main 665s ok 7 - createdb fts 665s ok 8 - correct output of createdb fts 665s ok 9 - creating en_US full text search configuration 665s ok 10 - creating data table and search index 665s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 665s ok 12 - stem search of correct word 665s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 665s ok 14 - stem search of correct word 666s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 666s ok 16 - stem search of unknown word 666s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 666s ok 18 - full text search, exact word 666s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 666s ok 20 - full text search for word stem 666s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 666s ok 22 - full text search for word substring fails 666s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 666s ok 24 - full text search, exact unicode word 666s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 666s ok 26 - full text search for unicode word stem 666s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 666s ok 28 - full text search for unicode word substring fails 667s ok 29 667s # Cleanup 667s ok 30 - Cleanup: No clusters left behind 667s ok 31 - No postgres processes left behind 667s ok 32 - No files in /etc/postgresql left behind 667s ok 33 - No files in /var/lib/postgresql left behind 667s ok 34 - No files in /var/run/postgresql left behind 667s ok 35 - No files in /var/log/postgresql left behind 667s ok 36 - PostgreSQL TCP ports are closed 667s ok 37 - Next free port is 5432 667s ### End test 150_tsearch_stemming.t ### 667s 667s ### PostgreSQL test 160_alternate_confroot.t ### 667s 1..28 671s ok 1 671s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 671s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 671s ok 4 - pg_lsclusters -h 671s ok 5 - correct output of pg_lsclusters -h 671s ok 6 - psql -Atl 671s ok 7 - correct output of psql -Atl 671s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 671s ok 9 - ... 671s ok 10 - ... 671s ok 11 - ... 671s ok 12 - ... 671s ok 13 - ... 671s ok 14 - ... 671s ok 15 - pg_dropcluster 16 test --stop 671s ok 16 - correct output of pg_dropcluster 16 test --stop 671s ok 17 - pg_lsclusters -h 671s ok 18 - correct output of pg_lsclusters -h 671s ok 19 - No files in root/data left behind 671s ok 20 - No cruft in root dir left behind 671s # Cleanup 671s ok 21 - Cleanup: No clusters left behind 671s ok 22 - No postgres processes left behind 671s ok 23 - No files in /etc/postgresql left behind 671s ok 24 - No files in /var/lib/postgresql left behind 671s ok 25 - No files in /var/run/postgresql left behind 671s ok 26 - No files in /var/log/postgresql left behind 671s ok 27 - PostgreSQL TCP ports are closed 671s ok 28 - Next free port is 5432 671s ### End test 160_alternate_confroot.t ### 671s 671s ### PostgreSQL test 170_extensions.t ### 671s # Running tests for 16 674s ok 1 - pg_createcluster 16 main 674s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 674s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 674s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 674s ok 5 - extension adminpack installs without error 674s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 674s ok 7 - extension adminpack removes without error 674s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 674s ok 9 - extension amcheck installs without error 675s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 675s ok 11 - extension amcheck removes without error 675s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 675s ok 13 - extension autoinc installs without error 675s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 675s ok 15 - extension autoinc removes without error 675s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 675s ok 17 - extension bloom installs without error 675s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 675s ok 19 - extension bloom removes without error 675s ok 20 - psql -qc 'CREATE EXTENSION plperl' 675s ok 21 - bool_plperl dependency plperl installs without error 675s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 675s ok 23 - extension bool_plperl installs without error 675s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 675s ok 25 - extension bool_plperl removes without error 675s ok 26 - psql -qc 'DROP EXTENSION plperl' 675s ok 27 - bool_plperl dependency extension plperl removes without error 675s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 675s ok 29 - bool_plperlu dependency plperlu installs without error 675s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 675s ok 31 - extension bool_plperlu installs without error 675s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 675s ok 33 - extension bool_plperlu removes without error 675s ok 34 - psql -qc 'DROP EXTENSION plperlu' 675s ok 35 - bool_plperlu dependency extension plperlu removes without error 675s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 675s ok 37 - extension btree_gin installs without error 675s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 675s ok 39 - extension btree_gin removes without error 675s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 675s ok 41 - extension btree_gist installs without error 675s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 675s ok 43 - extension btree_gist removes without error 675s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 675s ok 45 - extension citext installs without error 675s ok 46 - psql -qc 'DROP EXTENSION "citext"' 675s ok 47 - extension citext removes without error 676s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 676s ok 49 - extension cube installs without error 676s ok 50 - psql -qc 'DROP EXTENSION "cube"' 676s ok 51 - extension cube removes without error 676s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 676s ok 53 - extension dblink installs without error 676s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 676s ok 55 - extension dblink removes without error 676s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 676s ok 57 - extension dict_int installs without error 676s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 676s ok 59 - extension dict_int removes without error 676s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 676s ok 61 - extension dict_xsyn installs without error 676s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 676s ok 63 - extension dict_xsyn removes without error 676s ok 64 - psql -qc 'CREATE EXTENSION cube' 676s ok 65 - earthdistance dependency cube installs without error 676s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 676s ok 67 - extension earthdistance installs without error 676s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 676s ok 69 - extension earthdistance removes without error 676s ok 70 - psql -qc 'DROP EXTENSION cube' 676s ok 71 - earthdistance dependency extension cube removes without error 676s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 676s ok 73 - extension file_fdw installs without error 676s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 676s ok 75 - extension file_fdw removes without error 676s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 676s ok 77 - extension fuzzystrmatch installs without error 676s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 676s ok 79 - extension fuzzystrmatch removes without error 676s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 676s ok 81 - extension hstore installs without error 676s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 676s ok 83 - extension hstore removes without error 676s ok 84 - psql -qc 'CREATE EXTENSION hstore' 676s ok 85 - hstore_plperl dependency hstore installs without error 677s ok 86 - psql -qc 'CREATE EXTENSION plperl' 677s ok 87 - hstore_plperl dependency plperl installs without error 677s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 677s ok 89 - extension hstore_plperl installs without error 677s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 677s ok 91 - extension hstore_plperl removes without error 677s ok 92 - psql -qc 'DROP EXTENSION hstore' 677s ok 93 - hstore_plperl dependency extension hstore removes without error 677s ok 94 - psql -qc 'DROP EXTENSION plperl' 677s ok 95 - hstore_plperl dependency extension plperl removes without error 677s ok 96 - psql -qc 'CREATE EXTENSION hstore' 677s ok 97 - hstore_plperlu dependency hstore installs without error 677s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 677s ok 99 - hstore_plperlu dependency plperlu installs without error 677s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 677s ok 101 - extension hstore_plperlu installs without error 677s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 677s ok 103 - extension hstore_plperlu removes without error 677s ok 104 - psql -qc 'DROP EXTENSION hstore' 677s ok 105 - hstore_plperlu dependency extension hstore removes without error 677s ok 106 - psql -qc 'DROP EXTENSION plperlu' 677s ok 107 - hstore_plperlu dependency extension plperlu removes without error 677s ok 108 - psql -qc 'CREATE EXTENSION hstore' 677s ok 109 - hstore_plpython3u dependency hstore installs without error 677s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 677s ok 111 - hstore_plpython3u dependency plpython3u installs without error 677s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 677s ok 113 - extension hstore_plpython3u installs without error 677s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 677s ok 115 - extension hstore_plpython3u removes without error 677s ok 116 - psql -qc 'DROP EXTENSION hstore' 677s ok 117 - hstore_plpython3u dependency extension hstore removes without error 677s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 677s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 677s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 677s ok 121 - extension insert_username installs without error 678s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 678s ok 123 - extension insert_username removes without error 678s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 678s ok 125 - extension intagg installs without error 678s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 678s ok 127 - extension intagg removes without error 678s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 678s ok 129 - extension intarray installs without error 678s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 678s ok 131 - extension intarray removes without error 678s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 678s ok 133 - extension isn installs without error 678s ok 134 - psql -qc 'DROP EXTENSION "isn"' 678s ok 135 - extension isn removes without error 678s ok 136 - psql -qc 'CREATE EXTENSION plperl' 678s ok 137 - jsonb_plperl dependency plperl installs without error 678s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 678s ok 139 - extension jsonb_plperl installs without error 678s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 678s ok 141 - extension jsonb_plperl removes without error 678s ok 142 - psql -qc 'DROP EXTENSION plperl' 678s ok 143 - jsonb_plperl dependency extension plperl removes without error 678s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 678s ok 145 - jsonb_plperlu dependency plperlu installs without error 678s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 678s ok 147 - extension jsonb_plperlu installs without error 678s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 678s ok 149 - extension jsonb_plperlu removes without error 678s ok 150 - psql -qc 'DROP EXTENSION plperlu' 678s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 678s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 678s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 678s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 678s ok 155 - extension jsonb_plpython3u installs without error 678s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 678s ok 157 - extension jsonb_plpython3u removes without error 678s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 678s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 678s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 678s ok 161 - extension lo installs without error 679s ok 162 - psql -qc 'DROP EXTENSION "lo"' 679s ok 163 - extension lo removes without error 679s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 679s ok 165 - extension ltree installs without error 679s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 679s ok 167 - extension ltree removes without error 679s ok 168 - psql -qc 'CREATE EXTENSION ltree' 679s ok 169 - ltree_plpython3u dependency ltree installs without error 679s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 679s ok 171 - ltree_plpython3u dependency plpython3u installs without error 679s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 679s ok 173 - extension ltree_plpython3u installs without error 679s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 679s ok 175 - extension ltree_plpython3u removes without error 679s ok 176 - psql -qc 'DROP EXTENSION ltree' 679s ok 177 - ltree_plpython3u dependency extension ltree removes without error 679s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 679s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 679s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 679s ok 181 - extension moddatetime installs without error 679s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 679s ok 183 - extension moddatetime removes without error 679s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 679s ok 185 - extension old_snapshot installs without error 679s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 679s ok 187 - extension old_snapshot removes without error 679s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 679s ok 189 - extension pageinspect installs without error 679s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 679s ok 191 - extension pageinspect removes without error 679s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 679s ok 193 - extension pg_buffercache installs without error 679s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 679s ok 195 - extension pg_buffercache removes without error 679s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 679s ok 197 - extension pg_freespacemap installs without error 679s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 679s ok 199 - extension pg_freespacemap removes without error 679s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 679s ok 201 - extension pg_prewarm installs without error 680s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 680s ok 203 - extension pg_prewarm removes without error 680s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 680s ok 205 - extension pg_stat_statements installs without error 680s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 680s ok 207 - extension pg_stat_statements removes without error 680s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 680s ok 209 - extension pg_surgery installs without error 680s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 680s ok 211 - extension pg_surgery removes without error 680s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 680s ok 213 - extension pg_trgm installs without error 680s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 680s ok 215 - extension pg_trgm removes without error 680s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 680s ok 217 - extension pg_visibility installs without error 680s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 680s ok 219 - extension pg_visibility removes without error 680s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 680s ok 221 - extension pg_walinspect installs without error 680s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 680s ok 223 - extension pg_walinspect removes without error 680s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 680s ok 225 - extension pgcrypto installs without error 680s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 680s ok 227 - extension pgcrypto removes without error 680s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 680s ok 229 - extension pgrowlocks installs without error 680s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 680s ok 231 - extension pgrowlocks removes without error 680s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 680s ok 233 - extension pgstattuple installs without error 680s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 680s ok 235 - extension pgstattuple removes without error 680s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 680s ok 237 - extension plperl installs without error 680s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 680s ok 239 - extension plperl removes without error 680s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 680s ok 241 - extension plperlu installs without error 680s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 680s ok 243 - extension plperlu removes without error 681s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 681s ok 245 - extension plpython3u installs without error 681s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 681s ok 247 - extension plpython3u removes without error 681s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 681s ok 249 - extension pltcl installs without error 681s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 681s ok 251 - extension pltcl removes without error 681s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 681s ok 253 - extension pltclu installs without error 681s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 681s ok 255 - extension pltclu removes without error 681s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 681s ok 257 - extension postgres_fdw installs without error 681s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 681s ok 259 - extension postgres_fdw removes without error 681s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 681s ok 261 - extension refint installs without error 681s ok 262 - psql -qc 'DROP EXTENSION "refint"' 681s ok 263 - extension refint removes without error 681s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 681s ok 265 - extension seg installs without error 681s ok 266 - psql -qc 'DROP EXTENSION "seg"' 681s ok 267 - extension seg removes without error 681s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 681s ok 269 - extension sslinfo installs without error 681s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 681s ok 271 - extension sslinfo removes without error 681s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 681s ok 273 - extension tablefunc installs without error 681s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 681s ok 275 - extension tablefunc removes without error 681s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 681s ok 277 - extension tcn installs without error 681s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 681s ok 279 - extension tcn removes without error 681s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 681s ok 281 - extension tsm_system_rows installs without error 681s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 681s ok 283 - extension tsm_system_rows removes without error 681s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 681s ok 285 - extension tsm_system_time installs without error 681s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 681s ok 287 - extension tsm_system_time removes without error 682s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 682s ok 289 - extension unaccent installs without error 682s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 682s ok 291 - extension unaccent removes without error 682s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 682s ok 293 - extension uuid-ossp installs without error 682s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 682s ok 295 - extension uuid-ossp removes without error 682s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 682s ok 297 - extension xml2 installs without error 682s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 682s ok 299 - extension xml2 removes without error 683s ok 300 - pg_dropcluster 16 main 683s # Cleanup 683s ok 301 - Cleanup: No clusters left behind 683s ok 302 - No postgres processes left behind 683s ok 303 - No files in /etc/postgresql left behind 683s ok 304 - No files in /var/lib/postgresql left behind 683s ok 305 - No files in /var/run/postgresql left behind 683s ok 306 - No files in /var/log/postgresql left behind 683s ok 307 - PostgreSQL TCP ports are closed 683s ok 308 - Next free port is 5432 683s 1..308 683s ### End test 170_extensions.t ### 683s 683s ### PostgreSQL test 180_ecpg.t ### 683s 1..14 683s ok 1 - ecpg test.pgc 683s ok 2 - ecpg processing 684s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 684s ok 4 - compiling ecpg output 691s ok 5 - pg_virtualenv /tmp/tmp.BeG9Pc44lO/test 691s ok 6 - test program runs and gives correct output 691s # Cleanup 691s ok 7 - Cleanup: No clusters left behind 691s ok 8 - No postgres processes left behind 691s ok 9 - No files in /etc/postgresql left behind 691s ok 10 - No files in /var/lib/postgresql left behind 691s ok 11 - No files in /var/run/postgresql left behind 691s ok 12 - No files in /var/log/postgresql left behind 691s ok 13 - PostgreSQL TCP ports are closed 691s ok 14 - Next free port is 5432 691s ### End test 180_ecpg.t ### 691s 691s ### PostgreSQL test 190_pg_buildext.t ### 691s ok 1 - make clean 691s ok 2 - make tar 691s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 691s # testing 'dh --with pgxs' 695s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 695s ok 5 - postgresql-16-foo_123-1_arm64.deb was built 702s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 702s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 703s ok 8 - dpkg -i postgresql-16-foo_123-1_arm64.deb 710s ok 9 - cd foo-123 && pg_buildext installcheck 710s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 717s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 717s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 724s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 724s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 724s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 724s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 725s ok 17 - dpkg -r postgresql-16-foo 725s # testing 'dh --with pgxs_loop' 725s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 728s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 728s ok 20 - postgresql-16-foo_123-1_arm64.deb was built 728s ok 21 - make clean 728s # testing pg_buildext updatecontrol 728s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 728s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 728s 1..23 728s ### End test 190_pg_buildext.t ### 728s 728s ### PostgreSQL test 200_maintscripts.t ### 728s 1..15 728s # We are running systemd 731s ok 1 - pg_createcluster 16 main --start 731s ok 2 - postmaster PID is 23140 733s ok 3 - apt-get update -q 733s # postgresql-common: 733s # Installed: 262 733s # Candidate: 262 733s # Version table: 733s # 267 100 733s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages 733s # *** 262 500 733s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 733s # 100 /var/lib/dpkg/status 736s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 736s # postgresql-common: 736s # Installed: 262 736s # Candidate: 262 736s # Version table: 736s # 267 100 736s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages 736s # *** 262 500 736s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 736s # 100 /var/lib/dpkg/status 736s ok 5 - postmaster PID is 23140 736s ok 6 - postmaster was not restarted 738s ok 7 - pg_dropcluster 16 main --stop 738s # Cleanup 738s ok 8 - Cleanup: No clusters left behind 738s ok 9 - No postgres processes left behind 738s ok 10 - No files in /etc/postgresql left behind 738s ok 11 - No files in /var/lib/postgresql left behind 738s ok 12 - No files in /var/run/postgresql left behind 738s ok 13 - No files in /var/log/postgresql left behind 738s ok 14 - PostgreSQL TCP ports are closed 738s ok 15 - Next free port is 5432 738s ### End test 200_maintscripts.t ### 738s 739s autopkgtest [22:54:05]: test run-testsuite: -----------------------] 739s autopkgtest [22:54:05]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 739s run-testsuite PASS 740s autopkgtest [22:54:06]: @@@@@@@@@@@@@@@@@@@@ summary 740s default-psql PASS 740s run-testsuite PASS 756s nova [W] Using flock in prodstack6-arm64 756s flock: timeout while waiting to get lock 756s Creating nova instance adt-plucky-arm64-postgresql-common-20250102-224146-juju-7f2275-prod-proposed-migration-environment-2-2708429f-34d1-4bfd-a73e-04085b57947e from image adt/ubuntu-plucky-arm64-server-20250102.img (UUID 4cb073f4-4206-4362-b576-2406cb25ddd8)... 756s nova [W] Timed out waiting for e59465b9-fea2-4a6d-94d5-f15fd0585b32 to get deleted. 756s nova [W] Using flock in prodstack6-arm64 756s Creating nova instance adt-plucky-arm64-postgresql-common-20250102-224146-juju-7f2275-prod-proposed-migration-environment-2-2708429f-34d1-4bfd-a73e-04085b57947e from image adt/ubuntu-plucky-arm64-server-20250102.img (UUID 4cb073f4-4206-4362-b576-2406cb25ddd8)... 756s nova [W] Timed out waiting for 79a80614-3357-4424-baf5-23f60b844ee7 to get deleted.