0s autopkgtest [13:15:30]: starting date and time: 2025-02-26 13:15:30+0000 0s autopkgtest [13:15:30]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:15:30]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.weix5s_h/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:tzdata --apt-upgrade postgresql-14 --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=tzdata/2025a-0ubuntu0.22.04 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-arm64-34.secgroup --name adt-jammy-arm64-postgresql-14-20250226-131530-juju-7f2275-prod-proposed-migration-environment-20-49281607-fbae-453f-bed5-c75d494c9b43 --image adt/ubuntu-jammy-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 90s autopkgtest [13:17:00]: testbed dpkg architecture: arm64 90s autopkgtest [13:17:00]: testbed apt version: 2.4.13 91s autopkgtest [13:17:01]: @@@@@@@@@@@@@@@@@@@@ test bed setup 91s autopkgtest [13:17:01]: testbed release detected to be: None 92s autopkgtest [13:17:02]: updating testbed package index (apt update) 92s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 92s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 92s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 92s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 93s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 93s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 93s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 93s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 93s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 Packages [319 kB] 93s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 c-n-f Metadata [1748 B] 93s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted arm64 Packages [456 kB] 93s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted arm64 c-n-f Metadata [412 B] 93s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe arm64 Packages [115 kB] 93s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe arm64 c-n-f Metadata [1308 B] 93s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse arm64 Packages [9504 B] 93s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse arm64 c-n-f Metadata [208 B] 95s Fetched 1339 kB in 1s (970 kB/s) 96s Reading package lists... 97s Reading package lists... 97s Building dependency tree... 97s Reading state information... 98s Calculating upgrade... 98s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 99s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 99s autopkgtest [13:17:09]: upgrading testbed (apt dist-upgrade and autopurge) 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 100s Starting 2 pkgProblemResolver with broken count: 0 100s Done 100s Entering ResolveByKeep 101s 101s The following packages will be upgraded: 101s tzdata 101s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 101s Need to get 347 kB of archives. 101s After this operation, 4096 B of additional disk space will be used. 101s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 tzdata all 2025a-0ubuntu0.22.04 [347 kB] 102s Preconfiguring packages ... 102s Fetched 347 kB in 0s (745 kB/s) 102s (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 ... 70618 files and directories currently installed.) 102s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 102s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 102s Setting up tzdata (2025a-0ubuntu0.22.04) ... 102s 102s Current default time zone: 'Etc/UTC' 102s Local time is now: Wed Feb 26 13:17:12 UTC 2025. 102s Universal Time is now: Wed Feb 26 13:17:12 UTC 2025. 102s Run 'dpkg-reconfigure tzdata' if you wish to change it. 102s 103s Reading package lists... 103s Building dependency tree... 103s Reading state information... 104s Starting pkgProblemResolver with broken count: 0 104s Starting 2 pkgProblemResolver with broken count: 0 104s Done 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s autopkgtest [13:17:17]: testbed running kernel: Linux 5.15.0-133-generic #144-Ubuntu SMP Sat Feb 8 14:13:21 UTC 2025 107s autopkgtest [13:17:17]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-14 120s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (dsc) [3864 B] 120s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (tar) [29.3 MB] 120s Get:3 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (diff) [30.0 kB] 120s gpgv: Signature made Wed Nov 27 17:13:16 2024 UTC 120s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 120s gpgv: Can't check signature: No public key 120s dpkg-source: warning: cannot verify signature ./postgresql-14_14.15-0ubuntu0.22.04.1.dsc 121s autopkgtest [13:17:31]: testing package postgresql-14 version 14.15-0ubuntu0.22.04.1 123s autopkgtest [13:17:33]: build not needed 130s autopkgtest [13:17:40]: test run-testsuite: preparing testbed 130s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s Starting pkgProblemResolver with broken count: 0 131s Starting 2 pkgProblemResolver with broken count: 0 131s Done 132s The following NEW packages will be installed: 132s build-essential clang-14 cpp cpp-11 dictionaries-common emacsen-common g++ 132s g++-11 gcc gcc-11 gcc-11-base hunspell-en-us icu-devtools libasan6 132s libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-14-dev 132s libclang-cpp14 libclang1-14 libcrypt-dev libecpg-compat3 libecpg-dev 132s libecpg6 libffi-dev libgc1 libgcc-11-dev libgomp1 libhwasan0 libicu-dev 132s libisl23 libitm1 libjson-perl libllvm14 liblsan0 libmpc3 libncurses-dev 132s libnsl-dev libobjc-11-dev libobjc4 libpfm4 libpgtypes3 libpq-dev libpq5 132s libpython3.10 libssl-dev libstdc++-11-dev libtinfo-dev libtirpc-dev libtsan0 132s libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-14 132s llvm-14-dev llvm-14-linker-tools llvm-14-runtime llvm-14-tools net-tools 132s postgresql-14 postgresql-client-14 postgresql-client-common 132s postgresql-common postgresql-doc-14 postgresql-plperl-14 132s postgresql-plpython3-14 postgresql-pltcl-14 postgresql-server-dev-14 132s python3-pygments rpcsvc-proto ssl-cert 132s 0 upgraded, 75 newly installed, 0 to remove and 0 not upgraded. 132s Need to get 197 MB of archives. 132s After this operation, 918 MB of additional disk space will be used. 132s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libc-dev-bin arm64 2.35-0ubuntu3.9 [19.6 kB] 132s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 linux-libc-dev arm64 5.15.0-133.144 [1274 kB] 132s Get:3 http://ftpmaster.internal/ubuntu jammy/main arm64 libcrypt-dev arm64 1:4.4.27-1 [119 kB] 132s Get:4 http://ftpmaster.internal/ubuntu jammy/main arm64 rpcsvc-proto arm64 1.4.2-0ubuntu6 [65.4 kB] 132s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtirpc-dev arm64 1.3.2-2ubuntu0.1 [199 kB] 132s Get:6 http://ftpmaster.internal/ubuntu jammy/main arm64 libnsl-dev arm64 1.3.0-2build2 [72.1 kB] 132s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libc6-dev arm64 2.35-0ubuntu3.9 [1544 kB] 133s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 gcc-11-base arm64 11.4.0-1ubuntu1~22.04 [20.3 kB] 133s Get:9 http://ftpmaster.internal/ubuntu jammy/main arm64 libisl23 arm64 0.24-2build1 [689 kB] 133s Get:10 http://ftpmaster.internal/ubuntu jammy/main arm64 libmpc3 arm64 1.2.1-2build1 [48.1 kB] 133s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 cpp-11 arm64 11.4.0-1ubuntu1~22.04 [9762 kB] 133s Get:12 http://ftpmaster.internal/ubuntu jammy/main arm64 cpp arm64 4:11.2.0-1ubuntu1 [27.7 kB] 133s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libcc1-0 arm64 12.3.0-1ubuntu1~22.04 [45.0 kB] 133s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libgomp1 arm64 12.3.0-1ubuntu1~22.04 [124 kB] 133s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libitm1 arm64 12.3.0-1ubuntu1~22.04 [28.4 kB] 133s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libatomic1 arm64 12.3.0-1ubuntu1~22.04 [10.8 kB] 133s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libasan6 arm64 11.4.0-1ubuntu1~22.04 [2234 kB] 133s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 liblsan0 arm64 12.3.0-1ubuntu1~22.04 [1035 kB] 133s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtsan0 arm64 11.4.0-1ubuntu1~22.04 [2235 kB] 133s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libubsan1 arm64 12.3.0-1ubuntu1~22.04 [965 kB] 133s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libhwasan0 arm64 12.3.0-1ubuntu1~22.04 [1117 kB] 134s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libgcc-11-dev arm64 11.4.0-1ubuntu1~22.04 [1146 kB] 134s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 gcc-11 arm64 11.4.0-1ubuntu1~22.04 [19.4 MB] 134s Get:24 http://ftpmaster.internal/ubuntu jammy/main arm64 gcc arm64 4:11.2.0-1ubuntu1 [5128 B] 134s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libstdc++-11-dev arm64 11.4.0-1ubuntu1~22.04 [2088 kB] 134s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 g++-11 arm64 11.4.0-1ubuntu1~22.04 [11.1 MB] 134s Get:27 http://ftpmaster.internal/ubuntu jammy/main arm64 g++ arm64 4:11.2.0-1ubuntu1 [1394 B] 134s Get:28 http://ftpmaster.internal/ubuntu jammy/main arm64 build-essential arm64 12.9ubuntu3 [4740 B] 134s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libllvm14 arm64 1:14.0.0-1ubuntu1.1 [22.6 MB] 135s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang-cpp14 arm64 1:14.0.0-1ubuntu1.1 [11.5 MB] 136s Get:31 http://ftpmaster.internal/ubuntu jammy/main arm64 libgc1 arm64 1:8.0.6-1.1build1 [94.2 kB] 136s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libobjc4 arm64 12.3.0-1ubuntu1~22.04 [46.8 kB] 136s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libobjc-11-dev arm64 11.4.0-1ubuntu1~22.04 [192 kB] 136s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang-common-14-dev arm64 1:14.0.0-1ubuntu1.1 [4488 kB] 136s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-linker-tools arm64 1:14.0.0-1ubuntu1.1 [1237 kB] 136s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang1-14 arm64 1:14.0.0-1ubuntu1.1 [6470 kB] 136s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 clang-14 arm64 1:14.0.0-1ubuntu1.1 [77.5 kB] 136s Get:38 http://ftpmaster.internal/ubuntu jammy/main arm64 emacsen-common all 3.0.4 [14.9 kB] 136s Get:39 http://ftpmaster.internal/ubuntu jammy/main arm64 dictionaries-common all 1.28.14 [185 kB] 136s Get:40 http://ftpmaster.internal/ubuntu jammy/main arm64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 136s Get:41 http://ftpmaster.internal/ubuntu jammy/main arm64 icu-devtools arm64 70.1-2 [193 kB] 136s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpgtypes3 arm64 14.15-0ubuntu0.22.04.1 [47.2 kB] 136s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpq5 arm64 14.15-0ubuntu0.22.04.1 [145 kB] 136s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg6 arm64 14.15-0ubuntu0.22.04.1 [43.2 kB] 136s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg-compat3 arm64 14.15-0ubuntu0.22.04.1 [13.1 kB] 136s Get:46 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libssl-dev arm64 3.0.2-0ubuntu1.19 [2299 kB] 136s Get:47 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpq-dev arm64 14.15-0ubuntu0.22.04.1 [148 kB] 136s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg-dev arm64 14.15-0ubuntu0.22.04.1 [258 kB] 136s Get:49 http://ftpmaster.internal/ubuntu jammy/main arm64 libicu-dev arm64 70.1-2 [11.6 MB] 137s Get:50 http://ftpmaster.internal/ubuntu jammy/main arm64 libjson-perl all 4.04000-1 [81.8 kB] 137s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libncurses-dev arm64 6.3-2ubuntu0.1 [381 kB] 137s Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpython3.10 arm64 3.10.12-1~22.04.9 [1888 kB] 137s Get:53 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtinfo-dev arm64 6.3-2ubuntu0.1 [780 B] 137s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libxml2-dev arm64 2.9.13+dfsg-1ubuntu0.6 [804 kB] 137s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.22.04.1 [160 kB] 137s Get:56 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-runtime arm64 1:14.0.0-1ubuntu1.1 [456 kB] 137s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpfm4 arm64 4.11.1+git32-gd0b85fb-1ubuntu0.1 [50.4 kB] 137s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14 arm64 1:14.0.0-1ubuntu1.1 [11.5 MB] 138s Get:59 http://ftpmaster.internal/ubuntu jammy/main arm64 libffi-dev arm64 3.4.2-4 [61.0 kB] 138s Get:60 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 138s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-tools arm64 1:14.0.0-1ubuntu1.1 [395 kB] 138s Get:62 http://ftpmaster.internal/ubuntu jammy/universe arm64 libz3-4 arm64 4.8.12-1 [5352 kB] 138s Get:63 http://ftpmaster.internal/ubuntu jammy/universe arm64 libz3-dev arm64 4.8.12-1 [72.2 kB] 138s Get:64 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-dev arm64 1:14.0.0-1ubuntu1.1 [36.3 MB] 139s Get:65 http://ftpmaster.internal/ubuntu jammy/main arm64 net-tools arm64 1.60+git20181103.0eebece-1ubuntu5 [207 kB] 139s Get:66 http://ftpmaster.internal/ubuntu jammy/main arm64 postgresql-client-common all 238 [29.6 kB] 139s Get:67 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-client-14 arm64 14.15-0ubuntu0.22.04.1 [1218 kB] 139s Get:68 http://ftpmaster.internal/ubuntu jammy/main arm64 ssl-cert all 1.1.2 [17.4 kB] 139s Get:69 http://ftpmaster.internal/ubuntu jammy/main arm64 postgresql-common all 238 [169 kB] 139s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-14 arm64 14.15-0ubuntu0.22.04.1 [15.9 MB] 140s Get:71 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 140s Get:72 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-plperl-14 arm64 14.15-0ubuntu0.22.04.1 [73.4 kB] 140s Get:73 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-plpython3-14 arm64 14.15-0ubuntu0.22.04.1 [81.9 kB] 140s Get:74 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-pltcl-14 arm64 14.15-0ubuntu0.22.04.1 [34.8 kB] 140s Get:75 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 postgresql-server-dev-14 arm64 14.15-0ubuntu0.22.04.1 [1178 kB] 140s Preconfiguring packages ... 140s Fetched 197 MB in 8s (24.5 MB/s) 140s Selecting previously unselected package libc-dev-bin. 141s (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 ... 70619 files and directories currently installed.) 141s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_arm64.deb ... 141s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 141s Selecting previously unselected package linux-libc-dev:arm64. 141s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_arm64.deb ... 141s Unpacking linux-libc-dev:arm64 (5.15.0-133.144) ... 141s Selecting previously unselected package libcrypt-dev:arm64. 141s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_arm64.deb ... 141s Unpacking libcrypt-dev:arm64 (1:4.4.27-1) ... 141s Selecting previously unselected package rpcsvc-proto. 141s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_arm64.deb ... 141s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 141s Selecting previously unselected package libtirpc-dev:arm64. 141s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_arm64.deb ... 141s Unpacking libtirpc-dev:arm64 (1.3.2-2ubuntu0.1) ... 141s Selecting previously unselected package libnsl-dev:arm64. 141s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_arm64.deb ... 141s Unpacking libnsl-dev:arm64 (1.3.0-2build2) ... 141s Selecting previously unselected package libc6-dev:arm64. 141s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_arm64.deb ... 141s Unpacking libc6-dev:arm64 (2.35-0ubuntu3.9) ... 141s Selecting previously unselected package gcc-11-base:arm64. 141s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking gcc-11-base:arm64 (11.4.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libisl23:arm64. 141s Preparing to unpack .../08-libisl23_0.24-2build1_arm64.deb ... 141s Unpacking libisl23:arm64 (0.24-2build1) ... 141s Selecting previously unselected package libmpc3:arm64. 141s Preparing to unpack .../09-libmpc3_1.2.1-2build1_arm64.deb ... 141s Unpacking libmpc3:arm64 (1.2.1-2build1) ... 141s Selecting previously unselected package cpp-11. 141s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package cpp. 141s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_arm64.deb ... 141s Unpacking cpp (4:11.2.0-1ubuntu1) ... 141s Selecting previously unselected package libcc1-0:arm64. 141s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libcc1-0:arm64 (12.3.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libgomp1:arm64. 141s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libgomp1:arm64 (12.3.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libitm1:arm64. 141s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libitm1:arm64 (12.3.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libatomic1:arm64. 141s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libatomic1:arm64 (12.3.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libasan6:arm64. 141s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libasan6:arm64 (11.4.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package liblsan0:arm64. 141s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking liblsan0:arm64 (12.3.0-1ubuntu1~22.04) ... 141s Selecting previously unselected package libtsan0:arm64. 141s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_arm64.deb ... 141s Unpacking libtsan0:arm64 (11.4.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package libubsan1:arm64. 142s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking libubsan1:arm64 (12.3.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package libhwasan0:arm64. 142s Preparing to unpack .../20-libhwasan0_12.3.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking libhwasan0:arm64 (12.3.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package libgcc-11-dev:arm64. 142s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking libgcc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package gcc-11. 142s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package gcc. 142s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_arm64.deb ... 142s Unpacking gcc (4:11.2.0-1ubuntu1) ... 142s Selecting previously unselected package libstdc++-11-dev:arm64. 142s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking libstdc++-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package g++-11. 142s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 142s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 142s Selecting previously unselected package g++. 142s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_arm64.deb ... 142s Unpacking g++ (4:11.2.0-1ubuntu1) ... 142s Selecting previously unselected package build-essential. 142s Preparing to unpack .../27-build-essential_12.9ubuntu3_arm64.deb ... 142s Unpacking build-essential (12.9ubuntu3) ... 142s Selecting previously unselected package libllvm14:arm64. 142s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 142s Unpacking libllvm14:arm64 (1:14.0.0-1ubuntu1.1) ... 143s Selecting previously unselected package libclang-cpp14. 143s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 143s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 143s Selecting previously unselected package libgc1:arm64. 143s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_arm64.deb ... 143s Unpacking libgc1:arm64 (1:8.0.6-1.1build1) ... 143s Selecting previously unselected package libobjc4:arm64. 143s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_arm64.deb ... 143s Unpacking libobjc4:arm64 (12.3.0-1ubuntu1~22.04) ... 143s Selecting previously unselected package libobjc-11-dev:arm64. 143s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 143s Unpacking libobjc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 143s Selecting previously unselected package libclang-common-14-dev. 143s Preparing to unpack .../33-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 143s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 144s Selecting previously unselected package llvm-14-linker-tools. 144s Preparing to unpack .../34-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 144s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 144s Selecting previously unselected package libclang1-14. 144s Preparing to unpack .../35-libclang1-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 144s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 144s Selecting previously unselected package clang-14. 144s Preparing to unpack .../36-clang-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 144s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 144s Selecting previously unselected package emacsen-common. 144s Preparing to unpack .../37-emacsen-common_3.0.4_all.deb ... 144s Unpacking emacsen-common (3.0.4) ... 144s Selecting previously unselected package dictionaries-common. 144s Preparing to unpack .../38-dictionaries-common_1.28.14_all.deb ... 144s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 144s Unpacking dictionaries-common (1.28.14) ... 144s Selecting previously unselected package hunspell-en-us. 144s Preparing to unpack .../39-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 144s Unpacking hunspell-en-us (1:2020.12.07-2) ... 144s Selecting previously unselected package icu-devtools. 144s Preparing to unpack .../40-icu-devtools_70.1-2_arm64.deb ... 144s Unpacking icu-devtools (70.1-2) ... 144s Selecting previously unselected package libpgtypes3:arm64. 144s Preparing to unpack .../41-libpgtypes3_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libpgtypes3:arm64 (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libpq5:arm64. 144s Preparing to unpack .../42-libpq5_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libpq5:arm64 (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libecpg6:arm64. 144s Preparing to unpack .../43-libecpg6_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libecpg6:arm64 (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libecpg-compat3:arm64. 144s Preparing to unpack .../44-libecpg-compat3_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libecpg-compat3:arm64 (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libssl-dev:arm64. 144s Preparing to unpack .../45-libssl-dev_3.0.2-0ubuntu1.19_arm64.deb ... 144s Unpacking libssl-dev:arm64 (3.0.2-0ubuntu1.19) ... 144s Selecting previously unselected package libpq-dev. 144s Preparing to unpack .../46-libpq-dev_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libecpg-dev. 144s Preparing to unpack .../47-libecpg-dev_14.15-0ubuntu0.22.04.1_arm64.deb ... 144s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 144s Selecting previously unselected package libicu-dev:arm64. 144s Preparing to unpack .../48-libicu-dev_70.1-2_arm64.deb ... 144s Unpacking libicu-dev:arm64 (70.1-2) ... 145s Selecting previously unselected package libjson-perl. 145s Preparing to unpack .../49-libjson-perl_4.04000-1_all.deb ... 145s Unpacking libjson-perl (4.04000-1) ... 145s Selecting previously unselected package libncurses-dev:arm64. 145s Preparing to unpack .../50-libncurses-dev_6.3-2ubuntu0.1_arm64.deb ... 145s Unpacking libncurses-dev:arm64 (6.3-2ubuntu0.1) ... 145s Selecting previously unselected package libpython3.10:arm64. 145s Preparing to unpack .../51-libpython3.10_3.10.12-1~22.04.9_arm64.deb ... 145s Unpacking libpython3.10:arm64 (3.10.12-1~22.04.9) ... 145s Selecting previously unselected package libtinfo-dev:arm64. 145s Preparing to unpack .../52-libtinfo-dev_6.3-2ubuntu0.1_arm64.deb ... 145s Unpacking libtinfo-dev:arm64 (6.3-2ubuntu0.1) ... 145s Selecting previously unselected package libxml2-dev:arm64. 145s Preparing to unpack .../53-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_arm64.deb ... 145s Unpacking libxml2-dev:arm64 (2.9.13+dfsg-1ubuntu0.6) ... 145s Selecting previously unselected package libxslt1.1:arm64. 145s Preparing to unpack .../54-libxslt1.1_1.1.34-4ubuntu0.22.04.1_arm64.deb ... 145s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.22.04.1) ... 145s Selecting previously unselected package llvm-14-runtime. 145s Preparing to unpack .../55-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 145s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 145s Selecting previously unselected package libpfm4:arm64. 145s Preparing to unpack .../56-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_arm64.deb ... 145s Unpacking libpfm4:arm64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 145s Selecting previously unselected package llvm-14. 145s Preparing to unpack .../57-llvm-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 145s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 145s Selecting previously unselected package libffi-dev:arm64. 145s Preparing to unpack .../58-libffi-dev_3.4.2-4_arm64.deb ... 145s Unpacking libffi-dev:arm64 (3.4.2-4) ... 145s Selecting previously unselected package python3-pygments. 145s Preparing to unpack .../59-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 145s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 145s Selecting previously unselected package llvm-14-tools. 145s Preparing to unpack .../60-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 145s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 145s Selecting previously unselected package libz3-4:arm64. 145s Preparing to unpack .../61-libz3-4_4.8.12-1_arm64.deb ... 145s Unpacking libz3-4:arm64 (4.8.12-1) ... 146s Selecting previously unselected package libz3-dev:arm64. 146s Preparing to unpack .../62-libz3-dev_4.8.12-1_arm64.deb ... 146s Unpacking libz3-dev:arm64 (4.8.12-1) ... 146s Selecting previously unselected package llvm-14-dev. 146s Preparing to unpack .../63-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 146s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 147s Selecting previously unselected package net-tools. 147s Preparing to unpack .../64-net-tools_1.60+git20181103.0eebece-1ubuntu5_arm64.deb ... 147s Unpacking net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 147s Selecting previously unselected package postgresql-client-common. 147s Preparing to unpack .../65-postgresql-client-common_238_all.deb ... 147s Unpacking postgresql-client-common (238) ... 147s Selecting previously unselected package postgresql-client-14. 147s Preparing to unpack .../66-postgresql-client-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 147s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 147s Selecting previously unselected package ssl-cert. 147s Preparing to unpack .../67-ssl-cert_1.1.2_all.deb ... 147s Unpacking ssl-cert (1.1.2) ... 147s Selecting previously unselected package postgresql-common. 147s Preparing to unpack .../68-postgresql-common_238_all.deb ... 147s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 147s Unpacking postgresql-common (238) ... 147s Selecting previously unselected package postgresql-14. 147s Preparing to unpack .../69-postgresql-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 147s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 147s Selecting previously unselected package postgresql-doc-14. 147s Preparing to unpack .../70-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 147s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 148s Selecting previously unselected package postgresql-plperl-14. 148s Preparing to unpack .../71-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 148s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 148s Selecting previously unselected package postgresql-plpython3-14. 148s Preparing to unpack .../72-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 148s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 148s Selecting previously unselected package postgresql-pltcl-14. 148s Preparing to unpack .../73-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 148s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 148s Selecting previously unselected package postgresql-server-dev-14. 148s Preparing to unpack .../74-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 148s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 148s Setting up postgresql-client-common (238) ... 148s Setting up libpgtypes3:arm64 (14.15-0ubuntu0.22.04.1) ... 148s Setting up gcc-11-base:arm64 (11.4.0-1ubuntu1~22.04) ... 148s Setting up libpython3.10:arm64 (3.10.12-1~22.04.9) ... 148s Setting up net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 148s Setting up libpq5:arm64 (14.15-0ubuntu0.22.04.1) ... 148s Setting up linux-libc-dev:arm64 (5.15.0-133.144) ... 148s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 148s update-alternatives: using /usr/share/postgresql/14/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 148s Setting up libgomp1:arm64 (12.3.0-1ubuntu1~22.04) ... 148s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 149s update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 149s Setting up libffi-dev:arm64 (3.4.2-4) ... 149s Setting up libasan6:arm64 (11.4.0-1ubuntu1~22.04) ... 149s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 150s Setting up libz3-4:arm64 (4.8.12-1) ... 150s Setting up libtirpc-dev:arm64 (1.3.2-2ubuntu0.1) ... 150s Setting up libpfm4:arm64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 150s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 150s Setting up emacsen-common (3.0.4) ... 150s Setting up ssl-cert (1.1.2) ... 150s Setting up libssl-dev:arm64 (3.0.2-0ubuntu1.19) ... 150s Setting up libmpc3:arm64 (1.2.1-2build1) ... 150s Setting up libatomic1:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up icu-devtools (70.1-2) ... 150s Setting up libgc1:arm64 (1:8.0.6-1.1build1) ... 150s Setting up libubsan1:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up libllvm14:arm64 (1:14.0.0-1ubuntu1.1) ... 150s Setting up libnsl-dev:arm64 (1.3.0-2build2) ... 150s Setting up libhwasan0:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up libcrypt-dev:arm64 (1:4.4.27-1) ... 150s Setting up libjson-perl (4.04000-1) ... 150s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.22.04.1) ... 150s Setting up libecpg6:arm64 (14.15-0ubuntu0.22.04.1) ... 150s Setting up libisl23:arm64 (0.24-2build1) ... 150s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 150s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 150s Setting up libcc1-0:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up liblsan0:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up libitm1:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up libtsan0:arm64 (11.4.0-1ubuntu1~22.04) ... 150s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 150s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 150s Setting up libz3-dev:arm64 (4.8.12-1) ... 150s Setting up libecpg-compat3:arm64 (14.15-0ubuntu0.22.04.1) ... 150s Setting up dictionaries-common (1.28.14) ... 150s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 150s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 150s Setting up libobjc4:arm64 (12.3.0-1ubuntu1~22.04) ... 150s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 150s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 150s Setting up postgresql-common (238) ... 150s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 150s Adding user postgres to group ssl-cert 151s 151s Creating config file /etc/postgresql-common/createcluster.conf with new version 151s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 151s en_us 151s Removing obsolete dictionary files: 151s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 152s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 152s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 152s Setting up libgcc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 152s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 152s Setting up cpp (4:11.2.0-1ubuntu1) ... 152s Setting up hunspell-en-us (1:2020.12.07-2) ... 152s Setting up libc6-dev:arm64 (2.35-0ubuntu3.9) ... 152s Setting up libicu-dev:arm64 (70.1-2) ... 152s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 152s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 152s Creating new PostgreSQL cluster 14/main ... 152s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 152s The files belonging to this database system will be owned by user "postgres". 152s This user must also own the server process. 152s 152s The database cluster will be initialized with locale "C.UTF-8". 152s The default database encoding has accordingly been set to "UTF8". 152s The default text search configuration will be set to "english". 152s 152s Data page checksums are disabled. 152s 152s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 152s creating subdirectories ... ok 152s selecting dynamic shared memory implementation ... posix 152s selecting default max_connections ... 100 152s selecting default shared_buffers ... 128MB 152s selecting default time zone ... Etc/UTC 152s creating configuration files ... ok 152s running bootstrap script ... ok 152s performing post-bootstrap initialization ... ok 152s syncing data to disk ... ok 153s update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 155s Setting up libncurses-dev:arm64 (6.3-2ubuntu0.1) ... 155s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 155s Setting up libobjc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 155s Setting up gcc (4:11.2.0-1ubuntu1) ... 155s Setting up libxml2-dev:arm64 (2.9.13+dfsg-1ubuntu0.6) ... 155s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 155s Setting up libstdc++-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 155s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 155s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 155s Setting up libtinfo-dev:arm64 (6.3-2ubuntu0.1) ... 155s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 155s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 155s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 155s Setting up g++ (4:11.2.0-1ubuntu1) ... 155s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 155s Setting up build-essential (12.9ubuntu3) ... 155s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 155s Processing triggers for man-db (2.10.2-1) ... 156s Processing triggers for install-info (6.8-4build1) ... 156s Processing triggers for dictionaries-common (1.28.14) ... 159s autopkgtest [13:18:09]: test run-testsuite: [----------------------- 159s Generating locales (this might take a while)... 161s en_US.UTF-8... done 162s ru_RU.ISO-8859-5... done 163s ru_RU.UTF-8... done 163s Generation complete. 164s ====== Running all tests with umask 077 ======= 164s === Running test 001_packages.t ... === 164s 1..21 164s ok 1 - /etc/os-release exists 164s ok 2 - OS is ubuntu 164s ok 3 - OS version is 22.04 164s # PostgreSQL versions installed: 14 164s ok 4 - postgresql-14 installed 164s ok 5 # skip No python2 support 164s ok 6 - postgresql-plpython3-14 installed 164s ok 7 - postgresql-plperl-14 installed 164s ok 8 - postgresql-pltcl-14 installed 164s ok 9 - postgresql-server-dev-14 installed 164s ok 10 # skip No postgresql-contrib-14 package for version 14 164s ok 11 - libecpg-dev installed 164s ok 12 - procps installed 164s ok 13 - netcat-openbsd installed 164s ok 14 - hunspell-en-us installed 164s ok 15 - system has a default UTF-8 locale 164s ok 16 - locale ru_RU exists 164s ok 17 - locale ru_RU.UTF-8 exists 164s ok 18 - user postgres in the UNIX group ssl-cert 164s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 164s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 164s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 164s === Running test 002_existing_clusters.t ... === 164s 1..8 164s # Cleanup 164s ok 1 - Cleanup: No clusters left behind 164s ok 2 - No postgres processes left behind 164s ok 3 - No files in /etc/postgresql left behind 164s ok 4 - No files in /var/lib/postgresql left behind 164s ok 5 - No files in /var/run/postgresql left behind 164s ok 6 - No files in /var/log/postgresql left behind 164s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 164s ok 8 - PostgreSQL TCP ports are closed 164s === Running test 005_PgCommon.t ... === 164s 1..24 164s ok 1 - correctly parsed line 'local all postgres ident sameuser' 164s ok 2 - correctly parsed line 'local foo nobody trust' 164s ok 3 - correctly parsed line 'local foo nobody crypt' 164s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 164s ok 5 - correctly parsed line 'local foo,bar nobody ident' 164s ok 6 - correctly parsed line 'local all +foogrp password' 164s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 164s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 164s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 164s ok 10 - @expected_records has correct number of entries 164s ok 11 - returned read_pg_hba array has correct number of records 164s ok 12 - line 'foo all all md5' parsed as invalid 164s ok 13 - line 'local all all foo' parsed as invalid 164s ok 14 - line 'host all all foo' parsed as invalid 164s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 164s ok 16 - line 'host all all md5' parsed as invalid 164s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 164s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 164s ok 19 - read_conf_file returns empty dict for nonexisting file 164s ok 20 - read_conf_file() parsing 164s ok 21 - read_conf_file() parsing with include directives 164s ok 22 - set_conf_value 164s ok 23 - disable_conf_value 164s ok 24 - replace_conf_value 164s === Running test 006_next_free_port.t ... === 164s 1..5 164s ok 1 - next_free_port is 5432 165s ok 2 - next_free_port detects localhost ipv4 socket 166s ok 3 - next_free_port detects wildcard ipv4 socket 167s ok 4 - next_free_port detects localhost ipv6 socket 168s ok 5 - next_free_port detects wildcard ipv6 socket 168s === Running test 007_pg_conftool.t ... === 168s 1..41 168s # test without cluster 168s ok 1 - pg_conftool show all 168s ok 2 - correct output of pg_conftool show all 168s ok 3 - pg_conftool foo.conf show all 168s ok 4 - correct output of pg_conftool foo.conf show all 169s ok 5 - pg_conftool /tmp/04XxBoHznV/different.conf show all 169s ok 6 - correct output of pg_conftool /tmp/04XxBoHznV/different.conf show all 169s ok 7 - pg_conftool 9.7 main show all 169s ok 8 - correct output of pg_conftool 9.7 main show all 169s # test show 169s ok 9 - pg_conftool show all 169s ok 10 - correct output of pg_conftool show all 169s ok 11 - pg_conftool other.conf show all 169s ok 12 - correct output of pg_conftool other.conf show all 169s ok 13 - pg_conftool /tmp/04XxBoHznV/different.conf show all 169s ok 14 - correct output of pg_conftool /tmp/04XxBoHznV/different.conf show all 169s ok 15 - pg_conftool 14 main show all 169s ok 16 - correct output of pg_conftool 14 main show all 169s ok 17 - pg_conftool 14 main other.conf show all 169s ok 18 - correct output of pg_conftool 14 main other.conf show all 169s ok 19 - pg_conftool show a 169s ok 20 - correct output of pg_conftool show a 169s ok 21 - pg_conftool -s show a 169s ok 22 - correct output of pg_conftool -s show a 169s # test set 169s ok 23 - pg_conftool set c 7 169s ok 24 - correct output of pg_conftool set c 7 169s ok 25 - file contains new setting 169s ok 26 - pg_conftool set a 8 169s ok 27 - correct output of pg_conftool set a 8 169s ok 28 - file contains updated setting 169s ok 29 - pg_conftool /tmp/04XxBoHznV/different.conf set a 9 169s ok 30 - correct output of pg_conftool /tmp/04XxBoHznV/different.conf set a 9 169s ok 31 - file with path contains updated setting 169s # test remove 169s ok 32 - pg_conftool remove a 169s ok 33 - correct output of pg_conftool remove a 169s ok 34 - setting removed from file 169s ok 35 - pg_conftool /tmp/04XxBoHznV/different.conf remove a 169s ok 36 - correct output of pg_conftool /tmp/04XxBoHznV/different.conf remove a 169s ok 37 - setting removed from file with path 169s # test edit 169s ok 38 - pg_conftool edit 169s ok 39 - correct output of pg_conftool edit 169s ok 40 - pg_conftool /tmp/04XxBoHznV/different.conf edit 169s ok 41 - correct output of pg_conftool /tmp/04XxBoHznV/different.conf edit 169s === Running test 010_defaultport_cluster.t ... === 169s 1..14 169s ok 1 - psql --version 169s ok 2 - pg_wrapper selects highest available version number 169s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 169s ok 4 - connecting to localhost fails with no clusters 169s ok 5 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -l 169s ok 6 - pg_wrapper uses host and port from PGCLUSTER 169s ok 7 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --cluster 14/127.0.0.3:5430 -l 169s ok 8 - pg_wrapper uses --cluster from the command line 169s ok 9 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -h 127.0.0.3 -l 169s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 169s ok 11 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --host 127.0.0.3 -l 169s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 169s ok 13 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 169s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 169s === Running test 012_maintscripts.t ... === 169s 1..14 169s # We are running systemd 173s ok 1 - pg_createcluster 14 main --start 173s ok 2 - postmaster PID is 5228 174s ok 3 - dpkg-reconfigure --frontend=noninteractive postgresql-common 174s ok 4 - postmaster PID is 5228 174s ok 5 - postmaster was not restarted 175s ok 6 - pg_dropcluster 14 main --stop 175s # Cleanup 175s ok 7 - Cleanup: No clusters left behind 175s ok 8 - No postgres processes left behind 175s ok 9 - No files in /etc/postgresql left behind 175s ok 10 - No files in /var/lib/postgresql left behind 175s ok 11 - No files in /var/run/postgresql left behind 175s ok 12 - No files in /var/log/postgresql left behind 175s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 175s ok 14 - PostgreSQL TCP ports are closed 175s === Running test 015_start_stop.t ... === 175s 1..71 175s # We are running systemd 175s # Running tests for 14 175s # Cluster does not exist yet 175s ok 1 - cluster 14 main does not exist 175s ok 2 - service postgresql@14-main does not exist 175s ok 3 - systemctl start postgresql 175s ok 4 - cluster 14 main does not exist 175s ok 5 - service postgresql@14-main does not exist 175s ok 6 - systemctl start postgresql@14-main 175s ok 7 - cluster 14 main does not exist 175s ok 8 - service postgresql@14-main does not exist 175s # Start/stop postgresql using system tools 176s ok 9 - pg_createcluster 14 main 176s ok 10 - cluster 14 main is stopped 176s ok 11 - service postgresql@14-main is stopped 178s ok 12 - systemctl start postgresql 178s ok 13 - cluster 14 main is running 178s ok 14 - service postgresql@14-main is running 178s ok 15 - systemctl start postgresql 178s ok 16 - cluster 14 main is already running 178s ok 17 - service postgresql@14-main is already running 178s ok 18 - systemctl stop postgresql 184s ok 19 - cluster 14 main is stopped 184s ok 20 - service postgresql@14-main is stopped 184s ok 21 - systemctl stop postgresql 184s ok 22 - cluster 14 main is already stopped 184s ok 23 - service postgresql@14-main is already stopped 184s # Start/stop specific cluster using system tools 187s ok 24 - systemctl start postgresql@14-main 187s ok 25 - cluster 14 main is running 187s ok 26 - service postgresql@14-main is running 187s ok 27 - systemctl start postgresql@14-main 187s ok 28 - cluster 14 main is running 187s ok 29 - service postgresql@14-main is running 189s ok 30 - systemctl restart postgresql@14-main 189s ok 31 - cluster 14 main is running 189s ok 32 - service postgresql@14-main is running 189s ok 33 - systemctl stop postgresql@14-main 189s ok 34 - cluster 14 main is stopped 189s ok 35 - service postgresql@14-main is stopped 189s ok 36 - systemctl stop postgresql@14-main 189s ok 37 - cluster 14 main is already stopped 189s ok 38 - service postgresql@14-main is already stopped 191s ok 39 - pg_dropcluster 14 main 191s ok 40 - cluster 14 main does not exist 191s ok 41 - service postgresql@14-main does not exist 191s # Start/stop specific cluster using pg_*cluster 191s ok 42 - pg_ctlcluster start 14 main 191s ok 43 - cluster 14 main does not exist 191s ok 44 - service postgresql@14-main does not exist 194s ok 45 - pg_createcluster 14 main --start 194s ok 46 - cluster 14 main is running 194s ok 47 - service postgresql@14-main is running 194s ok 48 - pg_ctlcluster 14 main start 194s ok 49 - cluster 14 main is already running 194s ok 50 - service postgresql@14-main is already running 196s ok 51 - pg_ctlcluster 14-main restart 196s ok 52 - cluster 14 main is running 197s ok 53 - service postgresql@14-main is running 197s ok 54 - pg_ctlcluster 14 main stop 197s ok 55 - cluster 14 main is stopped 197s ok 56 - service postgresql@14-main is stopped 197s ok 57 - pg_ctlcluster 14 main stop 197s ok 58 - cluster 14 main is already stopped 197s ok 59 - service postgresql@14-main is already stopped 199s ok 60 - pg_ctlcluster start 14-main 199s ok 61 - cluster 14 main is running 199s ok 62 - service postgresql@14-main is running 200s ok 63 - pg_dropcluster 14 main --stop 200s # Cleanup 200s ok 64 - Cleanup: No clusters left behind 200s ok 65 - No postgres processes left behind 200s ok 66 - No files in /etc/postgresql left behind 200s ok 67 - No files in /var/lib/postgresql left behind 200s ok 68 - No files in /var/run/postgresql left behind 200s ok 69 - No files in /var/log/postgresql left behind 200s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 200s ok 71 - PostgreSQL TCP ports are closed 200s === Running test 020_create_sql_remove.t ... === 201s 1..147 201s # Running tests for 14 204s ok 1 - pg_createcluster 14 main --start -- -X /tmp/14.xlog.8fZ_8H 204s ok 2 - pg_createcluster 14 main 204s ok 3 - Socket and pid file are in /var/run/postgresql/ 204s ok 4 - xlog/wal directory /tmp/14.xlog.8fZ_8H was created 204s ok 5 - local method in pg_hba.conf is peer 204s ok 6 - host method in pg_hba.conf is scram-sha-256 204s ok 7 - Exactly one postgres master process running 206s ok 8 - pg_ctlcluster 14 main restart 206s ok 9 - cluster restarts with new environment file 206s ok 10 - Exactly one postgres master process running 206s ok 11 - correct value of PGEXTRAVAR1 in environment 206s ok 12 - correct value of PGEXTRAVAR2 in environment 206s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 206s ok 14 - createdb --version 206s ok 15 - pg_wrapper selects version number of cluster 206s ok 16 - psql --version 206s ok 17 - pg_wrapper selects version number of cluster 206s ok 18 - pg_lscluster reports online cluster on port 5432 206s ok 19 - log file is actually used 206s ok 20 - /etc/postgresql is owned by user "postgres" 206s ok 21 - version configuration directory file is owned by user "postgres" 206s ok 22 - configuration directory file is owned by user "postgres" 206s ok 23 - version data directory file is owned by user "postgres" 206s ok 24 - data directory file is owned by user "postgres" 206s ok 25 - log file has 0640 permissions 206s ok 26 - log file is owned by user "postgres" 206s ok 27 - log file is owned by group "adm" 206s ok 28 - no log symlink by default 206s ok 29 - /var/log/postgresql/postgresql-14-main.log is the default log if log symlink is missing 206s ok 30 - pg_lsclusters -h 206s ok 31 - correct output of pg_lsclusters -h 206s ok 32 - stopping cluster 209s ok 33 - restarting cluster with nondefault log symlink 209s ok 34 - log target is used as log file 209s ok 35 - default log is not used 209s ok 36 - pg_lsclusters -h 209s ok 37 - correct output of pg_lsclusters -h 209s ok 38 - stopping cluster 212s ok 39 - restarting cluster with explicitly configured log file 212s ok 40 - default log is not used 212s ok 41 - log symlink target is used for startup message 212s ok 42 - exactly one log file 212s ok 43 - custom log is actually used 212s ok 44 - pg_lsclusters -h 212s ok 45 - correct output of pg_lsclusters -h 212s ok 46 - stopping cluster 212s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 212s ok 48 - /etc/postgres-hack was not created 214s ok 49 - restarting cluster 214s ok 50 - ps -o tty -U postgres h 214s ok 51 - postgres processes do not have an associated terminal 214s ok 52 - Server is linked with SSL support 214s ok 53 - SSL is enabled in postgresql.conf 214s ok 54 - psql -l fails for nobody 214s ok 55 - createuser nobody 214s ok 56 - createdb nobodydb 215s ok 57 - psql -ltA succeeds for nobody 215s ok 58 - psql -ltA output 215s ok 59 - SQL command: create table 215s ok 60 - SQL command: insert into table values 215s ok 61 - SQL command: insert into table values 215s ok 62 - primary key violation 215s ok 63 - psql -tAc "select * from phone order by name" nobodydb 215s ok 64 - SQL command output: select -tA 215s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 215s ok 66 - SQL command output: select -tx 215s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 215s ok 68 - SQL command output: select -tAx 215s ok 69 - CREATE EXTENSION plperlu fails for user nobody 215s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 215s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 215s ok 72 - creating PL/PerlU function as user nobody fails 215s ok 73 - creating unsafe PL/Perl function as user postgres fails 215s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 215s ok 75 - creating PL/PerlU function as user postgres succeeds 215s ok 76 - psql nobodydb -Atc "select read_file()" 215s ok 77 - calling PL/PerlU function 215s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 215s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 215s ok 80 - creating unsafe PL/Perl function as user nobody fails 215s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 215s ok 82 - creating PL/Perl function as user nobody succeeds 215s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 215s ok 84 - calling PL/Perl function 215s ok 85 # skip No python2 support 215s ok 86 # skip No python2 support 215s ok 87 # skip No python2 support 215s ok 88 # skip No python2 support 215s ok 89 # skip No python2 support 215s ok 90 # skip No python2 support 215s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 215s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 215s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 215s ok 94 - creating PL/Python3 function as user postgres succeeds 215s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 215s ok 96 - calling PL/Python function 215s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 215s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 216s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 216s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 216s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 216s ok 102 - creating PL/Tcl function as user nobody succeeds 216s 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;" 216s ok 104 - creating PL/TclU function as user postgres succeeds 216s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 216s ok 106 - calling PL/Tcl function 216s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 216s ok 108 - calling PL/TclU function 216s ok 109 - stopping cluster 216s ok 110 - pg_ctlcluster 14 main start 216s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 218s ok 112 - pg_ctlcluster 14 main start 218s ok 113 - cluster restarts with pgdata symlink 219s ok 114 - postgres master has OOM killer protection 219s ok 115 - postgres client backend has no OOM adjustment 219s ok 116 - ps h 6769 219s ok 117 - process title is idle 219s ok 118 - ps h 6769 219s ok 119 - process title is idle in transaction 219s ok 120 - stopping cluster 221s ok 121 - starting cluster as postgres works without a log file 221s ok 122 - log file got recreated and used 221s ok 123 - creating a directory in spc2 222s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/14.spc1.aXX5wc'" 222s ok 125 - creating tablespace spc1 222s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 222s ok 127 - creating a table in spc1 222s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/14.spc2.RskvEa'" 222s ok 129 - creating tablespace spc2 222s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 222s ok 131 - creating a table in spc2 222s ok 132 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 222s ok 133 - Correct apt NeverAutoRemove config 223s ok 134 - pg_dropcluster removes cluster 223s ok 135 - xlog/wal directory /tmp/14.xlog.8fZ_8H was deleted 223s ok 136 - tablespace spc1 was emptied 223s ok 137 - tablespace spc2 was emptied 223s ok 138 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 223s ok 139 - Correct apt NeverAutoRemove config 223s # Cleanup 223s ok 140 - Cleanup: No clusters left behind 223s ok 141 - No postgres processes left behind 223s ok 142 - No files in /etc/postgresql left behind 223s ok 143 - No files in /var/lib/postgresql left behind 223s ok 144 - No files in /var/run/postgresql left behind 223s ok 145 - No files in /var/log/postgresql left behind 223s ok 146 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 223s ok 147 - PostgreSQL TCP ports are closed 223s === Running test 021_pg_renamecluster.t ... === 223s 1..20 226s ok 1 - pg_createcluster 14 main 229s ok 2 - pg_renamecluster 14 main donau 229s ok 3 - psql -tAc "show data_directory" 229s ok 4 - cluster is running and data_directory was moved 229s ok 5 - pg_hba.conf location updated 229s ok 6 - pg_ident.conf location updated 229s ok 7 - external_pid_file location updated 229s ok 8 - external_pid_file exists 229s ok 9 - stats_temp_directory location updated 229s ok 10 - stats_temp_directory exists 229s ok 11 - cluster_name is updated 230s ok 12 - pg_dropcluster removes cluster 230s # Cleanup 230s ok 13 - Cleanup: No clusters left behind 230s ok 14 - No postgres processes left behind 230s ok 15 - No files in /etc/postgresql left behind 230s ok 16 - No files in /var/lib/postgresql left behind 230s ok 17 - No files in /var/run/postgresql left behind 230s ok 18 - No files in /var/log/postgresql left behind 230s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 230s ok 20 - PostgreSQL TCP ports are closed 230s === Running test 022_recovery.t ... === 230s 1..17 230s # Running tests for 14 234s ok 1 - pg_createcluster 14 main --start >/dev/null 234s ok 2 - pg_ctlcluster 14 main stop -m i 236s ok 3 - pg_ctlcluster 14 main start 236s ok 4 - psql -c '' 236s ok 5 - pg_ctlcluster 14 main stop -m i 236s ok 6 - create write-protected file in data directory 238s ok 7 - pg_ctlcluster 14 main start 239s ok 8 - psql -c '' 240s ok 9 - pg_dropcluster removes cluster 240s # Cleanup 240s ok 10 - Cleanup: No clusters left behind 240s ok 11 - No postgres processes left behind 240s ok 12 - No files in /etc/postgresql left behind 240s ok 13 - No files in /var/lib/postgresql left behind 240s ok 14 - No files in /var/run/postgresql left behind 240s ok 15 - No files in /var/log/postgresql left behind 240s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 240s ok 17 - PostgreSQL TCP ports are closed 240s === Running test 025_logging.t ... === 240s 1..55 240s # Logging to /var/log/syslog works 240s # Running tests for 14 244s ok 1 - pg_createcluster 14 main 244s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-14-main.log 244s ok 3 - psql -qc "'foobar_14_7671'" 244s ok 4 - log an error 244s ok 5 - grep --binary-files=text foobar_14_7671 /var/log/postgresql/postgresql-14-main.log 244s ok 6 - error appears in logfile 244s ok 7 - pg_conftool 14 main set log_destination syslog 244s ok 8 - set log_destination syslog 244s ok 9 - pg_ctlcluster 14 main reload 244s ok 10 - 14 main reload 244s ok 11 - psql -Atc "show log_destination" 244s ok 12 - log_destination is syslog 244s ok 13 - pg_lscluster reports syslog 245s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 245s ok 15 - error appears in /var/log/syslog 245s ok 16 - pg_conftool 14 main set logging_collector on 245s ok 17 - set logging_collector on 245s ok 18 - pg_conftool 14 main set log_destination csvlog 245s ok 19 - set log_destination csvlog 247s ok 20 - pg_ctlcluster 14 main restart 247s ok 21 - 14 main restart 247s ok 22 - psql -Atc "show logging_collector" 247s ok 23 - logging_collector is on 247s ok 24 - psql -Atc "show log_destination" 247s ok 25 - log_destination is csvlog 247s ok 26 - pg_lscluster reports csvlog 247s ok 27 - psql -qc "'barbaz_14_7671'" 247s ok 28 - log an error 248s ok 29 - grep --binary-files=text barbaz_14_7671 /var/lib/postgresql/14/main/log/*.csv 248s ok 30 - error appears in log/*.csv 248s ok 31 - pg_conftool 14 main set log_destination stderr,syslog,csvlog 248s ok 32 - set log_destination stderr,syslog,csvlog 248s ok 33 - pg_ctlcluster 14 main reload 248s ok 34 - 14 main reload 248s ok 35 - psql -Atc "show log_destination" 248s ok 36 - log_destination is stderr,syslog,csvlog 248s ok 37 - pg_lscluster reports stderr,syslog,csvlog 248s ok 38 - psql -qc "'moo_14_7671'" 248s ok 39 - log an error 249s ok 40 - grep --binary-files=text moo_14_7671 /var/lib/postgresql/14/main/log/*.log 249s ok 41 - error appears in log/*.log 249s ok 42 - grep --binary-files=text 'postgres.*moo_14_7671' /var/log/syslog 249s ok 43 - error appears in /var/log/syslog 249s ok 44 - grep --binary-files=text moo_14_7671 /var/lib/postgresql/14/main/log/*.csv 249s ok 45 - error appears in log/*.csv 250s ok 46 - pg_dropcluster 14 main --stop 250s ok 47 - pg_dropcluster removes cluster 250s # Cleanup 250s ok 48 - Cleanup: No clusters left behind 250s ok 49 - No postgres processes left behind 250s ok 50 - No files in /etc/postgresql left behind 250s ok 51 - No files in /var/lib/postgresql left behind 250s ok 52 - No files in /var/run/postgresql left behind 250s ok 53 - No files in /var/log/postgresql left behind 250s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 250s ok 55 - PostgreSQL TCP ports are closed 250s === Running test 030_errors.t ... === 251s 1..156 251s ok 1 - pg_lscluster reports cluster without binaries 251s ok 2 - pg_dropcluster 6.3 main 252s ok 3 - pg_createcluster --socketdir 252s ok 4 - pg_lsclusters -h 252s ok 5 - cluster was created 252s ok 6 - Port of created cluster is 5432 252s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 14 main 252s ok 8 - pg_createcluster on existing cluster 252s ok 9 - pg_lsclusters -h 252s ok 10 - original cluster still exists 252s ok 11 - pg_createcluster 14 test -p foo 252s ok 12 - pg_createcluster -p checks that port option is numeric 253s ok 13 - pg_createcluster 14 test -p 42 253s ok 14 - pg_createcluster -p checks valid port range 253s ok 15 - pg_ctlcluster 14 main start 253s ok 16 - pg_ctlcluster refuses to start root-owned cluster 253s ok 17 - pg_ctlcluster 14 main start 253s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 253s ok 19 - pg_ctlcluster 14 main start 253s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 253s ok 21 - pg_ctlcluster 14 main start 253s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 255s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 255s ok 24 - No sockets in /var/run/postgresql 255s ok 25 - Socket is in /tmp/postgresql-testsuite/ 255s ok 26 - cluster stops with custom unix_socket_dir 255s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 257s ok 28 - cluster starts after removing unix_socket_dir 257s ok 29 - Socket is in default dir /var/run/postgresql 257s ok 30 - No sockets in /tmp/postgresql-testsuite/ 257s ok 31 - pg_ctlcluster 14 main stop 257s ok 32 - pg_ctlcluster fails with corrupted PID file 257s ok 33 - pg_lsclusters -h 257s ok 34 - cluster is still online 258s ok 35 - pg_ctlcluster succeeds with restored PID file 258s ok 36 - pg_lsclusters -h 258s ok 37 - cluster is down 258s ok 38 - pg_ctlcluster 14 main stop 258s ok 39 - pg_ctlcluster stop fails on stopped cluster 260s ok 40 - pg_ctlcluster 14 main start 260s ok 41 - pg_ctlcluster succeeds with already existing PID file 260s ok 42 - pg_lsclusters -h 260s ok 43 - cluster is online 260s ok 44 - pg_ctlcluster stop succeeds 260s ok 45 - pg_lsclusters -h 260s ok 46 - cluster is down 260s ok 47 - no pid file left 260s ok 48 - pg_ctlcluster 14 main stop 260s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 260s ok 50 - pid file was cleaned up 260s ok 51 - pg_ctlcluster --force 14 main stop 260s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 260s ok 53 - pid file was cleaned up 260s ok 54 - pg_ctlcluster 14 main stop 260s ok 55 - pg_ctlcluster stop succeeds with stale PID file 260s ok 56 - pid file was cleaned up 260s ok 57 - pg_ctlcluster --force 14 main stop 260s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 260s ok 59 - pid file was cleaned up 260s ok 60 - pg_ctlcluster --force 14 main stop 260s ok 61 - pg_ctlcluster stop succeeds with empty PID file 260s ok 62 - pid file was cleaned up 263s ok 63 - pg_ctlcluster 14 main start 263s ok 64 - pg_ctlcluster succeeds with corrupted PID file 263s ok 65 - pg_lsclusters -h 263s ok 66 - cluster is online 263s ok 67 - pg_ctlcluster 14 main start 263s ok 68 - pg_ctlcluster start fails on running cluster 263s ok 69 - pg_ctlcluster stop 263s ok 70 - pg_ctlcluster 14 main start 263s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 263s ok 72 - pg_ctlcluster 14 main stop 263s ok 73 - stopping cluster 269s ok 74 - pg_ctlcluster 14 main start 269s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 269s ok 76 - pg_ctlcluster 14 main stop 269s ok 77 - stopping cluster 269s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 269s ok 79 - pg_dropcluster 14 main 269s ok 80 - pg_dropcluster works as user postgres 270s ok 81 - pg_createcluster succeeds 270s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 270s ok 83 - proper error message for nonexisting /var/lib/postgresql 273s ok 84 - pg_ctlcluster 14 main start 273s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 273s ok 86 - pg_ctlcluster 14 main stop 273s ok 87 - stopping cluster 274s ok 88 - pg_createcluster other 276s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 278s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 278s ok 91 278s ok 92 - pg_ctlcluster 14 other start 278s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 278s ok 94 - pg_ctlcluster 14 main stop 278s ok 95 - stopping main cluster 281s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 282s ok 97 - pg_dropcluster other 283s ok 98 - pg_dropcluster 283s ok 99 - No sockets any more 283s ok 100 - 'pg_lsclusters 4.5 foo' fails 283s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 283s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 283s ok 103 - 'psql --cluster 4.5/foo' fails 283s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 283s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 283s ok 106 - 'psql --cluster 14/foo' fails 283s ok 107 - psql --cluster 14/foo gives error message about nonexisting cluster 283s ok 108 - psql --cluster 14/foo does not print 'invalid symbolic link' gibberish 283s ok 109 - 'pg_dropcluster 4.5 foo' fails 283s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 283s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 283s ok 112 - 'pg_dropcluster 14 foo' fails 283s ok 113 - pg_dropcluster 14 foo gives error message about nonexisting cluster 283s ok 114 - pg_dropcluster 14 foo does not print 'invalid symbolic link' gibberish 283s ok 115 - 'pg_upgradecluster 4.5 foo' fails 283s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 283s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 283s ok 118 - 'pg_upgradecluster 14 foo' fails 283s ok 119 - pg_upgradecluster 14 foo gives error message about nonexisting cluster 283s ok 120 - pg_upgradecluster 14 foo does not print 'invalid symbolic link' gibberish 283s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 283s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 283s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 283s ok 124 - 'pg_ctlcluster 14 foo stop' fails 283s ok 125 - pg_ctlcluster 14 foo stop gives error message about nonexisting cluster 283s ok 126 - pg_ctlcluster 14 foo stop does not print 'invalid symbolic link' gibberish 283s # Cleanup 283s ok 127 - Cleanup: No clusters left behind 283s ok 128 - No postgres processes left behind 283s ok 129 - No files in /etc/postgresql left behind 283s ok 130 - No files in /var/lib/postgresql left behind 283s ok 131 - No files in /var/run/postgresql left behind 283s ok 132 - No files in /var/log/postgresql left behind 283s ok 133 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 283s ok 134 - PostgreSQL TCP ports are closed 284s ok 135 - pg_dropcluster 14 broken 284s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 284s # Cleanup 284s ok 137 - Cleanup: No clusters left behind 284s ok 138 - No postgres processes left behind 284s ok 139 - No files in /etc/postgresql left behind 284s ok 140 - No files in /var/lib/postgresql left behind 284s ok 141 - No files in /var/run/postgresql left behind 284s ok 142 - No files in /var/log/postgresql left behind 284s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 284s ok 144 - PostgreSQL TCP ports are closed 285s ok 145 - pg_dropcluster 14 broken 285s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 285s ok 147 - /etc/postgresql/14 was removed 285s ok 148 - /var/lib/postgresql/14 was removed 285s # Cleanup 285s ok 149 - Cleanup: No clusters left behind 285s ok 150 - No postgres processes left behind 285s ok 151 - No files in /etc/postgresql left behind 285s ok 152 - No files in /var/lib/postgresql left behind 285s ok 153 - No files in /var/run/postgresql left behind 285s ok 154 - No files in /var/log/postgresql left behind 285s ok 155 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 285s ok 156 - PostgreSQL TCP ports are closed 285s === Running test 031_errors_disk_full.t ... === 286s 1..22 286s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 289s ok 1 - script failed 289s ok 2 - pg_createcluster fails due to insufficient disk space 289s ok 3 - does not leave files behind 289s # Cleanup 289s ok 4 - Cleanup: No clusters left behind 289s ok 5 - No postgres processes left behind 289s ok 6 - No files in /etc/postgresql left behind 289s ok 7 - No files in /var/lib/postgresql left behind 289s ok 8 - No files in /var/run/postgresql left behind 289s ok 9 - No files in /var/log/postgresql left behind 289s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 289s ok 11 - PostgreSQL TCP ports are closed 289s # check disk full conditions on startup 289s ok 12 - script failed 289s ok 13 - pg_ctlcluster prints error message 289s ok 14 - log file has error message 289s # Cleanup 289s ok 15 - Cleanup: No clusters left behind 289s ok 16 - No postgres processes left behind 289s ok 17 - No files in /etc/postgresql left behind 289s ok 18 - No files in /var/lib/postgresql left behind 289s ok 19 - No files in /var/run/postgresql left behind 289s ok 20 - No files in /var/log/postgresql left behind 289s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 289s ok 22 - PostgreSQL TCP ports are closed 289s === Running test 032_ssl_key_permissions.t ... === 289s 1..22 289s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 289s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 289s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 289s # 14 (14.15-0ubuntu0.22.04.1) 290s ok 4 - pg_createcluster 14 main 290s ok 5 - pg_ctlcluster 14 main start 290s ok 6 - ssl key owned by nobody refused 290s ok 7 - pg_ctlcluster 14 main start 290s ok 8 - ssl key with permissions root:root 0644 refused 291s ok 9 - pg_ctlcluster 14 main start 291s ok 10 - ssl key with permissions postgres:postgres 0640 refused 292s ok 11 - pg_dropcluster 14 main --stop 292s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 292s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 292s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 292s # Cleanup 292s ok 15 - Cleanup: No clusters left behind 292s ok 16 - No postgres processes left behind 292s ok 17 - No files in /etc/postgresql left behind 292s ok 18 - No files in /var/lib/postgresql left behind 292s ok 19 - No files in /var/run/postgresql left behind 292s ok 20 - No files in /var/log/postgresql left behind 292s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 292s ok 22 - PostgreSQL TCP ports are closed 292s === Running test 040_upgrade.t ... === 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s === Running test 041_upgrade_custompaths.t ... === 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s === Running test 043_upgrade_ssl_cert.t ... === 292s 1..1 292s ok 1 - only one major version installed, skipping upgrade tests 292s === Running test 045_backup.t ... === 292s # We are running systemd 292s # PostgreSQL 14 292s # create cluster 295s ok 1 - pg_createcluster --locale en_US.UTF-8 14 main --start 295s ok 2 - pg_lsclusters -h 295s ok 3 - correct output of pg_lsclusters -h 295s ok 4 - pg_conftool 14 main set work_mem 11MB 295s ok 5 - createdb -E SQL_ASCII -T template0 mydb 295s ok 6 - psql -c 'alter database mydb set search_path=public' 295s ok 7 - psql -c 'create table foo (t text)' mydb 296s ok 8 - psql -c "insert into foo values ('important data')" mydb 296s ok 9 - psql -c 'CREATE USER myuser' 296s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 296s ok 11 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 296s # create directory 296s ok 12 - pg_backupcluster 14 main createdirectory 296s ok 13 - /var/backups/postgresql/14-main owned by uid postgres 296s ok 14 - /var/backups/postgresql/14-main owned by gid postgres 296s # dump 296s ok 15 - systemctl start pg_dump@14-main 296s ok 16 - dump created in /var/backups/postgresql/14-main/2025-02-26T132026Z.dump 296s ok 17 - /var/backups/postgresql/14-main/2025-02-26T132026Z.dump owned by uid postgres 296s ok 18 - /var/backups/postgresql/14-main/2025-02-26T132026Z.dump owned by gid postgres 296s # basebackup 296s ok 19 - systemctl start pg_receivewal@14-main 302s ok 20 - systemctl start pg_basebackup@14-main 302s ok 21 - dump created in /var/backups/postgresql/14-main/2025-02-26T132026Z.backup 302s ok 22 - /var/backups/postgresql/14-main/2025-02-26T132026Z.backup owned by uid postgres 302s ok 23 - /var/backups/postgresql/14-main/2025-02-26T132026Z.backup owned by gid postgres 302s # list 302s ok 24 - pg_backupcluster 14 main list 302s ok 25 - correct output of pg_backupcluster 14 main list 302s # more database changes 302s ok 26 - psql -c "insert into foo values ('some other data')" mydb 302s ok 27 - psql -c "insert into foo values ('yet more data')" mydb 302s ok 28 - retrieve recovery timestamp 302s ok 29 - psql -c "delete from foo where t = 'some other data'" mydb 303s ok 30 - systemctl stop pg_receivewal@14-main 303s # restore /var/backups/postgresql/14-main/2025-02-26T132026Z.dump 304s ok 31 - pg_dropcluster 14 main --stop 308s ok 32 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132026Z.dump --start --datadir /var/lib/postgresql/14/snowflake 309s ok 33 - pg_lsclusters -h 309s ok 34 - correct output of pg_lsclusters -h 309s ok 35 - psql -XAtl 309s ok 36 - correct output of psql -XAtl 309s ok 37 - psql -XAtc 'show work_mem' 309s ok 38 - correct output of psql -XAtc 'show work_mem' 309s ok 39 - psql -XAtc 'select * from foo' mydb 309s ok 40 - correct output of psql -XAtc 'select * from foo' mydb 309s ok 41 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 309s ok 42 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 309s ok 43 - psql -XAtc '\drds' 309s ok 44 - correct output of psql -XAtc '\drds' 309s # restore /var/backups/postgresql/14-main/2025-02-26T132026Z.backup 310s ok 45 - pg_dropcluster 14 main --stop 313s ok 46 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132026Z.backup --start --datadir /var/lib/postgresql/14/snowflake 313s ok 47 - pg_lsclusters -h 313s ok 48 - correct output of pg_lsclusters -h 313s ok 49 - psql -XAtl 313s ok 50 - correct output of psql -XAtl 313s ok 51 - psql -XAtc 'show work_mem' 313s ok 52 - correct output of psql -XAtc 'show work_mem' 313s ok 53 - psql -XAtc 'select * from foo' mydb 313s ok 54 - correct output of psql -XAtc 'select * from foo' mydb 314s ok 55 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 314s ok 56 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 314s ok 57 - psql -XAtc '\drds' 314s ok 58 - correct output of psql -XAtc '\drds' 314s # restore /var/backups/postgresql/14-main/2025-02-26T132026Z.backup with WAL archive 315s ok 59 - pg_dropcluster 14 main --stop 318s ok 60 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132026Z.backup --start --archive --port 5430 318s ok 61 - pg_lsclusters -h 318s ok 62 - correct output of pg_lsclusters -h 318s ok 63 - psql -XAtc 'select * from foo order by t' mydb 318s ok 64 - correct output of psql -XAtc 'select * from foo order by t' mydb 318s # restore /var/backups/postgresql/14-main/2025-02-26T132026Z.backup with PITR 320s ok 65 - pg_dropcluster 14 main --stop 323s ok 66 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132026Z.backup --start --pitr '2025-02-26 13:20:32.903245+00 323s # ' 323s ok 67 - pg_lsclusters -h 323s ok 68 - correct output of pg_lsclusters -h 323s ok 69 - psql -XAtc 'select * from foo order by t' mydb 323s ok 70 - correct output of psql -XAtc 'select * from foo order by t' mydb 325s ok 71 - pg_dropcluster 14 main --stop 325s # Cleanup 325s ok 72 - Cleanup: No clusters left behind 325s ok 73 - No postgres processes left behind 325s ok 74 - No files in /etc/postgresql left behind 325s ok 75 - No files in /var/lib/postgresql left behind 325s ok 76 - No files in /var/run/postgresql left behind 325s ok 77 - No files in /var/log/postgresql left behind 325s ok 78 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 325s ok 79 - PostgreSQL TCP ports are closed 325s 1..79 325s === Running test 050_encodings.t ... === 325s 1..60 325s # Checking 14 ru_RU 328s ok 1 - pg_createcluster version 14 for ru_RU without --encoding succeeded 329s ok 2 - psql -l succeeds 329s ok 3 - template1 is not UTF-8 encoded 329s ok 4 - creating test database 329s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 329s # create table t (x varchar); copy t from stdin" test 329s ok 6 - creating table with ISO-8859-5 characters 329s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 329s ok 8 - correct string in UTF-8 329s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 329s ok 10 - correct string in ISO-8859-5 329s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 329s # delete from t; copy t from stdin" test 329s ok 12 - creating table with UTF-8 characters 329s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 329s ok 14 - correct string in UTF-8 329s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 329s ok 16 - correct string in ISO-8859-1 329s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 329s ok 18 - Server error message has correct language and encoding 332s ok 19 - pg_ctlcluster 14 ru_RU restart 332s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 333s ok 21 - Dropping cluster 333s # Checking 14 ru_RU.UTF-8 336s ok 22 - pg_createcluster version 14 for ru_RU.UTF-8 without --encoding succeeded 337s ok 23 - psql -l succeeds 337s ok 24 - template1 is UTF-8 encoded 337s ok 25 - creating test database 337s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 337s # create table t (x varchar); copy t from stdin" test 337s ok 27 - creating table with ISO-8859-5 characters 337s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 337s ok 29 - correct string in UTF-8 337s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 337s ok 31 - correct string in ISO-8859-5 337s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 337s # delete from t; copy t from stdin" test 337s ok 33 - creating table with UTF-8 characters 338s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 338s ok 35 - correct string in UTF-8 338s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 338s ok 37 - correct string in ISO-8859-1 338s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 338s ok 39 - Server error message has correct language and encoding 340s ok 40 - pg_ctlcluster 14 ru_RU.UTF8 restart 340s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 340s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 340s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 340s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 340s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 340s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 340s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 341s ok 48 - Dropping cluster 341s # Check 14 locale environment variables 345s ok 49 - pg_createcluster: LC_ALL dominates LANG 345s ok 50 - psql -Atl --cluster 14/main 345s ok 51 - template1 is ASCII encoded 347s ok 52 - Dropping cluster 347s # Cleanup 347s ok 53 - Cleanup: No clusters left behind 347s ok 54 - No postgres processes left behind 347s ok 55 - No files in /etc/postgresql left behind 347s ok 56 - No files in /var/lib/postgresql left behind 347s ok 57 - No files in /var/run/postgresql left behind 347s ok 58 - No files in /var/log/postgresql left behind 347s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 347s ok 60 - PostgreSQL TCP ports are closed 347s === Running test 052_upgrade_encodings.t ... === 347s 1..1 347s ok 1 - only one major version installed, skipping upgrade tests 347s === Running test 060_obsolete_confparams.t ... === 347s ok 1 - only one major version installed, skipping upgrade tests 347s 1..1 347s === Running test 070_non_postgres_clusters.t ... === 347s 1..40 348s ok 1 - pg_createcluster 14 main for owner nobody 348s ok 2 - pg_ctlcluster 14 main start 348s ok 3 - start refused when config and data owners mismatch 350s ok 4 - pg_ctlcluster succeeds with owner nobody 350s ok 5 - pg_lsclusters -h 350s ok 6 - pg_lsclusters shows running cluster 350s ok 7 - postgres is running as user nobody 350s ok 8 - ls /tmp/.s.PGSQL.* 350s ok 9 - socket is in /tmp 350s ok 10 - /var/run/postgresql is empty 350s ok 11 - conf dir is owned by user 350s ok 12 - conf dir is owned by user's primary group 350s ok 13 - files are owned by user 350s ok 14 - files are owned by user's primary group 350s ok 15 - log file has 0640 permissions 350s ok 16 - log file is owned by user 350s ok 17 - log file is owned by user's primary group 350s ok 18 - only one major version installed, skipping upgrade test 350s ok 19 - ... 350s ok 20 - ... 350s ok 21 - ... 350s ok 22 - ... 350s ok 23 - ... 350s ok 24 - ... 350s ok 25 - ... 350s ok 26 - ... 350s ok 27 - ... 350s ok 28 - ... 352s ok 29 - pg_dropcluster 352s ok 30 - pg_lsclusters -h 352s ok 31 - No clusters left 352s ok 32 - No postgres processes left 352s # Cleanup 352s ok 33 - Cleanup: No clusters left behind 352s ok 34 - No postgres processes left behind 352s ok 35 - No files in /etc/postgresql left behind 352s ok 36 - No files in /var/lib/postgresql left behind 352s ok 37 - No files in /var/run/postgresql left behind 352s ok 38 - No files in /var/log/postgresql left behind 352s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 352s ok 40 - PostgreSQL TCP ports are closed 352s === Running test 080_start.conf.t ... === 352s 1..73 353s ok 1 - pg_createcluster 14 main 353s # start.conf auto 353s ok 2 - get_cluster_start_conf returns auto 353s ok 3 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 353s ok 4 - start.conf contains auto 353s ok 5 - systemd generator links cluster 353s ok 6 - systemd generator links correct service file 355s ok 7 - /etc/init.d/postgresql start 14 355s ok 8 - correct output of /etc/init.d/postgresql start 14 355s ok 9 - pg_lsclusters -h 355s ok 10 - cluster is online 355s ok 11 - /etc/init.d/postgresql stop 14 355s ok 12 - correct output of /etc/init.d/postgresql stop 14 358s ok 13 - pg_lsclusters -h 358s ok 14 - cluster is down 358s # start.conf manual 358s ok 15 - get_cluster_start_conf returns manual 358s ok 16 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 358s ok 17 - start.conf contains manual 358s ok 18 - systemd generator doesn't link cluster 358s ok 19 - /etc/init.d/postgresql start 14 358s ok 20 - correct output of /etc/init.d/postgresql start 14 358s ok 21 - pg_lsclusters -h 358s ok 22 - cluster is down 361s ok 23 - pg_ctlcluster 14 main start 361s ok 24 - correct output of pg_ctlcluster 14 main start 361s ok 25 - pg_lsclusters -h 361s ok 26 - cluster is online 361s ok 27 - pg_ctlcluster 14 main stop 361s ok 28 - correct output of pg_ctlcluster 14 main stop 361s ok 29 - pg_lsclusters -h 361s ok 30 - cluster is down 361s # start.conf disabled 361s ok 31 - get_cluster_start_conf returns disabled 361s ok 32 - systemd generator doesn't link cluster 361s ok 33 - /etc/init.d/postgresql start 14 361s ok 34 - correct output of /etc/init.d/postgresql start 14 361s ok 35 - pg_lsclusters -h 361s ok 36 - cluster is down 361s ok 37 - pg_ctlcluster 14 main start 361s ok 38 - correct output of pg_ctlcluster 14 main start 361s ok 39 - pg_lsclusters -h 361s ok 40 - cluster is down 363s ok 41 - pg_ctlcluster 14 main start 363s ok 42 - correct output of pg_ctlcluster 14 main start 363s ok 43 - pg_lsclusters -h 363s ok 44 - cluster is online 364s ok 45 - pg_ctlcluster 14 main stop 364s ok 46 - correct output of pg_ctlcluster 14 main stop 364s ok 47 - pg_lsclusters -h 364s ok 48 - cluster is down 366s ok 49 - pg_ctlcluster 14 main start 366s ok 50 - correct output of pg_ctlcluster 14 main start 366s ok 51 - pg_lsclusters -h 366s ok 52 - cluster is online 366s # test upgrade 366s ok 53 - only one major version installed, skipping upgrade test 366s ok 54 - ... 366s ok 55 - get_cluster_start_conf for old cluster returns manual 366s ok 56 - get_cluster_start_conf for new cluster returns manual 366s ok 57 - ... 367s ok 58 - dropping upgraded cluster 367s ok 59 - pg_lsclusters -h 367s ok 60 - no clusters any more 367s ok 61 - pg_createcluster 14 main --start-conf foo 367s ok 62 - pg_createcluster checks --start-conf validity 368s ok 63 - pg_createcluster checks --start-conf manual 368s ok 64 - get_cluster_start_conf returns manual 369s ok 65 - dropping cluster 369s # Cleanup 369s ok 66 - Cleanup: No clusters left behind 369s ok 67 - No postgres processes left behind 369s ok 68 - No files in /etc/postgresql left behind 369s ok 69 - No files in /var/lib/postgresql left behind 369s ok 70 - No files in /var/run/postgresql left behind 369s ok 71 - No files in /var/log/postgresql left behind 369s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 369s ok 73 - PostgreSQL TCP ports are closed 369s === Running test 085_pg_ctl.conf.t ... === 369s 1..29 370s ok 1 - pg_createcluster 14 main 370s ok 2 - /etc/postgresql/14/main/pg_ctl.conf exists 372s ok 3 - pg_ctlcluster 14 main start 372s ok 4 - starting cluster 372s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 372s ok 6 - soft core size is 0 372s ok 7 - set pg_ctl default option to -c 375s ok 8 - pg_ctlcluster 14 main restart 375s ok 9 - restarting cluster 375s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 375s ok 11 - soft core size is unlimited 375s ok 12 - restored pg_ctl default option 377s ok 13 - pg_ctlcluster 14 main restart 377s ok 14 - restarting cluster 377s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 377s ok 16 - soft core size is 0 379s ok 17 - pg_ctlcluster 14 main restart -- -c 379s ok 18 - restarting cluster with -c on the command line 379s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 379s ok 20 - soft core size is unlimited 380s ok 21 - dropping cluster 380s # Cleanup 380s ok 22 - Cleanup: No clusters left behind 380s ok 23 - No postgres processes left behind 380s ok 24 - No files in /etc/postgresql left behind 380s ok 25 - No files in /var/lib/postgresql left behind 380s ok 26 - No files in /var/run/postgresql left behind 380s ok 27 - No files in /var/log/postgresql left behind 380s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 380s ok 29 - PostgreSQL TCP ports are closed 380s === Running test 090_multicluster.t ... === 381s 1..125 381s ok 1 - pg_createcluster 14 old 382s ok 2 - pg_createcluster 14 new1 383s ok 3 - pg_createcluster 14 new2 386s ok 4 - starting cluster 14/old 388s ok 5 - starting cluster 14/new1 390s ok 6 - starting cluster 14/new2 390s ok 7 - pg_lsclusters -h | sort -k3 390s ok 8 - clusters have the correct ports, skipping used 5433 390s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 390s ok 10 - createdb --version 390s ok 11 - pg_wrapper selects port 5432 as default cluster 390s ok 12 - createdb --cluster 14/new1 --version 390s ok 13 - pg_wrapper --cluster works 390s ok 14 - createdb --cluster 14/foo --version 390s ok 15 - pg_wrapper --cluster errors out for invalid cluster 390s ok 16 - createdb --cluster 14/new1 test 390s ok 17 - correct output of createdb --cluster 14/new1 test 390s ok 18 - psql -Atl --cluster 14/new1 390s ok 19 - test db appears in cluster new1 390s ok 20 - psql -Atl --cluster 14/new2 390s ok 21 - test db does not appear in cluster new2 390s ok 22 - psql -Atl 390s ok 23 - test db does not appear in default cluster 390s ok 24 - psql --cluster 14/127.0.0.1: -Atc 'show port' template1 390s ok 25 - psql --cluster 14/127.0.0.1: defaults to port 5432 390s ok 26 - createdb --cluster 14/127.0.0.1:5432 --version 390s ok 27 - createdb --cluster 14/127.0.0.1:5432 uses latest client version 391s ok 28 - psql -Atl --cluster 14/localhost:5434 391s ok 29 - test db appears in cluster 14/localhost:5434 391s ok 30 - psql -Atl --cluster 14/localhost:5440 391s ok 31 - test db does not appear in cluster 14/localhost:5440 391s ok 32 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:5435 391s ok 33 - psql --cluster 14/localhost:5435 fails due to nonexisting port 391s ok 34 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:a 391s ok 35 - psql --cluster 14/localhost:a fails due to invalid syntax 391s ok 36 - LC_MESSAGES=C psql -Atl --cluster 14/doesnotexi.st 391s ok 37 - psql --cluster 14/doesnotexi.st fails due to invalid syntax 391s ok 38 - psql -Atl --cluster 6.4/localhost: 391s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 391s ok 40 - psql -Atl 391s ok 41 - PGCLUSTER selection (1) 391s ok 42 - psql -Atl 391s ok 43 - PGCLUSTER selection (2) 391s ok 44 - psql -l 391s ok 45 - invalid PGCLUSTER value 391s ok 46 - createdb --version 391s ok 47 - PGCLUSTER network cluster selection (1) 391s ok 48 - psql -Atl 391s ok 49 - PGCLUSTER network cluster selection (2) 391s ok 50 - psql -Atl 391s ok 51 - PGCLUSTER network cluster selection (3) 391s ok 52 - LC_MESSAGES=C psql -Atl 391s ok 53 - psql --cluster 14/localhost:5435 fails due to nonexisting port 391s ok 54 - psql -Atc "show port" template1 391s ok 55 - PGPORT selection (1) 391s ok 56 - psql -Atc "show port" template1 391s ok 57 - PGPORT selection (2) 391s ok 58 - createdb --version 391s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 391s ok 60 - psql -Atc "show port" template1 391s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 391s ok 62 - psql --cluster 14/new1 -Atc 'select current_database()' 391s ok 63 - PGDATABASE environment variable works 391s ok 64 - createdb --version 391s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 391s ok 66 - createdb --cluster 14/new1 --version 391s ok 67 - pg_wrapper --cluster works with empty user_clusters 391s ok 68 - createdb --version 391s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 14 new1 *' 391s ok 70 - psql -Atc "select current_database()" 391s ok 71 - pg_wrapper selects correct database with user_clusters '* * 14 new1 test' 391s ok 72 - psql -Atc 'select current_database()' 391s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 391s ok 74 - createdb --version 391s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 391s ok 76 - createdb --version 391s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 391s ok 78 - createdb --version 391s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 392s ok 80 - createdb --version 392s ok 81 - pg_wrapper selects correct version with per-user user_clusters 392s ok 82 - createdb --version 392s ok 83 - pg_wrapper selects correct version with per-user user_clusters 392s ok 84 - createdb --version 392s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 392s ok 86 - psql -Atl 392s ok 87 - $PGHOST overrides user_clusters 392s ok 88 - psql --cluster 14/localhost:5434 -Atc 'select current_database()' test 392s ok 89 - --cluster overrides $PGHOST 392s ok 90 - createdb --version 392s ok 91 - pg_wrapper ignores invalid lines in user_clusters 392s ok 92 - psql -Atc 'select current_database()' 392s ok 93 - pg_service conf selection 1 392s ok 94 - psql -Atc 'select current_database()' 392s ok 95 - pg_service conf selection 2 392s ok 96 - psql -Atc 'select current_database()' 392s ok 97 - pg_service conf selection 3 392s ok 98 - stopping cluster 14/old 394s ok 99 - restarting cluster 14/old 394s ok 100 - pg_lsclusters -h | sort -k3 394s ok 101 - port of first cluster was successfully changed 394s ok 102 - psql -l 394s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 394s ok 104 - psql -Atl --cluster 14/new1 394s ok 105 - --cluster selects appropriate cluster 394s ok 106 - psql -Atl -p 5434 394s ok 107 - -p selects appropriate cluster 394s ok 108 - psql -Atlp 5434 394s ok 109 - -Atlp selects appropriate cluster 395s ok 110 - psql -Atl --port 5434 395s ok 111 - --port selects appropriate cluster 395s ok 112 - env PGPORT=5434 psql -Atl 395s ok 113 - $PGPORT selects appropriate cluster 395s ok 114 - Restoring original /etc/postgresql-common/user_clusters 396s ok 115 - dropping 14/new1 397s ok 116 - dropping 14/new2 398s ok 117 - dropping 14/old 398s # Cleanup 398s ok 118 - Cleanup: No clusters left behind 398s ok 119 - No postgres processes left behind 398s ok 120 - No files in /etc/postgresql left behind 398s ok 121 - No files in /var/lib/postgresql left behind 398s ok 122 - No files in /var/run/postgresql left behind 398s ok 123 - No files in /var/log/postgresql left behind 398s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 398s ok 125 - PostgreSQL TCP ports are closed 398s === Running test 100_upgrade_scripts.t ... === 399s 1..27 402s ok 1 - pg_createcluster 14 main 402s ok 2 - createdb --cluster 14/main db1 402s ok 3 - correct output of createdb --cluster 14/main db1 402s ok 4 - createdb --cluster 14/main db2 402s ok 5 - correct output of createdb --cluster 14/main db2 402s ok 6 - psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 402s ok 7 - correct output of psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 402s ok 8 - get_cluster_databases() works 402s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 404s ok 10 - run-upgrade-scripts succeeds 404s ok 11 - correct run-upgrade-script output 404s ok 12 - psql --cluster 14/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 404s ok 13 - check SQL scripts results in 14/main db1 404s ok 14 - psql --cluster 14/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 404s ok 15 - check SQL scripts results in 14/main db2 404s ok 16 - psql --cluster 14/main db1 -Atc 'select * from log order by str' 404s ok 17 - check shell scripts results in $v/main 404s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 405s ok 19 - pg_dropcluster 14 main 405s # Cleanup 405s ok 20 - Cleanup: No clusters left behind 405s ok 21 - No postgres processes left behind 405s ok 22 - No files in /etc/postgresql left behind 405s ok 23 - No files in /var/lib/postgresql left behind 405s ok 24 - No files in /var/run/postgresql left behind 405s ok 25 - No files in /var/log/postgresql left behind 405s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 405s ok 27 - PostgreSQL TCP ports are closed 405s === Running test 110_integrate_cluster.t ... === 405s 1..32 406s ok 1 - /usr/lib/postgresql/14/bin/initdb /tmp/naBkH6KN9O/c/postgres 406s ok 2 - creating raw initdb cluster for user postgres 406s ok 3 - pg_createcluster 14 postgres -d /tmp/naBkH6KN9O/c/postgres 406s ok 4 - integrating postgres cluster 406s ok 5 - pg_lsclusters 406s ok 6 - correct pg_lsclusters output 409s ok 7 - pg_ctlcluster 14 postgres start 409s ok 8 - starting cluster postgres 409s ok 9 - pg_lsclusters 409s ok 10 - correct pg_lsclusters output 410s ok 11 - dropping cluster postgres 410s ok 12 - No files in temporary cluster dir left behind 411s ok 13 - /usr/lib/postgresql/14/bin/initdb /tmp/naBkH6KN9O/c/nobody 411s ok 14 - creating raw initdb cluster for user nobody 411s ok 15 - pg_createcluster 14 nobody -d /tmp/naBkH6KN9O/c/nobody 411s ok 16 - integrating nobody cluster 411s ok 17 - pg_lsclusters 411s ok 18 - correct pg_lsclusters output 413s ok 19 - pg_ctlcluster 14 nobody start 413s ok 20 - starting cluster nobody 413s ok 21 - pg_lsclusters 413s ok 22 - correct pg_lsclusters output 415s ok 23 - dropping cluster nobody 415s ok 24 - No files in temporary cluster dir left behind 415s # Cleanup 415s ok 25 - Cleanup: No clusters left behind 415s ok 26 - No postgres processes left behind 415s ok 27 - No files in /etc/postgresql left behind 415s ok 28 - No files in /var/lib/postgresql left behind 415s ok 29 - No files in /var/run/postgresql left behind 415s ok 30 - No files in /var/log/postgresql left behind 415s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 415s ok 32 - PostgreSQL TCP ports are closed 415s === Running test 120_pg_upgradecluster_scripts.t ... === 415s 1..1 415s ok 1 - only one major version installed, skipping upgrade tests 415s === Running test 130_nonroot_admin.t ... === 415s 1..22 418s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 418s ok 2 - pg_lsclusters -h 418s ok 3 - correct output of pg_lsclusters -h 418s ok 4 - psql -Atl 418s ok 5 - correct output of psql -Atl 418s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 418s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 418s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 418s # Cleanup 418s ok 15 - Cleanup: No clusters left behind 418s ok 16 - No postgres processes left behind 418s ok 17 - No files in /etc/postgresql left behind 418s ok 18 - No files in /var/lib/postgresql left behind 418s ok 19 - No files in /var/run/postgresql left behind 418s ok 20 - No files in /var/log/postgresql left behind 418s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 418s ok 22 - PostgreSQL TCP ports are closed 418s === Running test 135_pg_virtualenv.t ... === 418s 1..20 423s ok 1 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 423s ok 2 - running pg_virtualenv as root 426s ok 3 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 426s ok 4 - running pg_virtualenv as postgres 429s ok 5 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 429s ok 6 - running pg_virtualenv as nobody 429s ok 7 # skip /usr/bin/fakeroot not available 429s ok 8 # skip /usr/bin/fakeroot not available 429s ok 9 # skip /usr/bin/fakeroot not available 429s ok 10 # skip /usr/bin/fakeroot not available 429s ok 11 # skip /usr/bin/fakeroot not available 429s ok 12 # skip /usr/bin/fakeroot not available 429s # Cleanup 429s ok 13 - Cleanup: No clusters left behind 429s ok 14 - No postgres processes left behind 429s ok 15 - No files in /etc/postgresql left behind 429s ok 16 - No files in /var/lib/postgresql left behind 429s ok 17 - No files in /var/run/postgresql left behind 429s ok 18 - No files in /var/log/postgresql left behind 429s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 429s ok 20 - PostgreSQL TCP ports are closed 429s === Running test 140_pg_config.t ... === 429s 1..38 429s # Multiarch is enabled 429s # checking version specific output for 14 429s ok 1 - /usr/lib/postgresql/14/bin/pg_config --pgxs 429s ok 2 - correct output of /usr/lib/postgresql/14/bin/pg_config --pgxs 429s ok 3 - /usr/lib/postgresql/14/bin/pg_config --libdir 429s ok 4 - correct output of /usr/lib/postgresql/14/bin/pg_config --libdir 429s ok 5 - /usr/lib/postgresql/14/bin/pg_config --pkglibdir 429s ok 6 - correct output of /usr/lib/postgresql/14/bin/pg_config --pkglibdir 429s ok 7 - /usr/lib/postgresql/14/bin/pg_config --bindir 429s ok 8 - correct output of /usr/lib/postgresql/14/bin/pg_config --bindir 429s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 429s # checking pg_config output (should behave like version 14) 429s ok 15 - pg_config 429s ok 16 - correct output of pg_config 429s ok 17 - pg_config --help 429s ok 18 - correct output of pg_config --help 429s ok 19 - pg_config --pgxs 429s ok 20 - correct output of pg_config --pgxs 429s ok 21 - pg_config --libdir 429s ok 22 - correct output of pg_config --libdir 429s ok 23 - pg_config --pkglibdir 429s ok 24 - correct output of pg_config --pkglibdir 429s ok 25 - pg_config --bindir 429s ok 26 - correct output of pg_config --bindir 429s # checking pg_config.libpq-dev output (should behave like version 14) 429s ok 27 - pg_config.libpq-dev 429s ok 28 - correct output of pg_config.libpq-dev 429s ok 29 - pg_config.libpq-dev --help 429s ok 30 - correct output of pg_config.libpq-dev --help 429s ok 31 - pg_config.libpq-dev --pgxs 429s ok 32 - correct output of pg_config.libpq-dev --pgxs 429s ok 33 - pg_config.libpq-dev --libdir 429s ok 34 - correct output of pg_config.libpq-dev --libdir 429s ok 35 - pg_config.libpq-dev --pkglibdir 429s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 429s ok 37 - pg_config.libpq-dev --bindir 429s ok 38 - correct output of pg_config.libpq-dev --bindir 429s === Running test 150_tsearch_stemming.t ... === 429s 1..37 429s ok 1 - pg_updatedicts succeeded 429s ok 2 - pg_updatedicts created en_us.affix 429s ok 3 - pg_updatedicts created en_us.dict 429s ok 4 - pg_updatedicts created 14 en_us.affix symlink 429s ok 5 - pg_updatedicts created 14 en_us.dict symlink 433s ok 6 - pg_createcluster 14 main 433s ok 7 - createdb fts 433s ok 8 - correct output of createdb fts 433s ok 9 - creating en_US full text search configuration 433s ok 10 - creating data table and search index 433s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 433s ok 12 - stem search of correct word 433s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 433s ok 14 - stem search of correct word 433s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 433s ok 16 - stem search of unknown word 433s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 433s ok 18 - full text search, exact word 433s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 433s ok 20 - full text search for word stem 433s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 433s ok 22 - full text search for word substring fails 433s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 433s ok 24 - full text search, exact unicode word 433s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 433s ok 26 - full text search for unicode word stem 434s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 434s ok 28 - full text search for unicode word substring fails 435s ok 29 435s # Cleanup 435s ok 30 - Cleanup: No clusters left behind 435s ok 31 - No postgres processes left behind 435s ok 32 - No files in /etc/postgresql left behind 435s ok 33 - No files in /var/lib/postgresql left behind 435s ok 34 - No files in /var/run/postgresql left behind 435s ok 35 - No files in /var/log/postgresql left behind 435s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 435s ok 37 - PostgreSQL TCP ports are closed 435s === Running test 160_alternate_confroot.t ... === 435s 1..28 438s ok 1 438s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 438s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 438s ok 4 - pg_lsclusters -h 438s ok 5 - correct output of pg_lsclusters -h 438s ok 6 - psql -Atl 438s ok 7 - correct output of psql -Atl 438s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 438s ok 9 - ... 438s ok 10 - ... 438s ok 11 - ... 438s ok 12 - ... 438s ok 13 - ... 438s ok 14 - ... 438s ok 15 - pg_dropcluster 14 test --stop 438s ok 16 - correct output of pg_dropcluster 14 test --stop 438s ok 17 - pg_lsclusters -h 438s ok 18 - correct output of pg_lsclusters -h 438s ok 19 - No files in root/data left behind 438s ok 20 - No cruft in root dir left behind 438s # Cleanup 438s ok 21 - Cleanup: No clusters left behind 438s ok 22 - No postgres processes left behind 438s ok 23 - No files in /etc/postgresql left behind 438s ok 24 - No files in /var/lib/postgresql left behind 438s ok 25 - No files in /var/run/postgresql left behind 438s ok 26 - No files in /var/log/postgresql left behind 438s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 438s ok 28 - PostgreSQL TCP ports are closed 438s === Running test 170_extensions.t ... === 438s # Running tests for 14 442s ok 1 - pg_createcluster 14 main 442s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 442s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 442s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 442s ok 5 - extension adminpack installs without error 442s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 442s ok 7 - extension adminpack removes without error 442s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 442s ok 9 - extension amcheck installs without error 442s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 442s ok 11 - extension amcheck removes without error 442s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 442s ok 13 - extension autoinc installs without error 442s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 442s ok 15 - extension autoinc removes without error 442s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 442s ok 17 - extension bloom installs without error 442s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 442s ok 19 - extension bloom removes without error 442s ok 20 - psql -qc 'CREATE EXTENSION plperl' 442s ok 21 - bool_plperl dependency plperl installs without error 442s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 442s ok 23 - extension bool_plperl installs without error 442s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 442s ok 25 - extension bool_plperl removes without error 442s ok 26 - psql -qc 'DROP EXTENSION plperl' 442s ok 27 - bool_plperl dependency extension plperl removes without error 442s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 442s ok 29 - bool_plperlu dependency plperlu installs without error 442s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 442s ok 31 - extension bool_plperlu installs without error 442s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 442s ok 33 - extension bool_plperlu removes without error 442s ok 34 - psql -qc 'DROP EXTENSION plperlu' 442s ok 35 - bool_plperlu dependency extension plperlu removes without error 442s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 442s ok 37 - extension btree_gin installs without error 442s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 442s ok 39 - extension btree_gin removes without error 443s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 443s ok 41 - extension btree_gist installs without error 443s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 443s ok 43 - extension btree_gist removes without error 443s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 443s ok 45 - extension citext installs without error 443s ok 46 - psql -qc 'DROP EXTENSION "citext"' 443s ok 47 - extension citext removes without error 443s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 443s ok 49 - extension cube installs without error 443s ok 50 - psql -qc 'DROP EXTENSION "cube"' 443s ok 51 - extension cube removes without error 443s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 443s ok 53 - extension dblink installs without error 443s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 443s ok 55 - extension dblink removes without error 443s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 443s ok 57 - extension dict_int installs without error 443s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 443s ok 59 - extension dict_int removes without error 443s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 443s ok 61 - extension dict_xsyn installs without error 443s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 443s ok 63 - extension dict_xsyn removes without error 443s ok 64 - psql -qc 'CREATE EXTENSION cube' 443s ok 65 - earthdistance dependency cube installs without error 443s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 443s ok 67 - extension earthdistance installs without error 443s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 443s ok 69 - extension earthdistance removes without error 443s ok 70 - psql -qc 'DROP EXTENSION cube' 443s ok 71 - earthdistance dependency extension cube removes without error 443s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 443s ok 73 - extension file_fdw installs without error 443s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 443s ok 75 - extension file_fdw removes without error 443s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 443s ok 77 - extension fuzzystrmatch installs without error 443s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 443s ok 79 - extension fuzzystrmatch removes without error 443s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 443s ok 81 - extension hstore installs without error 443s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 443s ok 83 - extension hstore removes without error 443s ok 84 - psql -qc 'CREATE EXTENSION hstore' 443s ok 85 - hstore_plperl dependency hstore installs without error 444s ok 86 - psql -qc 'CREATE EXTENSION plperl' 444s ok 87 - hstore_plperl dependency plperl installs without error 444s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 444s ok 89 - extension hstore_plperl installs without error 444s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 444s ok 91 - extension hstore_plperl removes without error 444s ok 92 - psql -qc 'DROP EXTENSION hstore' 444s ok 93 - hstore_plperl dependency extension hstore removes without error 444s ok 94 - psql -qc 'DROP EXTENSION plperl' 444s ok 95 - hstore_plperl dependency extension plperl removes without error 444s ok 96 - psql -qc 'CREATE EXTENSION hstore' 444s ok 97 - hstore_plperlu dependency hstore installs without error 444s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 444s ok 99 - hstore_plperlu dependency plperlu installs without error 444s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 444s ok 101 - extension hstore_plperlu installs without error 444s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 444s ok 103 - extension hstore_plperlu removes without error 444s ok 104 - psql -qc 'DROP EXTENSION hstore' 444s ok 105 - hstore_plperlu dependency extension hstore removes without error 444s ok 106 - psql -qc 'DROP EXTENSION plperlu' 444s ok 107 - hstore_plperlu dependency extension plperlu removes without error 444s ok 108 - psql -qc 'CREATE EXTENSION hstore' 444s ok 109 - hstore_plpython3u dependency hstore installs without error 444s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 444s ok 111 - hstore_plpython3u dependency plpython3u installs without error 444s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 444s ok 113 - extension hstore_plpython3u installs without error 444s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 444s ok 115 - extension hstore_plpython3u removes without error 444s ok 116 - psql -qc 'DROP EXTENSION hstore' 444s ok 117 - hstore_plpython3u dependency extension hstore removes without error 444s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 444s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 444s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 444s ok 121 - extension insert_username installs without error 444s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 444s ok 123 - extension insert_username removes without error 444s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 444s ok 125 - extension intagg installs without error 444s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 444s ok 127 - extension intagg removes without error 444s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 444s ok 129 - extension intarray installs without error 444s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 444s ok 131 - extension intarray removes without error 445s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 445s ok 133 - extension isn installs without error 445s ok 134 - psql -qc 'DROP EXTENSION "isn"' 445s ok 135 - extension isn removes without error 445s ok 136 - psql -qc 'CREATE EXTENSION plperl' 445s ok 137 - jsonb_plperl dependency plperl installs without error 445s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 445s ok 139 - extension jsonb_plperl installs without error 445s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 445s ok 141 - extension jsonb_plperl removes without error 445s ok 142 - psql -qc 'DROP EXTENSION plperl' 445s ok 143 - jsonb_plperl dependency extension plperl removes without error 445s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 445s ok 145 - jsonb_plperlu dependency plperlu installs without error 445s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 445s ok 147 - extension jsonb_plperlu installs without error 445s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 445s ok 149 - extension jsonb_plperlu removes without error 445s ok 150 - psql -qc 'DROP EXTENSION plperlu' 445s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 445s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 445s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 445s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 445s ok 155 - extension jsonb_plpython3u installs without error 445s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 445s ok 157 - extension jsonb_plpython3u removes without error 445s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 445s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 445s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 445s ok 161 - extension lo installs without error 445s ok 162 - psql -qc 'DROP EXTENSION "lo"' 445s ok 163 - extension lo removes without error 445s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 445s ok 165 - extension ltree installs without error 445s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 445s ok 167 - extension ltree removes without error 445s ok 168 - psql -qc 'CREATE EXTENSION ltree' 445s ok 169 - ltree_plpython3u dependency ltree installs without error 445s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 445s ok 171 - ltree_plpython3u dependency plpython3u installs without error 445s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 445s ok 173 - extension ltree_plpython3u installs without error 445s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 445s ok 175 - extension ltree_plpython3u removes without error 446s ok 176 - psql -qc 'DROP EXTENSION ltree' 446s ok 177 - ltree_plpython3u dependency extension ltree removes without error 446s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 446s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 446s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 446s ok 181 - extension moddatetime installs without error 446s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 446s ok 183 - extension moddatetime removes without error 446s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 446s ok 185 - extension old_snapshot installs without error 446s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 446s ok 187 - extension old_snapshot removes without error 446s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 446s ok 189 - extension pageinspect installs without error 446s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 446s ok 191 - extension pageinspect removes without error 446s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 446s ok 193 - extension pg_buffercache installs without error 446s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 446s ok 195 - extension pg_buffercache removes without error 446s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 446s ok 197 - extension pg_freespacemap installs without error 446s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 446s ok 199 - extension pg_freespacemap removes without error 446s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 446s ok 201 - extension pg_prewarm installs without error 446s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 446s ok 203 - extension pg_prewarm removes without error 446s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 446s ok 205 - extension pg_stat_statements installs without error 446s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 446s ok 207 - extension pg_stat_statements removes without error 446s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 446s ok 209 - extension pg_surgery installs without error 446s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 446s ok 211 - extension pg_surgery removes without error 446s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 446s ok 213 - extension pg_trgm installs without error 446s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 446s ok 215 - extension pg_trgm removes without error 446s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 446s ok 217 - extension pg_visibility installs without error 446s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 446s ok 219 - extension pg_visibility removes without error 446s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 446s ok 221 - extension pgcrypto installs without error 447s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 447s ok 223 - extension pgcrypto removes without error 447s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 447s ok 225 - extension pgrowlocks installs without error 447s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 447s ok 227 - extension pgrowlocks removes without error 447s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 447s ok 229 - extension pgstattuple installs without error 447s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 447s ok 231 - extension pgstattuple removes without error 447s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 447s ok 233 - extension plperl installs without error 447s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 447s ok 235 - extension plperl removes without error 447s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 447s ok 237 - extension plperlu installs without error 447s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 447s ok 239 - extension plperlu removes without error 447s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 447s ok 241 - extension plpython3u installs without error 447s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 447s ok 243 - extension plpython3u removes without error 447s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 447s ok 245 - extension pltcl installs without error 447s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 447s ok 247 - extension pltcl removes without error 447s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 447s ok 249 - extension pltclu installs without error 447s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 447s ok 251 - extension pltclu removes without error 447s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 447s ok 253 - extension postgres_fdw installs without error 447s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 447s ok 255 - extension postgres_fdw removes without error 447s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 447s ok 257 - extension refint installs without error 447s ok 258 - psql -qc 'DROP EXTENSION "refint"' 447s ok 259 - extension refint removes without error 447s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 447s ok 261 - extension seg installs without error 447s ok 262 - psql -qc 'DROP EXTENSION "seg"' 447s ok 263 - extension seg removes without error 447s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 447s ok 265 - extension sslinfo installs without error 447s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 447s ok 267 - extension sslinfo removes without error 448s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 448s ok 269 - extension tablefunc installs without error 448s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 448s ok 271 - extension tablefunc removes without error 448s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 448s ok 273 - extension tcn installs without error 448s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 448s ok 275 - extension tcn removes without error 448s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 448s ok 277 - extension tsm_system_rows installs without error 448s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 448s ok 279 - extension tsm_system_rows removes without error 448s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 448s ok 281 - extension tsm_system_time installs without error 448s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 448s ok 283 - extension tsm_system_time removes without error 448s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 448s ok 285 - extension unaccent installs without error 448s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 448s ok 287 - extension unaccent removes without error 448s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 448s ok 289 - extension uuid-ossp installs without error 448s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 448s ok 291 - extension uuid-ossp removes without error 448s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 448s ok 293 - extension xml2 installs without error 448s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 448s ok 295 - extension xml2 removes without error 449s ok 296 - pg_dropcluster 14 main 449s # Cleanup 449s ok 297 - Cleanup: No clusters left behind 449s ok 298 - No postgres processes left behind 449s ok 299 - No files in /etc/postgresql left behind 449s ok 300 - No files in /var/lib/postgresql left behind 449s ok 301 - No files in /var/run/postgresql left behind 449s ok 302 - No files in /var/log/postgresql left behind 449s ok 303 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 449s ok 304 - PostgreSQL TCP ports are closed 449s 1..304 449s === Running test 180_ecpg.t ... === 449s 1..14 449s ok 1 - ecpg test.pgc 449s ok 2 - ecpg processing 450s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 450s ok 4 - compiling ecpg output 457s ok 5 - pg_virtualenv /tmp/tmp.b2qYeioEl1/test 457s ok 6 - test program runs and gives correct output 457s # Cleanup 457s ok 7 - Cleanup: No clusters left behind 457s ok 8 - No postgres processes left behind 457s ok 9 - No files in /etc/postgresql left behind 457s ok 10 - No files in /var/lib/postgresql left behind 457s ok 11 - No files in /var/run/postgresql left behind 457s ok 12 - No files in /var/log/postgresql left behind 457s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 457s ok 14 - PostgreSQL TCP ports are closed 457s === Running test 190_pg_buildext.t ... === 457s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 457s 1..1 457s autopkgtest [13:23:07]: test run-testsuite: -----------------------] 458s autopkgtest [13:23:08]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 458s run-testsuite PASS 458s autopkgtest [13:23:08]: test installcheck: preparing testbed 556s autopkgtest [13:24:46]: testbed dpkg architecture: arm64 557s autopkgtest [13:24:47]: testbed apt version: 2.4.13 557s autopkgtest [13:24:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 557s autopkgtest [13:24:47]: testbed release detected to be: jammy 558s autopkgtest [13:24:48]: updating testbed package index (apt update) 558s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 558s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 558s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 559s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 559s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 559s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 559s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 559s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 559s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 Packages [319 kB] 559s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 c-n-f Metadata [1748 B] 559s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted arm64 Packages [456 kB] 559s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted arm64 c-n-f Metadata [412 B] 559s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe arm64 Packages [115 kB] 559s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe arm64 c-n-f Metadata [1308 B] 559s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse arm64 Packages [9504 B] 559s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse arm64 c-n-f Metadata [208 B] 561s Fetched 1339 kB in 1s (1094 kB/s) 563s Reading package lists... 563s Reading package lists... 564s Building dependency tree... 564s Reading state information... 564s Calculating upgrade... 565s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 565s Reading package lists... 565s Building dependency tree... 565s Reading state information... 566s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 566s autopkgtest [13:24:56]: upgrading testbed (apt dist-upgrade and autopurge) 567s Reading package lists... 567s Building dependency tree... 567s Reading state information... 568s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 569s Starting 2 pkgProblemResolver with broken count: 0 569s Done 570s Entering ResolveByKeep 570s 570s The following packages will be upgraded: 570s tzdata 570s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 570s Need to get 347 kB of archives. 570s After this operation, 4096 B of additional disk space will be used. 570s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main arm64 tzdata all 2025a-0ubuntu0.22.04 [347 kB] 571s Preconfiguring packages ... 571s Fetched 347 kB in 0s (841 kB/s) 572s (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 ... 70618 files and directories currently installed.) 572s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 572s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 572s Setting up tzdata (2025a-0ubuntu0.22.04) ... 572s 572s Current default time zone: 'Etc/UTC' 572s Local time is now: Wed Feb 26 13:25:02 UTC 2025. 572s Universal Time is now: Wed Feb 26 13:25:02 UTC 2025. 572s Run 'dpkg-reconfigure tzdata' if you wish to change it. 572s 573s Reading package lists... 573s Building dependency tree... 573s Reading state information... 574s Starting pkgProblemResolver with broken count: 0 574s Starting 2 pkgProblemResolver with broken count: 0 574s Done 576s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 579s Reading package lists... 579s Building dependency tree... 579s Reading state information... 579s Starting pkgProblemResolver with broken count: 0 579s Starting 2 pkgProblemResolver with broken count: 0 579s Done 580s The following NEW packages will be installed: 580s build-essential clang-14 cpp cpp-11 g++ g++-11 gcc gcc-11 gcc-11-base 580s icu-devtools libasan6 libatomic1 libc-dev-bin libc6-dev libcc1-0 580s libclang-common-14-dev libclang-cpp14 libclang1-14 libcrypt-dev 580s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1 libgcc-11-dev 580s libgomp1 libhwasan0 libicu-dev libisl23 libitm1 libjson-perl libllvm14 580s liblsan0 libmpc3 libncurses-dev libnsl-dev libobjc-11-dev libobjc4 libpfm4 580s libpgtypes3 libpq-dev libpq5 libpython3.10 libssl-dev libstdc++-11-dev 580s libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev libxslt1.1 libz3-4 580s libz3-dev linux-libc-dev llvm-14 llvm-14-dev llvm-14-linker-tools 580s llvm-14-runtime llvm-14-tools postgresql-14 postgresql-client-14 580s postgresql-client-common postgresql-common postgresql-doc-14 580s postgresql-plperl-14 postgresql-plpython3-14 postgresql-pltcl-14 580s postgresql-server-dev-14 python3-pygments rpcsvc-proto ssl-cert 580s 0 upgraded, 71 newly installed, 0 to remove and 0 not upgraded. 580s Need to get 196 MB of archives. 580s After this operation, 916 MB of additional disk space will be used. 580s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libc-dev-bin arm64 2.35-0ubuntu3.9 [19.6 kB] 581s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 linux-libc-dev arm64 5.15.0-133.144 [1274 kB] 581s Get:3 http://ftpmaster.internal/ubuntu jammy/main arm64 libcrypt-dev arm64 1:4.4.27-1 [119 kB] 581s Get:4 http://ftpmaster.internal/ubuntu jammy/main arm64 rpcsvc-proto arm64 1.4.2-0ubuntu6 [65.4 kB] 581s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtirpc-dev arm64 1.3.2-2ubuntu0.1 [199 kB] 581s Get:6 http://ftpmaster.internal/ubuntu jammy/main arm64 libnsl-dev arm64 1.3.0-2build2 [72.1 kB] 581s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libc6-dev arm64 2.35-0ubuntu3.9 [1544 kB] 581s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 gcc-11-base arm64 11.4.0-1ubuntu1~22.04 [20.3 kB] 581s Get:9 http://ftpmaster.internal/ubuntu jammy/main arm64 libisl23 arm64 0.24-2build1 [689 kB] 581s Get:10 http://ftpmaster.internal/ubuntu jammy/main arm64 libmpc3 arm64 1.2.1-2build1 [48.1 kB] 581s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 cpp-11 arm64 11.4.0-1ubuntu1~22.04 [9762 kB] 582s Get:12 http://ftpmaster.internal/ubuntu jammy/main arm64 cpp arm64 4:11.2.0-1ubuntu1 [27.7 kB] 582s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libcc1-0 arm64 12.3.0-1ubuntu1~22.04 [45.0 kB] 582s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libgomp1 arm64 12.3.0-1ubuntu1~22.04 [124 kB] 582s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libitm1 arm64 12.3.0-1ubuntu1~22.04 [28.4 kB] 582s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libatomic1 arm64 12.3.0-1ubuntu1~22.04 [10.8 kB] 582s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libasan6 arm64 11.4.0-1ubuntu1~22.04 [2234 kB] 582s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 liblsan0 arm64 12.3.0-1ubuntu1~22.04 [1035 kB] 582s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtsan0 arm64 11.4.0-1ubuntu1~22.04 [2235 kB] 583s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libubsan1 arm64 12.3.0-1ubuntu1~22.04 [965 kB] 583s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libhwasan0 arm64 12.3.0-1ubuntu1~22.04 [1117 kB] 583s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libgcc-11-dev arm64 11.4.0-1ubuntu1~22.04 [1146 kB] 583s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 gcc-11 arm64 11.4.0-1ubuntu1~22.04 [19.4 MB] 583s Get:24 http://ftpmaster.internal/ubuntu jammy/main arm64 gcc arm64 4:11.2.0-1ubuntu1 [5128 B] 583s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libstdc++-11-dev arm64 11.4.0-1ubuntu1~22.04 [2088 kB] 583s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 g++-11 arm64 11.4.0-1ubuntu1~22.04 [11.1 MB] 584s Get:27 http://ftpmaster.internal/ubuntu jammy/main arm64 g++ arm64 4:11.2.0-1ubuntu1 [1394 B] 584s Get:28 http://ftpmaster.internal/ubuntu jammy/main arm64 build-essential arm64 12.9ubuntu3 [4740 B] 584s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libllvm14 arm64 1:14.0.0-1ubuntu1.1 [22.6 MB] 585s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang-cpp14 arm64 1:14.0.0-1ubuntu1.1 [11.5 MB] 585s Get:31 http://ftpmaster.internal/ubuntu jammy/main arm64 libgc1 arm64 1:8.0.6-1.1build1 [94.2 kB] 585s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libobjc4 arm64 12.3.0-1ubuntu1~22.04 [46.8 kB] 585s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libobjc-11-dev arm64 11.4.0-1ubuntu1~22.04 [192 kB] 585s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang-common-14-dev arm64 1:14.0.0-1ubuntu1.1 [4488 kB] 585s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-linker-tools arm64 1:14.0.0-1ubuntu1.1 [1237 kB] 585s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 libclang1-14 arm64 1:14.0.0-1ubuntu1.1 [6470 kB] 585s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 clang-14 arm64 1:14.0.0-1ubuntu1.1 [77.5 kB] 585s Get:38 http://ftpmaster.internal/ubuntu jammy/main arm64 icu-devtools arm64 70.1-2 [193 kB] 585s Get:39 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpgtypes3 arm64 14.15-0ubuntu0.22.04.1 [47.2 kB] 585s Get:40 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpq5 arm64 14.15-0ubuntu0.22.04.1 [145 kB] 586s Get:41 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg6 arm64 14.15-0ubuntu0.22.04.1 [43.2 kB] 586s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg-compat3 arm64 14.15-0ubuntu0.22.04.1 [13.1 kB] 586s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libssl-dev arm64 3.0.2-0ubuntu1.19 [2299 kB] 586s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpq-dev arm64 14.15-0ubuntu0.22.04.1 [148 kB] 586s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libecpg-dev arm64 14.15-0ubuntu0.22.04.1 [258 kB] 586s Get:46 http://ftpmaster.internal/ubuntu jammy/main arm64 libicu-dev arm64 70.1-2 [11.6 MB] 586s Get:47 http://ftpmaster.internal/ubuntu jammy/main arm64 libjson-perl all 4.04000-1 [81.8 kB] 586s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libncurses-dev arm64 6.3-2ubuntu0.1 [381 kB] 586s Get:49 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpython3.10 arm64 3.10.12-1~22.04.9 [1888 kB] 586s Get:50 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libtinfo-dev arm64 6.3-2ubuntu0.1 [780 B] 586s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libxml2-dev arm64 2.9.13+dfsg-1ubuntu0.6 [804 kB] 586s Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.22.04.1 [160 kB] 586s Get:53 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-runtime arm64 1:14.0.0-1ubuntu1.1 [456 kB] 586s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 libpfm4 arm64 4.11.1+git32-gd0b85fb-1ubuntu0.1 [50.4 kB] 586s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14 arm64 1:14.0.0-1ubuntu1.1 [11.5 MB] 586s Get:56 http://ftpmaster.internal/ubuntu jammy/main arm64 libffi-dev arm64 3.4.2-4 [61.0 kB] 586s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 586s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-tools arm64 1:14.0.0-1ubuntu1.1 [395 kB] 586s Get:59 http://ftpmaster.internal/ubuntu jammy/universe arm64 libz3-4 arm64 4.8.12-1 [5352 kB] 587s Get:60 http://ftpmaster.internal/ubuntu jammy/universe arm64 libz3-dev arm64 4.8.12-1 [72.2 kB] 587s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 llvm-14-dev arm64 1:14.0.0-1ubuntu1.1 [36.3 MB] 588s Get:62 http://ftpmaster.internal/ubuntu jammy/main arm64 postgresql-client-common all 238 [29.6 kB] 588s Get:63 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-client-14 arm64 14.15-0ubuntu0.22.04.1 [1218 kB] 588s Get:64 http://ftpmaster.internal/ubuntu jammy/main arm64 ssl-cert all 1.1.2 [17.4 kB] 588s Get:65 http://ftpmaster.internal/ubuntu jammy/main arm64 postgresql-common all 238 [169 kB] 588s Get:66 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-14 arm64 14.15-0ubuntu0.22.04.1 [15.9 MB] 588s Get:67 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 588s Get:68 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-plperl-14 arm64 14.15-0ubuntu0.22.04.1 [73.4 kB] 588s Get:69 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-plpython3-14 arm64 14.15-0ubuntu0.22.04.1 [81.9 kB] 588s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main arm64 postgresql-pltcl-14 arm64 14.15-0ubuntu0.22.04.1 [34.8 kB] 588s Get:71 http://ftpmaster.internal/ubuntu jammy-updates/universe arm64 postgresql-server-dev-14 arm64 14.15-0ubuntu0.22.04.1 [1178 kB] 589s Preconfiguring packages ... 589s Fetched 196 MB in 8s (23.9 MB/s) 589s Selecting previously unselected package libc-dev-bin. 589s (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 ... 70619 files and directories currently installed.) 589s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_arm64.deb ... 589s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 589s Selecting previously unselected package linux-libc-dev:arm64. 589s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_arm64.deb ... 589s Unpacking linux-libc-dev:arm64 (5.15.0-133.144) ... 589s Selecting previously unselected package libcrypt-dev:arm64. 589s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_arm64.deb ... 589s Unpacking libcrypt-dev:arm64 (1:4.4.27-1) ... 589s Selecting previously unselected package rpcsvc-proto. 589s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_arm64.deb ... 589s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 589s Selecting previously unselected package libtirpc-dev:arm64. 589s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_arm64.deb ... 589s Unpacking libtirpc-dev:arm64 (1.3.2-2ubuntu0.1) ... 590s Selecting previously unselected package libnsl-dev:arm64. 590s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_arm64.deb ... 590s Unpacking libnsl-dev:arm64 (1.3.0-2build2) ... 590s Selecting previously unselected package libc6-dev:arm64. 590s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_arm64.deb ... 590s Unpacking libc6-dev:arm64 (2.35-0ubuntu3.9) ... 590s Selecting previously unselected package gcc-11-base:arm64. 590s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking gcc-11-base:arm64 (11.4.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libisl23:arm64. 590s Preparing to unpack .../08-libisl23_0.24-2build1_arm64.deb ... 590s Unpacking libisl23:arm64 (0.24-2build1) ... 590s Selecting previously unselected package libmpc3:arm64. 590s Preparing to unpack .../09-libmpc3_1.2.1-2build1_arm64.deb ... 590s Unpacking libmpc3:arm64 (1.2.1-2build1) ... 590s Selecting previously unselected package cpp-11. 590s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package cpp. 590s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_arm64.deb ... 590s Unpacking cpp (4:11.2.0-1ubuntu1) ... 590s Selecting previously unselected package libcc1-0:arm64. 590s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libcc1-0:arm64 (12.3.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libgomp1:arm64. 590s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libgomp1:arm64 (12.3.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libitm1:arm64. 590s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libitm1:arm64 (12.3.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libatomic1:arm64. 590s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libatomic1:arm64 (12.3.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libasan6:arm64. 590s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libasan6:arm64 (11.4.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package liblsan0:arm64. 590s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking liblsan0:arm64 (12.3.0-1ubuntu1~22.04) ... 590s Selecting previously unselected package libtsan0:arm64. 590s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_arm64.deb ... 590s Unpacking libtsan0:arm64 (11.4.0-1ubuntu1~22.04) ... 591s Selecting previously unselected package libubsan1:arm64. 591s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_arm64.deb ... 591s Unpacking libubsan1:arm64 (12.3.0-1ubuntu1~22.04) ... 591s Selecting previously unselected package libhwasan0:arm64. 591s Preparing to unpack .../20-libhwasan0_12.3.0-1ubuntu1~22.04_arm64.deb ... 591s Unpacking libhwasan0:arm64 (12.3.0-1ubuntu1~22.04) ... 591s Selecting previously unselected package libgcc-11-dev:arm64. 591s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 591s Unpacking libgcc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 591s Selecting previously unselected package gcc-11. 591s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 591s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 591s Selecting previously unselected package gcc. 591s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_arm64.deb ... 591s Unpacking gcc (4:11.2.0-1ubuntu1) ... 591s Selecting previously unselected package libstdc++-11-dev:arm64. 591s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 591s Unpacking libstdc++-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 592s Selecting previously unselected package g++-11. 592s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_arm64.deb ... 592s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 592s Selecting previously unselected package g++. 592s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_arm64.deb ... 592s Unpacking g++ (4:11.2.0-1ubuntu1) ... 592s Selecting previously unselected package build-essential. 592s Preparing to unpack .../27-build-essential_12.9ubuntu3_arm64.deb ... 592s Unpacking build-essential (12.9ubuntu3) ... 592s Selecting previously unselected package libllvm14:arm64. 592s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 592s Unpacking libllvm14:arm64 (1:14.0.0-1ubuntu1.1) ... 593s Selecting previously unselected package libclang-cpp14. 593s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 593s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 593s Selecting previously unselected package libgc1:arm64. 593s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_arm64.deb ... 593s Unpacking libgc1:arm64 (1:8.0.6-1.1build1) ... 593s Selecting previously unselected package libobjc4:arm64. 593s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_arm64.deb ... 593s Unpacking libobjc4:arm64 (12.3.0-1ubuntu1~22.04) ... 593s Selecting previously unselected package libobjc-11-dev:arm64. 593s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_arm64.deb ... 593s Unpacking libobjc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 593s Selecting previously unselected package libclang-common-14-dev. 593s Preparing to unpack .../33-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 593s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 594s Selecting previously unselected package llvm-14-linker-tools. 594s Preparing to unpack .../34-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 594s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 594s Selecting previously unselected package libclang1-14. 594s Preparing to unpack .../35-libclang1-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 594s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 594s Selecting previously unselected package clang-14. 594s Preparing to unpack .../36-clang-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 594s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 594s Selecting previously unselected package icu-devtools. 594s Preparing to unpack .../37-icu-devtools_70.1-2_arm64.deb ... 594s Unpacking icu-devtools (70.1-2) ... 594s Selecting previously unselected package libpgtypes3:arm64. 594s Preparing to unpack .../38-libpgtypes3_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libpgtypes3:arm64 (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libpq5:arm64. 594s Preparing to unpack .../39-libpq5_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libpq5:arm64 (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libecpg6:arm64. 594s Preparing to unpack .../40-libecpg6_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libecpg6:arm64 (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libecpg-compat3:arm64. 594s Preparing to unpack .../41-libecpg-compat3_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libecpg-compat3:arm64 (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libssl-dev:arm64. 594s Preparing to unpack .../42-libssl-dev_3.0.2-0ubuntu1.19_arm64.deb ... 594s Unpacking libssl-dev:arm64 (3.0.2-0ubuntu1.19) ... 594s Selecting previously unselected package libpq-dev. 594s Preparing to unpack .../43-libpq-dev_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libecpg-dev. 594s Preparing to unpack .../44-libecpg-dev_14.15-0ubuntu0.22.04.1_arm64.deb ... 594s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 594s Selecting previously unselected package libicu-dev:arm64. 594s Preparing to unpack .../45-libicu-dev_70.1-2_arm64.deb ... 594s Unpacking libicu-dev:arm64 (70.1-2) ... 595s Selecting previously unselected package libjson-perl. 595s Preparing to unpack .../46-libjson-perl_4.04000-1_all.deb ... 595s Unpacking libjson-perl (4.04000-1) ... 595s Selecting previously unselected package libncurses-dev:arm64. 595s Preparing to unpack .../47-libncurses-dev_6.3-2ubuntu0.1_arm64.deb ... 595s Unpacking libncurses-dev:arm64 (6.3-2ubuntu0.1) ... 595s Selecting previously unselected package libpython3.10:arm64. 595s Preparing to unpack .../48-libpython3.10_3.10.12-1~22.04.9_arm64.deb ... 595s Unpacking libpython3.10:arm64 (3.10.12-1~22.04.9) ... 595s Selecting previously unselected package libtinfo-dev:arm64. 595s Preparing to unpack .../49-libtinfo-dev_6.3-2ubuntu0.1_arm64.deb ... 595s Unpacking libtinfo-dev:arm64 (6.3-2ubuntu0.1) ... 595s Selecting previously unselected package libxml2-dev:arm64. 595s Preparing to unpack .../50-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_arm64.deb ... 595s Unpacking libxml2-dev:arm64 (2.9.13+dfsg-1ubuntu0.6) ... 595s Selecting previously unselected package libxslt1.1:arm64. 595s Preparing to unpack .../51-libxslt1.1_1.1.34-4ubuntu0.22.04.1_arm64.deb ... 595s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.22.04.1) ... 595s Selecting previously unselected package llvm-14-runtime. 595s Preparing to unpack .../52-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 595s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 595s Selecting previously unselected package libpfm4:arm64. 595s Preparing to unpack .../53-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_arm64.deb ... 595s Unpacking libpfm4:arm64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 595s Selecting previously unselected package llvm-14. 595s Preparing to unpack .../54-llvm-14_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 595s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 595s Selecting previously unselected package libffi-dev:arm64. 595s Preparing to unpack .../55-libffi-dev_3.4.2-4_arm64.deb ... 595s Unpacking libffi-dev:arm64 (3.4.2-4) ... 595s Selecting previously unselected package python3-pygments. 595s Preparing to unpack .../56-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 595s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 595s Selecting previously unselected package llvm-14-tools. 596s Preparing to unpack .../57-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 596s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 596s Selecting previously unselected package libz3-4:arm64. 596s Preparing to unpack .../58-libz3-4_4.8.12-1_arm64.deb ... 596s Unpacking libz3-4:arm64 (4.8.12-1) ... 596s Selecting previously unselected package libz3-dev:arm64. 596s Preparing to unpack .../59-libz3-dev_4.8.12-1_arm64.deb ... 596s Unpacking libz3-dev:arm64 (4.8.12-1) ... 596s Selecting previously unselected package llvm-14-dev. 596s Preparing to unpack .../60-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_arm64.deb ... 596s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 597s Selecting previously unselected package postgresql-client-common. 597s Preparing to unpack .../61-postgresql-client-common_238_all.deb ... 597s Unpacking postgresql-client-common (238) ... 598s Selecting previously unselected package postgresql-client-14. 598s Preparing to unpack .../62-postgresql-client-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 598s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 598s Selecting previously unselected package ssl-cert. 598s Preparing to unpack .../63-ssl-cert_1.1.2_all.deb ... 598s Unpacking ssl-cert (1.1.2) ... 598s Selecting previously unselected package postgresql-common. 598s Preparing to unpack .../64-postgresql-common_238_all.deb ... 598s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 598s Unpacking postgresql-common (238) ... 598s Selecting previously unselected package postgresql-14. 598s Preparing to unpack .../65-postgresql-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 598s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 598s Selecting previously unselected package postgresql-doc-14. 598s Preparing to unpack .../66-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 598s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 598s Selecting previously unselected package postgresql-plperl-14. 598s Preparing to unpack .../67-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 598s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 598s Selecting previously unselected package postgresql-plpython3-14. 598s Preparing to unpack .../68-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 598s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 598s Selecting previously unselected package postgresql-pltcl-14. 599s Preparing to unpack .../69-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 599s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 599s Selecting previously unselected package postgresql-server-dev-14. 599s Preparing to unpack .../70-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_arm64.deb ... 599s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 599s Setting up postgresql-client-common (238) ... 599s Setting up libpgtypes3:arm64 (14.15-0ubuntu0.22.04.1) ... 599s Setting up gcc-11-base:arm64 (11.4.0-1ubuntu1~22.04) ... 599s Setting up libpython3.10:arm64 (3.10.12-1~22.04.9) ... 599s Setting up libpq5:arm64 (14.15-0ubuntu0.22.04.1) ... 599s Setting up linux-libc-dev:arm64 (5.15.0-133.144) ... 599s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 599s update-alternatives: using /usr/share/postgresql/14/man/man3/SPI_connect.3.gz to provide /usr/share/man/man3/SPI_connect.3.gz (SPI_connect.3.gz) in auto mode 599s Setting up libgomp1:arm64 (12.3.0-1ubuntu1~22.04) ... 599s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 600s update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 600s Setting up libffi-dev:arm64 (3.4.2-4) ... 600s Setting up libasan6:arm64 (11.4.0-1ubuntu1~22.04) ... 600s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 601s Setting up libz3-4:arm64 (4.8.12-1) ... 601s Setting up libtirpc-dev:arm64 (1.3.2-2ubuntu0.1) ... 601s Setting up libpfm4:arm64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 601s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 601s Setting up ssl-cert (1.1.2) ... 602s Setting up libssl-dev:arm64 (3.0.2-0ubuntu1.19) ... 602s Setting up libmpc3:arm64 (1.2.1-2build1) ... 602s Setting up libatomic1:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up icu-devtools (70.1-2) ... 602s Setting up libgc1:arm64 (1:8.0.6-1.1build1) ... 602s Setting up libubsan1:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up libllvm14:arm64 (1:14.0.0-1ubuntu1.1) ... 602s Setting up libnsl-dev:arm64 (1.3.0-2build2) ... 602s Setting up libhwasan0:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up libcrypt-dev:arm64 (1:4.4.27-1) ... 602s Setting up libjson-perl (4.04000-1) ... 602s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.22.04.1) ... 602s Setting up libecpg6:arm64 (14.15-0ubuntu0.22.04.1) ... 602s Setting up libisl23:arm64 (0.24-2build1) ... 602s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 602s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 602s Setting up libcc1-0:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up liblsan0:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up libitm1:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up libtsan0:arm64 (11.4.0-1ubuntu1~22.04) ... 602s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 602s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 602s Setting up libz3-dev:arm64 (4.8.12-1) ... 602s Setting up libecpg-compat3:arm64 (14.15-0ubuntu0.22.04.1) ... 602s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 602s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 602s Setting up libobjc4:arm64 (12.3.0-1ubuntu1~22.04) ... 602s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 602s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 602s Setting up postgresql-common (238) ... 602s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 602s Adding user postgres to group ssl-cert 603s 603s Creating config file /etc/postgresql-common/createcluster.conf with new version 603s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 603s Removing obsolete dictionary files: 603s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 604s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 604s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 604s Setting up libgcc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 604s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 604s Setting up cpp (4:11.2.0-1ubuntu1) ... 604s Setting up libc6-dev:arm64 (2.35-0ubuntu3.9) ... 604s Setting up libicu-dev:arm64 (70.1-2) ... 604s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 604s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 604s Creating new PostgreSQL cluster 14/main ... 604s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 604s The files belonging to this database system will be owned by user "postgres". 604s This user must also own the server process. 604s 604s The database cluster will be initialized with locale "C.UTF-8". 604s The default database encoding has accordingly been set to "UTF8". 604s The default text search configuration will be set to "english". 604s 604s Data page checksums are disabled. 604s 604s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 604s creating subdirectories ... ok 604s selecting dynamic shared memory implementation ... posix 604s selecting default max_connections ... 100 604s selecting default shared_buffers ... 128MB 604s selecting default time zone ... Etc/UTC 604s creating configuration files ... ok 604s running bootstrap script ... ok 605s performing post-bootstrap initialization ... ok 605s syncing data to disk ... ok 606s update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 608s Setting up libncurses-dev:arm64 (6.3-2ubuntu0.1) ... 608s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 608s Setting up libobjc-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 608s Setting up gcc (4:11.2.0-1ubuntu1) ... 608s Setting up libxml2-dev:arm64 (2.9.13+dfsg-1ubuntu0.6) ... 608s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 608s Setting up libstdc++-11-dev:arm64 (11.4.0-1ubuntu1~22.04) ... 608s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 608s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 608s Setting up libtinfo-dev:arm64 (6.3-2ubuntu0.1) ... 608s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 608s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 608s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 608s Setting up g++ (4:11.2.0-1ubuntu1) ... 608s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 608s Setting up build-essential (12.9ubuntu3) ... 608s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 608s Processing triggers for man-db (2.10.2-1) ... 609s Processing triggers for install-info (6.8-4build1) ... 628s autopkgtest [13:25:58]: test installcheck: [----------------------- 628s + dpkg-parsechangelog -SSource 628s + SOURCE=postgresql-14 628s + MAJOR=14 628s + top_srcdir=/tmp/autopkgtest.3puq99/build.bcO/src 628s + cd src/test/regress 628s + make -f /tmp/autopkgtest.3puq99/build.bcO/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/14/bin/pg_config with_llvm=no 628s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -moutline-atomics -g -g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fPIC -I. -I/tmp/autopkgtest.3puq99/build.bcO/src/debian/tests/ -I/usr/include/postgresql/14/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o regress.o regress.c 629s gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -moutline-atomics -g -g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fPIC -shared -o regress.so regress.o -L/usr/lib/aarch64-linux-gnu -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-14/lib -Wl,--as-needed 629s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.3puq99/build.bcO/src/src/test/regress/regress: input/constraints.source input/copy.source input/create_function_0.source input/create_function_1.source input/create_function_2.source input/largeobject.source input/misc.source input/tablespace.source output/constraints.source output/copy.source output/create_function_0.source output/create_function_1.source output/create_function_2.source output/largeobject.source output/largeobject_1.source output/misc.source output/tablespace.source 629s + id -u 629s + [ 1000 = 0 ] 629s + SU=sh 629s + sh 629s + mktemp -d /tmp/regress.XXXXXX 629s + OUTPUT=/tmp/regress.2ww2gl 629s + trap rm -rf /tmp/regress.2ww2gl EXIT 629s + pg_virtualenv -v 14 /usr/lib/postgresql/14/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --make-testtablespace-dir --outputdir=/tmp/regress.2ww2gl --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 630s Creating new PostgreSQL cluster 14/regress ... 632s (using postmaster on localhost, port 5433) 632s ============== dropping database "regression" ============== 632s DROP DATABASE 632s NOTICE: database "regression" does not exist, skipping 632s ============== creating database "regression" ============== 632s CREATE DATABASE 633s ALTER DATABASE 633s ============== running regression test queries ============== 633s test tablespace ... ok 241 ms 634s parallel group (20 tests): varchar int8 float4 regproc pg_lsn oid float8 uuid name char money enum int2 txid int4 text numeric boolean bit rangetypes 634s boolean ... ok 731 ms 634s char ... ok 347 ms 634s name ... ok 323 ms 634s varchar ... ok 124 ms 634s text ... ok 449 ms 634s int2 ... ok 395 ms 634s int4 ... ok 432 ms 634s int8 ... ok 151 ms 634s oid ... ok 244 ms 634s float4 ... ok 210 ms 634s float8 ... ok 243 ms 634s bit ... ok 745 ms 634s numeric ... ok 676 ms 634s txid ... ok 421 ms 634s uuid ... ok 321 ms 634s enum ... ok 362 ms 634s money ... ok 350 ms 634s rangetypes ... ok 935 ms 634s pg_lsn ... ok 235 ms 634s regproc ... ok 221 ms 635s parallel group (20 tests): circle time path line create_function_0 macaddr lseg timetz numerology macaddr8 inet date interval strings timestamp point timestamptz polygon multirangetypes box 635s strings ... ok 615 ms 635s numerology ... ok 424 ms 635s point ... ok 693 ms 635s lseg ... ok 350 ms 635s line ... ok 270 ms 635s box ... ok 1260 ms 635s path ... ok 209 ms 635s polygon ... ok 1050 ms 635s circle ... ok 166 ms 635s date ... ok 561 ms 635s time ... ok 174 ms 635s timetz ... ok 400 ms 635s timestamp ... ok 631 ms 635s timestamptz ... FAILED 722 ms 635s interval ... ok 602 ms 635s inet ... ok 490 ms 635s macaddr ... ok 320 ms 635s macaddr8 ... ok 424 ms 635s multirangetypes ... ok 1094 ms 635s create_function_0 ... ok 282 ms 636s parallel group (13 tests): geometry xid unicode misc_sanity comments tstypes mvcc expressions type_sanity database opr_sanity horology regex 636s geometry ... ok 211 ms 636s horology ... ok 686 ms 636s tstypes ... ok 365 ms 636s regex ... ok 735 ms 636s type_sanity ... ok 444 ms 636s opr_sanity ... ok 652 ms 636s misc_sanity ... ok 319 ms 636s comments ... ok 321 ms 636s expressions ... ok 422 ms 636s unicode ... ok 283 ms 636s xid ... ok 272 ms 636s mvcc ... ok 399 ms 636s database ... ok 465 ms 636s test create_function_1 ... ok 20 ms 636s test create_type ... ok 35 ms 636s test create_table ... ok 288 ms 636s test create_function_2 ... ok 22 ms 637s parallel group (5 tests): copyselect copydml insert_conflict insert copy 637s copy ... ok 374 ms 637s copyselect ... ok 97 ms 637s copydml ... ok 111 ms 637s insert ... ok 348 ms 637s insert_conflict ... ok 226 ms 637s parallel group (4 tests): create_operator create_schema create_misc create_procedure 637s create_misc ... ok 95 ms 637s create_operator ... ok 81 ms 637s create_procedure ... ok 101 ms 637s create_schema ... ok 89 ms 638s parallel group (5 tests): index_including index_including_gist create_view create_index_spgist create_index 638s create_index ... ok 1298 ms 638s create_index_spgist ... ok 1197 ms 638s create_view ... ok 517 ms 638s index_including ... ok 338 ms 638s index_including_gist ... ok 369 ms 639s parallel group (16 tests): create_aggregate roleattributes create_cast infinite_recurse create_am hash_func typed_table select errors drop_if_exists create_function_3 constraints vacuum updatable_views inherit triggers 639s create_aggregate ... ok 80 ms 639s create_function_3 ... ok 724 ms 639s create_cast ... ok 350 ms 639s constraints ... ok 780 ms 639s triggers ... ok 1415 ms 639s select ... ok 507 ms 639s inherit ... ok 1378 ms 639s typed_table ... ok 442 ms 639s vacuum ... ok 880 ms 639s drop_if_exists ... ok 522 ms 639s updatable_views ... ok 1192 ms 639s roleattributes ... ok 167 ms 639s create_am ... ok 384 ms 639s hash_func ... ok 425 ms 639s errors ... ok 513 ms 639s infinite_recurse ... ok 382 ms 640s test sanity_check ... ok 128 ms 642s parallel group (20 tests): case select_implicit select_distinct_on select_having delete namespace random select_into prepared_xacts subselect select_distinct union transactions portals hash_index arrays update aggregates btree_index join 642s select_into ... ok 444 ms 642s select_distinct ... ok 532 ms 642s select_distinct_on ... ok 234 ms 642s select_implicit ... ok 229 ms 642s select_having ... ok 314 ms 642s subselect ... ok 509 ms 642s union ... ok 734 ms 642s case ... ok 182 ms 642s join ... ok 2074 ms 642s aggregates ... ok 1746 ms 642s transactions ... ok 843 ms 642s random ... ok 387 ms 642s portals ... ok 876 ms 642s arrays ... ok 1052 ms 642s btree_index ... ok 1898 ms 642s hash_index ... ok 1013 ms 642s update ... ok 1386 ms 642s delete ... ok 315 ms 642s namespace ... ok 363 ms 642s prepared_xacts ... ok 467 ms 649s parallel group (20 tests): drop_operator init_privs tablesample security_label lock object_address replica_identity password identity spgist matview generated collate rowsecurity gist groupingsets gin brin join_hash privileges 649s brin ... ok 6701 ms 649s gin ... ok 2936 ms 649s gist ... ok 2552 ms 649s spgist ... ok 1624 ms 649s privileges ... ok 7084 ms 649s init_privs ... ok 287 ms 649s security_label ... ok 634 ms 649s collate ... ok 2248 ms 649s matview ... ok 1831 ms 649s lock ... ok 685 ms 649s replica_identity ... ok 1070 ms 649s rowsecurity ... ok 2390 ms 649s object_address ... ok 907 ms 649s tablesample ... ok 458 ms 649s groupingsets ... ok 2902 ms 649s drop_operator ... ok 168 ms 649s password ... ok 1160 ms 649s identity ... ok 1475 ms 649s generated ... ok 1866 ms 649s join_hash ... ok 6708 ms 649s parallel group (2 tests): brin_bloom brin_multi 649s brin_bloom ... ok 105 ms 649s brin_multi ... ok 187 ms 650s parallel group (14 tests): sysviews tid async dbsize alter_operator alter_generic tidscan tsrf misc_functions create_table_like tidrangescan incremental_sort collate.icu.utf8 misc 650s create_table_like ... ok 622 ms 650s alter_generic ... ok 262 ms 650s alter_operator ... ok 254 ms 650s misc ... ok 1042 ms 650s async ... ok 209 ms 650s dbsize ... ok 247 ms 650s misc_functions ... ok 375 ms 650s sysviews ... ok 105 ms 650s tsrf ... ok 347 ms 650s tid ... ok 140 ms 650s tidscan ... ok 339 ms 650s tidrangescan ... ok 708 ms 650s collate.icu.utf8 ... ok 980 ms 650s incremental_sort ... ok 772 ms 651s parallel group (6 tests): collate.linux.utf8 amutils psql_crosstab psql rules stats_ext 651s rules ... ok 435 ms 651s psql ... ok 422 ms 651s psql_crosstab ... ok 94 ms 651s amutils ... ok 73 ms 651s stats_ext ... ok 1155 ms 651s collate.linux.utf8 ... ok 58 ms 654s test select_parallel ... ok 3188 ms 654s test write_parallel ... ok 136 ms 655s test vacuum_parallel ... ok 106 ms 655s parallel group (2 tests): subscription publication 655s publication ... ok 80 ms 655s subscription ... ok 45 ms 656s parallel group (17 tests): advisory_lock guc tsdicts functional_deps portals_p2 dependency xmlmap select_views equivclass combocid bitmapops window cluster indirect_toast foreign_data tsearch foreign_key 656s select_views ... ok 540 ms 656s portals_p2 ... ok 438 ms 656s foreign_key ... ok 1478 ms 656s cluster ... ok 923 ms 656s dependency ... ok 453 ms 656s guc ... ok 114 ms 656s bitmapops ... ok 801 ms 656s combocid ... ok 545 ms 656s tsearch ... ok 1412 ms 656s tsdicts ... ok 153 ms 656s foreign_data ... ok 1168 ms 656s window ... ok 834 ms 656s xmlmap ... ok 520 ms 656s functional_deps ... ok 181 ms 656s advisory_lock ... ok 56 ms 656s indirect_toast ... ok 963 ms 656s equivclass ... ok 538 ms 656s parallel group (6 tests): json_encoding jsonpath jsonpath_encoding jsonb_jsonpath json jsonb 656s json ... ok 185 ms 656s jsonb ... ok 287 ms 656s json_encoding ... ok 66 ms 656s jsonpath ... ok 78 ms 656s jsonpath_encoding ... ok 83 ms 656s jsonb_jsonpath ... ok 175 ms 659s parallel group (18 tests): prepare limit conversion temp returning plancache copy2 with truncate rangefuncs sequence rowtypes polymorphism largeobject domain xml plpgsql alter_table 659s plancache ... ok 827 ms 659s limit ... ok 412 ms 659s plpgsql ... ok 1539 ms 659s copy2 ... ok 963 ms 659s temp ... ok 660 ms 659s domain ... ok 1268 ms 659s rangefuncs ... ok 1070 ms 659s prepare ... ok 141 ms 659s conversion ... ok 595 ms 659s truncate ... ok 1052 ms 659s alter_table ... ok 2048 ms 659s sequence ... ok 1148 ms 659s polymorphism ... ok 1238 ms 659s rowtypes ... ok 1169 ms 659s returning ... ok 676 ms 659s largeobject ... ok 1243 ms 659s with ... ok 1041 ms 659s xml ... ok 1291 ms 661s parallel group (11 tests): hash_part reloptions partition_info explain compression memoize partition_aggregate partition_join indexing tuplesort partition_prune 661s partition_join ... ok 1660 ms 661s partition_prune ... ok 2050 ms 661s reloptions ... ok 186 ms 661s hash_part ... ok 166 ms 661s indexing ... ok 1663 ms 661s partition_aggregate ... ok 1495 ms 661s partition_info ... ok 202 ms 661s tuplesort ... ok 1838 ms 661s explain ... ok 340 ms 661s compression ... ok 451 ms 661s memoize ... ok 1310 ms 661s parallel group (2 tests): event_trigger oidjoins 661s event_trigger ... ok 99 ms 661s oidjoins ... ok 184 ms 661s test fast_default ... ok 113 ms 662s test stats ... ok 591 ms 662s 662s ======================== 662s 1 of 212 tests failed. 662s ======================== 662s 662s The differences that caused some tests to fail can be viewed in the 662s file "/tmp/regress.2ww2gl/regression.diffs". A copy of the test summary that you see 662s above is saved in the file "/tmp/regress.2ww2gl/regression.out". 662s 662s *** /tmp/pg_virtualenv.J2RhlV/log/postgresql-14-regress.log (last 100 lines) *** 662s 2025-02-26 13:26:30.595 UTC [5798] ubuntu@regression DETAIL: Key (a)=(3) already exists. 662s 2025-02-26 13:26:30.595 UTC [5798] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression DETAIL: Key (a)=(4) already exists. 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 662s 2025-02-26 13:26:30.598 UTC [5798] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 662s 2025-02-26 13:26:30.600 UTC [5798] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 662s 2025-02-26 13:26:30.600 UTC [5798] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 662s 2025-02-26 13:26:30.607 UTC [5798] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 662s 2025-02-26 13:26:30.607 UTC [5798] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 662s 2025-02-26 13:26:30.679 UTC [5798] ubuntu@regression ERROR: division by zero 662s 2025-02-26 13:26:30.679 UTC [5798] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 662s 2025-02-26 13:26:31.121 UTC [5887] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 662s 2025-02-26 13:26:31.121 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 662s on ddl_command_start 662s execute procedure pg_backend_pid(); 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression ERROR: trigger functions can only be called as triggers 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 662s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 662s SELECT 1 $$ language sql; 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 662s 2025-02-26 13:26:31.123 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: unrecognized filter variable "food" 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when food in ('sandwich') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('sandwich') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('create table', 'create skunkcabbage') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('DROP EVENT TRIGGER') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('CREATE ROLE') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('CREATE DATABASE') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('CREATE TABLESPACE') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: filter variable "tag" specified more than once 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s when tag in ('create table') and tag in ('CREATE FUNCTION') 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 662s 2025-02-26 13:26:31.124 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 662s execute procedure test_event_trigger('argument not allowed'); 662s 2025-02-26 13:26:31.125 UTC [5887] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 662s 2025-02-26 13:26:31.125 UTC [5887] ubuntu@regression HINT: Must be superuser to create an event trigger. 662s 2025-02-26 13:26:31.125 UTC [5887] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 662s execute procedure test_event_trigger(); 662s 2025-02-26 13:26:31.134 UTC [5887] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 662s 2025-02-26 13:26:31.134 UTC [5887] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 662s 2025-02-26 13:26:31.134 UTC [5887] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 662s owner of user mapping for regress_evt_user on server useless_server 662s owner of default privileges on new relations belonging to role regress_evt_user 662s 2025-02-26 13:26:31.135 UTC [5887] ubuntu@regression STATEMENT: drop role regress_evt_user; 662s 2025-02-26 13:26:31.148 UTC [5887] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 662s 2025-02-26 13:26:31.148 UTC [5887] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 662s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 662s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 662s 2025-02-26 13:26:31.148 UTC [5887] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 662s 2025-02-26 13:26:31.151 UTC [5887] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 662s 2025-02-26 13:26:31.151 UTC [5887] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 662s 2025-02-26 13:26:31.151 UTC [5887] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 662s 2025-02-26 13:26:31.177 UTC [5887] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 662s 2025-02-26 13:26:31.177 UTC [5887] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 662s 2025-02-26 13:26:31.182 UTC [5887] ubuntu@regression ERROR: rewrites not allowed 662s 2025-02-26 13:26:31.182 UTC [5887] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 662s 2025-02-26 13:26:31.182 UTC [5887] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 662s 2025-02-26 13:26:31.194 UTC [5887] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 662s 2025-02-26 13:26:31.194 UTC [5887] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 662s 2025-02-26 13:26:31.985 UTC [5899] ubuntu@regression LOG: wait_for_stats delayed 0.521790 seconds 662s 2025-02-26 13:26:31.985 UTC [5899] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 662s 2025-02-26 13:26:31.985 UTC [5899] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 662s Dropping cluster 14/regress ... 662s diff -U3 /tmp/autopkgtest.3puq99/build.bcO/src/src/test/regress/expected/timestamptz.out /tmp/regress.2ww2gl/results/timestamptz.out 662s --- /tmp/autopkgtest.3puq99/build.bcO/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:37:40.000000000 +0000 662s +++ /tmp/regress.2ww2gl/results/timestamptz.out 2025-02-26 13:26:04.910135854 +0000 662s @@ -2280,7 +2280,7 @@ 662s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 662s timezone 662s -------------------------- 662s - Wed Dec 09 15:56:00 1846 662s + Wed Dec 09 15:56:08 1846 662s (1 row) 662s 662s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 662s + head -100 /tmp/regress.2ww2gl/regression.diffs 662s + exit 1 662s + rm -rf /tmp/regress.2ww2gl 662s autopkgtest [13:26:32]: test installcheck: -----------------------] 663s installcheck FAIL non-zero exit status 1 663s autopkgtest [13:26:33]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 663s autopkgtest [13:26:33]: @@@@@@@@@@@@@@@@@@@@ summary 663s run-testsuite PASS 663s installcheck FAIL non-zero exit status 1 680s nova [W] Using flock in prodstack6-arm64 680s Creating nova instance adt-jammy-arm64-postgresql-14-20250226-131530-juju-7f2275-prod-proposed-migration-environment-20-49281607-fbae-453f-bed5-c75d494c9b43 from image adt/ubuntu-jammy-arm64-server-20250226.img (UUID d5737183-38c5-4924-a254-272e32e58150)... 680s nova [W] Timed out waiting for 41e5f9a4-cb24-4ea1-b833-bcff4ca9ffd0 to get deleted. 680s nova [W] Using flock in prodstack6-arm64 680s Creating nova instance adt-jammy-arm64-postgresql-14-20250226-131530-juju-7f2275-prod-proposed-migration-environment-20-49281607-fbae-453f-bed5-c75d494c9b43 from image adt/ubuntu-jammy-arm64-server-20250226.img (UUID d5737183-38c5-4924-a254-272e32e58150)... 680s nova [W] Timed out waiting for 9d4cfd0c-ff25-47c2-8941-78e8fb5b7775 to get deleted.