0s autopkgtest [03:38:33]: starting date and time: 2025-06-19 03:38:33+0000 0s autopkgtest [03:38:33]: git checkout: 9986aa8c Merge branch 'skia/fix_network_interface' into 'ubuntu/production' 0s autopkgtest [03:38:33]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.px3p3345/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:procps --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=procps/2:4.0.4-8ubuntu1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-4.secgroup --name adt-questing-amd64-postgresql-common-20250619-033832-juju-7f2275-prod-proposed-migration-environment-2-a0ea3f77-3e0b-4021-bc09-69e58654de2d --image adt/ubuntu-questing-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux --mirror=http://ftpmaster.internal/ubuntu/ 55s autopkgtest [03:39:28]: testbed dpkg architecture: amd64 55s autopkgtest [03:39:28]: testbed apt version: 3.1.2 55s autopkgtest [03:39:28]: @@@@@@@@@@@@@@@@@@@@ test bed setup 56s autopkgtest [03:39:29]: testbed release detected to be: None 56s autopkgtest [03:39:29]: updating testbed package index (apt update) 57s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 57s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 57s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 57s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 57s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 57s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [407 kB] 57s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 57s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 57s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [45.1 kB] 57s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [81.6 kB] 57s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/restricted i386 Packages [2420 B] 57s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 Packages [13.3 kB] 57s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [136 kB] 57s Get:14 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [374 kB] 58s Get:15 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [24.7 kB] 58s Get:16 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [5028 B] 58s Fetched 1396 kB in 1s (1333 kB/s) 59s Reading package lists... 59s autopkgtest [03:39:32]: upgrading testbed (apt dist-upgrade and autopurge) 59s Reading package lists... 60s Building dependency tree... 60s Reading state information... 60s Calculating upgrade... 60s The following packages will be upgraded: 60s libproc2-0 procps 60s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 60s Need to get 768 kB of archives. 60s After this operation, 36.9 kB disk space will be freed. 60s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 libproc2-0 amd64 2:4.0.4-8ubuntu1 [58.9 kB] 60s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 procps amd64 2:4.0.4-8ubuntu1 [709 kB] 61s Fetched 768 kB in 1s (1209 kB/s) 61s (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 ... 81475 files and directories currently installed.) 61s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_amd64.deb ... 61s Unpacking libproc2-0:amd64 (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 61s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_amd64.deb ... 62s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 62s Setting up libproc2-0:amd64 (2:4.0.4-8ubuntu1) ... 62s Setting up procps (2:4.0.4-8ubuntu1) ... 62s Processing triggers for systemd (257.6-1ubuntu1) ... 62s Processing triggers for man-db (2.13.1-1) ... 63s Processing triggers for libc-bin (2.41-6ubuntu2) ... 64s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s Solving dependencies... 64s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 64s autopkgtest [03:39:37]: rebooting testbed after setup commands that affected boot 87s autopkgtest [03:40:00]: testbed running kernel: Linux 6.14.0-15-generic #15-Ubuntu SMP PREEMPT_DYNAMIC Sun Apr 6 15:05:05 UTC 2025 91s autopkgtest [03:40:03]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 96s Get:1 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (dsc) [2385 B] 96s Get:2 http://ftpmaster.internal/ubuntu questing/main postgresql-common 279 (tar) [218 kB] 96s gpgv: Signature made Thu Jun 12 19:04:12 2025 UTC 96s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 96s gpgv: Can't check signature: No public key 96s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_279.dsc: no acceptable signature found 96s autopkgtest [03:40:09]: testing package postgresql-common version 279 97s autopkgtest [03:40:10]: build not needed 97s autopkgtest [03:40:10]: test default-psql: preparing testbed 97s Reading package lists... 97s Building dependency tree... 97s Reading state information... 97s Solving dependencies... 98s The following NEW packages will be installed: 98s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql 98s postgresql-17 postgresql-client-17 postgresql-client-common 98s postgresql-common postgresql-common-dev ssl-cert 98s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 98s Need to get 20.9 MB of archives. 98s After this operation, 72.4 MB of additional disk space will be used. 98s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 98s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-common all 279 [48.1 kB] 98s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 98s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 98s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common-dev all 279 [73.6 kB] 98s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 98s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common all 279 [101 kB] 98s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.5-1build1 [253 kB] 98s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.43-0exp1 [163 kB] 98s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.5-1build1 [2129 kB] 99s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.5-1build1 [17.9 MB] 101s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql all 17+279 [16.6 kB] 101s Preconfiguring packages ... 101s /var/cache/debconf/tmp.ci/postgresql.config.OqBYuM: 12: pg_lsclusters: not found 101s Fetched 20.9 MB in 4s (5885 kB/s) 101s Selecting previously unselected package libjson-perl. 102s (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 ... 81475 files and directories currently installed.) 102s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 102s Unpacking libjson-perl (4.10000-1) ... 102s Selecting previously unselected package postgresql-client-common. 102s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 102s Unpacking postgresql-client-common (279) ... 102s Selecting previously unselected package libio-pty-perl. 102s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 102s Unpacking libio-pty-perl (1:1.20-1build3) ... 102s Selecting previously unselected package libipc-run-perl. 102s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 102s Unpacking libipc-run-perl (20231003.0-2) ... 102s Selecting previously unselected package postgresql-common-dev. 102s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 102s Unpacking postgresql-common-dev (279) ... 102s Selecting previously unselected package ssl-cert. 102s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 102s Unpacking ssl-cert (1.1.3ubuntu1) ... 102s Selecting previously unselected package postgresql-common. 102s Preparing to unpack .../06-postgresql-common_279_all.deb ... 102s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 102s Unpacking postgresql-common (279) ... 102s Selecting previously unselected package libpq5:amd64. 102s Preparing to unpack .../07-libpq5_17.5-1build1_amd64.deb ... 102s Unpacking libpq5:amd64 (17.5-1build1) ... 102s Selecting previously unselected package libxslt1.1:amd64. 102s Preparing to unpack .../08-libxslt1.1_1.1.43-0exp1_amd64.deb ... 102s Unpacking libxslt1.1:amd64 (1.1.43-0exp1) ... 102s Selecting previously unselected package postgresql-client-17. 102s Preparing to unpack .../09-postgresql-client-17_17.5-1build1_amd64.deb ... 102s Unpacking postgresql-client-17 (17.5-1build1) ... 102s Selecting previously unselected package postgresql-17. 102s Preparing to unpack .../10-postgresql-17_17.5-1build1_amd64.deb ... 102s Unpacking postgresql-17 (17.5-1build1) ... 102s Selecting previously unselected package postgresql. 102s Preparing to unpack .../11-postgresql_17+279_all.deb ... 102s Unpacking postgresql (17+279) ... 102s Setting up postgresql-client-common (279) ... 102s Setting up libio-pty-perl (1:1.20-1build3) ... 102s Setting up libpq5:amd64 (17.5-1build1) ... 102s Setting up ssl-cert (1.1.3ubuntu1) ... 103s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 103s Setting up libipc-run-perl (20231003.0-2) ... 103s Setting up libjson-perl (4.10000-1) ... 103s Setting up libxslt1.1:amd64 (1.1.43-0exp1) ... 103s Setting up postgresql-common-dev (279) ... 103s Setting up postgresql-client-17 (17.5-1build1) ... 104s 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 104s Setting up postgresql-common (279) ... 104s Creating config file /etc/postgresql-common/createcluster.conf with new version 104s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 104s Removing obsolete dictionary files: 105s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 105s Setting up postgresql-17 (17.5-1build1) ... 106s Creating new PostgreSQL cluster 17/main ... 106s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 106s The files belonging to this database system will be owned by user "postgres". 106s This user must also own the server process. 106s 106s The database cluster will be initialized with locale "C.UTF-8". 106s The default database encoding has accordingly been set to "UTF8". 106s The default text search configuration will be set to "english". 106s 106s Data page checksums are disabled. 106s 106s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 106s creating subdirectories ... ok 106s selecting dynamic shared memory implementation ... posix 106s selecting default "max_connections" ... 100 106s selecting default "shared_buffers" ... 128MB 106s selecting default time zone ... Etc/UTC 106s creating configuration files ... ok 106s running bootstrap script ... ok 106s performing post-bootstrap initialization ... ok 106s syncing data to disk ... ok 109s Setting up postgresql (17+279) ... 110s Processing triggers for man-db (2.13.1-1) ... 111s Processing triggers for libc-bin (2.41-6ubuntu2) ... 112s autopkgtest [03:40:25]: test default-psql: [----------------------- 113s autopkgtest [03:40:26]: test default-psql: -----------------------] 113s autopkgtest [03:40:26]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 113s default-psql PASS 114s autopkgtest [03:40:27]: test run-testsuite: preparing testbed 192s autopkgtest [03:41:45]: testbed dpkg architecture: amd64 192s autopkgtest [03:41:45]: testbed apt version: 3.1.2 192s autopkgtest [03:41:45]: @@@@@@@@@@@@@@@@@@@@ test bed setup 193s autopkgtest [03:41:46]: testbed release detected to be: questing 193s autopkgtest [03:41:46]: updating testbed package index (apt update) 194s Get:1 http://ftpmaster.internal/ubuntu questing-proposed InRelease [249 kB] 194s Hit:2 http://ftpmaster.internal/ubuntu questing InRelease 194s Hit:3 http://ftpmaster.internal/ubuntu questing-updates InRelease 194s Hit:4 http://ftpmaster.internal/ubuntu questing-security InRelease 194s Get:5 http://ftpmaster.internal/ubuntu questing-proposed/multiverse Sources [16.8 kB] 194s Get:6 http://ftpmaster.internal/ubuntu questing-proposed/restricted Sources [4716 B] 194s Get:7 http://ftpmaster.internal/ubuntu questing-proposed/universe Sources [407 kB] 194s Get:8 http://ftpmaster.internal/ubuntu questing-proposed/main Sources [35.8 kB] 194s Get:9 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 Packages [81.6 kB] 194s Get:10 http://ftpmaster.internal/ubuntu questing-proposed/main i386 Packages [45.1 kB] 194s Get:11 http://ftpmaster.internal/ubuntu questing-proposed/restricted i386 Packages [2420 B] 194s Get:12 http://ftpmaster.internal/ubuntu questing-proposed/restricted amd64 Packages [13.3 kB] 194s Get:13 http://ftpmaster.internal/ubuntu questing-proposed/universe i386 Packages [136 kB] 194s Get:14 http://ftpmaster.internal/ubuntu questing-proposed/universe amd64 Packages [374 kB] 194s Get:15 http://ftpmaster.internal/ubuntu questing-proposed/multiverse i386 Packages [5028 B] 194s Get:16 http://ftpmaster.internal/ubuntu questing-proposed/multiverse amd64 Packages [24.7 kB] 194s Fetched 1396 kB in 1s (1676 kB/s) 195s Reading package lists... 196s autopkgtest [03:41:49]: upgrading testbed (apt dist-upgrade and autopurge) 196s Reading package lists... 196s Building dependency tree... 196s Reading state information... 197s Calculating upgrade... 197s The following packages will be upgraded: 197s libproc2-0 procps 197s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 197s Need to get 768 kB of archives. 197s After this operation, 36.9 kB disk space will be freed. 197s Get:1 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 libproc2-0 amd64 2:4.0.4-8ubuntu1 [58.9 kB] 197s Get:2 http://ftpmaster.internal/ubuntu questing-proposed/main amd64 procps amd64 2:4.0.4-8ubuntu1 [709 kB] 198s Fetched 768 kB in 1s (962 kB/s) 198s (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 ... 81475 files and directories currently installed.) 198s Preparing to unpack .../libproc2-0_2%3a4.0.4-8ubuntu1_amd64.deb ... 198s Unpacking libproc2-0:amd64 (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 198s Preparing to unpack .../procps_2%3a4.0.4-8ubuntu1_amd64.deb ... 198s Unpacking procps (2:4.0.4-8ubuntu1) over (2:4.0.4-7ubuntu1) ... 198s Setting up libproc2-0:amd64 (2:4.0.4-8ubuntu1) ... 198s Setting up procps (2:4.0.4-8ubuntu1) ... 199s Processing triggers for systemd (257.6-1ubuntu1) ... 199s Processing triggers for man-db (2.13.1-1) ... 200s Processing triggers for libc-bin (2.41-6ubuntu2) ... 201s Reading package lists... 201s Building dependency tree... 201s Reading state information... 201s Solving dependencies... 201s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 201s autopkgtest [03:41:54]: rebooting testbed after setup commands that affected boot 227s Reading package lists... 227s Building dependency tree... 227s Reading state information... 227s Solving dependencies... 227s The following NEW packages will be installed: 227s autoconf automake autopoint autotools-dev build-essential clang-20 cpp 227s cpp-14 cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 227s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 227s fakeroot g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 227s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 227s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-20-dev 227s libclang1-20 libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 227s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev 227s libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 libitm1 227s libjson-perl liblsan0 liblzma-dev libmpc3 libncurses-dev libobjc-14-dev 227s libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 libquadmath0 libssl-dev 227s libstdc++-14-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 227s llvm-20 llvm-20-dev llvm-20-linker-tools llvm-20-runtime llvm-20-tools 227s locales-all m4 po-debconf postgresql-17 postgresql-all postgresql-client-17 227s postgresql-client-common postgresql-common postgresql-common-dev 227s postgresql-doc postgresql-doc-17 postgresql-plperl-17 227s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 227s postgresql-server-dev-all ssl-cert zlib1g-dev 228s 0 upgraded, 92 newly installed, 0 to remove and 0 not upgraded. 228s Need to get 196 MB of archives. 228s After this operation, 1160 MB of additional disk space will be used. 228s Get:1 http://ftpmaster.internal/ubuntu questing/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 228s Get:2 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-common all 279 [48.1 kB] 228s Get:3 http://ftpmaster.internal/ubuntu questing/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 228s Get:4 http://ftpmaster.internal/ubuntu questing/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 228s Get:5 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common-dev all 279 [73.6 kB] 228s Get:6 http://ftpmaster.internal/ubuntu questing/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 228s Get:7 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-common all 279 [101 kB] 228s Get:8 http://ftpmaster.internal/ubuntu questing/main amd64 m4 amd64 1.4.19-8 [248 kB] 228s Get:9 http://ftpmaster.internal/ubuntu questing/main amd64 autoconf all 2.72-3.1ubuntu1 [384 kB] 228s Get:10 http://ftpmaster.internal/ubuntu questing/main amd64 autotools-dev all 20240727.1 [43.4 kB] 229s Get:11 http://ftpmaster.internal/ubuntu questing/main amd64 automake all 1:1.17-4ubuntu1 [572 kB] 229s Get:12 http://ftpmaster.internal/ubuntu questing/main amd64 autopoint all 0.23.1-2build1 [619 kB] 229s Get:13 http://ftpmaster.internal/ubuntu questing/main amd64 libisl23 amd64 0.27-1 [685 kB] 229s Get:14 http://ftpmaster.internal/ubuntu questing/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 229s Get:15 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14-x86-64-linux-gnu amd64 14.3.0-1ubuntu1 [11.9 MB] 231s Get:16 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-14 amd64 14.3.0-1ubuntu1 [1028 B] 231s Get:17 http://ftpmaster.internal/ubuntu questing/main amd64 cpp-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [5586 B] 231s Get:18 http://ftpmaster.internal/ubuntu questing/main amd64 cpp amd64 4:14.2.0-1ubuntu1 [22.4 kB] 231s Get:19 http://ftpmaster.internal/ubuntu questing/main amd64 libcc1-0 amd64 15.1.0-5ubuntu1 [47.1 kB] 231s Get:20 http://ftpmaster.internal/ubuntu questing/main amd64 libgomp1 amd64 15.1.0-5ubuntu1 [151 kB] 231s Get:21 http://ftpmaster.internal/ubuntu questing/main amd64 libitm1 amd64 15.1.0-5ubuntu1 [29.3 kB] 231s Get:22 http://ftpmaster.internal/ubuntu questing/main amd64 libasan8 amd64 15.1.0-5ubuntu1 [3071 kB] 231s Get:23 http://ftpmaster.internal/ubuntu questing/main amd64 liblsan0 amd64 15.1.0-5ubuntu1 [1360 kB] 231s Get:24 http://ftpmaster.internal/ubuntu questing/main amd64 libtsan2 amd64 15.1.0-5ubuntu1 [2757 kB] 232s Get:25 http://ftpmaster.internal/ubuntu questing/main amd64 libubsan1 amd64 15.1.0-5ubuntu1 [1210 kB] 232s Get:26 http://ftpmaster.internal/ubuntu questing/main amd64 libhwasan0 amd64 15.1.0-5ubuntu1 [1685 kB] 232s Get:27 http://ftpmaster.internal/ubuntu questing/main amd64 libquadmath0 amd64 15.1.0-5ubuntu1 [153 kB] 232s Get:28 http://ftpmaster.internal/ubuntu questing/main amd64 libgcc-14-dev amd64 14.3.0-1ubuntu1 [2815 kB] 232s Get:29 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14-x86-64-linux-gnu amd64 14.3.0-1ubuntu1 [23.3 MB] 233s Get:30 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-14 amd64 14.3.0-1ubuntu1 [549 kB] 233s Get:31 http://ftpmaster.internal/ubuntu questing/main amd64 gcc-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [1208 B] 233s Get:32 http://ftpmaster.internal/ubuntu questing/main amd64 gcc amd64 4:14.2.0-1ubuntu1 [5004 B] 233s Get:33 http://ftpmaster.internal/ubuntu questing/main amd64 libstdc++-14-dev amd64 14.3.0-1ubuntu1 [2820 kB] 233s Get:34 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14-x86-64-linux-gnu amd64 14.3.0-1ubuntu1 [13.4 MB] 233s Get:35 http://ftpmaster.internal/ubuntu questing/main amd64 g++-14 amd64 14.3.0-1ubuntu1 [27.4 kB] 233s Get:36 http://ftpmaster.internal/ubuntu questing/main amd64 g++-x86-64-linux-gnu amd64 4:14.2.0-1ubuntu1 [968 B] 233s Get:37 http://ftpmaster.internal/ubuntu questing/main amd64 g++ amd64 4:14.2.0-1ubuntu1 [1100 B] 233s Get:38 http://ftpmaster.internal/ubuntu questing/main amd64 build-essential amd64 12.12ubuntu1 [5080 B] 233s Get:39 http://ftpmaster.internal/ubuntu questing/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 233s Get:40 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc4 amd64 15.1.0-5ubuntu1 [47.8 kB] 233s Get:41 http://ftpmaster.internal/ubuntu questing/universe amd64 libobjc-14-dev amd64 14.3.0-1ubuntu1 [195 kB] 233s Get:42 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang-common-20-dev amd64 1:20.1.6-0ubuntu1 [778 kB] 233s Get:43 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-linker-tools amd64 1:20.1.6-0ubuntu1 [1334 kB] 233s Get:44 http://ftpmaster.internal/ubuntu questing/universe amd64 libclang1-20 amd64 1:20.1.6-0ubuntu1 [8236 kB] 234s Get:45 http://ftpmaster.internal/ubuntu questing/universe amd64 clang-20 amd64 1:20.1.6-0ubuntu1 [77.7 kB] 234s Get:46 http://ftpmaster.internal/ubuntu questing/main amd64 libdebhelper-perl all 13.24.2ubuntu1 [95.7 kB] 234s Get:47 http://ftpmaster.internal/ubuntu questing/main amd64 libtool all 2.5.4-4 [168 kB] 234s Get:48 http://ftpmaster.internal/ubuntu questing/main amd64 dh-autoreconf all 20 [16.1 kB] 234s Get:49 http://ftpmaster.internal/ubuntu questing/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 234s Get:50 http://ftpmaster.internal/ubuntu questing/main amd64 libfile-stripnondeterminism-perl all 1.14.1-2 [20.3 kB] 234s Get:51 http://ftpmaster.internal/ubuntu questing/main amd64 dh-strip-nondeterminism all 1.14.1-2 [5064 B] 234s Get:52 http://ftpmaster.internal/ubuntu questing/main amd64 debugedit amd64 1:5.1-2 [47.0 kB] 234s Get:53 http://ftpmaster.internal/ubuntu questing/main amd64 dwz amd64 0.15-1build6 [115 kB] 234s Get:54 http://ftpmaster.internal/ubuntu questing/main amd64 gettext amd64 0.23.1-2build1 [1472 kB] 234s Get:55 http://ftpmaster.internal/ubuntu questing/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 234s Get:56 http://ftpmaster.internal/ubuntu questing/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 234s Get:57 http://ftpmaster.internal/ubuntu questing/main amd64 debhelper all 13.24.2ubuntu1 [896 kB] 234s Get:58 http://ftpmaster.internal/ubuntu questing/main amd64 emacsen-common all 3.0.8 [13.9 kB] 234s Get:59 http://ftpmaster.internal/ubuntu questing/main amd64 dictionaries-common all 1.30.10 [178 kB] 234s Get:60 http://ftpmaster.internal/ubuntu questing/main amd64 libfakeroot amd64 1.37.1.2-1 [33.7 kB] 234s Get:61 http://ftpmaster.internal/ubuntu questing/main amd64 fakeroot amd64 1.37.1.2-1 [68.0 kB] 234s Get:62 http://ftpmaster.internal/ubuntu questing/main amd64 hunspell-en-us all 1:2020.12.07-4 [585 kB] 234s Get:63 http://ftpmaster.internal/ubuntu questing/main amd64 libpgtypes3 amd64 17.5-1build1 [45.5 kB] 234s Get:64 http://ftpmaster.internal/ubuntu questing/main amd64 libpq5 amd64 17.5-1build1 [253 kB] 234s Get:65 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg6 amd64 17.5-1build1 [64.1 kB] 234s Get:66 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-compat3 amd64 17.5-1build1 [16.6 kB] 234s Get:67 http://ftpmaster.internal/ubuntu questing/main amd64 libssl-dev amd64 3.5.0-2ubuntu1 [2909 kB] 234s Get:68 http://ftpmaster.internal/ubuntu questing/main amd64 libpq-dev amd64 17.5-1build1 [159 kB] 234s Get:69 http://ftpmaster.internal/ubuntu questing/main amd64 libecpg-dev amd64 17.5-1build1 [328 kB] 234s Get:70 http://ftpmaster.internal/ubuntu questing/main amd64 libncurses-dev amd64 6.5+20250216-2 [424 kB] 234s Get:71 http://ftpmaster.internal/ubuntu questing/main amd64 libtcl8.6 amd64 8.6.16+dfsg-1 [1086 kB] 234s Get:72 http://ftpmaster.internal/ubuntu questing/main amd64 liblzma-dev amd64 5.8.1-1build1 [179 kB] 234s Get:73 http://ftpmaster.internal/ubuntu questing/main amd64 zlib1g-dev amd64 1:1.3.dfsg+really1.3.1-1ubuntu1 [895 kB] 234s Get:74 http://ftpmaster.internal/ubuntu questing/main amd64 libxml2-dev amd64 2.14.3+dfsg-0exp3 [68.6 kB] 234s Get:75 http://ftpmaster.internal/ubuntu questing/main amd64 libxslt1.1 amd64 1.1.43-0exp1 [163 kB] 234s Get:76 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-runtime amd64 1:20.1.6-0ubuntu1 [559 kB] 234s Get:77 http://ftpmaster.internal/ubuntu questing/universe amd64 libpfm4 amd64 4.13.0+git99-gc5587f9-1 [437 kB] 234s Get:78 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20 amd64 1:20.1.6-0ubuntu1 [19.7 MB] 235s Get:79 http://ftpmaster.internal/ubuntu questing/main amd64 libffi-dev amd64 3.4.8-2 [63.2 kB] 235s Get:80 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-tools amd64 1:20.1.6-0ubuntu1 [512 kB] 235s Get:81 http://ftpmaster.internal/ubuntu questing/universe amd64 llvm-20-dev amd64 1:20.1.6-0ubuntu1 [50.3 MB] 236s Get:82 http://ftpmaster.internal/ubuntu questing/universe amd64 locales-all amd64 2.41-6ubuntu2 [11.2 MB] 236s Get:83 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-client-17 amd64 17.5-1build1 [2129 kB] 236s Get:84 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-17 amd64 17.5-1build1 [17.9 MB] 237s Get:85 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-17 amd64 17.5-1build1 [1395 kB] 237s Get:86 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-server-dev-all all 279 [1626 B] 237s Get:87 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plperl-17 amd64 17.5-1build1 [90.2 kB] 237s Get:88 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-plpython3-17 amd64 17.5-1build1 [117 kB] 237s Get:89 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-pltcl-17 amd64 17.5-1build1 [44.6 kB] 237s Get:90 http://ftpmaster.internal/ubuntu questing/universe amd64 postgresql-all all 279 [1706 B] 237s Get:91 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-doc-17 all 17.5-1build1 [2137 kB] 237s Get:92 http://ftpmaster.internal/ubuntu questing/main amd64 postgresql-doc all 17+279 [13.8 kB] 237s Preconfiguring packages ... 238s Fetched 196 MB in 10s (20.4 MB/s) 238s Selecting previously unselected package libjson-perl. 238s (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 ... 81475 files and directories currently installed.) 238s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 238s Unpacking libjson-perl (4.10000-1) ... 238s Selecting previously unselected package postgresql-client-common. 238s Preparing to unpack .../01-postgresql-client-common_279_all.deb ... 238s Unpacking postgresql-client-common (279) ... 238s Selecting previously unselected package libio-pty-perl. 238s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 238s Unpacking libio-pty-perl (1:1.20-1build3) ... 238s Selecting previously unselected package libipc-run-perl. 238s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 238s Unpacking libipc-run-perl (20231003.0-2) ... 238s Selecting previously unselected package postgresql-common-dev. 238s Preparing to unpack .../04-postgresql-common-dev_279_all.deb ... 238s Unpacking postgresql-common-dev (279) ... 238s Selecting previously unselected package ssl-cert. 238s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 238s Unpacking ssl-cert (1.1.3ubuntu1) ... 238s Selecting previously unselected package postgresql-common. 238s Preparing to unpack .../06-postgresql-common_279_all.deb ... 238s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 238s Unpacking postgresql-common (279) ... 238s Selecting previously unselected package m4. 238s Preparing to unpack .../07-m4_1.4.19-8_amd64.deb ... 238s Unpacking m4 (1.4.19-8) ... 238s Selecting previously unselected package autoconf. 238s Preparing to unpack .../08-autoconf_2.72-3.1ubuntu1_all.deb ... 238s Unpacking autoconf (2.72-3.1ubuntu1) ... 238s Selecting previously unselected package autotools-dev. 238s Preparing to unpack .../09-autotools-dev_20240727.1_all.deb ... 238s Unpacking autotools-dev (20240727.1) ... 238s Selecting previously unselected package automake. 238s Preparing to unpack .../10-automake_1%3a1.17-4ubuntu1_all.deb ... 238s Unpacking automake (1:1.17-4ubuntu1) ... 238s Selecting previously unselected package autopoint. 238s Preparing to unpack .../11-autopoint_0.23.1-2build1_all.deb ... 238s Unpacking autopoint (0.23.1-2build1) ... 238s Selecting previously unselected package libisl23:amd64. 238s Preparing to unpack .../12-libisl23_0.27-1_amd64.deb ... 238s Unpacking libisl23:amd64 (0.27-1) ... 238s Selecting previously unselected package libmpc3:amd64. 238s Preparing to unpack .../13-libmpc3_1.3.1-1build2_amd64.deb ... 238s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 238s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 238s Preparing to unpack .../14-cpp-14-x86-64-linux-gnu_14.3.0-1ubuntu1_amd64.deb ... 238s Unpacking cpp-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 238s Selecting previously unselected package cpp-14. 238s Preparing to unpack .../15-cpp-14_14.3.0-1ubuntu1_amd64.deb ... 238s Unpacking cpp-14 (14.3.0-1ubuntu1) ... 238s Selecting previously unselected package cpp-x86-64-linux-gnu. 238s Preparing to unpack .../16-cpp-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 238s Unpacking cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 238s Selecting previously unselected package cpp. 238s Preparing to unpack .../17-cpp_4%3a14.2.0-1ubuntu1_amd64.deb ... 238s Unpacking cpp (4:14.2.0-1ubuntu1) ... 238s Selecting previously unselected package libcc1-0:amd64. 238s Preparing to unpack .../18-libcc1-0_15.1.0-5ubuntu1_amd64.deb ... 238s Unpacking libcc1-0:amd64 (15.1.0-5ubuntu1) ... 238s Selecting previously unselected package libgomp1:amd64. 238s Preparing to unpack .../19-libgomp1_15.1.0-5ubuntu1_amd64.deb ... 238s Unpacking libgomp1:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libitm1:amd64. 239s Preparing to unpack .../20-libitm1_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libitm1:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libasan8:amd64. 239s Preparing to unpack .../21-libasan8_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libasan8:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package liblsan0:amd64. 239s Preparing to unpack .../22-liblsan0_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking liblsan0:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libtsan2:amd64. 239s Preparing to unpack .../23-libtsan2_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libtsan2:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libubsan1:amd64. 239s Preparing to unpack .../24-libubsan1_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libubsan1:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libhwasan0:amd64. 239s Preparing to unpack .../25-libhwasan0_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libhwasan0:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libquadmath0:amd64. 239s Preparing to unpack .../26-libquadmath0_15.1.0-5ubuntu1_amd64.deb ... 239s Unpacking libquadmath0:amd64 (15.1.0-5ubuntu1) ... 239s Selecting previously unselected package libgcc-14-dev:amd64. 239s Preparing to unpack .../27-libgcc-14-dev_14.3.0-1ubuntu1_amd64.deb ... 239s Unpacking libgcc-14-dev:amd64 (14.3.0-1ubuntu1) ... 239s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 239s Preparing to unpack .../28-gcc-14-x86-64-linux-gnu_14.3.0-1ubuntu1_amd64.deb ... 239s Unpacking gcc-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 239s Selecting previously unselected package gcc-14. 239s Preparing to unpack .../29-gcc-14_14.3.0-1ubuntu1_amd64.deb ... 239s Unpacking gcc-14 (14.3.0-1ubuntu1) ... 239s Selecting previously unselected package gcc-x86-64-linux-gnu. 239s Preparing to unpack .../30-gcc-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 239s Unpacking gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 239s Selecting previously unselected package gcc. 239s Preparing to unpack .../31-gcc_4%3a14.2.0-1ubuntu1_amd64.deb ... 239s Unpacking gcc (4:14.2.0-1ubuntu1) ... 239s Selecting previously unselected package libstdc++-14-dev:amd64. 239s Preparing to unpack .../32-libstdc++-14-dev_14.3.0-1ubuntu1_amd64.deb ... 239s Unpacking libstdc++-14-dev:amd64 (14.3.0-1ubuntu1) ... 239s Selecting previously unselected package g++-14-x86-64-linux-gnu. 239s Preparing to unpack .../33-g++-14-x86-64-linux-gnu_14.3.0-1ubuntu1_amd64.deb ... 239s Unpacking g++-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 240s Selecting previously unselected package g++-14. 240s Preparing to unpack .../34-g++-14_14.3.0-1ubuntu1_amd64.deb ... 240s Unpacking g++-14 (14.3.0-1ubuntu1) ... 240s Selecting previously unselected package g++-x86-64-linux-gnu. 240s Preparing to unpack .../35-g++-x86-64-linux-gnu_4%3a14.2.0-1ubuntu1_amd64.deb ... 240s Unpacking g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 240s Selecting previously unselected package g++. 240s Preparing to unpack .../36-g++_4%3a14.2.0-1ubuntu1_amd64.deb ... 240s Unpacking g++ (4:14.2.0-1ubuntu1) ... 240s Selecting previously unselected package build-essential. 240s Preparing to unpack .../37-build-essential_12.12ubuntu1_amd64.deb ... 240s Unpacking build-essential (12.12ubuntu1) ... 240s Selecting previously unselected package libgc1:amd64. 240s Preparing to unpack .../38-libgc1_1%3a8.2.8-1_amd64.deb ... 240s Unpacking libgc1:amd64 (1:8.2.8-1) ... 240s Selecting previously unselected package libobjc4:amd64. 240s Preparing to unpack .../39-libobjc4_15.1.0-5ubuntu1_amd64.deb ... 240s Unpacking libobjc4:amd64 (15.1.0-5ubuntu1) ... 240s Selecting previously unselected package libobjc-14-dev:amd64. 240s Preparing to unpack .../40-libobjc-14-dev_14.3.0-1ubuntu1_amd64.deb ... 240s Unpacking libobjc-14-dev:amd64 (14.3.0-1ubuntu1) ... 240s Selecting previously unselected package libclang-common-20-dev:amd64. 240s Preparing to unpack .../41-libclang-common-20-dev_1%3a20.1.6-0ubuntu1_amd64.deb ... 240s Unpacking libclang-common-20-dev:amd64 (1:20.1.6-0ubuntu1) ... 240s Selecting previously unselected package llvm-20-linker-tools. 240s Preparing to unpack .../42-llvm-20-linker-tools_1%3a20.1.6-0ubuntu1_amd64.deb ... 240s Unpacking llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 240s Selecting previously unselected package libclang1-20. 240s Preparing to unpack .../43-libclang1-20_1%3a20.1.6-0ubuntu1_amd64.deb ... 240s Unpacking libclang1-20 (1:20.1.6-0ubuntu1) ... 240s Selecting previously unselected package clang-20. 240s Preparing to unpack .../44-clang-20_1%3a20.1.6-0ubuntu1_amd64.deb ... 240s Unpacking clang-20 (1:20.1.6-0ubuntu1) ... 240s Selecting previously unselected package libdebhelper-perl. 240s Preparing to unpack .../45-libdebhelper-perl_13.24.2ubuntu1_all.deb ... 240s Unpacking libdebhelper-perl (13.24.2ubuntu1) ... 240s Selecting previously unselected package libtool. 240s Preparing to unpack .../46-libtool_2.5.4-4_all.deb ... 240s Unpacking libtool (2.5.4-4) ... 240s Selecting previously unselected package dh-autoreconf. 240s Preparing to unpack .../47-dh-autoreconf_20_all.deb ... 240s Unpacking dh-autoreconf (20) ... 240s Selecting previously unselected package libarchive-zip-perl. 240s Preparing to unpack .../48-libarchive-zip-perl_1.68-1_all.deb ... 240s Unpacking libarchive-zip-perl (1.68-1) ... 240s Selecting previously unselected package libfile-stripnondeterminism-perl. 240s Preparing to unpack .../49-libfile-stripnondeterminism-perl_1.14.1-2_all.deb ... 240s Unpacking libfile-stripnondeterminism-perl (1.14.1-2) ... 240s Selecting previously unselected package dh-strip-nondeterminism. 240s Preparing to unpack .../50-dh-strip-nondeterminism_1.14.1-2_all.deb ... 240s Unpacking dh-strip-nondeterminism (1.14.1-2) ... 240s Selecting previously unselected package debugedit. 240s Preparing to unpack .../51-debugedit_1%3a5.1-2_amd64.deb ... 240s Unpacking debugedit (1:5.1-2) ... 240s Selecting previously unselected package dwz. 240s Preparing to unpack .../52-dwz_0.15-1build6_amd64.deb ... 240s Unpacking dwz (0.15-1build6) ... 240s Selecting previously unselected package gettext. 240s Preparing to unpack .../53-gettext_0.23.1-2build1_amd64.deb ... 240s Unpacking gettext (0.23.1-2build1) ... 240s Selecting previously unselected package intltool-debian. 240s Preparing to unpack .../54-intltool-debian_0.35.0+20060710.6_all.deb ... 240s Unpacking intltool-debian (0.35.0+20060710.6) ... 241s Selecting previously unselected package po-debconf. 241s Preparing to unpack .../55-po-debconf_1.0.21+nmu1_all.deb ... 241s Unpacking po-debconf (1.0.21+nmu1) ... 241s Selecting previously unselected package debhelper. 241s Preparing to unpack .../56-debhelper_13.24.2ubuntu1_all.deb ... 241s Unpacking debhelper (13.24.2ubuntu1) ... 241s Selecting previously unselected package emacsen-common. 241s Preparing to unpack .../57-emacsen-common_3.0.8_all.deb ... 241s Unpacking emacsen-common (3.0.8) ... 241s Selecting previously unselected package dictionaries-common. 241s Preparing to unpack .../58-dictionaries-common_1.30.10_all.deb ... 241s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 241s Unpacking dictionaries-common (1.30.10) ... 241s Selecting previously unselected package libfakeroot:amd64. 241s Preparing to unpack .../59-libfakeroot_1.37.1.2-1_amd64.deb ... 241s Unpacking libfakeroot:amd64 (1.37.1.2-1) ... 241s Selecting previously unselected package fakeroot. 241s Preparing to unpack .../60-fakeroot_1.37.1.2-1_amd64.deb ... 241s Unpacking fakeroot (1.37.1.2-1) ... 241s Selecting previously unselected package hunspell-en-us. 241s Preparing to unpack .../61-hunspell-en-us_1%3a2020.12.07-4_all.deb ... 241s Unpacking hunspell-en-us (1:2020.12.07-4) ... 241s Selecting previously unselected package libpgtypes3:amd64. 241s Preparing to unpack .../62-libpgtypes3_17.5-1build1_amd64.deb ... 241s Unpacking libpgtypes3:amd64 (17.5-1build1) ... 241s Selecting previously unselected package libpq5:amd64. 241s Preparing to unpack .../63-libpq5_17.5-1build1_amd64.deb ... 241s Unpacking libpq5:amd64 (17.5-1build1) ... 241s Selecting previously unselected package libecpg6:amd64. 241s Preparing to unpack .../64-libecpg6_17.5-1build1_amd64.deb ... 241s Unpacking libecpg6:amd64 (17.5-1build1) ... 241s Selecting previously unselected package libecpg-compat3:amd64. 241s Preparing to unpack .../65-libecpg-compat3_17.5-1build1_amd64.deb ... 241s Unpacking libecpg-compat3:amd64 (17.5-1build1) ... 241s Selecting previously unselected package libssl-dev:amd64. 241s Preparing to unpack .../66-libssl-dev_3.5.0-2ubuntu1_amd64.deb ... 241s Unpacking libssl-dev:amd64 (3.5.0-2ubuntu1) ... 241s Selecting previously unselected package libpq-dev. 241s Preparing to unpack .../67-libpq-dev_17.5-1build1_amd64.deb ... 241s Unpacking libpq-dev (17.5-1build1) ... 241s Selecting previously unselected package libecpg-dev. 241s Preparing to unpack .../68-libecpg-dev_17.5-1build1_amd64.deb ... 241s Unpacking libecpg-dev (17.5-1build1) ... 241s Selecting previously unselected package libncurses-dev:amd64. 241s Preparing to unpack .../69-libncurses-dev_6.5+20250216-2_amd64.deb ... 241s Unpacking libncurses-dev:amd64 (6.5+20250216-2) ... 241s Selecting previously unselected package libtcl8.6:amd64. 241s Preparing to unpack .../70-libtcl8.6_8.6.16+dfsg-1_amd64.deb ... 241s Unpacking libtcl8.6:amd64 (8.6.16+dfsg-1) ... 241s Selecting previously unselected package liblzma-dev:amd64. 241s Preparing to unpack .../71-liblzma-dev_5.8.1-1build1_amd64.deb ... 241s Unpacking liblzma-dev:amd64 (5.8.1-1build1) ... 241s Selecting previously unselected package zlib1g-dev:amd64. 241s Preparing to unpack .../72-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_amd64.deb ... 241s Unpacking zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 241s Selecting previously unselected package libxml2-dev:amd64. 241s Preparing to unpack .../73-libxml2-dev_2.14.3+dfsg-0exp3_amd64.deb ... 241s Unpacking libxml2-dev:amd64 (2.14.3+dfsg-0exp3) ... 241s Selecting previously unselected package libxslt1.1:amd64. 241s Preparing to unpack .../74-libxslt1.1_1.1.43-0exp1_amd64.deb ... 241s Unpacking libxslt1.1:amd64 (1.1.43-0exp1) ... 241s Selecting previously unselected package llvm-20-runtime. 241s Preparing to unpack .../75-llvm-20-runtime_1%3a20.1.6-0ubuntu1_amd64.deb ... 241s Unpacking llvm-20-runtime (1:20.1.6-0ubuntu1) ... 241s Selecting previously unselected package libpfm4:amd64. 241s Preparing to unpack .../76-libpfm4_4.13.0+git99-gc5587f9-1_amd64.deb ... 241s Unpacking libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 241s Selecting previously unselected package llvm-20. 241s Preparing to unpack .../77-llvm-20_1%3a20.1.6-0ubuntu1_amd64.deb ... 241s Unpacking llvm-20 (1:20.1.6-0ubuntu1) ... 242s Selecting previously unselected package libffi-dev:amd64. 242s Preparing to unpack .../78-libffi-dev_3.4.8-2_amd64.deb ... 242s Unpacking libffi-dev:amd64 (3.4.8-2) ... 242s Selecting previously unselected package llvm-20-tools. 242s Preparing to unpack .../79-llvm-20-tools_1%3a20.1.6-0ubuntu1_amd64.deb ... 242s Unpacking llvm-20-tools (1:20.1.6-0ubuntu1) ... 242s Selecting previously unselected package llvm-20-dev. 242s Preparing to unpack .../80-llvm-20-dev_1%3a20.1.6-0ubuntu1_amd64.deb ... 242s Unpacking llvm-20-dev (1:20.1.6-0ubuntu1) ... 244s Selecting previously unselected package locales-all. 244s Preparing to unpack .../81-locales-all_2.41-6ubuntu2_amd64.deb ... 244s Unpacking locales-all (2.41-6ubuntu2) ... 245s Selecting previously unselected package postgresql-client-17. 245s Preparing to unpack .../82-postgresql-client-17_17.5-1build1_amd64.deb ... 245s Unpacking postgresql-client-17 (17.5-1build1) ... 245s Selecting previously unselected package postgresql-17. 245s Preparing to unpack .../83-postgresql-17_17.5-1build1_amd64.deb ... 245s Unpacking postgresql-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-server-dev-17. 246s Preparing to unpack .../84-postgresql-server-dev-17_17.5-1build1_amd64.deb ... 246s Unpacking postgresql-server-dev-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-server-dev-all. 246s Preparing to unpack .../85-postgresql-server-dev-all_279_all.deb ... 246s Unpacking postgresql-server-dev-all (279) ... 246s Selecting previously unselected package postgresql-plperl-17. 246s Preparing to unpack .../86-postgresql-plperl-17_17.5-1build1_amd64.deb ... 246s Unpacking postgresql-plperl-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-plpython3-17. 246s Preparing to unpack .../87-postgresql-plpython3-17_17.5-1build1_amd64.deb ... 246s Unpacking postgresql-plpython3-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-pltcl-17. 246s Preparing to unpack .../88-postgresql-pltcl-17_17.5-1build1_amd64.deb ... 246s Unpacking postgresql-pltcl-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-all. 246s Preparing to unpack .../89-postgresql-all_279_all.deb ... 246s Unpacking postgresql-all (279) ... 246s Selecting previously unselected package postgresql-doc-17. 246s Preparing to unpack .../90-postgresql-doc-17_17.5-1build1_all.deb ... 246s Unpacking postgresql-doc-17 (17.5-1build1) ... 246s Selecting previously unselected package postgresql-doc. 246s Preparing to unpack .../91-postgresql-doc_17+279_all.deb ... 246s Unpacking postgresql-doc (17+279) ... 246s Setting up postgresql-client-common (279) ... 246s Setting up libpgtypes3:amd64 (17.5-1build1) ... 246s Setting up libncurses-dev:amd64 (6.5+20250216-2) ... 246s Setting up libio-pty-perl (1:1.20-1build3) ... 246s Setting up libarchive-zip-perl (1.68-1) ... 246s Setting up libclang-common-20-dev:amd64 (1:20.1.6-0ubuntu1) ... 246s Setting up libdebhelper-perl (13.24.2ubuntu1) ... 246s Setting up postgresql-doc-17 (17.5-1build1) ... 246s 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 246s Setting up libpq5:amd64 (17.5-1build1) ... 246s Setting up m4 (1.4.19-8) ... 246s Setting up llvm-20-runtime (1:20.1.6-0ubuntu1) ... 246s Setting up libgomp1:amd64 (15.1.0-5ubuntu1) ... 246s Setting up libffi-dev:amd64 (3.4.8-2) ... 246s Setting up locales-all (2.41-6ubuntu2) ... 246s Setting up libfakeroot:amd64 (1.37.1.2-1) ... 246s Setting up llvm-20-linker-tools (1:20.1.6-0ubuntu1) ... 246s Setting up fakeroot (1.37.1.2-1) ... 246s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 246s Setting up llvm-20-tools (1:20.1.6-0ubuntu1) ... 246s Setting up autotools-dev (20240727.1) ... 246s Setting up libpfm4:amd64 (4.13.0+git99-gc5587f9-1) ... 246s Setting up emacsen-common (3.0.8) ... 246s Setting up ssl-cert (1.1.3ubuntu1) ... 247s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 247s Setting up libquadmath0:amd64 (15.1.0-5ubuntu1) ... 247s Setting up llvm-20 (1:20.1.6-0ubuntu1) ... 247s Setting up libssl-dev:amd64 (3.5.0-2ubuntu1) ... 247s Setting up libmpc3:amd64 (1.3.1-1build2) ... 247s Setting up libtcl8.6:amd64 (8.6.16+dfsg-1) ... 247s Setting up autopoint (0.23.1-2build1) ... 247s Setting up libipc-run-perl (20231003.0-2) ... 247s Setting up libgc1:amd64 (1:8.2.8-1) ... 247s Setting up autoconf (2.72-3.1ubuntu1) ... 247s Setting up liblzma-dev:amd64 (5.8.1-1build1) ... 247s Setting up libubsan1:amd64 (15.1.0-5ubuntu1) ... 247s Setting up zlib1g-dev:amd64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 247s Setting up dwz (0.15-1build6) ... 247s Setting up libhwasan0:amd64 (15.1.0-5ubuntu1) ... 247s Setting up libasan8:amd64 (15.1.0-5ubuntu1) ... 247s Setting up libjson-perl (4.10000-1) ... 247s Setting up postgresql-doc (17+279) ... 247s Setting up libxslt1.1:amd64 (1.1.43-0exp1) ... 247s Setting up debugedit (1:5.1-2) ... 247s Setting up libecpg6:amd64 (17.5-1build1) ... 247s Setting up libtsan2:amd64 (15.1.0-5ubuntu1) ... 247s Setting up libisl23:amd64 (0.27-1) ... 247s Setting up libclang1-20 (1:20.1.6-0ubuntu1) ... 247s Setting up libcc1-0:amd64 (15.1.0-5ubuntu1) ... 247s Setting up liblsan0:amd64 (15.1.0-5ubuntu1) ... 247s Setting up libitm1:amd64 (15.1.0-5ubuntu1) ... 247s Setting up postgresql-common-dev (279) ... 247s Setting up automake (1:1.17-4ubuntu1) ... 247s update-alternatives: using /usr/bin/automake-1.17 to provide /usr/bin/automake (automake) in auto mode 247s Setting up libfile-stripnondeterminism-perl (1.14.1-2) ... 247s Setting up gettext (0.23.1-2build1) ... 247s Setting up libecpg-compat3:amd64 (17.5-1build1) ... 247s Setting up dictionaries-common (1.30.10) ... 247s Setting up postgresql-client-17 (17.5-1build1) ... 248s 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 248s Setting up libpq-dev (17.5-1build1) ... 248s Setting up libobjc4:amd64 (15.1.0-5ubuntu1) ... 248s Setting up libecpg-dev (17.5-1build1) ... 248s Setting up intltool-debian (0.35.0+20060710.6) ... 248s Setting up libxml2-dev:amd64 (2.14.3+dfsg-0exp3) ... 248s Setting up postgresql-common (279) ... 248s Creating config file /etc/postgresql-common/createcluster.conf with new version 248s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 248s en_us 248s Removing obsolete dictionary files: 249s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 249s Setting up llvm-20-dev (1:20.1.6-0ubuntu1) ... 249s Setting up cpp-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 249s Setting up cpp-14 (14.3.0-1ubuntu1) ... 249s Setting up dh-strip-nondeterminism (1.14.1-2) ... 249s Setting up hunspell-en-us (1:2020.12.07-4) ... 249s Setting up libgcc-14-dev:amd64 (14.3.0-1ubuntu1) ... 249s Setting up libstdc++-14-dev:amd64 (14.3.0-1ubuntu1) ... 249s Setting up cpp-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 249s Setting up postgresql-17 (17.5-1build1) ... 250s Creating new PostgreSQL cluster 17/main ... 250s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 250s The files belonging to this database system will be owned by user "postgres". 250s This user must also own the server process. 250s 250s The database cluster will be initialized with locale "C.UTF-8". 250s The default database encoding has accordingly been set to "UTF8". 250s The default text search configuration will be set to "english". 250s 250s Data page checksums are disabled. 250s 250s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 250s creating subdirectories ... ok 250s selecting dynamic shared memory implementation ... posix 250s selecting default "max_connections" ... 100 250s selecting default "shared_buffers" ... 128MB 250s selecting default time zone ... Etc/UTC 250s creating configuration files ... ok 250s running bootstrap script ... ok 251s performing post-bootstrap initialization ... ok 251s syncing data to disk ... ok 253s Setting up po-debconf (1.0.21+nmu1) ... 253s Setting up libobjc-14-dev:amd64 (14.3.0-1ubuntu1) ... 253s Setting up postgresql-plpython3-17 (17.5-1build1) ... 253s Setting up postgresql-plperl-17 (17.5-1build1) ... 253s Setting up cpp (4:14.2.0-1ubuntu1) ... 253s Setting up gcc-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 253s Setting up clang-20 (1:20.1.6-0ubuntu1) ... 253s Setting up postgresql-pltcl-17 (17.5-1build1) ... 253s Setting up gcc-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 253s Setting up libtool (2.5.4-4) ... 253s Setting up gcc-14 (14.3.0-1ubuntu1) ... 253s Setting up dh-autoreconf (20) ... 253s Setting up postgresql-server-dev-17 (17.5-1build1) ... 253s Setting up g++-14-x86-64-linux-gnu (14.3.0-1ubuntu1) ... 253s Setting up g++-x86-64-linux-gnu (4:14.2.0-1ubuntu1) ... 253s Setting up g++-14 (14.3.0-1ubuntu1) ... 253s Setting up postgresql-server-dev-all (279) ... 253s Setting up debhelper (13.24.2ubuntu1) ... 253s Setting up postgresql-all (279) ... 253s Setting up gcc (4:14.2.0-1ubuntu1) ... 253s Setting up g++ (4:14.2.0-1ubuntu1) ... 253s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 253s Setting up build-essential (12.12ubuntu1) ... 253s Processing triggers for libc-bin (2.41-6ubuntu2) ... 253s Processing triggers for systemd (257.6-1ubuntu1) ... 253s Processing triggers for man-db (2.13.1-1) ... 255s Processing triggers for install-info (7.1.1-1) ... 255s Processing triggers for dictionaries-common (1.30.10) ... 258s autopkgtest [03:42:51]: test run-testsuite: [----------------------- 259s ====== Running all tests with umask 077 ======= 259s ### PostgreSQL test 001_packages.t ### 259s 1..23 259s ok 1 - /etc/os-release exists 259s ok 2 - OS is ubuntu 259s ok 3 - OS version is 25.10 259s # PostgreSQL versions installed: 17 259s # 17 259s ok 4 - postgresql-17 installed 259s ok 5 - postgresql-plpython3-17 installed 259s ok 6 - postgresql-plperl-17 installed 259s ok 7 - postgresql-pltcl-17 installed 259s ok 8 # skip No postgresql-17-jit package for version 17 259s ok 9 - postgresql-server-dev-17 installed 259s ok 10 # skip No postgresql-contrib-17 package for version 17 259s # postgresql-doc-17 installed 259s ok 11 - At least one doc package installed 259s ok 12 - libecpg-dev installed 259s ok 13 - postgresql-common-dev installed 259s ok 14 - procps installed 259s ok 15 - netcat-openbsd installed 259s ok 16 - hunspell-en-us installed 259s ok 17 - system has a default UTF-8 locale 259s ok 18 - locale ru_RU exists 259s ok 19 - locale ru_RU.UTF-8 exists 259s ok 20 - user postgres in the UNIX group ssl-cert 259s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key exists 259s ok 22 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 259s ok 23 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 259s ### End test 001_packages.t ### 259s 259s ### PostgreSQL test 002_existing_clusters.t ### 259s 1..8 259s # Cleanup 259s ok 1 - Cleanup: No clusters left behind 259s ok 2 - No postgres processes left behind 259s ok 3 - No files in /etc/postgresql left behind 259s ok 4 - No files in /var/lib/postgresql left behind 259s ok 5 - No files in /var/run/postgresql left behind 259s ok 6 - No files in /var/log/postgresql left behind 259s ok 7 - PostgreSQL TCP ports are closed 259s ok 8 - Next free port is 5432 259s ### End test 002_existing_clusters.t ### 259s 259s ### PostgreSQL test 003_alternatives.t ### 259s 1..9 259s # Newest PG version installed is 17 259s ok 1 - psql.1.gz link group 259s ok 2 - postmaster.1.gz link group does not exist 259s ok 3 - psql.1.gz alternative 259s ok 4 - pg_dump.1.gz alternative 259s ok 5 - postgres.1.gz alternative 259s ok 6 - pg_ctl.1.gz alternative 259s # Newest PG doc version installed is 17 259s ok 7 - SPI_connect.3.gz link group 259s ok 8 - SPI_connect.3.gz alternative 259s ok 9 - SPI_exec.3.gz alternative 259s ### End test 003_alternatives.t ### 259s 259s ### PostgreSQL test 005_PgCommon.t ### 259s 1..24 259s ok 1 - correctly parsed line 'local all postgres ident sameuser' 259s ok 2 - correctly parsed line 'local foo nobody trust' 259s ok 3 - correctly parsed line 'local foo nobody crypt' 259s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 259s ok 5 - correctly parsed line 'local foo,bar nobody ident' 259s ok 6 - correctly parsed line 'local all +foogrp password' 259s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 259s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 259s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 259s ok 10 - @expected_records has correct number of entries 259s ok 11 - returned read_pg_hba array has correct number of records 259s ok 12 - line 'foo all all md5' parsed as invalid 259s ok 13 - line 'local all all foo' parsed as invalid 259s ok 14 - line 'host all all foo' parsed as invalid 259s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 259s ok 16 - line 'host all all md5' parsed as invalid 259s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 259s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 259s ok 19 - read_conf_file returns empty dict for nonexisting file 259s ok 20 - read_conf_file() parsing 259s ok 21 - read_conf_file() parsing with include directives 259s ok 22 - set_conf_value 259s ok 23 - disable_conf_value 259s ok 24 - replace_conf_value 259s ### End test 005_PgCommon.t ### 259s 259s ### PostgreSQL test 006_next_free_port.t ### 259s 1..5 259s ok 1 - next_free_port is 5432 260s ok 2 - next_free_port detects localhost ipv4 socket 261s ok 3 - next_free_port detects wildcard ipv4 socket 262s ok 4 - next_free_port detects localhost ipv6 socket 263s ok 5 - next_free_port detects wildcard ipv6 socket 263s ### End test 006_next_free_port.t ### 263s 263s ### PostgreSQL test 007_pg_conftool.t ### 263s 1..41 263s # test without cluster 263s ok 1 - pg_conftool show all 263s ok 2 - correct output of pg_conftool show all 263s ok 3 - pg_conftool foo.conf show all 263s ok 4 - correct output of pg_conftool foo.conf show all 263s ok 5 - pg_conftool /tmp/7JteYr32p1/different.conf show all 263s ok 6 - correct output of pg_conftool /tmp/7JteYr32p1/different.conf show all 264s ok 7 - pg_conftool 9.7 main show all 264s ok 8 - correct output of pg_conftool 9.7 main show all 264s # test show 264s ok 9 - pg_conftool show all 264s ok 10 - correct output of pg_conftool show all 264s ok 11 - pg_conftool other.conf show all 264s ok 12 - correct output of pg_conftool other.conf show all 264s ok 13 - pg_conftool /tmp/7JteYr32p1/different.conf show all 264s ok 14 - correct output of pg_conftool /tmp/7JteYr32p1/different.conf show all 264s ok 15 - pg_conftool 17 main show all 264s ok 16 - correct output of pg_conftool 17 main show all 264s ok 17 - pg_conftool 17 main other.conf show all 264s ok 18 - correct output of pg_conftool 17 main other.conf show all 264s ok 19 - pg_conftool show a 264s ok 20 - correct output of pg_conftool show a 264s ok 21 - pg_conftool -s show a 264s ok 22 - correct output of pg_conftool -s show a 264s # test set 264s ok 23 - pg_conftool set c 7 264s ok 24 - correct output of pg_conftool set c 7 264s ok 25 - file contains new setting 264s ok 26 - pg_conftool set a 8 264s ok 27 - correct output of pg_conftool set a 8 264s ok 28 - file contains updated setting 264s ok 29 - pg_conftool /tmp/7JteYr32p1/different.conf set a 9 264s ok 30 - correct output of pg_conftool /tmp/7JteYr32p1/different.conf set a 9 264s ok 31 - file with path contains updated setting 264s # test remove 264s ok 32 - pg_conftool remove a 264s ok 33 - correct output of pg_conftool remove a 264s ok 34 - setting removed from file 264s ok 35 - pg_conftool /tmp/7JteYr32p1/different.conf remove a 264s ok 36 - correct output of pg_conftool /tmp/7JteYr32p1/different.conf remove a 264s ok 37 - setting removed from file with path 264s # test edit 264s ok 38 - pg_conftool edit 264s ok 39 - correct output of pg_conftool edit 264s ok 40 - pg_conftool /tmp/7JteYr32p1/different.conf edit 264s ok 41 - correct output of pg_conftool /tmp/7JteYr32p1/different.conf edit 264s ### End test 007_pg_conftool.t ### 264s 264s ### PostgreSQL test 010_defaultport_cluster.t ### 264s 1..14 264s ok 1 - psql --version 264s ok 2 - pg_wrapper selects highest available version number 264s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 264s ok 4 - connecting to localhost fails with no clusters 264s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 264s ok 6 - pg_wrapper uses host and port from PGCLUSTER 264s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 264s ok 8 - pg_wrapper uses --cluster from the command line 264s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 264s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 264s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 264s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 264s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 264s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 264s ### End test 010_defaultport_cluster.t ### 264s 264s ### PostgreSQL test 015_start_stop.t ### 264s 1..71 264s # We are running systemd 264s # Running tests for 17 264s # Cluster does not exist yet 264s ok 1 - cluster 17 main does not exist 264s ok 2 - service postgresql@17-main does not exist 264s ok 3 - systemctl start postgresql 264s ok 4 - cluster 17 main does not exist 264s ok 5 - service postgresql@17-main does not exist 264s ok 6 - systemctl start postgresql@17-main 264s ok 7 - cluster 17 main does not exist 264s ok 8 - service postgresql@17-main does not exist 264s # Start/stop postgresql using system tools 265s ok 9 - pg_createcluster 17 main 265s ok 10 - cluster 17 main is stopped 265s ok 11 - service postgresql@17-main is stopped 268s ok 12 - systemctl start postgresql 268s ok 13 - cluster 17 main is running 268s ok 14 - service postgresql@17-main is running 268s ok 15 - systemctl start postgresql 268s ok 16 - cluster 17 main is already running 268s ok 17 - service postgresql@17-main is already running 268s ok 18 - systemctl stop postgresql 274s ok 19 - cluster 17 main is stopped 274s ok 20 - service postgresql@17-main is stopped 274s ok 21 - systemctl stop postgresql 274s ok 22 - cluster 17 main is already stopped 274s ok 23 - service postgresql@17-main is already stopped 274s # Start/stop specific cluster using system tools 276s ok 24 - systemctl start postgresql@17-main 276s ok 25 - cluster 17 main is running 276s ok 26 - service postgresql@17-main is running 276s ok 27 - systemctl start postgresql@17-main 276s ok 28 - cluster 17 main is running 276s ok 29 - service postgresql@17-main is running 279s ok 30 - systemctl restart postgresql@17-main 279s ok 31 - cluster 17 main is running 279s ok 32 - service postgresql@17-main is running 279s ok 33 - systemctl stop postgresql@17-main 279s ok 34 - cluster 17 main is stopped 279s ok 35 - service postgresql@17-main is stopped 279s ok 36 - systemctl stop postgresql@17-main 279s ok 37 - cluster 17 main is already stopped 279s ok 38 - service postgresql@17-main is already stopped 280s ok 39 - pg_dropcluster 17 main 280s ok 40 - cluster 17 main does not exist 280s ok 41 - service postgresql@17-main does not exist 280s # Start/stop specific cluster using pg_*cluster 280s ok 42 - pg_ctlcluster start 17 main 280s ok 43 - cluster 17 main does not exist 280s ok 44 - service postgresql@17-main does not exist 283s ok 45 - pg_createcluster 17 main --start 284s ok 46 - cluster 17 main is running 284s ok 47 - service postgresql@17-main is running 284s ok 48 - pg_ctlcluster 17 main start 284s ok 49 - cluster 17 main is already running 284s ok 50 - service postgresql@17-main is already running 286s ok 51 - pg_ctlcluster 17-main restart 286s ok 52 - cluster 17 main is running 286s ok 53 - service postgresql@17-main is running 286s ok 54 - pg_ctlcluster 17 main stop 286s ok 55 - cluster 17 main is stopped 286s ok 56 - service postgresql@17-main is stopped 286s ok 57 - pg_ctlcluster 17 main stop 286s ok 58 - cluster 17 main is already stopped 286s ok 59 - service postgresql@17-main is already stopped 289s ok 60 - pg_ctlcluster start 17-main 289s ok 61 - cluster 17 main is running 289s ok 62 - service postgresql@17-main is running 290s ok 63 - pg_dropcluster 17 main --stop 290s # Cleanup 290s ok 64 - Cleanup: No clusters left behind 290s ok 65 - No postgres processes left behind 290s ok 66 - No files in /etc/postgresql left behind 290s ok 67 - No files in /var/lib/postgresql left behind 290s ok 68 - No files in /var/run/postgresql left behind 290s ok 69 - No files in /var/log/postgresql left behind 290s ok 70 - PostgreSQL TCP ports are closed 290s ok 71 - Next free port is 5432 290s ### End test 015_start_stop.t ### 290s 290s ### PostgreSQL test 020_create_sql_remove.t ### 290s 1..141 290s # Running tests for 17 293s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.jS0hb7 293s ok 2 - pg_createcluster 17 main 293s ok 3 - Socket and pid file are in /var/run/postgresql/ 293s ok 4 - xlog/wal directory /tmp/17.xlog.jS0hb7 was created 293s ok 5 - local method in pg_hba.conf is peer 293s ok 6 - host method in pg_hba.conf is scram-sha-256 293s ok 7 - Exactly one postgres master process running 296s ok 8 - pg_ctlcluster 17 main restart 296s ok 9 - cluster restarts with new environment file 296s ok 10 - Exactly one postgres master process running 296s ok 11 - correct value of PGEXTRAVAR1 in environment 296s ok 12 - correct value of PGEXTRAVAR2 in environment 296s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 296s ok 14 - createdb --version 296s ok 15 - pg_wrapper+createdb selects version number of cluster 296s ok 16 - psql --version 296s ok 17 - pg_wrapper+psql selects version 17 296s ok 18 - pg_lscluster reports online cluster on port 5432 296s ok 19 - log file is actually used 296s ok 20 - /etc/postgresql is owned by user "postgres" 296s ok 21 - version configuration directory file is owned by user "postgres" 296s ok 22 - configuration directory file is owned by user "postgres" 296s ok 23 - version data directory file is owned by user "postgres" 296s ok 24 - data directory file is owned by user "postgres" 296s ok 25 - log file has 0640 permissions 296s ok 26 - log file is owned by user "postgres" 296s ok 27 - log file is owned by group "adm" 296s ok 28 - no log symlink by default 296s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 296s ok 30 - pg_lsclusters -h 296s ok 31 - correct output of pg_lsclusters -h 296s ok 32 - stopping cluster 299s ok 33 - restarting cluster with nondefault log symlink 299s ok 34 - log target is used as log file 299s ok 35 - default log is not used 299s ok 36 - pg_lsclusters -h 299s ok 37 - correct output of pg_lsclusters -h 299s ok 38 - stopping cluster 302s ok 39 - restarting cluster with explicitly configured log file 302s ok 40 - default log is not used 302s ok 41 - log symlink target is used for startup message 302s ok 42 - exactly one log file 302s ok 43 - custom log is actually used 302s ok 44 - pg_lsclusters -h 302s ok 45 - correct output of pg_lsclusters -h 302s ok 46 - stopping cluster 302s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 302s ok 48 - /etc/postgres-hack was not created 304s ok 49 - restarting cluster 304s ok 50 - ps -o tty -U postgres h 304s ok 51 - postgres processes do not have an associated terminal 304s ok 52 - Server is linked with SSL support 304s ok 53 - SSL is enabled in postgresql.conf 304s ok 54 - psql -l fails for nobody 304s ok 55 - createuser nobody 304s ok 56 - createdb nobodydb 304s ok 57 - psql -ltA succeeds for nobody 304s ok 58 - psql -ltA output 304s ok 59 - SQL command: create table 304s ok 60 - SQL command: insert into table values 304s ok 61 - SQL command: insert into table values 304s ok 62 - primary key violation 304s ok 63 - psql -tAc "select * from phone order by name" nobodydb 304s ok 64 - SQL command output: select -tA 305s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 305s ok 66 - SQL command output: select -tx 305s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 305s ok 68 - SQL command output: select -tAx 305s ok 69 - CREATE EXTENSION plperlu fails for user nobody 305s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 305s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 305s ok 72 - creating PL/PerlU function as user nobody fails 305s ok 73 - creating unsafe PL/Perl function as user postgres fails 305s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 305s ok 75 - creating PL/PerlU function as user postgres succeeds 305s ok 76 - psql nobodydb -Atc "select read_file()" 305s ok 77 - calling PL/PerlU function 305s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 305s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 305s ok 80 - creating unsafe PL/Perl function as user nobody fails 305s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 305s ok 82 - creating PL/Perl function as user nobody succeeds 305s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 305s ok 84 - calling PL/Perl function 305s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 305s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 305s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 305s ok 88 - creating PL/Python3 function as user postgres succeeds 305s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 305s ok 90 - calling PL/Python function 305s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 305s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 305s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 305s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 305s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 305s ok 96 - creating PL/Tcl function as user nobody succeeds 305s 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;" 305s ok 98 - creating PL/TclU function as user postgres succeeds 305s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 305s ok 100 - calling PL/Tcl function 305s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 305s ok 102 - calling PL/TclU function 306s ok 103 - stopping cluster 306s ok 104 - pg_ctlcluster 17 main start 306s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 308s ok 106 - pg_ctlcluster 17 main start 308s ok 107 - cluster restarts with pgdata symlink 308s ok 108 - postgres master has OOM killer protection 308s ok 109 - postgres client backend has no OOM adjustment 308s ok 110 - ps h 6073 308s ok 111 - process title is idle 309s ok 112 - ps h 6073 309s ok 113 - process title is idle in transaction 309s ok 114 - stopping cluster 311s ok 115 - starting cluster as postgres works without a log file 311s ok 116 - log file got recreated and used 311s ok 117 - creating a directory in spc2 311s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.MF735Q'" 311s ok 119 - creating tablespace spc1 311s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 311s ok 121 - creating a table in spc1 311s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.gT0NM7'" 311s ok 123 - creating tablespace spc2 311s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 311s ok 125 - creating a table in spc2 311s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 311s ok 127 - Correct apt NeverAutoRemove config 313s ok 128 - pg_dropcluster removes cluster 313s ok 129 - xlog/wal directory /tmp/17.xlog.jS0hb7 was deleted 313s ok 130 - tablespace spc1 was emptied 313s ok 131 - tablespace spc2 was emptied 313s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 313s ok 133 - Correct apt NeverAutoRemove config 313s # Cleanup 313s ok 134 - Cleanup: No clusters left behind 313s ok 135 - No postgres processes left behind 313s ok 136 - No files in /etc/postgresql left behind 313s ok 137 - No files in /var/lib/postgresql left behind 313s ok 138 - No files in /var/run/postgresql left behind 313s ok 139 - No files in /var/log/postgresql left behind 313s ok 140 - PostgreSQL TCP ports are closed 313s ok 141 - Next free port is 5432 313s ### End test 020_create_sql_remove.t ### 313s 313s ### PostgreSQL test 021_pg_renamecluster.t ### 313s 1..20 316s ok 1 - pg_createcluster 17 main 319s ok 2 - pg_renamecluster 17 main donau 319s ok 3 - psql -tAc "show data_directory" 319s ok 4 - cluster is running and data_directory was moved 319s ok 5 - pg_hba.conf location updated 319s ok 6 - pg_ident.conf location updated 319s ok 7 - external_pid_file location updated 319s ok 8 - external_pid_file exists 319s ok 9 # skip no stats_temp_directory in 17 319s ok 10 # skip no stats_temp_directory in 17 319s ok 11 - cluster_name is updated 320s ok 12 - pg_dropcluster removes cluster 320s # Cleanup 320s ok 13 - Cleanup: No clusters left behind 320s ok 14 - No postgres processes left behind 320s ok 15 - No files in /etc/postgresql left behind 320s ok 16 - No files in /var/lib/postgresql left behind 320s ok 17 - No files in /var/run/postgresql left behind 320s ok 18 - No files in /var/log/postgresql left behind 320s ok 19 - PostgreSQL TCP ports are closed 320s ok 20 - Next free port is 5432 320s ### End test 021_pg_renamecluster.t ### 320s 320s ### PostgreSQL test 022_recovery.t ### 320s 1..17 320s # Running tests for 17 323s ok 1 - pg_createcluster 17 main --start >/dev/null 323s ok 2 - pg_ctlcluster 17 main stop -m i 326s ok 3 - pg_ctlcluster 17 main start 326s ok 4 - psql -c '' 326s ok 5 - pg_ctlcluster 17 main stop -m i 326s ok 6 - create write-protected file in data directory 328s ok 7 - pg_ctlcluster 17 main start 328s ok 8 - psql -c '' 330s ok 9 - pg_dropcluster removes cluster 330s # Cleanup 330s ok 10 - Cleanup: No clusters left behind 330s ok 11 - No postgres processes left behind 330s ok 12 - No files in /etc/postgresql left behind 330s ok 13 - No files in /var/lib/postgresql left behind 330s ok 14 - No files in /var/run/postgresql left behind 330s ok 15 - No files in /var/log/postgresql left behind 330s ok 16 - PostgreSQL TCP ports are closed 330s ok 17 - Next free port is 5432 330s ### End test 022_recovery.t ### 330s 330s ### PostgreSQL test 025_logging.t ### 330s 1..55 330s # Logging to /var/log/syslog works 330s # Running tests for 17 333s ok 1 - pg_createcluster 17 main 333s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 333s ok 3 - psql -qc "'foobar_17_7264'" 333s ok 4 - log an error 334s ok 5 - grep --binary-files=text foobar_17_7264 /var/log/postgresql/postgresql-17-main.log 334s ok 6 - error appears in logfile 334s ok 7 - pg_conftool 17 main set log_destination syslog 334s ok 8 - set log_destination syslog 334s ok 9 - pg_ctlcluster 17 main reload 334s ok 10 - 17 main reload 334s ok 11 - psql -Atc "show log_destination" 334s ok 12 - log_destination is syslog 334s ok 13 - pg_lscluster reports syslog 335s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 335s ok 15 - error appears in /var/log/syslog 335s ok 16 - pg_conftool 17 main set logging_collector on 335s ok 17 - set logging_collector on 335s ok 18 - pg_conftool 17 main set log_destination csvlog 335s ok 19 - set log_destination csvlog 337s ok 20 - pg_ctlcluster 17 main restart 337s ok 21 - 17 main restart 337s ok 22 - psql -Atc "show logging_collector" 337s ok 23 - logging_collector is on 337s ok 24 - psql -Atc "show log_destination" 337s ok 25 - log_destination is csvlog 337s ok 26 - pg_lscluster reports csvlog 337s ok 27 - psql -qc "'barbaz_17_7264'" 337s ok 28 - log an error 338s ok 29 - grep --binary-files=text barbaz_17_7264 /var/lib/postgresql/17/main/log/*.csv 338s ok 30 - error appears in log/*.csv 338s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 338s ok 32 - set log_destination stderr,syslog,csvlog 338s ok 33 - pg_ctlcluster 17 main reload 338s ok 34 - 17 main reload 338s ok 35 - psql -Atc "show log_destination" 338s ok 36 - log_destination is stderr,syslog,csvlog 338s ok 37 - pg_lscluster reports stderr,syslog,csvlog 338s ok 38 - psql -qc "'moo_17_7264'" 338s ok 39 - log an error 339s ok 40 - grep --binary-files=text moo_17_7264 /var/lib/postgresql/17/main/log/*.log 339s ok 41 - error appears in log/*.log 339s ok 42 - grep --binary-files=text 'postgres.*moo_17_7264' /var/log/syslog 339s ok 43 - error appears in /var/log/syslog 339s ok 44 - grep --binary-files=text moo_17_7264 /var/lib/postgresql/17/main/log/*.csv 339s ok 45 - error appears in log/*.csv 341s ok 46 - pg_dropcluster 17 main --stop 341s ok 47 - pg_dropcluster removes cluster 341s # Cleanup 341s ok 48 - Cleanup: No clusters left behind 341s ok 49 - No postgres processes left behind 341s ok 50 - No files in /etc/postgresql left behind 341s ok 51 - No files in /var/lib/postgresql left behind 341s ok 52 - No files in /var/run/postgresql left behind 341s ok 53 - No files in /var/log/postgresql left behind 341s ok 54 - PostgreSQL TCP ports are closed 341s ok 55 - Next free port is 5432 341s ### End test 025_logging.t ### 341s 341s ### PostgreSQL test 027_jit.t ### 341s # 17 344s ok 1 - pg_createcluster 17 main --start 344s ok 2 - psql -Xatc 'show jit' 344s ok 3 - JIT is on by default 344s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 344s ok 5 - No JIT on cheap query 344s ok 6 - pg_conftool 17 main set seq_page_cost 100000 344s ok 7 - pg_conftool 17 main set random_page_cost 100000 344s ok 8 - pg_ctlcluster 17 main reload 344s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 344s ok 10 - Expensive query is JITed 346s ok 11 - pg_dropcluster --stop 17 main 346s # Cleanup 346s ok 12 - Cleanup: No clusters left behind 346s ok 13 - No postgres processes left behind 346s ok 14 - No files in /etc/postgresql left behind 346s ok 15 - No files in /var/lib/postgresql left behind 346s ok 16 - No files in /var/run/postgresql left behind 346s ok 17 - No files in /var/log/postgresql left behind 346s ok 18 - PostgreSQL TCP ports are closed 346s ok 19 - Next free port is 5432 346s 1..19 346s ### End test 027_jit.t ### 346s 346s ### PostgreSQL test 030_errors.t ### 346s 1..156 346s ok 1 - pg_lscluster reports cluster without binaries 347s ok 2 - pg_dropcluster 6.3 main 348s ok 3 - pg_createcluster --socketdir 348s ok 4 - pg_lsclusters -h 348s ok 5 - cluster was created 348s ok 6 - Port of created cluster is 5432 348s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 348s ok 8 - pg_createcluster on existing cluster 348s ok 9 - pg_lsclusters -h 348s ok 10 - original cluster still exists 348s ok 11 - pg_createcluster 17 test -p foo 348s ok 12 - pg_createcluster -p checks that port option is numeric 348s ok 13 - pg_createcluster 17 test -p 42 348s ok 14 - pg_createcluster -p checks valid port range 348s ok 15 - pg_ctlcluster 17 main start 348s ok 16 - pg_ctlcluster refuses to start root-owned cluster 348s ok 17 - pg_ctlcluster 17 main start 348s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 348s ok 19 - pg_ctlcluster 17 main start 348s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 348s ok 21 - pg_ctlcluster 17 main start 348s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 351s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 351s ok 24 - No sockets in /var/run/postgresql 351s ok 25 - Socket is in /tmp/postgresql-testsuite/ 351s ok 26 - cluster stops with custom unix_socket_dir 351s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 353s ok 28 - cluster starts after removing unix_socket_dir 353s ok 29 - Socket is in default dir /var/run/postgresql 353s ok 30 - No sockets in /tmp/postgresql-testsuite/ 353s ok 31 - pg_ctlcluster 17 main stop 353s ok 32 - pg_ctlcluster fails with corrupted PID file 353s ok 33 - pg_lsclusters -h 353s ok 34 - cluster is still online 353s ok 35 - pg_ctlcluster succeeds with restored PID file 353s ok 36 - pg_lsclusters -h 353s ok 37 - cluster is down 353s ok 38 - pg_ctlcluster 17 main stop 353s ok 39 - pg_ctlcluster stop fails on stopped cluster 356s ok 40 - pg_ctlcluster 17 main start 356s ok 41 - pg_ctlcluster succeeds with already existing PID file 356s ok 42 - pg_lsclusters -h 356s ok 43 - cluster is online 356s ok 44 - pg_ctlcluster stop succeeds 356s ok 45 - pg_lsclusters -h 356s ok 46 - cluster is down 356s ok 47 - no pid file left 356s ok 48 - pg_ctlcluster 17 main stop 356s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 356s ok 50 - pid file was cleaned up 356s ok 51 - pg_ctlcluster --force 17 main stop 356s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 356s ok 53 - pid file was cleaned up 356s ok 54 - pg_ctlcluster 17 main stop 356s ok 55 - pg_ctlcluster stop succeeds with stale PID file 356s ok 56 - pid file was cleaned up 356s ok 57 - pg_ctlcluster --force 17 main stop 356s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 356s ok 59 - pid file was cleaned up 356s ok 60 - pg_ctlcluster --force 17 main stop 356s ok 61 - pg_ctlcluster stop succeeds with empty PID file 356s ok 62 - pid file was cleaned up 358s ok 63 - pg_ctlcluster 17 main start 358s ok 64 - pg_ctlcluster succeeds with corrupted PID file 358s ok 65 - pg_lsclusters -h 358s ok 66 - cluster is online 358s ok 67 - pg_ctlcluster 17 main start 358s ok 68 - pg_ctlcluster start fails on running cluster 359s ok 69 - pg_ctlcluster stop 359s ok 70 - pg_ctlcluster 17 main start 359s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 359s ok 72 - pg_ctlcluster 17 main stop 359s ok 73 - stopping cluster 365s ok 74 - pg_ctlcluster 17 main start 365s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 365s ok 76 - pg_ctlcluster 17 main stop 365s ok 77 - stopping cluster 365s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 365s ok 79 - pg_dropcluster 17 main 365s ok 80 - pg_dropcluster works as user postgres 366s ok 81 - pg_createcluster succeeds 366s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 366s ok 83 - proper error message for nonexisting /var/lib/postgresql 368s ok 84 - pg_ctlcluster 17 main start 368s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 369s ok 86 - pg_ctlcluster 17 main stop 369s ok 87 - stopping cluster 369s ok 88 - pg_createcluster other 372s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 374s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 374s ok 91 374s ok 92 - pg_ctlcluster 17 other start 374s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 374s ok 94 - pg_ctlcluster 17 main stop 374s ok 95 - stopping main cluster 376s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 378s ok 97 - pg_dropcluster other 379s ok 98 - pg_dropcluster 379s ok 99 - No sockets any more 379s ok 100 - 'pg_lsclusters 4.5 foo' fails 379s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 379s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 379s ok 103 - 'psql --cluster 4.5/foo' fails 379s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 379s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 379s ok 106 - 'psql --cluster 17/foo' fails 379s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 379s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 379s ok 109 - 'pg_dropcluster 4.5 foo' fails 379s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 379s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 379s ok 112 - 'pg_dropcluster 17 foo' fails 379s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 379s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 380s ok 115 - 'pg_upgradecluster 4.5 foo' fails 380s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 380s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 380s ok 118 - 'pg_upgradecluster 17 foo' fails 380s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 380s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 380s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 380s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 380s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 380s ok 124 - 'pg_ctlcluster 17 foo stop' fails 380s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 380s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 380s # Cleanup 380s ok 127 - Cleanup: No clusters left behind 380s ok 128 - No postgres processes left behind 380s ok 129 - No files in /etc/postgresql left behind 380s ok 130 - No files in /var/lib/postgresql left behind 380s ok 131 - No files in /var/run/postgresql left behind 380s ok 132 - No files in /var/log/postgresql left behind 380s ok 133 - PostgreSQL TCP ports are closed 380s ok 134 - Next free port is 5432 381s ok 135 - pg_dropcluster 17 broken 381s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 381s # Cleanup 381s ok 137 - Cleanup: No clusters left behind 381s ok 138 - No postgres processes left behind 381s ok 139 - No files in /etc/postgresql left behind 381s ok 140 - No files in /var/lib/postgresql left behind 381s ok 141 - No files in /var/run/postgresql left behind 381s ok 142 - No files in /var/log/postgresql left behind 381s ok 143 - PostgreSQL TCP ports are closed 381s ok 144 - Next free port is 5432 382s ok 145 - pg_dropcluster 17 broken 382s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 382s ok 147 - /etc/postgresql/17 was removed 382s ok 148 - /var/lib/postgresql/17 was removed 382s # Cleanup 382s ok 149 - Cleanup: No clusters left behind 382s ok 150 - No postgres processes left behind 382s ok 151 - No files in /etc/postgresql left behind 382s ok 152 - No files in /var/lib/postgresql left behind 382s ok 153 - No files in /var/run/postgresql left behind 382s ok 154 - No files in /var/log/postgresql left behind 382s ok 155 - PostgreSQL TCP ports are closed 382s ok 156 - Next free port is 5432 382s ### End test 030_errors.t ### 382s 382s ### PostgreSQL test 031_errors_disk_full.t ### 382s 1..22 382s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 384s ok 1 - script failed 384s ok 2 - pg_createcluster fails due to insufficient disk space 384s ok 3 - does not leave files behind 384s # Cleanup 384s ok 4 - Cleanup: No clusters left behind 384s ok 5 - No postgres processes left behind 384s ok 6 - No files in /etc/postgresql left behind 384s ok 7 - No files in /var/lib/postgresql left behind 384s ok 8 - No files in /var/run/postgresql left behind 384s ok 9 - No files in /var/log/postgresql left behind 384s ok 10 - PostgreSQL TCP ports are closed 384s ok 11 - Next free port is 5432 384s # check disk full conditions on startup 386s ok 12 - script failed 386s ok 13 - pg_ctlcluster prints error message 386s ok 14 - log file has error message 386s # Cleanup 386s ok 15 - Cleanup: No clusters left behind 386s ok 16 - No postgres processes left behind 386s ok 17 - No files in /etc/postgresql left behind 386s ok 18 - No files in /var/lib/postgresql left behind 386s ok 19 - No files in /var/run/postgresql left behind 386s ok 20 - No files in /var/log/postgresql left behind 386s ok 21 - PostgreSQL TCP ports are closed 386s ok 22 - Next free port is 5432 386s ### End test 031_errors_disk_full.t ### 386s 386s ### PostgreSQL test 032_ssl_key_permissions.t ### 386s 1..22 386s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 386s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 386s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 387s ok 4 - pg_createcluster 17 main 387s ok 5 - pg_ctlcluster 17 main start 387s ok 6 - ssl key owned by nobody refused 388s ok 7 - pg_ctlcluster 17 main start 388s ok 8 - ssl key with permissions root:root 0644 refused 388s ok 9 - pg_ctlcluster 17 main start 388s ok 10 - ssl key with permissions postgres:postgres 0640 refused 389s ok 11 - pg_dropcluster 17 main --stop 389s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 389s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 389s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 389s # Cleanup 389s ok 15 - Cleanup: No clusters left behind 389s ok 16 - No postgres processes left behind 389s ok 17 - No files in /etc/postgresql left behind 389s ok 18 - No files in /var/lib/postgresql left behind 389s ok 19 - No files in /var/run/postgresql left behind 389s ok 20 - No files in /var/log/postgresql left behind 389s ok 21 - PostgreSQL TCP ports are closed 389s ok 22 - Next free port is 5432 389s ### End test 032_ssl_key_permissions.t ### 389s 389s ### PostgreSQL test 040_upgrade.t ### 389s 1..1 389s ok 1 - only one major version installed, skipping upgrade tests 389s ### End test 040_upgrade.t ### 389s 389s ### PostgreSQL test 041_upgrade_custompaths.t ### 389s 1..1 389s ok 1 - only one major version installed, skipping upgrade tests 389s ### End test 041_upgrade_custompaths.t ### 389s 389s ### PostgreSQL test 042_upgrade_rename.t ### 389s 1..15 389s # PostgreSQL 17 392s ok 1 - pg_createcluster 17 main --start 398s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 398s ok 3 - pg_lsclusters -h 398s ok 4 - correct output of pg_lsclusters -h 399s ok 5 - pg_dropcluster 17 main --stop 401s ok 6 - pg_dropcluster 17 upgr --stop 401s ok 7 - Cleaning pg_upgrade log files 401s # Cleanup 401s ok 8 - Cleanup: No clusters left behind 401s ok 9 - No postgres processes left behind 401s ok 10 - No files in /etc/postgresql left behind 401s ok 11 - No files in /var/lib/postgresql left behind 401s ok 12 - No files in /var/run/postgresql left behind 401s ok 13 - No files in /var/log/postgresql left behind 401s ok 14 - PostgreSQL TCP ports are closed 401s ok 15 - Next free port is 5432 401s ### End test 042_upgrade_rename.t ### 401s 401s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 401s 1..1 401s ok 1 - only one major version installed, skipping upgrade tests 401s ### End test 043_upgrade_ssl_cert.t ### 401s 401s ### PostgreSQL test 045_backup.t ### 401s # We are running systemd 401s # PostgreSQL 17 401s # create cluster 404s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 404s ok 2 - pg_lsclusters -h 404s ok 3 - correct output of pg_lsclusters -h 404s ok 4 - pg_conftool 17 main set work_mem 11MB 404s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 404s ok 6 - psql -c 'alter database mydb set search_path=public' 404s ok 7 - psql -c 'create table foo (t text)' mydb 404s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 405s ok 9 - psql -c 'CREATE USER myuser' 405s ok 10 - psql -c 'grant create on database mydb to myuser' 405s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 405s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 405s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 405s # create directory 405s ok 14 - pg_backupcluster 17 main createdirectory 405s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 405s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 405s # dump 405s ok 17 - systemctl start pg_dump@17-main 405s ok 18 - dump created in /var/backups/postgresql/17-main/2025-06-19T034518Z.dump 405s ok 19 - /var/backups/postgresql/17-main/2025-06-19T034518Z.dump owned by uid postgres 405s ok 20 - /var/backups/postgresql/17-main/2025-06-19T034518Z.dump owned by gid postgres 405s # basebackup 405s ok 21 - systemctl start pg_receivewal@17-main 406s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 406s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 406s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 406s ok 25 - psql -c 'select pg_reload_conf()' 433s ok 26 - systemctl start pg_basebackup@17-main 433s ok 27 - dump created in /var/backups/postgresql/17-main/2025-06-19T034519Z.backup 433s ok 28 - /var/backups/postgresql/17-main/2025-06-19T034519Z.backup owned by uid postgres 433s ok 29 - /var/backups/postgresql/17-main/2025-06-19T034519Z.backup owned by gid postgres 433s # list 433s ok 30 - pg_backupcluster 17 main list 433s ok 31 - correct output of pg_backupcluster 17 main list 433s # more database changes 434s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 434s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 434s ok 34 - retrieve recovery timestamp 434s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 434s ok 36 - systemctl stop pg_receivewal@17-main 434s # restore /var/backups/postgresql/17-main/2025-06-19T034518Z.dump 436s ok 37 - pg_dropcluster 17 main --stop 440s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T034518Z.dump --start --datadir /var/lib/postgresql/17/snowflake 440s ok 39 - pg_lsclusters -h 440s ok 40 - correct output of pg_lsclusters -h 440s ok 41 - psql -XAtl 440s ok 42 - mydb locales 440s ok 43 - mydb grants 440s ok 44 - myicudb locales 440s ok 45 - psql -XAtc 'show work_mem' 440s ok 46 - correct output of psql -XAtc 'show work_mem' 440s ok 47 - psql -XAtc 'select * from foo' mydb 440s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 440s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 440s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 440s ok 51 - psql -XAtc '\drds' 440s ok 52 - correct output of psql -XAtc '\drds' 440s # restore /var/backups/postgresql/17-main/2025-06-19T034519Z.backup 442s ok 53 - pg_dropcluster 17 main --stop 445s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T034519Z.backup --start --datadir /var/lib/postgresql/17/snowflake 445s ok 55 - pg_lsclusters -h 445s ok 56 - correct output of pg_lsclusters -h 445s ok 57 - psql -XAtl 445s ok 58 - mydb locales 445s ok 59 - mydb grants 445s ok 60 - myicudb locales 445s ok 61 - psql -XAtc 'show work_mem' 445s ok 62 - correct output of psql -XAtc 'show work_mem' 445s ok 63 - psql -XAtc 'select * from foo' mydb 445s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 445s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 445s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 446s ok 67 - psql -XAtc '\drds' 446s ok 68 - correct output of psql -XAtc '\drds' 446s # restore /var/backups/postgresql/17-main/2025-06-19T034519Z.backup with WAL archive 447s ok 69 - pg_dropcluster 17 main --stop 451s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T034519Z.backup --start --archive --port 5430 451s ok 71 - pg_lsclusters -h 451s ok 72 - correct output of pg_lsclusters -h 451s ok 73 - psql -XAtc 'select * from foo order by t' mydb 451s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 451s # restore /var/backups/postgresql/17-main/2025-06-19T034519Z.backup with PITR 452s ok 75 - pg_dropcluster 17 main --stop 456s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-06-19T034519Z.backup --start --pitr '2025-06-19 03:45:47.092487+00 456s # ' 456s ok 77 - pg_lsclusters -h 456s ok 78 - correct output of pg_lsclusters -h 456s ok 79 - psql -XAtc 'select * from foo order by t' mydb 456s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 457s ok 81 - pg_dropcluster 17 main --stop 457s # Cleanup 458s ok 82 - Cleanup: No clusters left behind 458s ok 83 - No postgres processes left behind 458s ok 84 - No files in /etc/postgresql left behind 458s ok 85 - No files in /var/lib/postgresql left behind 458s ok 86 - No files in /var/run/postgresql left behind 458s ok 87 - No files in /var/log/postgresql left behind 458s ok 88 - PostgreSQL TCP ports are closed 458s ok 89 - Next free port is 5432 458s 1..89 458s ### End test 045_backup.t ### 458s 458s ### PostgreSQL test 050_encodings.t ### 458s 1..60 458s # Checking 17 ru_RU 461s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 462s ok 2 - psql -l succeeds 462s ok 3 - template1 is not UTF-8 encoded 462s ok 4 - creating test database 462s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 462s # create table t (x varchar); copy t from stdin" test 462s ok 6 - creating table with ISO-8859-5 characters 462s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 462s ok 8 - correct string in UTF-8 462s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 462s ok 10 - correct string in ISO-8859-5 462s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 462s # delete from t; copy t from stdin" test 462s ok 12 - creating table with UTF-8 characters 462s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 462s ok 14 - correct string in UTF-8 462s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 462s ok 16 - correct string in ISO-8859-1 462s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 462s ok 18 - Server error message has correct language and encoding 464s ok 19 - pg_ctlcluster 17 ru_RU restart 464s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 466s ok 21 - Dropping cluster 466s # Checking 17 ru_RU.UTF-8 469s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 470s ok 23 - psql -l succeeds 470s ok 24 - template1 is UTF-8 encoded 470s ok 25 - creating test database 470s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 470s # create table t (x varchar); copy t from stdin" test 470s ok 27 - creating table with ISO-8859-5 characters 470s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 470s ok 29 - correct string in UTF-8 470s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 470s ok 31 - correct string in ISO-8859-5 470s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 470s # delete from t; copy t from stdin" test 470s ok 33 - creating table with UTF-8 characters 470s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 470s ok 35 - correct string in UTF-8 470s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 470s ok 37 - correct string in ISO-8859-1 470s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 470s ok 39 - Server error message has correct language and encoding 473s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 473s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 473s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 473s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 473s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 473s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 473s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 473s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 474s ok 48 - Dropping cluster 474s # Check 17 locale environment variables 477s ok 49 - pg_createcluster: LC_ALL dominates LANG 478s ok 50 - psql -Atl --cluster 17/main 478s ok 51 - template1 is ASCII encoded 479s ok 52 - Dropping cluster 479s # Cleanup 479s ok 53 - Cleanup: No clusters left behind 479s ok 54 - No postgres processes left behind 479s ok 55 - No files in /etc/postgresql left behind 479s ok 56 - No files in /var/lib/postgresql left behind 479s ok 57 - No files in /var/run/postgresql left behind 479s ok 58 - No files in /var/log/postgresql left behind 479s ok 59 - PostgreSQL TCP ports are closed 479s ok 60 - Next free port is 5432 479s ### End test 050_encodings.t ### 479s 479s ### PostgreSQL test 052_upgrade_encodings.t ### 479s 1..1 479s ok 1 - only one major version installed, skipping upgrade tests 479s ### End test 052_upgrade_encodings.t ### 479s 479s ### PostgreSQL test 060_obsolete_confparams.t ### 479s ok 1 - only one major version installed, skipping upgrade tests 479s 1..1 479s ### End test 060_obsolete_confparams.t ### 479s 479s ### PostgreSQL test 070_non_postgres_clusters.t ### 479s 1..40 480s ok 1 - pg_createcluster 17 main for owner nobody 480s ok 2 - pg_ctlcluster 17 main start 480s ok 3 - start refused when config and data owners mismatch 482s ok 4 - pg_ctlcluster succeeds with owner nobody 482s ok 5 - pg_lsclusters -h 482s ok 6 - pg_lsclusters shows running cluster 482s ok 7 - postgres is running as user nobody 482s ok 8 - ls /tmp/.s.PGSQL.* 482s ok 9 - socket is in /tmp 482s ok 10 - /var/run/postgresql is empty 482s ok 11 - conf dir is owned by user 482s ok 12 - conf dir is owned by user's primary group 482s ok 13 - files are owned by user 482s ok 14 - files are owned by user's primary group 482s ok 15 - log file has 0640 permissions 482s ok 16 - log file is owned by user 482s ok 17 - log file is owned by user's primary group 482s ok 18 - only one major version installed, skipping upgrade test 482s ok 19 - ... 482s ok 20 - ... 482s ok 21 - ... 482s ok 22 - ... 482s ok 23 - ... 482s ok 24 - ... 482s ok 25 - ... 482s ok 26 - ... 482s ok 27 - ... 482s ok 28 - ... 484s ok 29 - pg_dropcluster 484s ok 30 - pg_lsclusters -h 484s ok 31 - No clusters left 484s ok 32 - No postgres processes left 484s # Cleanup 484s ok 33 - Cleanup: No clusters left behind 484s ok 34 - No postgres processes left behind 484s ok 35 - No files in /etc/postgresql left behind 484s ok 36 - No files in /var/lib/postgresql left behind 484s ok 37 - No files in /var/run/postgresql left behind 484s ok 38 - No files in /var/log/postgresql left behind 484s ok 39 - PostgreSQL TCP ports are closed 484s ok 40 - Next free port is 5432 484s ### End test 070_non_postgres_clusters.t ### 484s 484s ### PostgreSQL test 080_start.conf.t ### 484s 1..73 485s ok 1 - pg_createcluster 17 main 485s # start.conf auto 485s ok 2 - get_cluster_start_conf returns auto 485s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 485s ok 4 - start.conf contains auto 485s ok 5 - systemd generator links cluster 485s ok 6 - systemd generator links correct service file 487s ok 7 - /etc/init.d/postgresql start 17 487s ok 8 - correct output of /etc/init.d/postgresql start 17 487s ok 9 - pg_lsclusters -h 487s ok 10 - cluster is online 487s ok 11 - /etc/init.d/postgresql stop 17 487s ok 12 - correct output of /etc/init.d/postgresql stop 17 490s ok 13 - pg_lsclusters -h 490s ok 14 - cluster is down 490s # start.conf manual 490s ok 15 - get_cluster_start_conf returns manual 490s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 490s ok 17 - start.conf contains manual 490s ok 18 - systemd generator doesn't link cluster 490s ok 19 - /etc/init.d/postgresql start 17 490s ok 20 - correct output of /etc/init.d/postgresql start 17 490s ok 21 - pg_lsclusters -h 490s ok 22 - cluster is down 493s ok 23 - pg_ctlcluster 17 main start 493s ok 24 - correct output of pg_ctlcluster 17 main start 493s ok 25 - pg_lsclusters -h 493s ok 26 - cluster is online 493s ok 27 - pg_ctlcluster 17 main stop 493s ok 28 - correct output of pg_ctlcluster 17 main stop 493s ok 29 - pg_lsclusters -h 493s ok 30 - cluster is down 493s # start.conf disabled 493s ok 31 - get_cluster_start_conf returns disabled 493s ok 32 - systemd generator doesn't link cluster 493s ok 33 - /etc/init.d/postgresql start 17 493s ok 34 - correct output of /etc/init.d/postgresql start 17 493s ok 35 - pg_lsclusters -h 493s ok 36 - cluster is down 493s ok 37 - pg_ctlcluster 17 main start 493s ok 38 - correct output of pg_ctlcluster 17 main start 493s ok 39 - pg_lsclusters -h 493s ok 40 - cluster is down 495s ok 41 - pg_ctlcluster 17 main start 495s ok 42 - correct output of pg_ctlcluster 17 main start 495s ok 43 - pg_lsclusters -h 495s ok 44 - cluster is online 496s ok 45 - pg_ctlcluster 17 main stop 496s ok 46 - correct output of pg_ctlcluster 17 main stop 496s ok 47 - pg_lsclusters -h 496s ok 48 - cluster is down 498s ok 49 - pg_ctlcluster 17 main start 498s ok 50 - correct output of pg_ctlcluster 17 main start 498s ok 51 - pg_lsclusters -h 498s ok 52 - cluster is online 498s # test upgrade 498s ok 53 - only one major version installed, skipping upgrade test 498s ok 54 - ... 498s ok 55 - get_cluster_start_conf for old cluster returns manual 498s ok 56 - get_cluster_start_conf for new cluster returns manual 498s ok 57 - ... 499s ok 58 - dropping upgraded cluster 499s ok 59 - pg_lsclusters -h 499s ok 60 - no clusters any more 499s ok 61 - pg_createcluster 17 main --start-conf foo 499s ok 62 - pg_createcluster checks --start-conf validity 500s ok 63 - pg_createcluster checks --start-conf manual 500s ok 64 - get_cluster_start_conf returns manual 501s ok 65 - dropping cluster 501s # Cleanup 501s ok 66 - Cleanup: No clusters left behind 501s ok 67 - No postgres processes left behind 501s ok 68 - No files in /etc/postgresql left behind 501s ok 69 - No files in /var/lib/postgresql left behind 501s ok 70 - No files in /var/run/postgresql left behind 501s ok 71 - No files in /var/log/postgresql left behind 501s ok 72 - PostgreSQL TCP ports are closed 501s ok 73 - Next free port is 5432 501s ### End test 080_start.conf.t ### 501s 501s ### PostgreSQL test 085_pg_ctl.conf.t ### 501s 1..33 501s ok 1 - prlimit --core=0:unlimited --pid=16084 501s ok 2 - set core file size to unlimited 501s ok 3 - sh -c 'ulimit -Hc' 501s ok 4 - core file size is unlimited 502s ok 5 - pg_createcluster 17 main 502s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 504s ok 7 - pg_ctlcluster 17 main start 504s ok 8 - starting cluster as root 504s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 504s ok 10 - soft core size is 0 504s # hard core file size limit of root-started postgres process is unlimited 504s ok 11 - set pg_ctl default option to -c 507s ok 12 - pg_ctlcluster 17 main restart 507s ok 13 - restarting cluster as root 507s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 507s ok 15 - soft core size is unlimited 507s ok 16 - pg_ctlcluster 17 main stop 507s ok 17 - stopping cluster 507s ok 18 - restored pg_ctl default option 509s ok 19 - pg_ctlcluster 17 main start -- -c 509s ok 20 - starting cluster with -c on the command line as postgres 509s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 509s ok 22 - soft core size is unlimited 509s ok 23 - pg_ctlcluster 17 main stop 509s ok 24 - stopping cluster 510s ok 25 - dropping cluster 510s # Cleanup 510s ok 26 - Cleanup: No clusters left behind 510s ok 27 - No postgres processes left behind 510s ok 28 - No files in /etc/postgresql left behind 510s ok 29 - No files in /var/lib/postgresql left behind 510s ok 30 - No files in /var/run/postgresql left behind 510s ok 31 - No files in /var/log/postgresql left behind 510s ok 32 - PostgreSQL TCP ports are closed 510s ok 33 - Next free port is 5432 510s ### End test 085_pg_ctl.conf.t ### 510s 510s ### PostgreSQL test 090_multicluster.t ### 510s 1..125 511s ok 1 - pg_createcluster 17 old 512s ok 2 - pg_createcluster 17 new1 513s ok 3 - pg_createcluster 17 new2 515s ok 4 - starting cluster 17/old 518s ok 5 - starting cluster 17/new1 520s ok 6 - starting cluster 17/new2 520s ok 7 - pg_lsclusters -h | sort -k3 520s ok 8 - clusters have the correct ports, skipping used 5433 520s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 520s ok 10 - createdb --version 520s ok 11 - pg_wrapper selects port 5432 as default cluster 520s ok 12 - createdb --cluster 17/new1 --version 520s ok 13 - pg_wrapper --cluster works 520s ok 14 - createdb --cluster 17/foo --version 520s ok 15 - pg_wrapper --cluster errors out for invalid cluster 520s ok 16 - createdb --cluster 17/new1 test 520s ok 17 - correct output of createdb --cluster 17/new1 test 520s ok 18 - psql -Atl --cluster 17/new1 520s ok 19 - test db appears in cluster new1 520s ok 20 - psql -Atl --cluster 17/new2 520s ok 21 - test db does not appear in cluster new2 520s ok 22 - psql -Atl 520s ok 23 - test db does not appear in default cluster 520s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 520s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 520s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 520s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 520s ok 28 - psql -Atl --cluster 17/localhost:5434 520s ok 29 - test db appears in cluster 17/localhost:5434 520s ok 30 - psql -Atl --cluster 17/localhost:5440 520s ok 31 - test db does not appear in cluster 17/localhost:5440 520s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 520s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 520s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 520s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 520s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 520s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 520s ok 38 - psql -Atl --cluster 6.4/localhost: 520s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 520s ok 40 - psql -Atl 520s ok 41 - PGCLUSTER selection (1) 520s ok 42 - psql -Atl 520s ok 43 - PGCLUSTER selection (2) 520s ok 44 - psql -l 520s ok 45 - invalid PGCLUSTER value 520s ok 46 - createdb --version 520s ok 47 - PGCLUSTER network cluster selection (1) 520s ok 48 - psql -Atl 520s ok 49 - PGCLUSTER network cluster selection (2) 521s ok 50 - psql -Atl 521s ok 51 - PGCLUSTER network cluster selection (3) 521s ok 52 - LC_MESSAGES=C psql -Atl 521s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 521s ok 54 - psql -Atc "show port" template1 521s ok 55 - PGPORT selection (1) 521s ok 56 - psql -Atc "show port" template1 521s ok 57 - PGPORT selection (2) 521s ok 58 - createdb --version 521s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 521s ok 60 - psql -Atc "show port" template1 521s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 521s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 521s ok 63 - PGDATABASE environment variable works 521s ok 64 - createdb --version 521s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 521s ok 66 - createdb --cluster 17/new1 --version 521s ok 67 - pg_wrapper --cluster works with empty user_clusters 521s ok 68 - createdb --version 521s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 521s ok 70 - psql -Atc "select current_database()" 521s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 521s ok 72 - psql -Atc 'select current_database()' 521s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 521s ok 74 - createdb --version 521s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 521s ok 76 - createdb --version 521s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 521s ok 78 - createdb --version 521s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 521s ok 80 - createdb --version 521s ok 81 - pg_wrapper selects correct version with per-user user_clusters 521s ok 82 - createdb --version 521s ok 83 - pg_wrapper selects correct version with per-user user_clusters 521s ok 84 - createdb --version 521s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 521s ok 86 - psql -Atl 521s ok 87 - $PGHOST overrides user_clusters 521s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 521s ok 89 - --cluster overrides $PGHOST 521s ok 90 - createdb --version 521s ok 91 - pg_wrapper ignores invalid lines in user_clusters 521s ok 92 - psql -Atc 'select current_database()' 521s ok 93 - pg_service conf selection 1 521s ok 94 - psql -Atc 'select current_database()' 521s ok 95 - pg_service conf selection 2 521s ok 96 - psql -Atc 'select current_database()' 521s ok 97 - pg_service conf selection 3 521s ok 98 - stopping cluster 17/old 524s ok 99 - restarting cluster 17/old 524s ok 100 - pg_lsclusters -h | sort -k3 524s ok 101 - port of first cluster was successfully changed 524s ok 102 - psql -l 524s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 524s ok 104 - psql -Atl --cluster 17/new1 524s ok 105 - --cluster selects appropriate cluster 524s ok 106 - psql -Atl -p 5434 524s ok 107 - -p selects appropriate cluster 524s ok 108 - psql -Atlp 5434 524s ok 109 - -Atlp selects appropriate cluster 524s ok 110 - psql -Atl --port 5434 524s ok 111 - --port selects appropriate cluster 524s ok 112 - env PGPORT=5434 psql -Atl 524s ok 113 - $PGPORT selects appropriate cluster 524s ok 114 - Restoring original /etc/postgresql-common/user_clusters 526s ok 115 - dropping 17/new1 527s ok 116 - dropping 17/new2 529s ok 117 - dropping 17/old 529s # Cleanup 529s ok 118 - Cleanup: No clusters left behind 529s ok 119 - No postgres processes left behind 529s ok 120 - No files in /etc/postgresql left behind 529s ok 121 - No files in /var/lib/postgresql left behind 529s ok 122 - No files in /var/run/postgresql left behind 529s ok 123 - No files in /var/log/postgresql left behind 529s ok 124 - PostgreSQL TCP ports are closed 529s ok 125 - Next free port is 5432 529s ### End test 090_multicluster.t ### 529s 529s ### PostgreSQL test 110_integrate_cluster.t ### 529s 1..32 530s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/3kC36EKzpi/c/postgres 530s ok 2 - creating raw initdb cluster for user postgres 530s ok 3 - pg_createcluster 17 postgres -d /tmp/3kC36EKzpi/c/postgres 530s ok 4 - integrating postgres cluster 530s ok 5 - pg_lsclusters 530s ok 6 - correct pg_lsclusters output 532s ok 7 - pg_ctlcluster 17 postgres start 532s ok 8 - starting cluster postgres 532s ok 9 - pg_lsclusters 532s ok 10 - correct pg_lsclusters output 534s ok 11 - dropping cluster postgres 534s ok 12 - No files in temporary cluster dir left behind 534s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/3kC36EKzpi/c/nobody 534s ok 14 - creating raw initdb cluster for user nobody 535s ok 15 - pg_createcluster 17 nobody -d /tmp/3kC36EKzpi/c/nobody 535s ok 16 - integrating nobody cluster 535s ok 17 - pg_lsclusters 535s ok 18 - correct pg_lsclusters output 537s ok 19 - pg_ctlcluster 17 nobody start 537s ok 20 - starting cluster nobody 537s ok 21 - pg_lsclusters 537s ok 22 - correct pg_lsclusters output 538s ok 23 - dropping cluster nobody 538s ok 24 - No files in temporary cluster dir left behind 538s # Cleanup 538s ok 25 - Cleanup: No clusters left behind 538s ok 26 - No postgres processes left behind 538s ok 27 - No files in /etc/postgresql left behind 538s ok 28 - No files in /var/lib/postgresql left behind 538s ok 29 - No files in /var/run/postgresql left behind 538s ok 30 - No files in /var/log/postgresql left behind 538s ok 31 - PostgreSQL TCP ports are closed 538s ok 32 - Next free port is 5432 538s ### End test 110_integrate_cluster.t ### 538s 538s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 538s 1..1 538s ok 1 - only one major version installed, skipping upgrade tests 538s ### End test 120_pg_upgradecluster_scripts.t ### 538s 538s ### PostgreSQL test 130_nonroot_admin.t ### 538s 1..22 541s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 541s ok 2 - pg_lsclusters -h 541s ok 3 - correct output of pg_lsclusters -h 541s ok 4 - psql -Atl 541s ok 5 - correct output of psql -Atl 542s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 542s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 542s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 542s # Cleanup 542s ok 15 - Cleanup: No clusters left behind 542s ok 16 - No postgres processes left behind 542s ok 17 - No files in /etc/postgresql left behind 542s ok 18 - No files in /var/lib/postgresql left behind 542s ok 19 - No files in /var/run/postgresql left behind 542s ok 20 - No files in /var/log/postgresql left behind 542s ok 21 - PostgreSQL TCP ports are closed 542s ok 22 - Next free port is 5432 542s ### End test 130_nonroot_admin.t ### 542s 542s ### PostgreSQL test 135_pg_virtualenv.t ### 542s 1..20 546s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 546s ok 2 - running pg_virtualenv as root 549s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 549s ok 4 - running pg_virtualenv as postgres 552s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 552s ok 6 - running pg_virtualenv as nobody 555s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 555s ok 8 - running fakeroot pg_virtualenv as root 558s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 558s ok 10 - running fakeroot pg_virtualenv as postgres 561s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 561s ok 12 - running fakeroot pg_virtualenv as nobody 561s # Cleanup 561s ok 13 - Cleanup: No clusters left behind 562s ok 14 - No postgres processes left behind 562s ok 15 - No files in /etc/postgresql left behind 562s ok 16 - No files in /var/lib/postgresql left behind 562s ok 17 - No files in /var/run/postgresql left behind 562s ok 18 - No files in /var/log/postgresql left behind 562s ok 19 - PostgreSQL TCP ports are closed 562s ok 20 - Next free port is 5432 562s ### End test 135_pg_virtualenv.t ### 562s 562s ### PostgreSQL test 140_pg_config.t ### 562s 1..38 562s # Multiarch is enabled 562s # checking version specific output for 17 562s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 562s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 562s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 562s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 562s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 562s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 562s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 562s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 562s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 562s # checking pg_config output (should behave like version 17) 562s ok 15 - pg_config 562s ok 16 - correct output of pg_config 562s ok 17 - pg_config --help 562s ok 18 - correct output of pg_config --help 562s ok 19 - pg_config --pgxs 562s ok 20 - correct output of pg_config --pgxs 562s ok 21 - pg_config --libdir 562s ok 22 - correct output of pg_config --libdir 562s ok 23 - pg_config --pkglibdir 562s ok 24 - correct output of pg_config --pkglibdir 562s ok 25 - pg_config --bindir 562s ok 26 - correct output of pg_config --bindir 562s # checking pg_config.libpq-dev output (should behave like version 17) 562s ok 27 - pg_config.libpq-dev 562s ok 28 - correct output of pg_config.libpq-dev 562s ok 29 - pg_config.libpq-dev --help 562s ok 30 - correct output of pg_config.libpq-dev --help 562s ok 31 - pg_config.libpq-dev --pgxs 562s ok 32 - correct output of pg_config.libpq-dev --pgxs 562s ok 33 - pg_config.libpq-dev --libdir 562s ok 34 - correct output of pg_config.libpq-dev --libdir 562s ok 35 - pg_config.libpq-dev --pkglibdir 562s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 562s ok 37 - pg_config.libpq-dev --bindir 562s ok 38 - correct output of pg_config.libpq-dev --bindir 562s ### End test 140_pg_config.t ### 562s 562s ### PostgreSQL test 150_tsearch_stemming.t ### 562s 1..37 562s ok 1 - pg_updatedicts succeeded 562s ok 2 - pg_updatedicts created en_us.affix 562s ok 3 - pg_updatedicts created en_us.dict 562s ok 4 - pg_updatedicts created 17 en_us.affix symlink 562s ok 5 - pg_updatedicts created 17 en_us.dict symlink 565s ok 6 - pg_createcluster 17 main 565s ok 7 - createdb fts 565s ok 8 - correct output of createdb fts 565s ok 9 - creating en_US full text search configuration 565s ok 10 - creating data table and search index 565s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 565s ok 12 - stem search of correct word 566s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 566s ok 14 - stem search of correct word 566s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 566s ok 16 - stem search of unknown word 566s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 566s ok 18 - full text search, exact word 566s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 566s ok 20 - full text search for word stem 566s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 566s ok 22 - full text search for word substring fails 566s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 566s ok 24 - full text search, exact unicode word 566s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 566s ok 26 - full text search for unicode word stem 566s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 566s ok 28 - full text search for unicode word substring fails 568s ok 29 568s # Cleanup 568s ok 30 - Cleanup: No clusters left behind 568s ok 31 - No postgres processes left behind 568s ok 32 - No files in /etc/postgresql left behind 568s ok 33 - No files in /var/lib/postgresql left behind 568s ok 34 - No files in /var/run/postgresql left behind 568s ok 35 - No files in /var/log/postgresql left behind 568s ok 36 - PostgreSQL TCP ports are closed 568s ok 37 - Next free port is 5432 568s ### End test 150_tsearch_stemming.t ### 568s 568s ### PostgreSQL test 160_alternate_confroot.t ### 568s 1..28 571s ok 1 571s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 571s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 571s ok 4 - pg_lsclusters -h 571s ok 5 - correct output of pg_lsclusters -h 571s ok 6 - psql -Atl 571s ok 7 - correct output of psql -Atl 571s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 571s ok 9 - ... 571s ok 10 - ... 571s ok 11 - ... 571s ok 12 - ... 571s ok 13 - ... 571s ok 14 - ... 571s ok 15 - pg_dropcluster 17 test --stop 571s ok 16 - correct output of pg_dropcluster 17 test --stop 571s ok 17 - pg_lsclusters -h 571s ok 18 - correct output of pg_lsclusters -h 571s ok 19 - No files in root/data left behind 571s ok 20 - No cruft in root dir left behind 571s # Cleanup 571s ok 21 - Cleanup: No clusters left behind 571s ok 22 - No postgres processes left behind 571s ok 23 - No files in /etc/postgresql left behind 571s ok 24 - No files in /var/lib/postgresql left behind 571s ok 25 - No files in /var/run/postgresql left behind 571s ok 26 - No files in /var/log/postgresql left behind 571s ok 27 - PostgreSQL TCP ports are closed 571s ok 28 - Next free port is 5432 571s ### End test 160_alternate_confroot.t ### 571s 571s ### PostgreSQL test 170_extensions.t ### 571s # Running tests for 17 574s ok 1 - pg_createcluster 17 main 574s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 574s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 574s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 574s ok 5 - extension amcheck installs without error 574s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 574s ok 7 - extension amcheck removes without error 574s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 574s ok 9 - extension autoinc installs without error 574s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 574s ok 11 - extension autoinc removes without error 574s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 574s ok 13 - extension bloom installs without error 574s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 574s ok 15 - extension bloom removes without error 574s ok 16 - psql -qc 'CREATE EXTENSION plperl' 574s ok 17 - bool_plperl dependency plperl installs without error 574s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 574s ok 19 - extension bool_plperl installs without error 574s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 574s ok 21 - extension bool_plperl removes without error 574s ok 22 - psql -qc 'DROP EXTENSION plperl' 574s ok 23 - bool_plperl dependency extension plperl removes without error 575s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 575s ok 25 - bool_plperlu dependency plperlu installs without error 575s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 575s ok 27 - extension bool_plperlu installs without error 575s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 575s ok 29 - extension bool_plperlu removes without error 575s ok 30 - psql -qc 'DROP EXTENSION plperlu' 575s ok 31 - bool_plperlu dependency extension plperlu removes without error 575s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 575s ok 33 - extension btree_gin installs without error 575s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 575s ok 35 - extension btree_gin removes without error 575s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 575s ok 37 - extension btree_gist installs without error 575s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 575s ok 39 - extension btree_gist removes without error 575s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 575s ok 41 - extension citext installs without error 575s ok 42 - psql -qc 'DROP EXTENSION "citext"' 575s ok 43 - extension citext removes without error 575s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 575s ok 45 - extension cube installs without error 575s ok 46 - psql -qc 'DROP EXTENSION "cube"' 575s ok 47 - extension cube removes without error 575s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 575s ok 49 - extension dblink installs without error 575s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 575s ok 51 - extension dblink removes without error 575s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 575s ok 53 - extension dict_int installs without error 575s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 575s ok 55 - extension dict_int removes without error 575s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 575s ok 57 - extension dict_xsyn installs without error 575s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 575s ok 59 - extension dict_xsyn removes without error 575s ok 60 - psql -qc 'CREATE EXTENSION cube' 575s ok 61 - earthdistance dependency cube installs without error 575s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 575s ok 63 - extension earthdistance installs without error 575s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 575s ok 65 - extension earthdistance removes without error 575s ok 66 - psql -qc 'DROP EXTENSION cube' 575s ok 67 - earthdistance dependency extension cube removes without error 575s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 575s ok 69 - extension file_fdw installs without error 575s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 575s ok 71 - extension file_fdw removes without error 575s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 575s ok 73 - extension fuzzystrmatch installs without error 576s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 576s ok 75 - extension fuzzystrmatch removes without error 576s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 576s ok 77 - extension hstore installs without error 576s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 576s ok 79 - extension hstore removes without error 576s ok 80 - psql -qc 'CREATE EXTENSION hstore' 576s ok 81 - hstore_plperl dependency hstore installs without error 576s ok 82 - psql -qc 'CREATE EXTENSION plperl' 576s ok 83 - hstore_plperl dependency plperl installs without error 576s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 576s ok 85 - extension hstore_plperl installs without error 576s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 576s ok 87 - extension hstore_plperl removes without error 576s ok 88 - psql -qc 'DROP EXTENSION hstore' 576s ok 89 - hstore_plperl dependency extension hstore removes without error 576s ok 90 - psql -qc 'DROP EXTENSION plperl' 576s ok 91 - hstore_plperl dependency extension plperl removes without error 576s ok 92 - psql -qc 'CREATE EXTENSION hstore' 576s ok 93 - hstore_plperlu dependency hstore installs without error 576s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 576s ok 95 - hstore_plperlu dependency plperlu installs without error 576s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 576s ok 97 - extension hstore_plperlu installs without error 576s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 576s ok 99 - extension hstore_plperlu removes without error 576s ok 100 - psql -qc 'DROP EXTENSION hstore' 576s ok 101 - hstore_plperlu dependency extension hstore removes without error 576s ok 102 - psql -qc 'DROP EXTENSION plperlu' 576s ok 103 - hstore_plperlu dependency extension plperlu removes without error 576s ok 104 - psql -qc 'CREATE EXTENSION hstore' 576s ok 105 - hstore_plpython3u dependency hstore installs without error 576s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 576s ok 107 - hstore_plpython3u dependency plpython3u installs without error 576s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 576s ok 109 - extension hstore_plpython3u installs without error 576s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 576s ok 111 - extension hstore_plpython3u removes without error 576s ok 112 - psql -qc 'DROP EXTENSION hstore' 576s ok 113 - hstore_plpython3u dependency extension hstore removes without error 576s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 576s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 576s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 576s ok 117 - extension insert_username installs without error 576s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 576s ok 119 - extension insert_username removes without error 576s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 576s ok 121 - extension intagg installs without error 577s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 577s ok 123 - extension intagg removes without error 577s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 577s ok 125 - extension intarray installs without error 577s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 577s ok 127 - extension intarray removes without error 577s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 577s ok 129 - extension isn installs without error 577s ok 130 - psql -qc 'DROP EXTENSION "isn"' 577s ok 131 - extension isn removes without error 577s ok 132 - psql -qc 'CREATE EXTENSION plperl' 577s ok 133 - jsonb_plperl dependency plperl installs without error 577s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 577s ok 135 - extension jsonb_plperl installs without error 577s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 577s ok 137 - extension jsonb_plperl removes without error 577s ok 138 - psql -qc 'DROP EXTENSION plperl' 577s ok 139 - jsonb_plperl dependency extension plperl removes without error 577s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 577s ok 141 - jsonb_plperlu dependency plperlu installs without error 577s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 577s ok 143 - extension jsonb_plperlu installs without error 577s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 577s ok 145 - extension jsonb_plperlu removes without error 577s ok 146 - psql -qc 'DROP EXTENSION plperlu' 577s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 577s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 577s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 577s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 577s ok 151 - extension jsonb_plpython3u installs without error 577s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 577s ok 153 - extension jsonb_plpython3u removes without error 577s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 577s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 577s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 577s ok 157 - extension lo installs without error 577s ok 158 - psql -qc 'DROP EXTENSION "lo"' 577s ok 159 - extension lo removes without error 577s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 577s ok 161 - extension ltree installs without error 577s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 577s ok 163 - extension ltree removes without error 577s ok 164 - psql -qc 'CREATE EXTENSION ltree' 577s ok 165 - ltree_plpython3u dependency ltree installs without error 577s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 577s ok 167 - ltree_plpython3u dependency plpython3u installs without error 578s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 578s ok 169 - extension ltree_plpython3u installs without error 578s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 578s ok 171 - extension ltree_plpython3u removes without error 578s ok 172 - psql -qc 'DROP EXTENSION ltree' 578s ok 173 - ltree_plpython3u dependency extension ltree removes without error 578s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 578s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 578s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 578s ok 177 - extension moddatetime installs without error 578s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 578s ok 179 - extension moddatetime removes without error 578s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 578s ok 181 - extension pageinspect installs without error 578s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 578s ok 183 - extension pageinspect removes without error 578s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 578s ok 185 - extension pg_buffercache installs without error 578s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 578s ok 187 - extension pg_buffercache removes without error 578s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 578s ok 189 - extension pg_freespacemap installs without error 578s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 578s ok 191 - extension pg_freespacemap removes without error 578s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 578s ok 193 - extension pg_prewarm installs without error 578s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 578s ok 195 - extension pg_prewarm removes without error 578s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 578s ok 197 - extension pg_stat_statements installs without error 578s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 578s ok 199 - extension pg_stat_statements removes without error 578s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 578s ok 201 - extension pg_surgery installs without error 578s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 578s ok 203 - extension pg_surgery removes without error 578s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 578s ok 205 - extension pg_trgm installs without error 578s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 578s ok 207 - extension pg_trgm removes without error 578s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 578s ok 209 - extension pg_visibility installs without error 578s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 578s ok 211 - extension pg_visibility removes without error 578s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 578s ok 213 - extension pg_walinspect installs without error 578s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 578s ok 215 - extension pg_walinspect removes without error 578s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 578s ok 217 - extension pgcrypto installs without error 578s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 578s ok 219 - extension pgcrypto removes without error 578s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 578s ok 221 - extension pgrowlocks installs without error 578s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 578s ok 223 - extension pgrowlocks removes without error 579s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 579s ok 225 - extension pgstattuple installs without error 579s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 579s ok 227 - extension pgstattuple removes without error 579s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 579s ok 229 - extension plperl installs without error 579s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 579s ok 231 - extension plperl removes without error 579s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 579s ok 233 - extension plperlu installs without error 579s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 579s ok 235 - extension plperlu removes without error 579s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 579s ok 237 - extension plpython3u installs without error 579s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 579s ok 239 - extension plpython3u removes without error 579s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 579s ok 241 - extension pltcl installs without error 579s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 579s ok 243 - extension pltcl removes without error 579s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 579s ok 245 - extension pltclu installs without error 579s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 579s ok 247 - extension pltclu removes without error 579s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 579s ok 249 - extension postgres_fdw installs without error 579s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 579s ok 251 - extension postgres_fdw removes without error 579s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 579s ok 253 - extension refint installs without error 579s ok 254 - psql -qc 'DROP EXTENSION "refint"' 579s ok 255 - extension refint removes without error 579s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 579s ok 257 - extension seg installs without error 579s ok 258 - psql -qc 'DROP EXTENSION "seg"' 579s ok 259 - extension seg removes without error 579s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 579s ok 261 - extension sslinfo installs without error 579s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 579s ok 263 - extension sslinfo removes without error 579s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 579s ok 265 - extension tablefunc installs without error 579s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 579s ok 267 - extension tablefunc removes without error 579s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 579s ok 269 - extension tcn installs without error 579s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 579s ok 271 - extension tcn removes without error 579s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 579s ok 273 - extension tsm_system_rows installs without error 579s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 579s ok 275 - extension tsm_system_rows removes without error 579s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 579s ok 277 - extension tsm_system_time installs without error 580s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 580s ok 279 - extension tsm_system_time removes without error 580s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 580s ok 281 - extension unaccent installs without error 580s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 580s ok 283 - extension unaccent removes without error 580s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 580s ok 285 - extension uuid-ossp installs without error 580s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 580s ok 287 - extension uuid-ossp removes without error 580s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 580s ok 289 - extension xml2 installs without error 580s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 580s ok 291 - extension xml2 removes without error 581s ok 292 - pg_dropcluster 17 main 581s # Cleanup 581s ok 293 - Cleanup: No clusters left behind 581s ok 294 - No postgres processes left behind 581s ok 295 - No files in /etc/postgresql left behind 581s ok 296 - No files in /var/lib/postgresql left behind 581s ok 297 - No files in /var/run/postgresql left behind 581s ok 298 - No files in /var/log/postgresql left behind 581s ok 299 - PostgreSQL TCP ports are closed 581s ok 300 - Next free port is 5432 581s 1..300 581s ### End test 170_extensions.t ### 581s 581s ### PostgreSQL test 180_ecpg.t ### 581s 1..14 581s ok 1 - ecpg test.pgc 581s ok 2 - ecpg processing 581s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 581s ok 4 - compiling ecpg output 589s ok 5 - pg_virtualenv /tmp/tmp.1FbxJh6BPS/test 589s ok 6 - test program runs and gives correct output 589s # Cleanup 589s ok 7 - Cleanup: No clusters left behind 589s ok 8 - No postgres processes left behind 589s ok 9 - No files in /etc/postgresql left behind 589s ok 10 - No files in /var/lib/postgresql left behind 589s ok 11 - No files in /var/run/postgresql left behind 589s ok 12 - No files in /var/log/postgresql left behind 589s ok 13 - PostgreSQL TCP ports are closed 589s ok 14 - Next free port is 5432 589s ### End test 180_ecpg.t ### 589s 589s ### PostgreSQL test 190_pg_buildext.t ### 589s ok 1 - make clean 589s ok 2 - make tar 589s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 589s # testing 'dh --with pgxs' 592s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 592s ok 5 - postgresql-17-foo_123-1_amd64.deb was built 599s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 599s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 599s ok 8 - dpkg -i postgresql-17-foo_123-1_amd64.deb 606s ok 9 - cd foo-123 && pg_buildext installcheck 606s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 614s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 614s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 621s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 621s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 621s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 621s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 621s ok 17 - dpkg -r postgresql-17-foo 621s # testing 'dh --with pgxs_loop' 621s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 624s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 624s ok 20 - postgresql-17-foo_123-1_amd64.deb was built 624s ok 21 - make clean 624s # testing pg_buildext updatecontrol 624s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 624s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 624s 1..23 624s ### End test 190_pg_buildext.t ### 624s 624s ### PostgreSQL test 200_maintscripts.t ### 624s 1..15 624s # We are running systemd 627s ok 1 - pg_createcluster 17 main --start 627s ok 2 - postmaster PID is 22405 628s ok 3 - apt-get update -q 628s # postgresql-common: 628s # Installed: 279 628s # Candidate: 279 628s # Version table: 628s # *** 279 500 628s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 628s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 628s # 100 /var/lib/dpkg/status 631s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 631s # postgresql-common: 631s # Installed: 279 631s # Candidate: 279 631s # Version table: 631s # *** 279 500 631s # 500 http://ftpmaster.internal/ubuntu questing/main amd64 Packages 631s # 500 http://ftpmaster.internal/ubuntu questing/main i386 Packages 631s # 100 /var/lib/dpkg/status 631s ok 5 - postmaster PID is 22405 631s ok 6 - postmaster was not restarted 633s ok 7 - pg_dropcluster 17 main --stop 633s # Cleanup 633s ok 8 - Cleanup: No clusters left behind 633s ok 9 - No postgres processes left behind 633s ok 10 - No files in /etc/postgresql left behind 633s ok 11 - No files in /var/lib/postgresql left behind 633s ok 12 - No files in /var/run/postgresql left behind 633s ok 13 - No files in /var/log/postgresql left behind 633s ok 14 - PostgreSQL TCP ports are closed 633s ok 15 - Next free port is 5432 633s ### End test 200_maintscripts.t ### 633s 633s autopkgtest [03:49:06]: test run-testsuite: -----------------------] 634s autopkgtest [03:49:07]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 634s run-testsuite PASS 634s autopkgtest [03:49:07]: @@@@@@@@@@@@@@@@@@@@ summary 634s default-psql PASS 634s run-testsuite PASS 653s nova [W] Skipping flock for amd64 653s Creating nova instance adt-questing-amd64-postgresql-common-20250619-033832-juju-7f2275-prod-proposed-migration-environment-2-a0ea3f77-3e0b-4021-bc09-69e58654de2d from image adt/ubuntu-questing-amd64-server-20250619.img (UUID 0ac4ce88-14b4-462b-a8ff-5e89102fdccd)... 653s nova [W] Timed out waiting for 3e09aac5-2aeb-4cbe-9a40-4777dfe9a5dc to get deleted. 653s nova [W] Skipping flock for amd64 653s Creating nova instance adt-questing-amd64-postgresql-common-20250619-033832-juju-7f2275-prod-proposed-migration-environment-2-a0ea3f77-3e0b-4021-bc09-69e58654de2d from image adt/ubuntu-questing-amd64-server-20250619.img (UUID 0ac4ce88-14b4-462b-a8ff-5e89102fdccd)... 653s nova [W] Timed out waiting for a32c484d-4af9-469e-9577-c4b188ee77ab to get deleted.