0s autopkgtest [13:50:17]: starting date and time: 2025-02-21 13:50:17+0000 0s autopkgtest [13:50:17]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:50:17]: host juju-7f2275-prod-proposed-migration-environment-9; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.5gu777yw/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,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com\n" >> /etc/environment' --apt-pocket=proposed=src:build-essential --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=build-essential/12.12 -- lxd -r lxd-armhf-10.145.243.201 lxd-armhf-10.145.243.201:autopkgtest/ubuntu/plucky/armhf 23s autopkgtest [13:50:40]: testbed dpkg architecture: armhf 26s autopkgtest [13:50:43]: testbed apt version: 2.9.30ubuntu1 31s autopkgtest [13:50:48]: @@@@@@@@@@@@@@@@@@@@ test bed setup 33s autopkgtest [13:50:50]: testbed release detected to be: None 43s autopkgtest [13:51:00]: updating testbed package index (apt update) 46s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 46s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 47s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 47s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 47s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.8 kB] 47s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 47s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [90.3 kB] 47s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [719 kB] 47s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf Packages [135 kB] 47s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted armhf Packages [760 B] 47s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe armhf Packages [622 kB] 47s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse armhf Packages [2640 B] 48s Fetched 1698 kB in 1s (1179 kB/s) 49s Reading package lists... 56s autopkgtest [13:51:13]: upgrading testbed (apt dist-upgrade and autopurge) 58s Reading package lists... 58s Building dependency tree... 58s Reading state information... 59s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 59s Starting 2 pkgProblemResolver with broken count: 0 59s Done 60s Entering ResolveByKeep 60s 61s Calculating upgrade... 61s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 63s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s Starting pkgProblemResolver with broken count: 0 64s Starting 2 pkgProblemResolver with broken count: 0 64s Done 65s Solving dependencies... 65s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 68s autopkgtest [13:51:25]: rebooting testbed after setup commands that affected boot 112s autopkgtest [13:52:09]: testbed running kernel: Linux 6.8.0-52-generic #53~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Jan 15 18:10:51 UTC 2 140s autopkgtest [13:52:37]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 185s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 273 (dsc) [2385 B] 185s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 273 (tar) [216 kB] 185s gpgv: Signature made Fri Feb 14 14:16:57 2025 UTC 185s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 185s gpgv: Can't check signature: No public key 185s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_273.dsc: no acceptable signature found 185s autopkgtest [13:53:22]: testing package postgresql-common version 273 188s autopkgtest [13:53:25]: build not needed 191s autopkgtest [13:53:28]: test default-psql: preparing testbed 193s Reading package lists... 193s Building dependency tree... 193s Reading state information... 194s Starting pkgProblemResolver with broken count: 0 194s Starting 2 pkgProblemResolver with broken count: 0 194s Done 195s The following NEW packages will be installed: 195s libio-pty-perl libipc-run-perl libjson-perl libllvm19 libpq5 libxslt1.1 195s postgresql postgresql-17 postgresql-client-17 postgresql-client-common 195s postgresql-common postgresql-common-dev ssl-cert 195s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 195s Need to get 44.5 MB of archives. 195s After this operation, 169 MB of additional disk space will be used. 195s Get:1 http://ftpmaster.internal/ubuntu plucky/main armhf libjson-perl all 4.10000-1 [81.9 kB] 195s Get:2 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-common all 273 [47.5 kB] 195s Get:3 http://ftpmaster.internal/ubuntu plucky/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 195s Get:4 http://ftpmaster.internal/ubuntu plucky/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 195s Get:5 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common-dev all 273 [72.9 kB] 195s Get:6 http://ftpmaster.internal/ubuntu plucky/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 195s Get:7 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common all 273 [101 kB] 195s Get:8 http://ftpmaster.internal/ubuntu plucky/main armhf libllvm19 armhf 1:19.1.7-1ubuntu1 [27.8 MB] 198s Get:9 http://ftpmaster.internal/ubuntu plucky/main armhf libpq5 armhf 17.3-3 [125 kB] 198s Get:10 http://ftpmaster.internal/ubuntu plucky/main armhf libxslt1.1 armhf 1.1.39-0exp1ubuntu2 [152 kB] 198s Get:11 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-17 armhf 17.3-3 [1285 kB] 199s Get:12 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-17 armhf 17.3-3 [14.7 MB] 199s Get:13 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql all 17+273 [14.3 kB] 200s Preconfiguring packages ... 200s /var/cache/debconf/tmp.ci/postgresql.config.mi9vu8: 12: pg_lsclusters: not found 200s Fetched 44.5 MB in 4s (9976 kB/s) 200s Selecting previously unselected package libjson-perl. 200s (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 ... 60726 files and directories currently installed.) 200s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 200s Unpacking libjson-perl (4.10000-1) ... 200s Selecting previously unselected package postgresql-client-common. 200s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 200s Unpacking postgresql-client-common (273) ... 200s Selecting previously unselected package libio-pty-perl. 200s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 200s Unpacking libio-pty-perl (1:1.20-1build3) ... 200s Selecting previously unselected package libipc-run-perl. 200s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 200s Unpacking libipc-run-perl (20231003.0-2) ... 200s Selecting previously unselected package postgresql-common-dev. 200s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 200s Unpacking postgresql-common-dev (273) ... 200s Selecting previously unselected package ssl-cert. 200s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 200s Unpacking ssl-cert (1.1.3ubuntu1) ... 200s Selecting previously unselected package postgresql-common. 200s Preparing to unpack .../06-postgresql-common_273_all.deb ... 200s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 200s Unpacking postgresql-common (273) ... 200s Selecting previously unselected package libllvm19:armhf. 200s Preparing to unpack .../07-libllvm19_1%3a19.1.7-1ubuntu1_armhf.deb ... 200s Unpacking libllvm19:armhf (1:19.1.7-1ubuntu1) ... 201s Selecting previously unselected package libpq5:armhf. 201s Preparing to unpack .../08-libpq5_17.3-3_armhf.deb ... 201s Unpacking libpq5:armhf (17.3-3) ... 201s Selecting previously unselected package libxslt1.1:armhf. 201s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_armhf.deb ... 201s Unpacking libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 201s Selecting previously unselected package postgresql-client-17. 201s Preparing to unpack .../10-postgresql-client-17_17.3-3_armhf.deb ... 201s Unpacking postgresql-client-17 (17.3-3) ... 201s Selecting previously unselected package postgresql-17. 201s Preparing to unpack .../11-postgresql-17_17.3-3_armhf.deb ... 201s Unpacking postgresql-17 (17.3-3) ... 202s Selecting previously unselected package postgresql. 202s Preparing to unpack .../12-postgresql_17+273_all.deb ... 202s Unpacking postgresql (17+273) ... 202s Setting up postgresql-client-common (273) ... 202s Setting up libllvm19:armhf (1:19.1.7-1ubuntu1) ... 202s Setting up libio-pty-perl (1:1.20-1build3) ... 202s Setting up libpq5:armhf (17.3-3) ... 202s Setting up ssl-cert (1.1.3ubuntu1) ... 203s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 204s Setting up libipc-run-perl (20231003.0-2) ... 204s Setting up libjson-perl (4.10000-1) ... 204s Setting up libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 204s Setting up postgresql-common-dev (273) ... 204s Setting up postgresql-client-17 (17.3-3) ... 205s 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 205s Setting up postgresql-common (273) ... 205s Creating config file /etc/postgresql-common/createcluster.conf with new version 205s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 205s Removing obsolete dictionary files: 206s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 206s Setting up postgresql-17 (17.3-3) ... 207s Creating new PostgreSQL cluster 17/main ... 207s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 207s The files belonging to this database system will be owned by user "postgres". 207s This user must also own the server process. 207s 207s The database cluster will be initialized with locale "C.UTF-8". 207s The default database encoding has accordingly been set to "UTF8". 207s The default text search configuration will be set to "english". 207s 207s Data page checksums are disabled. 207s 207s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 207s creating subdirectories ... ok 207s selecting dynamic shared memory implementation ... posix 208s selecting default "max_connections" ... 100 208s selecting default "shared_buffers" ... 128MB 208s selecting default time zone ... Etc/UTC 208s creating configuration files ... ok 208s running bootstrap script ... ok 208s performing post-bootstrap initialization ... ok 208s syncing data to disk ... ok 211s Setting up postgresql (17+273) ... 211s Processing triggers for man-db (2.13.0-1) ... 213s Processing triggers for libc-bin (2.40-4ubuntu1) ... 223s autopkgtest [13:54:00]: test default-psql: [----------------------- 226s autopkgtest [13:54:03]: test default-psql: -----------------------] 230s autopkgtest [13:54:07]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 230s default-psql PASS 235s autopkgtest [13:54:12]: test run-testsuite: preparing testbed 263s autopkgtest [13:54:40]: testbed dpkg architecture: armhf 265s autopkgtest [13:54:42]: testbed apt version: 2.9.30ubuntu1 270s autopkgtest [13:54:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 272s autopkgtest [13:54:49]: testbed release detected to be: plucky 281s autopkgtest [13:54:58]: updating testbed package index (apt update) 284s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 284s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 284s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 284s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 284s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [90.3 kB] 284s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 284s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [719 kB] 285s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.8 kB] 285s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf Packages [135 kB] 285s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted armhf Packages [760 B] 285s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe armhf Packages [622 kB] 285s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse armhf Packages [2640 B] 285s Fetched 1698 kB in 1s (1733 kB/s) 286s Reading package lists... 293s autopkgtest [13:55:10]: upgrading testbed (apt dist-upgrade and autopurge) 295s Reading package lists... 295s Building dependency tree... 295s Reading state information... 296s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 296s Starting 2 pkgProblemResolver with broken count: 0 296s Done 297s Entering ResolveByKeep 297s 297s Calculating upgrade... 298s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 300s Reading package lists... 300s Building dependency tree... 300s Reading state information... 300s Starting pkgProblemResolver with broken count: 0 301s Starting 2 pkgProblemResolver with broken count: 0 301s Done 302s Solving dependencies... 303s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 305s autopkgtest [13:55:22]: rebooting testbed after setup commands that affected boot 383s Reading package lists... 383s Building dependency tree... 383s Reading state information... 384s Starting pkgProblemResolver with broken count: 0 384s Starting 2 pkgProblemResolver with broken count: 0 384s Done 385s The following NEW packages will be installed: 385s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 385s cpp-14 cpp-14-arm-linux-gnueabihf cpp-arm-linux-gnueabihf debhelper 385s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 385s emacsen-common fakeroot g++ g++-14 g++-14-arm-linux-gnueabihf 385s g++-arm-linux-gnueabihf gcc gcc-14 gcc-14-arm-linux-gnueabihf 385s gcc-arm-linux-gnueabihf gettext hunspell-en-us intltool-debian 385s libarchive-zip-perl libasan8 libc-dev-bin libc6-dev libcc1-0 385s libclang-common-19-dev libclang-cpp19 libclang1-19 libcrypt-dev 385s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 385s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev libgomp1 385s libio-pty-perl libipc-run-perl libisl23 libjson-perl libllvm19 libmpc3 385s libncurses-dev libobjc-14-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 385s libpython3.13 libssl-dev libstdc++-14-dev libtcl8.6 libtool libubsan1 385s libxml2-dev libxslt1.1 linux-libc-dev llvm-19 llvm-19-dev 385s llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all m4 po-debconf 385s postgresql-17 postgresql-all postgresql-client-17 postgresql-client-common 385s postgresql-common postgresql-common-dev postgresql-doc postgresql-doc-17 385s postgresql-plperl-17 postgresql-plpython3-17 postgresql-pltcl-17 385s postgresql-server-dev-17 postgresql-server-dev-all rpcsvc-proto ssl-cert 385s 0 upgraded, 93 newly installed, 0 to remove and 0 not upgraded. 385s Need to get 211 MB of archives. 385s After this operation, 1107 MB of additional disk space will be used. 385s Get:1 http://ftpmaster.internal/ubuntu plucky/main armhf libjson-perl all 4.10000-1 [81.9 kB] 385s Get:2 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-common all 273 [47.5 kB] 385s Get:3 http://ftpmaster.internal/ubuntu plucky/main armhf libio-pty-perl armhf 1:1.20-1build3 [31.0 kB] 385s Get:4 http://ftpmaster.internal/ubuntu plucky/main armhf libipc-run-perl all 20231003.0-2 [91.5 kB] 385s Get:5 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common-dev all 273 [72.9 kB] 385s Get:6 http://ftpmaster.internal/ubuntu plucky/main armhf ssl-cert all 1.1.3ubuntu1 [18.7 kB] 385s Get:7 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-common all 273 [101 kB] 385s Get:8 http://ftpmaster.internal/ubuntu plucky/main armhf m4 armhf 1.4.19-5 [238 kB] 385s Get:9 http://ftpmaster.internal/ubuntu plucky/main armhf autoconf all 2.72-3ubuntu1 [383 kB] 385s Get:10 http://ftpmaster.internal/ubuntu plucky/main armhf autotools-dev all 20220109.1 [44.9 kB] 385s Get:11 http://ftpmaster.internal/ubuntu plucky/main armhf automake all 1:1.17-3ubuntu1 [572 kB] 385s Get:12 http://ftpmaster.internal/ubuntu plucky/main armhf autopoint all 0.23.1-1 [619 kB] 385s Get:13 http://ftpmaster.internal/ubuntu plucky/main armhf libc-dev-bin armhf 2.40-4ubuntu1 [19.2 kB] 385s Get:14 http://ftpmaster.internal/ubuntu plucky/main armhf linux-libc-dev armhf 6.12.0-15.15 [1697 kB] 385s Get:15 http://ftpmaster.internal/ubuntu plucky/main armhf libcrypt-dev armhf 1:4.4.38-1 [120 kB] 385s Get:16 http://ftpmaster.internal/ubuntu plucky/main armhf rpcsvc-proto armhf 1.4.2-0ubuntu7 [62.2 kB] 385s Get:17 http://ftpmaster.internal/ubuntu plucky/main armhf libc6-dev armhf 2.40-4ubuntu1 [1358 kB] 385s Get:18 http://ftpmaster.internal/ubuntu plucky/main armhf libisl23 armhf 0.27-1 [546 kB] 385s Get:19 http://ftpmaster.internal/ubuntu plucky/main armhf libmpc3 armhf 1.3.1-1build2 [47.1 kB] 385s Get:20 http://ftpmaster.internal/ubuntu plucky/main armhf cpp-14-arm-linux-gnueabihf armhf 14.2.0-17ubuntu3 [9220 kB] 386s Get:21 http://ftpmaster.internal/ubuntu plucky/main armhf cpp-14 armhf 14.2.0-17ubuntu3 [1030 B] 386s Get:22 http://ftpmaster.internal/ubuntu plucky/main armhf cpp-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [5578 B] 386s Get:23 http://ftpmaster.internal/ubuntu plucky/main armhf cpp armhf 4:14.2.0-1ubuntu1 [22.4 kB] 386s Get:24 http://ftpmaster.internal/ubuntu plucky/main armhf libcc1-0 armhf 15-20250213-1ubuntu1 [38.9 kB] 386s Get:25 http://ftpmaster.internal/ubuntu plucky/main armhf libgomp1 armhf 15-20250213-1ubuntu1 [128 kB] 386s Get:26 http://ftpmaster.internal/ubuntu plucky/main armhf libasan8 armhf 15-20250213-1ubuntu1 [2956 kB] 386s Get:27 http://ftpmaster.internal/ubuntu plucky/main armhf libubsan1 armhf 15-20250213-1ubuntu1 [1190 kB] 386s Get:28 http://ftpmaster.internal/ubuntu plucky/main armhf libgcc-14-dev armhf 14.2.0-17ubuntu3 [897 kB] 386s Get:29 http://ftpmaster.internal/ubuntu plucky/main armhf gcc-14-arm-linux-gnueabihf armhf 14.2.0-17ubuntu3 [18.0 MB] 387s Get:30 http://ftpmaster.internal/ubuntu plucky/main armhf gcc-14 armhf 14.2.0-17ubuntu3 [506 kB] 387s Get:31 http://ftpmaster.internal/ubuntu plucky/main armhf gcc-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [1218 B] 387s Get:32 http://ftpmaster.internal/ubuntu plucky/main armhf gcc armhf 4:14.2.0-1ubuntu1 [5004 B] 387s Get:33 http://ftpmaster.internal/ubuntu plucky/main armhf libstdc++-14-dev armhf 14.2.0-17ubuntu3 [2573 kB] 387s Get:34 http://ftpmaster.internal/ubuntu plucky/main armhf g++-14-arm-linux-gnueabihf armhf 14.2.0-17ubuntu3 [10.5 MB] 387s Get:35 http://ftpmaster.internal/ubuntu plucky/main armhf g++-14 armhf 14.2.0-17ubuntu3 [21.8 kB] 387s Get:36 http://ftpmaster.internal/ubuntu plucky/main armhf g++-arm-linux-gnueabihf armhf 4:14.2.0-1ubuntu1 [966 B] 387s Get:37 http://ftpmaster.internal/ubuntu plucky/main armhf g++ armhf 4:14.2.0-1ubuntu1 [1084 B] 387s Get:38 http://ftpmaster.internal/ubuntu plucky-proposed/main armhf build-essential armhf 12.12 [4610 B] 387s Get:39 http://ftpmaster.internal/ubuntu plucky/main armhf libllvm19 armhf 1:19.1.7-1ubuntu1 [27.8 MB] 387s Get:40 http://ftpmaster.internal/ubuntu plucky/universe armhf libclang-cpp19 armhf 1:19.1.7-1ubuntu1 [13.4 MB] 388s Get:41 http://ftpmaster.internal/ubuntu plucky/main armhf libgc1 armhf 1:8.2.8-1 [81.2 kB] 388s Get:42 http://ftpmaster.internal/ubuntu plucky/universe armhf libobjc4 armhf 15-20250213-1ubuntu1 [38.7 kB] 388s Get:43 http://ftpmaster.internal/ubuntu plucky/universe armhf libobjc-14-dev armhf 14.2.0-17ubuntu3 [185 kB] 388s Get:44 http://ftpmaster.internal/ubuntu plucky/universe armhf libclang-common-19-dev armhf 1:19.1.7-1ubuntu1 [742 kB] 388s Get:45 http://ftpmaster.internal/ubuntu plucky/universe armhf llvm-19-linker-tools armhf 1:19.1.7-1ubuntu1 [1168 kB] 388s Get:46 http://ftpmaster.internal/ubuntu plucky/main armhf libclang1-19 armhf 1:19.1.7-1ubuntu1 [7705 kB] 388s Get:47 http://ftpmaster.internal/ubuntu plucky/universe armhf clang-19 armhf 1:19.1.7-1ubuntu1 [75.4 kB] 388s Get:48 http://ftpmaster.internal/ubuntu plucky/main armhf libdebhelper-perl all 13.24.1ubuntu2 [95.4 kB] 388s Get:49 http://ftpmaster.internal/ubuntu plucky/main armhf libtool all 2.5.4-3build1 [168 kB] 388s Get:50 http://ftpmaster.internal/ubuntu plucky/main armhf dh-autoreconf all 20 [16.1 kB] 388s Get:51 http://ftpmaster.internal/ubuntu plucky/main armhf libarchive-zip-perl all 1.68-1 [90.2 kB] 388s Get:52 http://ftpmaster.internal/ubuntu plucky/main armhf libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 388s Get:53 http://ftpmaster.internal/ubuntu plucky/main armhf dh-strip-nondeterminism all 1.14.1-2 [5064 B] 388s Get:54 http://ftpmaster.internal/ubuntu plucky/main armhf debugedit armhf 1:5.1-2 [46.7 kB] 388s Get:55 http://ftpmaster.internal/ubuntu plucky/main armhf dwz armhf 0.15-1build6 [116 kB] 388s Get:56 http://ftpmaster.internal/ubuntu plucky/main armhf gettext armhf 0.23.1-1 [1053 kB] 388s Get:57 http://ftpmaster.internal/ubuntu plucky/main armhf intltool-debian all 0.35.0+20060710.6 [23.2 kB] 388s Get:58 http://ftpmaster.internal/ubuntu plucky/main armhf po-debconf all 1.0.21+nmu1 [233 kB] 388s Get:59 http://ftpmaster.internal/ubuntu plucky/main armhf debhelper all 13.24.1ubuntu2 [895 kB] 388s Get:60 http://ftpmaster.internal/ubuntu plucky/main armhf emacsen-common all 3.0.5 [12.1 kB] 388s Get:61 http://ftpmaster.internal/ubuntu plucky/main armhf dictionaries-common all 1.30.5 [177 kB] 388s Get:62 http://ftpmaster.internal/ubuntu plucky/main armhf libfakeroot armhf 1.37-1 [29.6 kB] 388s Get:63 http://ftpmaster.internal/ubuntu plucky/main armhf fakeroot armhf 1.37-1 [69.3 kB] 388s Get:64 http://ftpmaster.internal/ubuntu plucky/main armhf hunspell-en-us all 1:2020.12.07-3 [586 kB] 388s Get:65 http://ftpmaster.internal/ubuntu plucky/main armhf libpgtypes3 armhf 17.3-3 [41.2 kB] 388s Get:66 http://ftpmaster.internal/ubuntu plucky/main armhf libpq5 armhf 17.3-3 [125 kB] 388s Get:67 http://ftpmaster.internal/ubuntu plucky/main armhf libecpg6 armhf 17.3-3 [38.6 kB] 388s Get:68 http://ftpmaster.internal/ubuntu plucky/main armhf libecpg-compat3 armhf 17.3-3 [10.9 kB] 388s Get:69 http://ftpmaster.internal/ubuntu plucky/main armhf libssl-dev armhf 3.4.1-1ubuntu1 [2381 kB] 388s Get:70 http://ftpmaster.internal/ubuntu plucky/main armhf libpq-dev armhf 17.3-3 [144 kB] 388s Get:71 http://ftpmaster.internal/ubuntu plucky/main armhf libecpg-dev armhf 17.3-3 [260 kB] 388s Get:72 http://ftpmaster.internal/ubuntu plucky/main armhf libncurses-dev armhf 6.5+20250125-2 [498 kB] 388s Get:73 http://ftpmaster.internal/ubuntu plucky/main armhf libpython3.13 armhf 3.13.2-1 [2075 kB] 388s Get:74 http://ftpmaster.internal/ubuntu plucky/main armhf libtcl8.6 armhf 8.6.16+dfsg-1 [909 kB] 388s Get:75 http://ftpmaster.internal/ubuntu plucky/main armhf libxml2-dev armhf 2.12.7+dfsg+really2.9.14-0.2ubuntu3 [738 kB] 388s Get:76 http://ftpmaster.internal/ubuntu plucky/main armhf libxslt1.1 armhf 1.1.39-0exp1ubuntu2 [152 kB] 388s Get:77 http://ftpmaster.internal/ubuntu plucky/universe armhf llvm-19-runtime armhf 1:19.1.7-1ubuntu1 [530 kB] 388s Get:78 http://ftpmaster.internal/ubuntu plucky/universe armhf libpfm4 armhf 4.13.0+git83-g91970fe-1 [62.8 kB] 388s Get:79 http://ftpmaster.internal/ubuntu plucky/universe armhf llvm-19 armhf 1:19.1.7-1ubuntu1 [17.3 MB] 389s Get:80 http://ftpmaster.internal/ubuntu plucky/main armhf libffi-dev armhf 3.4.7-1 [57.2 kB] 389s Get:81 http://ftpmaster.internal/ubuntu plucky/universe armhf llvm-19-tools armhf 1:19.1.7-1ubuntu1 [512 kB] 389s Get:82 http://ftpmaster.internal/ubuntu plucky/universe armhf llvm-19-dev armhf 1:19.1.7-1ubuntu1 [47.2 MB] 390s Get:83 http://ftpmaster.internal/ubuntu plucky/universe armhf locales-all armhf 2.40-4ubuntu1 [11.1 MB] 390s Get:84 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-client-17 armhf 17.3-3 [1285 kB] 390s Get:85 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-17 armhf 17.3-3 [14.7 MB] 391s Get:86 http://ftpmaster.internal/ubuntu plucky/universe armhf postgresql-server-dev-17 armhf 17.3-3 [1368 kB] 391s Get:87 http://ftpmaster.internal/ubuntu plucky/universe armhf postgresql-server-dev-all all 273 [1632 B] 391s Get:88 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-plperl-17 armhf 17.3-3 [62.4 kB] 391s Get:89 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-plpython3-17 armhf 17.3-3 [69.9 kB] 391s Get:90 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-pltcl-17 armhf 17.3-3 [27.7 kB] 391s Get:91 http://ftpmaster.internal/ubuntu plucky/universe armhf postgresql-all all 273 [1708 B] 391s Get:92 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-doc-17 all 17.3-3 [2131 kB] 391s Get:93 http://ftpmaster.internal/ubuntu plucky/main armhf postgresql-doc all 17+273 [13.2 kB] 392s Preconfiguring packages ... 392s Fetched 211 MB in 6s (33.7 MB/s) 392s Selecting previously unselected package libjson-perl. 392s (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 ... 60726 files and directories currently installed.) 392s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 392s Unpacking libjson-perl (4.10000-1) ... 392s Selecting previously unselected package postgresql-client-common. 392s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 392s Unpacking postgresql-client-common (273) ... 392s Selecting previously unselected package libio-pty-perl. 392s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_armhf.deb ... 392s Unpacking libio-pty-perl (1:1.20-1build3) ... 392s Selecting previously unselected package libipc-run-perl. 392s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 392s Unpacking libipc-run-perl (20231003.0-2) ... 392s Selecting previously unselected package postgresql-common-dev. 392s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 392s Unpacking postgresql-common-dev (273) ... 392s Selecting previously unselected package ssl-cert. 392s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 392s Unpacking ssl-cert (1.1.3ubuntu1) ... 392s Selecting previously unselected package postgresql-common. 392s Preparing to unpack .../06-postgresql-common_273_all.deb ... 392s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 392s Unpacking postgresql-common (273) ... 393s Selecting previously unselected package m4. 393s Preparing to unpack .../07-m4_1.4.19-5_armhf.deb ... 393s Unpacking m4 (1.4.19-5) ... 393s Selecting previously unselected package autoconf. 393s Preparing to unpack .../08-autoconf_2.72-3ubuntu1_all.deb ... 393s Unpacking autoconf (2.72-3ubuntu1) ... 393s Selecting previously unselected package autotools-dev. 393s Preparing to unpack .../09-autotools-dev_20220109.1_all.deb ... 393s Unpacking autotools-dev (20220109.1) ... 393s Selecting previously unselected package automake. 393s Preparing to unpack .../10-automake_1%3a1.17-3ubuntu1_all.deb ... 393s Unpacking automake (1:1.17-3ubuntu1) ... 393s Selecting previously unselected package autopoint. 393s Preparing to unpack .../11-autopoint_0.23.1-1_all.deb ... 393s Unpacking autopoint (0.23.1-1) ... 393s Selecting previously unselected package libc-dev-bin. 393s Preparing to unpack .../12-libc-dev-bin_2.40-4ubuntu1_armhf.deb ... 393s Unpacking libc-dev-bin (2.40-4ubuntu1) ... 393s Selecting previously unselected package linux-libc-dev:armhf. 393s Preparing to unpack .../13-linux-libc-dev_6.12.0-15.15_armhf.deb ... 393s Unpacking linux-libc-dev:armhf (6.12.0-15.15) ... 393s Selecting previously unselected package libcrypt-dev:armhf. 393s Preparing to unpack .../14-libcrypt-dev_1%3a4.4.38-1_armhf.deb ... 393s Unpacking libcrypt-dev:armhf (1:4.4.38-1) ... 393s Selecting previously unselected package rpcsvc-proto. 393s Preparing to unpack .../15-rpcsvc-proto_1.4.2-0ubuntu7_armhf.deb ... 393s Unpacking rpcsvc-proto (1.4.2-0ubuntu7) ... 393s Selecting previously unselected package libc6-dev:armhf. 393s Preparing to unpack .../16-libc6-dev_2.40-4ubuntu1_armhf.deb ... 393s Unpacking libc6-dev:armhf (2.40-4ubuntu1) ... 393s Selecting previously unselected package libisl23:armhf. 393s Preparing to unpack .../17-libisl23_0.27-1_armhf.deb ... 393s Unpacking libisl23:armhf (0.27-1) ... 393s Selecting previously unselected package libmpc3:armhf. 393s Preparing to unpack .../18-libmpc3_1.3.1-1build2_armhf.deb ... 393s Unpacking libmpc3:armhf (1.3.1-1build2) ... 393s Selecting previously unselected package cpp-14-arm-linux-gnueabihf. 393s Preparing to unpack .../19-cpp-14-arm-linux-gnueabihf_14.2.0-17ubuntu3_armhf.deb ... 393s Unpacking cpp-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 393s Selecting previously unselected package cpp-14. 394s Preparing to unpack .../20-cpp-14_14.2.0-17ubuntu3_armhf.deb ... 394s Unpacking cpp-14 (14.2.0-17ubuntu3) ... 394s Selecting previously unselected package cpp-arm-linux-gnueabihf. 394s Preparing to unpack .../21-cpp-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 394s Unpacking cpp-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 394s Selecting previously unselected package cpp. 394s Preparing to unpack .../22-cpp_4%3a14.2.0-1ubuntu1_armhf.deb ... 394s Unpacking cpp (4:14.2.0-1ubuntu1) ... 394s Selecting previously unselected package libcc1-0:armhf. 394s Preparing to unpack .../23-libcc1-0_15-20250213-1ubuntu1_armhf.deb ... 394s Unpacking libcc1-0:armhf (15-20250213-1ubuntu1) ... 394s Selecting previously unselected package libgomp1:armhf. 394s Preparing to unpack .../24-libgomp1_15-20250213-1ubuntu1_armhf.deb ... 394s Unpacking libgomp1:armhf (15-20250213-1ubuntu1) ... 394s Selecting previously unselected package libasan8:armhf. 394s Preparing to unpack .../25-libasan8_15-20250213-1ubuntu1_armhf.deb ... 394s Unpacking libasan8:armhf (15-20250213-1ubuntu1) ... 394s Selecting previously unselected package libubsan1:armhf. 394s Preparing to unpack .../26-libubsan1_15-20250213-1ubuntu1_armhf.deb ... 394s Unpacking libubsan1:armhf (15-20250213-1ubuntu1) ... 394s Selecting previously unselected package libgcc-14-dev:armhf. 394s Preparing to unpack .../27-libgcc-14-dev_14.2.0-17ubuntu3_armhf.deb ... 394s Unpacking libgcc-14-dev:armhf (14.2.0-17ubuntu3) ... 394s Selecting previously unselected package gcc-14-arm-linux-gnueabihf. 394s Preparing to unpack .../28-gcc-14-arm-linux-gnueabihf_14.2.0-17ubuntu3_armhf.deb ... 394s Unpacking gcc-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 394s Selecting previously unselected package gcc-14. 394s Preparing to unpack .../29-gcc-14_14.2.0-17ubuntu3_armhf.deb ... 394s Unpacking gcc-14 (14.2.0-17ubuntu3) ... 394s Selecting previously unselected package gcc-arm-linux-gnueabihf. 394s Preparing to unpack .../30-gcc-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 394s Unpacking gcc-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 395s Selecting previously unselected package gcc. 395s Preparing to unpack .../31-gcc_4%3a14.2.0-1ubuntu1_armhf.deb ... 395s Unpacking gcc (4:14.2.0-1ubuntu1) ... 395s Selecting previously unselected package libstdc++-14-dev:armhf. 395s Preparing to unpack .../32-libstdc++-14-dev_14.2.0-17ubuntu3_armhf.deb ... 395s Unpacking libstdc++-14-dev:armhf (14.2.0-17ubuntu3) ... 395s Selecting previously unselected package g++-14-arm-linux-gnueabihf. 395s Preparing to unpack .../33-g++-14-arm-linux-gnueabihf_14.2.0-17ubuntu3_armhf.deb ... 395s Unpacking g++-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 395s Selecting previously unselected package g++-14. 395s Preparing to unpack .../34-g++-14_14.2.0-17ubuntu3_armhf.deb ... 395s Unpacking g++-14 (14.2.0-17ubuntu3) ... 395s Selecting previously unselected package g++-arm-linux-gnueabihf. 395s Preparing to unpack .../35-g++-arm-linux-gnueabihf_4%3a14.2.0-1ubuntu1_armhf.deb ... 395s Unpacking g++-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 395s Selecting previously unselected package g++. 395s Preparing to unpack .../36-g++_4%3a14.2.0-1ubuntu1_armhf.deb ... 395s Unpacking g++ (4:14.2.0-1ubuntu1) ... 395s Selecting previously unselected package build-essential. 395s Preparing to unpack .../37-build-essential_12.12_armhf.deb ... 395s Unpacking build-essential (12.12) ... 395s Selecting previously unselected package libllvm19:armhf. 395s Preparing to unpack .../38-libllvm19_1%3a19.1.7-1ubuntu1_armhf.deb ... 395s Unpacking libllvm19:armhf (1:19.1.7-1ubuntu1) ... 396s Selecting previously unselected package libclang-cpp19. 396s Preparing to unpack .../39-libclang-cpp19_1%3a19.1.7-1ubuntu1_armhf.deb ... 396s Unpacking libclang-cpp19 (1:19.1.7-1ubuntu1) ... 397s Selecting previously unselected package libgc1:armhf. 397s Preparing to unpack .../40-libgc1_1%3a8.2.8-1_armhf.deb ... 397s Unpacking libgc1:armhf (1:8.2.8-1) ... 397s Selecting previously unselected package libobjc4:armhf. 397s Preparing to unpack .../41-libobjc4_15-20250213-1ubuntu1_armhf.deb ... 397s Unpacking libobjc4:armhf (15-20250213-1ubuntu1) ... 397s Selecting previously unselected package libobjc-14-dev:armhf. 397s Preparing to unpack .../42-libobjc-14-dev_14.2.0-17ubuntu3_armhf.deb ... 397s Unpacking libobjc-14-dev:armhf (14.2.0-17ubuntu3) ... 397s Selecting previously unselected package libclang-common-19-dev:armhf. 397s Preparing to unpack .../43-libclang-common-19-dev_1%3a19.1.7-1ubuntu1_armhf.deb ... 397s Unpacking libclang-common-19-dev:armhf (1:19.1.7-1ubuntu1) ... 397s Selecting previously unselected package llvm-19-linker-tools. 397s Preparing to unpack .../44-llvm-19-linker-tools_1%3a19.1.7-1ubuntu1_armhf.deb ... 397s Unpacking llvm-19-linker-tools (1:19.1.7-1ubuntu1) ... 397s Selecting previously unselected package libclang1-19. 397s Preparing to unpack .../45-libclang1-19_1%3a19.1.7-1ubuntu1_armhf.deb ... 397s Unpacking libclang1-19 (1:19.1.7-1ubuntu1) ... 397s Selecting previously unselected package clang-19. 397s Preparing to unpack .../46-clang-19_1%3a19.1.7-1ubuntu1_armhf.deb ... 397s Unpacking clang-19 (1:19.1.7-1ubuntu1) ... 397s Selecting previously unselected package libdebhelper-perl. 397s Preparing to unpack .../47-libdebhelper-perl_13.24.1ubuntu2_all.deb ... 397s Unpacking libdebhelper-perl (13.24.1ubuntu2) ... 397s Selecting previously unselected package libtool. 397s Preparing to unpack .../48-libtool_2.5.4-3build1_all.deb ... 397s Unpacking libtool (2.5.4-3build1) ... 397s Selecting previously unselected package dh-autoreconf. 397s Preparing to unpack .../49-dh-autoreconf_20_all.deb ... 397s Unpacking dh-autoreconf (20) ... 397s Selecting previously unselected package libarchive-zip-perl. 397s Preparing to unpack .../50-libarchive-zip-perl_1.68-1_all.deb ... 397s Unpacking libarchive-zip-perl (1.68-1) ... 397s Selecting previously unselected package libfile-stripnondeterminism-perl. 397s Preparing to unpack .../51-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 397s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 397s Selecting previously unselected package dh-strip-nondeterminism. 397s Preparing to unpack .../52-dh-strip-nondeterminism_1.14.1-2_all.deb ... 397s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 397s Selecting previously unselected package debugedit. 397s Preparing to unpack .../53-debugedit_1%3a5.1-2_armhf.deb ... 397s Unpacking debugedit (1:5.1-2) ... 397s Selecting previously unselected package dwz. 398s Preparing to unpack .../54-dwz_0.15-1build6_armhf.deb ... 398s Unpacking dwz (0.15-1build6) ... 398s Selecting previously unselected package gettext. 398s Preparing to unpack .../55-gettext_0.23.1-1_armhf.deb ... 398s Unpacking gettext (0.23.1-1) ... 398s Selecting previously unselected package intltool-debian. 398s Preparing to unpack .../56-intltool-debian_0.35.0+20060710.6_all.deb ... 398s Unpacking intltool-debian (0.35.0+20060710.6) ... 398s Selecting previously unselected package po-debconf. 398s Preparing to unpack .../57-po-debconf_1.0.21+nmu1_all.deb ... 398s Unpacking po-debconf (1.0.21+nmu1) ... 398s Selecting previously unselected package debhelper. 398s Preparing to unpack .../58-debhelper_13.24.1ubuntu2_all.deb ... 398s Unpacking debhelper (13.24.1ubuntu2) ... 398s Selecting previously unselected package emacsen-common. 398s Preparing to unpack .../59-emacsen-common_3.0.5_all.deb ... 398s Unpacking emacsen-common (3.0.5) ... 398s Selecting previously unselected package dictionaries-common. 398s Preparing to unpack .../60-dictionaries-common_1.30.5_all.deb ... 398s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 398s Unpacking dictionaries-common (1.30.5) ... 398s Selecting previously unselected package libfakeroot:armhf. 398s Preparing to unpack .../61-libfakeroot_1.37-1_armhf.deb ... 398s Unpacking libfakeroot:armhf (1.37-1) ... 398s Selecting previously unselected package fakeroot. 398s Preparing to unpack .../62-fakeroot_1.37-1_armhf.deb ... 398s Unpacking fakeroot (1.37-1) ... 398s Selecting previously unselected package hunspell-en-us. 398s Preparing to unpack .../63-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 398s Unpacking hunspell-en-us (1:2020.12.07-3) ... 398s Selecting previously unselected package libpgtypes3:armhf. 398s Preparing to unpack .../64-libpgtypes3_17.3-3_armhf.deb ... 398s Unpacking libpgtypes3:armhf (17.3-3) ... 398s Selecting previously unselected package libpq5:armhf. 398s Preparing to unpack .../65-libpq5_17.3-3_armhf.deb ... 398s Unpacking libpq5:armhf (17.3-3) ... 398s Selecting previously unselected package libecpg6:armhf. 398s Preparing to unpack .../66-libecpg6_17.3-3_armhf.deb ... 398s Unpacking libecpg6:armhf (17.3-3) ... 398s Selecting previously unselected package libecpg-compat3:armhf. 398s Preparing to unpack .../67-libecpg-compat3_17.3-3_armhf.deb ... 398s Unpacking libecpg-compat3:armhf (17.3-3) ... 398s Selecting previously unselected package libssl-dev:armhf. 399s Preparing to unpack .../68-libssl-dev_3.4.1-1ubuntu1_armhf.deb ... 399s Unpacking libssl-dev:armhf (3.4.1-1ubuntu1) ... 399s Selecting previously unselected package libpq-dev. 399s Preparing to unpack .../69-libpq-dev_17.3-3_armhf.deb ... 399s Unpacking libpq-dev (17.3-3) ... 399s Selecting previously unselected package libecpg-dev. 399s Preparing to unpack .../70-libecpg-dev_17.3-3_armhf.deb ... 399s Unpacking libecpg-dev (17.3-3) ... 399s Selecting previously unselected package libncurses-dev:armhf. 399s Preparing to unpack .../71-libncurses-dev_6.5+20250125-2_armhf.deb ... 399s Unpacking libncurses-dev:armhf (6.5+20250125-2) ... 399s Selecting previously unselected package libpython3.13:armhf. 399s Preparing to unpack .../72-libpython3.13_3.13.2-1_armhf.deb ... 399s Unpacking libpython3.13:armhf (3.13.2-1) ... 399s Selecting previously unselected package libtcl8.6:armhf. 399s Preparing to unpack .../73-libtcl8.6_8.6.16+dfsg-1_armhf.deb ... 399s Unpacking libtcl8.6:armhf (8.6.16+dfsg-1) ... 399s Selecting previously unselected package libxml2-dev:armhf. 399s Preparing to unpack .../74-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu3_armhf.deb ... 399s Unpacking libxml2-dev:armhf (2.12.7+dfsg+really2.9.14-0.2ubuntu3) ... 399s Selecting previously unselected package libxslt1.1:armhf. 399s Preparing to unpack .../75-libxslt1.1_1.1.39-0exp1ubuntu2_armhf.deb ... 399s Unpacking libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 399s Selecting previously unselected package llvm-19-runtime. 399s Preparing to unpack .../76-llvm-19-runtime_1%3a19.1.7-1ubuntu1_armhf.deb ... 399s Unpacking llvm-19-runtime (1:19.1.7-1ubuntu1) ... 399s Selecting previously unselected package libpfm4:armhf. 399s Preparing to unpack .../77-libpfm4_4.13.0+git83-g91970fe-1_armhf.deb ... 399s Unpacking libpfm4:armhf (4.13.0+git83-g91970fe-1) ... 399s Selecting previously unselected package llvm-19. 399s Preparing to unpack .../78-llvm-19_1%3a19.1.7-1ubuntu1_armhf.deb ... 399s Unpacking llvm-19 (1:19.1.7-1ubuntu1) ... 400s Selecting previously unselected package libffi-dev:armhf. 400s Preparing to unpack .../79-libffi-dev_3.4.7-1_armhf.deb ... 400s Unpacking libffi-dev:armhf (3.4.7-1) ... 400s Selecting previously unselected package llvm-19-tools. 400s Preparing to unpack .../80-llvm-19-tools_1%3a19.1.7-1ubuntu1_armhf.deb ... 400s Unpacking llvm-19-tools (1:19.1.7-1ubuntu1) ... 400s Selecting previously unselected package llvm-19-dev. 400s Preparing to unpack .../81-llvm-19-dev_1%3a19.1.7-1ubuntu1_armhf.deb ... 400s Unpacking llvm-19-dev (1:19.1.7-1ubuntu1) ... 403s Selecting previously unselected package locales-all. 403s Preparing to unpack .../82-locales-all_2.40-4ubuntu1_armhf.deb ... 403s Unpacking locales-all (2.40-4ubuntu1) ... 404s Selecting previously unselected package postgresql-client-17. 405s Preparing to unpack .../83-postgresql-client-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-client-17 (17.3-3) ... 405s Selecting previously unselected package postgresql-17. 405s Preparing to unpack .../84-postgresql-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-17 (17.3-3) ... 405s Selecting previously unselected package postgresql-server-dev-17. 405s Preparing to unpack .../85-postgresql-server-dev-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-server-dev-17 (17.3-3) ... 405s Selecting previously unselected package postgresql-server-dev-all. 405s Preparing to unpack .../86-postgresql-server-dev-all_273_all.deb ... 405s Unpacking postgresql-server-dev-all (273) ... 405s Selecting previously unselected package postgresql-plperl-17. 405s Preparing to unpack .../87-postgresql-plperl-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-plperl-17 (17.3-3) ... 405s Selecting previously unselected package postgresql-plpython3-17. 405s Preparing to unpack .../88-postgresql-plpython3-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-plpython3-17 (17.3-3) ... 405s Selecting previously unselected package postgresql-pltcl-17. 405s Preparing to unpack .../89-postgresql-pltcl-17_17.3-3_armhf.deb ... 405s Unpacking postgresql-pltcl-17 (17.3-3) ... 406s Selecting previously unselected package postgresql-all. 406s Preparing to unpack .../90-postgresql-all_273_all.deb ... 406s Unpacking postgresql-all (273) ... 406s Selecting previously unselected package postgresql-doc-17. 406s Preparing to unpack .../91-postgresql-doc-17_17.3-3_all.deb ... 406s Unpacking postgresql-doc-17 (17.3-3) ... 406s Selecting previously unselected package postgresql-doc. 406s Preparing to unpack .../92-postgresql-doc_17+273_all.deb ... 406s Unpacking postgresql-doc (17+273) ... 406s Setting up libpython3.13:armhf (3.13.2-1) ... 406s Setting up postgresql-client-common (273) ... 406s Setting up libpgtypes3:armhf (17.3-3) ... 406s Setting up libllvm19:armhf (1:19.1.7-1ubuntu1) ... 406s Setting up libclang1-19 (1:19.1.7-1ubuntu1) ... 406s Setting up libio-pty-perl (1:1.20-1build3) ... 406s Setting up libclang-common-19-dev:armhf (1:19.1.7-1ubuntu1) ... 406s Setting up libarchive-zip-perl (1.68-1) ... 406s Setting up libdebhelper-perl (13.24.1ubuntu2) ... 406s Setting up postgresql-doc-17 (17.3-3) ... 406s 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 406s Setting up libpq5:armhf (17.3-3) ... 406s Setting up linux-libc-dev:armhf (6.12.0-15.15) ... 406s Setting up m4 (1.4.19-5) ... 406s Setting up libgomp1:armhf (15-20250213-1ubuntu1) ... 406s Setting up libffi-dev:armhf (3.4.7-1) ... 406s Setting up locales-all (2.40-4ubuntu1) ... 406s Setting up libfakeroot:armhf (1.37-1) ... 406s Setting up fakeroot (1.37-1) ... 406s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 406s Setting up autotools-dev (20220109.1) ... 406s Setting up libxml2-dev:armhf (2.12.7+dfsg+really2.9.14-0.2ubuntu3) ... 406s Setting up libpfm4:armhf (4.13.0+git83-g91970fe-1) ... 406s Setting up rpcsvc-proto (1.4.2-0ubuntu7) ... 406s Setting up emacsen-common (3.0.5) ... 406s Setting up ssl-cert (1.1.3ubuntu1) ... 407s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 408s Setting up libssl-dev:armhf (3.4.1-1ubuntu1) ... 408s Setting up libmpc3:armhf (1.3.1-1build2) ... 408s Setting up libtcl8.6:armhf (8.6.16+dfsg-1) ... 408s Setting up autopoint (0.23.1-1) ... 408s Setting up libipc-run-perl (20231003.0-2) ... 408s Setting up libgc1:armhf (1:8.2.8-1) ... 408s Setting up autoconf (2.72-3ubuntu1) ... 408s Setting up libubsan1:armhf (15-20250213-1ubuntu1) ... 408s Setting up dwz (0.15-1build6) ... 408s Setting up libcrypt-dev:armhf (1:4.4.38-1) ... 408s Setting up libasan8:armhf (15-20250213-1ubuntu1) ... 408s Setting up libjson-perl (4.10000-1) ... 408s Setting up postgresql-doc (17+273) ... 408s Setting up libxslt1.1:armhf (1.1.39-0exp1ubuntu2) ... 408s Setting up debugedit (1:5.1-2) ... 408s Setting up libecpg6:armhf (17.3-3) ... 408s Setting up llvm-19-linker-tools (1:19.1.7-1ubuntu1) ... 408s Setting up libgcc-14-dev:armhf (14.2.0-17ubuntu3) ... 408s Setting up libisl23:armhf (0.27-1) ... 408s Setting up llvm-19-runtime (1:19.1.7-1ubuntu1) ... 408s Setting up libc-dev-bin (2.40-4ubuntu1) ... 408s Setting up llvm-19-tools (1:19.1.7-1ubuntu1) ... 408s Setting up libcc1-0:armhf (15-20250213-1ubuntu1) ... 408s Setting up cpp-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 408s Setting up libclang-cpp19 (1:19.1.7-1ubuntu1) ... 408s Setting up postgresql-common-dev (273) ... 408s Setting up automake (1:1.17-3ubuntu1) ... 408s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 408s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 408s Setting up gettext (0.23.1-1) ... 408s Setting up libecpg-compat3:armhf (17.3-3) ... 408s Setting up dictionaries-common (1.30.5) ... 408s Setting up postgresql-client-17 (17.3-3) ... 409s 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 409s Setting up gcc-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 409s Setting up libpq-dev (17.3-3) ... 409s Setting up libobjc4:armhf (15-20250213-1ubuntu1) ... 409s Setting up libobjc-14-dev:armhf (14.2.0-17ubuntu3) ... 409s Setting up libecpg-dev (17.3-3) ... 409s Setting up intltool-debian (0.35.0+20060710.6) ... 409s Setting up postgresql-common (273) ... 410s Creating config file /etc/postgresql-common/createcluster.conf with new version 410s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 410s en_us 410s Removing obsolete dictionary files: 411s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 412s Setting up cpp-14 (14.2.0-17ubuntu3) ... 412s Setting up dh-strip-nondeterminism (1.14.1-2) ... 412s Setting up hunspell-en-us (1:2020.12.07-3) ... 412s Setting up libc6-dev:armhf (2.40-4ubuntu1) ... 412s Setting up llvm-19 (1:19.1.7-1ubuntu1) ... 412s Setting up libstdc++-14-dev:armhf (14.2.0-17ubuntu3) ... 412s Setting up cpp-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 412s Setting up gcc-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 412s Setting up g++-14-arm-linux-gnueabihf (14.2.0-17ubuntu3) ... 412s Setting up postgresql-17 (17.3-3) ... 414s Creating new PostgreSQL cluster 17/main ... 414s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 414s The files belonging to this database system will be owned by user "postgres". 414s This user must also own the server process. 414s 414s The database cluster will be initialized with locale "C.UTF-8". 414s The default database encoding has accordingly been set to "UTF8". 414s The default text search configuration will be set to "english". 414s 414s Data page checksums are disabled. 414s 414s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 414s creating subdirectories ... ok 414s selecting dynamic shared memory implementation ... posix 414s selecting default "max_connections" ... 100 414s selecting default "shared_buffers" ... 128MB 414s selecting default time zone ... Etc/UTC 414s creating configuration files ... ok 414s running bootstrap script ... ok 415s performing post-bootstrap initialization ... ok 415s syncing data to disk ... ok 418s Setting up libncurses-dev:armhf (6.5+20250125-2) ... 418s Setting up po-debconf (1.0.21+nmu1) ... 418s Setting up clang-19 (1:19.1.7-1ubuntu1) ... 418s Setting up gcc-14 (14.2.0-17ubuntu3) ... 418s Setting up llvm-19-dev (1:19.1.7-1ubuntu1) ... 418s Setting up postgresql-plpython3-17 (17.3-3) ... 418s Setting up postgresql-plperl-17 (17.3-3) ... 418s Setting up cpp (4:14.2.0-1ubuntu1) ... 418s Setting up g++-14 (14.2.0-17ubuntu3) ... 418s Setting up g++-arm-linux-gnueabihf (4:14.2.0-1ubuntu1) ... 418s Setting up postgresql-pltcl-17 (17.3-3) ... 418s Setting up libtool (2.5.4-3build1) ... 418s Setting up gcc (4:14.2.0-1ubuntu1) ... 418s Setting up dh-autoreconf (20) ... 418s Setting up postgresql-server-dev-17 (17.3-3) ... 418s Setting up g++ (4:14.2.0-1ubuntu1) ... 418s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 418s Setting up build-essential (12.12) ... 418s Setting up postgresql-server-dev-all (273) ... 418s Setting up debhelper (13.24.1ubuntu2) ... 418s Setting up postgresql-all (273) ... 418s Processing triggers for install-info (7.1.1-1) ... 418s Processing triggers for libc-bin (2.40-4ubuntu1) ... 418s Processing triggers for systemd (257.2-3ubuntu1) ... 418s Processing triggers for man-db (2.13.0-1) ... 420s Processing triggers for dictionaries-common (1.30.5) ... 439s autopkgtest [13:57:36]: test run-testsuite: [----------------------- 442s ====== Running all tests with umask 077 ======= 442s ### PostgreSQL test 001_packages.t ### 442s 1..22 442s ok 1 - /etc/os-release exists 442s ok 2 - OS is ubuntu 442s ok 3 - OS version is 25.04 442s # PostgreSQL versions installed: 17 442s ok 4 - postgresql-17 installed 442s ok 5 - postgresql-plpython3-17 installed 442s ok 6 - postgresql-plperl-17 installed 442s ok 7 - postgresql-pltcl-17 installed 442s ok 8 - postgresql-server-dev-17 installed 442s ok 9 # skip No postgresql-contrib-17 package for version 17 442s # postgresql-doc-17 installed 442s ok 10 - At least one doc package installed 442s ok 11 - libecpg-dev installed 442s ok 12 - postgresql-common-dev installed 442s ok 13 - procps installed 442s ok 14 - netcat-openbsd installed 442s ok 15 - hunspell-en-us installed 442s ok 16 - system has a default UTF-8 locale 442s ok 17 - locale ru_RU exists 442s ok 18 - locale ru_RU.UTF-8 exists 442s ok 19 - user postgres in the UNIX group ssl-cert 442s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 442s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 442s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 442s ### End test 001_packages.t ### 442s 442s ### PostgreSQL test 002_existing_clusters.t ### 442s 1..8 442s # Cleanup 442s ok 1 - Cleanup: No clusters left behind 442s ok 2 - No postgres processes left behind 442s ok 3 - No files in /etc/postgresql left behind 442s ok 4 - No files in /var/lib/postgresql left behind 442s ok 5 - No files in /var/run/postgresql left behind 442s ok 6 - No files in /var/log/postgresql left behind 442s ok 7 - PostgreSQL TCP ports are closed 442s ok 8 - Next free port is 5432 442s ### End test 002_existing_clusters.t ### 442s 442s ### PostgreSQL test 003_alternatives.t ### 442s 1..9 442s # Newest PG version installed is 17 442s ok 1 - psql.1.gz link group 442s ok 2 - postmaster.1.gz link group does not exist 442s ok 3 - psql.1.gz alternative 442s ok 4 - pg_dump.1.gz alternative 442s ok 5 - postgres.1.gz alternative 442s ok 6 - pg_ctl.1.gz alternative 442s # Newest PG doc version installed is 17 442s ok 7 - SPI_connect.3.gz link group 442s ok 8 - SPI_connect.3.gz alternative 442s ok 9 - SPI_exec.3.gz alternative 442s ### End test 003_alternatives.t ### 442s 442s ### PostgreSQL test 005_PgCommon.t ### 442s 1..24 442s ok 1 - correctly parsed line 'local all postgres ident sameuser' 442s ok 2 - correctly parsed line 'local foo nobody trust' 442s ok 3 - correctly parsed line 'local foo nobody crypt' 442s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 442s ok 5 - correctly parsed line 'local foo,bar nobody ident' 442s ok 6 - correctly parsed line 'local all +foogrp password' 442s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 442s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 442s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 442s ok 10 - @expected_records has correct number of entries 442s ok 11 - returned read_pg_hba array has correct number of records 442s ok 12 - line 'foo all all md5' parsed as invalid 442s ok 13 - line 'local all all foo' parsed as invalid 442s ok 14 - line 'host all all foo' parsed as invalid 442s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 442s ok 16 - line 'host all all md5' parsed as invalid 442s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 442s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 442s ok 19 - read_conf_file returns empty dict for nonexisting file 442s ok 20 - read_conf_file() parsing 442s ok 21 - read_conf_file() parsing with include directives 442s ok 22 - set_conf_value 442s ok 23 - disable_conf_value 442s ok 24 - replace_conf_value 442s ### End test 005_PgCommon.t ### 442s 442s ### PostgreSQL test 006_next_free_port.t ### 442s 1..5 442s ok 1 - next_free_port is 5432 443s ok 2 - next_free_port detects localhost ipv4 socket 444s ok 3 - next_free_port detects wildcard ipv4 socket 445s ok 4 - next_free_port detects localhost ipv6 socket 446s ok 5 - next_free_port detects wildcard ipv6 socket 446s ### End test 006_next_free_port.t ### 446s 446s ### PostgreSQL test 007_pg_conftool.t ### 446s 1..41 447s # test without cluster 447s ok 1 - pg_conftool show all 447s ok 2 - correct output of pg_conftool show all 447s ok 3 - pg_conftool foo.conf show all 447s ok 4 - correct output of pg_conftool foo.conf show all 447s ok 5 - pg_conftool /tmp/hTR3Fd5EMV/different.conf show all 447s ok 6 - correct output of pg_conftool /tmp/hTR3Fd5EMV/different.conf show all 447s ok 7 - pg_conftool 9.7 main show all 447s ok 8 - correct output of pg_conftool 9.7 main show all 447s # test show 447s ok 9 - pg_conftool show all 447s ok 10 - correct output of pg_conftool show all 447s ok 11 - pg_conftool other.conf show all 447s ok 12 - correct output of pg_conftool other.conf show all 447s ok 13 - pg_conftool /tmp/hTR3Fd5EMV/different.conf show all 447s ok 14 - correct output of pg_conftool /tmp/hTR3Fd5EMV/different.conf show all 447s ok 15 - pg_conftool 17 main show all 447s ok 16 - correct output of pg_conftool 17 main show all 447s ok 17 - pg_conftool 17 main other.conf show all 447s ok 18 - correct output of pg_conftool 17 main other.conf show all 447s ok 19 - pg_conftool show a 447s ok 20 - correct output of pg_conftool show a 447s ok 21 - pg_conftool -s show a 447s ok 22 - correct output of pg_conftool -s show a 447s # test set 447s ok 23 - pg_conftool set c 7 447s ok 24 - correct output of pg_conftool set c 7 447s ok 25 - file contains new setting 447s ok 26 - pg_conftool set a 8 447s ok 27 - correct output of pg_conftool set a 8 447s ok 28 - file contains updated setting 447s ok 29 - pg_conftool /tmp/hTR3Fd5EMV/different.conf set a 9 447s ok 30 - correct output of pg_conftool /tmp/hTR3Fd5EMV/different.conf set a 9 447s ok 31 - file with path contains updated setting 447s # test remove 447s ok 32 - pg_conftool remove a 447s ok 33 - correct output of pg_conftool remove a 447s ok 34 - setting removed from file 447s ok 35 - pg_conftool /tmp/hTR3Fd5EMV/different.conf remove a 447s ok 36 - correct output of pg_conftool /tmp/hTR3Fd5EMV/different.conf remove a 447s ok 37 - setting removed from file with path 447s # test edit 447s ok 38 - pg_conftool edit 447s ok 39 - correct output of pg_conftool edit 447s ok 40 - pg_conftool /tmp/hTR3Fd5EMV/different.conf edit 447s ok 41 - correct output of pg_conftool /tmp/hTR3Fd5EMV/different.conf edit 447s ### End test 007_pg_conftool.t ### 447s 447s ### PostgreSQL test 010_defaultport_cluster.t ### 447s 1..14 447s ok 1 - psql --version 447s ok 2 - pg_wrapper selects highest available version number 447s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 447s ok 4 - connecting to localhost fails with no clusters 447s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 447s ok 6 - pg_wrapper uses host and port from PGCLUSTER 448s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 448s ok 8 - pg_wrapper uses --cluster from the command line 448s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 448s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 448s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 448s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 448s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 448s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 448s ### End test 010_defaultport_cluster.t ### 448s 448s ### PostgreSQL test 015_start_stop.t ### 448s 1..71 448s # We are running systemd 448s # Running tests for 17 448s # Cluster does not exist yet 448s ok 1 - cluster 17 main does not exist 448s ok 2 - service postgresql@17-main does not exist 448s ok 3 - systemctl start postgresql 448s ok 4 - cluster 17 main does not exist 448s ok 5 - service postgresql@17-main does not exist 448s ok 6 - systemctl start postgresql@17-main 448s ok 7 - cluster 17 main does not exist 448s ok 8 - service postgresql@17-main does not exist 448s # Start/stop postgresql using system tools 449s ok 9 - pg_createcluster 17 main 449s ok 10 - cluster 17 main is stopped 449s ok 11 - service postgresql@17-main is stopped 452s ok 12 - systemctl start postgresql 452s ok 13 - cluster 17 main is running 452s ok 14 - service postgresql@17-main is running 452s ok 15 - systemctl start postgresql 452s ok 16 - cluster 17 main is already running 452s ok 17 - service postgresql@17-main is already running 452s ok 18 - systemctl stop postgresql 458s ok 19 - cluster 17 main is stopped 458s ok 20 - service postgresql@17-main is stopped 458s ok 21 - systemctl stop postgresql 458s ok 22 - cluster 17 main is already stopped 458s ok 23 - service postgresql@17-main is already stopped 458s # Start/stop specific cluster using system tools 460s ok 24 - systemctl start postgresql@17-main 460s ok 25 - cluster 17 main is running 460s ok 26 - service postgresql@17-main is running 460s ok 27 - systemctl start postgresql@17-main 460s ok 28 - cluster 17 main is running 460s ok 29 - service postgresql@17-main is running 463s ok 30 - systemctl restart postgresql@17-main 463s ok 31 - cluster 17 main is running 463s ok 32 - service postgresql@17-main is running 463s ok 33 - systemctl stop postgresql@17-main 463s ok 34 - cluster 17 main is stopped 463s ok 35 - service postgresql@17-main is stopped 463s ok 36 - systemctl stop postgresql@17-main 463s ok 37 - cluster 17 main is already stopped 463s ok 38 - service postgresql@17-main is already stopped 464s ok 39 - pg_dropcluster 17 main 464s ok 40 - cluster 17 main does not exist 464s ok 41 - service postgresql@17-main does not exist 464s # Start/stop specific cluster using pg_*cluster 464s ok 42 - pg_ctlcluster start 17 main 465s ok 43 - cluster 17 main does not exist 465s ok 44 - service postgresql@17-main does not exist 468s ok 45 - pg_createcluster 17 main --start 468s ok 46 - cluster 17 main is running 468s ok 47 - service postgresql@17-main is running 468s ok 48 - pg_ctlcluster 17 main start 468s ok 49 - cluster 17 main is already running 468s ok 50 - service postgresql@17-main is already running 471s ok 51 - pg_ctlcluster 17-main restart 471s ok 52 - cluster 17 main is running 471s ok 53 - service postgresql@17-main is running 471s ok 54 - pg_ctlcluster 17 main stop 471s ok 55 - cluster 17 main is stopped 471s ok 56 - service postgresql@17-main is stopped 471s ok 57 - pg_ctlcluster 17 main stop 471s ok 58 - cluster 17 main is already stopped 471s ok 59 - service postgresql@17-main is already stopped 473s ok 60 - pg_ctlcluster start 17-main 473s ok 61 - cluster 17 main is running 474s ok 62 - service postgresql@17-main is running 475s ok 63 - pg_dropcluster 17 main --stop 475s # Cleanup 475s ok 64 - Cleanup: No clusters left behind 475s ok 65 - No postgres processes left behind 475s ok 66 - No files in /etc/postgresql left behind 475s ok 67 - No files in /var/lib/postgresql left behind 475s ok 68 - No files in /var/run/postgresql left behind 475s ok 69 - No files in /var/log/postgresql left behind 475s ok 70 - PostgreSQL TCP ports are closed 475s ok 71 - Next free port is 5432 475s ### End test 015_start_stop.t ### 475s 475s ### PostgreSQL test 020_create_sql_remove.t ### 475s 1..141 475s # Running tests for 17 479s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.vxRtCC 479s ok 2 - pg_createcluster 17 main 479s ok 3 - Socket and pid file are in /var/run/postgresql/ 479s ok 4 - xlog/wal directory /tmp/17.xlog.vxRtCC was created 479s ok 5 - local method in pg_hba.conf is peer 479s ok 6 - host method in pg_hba.conf is scram-sha-256 479s ok 7 - Exactly one postgres master process running 481s ok 8 - pg_ctlcluster 17 main restart 481s ok 9 - cluster restarts with new environment file 481s ok 10 - Exactly one postgres master process running 481s ok 11 - correct value of PGEXTRAVAR1 in environment 481s ok 12 - correct value of PGEXTRAVAR2 in environment 481s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 481s ok 14 - createdb --version 481s ok 15 - pg_wrapper+createdb selects version number of cluster 481s ok 16 - psql --version 481s ok 17 - pg_wrapper+psql selects version 17 481s ok 18 - pg_lscluster reports online cluster on port 5432 481s ok 19 - log file is actually used 481s ok 20 - /etc/postgresql is owned by user "postgres" 481s ok 21 - version configuration directory file is owned by user "postgres" 481s ok 22 - configuration directory file is owned by user "postgres" 481s ok 23 - version data directory file is owned by user "postgres" 481s ok 24 - data directory file is owned by user "postgres" 481s ok 25 - log file has 0640 permissions 481s ok 26 - log file is owned by user "postgres" 481s ok 27 - log file is owned by group "adm" 481s ok 28 - no log symlink by default 481s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 481s ok 30 - pg_lsclusters -h 481s ok 31 - correct output of pg_lsclusters -h 481s ok 32 - stopping cluster 484s ok 33 - restarting cluster with nondefault log symlink 484s ok 34 - log target is used as log file 484s ok 35 - default log is not used 484s ok 36 - pg_lsclusters -h 484s ok 37 - correct output of pg_lsclusters -h 484s ok 38 - stopping cluster 487s ok 39 - restarting cluster with explicitly configured log file 487s ok 40 - default log is not used 487s ok 41 - log symlink target is used for startup message 487s ok 42 - exactly one log file 487s ok 43 - custom log is actually used 487s ok 44 - pg_lsclusters -h 487s ok 45 - correct output of pg_lsclusters -h 487s ok 46 - stopping cluster 487s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 487s ok 48 - /etc/postgres-hack was not created 490s ok 49 - restarting cluster 490s ok 50 - ps -o tty -U postgres h 490s ok 51 - postgres processes do not have an associated terminal 490s ok 52 - Server is linked with SSL support 490s ok 53 - SSL is enabled in postgresql.conf 490s ok 54 - psql -l fails for nobody 490s ok 55 - createuser nobody 490s ok 56 - createdb nobodydb 490s ok 57 - psql -ltA succeeds for nobody 490s ok 58 - psql -ltA output 490s ok 59 - SQL command: create table 490s ok 60 - SQL command: insert into table values 490s ok 61 - SQL command: insert into table values 490s ok 62 - primary key violation 490s ok 63 - psql -tAc "select * from phone order by name" nobodydb 490s ok 64 - SQL command output: select -tA 490s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 490s ok 66 - SQL command output: select -tx 490s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 490s ok 68 - SQL command output: select -tAx 490s ok 69 - CREATE EXTENSION plperlu fails for user nobody 490s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 490s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 490s ok 72 - creating PL/PerlU function as user nobody fails 491s ok 73 - creating unsafe PL/Perl function as user postgres fails 491s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 491s ok 75 - creating PL/PerlU function as user postgres succeeds 491s ok 76 - psql nobodydb -Atc "select read_file()" 491s ok 77 - calling PL/PerlU function 491s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 491s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 491s ok 80 - creating unsafe PL/Perl function as user nobody fails 491s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 491s ok 82 - creating PL/Perl function as user nobody succeeds 491s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 491s ok 84 - calling PL/Perl function 491s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 491s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 491s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 491s ok 88 - creating PL/Python3 function as user postgres succeeds 491s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 491s ok 90 - calling PL/Python function 491s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 491s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 491s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 491s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 492s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 492s ok 96 - creating PL/Tcl function as user nobody succeeds 492s 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;" 492s ok 98 - creating PL/TclU function as user postgres succeeds 492s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 492s ok 100 - calling PL/Tcl function 492s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 492s ok 102 - calling PL/TclU function 492s ok 103 - stopping cluster 492s ok 104 - pg_ctlcluster 17 main start 492s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 494s ok 106 - pg_ctlcluster 17 main start 494s ok 107 - cluster restarts with pgdata symlink 495s ok 108 # skip skipping postmaster OOM killer adjustment in container 495s ok 109 - postgres client backend has no OOM adjustment 495s ok 110 - ps h 5455 495s ok 111 - process title is idle 495s ok 112 - ps h 5455 495s ok 113 - process title is idle in transaction 495s ok 114 - stopping cluster 497s ok 115 - starting cluster as postgres works without a log file 497s ok 116 - log file got recreated and used 497s ok 117 - creating a directory in spc2 498s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.PxnhK2'" 498s ok 119 - creating tablespace spc1 498s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 498s ok 121 - creating a table in spc1 498s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.wc0lIe'" 498s ok 123 - creating tablespace spc2 498s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 498s ok 125 - creating a table in spc2 498s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 498s ok 127 - Correct apt NeverAutoRemove config 499s ok 128 - pg_dropcluster removes cluster 499s ok 129 - xlog/wal directory /tmp/17.xlog.vxRtCC was deleted 499s ok 130 - tablespace spc1 was emptied 499s ok 131 - tablespace spc2 was emptied 499s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 499s ok 133 - Correct apt NeverAutoRemove config 499s # Cleanup 499s ok 134 - Cleanup: No clusters left behind 499s ok 135 - No postgres processes left behind 499s ok 136 - No files in /etc/postgresql left behind 499s ok 137 - No files in /var/lib/postgresql left behind 499s ok 138 - No files in /var/run/postgresql left behind 499s ok 139 - No files in /var/log/postgresql left behind 499s ok 140 - PostgreSQL TCP ports are closed 499s ok 141 - Next free port is 5432 499s ### End test 020_create_sql_remove.t ### 499s 499s ### PostgreSQL test 021_pg_renamecluster.t ### 499s 1..20 503s ok 1 - pg_createcluster 17 main 506s ok 2 - pg_renamecluster 17 main donau 506s ok 3 - psql -tAc "show data_directory" 506s ok 4 - cluster is running and data_directory was moved 506s ok 5 - pg_hba.conf location updated 506s ok 6 - pg_ident.conf location updated 506s ok 7 - external_pid_file location updated 506s ok 8 - external_pid_file exists 506s ok 9 # skip no stats_temp_directory in 17 506s ok 10 # skip no stats_temp_directory in 17 506s ok 11 - cluster_name is updated 508s ok 12 - pg_dropcluster removes cluster 508s # Cleanup 508s ok 13 - Cleanup: No clusters left behind 508s ok 14 - No postgres processes left behind 508s ok 15 - No files in /etc/postgresql left behind 508s ok 16 - No files in /var/lib/postgresql left behind 508s ok 17 - No files in /var/run/postgresql left behind 508s ok 18 - No files in /var/log/postgresql left behind 508s ok 19 - PostgreSQL TCP ports are closed 508s ok 20 - Next free port is 5432 508s ### End test 021_pg_renamecluster.t ### 508s 508s ### PostgreSQL test 022_recovery.t ### 508s 1..17 508s # Running tests for 17 511s ok 1 - pg_createcluster 17 main --start >/dev/null 511s ok 2 - pg_ctlcluster 17 main stop -m i 513s ok 3 - pg_ctlcluster 17 main start 513s ok 4 - psql -c '' 514s ok 5 - pg_ctlcluster 17 main stop -m i 514s ok 6 - create write-protected file in data directory 516s ok 7 - pg_ctlcluster 17 main start 516s ok 8 - psql -c '' 518s ok 9 - pg_dropcluster removes cluster 518s # Cleanup 518s ok 10 - Cleanup: No clusters left behind 518s ok 11 - No postgres processes left behind 518s ok 12 - No files in /etc/postgresql left behind 518s ok 13 - No files in /var/lib/postgresql left behind 518s ok 14 - No files in /var/run/postgresql left behind 518s ok 15 - No files in /var/log/postgresql left behind 518s ok 16 - PostgreSQL TCP ports are closed 518s ok 17 - Next free port is 5432 518s ### End test 022_recovery.t ### 518s 518s ### PostgreSQL test 025_logging.t ### 518s 1..55 519s # Logging to /var/log/syslog works 519s # Running tests for 17 522s ok 1 - pg_createcluster 17 main 522s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 522s ok 3 - psql -qc "'foobar_17_6592'" 522s ok 4 - log an error 523s ok 5 - grep --binary-files=text foobar_17_6592 /var/log/postgresql/postgresql-17-main.log 523s ok 6 - error appears in logfile 523s ok 7 - pg_conftool 17 main set log_destination syslog 523s ok 8 - set log_destination syslog 523s ok 9 - pg_ctlcluster 17 main reload 523s ok 10 - 17 main reload 523s ok 11 - psql -Atc "show log_destination" 523s ok 12 - log_destination is syslog 523s ok 13 - pg_lscluster reports syslog 523s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 523s ok 15 - error appears in /var/log/syslog 523s ok 16 - pg_conftool 17 main set logging_collector on 523s ok 17 - set logging_collector on 523s ok 18 - pg_conftool 17 main set log_destination csvlog 523s ok 19 - set log_destination csvlog 526s ok 20 - pg_ctlcluster 17 main restart 526s ok 21 - 17 main restart 526s ok 22 - psql -Atc "show logging_collector" 526s ok 23 - logging_collector is on 526s ok 24 - psql -Atc "show log_destination" 526s ok 25 - log_destination is csvlog 526s ok 26 - pg_lscluster reports csvlog 526s ok 27 - psql -qc "'barbaz_17_6592'" 526s ok 28 - log an error 527s ok 29 - grep --binary-files=text barbaz_17_6592 /var/lib/postgresql/17/main/log/*.csv 527s ok 30 - error appears in log/*.csv 527s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 527s ok 32 - set log_destination stderr,syslog,csvlog 527s ok 33 - pg_ctlcluster 17 main reload 527s ok 34 - 17 main reload 527s ok 35 - psql -Atc "show log_destination" 527s ok 36 - log_destination is stderr,syslog,csvlog 527s ok 37 - pg_lscluster reports stderr,syslog,csvlog 527s ok 38 - psql -qc "'moo_17_6592'" 527s ok 39 - log an error 527s ok 40 - grep --binary-files=text moo_17_6592 /var/lib/postgresql/17/main/log/*.log 527s ok 41 - error appears in log/*.log 528s ok 42 - grep --binary-files=text 'postgres.*moo_17_6592' /var/log/syslog 528s ok 43 - error appears in /var/log/syslog 528s ok 44 - grep --binary-files=text moo_17_6592 /var/lib/postgresql/17/main/log/*.csv 528s ok 45 - error appears in log/*.csv 530s ok 46 - pg_dropcluster 17 main --stop 530s ok 47 - pg_dropcluster removes cluster 530s # Cleanup 530s ok 48 - Cleanup: No clusters left behind 530s ok 49 - No postgres processes left behind 530s ok 50 - No files in /etc/postgresql left behind 530s ok 51 - No files in /var/lib/postgresql left behind 530s ok 52 - No files in /var/run/postgresql left behind 530s ok 53 - No files in /var/log/postgresql left behind 530s ok 54 - PostgreSQL TCP ports are closed 530s ok 55 - Next free port is 5432 530s ### End test 025_logging.t ### 530s 530s ### PostgreSQL test 027_jit.t ### 530s # 17 533s ok 1 - pg_createcluster 17 main --start 533s ok 2 - psql -Xatc 'show jit' 533s ok 3 - JIT is on by default 533s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 533s ok 5 - No JIT on cheap query 533s ok 6 - pg_conftool 17 main set seq_page_cost 100000 534s ok 7 - pg_conftool 17 main set random_page_cost 100000 534s ok 8 - pg_ctlcluster 17 main reload 534s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 534s ok 10 - Expensive query is JITed 535s ok 11 - pg_dropcluster --stop 17 main 535s # Cleanup 536s ok 12 - Cleanup: No clusters left behind 536s ok 13 - No postgres processes left behind 536s ok 14 - No files in /etc/postgresql left behind 536s ok 15 - No files in /var/lib/postgresql left behind 536s ok 16 - No files in /var/run/postgresql left behind 536s ok 17 - No files in /var/log/postgresql left behind 536s ok 18 - PostgreSQL TCP ports are closed 536s ok 19 - Next free port is 5432 536s 1..19 536s ### End test 027_jit.t ### 536s 536s ### PostgreSQL test 030_errors.t ### 536s 1..156 536s ok 1 - pg_lscluster reports cluster without binaries 537s ok 2 - pg_dropcluster 6.3 main 538s ok 3 - pg_createcluster --socketdir 538s ok 4 - pg_lsclusters -h 538s ok 5 - cluster was created 538s ok 6 - Port of created cluster is 5432 538s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 538s ok 8 - pg_createcluster on existing cluster 538s ok 9 - pg_lsclusters -h 538s ok 10 - original cluster still exists 538s ok 11 - pg_createcluster 17 test -p foo 538s ok 12 - pg_createcluster -p checks that port option is numeric 538s ok 13 - pg_createcluster 17 test -p 42 538s ok 14 - pg_createcluster -p checks valid port range 538s ok 15 - pg_ctlcluster 17 main start 538s ok 16 - pg_ctlcluster refuses to start root-owned cluster 538s ok 17 - pg_ctlcluster 17 main start 538s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 538s ok 19 - pg_ctlcluster 17 main start 538s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 539s ok 21 - pg_ctlcluster 17 main start 539s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 541s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 541s ok 24 - No sockets in /var/run/postgresql 541s ok 25 - Socket is in /tmp/postgresql-testsuite/ 541s ok 26 - cluster stops with custom unix_socket_dir 541s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 543s ok 28 - cluster starts after removing unix_socket_dir 543s ok 29 - Socket is in default dir /var/run/postgresql 543s ok 30 - No sockets in /tmp/postgresql-testsuite/ 543s ok 31 - pg_ctlcluster 17 main stop 543s ok 32 - pg_ctlcluster fails with corrupted PID file 544s ok 33 - pg_lsclusters -h 544s ok 34 - cluster is still online 544s ok 35 - pg_ctlcluster succeeds with restored PID file 544s ok 36 - pg_lsclusters -h 544s ok 37 - cluster is down 544s ok 38 - pg_ctlcluster 17 main stop 544s ok 39 - pg_ctlcluster stop fails on stopped cluster 546s ok 40 - pg_ctlcluster 17 main start 546s ok 41 - pg_ctlcluster succeeds with already existing PID file 546s ok 42 - pg_lsclusters -h 546s ok 43 - cluster is online 546s ok 44 - pg_ctlcluster stop succeeds 546s ok 45 - pg_lsclusters -h 547s ok 46 - cluster is down 547s ok 47 - no pid file left 547s ok 48 - pg_ctlcluster 17 main stop 547s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 547s ok 50 - pid file was cleaned up 547s ok 51 - pg_ctlcluster --force 17 main stop 547s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 547s ok 53 - pid file was cleaned up 547s ok 54 - pg_ctlcluster 17 main stop 547s ok 55 - pg_ctlcluster stop succeeds with stale PID file 547s ok 56 - pid file was cleaned up 547s ok 57 - pg_ctlcluster --force 17 main stop 547s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 547s ok 59 - pid file was cleaned up 547s ok 60 - pg_ctlcluster --force 17 main stop 547s ok 61 - pg_ctlcluster stop succeeds with empty PID file 547s ok 62 - pid file was cleaned up 549s ok 63 - pg_ctlcluster 17 main start 549s ok 64 - pg_ctlcluster succeeds with corrupted PID file 549s ok 65 - pg_lsclusters -h 549s ok 66 - cluster is online 549s ok 67 - pg_ctlcluster 17 main start 549s ok 68 - pg_ctlcluster start fails on running cluster 549s ok 69 - pg_ctlcluster stop 549s ok 70 - pg_ctlcluster 17 main start 549s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 550s ok 72 - pg_ctlcluster 17 main stop 550s ok 73 - stopping cluster 556s ok 74 - pg_ctlcluster 17 main start 556s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 556s ok 76 - pg_ctlcluster 17 main stop 556s ok 77 - stopping cluster 556s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 556s ok 79 - pg_dropcluster 17 main 556s ok 80 - pg_dropcluster works as user postgres 557s ok 81 - pg_createcluster succeeds 557s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 557s ok 83 - proper error message for nonexisting /var/lib/postgresql 560s ok 84 - pg_ctlcluster 17 main start 560s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 560s ok 86 - pg_ctlcluster 17 main stop 560s ok 87 - stopping cluster 561s ok 88 - pg_createcluster other 563s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 565s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 565s ok 91 566s ok 92 - pg_ctlcluster 17 other start 566s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 566s ok 94 - pg_ctlcluster 17 main stop 566s ok 95 - stopping main cluster 568s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 569s ok 97 - pg_dropcluster other 571s ok 98 - pg_dropcluster 571s ok 99 - No sockets any more 571s ok 100 - 'pg_lsclusters 4.5 foo' fails 571s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 571s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 571s ok 103 - 'psql --cluster 4.5/foo' fails 571s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 571s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 571s ok 106 - 'psql --cluster 17/foo' fails 571s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 571s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 571s ok 109 - 'pg_dropcluster 4.5 foo' fails 571s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 571s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 571s ok 112 - 'pg_dropcluster 17 foo' fails 571s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 571s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 571s ok 115 - 'pg_upgradecluster 4.5 foo' fails 571s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 571s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 571s ok 118 - 'pg_upgradecluster 17 foo' fails 571s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 571s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 571s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 571s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 571s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 571s ok 124 - 'pg_ctlcluster 17 foo stop' fails 571s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 571s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 571s # Cleanup 571s ok 127 - Cleanup: No clusters left behind 571s ok 128 - No postgres processes left behind 571s ok 129 - No files in /etc/postgresql left behind 571s ok 130 - No files in /var/lib/postgresql left behind 571s ok 131 - No files in /var/run/postgresql left behind 571s ok 132 - No files in /var/log/postgresql left behind 571s ok 133 - PostgreSQL TCP ports are closed 571s ok 134 - Next free port is 5432 572s ok 135 - pg_dropcluster 17 broken 572s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 572s # Cleanup 572s ok 137 - Cleanup: No clusters left behind 572s ok 138 - No postgres processes left behind 572s ok 139 - No files in /etc/postgresql left behind 572s ok 140 - No files in /var/lib/postgresql left behind 572s ok 141 - No files in /var/run/postgresql left behind 572s ok 142 - No files in /var/log/postgresql left behind 572s ok 143 - PostgreSQL TCP ports are closed 572s ok 144 - Next free port is 5432 574s ok 145 - pg_dropcluster 17 broken 574s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 574s ok 147 - /etc/postgresql/17 was removed 574s ok 148 - /var/lib/postgresql/17 was removed 574s # Cleanup 574s ok 149 - Cleanup: No clusters left behind 574s ok 150 - No postgres processes left behind 574s ok 151 - No files in /etc/postgresql left behind 574s ok 152 - No files in /var/lib/postgresql left behind 574s ok 153 - No files in /var/run/postgresql left behind 574s ok 154 - No files in /var/log/postgresql left behind 574s ok 155 - PostgreSQL TCP ports are closed 574s ok 156 - Next free port is 5432 574s ### End test 030_errors.t ### 574s 574s ### PostgreSQL test 031_errors_disk_full.t ### 574s 1..22 574s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 575s ok 1 - script failed 575s ok 2 - pg_createcluster fails due to insufficient disk space 575s ok 3 - does not leave files behind 575s # Cleanup 575s ok 4 - Cleanup: No clusters left behind 575s ok 5 - No postgres processes left behind 575s ok 6 - No files in /etc/postgresql left behind 575s ok 7 - No files in /var/lib/postgresql left behind 575s ok 8 - No files in /var/run/postgresql left behind 575s ok 9 - No files in /var/log/postgresql left behind 575s ok 10 - PostgreSQL TCP ports are closed 575s ok 11 - Next free port is 5432 575s # check disk full conditions on startup 578s ok 12 - script failed 578s ok 13 - pg_ctlcluster prints error message 578s ok 14 - log file has error message 578s # Cleanup 578s ok 15 - Cleanup: No clusters left behind 578s ok 16 - No postgres processes left behind 578s ok 17 - No files in /etc/postgresql left behind 578s ok 18 - No files in /var/lib/postgresql left behind 578s ok 19 - No files in /var/run/postgresql left behind 578s ok 20 - No files in /var/log/postgresql left behind 578s ok 21 - PostgreSQL TCP ports are closed 578s ok 22 - Next free port is 5432 578s ### End test 031_errors_disk_full.t ### 578s 578s ### PostgreSQL test 032_ssl_key_permissions.t ### 578s 1..22 578s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 578s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 578s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 579s ok 4 - pg_createcluster 17 main 579s ok 5 - pg_ctlcluster 17 main start 579s ok 6 - ssl key owned by nobody refused 580s ok 7 - pg_ctlcluster 17 main start 580s ok 8 - ssl key with permissions root:root 0644 refused 580s ok 9 - pg_ctlcluster 17 main start 580s ok 10 - ssl key with permissions postgres:postgres 0640 refused 581s ok 11 - pg_dropcluster 17 main --stop 581s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 581s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 581s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 581s # Cleanup 581s ok 15 - Cleanup: No clusters left behind 581s ok 16 - No postgres processes left behind 581s ok 17 - No files in /etc/postgresql left behind 581s ok 18 - No files in /var/lib/postgresql left behind 581s ok 19 - No files in /var/run/postgresql left behind 581s ok 20 - No files in /var/log/postgresql left behind 581s ok 21 - PostgreSQL TCP ports are closed 581s ok 22 - Next free port is 5432 581s ### End test 032_ssl_key_permissions.t ### 581s 581s ### PostgreSQL test 040_upgrade.t ### 581s 1..1 581s ok 1 - only one major version installed, skipping upgrade tests 581s ### End test 040_upgrade.t ### 581s 581s ### PostgreSQL test 041_upgrade_custompaths.t ### 581s 1..1 581s ok 1 - only one major version installed, skipping upgrade tests 581s ### End test 041_upgrade_custompaths.t ### 581s 581s ### PostgreSQL test 042_upgrade_rename.t ### 582s 1..15 582s # PostgreSQL 17 585s ok 1 - pg_createcluster 17 main --start 592s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 592s ok 3 - pg_lsclusters -h 592s ok 4 - correct output of pg_lsclusters -h 593s ok 5 - pg_dropcluster 17 main --stop 595s ok 6 - pg_dropcluster 17 upgr --stop 595s ok 7 - Cleaning pg_upgrade log files 595s # Cleanup 595s ok 8 - Cleanup: No clusters left behind 595s ok 9 - No postgres processes left behind 595s ok 10 - No files in /etc/postgresql left behind 595s ok 11 - No files in /var/lib/postgresql left behind 595s ok 12 - No files in /var/run/postgresql left behind 595s ok 13 - No files in /var/log/postgresql left behind 595s ok 14 - PostgreSQL TCP ports are closed 595s ok 15 - Next free port is 5432 595s ### End test 042_upgrade_rename.t ### 595s 595s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 595s 1..1 595s ok 1 - only one major version installed, skipping upgrade tests 595s ### End test 043_upgrade_ssl_cert.t ### 595s 595s ### PostgreSQL test 045_backup.t ### 595s # We are running systemd 595s # PostgreSQL 17 595s # create cluster 598s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 599s ok 2 - pg_lsclusters -h 599s ok 3 - correct output of pg_lsclusters -h 599s ok 4 - pg_conftool 17 main set work_mem 11MB 599s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 599s ok 6 - psql -c 'alter database mydb set search_path=public' 599s ok 7 - psql -c 'create table foo (t text)' mydb 599s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 599s ok 9 - psql -c 'CREATE USER myuser' 599s ok 10 - psql -c 'grant create on database mydb to myuser' 599s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 599s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 599s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 599s # create directory 599s ok 14 - pg_backupcluster 17 main createdirectory 599s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 599s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 599s # dump 600s ok 17 - systemctl start pg_dump@17-main 600s ok 18 - dump created in /var/backups/postgresql/17-main/2025-02-21T140016Z.dump 600s ok 19 - /var/backups/postgresql/17-main/2025-02-21T140016Z.dump owned by uid postgres 600s ok 20 - /var/backups/postgresql/17-main/2025-02-21T140016Z.dump owned by gid postgres 600s # basebackup 600s ok 21 - systemctl start pg_receivewal@17-main 600s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 600s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 601s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 601s ok 25 - psql -c 'select pg_reload_conf()' 629s ok 26 - systemctl start pg_basebackup@17-main 629s ok 27 - dump created in /var/backups/postgresql/17-main/2025-02-21T140018Z.backup 629s ok 28 - /var/backups/postgresql/17-main/2025-02-21T140018Z.backup owned by uid postgres 629s ok 29 - /var/backups/postgresql/17-main/2025-02-21T140018Z.backup owned by gid postgres 629s # list 629s ok 30 - pg_backupcluster 17 main list 629s ok 31 - correct output of pg_backupcluster 17 main list 629s # more database changes 629s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 629s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 629s ok 34 - retrieve recovery timestamp 629s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 629s ok 36 - systemctl stop pg_receivewal@17-main 629s # restore /var/backups/postgresql/17-main/2025-02-21T140016Z.dump 631s ok 37 - pg_dropcluster 17 main --stop 636s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-02-21T140016Z.dump --start --datadir /var/lib/postgresql/17/snowflake 636s ok 39 - pg_lsclusters -h 636s ok 40 - correct output of pg_lsclusters -h 636s ok 41 - psql -XAtl 636s ok 42 - mydb locales 636s ok 43 - mydb grants 636s ok 44 - myicudb locales 636s ok 45 - psql -XAtc 'show work_mem' 636s ok 46 - correct output of psql -XAtc 'show work_mem' 636s ok 47 - psql -XAtc 'select * from foo' mydb 636s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 637s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 637s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 637s ok 51 - psql -XAtc '\drds' 637s ok 52 - correct output of psql -XAtc '\drds' 637s # restore /var/backups/postgresql/17-main/2025-02-21T140018Z.backup 638s ok 53 - pg_dropcluster 17 main --stop 642s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-02-21T140018Z.backup --start --datadir /var/lib/postgresql/17/snowflake 642s ok 55 - pg_lsclusters -h 642s ok 56 - correct output of pg_lsclusters -h 642s ok 57 - psql -XAtl 642s ok 58 - mydb locales 642s ok 59 - mydb grants 642s ok 60 - myicudb locales 642s ok 61 - psql -XAtc 'show work_mem' 642s ok 62 - correct output of psql -XAtc 'show work_mem' 642s ok 63 - psql -XAtc 'select * from foo' mydb 642s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 642s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 642s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 642s ok 67 - psql -XAtc '\drds' 642s ok 68 - correct output of psql -XAtc '\drds' 642s # restore /var/backups/postgresql/17-main/2025-02-21T140018Z.backup with WAL archive 644s ok 69 - pg_dropcluster 17 main --stop 647s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-02-21T140018Z.backup --start --archive --port 5430 647s ok 71 - pg_lsclusters -h 647s ok 72 - correct output of pg_lsclusters -h 647s ok 73 - psql -XAtc 'select * from foo order by t' mydb 647s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 648s # restore /var/backups/postgresql/17-main/2025-02-21T140018Z.backup with PITR 649s ok 75 - pg_dropcluster 17 main --stop 653s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-02-21T140018Z.backup --start --pitr '2025-02-21 14:00:46.332772+00 653s # ' 653s ok 77 - pg_lsclusters -h 653s ok 78 - correct output of pg_lsclusters -h 653s ok 79 - psql -XAtc 'select * from foo order by t' mydb 653s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 655s ok 81 - pg_dropcluster 17 main --stop 655s # Cleanup 655s ok 82 - Cleanup: No clusters left behind 655s ok 83 - No postgres processes left behind 655s ok 84 - No files in /etc/postgresql left behind 655s ok 85 - No files in /var/lib/postgresql left behind 655s ok 86 - No files in /var/run/postgresql left behind 655s ok 87 - No files in /var/log/postgresql left behind 655s ok 88 - PostgreSQL TCP ports are closed 655s ok 89 - Next free port is 5432 655s 1..89 655s ### End test 045_backup.t ### 655s 655s ### PostgreSQL test 050_encodings.t ### 655s 1..60 655s # Checking 17 ru_RU 658s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 659s ok 2 - psql -l succeeds 659s ok 3 - template1 is not UTF-8 encoded 659s ok 4 - creating test database 659s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 659s # create table t (x varchar); copy t from stdin" test 659s ok 6 - creating table with ISO-8859-5 characters 659s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 659s ok 8 - correct string in UTF-8 659s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 659s ok 10 - correct string in ISO-8859-5 659s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 659s # delete from t; copy t from stdin" test 659s ok 12 - creating table with UTF-8 characters 660s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 660s ok 14 - correct string in UTF-8 660s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 660s ok 16 - correct string in ISO-8859-1 660s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 660s ok 18 - Server error message has correct language and encoding 662s ok 19 - pg_ctlcluster 17 ru_RU restart 662s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 664s ok 21 - Dropping cluster 664s # Checking 17 ru_RU.UTF-8 667s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 668s ok 23 - psql -l succeeds 668s ok 24 - template1 is UTF-8 encoded 668s ok 25 - creating test database 668s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 668s # create table t (x varchar); copy t from stdin" test 668s ok 27 - creating table with ISO-8859-5 characters 668s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 668s ok 29 - correct string in UTF-8 668s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 668s ok 31 - correct string in ISO-8859-5 669s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 669s # delete from t; copy t from stdin" test 669s ok 33 - creating table with UTF-8 characters 669s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 669s ok 35 - correct string in UTF-8 669s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 669s ok 37 - correct string in ISO-8859-1 669s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 669s ok 39 - Server error message has correct language and encoding 671s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 671s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 671s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 671s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 671s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 671s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 671s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 671s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 673s ok 48 - Dropping cluster 673s # Check 17 locale environment variables 677s ok 49 - pg_createcluster: LC_ALL dominates LANG 677s ok 50 - psql -Atl --cluster 17/main 677s ok 51 - template1 is ASCII encoded 678s ok 52 - Dropping cluster 678s # Cleanup 679s ok 53 - Cleanup: No clusters left behind 679s ok 54 - No postgres processes left behind 679s ok 55 - No files in /etc/postgresql left behind 679s ok 56 - No files in /var/lib/postgresql left behind 679s ok 57 - No files in /var/run/postgresql left behind 679s ok 58 - No files in /var/log/postgresql left behind 679s ok 59 - PostgreSQL TCP ports are closed 679s ok 60 - Next free port is 5432 679s ### End test 050_encodings.t ### 679s 679s ### PostgreSQL test 052_upgrade_encodings.t ### 679s 1..1 679s ok 1 - only one major version installed, skipping upgrade tests 679s ### End test 052_upgrade_encodings.t ### 679s 679s ### PostgreSQL test 060_obsolete_confparams.t ### 679s ok 1 - only one major version installed, skipping upgrade tests 679s 1..1 679s ### End test 060_obsolete_confparams.t ### 679s 679s ### PostgreSQL test 070_non_postgres_clusters.t ### 679s 1..40 680s ok 1 - pg_createcluster 17 main for owner nobody 680s ok 2 - pg_ctlcluster 17 main start 680s ok 3 - start refused when config and data owners mismatch 682s ok 4 - pg_ctlcluster succeeds with owner nobody 682s ok 5 - pg_lsclusters -h 682s ok 6 - pg_lsclusters shows running cluster 682s ok 7 - postgres is running as user nobody 682s ok 8 - ls /tmp/.s.PGSQL.* 682s ok 9 - socket is in /tmp 682s ok 10 - /var/run/postgresql is empty 682s ok 11 - conf dir is owned by user 682s ok 12 - conf dir is owned by user's primary group 682s ok 13 - files are owned by user 682s ok 14 - files are owned by user's primary group 682s ok 15 - log file has 0640 permissions 682s ok 16 - log file is owned by user 682s ok 17 - log file is owned by user's primary group 682s ok 18 - only one major version installed, skipping upgrade test 682s ok 19 - ... 682s ok 20 - ... 682s ok 21 - ... 682s ok 22 - ... 682s ok 23 - ... 682s ok 24 - ... 682s ok 25 - ... 682s ok 26 - ... 682s ok 27 - ... 682s ok 28 - ... 684s ok 29 - pg_dropcluster 684s ok 30 - pg_lsclusters -h 684s ok 31 - No clusters left 684s ok 32 - No postgres processes left 684s # Cleanup 684s ok 33 - Cleanup: No clusters left behind 684s ok 34 - No postgres processes left behind 684s ok 35 - No files in /etc/postgresql left behind 684s ok 36 - No files in /var/lib/postgresql left behind 684s ok 37 - No files in /var/run/postgresql left behind 684s ok 38 - No files in /var/log/postgresql left behind 684s ok 39 - PostgreSQL TCP ports are closed 684s ok 40 - Next free port is 5432 684s ### End test 070_non_postgres_clusters.t ### 684s 684s ### PostgreSQL test 080_start.conf.t ### 684s 1..73 685s ok 1 - pg_createcluster 17 main 685s # start.conf auto 685s ok 2 - get_cluster_start_conf returns auto 685s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 685s ok 4 - start.conf contains auto 685s ok 5 - systemd generator links cluster 685s ok 6 - systemd generator links correct service file 687s ok 7 - /etc/init.d/postgresql start 17 687s ok 8 - correct output of /etc/init.d/postgresql start 17 687s ok 9 - pg_lsclusters -h 687s ok 10 - cluster is online 687s ok 11 - /etc/init.d/postgresql stop 17 687s ok 12 - correct output of /etc/init.d/postgresql stop 17 691s ok 13 - pg_lsclusters -h 691s ok 14 - cluster is down 691s # start.conf manual 691s ok 15 - get_cluster_start_conf returns manual 691s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 691s ok 17 - start.conf contains manual 691s ok 18 - systemd generator doesn't link cluster 691s ok 19 - /etc/init.d/postgresql start 17 691s ok 20 - correct output of /etc/init.d/postgresql start 17 691s ok 21 - pg_lsclusters -h 691s ok 22 - cluster is down 693s ok 23 - pg_ctlcluster 17 main start 693s ok 24 - correct output of pg_ctlcluster 17 main start 693s ok 25 - pg_lsclusters -h 693s ok 26 - cluster is online 693s ok 27 - pg_ctlcluster 17 main stop 693s ok 28 - correct output of pg_ctlcluster 17 main stop 693s ok 29 - pg_lsclusters -h 693s ok 30 - cluster is down 693s # start.conf disabled 693s ok 31 - get_cluster_start_conf returns disabled 694s ok 32 - systemd generator doesn't link cluster 694s ok 33 - /etc/init.d/postgresql start 17 694s ok 34 - correct output of /etc/init.d/postgresql start 17 694s ok 35 - pg_lsclusters -h 694s ok 36 - cluster is down 694s ok 37 - pg_ctlcluster 17 main start 694s ok 38 - correct output of pg_ctlcluster 17 main start 694s ok 39 - pg_lsclusters -h 694s ok 40 - cluster is down 696s ok 41 - pg_ctlcluster 17 main start 696s ok 42 - correct output of pg_ctlcluster 17 main start 696s ok 43 - pg_lsclusters -h 696s ok 44 - cluster is online 696s ok 45 - pg_ctlcluster 17 main stop 696s ok 46 - correct output of pg_ctlcluster 17 main stop 696s ok 47 - pg_lsclusters -h 696s ok 48 - cluster is down 698s ok 49 - pg_ctlcluster 17 main start 698s ok 50 - correct output of pg_ctlcluster 17 main start 698s ok 51 - pg_lsclusters -h 698s ok 52 - cluster is online 698s # test upgrade 698s ok 53 - only one major version installed, skipping upgrade test 698s ok 54 - ... 698s ok 55 - get_cluster_start_conf for old cluster returns manual 698s ok 56 - get_cluster_start_conf for new cluster returns manual 698s ok 57 - ... 700s ok 58 - dropping upgraded cluster 700s ok 59 - pg_lsclusters -h 700s ok 60 - no clusters any more 700s ok 61 - pg_createcluster 17 main --start-conf foo 700s ok 62 - pg_createcluster checks --start-conf validity 701s ok 63 - pg_createcluster checks --start-conf manual 701s ok 64 - get_cluster_start_conf returns manual 702s ok 65 - dropping cluster 702s # Cleanup 702s ok 66 - Cleanup: No clusters left behind 702s ok 67 - No postgres processes left behind 702s ok 68 - No files in /etc/postgresql left behind 702s ok 69 - No files in /var/lib/postgresql left behind 702s ok 70 - No files in /var/run/postgresql left behind 702s ok 71 - No files in /var/log/postgresql left behind 702s ok 72 - PostgreSQL TCP ports are closed 702s ok 73 - Next free port is 5432 702s ### End test 080_start.conf.t ### 702s 702s ### PostgreSQL test 085_pg_ctl.conf.t ### 702s 1..33 702s ok 1 - prlimit --core=0:unlimited --pid=14860 702s ok 2 - set core file size to unlimited 702s ok 3 - sh -c 'ulimit -Hc' 702s ok 4 - core file size is unlimited 703s ok 5 - pg_createcluster 17 main 703s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 706s ok 7 - pg_ctlcluster 17 main start 706s ok 8 - starting cluster as root 706s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 706s ok 10 - soft core size is 0 706s # hard core file size limit of root-started postgres process is unlimited 706s ok 11 - set pg_ctl default option to -c 708s ok 12 - pg_ctlcluster 17 main restart 708s ok 13 - restarting cluster as root 708s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 708s ok 15 - soft core size is unlimited 708s ok 16 - pg_ctlcluster 17 main stop 708s ok 17 - stopping cluster 708s ok 18 - restored pg_ctl default option 710s ok 19 - pg_ctlcluster 17 main start -- -c 710s ok 20 - starting cluster with -c on the command line as postgres 710s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 710s ok 22 - soft core size is unlimited 711s ok 23 - pg_ctlcluster 17 main stop 711s ok 24 - stopping cluster 712s ok 25 - dropping cluster 712s # Cleanup 712s ok 26 - Cleanup: No clusters left behind 712s ok 27 - No postgres processes left behind 712s ok 28 - No files in /etc/postgresql left behind 712s ok 29 - No files in /var/lib/postgresql left behind 712s ok 30 - No files in /var/run/postgresql left behind 712s ok 31 - No files in /var/log/postgresql left behind 712s ok 32 - PostgreSQL TCP ports are closed 712s ok 33 - Next free port is 5432 712s ### End test 085_pg_ctl.conf.t ### 712s 712s ### PostgreSQL test 090_multicluster.t ### 712s 1..125 713s ok 1 - pg_createcluster 17 old 715s ok 2 - pg_createcluster 17 new1 716s ok 3 - pg_createcluster 17 new2 718s ok 4 - starting cluster 17/old 720s ok 5 - starting cluster 17/new1 723s ok 6 - starting cluster 17/new2 723s ok 7 - pg_lsclusters -h | sort -k3 723s ok 8 - clusters have the correct ports, skipping used 5433 723s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 723s ok 10 - createdb --version 723s ok 11 - pg_wrapper selects port 5432 as default cluster 723s ok 12 - createdb --cluster 17/new1 --version 723s ok 13 - pg_wrapper --cluster works 723s ok 14 - createdb --cluster 17/foo --version 723s ok 15 - pg_wrapper --cluster errors out for invalid cluster 723s ok 16 - createdb --cluster 17/new1 test 723s ok 17 - correct output of createdb --cluster 17/new1 test 723s ok 18 - psql -Atl --cluster 17/new1 723s ok 19 - test db appears in cluster new1 723s ok 20 - psql -Atl --cluster 17/new2 723s ok 21 - test db does not appear in cluster new2 723s ok 22 - psql -Atl 723s ok 23 - test db does not appear in default cluster 723s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 723s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 723s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 723s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 723s ok 28 - psql -Atl --cluster 17/localhost:5434 723s ok 29 - test db appears in cluster 17/localhost:5434 723s ok 30 - psql -Atl --cluster 17/localhost:5440 723s ok 31 - test db does not appear in cluster 17/localhost:5440 723s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 723s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 723s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 723s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 723s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 723s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 723s ok 38 - psql -Atl --cluster 6.4/localhost: 723s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 723s ok 40 - psql -Atl 723s ok 41 - PGCLUSTER selection (1) 723s ok 42 - psql -Atl 723s ok 43 - PGCLUSTER selection (2) 723s ok 44 - psql -l 723s ok 45 - invalid PGCLUSTER value 723s ok 46 - createdb --version 723s ok 47 - PGCLUSTER network cluster selection (1) 723s ok 48 - psql -Atl 723s ok 49 - PGCLUSTER network cluster selection (2) 723s ok 50 - psql -Atl 723s ok 51 - PGCLUSTER network cluster selection (3) 723s ok 52 - LC_MESSAGES=C psql -Atl 723s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 724s ok 54 - psql -Atc "show port" template1 724s ok 55 - PGPORT selection (1) 724s ok 56 - psql -Atc "show port" template1 724s ok 57 - PGPORT selection (2) 724s ok 58 - createdb --version 724s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 724s ok 60 - psql -Atc "show port" template1 724s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 724s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 724s ok 63 - PGDATABASE environment variable works 724s ok 64 - createdb --version 724s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 724s ok 66 - createdb --cluster 17/new1 --version 724s ok 67 - pg_wrapper --cluster works with empty user_clusters 724s ok 68 - createdb --version 724s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 724s ok 70 - psql -Atc "select current_database()" 724s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 724s ok 72 - psql -Atc 'select current_database()' 724s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 724s ok 74 - createdb --version 724s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 724s ok 76 - createdb --version 724s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 724s ok 78 - createdb --version 724s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 724s ok 80 - createdb --version 724s ok 81 - pg_wrapper selects correct version with per-user user_clusters 724s ok 82 - createdb --version 724s ok 83 - pg_wrapper selects correct version with per-user user_clusters 724s ok 84 - createdb --version 724s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 724s ok 86 - psql -Atl 724s ok 87 - $PGHOST overrides user_clusters 724s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 724s ok 89 - --cluster overrides $PGHOST 724s ok 90 - createdb --version 724s ok 91 - pg_wrapper ignores invalid lines in user_clusters 724s ok 92 - psql -Atc 'select current_database()' 724s ok 93 - pg_service conf selection 1 724s ok 94 - psql -Atc 'select current_database()' 724s ok 95 - pg_service conf selection 2 724s ok 96 - psql -Atc 'select current_database()' 724s ok 97 - pg_service conf selection 3 725s ok 98 - stopping cluster 17/old 727s ok 99 - restarting cluster 17/old 727s ok 100 - pg_lsclusters -h | sort -k3 727s ok 101 - port of first cluster was successfully changed 727s ok 102 - psql -l 727s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 727s ok 104 - psql -Atl --cluster 17/new1 727s ok 105 - --cluster selects appropriate cluster 727s ok 106 - psql -Atl -p 5434 727s ok 107 - -p selects appropriate cluster 727s ok 108 - psql -Atlp 5434 727s ok 109 - -Atlp selects appropriate cluster 727s ok 110 - psql -Atl --port 5434 727s ok 111 - --port selects appropriate cluster 727s ok 112 - env PGPORT=5434 psql -Atl 727s ok 113 - $PGPORT selects appropriate cluster 727s ok 114 - Restoring original /etc/postgresql-common/user_clusters 729s ok 115 - dropping 17/new1 731s ok 116 - dropping 17/new2 732s ok 117 - dropping 17/old 732s # Cleanup 732s ok 118 - Cleanup: No clusters left behind 732s ok 119 - No postgres processes left behind 732s ok 120 - No files in /etc/postgresql left behind 732s ok 121 - No files in /var/lib/postgresql left behind 732s ok 122 - No files in /var/run/postgresql left behind 732s ok 123 - No files in /var/log/postgresql left behind 732s ok 124 - PostgreSQL TCP ports are closed 732s ok 125 - Next free port is 5432 732s ### End test 090_multicluster.t ### 732s 732s ### PostgreSQL test 110_integrate_cluster.t ### 732s 1..32 734s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/EQFz34Wwc0/c/postgres 734s ok 2 - creating raw initdb cluster for user postgres 735s ok 3 - pg_createcluster 17 postgres -d /tmp/EQFz34Wwc0/c/postgres 735s ok 4 - integrating postgres cluster 735s ok 5 - pg_lsclusters 735s ok 6 - correct pg_lsclusters output 737s ok 7 - pg_ctlcluster 17 postgres start 737s ok 8 - starting cluster postgres 737s ok 9 - pg_lsclusters 737s ok 10 - correct pg_lsclusters output 739s ok 11 - dropping cluster postgres 739s ok 12 - No files in temporary cluster dir left behind 741s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/EQFz34Wwc0/c/nobody 741s ok 14 - creating raw initdb cluster for user nobody 741s ok 15 - pg_createcluster 17 nobody -d /tmp/EQFz34Wwc0/c/nobody 741s ok 16 - integrating nobody cluster 741s ok 17 - pg_lsclusters 741s ok 18 - correct pg_lsclusters output 744s ok 19 - pg_ctlcluster 17 nobody start 744s ok 20 - starting cluster nobody 744s ok 21 - pg_lsclusters 744s ok 22 - correct pg_lsclusters output 745s ok 23 - dropping cluster nobody 745s ok 24 - No files in temporary cluster dir left behind 745s # Cleanup 745s ok 25 - Cleanup: No clusters left behind 745s ok 26 - No postgres processes left behind 745s ok 27 - No files in /etc/postgresql left behind 745s ok 28 - No files in /var/lib/postgresql left behind 745s ok 29 - No files in /var/run/postgresql left behind 745s ok 30 - No files in /var/log/postgresql left behind 745s ok 31 - PostgreSQL TCP ports are closed 745s ok 32 - Next free port is 5432 745s ### End test 110_integrate_cluster.t ### 745s 745s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 745s 1..1 745s ok 1 - only one major version installed, skipping upgrade tests 745s ### End test 120_pg_upgradecluster_scripts.t ### 745s 745s ### PostgreSQL test 130_nonroot_admin.t ### 745s 1..22 749s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 749s ok 2 - pg_lsclusters -h 749s ok 3 - correct output of pg_lsclusters -h 749s ok 4 - psql -Atl 749s ok 5 - correct output of psql -Atl 749s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 749s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 749s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 749s # Cleanup 749s ok 15 - Cleanup: No clusters left behind 749s ok 16 - No postgres processes left behind 749s ok 17 - No files in /etc/postgresql left behind 749s ok 18 - No files in /var/lib/postgresql left behind 749s ok 19 - No files in /var/run/postgresql left behind 749s ok 20 - No files in /var/log/postgresql left behind 749s ok 21 - PostgreSQL TCP ports are closed 749s ok 22 - Next free port is 5432 749s ### End test 130_nonroot_admin.t ### 749s 749s ### PostgreSQL test 135_pg_virtualenv.t ### 749s 1..20 754s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 754s ok 2 - running pg_virtualenv as root 757s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 757s ok 4 - running pg_virtualenv as postgres 761s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 761s ok 6 - running pg_virtualenv as nobody 764s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 764s ok 8 - running fakeroot pg_virtualenv as root 767s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 767s ok 10 - running fakeroot pg_virtualenv as postgres 771s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 771s ok 12 - running fakeroot pg_virtualenv as nobody 771s # Cleanup 771s ok 13 - Cleanup: No clusters left behind 771s ok 14 - No postgres processes left behind 771s ok 15 - No files in /etc/postgresql left behind 771s ok 16 - No files in /var/lib/postgresql left behind 771s ok 17 - No files in /var/run/postgresql left behind 771s ok 18 - No files in /var/log/postgresql left behind 771s ok 19 - PostgreSQL TCP ports are closed 771s ok 20 - Next free port is 5432 771s ### End test 135_pg_virtualenv.t ### 771s 771s ### PostgreSQL test 140_pg_config.t ### 771s 1..38 771s # Multiarch is enabled 771s # checking version specific output for 17 771s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 771s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 771s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 771s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 771s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 771s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 771s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 771s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 771s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 771s # checking pg_config output (should behave like version 17) 771s ok 15 - pg_config 771s ok 16 - correct output of pg_config 771s ok 17 - pg_config --help 771s ok 18 - correct output of pg_config --help 771s ok 19 - pg_config --pgxs 771s ok 20 - correct output of pg_config --pgxs 771s ok 21 - pg_config --libdir 771s ok 22 - correct output of pg_config --libdir 771s ok 23 - pg_config --pkglibdir 771s ok 24 - correct output of pg_config --pkglibdir 771s ok 25 - pg_config --bindir 771s ok 26 - correct output of pg_config --bindir 771s # checking pg_config.libpq-dev output (should behave like version 17) 771s ok 27 - pg_config.libpq-dev 771s ok 28 - correct output of pg_config.libpq-dev 771s ok 29 - pg_config.libpq-dev --help 771s ok 30 - correct output of pg_config.libpq-dev --help 771s ok 31 - pg_config.libpq-dev --pgxs 771s ok 32 - correct output of pg_config.libpq-dev --pgxs 771s ok 33 - pg_config.libpq-dev --libdir 771s ok 34 - correct output of pg_config.libpq-dev --libdir 771s ok 35 - pg_config.libpq-dev --pkglibdir 771s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 771s ok 37 - pg_config.libpq-dev --bindir 771s ok 38 - correct output of pg_config.libpq-dev --bindir 771s ### End test 140_pg_config.t ### 771s 771s ### PostgreSQL test 150_tsearch_stemming.t ### 771s 1..37 771s ok 1 - pg_updatedicts succeeded 771s ok 2 - pg_updatedicts created en_us.affix 771s ok 3 - pg_updatedicts created en_us.dict 771s ok 4 - pg_updatedicts created 17 en_us.affix symlink 771s ok 5 - pg_updatedicts created 17 en_us.dict symlink 775s ok 6 - pg_createcluster 17 main 775s ok 7 - createdb fts 775s ok 8 - correct output of createdb fts 775s ok 9 - creating en_US full text search configuration 775s ok 10 - creating data table and search index 775s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 775s ok 12 - stem search of correct word 776s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 776s ok 14 - stem search of correct word 776s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 776s ok 16 - stem search of unknown word 776s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 776s ok 18 - full text search, exact word 776s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 776s ok 20 - full text search for word stem 776s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 776s ok 22 - full text search for word substring fails 776s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 776s ok 24 - full text search, exact unicode word 776s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 776s ok 26 - full text search for unicode word stem 776s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 776s ok 28 - full text search for unicode word substring fails 778s ok 29 778s # Cleanup 778s ok 30 - Cleanup: No clusters left behind 778s ok 31 - No postgres processes left behind 778s ok 32 - No files in /etc/postgresql left behind 778s ok 33 - No files in /var/lib/postgresql left behind 778s ok 34 - No files in /var/run/postgresql left behind 778s ok 35 - No files in /var/log/postgresql left behind 778s ok 36 - PostgreSQL TCP ports are closed 778s ok 37 - Next free port is 5432 778s ### End test 150_tsearch_stemming.t ### 778s 778s ### PostgreSQL test 160_alternate_confroot.t ### 778s 1..28 782s ok 1 782s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 782s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 782s ok 4 - pg_lsclusters -h 782s ok 5 - correct output of pg_lsclusters -h 782s ok 6 - psql -Atl 782s ok 7 - correct output of psql -Atl 782s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 782s ok 9 - ... 782s ok 10 - ... 782s ok 11 - ... 782s ok 12 - ... 782s ok 13 - ... 782s ok 14 - ... 783s ok 15 - pg_dropcluster 17 test --stop 783s ok 16 - correct output of pg_dropcluster 17 test --stop 783s ok 17 - pg_lsclusters -h 783s ok 18 - correct output of pg_lsclusters -h 783s ok 19 - No files in root/data left behind 783s ok 20 - No cruft in root dir left behind 783s # Cleanup 783s ok 21 - Cleanup: No clusters left behind 783s ok 22 - No postgres processes left behind 783s ok 23 - No files in /etc/postgresql left behind 783s ok 24 - No files in /var/lib/postgresql left behind 783s ok 25 - No files in /var/run/postgresql left behind 783s ok 26 - No files in /var/log/postgresql left behind 783s ok 27 - PostgreSQL TCP ports are closed 783s ok 28 - Next free port is 5432 783s ### End test 160_alternate_confroot.t ### 783s 783s ### PostgreSQL test 170_extensions.t ### 783s # Running tests for 17 786s ok 1 - pg_createcluster 17 main 786s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 786s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 786s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 786s ok 5 - extension amcheck installs without error 786s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 786s ok 7 - extension amcheck removes without error 786s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 786s ok 9 - extension autoinc installs without error 786s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 786s ok 11 - extension autoinc removes without error 786s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 786s ok 13 - extension bloom installs without error 786s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 786s ok 15 - extension bloom removes without error 787s ok 16 - psql -qc 'CREATE EXTENSION plperl' 787s ok 17 - bool_plperl dependency plperl installs without error 787s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 787s ok 19 - extension bool_plperl installs without error 787s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 787s ok 21 - extension bool_plperl removes without error 787s ok 22 - psql -qc 'DROP EXTENSION plperl' 787s ok 23 - bool_plperl dependency extension plperl removes without error 787s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 787s ok 25 - bool_plperlu dependency plperlu installs without error 787s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 787s ok 27 - extension bool_plperlu installs without error 787s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 787s ok 29 - extension bool_plperlu removes without error 787s ok 30 - psql -qc 'DROP EXTENSION plperlu' 787s ok 31 - bool_plperlu dependency extension plperlu removes without error 787s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 787s ok 33 - extension btree_gin installs without error 787s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 787s ok 35 - extension btree_gin removes without error 787s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 787s ok 37 - extension btree_gist installs without error 787s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 787s ok 39 - extension btree_gist removes without error 787s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 787s ok 41 - extension citext installs without error 787s ok 42 - psql -qc 'DROP EXTENSION "citext"' 787s ok 43 - extension citext removes without error 787s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 787s ok 45 - extension cube installs without error 788s ok 46 - psql -qc 'DROP EXTENSION "cube"' 788s ok 47 - extension cube removes without error 788s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 788s ok 49 - extension dblink installs without error 788s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 788s ok 51 - extension dblink removes without error 788s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 788s ok 53 - extension dict_int installs without error 788s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 788s ok 55 - extension dict_int removes without error 788s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 788s ok 57 - extension dict_xsyn installs without error 788s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 788s ok 59 - extension dict_xsyn removes without error 788s ok 60 - psql -qc 'CREATE EXTENSION cube' 788s ok 61 - earthdistance dependency cube installs without error 788s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 788s ok 63 - extension earthdistance installs without error 788s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 788s ok 65 - extension earthdistance removes without error 788s ok 66 - psql -qc 'DROP EXTENSION cube' 788s ok 67 - earthdistance dependency extension cube removes without error 788s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 788s ok 69 - extension file_fdw installs without error 788s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 788s ok 71 - extension file_fdw removes without error 788s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 788s ok 73 - extension fuzzystrmatch installs without error 788s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 788s ok 75 - extension fuzzystrmatch removes without error 788s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 788s ok 77 - extension hstore installs without error 788s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 788s ok 79 - extension hstore removes without error 788s ok 80 - psql -qc 'CREATE EXTENSION hstore' 788s ok 81 - hstore_plperl dependency hstore installs without error 788s ok 82 - psql -qc 'CREATE EXTENSION plperl' 788s ok 83 - hstore_plperl dependency plperl installs without error 788s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 788s ok 85 - extension hstore_plperl installs without error 789s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 789s ok 87 - extension hstore_plperl removes without error 789s ok 88 - psql -qc 'DROP EXTENSION hstore' 789s ok 89 - hstore_plperl dependency extension hstore removes without error 789s ok 90 - psql -qc 'DROP EXTENSION plperl' 789s ok 91 - hstore_plperl dependency extension plperl removes without error 789s ok 92 - psql -qc 'CREATE EXTENSION hstore' 789s ok 93 - hstore_plperlu dependency hstore installs without error 789s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 789s ok 95 - hstore_plperlu dependency plperlu installs without error 789s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 789s ok 97 - extension hstore_plperlu installs without error 789s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 789s ok 99 - extension hstore_plperlu removes without error 789s ok 100 - psql -qc 'DROP EXTENSION hstore' 789s ok 101 - hstore_plperlu dependency extension hstore removes without error 789s ok 102 - psql -qc 'DROP EXTENSION plperlu' 789s ok 103 - hstore_plperlu dependency extension plperlu removes without error 789s ok 104 - psql -qc 'CREATE EXTENSION hstore' 789s ok 105 - hstore_plpython3u dependency hstore installs without error 789s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 789s ok 107 - hstore_plpython3u dependency plpython3u installs without error 789s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 789s ok 109 - extension hstore_plpython3u installs without error 789s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 789s ok 111 - extension hstore_plpython3u removes without error 789s ok 112 - psql -qc 'DROP EXTENSION hstore' 789s ok 113 - hstore_plpython3u dependency extension hstore removes without error 789s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 789s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 789s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 789s ok 117 - extension insert_username installs without error 790s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 790s ok 119 - extension insert_username removes without error 790s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 790s ok 121 - extension intagg installs without error 790s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 790s ok 123 - extension intagg removes without error 790s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 790s ok 125 - extension intarray installs without error 790s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 790s ok 127 - extension intarray removes without error 790s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 790s ok 129 - extension isn installs without error 790s ok 130 - psql -qc 'DROP EXTENSION "isn"' 790s ok 131 - extension isn removes without error 790s ok 132 - psql -qc 'CREATE EXTENSION plperl' 790s ok 133 - jsonb_plperl dependency plperl installs without error 790s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 790s ok 135 - extension jsonb_plperl installs without error 790s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 790s ok 137 - extension jsonb_plperl removes without error 790s ok 138 - psql -qc 'DROP EXTENSION plperl' 790s ok 139 - jsonb_plperl dependency extension plperl removes without error 790s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 790s ok 141 - jsonb_plperlu dependency plperlu installs without error 790s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 790s ok 143 - extension jsonb_plperlu installs without error 790s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 790s ok 145 - extension jsonb_plperlu removes without error 791s ok 146 - psql -qc 'DROP EXTENSION plperlu' 791s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 791s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 791s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 791s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 791s ok 151 - extension jsonb_plpython3u installs without error 791s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 791s ok 153 - extension jsonb_plpython3u removes without error 791s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 791s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 791s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 791s ok 157 - extension lo installs without error 791s ok 158 - psql -qc 'DROP EXTENSION "lo"' 791s ok 159 - extension lo removes without error 791s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 791s ok 161 - extension ltree installs without error 791s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 791s ok 163 - extension ltree removes without error 791s ok 164 - psql -qc 'CREATE EXTENSION ltree' 791s ok 165 - ltree_plpython3u dependency ltree installs without error 791s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 791s ok 167 - ltree_plpython3u dependency plpython3u installs without error 791s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 791s ok 169 - extension ltree_plpython3u installs without error 791s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 791s ok 171 - extension ltree_plpython3u removes without error 791s ok 172 - psql -qc 'DROP EXTENSION ltree' 791s ok 173 - ltree_plpython3u dependency extension ltree removes without error 791s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 791s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 791s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 791s ok 177 - extension moddatetime installs without error 792s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 792s ok 179 - extension moddatetime removes without error 792s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 792s ok 181 - extension pageinspect installs without error 792s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 792s ok 183 - extension pageinspect removes without error 792s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 792s ok 185 - extension pg_buffercache installs without error 792s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 792s ok 187 - extension pg_buffercache removes without error 792s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 792s ok 189 - extension pg_freespacemap installs without error 792s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 792s ok 191 - extension pg_freespacemap removes without error 792s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 792s ok 193 - extension pg_prewarm installs without error 792s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 792s ok 195 - extension pg_prewarm removes without error 792s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 792s ok 197 - extension pg_stat_statements installs without error 792s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 792s ok 199 - extension pg_stat_statements removes without error 792s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 792s ok 201 - extension pg_surgery installs without error 792s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 792s ok 203 - extension pg_surgery removes without error 792s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 792s ok 205 - extension pg_trgm installs without error 792s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 792s ok 207 - extension pg_trgm removes without error 792s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 792s ok 209 - extension pg_visibility installs without error 792s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 792s ok 211 - extension pg_visibility removes without error 792s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 792s ok 213 - extension pg_walinspect installs without error 792s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 792s ok 215 - extension pg_walinspect removes without error 793s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 793s ok 217 - extension pgcrypto installs without error 793s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 793s ok 219 - extension pgcrypto removes without error 793s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 793s ok 221 - extension pgrowlocks installs without error 793s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 793s ok 223 - extension pgrowlocks removes without error 793s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 793s ok 225 - extension pgstattuple installs without error 793s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 793s ok 227 - extension pgstattuple removes without error 793s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 793s ok 229 - extension plperl installs without error 793s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 793s ok 231 - extension plperl removes without error 793s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 793s ok 233 - extension plperlu installs without error 793s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 793s ok 235 - extension plperlu removes without error 793s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 793s ok 237 - extension plpython3u installs without error 793s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 793s ok 239 - extension plpython3u removes without error 793s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 793s ok 241 - extension pltcl installs without error 793s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 793s ok 243 - extension pltcl removes without error 793s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 793s ok 245 - extension pltclu installs without error 793s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 793s ok 247 - extension pltclu removes without error 793s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 793s ok 249 - extension postgres_fdw installs without error 793s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 793s ok 251 - extension postgres_fdw removes without error 794s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 794s ok 253 - extension refint installs without error 794s ok 254 - psql -qc 'DROP EXTENSION "refint"' 794s ok 255 - extension refint removes without error 794s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 794s ok 257 - extension seg installs without error 794s ok 258 - psql -qc 'DROP EXTENSION "seg"' 794s ok 259 - extension seg removes without error 794s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 794s ok 261 - extension sslinfo installs without error 794s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 794s ok 263 - extension sslinfo removes without error 794s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 794s ok 265 - extension tablefunc installs without error 794s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 794s ok 267 - extension tablefunc removes without error 794s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 794s ok 269 - extension tcn installs without error 794s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 794s ok 271 - extension tcn removes without error 794s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 794s ok 273 - extension tsm_system_rows installs without error 794s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 794s ok 275 - extension tsm_system_rows removes without error 794s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 794s ok 277 - extension tsm_system_time installs without error 794s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 794s ok 279 - extension tsm_system_time removes without error 794s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 794s ok 281 - extension unaccent installs without error 794s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 794s ok 283 - extension unaccent removes without error 794s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 794s ok 285 - extension uuid-ossp installs without error 794s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 794s ok 287 - extension uuid-ossp removes without error 794s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 794s ok 289 - extension xml2 installs without error 795s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 795s ok 291 - extension xml2 removes without error 796s ok 292 - pg_dropcluster 17 main 796s # Cleanup 796s ok 293 - Cleanup: No clusters left behind 796s ok 294 - No postgres processes left behind 796s ok 295 - No files in /etc/postgresql left behind 796s ok 296 - No files in /var/lib/postgresql left behind 796s ok 297 - No files in /var/run/postgresql left behind 796s ok 298 - No files in /var/log/postgresql left behind 796s ok 299 - PostgreSQL TCP ports are closed 796s ok 300 - Next free port is 5432 796s 1..300 796s ### End test 170_extensions.t ### 796s 796s ### PostgreSQL test 180_ecpg.t ### 796s 1..14 796s ok 1 - ecpg test.pgc 796s ok 2 - ecpg processing 797s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 797s ok 4 - compiling ecpg output 804s ok 5 - pg_virtualenv /tmp/tmp.AjZKNgCNPj/test 804s ok 6 - test program runs and gives correct output 804s # Cleanup 804s ok 7 - Cleanup: No clusters left behind 804s ok 8 - No postgres processes left behind 804s ok 9 - No files in /etc/postgresql left behind 804s ok 10 - No files in /var/lib/postgresql left behind 804s ok 11 - No files in /var/run/postgresql left behind 804s ok 12 - No files in /var/log/postgresql left behind 805s ok 13 - PostgreSQL TCP ports are closed 805s ok 14 - Next free port is 5432 805s ### End test 180_ecpg.t ### 805s 805s ### PostgreSQL test 190_pg_buildext.t ### 805s ok 1 - make clean 805s ok 2 - make tar 805s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 805s # testing 'dh --with pgxs' 809s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 809s ok 5 - postgresql-17-foo_123-1_armhf.deb was built 817s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 817s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 817s ok 8 - dpkg -i postgresql-17-foo_123-1_armhf.deb 825s ok 9 - cd foo-123 && pg_buildext installcheck 825s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 833s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 833s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 840s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 840s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 840s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 840s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 840s ok 17 - dpkg -r postgresql-17-foo 840s # testing 'dh --with pgxs_loop' 840s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 844s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 844s ok 20 - postgresql-17-foo_123-1_armhf.deb was built 844s ok 21 - make clean 844s # testing pg_buildext updatecontrol 844s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 844s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 844s 1..23 844s ### End test 190_pg_buildext.t ### 844s 844s ### PostgreSQL test 200_maintscripts.t ### 844s 1..15 844s # We are running systemd 847s ok 1 - pg_createcluster 17 main --start 847s ok 2 - postmaster PID is 20933 849s ok 3 - apt-get update -q 849s # postgresql-common: 849s # Installed: 273 849s # Candidate: 273 849s # Version table: 849s # *** 273 500 849s # 500 http://ftpmaster.internal/ubuntu plucky/main armhf Packages 849s # 100 /var/lib/dpkg/status 854s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 854s # postgresql-common: 854s # Installed: 273 854s # Candidate: 273 854s # Version table: 854s # *** 273 500 854s # 500 http://ftpmaster.internal/ubuntu plucky/main armhf Packages 854s # 100 /var/lib/dpkg/status 854s ok 5 - postmaster PID is 20933 854s ok 6 - postmaster was not restarted 856s ok 7 - pg_dropcluster 17 main --stop 856s # Cleanup 856s ok 8 - Cleanup: No clusters left behind 856s ok 9 - No postgres processes left behind 856s ok 10 - No files in /etc/postgresql left behind 856s ok 11 - No files in /var/lib/postgresql left behind 856s ok 12 - No files in /var/run/postgresql left behind 856s ok 13 - No files in /var/log/postgresql left behind 856s ok 14 - PostgreSQL TCP ports are closed 856s ok 15 - Next free port is 5432 856s ### End test 200_maintscripts.t ### 856s 859s autopkgtest [14:04:34]: test run-testsuite: -----------------------] 864s autopkgtest [14:04:41]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 864s run-testsuite PASS 869s autopkgtest [14:04:46]: @@@@@@@@@@@@@@@@@@@@ summary 869s default-psql PASS 869s run-testsuite PASS