0s autopkgtest [22:41:34]: starting date and time: 2025-01-02 22:41:34+0000 0s autopkgtest [22:41:34]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [22:41:34]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.nd73axhb/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:debhelper --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=debhelper/13.23ubuntu1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@lcy02-69.secgroup --name adt-plucky-amd64-postgresql-common-20250102-224133-juju-7f2275-prod-proposed-migration-environment-2-afb82e6a-8e2f-4de6-b255-9884e8c364e1 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 85s autopkgtest [22:42:59]: testbed dpkg architecture: amd64 85s autopkgtest [22:42:59]: testbed apt version: 2.9.18 85s autopkgtest [22:42:59]: @@@@@@@@@@@@@@@@@@@@ test bed setup 85s autopkgtest [22:42:59]: testbed release detected to be: None 86s autopkgtest [22:43:00]: updating testbed package index (apt update) 86s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 86s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 86s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 86s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 86s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [652 kB] 86s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 86s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [57.4 kB] 86s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [10.1 kB] 86s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [85.8 kB] 86s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [48.2 kB] 86s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 86s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 86s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [178 kB] 86s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [514 kB] 86s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [8884 B] 86s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [2816 B] 86s Fetched 1683 kB in 0s (6488 kB/s) 87s Reading package lists... 87s Reading package lists... 88s Building dependency tree... 88s Reading state information... 88s Calculating upgrade... 88s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 88s Reading package lists... 88s Building dependency tree... 88s Reading state information... 89s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 89s autopkgtest [22:43:03]: upgrading testbed (apt dist-upgrade and autopurge) 89s Reading package lists... 89s Building dependency tree... 89s Reading state information... 90s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 90s Starting 2 pkgProblemResolver with broken count: 0 90s Done 90s Entering ResolveByKeep 90s 90s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 91s Reading package lists... 91s Building dependency tree... 91s Reading state information... 91s Starting pkgProblemResolver with broken count: 0 91s Starting 2 pkgProblemResolver with broken count: 0 91s Done 91s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 92s autopkgtest [22:43:06]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 92s autopkgtest [22:43:06]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 94s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (dsc) [2383 B] 94s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 262 (tar) [218 kB] 94s gpgv: Signature made Thu Aug 8 15:27:49 2024 UTC 94s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 94s gpgv: Can't check signature: No public key 94s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_262.dsc: no acceptable signature found 95s autopkgtest [22:43:09]: testing package postgresql-common version 262 95s autopkgtest [22:43:09]: build not needed 95s autopkgtest [22:43:09]: test default-psql: preparing testbed 95s Reading package lists... 95s Building dependency tree... 95s Reading state information... 96s Starting pkgProblemResolver with broken count: 0 96s Starting 2 pkgProblemResolver with broken count: 0 96s Done 96s The following NEW packages will be installed: 96s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 96s postgresql-client-common postgresql-common ssl-cert 96s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 96s Need to get 17.1 MB of archives. 96s After this operation, 51.0 MB of additional disk space will be used. 96s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 96s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 96s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 96s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 96s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 96s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 96s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-16 amd64 16.4-3 [1278 kB] 96s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-16 amd64 16.4-3 [15.2 MB] 96s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql all 16+262 [11.8 kB] 97s Preconfiguring packages ... 97s Fetched 17.1 MB in 0s (36.4 MB/s) 97s Selecting previously unselected package libjson-perl. 97s (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 ... 75804 files and directories currently installed.) 97s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 97s Unpacking libjson-perl (4.10000-1) ... 97s Selecting previously unselected package postgresql-client-common. 97s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 97s Unpacking postgresql-client-common (262) ... 97s Selecting previously unselected package ssl-cert. 97s Preparing to unpack .../2-ssl-cert_1.1.3ubuntu1_all.deb ... 97s Unpacking ssl-cert (1.1.3ubuntu1) ... 97s Selecting previously unselected package postgresql-common. 97s Preparing to unpack .../3-postgresql-common_262_all.deb ... 97s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 97s Unpacking postgresql-common (262) ... 97s Selecting previously unselected package libpq5:amd64. 97s Preparing to unpack .../4-libpq5_17.2-1_amd64.deb ... 97s Unpacking libpq5:amd64 (17.2-1) ... 97s Selecting previously unselected package libxslt1.1:amd64. 97s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 97s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 97s Selecting previously unselected package postgresql-client-16. 97s Preparing to unpack .../6-postgresql-client-16_16.4-3_amd64.deb ... 97s Unpacking postgresql-client-16 (16.4-3) ... 97s Selecting previously unselected package postgresql-16. 97s Preparing to unpack .../7-postgresql-16_16.4-3_amd64.deb ... 97s Unpacking postgresql-16 (16.4-3) ... 98s Selecting previously unselected package postgresql. 98s Preparing to unpack .../8-postgresql_16+262_all.deb ... 98s Unpacking postgresql (16+262) ... 98s Setting up postgresql-client-common (262) ... 98s Setting up libpq5:amd64 (17.2-1) ... 98s Setting up ssl-cert (1.1.3ubuntu1) ... 98s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 99s Setting up libjson-perl (4.10000-1) ... 99s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 99s Setting up postgresql-client-16 (16.4-3) ... 99s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 99s Setting up postgresql-common (262) ... 100s Creating config file /etc/postgresql-common/createcluster.conf with new version 100s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 100s Removing obsolete dictionary files: 100s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 101s Setting up postgresql-16 (16.4-3) ... 101s Creating new PostgreSQL cluster 16/main ... 101s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 101s The files belonging to this database system will be owned by user "postgres". 101s This user must also own the server process. 101s 101s The database cluster will be initialized with locale "C.UTF-8". 101s The default database encoding has accordingly been set to "UTF8". 101s The default text search configuration will be set to "english". 101s 101s Data page checksums are disabled. 101s 101s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 101s creating subdirectories ... ok 101s selecting dynamic shared memory implementation ... posix 101s selecting default max_connections ... 100 101s selecting default shared_buffers ... 128MB 101s selecting default time zone ... Etc/UTC 101s creating configuration files ... ok 101s running bootstrap script ... ok 102s performing post-bootstrap initialization ... ok 102s syncing data to disk ... ok 105s Setting up postgresql (16+262) ... 105s Processing triggers for man-db (2.13.0-1) ... 107s Processing triggers for libc-bin (2.40-4ubuntu1) ... 107s autopkgtest [22:43:21]: test default-psql: [----------------------- 108s autopkgtest [22:43:22]: test default-psql: -----------------------] 108s autopkgtest [22:43:22]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 108s default-psql PASS 108s autopkgtest [22:43:22]: test run-testsuite: preparing testbed 177s autopkgtest [22:44:31]: testbed dpkg architecture: amd64 177s autopkgtest [22:44:31]: testbed apt version: 2.9.18 177s autopkgtest [22:44:31]: @@@@@@@@@@@@@@@@@@@@ test bed setup 177s autopkgtest [22:44:31]: testbed release detected to be: plucky 177s autopkgtest [22:44:31]: updating testbed package index (apt update) 177s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 177s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 177s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 177s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 177s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [10.1 kB] 177s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [652 kB] 177s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 177s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [57.4 kB] 177s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [85.8 kB] 177s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [48.2 kB] 177s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 177s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 177s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [514 kB] 177s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [178 kB] 177s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [2816 B] 177s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [8884 B] 178s Fetched 1683 kB in 0s (4957 kB/s) 178s Reading package lists... 179s Reading package lists... 179s Building dependency tree... 179s Reading state information... 179s Calculating upgrade... 179s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 179s Reading package lists... 180s Building dependency tree... 180s Reading state information... 180s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 180s autopkgtest [22:44:34]: upgrading testbed (apt dist-upgrade and autopurge) 180s Reading package lists... 180s Building dependency tree... 180s Reading state information... 181s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 181s Starting 2 pkgProblemResolver with broken count: 0 181s Done 182s Entering ResolveByKeep 182s 182s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 182s Reading package lists... 183s Building dependency tree... 183s Reading state information... 183s Starting pkgProblemResolver with broken count: 0 183s Starting 2 pkgProblemResolver with broken count: 0 183s Done 183s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 184s Reading package lists... 184s Building dependency tree... 184s Reading state information... 184s Starting pkgProblemResolver with broken count: 0 184s Starting 2 pkgProblemResolver with broken count: 0 184s Done 185s The following NEW packages will be installed: 185s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 185s cpp-14 cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 185s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 185s fakeroot g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 185s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 185s icu-devtools intltool-debian libarchive-zip-perl libasan8 libcc1-0 185s libclang-common-19-dev libclang-cpp19 libdebhelper-perl libecpg-compat3 185s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 185s libgc1 libgcc-14-dev libgomp1 libhwasan0 libicu-dev libisl23 libitm1 185s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 185s libpgtypes3 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev 185s libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 llvm-19 185s llvm-19-dev llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all 185s m4 po-debconf postgresql-16 postgresql-all postgresql-client-16 185s postgresql-client-common postgresql-common postgresql-doc postgresql-doc-16 185s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 185s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert 185s 0 upgraded, 89 newly installed, 0 to remove and 0 not upgraded. 185s Need to get 204 MB of archives. 185s After this operation, 1162 MB of additional disk space will be used. 185s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 185s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 185s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 185s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 185s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 185s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 autoconf all 2.72-3 [382 kB] 185s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 autotools-dev all 20220109.1 [44.9 kB] 185s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 185s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 autopoint all 0.22.5-3 [616 kB] 185s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libisl23 amd64 0.27-1 [685 kB] 185s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 185s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-12ubuntu1 [11.9 MB] 185s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14 amd64 14.2.0-12ubuntu1 [1036 B] 185s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [5452 B] 185s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp amd64 4:14.1.0-2ubuntu1 [22.4 kB] 185s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 libcc1-0 amd64 14.2.0-12ubuntu1 [47.6 kB] 185s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 libgomp1 amd64 14.2.0-12ubuntu1 [148 kB] 185s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libitm1 amd64 14.2.0-12ubuntu1 [28.9 kB] 185s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 libasan8 amd64 14.2.0-12ubuntu1 [2998 kB] 185s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 liblsan0 amd64 14.2.0-12ubuntu1 [1317 kB] 186s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 libtsan2 amd64 14.2.0-12ubuntu1 [2732 kB] 186s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 libubsan1 amd64 14.2.0-12ubuntu1 [1177 kB] 186s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 libhwasan0 amd64 14.2.0-12ubuntu1 [1634 kB] 186s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 libquadmath0 amd64 14.2.0-12ubuntu1 [153 kB] 186s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 libgcc-14-dev amd64 14.2.0-12ubuntu1 [2815 kB] 186s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-12ubuntu1 [23.3 MB] 187s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14 amd64 14.2.0-12ubuntu1 [533 kB] 187s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [1214 B] 187s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc amd64 4:14.1.0-2ubuntu1 [5000 B] 187s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 libstdc++-14-dev amd64 14.2.0-12ubuntu1 [2506 kB] 187s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-12ubuntu1 [13.3 MB] 187s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14 amd64 14.2.0-12ubuntu1 [20.2 kB] 187s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [966 B] 187s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 g++ amd64 4:14.1.0-2ubuntu1 [1100 B] 187s Get:35 http://ftpmaster.internal/ubuntu plucky/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 187s Get:36 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-cpp19 amd64 1:19.1.6-1ubuntu1 [14.2 MB] 187s Get:37 http://ftpmaster.internal/ubuntu plucky/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 187s Get:38 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc4 amd64 14.2.0-12ubuntu1 [47.0 kB] 187s Get:39 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc-14-dev amd64 14.2.0-12ubuntu1 [194 kB] 187s Get:40 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-common-19-dev amd64 1:19.1.6-1ubuntu1 [743 kB] 187s Get:41 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-linker-tools amd64 1:19.1.6-1ubuntu1 [1325 kB] 187s Get:42 http://ftpmaster.internal/ubuntu plucky/universe amd64 clang-19 amd64 1:19.1.6-1ubuntu1 [78.9 kB] 187s Get:43 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libdebhelper-perl all 13.23ubuntu1 [95.1 kB] 187s Get:44 http://ftpmaster.internal/ubuntu plucky/main amd64 libtool all 2.4.7-8 [166 kB] 187s Get:45 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-autoreconf all 20 [16.1 kB] 187s Get:46 http://ftpmaster.internal/ubuntu plucky/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 187s Get:47 http://ftpmaster.internal/ubuntu plucky/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 187s Get:48 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 187s Get:49 http://ftpmaster.internal/ubuntu plucky/main amd64 debugedit amd64 1:5.1-1 [46.9 kB] 187s Get:50 http://ftpmaster.internal/ubuntu plucky/main amd64 dwz amd64 0.15-1build6 [115 kB] 187s Get:51 http://ftpmaster.internal/ubuntu plucky/main amd64 gettext amd64 0.22.5-3 [1025 kB] 187s Get:52 http://ftpmaster.internal/ubuntu plucky/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 187s Get:53 http://ftpmaster.internal/ubuntu plucky/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 187s Get:54 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 debhelper all 13.23ubuntu1 [895 kB] 187s Get:55 http://ftpmaster.internal/ubuntu plucky/main amd64 emacsen-common all 3.0.5 [12.1 kB] 187s Get:56 http://ftpmaster.internal/ubuntu plucky/main amd64 dictionaries-common all 1.30.2 [176 kB] 187s Get:57 http://ftpmaster.internal/ubuntu plucky/main amd64 libfakeroot amd64 1.36.2-1 [33.8 kB] 187s Get:58 http://ftpmaster.internal/ubuntu plucky/main amd64 fakeroot amd64 1.36.2-1 [67.9 kB] 187s Get:59 http://ftpmaster.internal/ubuntu plucky/main amd64 hunspell-en-us all 1:2020.12.07-3 [586 kB] 187s Get:60 http://ftpmaster.internal/ubuntu plucky/main amd64 icu-devtools amd64 74.2-1ubuntu4 [213 kB] 187s Get:61 http://ftpmaster.internal/ubuntu plucky/main amd64 libpgtypes3 amd64 17.2-1 [45.0 kB] 187s Get:62 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 187s Get:63 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg6 amd64 17.2-1 [51.7 kB] 187s Get:64 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-compat3 amd64 17.2-1 [13.2 kB] 187s Get:65 http://ftpmaster.internal/ubuntu plucky/main amd64 libssl-dev amd64 3.4.0-1ubuntu2 [2874 kB] 187s Get:66 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq-dev amd64 17.2-1 [158 kB] 187s Get:67 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-dev amd64 17.2-1 [276 kB] 187s Get:68 http://ftpmaster.internal/ubuntu plucky/main amd64 libicu-dev amd64 74.2-1ubuntu4 [11.9 MB] 187s Get:69 http://ftpmaster.internal/ubuntu plucky/main amd64 libncurses-dev amd64 6.5-2 [384 kB] 187s Get:70 http://ftpmaster.internal/ubuntu plucky/main amd64 libtcl8.6 amd64 8.6.15+dfsg-2 [1085 kB] 187s Get:71 http://ftpmaster.internal/ubuntu plucky/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.2build1 [786 kB] 187s Get:72 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 187s Get:73 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-runtime amd64 1:19.1.6-1ubuntu1 [554 kB] 187s Get:74 http://ftpmaster.internal/ubuntu plucky/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 187s Get:75 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19 amd64 1:19.1.6-1ubuntu1 [17.8 MB] 188s Get:76 http://ftpmaster.internal/ubuntu plucky/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 188s Get:77 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-tools amd64 1:19.1.6-1ubuntu1 [540 kB] 188s Get:78 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-dev amd64 1:19.1.6-1ubuntu1 [47.3 MB] 188s Get:79 http://ftpmaster.internal/ubuntu plucky/universe amd64 locales-all amd64 2.40-4ubuntu1 [11.1 MB] 189s Get:80 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-16 amd64 16.4-3 [1278 kB] 189s Get:81 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-16 amd64 16.4-3 [15.2 MB] 189s Get:82 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-16 amd64 16.4-3 [1220 kB] 189s Get:83 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-all amd64 262 [20.7 kB] 189s Get:84 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plperl-16 amd64 16.4-3 [62.7 kB] 189s Get:85 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plpython3-16 amd64 16.4-3 [72.4 kB] 189s Get:86 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-pltcl-16 amd64 16.4-3 [27.2 kB] 189s Get:87 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-all all 262 [1710 B] 189s Get:88 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-doc-16 all 16.4-3 [2098 kB] 189s Get:89 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-doc all 16+262 [11.8 kB] 189s Preconfiguring packages ... 189s Fetched 204 MB in 4s (53.4 MB/s) 189s Selecting previously unselected package libjson-perl. 190s (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 ... 75804 files and directories currently installed.) 190s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 190s Unpacking libjson-perl (4.10000-1) ... 190s Selecting previously unselected package postgresql-client-common. 190s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 190s Unpacking postgresql-client-common (262) ... 190s Selecting previously unselected package ssl-cert. 190s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 190s Unpacking ssl-cert (1.1.3ubuntu1) ... 190s Selecting previously unselected package postgresql-common. 190s Preparing to unpack .../03-postgresql-common_262_all.deb ... 190s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 190s Unpacking postgresql-common (262) ... 190s Selecting previously unselected package m4. 190s Preparing to unpack .../04-m4_1.4.19-4build1_amd64.deb ... 190s Unpacking m4 (1.4.19-4build1) ... 190s Selecting previously unselected package autoconf. 190s Preparing to unpack .../05-autoconf_2.72-3_all.deb ... 190s Unpacking autoconf (2.72-3) ... 190s Selecting previously unselected package autotools-dev. 190s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 190s Unpacking autotools-dev (20220109.1) ... 190s Selecting previously unselected package automake. 190s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 190s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 190s Selecting previously unselected package autopoint. 190s Preparing to unpack .../08-autopoint_0.22.5-3_all.deb ... 190s Unpacking autopoint (0.22.5-3) ... 190s Selecting previously unselected package libisl23:amd64. 190s Preparing to unpack .../09-libisl23_0.27-1_amd64.deb ... 190s Unpacking libisl23:amd64 (0.27-1) ... 190s Selecting previously unselected package libmpc3:amd64. 190s Preparing to unpack .../10-libmpc3_1.3.1-1build2_amd64.deb ... 190s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 190s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 190s Preparing to unpack .../11-cpp-14-x86-64-linux-gnu_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 190s Selecting previously unselected package cpp-14. 190s Preparing to unpack .../12-cpp-14_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking cpp-14 (14.2.0-12ubuntu1) ... 190s Selecting previously unselected package cpp-x86-64-linux-gnu. 190s Preparing to unpack .../13-cpp-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 190s Unpacking cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 190s Selecting previously unselected package cpp. 190s Preparing to unpack .../14-cpp_4%3a14.1.0-2ubuntu1_amd64.deb ... 190s Unpacking cpp (4:14.1.0-2ubuntu1) ... 190s Selecting previously unselected package libcc1-0:amd64. 190s Preparing to unpack .../15-libcc1-0_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking libcc1-0:amd64 (14.2.0-12ubuntu1) ... 190s Selecting previously unselected package libgomp1:amd64. 190s Preparing to unpack .../16-libgomp1_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking libgomp1:amd64 (14.2.0-12ubuntu1) ... 190s Selecting previously unselected package libitm1:amd64. 190s Preparing to unpack .../17-libitm1_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking libitm1:amd64 (14.2.0-12ubuntu1) ... 190s Selecting previously unselected package libasan8:amd64. 190s Preparing to unpack .../18-libasan8_14.2.0-12ubuntu1_amd64.deb ... 190s Unpacking libasan8:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package liblsan0:amd64. 191s Preparing to unpack .../19-liblsan0_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking liblsan0:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package libtsan2:amd64. 191s Preparing to unpack .../20-libtsan2_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libtsan2:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package libubsan1:amd64. 191s Preparing to unpack .../21-libubsan1_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libubsan1:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package libhwasan0:amd64. 191s Preparing to unpack .../22-libhwasan0_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libhwasan0:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package libquadmath0:amd64. 191s Preparing to unpack .../23-libquadmath0_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libquadmath0:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package libgcc-14-dev:amd64. 191s Preparing to unpack .../24-libgcc-14-dev_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libgcc-14-dev:amd64 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 191s Preparing to unpack .../25-gcc-14-x86-64-linux-gnu_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package gcc-14. 191s Preparing to unpack .../26-gcc-14_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking gcc-14 (14.2.0-12ubuntu1) ... 191s Selecting previously unselected package gcc-x86-64-linux-gnu. 191s Preparing to unpack .../27-gcc-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 191s Unpacking gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 191s Selecting previously unselected package gcc. 191s Preparing to unpack .../28-gcc_4%3a14.1.0-2ubuntu1_amd64.deb ... 191s Unpacking gcc (4:14.1.0-2ubuntu1) ... 191s Selecting previously unselected package libstdc++-14-dev:amd64. 191s Preparing to unpack .../29-libstdc++-14-dev_14.2.0-12ubuntu1_amd64.deb ... 191s Unpacking libstdc++-14-dev:amd64 (14.2.0-12ubuntu1) ... 192s Selecting previously unselected package g++-14-x86-64-linux-gnu. 192s Preparing to unpack .../30-g++-14-x86-64-linux-gnu_14.2.0-12ubuntu1_amd64.deb ... 192s Unpacking g++-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 192s Selecting previously unselected package g++-14. 192s Preparing to unpack .../31-g++-14_14.2.0-12ubuntu1_amd64.deb ... 192s Unpacking g++-14 (14.2.0-12ubuntu1) ... 192s Selecting previously unselected package g++-x86-64-linux-gnu. 192s Preparing to unpack .../32-g++-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 192s Unpacking g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 192s Selecting previously unselected package g++. 192s Preparing to unpack .../33-g++_4%3a14.1.0-2ubuntu1_amd64.deb ... 192s Unpacking g++ (4:14.1.0-2ubuntu1) ... 192s Selecting previously unselected package build-essential. 192s Preparing to unpack .../34-build-essential_12.10ubuntu1_amd64.deb ... 192s Unpacking build-essential (12.10ubuntu1) ... 192s Selecting previously unselected package libclang-cpp19. 192s Preparing to unpack .../35-libclang-cpp19_1%3a19.1.6-1ubuntu1_amd64.deb ... 192s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 192s Selecting previously unselected package libgc1:amd64. 192s Preparing to unpack .../36-libgc1_1%3a8.2.8-1_amd64.deb ... 192s Unpacking libgc1:amd64 (1:8.2.8-1) ... 192s Selecting previously unselected package libobjc4:amd64. 192s Preparing to unpack .../37-libobjc4_14.2.0-12ubuntu1_amd64.deb ... 192s Unpacking libobjc4:amd64 (14.2.0-12ubuntu1) ... 192s Selecting previously unselected package libobjc-14-dev:amd64. 192s Preparing to unpack .../38-libobjc-14-dev_14.2.0-12ubuntu1_amd64.deb ... 192s Unpacking libobjc-14-dev:amd64 (14.2.0-12ubuntu1) ... 192s Selecting previously unselected package libclang-common-19-dev:amd64. 192s Preparing to unpack .../39-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_amd64.deb ... 192s Unpacking libclang-common-19-dev:amd64 (1:19.1.6-1ubuntu1) ... 192s Selecting previously unselected package llvm-19-linker-tools. 192s Preparing to unpack .../40-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_amd64.deb ... 192s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 193s Selecting previously unselected package clang-19. 193s Preparing to unpack .../41-clang-19_1%3a19.1.6-1ubuntu1_amd64.deb ... 193s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 193s Selecting previously unselected package libdebhelper-perl. 193s Preparing to unpack .../42-libdebhelper-perl_13.23ubuntu1_all.deb ... 193s Unpacking libdebhelper-perl (13.23ubuntu1) ... 193s Selecting previously unselected package libtool. 193s Preparing to unpack .../43-libtool_2.4.7-8_all.deb ... 193s Unpacking libtool (2.4.7-8) ... 193s Selecting previously unselected package dh-autoreconf. 193s Preparing to unpack .../44-dh-autoreconf_20_all.deb ... 193s Unpacking dh-autoreconf (20) ... 193s Selecting previously unselected package libarchive-zip-perl. 193s Preparing to unpack .../45-libarchive-zip-perl_1.68-1_all.deb ... 193s Unpacking libarchive-zip-perl (1.68-1) ... 193s Selecting previously unselected package libfile-stripnondeterminism-perl. 193s Preparing to unpack .../46-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 193s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 193s Selecting previously unselected package dh-strip-nondeterminism. 193s Preparing to unpack .../47-dh-strip-nondeterminism_1.14.0-1_all.deb ... 193s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 193s Selecting previously unselected package debugedit. 193s Preparing to unpack .../48-debugedit_1%3a5.1-1_amd64.deb ... 193s Unpacking debugedit (1:5.1-1) ... 193s Selecting previously unselected package dwz. 193s Preparing to unpack .../49-dwz_0.15-1build6_amd64.deb ... 193s Unpacking dwz (0.15-1build6) ... 193s Selecting previously unselected package gettext. 193s Preparing to unpack .../50-gettext_0.22.5-3_amd64.deb ... 193s Unpacking gettext (0.22.5-3) ... 193s Selecting previously unselected package intltool-debian. 193s Preparing to unpack .../51-intltool-debian_0.35.0+20060710.6_all.deb ... 193s Unpacking intltool-debian (0.35.0+20060710.6) ... 193s Selecting previously unselected package po-debconf. 193s Preparing to unpack .../52-po-debconf_1.0.21+nmu1_all.deb ... 193s Unpacking po-debconf (1.0.21+nmu1) ... 193s Selecting previously unselected package debhelper. 193s Preparing to unpack .../53-debhelper_13.23ubuntu1_all.deb ... 193s Unpacking debhelper (13.23ubuntu1) ... 193s Selecting previously unselected package emacsen-common. 193s Preparing to unpack .../54-emacsen-common_3.0.5_all.deb ... 193s Unpacking emacsen-common (3.0.5) ... 193s Selecting previously unselected package dictionaries-common. 193s Preparing to unpack .../55-dictionaries-common_1.30.2_all.deb ... 193s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 193s Unpacking dictionaries-common (1.30.2) ... 193s Selecting previously unselected package libfakeroot:amd64. 193s Preparing to unpack .../56-libfakeroot_1.36.2-1_amd64.deb ... 193s Unpacking libfakeroot:amd64 (1.36.2-1) ... 193s Selecting previously unselected package fakeroot. 193s Preparing to unpack .../57-fakeroot_1.36.2-1_amd64.deb ... 193s Unpacking fakeroot (1.36.2-1) ... 193s Selecting previously unselected package hunspell-en-us. 193s Preparing to unpack .../58-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 193s Unpacking hunspell-en-us (1:2020.12.07-3) ... 193s Selecting previously unselected package icu-devtools. 193s Preparing to unpack .../59-icu-devtools_74.2-1ubuntu4_amd64.deb ... 193s Unpacking icu-devtools (74.2-1ubuntu4) ... 193s Selecting previously unselected package libpgtypes3:amd64. 193s Preparing to unpack .../60-libpgtypes3_17.2-1_amd64.deb ... 193s Unpacking libpgtypes3:amd64 (17.2-1) ... 193s Selecting previously unselected package libpq5:amd64. 193s Preparing to unpack .../61-libpq5_17.2-1_amd64.deb ... 193s Unpacking libpq5:amd64 (17.2-1) ... 193s Selecting previously unselected package libecpg6:amd64. 193s Preparing to unpack .../62-libecpg6_17.2-1_amd64.deb ... 193s Unpacking libecpg6:amd64 (17.2-1) ... 193s Selecting previously unselected package libecpg-compat3:amd64. 193s Preparing to unpack .../63-libecpg-compat3_17.2-1_amd64.deb ... 193s Unpacking libecpg-compat3:amd64 (17.2-1) ... 193s Selecting previously unselected package libssl-dev:amd64. 193s Preparing to unpack .../64-libssl-dev_3.4.0-1ubuntu2_amd64.deb ... 193s Unpacking libssl-dev:amd64 (3.4.0-1ubuntu2) ... 194s Selecting previously unselected package libpq-dev. 194s Preparing to unpack .../65-libpq-dev_17.2-1_amd64.deb ... 194s Unpacking libpq-dev (17.2-1) ... 194s Selecting previously unselected package libecpg-dev. 194s Preparing to unpack .../66-libecpg-dev_17.2-1_amd64.deb ... 194s Unpacking libecpg-dev (17.2-1) ... 194s Selecting previously unselected package libicu-dev:amd64. 194s Preparing to unpack .../67-libicu-dev_74.2-1ubuntu4_amd64.deb ... 194s Unpacking libicu-dev:amd64 (74.2-1ubuntu4) ... 194s Selecting previously unselected package libncurses-dev:amd64. 194s Preparing to unpack .../68-libncurses-dev_6.5-2_amd64.deb ... 194s Unpacking libncurses-dev:amd64 (6.5-2) ... 194s Selecting previously unselected package libtcl8.6:amd64. 194s Preparing to unpack .../69-libtcl8.6_8.6.15+dfsg-2_amd64.deb ... 194s Unpacking libtcl8.6:amd64 (8.6.15+dfsg-2) ... 194s Selecting previously unselected package libxml2-dev:amd64. 194s Preparing to unpack .../70-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2build1_amd64.deb ... 194s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.2build1) ... 194s Selecting previously unselected package libxslt1.1:amd64. 194s Preparing to unpack .../71-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 194s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 194s Selecting previously unselected package llvm-19-runtime. 194s Preparing to unpack .../72-llvm-19-runtime_1%3a19.1.6-1ubuntu1_amd64.deb ... 194s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 194s Selecting previously unselected package libpfm4:amd64. 194s Preparing to unpack .../73-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 194s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 194s Selecting previously unselected package llvm-19. 194s Preparing to unpack .../74-llvm-19_1%3a19.1.6-1ubuntu1_amd64.deb ... 194s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 195s Selecting previously unselected package libffi-dev:amd64. 195s Preparing to unpack .../75-libffi-dev_3.4.6-1build1_amd64.deb ... 195s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 195s Selecting previously unselected package llvm-19-tools. 195s Preparing to unpack .../76-llvm-19-tools_1%3a19.1.6-1ubuntu1_amd64.deb ... 195s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 195s Selecting previously unselected package llvm-19-dev. 195s Preparing to unpack .../77-llvm-19-dev_1%3a19.1.6-1ubuntu1_amd64.deb ... 195s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 196s Selecting previously unselected package locales-all. 196s Preparing to unpack .../78-locales-all_2.40-4ubuntu1_amd64.deb ... 196s Unpacking locales-all (2.40-4ubuntu1) ... 198s Selecting previously unselected package postgresql-client-16. 198s Preparing to unpack .../79-postgresql-client-16_16.4-3_amd64.deb ... 198s Unpacking postgresql-client-16 (16.4-3) ... 198s Selecting previously unselected package postgresql-16. 198s Preparing to unpack .../80-postgresql-16_16.4-3_amd64.deb ... 198s Unpacking postgresql-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-server-dev-16. 199s Preparing to unpack .../81-postgresql-server-dev-16_16.4-3_amd64.deb ... 199s Unpacking postgresql-server-dev-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-server-dev-all:amd64. 199s Preparing to unpack .../82-postgresql-server-dev-all_262_amd64.deb ... 199s Unpacking postgresql-server-dev-all:amd64 (262) ... 199s Selecting previously unselected package postgresql-plperl-16. 199s Preparing to unpack .../83-postgresql-plperl-16_16.4-3_amd64.deb ... 199s Unpacking postgresql-plperl-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-plpython3-16. 199s Preparing to unpack .../84-postgresql-plpython3-16_16.4-3_amd64.deb ... 199s Unpacking postgresql-plpython3-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-pltcl-16. 199s Preparing to unpack .../85-postgresql-pltcl-16_16.4-3_amd64.deb ... 199s Unpacking postgresql-pltcl-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-all. 199s Preparing to unpack .../86-postgresql-all_262_all.deb ... 199s Unpacking postgresql-all (262) ... 199s Selecting previously unselected package postgresql-doc-16. 199s Preparing to unpack .../87-postgresql-doc-16_16.4-3_all.deb ... 199s Unpacking postgresql-doc-16 (16.4-3) ... 199s Selecting previously unselected package postgresql-doc. 199s Preparing to unpack .../88-postgresql-doc_16+262_all.deb ... 199s Unpacking postgresql-doc (16+262) ... 199s Setting up postgresql-client-common (262) ... 199s Setting up libpgtypes3:amd64 (17.2-1) ... 199s Setting up libncurses-dev:amd64 (6.5-2) ... 199s Setting up libclang-common-19-dev:amd64 (1:19.1.6-1ubuntu1) ... 199s Setting up postgresql-doc-16 (16.4-3) ... 200s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 200s Setting up libarchive-zip-perl (1.68-1) ... 200s Setting up libdebhelper-perl (13.23ubuntu1) ... 200s Setting up libpq5:amd64 (17.2-1) ... 200s Setting up m4 (1.4.19-4build1) ... 200s Setting up libgomp1:amd64 (14.2.0-12ubuntu1) ... 200s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 200s Setting up locales-all (2.40-4ubuntu1) ... 200s Setting up libfakeroot:amd64 (1.36.2-1) ... 200s Setting up fakeroot (1.36.2-1) ... 200s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 200s Setting up autotools-dev (20220109.1) ... 200s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 200s Setting up emacsen-common (3.0.5) ... 200s Setting up ssl-cert (1.1.3ubuntu1) ... 200s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 201s Setting up libquadmath0:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libssl-dev:amd64 (3.4.0-1ubuntu2) ... 201s Setting up libmpc3:amd64 (1.3.1-1build2) ... 201s Setting up libtcl8.6:amd64 (8.6.15+dfsg-2) ... 201s Setting up autopoint (0.22.5-3) ... 201s Setting up icu-devtools (74.2-1ubuntu4) ... 201s Setting up libgc1:amd64 (1:8.2.8-1) ... 201s Setting up autoconf (2.72-3) ... 201s Setting up libubsan1:amd64 (14.2.0-12ubuntu1) ... 201s Setting up dwz (0.15-1build6) ... 201s Setting up libhwasan0:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libasan8:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libjson-perl (4.10000-1) ... 201s Setting up postgresql-doc (16+262) ... 201s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 201s Setting up debugedit (1:5.1-1) ... 201s Setting up libecpg6:amd64 (17.2-1) ... 201s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 201s Setting up libtsan2:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libisl23:amd64 (0.27-1) ... 201s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 201s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 201s Setting up libicu-dev:amd64 (74.2-1ubuntu4) ... 201s Setting up libcc1-0:amd64 (14.2.0-12ubuntu1) ... 201s Setting up liblsan0:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libitm1:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 201s Setting up automake (1:1.16.5-1.3ubuntu1) ... 201s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 201s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 201s Setting up gettext (0.22.5-3) ... 201s Setting up libecpg-compat3:amd64 (17.2-1) ... 201s Setting up dictionaries-common (1.30.2) ... 201s Setting up postgresql-client-16 (16.4-3) ... 201s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 201s Setting up libpq-dev (17.2-1) ... 201s Setting up libobjc4:amd64 (14.2.0-12ubuntu1) ... 201s Setting up libecpg-dev (17.2-1) ... 201s Setting up intltool-debian (0.35.0+20060710.6) ... 201s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.2build1) ... 201s Setting up postgresql-common (262) ... 202s Creating config file /etc/postgresql-common/createcluster.conf with new version 202s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 202s en_us 202s Removing obsolete dictionary files: 203s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 203s Setting up cpp-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 203s Setting up cpp-14 (14.2.0-12ubuntu1) ... 203s Setting up dh-strip-nondeterminism (1.14.0-1) ... 203s Setting up hunspell-en-us (1:2020.12.07-3) ... 203s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 203s Setting up libgcc-14-dev:amd64 (14.2.0-12ubuntu1) ... 203s Setting up libstdc++-14-dev:amd64 (14.2.0-12ubuntu1) ... 203s Setting up cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 203s Setting up postgresql-16 (16.4-3) ... 203s Creating new PostgreSQL cluster 16/main ... 203s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 203s The files belonging to this database system will be owned by user "postgres". 203s This user must also own the server process. 203s 203s The database cluster will be initialized with locale "C.UTF-8". 203s The default database encoding has accordingly been set to "UTF8". 203s The default text search configuration will be set to "english". 203s 203s Data page checksums are disabled. 203s 203s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 203s creating subdirectories ... ok 203s selecting dynamic shared memory implementation ... posix 203s selecting default max_connections ... 100 203s selecting default shared_buffers ... 128MB 203s selecting default time zone ... Etc/UTC 203s creating configuration files ... ok 204s running bootstrap script ... ok 204s performing post-bootstrap initialization ... ok 204s syncing data to disk ... ok 208s Setting up po-debconf (1.0.21+nmu1) ... 208s Setting up libobjc-14-dev:amd64 (14.2.0-12ubuntu1) ... 208s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 208s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 208s Setting up postgresql-server-dev-16 (16.4-3) ... 208s Setting up postgresql-plpython3-16 (16.4-3) ... 208s Setting up cpp (4:14.1.0-2ubuntu1) ... 208s Setting up postgresql-plperl-16 (16.4-3) ... 208s Setting up gcc-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 208s Setting up postgresql-server-dev-all:amd64 (262) ... 208s Setting up postgresql-pltcl-16 (16.4-3) ... 208s Setting up gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 208s Setting up libtool (2.4.7-8) ... 208s Setting up postgresql-all (262) ... 208s Setting up gcc-14 (14.2.0-12ubuntu1) ... 208s Setting up dh-autoreconf (20) ... 208s Setting up g++-14-x86-64-linux-gnu (14.2.0-12ubuntu1) ... 208s Setting up g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 208s Setting up g++-14 (14.2.0-12ubuntu1) ... 208s Setting up debhelper (13.23ubuntu1) ... 208s Setting up gcc (4:14.1.0-2ubuntu1) ... 208s Setting up g++ (4:14.1.0-2ubuntu1) ... 208s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 208s Setting up build-essential (12.10ubuntu1) ... 208s Processing triggers for libc-bin (2.40-4ubuntu1) ... 208s Processing triggers for systemd (257-2ubuntu1) ... 208s Processing triggers for man-db (2.13.0-1) ... 210s Processing triggers for install-info (7.1.1-1) ... 210s Processing triggers for dictionaries-common (1.30.2) ... 211s autopkgtest [22:45:05]: test run-testsuite: [----------------------- 212s ====== Running all tests with umask 077 ======= 212s ### PostgreSQL test 001_packages.t ### 212s 1..22 212s ok 1 - /etc/os-release exists 212s ok 2 - OS is ubuntu 212s ok 3 - OS version is 25.04 212s # PostgreSQL versions installed: 16 212s ok 4 - postgresql-16 installed 212s ok 5 # skip No python2 support 212s ok 6 - postgresql-plpython3-16 installed 212s ok 7 - postgresql-plperl-16 installed 212s ok 8 - postgresql-pltcl-16 installed 212s ok 9 - postgresql-server-dev-16 installed 212s ok 10 # skip No postgresql-contrib-16 package for version 16 212s # postgresql-doc-16 installed 212s ok 11 - At least one doc package installed 212s ok 12 - libecpg-dev installed 212s ok 13 - procps installed 212s ok 14 - netcat-openbsd installed 212s ok 15 - hunspell-en-us installed 212s ok 16 - system has a default UTF-8 locale 212s ok 17 - locale ru_RU exists 212s ok 18 - locale ru_RU.UTF-8 exists 212s ok 19 - user postgres in the UNIX group ssl-cert 212s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 212s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 212s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 212s ### End test 001_packages.t ### 212s 212s ### PostgreSQL test 002_existing_clusters.t ### 212s 1..8 212s # Cleanup 212s ok 1 - Cleanup: No clusters left behind 212s ok 2 - No postgres processes left behind 212s ok 3 - No files in /etc/postgresql left behind 212s ok 4 - No files in /var/lib/postgresql left behind 212s ok 5 - No files in /var/run/postgresql left behind 212s ok 6 - No files in /var/log/postgresql left behind 212s ok 7 - PostgreSQL TCP ports are closed 212s ok 8 - Next free port is 5432 212s ### End test 002_existing_clusters.t ### 212s 212s ### PostgreSQL test 003_alternatives.t ### 212s 1..9 212s # Newest PG version installed is 16 212s ok 1 - psql.1.gz link group 212s ok 2 - postmaster.1.gz link group does not exist 212s ok 3 - psql.1.gz alternative 212s ok 4 - pg_dump.1.gz alternative 212s ok 5 - postgres.1.gz alternative 212s ok 6 - pg_ctl.1.gz alternative 212s # Newest PG doc version installed is 16 212s ok 7 - SPI_connect.3.gz link group 212s ok 8 - SPI_connect.3.gz alternative 212s ok 9 - SPI_exec.3.gz alternative 212s ### End test 003_alternatives.t ### 212s 212s ### PostgreSQL test 005_PgCommon.t ### 212s 1..24 212s ok 1 - correctly parsed line 'local all postgres ident sameuser' 212s ok 2 - correctly parsed line 'local foo nobody trust' 212s ok 3 - correctly parsed line 'local foo nobody crypt' 212s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 212s ok 5 - correctly parsed line 'local foo,bar nobody ident' 212s ok 6 - correctly parsed line 'local all +foogrp password' 212s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 212s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 212s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 212s ok 10 - @expected_records has correct number of entries 212s ok 11 - returned read_pg_hba array has correct number of records 212s ok 12 - line 'foo all all md5' parsed as invalid 212s ok 13 - line 'local all all foo' parsed as invalid 212s ok 14 - line 'host all all foo' parsed as invalid 212s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 212s ok 16 - line 'host all all md5' parsed as invalid 212s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 212s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 212s ok 19 - read_conf_file returns empty dict for nonexisting file 212s ok 20 - read_conf_file() parsing 212s ok 21 - read_conf_file() parsing with include directives 212s ok 22 - set_conf_value 212s ok 23 - disable_conf_value 212s ok 24 - replace_conf_value 212s ### End test 005_PgCommon.t ### 212s 212s ### PostgreSQL test 006_next_free_port.t ### 212s 1..5 212s ok 1 - next_free_port is 5432 213s ok 2 - next_free_port detects localhost ipv4 socket 214s ok 3 - next_free_port detects wildcard ipv4 socket 215s ok 4 - next_free_port detects localhost ipv6 socket 217s ok 5 - next_free_port detects wildcard ipv6 socket 217s ### End test 006_next_free_port.t ### 217s 217s ### PostgreSQL test 007_pg_conftool.t ### 217s 1..41 217s # test without cluster 217s ok 1 - pg_conftool show all 217s ok 2 - correct output of pg_conftool show all 217s ok 3 - pg_conftool foo.conf show all 217s ok 4 - correct output of pg_conftool foo.conf show all 217s ok 5 - pg_conftool /tmp/rjVwAe4eXM/different.conf show all 217s ok 6 - correct output of pg_conftool /tmp/rjVwAe4eXM/different.conf show all 217s ok 7 - pg_conftool 9.7 main show all 217s ok 8 - correct output of pg_conftool 9.7 main show all 217s # test show 217s ok 9 - pg_conftool show all 217s ok 10 - correct output of pg_conftool show all 217s ok 11 - pg_conftool other.conf show all 217s ok 12 - correct output of pg_conftool other.conf show all 217s ok 13 - pg_conftool /tmp/rjVwAe4eXM/different.conf show all 217s ok 14 - correct output of pg_conftool /tmp/rjVwAe4eXM/different.conf show all 217s ok 15 - pg_conftool 16 main show all 217s ok 16 - correct output of pg_conftool 16 main show all 217s ok 17 - pg_conftool 16 main other.conf show all 217s ok 18 - correct output of pg_conftool 16 main other.conf show all 217s ok 19 - pg_conftool show a 217s ok 20 - correct output of pg_conftool show a 217s ok 21 - pg_conftool -s show a 217s ok 22 - correct output of pg_conftool -s show a 217s # test set 217s ok 23 - pg_conftool set c 7 217s ok 24 - correct output of pg_conftool set c 7 217s ok 25 - file contains new setting 217s ok 26 - pg_conftool set a 8 217s ok 27 - correct output of pg_conftool set a 8 217s ok 28 - file contains updated setting 217s ok 29 - pg_conftool /tmp/rjVwAe4eXM/different.conf set a 9 217s ok 30 - correct output of pg_conftool /tmp/rjVwAe4eXM/different.conf set a 9 217s ok 31 - file with path contains updated setting 217s # test remove 217s ok 32 - pg_conftool remove a 217s ok 33 - correct output of pg_conftool remove a 217s ok 34 - setting removed from file 217s ok 35 - pg_conftool /tmp/rjVwAe4eXM/different.conf remove a 217s ok 36 - correct output of pg_conftool /tmp/rjVwAe4eXM/different.conf remove a 217s ok 37 - setting removed from file with path 217s # test edit 217s ok 38 - pg_conftool edit 217s ok 39 - correct output of pg_conftool edit 217s ok 40 - pg_conftool /tmp/rjVwAe4eXM/different.conf edit 217s ok 41 - correct output of pg_conftool /tmp/rjVwAe4eXM/different.conf edit 217s ### End test 007_pg_conftool.t ### 217s 217s ### PostgreSQL test 010_defaultport_cluster.t ### 217s 1..14 217s ok 1 - psql --version 217s ok 2 - pg_wrapper selects highest available version number 217s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 217s ok 4 - connecting to localhost fails with no clusters 217s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 217s ok 6 - pg_wrapper uses host and port from PGCLUSTER 218s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 218s ok 8 - pg_wrapper uses --cluster from the command line 218s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 218s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 218s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 218s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 218s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 218s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 218s ### End test 010_defaultport_cluster.t ### 218s 218s ### PostgreSQL test 015_start_stop.t ### 218s 1..71 218s # We are running systemd 218s # Running tests for 16 218s # Cluster does not exist yet 218s ok 1 - cluster 16 main does not exist 218s ok 2 - service postgresql@16-main does not exist 218s ok 3 - systemctl start postgresql 218s ok 4 - cluster 16 main does not exist 218s ok 5 - service postgresql@16-main does not exist 218s ok 6 - systemctl start postgresql@16-main 218s ok 7 - cluster 16 main does not exist 218s ok 8 - service postgresql@16-main does not exist 218s # Start/stop postgresql using system tools 219s ok 9 - pg_createcluster 16 main 219s ok 10 - cluster 16 main is stopped 219s ok 11 - service postgresql@16-main is stopped 221s ok 12 - systemctl start postgresql 221s ok 13 - cluster 16 main is running 221s ok 14 - service postgresql@16-main is running 221s ok 15 - systemctl start postgresql 221s ok 16 - cluster 16 main is already running 221s ok 17 - service postgresql@16-main is already running 221s ok 18 - systemctl stop postgresql 228s ok 19 - cluster 16 main is stopped 228s ok 20 - service postgresql@16-main is stopped 228s ok 21 - systemctl stop postgresql 228s ok 22 - cluster 16 main is already stopped 228s ok 23 - service postgresql@16-main is already stopped 228s # Start/stop specific cluster using system tools 230s ok 24 - systemctl start postgresql@16-main 230s ok 25 - cluster 16 main is running 230s ok 26 - service postgresql@16-main is running 230s ok 27 - systemctl start postgresql@16-main 230s ok 28 - cluster 16 main is running 230s ok 29 - service postgresql@16-main is running 232s ok 30 - systemctl restart postgresql@16-main 232s ok 31 - cluster 16 main is running 232s ok 32 - service postgresql@16-main is running 233s ok 33 - systemctl stop postgresql@16-main 233s ok 34 - cluster 16 main is stopped 233s ok 35 - service postgresql@16-main is stopped 233s ok 36 - systemctl stop postgresql@16-main 233s ok 37 - cluster 16 main is already stopped 233s ok 38 - service postgresql@16-main is already stopped 234s ok 39 - pg_dropcluster 16 main 234s ok 40 - cluster 16 main does not exist 234s ok 41 - service postgresql@16-main does not exist 234s # Start/stop specific cluster using pg_*cluster 234s ok 42 - pg_ctlcluster start 16 main 234s ok 43 - cluster 16 main does not exist 234s ok 44 - service postgresql@16-main does not exist 238s ok 45 - pg_createcluster 16 main --start 238s ok 46 - cluster 16 main is running 238s ok 47 - service postgresql@16-main is running 238s ok 48 - pg_ctlcluster 16 main start 238s ok 49 - cluster 16 main is already running 238s ok 50 - service postgresql@16-main is already running 240s ok 51 - pg_ctlcluster 16-main restart 240s ok 52 - cluster 16 main is running 240s ok 53 - service postgresql@16-main is running 241s ok 54 - pg_ctlcluster 16 main stop 241s ok 55 - cluster 16 main is stopped 241s ok 56 - service postgresql@16-main is stopped 241s ok 57 - pg_ctlcluster 16 main stop 241s ok 58 - cluster 16 main is already stopped 241s ok 59 - service postgresql@16-main is already stopped 243s ok 60 - pg_ctlcluster start 16-main 243s ok 61 - cluster 16 main is running 243s ok 62 - service postgresql@16-main is running 245s ok 63 - pg_dropcluster 16 main --stop 245s # Cleanup 245s ok 64 - Cleanup: No clusters left behind 245s ok 65 - No postgres processes left behind 245s ok 66 - No files in /etc/postgresql left behind 245s ok 67 - No files in /var/lib/postgresql left behind 245s ok 68 - No files in /var/run/postgresql left behind 245s ok 69 - No files in /var/log/postgresql left behind 245s ok 70 - PostgreSQL TCP ports are closed 245s ok 71 - Next free port is 5432 245s ### End test 015_start_stop.t ### 245s 245s ### PostgreSQL test 020_create_sql_remove.t ### 245s 1..147 245s # Running tests for 16 248s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.zAo65V 248s ok 2 - pg_createcluster 16 main 248s ok 3 - Socket and pid file are in /var/run/postgresql/ 248s ok 4 - xlog/wal directory /tmp/16.xlog.zAo65V was created 248s ok 5 - local method in pg_hba.conf is peer 248s ok 6 - host method in pg_hba.conf is scram-sha-256 248s ok 7 - Exactly one postgres master process running 251s ok 8 - pg_ctlcluster 16 main restart 251s ok 9 - cluster restarts with new environment file 251s ok 10 - Exactly one postgres master process running 251s ok 11 - correct value of PGEXTRAVAR1 in environment 251s ok 12 - correct value of PGEXTRAVAR2 in environment 251s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 251s ok 14 - createdb --version 251s ok 15 - pg_wrapper+createdb selects version number of cluster 251s ok 16 - psql --version 251s ok 17 - pg_wrapper+psql selects version 16 251s ok 18 - pg_lscluster reports online cluster on port 5432 251s ok 19 - log file is actually used 251s ok 20 - /etc/postgresql is owned by user "postgres" 251s ok 21 - version configuration directory file is owned by user "postgres" 251s ok 22 - configuration directory file is owned by user "postgres" 251s ok 23 - version data directory file is owned by user "postgres" 251s ok 24 - data directory file is owned by user "postgres" 251s ok 25 - log file has 0640 permissions 251s ok 26 - log file is owned by user "postgres" 251s ok 27 - log file is owned by group "adm" 251s ok 28 - no log symlink by default 251s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 251s ok 30 - pg_lsclusters -h 251s ok 31 - correct output of pg_lsclusters -h 251s ok 32 - stopping cluster 254s ok 33 - restarting cluster with nondefault log symlink 254s ok 34 - log target is used as log file 254s ok 35 - default log is not used 254s ok 36 - pg_lsclusters -h 254s ok 37 - correct output of pg_lsclusters -h 254s ok 38 - stopping cluster 257s ok 39 - restarting cluster with explicitly configured log file 257s ok 40 - default log is not used 257s ok 41 - log symlink target is used for startup message 257s ok 42 - exactly one log file 257s ok 43 - custom log is actually used 257s ok 44 - pg_lsclusters -h 257s ok 45 - correct output of pg_lsclusters -h 257s ok 46 - stopping cluster 257s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 257s ok 48 - /etc/postgres-hack was not created 259s ok 49 - restarting cluster 259s ok 50 - ps -o tty -U postgres h 259s ok 51 - postgres processes do not have an associated terminal 259s ok 52 - Server is linked with SSL support 259s ok 53 - SSL is enabled in postgresql.conf 259s ok 54 - psql -l fails for nobody 259s ok 55 - createuser nobody 259s ok 56 - createdb nobodydb 260s ok 57 - psql -ltA succeeds for nobody 260s ok 58 - psql -ltA output 260s ok 59 - SQL command: create table 260s ok 60 - SQL command: insert into table values 260s ok 61 - SQL command: insert into table values 260s ok 62 - primary key violation 260s ok 63 - psql -tAc "select * from phone order by name" nobodydb 260s ok 64 - SQL command output: select -tA 260s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 260s ok 66 - SQL command output: select -tx 260s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 260s ok 68 - SQL command output: select -tAx 260s ok 69 - CREATE EXTENSION plperlu fails for user nobody 260s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 260s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 260s ok 72 - creating PL/PerlU function as user nobody fails 260s ok 73 - creating unsafe PL/Perl function as user postgres fails 260s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 260s ok 75 - creating PL/PerlU function as user postgres succeeds 260s ok 76 - psql nobodydb -Atc "select read_file()" 260s ok 77 - calling PL/PerlU function 260s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 260s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 260s ok 80 - creating unsafe PL/Perl function as user nobody fails 260s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 260s ok 82 - creating PL/Perl function as user nobody succeeds 260s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 260s ok 84 - calling PL/Perl function 260s ok 85 # skip No python2 support 260s ok 86 # skip No python2 support 260s ok 87 # skip No python2 support 260s ok 88 # skip No python2 support 260s ok 89 # skip No python2 support 260s ok 90 # skip No python2 support 261s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 261s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 261s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 261s ok 94 - creating PL/Python3 function as user postgres succeeds 261s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 261s ok 96 - calling PL/Python function 261s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 261s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 261s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 261s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 261s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 261s ok 102 - creating PL/Tcl function as user nobody succeeds 261s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 261s ok 104 - creating PL/TclU function as user postgres succeeds 261s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 261s ok 106 - calling PL/Tcl function 261s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 261s ok 108 - calling PL/TclU function 261s ok 109 - stopping cluster 261s ok 110 - pg_ctlcluster 16 main start 261s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 263s ok 112 - pg_ctlcluster 16 main start 263s ok 113 - cluster restarts with pgdata symlink 264s ok 114 - postgres master has OOM killer protection 264s ok 115 - postgres client backend has no OOM adjustment 264s ok 116 - ps h 6394 264s ok 117 - process title is idle 265s ok 118 - ps h 6394 265s ok 119 - process title is idle in transaction 265s ok 120 - stopping cluster 267s ok 121 - starting cluster as postgres works without a log file 267s ok 122 - log file got recreated and used 267s ok 123 - creating a directory in spc2 267s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.zVhy4P'" 267s ok 125 - creating tablespace spc1 267s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 267s ok 127 - creating a table in spc1 267s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.8xND4p'" 267s ok 129 - creating tablespace spc2 267s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 267s ok 131 - creating a table in spc2 267s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 267s ok 133 - Correct apt NeverAutoRemove config 269s ok 134 - pg_dropcluster removes cluster 269s ok 135 - xlog/wal directory /tmp/16.xlog.zAo65V was deleted 269s ok 136 - tablespace spc1 was emptied 269s ok 137 - tablespace spc2 was emptied 269s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 269s ok 139 - Correct apt NeverAutoRemove config 269s # Cleanup 269s ok 140 - Cleanup: No clusters left behind 269s ok 141 - No postgres processes left behind 269s ok 142 - No files in /etc/postgresql left behind 269s ok 143 - No files in /var/lib/postgresql left behind 269s ok 144 - No files in /var/run/postgresql left behind 269s ok 145 - No files in /var/log/postgresql left behind 269s ok 146 - PostgreSQL TCP ports are closed 269s ok 147 - Next free port is 5432 269s ### End test 020_create_sql_remove.t ### 269s 269s ### PostgreSQL test 021_pg_renamecluster.t ### 269s 1..20 272s ok 1 - pg_createcluster 16 main 275s ok 2 - pg_renamecluster 16 main donau 275s ok 3 - psql -tAc "show data_directory" 275s ok 4 - cluster is running and data_directory was moved 275s ok 5 - pg_hba.conf location updated 275s ok 6 - pg_ident.conf location updated 275s ok 7 - external_pid_file location updated 275s ok 8 - external_pid_file exists 275s ok 9 # skip no stats_temp_directory in 16 275s ok 10 # skip no stats_temp_directory in 16 275s ok 11 - cluster_name is updated 277s ok 12 - pg_dropcluster removes cluster 277s # Cleanup 277s ok 13 - Cleanup: No clusters left behind 277s ok 14 - No postgres processes left behind 277s ok 15 - No files in /etc/postgresql left behind 277s ok 16 - No files in /var/lib/postgresql left behind 277s ok 17 - No files in /var/run/postgresql left behind 277s ok 18 - No files in /var/log/postgresql left behind 277s ok 19 - PostgreSQL TCP ports are closed 277s ok 20 - Next free port is 5432 277s ### End test 021_pg_renamecluster.t ### 277s 277s ### PostgreSQL test 022_recovery.t ### 277s 1..17 277s # Running tests for 16 281s ok 1 - pg_createcluster 16 main --start >/dev/null 281s ok 2 - pg_ctlcluster 16 main stop -m i 283s ok 3 - pg_ctlcluster 16 main start 283s ok 4 - psql -c '' 283s ok 5 - pg_ctlcluster 16 main stop -m i 283s ok 6 - create write-protected file in data directory 286s ok 7 - pg_ctlcluster 16 main start 286s ok 8 - psql -c '' 288s ok 9 - pg_dropcluster removes cluster 288s # Cleanup 288s ok 10 - Cleanup: No clusters left behind 288s ok 11 - No postgres processes left behind 288s ok 12 - No files in /etc/postgresql left behind 288s ok 13 - No files in /var/lib/postgresql left behind 288s ok 14 - No files in /var/run/postgresql left behind 288s ok 15 - No files in /var/log/postgresql left behind 288s ok 16 - PostgreSQL TCP ports are closed 288s ok 17 - Next free port is 5432 288s ### End test 022_recovery.t ### 288s 288s ### PostgreSQL test 025_logging.t ### 288s 1..55 288s # Logging to /var/log/syslog works 288s # Running tests for 16 292s ok 1 - pg_createcluster 16 main 292s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 292s ok 3 - psql -qc "'foobar_16_7645'" 292s ok 4 - log an error 292s ok 5 - grep --binary-files=text foobar_16_7645 /var/log/postgresql/postgresql-16-main.log 292s ok 6 - error appears in logfile 292s ok 7 - pg_conftool 16 main set log_destination syslog 292s ok 8 - set log_destination syslog 292s ok 9 - pg_ctlcluster 16 main reload 292s ok 10 - 16 main reload 292s ok 11 - psql -Atc "show log_destination" 292s ok 12 - log_destination is syslog 292s ok 13 - pg_lscluster reports syslog 293s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 293s ok 15 - error appears in /var/log/syslog 293s ok 16 - pg_conftool 16 main set logging_collector on 293s ok 17 - set logging_collector on 293s ok 18 - pg_conftool 16 main set log_destination csvlog 293s ok 19 - set log_destination csvlog 295s ok 20 - pg_ctlcluster 16 main restart 295s ok 21 - 16 main restart 295s ok 22 - psql -Atc "show logging_collector" 295s ok 23 - logging_collector is on 295s ok 24 - psql -Atc "show log_destination" 295s ok 25 - log_destination is csvlog 295s ok 26 - pg_lscluster reports csvlog 296s ok 27 - psql -qc "'barbaz_16_7645'" 296s ok 28 - log an error 296s ok 29 - grep --binary-files=text barbaz_16_7645 /var/lib/postgresql/16/main/log/*.csv 296s ok 30 - error appears in log/*.csv 296s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 296s ok 32 - set log_destination stderr,syslog,csvlog 296s ok 33 - pg_ctlcluster 16 main reload 296s ok 34 - 16 main reload 296s ok 35 - psql -Atc "show log_destination" 296s ok 36 - log_destination is stderr,syslog,csvlog 296s ok 37 - pg_lscluster reports stderr,syslog,csvlog 296s ok 38 - psql -qc "'moo_16_7645'" 296s ok 39 - log an error 297s ok 40 - grep --binary-files=text moo_16_7645 /var/lib/postgresql/16/main/log/*.log 297s ok 41 - error appears in log/*.log 297s ok 42 - grep --binary-files=text 'postgres.*moo_16_7645' /var/log/syslog 297s ok 43 - error appears in /var/log/syslog 297s ok 44 - grep --binary-files=text moo_16_7645 /var/lib/postgresql/16/main/log/*.csv 297s ok 45 - error appears in log/*.csv 299s ok 46 - pg_dropcluster 16 main --stop 299s ok 47 - pg_dropcluster removes cluster 299s # Cleanup 299s ok 48 - Cleanup: No clusters left behind 299s ok 49 - No postgres processes left behind 299s ok 50 - No files in /etc/postgresql left behind 299s ok 51 - No files in /var/lib/postgresql left behind 299s ok 52 - No files in /var/run/postgresql left behind 299s ok 53 - No files in /var/log/postgresql left behind 299s ok 54 - PostgreSQL TCP ports are closed 299s ok 55 - Next free port is 5432 299s ### End test 025_logging.t ### 299s 299s ### PostgreSQL test 027_jit.t ### 299s # 16 303s ok 1 - pg_createcluster 16 main --start 303s ok 2 - psql -Xatc 'show jit' 303s ok 3 - JIT is on by default 303s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 303s ok 5 - No JIT on cheap query 303s ok 6 - pg_conftool 16 main set seq_page_cost 100000 303s ok 7 - pg_conftool 16 main set random_page_cost 100000 303s ok 8 - pg_ctlcluster 16 main reload 303s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 303s ok 10 - Expensive query is JITed 305s ok 11 - pg_dropcluster --stop 16 main 305s # Cleanup 305s ok 12 - Cleanup: No clusters left behind 305s ok 13 - No postgres processes left behind 305s ok 14 - No files in /etc/postgresql left behind 305s ok 15 - No files in /var/lib/postgresql left behind 305s ok 16 - No files in /var/run/postgresql left behind 305s ok 17 - No files in /var/log/postgresql left behind 305s ok 18 - PostgreSQL TCP ports are closed 305s ok 19 - Next free port is 5432 305s 1..19 305s ### End test 027_jit.t ### 305s 305s ### PostgreSQL test 030_errors.t ### 305s 1..156 305s ok 1 - pg_lscluster reports cluster without binaries 306s ok 2 - pg_dropcluster 6.3 main 307s ok 3 - pg_createcluster --socketdir 307s ok 4 - pg_lsclusters -h 307s ok 5 - cluster was created 307s ok 6 - Port of created cluster is 5432 307s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 307s ok 8 - pg_createcluster on existing cluster 308s ok 9 - pg_lsclusters -h 308s ok 10 - original cluster still exists 308s ok 11 - pg_createcluster 16 test -p foo 308s ok 12 - pg_createcluster -p checks that port option is numeric 308s ok 13 - pg_createcluster 16 test -p 42 308s ok 14 - pg_createcluster -p checks valid port range 308s ok 15 - pg_ctlcluster 16 main start 308s ok 16 - pg_ctlcluster refuses to start root-owned cluster 308s ok 17 - pg_ctlcluster 16 main start 308s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 308s ok 19 - pg_ctlcluster 16 main start 308s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 308s ok 21 - pg_ctlcluster 16 main start 308s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 310s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 310s ok 24 - No sockets in /var/run/postgresql 310s ok 25 - Socket is in /tmp/postgresql-testsuite/ 310s ok 26 - cluster stops with custom unix_socket_dir 310s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 313s ok 28 - cluster starts after removing unix_socket_dir 313s ok 29 - Socket is in default dir /var/run/postgresql 313s ok 30 - No sockets in /tmp/postgresql-testsuite/ 313s ok 31 - pg_ctlcluster 16 main stop 313s ok 32 - pg_ctlcluster fails with corrupted PID file 313s ok 33 - pg_lsclusters -h 313s ok 34 - cluster is still online 313s ok 35 - pg_ctlcluster succeeds with restored PID file 313s ok 36 - pg_lsclusters -h 313s ok 37 - cluster is down 313s ok 38 - pg_ctlcluster 16 main stop 313s ok 39 - pg_ctlcluster stop fails on stopped cluster 315s ok 40 - pg_ctlcluster 16 main start 315s ok 41 - pg_ctlcluster succeeds with already existing PID file 315s ok 42 - pg_lsclusters -h 315s ok 43 - cluster is online 315s ok 44 - pg_ctlcluster stop succeeds 315s ok 45 - pg_lsclusters -h 315s ok 46 - cluster is down 315s ok 47 - no pid file left 316s ok 48 - pg_ctlcluster 16 main stop 316s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 316s ok 50 - pid file was cleaned up 316s ok 51 - pg_ctlcluster --force 16 main stop 316s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 316s ok 53 - pid file was cleaned up 316s ok 54 - pg_ctlcluster 16 main stop 316s ok 55 - pg_ctlcluster stop succeeds with stale PID file 316s ok 56 - pid file was cleaned up 316s ok 57 - pg_ctlcluster --force 16 main stop 316s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 316s ok 59 - pid file was cleaned up 316s ok 60 - pg_ctlcluster --force 16 main stop 316s ok 61 - pg_ctlcluster stop succeeds with empty PID file 316s ok 62 - pid file was cleaned up 318s ok 63 - pg_ctlcluster 16 main start 318s ok 64 - pg_ctlcluster succeeds with corrupted PID file 318s ok 65 - pg_lsclusters -h 318s ok 66 - cluster is online 318s ok 67 - pg_ctlcluster 16 main start 318s ok 68 - pg_ctlcluster start fails on running cluster 318s ok 69 - pg_ctlcluster stop 318s ok 70 - pg_ctlcluster 16 main start 318s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 318s ok 72 - pg_ctlcluster 16 main stop 318s ok 73 - stopping cluster 325s ok 74 - pg_ctlcluster 16 main start 325s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 325s ok 76 - pg_ctlcluster 16 main stop 325s ok 77 - stopping cluster 325s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 325s ok 79 - pg_dropcluster 16 main 325s ok 80 - pg_dropcluster works as user postgres 326s ok 81 - pg_createcluster succeeds 326s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 326s ok 83 - proper error message for nonexisting /var/lib/postgresql 328s ok 84 - pg_ctlcluster 16 main start 328s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 329s ok 86 - pg_ctlcluster 16 main stop 329s ok 87 - stopping cluster 330s ok 88 - pg_createcluster other 332s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 334s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 334s ok 91 334s ok 92 - pg_ctlcluster 16 other start 334s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 334s ok 94 - pg_ctlcluster 16 main stop 334s ok 95 - stopping main cluster 337s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 338s ok 97 - pg_dropcluster other 340s ok 98 - pg_dropcluster 340s ok 99 - No sockets any more 340s ok 100 - 'pg_lsclusters 4.5 foo' fails 340s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 340s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 340s ok 103 - 'psql --cluster 4.5/foo' fails 340s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 340s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 340s ok 106 - 'psql --cluster 16/foo' fails 340s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 340s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 340s ok 109 - 'pg_dropcluster 4.5 foo' fails 340s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 340s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 340s ok 112 - 'pg_dropcluster 16 foo' fails 340s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 340s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 340s ok 115 - 'pg_upgradecluster 4.5 foo' fails 340s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 340s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 340s ok 118 - 'pg_upgradecluster 16 foo' fails 340s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 340s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 340s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 340s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 340s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 340s ok 124 - 'pg_ctlcluster 16 foo stop' fails 340s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 340s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 340s # Cleanup 340s ok 127 - Cleanup: No clusters left behind 340s ok 128 - No postgres processes left behind 340s ok 129 - No files in /etc/postgresql left behind 340s ok 130 - No files in /var/lib/postgresql left behind 340s ok 131 - No files in /var/run/postgresql left behind 340s ok 132 - No files in /var/log/postgresql left behind 340s ok 133 - PostgreSQL TCP ports are closed 340s ok 134 - Next free port is 5432 341s ok 135 - pg_dropcluster 16 broken 341s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 341s # Cleanup 341s ok 137 - Cleanup: No clusters left behind 341s ok 138 - No postgres processes left behind 341s ok 139 - No files in /etc/postgresql left behind 341s ok 140 - No files in /var/lib/postgresql left behind 341s ok 141 - No files in /var/run/postgresql left behind 341s ok 142 - No files in /var/log/postgresql left behind 341s ok 143 - PostgreSQL TCP ports are closed 341s ok 144 - Next free port is 5432 343s ok 145 - pg_dropcluster 16 broken 343s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 343s ok 147 - /etc/postgresql/16 was removed 343s ok 148 - /var/lib/postgresql/16 was removed 343s # Cleanup 343s ok 149 - Cleanup: No clusters left behind 343s ok 150 - No postgres processes left behind 343s ok 151 - No files in /etc/postgresql left behind 343s ok 152 - No files in /var/lib/postgresql left behind 343s ok 153 - No files in /var/run/postgresql left behind 343s ok 154 - No files in /var/log/postgresql left behind 343s ok 155 - PostgreSQL TCP ports are closed 343s ok 156 - Next free port is 5432 343s ### End test 030_errors.t ### 343s 343s ### PostgreSQL test 031_errors_disk_full.t ### 343s 1..22 343s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 344s ok 1 - script failed 344s ok 2 - pg_createcluster fails due to insufficient disk space 344s ok 3 - does not leave files behind 344s # Cleanup 344s ok 4 - Cleanup: No clusters left behind 344s ok 5 - No postgres processes left behind 344s ok 6 - No files in /etc/postgresql left behind 344s ok 7 - No files in /var/lib/postgresql left behind 344s ok 8 - No files in /var/run/postgresql left behind 344s ok 9 - No files in /var/log/postgresql left behind 344s ok 10 - PostgreSQL TCP ports are closed 344s ok 11 - Next free port is 5432 344s # check disk full conditions on startup 347s ok 12 - script failed 347s ok 13 - pg_ctlcluster prints error message 347s ok 14 - log file has error message 347s # Cleanup 347s ok 15 - Cleanup: No clusters left behind 347s ok 16 - No postgres processes left behind 347s ok 17 - No files in /etc/postgresql left behind 347s ok 18 - No files in /var/lib/postgresql left behind 347s ok 19 - No files in /var/run/postgresql left behind 347s ok 20 - No files in /var/log/postgresql left behind 347s ok 21 - PostgreSQL TCP ports are closed 347s ok 22 - Next free port is 5432 347s ### End test 031_errors_disk_full.t ### 347s 347s ### PostgreSQL test 032_ssl_key_permissions.t ### 347s 1..22 347s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 347s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 347s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 347s # 16 (16.4-3) 348s ok 4 - pg_createcluster 16 main 349s ok 5 - pg_ctlcluster 16 main start 349s ok 6 - ssl key owned by nobody refused 349s ok 7 - pg_ctlcluster 16 main start 349s ok 8 - ssl key with permissions root:root 0644 refused 349s ok 9 - pg_ctlcluster 16 main start 349s ok 10 - ssl key with permissions postgres:postgres 0640 refused 350s ok 11 - pg_dropcluster 16 main --stop 350s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 350s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 350s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 350s # Cleanup 350s ok 15 - Cleanup: No clusters left behind 350s ok 16 - No postgres processes left behind 350s ok 17 - No files in /etc/postgresql left behind 350s ok 18 - No files in /var/lib/postgresql left behind 350s ok 19 - No files in /var/run/postgresql left behind 350s ok 20 - No files in /var/log/postgresql left behind 350s ok 21 - PostgreSQL TCP ports are closed 350s ok 22 - Next free port is 5432 350s ### End test 032_ssl_key_permissions.t ### 350s 350s ### PostgreSQL test 040_upgrade.t ### 351s 1..1 351s ok 1 - only one major version installed, skipping upgrade tests 351s ### End test 040_upgrade.t ### 351s 351s ### PostgreSQL test 041_upgrade_custompaths.t ### 351s 1..1 351s ok 1 - only one major version installed, skipping upgrade tests 351s ### End test 041_upgrade_custompaths.t ### 351s 351s ### PostgreSQL test 042_upgrade_rename.t ### 351s 1..15 351s # PostgreSQL 16 354s ok 1 - pg_createcluster 16 main --start 360s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 360s ok 3 - pg_lsclusters -h 360s ok 4 - correct output of pg_lsclusters -h 361s ok 5 - pg_dropcluster 16 main --stop 363s ok 6 - pg_dropcluster 16 upgr --stop 363s ok 7 - Cleaning pg_upgrade log files 363s # Cleanup 363s ok 8 - Cleanup: No clusters left behind 363s ok 9 - No postgres processes left behind 363s ok 10 - No files in /etc/postgresql left behind 363s ok 11 - No files in /var/lib/postgresql left behind 363s ok 12 - No files in /var/run/postgresql left behind 363s ok 13 - No files in /var/log/postgresql left behind 363s ok 14 - PostgreSQL TCP ports are closed 363s ok 15 - Next free port is 5432 363s ### End test 042_upgrade_rename.t ### 363s 363s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 363s 1..1 363s ok 1 - only one major version installed, skipping upgrade tests 363s ### End test 043_upgrade_ssl_cert.t ### 363s 363s ### PostgreSQL test 045_backup.t ### 363s # We are running systemd 363s # PostgreSQL 16 363s # create cluster 367s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 367s ok 2 - pg_lsclusters -h 367s ok 3 - correct output of pg_lsclusters -h 367s ok 4 - pg_conftool 16 main set work_mem 11MB 367s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 367s ok 6 - psql -c 'alter database mydb set search_path=public' 367s ok 7 - psql -c 'create table foo (t text)' mydb 367s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 367s ok 9 - psql -c 'CREATE USER myuser' 367s ok 10 - psql -c 'grant create on database mydb to myuser' 367s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 367s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 367s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 367s # create directory 367s ok 14 - pg_backupcluster 16 main createdirectory 367s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 367s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 367s # dump 368s ok 17 - systemctl start pg_dump@16-main 368s ok 18 - dump created in /var/backups/postgresql/16-main/2025-01-02T224741Z.dump 368s ok 19 - /var/backups/postgresql/16-main/2025-01-02T224741Z.dump owned by uid postgres 368s ok 20 - /var/backups/postgresql/16-main/2025-01-02T224741Z.dump owned by gid postgres 368s # basebackup 368s ok 21 - systemctl start pg_receivewal@16-main 368s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 369s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 369s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 369s ok 25 - psql -c 'select pg_reload_conf()' 397s ok 26 - systemctl start pg_basebackup@16-main 397s ok 27 - dump created in /var/backups/postgresql/16-main/2025-01-02T224743Z.backup 397s ok 28 - /var/backups/postgresql/16-main/2025-01-02T224743Z.backup owned by uid postgres 397s ok 29 - /var/backups/postgresql/16-main/2025-01-02T224743Z.backup owned by gid postgres 397s # list 397s ok 30 - pg_backupcluster 16 main list 397s ok 31 - correct output of pg_backupcluster 16 main list 397s # more database changes 397s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 397s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 397s ok 34 - retrieve recovery timestamp 397s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 397s ok 36 - systemctl stop pg_receivewal@16-main 397s # restore /var/backups/postgresql/16-main/2025-01-02T224741Z.dump 399s ok 37 - pg_dropcluster 16 main --stop 403s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T224741Z.dump --start --datadir /var/lib/postgresql/16/snowflake 403s ok 39 - pg_lsclusters -h 403s ok 40 - correct output of pg_lsclusters -h 403s ok 41 - psql -XAtl 403s ok 42 - mydb locales 403s ok 43 - mydb grants 403s ok 44 - myicudb locales 403s ok 45 - psql -XAtc 'show work_mem' 403s ok 46 - correct output of psql -XAtc 'show work_mem' 404s ok 47 - psql -XAtc 'select * from foo' mydb 404s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 404s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 404s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 404s ok 51 - psql -XAtc '\drds' 404s ok 52 - correct output of psql -XAtc '\drds' 404s # restore /var/backups/postgresql/16-main/2025-01-02T224743Z.backup 405s ok 53 - pg_dropcluster 16 main --stop 409s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T224743Z.backup --start --datadir /var/lib/postgresql/16/snowflake 409s ok 55 - pg_lsclusters -h 409s ok 56 - correct output of pg_lsclusters -h 409s ok 57 - psql -XAtl 409s ok 58 - mydb locales 409s ok 59 - mydb grants 409s ok 60 - myicudb locales 409s ok 61 - psql -XAtc 'show work_mem' 409s ok 62 - correct output of psql -XAtc 'show work_mem' 409s ok 63 - psql -XAtc 'select * from foo' mydb 409s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 409s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 409s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 409s ok 67 - psql -XAtc '\drds' 409s ok 68 - correct output of psql -XAtc '\drds' 409s # restore /var/backups/postgresql/16-main/2025-01-02T224743Z.backup with WAL archive 411s ok 69 - pg_dropcluster 16 main --stop 414s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T224743Z.backup --start --archive --port 5430 414s ok 71 - pg_lsclusters -h 414s ok 72 - correct output of pg_lsclusters -h 414s ok 73 - psql -XAtc 'select * from foo order by t' mydb 414s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 414s # restore /var/backups/postgresql/16-main/2025-01-02T224743Z.backup with PITR 416s ok 75 - pg_dropcluster 16 main --stop 419s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2025-01-02T224743Z.backup --start --pitr '2025-01-02 22:48:11.282961+00 419s # ' 419s ok 77 - pg_lsclusters -h 419s ok 78 - correct output of pg_lsclusters -h 420s ok 79 - psql -XAtc 'select * from foo order by t' mydb 420s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 421s ok 81 - pg_dropcluster 16 main --stop 421s # Cleanup 421s ok 82 - Cleanup: No clusters left behind 421s ok 83 - No postgres processes left behind 421s ok 84 - No files in /etc/postgresql left behind 421s ok 85 - No files in /var/lib/postgresql left behind 421s ok 86 - No files in /var/run/postgresql left behind 421s ok 87 - No files in /var/log/postgresql left behind 421s ok 88 - PostgreSQL TCP ports are closed 421s ok 89 - Next free port is 5432 421s 1..89 421s ### End test 045_backup.t ### 421s 421s ### PostgreSQL test 050_encodings.t ### 421s 1..60 421s # Checking 16 ru_RU 425s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 426s ok 2 - psql -l succeeds 426s ok 3 - template1 is not UTF-8 encoded 426s ok 4 - creating test database 426s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 426s # create table t (x varchar); copy t from stdin" test 426s ok 6 - creating table with ISO-8859-5 characters 426s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 426s ok 8 - correct string in UTF-8 426s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 426s ok 10 - correct string in ISO-8859-5 426s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 426s # delete from t; copy t from stdin" test 426s ok 12 - creating table with UTF-8 characters 426s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 426s ok 14 - correct string in UTF-8 426s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 426s ok 16 - correct string in ISO-8859-1 426s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 426s ok 18 - Server error message has correct language and encoding 429s ok 19 - pg_ctlcluster 16 ru_RU restart 429s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 430s ok 21 - Dropping cluster 430s # Checking 16 ru_RU.UTF-8 433s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 434s ok 23 - psql -l succeeds 434s ok 24 - template1 is UTF-8 encoded 435s ok 25 - creating test database 435s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 435s # create table t (x varchar); copy t from stdin" test 435s ok 27 - creating table with ISO-8859-5 characters 435s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 435s ok 29 - correct string in UTF-8 435s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 435s ok 31 - correct string in ISO-8859-5 435s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 435s # delete from t; copy t from stdin" test 435s ok 33 - creating table with UTF-8 characters 435s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 435s ok 35 - correct string in UTF-8 435s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 435s ok 37 - correct string in ISO-8859-1 435s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 435s ok 39 - Server error message has correct language and encoding 437s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 437s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 437s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 437s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 437s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 437s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 437s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 437s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 439s ok 48 - Dropping cluster 439s # Check 16 locale environment variables 442s ok 49 - pg_createcluster: LC_ALL dominates LANG 442s ok 50 - psql -Atl --cluster 16/main 442s ok 51 - template1 is ASCII encoded 444s ok 52 - Dropping cluster 444s # Cleanup 444s ok 53 - Cleanup: No clusters left behind 444s ok 54 - No postgres processes left behind 444s ok 55 - No files in /etc/postgresql left behind 444s ok 56 - No files in /var/lib/postgresql left behind 444s ok 57 - No files in /var/run/postgresql left behind 444s ok 58 - No files in /var/log/postgresql left behind 444s ok 59 - PostgreSQL TCP ports are closed 444s ok 60 - Next free port is 5432 444s ### End test 050_encodings.t ### 444s 444s ### PostgreSQL test 052_upgrade_encodings.t ### 444s 1..1 444s ok 1 - only one major version installed, skipping upgrade tests 444s ### End test 052_upgrade_encodings.t ### 444s 444s ### PostgreSQL test 060_obsolete_confparams.t ### 444s ok 1 - only one major version installed, skipping upgrade tests 444s 1..1 444s ### End test 060_obsolete_confparams.t ### 444s 444s ### PostgreSQL test 070_non_postgres_clusters.t ### 444s 1..40 445s ok 1 - pg_createcluster 16 main for owner nobody 445s ok 2 - pg_ctlcluster 16 main start 445s ok 3 - start refused when config and data owners mismatch 447s ok 4 - pg_ctlcluster succeeds with owner nobody 448s ok 5 - pg_lsclusters -h 448s ok 6 - pg_lsclusters shows running cluster 448s ok 7 - postgres is running as user nobody 448s ok 8 - ls /tmp/.s.PGSQL.* 448s ok 9 - socket is in /tmp 448s ok 10 - /var/run/postgresql is empty 448s ok 11 - conf dir is owned by user 448s ok 12 - conf dir is owned by user's primary group 448s ok 13 - files are owned by user 448s ok 14 - files are owned by user's primary group 448s ok 15 - log file has 0640 permissions 448s ok 16 - log file is owned by user 448s ok 17 - log file is owned by user's primary group 448s ok 18 - only one major version installed, skipping upgrade test 448s ok 19 - ... 448s ok 20 - ... 448s ok 21 - ... 448s ok 22 - ... 448s ok 23 - ... 448s ok 24 - ... 448s ok 25 - ... 448s ok 26 - ... 448s ok 27 - ... 448s ok 28 - ... 449s ok 29 - pg_dropcluster 449s ok 30 - pg_lsclusters -h 449s ok 31 - No clusters left 449s ok 32 - No postgres processes left 449s # Cleanup 449s ok 33 - Cleanup: No clusters left behind 449s ok 34 - No postgres processes left behind 449s ok 35 - No files in /etc/postgresql left behind 449s ok 36 - No files in /var/lib/postgresql left behind 449s ok 37 - No files in /var/run/postgresql left behind 449s ok 38 - No files in /var/log/postgresql left behind 449s ok 39 - PostgreSQL TCP ports are closed 449s ok 40 - Next free port is 5432 449s ### End test 070_non_postgres_clusters.t ### 449s 449s ### PostgreSQL test 080_start.conf.t ### 449s 1..73 450s ok 1 - pg_createcluster 16 main 450s # start.conf auto 450s ok 2 - get_cluster_start_conf returns auto 450s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 450s ok 4 - start.conf contains auto 450s ok 5 - systemd generator links cluster 450s ok 6 - systemd generator links correct service file 453s ok 7 - /etc/init.d/postgresql start 16 453s ok 8 - correct output of /etc/init.d/postgresql start 16 453s ok 9 - pg_lsclusters -h 453s ok 10 - cluster is online 453s ok 11 - /etc/init.d/postgresql stop 16 453s ok 12 - correct output of /etc/init.d/postgresql stop 16 456s ok 13 - pg_lsclusters -h 456s ok 14 - cluster is down 456s # start.conf manual 456s ok 15 - get_cluster_start_conf returns manual 456s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 456s ok 17 - start.conf contains manual 456s ok 18 - systemd generator doesn't link cluster 456s ok 19 - /etc/init.d/postgresql start 16 456s ok 20 - correct output of /etc/init.d/postgresql start 16 456s ok 21 - pg_lsclusters -h 456s ok 22 - cluster is down 458s ok 23 - pg_ctlcluster 16 main start 458s ok 24 - correct output of pg_ctlcluster 16 main start 459s ok 25 - pg_lsclusters -h 459s ok 26 - cluster is online 459s ok 27 - pg_ctlcluster 16 main stop 459s ok 28 - correct output of pg_ctlcluster 16 main stop 459s ok 29 - pg_lsclusters -h 459s ok 30 - cluster is down 459s # start.conf disabled 459s ok 31 - get_cluster_start_conf returns disabled 459s ok 32 - systemd generator doesn't link cluster 459s ok 33 - /etc/init.d/postgresql start 16 459s ok 34 - correct output of /etc/init.d/postgresql start 16 459s ok 35 - pg_lsclusters -h 459s ok 36 - cluster is down 459s ok 37 - pg_ctlcluster 16 main start 459s ok 38 - correct output of pg_ctlcluster 16 main start 459s ok 39 - pg_lsclusters -h 459s ok 40 - cluster is down 461s ok 41 - pg_ctlcluster 16 main start 461s ok 42 - correct output of pg_ctlcluster 16 main start 461s ok 43 - pg_lsclusters -h 461s ok 44 - cluster is online 462s ok 45 - pg_ctlcluster 16 main stop 462s ok 46 - correct output of pg_ctlcluster 16 main stop 462s ok 47 - pg_lsclusters -h 462s ok 48 - cluster is down 464s ok 49 - pg_ctlcluster 16 main start 464s ok 50 - correct output of pg_ctlcluster 16 main start 464s ok 51 - pg_lsclusters -h 464s ok 52 - cluster is online 464s # test upgrade 464s ok 53 - only one major version installed, skipping upgrade test 464s ok 54 - ... 464s ok 55 - get_cluster_start_conf for old cluster returns manual 464s ok 56 - get_cluster_start_conf for new cluster returns manual 464s ok 57 - ... 465s ok 58 - dropping upgraded cluster 465s ok 59 - pg_lsclusters -h 465s ok 60 - no clusters any more 465s ok 61 - pg_createcluster 16 main --start-conf foo 465s ok 62 - pg_createcluster checks --start-conf validity 466s ok 63 - pg_createcluster checks --start-conf manual 466s ok 64 - get_cluster_start_conf returns manual 467s ok 65 - dropping cluster 467s # Cleanup 467s ok 66 - Cleanup: No clusters left behind 467s ok 67 - No postgres processes left behind 467s ok 68 - No files in /etc/postgresql left behind 467s ok 69 - No files in /var/lib/postgresql left behind 467s ok 70 - No files in /var/run/postgresql left behind 467s ok 71 - No files in /var/log/postgresql left behind 467s ok 72 - PostgreSQL TCP ports are closed 467s ok 73 - Next free port is 5432 467s ### End test 080_start.conf.t ### 467s 467s ### PostgreSQL test 085_pg_ctl.conf.t ### 468s 1..33 468s ok 1 - prlimit --core=0:unlimited --pid=16563 468s ok 2 - set core file size to unlimited 468s ok 3 - sh -c 'ulimit -Hc' 468s ok 4 - core file size is unlimited 469s ok 5 - pg_createcluster 16 main 469s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 471s ok 7 - pg_ctlcluster 16 main start 471s ok 8 - starting cluster as root 471s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 471s ok 10 - soft core size is 0 471s # hard core file size limit of root-started postgres process is unlimited 471s ok 11 - set pg_ctl default option to -c 473s ok 12 - pg_ctlcluster 16 main restart 473s ok 13 - restarting cluster as root 473s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 473s ok 15 - soft core size is unlimited 474s ok 16 - pg_ctlcluster 16 main stop 474s ok 17 - stopping cluster 474s ok 18 - restored pg_ctl default option 476s ok 19 - pg_ctlcluster 16 main start -- -c 476s ok 20 - starting cluster with -c on the command line as postgres 476s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 476s ok 22 - soft core size is unlimited 476s ok 23 - pg_ctlcluster 16 main stop 476s ok 24 - stopping cluster 477s ok 25 - dropping cluster 477s # Cleanup 477s ok 26 - Cleanup: No clusters left behind 477s ok 27 - No postgres processes left behind 477s ok 28 - No files in /etc/postgresql left behind 477s ok 29 - No files in /var/lib/postgresql left behind 477s ok 30 - No files in /var/run/postgresql left behind 477s ok 31 - No files in /var/log/postgresql left behind 477s ok 32 - PostgreSQL TCP ports are closed 477s ok 33 - Next free port is 5432 477s ### End test 085_pg_ctl.conf.t ### 477s 477s ### PostgreSQL test 090_multicluster.t ### 477s 1..125 478s ok 1 - pg_createcluster 16 old 479s ok 2 - pg_createcluster 16 new1 480s ok 3 - pg_createcluster 16 new2 483s ok 4 - starting cluster 16/old 485s ok 5 - starting cluster 16/new1 487s ok 6 - starting cluster 16/new2 487s ok 7 - pg_lsclusters -h | sort -k3 487s ok 8 - clusters have the correct ports, skipping used 5433 487s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 487s ok 10 - createdb --version 487s ok 11 - pg_wrapper selects port 5432 as default cluster 487s ok 12 - createdb --cluster 16/new1 --version 487s ok 13 - pg_wrapper --cluster works 487s ok 14 - createdb --cluster 16/foo --version 487s ok 15 - pg_wrapper --cluster errors out for invalid cluster 488s ok 16 - createdb --cluster 16/new1 test 488s ok 17 - correct output of createdb --cluster 16/new1 test 488s ok 18 - psql -Atl --cluster 16/new1 488s ok 19 - test db appears in cluster new1 488s ok 20 - psql -Atl --cluster 16/new2 488s ok 21 - test db does not appear in cluster new2 488s ok 22 - psql -Atl 488s ok 23 - test db does not appear in default cluster 488s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 488s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 488s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 488s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 488s ok 28 - psql -Atl --cluster 16/localhost:5434 488s ok 29 - test db appears in cluster 16/localhost:5434 488s ok 30 - psql -Atl --cluster 16/localhost:5440 488s ok 31 - test db does not appear in cluster 16/localhost:5440 488s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 488s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 488s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 488s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 488s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 488s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 488s ok 38 - psql -Atl --cluster 6.4/localhost: 488s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 488s ok 40 - psql -Atl 488s ok 41 - PGCLUSTER selection (1) 488s ok 42 - psql -Atl 488s ok 43 - PGCLUSTER selection (2) 488s ok 44 - psql -l 488s ok 45 - invalid PGCLUSTER value 488s ok 46 - createdb --version 488s ok 47 - PGCLUSTER network cluster selection (1) 488s ok 48 - psql -Atl 488s ok 49 - PGCLUSTER network cluster selection (2) 488s ok 50 - psql -Atl 488s ok 51 - PGCLUSTER network cluster selection (3) 488s ok 52 - LC_MESSAGES=C psql -Atl 488s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 488s ok 54 - psql -Atc "show port" template1 488s ok 55 - PGPORT selection (1) 488s ok 56 - psql -Atc "show port" template1 488s ok 57 - PGPORT selection (2) 488s ok 58 - createdb --version 488s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 488s ok 60 - psql -Atc "show port" template1 488s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 488s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 488s ok 63 - PGDATABASE environment variable works 488s ok 64 - createdb --version 488s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 489s ok 66 - createdb --cluster 16/new1 --version 489s ok 67 - pg_wrapper --cluster works with empty user_clusters 489s ok 68 - createdb --version 489s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 489s ok 70 - psql -Atc "select current_database()" 489s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 489s ok 72 - psql -Atc 'select current_database()' 489s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 489s ok 74 - createdb --version 489s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 489s ok 76 - createdb --version 489s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 489s ok 78 - createdb --version 489s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 489s ok 80 - createdb --version 489s ok 81 - pg_wrapper selects correct version with per-user user_clusters 489s ok 82 - createdb --version 489s ok 83 - pg_wrapper selects correct version with per-user user_clusters 489s ok 84 - createdb --version 489s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 489s ok 86 - psql -Atl 489s ok 87 - $PGHOST overrides user_clusters 489s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 489s ok 89 - --cluster overrides $PGHOST 489s ok 90 - createdb --version 489s ok 91 - pg_wrapper ignores invalid lines in user_clusters 489s ok 92 - psql -Atc 'select current_database()' 489s ok 93 - pg_service conf selection 1 489s ok 94 - psql -Atc 'select current_database()' 489s ok 95 - pg_service conf selection 2 489s ok 96 - psql -Atc 'select current_database()' 489s ok 97 - pg_service conf selection 3 489s ok 98 - stopping cluster 16/old 492s ok 99 - restarting cluster 16/old 492s ok 100 - pg_lsclusters -h | sort -k3 492s ok 101 - port of first cluster was successfully changed 492s ok 102 - psql -l 492s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 492s ok 104 - psql -Atl --cluster 16/new1 492s ok 105 - --cluster selects appropriate cluster 492s ok 106 - psql -Atl -p 5434 492s ok 107 - -p selects appropriate cluster 492s ok 108 - psql -Atlp 5434 492s ok 109 - -Atlp selects appropriate cluster 492s ok 110 - psql -Atl --port 5434 492s ok 111 - --port selects appropriate cluster 492s ok 112 - env PGPORT=5434 psql -Atl 492s ok 113 - $PGPORT selects appropriate cluster 492s ok 114 - Restoring original /etc/postgresql-common/user_clusters 494s ok 115 - dropping 16/new1 495s ok 116 - dropping 16/new2 497s ok 117 - dropping 16/old 497s # Cleanup 497s ok 118 - Cleanup: No clusters left behind 497s ok 119 - No postgres processes left behind 497s ok 120 - No files in /etc/postgresql left behind 497s ok 121 - No files in /var/lib/postgresql left behind 497s ok 122 - No files in /var/run/postgresql left behind 497s ok 123 - No files in /var/log/postgresql left behind 497s ok 124 - PostgreSQL TCP ports are closed 497s ok 125 - Next free port is 5432 497s ### End test 090_multicluster.t ### 497s 497s ### PostgreSQL test 110_integrate_cluster.t ### 497s 1..32 498s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/TWEfe7ZuN8/c/postgres 498s ok 2 - creating raw initdb cluster for user postgres 498s ok 3 - pg_createcluster 16 postgres -d /tmp/TWEfe7ZuN8/c/postgres 498s ok 4 - integrating postgres cluster 498s ok 5 - pg_lsclusters 498s ok 6 - correct pg_lsclusters output 501s ok 7 - pg_ctlcluster 16 postgres start 501s ok 8 - starting cluster postgres 501s ok 9 - pg_lsclusters 501s ok 10 - correct pg_lsclusters output 502s ok 11 - dropping cluster postgres 502s ok 12 - No files in temporary cluster dir left behind 503s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/TWEfe7ZuN8/c/nobody 503s ok 14 - creating raw initdb cluster for user nobody 504s ok 15 - pg_createcluster 16 nobody -d /tmp/TWEfe7ZuN8/c/nobody 504s ok 16 - integrating nobody cluster 504s ok 17 - pg_lsclusters 504s ok 18 - correct pg_lsclusters output 506s ok 19 - pg_ctlcluster 16 nobody start 506s ok 20 - starting cluster nobody 506s ok 21 - pg_lsclusters 506s ok 22 - correct pg_lsclusters output 508s ok 23 - dropping cluster nobody 508s ok 24 - No files in temporary cluster dir left behind 508s # Cleanup 508s ok 25 - Cleanup: No clusters left behind 508s ok 26 - No postgres processes left behind 508s ok 27 - No files in /etc/postgresql left behind 508s ok 28 - No files in /var/lib/postgresql left behind 508s ok 29 - No files in /var/run/postgresql left behind 508s ok 30 - No files in /var/log/postgresql left behind 508s ok 31 - PostgreSQL TCP ports are closed 508s ok 32 - Next free port is 5432 508s ### End test 110_integrate_cluster.t ### 508s 508s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 508s 1..1 508s ok 1 - only one major version installed, skipping upgrade tests 508s ### End test 120_pg_upgradecluster_scripts.t ### 508s 508s ### PostgreSQL test 130_nonroot_admin.t ### 508s 1..22 511s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 511s ok 2 - pg_lsclusters -h 511s ok 3 - correct output of pg_lsclusters -h 511s ok 4 - psql -Atl 511s ok 5 - correct output of psql -Atl 511s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 511s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 511s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 511s # Cleanup 511s ok 15 - Cleanup: No clusters left behind 511s ok 16 - No postgres processes left behind 511s ok 17 - No files in /etc/postgresql left behind 511s ok 18 - No files in /var/lib/postgresql left behind 511s ok 19 - No files in /var/run/postgresql left behind 511s ok 20 - No files in /var/log/postgresql left behind 511s ok 21 - PostgreSQL TCP ports are closed 511s ok 22 - Next free port is 5432 511s ### End test 130_nonroot_admin.t ### 511s 511s ### PostgreSQL test 135_pg_virtualenv.t ### 511s 1..20 516s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 516s ok 2 - running pg_virtualenv as root 519s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 519s ok 4 - running pg_virtualenv as postgres 523s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 523s ok 6 - running pg_virtualenv as nobody 526s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 526s ok 8 - running fakeroot pg_virtualenv as root 529s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 529s ok 10 - running fakeroot pg_virtualenv as postgres 532s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 532s ok 12 - running fakeroot pg_virtualenv as nobody 532s # Cleanup 532s ok 13 - Cleanup: No clusters left behind 532s ok 14 - No postgres processes left behind 532s ok 15 - No files in /etc/postgresql left behind 532s ok 16 - No files in /var/lib/postgresql left behind 532s ok 17 - No files in /var/run/postgresql left behind 532s ok 18 - No files in /var/log/postgresql left behind 532s ok 19 - PostgreSQL TCP ports are closed 532s ok 20 - Next free port is 5432 532s ### End test 135_pg_virtualenv.t ### 532s 532s ### PostgreSQL test 140_pg_config.t ### 533s 1..38 533s # Multiarch is enabled 533s # checking version specific output for 16 533s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 533s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 533s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 533s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 533s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 533s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 533s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 533s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 533s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 533s # checking pg_config output (should behave like version 16) 533s ok 15 - pg_config 533s ok 16 - correct output of pg_config 533s ok 17 - pg_config --help 533s ok 18 - correct output of pg_config --help 533s ok 19 - pg_config --pgxs 533s ok 20 - correct output of pg_config --pgxs 533s ok 21 - pg_config --libdir 533s ok 22 - correct output of pg_config --libdir 533s ok 23 - pg_config --pkglibdir 533s ok 24 - correct output of pg_config --pkglibdir 533s ok 25 - pg_config --bindir 533s ok 26 - correct output of pg_config --bindir 533s # checking pg_config.libpq-dev output (should behave like version 17) 533s ok 27 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 533s ok 28 # skip /usr/lib/postgresql/17/bin/pg_config not installed, can't check full pg_config.libpq-dev output 533s ok 29 - pg_config.libpq-dev --help 533s ok 30 - correct output of pg_config.libpq-dev --help 533s ok 31 - pg_config.libpq-dev --pgxs 533s ok 32 - correct output of pg_config.libpq-dev --pgxs 533s ok 33 - pg_config.libpq-dev --libdir 533s ok 34 - correct output of pg_config.libpq-dev --libdir 533s ok 35 - pg_config.libpq-dev --pkglibdir 533s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 533s ok 37 - pg_config.libpq-dev --bindir 533s ok 38 - correct output of pg_config.libpq-dev --bindir 533s ### End test 140_pg_config.t ### 533s 533s ### PostgreSQL test 150_tsearch_stemming.t ### 533s 1..37 533s ok 1 - pg_updatedicts succeeded 533s ok 2 - pg_updatedicts created en_us.affix 533s ok 3 - pg_updatedicts created en_us.dict 533s ok 4 - pg_updatedicts created 16 en_us.affix symlink 533s ok 5 - pg_updatedicts created 16 en_us.dict symlink 536s ok 6 - pg_createcluster 16 main 536s ok 7 - createdb fts 536s ok 8 - correct output of createdb fts 536s ok 9 - creating en_US full text search configuration 537s ok 10 - creating data table and search index 537s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 537s ok 12 - stem search of correct word 537s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 537s ok 14 - stem search of correct word 537s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 537s ok 16 - stem search of unknown word 537s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 537s ok 18 - full text search, exact word 537s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 537s ok 20 - full text search for word stem 537s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 537s ok 22 - full text search for word substring fails 537s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 537s ok 24 - full text search, exact unicode word 537s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 537s ok 26 - full text search for unicode word stem 537s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 537s ok 28 - full text search for unicode word substring fails 539s ok 29 539s # Cleanup 539s ok 30 - Cleanup: No clusters left behind 539s ok 31 - No postgres processes left behind 539s ok 32 - No files in /etc/postgresql left behind 539s ok 33 - No files in /var/lib/postgresql left behind 539s ok 34 - No files in /var/run/postgresql left behind 539s ok 35 - No files in /var/log/postgresql left behind 539s ok 36 - PostgreSQL TCP ports are closed 539s ok 37 - Next free port is 5432 539s ### End test 150_tsearch_stemming.t ### 539s 539s ### PostgreSQL test 160_alternate_confroot.t ### 539s 1..28 542s ok 1 542s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 542s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 542s ok 4 - pg_lsclusters -h 542s ok 5 - correct output of pg_lsclusters -h 542s ok 6 - psql -Atl 542s ok 7 - correct output of psql -Atl 542s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 542s ok 9 - ... 542s ok 10 - ... 542s ok 11 - ... 542s ok 12 - ... 542s ok 13 - ... 542s ok 14 - ... 543s ok 15 - pg_dropcluster 16 test --stop 543s ok 16 - correct output of pg_dropcluster 16 test --stop 543s ok 17 - pg_lsclusters -h 543s ok 18 - correct output of pg_lsclusters -h 543s ok 19 - No files in root/data left behind 543s ok 20 - No cruft in root dir left behind 543s # Cleanup 543s ok 21 - Cleanup: No clusters left behind 543s ok 22 - No postgres processes left behind 543s ok 23 - No files in /etc/postgresql left behind 543s ok 24 - No files in /var/lib/postgresql left behind 543s ok 25 - No files in /var/run/postgresql left behind 543s ok 26 - No files in /var/log/postgresql left behind 543s ok 27 - PostgreSQL TCP ports are closed 543s ok 28 - Next free port is 5432 543s ### End test 160_alternate_confroot.t ### 543s 543s ### PostgreSQL test 170_extensions.t ### 543s # Running tests for 16 546s ok 1 - pg_createcluster 16 main 546s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 546s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 546s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 546s ok 5 - extension adminpack installs without error 546s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 546s ok 7 - extension adminpack removes without error 546s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 546s ok 9 - extension amcheck installs without error 546s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 546s ok 11 - extension amcheck removes without error 546s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 546s ok 13 - extension autoinc installs without error 546s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 546s ok 15 - extension autoinc removes without error 546s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 546s ok 17 - extension bloom installs without error 546s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 546s ok 19 - extension bloom removes without error 546s ok 20 - psql -qc 'CREATE EXTENSION plperl' 546s ok 21 - bool_plperl dependency plperl installs without error 546s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 546s ok 23 - extension bool_plperl installs without error 547s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 547s ok 25 - extension bool_plperl removes without error 547s ok 26 - psql -qc 'DROP EXTENSION plperl' 547s ok 27 - bool_plperl dependency extension plperl removes without error 547s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 547s ok 29 - bool_plperlu dependency plperlu installs without error 547s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 547s ok 31 - extension bool_plperlu installs without error 547s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 547s ok 33 - extension bool_plperlu removes without error 547s ok 34 - psql -qc 'DROP EXTENSION plperlu' 547s ok 35 - bool_plperlu dependency extension plperlu removes without error 547s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 547s ok 37 - extension btree_gin installs without error 547s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 547s ok 39 - extension btree_gin removes without error 547s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 547s ok 41 - extension btree_gist installs without error 547s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 547s ok 43 - extension btree_gist removes without error 547s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 547s ok 45 - extension citext installs without error 547s ok 46 - psql -qc 'DROP EXTENSION "citext"' 547s ok 47 - extension citext removes without error 547s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 547s ok 49 - extension cube installs without error 547s ok 50 - psql -qc 'DROP EXTENSION "cube"' 547s ok 51 - extension cube removes without error 547s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 547s ok 53 - extension dblink installs without error 547s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 547s ok 55 - extension dblink removes without error 547s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 547s ok 57 - extension dict_int installs without error 547s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 547s ok 59 - extension dict_int removes without error 547s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 547s ok 61 - extension dict_xsyn installs without error 547s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 547s ok 63 - extension dict_xsyn removes without error 548s ok 64 - psql -qc 'CREATE EXTENSION cube' 548s ok 65 - earthdistance dependency cube installs without error 548s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 548s ok 67 - extension earthdistance installs without error 548s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 548s ok 69 - extension earthdistance removes without error 548s ok 70 - psql -qc 'DROP EXTENSION cube' 548s ok 71 - earthdistance dependency extension cube removes without error 548s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 548s ok 73 - extension file_fdw installs without error 548s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 548s ok 75 - extension file_fdw removes without error 548s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 548s ok 77 - extension fuzzystrmatch installs without error 548s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 548s ok 79 - extension fuzzystrmatch removes without error 548s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 548s ok 81 - extension hstore installs without error 548s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 548s ok 83 - extension hstore removes without error 548s ok 84 - psql -qc 'CREATE EXTENSION hstore' 548s ok 85 - hstore_plperl dependency hstore installs without error 548s ok 86 - psql -qc 'CREATE EXTENSION plperl' 548s ok 87 - hstore_plperl dependency plperl installs without error 548s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 548s ok 89 - extension hstore_plperl installs without error 548s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 548s ok 91 - extension hstore_plperl removes without error 548s ok 92 - psql -qc 'DROP EXTENSION hstore' 548s ok 93 - hstore_plperl dependency extension hstore removes without error 548s ok 94 - psql -qc 'DROP EXTENSION plperl' 548s ok 95 - hstore_plperl dependency extension plperl removes without error 548s ok 96 - psql -qc 'CREATE EXTENSION hstore' 548s ok 97 - hstore_plperlu dependency hstore installs without error 548s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 548s ok 99 - hstore_plperlu dependency plperlu installs without error 548s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 548s ok 101 - extension hstore_plperlu installs without error 548s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 548s ok 103 - extension hstore_plperlu removes without error 549s ok 104 - psql -qc 'DROP EXTENSION hstore' 549s ok 105 - hstore_plperlu dependency extension hstore removes without error 549s ok 106 - psql -qc 'DROP EXTENSION plperlu' 549s ok 107 - hstore_plperlu dependency extension plperlu removes without error 549s ok 108 - psql -qc 'CREATE EXTENSION hstore' 549s ok 109 - hstore_plpython3u dependency hstore installs without error 549s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 549s ok 111 - hstore_plpython3u dependency plpython3u installs without error 549s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 549s ok 113 - extension hstore_plpython3u installs without error 549s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 549s ok 115 - extension hstore_plpython3u removes without error 549s ok 116 - psql -qc 'DROP EXTENSION hstore' 549s ok 117 - hstore_plpython3u dependency extension hstore removes without error 549s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 549s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 549s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 549s ok 121 - extension insert_username installs without error 549s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 549s ok 123 - extension insert_username removes without error 549s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 549s ok 125 - extension intagg installs without error 549s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 549s ok 127 - extension intagg removes without error 549s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 549s ok 129 - extension intarray installs without error 549s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 549s ok 131 - extension intarray removes without error 549s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 549s ok 133 - extension isn installs without error 549s ok 134 - psql -qc 'DROP EXTENSION "isn"' 549s ok 135 - extension isn removes without error 549s ok 136 - psql -qc 'CREATE EXTENSION plperl' 549s ok 137 - jsonb_plperl dependency plperl installs without error 549s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 549s ok 139 - extension jsonb_plperl installs without error 550s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 550s ok 141 - extension jsonb_plperl removes without error 550s ok 142 - psql -qc 'DROP EXTENSION plperl' 550s ok 143 - jsonb_plperl dependency extension plperl removes without error 550s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 550s ok 145 - jsonb_plperlu dependency plperlu installs without error 550s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 550s ok 147 - extension jsonb_plperlu installs without error 550s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 550s ok 149 - extension jsonb_plperlu removes without error 550s ok 150 - psql -qc 'DROP EXTENSION plperlu' 550s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 550s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 550s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 550s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 550s ok 155 - extension jsonb_plpython3u installs without error 550s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 550s ok 157 - extension jsonb_plpython3u removes without error 550s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 550s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 550s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 550s ok 161 - extension lo installs without error 550s ok 162 - psql -qc 'DROP EXTENSION "lo"' 550s ok 163 - extension lo removes without error 550s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 550s ok 165 - extension ltree installs without error 550s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 550s ok 167 - extension ltree removes without error 550s ok 168 - psql -qc 'CREATE EXTENSION ltree' 550s ok 169 - ltree_plpython3u dependency ltree installs without error 550s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 550s ok 171 - ltree_plpython3u dependency plpython3u installs without error 550s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 550s ok 173 - extension ltree_plpython3u installs without error 550s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 550s ok 175 - extension ltree_plpython3u removes without error 550s ok 176 - psql -qc 'DROP EXTENSION ltree' 550s ok 177 - ltree_plpython3u dependency extension ltree removes without error 550s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 550s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 550s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 550s ok 181 - extension moddatetime installs without error 551s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 551s ok 183 - extension moddatetime removes without error 551s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 551s ok 185 - extension old_snapshot installs without error 551s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 551s ok 187 - extension old_snapshot removes without error 551s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 551s ok 189 - extension pageinspect installs without error 551s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 551s ok 191 - extension pageinspect removes without error 551s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 551s ok 193 - extension pg_buffercache installs without error 551s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 551s ok 195 - extension pg_buffercache removes without error 551s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 551s ok 197 - extension pg_freespacemap installs without error 551s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 551s ok 199 - extension pg_freespacemap removes without error 551s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 551s ok 201 - extension pg_prewarm installs without error 551s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 551s ok 203 - extension pg_prewarm removes without error 551s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 551s ok 205 - extension pg_stat_statements installs without error 551s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 551s ok 207 - extension pg_stat_statements removes without error 551s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 551s ok 209 - extension pg_surgery installs without error 551s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 551s ok 211 - extension pg_surgery removes without error 551s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 551s ok 213 - extension pg_trgm installs without error 551s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 551s ok 215 - extension pg_trgm removes without error 551s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 551s ok 217 - extension pg_visibility installs without error 551s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 551s ok 219 - extension pg_visibility removes without error 551s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 551s ok 221 - extension pg_walinspect installs without error 551s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 551s ok 223 - extension pg_walinspect removes without error 551s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 551s ok 225 - extension pgcrypto installs without error 552s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 552s ok 227 - extension pgcrypto removes without error 552s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 552s ok 229 - extension pgrowlocks installs without error 552s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 552s ok 231 - extension pgrowlocks removes without error 552s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 552s ok 233 - extension pgstattuple installs without error 552s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 552s ok 235 - extension pgstattuple removes without error 552s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 552s ok 237 - extension plperl installs without error 552s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 552s ok 239 - extension plperl removes without error 552s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 552s ok 241 - extension plperlu installs without error 552s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 552s ok 243 - extension plperlu removes without error 552s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 552s ok 245 - extension plpython3u installs without error 552s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 552s ok 247 - extension plpython3u removes without error 552s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 552s ok 249 - extension pltcl installs without error 552s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 552s ok 251 - extension pltcl removes without error 552s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 552s ok 253 - extension pltclu installs without error 552s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 552s ok 255 - extension pltclu removes without error 552s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 552s ok 257 - extension postgres_fdw installs without error 552s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 552s ok 259 - extension postgres_fdw removes without error 552s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 552s ok 261 - extension refint installs without error 552s ok 262 - psql -qc 'DROP EXTENSION "refint"' 552s ok 263 - extension refint removes without error 552s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 552s ok 265 - extension seg installs without error 552s ok 266 - psql -qc 'DROP EXTENSION "seg"' 552s ok 267 - extension seg removes without error 552s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 552s ok 269 - extension sslinfo installs without error 553s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 553s ok 271 - extension sslinfo removes without error 553s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 553s ok 273 - extension tablefunc installs without error 553s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 553s ok 275 - extension tablefunc removes without error 553s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 553s ok 277 - extension tcn installs without error 553s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 553s ok 279 - extension tcn removes without error 553s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 553s ok 281 - extension tsm_system_rows installs without error 553s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 553s ok 283 - extension tsm_system_rows removes without error 553s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 553s ok 285 - extension tsm_system_time installs without error 553s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 553s ok 287 - extension tsm_system_time removes without error 553s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 553s ok 289 - extension unaccent installs without error 553s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 553s ok 291 - extension unaccent removes without error 553s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 553s ok 293 - extension uuid-ossp installs without error 553s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 553s ok 295 - extension uuid-ossp removes without error 553s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 553s ok 297 - extension xml2 installs without error 553s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 553s ok 299 - extension xml2 removes without error 555s ok 300 - pg_dropcluster 16 main 555s # Cleanup 555s ok 301 - Cleanup: No clusters left behind 555s ok 302 - No postgres processes left behind 555s ok 303 - No files in /etc/postgresql left behind 555s ok 304 - No files in /var/lib/postgresql left behind 555s ok 305 - No files in /var/run/postgresql left behind 555s ok 306 - No files in /var/log/postgresql left behind 555s ok 307 - PostgreSQL TCP ports are closed 555s ok 308 - Next free port is 5432 555s 1..308 555s ### End test 170_extensions.t ### 555s 555s ### PostgreSQL test 180_ecpg.t ### 555s 1..14 555s ok 1 - ecpg test.pgc 555s ok 2 - ecpg processing 555s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 555s ok 4 - compiling ecpg output 562s ok 5 - pg_virtualenv /tmp/tmp.lILpoFF35Q/test 562s ok 6 - test program runs and gives correct output 562s # Cleanup 562s ok 7 - Cleanup: No clusters left behind 562s ok 8 - No postgres processes left behind 562s ok 9 - No files in /etc/postgresql left behind 562s ok 10 - No files in /var/lib/postgresql left behind 562s ok 11 - No files in /var/run/postgresql left behind 562s ok 12 - No files in /var/log/postgresql left behind 562s ok 13 - PostgreSQL TCP ports are closed 562s ok 14 - Next free port is 5432 562s ### End test 180_ecpg.t ### 562s 562s ### PostgreSQL test 190_pg_buildext.t ### 562s ok 1 - make clean 563s ok 2 - make tar 563s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 563s # testing 'dh --with pgxs' 566s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 566s ok 5 - postgresql-16-foo_123-1_amd64.deb was built 573s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 573s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 574s ok 8 - dpkg -i postgresql-16-foo_123-1_amd64.deb 581s ok 9 - cd foo-123 && pg_buildext installcheck 581s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 588s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 588s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 596s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 596s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 596s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 596s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 596s ok 17 - dpkg -r postgresql-16-foo 596s # testing 'dh --with pgxs_loop' 596s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 599s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 599s ok 20 - postgresql-16-foo_123-1_amd64.deb was built 599s ok 21 - make clean 599s # testing pg_buildext updatecontrol 599s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 599s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 599s 1..23 599s ### End test 190_pg_buildext.t ### 599s 599s ### PostgreSQL test 200_maintscripts.t ### 599s 1..15 599s # We are running systemd 602s ok 1 - pg_createcluster 16 main --start 602s ok 2 - postmaster PID is 23038 604s ok 3 - apt-get update -q 604s # postgresql-common: 604s # Installed: 262 604s # Candidate: 262 604s # Version table: 604s # 267 100 604s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages 604s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages 604s # *** 262 500 604s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 604s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 604s # 100 /var/lib/dpkg/status 607s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 607s # postgresql-common: 607s # Installed: 262 607s # Candidate: 262 607s # Version table: 607s # 267 100 607s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages 607s # 100 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages 607s # *** 262 500 607s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 607s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 607s # 100 /var/lib/dpkg/status 607s ok 5 - postmaster PID is 23038 607s ok 6 - postmaster was not restarted 609s ok 7 - pg_dropcluster 16 main --stop 609s # Cleanup 609s ok 8 - Cleanup: No clusters left behind 609s ok 9 - No postgres processes left behind 609s ok 10 - No files in /etc/postgresql left behind 609s ok 11 - No files in /var/lib/postgresql left behind 609s ok 12 - No files in /var/run/postgresql left behind 609s ok 13 - No files in /var/log/postgresql left behind 609s ok 14 - PostgreSQL TCP ports are closed 609s ok 15 - Next free port is 5432 609s ### End test 200_maintscripts.t ### 609s 610s autopkgtest [22:51:44]: test run-testsuite: -----------------------] 610s autopkgtest [22:51:44]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 610s run-testsuite PASS 610s autopkgtest [22:51:44]: @@@@@@@@@@@@@@@@@@@@ summary 610s default-psql PASS 610s run-testsuite PASS 625s nova [W] Skipping flock for amd64 625s Creating nova instance adt-plucky-amd64-postgresql-common-20250102-224133-juju-7f2275-prod-proposed-migration-environment-2-afb82e6a-8e2f-4de6-b255-9884e8c364e1 from image adt/ubuntu-plucky-amd64-server-20250102.img (UUID 1d6e8f8e-081e-41c6-b3dd-06bd07411f46)... 625s nova [W] Timed out waiting for ca85c87a-bd88-45ca-a1eb-deb584c51499 to get deleted. 625s nova [W] Skipping flock for amd64 625s Creating nova instance adt-plucky-amd64-postgresql-common-20250102-224133-juju-7f2275-prod-proposed-migration-environment-2-afb82e6a-8e2f-4de6-b255-9884e8c364e1 from image adt/ubuntu-plucky-amd64-server-20250102.img (UUID 1d6e8f8e-081e-41c6-b3dd-06bd07411f46)... 625s nova [W] Timed out waiting for 529257e1-42d3-43c2-b34e-05e18edcfefc to get deleted.