0s autopkgtest [08:26:41]: starting date and time: 2024-06-25 08:26:41+0000 0s autopkgtest [08:26:41]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [08:26:41]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.bwq70vsw/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@lcy02-11.secgroup --name adt-oracular-amd64-postgresql-common-20240625-082641-juju-7f2275-prod-proposed-migration-environment-2-54eca450-5c4e-49cb-bbb9-37413e649646 --image adt/ubuntu-oracular-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 79s autopkgtest [08:28:00]: testbed dpkg architecture: amd64 79s autopkgtest [08:28:00]: testbed apt version: 2.9.5 79s autopkgtest [08:28:00]: @@@@@@@@@@@@@@@@@@@@ test bed setup 79s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 79s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 79s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 79s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 79s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 79s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages [123 kB] 79s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages [92.7 kB] 79s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted amd64 Packages [28.9 kB] 79s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted i386 Packages [6732 B] 79s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 Packages [388 kB] 79s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe i386 Packages [198 kB] 80s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse i386 Packages [3884 B] 80s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse amd64 Packages [8364 B] 80s Fetched 1467 kB in 0s (6068 kB/s) 80s Reading package lists... 81s Reading package lists... 81s Building dependency tree... 81s Reading state information... 82s Calculating upgrade... 82s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 82s Reading package lists... 82s Building dependency tree... 82s Reading state information... 83s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 83s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 83s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 83s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 83s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 84s Reading package lists... 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 85s Calculating upgrade... 85s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 85s Reading package lists... 85s Building dependency tree... 85s Reading state information... 86s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 86s autopkgtest [08:28:07]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 86s autopkgtest [08:28:07]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 89s Get:1 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (dsc) [2383 B] 89s Get:2 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (tar) [218 kB] 89s gpgv: Signature made Thu May 9 15:21:37 2024 UTC 89s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 89s gpgv: Can't check signature: No public key 89s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_260.dsc: no acceptable signature found 89s autopkgtest [08:28:10]: testing package postgresql-common version 260 89s autopkgtest [08:28:10]: build not needed 89s autopkgtest [08:28:10]: test default-psql: preparing testbed 89s Reading package lists... 90s Building dependency tree... 90s Reading state information... 90s Starting pkgProblemResolver with broken count: 0 90s Starting 2 pkgProblemResolver with broken count: 0 90s Done 91s The following additional packages will be installed: 91s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 91s postgresql-client-common postgresql-common ssl-cert 91s Suggested packages: 91s postgresql-doc postgresql-doc-16 91s Recommended packages: 91s libjson-xs-perl 91s The following NEW packages will be installed: 91s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 91s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 91s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 91s Need to get 17.4 MB/17.4 MB of archives. 91s After this operation, 51.2 MB of additional disk space will be used. 91s Get:1 /tmp/autopkgtest.1LiX4L/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [704 B] 91s Get:2 http://ftpmaster.internal/ubuntu oracular/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 91s Get:3 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-common all 260 [36.4 kB] 91s Get:4 http://ftpmaster.internal/ubuntu oracular/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 91s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-common all 260 [162 kB] 91s Get:6 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq5 amd64 16.3-1 [140 kB] 91s Get:7 http://ftpmaster.internal/ubuntu oracular/main amd64 libxslt1.1 amd64 1.1.39-0exp1build1 [167 kB] 91s Get:8 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-16 amd64 16.3-1 [1269 kB] 91s Get:9 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-16 amd64 16.3-1 [15.5 MB] 91s Get:10 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql all 16+260 [11.6 kB] 92s Preconfiguring packages ... 92s Fetched 17.4 MB in 1s (29.2 MB/s) 92s Selecting previously unselected package libjson-perl. 92s (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 ... 74417 files and directories currently installed.) 92s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 92s Unpacking libjson-perl (4.10000-1) ... 92s Selecting previously unselected package postgresql-client-common. 92s Preparing to unpack .../1-postgresql-client-common_260_all.deb ... 92s Unpacking postgresql-client-common (260) ... 92s Selecting previously unselected package ssl-cert. 92s Preparing to unpack .../2-ssl-cert_1.1.2ubuntu1_all.deb ... 92s Unpacking ssl-cert (1.1.2ubuntu1) ... 92s Selecting previously unselected package postgresql-common. 92s Preparing to unpack .../3-postgresql-common_260_all.deb ... 92s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 92s Unpacking postgresql-common (260) ... 92s Selecting previously unselected package libpq5:amd64. 92s Preparing to unpack .../4-libpq5_16.3-1_amd64.deb ... 92s Unpacking libpq5:amd64 (16.3-1) ... 92s Selecting previously unselected package libxslt1.1:amd64. 92s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1build1_amd64.deb ... 92s Unpacking libxslt1.1:amd64 (1.1.39-0exp1build1) ... 92s Selecting previously unselected package postgresql-client-16. 92s Preparing to unpack .../6-postgresql-client-16_16.3-1_amd64.deb ... 92s Unpacking postgresql-client-16 (16.3-1) ... 93s Selecting previously unselected package postgresql-16. 93s Preparing to unpack .../7-postgresql-16_16.3-1_amd64.deb ... 93s Unpacking postgresql-16 (16.3-1) ... 93s Selecting previously unselected package postgresql. 93s Preparing to unpack .../8-postgresql_16+260_all.deb ... 93s Unpacking postgresql (16+260) ... 93s Selecting previously unselected package autopkgtest-satdep. 93s Preparing to unpack .../9-1-autopkgtest-satdep.deb ... 93s Unpacking autopkgtest-satdep (0) ... 93s Setting up postgresql-client-common (260) ... 93s Setting up libpq5:amd64 (16.3-1) ... 93s Setting up ssl-cert (1.1.2ubuntu1) ... 94s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 95s Setting up libjson-perl (4.10000-1) ... 95s Setting up libxslt1.1:amd64 (1.1.39-0exp1build1) ... 95s Setting up postgresql-client-16 (16.3-1) ... 95s 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 95s Setting up postgresql-common (260) ... 96s 96s Creating config file /etc/postgresql-common/createcluster.conf with new version 96s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 96s Removing obsolete dictionary files: 96s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 97s Setting up postgresql-16 (16.3-1) ... 97s Creating new PostgreSQL cluster 16/main ... 97s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 97s The files belonging to this database system will be owned by user "postgres". 97s This user must also own the server process. 97s 97s The database cluster will be initialized with locale "C.UTF-8". 97s The default database encoding has accordingly been set to "UTF8". 97s The default text search configuration will be set to "english". 97s 97s Data page checksums are disabled. 97s 97s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 97s creating subdirectories ... ok 97s selecting dynamic shared memory implementation ... posix 97s selecting default max_connections ... 100 97s selecting default shared_buffers ... 128MB 97s selecting default time zone ... Etc/UTC 97s creating configuration files ... ok 97s running bootstrap script ... ok 98s performing post-bootstrap initialization ... ok 98s syncing data to disk ... ok 101s Setting up postgresql (16+260) ... 101s Setting up autopkgtest-satdep (0) ... 101s Processing triggers for man-db (2.12.1-2) ... 103s Processing triggers for libc-bin (2.39-0ubuntu9) ... 105s (Reading database ... 76358 files and directories currently installed.) 105s Removing autopkgtest-satdep (0) ... 105s autopkgtest [08:28:26]: test default-psql: [----------------------- 106s autopkgtest [08:28:27]: test default-psql: -----------------------] 106s autopkgtest [08:28:27]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 106s default-psql PASS 106s autopkgtest [08:28:27]: test run-testsuite: preparing testbed 196s autopkgtest [08:29:57]: testbed dpkg architecture: amd64 196s autopkgtest [08:29:57]: testbed apt version: 2.9.5 196s autopkgtest [08:29:57]: @@@@@@@@@@@@@@@@@@@@ test bed setup 197s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 197s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [58.2 kB] 197s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [3256 B] 197s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [439 kB] 197s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 197s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages [123 kB] 197s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages [92.7 kB] 197s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted i386 Packages [6732 B] 197s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted amd64 Packages [28.9 kB] 197s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe i386 Packages [198 kB] 197s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 Packages [388 kB] 197s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse amd64 Packages [8364 B] 197s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse i386 Packages [3884 B] 197s Fetched 1467 kB in 0s (5599 kB/s) 197s Reading package lists... 198s Reading package lists... 199s Building dependency tree... 199s Reading state information... 199s Calculating upgrade... 199s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 199s Reading package lists... 200s Building dependency tree... 200s Reading state information... 200s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 200s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 200s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 200s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 200s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 201s Reading package lists... 202s Reading package lists... 202s Building dependency tree... 202s Reading state information... 202s Calculating upgrade... 202s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 202s Reading package lists... 203s Building dependency tree... 203s Reading state information... 203s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 205s Reading package lists... 205s Building dependency tree... 205s Reading state information... 205s Starting pkgProblemResolver with broken count: 0 205s Starting 2 pkgProblemResolver with broken count: 0 205s Done 206s The following additional packages will be installed: 206s autoconf automake autopoint autotools-dev build-essential clang-18 cpp 206s cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 206s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 206s fakeroot g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-13 206s gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext 206s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 206s libatomic1 libcc1-0 libclang-common-18-dev libdebhelper-perl libecpg-compat3 206s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 206s libgc1 libgcc-13-dev libgomp1 libhwasan0 libicu-dev libisl23 libitm1 206s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 206s libpgtypes3 libpq-dev libpq5 libpython3.12t64 libquadmath0 libssl-dev 206s libstdc++-13-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 206s libz3-4 libz3-dev llvm-18 llvm-18-dev llvm-18-linker-tools llvm-18-runtime 206s llvm-18-tools locales-all m4 po-debconf postgresql-16 postgresql-all 206s postgresql-client-16 postgresql-client-common postgresql-common 206s postgresql-doc postgresql-doc-16 postgresql-plperl-16 206s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 206s postgresql-server-dev-all ssl-cert 206s Suggested packages: 206s autoconf-archive gnu-standards autoconf-doc clang-18-doc wasi-libc cpp-doc 206s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 206s g++-multilib g++-13-multilib gcc-13-doc gcc-multilib manpages-dev flex bison 206s gdb gcc-doc gcc-13-multilib gdb-x86-64-linux-gnu gettext-doc libasprintf-dev 206s libgettextpo-dev hunspell openoffice.org-hunspell | openoffice.org-core 206s icu-doc ncurses-doc libssl-doc libstdc++-13-doc tcl8.6 libtool-doc gfortran 206s | fortran95-compiler gcj-jdk pkg-config llvm-18-doc m4-doc libmail-box-perl 206s Recommended packages: 206s libclang-rt-18-dev libarchive-cpio-perl libjson-xs-perl libltdl-dev 206s libmail-sendmail-perl 206s The following NEW packages will be installed: 206s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 206s clang-18 cpp cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper 206s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 206s emacsen-common fakeroot g++ g++-13 g++-13-x86-64-linux-gnu 206s g++-x86-64-linux-gnu gcc gcc-13 gcc-13-base gcc-13-x86-64-linux-gnu 206s gcc-x86-64-linux-gnu gettext hunspell-en-us icu-devtools intltool-debian 206s libarchive-zip-perl libasan8 libatomic1 libcc1-0 libclang-common-18-dev 206s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 206s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 206s libhwasan0 libicu-dev libisl23 libitm1 libjson-perl liblsan0 libmpc3 206s libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 206s libpython3.12t64 libquadmath0 libssl-dev libstdc++-13-dev libtcl8.6 libtool 206s libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev llvm-18 206s llvm-18-dev llvm-18-linker-tools llvm-18-runtime llvm-18-tools locales-all 206s m4 po-debconf postgresql-16 postgresql-all postgresql-client-16 206s postgresql-client-common postgresql-common postgresql-doc postgresql-doc-16 206s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 206s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert 206s 0 upgraded, 94 newly installed, 0 to remove and 0 not upgraded. 206s Need to get 198 MB/198 MB of archives. 206s After this operation, 1138 MB of additional disk space will be used. 206s Get:1 /tmp/autopkgtest.1LiX4L/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [792 B] 206s Get:2 http://ftpmaster.internal/ubuntu oracular/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 208s Get:3 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-common all 260 [36.4 kB] 208s Get:4 http://ftpmaster.internal/ubuntu oracular/main amd64 ssl-cert all 1.1.2ubuntu1 [17.8 kB] 208s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-common all 260 [162 kB] 208s Get:6 http://ftpmaster.internal/ubuntu oracular/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 208s Get:7 http://ftpmaster.internal/ubuntu oracular/main amd64 autoconf all 2.71-3 [339 kB] 208s Get:8 http://ftpmaster.internal/ubuntu oracular/main amd64 autotools-dev all 20220109.1 [44.9 kB] 208s Get:9 http://ftpmaster.internal/ubuntu oracular/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 208s Get:10 http://ftpmaster.internal/ubuntu oracular/main amd64 autopoint all 0.21-14ubuntu2 [422 kB] 208s Get:11 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13-base amd64 13.2.0-23ubuntu4 [49.0 kB] 208s Get:12 http://ftpmaster.internal/ubuntu oracular/main amd64 libisl23 amd64 0.26-3build1 [680 kB] 208s Get:13 http://ftpmaster.internal/ubuntu oracular/main amd64 libmpc3 amd64 1.3.1-1build1 [54.5 kB] 208s Get:14 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [11.2 MB] 208s Get:15 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-13 amd64 13.2.0-23ubuntu4 [1032 B] 208s Get:16 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 208s Get:17 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 208s Get:18 http://ftpmaster.internal/ubuntu oracular/main amd64 libcc1-0 amd64 14.1.0-1ubuntu1 [48.0 kB] 208s Get:19 http://ftpmaster.internal/ubuntu oracular/main amd64 libgomp1 amd64 14.1.0-1ubuntu1 [148 kB] 208s Get:20 http://ftpmaster.internal/ubuntu oracular/main amd64 libitm1 amd64 14.1.0-1ubuntu1 [29.1 kB] 208s Get:21 http://ftpmaster.internal/ubuntu oracular/main amd64 libatomic1 amd64 14.1.0-1ubuntu1 [10.4 kB] 208s Get:22 http://ftpmaster.internal/ubuntu oracular/main amd64 libasan8 amd64 14.1.0-1ubuntu1 [3025 kB] 208s Get:23 http://ftpmaster.internal/ubuntu oracular/main amd64 liblsan0 amd64 14.1.0-1ubuntu1 [1313 kB] 208s Get:24 http://ftpmaster.internal/ubuntu oracular/main amd64 libtsan2 amd64 14.1.0-1ubuntu1 [2736 kB] 208s Get:25 http://ftpmaster.internal/ubuntu oracular/main amd64 libubsan1 amd64 14.1.0-1ubuntu1 [1174 kB] 208s Get:26 http://ftpmaster.internal/ubuntu oracular/main amd64 libhwasan0 amd64 14.1.0-1ubuntu1 [1632 kB] 208s Get:27 http://ftpmaster.internal/ubuntu oracular/main amd64 libquadmath0 amd64 14.1.0-1ubuntu1 [153 kB] 208s Get:28 http://ftpmaster.internal/ubuntu oracular/main amd64 libgcc-13-dev amd64 13.2.0-23ubuntu4 [2688 kB] 208s Get:29 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [21.9 MB] 208s Get:30 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13 amd64 13.2.0-23ubuntu4 [482 kB] 208s Get:31 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 208s Get:32 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 208s Get:33 http://ftpmaster.internal/ubuntu oracular/main amd64 libstdc++-13-dev amd64 13.2.0-23ubuntu4 [2399 kB] 208s Get:34 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [12.5 MB] 209s Get:35 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-13 amd64 13.2.0-23ubuntu4 [14.5 kB] 209s Get:36 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 209s Get:37 http://ftpmaster.internal/ubuntu oracular/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 209s Get:38 http://ftpmaster.internal/ubuntu oracular/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 209s Get:39 http://ftpmaster.internal/ubuntu oracular/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 209s Get:40 http://ftpmaster.internal/ubuntu oracular/universe amd64 libobjc4 amd64 14.1.0-1ubuntu1 [46.1 kB] 209s Get:41 http://ftpmaster.internal/ubuntu oracular/universe amd64 libobjc-13-dev amd64 13.2.0-23ubuntu4 [194 kB] 209s Get:42 http://ftpmaster.internal/ubuntu oracular/universe amd64 libclang-common-18-dev amd64 1:18.1.7-1 [735 kB] 209s Get:43 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-linker-tools amd64 1:18.1.7-1 [1310 kB] 209s Get:44 http://ftpmaster.internal/ubuntu oracular/universe amd64 clang-18 amd64 1:18.1.7-1 [80.0 kB] 209s Get:45 http://ftpmaster.internal/ubuntu oracular/main amd64 libdebhelper-perl all 13.15.3ubuntu2 [92.3 kB] 209s Get:46 http://ftpmaster.internal/ubuntu oracular/main amd64 libtool all 2.4.7-7build1 [166 kB] 209s Get:47 http://ftpmaster.internal/ubuntu oracular/main amd64 dh-autoreconf all 20 [16.1 kB] 209s Get:48 http://ftpmaster.internal/ubuntu oracular/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 209s Get:49 http://ftpmaster.internal/ubuntu oracular/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 209s Get:50 http://ftpmaster.internal/ubuntu oracular/main amd64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 209s Get:51 http://ftpmaster.internal/ubuntu oracular/main amd64 debugedit amd64 1:5.0-5build2 [46.1 kB] 209s Get:52 http://ftpmaster.internal/ubuntu oracular/main amd64 dwz amd64 0.15-1build6 [115 kB] 209s Get:53 http://ftpmaster.internal/ubuntu oracular/main amd64 gettext amd64 0.21-14ubuntu2 [864 kB] 209s Get:54 http://ftpmaster.internal/ubuntu oracular/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 209s Get:55 http://ftpmaster.internal/ubuntu oracular/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 209s Get:56 http://ftpmaster.internal/ubuntu oracular/main amd64 debhelper all 13.15.3ubuntu2 [878 kB] 209s Get:57 http://ftpmaster.internal/ubuntu oracular/main amd64 emacsen-common all 3.0.5 [12.1 kB] 209s Get:58 http://ftpmaster.internal/ubuntu oracular/main amd64 dictionaries-common all 1.29.7 [188 kB] 209s Get:59 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libfakeroot amd64 1.35.1-1 [32.6 kB] 209s Get:60 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 fakeroot amd64 1.35.1-1 [67.5 kB] 209s Get:61 http://ftpmaster.internal/ubuntu oracular/main amd64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 209s Get:62 http://ftpmaster.internal/ubuntu oracular/main amd64 icu-devtools amd64 74.2-1ubuntu3 [212 kB] 209s Get:63 http://ftpmaster.internal/ubuntu oracular/main amd64 libpgtypes3 amd64 16.3-1 [43.0 kB] 209s Get:64 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq5 amd64 16.3-1 [140 kB] 209s Get:65 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg6 amd64 16.3-1 [44.5 kB] 209s Get:66 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg-compat3 amd64 16.3-1 [17.8 kB] 209s Get:67 http://ftpmaster.internal/ubuntu oracular/main amd64 libssl-dev amd64 3.0.13-0ubuntu4 [2408 kB] 209s Get:68 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq-dev amd64 16.3-1 [151 kB] 209s Get:69 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg-dev amd64 16.3-1 [265 kB] 209s Get:70 http://ftpmaster.internal/ubuntu oracular/main amd64 libicu-dev amd64 74.2-1ubuntu3 [11.9 MB] 209s Get:71 http://ftpmaster.internal/ubuntu oracular/main amd64 libncurses-dev amd64 6.5-2 [384 kB] 209s Get:72 http://ftpmaster.internal/ubuntu oracular/main amd64 libpython3.12t64 amd64 3.12.4-1 [2338 kB] 209s Get:73 http://ftpmaster.internal/ubuntu oracular/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 209s Get:74 http://ftpmaster.internal/ubuntu oracular/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3 [780 kB] 209s Get:75 http://ftpmaster.internal/ubuntu oracular/main amd64 libxslt1.1 amd64 1.1.39-0exp1build1 [167 kB] 209s Get:76 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-runtime amd64 1:18.1.7-1 [537 kB] 209s Get:77 http://ftpmaster.internal/ubuntu oracular/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 209s Get:78 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18 amd64 1:18.1.7-1 [25.2 MB] 210s Get:79 http://ftpmaster.internal/ubuntu oracular/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 210s Get:80 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-tools amd64 1:18.1.7-1 [533 kB] 210s Get:81 http://ftpmaster.internal/ubuntu oracular/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 210s Get:82 http://ftpmaster.internal/ubuntu oracular/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 210s Get:83 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-dev amd64 1:18.1.7-1 [44.9 MB] 212s Get:84 http://ftpmaster.internal/ubuntu oracular/universe amd64 locales-all amd64 2.39-0ubuntu9 [11.0 MB] 212s Get:85 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-16 amd64 16.3-1 [1269 kB] 212s Get:86 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-16 amd64 16.3-1 [15.5 MB] 212s Get:87 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-server-dev-16 amd64 16.3-1 [1223 kB] 212s Get:88 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-server-dev-all amd64 260 [20.6 kB] 212s Get:89 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-plperl-16 amd64 16.3-1 [67.4 kB] 212s Get:90 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-plpython3-16 amd64 16.3-1 [75.4 kB] 212s Get:91 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-pltcl-16 amd64 16.3-1 [30.2 kB] 212s Get:92 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-all all 260 [1712 B] 212s Get:93 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-doc-16 all 16.3-1 [2098 kB] 212s Get:94 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-doc all 16+260 [11.6 kB] 212s Preconfiguring packages ... 212s Fetched 198 MB in 6s (33.2 MB/s) 212s Selecting previously unselected package libjson-perl. 213s (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 ... 74417 files and directories currently installed.) 213s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 213s Unpacking libjson-perl (4.10000-1) ... 213s Selecting previously unselected package postgresql-client-common. 213s Preparing to unpack .../01-postgresql-client-common_260_all.deb ... 213s Unpacking postgresql-client-common (260) ... 213s Selecting previously unselected package ssl-cert. 213s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu1_all.deb ... 213s Unpacking ssl-cert (1.1.2ubuntu1) ... 213s Selecting previously unselected package postgresql-common. 213s Preparing to unpack .../03-postgresql-common_260_all.deb ... 213s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 213s Unpacking postgresql-common (260) ... 213s Selecting previously unselected package m4. 213s Preparing to unpack .../04-m4_1.4.19-4build1_amd64.deb ... 213s Unpacking m4 (1.4.19-4build1) ... 213s Selecting previously unselected package autoconf. 213s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 213s Unpacking autoconf (2.71-3) ... 213s Selecting previously unselected package autotools-dev. 213s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 213s Unpacking autotools-dev (20220109.1) ... 213s Selecting previously unselected package automake. 213s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 213s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 213s Selecting previously unselected package autopoint. 213s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 213s Unpacking autopoint (0.21-14ubuntu2) ... 213s Selecting previously unselected package gcc-13-base:amd64. 213s Preparing to unpack .../09-gcc-13-base_13.2.0-23ubuntu4_amd64.deb ... 213s Unpacking gcc-13-base:amd64 (13.2.0-23ubuntu4) ... 213s Selecting previously unselected package libisl23:amd64. 213s Preparing to unpack .../10-libisl23_0.26-3build1_amd64.deb ... 213s Unpacking libisl23:amd64 (0.26-3build1) ... 213s Selecting previously unselected package libmpc3:amd64. 213s Preparing to unpack .../11-libmpc3_1.3.1-1build1_amd64.deb ... 213s Unpacking libmpc3:amd64 (1.3.1-1build1) ... 213s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 213s Preparing to unpack .../12-cpp-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 213s Unpacking cpp-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 213s Selecting previously unselected package cpp-13. 213s Preparing to unpack .../13-cpp-13_13.2.0-23ubuntu4_amd64.deb ... 213s Unpacking cpp-13 (13.2.0-23ubuntu4) ... 213s Selecting previously unselected package cpp-x86-64-linux-gnu. 213s Preparing to unpack .../14-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 213s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 213s Selecting previously unselected package cpp. 213s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 213s Unpacking cpp (4:13.2.0-7ubuntu1) ... 213s Selecting previously unselected package libcc1-0:amd64. 213s Preparing to unpack .../16-libcc1-0_14.1.0-1ubuntu1_amd64.deb ... 213s Unpacking libcc1-0:amd64 (14.1.0-1ubuntu1) ... 213s Selecting previously unselected package libgomp1:amd64. 213s Preparing to unpack .../17-libgomp1_14.1.0-1ubuntu1_amd64.deb ... 213s Unpacking libgomp1:amd64 (14.1.0-1ubuntu1) ... 213s Selecting previously unselected package libitm1:amd64. 213s Preparing to unpack .../18-libitm1_14.1.0-1ubuntu1_amd64.deb ... 213s Unpacking libitm1:amd64 (14.1.0-1ubuntu1) ... 213s Selecting previously unselected package libatomic1:amd64. 213s Preparing to unpack .../19-libatomic1_14.1.0-1ubuntu1_amd64.deb ... 213s Unpacking libatomic1:amd64 (14.1.0-1ubuntu1) ... 213s Selecting previously unselected package libasan8:amd64. 213s Preparing to unpack .../20-libasan8_14.1.0-1ubuntu1_amd64.deb ... 213s Unpacking libasan8:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package liblsan0:amd64. 214s Preparing to unpack .../21-liblsan0_14.1.0-1ubuntu1_amd64.deb ... 214s Unpacking liblsan0:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package libtsan2:amd64. 214s Preparing to unpack .../22-libtsan2_14.1.0-1ubuntu1_amd64.deb ... 214s Unpacking libtsan2:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package libubsan1:amd64. 214s Preparing to unpack .../23-libubsan1_14.1.0-1ubuntu1_amd64.deb ... 214s Unpacking libubsan1:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package libhwasan0:amd64. 214s Preparing to unpack .../24-libhwasan0_14.1.0-1ubuntu1_amd64.deb ... 214s Unpacking libhwasan0:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package libquadmath0:amd64. 214s Preparing to unpack .../25-libquadmath0_14.1.0-1ubuntu1_amd64.deb ... 214s Unpacking libquadmath0:amd64 (14.1.0-1ubuntu1) ... 214s Selecting previously unselected package libgcc-13-dev:amd64. 214s Preparing to unpack .../26-libgcc-13-dev_13.2.0-23ubuntu4_amd64.deb ... 214s Unpacking libgcc-13-dev:amd64 (13.2.0-23ubuntu4) ... 214s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 214s Preparing to unpack .../27-gcc-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 214s Unpacking gcc-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 214s Selecting previously unselected package gcc-13. 214s Preparing to unpack .../28-gcc-13_13.2.0-23ubuntu4_amd64.deb ... 214s Unpacking gcc-13 (13.2.0-23ubuntu4) ... 214s Selecting previously unselected package gcc-x86-64-linux-gnu. 214s Preparing to unpack .../29-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 214s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 214s Selecting previously unselected package gcc. 214s Preparing to unpack .../30-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 214s Unpacking gcc (4:13.2.0-7ubuntu1) ... 214s Selecting previously unselected package libstdc++-13-dev:amd64. 214s Preparing to unpack .../31-libstdc++-13-dev_13.2.0-23ubuntu4_amd64.deb ... 214s Unpacking libstdc++-13-dev:amd64 (13.2.0-23ubuntu4) ... 215s Selecting previously unselected package g++-13-x86-64-linux-gnu. 215s Preparing to unpack .../32-g++-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 215s Unpacking g++-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 215s Selecting previously unselected package g++-13. 215s Preparing to unpack .../33-g++-13_13.2.0-23ubuntu4_amd64.deb ... 215s Unpacking g++-13 (13.2.0-23ubuntu4) ... 215s Selecting previously unselected package g++-x86-64-linux-gnu. 215s Preparing to unpack .../34-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 215s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 215s Selecting previously unselected package g++. 215s Preparing to unpack .../35-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 215s Unpacking g++ (4:13.2.0-7ubuntu1) ... 215s Selecting previously unselected package build-essential. 215s Preparing to unpack .../36-build-essential_12.10ubuntu1_amd64.deb ... 215s Unpacking build-essential (12.10ubuntu1) ... 215s Selecting previously unselected package libgc1:amd64. 215s Preparing to unpack .../37-libgc1_1%3a8.2.6-1build1_amd64.deb ... 215s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 215s Selecting previously unselected package libobjc4:amd64. 215s Preparing to unpack .../38-libobjc4_14.1.0-1ubuntu1_amd64.deb ... 215s Unpacking libobjc4:amd64 (14.1.0-1ubuntu1) ... 215s Selecting previously unselected package libobjc-13-dev:amd64. 215s Preparing to unpack .../39-libobjc-13-dev_13.2.0-23ubuntu4_amd64.deb ... 215s Unpacking libobjc-13-dev:amd64 (13.2.0-23ubuntu4) ... 215s Selecting previously unselected package libclang-common-18-dev:amd64. 215s Preparing to unpack .../40-libclang-common-18-dev_1%3a18.1.7-1_amd64.deb ... 215s Unpacking libclang-common-18-dev:amd64 (1:18.1.7-1) ... 215s Selecting previously unselected package llvm-18-linker-tools. 215s Preparing to unpack .../41-llvm-18-linker-tools_1%3a18.1.7-1_amd64.deb ... 215s Unpacking llvm-18-linker-tools (1:18.1.7-1) ... 215s Selecting previously unselected package clang-18. 215s Preparing to unpack .../42-clang-18_1%3a18.1.7-1_amd64.deb ... 215s Unpacking clang-18 (1:18.1.7-1) ... 215s Selecting previously unselected package libdebhelper-perl. 215s Preparing to unpack .../43-libdebhelper-perl_13.15.3ubuntu2_all.deb ... 215s Unpacking libdebhelper-perl (13.15.3ubuntu2) ... 215s Selecting previously unselected package libtool. 215s Preparing to unpack .../44-libtool_2.4.7-7build1_all.deb ... 215s Unpacking libtool (2.4.7-7build1) ... 215s Selecting previously unselected package dh-autoreconf. 215s Preparing to unpack .../45-dh-autoreconf_20_all.deb ... 215s Unpacking dh-autoreconf (20) ... 215s Selecting previously unselected package libarchive-zip-perl. 215s Preparing to unpack .../46-libarchive-zip-perl_1.68-1_all.deb ... 215s Unpacking libarchive-zip-perl (1.68-1) ... 215s Selecting previously unselected package libfile-stripnondeterminism-perl. 215s Preparing to unpack .../47-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 215s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 215s Selecting previously unselected package dh-strip-nondeterminism. 215s Preparing to unpack .../48-dh-strip-nondeterminism_1.14.0-1_all.deb ... 215s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 215s Selecting previously unselected package debugedit. 215s Preparing to unpack .../49-debugedit_1%3a5.0-5build2_amd64.deb ... 215s Unpacking debugedit (1:5.0-5build2) ... 215s Selecting previously unselected package dwz. 215s Preparing to unpack .../50-dwz_0.15-1build6_amd64.deb ... 215s Unpacking dwz (0.15-1build6) ... 215s Selecting previously unselected package gettext. 215s Preparing to unpack .../51-gettext_0.21-14ubuntu2_amd64.deb ... 215s Unpacking gettext (0.21-14ubuntu2) ... 216s Selecting previously unselected package intltool-debian. 216s Preparing to unpack .../52-intltool-debian_0.35.0+20060710.6_all.deb ... 216s Unpacking intltool-debian (0.35.0+20060710.6) ... 216s Selecting previously unselected package po-debconf. 216s Preparing to unpack .../53-po-debconf_1.0.21+nmu1_all.deb ... 216s Unpacking po-debconf (1.0.21+nmu1) ... 216s Selecting previously unselected package debhelper. 216s Preparing to unpack .../54-debhelper_13.15.3ubuntu2_all.deb ... 216s Unpacking debhelper (13.15.3ubuntu2) ... 216s Selecting previously unselected package emacsen-common. 216s Preparing to unpack .../55-emacsen-common_3.0.5_all.deb ... 216s Unpacking emacsen-common (3.0.5) ... 216s Selecting previously unselected package dictionaries-common. 216s Preparing to unpack .../56-dictionaries-common_1.29.7_all.deb ... 216s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 216s Unpacking dictionaries-common (1.29.7) ... 216s Selecting previously unselected package libfakeroot:amd64. 216s Preparing to unpack .../57-libfakeroot_1.35.1-1_amd64.deb ... 216s Unpacking libfakeroot:amd64 (1.35.1-1) ... 216s Selecting previously unselected package fakeroot. 216s Preparing to unpack .../58-fakeroot_1.35.1-1_amd64.deb ... 216s Unpacking fakeroot (1.35.1-1) ... 216s Selecting previously unselected package hunspell-en-us. 216s Preparing to unpack .../59-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 216s Unpacking hunspell-en-us (1:2020.12.07-2) ... 216s Selecting previously unselected package icu-devtools. 216s Preparing to unpack .../60-icu-devtools_74.2-1ubuntu3_amd64.deb ... 216s Unpacking icu-devtools (74.2-1ubuntu3) ... 216s Selecting previously unselected package libpgtypes3:amd64. 216s Preparing to unpack .../61-libpgtypes3_16.3-1_amd64.deb ... 216s Unpacking libpgtypes3:amd64 (16.3-1) ... 216s Selecting previously unselected package libpq5:amd64. 216s Preparing to unpack .../62-libpq5_16.3-1_amd64.deb ... 216s Unpacking libpq5:amd64 (16.3-1) ... 216s Selecting previously unselected package libecpg6:amd64. 216s Preparing to unpack .../63-libecpg6_16.3-1_amd64.deb ... 216s Unpacking libecpg6:amd64 (16.3-1) ... 216s Selecting previously unselected package libecpg-compat3:amd64. 216s Preparing to unpack .../64-libecpg-compat3_16.3-1_amd64.deb ... 216s Unpacking libecpg-compat3:amd64 (16.3-1) ... 216s Selecting previously unselected package libssl-dev:amd64. 216s Preparing to unpack .../65-libssl-dev_3.0.13-0ubuntu4_amd64.deb ... 216s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu4) ... 216s Selecting previously unselected package libpq-dev. 216s Preparing to unpack .../66-libpq-dev_16.3-1_amd64.deb ... 216s Unpacking libpq-dev (16.3-1) ... 216s Selecting previously unselected package libecpg-dev. 216s Preparing to unpack .../67-libecpg-dev_16.3-1_amd64.deb ... 216s Unpacking libecpg-dev (16.3-1) ... 216s Selecting previously unselected package libicu-dev:amd64. 216s Preparing to unpack .../68-libicu-dev_74.2-1ubuntu3_amd64.deb ... 216s Unpacking libicu-dev:amd64 (74.2-1ubuntu3) ... 216s Selecting previously unselected package libncurses-dev:amd64. 216s Preparing to unpack .../69-libncurses-dev_6.5-2_amd64.deb ... 216s Unpacking libncurses-dev:amd64 (6.5-2) ... 216s Selecting previously unselected package libpython3.12t64:amd64. 216s Preparing to unpack .../70-libpython3.12t64_3.12.4-1_amd64.deb ... 216s Unpacking libpython3.12t64:amd64 (3.12.4-1) ... 217s Selecting previously unselected package libtcl8.6:amd64. 217s Preparing to unpack .../71-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 217s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 217s Selecting previously unselected package libxml2-dev:amd64. 217s Preparing to unpack .../72-libxml2-dev_2.9.14+dfsg-1.3ubuntu3_amd64.deb ... 217s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3) ... 217s Selecting previously unselected package libxslt1.1:amd64. 217s Preparing to unpack .../73-libxslt1.1_1.1.39-0exp1build1_amd64.deb ... 217s Unpacking libxslt1.1:amd64 (1.1.39-0exp1build1) ... 217s Selecting previously unselected package llvm-18-runtime. 217s Preparing to unpack .../74-llvm-18-runtime_1%3a18.1.7-1_amd64.deb ... 217s Unpacking llvm-18-runtime (1:18.1.7-1) ... 217s Selecting previously unselected package libpfm4:amd64. 217s Preparing to unpack .../75-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 217s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 217s Selecting previously unselected package llvm-18. 217s Preparing to unpack .../76-llvm-18_1%3a18.1.7-1_amd64.deb ... 217s Unpacking llvm-18 (1:18.1.7-1) ... 217s Selecting previously unselected package libffi-dev:amd64. 217s Preparing to unpack .../77-libffi-dev_3.4.6-1build1_amd64.deb ... 217s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 217s Selecting previously unselected package llvm-18-tools. 217s Preparing to unpack .../78-llvm-18-tools_1%3a18.1.7-1_amd64.deb ... 217s Unpacking llvm-18-tools (1:18.1.7-1) ... 218s Selecting previously unselected package libz3-4:amd64. 218s Preparing to unpack .../79-libz3-4_4.8.12-3.1build1_amd64.deb ... 218s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 218s Selecting previously unselected package libz3-dev:amd64. 218s Preparing to unpack .../80-libz3-dev_4.8.12-3.1build1_amd64.deb ... 218s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 218s Selecting previously unselected package llvm-18-dev. 218s Preparing to unpack .../81-llvm-18-dev_1%3a18.1.7-1_amd64.deb ... 218s Unpacking llvm-18-dev (1:18.1.7-1) ... 219s Selecting previously unselected package locales-all. 219s Preparing to unpack .../82-locales-all_2.39-0ubuntu9_amd64.deb ... 219s Unpacking locales-all (2.39-0ubuntu9) ... 221s Selecting previously unselected package postgresql-client-16. 221s Preparing to unpack .../83-postgresql-client-16_16.3-1_amd64.deb ... 221s Unpacking postgresql-client-16 (16.3-1) ... 221s Selecting previously unselected package postgresql-16. 221s Preparing to unpack .../84-postgresql-16_16.3-1_amd64.deb ... 221s Unpacking postgresql-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-server-dev-16. 222s Preparing to unpack .../85-postgresql-server-dev-16_16.3-1_amd64.deb ... 222s Unpacking postgresql-server-dev-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-server-dev-all:amd64. 222s Preparing to unpack .../86-postgresql-server-dev-all_260_amd64.deb ... 222s Unpacking postgresql-server-dev-all:amd64 (260) ... 222s Selecting previously unselected package postgresql-plperl-16. 222s Preparing to unpack .../87-postgresql-plperl-16_16.3-1_amd64.deb ... 222s Unpacking postgresql-plperl-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-plpython3-16. 222s Preparing to unpack .../88-postgresql-plpython3-16_16.3-1_amd64.deb ... 222s Unpacking postgresql-plpython3-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-pltcl-16. 222s Preparing to unpack .../89-postgresql-pltcl-16_16.3-1_amd64.deb ... 222s Unpacking postgresql-pltcl-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-all. 222s Preparing to unpack .../90-postgresql-all_260_all.deb ... 222s Unpacking postgresql-all (260) ... 222s Selecting previously unselected package postgresql-doc-16. 222s Preparing to unpack .../91-postgresql-doc-16_16.3-1_all.deb ... 222s Unpacking postgresql-doc-16 (16.3-1) ... 222s Selecting previously unselected package postgresql-doc. 222s Preparing to unpack .../92-postgresql-doc_16+260_all.deb ... 222s Unpacking postgresql-doc (16+260) ... 222s Selecting previously unselected package autopkgtest-satdep. 222s Preparing to unpack .../93-2-autopkgtest-satdep.deb ... 222s Unpacking autopkgtest-satdep (0) ... 222s Setting up postgresql-client-common (260) ... 222s Setting up libpgtypes3:amd64 (16.3-1) ... 222s Setting up libncurses-dev:amd64 (6.5-2) ... 222s Setting up postgresql-doc-16 (16.3-1) ... 222s 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 222s Setting up libarchive-zip-perl (1.68-1) ... 222s Setting up libdebhelper-perl (13.15.3ubuntu2) ... 222s Setting up libpq5:amd64 (16.3-1) ... 222s Setting up m4 (1.4.19-4build1) ... 222s Setting up llvm-18-tools (1:18.1.7-1) ... 222s Setting up libgomp1:amd64 (14.1.0-1ubuntu1) ... 222s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 222s Setting up locales-all (2.39-0ubuntu9) ... 222s Setting up libfakeroot:amd64 (1.35.1-1) ... 222s Setting up fakeroot (1.35.1-1) ... 222s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 222s Setting up libpython3.12t64:amd64 (3.12.4-1) ... 222s Setting up autotools-dev (20220109.1) ... 222s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 222s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 222s Setting up gcc-13-base:amd64 (13.2.0-23ubuntu4) ... 222s Setting up emacsen-common (3.0.5) ... 222s Setting up ssl-cert (1.1.2ubuntu1) ... 223s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 223s Setting up libquadmath0:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libssl-dev:amd64 (3.0.13-0ubuntu4) ... 223s Setting up libmpc3:amd64 (1.3.1-1build1) ... 223s Setting up libatomic1:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 223s Setting up autopoint (0.21-14ubuntu2) ... 223s Setting up icu-devtools (74.2-1ubuntu3) ... 223s Setting up libclang-common-18-dev:amd64 (1:18.1.7-1) ... 223s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 223s Setting up autoconf (2.71-3) ... 223s Setting up llvm-18-linker-tools (1:18.1.7-1) ... 223s Setting up libubsan1:amd64 (14.1.0-1ubuntu1) ... 223s Setting up dwz (0.15-1build6) ... 223s Setting up libhwasan0:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libasan8:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libjson-perl (4.10000-1) ... 223s Setting up postgresql-doc (16+260) ... 223s Setting up libxslt1.1:amd64 (1.1.39-0exp1build1) ... 223s Setting up debugedit (1:5.0-5build2) ... 223s Setting up libecpg6:amd64 (16.3-1) ... 223s Setting up libtsan2:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libisl23:amd64 (0.26-3build1) ... 223s Setting up llvm-18-runtime (1:18.1.7-1) ... 223s Setting up libicu-dev:amd64 (74.2-1ubuntu3) ... 223s Setting up libcc1-0:amd64 (14.1.0-1ubuntu1) ... 223s Setting up liblsan0:amd64 (14.1.0-1ubuntu1) ... 223s Setting up libitm1:amd64 (14.1.0-1ubuntu1) ... 223s Setting up automake (1:1.16.5-1.3ubuntu1) ... 223s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 223s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 223s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 223s Setting up gettext (0.21-14ubuntu2) ... 223s Setting up libecpg-compat3:amd64 (16.3-1) ... 223s Setting up dictionaries-common (1.29.7) ... 224s Setting up cpp-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 224s Setting up postgresql-client-16 (16.3-1) ... 224s 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 224s Setting up libpq-dev (16.3-1) ... 224s Setting up libobjc4:amd64 (14.1.0-1ubuntu1) ... 224s Setting up libecpg-dev (16.3-1) ... 224s Setting up intltool-debian (0.35.0+20060710.6) ... 224s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3) ... 224s Setting up postgresql-common (260) ... 225s 225s Creating config file /etc/postgresql-common/createcluster.conf with new version 225s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 225s en_us 225s Removing obsolete dictionary files: 226s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 226s Setting up dh-strip-nondeterminism (1.14.0-1) ... 226s Setting up libgcc-13-dev:amd64 (13.2.0-23ubuntu4) ... 226s Setting up llvm-18 (1:18.1.7-1) ... 226s Setting up hunspell-en-us (1:2020.12.07-2) ... 226s Setting up libobjc-13-dev:amd64 (13.2.0-23ubuntu4) ... 226s Setting up libstdc++-13-dev:amd64 (13.2.0-23ubuntu4) ... 226s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 226s Setting up llvm-18-dev (1:18.1.7-1) ... 226s Setting up postgresql-16 (16.3-1) ... 226s Creating new PostgreSQL cluster 16/main ... 226s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 226s The files belonging to this database system will be owned by user "postgres". 226s This user must also own the server process. 226s 226s The database cluster will be initialized with locale "C.UTF-8". 226s The default database encoding has accordingly been set to "UTF8". 226s The default text search configuration will be set to "english". 226s 226s Data page checksums are disabled. 226s 226s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 226s creating subdirectories ... ok 226s selecting dynamic shared memory implementation ... posix 226s selecting default max_connections ... 100 226s selecting default shared_buffers ... 128MB 226s selecting default time zone ... Etc/UTC 226s creating configuration files ... ok 227s running bootstrap script ... ok 227s performing post-bootstrap initialization ... ok 227s syncing data to disk ... ok 231s Setting up cpp-13 (13.2.0-23ubuntu4) ... 231s Setting up gcc-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 231s Setting up po-debconf (1.0.21+nmu1) ... 231s Setting up clang-18 (1:18.1.7-1) ... 231s Setting up gcc-13 (13.2.0-23ubuntu4) ... 231s Setting up postgresql-server-dev-16 (16.3-1) ... 231s Setting up postgresql-plpython3-16 (16.3-1) ... 231s Setting up cpp (4:13.2.0-7ubuntu1) ... 231s Setting up postgresql-plperl-16 (16.3-1) ... 231s Setting up postgresql-server-dev-all:amd64 (260) ... 231s Setting up postgresql-pltcl-16 (16.3-1) ... 231s Setting up g++-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 231s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 231s Setting up libtool (2.4.7-7build1) ... 231s Setting up postgresql-all (260) ... 231s Setting up gcc (4:13.2.0-7ubuntu1) ... 231s Setting up dh-autoreconf (20) ... 231s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 231s Setting up g++-13 (13.2.0-23ubuntu4) ... 231s Setting up debhelper (13.15.3ubuntu2) ... 231s Setting up g++ (4:13.2.0-7ubuntu1) ... 231s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 231s Setting up build-essential (12.10ubuntu1) ... 231s Setting up autopkgtest-satdep (0) ... 231s Processing triggers for systemd (255.4-1ubuntu8) ... 231s Processing triggers for man-db (2.12.1-2) ... 232s Processing triggers for install-info (7.1-3build2) ... 233s Processing triggers for libc-bin (2.39-0ubuntu9) ... 233s Processing triggers for dictionaries-common (1.29.7) ... 237s (Reading database ... 92725 files and directories currently installed.) 237s Removing autopkgtest-satdep (0) ... 239s autopkgtest [08:30:40]: test run-testsuite: [----------------------- 240s ====== Running all tests with umask 077 ======= 240s ### PostgreSQL test 001_packages.t ### 240s 1..22 240s ok 1 - /etc/os-release exists 240s ok 2 - OS is ubuntu 240s ok 3 - OS version is 24.10 240s # PostgreSQL versions installed: 16 241s ok 4 - postgresql-16 installed 241s ok 5 # skip No python2 support 241s ok 6 - postgresql-plpython3-16 installed 241s ok 7 - postgresql-plperl-16 installed 241s ok 8 - postgresql-pltcl-16 installed 241s ok 9 - postgresql-server-dev-16 installed 241s ok 10 # skip No postgresql-contrib-16 package for version 16 241s # postgresql-doc-16 installed 241s ok 11 - At least one doc package installed 241s ok 12 - libecpg-dev installed 241s ok 13 - procps installed 241s ok 14 - netcat-openbsd installed 241s ok 15 - hunspell-en-us installed 241s ok 16 - system has a default UTF-8 locale 241s ok 17 - locale ru_RU exists 241s ok 18 - locale ru_RU.UTF-8 exists 241s ok 19 - user postgres in the UNIX group ssl-cert 241s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 241s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 241s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 241s ### End test 001_packages.t ### 241s 241s ### PostgreSQL test 002_existing_clusters.t ### 241s 1..8 241s # Cleanup 241s ok 1 - Cleanup: No clusters left behind 241s ok 2 - No postgres processes left behind 241s ok 3 - No files in /etc/postgresql left behind 241s ok 4 - No files in /var/lib/postgresql left behind 241s ok 5 - No files in /var/run/postgresql left behind 241s ok 6 - No files in /var/log/postgresql left behind 241s ok 7 - PostgreSQL TCP ports are closed 241s ok 8 - Next free port is 5432 241s ### End test 002_existing_clusters.t ### 241s 241s ### PostgreSQL test 003_alternatives.t ### 241s 1..9 241s # Newest PG version installed is 16 241s ok 1 - psql.1.gz link group 241s ok 2 - postmaster.1.gz link group does not exist 241s ok 3 - psql.1.gz alternative 241s ok 4 - pg_dump.1.gz alternative 241s ok 5 - postgres.1.gz alternative 241s ok 6 - pg_ctl.1.gz alternative 241s # Newest PG doc version installed is 16 241s ok 7 - SPI_connect.3.gz link group 241s ok 8 - SPI_connect.3.gz alternative 241s ok 9 - SPI_exec.3.gz alternative 241s ### End test 003_alternatives.t ### 241s 241s ### PostgreSQL test 005_PgCommon.t ### 241s 1..24 241s ok 1 - correctly parsed line 'local all postgres ident sameuser' 241s ok 2 - correctly parsed line 'local foo nobody trust' 241s ok 3 - correctly parsed line 'local foo nobody crypt' 241s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 241s ok 5 - correctly parsed line 'local foo,bar nobody ident' 241s ok 6 - correctly parsed line 'local all +foogrp password' 241s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 241s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 241s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 241s ok 10 - @expected_records has correct number of entries 241s ok 11 - returned read_pg_hba array has correct number of records 241s ok 12 - line 'foo all all md5' parsed as invalid 241s ok 13 - line 'local all all foo' parsed as invalid 241s ok 14 - line 'host all all foo' parsed as invalid 241s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 241s ok 16 - line 'host all all md5' parsed as invalid 241s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 241s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 241s ok 19 - read_conf_file returns empty dict for nonexisting file 241s ok 20 - read_conf_file() parsing 241s ok 21 - read_conf_file() parsing with include directives 241s ok 22 - set_conf_value 241s ok 23 - disable_conf_value 241s ok 24 - replace_conf_value 241s ### End test 005_PgCommon.t ### 241s 241s ### PostgreSQL test 006_next_free_port.t ### 241s 1..5 241s ok 1 - next_free_port is 5432 242s ok 2 - next_free_port detects localhost ipv4 socket 243s ok 3 - next_free_port detects wildcard ipv4 socket 244s ok 4 - next_free_port detects localhost ipv6 socket 245s ok 5 - next_free_port detects wildcard ipv6 socket 245s ### End test 006_next_free_port.t ### 245s 245s ### PostgreSQL test 007_pg_conftool.t ### 245s 1..41 245s # test without cluster 245s ok 1 - pg_conftool show all 245s ok 2 - correct output of pg_conftool show all 245s ok 3 - pg_conftool foo.conf show all 245s ok 4 - correct output of pg_conftool foo.conf show all 245s ok 5 - pg_conftool /tmp/WWyXDLxtwT/different.conf show all 245s ok 6 - correct output of pg_conftool /tmp/WWyXDLxtwT/different.conf show all 245s ok 7 - pg_conftool 9.7 main show all 245s ok 8 - correct output of pg_conftool 9.7 main show all 245s # test show 245s ok 9 - pg_conftool show all 245s ok 10 - correct output of pg_conftool show all 245s ok 11 - pg_conftool other.conf show all 245s ok 12 - correct output of pg_conftool other.conf show all 245s ok 13 - pg_conftool /tmp/WWyXDLxtwT/different.conf show all 245s ok 14 - correct output of pg_conftool /tmp/WWyXDLxtwT/different.conf show all 245s ok 15 - pg_conftool 16 main show all 245s ok 16 - correct output of pg_conftool 16 main show all 245s ok 17 - pg_conftool 16 main other.conf show all 245s ok 18 - correct output of pg_conftool 16 main other.conf show all 246s ok 19 - pg_conftool show a 246s ok 20 - correct output of pg_conftool show a 246s ok 21 - pg_conftool -s show a 246s ok 22 - correct output of pg_conftool -s show a 246s # test set 246s ok 23 - pg_conftool set c 7 246s ok 24 - correct output of pg_conftool set c 7 246s ok 25 - file contains new setting 246s ok 26 - pg_conftool set a 8 246s ok 27 - correct output of pg_conftool set a 8 246s ok 28 - file contains updated setting 246s ok 29 - pg_conftool /tmp/WWyXDLxtwT/different.conf set a 9 246s ok 30 - correct output of pg_conftool /tmp/WWyXDLxtwT/different.conf set a 9 246s ok 31 - file with path contains updated setting 246s # test remove 246s ok 32 - pg_conftool remove a 246s ok 33 - correct output of pg_conftool remove a 246s ok 34 - setting removed from file 246s ok 35 - pg_conftool /tmp/WWyXDLxtwT/different.conf remove a 246s ok 36 - correct output of pg_conftool /tmp/WWyXDLxtwT/different.conf remove a 246s ok 37 - setting removed from file with path 246s # test edit 246s ok 38 - pg_conftool edit 246s ok 39 - correct output of pg_conftool edit 246s ok 40 - pg_conftool /tmp/WWyXDLxtwT/different.conf edit 246s ok 41 - correct output of pg_conftool /tmp/WWyXDLxtwT/different.conf edit 246s ### End test 007_pg_conftool.t ### 246s 246s ### PostgreSQL test 010_defaultport_cluster.t ### 246s 1..14 246s ok 1 - psql --version 246s ok 2 - pg_wrapper selects highest available version number 246s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 246s ok 4 - connecting to localhost fails with no clusters 246s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 246s ok 6 - pg_wrapper uses host and port from PGCLUSTER 246s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 246s ok 8 - pg_wrapper uses --cluster from the command line 246s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 246s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 246s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 246s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 246s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 246s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 246s ### End test 010_defaultport_cluster.t ### 246s 246s ### PostgreSQL test 015_start_stop.t ### 246s 1..71 246s # We are running systemd 246s # Running tests for 16 246s # Cluster does not exist yet 246s ok 1 - cluster 16 main does not exist 246s ok 2 - service postgresql@16-main does not exist 246s ok 3 - systemctl start postgresql 246s ok 4 - cluster 16 main does not exist 246s ok 5 - service postgresql@16-main does not exist 246s ok 6 - systemctl start postgresql@16-main 246s ok 7 - cluster 16 main does not exist 246s ok 8 - service postgresql@16-main does not exist 246s # Start/stop postgresql using system tools 247s ok 9 - pg_createcluster 16 main 248s ok 10 - cluster 16 main is stopped 248s ok 11 - service postgresql@16-main is stopped 250s ok 12 - systemctl start postgresql 250s ok 13 - cluster 16 main is running 250s ok 14 - service postgresql@16-main is running 250s ok 15 - systemctl start postgresql 250s ok 16 - cluster 16 main is already running 250s ok 17 - service postgresql@16-main is already running 250s ok 18 - systemctl stop postgresql 256s ok 19 - cluster 16 main is stopped 256s ok 20 - service postgresql@16-main is stopped 256s ok 21 - systemctl stop postgresql 256s ok 22 - cluster 16 main is already stopped 256s ok 23 - service postgresql@16-main is already stopped 256s # Start/stop specific cluster using system tools 258s ok 24 - systemctl start postgresql@16-main 258s ok 25 - cluster 16 main is running 258s ok 26 - service postgresql@16-main is running 258s ok 27 - systemctl start postgresql@16-main 258s ok 28 - cluster 16 main is running 258s ok 29 - service postgresql@16-main is running 261s ok 30 - systemctl restart postgresql@16-main 261s ok 31 - cluster 16 main is running 261s ok 32 - service postgresql@16-main is running 261s ok 33 - systemctl stop postgresql@16-main 261s ok 34 - cluster 16 main is stopped 261s ok 35 - service postgresql@16-main is stopped 261s ok 36 - systemctl stop postgresql@16-main 261s ok 37 - cluster 16 main is already stopped 261s ok 38 - service postgresql@16-main is already stopped 263s ok 39 - pg_dropcluster 16 main 263s ok 40 - cluster 16 main does not exist 263s ok 41 - service postgresql@16-main does not exist 263s # Start/stop specific cluster using pg_*cluster 263s ok 42 - pg_ctlcluster start 16 main 263s ok 43 - cluster 16 main does not exist 263s ok 44 - service postgresql@16-main does not exist 266s ok 45 - pg_createcluster 16 main --start 266s ok 46 - cluster 16 main is running 266s ok 47 - service postgresql@16-main is running 266s ok 48 - pg_ctlcluster 16 main start 266s ok 49 - cluster 16 main is already running 266s ok 50 - service postgresql@16-main is already running 269s ok 51 - pg_ctlcluster 16-main restart 269s ok 52 - cluster 16 main is running 269s ok 53 - service postgresql@16-main is running 269s ok 54 - pg_ctlcluster 16 main stop 269s ok 55 - cluster 16 main is stopped 269s ok 56 - service postgresql@16-main is stopped 269s ok 57 - pg_ctlcluster 16 main stop 269s ok 58 - cluster 16 main is already stopped 269s ok 59 - service postgresql@16-main is already stopped 271s ok 60 - pg_ctlcluster start 16-main 271s ok 61 - cluster 16 main is running 271s ok 62 - service postgresql@16-main is running 273s ok 63 - pg_dropcluster 16 main --stop 273s # Cleanup 273s ok 64 - Cleanup: No clusters left behind 273s ok 65 - No postgres processes left behind 273s ok 66 - No files in /etc/postgresql left behind 273s ok 67 - No files in /var/lib/postgresql left behind 273s ok 68 - No files in /var/run/postgresql left behind 273s ok 69 - No files in /var/log/postgresql left behind 273s ok 70 - PostgreSQL TCP ports are closed 273s ok 71 - Next free port is 5432 273s ### End test 015_start_stop.t ### 273s 273s ### PostgreSQL test 020_create_sql_remove.t ### 273s 1..147 273s # Running tests for 16 277s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.hwWUI6 277s ok 2 - pg_createcluster 16 main 277s ok 3 - Socket and pid file are in /var/run/postgresql/ 277s ok 4 - xlog/wal directory /tmp/16.xlog.hwWUI6 was created 277s ok 5 - local method in pg_hba.conf is peer 277s ok 6 - host method in pg_hba.conf is scram-sha-256 277s ok 7 - Exactly one postgres master process running 279s ok 8 - pg_ctlcluster 16 main restart 279s ok 9 - cluster restarts with new environment file 279s ok 10 - Exactly one postgres master process running 279s ok 11 - correct value of PGEXTRAVAR1 in environment 279s ok 12 - correct value of PGEXTRAVAR2 in environment 279s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 279s ok 14 - createdb --version 279s ok 15 - pg_wrapper+createdb selects version number of cluster 279s ok 16 - psql --version 279s ok 17 - pg_wrapper+psql selects version 16 279s ok 18 - pg_lscluster reports online cluster on port 5432 279s ok 19 - log file is actually used 279s ok 20 - /etc/postgresql is owned by user "postgres" 279s ok 21 - version configuration directory file is owned by user "postgres" 279s ok 22 - configuration directory file is owned by user "postgres" 279s ok 23 - version data directory file is owned by user "postgres" 279s ok 24 - data directory file is owned by user "postgres" 279s ok 25 - log file has 0640 permissions 279s ok 26 - log file is owned by user "postgres" 279s ok 27 - log file is owned by group "adm" 279s ok 28 - no log symlink by default 279s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 279s ok 30 - pg_lsclusters -h 279s ok 31 - correct output of pg_lsclusters -h 280s ok 32 - stopping cluster 282s ok 33 - restarting cluster with nondefault log symlink 282s ok 34 - log target is used as log file 282s ok 35 - default log is not used 282s ok 36 - pg_lsclusters -h 282s ok 37 - correct output of pg_lsclusters -h 282s ok 38 - stopping cluster 285s ok 39 - restarting cluster with explicitly configured log file 285s ok 40 - default log is not used 285s ok 41 - log symlink target is used for startup message 285s ok 42 - exactly one log file 285s ok 43 - custom log is actually used 285s ok 44 - pg_lsclusters -h 285s ok 45 - correct output of pg_lsclusters -h 285s ok 46 - stopping cluster 285s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 285s ok 48 - /etc/postgres-hack was not created 288s ok 49 - restarting cluster 288s ok 50 - ps -o tty -U postgres h 288s ok 51 - postgres processes do not have an associated terminal 288s ok 52 - Server is linked with SSL support 288s ok 53 - SSL is enabled in postgresql.conf 288s ok 54 - psql -l fails for nobody 288s ok 55 - createuser nobody 288s ok 56 - createdb nobodydb 288s ok 57 - psql -ltA succeeds for nobody 288s ok 58 - psql -ltA output 288s ok 59 - SQL command: create table 288s ok 60 - SQL command: insert into table values 288s ok 61 - SQL command: insert into table values 288s ok 62 - primary key violation 288s ok 63 - psql -tAc "select * from phone order by name" nobodydb 288s ok 64 - SQL command output: select -tA 288s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 288s ok 66 - SQL command output: select -tx 288s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 288s ok 68 - SQL command output: select -tAx 288s ok 69 - CREATE EXTENSION plperlu fails for user nobody 288s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 288s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 288s ok 72 - creating PL/PerlU function as user nobody fails 288s ok 73 - creating unsafe PL/Perl function as user postgres fails 288s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 288s ok 75 - creating PL/PerlU function as user postgres succeeds 288s ok 76 - psql nobodydb -Atc "select read_file()" 288s ok 77 - calling PL/PerlU function 289s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 289s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 289s ok 80 - creating unsafe PL/Perl function as user nobody fails 289s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 289s ok 82 - creating PL/Perl function as user nobody succeeds 289s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 289s ok 84 - calling PL/Perl function 289s ok 85 # skip No python2 support 289s ok 86 # skip No python2 support 289s ok 87 # skip No python2 support 289s ok 88 # skip No python2 support 289s ok 89 # skip No python2 support 289s ok 90 # skip No python2 support 289s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 289s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 289s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 289s ok 94 - creating PL/Python3 function as user postgres succeeds 289s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 289s ok 96 - calling PL/Python function 289s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 289s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 289s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 289s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 289s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 289s ok 102 - creating PL/Tcl function as user nobody succeeds 289s 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;" 289s ok 104 - creating PL/TclU function as user postgres succeeds 289s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 289s ok 106 - calling PL/Tcl function 289s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 289s ok 108 - calling PL/TclU function 289s ok 109 - stopping cluster 289s ok 110 - pg_ctlcluster 16 main start 289s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 292s ok 112 - pg_ctlcluster 16 main start 292s ok 113 - cluster restarts with pgdata symlink 292s ok 114 - postgres master has OOM killer protection 292s ok 115 - postgres client backend has no OOM adjustment 292s ok 116 - ps h 6812 292s ok 117 - process title is idle 293s ok 118 - ps h 6812 293s ok 119 - process title is idle in transaction 293s ok 120 - stopping cluster 295s ok 121 - starting cluster as postgres works without a log file 295s ok 122 - log file got recreated and used 295s ok 123 - creating a directory in spc2 295s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.9gzxhk'" 295s ok 125 - creating tablespace spc1 295s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 295s ok 127 - creating a table in spc1 295s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.MOS2tX'" 295s ok 129 - creating tablespace spc2 295s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 295s ok 131 - creating a table in spc2 295s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 295s ok 133 - Correct apt NeverAutoRemove config 297s ok 134 - pg_dropcluster removes cluster 297s ok 135 - xlog/wal directory /tmp/16.xlog.hwWUI6 was deleted 297s ok 136 - tablespace spc1 was emptied 297s ok 137 - tablespace spc2 was emptied 297s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 297s ok 139 - Correct apt NeverAutoRemove config 297s # Cleanup 297s ok 140 - Cleanup: No clusters left behind 297s ok 141 - No postgres processes left behind 297s ok 142 - No files in /etc/postgresql left behind 297s ok 143 - No files in /var/lib/postgresql left behind 297s ok 144 - No files in /var/run/postgresql left behind 297s ok 145 - No files in /var/log/postgresql left behind 297s ok 146 - PostgreSQL TCP ports are closed 297s ok 147 - Next free port is 5432 297s ### End test 020_create_sql_remove.t ### 297s 297s ### PostgreSQL test 021_pg_renamecluster.t ### 297s 1..20 301s ok 1 - pg_createcluster 16 main 303s ok 2 - pg_renamecluster 16 main donau 303s ok 3 - psql -tAc "show data_directory" 303s ok 4 - cluster is running and data_directory was moved 303s ok 5 - pg_hba.conf location updated 303s ok 6 - pg_ident.conf location updated 304s ok 7 - external_pid_file location updated 304s ok 8 - external_pid_file exists 304s ok 9 # skip no stats_temp_directory in 16 304s ok 10 # skip no stats_temp_directory in 16 304s ok 11 - cluster_name is updated 305s ok 12 - pg_dropcluster removes cluster 305s # Cleanup 305s ok 13 - Cleanup: No clusters left behind 305s ok 14 - No postgres processes left behind 305s ok 15 - No files in /etc/postgresql left behind 305s ok 16 - No files in /var/lib/postgresql left behind 305s ok 17 - No files in /var/run/postgresql left behind 305s ok 18 - No files in /var/log/postgresql left behind 305s ok 19 - PostgreSQL TCP ports are closed 305s ok 20 - Next free port is 5432 305s ### End test 021_pg_renamecluster.t ### 305s 305s ### PostgreSQL test 022_recovery.t ### 305s 1..17 305s # Running tests for 16 309s ok 1 - pg_createcluster 16 main --start >/dev/null 309s ok 2 - pg_ctlcluster 16 main stop -m i 311s ok 3 - pg_ctlcluster 16 main start 311s ok 4 - psql -c '' 312s ok 5 - pg_ctlcluster 16 main stop -m i 312s ok 6 - create write-protected file in data directory 314s ok 7 - pg_ctlcluster 16 main start 314s ok 8 - psql -c '' 316s ok 9 - pg_dropcluster removes cluster 316s # Cleanup 316s ok 10 - Cleanup: No clusters left behind 316s ok 11 - No postgres processes left behind 316s ok 12 - No files in /etc/postgresql left behind 316s ok 13 - No files in /var/lib/postgresql left behind 316s ok 14 - No files in /var/run/postgresql left behind 316s ok 15 - No files in /var/log/postgresql left behind 316s ok 16 - PostgreSQL TCP ports are closed 316s ok 17 - Next free port is 5432 316s ### End test 022_recovery.t ### 316s 316s ### PostgreSQL test 025_logging.t ### 316s 1..55 316s # Logging to /var/log/syslog works 316s # Running tests for 16 320s ok 1 - pg_createcluster 16 main 320s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 320s ok 3 - psql -qc "'foobar_16_7980'" 320s ok 4 - log an error 320s ok 5 - grep --binary-files=text foobar_16_7980 /var/log/postgresql/postgresql-16-main.log 320s ok 6 - error appears in logfile 320s ok 7 - pg_conftool 16 main set log_destination syslog 320s ok 8 - set log_destination syslog 320s ok 9 - pg_ctlcluster 16 main reload 320s ok 10 - 16 main reload 321s ok 11 - psql -Atc "show log_destination" 321s ok 12 - log_destination is syslog 321s ok 13 - pg_lscluster reports syslog 321s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 321s ok 15 - error appears in /var/log/syslog 321s ok 16 - pg_conftool 16 main set logging_collector on 321s ok 17 - set logging_collector on 321s ok 18 - pg_conftool 16 main set log_destination csvlog 321s ok 19 - set log_destination csvlog 324s ok 20 - pg_ctlcluster 16 main restart 324s ok 21 - 16 main restart 324s ok 22 - psql -Atc "show logging_collector" 324s ok 23 - logging_collector is on 324s ok 24 - psql -Atc "show log_destination" 324s ok 25 - log_destination is csvlog 324s ok 26 - pg_lscluster reports csvlog 324s ok 27 - psql -qc "'barbaz_16_7980'" 324s ok 28 - log an error 324s ok 29 - grep --binary-files=text barbaz_16_7980 /var/lib/postgresql/16/main/log/*.csv 324s ok 30 - error appears in log/*.csv 324s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 324s ok 32 - set log_destination stderr,syslog,csvlog 324s ok 33 - pg_ctlcluster 16 main reload 324s ok 34 - 16 main reload 325s ok 35 - psql -Atc "show log_destination" 325s ok 36 - log_destination is stderr,syslog,csvlog 325s ok 37 - pg_lscluster reports stderr,syslog,csvlog 325s ok 38 - psql -qc "'moo_16_7980'" 325s ok 39 - log an error 325s ok 40 - grep --binary-files=text moo_16_7980 /var/lib/postgresql/16/main/log/*.log 325s ok 41 - error appears in log/*.log 326s ok 42 - grep --binary-files=text 'postgres.*moo_16_7980' /var/log/syslog 326s ok 43 - error appears in /var/log/syslog 326s ok 44 - grep --binary-files=text moo_16_7980 /var/lib/postgresql/16/main/log/*.csv 326s ok 45 - error appears in log/*.csv 328s ok 46 - pg_dropcluster 16 main --stop 328s ok 47 - pg_dropcluster removes cluster 328s # Cleanup 328s ok 48 - Cleanup: No clusters left behind 328s ok 49 - No postgres processes left behind 328s ok 50 - No files in /etc/postgresql left behind 328s ok 51 - No files in /var/lib/postgresql left behind 328s ok 52 - No files in /var/run/postgresql left behind 328s ok 53 - No files in /var/log/postgresql left behind 328s ok 54 - PostgreSQL TCP ports are closed 328s ok 55 - Next free port is 5432 328s ### End test 025_logging.t ### 328s 328s ### PostgreSQL test 027_jit.t ### 328s # 16 331s ok 1 - pg_createcluster 16 main --start 331s ok 2 - psql -Xatc 'show jit' 331s ok 3 - JIT is on by default 331s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 331s ok 5 - No JIT on cheap query 331s ok 6 - pg_conftool 16 main set seq_page_cost 100000 331s ok 7 - pg_conftool 16 main set random_page_cost 100000 331s ok 8 - pg_ctlcluster 16 main reload 332s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 332s ok 10 - Expensive query is JITed 334s ok 11 - pg_dropcluster --stop 16 main 334s # Cleanup 334s ok 12 - Cleanup: No clusters left behind 334s ok 13 - No postgres processes left behind 334s ok 14 - No files in /etc/postgresql left behind 334s ok 15 - No files in /var/lib/postgresql left behind 334s ok 16 - No files in /var/run/postgresql left behind 334s ok 17 - No files in /var/log/postgresql left behind 334s ok 18 - PostgreSQL TCP ports are closed 334s ok 19 - Next free port is 5432 334s 1..19 334s ### End test 027_jit.t ### 334s 334s ### PostgreSQL test 030_errors.t ### 334s 1..156 334s ok 1 - pg_lscluster reports cluster without binaries 335s ok 2 - pg_dropcluster 6.3 main 337s ok 3 - pg_createcluster --socketdir 337s ok 4 - pg_lsclusters -h 337s ok 5 - cluster was created 337s ok 6 - Port of created cluster is 5432 337s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 337s ok 8 - pg_createcluster on existing cluster 337s ok 9 - pg_lsclusters -h 337s ok 10 - original cluster still exists 337s ok 11 - pg_createcluster 16 test -p foo 337s ok 12 - pg_createcluster -p checks that port option is numeric 337s ok 13 - pg_createcluster 16 test -p 42 337s ok 14 - pg_createcluster -p checks valid port range 337s ok 15 - pg_ctlcluster 16 main start 337s ok 16 - pg_ctlcluster refuses to start root-owned cluster 337s ok 17 - pg_ctlcluster 16 main start 337s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 337s ok 19 - pg_ctlcluster 16 main start 337s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 337s ok 21 - pg_ctlcluster 16 main start 337s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 339s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 339s ok 24 - No sockets in /var/run/postgresql 339s ok 25 - Socket is in /tmp/postgresql-testsuite/ 339s ok 26 - cluster stops with custom unix_socket_dir 339s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 342s ok 28 - cluster starts after removing unix_socket_dir 342s ok 29 - Socket is in default dir /var/run/postgresql 342s ok 30 - No sockets in /tmp/postgresql-testsuite/ 342s ok 31 - pg_ctlcluster 16 main stop 342s ok 32 - pg_ctlcluster fails with corrupted PID file 342s ok 33 - pg_lsclusters -h 342s ok 34 - cluster is still online 342s ok 35 - pg_ctlcluster succeeds with restored PID file 342s ok 36 - pg_lsclusters -h 342s ok 37 - cluster is down 342s ok 38 - pg_ctlcluster 16 main stop 342s ok 39 - pg_ctlcluster stop fails on stopped cluster 344s ok 40 - pg_ctlcluster 16 main start 344s ok 41 - pg_ctlcluster succeeds with already existing PID file 344s ok 42 - pg_lsclusters -h 344s ok 43 - cluster is online 345s ok 44 - pg_ctlcluster stop succeeds 345s ok 45 - pg_lsclusters -h 345s ok 46 - cluster is down 345s ok 47 - no pid file left 345s ok 48 - pg_ctlcluster 16 main stop 345s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 345s ok 50 - pid file was cleaned up 345s ok 51 - pg_ctlcluster --force 16 main stop 345s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 345s ok 53 - pid file was cleaned up 345s ok 54 - pg_ctlcluster 16 main stop 345s ok 55 - pg_ctlcluster stop succeeds with stale PID file 345s ok 56 - pid file was cleaned up 345s ok 57 - pg_ctlcluster --force 16 main stop 345s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 345s ok 59 - pid file was cleaned up 345s ok 60 - pg_ctlcluster --force 16 main stop 345s ok 61 - pg_ctlcluster stop succeeds with empty PID file 345s ok 62 - pid file was cleaned up 347s ok 63 - pg_ctlcluster 16 main start 347s ok 64 - pg_ctlcluster succeeds with corrupted PID file 347s ok 65 - pg_lsclusters -h 347s ok 66 - cluster is online 347s ok 67 - pg_ctlcluster 16 main start 347s ok 68 - pg_ctlcluster start fails on running cluster 347s ok 69 - pg_ctlcluster stop 348s ok 70 - pg_ctlcluster 16 main start 348s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 348s ok 72 - pg_ctlcluster 16 main stop 348s ok 73 - stopping cluster 354s ok 74 - pg_ctlcluster 16 main start 354s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 354s ok 76 - pg_ctlcluster 16 main stop 354s ok 77 - stopping cluster 354s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 354s ok 79 - pg_dropcluster 16 main 354s ok 80 - pg_dropcluster works as user postgres 355s ok 81 - pg_createcluster succeeds 355s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 355s ok 83 - proper error message for nonexisting /var/lib/postgresql 358s ok 84 - pg_ctlcluster 16 main start 358s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 358s ok 86 - pg_ctlcluster 16 main stop 358s ok 87 - stopping cluster 359s ok 88 - pg_createcluster other 361s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 363s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 363s ok 91 364s ok 92 - pg_ctlcluster 16 other start 364s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 364s ok 94 - pg_ctlcluster 16 main stop 364s ok 95 - stopping main cluster 366s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 368s ok 97 - pg_dropcluster other 369s ok 98 - pg_dropcluster 369s ok 99 - No sockets any more 369s ok 100 - 'pg_lsclusters 4.5 foo' fails 369s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 369s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 369s ok 103 - 'psql --cluster 4.5/foo' fails 369s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 369s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 369s ok 106 - 'psql --cluster 16/foo' fails 369s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 369s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 369s ok 109 - 'pg_dropcluster 4.5 foo' fails 369s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 369s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 369s ok 112 - 'pg_dropcluster 16 foo' fails 369s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 369s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 369s ok 115 - 'pg_upgradecluster 4.5 foo' fails 369s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 369s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 370s ok 118 - 'pg_upgradecluster 16 foo' fails 370s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 370s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 370s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 370s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 370s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 370s ok 124 - 'pg_ctlcluster 16 foo stop' fails 370s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 370s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 370s # Cleanup 370s ok 127 - Cleanup: No clusters left behind 370s ok 128 - No postgres processes left behind 370s ok 129 - No files in /etc/postgresql left behind 370s ok 130 - No files in /var/lib/postgresql left behind 370s ok 131 - No files in /var/run/postgresql left behind 370s ok 132 - No files in /var/log/postgresql left behind 370s ok 133 - PostgreSQL TCP ports are closed 370s ok 134 - Next free port is 5432 371s ok 135 - pg_dropcluster 16 broken 371s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 371s # Cleanup 371s ok 137 - Cleanup: No clusters left behind 371s ok 138 - No postgres processes left behind 371s ok 139 - No files in /etc/postgresql left behind 371s ok 140 - No files in /var/lib/postgresql left behind 371s ok 141 - No files in /var/run/postgresql left behind 371s ok 142 - No files in /var/log/postgresql left behind 371s ok 143 - PostgreSQL TCP ports are closed 371s ok 144 - Next free port is 5432 373s ok 145 - pg_dropcluster 16 broken 373s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 373s ok 147 - /etc/postgresql/16 was removed 373s ok 148 - /var/lib/postgresql/16 was removed 373s # Cleanup 373s ok 149 - Cleanup: No clusters left behind 373s ok 150 - No postgres processes left behind 373s ok 151 - No files in /etc/postgresql left behind 373s ok 152 - No files in /var/lib/postgresql left behind 373s ok 153 - No files in /var/run/postgresql left behind 373s ok 154 - No files in /var/log/postgresql left behind 373s ok 155 - PostgreSQL TCP ports are closed 373s ok 156 - Next free port is 5432 373s ### End test 030_errors.t ### 373s 373s ### PostgreSQL test 031_errors_disk_full.t ### 373s 1..22 373s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 375s ok 1 - script failed 375s ok 2 - pg_createcluster fails due to insufficient disk space 375s ok 3 - does not leave files behind 375s # Cleanup 375s ok 4 - Cleanup: No clusters left behind 375s ok 5 - No postgres processes left behind 375s ok 6 - No files in /etc/postgresql left behind 375s ok 7 - No files in /var/lib/postgresql left behind 375s ok 8 - No files in /var/run/postgresql left behind 375s ok 9 - No files in /var/log/postgresql left behind 375s ok 10 - PostgreSQL TCP ports are closed 375s ok 11 - Next free port is 5432 375s # check disk full conditions on startup 378s ok 12 - script failed 378s ok 13 - pg_ctlcluster prints error message 378s ok 14 - log file has error message 378s # Cleanup 378s ok 15 - Cleanup: No clusters left behind 378s ok 16 - No postgres processes left behind 378s ok 17 - No files in /etc/postgresql left behind 378s ok 18 - No files in /var/lib/postgresql left behind 378s ok 19 - No files in /var/run/postgresql left behind 378s ok 20 - No files in /var/log/postgresql left behind 378s ok 21 - PostgreSQL TCP ports are closed 378s ok 22 - Next free port is 5432 378s ### End test 031_errors_disk_full.t ### 378s 378s ### PostgreSQL test 032_ssl_key_permissions.t ### 378s 1..22 378s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 378s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 378s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 378s # 16 (16.3-1) 379s ok 4 - pg_createcluster 16 main 379s ok 5 - pg_ctlcluster 16 main start 379s ok 6 - ssl key owned by nobody refused 379s ok 7 - pg_ctlcluster 16 main start 379s ok 8 - ssl key with permissions root:root 0644 refused 379s ok 9 - pg_ctlcluster 16 main start 379s ok 10 - ssl key with permissions postgres:postgres 0640 refused 381s ok 11 - pg_dropcluster 16 main --stop 381s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 381s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 381s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 381s # Cleanup 381s ok 15 - Cleanup: No clusters left behind 381s ok 16 - No postgres processes left behind 381s ok 17 - No files in /etc/postgresql left behind 381s ok 18 - No files in /var/lib/postgresql left behind 381s ok 19 - No files in /var/run/postgresql left behind 381s ok 20 - No files in /var/log/postgresql left behind 381s ok 21 - PostgreSQL TCP ports are closed 381s ok 22 - Next free port is 5432 381s ### End test 032_ssl_key_permissions.t ### 381s 381s ### PostgreSQL test 040_upgrade.t ### 381s 1..1 381s ok 1 - only one major version installed, skipping upgrade tests 381s ### End test 040_upgrade.t ### 381s 381s ### PostgreSQL test 041_upgrade_custompaths.t ### 381s 1..1 381s ok 1 - only one major version installed, skipping upgrade tests 381s ### End test 041_upgrade_custompaths.t ### 381s 381s ### PostgreSQL test 042_upgrade_rename.t ### 381s 1..15 381s # PostgreSQL 16 385s ok 1 - pg_createcluster 16 main --start 391s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 391s ok 3 - pg_lsclusters -h 391s ok 4 - correct output of pg_lsclusters -h 393s ok 5 - pg_dropcluster 16 main --stop 394s ok 6 - pg_dropcluster 16 upgr --stop 394s ok 7 - Cleaning pg_upgrade log files 394s # Cleanup 395s ok 8 - Cleanup: No clusters left behind 395s ok 9 - No postgres processes left behind 395s ok 10 - No files in /etc/postgresql left behind 395s ok 11 - No files in /var/lib/postgresql left behind 395s ok 12 - No files in /var/run/postgresql left behind 395s ok 13 - No files in /var/log/postgresql left behind 395s ok 14 - PostgreSQL TCP ports are closed 395s ok 15 - Next free port is 5432 395s ### End test 042_upgrade_rename.t ### 395s 395s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 395s 1..1 395s ok 1 - only one major version installed, skipping upgrade tests 395s ### End test 043_upgrade_ssl_cert.t ### 395s 395s ### PostgreSQL test 045_backup.t ### 395s # We are running systemd 395s # PostgreSQL 16 395s # create cluster 398s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 398s ok 2 - pg_lsclusters -h 398s ok 3 - correct output of pg_lsclusters -h 398s ok 4 - pg_conftool 16 main set work_mem 11MB 398s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 398s ok 6 - psql -c 'alter database mydb set search_path=public' 398s ok 7 - psql -c 'create table foo (t text)' mydb 398s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 399s ok 9 - psql -c 'CREATE USER myuser' 399s ok 10 - psql -c 'grant create on database mydb to myuser' 399s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 399s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 399s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 399s # create directory 399s ok 14 - pg_backupcluster 16 main createdirectory 399s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 399s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 399s # dump 399s ok 17 - systemctl start pg_dump@16-main 399s ok 18 - dump created in /var/backups/postgresql/16-main/2024-06-25T083320Z.dump 399s ok 19 - /var/backups/postgresql/16-main/2024-06-25T083320Z.dump owned by uid postgres 399s ok 20 - /var/backups/postgresql/16-main/2024-06-25T083320Z.dump owned by gid postgres 399s # basebackup 400s ok 21 - systemctl start pg_receivewal@16-main 400s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 400s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 400s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 400s ok 25 - psql -c 'select pg_reload_conf()' 428s ok 26 - systemctl start pg_basebackup@16-main 428s ok 27 - dump created in /var/backups/postgresql/16-main/2024-06-25T083321Z.backup 428s ok 28 - /var/backups/postgresql/16-main/2024-06-25T083321Z.backup owned by uid postgres 428s ok 29 - /var/backups/postgresql/16-main/2024-06-25T083321Z.backup owned by gid postgres 428s # list 428s ok 30 - pg_backupcluster 16 main list 428s ok 31 - correct output of pg_backupcluster 16 main list 428s # more database changes 428s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 428s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 428s ok 34 - retrieve recovery timestamp 428s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 428s ok 36 - systemctl stop pg_receivewal@16-main 428s # restore /var/backups/postgresql/16-main/2024-06-25T083320Z.dump 430s ok 37 - pg_dropcluster 16 main --stop 434s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083320Z.dump --start --datadir /var/lib/postgresql/16/snowflake 435s ok 39 - pg_lsclusters -h 435s ok 40 - correct output of pg_lsclusters -h 435s ok 41 - psql -XAtl 435s ok 42 - mydb locales 435s ok 43 - mydb grants 435s ok 44 - myicudb locales 435s ok 45 - psql -XAtc 'show work_mem' 435s ok 46 - correct output of psql -XAtc 'show work_mem' 435s ok 47 - psql -XAtc 'select * from foo' mydb 435s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 435s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 435s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 435s ok 51 - psql -XAtc '\drds' 435s ok 52 - correct output of psql -XAtc '\drds' 435s # restore /var/backups/postgresql/16-main/2024-06-25T083321Z.backup 437s ok 53 - pg_dropcluster 16 main --stop 440s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083321Z.backup --start --datadir /var/lib/postgresql/16/snowflake 440s ok 55 - pg_lsclusters -h 440s ok 56 - correct output of pg_lsclusters -h 440s ok 57 - psql -XAtl 440s ok 58 - mydb locales 440s ok 59 - mydb grants 440s ok 60 - myicudb locales 440s ok 61 - psql -XAtc 'show work_mem' 440s ok 62 - correct output of psql -XAtc 'show work_mem' 440s ok 63 - psql -XAtc 'select * from foo' mydb 440s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 440s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 440s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 440s ok 67 - psql -XAtc '\drds' 440s ok 68 - correct output of psql -XAtc '\drds' 440s # restore /var/backups/postgresql/16-main/2024-06-25T083321Z.backup with WAL archive 442s ok 69 - pg_dropcluster 16 main --stop 446s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083321Z.backup --start --archive --port 5430 446s ok 71 - pg_lsclusters -h 446s ok 72 - correct output of pg_lsclusters -h 446s ok 73 - psql -XAtc 'select * from foo order by t' mydb 446s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 446s # restore /var/backups/postgresql/16-main/2024-06-25T083321Z.backup with PITR 448s ok 75 - pg_dropcluster 16 main --stop 451s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-25T083321Z.backup --start --pitr '2024-06-25 08:33:49.270045+00 451s # ' 451s ok 77 - pg_lsclusters -h 451s ok 78 - correct output of pg_lsclusters -h 451s ok 79 - psql -XAtc 'select * from foo order by t' mydb 451s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 453s ok 81 - pg_dropcluster 16 main --stop 453s # Cleanup 453s ok 82 - Cleanup: No clusters left behind 453s ok 83 - No postgres processes left behind 453s ok 84 - No files in /etc/postgresql left behind 453s ok 85 - No files in /var/lib/postgresql left behind 453s ok 86 - No files in /var/run/postgresql left behind 453s ok 87 - No files in /var/log/postgresql left behind 453s ok 88 - PostgreSQL TCP ports are closed 453s ok 89 - Next free port is 5432 453s 1..89 453s ### End test 045_backup.t ### 453s 453s ### PostgreSQL test 050_encodings.t ### 453s 1..60 453s # Checking 16 ru_RU 456s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 457s ok 2 - psql -l succeeds 457s ok 3 - template1 is not UTF-8 encoded 458s ok 4 - creating test database 458s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 458s # create table t (x varchar); copy t from stdin" test 458s ok 6 - creating table with ISO-8859-5 characters 458s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 458s ok 8 - correct string in UTF-8 458s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 458s ok 10 - correct string in ISO-8859-5 458s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 458s # delete from t; copy t from stdin" test 458s ok 12 - creating table with UTF-8 characters 458s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 458s ok 14 - correct string in UTF-8 458s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 458s ok 16 - correct string in ISO-8859-1 458s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 458s ok 18 - Server error message has correct language and encoding 460s ok 19 - pg_ctlcluster 16 ru_RU restart 460s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 462s ok 21 - Dropping cluster 462s # Checking 16 ru_RU.UTF-8 466s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 467s ok 23 - psql -l succeeds 467s ok 24 - template1 is UTF-8 encoded 467s ok 25 - creating test database 467s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 467s # create table t (x varchar); copy t from stdin" test 467s ok 27 - creating table with ISO-8859-5 characters 467s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 467s ok 29 - correct string in UTF-8 467s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 467s ok 31 - correct string in ISO-8859-5 467s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 467s # delete from t; copy t from stdin" test 467s ok 33 - creating table with UTF-8 characters 467s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 467s ok 35 - correct string in UTF-8 467s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 467s ok 37 - correct string in ISO-8859-1 467s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 467s ok 39 - Server error message has correct language and encoding 470s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 470s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 470s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 470s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 470s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 470s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 470s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 470s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 472s ok 48 - Dropping cluster 472s # Check 16 locale environment variables 475s ok 49 - pg_createcluster: LC_ALL dominates LANG 475s ok 50 - psql -Atl --cluster 16/main 475s ok 51 - template1 is ASCII encoded 477s ok 52 - Dropping cluster 477s # Cleanup 477s ok 53 - Cleanup: No clusters left behind 477s ok 54 - No postgres processes left behind 477s ok 55 - No files in /etc/postgresql left behind 477s ok 56 - No files in /var/lib/postgresql left behind 477s ok 57 - No files in /var/run/postgresql left behind 477s ok 58 - No files in /var/log/postgresql left behind 477s ok 59 - PostgreSQL TCP ports are closed 477s ok 60 - Next free port is 5432 477s ### End test 050_encodings.t ### 477s 477s ### PostgreSQL test 052_upgrade_encodings.t ### 477s 1..1 477s ok 1 - only one major version installed, skipping upgrade tests 477s ### End test 052_upgrade_encodings.t ### 477s 477s ### PostgreSQL test 060_obsolete_confparams.t ### 477s ok 1 - only one major version installed, skipping upgrade tests 477s 1..1 477s ### End test 060_obsolete_confparams.t ### 477s 477s ### PostgreSQL test 070_non_postgres_clusters.t ### 477s 1..40 478s ok 1 - pg_createcluster 16 main for owner nobody 478s ok 2 - pg_ctlcluster 16 main start 478s ok 3 - start refused when config and data owners mismatch 480s ok 4 - pg_ctlcluster succeeds with owner nobody 481s ok 5 - pg_lsclusters -h 481s ok 6 - pg_lsclusters shows running cluster 481s ok 7 - postgres is running as user nobody 481s ok 8 - ls /tmp/.s.PGSQL.* 481s ok 9 - socket is in /tmp 481s ok 10 - /var/run/postgresql is empty 481s ok 11 - conf dir is owned by user 481s ok 12 - conf dir is owned by user's primary group 481s ok 13 - files are owned by user 481s ok 14 - files are owned by user's primary group 481s ok 15 - log file has 0640 permissions 481s ok 16 - log file is owned by user 481s ok 17 - log file is owned by user's primary group 481s ok 18 - only one major version installed, skipping upgrade test 481s ok 19 - ... 481s ok 20 - ... 481s ok 21 - ... 481s ok 22 - ... 481s ok 23 - ... 481s ok 24 - ... 481s ok 25 - ... 481s ok 26 - ... 481s ok 27 - ... 481s ok 28 - ... 482s ok 29 - pg_dropcluster 482s ok 30 - pg_lsclusters -h 482s ok 31 - No clusters left 482s ok 32 - No postgres processes left 482s # Cleanup 482s ok 33 - Cleanup: No clusters left behind 482s ok 34 - No postgres processes left behind 482s ok 35 - No files in /etc/postgresql left behind 482s ok 36 - No files in /var/lib/postgresql left behind 482s ok 37 - No files in /var/run/postgresql left behind 482s ok 38 - No files in /var/log/postgresql left behind 482s ok 39 - PostgreSQL TCP ports are closed 482s ok 40 - Next free port is 5432 482s ### End test 070_non_postgres_clusters.t ### 482s 482s ### PostgreSQL test 080_start.conf.t ### 482s 1..73 483s ok 1 - pg_createcluster 16 main 483s # start.conf auto 483s ok 2 - get_cluster_start_conf returns auto 483s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 483s ok 4 - start.conf contains auto 483s ok 5 - systemd generator links cluster 483s ok 6 - systemd generator links correct service file 487s ok 7 - /etc/init.d/postgresql start 16 487s ok 8 - correct output of /etc/init.d/postgresql start 16 487s ok 9 - pg_lsclusters -h 487s ok 10 - cluster is online 487s ok 11 - /etc/init.d/postgresql stop 16 487s ok 12 - correct output of /etc/init.d/postgresql stop 16 489s ok 13 - pg_lsclusters -h 489s ok 14 - cluster is down 489s # start.conf manual 489s ok 15 - get_cluster_start_conf returns manual 489s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 489s ok 17 - start.conf contains manual 489s ok 18 - systemd generator doesn't link cluster 489s ok 19 - /etc/init.d/postgresql start 16 489s ok 20 - correct output of /etc/init.d/postgresql start 16 489s ok 21 - pg_lsclusters -h 489s ok 22 - cluster is down 492s ok 23 - pg_ctlcluster 16 main start 492s ok 24 - correct output of pg_ctlcluster 16 main start 492s ok 25 - pg_lsclusters -h 492s ok 26 - cluster is online 492s ok 27 - pg_ctlcluster 16 main stop 492s ok 28 - correct output of pg_ctlcluster 16 main stop 492s ok 29 - pg_lsclusters -h 492s ok 30 - cluster is down 492s # start.conf disabled 492s ok 31 - get_cluster_start_conf returns disabled 492s ok 32 - systemd generator doesn't link cluster 492s ok 33 - /etc/init.d/postgresql start 16 492s ok 34 - correct output of /etc/init.d/postgresql start 16 492s ok 35 - pg_lsclusters -h 492s ok 36 - cluster is down 492s ok 37 - pg_ctlcluster 16 main start 492s ok 38 - correct output of pg_ctlcluster 16 main start 492s ok 39 - pg_lsclusters -h 492s ok 40 - cluster is down 494s ok 41 - pg_ctlcluster 16 main start 494s ok 42 - correct output of pg_ctlcluster 16 main start 494s ok 43 - pg_lsclusters -h 494s ok 44 - cluster is online 495s ok 45 - pg_ctlcluster 16 main stop 495s ok 46 - correct output of pg_ctlcluster 16 main stop 495s ok 47 - pg_lsclusters -h 495s ok 48 - cluster is down 497s ok 49 - pg_ctlcluster 16 main start 497s ok 50 - correct output of pg_ctlcluster 16 main start 497s ok 51 - pg_lsclusters -h 497s ok 52 - cluster is online 497s # test upgrade 497s ok 53 - only one major version installed, skipping upgrade test 497s ok 54 - ... 497s ok 55 - get_cluster_start_conf for old cluster returns manual 497s ok 56 - get_cluster_start_conf for new cluster returns manual 497s ok 57 - ... 498s ok 58 - dropping upgraded cluster 498s ok 59 - pg_lsclusters -h 498s ok 60 - no clusters any more 499s ok 61 - pg_createcluster 16 main --start-conf foo 499s ok 62 - pg_createcluster checks --start-conf validity 499s ok 63 - pg_createcluster checks --start-conf manual 499s ok 64 - get_cluster_start_conf returns manual 501s ok 65 - dropping cluster 501s # Cleanup 501s ok 66 - Cleanup: No clusters left behind 501s ok 67 - No postgres processes left behind 501s ok 68 - No files in /etc/postgresql left behind 501s ok 69 - No files in /var/lib/postgresql left behind 501s ok 70 - No files in /var/run/postgresql left behind 501s ok 71 - No files in /var/log/postgresql left behind 501s ok 72 - PostgreSQL TCP ports are closed 501s ok 73 - Next free port is 5432 501s ### End test 080_start.conf.t ### 501s 501s ### PostgreSQL test 085_pg_ctl.conf.t ### 501s 1..33 501s ok 1 - prlimit --core=0:unlimited --pid=16769 501s ok 2 - set core file size to unlimited 501s ok 3 - sh -c 'ulimit -Hc' 501s ok 4 - core file size is unlimited 502s ok 5 - pg_createcluster 16 main 502s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 504s ok 7 - pg_ctlcluster 16 main start 504s ok 8 - starting cluster as root 504s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 504s ok 10 - soft core size is 0 504s # hard core file size limit of root-started postgres process is unlimited 504s ok 11 - set pg_ctl default option to -c 507s ok 12 - pg_ctlcluster 16 main restart 507s ok 13 - restarting cluster as root 507s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 507s ok 15 - soft core size is unlimited 507s ok 16 - pg_ctlcluster 16 main stop 507s ok 17 - stopping cluster 507s ok 18 - restored pg_ctl default option 509s ok 19 - pg_ctlcluster 16 main start -- -c 509s ok 20 - starting cluster with -c on the command line as postgres 509s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 509s ok 22 - soft core size is unlimited 509s ok 23 - pg_ctlcluster 16 main stop 509s ok 24 - stopping cluster 511s ok 25 - dropping cluster 511s # Cleanup 511s ok 26 - Cleanup: No clusters left behind 511s ok 27 - No postgres processes left behind 511s ok 28 - No files in /etc/postgresql left behind 511s ok 29 - No files in /var/lib/postgresql left behind 511s ok 30 - No files in /var/run/postgresql left behind 511s ok 31 - No files in /var/log/postgresql left behind 511s ok 32 - PostgreSQL TCP ports are closed 511s ok 33 - Next free port is 5432 511s ### End test 085_pg_ctl.conf.t ### 511s 511s ### PostgreSQL test 090_multicluster.t ### 511s 1..125 512s ok 1 - pg_createcluster 16 old 513s ok 2 - pg_createcluster 16 new1 514s ok 3 - pg_createcluster 16 new2 517s ok 4 - starting cluster 16/old 519s ok 5 - starting cluster 16/new1 521s ok 6 - starting cluster 16/new2 521s ok 7 - pg_lsclusters -h | sort -k3 521s ok 8 - clusters have the correct ports, skipping used 5433 521s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 521s ok 10 - createdb --version 521s ok 11 - pg_wrapper selects port 5432 as default cluster 521s ok 12 - createdb --cluster 16/new1 --version 521s ok 13 - pg_wrapper --cluster works 521s ok 14 - createdb --cluster 16/foo --version 521s ok 15 - pg_wrapper --cluster errors out for invalid cluster 521s ok 16 - createdb --cluster 16/new1 test 521s ok 17 - correct output of createdb --cluster 16/new1 test 521s ok 18 - psql -Atl --cluster 16/new1 521s ok 19 - test db appears in cluster new1 521s ok 20 - psql -Atl --cluster 16/new2 521s ok 21 - test db does not appear in cluster new2 521s ok 22 - psql -Atl 521s ok 23 - test db does not appear in default cluster 522s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 522s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 522s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 522s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 522s ok 28 - psql -Atl --cluster 16/localhost:5434 522s ok 29 - test db appears in cluster 16/localhost:5434 522s ok 30 - psql -Atl --cluster 16/localhost:5440 522s ok 31 - test db does not appear in cluster 16/localhost:5440 522s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 522s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 522s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 522s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 522s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 522s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 522s ok 38 - psql -Atl --cluster 6.4/localhost: 522s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 522s ok 40 - psql -Atl 522s ok 41 - PGCLUSTER selection (1) 522s ok 42 - psql -Atl 522s ok 43 - PGCLUSTER selection (2) 522s ok 44 - psql -l 522s ok 45 - invalid PGCLUSTER value 522s ok 46 - createdb --version 522s ok 47 - PGCLUSTER network cluster selection (1) 522s ok 48 - psql -Atl 522s ok 49 - PGCLUSTER network cluster selection (2) 522s ok 50 - psql -Atl 522s ok 51 - PGCLUSTER network cluster selection (3) 522s ok 52 - LC_MESSAGES=C psql -Atl 522s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 522s ok 54 - psql -Atc "show port" template1 522s ok 55 - PGPORT selection (1) 522s ok 56 - psql -Atc "show port" template1 522s ok 57 - PGPORT selection (2) 522s ok 58 - createdb --version 522s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 522s ok 60 - psql -Atc "show port" template1 522s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 522s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 522s ok 63 - PGDATABASE environment variable works 522s ok 64 - createdb --version 522s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 522s ok 66 - createdb --cluster 16/new1 --version 522s ok 67 - pg_wrapper --cluster works with empty user_clusters 522s ok 68 - createdb --version 522s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 523s ok 70 - psql -Atc "select current_database()" 523s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 523s ok 72 - psql -Atc 'select current_database()' 523s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 523s ok 74 - createdb --version 523s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 523s ok 76 - createdb --version 523s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 523s ok 78 - createdb --version 523s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 523s ok 80 - createdb --version 523s ok 81 - pg_wrapper selects correct version with per-user user_clusters 523s ok 82 - createdb --version 523s ok 83 - pg_wrapper selects correct version with per-user user_clusters 523s ok 84 - createdb --version 523s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 523s ok 86 - psql -Atl 523s ok 87 - $PGHOST overrides user_clusters 523s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 523s ok 89 - --cluster overrides $PGHOST 523s ok 90 - createdb --version 523s ok 91 - pg_wrapper ignores invalid lines in user_clusters 523s ok 92 - psql -Atc 'select current_database()' 523s ok 93 - pg_service conf selection 1 523s ok 94 - psql -Atc 'select current_database()' 523s ok 95 - pg_service conf selection 2 523s ok 96 - psql -Atc 'select current_database()' 523s ok 97 - pg_service conf selection 3 523s ok 98 - stopping cluster 16/old 526s ok 99 - restarting cluster 16/old 526s ok 100 - pg_lsclusters -h | sort -k3 526s ok 101 - port of first cluster was successfully changed 526s ok 102 - psql -l 526s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 526s ok 104 - psql -Atl --cluster 16/new1 526s ok 105 - --cluster selects appropriate cluster 526s ok 106 - psql -Atl -p 5434 526s ok 107 - -p selects appropriate cluster 526s ok 108 - psql -Atlp 5434 526s ok 109 - -Atlp selects appropriate cluster 526s ok 110 - psql -Atl --port 5434 526s ok 111 - --port selects appropriate cluster 526s ok 112 - env PGPORT=5434 psql -Atl 526s ok 113 - $PGPORT selects appropriate cluster 526s ok 114 - Restoring original /etc/postgresql-common/user_clusters 528s ok 115 - dropping 16/new1 530s ok 116 - dropping 16/new2 532s ok 117 - dropping 16/old 532s # Cleanup 532s ok 118 - Cleanup: No clusters left behind 532s ok 119 - No postgres processes left behind 532s ok 120 - No files in /etc/postgresql left behind 532s ok 121 - No files in /var/lib/postgresql left behind 532s ok 122 - No files in /var/run/postgresql left behind 532s ok 123 - No files in /var/log/postgresql left behind 532s ok 124 - PostgreSQL TCP ports are closed 532s ok 125 - Next free port is 5432 532s ### End test 090_multicluster.t ### 532s 532s ### PostgreSQL test 110_integrate_cluster.t ### 532s 1..32 533s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/69vIP7dG5a/c/postgres 533s ok 2 - creating raw initdb cluster for user postgres 533s ok 3 - pg_createcluster 16 postgres -d /tmp/69vIP7dG5a/c/postgres 533s ok 4 - integrating postgres cluster 533s ok 5 - pg_lsclusters 533s ok 6 - correct pg_lsclusters output 535s ok 7 - pg_ctlcluster 16 postgres start 535s ok 8 - starting cluster postgres 535s ok 9 - pg_lsclusters 535s ok 10 - correct pg_lsclusters output 537s ok 11 - dropping cluster postgres 537s ok 12 - No files in temporary cluster dir left behind 538s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/69vIP7dG5a/c/nobody 538s ok 14 - creating raw initdb cluster for user nobody 539s ok 15 - pg_createcluster 16 nobody -d /tmp/69vIP7dG5a/c/nobody 539s ok 16 - integrating nobody cluster 539s ok 17 - pg_lsclusters 539s ok 18 - correct pg_lsclusters output 541s ok 19 - pg_ctlcluster 16 nobody start 541s ok 20 - starting cluster nobody 541s ok 21 - pg_lsclusters 541s ok 22 - correct pg_lsclusters output 543s ok 23 - dropping cluster nobody 543s ok 24 - No files in temporary cluster dir left behind 543s # Cleanup 543s ok 25 - Cleanup: No clusters left behind 543s ok 26 - No postgres processes left behind 543s ok 27 - No files in /etc/postgresql left behind 543s ok 28 - No files in /var/lib/postgresql left behind 543s ok 29 - No files in /var/run/postgresql left behind 543s ok 30 - No files in /var/log/postgresql left behind 543s ok 31 - PostgreSQL TCP ports are closed 543s ok 32 - Next free port is 5432 543s ### End test 110_integrate_cluster.t ### 543s 543s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 543s 1..1 543s ok 1 - only one major version installed, skipping upgrade tests 543s ### End test 120_pg_upgradecluster_scripts.t ### 543s 543s ### PostgreSQL test 130_nonroot_admin.t ### 543s 1..22 546s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 546s ok 2 - pg_lsclusters -h 546s ok 3 - correct output of pg_lsclusters -h 546s ok 4 - psql -Atl 546s ok 5 - correct output of psql -Atl 546s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 546s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 546s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 546s # Cleanup 546s ok 15 - Cleanup: No clusters left behind 546s ok 16 - No postgres processes left behind 546s ok 17 - No files in /etc/postgresql left behind 546s ok 18 - No files in /var/lib/postgresql left behind 546s ok 19 - No files in /var/run/postgresql left behind 546s ok 20 - No files in /var/log/postgresql left behind 546s ok 21 - PostgreSQL TCP ports are closed 546s ok 22 - Next free port is 5432 546s ### End test 130_nonroot_admin.t ### 546s 546s ### PostgreSQL test 135_pg_virtualenv.t ### 547s 1..20 552s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 552s ok 2 - running pg_virtualenv as root 555s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 555s ok 4 - running pg_virtualenv as postgres 558s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 558s ok 6 - running pg_virtualenv as nobody 562s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 562s ok 8 - running fakeroot pg_virtualenv as root 565s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 565s ok 10 - running fakeroot pg_virtualenv as postgres 568s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 568s ok 12 - running fakeroot pg_virtualenv as nobody 568s # Cleanup 569s ok 13 - Cleanup: No clusters left behind 569s ok 14 - No postgres processes left behind 569s ok 15 - No files in /etc/postgresql left behind 569s ok 16 - No files in /var/lib/postgresql left behind 569s ok 17 - No files in /var/run/postgresql left behind 569s ok 18 - No files in /var/log/postgresql left behind 569s ok 19 - PostgreSQL TCP ports are closed 569s ok 20 - Next free port is 5432 569s ### End test 135_pg_virtualenv.t ### 569s 569s ### PostgreSQL test 140_pg_config.t ### 569s 1..38 569s # Multiarch is enabled 569s # checking version specific output for 16 569s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 569s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 569s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 569s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 569s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 569s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 569s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 569s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 569s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 569s # checking pg_config output (should behave like version 16) 569s ok 15 - pg_config 569s ok 16 - correct output of pg_config 569s ok 17 - pg_config --help 569s ok 18 - correct output of pg_config --help 569s ok 19 - pg_config --pgxs 569s ok 20 - correct output of pg_config --pgxs 569s ok 21 - pg_config --libdir 569s ok 22 - correct output of pg_config --libdir 569s ok 23 - pg_config --pkglibdir 569s ok 24 - correct output of pg_config --pkglibdir 569s ok 25 - pg_config --bindir 569s ok 26 - correct output of pg_config --bindir 569s # checking pg_config.libpq-dev output (should behave like version 16) 569s ok 27 - pg_config.libpq-dev 569s ok 28 - correct output of pg_config.libpq-dev 569s ok 29 - pg_config.libpq-dev --help 569s ok 30 - correct output of pg_config.libpq-dev --help 569s ok 31 - pg_config.libpq-dev --pgxs 569s ok 32 - correct output of pg_config.libpq-dev --pgxs 569s ok 33 - pg_config.libpq-dev --libdir 569s ok 34 - correct output of pg_config.libpq-dev --libdir 569s ok 35 - pg_config.libpq-dev --pkglibdir 569s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 569s ok 37 - pg_config.libpq-dev --bindir 569s ok 38 - correct output of pg_config.libpq-dev --bindir 569s ### End test 140_pg_config.t ### 569s 569s ### PostgreSQL test 150_tsearch_stemming.t ### 569s 1..37 569s ok 1 - pg_updatedicts succeeded 569s ok 2 - pg_updatedicts created en_us.affix 569s ok 3 - pg_updatedicts created en_us.dict 569s ok 4 - pg_updatedicts created 16 en_us.affix symlink 569s ok 5 - pg_updatedicts created 16 en_us.dict symlink 573s ok 6 - pg_createcluster 16 main 573s ok 7 - createdb fts 573s ok 8 - correct output of createdb fts 573s ok 9 - creating en_US full text search configuration 573s ok 10 - creating data table and search index 573s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 573s ok 12 - stem search of correct word 573s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 573s ok 14 - stem search of correct word 573s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 573s ok 16 - stem search of unknown word 573s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 573s ok 18 - full text search, exact word 573s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 573s ok 20 - full text search for word stem 573s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 573s ok 22 - full text search for word substring fails 573s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 573s ok 24 - full text search, exact unicode word 574s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 574s ok 26 - full text search for unicode word stem 574s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 574s ok 28 - full text search for unicode word substring fails 575s ok 29 575s # Cleanup 575s ok 30 - Cleanup: No clusters left behind 575s ok 31 - No postgres processes left behind 575s ok 32 - No files in /etc/postgresql left behind 575s ok 33 - No files in /var/lib/postgresql left behind 575s ok 34 - No files in /var/run/postgresql left behind 575s ok 35 - No files in /var/log/postgresql left behind 575s ok 36 - PostgreSQL TCP ports are closed 575s ok 37 - Next free port is 5432 575s ### End test 150_tsearch_stemming.t ### 575s 575s ### PostgreSQL test 160_alternate_confroot.t ### 575s 1..28 579s ok 1 579s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 579s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 579s ok 4 - pg_lsclusters -h 579s ok 5 - correct output of pg_lsclusters -h 579s ok 6 - psql -Atl 579s ok 7 - correct output of psql -Atl 579s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 579s ok 9 - ... 579s ok 10 - ... 579s ok 11 - ... 579s ok 12 - ... 579s ok 13 - ... 579s ok 14 - ... 579s ok 15 - pg_dropcluster 16 test --stop 579s ok 16 - correct output of pg_dropcluster 16 test --stop 579s ok 17 - pg_lsclusters -h 579s ok 18 - correct output of pg_lsclusters -h 579s ok 19 - No files in root/data left behind 579s ok 20 - No cruft in root dir left behind 579s # Cleanup 579s ok 21 - Cleanup: No clusters left behind 579s ok 22 - No postgres processes left behind 579s ok 23 - No files in /etc/postgresql left behind 579s ok 24 - No files in /var/lib/postgresql left behind 579s ok 25 - No files in /var/run/postgresql left behind 579s ok 26 - No files in /var/log/postgresql left behind 579s ok 27 - PostgreSQL TCP ports are closed 579s ok 28 - Next free port is 5432 579s ### End test 160_alternate_confroot.t ### 579s 579s ### PostgreSQL test 170_extensions.t ### 579s # Running tests for 16 582s ok 1 - pg_createcluster 16 main 582s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 582s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 582s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 582s ok 5 - extension adminpack installs without error 582s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 582s ok 7 - extension adminpack removes without error 583s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 583s ok 9 - extension amcheck installs without error 583s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 583s ok 11 - extension amcheck removes without error 583s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 583s ok 13 - extension autoinc installs without error 583s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 583s ok 15 - extension autoinc removes without error 583s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 583s ok 17 - extension bloom installs without error 583s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 583s ok 19 - extension bloom removes without error 583s ok 20 - psql -qc 'CREATE EXTENSION plperl' 583s ok 21 - bool_plperl dependency plperl installs without error 583s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 583s ok 23 - extension bool_plperl installs without error 583s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 583s ok 25 - extension bool_plperl removes without error 583s ok 26 - psql -qc 'DROP EXTENSION plperl' 583s ok 27 - bool_plperl dependency extension plperl removes without error 583s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 583s ok 29 - bool_plperlu dependency plperlu installs without error 583s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 583s ok 31 - extension bool_plperlu installs without error 583s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 583s ok 33 - extension bool_plperlu removes without error 583s ok 34 - psql -qc 'DROP EXTENSION plperlu' 583s ok 35 - bool_plperlu dependency extension plperlu removes without error 583s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 583s ok 37 - extension btree_gin installs without error 583s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 583s ok 39 - extension btree_gin removes without error 583s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 583s ok 41 - extension btree_gist installs without error 583s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 583s ok 43 - extension btree_gist removes without error 583s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 583s ok 45 - extension citext installs without error 584s ok 46 - psql -qc 'DROP EXTENSION "citext"' 584s ok 47 - extension citext removes without error 584s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 584s ok 49 - extension cube installs without error 584s ok 50 - psql -qc 'DROP EXTENSION "cube"' 584s ok 51 - extension cube removes without error 584s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 584s ok 53 - extension dblink installs without error 584s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 584s ok 55 - extension dblink removes without error 584s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 584s ok 57 - extension dict_int installs without error 584s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 584s ok 59 - extension dict_int removes without error 584s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 584s ok 61 - extension dict_xsyn installs without error 584s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 584s ok 63 - extension dict_xsyn removes without error 584s ok 64 - psql -qc 'CREATE EXTENSION cube' 584s ok 65 - earthdistance dependency cube installs without error 584s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 584s ok 67 - extension earthdistance installs without error 584s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 584s ok 69 - extension earthdistance removes without error 584s ok 70 - psql -qc 'DROP EXTENSION cube' 584s ok 71 - earthdistance dependency extension cube removes without error 584s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 584s ok 73 - extension file_fdw installs without error 584s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 584s ok 75 - extension file_fdw removes without error 584s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 584s ok 77 - extension fuzzystrmatch installs without error 584s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 584s ok 79 - extension fuzzystrmatch removes without error 584s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 584s ok 81 - extension hstore installs without error 584s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 584s ok 83 - extension hstore removes without error 584s ok 84 - psql -qc 'CREATE EXTENSION hstore' 584s ok 85 - hstore_plperl dependency hstore installs without error 585s ok 86 - psql -qc 'CREATE EXTENSION plperl' 585s ok 87 - hstore_plperl dependency plperl installs without error 585s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 585s ok 89 - extension hstore_plperl installs without error 585s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 585s ok 91 - extension hstore_plperl removes without error 585s ok 92 - psql -qc 'DROP EXTENSION hstore' 585s ok 93 - hstore_plperl dependency extension hstore removes without error 585s ok 94 - psql -qc 'DROP EXTENSION plperl' 585s ok 95 - hstore_plperl dependency extension plperl removes without error 585s ok 96 - psql -qc 'CREATE EXTENSION hstore' 585s ok 97 - hstore_plperlu dependency hstore installs without error 585s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 585s ok 99 - hstore_plperlu dependency plperlu installs without error 585s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 585s ok 101 - extension hstore_plperlu installs without error 585s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 585s ok 103 - extension hstore_plperlu removes without error 585s ok 104 - psql -qc 'DROP EXTENSION hstore' 585s ok 105 - hstore_plperlu dependency extension hstore removes without error 585s ok 106 - psql -qc 'DROP EXTENSION plperlu' 585s ok 107 - hstore_plperlu dependency extension plperlu removes without error 585s ok 108 - psql -qc 'CREATE EXTENSION hstore' 585s ok 109 - hstore_plpython3u dependency hstore installs without error 585s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 585s ok 111 - hstore_plpython3u dependency plpython3u installs without error 585s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 585s ok 113 - extension hstore_plpython3u installs without error 585s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 585s ok 115 - extension hstore_plpython3u removes without error 585s ok 116 - psql -qc 'DROP EXTENSION hstore' 585s ok 117 - hstore_plpython3u dependency extension hstore removes without error 585s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 585s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 585s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 585s ok 121 - extension insert_username installs without error 585s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 585s ok 123 - extension insert_username removes without error 586s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 586s ok 125 - extension intagg installs without error 586s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 586s ok 127 - extension intagg removes without error 586s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 586s ok 129 - extension intarray installs without error 597s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 597s ok 131 - extension intarray removes without error 597s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 597s ok 133 - extension isn installs without error 597s ok 134 - psql -qc 'DROP EXTENSION "isn"' 597s ok 135 - extension isn removes without error 597s ok 136 - psql -qc 'CREATE EXTENSION plperl' 597s ok 137 - jsonb_plperl dependency plperl installs without error 597s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 597s ok 139 - extension jsonb_plperl installs without error 597s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 597s ok 141 - extension jsonb_plperl removes without error 597s ok 142 - psql -qc 'DROP EXTENSION plperl' 597s ok 143 - jsonb_plperl dependency extension plperl removes without error 597s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 597s ok 145 - jsonb_plperlu dependency plperlu installs without error 597s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 597s ok 147 - extension jsonb_plperlu installs without error 597s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 597s ok 149 - extension jsonb_plperlu removes without error 597s ok 150 - psql -qc 'DROP EXTENSION plperlu' 597s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 597s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 597s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 597s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 597s ok 155 - extension jsonb_plpython3u installs without error 597s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 597s ok 157 - extension jsonb_plpython3u removes without error 597s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 597s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 597s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 597s ok 161 - extension lo installs without error 597s ok 162 - psql -qc 'DROP EXTENSION "lo"' 597s ok 163 - extension lo removes without error 597s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 597s ok 165 - extension ltree installs without error 597s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 597s ok 167 - extension ltree removes without error 597s ok 168 - psql -qc 'CREATE EXTENSION ltree' 597s ok 169 - ltree_plpython3u dependency ltree installs without error 597s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 597s ok 171 - ltree_plpython3u dependency plpython3u installs without error 597s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 597s ok 173 - extension ltree_plpython3u installs without error 597s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 597s ok 175 - extension ltree_plpython3u removes without error 597s ok 176 - psql -qc 'DROP EXTENSION ltree' 597s ok 177 - ltree_plpython3u dependency extension ltree removes without error 597s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 597s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 597s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 597s ok 181 - extension moddatetime installs without error 597s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 597s ok 183 - extension moddatetime removes without error 597s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 597s ok 185 - extension old_snapshot installs without error 597s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 597s ok 187 - extension old_snapshot removes without error 597s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 597s ok 189 - extension pageinspect installs without error 597s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 597s ok 191 - extension pageinspect removes without error 597s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 597s ok 193 - extension pg_buffercache installs without error 597s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 597s ok 195 - extension pg_buffercache removes without error 597s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 597s ok 197 - extension pg_freespacemap installs without error 597s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 597s ok 199 - extension pg_freespacemap removes without error 597s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 597s ok 201 - extension pg_prewarm installs without error 597s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 597s ok 203 - extension pg_prewarm removes without error 597s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 597s ok 205 - extension pg_stat_statements installs without error 597s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 597s ok 207 - extension pg_stat_statements removes without error 597s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 597s ok 209 - extension pg_surgery installs without error 597s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 597s ok 211 - extension pg_surgery removes without error 597s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 597s ok 213 - extension pg_trgm installs without error 597s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 597s ok 215 - extension pg_trgm removes without error 597s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 597s ok 217 - extension pg_visibility installs without error 597s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 597s ok 219 - extension pg_visibility removes without error 597s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 597s ok 221 - extension pg_walinspect installs without error 597s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 597s ok 223 - extension pg_walinspect removes without error 597s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 597s ok 225 - extension pgcrypto installs without error 597s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 597s ok 227 - extension pgcrypto removes without error 597s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 597s ok 229 - extension pgrowlocks installs without error 597s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 597s ok 231 - extension pgrowlocks removes without error 597s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 597s ok 233 - extension pgstattuple installs without error 597s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 597s ok 235 - extension pgstattuple removes without error 597s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 597s ok 237 - extension plperl installs without error 597s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 597s ok 239 - extension plperl removes without error 597s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 597s ok 241 - extension plperlu installs without error 597s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 597s ok 243 - extension plperlu removes without error 597s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 597s ok 245 - extension plpython3u installs without error 597s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 597s ok 247 - extension plpython3u removes without error 597s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 597s ok 249 - extension pltcl installs without error 597s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 597s ok 251 - extension pltcl removes without error 597s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 597s ok 253 - extension pltclu installs without error 597s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 597s ok 255 - extension pltclu removes without error 597s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 597s ok 257 - extension postgres_fdw installs without error 597s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 597s ok 259 - extension postgres_fdw removes without error 597s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 597s ok 261 - extension refint installs without error 597s ok 262 - psql -qc 'DROP EXTENSION "refint"' 597s ok 263 - extension refint removes without error 597s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 597s ok 265 - extension seg installs without error 597s ok 266 - psql -qc 'DROP EXTENSION "seg"' 597s ok 267 - extension seg removes without error 597s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 597s ok 269 - extension sslinfo installs without error 597s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 597s ok 271 - extension sslinfo removes without error 597s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 597s ok 273 - extension tablefunc installs without error 597s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 597s ok 275 - extension tablefunc removes without error 597s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 597s ok 277 - extension tcn installs without error 597s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 597s ok 279 - extension tcn removes without error 597s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 597s ok 281 - extension tsm_system_rows installs without error 597s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 597s ok 283 - extension tsm_system_rows removes without error 597s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 597s ok 285 - extension tsm_system_time installs without error 597s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 597s ok 287 - extension tsm_system_time removes without error 597s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 597s ok 289 - extension unaccent installs without error 597s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 597s ok 291 - extension unaccent removes without error 597s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 597s ok 293 - extension uuid-ossp installs without error 597s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 597s ok 295 - extension uuid-ossp removes without error 597s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 597s ok 297 - extension xml2 installs without error 597s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 597s ok 299 - extension xml2 removes without error 597s ok 300 - pg_dropcluster 16 main 597s # Cleanup 597s ok 301 - Cleanup: No clusters left behind 597s ok 302 - No postgres processes left behind 597s ok 303 - No files in /etc/postgresql left behind 597s ok 304 - No files in /var/lib/postgresql left behind 597s ok 305 - No files in /var/run/postgresql left behind 597s ok 306 - No files in /var/log/postgresql left behind 597s ok 307 - PostgreSQL TCP ports are closed 597s ok 308 - Next free port is 5432 597s 1..308 597s ### End test 170_extensions.t ### 597s 597s ### PostgreSQL test 180_ecpg.t ### 597s 1..14 597s ok 1 - ecpg test.pgc 597s ok 2 - ecpg processing 597s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 597s ok 4 - compiling ecpg output 599s ok 5 - pg_virtualenv /tmp/tmp.7LHb7aVE3O/test 599s ok 6 - test program runs and gives correct output 599s # Cleanup 600s ok 7 - Cleanup: No clusters left behind 600s ok 8 - No postgres processes left behind 600s ok 9 - No files in /etc/postgresql left behind 600s ok 10 - No files in /var/lib/postgresql left behind 600s ok 11 - No files in /var/run/postgresql left behind 600s ok 12 - No files in /var/log/postgresql left behind 600s ok 13 - PostgreSQL TCP ports are closed 600s ok 14 - Next free port is 5432 600s ### End test 180_ecpg.t ### 600s 600s ### PostgreSQL test 190_pg_buildext.t ### 600s ok 1 - make clean 600s ok 2 - make tar 600s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 600s # testing 'dh --with pgxs' 604s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 604s ok 5 - postgresql-16-foo_123-1_amd64.deb was built 611s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 611s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 612s ok 8 - dpkg -i postgresql-16-foo_123-1_amd64.deb 619s ok 9 - cd foo-123 && pg_buildext installcheck 619s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 627s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 627s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 634s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 634s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 634s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 634s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 635s ok 17 - dpkg -r postgresql-16-foo 635s # testing 'dh --with pgxs_loop' 635s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 655s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 655s autopkgtest [08:37:30]: test run-testsuite: -----------------------] 655s ok 20 - postgresql-16-foo_123-1_amd64.deb was built 655s ok 21 - make clean 655s # testing pg_buildext updatecontrol 655s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 655s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 655s 1..23 655s ### End test 190_pg_buildext.t ### 655s 655s ### PostgreSQL test 200_maintscripts.t ### 655s 1..15 655s # We are running systemd 655s ok 1 - pg_createcluster 16 main --start 655s ok 2 - postmaster PID is 23157 655s ok 3 - apt-get update -q 655s # postgresql-common: 655s # Installed: 260 655s # Candidate: 260 655s # Version table: 655s # *** 260 990 655s # 990 http://ftpmaster.internal/ubuntu oracular/main amd64 Packages 655s # 990 http://ftpmaster.internal/ubuntu oracular/main i386 Packages 655s # 100 /var/lib/dpkg/status 655s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 655s # postgresql-common: 655s # Installed: 260 655s # Candidate: 260 655s # Version table: 655s # *** 260 990 655s # 990 http://ftpmaster.internal/ubuntu oracular/main amd64 Packages 655s # 990 http://ftpmaster.internal/ubuntu oracular/main i386 Packages 655s # 100 /var/lib/dpkg/status 655s ok 5 - postmaster PID is 23157 655s ok 6 - postmaster was not restarted 655s ok 7 - pg_dropcluster 16 main --stop 655s # Cleanup 655s ok 8 - Cleanup: No clusters left behind 655s ok 9 - No postgres processes left behind 655s ok 10 - No files in /etc/postgresql left behind 655s ok 11 - No files in /var/lib/postgresql left behind 655s ok 12 - No files in /var/run/postgresql left behind 655s ok 13 - No files in /var/log/postgresql left behind 655s ok 14 - PostgreSQL TCP ports are closed 655s ok 15 - Next free port is 5432 655s ### End test 200_maintscripts.t ### 655s 656s autopkgtest [08:37:37]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 656s run-testsuite PASS 691s autopkgtest [08:38:12]: @@@@@@@@@@@@@@@@@@@@ summary 691s default-psql PASS 691s run-testsuite PASS 737s nova [W] Skipping flock for amd64 737s Creating nova instance adt-oracular-amd64-postgresql-common-20240625-082641-juju-7f2275-prod-proposed-migration-environment-2-54eca450-5c4e-49cb-bbb9-37413e649646 from image adt/ubuntu-oracular-amd64-server-20240624.img (UUID 45913f2e-6054-4f37-b765-8cd247ae5ee5)... 737s nova [W] Skipping flock for amd64 737s Creating nova instance adt-oracular-amd64-postgresql-common-20240625-082641-juju-7f2275-prod-proposed-migration-environment-2-54eca450-5c4e-49cb-bbb9-37413e649646 from image adt/ubuntu-oracular-amd64-server-20240624.img (UUID 45913f2e-6054-4f37-b765-8cd247ae5ee5)...