0s autopkgtest [04:41:53]: starting date and time: 2025-01-19 04:41:53+0000 0s autopkgtest [04:41:53]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [04:41:53]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.izeo8rvy/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:ucf --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=ucf/3.0048 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-16.secgroup --name adt-plucky-amd64-postgresql-common-20250119-044153-juju-7f2275-prod-proposed-migration-environment-15-c1ffe59f-f4e5-42d6-a5fd-7d2e1ff7970e --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 346s autopkgtest [04:47:39]: testbed dpkg architecture: amd64 346s autopkgtest [04:47:39]: testbed apt version: 2.9.18 346s autopkgtest [04:47:39]: @@@@@@@@@@@@@@@@@@@@ test bed setup 347s autopkgtest [04:47:40]: testbed release detected to be: None 347s autopkgtest [04:47:40]: updating testbed package index (apt update) 348s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 348s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 348s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 348s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 348s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.6 kB] 348s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [147 kB] 348s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 348s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [806 kB] 349s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [196 kB] 349s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [283 kB] 349s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 349s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 349s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [926 kB] 349s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [401 kB] 349s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [24.6 kB] 349s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [4116 B] 350s Fetched 2928 kB in 2s (1532 kB/s) 350s Reading package lists... 351s Reading package lists... 351s Building dependency tree... 351s Reading state information... 351s Calculating upgrade... 351s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 351s Reading package lists... 352s Building dependency tree... 352s Reading state information... 352s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 352s autopkgtest [04:47:45]: upgrading testbed (apt dist-upgrade and autopurge) 352s Reading package lists... 352s Building dependency tree... 352s Reading state information... 352s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 352s Starting 2 pkgProblemResolver with broken count: 0 352s Done 353s Entering ResolveByKeep 353s 353s The following packages will be upgraded: 353s ucf 353s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 353s Need to get 42.8 kB of archives. 353s After this operation, 0 B of additional disk space will be used. 353s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 ucf all 3.0048 [42.8 kB] 353s Preconfiguring packages ... 353s Fetched 42.8 kB in 0s (149 kB/s) 354s (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 ... 89449 files and directories currently installed.) 354s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 354s Unpacking ucf (3.0048) over (3.0046) ... 354s Setting up ucf (3.0048) ... 354s Processing triggers for man-db (2.13.0-1) ... 355s 355s Running kernel seems to be up-to-date. 355s 355s No services need to be restarted. 355s 355s No containers need to be restarted. 355s 355s No user sessions are running outdated binaries. 355s 355s No VM guests are running outdated hypervisor (qemu) binaries on this host. 356s Reading package lists... 356s Building dependency tree... 356s Reading state information... 356s Starting pkgProblemResolver with broken count: 0 356s Starting 2 pkgProblemResolver with broken count: 0 356s Done 357s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 359s autopkgtest [04:47:52]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 359s autopkgtest [04:47:52]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 364s Get:1 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (dsc) [2383 B] 364s Get:2 http://ftpmaster.internal/ubuntu plucky/main postgresql-common 267 (tar) [219 kB] 364s gpgv: Signature made Thu Nov 21 11:03:28 2024 UTC 364s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 364s gpgv: Can't check signature: No public key 364s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_267.dsc: no acceptable signature found 364s autopkgtest [04:47:57]: testing package postgresql-common version 267 364s autopkgtest [04:47:57]: build not needed 365s autopkgtest [04:47:58]: test default-psql: preparing testbed 365s Reading package lists... 365s Building dependency tree... 365s Reading state information... 365s Starting pkgProblemResolver with broken count: 0 365s Starting 2 pkgProblemResolver with broken count: 0 365s Done 365s The following NEW packages will be installed: 365s libio-pty-perl libipc-run-perl libjson-perl libpq5 postgresql postgresql-17 365s postgresql-client-17 postgresql-client-common postgresql-common ssl-cert 366s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 366s Need to get 18.5 MB of archives. 366s After this operation, 55.2 MB of additional disk space will be used. 366s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 366s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 366s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 366s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 267 [37.1 kB] 366s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 366s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 267 [162 kB] 366s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 366s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.2-1 [1405 kB] 367s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.2-1 [16.5 MB] 380s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql all 17+267 [12.2 kB] 380s Preconfiguring packages ... 380s Fetched 18.5 MB in 15s (1260 kB/s) 380s Selecting previously unselected package libjson-perl. 381s (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 ... 89449 files and directories currently installed.) 381s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 381s Unpacking libjson-perl (4.10000-1) ... 381s Selecting previously unselected package libio-pty-perl. 381s Preparing to unpack .../1-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 381s Unpacking libio-pty-perl (1:1.20-1build3) ... 381s Selecting previously unselected package libipc-run-perl. 381s Preparing to unpack .../2-libipc-run-perl_20231003.0-2_all.deb ... 381s Unpacking libipc-run-perl (20231003.0-2) ... 381s Selecting previously unselected package postgresql-client-common. 381s Preparing to unpack .../3-postgresql-client-common_267_all.deb ... 381s Unpacking postgresql-client-common (267) ... 381s Selecting previously unselected package ssl-cert. 381s Preparing to unpack .../4-ssl-cert_1.1.3ubuntu1_all.deb ... 381s Unpacking ssl-cert (1.1.3ubuntu1) ... 381s Selecting previously unselected package postgresql-common. 381s Preparing to unpack .../5-postgresql-common_267_all.deb ... 381s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 381s Unpacking postgresql-common (267) ... 381s Selecting previously unselected package libpq5:amd64. 381s Preparing to unpack .../6-libpq5_17.2-1_amd64.deb ... 381s Unpacking libpq5:amd64 (17.2-1) ... 381s Selecting previously unselected package postgresql-client-17. 381s Preparing to unpack .../7-postgresql-client-17_17.2-1_amd64.deb ... 381s Unpacking postgresql-client-17 (17.2-1) ... 381s Selecting previously unselected package postgresql-17. 381s Preparing to unpack .../8-postgresql-17_17.2-1_amd64.deb ... 381s Unpacking postgresql-17 (17.2-1) ... 381s Selecting previously unselected package postgresql. 381s Preparing to unpack .../9-postgresql_17+267_all.deb ... 381s Unpacking postgresql (17+267) ... 381s Setting up libio-pty-perl (1:1.20-1build3) ... 381s Setting up libpq5:amd64 (17.2-1) ... 381s Setting up ssl-cert (1.1.3ubuntu1) ... 381s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 382s /usr/sbin/policy-rc.d returned 101, not running 'start ssl-cert.service' 382s Setting up libipc-run-perl (20231003.0-2) ... 382s Setting up libjson-perl (4.10000-1) ... 382s Setting up postgresql-client-common (267) ... 382s Setting up postgresql-client-17 (17.2-1) ... 382s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 382s Setting up postgresql-common (267) ... 382s Creating config file /etc/postgresql-common/createcluster.conf with new version 383s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 383s Removing obsolete dictionary files: 383s invoke-rc.d: policy-rc.d denied execution of start. 383s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 383s /usr/sbin/policy-rc.d returned 101, not running 'start postgresql.service' 383s Setting up postgresql-17 (17.2-1) ... 384s Creating new PostgreSQL cluster 17/main ... 384s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 384s The files belonging to this database system will be owned by user "postgres". 384s This user must also own the server process. 384s 384s The database cluster will be initialized with locale "C.UTF-8". 384s The default database encoding has accordingly been set to "UTF8". 384s The default text search configuration will be set to "english". 384s 384s Data page checksums are disabled. 384s 384s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 384s creating subdirectories ... ok 384s selecting dynamic shared memory implementation ... posix 384s selecting default "max_connections" ... 100 384s selecting default "shared_buffers" ... 128MB 384s selecting default time zone ... Etc/UTC 384s creating configuration files ... ok 384s running bootstrap script ... ok 384s performing post-bootstrap initialization ... ok 384s syncing data to disk ... ok 385s invoke-rc.d: policy-rc.d denied execution of start. 385s Setting up postgresql (17+267) ... 385s Processing triggers for man-db (2.13.0-1) ... 386s Processing triggers for libc-bin (2.40-4ubuntu1) ... 387s 387s Running kernel seems to be up-to-date. 387s 387s No services need to be restarted. 387s 387s No containers need to be restarted. 387s 387s No user sessions are running outdated binaries. 387s 387s No VM guests are running outdated hypervisor (qemu) binaries on this host. 388s autopkgtest [04:48:21]: test default-psql: [----------------------- 389s No running cluster! 389s Ver Cluster Port Status Owner Data directory Log file 389s 17 main 5432 down postgres /var/lib/postgresql/17/main /var/log/postgresql/postgresql-17-main.log 389s psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory 389s Is the server running locally and accepting connections on that socket? 389s autopkgtest [04:48:22]: test default-psql: -----------------------] 390s autopkgtest [04:48:23]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 390s default-psql FAIL non-zero exit status 2 390s autopkgtest [04:48:23]: test default-psql: - - - - - - - - - - stderr - - - - - - - - - - 390s No running cluster! 390s Ver Cluster Port Status Owner Data directory Log file 390s 17 main 5432 down postgres /var/lib/postgresql/17/main /var/log/postgresql/postgresql-17-main.log 390s psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory 390s Is the server running locally and accepting connections on that socket? 390s autopkgtest [04:48:23]: test run-testsuite: preparing testbed 530s autopkgtest [04:50:43]: testbed dpkg architecture: amd64 530s autopkgtest [04:50:43]: testbed apt version: 2.9.18 530s autopkgtest [04:50:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 531s autopkgtest [04:50:44]: testbed release detected to be: plucky 531s autopkgtest [04:50:44]: updating testbed package index (apt update) 532s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 532s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 532s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 532s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 532s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 532s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [806 kB] 533s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [14.6 kB] 533s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [147 kB] 533s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [283 kB] 533s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [196 kB] 533s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 533s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 533s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [401 kB] 533s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [926 kB] 534s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [4116 B] 534s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [24.6 kB] 534s Fetched 2928 kB in 2s (1448 kB/s) 535s Reading package lists... 535s Reading package lists... 536s Building dependency tree... 536s Reading state information... 536s Calculating upgrade... 536s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 536s Reading package lists... 537s Building dependency tree... 537s Reading state information... 537s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 537s autopkgtest [04:50:50]: upgrading testbed (apt dist-upgrade and autopurge) 537s Reading package lists... 537s Building dependency tree... 537s Reading state information... 538s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 538s Starting 2 pkgProblemResolver with broken count: 0 538s Done 538s Entering ResolveByKeep 538s 539s The following packages will be upgraded: 539s ucf 539s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 539s Need to get 42.8 kB of archives. 539s After this operation, 0 B of additional disk space will be used. 539s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 ucf all 3.0048 [42.8 kB] 539s Preconfiguring packages ... 539s Fetched 42.8 kB in 0s (138 kB/s) 540s (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 ... 89449 files and directories currently installed.) 540s Preparing to unpack .../archives/ucf_3.0048_all.deb ... 540s Unpacking ucf (3.0048) over (3.0046) ... 540s Setting up ucf (3.0048) ... 540s Processing triggers for man-db (2.13.0-1) ... 541s 541s Running kernel seems to be up-to-date. 541s 541s No services need to be restarted. 541s 541s No containers need to be restarted. 541s 541s No user sessions are running outdated binaries. 541s 541s No VM guests are running outdated hypervisor (qemu) binaries on this host. 542s Reading package lists... 542s Building dependency tree... 542s Reading state information... 543s Starting pkgProblemResolver with broken count: 0 543s Starting 2 pkgProblemResolver with broken count: 0 543s Done 543s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 546s Reading package lists... 546s Building dependency tree... 546s Reading state information... 546s Starting pkgProblemResolver with broken count: 0 546s Starting 2 pkgProblemResolver with broken count: 0 546s Done 547s The following NEW packages will be installed: 547s autoconf automake autopoint autotools-dev build-essential clang-19 cpp 547s cpp-14 cpp-14-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 547s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 547s fakeroot g++ g++-14 g++-14-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-14 547s gcc-14-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext hunspell-en-us 547s intltool-debian libarchive-zip-perl libasan8 libcc1-0 libclang-common-19-dev 547s libclang-cpp19 libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 547s libfakeroot libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-14-dev 547s libgomp1 libhwasan0 libio-pty-perl libipc-run-perl libisl23 libitm1 547s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-14-dev libobjc4 libpfm4 547s libpgtypes3 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-14-dev 547s libtool libtsan2 libubsan1 libxml2-dev llvm-19 llvm-19-dev 547s llvm-19-linker-tools llvm-19-runtime llvm-19-tools locales-all m4 po-debconf 547s postgresql-17 postgresql-all postgresql-client-17 postgresql-client-common 547s postgresql-common postgresql-doc postgresql-doc-17 postgresql-plperl-17 547s postgresql-plpython3-17 postgresql-pltcl-17 postgresql-server-dev-17 547s postgresql-server-dev-all ssl-cert 547s 0 upgraded, 87 newly installed, 0 to remove and 0 not upgraded. 547s Need to get 192 MB of archives. 547s After this operation, 1114 MB of additional disk space will be used. 547s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 547s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 547s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 547s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 267 [37.1 kB] 547s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 547s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 267 [162 kB] 547s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 547s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 autoconf all 2.72-3 [382 kB] 548s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 autotools-dev all 20220109.1 [44.9 kB] 548s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 548s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 autopoint all 0.22.5-3 [616 kB] 548s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libisl23 amd64 0.27-1 [685 kB] 548s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 libmpc3 amd64 1.3.1-1build2 [55.3 kB] 548s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14-x86-64-linux-gnu amd64 14.2.0-13ubuntu1 [11.9 MB] 554s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-14 amd64 14.2.0-13ubuntu1 [1032 B] 554s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [5452 B] 554s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 cpp amd64 4:14.1.0-2ubuntu1 [22.4 kB] 554s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libcc1-0 amd64 14.2.0-13ubuntu1 [47.6 kB] 554s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 libgomp1 amd64 14.2.0-13ubuntu1 [148 kB] 554s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 libitm1 amd64 14.2.0-13ubuntu1 [29.1 kB] 554s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 libasan8 amd64 14.2.0-13ubuntu1 [2998 kB] 555s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 liblsan0 amd64 14.2.0-13ubuntu1 [1317 kB] 556s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 libtsan2 amd64 14.2.0-13ubuntu1 [2732 kB] 558s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 libubsan1 amd64 14.2.0-13ubuntu1 [1177 kB] 558s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 libhwasan0 amd64 14.2.0-13ubuntu1 [1634 kB] 559s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 libquadmath0 amd64 14.2.0-13ubuntu1 [153 kB] 559s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 libgcc-14-dev amd64 14.2.0-13ubuntu1 [2815 kB] 561s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14-x86-64-linux-gnu amd64 14.2.0-13ubuntu1 [23.4 MB] 577s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-14 amd64 14.2.0-13ubuntu1 [534 kB] 577s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [1214 B] 577s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 gcc amd64 4:14.1.0-2ubuntu1 [5000 B] 577s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 libstdc++-14-dev amd64 14.2.0-13ubuntu1 [2508 kB] 579s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14-x86-64-linux-gnu amd64 14.2.0-13ubuntu1 [13.3 MB] 593s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-14 amd64 14.2.0-13ubuntu1 [21.1 kB] 593s Get:35 http://ftpmaster.internal/ubuntu plucky/main amd64 g++-x86-64-linux-gnu amd64 4:14.1.0-2ubuntu1 [966 B] 593s Get:36 http://ftpmaster.internal/ubuntu plucky/main amd64 g++ amd64 4:14.1.0-2ubuntu1 [1100 B] 593s Get:37 http://ftpmaster.internal/ubuntu plucky/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 593s Get:38 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-cpp19 amd64 1:19.1.6-1ubuntu1 [14.2 MB] 597s Get:39 http://ftpmaster.internal/ubuntu plucky/main amd64 libgc1 amd64 1:8.2.8-1 [102 kB] 597s Get:40 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc4 amd64 14.2.0-13ubuntu1 [47.0 kB] 597s Get:41 http://ftpmaster.internal/ubuntu plucky/universe amd64 libobjc-14-dev amd64 14.2.0-13ubuntu1 [194 kB] 597s Get:42 http://ftpmaster.internal/ubuntu plucky/universe amd64 libclang-common-19-dev amd64 1:19.1.6-1ubuntu1 [743 kB] 597s Get:43 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-linker-tools amd64 1:19.1.6-1ubuntu1 [1325 kB] 598s Get:44 http://ftpmaster.internal/ubuntu plucky/universe amd64 clang-19 amd64 1:19.1.6-1ubuntu1 [78.9 kB] 598s Get:45 http://ftpmaster.internal/ubuntu plucky/main amd64 libdebhelper-perl all 13.20ubuntu1 [94.2 kB] 598s Get:46 http://ftpmaster.internal/ubuntu plucky/main amd64 libtool all 2.4.7-8 [166 kB] 598s Get:47 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-autoreconf all 20 [16.1 kB] 598s Get:48 http://ftpmaster.internal/ubuntu plucky/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 598s Get:49 http://ftpmaster.internal/ubuntu plucky/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 598s Get:50 http://ftpmaster.internal/ubuntu plucky/main amd64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 598s Get:51 http://ftpmaster.internal/ubuntu plucky/main amd64 debugedit amd64 1:5.1-1 [46.9 kB] 598s Get:52 http://ftpmaster.internal/ubuntu plucky/main amd64 dwz amd64 0.15-1build6 [115 kB] 598s Get:53 http://ftpmaster.internal/ubuntu plucky/main amd64 gettext amd64 0.22.5-3 [1025 kB] 598s Get:54 http://ftpmaster.internal/ubuntu plucky/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 598s Get:55 http://ftpmaster.internal/ubuntu plucky/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 598s Get:56 http://ftpmaster.internal/ubuntu plucky/main amd64 debhelper all 13.20ubuntu1 [893 kB] 599s Get:57 http://ftpmaster.internal/ubuntu plucky/main amd64 emacsen-common all 3.0.5 [12.1 kB] 599s Get:58 http://ftpmaster.internal/ubuntu plucky/main amd64 dictionaries-common all 1.30.3 [176 kB] 599s Get:59 http://ftpmaster.internal/ubuntu plucky/main amd64 libfakeroot amd64 1.36.2-1 [33.8 kB] 599s Get:60 http://ftpmaster.internal/ubuntu plucky/main amd64 fakeroot amd64 1.36.2-1 [67.9 kB] 599s Get:61 http://ftpmaster.internal/ubuntu plucky/main amd64 hunspell-en-us all 1:2020.12.07-3 [586 kB] 599s Get:62 http://ftpmaster.internal/ubuntu plucky/main amd64 libpgtypes3 amd64 17.2-1 [45.0 kB] 599s Get:63 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 599s Get:64 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg6 amd64 17.2-1 [51.7 kB] 599s Get:65 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-compat3 amd64 17.2-1 [13.2 kB] 599s Get:66 http://ftpmaster.internal/ubuntu plucky/main amd64 libssl-dev amd64 3.4.0-1ubuntu2 [2874 kB] 601s Get:67 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq-dev amd64 17.2-1 [158 kB] 601s Get:68 http://ftpmaster.internal/ubuntu plucky/main amd64 libecpg-dev amd64 17.2-1 [276 kB] 602s Get:69 http://ftpmaster.internal/ubuntu plucky/main amd64 libncurses-dev amd64 6.5-2 [384 kB] 602s Get:70 http://ftpmaster.internal/ubuntu plucky/main amd64 libxml2-dev amd64 2.12.7+dfsg+really2.9.14-0.2ubuntu2 [784 kB] 603s Get:71 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-runtime amd64 1:19.1.6-1ubuntu1 [554 kB] 604s Get:72 http://ftpmaster.internal/ubuntu plucky/universe amd64 libpfm4 amd64 4.13.0+git83-g91970fe-1 [429 kB] 604s Get:73 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19 amd64 1:19.1.6-1ubuntu1 [17.8 MB] 631s Get:74 http://ftpmaster.internal/ubuntu plucky/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 631s Get:75 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-tools amd64 1:19.1.6-1ubuntu1 [540 kB] 632s Get:76 http://ftpmaster.internal/ubuntu plucky/universe amd64 llvm-19-dev amd64 1:19.1.6-1ubuntu1 [47.3 MB] 710s Get:77 http://ftpmaster.internal/ubuntu plucky/universe amd64 locales-all amd64 2.40-4ubuntu1 [11.1 MB] 717s Get:78 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.2-1 [1405 kB] 718s Get:79 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.2-1 [16.5 MB] 728s Get:80 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-17 amd64 17.2-1 [1416 kB] 728s Get:81 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-server-dev-all amd64 267 [21.3 kB] 728s Get:82 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plperl-17 amd64 17.2-1 [70.0 kB] 728s Get:83 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-plpython3-17 amd64 17.2-1 [77.0 kB] 728s Get:84 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-pltcl-17 amd64 17.2-1 [30.0 kB] 728s Get:85 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-all all 267 [1710 B] 728s Get:86 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-doc-17 all 17.2-1 [2122 kB] 729s Get:87 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-doc all 17+267 [12.2 kB] 730s Preconfiguring packages ... 730s Fetched 192 MB in 3min 2s (1053 kB/s) 730s Selecting previously unselected package libjson-perl. 730s (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 ... 89449 files and directories currently installed.) 730s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 730s Unpacking libjson-perl (4.10000-1) ... 730s Selecting previously unselected package libio-pty-perl. 730s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 730s Unpacking libio-pty-perl (1:1.20-1build3) ... 730s Selecting previously unselected package libipc-run-perl. 730s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 730s Unpacking libipc-run-perl (20231003.0-2) ... 730s Selecting previously unselected package postgresql-client-common. 730s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 730s Unpacking postgresql-client-common (267) ... 730s Selecting previously unselected package ssl-cert. 730s Preparing to unpack .../04-ssl-cert_1.1.3ubuntu1_all.deb ... 730s Unpacking ssl-cert (1.1.3ubuntu1) ... 730s Selecting previously unselected package postgresql-common. 730s Preparing to unpack .../05-postgresql-common_267_all.deb ... 730s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 730s Unpacking postgresql-common (267) ... 730s Selecting previously unselected package m4. 730s Preparing to unpack .../06-m4_1.4.19-4build1_amd64.deb ... 730s Unpacking m4 (1.4.19-4build1) ... 730s Selecting previously unselected package autoconf. 730s Preparing to unpack .../07-autoconf_2.72-3_all.deb ... 730s Unpacking autoconf (2.72-3) ... 730s Selecting previously unselected package autotools-dev. 730s Preparing to unpack .../08-autotools-dev_20220109.1_all.deb ... 730s Unpacking autotools-dev (20220109.1) ... 730s Selecting previously unselected package automake. 730s Preparing to unpack .../09-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 730s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 730s Selecting previously unselected package autopoint. 730s Preparing to unpack .../10-autopoint_0.22.5-3_all.deb ... 730s Unpacking autopoint (0.22.5-3) ... 730s Selecting previously unselected package libisl23:amd64. 730s Preparing to unpack .../11-libisl23_0.27-1_amd64.deb ... 730s Unpacking libisl23:amd64 (0.27-1) ... 730s Selecting previously unselected package libmpc3:amd64. 730s Preparing to unpack .../12-libmpc3_1.3.1-1build2_amd64.deb ... 730s Unpacking libmpc3:amd64 (1.3.1-1build2) ... 730s Selecting previously unselected package cpp-14-x86-64-linux-gnu. 730s Preparing to unpack .../13-cpp-14-x86-64-linux-gnu_14.2.0-13ubuntu1_amd64.deb ... 730s Unpacking cpp-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 730s Selecting previously unselected package cpp-14. 730s Preparing to unpack .../14-cpp-14_14.2.0-13ubuntu1_amd64.deb ... 730s Unpacking cpp-14 (14.2.0-13ubuntu1) ... 730s Selecting previously unselected package cpp-x86-64-linux-gnu. 730s Preparing to unpack .../15-cpp-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 730s Unpacking cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 730s Selecting previously unselected package cpp. 730s Preparing to unpack .../16-cpp_4%3a14.1.0-2ubuntu1_amd64.deb ... 730s Unpacking cpp (4:14.1.0-2ubuntu1) ... 730s Selecting previously unselected package libcc1-0:amd64. 730s Preparing to unpack .../17-libcc1-0_14.2.0-13ubuntu1_amd64.deb ... 730s Unpacking libcc1-0:amd64 (14.2.0-13ubuntu1) ... 730s Selecting previously unselected package libgomp1:amd64. 730s Preparing to unpack .../18-libgomp1_14.2.0-13ubuntu1_amd64.deb ... 730s Unpacking libgomp1:amd64 (14.2.0-13ubuntu1) ... 730s Selecting previously unselected package libitm1:amd64. 730s Preparing to unpack .../19-libitm1_14.2.0-13ubuntu1_amd64.deb ... 730s Unpacking libitm1:amd64 (14.2.0-13ubuntu1) ... 730s Selecting previously unselected package libasan8:amd64. 731s Preparing to unpack .../20-libasan8_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libasan8:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package liblsan0:amd64. 731s Preparing to unpack .../21-liblsan0_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking liblsan0:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package libtsan2:amd64. 731s Preparing to unpack .../22-libtsan2_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libtsan2:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package libubsan1:amd64. 731s Preparing to unpack .../23-libubsan1_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libubsan1:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package libhwasan0:amd64. 731s Preparing to unpack .../24-libhwasan0_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libhwasan0:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package libquadmath0:amd64. 731s Preparing to unpack .../25-libquadmath0_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libquadmath0:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package libgcc-14-dev:amd64. 731s Preparing to unpack .../26-libgcc-14-dev_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libgcc-14-dev:amd64 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package gcc-14-x86-64-linux-gnu. 731s Preparing to unpack .../27-gcc-14-x86-64-linux-gnu_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking gcc-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package gcc-14. 731s Preparing to unpack .../28-gcc-14_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking gcc-14 (14.2.0-13ubuntu1) ... 731s Selecting previously unselected package gcc-x86-64-linux-gnu. 731s Preparing to unpack .../29-gcc-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 731s Unpacking gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 731s Selecting previously unselected package gcc. 731s Preparing to unpack .../30-gcc_4%3a14.1.0-2ubuntu1_amd64.deb ... 731s Unpacking gcc (4:14.1.0-2ubuntu1) ... 731s Selecting previously unselected package libstdc++-14-dev:amd64. 731s Preparing to unpack .../31-libstdc++-14-dev_14.2.0-13ubuntu1_amd64.deb ... 731s Unpacking libstdc++-14-dev:amd64 (14.2.0-13ubuntu1) ... 732s Selecting previously unselected package g++-14-x86-64-linux-gnu. 732s Preparing to unpack .../32-g++-14-x86-64-linux-gnu_14.2.0-13ubuntu1_amd64.deb ... 732s Unpacking g++-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 732s Selecting previously unselected package g++-14. 732s Preparing to unpack .../33-g++-14_14.2.0-13ubuntu1_amd64.deb ... 732s Unpacking g++-14 (14.2.0-13ubuntu1) ... 732s Selecting previously unselected package g++-x86-64-linux-gnu. 732s Preparing to unpack .../34-g++-x86-64-linux-gnu_4%3a14.1.0-2ubuntu1_amd64.deb ... 732s Unpacking g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 732s Selecting previously unselected package g++. 732s Preparing to unpack .../35-g++_4%3a14.1.0-2ubuntu1_amd64.deb ... 732s Unpacking g++ (4:14.1.0-2ubuntu1) ... 732s Selecting previously unselected package build-essential. 732s Preparing to unpack .../36-build-essential_12.10ubuntu1_amd64.deb ... 732s Unpacking build-essential (12.10ubuntu1) ... 732s Selecting previously unselected package libclang-cpp19. 732s Preparing to unpack .../37-libclang-cpp19_1%3a19.1.6-1ubuntu1_amd64.deb ... 732s Unpacking libclang-cpp19 (1:19.1.6-1ubuntu1) ... 732s Selecting previously unselected package libgc1:amd64. 732s Preparing to unpack .../38-libgc1_1%3a8.2.8-1_amd64.deb ... 732s Unpacking libgc1:amd64 (1:8.2.8-1) ... 732s Selecting previously unselected package libobjc4:amd64. 732s Preparing to unpack .../39-libobjc4_14.2.0-13ubuntu1_amd64.deb ... 732s Unpacking libobjc4:amd64 (14.2.0-13ubuntu1) ... 732s Selecting previously unselected package libobjc-14-dev:amd64. 732s Preparing to unpack .../40-libobjc-14-dev_14.2.0-13ubuntu1_amd64.deb ... 732s Unpacking libobjc-14-dev:amd64 (14.2.0-13ubuntu1) ... 732s Selecting previously unselected package libclang-common-19-dev:amd64. 732s Preparing to unpack .../41-libclang-common-19-dev_1%3a19.1.6-1ubuntu1_amd64.deb ... 732s Unpacking libclang-common-19-dev:amd64 (1:19.1.6-1ubuntu1) ... 732s Selecting previously unselected package llvm-19-linker-tools. 732s Preparing to unpack .../42-llvm-19-linker-tools_1%3a19.1.6-1ubuntu1_amd64.deb ... 732s Unpacking llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 732s Selecting previously unselected package clang-19. 732s Preparing to unpack .../43-clang-19_1%3a19.1.6-1ubuntu1_amd64.deb ... 732s Unpacking clang-19 (1:19.1.6-1ubuntu1) ... 732s Selecting previously unselected package libdebhelper-perl. 732s Preparing to unpack .../44-libdebhelper-perl_13.20ubuntu1_all.deb ... 732s Unpacking libdebhelper-perl (13.20ubuntu1) ... 733s Selecting previously unselected package libtool. 733s Preparing to unpack .../45-libtool_2.4.7-8_all.deb ... 733s Unpacking libtool (2.4.7-8) ... 733s Selecting previously unselected package dh-autoreconf. 733s Preparing to unpack .../46-dh-autoreconf_20_all.deb ... 733s Unpacking dh-autoreconf (20) ... 733s Selecting previously unselected package libarchive-zip-perl. 733s Preparing to unpack .../47-libarchive-zip-perl_1.68-1_all.deb ... 733s Unpacking libarchive-zip-perl (1.68-1) ... 733s Selecting previously unselected package libfile-stripnondeterminism-perl. 733s Preparing to unpack .../48-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 733s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 733s Selecting previously unselected package dh-strip-nondeterminism. 733s Preparing to unpack .../49-dh-strip-nondeterminism_1.14.0-1_all.deb ... 733s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 733s Selecting previously unselected package debugedit. 733s Preparing to unpack .../50-debugedit_1%3a5.1-1_amd64.deb ... 733s Unpacking debugedit (1:5.1-1) ... 733s Selecting previously unselected package dwz. 733s Preparing to unpack .../51-dwz_0.15-1build6_amd64.deb ... 733s Unpacking dwz (0.15-1build6) ... 733s Selecting previously unselected package gettext. 733s Preparing to unpack .../52-gettext_0.22.5-3_amd64.deb ... 733s Unpacking gettext (0.22.5-3) ... 733s Selecting previously unselected package intltool-debian. 733s Preparing to unpack .../53-intltool-debian_0.35.0+20060710.6_all.deb ... 733s Unpacking intltool-debian (0.35.0+20060710.6) ... 733s Selecting previously unselected package po-debconf. 733s Preparing to unpack .../54-po-debconf_1.0.21+nmu1_all.deb ... 733s Unpacking po-debconf (1.0.21+nmu1) ... 733s Selecting previously unselected package debhelper. 733s Preparing to unpack .../55-debhelper_13.20ubuntu1_all.deb ... 733s Unpacking debhelper (13.20ubuntu1) ... 733s Selecting previously unselected package emacsen-common. 733s Preparing to unpack .../56-emacsen-common_3.0.5_all.deb ... 733s Unpacking emacsen-common (3.0.5) ... 733s Selecting previously unselected package dictionaries-common. 733s Preparing to unpack .../57-dictionaries-common_1.30.3_all.deb ... 733s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 733s Unpacking dictionaries-common (1.30.3) ... 733s Selecting previously unselected package libfakeroot:amd64. 733s Preparing to unpack .../58-libfakeroot_1.36.2-1_amd64.deb ... 733s Unpacking libfakeroot:amd64 (1.36.2-1) ... 733s Selecting previously unselected package fakeroot. 733s Preparing to unpack .../59-fakeroot_1.36.2-1_amd64.deb ... 733s Unpacking fakeroot (1.36.2-1) ... 733s Selecting previously unselected package hunspell-en-us. 733s Preparing to unpack .../60-hunspell-en-us_1%3a2020.12.07-3_all.deb ... 733s Unpacking hunspell-en-us (1:2020.12.07-3) ... 733s Selecting previously unselected package libpgtypes3:amd64. 733s Preparing to unpack .../61-libpgtypes3_17.2-1_amd64.deb ... 733s Unpacking libpgtypes3:amd64 (17.2-1) ... 733s Selecting previously unselected package libpq5:amd64. 733s Preparing to unpack .../62-libpq5_17.2-1_amd64.deb ... 733s Unpacking libpq5:amd64 (17.2-1) ... 733s Selecting previously unselected package libecpg6:amd64. 733s Preparing to unpack .../63-libecpg6_17.2-1_amd64.deb ... 733s Unpacking libecpg6:amd64 (17.2-1) ... 733s Selecting previously unselected package libecpg-compat3:amd64. 733s Preparing to unpack .../64-libecpg-compat3_17.2-1_amd64.deb ... 733s Unpacking libecpg-compat3:amd64 (17.2-1) ... 733s Selecting previously unselected package libssl-dev:amd64. 733s Preparing to unpack .../65-libssl-dev_3.4.0-1ubuntu2_amd64.deb ... 733s Unpacking libssl-dev:amd64 (3.4.0-1ubuntu2) ... 734s Selecting previously unselected package libpq-dev. 734s Preparing to unpack .../66-libpq-dev_17.2-1_amd64.deb ... 734s Unpacking libpq-dev (17.2-1) ... 734s Selecting previously unselected package libecpg-dev. 734s Preparing to unpack .../67-libecpg-dev_17.2-1_amd64.deb ... 734s Unpacking libecpg-dev (17.2-1) ... 734s Selecting previously unselected package libncurses-dev:amd64. 734s Preparing to unpack .../68-libncurses-dev_6.5-2_amd64.deb ... 734s Unpacking libncurses-dev:amd64 (6.5-2) ... 734s Selecting previously unselected package libxml2-dev:amd64. 734s Preparing to unpack .../69-libxml2-dev_2.12.7+dfsg+really2.9.14-0.2ubuntu2_amd64.deb ... 734s Unpacking libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 734s Selecting previously unselected package llvm-19-runtime. 734s Preparing to unpack .../70-llvm-19-runtime_1%3a19.1.6-1ubuntu1_amd64.deb ... 734s Unpacking llvm-19-runtime (1:19.1.6-1ubuntu1) ... 734s Selecting previously unselected package libpfm4:amd64. 734s Preparing to unpack .../71-libpfm4_4.13.0+git83-g91970fe-1_amd64.deb ... 734s Unpacking libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 734s Selecting previously unselected package llvm-19. 734s Preparing to unpack .../72-llvm-19_1%3a19.1.6-1ubuntu1_amd64.deb ... 734s Unpacking llvm-19 (1:19.1.6-1ubuntu1) ... 734s Selecting previously unselected package libffi-dev:amd64. 734s Preparing to unpack .../73-libffi-dev_3.4.6-1build1_amd64.deb ... 734s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 734s Selecting previously unselected package llvm-19-tools. 734s Preparing to unpack .../74-llvm-19-tools_1%3a19.1.6-1ubuntu1_amd64.deb ... 734s Unpacking llvm-19-tools (1:19.1.6-1ubuntu1) ... 734s Selecting previously unselected package llvm-19-dev. 734s Preparing to unpack .../75-llvm-19-dev_1%3a19.1.6-1ubuntu1_amd64.deb ... 734s Unpacking llvm-19-dev (1:19.1.6-1ubuntu1) ... 736s Selecting previously unselected package locales-all. 736s Preparing to unpack .../76-locales-all_2.40-4ubuntu1_amd64.deb ... 736s Unpacking locales-all (2.40-4ubuntu1) ... 738s Selecting previously unselected package postgresql-client-17. 738s Preparing to unpack .../77-postgresql-client-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-client-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-17. 738s Preparing to unpack .../78-postgresql-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-server-dev-17. 738s Preparing to unpack .../79-postgresql-server-dev-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-server-dev-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-server-dev-all:amd64. 738s Preparing to unpack .../80-postgresql-server-dev-all_267_amd64.deb ... 738s Unpacking postgresql-server-dev-all:amd64 (267) ... 738s Selecting previously unselected package postgresql-plperl-17. 738s Preparing to unpack .../81-postgresql-plperl-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-plperl-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-plpython3-17. 738s Preparing to unpack .../82-postgresql-plpython3-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-plpython3-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-pltcl-17. 738s Preparing to unpack .../83-postgresql-pltcl-17_17.2-1_amd64.deb ... 738s Unpacking postgresql-pltcl-17 (17.2-1) ... 738s Selecting previously unselected package postgresql-all. 738s Preparing to unpack .../84-postgresql-all_267_all.deb ... 738s Unpacking postgresql-all (267) ... 738s Selecting previously unselected package postgresql-doc-17. 738s Preparing to unpack .../85-postgresql-doc-17_17.2-1_all.deb ... 738s Unpacking postgresql-doc-17 (17.2-1) ... 739s Selecting previously unselected package postgresql-doc. 739s Preparing to unpack .../86-postgresql-doc_17+267_all.deb ... 739s Unpacking postgresql-doc (17+267) ... 739s Setting up libpgtypes3:amd64 (17.2-1) ... 739s Setting up libncurses-dev:amd64 (6.5-2) ... 739s Setting up libio-pty-perl (1:1.20-1build3) ... 739s Setting up libclang-common-19-dev:amd64 (1:19.1.6-1ubuntu1) ... 739s Setting up libarchive-zip-perl (1.68-1) ... 739s Setting up libdebhelper-perl (13.20ubuntu1) ... 739s Setting up postgresql-doc-17 (17.2-1) ... 739s update-alternatives: using /usr/share/postgresql/17/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 739s Setting up libpq5:amd64 (17.2-1) ... 739s Setting up m4 (1.4.19-4build1) ... 739s Setting up libgomp1:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 739s Setting up locales-all (2.40-4ubuntu1) ... 739s Setting up libfakeroot:amd64 (1.36.2-1) ... 739s Setting up fakeroot (1.36.2-1) ... 739s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 739s Setting up autotools-dev (20220109.1) ... 739s Setting up libxml2-dev:amd64 (2.12.7+dfsg+really2.9.14-0.2ubuntu2) ... 739s Setting up libpfm4:amd64 (4.13.0+git83-g91970fe-1) ... 739s Setting up emacsen-common (3.0.5) ... 739s Setting up ssl-cert (1.1.3ubuntu1) ... 739s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 739s /usr/sbin/policy-rc.d returned 101, not running 'start ssl-cert.service' 739s Setting up libquadmath0:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libssl-dev:amd64 (3.4.0-1ubuntu2) ... 739s Setting up libmpc3:amd64 (1.3.1-1build2) ... 739s Setting up autopoint (0.22.5-3) ... 739s Setting up libipc-run-perl (20231003.0-2) ... 739s Setting up libgc1:amd64 (1:8.2.8-1) ... 739s Setting up autoconf (2.72-3) ... 739s Setting up libubsan1:amd64 (14.2.0-13ubuntu1) ... 739s Setting up dwz (0.15-1build6) ... 739s Setting up libhwasan0:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libasan8:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libjson-perl (4.10000-1) ... 739s Setting up postgresql-doc (17+267) ... 739s Setting up debugedit (1:5.1-1) ... 739s Setting up libecpg6:amd64 (17.2-1) ... 739s Setting up llvm-19-linker-tools (1:19.1.6-1ubuntu1) ... 739s Setting up libtsan2:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libisl23:amd64 (0.27-1) ... 739s Setting up llvm-19-runtime (1:19.1.6-1ubuntu1) ... 739s Setting up llvm-19-tools (1:19.1.6-1ubuntu1) ... 739s Setting up libcc1-0:amd64 (14.2.0-13ubuntu1) ... 739s Setting up liblsan0:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libitm1:amd64 (14.2.0-13ubuntu1) ... 739s Setting up libclang-cpp19 (1:19.1.6-1ubuntu1) ... 739s Setting up automake (1:1.16.5-1.3ubuntu1) ... 739s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 739s Setting up postgresql-client-common (267) ... 739s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 739s Setting up gettext (0.22.5-3) ... 739s Setting up libecpg-compat3:amd64 (17.2-1) ... 739s Setting up dictionaries-common (1.30.3) ... 740s Setting up postgresql-client-17 (17.2-1) ... 740s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 740s Setting up libpq-dev (17.2-1) ... 740s Setting up libobjc4:amd64 (14.2.0-13ubuntu1) ... 740s Setting up libecpg-dev (17.2-1) ... 740s Setting up intltool-debian (0.35.0+20060710.6) ... 740s Setting up postgresql-common (267) ... 740s Creating config file /etc/postgresql-common/createcluster.conf with new version 740s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 740s en_us 741s Removing obsolete dictionary files: 741s invoke-rc.d: policy-rc.d denied execution of start. 741s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 741s /usr/sbin/policy-rc.d returned 101, not running 'start postgresql.service' 741s Setting up cpp-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 741s Setting up cpp-14 (14.2.0-13ubuntu1) ... 741s Setting up dh-strip-nondeterminism (1.14.0-1) ... 741s Setting up hunspell-en-us (1:2020.12.07-3) ... 741s Setting up llvm-19 (1:19.1.6-1ubuntu1) ... 741s Setting up libgcc-14-dev:amd64 (14.2.0-13ubuntu1) ... 741s Setting up libstdc++-14-dev:amd64 (14.2.0-13ubuntu1) ... 741s Setting up cpp-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 741s Setting up postgresql-17 (17.2-1) ... 742s Creating new PostgreSQL cluster 17/main ... 742s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 742s The files belonging to this database system will be owned by user "postgres". 742s This user must also own the server process. 742s 742s The database cluster will be initialized with locale "C.UTF-8". 742s The default database encoding has accordingly been set to "UTF8". 742s The default text search configuration will be set to "english". 742s 742s Data page checksums are disabled. 742s 742s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 742s creating subdirectories ... ok 742s selecting dynamic shared memory implementation ... posix 742s selecting default "max_connections" ... 100 742s selecting default "shared_buffers" ... 128MB 742s selecting default time zone ... Etc/UTC 742s creating configuration files ... ok 742s running bootstrap script ... ok 742s performing post-bootstrap initialization ... ok 742s syncing data to disk ... ok 743s invoke-rc.d: policy-rc.d denied execution of start. 743s Setting up po-debconf (1.0.21+nmu1) ... 743s Setting up libobjc-14-dev:amd64 (14.2.0-13ubuntu1) ... 744s Setting up clang-19 (1:19.1.6-1ubuntu1) ... 744s Setting up llvm-19-dev (1:19.1.6-1ubuntu1) ... 744s Setting up postgresql-plpython3-17 (17.2-1) ... 744s Setting up postgresql-plperl-17 (17.2-1) ... 744s Setting up cpp (4:14.1.0-2ubuntu1) ... 744s Setting up gcc-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 744s Setting up postgresql-pltcl-17 (17.2-1) ... 744s Setting up gcc-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 744s Setting up libtool (2.4.7-8) ... 744s Setting up gcc-14 (14.2.0-13ubuntu1) ... 744s Setting up dh-autoreconf (20) ... 744s Setting up postgresql-server-dev-17 (17.2-1) ... 744s Setting up g++-14-x86-64-linux-gnu (14.2.0-13ubuntu1) ... 744s Setting up g++-x86-64-linux-gnu (4:14.1.0-2ubuntu1) ... 744s Setting up g++-14 (14.2.0-13ubuntu1) ... 744s Setting up postgresql-server-dev-all:amd64 (267) ... 744s Setting up debhelper (13.20ubuntu1) ... 744s Setting up postgresql-all (267) ... 744s Setting up gcc (4:14.1.0-2ubuntu1) ... 744s Setting up g++ (4:14.1.0-2ubuntu1) ... 744s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 744s Setting up build-essential (12.10ubuntu1) ... 744s Processing triggers for libc-bin (2.40-4ubuntu1) ... 744s Processing triggers for systemd (257-2ubuntu1) ... 744s Processing triggers for man-db (2.13.0-1) ... 746s Processing triggers for install-info (7.1.1-1) ... 746s Processing triggers for dictionaries-common (1.30.3) ... 746s 746s Running kernel seems to be up-to-date. 746s 746s No services need to be restarted. 746s 746s No containers need to be restarted. 746s 746s No user sessions are running outdated binaries. 746s 746s No VM guests are running outdated hypervisor (qemu) binaries on this host. 751s autopkgtest [04:54:24]: test run-testsuite: [----------------------- 752s ====== Running all tests with umask 077 ======= 752s ### PostgreSQL test 001_packages.t ### 752s 1..21 752s ok 1 - /etc/os-release exists 752s ok 2 - OS is ubuntu 752s ok 3 - OS version is 25.04 752s # PostgreSQL versions installed: 17 752s ok 4 - postgresql-17 installed 752s ok 5 - postgresql-plpython3-17 installed 752s ok 6 - postgresql-plperl-17 installed 752s ok 7 - postgresql-pltcl-17 installed 752s ok 8 - postgresql-server-dev-17 installed 752s ok 9 # skip No postgresql-contrib-17 package for version 17 752s # postgresql-doc-17 installed 752s ok 10 - At least one doc package installed 752s ok 11 - libecpg-dev installed 752s ok 12 - procps installed 752s ok 13 - netcat-openbsd installed 752s ok 14 - hunspell-en-us installed 752s ok 15 - system has a default UTF-8 locale 752s ok 16 - locale ru_RU exists 752s ok 17 - locale ru_RU.UTF-8 exists 752s ok 18 - user postgres in the UNIX group ssl-cert 752s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 752s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 752s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 752s ### End test 001_packages.t ### 752s 752s ### PostgreSQL test 002_existing_clusters.t ### 752s 1..8 752s # Cleanup 752s ok 1 - Cleanup: No clusters left behind 752s ok 2 - No postgres processes left behind 752s ok 3 - No files in /etc/postgresql left behind 752s ok 4 - No files in /var/lib/postgresql left behind 752s ok 5 - No files in /var/run/postgresql left behind 752s ok 6 - No files in /var/log/postgresql left behind 752s ok 7 - PostgreSQL TCP ports are closed 752s ok 8 - Next free port is 5432 752s ### End test 002_existing_clusters.t ### 752s 752s ### PostgreSQL test 003_alternatives.t ### 752s 1..9 752s # Newest PG version installed is 17 752s ok 1 - psql.1.gz link group 752s ok 2 - postmaster.1.gz link group does not exist 752s ok 3 - psql.1.gz alternative 752s ok 4 - pg_dump.1.gz alternative 752s ok 5 - postgres.1.gz alternative 752s ok 6 - pg_ctl.1.gz alternative 752s # Newest PG doc version installed is 17 752s ok 7 - SPI_connect.3.gz link group 752s ok 8 - SPI_connect.3.gz alternative 752s ok 9 - SPI_exec.3.gz alternative 752s ### End test 003_alternatives.t ### 752s 752s ### PostgreSQL test 005_PgCommon.t ### 752s 1..24 752s ok 1 - correctly parsed line 'local all postgres ident sameuser' 752s ok 2 - correctly parsed line 'local foo nobody trust' 752s ok 3 - correctly parsed line 'local foo nobody crypt' 752s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 752s ok 5 - correctly parsed line 'local foo,bar nobody ident' 752s ok 6 - correctly parsed line 'local all +foogrp password' 752s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 752s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 752s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 752s ok 10 - @expected_records has correct number of entries 752s ok 11 - returned read_pg_hba array has correct number of records 752s ok 12 - line 'foo all all md5' parsed as invalid 752s ok 13 - line 'local all all foo' parsed as invalid 752s ok 14 - line 'host all all foo' parsed as invalid 752s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 752s ok 16 - line 'host all all md5' parsed as invalid 752s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 752s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 752s ok 19 - read_conf_file returns empty dict for nonexisting file 752s ok 20 - read_conf_file() parsing 752s ok 21 - read_conf_file() parsing with include directives 752s ok 22 - set_conf_value 752s ok 23 - disable_conf_value 752s ok 24 - replace_conf_value 752s ### End test 005_PgCommon.t ### 752s 752s ### PostgreSQL test 006_next_free_port.t ### 753s 1..5 753s ok 1 - next_free_port is 5432 754s ok 2 - next_free_port detects localhost ipv4 socket 755s ok 3 - next_free_port detects wildcard ipv4 socket 756s ok 4 - next_free_port detects localhost ipv6 socket 757s ok 5 - next_free_port detects wildcard ipv6 socket 757s ### End test 006_next_free_port.t ### 757s 757s ### PostgreSQL test 007_pg_conftool.t ### 757s 1..41 757s # test without cluster 757s ok 1 - pg_conftool show all 757s ok 2 - correct output of pg_conftool show all 757s ok 3 - pg_conftool foo.conf show all 757s ok 4 - correct output of pg_conftool foo.conf show all 757s ok 5 - pg_conftool /tmp/p12VqZxpoL/different.conf show all 757s ok 6 - correct output of pg_conftool /tmp/p12VqZxpoL/different.conf show all 757s ok 7 - pg_conftool 9.7 main show all 757s ok 8 - correct output of pg_conftool 9.7 main show all 757s # test show 757s ok 9 - pg_conftool show all 757s ok 10 - correct output of pg_conftool show all 757s ok 11 - pg_conftool other.conf show all 757s ok 12 - correct output of pg_conftool other.conf show all 757s ok 13 - pg_conftool /tmp/p12VqZxpoL/different.conf show all 757s ok 14 - correct output of pg_conftool /tmp/p12VqZxpoL/different.conf show all 757s ok 15 - pg_conftool 17 main show all 757s ok 16 - correct output of pg_conftool 17 main show all 757s ok 17 - pg_conftool 17 main other.conf show all 757s ok 18 - correct output of pg_conftool 17 main other.conf show all 757s ok 19 - pg_conftool show a 757s ok 20 - correct output of pg_conftool show a 757s ok 21 - pg_conftool -s show a 757s ok 22 - correct output of pg_conftool -s show a 757s # test set 757s ok 23 - pg_conftool set c 7 757s ok 24 - correct output of pg_conftool set c 7 757s ok 25 - file contains new setting 757s ok 26 - pg_conftool set a 8 757s ok 27 - correct output of pg_conftool set a 8 757s ok 28 - file contains updated setting 757s ok 29 - pg_conftool /tmp/p12VqZxpoL/different.conf set a 9 757s ok 30 - correct output of pg_conftool /tmp/p12VqZxpoL/different.conf set a 9 757s ok 31 - file with path contains updated setting 757s # test remove 757s ok 32 - pg_conftool remove a 757s ok 33 - correct output of pg_conftool remove a 757s ok 34 - setting removed from file 757s ok 35 - pg_conftool /tmp/p12VqZxpoL/different.conf remove a 757s ok 36 - correct output of pg_conftool /tmp/p12VqZxpoL/different.conf remove a 757s ok 37 - setting removed from file with path 757s # test edit 757s ok 38 - pg_conftool edit 757s ok 39 - correct output of pg_conftool edit 757s ok 40 - pg_conftool /tmp/p12VqZxpoL/different.conf edit 757s ok 41 - correct output of pg_conftool /tmp/p12VqZxpoL/different.conf edit 757s ### End test 007_pg_conftool.t ### 757s 757s ### PostgreSQL test 010_defaultport_cluster.t ### 757s 1..14 757s ok 1 - psql --version 757s ok 2 - pg_wrapper selects highest available version number 757s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 757s ok 4 - connecting to localhost fails with no clusters 757s ok 5 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -l 757s ok 6 - pg_wrapper uses host and port from PGCLUSTER 758s ok 7 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --cluster 17/127.0.0.3:5430 -l 758s ok 8 - pg_wrapper uses --cluster from the command line 758s ok 9 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql -h 127.0.0.3 -l 758s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 758s ok 11 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 psql --host 127.0.0.3 -l 758s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 758s ok 13 - env LC_MESSAGES=C PGCLUSTER=17/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 758s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 758s ### End test 010_defaultport_cluster.t ### 758s 758s ### PostgreSQL test 015_start_stop.t ### 758s 1..71 758s # We are running systemd 758s # Running tests for 17 758s # Cluster does not exist yet 758s ok 1 - cluster 17 main does not exist 758s ok 2 - service postgresql@17-main does not exist 758s ok 3 - systemctl start postgresql 758s ok 4 - cluster 17 main does not exist 758s ok 5 - service postgresql@17-main does not exist 758s ok 6 - systemctl start postgresql@17-main 758s ok 7 - cluster 17 main does not exist 758s ok 8 - service postgresql@17-main does not exist 758s # Start/stop postgresql using system tools 759s ok 9 - pg_createcluster 17 main 759s ok 10 - cluster 17 main is stopped 759s ok 11 - service postgresql@17-main is stopped 761s ok 12 - systemctl start postgresql 761s ok 13 - cluster 17 main is running 761s ok 14 - service postgresql@17-main is running 761s ok 15 - systemctl start postgresql 761s ok 16 - cluster 17 main is already running 761s ok 17 - service postgresql@17-main is already running 761s ok 18 - systemctl stop postgresql 767s ok 19 - cluster 17 main is stopped 767s ok 20 - service postgresql@17-main is stopped 767s ok 21 - systemctl stop postgresql 767s ok 22 - cluster 17 main is already stopped 767s ok 23 - service postgresql@17-main is already stopped 767s # Start/stop specific cluster using system tools 770s ok 24 - systemctl start postgresql@17-main 770s ok 25 - cluster 17 main is running 770s ok 26 - service postgresql@17-main is running 770s ok 27 - systemctl start postgresql@17-main 770s ok 28 - cluster 17 main is running 770s ok 29 - service postgresql@17-main is running 772s ok 30 - systemctl restart postgresql@17-main 772s ok 31 - cluster 17 main is running 772s ok 32 - service postgresql@17-main is running 772s ok 33 - systemctl stop postgresql@17-main 772s ok 34 - cluster 17 main is stopped 772s ok 35 - service postgresql@17-main is stopped 772s ok 36 - systemctl stop postgresql@17-main 772s ok 37 - cluster 17 main is already stopped 772s ok 38 - service postgresql@17-main is already stopped 774s ok 39 - pg_dropcluster 17 main 774s ok 40 - cluster 17 main does not exist 774s ok 41 - service postgresql@17-main does not exist 774s # Start/stop specific cluster using pg_*cluster 774s ok 42 - pg_ctlcluster start 17 main 774s ok 43 - cluster 17 main does not exist 774s ok 44 - service postgresql@17-main does not exist 777s ok 45 - pg_createcluster 17 main --start 777s ok 46 - cluster 17 main is running 777s ok 47 - service postgresql@17-main is running 777s ok 48 - pg_ctlcluster 17 main start 777s ok 49 - cluster 17 main is already running 777s ok 50 - service postgresql@17-main is already running 779s ok 51 - pg_ctlcluster 17-main restart 780s ok 52 - cluster 17 main is running 780s ok 53 - service postgresql@17-main is running 780s ok 54 - pg_ctlcluster 17 main stop 780s ok 55 - cluster 17 main is stopped 780s ok 56 - service postgresql@17-main is stopped 780s ok 57 - pg_ctlcluster 17 main stop 780s ok 58 - cluster 17 main is already stopped 780s ok 59 - service postgresql@17-main is already stopped 782s ok 60 - pg_ctlcluster start 17-main 782s ok 61 - cluster 17 main is running 782s ok 62 - service postgresql@17-main is running 784s ok 63 - pg_dropcluster 17 main --stop 784s # Cleanup 784s ok 64 - Cleanup: No clusters left behind 784s ok 65 - No postgres processes left behind 784s ok 66 - No files in /etc/postgresql left behind 784s ok 67 - No files in /var/lib/postgresql left behind 784s ok 68 - No files in /var/run/postgresql left behind 784s ok 69 - No files in /var/log/postgresql left behind 784s ok 70 - PostgreSQL TCP ports are closed 784s ok 71 - Next free port is 5432 784s ### End test 015_start_stop.t ### 784s 784s ### PostgreSQL test 020_create_sql_remove.t ### 784s 1..141 784s # Running tests for 17 787s ok 1 - pg_createcluster 17 main --start -- -X /tmp/17.xlog.vxMH4M 787s ok 2 - pg_createcluster 17 main 787s ok 3 - Socket and pid file are in /var/run/postgresql/ 787s ok 4 - xlog/wal directory /tmp/17.xlog.vxMH4M was created 787s ok 5 - local method in pg_hba.conf is peer 787s ok 6 - host method in pg_hba.conf is scram-sha-256 787s ok 7 - Exactly one postgres master process running 789s ok 8 - pg_ctlcluster 17 main restart 789s ok 9 - cluster restarts with new environment file 789s ok 10 - Exactly one postgres master process running 789s ok 11 - correct value of PGEXTRAVAR1 in environment 789s ok 12 - correct value of PGEXTRAVAR2 in environment 789s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 789s ok 14 - createdb --version 789s ok 15 - pg_wrapper+createdb selects version number of cluster 789s ok 16 - psql --version 789s ok 17 - pg_wrapper+psql selects version 17 789s ok 18 - pg_lscluster reports online cluster on port 5432 789s ok 19 - log file is actually used 789s ok 20 - /etc/postgresql is owned by user "postgres" 789s ok 21 - version configuration directory file is owned by user "postgres" 789s ok 22 - configuration directory file is owned by user "postgres" 789s ok 23 - version data directory file is owned by user "postgres" 789s ok 24 - data directory file is owned by user "postgres" 789s ok 25 - log file has 0640 permissions 789s ok 26 - log file is owned by user "postgres" 789s ok 27 - log file is owned by group "adm" 789s ok 28 - no log symlink by default 789s ok 29 - /var/log/postgresql/postgresql-17-main.log is the default log if log symlink is missing 789s ok 30 - pg_lsclusters -h 789s ok 31 - correct output of pg_lsclusters -h 789s ok 32 - stopping cluster 792s ok 33 - restarting cluster with nondefault log symlink 792s ok 34 - log target is used as log file 792s ok 35 - default log is not used 792s ok 36 - pg_lsclusters -h 792s ok 37 - correct output of pg_lsclusters -h 792s ok 38 - stopping cluster 795s ok 39 - restarting cluster with explicitly configured log file 795s ok 40 - default log is not used 795s ok 41 - log symlink target is used for startup message 795s ok 42 - exactly one log file 795s ok 43 - custom log is actually used 795s ok 44 - pg_lsclusters -h 795s ok 45 - correct output of pg_lsclusters -h 795s ok 46 - stopping cluster 795s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 795s ok 48 - /etc/postgres-hack was not created 797s ok 49 - restarting cluster 797s ok 50 - ps -o tty -U postgres h 797s ok 51 - postgres processes do not have an associated terminal 797s ok 52 - Server is linked with SSL support 797s ok 53 - SSL is enabled in postgresql.conf 798s ok 54 - psql -l fails for nobody 798s ok 55 - createuser nobody 798s ok 56 - createdb nobodydb 798s ok 57 - psql -ltA succeeds for nobody 798s ok 58 - psql -ltA output 798s ok 59 - SQL command: create table 798s ok 60 - SQL command: insert into table values 798s ok 61 - SQL command: insert into table values 798s ok 62 - primary key violation 798s ok 63 - psql -tAc "select * from phone order by name" nobodydb 798s ok 64 - SQL command output: select -tA 798s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 798s ok 66 - SQL command output: select -tx 798s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 798s ok 68 - SQL command output: select -tAx 798s ok 69 - CREATE EXTENSION plperlu fails for user nobody 798s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 798s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 798s ok 72 - creating PL/PerlU function as user nobody fails 798s ok 73 - creating unsafe PL/Perl function as user postgres fails 798s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 798s ok 75 - creating PL/PerlU function as user postgres succeeds 798s ok 76 - psql nobodydb -Atc "select read_file()" 798s ok 77 - calling PL/PerlU function 798s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 798s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 798s ok 80 - creating unsafe PL/Perl function as user nobody fails 798s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 798s ok 82 - creating PL/Perl function as user nobody succeeds 798s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 798s ok 84 - calling PL/Perl function 798s ok 85 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 798s ok 86 - CREATE EXTENSION plpython3u succeeds for user postgres 799s ok 87 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 799s ok 88 - creating PL/Python3 function as user postgres succeeds 799s ok 89 - psql nobodydb -Atc "select capitalize3('foo')" 799s ok 90 - calling PL/Python function 799s ok 91 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 799s ok 92 - CREATE EXTENSION pltcl succeeds for user postgres 799s ok 93 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 799s ok 94 - CREATE EXTENSION pltclu succeeds for user postgres 799s ok 95 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 799s ok 96 - creating PL/Tcl function as user nobody succeeds 799s ok 97 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 799s ok 98 - creating PL/TclU function as user postgres succeeds 799s ok 99 - psql nobodydb -Atc "select tcl_max(3,4)" 799s ok 100 - calling PL/Tcl function 799s ok 101 - psql nobodydb -Atc "select tcl_max_u(5,4)" 799s ok 102 - calling PL/TclU function 799s ok 103 - stopping cluster 799s ok 104 - pg_ctlcluster 17 main start 799s ok 105 - cluster fails to start with invalid data_directory and valid pgdata symlink 801s ok 106 - pg_ctlcluster 17 main start 801s ok 107 - cluster restarts with pgdata symlink 802s ok 108 - postgres master has OOM killer protection 802s ok 109 - postgres client backend has no OOM adjustment 802s ok 110 - ps h 6964 802s ok 111 - process title is idle 802s ok 112 - ps h 6964 802s ok 113 - process title is idle in transaction 802s ok 114 - stopping cluster 805s ok 115 - starting cluster as postgres works without a log file 805s ok 116 - log file got recreated and used 805s ok 117 - creating a directory in spc2 805s ok 118 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/17.spc1.0hmlFu'" 805s ok 119 - creating tablespace spc1 805s ok 120 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 805s ok 121 - creating a table in spc1 805s ok 122 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/17.spc2.GgPipv'" 805s ok 123 - creating tablespace spc2 805s ok 124 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 805s ok 125 - creating a table in spc2 805s ok 126 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 805s ok 127 - Correct apt NeverAutoRemove config 806s ok 128 - pg_dropcluster removes cluster 806s ok 129 - xlog/wal directory /tmp/17.xlog.vxMH4M was deleted 806s ok 130 - tablespace spc1 was emptied 806s ok 131 - tablespace spc2 was emptied 806s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 806s ok 133 - Correct apt NeverAutoRemove config 806s # Cleanup 806s ok 134 - Cleanup: No clusters left behind 806s ok 135 - No postgres processes left behind 806s ok 136 - No files in /etc/postgresql left behind 806s ok 137 - No files in /var/lib/postgresql left behind 806s ok 138 - No files in /var/run/postgresql left behind 806s ok 139 - No files in /var/log/postgresql left behind 806s ok 140 - PostgreSQL TCP ports are closed 806s ok 141 - Next free port is 5432 806s ### End test 020_create_sql_remove.t ### 806s 806s ### PostgreSQL test 021_pg_renamecluster.t ### 806s 1..20 809s ok 1 - pg_createcluster 17 main 812s ok 2 - pg_renamecluster 17 main donau 812s ok 3 - psql -tAc "show data_directory" 812s ok 4 - cluster is running and data_directory was moved 812s ok 5 - pg_hba.conf location updated 812s ok 6 - pg_ident.conf location updated 812s ok 7 - external_pid_file location updated 812s ok 8 - external_pid_file exists 812s ok 9 # skip no stats_temp_directory in 17 812s ok 10 # skip no stats_temp_directory in 17 812s ok 11 - cluster_name is updated 814s ok 12 - pg_dropcluster removes cluster 814s # Cleanup 814s ok 13 - Cleanup: No clusters left behind 814s ok 14 - No postgres processes left behind 814s ok 15 - No files in /etc/postgresql left behind 814s ok 16 - No files in /var/lib/postgresql left behind 814s ok 17 - No files in /var/run/postgresql left behind 814s ok 18 - No files in /var/log/postgresql left behind 814s ok 19 - PostgreSQL TCP ports are closed 814s ok 20 - Next free port is 5432 814s ### End test 021_pg_renamecluster.t ### 814s 814s ### PostgreSQL test 022_recovery.t ### 814s 1..17 814s # Running tests for 17 817s ok 1 - pg_createcluster 17 main --start >/dev/null 817s ok 2 - pg_ctlcluster 17 main stop -m i 820s ok 3 - pg_ctlcluster 17 main start 820s ok 4 - psql -c '' 820s ok 5 - pg_ctlcluster 17 main stop -m i 820s ok 6 - create write-protected file in data directory 822s ok 7 - pg_ctlcluster 17 main start 822s ok 8 - psql -c '' 824s ok 9 - pg_dropcluster removes cluster 824s # Cleanup 824s ok 10 - Cleanup: No clusters left behind 824s ok 11 - No postgres processes left behind 824s ok 12 - No files in /etc/postgresql left behind 824s ok 13 - No files in /var/lib/postgresql left behind 824s ok 14 - No files in /var/run/postgresql left behind 824s ok 15 - No files in /var/log/postgresql left behind 824s ok 16 - PostgreSQL TCP ports are closed 824s ok 17 - Next free port is 5432 824s ### End test 022_recovery.t ### 824s 824s ### PostgreSQL test 025_logging.t ### 824s 1..55 824s # Logging to /var/log/syslog works 824s # Running tests for 17 828s ok 1 - pg_createcluster 17 main 828s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-17-main.log 828s ok 3 - psql -qc "'foobar_17_8253'" 828s ok 4 - log an error 828s ok 5 - grep --binary-files=text foobar_17_8253 /var/log/postgresql/postgresql-17-main.log 828s ok 6 - error appears in logfile 828s ok 7 - pg_conftool 17 main set log_destination syslog 828s ok 8 - set log_destination syslog 828s ok 9 - pg_ctlcluster 17 main reload 828s ok 10 - 17 main reload 828s ok 11 - psql -Atc "show log_destination" 828s ok 12 - log_destination is syslog 828s ok 13 - pg_lscluster reports syslog 829s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 829s ok 15 - error appears in /var/log/syslog 829s ok 16 - pg_conftool 17 main set logging_collector on 829s ok 17 - set logging_collector on 829s ok 18 - pg_conftool 17 main set log_destination csvlog 829s ok 19 - set log_destination csvlog 831s ok 20 - pg_ctlcluster 17 main restart 831s ok 21 - 17 main restart 831s ok 22 - psql -Atc "show logging_collector" 831s ok 23 - logging_collector is on 831s ok 24 - psql -Atc "show log_destination" 831s ok 25 - log_destination is csvlog 831s ok 26 - pg_lscluster reports csvlog 831s ok 27 - psql -qc "'barbaz_17_8253'" 831s ok 28 - log an error 832s ok 29 - grep --binary-files=text barbaz_17_8253 /var/lib/postgresql/17/main/log/*.csv 832s ok 30 - error appears in log/*.csv 832s ok 31 - pg_conftool 17 main set log_destination stderr,syslog,csvlog 832s ok 32 - set log_destination stderr,syslog,csvlog 832s ok 33 - pg_ctlcluster 17 main reload 832s ok 34 - 17 main reload 832s ok 35 - psql -Atc "show log_destination" 832s ok 36 - log_destination is stderr,syslog,csvlog 832s ok 37 - pg_lscluster reports stderr,syslog,csvlog 832s ok 38 - psql -qc "'moo_17_8253'" 832s ok 39 - log an error 833s ok 40 - grep --binary-files=text moo_17_8253 /var/lib/postgresql/17/main/log/*.log 833s ok 41 - error appears in log/*.log 833s ok 42 - grep --binary-files=text 'postgres.*moo_17_8253' /var/log/syslog 833s ok 43 - error appears in /var/log/syslog 833s ok 44 - grep --binary-files=text moo_17_8253 /var/lib/postgresql/17/main/log/*.csv 833s ok 45 - error appears in log/*.csv 835s ok 46 - pg_dropcluster 17 main --stop 835s ok 47 - pg_dropcluster removes cluster 835s # Cleanup 835s ok 48 - Cleanup: No clusters left behind 835s ok 49 - No postgres processes left behind 835s ok 50 - No files in /etc/postgresql left behind 835s ok 51 - No files in /var/lib/postgresql left behind 835s ok 52 - No files in /var/run/postgresql left behind 835s ok 53 - No files in /var/log/postgresql left behind 835s ok 54 - PostgreSQL TCP ports are closed 835s ok 55 - Next free port is 5432 835s ### End test 025_logging.t ### 835s 835s ### PostgreSQL test 027_jit.t ### 835s # 17 838s ok 1 - pg_createcluster 17 main --start 838s ok 2 - psql -Xatc 'show jit' 838s ok 3 - JIT is on by default 838s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 838s ok 5 - No JIT on cheap query 838s ok 6 - pg_conftool 17 main set seq_page_cost 100000 838s ok 7 - pg_conftool 17 main set random_page_cost 100000 838s ok 8 - pg_ctlcluster 17 main reload 838s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 838s ok 10 - Expensive query is JITed 840s ok 11 - pg_dropcluster --stop 17 main 840s # Cleanup 840s ok 12 - Cleanup: No clusters left behind 840s ok 13 - No postgres processes left behind 840s ok 14 - No files in /etc/postgresql left behind 840s ok 15 - No files in /var/lib/postgresql left behind 840s ok 16 - No files in /var/run/postgresql left behind 840s ok 17 - No files in /var/log/postgresql left behind 840s ok 18 - PostgreSQL TCP ports are closed 840s ok 19 - Next free port is 5432 840s 1..19 840s ### End test 027_jit.t ### 840s 840s ### PostgreSQL test 030_errors.t ### 840s 1..156 840s ok 1 - pg_lscluster reports cluster without binaries 841s ok 2 - pg_dropcluster 6.3 main 842s ok 3 - pg_createcluster --socketdir 842s ok 4 - pg_lsclusters -h 842s ok 5 - cluster was created 842s ok 6 - Port of created cluster is 5432 842s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 17 main 842s ok 8 - pg_createcluster on existing cluster 842s ok 9 - pg_lsclusters -h 842s ok 10 - original cluster still exists 842s ok 11 - pg_createcluster 17 test -p foo 842s ok 12 - pg_createcluster -p checks that port option is numeric 842s ok 13 - pg_createcluster 17 test -p 42 842s ok 14 - pg_createcluster -p checks valid port range 842s ok 15 - pg_ctlcluster 17 main start 842s ok 16 - pg_ctlcluster refuses to start root-owned cluster 842s ok 17 - pg_ctlcluster 17 main start 842s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 842s ok 19 - pg_ctlcluster 17 main start 842s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 842s ok 21 - pg_ctlcluster 17 main start 842s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 844s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 844s ok 24 - No sockets in /var/run/postgresql 844s ok 25 - Socket is in /tmp/postgresql-testsuite/ 844s ok 26 - cluster stops with custom unix_socket_dir 844s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 847s ok 28 - cluster starts after removing unix_socket_dir 847s ok 29 - Socket is in default dir /var/run/postgresql 847s ok 30 - No sockets in /tmp/postgresql-testsuite/ 847s ok 31 - pg_ctlcluster 17 main stop 847s ok 32 - pg_ctlcluster fails with corrupted PID file 847s ok 33 - pg_lsclusters -h 847s ok 34 - cluster is still online 847s ok 35 - pg_ctlcluster succeeds with restored PID file 847s ok 36 - pg_lsclusters -h 847s ok 37 - cluster is down 847s ok 38 - pg_ctlcluster 17 main stop 847s ok 39 - pg_ctlcluster stop fails on stopped cluster 849s ok 40 - pg_ctlcluster 17 main start 849s ok 41 - pg_ctlcluster succeeds with already existing PID file 849s ok 42 - pg_lsclusters -h 849s ok 43 - cluster is online 849s ok 44 - pg_ctlcluster stop succeeds 849s ok 45 - pg_lsclusters -h 849s ok 46 - cluster is down 849s ok 47 - no pid file left 849s ok 48 - pg_ctlcluster 17 main stop 849s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 849s ok 50 - pid file was cleaned up 850s ok 51 - pg_ctlcluster --force 17 main stop 850s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 850s ok 53 - pid file was cleaned up 850s ok 54 - pg_ctlcluster 17 main stop 850s ok 55 - pg_ctlcluster stop succeeds with stale PID file 850s ok 56 - pid file was cleaned up 850s ok 57 - pg_ctlcluster --force 17 main stop 850s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 850s ok 59 - pid file was cleaned up 850s ok 60 - pg_ctlcluster --force 17 main stop 850s ok 61 - pg_ctlcluster stop succeeds with empty PID file 850s ok 62 - pid file was cleaned up 852s ok 63 - pg_ctlcluster 17 main start 852s ok 64 - pg_ctlcluster succeeds with corrupted PID file 852s ok 65 - pg_lsclusters -h 852s ok 66 - cluster is online 852s ok 67 - pg_ctlcluster 17 main start 852s ok 68 - pg_ctlcluster start fails on running cluster 852s ok 69 - pg_ctlcluster stop 852s ok 70 - pg_ctlcluster 17 main start 852s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 852s ok 72 - pg_ctlcluster 17 main stop 852s ok 73 - stopping cluster 859s ok 74 - pg_ctlcluster 17 main start 859s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 859s ok 76 - pg_ctlcluster 17 main stop 859s ok 77 - stopping cluster 859s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 859s ok 79 - pg_dropcluster 17 main 859s ok 80 - pg_dropcluster works as user postgres 860s ok 81 - pg_createcluster succeeds 860s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 860s ok 83 - proper error message for nonexisting /var/lib/postgresql 862s ok 84 - pg_ctlcluster 17 main start 862s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 862s ok 86 - pg_ctlcluster 17 main stop 862s ok 87 - stopping cluster 863s ok 88 - pg_createcluster other 865s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 867s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 868s ok 91 868s ok 92 - pg_ctlcluster 17 other start 868s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 868s ok 94 - pg_ctlcluster 17 main stop 868s ok 95 - stopping main cluster 870s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 872s ok 97 - pg_dropcluster other 873s ok 98 - pg_dropcluster 873s ok 99 - No sockets any more 873s ok 100 - 'pg_lsclusters 4.5 foo' fails 873s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 873s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 873s ok 103 - 'psql --cluster 4.5/foo' fails 873s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 873s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 873s ok 106 - 'psql --cluster 17/foo' fails 873s ok 107 - psql --cluster 17/foo gives error message about nonexisting cluster 873s ok 108 - psql --cluster 17/foo does not print 'invalid symbolic link' gibberish 873s ok 109 - 'pg_dropcluster 4.5 foo' fails 873s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 873s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 873s ok 112 - 'pg_dropcluster 17 foo' fails 873s ok 113 - pg_dropcluster 17 foo gives error message about nonexisting cluster 873s ok 114 - pg_dropcluster 17 foo does not print 'invalid symbolic link' gibberish 873s ok 115 - 'pg_upgradecluster 4.5 foo' fails 873s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 873s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 873s ok 118 - 'pg_upgradecluster 17 foo' fails 873s ok 119 - pg_upgradecluster 17 foo gives error message about nonexisting cluster 873s ok 120 - pg_upgradecluster 17 foo does not print 'invalid symbolic link' gibberish 873s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 873s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 873s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 873s ok 124 - 'pg_ctlcluster 17 foo stop' fails 873s ok 125 - pg_ctlcluster 17 foo stop gives error message about nonexisting cluster 873s ok 126 - pg_ctlcluster 17 foo stop does not print 'invalid symbolic link' gibberish 873s # Cleanup 873s ok 127 - Cleanup: No clusters left behind 873s ok 128 - No postgres processes left behind 873s ok 129 - No files in /etc/postgresql left behind 873s ok 130 - No files in /var/lib/postgresql left behind 873s ok 131 - No files in /var/run/postgresql left behind 873s ok 132 - No files in /var/log/postgresql left behind 873s ok 133 - PostgreSQL TCP ports are closed 873s ok 134 - Next free port is 5432 874s ok 135 - pg_dropcluster 17 broken 874s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 874s # Cleanup 874s ok 137 - Cleanup: No clusters left behind 874s ok 138 - No postgres processes left behind 874s ok 139 - No files in /etc/postgresql left behind 874s ok 140 - No files in /var/lib/postgresql left behind 874s ok 141 - No files in /var/run/postgresql left behind 874s ok 142 - No files in /var/log/postgresql left behind 874s ok 143 - PostgreSQL TCP ports are closed 874s ok 144 - Next free port is 5432 876s ok 145 - pg_dropcluster 17 broken 876s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 876s ok 147 - /etc/postgresql/17 was removed 876s ok 148 - /var/lib/postgresql/17 was removed 876s # Cleanup 876s ok 149 - Cleanup: No clusters left behind 876s ok 150 - No postgres processes left behind 876s ok 151 - No files in /etc/postgresql left behind 876s ok 152 - No files in /var/lib/postgresql left behind 876s ok 153 - No files in /var/run/postgresql left behind 876s ok 154 - No files in /var/log/postgresql left behind 876s ok 155 - PostgreSQL TCP ports are closed 876s ok 156 - Next free port is 5432 876s ### End test 030_errors.t ### 876s 876s ### PostgreSQL test 031_errors_disk_full.t ### 876s 1..22 876s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 877s ok 1 - script failed 877s ok 2 - pg_createcluster fails due to insufficient disk space 877s ok 3 - does not leave files behind 877s # Cleanup 877s ok 4 - Cleanup: No clusters left behind 877s ok 5 - No postgres processes left behind 877s ok 6 - No files in /etc/postgresql left behind 877s ok 7 - No files in /var/lib/postgresql left behind 877s ok 8 - No files in /var/run/postgresql left behind 877s ok 9 - No files in /var/log/postgresql left behind 877s ok 10 - PostgreSQL TCP ports are closed 877s ok 11 - Next free port is 5432 877s # check disk full conditions on startup 879s ok 12 - script failed 879s ok 13 - pg_ctlcluster prints error message 879s ok 14 - log file has error message 879s # Cleanup 879s ok 15 - Cleanup: No clusters left behind 880s ok 16 - No postgres processes left behind 880s ok 17 - No files in /etc/postgresql left behind 880s ok 18 - No files in /var/lib/postgresql left behind 880s ok 19 - No files in /var/run/postgresql left behind 880s ok 20 - No files in /var/log/postgresql left behind 880s ok 21 - PostgreSQL TCP ports are closed 880s ok 22 - Next free port is 5432 880s ### End test 031_errors_disk_full.t ### 880s 880s ### PostgreSQL test 032_ssl_key_permissions.t ### 880s 1..22 880s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 880s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 880s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 880s # 17 (17.2-1) 880s ok 4 - pg_createcluster 17 main 881s ok 5 - pg_ctlcluster 17 main start 881s ok 6 - ssl key owned by nobody refused 881s ok 7 - pg_ctlcluster 17 main start 881s ok 8 - ssl key with permissions root:root 0644 refused 881s ok 9 - pg_ctlcluster 17 main start 881s ok 10 - ssl key with permissions postgres:postgres 0640 refused 882s ok 11 - pg_dropcluster 17 main --stop 882s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 882s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 882s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 882s # Cleanup 882s ok 15 - Cleanup: No clusters left behind 882s ok 16 - No postgres processes left behind 882s ok 17 - No files in /etc/postgresql left behind 882s ok 18 - No files in /var/lib/postgresql left behind 882s ok 19 - No files in /var/run/postgresql left behind 882s ok 20 - No files in /var/log/postgresql left behind 882s ok 21 - PostgreSQL TCP ports are closed 882s ok 22 - Next free port is 5432 882s ### End test 032_ssl_key_permissions.t ### 882s 882s ### PostgreSQL test 040_upgrade.t ### 882s 1..1 882s ok 1 - only one major version installed, skipping upgrade tests 882s ### End test 040_upgrade.t ### 882s 882s ### PostgreSQL test 041_upgrade_custompaths.t ### 882s 1..1 882s ok 1 - only one major version installed, skipping upgrade tests 882s ### End test 041_upgrade_custompaths.t ### 882s 882s ### PostgreSQL test 042_upgrade_rename.t ### 882s 1..15 882s # PostgreSQL 17 885s ok 1 - pg_createcluster 17 main --start 891s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/17/bin -v 17 --rename upgr 17 main 891s ok 3 - pg_lsclusters -h 891s ok 4 - correct output of pg_lsclusters -h 892s ok 5 - pg_dropcluster 17 main --stop 894s ok 6 - pg_dropcluster 17 upgr --stop 894s ok 7 - Cleaning pg_upgrade log files 894s # Cleanup 894s ok 8 - Cleanup: No clusters left behind 894s ok 9 - No postgres processes left behind 894s ok 10 - No files in /etc/postgresql left behind 894s ok 11 - No files in /var/lib/postgresql left behind 894s ok 12 - No files in /var/run/postgresql left behind 894s ok 13 - No files in /var/log/postgresql left behind 894s ok 14 - PostgreSQL TCP ports are closed 894s ok 15 - Next free port is 5432 894s ### End test 042_upgrade_rename.t ### 894s 894s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 894s 1..1 894s ok 1 - only one major version installed, skipping upgrade tests 894s ### End test 043_upgrade_ssl_cert.t ### 894s 894s ### PostgreSQL test 045_backup.t ### 894s # We are running systemd 894s # PostgreSQL 17 894s # create cluster 897s ok 1 - pg_createcluster --locale en_US.UTF-8 17 main --start 897s ok 2 - pg_lsclusters -h 897s ok 3 - correct output of pg_lsclusters -h 897s ok 4 - pg_conftool 17 main set work_mem 11MB 897s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 897s ok 6 - psql -c 'alter database mydb set search_path=public' 897s ok 7 - psql -c 'create table foo (t text)' mydb 897s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 898s ok 9 - psql -c 'CREATE USER myuser' 898s ok 10 - psql -c 'grant create on database mydb to myuser' 898s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 898s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 898s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 898s # create directory 898s ok 14 - pg_backupcluster 17 main createdirectory 898s ok 15 - /var/backups/postgresql/17-main owned by uid postgres 898s ok 16 - /var/backups/postgresql/17-main owned by gid postgres 898s # dump 898s ok 17 - systemctl start pg_dump@17-main 898s ok 18 - dump created in /var/backups/postgresql/17-main/2025-01-19T045651Z.dump 898s ok 19 - /var/backups/postgresql/17-main/2025-01-19T045651Z.dump owned by uid postgres 898s ok 20 - /var/backups/postgresql/17-main/2025-01-19T045651Z.dump owned by gid postgres 898s # basebackup 898s ok 21 - systemctl start pg_receivewal@17-main 898s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 899s ok 23 - /var/backups/postgresql/17-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 899s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 899s ok 25 - psql -c 'select pg_reload_conf()' 926s ok 26 - systemctl start pg_basebackup@17-main 926s ok 27 - dump created in /var/backups/postgresql/17-main/2025-01-19T045652Z.backup 926s ok 28 - /var/backups/postgresql/17-main/2025-01-19T045652Z.backup owned by uid postgres 926s ok 29 - /var/backups/postgresql/17-main/2025-01-19T045652Z.backup owned by gid postgres 926s # list 926s ok 30 - pg_backupcluster 17 main list 926s ok 31 - correct output of pg_backupcluster 17 main list 926s # more database changes 926s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 926s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 927s ok 34 - retrieve recovery timestamp 927s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 927s ok 36 - systemctl stop pg_receivewal@17-main 927s # restore /var/backups/postgresql/17-main/2025-01-19T045651Z.dump 928s ok 37 - pg_dropcluster 17 main --stop 932s ok 38 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-19T045651Z.dump --start --datadir /var/lib/postgresql/17/snowflake 932s ok 39 - pg_lsclusters -h 932s ok 40 - correct output of pg_lsclusters -h 933s ok 41 - psql -XAtl 933s ok 42 - mydb locales 933s ok 43 - mydb grants 933s ok 44 - myicudb locales 933s ok 45 - psql -XAtc 'show work_mem' 933s ok 46 - correct output of psql -XAtc 'show work_mem' 933s ok 47 - psql -XAtc 'select * from foo' mydb 933s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 933s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 933s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 933s ok 51 - psql -XAtc '\drds' 933s ok 52 - correct output of psql -XAtc '\drds' 933s # restore /var/backups/postgresql/17-main/2025-01-19T045652Z.backup 934s ok 53 - pg_dropcluster 17 main --stop 937s ok 54 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-19T045652Z.backup --start --datadir /var/lib/postgresql/17/snowflake 937s ok 55 - pg_lsclusters -h 937s ok 56 - correct output of pg_lsclusters -h 938s ok 57 - psql -XAtl 938s ok 58 - mydb locales 938s ok 59 - mydb grants 938s ok 60 - myicudb locales 938s ok 61 - psql -XAtc 'show work_mem' 938s ok 62 - correct output of psql -XAtc 'show work_mem' 938s ok 63 - psql -XAtc 'select * from foo' mydb 938s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 938s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 938s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 938s ok 67 - psql -XAtc '\drds' 938s ok 68 - correct output of psql -XAtc '\drds' 938s # restore /var/backups/postgresql/17-main/2025-01-19T045652Z.backup with WAL archive 939s ok 69 - pg_dropcluster 17 main --stop 942s ok 70 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-19T045652Z.backup --start --archive --port 5430 943s ok 71 - pg_lsclusters -h 943s ok 72 - correct output of pg_lsclusters -h 943s ok 73 - psql -XAtc 'select * from foo order by t' mydb 943s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 943s # restore /var/backups/postgresql/17-main/2025-01-19T045652Z.backup with PITR 944s ok 75 - pg_dropcluster 17 main --stop 948s ok 76 - pg_restorecluster 17 main /var/backups/postgresql/17-main/2025-01-19T045652Z.backup --start --pitr '2025-01-19 04:57:20.00056+00 948s # ' 948s ok 77 - pg_lsclusters -h 948s ok 78 - correct output of pg_lsclusters -h 948s ok 79 - psql -XAtc 'select * from foo order by t' mydb 948s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 949s ok 81 - pg_dropcluster 17 main --stop 949s # Cleanup 949s ok 82 - Cleanup: No clusters left behind 949s ok 83 - No postgres processes left behind 949s ok 84 - No files in /etc/postgresql left behind 949s ok 85 - No files in /var/lib/postgresql left behind 949s ok 86 - No files in /var/run/postgresql left behind 949s ok 87 - No files in /var/log/postgresql left behind 949s ok 88 - PostgreSQL TCP ports are closed 949s ok 89 - Next free port is 5432 949s 1..89 949s ### End test 045_backup.t ### 949s 949s ### PostgreSQL test 050_encodings.t ### 949s 1..60 949s # Checking 17 ru_RU 952s ok 1 - pg_createcluster version 17 for ru_RU without --encoding succeeded 954s ok 2 - psql -l succeeds 954s ok 3 - template1 is not UTF-8 encoded 954s ok 4 - creating test database 954s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 954s # create table t (x varchar); copy t from stdin" test 954s ok 6 - creating table with ISO-8859-5 characters 954s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 954s ok 8 - correct string in UTF-8 954s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 954s ok 10 - correct string in ISO-8859-5 954s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 954s # delete from t; copy t from stdin" test 954s ok 12 - creating table with UTF-8 characters 954s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 954s ok 14 - correct string in UTF-8 954s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 954s ok 16 - correct string in ISO-8859-1 954s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 954s ok 18 - Server error message has correct language and encoding 956s ok 19 - pg_ctlcluster 17 ru_RU restart 956s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 958s ok 21 - Dropping cluster 958s # Checking 17 ru_RU.UTF-8 961s ok 22 - pg_createcluster version 17 for ru_RU.UTF-8 without --encoding succeeded 962s ok 23 - psql -l succeeds 962s ok 24 - template1 is UTF-8 encoded 962s ok 25 - creating test database 962s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 962s # create table t (x varchar); copy t from stdin" test 962s ok 27 - creating table with ISO-8859-5 characters 962s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 962s ok 29 - correct string in UTF-8 962s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 962s ok 31 - correct string in ISO-8859-5 962s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 962s # delete from t; copy t from stdin" test 962s ok 33 - creating table with UTF-8 characters 962s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 962s ok 35 - correct string in UTF-8 962s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 962s ok 37 - correct string in ISO-8859-1 962s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 962s ok 39 - Server error message has correct language and encoding 965s ok 40 - pg_ctlcluster 17 ru_RU.UTF8 restart 965s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 965s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 965s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 965s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 965s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 965s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 965s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 966s ok 48 - Dropping cluster 966s # Check 17 locale environment variables 969s ok 49 - pg_createcluster: LC_ALL dominates LANG 969s ok 50 - psql -Atl --cluster 17/main 969s ok 51 - template1 is ASCII encoded 971s ok 52 - Dropping cluster 971s # Cleanup 971s ok 53 - Cleanup: No clusters left behind 971s ok 54 - No postgres processes left behind 971s ok 55 - No files in /etc/postgresql left behind 971s ok 56 - No files in /var/lib/postgresql left behind 971s ok 57 - No files in /var/run/postgresql left behind 971s ok 58 - No files in /var/log/postgresql left behind 971s ok 59 - PostgreSQL TCP ports are closed 971s ok 60 - Next free port is 5432 971s ### End test 050_encodings.t ### 971s 971s ### PostgreSQL test 052_upgrade_encodings.t ### 971s 1..1 971s ok 1 - only one major version installed, skipping upgrade tests 971s ### End test 052_upgrade_encodings.t ### 971s 971s ### PostgreSQL test 060_obsolete_confparams.t ### 971s ok 1 - only one major version installed, skipping upgrade tests 971s 1..1 971s ### End test 060_obsolete_confparams.t ### 971s 971s ### PostgreSQL test 070_non_postgres_clusters.t ### 971s 1..40 972s ok 1 - pg_createcluster 17 main for owner nobody 972s ok 2 - pg_ctlcluster 17 main start 972s ok 3 - start refused when config and data owners mismatch 974s ok 4 - pg_ctlcluster succeeds with owner nobody 974s ok 5 - pg_lsclusters -h 974s ok 6 - pg_lsclusters shows running cluster 974s ok 7 - postgres is running as user nobody 974s ok 8 - ls /tmp/.s.PGSQL.* 974s ok 9 - socket is in /tmp 974s ok 10 - /var/run/postgresql is empty 974s ok 11 - conf dir is owned by user 974s ok 12 - conf dir is owned by user's primary group 974s ok 13 - files are owned by user 974s ok 14 - files are owned by user's primary group 974s ok 15 - log file has 0640 permissions 974s ok 16 - log file is owned by user 974s ok 17 - log file is owned by user's primary group 974s ok 18 - only one major version installed, skipping upgrade test 974s ok 19 - ... 974s ok 20 - ... 974s ok 21 - ... 974s ok 22 - ... 974s ok 23 - ... 974s ok 24 - ... 974s ok 25 - ... 974s ok 26 - ... 974s ok 27 - ... 974s ok 28 - ... 975s ok 29 - pg_dropcluster 975s ok 30 - pg_lsclusters -h 975s ok 31 - No clusters left 975s ok 32 - No postgres processes left 975s # Cleanup 975s ok 33 - Cleanup: No clusters left behind 975s ok 34 - No postgres processes left behind 975s ok 35 - No files in /etc/postgresql left behind 975s ok 36 - No files in /var/lib/postgresql left behind 975s ok 37 - No files in /var/run/postgresql left behind 975s ok 38 - No files in /var/log/postgresql left behind 975s ok 39 - PostgreSQL TCP ports are closed 975s ok 40 - Next free port is 5432 975s ### End test 070_non_postgres_clusters.t ### 975s 975s ### PostgreSQL test 080_start.conf.t ### 975s 1..73 976s ok 1 - pg_createcluster 17 main 976s # start.conf auto 976s ok 2 - get_cluster_start_conf returns auto 976s ok 3 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 976s ok 4 - start.conf contains auto 976s ok 5 - systemd generator links cluster 976s ok 6 - systemd generator links correct service file 979s ok 7 - /etc/init.d/postgresql start 17 979s ok 8 - correct output of /etc/init.d/postgresql start 17 979s ok 9 - pg_lsclusters -h 979s ok 10 - cluster is online 979s ok 11 - /etc/init.d/postgresql stop 17 979s ok 12 - correct output of /etc/init.d/postgresql stop 17 982s ok 13 - pg_lsclusters -h 982s ok 14 - cluster is down 982s # start.conf manual 982s ok 15 - get_cluster_start_conf returns manual 982s ok 16 - grep '^[^\\s\#]' /etc/postgresql/17/main/start.conf 982s ok 17 - start.conf contains manual 982s ok 18 - systemd generator doesn't link cluster 982s ok 19 - /etc/init.d/postgresql start 17 982s ok 20 - correct output of /etc/init.d/postgresql start 17 982s ok 21 - pg_lsclusters -h 982s ok 22 - cluster is down 984s ok 23 - pg_ctlcluster 17 main start 984s ok 24 - correct output of pg_ctlcluster 17 main start 984s ok 25 - pg_lsclusters -h 984s ok 26 - cluster is online 984s ok 27 - pg_ctlcluster 17 main stop 984s ok 28 - correct output of pg_ctlcluster 17 main stop 984s ok 29 - pg_lsclusters -h 984s ok 30 - cluster is down 984s # start.conf disabled 984s ok 31 - get_cluster_start_conf returns disabled 985s ok 32 - systemd generator doesn't link cluster 985s ok 33 - /etc/init.d/postgresql start 17 985s ok 34 - correct output of /etc/init.d/postgresql start 17 985s ok 35 - pg_lsclusters -h 985s ok 36 - cluster is down 985s ok 37 - pg_ctlcluster 17 main start 985s ok 38 - correct output of pg_ctlcluster 17 main start 985s ok 39 - pg_lsclusters -h 985s ok 40 - cluster is down 987s ok 41 - pg_ctlcluster 17 main start 987s ok 42 - correct output of pg_ctlcluster 17 main start 987s ok 43 - pg_lsclusters -h 987s ok 44 - cluster is online 987s ok 45 - pg_ctlcluster 17 main stop 987s ok 46 - correct output of pg_ctlcluster 17 main stop 987s ok 47 - pg_lsclusters -h 987s ok 48 - cluster is down 989s ok 49 - pg_ctlcluster 17 main start 989s ok 50 - correct output of pg_ctlcluster 17 main start 989s ok 51 - pg_lsclusters -h 989s ok 52 - cluster is online 989s # test upgrade 989s ok 53 - only one major version installed, skipping upgrade test 989s ok 54 - ... 989s ok 55 - get_cluster_start_conf for old cluster returns manual 989s ok 56 - get_cluster_start_conf for new cluster returns manual 989s ok 57 - ... 991s ok 58 - dropping upgraded cluster 991s ok 59 - pg_lsclusters -h 991s ok 60 - no clusters any more 991s ok 61 - pg_createcluster 17 main --start-conf foo 991s ok 62 - pg_createcluster checks --start-conf validity 991s ok 63 - pg_createcluster checks --start-conf manual 991s ok 64 - get_cluster_start_conf returns manual 992s ok 65 - dropping cluster 992s # Cleanup 992s ok 66 - Cleanup: No clusters left behind 992s ok 67 - No postgres processes left behind 992s ok 68 - No files in /etc/postgresql left behind 992s ok 69 - No files in /var/lib/postgresql left behind 992s ok 70 - No files in /var/run/postgresql left behind 992s ok 71 - No files in /var/log/postgresql left behind 992s ok 72 - PostgreSQL TCP ports are closed 992s ok 73 - Next free port is 5432 992s ### End test 080_start.conf.t ### 992s 992s ### PostgreSQL test 085_pg_ctl.conf.t ### 992s 1..33 992s ok 1 - prlimit --core=0:unlimited --pid=17529 992s ok 2 - set core file size to unlimited 992s ok 3 - sh -c 'ulimit -Hc' 992s ok 4 - core file size is unlimited 993s ok 5 - pg_createcluster 17 main 993s ok 6 - /etc/postgresql/17/main/pg_ctl.conf exists 995s ok 7 - pg_ctlcluster 17 main start 995s ok 8 - starting cluster as root 995s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 995s ok 10 - soft core size is 0 995s # hard core file size limit of root-started postgres process is unlimited 995s ok 11 - set pg_ctl default option to -c 998s ok 12 - pg_ctlcluster 17 main restart 998s ok 13 - restarting cluster as root 998s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 998s ok 15 - soft core size is unlimited 998s ok 16 - pg_ctlcluster 17 main stop 998s ok 17 - stopping cluster 998s ok 18 - restored pg_ctl default option 1000s ok 19 - pg_ctlcluster 17 main start -- -c 1000s ok 20 - starting cluster with -c on the command line as postgres 1000s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/17-main.pid 1000s ok 22 - soft core size is unlimited 1000s ok 23 - pg_ctlcluster 17 main stop 1000s ok 24 - stopping cluster 1002s ok 25 - dropping cluster 1002s # Cleanup 1002s ok 26 - Cleanup: No clusters left behind 1002s ok 27 - No postgres processes left behind 1002s ok 28 - No files in /etc/postgresql left behind 1002s ok 29 - No files in /var/lib/postgresql left behind 1002s ok 30 - No files in /var/run/postgresql left behind 1002s ok 31 - No files in /var/log/postgresql left behind 1002s ok 32 - PostgreSQL TCP ports are closed 1002s ok 33 - Next free port is 5432 1002s ### End test 085_pg_ctl.conf.t ### 1002s 1002s ### PostgreSQL test 090_multicluster.t ### 1002s 1..125 1003s ok 1 - pg_createcluster 17 old 1004s ok 2 - pg_createcluster 17 new1 1004s ok 3 - pg_createcluster 17 new2 1007s ok 4 - starting cluster 17/old 1009s ok 5 - starting cluster 17/new1 1011s ok 6 - starting cluster 17/new2 1011s ok 7 - pg_lsclusters -h | sort -k3 1011s ok 8 - clusters have the correct ports, skipping used 5433 1011s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 1011s ok 10 - createdb --version 1011s ok 11 - pg_wrapper selects port 5432 as default cluster 1011s ok 12 - createdb --cluster 17/new1 --version 1011s ok 13 - pg_wrapper --cluster works 1011s ok 14 - createdb --cluster 17/foo --version 1011s ok 15 - pg_wrapper --cluster errors out for invalid cluster 1011s ok 16 - createdb --cluster 17/new1 test 1011s ok 17 - correct output of createdb --cluster 17/new1 test 1011s ok 18 - psql -Atl --cluster 17/new1 1011s ok 19 - test db appears in cluster new1 1011s ok 20 - psql -Atl --cluster 17/new2 1011s ok 21 - test db does not appear in cluster new2 1011s ok 22 - psql -Atl 1011s ok 23 - test db does not appear in default cluster 1011s ok 24 - psql --cluster 17/127.0.0.1: -Atc 'show port' template1 1011s ok 25 - psql --cluster 17/127.0.0.1: defaults to port 5432 1011s ok 26 - createdb --cluster 17/127.0.0.1:5432 --version 1011s ok 27 - createdb --cluster 17/127.0.0.1:5432 uses latest client version 1011s ok 28 - psql -Atl --cluster 17/localhost:5434 1011s ok 29 - test db appears in cluster 17/localhost:5434 1012s ok 30 - psql -Atl --cluster 17/localhost:5440 1012s ok 31 - test db does not appear in cluster 17/localhost:5440 1012s ok 32 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:5435 1012s ok 33 - psql --cluster 17/localhost:5435 fails due to nonexisting port 1012s ok 34 - LC_MESSAGES=C psql -Atl --cluster 17/localhost:a 1012s ok 35 - psql --cluster 17/localhost:a fails due to invalid syntax 1012s ok 36 - LC_MESSAGES=C psql -Atl --cluster 17/doesnotexi.st 1012s ok 37 - psql --cluster 17/doesnotexi.st fails due to invalid syntax 1012s ok 38 - psql -Atl --cluster 6.4/localhost: 1012s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 1012s ok 40 - psql -Atl 1012s ok 41 - PGCLUSTER selection (1) 1012s ok 42 - psql -Atl 1012s ok 43 - PGCLUSTER selection (2) 1012s ok 44 - psql -l 1012s ok 45 - invalid PGCLUSTER value 1012s ok 46 - createdb --version 1012s ok 47 - PGCLUSTER network cluster selection (1) 1012s ok 48 - psql -Atl 1012s ok 49 - PGCLUSTER network cluster selection (2) 1012s ok 50 - psql -Atl 1012s ok 51 - PGCLUSTER network cluster selection (3) 1012s ok 52 - LC_MESSAGES=C psql -Atl 1012s ok 53 - psql --cluster 17/localhost:5435 fails due to nonexisting port 1012s ok 54 - psql -Atc "show port" template1 1012s ok 55 - PGPORT selection (1) 1012s ok 56 - psql -Atc "show port" template1 1012s ok 57 - PGPORT selection (2) 1012s ok 58 - createdb --version 1012s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 1012s ok 60 - psql -Atc "show port" template1 1012s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 1012s ok 62 - psql --cluster 17/new1 -Atc 'select current_database()' 1012s ok 63 - PGDATABASE environment variable works 1012s ok 64 - createdb --version 1012s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 1012s ok 66 - createdb --cluster 17/new1 --version 1012s ok 67 - pg_wrapper --cluster works with empty user_clusters 1012s ok 68 - createdb --version 1012s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 17 new1 *' 1012s ok 70 - psql -Atc "select current_database()" 1012s ok 71 - pg_wrapper selects correct database with user_clusters '* * 17 new1 test' 1012s ok 72 - psql -Atc 'select current_database()' 1012s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 1012s ok 74 - createdb --version 1012s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 1012s ok 76 - createdb --version 1012s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 1012s ok 78 - createdb --version 1012s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 1013s ok 80 - createdb --version 1013s ok 81 - pg_wrapper selects correct version with per-user user_clusters 1013s ok 82 - createdb --version 1013s ok 83 - pg_wrapper selects correct version with per-user user_clusters 1013s ok 84 - createdb --version 1013s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 1013s ok 86 - psql -Atl 1013s ok 87 - $PGHOST overrides user_clusters 1013s ok 88 - psql --cluster 17/localhost:5434 -Atc 'select current_database()' test 1013s ok 89 - --cluster overrides $PGHOST 1013s ok 90 - createdb --version 1013s ok 91 - pg_wrapper ignores invalid lines in user_clusters 1013s ok 92 - psql -Atc 'select current_database()' 1013s ok 93 - pg_service conf selection 1 1013s ok 94 - psql -Atc 'select current_database()' 1013s ok 95 - pg_service conf selection 2 1013s ok 96 - psql -Atc 'select current_database()' 1013s ok 97 - pg_service conf selection 3 1013s ok 98 - stopping cluster 17/old 1015s ok 99 - restarting cluster 17/old 1015s ok 100 - pg_lsclusters -h | sort -k3 1015s ok 101 - port of first cluster was successfully changed 1015s ok 102 - psql -l 1015s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 1015s ok 104 - psql -Atl --cluster 17/new1 1015s ok 105 - --cluster selects appropriate cluster 1015s ok 106 - psql -Atl -p 5434 1015s ok 107 - -p selects appropriate cluster 1015s ok 108 - psql -Atlp 5434 1015s ok 109 - -Atlp selects appropriate cluster 1015s ok 110 - psql -Atl --port 5434 1015s ok 111 - --port selects appropriate cluster 1016s ok 112 - env PGPORT=5434 psql -Atl 1016s ok 113 - $PGPORT selects appropriate cluster 1016s ok 114 - Restoring original /etc/postgresql-common/user_clusters 1017s ok 115 - dropping 17/new1 1019s ok 116 - dropping 17/new2 1020s ok 117 - dropping 17/old 1020s # Cleanup 1020s ok 118 - Cleanup: No clusters left behind 1020s ok 119 - No postgres processes left behind 1020s ok 120 - No files in /etc/postgresql left behind 1020s ok 121 - No files in /var/lib/postgresql left behind 1020s ok 122 - No files in /var/run/postgresql left behind 1020s ok 123 - No files in /var/log/postgresql left behind 1020s ok 124 - PostgreSQL TCP ports are closed 1020s ok 125 - Next free port is 5432 1020s ### End test 090_multicluster.t ### 1020s 1020s ### PostgreSQL test 110_integrate_cluster.t ### 1020s 1..32 1021s ok 1 - /usr/lib/postgresql/17/bin/initdb /tmp/0RcFhBCnWU/c/postgres 1021s ok 2 - creating raw initdb cluster for user postgres 1021s ok 3 - pg_createcluster 17 postgres -d /tmp/0RcFhBCnWU/c/postgres 1021s ok 4 - integrating postgres cluster 1021s ok 5 - pg_lsclusters 1021s ok 6 - correct pg_lsclusters output 1023s ok 7 - pg_ctlcluster 17 postgres start 1023s ok 8 - starting cluster postgres 1023s ok 9 - pg_lsclusters 1023s ok 10 - correct pg_lsclusters output 1025s ok 11 - dropping cluster postgres 1025s ok 12 - No files in temporary cluster dir left behind 1025s ok 13 - /usr/lib/postgresql/17/bin/initdb /tmp/0RcFhBCnWU/c/nobody 1025s ok 14 - creating raw initdb cluster for user nobody 1026s ok 15 - pg_createcluster 17 nobody -d /tmp/0RcFhBCnWU/c/nobody 1026s ok 16 - integrating nobody cluster 1026s ok 17 - pg_lsclusters 1026s ok 18 - correct pg_lsclusters output 1028s ok 19 - pg_ctlcluster 17 nobody start 1028s ok 20 - starting cluster nobody 1028s ok 21 - pg_lsclusters 1028s ok 22 - correct pg_lsclusters output 1029s ok 23 - dropping cluster nobody 1029s ok 24 - No files in temporary cluster dir left behind 1029s # Cleanup 1029s ok 25 - Cleanup: No clusters left behind 1029s ok 26 - No postgres processes left behind 1029s ok 27 - No files in /etc/postgresql left behind 1029s ok 28 - No files in /var/lib/postgresql left behind 1029s ok 29 - No files in /var/run/postgresql left behind 1029s ok 30 - No files in /var/log/postgresql left behind 1029s ok 31 - PostgreSQL TCP ports are closed 1029s ok 32 - Next free port is 5432 1029s ### End test 110_integrate_cluster.t ### 1029s 1029s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 1029s 1..1 1029s ok 1 - only one major version installed, skipping upgrade tests 1029s ### End test 120_pg_upgradecluster_scripts.t ### 1029s 1029s ### PostgreSQL test 130_nonroot_admin.t ### 1029s 1..22 1032s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 1032s ok 2 - pg_lsclusters -h 1032s ok 3 - correct output of pg_lsclusters -h 1032s ok 4 - psql -Atl 1032s ok 5 - correct output of psql -Atl 1032s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 1032s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 1032s # Cleanup 1032s ok 15 - Cleanup: No clusters left behind 1032s ok 16 - No postgres processes left behind 1032s ok 17 - No files in /etc/postgresql left behind 1032s ok 18 - No files in /var/lib/postgresql left behind 1032s ok 19 - No files in /var/run/postgresql left behind 1032s ok 20 - No files in /var/log/postgresql left behind 1032s ok 21 - PostgreSQL TCP ports are closed 1032s ok 22 - Next free port is 5432 1032s ### End test 130_nonroot_admin.t ### 1032s 1032s ### PostgreSQL test 135_pg_virtualenv.t ### 1033s 1..20 1037s ok 1 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1037s ok 2 - running pg_virtualenv as root 1040s ok 3 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1040s ok 4 - running pg_virtualenv as postgres 1043s ok 5 - pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1043s ok 6 - running pg_virtualenv as nobody 1046s ok 7 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1046s ok 8 - running fakeroot pg_virtualenv as root 1049s ok 9 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1049s ok 10 - running fakeroot pg_virtualenv as postgres 1052s ok 11 - fakeroot pg_virtualenv -v 17 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1052s ok 12 - running fakeroot pg_virtualenv as nobody 1052s # Cleanup 1052s ok 13 - Cleanup: No clusters left behind 1052s ok 14 - No postgres processes left behind 1052s ok 15 - No files in /etc/postgresql left behind 1052s ok 16 - No files in /var/lib/postgresql left behind 1052s ok 17 - No files in /var/run/postgresql left behind 1052s ok 18 - No files in /var/log/postgresql left behind 1052s ok 19 - PostgreSQL TCP ports are closed 1052s ok 20 - Next free port is 5432 1052s ### End test 135_pg_virtualenv.t ### 1052s 1052s ### PostgreSQL test 140_pg_config.t ### 1052s 1..38 1052s # Multiarch is enabled 1052s # checking version specific output for 17 1052s ok 1 - /usr/lib/postgresql/17/bin/pg_config --pgxs 1052s ok 2 - correct output of /usr/lib/postgresql/17/bin/pg_config --pgxs 1052s ok 3 - /usr/lib/postgresql/17/bin/pg_config --libdir 1052s ok 4 - correct output of /usr/lib/postgresql/17/bin/pg_config --libdir 1052s ok 5 - /usr/lib/postgresql/17/bin/pg_config --pkglibdir 1052s ok 6 - correct output of /usr/lib/postgresql/17/bin/pg_config --pkglibdir 1052s ok 7 - /usr/lib/postgresql/17/bin/pg_config --bindir 1052s ok 8 - correct output of /usr/lib/postgresql/17/bin/pg_config --bindir 1052s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/17/lib/pgxs/src/Makefile.global 1052s # checking pg_config output (should behave like version 17) 1052s ok 15 - pg_config 1052s ok 16 - correct output of pg_config 1052s ok 17 - pg_config --help 1052s ok 18 - correct output of pg_config --help 1052s ok 19 - pg_config --pgxs 1052s ok 20 - correct output of pg_config --pgxs 1052s ok 21 - pg_config --libdir 1052s ok 22 - correct output of pg_config --libdir 1052s ok 23 - pg_config --pkglibdir 1052s ok 24 - correct output of pg_config --pkglibdir 1052s ok 25 - pg_config --bindir 1052s ok 26 - correct output of pg_config --bindir 1052s # checking pg_config.libpq-dev output (should behave like version 17) 1052s ok 27 - pg_config.libpq-dev 1052s ok 28 - correct output of pg_config.libpq-dev 1052s ok 29 - pg_config.libpq-dev --help 1052s ok 30 - correct output of pg_config.libpq-dev --help 1052s ok 31 - pg_config.libpq-dev --pgxs 1052s ok 32 - correct output of pg_config.libpq-dev --pgxs 1052s ok 33 - pg_config.libpq-dev --libdir 1052s ok 34 - correct output of pg_config.libpq-dev --libdir 1052s ok 35 - pg_config.libpq-dev --pkglibdir 1052s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 1052s ok 37 - pg_config.libpq-dev --bindir 1052s ok 38 - correct output of pg_config.libpq-dev --bindir 1052s ### End test 140_pg_config.t ### 1052s 1052s ### PostgreSQL test 150_tsearch_stemming.t ### 1052s 1..37 1053s ok 1 - pg_updatedicts succeeded 1053s ok 2 - pg_updatedicts created en_us.affix 1053s ok 3 - pg_updatedicts created en_us.dict 1053s ok 4 - pg_updatedicts created 17 en_us.affix symlink 1053s ok 5 - pg_updatedicts created 17 en_us.dict symlink 1056s ok 6 - pg_createcluster 17 main 1056s ok 7 - createdb fts 1056s ok 8 - correct output of createdb fts 1056s ok 9 - creating en_US full text search configuration 1056s ok 10 - creating data table and search index 1056s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 1056s ok 12 - stem search of correct word 1056s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 1056s ok 14 - stem search of correct word 1056s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 1056s ok 16 - stem search of unknown word 1056s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 1056s ok 18 - full text search, exact word 1056s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 1056s ok 20 - full text search for word stem 1056s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 1056s ok 22 - full text search for word substring fails 1056s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 1056s ok 24 - full text search, exact unicode word 1056s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 1056s ok 26 - full text search for unicode word stem 1056s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 1056s ok 28 - full text search for unicode word substring fails 1058s ok 29 1058s # Cleanup 1058s ok 30 - Cleanup: No clusters left behind 1058s ok 31 - No postgres processes left behind 1058s ok 32 - No files in /etc/postgresql left behind 1058s ok 33 - No files in /var/lib/postgresql left behind 1058s ok 34 - No files in /var/run/postgresql left behind 1058s ok 35 - No files in /var/log/postgresql left behind 1058s ok 36 - PostgreSQL TCP ports are closed 1058s ok 37 - Next free port is 5432 1058s ### End test 150_tsearch_stemming.t ### 1058s 1058s ### PostgreSQL test 160_alternate_confroot.t ### 1058s 1..28 1061s ok 1 1061s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1061s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1061s ok 4 - pg_lsclusters -h 1061s ok 5 - correct output of pg_lsclusters -h 1061s ok 6 - psql -Atl 1061s ok 7 - correct output of psql -Atl 1061s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 1061s ok 9 - ... 1061s ok 10 - ... 1061s ok 11 - ... 1061s ok 12 - ... 1061s ok 13 - ... 1061s ok 14 - ... 1061s ok 15 - pg_dropcluster 17 test --stop 1061s ok 16 - correct output of pg_dropcluster 17 test --stop 1061s ok 17 - pg_lsclusters -h 1061s ok 18 - correct output of pg_lsclusters -h 1061s ok 19 - No files in root/data left behind 1061s ok 20 - No cruft in root dir left behind 1061s # Cleanup 1061s ok 21 - Cleanup: No clusters left behind 1061s ok 22 - No postgres processes left behind 1061s ok 23 - No files in /etc/postgresql left behind 1061s ok 24 - No files in /var/lib/postgresql left behind 1061s ok 25 - No files in /var/run/postgresql left behind 1061s ok 26 - No files in /var/log/postgresql left behind 1061s ok 27 - PostgreSQL TCP ports are closed 1061s ok 28 - Next free port is 5432 1061s ### End test 160_alternate_confroot.t ### 1061s 1061s ### PostgreSQL test 170_extensions.t ### 1061s # Running tests for 17 1064s ok 1 - pg_createcluster 17 main 1064s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 1064s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 1064s ok 4 - psql -qc 'CREATE EXTENSION "amcheck"' 1064s ok 5 - extension amcheck installs without error 1064s ok 6 - psql -qc 'DROP EXTENSION "amcheck"' 1064s ok 7 - extension amcheck removes without error 1064s ok 8 - psql -qc 'CREATE EXTENSION "autoinc"' 1064s ok 9 - extension autoinc installs without error 1064s ok 10 - psql -qc 'DROP EXTENSION "autoinc"' 1064s ok 11 - extension autoinc removes without error 1064s ok 12 - psql -qc 'CREATE EXTENSION "bloom"' 1064s ok 13 - extension bloom installs without error 1064s ok 14 - psql -qc 'DROP EXTENSION "bloom"' 1064s ok 15 - extension bloom removes without error 1064s ok 16 - psql -qc 'CREATE EXTENSION plperl' 1064s ok 17 - bool_plperl dependency plperl installs without error 1064s ok 18 - psql -qc 'CREATE EXTENSION "bool_plperl"' 1064s ok 19 - extension bool_plperl installs without error 1065s ok 20 - psql -qc 'DROP EXTENSION "bool_plperl"' 1065s ok 21 - extension bool_plperl removes without error 1065s ok 22 - psql -qc 'DROP EXTENSION plperl' 1065s ok 23 - bool_plperl dependency extension plperl removes without error 1065s ok 24 - psql -qc 'CREATE EXTENSION plperlu' 1065s ok 25 - bool_plperlu dependency plperlu installs without error 1065s ok 26 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 1065s ok 27 - extension bool_plperlu installs without error 1065s ok 28 - psql -qc 'DROP EXTENSION "bool_plperlu"' 1065s ok 29 - extension bool_plperlu removes without error 1065s ok 30 - psql -qc 'DROP EXTENSION plperlu' 1065s ok 31 - bool_plperlu dependency extension plperlu removes without error 1065s ok 32 - psql -qc 'CREATE EXTENSION "btree_gin"' 1065s ok 33 - extension btree_gin installs without error 1065s ok 34 - psql -qc 'DROP EXTENSION "btree_gin"' 1065s ok 35 - extension btree_gin removes without error 1065s ok 36 - psql -qc 'CREATE EXTENSION "btree_gist"' 1065s ok 37 - extension btree_gist installs without error 1065s ok 38 - psql -qc 'DROP EXTENSION "btree_gist"' 1065s ok 39 - extension btree_gist removes without error 1065s ok 40 - psql -qc 'CREATE EXTENSION "citext"' 1065s ok 41 - extension citext installs without error 1065s ok 42 - psql -qc 'DROP EXTENSION "citext"' 1065s ok 43 - extension citext removes without error 1065s ok 44 - psql -qc 'CREATE EXTENSION "cube"' 1065s ok 45 - extension cube installs without error 1065s ok 46 - psql -qc 'DROP EXTENSION "cube"' 1065s ok 47 - extension cube removes without error 1065s ok 48 - psql -qc 'CREATE EXTENSION "dblink"' 1065s ok 49 - extension dblink installs without error 1065s ok 50 - psql -qc 'DROP EXTENSION "dblink"' 1065s ok 51 - extension dblink removes without error 1065s ok 52 - psql -qc 'CREATE EXTENSION "dict_int"' 1065s ok 53 - extension dict_int installs without error 1065s ok 54 - psql -qc 'DROP EXTENSION "dict_int"' 1065s ok 55 - extension dict_int removes without error 1065s ok 56 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 1065s ok 57 - extension dict_xsyn installs without error 1065s ok 58 - psql -qc 'DROP EXTENSION "dict_xsyn"' 1065s ok 59 - extension dict_xsyn removes without error 1065s ok 60 - psql -qc 'CREATE EXTENSION cube' 1065s ok 61 - earthdistance dependency cube installs without error 1065s ok 62 - psql -qc 'CREATE EXTENSION "earthdistance"' 1065s ok 63 - extension earthdistance installs without error 1065s ok 64 - psql -qc 'DROP EXTENSION "earthdistance"' 1065s ok 65 - extension earthdistance removes without error 1066s ok 66 - psql -qc 'DROP EXTENSION cube' 1066s ok 67 - earthdistance dependency extension cube removes without error 1066s ok 68 - psql -qc 'CREATE EXTENSION "file_fdw"' 1066s ok 69 - extension file_fdw installs without error 1066s ok 70 - psql -qc 'DROP EXTENSION "file_fdw"' 1066s ok 71 - extension file_fdw removes without error 1066s ok 72 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 1066s ok 73 - extension fuzzystrmatch installs without error 1066s ok 74 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 1066s ok 75 - extension fuzzystrmatch removes without error 1066s ok 76 - psql -qc 'CREATE EXTENSION "hstore"' 1066s ok 77 - extension hstore installs without error 1066s ok 78 - psql -qc 'DROP EXTENSION "hstore"' 1066s ok 79 - extension hstore removes without error 1066s ok 80 - psql -qc 'CREATE EXTENSION hstore' 1066s ok 81 - hstore_plperl dependency hstore installs without error 1066s ok 82 - psql -qc 'CREATE EXTENSION plperl' 1066s ok 83 - hstore_plperl dependency plperl installs without error 1066s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 1066s ok 85 - extension hstore_plperl installs without error 1066s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperl"' 1066s ok 87 - extension hstore_plperl removes without error 1066s ok 88 - psql -qc 'DROP EXTENSION hstore' 1066s ok 89 - hstore_plperl dependency extension hstore removes without error 1066s ok 90 - psql -qc 'DROP EXTENSION plperl' 1066s ok 91 - hstore_plperl dependency extension plperl removes without error 1066s ok 92 - psql -qc 'CREATE EXTENSION hstore' 1066s ok 93 - hstore_plperlu dependency hstore installs without error 1066s ok 94 - psql -qc 'CREATE EXTENSION plperlu' 1066s ok 95 - hstore_plperlu dependency plperlu installs without error 1066s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 1066s ok 97 - extension hstore_plperlu installs without error 1066s ok 98 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 1066s ok 99 - extension hstore_plperlu removes without error 1066s ok 100 - psql -qc 'DROP EXTENSION hstore' 1066s ok 101 - hstore_plperlu dependency extension hstore removes without error 1066s ok 102 - psql -qc 'DROP EXTENSION plperlu' 1066s ok 103 - hstore_plperlu dependency extension plperlu removes without error 1066s ok 104 - psql -qc 'CREATE EXTENSION hstore' 1066s ok 105 - hstore_plpython3u dependency hstore installs without error 1066s ok 106 - psql -qc 'CREATE EXTENSION plpython3u' 1066s ok 107 - hstore_plpython3u dependency plpython3u installs without error 1066s ok 108 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 1066s ok 109 - extension hstore_plpython3u installs without error 1066s ok 110 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 1066s ok 111 - extension hstore_plpython3u removes without error 1066s ok 112 - psql -qc 'DROP EXTENSION hstore' 1066s ok 113 - hstore_plpython3u dependency extension hstore removes without error 1066s ok 114 - psql -qc 'DROP EXTENSION plpython3u' 1066s ok 115 - hstore_plpython3u dependency extension plpython3u removes without error 1067s ok 116 - psql -qc 'CREATE EXTENSION "insert_username"' 1067s ok 117 - extension insert_username installs without error 1067s ok 118 - psql -qc 'DROP EXTENSION "insert_username"' 1067s ok 119 - extension insert_username removes without error 1067s ok 120 - psql -qc 'CREATE EXTENSION "intagg"' 1067s ok 121 - extension intagg installs without error 1067s ok 122 - psql -qc 'DROP EXTENSION "intagg"' 1067s ok 123 - extension intagg removes without error 1067s ok 124 - psql -qc 'CREATE EXTENSION "intarray"' 1067s ok 125 - extension intarray installs without error 1067s ok 126 - psql -qc 'DROP EXTENSION "intarray"' 1067s ok 127 - extension intarray removes without error 1067s ok 128 - psql -qc 'CREATE EXTENSION "isn"' 1067s ok 129 - extension isn installs without error 1067s ok 130 - psql -qc 'DROP EXTENSION "isn"' 1067s ok 131 - extension isn removes without error 1067s ok 132 - psql -qc 'CREATE EXTENSION plperl' 1067s ok 133 - jsonb_plperl dependency plperl installs without error 1067s ok 134 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 1067s ok 135 - extension jsonb_plperl installs without error 1067s ok 136 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 1067s ok 137 - extension jsonb_plperl removes without error 1067s ok 138 - psql -qc 'DROP EXTENSION plperl' 1067s ok 139 - jsonb_plperl dependency extension plperl removes without error 1067s ok 140 - psql -qc 'CREATE EXTENSION plperlu' 1067s ok 141 - jsonb_plperlu dependency plperlu installs without error 1067s ok 142 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 1067s ok 143 - extension jsonb_plperlu installs without error 1067s ok 144 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 1067s ok 145 - extension jsonb_plperlu removes without error 1067s ok 146 - psql -qc 'DROP EXTENSION plperlu' 1067s ok 147 - jsonb_plperlu dependency extension plperlu removes without error 1067s ok 148 - psql -qc 'CREATE EXTENSION plpython3u' 1067s ok 149 - jsonb_plpython3u dependency plpython3u installs without error 1067s ok 150 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 1067s ok 151 - extension jsonb_plpython3u installs without error 1067s ok 152 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 1067s ok 153 - extension jsonb_plpython3u removes without error 1067s ok 154 - psql -qc 'DROP EXTENSION plpython3u' 1067s ok 155 - jsonb_plpython3u dependency extension plpython3u removes without error 1067s ok 156 - psql -qc 'CREATE EXTENSION "lo"' 1067s ok 157 - extension lo installs without error 1067s ok 158 - psql -qc 'DROP EXTENSION "lo"' 1067s ok 159 - extension lo removes without error 1068s ok 160 - psql -qc 'CREATE EXTENSION "ltree"' 1068s ok 161 - extension ltree installs without error 1068s ok 162 - psql -qc 'DROP EXTENSION "ltree"' 1068s ok 163 - extension ltree removes without error 1068s ok 164 - psql -qc 'CREATE EXTENSION ltree' 1068s ok 165 - ltree_plpython3u dependency ltree installs without error 1068s ok 166 - psql -qc 'CREATE EXTENSION plpython3u' 1068s ok 167 - ltree_plpython3u dependency plpython3u installs without error 1068s ok 168 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 1068s ok 169 - extension ltree_plpython3u installs without error 1068s ok 170 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 1068s ok 171 - extension ltree_plpython3u removes without error 1068s ok 172 - psql -qc 'DROP EXTENSION ltree' 1068s ok 173 - ltree_plpython3u dependency extension ltree removes without error 1068s ok 174 - psql -qc 'DROP EXTENSION plpython3u' 1068s ok 175 - ltree_plpython3u dependency extension plpython3u removes without error 1068s ok 176 - psql -qc 'CREATE EXTENSION "moddatetime"' 1068s ok 177 - extension moddatetime installs without error 1068s ok 178 - psql -qc 'DROP EXTENSION "moddatetime"' 1068s ok 179 - extension moddatetime removes without error 1068s ok 180 - psql -qc 'CREATE EXTENSION "pageinspect"' 1068s ok 181 - extension pageinspect installs without error 1068s ok 182 - psql -qc 'DROP EXTENSION "pageinspect"' 1068s ok 183 - extension pageinspect removes without error 1068s ok 184 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 1068s ok 185 - extension pg_buffercache installs without error 1068s ok 186 - psql -qc 'DROP EXTENSION "pg_buffercache"' 1068s ok 187 - extension pg_buffercache removes without error 1068s ok 188 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 1068s ok 189 - extension pg_freespacemap installs without error 1068s ok 190 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 1068s ok 191 - extension pg_freespacemap removes without error 1068s ok 192 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 1068s ok 193 - extension pg_prewarm installs without error 1068s ok 194 - psql -qc 'DROP EXTENSION "pg_prewarm"' 1068s ok 195 - extension pg_prewarm removes without error 1068s ok 196 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 1068s ok 197 - extension pg_stat_statements installs without error 1068s ok 198 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 1068s ok 199 - extension pg_stat_statements removes without error 1068s ok 200 - psql -qc 'CREATE EXTENSION "pg_surgery"' 1068s ok 201 - extension pg_surgery installs without error 1068s ok 202 - psql -qc 'DROP EXTENSION "pg_surgery"' 1068s ok 203 - extension pg_surgery removes without error 1068s ok 204 - psql -qc 'CREATE EXTENSION "pg_trgm"' 1068s ok 205 - extension pg_trgm installs without error 1069s ok 206 - psql -qc 'DROP EXTENSION "pg_trgm"' 1069s ok 207 - extension pg_trgm removes without error 1069s ok 208 - psql -qc 'CREATE EXTENSION "pg_visibility"' 1069s ok 209 - extension pg_visibility installs without error 1069s ok 210 - psql -qc 'DROP EXTENSION "pg_visibility"' 1069s ok 211 - extension pg_visibility removes without error 1069s ok 212 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 1069s ok 213 - extension pg_walinspect installs without error 1069s ok 214 - psql -qc 'DROP EXTENSION "pg_walinspect"' 1069s ok 215 - extension pg_walinspect removes without error 1069s ok 216 - psql -qc 'CREATE EXTENSION "pgcrypto"' 1069s ok 217 - extension pgcrypto installs without error 1069s ok 218 - psql -qc 'DROP EXTENSION "pgcrypto"' 1069s ok 219 - extension pgcrypto removes without error 1069s ok 220 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 1069s ok 221 - extension pgrowlocks installs without error 1069s ok 222 - psql -qc 'DROP EXTENSION "pgrowlocks"' 1069s ok 223 - extension pgrowlocks removes without error 1069s ok 224 - psql -qc 'CREATE EXTENSION "pgstattuple"' 1069s ok 225 - extension pgstattuple installs without error 1069s ok 226 - psql -qc 'DROP EXTENSION "pgstattuple"' 1069s ok 227 - extension pgstattuple removes without error 1069s ok 228 - psql -qc 'CREATE EXTENSION "plperl"' 1069s ok 229 - extension plperl installs without error 1069s ok 230 - psql -qc 'DROP EXTENSION "plperl"' 1069s ok 231 - extension plperl removes without error 1069s ok 232 - psql -qc 'CREATE EXTENSION "plperlu"' 1069s ok 233 - extension plperlu installs without error 1069s ok 234 - psql -qc 'DROP EXTENSION "plperlu"' 1069s ok 235 - extension plperlu removes without error 1069s ok 236 - psql -qc 'CREATE EXTENSION "plpython3u"' 1069s ok 237 - extension plpython3u installs without error 1069s ok 238 - psql -qc 'DROP EXTENSION "plpython3u"' 1069s ok 239 - extension plpython3u removes without error 1069s ok 240 - psql -qc 'CREATE EXTENSION "pltcl"' 1069s ok 241 - extension pltcl installs without error 1069s ok 242 - psql -qc 'DROP EXTENSION "pltcl"' 1069s ok 243 - extension pltcl removes without error 1069s ok 244 - psql -qc 'CREATE EXTENSION "pltclu"' 1069s ok 245 - extension pltclu installs without error 1069s ok 246 - psql -qc 'DROP EXTENSION "pltclu"' 1069s ok 247 - extension pltclu removes without error 1069s ok 248 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 1069s ok 249 - extension postgres_fdw installs without error 1069s ok 250 - psql -qc 'DROP EXTENSION "postgres_fdw"' 1069s ok 251 - extension postgres_fdw removes without error 1069s ok 252 - psql -qc 'CREATE EXTENSION "refint"' 1069s ok 253 - extension refint installs without error 1070s ok 254 - psql -qc 'DROP EXTENSION "refint"' 1070s ok 255 - extension refint removes without error 1070s ok 256 - psql -qc 'CREATE EXTENSION "seg"' 1070s ok 257 - extension seg installs without error 1070s ok 258 - psql -qc 'DROP EXTENSION "seg"' 1070s ok 259 - extension seg removes without error 1070s ok 260 - psql -qc 'CREATE EXTENSION "sslinfo"' 1070s ok 261 - extension sslinfo installs without error 1070s ok 262 - psql -qc 'DROP EXTENSION "sslinfo"' 1070s ok 263 - extension sslinfo removes without error 1070s ok 264 - psql -qc 'CREATE EXTENSION "tablefunc"' 1070s ok 265 - extension tablefunc installs without error 1070s ok 266 - psql -qc 'DROP EXTENSION "tablefunc"' 1070s ok 267 - extension tablefunc removes without error 1070s ok 268 - psql -qc 'CREATE EXTENSION "tcn"' 1070s ok 269 - extension tcn installs without error 1070s ok 270 - psql -qc 'DROP EXTENSION "tcn"' 1070s ok 271 - extension tcn removes without error 1070s ok 272 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 1070s ok 273 - extension tsm_system_rows installs without error 1070s ok 274 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 1070s ok 275 - extension tsm_system_rows removes without error 1070s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 1070s ok 277 - extension tsm_system_time installs without error 1070s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_time"' 1070s ok 279 - extension tsm_system_time removes without error 1070s ok 280 - psql -qc 'CREATE EXTENSION "unaccent"' 1070s ok 281 - extension unaccent installs without error 1070s ok 282 - psql -qc 'DROP EXTENSION "unaccent"' 1070s ok 283 - extension unaccent removes without error 1070s ok 284 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 1070s ok 285 - extension uuid-ossp installs without error 1070s ok 286 - psql -qc 'DROP EXTENSION "uuid-ossp"' 1070s ok 287 - extension uuid-ossp removes without error 1070s ok 288 - psql -qc 'CREATE EXTENSION "xml2"' 1070s ok 289 - extension xml2 installs without error 1070s ok 290 - psql -qc 'DROP EXTENSION "xml2"' 1070s ok 291 - extension xml2 removes without error 1072s ok 292 - pg_dropcluster 17 main 1072s # Cleanup 1072s ok 293 - Cleanup: No clusters left behind 1072s ok 294 - No postgres processes left behind 1072s ok 295 - No files in /etc/postgresql left behind 1072s ok 296 - No files in /var/lib/postgresql left behind 1072s ok 297 - No files in /var/run/postgresql left behind 1072s ok 298 - No files in /var/log/postgresql left behind 1072s ok 299 - PostgreSQL TCP ports are closed 1072s ok 300 - Next free port is 5432 1072s 1..300 1072s ### End test 170_extensions.t ### 1072s 1072s ### PostgreSQL test 180_ecpg.t ### 1072s 1..14 1072s ok 1 - ecpg test.pgc 1072s ok 2 - ecpg processing 1072s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 1072s ok 4 - compiling ecpg output 1079s ok 5 - pg_virtualenv /tmp/tmp.2qMRydpUzw/test 1079s ok 6 - test program runs and gives correct output 1079s # Cleanup 1079s ok 7 - Cleanup: No clusters left behind 1079s ok 8 - No postgres processes left behind 1079s ok 9 - No files in /etc/postgresql left behind 1079s ok 10 - No files in /var/lib/postgresql left behind 1079s ok 11 - No files in /var/run/postgresql left behind 1079s ok 12 - No files in /var/log/postgresql left behind 1079s ok 13 - PostgreSQL TCP ports are closed 1079s ok 14 - Next free port is 5432 1079s ### End test 180_ecpg.t ### 1079s 1079s ### PostgreSQL test 190_pg_buildext.t ### 1079s ok 1 - make clean 1079s ok 2 - make tar 1079s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 1079s # testing 'dh --with pgxs' 1082s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 1082s ok 5 - postgresql-17-foo_123-1_amd64.deb was built 1089s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 1089s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=17 dh_pgxs_test 1090s ok 8 - dpkg -i postgresql-17-foo_123-1_amd64.deb 1097s ok 9 - cd foo-123 && pg_buildext installcheck 1097s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 1104s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1104s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1111s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1111s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1111s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 1111s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 1111s ok 17 - dpkg -r postgresql-17-foo 1111s # testing 'dh --with pgxs_loop' 1111s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 1114s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc -Ppkg.postgresql.32-bit 1114s ok 20 - postgresql-17-foo_123-1_amd64.deb was built 1114s ok 21 - make clean 1114s # testing pg_buildext updatecontrol 1114s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 1114s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 1114s 1..23 1114s ### End test 190_pg_buildext.t ### 1114s 1114s ### PostgreSQL test 200_maintscripts.t ### 1115s 1..15 1115s # We are running systemd 1118s ok 1 - pg_createcluster 17 main --start 1118s ok 2 - postmaster PID is 24156 1121s ok 3 - apt-get update -q 1121s # postgresql-common: 1121s # Installed: 267 1121s # Candidate: 267 1121s # Version table: 1121s # *** 267 500 1121s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 1121s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 1121s # 100 /var/lib/dpkg/status 1125s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 1125s # postgresql-common: 1125s # Installed: 267 1125s # Candidate: 267 1125s # Version table: 1125s # *** 267 500 1125s # 500 http://ftpmaster.internal/ubuntu plucky/main amd64 Packages 1125s # 500 http://ftpmaster.internal/ubuntu plucky/main i386 Packages 1125s # 100 /var/lib/dpkg/status 1125s ok 5 - postmaster PID is 24156 1125s ok 6 - postmaster was not restarted 1127s ok 7 - pg_dropcluster 17 main --stop 1127s # Cleanup 1127s ok 8 - Cleanup: No clusters left behind 1127s ok 9 - No postgres processes left behind 1127s ok 10 - No files in /etc/postgresql left behind 1127s ok 11 - No files in /var/lib/postgresql left behind 1127s ok 12 - No files in /var/run/postgresql left behind 1127s ok 13 - No files in /var/log/postgresql left behind 1127s ok 14 - PostgreSQL TCP ports are closed 1127s ok 15 - Next free port is 5432 1127s ### End test 200_maintscripts.t ### 1127s 1127s autopkgtest [05:00:40]: test run-testsuite: -----------------------] 1128s run-testsuite PASS 1128s autopkgtest [05:00:41]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 1128s autopkgtest [05:00:41]: @@@@@@@@@@@@@@@@@@@@ summary 1128s default-psql FAIL non-zero exit status 2 1128s run-testsuite PASS 1427s nova [W] Skipping flock for amd64 1427s Creating nova instance adt-plucky-amd64-postgresql-common-20250119-044153-juju-7f2275-prod-proposed-migration-environment-15-c1ffe59f-f4e5-42d6-a5fd-7d2e1ff7970e from image adt/ubuntu-plucky-amd64-server-20250119.img (UUID 7982e7e7-53fc-4a89-b206-09501ed3ffd2)... 1427s nova [W] Timed out waiting for fb0731b1-5bc8-4449-aff9-2004d4c2c1a7 to get deleted. 1427s nova [W] Skipping flock for amd64 1427s Creating nova instance adt-plucky-amd64-postgresql-common-20250119-044153-juju-7f2275-prod-proposed-migration-environment-15-c1ffe59f-f4e5-42d6-a5fd-7d2e1ff7970e from image adt/ubuntu-plucky-amd64-server-20250119.img (UUID 7982e7e7-53fc-4a89-b206-09501ed3ffd2)...