0s autopkgtest [01:18:57]: starting date and time: 2025-06-19 01:18:57+0000 0s autopkgtest [01:18:57]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [01:18:57]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.5vuaclx_/out --timeout-copy=6000 --setup-commands 'ln -s /dev/null /etc/systemd/system/bluetooth.service; printf "http_proxy=http://squid.internal:3128\nhttps_proxy=http://squid.internal:3128\nno_proxy=127.0.0.1,127.0.1.1,localhost,localdomain,internal,login.ubuntu.com,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com\n" >> /etc/environment' --apt-pocket=proposed=src:procps --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=procps/2:4.0.4-8ubuntu1 -- lxd -r lxd-armhf-10.145.243.210 lxd-armhf-10.145.243.210:autopkgtest/ubuntu/questing/armhf 24s autopkgtest [01:19:21]: testbed dpkg architecture: armhf 26s autopkgtest [01:19:23]: testbed apt version: 3.1.2 29s autopkgtest [01:19:26]: @@@@@@@@@@@@@@@@@@@@ test bed setup 31s autopkgtest [01:19:28]: testbed release detected to be: None 39s autopkgtest [01:19:36]: updating testbed package index (apt update) 40s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 41s Get:2 http://ftpmaster.internal/ubuntu questing InRelease [249 kB] 41s Get:3 http://ftpmaster.internal/ubuntu questing-updates InRelease [110 kB] 41s Get:4 http://ftpmaster.internal/ubuntu questing-security InRelease [110 kB] 41s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 41s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [404 kB] 41s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 41s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 41s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main armhf Packages [59.8 kB] 41s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted armhf Packages [716 B] 41s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe armhf Packages [341 kB] 41s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse armhf Packages [4104 B] 41s Get:13 http://ftpmaster.internal/ubuntu questing/universe Sources [21.3 MB] 42s Get:14 http://ftpmaster.internal/ubuntu questing/main Sources [1395 kB] 42s Get:15 http://ftpmaster.internal/ubuntu questing/multiverse Sources [309 kB] 42s Get:16 http://ftpmaster.internal/ubuntu questing/main armhf Packages [1356 kB] 42s Get:17 http://ftpmaster.internal/ubuntu questing/universe armhf Packages [15.2 MB] 42s Get:18 http://ftpmaster.internal/ubuntu questing/multiverse armhf Packages [184 kB] 46s Fetched 41.2 MB in 6s (7399 kB/s) 47s Reading package lists... 52s autopkgtest [01:19:49]: upgrading testbed (apt dist-upgrade and autopurge) 54s Reading package lists... 54s Building dependency tree... 54s Reading state information... 55s Calculating upgrade... 55s The following packages will be upgraded: 55s libpng16-16t64 libproc2-0 libssl3t64 openssl openssl-provider-legacy procps 55s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 55s Need to get 4037 kB of archives. 55s After this operation, 386 kB of additional disk space will be used. 55s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf openssl-provider-legacy armhf 3.5.0-2ubuntu1 [29.8 kB] 55s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf libssl3t64 armhf 3.5.0-2ubuntu1 [1875 kB] 56s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main armhf libproc2-0 armhf 2:4.0.4-8ubuntu1 [50.2 kB] 56s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main armhf procps armhf 2:4.0.4-8ubuntu1 [702 kB] 56s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf openssl armhf 3.5.0-2ubuntu1 [1212 kB] 56s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf libpng16-16t64 armhf 1.6.49-1~exp1 [168 kB] 56s Fetched 4037 kB in 1s (5510 kB/s) 56s (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 ... 59648 files and directories currently installed.) 56s Preparing to unpack .../openssl-provider-legacy_3.5.0-2ubuntu1_armhf.deb ... 56s Unpacking openssl-provider-legacy (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 56s Setting up openssl-provider-legacy (3.5.0-2ubuntu1) ... 56s (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 ... 59648 files and directories currently installed.) 56s Preparing to unpack .../libssl3t64_3.5.0-2ubuntu1_armhf.deb ... 56s Unpacking libssl3t64:armhf (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 57s Setting up libssl3t64:armhf (3.5.0-2ubuntu1) ... 57s (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 ... 59647 files and directories currently installed.) 57s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_armhf.deb ... 57s Unpacking libproc2-0:armhf (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 57s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_armhf.deb ... 57s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 57s Preparing to unpack .../openssl_3.5.0-2ubuntu1_armhf.deb ... 57s Unpacking openssl (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 57s Preparing to unpack .../libpng16-16t64_1.6.49-1~exp1_armhf.deb ... 57s Unpacking libpng16-16t64:armhf (1.6.49-1~exp1) over (1.6.48-1) ... 57s Setting up libproc2-0:armhf (2:4.0.4-8ubuntu1) ... 57s Setting up libpng16-16t64:armhf (1.6.49-1~exp1) ... 57s Setting up procps (2:4.0.4-8ubuntu1) ... 57s Setting up openssl (3.5.0-2ubuntu1) ... 57s Processing triggers for systemd (257.6-1ubuntu1) ... 57s Processing triggers for man-db (2.13.1-1) ... 59s Processing triggers for libc-bin (2.41-6ubuntu2) ... 61s Reading package lists... 61s Building dependency tree... 61s Reading state information... 61s Solving dependencies... 62s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s autopkgtest [01:20:01]: rebooting testbed after setup commands that affected boot 103s autopkgtest [01:20:40]: testbed running kernel: Linux 6.8.0-58-generic #60~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Fri Mar 28 14:48:37 UTC 2 126s autopkgtest [01:21:03]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 162s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (dsc) [2385 B] 162s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (tar) [218 kB] 162s gpgv: Signature made Thu Jun 12 19:04:12 2025 UTC 162s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 162s gpgv: Can't check signature: No public key 162s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_279.dsc: no acceptable signature found 162s autopkgtest [01:21:39]: testing package postgresql-common version 279 164s autopkgtest [01:21:41]: build not needed 166s autopkgtest [01:21:43]: test default-psql: preparing testbed 167s Reading package lists... 168s Building dependency tree... 168s Reading state information... 168s Solving dependencies... 168s The following NEW packages will be installed: 168s libicu76 libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 168s libxslt1.1 postgresql postgresql-17 postgresql-client-17 168s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 169s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 169s Need to get 60.2 MB of archives. 169s After this operation, 237 MB of additional disk space will be used. 169s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf libjson-perl all 4.10000-1 [81.9 kB] 169s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-client-common all 279 [48.1 kB] 169s Get:3 http://ftpmaster.internal/ubuntu questing/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 169s Get:4 http://ftpmaster.internal/ubuntu questing/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 169s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-common-dev all 279 [73.6 kB] 169s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 169s Get:7 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-common all 279 [101 kB] 169s Get:8 http://ftpmaster.internal/ubuntu questing/main armhf libicu76 armhf 76.1-4ubuntu1 [10.7 MB] 170s Get:9 http://ftpmaster.internal/ubuntu questing/main armhf libllvm20 armhf 1:20.1.6-0ubuntu1 [29.6 MB] 171s Get:10 http://ftpmaster.internal/ubuntu questing/main armhf libpq5 armhf 17.5-1build1 [236 kB] 171s Get:11 http://ftpmaster.internal/ubuntu questing/main armhf libxslt1.1 armhf 1.1.43-0exp1 [144 kB] 171s Get:12 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-client-17 armhf 17.5-1build1 [2064 kB] 171s Get:13 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-17 armhf 17.5-1build1 [16.9 MB] 171s Get:14 http://ftpmaster.internal/ubuntu questing/main armhf postgresql all 17+279 [16.6 kB] 172s Preconfiguring packages ... 172s /var/cache/debconf/tmp.ci/postgresql.config.SAGgK0: 12: pg_lsclusters: not found 172s Fetched 60.2 MB in 3s (21.6 MB/s) 172s Selecting previously unselected package libjson-perl. 172s (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 ... 59700 files and directories currently installed.) 172s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 172s Unpacking libjson-perl (4.10000-1) ... 172s Selecting previously unselected package postgresql-client-common. 172s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 172s Unpacking postgresql-client-common (279) ... 172s Selecting previously unselected package libio-pty-perl. 172s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 172s Unpacking libio-pty-perl (1:1.20-1build3) ... 172s Selecting previously unselected package libipc-run-perl. 172s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 172s Unpacking libipc-run-perl (20231003.0-2) ... 172s Selecting previously unselected package postgresql-common-dev. 172s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 172s Unpacking postgresql-common-dev (279) ... 172s Selecting previously unselected package ssl-cert. 172s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 172s Unpacking ssl-cert (1.1.3ubuntu1) ... 172s Selecting previously unselected package postgresql-common. 172s Preparing to unpack .../06-postgresql-common_279_all.deb ... 172s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 172s Unpacking postgresql-common (279) ... 172s Selecting previously unselected package libicu76:armhf. 172s Preparing to unpack .../07-libicu76_76.1-4ubuntu1_armhf.deb ... 172s Unpacking libicu76:armhf (76.1-4ubuntu1) ... 172s Selecting previously unselected package libllvm20:armhf. 172s Preparing to unpack .../08-libllvm20_1%3a20.1.6-0ubuntu1_armhf.deb ... 172s Unpacking libllvm20:armhf (1:20.1.6-0ubuntu1) ... 173s Selecting previously unselected package libpq5:armhf. 173s Preparing to unpack .../09-libpq5_17.5-1build1_armhf.deb ... 173s Unpacking libpq5:armhf (17.5-1build1) ... 173s Selecting previously unselected package libxslt1.1:armhf. 173s Preparing to unpack .../10-libxslt1.1_1.1.43-0exp1_armhf.deb ... 173s Unpacking libxslt1.1:armhf (1.1.43-0exp1) ... 173s Selecting previously unselected package postgresql-client-17. 173s Preparing to unpack .../11-postgresql-client-17_17.5-1build1_armhf.deb ... 173s Unpacking postgresql-client-17 (17.5-1build1) ... 173s Selecting previously unselected package postgresql-17. 173s Preparing to unpack .../12-postgresql-17_17.5-1build1_armhf.deb ... 173s Unpacking postgresql-17 (17.5-1build1) ... 174s Selecting previously unselected package postgresql. 174s Preparing to unpack .../13-postgresql_17+279_all.deb ... 174s Unpacking postgresql (17+279) ... 174s Setting up postgresql-client-common (279) ... 174s Setting up libio-pty-perl (1:1.20-1build3) ... 174s Setting up libpq5:armhf (17.5-1build1) ... 174s Setting up ssl-cert (1.1.3ubuntu1) ... 174s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 175s Setting up libllvm20:armhf (1:20.1.6-0ubuntu1) ... 175s Setting up libipc-run-perl (20231003.0-2) ... 175s Setting up libjson-perl (4.10000-1) ... 175s Setting up libxslt1.1:armhf (1.1.43-0exp1) ... 175s Setting up libicu76:armhf (76.1-4ubuntu1) ... 175s Setting up postgresql-common-dev (279) ... 175s Setting up postgresql-client-17 (17.5-1build1) ... 175s 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 175s Setting up postgresql-common (279) ... 176s Creating config file /etc/postgresql-common/createcluster.conf with new version 176s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 176s Removing obsolete dictionary files: 177s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 177s Setting up postgresql-17 (17.5-1build1) ... 178s Creating new PostgreSQL cluster 17/main ... 178s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 178s The files belonging to this database system will be owned by user "postgres". 178s This user must also own the server process. 178s 178s The database cluster will be initialized with locale "C.UTF-8". 178s The default database encoding has accordingly been set to "UTF8". 178s The default text search configuration will be set to "english". 178s 178s Data page checksums are disabled. 178s 178s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 178s creating subdirectories ... ok 178s selecting dynamic shared memory implementation ... posix 178s selecting default "max_connections" ... 100 178s selecting default "shared_buffers" ... 128MB 178s selecting default time zone ... Etc/UTC 178s creating configuration files ... ok 178s running bootstrap script ... ok 179s performing post-bootstrap initialization ... ok 179s syncing data to disk ... ok 182s Setting up postgresql (17+279) ... 182s Processing triggers for man-db (2.13.1-1) ... 183s Processing triggers for libc-bin (2.41-6ubuntu2) ... 190s autopkgtest [01:22:07]: test default-psql: [----------------------- 192s autopkgtest [01:22:09]: test default-psql: -----------------------] 196s default-psql PASS 196s autopkgtest [01:22:13]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 200s autopkgtest [01:22:17]: test run-testsuite: preparing testbed 225s autopkgtest [01:22:42]: testbed dpkg architecture: armhf 227s autopkgtest [01:22:44]: testbed apt version: 3.1.2 230s autopkgtest [01:22:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 232s autopkgtest [01:22:49]: testbed release detected to be: questing 239s autopkgtest [01:22:56]: updating testbed package index (apt update) 241s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 241s Get:2 http://ftpmaster.internal/ubuntu questing InRelease [249 kB] 241s Get:3 http://ftpmaster.internal/ubuntu questing-updates InRelease [110 kB] 241s Get:4 http://ftpmaster.internal/ubuntu questing-security InRelease [110 kB] 241s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 241s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 241s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [404 kB] 241s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 241s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main armhf Packages [59.8 kB] 242s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/restricted armhf Packages [716 B] 242s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/universe armhf Packages [341 kB] 242s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/multiverse armhf Packages [4104 B] 242s Get:13 http://ftpmaster.internal/ubuntu questing/main Sources [1395 kB] 242s Get:14 http://ftpmaster.internal/ubuntu questing/universe Sources [21.3 MB] 242s Get:15 http://ftpmaster.internal/ubuntu questing/multiverse Sources [309 kB] 242s Get:16 http://ftpmaster.internal/ubuntu questing/main armhf Packages [1356 kB] 242s Get:17 http://ftpmaster.internal/ubuntu questing/universe armhf Packages [15.2 MB] 242s Get:18 http://ftpmaster.internal/ubuntu questing/multiverse armhf Packages [184 kB] 246s Fetched 41.2 MB in 5s (8057 kB/s) 247s Reading package lists... 253s autopkgtest [01:23:10]: upgrading testbed (apt dist-upgrade and autopurge) 254s Reading package lists... 254s Building dependency tree... 254s Reading state information... 255s Calculating upgrade... 255s The following packages will be upgraded: 255s libpng16-16t64 libproc2-0 libssl3t64 openssl openssl-provider-legacy procps 255s 6 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 255s Need to get 4037 kB of archives. 255s After this operation, 386 kB of additional disk space will be used. 255s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf openssl-provider-legacy armhf 3.5.0-2ubuntu1 [29.8 kB] 256s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf libssl3t64 armhf 3.5.0-2ubuntu1 [1875 kB] 257s Get:3 http://ftpmaster.internal/ubuntu questing-proposed/main armhf libproc2-0 armhf 2:4.0.4-8ubuntu1 [50.2 kB] 257s Get:4 http://ftpmaster.internal/ubuntu questing-proposed/main armhf procps armhf 2:4.0.4-8ubuntu1 [702 kB] 258s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf openssl armhf 3.5.0-2ubuntu1 [1212 kB] 258s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf libpng16-16t64 armhf 1.6.49-1~exp1 [168 kB] 258s Fetched 4037 kB in 3s (1422 kB/s) 259s (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 ... 59648 files and directories currently installed.) 259s Preparing to unpack .../openssl-provider-legacy_3.5.0-2ubuntu1_armhf.deb ... 259s Unpacking openssl-provider-legacy (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 259s Setting up openssl-provider-legacy (3.5.0-2ubuntu1) ... 259s (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 ... 59648 files and directories currently installed.) 259s Preparing to unpack .../libssl3t64_3.5.0-2ubuntu1_armhf.deb ... 259s Unpacking libssl3t64:armhf (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 259s Setting up libssl3t64:armhf (3.5.0-2ubuntu1) ... 259s (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 ... 59647 files and directories currently installed.) 259s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_armhf.deb ... 259s Unpacking libproc2-0:armhf (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 259s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_armhf.deb ... 259s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 259s Preparing to unpack .../openssl_3.5.0-2ubuntu1_armhf.deb ... 259s Unpacking openssl (3.5.0-2ubuntu1) over (3.4.1-1ubuntu3) ... 259s Preparing to unpack .../libpng16-16t64_1.6.49-1~exp1_armhf.deb ... 259s Unpacking libpng16-16t64:armhf (1.6.49-1~exp1) over (1.6.48-1) ... 259s Setting up libproc2-0:armhf (2:4.0.4-8ubuntu1) ... 259s Setting up libpng16-16t64:armhf (1.6.49-1~exp1) ... 259s Setting up procps (2:4.0.4-8ubuntu1) ... 260s Setting up openssl (3.5.0-2ubuntu1) ... 260s Processing triggers for systemd (257.6-1ubuntu1) ... 260s Processing triggers for man-db (2.13.1-1) ... 261s Processing triggers for libc-bin (2.41-6ubuntu2) ... 263s Reading package lists... 263s Building dependency tree... 263s Reading state information... 264s Solving dependencies... 264s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 266s autopkgtest [01:23:23]: rebooting testbed after setup commands that affected boot 327s Reading package lists... 328s Building dependency tree... 328s Reading state information... 328s Solving dependencies... 328s The following NEW packages will be installed: 328s autoconf automake autopoint autotools-dev build-essential clang-20 cpp 328s cpp-14 cpp-14-arm-linux-gnueabihf cpp-arm-linux-gnueabihf debhelper 328s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 328s emacsen-common fakeroot g++ g++-14 g++-14-arm-linux-gnueabihf 328s g++-arm-linux-gnueabihf gcc gcc-14 gcc-14-arm-linux-gnueabihf 328s gcc-arm-linux-gnueabihf gettext hunspell-en-us intltool-debian 328s libarchive-zip-perl libasan8 libc-dev-bin libc6-dev libcc1-0 328s libclang-common-20-dev libclang-cpp20 libclang1-20 libcrypt-dev 328s libdebhelper-perl libdw1t64 libecpg-compat3 libecpg-dev libecpg6 libfakeroot 328s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev libgomp1 328s libicu76 libio-pty-perl libipc-run-perl libisl23 libjson-perl libllvm20 328s liblzma-dev libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 328s libpgtypes3 libpq-dev libpq5 libpython3.13 libssl-dev libstdc++-14-dev 328s libtcl8.6 libtool libubsan1 libxml2-dev libxslt1.1 linux-libc-dev llvm-20 328s llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools locales-all 328s m4 po-debconf postgresql-17 postgresql-all postgresql-client-17 328s postgresql-client-common postgresql-common postgresql-common-dev 328s postgresql-doc postgresql-doc-17 postgresql-plperl-17 328s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 328s postgresql-server-dev-all rpcsvc-proto ssl-cert zlib1g-dev 329s 0 upgraded, 97 newly installed, 0 to remove and 0 not upgraded. 329s Need to get 234 MB of archives. 329s After this operation, 1229 MB of additional disk space will be used. 329s Get:1 http://ftpmaster.internal/ubuntu questing/main armhf libjson-perl all 4.10000-1 [81.9 kB] 329s Get:2 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-client-common all 279 [48.1 kB] 329s Get:3 http://ftpmaster.internal/ubuntu questing/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 329s Get:4 http://ftpmaster.internal/ubuntu questing/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 329s Get:5 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-common-dev all 279 [73.6 kB] 329s Get:6 http://ftpmaster.internal/ubuntu questing/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 329s Get:7 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-common all 279 [101 kB] 329s Get:8 http://ftpmaster.internal/ubuntu questing/main armhf m4 armhf 1.4.19-8 [238 kB] 329s Get:9 http://ftpmaster.internal/ubuntu questing/main armhf autoconf all 2.72-3.1ubuntu1 [384 kB] 329s Get:10 http://ftpmaster.internal/ubuntu questing/main armhf autotools-dev all 20240727.1 [43.4 kB] 329s Get:11 http://ftpmaster.internal/ubuntu questing/main armhf automake all 1:1.17-4ubuntu1 [572 kB] 329s Get:12 http://ftpmaster.internal/ubuntu questing/main armhf autopoint all 0.23.1-2build1 [619 kB] 330s Get:13 http://ftpmaster.internal/ubuntu questing/main armhf libc-dev-bin armhf 2.41-6ubuntu2 [21.7 kB] 330s Get:14 http://ftpmaster.internal/ubuntu questing/main armhf linux-libc-dev armhf 6.14.0-15.15 [1687 kB] 330s Get:15 http://ftpmaster.internal/ubuntu questing/main armhf libcrypt-dev armhf 1:4.4.38-1 [120 kB] 330s Get:16 http://ftpmaster.internal/ubuntu questing/main armhf rpcsvc-proto armhf 1.4.3-1 [62.3 kB] 330s Get:17 http://ftpmaster.internal/ubuntu questing/main armhf libc6-dev armhf 2.41-6ubuntu2 [1395 kB] 330s Get:18 http://ftpmaster.internal/ubuntu questing/main armhf libisl23 armhf 0.27-1 [546 kB] 331s Get:19 http://ftpmaster.internal/ubuntu questing/main armhf libmpc3 armhf 1.3.1-1build2 [47.1 kB] 331s Get:20 http://ftpmaster.internal/ubuntu questing/main armhf cpp-14-arm-linux-gnueabihf armhf 14.3.0-1ubuntu1 [9216 kB] 332s Get:21 http://ftpmaster.internal/ubuntu questing/main armhf cpp-14 armhf 14.3.0-1ubuntu1 [1032 B] 332s Get:22 http://ftpmaster.internal/ubuntu questing/main armhf cpp-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [5578 B] 332s Get:23 http://ftpmaster.internal/ubuntu questing/main armhf cpp armhf 4:14.2.0-1ubuntu1 [22.4 kB] 332s Get:24 http://ftpmaster.internal/ubuntu questing/main armhf libcc1-0 armhf 15.1.0-5ubuntu1 [43.4 kB] 332s Get:25 http://ftpmaster.internal/ubuntu questing/main armhf libgomp1 armhf 15.1.0-5ubuntu1 [129 kB] 332s Get:26 http://ftpmaster.internal/ubuntu questing/main armhf libasan8 armhf 15.1.0-5ubuntu1 [2949 kB] 332s Get:27 http://ftpmaster.internal/ubuntu questing/main armhf libubsan1 armhf 15.1.0-5ubuntu1 [1187 kB] 332s Get:28 http://ftpmaster.internal/ubuntu questing/main armhf libgcc-14-dev armhf 14.3.0-1ubuntu1 [896 kB] 332s Get:29 http://ftpmaster.internal/ubuntu questing/main armhf gcc-14-arm-linux-gnueabihf armhf 14.3.0-1ubuntu1 [18.0 MB] 333s Get:30 http://ftpmaster.internal/ubuntu questing/main armhf gcc-14 armhf 14.3.0-1ubuntu1 [518 kB] 333s Get:31 http://ftpmaster.internal/ubuntu questing/main armhf gcc-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [1218 B] 333s Get:32 http://ftpmaster.internal/ubuntu questing/main armhf gcc armhf 4:14.2.0-1ubuntu1 [5004 B] 333s Get:33 http://ftpmaster.internal/ubuntu questing/main armhf libstdc++-14-dev armhf 14.3.0-1ubuntu1 [2856 kB] 333s Get:34 http://ftpmaster.internal/ubuntu questing/main armhf g++-14-arm-linux-gnueabihf armhf 14.3.0-1ubuntu1 [10.5 MB] 333s Get:35 http://ftpmaster.internal/ubuntu questing/main armhf g++-14 armhf 14.3.0-1ubuntu1 [27.4 kB] 333s Get:36 http://ftpmaster.internal/ubuntu questing/main armhf g++-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [966 B] 333s Get:37 http://ftpmaster.internal/ubuntu questing/main armhf g++ armhf 4:14.2.0-1ubuntu1 [1084 B] 333s Get:38 http://ftpmaster.internal/ubuntu questing/main armhf build-essential armhf 12.12ubuntu1 [5088 B] 333s Get:39 http://ftpmaster.internal/ubuntu questing/main armhf libllvm20 armhf 1:20.1.6-0ubuntu1 [29.6 MB] 334s Get:40 http://ftpmaster.internal/ubuntu questing/main armhf libclang-cpp20 armhf 1:20.1.6-0ubuntu1 [13.3 MB] 335s Get:41 http://ftpmaster.internal/ubuntu questing/main armhf libgc1 armhf 1:8.2.8-1 [81.2 kB] 335s Get:42 http://ftpmaster.internal/ubuntu questing/universe armhf libobjc4 armhf 15.1.0-5ubuntu1 [38.8 kB] 335s Get:43 http://ftpmaster.internal/ubuntu questing/universe armhf libobjc-14-dev armhf 14.3.0-1ubuntu1 [184 kB] 335s Get:44 http://ftpmaster.internal/ubuntu questing/universe armhf libclang-common-20-dev armhf 1:20.1.6-0ubuntu1 [775 kB] 335s Get:45 http://ftpmaster.internal/ubuntu questing/universe armhf llvm-20-linker-tools armhf 1:20.1.6-0ubuntu1 [1178 kB] 335s Get:46 http://ftpmaster.internal/ubuntu questing/universe armhf libclang1-20 armhf 1:20.1.6-0ubuntu1 [7707 kB] 335s Get:47 http://ftpmaster.internal/ubuntu questing/universe armhf clang-20 armhf 1:20.1.6-0ubuntu1 [74.6 kB] 335s Get:48 http://ftpmaster.internal/ubuntu questing/main armhf libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 335s Get:49 http://ftpmaster.internal/ubuntu questing/main armhf libtool all 2.5.4-4 [168 kB] 335s Get:50 http://ftpmaster.internal/ubuntu questing/main armhf dh-autoreconf all 20 [16.1 kB] 335s Get:51 http://ftpmaster.internal/ubuntu questing/main armhf libarchive-zip-perl all 1.68-1 [90.2 kB] 335s Get:52 http://ftpmaster.internal/ubuntu questing/main armhf libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 335s Get:53 http://ftpmaster.internal/ubuntu questing/main armhf dh-strip-nondeterminism all 1.14.1-2 [5064 B] 335s Get:54 http://ftpmaster.internal/ubuntu questing/main armhf libdw1t64 armhf 0.193-1 [248 kB] 335s Get:55 http://ftpmaster.internal/ubuntu questing/main armhf debugedit armhf 1:5.1-2 [46.7 kB] 335s Get:56 http://ftpmaster.internal/ubuntu questing/main armhf dwz armhf 0.15-1build6 [116 kB] 335s Get:57 http://ftpmaster.internal/ubuntu questing/main armhf gettext armhf 0.23.1-2build1 [1508 kB] 335s Get:58 http://ftpmaster.internal/ubuntu questing/main armhf intltool-debian all 0.35.0+20060710.6 [23.2 kB] 335s Get:59 http://ftpmaster.internal/ubuntu questing/main armhf po-debconf all 1.0.21+nmu1 [233 kB] 335s Get:60 http://ftpmaster.internal/ubuntu questing/main armhf debhelper all 13.24.2ubuntu1 [896 kB] 335s Get:61 http://ftpmaster.internal/ubuntu questing/main armhf emacsen-common all 3.0.8 [13.9 kB] 335s Get:62 http://ftpmaster.internal/ubuntu questing/main armhf dictionaries-common all 1.30.10 [178 kB] 335s Get:63 http://ftpmaster.internal/ubuntu questing/main armhf libfakeroot armhf 1.37.1.2-1 [29.7 kB] 335s Get:64 http://ftpmaster.internal/ubuntu questing/main armhf fakeroot armhf 1.37.1.2-1 [69.5 kB] 335s Get:65 http://ftpmaster.internal/ubuntu questing/main armhf hunspell-en-us all 1:2020.12.07-4 [585 kB] 335s Get:66 http://ftpmaster.internal/ubuntu questing/main armhf libpgtypes3 armhf 17.5-1build1 [42.3 kB] 335s Get:67 http://ftpmaster.internal/ubuntu questing/main armhf libpq5 armhf 17.5-1build1 [236 kB] 335s Get:68 http://ftpmaster.internal/ubuntu questing/main armhf libecpg6 armhf 17.5-1build1 [57.7 kB] 335s Get:69 http://ftpmaster.internal/ubuntu questing/main armhf libecpg-compat3 armhf 17.5-1build1 [15.2 kB] 336s Get:70 http://ftpmaster.internal/ubuntu questing/main armhf libssl-dev armhf 3.5.0-2ubuntu1 [2525 kB] 336s Get:71 http://ftpmaster.internal/ubuntu questing/main armhf libpq-dev armhf 17.5-1build1 [148 kB] 336s Get:72 http://ftpmaster.internal/ubuntu questing/main armhf libecpg-dev armhf 17.5-1build1 [319 kB] 336s Get:73 http://ftpmaster.internal/ubuntu questing/main armhf libicu76 armhf 76.1-4ubuntu1 [10.7 MB] 336s Get:74 http://ftpmaster.internal/ubuntu questing/main armhf libncurses-dev armhf 6.5+20250216-2 [345 kB] 336s Get:75 http://ftpmaster.internal/ubuntu questing/main armhf libpython3.13 armhf 3.13.5-1 [2086 kB] 336s Get:76 http://ftpmaster.internal/ubuntu questing/main armhf libtcl8.6 armhf 8.6.16+dfsg-1 [909 kB] 336s Get:77 http://ftpmaster.internal/ubuntu questing/main armhf liblzma-dev armhf 5.8.1-1build1 [167 kB] 336s Get:78 http://ftpmaster.internal/ubuntu questing/main armhf zlib1g-dev armhf 1:1.3.dfsg+really1.3.1-1ubuntu1 [880 kB] 336s Get:79 http://ftpmaster.internal/ubuntu questing/main armhf libxml2-dev armhf 2.14.3+dfsg-0exp3 [68.6 kB] 336s Get:80 http://ftpmaster.internal/ubuntu questing/main armhf libxslt1.1 armhf 1.1.43-0exp1 [144 kB] 336s Get:81 http://ftpmaster.internal/ubuntu questing/universe armhf llvm-20-runtime armhf 1:20.1.6-0ubuntu1 [536 kB] 336s Get:82 http://ftpmaster.internal/ubuntu questing/universe armhf libpfm4 armhf 4.13.0+git99-gc5587f9-1 [71.7 kB] 336s Get:83 http://ftpmaster.internal/ubuntu questing/universe armhf llvm-20 armhf 1:20.1.6-0ubuntu1 [19.2 MB] 337s Get:84 http://ftpmaster.internal/ubuntu questing/main armhf libffi-dev armhf 3.4.8-2 [57.1 kB] 337s Get:85 http://ftpmaster.internal/ubuntu questing/universe armhf llvm-20-tools armhf 1:20.1.6-0ubuntu1 [482 kB] 337s Get:86 http://ftpmaster.internal/ubuntu questing/universe armhf llvm-20-dev armhf 1:20.1.6-0ubuntu1 [51.4 MB] 339s Get:87 http://ftpmaster.internal/ubuntu questing/universe armhf locales-all armhf 2.41-6ubuntu2 [11.2 MB] 339s Get:88 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-client-17 armhf 17.5-1build1 [2064 kB] 339s Get:89 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-17 armhf 17.5-1build1 [16.9 MB] 340s Get:90 http://ftpmaster.internal/ubuntu questing/universe armhf postgresql-server-dev-17 armhf 17.5-1build1 [1373 kB] 340s Get:91 http://ftpmaster.internal/ubuntu questing/universe armhf postgresql-server-dev-all all 279 [1626 B] 340s Get:92 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-plperl-17 armhf 17.5-1build1 [86.7 kB] 340s Get:93 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-plpython3-17 armhf 17.5-1build1 [112 kB] 340s Get:94 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-pltcl-17 armhf 17.5-1build1 [41.9 kB] 340s Get:95 http://ftpmaster.internal/ubuntu questing/universe armhf postgresql-all all 279 [1706 B] 340s Get:96 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-doc-17 all 17.5-1build1 [2137 kB] 340s Get:97 http://ftpmaster.internal/ubuntu questing/main armhf postgresql-doc all 17+279 [13.8 kB] 340s Preconfiguring packages ... 341s Fetched 234 MB in 12s (20.3 MB/s) 341s Selecting previously unselected package libjson-perl. 341s (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 ... 59700 files and directories currently installed.) 341s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 341s Unpacking libjson-perl (4.10000-1) ... 341s Selecting previously unselected package postgresql-client-common. 341s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 341s Unpacking postgresql-client-common (279) ... 341s Selecting previously unselected package libio-pty-perl. 341s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 341s Unpacking libio-pty-perl (1:1.20-1build3) ... 341s Selecting previously unselected package libipc-run-perl. 341s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 341s Unpacking libipc-run-perl (20231003.0-2) ... 341s Selecting previously unselected package postgresql-common-dev. 341s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 341s Unpacking postgresql-common-dev (279) ... 341s Selecting previously unselected package ssl-cert. 341s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 341s Unpacking ssl-cert (1.1.3ubuntu1) ... 341s Selecting previously unselected package postgresql-common. 341s Preparing to unpack .../06-postgresql-common_279_all.deb ... 341s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 341s Unpacking postgresql-common (279) ... 341s Selecting previously unselected package m4. 341s Preparing to unpack .../07-m4_1.4.19-8_armhf.deb ... 341s Unpacking m4 (1.4.19-8) ... 341s Selecting previously unselected package autoconf. 341s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 341s Unpacking autoconf (2.72-3.1ubuntu1) ... 341s Selecting previously unselected package autotools-dev. 341s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 341s Unpacking autotools-dev (20240727.1) ... 341s Selecting previously unselected package automake. 341s Preparing to unpack .../10-automake_1%3a1.17-4ubuntu1_all.deb ... 341s Unpacking automake (1:1.17-4ubuntu1) ... 341s Selecting previously unselected package autopoint. 341s Preparing to unpack .../11-autopoint_0.23.1-2build1_all.deb ... 341s Unpacking autopoint (0.23.1-2build1) ... 341s Selecting previously unselected package libc-dev-bin. 341s Preparing to unpack .../12-libc-dev-bin_2.41-6ubuntu2_armhf.deb ... 341s Unpacking libc-dev-bin (2.41-6ubuntu2) ... 341s Selecting previously unselected package linux-libc-dev:armhf. 341s Preparing to unpack .../13-linux-libc-dev_6.14.0-15.15_armhf.deb ... 341s Unpacking linux-libc-dev:armhf (6.14.0-15.15) ... 342s Selecting previously unselected package libcrypt-dev:armhf. 342s Preparing to unpack .../14-libcrypt-dev_1%3a4.4.38-1_armhf.deb ... 342s Unpacking libcrypt-dev:armhf (1:4.4.38-1) ... 342s Selecting previously unselected package rpcsvc-proto. 342s Preparing to unpack .../15-rpcsvc-proto_1.4.3-1_armhf.deb ... 342s Unpacking rpcsvc-proto (1.4.3-1) ... 342s Selecting previously unselected package libc6-dev:armhf. 342s Preparing to unpack .../16-libc6-dev_2.41-6ubuntu2_armhf.deb ... 342s Unpacking libc6-dev:armhf (2.41-6ubuntu2) ... 342s Selecting previously unselected package libisl23:armhf. 342s Preparing to unpack .../17-libisl23_0.27-1_armhf.deb ... 342s Unpacking libisl23:armhf (0.27-1) ... 342s Selecting previously unselected package libmpc3:armhf. 342s Preparing to unpack .../18-libmpc3_1.3.1-1build2_armhf.deb ... 342s Unpacking libmpc3:armhf (1.3.1-1build2) ... 342s Selecting previously unselected package cpp-14-arm-linux-gnueabihf. 342s Preparing to unpack .../19-cpp-14-arm-linux-gnueabihf_14.3.0-1ubuntu1_armhf.deb ... 342s Unpacking cpp-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 342s Selecting previously unselected package cpp-14. 342s Preparing to unpack .../20-cpp-14_14.3.0-1ubuntu1_armhf.deb ... 342s Unpacking cpp-14 (14.3.0-1ubuntu1) ... 342s Selecting previously unselected package cpp-arm-linux-gnueabihf. 342s Preparing to unpack .../21-cpp-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 342s Unpacking cpp-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 342s Selecting previously unselected package cpp. 342s Preparing to unpack .../22-cpp_4%3a14.2.0-1ubuntu1_armhf.deb ... 342s Unpacking cpp (4:14.2.0-1ubuntu1) ... 342s Selecting previously unselected package libcc1-0:armhf. 342s Preparing to unpack .../23-libcc1-0_15.1.0-5ubuntu1_armhf.deb ... 342s Unpacking libcc1-0:armhf (15.1.0-5ubuntu1) ... 342s Selecting previously unselected package libgomp1:armhf. 342s Preparing to unpack .../24-libgomp1_15.1.0-5ubuntu1_armhf.deb ... 342s Unpacking libgomp1:armhf (15.1.0-5ubuntu1) ... 342s Selecting previously unselected package libasan8:armhf. 342s Preparing to unpack .../25-libasan8_15.1.0-5ubuntu1_armhf.deb ... 342s Unpacking libasan8:armhf (15.1.0-5ubuntu1) ... 343s Selecting previously unselected package libubsan1:armhf. 343s Preparing to unpack .../26-libubsan1_15.1.0-5ubuntu1_armhf.deb ... 343s Unpacking libubsan1:armhf (15.1.0-5ubuntu1) ... 343s Selecting previously unselected package libgcc-14-dev:armhf. 343s Preparing to unpack .../27-libgcc-14-dev_14.3.0-1ubuntu1_armhf.deb ... 343s Unpacking libgcc-14-dev:armhf (14.3.0-1ubuntu1) ... 343s Selecting previously unselected package gcc-14-arm-linux-gnueabihf. 343s Preparing to unpack .../28-gcc-14-arm-linux-gnueabihf_14.3.0-1ubuntu1_armhf.deb ... 343s Unpacking gcc-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 343s Selecting previously unselected package gcc-14. 343s Preparing to unpack .../29-gcc-14_14.3.0-1ubuntu1_armhf.deb ... 343s Unpacking gcc-14 (14.3.0-1ubuntu1) ... 343s Selecting previously unselected package gcc-arm-linux-gnueabihf. 343s Preparing to unpack .../30-gcc-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 343s Unpacking gcc-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 343s Selecting previously unselected package gcc. 343s Preparing to unpack .../31-gcc_4%3a14.2.0-1ubuntu1_armhf.deb ... 343s Unpacking gcc (4:14.2.0-1ubuntu1) ... 343s Selecting previously unselected package libstdc++-14-dev:armhf. 343s Preparing to unpack .../32-libstdc++-14-dev_14.3.0-1ubuntu1_armhf.deb ... 343s Unpacking libstdc++-14-dev:armhf (14.3.0-1ubuntu1) ... 343s Selecting previously unselected package g++-14-arm-linux-gnueabihf. 343s Preparing to unpack .../33-g++-14-arm-linux-gnueabihf_14.3.0-1ubuntu1_armhf.deb ... 343s Unpacking g++-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 344s Selecting previously unselected package g++-14. 344s Preparing to unpack .../34-g++-14_14.3.0-1ubuntu1_armhf.deb ... 344s Unpacking g++-14 (14.3.0-1ubuntu1) ... 344s Selecting previously unselected package g++-arm-linux-gnueabihf. 344s Preparing to unpack .../35-g++-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 344s Unpacking g++-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 344s Selecting previously unselected package g++. 344s Preparing to unpack .../36-g++_4%3a14.2.0-1ubuntu1_armhf.deb ... 344s Unpacking g++ (4:14.2.0-1ubuntu1) ... 344s Selecting previously unselected package build-essential. 344s Preparing to unpack .../37-build-essential_12.12ubuntu1_armhf.deb ... 344s Unpacking build-essential (12.12ubuntu1) ... 344s Selecting previously unselected package libllvm20:armhf. 344s Preparing to unpack .../38-libllvm20_1%3a20.1.6-0ubuntu1_armhf.deb ... 344s Unpacking libllvm20:armhf (1:20.1.6-0ubuntu1) ... 345s Selecting previously unselected package libclang-cpp20. 345s Preparing to unpack .../39-libclang-cpp20_1%3a20.1.6-0ubuntu1_armhf.deb ... 345s Unpacking libclang-cpp20 (1:20.1.6-0ubuntu1) ... 345s Selecting previously unselected package libgc1:armhf. 345s Preparing to unpack .../40-libgc1_1%3a8.2.8-1_armhf.deb ... 345s Unpacking libgc1:armhf (1:8.2.8-1) ... 345s Selecting previously unselected package libobjc4:armhf. 345s Preparing to unpack .../41-libobjc4_15.1.0-5ubuntu1_armhf.deb ... 345s Unpacking libobjc4:armhf (15.1.0-5ubuntu1) ... 345s Selecting previously unselected package libobjc-14-dev:armhf. 345s Preparing to unpack .../42-libobjc-14-dev_14.3.0-1ubuntu1_armhf.deb ... 345s Unpacking libobjc-14-dev:armhf (14.3.0-1ubuntu1) ... 346s Selecting previously unselected package libclang-common-20-dev:armhf. 346s Preparing to unpack .../43-libclang-common-20-dev_1%3a20.1.6-0ubuntu1_armhf.deb ... 346s Unpacking libclang-common-20-dev:armhf (1:20.1.6-0ubuntu1) ... 346s Selecting previously unselected package llvm-20-linker-tools. 346s Preparing to unpack .../44-llvm-20-linker-tools_1%3a20.1.6-0ubuntu1_armhf.deb ... 346s Unpacking llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 346s Selecting previously unselected package libclang1-20. 346s Preparing to unpack .../45-libclang1-20_1%3a20.1.6-0ubuntu1_armhf.deb ... 346s Unpacking libclang1-20 (1:20.1.6-0ubuntu1) ... 346s Selecting previously unselected package clang-20. 346s Preparing to unpack .../46-clang-20_1%3a20.1.6-0ubuntu1_armhf.deb ... 346s Unpacking clang-20 (1:20.1.6-0ubuntu1) ... 346s Selecting previously unselected package libdebhelper-perl. 346s Preparing to unpack .../47-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 346s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 346s Selecting previously unselected package libtool. 346s Preparing to unpack .../48-libtool_2.5.4-4_all.deb ... 346s Unpacking libtool (2.5.4-4) ... 346s Selecting previously unselected package dh-autoreconf. 346s Preparing to unpack .../49-dh-autoreconf_20_all.deb ... 346s Unpacking dh-autoreconf (20) ... 346s Selecting previously unselected package libarchive-zip-perl. 346s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 346s Unpacking libarchive-zip-perl (1.68-1) ... 346s Selecting previously unselected package libfile-stripnondeterminism-perl. 346s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 346s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 346s Selecting previously unselected package dh-strip-nondeterminism. 346s Preparing to unpack .../52-dh-strip-nondeterminism_1.14.1-2_all.deb ... 346s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 346s Selecting previously unselected package libdw1t64:armhf. 346s Preparing to unpack .../53-libdw1t64_0.193-1_armhf.deb ... 346s Unpacking libdw1t64:armhf (0.193-1) ... 346s Selecting previously unselected package debugedit. 346s Preparing to unpack .../54-debugedit_1%3a5.1-2_armhf.deb ... 346s Unpacking debugedit (1:5.1-2) ... 346s Selecting previously unselected package dwz. 346s Preparing to unpack .../55-dwz_0.15-1build6_armhf.deb ... 346s Unpacking dwz (0.15-1build6) ... 346s Selecting previously unselected package gettext. 346s Preparing to unpack .../56-gettext_0.23.1-2build1_armhf.deb ... 346s Unpacking gettext (0.23.1-2build1) ... 346s Selecting previously unselected package intltool-debian. 346s Preparing to unpack .../57-intltool-debian_0.35.0+20060710.6_all.deb ... 346s Unpacking intltool-debian (0.35.0+20060710.6) ... 346s Selecting previously unselected package po-debconf. 346s Preparing to unpack .../58-po-debconf_1.0.21+nmu1_all.deb ... 346s Unpacking po-debconf (1.0.21+nmu1) ... 346s Selecting previously unselected package debhelper. 346s Preparing to unpack .../59-debhelper_13.24.2ubuntu1_all.deb ... 346s Unpacking debhelper (13.24.2ubuntu1) ... 347s Selecting previously unselected package emacsen-common. 347s Preparing to unpack .../60-emacsen-common_3.0.8_all.deb ... 347s Unpacking emacsen-common (3.0.8) ... 347s Selecting previously unselected package dictionaries-common. 347s Preparing to unpack .../61-dictionaries-common_1.30.10_all.deb ... 347s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 347s Unpacking dictionaries-common (1.30.10) ... 347s Selecting previously unselected package libfakeroot:armhf. 347s Preparing to unpack .../62-libfakeroot_1.37.1.2-1_armhf.deb ... 347s Unpacking libfakeroot:armhf (1.37.1.2-1) ... 347s Selecting previously unselected package fakeroot. 347s Preparing to unpack .../63-fakeroot_1.37.1.2-1_armhf.deb ... 347s Unpacking fakeroot (1.37.1.2-1) ... 347s Selecting previously unselected package hunspell-en-us. 347s Preparing to unpack .../64-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 347s Unpacking hunspell-en-us (1:2020.12.07-4) ... 347s Selecting previously unselected package libpgtypes3:armhf. 347s Preparing to unpack .../65-libpgtypes3_17.5-1build1_armhf.deb ... 347s Unpacking libpgtypes3:armhf (17.5-1build1) ... 347s Selecting previously unselected package libpq5:armhf. 347s Preparing to unpack .../66-libpq5_17.5-1build1_armhf.deb ... 347s Unpacking libpq5:armhf (17.5-1build1) ... 347s Selecting previously unselected package libecpg6:armhf. 347s Preparing to unpack .../67-libecpg6_17.5-1build1_armhf.deb ... 347s Unpacking libecpg6:armhf (17.5-1build1) ... 347s Selecting previously unselected package libecpg-compat3:armhf. 347s Preparing to unpack .../68-libecpg-compat3_17.5-1build1_armhf.deb ... 347s Unpacking libecpg-compat3:armhf (17.5-1build1) ... 347s Selecting previously unselected package libssl-dev:armhf. 347s Preparing to unpack .../69-libssl-dev_3.5.0-2ubuntu1_armhf.deb ... 347s Unpacking libssl-dev:armhf (3.5.0-2ubuntu1) ... 347s Selecting previously unselected package libpq-dev. 347s Preparing to unpack .../70-libpq-dev_17.5-1build1_armhf.deb ... 347s Unpacking libpq-dev (17.5-1build1) ... 347s Selecting previously unselected package libecpg-dev. 347s Preparing to unpack .../71-libecpg-dev_17.5-1build1_armhf.deb ... 347s Unpacking libecpg-dev (17.5-1build1) ... 347s Selecting previously unselected package libicu76:armhf. 347s Preparing to unpack .../72-libicu76_76.1-4ubuntu1_armhf.deb ... 347s Unpacking libicu76:armhf (76.1-4ubuntu1) ... 348s Selecting previously unselected package libncurses-dev:armhf. 348s Preparing to unpack .../73-libncurses-dev_6.5+20250216-2_armhf.deb ... 348s Unpacking libncurses-dev:armhf (6.5+20250216-2) ... 348s Selecting previously unselected package libpython3.13:armhf. 348s Preparing to unpack .../74-libpython3.13_3.13.5-1_armhf.deb ... 348s Unpacking libpython3.13:armhf (3.13.5-1) ... 348s Selecting previously unselected package libtcl8.6:armhf. 348s Preparing to unpack .../75-libtcl8.6_8.6.16+dfsg-1_armhf.deb ... 348s Unpacking libtcl8.6:armhf (8.6.16+dfsg-1) ... 348s Selecting previously unselected package liblzma-dev:armhf. 348s Preparing to unpack .../76-liblzma-dev_5.8.1-1build1_armhf.deb ... 348s Unpacking liblzma-dev:armhf (5.8.1-1build1) ... 348s Selecting previously unselected package zlib1g-dev:armhf. 348s Preparing to unpack .../77-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_armhf.deb ... 348s Unpacking zlib1g-dev:armhf (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 348s Selecting previously unselected package libxml2-dev:armhf. 348s Preparing to unpack .../78-libxml2-dev_2.14.3+dfsg-0exp3_armhf.deb ... 348s Unpacking libxml2-dev:armhf (2.14.3+dfsg-0exp3) ... 348s Selecting previously unselected package libxslt1.1:armhf. 348s Preparing to unpack .../79-libxslt1.1_1.1.43-0exp1_armhf.deb ... 348s Unpacking libxslt1.1:armhf (1.1.43-0exp1) ... 348s Selecting previously unselected package llvm-20-runtime. 348s Preparing to unpack .../80-llvm-20-runtime_1%3a20.1.6-0ubuntu1_armhf.deb ... 348s Unpacking llvm-20-runtime (1:20.1.6-0ubuntu1) ... 348s Selecting previously unselected package libpfm4:armhf. 348s Preparing to unpack .../81-libpfm4_4.13.0+git99-gc5587f9-1_armhf.deb ... 348s Unpacking libpfm4:armhf (4.13.0+git99-gc5587f9-1) ... 348s Selecting previously unselected package llvm-20. 348s Preparing to unpack .../82-llvm-20_1%3a20.1.6-0ubuntu1_armhf.deb ... 348s Unpacking llvm-20 (1:20.1.6-0ubuntu1) ... 349s Selecting previously unselected package libffi-dev:armhf. 349s Preparing to unpack .../83-libffi-dev_3.4.8-2_armhf.deb ... 349s Unpacking libffi-dev:armhf (3.4.8-2) ... 349s Selecting previously unselected package llvm-20-tools. 349s Preparing to unpack .../84-llvm-20-tools_1%3a20.1.6-0ubuntu1_armhf.deb ... 349s Unpacking llvm-20-tools (1:20.1.6-0ubuntu1) ... 349s Selecting previously unselected package llvm-20-dev. 349s Preparing to unpack .../85-llvm-20-dev_1%3a20.1.6-0ubuntu1_armhf.deb ... 349s Unpacking llvm-20-dev (1:20.1.6-0ubuntu1) ... 351s Selecting previously unselected package locales-all. 351s Preparing to unpack .../86-locales-all_2.41-6ubuntu2_armhf.deb ... 351s Unpacking locales-all (2.41-6ubuntu2) ... 352s Selecting previously unselected package postgresql-client-17. 352s Preparing to unpack .../87-postgresql-client-17_17.5-1build1_armhf.deb ... 352s Unpacking postgresql-client-17 (17.5-1build1) ... 353s Selecting previously unselected package postgresql-17. 353s Preparing to unpack .../88-postgresql-17_17.5-1build1_armhf.deb ... 353s Unpacking postgresql-17 (17.5-1build1) ... 353s Selecting previously unselected package postgresql-server-dev-17. 353s Preparing to unpack .../89-postgresql-server-dev-17_17.5-1build1_armhf.deb ... 353s Unpacking postgresql-server-dev-17 (17.5-1build1) ... 353s Selecting previously unselected package postgresql-server-dev-all. 354s Preparing to unpack .../90-postgresql-server-dev-all_279_all.deb ... 354s Unpacking postgresql-server-dev-all (279) ... 354s Selecting previously unselected package postgresql-plperl-17. 354s Preparing to unpack .../91-postgresql-plperl-17_17.5-1build1_armhf.deb ... 354s Unpacking postgresql-plperl-17 (17.5-1build1) ... 354s Selecting previously unselected package postgresql-plpython3-17. 354s Preparing to unpack .../92-postgresql-plpython3-17_17.5-1build1_armhf.deb ... 354s Unpacking postgresql-plpython3-17 (17.5-1build1) ... 354s Selecting previously unselected package postgresql-pltcl-17. 354s Preparing to unpack .../93-postgresql-pltcl-17_17.5-1build1_armhf.deb ... 354s Unpacking postgresql-pltcl-17 (17.5-1build1) ... 354s Selecting previously unselected package postgresql-all. 354s Preparing to unpack .../94-postgresql-all_279_all.deb ... 354s Unpacking postgresql-all (279) ... 354s Selecting previously unselected package postgresql-doc-17. 354s Preparing to unpack .../95-postgresql-doc-17_17.5-1build1_all.deb ... 354s Unpacking postgresql-doc-17 (17.5-1build1) ... 354s Selecting previously unselected package postgresql-doc. 354s Preparing to unpack .../96-postgresql-doc_17+279_all.deb ... 354s Unpacking postgresql-doc (17+279) ... 354s Setting up libpython3.13:armhf (3.13.5-1) ... 354s Setting up postgresql-client-common (279) ... 354s Setting up libpgtypes3:armhf (17.5-1build1) ... 354s Setting up libio-pty-perl (1:1.20-1build3) ... 354s Setting up libarchive-zip-perl (1.68-1) ... 354s Setting up libclang-common-20-dev:armhf (1:20.1.6-0ubuntu1) ... 354s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 354s Setting up postgresql-doc-17 (17.5-1build1) ... 354s 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 354s Setting up libpq5:armhf (17.5-1build1) ... 354s Setting up linux-libc-dev:armhf (6.14.0-15.15) ... 354s Setting up m4 (1.4.19-8) ... 354s Setting up libgomp1:armhf (15.1.0-5ubuntu1) ... 354s Setting up libffi-dev:armhf (3.4.8-2) ... 354s Setting up locales-all (2.41-6ubuntu2) ... 354s Setting up libfakeroot:armhf (1.37.1.2-1) ... 354s Setting up libdw1t64:armhf (0.193-1) ... 354s Setting up fakeroot (1.37.1.2-1) ... 354s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 354s Setting up autotools-dev (20240727.1) ... 354s Setting up libpfm4:armhf (4.13.0+git99-gc5587f9-1) ... 354s Setting up rpcsvc-proto (1.4.3-1) ... 354s Setting up emacsen-common (3.0.8) ... 354s Setting up ssl-cert (1.1.3ubuntu1) ... 355s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 355s Setting up libssl-dev:armhf (3.5.0-2ubuntu1) ... 355s Setting up libmpc3:armhf (1.3.1-1build2) ... 355s Setting up libtcl8.6:armhf (8.6.16+dfsg-1) ... 355s Setting up autopoint (0.23.1-2build1) ... 355s Setting up libllvm20:armhf (1:20.1.6-0ubuntu1) ... 355s Setting up libipc-run-perl (20231003.0-2) ... 355s Setting up libgc1:armhf (1:8.2.8-1) ... 355s Setting up autoconf (2.72-3.1ubuntu1) ... 355s Setting up liblzma-dev:armhf (5.8.1-1build1) ... 355s Setting up libubsan1:armhf (15.1.0-5ubuntu1) ... 355s Setting up dwz (0.15-1build6) ... 355s Setting up libcrypt-dev:armhf (1:4.4.38-1) ... 355s Setting up libasan8:armhf (15.1.0-5ubuntu1) ... 355s Setting up libjson-perl (4.10000-1) ... 355s Setting up postgresql-doc (17+279) ... 355s Setting up libxslt1.1:armhf (1.1.43-0exp1) ... 355s Setting up debugedit (1:5.1-2) ... 355s Setting up libecpg6:armhf (17.5-1build1) ... 355s Setting up libicu76:armhf (76.1-4ubuntu1) ... 355s Setting up libgcc-14-dev:armhf (14.3.0-1ubuntu1) ... 355s Setting up libisl23:armhf (0.27-1) ... 355s Setting up libc-dev-bin (2.41-6ubuntu2) ... 355s Setting up libclang1-20 (1:20.1.6-0ubuntu1) ... 355s Setting up libcc1-0:armhf (15.1.0-5ubuntu1) ... 355s Setting up cpp-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 355s Setting up postgresql-common-dev (279) ... 355s Setting up automake (1:1.17-4ubuntu1) ... 355s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 355s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 355s Setting up gettext (0.23.1-2build1) ... 355s Setting up libecpg-compat3:armhf (17.5-1build1) ... 355s Setting up dictionaries-common (1.30.10) ... 355s Setting up postgresql-client-17 (17.5-1build1) ... 356s 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 356s Setting up gcc-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 356s Setting up llvm-20-runtime (1:20.1.6-0ubuntu1) ... 356s Setting up libpq-dev (17.5-1build1) ... 356s Setting up libobjc4:armhf (15.1.0-5ubuntu1) ... 356s Setting up libobjc-14-dev:armhf (14.3.0-1ubuntu1) ... 356s Setting up libecpg-dev (17.5-1build1) ... 356s Setting up intltool-debian (0.35.0+20060710.6) ... 356s Setting up llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 356s Setting up llvm-20-tools (1:20.1.6-0ubuntu1) ... 356s Setting up libclang-cpp20 (1:20.1.6-0ubuntu1) ... 356s Setting up llvm-20 (1:20.1.6-0ubuntu1) ... 356s Setting up postgresql-common (279) ... 357s Creating config file /etc/postgresql-common/createcluster.conf with new version 357s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 357s en_us 357s Removing obsolete dictionary files: 358s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 358s Setting up cpp-14 (14.3.0-1ubuntu1) ... 358s Setting up dh-strip-nondeterminism (1.14.1-2) ... 358s Setting up hunspell-en-us (1:2020.12.07-4) ... 358s Setting up libc6-dev:armhf (2.41-6ubuntu2) ... 358s Setting up libstdc++-14-dev:armhf (14.3.0-1ubuntu1) ... 358s Setting up cpp-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 358s Setting up clang-20 (1:20.1.6-0ubuntu1) ... 358s Setting up gcc-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 358s Setting up g++-14-arm-linux-gnueabihf (14.3.0-1ubuntu1) ... 358s Setting up postgresql-17 (17.5-1build1) ... 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 363s Setting up libncurses-dev:armhf (6.5+20250216-2) ... 363s Setting up po-debconf (1.0.21+nmu1) ... 363s Setting up gcc-14 (14.3.0-1ubuntu1) ... 363s Setting up postgresql-plpython3-17 (17.5-1build1) ... 363s Setting up zlib1g-dev:armhf (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 363s Setting up postgresql-plperl-17 (17.5-1build1) ... 363s Setting up cpp (4:14.2.0-1ubuntu1) ... 363s Setting up g++-14 (14.3.0-1ubuntu1) ... 363s Setting up g++-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 363s Setting up postgresql-pltcl-17 (17.5-1build1) ... 363s Setting up libtool (2.5.4-4) ... 363s Setting up gcc (4:14.2.0-1ubuntu1) ... 363s Setting up dh-autoreconf (20) ... 363s Setting up libxml2-dev:armhf (2.14.3+dfsg-0exp3) ... 363s Setting up llvm-20-dev (1:20.1.6-0ubuntu1) ... 363s Setting up g++ (4:14.2.0-1ubuntu1) ... 363s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 363s Setting up build-essential (12.12ubuntu1) ... 363s Setting up debhelper (13.24.2ubuntu1) ... 363s Setting up postgresql-server-dev-17 (17.5-1build1) ... 363s Setting up postgresql-server-dev-all (279) ... 363s Setting up postgresql-all (279) ... 363s Processing triggers for install-info (7.1.1-1) ... 363s Processing triggers for libc-bin (2.41-6ubuntu2) ... 363s Processing triggers for systemd (257.6-1ubuntu1) ... 363s Processing triggers for man-db (2.13.1-1) ... 364s Processing triggers for dictionaries-common (1.30.10) ... 379s autopkgtest [01:25:16]: test run-testsuite: [----------------------- 382s ====== Running all tests with umask 077 ======= 382s ### PostgreSQL test 001_packages.t ### 382s 1..23 382s ok 1 - /etc/os-release exists 382s ok 2 - OS is ubuntu 382s ok 3 - OS version is 25.10 382s # PostgreSQL versions installed: 17 382s # 17 382s ok 4 - postgresql-17 installed 382s ok 5 - postgresql-plpython3-17 installed 382s ok 6 - postgresql-plperl-17 installed 382s ok 7 - postgresql-pltcl-17 installed 382s ok 8 # skip No postgresql-17-jit package for version 17 382s ok 9 - postgresql-server-dev-17 installed 382s ok 10 # skip No postgresql-contrib-17 package for version 17 382s # postgresql-doc-17 installed 382s ok 11 - At least one doc package installed 382s ok 12 - libecpg-dev installed 382s ok 13 - postgresql-common-dev installed 382s ok 14 - procps installed 382s ok 15 - netcat-openbsd installed 382s ok 16 - hunspell-en-us installed 382s ok 17 - system has a default UTF-8 locale 382s ok 18 - locale ru_RU exists 382s ok 19 - locale ru_RU.UTF-8 exists 382s ok 20 - user postgres in the UNIX group ssl-cert 382s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 382s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 382s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 382s ### End test 001_packages.t ### 382s 382s ### PostgreSQL test 002_existing_clusters.t ### 382s 1..8 382s # Cleanup 382s ok 1 - Cleanup: No clusters left behind 382s ok 2 - No postgres processes left behind 382s ok 3 - No files in /etc/postgresql left behind 382s ok 4 - No files in /var/lib/postgresql left behind 382s ok 5 - No files in /var/run/postgresql left behind 382s ok 6 - No files in /var/log/postgresql left behind 382s ok 7 - PostgreSQL TCP ports are closed 382s ok 8 - Next free port is 5432 382s ### End test 002_existing_clusters.t ### 382s 382s ### PostgreSQL test 003_alternatives.t ### 382s 1..9 382s # Newest PG version installed is 17 382s ok 1 - psql.1.gz link group 382s ok 2 - postmaster.1.gz link group does not exist 382s ok 3 - psql.1.gz alternative 382s ok 4 - pg_dump.1.gz alternative 382s ok 5 - postgres.1.gz alternative 382s ok 6 - pg_ctl.1.gz alternative 382s # Newest PG doc version installed is 17 382s ok 7 - SPI_connect.3.gz link group 382s ok 8 - SPI_connect.3.gz alternative 382s ok 9 - SPI_exec.3.gz alternative 382s ### End test 003_alternatives.t ### 382s 382s ### PostgreSQL test 005_PgCommon.t ### 382s 1..24 382s ok 1 - correctly parsed line 'local all postgres ident sameuser' 382s ok 2 - correctly parsed line 'local foo nobody trust' 382s ok 3 - correctly parsed line 'local foo nobody crypt' 382s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 382s ok 5 - correctly parsed line 'local foo,bar nobody ident' 382s ok 6 - correctly parsed line 'local all +foogrp password' 382s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 382s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 382s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 382s ok 10 - @expected_records has correct number of entries 382s ok 11 - returned read_pg_hba array has correct number of records 382s ok 12 - line 'foo all all md5' parsed as invalid 382s ok 13 - line 'local all all foo' parsed as invalid 382s ok 14 - line 'host all all foo' parsed as invalid 382s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 382s ok 16 - line 'host all all md5' parsed as invalid 382s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 382s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 382s ok 19 - read_conf_file returns empty dict for nonexisting file 382s ok 20 - read_conf_file() parsing 382s ok 21 - read_conf_file() parsing with include directives 382s ok 22 - set_conf_value 382s ok 23 - disable_conf_value 382s ok 24 - replace_conf_value 382s ### End test 005_PgCommon.t ### 382s 382s ### PostgreSQL test 006_next_free_port.t ### 382s 1..5 382s ok 1 - next_free_port is 5432 383s ok 2 - next_free_port detects localhost ipv4 socket 384s ok 3 - next_free_port detects wildcard ipv4 socket 385s ok 4 - next_free_port detects localhost ipv6 socket 386s ok 5 - next_free_port detects wildcard ipv6 socket 386s ### End test 006_next_free_port.t ### 386s 386s ### PostgreSQL test 007_pg_conftool.t ### 386s 1..41 386s # test without cluster 386s ok 1 - pg_conftool show all 386s ok 2 - correct output of pg_conftool show all 386s ok 3 - pg_conftool foo.conf show all 386s ok 4 - correct output of pg_conftool foo.conf show all 387s ok 5 - pg_conftool /tmp/d3IXvxPa8A/different.conf show all 387s ok 6 - correct output of pg_conftool /tmp/d3IXvxPa8A/different.conf show all 387s ok 7 - pg_conftool 9.7 main show all 387s ok 8 - correct output of pg_conftool 9.7 main show all 387s # test show 387s ok 9 - pg_conftool show all 387s ok 10 - correct output of pg_conftool show all 387s ok 11 - pg_conftool other.conf show all 387s ok 12 - correct output of pg_conftool other.conf show all 387s ok 13 - pg_conftool /tmp/d3IXvxPa8A/different.conf show all 387s ok 14 - correct output of pg_conftool /tmp/d3IXvxPa8A/different.conf show all 387s ok 15 - pg_conftool 17 main show all 387s ok 16 - correct output of pg_conftool 17 main show all 387s ok 17 - pg_conftool 17 main other.conf show all 387s ok 18 - correct output of pg_conftool 17 main other.conf show all 387s ok 19 - pg_conftool show a 387s ok 20 - correct output of pg_conftool show a 387s ok 21 - pg_conftool -s show a 387s ok 22 - correct output of pg_conftool -s show a 387s # test set 387s ok 23 - pg_conftool set c 7 387s ok 24 - correct output of pg_conftool set c 7 387s ok 25 - file contains new setting 387s ok 26 - pg_conftool set a 8 387s ok 27 - correct output of pg_conftool set a 8 387s ok 28 - file contains updated setting 387s ok 29 - pg_conftool /tmp/d3IXvxPa8A/different.conf set a 9 387s ok 30 - correct output of pg_conftool /tmp/d3IXvxPa8A/different.conf set a 9 387s ok 31 - file with path contains updated setting 387s # test remove 387s ok 32 - pg_conftool remove a 387s ok 33 - correct output of pg_conftool remove a 387s ok 34 - setting removed from file 387s ok 35 - pg_conftool /tmp/d3IXvxPa8A/different.conf remove a 387s ok 36 - correct output of pg_conftool /tmp/d3IXvxPa8A/different.conf remove a 387s ok 37 - setting removed from file with path 387s # test edit 387s ok 38 - pg_conftool edit 387s ok 39 - correct output of pg_conftool edit 387s ok 40 - pg_conftool /tmp/d3IXvxPa8A/different.conf edit 387s ok 41 - correct output of pg_conftool /tmp/d3IXvxPa8A/different.conf edit 387s ### End test 007_pg_conftool.t ### 387s 387s ### PostgreSQL test 010_defaultport_cluster.t ### 387s 1..14 387s ok 1 - psql --version 387s ok 2 - pg_wrapper selects highest available version number 388s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 388s ok 4 - connecting to localhost fails with no clusters 388s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 388s ok 6 - pg_wrapper uses host and port from PGCLUSTER 388s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 388s ok 8 - pg_wrapper uses --cluster from the command line 388s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 388s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 388s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 388s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 388s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 388s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 388s ### End test 010_defaultport_cluster.t ### 388s 388s ### PostgreSQL test 015_start_stop.t ### 388s 1..71 388s # We are running systemd 388s # Running tests for 17 388s # Cluster does not exist yet 388s ok 1 - cluster 17 main does not exist 388s ok 2 - service postgresql@17-main does not exist 388s ok 3 - systemctl start postgresql 388s ok 4 - cluster 17 main does not exist 388s ok 5 - service postgresql@17-main does not exist 388s ok 6 - systemctl start postgresql@17-main 388s ok 7 - cluster 17 main does not exist 388s ok 8 - service postgresql@17-main does not exist 388s # Start/stop postgresql using system tools 389s ok 9 - pg_createcluster 17 main 389s ok 10 - cluster 17 main is stopped 390s ok 11 - service postgresql@17-main is stopped 392s ok 12 - systemctl start postgresql 392s ok 13 - cluster 17 main is running 392s ok 14 - service postgresql@17-main is running 392s ok 15 - systemctl start postgresql 392s ok 16 - cluster 17 main is already running 392s ok 17 - service postgresql@17-main is already running 392s ok 18 - systemctl stop postgresql 398s ok 19 - cluster 17 main is stopped 398s ok 20 - service postgresql@17-main is stopped 398s ok 21 - systemctl stop postgresql 398s ok 22 - cluster 17 main is already stopped 398s ok 23 - service postgresql@17-main is already stopped 398s # Start/stop specific cluster using system tools 400s ok 24 - systemctl start postgresql@17-main 400s ok 25 - cluster 17 main is running 400s ok 26 - service postgresql@17-main is running 400s ok 27 - systemctl start postgresql@17-main 400s ok 28 - cluster 17 main is running 400s ok 29 - service postgresql@17-main is running 403s ok 30 - systemctl restart postgresql@17-main 403s ok 31 - cluster 17 main is running 403s ok 32 - service postgresql@17-main is running 403s ok 33 - systemctl stop postgresql@17-main 403s ok 34 - cluster 17 main is stopped 403s ok 35 - service postgresql@17-main is stopped 403s ok 36 - systemctl stop postgresql@17-main 403s ok 37 - cluster 17 main is already stopped 403s ok 38 - service postgresql@17-main is already stopped 405s ok 39 - pg_dropcluster 17 main 405s ok 40 - cluster 17 main does not exist 405s ok 41 - service postgresql@17-main does not exist 405s # Start/stop specific cluster using pg_*cluster 405s ok 42 - pg_ctlcluster start 17 main 405s ok 43 - cluster 17 main does not exist 405s ok 44 - service postgresql@17-main does not exist 408s ok 45 - pg_createcluster 17 main --start 408s ok 46 - cluster 17 main is running 408s ok 47 - service postgresql@17-main is running 408s ok 48 - pg_ctlcluster 17 main start 408s ok 49 - cluster 17 main is already running 408s ok 50 - service postgresql@17-main is already running 411s ok 51 - pg_ctlcluster 17-main restart 411s ok 52 - cluster 17 main is running 411s ok 53 - service postgresql@17-main is running 411s ok 54 - pg_ctlcluster 17 main stop 411s ok 55 - cluster 17 main is stopped 411s ok 56 - service postgresql@17-main is stopped 411s ok 57 - pg_ctlcluster 17 main stop 411s ok 58 - cluster 17 main is already stopped 411s ok 59 - service postgresql@17-main is already stopped 413s ok 60 - pg_ctlcluster start 17-main 413s ok 61 - cluster 17 main is running 414s ok 62 - service postgresql@17-main is running 415s ok 63 - pg_dropcluster 17 main --stop 415s # Cleanup 415s ok 64 - Cleanup: No clusters left behind 415s ok 65 - No postgres processes left behind 415s ok 66 - No files in /etc/postgresql left behind 415s ok 67 - No files in /var/lib/postgresql left behind 415s ok 68 - No files in /var/run/postgresql left behind 415s ok 69 - No files in /var/log/postgresql left behind 415s ok 70 - PostgreSQL TCP ports are closed 415s ok 71 - Next free port is 5432 415s ### End test 015_start_stop.t ### 415s 415s ### PostgreSQL test 020_create_sql_remove.t ### 415s 1..141 415s # Running tests for 17 419s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.evnpUi 419s ok 2 - pg_createcluster 17 main 419s ok 3 - Socket and pid file are in /var/run/postgresql/ 419s ok 4 - xlog/wal directory /tmp/17.xlog.evnpUi was created 419s ok 5 - local method in pg_hba.conf is peer 419s ok 6 - host method in pg_hba.conf is scram-sha-256 419s ok 7 - Exactly one postgres master process running 421s ok 8 - pg_ctlcluster 17 main restart 421s ok 9 - cluster restarts with new environment file 421s ok 10 - Exactly one postgres master process running 421s ok 11 - correct value of PGEXTRAVAR1 in environment 421s ok 12 - correct value of PGEXTRAVAR2 in environment 421s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 421s ok 14 - createdb --version 421s ok 15 - pg_wrapper+createdb selects version number of cluster 421s ok 16 - psql --version 421s ok 17 - pg_wrapper+psql selects version 17 421s ok 18 - pg_lscluster reports online cluster on port 5432 421s ok 19 - log file is actually used 421s ok 20 - /etc/postgresql is owned by user "postgres" 421s ok 21 - version configuration directory file is owned by user "postgres" 421s ok 22 - configuration directory file is owned by user "postgres" 421s ok 23 - version data directory file is owned by user "postgres" 421s ok 24 - data directory file is owned by user "postgres" 421s ok 25 - log file has 0640 permissions 421s ok 26 - log file is owned by user "postgres" 421s ok 27 - log file is owned by group "adm" 421s ok 28 - no log symlink by default 421s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 421s ok 30 - pg_lsclusters -h 421s ok 31 - correct output of pg_lsclusters -h 421s ok 32 - stopping cluster 424s ok 33 - restarting cluster with nondefault log symlink 424s ok 34 - log target is used as log file 424s ok 35 - default log is not used 424s ok 36 - pg_lsclusters -h 424s ok 37 - correct output of pg_lsclusters -h 424s ok 38 - stopping cluster 427s ok 39 - restarting cluster with explicitly configured log file 427s ok 40 - default log is not used 427s ok 41 - log symlink target is used for startup message 427s ok 42 - exactly one log file 427s ok 43 - custom log is actually used 427s ok 44 - pg_lsclusters -h 427s ok 45 - correct output of pg_lsclusters -h 427s ok 46 - stopping cluster 427s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 427s ok 48 - /etc/postgres-hack was not created 430s ok 49 - restarting cluster 430s ok 50 - ps -o tty -U postgres h 430s ok 51 - postgres processes do not have an associated terminal 430s ok 52 - Server is linked with SSL support 430s ok 53 - SSL is enabled in postgresql.conf 430s ok 54 - psql -l fails for nobody 430s ok 55 - createuser nobody 430s ok 56 - createdb nobodydb 430s ok 57 - psql -ltA succeeds for nobody 430s ok 58 - psql -ltA output 430s ok 59 - SQL command: create table 430s ok 60 - SQL command: insert into table values 430s ok 61 - SQL command: insert into table values 430s ok 62 - primary key violation 430s ok 63 - psql -tAc "select * from phone order by name" nobodydb 430s ok 64 - SQL command output: select -tA 430s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 430s ok 66 - SQL command output: select -tx 430s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 430s ok 68 - SQL command output: select -tAx 430s ok 69 - CREATE EXTENSION plperlu fails for user nobody 430s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 430s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 431s ok 72 - creating PL/PerlU function as user nobody fails 431s ok 73 - creating unsafe PL/Perl function as user postgres fails 431s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 431s ok 75 - creating PL/PerlU function as user postgres succeeds 431s ok 76 - psql nobodydb -Atc "select read_file()" 431s ok 77 - calling PL/PerlU function 431s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 431s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 431s ok 80 - creating unsafe PL/Perl function as user nobody fails 431s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 431s ok 82 - creating PL/Perl function as user nobody succeeds 431s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 431s ok 84 - calling PL/Perl function 431s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 431s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 431s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 431s ok 88 - creating PL/Python3 function as user postgres succeeds 431s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 431s ok 90 - calling PL/Python function 431s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 431s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 431s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 431s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 431s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 431s ok 96 - creating PL/Tcl function as user nobody succeeds 431s 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;" 431s ok 98 - creating PL/TclU function as user postgres succeeds 431s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 431s ok 100 - calling PL/Tcl function 432s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 432s ok 102 - calling PL/TclU function 432s ok 103 - stopping cluster 432s ok 104 - pg_ctlcluster 17 main start 432s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 434s ok 106 - pg_ctlcluster 17 main start 434s ok 107 - cluster restarts with pgdata symlink 434s ok 108 # skip skipping postmaster OOM killer adjustment in container 434s ok 109 - postgres client backend has no OOM adjustment 434s ok 110 - ps h 5557 434s ok 111 - process title is idle 435s ok 112 - ps h 5557 435s ok 113 - process title is idle in transaction 435s ok 114 - stopping cluster 437s ok 115 - starting cluster as postgres works without a log file 437s ok 116 - log file got recreated and used 437s ok 117 - creating a directory in spc2 437s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.vx2bpH'" 437s ok 119 - creating tablespace spc1 438s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 438s ok 121 - creating a table in spc1 438s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.nE6FEK'" 438s ok 123 - creating tablespace spc2 438s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 438s ok 125 - creating a table in spc2 438s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 438s ok 127 - Correct apt NeverAutoRemove config 439s ok 128 - pg_dropcluster removes cluster 439s ok 129 - xlog/wal directory /tmp/17.xlog.evnpUi was deleted 439s ok 130 - tablespace spc1 was emptied 439s ok 131 - tablespace spc2 was emptied 439s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 439s ok 133 - Correct apt NeverAutoRemove config 439s # Cleanup 439s ok 134 - Cleanup: No clusters left behind 439s ok 135 - No postgres processes left behind 439s ok 136 - No files in /etc/postgresql left behind 439s ok 137 - No files in /var/lib/postgresql left behind 439s ok 138 - No files in /var/run/postgresql left behind 439s ok 139 - No files in /var/log/postgresql left behind 439s ok 140 - PostgreSQL TCP ports are closed 439s ok 141 - Next free port is 5432 439s ### End test 020_create_sql_remove.t ### 439s 439s ### PostgreSQL test 021_pg_renamecluster.t ### 439s 1..20 443s ok 1 - pg_createcluster 17 main 446s ok 2 - pg_renamecluster 17 main donau 446s ok 3 - psql -tAc "show data_directory" 446s ok 4 - cluster is running and data_directory was moved 446s ok 5 - pg_hba.conf location updated 446s ok 6 - pg_ident.conf location updated 446s ok 7 - external_pid_file location updated 446s ok 8 - external_pid_file exists 446s ok 9 # skip no stats_temp_directory in 17 446s ok 10 # skip no stats_temp_directory in 17 446s ok 11 - cluster_name is updated 447s ok 12 - pg_dropcluster removes cluster 447s # Cleanup 448s ok 13 - Cleanup: No clusters left behind 448s ok 14 - No postgres processes left behind 448s ok 15 - No files in /etc/postgresql left behind 448s ok 16 - No files in /var/lib/postgresql left behind 448s ok 17 - No files in /var/run/postgresql left behind 448s ok 18 - No files in /var/log/postgresql left behind 448s ok 19 - PostgreSQL TCP ports are closed 448s ok 20 - Next free port is 5432 448s ### End test 021_pg_renamecluster.t ### 448s 448s ### PostgreSQL test 022_recovery.t ### 448s 1..17 448s # Running tests for 17 451s ok 1 - pg_createcluster 17 main --start >/dev/null 451s ok 2 - pg_ctlcluster 17 main stop -m i 454s ok 3 - pg_ctlcluster 17 main start 454s ok 4 - psql -c '' 454s ok 5 - pg_ctlcluster 17 main stop -m i 454s ok 6 - create write-protected file in data directory 456s ok 7 - pg_ctlcluster 17 main start 456s ok 8 - psql -c '' 458s ok 9 - pg_dropcluster removes cluster 458s # Cleanup 458s ok 10 - Cleanup: No clusters left behind 458s ok 11 - No postgres processes left behind 458s ok 12 - No files in /etc/postgresql left behind 458s ok 13 - No files in /var/lib/postgresql left behind 458s ok 14 - No files in /var/run/postgresql left behind 458s ok 15 - No files in /var/log/postgresql left behind 458s ok 16 - PostgreSQL TCP ports are closed 458s ok 17 - Next free port is 5432 458s ### End test 022_recovery.t ### 458s 458s ### PostgreSQL test 025_logging.t ### 458s 1..55 459s # Logging to /var/log/syslog works 459s # Running tests for 17 462s ok 1 - pg_createcluster 17 main 462s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 462s ok 3 - psql -qc "'foobar_17_6694'" 462s ok 4 - log an error 463s ok 5 - grep --binary-files=text foobar_17_6694 /var/log/postgresql/postgresql-17-main.log 463s ok 6 - error appears in logfile 463s ok 7 - pg_conftool 17 main set log_destination syslog 463s ok 8 - set log_destination syslog 463s ok 9 - pg_ctlcluster 17 main reload 463s ok 10 - 17 main reload 463s ok 11 - psql -Atc "show log_destination" 463s ok 12 - log_destination is syslog 463s ok 13 - pg_lscluster reports syslog 463s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 463s ok 15 - error appears in /var/log/syslog 463s ok 16 - pg_conftool 17 main set logging_collector on 463s ok 17 - set logging_collector on 463s ok 18 - pg_conftool 17 main set log_destination csvlog 463s ok 19 - set log_destination csvlog 466s ok 20 - pg_ctlcluster 17 main restart 466s ok 21 - 17 main restart 466s ok 22 - psql -Atc "show logging_collector" 466s ok 23 - logging_collector is on 466s ok 24 - psql -Atc "show log_destination" 466s ok 25 - log_destination is csvlog 466s ok 26 - pg_lscluster reports csvlog 466s ok 27 - psql -qc "'barbaz_17_6694'" 466s ok 28 - log an error 467s ok 29 - grep --binary-files=text barbaz_17_6694 /var/lib/postgresql/17/main/log/*.csv 467s ok 30 - error appears in log/*.csv 467s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 467s ok 32 - set log_destination stderr,syslog,csvlog 467s ok 33 - pg_ctlcluster 17 main reload 467s ok 34 - 17 main reload 467s ok 35 - psql -Atc "show log_destination" 467s ok 36 - log_destination is stderr,syslog,csvlog 467s ok 37 - pg_lscluster reports stderr,syslog,csvlog 467s ok 38 - psql -qc "'moo_17_6694'" 467s ok 39 - log an error 467s ok 40 - grep --binary-files=text moo_17_6694 /var/lib/postgresql/17/main/log/*.log 467s ok 41 - error appears in log/*.log 468s ok 42 - grep --binary-files=text 'postgres.*moo_17_6694' /var/log/syslog 468s ok 43 - error appears in /var/log/syslog 468s ok 44 - grep --binary-files=text moo_17_6694 /var/lib/postgresql/17/main/log/*.csv 468s ok 45 - error appears in log/*.csv 470s ok 46 - pg_dropcluster 17 main --stop 470s ok 47 - pg_dropcluster removes cluster 470s # Cleanup 470s ok 48 - Cleanup: No clusters left behind 470s ok 49 - No postgres processes left behind 470s ok 50 - No files in /etc/postgresql left behind 470s ok 51 - No files in /var/lib/postgresql left behind 470s ok 52 - No files in /var/run/postgresql left behind 470s ok 53 - No files in /var/log/postgresql left behind 470s ok 54 - PostgreSQL TCP ports are closed 470s ok 55 - Next free port is 5432 470s ### End test 025_logging.t ### 470s 470s ### PostgreSQL test 027_jit.t ### 470s # 17 474s ok 1 - pg_createcluster 17 main --start 474s ok 2 - psql -Xatc 'show jit' 474s ok 3 - JIT is on by default 474s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 474s ok 5 - No JIT on cheap query 474s ok 6 - pg_conftool 17 main set seq_page_cost 100000 474s ok 7 - pg_conftool 17 main set random_page_cost 100000 474s ok 8 - pg_ctlcluster 17 main reload 474s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 474s ok 10 - Expensive query is JITed 476s ok 11 - pg_dropcluster --stop 17 main 476s # Cleanup 476s ok 12 - Cleanup: No clusters left behind 476s ok 13 - No postgres processes left behind 476s ok 14 - No files in /etc/postgresql left behind 476s ok 15 - No files in /var/lib/postgresql left behind 476s ok 16 - No files in /var/run/postgresql left behind 476s ok 17 - No files in /var/log/postgresql left behind 476s ok 18 - PostgreSQL TCP ports are closed 476s ok 19 - Next free port is 5432 476s 1..19 476s ### End test 027_jit.t ### 476s 476s ### PostgreSQL test 030_errors.t ### 476s 1..156 476s ok 1 - pg_lscluster reports cluster without binaries 477s ok 2 - pg_dropcluster 6.3 main 478s ok 3 - pg_createcluster --socketdir 478s ok 4 - pg_lsclusters -h 478s ok 5 - cluster was created 478s ok 6 - Port of created cluster is 5432 478s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 478s ok 8 - pg_createcluster on existing cluster 478s ok 9 - pg_lsclusters -h 478s ok 10 - original cluster still exists 478s ok 11 - pg_createcluster 17 test -p foo 478s ok 12 - pg_createcluster -p checks that port option is numeric 478s ok 13 - pg_createcluster 17 test -p 42 478s ok 14 - pg_createcluster -p checks valid port range 478s ok 15 - pg_ctlcluster 17 main start 478s ok 16 - pg_ctlcluster refuses to start root-owned cluster 478s ok 17 - pg_ctlcluster 17 main start 478s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 478s ok 19 - pg_ctlcluster 17 main start 478s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 478s ok 21 - pg_ctlcluster 17 main start 478s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 481s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 481s ok 24 - No sockets in /var/run/postgresql 481s ok 25 - Socket is in /tmp/postgresql-testsuite/ 481s ok 26 - cluster stops with custom unix_socket_dir 481s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 483s ok 28 - cluster starts after removing unix_socket_dir 483s ok 29 - Socket is in default dir /var/run/postgresql 483s ok 30 - No sockets in /tmp/postgresql-testsuite/ 483s ok 31 - pg_ctlcluster 17 main stop 483s ok 32 - pg_ctlcluster fails with corrupted PID file 483s ok 33 - pg_lsclusters -h 483s ok 34 - cluster is still online 483s ok 35 - pg_ctlcluster succeeds with restored PID file 483s ok 36 - pg_lsclusters -h 483s ok 37 - cluster is down 484s ok 38 - pg_ctlcluster 17 main stop 484s ok 39 - pg_ctlcluster stop fails on stopped cluster 486s ok 40 - pg_ctlcluster 17 main start 486s ok 41 - pg_ctlcluster succeeds with already existing PID file 486s ok 42 - pg_lsclusters -h 486s ok 43 - cluster is online 486s ok 44 - pg_ctlcluster stop succeeds 486s ok 45 - pg_lsclusters -h 486s ok 46 - cluster is down 486s ok 47 - no pid file left 486s ok 48 - pg_ctlcluster 17 main stop 486s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 486s ok 50 - pid file was cleaned up 486s ok 51 - pg_ctlcluster --force 17 main stop 486s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 486s ok 53 - pid file was cleaned up 486s ok 54 - pg_ctlcluster 17 main stop 486s ok 55 - pg_ctlcluster stop succeeds with stale PID file 486s ok 56 - pid file was cleaned up 486s ok 57 - pg_ctlcluster --force 17 main stop 486s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 486s ok 59 - pid file was cleaned up 486s ok 60 - pg_ctlcluster --force 17 main stop 486s ok 61 - pg_ctlcluster stop succeeds with empty PID file 486s ok 62 - pid file was cleaned up 488s ok 63 - pg_ctlcluster 17 main start 488s ok 64 - pg_ctlcluster succeeds with corrupted PID file 489s ok 65 - pg_lsclusters -h 489s ok 66 - cluster is online 489s ok 67 - pg_ctlcluster 17 main start 489s ok 68 - pg_ctlcluster start fails on running cluster 489s ok 69 - pg_ctlcluster stop 489s ok 70 - pg_ctlcluster 17 main start 489s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 489s ok 72 - pg_ctlcluster 17 main stop 489s ok 73 - stopping cluster 495s ok 74 - pg_ctlcluster 17 main start 495s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 495s ok 76 - pg_ctlcluster 17 main stop 495s ok 77 - stopping cluster 495s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 495s ok 79 - pg_dropcluster 17 main 495s ok 80 - pg_dropcluster works as user postgres 497s ok 81 - pg_createcluster succeeds 497s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 497s ok 83 - proper error message for nonexisting /var/lib/postgresql 499s ok 84 - pg_ctlcluster 17 main start 499s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 499s ok 86 - pg_ctlcluster 17 main stop 499s ok 87 - stopping cluster 500s ok 88 - pg_createcluster other 502s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 504s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 505s ok 91 505s ok 92 - pg_ctlcluster 17 other start 505s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 505s ok 94 - pg_ctlcluster 17 main stop 505s ok 95 - stopping main cluster 507s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 509s ok 97 - pg_dropcluster other 510s ok 98 - pg_dropcluster 510s ok 99 - No sockets any more 510s ok 100 - 'pg_lsclusters 4.5 foo' fails 510s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 510s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 510s ok 103 - 'psql --cluster 4.5/foo' fails 510s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 510s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 510s ok 106 - 'psql --cluster 17/foo' fails 510s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 510s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 510s ok 109 - 'pg_dropcluster 4.5 foo' fails 510s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 510s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 510s ok 112 - 'pg_dropcluster 17 foo' fails 510s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 510s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 510s ok 115 - 'pg_upgradecluster 4.5 foo' fails 510s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 510s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 510s ok 118 - 'pg_upgradecluster 17 foo' fails 510s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 510s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 510s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 510s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 510s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 510s ok 124 - 'pg_ctlcluster 17 foo stop' fails 510s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 510s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 510s # Cleanup 510s ok 127 - Cleanup: No clusters left behind 510s ok 128 - No postgres processes left behind 510s ok 129 - No files in /etc/postgresql left behind 510s ok 130 - No files in /var/lib/postgresql left behind 510s ok 131 - No files in /var/run/postgresql left behind 510s ok 132 - No files in /var/log/postgresql left behind 510s ok 133 - PostgreSQL TCP ports are closed 510s ok 134 - Next free port is 5432 511s ok 135 - pg_dropcluster 17 broken 511s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 511s # Cleanup 511s ok 137 - Cleanup: No clusters left behind 511s ok 138 - No postgres processes left behind 511s ok 139 - No files in /etc/postgresql left behind 511s ok 140 - No files in /var/lib/postgresql left behind 511s ok 141 - No files in /var/run/postgresql left behind 511s ok 142 - No files in /var/log/postgresql left behind 512s ok 143 - PostgreSQL TCP ports are closed 512s ok 144 - Next free port is 5432 513s ok 145 - pg_dropcluster 17 broken 513s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 513s ok 147 - /etc/postgresql/17 was removed 513s ok 148 - /var/lib/postgresql/17 was removed 513s # Cleanup 513s ok 149 - Cleanup: No clusters left behind 513s ok 150 - No postgres processes left behind 513s ok 151 - No files in /etc/postgresql left behind 513s ok 152 - No files in /var/lib/postgresql left behind 513s ok 153 - No files in /var/run/postgresql left behind 513s ok 154 - No files in /var/log/postgresql left behind 513s ok 155 - PostgreSQL TCP ports are closed 513s ok 156 - Next free port is 5432 513s ### End test 030_errors.t ### 513s 513s ### PostgreSQL test 031_errors_disk_full.t ### 513s 1..22 513s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 514s ok 1 - script failed 514s ok 2 - pg_createcluster fails due to insufficient disk space 514s ok 3 - does not leave files behind 514s # Cleanup 514s ok 4 - Cleanup: No clusters left behind 514s ok 5 - No postgres processes left behind 514s ok 6 - No files in /etc/postgresql left behind 514s ok 7 - No files in /var/lib/postgresql left behind 514s ok 8 - No files in /var/run/postgresql left behind 514s ok 9 - No files in /var/log/postgresql left behind 514s ok 10 - PostgreSQL TCP ports are closed 514s ok 11 - Next free port is 5432 514s # check disk full conditions on startup 517s ok 12 - script failed 517s ok 13 - pg_ctlcluster prints error message 517s ok 14 - log file has error message 517s # Cleanup 517s ok 15 - Cleanup: No clusters left behind 517s ok 16 - No postgres processes left behind 517s ok 17 - No files in /etc/postgresql left behind 517s ok 18 - No files in /var/lib/postgresql left behind 517s ok 19 - No files in /var/run/postgresql left behind 517s ok 20 - No files in /var/log/postgresql left behind 517s ok 21 - PostgreSQL TCP ports are closed 517s ok 22 - Next free port is 5432 517s ### End test 031_errors_disk_full.t ### 517s 517s ### PostgreSQL test 032_ssl_key_permissions.t ### 517s 1..22 517s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 517s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 517s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 518s ok 4 - pg_createcluster 17 main 518s ok 5 - pg_ctlcluster 17 main start 518s ok 6 - ssl key owned by nobody refused 519s ok 7 - pg_ctlcluster 17 main start 519s ok 8 - ssl key with permissions root:root 0644 refused 519s ok 9 - pg_ctlcluster 17 main start 519s ok 10 - ssl key with permissions postgres:postgres 0640 refused 520s ok 11 - pg_dropcluster 17 main --stop 520s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 520s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 520s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 520s # Cleanup 520s ok 15 - Cleanup: No clusters left behind 520s ok 16 - No postgres processes left behind 520s ok 17 - No files in /etc/postgresql left behind 520s ok 18 - No files in /var/lib/postgresql left behind 520s ok 19 - No files in /var/run/postgresql left behind 520s ok 20 - No files in /var/log/postgresql left behind 520s ok 21 - PostgreSQL TCP ports are closed 520s ok 22 - Next free port is 5432 520s ### End test 032_ssl_key_permissions.t ### 520s 520s ### PostgreSQL test 040_upgrade.t ### 520s 1..1 520s ok 1 - only one major version installed, skipping upgrade tests 520s ### End test 040_upgrade.t ### 520s 520s ### PostgreSQL test 041_upgrade_custompaths.t ### 520s 1..1 520s ok 1 - only one major version installed, skipping upgrade tests 520s ### End test 041_upgrade_custompaths.t ### 520s 520s ### PostgreSQL test 042_upgrade_rename.t ### 520s 1..15 520s # PostgreSQL 17 524s ok 1 - pg_createcluster 17 main --start 530s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 530s ok 3 - pg_lsclusters -h 530s ok 4 - correct output of pg_lsclusters -h 531s ok 5 - pg_dropcluster 17 main --stop 533s ok 6 - pg_dropcluster 17 upgr --stop 533s ok 7 - Cleaning pg_upgrade log files 533s # Cleanup 533s ok 8 - Cleanup: No clusters left behind 533s ok 9 - No postgres processes left behind 533s ok 10 - No files in /etc/postgresql left behind 533s ok 11 - No files in /var/lib/postgresql left behind 533s ok 12 - No files in /var/run/postgresql left behind 533s ok 13 - No files in /var/log/postgresql left behind 533s ok 14 - PostgreSQL TCP ports are closed 533s ok 15 - Next free port is 5432 533s ### End test 042_upgrade_rename.t ### 533s 533s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 533s 1..1 533s ok 1 - only one major version installed, skipping upgrade tests 533s ### End test 043_upgrade_ssl_cert.t ### 533s 533s ### PostgreSQL test 045_backup.t ### 533s # We are running systemd 533s # PostgreSQL 17 533s # create cluster 537s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 537s ok 2 - pg_lsclusters -h 537s ok 3 - correct output of pg_lsclusters -h 537s ok 4 - pg_conftool 17 main set work_mem 11MB 537s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 537s ok 6 - psql -c 'alter database mydb set search_path=public' 537s ok 7 - psql -c 'create table foo (t text)' mydb 537s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 537s ok 9 - psql -c 'CREATE USER myuser' 537s ok 10 - psql -c 'grant create on database mydb to myuser' 537s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 537s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 537s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 537s # create directory 537s ok 14 - pg_backupcluster 17 main createdirectory 537s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 537s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 537s # dump 538s ok 17 - systemctl start pg_dump@17-main 538s ok 18 - dump created in /var/backups/postgresql/17-main/2025-06-19T012754Z.dump 538s ok 19 - /var/backups/postgresql/17-main/2025-06-19T012754Z.dump owned by uid postgres 538s ok 20 - /var/backups/postgresql/17-main/2025-06-19T012754Z.dump owned by gid postgres 538s # basebackup 538s ok 21 - systemctl start pg_receivewal@17-main 538s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 538s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 539s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 539s ok 25 - psql -c 'select pg_reload_conf()' 567s ok 26 - systemctl start pg_basebackup@17-main 567s ok 27 - dump created in /var/backups/postgresql/17-main/2025-06-19T012756Z.backup 567s ok 28 - /var/backups/postgresql/17-main/2025-06-19T012756Z.backup owned by uid postgres 567s ok 29 - /var/backups/postgresql/17-main/2025-06-19T012756Z.backup owned by gid postgres 567s # list 567s ok 30 - pg_backupcluster 17 main list 567s ok 31 - correct output of pg_backupcluster 17 main list 567s # more database changes 567s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 567s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 567s ok 34 - retrieve recovery timestamp 567s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 568s ok 36 - systemctl stop pg_receivewal@17-main 568s # restore /var/backups/postgresql/17-main/2025-06-19T012754Z.dump 569s ok 37 - pg_dropcluster 17 main --stop 574s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T012754Z.dump --start --datadir /var/lib/postgresql/17/snowflake 575s ok 39 - pg_lsclusters -h 575s ok 40 - correct output of pg_lsclusters -h 575s ok 41 - psql -XAtl 575s ok 42 - mydb locales 575s ok 43 - mydb grants 575s ok 44 - myicudb locales 575s ok 45 - psql -XAtc 'show work_mem' 575s ok 46 - correct output of psql -XAtc 'show work_mem' 575s ok 47 - psql -XAtc 'select * from foo' mydb 575s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 575s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 575s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 575s ok 51 - psql -XAtc '\drds' 575s ok 52 - correct output of psql -XAtc '\drds' 575s # restore /var/backups/postgresql/17-main/2025-06-19T012756Z.backup 576s ok 53 - pg_dropcluster 17 main --stop 580s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T012756Z.backup --start --datadir /var/lib/postgresql/17/snowflake 580s ok 55 - pg_lsclusters -h 580s ok 56 - correct output of pg_lsclusters -h 580s ok 57 - psql -XAtl 580s ok 58 - mydb locales 580s ok 59 - mydb grants 580s ok 60 - myicudb locales 580s ok 61 - psql -XAtc 'show work_mem' 580s ok 62 - correct output of psql -XAtc 'show work_mem' 580s ok 63 - psql -XAtc 'select * from foo' mydb 580s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 580s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 580s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 580s ok 67 - psql -XAtc '\drds' 580s ok 68 - correct output of psql -XAtc '\drds' 580s # restore /var/backups/postgresql/17-main/2025-06-19T012756Z.backup with WAL archive 582s ok 69 - pg_dropcluster 17 main --stop 586s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T012756Z.backup --start --archive --port 5430 586s ok 71 - pg_lsclusters -h 586s ok 72 - correct output of pg_lsclusters -h 586s ok 73 - psql -XAtc 'select * from foo order by t' mydb 586s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 586s # restore /var/backups/postgresql/17-main/2025-06-19T012756Z.backup with PITR 588s ok 75 - pg_dropcluster 17 main --stop 592s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T012756Z.backup --start --pitr '2025-06-19 01:28:24.461594+00 592s # ' 592s ok 77 - pg_lsclusters -h 592s ok 78 - correct output of pg_lsclusters -h 592s ok 79 - psql -XAtc 'select * from foo order by t' mydb 592s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 593s ok 81 - pg_dropcluster 17 main --stop 594s # Cleanup 594s ok 82 - Cleanup: No clusters left behind 594s ok 83 - No postgres processes left behind 594s ok 84 - No files in /etc/postgresql left behind 594s ok 85 - No files in /var/lib/postgresql left behind 594s ok 86 - No files in /var/run/postgresql left behind 594s ok 87 - No files in /var/log/postgresql left behind 594s ok 88 - PostgreSQL TCP ports are closed 594s ok 89 - Next free port is 5432 594s 1..89 594s ### End test 045_backup.t ### 594s 594s ### PostgreSQL test 050_encodings.t ### 594s 1..60 594s # Checking 17 ru_RU 597s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 598s ok 2 - psql -l succeeds 598s ok 3 - template1 is not UTF-8 encoded 598s ok 4 - creating test database 598s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 598s # create table t (x varchar); copy t from stdin" test 598s ok 6 - creating table with ISO-8859-5 characters 598s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 598s ok 8 - correct string in UTF-8 598s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 598s ok 10 - correct string in ISO-8859-5 598s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 598s # delete from t; copy t from stdin" test 598s ok 12 - creating table with UTF-8 characters 598s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 598s ok 14 - correct string in UTF-8 598s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 598s ok 16 - correct string in ISO-8859-1 598s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 598s ok 18 - Server error message has correct language and encoding 601s ok 19 - pg_ctlcluster 17 ru_RU restart 601s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 603s ok 21 - Dropping cluster 603s # Checking 17 ru_RU.UTF-8 607s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 608s ok 23 - psql -l succeeds 608s ok 24 - template1 is UTF-8 encoded 608s ok 25 - creating test database 608s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 608s # create table t (x varchar); copy t from stdin" test 608s ok 27 - creating table with ISO-8859-5 characters 608s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 608s ok 29 - correct string in UTF-8 608s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 608s ok 31 - correct string in ISO-8859-5 608s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 608s # delete from t; copy t from stdin" test 608s ok 33 - creating table with UTF-8 characters 608s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 608s ok 35 - correct string in UTF-8 608s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 608s ok 37 - correct string in ISO-8859-1 608s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 608s ok 39 - Server error message has correct language and encoding 611s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 611s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 611s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 611s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 611s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 611s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 611s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 611s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 614s ok 48 - Dropping cluster 614s # Check 17 locale environment variables 617s ok 49 - pg_createcluster: LC_ALL dominates LANG 617s ok 50 - psql -Atl --cluster 17/main 617s ok 51 - template1 is ASCII encoded 619s ok 52 - Dropping cluster 619s # Cleanup 619s ok 53 - Cleanup: No clusters left behind 619s ok 54 - No postgres processes left behind 619s ok 55 - No files in /etc/postgresql left behind 619s ok 56 - No files in /var/lib/postgresql left behind 619s ok 57 - No files in /var/run/postgresql left behind 619s ok 58 - No files in /var/log/postgresql left behind 619s ok 59 - PostgreSQL TCP ports are closed 619s ok 60 - Next free port is 5432 619s ### End test 050_encodings.t ### 619s 619s ### PostgreSQL test 052_upgrade_encodings.t ### 619s 1..1 619s ok 1 - only one major version installed, skipping upgrade tests 619s ### End test 052_upgrade_encodings.t ### 619s 619s ### PostgreSQL test 060_obsolete_confparams.t ### 619s ok 1 - only one major version installed, skipping upgrade tests 619s 1..1 619s ### End test 060_obsolete_confparams.t ### 619s 619s ### PostgreSQL test 070_non_postgres_clusters.t ### 619s 1..40 621s ok 1 - pg_createcluster 17 main for owner nobody 621s ok 2 - pg_ctlcluster 17 main start 621s ok 3 - start refused when config and data owners mismatch 623s ok 4 - pg_ctlcluster succeeds with owner nobody 623s ok 5 - pg_lsclusters -h 623s ok 6 - pg_lsclusters shows running cluster 623s ok 7 - postgres is running as user nobody 623s ok 8 - ls /tmp/.s.PGSQL.* 623s ok 9 - socket is in /tmp 623s ok 10 - /var/run/postgresql is empty 623s ok 11 - conf dir is owned by user 623s ok 12 - conf dir is owned by user's primary group 623s ok 13 - files are owned by user 623s ok 14 - files are owned by user's primary group 623s ok 15 - log file has 0640 permissions 623s ok 16 - log file is owned by user 623s ok 17 - log file is owned by user's primary group 623s ok 18 - only one major version installed, skipping upgrade test 623s ok 19 - ... 623s ok 20 - ... 623s ok 21 - ... 623s ok 22 - ... 623s ok 23 - ... 623s ok 24 - ... 623s ok 25 - ... 623s ok 26 - ... 623s ok 27 - ... 623s ok 28 - ... 625s ok 29 - pg_dropcluster 625s ok 30 - pg_lsclusters -h 625s ok 31 - No clusters left 625s ok 32 - No postgres processes left 625s # Cleanup 625s ok 33 - Cleanup: No clusters left behind 625s ok 34 - No postgres processes left behind 625s ok 35 - No files in /etc/postgresql left behind 625s ok 36 - No files in /var/lib/postgresql left behind 625s ok 37 - No files in /var/run/postgresql left behind 625s ok 38 - No files in /var/log/postgresql left behind 625s ok 39 - PostgreSQL TCP ports are closed 625s ok 40 - Next free port is 5432 625s ### End test 070_non_postgres_clusters.t ### 625s 625s ### PostgreSQL test 080_start.conf.t ### 625s 1..73 626s ok 1 - pg_createcluster 17 main 626s # start.conf auto 626s ok 2 - get_cluster_start_conf returns auto 626s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 626s ok 4 - start.conf contains auto 626s ok 5 - systemd generator links cluster 626s ok 6 - systemd generator links correct service file 629s ok 7 - /etc/init.d/postgresql start 17 629s ok 8 - correct output of /etc/init.d/postgresql start 17 629s ok 9 - pg_lsclusters -h 629s ok 10 - cluster is online 629s ok 11 - /etc/init.d/postgresql stop 17 629s ok 12 - correct output of /etc/init.d/postgresql stop 17 632s ok 13 - pg_lsclusters -h 632s ok 14 - cluster is down 632s # start.conf manual 632s ok 15 - get_cluster_start_conf returns manual 632s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 632s ok 17 - start.conf contains manual 632s ok 18 - systemd generator doesn't link cluster 632s ok 19 - /etc/init.d/postgresql start 17 632s ok 20 - correct output of /etc/init.d/postgresql start 17 632s ok 21 - pg_lsclusters -h 632s ok 22 - cluster is down 635s ok 23 - pg_ctlcluster 17 main start 635s ok 24 - correct output of pg_ctlcluster 17 main start 635s ok 25 - pg_lsclusters -h 635s ok 26 - cluster is online 635s ok 27 - pg_ctlcluster 17 main stop 635s ok 28 - correct output of pg_ctlcluster 17 main stop 635s ok 29 - pg_lsclusters -h 635s ok 30 - cluster is down 635s # start.conf disabled 635s ok 31 - get_cluster_start_conf returns disabled 635s ok 32 - systemd generator doesn't link cluster 635s ok 33 - /etc/init.d/postgresql start 17 635s ok 34 - correct output of /etc/init.d/postgresql start 17 635s ok 35 - pg_lsclusters -h 635s ok 36 - cluster is down 635s ok 37 - pg_ctlcluster 17 main start 635s ok 38 - correct output of pg_ctlcluster 17 main start 635s ok 39 - pg_lsclusters -h 635s ok 40 - cluster is down 638s ok 41 - pg_ctlcluster 17 main start 638s ok 42 - correct output of pg_ctlcluster 17 main start 638s ok 43 - pg_lsclusters -h 638s ok 44 - cluster is online 638s ok 45 - pg_ctlcluster 17 main stop 638s ok 46 - correct output of pg_ctlcluster 17 main stop 638s ok 47 - pg_lsclusters -h 638s ok 48 - cluster is down 640s ok 49 - pg_ctlcluster 17 main start 640s ok 50 - correct output of pg_ctlcluster 17 main start 640s ok 51 - pg_lsclusters -h 640s ok 52 - cluster is online 640s # test upgrade 640s ok 53 - only one major version installed, skipping upgrade test 640s ok 54 - ... 640s ok 55 - get_cluster_start_conf for old cluster returns manual 640s ok 56 - get_cluster_start_conf for new cluster returns manual 640s ok 57 - ... 642s ok 58 - dropping upgraded cluster 642s ok 59 - pg_lsclusters -h 642s ok 60 - no clusters any more 642s ok 61 - pg_createcluster 17 main --start-conf foo 642s ok 62 - pg_createcluster checks --start-conf validity 643s ok 63 - pg_createcluster checks --start-conf manual 643s ok 64 - get_cluster_start_conf returns manual 644s ok 65 - dropping cluster 644s # Cleanup 644s ok 66 - Cleanup: No clusters left behind 644s ok 67 - No postgres processes left behind 644s ok 68 - No files in /etc/postgresql left behind 644s ok 69 - No files in /var/lib/postgresql left behind 644s ok 70 - No files in /var/run/postgresql left behind 644s ok 71 - No files in /var/log/postgresql left behind 644s ok 72 - PostgreSQL TCP ports are closed 644s ok 73 - Next free port is 5432 644s ### End test 080_start.conf.t ### 644s 644s ### PostgreSQL test 085_pg_ctl.conf.t ### 644s 1..33 644s ok 1 - prlimit --core=0:unlimited --pid=15008 644s ok 2 - set core file size to unlimited 644s ok 3 - sh -c 'ulimit -Hc' 644s ok 4 - core file size is unlimited 645s ok 5 - pg_createcluster 17 main 645s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 647s ok 7 - pg_ctlcluster 17 main start 647s ok 8 - starting cluster as root 647s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 647s ok 10 - soft core size is 0 647s # hard core file size limit of root-started postgres process is unlimited 647s ok 11 - set pg_ctl default option to -c 650s ok 12 - pg_ctlcluster 17 main restart 650s ok 13 - restarting cluster as root 650s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 650s ok 15 - soft core size is unlimited 650s ok 16 - pg_ctlcluster 17 main stop 650s ok 17 - stopping cluster 650s ok 18 - restored pg_ctl default option 652s ok 19 - pg_ctlcluster 17 main start -- -c 652s ok 20 - starting cluster with -c on the command line as postgres 652s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 652s ok 22 - soft core size is unlimited 653s ok 23 - pg_ctlcluster 17 main stop 653s ok 24 - stopping cluster 654s ok 25 - dropping cluster 654s # Cleanup 654s ok 26 - Cleanup: No clusters left behind 654s ok 27 - No postgres processes left behind 654s ok 28 - No files in /etc/postgresql left behind 654s ok 29 - No files in /var/lib/postgresql left behind 654s ok 30 - No files in /var/run/postgresql left behind 654s ok 31 - No files in /var/log/postgresql left behind 654s ok 32 - PostgreSQL TCP ports are closed 654s ok 33 - Next free port is 5432 654s ### End test 085_pg_ctl.conf.t ### 654s 654s ### PostgreSQL test 090_multicluster.t ### 654s 1..125 655s ok 1 - pg_createcluster 17 old 656s ok 2 - pg_createcluster 17 new1 657s ok 3 - pg_createcluster 17 new2 660s ok 4 - starting cluster 17/old 662s ok 5 - starting cluster 17/new1 664s ok 6 - starting cluster 17/new2 664s ok 7 - pg_lsclusters -h | sort -k3 664s ok 8 - clusters have the correct ports, skipping used 5433 664s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 664s ok 10 - createdb --version 664s ok 11 - pg_wrapper selects port 5432 as default cluster 664s ok 12 - createdb --cluster 17/new1 --version 664s ok 13 - pg_wrapper --cluster works 664s ok 14 - createdb --cluster 17/foo --version 664s ok 15 - pg_wrapper --cluster errors out for invalid cluster 665s ok 16 - createdb --cluster 17/new1 test 665s ok 17 - correct output of createdb --cluster 17/new1 test 665s ok 18 - psql -Atl --cluster 17/new1 665s ok 19 - test db appears in cluster new1 665s ok 20 - psql -Atl --cluster 17/new2 665s ok 21 - test db does not appear in cluster new2 665s ok 22 - psql -Atl 665s ok 23 - test db does not appear in default cluster 665s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 665s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 665s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 665s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 665s ok 28 - psql -Atl --cluster 17/localhost:5434 665s ok 29 - test db appears in cluster 17/localhost:5434 665s ok 30 - psql -Atl --cluster 17/localhost:5440 665s ok 31 - test db does not appear in cluster 17/localhost:5440 665s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 665s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 665s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 665s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 665s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 665s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 665s ok 38 - psql -Atl --cluster 6.4/localhost: 665s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 665s ok 40 - psql -Atl 665s ok 41 - PGCLUSTER selection (1) 665s ok 42 - psql -Atl 665s ok 43 - PGCLUSTER selection (2) 665s ok 44 - psql -l 665s ok 45 - invalid PGCLUSTER value 665s ok 46 - createdb --version 665s ok 47 - PGCLUSTER network cluster selection (1) 665s ok 48 - psql -Atl 665s ok 49 - PGCLUSTER network cluster selection (2) 665s ok 50 - psql -Atl 665s ok 51 - PGCLUSTER network cluster selection (3) 665s ok 52 - LC_MESSAGES=C psql -Atl 665s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 665s ok 54 - psql -Atc "show port" template1 665s ok 55 - PGPORT selection (1) 665s ok 56 - psql -Atc "show port" template1 665s ok 57 - PGPORT selection (2) 665s ok 58 - createdb --version 665s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 665s ok 60 - psql -Atc "show port" template1 665s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 665s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 665s ok 63 - PGDATABASE environment variable works 666s ok 64 - createdb --version 666s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 666s ok 66 - createdb --cluster 17/new1 --version 666s ok 67 - pg_wrapper --cluster works with empty user_clusters 666s ok 68 - createdb --version 666s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 666s ok 70 - psql -Atc "select current_database()" 666s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 666s ok 72 - psql -Atc 'select current_database()' 666s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 666s ok 74 - createdb --version 666s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 666s ok 76 - createdb --version 666s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 666s ok 78 - createdb --version 666s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 666s ok 80 - createdb --version 666s ok 81 - pg_wrapper selects correct version with per-user user_clusters 666s ok 82 - createdb --version 666s ok 83 - pg_wrapper selects correct version with per-user user_clusters 666s ok 84 - createdb --version 666s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 666s ok 86 - psql -Atl 666s ok 87 - $PGHOST overrides user_clusters 666s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 666s ok 89 - --cluster overrides $PGHOST 666s ok 90 - createdb --version 666s ok 91 - pg_wrapper ignores invalid lines in user_clusters 666s ok 92 - psql -Atc 'select current_database()' 666s ok 93 - pg_service conf selection 1 666s ok 94 - psql -Atc 'select current_database()' 666s ok 95 - pg_service conf selection 2 666s ok 96 - psql -Atc 'select current_database()' 666s ok 97 - pg_service conf selection 3 667s ok 98 - stopping cluster 17/old 669s ok 99 - restarting cluster 17/old 669s ok 100 - pg_lsclusters -h | sort -k3 669s ok 101 - port of first cluster was successfully changed 669s ok 102 - psql -l 669s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 669s ok 104 - psql -Atl --cluster 17/new1 669s ok 105 - --cluster selects appropriate cluster 669s ok 106 - psql -Atl -p 5434 669s ok 107 - -p selects appropriate cluster 669s ok 108 - psql -Atlp 5434 669s ok 109 - -Atlp selects appropriate cluster 669s ok 110 - psql -Atl --port 5434 669s ok 111 - --port selects appropriate cluster 669s ok 112 - env PGPORT=5434 psql -Atl 669s ok 113 - $PGPORT selects appropriate cluster 669s ok 114 - Restoring original /etc/postgresql-common/user_clusters 671s ok 115 - dropping 17/new1 673s ok 116 - dropping 17/new2 675s ok 117 - dropping 17/old 675s # Cleanup 675s ok 118 - Cleanup: No clusters left behind 675s ok 119 - No postgres processes left behind 675s ok 120 - No files in /etc/postgresql left behind 675s ok 121 - No files in /var/lib/postgresql left behind 675s ok 122 - No files in /var/run/postgresql left behind 675s ok 123 - No files in /var/log/postgresql left behind 675s ok 124 - PostgreSQL TCP ports are closed 675s ok 125 - Next free port is 5432 675s ### End test 090_multicluster.t ### 675s 675s ### PostgreSQL test 110_integrate_cluster.t ### 675s 1..32 677s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/Eo8OdoJpDZ/c/postgres 677s ok 2 - creating raw initdb cluster for user postgres 678s ok 3 - pg_createcluster 17 postgres -d /tmp/Eo8OdoJpDZ/c/postgres 678s ok 4 - integrating postgres cluster 679s ok 5 - pg_lsclusters 679s ok 6 - correct pg_lsclusters output 680s ok 7 - pg_ctlcluster 17 postgres start 680s ok 8 - starting cluster postgres 680s ok 9 - pg_lsclusters 680s ok 10 - correct pg_lsclusters output 682s ok 11 - dropping cluster postgres 682s ok 12 - No files in temporary cluster dir left behind 684s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/Eo8OdoJpDZ/c/nobody 684s ok 14 - creating raw initdb cluster for user nobody 684s ok 15 - pg_createcluster 17 nobody -d /tmp/Eo8OdoJpDZ/c/nobody 684s ok 16 - integrating nobody cluster 684s ok 17 - pg_lsclusters 684s ok 18 - correct pg_lsclusters output 687s ok 19 - pg_ctlcluster 17 nobody start 687s ok 20 - starting cluster nobody 687s ok 21 - pg_lsclusters 687s ok 22 - correct pg_lsclusters output 688s ok 23 - dropping cluster nobody 688s ok 24 - No files in temporary cluster dir left behind 688s # Cleanup 688s ok 25 - Cleanup: No clusters left behind 688s ok 26 - No postgres processes left behind 688s ok 27 - No files in /etc/postgresql left behind 688s ok 28 - No files in /var/lib/postgresql left behind 688s ok 29 - No files in /var/run/postgresql left behind 688s ok 30 - No files in /var/log/postgresql left behind 688s ok 31 - PostgreSQL TCP ports are closed 688s ok 32 - Next free port is 5432 688s ### End test 110_integrate_cluster.t ### 688s 688s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 688s 1..1 688s ok 1 - only one major version installed, skipping upgrade tests 688s ### End test 120_pg_upgradecluster_scripts.t ### 688s 688s ### PostgreSQL test 130_nonroot_admin.t ### 688s 1..22 692s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 692s ok 2 - pg_lsclusters -h 692s ok 3 - correct output of pg_lsclusters -h 692s ok 4 - psql -Atl 692s ok 5 - correct output of psql -Atl 692s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 692s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 692s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 692s # Cleanup 692s ok 15 - Cleanup: No clusters left behind 692s ok 16 - No postgres processes left behind 692s ok 17 - No files in /etc/postgresql left behind 692s ok 18 - No files in /var/lib/postgresql left behind 692s ok 19 - No files in /var/run/postgresql left behind 692s ok 20 - No files in /var/log/postgresql left behind 692s ok 21 - PostgreSQL TCP ports are closed 692s ok 22 - Next free port is 5432 692s ### End test 130_nonroot_admin.t ### 692s 692s ### PostgreSQL test 135_pg_virtualenv.t ### 692s 1..20 697s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 697s ok 2 - running pg_virtualenv as root 700s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 700s ok 4 - running pg_virtualenv as postgres 703s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 703s ok 6 - running pg_virtualenv as nobody 707s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 707s ok 8 - running fakeroot pg_virtualenv as root 710s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 710s ok 10 - running fakeroot pg_virtualenv as postgres 714s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 714s ok 12 - running fakeroot pg_virtualenv as nobody 714s # Cleanup 714s ok 13 - Cleanup: No clusters left behind 714s ok 14 - No postgres processes left behind 714s ok 15 - No files in /etc/postgresql left behind 714s ok 16 - No files in /var/lib/postgresql left behind 714s ok 17 - No files in /var/run/postgresql left behind 714s ok 18 - No files in /var/log/postgresql left behind 714s ok 19 - PostgreSQL TCP ports are closed 714s ok 20 - Next free port is 5432 714s ### End test 135_pg_virtualenv.t ### 714s 714s ### PostgreSQL test 140_pg_config.t ### 714s 1..38 714s # Multiarch is enabled 714s # checking version specific output for 17 714s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 714s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 714s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 714s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 714s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 714s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 714s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 714s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 714s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 714s # checking pg_config output (should behave like version 17) 714s ok 15 - pg_config 714s ok 16 - correct output of pg_config 714s ok 17 - pg_config --help 714s ok 18 - correct output of pg_config --help 714s ok 19 - pg_config --pgxs 714s ok 20 - correct output of pg_config --pgxs 714s ok 21 - pg_config --libdir 714s ok 22 - correct output of pg_config --libdir 714s ok 23 - pg_config --pkglibdir 714s ok 24 - correct output of pg_config --pkglibdir 714s ok 25 - pg_config --bindir 714s ok 26 - correct output of pg_config --bindir 714s # checking pg_config.libpq-dev output (should behave like version 17) 714s ok 27 - pg_config.libpq-dev 714s ok 28 - correct output of pg_config.libpq-dev 714s ok 29 - pg_config.libpq-dev --help 714s ok 30 - correct output of pg_config.libpq-dev --help 714s ok 31 - pg_config.libpq-dev --pgxs 714s ok 32 - correct output of pg_config.libpq-dev --pgxs 714s ok 33 - pg_config.libpq-dev --libdir 714s ok 34 - correct output of pg_config.libpq-dev --libdir 714s ok 35 - pg_config.libpq-dev --pkglibdir 714s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 714s ok 37 - pg_config.libpq-dev --bindir 714s ok 38 - correct output of pg_config.libpq-dev --bindir 714s ### End test 140_pg_config.t ### 714s 714s ### PostgreSQL test 150_tsearch_stemming.t ### 714s 1..37 714s ok 1 - pg_updatedicts succeeded 714s ok 2 - pg_updatedicts created en_us.affix 714s ok 3 - pg_updatedicts created en_us.dict 714s ok 4 - pg_updatedicts created 17 en_us.affix symlink 714s ok 5 - pg_updatedicts created 17 en_us.dict symlink 718s ok 6 - pg_createcluster 17 main 718s ok 7 - createdb fts 718s ok 8 - correct output of createdb fts 718s ok 9 - creating en_US full text search configuration 718s ok 10 - creating data table and search index 718s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 718s ok 12 - stem search of correct word 718s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 718s ok 14 - stem search of correct word 719s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 719s ok 16 - stem search of unknown word 719s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 719s ok 18 - full text search, exact word 719s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 719s ok 20 - full text search for word stem 719s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 719s ok 22 - full text search for word substring fails 719s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 719s ok 24 - full text search, exact unicode word 719s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 719s ok 26 - full text search for unicode word stem 719s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 719s ok 28 - full text search for unicode word substring fails 720s ok 29 720s # Cleanup 720s ok 30 - Cleanup: No clusters left behind 720s ok 31 - No postgres processes left behind 720s ok 32 - No files in /etc/postgresql left behind 720s ok 33 - No files in /var/lib/postgresql left behind 720s ok 34 - No files in /var/run/postgresql left behind 720s ok 35 - No files in /var/log/postgresql left behind 720s ok 36 - PostgreSQL TCP ports are closed 720s ok 37 - Next free port is 5432 720s ### End test 150_tsearch_stemming.t ### 720s 720s ### PostgreSQL test 160_alternate_confroot.t ### 720s 1..28 725s ok 1 725s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 725s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 725s ok 4 - pg_lsclusters -h 725s ok 5 - correct output of pg_lsclusters -h 725s ok 6 - psql -Atl 725s ok 7 - correct output of psql -Atl 725s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 725s ok 9 - ... 725s ok 10 - ... 725s ok 11 - ... 725s ok 12 - ... 725s ok 13 - ... 725s ok 14 - ... 725s ok 15 - pg_dropcluster 17 test --stop 725s ok 16 - correct output of pg_dropcluster 17 test --stop 725s ok 17 - pg_lsclusters -h 725s ok 18 - correct output of pg_lsclusters -h 725s ok 19 - No files in root/data left behind 725s ok 20 - No cruft in root dir left behind 725s # Cleanup 725s ok 21 - Cleanup: No clusters left behind 725s ok 22 - No postgres processes left behind 725s ok 23 - No files in /etc/postgresql left behind 725s ok 24 - No files in /var/lib/postgresql left behind 725s ok 25 - No files in /var/run/postgresql left behind 725s ok 26 - No files in /var/log/postgresql left behind 725s ok 27 - PostgreSQL TCP ports are closed 725s ok 28 - Next free port is 5432 725s ### End test 160_alternate_confroot.t ### 725s 725s ### PostgreSQL test 170_extensions.t ### 725s # Running tests for 17 729s ok 1 - pg_createcluster 17 main 729s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 729s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 729s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 729s ok 5 - extension amcheck installs without error 729s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 729s ok 7 - extension amcheck removes without error 729s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 729s ok 9 - extension autoinc installs without error 729s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 729s ok 11 - extension autoinc removes without error 729s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 729s ok 13 - extension bloom installs without error 729s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 729s ok 15 - extension bloom removes without error 729s ok 16 - psql -qc 'CREATE EXTENSION plperl' 729s ok 17 - bool_plperl dependency plperl installs without error 729s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 729s ok 19 - extension bool_plperl installs without error 729s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 729s ok 21 - extension bool_plperl removes without error 729s ok 22 - psql -qc 'DROP EXTENSION plperl' 729s ok 23 - bool_plperl dependency extension plperl removes without error 729s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 729s ok 25 - bool_plperlu dependency plperlu installs without error 729s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 729s ok 27 - extension bool_plperlu installs without error 729s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 729s ok 29 - extension bool_plperlu removes without error 729s ok 30 - psql -qc 'DROP EXTENSION plperlu' 729s ok 31 - bool_plperlu dependency extension plperlu removes without error 729s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 729s ok 33 - extension btree_gin installs without error 729s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 729s ok 35 - extension btree_gin removes without error 729s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 729s ok 37 - extension btree_gist installs without error 730s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 730s ok 39 - extension btree_gist removes without error 730s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 730s ok 41 - extension citext installs without error 730s ok 42 - psql -qc 'DROP EXTENSION "citext"' 730s ok 43 - extension citext removes without error 730s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 730s ok 45 - extension cube installs without error 730s ok 46 - psql -qc 'DROP EXTENSION "cube"' 730s ok 47 - extension cube removes without error 730s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 730s ok 49 - extension dblink installs without error 730s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 730s ok 51 - extension dblink removes without error 730s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 730s ok 53 - extension dict_int installs without error 730s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 730s ok 55 - extension dict_int removes without error 730s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 730s ok 57 - extension dict_xsyn installs without error 730s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 730s ok 59 - extension dict_xsyn removes without error 730s ok 60 - psql -qc 'CREATE EXTENSION cube' 730s ok 61 - earthdistance dependency cube installs without error 730s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 730s ok 63 - extension earthdistance installs without error 730s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 730s ok 65 - extension earthdistance removes without error 730s ok 66 - psql -qc 'DROP EXTENSION cube' 730s ok 67 - earthdistance dependency extension cube removes without error 730s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 730s ok 69 - extension file_fdw installs without error 730s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 730s ok 71 - extension file_fdw removes without error 730s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 730s ok 73 - extension fuzzystrmatch installs without error 730s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 730s ok 75 - extension fuzzystrmatch removes without error 731s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 731s ok 77 - extension hstore installs without error 731s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 731s ok 79 - extension hstore removes without error 731s ok 80 - psql -qc 'CREATE EXTENSION hstore' 731s ok 81 - hstore_plperl dependency hstore installs without error 731s ok 82 - psql -qc 'CREATE EXTENSION plperl' 731s ok 83 - hstore_plperl dependency plperl installs without error 731s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 731s ok 85 - extension hstore_plperl installs without error 731s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 731s ok 87 - extension hstore_plperl removes without error 731s ok 88 - psql -qc 'DROP EXTENSION hstore' 731s ok 89 - hstore_plperl dependency extension hstore removes without error 731s ok 90 - psql -qc 'DROP EXTENSION plperl' 731s ok 91 - hstore_plperl dependency extension plperl removes without error 731s ok 92 - psql -qc 'CREATE EXTENSION hstore' 731s ok 93 - hstore_plperlu dependency hstore installs without error 731s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 731s ok 95 - hstore_plperlu dependency plperlu installs without error 731s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 731s ok 97 - extension hstore_plperlu installs without error 731s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 731s ok 99 - extension hstore_plperlu removes without error 731s ok 100 - psql -qc 'DROP EXTENSION hstore' 731s ok 101 - hstore_plperlu dependency extension hstore removes without error 731s ok 102 - psql -qc 'DROP EXTENSION plperlu' 731s ok 103 - hstore_plperlu dependency extension plperlu removes without error 731s ok 104 - psql -qc 'CREATE EXTENSION hstore' 731s ok 105 - hstore_plpython3u dependency hstore installs without error 731s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 731s ok 107 - hstore_plpython3u dependency plpython3u installs without error 731s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 731s ok 109 - extension hstore_plpython3u installs without error 731s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 731s ok 111 - extension hstore_plpython3u removes without error 731s ok 112 - psql -qc 'DROP EXTENSION hstore' 731s ok 113 - hstore_plpython3u dependency extension hstore removes without error 731s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 731s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 732s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 732s ok 117 - extension insert_username installs without error 732s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 732s ok 119 - extension insert_username removes without error 732s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 732s ok 121 - extension intagg installs without error 732s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 732s ok 123 - extension intagg removes without error 732s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 732s ok 125 - extension intarray installs without error 732s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 732s ok 127 - extension intarray removes without error 732s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 732s ok 129 - extension isn installs without error 732s ok 130 - psql -qc 'DROP EXTENSION "isn"' 732s ok 131 - extension isn removes without error 732s ok 132 - psql -qc 'CREATE EXTENSION plperl' 732s ok 133 - jsonb_plperl dependency plperl installs without error 732s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 732s ok 135 - extension jsonb_plperl installs without error 732s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 732s ok 137 - extension jsonb_plperl removes without error 732s ok 138 - psql -qc 'DROP EXTENSION plperl' 732s ok 139 - jsonb_plperl dependency extension plperl removes without error 732s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 732s ok 141 - jsonb_plperlu dependency plperlu installs without error 732s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 732s ok 143 - extension jsonb_plperlu installs without error 732s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 732s ok 145 - extension jsonb_plperlu removes without error 732s ok 146 - psql -qc 'DROP EXTENSION plperlu' 732s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 732s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 732s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 732s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 732s ok 151 - extension jsonb_plpython3u installs without error 732s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 732s ok 153 - extension jsonb_plpython3u removes without error 733s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 733s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 733s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 733s ok 157 - extension lo installs without error 733s ok 158 - psql -qc 'DROP EXTENSION "lo"' 733s ok 159 - extension lo removes without error 733s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 733s ok 161 - extension ltree installs without error 733s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 733s ok 163 - extension ltree removes without error 733s ok 164 - psql -qc 'CREATE EXTENSION ltree' 733s ok 165 - ltree_plpython3u dependency ltree installs without error 733s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 733s ok 167 - ltree_plpython3u dependency plpython3u installs without error 733s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 733s ok 169 - extension ltree_plpython3u installs without error 733s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 733s ok 171 - extension ltree_plpython3u removes without error 733s ok 172 - psql -qc 'DROP EXTENSION ltree' 733s ok 173 - ltree_plpython3u dependency extension ltree removes without error 733s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 733s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 733s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 733s ok 177 - extension moddatetime installs without error 733s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 733s ok 179 - extension moddatetime removes without error 733s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 733s ok 181 - extension pageinspect installs without error 733s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 733s ok 183 - extension pageinspect removes without error 733s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 733s ok 185 - extension pg_buffercache installs without error 733s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 733s ok 187 - extension pg_buffercache removes without error 733s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 733s ok 189 - extension pg_freespacemap installs without error 733s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 733s ok 191 - extension pg_freespacemap removes without error 734s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 734s ok 193 - extension pg_prewarm installs without error 734s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 734s ok 195 - extension pg_prewarm removes without error 734s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 734s ok 197 - extension pg_stat_statements installs without error 734s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 734s ok 199 - extension pg_stat_statements removes without error 734s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 734s ok 201 - extension pg_surgery installs without error 734s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 734s ok 203 - extension pg_surgery removes without error 734s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 734s ok 205 - extension pg_trgm installs without error 734s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 734s ok 207 - extension pg_trgm removes without error 734s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 734s ok 209 - extension pg_visibility installs without error 734s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 734s ok 211 - extension pg_visibility removes without error 734s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 734s ok 213 - extension pg_walinspect installs without error 734s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 734s ok 215 - extension pg_walinspect removes without error 734s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 734s ok 217 - extension pgcrypto installs without error 734s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 734s ok 219 - extension pgcrypto removes without error 734s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 734s ok 221 - extension pgrowlocks installs without error 734s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 734s ok 223 - extension pgrowlocks removes without error 734s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 734s ok 225 - extension pgstattuple installs without error 734s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 734s ok 227 - extension pgstattuple removes without error 734s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 734s ok 229 - extension plperl installs without error 734s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 734s ok 231 - extension plperl removes without error 734s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 734s ok 233 - extension plperlu installs without error 735s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 735s ok 235 - extension plperlu removes without error 735s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 735s ok 237 - extension plpython3u installs without error 735s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 735s ok 239 - extension plpython3u removes without error 735s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 735s ok 241 - extension pltcl installs without error 735s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 735s ok 243 - extension pltcl removes without error 735s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 735s ok 245 - extension pltclu installs without error 735s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 735s ok 247 - extension pltclu removes without error 735s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 735s ok 249 - extension postgres_fdw installs without error 735s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 735s ok 251 - extension postgres_fdw removes without error 735s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 735s ok 253 - extension refint installs without error 735s ok 254 - psql -qc 'DROP EXTENSION "refint"' 735s ok 255 - extension refint removes without error 735s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 735s ok 257 - extension seg installs without error 735s ok 258 - psql -qc 'DROP EXTENSION "seg"' 735s ok 259 - extension seg removes without error 735s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 735s ok 261 - extension sslinfo installs without error 735s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 735s ok 263 - extension sslinfo removes without error 735s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 735s ok 265 - extension tablefunc installs without error 735s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 735s ok 267 - extension tablefunc removes without error 735s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 735s ok 269 - extension tcn installs without error 735s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 735s ok 271 - extension tcn removes without error 735s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 735s ok 273 - extension tsm_system_rows installs without error 735s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 735s ok 275 - extension tsm_system_rows removes without error 735s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 735s ok 277 - extension tsm_system_time installs without error 736s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 736s ok 279 - extension tsm_system_time removes without error 736s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 736s ok 281 - extension unaccent installs without error 736s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 736s ok 283 - extension unaccent removes without error 736s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 736s ok 285 - extension uuid-ossp installs without error 736s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 736s ok 287 - extension uuid-ossp removes without error 736s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 736s ok 289 - extension xml2 installs without error 736s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 736s ok 291 - extension xml2 removes without error 737s ok 292 - pg_dropcluster 17 main 737s # Cleanup 737s ok 293 - Cleanup: No clusters left behind 737s ok 294 - No postgres processes left behind 737s ok 295 - No files in /etc/postgresql left behind 737s ok 296 - No files in /var/lib/postgresql left behind 737s ok 297 - No files in /var/run/postgresql left behind 737s ok 298 - No files in /var/log/postgresql left behind 737s ok 299 - PostgreSQL TCP ports are closed 737s ok 300 - Next free port is 5432 737s 1..300 737s ### End test 170_extensions.t ### 737s 737s ### PostgreSQL test 180_ecpg.t ### 737s 1..14 737s ok 1 - ecpg test.pgc 737s ok 2 - ecpg processing 738s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 738s ok 4 - compiling ecpg output 745s ok 5 - pg_virtualenv /tmp/tmp.kOryPtMZSm/test 745s ok 6 - test program runs and gives correct output 745s # Cleanup 745s ok 7 - Cleanup: No clusters left behind 745s ok 8 - No postgres processes left behind 745s ok 9 - No files in /etc/postgresql left behind 745s ok 10 - No files in /var/lib/postgresql left behind 745s ok 11 - No files in /var/run/postgresql left behind 745s ok 12 - No files in /var/log/postgresql left behind 745s ok 13 - PostgreSQL TCP ports are closed 745s ok 14 - Next free port is 5432 745s ### End test 180_ecpg.t ### 745s 745s ### PostgreSQL test 190_pg_buildext.t ### 745s ok 1 - make clean 745s ok 2 - make tar 745s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 745s # testing 'dh --with pgxs' 749s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 749s ok 5 - postgresql-17-foo_123-1_armhf.deb was built 756s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 756s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 757s ok 8 - dpkg -i postgresql-17-foo_123-1_armhf.deb 764s ok 9 - cd foo-123 && pg_buildext installcheck 764s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 772s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 772s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 779s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 779s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 779s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 779s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 779s ok 17 - dpkg -r postgresql-17-foo 779s # testing 'dh --with pgxs_loop' 779s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 782s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 782s ok 20 - postgresql-17-foo_123-1_armhf.deb was built 782s ok 21 - make clean 782s # testing pg_buildext updatecontrol 783s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 783s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 783s 1..23 783s ### End test 190_pg_buildext.t ### 783s 783s ### PostgreSQL test 200_maintscripts.t ### 783s 1..15 783s # We are running systemd 786s ok 1 - pg_createcluster 17 main --start 786s ok 2 - postmaster PID is 21090 787s ok 3 - apt-get update -q 787s # postgresql-common: 787s # Installed: 279 787s # Candidate: 279 787s # Version table: 787s # *** 279 500 787s # 500 http://ftpmaster.internal/ubuntu questing/main armhf Packages 787s # 100 /var/lib/dpkg/status 791s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 791s # postgresql-common: 791s # Installed: 279 791s # Candidate: 279 791s # Version table: 791s # *** 279 500 791s # 500 http://ftpmaster.internal/ubuntu questing/main armhf Packages 791s # 100 /var/lib/dpkg/status 791s ok 5 - postmaster PID is 21090 791s ok 6 - postmaster was not restarted 793s ok 7 - pg_dropcluster 17 main --stop 793s # Cleanup 793s ok 8 - Cleanup: No clusters left behind 793s ok 9 - No postgres processes left behind 793s ok 10 - No files in /etc/postgresql left behind 793s ok 11 - No files in /var/lib/postgresql left behind 793s ok 12 - No files in /var/run/postgresql left behind 793s ok 13 - No files in /var/log/postgresql left behind 793s ok 14 - PostgreSQL TCP ports are closed 793s ok 15 - Next free port is 5432 793s ### End test 200_maintscripts.t ### 793s 793s autopkgtest [01:32:10]: test run-testsuite: -----------------------] 798s run-testsuite PASS 798s autopkgtest [01:32:15]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 801s autopkgtest [01:32:18]: @@@@@@@@@@@@@@@@@@@@ summary 801s default-psql PASS 801s run-testsuite PASS