0s autopkgtest [18:19:26]: starting date and time: 2024-06-28 18:19:26+0000 0s autopkgtest [18:19:26]: git checkout: 85adf9a1 setup-testbed: prevent /tmp from getting a tmpfs mount 0s autopkgtest [18:19:26]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.6stqtw7i/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.39-3.1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@lcy02-25.secgroup --name adt-oracular-amd64-postgresql-common-20240628-181925-juju-7f2275-prod-proposed-migration-environment-2-ef062626-8be9-4e3e-aed4-f0525708472d --image adt/ubuntu-oracular-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 119s autopkgtest [18:21:25]: testbed dpkg architecture: amd64 119s autopkgtest [18:21:25]: testbed apt version: 2.9.5 119s autopkgtest [18:21:25]: @@@@@@@@@@@@@@@@@@@@ test bed setup 120s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 120s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [365 kB] 120s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 120s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2576 B] 120s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [48.3 kB] 120s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages [82.7 kB] 120s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages [101 kB] 120s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted amd64 Packages [28.0 kB] 120s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted i386 Packages [6244 B] 120s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe i386 Packages [227 kB] 120s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 Packages [403 kB] 120s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse amd64 Packages [7968 B] 120s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse i386 Packages [3368 B] 121s Fetched 1393 kB in 0s (4411 kB/s) 121s Reading package lists... 124s Reading package lists... 125s Building dependency tree... 125s Reading state information... 125s Calculating upgrade... 126s The following packages will be upgraded: 126s base-files libc-bin libc-dev-bin libc-devtools libc6 libc6-dev locales 126s motd-news-config 126s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 126s Need to get 10.4 MB of archives. 126s After this operation, 35.8 kB of additional disk space will be used. 126s Get:1 http://ftpmaster.internal/ubuntu oracular/main amd64 motd-news-config all 13.3ubuntu2 [5416 B] 126s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-devtools amd64 2.39-3.1ubuntu2 [29.3 kB] 126s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc6-dev amd64 2.39-3.1ubuntu2 [2120 kB] 126s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-dev-bin amd64 2.39-3.1ubuntu2 [20.4 kB] 126s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 base-files amd64 13.3ubuntu2 [75.3 kB] 126s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc6 amd64 2.39-3.1ubuntu2 [3261 kB] 126s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-bin amd64 2.39-3.1ubuntu2 [680 kB] 126s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 locales all 2.39-3.1ubuntu2 [4220 kB] 127s Preconfiguring packages ... 127s Fetched 10.4 MB in 0s (45.8 MB/s) 127s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 74417 files and directories currently installed.) 127s Preparing to unpack .../motd-news-config_13.3ubuntu2_all.deb ... 127s Unpacking motd-news-config (13.3ubuntu2) over (13.1ubuntu1) ... 127s Preparing to unpack .../libc-devtools_2.39-3.1ubuntu2_amd64.deb ... 127s Unpacking libc-devtools (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 127s Preparing to unpack .../libc6-dev_2.39-3.1ubuntu2_amd64.deb ... 127s Unpacking libc6-dev:amd64 (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 128s Preparing to unpack .../libc-dev-bin_2.39-3.1ubuntu2_amd64.deb ... 128s Unpacking libc-dev-bin (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 128s Preparing to unpack .../base-files_13.3ubuntu2_amd64.deb ... 128s Unpacking base-files (13.3ubuntu2) over (13.1ubuntu1) ... 128s Setting up base-files (13.3ubuntu2) ... 128s Updating /etc/profile to current default. 129s motd-news.service is a disabled or a static unit not running, not starting it. 129s (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 ... 74420 files and directories currently installed.) 129s Preparing to unpack .../libc6_2.39-3.1ubuntu2_amd64.deb ... 129s Unpacking libc6:amd64 (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 130s Setting up libc6:amd64 (2.39-3.1ubuntu2) ... 130s (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 ... 74420 files and directories currently installed.) 130s Preparing to unpack .../libc-bin_2.39-3.1ubuntu2_amd64.deb ... 130s Unpacking libc-bin (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 130s Setting up libc-bin (2.39-3.1ubuntu2) ... 130s (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 ... 74420 files and directories currently installed.) 130s Preparing to unpack .../locales_2.39-3.1ubuntu2_all.deb ... 130s Unpacking locales (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 131s Setting up motd-news-config (13.3ubuntu2) ... 131s Setting up locales (2.39-3.1ubuntu2) ... 132s Generating locales (this might take a while)... 133s en_US.UTF-8... done 133s Generation complete. 133s Setting up libc-dev-bin (2.39-3.1ubuntu2) ... 133s Setting up libc-devtools (2.39-3.1ubuntu2) ... 133s Setting up libc6-dev:amd64 (2.39-3.1ubuntu2) ... 133s Processing triggers for man-db (2.12.1-2) ... 136s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-1ubuntu7) ... 136s update-initramfs: deferring update (trigger activated) 136s Processing triggers for install-info (7.1-3build2) ... 136s Processing triggers for initramfs-tools (0.142ubuntu28) ... 136s update-initramfs: Generating /boot/initrd.img-6.8.0-31-generic 136s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 148s Reading package lists... 149s Building dependency tree... 149s Reading state information... 149s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 150s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 150s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 150s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 150s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 151s Reading package lists... 151s Reading package lists... 152s Building dependency tree... 152s Reading state information... 152s Calculating upgrade... 153s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 153s Reading package lists... 153s Building dependency tree... 153s Reading state information... 154s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 154s autopkgtest [18:22:00]: rebooting testbed after setup commands that affected boot 158s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 180s autopkgtest [18:22:26]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 185s autopkgtest [18:22:31]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 189s Get:1 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (dsc) [2383 B] 189s Get:2 http://ftpmaster.internal/ubuntu oracular/main postgresql-common 260 (tar) [218 kB] 190s gpgv: Signature made Thu May 9 15:21:37 2024 UTC 190s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 190s gpgv: Can't check signature: No public key 190s dpkg-source: warning: cannot verify inline signature for ./postgresql-common_260.dsc: no acceptable signature found 190s autopkgtest [18:22:36]: testing package postgresql-common version 260 190s autopkgtest [18:22:36]: build not needed 190s autopkgtest [18:22:36]: test default-psql: preparing testbed 192s Reading package lists... 192s Building dependency tree... 192s Reading state information... 193s Starting pkgProblemResolver with broken count: 0 193s Starting 2 pkgProblemResolver with broken count: 0 193s Done 194s The following additional packages will be installed: 194s libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 postgresql-client-16 194s postgresql-client-common postgresql-common ssl-cert 194s Suggested packages: 194s postgresql-doc postgresql-doc-16 194s Recommended packages: 194s libjson-xs-perl 194s The following NEW packages will be installed: 194s autopkgtest-satdep libjson-perl libpq5 libxslt1.1 postgresql postgresql-16 194s postgresql-client-16 postgresql-client-common postgresql-common ssl-cert 194s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 194s Need to get 17.4 MB/17.4 MB of archives. 194s After this operation, 51.2 MB of additional disk space will be used. 194s Get:1 /tmp/autopkgtest.sJ2N3c/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [704 B] 194s Get:2 http://ftpmaster.internal/ubuntu oracular/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 194s Get:3 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-common all 260 [36.4 kB] 194s Get:4 http://ftpmaster.internal/ubuntu oracular/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 194s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-common all 260 [162 kB] 194s Get:6 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq5 amd64 16.3-1 [140 kB] 194s Get:7 http://ftpmaster.internal/ubuntu oracular/main amd64 libxslt1.1 amd64 1.1.39-0exp1build1 [167 kB] 194s Get:8 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-16 amd64 16.3-1 [1269 kB] 194s Get:9 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-16 amd64 16.3-1 [15.5 MB] 195s Get:10 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql all 16+260 [11.6 kB] 195s Preconfiguring packages ... 195s Fetched 17.4 MB in 1s (29.2 MB/s) 195s Selecting previously unselected package libjson-perl. 196s (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 ... 74420 files and directories currently installed.) 196s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 196s Unpacking libjson-perl (4.10000-1) ... 196s Selecting previously unselected package postgresql-client-common. 196s Preparing to unpack .../1-postgresql-client-common_260_all.deb ... 196s Unpacking postgresql-client-common (260) ... 196s Selecting previously unselected package ssl-cert. 196s Preparing to unpack .../2-ssl-cert_1.1.2ubuntu2_all.deb ... 196s Unpacking ssl-cert (1.1.2ubuntu2) ... 196s Selecting previously unselected package postgresql-common. 196s Preparing to unpack .../3-postgresql-common_260_all.deb ... 196s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 196s Unpacking postgresql-common (260) ... 196s Selecting previously unselected package libpq5:amd64. 196s Preparing to unpack .../4-libpq5_16.3-1_amd64.deb ... 196s Unpacking libpq5:amd64 (16.3-1) ... 196s Selecting previously unselected package libxslt1.1:amd64. 196s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1build1_amd64.deb ... 196s Unpacking libxslt1.1:amd64 (1.1.39-0exp1build1) ... 196s Selecting previously unselected package postgresql-client-16. 196s Preparing to unpack .../6-postgresql-client-16_16.3-1_amd64.deb ... 196s Unpacking postgresql-client-16 (16.3-1) ... 196s Selecting previously unselected package postgresql-16. 196s Preparing to unpack .../7-postgresql-16_16.3-1_amd64.deb ... 196s Unpacking postgresql-16 (16.3-1) ... 197s Selecting previously unselected package postgresql. 197s Preparing to unpack .../8-postgresql_16+260_all.deb ... 197s Unpacking postgresql (16+260) ... 197s Selecting previously unselected package autopkgtest-satdep. 197s Preparing to unpack .../9-1-autopkgtest-satdep.deb ... 197s Unpacking autopkgtest-satdep (0) ... 197s Setting up postgresql-client-common (260) ... 197s Setting up libpq5:amd64 (16.3-1) ... 197s Setting up ssl-cert (1.1.2ubuntu2) ... 198s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 198s Setting up libjson-perl (4.10000-1) ... 198s Setting up libxslt1.1:amd64 (1.1.39-0exp1build1) ... 198s Setting up postgresql-client-16 (16.3-1) ... 199s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 199s Setting up postgresql-common (260) ... 200s 200s Creating config file /etc/postgresql-common/createcluster.conf with new version 200s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 200s Removing obsolete dictionary files: 201s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 201s Setting up postgresql-16 (16.3-1) ... 202s Creating new PostgreSQL cluster 16/main ... 202s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 202s The files belonging to this database system will be owned by user "postgres". 202s This user must also own the server process. 202s 202s The database cluster will be initialized with locale "C.UTF-8". 202s The default database encoding has accordingly been set to "UTF8". 202s The default text search configuration will be set to "english". 202s 202s Data page checksums are disabled. 202s 202s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 202s creating subdirectories ... ok 202s selecting dynamic shared memory implementation ... posix 202s selecting default max_connections ... 100 202s selecting default shared_buffers ... 128MB 202s selecting default time zone ... Etc/UTC 202s creating configuration files ... ok 202s running bootstrap script ... ok 203s performing post-bootstrap initialization ... ok 203s syncing data to disk ... ok 207s Setting up postgresql (16+260) ... 207s Setting up autopkgtest-satdep (0) ... 207s Processing triggers for man-db (2.12.1-2) ... 209s Processing triggers for libc-bin (2.39-3.1ubuntu2) ... 224s (Reading database ... 76361 files and directories currently installed.) 224s Removing autopkgtest-satdep (0) ... 224s autopkgtest [18:23:10]: test default-psql: [----------------------- 225s autopkgtest [18:23:11]: test default-psql: -----------------------] 225s autopkgtest [18:23:11]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 225s default-psql PASS 225s autopkgtest [18:23:11]: test run-testsuite: preparing testbed 750s autopkgtest [18:31:56]: testbed dpkg architecture: amd64 751s autopkgtest [18:31:57]: testbed apt version: 2.9.5 751s autopkgtest [18:31:57]: @@@@@@@@@@@@@@@@@@@@ test bed setup 752s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 752s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7052 B] 752s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [365 kB] 752s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [48.3 kB] 752s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2576 B] 752s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages [82.7 kB] 752s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages [101 kB] 752s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted i386 Packages [6244 B] 752s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted amd64 Packages [28.0 kB] 752s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 Packages [403 kB] 752s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe i386 Packages [227 kB] 752s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse i386 Packages [3368 B] 752s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse amd64 Packages [7968 B] 752s Fetched 1393 kB in 0s (4095 kB/s) 752s Reading package lists... 770s Reading package lists... 770s Building dependency tree... 770s Reading state information... 771s Calculating upgrade... 772s The following packages will be upgraded: 772s base-files libc-bin libc-dev-bin libc-devtools libc6 libc6-dev locales 772s motd-news-config 772s 8 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 772s Need to get 10.4 MB of archives. 772s After this operation, 35.8 kB of additional disk space will be used. 772s Get:1 http://ftpmaster.internal/ubuntu oracular/main amd64 motd-news-config all 13.3ubuntu2 [5416 B] 772s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-devtools amd64 2.39-3.1ubuntu2 [29.3 kB] 772s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc6-dev amd64 2.39-3.1ubuntu2 [2120 kB] 772s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-dev-bin amd64 2.39-3.1ubuntu2 [20.4 kB] 772s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 base-files amd64 13.3ubuntu2 [75.3 kB] 772s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc6 amd64 2.39-3.1ubuntu2 [3261 kB] 772s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 libc-bin amd64 2.39-3.1ubuntu2 [680 kB] 772s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 locales all 2.39-3.1ubuntu2 [4220 kB] 772s Preconfiguring packages ... 772s Fetched 10.4 MB in 0s (59.4 MB/s) 773s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 74417 files and directories currently installed.) 773s Preparing to unpack .../motd-news-config_13.3ubuntu2_all.deb ... 773s Unpacking motd-news-config (13.3ubuntu2) over (13.1ubuntu1) ... 773s Preparing to unpack .../libc-devtools_2.39-3.1ubuntu2_amd64.deb ... 773s Unpacking libc-devtools (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 773s Preparing to unpack .../libc6-dev_2.39-3.1ubuntu2_amd64.deb ... 773s Unpacking libc6-dev:amd64 (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 773s Preparing to unpack .../libc-dev-bin_2.39-3.1ubuntu2_amd64.deb ... 773s Unpacking libc-dev-bin (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 773s Preparing to unpack .../base-files_13.3ubuntu2_amd64.deb ... 774s Unpacking base-files (13.3ubuntu2) over (13.1ubuntu1) ... 774s Setting up base-files (13.3ubuntu2) ... 774s Updating /etc/profile to current default. 775s motd-news.service is a disabled or a static unit not running, not starting it. 775s (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 ... 74420 files and directories currently installed.) 775s Preparing to unpack .../libc6_2.39-3.1ubuntu2_amd64.deb ... 775s Unpacking libc6:amd64 (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 775s Setting up libc6:amd64 (2.39-3.1ubuntu2) ... 776s (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 ... 74420 files and directories currently installed.) 776s Preparing to unpack .../libc-bin_2.39-3.1ubuntu2_amd64.deb ... 776s Unpacking libc-bin (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 776s Setting up libc-bin (2.39-3.1ubuntu2) ... 776s (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 ... 74420 files and directories currently installed.) 776s Preparing to unpack .../locales_2.39-3.1ubuntu2_all.deb ... 776s Unpacking locales (2.39-3.1ubuntu2) over (2.39-0ubuntu9) ... 776s Setting up motd-news-config (13.3ubuntu2) ... 776s Setting up locales (2.39-3.1ubuntu2) ... 777s Generating locales (this might take a while)... 779s en_US.UTF-8... done 779s Generation complete. 779s Setting up libc-dev-bin (2.39-3.1ubuntu2) ... 779s Setting up libc-devtools (2.39-3.1ubuntu2) ... 779s Setting up libc6-dev:amd64 (2.39-3.1ubuntu2) ... 779s Processing triggers for man-db (2.12.1-2) ... 781s Processing triggers for plymouth-theme-ubuntu-text (24.004.60-1ubuntu7) ... 781s update-initramfs: deferring update (trigger activated) 781s Processing triggers for install-info (7.1-3build2) ... 781s Processing triggers for initramfs-tools (0.142ubuntu28) ... 781s update-initramfs: Generating /boot/initrd.img-6.8.0-31-generic 781s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 794s Reading package lists... 794s Building dependency tree... 794s Reading state information... 795s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 795s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 795s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 795s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 795s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 797s Reading package lists... 797s Reading package lists... 798s Building dependency tree... 798s Reading state information... 798s Calculating upgrade... 799s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 799s Reading package lists... 799s Building dependency tree... 799s Reading state information... 800s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 800s autopkgtest [18:32:46]: rebooting testbed after setup commands that affected boot 803s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 827s Reading package lists... 828s Building dependency tree... 828s Reading state information... 828s Starting pkgProblemResolver with broken count: 0 828s Starting 2 pkgProblemResolver with broken count: 0 828s Done 829s The following additional packages will be installed: 829s autoconf automake autopoint autotools-dev build-essential clang-18 cpp 829s cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper debugedit 829s dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz emacsen-common 829s fakeroot g++ g++-13 g++-13-x86-64-linux-gnu g++-x86-64-linux-gnu gcc gcc-13 829s gcc-13-base gcc-13-x86-64-linux-gnu gcc-x86-64-linux-gnu gettext 829s hunspell-en-us icu-devtools intltool-debian libarchive-zip-perl libasan8 829s libatomic1 libcc1-0 libclang-common-18-dev libdebhelper-perl libecpg-compat3 829s libecpg-dev libecpg6 libfakeroot libffi-dev libfile-stripnondeterminism-perl 829s libgc1 libgcc-13-dev libgomp1 libhwasan0 libicu-dev libisl23 libitm1 829s libjson-perl liblsan0 libmpc3 libncurses-dev libobjc-13-dev libobjc4 libpfm4 829s libpgtypes3 libpq-dev libpq5 libpython3.12t64 libquadmath0 libssl-dev 829s libstdc++-13-dev libtcl8.6 libtool libtsan2 libubsan1 libxml2-dev libxslt1.1 829s libz3-4 libz3-dev llvm-18 llvm-18-dev llvm-18-linker-tools llvm-18-runtime 829s llvm-18-tools locales-all m4 po-debconf postgresql-16 postgresql-all 829s postgresql-client-16 postgresql-client-common postgresql-common 829s postgresql-doc postgresql-doc-16 postgresql-plperl-16 829s postgresql-plpython3-16 postgresql-pltcl-16 postgresql-server-dev-16 829s postgresql-server-dev-all ssl-cert 829s Suggested packages: 829s autoconf-archive gnu-standards autoconf-doc clang-18-doc wasi-libc cpp-doc 829s gcc-13-locales cpp-13-doc dh-make ispell | aspell | hunspell wordlist 829s g++-multilib g++-13-multilib gcc-13-doc gcc-multilib manpages-dev flex bison 829s gdb gcc-doc gcc-13-multilib gdb-x86-64-linux-gnu gettext-doc libasprintf-dev 829s libgettextpo-dev hunspell openoffice.org-hunspell | openoffice.org-core 829s icu-doc ncurses-doc libssl-doc libstdc++-13-doc tcl8.6 libtool-doc gfortran 829s | fortran95-compiler gcj-jdk pkg-config llvm-18-doc m4-doc libmail-box-perl 829s Recommended packages: 829s libclang-rt-18-dev libarchive-cpio-perl libjson-xs-perl libltdl-dev 829s libmail-sendmail-perl 829s The following NEW packages will be installed: 829s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 829s clang-18 cpp cpp-13 cpp-13-x86-64-linux-gnu cpp-x86-64-linux-gnu debhelper 829s debugedit dh-autoreconf dh-strip-nondeterminism dictionaries-common dwz 829s emacsen-common fakeroot g++ g++-13 g++-13-x86-64-linux-gnu 829s g++-x86-64-linux-gnu gcc gcc-13 gcc-13-base gcc-13-x86-64-linux-gnu 829s gcc-x86-64-linux-gnu gettext hunspell-en-us icu-devtools intltool-debian 829s libarchive-zip-perl libasan8 libatomic1 libcc1-0 libclang-common-18-dev 829s libdebhelper-perl libecpg-compat3 libecpg-dev libecpg6 libfakeroot 829s libffi-dev libfile-stripnondeterminism-perl libgc1 libgcc-13-dev libgomp1 829s libhwasan0 libicu-dev libisl23 libitm1 libjson-perl liblsan0 libmpc3 829s libncurses-dev libobjc-13-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 829s libpython3.12t64 libquadmath0 libssl-dev libstdc++-13-dev libtcl8.6 libtool 829s libtsan2 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev llvm-18 829s llvm-18-dev llvm-18-linker-tools llvm-18-runtime llvm-18-tools locales-all 829s m4 po-debconf postgresql-16 postgresql-all postgresql-client-16 829s postgresql-client-common postgresql-common postgresql-doc postgresql-doc-16 829s postgresql-plperl-16 postgresql-plpython3-16 postgresql-pltcl-16 829s postgresql-server-dev-16 postgresql-server-dev-all ssl-cert 833s 0 upgraded, 94 newly installed, 0 to remove and 0 not upgraded. 833s Need to get 198 MB/198 MB of archives. 833s After this operation, 1138 MB of additional disk space will be used. 833s Get:1 /tmp/autopkgtest.sJ2N3c/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [796 B] 833s Get:2 http://ftpmaster.internal/ubuntu oracular/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 833s Get:3 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-common all 260 [36.4 kB] 833s Get:4 http://ftpmaster.internal/ubuntu oracular/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 833s Get:5 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-common all 260 [162 kB] 833s Get:6 http://ftpmaster.internal/ubuntu oracular/main amd64 m4 amd64 1.4.19-4build1 [244 kB] 833s Get:7 http://ftpmaster.internal/ubuntu oracular/main amd64 autoconf all 2.71-3 [339 kB] 833s Get:8 http://ftpmaster.internal/ubuntu oracular/main amd64 autotools-dev all 20220109.1 [44.9 kB] 833s Get:9 http://ftpmaster.internal/ubuntu oracular/main amd64 automake all 1:1.16.5-1.3ubuntu1 [558 kB] 833s Get:10 http://ftpmaster.internal/ubuntu oracular/main amd64 autopoint all 0.21-14ubuntu2 [422 kB] 833s Get:11 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13-base amd64 13.2.0-23ubuntu4 [49.0 kB] 833s Get:12 http://ftpmaster.internal/ubuntu oracular/main amd64 libisl23 amd64 0.26-3build1 [680 kB] 833s Get:13 http://ftpmaster.internal/ubuntu oracular/main amd64 libmpc3 amd64 1.3.1-1build1 [54.5 kB] 833s Get:14 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [11.2 MB] 833s Get:15 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-13 amd64 13.2.0-23ubuntu4 [1032 B] 833s Get:16 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [5326 B] 833s Get:17 http://ftpmaster.internal/ubuntu oracular/main amd64 cpp amd64 4:13.2.0-7ubuntu1 [22.4 kB] 833s Get:18 http://ftpmaster.internal/ubuntu oracular/main amd64 libcc1-0 amd64 14.1.0-1ubuntu1 [48.0 kB] 833s Get:19 http://ftpmaster.internal/ubuntu oracular/main amd64 libgomp1 amd64 14.1.0-1ubuntu1 [148 kB] 833s Get:20 http://ftpmaster.internal/ubuntu oracular/main amd64 libitm1 amd64 14.1.0-1ubuntu1 [29.1 kB] 833s Get:21 http://ftpmaster.internal/ubuntu oracular/main amd64 libatomic1 amd64 14.1.0-1ubuntu1 [10.4 kB] 833s Get:22 http://ftpmaster.internal/ubuntu oracular/main amd64 libasan8 amd64 14.1.0-1ubuntu1 [3025 kB] 833s Get:23 http://ftpmaster.internal/ubuntu oracular/main amd64 liblsan0 amd64 14.1.0-1ubuntu1 [1313 kB] 833s Get:24 http://ftpmaster.internal/ubuntu oracular/main amd64 libtsan2 amd64 14.1.0-1ubuntu1 [2736 kB] 833s Get:25 http://ftpmaster.internal/ubuntu oracular/main amd64 libubsan1 amd64 14.1.0-1ubuntu1 [1174 kB] 833s Get:26 http://ftpmaster.internal/ubuntu oracular/main amd64 libhwasan0 amd64 14.1.0-1ubuntu1 [1632 kB] 833s Get:27 http://ftpmaster.internal/ubuntu oracular/main amd64 libquadmath0 amd64 14.1.0-1ubuntu1 [153 kB] 833s Get:28 http://ftpmaster.internal/ubuntu oracular/main amd64 libgcc-13-dev amd64 13.2.0-23ubuntu4 [2688 kB] 833s Get:29 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [21.9 MB] 833s Get:30 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-13 amd64 13.2.0-23ubuntu4 [482 kB] 833s Get:31 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [1212 B] 833s Get:32 http://ftpmaster.internal/ubuntu oracular/main amd64 gcc amd64 4:13.2.0-7ubuntu1 [5018 B] 833s Get:33 http://ftpmaster.internal/ubuntu oracular/main amd64 libstdc++-13-dev amd64 13.2.0-23ubuntu4 [2399 kB] 833s Get:34 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-13-x86-64-linux-gnu amd64 13.2.0-23ubuntu4 [12.5 MB] 833s Get:35 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-13 amd64 13.2.0-23ubuntu4 [14.5 kB] 833s Get:36 http://ftpmaster.internal/ubuntu oracular/main amd64 g++-x86-64-linux-gnu amd64 4:13.2.0-7ubuntu1 [964 B] 833s Get:37 http://ftpmaster.internal/ubuntu oracular/main amd64 g++ amd64 4:13.2.0-7ubuntu1 [1100 B] 833s Get:38 http://ftpmaster.internal/ubuntu oracular/main amd64 build-essential amd64 12.10ubuntu1 [4928 B] 833s Get:39 http://ftpmaster.internal/ubuntu oracular/main amd64 libgc1 amd64 1:8.2.6-1build1 [90.3 kB] 833s Get:40 http://ftpmaster.internal/ubuntu oracular/universe amd64 libobjc4 amd64 14.1.0-1ubuntu1 [46.1 kB] 833s Get:41 http://ftpmaster.internal/ubuntu oracular/universe amd64 libobjc-13-dev amd64 13.2.0-23ubuntu4 [194 kB] 833s Get:42 http://ftpmaster.internal/ubuntu oracular/universe amd64 libclang-common-18-dev amd64 1:18.1.7-1 [735 kB] 833s Get:43 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-linker-tools amd64 1:18.1.7-1 [1310 kB] 833s Get:44 http://ftpmaster.internal/ubuntu oracular/universe amd64 clang-18 amd64 1:18.1.7-1 [80.0 kB] 833s Get:45 http://ftpmaster.internal/ubuntu oracular/main amd64 libdebhelper-perl all 13.16ubuntu2 [92.9 kB] 833s Get:46 http://ftpmaster.internal/ubuntu oracular/main amd64 libtool all 2.4.7-7build1 [166 kB] 833s Get:47 http://ftpmaster.internal/ubuntu oracular/main amd64 dh-autoreconf all 20 [16.1 kB] 833s Get:48 http://ftpmaster.internal/ubuntu oracular/main amd64 libarchive-zip-perl all 1.68-1 [90.2 kB] 833s Get:49 http://ftpmaster.internal/ubuntu oracular/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 833s Get:50 http://ftpmaster.internal/ubuntu oracular/main amd64 dh-strip-nondeterminism all 1.14.0-1 [5058 B] 833s Get:51 http://ftpmaster.internal/ubuntu oracular/main amd64 debugedit amd64 1:5.0-5build2 [46.1 kB] 833s Get:52 http://ftpmaster.internal/ubuntu oracular/main amd64 dwz amd64 0.15-1build6 [115 kB] 833s Get:53 http://ftpmaster.internal/ubuntu oracular/main amd64 gettext amd64 0.21-14ubuntu2 [864 kB] 833s Get:54 http://ftpmaster.internal/ubuntu oracular/main amd64 intltool-debian all 0.35.0+20060710.6 [23.2 kB] 833s Get:55 http://ftpmaster.internal/ubuntu oracular/main amd64 po-debconf all 1.0.21+nmu1 [233 kB] 833s Get:56 http://ftpmaster.internal/ubuntu oracular/main amd64 debhelper all 13.16ubuntu2 [869 kB] 833s Get:57 http://ftpmaster.internal/ubuntu oracular/main amd64 emacsen-common all 3.0.5 [12.1 kB] 833s Get:58 http://ftpmaster.internal/ubuntu oracular/main amd64 dictionaries-common all 1.29.7 [188 kB] 833s Get:59 http://ftpmaster.internal/ubuntu oracular/main amd64 libfakeroot amd64 1.34-1 [32.4 kB] 833s Get:60 http://ftpmaster.internal/ubuntu oracular/main amd64 fakeroot amd64 1.34-1 [67.2 kB] 833s Get:61 http://ftpmaster.internal/ubuntu oracular/main amd64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 833s Get:62 http://ftpmaster.internal/ubuntu oracular/main amd64 icu-devtools amd64 74.2-1ubuntu3 [212 kB] 833s Get:63 http://ftpmaster.internal/ubuntu oracular/main amd64 libpgtypes3 amd64 16.3-1 [43.0 kB] 833s Get:64 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq5 amd64 16.3-1 [140 kB] 833s Get:65 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg6 amd64 16.3-1 [44.5 kB] 833s Get:66 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg-compat3 amd64 16.3-1 [17.8 kB] 833s Get:67 http://ftpmaster.internal/ubuntu oracular/main amd64 libssl-dev amd64 3.0.13-0ubuntu4 [2408 kB] 833s Get:68 http://ftpmaster.internal/ubuntu oracular/main amd64 libpq-dev amd64 16.3-1 [151 kB] 833s Get:69 http://ftpmaster.internal/ubuntu oracular/main amd64 libecpg-dev amd64 16.3-1 [265 kB] 833s Get:70 http://ftpmaster.internal/ubuntu oracular/main amd64 libicu-dev amd64 74.2-1ubuntu3 [11.9 MB] 833s Get:71 http://ftpmaster.internal/ubuntu oracular/main amd64 libncurses-dev amd64 6.5-2 [384 kB] 833s Get:72 http://ftpmaster.internal/ubuntu oracular/main amd64 libpython3.12t64 amd64 3.12.4-1 [2338 kB] 833s Get:73 http://ftpmaster.internal/ubuntu oracular/main amd64 libtcl8.6 amd64 8.6.14+dfsg-1build1 [988 kB] 833s Get:74 http://ftpmaster.internal/ubuntu oracular/main amd64 libxml2-dev amd64 2.9.14+dfsg-1.3ubuntu3 [780 kB] 833s Get:75 http://ftpmaster.internal/ubuntu oracular/main amd64 libxslt1.1 amd64 1.1.39-0exp1build1 [167 kB] 833s Get:76 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-runtime amd64 1:18.1.7-1 [537 kB] 833s Get:77 http://ftpmaster.internal/ubuntu oracular/universe amd64 libpfm4 amd64 4.13.0+git32-g0d4ed0e-1 [414 kB] 833s Get:78 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18 amd64 1:18.1.7-1 [25.2 MB] 833s Get:79 http://ftpmaster.internal/ubuntu oracular/main amd64 libffi-dev amd64 3.4.6-1build1 [62.8 kB] 833s Get:80 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-tools amd64 1:18.1.7-1 [533 kB] 833s Get:81 http://ftpmaster.internal/ubuntu oracular/universe amd64 libz3-4 amd64 4.8.12-3.1build1 [5836 kB] 833s Get:82 http://ftpmaster.internal/ubuntu oracular/universe amd64 libz3-dev amd64 4.8.12-3.1build1 [72.2 kB] 833s Get:83 http://ftpmaster.internal/ubuntu oracular/universe amd64 llvm-18-dev amd64 1:18.1.7-1 [44.9 MB] 833s Get:84 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 locales-all amd64 2.39-3.1ubuntu2 [10.9 MB] 833s Get:85 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-client-16 amd64 16.3-1 [1269 kB] 833s Get:86 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-16 amd64 16.3-1 [15.5 MB] 833s Get:87 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-server-dev-16 amd64 16.3-1 [1223 kB] 833s Get:88 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-server-dev-all amd64 260 [20.6 kB] 833s Get:89 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-plperl-16 amd64 16.3-1 [67.4 kB] 833s Get:90 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-plpython3-16 amd64 16.3-1 [75.4 kB] 833s Get:91 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-pltcl-16 amd64 16.3-1 [30.2 kB] 833s Get:92 http://ftpmaster.internal/ubuntu oracular/universe amd64 postgresql-all all 260 [1712 B] 833s Get:93 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-doc-16 all 16.3-1 [2098 kB] 833s Get:94 http://ftpmaster.internal/ubuntu oracular/main amd64 postgresql-doc all 16+260 [11.6 kB] 833s Preconfiguring packages ... 833s Fetched 198 MB in 2s (85.0 MB/s) 833s Selecting previously unselected package libjson-perl. 833s (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 ... 74420 files and directories currently installed.) 833s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 833s Unpacking libjson-perl (4.10000-1) ... 833s Selecting previously unselected package postgresql-client-common. 833s Preparing to unpack .../01-postgresql-client-common_260_all.deb ... 833s Unpacking postgresql-client-common (260) ... 833s Selecting previously unselected package ssl-cert. 833s Preparing to unpack .../02-ssl-cert_1.1.2ubuntu2_all.deb ... 833s Unpacking ssl-cert (1.1.2ubuntu2) ... 833s Selecting previously unselected package postgresql-common. 833s Preparing to unpack .../03-postgresql-common_260_all.deb ... 833s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 833s Unpacking postgresql-common (260) ... 833s Selecting previously unselected package m4. 833s Preparing to unpack .../04-m4_1.4.19-4build1_amd64.deb ... 833s Unpacking m4 (1.4.19-4build1) ... 833s Selecting previously unselected package autoconf. 833s Preparing to unpack .../05-autoconf_2.71-3_all.deb ... 833s Unpacking autoconf (2.71-3) ... 833s Selecting previously unselected package autotools-dev. 833s Preparing to unpack .../06-autotools-dev_20220109.1_all.deb ... 833s Unpacking autotools-dev (20220109.1) ... 834s Selecting previously unselected package automake. 834s Preparing to unpack .../07-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 834s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 834s Selecting previously unselected package autopoint. 834s Preparing to unpack .../08-autopoint_0.21-14ubuntu2_all.deb ... 834s Unpacking autopoint (0.21-14ubuntu2) ... 834s Selecting previously unselected package gcc-13-base:amd64. 834s Preparing to unpack .../09-gcc-13-base_13.2.0-23ubuntu4_amd64.deb ... 834s Unpacking gcc-13-base:amd64 (13.2.0-23ubuntu4) ... 834s Selecting previously unselected package libisl23:amd64. 834s Preparing to unpack .../10-libisl23_0.26-3build1_amd64.deb ... 834s Unpacking libisl23:amd64 (0.26-3build1) ... 834s Selecting previously unselected package libmpc3:amd64. 834s Preparing to unpack .../11-libmpc3_1.3.1-1build1_amd64.deb ... 834s Unpacking libmpc3:amd64 (1.3.1-1build1) ... 834s Selecting previously unselected package cpp-13-x86-64-linux-gnu. 834s Preparing to unpack .../12-cpp-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 834s Unpacking cpp-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 834s Selecting previously unselected package cpp-13. 834s Preparing to unpack .../13-cpp-13_13.2.0-23ubuntu4_amd64.deb ... 834s Unpacking cpp-13 (13.2.0-23ubuntu4) ... 834s Selecting previously unselected package cpp-x86-64-linux-gnu. 834s Preparing to unpack .../14-cpp-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 834s Unpacking cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 834s Selecting previously unselected package cpp. 834s Preparing to unpack .../15-cpp_4%3a13.2.0-7ubuntu1_amd64.deb ... 834s Unpacking cpp (4:13.2.0-7ubuntu1) ... 834s Selecting previously unselected package libcc1-0:amd64. 834s Preparing to unpack .../16-libcc1-0_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking libcc1-0:amd64 (14.1.0-1ubuntu1) ... 834s Selecting previously unselected package libgomp1:amd64. 834s Preparing to unpack .../17-libgomp1_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking libgomp1:amd64 (14.1.0-1ubuntu1) ... 834s Selecting previously unselected package libitm1:amd64. 834s Preparing to unpack .../18-libitm1_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking libitm1:amd64 (14.1.0-1ubuntu1) ... 834s Selecting previously unselected package libatomic1:amd64. 834s Preparing to unpack .../19-libatomic1_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking libatomic1:amd64 (14.1.0-1ubuntu1) ... 834s Selecting previously unselected package libasan8:amd64. 834s Preparing to unpack .../20-libasan8_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking libasan8:amd64 (14.1.0-1ubuntu1) ... 834s Selecting previously unselected package liblsan0:amd64. 834s Preparing to unpack .../21-liblsan0_14.1.0-1ubuntu1_amd64.deb ... 834s Unpacking liblsan0:amd64 (14.1.0-1ubuntu1) ... 835s Selecting previously unselected package libtsan2:amd64. 835s Preparing to unpack .../22-libtsan2_14.1.0-1ubuntu1_amd64.deb ... 835s Unpacking libtsan2:amd64 (14.1.0-1ubuntu1) ... 835s Selecting previously unselected package libubsan1:amd64. 835s Preparing to unpack .../23-libubsan1_14.1.0-1ubuntu1_amd64.deb ... 835s Unpacking libubsan1:amd64 (14.1.0-1ubuntu1) ... 835s Selecting previously unselected package libhwasan0:amd64. 835s Preparing to unpack .../24-libhwasan0_14.1.0-1ubuntu1_amd64.deb ... 835s Unpacking libhwasan0:amd64 (14.1.0-1ubuntu1) ... 835s Selecting previously unselected package libquadmath0:amd64. 835s Preparing to unpack .../25-libquadmath0_14.1.0-1ubuntu1_amd64.deb ... 835s Unpacking libquadmath0:amd64 (14.1.0-1ubuntu1) ... 835s Selecting previously unselected package libgcc-13-dev:amd64. 835s Preparing to unpack .../26-libgcc-13-dev_13.2.0-23ubuntu4_amd64.deb ... 835s Unpacking libgcc-13-dev:amd64 (13.2.0-23ubuntu4) ... 835s Selecting previously unselected package gcc-13-x86-64-linux-gnu. 835s Preparing to unpack .../27-gcc-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 835s Unpacking gcc-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 835s Selecting previously unselected package gcc-13. 835s Preparing to unpack .../28-gcc-13_13.2.0-23ubuntu4_amd64.deb ... 835s Unpacking gcc-13 (13.2.0-23ubuntu4) ... 835s Selecting previously unselected package gcc-x86-64-linux-gnu. 835s Preparing to unpack .../29-gcc-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 835s Unpacking gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 836s Selecting previously unselected package gcc. 836s Preparing to unpack .../30-gcc_4%3a13.2.0-7ubuntu1_amd64.deb ... 836s Unpacking gcc (4:13.2.0-7ubuntu1) ... 836s Selecting previously unselected package libstdc++-13-dev:amd64. 836s Preparing to unpack .../31-libstdc++-13-dev_13.2.0-23ubuntu4_amd64.deb ... 836s Unpacking libstdc++-13-dev:amd64 (13.2.0-23ubuntu4) ... 836s Selecting previously unselected package g++-13-x86-64-linux-gnu. 836s Preparing to unpack .../32-g++-13-x86-64-linux-gnu_13.2.0-23ubuntu4_amd64.deb ... 836s Unpacking g++-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 836s Selecting previously unselected package g++-13. 836s Preparing to unpack .../33-g++-13_13.2.0-23ubuntu4_amd64.deb ... 836s Unpacking g++-13 (13.2.0-23ubuntu4) ... 836s Selecting previously unselected package g++-x86-64-linux-gnu. 836s Preparing to unpack .../34-g++-x86-64-linux-gnu_4%3a13.2.0-7ubuntu1_amd64.deb ... 836s Unpacking g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 836s Selecting previously unselected package g++. 836s Preparing to unpack .../35-g++_4%3a13.2.0-7ubuntu1_amd64.deb ... 836s Unpacking g++ (4:13.2.0-7ubuntu1) ... 836s Selecting previously unselected package build-essential. 836s Preparing to unpack .../36-build-essential_12.10ubuntu1_amd64.deb ... 836s Unpacking build-essential (12.10ubuntu1) ... 836s Selecting previously unselected package libgc1:amd64. 836s Preparing to unpack .../37-libgc1_1%3a8.2.6-1build1_amd64.deb ... 836s Unpacking libgc1:amd64 (1:8.2.6-1build1) ... 836s Selecting previously unselected package libobjc4:amd64. 836s Preparing to unpack .../38-libobjc4_14.1.0-1ubuntu1_amd64.deb ... 836s Unpacking libobjc4:amd64 (14.1.0-1ubuntu1) ... 836s Selecting previously unselected package libobjc-13-dev:amd64. 836s Preparing to unpack .../39-libobjc-13-dev_13.2.0-23ubuntu4_amd64.deb ... 836s Unpacking libobjc-13-dev:amd64 (13.2.0-23ubuntu4) ... 836s Selecting previously unselected package libclang-common-18-dev:amd64. 836s Preparing to unpack .../40-libclang-common-18-dev_1%3a18.1.7-1_amd64.deb ... 836s Unpacking libclang-common-18-dev:amd64 (1:18.1.7-1) ... 837s Selecting previously unselected package llvm-18-linker-tools. 837s Preparing to unpack .../41-llvm-18-linker-tools_1%3a18.1.7-1_amd64.deb ... 837s Unpacking llvm-18-linker-tools (1:18.1.7-1) ... 837s Selecting previously unselected package clang-18. 837s Preparing to unpack .../42-clang-18_1%3a18.1.7-1_amd64.deb ... 837s Unpacking clang-18 (1:18.1.7-1) ... 837s Selecting previously unselected package libdebhelper-perl. 837s Preparing to unpack .../43-libdebhelper-perl_13.16ubuntu2_all.deb ... 837s Unpacking libdebhelper-perl (13.16ubuntu2) ... 837s Selecting previously unselected package libtool. 837s Preparing to unpack .../44-libtool_2.4.7-7build1_all.deb ... 837s Unpacking libtool (2.4.7-7build1) ... 837s Selecting previously unselected package dh-autoreconf. 837s Preparing to unpack .../45-dh-autoreconf_20_all.deb ... 837s Unpacking dh-autoreconf (20) ... 837s Selecting previously unselected package libarchive-zip-perl. 837s Preparing to unpack .../46-libarchive-zip-perl_1.68-1_all.deb ... 837s Unpacking libarchive-zip-perl (1.68-1) ... 837s Selecting previously unselected package libfile-stripnondeterminism-perl. 837s Preparing to unpack .../47-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 837s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 837s Selecting previously unselected package dh-strip-nondeterminism. 837s Preparing to unpack .../48-dh-strip-nondeterminism_1.14.0-1_all.deb ... 837s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 837s Selecting previously unselected package debugedit. 837s Preparing to unpack .../49-debugedit_1%3a5.0-5build2_amd64.deb ... 837s Unpacking debugedit (1:5.0-5build2) ... 837s Selecting previously unselected package dwz. 837s Preparing to unpack .../50-dwz_0.15-1build6_amd64.deb ... 837s Unpacking dwz (0.15-1build6) ... 837s Selecting previously unselected package gettext. 837s Preparing to unpack .../51-gettext_0.21-14ubuntu2_amd64.deb ... 837s Unpacking gettext (0.21-14ubuntu2) ... 837s Selecting previously unselected package intltool-debian. 837s Preparing to unpack .../52-intltool-debian_0.35.0+20060710.6_all.deb ... 837s Unpacking intltool-debian (0.35.0+20060710.6) ... 837s Selecting previously unselected package po-debconf. 837s Preparing to unpack .../53-po-debconf_1.0.21+nmu1_all.deb ... 837s Unpacking po-debconf (1.0.21+nmu1) ... 837s Selecting previously unselected package debhelper. 837s Preparing to unpack .../54-debhelper_13.16ubuntu2_all.deb ... 837s Unpacking debhelper (13.16ubuntu2) ... 837s Selecting previously unselected package emacsen-common. 837s Preparing to unpack .../55-emacsen-common_3.0.5_all.deb ... 837s Unpacking emacsen-common (3.0.5) ... 837s Selecting previously unselected package dictionaries-common. 837s Preparing to unpack .../56-dictionaries-common_1.29.7_all.deb ... 837s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 837s Unpacking dictionaries-common (1.29.7) ... 837s Selecting previously unselected package libfakeroot:amd64. 837s Preparing to unpack .../57-libfakeroot_1.34-1_amd64.deb ... 837s Unpacking libfakeroot:amd64 (1.34-1) ... 837s Selecting previously unselected package fakeroot. 837s Preparing to unpack .../58-fakeroot_1.34-1_amd64.deb ... 837s Unpacking fakeroot (1.34-1) ... 838s Selecting previously unselected package hunspell-en-us. 838s Preparing to unpack .../59-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 838s Unpacking hunspell-en-us (1:2020.12.07-2) ... 838s Selecting previously unselected package icu-devtools. 838s Preparing to unpack .../60-icu-devtools_74.2-1ubuntu3_amd64.deb ... 838s Unpacking icu-devtools (74.2-1ubuntu3) ... 838s Selecting previously unselected package libpgtypes3:amd64. 838s Preparing to unpack .../61-libpgtypes3_16.3-1_amd64.deb ... 838s Unpacking libpgtypes3:amd64 (16.3-1) ... 838s Selecting previously unselected package libpq5:amd64. 838s Preparing to unpack .../62-libpq5_16.3-1_amd64.deb ... 838s Unpacking libpq5:amd64 (16.3-1) ... 838s Selecting previously unselected package libecpg6:amd64. 838s Preparing to unpack .../63-libecpg6_16.3-1_amd64.deb ... 838s Unpacking libecpg6:amd64 (16.3-1) ... 838s Selecting previously unselected package libecpg-compat3:amd64. 838s Preparing to unpack .../64-libecpg-compat3_16.3-1_amd64.deb ... 838s Unpacking libecpg-compat3:amd64 (16.3-1) ... 838s Selecting previously unselected package libssl-dev:amd64. 838s Preparing to unpack .../65-libssl-dev_3.0.13-0ubuntu4_amd64.deb ... 838s Unpacking libssl-dev:amd64 (3.0.13-0ubuntu4) ... 838s Selecting previously unselected package libpq-dev. 838s Preparing to unpack .../66-libpq-dev_16.3-1_amd64.deb ... 838s Unpacking libpq-dev (16.3-1) ... 838s Selecting previously unselected package libecpg-dev. 838s Preparing to unpack .../67-libecpg-dev_16.3-1_amd64.deb ... 838s Unpacking libecpg-dev (16.3-1) ... 838s Selecting previously unselected package libicu-dev:amd64. 838s Preparing to unpack .../68-libicu-dev_74.2-1ubuntu3_amd64.deb ... 838s Unpacking libicu-dev:amd64 (74.2-1ubuntu3) ... 838s Selecting previously unselected package libncurses-dev:amd64. 838s Preparing to unpack .../69-libncurses-dev_6.5-2_amd64.deb ... 838s Unpacking libncurses-dev:amd64 (6.5-2) ... 838s Selecting previously unselected package libpython3.12t64:amd64. 838s Preparing to unpack .../70-libpython3.12t64_3.12.4-1_amd64.deb ... 838s Unpacking libpython3.12t64:amd64 (3.12.4-1) ... 839s Selecting previously unselected package libtcl8.6:amd64. 839s Preparing to unpack .../71-libtcl8.6_8.6.14+dfsg-1build1_amd64.deb ... 839s Unpacking libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 839s Selecting previously unselected package libxml2-dev:amd64. 839s Preparing to unpack .../72-libxml2-dev_2.9.14+dfsg-1.3ubuntu3_amd64.deb ... 839s Unpacking libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3) ... 839s Selecting previously unselected package libxslt1.1:amd64. 839s Preparing to unpack .../73-libxslt1.1_1.1.39-0exp1build1_amd64.deb ... 839s Unpacking libxslt1.1:amd64 (1.1.39-0exp1build1) ... 839s Selecting previously unselected package llvm-18-runtime. 839s Preparing to unpack .../74-llvm-18-runtime_1%3a18.1.7-1_amd64.deb ... 839s Unpacking llvm-18-runtime (1:18.1.7-1) ... 839s Selecting previously unselected package libpfm4:amd64. 839s Preparing to unpack .../75-libpfm4_4.13.0+git32-g0d4ed0e-1_amd64.deb ... 839s Unpacking libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 839s Selecting previously unselected package llvm-18. 839s Preparing to unpack .../76-llvm-18_1%3a18.1.7-1_amd64.deb ... 839s Unpacking llvm-18 (1:18.1.7-1) ... 840s Selecting previously unselected package libffi-dev:amd64. 840s Preparing to unpack .../77-libffi-dev_3.4.6-1build1_amd64.deb ... 840s Unpacking libffi-dev:amd64 (3.4.6-1build1) ... 840s Selecting previously unselected package llvm-18-tools. 840s Preparing to unpack .../78-llvm-18-tools_1%3a18.1.7-1_amd64.deb ... 840s Unpacking llvm-18-tools (1:18.1.7-1) ... 840s Selecting previously unselected package libz3-4:amd64. 840s Preparing to unpack .../79-libz3-4_4.8.12-3.1build1_amd64.deb ... 840s Unpacking libz3-4:amd64 (4.8.12-3.1build1) ... 840s Selecting previously unselected package libz3-dev:amd64. 840s Preparing to unpack .../80-libz3-dev_4.8.12-3.1build1_amd64.deb ... 840s Unpacking libz3-dev:amd64 (4.8.12-3.1build1) ... 840s Selecting previously unselected package llvm-18-dev. 840s Preparing to unpack .../81-llvm-18-dev_1%3a18.1.7-1_amd64.deb ... 840s Unpacking llvm-18-dev (1:18.1.7-1) ... 843s Selecting previously unselected package locales-all. 843s Preparing to unpack .../82-locales-all_2.39-3.1ubuntu2_amd64.deb ... 843s Unpacking locales-all (2.39-3.1ubuntu2) ... 845s Selecting previously unselected package postgresql-client-16. 845s Preparing to unpack .../83-postgresql-client-16_16.3-1_amd64.deb ... 845s Unpacking postgresql-client-16 (16.3-1) ... 845s Selecting previously unselected package postgresql-16. 845s Preparing to unpack .../84-postgresql-16_16.3-1_amd64.deb ... 845s Unpacking postgresql-16 (16.3-1) ... 846s Selecting previously unselected package postgresql-server-dev-16. 846s Preparing to unpack .../85-postgresql-server-dev-16_16.3-1_amd64.deb ... 846s Unpacking postgresql-server-dev-16 (16.3-1) ... 846s Selecting previously unselected package postgresql-server-dev-all:amd64. 846s Preparing to unpack .../86-postgresql-server-dev-all_260_amd64.deb ... 846s Unpacking postgresql-server-dev-all:amd64 (260) ... 846s Selecting previously unselected package postgresql-plperl-16. 846s Preparing to unpack .../87-postgresql-plperl-16_16.3-1_amd64.deb ... 846s Unpacking postgresql-plperl-16 (16.3-1) ... 846s Selecting previously unselected package postgresql-plpython3-16. 846s Preparing to unpack .../88-postgresql-plpython3-16_16.3-1_amd64.deb ... 846s Unpacking postgresql-plpython3-16 (16.3-1) ... 846s Selecting previously unselected package postgresql-pltcl-16. 846s Preparing to unpack .../89-postgresql-pltcl-16_16.3-1_amd64.deb ... 846s Unpacking postgresql-pltcl-16 (16.3-1) ... 846s Selecting previously unselected package postgresql-all. 846s Preparing to unpack .../90-postgresql-all_260_all.deb ... 846s Unpacking postgresql-all (260) ... 846s Selecting previously unselected package postgresql-doc-16. 846s Preparing to unpack .../91-postgresql-doc-16_16.3-1_all.deb ... 846s Unpacking postgresql-doc-16 (16.3-1) ... 847s Selecting previously unselected package postgresql-doc. 847s Preparing to unpack .../92-postgresql-doc_16+260_all.deb ... 847s Unpacking postgresql-doc (16+260) ... 847s Selecting previously unselected package autopkgtest-satdep. 847s Preparing to unpack .../93-2-autopkgtest-satdep.deb ... 847s Unpacking autopkgtest-satdep (0) ... 847s Setting up postgresql-client-common (260) ... 847s Setting up libpgtypes3:amd64 (16.3-1) ... 847s Setting up libncurses-dev:amd64 (6.5-2) ... 847s Setting up postgresql-doc-16 (16.3-1) ... 847s update-alternatives: using /usr/share/postgresql/16/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 847s Setting up libarchive-zip-perl (1.68-1) ... 847s Setting up libdebhelper-perl (13.16ubuntu2) ... 847s Setting up libpq5:amd64 (16.3-1) ... 847s Setting up m4 (1.4.19-4build1) ... 847s Setting up llvm-18-tools (1:18.1.7-1) ... 847s Setting up libgomp1:amd64 (14.1.0-1ubuntu1) ... 847s Setting up libffi-dev:amd64 (3.4.6-1build1) ... 847s Setting up locales-all (2.39-3.1ubuntu2) ... 847s Setting up libfakeroot:amd64 (1.34-1) ... 847s Setting up fakeroot (1.34-1) ... 847s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 847s Setting up libpython3.12t64:amd64 (3.12.4-1) ... 847s Setting up autotools-dev (20220109.1) ... 847s Setting up libz3-4:amd64 (4.8.12-3.1build1) ... 847s Setting up libpfm4:amd64 (4.13.0+git32-g0d4ed0e-1) ... 847s Setting up gcc-13-base:amd64 (13.2.0-23ubuntu4) ... 847s Setting up emacsen-common (3.0.5) ... 847s Setting up ssl-cert (1.1.2ubuntu2) ... 848s Created symlink /etc/systemd/system/multi-user.target.wants/ssl-cert.service → /usr/lib/systemd/system/ssl-cert.service. 848s Setting up libquadmath0:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libssl-dev:amd64 (3.0.13-0ubuntu4) ... 848s Setting up libmpc3:amd64 (1.3.1-1build1) ... 848s Setting up libatomic1:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libtcl8.6:amd64 (8.6.14+dfsg-1build1) ... 848s Setting up autopoint (0.21-14ubuntu2) ... 848s Setting up icu-devtools (74.2-1ubuntu3) ... 848s Setting up libclang-common-18-dev:amd64 (1:18.1.7-1) ... 848s Setting up libgc1:amd64 (1:8.2.6-1build1) ... 848s Setting up autoconf (2.71-3) ... 848s Setting up llvm-18-linker-tools (1:18.1.7-1) ... 848s Setting up libubsan1:amd64 (14.1.0-1ubuntu1) ... 848s Setting up dwz (0.15-1build6) ... 848s Setting up libhwasan0:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libasan8:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libjson-perl (4.10000-1) ... 848s Setting up postgresql-doc (16+260) ... 848s Setting up libxslt1.1:amd64 (1.1.39-0exp1build1) ... 848s Setting up debugedit (1:5.0-5build2) ... 848s Setting up libecpg6:amd64 (16.3-1) ... 848s Setting up libtsan2:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libisl23:amd64 (0.26-3build1) ... 848s Setting up llvm-18-runtime (1:18.1.7-1) ... 848s Setting up libicu-dev:amd64 (74.2-1ubuntu3) ... 848s Setting up libcc1-0:amd64 (14.1.0-1ubuntu1) ... 848s Setting up liblsan0:amd64 (14.1.0-1ubuntu1) ... 848s Setting up libitm1:amd64 (14.1.0-1ubuntu1) ... 848s Setting up automake (1:1.16.5-1.3ubuntu1) ... 848s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 848s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 848s Setting up libz3-dev:amd64 (4.8.12-3.1build1) ... 848s Setting up gettext (0.21-14ubuntu2) ... 848s Setting up libecpg-compat3:amd64 (16.3-1) ... 848s Setting up dictionaries-common (1.29.7) ... 849s Setting up cpp-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 849s Setting up postgresql-client-16 (16.3-1) ... 850s update-alternatives: using /usr/share/postgresql/16/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 850s Setting up libpq-dev (16.3-1) ... 850s Setting up libobjc4:amd64 (14.1.0-1ubuntu1) ... 850s Setting up libecpg-dev (16.3-1) ... 850s Setting up intltool-debian (0.35.0+20060710.6) ... 850s Setting up libxml2-dev:amd64 (2.9.14+dfsg-1.3ubuntu3) ... 850s Setting up postgresql-common (260) ... 850s 850s Creating config file /etc/postgresql-common/createcluster.conf with new version 850s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 850s en_us 850s Removing obsolete dictionary files: 851s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /usr/lib/systemd/system/postgresql.service. 852s Setting up dh-strip-nondeterminism (1.14.0-1) ... 852s Setting up libgcc-13-dev:amd64 (13.2.0-23ubuntu4) ... 852s Setting up llvm-18 (1:18.1.7-1) ... 852s Setting up hunspell-en-us (1:2020.12.07-2) ... 852s Setting up libobjc-13-dev:amd64 (13.2.0-23ubuntu4) ... 852s Setting up libstdc++-13-dev:amd64 (13.2.0-23ubuntu4) ... 852s Setting up cpp-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 852s Setting up llvm-18-dev (1:18.1.7-1) ... 852s Setting up postgresql-16 (16.3-1) ... 852s Creating new PostgreSQL cluster 16/main ... 852s /usr/lib/postgresql/16/bin/initdb -D /var/lib/postgresql/16/main --auth-local peer --auth-host scram-sha-256 --no-instructions 852s The files belonging to this database system will be owned by user "postgres". 852s This user must also own the server process. 852s 852s The database cluster will be initialized with locale "C.UTF-8". 852s The default database encoding has accordingly been set to "UTF8". 852s The default text search configuration will be set to "english". 852s 852s Data page checksums are disabled. 852s 852s fixing permissions on existing directory /var/lib/postgresql/16/main ... ok 852s creating subdirectories ... ok 852s selecting dynamic shared memory implementation ... posix 852s selecting default max_connections ... 100 852s selecting default shared_buffers ... 128MB 852s selecting default time zone ... Etc/UTC 853s creating configuration files ... ok 853s running bootstrap script ... ok 853s performing post-bootstrap initialization ... ok 853s syncing data to disk ... ok 858s Setting up cpp-13 (13.2.0-23ubuntu4) ... 858s Setting up gcc-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 858s Setting up po-debconf (1.0.21+nmu1) ... 858s Setting up clang-18 (1:18.1.7-1) ... 858s Setting up gcc-13 (13.2.0-23ubuntu4) ... 858s Setting up postgresql-server-dev-16 (16.3-1) ... 858s Setting up postgresql-plpython3-16 (16.3-1) ... 858s Setting up cpp (4:13.2.0-7ubuntu1) ... 858s Setting up postgresql-plperl-16 (16.3-1) ... 858s Setting up postgresql-server-dev-all:amd64 (260) ... 858s Setting up postgresql-pltcl-16 (16.3-1) ... 858s Setting up g++-13-x86-64-linux-gnu (13.2.0-23ubuntu4) ... 858s Setting up gcc-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 858s Setting up libtool (2.4.7-7build1) ... 858s Setting up postgresql-all (260) ... 858s Setting up gcc (4:13.2.0-7ubuntu1) ... 858s Setting up dh-autoreconf (20) ... 858s Setting up g++-x86-64-linux-gnu (4:13.2.0-7ubuntu1) ... 858s Setting up g++-13 (13.2.0-23ubuntu4) ... 858s Setting up debhelper (13.16ubuntu2) ... 858s Setting up g++ (4:13.2.0-7ubuntu1) ... 858s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 858s Setting up build-essential (12.10ubuntu1) ... 858s Setting up autopkgtest-satdep (0) ... 858s Processing triggers for systemd (255.4-1ubuntu8) ... 858s Processing triggers for man-db (2.12.1-2) ... 861s Processing triggers for install-info (7.1-3build2) ... 861s Processing triggers for libc-bin (2.39-3.1ubuntu2) ... 861s Processing triggers for dictionaries-common (1.29.7) ... 865s (Reading database ... 92729 files and directories currently installed.) 865s Removing autopkgtest-satdep (0) ... 867s autopkgtest [18:33:53]: test run-testsuite: [----------------------- 868s ====== Running all tests with umask 077 ======= 868s ### PostgreSQL test 001_packages.t ### 868s 1..22 868s ok 1 - /etc/os-release exists 868s ok 2 - OS is ubuntu 868s ok 3 - OS version is 24.10 868s # PostgreSQL versions installed: 16 868s ok 4 - postgresql-16 installed 868s ok 5 # skip No python2 support 868s ok 6 - postgresql-plpython3-16 installed 869s ok 7 - postgresql-plperl-16 installed 869s ok 8 - postgresql-pltcl-16 installed 869s ok 9 - postgresql-server-dev-16 installed 869s ok 10 # skip No postgresql-contrib-16 package for version 16 869s # postgresql-doc-16 installed 869s ok 11 - At least one doc package installed 869s ok 12 - libecpg-dev installed 869s ok 13 - procps installed 869s ok 14 - netcat-openbsd installed 869s ok 15 - hunspell-en-us installed 869s ok 16 - system has a default UTF-8 locale 869s ok 17 - locale ru_RU exists 869s ok 18 - locale ru_RU.UTF-8 exists 869s ok 19 - user postgres in the UNIX group ssl-cert 869s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key exists 869s ok 21 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 869s ok 22 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 869s ### End test 001_packages.t ### 869s 869s ### PostgreSQL test 002_existing_clusters.t ### 869s 1..8 869s # Cleanup 869s ok 1 - Cleanup: No clusters left behind 869s ok 2 - No postgres processes left behind 869s ok 3 - No files in /etc/postgresql left behind 869s ok 4 - No files in /var/lib/postgresql left behind 869s ok 5 - No files in /var/run/postgresql left behind 869s ok 6 - No files in /var/log/postgresql left behind 869s ok 7 - PostgreSQL TCP ports are closed 869s ok 8 - Next free port is 5432 869s ### End test 002_existing_clusters.t ### 869s 869s ### PostgreSQL test 003_alternatives.t ### 869s 1..9 869s # Newest PG version installed is 16 869s ok 1 - psql.1.gz link group 869s ok 2 - postmaster.1.gz link group does not exist 869s ok 3 - psql.1.gz alternative 869s ok 4 - pg_dump.1.gz alternative 869s ok 5 - postgres.1.gz alternative 869s ok 6 - pg_ctl.1.gz alternative 869s # Newest PG doc version installed is 16 869s ok 7 - SPI_connect.3.gz link group 869s ok 8 - SPI_connect.3.gz alternative 869s ok 9 - SPI_exec.3.gz alternative 869s ### End test 003_alternatives.t ### 869s 869s ### PostgreSQL test 005_PgCommon.t ### 869s 1..24 869s ok 1 - correctly parsed line 'local all postgres ident sameuser' 869s ok 2 - correctly parsed line 'local foo nobody trust' 869s ok 3 - correctly parsed line 'local foo nobody crypt' 869s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 869s ok 5 - correctly parsed line 'local foo,bar nobody ident' 869s ok 6 - correctly parsed line 'local all +foogrp password' 869s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 869s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 869s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 869s ok 10 - @expected_records has correct number of entries 869s ok 11 - returned read_pg_hba array has correct number of records 869s ok 12 - line 'foo all all md5' parsed as invalid 869s ok 13 - line 'local all all foo' parsed as invalid 869s ok 14 - line 'host all all foo' parsed as invalid 869s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 869s ok 16 - line 'host all all md5' parsed as invalid 869s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 869s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 869s ok 19 - read_conf_file returns empty dict for nonexisting file 869s ok 20 - read_conf_file() parsing 869s ok 21 - read_conf_file() parsing with include directives 869s ok 22 - set_conf_value 869s ok 23 - disable_conf_value 869s ok 24 - replace_conf_value 869s ### End test 005_PgCommon.t ### 869s 869s ### PostgreSQL test 006_next_free_port.t ### 869s 1..5 869s ok 1 - next_free_port is 5432 870s ok 2 - next_free_port detects localhost ipv4 socket 871s ok 3 - next_free_port detects wildcard ipv4 socket 872s ok 4 - next_free_port detects localhost ipv6 socket 873s ok 5 - next_free_port detects wildcard ipv6 socket 873s ### End test 006_next_free_port.t ### 873s 873s ### PostgreSQL test 007_pg_conftool.t ### 873s 1..41 873s # test without cluster 873s ok 1 - pg_conftool show all 873s ok 2 - correct output of pg_conftool show all 874s ok 3 - pg_conftool foo.conf show all 874s ok 4 - correct output of pg_conftool foo.conf show all 874s ok 5 - pg_conftool /tmp/AlQIrCHmwb/different.conf show all 874s ok 6 - correct output of pg_conftool /tmp/AlQIrCHmwb/different.conf show all 874s ok 7 - pg_conftool 9.7 main show all 874s ok 8 - correct output of pg_conftool 9.7 main show all 874s # test show 874s ok 9 - pg_conftool show all 874s ok 10 - correct output of pg_conftool show all 874s ok 11 - pg_conftool other.conf show all 874s ok 12 - correct output of pg_conftool other.conf show all 874s ok 13 - pg_conftool /tmp/AlQIrCHmwb/different.conf show all 874s ok 14 - correct output of pg_conftool /tmp/AlQIrCHmwb/different.conf show all 874s ok 15 - pg_conftool 16 main show all 874s ok 16 - correct output of pg_conftool 16 main show all 874s ok 17 - pg_conftool 16 main other.conf show all 874s ok 18 - correct output of pg_conftool 16 main other.conf show all 874s ok 19 - pg_conftool show a 874s ok 20 - correct output of pg_conftool show a 874s ok 21 - pg_conftool -s show a 874s ok 22 - correct output of pg_conftool -s show a 874s # test set 874s ok 23 - pg_conftool set c 7 874s ok 24 - correct output of pg_conftool set c 7 874s ok 25 - file contains new setting 874s ok 26 - pg_conftool set a 8 874s ok 27 - correct output of pg_conftool set a 8 874s ok 28 - file contains updated setting 874s ok 29 - pg_conftool /tmp/AlQIrCHmwb/different.conf set a 9 874s ok 30 - correct output of pg_conftool /tmp/AlQIrCHmwb/different.conf set a 9 874s ok 31 - file with path contains updated setting 874s # test remove 874s ok 32 - pg_conftool remove a 874s ok 33 - correct output of pg_conftool remove a 874s ok 34 - setting removed from file 874s ok 35 - pg_conftool /tmp/AlQIrCHmwb/different.conf remove a 874s ok 36 - correct output of pg_conftool /tmp/AlQIrCHmwb/different.conf remove a 874s ok 37 - setting removed from file with path 874s # test edit 874s ok 38 - pg_conftool edit 874s ok 39 - correct output of pg_conftool edit 874s ok 40 - pg_conftool /tmp/AlQIrCHmwb/different.conf edit 874s ok 41 - correct output of pg_conftool /tmp/AlQIrCHmwb/different.conf edit 874s ### End test 007_pg_conftool.t ### 874s 874s ### PostgreSQL test 010_defaultport_cluster.t ### 874s 1..14 874s ok 1 - psql --version 874s ok 2 - pg_wrapper selects highest available version number 875s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 875s ok 4 - connecting to localhost fails with no clusters 875s ok 5 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -l 875s ok 6 - pg_wrapper uses host and port from PGCLUSTER 875s ok 7 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --cluster 16/127.0.0.3:5430 -l 875s ok 8 - pg_wrapper uses --cluster from the command line 875s ok 9 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql -h 127.0.0.3 -l 875s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 875s ok 11 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 psql --host 127.0.0.3 -l 875s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 875s ok 13 - env LC_MESSAGES=C PGCLUSTER=16/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 875s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 875s ### End test 010_defaultport_cluster.t ### 875s 875s ### PostgreSQL test 015_start_stop.t ### 875s 1..71 875s # We are running systemd 875s # Running tests for 16 875s # Cluster does not exist yet 875s ok 1 - cluster 16 main does not exist 875s ok 2 - service postgresql@16-main does not exist 875s ok 3 - systemctl start postgresql 875s ok 4 - cluster 16 main does not exist 875s ok 5 - service postgresql@16-main does not exist 875s ok 6 - systemctl start postgresql@16-main 875s ok 7 - cluster 16 main does not exist 875s ok 8 - service postgresql@16-main does not exist 875s # Start/stop postgresql using system tools 877s ok 9 - pg_createcluster 16 main 877s ok 10 - cluster 16 main is stopped 877s ok 11 - service postgresql@16-main is stopped 879s ok 12 - systemctl start postgresql 879s ok 13 - cluster 16 main is running 879s ok 14 - service postgresql@16-main is running 879s ok 15 - systemctl start postgresql 879s ok 16 - cluster 16 main is already running 879s ok 17 - service postgresql@16-main is already running 879s ok 18 - systemctl stop postgresql 885s ok 19 - cluster 16 main is stopped 885s ok 20 - service postgresql@16-main is stopped 885s ok 21 - systemctl stop postgresql 886s ok 22 - cluster 16 main is already stopped 886s ok 23 - service postgresql@16-main is already stopped 886s # Start/stop specific cluster using system tools 888s ok 24 - systemctl start postgresql@16-main 888s ok 25 - cluster 16 main is running 888s ok 26 - service postgresql@16-main is running 888s ok 27 - systemctl start postgresql@16-main 888s ok 28 - cluster 16 main is running 888s ok 29 - service postgresql@16-main is running 891s ok 30 - systemctl restart postgresql@16-main 891s ok 31 - cluster 16 main is running 891s ok 32 - service postgresql@16-main is running 891s ok 33 - systemctl stop postgresql@16-main 891s ok 34 - cluster 16 main is stopped 891s ok 35 - service postgresql@16-main is stopped 891s ok 36 - systemctl stop postgresql@16-main 891s ok 37 - cluster 16 main is already stopped 891s ok 38 - service postgresql@16-main is already stopped 893s ok 39 - pg_dropcluster 16 main 893s ok 40 - cluster 16 main does not exist 893s ok 41 - service postgresql@16-main does not exist 893s # Start/stop specific cluster using pg_*cluster 893s ok 42 - pg_ctlcluster start 16 main 893s ok 43 - cluster 16 main does not exist 893s ok 44 - service postgresql@16-main does not exist 897s ok 45 - pg_createcluster 16 main --start 897s ok 46 - cluster 16 main is running 897s ok 47 - service postgresql@16-main is running 897s ok 48 - pg_ctlcluster 16 main start 898s ok 49 - cluster 16 main is already running 898s ok 50 - service postgresql@16-main is already running 900s ok 51 - pg_ctlcluster 16-main restart 900s ok 52 - cluster 16 main is running 900s ok 53 - service postgresql@16-main is running 900s ok 54 - pg_ctlcluster 16 main stop 901s ok 55 - cluster 16 main is stopped 901s ok 56 - service postgresql@16-main is stopped 901s ok 57 - pg_ctlcluster 16 main stop 901s ok 58 - cluster 16 main is already stopped 901s ok 59 - service postgresql@16-main is already stopped 903s ok 60 - pg_ctlcluster start 16-main 903s ok 61 - cluster 16 main is running 903s ok 62 - service postgresql@16-main is running 906s ok 63 - pg_dropcluster 16 main --stop 906s # Cleanup 906s ok 64 - Cleanup: No clusters left behind 906s ok 65 - No postgres processes left behind 906s ok 66 - No files in /etc/postgresql left behind 906s ok 67 - No files in /var/lib/postgresql left behind 906s ok 68 - No files in /var/run/postgresql left behind 906s ok 69 - No files in /var/log/postgresql left behind 906s ok 70 - PostgreSQL TCP ports are closed 906s ok 71 - Next free port is 5432 906s ### End test 015_start_stop.t ### 906s 906s ### PostgreSQL test 020_create_sql_remove.t ### 906s 1..147 906s # Running tests for 16 910s ok 1 - pg_createcluster 16 main --start -- -X /tmp/16.xlog.WwQCpN 910s ok 2 - pg_createcluster 16 main 910s ok 3 - Socket and pid file are in /var/run/postgresql/ 910s ok 4 - xlog/wal directory /tmp/16.xlog.WwQCpN was created 910s ok 5 - local method in pg_hba.conf is peer 910s ok 6 - host method in pg_hba.conf is scram-sha-256 910s ok 7 - Exactly one postgres master process running 912s ok 8 - pg_ctlcluster 16 main restart 912s ok 9 - cluster restarts with new environment file 912s ok 10 - Exactly one postgres master process running 912s ok 11 - correct value of PGEXTRAVAR1 in environment 912s ok 12 - correct value of PGEXTRAVAR2 in environment 912s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 912s ok 14 - createdb --version 912s ok 15 - pg_wrapper+createdb selects version number of cluster 912s ok 16 - psql --version 912s ok 17 - pg_wrapper+psql selects version 16 912s ok 18 - pg_lscluster reports online cluster on port 5432 912s ok 19 - log file is actually used 912s ok 20 - /etc/postgresql is owned by user "postgres" 912s ok 21 - version configuration directory file is owned by user "postgres" 912s ok 22 - configuration directory file is owned by user "postgres" 912s ok 23 - version data directory file is owned by user "postgres" 912s ok 24 - data directory file is owned by user "postgres" 912s ok 25 - log file has 0640 permissions 912s ok 26 - log file is owned by user "postgres" 912s ok 27 - log file is owned by group "adm" 912s ok 28 - no log symlink by default 912s ok 29 - /var/log/postgresql/postgresql-16-main.log is the default log if log symlink is missing 912s ok 30 - pg_lsclusters -h 912s ok 31 - correct output of pg_lsclusters -h 912s ok 32 - stopping cluster 917s ok 33 - restarting cluster with nondefault log symlink 917s ok 34 - log target is used as log file 917s ok 35 - default log is not used 917s ok 36 - pg_lsclusters -h 917s ok 37 - correct output of pg_lsclusters -h 917s ok 38 - stopping cluster 918s ok 39 - restarting cluster with explicitly configured log file 918s ok 40 - default log is not used 918s ok 41 - log symlink target is used for startup message 918s ok 42 - exactly one log file 918s ok 43 - custom log is actually used 918s ok 44 - pg_lsclusters -h 918s ok 45 - correct output of pg_lsclusters -h 918s ok 46 - stopping cluster 919s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 919s ok 48 - /etc/postgres-hack was not created 921s ok 49 - restarting cluster 921s ok 50 - ps -o tty -U postgres h 921s ok 51 - postgres processes do not have an associated terminal 921s ok 52 - Server is linked with SSL support 921s ok 53 - SSL is enabled in postgresql.conf 921s ok 54 - psql -l fails for nobody 921s ok 55 - createuser nobody 921s ok 56 - createdb nobodydb 921s ok 57 - psql -ltA succeeds for nobody 921s ok 58 - psql -ltA output 921s ok 59 - SQL command: create table 921s ok 60 - SQL command: insert into table values 921s ok 61 - SQL command: insert into table values 921s ok 62 - primary key violation 921s ok 63 - psql -tAc "select * from phone order by name" nobodydb 921s ok 64 - SQL command output: select -tA 921s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 921s ok 66 - SQL command output: select -tx 922s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 922s ok 68 - SQL command output: select -tAx 922s ok 69 - CREATE EXTENSION plperlu fails for user nobody 922s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 922s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 922s ok 72 - creating PL/PerlU function as user nobody fails 922s ok 73 - creating unsafe PL/Perl function as user postgres fails 922s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 922s ok 75 - creating PL/PerlU function as user postgres succeeds 922s ok 76 - psql nobodydb -Atc "select read_file()" 922s ok 77 - calling PL/PerlU function 922s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 922s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 922s ok 80 - creating unsafe PL/Perl function as user nobody fails 922s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 922s ok 82 - creating PL/Perl function as user nobody succeeds 922s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 922s ok 84 - calling PL/Perl function 922s ok 85 # skip No python2 support 922s ok 86 # skip No python2 support 922s ok 87 # skip No python2 support 922s ok 88 # skip No python2 support 922s ok 89 # skip No python2 support 922s ok 90 # skip No python2 support 922s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 922s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 922s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 922s ok 94 - creating PL/Python3 function as user postgres succeeds 922s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 922s ok 96 - calling PL/Python function 923s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 923s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 923s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 923s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 923s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 923s ok 102 - creating PL/Tcl function as user nobody succeeds 923s ok 103 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 923s ok 104 - creating PL/TclU function as user postgres succeeds 923s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 923s ok 106 - calling PL/Tcl function 923s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 923s ok 108 - calling PL/TclU function 923s ok 109 - stopping cluster 923s ok 110 - pg_ctlcluster 16 main start 923s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 925s ok 112 - pg_ctlcluster 16 main start 925s ok 113 - cluster restarts with pgdata symlink 926s ok 114 - postgres master has OOM killer protection 926s ok 115 - postgres client backend has no OOM adjustment 926s ok 116 - ps h 6081 926s ok 117 - process title is idle 926s ok 118 - ps h 6081 926s ok 119 - process title is idle in transaction 927s ok 120 - stopping cluster 929s ok 121 - starting cluster as postgres works without a log file 929s ok 122 - log file got recreated and used 929s ok 123 - creating a directory in spc2 929s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/16.spc1.bfJRuU'" 929s ok 125 - creating tablespace spc1 929s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 929s ok 127 - creating a table in spc1 929s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/16.spc2.u8DrYt'" 929s ok 129 - creating tablespace spc2 929s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 929s ok 131 - creating a table in spc2 929s ok 132 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 929s ok 133 - Correct apt NeverAutoRemove config 931s ok 134 - pg_dropcluster removes cluster 931s ok 135 - xlog/wal directory /tmp/16.xlog.WwQCpN was deleted 931s ok 136 - tablespace spc1 was emptied 931s ok 137 - tablespace spc2 was emptied 931s ok 138 - grep -Eo 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 931s ok 139 - Correct apt NeverAutoRemove config 931s # Cleanup 931s ok 140 - Cleanup: No clusters left behind 931s ok 141 - No postgres processes left behind 931s ok 142 - No files in /etc/postgresql left behind 931s ok 143 - No files in /var/lib/postgresql left behind 931s ok 144 - No files in /var/run/postgresql left behind 931s ok 145 - No files in /var/log/postgresql left behind 931s ok 146 - PostgreSQL TCP ports are closed 931s ok 147 - Next free port is 5432 931s ### End test 020_create_sql_remove.t ### 931s 931s ### PostgreSQL test 021_pg_renamecluster.t ### 931s 1..20 935s ok 1 - pg_createcluster 16 main 938s ok 2 - pg_renamecluster 16 main donau 939s ok 3 - psql -tAc "show data_directory" 939s ok 4 - cluster is running and data_directory was moved 939s ok 5 - pg_hba.conf location updated 939s ok 6 - pg_ident.conf location updated 939s ok 7 - external_pid_file location updated 939s ok 8 - external_pid_file exists 939s ok 9 # skip no stats_temp_directory in 16 939s ok 10 # skip no stats_temp_directory in 16 939s ok 11 - cluster_name is updated 941s ok 12 - pg_dropcluster removes cluster 941s # Cleanup 941s ok 13 - Cleanup: No clusters left behind 941s ok 14 - No postgres processes left behind 941s ok 15 - No files in /etc/postgresql left behind 941s ok 16 - No files in /var/lib/postgresql left behind 941s ok 17 - No files in /var/run/postgresql left behind 941s ok 18 - No files in /var/log/postgresql left behind 941s ok 19 - PostgreSQL TCP ports are closed 941s ok 20 - Next free port is 5432 941s ### End test 021_pg_renamecluster.t ### 941s 941s ### PostgreSQL test 022_recovery.t ### 941s 1..17 941s # Running tests for 16 945s ok 1 - pg_createcluster 16 main --start >/dev/null 945s ok 2 - pg_ctlcluster 16 main stop -m i 947s ok 3 - pg_ctlcluster 16 main start 948s ok 4 - psql -c '' 948s ok 5 - pg_ctlcluster 16 main stop -m i 948s ok 6 - create write-protected file in data directory 950s ok 7 - pg_ctlcluster 16 main start 950s ok 8 - psql -c '' 953s ok 9 - pg_dropcluster removes cluster 953s # Cleanup 953s ok 10 - Cleanup: No clusters left behind 953s ok 11 - No postgres processes left behind 953s ok 12 - No files in /etc/postgresql left behind 953s ok 13 - No files in /var/lib/postgresql left behind 953s ok 14 - No files in /var/run/postgresql left behind 953s ok 15 - No files in /var/log/postgresql left behind 953s ok 16 - PostgreSQL TCP ports are closed 953s ok 17 - Next free port is 5432 953s ### End test 022_recovery.t ### 953s 953s ### PostgreSQL test 025_logging.t ### 953s 1..55 953s # Logging to /var/log/syslog works 953s # Running tests for 16 957s ok 1 - pg_createcluster 16 main 957s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-16-main.log 957s ok 3 - psql -qc "'foobar_16_7252'" 957s ok 4 - log an error 958s ok 5 - grep --binary-files=text foobar_16_7252 /var/log/postgresql/postgresql-16-main.log 958s ok 6 - error appears in logfile 958s ok 7 - pg_conftool 16 main set log_destination syslog 958s ok 8 - set log_destination syslog 958s ok 9 - pg_ctlcluster 16 main reload 958s ok 10 - 16 main reload 958s ok 11 - psql -Atc "show log_destination" 958s ok 12 - log_destination is syslog 958s ok 13 - pg_lscluster reports syslog 959s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 959s ok 15 - error appears in /var/log/syslog 959s ok 16 - pg_conftool 16 main set logging_collector on 959s ok 17 - set logging_collector on 959s ok 18 - pg_conftool 16 main set log_destination csvlog 959s ok 19 - set log_destination csvlog 961s ok 20 - pg_ctlcluster 16 main restart 961s ok 21 - 16 main restart 961s ok 22 - psql -Atc "show logging_collector" 961s ok 23 - logging_collector is on 961s ok 24 - psql -Atc "show log_destination" 961s ok 25 - log_destination is csvlog 961s ok 26 - pg_lscluster reports csvlog 961s ok 27 - psql -qc "'barbaz_16_7252'" 961s ok 28 - log an error 962s ok 29 - grep --binary-files=text barbaz_16_7252 /var/lib/postgresql/16/main/log/*.csv 962s ok 30 - error appears in log/*.csv 962s ok 31 - pg_conftool 16 main set log_destination stderr,syslog,csvlog 962s ok 32 - set log_destination stderr,syslog,csvlog 962s ok 33 - pg_ctlcluster 16 main reload 962s ok 34 - 16 main reload 962s ok 35 - psql -Atc "show log_destination" 962s ok 36 - log_destination is stderr,syslog,csvlog 962s ok 37 - pg_lscluster reports stderr,syslog,csvlog 962s ok 38 - psql -qc "'moo_16_7252'" 962s ok 39 - log an error 963s ok 40 - grep --binary-files=text moo_16_7252 /var/lib/postgresql/16/main/log/*.log 963s ok 41 - error appears in log/*.log 963s ok 42 - grep --binary-files=text 'postgres.*moo_16_7252' /var/log/syslog 963s ok 43 - error appears in /var/log/syslog 963s ok 44 - grep --binary-files=text moo_16_7252 /var/lib/postgresql/16/main/log/*.csv 963s ok 45 - error appears in log/*.csv 966s ok 46 - pg_dropcluster 16 main --stop 966s ok 47 - pg_dropcluster removes cluster 966s # Cleanup 966s ok 48 - Cleanup: No clusters left behind 966s ok 49 - No postgres processes left behind 966s ok 50 - No files in /etc/postgresql left behind 966s ok 51 - No files in /var/lib/postgresql left behind 966s ok 52 - No files in /var/run/postgresql left behind 966s ok 53 - No files in /var/log/postgresql left behind 966s ok 54 - PostgreSQL TCP ports are closed 966s ok 55 - Next free port is 5432 966s ### End test 025_logging.t ### 966s 966s ### PostgreSQL test 027_jit.t ### 966s # 16 970s ok 1 - pg_createcluster 16 main --start 970s ok 2 - psql -Xatc 'show jit' 970s ok 3 - JIT is on by default 970s ok 4 - psql -c 'explain (analyze) select count(*) from pg_class' 970s ok 5 - No JIT on cheap query 970s ok 6 - pg_conftool 16 main set seq_page_cost 100000 970s ok 7 - pg_conftool 16 main set random_page_cost 100000 970s ok 8 - pg_ctlcluster 16 main reload 971s ok 9 - psql -c 'explain (analyze) select count(*) from pg_class' 971s ok 10 - Expensive query is JITed 973s ok 11 - pg_dropcluster --stop 16 main 973s # Cleanup 973s ok 12 - Cleanup: No clusters left behind 973s ok 13 - No postgres processes left behind 973s ok 14 - No files in /etc/postgresql left behind 973s ok 15 - No files in /var/lib/postgresql left behind 973s ok 16 - No files in /var/run/postgresql left behind 973s ok 17 - No files in /var/log/postgresql left behind 973s ok 18 - PostgreSQL TCP ports are closed 973s ok 19 - Next free port is 5432 973s 1..19 973s ### End test 027_jit.t ### 973s 973s ### PostgreSQL test 030_errors.t ### 973s 1..156 973s ok 1 - pg_lscluster reports cluster without binaries 975s ok 2 - pg_dropcluster 6.3 main 976s ok 3 - pg_createcluster --socketdir 976s ok 4 - pg_lsclusters -h 976s ok 5 - cluster was created 976s ok 6 - Port of created cluster is 5432 976s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 16 main 976s ok 8 - pg_createcluster on existing cluster 976s ok 9 - pg_lsclusters -h 976s ok 10 - original cluster still exists 977s ok 11 - pg_createcluster 16 test -p foo 977s ok 12 - pg_createcluster -p checks that port option is numeric 977s ok 13 - pg_createcluster 16 test -p 42 977s ok 14 - pg_createcluster -p checks valid port range 977s ok 15 - pg_ctlcluster 16 main start 977s ok 16 - pg_ctlcluster refuses to start root-owned cluster 977s ok 17 - pg_ctlcluster 16 main start 977s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 977s ok 19 - pg_ctlcluster 16 main start 977s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 977s ok 21 - pg_ctlcluster 16 main start 977s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 979s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 979s ok 24 - No sockets in /var/run/postgresql 979s ok 25 - Socket is in /tmp/postgresql-testsuite/ 979s ok 26 - cluster stops with custom unix_socket_dir 979s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 982s ok 28 - cluster starts after removing unix_socket_dir 982s ok 29 - Socket is in default dir /var/run/postgresql 982s ok 30 - No sockets in /tmp/postgresql-testsuite/ 982s ok 31 - pg_ctlcluster 16 main stop 982s ok 32 - pg_ctlcluster fails with corrupted PID file 982s ok 33 - pg_lsclusters -h 982s ok 34 - cluster is still online 982s ok 35 - pg_ctlcluster succeeds with restored PID file 982s ok 36 - pg_lsclusters -h 982s ok 37 - cluster is down 982s ok 38 - pg_ctlcluster 16 main stop 982s ok 39 - pg_ctlcluster stop fails on stopped cluster 984s ok 40 - pg_ctlcluster 16 main start 984s ok 41 - pg_ctlcluster succeeds with already existing PID file 985s ok 42 - pg_lsclusters -h 985s ok 43 - cluster is online 985s ok 44 - pg_ctlcluster stop succeeds 985s ok 45 - pg_lsclusters -h 985s ok 46 - cluster is down 985s ok 47 - no pid file left 985s ok 48 - pg_ctlcluster 16 main stop 985s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 985s ok 50 - pid file was cleaned up 985s ok 51 - pg_ctlcluster --force 16 main stop 985s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 985s ok 53 - pid file was cleaned up 985s ok 54 - pg_ctlcluster 16 main stop 985s ok 55 - pg_ctlcluster stop succeeds with stale PID file 985s ok 56 - pid file was cleaned up 985s ok 57 - pg_ctlcluster --force 16 main stop 985s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 985s ok 59 - pid file was cleaned up 985s ok 60 - pg_ctlcluster --force 16 main stop 985s ok 61 - pg_ctlcluster stop succeeds with empty PID file 985s ok 62 - pid file was cleaned up 987s ok 63 - pg_ctlcluster 16 main start 987s ok 64 - pg_ctlcluster succeeds with corrupted PID file 988s ok 65 - pg_lsclusters -h 988s ok 66 - cluster is online 988s ok 67 - pg_ctlcluster 16 main start 988s ok 68 - pg_ctlcluster start fails on running cluster 988s ok 69 - pg_ctlcluster stop 988s ok 70 - pg_ctlcluster 16 main start 988s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 988s ok 72 - pg_ctlcluster 16 main stop 988s ok 73 - stopping cluster 994s ok 74 - pg_ctlcluster 16 main start 994s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 995s ok 76 - pg_ctlcluster 16 main stop 995s ok 77 - stopping cluster 995s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 995s ok 79 - pg_dropcluster 16 main 995s ok 80 - pg_dropcluster works as user postgres 996s ok 81 - pg_createcluster succeeds 996s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 996s ok 83 - proper error message for nonexisting /var/lib/postgresql 998s ok 84 - pg_ctlcluster 16 main start 998s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 999s ok 86 - pg_ctlcluster 16 main stop 999s ok 87 - stopping cluster 1000s ok 88 - pg_createcluster other 1002s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 1005s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 1005s ok 91 1005s ok 92 - pg_ctlcluster 16 other start 1005s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 1005s ok 94 - pg_ctlcluster 16 main stop 1005s ok 95 - stopping main cluster 1007s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 1009s ok 97 - pg_dropcluster other 1011s ok 98 - pg_dropcluster 1011s ok 99 - No sockets any more 1012s ok 100 - 'pg_lsclusters 4.5 foo' fails 1012s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 1012s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 1012s ok 103 - 'psql --cluster 4.5/foo' fails 1012s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 1012s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 1012s ok 106 - 'psql --cluster 16/foo' fails 1012s ok 107 - psql --cluster 16/foo gives error message about nonexisting cluster 1012s ok 108 - psql --cluster 16/foo does not print 'invalid symbolic link' gibberish 1012s ok 109 - 'pg_dropcluster 4.5 foo' fails 1012s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 1012s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 1012s ok 112 - 'pg_dropcluster 16 foo' fails 1012s ok 113 - pg_dropcluster 16 foo gives error message about nonexisting cluster 1012s ok 114 - pg_dropcluster 16 foo does not print 'invalid symbolic link' gibberish 1012s ok 115 - 'pg_upgradecluster 4.5 foo' fails 1012s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 1012s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 1012s ok 118 - 'pg_upgradecluster 16 foo' fails 1012s ok 119 - pg_upgradecluster 16 foo gives error message about nonexisting cluster 1012s ok 120 - pg_upgradecluster 16 foo does not print 'invalid symbolic link' gibberish 1012s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 1012s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 1012s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 1012s ok 124 - 'pg_ctlcluster 16 foo stop' fails 1012s ok 125 - pg_ctlcluster 16 foo stop gives error message about nonexisting cluster 1012s ok 126 - pg_ctlcluster 16 foo stop does not print 'invalid symbolic link' gibberish 1012s # Cleanup 1012s ok 127 - Cleanup: No clusters left behind 1012s ok 128 - No postgres processes left behind 1012s ok 129 - No files in /etc/postgresql left behind 1012s ok 130 - No files in /var/lib/postgresql left behind 1012s ok 131 - No files in /var/run/postgresql left behind 1012s ok 132 - No files in /var/log/postgresql left behind 1012s ok 133 - PostgreSQL TCP ports are closed 1012s ok 134 - Next free port is 5432 1014s ok 135 - pg_dropcluster 16 broken 1014s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 1014s # Cleanup 1014s ok 137 - Cleanup: No clusters left behind 1014s ok 138 - No postgres processes left behind 1014s ok 139 - No files in /etc/postgresql left behind 1014s ok 140 - No files in /var/lib/postgresql left behind 1014s ok 141 - No files in /var/run/postgresql left behind 1014s ok 142 - No files in /var/log/postgresql left behind 1014s ok 143 - PostgreSQL TCP ports are closed 1014s ok 144 - Next free port is 5432 1016s ok 145 - pg_dropcluster 16 broken 1016s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 1016s ok 147 - /etc/postgresql/16 was removed 1016s ok 148 - /var/lib/postgresql/16 was removed 1016s # Cleanup 1016s ok 149 - Cleanup: No clusters left behind 1016s ok 150 - No postgres processes left behind 1016s ok 151 - No files in /etc/postgresql left behind 1016s ok 152 - No files in /var/lib/postgresql left behind 1016s ok 153 - No files in /var/run/postgresql left behind 1016s ok 154 - No files in /var/log/postgresql left behind 1016s ok 155 - PostgreSQL TCP ports are closed 1016s ok 156 - Next free port is 5432 1016s ### End test 030_errors.t ### 1016s 1016s ### PostgreSQL test 031_errors_disk_full.t ### 1016s 1..22 1016s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 1018s ok 1 - script failed 1018s ok 2 - pg_createcluster fails due to insufficient disk space 1018s ok 3 - does not leave files behind 1018s # Cleanup 1018s ok 4 - Cleanup: No clusters left behind 1018s ok 5 - No postgres processes left behind 1018s ok 6 - No files in /etc/postgresql left behind 1018s ok 7 - No files in /var/lib/postgresql left behind 1018s ok 8 - No files in /var/run/postgresql left behind 1018s ok 9 - No files in /var/log/postgresql left behind 1018s ok 10 - PostgreSQL TCP ports are closed 1018s ok 11 - Next free port is 5432 1018s # check disk full conditions on startup 1022s ok 12 - script failed 1022s ok 13 - pg_ctlcluster prints error message 1022s ok 14 - log file has error message 1022s # Cleanup 1022s ok 15 - Cleanup: No clusters left behind 1022s ok 16 - No postgres processes left behind 1022s ok 17 - No files in /etc/postgresql left behind 1022s ok 18 - No files in /var/lib/postgresql left behind 1022s ok 19 - No files in /var/run/postgresql left behind 1022s ok 20 - No files in /var/log/postgresql left behind 1022s ok 21 - PostgreSQL TCP ports are closed 1022s ok 22 - Next free port is 5432 1022s ### End test 031_errors_disk_full.t ### 1022s 1022s ### PostgreSQL test 032_ssl_key_permissions.t ### 1022s 1..22 1022s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 1022s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 1022s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 1022s # 16 (16.3-1) 1024s ok 4 - pg_createcluster 16 main 1024s ok 5 - pg_ctlcluster 16 main start 1024s ok 6 - ssl key owned by nobody refused 1024s ok 7 - pg_ctlcluster 16 main start 1024s ok 8 - ssl key with permissions root:root 0644 refused 1024s ok 9 - pg_ctlcluster 16 main start 1024s ok 10 - ssl key with permissions postgres:postgres 0640 refused 1026s ok 11 - pg_dropcluster 16 main --stop 1026s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 1026s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 1026s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 1026s # Cleanup 1026s ok 15 - Cleanup: No clusters left behind 1026s ok 16 - No postgres processes left behind 1026s ok 17 - No files in /etc/postgresql left behind 1026s ok 18 - No files in /var/lib/postgresql left behind 1026s ok 19 - No files in /var/run/postgresql left behind 1026s ok 20 - No files in /var/log/postgresql left behind 1026s ok 21 - PostgreSQL TCP ports are closed 1026s ok 22 - Next free port is 5432 1026s ### End test 032_ssl_key_permissions.t ### 1026s 1026s ### PostgreSQL test 040_upgrade.t ### 1026s 1..1 1026s ok 1 - only one major version installed, skipping upgrade tests 1026s ### End test 040_upgrade.t ### 1026s 1026s ### PostgreSQL test 041_upgrade_custompaths.t ### 1026s 1..1 1026s ok 1 - only one major version installed, skipping upgrade tests 1026s ### End test 041_upgrade_custompaths.t ### 1026s 1026s ### PostgreSQL test 042_upgrade_rename.t ### 1026s 1..15 1026s # PostgreSQL 16 1030s ok 1 - pg_createcluster 16 main --start 1038s ok 2 - pg_upgradecluster -m upgrade --old-bindir=/usr/lib/postgresql/16/bin -v 16 --rename upgr 16 main 1038s ok 3 - pg_lsclusters -h 1038s ok 4 - correct output of pg_lsclusters -h 1039s ok 5 - pg_dropcluster 16 main --stop 1042s ok 6 - pg_dropcluster 16 upgr --stop 1042s ok 7 - Cleaning pg_upgrade log files 1042s # Cleanup 1042s ok 8 - Cleanup: No clusters left behind 1042s ok 9 - No postgres processes left behind 1042s ok 10 - No files in /etc/postgresql left behind 1042s ok 11 - No files in /var/lib/postgresql left behind 1042s ok 12 - No files in /var/run/postgresql left behind 1042s ok 13 - No files in /var/log/postgresql left behind 1042s ok 14 - PostgreSQL TCP ports are closed 1042s ok 15 - Next free port is 5432 1042s ### End test 042_upgrade_rename.t ### 1042s 1042s ### PostgreSQL test 043_upgrade_ssl_cert.t ### 1042s 1..1 1042s ok 1 - only one major version installed, skipping upgrade tests 1042s ### End test 043_upgrade_ssl_cert.t ### 1042s 1042s ### PostgreSQL test 045_backup.t ### 1042s # We are running systemd 1042s # PostgreSQL 16 1042s # create cluster 1046s ok 1 - pg_createcluster --locale en_US.UTF-8 16 main --start 1046s ok 2 - pg_lsclusters -h 1046s ok 3 - correct output of pg_lsclusters -h 1046s ok 4 - pg_conftool 16 main set work_mem 11MB 1046s ok 5 - createdb -E SQL_ASCII --locale-provider libc -T template0 mydb 1046s ok 6 - psql -c 'alter database mydb set search_path=public' 1046s ok 7 - psql -c 'create table foo (t text)' mydb 1046s ok 8 - psql -c "insert into foo values ('data from backup')" mydb 1046s ok 9 - psql -c 'CREATE USER myuser' 1046s ok 10 - psql -c 'grant create on database mydb to myuser' 1047s ok 11 - psql -c 'alter role myuser set search_path=public, myschema' 1047s ok 12 - createdb --locale-provider icu --icu-locale de -T template0 myicudb 1047s ok 13 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 1047s # create directory 1047s ok 14 - pg_backupcluster 16 main createdirectory 1047s ok 15 - /var/backups/postgresql/16-main owned by uid postgres 1047s ok 16 - /var/backups/postgresql/16-main owned by gid postgres 1047s # dump 1048s ok 17 - systemctl start pg_dump@16-main 1048s ok 18 - dump created in /var/backups/postgresql/16-main/2024-06-28T183653Z.dump 1048s ok 19 - /var/backups/postgresql/16-main/2024-06-28T183653Z.dump owned by uid postgres 1048s ok 20 - /var/backups/postgresql/16-main/2024-06-28T183653Z.dump owned by gid postgres 1048s # basebackup 1048s ok 21 - systemctl start pg_receivewal@16-main 1048s ok 22 - psql -c 'create table poke_receivewal (t text)' mydb 1048s ok 23 - /var/backups/postgresql/16-main/wal contains 000000010000000000000001.gz.partial # TODO WAL test is unstable 1048s ok 24 - psql -c 'alter system set checkpoint_timeout=30' 1048s ok 25 - psql -c 'select pg_reload_conf()' 1077s ok 26 - systemctl start pg_basebackup@16-main 1077s ok 27 - dump created in /var/backups/postgresql/16-main/2024-06-28T183655Z.backup 1077s ok 28 - /var/backups/postgresql/16-main/2024-06-28T183655Z.backup owned by uid postgres 1077s ok 29 - /var/backups/postgresql/16-main/2024-06-28T183655Z.backup owned by gid postgres 1077s # list 1077s ok 30 - pg_backupcluster 16 main list 1077s ok 31 - correct output of pg_backupcluster 16 main list 1077s # more database changes 1077s ok 32 - psql -c "insert into foo values ('data later deleted')" mydb 1077s ok 33 - psql -c "insert into foo values ('data from archive')" mydb 1077s ok 34 - retrieve recovery timestamp 1077s ok 35 - psql -c "delete from foo where t = 'data later deleted'" mydb 1078s ok 36 - systemctl stop pg_receivewal@16-main 1078s # restore /var/backups/postgresql/16-main/2024-06-28T183653Z.dump 1080s ok 37 - pg_dropcluster 16 main --stop 1085s ok 38 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-28T183653Z.dump --start --datadir /var/lib/postgresql/16/snowflake 1085s ok 39 - pg_lsclusters -h 1085s ok 40 - correct output of pg_lsclusters -h 1085s ok 41 - psql -XAtl 1085s ok 42 - mydb locales 1085s ok 43 - mydb grants 1085s ok 44 - myicudb locales 1085s ok 45 - psql -XAtc 'show work_mem' 1085s ok 46 - correct output of psql -XAtc 'show work_mem' 1085s ok 47 - psql -XAtc 'select * from foo' mydb 1085s ok 48 - correct output of psql -XAtc 'select * from foo' mydb 1085s ok 49 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1085s ok 50 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1086s ok 51 - psql -XAtc '\drds' 1086s ok 52 - correct output of psql -XAtc '\drds' 1086s # restore /var/backups/postgresql/16-main/2024-06-28T183655Z.backup 1088s ok 53 - pg_dropcluster 16 main --stop 1092s ok 54 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-28T183655Z.backup --start --datadir /var/lib/postgresql/16/snowflake 1092s ok 55 - pg_lsclusters -h 1092s ok 56 - correct output of pg_lsclusters -h 1092s ok 57 - psql -XAtl 1092s ok 58 - mydb locales 1092s ok 59 - mydb grants 1092s ok 60 - myicudb locales 1092s ok 61 - psql -XAtc 'show work_mem' 1092s ok 62 - correct output of psql -XAtc 'show work_mem' 1092s ok 63 - psql -XAtc 'select * from foo' mydb 1092s ok 64 - correct output of psql -XAtc 'select * from foo' mydb 1092s ok 65 - psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1092s ok 66 - correct output of psql -XAtc "select analyze_count between 1 and 3 from pg_stat_user_tables where relname = 'foo'" mydb 1092s ok 67 - psql -XAtc '\drds' 1092s ok 68 - correct output of psql -XAtc '\drds' 1092s # restore /var/backups/postgresql/16-main/2024-06-28T183655Z.backup with WAL archive 1095s ok 69 - pg_dropcluster 16 main --stop 1099s ok 70 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-28T183655Z.backup --start --archive --port 5430 1099s ok 71 - pg_lsclusters -h 1099s ok 72 - correct output of pg_lsclusters -h 1099s ok 73 - psql -XAtc 'select * from foo order by t' mydb 1099s ok 74 - correct output of psql -XAtc 'select * from foo order by t' mydb 1099s # restore /var/backups/postgresql/16-main/2024-06-28T183655Z.backup with PITR 1101s ok 75 - pg_dropcluster 16 main --stop 1105s ok 76 - pg_restorecluster 16 main /var/backups/postgresql/16-main/2024-06-28T183655Z.backup --start --pitr '2024-06-28 18:37:23.601236+00 1105s # ' 1105s ok 77 - pg_lsclusters -h 1105s ok 78 - correct output of pg_lsclusters -h 1105s ok 79 - psql -XAtc 'select * from foo order by t' mydb 1105s ok 80 - correct output of psql -XAtc 'select * from foo order by t' mydb 1108s ok 81 - pg_dropcluster 16 main --stop 1108s # Cleanup 1108s ok 82 - Cleanup: No clusters left behind 1108s ok 83 - No postgres processes left behind 1108s ok 84 - No files in /etc/postgresql left behind 1108s ok 85 - No files in /var/lib/postgresql left behind 1108s ok 86 - No files in /var/run/postgresql left behind 1108s ok 87 - No files in /var/log/postgresql left behind 1108s ok 88 - PostgreSQL TCP ports are closed 1108s ok 89 - Next free port is 5432 1108s 1..89 1108s ### End test 045_backup.t ### 1108s 1108s ### PostgreSQL test 050_encodings.t ### 1108s 1..60 1108s # Checking 16 ru_RU 1112s ok 1 - pg_createcluster version 16 for ru_RU without --encoding succeeded 1113s ok 2 - psql -l succeeds 1113s ok 3 - template1 is not UTF-8 encoded 1113s ok 4 - creating test database 1113s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 1113s # create table t (x varchar); copy t from stdin" test 1113s ok 6 - creating table with ISO-8859-5 characters 1113s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1113s ok 8 - correct string in UTF-8 1113s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1113s ok 10 - correct string in ISO-8859-5 1113s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 1113s # delete from t; copy t from stdin" test 1113s ok 12 - creating table with UTF-8 characters 1113s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1113s ok 14 - correct string in UTF-8 1113s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1113s ok 16 - correct string in ISO-8859-1 1113s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 1113s ok 18 - Server error message has correct language and encoding 1116s ok 19 - pg_ctlcluster 16 ru_RU restart 1116s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 1118s ok 21 - Dropping cluster 1118s # Checking 16 ru_RU.UTF-8 1122s ok 22 - pg_createcluster version 16 for ru_RU.UTF-8 without --encoding succeeded 1123s ok 23 - psql -l succeeds 1123s ok 24 - template1 is UTF-8 encoded 1123s ok 25 - creating test database 1123s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 1123s # create table t (x varchar); copy t from stdin" test 1123s ok 27 - creating table with ISO-8859-5 characters 1123s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1123s ok 29 - correct string in UTF-8 1123s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1123s ok 31 - correct string in ISO-8859-5 1123s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 1123s # delete from t; copy t from stdin" test 1123s ok 33 - creating table with UTF-8 characters 1123s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 1123s ok 35 - correct string in UTF-8 1123s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 1123s ok 37 - correct string in ISO-8859-1 1124s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 1124s ok 39 - Server error message has correct language and encoding 1126s ok 40 - pg_ctlcluster 16 ru_RU.UTF8 restart 1126s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 1126s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 1126s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 1126s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 1126s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 1126s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 1126s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 1129s ok 48 - Dropping cluster 1129s # Check 16 locale environment variables 1133s ok 49 - pg_createcluster: LC_ALL dominates LANG 1133s ok 50 - psql -Atl --cluster 16/main 1133s ok 51 - template1 is ASCII encoded 1135s ok 52 - Dropping cluster 1135s # Cleanup 1135s ok 53 - Cleanup: No clusters left behind 1135s ok 54 - No postgres processes left behind 1135s ok 55 - No files in /etc/postgresql left behind 1135s ok 56 - No files in /var/lib/postgresql left behind 1135s ok 57 - No files in /var/run/postgresql left behind 1135s ok 58 - No files in /var/log/postgresql left behind 1135s ok 59 - PostgreSQL TCP ports are closed 1135s ok 60 - Next free port is 5432 1136s ### End test 050_encodings.t ### 1136s 1136s ### PostgreSQL test 052_upgrade_encodings.t ### 1136s 1..1 1136s ok 1 - only one major version installed, skipping upgrade tests 1136s ### End test 052_upgrade_encodings.t ### 1136s 1136s ### PostgreSQL test 060_obsolete_confparams.t ### 1136s ok 1 - only one major version installed, skipping upgrade tests 1136s 1..1 1136s ### End test 060_obsolete_confparams.t ### 1136s 1136s ### PostgreSQL test 070_non_postgres_clusters.t ### 1136s 1..40 1137s ok 1 - pg_createcluster 16 main for owner nobody 1137s ok 2 - pg_ctlcluster 16 main start 1137s ok 3 - start refused when config and data owners mismatch 1140s ok 4 - pg_ctlcluster succeeds with owner nobody 1140s ok 5 - pg_lsclusters -h 1140s ok 6 - pg_lsclusters shows running cluster 1140s ok 7 - postgres is running as user nobody 1140s ok 8 - ls /tmp/.s.PGSQL.* 1140s ok 9 - socket is in /tmp 1140s ok 10 - /var/run/postgresql is empty 1140s ok 11 - conf dir is owned by user 1140s ok 12 - conf dir is owned by user's primary group 1140s ok 13 - files are owned by user 1140s ok 14 - files are owned by user's primary group 1140s ok 15 - log file has 0640 permissions 1140s ok 16 - log file is owned by user 1140s ok 17 - log file is owned by user's primary group 1140s ok 18 - only one major version installed, skipping upgrade test 1140s ok 19 - ... 1140s ok 20 - ... 1140s ok 21 - ... 1140s ok 22 - ... 1140s ok 23 - ... 1140s ok 24 - ... 1140s ok 25 - ... 1140s ok 26 - ... 1140s ok 27 - ... 1140s ok 28 - ... 1142s ok 29 - pg_dropcluster 1142s ok 30 - pg_lsclusters -h 1142s ok 31 - No clusters left 1142s ok 32 - No postgres processes left 1142s # Cleanup 1142s ok 33 - Cleanup: No clusters left behind 1142s ok 34 - No postgres processes left behind 1142s ok 35 - No files in /etc/postgresql left behind 1142s ok 36 - No files in /var/lib/postgresql left behind 1142s ok 37 - No files in /var/run/postgresql left behind 1142s ok 38 - No files in /var/log/postgresql left behind 1142s ok 39 - PostgreSQL TCP ports are closed 1142s ok 40 - Next free port is 5432 1142s ### End test 070_non_postgres_clusters.t ### 1142s 1142s ### PostgreSQL test 080_start.conf.t ### 1142s 1..73 1144s ok 1 - pg_createcluster 16 main 1144s # start.conf auto 1144s ok 2 - get_cluster_start_conf returns auto 1144s ok 3 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 1144s ok 4 - start.conf contains auto 1144s ok 5 - systemd generator links cluster 1144s ok 6 - systemd generator links correct service file 1146s ok 7 - /etc/init.d/postgresql start 16 1146s ok 8 - correct output of /etc/init.d/postgresql start 16 1146s ok 9 - pg_lsclusters -h 1146s ok 10 - cluster is online 1146s ok 11 - /etc/init.d/postgresql stop 16 1146s ok 12 - correct output of /etc/init.d/postgresql stop 16 1149s ok 13 - pg_lsclusters -h 1149s ok 14 - cluster is down 1149s # start.conf manual 1149s ok 15 - get_cluster_start_conf returns manual 1149s ok 16 - grep '^[^\\s\#]' /etc/postgresql/16/main/start.conf 1149s ok 17 - start.conf contains manual 1150s ok 18 - systemd generator doesn't link cluster 1150s ok 19 - /etc/init.d/postgresql start 16 1150s ok 20 - correct output of /etc/init.d/postgresql start 16 1150s ok 21 - pg_lsclusters -h 1150s ok 22 - cluster is down 1152s ok 23 - pg_ctlcluster 16 main start 1152s ok 24 - correct output of pg_ctlcluster 16 main start 1152s ok 25 - pg_lsclusters -h 1152s ok 26 - cluster is online 1152s ok 27 - pg_ctlcluster 16 main stop 1152s ok 28 - correct output of pg_ctlcluster 16 main stop 1152s ok 29 - pg_lsclusters -h 1152s ok 30 - cluster is down 1152s # start.conf disabled 1152s ok 31 - get_cluster_start_conf returns disabled 1153s ok 32 - systemd generator doesn't link cluster 1153s ok 33 - /etc/init.d/postgresql start 16 1153s ok 34 - correct output of /etc/init.d/postgresql start 16 1153s ok 35 - pg_lsclusters -h 1153s ok 36 - cluster is down 1153s ok 37 - pg_ctlcluster 16 main start 1153s ok 38 - correct output of pg_ctlcluster 16 main start 1153s ok 39 - pg_lsclusters -h 1153s ok 40 - cluster is down 1155s ok 41 - pg_ctlcluster 16 main start 1155s ok 42 - correct output of pg_ctlcluster 16 main start 1155s ok 43 - pg_lsclusters -h 1155s ok 44 - cluster is online 1156s ok 45 - pg_ctlcluster 16 main stop 1156s ok 46 - correct output of pg_ctlcluster 16 main stop 1156s ok 47 - pg_lsclusters -h 1156s ok 48 - cluster is down 1158s ok 49 - pg_ctlcluster 16 main start 1158s ok 50 - correct output of pg_ctlcluster 16 main start 1158s ok 51 - pg_lsclusters -h 1158s ok 52 - cluster is online 1158s # test upgrade 1158s ok 53 - only one major version installed, skipping upgrade test 1158s ok 54 - ... 1158s ok 55 - get_cluster_start_conf for old cluster returns manual 1158s ok 56 - get_cluster_start_conf for new cluster returns manual 1158s ok 57 - ... 1160s ok 58 - dropping upgraded cluster 1160s ok 59 - pg_lsclusters -h 1160s ok 60 - no clusters any more 1160s ok 61 - pg_createcluster 16 main --start-conf foo 1160s ok 62 - pg_createcluster checks --start-conf validity 1161s ok 63 - pg_createcluster checks --start-conf manual 1161s ok 64 - get_cluster_start_conf returns manual 1163s ok 65 - dropping cluster 1163s # Cleanup 1163s ok 66 - Cleanup: No clusters left behind 1163s ok 67 - No postgres processes left behind 1163s ok 68 - No files in /etc/postgresql left behind 1163s ok 69 - No files in /var/lib/postgresql left behind 1163s ok 70 - No files in /var/run/postgresql left behind 1163s ok 71 - No files in /var/log/postgresql left behind 1163s ok 72 - PostgreSQL TCP ports are closed 1163s ok 73 - Next free port is 5432 1163s ### End test 080_start.conf.t ### 1163s 1163s ### PostgreSQL test 085_pg_ctl.conf.t ### 1163s 1..33 1163s ok 1 - prlimit --core=0:unlimited --pid=15775 1163s ok 2 - set core file size to unlimited 1163s ok 3 - sh -c 'ulimit -Hc' 1163s ok 4 - core file size is unlimited 1165s ok 5 - pg_createcluster 16 main 1165s ok 6 - /etc/postgresql/16/main/pg_ctl.conf exists 1167s ok 7 - pg_ctlcluster 16 main start 1167s ok 8 - starting cluster as root 1167s ok 9 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1167s ok 10 - soft core size is 0 1167s # hard core file size limit of root-started postgres process is unlimited 1167s ok 11 - set pg_ctl default option to -c 1170s ok 12 - pg_ctlcluster 16 main restart 1170s ok 13 - restarting cluster as root 1170s ok 14 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1170s ok 15 - soft core size is unlimited 1170s ok 16 - pg_ctlcluster 16 main stop 1170s ok 17 - stopping cluster 1170s ok 18 - restored pg_ctl default option 1172s ok 19 - pg_ctlcluster 16 main start -- -c 1172s ok 20 - starting cluster with -c on the command line as postgres 1172s ok 21 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/16-main.pid 1172s ok 22 - soft core size is unlimited 1172s ok 23 - pg_ctlcluster 16 main stop 1172s ok 24 - stopping cluster 1175s ok 25 - dropping cluster 1175s # Cleanup 1175s ok 26 - Cleanup: No clusters left behind 1175s ok 27 - No postgres processes left behind 1175s ok 28 - No files in /etc/postgresql left behind 1175s ok 29 - No files in /var/lib/postgresql left behind 1175s ok 30 - No files in /var/run/postgresql left behind 1175s ok 31 - No files in /var/log/postgresql left behind 1175s ok 32 - PostgreSQL TCP ports are closed 1175s ok 33 - Next free port is 5432 1175s ### End test 085_pg_ctl.conf.t ### 1175s 1175s ### PostgreSQL test 090_multicluster.t ### 1175s 1..125 1176s ok 1 - pg_createcluster 16 old 1178s ok 2 - pg_createcluster 16 new1 1179s ok 3 - pg_createcluster 16 new2 1182s ok 4 - starting cluster 16/old 1184s ok 5 - starting cluster 16/new1 1186s ok 6 - starting cluster 16/new2 1187s ok 7 - pg_lsclusters -h | sort -k3 1187s ok 8 - clusters have the correct ports, skipping used 5433 1187s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 1187s ok 10 - createdb --version 1187s ok 11 - pg_wrapper selects port 5432 as default cluster 1187s ok 12 - createdb --cluster 16/new1 --version 1187s ok 13 - pg_wrapper --cluster works 1187s ok 14 - createdb --cluster 16/foo --version 1187s ok 15 - pg_wrapper --cluster errors out for invalid cluster 1187s ok 16 - createdb --cluster 16/new1 test 1187s ok 17 - correct output of createdb --cluster 16/new1 test 1187s ok 18 - psql -Atl --cluster 16/new1 1187s ok 19 - test db appears in cluster new1 1187s ok 20 - psql -Atl --cluster 16/new2 1187s ok 21 - test db does not appear in cluster new2 1187s ok 22 - psql -Atl 1187s ok 23 - test db does not appear in default cluster 1187s ok 24 - psql --cluster 16/127.0.0.1: -Atc 'show port' template1 1187s ok 25 - psql --cluster 16/127.0.0.1: defaults to port 5432 1187s ok 26 - createdb --cluster 16/127.0.0.1:5432 --version 1187s ok 27 - createdb --cluster 16/127.0.0.1:5432 uses latest client version 1187s ok 28 - psql -Atl --cluster 16/localhost:5434 1187s ok 29 - test db appears in cluster 16/localhost:5434 1187s ok 30 - psql -Atl --cluster 16/localhost:5440 1187s ok 31 - test db does not appear in cluster 16/localhost:5440 1187s ok 32 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:5435 1187s ok 33 - psql --cluster 16/localhost:5435 fails due to nonexisting port 1187s ok 34 - LC_MESSAGES=C psql -Atl --cluster 16/localhost:a 1187s ok 35 - psql --cluster 16/localhost:a fails due to invalid syntax 1187s ok 36 - LC_MESSAGES=C psql -Atl --cluster 16/doesnotexi.st 1187s ok 37 - psql --cluster 16/doesnotexi.st fails due to invalid syntax 1187s ok 38 - psql -Atl --cluster 6.4/localhost: 1187s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 1188s ok 40 - psql -Atl 1188s ok 41 - PGCLUSTER selection (1) 1188s ok 42 - psql -Atl 1188s ok 43 - PGCLUSTER selection (2) 1188s ok 44 - psql -l 1188s ok 45 - invalid PGCLUSTER value 1188s ok 46 - createdb --version 1188s ok 47 - PGCLUSTER network cluster selection (1) 1188s ok 48 - psql -Atl 1188s ok 49 - PGCLUSTER network cluster selection (2) 1188s ok 50 - psql -Atl 1188s ok 51 - PGCLUSTER network cluster selection (3) 1188s ok 52 - LC_MESSAGES=C psql -Atl 1188s ok 53 - psql --cluster 16/localhost:5435 fails due to nonexisting port 1188s ok 54 - psql -Atc "show port" template1 1188s ok 55 - PGPORT selection (1) 1188s ok 56 - psql -Atc "show port" template1 1188s ok 57 - PGPORT selection (2) 1188s ok 58 - createdb --version 1188s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 1188s ok 60 - psql -Atc "show port" template1 1188s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 1188s ok 62 - psql --cluster 16/new1 -Atc 'select current_database()' 1188s ok 63 - PGDATABASE environment variable works 1188s ok 64 - createdb --version 1188s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 1188s ok 66 - createdb --cluster 16/new1 --version 1188s ok 67 - pg_wrapper --cluster works with empty user_clusters 1188s ok 68 - createdb --version 1188s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 16 new1 *' 1189s ok 70 - psql -Atc "select current_database()" 1189s ok 71 - pg_wrapper selects correct database with user_clusters '* * 16 new1 test' 1189s ok 72 - psql -Atc 'select current_database()' 1189s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 1189s ok 74 - createdb --version 1189s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 1189s ok 76 - createdb --version 1189s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 1189s ok 78 - createdb --version 1189s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 1189s ok 80 - createdb --version 1189s ok 81 - pg_wrapper selects correct version with per-user user_clusters 1189s ok 82 - createdb --version 1189s ok 83 - pg_wrapper selects correct version with per-user user_clusters 1189s ok 84 - createdb --version 1189s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 1189s ok 86 - psql -Atl 1189s ok 87 - $PGHOST overrides user_clusters 1189s ok 88 - psql --cluster 16/localhost:5434 -Atc 'select current_database()' test 1189s ok 89 - --cluster overrides $PGHOST 1189s ok 90 - createdb --version 1189s ok 91 - pg_wrapper ignores invalid lines in user_clusters 1189s ok 92 - psql -Atc 'select current_database()' 1189s ok 93 - pg_service conf selection 1 1189s ok 94 - psql -Atc 'select current_database()' 1189s ok 95 - pg_service conf selection 2 1189s ok 96 - psql -Atc 'select current_database()' 1189s ok 97 - pg_service conf selection 3 1190s ok 98 - stopping cluster 16/old 1192s ok 99 - restarting cluster 16/old 1192s ok 100 - pg_lsclusters -h | sort -k3 1192s ok 101 - port of first cluster was successfully changed 1192s ok 102 - psql -l 1192s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 1192s ok 104 - psql -Atl --cluster 16/new1 1192s ok 105 - --cluster selects appropriate cluster 1192s ok 106 - psql -Atl -p 5434 1192s ok 107 - -p selects appropriate cluster 1192s ok 108 - psql -Atlp 5434 1192s ok 109 - -Atlp selects appropriate cluster 1192s ok 110 - psql -Atl --port 5434 1192s ok 111 - --port selects appropriate cluster 1192s ok 112 - env PGPORT=5434 psql -Atl 1192s ok 113 - $PGPORT selects appropriate cluster 1192s ok 114 - Restoring original /etc/postgresql-common/user_clusters 1195s ok 115 - dropping 16/new1 1197s ok 116 - dropping 16/new2 1199s ok 117 - dropping 16/old 1199s # Cleanup 1200s ok 118 - Cleanup: No clusters left behind 1200s ok 119 - No postgres processes left behind 1200s ok 120 - No files in /etc/postgresql left behind 1200s ok 121 - No files in /var/lib/postgresql left behind 1200s ok 122 - No files in /var/run/postgresql left behind 1200s ok 123 - No files in /var/log/postgresql left behind 1200s ok 124 - PostgreSQL TCP ports are closed 1200s ok 125 - Next free port is 5432 1200s ### End test 090_multicluster.t ### 1200s 1200s ### PostgreSQL test 110_integrate_cluster.t ### 1200s 1..32 1201s ok 1 - /usr/lib/postgresql/16/bin/initdb /tmp/J3l7QA23hP/c/postgres 1201s ok 2 - creating raw initdb cluster for user postgres 1202s ok 3 - pg_createcluster 16 postgres -d /tmp/J3l7QA23hP/c/postgres 1202s ok 4 - integrating postgres cluster 1202s ok 5 - pg_lsclusters 1202s ok 6 - correct pg_lsclusters output 1204s ok 7 - pg_ctlcluster 16 postgres start 1204s ok 8 - starting cluster postgres 1204s ok 9 - pg_lsclusters 1204s ok 10 - correct pg_lsclusters output 1206s ok 11 - dropping cluster postgres 1206s ok 12 - No files in temporary cluster dir left behind 1208s ok 13 - /usr/lib/postgresql/16/bin/initdb /tmp/J3l7QA23hP/c/nobody 1208s ok 14 - creating raw initdb cluster for user nobody 1208s ok 15 - pg_createcluster 16 nobody -d /tmp/J3l7QA23hP/c/nobody 1208s ok 16 - integrating nobody cluster 1208s ok 17 - pg_lsclusters 1208s ok 18 - correct pg_lsclusters output 1211s ok 19 - pg_ctlcluster 16 nobody start 1211s ok 20 - starting cluster nobody 1211s ok 21 - pg_lsclusters 1211s ok 22 - correct pg_lsclusters output 1213s ok 23 - dropping cluster nobody 1213s ok 24 - No files in temporary cluster dir left behind 1213s # Cleanup 1213s ok 25 - Cleanup: No clusters left behind 1213s ok 26 - No postgres processes left behind 1213s ok 27 - No files in /etc/postgresql left behind 1213s ok 28 - No files in /var/lib/postgresql left behind 1213s ok 29 - No files in /var/run/postgresql left behind 1213s ok 30 - No files in /var/log/postgresql left behind 1213s ok 31 - PostgreSQL TCP ports are closed 1213s ok 32 - Next free port is 5432 1213s ### End test 110_integrate_cluster.t ### 1213s 1213s ### PostgreSQL test 120_pg_upgradecluster_scripts.t ### 1213s 1..1 1213s ok 1 - only one major version installed, skipping upgrade tests 1213s ### End test 120_pg_upgradecluster_scripts.t ### 1213s 1213s ### PostgreSQL test 130_nonroot_admin.t ### 1213s 1..22 1217s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 1217s ok 2 - pg_lsclusters -h 1217s ok 3 - correct output of pg_lsclusters -h 1217s ok 4 - psql -Atl 1217s ok 5 - correct output of psql -Atl 1217s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 1217s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 1217s # Cleanup 1217s ok 15 - Cleanup: No clusters left behind 1217s ok 16 - No postgres processes left behind 1217s ok 17 - No files in /etc/postgresql left behind 1217s ok 18 - No files in /var/lib/postgresql left behind 1217s ok 19 - No files in /var/run/postgresql left behind 1217s ok 20 - No files in /var/log/postgresql left behind 1217s ok 21 - PostgreSQL TCP ports are closed 1217s ok 22 - Next free port is 5432 1217s ### End test 130_nonroot_admin.t ### 1217s 1217s ### PostgreSQL test 135_pg_virtualenv.t ### 1217s 1..20 1224s ok 1 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1224s ok 2 - running pg_virtualenv as root 1227s ok 3 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1227s ok 4 - running pg_virtualenv as postgres 1231s ok 5 - pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1231s ok 6 - running pg_virtualenv as nobody 1235s ok 7 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1235s ok 8 - running fakeroot pg_virtualenv as root 1239s ok 9 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1239s ok 10 - running fakeroot pg_virtualenv as postgres 1243s ok 11 - fakeroot pg_virtualenv -v 16 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 1243s ok 12 - running fakeroot pg_virtualenv as nobody 1243s # Cleanup 1243s ok 13 - Cleanup: No clusters left behind 1243s ok 14 - No postgres processes left behind 1243s ok 15 - No files in /etc/postgresql left behind 1243s ok 16 - No files in /var/lib/postgresql left behind 1243s ok 17 - No files in /var/run/postgresql left behind 1243s ok 18 - No files in /var/log/postgresql left behind 1243s ok 19 - PostgreSQL TCP ports are closed 1243s ok 20 - Next free port is 5432 1243s ### End test 135_pg_virtualenv.t ### 1243s 1243s ### PostgreSQL test 140_pg_config.t ### 1243s 1..38 1243s # Multiarch is enabled 1243s # checking version specific output for 16 1243s ok 1 - /usr/lib/postgresql/16/bin/pg_config --pgxs 1243s ok 2 - correct output of /usr/lib/postgresql/16/bin/pg_config --pgxs 1243s ok 3 - /usr/lib/postgresql/16/bin/pg_config --libdir 1243s ok 4 - correct output of /usr/lib/postgresql/16/bin/pg_config --libdir 1243s ok 5 - /usr/lib/postgresql/16/bin/pg_config --pkglibdir 1243s ok 6 - correct output of /usr/lib/postgresql/16/bin/pg_config --pkglibdir 1243s ok 7 - /usr/lib/postgresql/16/bin/pg_config --bindir 1243s ok 8 - correct output of /usr/lib/postgresql/16/bin/pg_config --bindir 1243s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/16/lib/pgxs/src/Makefile.global 1243s # checking pg_config output (should behave like version 16) 1243s ok 15 - pg_config 1243s ok 16 - correct output of pg_config 1243s ok 17 - pg_config --help 1243s ok 18 - correct output of pg_config --help 1243s ok 19 - pg_config --pgxs 1243s ok 20 - correct output of pg_config --pgxs 1243s ok 21 - pg_config --libdir 1243s ok 22 - correct output of pg_config --libdir 1243s ok 23 - pg_config --pkglibdir 1243s ok 24 - correct output of pg_config --pkglibdir 1243s ok 25 - pg_config --bindir 1243s ok 26 - correct output of pg_config --bindir 1243s # checking pg_config.libpq-dev output (should behave like version 16) 1243s ok 27 - pg_config.libpq-dev 1243s ok 28 - correct output of pg_config.libpq-dev 1243s ok 29 - pg_config.libpq-dev --help 1243s ok 30 - correct output of pg_config.libpq-dev --help 1243s ok 31 - pg_config.libpq-dev --pgxs 1243s ok 32 - correct output of pg_config.libpq-dev --pgxs 1243s ok 33 - pg_config.libpq-dev --libdir 1243s ok 34 - correct output of pg_config.libpq-dev --libdir 1243s ok 35 - pg_config.libpq-dev --pkglibdir 1243s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 1243s ok 37 - pg_config.libpq-dev --bindir 1243s ok 38 - correct output of pg_config.libpq-dev --bindir 1243s ### End test 140_pg_config.t ### 1243s 1243s ### PostgreSQL test 150_tsearch_stemming.t ### 1243s 1..37 1243s ok 1 - pg_updatedicts succeeded 1243s ok 2 - pg_updatedicts created en_us.affix 1243s ok 3 - pg_updatedicts created en_us.dict 1243s ok 4 - pg_updatedicts created 16 en_us.affix symlink 1243s ok 5 - pg_updatedicts created 16 en_us.dict symlink 1247s ok 6 - pg_createcluster 16 main 1247s ok 7 - createdb fts 1247s ok 8 - correct output of createdb fts 1248s ok 9 - creating en_US full text search configuration 1248s ok 10 - creating data table and search index 1248s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 1248s ok 12 - stem search of correct word 1248s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 1248s ok 14 - stem search of correct word 1249s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 1249s ok 16 - stem search of unknown word 1249s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 1249s ok 18 - full text search, exact word 1249s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 1249s ok 20 - full text search for word stem 1249s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 1249s ok 22 - full text search for word substring fails 1249s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 1249s ok 24 - full text search, exact unicode word 1249s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 1249s ok 26 - full text search for unicode word stem 1249s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 1249s ok 28 - full text search for unicode word substring fails 1251s ok 29 1251s # Cleanup 1251s ok 30 - Cleanup: No clusters left behind 1251s ok 31 - No postgres processes left behind 1251s ok 32 - No files in /etc/postgresql left behind 1251s ok 33 - No files in /var/lib/postgresql left behind 1251s ok 34 - No files in /var/run/postgresql left behind 1251s ok 35 - No files in /var/log/postgresql left behind 1251s ok 36 - PostgreSQL TCP ports are closed 1251s ok 37 - Next free port is 5432 1251s ### End test 150_tsearch_stemming.t ### 1251s 1251s ### PostgreSQL test 160_alternate_confroot.t ### 1252s 1..28 1255s ok 1 1255s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1255s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 1255s ok 4 - pg_lsclusters -h 1255s ok 5 - correct output of pg_lsclusters -h 1255s ok 6 - psql -Atl 1255s ok 7 - correct output of psql -Atl 1255s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 1255s ok 9 - ... 1255s ok 10 - ... 1255s ok 11 - ... 1255s ok 12 - ... 1255s ok 13 - ... 1255s ok 14 - ... 1256s ok 15 - pg_dropcluster 16 test --stop 1256s ok 16 - correct output of pg_dropcluster 16 test --stop 1256s ok 17 - pg_lsclusters -h 1256s ok 18 - correct output of pg_lsclusters -h 1256s ok 19 - No files in root/data left behind 1256s ok 20 - No cruft in root dir left behind 1256s # Cleanup 1256s ok 21 - Cleanup: No clusters left behind 1256s ok 22 - No postgres processes left behind 1256s ok 23 - No files in /etc/postgresql left behind 1256s ok 24 - No files in /var/lib/postgresql left behind 1256s ok 25 - No files in /var/run/postgresql left behind 1256s ok 26 - No files in /var/log/postgresql left behind 1256s ok 27 - PostgreSQL TCP ports are closed 1256s ok 28 - Next free port is 5432 1256s ### End test 160_alternate_confroot.t ### 1256s 1256s ### PostgreSQL test 170_extensions.t ### 1256s # Running tests for 16 1260s ok 1 - pg_createcluster 16 main 1260s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 1260s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 1260s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 1260s ok 5 - extension adminpack installs without error 1260s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 1260s ok 7 - extension adminpack removes without error 1260s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 1260s ok 9 - extension amcheck installs without error 1260s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 1260s ok 11 - extension amcheck removes without error 1260s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 1260s ok 13 - extension autoinc installs without error 1260s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 1260s ok 15 - extension autoinc removes without error 1260s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 1260s ok 17 - extension bloom installs without error 1260s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 1260s ok 19 - extension bloom removes without error 1260s ok 20 - psql -qc 'CREATE EXTENSION plperl' 1260s ok 21 - bool_plperl dependency plperl installs without error 1261s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 1261s ok 23 - extension bool_plperl installs without error 1261s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 1261s ok 25 - extension bool_plperl removes without error 1261s ok 26 - psql -qc 'DROP EXTENSION plperl' 1261s ok 27 - bool_plperl dependency extension plperl removes without error 1261s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 1261s ok 29 - bool_plperlu dependency plperlu installs without error 1261s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 1261s ok 31 - extension bool_plperlu installs without error 1261s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 1261s ok 33 - extension bool_plperlu removes without error 1261s ok 34 - psql -qc 'DROP EXTENSION plperlu' 1261s ok 35 - bool_plperlu dependency extension plperlu removes without error 1261s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 1261s ok 37 - extension btree_gin installs without error 1261s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 1261s ok 39 - extension btree_gin removes without error 1261s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 1261s ok 41 - extension btree_gist installs without error 1261s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 1261s ok 43 - extension btree_gist removes without error 1261s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 1261s ok 45 - extension citext installs without error 1261s ok 46 - psql -qc 'DROP EXTENSION "citext"' 1261s ok 47 - extension citext removes without error 1262s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 1262s ok 49 - extension cube installs without error 1262s ok 50 - psql -qc 'DROP EXTENSION "cube"' 1262s ok 51 - extension cube removes without error 1262s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 1262s ok 53 - extension dblink installs without error 1262s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 1262s ok 55 - extension dblink removes without error 1262s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 1262s ok 57 - extension dict_int installs without error 1262s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 1262s ok 59 - extension dict_int removes without error 1262s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 1262s ok 61 - extension dict_xsyn installs without error 1262s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 1262s ok 63 - extension dict_xsyn removes without error 1262s ok 64 - psql -qc 'CREATE EXTENSION cube' 1262s ok 65 - earthdistance dependency cube installs without error 1262s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 1262s ok 67 - extension earthdistance installs without error 1262s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 1262s ok 69 - extension earthdistance removes without error 1262s ok 70 - psql -qc 'DROP EXTENSION cube' 1262s ok 71 - earthdistance dependency extension cube removes without error 1262s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 1262s ok 73 - extension file_fdw installs without error 1262s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 1262s ok 75 - extension file_fdw removes without error 1263s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 1263s ok 77 - extension fuzzystrmatch installs without error 1263s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 1263s ok 79 - extension fuzzystrmatch removes without error 1263s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 1263s ok 81 - extension hstore installs without error 1263s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 1263s ok 83 - extension hstore removes without error 1263s ok 84 - psql -qc 'CREATE EXTENSION hstore' 1263s ok 85 - hstore_plperl dependency hstore installs without error 1263s ok 86 - psql -qc 'CREATE EXTENSION plperl' 1263s ok 87 - hstore_plperl dependency plperl installs without error 1263s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 1263s ok 89 - extension hstore_plperl installs without error 1263s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 1263s ok 91 - extension hstore_plperl removes without error 1263s ok 92 - psql -qc 'DROP EXTENSION hstore' 1263s ok 93 - hstore_plperl dependency extension hstore removes without error 1263s ok 94 - psql -qc 'DROP EXTENSION plperl' 1263s ok 95 - hstore_plperl dependency extension plperl removes without error 1263s ok 96 - psql -qc 'CREATE EXTENSION hstore' 1263s ok 97 - hstore_plperlu dependency hstore installs without error 1263s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 1263s ok 99 - hstore_plperlu dependency plperlu installs without error 1263s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 1263s ok 101 - extension hstore_plperlu installs without error 1263s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 1263s ok 103 - extension hstore_plperlu removes without error 1263s ok 104 - psql -qc 'DROP EXTENSION hstore' 1263s ok 105 - hstore_plperlu dependency extension hstore removes without error 1264s ok 106 - psql -qc 'DROP EXTENSION plperlu' 1264s ok 107 - hstore_plperlu dependency extension plperlu removes without error 1264s ok 108 - psql -qc 'CREATE EXTENSION hstore' 1264s ok 109 - hstore_plpython3u dependency hstore installs without error 1264s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 1264s ok 111 - hstore_plpython3u dependency plpython3u installs without error 1264s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 1264s ok 113 - extension hstore_plpython3u installs without error 1264s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 1264s ok 115 - extension hstore_plpython3u removes without error 1264s ok 116 - psql -qc 'DROP EXTENSION hstore' 1264s ok 117 - hstore_plpython3u dependency extension hstore removes without error 1264s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 1264s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 1264s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 1264s ok 121 - extension insert_username installs without error 1264s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 1264s ok 123 - extension insert_username removes without error 1264s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 1264s ok 125 - extension intagg installs without error 1264s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 1264s ok 127 - extension intagg removes without error 1264s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 1264s ok 129 - extension intarray installs without error 1265s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 1265s ok 131 - extension intarray removes without error 1265s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 1265s ok 133 - extension isn installs without error 1265s ok 134 - psql -qc 'DROP EXTENSION "isn"' 1265s ok 135 - extension isn removes without error 1265s ok 136 - psql -qc 'CREATE EXTENSION plperl' 1265s ok 137 - jsonb_plperl dependency plperl installs without error 1265s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 1265s ok 139 - extension jsonb_plperl installs without error 1265s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 1265s ok 141 - extension jsonb_plperl removes without error 1265s ok 142 - psql -qc 'DROP EXTENSION plperl' 1265s ok 143 - jsonb_plperl dependency extension plperl removes without error 1265s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 1265s ok 145 - jsonb_plperlu dependency plperlu installs without error 1265s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 1265s ok 147 - extension jsonb_plperlu installs without error 1265s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 1265s ok 149 - extension jsonb_plperlu removes without error 1265s ok 150 - psql -qc 'DROP EXTENSION plperlu' 1265s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 1265s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 1265s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 1266s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 1266s ok 155 - extension jsonb_plpython3u installs without error 1266s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 1266s ok 157 - extension jsonb_plpython3u removes without error 1266s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 1266s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 1266s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 1266s ok 161 - extension lo installs without error 1266s ok 162 - psql -qc 'DROP EXTENSION "lo"' 1266s ok 163 - extension lo removes without error 1266s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 1266s ok 165 - extension ltree installs without error 1266s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 1266s ok 167 - extension ltree removes without error 1266s ok 168 - psql -qc 'CREATE EXTENSION ltree' 1266s ok 169 - ltree_plpython3u dependency ltree installs without error 1266s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 1266s ok 171 - ltree_plpython3u dependency plpython3u installs without error 1266s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 1266s ok 173 - extension ltree_plpython3u installs without error 1266s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 1266s ok 175 - extension ltree_plpython3u removes without error 1266s ok 176 - psql -qc 'DROP EXTENSION ltree' 1266s ok 177 - ltree_plpython3u dependency extension ltree removes without error 1266s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 1266s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 1267s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 1267s ok 181 - extension moddatetime installs without error 1267s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 1267s ok 183 - extension moddatetime removes without error 1267s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 1267s ok 185 - extension old_snapshot installs without error 1267s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 1267s ok 187 - extension old_snapshot removes without error 1267s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 1267s ok 189 - extension pageinspect installs without error 1267s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 1267s ok 191 - extension pageinspect removes without error 1267s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 1267s ok 193 - extension pg_buffercache installs without error 1267s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 1267s ok 195 - extension pg_buffercache removes without error 1267s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 1267s ok 197 - extension pg_freespacemap installs without error 1267s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 1267s ok 199 - extension pg_freespacemap removes without error 1267s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 1267s ok 201 - extension pg_prewarm installs without error 1267s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 1267s ok 203 - extension pg_prewarm removes without error 1267s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 1267s ok 205 - extension pg_stat_statements installs without error 1267s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 1267s ok 207 - extension pg_stat_statements removes without error 1267s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 1267s ok 209 - extension pg_surgery installs without error 1268s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 1268s ok 211 - extension pg_surgery removes without error 1268s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 1268s ok 213 - extension pg_trgm installs without error 1268s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 1268s ok 215 - extension pg_trgm removes without error 1268s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 1268s ok 217 - extension pg_visibility installs without error 1268s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 1268s ok 219 - extension pg_visibility removes without error 1268s ok 220 - psql -qc 'CREATE EXTENSION "pg_walinspect"' 1268s ok 221 - extension pg_walinspect installs without error 1268s ok 222 - psql -qc 'DROP EXTENSION "pg_walinspect"' 1268s ok 223 - extension pg_walinspect removes without error 1268s ok 224 - psql -qc 'CREATE EXTENSION "pgcrypto"' 1268s ok 225 - extension pgcrypto installs without error 1268s ok 226 - psql -qc 'DROP EXTENSION "pgcrypto"' 1268s ok 227 - extension pgcrypto removes without error 1268s ok 228 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 1268s ok 229 - extension pgrowlocks installs without error 1268s ok 230 - psql -qc 'DROP EXTENSION "pgrowlocks"' 1268s ok 231 - extension pgrowlocks removes without error 1268s ok 232 - psql -qc 'CREATE EXTENSION "pgstattuple"' 1268s ok 233 - extension pgstattuple installs without error 1268s ok 234 - psql -qc 'DROP EXTENSION "pgstattuple"' 1268s ok 235 - extension pgstattuple removes without error 1269s ok 236 - psql -qc 'CREATE EXTENSION "plperl"' 1269s ok 237 - extension plperl installs without error 1269s ok 238 - psql -qc 'DROP EXTENSION "plperl"' 1269s ok 239 - extension plperl removes without error 1269s ok 240 - psql -qc 'CREATE EXTENSION "plperlu"' 1269s ok 241 - extension plperlu installs without error 1269s ok 242 - psql -qc 'DROP EXTENSION "plperlu"' 1269s ok 243 - extension plperlu removes without error 1269s ok 244 - psql -qc 'CREATE EXTENSION "plpython3u"' 1269s ok 245 - extension plpython3u installs without error 1269s ok 246 - psql -qc 'DROP EXTENSION "plpython3u"' 1269s ok 247 - extension plpython3u removes without error 1269s ok 248 - psql -qc 'CREATE EXTENSION "pltcl"' 1269s ok 249 - extension pltcl installs without error 1269s ok 250 - psql -qc 'DROP EXTENSION "pltcl"' 1269s ok 251 - extension pltcl removes without error 1269s ok 252 - psql -qc 'CREATE EXTENSION "pltclu"' 1269s ok 253 - extension pltclu installs without error 1269s ok 254 - psql -qc 'DROP EXTENSION "pltclu"' 1269s ok 255 - extension pltclu removes without error 1269s ok 256 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 1269s ok 257 - extension postgres_fdw installs without error 1269s ok 258 - psql -qc 'DROP EXTENSION "postgres_fdw"' 1269s ok 259 - extension postgres_fdw removes without error 1269s ok 260 - psql -qc 'CREATE EXTENSION "refint"' 1269s ok 261 - extension refint installs without error 1269s ok 262 - psql -qc 'DROP EXTENSION "refint"' 1269s ok 263 - extension refint removes without error 1269s ok 264 - psql -qc 'CREATE EXTENSION "seg"' 1269s ok 265 - extension seg installs without error 1270s ok 266 - psql -qc 'DROP EXTENSION "seg"' 1270s ok 267 - extension seg removes without error 1270s ok 268 - psql -qc 'CREATE EXTENSION "sslinfo"' 1270s ok 269 - extension sslinfo installs without error 1270s ok 270 - psql -qc 'DROP EXTENSION "sslinfo"' 1270s ok 271 - extension sslinfo removes without error 1270s ok 272 - psql -qc 'CREATE EXTENSION "tablefunc"' 1270s ok 273 - extension tablefunc installs without error 1270s ok 274 - psql -qc 'DROP EXTENSION "tablefunc"' 1270s ok 275 - extension tablefunc removes without error 1270s ok 276 - psql -qc 'CREATE EXTENSION "tcn"' 1270s ok 277 - extension tcn installs without error 1270s ok 278 - psql -qc 'DROP EXTENSION "tcn"' 1270s ok 279 - extension tcn removes without error 1270s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 1270s ok 281 - extension tsm_system_rows installs without error 1270s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 1270s ok 283 - extension tsm_system_rows removes without error 1270s ok 284 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 1270s ok 285 - extension tsm_system_time installs without error 1270s ok 286 - psql -qc 'DROP EXTENSION "tsm_system_time"' 1270s ok 287 - extension tsm_system_time removes without error 1270s ok 288 - psql -qc 'CREATE EXTENSION "unaccent"' 1270s ok 289 - extension unaccent installs without error 1270s ok 290 - psql -qc 'DROP EXTENSION "unaccent"' 1270s ok 291 - extension unaccent removes without error 1270s ok 292 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 1270s ok 293 - extension uuid-ossp installs without error 1270s ok 294 - psql -qc 'DROP EXTENSION "uuid-ossp"' 1270s ok 295 - extension uuid-ossp removes without error 1271s ok 296 - psql -qc 'CREATE EXTENSION "xml2"' 1271s ok 297 - extension xml2 installs without error 1271s ok 298 - psql -qc 'DROP EXTENSION "xml2"' 1271s ok 299 - extension xml2 removes without error 1273s ok 300 - pg_dropcluster 16 main 1273s # Cleanup 1273s ok 301 - Cleanup: No clusters left behind 1273s ok 302 - No postgres processes left behind 1273s ok 303 - No files in /etc/postgresql left behind 1273s ok 304 - No files in /var/lib/postgresql left behind 1273s ok 305 - No files in /var/run/postgresql left behind 1273s ok 306 - No files in /var/log/postgresql left behind 1273s ok 307 - PostgreSQL TCP ports are closed 1273s ok 308 - Next free port is 5432 1273s 1..308 1273s ### End test 170_extensions.t ### 1273s 1273s ### PostgreSQL test 180_ecpg.t ### 1273s 1..14 1273s ok 1 - ecpg test.pgc 1273s ok 2 - ecpg processing 1274s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 1274s ok 4 - compiling ecpg output 1281s ok 5 - pg_virtualenv /tmp/tmp.YdlbSds2ch/test 1281s ok 6 - test program runs and gives correct output 1281s # Cleanup 1281s ok 7 - Cleanup: No clusters left behind 1281s ok 8 - No postgres processes left behind 1281s ok 9 - No files in /etc/postgresql left behind 1281s ok 10 - No files in /var/lib/postgresql left behind 1281s ok 11 - No files in /var/run/postgresql left behind 1281s ok 12 - No files in /var/log/postgresql left behind 1281s ok 13 - PostgreSQL TCP ports are closed 1281s ok 14 - Next free port is 5432 1281s ### End test 180_ecpg.t ### 1281s 1281s ### PostgreSQL test 190_pg_buildext.t ### 1282s ok 1 - make clean 1282s ok 2 - make tar 1282s ok 3 - cd foo-123 && echo y | EDITOR=true dh_make_pgxs 1282s # testing 'dh --with pgxs' 1287s ok 4 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 1287s ok 5 - postgresql-16-foo_123-1_amd64.deb was built 1295s ok 6 - cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1295s ok 7 - correct output of cd foo-123 && PG_SUPPORTED_VERSIONS=16 dh_pgxs_test 1296s ok 8 - dpkg -i postgresql-16-foo_123-1_amd64.deb 1304s ok 9 - cd foo-123 && pg_buildext installcheck 1304s ok 10 - correct output of cd foo-123 && pg_buildext installcheck 1312s ok 11 - cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1312s ok 12 - correct output of cd foo-123 && echo 'SELECT 3*41, version()' | pg_buildext psql 1320s ok 13 - cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1320s ok 14 - correct output of cd foo-123 && echo 'echo --$PGVERSION--' | pg_buildext virtualenv 1320s ok 15 - cd foo-123 && pg_buildext run echo --%v-- 1320s ok 16 - correct output of cd foo-123 && pg_buildext run echo --%v-- 1320s ok 17 - dpkg -r postgresql-16-foo 1320s # testing 'dh --with pgxs_loop' 1320s ok 18 - sed -i -e s/pgxs/pgxs_loop/ foo-123/debian/rules 1325s ok 19 - cd foo-123 && DEB_BUILD_OPTIONS=nocheck dpkg-buildpackage -us -uc 1325s ok 20 - postgresql-16-foo_123-1_amd64.deb was built 1325s ok 21 - make clean 1325s # testing pg_buildext updatecontrol 1325s ok 22 - PG_SUPPORTED_VERSIONS="0.9 1.0 1.1 2 3" pg_buildext updatecontrol 1325s ok 23 - PGVERSION and PGVERSIONS were correctly replaced 1325s 1..23 1325s ### End test 190_pg_buildext.t ### 1325s 1325s ### PostgreSQL test 200_maintscripts.t ### 1325s 1..15 1325s # We are running systemd 1329s ok 1 - pg_createcluster 16 main --start 1329s ok 2 - postmaster PID is 22128 1331s ok 3 - apt-get update -q 1331s # postgresql-common: 1331s # Installed: 260 1331s # Candidate: 260 1331s # Version table: 1331s # 261 500 1331s # 500 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages 1331s # 500 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages 1331s # *** 260 990 1331s # 990 http://ftpmaster.internal/ubuntu oracular/main amd64 Packages 1331s # 990 http://ftpmaster.internal/ubuntu oracular/main i386 Packages 1331s # 100 /var/lib/dpkg/status 1336s ok 4 - apt-get install -y --reinstall -o DPkg::Options::=--force-confnew postgresql-common 1336s # postgresql-common: 1336s # Installed: 260 1336s # Candidate: 260 1336s # Version table: 1336s # 261 500 1336s # 500 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages 1336s # 500 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages 1336s # *** 260 990 1336s # 990 http://ftpmaster.internal/ubuntu oracular/main amd64 Packages 1336s # 990 http://ftpmaster.internal/ubuntu oracular/main i386 Packages 1336s # 100 /var/lib/dpkg/status 1336s ok 5 - postmaster PID is 22128 1336s ok 6 - postmaster was not restarted 1338s ok 7 - pg_dropcluster 16 main --stop 1338s # Cleanup 1338s ok 8 - Cleanup: No clusters left behind 1338s ok 9 - No postgres processes left behind 1338s ok 10 - No files in /etc/postgresql left behind 1338s ok 11 - No files in /var/lib/postgresql left behind 1338s ok 12 - No files in /var/run/postgresql left behind 1338s ok 13 - No files in /var/log/postgresql left behind 1338s ok 14 - PostgreSQL TCP ports are closed 1338s ok 15 - Next free port is 5432 1338s ### End test 200_maintscripts.t ### 1338s 1339s autopkgtest [18:41:45]: test run-testsuite: -----------------------] 1340s autopkgtest [18:41:46]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 1340s run-testsuite PASS 1340s autopkgtest [18:41:46]: @@@@@@@@@@@@@@@@@@@@ summary 1340s default-psql PASS 1340s run-testsuite PASS 1351s nova [W] Skipping flock for amd64 1351s Creating nova instance adt-oracular-amd64-postgresql-common-20240628-181925-juju-7f2275-prod-proposed-migration-environment-2-ef062626-8be9-4e3e-aed4-f0525708472d from image adt/ubuntu-oracular-amd64-server-20240628.img (UUID 9d02b460-22c0-49a4-a380-3bb68f865fe5)... 1351s nova [W] Skipping flock for amd64 1351s Creating nova instance adt-oracular-amd64-postgresql-common-20240628-181925-juju-7f2275-prod-proposed-migration-environment-2-ef062626-8be9-4e3e-aed4-f0525708472d from image adt/ubuntu-oracular-amd64-server-20240628.img (UUID 9d02b460-22c0-49a4-a380-3bb68f865fe5)...