0s autopkgtest [11:45:07]: starting date and time: 2025-01-16 11:45:07+0000 0s autopkgtest [11:45:07]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [11:45:07]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.hezalceo/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-arm64-4.secgroup --name adt-plucky-arm64-postgresql-common-20250116-114507-juju-7f2275-prod-proposed-migration-environment-2-739e2083-0137-40e4-975c-3f999c6f39cc --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 123s autopkgtest [11:47:10]: testbed dpkg architecture: arm64 123s autopkgtest [11:47:10]: testbed apt version: 2.9.18 124s autopkgtest [11:47:11]: @@@@@@@@@@@@@@@@@@@@ test bed setup 124s autopkgtest [11:47:11]: testbed release detected to be: None 126s autopkgtest [11:47:13]: updating testbed package index (apt update) 126s 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/multiverse Sources [14.7 kB] 126s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [904 kB] 127s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [160 kB] 127s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 127s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [303 kB] 127s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 127s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [1080 kB] 127s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [10.5 kB] 127s Fetched 2613 kB in 1s (2617 kB/s) 128s Reading package lists... 128s + lsb_release --codename --short 128s + RELEASE=plucky 128s + cat 128s + [ plucky != trusty ] 128s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 128s Reading package lists... 129s Building dependency tree... 129s Reading state information... 129s Calculating upgrade... 129s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 129s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 129s + /usr/lib/apt/apt-helper analyze-pattern ?true 130s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove ?obsolete 130s Reading package lists... 130s Building dependency tree... 130s Reading state information... 130s + grep -q trusty /etc/lsb-release 130s + [ ! -d /usr/share/doc/unattended-upgrades ] 130s + [ ! -d /usr/share/doc/lxd ] 130s + [ ! -d /usr/share/doc/lxd-client ] 130s + [ ! -d /usr/share/doc/snapd ] 130s + type iptables 130s + cat 130s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 130s + chmod 755 /etc/rc.local 130s + . /etc/rc.local 130s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 130s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 130s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 130s + uname -m 130s + [ aarch64 = ppc64le ] 130s + [ -d /run/systemd/system ] 130s + systemd-detect-virt --quiet --vm 130s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 130s + cat 130s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 130s + echo COMPRESS=lz4 130s + sync 131s autopkgtest [11:47:18]: upgrading testbed (apt dist-upgrade and autopurge) 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 132s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 132s Starting 2 pkgProblemResolver with broken count: 0 132s Done 132s Entering ResolveByKeep 133s 133s The following packages will be upgraded: 133s ucf 133s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s Need to get 42.8 kB of archives. 133s After this operation, 0 B of additional disk space will be used. 133s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 ucf all 3.0048 [42.8 kB] 134s Preconfiguring packages ... 134s Fetched 42.8 kB in 0s (148 kB/s) 135s (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 ... 80205 files and directories currently installed.) 135s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 135s Unpacking ucf (3.0048) over (3.0046) ... 135s Setting up ucf (3.0048) ... 135s Processing triggers for man-db (2.13.0-1) ... 136s Reading package lists... 136s Building dependency tree... 136s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 137s Starting 2 pkgProblemResolver with broken count: 0 138s Done 139s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 142s autopkgtest [11:47:29]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 142s autopkgtest [11:47:29]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 148s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (dsc) [2383 B] 148s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (tar) [219 kB] 148s gpgv: Signature made Thu Nov 21 11:03:28 2024 UTC 148s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 148s gpgv: Can't check signature: No public key 148s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_267.dsc: no acceptable signature found 148s autopkgtest [11:47:35]: testing package postgresql-common version 267 149s autopkgtest [11:47:36]: build not needed 149s autopkgtest [11:47:36]: test default-psql: preparing testbed 149s Reading package lists... 150s Building dependency tree... 150s Reading state information... 150s Starting pkgProblemResolver with broken count: 0 151s Starting 2 pkgProblemResolver with broken count: 0 151s Done 152s The following NEW packages will be installed: 152s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 152s postgresql-17 postgresql-client-17 postgresql-client-common 152s postgresql-common ssl-cert 152s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 152s Need to get 17.6 MB of archives. 152s After this operation, 57.4 MB of additional disk space will be used. 152s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 152s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 152s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 152s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 267 [37.1 kB] 152s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 152s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 267 [162 kB] 152s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.2-1 [141 kB] 152s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 152s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.2-1 [1318 kB] 152s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.2-1 [15.5 MB] 153s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql all 17+267 [12.2 kB] 153s Preconfiguring packages ... 153s Fetched 17.6 MB in 1s (17.1 MB/s) 153s Selecting previously unselected package libjson-perl. 153s (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 ... 80205 files and directories currently installed.) 153s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 153s Unpacking libjson-perl (4.10000-1) ... 153s Selecting previously unselected package libio-pty-perl. 153s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 153s Unpacking libio-pty-perl (1:1.20-1build3) ... 153s Selecting previously unselected package libipc-run-perl. 153s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 153s Unpacking libipc-run-perl (20231003.0-2) ... 153s Selecting previously unselected package postgresql-client-common. 153s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 153s Unpacking postgresql-client-common (267) ... 153s Selecting previously unselected package ssl-cert. 153s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 153s Unpacking ssl-cert (1.1.3ubuntu1) ... 153s Selecting previously unselected package postgresql-common. 153s Preparing to unpack .../05-postgresql-common_267_all.deb ... 153s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 153s Unpacking postgresql-common (267) ... 154s Selecting previously unselected package libpq5:arm64. 154s Preparing to unpack .../06-libpq5_17.2-1_arm64.deb ... 154s Unpacking libpq5:arm64 (17.2-1) ... 154s Selecting previously unselected package libxslt1.1:arm64. 154s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 154s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 154s Selecting previously unselected package postgresql-client-17. 154s Preparing to unpack .../08-postgresql-client-17_17.2-1_arm64.deb ... 154s Unpacking postgresql-client-17 (17.2-1) ... 154s Selecting previously unselected package postgresql-17. 154s Preparing to unpack .../09-postgresql-17_17.2-1_arm64.deb ... 154s Unpacking postgresql-17 (17.2-1) ... 154s Selecting previously unselected package postgresql. 154s Preparing to unpack .../10-postgresql_17+267_all.deb ... 154s Unpacking postgresql (17+267) ... 154s Setting up libio-pty-perl (1:1.20-1build3) ... 154s Setting up libpq5:arm64 (17.2-1) ... 154s Setting up ssl-cert (1.1.3ubuntu1) ... 155s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 155s Setting up libipc-run-perl (20231003.0-2) ... 155s Setting up libjson-perl (4.10000-1) ... 155s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 155s Setting up postgresql-client-common (267) ... 155s Setting up postgresql-client-17 (17.2-1) ... 155s 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 155s Setting up postgresql-common (267) ... 156s Creating config file /etc/postgresql-common/createcluster.conf with new version 156s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 156s Removing obsolete dictionary files: 156s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 157s Setting up postgresql-17 (17.2-1) ... 157s Creating new PostgreSQL cluster 17/main ... 157s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 157s The files belonging to this database system will be owned by user "postgres". 157s This user must also own the server process. 157s 157s The database cluster will be initialized with locale "C.UTF-8". 157s The default database encoding has accordingly been set to "UTF8". 157s The default text search configuration will be set to "english". 157s 157s Data page checksums are disabled. 157s 157s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 157s creating subdirectories ... ok 157s selecting dynamic shared memory implementation ... posix 157s selecting default "max_connections" ... 100 157s selecting default "shared_buffers" ... 128MB 157s selecting default time zone ... Etc/UTC 157s creating configuration files ... ok 157s running bootstrap script ... ok 158s performing post-bootstrap initialization ... ok 158s syncing data to disk ... ok 161s Setting up postgresql (17+267) ... 161s Processing triggers for man-db (2.13.0-1) ... 162s Processing triggers for libc-bin (2.40-4ubuntu1) ... 163s autopkgtest [11:47:50]: test default-psql: [----------------------- 164s autopkgtest [11:47:51]: test default-psql: -----------------------] 165s default-psql PASS 165s autopkgtest [11:47:52]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 165s autopkgtest [11:47:52]: test run-testsuite: preparing testbed 319s autopkgtest [11:50:26]: testbed dpkg architecture: arm64 319s autopkgtest [11:50:26]: testbed apt version: 2.9.18 319s autopkgtest [11:50:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 320s autopkgtest [11:50:27]: testbed release detected to be: plucky 320s autopkgtest [11:50:27]: updating testbed package index (apt update) 321s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 321s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 321s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 321s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 321s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [904 kB] 321s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 321s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.7 kB] 321s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [160 kB] 321s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [303 kB] 321s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 321s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [1080 kB] 321s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [10.5 kB] 322s Fetched 2613 kB in 1s (2651 kB/s) 323s Reading package lists... 323s + lsb_release --codename --short 323s + RELEASE=plucky 323s + cat 323s + [ plucky != trusty ] 323s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 323s Reading package lists... 323s Building dependency tree... 323s Reading state information... 324s Calculating upgrade... 324s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 324s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 324s + /usr/lib/apt/apt-helper analyze-pattern ?true 324s Reading package lists...+ DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove ?obsolete 324s 325s Building dependency tree... 325s Reading state information... 325s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 325s + grep -q trusty /etc/lsb-release 325s + [ ! -d /usr/share/doc/unattended-upgrades ] 325s + [ ! -d /usr/share/doc/lxd ] 325s + [ ! -d /usr/share/doc/lxd-client ] 325s + [ ! -d /usr/share/doc/snapd ] 325s + type iptables 325s + cat 325s + chmod 755 /etc/rc.local 325s + . /etc/rc.local 325s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 325s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 325s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 325s + uname -m 325s + [ aarch64 = ppc64le ] 325s + [ -d /run/systemd/system ] 325s + systemd-detect-virt --quiet --vm 325s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 325s + cat 325s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 325s + echo COMPRESS=lz4 325s + sync 326s autopkgtest [11:50:33]: upgrading testbed (apt dist-upgrade and autopurge) 326s Reading package lists... 326s Building dependency tree... 326s Reading state information... 327s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 327s Starting 2 pkgProblemResolver with broken count: 0 327s Done 328s Entering ResolveByKeep 328s 328s The following packages will be upgraded: 328s ucf 329s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 329s Need to get 42.8 kB of archives. 329s After this operation, 0 B of additional disk space will be used. 329s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 ucf all 3.0048 [42.8 kB] 329s Preconfiguring packages ... 329s Fetched 42.8 kB in 0s (151 kB/s) 329s (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 ... 80205 files and directories currently installed.) 329s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 329s Unpacking ucf (3.0048) over (3.0046) ... 329s Setting up ucf (3.0048) ... 329s Processing triggers for man-db (2.13.0-1) ... 331s Reading package lists... 331s Building dependency tree... 331s Reading state information... 331s Starting pkgProblemResolver with broken count: 0 331s Starting 2 pkgProblemResolver with broken count: 0 331s Done 332s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 336s Reading package lists... 337s Building dependency tree... 337s Reading state information... 337s Starting pkgProblemResolver with broken count: 0 337s Starting 2 pkgProblemResolver with broken count: 0 337s Done 338s The following NEW packages will be installed: 338s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 338s cpp-14 cpp-14-aarch64-linux-gnu cpp-aarch64-linux-gnu debhelper debugedit 338s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 338s fakeroot g++ g++-14 g++-14-aarch64-linux-gnu g++-aarch64-linux-gnu gcc 338s gcc-14 gcc-14-aarch64-linux-gnu gcc-aarch64-linux-gnu gettext hunspell-en-us 338s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-19-dev 338s libclang-cpp19 libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 338s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev 338s libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 libitm1 338s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 338s libpgtypes3 libpq-dev libpq5 libssl-dev libstdc++-14-dev libtcl8.6 libtool 338s libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-19 llvm-19-dev 338s llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all m4 po-debconf 338s postgresql-17 postgresql-all postgresql-client-17 postgresql-client-common 338s postgresql-common postgresql-doc postgresql-doc-17 postgresql-plperl-17 338s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 338s postgresql-server-dev-all ssl-cert 338s 0 upgraded, 88 newly installed, 0 to remove and 0 not upgraded. 338s Need to get 183 MB of archives. 338s After this operation, 1095 MB of additional disk space will be used. 338s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 338s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 338s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 338s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 267 [37.1 kB] 338s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 338s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 267 [162 kB] 338s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 m4 arm64 1.4.19-4build1 [240 kB] 338s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 autoconf all 2.72-3 [382 kB] 338s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 autotools-dev all 20220109.1 [44.9 kB] 338s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 338s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 autopoint all 0.22.5-3 [616 kB] 338s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 libisl23 arm64 0.27-1 [676 kB] 338s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libmpc3 arm64 1.3.1-1build2 [56.8 kB] 338s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [10.6 MB] 339s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-14 arm64 14.2.0-12ubuntu1 [1032 B] 339s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [5452 B] 339s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 cpp arm64 4:14.1.0-2ubuntu1 [22.5 kB] 339s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 libcc1-0 arm64 14.2.0-12ubuntu1 [49.6 kB] 339s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libgomp1 arm64 14.2.0-12ubuntu1 [145 kB] 339s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 libitm1 arm64 14.2.0-12ubuntu1 [27.7 kB] 339s Get:21 http://ftpmaster.internal/ubuntu plucky/main arm64 libasan8 arm64 14.2.0-12ubuntu1 [2896 kB] 339s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 liblsan0 arm64 14.2.0-12ubuntu1 [1283 kB] 339s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 libtsan2 arm64 14.2.0-12ubuntu1 [2687 kB] 339s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libubsan1 arm64 14.2.0-12ubuntu1 [1152 kB] 339s Get:25 http://ftpmaster.internal/ubuntu plucky/main arm64 libhwasan0 arm64 14.2.0-12ubuntu1 [1598 kB] 339s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 libgcc-14-dev arm64 14.2.0-12ubuntu1 [2596 kB] 339s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [20.9 MB] 340s Get:28 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-14 arm64 14.2.0-12ubuntu1 [522 kB] 340s Get:29 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [1200 B] 340s Get:30 http://ftpmaster.internal/ubuntu plucky/main arm64 gcc arm64 4:14.1.0-2ubuntu1 [4994 B] 340s Get:31 http://ftpmaster.internal/ubuntu plucky/main arm64 libstdc++-14-dev arm64 14.2.0-12ubuntu1 [2500 kB] 340s Get:32 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14-aarch64-linux-gnu arm64 14.2.0-12ubuntu1 [12.1 MB] 340s Get:33 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-14 arm64 14.2.0-12ubuntu1 [20.2 kB] 340s Get:34 http://ftpmaster.internal/ubuntu plucky/main arm64 g++-aarch64-linux-gnu arm64 4:14.1.0-2ubuntu1 [958 B] 340s Get:35 http://ftpmaster.internal/ubuntu plucky/main arm64 g++ arm64 4:14.1.0-2ubuntu1 [1080 B] 340s Get:36 http://ftpmaster.internal/ubuntu plucky/main arm64 build-essential arm64 12.10ubuntu1 [4932 B] 340s Get:37 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-cpp19 arm64 1:19.1.6-1ubuntu1 [13.8 MB] 341s Get:38 http://ftpmaster.internal/ubuntu plucky/main arm64 libgc1 arm64 1:8.2.8-1 [90.1 kB] 341s Get:39 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc4 arm64 14.2.0-12ubuntu1 [45.2 kB] 341s Get:40 http://ftpmaster.internal/ubuntu plucky/universe arm64 libobjc-14-dev arm64 14.2.0-12ubuntu1 [190 kB] 341s Get:41 http://ftpmaster.internal/ubuntu plucky/universe arm64 libclang-common-19-dev arm64 1:19.1.6-1ubuntu1 [743 kB] 341s Get:42 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-linker-tools arm64 1:19.1.6-1ubuntu1 [1232 kB] 341s Get:43 http://ftpmaster.internal/ubuntu plucky/universe arm64 clang-19 arm64 1:19.1.6-1ubuntu1 [77.2 kB] 341s Get:44 http://ftpmaster.internal/ubuntu plucky/main arm64 libdebhelper-perl all 13.20ubuntu1 [94.2 kB] 341s Get:45 http://ftpmaster.internal/ubuntu plucky/main arm64 libtool all 2.4.7-8 [166 kB] 341s Get:46 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-autoreconf all 20 [16.1 kB] 341s Get:47 http://ftpmaster.internal/ubuntu plucky/main arm64 libarchive-zip-perl all 1.68-1 [90.2 kB] 341s Get:48 http://ftpmaster.internal/ubuntu plucky/main arm64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 341s Get:49 http://ftpmaster.internal/ubuntu plucky/main arm64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 341s Get:50 http://ftpmaster.internal/ubuntu plucky/main arm64 debugedit arm64 1:5.1-1 [45.9 kB] 341s Get:51 http://ftpmaster.internal/ubuntu plucky/main arm64 dwz arm64 0.15-1build6 [113 kB] 341s Get:52 http://ftpmaster.internal/ubuntu plucky/main arm64 gettext arm64 0.22.5-3 [932 kB] 341s Get:53 http://ftpmaster.internal/ubuntu plucky/main arm64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 341s Get:54 http://ftpmaster.internal/ubuntu plucky/main arm64 po-debconf all 1.0.21+nmu1 [233 kB] 341s Get:55 http://ftpmaster.internal/ubuntu plucky/main arm64 debhelper all 13.20ubuntu1 [893 kB] 341s Get:56 http://ftpmaster.internal/ubuntu plucky/main arm64 emacsen-common all 3.0.5 [12.1 kB] 341s Get:57 http://ftpmaster.internal/ubuntu plucky/main arm64 dictionaries-common all 1.30.2 [176 kB] 341s Get:58 http://ftpmaster.internal/ubuntu plucky/main arm64 libfakeroot arm64 1.36.2-1 [33.5 kB] 341s Get:59 http://ftpmaster.internal/ubuntu plucky/main arm64 fakeroot arm64 1.36.2-1 [67.1 kB] 341s Get:60 http://ftpmaster.internal/ubuntu plucky/main arm64 hunspell-en-us all 1:2020.12.07-3 [586 kB] 341s Get:61 http://ftpmaster.internal/ubuntu plucky/main arm64 libpgtypes3 arm64 17.2-1 [42.3 kB] 341s Get:62 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.2-1 [141 kB] 341s Get:63 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg6 arm64 17.2-1 [44.0 kB] 341s Get:64 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-compat3 arm64 17.2-1 [12.3 kB] 341s Get:65 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.0-1ubuntu2 [3284 kB] 341s Get:66 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq-dev arm64 17.2-1 [158 kB] 341s Get:67 http://ftpmaster.internal/ubuntu plucky/main arm64 libecpg-dev arm64 17.2-1 [263 kB] 341s Get:68 http://ftpmaster.internal/ubuntu plucky/main arm64 libncurses-dev arm64 6.5-2 [385 kB] 341s Get:69 http://ftpmaster.internal/ubuntu plucky/main arm64 libtcl8.6 arm64 8.6.15+dfsg-2 [987 kB] 341s Get:70 http://ftpmaster.internal/ubuntu plucky/main arm64 libxml2-dev arm64 2.12.7+dfsg+really2.9.14-0.2ubuntu2 [803 kB] 341s Get:71 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 341s Get:72 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-runtime arm64 1:19.1.6-1ubuntu1 [532 kB] 341s Get:73 http://ftpmaster.internal/ubuntu plucky/universe arm64 libpfm4 arm64 4.13.0+git83-g91970fe-1 [71.9 kB] 341s Get:74 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19 arm64 1:19.1.6-1ubuntu1 [17.1 MB] 342s Get:75 http://ftpmaster.internal/ubuntu plucky/main arm64 libffi-dev arm64 3.4.6-1build1 [59.5 kB] 342s Get:76 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-tools arm64 1:19.1.6-1ubuntu1 [539 kB] 342s Get:77 http://ftpmaster.internal/ubuntu plucky/universe arm64 llvm-19-dev arm64 1:19.1.6-1ubuntu1 [45.1 MB] 343s Get:78 http://ftpmaster.internal/ubuntu plucky/universe arm64 locales-all arm64 2.40-4ubuntu1 [11.1 MB] 344s Get:79 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.2-1 [1318 kB] 344s Get:80 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.2-1 [15.5 MB] 344s Get:81 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-17 arm64 17.2-1 [1388 kB] 344s Get:82 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-server-dev-all arm64 267 [21.3 kB] 344s Get:83 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plperl-17 arm64 17.2-1 [63.5 kB] 345s Get:84 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-plpython3-17 arm64 17.2-1 [72.7 kB] 345s Get:85 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-pltcl-17 arm64 17.2-1 [28.7 kB] 345s Get:86 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-all all 267 [1710 B] 345s Get:87 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc-17 all 17.2-1 [2122 kB] 345s Get:88 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-doc all 17+267 [12.2 kB] 345s Preconfiguring packages ... 345s Fetched 183 MB in 7s (26.7 MB/s) 345s Selecting previously unselected package libjson-perl. 345s (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 ... 80205 files and directories currently installed.) 345s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 345s Unpacking libjson-perl (4.10000-1) ... 345s Selecting previously unselected package libio-pty-perl. 345s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 345s Unpacking libio-pty-perl (1:1.20-1build3) ... 345s Selecting previously unselected package libipc-run-perl. 345s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 345s Unpacking libipc-run-perl (20231003.0-2) ... 345s Selecting previously unselected package postgresql-client-common. 345s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 345s Unpacking postgresql-client-common (267) ... 345s Selecting previously unselected package ssl-cert. 345s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 345s Unpacking ssl-cert (1.1.3ubuntu1) ... 345s Selecting previously unselected package postgresql-common. 346s Preparing to unpack .../05-postgresql-common_267_all.deb ... 346s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 346s Unpacking postgresql-common (267) ... 346s Selecting previously unselected package m4. 346s Preparing to unpack .../06-m4_1.4.19-4build1_arm64.deb ... 346s Unpacking m4 (1.4.19-4build1) ... 346s Selecting previously unselected package autoconf. 346s Preparing to unpack .../07-autoconf_2.72-3_all.deb ... 346s Unpacking autoconf (2.72-3) ... 346s Selecting previously unselected package autotools-dev. 346s Preparing to unpack .../08-autotools-dev_20220109.1_all.deb ... 346s Unpacking autotools-dev (20220109.1) ... 346s Selecting previously unselected package automake. 346s Preparing to unpack .../09-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 346s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 346s Selecting previously unselected package autopoint. 346s Preparing to unpack .../10-autopoint_0.22.5-3_all.deb ... 346s Unpacking autopoint (0.22.5-3) ... 346s Selecting previously unselected package libisl23:arm64. 346s Preparing to unpack .../11-libisl23_0.27-1_arm64.deb ... 346s Unpacking libisl23:arm64 (0.27-1) ... 346s Selecting previously unselected package libmpc3:arm64. 346s Preparing to unpack .../12-libmpc3_1.3.1-1build2_arm64.deb ... 346s Unpacking libmpc3:arm64 (1.3.1-1build2) ... 346s Selecting previously unselected package cpp-14-aarch64-linux-gnu. 346s Preparing to unpack .../13-cpp-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking cpp-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package cpp-14. 346s Preparing to unpack .../14-cpp-14_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package cpp-aarch64-linux-gnu. 346s Preparing to unpack .../15-cpp-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 346s Unpacking cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 346s Selecting previously unselected package cpp. 346s Preparing to unpack .../16-cpp_4%3a14.1.0-2ubuntu1_arm64.deb ... 346s Unpacking cpp (4:14.1.0-2ubuntu1) ... 346s Selecting previously unselected package libcc1-0:arm64. 346s Preparing to unpack .../17-libcc1-0_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking libcc1-0:arm64 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package libgomp1:arm64. 346s Preparing to unpack .../18-libgomp1_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking libgomp1:arm64 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package libitm1:arm64. 346s Preparing to unpack .../19-libitm1_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking libitm1:arm64 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package libasan8:arm64. 346s Preparing to unpack .../20-libasan8_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking libasan8:arm64 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package liblsan0:arm64. 346s Preparing to unpack .../21-liblsan0_14.2.0-12ubuntu1_arm64.deb ... 346s Unpacking liblsan0:arm64 (14.2.0-12ubuntu1) ... 346s Selecting previously unselected package libtsan2:arm64. 347s Preparing to unpack .../22-libtsan2_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking libtsan2:arm64 (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package libubsan1:arm64. 347s Preparing to unpack .../23-libubsan1_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking libubsan1:arm64 (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package libhwasan0:arm64. 347s Preparing to unpack .../24-libhwasan0_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking libhwasan0:arm64 (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package libgcc-14-dev:arm64. 347s Preparing to unpack .../25-libgcc-14-dev_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking libgcc-14-dev:arm64 (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package gcc-14-aarch64-linux-gnu. 347s Preparing to unpack .../26-gcc-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking gcc-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package gcc-14. 347s Preparing to unpack .../27-gcc-14_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 347s Selecting previously unselected package gcc-aarch64-linux-gnu. 347s Preparing to unpack .../28-gcc-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 347s Unpacking gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 347s Selecting previously unselected package gcc. 347s Preparing to unpack .../29-gcc_4%3a14.1.0-2ubuntu1_arm64.deb ... 347s Unpacking gcc (4:14.1.0-2ubuntu1) ... 347s Selecting previously unselected package libstdc++-14-dev:arm64. 347s Preparing to unpack .../30-libstdc++-14-dev_14.2.0-12ubuntu1_arm64.deb ... 347s Unpacking libstdc++-14-dev:arm64 (14.2.0-12ubuntu1) ... 348s Selecting previously unselected package g++-14-aarch64-linux-gnu. 348s Preparing to unpack .../31-g++-14-aarch64-linux-gnu_14.2.0-12ubuntu1_arm64.deb ... 348s Unpacking g++-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 348s Selecting previously unselected package g++-14. 348s Preparing to unpack .../32-g++-14_14.2.0-12ubuntu1_arm64.deb ... 348s Unpacking g++-14 (14.2.0-12ubuntu1) ... 348s Selecting previously unselected package g++-aarch64-linux-gnu. 348s Preparing to unpack .../33-g++-aarch64-linux-gnu_4%3a14.1.0-2ubuntu1_arm64.deb ... 348s Unpacking g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 348s Selecting previously unselected package g++. 348s Preparing to unpack .../34-g++_4%3a14.1.0-2ubuntu1_arm64.deb ... 348s Unpacking g++ (4:14.1.0-2ubuntu1) ... 348s Selecting previously unselected package build-essential. 348s Preparing to unpack .../35-build-essential_12.10ubuntu1_arm64.deb ... 348s Unpacking build-essential (12.10ubuntu1) ... 348s Selecting previously unselected package libclang-cpp19. 348s Preparing to unpack .../36-libclang-cpp19_1%3a19.1.6-1ubuntu1_arm64.deb ... 348s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 348s Selecting previously unselected package libgc1:arm64. 348s Preparing to unpack .../37-libgc1_1%3a8.2.8-1_arm64.deb ... 348s Unpacking libgc1:arm64 (1:8.2.8-1) ... 348s Selecting previously unselected package libobjc4:arm64. 348s Preparing to unpack .../38-libobjc4_14.2.0-12ubuntu1_arm64.deb ... 348s Unpacking libobjc4:arm64 (14.2.0-12ubuntu1) ... 348s Selecting previously unselected package libobjc-14-dev:arm64. 348s Preparing to unpack .../39-libobjc-14-dev_14.2.0-12ubuntu1_arm64.deb ... 348s Unpacking libobjc-14-dev:arm64 (14.2.0-12ubuntu1) ... 348s Selecting previously unselected package libclang-common-19-dev:arm64. 348s Preparing to unpack .../40-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_arm64.deb ... 348s Unpacking libclang-common-19-dev:arm64 (1:19.1.6-1ubuntu1) ... 349s Selecting previously unselected package llvm-19-linker-tools. 349s Preparing to unpack .../41-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_arm64.deb ... 349s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 349s Selecting previously unselected package clang-19. 349s Preparing to unpack .../42-clang-19_1%3a19.1.6-1ubuntu1_arm64.deb ... 349s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 349s Selecting previously unselected package libdebhelper-perl. 349s Preparing to unpack .../43-libdebhelper-perl_13.20ubuntu1_all.deb ... 349s Unpacking libdebhelper-perl (13.20ubuntu1) ... 349s Selecting previously unselected package libtool. 349s Preparing to unpack .../44-libtool_2.4.7-8_all.deb ... 349s Unpacking libtool (2.4.7-8) ... 349s Selecting previously unselected package dh-autoreconf. 349s Preparing to unpack .../45-dh-autoreconf_20_all.deb ... 349s Unpacking dh-autoreconf (20) ... 349s Selecting previously unselected package libarchive-zip-perl. 349s Preparing to unpack .../46-libarchive-zip-perl_1.68-1_all.deb ... 349s Unpacking libarchive-zip-perl (1.68-1) ... 349s Selecting previously unselected package libfile-stripnondeterminism-perl. 349s Preparing to unpack .../47-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 349s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 349s Selecting previously unselected package dh-strip-nondeterminism. 349s Preparing to unpack .../48-dh-strip-nondeterminism_1.14.0-1_all.deb ... 349s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 349s Selecting previously unselected package debugedit. 349s Preparing to unpack .../49-debugedit_1%3a5.1-1_arm64.deb ... 349s Unpacking debugedit (1:5.1-1) ... 349s Selecting previously unselected package dwz. 349s Preparing to unpack .../50-dwz_0.15-1build6_arm64.deb ... 349s Unpacking dwz (0.15-1build6) ... 349s Selecting previously unselected package gettext. 349s Preparing to unpack .../51-gettext_0.22.5-3_arm64.deb ... 349s Unpacking gettext (0.22.5-3) ... 349s Selecting previously unselected package intltool-debian. 349s Preparing to unpack .../52-intltool-debian_0.35.0+20060710.6_all.deb ... 349s Unpacking intltool-debian (0.35.0+20060710.6) ... 349s Selecting previously unselected package po-debconf. 349s Preparing to unpack .../53-po-debconf_1.0.21+nmu1_all.deb ... 349s Unpacking po-debconf (1.0.21+nmu1) ... 349s Selecting previously unselected package debhelper. 349s Preparing to unpack .../54-debhelper_13.20ubuntu1_all.deb ... 349s Unpacking debhelper (13.20ubuntu1) ... 349s Selecting previously unselected package emacsen-common. 349s Preparing to unpack .../55-emacsen-common_3.0.5_all.deb ... 349s Unpacking emacsen-common (3.0.5) ... 349s Selecting previously unselected package dictionaries-common. 349s Preparing to unpack .../56-dictionaries-common_1.30.2_all.deb ... 349s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 349s Unpacking dictionaries-common (1.30.2) ... 349s Selecting previously unselected package libfakeroot:arm64. 349s Preparing to unpack .../57-libfakeroot_1.36.2-1_arm64.deb ... 349s Unpacking libfakeroot:arm64 (1.36.2-1) ... 349s Selecting previously unselected package fakeroot. 349s Preparing to unpack .../58-fakeroot_1.36.2-1_arm64.deb ... 349s Unpacking fakeroot (1.36.2-1) ... 349s Selecting previously unselected package hunspell-en-us. 349s Preparing to unpack .../59-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 349s Unpacking hunspell-en-us (1:2020.12.07-3) ... 349s Selecting previously unselected package libpgtypes3:arm64. 349s Preparing to unpack .../60-libpgtypes3_17.2-1_arm64.deb ... 349s Unpacking libpgtypes3:arm64 (17.2-1) ... 349s Selecting previously unselected package libpq5:arm64. 349s Preparing to unpack .../61-libpq5_17.2-1_arm64.deb ... 349s Unpacking libpq5:arm64 (17.2-1) ... 349s Selecting previously unselected package libecpg6:arm64. 349s Preparing to unpack .../62-libecpg6_17.2-1_arm64.deb ... 349s Unpacking libecpg6:arm64 (17.2-1) ... 349s Selecting previously unselected package libecpg-compat3:arm64. 349s Preparing to unpack .../63-libecpg-compat3_17.2-1_arm64.deb ... 349s Unpacking libecpg-compat3:arm64 (17.2-1) ... 350s Selecting previously unselected package libssl-dev:arm64. 350s Preparing to unpack .../64-libssl-dev_3.4.0-1ubuntu2_arm64.deb ... 350s Unpacking libssl-dev:arm64 (3.4.0-1ubuntu2) ... 350s Selecting previously unselected package libpq-dev. 350s Preparing to unpack .../65-libpq-dev_17.2-1_arm64.deb ... 350s Unpacking libpq-dev (17.2-1) ... 350s Selecting previously unselected package libecpg-dev. 350s Preparing to unpack .../66-libecpg-dev_17.2-1_arm64.deb ... 350s Unpacking libecpg-dev (17.2-1) ... 350s Selecting previously unselected package libncurses-dev:arm64. 350s Preparing to unpack .../67-libncurses-dev_6.5-2_arm64.deb ... 350s Unpacking libncurses-dev:arm64 (6.5-2) ... 350s Selecting previously unselected package libtcl8.6:arm64. 350s Preparing to unpack .../68-libtcl8.6_8.6.15+dfsg-2_arm64.deb ... 350s Unpacking libtcl8.6:arm64 (8.6.15+dfsg-2) ... 350s Selecting previously unselected package libxml2-dev:arm64. 350s Preparing to unpack .../69-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu2_arm64.deb ... 350s Unpacking libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 350s Selecting previously unselected package libxslt1.1:arm64. 350s Preparing to unpack .../70-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 350s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 350s Selecting previously unselected package llvm-19-runtime. 350s Preparing to unpack .../71-llvm-19-runtime_1%3a19.1.6-1ubuntu1_arm64.deb ... 350s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 350s Selecting previously unselected package libpfm4:arm64. 350s Preparing to unpack .../72-libpfm4_4.13.0+git83-g91970fe-1_arm64.deb ... 350s Unpacking libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 350s Selecting previously unselected package llvm-19. 350s Preparing to unpack .../73-llvm-19_1%3a19.1.6-1ubuntu1_arm64.deb ... 350s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 351s Selecting previously unselected package libffi-dev:arm64. 351s Preparing to unpack .../74-libffi-dev_3.4.6-1build1_arm64.deb ... 351s Unpacking libffi-dev:arm64 (3.4.6-1build1) ... 351s Selecting previously unselected package llvm-19-tools. 351s Preparing to unpack .../75-llvm-19-tools_1%3a19.1.6-1ubuntu1_arm64.deb ... 351s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 351s Selecting previously unselected package llvm-19-dev. 351s Preparing to unpack .../76-llvm-19-dev_1%3a19.1.6-1ubuntu1_arm64.deb ... 351s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 352s Selecting previously unselected package locales-all. 352s Preparing to unpack .../77-locales-all_2.40-4ubuntu1_arm64.deb ... 352s Unpacking locales-all (2.40-4ubuntu1) ... 354s Selecting previously unselected package postgresql-client-17. 354s Preparing to unpack .../78-postgresql-client-17_17.2-1_arm64.deb ... 354s Unpacking postgresql-client-17 (17.2-1) ... 354s Selecting previously unselected package postgresql-17. 354s Preparing to unpack .../79-postgresql-17_17.2-1_arm64.deb ... 354s Unpacking postgresql-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-server-dev-17. 355s Preparing to unpack .../80-postgresql-server-dev-17_17.2-1_arm64.deb ... 355s Unpacking postgresql-server-dev-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-server-dev-all:arm64. 355s Preparing to unpack .../81-postgresql-server-dev-all_267_arm64.deb ... 355s Unpacking postgresql-server-dev-all:arm64 (267) ... 355s Selecting previously unselected package postgresql-plperl-17. 355s Preparing to unpack .../82-postgresql-plperl-17_17.2-1_arm64.deb ... 355s Unpacking postgresql-plperl-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-plpython3-17. 355s Preparing to unpack .../83-postgresql-plpython3-17_17.2-1_arm64.deb ... 355s Unpacking postgresql-plpython3-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-pltcl-17. 355s Preparing to unpack .../84-postgresql-pltcl-17_17.2-1_arm64.deb ... 355s Unpacking postgresql-pltcl-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-all. 355s Preparing to unpack .../85-postgresql-all_267_all.deb ... 355s Unpacking postgresql-all (267) ... 355s Selecting previously unselected package postgresql-doc-17. 355s Preparing to unpack .../86-postgresql-doc-17_17.2-1_all.deb ... 355s Unpacking postgresql-doc-17 (17.2-1) ... 355s Selecting previously unselected package postgresql-doc. 355s Preparing to unpack .../87-postgresql-doc_17+267_all.deb ... 355s Unpacking postgresql-doc (17+267) ... 355s Setting up libpgtypes3:arm64 (17.2-1) ... 355s Setting up libncurses-dev:arm64 (6.5-2) ... 355s Setting up libio-pty-perl (1:1.20-1build3) ... 355s Setting up libclang-common-19-dev:arm64 (1:19.1.6-1ubuntu1) ... 355s Setting up libarchive-zip-perl (1.68-1) ... 355s Setting up libdebhelper-perl (13.20ubuntu1) ... 355s Setting up postgresql-doc-17 (17.2-1) ... 356s 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 356s Setting up libpq5:arm64 (17.2-1) ... 356s Setting up m4 (1.4.19-4build1) ... 356s Setting up libgomp1:arm64 (14.2.0-12ubuntu1) ... 356s Setting up libffi-dev:arm64 (3.4.6-1build1) ... 356s Setting up locales-all (2.40-4ubuntu1) ... 356s Setting up libfakeroot:arm64 (1.36.2-1) ... 356s Setting up fakeroot (1.36.2-1) ... 356s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 356s Setting up autotools-dev (20220109.1) ... 356s Setting up libxml2-dev:arm64 (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 356s Setting up libpfm4:arm64 (4.13.0+git83-g91970fe-1) ... 356s Setting up emacsen-common (3.0.5) ... 356s Setting up ssl-cert (1.1.3ubuntu1) ... 356s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 357s Setting up libssl-dev:arm64 (3.4.0-1ubuntu2) ... 357s Setting up libmpc3:arm64 (1.3.1-1build2) ... 357s Setting up libtcl8.6:arm64 (8.6.15+dfsg-2) ... 357s Setting up autopoint (0.22.5-3) ... 357s Setting up libipc-run-perl (20231003.0-2) ... 357s Setting up libgc1:arm64 (1:8.2.8-1) ... 357s Setting up autoconf (2.72-3) ... 357s Setting up libubsan1:arm64 (14.2.0-12ubuntu1) ... 357s Setting up dwz (0.15-1build6) ... 357s Setting up libhwasan0:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libasan8:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libjson-perl (4.10000-1) ... 357s Setting up postgresql-doc (17+267) ... 357s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 357s Setting up debugedit (1:5.1-1) ... 357s Setting up libecpg6:arm64 (17.2-1) ... 357s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 357s Setting up libtsan2:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libisl23:arm64 (0.27-1) ... 357s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 357s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 357s Setting up libcc1-0:arm64 (14.2.0-12ubuntu1) ... 357s Setting up liblsan0:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libitm1:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 357s Setting up automake (1:1.16.5-1.3ubuntu1) ... 357s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 357s Setting up postgresql-client-common (267) ... 357s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 357s Setting up gettext (0.22.5-3) ... 357s Setting up libecpg-compat3:arm64 (17.2-1) ... 357s Setting up dictionaries-common (1.30.2) ... 357s Setting up postgresql-client-17 (17.2-1) ... 357s 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 357s Setting up libpq-dev (17.2-1) ... 357s Setting up libobjc4:arm64 (14.2.0-12ubuntu1) ... 357s Setting up libecpg-dev (17.2-1) ... 357s Setting up intltool-debian (0.35.0+20060710.6) ... 358s Setting up postgresql-common (267) ... 358s Creating config file /etc/postgresql-common/createcluster.conf with new version 358s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 358s en_us 358s Removing obsolete dictionary files: 359s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 359s Setting up dh-strip-nondeterminism (1.14.0-1) ... 359s Setting up cpp-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 359s Setting up hunspell-en-us (1:2020.12.07-3) ... 359s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 359s Setting up libgcc-14-dev:arm64 (14.2.0-12ubuntu1) ... 359s Setting up libstdc++-14-dev:arm64 (14.2.0-12ubuntu1) ... 359s Setting up postgresql-17 (17.2-1) ... 359s Creating new PostgreSQL cluster 17/main ... 359s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 359s The files belonging to this database system will be owned by user "postgres". 359s This user must also own the server process. 359s 359s The database cluster will be initialized with locale "C.UTF-8". 359s The default database encoding has accordingly been set to "UTF8". 359s The default text search configuration will be set to "english". 359s 359s Data page checksums are disabled. 359s 359s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 359s creating subdirectories ... ok 359s selecting dynamic shared memory implementation ... posix 359s selecting default "max_connections" ... 100 359s selecting default "shared_buffers" ... 128MB 359s selecting default time zone ... Etc/UTC 359s creating configuration files ... ok 360s running bootstrap script ... ok 360s performing post-bootstrap initialization ... ok 360s syncing data to disk ... ok 364s Setting up po-debconf (1.0.21+nmu1) ... 364s Setting up libobjc-14-dev:arm64 (14.2.0-12ubuntu1) ... 364s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 364s Setting up cpp-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 364s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 364s Setting up cpp-14 (14.2.0-12ubuntu1) ... 364s Setting up postgresql-plpython3-17 (17.2-1) ... 364s Setting up postgresql-plperl-17 (17.2-1) ... 364s Setting up cpp (4:14.1.0-2ubuntu1) ... 364s Setting up gcc-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 364s Setting up gcc-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 364s Setting up postgresql-pltcl-17 (17.2-1) ... 364s Setting up g++-14-aarch64-linux-gnu (14.2.0-12ubuntu1) ... 364s Setting up libtool (2.4.7-8) ... 364s Setting up gcc-14 (14.2.0-12ubuntu1) ... 364s Setting up dh-autoreconf (20) ... 364s Setting up postgresql-server-dev-17 (17.2-1) ... 364s Setting up g++-aarch64-linux-gnu (4:14.1.0-2ubuntu1) ... 364s Setting up g++-14 (14.2.0-12ubuntu1) ... 364s Setting up postgresql-server-dev-all:arm64 (267) ... 364s Setting up debhelper (13.20ubuntu1) ... 364s Setting up postgresql-all (267) ... 364s Setting up gcc (4:14.1.0-2ubuntu1) ... 364s Setting up g++ (4:14.1.0-2ubuntu1) ... 364s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 364s Setting up build-essential (12.10ubuntu1) ... 364s Processing triggers for libc-bin (2.40-4ubuntu1) ... 364s Processing triggers for systemd (257-2ubuntu1) ... 364s Processing triggers for man-db (2.13.0-1) ... 365s Processing triggers for install-info (7.1.1-1) ... 366s Processing triggers for dictionaries-common (1.30.2) ... 368s autopkgtest [11:51:15]: test run-testsuite: [----------------------- 369s ====== Running all tests with umask 077 ======= 369s ### PostgreSQL test 001_packages.t ### 369s 1..21 369s ok 1 - /etc/os-release exists 369s ok 2 - OS is ubuntu 369s ok 3 - OS version is 25.04 369s # PostgreSQL versions installed: 17 369s ok 4 - postgresql-17 installed 369s ok 5 - postgresql-plpython3-17 installed 369s ok 6 - postgresql-plperl-17 installed 369s ok 7 - postgresql-pltcl-17 installed 369s ok 8 - postgresql-server-dev-17 installed 369s ok 9 # skip No postgresql-contrib-17 package for version 17 369s # postgresql-doc-17 installed 369s ok 10 - At least one doc package installed 369s ok 11 - libecpg-dev installed 369s ok 12 - procps installed 369s ok 13 - netcat-openbsd installed 369s ok 14 - hunspell-en-us installed 369s ok 15 - system has a default UTF-8 locale 369s ok 16 - locale ru_RU exists 369s ok 17 - locale ru_RU.UTF-8 exists 369s ok 18 - user postgres in the UNIX group ssl-cert 369s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 369s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 369s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 369s ### End test 001_packages.t ### 369s 369s ### PostgreSQL test 002_existing_clusters.t ### 369s 1..8 369s # Cleanup 369s ok 1 - Cleanup: No clusters left behind 369s ok 2 - No postgres processes left behind 369s ok 3 - No files in /etc/postgresql left behind 369s ok 4 - No files in /var/lib/postgresql left behind 369s ok 5 - No files in /var/run/postgresql left behind 369s ok 6 - No files in /var/log/postgresql left behind 369s ok 7 - PostgreSQL TCP ports are closed 369s ok 8 - Next free port is 5432 369s ### End test 002_existing_clusters.t ### 369s 369s ### PostgreSQL test 003_alternatives.t ### 369s 1..9 369s # Newest PG version installed is 17 369s ok 1 - psql.1.gz link group 369s ok 2 - postmaster.1.gz link group does not exist 369s ok 3 - psql.1.gz alternative 369s ok 4 - pg_dump.1.gz alternative 369s ok 5 - postgres.1.gz alternative 369s ok 6 - pg_ctl.1.gz alternative 369s # Newest PG doc version installed is 17 369s ok 7 - SPI_connect.3.gz link group 369s ok 8 - SPI_connect.3.gz alternative 369s ok 9 - SPI_exec.3.gz alternative 369s ### End test 003_alternatives.t ### 369s 369s ### PostgreSQL test 005_PgCommon.t ### 369s 1..24 369s ok 1 - correctly parsed line 'local all postgres ident sameuser' 369s ok 2 - correctly parsed line 'local foo nobody trust' 369s ok 3 - correctly parsed line 'local foo nobody crypt' 369s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 369s ok 5 - correctly parsed line 'local foo,bar nobody ident' 369s ok 6 - correctly parsed line 'local all +foogrp password' 369s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 369s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 369s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 369s ok 10 - @expected_records has correct number of entries 369s ok 11 - returned read_pg_hba array has correct number of records 369s ok 12 - line 'foo all all md5' parsed as invalid 369s ok 13 - line 'local all all foo' parsed as invalid 369s ok 14 - line 'host all all foo' parsed as invalid 369s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 369s ok 16 - line 'host all all md5' parsed as invalid 369s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 369s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 369s ok 19 - read_conf_file returns empty dict for nonexisting file 369s ok 20 - read_conf_file() parsing 369s ok 21 - read_conf_file() parsing with include directives 369s ok 22 - set_conf_value 369s ok 23 - disable_conf_value 369s ok 24 - replace_conf_value 369s ### End test 005_PgCommon.t ### 369s 369s ### PostgreSQL test 006_next_free_port.t ### 370s 1..5 370s ok 1 - next_free_port is 5432 371s ok 2 - next_free_port detects localhost ipv4 socket 372s ok 3 - next_free_port detects wildcard ipv4 socket 373s ok 4 - next_free_port detects localhost ipv6 socket 374s ok 5 - next_free_port detects wildcard ipv6 socket 374s ### End test 006_next_free_port.t ### 374s 374s ### PostgreSQL test 007_pg_conftool.t ### 374s 1..41 374s # test without cluster 374s ok 1 - pg_conftool show all 374s ok 2 - correct output of pg_conftool show all 374s ok 3 - pg_conftool foo.conf show all 374s ok 4 - correct output of pg_conftool foo.conf show all 374s ok 5 - pg_conftool /tmp/C70d_wgFyC/different.conf show all 374s ok 6 - correct output of pg_conftool /tmp/C70d_wgFyC/different.conf show all 374s ok 7 - pg_conftool 9.7 main show all 374s ok 8 - correct output of pg_conftool 9.7 main show all 374s # test show 374s ok 9 - pg_conftool show all 374s ok 10 - correct output of pg_conftool show all 374s ok 11 - pg_conftool other.conf show all 374s ok 12 - correct output of pg_conftool other.conf show all 374s ok 13 - pg_conftool /tmp/C70d_wgFyC/different.conf show all 374s ok 14 - correct output of pg_conftool /tmp/C70d_wgFyC/different.conf show all 374s ok 15 - pg_conftool 17 main show all 374s ok 16 - correct output of pg_conftool 17 main show all 374s ok 17 - pg_conftool 17 main other.conf show all 374s ok 18 - correct output of pg_conftool 17 main other.conf show all 374s ok 19 - pg_conftool show a 374s ok 20 - correct output of pg_conftool show a 374s ok 21 - pg_conftool -s show a 374s ok 22 - correct output of pg_conftool -s show a 374s # test set 374s ok 23 - pg_conftool set c 7 374s ok 24 - correct output of pg_conftool set c 7 374s ok 25 - file contains new setting 374s ok 26 - pg_conftool set a 8 374s ok 27 - correct output of pg_conftool set a 8 374s ok 28 - file contains updated setting 374s ok 29 - pg_conftool /tmp/C70d_wgFyC/different.conf set a 9 374s ok 30 - correct output of pg_conftool /tmp/C70d_wgFyC/different.conf set a 9 374s ok 31 - file with path contains updated setting 374s # test remove 374s ok 32 - pg_conftool remove a 374s ok 33 - correct output of pg_conftool remove a 374s ok 34 - setting removed from file 374s ok 35 - pg_conftool /tmp/C70d_wgFyC/different.conf remove a 374s ok 36 - correct output of pg_conftool /tmp/C70d_wgFyC/different.conf remove a 374s ok 37 - setting removed from file with path 374s # test edit 374s ok 38 - pg_conftool edit 374s ok 39 - correct output of pg_conftool edit 374s ok 40 - pg_conftool /tmp/C70d_wgFyC/different.conf edit 374s ok 41 - correct output of pg_conftool /tmp/C70d_wgFyC/different.conf edit 374s ### End test 007_pg_conftool.t ### 374s 374s ### PostgreSQL test 010_defaultport_cluster.t ### 374s 1..14 374s ok 1 - psql --version 374s ok 2 - pg_wrapper selects highest available version number 374s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 374s ok 4 - connecting to localhost fails with no clusters 375s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 375s ok 6 - pg_wrapper uses host and port from PGCLUSTER 375s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 375s ok 8 - pg_wrapper uses --cluster from the command line 375s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 375s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 375s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 375s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 375s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 375s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 375s ### End test 010_defaultport_cluster.t ### 375s 375s ### PostgreSQL test 015_start_stop.t ### 375s 1..71 375s # We are running systemd 375s # Running tests for 17 375s # Cluster does not exist yet 375s ok 1 - cluster 17 main does not exist 375s ok 2 - service postgresql@17-main does not exist 375s ok 3 - systemctl start postgresql 375s ok 4 - cluster 17 main does not exist 375s ok 5 - service postgresql@17-main does not exist 375s ok 6 - systemctl start postgresql@17-main 375s ok 7 - cluster 17 main does not exist 375s ok 8 - service postgresql@17-main does not exist 375s # Start/stop postgresql using system tools 376s ok 9 - pg_createcluster 17 main 376s ok 10 - cluster 17 main is stopped 376s ok 11 - service postgresql@17-main is stopped 378s ok 12 - systemctl start postgresql 378s ok 13 - cluster 17 main is running 378s ok 14 - service postgresql@17-main is running 378s ok 15 - systemctl start postgresql 378s ok 16 - cluster 17 main is already running 378s ok 17 - service postgresql@17-main is already running 378s ok 18 - systemctl stop postgresql 384s ok 19 - cluster 17 main is stopped 384s ok 20 - service postgresql@17-main is stopped 385s ok 21 - systemctl stop postgresql 385s ok 22 - cluster 17 main is already stopped 385s ok 23 - service postgresql@17-main is already stopped 385s # Start/stop specific cluster using system tools 387s ok 24 - systemctl start postgresql@17-main 387s ok 25 - cluster 17 main is running 387s ok 26 - service postgresql@17-main is running 387s ok 27 - systemctl start postgresql@17-main 387s ok 28 - cluster 17 main is running 387s ok 29 - service postgresql@17-main is running 389s ok 30 - systemctl restart postgresql@17-main 389s ok 31 - cluster 17 main is running 389s ok 32 - service postgresql@17-main is running 390s ok 33 - systemctl stop postgresql@17-main 390s ok 34 - cluster 17 main is stopped 390s ok 35 - service postgresql@17-main is stopped 390s ok 36 - systemctl stop postgresql@17-main 390s ok 37 - cluster 17 main is already stopped 390s ok 38 - service postgresql@17-main is already stopped 391s ok 39 - pg_dropcluster 17 main 391s ok 40 - cluster 17 main does not exist 391s ok 41 - service postgresql@17-main does not exist 391s # Start/stop specific cluster using pg_*cluster 391s ok 42 - pg_ctlcluster start 17 main 391s ok 43 - cluster 17 main does not exist 391s ok 44 - service postgresql@17-main does not exist 395s ok 45 - pg_createcluster 17 main --start 395s ok 46 - cluster 17 main is running 395s ok 47 - service postgresql@17-main is running 395s ok 48 - pg_ctlcluster 17 main start 395s ok 49 - cluster 17 main is already running 395s ok 50 - service postgresql@17-main is already running 397s ok 51 - pg_ctlcluster 17-main restart 397s ok 52 - cluster 17 main is running 397s ok 53 - service postgresql@17-main is running 397s ok 54 - pg_ctlcluster 17 main stop 397s ok 55 - cluster 17 main is stopped 397s ok 56 - service postgresql@17-main is stopped 398s ok 57 - pg_ctlcluster 17 main stop 398s ok 58 - cluster 17 main is already stopped 398s ok 59 - service postgresql@17-main is already stopped 400s ok 60 - pg_ctlcluster start 17-main 400s ok 61 - cluster 17 main is running 400s ok 62 - service postgresql@17-main is running 402s ok 63 - pg_dropcluster 17 main --stop 402s # Cleanup 402s ok 64 - Cleanup: No clusters left behind 402s ok 65 - No postgres processes left behind 402s ok 66 - No files in /etc/postgresql left behind 402s ok 67 - No files in /var/lib/postgresql left behind 402s ok 68 - No files in /var/run/postgresql left behind 402s ok 69 - No files in /var/log/postgresql left behind 402s ok 70 - PostgreSQL TCP ports are closed 402s ok 71 - Next free port is 5432 402s ### End test 015_start_stop.t ### 402s 402s ### PostgreSQL test 020_create_sql_remove.t ### 402s 1..141 402s # Running tests for 17 405s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.Qp1ww5 405s ok 2 - pg_createcluster 17 main 405s ok 3 - Socket and pid file are in /var/run/postgresql/ 405s ok 4 - xlog/wal directory /tmp/17.xlog.Qp1ww5 was created 405s ok 5 - local method in pg_hba.conf is peer 405s ok 6 - host method in pg_hba.conf is scram-sha-256 405s ok 7 - Exactly one postgres master process running 407s ok 8 - pg_ctlcluster 17 main restart 407s ok 9 - cluster restarts with new environment file 407s ok 10 - Exactly one postgres master process running 407s ok 11 - correct value of PGEXTRAVAR1 in environment 407s ok 12 - correct value of PGEXTRAVAR2 in environment 407s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 407s ok 14 - createdb --version 407s ok 15 - pg_wrapper+createdb selects version number of cluster 407s ok 16 - psql --version 407s ok 17 - pg_wrapper+psql selects version 17 407s ok 18 - pg_lscluster reports online cluster on port 5432 407s ok 19 - log file is actually used 407s ok 20 - /etc/postgresql is owned by user "postgres" 407s ok 21 - version configuration directory file is owned by user "postgres" 407s ok 22 - configuration directory file is owned by user "postgres" 407s ok 23 - version data directory file is owned by user "postgres" 407s ok 24 - data directory file is owned by user "postgres" 407s ok 25 - log file has 0640 permissions 407s ok 26 - log file is owned by user "postgres" 407s ok 27 - log file is owned by group "adm" 407s ok 28 - no log symlink by default 407s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 407s ok 30 - pg_lsclusters -h 407s ok 31 - correct output of pg_lsclusters -h 408s ok 32 - stopping cluster 410s ok 33 - restarting cluster with nondefault log symlink 410s ok 34 - log target is used as log file 410s ok 35 - default log is not used 410s ok 36 - pg_lsclusters -h 410s ok 37 - correct output of pg_lsclusters -h 411s ok 38 - stopping cluster 413s ok 39 - restarting cluster with explicitly configured log file 413s ok 40 - default log is not used 413s ok 41 - log symlink target is used for startup message 413s ok 42 - exactly one log file 413s ok 43 - custom log is actually used 413s ok 44 - pg_lsclusters -h 413s ok 45 - correct output of pg_lsclusters -h 413s ok 46 - stopping cluster 413s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 413s ok 48 - /etc/postgres-hack was not created 416s ok 49 - restarting cluster 416s ok 50 - ps -o tty -U postgres h 416s ok 51 - postgres processes do not have an associated terminal 416s ok 52 - Server is linked with SSL support 416s ok 53 - SSL is enabled in postgresql.conf 416s ok 54 - psql -l fails for nobody 416s ok 55 - createuser nobody 416s ok 56 - createdb nobodydb 416s ok 57 - psql -ltA succeeds for nobody 416s ok 58 - psql -ltA output 416s ok 59 - SQL command: create table 416s ok 60 - SQL command: insert into table values 416s ok 61 - SQL command: insert into table values 416s ok 62 - primary key violation 416s ok 63 - psql -tAc "select * from phone order by name" nobodydb 416s ok 64 - SQL command output: select -tA 416s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 416s ok 66 - SQL command output: select -tx 416s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 416s ok 68 - SQL command output: select -tAx 416s ok 69 - CREATE EXTENSION plperlu fails for user nobody 416s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 416s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 417s ok 72 - creating PL/PerlU function as user nobody fails 417s ok 73 - creating unsafe PL/Perl function as user postgres fails 417s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 417s ok 75 - creating PL/PerlU function as user postgres succeeds 417s ok 76 - psql nobodydb -Atc "select read_file()" 417s ok 77 - calling PL/PerlU function 417s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 417s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 417s ok 80 - creating unsafe PL/Perl function as user nobody fails 417s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 417s ok 82 - creating PL/Perl function as user nobody succeeds 417s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 417s ok 84 - calling PL/Perl function 417s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 417s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 417s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 417s ok 88 - creating PL/Python3 function as user postgres succeeds 417s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 417s ok 90 - calling PL/Python function 417s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 417s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 417s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 417s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 417s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 417s ok 96 - creating PL/Tcl function as user nobody succeeds 417s 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;" 417s ok 98 - creating PL/TclU function as user postgres succeeds 417s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 417s ok 100 - calling PL/Tcl function 418s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 418s ok 102 - calling PL/TclU function 418s ok 103 - stopping cluster 418s ok 104 - pg_ctlcluster 17 main start 418s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 420s ok 106 - pg_ctlcluster 17 main start 420s ok 107 - cluster restarts with pgdata symlink 420s ok 108 - postgres master has OOM killer protection 420s ok 109 - postgres client backend has no OOM adjustment 420s ok 110 - ps h 6409 420s ok 111 - process title is idle 421s ok 112 - ps h 6409 421s ok 113 - process title is idle in transaction 421s ok 114 - stopping cluster 423s ok 115 - starting cluster as postgres works without a log file 423s ok 116 - log file got recreated and used 423s ok 117 - creating a directory in spc2 423s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1._7AZlv'" 423s ok 119 - creating tablespace spc1 423s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 423s ok 121 - creating a table in spc1 423s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.h0DqQT'" 423s ok 123 - creating tablespace spc2 424s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 424s ok 125 - creating a table in spc2 424s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 424s ok 127 - Correct apt NeverAutoRemove config 425s ok 128 - pg_dropcluster removes cluster 425s ok 129 - xlog/wal directory /tmp/17.xlog.Qp1ww5 was deleted 425s ok 130 - tablespace spc1 was emptied 425s ok 131 - tablespace spc2 was emptied 425s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 425s ok 133 - Correct apt NeverAutoRemove config 425s # Cleanup 425s ok 134 - Cleanup: No clusters left behind 425s ok 135 - No postgres processes left behind 425s ok 136 - No files in /etc/postgresql left behind 425s ok 137 - No files in /var/lib/postgresql left behind 425s ok 138 - No files in /var/run/postgresql left behind 425s ok 139 - No files in /var/log/postgresql left behind 425s ok 140 - PostgreSQL TCP ports are closed 425s ok 141 - Next free port is 5432 425s ### End test 020_create_sql_remove.t ### 425s 425s ### PostgreSQL test 021_pg_renamecluster.t ### 425s 1..20 429s ok 1 - pg_createcluster 17 main 431s ok 2 - pg_renamecluster 17 main donau 431s ok 3 - psql -tAc "show data_directory" 431s ok 4 - cluster is running and data_directory was moved 431s ok 5 - pg_hba.conf location updated 431s ok 6 - pg_ident.conf location updated 431s ok 7 - external_pid_file location updated 431s ok 8 - external_pid_file exists 431s ok 9 # skip no stats_temp_directory in 17 431s ok 10 # skip no stats_temp_directory in 17 431s ok 11 - cluster_name is updated 433s ok 12 - pg_dropcluster removes cluster 433s # Cleanup 433s ok 13 - Cleanup: No clusters left behind 433s ok 14 - No postgres processes left behind 433s ok 15 - No files in /etc/postgresql left behind 433s ok 16 - No files in /var/lib/postgresql left behind 433s ok 17 - No files in /var/run/postgresql left behind 433s ok 18 - No files in /var/log/postgresql left behind 433s ok 19 - PostgreSQL TCP ports are closed 433s ok 20 - Next free port is 5432 433s ### End test 021_pg_renamecluster.t ### 433s 433s ### PostgreSQL test 022_recovery.t ### 433s 1..17 433s # Running tests for 17 436s ok 1 - pg_createcluster 17 main --start >/dev/null 437s ok 2 - pg_ctlcluster 17 main stop -m i 439s ok 3 - pg_ctlcluster 17 main start 439s ok 4 - psql -c '' 439s ok 5 - pg_ctlcluster 17 main stop -m i 439s ok 6 - create write-protected file in data directory 441s ok 7 - pg_ctlcluster 17 main start 441s ok 8 - psql -c '' 443s ok 9 - pg_dropcluster removes cluster 443s # Cleanup 443s ok 10 - Cleanup: No clusters left behind 443s ok 11 - No postgres processes left behind 443s ok 12 - No files in /etc/postgresql left behind 443s ok 13 - No files in /var/lib/postgresql left behind 443s ok 14 - No files in /var/run/postgresql left behind 443s ok 15 - No files in /var/log/postgresql left behind 443s ok 16 - PostgreSQL TCP ports are closed 443s ok 17 - Next free port is 5432 443s ### End test 022_recovery.t ### 443s 443s ### PostgreSQL test 025_logging.t ### 443s 1..55 444s # Logging to /var/log/syslog works 444s # Running tests for 17 447s ok 1 - pg_createcluster 17 main 447s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 447s ok 3 - psql -qc "'foobar_17_7613'" 447s ok 4 - log an error 447s ok 5 - grep --binary-files=text foobar_17_7613 /var/log/postgresql/postgresql-17-main.log 447s ok 6 - error appears in logfile 447s ok 7 - pg_conftool 17 main set log_destination syslog 447s ok 8 - set log_destination syslog 448s ok 9 - pg_ctlcluster 17 main reload 448s ok 10 - 17 main reload 448s ok 11 - psql -Atc "show log_destination" 448s ok 12 - log_destination is syslog 448s ok 13 - pg_lscluster reports syslog 448s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 448s ok 15 - error appears in /var/log/syslog 448s ok 16 - pg_conftool 17 main set logging_collector on 448s ok 17 - set logging_collector on 448s ok 18 - pg_conftool 17 main set log_destination csvlog 448s ok 19 - set log_destination csvlog 451s ok 20 - pg_ctlcluster 17 main restart 451s ok 21 - 17 main restart 451s ok 22 - psql -Atc "show logging_collector" 451s ok 23 - logging_collector is on 451s ok 24 - psql -Atc "show log_destination" 451s ok 25 - log_destination is csvlog 451s ok 26 - pg_lscluster reports csvlog 451s ok 27 - psql -qc "'barbaz_17_7613'" 451s ok 28 - log an error 451s ok 29 - grep --binary-files=text barbaz_17_7613 /var/lib/postgresql/17/main/log/*.csv 451s ok 30 - error appears in log/*.csv 451s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 451s ok 32 - set log_destination stderr,syslog,csvlog 451s ok 33 - pg_ctlcluster 17 main reload 451s ok 34 - 17 main reload 451s ok 35 - psql -Atc "show log_destination" 451s ok 36 - log_destination is stderr,syslog,csvlog 452s ok 37 - pg_lscluster reports stderr,syslog,csvlog 452s ok 38 - psql -qc "'moo_17_7613'" 452s ok 39 - log an error 452s ok 40 - grep --binary-files=text moo_17_7613 /var/lib/postgresql/17/main/log/*.log 452s ok 41 - error appears in log/*.log 453s ok 42 - grep --binary-files=text 'postgres.*moo_17_7613' /var/log/syslog 453s ok 43 - error appears in /var/log/syslog 453s ok 44 - grep --binary-files=text moo_17_7613 /var/lib/postgresql/17/main/log/*.csv 453s ok 45 - error appears in log/*.csv 454s ok 46 - pg_dropcluster 17 main --stop 454s ok 47 - pg_dropcluster removes cluster 454s # Cleanup 454s ok 48 - Cleanup: No clusters left behind 454s ok 49 - No postgres processes left behind 454s ok 50 - No files in /etc/postgresql left behind 454s ok 51 - No files in /var/lib/postgresql left behind 454s ok 52 - No files in /var/run/postgresql left behind 454s ok 53 - No files in /var/log/postgresql left behind 454s ok 54 - PostgreSQL TCP ports are closed 454s ok 55 - Next free port is 5432 454s ### End test 025_logging.t ### 454s 454s ### PostgreSQL test 027_jit.t ### 454s # 17 458s ok 1 - pg_createcluster 17 main --start 458s ok 2 - psql -Xatc 'show jit' 458s ok 3 - JIT is on by default 458s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 458s ok 5 - No JIT on cheap query 458s ok 6 - pg_conftool 17 main set seq_page_cost 100000 458s ok 7 - pg_conftool 17 main set random_page_cost 100000 458s ok 8 - pg_ctlcluster 17 main reload 458s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 458s ok 10 - Expensive query is JITed 460s ok 11 - pg_dropcluster --stop 17 main 460s # Cleanup 460s ok 12 - Cleanup: No clusters left behind 460s ok 13 - No postgres processes left behind 460s ok 14 - No files in /etc/postgresql left behind 460s ok 15 - No files in /var/lib/postgresql left behind 460s ok 16 - No files in /var/run/postgresql left behind 460s ok 17 - No files in /var/log/postgresql left behind 460s ok 18 - PostgreSQL TCP ports are closed 460s ok 19 - Next free port is 5432 460s 1..19 460s ### End test 027_jit.t ### 460s 460s ### PostgreSQL test 030_errors.t ### 460s 1..156 460s ok 1 - pg_lscluster reports cluster without binaries 462s ok 2 - pg_dropcluster 6.3 main 463s ok 3 - pg_createcluster --socketdir 463s ok 4 - pg_lsclusters -h 463s ok 5 - cluster was created 463s ok 6 - Port of created cluster is 5432 463s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 463s ok 8 - pg_createcluster on existing cluster 463s ok 9 - pg_lsclusters -h 463s ok 10 - original cluster still exists 463s ok 11 - pg_createcluster 17 test -p foo 463s ok 12 - pg_createcluster -p checks that port option is numeric 463s ok 13 - pg_createcluster 17 test -p 42 463s ok 14 - pg_createcluster -p checks valid port range 463s ok 15 - pg_ctlcluster 17 main start 463s ok 16 - pg_ctlcluster refuses to start root-owned cluster 463s ok 17 - pg_ctlcluster 17 main start 463s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 463s ok 19 - pg_ctlcluster 17 main start 463s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 463s ok 21 - pg_ctlcluster 17 main start 463s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 465s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 465s ok 24 - No sockets in /var/run/postgresql 465s ok 25 - Socket is in /tmp/postgresql-testsuite/ 466s ok 26 - cluster stops with custom unix_socket_dir 466s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 468s ok 28 - cluster starts after removing unix_socket_dir 468s ok 29 - Socket is in default dir /var/run/postgresql 468s ok 30 - No sockets in /tmp/postgresql-testsuite/ 468s ok 31 - pg_ctlcluster 17 main stop 468s ok 32 - pg_ctlcluster fails with corrupted PID file 468s ok 33 - pg_lsclusters -h 468s ok 34 - cluster is still online 468s ok 35 - pg_ctlcluster succeeds with restored PID file 468s ok 36 - pg_lsclusters -h 468s ok 37 - cluster is down 468s ok 38 - pg_ctlcluster 17 main stop 468s ok 39 - pg_ctlcluster stop fails on stopped cluster 470s ok 40 - pg_ctlcluster 17 main start 470s ok 41 - pg_ctlcluster succeeds with already existing PID file 470s ok 42 - pg_lsclusters -h 470s ok 43 - cluster is online 471s ok 44 - pg_ctlcluster stop succeeds 471s ok 45 - pg_lsclusters -h 471s ok 46 - cluster is down 471s ok 47 - no pid file left 471s ok 48 - pg_ctlcluster 17 main stop 471s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 471s ok 50 - pid file was cleaned up 471s ok 51 - pg_ctlcluster --force 17 main stop 471s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 471s ok 53 - pid file was cleaned up 471s ok 54 - pg_ctlcluster 17 main stop 471s ok 55 - pg_ctlcluster stop succeeds with stale PID file 471s ok 56 - pid file was cleaned up 471s ok 57 - pg_ctlcluster --force 17 main stop 471s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 471s ok 59 - pid file was cleaned up 471s ok 60 - pg_ctlcluster --force 17 main stop 471s ok 61 - pg_ctlcluster stop succeeds with empty PID file 471s ok 62 - pid file was cleaned up 473s ok 63 - pg_ctlcluster 17 main start 473s ok 64 - pg_ctlcluster succeeds with corrupted PID file 473s ok 65 - pg_lsclusters -h 473s ok 66 - cluster is online 473s ok 67 - pg_ctlcluster 17 main start 473s ok 68 - pg_ctlcluster start fails on running cluster 473s ok 69 - pg_ctlcluster stop 473s ok 70 - pg_ctlcluster 17 main start 473s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 474s ok 72 - pg_ctlcluster 17 main stop 474s ok 73 - stopping cluster 480s ok 74 - pg_ctlcluster 17 main start 480s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 480s ok 76 - pg_ctlcluster 17 main stop 480s ok 77 - stopping cluster 480s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 480s ok 79 - pg_dropcluster 17 main 480s ok 80 - pg_dropcluster works as user postgres 481s ok 81 - pg_createcluster succeeds 481s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 481s ok 83 - proper error message for nonexisting /var/lib/postgresql 483s ok 84 - pg_ctlcluster 17 main start 483s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 483s ok 86 - pg_ctlcluster 17 main stop 483s ok 87 - stopping cluster 484s ok 88 - pg_createcluster other 487s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 489s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 489s ok 91 489s ok 92 - pg_ctlcluster 17 other start 489s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 489s ok 94 - pg_ctlcluster 17 main stop 489s ok 95 - stopping main cluster 491s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 493s ok 97 - pg_dropcluster other 494s ok 98 - pg_dropcluster 494s ok 99 - No sockets any more 494s ok 100 - 'pg_lsclusters 4.5 foo' fails 494s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 494s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 494s ok 103 - 'psql --cluster 4.5/foo' fails 494s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 494s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 495s ok 106 - 'psql --cluster 17/foo' fails 495s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 495s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 495s ok 109 - 'pg_dropcluster 4.5 foo' fails 495s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 495s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 495s ok 112 - 'pg_dropcluster 17 foo' fails 495s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 495s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 495s ok 115 - 'pg_upgradecluster 4.5 foo' fails 495s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 495s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 495s ok 118 - 'pg_upgradecluster 17 foo' fails 495s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 495s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 495s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 495s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 495s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 495s ok 124 - 'pg_ctlcluster 17 foo stop' fails 495s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 495s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 495s # Cleanup 495s ok 127 - Cleanup: No clusters left behind 495s ok 128 - No postgres processes left behind 495s ok 129 - No files in /etc/postgresql left behind 495s ok 130 - No files in /var/lib/postgresql left behind 495s ok 131 - No files in /var/run/postgresql left behind 495s ok 132 - No files in /var/log/postgresql left behind 495s ok 133 - PostgreSQL TCP ports are closed 495s ok 134 - Next free port is 5432 496s ok 135 - pg_dropcluster 17 broken 496s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 496s # Cleanup 496s ok 137 - Cleanup: No clusters left behind 496s ok 138 - No postgres processes left behind 496s ok 139 - No files in /etc/postgresql left behind 496s ok 140 - No files in /var/lib/postgresql left behind 496s ok 141 - No files in /var/run/postgresql left behind 496s ok 142 - No files in /var/log/postgresql left behind 496s ok 143 - PostgreSQL TCP ports are closed 496s ok 144 - Next free port is 5432 497s ok 145 - pg_dropcluster 17 broken 497s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 497s ok 147 - /etc/postgresql/17 was removed 497s ok 148 - /var/lib/postgresql/17 was removed 497s # Cleanup 497s ok 149 - Cleanup: No clusters left behind 498s ok 150 - No postgres processes left behind 498s ok 151 - No files in /etc/postgresql left behind 498s ok 152 - No files in /var/lib/postgresql left behind 498s ok 153 - No files in /var/run/postgresql left behind 498s ok 154 - No files in /var/log/postgresql left behind 498s ok 155 - PostgreSQL TCP ports are closed 498s ok 156 - Next free port is 5432 498s ### End test 030_errors.t ### 498s 498s ### PostgreSQL test 031_errors_disk_full.t ### 498s 1..22 498s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 499s ok 1 - script failed 499s ok 2 - pg_createcluster fails due to insufficient disk space 499s ok 3 - does not leave files behind 499s # Cleanup 499s ok 4 - Cleanup: No clusters left behind 499s ok 5 - No postgres processes left behind 499s ok 6 - No files in /etc/postgresql left behind 499s ok 7 - No files in /var/lib/postgresql left behind 499s ok 8 - No files in /var/run/postgresql left behind 499s ok 9 - No files in /var/log/postgresql left behind 499s ok 10 - PostgreSQL TCP ports are closed 499s ok 11 - Next free port is 5432 499s # check disk full conditions on startup 502s ok 12 - script failed 502s ok 13 - pg_ctlcluster prints error message 502s ok 14 - log file has error message 502s # Cleanup 502s ok 15 - Cleanup: No clusters left behind 502s ok 16 - No postgres processes left behind 502s ok 17 - No files in /etc/postgresql left behind 502s ok 18 - No files in /var/lib/postgresql left behind 502s ok 19 - No files in /var/run/postgresql left behind 502s ok 20 - No files in /var/log/postgresql left behind 502s ok 21 - PostgreSQL TCP ports are closed 502s ok 22 - Next free port is 5432 502s ### End test 031_errors_disk_full.t ### 502s 502s ### PostgreSQL test 032_ssl_key_permissions.t ### 502s 1..22 502s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 502s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 502s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 502s # 17 (17.2-1) 503s ok 4 - pg_createcluster 17 main 503s ok 5 - pg_ctlcluster 17 main start 503s ok 6 - ssl key owned by nobody refused 503s ok 7 - pg_ctlcluster 17 main start 503s ok 8 - ssl key with permissions root:root 0644 refused 503s ok 9 - pg_ctlcluster 17 main start 503s ok 10 - ssl key with permissions postgres:postgres 0640 refused 505s ok 11 - pg_dropcluster 17 main --stop 505s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 505s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 505s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 505s # Cleanup 505s ok 15 - Cleanup: No clusters left behind 505s ok 16 - No postgres processes left behind 505s ok 17 - No files in /etc/postgresql left behind 505s ok 18 - No files in /var/lib/postgresql left behind 505s ok 19 - No files in /var/run/postgresql left behind 505s ok 20 - No files in /var/log/postgresql left behind 505s ok 21 - PostgreSQL TCP ports are closed 505s ok 22 - Next free port is 5432 505s ### End test 032_ssl_key_permissions.t ### 505s 505s ### PostgreSQL test 040_upgrade.t ### 505s 1..1 505s ok 1 - only one major version installed, skipping upgrade tests 505s ### End test 040_upgrade.t ### 505s 505s ### PostgreSQL test 041_upgrade_custompaths.t ### 505s 1..1 505s ok 1 - only one major version installed, skipping upgrade tests 505s ### End test 041_upgrade_custompaths.t ### 505s 505s ### PostgreSQL test 042_upgrade_rename.t ### 505s 1..15 505s # PostgreSQL 17 508s ok 1 - pg_createcluster 17 main --start 515s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 515s ok 3 - pg_lsclusters -h 515s ok 4 - correct output of pg_lsclusters -h 516s ok 5 - pg_dropcluster 17 main --stop 517s ok 6 - pg_dropcluster 17 upgr --stop 517s ok 7 - Cleaning pg_upgrade log files 517s # Cleanup 517s ok 8 - Cleanup: No clusters left behind 517s ok 9 - No postgres processes left behind 517s ok 10 - No files in /etc/postgresql left behind 517s ok 11 - No files in /var/lib/postgresql left behind 517s ok 12 - No files in /var/run/postgresql left behind 517s ok 13 - No files in /var/log/postgresql left behind 517s ok 14 - PostgreSQL TCP ports are closed 517s ok 15 - Next free port is 5432 517s ### End test 042_upgrade_rename.t ### 517s 517s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 517s 1..1 517s ok 1 - only one major version installed, skipping upgrade tests 517s ### End test 043_upgrade_ssl_cert.t ### 517s 517s ### PostgreSQL test 045_backup.t ### 517s # We are running systemd 517s # PostgreSQL 17 517s # create cluster 521s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 521s ok 2 - pg_lsclusters -h 521s ok 3 - correct output of pg_lsclusters -h 521s ok 4 - pg_conftool 17 main set work_mem 11MB 521s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 521s ok 6 - psql -c 'alter database mydb set search_path=public' 521s ok 7 - psql -c 'create table foo (t text)' mydb 521s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 521s ok 9 - psql -c 'CREATE USER myuser' 521s ok 10 - psql -c 'grant create on database mydb to myuser' 521s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 521s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 521s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 521s # create directory 521s ok 14 - pg_backupcluster 17 main createdirectory 521s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 521s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 521s # dump 522s ok 17 - systemctl start pg_dump@17-main 522s ok 18 - dump created in /var/backups/postgresql/17-main/2025-01-16T115348Z.dump 522s ok 19 - /var/backups/postgresql/17-main/2025-01-16T115348Z.dump owned by uid postgres 522s ok 20 - /var/backups/postgresql/17-main/2025-01-16T115348Z.dump owned by gid postgres 522s # basebackup 522s ok 21 - systemctl start pg_receivewal@17-main 522s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 523s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 523s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 523s ok 25 - psql -c 'select pg_reload_conf()' 551s ok 26 - systemctl start pg_basebackup@17-main 551s ok 27 - dump created in /var/backups/postgresql/17-main/2025-01-16T115350Z.backup 551s ok 28 - /var/backups/postgresql/17-main/2025-01-16T115350Z.backup owned by uid postgres 551s ok 29 - /var/backups/postgresql/17-main/2025-01-16T115350Z.backup owned by gid postgres 551s # list 551s ok 30 - pg_backupcluster 17 main list 551s ok 31 - correct output of pg_backupcluster 17 main list 551s # more database changes 551s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 551s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 551s ok 34 - retrieve recovery timestamp 551s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 551s ok 36 - systemctl stop pg_receivewal@17-main 551s # restore /var/backups/postgresql/17-main/2025-01-16T115348Z.dump 553s ok 37 - pg_dropcluster 17 main --stop 557s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T115348Z.dump --start --datadir /var/lib/postgresql/17/snowflake 557s ok 39 - pg_lsclusters -h 557s ok 40 - correct output of pg_lsclusters -h 557s ok 41 - psql -XAtl 557s ok 42 - mydb locales 557s ok 43 - mydb grants 557s ok 44 - myicudb locales 557s ok 45 - psql -XAtc 'show work_mem' 557s ok 46 - correct output of psql -XAtc 'show work_mem' 557s ok 47 - psql -XAtc 'select * from foo' mydb 557s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 558s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 558s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 558s ok 51 - psql -XAtc '\drds' 558s ok 52 - correct output of psql -XAtc '\drds' 558s # restore /var/backups/postgresql/17-main/2025-01-16T115350Z.backup 559s ok 53 - pg_dropcluster 17 main --stop 563s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T115350Z.backup --start --datadir /var/lib/postgresql/17/snowflake 563s ok 55 - pg_lsclusters -h 563s ok 56 - correct output of pg_lsclusters -h 563s ok 57 - psql -XAtl 563s ok 58 - mydb locales 563s ok 59 - mydb grants 563s ok 60 - myicudb locales 563s ok 61 - psql -XAtc 'show work_mem' 563s ok 62 - correct output of psql -XAtc 'show work_mem' 563s ok 63 - psql -XAtc 'select * from foo' mydb 563s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 563s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 563s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 563s ok 67 - psql -XAtc '\drds' 563s ok 68 - correct output of psql -XAtc '\drds' 563s # restore /var/backups/postgresql/17-main/2025-01-16T115350Z.backup with WAL archive 564s ok 69 - pg_dropcluster 17 main --stop 568s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T115350Z.backup --start --archive --port 5430 568s ok 71 - pg_lsclusters -h 568s ok 72 - correct output of pg_lsclusters -h 568s ok 73 - psql -XAtc 'select * from foo order by t' mydb 568s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 568s # restore /var/backups/postgresql/17-main/2025-01-16T115350Z.backup with PITR 570s ok 75 - pg_dropcluster 17 main --stop 573s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-16T115350Z.backup --start --pitr '2025-01-16 11:54:18.186669+00 573s # ' 573s ok 77 - pg_lsclusters -h 573s ok 78 - correct output of pg_lsclusters -h 573s ok 79 - psql -XAtc 'select * from foo order by t' mydb 573s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 575s ok 81 - pg_dropcluster 17 main --stop 575s # Cleanup 575s ok 82 - Cleanup: No clusters left behind 575s ok 83 - No postgres processes left behind 575s ok 84 - No files in /etc/postgresql left behind 575s ok 85 - No files in /var/lib/postgresql left behind 575s ok 86 - No files in /var/run/postgresql left behind 575s ok 87 - No files in /var/log/postgresql left behind 575s ok 88 - PostgreSQL TCP ports are closed 575s ok 89 - Next free port is 5432 575s 1..89 575s ### End test 045_backup.t ### 575s 575s ### PostgreSQL test 050_encodings.t ### 575s 1..60 575s # Checking 17 ru_RU 578s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 579s ok 2 - psql -l succeeds 579s ok 3 - template1 is not UTF-8 encoded 579s ok 4 - creating test database 579s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 579s # create table t (x varchar); copy t from stdin" test 579s ok 6 - creating table with ISO-8859-5 characters 579s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 579s ok 8 - correct string in UTF-8 579s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 579s ok 10 - correct string in ISO-8859-5 579s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 579s # delete from t; copy t from stdin" test 579s ok 12 - creating table with UTF-8 characters 580s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 580s ok 14 - correct string in UTF-8 580s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 580s ok 16 - correct string in ISO-8859-1 580s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 580s ok 18 - Server error message has correct language and encoding 582s ok 19 - pg_ctlcluster 17 ru_RU restart 582s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 584s ok 21 - Dropping cluster 584s # Checking 17 ru_RU.UTF-8 587s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 588s ok 23 - psql -l succeeds 588s ok 24 - template1 is UTF-8 encoded 588s ok 25 - creating test database 588s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 588s # create table t (x varchar); copy t from stdin" test 588s ok 27 - creating table with ISO-8859-5 characters 588s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 588s ok 29 - correct string in UTF-8 588s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 588s ok 31 - correct string in ISO-8859-5 588s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 588s # delete from t; copy t from stdin" test 588s ok 33 - creating table with UTF-8 characters 588s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 588s ok 35 - correct string in UTF-8 588s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 588s ok 37 - correct string in ISO-8859-1 588s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 588s ok 39 - Server error message has correct language and encoding 591s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 591s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 591s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 591s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 591s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 591s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 591s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 591s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 592s ok 48 - Dropping cluster 592s # Check 17 locale environment variables 596s ok 49 - pg_createcluster: LC_ALL dominates LANG 596s ok 50 - psql -Atl --cluster 17/main 596s ok 51 - template1 is ASCII encoded 597s ok 52 - Dropping cluster 597s # Cleanup 597s ok 53 - Cleanup: No clusters left behind 597s ok 54 - No postgres processes left behind 597s ok 55 - No files in /etc/postgresql left behind 597s ok 56 - No files in /var/lib/postgresql left behind 597s ok 57 - No files in /var/run/postgresql left behind 597s ok 58 - No files in /var/log/postgresql left behind 597s ok 59 - PostgreSQL TCP ports are closed 597s ok 60 - Next free port is 5432 597s ### End test 050_encodings.t ### 597s 597s ### PostgreSQL test 052_upgrade_encodings.t ### 597s 1..1 597s ok 1 - only one major version installed, skipping upgrade tests 597s ### End test 052_upgrade_encodings.t ### 597s 597s ### PostgreSQL test 060_obsolete_confparams.t ### 597s ok 1 - only one major version installed, skipping upgrade tests 597s 1..1 597s ### End test 060_obsolete_confparams.t ### 597s 597s ### PostgreSQL test 070_non_postgres_clusters.t ### 597s 1..40 598s ok 1 - pg_createcluster 17 main for owner nobody 598s ok 2 - pg_ctlcluster 17 main start 598s ok 3 - start refused when config and data owners mismatch 601s ok 4 - pg_ctlcluster succeeds with owner nobody 601s ok 5 - pg_lsclusters -h 601s ok 6 - pg_lsclusters shows running cluster 601s ok 7 - postgres is running as user nobody 601s ok 8 - ls /tmp/.s.PGSQL.* 601s ok 9 - socket is in /tmp 601s ok 10 - /var/run/postgresql is empty 601s ok 11 - conf dir is owned by user 601s ok 12 - conf dir is owned by user's primary group 601s ok 13 - files are owned by user 601s ok 14 - files are owned by user's primary group 601s ok 15 - log file has 0640 permissions 601s ok 16 - log file is owned by user 601s ok 17 - log file is owned by user's primary group 601s ok 18 - only one major version installed, skipping upgrade test 601s ok 19 - ... 601s ok 20 - ... 601s ok 21 - ... 601s ok 22 - ... 601s ok 23 - ... 601s ok 24 - ... 601s ok 25 - ... 601s ok 26 - ... 601s ok 27 - ... 601s ok 28 - ... 602s ok 29 - pg_dropcluster 602s ok 30 - pg_lsclusters -h 602s ok 31 - No clusters left 602s ok 32 - No postgres processes left 602s # Cleanup 602s ok 33 - Cleanup: No clusters left behind 602s ok 34 - No postgres processes left behind 602s ok 35 - No files in /etc/postgresql left behind 602s ok 36 - No files in /var/lib/postgresql left behind 602s ok 37 - No files in /var/run/postgresql left behind 602s ok 38 - No files in /var/log/postgresql left behind 602s ok 39 - PostgreSQL TCP ports are closed 602s ok 40 - Next free port is 5432 602s ### End test 070_non_postgres_clusters.t ### 602s 602s ### PostgreSQL test 080_start.conf.t ### 602s 1..73 603s ok 1 - pg_createcluster 17 main 603s # start.conf auto 603s ok 2 - get_cluster_start_conf returns auto 603s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 603s ok 4 - start.conf contains auto 603s ok 5 - systemd generator links cluster 603s ok 6 - systemd generator links correct service file 606s ok 7 - /etc/init.d/postgresql start 17 606s ok 8 - correct output of /etc/init.d/postgresql start 17 606s ok 9 - pg_lsclusters -h 606s ok 10 - cluster is online 606s ok 11 - /etc/init.d/postgresql stop 17 606s ok 12 - correct output of /etc/init.d/postgresql stop 17 609s ok 13 - pg_lsclusters -h 609s ok 14 - cluster is down 609s # start.conf manual 609s ok 15 - get_cluster_start_conf returns manual 609s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 609s ok 17 - start.conf contains manual 609s ok 18 - systemd generator doesn't link cluster 609s ok 19 - /etc/init.d/postgresql start 17 609s ok 20 - correct output of /etc/init.d/postgresql start 17 609s ok 21 - pg_lsclusters -h 609s ok 22 - cluster is down 611s ok 23 - pg_ctlcluster 17 main start 611s ok 24 - correct output of pg_ctlcluster 17 main start 611s ok 25 - pg_lsclusters -h 611s ok 26 - cluster is online 612s ok 27 - pg_ctlcluster 17 main stop 612s ok 28 - correct output of pg_ctlcluster 17 main stop 612s ok 29 - pg_lsclusters -h 612s ok 30 - cluster is down 612s # start.conf disabled 612s ok 31 - get_cluster_start_conf returns disabled 612s ok 32 - systemd generator doesn't link cluster 612s ok 33 - /etc/init.d/postgresql start 17 612s ok 34 - correct output of /etc/init.d/postgresql start 17 612s ok 35 - pg_lsclusters -h 612s ok 36 - cluster is down 612s ok 37 - pg_ctlcluster 17 main start 612s ok 38 - correct output of pg_ctlcluster 17 main start 612s ok 39 - pg_lsclusters -h 612s ok 40 - cluster is down 614s ok 41 - pg_ctlcluster 17 main start 614s ok 42 - correct output of pg_ctlcluster 17 main start 614s ok 43 - pg_lsclusters -h 614s ok 44 - cluster is online 614s ok 45 - pg_ctlcluster 17 main stop 614s ok 46 - correct output of pg_ctlcluster 17 main stop 614s ok 47 - pg_lsclusters -h 614s ok 48 - cluster is down 617s ok 49 - pg_ctlcluster 17 main start 617s ok 50 - correct output of pg_ctlcluster 17 main start 617s ok 51 - pg_lsclusters -h 617s ok 52 - cluster is online 617s # test upgrade 617s ok 53 - only one major version installed, skipping upgrade test 617s ok 54 - ... 617s ok 55 - get_cluster_start_conf for old cluster returns manual 617s ok 56 - get_cluster_start_conf for new cluster returns manual 617s ok 57 - ... 618s ok 58 - dropping upgraded cluster 618s ok 59 - pg_lsclusters -h 618s ok 60 - no clusters any more 618s ok 61 - pg_createcluster 17 main --start-conf foo 618s ok 62 - pg_createcluster checks --start-conf validity 619s ok 63 - pg_createcluster checks --start-conf manual 619s ok 64 - get_cluster_start_conf returns manual 620s ok 65 - dropping cluster 620s # Cleanup 620s ok 66 - Cleanup: No clusters left behind 620s ok 67 - No postgres processes left behind 620s ok 68 - No files in /etc/postgresql left behind 620s ok 69 - No files in /var/lib/postgresql left behind 620s ok 70 - No files in /var/run/postgresql left behind 620s ok 71 - No files in /var/log/postgresql left behind 620s ok 72 - PostgreSQL TCP ports are closed 620s ok 73 - Next free port is 5432 620s ### End test 080_start.conf.t ### 620s 620s ### PostgreSQL test 085_pg_ctl.conf.t ### 620s 1..33 620s ok 1 - prlimit --core=0:unlimited --pid=16509 620s ok 2 - set core file size to unlimited 620s ok 3 - sh -c 'ulimit -Hc' 620s ok 4 - core file size is unlimited 621s ok 5 - pg_createcluster 17 main 621s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 623s ok 7 - pg_ctlcluster 17 main start 623s ok 8 - starting cluster as root 623s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 623s ok 10 - soft core size is 0 623s # hard core file size limit of root-started postgres process is unlimited 623s ok 11 - set pg_ctl default option to -c 626s ok 12 - pg_ctlcluster 17 main restart 626s ok 13 - restarting cluster as root 626s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 626s ok 15 - soft core size is unlimited 626s ok 16 - pg_ctlcluster 17 main stop 626s ok 17 - stopping cluster 626s ok 18 - restored pg_ctl default option 628s ok 19 - pg_ctlcluster 17 main start -- -c 628s ok 20 - starting cluster with -c on the command line as postgres 628s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 628s ok 22 - soft core size is unlimited 628s ok 23 - pg_ctlcluster 17 main stop 628s ok 24 - stopping cluster 630s ok 25 - dropping cluster 630s # Cleanup 630s ok 26 - Cleanup: No clusters left behind 630s ok 27 - No postgres processes left behind 630s ok 28 - No files in /etc/postgresql left behind 630s ok 29 - No files in /var/lib/postgresql left behind 630s ok 30 - No files in /var/run/postgresql left behind 630s ok 31 - No files in /var/log/postgresql left behind 630s ok 32 - PostgreSQL TCP ports are closed 630s ok 33 - Next free port is 5432 630s ### End test 085_pg_ctl.conf.t ### 630s 630s ### PostgreSQL test 090_multicluster.t ### 630s 1..125 631s ok 1 - pg_createcluster 17 old 632s ok 2 - pg_createcluster 17 new1 633s ok 3 - pg_createcluster 17 new2 635s ok 4 - starting cluster 17/old 637s ok 5 - starting cluster 17/new1 640s ok 6 - starting cluster 17/new2 640s ok 7 - pg_lsclusters -h | sort -k3 640s ok 8 - clusters have the correct ports, skipping used 5433 640s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 640s ok 10 - createdb --version 640s ok 11 - pg_wrapper selects port 5432 as default cluster 640s ok 12 - createdb --cluster 17/new1 --version 640s ok 13 - pg_wrapper --cluster works 640s ok 14 - createdb --cluster 17/foo --version 640s ok 15 - pg_wrapper --cluster errors out for invalid cluster 640s ok 16 - createdb --cluster 17/new1 test 640s ok 17 - correct output of createdb --cluster 17/new1 test 640s ok 18 - psql -Atl --cluster 17/new1 640s ok 19 - test db appears in cluster new1 640s ok 20 - psql -Atl --cluster 17/new2 640s ok 21 - test db does not appear in cluster new2 640s ok 22 - psql -Atl 640s ok 23 - test db does not appear in default cluster 640s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 640s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 640s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 640s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 640s ok 28 - psql -Atl --cluster 17/localhost:5434 640s ok 29 - test db appears in cluster 17/localhost:5434 640s ok 30 - psql -Atl --cluster 17/localhost:5440 640s ok 31 - test db does not appear in cluster 17/localhost:5440 640s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 640s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 640s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 640s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 640s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 640s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 640s ok 38 - psql -Atl --cluster 6.4/localhost: 640s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 640s ok 40 - psql -Atl 640s ok 41 - PGCLUSTER selection (1) 640s ok 42 - psql -Atl 640s ok 43 - PGCLUSTER selection (2) 640s ok 44 - psql -l 640s ok 45 - invalid PGCLUSTER value 641s ok 46 - createdb --version 641s ok 47 - PGCLUSTER network cluster selection (1) 641s ok 48 - psql -Atl 641s ok 49 - PGCLUSTER network cluster selection (2) 641s ok 50 - psql -Atl 641s ok 51 - PGCLUSTER network cluster selection (3) 641s ok 52 - LC_MESSAGES=C psql -Atl 641s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 641s ok 54 - psql -Atc "show port" template1 641s ok 55 - PGPORT selection (1) 641s ok 56 - psql -Atc "show port" template1 641s ok 57 - PGPORT selection (2) 641s ok 58 - createdb --version 641s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 641s ok 60 - psql -Atc "show port" template1 641s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 641s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 641s ok 63 - PGDATABASE environment variable works 641s ok 64 - createdb --version 641s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 641s ok 66 - createdb --cluster 17/new1 --version 641s ok 67 - pg_wrapper --cluster works with empty user_clusters 641s ok 68 - createdb --version 641s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 641s ok 70 - psql -Atc "select current_database()" 641s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 641s ok 72 - psql -Atc 'select current_database()' 641s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 641s ok 74 - createdb --version 641s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 641s ok 76 - createdb --version 641s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 641s ok 78 - createdb --version 641s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 641s ok 80 - createdb --version 641s ok 81 - pg_wrapper selects correct version with per-user user_clusters 641s ok 82 - createdb --version 641s ok 83 - pg_wrapper selects correct version with per-user user_clusters 641s ok 84 - createdb --version 641s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 641s ok 86 - psql -Atl 641s ok 87 - $PGHOST overrides user_clusters 641s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 641s ok 89 - --cluster overrides $PGHOST 641s ok 90 - createdb --version 641s ok 91 - pg_wrapper ignores invalid lines in user_clusters 641s ok 92 - psql -Atc 'select current_database()' 641s ok 93 - pg_service conf selection 1 642s ok 94 - psql -Atc 'select current_database()' 642s ok 95 - pg_service conf selection 2 642s ok 96 - psql -Atc 'select current_database()' 642s ok 97 - pg_service conf selection 3 642s ok 98 - stopping cluster 17/old 644s ok 99 - restarting cluster 17/old 644s ok 100 - pg_lsclusters -h | sort -k3 644s ok 101 - port of first cluster was successfully changed 644s ok 102 - psql -l 644s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 644s ok 104 - psql -Atl --cluster 17/new1 644s ok 105 - --cluster selects appropriate cluster 644s ok 106 - psql -Atl -p 5434 644s ok 107 - -p selects appropriate cluster 644s ok 108 - psql -Atlp 5434 644s ok 109 - -Atlp selects appropriate cluster 644s ok 110 - psql -Atl --port 5434 644s ok 111 - --port selects appropriate cluster 644s ok 112 - env PGPORT=5434 psql -Atl 644s ok 113 - $PGPORT selects appropriate cluster 644s ok 114 - Restoring original /etc/postgresql-common/user_clusters 646s ok 115 - dropping 17/new1 648s ok 116 - dropping 17/new2 649s ok 117 - dropping 17/old 649s # Cleanup 649s ok 118 - Cleanup: No clusters left behind 649s ok 119 - No postgres processes left behind 649s ok 120 - No files in /etc/postgresql left behind 649s ok 121 - No files in /var/lib/postgresql left behind 649s ok 122 - No files in /var/run/postgresql left behind 649s ok 123 - No files in /var/log/postgresql left behind 649s ok 124 - PostgreSQL TCP ports are closed 649s ok 125 - Next free port is 5432 649s ### End test 090_multicluster.t ### 649s 649s ### PostgreSQL test 110_integrate_cluster.t ### 649s 1..32 650s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/ZhnX2LvpR4/c/postgres 650s ok 2 - creating raw initdb cluster for user postgres 651s ok 3 - pg_createcluster 17 postgres -d /tmp/ZhnX2LvpR4/c/postgres 651s ok 4 - integrating postgres cluster 651s ok 5 - pg_lsclusters 651s ok 6 - correct pg_lsclusters output 653s ok 7 - pg_ctlcluster 17 postgres start 653s ok 8 - starting cluster postgres 653s ok 9 - pg_lsclusters 653s ok 10 - correct pg_lsclusters output 654s ok 11 - dropping cluster postgres 654s ok 12 - No files in temporary cluster dir left behind 655s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/ZhnX2LvpR4/c/nobody 655s ok 14 - creating raw initdb cluster for user nobody 656s ok 15 - pg_createcluster 17 nobody -d /tmp/ZhnX2LvpR4/c/nobody 656s ok 16 - integrating nobody cluster 656s ok 17 - pg_lsclusters 656s ok 18 - correct pg_lsclusters output 658s ok 19 - pg_ctlcluster 17 nobody start 658s ok 20 - starting cluster nobody 658s ok 21 - pg_lsclusters 658s ok 22 - correct pg_lsclusters output 659s ok 23 - dropping cluster nobody 659s ok 24 - No files in temporary cluster dir left behind 659s # Cleanup 659s ok 25 - Cleanup: No clusters left behind 659s ok 26 - No postgres processes left behind 659s ok 27 - No files in /etc/postgresql left behind 659s ok 28 - No files in /var/lib/postgresql left behind 659s ok 29 - No files in /var/run/postgresql left behind 659s ok 30 - No files in /var/log/postgresql left behind 659s ok 31 - PostgreSQL TCP ports are closed 659s ok 32 - Next free port is 5432 659s ### End test 110_integrate_cluster.t ### 659s 659s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 659s 1..1 659s ok 1 - only one major version installed, skipping upgrade tests 659s ### End test 120_pg_upgradecluster_scripts.t ### 659s 659s ### PostgreSQL test 130_nonroot_admin.t ### 660s 1..22 662s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 662s ok 2 - pg_lsclusters -h 662s ok 3 - correct output of pg_lsclusters -h 662s ok 4 - psql -Atl 662s ok 5 - correct output of psql -Atl 663s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 663s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 663s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 663s # Cleanup 663s ok 15 - Cleanup: No clusters left behind 663s ok 16 - No postgres processes left behind 663s ok 17 - No files in /etc/postgresql left behind 663s ok 18 - No files in /var/lib/postgresql left behind 663s ok 19 - No files in /var/run/postgresql left behind 663s ok 20 - No files in /var/log/postgresql left behind 663s ok 21 - PostgreSQL TCP ports are closed 663s ok 22 - Next free port is 5432 663s ### End test 130_nonroot_admin.t ### 663s 663s ### PostgreSQL test 135_pg_virtualenv.t ### 663s 1..20 668s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 668s ok 2 - running pg_virtualenv as root 671s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 671s ok 4 - running pg_virtualenv as postgres 674s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 674s ok 6 - running pg_virtualenv as nobody 677s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 677s ok 8 - running fakeroot pg_virtualenv as root 681s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 681s ok 10 - running fakeroot pg_virtualenv as postgres 684s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 684s ok 12 - running fakeroot pg_virtualenv as nobody 684s # Cleanup 684s ok 13 - Cleanup: No clusters left behind 684s ok 14 - No postgres processes left behind 684s ok 15 - No files in /etc/postgresql left behind 684s ok 16 - No files in /var/lib/postgresql left behind 684s ok 17 - No files in /var/run/postgresql left behind 684s ok 18 - No files in /var/log/postgresql left behind 684s ok 19 - PostgreSQL TCP ports are closed 684s ok 20 - Next free port is 5432 684s ### End test 135_pg_virtualenv.t ### 684s 684s ### PostgreSQL test 140_pg_config.t ### 684s 1..38 684s # Multiarch is enabled 684s # checking version specific output for 17 684s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 684s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 684s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 684s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 684s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 684s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 684s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 684s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 684s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 684s # checking pg_config output (should behave like version 17) 684s ok 15 - pg_config 684s ok 16 - correct output of pg_config 684s ok 17 - pg_config --help 684s ok 18 - correct output of pg_config --help 684s ok 19 - pg_config --pgxs 684s ok 20 - correct output of pg_config --pgxs 684s ok 21 - pg_config --libdir 684s ok 22 - correct output of pg_config --libdir 684s ok 23 - pg_config --pkglibdir 684s ok 24 - correct output of pg_config --pkglibdir 684s ok 25 - pg_config --bindir 684s ok 26 - correct output of pg_config --bindir 684s # checking pg_config.libpq-dev output (should behave like version 17) 684s ok 27 - pg_config.libpq-dev 684s ok 28 - correct output of pg_config.libpq-dev 684s ok 29 - pg_config.libpq-dev --help 684s ok 30 - correct output of pg_config.libpq-dev --help 684s ok 31 - pg_config.libpq-dev --pgxs 684s ok 32 - correct output of pg_config.libpq-dev --pgxs 684s ok 33 - pg_config.libpq-dev --libdir 684s ok 34 - correct output of pg_config.libpq-dev --libdir 684s ok 35 - pg_config.libpq-dev --pkglibdir 684s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 684s ok 37 - pg_config.libpq-dev --bindir 684s ok 38 - correct output of pg_config.libpq-dev --bindir 684s ### End test 140_pg_config.t ### 684s 684s ### PostgreSQL test 150_tsearch_stemming.t ### 684s 1..37 684s ok 1 - pg_updatedicts succeeded 684s ok 2 - pg_updatedicts created en_us.affix 684s ok 3 - pg_updatedicts created en_us.dict 684s ok 4 - pg_updatedicts created 17 en_us.affix symlink 684s ok 5 - pg_updatedicts created 17 en_us.dict symlink 687s ok 6 - pg_createcluster 17 main 687s ok 7 - createdb fts 687s ok 8 - correct output of createdb fts 688s ok 9 - creating en_US full text search configuration 688s ok 10 - creating data table and search index 688s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 688s ok 12 - stem search of correct word 688s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 688s ok 14 - stem search of correct word 688s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 688s ok 16 - stem search of unknown word 688s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 688s ok 18 - full text search, exact word 688s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 688s ok 20 - full text search for word stem 688s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 688s ok 22 - full text search for word substring fails 688s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 688s ok 24 - full text search, exact unicode word 688s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 688s ok 26 - full text search for unicode word stem 688s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 688s ok 28 - full text search for unicode word substring fails 690s ok 29 690s # Cleanup 690s ok 30 - Cleanup: No clusters left behind 690s ok 31 - No postgres processes left behind 690s ok 32 - No files in /etc/postgresql left behind 690s ok 33 - No files in /var/lib/postgresql left behind 690s ok 34 - No files in /var/run/postgresql left behind 690s ok 35 - No files in /var/log/postgresql left behind 690s ok 36 - PostgreSQL TCP ports are closed 690s ok 37 - Next free port is 5432 690s ### End test 150_tsearch_stemming.t ### 690s 690s ### PostgreSQL test 160_alternate_confroot.t ### 690s 1..28 693s ok 1 693s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 693s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 693s ok 4 - pg_lsclusters -h 693s ok 5 - correct output of pg_lsclusters -h 693s ok 6 - psql -Atl 693s ok 7 - correct output of psql -Atl 693s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 693s ok 9 - ... 693s ok 10 - ... 693s ok 11 - ... 693s ok 12 - ... 693s ok 13 - ... 693s ok 14 - ... 694s ok 15 - pg_dropcluster 17 test --stop 694s ok 16 - correct output of pg_dropcluster 17 test --stop 694s ok 17 - pg_lsclusters -h 694s ok 18 - correct output of pg_lsclusters -h 694s ok 19 - No files in root/data left behind 694s ok 20 - No cruft in root dir left behind 694s # Cleanup 694s ok 21 - Cleanup: No clusters left behind 694s ok 22 - No postgres processes left behind 694s ok 23 - No files in /etc/postgresql left behind 694s ok 24 - No files in /var/lib/postgresql left behind 694s ok 25 - No files in /var/run/postgresql left behind 694s ok 26 - No files in /var/log/postgresql left behind 694s ok 27 - PostgreSQL TCP ports are closed 694s ok 28 - Next free port is 5432 694s ### End test 160_alternate_confroot.t ### 694s 694s ### PostgreSQL test 170_extensions.t ### 694s # Running tests for 17 697s ok 1 - pg_createcluster 17 main 697s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 697s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 697s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 697s ok 5 - extension amcheck installs without error 697s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 697s ok 7 - extension amcheck removes without error 697s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 697s ok 9 - extension autoinc installs without error 697s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 697s ok 11 - extension autoinc removes without error 697s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 697s ok 13 - extension bloom installs without error 697s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 697s ok 15 - extension bloom removes without error 697s ok 16 - psql -qc 'CREATE EXTENSION plperl' 697s ok 17 - bool_plperl dependency plperl installs without error 697s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 697s ok 19 - extension bool_plperl installs without error 697s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 697s ok 21 - extension bool_plperl removes without error 698s ok 22 - psql -qc 'DROP EXTENSION plperl' 698s ok 23 - bool_plperl dependency extension plperl removes without error 698s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 698s ok 25 - bool_plperlu dependency plperlu installs without error 698s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 698s ok 27 - extension bool_plperlu installs without error 698s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 698s ok 29 - extension bool_plperlu removes without error 698s ok 30 - psql -qc 'DROP EXTENSION plperlu' 698s ok 31 - bool_plperlu dependency extension plperlu removes without error 698s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 698s ok 33 - extension btree_gin installs without error 698s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 698s ok 35 - extension btree_gin removes without error 698s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 698s ok 37 - extension btree_gist installs without error 698s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 698s ok 39 - extension btree_gist removes without error 698s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 698s ok 41 - extension citext installs without error 698s ok 42 - psql -qc 'DROP EXTENSION "citext"' 698s ok 43 - extension citext removes without error 698s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 698s ok 45 - extension cube installs without error 698s ok 46 - psql -qc 'DROP EXTENSION "cube"' 698s ok 47 - extension cube removes without error 698s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 698s ok 49 - extension dblink installs without error 698s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 698s ok 51 - extension dblink removes without error 698s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 698s ok 53 - extension dict_int installs without error 698s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 698s ok 55 - extension dict_int removes without error 698s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 698s ok 57 - extension dict_xsyn installs without error 698s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 698s ok 59 - extension dict_xsyn removes without error 699s ok 60 - psql -qc 'CREATE EXTENSION cube' 699s ok 61 - earthdistance dependency cube installs without error 699s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 699s ok 63 - extension earthdistance installs without error 699s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 699s ok 65 - extension earthdistance removes without error 699s ok 66 - psql -qc 'DROP EXTENSION cube' 699s ok 67 - earthdistance dependency extension cube removes without error 699s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 699s ok 69 - extension file_fdw installs without error 699s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 699s ok 71 - extension file_fdw removes without error 699s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 699s ok 73 - extension fuzzystrmatch installs without error 699s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 699s ok 75 - extension fuzzystrmatch removes without error 699s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 699s ok 77 - extension hstore installs without error 699s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 699s ok 79 - extension hstore removes without error 699s ok 80 - psql -qc 'CREATE EXTENSION hstore' 699s ok 81 - hstore_plperl dependency hstore installs without error 699s ok 82 - psql -qc 'CREATE EXTENSION plperl' 699s ok 83 - hstore_plperl dependency plperl installs without error 699s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 699s ok 85 - extension hstore_plperl installs without error 699s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 699s ok 87 - extension hstore_plperl removes without error 699s ok 88 - psql -qc 'DROP EXTENSION hstore' 699s ok 89 - hstore_plperl dependency extension hstore removes without error 699s ok 90 - psql -qc 'DROP EXTENSION plperl' 699s ok 91 - hstore_plperl dependency extension plperl removes without error 699s ok 92 - psql -qc 'CREATE EXTENSION hstore' 699s ok 93 - hstore_plperlu dependency hstore installs without error 699s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 699s ok 95 - hstore_plperlu dependency plperlu installs without error 699s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 699s ok 97 - extension hstore_plperlu installs without error 699s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 699s ok 99 - extension hstore_plperlu removes without error 700s ok 100 - psql -qc 'DROP EXTENSION hstore' 700s ok 101 - hstore_plperlu dependency extension hstore removes without error 700s ok 102 - psql -qc 'DROP EXTENSION plperlu' 700s ok 103 - hstore_plperlu dependency extension plperlu removes without error 700s ok 104 - psql -qc 'CREATE EXTENSION hstore' 700s ok 105 - hstore_plpython3u dependency hstore installs without error 700s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 700s ok 107 - hstore_plpython3u dependency plpython3u installs without error 700s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 700s ok 109 - extension hstore_plpython3u installs without error 700s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 700s ok 111 - extension hstore_plpython3u removes without error 700s ok 112 - psql -qc 'DROP EXTENSION hstore' 700s ok 113 - hstore_plpython3u dependency extension hstore removes without error 700s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 700s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 700s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 700s ok 117 - extension insert_username installs without error 700s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 700s ok 119 - extension insert_username removes without error 700s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 700s ok 121 - extension intagg installs without error 700s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 700s ok 123 - extension intagg removes without error 700s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 700s ok 125 - extension intarray installs without error 700s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 700s ok 127 - extension intarray removes without error 700s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 700s ok 129 - extension isn installs without error 700s ok 130 - psql -qc 'DROP EXTENSION "isn"' 700s ok 131 - extension isn removes without error 700s ok 132 - psql -qc 'CREATE EXTENSION plperl' 700s ok 133 - jsonb_plperl dependency plperl installs without error 701s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 701s ok 135 - extension jsonb_plperl installs without error 701s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 701s ok 137 - extension jsonb_plperl removes without error 701s ok 138 - psql -qc 'DROP EXTENSION plperl' 701s ok 139 - jsonb_plperl dependency extension plperl removes without error 701s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 701s ok 141 - jsonb_plperlu dependency plperlu installs without error 701s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 701s ok 143 - extension jsonb_plperlu installs without error 701s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 701s ok 145 - extension jsonb_plperlu removes without error 701s ok 146 - psql -qc 'DROP EXTENSION plperlu' 701s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 701s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 701s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 701s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 701s ok 151 - extension jsonb_plpython3u installs without error 701s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 701s ok 153 - extension jsonb_plpython3u removes without error 701s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 701s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 701s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 701s ok 157 - extension lo installs without error 701s ok 158 - psql -qc 'DROP EXTENSION "lo"' 701s ok 159 - extension lo removes without error 701s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 701s ok 161 - extension ltree installs without error 701s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 701s ok 163 - extension ltree removes without error 701s ok 164 - psql -qc 'CREATE EXTENSION ltree' 701s ok 165 - ltree_plpython3u dependency ltree installs without error 701s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 701s ok 167 - ltree_plpython3u dependency plpython3u installs without error 701s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 701s ok 169 - extension ltree_plpython3u installs without error 701s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 701s ok 171 - extension ltree_plpython3u removes without error 702s ok 172 - psql -qc 'DROP EXTENSION ltree' 702s ok 173 - ltree_plpython3u dependency extension ltree removes without error 702s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 702s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 702s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 702s ok 177 - extension moddatetime installs without error 702s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 702s ok 179 - extension moddatetime removes without error 702s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 702s ok 181 - extension pageinspect installs without error 702s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 702s ok 183 - extension pageinspect removes without error 702s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 702s ok 185 - extension pg_buffercache installs without error 702s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 702s ok 187 - extension pg_buffercache removes without error 702s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 702s ok 189 - extension pg_freespacemap installs without error 702s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 702s ok 191 - extension pg_freespacemap removes without error 702s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 702s ok 193 - extension pg_prewarm installs without error 702s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 702s ok 195 - extension pg_prewarm removes without error 702s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 702s ok 197 - extension pg_stat_statements installs without error 702s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 702s ok 199 - extension pg_stat_statements removes without error 702s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 702s ok 201 - extension pg_surgery installs without error 702s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 702s ok 203 - extension pg_surgery removes without error 702s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 702s ok 205 - extension pg_trgm installs without error 702s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 702s ok 207 - extension pg_trgm removes without error 702s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 702s ok 209 - extension pg_visibility installs without error 702s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 702s ok 211 - extension pg_visibility removes without error 703s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 703s ok 213 - extension pg_walinspect installs without error 703s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 703s ok 215 - extension pg_walinspect removes without error 703s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 703s ok 217 - extension pgcrypto installs without error 703s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 703s ok 219 - extension pgcrypto removes without error 703s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 703s ok 221 - extension pgrowlocks installs without error 703s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 703s ok 223 - extension pgrowlocks removes without error 703s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 703s ok 225 - extension pgstattuple installs without error 703s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 703s ok 227 - extension pgstattuple removes without error 703s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 703s ok 229 - extension plperl installs without error 703s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 703s ok 231 - extension plperl removes without error 703s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 703s ok 233 - extension plperlu installs without error 703s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 703s ok 235 - extension plperlu removes without error 703s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 703s ok 237 - extension plpython3u installs without error 703s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 703s ok 239 - extension plpython3u removes without error 703s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 703s ok 241 - extension pltcl installs without error 703s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 703s ok 243 - extension pltcl removes without error 703s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 703s ok 245 - extension pltclu installs without error 703s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 703s ok 247 - extension pltclu removes without error 703s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 703s ok 249 - extension postgres_fdw installs without error 704s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 704s ok 251 - extension postgres_fdw removes without error 704s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 704s ok 253 - extension refint installs without error 704s ok 254 - psql -qc 'DROP EXTENSION "refint"' 704s ok 255 - extension refint removes without error 704s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 704s ok 257 - extension seg installs without error 704s ok 258 - psql -qc 'DROP EXTENSION "seg"' 704s ok 259 - extension seg removes without error 704s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 704s ok 261 - extension sslinfo installs without error 704s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 704s ok 263 - extension sslinfo removes without error 704s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 704s ok 265 - extension tablefunc installs without error 704s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 704s ok 267 - extension tablefunc removes without error 704s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 704s ok 269 - extension tcn installs without error 704s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 704s ok 271 - extension tcn removes without error 704s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 704s ok 273 - extension tsm_system_rows installs without error 704s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 704s ok 275 - extension tsm_system_rows removes without error 704s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 704s ok 277 - extension tsm_system_time installs without error 704s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 704s ok 279 - extension tsm_system_time removes without error 704s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 704s ok 281 - extension unaccent installs without error 704s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 704s ok 283 - extension unaccent removes without error 704s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 704s ok 285 - extension uuid-ossp installs without error 704s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 704s ok 287 - extension uuid-ossp removes without error 704s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 704s ok 289 - extension xml2 installs without error 704s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 704s ok 291 - extension xml2 removes without error 706s ok 292 - pg_dropcluster 17 main 706s # Cleanup 706s ok 293 - Cleanup: No clusters left behind 706s ok 294 - No postgres processes left behind 706s ok 295 - No files in /etc/postgresql left behind 706s ok 296 - No files in /var/lib/postgresql left behind 706s ok 297 - No files in /var/run/postgresql left behind 706s ok 298 - No files in /var/log/postgresql left behind 706s ok 299 - PostgreSQL TCP ports are closed 706s ok 300 - Next free port is 5432 706s 1..300 706s ### End test 170_extensions.t ### 706s 706s ### PostgreSQL test 180_ecpg.t ### 706s 1..14 706s ok 1 - ecpg test.pgc 706s ok 2 - ecpg processing 706s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 706s ok 4 - compiling ecpg output 714s ok 5 - pg_virtualenv /tmp/tmp.xm72mo88vm/test 714s ok 6 - test program runs and gives correct output 714s # Cleanup 714s ok 7 - Cleanup: No clusters left behind 714s ok 8 - No postgres processes left behind 714s ok 9 - No files in /etc/postgresql left behind 714s ok 10 - No files in /var/lib/postgresql left behind 714s ok 11 - No files in /var/run/postgresql left behind 714s ok 12 - No files in /var/log/postgresql left behind 714s ok 13 - PostgreSQL TCP ports are closed 714s ok 14 - Next free port is 5432 714s ### End test 180_ecpg.t ### 714s 714s ### PostgreSQL test 190_pg_buildext.t ### 714s ok 1 - make clean 714s ok 2 - make tar 714s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 714s # testing 'dh --with pgxs' 718s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 718s ok 5 - postgresql-17-foo_123-1_arm64.deb was built 726s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 726s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 726s ok 8 - dpkg -i postgresql-17-foo_123-1_arm64.deb 734s ok 9 - cd foo-123 && pg_buildext installcheck 734s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 741s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 741s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 748s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 748s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 748s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 748s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 748s ok 17 - dpkg -r postgresql-17-foo 748s # testing 'dh --with pgxs_loop' 749s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 752s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 752s ok 20 - postgresql-17-foo_123-1_arm64.deb was built 752s ok 21 - make clean 752s # testing pg_buildext updatecontrol 752s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 752s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 752s 1..23 752s ### End test 190_pg_buildext.t ### 752s 752s ### PostgreSQL test 200_maintscripts.t ### 752s 1..15 752s # We are running systemd 755s ok 1 - pg_createcluster 17 main --start 755s ok 2 - postmaster PID is 22966 756s ok 3 - apt-get update -q 757s # postgresql-common: 757s # Installed: 267 757s # Candidate: 267 757s # Version table: 757s # *** 267 500 757s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 757s # 100 /var/lib/dpkg/status 760s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 760s # postgresql-common: 760s # Installed: 267 760s # Candidate: 267 760s # Version table: 760s # *** 267 500 760s # 500 http://ftpmaster.internal/ubuntu plucky/main arm64 Packages 760s # 100 /var/lib/dpkg/status 760s ok 5 - postmaster PID is 22966 760s ok 6 - postmaster was not restarted 762s ok 7 - pg_dropcluster 17 main --stop 762s # Cleanup 762s ok 8 - Cleanup: No clusters left behind 762s ok 9 - No postgres processes left behind 762s ok 10 - No files in /etc/postgresql left behind 762s ok 11 - No files in /var/lib/postgresql left behind 762s ok 12 - No files in /var/run/postgresql left behind 762s ok 13 - No files in /var/log/postgresql left behind 762s ok 14 - PostgreSQL TCP ports are closed 762s ok 15 - Next free port is 5432 762s ### End test 200_maintscripts.t ### 762s 763s autopkgtest [11:57:50]: test run-testsuite: -----------------------] 763s run-testsuite PASS 763s autopkgtest [11:57:50]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 764s autopkgtest [11:57:51]: @@@@@@@@@@@@@@@@@@@@ summary 764s default-psql PASS 764s run-testsuite PASS 794s nova [W] Using flock in prodstack6-arm64 794s Creating nova instance adt-plucky-arm64-postgresql-common-20250116-114507-juju-7f2275-prod-proposed-migration-environment-2-739e2083-0137-40e4-975c-3f999c6f39cc from image adt/ubuntu-plucky-arm64-server-20250116.img (UUID b3960940-0e71-49d1-8b5d-cc75ec0ebb81)... 794s nova [W] Timed out waiting for 4943acda-e578-46b8-9b5f-07566a13a2f6 to get deleted. 794s nova [W] Using flock in prodstack6-arm64 794s Creating nova instance adt-plucky-arm64-postgresql-common-20250116-114507-juju-7f2275-prod-proposed-migration-environment-2-739e2083-0137-40e4-975c-3f999c6f39cc from image adt/ubuntu-plucky-arm64-server-20250116.img (UUID b3960940-0e71-49d1-8b5d-cc75ec0ebb81)... 794s nova [W] Timed out waiting for 4f62c862-407a-48a9-adc0-b5a5cfdc44df to get deleted.