0s autopkgtest [14:35:53]: starting date and time: 2025-01-16 14:35:53+0000 0s autopkgtest [14:35:53]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:35:53]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.etuf80l1/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:ucf --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=ucf/3.0048 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-16.secgroup --name adt-plucky-s390x-postgresql-common-20250116-143552-juju-7f2275-prod-proposed-migration-environment-2-6e136686-7d78-4cf5-a389-f38e47748946 --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-s390x -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/ 123s autopkgtest [14:37:56]: testbed dpkg architecture: s390x 123s autopkgtest [14:37:56]: testbed apt version: 2.9.18 124s autopkgtest [14:37:57]: @@@@@@@@@@@@@@@@@@@@ test bed setup 124s autopkgtest [14:37:57]: testbed release detected to be: None 125s autopkgtest [14:37:58]: updating testbed package index (apt update) 125s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 126s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 126s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 126s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 126s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 126s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.7 kB] 126s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [163 kB] 126s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [912 kB] 126s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [276 kB] 126s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [756 B] 126s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [975 kB] 126s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [4668 B] 127s Fetched 2429 kB in 1s (1698 kB/s) 128s Reading package lists... 129s + lsb_release --codename --short 129s + RELEASE=plucky 129s + cat 129s + [ plucky != trusty ] 129s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 129s Reading package lists... 129s Building dependency tree... 129s Reading state information... 130s Calculating upgrade... 130s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 130s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 130s + /usr/lib/apt/apt-helper analyze-pattern ?true 130s Reading package lists...+ DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove ?obsolete 130s 130s Building dependency tree... 130s Reading state information... 131s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 131s + grep -q trusty /etc/lsb-release 131s + [ ! -d /usr/share/doc/unattended-upgrades ] 131s + [ ! -d /usr/share/doc/lxd ] 131s + [ ! -d /usr/share/doc/lxd-client ] 131s + [ ! -d /usr/share/doc/snapd ] 131s + type iptables 131s + cat 131s + chmod 755 /etc/rc.local 131s + . /etc/rc.local 131s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 131s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 131s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 131s + uname -m 131s + [ s390x = ppc64le ] 131s + [ -d /run/systemd/system ] 131s + systemd-detect-virt --quiet --vm 131s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 131s + cat 131s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 131s + echo COMPRESS=lz4 131s + sync 131s autopkgtest [14:38:04]: upgrading testbed (apt dist-upgrade and autopurge) 132s Reading package lists... 132s Building dependency tree... 132s Reading state information... 132s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 132s Starting 2 pkgProblemResolver with broken count: 0 132s Done 133s Entering ResolveByKeep 133s 134s The following packages will be upgraded: 134s ucf 134s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s Need to get 42.8 kB of archives. 134s After this operation, 0 B of additional disk space will be used. 134s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x ucf all 3.0048 [42.8 kB] 135s Preconfiguring packages ... 135s Fetched 42.8 kB in 0s (140 kB/s) 138s (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 ... 55658 files and directories currently installed.) 138s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 138s Unpacking ucf (3.0048) over (3.0046) ... 138s Setting up ucf (3.0048) ... 138s Processing triggers for man-db (2.13.0-1) ... 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s Starting pkgProblemResolver with broken count: 0 143s Starting 2 pkgProblemResolver with broken count: 0 143s Done 143s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 146s autopkgtest [14:38:19]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 12:49:35 UTC 2024 147s autopkgtest [14:38:20]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 153s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (dsc) [2383 B] 153s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (tar) [219 kB] 154s gpgv: Signature made Thu Nov 21 11:03:28 2024 UTC 154s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 154s gpgv: Can't check signature: No public key 154s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_267.dsc: no acceptable signature found 154s autopkgtest [14:38:27]: testing package postgresql-common version 267 155s autopkgtest [14:38:28]: build not needed 157s autopkgtest [14:38:30]: test default-psql: preparing testbed 157s Reading package lists... 157s Building dependency tree... 157s Reading state information... 158s Starting pkgProblemResolver with broken count: 0 158s Starting 2 pkgProblemResolver with broken count: 0 158s Done 159s The following NEW packages will be installed: 159s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 159s postgresql-17 postgresql-client-17 postgresql-client-common 159s postgresql-common ssl-cert 159s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 159s Need to get 18.9 MB of archives. 159s After this operation, 55.0 MB of additional disk space will be used. 159s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 159s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 159s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 159s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 267 [37.1 kB] 159s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 159s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 267 [162 kB] 160s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x libpq5 s390x 17.2-1 [146 kB] 160s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 160s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-17 s390x 17.2-1 [1342 kB] 160s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-17 s390x 17.2-1 [16.9 MB] 163s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql all 17+267 [12.2 kB] 164s Preconfiguring packages ... 164s Fetched 18.9 MB in 4s (4327 kB/s) 164s Selecting previously unselected package libjson-perl. 164s (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 ... 55658 files and directories currently installed.) 164s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 164s Unpacking libjson-perl (4.10000-1) ... 164s Selecting previously unselected package libio-pty-perl. 164s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 164s Unpacking libio-pty-perl (1:1.20-1build3) ... 164s Selecting previously unselected package libipc-run-perl. 164s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 164s Unpacking libipc-run-perl (20231003.0-2) ... 164s Selecting previously unselected package postgresql-client-common. 164s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 164s Unpacking postgresql-client-common (267) ... 164s Selecting previously unselected package ssl-cert. 164s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 164s Unpacking ssl-cert (1.1.3ubuntu1) ... 164s Selecting previously unselected package postgresql-common. 164s Preparing to unpack .../05-postgresql-common_267_all.deb ... 164s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 164s Unpacking postgresql-common (267) ... 164s Selecting previously unselected package libpq5:s390x. 164s Preparing to unpack .../06-libpq5_17.2-1_s390x.deb ... 164s Unpacking libpq5:s390x (17.2-1) ... 164s Selecting previously unselected package libxslt1.1:s390x. 164s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 164s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 164s Selecting previously unselected package postgresql-client-17. 164s Preparing to unpack .../08-postgresql-client-17_17.2-1_s390x.deb ... 164s Unpacking postgresql-client-17 (17.2-1) ... 164s Selecting previously unselected package postgresql-17. 164s Preparing to unpack .../09-postgresql-17_17.2-1_s390x.deb ... 164s Unpacking postgresql-17 (17.2-1) ... 165s Selecting previously unselected package postgresql. 165s Preparing to unpack .../10-postgresql_17+267_all.deb ... 165s Unpacking postgresql (17+267) ... 165s Setting up libio-pty-perl (1:1.20-1build3) ... 165s Setting up libpq5:s390x (17.2-1) ... 165s Setting up ssl-cert (1.1.3ubuntu1) ... 167s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 167s Setting up libipc-run-perl (20231003.0-2) ... 167s Setting up libjson-perl (4.10000-1) ... 167s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 167s Setting up postgresql-client-common (267) ... 167s Setting up postgresql-client-17 (17.2-1) ... 168s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 168s Setting up postgresql-common (267) ... 168s Creating config file /etc/postgresql-common/createcluster.conf with new version 169s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 169s Removing obsolete dictionary files: 169s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 170s Setting up postgresql-17 (17.2-1) ... 170s Creating new PostgreSQL cluster 17/main ... 170s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 170s The files belonging to this database system will be owned by user "postgres". 170s This user must also own the server process. 170s 170s The database cluster will be initialized with locale "C.UTF-8". 170s The default database encoding has accordingly been set to "UTF8". 170s The default text search configuration will be set to "english". 170s 170s Data page checksums are disabled. 170s 170s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 170s creating subdirectories ... ok 170s selecting dynamic shared memory implementation ... posix 170s selecting default "max_connections" ... 100 170s selecting default "shared_buffers" ... 128MB 170s selecting default time zone ... Etc/UTC 170s creating configuration files ... ok 171s running bootstrap script ... ok 171s performing post-bootstrap initialization ... ok 171s syncing data to disk ... ok 176s Setting up postgresql (17+267) ... 176s Processing triggers for man-db (2.13.0-1) ... 186s Processing triggers for libc-bin (2.40-4ubuntu1) ... 188s autopkgtest [14:39:01]: test default-psql: [----------------------- 188s autopkgtest [14:39:01]: test default-psql: -----------------------] 189s autopkgtest [14:39:02]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 189s default-psql PASS 189s autopkgtest [14:39:02]: test run-testsuite: preparing testbed 306s autopkgtest [14:40:59]: testbed dpkg architecture: s390x 306s autopkgtest [14:40:59]: testbed apt version: 2.9.18 306s autopkgtest [14:40:59]: @@@@@@@@@@@@@@@@@@@@ test bed setup 306s autopkgtest [14:40:59]: testbed release detected to be: plucky 307s autopkgtest [14:41:00]: updating testbed package index (apt update) 308s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 308s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 308s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 308s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 308s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.7 kB] 308s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 308s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [163 kB] 308s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [912 kB] 309s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [276 kB] 309s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x Packages [756 B] 309s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [975 kB] 309s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [4668 B] 310s Fetched 2429 kB in 2s (1177 kB/s) 311s Reading package lists... 312s + lsb_release --codename --short 312s + RELEASE=plucky 312s + cat 312s + [ plucky != trusty ] 312s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 312s Reading package lists... 312s Building dependency tree... 312s Reading state information... 312s Calculating upgrade... 312s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 312s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 312s + /usr/lib/apt/apt-helper analyze-pattern ?true 312s Reading package lists...+ DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove ?obsolete 312s 313s Building dependency tree... 313s Reading state information... 313s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 313s + grep -q trusty /etc/lsb-release 313s + [ ! -d /usr/share/doc/unattended-upgrades ] 313s + [ ! -d /usr/share/doc/lxd ] 313s + [ ! -d /usr/share/doc/lxd-client ] 313s + [ ! -d /usr/share/doc/snapd ] 313s + type iptables 313s + cat 313s + chmod 755 /etc/rc.local 313s + . /etc/rc.local 313s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 313s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 313s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 313s + uname -m 313s + [ s390x = ppc64le ] 313s + [ -d /run/systemd/system ] 313s + systemd-detect-virt --quiet --vm 313s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 313s + cat 313s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 313s + echo COMPRESS=lz4 313s + sync 313s autopkgtest [14:41:06]: upgrading testbed (apt dist-upgrade and autopurge) 313s Reading package lists... 314s Building dependency tree... 314s Reading state information... 314s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 314s Starting 2 pkgProblemResolver with broken count: 0 314s Done 315s Entering ResolveByKeep 315s 315s The following packages will be upgraded: 315s ucf 315s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 315s Need to get 42.8 kB of archives. 315s After this operation, 0 B of additional disk space will be used. 315s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x ucf all 3.0048 [42.8 kB] 316s Preconfiguring packages ... 316s Fetched 42.8 kB in 0s (127 kB/s) 319s (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 ... 55658 files and directories currently installed.) 319s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 319s Unpacking ucf (3.0048) over (3.0046) ... 319s Setting up ucf (3.0048) ... 319s Processing triggers for man-db (2.13.0-1) ... 325s Reading package lists... 325s Building dependency tree... 325s Reading state information... 325s Starting pkgProblemResolver with broken count: 0 325s Starting 2 pkgProblemResolver with broken count: 0 325s Done 326s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 329s Reading package lists... 329s Building dependency tree... 329s Reading state information... 330s Starting pkgProblemResolver with broken count: 0 330s Starting 2 pkgProblemResolver with broken count: 0 330s Done 331s The following NEW packages will be installed: 331s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 331s cpp-14 cpp-14-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 331s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 331s fakeroot g++ g++-14 g++-14-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-14 331s gcc-14-s390x-linux-gnu gcc-s390x-linux-gnu gettext hunspell-en-us 331s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-19-dev 331s libclang-cpp19 libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 331s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev 331s libgomp1 libio-pty-perl libipc-run-perl libisl23 libitm1 libjson-perl 331s libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 331s libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool libubsan1 libxml2-dev 331s libxslt1.1 llvm-19 llvm-19-dev llvm-19-linker-tools llvm-19-runtime 331s llvm-19-tools locales-all m4 po-debconf postgresql-17 postgresql-all 331s postgresql-client-17 postgresql-client-common postgresql-common 331s postgresql-doc postgresql-doc-17 postgresql-plperl-17 331s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 331s postgresql-server-dev-all ssl-cert 331s 0 upgraded, 85 newly installed, 0 to remove and 0 not upgraded. 331s Need to get 185 MB of archives. 331s After this operation, 1107 MB of additional disk space will be used. 331s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 331s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 331s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 331s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 267 [37.1 kB] 331s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 331s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 267 [162 kB] 331s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x m4 s390x 1.4.19-4build1 [256 kB] 331s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x autoconf all 2.72-3 [382 kB] 332s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x autotools-dev all 20220109.1 [44.9 kB] 332s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x automake all 1:1.16.5-1.3ubuntu1 [558 kB] 332s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x autopoint all 0.22.5-3 [616 kB] 332s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x libisl23 s390x 0.27-1 [704 kB] 333s Get:13 http://ftpmaster.internal/ubuntu plucky/main s390x libmpc3 s390x 1.3.1-1build2 [57.8 kB] 333s Get:14 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [9571 kB] 339s Get:15 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-14 s390x 14.2.0-12ubuntu1 [1030 B] 339s Get:16 http://ftpmaster.internal/ubuntu plucky/main s390x cpp-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [5452 B] 339s Get:17 http://ftpmaster.internal/ubuntu plucky/main s390x cpp s390x 4:14.1.0-2ubuntu1 [22.4 kB] 339s Get:18 http://ftpmaster.internal/ubuntu plucky/main s390x libcc1-0 s390x 14.2.0-12ubuntu1 [50.6 kB] 339s Get:19 http://ftpmaster.internal/ubuntu plucky/main s390x libgomp1 s390x 14.2.0-12ubuntu1 [151 kB] 339s Get:20 http://ftpmaster.internal/ubuntu plucky/main s390x libitm1 s390x 14.2.0-12ubuntu1 [30.9 kB] 339s Get:21 http://ftpmaster.internal/ubuntu plucky/main s390x libasan8 s390x 14.2.0-12ubuntu1 [2964 kB] 341s Get:22 http://ftpmaster.internal/ubuntu plucky/main s390x libubsan1 s390x 14.2.0-12ubuntu1 [1184 kB] 342s Get:23 http://ftpmaster.internal/ubuntu plucky/main s390x libgcc-14-dev s390x 14.2.0-12ubuntu1 [1036 kB] 342s Get:24 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [18.7 MB] 348s Get:25 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-14 s390x 14.2.0-12ubuntu1 [522 kB] 348s Get:26 http://ftpmaster.internal/ubuntu plucky/main s390x gcc-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [1204 B] 348s Get:27 http://ftpmaster.internal/ubuntu plucky/main s390x gcc s390x 4:14.1.0-2ubuntu1 [4996 B] 348s Get:28 http://ftpmaster.internal/ubuntu plucky/main s390x libstdc++-14-dev s390x 14.2.0-12ubuntu1 [2610 kB] 348s Get:29 http://ftpmaster.internal/ubuntu plucky/main s390x g++-14-s390x-linux-gnu s390x 14.2.0-12ubuntu1 [11.0 MB] 350s Get:30 http://ftpmaster.internal/ubuntu plucky/main s390x g++-14 s390x 14.2.0-12ubuntu1 [20.2 kB] 350s Get:31 http://ftpmaster.internal/ubuntu plucky/main s390x g++-s390x-linux-gnu s390x 4:14.1.0-2ubuntu1 [956 B] 350s Get:32 http://ftpmaster.internal/ubuntu plucky/main s390x g++ s390x 4:14.1.0-2ubuntu1 [1076 B] 350s Get:33 http://ftpmaster.internal/ubuntu plucky/main s390x build-essential s390x 12.10ubuntu1 [4930 B] 350s Get:34 http://ftpmaster.internal/ubuntu plucky/universe s390x libclang-cpp19 s390x 1:19.1.6-1ubuntu1 [16.7 MB] 352s Get:35 http://ftpmaster.internal/ubuntu plucky/main s390x libgc1 s390x 1:8.2.8-1 [93.7 kB] 352s Get:36 http://ftpmaster.internal/ubuntu plucky/universe s390x libobjc4 s390x 14.2.0-12ubuntu1 [49.9 kB] 352s Get:37 http://ftpmaster.internal/ubuntu plucky/universe s390x libobjc-14-dev s390x 14.2.0-12ubuntu1 [194 kB] 352s Get:38 http://ftpmaster.internal/ubuntu plucky/universe s390x libclang-common-19-dev s390x 1:19.1.6-1ubuntu1 [742 kB] 352s Get:39 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-linker-tools s390x 1:19.1.6-1ubuntu1 [1546 kB] 352s Get:40 http://ftpmaster.internal/ubuntu plucky/universe s390x clang-19 s390x 1:19.1.6-1ubuntu1 [79.4 kB] 352s Get:41 http://ftpmaster.internal/ubuntu plucky/main s390x libdebhelper-perl all 13.20ubuntu1 [94.2 kB] 352s Get:42 http://ftpmaster.internal/ubuntu plucky/main s390x libtool all 2.4.7-8 [166 kB] 352s Get:43 http://ftpmaster.internal/ubuntu plucky/main s390x dh-autoreconf all 20 [16.1 kB] 352s Get:44 http://ftpmaster.internal/ubuntu plucky/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 352s Get:45 http://ftpmaster.internal/ubuntu plucky/main s390x libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 352s Get:46 http://ftpmaster.internal/ubuntu plucky/main s390x dh-strip-nondeterminism all 1.14.0-1 [5058 B] 352s Get:47 http://ftpmaster.internal/ubuntu plucky/main s390x debugedit s390x 1:5.1-1 [49.9 kB] 352s Get:48 http://ftpmaster.internal/ubuntu plucky/main s390x dwz s390x 0.15-1build6 [122 kB] 352s Get:49 http://ftpmaster.internal/ubuntu plucky/main s390x gettext s390x 0.22.5-3 [997 kB] 352s Get:50 http://ftpmaster.internal/ubuntu plucky/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 352s Get:51 http://ftpmaster.internal/ubuntu plucky/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 352s Get:52 http://ftpmaster.internal/ubuntu plucky/main s390x debhelper all 13.20ubuntu1 [893 kB] 352s Get:53 http://ftpmaster.internal/ubuntu plucky/main s390x emacsen-common all 3.0.5 [12.1 kB] 352s Get:54 http://ftpmaster.internal/ubuntu plucky/main s390x dictionaries-common all 1.30.2 [176 kB] 352s Get:55 http://ftpmaster.internal/ubuntu plucky/main s390x libfakeroot s390x 1.36.2-1 [32.4 kB] 352s Get:56 http://ftpmaster.internal/ubuntu plucky/main s390x fakeroot s390x 1.36.2-1 [67.7 kB] 352s Get:57 http://ftpmaster.internal/ubuntu plucky/main s390x hunspell-en-us all 1:2020.12.07-3 [586 kB] 352s Get:58 http://ftpmaster.internal/ubuntu plucky/main s390x libpgtypes3 s390x 17.2-1 [48.6 kB] 352s Get:59 http://ftpmaster.internal/ubuntu plucky/main s390x libpq5 s390x 17.2-1 [146 kB] 352s Get:60 http://ftpmaster.internal/ubuntu plucky/main s390x libecpg6 s390x 17.2-1 [48.0 kB] 352s Get:61 http://ftpmaster.internal/ubuntu plucky/main s390x libecpg-compat3 s390x 17.2-1 [13.1 kB] 352s Get:62 http://ftpmaster.internal/ubuntu plucky/main s390x libssl-dev s390x 3.4.0-1ubuntu2 [2427 kB] 353s Get:63 http://ftpmaster.internal/ubuntu plucky/main s390x libpq-dev s390x 17.2-1 [159 kB] 353s Get:64 http://ftpmaster.internal/ubuntu plucky/main s390x libecpg-dev s390x 17.2-1 [282 kB] 353s Get:65 http://ftpmaster.internal/ubuntu plucky/main s390x libncurses-dev s390x 6.5-2 [404 kB] 353s Get:66 http://ftpmaster.internal/ubuntu plucky/main s390x libtcl8.6 s390x 8.6.15+dfsg-2 [1034 kB] 353s Get:67 http://ftpmaster.internal/ubuntu plucky/main s390x libxml2-dev s390x 2.12.7+dfsg+really2.9.14-0.2ubuntu2 [823 kB] 353s Get:68 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 353s Get:69 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-runtime s390x 1:19.1.6-1ubuntu1 [622 kB] 353s Get:70 http://ftpmaster.internal/ubuntu plucky/universe s390x libpfm4 s390x 4.13.0+git83-g91970fe-1 [37.3 kB] 353s Get:71 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19 s390x 1:19.1.6-1ubuntu1 [21.1 MB] 355s Get:72 http://ftpmaster.internal/ubuntu plucky/main s390x libffi-dev s390x 3.4.6-1build1 [58.8 kB] 355s Get:73 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-tools s390x 1:19.1.6-1ubuntu1 [584 kB] 355s Get:74 http://ftpmaster.internal/ubuntu plucky/universe s390x llvm-19-dev s390x 1:19.1.6-1ubuntu1 [50.2 MB] 360s Get:75 http://ftpmaster.internal/ubuntu plucky/universe s390x locales-all s390x 2.40-4ubuntu1 [11.5 MB] 361s Get:76 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-17 s390x 17.2-1 [1342 kB] 361s Get:77 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-17 s390x 17.2-1 [16.9 MB] 363s Get:78 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-server-dev-17 s390x 17.2-1 [1397 kB] 363s Get:79 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-server-dev-all s390x 267 [21.3 kB] 363s Get:80 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-plperl-17 s390x 17.2-1 [67.7 kB] 363s Get:81 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-plpython3-17 s390x 17.2-1 [75.6 kB] 363s Get:82 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-pltcl-17 s390x 17.2-1 [30.5 kB] 363s Get:83 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-all all 267 [1710 B] 363s Get:84 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-doc-17 all 17.2-1 [2122 kB] 363s Get:85 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-doc all 17+267 [12.2 kB] 364s Preconfiguring packages ... 364s Fetched 185 MB in 33s (5701 kB/s) 364s Selecting previously unselected package libjson-perl. 364s (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 ... 55658 files and directories currently installed.) 364s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 364s Unpacking libjson-perl (4.10000-1) ... 364s Selecting previously unselected package libio-pty-perl. 364s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 364s Unpacking libio-pty-perl (1:1.20-1build3) ... 364s Selecting previously unselected package libipc-run-perl. 364s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 364s Unpacking libipc-run-perl (20231003.0-2) ... 364s Selecting previously unselected package postgresql-client-common. 364s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 364s Unpacking postgresql-client-common (267) ... 364s Selecting previously unselected package ssl-cert. 364s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 364s Unpacking ssl-cert (1.1.3ubuntu1) ... 365s Selecting previously unselected package postgresql-common. 365s Preparing to unpack .../05-postgresql-common_267_all.deb ... 365s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 365s Unpacking postgresql-common (267) ... 365s Selecting previously unselected package m4. 365s Preparing to unpack .../06-m4_1.4.19-4build1_s390x.deb ... 365s Unpacking m4 (1.4.19-4build1) ... 365s Selecting previously unselected package autoconf. 365s Preparing to unpack .../07-autoconf_2.72-3_all.deb ... 365s Unpacking autoconf (2.72-3) ... 365s Selecting previously unselected package autotools-dev. 365s Preparing to unpack .../08-autotools-dev_20220109.1_all.deb ... 365s Unpacking autotools-dev (20220109.1) ... 365s Selecting previously unselected package automake. 365s Preparing to unpack .../09-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 365s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 365s Selecting previously unselected package autopoint. 365s Preparing to unpack .../10-autopoint_0.22.5-3_all.deb ... 365s Unpacking autopoint (0.22.5-3) ... 366s Selecting previously unselected package libisl23:s390x. 366s Preparing to unpack .../11-libisl23_0.27-1_s390x.deb ... 366s Unpacking libisl23:s390x (0.27-1) ... 366s Selecting previously unselected package libmpc3:s390x. 366s Preparing to unpack .../12-libmpc3_1.3.1-1build2_s390x.deb ... 366s Unpacking libmpc3:s390x (1.3.1-1build2) ... 366s Selecting previously unselected package cpp-14-s390x-linux-gnu. 366s Preparing to unpack .../13-cpp-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking cpp-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 366s Selecting previously unselected package cpp-14. 366s Preparing to unpack .../14-cpp-14_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 366s Selecting previously unselected package cpp-s390x-linux-gnu. 366s Preparing to unpack .../15-cpp-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 366s Unpacking cpp-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 366s Selecting previously unselected package cpp. 366s Preparing to unpack .../16-cpp_4%3a14.1.0-2ubuntu1_s390x.deb ... 366s Unpacking cpp (4:14.1.0-2ubuntu1) ... 366s Selecting previously unselected package libcc1-0:s390x. 366s Preparing to unpack .../17-libcc1-0_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking libcc1-0:s390x (14.2.0-12ubuntu1) ... 366s Selecting previously unselected package libgomp1:s390x. 366s Preparing to unpack .../18-libgomp1_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking libgomp1:s390x (14.2.0-12ubuntu1) ... 366s Selecting previously unselected package libitm1:s390x. 366s Preparing to unpack .../19-libitm1_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking libitm1:s390x (14.2.0-12ubuntu1) ... 366s Selecting previously unselected package libasan8:s390x. 366s Preparing to unpack .../20-libasan8_14.2.0-12ubuntu1_s390x.deb ... 366s Unpacking libasan8:s390x (14.2.0-12ubuntu1) ... 367s Selecting previously unselected package libubsan1:s390x. 367s Preparing to unpack .../21-libubsan1_14.2.0-12ubuntu1_s390x.deb ... 367s Unpacking libubsan1:s390x (14.2.0-12ubuntu1) ... 367s Selecting previously unselected package libgcc-14-dev:s390x. 367s Preparing to unpack .../22-libgcc-14-dev_14.2.0-12ubuntu1_s390x.deb ... 367s Unpacking libgcc-14-dev:s390x (14.2.0-12ubuntu1) ... 367s Selecting previously unselected package gcc-14-s390x-linux-gnu. 367s Preparing to unpack .../23-gcc-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 367s Unpacking gcc-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 368s Selecting previously unselected package gcc-14. 368s Preparing to unpack .../24-gcc-14_14.2.0-12ubuntu1_s390x.deb ... 368s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 368s Selecting previously unselected package gcc-s390x-linux-gnu. 368s Preparing to unpack .../25-gcc-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 368s Unpacking gcc-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 368s Selecting previously unselected package gcc. 368s Preparing to unpack .../26-gcc_4%3a14.1.0-2ubuntu1_s390x.deb ... 368s Unpacking gcc (4:14.1.0-2ubuntu1) ... 368s Selecting previously unselected package libstdc++-14-dev:s390x. 368s Preparing to unpack .../27-libstdc++-14-dev_14.2.0-12ubuntu1_s390x.deb ... 368s Unpacking libstdc++-14-dev:s390x (14.2.0-12ubuntu1) ... 368s Selecting previously unselected package g++-14-s390x-linux-gnu. 368s Preparing to unpack .../28-g++-14-s390x-linux-gnu_14.2.0-12ubuntu1_s390x.deb ... 368s Unpacking g++-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 369s Selecting previously unselected package g++-14. 369s Preparing to unpack .../29-g++-14_14.2.0-12ubuntu1_s390x.deb ... 369s Unpacking g++-14 (14.2.0-12ubuntu1) ... 369s Selecting previously unselected package g++-s390x-linux-gnu. 369s Preparing to unpack .../30-g++-s390x-linux-gnu_4%3a14.1.0-2ubuntu1_s390x.deb ... 369s Unpacking g++-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 369s Selecting previously unselected package g++. 369s Preparing to unpack .../31-g++_4%3a14.1.0-2ubuntu1_s390x.deb ... 369s Unpacking g++ (4:14.1.0-2ubuntu1) ... 369s Selecting previously unselected package build-essential. 369s Preparing to unpack .../32-build-essential_12.10ubuntu1_s390x.deb ... 369s Unpacking build-essential (12.10ubuntu1) ... 369s Selecting previously unselected package libclang-cpp19. 369s Preparing to unpack .../33-libclang-cpp19_1%3a19.1.6-1ubuntu1_s390x.deb ... 369s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 370s Selecting previously unselected package libgc1:s390x. 370s Preparing to unpack .../34-libgc1_1%3a8.2.8-1_s390x.deb ... 370s Unpacking libgc1:s390x (1:8.2.8-1) ... 370s Selecting previously unselected package libobjc4:s390x. 370s Preparing to unpack .../35-libobjc4_14.2.0-12ubuntu1_s390x.deb ... 370s Unpacking libobjc4:s390x (14.2.0-12ubuntu1) ... 370s Selecting previously unselected package libobjc-14-dev:s390x. 370s Preparing to unpack .../36-libobjc-14-dev_14.2.0-12ubuntu1_s390x.deb ... 370s Unpacking libobjc-14-dev:s390x (14.2.0-12ubuntu1) ... 370s Selecting previously unselected package libclang-common-19-dev:s390x. 370s Preparing to unpack .../37-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_s390x.deb ... 370s Unpacking libclang-common-19-dev:s390x (1:19.1.6-1ubuntu1) ... 371s Selecting previously unselected package llvm-19-linker-tools. 371s Preparing to unpack .../38-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_s390x.deb ... 371s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 371s Selecting previously unselected package clang-19. 371s Preparing to unpack .../39-clang-19_1%3a19.1.6-1ubuntu1_s390x.deb ... 371s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 371s Selecting previously unselected package libdebhelper-perl. 371s Preparing to unpack .../40-libdebhelper-perl_13.20ubuntu1_all.deb ... 371s Unpacking libdebhelper-perl (13.20ubuntu1) ... 371s Selecting previously unselected package libtool. 371s Preparing to unpack .../41-libtool_2.4.7-8_all.deb ... 371s Unpacking libtool (2.4.7-8) ... 371s Selecting previously unselected package dh-autoreconf. 371s Preparing to unpack .../42-dh-autoreconf_20_all.deb ... 371s Unpacking dh-autoreconf (20) ... 371s Selecting previously unselected package libarchive-zip-perl. 371s Preparing to unpack .../43-libarchive-zip-perl_1.68-1_all.deb ... 371s Unpacking libarchive-zip-perl (1.68-1) ... 371s Selecting previously unselected package libfile-stripnondeterminism-perl. 371s Preparing to unpack .../44-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 371s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 371s Selecting previously unselected package dh-strip-nondeterminism. 371s Preparing to unpack .../45-dh-strip-nondeterminism_1.14.0-1_all.deb ... 371s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 371s Selecting previously unselected package debugedit. 371s Preparing to unpack .../46-debugedit_1%3a5.1-1_s390x.deb ... 371s Unpacking debugedit (1:5.1-1) ... 371s Selecting previously unselected package dwz. 371s Preparing to unpack .../47-dwz_0.15-1build6_s390x.deb ... 371s Unpacking dwz (0.15-1build6) ... 371s Selecting previously unselected package gettext. 371s Preparing to unpack .../48-gettext_0.22.5-3_s390x.deb ... 371s Unpacking gettext (0.22.5-3) ... 371s Selecting previously unselected package intltool-debian. 371s Preparing to unpack .../49-intltool-debian_0.35.0+20060710.6_all.deb ... 371s Unpacking intltool-debian (0.35.0+20060710.6) ... 371s Selecting previously unselected package po-debconf. 371s Preparing to unpack .../50-po-debconf_1.0.21+nmu1_all.deb ... 371s Unpacking po-debconf (1.0.21+nmu1) ... 371s Selecting previously unselected package debhelper. 371s Preparing to unpack .../51-debhelper_13.20ubuntu1_all.deb ... 372s Unpacking debhelper (13.20ubuntu1) ... 372s Selecting previously unselected package emacsen-common. 372s Preparing to unpack .../52-emacsen-common_3.0.5_all.deb ... 372s Unpacking emacsen-common (3.0.5) ... 372s Selecting previously unselected package dictionaries-common. 372s Preparing to unpack .../53-dictionaries-common_1.30.2_all.deb ... 372s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 372s Unpacking dictionaries-common (1.30.2) ... 372s Selecting previously unselected package libfakeroot:s390x. 372s Preparing to unpack .../54-libfakeroot_1.36.2-1_s390x.deb ... 372s Unpacking libfakeroot:s390x (1.36.2-1) ... 372s Selecting previously unselected package fakeroot. 372s Preparing to unpack .../55-fakeroot_1.36.2-1_s390x.deb ... 372s Unpacking fakeroot (1.36.2-1) ... 372s Selecting previously unselected package hunspell-en-us. 372s Preparing to unpack .../56-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 372s Unpacking hunspell-en-us (1:2020.12.07-3) ... 372s Selecting previously unselected package libpgtypes3:s390x. 372s Preparing to unpack .../57-libpgtypes3_17.2-1_s390x.deb ... 372s Unpacking libpgtypes3:s390x (17.2-1) ... 372s Selecting previously unselected package libpq5:s390x. 372s Preparing to unpack .../58-libpq5_17.2-1_s390x.deb ... 372s Unpacking libpq5:s390x (17.2-1) ... 372s Selecting previously unselected package libecpg6:s390x. 372s Preparing to unpack .../59-libecpg6_17.2-1_s390x.deb ... 372s Unpacking libecpg6:s390x (17.2-1) ... 372s Selecting previously unselected package libecpg-compat3:s390x. 372s Preparing to unpack .../60-libecpg-compat3_17.2-1_s390x.deb ... 372s Unpacking libecpg-compat3:s390x (17.2-1) ... 372s Selecting previously unselected package libssl-dev:s390x. 372s Preparing to unpack .../61-libssl-dev_3.4.0-1ubuntu2_s390x.deb ... 372s Unpacking libssl-dev:s390x (3.4.0-1ubuntu2) ... 372s Selecting previously unselected package libpq-dev. 373s Preparing to unpack .../62-libpq-dev_17.2-1_s390x.deb ... 373s Unpacking libpq-dev (17.2-1) ... 373s Selecting previously unselected package libecpg-dev. 373s Preparing to unpack .../63-libecpg-dev_17.2-1_s390x.deb ... 373s Unpacking libecpg-dev (17.2-1) ... 373s Selecting previously unselected package libncurses-dev:s390x. 373s Preparing to unpack .../64-libncurses-dev_6.5-2_s390x.deb ... 373s Unpacking libncurses-dev:s390x (6.5-2) ... 373s Selecting previously unselected package libtcl8.6:s390x. 373s Preparing to unpack .../65-libtcl8.6_8.6.15+dfsg-2_s390x.deb ... 373s Unpacking libtcl8.6:s390x (8.6.15+dfsg-2) ... 373s Selecting previously unselected package libxml2-dev:s390x. 373s Preparing to unpack .../66-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu2_s390x.deb ... 373s Unpacking libxml2-dev:s390x (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 373s Selecting previously unselected package libxslt1.1:s390x. 373s Preparing to unpack .../67-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 373s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 373s Selecting previously unselected package llvm-19-runtime. 373s Preparing to unpack .../68-llvm-19-runtime_1%3a19.1.6-1ubuntu1_s390x.deb ... 373s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 373s Selecting previously unselected package libpfm4:s390x. 373s Preparing to unpack .../69-libpfm4_4.13.0+git83-g91970fe-1_s390x.deb ... 373s Unpacking libpfm4:s390x (4.13.0+git83-g91970fe-1) ... 373s Selecting previously unselected package llvm-19. 373s Preparing to unpack .../70-llvm-19_1%3a19.1.6-1ubuntu1_s390x.deb ... 373s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 374s Selecting previously unselected package libffi-dev:s390x. 374s Preparing to unpack .../71-libffi-dev_3.4.6-1build1_s390x.deb ... 374s Unpacking libffi-dev:s390x (3.4.6-1build1) ... 374s Selecting previously unselected package llvm-19-tools. 374s Preparing to unpack .../72-llvm-19-tools_1%3a19.1.6-1ubuntu1_s390x.deb ... 374s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 374s Selecting previously unselected package llvm-19-dev. 374s Preparing to unpack .../73-llvm-19-dev_1%3a19.1.6-1ubuntu1_s390x.deb ... 374s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 377s Selecting previously unselected package locales-all. 377s Preparing to unpack .../74-locales-all_2.40-4ubuntu1_s390x.deb ... 377s Unpacking locales-all (2.40-4ubuntu1) ... 380s Selecting previously unselected package postgresql-client-17. 380s Preparing to unpack .../75-postgresql-client-17_17.2-1_s390x.deb ... 380s Unpacking postgresql-client-17 (17.2-1) ... 380s Selecting previously unselected package postgresql-17. 380s Preparing to unpack .../76-postgresql-17_17.2-1_s390x.deb ... 380s Unpacking postgresql-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-server-dev-17. 381s Preparing to unpack .../77-postgresql-server-dev-17_17.2-1_s390x.deb ... 381s Unpacking postgresql-server-dev-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-server-dev-all:s390x. 381s Preparing to unpack .../78-postgresql-server-dev-all_267_s390x.deb ... 381s Unpacking postgresql-server-dev-all:s390x (267) ... 381s Selecting previously unselected package postgresql-plperl-17. 381s Preparing to unpack .../79-postgresql-plperl-17_17.2-1_s390x.deb ... 381s Unpacking postgresql-plperl-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-plpython3-17. 381s Preparing to unpack .../80-postgresql-plpython3-17_17.2-1_s390x.deb ... 381s Unpacking postgresql-plpython3-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-pltcl-17. 381s Preparing to unpack .../81-postgresql-pltcl-17_17.2-1_s390x.deb ... 381s Unpacking postgresql-pltcl-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-all. 381s Preparing to unpack .../82-postgresql-all_267_all.deb ... 381s Unpacking postgresql-all (267) ... 381s Selecting previously unselected package postgresql-doc-17. 381s Preparing to unpack .../83-postgresql-doc-17_17.2-1_all.deb ... 381s Unpacking postgresql-doc-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-doc. 381s Preparing to unpack .../84-postgresql-doc_17+267_all.deb ... 381s Unpacking postgresql-doc (17+267) ... 382s Setting up libpgtypes3:s390x (17.2-1) ... 382s Setting up libncurses-dev:s390x (6.5-2) ... 382s Setting up libio-pty-perl (1:1.20-1build3) ... 382s Setting up libclang-common-19-dev:s390x (1:19.1.6-1ubuntu1) ... 382s Setting up libarchive-zip-perl (1.68-1) ... 382s Setting up libdebhelper-perl (13.20ubuntu1) ... 382s Setting up postgresql-doc-17 (17.2-1) ... 382s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 382s Setting up libpq5:s390x (17.2-1) ... 382s Setting up m4 (1.4.19-4build1) ... 382s Setting up libgomp1:s390x (14.2.0-12ubuntu1) ... 382s Setting up libffi-dev:s390x (3.4.6-1build1) ... 382s Setting up locales-all (2.40-4ubuntu1) ... 382s Setting up libfakeroot:s390x (1.36.2-1) ... 382s Setting up fakeroot (1.36.2-1) ... 382s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 382s Setting up autotools-dev (20220109.1) ... 382s Setting up libxml2-dev:s390x (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 382s Setting up libpfm4:s390x (4.13.0+git83-g91970fe-1) ... 382s Setting up emacsen-common (3.0.5) ... 382s Setting up ssl-cert (1.1.3ubuntu1) ... 382s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 383s Setting up libssl-dev:s390x (3.4.0-1ubuntu2) ... 383s Setting up libmpc3:s390x (1.3.1-1build2) ... 383s Setting up libtcl8.6:s390x (8.6.15+dfsg-2) ... 383s Setting up autopoint (0.22.5-3) ... 383s Setting up libipc-run-perl (20231003.0-2) ... 383s Setting up libgc1:s390x (1:8.2.8-1) ... 383s Setting up autoconf (2.72-3) ... 383s Setting up libubsan1:s390x (14.2.0-12ubuntu1) ... 383s Setting up dwz (0.15-1build6) ... 383s Setting up libasan8:s390x (14.2.0-12ubuntu1) ... 383s Setting up libjson-perl (4.10000-1) ... 383s Setting up postgresql-doc (17+267) ... 383s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 383s Setting up debugedit (1:5.1-1) ... 383s Setting up libecpg6:s390x (17.2-1) ... 383s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 383s Setting up libisl23:s390x (0.27-1) ... 383s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 383s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 383s Setting up libcc1-0:s390x (14.2.0-12ubuntu1) ... 383s Setting up libitm1:s390x (14.2.0-12ubuntu1) ... 383s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 383s Setting up automake (1:1.16.5-1.3ubuntu1) ... 383s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 383s Setting up postgresql-client-common (267) ... 383s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 383s Setting up gettext (0.22.5-3) ... 383s Setting up libecpg-compat3:s390x (17.2-1) ... 383s Setting up dictionaries-common (1.30.2) ... 383s Setting up postgresql-client-17 (17.2-1) ... 384s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 384s Setting up libpq-dev (17.2-1) ... 384s Setting up libobjc4:s390x (14.2.0-12ubuntu1) ... 384s Setting up libecpg-dev (17.2-1) ... 384s Setting up intltool-debian (0.35.0+20060710.6) ... 384s Setting up postgresql-common (267) ... 384s Creating config file /etc/postgresql-common/createcluster.conf with new version 384s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 384s en_us 384s Removing obsolete dictionary files: 385s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 385s Setting up cpp-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 385s Setting up cpp-14 (14.2.0-12ubuntu1) ... 385s Setting up dh-strip-nondeterminism (1.14.0-1) ... 385s Setting up hunspell-en-us (1:2020.12.07-3) ... 385s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 385s Setting up libgcc-14-dev:s390x (14.2.0-12ubuntu1) ... 385s Setting up libstdc++-14-dev:s390x (14.2.0-12ubuntu1) ... 385s Setting up postgresql-17 (17.2-1) ... 385s Creating new PostgreSQL cluster 17/main ... 385s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 385s The files belonging to this database system will be owned by user "postgres". 385s This user must also own the server process. 385s 385s The database cluster will be initialized with locale "C.UTF-8". 385s The default database encoding has accordingly been set to "UTF8". 385s The default text search configuration will be set to "english". 385s 385s Data page checksums are disabled. 385s 385s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 385s creating subdirectories ... ok 385s selecting dynamic shared memory implementation ... posix 385s selecting default "max_connections" ... 100 385s selecting default "shared_buffers" ... 128MB 385s selecting default time zone ... Etc/UTC 385s creating configuration files ... ok 386s running bootstrap script ... ok 386s performing post-bootstrap initialization ... ok 386s syncing data to disk ... ok 390s Setting up cpp-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 390s Setting up po-debconf (1.0.21+nmu1) ... 390s Setting up libobjc-14-dev:s390x (14.2.0-12ubuntu1) ... 390s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 390s Setting up gcc-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 390s Setting up gcc-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 390s Setting up g++-14-s390x-linux-gnu (14.2.0-12ubuntu1) ... 390s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 390s Setting up postgresql-plpython3-17 (17.2-1) ... 390s Setting up postgresql-plperl-17 (17.2-1) ... 390s Setting up cpp (4:14.1.0-2ubuntu1) ... 390s Setting up postgresql-pltcl-17 (17.2-1) ... 390s Setting up libtool (2.4.7-8) ... 390s Setting up g++-s390x-linux-gnu (4:14.1.0-2ubuntu1) ... 390s Setting up gcc-14 (14.2.0-12ubuntu1) ... 390s Setting up dh-autoreconf (20) ... 390s Setting up postgresql-server-dev-17 (17.2-1) ... 390s Setting up g++-14 (14.2.0-12ubuntu1) ... 390s Setting up postgresql-server-dev-all:s390x (267) ... 390s Setting up debhelper (13.20ubuntu1) ... 390s Setting up postgresql-all (267) ... 390s Setting up gcc (4:14.1.0-2ubuntu1) ... 390s Setting up g++ (4:14.1.0-2ubuntu1) ... 390s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 390s Setting up build-essential (12.10ubuntu1) ... 390s Processing triggers for libc-bin (2.40-4ubuntu1) ... 391s Processing triggers for systemd (257-2ubuntu1) ... 391s Processing triggers for man-db (2.13.0-1) ... 397s Processing triggers for install-info (7.1.1-1) ... 398s Processing triggers for dictionaries-common (1.30.2) ... 402s autopkgtest [14:42:35]: test run-testsuite: [----------------------- 403s ====== Running all tests with umask 077 ======= 403s ### PostgreSQL test 001_packages.t ### 403s 1..21 403s ok 1 - /etc/os-release exists 403s ok 2 - OS is ubuntu 403s ok 3 - OS version is 25.04 403s # PostgreSQL versions installed: 17 403s ok 4 - postgresql-17 installed 403s ok 5 - postgresql-plpython3-17 installed 403s ok 6 - postgresql-plperl-17 installed 403s ok 7 - postgresql-pltcl-17 installed 403s ok 8 - postgresql-server-dev-17 installed 403s ok 9 # skip No postgresql-contrib-17 package for version 17 403s # postgresql-doc-17 installed 403s ok 10 - At least one doc package installed 403s ok 11 - libecpg-dev installed 403s ok 12 - procps installed 403s ok 13 - netcat-openbsd installed 403s ok 14 - hunspell-en-us installed 403s ok 15 - system has a default UTF-8 locale 403s ok 16 - locale ru_RU exists 403s ok 17 - locale ru_RU.UTF-8 exists 403s ok 18 - user postgres in the UNIX group ssl-cert 403s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 403s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 403s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 403s ### End test 001_packages.t ### 403s 403s ### PostgreSQL test 002_existing_clusters.t ### 403s 1..8 403s # Cleanup 403s ok 1 - Cleanup: No clusters left behind 403s ok 2 - No postgres processes left behind 403s ok 3 - No files in /etc/postgresql left behind 403s ok 4 - No files in /var/lib/postgresql left behind 403s ok 5 - No files in /var/run/postgresql left behind 403s ok 6 - No files in /var/log/postgresql left behind 403s ok 7 - PostgreSQL TCP ports are closed 403s ok 8 - Next free port is 5432 403s ### End test 002_existing_clusters.t ### 403s 403s ### PostgreSQL test 003_alternatives.t ### 403s 1..9 403s # Newest PG version installed is 17 403s ok 1 - psql.1.gz link group 403s ok 2 - postmaster.1.gz link group does not exist 403s ok 3 - psql.1.gz alternative 403s ok 4 - pg_dump.1.gz alternative 403s ok 5 - postgres.1.gz alternative 403s ok 6 - pg_ctl.1.gz alternative 403s # Newest PG doc version installed is 17 403s ok 7 - SPI_connect.3.gz link group 403s ok 8 - SPI_connect.3.gz alternative 403s ok 9 - SPI_exec.3.gz alternative 403s ### End test 003_alternatives.t ### 403s 403s ### PostgreSQL test 005_PgCommon.t ### 404s 1..24 404s ok 1 - correctly parsed line 'local all postgres ident sameuser' 404s ok 2 - correctly parsed line 'local foo nobody trust' 404s ok 3 - correctly parsed line 'local foo nobody crypt' 404s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 404s ok 5 - correctly parsed line 'local foo,bar nobody ident' 404s ok 6 - correctly parsed line 'local all +foogrp password' 404s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 404s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 404s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 404s ok 10 - @expected_records has correct number of entries 404s ok 11 - returned read_pg_hba array has correct number of records 404s ok 12 - line 'foo all all md5' parsed as invalid 404s ok 13 - line 'local all all foo' parsed as invalid 404s ok 14 - line 'host all all foo' parsed as invalid 404s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 404s ok 16 - line 'host all all md5' parsed as invalid 404s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 404s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 404s ok 19 - read_conf_file returns empty dict for nonexisting file 404s ok 20 - read_conf_file() parsing 404s ok 21 - read_conf_file() parsing with include directives 404s ok 22 - set_conf_value 404s ok 23 - disable_conf_value 404s ok 24 - replace_conf_value 404s ### End test 005_PgCommon.t ### 404s 404s ### PostgreSQL test 006_next_free_port.t ### 404s 1..5 404s ok 1 - next_free_port is 5432 405s ok 2 - next_free_port detects localhost ipv4 socket 406s ok 3 - next_free_port detects wildcard ipv4 socket 407s ok 4 - next_free_port detects localhost ipv6 socket 408s ok 5 - next_free_port detects wildcard ipv6 socket 408s ### End test 006_next_free_port.t ### 408s 408s ### PostgreSQL test 007_pg_conftool.t ### 408s 1..41 408s # test without cluster 408s ok 1 - pg_conftool show all 408s ok 2 - correct output of pg_conftool show all 408s ok 3 - pg_conftool foo.conf show all 408s ok 4 - correct output of pg_conftool foo.conf show all 408s ok 5 - pg_conftool /tmp/hQ4625JMni/different.conf show all 408s ok 6 - correct output of pg_conftool /tmp/hQ4625JMni/different.conf show all 408s ok 7 - pg_conftool 9.7 main show all 408s ok 8 - correct output of pg_conftool 9.7 main show all 408s # test show 408s ok 9 - pg_conftool show all 408s ok 10 - correct output of pg_conftool show all 408s ok 11 - pg_conftool other.conf show all 408s ok 12 - correct output of pg_conftool other.conf show all 408s ok 13 - pg_conftool /tmp/hQ4625JMni/different.conf show all 408s ok 14 - correct output of pg_conftool /tmp/hQ4625JMni/different.conf show all 408s ok 15 - pg_conftool 17 main show all 408s ok 16 - correct output of pg_conftool 17 main show all 408s ok 17 - pg_conftool 17 main other.conf show all 408s ok 18 - correct output of pg_conftool 17 main other.conf show all 408s ok 19 - pg_conftool show a 408s ok 20 - correct output of pg_conftool show a 408s ok 21 - pg_conftool -s show a 408s ok 22 - correct output of pg_conftool -s show a 408s # test set 408s ok 23 - pg_conftool set c 7 408s ok 24 - correct output of pg_conftool set c 7 408s ok 25 - file contains new setting 408s ok 26 - pg_conftool set a 8 408s ok 27 - correct output of pg_conftool set a 8 408s ok 28 - file contains updated setting 409s ok 29 - pg_conftool /tmp/hQ4625JMni/different.conf set a 9 409s ok 30 - correct output of pg_conftool /tmp/hQ4625JMni/different.conf set a 9 409s ok 31 - file with path contains updated setting 409s # test remove 409s ok 32 - pg_conftool remove a 409s ok 33 - correct output of pg_conftool remove a 409s ok 34 - setting removed from file 409s ok 35 - pg_conftool /tmp/hQ4625JMni/different.conf remove a 409s ok 36 - correct output of pg_conftool /tmp/hQ4625JMni/different.conf remove a 409s ok 37 - setting removed from file with path 409s # test edit 409s ok 38 - pg_conftool edit 409s ok 39 - correct output of pg_conftool edit 409s ok 40 - pg_conftool /tmp/hQ4625JMni/different.conf edit 409s ok 41 - correct output of pg_conftool /tmp/hQ4625JMni/different.conf edit 409s ### End test 007_pg_conftool.t ### 409s 409s ### PostgreSQL test 010_defaultport_cluster.t ### 409s 1..14 409s ok 1 - psql --version 409s ok 2 - pg_wrapper selects highest available version number 409s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 409s ok 4 - connecting to localhost fails with no clusters 409s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 409s ok 6 - pg_wrapper uses host and port from PGCLUSTER 409s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 409s ok 8 - pg_wrapper uses --cluster from the command line 409s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 409s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 409s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 409s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 409s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 409s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 409s ### End test 010_defaultport_cluster.t ### 409s 409s ### PostgreSQL test 015_start_stop.t ### 409s 1..71 409s # We are running systemd 409s # Running tests for 17 409s # Cluster does not exist yet 409s ok 1 - cluster 17 main does not exist 409s ok 2 - service postgresql@17-main does not exist 409s ok 3 - systemctl start postgresql 410s ok 4 - cluster 17 main does not exist 410s ok 5 - service postgresql@17-main does not exist 410s ok 6 - systemctl start postgresql@17-main 410s ok 7 - cluster 17 main does not exist 410s ok 8 - service postgresql@17-main does not exist 410s # Start/stop postgresql using system tools 411s ok 9 - pg_createcluster 17 main 411s ok 10 - cluster 17 main is stopped 411s ok 11 - service postgresql@17-main is stopped 413s ok 12 - systemctl start postgresql 413s ok 13 - cluster 17 main is running 413s ok 14 - service postgresql@17-main is running 413s ok 15 - systemctl start postgresql 413s ok 16 - cluster 17 main is already running 413s ok 17 - service postgresql@17-main is already running 413s ok 18 - systemctl stop postgresql 419s ok 19 - cluster 17 main is stopped 419s ok 20 - service postgresql@17-main is stopped 419s ok 21 - systemctl stop postgresql 419s ok 22 - cluster 17 main is already stopped 419s ok 23 - service postgresql@17-main is already stopped 419s # Start/stop specific cluster using system tools 422s ok 24 - systemctl start postgresql@17-main 422s ok 25 - cluster 17 main is running 422s ok 26 - service postgresql@17-main is running 422s ok 27 - systemctl start postgresql@17-main 422s ok 28 - cluster 17 main is running 422s ok 29 - service postgresql@17-main is running 425s ok 30 - systemctl restart postgresql@17-main 425s ok 31 - cluster 17 main is running 425s ok 32 - service postgresql@17-main is running 425s ok 33 - systemctl stop postgresql@17-main 425s ok 34 - cluster 17 main is stopped 425s ok 35 - service postgresql@17-main is stopped 425s ok 36 - systemctl stop postgresql@17-main 425s ok 37 - cluster 17 main is already stopped 425s ok 38 - service postgresql@17-main is already stopped 427s ok 39 - pg_dropcluster 17 main 427s ok 40 - cluster 17 main does not exist 427s ok 41 - service postgresql@17-main does not exist 427s # Start/stop specific cluster using pg_*cluster 427s ok 42 - pg_ctlcluster start 17 main 427s ok 43 - cluster 17 main does not exist 427s ok 44 - service postgresql@17-main does not exist 430s ok 45 - pg_createcluster 17 main --start 430s ok 46 - cluster 17 main is running 430s ok 47 - service postgresql@17-main is running 430s ok 48 - pg_ctlcluster 17 main start 430s ok 49 - cluster 17 main is already running 430s ok 50 - service postgresql@17-main is already running 433s ok 51 - pg_ctlcluster 17-main restart 433s ok 52 - cluster 17 main is running 433s ok 53 - service postgresql@17-main is running 433s ok 54 - pg_ctlcluster 17 main stop 433s ok 55 - cluster 17 main is stopped 433s ok 56 - service postgresql@17-main is stopped 433s ok 57 - pg_ctlcluster 17 main stop 433s ok 58 - cluster 17 main is already stopped 433s ok 59 - service postgresql@17-main is already stopped 436s ok 60 - pg_ctlcluster start 17-main 436s ok 61 - cluster 17 main is running 436s ok 62 - service postgresql@17-main is running 437s ok 63 - pg_dropcluster 17 main --stop 437s # Cleanup 437s ok 64 - Cleanup: No clusters left behind 437s ok 65 - No postgres processes left behind 437s ok 66 - No files in /etc/postgresql left behind 437s ok 67 - No files in /var/lib/postgresql left behind 437s ok 68 - No files in /var/run/postgresql left behind 437s ok 69 - No files in /var/log/postgresql left behind 437s ok 70 - PostgreSQL TCP ports are closed 437s ok 71 - Next free port is 5432 437s ### End test 015_start_stop.t ### 437s 437s ### PostgreSQL test 020_create_sql_remove.t ### 437s 1..141 437s # Running tests for 17 441s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.N3pPfj 441s ok 2 - pg_createcluster 17 main 441s ok 3 - Socket and pid file are in /var/run/postgresql/ 441s ok 4 - xlog/wal directory /tmp/17.xlog.N3pPfj was created 441s ok 5 - local method in pg_hba.conf is peer 441s ok 6 - host method in pg_hba.conf is scram-sha-256 441s ok 7 - Exactly one postgres master process running 443s ok 8 - pg_ctlcluster 17 main restart 443s ok 9 - cluster restarts with new environment file 443s ok 10 - Exactly one postgres master process running 443s ok 11 - correct value of PGEXTRAVAR1 in environment 443s ok 12 - correct value of PGEXTRAVAR2 in environment 443s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 443s ok 14 - createdb --version 443s ok 15 - pg_wrapper+createdb selects version number of cluster 443s ok 16 - psql --version 443s ok 17 - pg_wrapper+psql selects version 17 443s ok 18 - pg_lscluster reports online cluster on port 5432 443s ok 19 - log file is actually used 443s ok 20 - /etc/postgresql is owned by user "postgres" 443s ok 21 - version configuration directory file is owned by user "postgres" 443s ok 22 - configuration directory file is owned by user "postgres" 443s ok 23 - version data directory file is owned by user "postgres" 443s ok 24 - data directory file is owned by user "postgres" 443s ok 25 - log file has 0640 permissions 443s ok 26 - log file is owned by user "postgres" 443s ok 27 - log file is owned by group "adm" 443s ok 28 - no log symlink by default 443s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 443s ok 30 - pg_lsclusters -h 443s ok 31 - correct output of pg_lsclusters -h 444s ok 32 - stopping cluster 446s ok 33 - restarting cluster with nondefault log symlink 446s ok 34 - log target is used as log file 446s ok 35 - default log is not used 446s ok 36 - pg_lsclusters -h 446s ok 37 - correct output of pg_lsclusters -h 446s ok 38 - stopping cluster 449s ok 39 - restarting cluster with explicitly configured log file 449s ok 40 - default log is not used 449s ok 41 - log symlink target is used for startup message 449s ok 42 - exactly one log file 449s ok 43 - custom log is actually used 450s ok 44 - pg_lsclusters -h 450s ok 45 - correct output of pg_lsclusters -h 450s ok 46 - stopping cluster 450s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 450s ok 48 - /etc/postgres-hack was not created 452s ok 49 - restarting cluster 452s ok 50 - ps -o tty -U postgres h 452s ok 51 - postgres processes do not have an associated terminal 452s ok 52 - Server is linked with SSL support 452s ok 53 - SSL is enabled in postgresql.conf 452s ok 54 - psql -l fails for nobody 452s ok 55 - createuser nobody 452s ok 56 - createdb nobodydb 453s ok 57 - psql -ltA succeeds for nobody 453s ok 58 - psql -ltA output 453s ok 59 - SQL command: create table 453s ok 60 - SQL command: insert into table values 453s ok 61 - SQL command: insert into table values 453s ok 62 - primary key violation 453s ok 63 - psql -tAc "select * from phone order by name" nobodydb 453s ok 64 - SQL command output: select -tA 453s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 453s ok 66 - SQL command output: select -tx 453s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 453s ok 68 - SQL command output: select -tAx 453s ok 69 - CREATE EXTENSION plperlu fails for user nobody 454s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 454s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 454s ok 72 - creating PL/PerlU function as user nobody fails 454s ok 73 - creating unsafe PL/Perl function as user postgres fails 454s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 454s ok 75 - creating PL/PerlU function as user postgres succeeds 454s ok 76 - psql nobodydb -Atc "select read_file()" 454s ok 77 - calling PL/PerlU function 454s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 454s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 454s ok 80 - creating unsafe PL/Perl function as user nobody fails 454s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 454s ok 82 - creating PL/Perl function as user nobody succeeds 454s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 454s ok 84 - calling PL/Perl function 454s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 454s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 454s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 454s ok 88 - creating PL/Python3 function as user postgres succeeds 454s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 454s ok 90 - calling PL/Python function 454s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 454s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 455s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 455s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 455s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 455s ok 96 - creating PL/Tcl function as user nobody succeeds 455s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 455s ok 98 - creating PL/TclU function as user postgres succeeds 455s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 455s ok 100 - calling PL/Tcl function 455s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 455s ok 102 - calling PL/TclU function 455s ok 103 - stopping cluster 455s ok 104 - pg_ctlcluster 17 main start 455s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 457s ok 106 - pg_ctlcluster 17 main start 457s ok 107 - cluster restarts with pgdata symlink 458s ok 108 - postgres master has OOM killer protection 458s ok 109 - postgres client backend has no OOM adjustment 458s ok 110 - ps h 6441 458s ok 111 - process title is idle 458s ok 112 - ps h 6441 458s ok 113 - process title is idle in transaction 458s ok 114 - stopping cluster 461s ok 115 - starting cluster as postgres works without a log file 461s ok 116 - log file got recreated and used 461s ok 117 - creating a directory in spc2 461s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.0CJgEs'" 461s ok 119 - creating tablespace spc1 461s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 461s ok 121 - creating a table in spc1 461s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.rQeLnc'" 461s ok 123 - creating tablespace spc2 461s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 461s ok 125 - creating a table in spc2 461s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 461s ok 127 - Correct apt NeverAutoRemove config 462s ok 128 - pg_dropcluster removes cluster 462s ok 129 - xlog/wal directory /tmp/17.xlog.N3pPfj was deleted 462s ok 130 - tablespace spc1 was emptied 462s ok 131 - tablespace spc2 was emptied 462s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 462s ok 133 - Correct apt NeverAutoRemove config 462s # Cleanup 462s ok 134 - Cleanup: No clusters left behind 462s ok 135 - No postgres processes left behind 462s ok 136 - No files in /etc/postgresql left behind 462s ok 137 - No files in /var/lib/postgresql left behind 462s ok 138 - No files in /var/run/postgresql left behind 462s ok 139 - No files in /var/log/postgresql left behind 462s ok 140 - PostgreSQL TCP ports are closed 462s ok 141 - Next free port is 5432 462s ### End test 020_create_sql_remove.t ### 462s 462s ### PostgreSQL test 021_pg_renamecluster.t ### 462s 1..20 466s ok 1 - pg_createcluster 17 main 469s ok 2 - pg_renamecluster 17 main donau 469s ok 3 - psql -tAc "show data_directory" 469s ok 4 - cluster is running and data_directory was moved 469s ok 5 - pg_hba.conf location updated 469s ok 6 - pg_ident.conf location updated 469s ok 7 - external_pid_file location updated 469s ok 8 - external_pid_file exists 469s ok 9 # skip no stats_temp_directory in 17 469s ok 10 # skip no stats_temp_directory in 17 469s ok 11 - cluster_name is updated 471s ok 12 - pg_dropcluster removes cluster 471s # Cleanup 471s ok 13 - Cleanup: No clusters left behind 471s ok 14 - No postgres processes left behind 471s ok 15 - No files in /etc/postgresql left behind 471s ok 16 - No files in /var/lib/postgresql left behind 471s ok 17 - No files in /var/run/postgresql left behind 471s ok 18 - No files in /var/log/postgresql left behind 471s ok 19 - PostgreSQL TCP ports are closed 471s ok 20 - Next free port is 5432 471s ### End test 021_pg_renamecluster.t ### 471s 471s ### PostgreSQL test 022_recovery.t ### 471s 1..17 471s # Running tests for 17 474s ok 1 - pg_createcluster 17 main --start >/dev/null 474s ok 2 - pg_ctlcluster 17 main stop -m i 476s ok 3 - pg_ctlcluster 17 main start 476s ok 4 - psql -c '' 477s ok 5 - pg_ctlcluster 17 main stop -m i 477s ok 6 - create write-protected file in data directory 479s ok 7 - pg_ctlcluster 17 main start 479s ok 8 - psql -c '' 480s ok 9 - pg_dropcluster removes cluster 480s # Cleanup 481s ok 10 - Cleanup: No clusters left behind 481s ok 11 - No postgres processes left behind 481s ok 12 - No files in /etc/postgresql left behind 481s ok 13 - No files in /var/lib/postgresql left behind 481s ok 14 - No files in /var/run/postgresql left behind 481s ok 15 - No files in /var/log/postgresql left behind 481s ok 16 - PostgreSQL TCP ports are closed 481s ok 17 - Next free port is 5432 481s ### End test 022_recovery.t ### 481s 481s ### PostgreSQL test 025_logging.t ### 481s 1..55 481s # Logging to /var/log/syslog works 481s # Running tests for 17 485s ok 1 - pg_createcluster 17 main 485s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 485s ok 3 - psql -qc "'foobar_17_7714'" 485s ok 4 - log an error 485s ok 5 - grep --binary-files=text foobar_17_7714 /var/log/postgresql/postgresql-17-main.log 485s ok 6 - error appears in logfile 485s ok 7 - pg_conftool 17 main set log_destination syslog 485s ok 8 - set log_destination syslog 485s ok 9 - pg_ctlcluster 17 main reload 485s ok 10 - 17 main reload 485s ok 11 - psql -Atc "show log_destination" 485s ok 12 - log_destination is syslog 485s ok 13 - pg_lscluster reports syslog 486s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 486s ok 15 - error appears in /var/log/syslog 486s ok 16 - pg_conftool 17 main set logging_collector on 486s ok 17 - set logging_collector on 486s ok 18 - pg_conftool 17 main set log_destination csvlog 486s ok 19 - set log_destination csvlog 489s ok 20 - pg_ctlcluster 17 main restart 489s ok 21 - 17 main restart 489s ok 22 - psql -Atc "show logging_collector" 489s ok 23 - logging_collector is on 489s ok 24 - psql -Atc "show log_destination" 489s ok 25 - log_destination is csvlog 489s ok 26 - pg_lscluster reports csvlog 489s ok 27 - psql -qc "'barbaz_17_7714'" 489s ok 28 - log an error 489s ok 29 - grep --binary-files=text barbaz_17_7714 /var/lib/postgresql/17/main/log/*.csv 489s ok 30 - error appears in log/*.csv 489s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 489s ok 32 - set log_destination stderr,syslog,csvlog 489s ok 33 - pg_ctlcluster 17 main reload 489s ok 34 - 17 main reload 489s ok 35 - psql -Atc "show log_destination" 489s ok 36 - log_destination is stderr,syslog,csvlog 489s ok 37 - pg_lscluster reports stderr,syslog,csvlog 489s ok 38 - psql -qc "'moo_17_7714'" 489s ok 39 - log an error 490s ok 40 - grep --binary-files=text moo_17_7714 /var/lib/postgresql/17/main/log/*.log 490s ok 41 - error appears in log/*.log 490s ok 42 - grep --binary-files=text 'postgres.*moo_17_7714' /var/log/syslog 490s ok 43 - error appears in /var/log/syslog 490s ok 44 - grep --binary-files=text moo_17_7714 /var/lib/postgresql/17/main/log/*.csv 490s ok 45 - error appears in log/*.csv 492s ok 46 - pg_dropcluster 17 main --stop 492s ok 47 - pg_dropcluster removes cluster 492s # Cleanup 492s ok 48 - Cleanup: No clusters left behind 492s ok 49 - No postgres processes left behind 492s ok 50 - No files in /etc/postgresql left behind 492s ok 51 - No files in /var/lib/postgresql left behind 492s ok 52 - No files in /var/run/postgresql left behind 492s ok 53 - No files in /var/log/postgresql left behind 492s ok 54 - PostgreSQL TCP ports are closed 492s ok 55 - Next free port is 5432 492s ### End test 025_logging.t ### 492s 492s ### PostgreSQL test 027_jit.t ### 492s # 17 496s ok 1 - pg_createcluster 17 main --start 496s ok 2 - psql -Xatc 'show jit' 496s ok 3 - JIT is on by default 496s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 496s ok 5 - No JIT on cheap query 496s ok 6 - pg_conftool 17 main set seq_page_cost 100000 496s ok 7 - pg_conftool 17 main set random_page_cost 100000 496s ok 8 - pg_ctlcluster 17 main reload 499s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 499s ok 10 - Expensive query is JITed 500s ok 11 - pg_dropcluster --stop 17 main 500s # Cleanup 500s ok 12 - Cleanup: No clusters left behind 500s ok 13 - No postgres processes left behind 500s ok 14 - No files in /etc/postgresql left behind 500s ok 15 - No files in /var/lib/postgresql left behind 500s ok 16 - No files in /var/run/postgresql left behind 500s ok 17 - No files in /var/log/postgresql left behind 500s ok 18 - PostgreSQL TCP ports are closed 500s ok 19 - Next free port is 5432 501s 1..19 501s ### End test 027_jit.t ### 501s 501s ### PostgreSQL test 030_errors.t ### 501s 1..156 501s ok 1 - pg_lscluster reports cluster without binaries 502s ok 2 - pg_dropcluster 6.3 main 503s ok 3 - pg_createcluster --socketdir 503s ok 4 - pg_lsclusters -h 503s ok 5 - cluster was created 503s ok 6 - Port of created cluster is 5432 503s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 503s ok 8 - pg_createcluster on existing cluster 504s ok 9 - pg_lsclusters -h 504s ok 10 - original cluster still exists 504s ok 11 - pg_createcluster 17 test -p foo 504s ok 12 - pg_createcluster -p checks that port option is numeric 504s ok 13 - pg_createcluster 17 test -p 42 504s ok 14 - pg_createcluster -p checks valid port range 504s ok 15 - pg_ctlcluster 17 main start 504s ok 16 - pg_ctlcluster refuses to start root-owned cluster 504s ok 17 - pg_ctlcluster 17 main start 504s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 504s ok 19 - pg_ctlcluster 17 main start 504s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 504s ok 21 - pg_ctlcluster 17 main start 504s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 506s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 506s ok 24 - No sockets in /var/run/postgresql 506s ok 25 - Socket is in /tmp/postgresql-testsuite/ 507s ok 26 - cluster stops with custom unix_socket_dir 507s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 509s ok 28 - cluster starts after removing unix_socket_dir 509s ok 29 - Socket is in default dir /var/run/postgresql 509s ok 30 - No sockets in /tmp/postgresql-testsuite/ 509s ok 31 - pg_ctlcluster 17 main stop 509s ok 32 - pg_ctlcluster fails with corrupted PID file 509s ok 33 - pg_lsclusters -h 509s ok 34 - cluster is still online 509s ok 35 - pg_ctlcluster succeeds with restored PID file 509s ok 36 - pg_lsclusters -h 509s ok 37 - cluster is down 509s ok 38 - pg_ctlcluster 17 main stop 509s ok 39 - pg_ctlcluster stop fails on stopped cluster 512s ok 40 - pg_ctlcluster 17 main start 512s ok 41 - pg_ctlcluster succeeds with already existing PID file 512s ok 42 - pg_lsclusters -h 512s ok 43 - cluster is online 512s ok 44 - pg_ctlcluster stop succeeds 512s ok 45 - pg_lsclusters -h 512s ok 46 - cluster is down 512s ok 47 - no pid file left 512s ok 48 - pg_ctlcluster 17 main stop 512s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 512s ok 50 - pid file was cleaned up 512s ok 51 - pg_ctlcluster --force 17 main stop 512s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 512s ok 53 - pid file was cleaned up 512s ok 54 - pg_ctlcluster 17 main stop 512s ok 55 - pg_ctlcluster stop succeeds with stale PID file 512s ok 56 - pid file was cleaned up 512s ok 57 - pg_ctlcluster --force 17 main stop 512s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 512s ok 59 - pid file was cleaned up 512s ok 60 - pg_ctlcluster --force 17 main stop 512s ok 61 - pg_ctlcluster stop succeeds with empty PID file 512s ok 62 - pid file was cleaned up 515s ok 63 - pg_ctlcluster 17 main start 515s ok 64 - pg_ctlcluster succeeds with corrupted PID file 515s ok 65 - pg_lsclusters -h 515s ok 66 - cluster is online 515s ok 67 - pg_ctlcluster 17 main start 515s ok 68 - pg_ctlcluster start fails on running cluster 515s ok 69 - pg_ctlcluster stop 515s ok 70 - pg_ctlcluster 17 main start 515s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 515s ok 72 - pg_ctlcluster 17 main stop 515s ok 73 - stopping cluster 522s ok 74 - pg_ctlcluster 17 main start 522s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 522s ok 76 - pg_ctlcluster 17 main stop 522s ok 77 - stopping cluster 522s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 522s ok 79 - pg_dropcluster 17 main 522s ok 80 - pg_dropcluster works as user postgres 523s ok 81 - pg_createcluster succeeds 523s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 523s ok 83 - proper error message for nonexisting /var/lib/postgresql 525s ok 84 - pg_ctlcluster 17 main start 525s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 525s ok 86 - pg_ctlcluster 17 main stop 525s ok 87 - stopping cluster 526s ok 88 - pg_createcluster other 528s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 531s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 531s ok 91 531s ok 92 - pg_ctlcluster 17 other start 531s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 531s ok 94 - pg_ctlcluster 17 main stop 531s ok 95 - stopping main cluster 534s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 536s ok 97 - pg_dropcluster other 537s ok 98 - pg_dropcluster 537s ok 99 - No sockets any more 537s ok 100 - 'pg_lsclusters 4.5 foo' fails 537s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 537s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 537s ok 103 - 'psql --cluster 4.5/foo' fails 537s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 537s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 537s ok 106 - 'psql --cluster 17/foo' fails 537s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 537s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 537s ok 109 - 'pg_dropcluster 4.5 foo' fails 537s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 537s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 537s ok 112 - 'pg_dropcluster 17 foo' fails 537s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 537s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 537s ok 115 - 'pg_upgradecluster 4.5 foo' fails 537s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 537s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 537s ok 118 - 'pg_upgradecluster 17 foo' fails 537s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 537s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 537s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 537s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 537s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 537s ok 124 - 'pg_ctlcluster 17 foo stop' fails 537s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 537s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 537s # Cleanup 537s ok 127 - Cleanup: No clusters left behind 538s ok 128 - No postgres processes left behind 538s ok 129 - No files in /etc/postgresql left behind 538s ok 130 - No files in /var/lib/postgresql left behind 538s ok 131 - No files in /var/run/postgresql left behind 538s ok 132 - No files in /var/log/postgresql left behind 538s ok 133 - PostgreSQL TCP ports are closed 538s ok 134 - Next free port is 5432 539s ok 135 - pg_dropcluster 17 broken 539s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 539s # Cleanup 539s ok 137 - Cleanup: No clusters left behind 539s ok 138 - No postgres processes left behind 539s ok 139 - No files in /etc/postgresql left behind 539s ok 140 - No files in /var/lib/postgresql left behind 539s ok 141 - No files in /var/run/postgresql left behind 539s ok 142 - No files in /var/log/postgresql left behind 539s ok 143 - PostgreSQL TCP ports are closed 539s ok 144 - Next free port is 5432 541s ok 145 - pg_dropcluster 17 broken 541s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 541s ok 147 - /etc/postgresql/17 was removed 541s ok 148 - /var/lib/postgresql/17 was removed 541s # Cleanup 541s ok 149 - Cleanup: No clusters left behind 541s ok 150 - No postgres processes left behind 541s ok 151 - No files in /etc/postgresql left behind 541s ok 152 - No files in /var/lib/postgresql left behind 541s ok 153 - No files in /var/run/postgresql left behind 541s ok 154 - No files in /var/log/postgresql left behind 541s ok 155 - PostgreSQL TCP ports are closed 541s ok 156 - Next free port is 5432 541s ### End test 030_errors.t ### 541s 541s ### PostgreSQL test 031_errors_disk_full.t ### 541s 1..22 541s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 543s ok 1 - script failed 543s ok 2 - pg_createcluster fails due to insufficient disk space 543s ok 3 - does not leave files behind 543s # Cleanup 543s ok 4 - Cleanup: No clusters left behind 543s ok 5 - No postgres processes left behind 543s ok 6 - No files in /etc/postgresql left behind 543s ok 7 - No files in /var/lib/postgresql left behind 543s ok 8 - No files in /var/run/postgresql left behind 543s ok 9 - No files in /var/log/postgresql left behind 543s ok 10 - PostgreSQL TCP ports are closed 543s ok 11 - Next free port is 5432 543s # check disk full conditions on startup 546s ok 12 - script failed 546s ok 13 - pg_ctlcluster prints error message 546s ok 14 - log file has error message 546s # Cleanup 546s ok 15 - Cleanup: No clusters left behind 546s ok 16 - No postgres processes left behind 546s ok 17 - No files in /etc/postgresql left behind 546s ok 18 - No files in /var/lib/postgresql left behind 546s ok 19 - No files in /var/run/postgresql left behind 546s ok 20 - No files in /var/log/postgresql left behind 546s ok 21 - PostgreSQL TCP ports are closed 546s ok 22 - Next free port is 5432 546s ### End test 031_errors_disk_full.t ### 546s 546s ### PostgreSQL test 032_ssl_key_permissions.t ### 546s 1..22 546s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 546s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 546s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 546s # 17 (17.2-1) 547s ok 4 - pg_createcluster 17 main 548s ok 5 - pg_ctlcluster 17 main start 548s ok 6 - ssl key owned by nobody refused 548s ok 7 - pg_ctlcluster 17 main start 548s ok 8 - ssl key with permissions root:root 0644 refused 548s ok 9 - pg_ctlcluster 17 main start 548s ok 10 - ssl key with permissions postgres:postgres 0640 refused 549s ok 11 - pg_dropcluster 17 main --stop 549s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 549s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 549s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 549s # Cleanup 549s ok 15 - Cleanup: No clusters left behind 549s ok 16 - No postgres processes left behind 549s ok 17 - No files in /etc/postgresql left behind 549s ok 18 - No files in /var/lib/postgresql left behind 549s ok 19 - No files in /var/run/postgresql left behind 549s ok 20 - No files in /var/log/postgresql left behind 549s ok 21 - PostgreSQL TCP ports are closed 549s ok 22 - Next free port is 5432 549s ### End test 032_ssl_key_permissions.t ### 549s 549s ### PostgreSQL test 040_upgrade.t ### 550s 1..1 550s ok 1 - only one major version installed, skipping upgrade tests 550s ### End test 040_upgrade.t ### 550s 550s ### PostgreSQL test 041_upgrade_custompaths.t ### 550s 1..1 550s ok 1 - only one major version installed, skipping upgrade tests 550s ### End test 041_upgrade_custompaths.t ### 550s 550s ### PostgreSQL test 042_upgrade_rename.t ### 550s 1..15 550s # PostgreSQL 17 553s ok 1 - pg_createcluster 17 main --start 559s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 559s ok 3 - pg_lsclusters -h 559s ok 4 - correct output of pg_lsclusters -h 561s ok 5 - pg_dropcluster 17 main --stop 563s ok 6 - pg_dropcluster 17 upgr --stop 563s ok 7 - Cleaning pg_upgrade log files 563s # Cleanup 563s ok 8 - Cleanup: No clusters left behind 563s ok 9 - No postgres processes left behind 563s ok 10 - No files in /etc/postgresql left behind 563s ok 11 - No files in /var/lib/postgresql left behind 563s ok 12 - No files in /var/run/postgresql left behind 563s ok 13 - No files in /var/log/postgresql left behind 563s ok 14 - PostgreSQL TCP ports are closed 563s ok 15 - Next free port is 5432 563s ### End test 042_upgrade_rename.t ### 563s 563s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 563s 1..1 563s ok 1 - only one major version installed, skipping upgrade tests 563s ### End test 043_upgrade_ssl_cert.t ### 563s 563s ### PostgreSQL test 045_backup.t ### 563s # We are running systemd 563s # PostgreSQL 17 563s # create cluster 567s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 567s ok 2 - pg_lsclusters -h 567s ok 3 - correct output of pg_lsclusters -h 567s ok 4 - pg_conftool 17 main set work_mem 11MB 567s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 567s ok 6 - psql -c 'alter database mydb set search_path=public' 567s ok 7 - psql -c 'create table foo (t text)' mydb 567s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 567s ok 9 - psql -c 'CREATE USER myuser' 567s ok 10 - psql -c 'grant create on database mydb to myuser' 567s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 567s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 567s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 567s # create directory 567s ok 14 - pg_backupcluster 17 main createdirectory 567s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 567s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 567s # dump 568s ok 17 - systemctl start pg_dump@17-main 568s ok 18 - dump created in /var/backups/postgresql/17-main/2025-01-16T144520Z.dump 568s ok 19 - /var/backups/postgresql/17-main/2025-01-16T144520Z.dump owned by uid postgres 568s ok 20 - /var/backups/postgresql/17-main/2025-01-16T144520Z.dump owned by gid postgres 568s # basebackup 568s ok 21 - systemctl start pg_receivewal@17-main 568s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 568s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 569s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 569s ok 25 - psql -c 'select pg_reload_conf()' 597s ok 26 - systemctl start pg_basebackup@17-main 597s ok 27 - dump created in /var/backups/postgresql/17-main/2025-01-16T144522Z.backup 597s ok 28 - /var/backups/postgresql/17-main/2025-01-16T144522Z.backup owned by uid postgres 597s ok 29 - /var/backups/postgresql/17-main/2025-01-16T144522Z.backup owned by gid postgres 597s # list 597s ok 30 - pg_backupcluster 17 main list 597s ok 31 - correct output of pg_backupcluster 17 main list 597s # more database changes 597s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 597s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 597s ok 34 - retrieve recovery timestamp 597s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 598s ok 36 - systemctl stop pg_receivewal@17-main 598s # restore /var/backups/postgresql/17-main/2025-01-16T144520Z.dump 599s ok 37 - pg_dropcluster 17 main --stop 604s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T144520Z.dump --start --datadir /var/lib/postgresql/17/snowflake 604s ok 39 - pg_lsclusters -h 604s ok 40 - correct output of pg_lsclusters -h 604s ok 41 - psql -XAtl 604s ok 42 - mydb locales 604s ok 43 - mydb grants 604s ok 44 - myicudb locales 604s ok 45 - psql -XAtc 'show work_mem' 604s ok 46 - correct output of psql -XAtc 'show work_mem' 604s ok 47 - psql -XAtc 'select * from foo' mydb 604s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 604s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 604s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 604s ok 51 - psql -XAtc '\drds' 604s ok 52 - correct output of psql -XAtc '\drds' 604s # restore /var/backups/postgresql/17-main/2025-01-16T144522Z.backup 606s ok 53 - pg_dropcluster 17 main --stop 609s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T144522Z.backup --start --datadir /var/lib/postgresql/17/snowflake 609s ok 55 - pg_lsclusters -h 609s ok 56 - correct output of pg_lsclusters -h 609s ok 57 - psql -XAtl 609s ok 58 - mydb locales 609s ok 59 - mydb grants 609s ok 60 - myicudb locales 609s ok 61 - psql -XAtc 'show work_mem' 609s ok 62 - correct output of psql -XAtc 'show work_mem' 609s ok 63 - psql -XAtc 'select * from foo' mydb 609s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 609s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 609s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 609s ok 67 - psql -XAtc '\drds' 609s ok 68 - correct output of psql -XAtc '\drds' 609s # restore /var/backups/postgresql/17-main/2025-01-16T144522Z.backup with WAL archive 611s ok 69 - pg_dropcluster 17 main --stop 615s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T144522Z.backup --start --archive --port 5430 615s ok 71 - pg_lsclusters -h 615s ok 72 - correct output of pg_lsclusters -h 615s ok 73 - psql -XAtc 'select * from foo order by t' mydb 615s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 615s # restore /var/backups/postgresql/17-main/2025-01-16T144522Z.backup with PITR 617s ok 75 - pg_dropcluster 17 main --stop 620s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T144522Z.backup --start --pitr '2025-01-16 14:45:50.292688+00 620s # ' 620s ok 77 - pg_lsclusters -h 620s ok 78 - correct output of pg_lsclusters -h 620s ok 79 - psql -XAtc 'select * from foo order by t' mydb 620s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 622s ok 81 - pg_dropcluster 17 main --stop 622s # Cleanup 622s ok 82 - Cleanup: No clusters left behind 622s ok 83 - No postgres processes left behind 622s ok 84 - No files in /etc/postgresql left behind 622s ok 85 - No files in /var/lib/postgresql left behind 622s ok 86 - No files in /var/run/postgresql left behind 622s ok 87 - No files in /var/log/postgresql left behind 622s ok 88 - PostgreSQL TCP ports are closed 622s ok 89 - Next free port is 5432 622s 1..89 622s ### End test 045_backup.t ### 622s 622s ### PostgreSQL test 050_encodings.t ### 622s 1..60 622s # Checking 17 ru_RU 626s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 627s ok 2 - psql -l succeeds 627s ok 3 - template1 is not UTF-8 encoded 627s ok 4 - creating test database 627s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 627s # create table t (x varchar); copy t from stdin" test 627s ok 6 - creating table with ISO-8859-5 characters 627s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 627s ok 8 - correct string in UTF-8 627s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 627s ok 10 - correct string in ISO-8859-5 627s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 627s # delete from t; copy t from stdin" test 627s ok 12 - creating table with UTF-8 characters 627s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 627s ok 14 - correct string in UTF-8 627s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 627s ok 16 - correct string in ISO-8859-1 627s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 627s ok 18 - Server error message has correct language and encoding 630s ok 19 - pg_ctlcluster 17 ru_RU restart 630s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 632s ok 21 - Dropping cluster 632s # Checking 17 ru_RU.UTF-8 635s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 636s ok 23 - psql -l succeeds 636s ok 24 - template1 is UTF-8 encoded 636s ok 25 - creating test database 636s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 636s # create table t (x varchar); copy t from stdin" test 636s ok 27 - creating table with ISO-8859-5 characters 636s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 636s ok 29 - correct string in UTF-8 636s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 636s ok 31 - correct string in ISO-8859-5 636s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 636s # delete from t; copy t from stdin" test 636s ok 33 - creating table with UTF-8 characters 637s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 637s ok 35 - correct string in UTF-8 637s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 637s ok 37 - correct string in ISO-8859-1 637s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 637s ok 39 - Server error message has correct language and encoding 639s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 639s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 639s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 639s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 639s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 639s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 639s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 639s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 641s ok 48 - Dropping cluster 641s # Check 17 locale environment variables 644s ok 49 - pg_createcluster: LC_ALL dominates LANG 645s ok 50 - psql -Atl --cluster 17/main 645s ok 51 - template1 is ASCII encoded 646s ok 52 - Dropping cluster 646s # Cleanup 646s ok 53 - Cleanup: No clusters left behind 646s ok 54 - No postgres processes left behind 646s ok 55 - No files in /etc/postgresql left behind 646s ok 56 - No files in /var/lib/postgresql left behind 646s ok 57 - No files in /var/run/postgresql left behind 646s ok 58 - No files in /var/log/postgresql left behind 646s ok 59 - PostgreSQL TCP ports are closed 646s ok 60 - Next free port is 5432 646s ### End test 050_encodings.t ### 646s 646s ### PostgreSQL test 052_upgrade_encodings.t ### 646s 1..1 646s ok 1 - only one major version installed, skipping upgrade tests 646s ### End test 052_upgrade_encodings.t ### 646s 646s ### PostgreSQL test 060_obsolete_confparams.t ### 646s ok 1 - only one major version installed, skipping upgrade tests 646s 1..1 646s ### End test 060_obsolete_confparams.t ### 646s 646s ### PostgreSQL test 070_non_postgres_clusters.t ### 646s 1..40 647s ok 1 - pg_createcluster 17 main for owner nobody 647s ok 2 - pg_ctlcluster 17 main start 647s ok 3 - start refused when config and data owners mismatch 650s ok 4 - pg_ctlcluster succeeds with owner nobody 650s ok 5 - pg_lsclusters -h 650s ok 6 - pg_lsclusters shows running cluster 650s ok 7 - postgres is running as user nobody 650s ok 8 - ls /tmp/.s.PGSQL.* 650s ok 9 - socket is in /tmp 650s ok 10 - /var/run/postgresql is empty 650s ok 11 - conf dir is owned by user 650s ok 12 - conf dir is owned by user's primary group 650s ok 13 - files are owned by user 650s ok 14 - files are owned by user's primary group 650s ok 15 - log file has 0640 permissions 650s ok 16 - log file is owned by user 650s ok 17 - log file is owned by user's primary group 650s ok 18 - only one major version installed, skipping upgrade test 650s ok 19 - ... 650s ok 20 - ... 650s ok 21 - ... 650s ok 22 - ... 650s ok 23 - ... 650s ok 24 - ... 650s ok 25 - ... 650s ok 26 - ... 650s ok 27 - ... 650s ok 28 - ... 652s ok 29 - pg_dropcluster 652s ok 30 - pg_lsclusters -h 652s ok 31 - No clusters left 652s ok 32 - No postgres processes left 652s # Cleanup 652s ok 33 - Cleanup: No clusters left behind 652s ok 34 - No postgres processes left behind 652s ok 35 - No files in /etc/postgresql left behind 652s ok 36 - No files in /var/lib/postgresql left behind 652s ok 37 - No files in /var/run/postgresql left behind 652s ok 38 - No files in /var/log/postgresql left behind 652s ok 39 - PostgreSQL TCP ports are closed 652s ok 40 - Next free port is 5432 652s ### End test 070_non_postgres_clusters.t ### 652s 652s ### PostgreSQL test 080_start.conf.t ### 652s 1..73 653s ok 1 - pg_createcluster 17 main 653s # start.conf auto 653s ok 2 - get_cluster_start_conf returns auto 653s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 653s ok 4 - start.conf contains auto 653s ok 5 - systemd generator links cluster 653s ok 6 - systemd generator links correct service file 656s ok 7 - /etc/init.d/postgresql start 17 656s ok 8 - correct output of /etc/init.d/postgresql start 17 656s ok 9 - pg_lsclusters -h 656s ok 10 - cluster is online 656s ok 11 - /etc/init.d/postgresql stop 17 656s ok 12 - correct output of /etc/init.d/postgresql stop 17 659s ok 13 - pg_lsclusters -h 659s ok 14 - cluster is down 659s # start.conf manual 659s ok 15 - get_cluster_start_conf returns manual 659s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 659s ok 17 - start.conf contains manual 659s ok 18 - systemd generator doesn't link cluster 659s ok 19 - /etc/init.d/postgresql start 17 659s ok 20 - correct output of /etc/init.d/postgresql start 17 659s ok 21 - pg_lsclusters -h 659s ok 22 - cluster is down 662s ok 23 - pg_ctlcluster 17 main start 662s ok 24 - correct output of pg_ctlcluster 17 main start 662s ok 25 - pg_lsclusters -h 662s ok 26 - cluster is online 662s ok 27 - pg_ctlcluster 17 main stop 662s ok 28 - correct output of pg_ctlcluster 17 main stop 662s ok 29 - pg_lsclusters -h 662s ok 30 - cluster is down 662s # start.conf disabled 662s ok 31 - get_cluster_start_conf returns disabled 662s ok 32 - systemd generator doesn't link cluster 662s ok 33 - /etc/init.d/postgresql start 17 662s ok 34 - correct output of /etc/init.d/postgresql start 17 662s ok 35 - pg_lsclusters -h 662s ok 36 - cluster is down 662s ok 37 - pg_ctlcluster 17 main start 662s ok 38 - correct output of pg_ctlcluster 17 main start 662s ok 39 - pg_lsclusters -h 662s ok 40 - cluster is down 665s ok 41 - pg_ctlcluster 17 main start 665s ok 42 - correct output of pg_ctlcluster 17 main start 665s ok 43 - pg_lsclusters -h 665s ok 44 - cluster is online 665s ok 45 - pg_ctlcluster 17 main stop 665s ok 46 - correct output of pg_ctlcluster 17 main stop 665s ok 47 - pg_lsclusters -h 665s ok 48 - cluster is down 667s ok 49 - pg_ctlcluster 17 main start 667s ok 50 - correct output of pg_ctlcluster 17 main start 667s ok 51 - pg_lsclusters -h 667s ok 52 - cluster is online 667s # test upgrade 667s ok 53 - only one major version installed, skipping upgrade test 667s ok 54 - ... 667s ok 55 - get_cluster_start_conf for old cluster returns manual 667s ok 56 - get_cluster_start_conf for new cluster returns manual 667s ok 57 - ... 669s ok 58 - dropping upgraded cluster 669s ok 59 - pg_lsclusters -h 669s ok 60 - no clusters any more 669s ok 61 - pg_createcluster 17 main --start-conf foo 669s ok 62 - pg_createcluster checks --start-conf validity 670s ok 63 - pg_createcluster checks --start-conf manual 670s ok 64 - get_cluster_start_conf returns manual 671s ok 65 - dropping cluster 671s # Cleanup 671s ok 66 - Cleanup: No clusters left behind 671s ok 67 - No postgres processes left behind 671s ok 68 - No files in /etc/postgresql left behind 671s ok 69 - No files in /var/lib/postgresql left behind 671s ok 70 - No files in /var/run/postgresql left behind 671s ok 71 - No files in /var/log/postgresql left behind 671s ok 72 - PostgreSQL TCP ports are closed 671s ok 73 - Next free port is 5432 671s ### End test 080_start.conf.t ### 671s 671s ### PostgreSQL test 085_pg_ctl.conf.t ### 671s 1..33 671s ok 1 - prlimit --core=0:unlimited --pid=16886 671s ok 2 - set core file size to unlimited 671s ok 3 - sh -c 'ulimit -Hc' 671s ok 4 - core file size is unlimited 672s ok 5 - pg_createcluster 17 main 672s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 675s ok 7 - pg_ctlcluster 17 main start 675s ok 8 - starting cluster as root 675s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 675s ok 10 - soft core size is 0 675s # hard core file size limit of root-started postgres process is unlimited 675s ok 11 - set pg_ctl default option to -c 677s ok 12 - pg_ctlcluster 17 main restart 677s ok 13 - restarting cluster as root 677s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 677s ok 15 - soft core size is unlimited 677s ok 16 - pg_ctlcluster 17 main stop 677s ok 17 - stopping cluster 677s ok 18 - restored pg_ctl default option 680s ok 19 - pg_ctlcluster 17 main start -- -c 680s ok 20 - starting cluster with -c on the command line as postgres 680s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 680s ok 22 - soft core size is unlimited 680s ok 23 - pg_ctlcluster 17 main stop 680s ok 24 - stopping cluster 681s ok 25 - dropping cluster 681s # Cleanup 681s ok 26 - Cleanup: No clusters left behind 681s ok 27 - No postgres processes left behind 681s ok 28 - No files in /etc/postgresql left behind 681s ok 29 - No files in /var/lib/postgresql left behind 681s ok 30 - No files in /var/run/postgresql left behind 681s ok 31 - No files in /var/log/postgresql left behind 681s ok 32 - PostgreSQL TCP ports are closed 681s ok 33 - Next free port is 5432 681s ### End test 085_pg_ctl.conf.t ### 681s 681s ### PostgreSQL test 090_multicluster.t ### 681s 1..125 683s ok 1 - pg_createcluster 17 old 684s ok 2 - pg_createcluster 17 new1 685s ok 3 - pg_createcluster 17 new2 687s ok 4 - starting cluster 17/old 689s ok 5 - starting cluster 17/new1 692s ok 6 - starting cluster 17/new2 692s ok 7 - pg_lsclusters -h | sort -k3 692s ok 8 - clusters have the correct ports, skipping used 5433 692s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 692s ok 10 - createdb --version 692s ok 11 - pg_wrapper selects port 5432 as default cluster 692s ok 12 - createdb --cluster 17/new1 --version 692s ok 13 - pg_wrapper --cluster works 692s ok 14 - createdb --cluster 17/foo --version 692s ok 15 - pg_wrapper --cluster errors out for invalid cluster 692s ok 16 - createdb --cluster 17/new1 test 692s ok 17 - correct output of createdb --cluster 17/new1 test 692s ok 18 - psql -Atl --cluster 17/new1 692s ok 19 - test db appears in cluster new1 692s ok 20 - psql -Atl --cluster 17/new2 692s ok 21 - test db does not appear in cluster new2 692s ok 22 - psql -Atl 692s ok 23 - test db does not appear in default cluster 692s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 692s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 692s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 692s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 692s ok 28 - psql -Atl --cluster 17/localhost:5434 692s ok 29 - test db appears in cluster 17/localhost:5434 692s ok 30 - psql -Atl --cluster 17/localhost:5440 692s ok 31 - test db does not appear in cluster 17/localhost:5440 692s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 692s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 692s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 692s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 692s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 692s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 692s ok 38 - psql -Atl --cluster 6.4/localhost: 692s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 692s ok 40 - psql -Atl 692s ok 41 - PGCLUSTER selection (1) 692s ok 42 - psql -Atl 692s ok 43 - PGCLUSTER selection (2) 692s ok 44 - psql -l 692s ok 45 - invalid PGCLUSTER value 692s ok 46 - createdb --version 692s ok 47 - PGCLUSTER network cluster selection (1) 692s ok 48 - psql -Atl 692s ok 49 - PGCLUSTER network cluster selection (2) 692s ok 50 - psql -Atl 692s ok 51 - PGCLUSTER network cluster selection (3) 692s ok 52 - LC_MESSAGES=C psql -Atl 692s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 692s ok 54 - psql -Atc "show port" template1 692s ok 55 - PGPORT selection (1) 692s ok 56 - psql -Atc "show port" template1 692s ok 57 - PGPORT selection (2) 692s ok 58 - createdb --version 692s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 692s ok 60 - psql -Atc "show port" template1 692s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 692s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 692s ok 63 - PGDATABASE environment variable works 693s ok 64 - createdb --version 693s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 693s ok 66 - createdb --cluster 17/new1 --version 693s ok 67 - pg_wrapper --cluster works with empty user_clusters 693s ok 68 - createdb --version 693s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 693s ok 70 - psql -Atc "select current_database()" 693s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 693s ok 72 - psql -Atc 'select current_database()' 693s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 693s ok 74 - createdb --version 693s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 693s ok 76 - createdb --version 693s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 693s ok 78 - createdb --version 693s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 693s ok 80 - createdb --version 693s ok 81 - pg_wrapper selects correct version with per-user user_clusters 693s ok 82 - createdb --version 693s ok 83 - pg_wrapper selects correct version with per-user user_clusters 693s ok 84 - createdb --version 693s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 693s ok 86 - psql -Atl 693s ok 87 - $PGHOST overrides user_clusters 693s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 693s ok 89 - --cluster overrides $PGHOST 693s ok 90 - createdb --version 693s ok 91 - pg_wrapper ignores invalid lines in user_clusters 693s ok 92 - psql -Atc 'select current_database()' 693s ok 93 - pg_service conf selection 1 693s ok 94 - psql -Atc 'select current_database()' 693s ok 95 - pg_service conf selection 2 693s ok 96 - psql -Atc 'select current_database()' 693s ok 97 - pg_service conf selection 3 693s ok 98 - stopping cluster 17/old 696s ok 99 - restarting cluster 17/old 696s ok 100 - pg_lsclusters -h | sort -k3 696s ok 101 - port of first cluster was successfully changed 696s ok 102 - psql -l 696s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 696s ok 104 - psql -Atl --cluster 17/new1 696s ok 105 - --cluster selects appropriate cluster 696s ok 106 - psql -Atl -p 5434 696s ok 107 - -p selects appropriate cluster 696s ok 108 - psql -Atlp 5434 696s ok 109 - -Atlp selects appropriate cluster 696s ok 110 - psql -Atl --port 5434 696s ok 111 - --port selects appropriate cluster 696s ok 112 - env PGPORT=5434 psql -Atl 696s ok 113 - $PGPORT selects appropriate cluster 696s ok 114 - Restoring original /etc/postgresql-common/user_clusters 698s ok 115 - dropping 17/new1 700s ok 116 - dropping 17/new2 702s ok 117 - dropping 17/old 702s # Cleanup 702s ok 118 - Cleanup: No clusters left behind 702s ok 119 - No postgres processes left behind 702s ok 120 - No files in /etc/postgresql left behind 702s ok 121 - No files in /var/lib/postgresql left behind 702s ok 122 - No files in /var/run/postgresql left behind 702s ok 123 - No files in /var/log/postgresql left behind 702s ok 124 - PostgreSQL TCP ports are closed 702s ok 125 - Next free port is 5432 702s ### End test 090_multicluster.t ### 702s 702s ### PostgreSQL test 110_integrate_cluster.t ### 702s 1..32 703s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/htKmA7nz5A/c/postgres 703s ok 2 - creating raw initdb cluster for user postgres 703s ok 3 - pg_createcluster 17 postgres -d /tmp/htKmA7nz5A/c/postgres 703s ok 4 - integrating postgres cluster 703s ok 5 - pg_lsclusters 703s ok 6 - correct pg_lsclusters output 706s ok 7 - pg_ctlcluster 17 postgres start 706s ok 8 - starting cluster postgres 706s ok 9 - pg_lsclusters 706s ok 10 - correct pg_lsclusters output 708s ok 11 - dropping cluster postgres 708s ok 12 - No files in temporary cluster dir left behind 709s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/htKmA7nz5A/c/nobody 709s ok 14 - creating raw initdb cluster for user nobody 709s ok 15 - pg_createcluster 17 nobody -d /tmp/htKmA7nz5A/c/nobody 709s ok 16 - integrating nobody cluster 709s ok 17 - pg_lsclusters 709s ok 18 - correct pg_lsclusters output 711s ok 19 - pg_ctlcluster 17 nobody start 711s ok 20 - starting cluster nobody 711s ok 21 - pg_lsclusters 711s ok 22 - correct pg_lsclusters output 713s ok 23 - dropping cluster nobody 713s ok 24 - No files in temporary cluster dir left behind 713s # Cleanup 713s ok 25 - Cleanup: No clusters left behind 713s ok 26 - No postgres processes left behind 713s ok 27 - No files in /etc/postgresql left behind 713s ok 28 - No files in /var/lib/postgresql left behind 713s ok 29 - No files in /var/run/postgresql left behind 713s ok 30 - No files in /var/log/postgresql left behind 713s ok 31 - PostgreSQL TCP ports are closed 713s ok 32 - Next free port is 5432 713s ### End test 110_integrate_cluster.t ### 713s 713s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 713s 1..1 713s ok 1 - only one major version installed, skipping upgrade tests 713s ### End test 120_pg_upgradecluster_scripts.t ### 713s 713s ### PostgreSQL test 130_nonroot_admin.t ### 713s 1..22 717s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 717s ok 2 - pg_lsclusters -h 717s ok 3 - correct output of pg_lsclusters -h 717s ok 4 - psql -Atl 717s ok 5 - correct output of psql -Atl 717s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 717s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 717s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 717s # Cleanup 717s ok 15 - Cleanup: No clusters left behind 717s ok 16 - No postgres processes left behind 717s ok 17 - No files in /etc/postgresql left behind 717s ok 18 - No files in /var/lib/postgresql left behind 717s ok 19 - No files in /var/run/postgresql left behind 717s ok 20 - No files in /var/log/postgresql left behind 717s ok 21 - PostgreSQL TCP ports are closed 717s ok 22 - Next free port is 5432 717s ### End test 130_nonroot_admin.t ### 717s 717s ### PostgreSQL test 135_pg_virtualenv.t ### 717s 1..20 722s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 722s ok 2 - running pg_virtualenv as root 726s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 726s ok 4 - running pg_virtualenv as postgres 729s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 729s ok 6 - running pg_virtualenv as nobody 733s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 733s ok 8 - running fakeroot pg_virtualenv as root 736s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 736s ok 10 - running fakeroot pg_virtualenv as postgres 739s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 739s ok 12 - running fakeroot pg_virtualenv as nobody 739s # Cleanup 739s ok 13 - Cleanup: No clusters left behind 739s ok 14 - No postgres processes left behind 739s ok 15 - No files in /etc/postgresql left behind 739s ok 16 - No files in /var/lib/postgresql left behind 739s ok 17 - No files in /var/run/postgresql left behind 739s ok 18 - No files in /var/log/postgresql left behind 739s ok 19 - PostgreSQL TCP ports are closed 739s ok 20 - Next free port is 5432 739s ### End test 135_pg_virtualenv.t ### 739s 739s ### PostgreSQL test 140_pg_config.t ### 740s 1..38 740s # Multiarch is enabled 740s # checking version specific output for 17 740s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 740s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 740s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 740s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 740s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 740s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 740s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 740s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 740s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 740s # checking pg_config output (should behave like version 17) 740s ok 15 - pg_config 740s ok 16 - correct output of pg_config 740s ok 17 - pg_config --help 740s ok 18 - correct output of pg_config --help 740s ok 19 - pg_config --pgxs 740s ok 20 - correct output of pg_config --pgxs 740s ok 21 - pg_config --libdir 740s ok 22 - correct output of pg_config --libdir 740s ok 23 - pg_config --pkglibdir 740s ok 24 - correct output of pg_config --pkglibdir 740s ok 25 - pg_config --bindir 740s ok 26 - correct output of pg_config --bindir 740s # checking pg_config.libpq-dev output (should behave like version 17) 740s ok 27 - pg_config.libpq-dev 740s ok 28 - correct output of pg_config.libpq-dev 740s ok 29 - pg_config.libpq-dev --help 740s ok 30 - correct output of pg_config.libpq-dev --help 740s ok 31 - pg_config.libpq-dev --pgxs 740s ok 32 - correct output of pg_config.libpq-dev --pgxs 740s ok 33 - pg_config.libpq-dev --libdir 740s ok 34 - correct output of pg_config.libpq-dev --libdir 740s ok 35 - pg_config.libpq-dev --pkglibdir 740s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 740s ok 37 - pg_config.libpq-dev --bindir 740s ok 38 - correct output of pg_config.libpq-dev --bindir 740s ### End test 140_pg_config.t ### 740s 740s ### PostgreSQL test 150_tsearch_stemming.t ### 740s 1..37 740s ok 1 - pg_updatedicts succeeded 740s ok 2 - pg_updatedicts created en_us.affix 740s ok 3 - pg_updatedicts created en_us.dict 740s ok 4 - pg_updatedicts created 17 en_us.affix symlink 740s ok 5 - pg_updatedicts created 17 en_us.dict symlink 743s ok 6 - pg_createcluster 17 main 743s ok 7 - createdb fts 743s ok 8 - correct output of createdb fts 743s ok 9 - creating en_US full text search configuration 744s ok 10 - creating data table and search index 744s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 744s ok 12 - stem search of correct word 744s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 744s ok 14 - stem search of correct word 744s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 744s ok 16 - stem search of unknown word 744s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 744s ok 18 - full text search, exact word 744s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 744s ok 20 - full text search for word stem 744s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 744s ok 22 - full text search for word substring fails 744s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 744s ok 24 - full text search, exact unicode word 744s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 744s ok 26 - full text search for unicode word stem 744s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 744s ok 28 - full text search for unicode word substring fails 746s ok 29 746s # Cleanup 746s ok 30 - Cleanup: No clusters left behind 746s ok 31 - No postgres processes left behind 746s ok 32 - No files in /etc/postgresql left behind 746s ok 33 - No files in /var/lib/postgresql left behind 746s ok 34 - No files in /var/run/postgresql left behind 746s ok 35 - No files in /var/log/postgresql left behind 746s ok 36 - PostgreSQL TCP ports are closed 746s ok 37 - Next free port is 5432 746s ### End test 150_tsearch_stemming.t ### 746s 746s ### PostgreSQL test 160_alternate_confroot.t ### 746s 1..28 751s ok 1 751s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 751s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 751s ok 4 - pg_lsclusters -h 751s ok 5 - correct output of pg_lsclusters -h 751s ok 6 - psql -Atl 751s ok 7 - correct output of psql -Atl 751s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 751s ok 9 - ... 751s ok 10 - ... 751s ok 11 - ... 751s ok 12 - ... 751s ok 13 - ... 751s ok 14 - ... 751s ok 15 - pg_dropcluster 17 test --stop 751s ok 16 - correct output of pg_dropcluster 17 test --stop 751s ok 17 - pg_lsclusters -h 751s ok 18 - correct output of pg_lsclusters -h 751s ok 19 - No files in root/data left behind 751s ok 20 - No cruft in root dir left behind 751s # Cleanup 751s ok 21 - Cleanup: No clusters left behind 751s ok 22 - No postgres processes left behind 751s ok 23 - No files in /etc/postgresql left behind 751s ok 24 - No files in /var/lib/postgresql left behind 751s ok 25 - No files in /var/run/postgresql left behind 751s ok 26 - No files in /var/log/postgresql left behind 751s ok 27 - PostgreSQL TCP ports are closed 751s ok 28 - Next free port is 5432 751s ### End test 160_alternate_confroot.t ### 751s 751s ### PostgreSQL test 170_extensions.t ### 751s # Running tests for 17 755s ok 1 - pg_createcluster 17 main 755s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 755s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 756s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 756s ok 5 - extension amcheck installs without error 756s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 756s ok 7 - extension amcheck removes without error 756s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 756s ok 9 - extension autoinc installs without error 756s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 756s ok 11 - extension autoinc removes without error 756s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 756s ok 13 - extension bloom installs without error 756s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 756s ok 15 - extension bloom removes without error 756s ok 16 - psql -qc 'CREATE EXTENSION plperl' 756s ok 17 - bool_plperl dependency plperl installs without error 756s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 756s ok 19 - extension bool_plperl installs without error 756s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 756s ok 21 - extension bool_plperl removes without error 756s ok 22 - psql -qc 'DROP EXTENSION plperl' 756s ok 23 - bool_plperl dependency extension plperl removes without error 756s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 756s ok 25 - bool_plperlu dependency plperlu installs without error 756s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 756s ok 27 - extension bool_plperlu installs without error 756s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 756s ok 29 - extension bool_plperlu removes without error 756s ok 30 - psql -qc 'DROP EXTENSION plperlu' 756s ok 31 - bool_plperlu dependency extension plperlu removes without error 756s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 756s ok 33 - extension btree_gin installs without error 757s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 757s ok 35 - extension btree_gin removes without error 757s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 757s ok 37 - extension btree_gist installs without error 757s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 757s ok 39 - extension btree_gist removes without error 757s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 757s ok 41 - extension citext installs without error 757s ok 42 - psql -qc 'DROP EXTENSION "citext"' 757s ok 43 - extension citext removes without error 757s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 757s ok 45 - extension cube installs without error 757s ok 46 - psql -qc 'DROP EXTENSION "cube"' 757s ok 47 - extension cube removes without error 757s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 757s ok 49 - extension dblink installs without error 757s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 757s ok 51 - extension dblink removes without error 758s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 758s ok 53 - extension dict_int installs without error 758s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 758s ok 55 - extension dict_int removes without error 758s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 758s ok 57 - extension dict_xsyn installs without error 758s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 758s ok 59 - extension dict_xsyn removes without error 758s ok 60 - psql -qc 'CREATE EXTENSION cube' 758s ok 61 - earthdistance dependency cube installs without error 758s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 758s ok 63 - extension earthdistance installs without error 758s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 758s ok 65 - extension earthdistance removes without error 758s ok 66 - psql -qc 'DROP EXTENSION cube' 758s ok 67 - earthdistance dependency extension cube removes without error 758s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 758s ok 69 - extension file_fdw installs without error 758s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 758s ok 71 - extension file_fdw removes without error 758s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 758s ok 73 - extension fuzzystrmatch installs without error 758s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 758s ok 75 - extension fuzzystrmatch removes without error 758s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 758s ok 77 - extension hstore installs without error 758s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 758s ok 79 - extension hstore removes without error 759s ok 80 - psql -qc 'CREATE EXTENSION hstore' 759s ok 81 - hstore_plperl dependency hstore installs without error 759s ok 82 - psql -qc 'CREATE EXTENSION plperl' 759s ok 83 - hstore_plperl dependency plperl installs without error 759s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 759s ok 85 - extension hstore_plperl installs without error 759s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 759s ok 87 - extension hstore_plperl removes without error 759s ok 88 - psql -qc 'DROP EXTENSION hstore' 759s ok 89 - hstore_plperl dependency extension hstore removes without error 759s ok 90 - psql -qc 'DROP EXTENSION plperl' 759s ok 91 - hstore_plperl dependency extension plperl removes without error 759s ok 92 - psql -qc 'CREATE EXTENSION hstore' 759s ok 93 - hstore_plperlu dependency hstore installs without error 759s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 759s ok 95 - hstore_plperlu dependency plperlu installs without error 759s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 759s ok 97 - extension hstore_plperlu installs without error 759s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 759s ok 99 - extension hstore_plperlu removes without error 759s ok 100 - psql -qc 'DROP EXTENSION hstore' 759s ok 101 - hstore_plperlu dependency extension hstore removes without error 760s ok 102 - psql -qc 'DROP EXTENSION plperlu' 760s ok 103 - hstore_plperlu dependency extension plperlu removes without error 760s ok 104 - psql -qc 'CREATE EXTENSION hstore' 760s ok 105 - hstore_plpython3u dependency hstore installs without error 760s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 760s ok 107 - hstore_plpython3u dependency plpython3u installs without error 760s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 760s ok 109 - extension hstore_plpython3u installs without error 760s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 760s ok 111 - extension hstore_plpython3u removes without error 760s ok 112 - psql -qc 'DROP EXTENSION hstore' 760s ok 113 - hstore_plpython3u dependency extension hstore removes without error 760s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 760s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 760s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 760s ok 117 - extension insert_username installs without error 760s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 760s ok 119 - extension insert_username removes without error 760s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 760s ok 121 - extension intagg installs without error 760s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 760s ok 123 - extension intagg removes without error 760s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 760s ok 125 - extension intarray installs without error 760s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 760s ok 127 - extension intarray removes without error 760s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 760s ok 129 - extension isn installs without error 760s ok 130 - psql -qc 'DROP EXTENSION "isn"' 760s ok 131 - extension isn removes without error 761s ok 132 - psql -qc 'CREATE EXTENSION plperl' 761s ok 133 - jsonb_plperl dependency plperl installs without error 761s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 761s ok 135 - extension jsonb_plperl installs without error 761s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 761s ok 137 - extension jsonb_plperl removes without error 761s ok 138 - psql -qc 'DROP EXTENSION plperl' 761s ok 139 - jsonb_plperl dependency extension plperl removes without error 761s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 761s ok 141 - jsonb_plperlu dependency plperlu installs without error 761s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 761s ok 143 - extension jsonb_plperlu installs without error 761s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 761s ok 145 - extension jsonb_plperlu removes without error 761s ok 146 - psql -qc 'DROP EXTENSION plperlu' 761s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 761s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 761s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 761s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 761s ok 151 - extension jsonb_plpython3u installs without error 761s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 761s ok 153 - extension jsonb_plpython3u removes without error 761s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 761s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 761s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 761s ok 157 - extension lo installs without error 761s ok 158 - psql -qc 'DROP EXTENSION "lo"' 761s ok 159 - extension lo removes without error 761s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 761s ok 161 - extension ltree installs without error 761s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 761s ok 163 - extension ltree removes without error 761s ok 164 - psql -qc 'CREATE EXTENSION ltree' 761s ok 165 - ltree_plpython3u dependency ltree installs without error 761s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 761s ok 167 - ltree_plpython3u dependency plpython3u installs without error 761s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 761s ok 169 - extension ltree_plpython3u installs without error 761s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 761s ok 171 - extension ltree_plpython3u removes without error 761s ok 172 - psql -qc 'DROP EXTENSION ltree' 761s ok 173 - ltree_plpython3u dependency extension ltree removes without error 761s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 761s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 762s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 762s ok 177 - extension moddatetime installs without error 762s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 762s ok 179 - extension moddatetime removes without error 762s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 762s ok 181 - extension pageinspect installs without error 762s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 762s ok 183 - extension pageinspect removes without error 762s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 762s ok 185 - extension pg_buffercache installs without error 762s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 762s ok 187 - extension pg_buffercache removes without error 762s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 762s ok 189 - extension pg_freespacemap installs without error 762s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 762s ok 191 - extension pg_freespacemap removes without error 762s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 762s ok 193 - extension pg_prewarm installs without error 762s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 762s ok 195 - extension pg_prewarm removes without error 762s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 762s ok 197 - extension pg_stat_statements installs without error 762s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 762s ok 199 - extension pg_stat_statements removes without error 762s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 762s ok 201 - extension pg_surgery installs without error 762s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 762s ok 203 - extension pg_surgery removes without error 762s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 762s ok 205 - extension pg_trgm installs without error 762s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 762s ok 207 - extension pg_trgm removes without error 762s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 762s ok 209 - extension pg_visibility installs without error 763s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 763s ok 211 - extension pg_visibility removes without error 763s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 763s ok 213 - extension pg_walinspect installs without error 763s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 763s ok 215 - extension pg_walinspect removes without error 763s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 763s ok 217 - extension pgcrypto installs without error 763s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 763s ok 219 - extension pgcrypto removes without error 763s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 763s ok 221 - extension pgrowlocks installs without error 763s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 763s ok 223 - extension pgrowlocks removes without error 763s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 763s ok 225 - extension pgstattuple installs without error 763s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 763s ok 227 - extension pgstattuple removes without error 763s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 763s ok 229 - extension plperl installs without error 763s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 763s ok 231 - extension plperl removes without error 763s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 763s ok 233 - extension plperlu installs without error 763s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 763s ok 235 - extension plperlu removes without error 763s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 763s ok 237 - extension plpython3u installs without error 763s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 763s ok 239 - extension plpython3u removes without error 763s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 763s ok 241 - extension pltcl installs without error 763s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 763s ok 243 - extension pltcl removes without error 764s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 764s ok 245 - extension pltclu installs without error 764s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 764s ok 247 - extension pltclu removes without error 764s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 764s ok 249 - extension postgres_fdw installs without error 764s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 764s ok 251 - extension postgres_fdw removes without error 764s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 764s ok 253 - extension refint installs without error 764s ok 254 - psql -qc 'DROP EXTENSION "refint"' 764s ok 255 - extension refint removes without error 764s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 764s ok 257 - extension seg installs without error 764s ok 258 - psql -qc 'DROP EXTENSION "seg"' 764s ok 259 - extension seg removes without error 764s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 764s ok 261 - extension sslinfo installs without error 764s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 764s ok 263 - extension sslinfo removes without error 764s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 764s ok 265 - extension tablefunc installs without error 764s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 764s ok 267 - extension tablefunc removes without error 764s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 764s ok 269 - extension tcn installs without error 764s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 764s ok 271 - extension tcn removes without error 764s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 764s ok 273 - extension tsm_system_rows installs without error 764s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 764s ok 275 - extension tsm_system_rows removes without error 764s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 764s ok 277 - extension tsm_system_time installs without error 764s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 764s ok 279 - extension tsm_system_time removes without error 764s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 764s ok 281 - extension unaccent installs without error 764s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 764s ok 283 - extension unaccent removes without error 764s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 764s ok 285 - extension uuid-ossp installs without error 764s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 764s ok 287 - extension uuid-ossp removes without error 764s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 764s ok 289 - extension xml2 installs without error 764s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 764s ok 291 - extension xml2 removes without error 766s ok 292 - pg_dropcluster 17 main 766s # Cleanup 766s ok 293 - Cleanup: No clusters left behind 766s ok 294 - No postgres processes left behind 766s ok 295 - No files in /etc/postgresql left behind 766s ok 296 - No files in /var/lib/postgresql left behind 766s ok 297 - No files in /var/run/postgresql left behind 766s ok 298 - No files in /var/log/postgresql left behind 766s ok 299 - PostgreSQL TCP ports are closed 766s ok 300 - Next free port is 5432 766s 1..300 766s ### End test 170_extensions.t ### 766s 766s ### PostgreSQL test 180_ecpg.t ### 766s 1..14 766s ok 1 - ecpg test.pgc 766s ok 2 - ecpg processing 767s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 767s ok 4 - compiling ecpg output 775s ok 5 - pg_virtualenv /tmp/tmp.ay8PYpuOue/test 775s ok 6 - test program runs and gives correct output 775s # Cleanup 775s ok 7 - Cleanup: No clusters left behind 775s ok 8 - No postgres processes left behind 775s ok 9 - No files in /etc/postgresql left behind 775s ok 10 - No files in /var/lib/postgresql left behind 775s ok 11 - No files in /var/run/postgresql left behind 775s ok 12 - No files in /var/log/postgresql left behind 775s ok 13 - PostgreSQL TCP ports are closed 775s ok 14 - Next free port is 5432 775s ### End test 180_ecpg.t ### 775s 775s ### PostgreSQL test 190_pg_buildext.t ### 775s ok 1 - make clean 775s ok 2 - make tar 776s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 776s # testing 'dh --with pgxs' 782s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 782s ok 5 - postgresql-17-foo_123-1_s390x.deb was built 790s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 790s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 791s ok 8 - dpkg -i postgresql-17-foo_123-1_s390x.deb 798s ok 9 - cd foo-123 && pg_buildext installcheck 798s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 806s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 806s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 815s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 815s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 815s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 815s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 816s ok 17 - dpkg -r postgresql-17-foo 816s # testing 'dh --with pgxs_loop' 816s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 819s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 819s ok 20 - postgresql-17-foo_123-1_s390x.deb was built 819s ok 21 - make clean 819s # testing pg_buildext updatecontrol 820s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 820s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 820s 1..23 820s ### End test 190_pg_buildext.t ### 820s 820s ### PostgreSQL test 200_maintscripts.t ### 820s 1..15 820s # We are running systemd 824s ok 1 - pg_createcluster 17 main --start 824s ok 2 - postmaster PID is 23451 826s ok 3 - apt-get update -q 826s # postgresql-common: 826s # Installed: 267 826s # Candidate: 267 826s # Version table: 826s # *** 267 500 826s # 500 http://ftpmaster.internal/ubuntu plucky/main s390x Packages 826s # 100 /var/lib/dpkg/status 833s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 833s # postgresql-common: 833s # Installed: 267 833s # Candidate: 267 833s # Version table: 833s # *** 267 500 833s # 500 http://ftpmaster.internal/ubuntu plucky/main s390x Packages 833s # 100 /var/lib/dpkg/status 833s ok 5 - postmaster PID is 23451 833s ok 6 - postmaster was not restarted 835s ok 7 - pg_dropcluster 17 main --stop 835s # Cleanup 835s ok 8 - Cleanup: No clusters left behind 835s ok 9 - No postgres processes left behind 835s ok 10 - No files in /etc/postgresql left behind 835s ok 11 - No files in /var/lib/postgresql left behind 835s ok 12 - No files in /var/run/postgresql left behind 835s ok 13 - No files in /var/log/postgresql left behind 835s ok 14 - PostgreSQL TCP ports are closed 835s ok 15 - Next free port is 5432 835s ### End test 200_maintscripts.t ### 835s 836s autopkgtest [14:49:49]: test run-testsuite: -----------------------] 837s run-testsuite PASS 837s autopkgtest [14:49:50]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 837s autopkgtest [14:49:50]: @@@@@@@@@@@@@@@@@@@@ summary 837s default-psql PASS 837s run-testsuite PASS 855s nova [W] Using flock in prodstack6-s390x 855s Creating nova instance adt-plucky-s390x-postgresql-common-20250116-143552-juju-7f2275-prod-proposed-migration-environment-2-6e136686-7d78-4cf5-a389-f38e47748946 from image adt/ubuntu-plucky-s390x-server-20250116.img (UUID e981a3af-6e9f-4d05-be37-4d186896cb71)... 855s nova [W] Timed out waiting for eb7b166a-2b6e-4c17-838a-b432174647bf to get deleted. 855s nova [W] Using flock in prodstack6-s390x 855s Creating nova instance adt-plucky-s390x-postgresql-common-20250116-143552-juju-7f2275-prod-proposed-migration-environment-2-6e136686-7d78-4cf5-a389-f38e47748946 from image adt/ubuntu-plucky-s390x-server-20250116.img (UUID e981a3af-6e9f-4d05-be37-4d186896cb71)... 855s nova [W] Timed out waiting for ebb2d384-5778-45c3-ad99-771b070e96fd to get deleted.