0s autopkgtest [08:27:27]: starting date and time: 2024-06-25 08:27:27+0000 0s autopkgtest [08:27:27]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [08:27:27]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.0mh3wg_1/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:fakeroot --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=fakeroot/1.35.1-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos02-s390x-4.secgroup --name adt-oracular-s390x-postgresql-common-20240625-082727-juju-7f2275-prod-proposed-migration-environment-2-b10fa386-1122-44ef-9729-7827c79246ef --image adt/ubuntu-oracular-s390x-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'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 127s autopkgtest [08:29:34]: testbed dpkg architecture: s390x 128s autopkgtest [08:29:35]: testbed apt version: 2.9.5 128s autopkgtest [08:29:35]: @@@@@@@@@@@@@@@@@@@@ test bed setup 128s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 129s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 129s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 129s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 129s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 129s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x Packages [109 kB] 130s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted s390x Packages [1860 B] 130s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x Packages [367 kB] 130s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse s390x Packages [2528 B] 130s Fetched 1098 kB in 2s (676 kB/s) 130s Reading package lists... 132s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Calculating upgrade... 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 134s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 134s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 134s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 135s Reading package lists... 135s Reading package lists... 136s Building dependency tree... 136s Reading state information... 136s Calculating upgrade... 136s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 136s Reading package lists... 136s Building dependency tree... 136s Reading state information... 137s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 139s autopkgtest [08:29:46]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP Sat Apr 20 00:14:26 UTC 2024 140s autopkgtest [08:29:47]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 145s Get:1 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (dsc) [2383 B] 145s Get:2 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (tar) [218 kB] 145s gpgv: Signature made Thu May 9 15:21:37 2024 UTC 145s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 145s gpgv: Can't check signature: No public key 145s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_260.dsc: no acceptable signature found 145s autopkgtest [08:29:52]: testing package postgresql-common version 260 146s autopkgtest [08:29:53]: build not needed 146s autopkgtest [08:29:53]: test default-psql: preparing testbed 148s Reading package lists... 148s Building dependency tree... 148s Reading state information... 148s Starting pkgProblemResolver with broken count: 0 148s Starting 2 pkgProblemResolver with broken count: 0 148s Done 148s The following additional packages will be installed: 148s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 148s postgresql-client-common postgresql-common ssl-cert 148s Suggested packages: 148s postgresql-doc postgresql-doc-16 148s Recommended packages: 148s libjson-xs-perl 149s The following NEW packages will be installed: 149s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 149s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 149s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 149s Need to get 18.6 MB/18.6 MB of archives. 149s After this operation, 53.1 MB of additional disk space will be used. 149s Get:1 /tmp/autopkgtest.8SrhIl/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [704 B] 149s Get:2 http://ftpmaster.internal/ubuntu oracular/main s390x libjson-perl all 4.10000-1 [81.9 kB] 149s Get:3 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-client-common all 260 [36.4 kB] 149s Get:4 http://ftpmaster.internal/ubuntu oracular/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 149s Get:5 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-common all 260 [162 kB] 149s Get:6 http://ftpmaster.internal/ubuntu oracular/main s390x libpq5 s390x 16.3-1 [144 kB] 150s Get:7 http://ftpmaster.internal/ubuntu oracular/main s390x libxslt1.1 s390x 1.1.39-0exp1build1 [170 kB] 150s Get:8 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-client-16 s390x 16.3-1 [1290 kB] 151s Get:9 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-16 s390x 16.3-1 [16.7 MB] 154s Get:10 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql all 16+260 [11.6 kB] 154s Preconfiguring packages ... 154s Fetched 18.6 MB in 5s (3524 kB/s) 154s Selecting previously unselected package libjson-perl. 154s (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 ... 54644 files and directories currently installed.) 154s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 154s Unpacking libjson-perl (4.10000-1) ... 154s Selecting previously unselected package postgresql-client-common. 154s Preparing to unpack .../1-postgresql-client-common_260_all.deb ... 154s Unpacking postgresql-client-common (260) ... 154s Selecting previously unselected package ssl-cert. 154s Preparing to unpack .../2-ssl-cert_1.1.2ubuntu1_all.deb ... 154s Unpacking ssl-cert (1.1.2ubuntu1) ... 154s Selecting previously unselected package postgresql-common. 154s Preparing to unpack .../3-postgresql-common_260_all.deb ... 154s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 154s Unpacking postgresql-common (260) ... 154s Selecting previously unselected package libpq5:s390x. 154s Preparing to unpack .../4-libpq5_16.3-1_s390x.deb ... 154s Unpacking libpq5:s390x (16.3-1) ... 154s Selecting previously unselected package libxslt1.1:s390x. 154s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1build1_s390x.deb ... 154s Unpacking libxslt1.1:s390x (1.1.39-0exp1build1) ... 154s Selecting previously unselected package postgresql-client-16. 154s Preparing to unpack .../6-postgresql-client-16_16.3-1_s390x.deb ... 154s Unpacking postgresql-client-16 (16.3-1) ... 155s Selecting previously unselected package postgresql-16. 155s Preparing to unpack .../7-postgresql-16_16.3-1_s390x.deb ... 155s Unpacking postgresql-16 (16.3-1) ... 155s Selecting previously unselected package postgresql. 155s Preparing to unpack .../8-postgresql_16+260_all.deb ... 155s Unpacking postgresql (16+260) ... 155s Selecting previously unselected package autopkgtest-satdep. 155s Preparing to unpack .../9-1-autopkgtest-satdep.deb ... 155s Unpacking autopkgtest-satdep (0) ... 155s Setting up postgresql-client-common (260) ... 155s Setting up libpq5:s390x (16.3-1) ... 155s Setting up ssl-cert (1.1.2ubuntu1) ... 157s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 157s Setting up libjson-perl (4.10000-1) ... 157s Setting up libxslt1.1:s390x (1.1.39-0exp1build1) ... 157s Setting up postgresql-client-16 (16.3-1) ... 158s 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 158s Setting up postgresql-common (260) ... 158s 158s Creating config file /etc/postgresql-common/createcluster.conf with new version 158s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 158s Removing obsolete dictionary files: 159s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 159s Setting up postgresql-16 (16.3-1) ... 160s Creating new PostgreSQL cluster 16/main ... 160s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 160s The files belonging to this database system will be owned by user "postgres". 160s This user must also own the server process. 160s 160s The database cluster will be initialized with locale "C.UTF-8". 160s The default database encoding has accordingly been set to "UTF8". 160s The default text search configuration will be set to "english". 160s 160s Data page checksums are disabled. 160s 160s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 160s creating subdirectories ... ok 160s selecting dynamic shared memory implementation ... posix 160s selecting default max_connections ... 100 160s selecting default shared_buffers ... 128MB 160s selecting default time zone ... Etc/UTC 160s creating configuration files ... ok 160s running bootstrap script ... ok 160s performing post-bootstrap initialization ... ok 160s syncing data to disk ... ok 164s Setting up postgresql (16+260) ... 164s Setting up autopkgtest-satdep (0) ... 164s Processing triggers for man-db (2.12.1-2) ... 165s Processing triggers for libc-bin (2.39-0ubuntu9) ... 168s (Reading database ... 56585 files and directories currently installed.) 168s Removing autopkgtest-satdep (0) ... 169s autopkgtest [08:30:16]: test default-psql: [----------------------- 170s autopkgtest [08:30:17]: test default-psql: -----------------------] 171s default-psql PASS 171s autopkgtest [08:30:18]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 172s autopkgtest [08:30:19]: test run-testsuite: preparing testbed 266s autopkgtest [08:31:53]: testbed dpkg architecture: s390x 267s autopkgtest [08:31:54]: testbed apt version: 2.9.5 267s autopkgtest [08:31:54]: @@@@@@@@@@@@@@@@@@@@ test bed setup 268s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 268s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 268s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 268s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 269s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 269s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x Packages [109 kB] 270s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted s390x Packages [1860 B] 270s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x Packages [367 kB] 270s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse s390x Packages [2528 B] 270s Fetched 1098 kB in 3s (406 kB/s) 270s Reading package lists... 272s Reading package lists... 273s Building dependency tree... 273s Reading state information... 273s Calculating upgrade... 273s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 273s Reading package lists... 273s Building dependency tree... 273s Reading state information... 274s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 274s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 274s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 274s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 274s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 275s Reading package lists... 276s Reading package lists... 276s Building dependency tree... 276s Reading state information... 276s Calculating upgrade... 276s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 276s Reading package lists... 276s Building dependency tree... 276s Reading state information... 277s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 281s Reading package lists... 281s Building dependency tree... 281s Reading state information... 282s Starting pkgProblemResolver with broken count: 0 282s Starting 2 pkgProblemResolver with broken count: 0 282s Done 282s The following additional packages will be installed: 282s autoconf automake autopoint autotools-dev build-essential clang-18 cpp 282s cpp-13 cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 282s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 282s fakeroot g++ g++-13 g++-13-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-13 282s gcc-13-base gcc-13-s390x-linux-gnu gcc-s390x-linux-gnu gettext 282s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 282s libatomic1 libcc1-0 libclang-common-18-dev libdebhelper-perl libecpg-compat3 282s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 282s libgc1 libgcc-13-dev libgomp1 libicu-dev libisl23 libitm1 libjson-perl 282s libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev 282s libpq5 libpython3.12t64 libssl-dev libstdc++-13-dev libtcl8.6 libtool 282s libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev llvm-18 llvm-18-dev 282s llvm-18-linker-tools llvm-18-runtime llvm-18-tools locales-all m4 po-debconf 282s postgresql-16 postgresql-all postgresql-client-16 postgresql-client-common 282s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 282s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 282s postgresql-server-dev-all ssl-cert 282s Suggested packages: 282s autoconf-archive gnu-standards autoconf-doc clang-18-doc wasi-libc cpp-doc 282s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 282s g++-multilib g++-13-multilib gcc-13-doc gcc-multilib manpages-dev flex bison 282s gdb gcc-doc gcc-13-multilib gdb-s390x-linux-gnu gettext-doc libasprintf-dev 282s libgettextpo-dev hunspell openoffice.org-hunspell | openoffice.org-core 282s icu-doc ncurses-doc libssl-doc libstdc++-13-doc tcl8.6 libtool-doc gfortran 282s | fortran95-compiler gcj-jdk pkg-config llvm-18-doc m4-doc libmail-box-perl 282s Recommended packages: 282s libclang-rt-18-dev libarchive-cpio-perl libjson-xs-perl libltdl-dev 282s libmail-sendmail-perl 282s The following NEW packages will be installed: 282s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 282s clang-18 cpp cpp-13 cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper 282s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 282s emacsen-common fakeroot g++ g++-13 g++-13-s390x-linux-gnu 282s g++-s390x-linux-gnu gcc gcc-13 gcc-13-base gcc-13-s390x-linux-gnu 282s gcc-s390x-linux-gnu gettext hunspell-en-us icu-devtools intltool-debian 282s libarchive-zip-perl libasan8 libatomic1 libcc1-0 libclang-common-18-dev 282s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 282s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 282s libicu-dev libisl23 libitm1 libjson-perl libmpc3 libncurses-dev 282s libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 282s libpython3.12t64 libssl-dev libstdc++-13-dev libtcl8.6 libtool libubsan1 282s libxml2-dev libxslt1.1 libz3-4 libz3-dev llvm-18 llvm-18-dev 282s llvm-18-linker-tools llvm-18-runtime llvm-18-tools locales-all m4 po-debconf 282s postgresql-16 postgresql-all postgresql-client-16 postgresql-client-common 282s postgresql-common postgresql-doc postgresql-doc-16 postgresql-plperl-16 282s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 282s postgresql-server-dev-all ssl-cert 282s 0 upgraded, 90 newly installed, 0 to remove and 0 not upgraded. 282s Need to get 195 MB/195 MB of archives. 282s After this operation, 1119 MB of additional disk space will be used. 282s Get:1 /tmp/autopkgtest.8SrhIl/2-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [800 B] 282s Get:2 http://ftpmaster.internal/ubuntu oracular/main s390x libjson-perl all 4.10000-1 [81.9 kB] 283s Get:3 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-client-common all 260 [36.4 kB] 283s Get:4 http://ftpmaster.internal/ubuntu oracular/main s390x ssl-cert all 1.1.2ubuntu1 [17.8 kB] 283s Get:5 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-common all 260 [162 kB] 283s Get:6 http://ftpmaster.internal/ubuntu oracular/main s390x m4 s390x 1.4.19-4build1 [256 kB] 283s Get:7 http://ftpmaster.internal/ubuntu oracular/main s390x autoconf all 2.71-3 [339 kB] 284s Get:8 http://ftpmaster.internal/ubuntu oracular/main s390x autotools-dev all 20220109.1 [44.9 kB] 284s Get:9 http://ftpmaster.internal/ubuntu oracular/main s390x automake all 1:1.16.5-1.3ubuntu1 [558 kB] 284s Get:10 http://ftpmaster.internal/ubuntu oracular/main s390x autopoint all 0.21-14ubuntu2 [422 kB] 284s Get:11 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13-base s390x 13.2.0-23ubuntu4 [48.9 kB] 285s Get:12 http://ftpmaster.internal/ubuntu oracular/main s390x libisl23 s390x 0.26-3build1 [713 kB] 285s Get:13 http://ftpmaster.internal/ubuntu oracular/main s390x libmpc3 s390x 1.3.1-1build1 [58.4 kB] 285s Get:14 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-13-s390x-linux-gnu s390x 13.2.0-23ubuntu4 [9939 kB] 287s Get:15 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-13 s390x 13.2.0-23ubuntu4 [1030 B] 287s Get:16 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [5308 B] 287s Get:17 http://ftpmaster.internal/ubuntu oracular/main s390x cpp s390x 4:13.2.0-7ubuntu1 [22.4 kB] 287s Get:18 http://ftpmaster.internal/ubuntu oracular/main s390x libcc1-0 s390x 14.1.0-1ubuntu1 [50.7 kB] 287s Get:19 http://ftpmaster.internal/ubuntu oracular/main s390x libgomp1 s390x 14.1.0-1ubuntu1 [151 kB] 287s Get:20 http://ftpmaster.internal/ubuntu oracular/main s390x libitm1 s390x 14.1.0-1ubuntu1 [31.1 kB] 287s Get:21 http://ftpmaster.internal/ubuntu oracular/main s390x libatomic1 s390x 14.1.0-1ubuntu1 [9378 B] 287s Get:22 http://ftpmaster.internal/ubuntu oracular/main s390x libasan8 s390x 14.1.0-1ubuntu1 [3003 kB] 287s Get:23 http://ftpmaster.internal/ubuntu oracular/main s390x libubsan1 s390x 14.1.0-1ubuntu1 [1189 kB] 287s Get:24 http://ftpmaster.internal/ubuntu oracular/main s390x libgcc-13-dev s390x 13.2.0-23ubuntu4 [1004 kB] 287s Get:25 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13-s390x-linux-gnu s390x 13.2.0-23ubuntu4 [19.1 MB] 289s Get:26 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13 s390x 13.2.0-23ubuntu4 [472 kB] 289s Get:27 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [1208 B] 289s Get:28 http://ftpmaster.internal/ubuntu oracular/main s390x gcc s390x 4:13.2.0-7ubuntu1 [5014 B] 289s Get:29 http://ftpmaster.internal/ubuntu oracular/main s390x libstdc++-13-dev s390x 13.2.0-23ubuntu4 [2494 kB] 289s Get:30 http://ftpmaster.internal/ubuntu oracular/main s390x g++-13-s390x-linux-gnu s390x 13.2.0-23ubuntu4 [11.3 MB] 289s Get:31 http://ftpmaster.internal/ubuntu oracular/main s390x g++-13 s390x 13.2.0-23ubuntu4 [14.5 kB] 289s Get:32 http://ftpmaster.internal/ubuntu oracular/main s390x g++-s390x-linux-gnu s390x 4:13.2.0-7ubuntu1 [956 B] 289s Get:33 http://ftpmaster.internal/ubuntu oracular/main s390x g++ s390x 4:13.2.0-7ubuntu1 [1096 B] 289s Get:34 http://ftpmaster.internal/ubuntu oracular/main s390x build-essential s390x 12.10ubuntu1 [4930 B] 289s Get:35 http://ftpmaster.internal/ubuntu oracular/main s390x libgc1 s390x 1:8.2.6-1build1 [95.1 kB] 289s Get:36 http://ftpmaster.internal/ubuntu oracular/universe s390x libobjc4 s390x 14.1.0-1ubuntu1 [50.3 kB] 289s Get:37 http://ftpmaster.internal/ubuntu oracular/universe s390x libobjc-13-dev s390x 13.2.0-23ubuntu4 [194 kB] 289s Get:38 http://ftpmaster.internal/ubuntu oracular/universe s390x libclang-common-18-dev s390x 1:18.1.7-1 [734 kB] 289s Get:39 http://ftpmaster.internal/ubuntu oracular/universe s390x llvm-18-linker-tools s390x 1:18.1.7-1 [1519 kB] 289s Get:40 http://ftpmaster.internal/ubuntu oracular/universe s390x clang-18 s390x 1:18.1.7-1 [79.4 kB] 289s Get:41 http://ftpmaster.internal/ubuntu oracular/main s390x libdebhelper-perl all 13.15.3ubuntu2 [92.3 kB] 289s Get:42 http://ftpmaster.internal/ubuntu oracular/main s390x libtool all 2.4.7-7build1 [166 kB] 289s Get:43 http://ftpmaster.internal/ubuntu oracular/main s390x dh-autoreconf all 20 [16.1 kB] 289s Get:44 http://ftpmaster.internal/ubuntu oracular/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 289s Get:45 http://ftpmaster.internal/ubuntu oracular/main s390x libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 289s Get:46 http://ftpmaster.internal/ubuntu oracular/main s390x dh-strip-nondeterminism all 1.14.0-1 [5058 B] 289s Get:47 http://ftpmaster.internal/ubuntu oracular/main s390x debugedit s390x 1:5.0-5build2 [50.5 kB] 289s Get:48 http://ftpmaster.internal/ubuntu oracular/main s390x dwz s390x 0.15-1build6 [122 kB] 289s Get:49 http://ftpmaster.internal/ubuntu oracular/main s390x gettext s390x 0.21-14ubuntu2 [915 kB] 289s Get:50 http://ftpmaster.internal/ubuntu oracular/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 289s Get:51 http://ftpmaster.internal/ubuntu oracular/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 289s Get:52 http://ftpmaster.internal/ubuntu oracular/main s390x debhelper all 13.15.3ubuntu2 [878 kB] 289s Get:53 http://ftpmaster.internal/ubuntu oracular/main s390x emacsen-common all 3.0.5 [12.1 kB] 289s Get:54 http://ftpmaster.internal/ubuntu oracular/main s390x dictionaries-common all 1.29.7 [188 kB] 289s Get:55 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x libfakeroot s390x 1.35.1-1 [31.6 kB] 289s Get:56 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x fakeroot s390x 1.35.1-1 [67.6 kB] 289s Get:57 http://ftpmaster.internal/ubuntu oracular/main s390x hunspell-en-us all 1:2020.12.07-2 [280 kB] 289s Get:58 http://ftpmaster.internal/ubuntu oracular/main s390x icu-devtools s390x 74.2-1ubuntu3 [223 kB] 289s Get:59 http://ftpmaster.internal/ubuntu oracular/main s390x libpgtypes3 s390x 16.3-1 [48.3 kB] 289s Get:60 http://ftpmaster.internal/ubuntu oracular/main s390x libpq5 s390x 16.3-1 [144 kB] 289s Get:61 http://ftpmaster.internal/ubuntu oracular/main s390x libecpg6 s390x 16.3-1 [47.2 kB] 289s Get:62 http://ftpmaster.internal/ubuntu oracular/main s390x libecpg-compat3 s390x 16.3-1 [18.5 kB] 289s Get:63 http://ftpmaster.internal/ubuntu oracular/main s390x libssl-dev s390x 3.0.13-0ubuntu4 [2110 kB] 289s Get:64 http://ftpmaster.internal/ubuntu oracular/main s390x libpq-dev s390x 16.3-1 [154 kB] 289s Get:65 http://ftpmaster.internal/ubuntu oracular/main s390x libecpg-dev s390x 16.3-1 [277 kB] 289s Get:66 http://ftpmaster.internal/ubuntu oracular/main s390x libicu-dev s390x 74.2-1ubuntu3 [11.9 MB] 290s Get:67 http://ftpmaster.internal/ubuntu oracular/main s390x libncurses-dev s390x 6.5-2 [404 kB] 290s Get:68 http://ftpmaster.internal/ubuntu oracular/main s390x libpython3.12t64 s390x 3.12.4-1 [2507 kB] 290s Get:69 http://ftpmaster.internal/ubuntu oracular/main s390x libtcl8.6 s390x 8.6.14+dfsg-1build1 [1038 kB] 290s Get:70 http://ftpmaster.internal/ubuntu oracular/main s390x libxml2-dev s390x 2.9.14+dfsg-1.3ubuntu3 [833 kB] 290s Get:71 http://ftpmaster.internal/ubuntu oracular/main s390x libxslt1.1 s390x 1.1.39-0exp1build1 [170 kB] 290s Get:72 http://ftpmaster.internal/ubuntu oracular/universe s390x llvm-18-runtime s390x 1:18.1.7-1 [611 kB] 290s Get:73 http://ftpmaster.internal/ubuntu oracular/universe s390x libpfm4 s390x 4.13.0+git32-g0d4ed0e-1 [38.8 kB] 290s Get:74 http://ftpmaster.internal/ubuntu oracular/universe s390x llvm-18 s390x 1:18.1.7-1 [29.5 MB] 291s Get:75 http://ftpmaster.internal/ubuntu oracular/main s390x libffi-dev s390x 3.4.6-1build1 [58.8 kB] 291s Get:76 http://ftpmaster.internal/ubuntu oracular/universe s390x llvm-18-tools s390x 1:18.1.7-1 [578 kB] 291s Get:77 http://ftpmaster.internal/ubuntu oracular/universe s390x libz3-4 s390x 4.8.12-3.1build1 [6507 kB] 291s Get:78 http://ftpmaster.internal/ubuntu oracular/universe s390x libz3-dev s390x 4.8.12-3.1build1 [72.2 kB] 291s Get:79 http://ftpmaster.internal/ubuntu oracular/universe s390x llvm-18-dev s390x 1:18.1.7-1 [47.6 MB] 293s Get:80 http://ftpmaster.internal/ubuntu oracular/universe s390x locales-all s390x 2.39-0ubuntu9 [11.3 MB] 294s Get:81 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-client-16 s390x 16.3-1 [1290 kB] 294s Get:82 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-16 s390x 16.3-1 [16.7 MB] 294s Get:83 http://ftpmaster.internal/ubuntu oracular/universe s390x postgresql-server-dev-16 s390x 16.3-1 [1229 kB] 294s Get:84 http://ftpmaster.internal/ubuntu oracular/universe s390x postgresql-server-dev-all s390x 260 [20.6 kB] 294s Get:85 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-plperl-16 s390x 16.3-1 [70.1 kB] 294s Get:86 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-plpython3-16 s390x 16.3-1 [76.6 kB] 294s Get:87 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-pltcl-16 s390x 16.3-1 [31.4 kB] 294s Get:88 http://ftpmaster.internal/ubuntu oracular/universe s390x postgresql-all all 260 [1712 B] 294s Get:89 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-doc-16 all 16.3-1 [2098 kB] 294s Get:90 http://ftpmaster.internal/ubuntu oracular/main s390x postgresql-doc all 16+260 [11.6 kB] 295s Preconfiguring packages ... 295s Fetched 195 MB in 12s (16.0 MB/s) 295s Selecting previously unselected package libjson-perl. 295s (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 ... 54644 files and directories currently installed.) 295s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 295s Unpacking libjson-perl (4.10000-1) ... 295s Selecting previously unselected package postgresql-client-common. 295s Preparing to unpack .../01-postgresql-client-common_260_all.deb ... 295s Unpacking postgresql-client-common (260) ... 295s Selecting previously unselected package ssl-cert. 295s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 295s Unpacking ssl-cert (1.1.2ubuntu1) ... 295s Selecting previously unselected package postgresql-common. 295s Preparing to unpack .../03-postgresql-common_260_all.deb ... 295s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 295s Unpacking postgresql-common (260) ... 295s Selecting previously unselected package m4. 295s Preparing to unpack .../04-m4_1.4.19-4build1_s390x.deb ... 295s Unpacking m4 (1.4.19-4build1) ... 295s Selecting previously unselected package autoconf. 295s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 295s Unpacking autoconf (2.71-3) ... 295s Selecting previously unselected package autotools-dev. 295s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 295s Unpacking autotools-dev (20220109.1) ... 295s Selecting previously unselected package automake. 295s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 295s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 295s Selecting previously unselected package autopoint. 295s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 295s Unpacking autopoint (0.21-14ubuntu2) ... 295s Selecting previously unselected package gcc-13-base:s390x. 295s Preparing to unpack .../09-gcc-13-base_13.2.0-23ubuntu4_s390x.deb ... 295s Unpacking gcc-13-base:s390x (13.2.0-23ubuntu4) ... 295s Selecting previously unselected package libisl23:s390x. 295s Preparing to unpack .../10-libisl23_0.26-3build1_s390x.deb ... 295s Unpacking libisl23:s390x (0.26-3build1) ... 295s Selecting previously unselected package libmpc3:s390x. 295s Preparing to unpack .../11-libmpc3_1.3.1-1build1_s390x.deb ... 295s Unpacking libmpc3:s390x (1.3.1-1build1) ... 295s Selecting previously unselected package cpp-13-s390x-linux-gnu. 295s Preparing to unpack .../12-cpp-13-s390x-linux-gnu_13.2.0-23ubuntu4_s390x.deb ... 295s Unpacking cpp-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 295s Selecting previously unselected package cpp-13. 295s Preparing to unpack .../13-cpp-13_13.2.0-23ubuntu4_s390x.deb ... 295s Unpacking cpp-13 (13.2.0-23ubuntu4) ... 295s Selecting previously unselected package cpp-s390x-linux-gnu. 295s Preparing to unpack .../14-cpp-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 295s Unpacking cpp-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 295s Selecting previously unselected package cpp. 295s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_s390x.deb ... 296s Unpacking cpp (4:13.2.0-7ubuntu1) ... 296s Selecting previously unselected package libcc1-0:s390x. 296s Preparing to unpack .../16-libcc1-0_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libcc1-0:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libgomp1:s390x. 296s Preparing to unpack .../17-libgomp1_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libgomp1:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libitm1:s390x. 296s Preparing to unpack .../18-libitm1_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libitm1:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libatomic1:s390x. 296s Preparing to unpack .../19-libatomic1_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libatomic1:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libasan8:s390x. 296s Preparing to unpack .../20-libasan8_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libasan8:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libubsan1:s390x. 296s Preparing to unpack .../21-libubsan1_14.1.0-1ubuntu1_s390x.deb ... 296s Unpacking libubsan1:s390x (14.1.0-1ubuntu1) ... 296s Selecting previously unselected package libgcc-13-dev:s390x. 296s Preparing to unpack .../22-libgcc-13-dev_13.2.0-23ubuntu4_s390x.deb ... 296s Unpacking libgcc-13-dev:s390x (13.2.0-23ubuntu4) ... 296s Selecting previously unselected package gcc-13-s390x-linux-gnu. 296s Preparing to unpack .../23-gcc-13-s390x-linux-gnu_13.2.0-23ubuntu4_s390x.deb ... 296s Unpacking gcc-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 296s Selecting previously unselected package gcc-13. 296s Preparing to unpack .../24-gcc-13_13.2.0-23ubuntu4_s390x.deb ... 296s Unpacking gcc-13 (13.2.0-23ubuntu4) ... 296s Selecting previously unselected package gcc-s390x-linux-gnu. 296s Preparing to unpack .../25-gcc-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 296s Unpacking gcc-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 296s Selecting previously unselected package gcc. 296s Preparing to unpack .../26-gcc_4%3a13.2.0-7ubuntu1_s390x.deb ... 296s Unpacking gcc (4:13.2.0-7ubuntu1) ... 296s Selecting previously unselected package libstdc++-13-dev:s390x. 296s Preparing to unpack .../27-libstdc++-13-dev_13.2.0-23ubuntu4_s390x.deb ... 296s Unpacking libstdc++-13-dev:s390x (13.2.0-23ubuntu4) ... 297s Selecting previously unselected package g++-13-s390x-linux-gnu. 297s Preparing to unpack .../28-g++-13-s390x-linux-gnu_13.2.0-23ubuntu4_s390x.deb ... 297s Unpacking g++-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 297s Selecting previously unselected package g++-13. 297s Preparing to unpack .../29-g++-13_13.2.0-23ubuntu4_s390x.deb ... 297s Unpacking g++-13 (13.2.0-23ubuntu4) ... 297s Selecting previously unselected package g++-s390x-linux-gnu. 297s Preparing to unpack .../30-g++-s390x-linux-gnu_4%3a13.2.0-7ubuntu1_s390x.deb ... 297s Unpacking g++-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 297s Selecting previously unselected package g++. 297s Preparing to unpack .../31-g++_4%3a13.2.0-7ubuntu1_s390x.deb ... 297s Unpacking g++ (4:13.2.0-7ubuntu1) ... 297s Selecting previously unselected package build-essential. 297s Preparing to unpack .../32-build-essential_12.10ubuntu1_s390x.deb ... 297s Unpacking build-essential (12.10ubuntu1) ... 297s Selecting previously unselected package libgc1:s390x. 297s Preparing to unpack .../33-libgc1_1%3a8.2.6-1build1_s390x.deb ... 297s Unpacking libgc1:s390x (1:8.2.6-1build1) ... 297s Selecting previously unselected package libobjc4:s390x. 297s Preparing to unpack .../34-libobjc4_14.1.0-1ubuntu1_s390x.deb ... 297s Unpacking libobjc4:s390x (14.1.0-1ubuntu1) ... 297s Selecting previously unselected package libobjc-13-dev:s390x. 297s Preparing to unpack .../35-libobjc-13-dev_13.2.0-23ubuntu4_s390x.deb ... 297s Unpacking libobjc-13-dev:s390x (13.2.0-23ubuntu4) ... 297s Selecting previously unselected package libclang-common-18-dev:s390x. 297s Preparing to unpack .../36-libclang-common-18-dev_1%3a18.1.7-1_s390x.deb ... 297s Unpacking libclang-common-18-dev:s390x (1:18.1.7-1) ... 297s Selecting previously unselected package llvm-18-linker-tools. 297s Preparing to unpack .../37-llvm-18-linker-tools_1%3a18.1.7-1_s390x.deb ... 297s Unpacking llvm-18-linker-tools (1:18.1.7-1) ... 297s Selecting previously unselected package clang-18. 297s Preparing to unpack .../38-clang-18_1%3a18.1.7-1_s390x.deb ... 297s Unpacking clang-18 (1:18.1.7-1) ... 297s Selecting previously unselected package libdebhelper-perl. 297s Preparing to unpack .../39-libdebhelper-perl_13.15.3ubuntu2_all.deb ... 297s Unpacking libdebhelper-perl (13.15.3ubuntu2) ... 297s Selecting previously unselected package libtool. 297s Preparing to unpack .../40-libtool_2.4.7-7build1_all.deb ... 297s Unpacking libtool (2.4.7-7build1) ... 297s Selecting previously unselected package dh-autoreconf. 297s Preparing to unpack .../41-dh-autoreconf_20_all.deb ... 297s Unpacking dh-autoreconf (20) ... 297s Selecting previously unselected package libarchive-zip-perl. 297s Preparing to unpack .../42-libarchive-zip-perl_1.68-1_all.deb ... 297s Unpacking libarchive-zip-perl (1.68-1) ... 297s Selecting previously unselected package libfile-stripnondeterminism-perl. 297s Preparing to unpack .../43-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 297s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 297s Selecting previously unselected package dh-strip-nondeterminism. 297s Preparing to unpack .../44-dh-strip-nondeterminism_1.14.0-1_all.deb ... 297s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 297s Selecting previously unselected package debugedit. 297s Preparing to unpack .../45-debugedit_1%3a5.0-5build2_s390x.deb ... 297s Unpacking debugedit (1:5.0-5build2) ... 297s Selecting previously unselected package dwz. 297s Preparing to unpack .../46-dwz_0.15-1build6_s390x.deb ... 297s Unpacking dwz (0.15-1build6) ... 297s Selecting previously unselected package gettext. 297s Preparing to unpack .../47-gettext_0.21-14ubuntu2_s390x.deb ... 297s Unpacking gettext (0.21-14ubuntu2) ... 297s Selecting previously unselected package intltool-debian. 297s Preparing to unpack .../48-intltool-debian_0.35.0+20060710.6_all.deb ... 297s Unpacking intltool-debian (0.35.0+20060710.6) ... 297s Selecting previously unselected package po-debconf. 297s Preparing to unpack .../49-po-debconf_1.0.21+nmu1_all.deb ... 297s Unpacking po-debconf (1.0.21+nmu1) ... 297s Selecting previously unselected package debhelper. 297s Preparing to unpack .../50-debhelper_13.15.3ubuntu2_all.deb ... 297s Unpacking debhelper (13.15.3ubuntu2) ... 298s Selecting previously unselected package emacsen-common. 298s Preparing to unpack .../51-emacsen-common_3.0.5_all.deb ... 298s Unpacking emacsen-common (3.0.5) ... 298s Selecting previously unselected package dictionaries-common. 298s Preparing to unpack .../52-dictionaries-common_1.29.7_all.deb ... 298s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 298s Unpacking dictionaries-common (1.29.7) ... 298s Selecting previously unselected package libfakeroot:s390x. 298s Preparing to unpack .../53-libfakeroot_1.35.1-1_s390x.deb ... 298s Unpacking libfakeroot:s390x (1.35.1-1) ... 298s Selecting previously unselected package fakeroot. 298s Preparing to unpack .../54-fakeroot_1.35.1-1_s390x.deb ... 298s Unpacking fakeroot (1.35.1-1) ... 298s Selecting previously unselected package hunspell-en-us. 298s Preparing to unpack .../55-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 298s Unpacking hunspell-en-us (1:2020.12.07-2) ... 298s Selecting previously unselected package icu-devtools. 298s Preparing to unpack .../56-icu-devtools_74.2-1ubuntu3_s390x.deb ... 298s Unpacking icu-devtools (74.2-1ubuntu3) ... 298s Selecting previously unselected package libpgtypes3:s390x. 298s Preparing to unpack .../57-libpgtypes3_16.3-1_s390x.deb ... 298s Unpacking libpgtypes3:s390x (16.3-1) ... 298s Selecting previously unselected package libpq5:s390x. 298s Preparing to unpack .../58-libpq5_16.3-1_s390x.deb ... 298s Unpacking libpq5:s390x (16.3-1) ... 298s Selecting previously unselected package libecpg6:s390x. 298s Preparing to unpack .../59-libecpg6_16.3-1_s390x.deb ... 298s Unpacking libecpg6:s390x (16.3-1) ... 298s Selecting previously unselected package libecpg-compat3:s390x. 298s Preparing to unpack .../60-libecpg-compat3_16.3-1_s390x.deb ... 298s Unpacking libecpg-compat3:s390x (16.3-1) ... 298s Selecting previously unselected package libssl-dev:s390x. 298s Preparing to unpack .../61-libssl-dev_3.0.13-0ubuntu4_s390x.deb ... 298s Unpacking libssl-dev:s390x (3.0.13-0ubuntu4) ... 298s Selecting previously unselected package libpq-dev. 298s Preparing to unpack .../62-libpq-dev_16.3-1_s390x.deb ... 298s Unpacking libpq-dev (16.3-1) ... 298s Selecting previously unselected package libecpg-dev. 298s Preparing to unpack .../63-libecpg-dev_16.3-1_s390x.deb ... 298s Unpacking libecpg-dev (16.3-1) ... 298s Selecting previously unselected package libicu-dev:s390x. 298s Preparing to unpack .../64-libicu-dev_74.2-1ubuntu3_s390x.deb ... 298s Unpacking libicu-dev:s390x (74.2-1ubuntu3) ... 298s Selecting previously unselected package libncurses-dev:s390x. 298s Preparing to unpack .../65-libncurses-dev_6.5-2_s390x.deb ... 298s Unpacking libncurses-dev:s390x (6.5-2) ... 298s Selecting previously unselected package libpython3.12t64:s390x. 298s Preparing to unpack .../66-libpython3.12t64_3.12.4-1_s390x.deb ... 298s Unpacking libpython3.12t64:s390x (3.12.4-1) ... 298s Selecting previously unselected package libtcl8.6:s390x. 298s Preparing to unpack .../67-libtcl8.6_8.6.14+dfsg-1build1_s390x.deb ... 298s Unpacking libtcl8.6:s390x (8.6.14+dfsg-1build1) ... 298s Selecting previously unselected package libxml2-dev:s390x. 298s Preparing to unpack .../68-libxml2-dev_2.9.14+dfsg-1.3ubuntu3_s390x.deb ... 298s Unpacking libxml2-dev:s390x (2.9.14+dfsg-1.3ubuntu3) ... 299s Selecting previously unselected package libxslt1.1:s390x. 299s Preparing to unpack .../69-libxslt1.1_1.1.39-0exp1build1_s390x.deb ... 299s Unpacking libxslt1.1:s390x (1.1.39-0exp1build1) ... 299s Selecting previously unselected package llvm-18-runtime. 299s Preparing to unpack .../70-llvm-18-runtime_1%3a18.1.7-1_s390x.deb ... 299s Unpacking llvm-18-runtime (1:18.1.7-1) ... 299s Selecting previously unselected package libpfm4:s390x. 299s Preparing to unpack .../71-libpfm4_4.13.0+git32-g0d4ed0e-1_s390x.deb ... 299s Unpacking libpfm4:s390x (4.13.0+git32-g0d4ed0e-1) ... 299s Selecting previously unselected package llvm-18. 299s Preparing to unpack .../72-llvm-18_1%3a18.1.7-1_s390x.deb ... 299s Unpacking llvm-18 (1:18.1.7-1) ... 300s Selecting previously unselected package libffi-dev:s390x. 300s Preparing to unpack .../73-libffi-dev_3.4.6-1build1_s390x.deb ... 300s Unpacking libffi-dev:s390x (3.4.6-1build1) ... 300s Selecting previously unselected package llvm-18-tools. 300s Preparing to unpack .../74-llvm-18-tools_1%3a18.1.7-1_s390x.deb ... 300s Unpacking llvm-18-tools (1:18.1.7-1) ... 300s Selecting previously unselected package libz3-4:s390x. 300s Preparing to unpack .../75-libz3-4_4.8.12-3.1build1_s390x.deb ... 300s Unpacking libz3-4:s390x (4.8.12-3.1build1) ... 300s Selecting previously unselected package libz3-dev:s390x. 300s Preparing to unpack .../76-libz3-dev_4.8.12-3.1build1_s390x.deb ... 300s Unpacking libz3-dev:s390x (4.8.12-3.1build1) ... 300s Selecting previously unselected package llvm-18-dev. 300s Preparing to unpack .../77-llvm-18-dev_1%3a18.1.7-1_s390x.deb ... 300s Unpacking llvm-18-dev (1:18.1.7-1) ... 303s Selecting previously unselected package locales-all. 303s Preparing to unpack .../78-locales-all_2.39-0ubuntu9_s390x.deb ... 303s Unpacking locales-all (2.39-0ubuntu9) ... 306s Selecting previously unselected package postgresql-client-16. 306s Preparing to unpack .../79-postgresql-client-16_16.3-1_s390x.deb ... 306s Unpacking postgresql-client-16 (16.3-1) ... 306s Selecting previously unselected package postgresql-16. 306s Preparing to unpack .../80-postgresql-16_16.3-1_s390x.deb ... 306s Unpacking postgresql-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-server-dev-16. 307s Preparing to unpack .../81-postgresql-server-dev-16_16.3-1_s390x.deb ... 307s Unpacking postgresql-server-dev-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-server-dev-all:s390x. 307s Preparing to unpack .../82-postgresql-server-dev-all_260_s390x.deb ... 307s Unpacking postgresql-server-dev-all:s390x (260) ... 307s Selecting previously unselected package postgresql-plperl-16. 307s Preparing to unpack .../83-postgresql-plperl-16_16.3-1_s390x.deb ... 307s Unpacking postgresql-plperl-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-plpython3-16. 307s Preparing to unpack .../84-postgresql-plpython3-16_16.3-1_s390x.deb ... 307s Unpacking postgresql-plpython3-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-pltcl-16. 307s Preparing to unpack .../85-postgresql-pltcl-16_16.3-1_s390x.deb ... 307s Unpacking postgresql-pltcl-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-all. 307s Preparing to unpack .../86-postgresql-all_260_all.deb ... 307s Unpacking postgresql-all (260) ... 307s Selecting previously unselected package postgresql-doc-16. 307s Preparing to unpack .../87-postgresql-doc-16_16.3-1_all.deb ... 307s Unpacking postgresql-doc-16 (16.3-1) ... 307s Selecting previously unselected package postgresql-doc. 307s Preparing to unpack .../88-postgresql-doc_16+260_all.deb ... 307s Unpacking postgresql-doc (16+260) ... 307s Selecting previously unselected package autopkgtest-satdep. 307s Preparing to unpack .../89-2-autopkgtest-satdep.deb ... 307s Unpacking autopkgtest-satdep (0) ... 307s Setting up postgresql-client-common (260) ... 307s Setting up libpgtypes3:s390x (16.3-1) ... 307s Setting up libncurses-dev:s390x (6.5-2) ... 307s Setting up postgresql-doc-16 (16.3-1) ... 308s 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 308s Setting up libarchive-zip-perl (1.68-1) ... 308s Setting up libdebhelper-perl (13.15.3ubuntu2) ... 308s Setting up libpq5:s390x (16.3-1) ... 308s Setting up m4 (1.4.19-4build1) ... 308s Setting up llvm-18-tools (1:18.1.7-1) ... 308s Setting up libgomp1:s390x (14.1.0-1ubuntu1) ... 308s Setting up libffi-dev:s390x (3.4.6-1build1) ... 308s Setting up locales-all (2.39-0ubuntu9) ... 308s Setting up libfakeroot:s390x (1.35.1-1) ... 308s Setting up fakeroot (1.35.1-1) ... 308s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 308s Setting up libpython3.12t64:s390x (3.12.4-1) ... 308s Setting up autotools-dev (20220109.1) ... 308s Setting up libz3-4:s390x (4.8.12-3.1build1) ... 308s Setting up libpfm4:s390x (4.13.0+git32-g0d4ed0e-1) ... 308s Setting up gcc-13-base:s390x (13.2.0-23ubuntu4) ... 308s Setting up emacsen-common (3.0.5) ... 308s Setting up ssl-cert (1.1.2ubuntu1) ... 308s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 309s Setting up libssl-dev:s390x (3.0.13-0ubuntu4) ... 309s Setting up libmpc3:s390x (1.3.1-1build1) ... 309s Setting up libatomic1:s390x (14.1.0-1ubuntu1) ... 309s Setting up libtcl8.6:s390x (8.6.14+dfsg-1build1) ... 309s Setting up autopoint (0.21-14ubuntu2) ... 309s Setting up icu-devtools (74.2-1ubuntu3) ... 309s Setting up libclang-common-18-dev:s390x (1:18.1.7-1) ... 309s Setting up libgc1:s390x (1:8.2.6-1build1) ... 309s Setting up autoconf (2.71-3) ... 309s Setting up llvm-18-linker-tools (1:18.1.7-1) ... 309s Setting up libubsan1:s390x (14.1.0-1ubuntu1) ... 309s Setting up dwz (0.15-1build6) ... 309s Setting up libasan8:s390x (14.1.0-1ubuntu1) ... 309s Setting up libjson-perl (4.10000-1) ... 309s Setting up postgresql-doc (16+260) ... 309s Setting up libxslt1.1:s390x (1.1.39-0exp1build1) ... 309s Setting up debugedit (1:5.0-5build2) ... 309s Setting up libecpg6:s390x (16.3-1) ... 309s Setting up libisl23:s390x (0.26-3build1) ... 309s Setting up llvm-18-runtime (1:18.1.7-1) ... 309s Setting up libicu-dev:s390x (74.2-1ubuntu3) ... 309s Setting up libcc1-0:s390x (14.1.0-1ubuntu1) ... 309s Setting up libitm1:s390x (14.1.0-1ubuntu1) ... 309s Setting up automake (1:1.16.5-1.3ubuntu1) ... 309s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 309s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 309s Setting up libz3-dev:s390x (4.8.12-3.1build1) ... 309s Setting up gettext (0.21-14ubuntu2) ... 309s Setting up libecpg-compat3:s390x (16.3-1) ... 309s Setting up dictionaries-common (1.29.7) ... 309s Setting up postgresql-client-16 (16.3-1) ... 309s 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 309s Setting up libpq-dev (16.3-1) ... 309s Setting up libobjc4:s390x (14.1.0-1ubuntu1) ... 310s Setting up libecpg-dev (16.3-1) ... 310s Setting up intltool-debian (0.35.0+20060710.6) ... 310s Setting up libxml2-dev:s390x (2.9.14+dfsg-1.3ubuntu3) ... 310s Setting up cpp-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 310s Setting up postgresql-common (260) ... 310s 310s Creating config file /etc/postgresql-common/createcluster.conf with new version 310s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 310s en_us 310s Removing obsolete dictionary files: 311s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 311s Setting up dh-strip-nondeterminism (1.14.0-1) ... 311s Setting up libgcc-13-dev:s390x (13.2.0-23ubuntu4) ... 311s Setting up llvm-18 (1:18.1.7-1) ... 311s Setting up hunspell-en-us (1:2020.12.07-2) ... 311s Setting up libobjc-13-dev:s390x (13.2.0-23ubuntu4) ... 311s Setting up libstdc++-13-dev:s390x (13.2.0-23ubuntu4) ... 311s Setting up llvm-18-dev (1:18.1.7-1) ... 311s Setting up postgresql-16 (16.3-1) ... 311s Creating new PostgreSQL cluster 16/main ... 311s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 311s The files belonging to this database system will be owned by user "postgres". 311s This user must also own the server process. 311s 311s The database cluster will be initialized with locale "C.UTF-8". 311s The default database encoding has accordingly been set to "UTF8". 311s The default text search configuration will be set to "english". 311s 311s Data page checksums are disabled. 311s 311s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 311s creating subdirectories ... ok 311s selecting dynamic shared memory implementation ... posix 311s selecting default max_connections ... 100 311s selecting default shared_buffers ... 128MB 311s selecting default time zone ... Etc/UTC 311s creating configuration files ... ok 312s running bootstrap script ... ok 312s performing post-bootstrap initialization ... ok 312s syncing data to disk ... ok 316s Setting up cpp-13 (13.2.0-23ubuntu4) ... 316s Setting up cpp-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 316s Setting up po-debconf (1.0.21+nmu1) ... 316s Setting up clang-18 (1:18.1.7-1) ... 316s Setting up gcc-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 316s Setting up gcc-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 316s Setting up g++-13-s390x-linux-gnu (13.2.0-23ubuntu4) ... 316s Setting up gcc-13 (13.2.0-23ubuntu4) ... 316s Setting up postgresql-server-dev-16 (16.3-1) ... 316s Setting up postgresql-plpython3-16 (16.3-1) ... 316s Setting up cpp (4:13.2.0-7ubuntu1) ... 316s Setting up postgresql-plperl-16 (16.3-1) ... 316s Setting up postgresql-server-dev-all:s390x (260) ... 316s Setting up g++-13 (13.2.0-23ubuntu4) ... 316s Setting up postgresql-pltcl-16 (16.3-1) ... 316s Setting up libtool (2.4.7-7build1) ... 316s Setting up g++-s390x-linux-gnu (4:13.2.0-7ubuntu1) ... 316s Setting up postgresql-all (260) ... 316s Setting up gcc (4:13.2.0-7ubuntu1) ... 316s Setting up dh-autoreconf (20) ... 316s Setting up g++ (4:13.2.0-7ubuntu1) ... 316s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 316s Setting up build-essential (12.10ubuntu1) ... 316s Setting up debhelper (13.15.3ubuntu2) ... 316s Setting up autopkgtest-satdep (0) ... 316s Processing triggers for systemd (255.4-1ubuntu8) ... 316s Processing triggers for man-db (2.12.1-2) ... 317s Processing triggers for install-info (7.1-3build2) ... 317s Processing triggers for libc-bin (2.39-0ubuntu9) ... 317s Processing triggers for dictionaries-common (1.29.7) ... 322s (Reading database ... 72805 files and directories currently installed.) 322s Removing autopkgtest-satdep (0) ... 325s autopkgtest [08:32:52]: test run-testsuite: [----------------------- 326s ====== Running all tests with umask 077 ======= 326s ### PostgreSQL test 001_packages.t ### 326s 1..22 326s ok 1 - /etc/os-release exists 326s ok 2 - OS is ubuntu 326s ok 3 - OS version is 24.10 326s # PostgreSQL versions installed: 16 326s ok 4 - postgresql-16 installed 326s ok 5 # skip No python2 support 326s ok 6 - postgresql-plpython3-16 installed 326s ok 7 - postgresql-plperl-16 installed 326s ok 8 - postgresql-pltcl-16 installed 326s ok 9 - postgresql-server-dev-16 installed 326s ok 10 # skip No postgresql-contrib-16 package for version 16 326s # postgresql-doc-16 installed 326s ok 11 - At least one doc package installed 326s ok 12 - libecpg-dev installed 326s ok 13 - procps installed 326s ok 14 - netcat-openbsd installed 326s ok 15 - hunspell-en-us installed 326s ok 16 - system has a default UTF-8 locale 326s ok 17 - locale ru_RU exists 326s ok 18 - locale ru_RU.UTF-8 exists 326s ok 19 - user postgres in the UNIX group ssl-cert 326s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 326s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 326s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 326s ### End test 001_packages.t ### 326s 326s ### PostgreSQL test 002_existing_clusters.t ### 326s 1..8 326s # Cleanup 327s ok 1 - Cleanup: No clusters left behind 327s ok 2 - No postgres processes left behind 327s ok 3 - No files in /etc/postgresql left behind 327s ok 4 - No files in /var/lib/postgresql left behind 327s ok 5 - No files in /var/run/postgresql left behind 327s ok 6 - No files in /var/log/postgresql left behind 327s ok 7 - PostgreSQL TCP ports are closed 327s ok 8 - Next free port is 5432 327s ### End test 002_existing_clusters.t ### 327s 327s ### PostgreSQL test 003_alternatives.t ### 327s 1..9 327s # Newest PG version installed is 16 327s ok 1 - psql.1.gz link group 327s ok 2 - postmaster.1.gz link group does not exist 327s ok 3 - psql.1.gz alternative 327s ok 4 - pg_dump.1.gz alternative 327s ok 5 - postgres.1.gz alternative 327s ok 6 - pg_ctl.1.gz alternative 327s # Newest PG doc version installed is 16 327s ok 7 - SPI_connect.3.gz link group 327s ok 8 - SPI_connect.3.gz alternative 327s ok 9 - SPI_exec.3.gz alternative 327s ### End test 003_alternatives.t ### 327s 327s ### PostgreSQL test 005_PgCommon.t ### 327s 1..24 327s ok 1 - correctly parsed line 'local all postgres ident sameuser' 327s ok 2 - correctly parsed line 'local foo nobody trust' 327s ok 3 - correctly parsed line 'local foo nobody crypt' 327s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 327s ok 5 - correctly parsed line 'local foo,bar nobody ident' 327s ok 6 - correctly parsed line 'local all +foogrp password' 327s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 327s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 327s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 327s ok 10 - @expected_records has correct number of entries 327s ok 11 - returned read_pg_hba array has correct number of records 327s ok 12 - line 'foo all all md5' parsed as invalid 327s ok 13 - line 'local all all foo' parsed as invalid 327s ok 14 - line 'host all all foo' parsed as invalid 327s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 327s ok 16 - line 'host all all md5' parsed as invalid 327s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 327s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 327s ok 19 - read_conf_file returns empty dict for nonexisting file 327s ok 20 - read_conf_file() parsing 327s ok 21 - read_conf_file() parsing with include directives 327s ok 22 - set_conf_value 327s ok 23 - disable_conf_value 327s ok 24 - replace_conf_value 327s ### End test 005_PgCommon.t ### 327s 327s ### PostgreSQL test 006_next_free_port.t ### 327s 1..5 327s ok 1 - next_free_port is 5432 328s ok 2 - next_free_port detects localhost ipv4 socket 329s ok 3 - next_free_port detects wildcard ipv4 socket 330s ok 4 - next_free_port detects localhost ipv6 socket 331s ok 5 - next_free_port detects wildcard ipv6 socket 331s ### End test 006_next_free_port.t ### 331s 331s ### PostgreSQL test 007_pg_conftool.t ### 331s 1..41 331s # test without cluster 331s ok 1 - pg_conftool show all 331s ok 2 - correct output of pg_conftool show all 331s ok 3 - pg_conftool foo.conf show all 331s ok 4 - correct output of pg_conftool foo.conf show all 331s ok 5 - pg_conftool /tmp/_GE3cdaryv/different.conf show all 331s ok 6 - correct output of pg_conftool /tmp/_GE3cdaryv/different.conf show all 331s ok 7 - pg_conftool 9.7 main show all 331s ok 8 - correct output of pg_conftool 9.7 main show all 331s # test show 331s ok 9 - pg_conftool show all 331s ok 10 - correct output of pg_conftool show all 331s ok 11 - pg_conftool other.conf show all 331s ok 12 - correct output of pg_conftool other.conf show all 331s ok 13 - pg_conftool /tmp/_GE3cdaryv/different.conf show all 331s ok 14 - correct output of pg_conftool /tmp/_GE3cdaryv/different.conf show all 331s ok 15 - pg_conftool 16 main show all 331s ok 16 - correct output of pg_conftool 16 main show all 331s ok 17 - pg_conftool 16 main other.conf show all 331s ok 18 - correct output of pg_conftool 16 main other.conf show all 331s ok 19 - pg_conftool show a 331s ok 20 - correct output of pg_conftool show a 331s ok 21 - pg_conftool -s show a 331s ok 22 - correct output of pg_conftool -s show a 331s # test set 331s ok 23 - pg_conftool set c 7 331s ok 24 - correct output of pg_conftool set c 7 331s ok 25 - file contains new setting 331s ok 26 - pg_conftool set a 8 331s ok 27 - correct output of pg_conftool set a 8 331s ok 28 - file contains updated setting 331s ok 29 - pg_conftool /tmp/_GE3cdaryv/different.conf set a 9 331s ok 30 - correct output of pg_conftool /tmp/_GE3cdaryv/different.conf set a 9 331s ok 31 - file with path contains updated setting 331s # test remove 331s ok 32 - pg_conftool remove a 331s ok 33 - correct output of pg_conftool remove a 331s ok 34 - setting removed from file 331s ok 35 - pg_conftool /tmp/_GE3cdaryv/different.conf remove a 331s ok 36 - correct output of pg_conftool /tmp/_GE3cdaryv/different.conf remove a 331s ok 37 - setting removed from file with path 331s # test edit 331s ok 38 - pg_conftool edit 331s ok 39 - correct output of pg_conftool edit 331s ok 40 - pg_conftool /tmp/_GE3cdaryv/different.conf edit 331s ok 41 - correct output of pg_conftool /tmp/_GE3cdaryv/different.conf edit 331s ### End test 007_pg_conftool.t ### 331s 331s ### PostgreSQL test 010_defaultport_cluster.t ### 332s 1..14 332s ok 1 - psql --version 332s ok 2 - pg_wrapper selects highest available version number 332s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 332s ok 4 - connecting to localhost fails with no clusters 332s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 332s ok 6 - pg_wrapper uses host and port from PGCLUSTER 332s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 332s ok 8 - pg_wrapper uses --cluster from the command line 332s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 332s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 332s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 332s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 332s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 332s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 332s ### End test 010_defaultport_cluster.t ### 332s 332s ### PostgreSQL test 015_start_stop.t ### 332s 1..71 332s # We are running systemd 332s # Running tests for 16 332s # Cluster does not exist yet 332s ok 1 - cluster 16 main does not exist 332s ok 2 - service postgresql@16-main does not exist 332s ok 3 - systemctl start postgresql 332s ok 4 - cluster 16 main does not exist 332s ok 5 - service postgresql@16-main does not exist 332s ok 6 - systemctl start postgresql@16-main 332s ok 7 - cluster 16 main does not exist 332s ok 8 - service postgresql@16-main does not exist 332s # Start/stop postgresql using system tools 333s ok 9 - pg_createcluster 16 main 333s ok 10 - cluster 16 main is stopped 333s ok 11 - service postgresql@16-main is stopped 335s ok 12 - systemctl start postgresql 335s ok 13 - cluster 16 main is running 335s ok 14 - service postgresql@16-main is running 335s ok 15 - systemctl start postgresql 336s ok 16 - cluster 16 main is already running 336s ok 17 - service postgresql@16-main is already running 336s ok 18 - systemctl stop postgresql 342s ok 19 - cluster 16 main is stopped 342s ok 20 - service postgresql@16-main is stopped 342s ok 21 - systemctl stop postgresql 342s ok 22 - cluster 16 main is already stopped 342s ok 23 - service postgresql@16-main is already stopped 342s # Start/stop specific cluster using system tools 344s ok 24 - systemctl start postgresql@16-main 344s ok 25 - cluster 16 main is running 344s ok 26 - service postgresql@16-main is running 344s ok 27 - systemctl start postgresql@16-main 344s ok 28 - cluster 16 main is running 344s ok 29 - service postgresql@16-main is running 346s ok 30 - systemctl restart postgresql@16-main 346s ok 31 - cluster 16 main is running 347s ok 32 - service postgresql@16-main is running 347s ok 33 - systemctl stop postgresql@16-main 347s ok 34 - cluster 16 main is stopped 347s ok 35 - service postgresql@16-main is stopped 347s ok 36 - systemctl stop postgresql@16-main 347s ok 37 - cluster 16 main is already stopped 347s ok 38 - service postgresql@16-main is already stopped 348s ok 39 - pg_dropcluster 16 main 348s ok 40 - cluster 16 main does not exist 348s ok 41 - service postgresql@16-main does not exist 348s # Start/stop specific cluster using pg_*cluster 349s ok 42 - pg_ctlcluster start 16 main 349s ok 43 - cluster 16 main does not exist 349s ok 44 - service postgresql@16-main does not exist 352s ok 45 - pg_createcluster 16 main --start 352s ok 46 - cluster 16 main is running 352s ok 47 - service postgresql@16-main is running 352s ok 48 - pg_ctlcluster 16 main start 352s ok 49 - cluster 16 main is already running 352s ok 50 - service postgresql@16-main is already running 355s ok 51 - pg_ctlcluster 16-main restart 355s ok 52 - cluster 16 main is running 355s ok 53 - service postgresql@16-main is running 355s ok 54 - pg_ctlcluster 16 main stop 355s ok 55 - cluster 16 main is stopped 355s ok 56 - service postgresql@16-main is stopped 355s ok 57 - pg_ctlcluster 16 main stop 355s ok 58 - cluster 16 main is already stopped 355s ok 59 - service postgresql@16-main is already stopped 357s ok 60 - pg_ctlcluster start 16-main 357s ok 61 - cluster 16 main is running 357s ok 62 - service postgresql@16-main is running 359s ok 63 - pg_dropcluster 16 main --stop 359s # Cleanup 359s ok 64 - Cleanup: No clusters left behind 359s ok 65 - No postgres processes left behind 359s ok 66 - No files in /etc/postgresql left behind 359s ok 67 - No files in /var/lib/postgresql left behind 359s ok 68 - No files in /var/run/postgresql left behind 359s ok 69 - No files in /var/log/postgresql left behind 359s ok 70 - PostgreSQL TCP ports are closed 359s ok 71 - Next free port is 5432 359s ### End test 015_start_stop.t ### 359s 359s ### PostgreSQL test 020_create_sql_remove.t ### 359s 1..147 359s # Running tests for 16 363s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.YZVZfL 363s ok 2 - pg_createcluster 16 main 363s ok 3 - Socket and pid file are in /var/run/postgresql/ 363s ok 4 - xlog/wal directory /tmp/16.xlog.YZVZfL was created 363s ok 5 - local method in pg_hba.conf is peer 363s ok 6 - host method in pg_hba.conf is scram-sha-256 363s ok 7 - Exactly one postgres master process running 365s ok 8 - pg_ctlcluster 16 main restart 365s ok 9 - cluster restarts with new environment file 365s ok 10 - Exactly one postgres master process running 365s ok 11 - correct value of PGEXTRAVAR1 in environment 365s ok 12 - correct value of PGEXTRAVAR2 in environment 365s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 365s ok 14 - createdb --version 365s ok 15 - pg_wrapper+createdb selects version number of cluster 365s ok 16 - psql --version 365s ok 17 - pg_wrapper+psql selects version 16 365s ok 18 - pg_lscluster reports online cluster on port 5432 365s ok 19 - log file is actually used 365s ok 20 - /etc/postgresql is owned by user "postgres" 365s ok 21 - version configuration directory file is owned by user "postgres" 365s ok 22 - configuration directory file is owned by user "postgres" 365s ok 23 - version data directory file is owned by user "postgres" 365s ok 24 - data directory file is owned by user "postgres" 365s ok 25 - log file has 0640 permissions 365s ok 26 - log file is owned by user "postgres" 365s ok 27 - log file is owned by group "adm" 365s ok 28 - no log symlink by default 365s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 365s ok 30 - pg_lsclusters -h 365s ok 31 - correct output of pg_lsclusters -h 365s ok 32 - stopping cluster 368s ok 33 - restarting cluster with nondefault log symlink 368s ok 34 - log target is used as log file 368s ok 35 - default log is not used 368s ok 36 - pg_lsclusters -h 368s ok 37 - correct output of pg_lsclusters -h 368s ok 38 - stopping cluster 371s ok 39 - restarting cluster with explicitly configured log file 371s ok 40 - default log is not used 371s ok 41 - log symlink target is used for startup message 371s ok 42 - exactly one log file 371s ok 43 - custom log is actually used 371s ok 44 - pg_lsclusters -h 371s ok 45 - correct output of pg_lsclusters -h 371s ok 46 - stopping cluster 371s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 371s ok 48 - /etc/postgres-hack was not created 374s ok 49 - restarting cluster 374s ok 50 - ps -o tty -U postgres h 374s ok 51 - postgres processes do not have an associated terminal 374s ok 52 - Server is linked with SSL support 374s ok 53 - SSL is enabled in postgresql.conf 374s ok 54 - psql -l fails for nobody 374s ok 55 - createuser nobody 374s ok 56 - createdb nobodydb 374s ok 57 - psql -ltA succeeds for nobody 374s ok 58 - psql -ltA output 374s ok 59 - SQL command: create table 374s ok 60 - SQL command: insert into table values 374s ok 61 - SQL command: insert into table values 374s ok 62 - primary key violation 374s ok 63 - psql -tAc "select * from phone order by name" nobodydb 374s ok 64 - SQL command output: select -tA 374s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 374s ok 66 - SQL command output: select -tx 374s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 374s ok 68 - SQL command output: select -tAx 374s ok 69 - CREATE EXTENSION plperlu fails for user nobody 374s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 374s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 374s ok 72 - creating PL/PerlU function as user nobody fails 374s ok 73 - creating unsafe PL/Perl function as user postgres fails 374s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 374s ok 75 - creating PL/PerlU function as user postgres succeeds 374s ok 76 - psql nobodydb -Atc "select read_file()" 374s ok 77 - calling PL/PerlU function 374s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 374s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 375s ok 80 - creating unsafe PL/Perl function as user nobody fails 375s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 375s ok 82 - creating PL/Perl function as user nobody succeeds 375s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 375s ok 84 - calling PL/Perl function 375s ok 85 # skip No python2 support 375s ok 86 # skip No python2 support 375s ok 87 # skip No python2 support 375s ok 88 # skip No python2 support 375s ok 89 # skip No python2 support 375s ok 90 # skip No python2 support 375s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 375s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 375s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 375s ok 94 - creating PL/Python3 function as user postgres succeeds 375s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 375s ok 96 - calling PL/Python function 375s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 375s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 375s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 375s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 375s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 375s ok 102 - creating PL/Tcl function as user nobody succeeds 375s 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;" 375s ok 104 - creating PL/TclU function as user postgres succeeds 375s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 375s ok 106 - calling PL/Tcl function 375s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 375s ok 108 - calling PL/TclU function 375s ok 109 - stopping cluster 375s ok 110 - pg_ctlcluster 16 main start 375s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 378s ok 112 - pg_ctlcluster 16 main start 378s ok 113 - cluster restarts with pgdata symlink 378s ok 114 - postgres master has OOM killer protection 378s ok 115 - postgres client backend has no OOM adjustment 378s ok 116 - ps h 6593 378s ok 117 - process title is idle 379s ok 118 - ps h 6593 379s ok 119 - process title is idle in transaction 379s ok 120 - stopping cluster 381s ok 121 - starting cluster as postgres works without a log file 381s ok 122 - log file got recreated and used 381s ok 123 - creating a directory in spc2 381s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.D2dDVI'" 381s ok 125 - creating tablespace spc1 381s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 381s ok 127 - creating a table in spc1 381s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.j4VT22'" 381s ok 129 - creating tablespace spc2 381s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 381s ok 131 - creating a table in spc2 381s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 381s ok 133 - Correct apt NeverAutoRemove config 383s ok 134 - pg_dropcluster removes cluster 383s ok 135 - xlog/wal directory /tmp/16.xlog.YZVZfL was deleted 383s ok 136 - tablespace spc1 was emptied 383s ok 137 - tablespace spc2 was emptied 383s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 383s ok 139 - Correct apt NeverAutoRemove config 383s # Cleanup 383s ok 140 - Cleanup: No clusters left behind 383s ok 141 - No postgres processes left behind 383s ok 142 - No files in /etc/postgresql left behind 383s ok 143 - No files in /var/lib/postgresql left behind 383s ok 144 - No files in /var/run/postgresql left behind 383s ok 145 - No files in /var/log/postgresql left behind 383s ok 146 - PostgreSQL TCP ports are closed 383s ok 147 - Next free port is 5432 383s ### End test 020_create_sql_remove.t ### 383s 383s ### PostgreSQL test 021_pg_renamecluster.t ### 383s 1..20 387s ok 1 - pg_createcluster 16 main 390s ok 2 - pg_renamecluster 16 main donau 390s ok 3 - psql -tAc "show data_directory" 390s ok 4 - cluster is running and data_directory was moved 390s ok 5 - pg_hba.conf location updated 390s ok 6 - pg_ident.conf location updated 390s ok 7 - external_pid_file location updated 390s ok 8 - external_pid_file exists 390s ok 9 # skip no stats_temp_directory in 16 390s ok 10 # skip no stats_temp_directory in 16 390s ok 11 - cluster_name is updated 392s ok 12 - pg_dropcluster removes cluster 392s # Cleanup 392s ok 13 - Cleanup: No clusters left behind 392s ok 14 - No postgres processes left behind 392s ok 15 - No files in /etc/postgresql left behind 392s ok 16 - No files in /var/lib/postgresql left behind 392s ok 17 - No files in /var/run/postgresql left behind 392s ok 18 - No files in /var/log/postgresql left behind 392s ok 19 - PostgreSQL TCP ports are closed 392s ok 20 - Next free port is 5432 392s ### End test 021_pg_renamecluster.t ### 392s 392s ### PostgreSQL test 022_recovery.t ### 392s 1..17 392s # Running tests for 16 396s ok 1 - pg_createcluster 16 main --start >/dev/null 396s ok 2 - pg_ctlcluster 16 main stop -m i 398s ok 3 - pg_ctlcluster 16 main start 398s ok 4 - psql -c '' 398s ok 5 - pg_ctlcluster 16 main stop -m i 398s ok 6 - create write-protected file in data directory 401s ok 7 - pg_ctlcluster 16 main start 401s ok 8 - psql -c '' 403s ok 9 - pg_dropcluster removes cluster 403s # Cleanup 403s ok 10 - Cleanup: No clusters left behind 403s ok 11 - No postgres processes left behind 403s ok 12 - No files in /etc/postgresql left behind 403s ok 13 - No files in /var/lib/postgresql left behind 403s ok 14 - No files in /var/run/postgresql left behind 403s ok 15 - No files in /var/log/postgresql left behind 403s ok 16 - PostgreSQL TCP ports are closed 403s ok 17 - Next free port is 5432 403s ### End test 022_recovery.t ### 403s 403s ### PostgreSQL test 025_logging.t ### 403s 1..55 403s # Logging to /var/log/syslog works 403s # Running tests for 16 407s ok 1 - pg_createcluster 16 main 407s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 407s ok 3 - psql -qc "'foobar_16_7787'" 407s ok 4 - log an error 407s ok 5 - grep --binary-files=text foobar_16_7787 /var/log/postgresql/postgresql-16-main.log 407s ok 6 - error appears in logfile 407s ok 7 - pg_conftool 16 main set log_destination syslog 407s ok 8 - set log_destination syslog 407s ok 9 - pg_ctlcluster 16 main reload 407s ok 10 - 16 main reload 407s ok 11 - psql -Atc "show log_destination" 407s ok 12 - log_destination is syslog 407s ok 13 - pg_lscluster reports syslog 408s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 408s ok 15 - error appears in /var/log/syslog 408s ok 16 - pg_conftool 16 main set logging_collector on 408s ok 17 - set logging_collector on 408s ok 18 - pg_conftool 16 main set log_destination csvlog 408s ok 19 - set log_destination csvlog 410s ok 20 - pg_ctlcluster 16 main restart 410s ok 21 - 16 main restart 411s ok 22 - psql -Atc "show logging_collector" 411s ok 23 - logging_collector is on 411s ok 24 - psql -Atc "show log_destination" 411s ok 25 - log_destination is csvlog 411s ok 26 - pg_lscluster reports csvlog 411s ok 27 - psql -qc "'barbaz_16_7787'" 411s ok 28 - log an error 411s ok 29 - grep --binary-files=text barbaz_16_7787 /var/lib/postgresql/16/main/log/*.csv 411s ok 30 - error appears in log/*.csv 411s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 411s ok 32 - set log_destination stderr,syslog,csvlog 411s ok 33 - pg_ctlcluster 16 main reload 411s ok 34 - 16 main reload 411s ok 35 - psql -Atc "show log_destination" 411s ok 36 - log_destination is stderr,syslog,csvlog 411s ok 37 - pg_lscluster reports stderr,syslog,csvlog 411s ok 38 - psql -qc "'moo_16_7787'" 411s ok 39 - log an error 412s ok 40 - grep --binary-files=text moo_16_7787 /var/lib/postgresql/16/main/log/*.log 412s ok 41 - error appears in log/*.log 412s ok 42 - grep --binary-files=text 'postgres.*moo_16_7787' /var/log/syslog 412s ok 43 - error appears in /var/log/syslog 412s ok 44 - grep --binary-files=text moo_16_7787 /var/lib/postgresql/16/main/log/*.csv 412s ok 45 - error appears in log/*.csv 414s ok 46 - pg_dropcluster 16 main --stop 414s ok 47 - pg_dropcluster removes cluster 414s # Cleanup 414s ok 48 - Cleanup: No clusters left behind 414s ok 49 - No postgres processes left behind 414s ok 50 - No files in /etc/postgresql left behind 414s ok 51 - No files in /var/lib/postgresql left behind 414s ok 52 - No files in /var/run/postgresql left behind 414s ok 53 - No files in /var/log/postgresql left behind 414s ok 54 - PostgreSQL TCP ports are closed 414s ok 55 - Next free port is 5432 414s ### End test 025_logging.t ### 414s 414s ### PostgreSQL test 027_jit.t ### 414s # 16 418s ok 1 - pg_createcluster 16 main --start 418s ok 2 - psql -Xatc 'show jit' 418s ok 3 - JIT is on by default 418s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 418s ok 5 - No JIT on cheap query 418s ok 6 - pg_conftool 16 main set seq_page_cost 100000 418s ok 7 - pg_conftool 16 main set random_page_cost 100000 418s ok 8 - pg_ctlcluster 16 main reload 418s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 418s ok 10 - Expensive query is JITed 420s ok 11 - pg_dropcluster --stop 16 main 420s # Cleanup 420s ok 12 - Cleanup: No clusters left behind 420s ok 13 - No postgres processes left behind 420s ok 14 - No files in /etc/postgresql left behind 420s ok 15 - No files in /var/lib/postgresql left behind 420s ok 16 - No files in /var/run/postgresql left behind 420s ok 17 - No files in /var/log/postgresql left behind 420s ok 18 - PostgreSQL TCP ports are closed 420s ok 19 - Next free port is 5432 420s 1..19 420s ### End test 027_jit.t ### 420s 420s ### PostgreSQL test 030_errors.t ### 420s 1..156 420s ok 1 - pg_lscluster reports cluster without binaries 421s ok 2 - pg_dropcluster 6.3 main 423s ok 3 - pg_createcluster --socketdir 423s ok 4 - pg_lsclusters -h 423s ok 5 - cluster was created 423s ok 6 - Port of created cluster is 5432 423s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 423s ok 8 - pg_createcluster on existing cluster 423s ok 9 - pg_lsclusters -h 423s ok 10 - original cluster still exists 423s ok 11 - pg_createcluster 16 test -p foo 423s ok 12 - pg_createcluster -p checks that port option is numeric 423s ok 13 - pg_createcluster 16 test -p 42 423s ok 14 - pg_createcluster -p checks valid port range 423s ok 15 - pg_ctlcluster 16 main start 423s ok 16 - pg_ctlcluster refuses to start root-owned cluster 423s ok 17 - pg_ctlcluster 16 main start 423s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 423s ok 19 - pg_ctlcluster 16 main start 423s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 423s ok 21 - pg_ctlcluster 16 main start 423s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 425s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 425s ok 24 - No sockets in /var/run/postgresql 425s ok 25 - Socket is in /tmp/postgresql-testsuite/ 426s ok 26 - cluster stops with custom unix_socket_dir 426s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 428s ok 28 - cluster starts after removing unix_socket_dir 428s ok 29 - Socket is in default dir /var/run/postgresql 428s ok 30 - No sockets in /tmp/postgresql-testsuite/ 428s ok 31 - pg_ctlcluster 16 main stop 428s ok 32 - pg_ctlcluster fails with corrupted PID file 428s ok 33 - pg_lsclusters -h 428s ok 34 - cluster is still online 428s ok 35 - pg_ctlcluster succeeds with restored PID file 428s ok 36 - pg_lsclusters -h 428s ok 37 - cluster is down 428s ok 38 - pg_ctlcluster 16 main stop 428s ok 39 - pg_ctlcluster stop fails on stopped cluster 430s ok 40 - pg_ctlcluster 16 main start 430s ok 41 - pg_ctlcluster succeeds with already existing PID file 431s ok 42 - pg_lsclusters -h 431s ok 43 - cluster is online 431s ok 44 - pg_ctlcluster stop succeeds 431s ok 45 - pg_lsclusters -h 431s ok 46 - cluster is down 431s ok 47 - no pid file left 431s ok 48 - pg_ctlcluster 16 main stop 431s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 431s ok 50 - pid file was cleaned up 431s ok 51 - pg_ctlcluster --force 16 main stop 431s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 431s ok 53 - pid file was cleaned up 431s ok 54 - pg_ctlcluster 16 main stop 431s ok 55 - pg_ctlcluster stop succeeds with stale PID file 431s ok 56 - pid file was cleaned up 431s ok 57 - pg_ctlcluster --force 16 main stop 431s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 431s ok 59 - pid file was cleaned up 431s ok 60 - pg_ctlcluster --force 16 main stop 431s ok 61 - pg_ctlcluster stop succeeds with empty PID file 431s ok 62 - pid file was cleaned up 433s ok 63 - pg_ctlcluster 16 main start 433s ok 64 - pg_ctlcluster succeeds with corrupted PID file 433s ok 65 - pg_lsclusters -h 433s ok 66 - cluster is online 433s ok 67 - pg_ctlcluster 16 main start 433s ok 68 - pg_ctlcluster start fails on running cluster 433s ok 69 - pg_ctlcluster stop 434s ok 70 - pg_ctlcluster 16 main start 434s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 434s ok 72 - pg_ctlcluster 16 main stop 434s ok 73 - stopping cluster 442s ok 74 - pg_ctlcluster 16 main start 442s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 442s ok 76 - pg_ctlcluster 16 main stop 442s ok 77 - stopping cluster 442s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 442s ok 79 - pg_dropcluster 16 main 442s ok 80 - pg_dropcluster works as user postgres 442s ok 81 - pg_createcluster succeeds 442s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 442s ok 83 - proper error message for nonexisting /var/lib/postgresql 443s ok 84 - pg_ctlcluster 16 main start 443s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 444s ok 86 - pg_ctlcluster 16 main stop 444s ok 87 - stopping cluster 445s ok 88 - pg_createcluster other 447s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 449s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 449s ok 91 449s ok 92 - pg_ctlcluster 16 other start 449s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 449s ok 94 - pg_ctlcluster 16 main stop 449s ok 95 - stopping main cluster 452s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 454s ok 97 - pg_dropcluster other 456s ok 98 - pg_dropcluster 456s ok 99 - No sockets any more 456s ok 100 - 'pg_lsclusters 4.5 foo' fails 456s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 456s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 456s ok 103 - 'psql --cluster 4.5/foo' fails 456s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 456s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 456s ok 106 - 'psql --cluster 16/foo' fails 456s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 456s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 456s ok 109 - 'pg_dropcluster 4.5 foo' fails 456s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 456s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 456s ok 112 - 'pg_dropcluster 16 foo' fails 456s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 456s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 456s ok 115 - 'pg_upgradecluster 4.5 foo' fails 456s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 456s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 456s ok 118 - 'pg_upgradecluster 16 foo' fails 456s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 456s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 456s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 456s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 456s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 456s ok 124 - 'pg_ctlcluster 16 foo stop' fails 456s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 456s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 456s # Cleanup 456s ok 127 - Cleanup: No clusters left behind 456s ok 128 - No postgres processes left behind 456s ok 129 - No files in /etc/postgresql left behind 456s ok 130 - No files in /var/lib/postgresql left behind 456s ok 131 - No files in /var/run/postgresql left behind 456s ok 132 - No files in /var/log/postgresql left behind 456s ok 133 - PostgreSQL TCP ports are closed 456s ok 134 - Next free port is 5432 458s ok 135 - pg_dropcluster 16 broken 458s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 458s # Cleanup 458s ok 137 - Cleanup: No clusters left behind 458s ok 138 - No postgres processes left behind 458s ok 139 - No files in /etc/postgresql left behind 458s ok 140 - No files in /var/lib/postgresql left behind 458s ok 141 - No files in /var/run/postgresql left behind 458s ok 142 - No files in /var/log/postgresql left behind 458s ok 143 - PostgreSQL TCP ports are closed 458s ok 144 - Next free port is 5432 459s ok 145 - pg_dropcluster 16 broken 459s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 459s ok 147 - /etc/postgresql/16 was removed 459s ok 148 - /var/lib/postgresql/16 was removed 459s # Cleanup 459s ok 149 - Cleanup: No clusters left behind 459s ok 150 - No postgres processes left behind 459s ok 151 - No files in /etc/postgresql left behind 459s ok 152 - No files in /var/lib/postgresql left behind 459s ok 153 - No files in /var/run/postgresql left behind 459s ok 154 - No files in /var/log/postgresql left behind 459s ok 155 - PostgreSQL TCP ports are closed 459s ok 156 - Next free port is 5432 459s ### End test 030_errors.t ### 459s 459s ### PostgreSQL test 031_errors_disk_full.t ### 459s 1..22 459s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 461s ok 1 - script failed 461s ok 2 - pg_createcluster fails due to insufficient disk space 461s ok 3 - does not leave files behind 461s # Cleanup 461s ok 4 - Cleanup: No clusters left behind 461s ok 5 - No postgres processes left behind 461s ok 6 - No files in /etc/postgresql left behind 461s ok 7 - No files in /var/lib/postgresql left behind 461s ok 8 - No files in /var/run/postgresql left behind 461s ok 9 - No files in /var/log/postgresql left behind 461s ok 10 - PostgreSQL TCP ports are closed 461s ok 11 - Next free port is 5432 461s # check disk full conditions on startup 464s ok 12 - script failed 464s ok 13 - pg_ctlcluster prints error message 464s ok 14 - log file has error message 464s # Cleanup 464s ok 15 - Cleanup: No clusters left behind 464s ok 16 - No postgres processes left behind 464s ok 17 - No files in /etc/postgresql left behind 464s ok 18 - No files in /var/lib/postgresql left behind 464s ok 19 - No files in /var/run/postgresql left behind 464s ok 20 - No files in /var/log/postgresql left behind 464s ok 21 - PostgreSQL TCP ports are closed 464s ok 22 - Next free port is 5432 464s ### End test 031_errors_disk_full.t ### 464s 464s ### PostgreSQL test 032_ssl_key_permissions.t ### 464s 1..22 464s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 464s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 464s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 464s # 16 (16.3-1) 465s ok 4 - pg_createcluster 16 main 466s ok 5 - pg_ctlcluster 16 main start 466s ok 6 - ssl key owned by nobody refused 466s ok 7 - pg_ctlcluster 16 main start 466s ok 8 - ssl key with permissions root:root 0644 refused 466s ok 9 - pg_ctlcluster 16 main start 466s ok 10 - ssl key with permissions postgres:postgres 0640 refused 467s ok 11 - pg_dropcluster 16 main --stop 467s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 467s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 467s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 467s # Cleanup 467s ok 15 - Cleanup: No clusters left behind 467s ok 16 - No postgres processes left behind 467s ok 17 - No files in /etc/postgresql left behind 467s ok 18 - No files in /var/lib/postgresql left behind 467s ok 19 - No files in /var/run/postgresql left behind 468s ok 20 - No files in /var/log/postgresql left behind 468s ok 21 - PostgreSQL TCP ports are closed 468s ok 22 - Next free port is 5432 468s ### End test 032_ssl_key_permissions.t ### 468s 468s ### PostgreSQL test 040_upgrade.t ### 468s 1..1 468s ok 1 - only one major version installed, skipping upgrade tests 468s ### End test 040_upgrade.t ### 468s 468s ### PostgreSQL test 041_upgrade_custompaths.t ### 468s 1..1 468s ok 1 - only one major version installed, skipping upgrade tests 468s ### End test 041_upgrade_custompaths.t ### 468s 468s ### PostgreSQL test 042_upgrade_rename.t ### 468s 1..15 468s # PostgreSQL 16 471s ok 1 - pg_createcluster 16 main --start 478s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 478s ok 3 - pg_lsclusters -h 478s ok 4 - correct output of pg_lsclusters -h 479s ok 5 - pg_dropcluster 16 main --stop 481s ok 6 - pg_dropcluster 16 upgr --stop 481s ok 7 - Cleaning pg_upgrade log files 481s # Cleanup 481s ok 8 - Cleanup: No clusters left behind 481s ok 9 - No postgres processes left behind 481s ok 10 - No files in /etc/postgresql left behind 481s ok 11 - No files in /var/lib/postgresql left behind 481s ok 12 - No files in /var/run/postgresql left behind 481s ok 13 - No files in /var/log/postgresql left behind 481s ok 14 - PostgreSQL TCP ports are closed 481s ok 15 - Next free port is 5432 481s ### End test 042_upgrade_rename.t ### 481s 481s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 481s 1..1 481s ok 1 - only one major version installed, skipping upgrade tests 481s ### End test 043_upgrade_ssl_cert.t ### 481s 481s ### PostgreSQL test 045_backup.t ### 481s # We are running systemd 481s # PostgreSQL 16 481s # create cluster 485s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 485s ok 2 - pg_lsclusters -h 485s ok 3 - correct output of pg_lsclusters -h 485s ok 4 - pg_conftool 16 main set work_mem 11MB 485s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 485s ok 6 - psql -c 'alter database mydb set search_path=public' 485s ok 7 - psql -c 'create table foo (t text)' mydb 485s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 485s ok 9 - psql -c 'CREATE USER myuser' 485s ok 10 - psql -c 'grant create on database mydb to myuser' 485s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 485s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 485s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 485s # create directory 485s ok 14 - pg_backupcluster 16 main createdirectory 485s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 485s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 485s # dump 486s ok 17 - systemctl start pg_dump@16-main 486s ok 18 - dump created in /var/backups/postgresql/16-main/2024-06-25T083532Z.dump 486s ok 19 - /var/backups/postgresql/16-main/2024-06-25T083532Z.dump owned by uid postgres 486s ok 20 - /var/backups/postgresql/16-main/2024-06-25T083532Z.dump owned by gid postgres 486s # basebackup 486s ok 21 - systemctl start pg_receivewal@16-main 486s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 487s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 487s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 487s ok 25 - psql -c 'select pg_reload_conf()' 515s ok 26 - systemctl start pg_basebackup@16-main 515s ok 27 - dump created in /var/backups/postgresql/16-main/2024-06-25T083534Z.backup 515s ok 28 - /var/backups/postgresql/16-main/2024-06-25T083534Z.backup owned by uid postgres 515s ok 29 - /var/backups/postgresql/16-main/2024-06-25T083534Z.backup owned by gid postgres 515s # list 515s ok 30 - pg_backupcluster 16 main list 515s ok 31 - correct output of pg_backupcluster 16 main list 515s # more database changes 515s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 515s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 515s ok 34 - retrieve recovery timestamp 515s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 516s ok 36 - systemctl stop pg_receivewal@16-main 516s # restore /var/backups/postgresql/16-main/2024-06-25T083532Z.dump 518s ok 37 - pg_dropcluster 16 main --stop 522s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083532Z.dump --start --datadir /var/lib/postgresql/16/snowflake 522s ok 39 - pg_lsclusters -h 522s ok 40 - correct output of pg_lsclusters -h 522s ok 41 - psql -XAtl 522s ok 42 - mydb locales 522s ok 43 - mydb grants 522s ok 44 - myicudb locales 522s ok 45 - psql -XAtc 'show work_mem' 522s ok 46 - correct output of psql -XAtc 'show work_mem' 523s ok 47 - psql -XAtc 'select * from foo' mydb 523s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 523s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 523s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 523s ok 51 - psql -XAtc '\drds' 523s ok 52 - correct output of psql -XAtc '\drds' 523s # restore /var/backups/postgresql/16-main/2024-06-25T083534Z.backup 525s ok 53 - pg_dropcluster 16 main --stop 528s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083534Z.backup --start --datadir /var/lib/postgresql/16/snowflake 528s ok 55 - pg_lsclusters -h 528s ok 56 - correct output of pg_lsclusters -h 528s ok 57 - psql -XAtl 528s ok 58 - mydb locales 528s ok 59 - mydb grants 528s ok 60 - myicudb locales 528s ok 61 - psql -XAtc 'show work_mem' 528s ok 62 - correct output of psql -XAtc 'show work_mem' 528s ok 63 - psql -XAtc 'select * from foo' mydb 528s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 528s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 528s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 529s ok 67 - psql -XAtc '\drds' 529s ok 68 - correct output of psql -XAtc '\drds' 529s # restore /var/backups/postgresql/16-main/2024-06-25T083534Z.backup with WAL archive 530s ok 69 - pg_dropcluster 16 main --stop 534s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083534Z.backup --start --archive --port 5430 534s ok 71 - pg_lsclusters -h 534s ok 72 - correct output of pg_lsclusters -h 534s ok 73 - psql -XAtc 'select * from foo order by t' mydb 534s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 534s # restore /var/backups/postgresql/16-main/2024-06-25T083534Z.backup with PITR 536s ok 75 - pg_dropcluster 16 main --stop 539s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083534Z.backup --start --pitr '2024-06-25 08:36:02.870294+00 539s # ' 539s ok 77 - pg_lsclusters -h 539s ok 78 - correct output of pg_lsclusters -h 540s ok 79 - psql -XAtc 'select * from foo order by t' mydb 540s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 541s ok 81 - pg_dropcluster 16 main --stop 541s # Cleanup 541s ok 82 - Cleanup: No clusters left behind 541s ok 83 - No postgres processes left behind 541s ok 84 - No files in /etc/postgresql left behind 541s ok 85 - No files in /var/lib/postgresql left behind 541s ok 86 - No files in /var/run/postgresql left behind 541s ok 87 - No files in /var/log/postgresql left behind 541s ok 88 - PostgreSQL TCP ports are closed 541s ok 89 - Next free port is 5432 541s 1..89 541s ### End test 045_backup.t ### 541s 541s ### PostgreSQL test 050_encodings.t ### 541s 1..60 541s # Checking 16 ru_RU 545s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 551s ok 2 - psql -l succeeds 551s ok 3 - template1 is not UTF-8 encoded 551s ok 4 - creating test database 551s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 551s # create table t (x varchar); copy t from stdin" test 551s ok 6 - creating table with ISO-8859-5 characters 551s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 551s ok 8 - correct string in UTF-8 551s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 551s ok 10 - correct string in ISO-8859-5 551s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 551s # delete from t; copy t from stdin" test 551s ok 12 - creating table with UTF-8 characters 551s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 551s ok 14 - correct string in UTF-8 551s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 551s ok 16 - correct string in ISO-8859-1 551s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 551s ok 18 - Server error message has correct language and encoding 551s ok 19 - pg_ctlcluster 16 ru_RU restart 551s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 551s ok 21 - Dropping cluster 551s # Checking 16 ru_RU.UTF-8 554s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 555s ok 23 - psql -l succeeds 555s ok 24 - template1 is UTF-8 encoded 555s ok 25 - creating test database 555s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 555s # create table t (x varchar); copy t from stdin" test 555s ok 27 - creating table with ISO-8859-5 characters 555s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 555s ok 29 - correct string in UTF-8 555s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 555s ok 31 - correct string in ISO-8859-5 555s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 555s # delete from t; copy t from stdin" test 555s ok 33 - creating table with UTF-8 characters 555s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 555s ok 35 - correct string in UTF-8 555s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 555s ok 37 - correct string in ISO-8859-1 555s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 555s ok 39 - Server error message has correct language and encoding 557s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 557s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 557s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 557s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 558s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 558s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 558s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 558s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 559s ok 48 - Dropping cluster 559s # Check 16 locale environment variables 563s ok 49 - pg_createcluster: LC_ALL dominates LANG 563s ok 50 - psql -Atl --cluster 16/main 563s ok 51 - template1 is ASCII encoded 565s ok 52 - Dropping cluster 565s # Cleanup 565s ok 53 - Cleanup: No clusters left behind 565s ok 54 - No postgres processes left behind 565s ok 55 - No files in /etc/postgresql left behind 565s ok 56 - No files in /var/lib/postgresql left behind 565s ok 57 - No files in /var/run/postgresql left behind 565s ok 58 - No files in /var/log/postgresql left behind 565s ok 59 - PostgreSQL TCP ports are closed 565s ok 60 - Next free port is 5432 565s ### End test 050_encodings.t ### 565s 565s ### PostgreSQL test 052_upgrade_encodings.t ### 565s 1..1 565s ok 1 - only one major version installed, skipping upgrade tests 565s ### End test 052_upgrade_encodings.t ### 565s 565s ### PostgreSQL test 060_obsolete_confparams.t ### 565s ok 1 - only one major version installed, skipping upgrade tests 565s 1..1 565s ### End test 060_obsolete_confparams.t ### 565s 565s ### PostgreSQL test 070_non_postgres_clusters.t ### 565s 1..40 566s ok 1 - pg_createcluster 16 main for owner nobody 566s ok 2 - pg_ctlcluster 16 main start 566s ok 3 - start refused when config and data owners mismatch 568s ok 4 - pg_ctlcluster succeeds with owner nobody 569s ok 5 - pg_lsclusters -h 569s ok 6 - pg_lsclusters shows running cluster 569s ok 7 - postgres is running as user nobody 569s ok 8 - ls /tmp/.s.PGSQL.* 569s ok 9 - socket is in /tmp 569s ok 10 - /var/run/postgresql is empty 569s ok 11 - conf dir is owned by user 569s ok 12 - conf dir is owned by user's primary group 569s ok 13 - files are owned by user 569s ok 14 - files are owned by user's primary group 569s ok 15 - log file has 0640 permissions 569s ok 16 - log file is owned by user 569s ok 17 - log file is owned by user's primary group 569s ok 18 - only one major version installed, skipping upgrade test 569s ok 19 - ... 569s ok 20 - ... 569s ok 21 - ... 569s ok 22 - ... 569s ok 23 - ... 569s ok 24 - ... 569s ok 25 - ... 569s ok 26 - ... 569s ok 27 - ... 569s ok 28 - ... 570s ok 29 - pg_dropcluster 570s ok 30 - pg_lsclusters -h 570s ok 31 - No clusters left 570s ok 32 - No postgres processes left 570s # Cleanup 570s ok 33 - Cleanup: No clusters left behind 570s ok 34 - No postgres processes left behind 570s ok 35 - No files in /etc/postgresql left behind 570s ok 36 - No files in /var/lib/postgresql left behind 570s ok 37 - No files in /var/run/postgresql left behind 570s ok 38 - No files in /var/log/postgresql left behind 570s ok 39 - PostgreSQL TCP ports are closed 570s ok 40 - Next free port is 5432 572s ### End test 070_non_postgres_clusters.t ### 572s 572s ### PostgreSQL test 080_start.conf.t ### 572s 1..73 572s ok 1 - pg_createcluster 16 main 572s # start.conf auto 572s ok 2 - get_cluster_start_conf returns auto 572s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 572s ok 4 - start.conf contains auto 572s ok 5 - systemd generator links cluster 572s ok 6 - systemd generator links correct service file 574s ok 7 - /etc/init.d/postgresql start 16 574s ok 8 - correct output of /etc/init.d/postgresql start 16 574s ok 9 - pg_lsclusters -h 574s ok 10 - cluster is online 574s ok 11 - /etc/init.d/postgresql stop 16 574s ok 12 - correct output of /etc/init.d/postgresql stop 16 577s ok 13 - pg_lsclusters -h 577s ok 14 - cluster is down 577s # start.conf manual 577s ok 15 - get_cluster_start_conf returns manual 577s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 577s ok 17 - start.conf contains manual 578s ok 18 - systemd generator doesn't link cluster 578s ok 19 - /etc/init.d/postgresql start 16 578s ok 20 - correct output of /etc/init.d/postgresql start 16 578s ok 21 - pg_lsclusters -h 578s ok 22 - cluster is down 580s ok 23 - pg_ctlcluster 16 main start 580s ok 24 - correct output of pg_ctlcluster 16 main start 580s ok 25 - pg_lsclusters -h 580s ok 26 - cluster is online 580s ok 27 - pg_ctlcluster 16 main stop 580s ok 28 - correct output of pg_ctlcluster 16 main stop 580s ok 29 - pg_lsclusters -h 580s ok 30 - cluster is down 580s # start.conf disabled 580s ok 31 - get_cluster_start_conf returns disabled 580s ok 32 - systemd generator doesn't link cluster 580s ok 33 - /etc/init.d/postgresql start 16 580s ok 34 - correct output of /etc/init.d/postgresql start 16 581s ok 35 - pg_lsclusters -h 581s ok 36 - cluster is down 581s ok 37 - pg_ctlcluster 16 main start 581s ok 38 - correct output of pg_ctlcluster 16 main start 581s ok 39 - pg_lsclusters -h 581s ok 40 - cluster is down 583s ok 41 - pg_ctlcluster 16 main start 583s ok 42 - correct output of pg_ctlcluster 16 main start 583s ok 43 - pg_lsclusters -h 583s ok 44 - cluster is online 583s ok 45 - pg_ctlcluster 16 main stop 583s ok 46 - correct output of pg_ctlcluster 16 main stop 583s ok 47 - pg_lsclusters -h 583s ok 48 - cluster is down 587s ok 49 - pg_ctlcluster 16 main start 587s ok 50 - correct output of pg_ctlcluster 16 main start 588s ok 51 - pg_lsclusters -h 588s ok 52 - cluster is online 588s # test upgrade 588s ok 53 - only one major version installed, skipping upgrade test 588s ok 54 - ... 588s ok 55 - get_cluster_start_conf for old cluster returns manual 588s ok 56 - get_cluster_start_conf for new cluster returns manual 588s ok 57 - ... 588s ok 58 - dropping upgraded cluster 588s ok 59 - pg_lsclusters -h 588s ok 60 - no clusters any more 588s ok 61 - pg_createcluster 16 main --start-conf foo 588s ok 62 - pg_createcluster checks --start-conf validity 588s ok 63 - pg_createcluster checks --start-conf manual 588s ok 64 - get_cluster_start_conf returns manual 609s ok 65 - dropping cluster 609s # Cleanup 609s ok 66 - Cleanup: No clusters left behind 609s ok 67 - No postgres processes left behind 609s ok 68 - No files in /etc/postgresql left behind 609s ok 69 - No files in /var/lib/postgresql left behind 609s ok 70 - No files in /var/run/postgresql left behind 609s ok 71 - No files in /var/log/postgresql left behind 609s ok 72 - PostgreSQL TCP ports are closed 609s ok 73 - Next free port is 5432 609s ### End test 080_start.conf.t ### 609s 609s ### PostgreSQL test 085_pg_ctl.conf.t ### 609s 1..33 609s ok 1 - prlimit --core=0:unlimited --pid=16497 609s ok 2 - set core file size to unlimited 609s ok 3 - sh -c 'ulimit -Hc' 609s ok 4 - core file size is unlimited 609s ok 5 - pg_createcluster 16 main 609s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 609s ok 7 - pg_ctlcluster 16 main start 609s ok 8 - starting cluster as root 609s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 609s ok 10 - soft core size is 0 609s # hard core file size limit of root-started postgres process is unlimited 609s ok 11 - set pg_ctl default option to -c 609s ok 12 - pg_ctlcluster 16 main restart 609s ok 13 - restarting cluster as root 609s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 609s ok 15 - soft core size is unlimited 609s ok 16 - pg_ctlcluster 16 main stop 609s ok 17 - stopping cluster 609s ok 18 - restored pg_ctl default option 609s ok 19 - pg_ctlcluster 16 main start -- -c 609s ok 20 - starting cluster with -c on the command line as postgres 609s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 609s ok 22 - soft core size is unlimited 609s ok 23 - pg_ctlcluster 16 main stop 609s ok 24 - stopping cluster 609s ok 25 - dropping cluster 609s # Cleanup 609s ok 26 - Cleanup: No clusters left behind 609s ok 27 - No postgres processes left behind 609s ok 28 - No files in /etc/postgresql left behind 609s ok 29 - No files in /var/lib/postgresql left behind 609s ok 30 - No files in /var/run/postgresql left behind 609s ok 31 - No files in /var/log/postgresql left behind 609s ok 32 - PostgreSQL TCP ports are closed 609s ok 33 - Next free port is 5432 609s ### End test 085_pg_ctl.conf.t ### 609s 609s ### PostgreSQL test 090_multicluster.t ### 609s 1..125 609s ok 1 - pg_createcluster 16 old 609s ok 2 - pg_createcluster 16 new1 609s ok 3 - pg_createcluster 16 new2 609s ok 4 - starting cluster 16/old 609s ok 5 - starting cluster 16/new1 609s ok 6 - starting cluster 16/new2 609s ok 7 - pg_lsclusters -h | sort -k3 609s ok 8 - clusters have the correct ports, skipping used 5433 609s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 609s ok 10 - createdb --version 609s ok 11 - pg_wrapper selects port 5432 as default cluster 609s ok 12 - createdb --cluster 16/new1 --version 609s ok 13 - pg_wrapper --cluster works 609s ok 14 - createdb --cluster 16/foo --version 609s ok 15 - pg_wrapper --cluster errors out for invalid cluster 609s ok 16 - createdb --cluster 16/new1 test 609s ok 17 - correct output of createdb --cluster 16/new1 test 609s ok 18 - psql -Atl --cluster 16/new1 609s ok 19 - test db appears in cluster new1 610s ok 20 - psql -Atl --cluster 16/new2 610s ok 21 - test db does not appear in cluster new2 610s ok 22 - psql -Atl 610s ok 23 - test db does not appear in default cluster 610s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 610s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 610s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 610s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 610s ok 28 - psql -Atl --cluster 16/localhost:5434 610s ok 29 - test db appears in cluster 16/localhost:5434 610s ok 30 - psql -Atl --cluster 16/localhost:5440 610s ok 31 - test db does not appear in cluster 16/localhost:5440 610s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 610s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 610s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 610s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 610s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 610s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 610s ok 38 - psql -Atl --cluster 6.4/localhost: 610s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 610s ok 40 - psql -Atl 610s ok 41 - PGCLUSTER selection (1) 610s ok 42 - psql -Atl 610s ok 43 - PGCLUSTER selection (2) 610s ok 44 - psql -l 610s ok 45 - invalid PGCLUSTER value 610s ok 46 - createdb --version 610s ok 47 - PGCLUSTER network cluster selection (1) 610s ok 48 - psql -Atl 610s ok 49 - PGCLUSTER network cluster selection (2) 610s ok 50 - psql -Atl 610s ok 51 - PGCLUSTER network cluster selection (3) 610s ok 52 - LC_MESSAGES=C psql -Atl 610s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 610s ok 54 - psql -Atc "show port" template1 610s ok 55 - PGPORT selection (1) 610s ok 56 - psql -Atc "show port" template1 610s ok 57 - PGPORT selection (2) 610s ok 58 - createdb --version 610s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 610s ok 60 - psql -Atc "show port" template1 610s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 610s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 610s ok 63 - PGDATABASE environment variable works 610s ok 64 - createdb --version 610s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 610s ok 66 - createdb --cluster 16/new1 --version 610s ok 67 - pg_wrapper --cluster works with empty user_clusters 610s ok 68 - createdb --version 610s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 610s ok 70 - psql -Atc "select current_database()" 610s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 610s ok 72 - psql -Atc 'select current_database()' 610s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 611s ok 74 - createdb --version 611s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 611s ok 76 - createdb --version 611s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 611s ok 78 - createdb --version 611s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 611s ok 80 - createdb --version 611s ok 81 - pg_wrapper selects correct version with per-user user_clusters 611s ok 82 - createdb --version 611s ok 83 - pg_wrapper selects correct version with per-user user_clusters 611s ok 84 - createdb --version 611s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 611s ok 86 - psql -Atl 611s ok 87 - $PGHOST overrides user_clusters 611s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 611s ok 89 - --cluster overrides $PGHOST 611s ok 90 - createdb --version 611s ok 91 - pg_wrapper ignores invalid lines in user_clusters 611s ok 92 - psql -Atc 'select current_database()' 611s ok 93 - pg_service conf selection 1 611s ok 94 - psql -Atc 'select current_database()' 611s ok 95 - pg_service conf selection 2 611s ok 96 - psql -Atc 'select current_database()' 611s ok 97 - pg_service conf selection 3 611s ok 98 - stopping cluster 16/old 614s ok 99 - restarting cluster 16/old 614s ok 100 - pg_lsclusters -h | sort -k3 614s ok 101 - port of first cluster was successfully changed 614s ok 102 - psql -l 614s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 614s ok 104 - psql -Atl --cluster 16/new1 614s ok 105 - --cluster selects appropriate cluster 614s ok 106 - psql -Atl -p 5434 614s ok 107 - -p selects appropriate cluster 614s ok 108 - psql -Atlp 5434 614s ok 109 - -Atlp selects appropriate cluster 614s ok 110 - psql -Atl --port 5434 614s ok 111 - --port selects appropriate cluster 614s ok 112 - env PGPORT=5434 psql -Atl 614s ok 113 - $PGPORT selects appropriate cluster 614s ok 114 - Restoring original /etc/postgresql-common/user_clusters 624s ok 115 - dropping 16/new1 624s ok 116 - dropping 16/new2 624s ok 117 - dropping 16/old 624s # Cleanup 624s ok 118 - Cleanup: No clusters left behind 624s ok 119 - No postgres processes left behind 624s ok 120 - No files in /etc/postgresql left behind 624s ok 121 - No files in /var/lib/postgresql left behind 624s ok 122 - No files in /var/run/postgresql left behind 624s ok 123 - No files in /var/log/postgresql left behind 624s ok 124 - PostgreSQL TCP ports are closed 624s ok 125 - Next free port is 5432 624s ### End test 090_multicluster.t ### 624s 624s ### PostgreSQL test 110_integrate_cluster.t ### 624s 1..32 624s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/gZniw_k7fT/c/postgres 624s ok 2 - creating raw initdb cluster for user postgres 624s ok 3 - pg_createcluster 16 postgres -d /tmp/gZniw_k7fT/c/postgres 624s ok 4 - integrating postgres cluster 624s ok 5 - pg_lsclusters 624s ok 6 - correct pg_lsclusters output 624s ok 7 - pg_ctlcluster 16 postgres start 624s ok 8 - starting cluster postgres 624s ok 9 - pg_lsclusters 624s ok 10 - correct pg_lsclusters output 624s ok 11 - dropping cluster postgres 624s ok 12 - No files in temporary cluster dir left behind 625s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/gZniw_k7fT/c/nobody 639s ok 14 - creating raw initdb cluster for user nobody 639s ok 15 - pg_createcluster 16 nobody -d /tmp/gZniw_k7fT/c/nobody 639s ok 16 - integrating nobody cluster 639s ok 17 - pg_lsclusters 639s ok 18 - correct pg_lsclusters output 639s ok 19 - pg_ctlcluster 16 nobody start 639s ok 20 - starting cluster nobody 639s ok 21 - pg_lsclusters 639s ok 22 - correct pg_lsclusters output 639s ok 23 - dropping cluster nobody 639s ok 24 - No files in temporary cluster dir left behind 639s # Cleanup 639s ok 25 - Cleanup: No clusters left behind 639s ok 26 - No postgres processes left behind 639s ok 27 - No files in /etc/postgresql left behind 639s ok 28 - No files in /var/lib/postgresql left behind 639s ok 29 - No files in /var/run/postgresql left behind 639s ok 30 - No files in /var/log/postgresql left behind 639s ok 31 - PostgreSQL TCP ports are closed 639s ok 32 - Next free port is 5432 639s ### End test 110_integrate_cluster.t ### 639s 639s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 639s 1..1 639s ok 1 - only one major version installed, skipping upgrade tests 639s ### End test 120_pg_upgradecluster_scripts.t ### 639s 639s ### PostgreSQL test 130_nonroot_admin.t ### 639s 1..22 639s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 639s ok 2 - pg_lsclusters -h 639s ok 3 - correct output of pg_lsclusters -h 639s ok 4 - psql -Atl 639s ok 5 - correct output of psql -Atl 639s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 639s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 639s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 639s # Cleanup 639s ok 15 - Cleanup: No clusters left behind 639s ok 16 - No postgres processes left behind 639s ok 17 - No files in /etc/postgresql left behind 639s ok 18 - No files in /var/lib/postgresql left behind 639s ok 19 - No files in /var/run/postgresql left behind 639s ok 20 - No files in /var/log/postgresql left behind 639s ok 21 - PostgreSQL TCP ports are closed 639s ok 22 - Next free port is 5432 639s ### End test 130_nonroot_admin.t ### 639s 639s ### PostgreSQL test 135_pg_virtualenv.t ### 639s 1..20 639s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 639s ok 2 - running pg_virtualenv as root 641s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 641s ok 4 - running pg_virtualenv as postgres 645s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 645s ok 6 - running pg_virtualenv as nobody 648s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 648s ok 8 - running fakeroot pg_virtualenv as root 651s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 651s ok 10 - running fakeroot pg_virtualenv as postgres 654s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 654s ok 12 - running fakeroot pg_virtualenv as nobody 654s # Cleanup 654s ok 13 - Cleanup: No clusters left behind 654s ok 14 - No postgres processes left behind 654s ok 15 - No files in /etc/postgresql left behind 654s ok 16 - No files in /var/lib/postgresql left behind 654s ok 17 - No files in /var/run/postgresql left behind 654s ok 18 - No files in /var/log/postgresql left behind 654s ok 19 - PostgreSQL TCP ports are closed 654s ok 20 - Next free port is 5432 654s ### End test 135_pg_virtualenv.t ### 654s 654s ### PostgreSQL test 140_pg_config.t ### 654s 1..38 654s # Multiarch is enabled 654s # checking version specific output for 16 654s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 654s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 654s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 654s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 654s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 654s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 654s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 654s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 654s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 654s # checking pg_config output (should behave like version 16) 654s ok 15 - pg_config 654s ok 16 - correct output of pg_config 654s ok 17 - pg_config --help 654s ok 18 - correct output of pg_config --help 654s ok 19 - pg_config --pgxs 654s ok 20 - correct output of pg_config --pgxs 654s ok 21 - pg_config --libdir 654s ok 22 - correct output of pg_config --libdir 654s ok 23 - pg_config --pkglibdir 654s ok 24 - correct output of pg_config --pkglibdir 654s ok 25 - pg_config --bindir 654s ok 26 - correct output of pg_config --bindir 654s # checking pg_config.libpq-dev output (should behave like version 16) 654s ok 27 - pg_config.libpq-dev 654s ok 28 - correct output of pg_config.libpq-dev 654s ok 29 - pg_config.libpq-dev --help 654s ok 30 - correct output of pg_config.libpq-dev --help 654s ok 31 - pg_config.libpq-dev --pgxs 654s ok 32 - correct output of pg_config.libpq-dev --pgxs 654s ok 33 - pg_config.libpq-dev --libdir 654s ok 34 - correct output of pg_config.libpq-dev --libdir 654s ok 35 - pg_config.libpq-dev --pkglibdir 654s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 654s ok 37 - pg_config.libpq-dev --bindir 654s ok 38 - correct output of pg_config.libpq-dev --bindir 654s ### End test 140_pg_config.t ### 654s 654s ### PostgreSQL test 150_tsearch_stemming.t ### 655s 1..37 655s ok 1 - pg_updatedicts succeeded 655s ok 2 - pg_updatedicts created en_us.affix 655s ok 3 - pg_updatedicts created en_us.dict 655s ok 4 - pg_updatedicts created 16 en_us.affix symlink 655s ok 5 - pg_updatedicts created 16 en_us.dict symlink 658s ok 6 - pg_createcluster 16 main 658s ok 7 - createdb fts 658s ok 8 - correct output of createdb fts 658s ok 9 - creating en_US full text search configuration 658s ok 10 - creating data table and search index 658s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 658s ok 12 - stem search of correct word 658s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 658s ok 14 - stem search of correct word 659s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 659s ok 16 - stem search of unknown word 659s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 659s ok 18 - full text search, exact word 659s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 659s ok 20 - full text search for word stem 659s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 659s ok 22 - full text search for word substring fails 659s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 659s ok 24 - full text search, exact unicode word 659s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 659s ok 26 - full text search for unicode word stem 659s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 659s ok 28 - full text search for unicode word substring fails 661s ok 29 661s # Cleanup 661s ok 30 - Cleanup: No clusters left behind 661s ok 31 - No postgres processes left behind 661s ok 32 - No files in /etc/postgresql left behind 661s ok 33 - No files in /var/lib/postgresql left behind 661s ok 34 - No files in /var/run/postgresql left behind 661s ok 35 - No files in /var/log/postgresql left behind 661s ok 36 - PostgreSQL TCP ports are closed 661s ok 37 - Next free port is 5432 661s ### End test 150_tsearch_stemming.t ### 661s 661s ### PostgreSQL test 160_alternate_confroot.t ### 661s 1..28 664s ok 1 664s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 664s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 664s ok 4 - pg_lsclusters -h 664s ok 5 - correct output of pg_lsclusters -h 664s ok 6 - psql -Atl 664s ok 7 - correct output of psql -Atl 664s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 664s ok 9 - ... 664s ok 10 - ... 664s ok 11 - ... 664s ok 12 - ... 664s ok 13 - ... 664s ok 14 - ... 664s ok 15 - pg_dropcluster 16 test --stop 664s ok 16 - correct output of pg_dropcluster 16 test --stop 664s ok 17 - pg_lsclusters -h 664s ok 18 - correct output of pg_lsclusters -h 664s ok 19 - No files in root/data left behind 664s ok 20 - No cruft in root dir left behind 664s # Cleanup 664s ok 21 - Cleanup: No clusters left behind 664s ok 22 - No postgres processes left behind 664s ok 23 - No files in /etc/postgresql left behind 664s ok 24 - No files in /var/lib/postgresql left behind 664s ok 25 - No files in /var/run/postgresql left behind 664s ok 26 - No files in /var/log/postgresql left behind 664s ok 27 - PostgreSQL TCP ports are closed 664s ok 28 - Next free port is 5432 664s ### End test 160_alternate_confroot.t ### 664s 664s ### PostgreSQL test 170_extensions.t ### 664s # Running tests for 16 668s ok 1 - pg_createcluster 16 main 668s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 668s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 668s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 668s ok 5 - extension adminpack installs without error 668s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 668s ok 7 - extension adminpack removes without error 668s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 668s ok 9 - extension amcheck installs without error 668s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 668s ok 11 - extension amcheck removes without error 668s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 668s ok 13 - extension autoinc installs without error 668s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 668s ok 15 - extension autoinc removes without error 668s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 668s ok 17 - extension bloom installs without error 668s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 668s ok 19 - extension bloom removes without error 668s ok 20 - psql -qc 'CREATE EXTENSION plperl' 668s ok 21 - bool_plperl dependency plperl installs without error 668s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 668s ok 23 - extension bool_plperl installs without error 668s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 668s ok 25 - extension bool_plperl removes without error 668s ok 26 - psql -qc 'DROP EXTENSION plperl' 668s ok 27 - bool_plperl dependency extension plperl removes without error 668s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 668s ok 29 - bool_plperlu dependency plperlu installs without error 668s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 668s ok 31 - extension bool_plperlu installs without error 668s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 668s ok 33 - extension bool_plperlu removes without error 668s ok 34 - psql -qc 'DROP EXTENSION plperlu' 668s ok 35 - bool_plperlu dependency extension plperlu removes without error 668s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 668s ok 37 - extension btree_gin installs without error 669s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 669s ok 39 - extension btree_gin removes without error 669s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 669s ok 41 - extension btree_gist installs without error 669s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 669s ok 43 - extension btree_gist removes without error 669s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 669s ok 45 - extension citext installs without error 669s ok 46 - psql -qc 'DROP EXTENSION "citext"' 669s ok 47 - extension citext removes without error 669s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 669s ok 49 - extension cube installs without error 669s ok 50 - psql -qc 'DROP EXTENSION "cube"' 669s ok 51 - extension cube removes without error 669s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 669s ok 53 - extension dblink installs without error 669s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 669s ok 55 - extension dblink removes without error 669s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 669s ok 57 - extension dict_int installs without error 669s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 669s ok 59 - extension dict_int removes without error 669s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 669s ok 61 - extension dict_xsyn installs without error 669s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 669s ok 63 - extension dict_xsyn removes without error 669s ok 64 - psql -qc 'CREATE EXTENSION cube' 669s ok 65 - earthdistance dependency cube installs without error 669s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 669s ok 67 - extension earthdistance installs without error 669s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 669s ok 69 - extension earthdistance removes without error 669s ok 70 - psql -qc 'DROP EXTENSION cube' 669s ok 71 - earthdistance dependency extension cube removes without error 670s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 670s ok 73 - extension file_fdw installs without error 670s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 670s ok 75 - extension file_fdw removes without error 670s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 670s ok 77 - extension fuzzystrmatch installs without error 670s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 670s ok 79 - extension fuzzystrmatch removes without error 670s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 670s ok 81 - extension hstore installs without error 670s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 670s ok 83 - extension hstore removes without error 670s ok 84 - psql -qc 'CREATE EXTENSION hstore' 670s ok 85 - hstore_plperl dependency hstore installs without error 670s ok 86 - psql -qc 'CREATE EXTENSION plperl' 670s ok 87 - hstore_plperl dependency plperl installs without error 670s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 670s ok 89 - extension hstore_plperl installs without error 670s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 670s ok 91 - extension hstore_plperl removes without error 670s ok 92 - psql -qc 'DROP EXTENSION hstore' 670s ok 93 - hstore_plperl dependency extension hstore removes without error 670s ok 94 - psql -qc 'DROP EXTENSION plperl' 670s ok 95 - hstore_plperl dependency extension plperl removes without error 670s ok 96 - psql -qc 'CREATE EXTENSION hstore' 670s ok 97 - hstore_plperlu dependency hstore installs without error 670s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 670s ok 99 - hstore_plperlu dependency plperlu installs without error 670s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 670s ok 101 - extension hstore_plperlu installs without error 670s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 670s ok 103 - extension hstore_plperlu removes without error 670s ok 104 - psql -qc 'DROP EXTENSION hstore' 670s ok 105 - hstore_plperlu dependency extension hstore removes without error 670s ok 106 - psql -qc 'DROP EXTENSION plperlu' 670s ok 107 - hstore_plperlu dependency extension plperlu removes without error 670s ok 108 - psql -qc 'CREATE EXTENSION hstore' 670s ok 109 - hstore_plpython3u dependency hstore installs without error 670s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 670s ok 111 - hstore_plpython3u dependency plpython3u installs without error 670s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 670s ok 113 - extension hstore_plpython3u installs without error 670s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 670s ok 115 - extension hstore_plpython3u removes without error 671s ok 116 - psql -qc 'DROP EXTENSION hstore' 671s ok 117 - hstore_plpython3u dependency extension hstore removes without error 671s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 671s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 671s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 671s ok 121 - extension insert_username installs without error 671s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 671s ok 123 - extension insert_username removes without error 671s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 671s ok 125 - extension intagg installs without error 671s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 671s ok 127 - extension intagg removes without error 671s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 671s ok 129 - extension intarray installs without error 671s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 671s ok 131 - extension intarray removes without error 671s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 671s ok 133 - extension isn installs without error 671s ok 134 - psql -qc 'DROP EXTENSION "isn"' 671s ok 135 - extension isn removes without error 671s ok 136 - psql -qc 'CREATE EXTENSION plperl' 671s ok 137 - jsonb_plperl dependency plperl installs without error 671s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 671s ok 139 - extension jsonb_plperl installs without error 671s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 671s ok 141 - extension jsonb_plperl removes without error 671s ok 142 - psql -qc 'DROP EXTENSION plperl' 671s ok 143 - jsonb_plperl dependency extension plperl removes without error 671s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 671s ok 145 - jsonb_plperlu dependency plperlu installs without error 671s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 671s ok 147 - extension jsonb_plperlu installs without error 671s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 671s ok 149 - extension jsonb_plperlu removes without error 671s ok 150 - psql -qc 'DROP EXTENSION plperlu' 671s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 671s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 671s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 672s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 672s ok 155 - extension jsonb_plpython3u installs without error 672s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 672s ok 157 - extension jsonb_plpython3u removes without error 672s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 672s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 672s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 672s ok 161 - extension lo installs without error 672s ok 162 - psql -qc 'DROP EXTENSION "lo"' 672s ok 163 - extension lo removes without error 672s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 672s ok 165 - extension ltree installs without error 672s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 672s ok 167 - extension ltree removes without error 672s ok 168 - psql -qc 'CREATE EXTENSION ltree' 672s ok 169 - ltree_plpython3u dependency ltree installs without error 672s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 672s ok 171 - ltree_plpython3u dependency plpython3u installs without error 672s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 672s ok 173 - extension ltree_plpython3u installs without error 672s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 672s ok 175 - extension ltree_plpython3u removes without error 672s ok 176 - psql -qc 'DROP EXTENSION ltree' 672s ok 177 - ltree_plpython3u dependency extension ltree removes without error 672s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 672s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 672s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 672s ok 181 - extension moddatetime installs without error 672s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 672s ok 183 - extension moddatetime removes without error 673s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 673s ok 185 - extension old_snapshot installs without error 673s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 673s ok 187 - extension old_snapshot removes without error 673s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 673s ok 189 - extension pageinspect installs without error 673s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 673s ok 191 - extension pageinspect removes without error 673s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 673s ok 193 - extension pg_buffercache installs without error 673s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 673s ok 195 - extension pg_buffercache removes without error 673s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 673s ok 197 - extension pg_freespacemap installs without error 673s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 673s ok 199 - extension pg_freespacemap removes without error 673s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 673s ok 201 - extension pg_prewarm installs without error 673s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 673s ok 203 - extension pg_prewarm removes without error 673s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 673s ok 205 - extension pg_stat_statements installs without error 673s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 673s ok 207 - extension pg_stat_statements removes without error 673s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 673s ok 209 - extension pg_surgery installs without error 673s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 673s ok 211 - extension pg_surgery removes without error 673s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 673s ok 213 - extension pg_trgm installs without error 673s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 673s ok 215 - extension pg_trgm removes without error 674s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 674s ok 217 - extension pg_visibility installs without error 674s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 674s ok 219 - extension pg_visibility removes without error 674s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 674s ok 221 - extension pg_walinspect installs without error 674s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 674s ok 223 - extension pg_walinspect removes without error 674s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 674s ok 225 - extension pgcrypto installs without error 674s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 674s ok 227 - extension pgcrypto removes without error 674s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 674s ok 229 - extension pgrowlocks installs without error 674s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 674s ok 231 - extension pgrowlocks removes without error 674s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 674s ok 233 - extension pgstattuple installs without error 674s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 674s ok 235 - extension pgstattuple removes without error 674s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 674s ok 237 - extension plperl installs without error 674s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 674s ok 239 - extension plperl removes without error 674s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 674s ok 241 - extension plperlu installs without error 674s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 674s ok 243 - extension plperlu removes without error 674s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 674s ok 245 - extension plpython3u installs without error 674s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 674s ok 247 - extension plpython3u removes without error 675s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 675s ok 249 - extension pltcl installs without error 675s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 675s ok 251 - extension pltcl removes without error 675s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 675s ok 253 - extension pltclu installs without error 675s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 675s ok 255 - extension pltclu removes without error 675s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 675s ok 257 - extension postgres_fdw installs without error 675s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 675s ok 259 - extension postgres_fdw removes without error 675s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 675s ok 261 - extension refint installs without error 675s ok 262 - psql -qc 'DROP EXTENSION "refint"' 675s ok 263 - extension refint removes without error 675s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 675s ok 265 - extension seg installs without error 675s ok 266 - psql -qc 'DROP EXTENSION "seg"' 675s ok 267 - extension seg removes without error 675s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 675s ok 269 - extension sslinfo installs without error 675s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 675s ok 271 - extension sslinfo removes without error 675s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 675s ok 273 - extension tablefunc installs without error 675s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 675s ok 275 - extension tablefunc removes without error 675s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 675s ok 277 - extension tcn installs without error 675s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 675s ok 279 - extension tcn removes without error 675s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 675s ok 281 - extension tsm_system_rows installs without error 675s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 675s ok 283 - extension tsm_system_rows removes without error 675s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 675s ok 285 - extension tsm_system_time installs without error 675s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 675s ok 287 - extension tsm_system_time removes without error 676s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 676s ok 289 - extension unaccent installs without error 676s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 676s ok 291 - extension unaccent removes without error 676s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 676s ok 293 - extension uuid-ossp installs without error 676s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 676s ok 295 - extension uuid-ossp removes without error 676s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 676s ok 297 - extension xml2 installs without error 676s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 676s ok 299 - extension xml2 removes without error 678s ok 300 - pg_dropcluster 16 main 678s # Cleanup 678s ok 301 - Cleanup: No clusters left behind 678s ok 302 - No postgres processes left behind 678s ok 303 - No files in /etc/postgresql left behind 678s ok 304 - No files in /var/lib/postgresql left behind 678s ok 305 - No files in /var/run/postgresql left behind 678s ok 306 - No files in /var/log/postgresql left behind 678s ok 307 - PostgreSQL TCP ports are closed 678s ok 308 - Next free port is 5432 678s 1..308 678s ### End test 170_extensions.t ### 678s 678s ### PostgreSQL test 180_ecpg.t ### 678s 1..14 678s ok 1 - ecpg test.pgc 678s ok 2 - ecpg processing 678s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 678s ok 4 - compiling ecpg output 685s ok 5 - pg_virtualenv /tmp/tmp.MyMzQ7SOe5/test 685s ok 6 - test program runs and gives correct output 685s # Cleanup 685s ok 7 - Cleanup: No clusters left behind 685s ok 8 - No postgres processes left behind 685s ok 9 - No files in /etc/postgresql left behind 685s ok 10 - No files in /var/lib/postgresql left behind 685s ok 11 - No files in /var/run/postgresql left behind 685s ok 12 - No files in /var/log/postgresql left behind 685s ok 13 - PostgreSQL TCP ports are closed 685s ok 14 - Next free port is 5432 685s ### End test 180_ecpg.t ### 685s 685s ### PostgreSQL test 190_pg_buildext.t ### 685s ok 1 - make clean 685s ok 2 - make tar 686s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 686s # testing 'dh --with pgxs' 689s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 689s ok 5 - postgresql-16-foo_123-1_s390x.deb was built 696s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 696s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 697s ok 8 - dpkg -i postgresql-16-foo_123-1_s390x.deb 704s ok 9 - cd foo-123 && pg_buildext installcheck 704s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 712s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 712s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 719s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 719s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 719s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 719s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 719s ok 17 - dpkg -r postgresql-16-foo 719s # testing 'dh --with pgxs_loop' 719s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 722s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 722s ok 20 - postgresql-16-foo_123-1_s390x.deb was built 722s ok 21 - make clean 722s # testing pg_buildext updatecontrol 722s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 722s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 722s 1..23 722s ### End test 190_pg_buildext.t ### 722s 722s ### PostgreSQL test 200_maintscripts.t ### 722s 1..15 722s # We are running systemd 726s ok 1 - pg_createcluster 16 main --start 726s ok 2 - postmaster PID is 22861 727s ok 3 - apt-get update -q 728s # postgresql-common: 728s # Installed: 260 728s # Candidate: 260 728s # Version table: 728s # *** 260 990 728s # 990 http://ftpmaster.internal/ubuntu oracular/main s390x Packages 728s # 100 /var/lib/dpkg/status 731s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 731s # postgresql-common: 731s # Installed: 260 731s # Candidate: 260 731s # Version table: 731s # *** 260 990 731s # 990 http://ftpmaster.internal/ubuntu oracular/main s390x Packages 731s # 100 /var/lib/dpkg/status 731s ok 5 - postmaster PID is 22861 731s ok 6 - postmaster was not restarted 733s ok 7 - pg_dropcluster 16 main --stop 733s # Cleanup 733s ok 8 - Cleanup: No clusters left behind 733s ok 9 - No postgres processes left behind 733s ok 10 - No files in /etc/postgresql left behind 733s ok 11 - No files in /var/lib/postgresql left behind 733s ok 12 - No files in /var/run/postgresql left behind 733s ok 13 - No files in /var/log/postgresql left behind 733s ok 14 - PostgreSQL TCP ports are closed 733s ok 15 - Next free port is 5432 733s ### End test 200_maintscripts.t ### 733s 734s autopkgtest [08:39:41]: test run-testsuite: -----------------------] 735s autopkgtest [08:39:42]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 735s run-testsuite PASS 739s autopkgtest [08:39:46]: @@@@@@@@@@@@@@@@@@@@ summary 739s default-psql PASS 739s run-testsuite PASS 760s nova [W] Using flock in scalingstack-bos02-s390x 760s Creating nova instance adt-oracular-s390x-postgresql-common-20240625-082727-juju-7f2275-prod-proposed-migration-environment-2-b10fa386-1122-44ef-9729-7827c79246ef from image adt/ubuntu-oracular-s390x-server-20240625.img (UUID f029f818-16e1-4f96-ad01-3182fd7f5948)... 760s nova [W] Using flock in scalingstack-bos02-s390x 760s Creating nova instance adt-oracular-s390x-postgresql-common-20240625-082727-juju-7f2275-prod-proposed-migration-environment-2-b10fa386-1122-44ef-9729-7827c79246ef from image adt/ubuntu-oracular-s390x-server-20240625.img (UUID f029f818-16e1-4f96-ad01-3182fd7f5948)...