0s autopkgtest [13:24:52]: starting date and time: 2025-02-26 13:24:52+0000 0s autopkgtest [13:24:52]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [13:24:52]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.hdppxn50/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-2@lcy02-71.secgroup --name adt-jammy-amd64-postgresql-14-20250226-132452-juju-7f2275-prod-proposed-migration-environment-2-37f698ee-520a-4590-948d-b64ebb1fc37f --image adt/ubuntu-jammy-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 41s autopkgtest [13:25:33]: testbed dpkg architecture: amd64 42s autopkgtest [13:25:33]: testbed apt version: 2.4.13 42s autopkgtest [13:25:34]: @@@@@@@@@@@@@@@@@@@@ test bed setup 42s autopkgtest [13:25:34]: testbed release detected to be: None 42s autopkgtest [13:25:34]: updating testbed package index (apt update) 42s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 42s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 42s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 42s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 43s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 43s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 43s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 43s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 43s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 Packages [329 kB] 43s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main i386 Packages [97.6 kB] 43s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 c-n-f Metadata [1740 B] 43s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 Packages [479 kB] 43s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/restricted i386 Packages [4732 B] 43s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 c-n-f Metadata [420 B] 43s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/universe i386 Packages [33.4 kB] 43s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 Packages [90.4 kB] 43s Get:17 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 c-n-f Metadata [1344 B] 43s Get:18 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse i386 Packages [2464 B] 43s Get:19 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 Packages [9488 B] 43s Get:20 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 c-n-f Metadata [208 B] 48s Fetched 1486 kB in 1s (2806 kB/s) 49s Reading package lists... 49s Reading package lists... 50s Building dependency tree... 50s Reading state information... 50s Calculating upgrade... 50s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 50s Reading package lists... 51s Building dependency tree... 51s Reading state information... 51s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 51s autopkgtest [13:25:43]: upgrading testbed (apt dist-upgrade and autopurge) 51s Reading package lists... 51s Building dependency tree... 51s Reading state information... 52s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 52s Starting 2 pkgProblemResolver with broken count: 0 52s Done 52s Entering ResolveByKeep 53s 53s The following packages will be upgraded: 53s tzdata 53s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 53s Need to get 347 kB of archives. 53s After this operation, 4096 B of additional disk space will be used. 53s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 tzdata all 2025a-0ubuntu0.22.04 [347 kB] 53s Preconfiguring packages ... 53s Fetched 347 kB in 0s (18.0 MB/s) 53s (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 ... 67962 files and directories currently installed.) 53s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 53s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 53s Setting up tzdata (2025a-0ubuntu0.22.04) ... 54s 54s Current default time zone: 'Etc/UTC' 54s Local time is now: Wed Feb 26 13:25:45 UTC 2025. 54s Universal Time is now: Wed Feb 26 13:25:45 UTC 2025. 54s Run 'dpkg-reconfigure tzdata' if you wish to change it. 54s 54s Reading package lists... 54s Building dependency tree... 54s Reading state information... 55s Starting pkgProblemResolver with broken count: 0 55s Starting 2 pkgProblemResolver with broken count: 0 55s Done 55s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 56s autopkgtest [13:25:48]: testbed running kernel: Linux 5.15.0-133-generic #144-Ubuntu SMP Fri Feb 7 20:47:38 UTC 2025 56s autopkgtest [13:25:48]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-14 62s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (dsc) [3864 B] 62s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (tar) [29.3 MB] 62s Get:3 http://ftpmaster.internal/ubuntu jammy-updates/main postgresql-14 14.15-0ubuntu0.22.04.1 (diff) [30.0 kB] 62s gpgv: Signature made Wed Nov 27 17:13:16 2024 UTC 62s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 62s gpgv: Can't check signature: No public key 62s dpkg-source: warning: cannot verify signature ./postgresql-14_14.15-0ubuntu0.22.04.1.dsc 63s autopkgtest [13:25:55]: testing package postgresql-14 version 14.15-0ubuntu0.22.04.1 65s autopkgtest [13:25:57]: build not needed 69s autopkgtest [13:26:01]: test run-testsuite: preparing testbed 70s Reading package lists... 70s Building dependency tree... 70s Reading state information... 70s Starting pkgProblemResolver with broken count: 0 70s Starting 2 pkgProblemResolver with broken count: 0 70s Done 71s The following NEW packages will be installed: 71s build-essential clang-14 cpp cpp-11 dictionaries-common emacsen-common g++ 71s g++-11 gcc gcc-11 gcc-11-base hunspell-en-us icu-devtools lib32gcc-s1 71s lib32stdc++6 libasan6 libatomic1 libc-dev-bin libc6-dev libc6-i386 libcc1-0 71s libclang-common-14-dev libclang-cpp14 libclang1-14 libcrypt-dev 71s libecpg-compat3 libecpg-dev libecpg6 libffi-dev libgc1 libgcc-11-dev 71s libgomp1 libicu-dev libisl23 libitm1 libjson-perl libllvm14 liblsan0 libmpc3 71s libncurses-dev libnsl-dev libobjc-11-dev libobjc4 libpfm4 libpgtypes3 71s libpq-dev libpq5 libpython3.10 libquadmath0 libssl-dev libstdc++-11-dev 71s libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev libxslt1.1 libz3-4 71s libz3-dev linux-libc-dev llvm-14 llvm-14-dev llvm-14-linker-tools 71s llvm-14-runtime llvm-14-tools net-tools postgresql-14 postgresql-client-14 71s postgresql-client-common postgresql-common postgresql-doc-14 71s postgresql-plperl-14 postgresql-plpython3-14 postgresql-pltcl-14 71s postgresql-server-dev-14 python3-pygments rpcsvc-proto ssl-cert 71s 0 upgraded, 78 newly installed, 0 to remove and 0 not upgraded. 71s Need to get 210 MB of archives. 71s After this operation, 995 MB of additional disk space will be used. 71s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc-dev-bin amd64 2.35-0ubuntu3.9 [20.3 kB] 71s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 linux-libc-dev amd64 5.15.0-133.144 [1298 kB] 71s Get:3 http://ftpmaster.internal/ubuntu jammy/main amd64 libcrypt-dev amd64 1:4.4.27-1 [112 kB] 71s Get:4 http://ftpmaster.internal/ubuntu jammy/main amd64 rpcsvc-proto amd64 1.4.2-0ubuntu6 [68.5 kB] 71s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtirpc-dev amd64 1.3.2-2ubuntu0.1 [192 kB] 71s Get:6 http://ftpmaster.internal/ubuntu jammy/main amd64 libnsl-dev amd64 1.3.0-2build2 [71.3 kB] 71s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-dev amd64 2.35-0ubuntu3.9 [2100 kB] 71s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 gcc-11-base amd64 11.4.0-1ubuntu1~22.04 [20.2 kB] 71s Get:9 http://ftpmaster.internal/ubuntu jammy/main amd64 libisl23 amd64 0.24-2build1 [727 kB] 71s Get:10 http://ftpmaster.internal/ubuntu jammy/main amd64 libmpc3 amd64 1.2.1-2build1 [46.9 kB] 71s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 cpp-11 amd64 11.4.0-1ubuntu1~22.04 [10.0 MB] 71s Get:12 http://ftpmaster.internal/ubuntu jammy/main amd64 cpp amd64 4:11.2.0-1ubuntu1 [27.7 kB] 71s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libcc1-0 amd64 12.3.0-1ubuntu1~22.04 [48.3 kB] 71s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgomp1 amd64 12.3.0-1ubuntu1~22.04 [126 kB] 71s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libitm1 amd64 12.3.0-1ubuntu1~22.04 [30.2 kB] 71s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libatomic1 amd64 12.3.0-1ubuntu1~22.04 [10.4 kB] 71s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libasan6 amd64 11.4.0-1ubuntu1~22.04 [2282 kB] 71s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 liblsan0 amd64 12.3.0-1ubuntu1~22.04 [1069 kB] 71s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtsan0 amd64 11.4.0-1ubuntu1~22.04 [2260 kB] 71s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libubsan1 amd64 12.3.0-1ubuntu1~22.04 [976 kB] 71s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libquadmath0 amd64 12.3.0-1ubuntu1~22.04 [154 kB] 71s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgcc-11-dev amd64 11.4.0-1ubuntu1~22.04 [2517 kB] 71s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 gcc-11 amd64 11.4.0-1ubuntu1~22.04 [20.1 MB] 71s Get:24 http://ftpmaster.internal/ubuntu jammy/main amd64 gcc amd64 4:11.2.0-1ubuntu1 [5112 B] 71s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libstdc++-11-dev amd64 11.4.0-1ubuntu1~22.04 [2101 kB] 71s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 g++-11 amd64 11.4.0-1ubuntu1~22.04 [11.4 MB] 71s Get:27 http://ftpmaster.internal/ubuntu jammy/main amd64 g++ amd64 4:11.2.0-1ubuntu1 [1412 B] 71s Get:28 http://ftpmaster.internal/ubuntu jammy/main amd64 build-essential amd64 12.9ubuntu3 [4744 B] 71s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libllvm14 amd64 1:14.0.0-1ubuntu1.1 [24.0 MB] 72s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang-cpp14 amd64 1:14.0.0-1ubuntu1.1 [12.1 MB] 72s Get:31 http://ftpmaster.internal/ubuntu jammy/main amd64 libgc1 amd64 1:8.0.6-1.1build1 [96.8 kB] 72s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc4 amd64 12.3.0-1ubuntu1~22.04 [48.6 kB] 72s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc-11-dev amd64 11.4.0-1ubuntu1~22.04 [196 kB] 72s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-i386 amd64 2.35-0ubuntu3.9 [2838 kB] 72s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32gcc-s1 amd64 12.3.0-1ubuntu1~22.04 [63.9 kB] 72s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32stdc++6 amd64 12.3.0-1ubuntu1~22.04 [740 kB] 72s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang-common-14-dev amd64 1:14.0.0-1ubuntu1.1 [5975 kB] 73s Get:38 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-linker-tools amd64 1:14.0.0-1ubuntu1.1 [1355 kB] 73s Get:39 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang1-14 amd64 1:14.0.0-1ubuntu1.1 [6792 kB] 73s Get:40 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 clang-14 amd64 1:14.0.0-1ubuntu1.1 [81.2 kB] 73s Get:41 http://ftpmaster.internal/ubuntu jammy/main amd64 emacsen-common all 3.0.4 [14.9 kB] 73s Get:42 http://ftpmaster.internal/ubuntu jammy/main amd64 dictionaries-common all 1.28.14 [185 kB] 73s Get:43 http://ftpmaster.internal/ubuntu jammy/main amd64 hunspell-en-us all 1:2020.12.07-2 [280 kB] 73s Get:44 http://ftpmaster.internal/ubuntu jammy/main amd64 icu-devtools amd64 70.1-2 [197 kB] 73s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpgtypes3 amd64 14.15-0ubuntu0.22.04.1 [47.1 kB] 73s Get:46 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq5 amd64 14.15-0ubuntu0.22.04.1 [150 kB] 73s Get:47 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg6 amd64 14.15-0ubuntu0.22.04.1 [45.1 kB] 73s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg-compat3 amd64 14.15-0ubuntu0.22.04.1 [13.6 kB] 73s Get:49 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libssl-dev amd64 3.0.2-0ubuntu1.19 [2376 kB] 73s Get:50 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq-dev amd64 14.15-0ubuntu0.22.04.1 [147 kB] 73s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg-dev amd64 14.15-0ubuntu0.22.04.1 [265 kB] 73s Get:52 http://ftpmaster.internal/ubuntu jammy/main amd64 libicu-dev amd64 70.1-2 [11.6 MB] 73s Get:53 http://ftpmaster.internal/ubuntu jammy/main amd64 libjson-perl all 4.04000-1 [81.8 kB] 73s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libncurses-dev amd64 6.3-2ubuntu0.1 [381 kB] 73s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpython3.10 amd64 3.10.12-1~22.04.9 [1949 kB] 73s Get:56 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtinfo-dev amd64 6.3-2ubuntu0.1 [780 B] 73s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxml2-dev amd64 2.9.13+dfsg-1ubuntu0.6 [804 kB] 73s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.22.04.1 [164 kB] 73s Get:59 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-runtime amd64 1:14.0.0-1ubuntu1.1 [484 kB] 73s Get:60 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpfm4 amd64 4.11.1+git32-gd0b85fb-1ubuntu0.1 [345 kB] 73s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14 amd64 1:14.0.0-1ubuntu1.1 [12.7 MB] 73s Get:62 http://ftpmaster.internal/ubuntu jammy/main amd64 libffi-dev amd64 3.4.2-4 [63.7 kB] 73s Get:63 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 73s Get:64 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-tools amd64 1:14.0.0-1ubuntu1.1 [404 kB] 73s Get:65 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-4 amd64 4.8.12-1 [5766 kB] 73s Get:66 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-dev amd64 4.8.12-1 [72.2 kB] 73s Get:67 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-dev amd64 1:14.0.0-1ubuntu1.1 [37.8 MB] 74s Get:68 http://ftpmaster.internal/ubuntu jammy/main amd64 net-tools amd64 1.60+git20181103.0eebece-1ubuntu5 [204 kB] 74s Get:69 http://ftpmaster.internal/ubuntu jammy/main amd64 postgresql-client-common all 238 [29.6 kB] 74s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-client-14 amd64 14.15-0ubuntu0.22.04.1 [1225 kB] 74s Get:71 http://ftpmaster.internal/ubuntu jammy/main amd64 ssl-cert all 1.1.2 [17.4 kB] 74s Get:72 http://ftpmaster.internal/ubuntu jammy/main amd64 postgresql-common all 238 [169 kB] 74s Get:73 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-14 amd64 14.15-0ubuntu0.22.04.1 [16.2 MB] 74s Get:74 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 74s Get:75 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-plperl-14 amd64 14.15-0ubuntu0.22.04.1 [75.4 kB] 74s Get:76 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-plpython3-14 amd64 14.15-0ubuntu0.22.04.1 [84.6 kB] 74s Get:77 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-pltcl-14 amd64 14.15-0ubuntu0.22.04.1 [35.7 kB] 74s Get:78 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 postgresql-server-dev-14 amd64 14.15-0ubuntu0.22.04.1 [1181 kB] 74s Preconfiguring packages ... 75s Fetched 210 MB in 3s (64.3 MB/s) 75s Selecting previously unselected package libc-dev-bin. 75s (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 ... 67963 files and directories currently installed.) 75s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_amd64.deb ... 75s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 75s Selecting previously unselected package linux-libc-dev:amd64. 75s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_amd64.deb ... 75s Unpacking linux-libc-dev:amd64 (5.15.0-133.144) ... 75s Selecting previously unselected package libcrypt-dev:amd64. 75s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_amd64.deb ... 75s Unpacking libcrypt-dev:amd64 (1:4.4.27-1) ... 75s Selecting previously unselected package rpcsvc-proto. 75s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_amd64.deb ... 75s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 75s Selecting previously unselected package libtirpc-dev:amd64. 75s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_amd64.deb ... 75s Unpacking libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... 75s Selecting previously unselected package libnsl-dev:amd64. 75s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_amd64.deb ... 75s Unpacking libnsl-dev:amd64 (1.3.0-2build2) ... 75s Selecting previously unselected package libc6-dev:amd64. 75s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_amd64.deb ... 75s Unpacking libc6-dev:amd64 (2.35-0ubuntu3.9) ... 75s Selecting previously unselected package gcc-11-base:amd64. 75s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking gcc-11-base:amd64 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libisl23:amd64. 75s Preparing to unpack .../08-libisl23_0.24-2build1_amd64.deb ... 75s Unpacking libisl23:amd64 (0.24-2build1) ... 75s Selecting previously unselected package libmpc3:amd64. 75s Preparing to unpack .../09-libmpc3_1.2.1-2build1_amd64.deb ... 75s Unpacking libmpc3:amd64 (1.2.1-2build1) ... 75s Selecting previously unselected package cpp-11. 75s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package cpp. 75s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_amd64.deb ... 75s Unpacking cpp (4:11.2.0-1ubuntu1) ... 75s Selecting previously unselected package libcc1-0:amd64. 75s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libcc1-0:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libgomp1:amd64. 75s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libgomp1:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libitm1:amd64. 75s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libitm1:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libatomic1:amd64. 75s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libatomic1:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libasan6:amd64. 75s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libasan6:amd64 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package liblsan0:amd64. 75s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking liblsan0:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libtsan0:amd64. 75s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libtsan0:amd64 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libubsan1:amd64. 75s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libubsan1:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libquadmath0:amd64. 75s Preparing to unpack .../20-libquadmath0_12.3.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libquadmath0:amd64 (12.3.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package libgcc-11-dev:amd64. 75s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libgcc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package gcc-11. 75s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 75s Selecting previously unselected package gcc. 75s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_amd64.deb ... 75s Unpacking gcc (4:11.2.0-1ubuntu1) ... 75s Selecting previously unselected package libstdc++-11-dev:amd64. 75s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 75s Unpacking libstdc++-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 76s Selecting previously unselected package g++-11. 76s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 76s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 76s Selecting previously unselected package g++. 76s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_amd64.deb ... 76s Unpacking g++ (4:11.2.0-1ubuntu1) ... 76s Selecting previously unselected package build-essential. 76s Preparing to unpack .../27-build-essential_12.9ubuntu3_amd64.deb ... 76s Unpacking build-essential (12.9ubuntu3) ... 76s Selecting previously unselected package libllvm14:amd64. 76s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 76s Unpacking libllvm14:amd64 (1:14.0.0-1ubuntu1.1) ... 76s Selecting previously unselected package libclang-cpp14. 76s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 76s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 76s Selecting previously unselected package libgc1:amd64. 76s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_amd64.deb ... 76s Unpacking libgc1:amd64 (1:8.0.6-1.1build1) ... 76s Selecting previously unselected package libobjc4:amd64. 76s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_amd64.deb ... 76s Unpacking libobjc4:amd64 (12.3.0-1ubuntu1~22.04) ... 76s Selecting previously unselected package libobjc-11-dev:amd64. 76s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 76s Unpacking libobjc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 77s Selecting previously unselected package libc6-i386. 77s Preparing to unpack .../33-libc6-i386_2.35-0ubuntu3.9_amd64.deb ... 77s Unpacking libc6-i386 (2.35-0ubuntu3.9) ... 77s Selecting previously unselected package lib32gcc-s1. 77s Preparing to unpack .../34-lib32gcc-s1_12.3.0-1ubuntu1~22.04_amd64.deb ... 77s Unpacking lib32gcc-s1 (12.3.0-1ubuntu1~22.04) ... 77s Selecting previously unselected package lib32stdc++6. 77s Preparing to unpack .../35-lib32stdc++6_12.3.0-1ubuntu1~22.04_amd64.deb ... 77s Unpacking lib32stdc++6 (12.3.0-1ubuntu1~22.04) ... 77s Selecting previously unselected package libclang-common-14-dev. 77s Preparing to unpack .../36-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 77s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 77s Selecting previously unselected package llvm-14-linker-tools. 77s Preparing to unpack .../37-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 77s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 77s Selecting previously unselected package libclang1-14. 77s Preparing to unpack .../38-libclang1-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 77s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 77s Selecting previously unselected package clang-14. 77s Preparing to unpack .../39-clang-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 77s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 77s Selecting previously unselected package emacsen-common. 77s Preparing to unpack .../40-emacsen-common_3.0.4_all.deb ... 77s Unpacking emacsen-common (3.0.4) ... 77s Selecting previously unselected package dictionaries-common. 77s Preparing to unpack .../41-dictionaries-common_1.28.14_all.deb ... 77s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 77s Unpacking dictionaries-common (1.28.14) ... 77s Selecting previously unselected package hunspell-en-us. 77s Preparing to unpack .../42-hunspell-en-us_1%3a2020.12.07-2_all.deb ... 77s Unpacking hunspell-en-us (1:2020.12.07-2) ... 77s Selecting previously unselected package icu-devtools. 77s Preparing to unpack .../43-icu-devtools_70.1-2_amd64.deb ... 77s Unpacking icu-devtools (70.1-2) ... 77s Selecting previously unselected package libpgtypes3:amd64. 77s Preparing to unpack .../44-libpgtypes3_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libpgtypes3:amd64 (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libpq5:amd64. 77s Preparing to unpack .../45-libpq5_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libpq5:amd64 (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libecpg6:amd64. 77s Preparing to unpack .../46-libecpg6_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libecpg6:amd64 (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libecpg-compat3:amd64. 77s Preparing to unpack .../47-libecpg-compat3_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libecpg-compat3:amd64 (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libssl-dev:amd64. 77s Preparing to unpack .../48-libssl-dev_3.0.2-0ubuntu1.19_amd64.deb ... 77s Unpacking libssl-dev:amd64 (3.0.2-0ubuntu1.19) ... 77s Selecting previously unselected package libpq-dev. 77s Preparing to unpack .../49-libpq-dev_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libecpg-dev. 77s Preparing to unpack .../50-libecpg-dev_14.15-0ubuntu0.22.04.1_amd64.deb ... 77s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 77s Selecting previously unselected package libicu-dev:amd64. 77s Preparing to unpack .../51-libicu-dev_70.1-2_amd64.deb ... 77s Unpacking libicu-dev:amd64 (70.1-2) ... 77s Selecting previously unselected package libjson-perl. 77s Preparing to unpack .../52-libjson-perl_4.04000-1_all.deb ... 77s Unpacking libjson-perl (4.04000-1) ... 77s Selecting previously unselected package libncurses-dev:amd64. 77s Preparing to unpack .../53-libncurses-dev_6.3-2ubuntu0.1_amd64.deb ... 77s Unpacking libncurses-dev:amd64 (6.3-2ubuntu0.1) ... 78s Selecting previously unselected package libpython3.10:amd64. 78s Preparing to unpack .../54-libpython3.10_3.10.12-1~22.04.9_amd64.deb ... 78s Unpacking libpython3.10:amd64 (3.10.12-1~22.04.9) ... 78s Selecting previously unselected package libtinfo-dev:amd64. 78s Preparing to unpack .../55-libtinfo-dev_6.3-2ubuntu0.1_amd64.deb ... 78s Unpacking libtinfo-dev:amd64 (6.3-2ubuntu0.1) ... 78s Selecting previously unselected package libxml2-dev:amd64. 78s Preparing to unpack .../56-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_amd64.deb ... 78s Unpacking libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.6) ... 78s Selecting previously unselected package libxslt1.1:amd64. 78s Preparing to unpack .../57-libxslt1.1_1.1.34-4ubuntu0.22.04.1_amd64.deb ... 78s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ... 78s Selecting previously unselected package llvm-14-runtime. 78s Preparing to unpack .../58-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 78s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 78s Selecting previously unselected package libpfm4:amd64. 78s Preparing to unpack .../59-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_amd64.deb ... 78s Unpacking libpfm4:amd64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 78s Selecting previously unselected package llvm-14. 78s Preparing to unpack .../60-llvm-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 78s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 78s Selecting previously unselected package libffi-dev:amd64. 78s Preparing to unpack .../61-libffi-dev_3.4.2-4_amd64.deb ... 78s Unpacking libffi-dev:amd64 (3.4.2-4) ... 78s Selecting previously unselected package python3-pygments. 78s Preparing to unpack .../62-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 78s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 78s Selecting previously unselected package llvm-14-tools. 78s Preparing to unpack .../63-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 78s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 78s Selecting previously unselected package libz3-4:amd64. 78s Preparing to unpack .../64-libz3-4_4.8.12-1_amd64.deb ... 78s Unpacking libz3-4:amd64 (4.8.12-1) ... 78s Selecting previously unselected package libz3-dev:amd64. 78s Preparing to unpack .../65-libz3-dev_4.8.12-1_amd64.deb ... 78s Unpacking libz3-dev:amd64 (4.8.12-1) ... 78s Selecting previously unselected package llvm-14-dev. 78s Preparing to unpack .../66-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 78s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 79s Selecting previously unselected package net-tools. 79s Preparing to unpack .../67-net-tools_1.60+git20181103.0eebece-1ubuntu5_amd64.deb ... 79s Unpacking net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 79s Selecting previously unselected package postgresql-client-common. 79s Preparing to unpack .../68-postgresql-client-common_238_all.deb ... 79s Unpacking postgresql-client-common (238) ... 79s Selecting previously unselected package postgresql-client-14. 79s Preparing to unpack .../69-postgresql-client-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 79s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 79s Selecting previously unselected package ssl-cert. 79s Preparing to unpack .../70-ssl-cert_1.1.2_all.deb ... 79s Unpacking ssl-cert (1.1.2) ... 79s Selecting previously unselected package postgresql-common. 79s Preparing to unpack .../71-postgresql-common_238_all.deb ... 79s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 79s Unpacking postgresql-common (238) ... 79s Selecting previously unselected package postgresql-14. 79s Preparing to unpack .../72-postgresql-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 79s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 80s Selecting previously unselected package postgresql-doc-14. 80s Preparing to unpack .../73-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 80s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 80s Selecting previously unselected package postgresql-plperl-14. 80s Preparing to unpack .../74-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 80s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 80s Selecting previously unselected package postgresql-plpython3-14. 80s Preparing to unpack .../75-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 80s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 80s Selecting previously unselected package postgresql-pltcl-14. 80s Preparing to unpack .../76-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 80s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 80s Selecting previously unselected package postgresql-server-dev-14. 80s Preparing to unpack .../77-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 80s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 80s Setting up postgresql-client-common (238) ... 80s Setting up libpgtypes3:amd64 (14.15-0ubuntu0.22.04.1) ... 80s Setting up gcc-11-base:amd64 (11.4.0-1ubuntu1~22.04) ... 80s Setting up libpython3.10:amd64 (3.10.12-1~22.04.9) ... 80s Setting up net-tools (1.60+git20181103.0eebece-1ubuntu5) ... 80s Setting up libpq5:amd64 (14.15-0ubuntu0.22.04.1) ... 80s Setting up linux-libc-dev:amd64 (5.15.0-133.144) ... 80s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 80s 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 80s Setting up libgomp1:amd64 (12.3.0-1ubuntu1~22.04) ... 80s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 80s 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 81s Setting up libffi-dev:amd64 (3.4.2-4) ... 81s Setting up libasan6:amd64 (11.4.0-1ubuntu1~22.04) ... 81s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 81s Setting up libz3-4:amd64 (4.8.12-1) ... 81s Setting up libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... 81s Setting up libpfm4:amd64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 81s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 81s Setting up emacsen-common (3.0.4) ... 81s Setting up ssl-cert (1.1.2) ... 82s Setting up libquadmath0:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up libssl-dev:amd64 (3.0.2-0ubuntu1.19) ... 82s Setting up libmpc3:amd64 (1.2.1-2build1) ... 82s Setting up libatomic1:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up icu-devtools (70.1-2) ... 82s Setting up libgc1:amd64 (1:8.0.6-1.1build1) ... 82s Setting up libubsan1:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up libllvm14:amd64 (1:14.0.0-1ubuntu1.1) ... 82s Setting up libnsl-dev:amd64 (1.3.0-2build2) ... 82s Setting up libcrypt-dev:amd64 (1:4.4.27-1) ... 82s Setting up libjson-perl (4.04000-1) ... 82s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ... 82s Setting up libecpg6:amd64 (14.15-0ubuntu0.22.04.1) ... 82s Setting up libc6-i386 (2.35-0ubuntu3.9) ... 82s Setting up libisl23:amd64 (0.24-2build1) ... 82s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 82s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 82s Setting up libcc1-0:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up liblsan0:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up libitm1:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up libtsan0:amd64 (11.4.0-1ubuntu1~22.04) ... 82s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 82s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 82s Setting up libz3-dev:amd64 (4.8.12-1) ... 82s Setting up libecpg-compat3:amd64 (14.15-0ubuntu0.22.04.1) ... 82s Setting up dictionaries-common (1.28.14) ... 82s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 82s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 82s Setting up libobjc4:amd64 (12.3.0-1ubuntu1~22.04) ... 82s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 82s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 82s Setting up lib32gcc-s1 (12.3.0-1ubuntu1~22.04) ... 82s Setting up lib32stdc++6 (12.3.0-1ubuntu1~22.04) ... 82s Setting up postgresql-common (238) ... 82s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 82s Adding user postgres to group ssl-cert 82s 82s Creating config file /etc/postgresql-common/createcluster.conf with new version 82s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 82s en_us 82s Removing obsolete dictionary files: 83s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 83s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 83s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 83s Setting up libgcc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 83s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 83s Setting up cpp (4:11.2.0-1ubuntu1) ... 83s Setting up hunspell-en-us (1:2020.12.07-2) ... 83s Setting up libc6-dev:amd64 (2.35-0ubuntu3.9) ... 83s Setting up libicu-dev:amd64 (70.1-2) ... 83s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 83s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 83s Creating new PostgreSQL cluster 14/main ... 83s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 83s The files belonging to this database system will be owned by user "postgres". 83s This user must also own the server process. 83s 83s The database cluster will be initialized with locale "C.UTF-8". 83s The default database encoding has accordingly been set to "UTF8". 83s The default text search configuration will be set to "english". 83s 83s Data page checksums are disabled. 83s 83s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 83s creating subdirectories ... ok 83s selecting dynamic shared memory implementation ... posix 83s selecting default max_connections ... 100 83s selecting default shared_buffers ... 128MB 83s selecting default time zone ... Etc/UTC 83s creating configuration files ... ok 83s running bootstrap script ... ok 84s performing post-bootstrap initialization ... ok 84s syncing data to disk ... ok 84s 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 86s Setting up libncurses-dev:amd64 (6.3-2ubuntu0.1) ... 86s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 86s Setting up libobjc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 86s Setting up gcc (4:11.2.0-1ubuntu1) ... 86s Setting up libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.6) ... 86s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 86s Setting up libstdc++-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 86s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 86s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 86s Setting up libtinfo-dev:amd64 (6.3-2ubuntu0.1) ... 86s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 86s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 86s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 86s Setting up g++ (4:11.2.0-1ubuntu1) ... 86s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 86s Setting up build-essential (12.9ubuntu3) ... 86s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 86s Processing triggers for man-db (2.10.2-1) ... 87s Processing triggers for install-info (6.8-4build1) ... 87s Processing triggers for dictionaries-common (1.28.14) ... 89s autopkgtest [13:26:21]: test run-testsuite: [----------------------- 89s Generating locales (this might take a while)... 90s en_US.UTF-8... done 90s ru_RU.ISO-8859-5... done 92s ru_RU.UTF-8... done 92s Generation complete. 92s ====== Running all tests with umask 077 ======= 92s === Running test 001_packages.t ... === 92s 1..21 92s ok 1 - /etc/os-release exists 92s ok 2 - OS is ubuntu 92s ok 3 - OS version is 22.04 92s # PostgreSQL versions installed: 14 92s ok 4 - postgresql-14 installed 92s ok 5 # skip No python2 support 92s ok 6 - postgresql-plpython3-14 installed 92s ok 7 - postgresql-plperl-14 installed 92s ok 8 - postgresql-pltcl-14 installed 92s ok 9 - postgresql-server-dev-14 installed 92s ok 10 # skip No postgresql-contrib-14 package for version 14 92s ok 11 - libecpg-dev installed 92s ok 12 - procps installed 92s ok 13 - netcat-openbsd installed 92s ok 14 - hunspell-en-us installed 92s ok 15 - system has a default UTF-8 locale 92s ok 16 - locale ru_RU exists 92s ok 17 - locale ru_RU.UTF-8 exists 92s ok 18 - user postgres in the UNIX group ssl-cert 92s ok 19 - /etc/ssl/private/ssl-cert-snakeoil.key exists 92s ok 20 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 92s ok 21 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 92s === Running test 002_existing_clusters.t ... === 92s 1..8 92s # Cleanup 92s ok 1 - Cleanup: No clusters left behind 92s ok 2 - No postgres processes left behind 92s ok 3 - No files in /etc/postgresql left behind 92s ok 4 - No files in /var/lib/postgresql left behind 92s ok 5 - No files in /var/run/postgresql left behind 92s ok 6 - No files in /var/log/postgresql left behind 92s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 92s ok 8 - PostgreSQL TCP ports are closed 92s === Running test 005_PgCommon.t ... === 92s 1..24 92s ok 1 - correctly parsed line 'local all postgres ident sameuser' 92s ok 2 - correctly parsed line 'local foo nobody trust' 92s ok 3 - correctly parsed line 'local foo nobody crypt' 92s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 92s ok 5 - correctly parsed line 'local foo,bar nobody ident' 92s ok 6 - correctly parsed line 'local all +foogrp password' 92s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 92s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 92s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 92s ok 10 - @expected_records has correct number of entries 92s ok 11 - returned read_pg_hba array has correct number of records 92s ok 12 - line 'foo all all md5' parsed as invalid 92s ok 13 - line 'local all all foo' parsed as invalid 92s ok 14 - line 'host all all foo' parsed as invalid 92s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 92s ok 16 - line 'host all all md5' parsed as invalid 92s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 92s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 92s ok 19 - read_conf_file returns empty dict for nonexisting file 92s ok 20 - read_conf_file() parsing 92s ok 21 - read_conf_file() parsing with include directives 92s ok 22 - set_conf_value 92s ok 23 - disable_conf_value 92s ok 24 - replace_conf_value 92s === Running test 006_next_free_port.t ... === 92s 1..5 92s ok 1 - next_free_port is 5432 93s ok 2 - next_free_port detects localhost ipv4 socket 94s ok 3 - next_free_port detects wildcard ipv4 socket 95s ok 4 - next_free_port detects localhost ipv6 socket 96s ok 5 - next_free_port detects wildcard ipv6 socket 96s === Running test 007_pg_conftool.t ... === 96s 1..41 96s # test without cluster 96s ok 1 - pg_conftool show all 96s ok 2 - correct output of pg_conftool show all 96s ok 3 - pg_conftool foo.conf show all 96s ok 4 - correct output of pg_conftool foo.conf show all 97s ok 5 - pg_conftool /tmp/eGYt6k4Mwc/different.conf show all 97s ok 6 - correct output of pg_conftool /tmp/eGYt6k4Mwc/different.conf show all 97s ok 7 - pg_conftool 9.7 main show all 97s ok 8 - correct output of pg_conftool 9.7 main show all 97s # test show 97s ok 9 - pg_conftool show all 97s ok 10 - correct output of pg_conftool show all 97s ok 11 - pg_conftool other.conf show all 97s ok 12 - correct output of pg_conftool other.conf show all 97s ok 13 - pg_conftool /tmp/eGYt6k4Mwc/different.conf show all 97s ok 14 - correct output of pg_conftool /tmp/eGYt6k4Mwc/different.conf show all 97s ok 15 - pg_conftool 14 main show all 97s ok 16 - correct output of pg_conftool 14 main show all 97s ok 17 - pg_conftool 14 main other.conf show all 97s ok 18 - correct output of pg_conftool 14 main other.conf show all 97s ok 19 - pg_conftool show a 97s ok 20 - correct output of pg_conftool show a 97s ok 21 - pg_conftool -s show a 97s ok 22 - correct output of pg_conftool -s show a 97s # test set 97s ok 23 - pg_conftool set c 7 97s ok 24 - correct output of pg_conftool set c 7 97s ok 25 - file contains new setting 97s ok 26 - pg_conftool set a 8 97s ok 27 - correct output of pg_conftool set a 8 97s ok 28 - file contains updated setting 97s ok 29 - pg_conftool /tmp/eGYt6k4Mwc/different.conf set a 9 97s ok 30 - correct output of pg_conftool /tmp/eGYt6k4Mwc/different.conf set a 9 97s ok 31 - file with path contains updated setting 97s # test remove 97s ok 32 - pg_conftool remove a 97s ok 33 - correct output of pg_conftool remove a 97s ok 34 - setting removed from file 97s ok 35 - pg_conftool /tmp/eGYt6k4Mwc/different.conf remove a 97s ok 36 - correct output of pg_conftool /tmp/eGYt6k4Mwc/different.conf remove a 97s ok 37 - setting removed from file with path 97s # test edit 97s ok 38 - pg_conftool edit 97s ok 39 - correct output of pg_conftool edit 97s ok 40 - pg_conftool /tmp/eGYt6k4Mwc/different.conf edit 97s ok 41 - correct output of pg_conftool /tmp/eGYt6k4Mwc/different.conf edit 97s === Running test 010_defaultport_cluster.t ... === 97s 1..14 97s ok 1 - psql --version 97s ok 2 - pg_wrapper selects highest available version number 97s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 97s ok 4 - connecting to localhost fails with no clusters 97s ok 5 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -l 97s ok 6 - pg_wrapper uses host and port from PGCLUSTER 97s ok 7 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --cluster 14/127.0.0.3:5430 -l 97s ok 8 - pg_wrapper uses --cluster from the command line 97s ok 9 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql -h 127.0.0.3 -l 97s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 97s ok 11 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 psql --host 127.0.0.3 -l 97s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 97s ok 13 - env LC_MESSAGES=C PGCLUSTER=14/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 97s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 97s === Running test 012_maintscripts.t ... === 97s 1..14 97s # We are running systemd 100s ok 1 - pg_createcluster 14 main --start 100s ok 2 - postmaster PID is 5257 101s ok 3 - dpkg-reconfigure --frontend=noninteractive postgresql-common 101s ok 4 - postmaster PID is 5257 101s ok 5 - postmaster was not restarted 102s ok 6 - pg_dropcluster 14 main --stop 102s # Cleanup 102s ok 7 - Cleanup: No clusters left behind 102s ok 8 - No postgres processes left behind 102s ok 9 - No files in /etc/postgresql left behind 102s ok 10 - No files in /var/lib/postgresql left behind 102s ok 11 - No files in /var/run/postgresql left behind 102s ok 12 - No files in /var/log/postgresql left behind 102s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 102s ok 14 - PostgreSQL TCP ports are closed 102s === Running test 015_start_stop.t ... === 102s 1..71 102s # We are running systemd 102s # Running tests for 14 102s # Cluster does not exist yet 103s ok 1 - cluster 14 main does not exist 103s ok 2 - service postgresql@14-main does not exist 103s ok 3 - systemctl start postgresql 103s ok 4 - cluster 14 main does not exist 103s ok 5 - service postgresql@14-main does not exist 103s ok 6 - systemctl start postgresql@14-main 103s ok 7 - cluster 14 main does not exist 103s ok 8 - service postgresql@14-main does not exist 103s # Start/stop postgresql using system tools 103s ok 9 - pg_createcluster 14 main 103s ok 10 - cluster 14 main is stopped 103s ok 11 - service postgresql@14-main is stopped 106s ok 12 - systemctl start postgresql 106s ok 13 - cluster 14 main is running 106s ok 14 - service postgresql@14-main is running 106s ok 15 - systemctl start postgresql 106s ok 16 - cluster 14 main is already running 106s ok 17 - service postgresql@14-main is already running 106s ok 18 - systemctl stop postgresql 112s ok 19 - cluster 14 main is stopped 112s ok 20 - service postgresql@14-main is stopped 112s ok 21 - systemctl stop postgresql 112s ok 22 - cluster 14 main is already stopped 112s ok 23 - service postgresql@14-main is already stopped 112s # Start/stop specific cluster using system tools 114s ok 24 - systemctl start postgresql@14-main 114s ok 25 - cluster 14 main is running 114s ok 26 - service postgresql@14-main is running 114s ok 27 - systemctl start postgresql@14-main 114s ok 28 - cluster 14 main is running 114s ok 29 - service postgresql@14-main is running 116s ok 30 - systemctl restart postgresql@14-main 116s ok 31 - cluster 14 main is running 116s ok 32 - service postgresql@14-main is running 117s ok 33 - systemctl stop postgresql@14-main 117s ok 34 - cluster 14 main is stopped 117s ok 35 - service postgresql@14-main is stopped 117s ok 36 - systemctl stop postgresql@14-main 117s ok 37 - cluster 14 main is already stopped 117s ok 38 - service postgresql@14-main is already stopped 118s ok 39 - pg_dropcluster 14 main 118s ok 40 - cluster 14 main does not exist 118s ok 41 - service postgresql@14-main does not exist 118s # Start/stop specific cluster using pg_*cluster 118s ok 42 - pg_ctlcluster start 14 main 118s ok 43 - cluster 14 main does not exist 118s ok 44 - service postgresql@14-main does not exist 121s ok 45 - pg_createcluster 14 main --start 121s ok 46 - cluster 14 main is running 121s ok 47 - service postgresql@14-main is running 121s ok 48 - pg_ctlcluster 14 main start 121s ok 49 - cluster 14 main is already running 121s ok 50 - service postgresql@14-main is already running 123s ok 51 - pg_ctlcluster 14-main restart 123s ok 52 - cluster 14 main is running 123s ok 53 - service postgresql@14-main is running 124s ok 54 - pg_ctlcluster 14 main stop 124s ok 55 - cluster 14 main is stopped 124s ok 56 - service postgresql@14-main is stopped 124s ok 57 - pg_ctlcluster 14 main stop 124s ok 58 - cluster 14 main is already stopped 124s ok 59 - service postgresql@14-main is already stopped 126s ok 60 - pg_ctlcluster start 14-main 126s ok 61 - cluster 14 main is running 126s ok 62 - service postgresql@14-main is running 127s ok 63 - pg_dropcluster 14 main --stop 127s # Cleanup 127s ok 64 - Cleanup: No clusters left behind 127s ok 65 - No postgres processes left behind 127s ok 66 - No files in /etc/postgresql left behind 127s ok 67 - No files in /var/lib/postgresql left behind 127s ok 68 - No files in /var/run/postgresql left behind 127s ok 69 - No files in /var/log/postgresql left behind 127s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 127s ok 71 - PostgreSQL TCP ports are closed 127s === Running test 020_create_sql_remove.t ... === 127s 1..147 127s # Running tests for 14 130s ok 1 - pg_createcluster 14 main --start -- -X /tmp/14.xlog.BQla0N 130s ok 2 - pg_createcluster 14 main 130s ok 3 - Socket and pid file are in /var/run/postgresql/ 130s ok 4 - xlog/wal directory /tmp/14.xlog.BQla0N was created 130s ok 5 - local method in pg_hba.conf is peer 130s ok 6 - host method in pg_hba.conf is scram-sha-256 130s ok 7 - Exactly one postgres master process running 133s ok 8 - pg_ctlcluster 14 main restart 133s ok 9 - cluster restarts with new environment file 133s ok 10 - Exactly one postgres master process running 133s ok 11 - correct value of PGEXTRAVAR1 in environment 133s ok 12 - correct value of PGEXTRAVAR2 in environment 133s ok 13 - Socket and stats dir, but not PID file in /var/run/postgresql/ 133s ok 14 - createdb --version 133s ok 15 - pg_wrapper selects version number of cluster 133s ok 16 - psql --version 133s ok 17 - pg_wrapper selects version number of cluster 133s ok 18 - pg_lscluster reports online cluster on port 5432 133s ok 19 - log file is actually used 133s ok 20 - /etc/postgresql is owned by user "postgres" 133s ok 21 - version configuration directory file is owned by user "postgres" 133s ok 22 - configuration directory file is owned by user "postgres" 133s ok 23 - version data directory file is owned by user "postgres" 133s ok 24 - data directory file is owned by user "postgres" 133s ok 25 - log file has 0640 permissions 133s ok 26 - log file is owned by user "postgres" 133s ok 27 - log file is owned by group "adm" 133s ok 28 - no log symlink by default 133s ok 29 - /var/log/postgresql/postgresql-14-main.log is the default log if log symlink is missing 133s ok 30 - pg_lsclusters -h 133s ok 31 - correct output of pg_lsclusters -h 133s ok 32 - stopping cluster 136s ok 33 - restarting cluster with nondefault log symlink 136s ok 34 - log target is used as log file 136s ok 35 - default log is not used 136s ok 36 - pg_lsclusters -h 136s ok 37 - correct output of pg_lsclusters -h 136s ok 38 - stopping cluster 138s ok 39 - restarting cluster with explicitly configured log file 138s ok 40 - default log is not used 138s ok 41 - log symlink target is used for startup message 138s ok 42 - exactly one log file 138s ok 43 - custom log is actually used 138s ok 44 - pg_lsclusters -h 138s ok 45 - correct output of pg_lsclusters -h 139s ok 46 - stopping cluster 139s ok 47 - starting cluster with rouge /var/log/postgresql symlink fails 139s ok 48 - /etc/postgres-hack was not created 141s ok 49 - restarting cluster 141s ok 50 - ps -o tty -U postgres h 141s ok 51 - postgres processes do not have an associated terminal 141s ok 52 - Server is linked with SSL support 141s ok 53 - SSL is enabled in postgresql.conf 141s ok 54 - psql -l fails for nobody 141s ok 55 - createuser nobody 141s ok 56 - createdb nobodydb 141s ok 57 - psql -ltA succeeds for nobody 141s ok 58 - psql -ltA output 141s ok 59 - SQL command: create table 141s ok 60 - SQL command: insert into table values 141s ok 61 - SQL command: insert into table values 141s ok 62 - primary key violation 141s ok 63 - psql -tAc "select * from phone order by name" nobodydb 141s ok 64 - SQL command output: select -tA 141s ok 65 - psql -txc "select * from phone where name = 'Alice'" nobodydb 141s ok 66 - SQL command output: select -tx 141s ok 67 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 141s ok 68 - SQL command output: select -tAx 141s ok 69 - CREATE EXTENSION plperlu fails for user nobody 141s ok 70 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 141s ok 71 - CREATE EXTENSION plperlu succeeds for user postgres 141s ok 72 - creating PL/PerlU function as user nobody fails 141s ok 73 - creating unsafe PL/Perl function as user postgres fails 141s ok 74 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 141s ok 75 - creating PL/PerlU function as user postgres succeeds 141s ok 76 - psql nobodydb -Atc "select read_file()" 141s ok 77 - calling PL/PerlU function 142s ok 78 - psql -qc 'CREATE EXTENSION plperl' nobodydb 142s ok 79 - CREATE EXTENSION plperl succeeds for user nobody 142s ok 80 - creating unsafe PL/Perl function as user nobody fails 142s ok 81 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 142s ok 82 - creating PL/Perl function as user nobody succeeds 142s ok 83 - psql nobodydb -Atc "select remove_vowels('foobArish')" 142s ok 84 - calling PL/Perl function 142s ok 85 # skip No python2 support 142s ok 86 # skip No python2 support 142s ok 87 # skip No python2 support 142s ok 88 # skip No python2 support 142s ok 89 # skip No python2 support 142s ok 90 # skip No python2 support 142s ok 91 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 142s ok 92 - CREATE EXTENSION plpython3u succeeds for user postgres 142s ok 93 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 142s ok 94 - creating PL/Python3 function as user postgres succeeds 142s ok 95 - psql nobodydb -Atc "select capitalize3('foo')" 142s ok 96 - calling PL/Python function 142s ok 97 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 142s ok 98 - CREATE EXTENSION pltcl succeeds for user postgres 142s ok 99 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 142s ok 100 - CREATE EXTENSION pltclu succeeds for user postgres 142s ok 101 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 142s ok 102 - creating PL/Tcl function as user nobody succeeds 142s 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;" 142s ok 104 - creating PL/TclU function as user postgres succeeds 142s ok 105 - psql nobodydb -Atc "select tcl_max(3,4)" 142s ok 106 - calling PL/Tcl function 142s ok 107 - psql nobodydb -Atc "select tcl_max_u(5,4)" 142s ok 108 - calling PL/TclU function 142s ok 109 - stopping cluster 142s ok 110 - pg_ctlcluster 14 main start 142s ok 111 - cluster fails to start with invalid data_directory and valid pgdata symlink 144s ok 112 - pg_ctlcluster 14 main start 144s ok 113 - cluster restarts with pgdata symlink 145s ok 114 - postgres master has OOM killer protection 145s ok 115 - postgres client backend has no OOM adjustment 145s ok 116 - ps h 6833 145s ok 117 - process title is idle 145s ok 118 - ps h 6833 145s ok 119 - process title is idle in transaction 146s ok 120 - stopping cluster 148s ok 121 - starting cluster as postgres works without a log file 148s ok 122 - log file got recreated and used 148s ok 123 - creating a directory in spc2 148s ok 124 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/14.spc1.ie_lBd'" 148s ok 125 - creating tablespace spc1 148s ok 126 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 148s ok 127 - creating a table in spc1 148s ok 128 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/14.spc2.Db2aY3'" 148s ok 129 - creating tablespace spc2 148s ok 130 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 148s ok 131 - creating a table in spc2 148s ok 132 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 148s ok 133 - Correct apt NeverAutoRemove config 149s ok 134 - pg_dropcluster removes cluster 149s ok 135 - xlog/wal directory /tmp/14.xlog.BQla0N was deleted 149s ok 136 - tablespace spc1 was emptied 149s ok 137 - tablespace spc2 was emptied 149s ok 138 - egrep -o 'postgresql.[0-9.*-]+' /etc/apt/apt.conf.d/02autoremove-postgresql 149s ok 139 - Correct apt NeverAutoRemove config 149s # Cleanup 149s ok 140 - Cleanup: No clusters left behind 149s ok 141 - No postgres processes left behind 149s ok 142 - No files in /etc/postgresql left behind 149s ok 143 - No files in /var/lib/postgresql left behind 149s ok 144 - No files in /var/run/postgresql left behind 149s ok 145 - No files in /var/log/postgresql left behind 149s ok 146 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 149s ok 147 - PostgreSQL TCP ports are closed 149s === Running test 021_pg_renamecluster.t ... === 149s 1..20 152s ok 1 - pg_createcluster 14 main 155s ok 2 - pg_renamecluster 14 main donau 155s ok 3 - psql -tAc "show data_directory" 155s ok 4 - cluster is running and data_directory was moved 155s ok 5 - pg_hba.conf location updated 155s ok 6 - pg_ident.conf location updated 155s ok 7 - external_pid_file location updated 155s ok 8 - external_pid_file exists 155s ok 9 - stats_temp_directory location updated 155s ok 10 - stats_temp_directory exists 155s ok 11 - cluster_name is updated 156s ok 12 - pg_dropcluster removes cluster 156s # Cleanup 156s ok 13 - Cleanup: No clusters left behind 156s ok 14 - No postgres processes left behind 156s ok 15 - No files in /etc/postgresql left behind 156s ok 16 - No files in /var/lib/postgresql left behind 156s ok 17 - No files in /var/run/postgresql left behind 156s ok 18 - No files in /var/log/postgresql left behind 156s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 156s ok 20 - PostgreSQL TCP ports are closed 156s === Running test 022_recovery.t ... === 156s 1..17 156s # Running tests for 14 159s ok 1 - pg_createcluster 14 main --start >/dev/null 159s ok 2 - pg_ctlcluster 14 main stop -m i 162s ok 3 - pg_ctlcluster 14 main start 162s ok 4 - psql -c '' 162s ok 5 - pg_ctlcluster 14 main stop -m i 162s ok 6 - create write-protected file in data directory 164s ok 7 - pg_ctlcluster 14 main start 164s ok 8 - psql -c '' 166s ok 9 - pg_dropcluster removes cluster 166s # Cleanup 166s ok 10 - Cleanup: No clusters left behind 166s ok 11 - No postgres processes left behind 166s ok 12 - No files in /etc/postgresql left behind 166s ok 13 - No files in /var/lib/postgresql left behind 166s ok 14 - No files in /var/run/postgresql left behind 166s ok 15 - No files in /var/log/postgresql left behind 166s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 166s ok 17 - PostgreSQL TCP ports are closed 166s === Running test 025_logging.t ... === 166s 1..55 166s # Logging to /var/log/syslog works 166s # Running tests for 14 169s ok 1 - pg_createcluster 14 main 169s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-14-main.log 169s ok 3 - psql -qc "'foobar_14_7741'" 169s ok 4 - log an error 170s ok 5 - grep --binary-files=text foobar_14_7741 /var/log/postgresql/postgresql-14-main.log 170s ok 6 - error appears in logfile 170s ok 7 - pg_conftool 14 main set log_destination syslog 170s ok 8 - set log_destination syslog 170s ok 9 - pg_ctlcluster 14 main reload 170s ok 10 - 14 main reload 170s ok 11 - psql -Atc "show log_destination" 170s ok 12 - log_destination is syslog 170s ok 13 - pg_lscluster reports syslog 170s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 170s ok 15 - error appears in /var/log/syslog 171s ok 16 - pg_conftool 14 main set logging_collector on 171s ok 17 - set logging_collector on 171s ok 18 - pg_conftool 14 main set log_destination csvlog 171s ok 19 - set log_destination csvlog 173s ok 20 - pg_ctlcluster 14 main restart 173s ok 21 - 14 main restart 173s ok 22 - psql -Atc "show logging_collector" 173s ok 23 - logging_collector is on 173s ok 24 - psql -Atc "show log_destination" 173s ok 25 - log_destination is csvlog 173s ok 26 - pg_lscluster reports csvlog 173s ok 27 - psql -qc "'barbaz_14_7741'" 173s ok 28 - log an error 174s ok 29 - grep --binary-files=text barbaz_14_7741 /var/lib/postgresql/14/main/log/*.csv 174s ok 30 - error appears in log/*.csv 174s ok 31 - pg_conftool 14 main set log_destination stderr,syslog,csvlog 174s ok 32 - set log_destination stderr,syslog,csvlog 174s ok 33 - pg_ctlcluster 14 main reload 174s ok 34 - 14 main reload 174s ok 35 - psql -Atc "show log_destination" 174s ok 36 - log_destination is stderr,syslog,csvlog 174s ok 37 - pg_lscluster reports stderr,syslog,csvlog 174s ok 38 - psql -qc "'moo_14_7741'" 174s ok 39 - log an error 174s ok 40 - grep --binary-files=text moo_14_7741 /var/lib/postgresql/14/main/log/*.log 174s ok 41 - error appears in log/*.log 175s ok 42 - grep --binary-files=text 'postgres.*moo_14_7741' /var/log/syslog 175s ok 43 - error appears in /var/log/syslog 175s ok 44 - grep --binary-files=text moo_14_7741 /var/lib/postgresql/14/main/log/*.csv 175s ok 45 - error appears in log/*.csv 176s ok 46 - pg_dropcluster 14 main --stop 176s ok 47 - pg_dropcluster removes cluster 176s # Cleanup 176s ok 48 - Cleanup: No clusters left behind 176s ok 49 - No postgres processes left behind 176s ok 50 - No files in /etc/postgresql left behind 176s ok 51 - No files in /var/lib/postgresql left behind 176s ok 52 - No files in /var/run/postgresql left behind 176s ok 53 - No files in /var/log/postgresql left behind 176s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 176s ok 55 - PostgreSQL TCP ports are closed 176s === Running test 030_errors.t ... === 176s 1..156 176s ok 1 - pg_lscluster reports cluster without binaries 177s ok 2 - pg_dropcluster 6.3 main 178s ok 3 - pg_createcluster --socketdir 178s ok 4 - pg_lsclusters -h 178s ok 5 - cluster was created 178s ok 6 - Port of created cluster is 5432 178s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 14 main 178s ok 8 - pg_createcluster on existing cluster 178s ok 9 - pg_lsclusters -h 178s ok 10 - original cluster still exists 178s ok 11 - pg_createcluster 14 test -p foo 178s ok 12 - pg_createcluster -p checks that port option is numeric 178s ok 13 - pg_createcluster 14 test -p 42 178s ok 14 - pg_createcluster -p checks valid port range 178s ok 15 - pg_ctlcluster 14 main start 178s ok 16 - pg_ctlcluster refuses to start root-owned cluster 178s ok 17 - pg_ctlcluster 14 main start 178s ok 18 - pg_ctlcluster fails on invalid cluster owner uid 178s ok 19 - pg_ctlcluster 14 main start 178s ok 20 - pg_ctlcluster as root fails on invalid cluster owner gid 178s ok 21 - pg_ctlcluster 14 main start 178s ok 22 - pg_ctlcluster as postgres fails on invalid cluster owner gid 180s ok 23 - pg_ctlcluster succeeds on valid cluster owner uid/gid 180s ok 24 - No sockets in /var/run/postgresql 180s ok 25 - Socket is in /tmp/postgresql-testsuite/ 181s ok 26 - cluster stops with custom unix_socket_dir 181s ok 27 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 183s ok 28 - cluster starts after removing unix_socket_dir 183s ok 29 - Socket is in default dir /var/run/postgresql 183s ok 30 - No sockets in /tmp/postgresql-testsuite/ 183s ok 31 - pg_ctlcluster 14 main stop 183s ok 32 - pg_ctlcluster fails with corrupted PID file 183s ok 33 - pg_lsclusters -h 183s ok 34 - cluster is still online 183s ok 35 - pg_ctlcluster succeeds with restored PID file 183s ok 36 - pg_lsclusters -h 183s ok 37 - cluster is down 183s ok 38 - pg_ctlcluster 14 main stop 183s ok 39 - pg_ctlcluster stop fails on stopped cluster 185s ok 40 - pg_ctlcluster 14 main start 185s ok 41 - pg_ctlcluster succeeds with already existing PID file 185s ok 42 - pg_lsclusters -h 185s ok 43 - cluster is online 185s ok 44 - pg_ctlcluster stop succeeds 185s ok 45 - pg_lsclusters -h 185s ok 46 - cluster is down 185s ok 47 - no pid file left 185s ok 48 - pg_ctlcluster 14 main stop 185s ok 49 - pg_ctlcluster stop succeeds with corrupted PID file 185s ok 50 - pid file was cleaned up 186s ok 51 - pg_ctlcluster --force 14 main stop 186s ok 52 - pg_ctlcluster --force stop succeeds with corrupted PID file 186s ok 53 - pid file was cleaned up 186s ok 54 - pg_ctlcluster 14 main stop 186s ok 55 - pg_ctlcluster stop succeeds with stale PID file 186s ok 56 - pid file was cleaned up 186s ok 57 - pg_ctlcluster --force 14 main stop 186s ok 58 - pg_ctlcluster --force stop succeeds with stale PID file 186s ok 59 - pid file was cleaned up 186s ok 60 - pg_ctlcluster --force 14 main stop 186s ok 61 - pg_ctlcluster stop succeeds with empty PID file 186s ok 62 - pid file was cleaned up 188s ok 63 - pg_ctlcluster 14 main start 188s ok 64 - pg_ctlcluster succeeds with corrupted PID file 188s ok 65 - pg_lsclusters -h 188s ok 66 - cluster is online 188s ok 67 - pg_ctlcluster 14 main start 188s ok 68 - pg_ctlcluster start fails on running cluster 188s ok 69 - pg_ctlcluster stop 188s ok 70 - pg_ctlcluster 14 main start 188s ok 71 - pg_ctlcluster start fails on invalid pg_hba.conf 188s ok 72 - pg_ctlcluster 14 main stop 188s ok 73 - stopping cluster 194s ok 74 - pg_ctlcluster 14 main start 194s ok 75 - pg_ctlcluster start warns about absence of passwordless superuser connection 195s ok 76 - pg_ctlcluster 14 main stop 195s ok 77 - stopping cluster 195s ok 78 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 195s ok 79 - pg_dropcluster 14 main 195s ok 80 - pg_dropcluster works as user postgres 196s ok 81 - pg_createcluster succeeds 196s ok 82 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 196s ok 83 - proper error message for nonexisting /var/lib/postgresql 198s ok 84 - pg_ctlcluster 14 main start 198s ok 85 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 198s ok 86 - pg_ctlcluster 14 main stop 198s ok 87 - stopping cluster 199s ok 88 - pg_createcluster other 201s ok 89 - pg_ctlcluster: main cluster on conflicting port starts 203s ok 90 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 203s ok 91 203s ok 92 - pg_ctlcluster 14 other start 203s ok 93 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 203s ok 94 - pg_ctlcluster 14 main stop 203s ok 95 - stopping main cluster 206s ok 96 - pg_ctlcluster: other cluster on conflicting port starts after main is down 207s ok 97 - pg_dropcluster other 208s ok 98 - pg_dropcluster 208s ok 99 - No sockets any more 208s ok 100 - 'pg_lsclusters 4.5 foo' fails 208s ok 101 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 208s ok 102 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 208s ok 103 - 'psql --cluster 4.5/foo' fails 208s ok 104 - psql --cluster 4.5/foo gives error message about nonexisting cluster 208s ok 105 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 208s ok 106 - 'psql --cluster 14/foo' fails 208s ok 107 - psql --cluster 14/foo gives error message about nonexisting cluster 208s ok 108 - psql --cluster 14/foo does not print 'invalid symbolic link' gibberish 208s ok 109 - 'pg_dropcluster 4.5 foo' fails 208s ok 110 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 208s ok 111 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 208s ok 112 - 'pg_dropcluster 14 foo' fails 208s ok 113 - pg_dropcluster 14 foo gives error message about nonexisting cluster 208s ok 114 - pg_dropcluster 14 foo does not print 'invalid symbolic link' gibberish 208s ok 115 - 'pg_upgradecluster 4.5 foo' fails 208s ok 116 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 208s ok 117 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 208s ok 118 - 'pg_upgradecluster 14 foo' fails 208s ok 119 - pg_upgradecluster 14 foo gives error message about nonexisting cluster 208s ok 120 - pg_upgradecluster 14 foo does not print 'invalid symbolic link' gibberish 208s ok 121 - 'pg_ctlcluster 4.5 foo stop' fails 208s ok 122 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 208s ok 123 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 208s ok 124 - 'pg_ctlcluster 14 foo stop' fails 208s ok 125 - pg_ctlcluster 14 foo stop gives error message about nonexisting cluster 208s ok 126 - pg_ctlcluster 14 foo stop does not print 'invalid symbolic link' gibberish 208s # Cleanup 208s ok 127 - Cleanup: No clusters left behind 208s ok 128 - No postgres processes left behind 208s ok 129 - No files in /etc/postgresql left behind 208s ok 130 - No files in /var/lib/postgresql left behind 208s ok 131 - No files in /var/run/postgresql left behind 208s ok 132 - No files in /var/log/postgresql left behind 208s ok 133 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 208s ok 134 - PostgreSQL TCP ports are closed 209s ok 135 - pg_dropcluster 14 broken 209s ok 136 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 209s # Cleanup 209s ok 137 - Cleanup: No clusters left behind 209s ok 138 - No postgres processes left behind 209s ok 139 - No files in /etc/postgresql left behind 209s ok 140 - No files in /var/lib/postgresql left behind 209s ok 141 - No files in /var/run/postgresql left behind 209s ok 142 - No files in /var/log/postgresql left behind 209s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 209s ok 144 - PostgreSQL TCP ports are closed 210s ok 145 - pg_dropcluster 14 broken 210s ok 146 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 210s ok 147 - /etc/postgresql/14 was removed 210s ok 148 - /var/lib/postgresql/14 was removed 210s # Cleanup 210s ok 149 - Cleanup: No clusters left behind 210s ok 150 - No postgres processes left behind 210s ok 151 - No files in /etc/postgresql left behind 210s ok 152 - No files in /var/lib/postgresql left behind 210s ok 153 - No files in /var/run/postgresql left behind 210s ok 154 - No files in /var/log/postgresql left behind 210s ok 155 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 210s ok 156 - PostgreSQL TCP ports are closed 210s === Running test 031_errors_disk_full.t ... === 210s 1..22 210s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 211s ok 1 - script failed 211s ok 2 - pg_createcluster fails due to insufficient disk space 211s ok 3 - does not leave files behind 211s # Cleanup 211s ok 4 - Cleanup: No clusters left behind 211s ok 5 - No postgres processes left behind 211s ok 6 - No files in /etc/postgresql left behind 211s ok 7 - No files in /var/lib/postgresql left behind 211s ok 8 - No files in /var/run/postgresql left behind 211s ok 9 - No files in /var/log/postgresql left behind 211s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 211s ok 11 - PostgreSQL TCP ports are closed 211s # check disk full conditions on startup 213s ok 12 - script failed 213s ok 13 - pg_ctlcluster prints error message 213s ok 14 - log file has error message 213s # Cleanup 213s ok 15 - Cleanup: No clusters left behind 213s ok 16 - No postgres processes left behind 213s ok 17 - No files in /etc/postgresql left behind 213s ok 18 - No files in /var/lib/postgresql left behind 213s ok 19 - No files in /var/run/postgresql left behind 213s ok 20 - No files in /var/log/postgresql left behind 213s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 213s ok 22 - PostgreSQL TCP ports are closed 213s === Running test 032_ssl_key_permissions.t ... === 213s 1..22 213s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 213s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 213s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 213s # 14 (14.15-0ubuntu0.22.04.1) 214s ok 4 - pg_createcluster 14 main 214s ok 5 - pg_ctlcluster 14 main start 214s ok 6 - ssl key owned by nobody refused 215s ok 7 - pg_ctlcluster 14 main start 215s ok 8 - ssl key with permissions root:root 0644 refused 215s ok 9 - pg_ctlcluster 14 main start 215s ok 10 - ssl key with permissions postgres:postgres 0640 refused 216s ok 11 - pg_dropcluster 14 main --stop 216s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 216s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 216s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 216s # Cleanup 216s ok 15 - Cleanup: No clusters left behind 216s ok 16 - No postgres processes left behind 216s ok 17 - No files in /etc/postgresql left behind 216s ok 18 - No files in /var/lib/postgresql left behind 216s ok 19 - No files in /var/run/postgresql left behind 216s ok 20 - No files in /var/log/postgresql left behind 216s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 216s ok 22 - PostgreSQL TCP ports are closed 216s === Running test 040_upgrade.t ... === 216s 1..1 216s ok 1 - only one major version installed, skipping upgrade tests 216s === Running test 041_upgrade_custompaths.t ... === 216s 1..1 216s ok 1 - only one major version installed, skipping upgrade tests 216s === Running test 043_upgrade_ssl_cert.t ... === 216s 1..1 216s ok 1 - only one major version installed, skipping upgrade tests 216s === Running test 045_backup.t ... === 216s # We are running systemd 216s # PostgreSQL 14 216s # create cluster 219s ok 1 - pg_createcluster --locale en_US.UTF-8 14 main --start 219s ok 2 - pg_lsclusters -h 219s ok 3 - correct output of pg_lsclusters -h 219s ok 4 - pg_conftool 14 main set work_mem 11MB 219s ok 5 - createdb -E SQL_ASCII -T template0 mydb 219s ok 6 - psql -c 'alter database mydb set search_path=public' 219s ok 7 - psql -c 'create table foo (t text)' mydb 219s ok 8 - psql -c "insert into foo values ('important data')" mydb 219s ok 9 - psql -c 'CREATE USER myuser' 219s ok 10 - psql -c 'alter role myuser set search_path=public, myschema' 219s ok 11 - psql -c 'alter role myuser in database mydb set search_path=public, myotherschema' 219s # create directory 219s ok 12 - pg_backupcluster 14 main createdirectory 219s ok 13 - /var/backups/postgresql/14-main owned by uid postgres 219s ok 14 - /var/backups/postgresql/14-main owned by gid postgres 219s # dump 220s ok 15 - systemctl start pg_dump@14-main 220s ok 16 - dump created in /var/backups/postgresql/14-main/2025-02-26T132832Z.dump 220s ok 17 - /var/backups/postgresql/14-main/2025-02-26T132832Z.dump owned by uid postgres 220s ok 18 - /var/backups/postgresql/14-main/2025-02-26T132832Z.dump owned by gid postgres 220s # basebackup 220s ok 19 - systemctl start pg_receivewal@14-main 226s ok 20 - systemctl start pg_basebackup@14-main 226s ok 21 - dump created in /var/backups/postgresql/14-main/2025-02-26T132832Z.backup 226s ok 22 - /var/backups/postgresql/14-main/2025-02-26T132832Z.backup owned by uid postgres 226s ok 23 - /var/backups/postgresql/14-main/2025-02-26T132832Z.backup owned by gid postgres 226s # list 226s ok 24 - pg_backupcluster 14 main list 226s ok 25 - correct output of pg_backupcluster 14 main list 226s # more database changes 226s ok 26 - psql -c "insert into foo values ('some other data')" mydb 226s ok 27 - psql -c "insert into foo values ('yet more data')" mydb 226s ok 28 - retrieve recovery timestamp 226s ok 29 - psql -c "delete from foo where t = 'some other data'" mydb 227s ok 30 - systemctl stop pg_receivewal@14-main 227s # restore /var/backups/postgresql/14-main/2025-02-26T132832Z.dump 228s ok 31 - pg_dropcluster 14 main --stop 232s ok 32 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132832Z.dump --start --datadir /var/lib/postgresql/14/snowflake 232s ok 33 - pg_lsclusters -h 232s ok 34 - correct output of pg_lsclusters -h 232s ok 35 - psql -XAtl 232s ok 36 - correct output of psql -XAtl 232s ok 37 - psql -XAtc 'show work_mem' 232s ok 38 - correct output of psql -XAtc 'show work_mem' 232s ok 39 - psql -XAtc 'select * from foo' mydb 232s ok 40 - correct output of psql -XAtc 'select * from foo' mydb 232s ok 41 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 232s ok 42 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 232s ok 43 - psql -XAtc '\drds' 232s ok 44 - correct output of psql -XAtc '\drds' 232s # restore /var/backups/postgresql/14-main/2025-02-26T132832Z.backup 233s ok 45 - pg_dropcluster 14 main --stop 236s ok 46 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132832Z.backup --start --datadir /var/lib/postgresql/14/snowflake 236s ok 47 - pg_lsclusters -h 236s ok 48 - correct output of pg_lsclusters -h 236s ok 49 - psql -XAtl 236s ok 50 - correct output of psql -XAtl 236s ok 51 - psql -XAtc 'show work_mem' 236s ok 52 - correct output of psql -XAtc 'show work_mem' 237s ok 53 - psql -XAtc 'select * from foo' mydb 237s ok 54 - correct output of psql -XAtc 'select * from foo' mydb 237s ok 55 - psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 237s ok 56 - correct output of psql -XAtc "select analyze_count from pg_stat_user_tables where relname = 'foo'" mydb 237s ok 57 - psql -XAtc '\drds' 237s ok 58 - correct output of psql -XAtc '\drds' 237s # restore /var/backups/postgresql/14-main/2025-02-26T132832Z.backup with WAL archive 238s ok 59 - pg_dropcluster 14 main --stop 241s ok 60 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132832Z.backup --start --archive --port 5430 241s ok 61 - pg_lsclusters -h 241s ok 62 - correct output of pg_lsclusters -h 241s ok 63 - psql -XAtc 'select * from foo order by t' mydb 241s ok 64 - correct output of psql -XAtc 'select * from foo order by t' mydb 241s # restore /var/backups/postgresql/14-main/2025-02-26T132832Z.backup with PITR 242s ok 65 - pg_dropcluster 14 main --stop 246s ok 66 - pg_restorecluster 14 main /var/backups/postgresql/14-main/2025-02-26T132832Z.backup --start --pitr '2025-02-26 13:28:38.867072+00 246s # ' 246s ok 67 - pg_lsclusters -h 246s ok 68 - correct output of pg_lsclusters -h 246s ok 69 - psql -XAtc 'select * from foo order by t' mydb 246s ok 70 - correct output of psql -XAtc 'select * from foo order by t' mydb 247s ok 71 - pg_dropcluster 14 main --stop 247s # Cleanup 247s ok 72 - Cleanup: No clusters left behind 247s ok 73 - No postgres processes left behind 247s ok 74 - No files in /etc/postgresql left behind 247s ok 75 - No files in /var/lib/postgresql left behind 247s ok 76 - No files in /var/run/postgresql left behind 247s ok 77 - No files in /var/log/postgresql left behind 247s ok 78 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 247s ok 79 - PostgreSQL TCP ports are closed 247s 1..79 247s === Running test 050_encodings.t ... === 247s 1..60 247s # Checking 14 ru_RU 250s ok 1 - pg_createcluster version 14 for ru_RU without --encoding succeeded 251s ok 2 - psql -l succeeds 251s ok 3 - template1 is not UTF-8 encoded 251s ok 4 - creating test database 251s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 251s # create table t (x varchar); copy t from stdin" test 251s ok 6 - creating table with ISO-8859-5 characters 251s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 251s ok 8 - correct string in UTF-8 251s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 251s ok 10 - correct string in ISO-8859-5 251s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 251s # delete from t; copy t from stdin" test 251s ok 12 - creating table with UTF-8 characters 251s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 251s ok 14 - correct string in UTF-8 251s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 251s ok 16 - correct string in ISO-8859-1 251s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 251s ok 18 - Server error message has correct language and encoding 254s ok 19 - pg_ctlcluster 14 ru_RU restart 254s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 255s ok 21 - Dropping cluster 255s # Checking 14 ru_RU.UTF-8 258s ok 22 - pg_createcluster version 14 for ru_RU.UTF-8 without --encoding succeeded 259s ok 23 - psql -l succeeds 259s ok 24 - template1 is UTF-8 encoded 259s ok 25 - creating test database 259s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 259s # create table t (x varchar); copy t from stdin" test 259s ok 27 - creating table with ISO-8859-5 characters 259s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 259s ok 29 - correct string in UTF-8 259s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 259s ok 31 - correct string in ISO-8859-5 259s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 259s # delete from t; copy t from stdin" test 259s ok 33 - creating table with UTF-8 characters 259s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 259s ok 35 - correct string in UTF-8 259s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 259s ok 37 - correct string in ISO-8859-1 259s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 259s ok 39 - Server error message has correct language and encoding 262s ok 40 - pg_ctlcluster 14 ru_RU.UTF8 restart 262s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 262s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 262s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 262s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 262s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 262s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 262s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 263s ok 48 - Dropping cluster 263s # Check 14 locale environment variables 266s ok 49 - pg_createcluster: LC_ALL dominates LANG 266s ok 50 - psql -Atl --cluster 14/main 266s ok 51 - template1 is ASCII encoded 267s ok 52 - Dropping cluster 267s # Cleanup 267s ok 53 - Cleanup: No clusters left behind 267s ok 54 - No postgres processes left behind 267s ok 55 - No files in /etc/postgresql left behind 267s ok 56 - No files in /var/lib/postgresql left behind 267s ok 57 - No files in /var/run/postgresql left behind 267s ok 58 - No files in /var/log/postgresql left behind 267s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 267s ok 60 - PostgreSQL TCP ports are closed 267s === Running test 052_upgrade_encodings.t ... === 267s 1..1 267s ok 1 - only one major version installed, skipping upgrade tests 267s === Running test 060_obsolete_confparams.t ... === 268s ok 1 - only one major version installed, skipping upgrade tests 268s 1..1 268s === Running test 070_non_postgres_clusters.t ... === 268s 1..40 269s ok 1 - pg_createcluster 14 main for owner nobody 269s ok 2 - pg_ctlcluster 14 main start 269s ok 3 - start refused when config and data owners mismatch 271s ok 4 - pg_ctlcluster succeeds with owner nobody 271s ok 5 - pg_lsclusters -h 271s ok 6 - pg_lsclusters shows running cluster 271s ok 7 - postgres is running as user nobody 271s ok 8 - ls /tmp/.s.PGSQL.* 271s ok 9 - socket is in /tmp 271s ok 10 - /var/run/postgresql is empty 271s ok 11 - conf dir is owned by user 271s ok 12 - conf dir is owned by user's primary group 271s ok 13 - files are owned by user 271s ok 14 - files are owned by user's primary group 271s ok 15 - log file has 0640 permissions 271s ok 16 - log file is owned by user 271s ok 17 - log file is owned by user's primary group 271s ok 18 - only one major version installed, skipping upgrade test 271s ok 19 - ... 271s ok 20 - ... 271s ok 21 - ... 271s ok 22 - ... 271s ok 23 - ... 271s ok 24 - ... 271s ok 25 - ... 271s ok 26 - ... 271s ok 27 - ... 271s ok 28 - ... 272s ok 29 - pg_dropcluster 272s ok 30 - pg_lsclusters -h 272s ok 31 - No clusters left 272s ok 32 - No postgres processes left 272s # Cleanup 272s ok 33 - Cleanup: No clusters left behind 272s ok 34 - No postgres processes left behind 272s ok 35 - No files in /etc/postgresql left behind 272s ok 36 - No files in /var/lib/postgresql left behind 272s ok 37 - No files in /var/run/postgresql left behind 272s ok 38 - No files in /var/log/postgresql left behind 272s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 272s ok 40 - PostgreSQL TCP ports are closed 272s === Running test 080_start.conf.t ... === 272s 1..73 273s ok 1 - pg_createcluster 14 main 273s # start.conf auto 273s ok 2 - get_cluster_start_conf returns auto 273s ok 3 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 273s ok 4 - start.conf contains auto 273s ok 5 - systemd generator links cluster 273s ok 6 - systemd generator links correct service file 275s ok 7 - /etc/init.d/postgresql start 14 275s ok 8 - correct output of /etc/init.d/postgresql start 14 275s ok 9 - pg_lsclusters -h 275s ok 10 - cluster is online 275s ok 11 - /etc/init.d/postgresql stop 14 275s ok 12 - correct output of /etc/init.d/postgresql stop 14 278s ok 13 - pg_lsclusters -h 278s ok 14 - cluster is down 278s # start.conf manual 278s ok 15 - get_cluster_start_conf returns manual 278s ok 16 - grep '^[^\\s\#]' /etc/postgresql/14/main/start.conf 278s ok 17 - start.conf contains manual 278s ok 18 - systemd generator doesn't link cluster 278s ok 19 - /etc/init.d/postgresql start 14 278s ok 20 - correct output of /etc/init.d/postgresql start 14 279s ok 21 - pg_lsclusters -h 279s ok 22 - cluster is down 281s ok 23 - pg_ctlcluster 14 main start 281s ok 24 - correct output of pg_ctlcluster 14 main start 281s ok 25 - pg_lsclusters -h 281s ok 26 - cluster is online 281s ok 27 - pg_ctlcluster 14 main stop 281s ok 28 - correct output of pg_ctlcluster 14 main stop 281s ok 29 - pg_lsclusters -h 281s ok 30 - cluster is down 281s # start.conf disabled 281s ok 31 - get_cluster_start_conf returns disabled 281s ok 32 - systemd generator doesn't link cluster 281s ok 33 - /etc/init.d/postgresql start 14 281s ok 34 - correct output of /etc/init.d/postgresql start 14 281s ok 35 - pg_lsclusters -h 281s ok 36 - cluster is down 281s ok 37 - pg_ctlcluster 14 main start 281s ok 38 - correct output of pg_ctlcluster 14 main start 281s ok 39 - pg_lsclusters -h 281s ok 40 - cluster is down 283s ok 41 - pg_ctlcluster 14 main start 283s ok 42 - correct output of pg_ctlcluster 14 main start 283s ok 43 - pg_lsclusters -h 283s ok 44 - cluster is online 284s ok 45 - pg_ctlcluster 14 main stop 284s ok 46 - correct output of pg_ctlcluster 14 main stop 284s ok 47 - pg_lsclusters -h 284s ok 48 - cluster is down 286s ok 49 - pg_ctlcluster 14 main start 286s ok 50 - correct output of pg_ctlcluster 14 main start 286s ok 51 - pg_lsclusters -h 286s ok 52 - cluster is online 286s # test upgrade 286s ok 53 - only one major version installed, skipping upgrade test 286s ok 54 - ... 286s ok 55 - get_cluster_start_conf for old cluster returns manual 286s ok 56 - get_cluster_start_conf for new cluster returns manual 286s ok 57 - ... 287s ok 58 - dropping upgraded cluster 287s ok 59 - pg_lsclusters -h 287s ok 60 - no clusters any more 287s ok 61 - pg_createcluster 14 main --start-conf foo 287s ok 62 - pg_createcluster checks --start-conf validity 288s ok 63 - pg_createcluster checks --start-conf manual 288s ok 64 - get_cluster_start_conf returns manual 289s ok 65 - dropping cluster 289s # Cleanup 289s ok 66 - Cleanup: No clusters left behind 289s ok 67 - No postgres processes left behind 289s ok 68 - No files in /etc/postgresql left behind 289s ok 69 - No files in /var/lib/postgresql left behind 289s ok 70 - No files in /var/run/postgresql left behind 289s ok 71 - No files in /var/log/postgresql left behind 289s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 289s ok 73 - PostgreSQL TCP ports are closed 289s === Running test 085_pg_ctl.conf.t ... === 289s 1..29 289s ok 1 - pg_createcluster 14 main 289s ok 2 - /etc/postgresql/14/main/pg_ctl.conf exists 292s ok 3 - pg_ctlcluster 14 main start 292s ok 4 - starting cluster 292s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 292s ok 6 - soft core size is 0 292s ok 7 - set pg_ctl default option to -c 294s ok 8 - pg_ctlcluster 14 main restart 294s ok 9 - restarting cluster 294s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 294s ok 11 - soft core size is unlimited 294s ok 12 - restored pg_ctl default option 296s ok 13 - pg_ctlcluster 14 main restart 296s ok 14 - restarting cluster 296s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 296s ok 16 - soft core size is 0 299s ok 17 - pg_ctlcluster 14 main restart -- -c 299s ok 18 - restarting cluster with -c on the command line 299s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/14-main.pid 299s ok 20 - soft core size is unlimited 300s ok 21 - dropping cluster 300s # Cleanup 300s ok 22 - Cleanup: No clusters left behind 300s ok 23 - No postgres processes left behind 300s ok 24 - No files in /etc/postgresql left behind 300s ok 25 - No files in /var/lib/postgresql left behind 300s ok 26 - No files in /var/run/postgresql left behind 300s ok 27 - No files in /var/log/postgresql left behind 300s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 300s ok 29 - PostgreSQL TCP ports are closed 300s === Running test 090_multicluster.t ... === 300s 1..125 301s ok 1 - pg_createcluster 14 old 302s ok 2 - pg_createcluster 14 new1 302s ok 3 - pg_createcluster 14 new2 305s ok 4 - starting cluster 14/old 307s ok 5 - starting cluster 14/new1 309s ok 6 - starting cluster 14/new2 309s ok 7 - pg_lsclusters -h | sort -k3 309s ok 8 - clusters have the correct ports, skipping used 5433 309s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 309s ok 10 - createdb --version 309s ok 11 - pg_wrapper selects port 5432 as default cluster 309s ok 12 - createdb --cluster 14/new1 --version 309s ok 13 - pg_wrapper --cluster works 309s ok 14 - createdb --cluster 14/foo --version 309s ok 15 - pg_wrapper --cluster errors out for invalid cluster 309s ok 16 - createdb --cluster 14/new1 test 309s ok 17 - correct output of createdb --cluster 14/new1 test 309s ok 18 - psql -Atl --cluster 14/new1 309s ok 19 - test db appears in cluster new1 309s ok 20 - psql -Atl --cluster 14/new2 309s ok 21 - test db does not appear in cluster new2 309s ok 22 - psql -Atl 309s ok 23 - test db does not appear in default cluster 309s ok 24 - psql --cluster 14/127.0.0.1: -Atc 'show port' template1 309s ok 25 - psql --cluster 14/127.0.0.1: defaults to port 5432 309s ok 26 - createdb --cluster 14/127.0.0.1:5432 --version 309s ok 27 - createdb --cluster 14/127.0.0.1:5432 uses latest client version 310s ok 28 - psql -Atl --cluster 14/localhost:5434 310s ok 29 - test db appears in cluster 14/localhost:5434 310s ok 30 - psql -Atl --cluster 14/localhost:5440 310s ok 31 - test db does not appear in cluster 14/localhost:5440 310s ok 32 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:5435 310s ok 33 - psql --cluster 14/localhost:5435 fails due to nonexisting port 310s ok 34 - LC_MESSAGES=C psql -Atl --cluster 14/localhost:a 310s ok 35 - psql --cluster 14/localhost:a fails due to invalid syntax 310s ok 36 - LC_MESSAGES=C psql -Atl --cluster 14/doesnotexi.st 310s ok 37 - psql --cluster 14/doesnotexi.st fails due to invalid syntax 310s ok 38 - psql -Atl --cluster 6.4/localhost: 310s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 310s ok 40 - psql -Atl 310s ok 41 - PGCLUSTER selection (1) 310s ok 42 - psql -Atl 310s ok 43 - PGCLUSTER selection (2) 310s ok 44 - psql -l 310s ok 45 - invalid PGCLUSTER value 310s ok 46 - createdb --version 310s ok 47 - PGCLUSTER network cluster selection (1) 310s ok 48 - psql -Atl 310s ok 49 - PGCLUSTER network cluster selection (2) 310s ok 50 - psql -Atl 310s ok 51 - PGCLUSTER network cluster selection (3) 310s ok 52 - LC_MESSAGES=C psql -Atl 310s ok 53 - psql --cluster 14/localhost:5435 fails due to nonexisting port 310s ok 54 - psql -Atc "show port" template1 310s ok 55 - PGPORT selection (1) 310s ok 56 - psql -Atc "show port" template1 310s ok 57 - PGPORT selection (2) 310s ok 58 - createdb --version 310s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 310s ok 60 - psql -Atc "show port" template1 310s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 310s ok 62 - psql --cluster 14/new1 -Atc 'select current_database()' 310s ok 63 - PGDATABASE environment variable works 310s ok 64 - createdb --version 310s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 310s ok 66 - createdb --cluster 14/new1 --version 310s ok 67 - pg_wrapper --cluster works with empty user_clusters 310s ok 68 - createdb --version 310s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 14 new1 *' 310s ok 70 - psql -Atc "select current_database()" 310s ok 71 - pg_wrapper selects correct database with user_clusters '* * 14 new1 test' 310s ok 72 - psql -Atc 'select current_database()' 310s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 310s ok 74 - createdb --version 310s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 310s ok 76 - createdb --version 310s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 310s ok 78 - createdb --version 310s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 310s ok 80 - createdb --version 310s ok 81 - pg_wrapper selects correct version with per-user user_clusters 310s ok 82 - createdb --version 310s ok 83 - pg_wrapper selects correct version with per-user user_clusters 310s ok 84 - createdb --version 310s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 311s ok 86 - psql -Atl 311s ok 87 - $PGHOST overrides user_clusters 311s ok 88 - psql --cluster 14/localhost:5434 -Atc 'select current_database()' test 311s ok 89 - --cluster overrides $PGHOST 311s ok 90 - createdb --version 311s ok 91 - pg_wrapper ignores invalid lines in user_clusters 311s ok 92 - psql -Atc 'select current_database()' 311s ok 93 - pg_service conf selection 1 311s ok 94 - psql -Atc 'select current_database()' 311s ok 95 - pg_service conf selection 2 311s ok 96 - psql -Atc 'select current_database()' 311s ok 97 - pg_service conf selection 3 311s ok 98 - stopping cluster 14/old 313s ok 99 - restarting cluster 14/old 313s ok 100 - pg_lsclusters -h | sort -k3 313s ok 101 - port of first cluster was successfully changed 313s ok 102 - psql -l 313s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 313s ok 104 - psql -Atl --cluster 14/new1 313s ok 105 - --cluster selects appropriate cluster 313s ok 106 - psql -Atl -p 5434 313s ok 107 - -p selects appropriate cluster 313s ok 108 - psql -Atlp 5434 313s ok 109 - -Atlp selects appropriate cluster 313s ok 110 - psql -Atl --port 5434 313s ok 111 - --port selects appropriate cluster 313s ok 112 - env PGPORT=5434 psql -Atl 313s ok 113 - $PGPORT selects appropriate cluster 313s ok 114 - Restoring original /etc/postgresql-common/user_clusters 315s ok 115 - dropping 14/new1 316s ok 116 - dropping 14/new2 317s ok 117 - dropping 14/old 317s # Cleanup 317s ok 118 - Cleanup: No clusters left behind 317s ok 119 - No postgres processes left behind 317s ok 120 - No files in /etc/postgresql left behind 317s ok 121 - No files in /var/lib/postgresql left behind 317s ok 122 - No files in /var/run/postgresql left behind 317s ok 123 - No files in /var/log/postgresql left behind 317s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 317s ok 125 - PostgreSQL TCP ports are closed 317s === Running test 100_upgrade_scripts.t ... === 317s 1..27 320s ok 1 - pg_createcluster 14 main 320s ok 2 - createdb --cluster 14/main db1 320s ok 3 - correct output of createdb --cluster 14/main db1 320s ok 4 - createdb --cluster 14/main db2 320s ok 5 - correct output of createdb --cluster 14/main db2 321s ok 6 - psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 321s ok 7 - correct output of psql -q --cluster 14/main db1 -c 'CREATE TABLE log (str varchar)' 321s ok 8 - get_cluster_databases() works 321s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 322s ok 10 - run-upgrade-scripts succeeds 322s ok 11 - correct run-upgrade-script output 322s ok 12 - psql --cluster 14/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 322s ok 13 - check SQL scripts results in 14/main db1 322s ok 14 - psql --cluster 14/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 322s ok 15 - check SQL scripts results in 14/main db2 322s ok 16 - psql --cluster 14/main db1 -Atc 'select * from log order by str' 322s ok 17 - check shell scripts results in $v/main 322s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 323s ok 19 - pg_dropcluster 14 main 323s # Cleanup 323s ok 20 - Cleanup: No clusters left behind 323s ok 21 - No postgres processes left behind 323s ok 22 - No files in /etc/postgresql left behind 323s ok 23 - No files in /var/lib/postgresql left behind 323s ok 24 - No files in /var/run/postgresql left behind 323s ok 25 - No files in /var/log/postgresql left behind 323s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 323s ok 27 - PostgreSQL TCP ports are closed 323s === Running test 110_integrate_cluster.t ... === 324s 1..32 324s ok 1 - /usr/lib/postgresql/14/bin/initdb /tmp/TImWHRCkWF/c/postgres 324s ok 2 - creating raw initdb cluster for user postgres 325s ok 3 - pg_createcluster 14 postgres -d /tmp/TImWHRCkWF/c/postgres 325s ok 4 - integrating postgres cluster 325s ok 5 - pg_lsclusters 325s ok 6 - correct pg_lsclusters output 327s ok 7 - pg_ctlcluster 14 postgres start 327s ok 8 - starting cluster postgres 327s ok 9 - pg_lsclusters 327s ok 10 - correct pg_lsclusters output 328s ok 11 - dropping cluster postgres 328s ok 12 - No files in temporary cluster dir left behind 329s ok 13 - /usr/lib/postgresql/14/bin/initdb /tmp/TImWHRCkWF/c/nobody 329s ok 14 - creating raw initdb cluster for user nobody 329s ok 15 - pg_createcluster 14 nobody -d /tmp/TImWHRCkWF/c/nobody 329s ok 16 - integrating nobody cluster 329s ok 17 - pg_lsclusters 329s ok 18 - correct pg_lsclusters output 331s ok 19 - pg_ctlcluster 14 nobody start 331s ok 20 - starting cluster nobody 331s ok 21 - pg_lsclusters 331s ok 22 - correct pg_lsclusters output 332s ok 23 - dropping cluster nobody 332s ok 24 - No files in temporary cluster dir left behind 332s # Cleanup 332s ok 25 - Cleanup: No clusters left behind 332s ok 26 - No postgres processes left behind 332s ok 27 - No files in /etc/postgresql left behind 332s ok 28 - No files in /var/lib/postgresql left behind 332s ok 29 - No files in /var/run/postgresql left behind 332s ok 30 - No files in /var/log/postgresql left behind 332s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 332s ok 32 - PostgreSQL TCP ports are closed 332s === Running test 120_pg_upgradecluster_scripts.t ... === 332s 1..1 332s ok 1 - only one major version installed, skipping upgrade tests 332s === Running test 130_nonroot_admin.t ... === 333s 1..22 335s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 335s ok 2 - pg_lsclusters -h 335s ok 3 - correct output of pg_lsclusters -h 335s ok 4 - psql -Atl 335s ok 5 - correct output of psql -Atl 336s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 336s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 336s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 336s # Cleanup 336s ok 15 - Cleanup: No clusters left behind 336s ok 16 - No postgres processes left behind 336s ok 17 - No files in /etc/postgresql left behind 336s ok 18 - No files in /var/lib/postgresql left behind 336s ok 19 - No files in /var/run/postgresql left behind 336s ok 20 - No files in /var/log/postgresql left behind 336s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 336s ok 22 - PostgreSQL TCP ports are closed 336s === Running test 135_pg_virtualenv.t ... === 336s 1..20 340s ok 1 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 340s ok 2 - running pg_virtualenv as root 343s ok 3 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 343s ok 4 - running pg_virtualenv as postgres 346s ok 5 - pg_virtualenv -v 14 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 346s ok 6 - running pg_virtualenv as nobody 346s ok 7 # skip /usr/bin/fakeroot not available 346s ok 8 # skip /usr/bin/fakeroot not available 346s ok 9 # skip /usr/bin/fakeroot not available 346s ok 10 # skip /usr/bin/fakeroot not available 346s ok 11 # skip /usr/bin/fakeroot not available 346s ok 12 # skip /usr/bin/fakeroot not available 346s # Cleanup 346s ok 13 - Cleanup: No clusters left behind 346s ok 14 - No postgres processes left behind 346s ok 15 - No files in /etc/postgresql left behind 346s ok 16 - No files in /var/lib/postgresql left behind 346s ok 17 - No files in /var/run/postgresql left behind 346s ok 18 - No files in /var/log/postgresql left behind 346s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 346s ok 20 - PostgreSQL TCP ports are closed 346s === Running test 140_pg_config.t ... === 346s 1..38 346s # Multiarch is enabled 346s # checking version specific output for 14 346s ok 1 - /usr/lib/postgresql/14/bin/pg_config --pgxs 346s ok 2 - correct output of /usr/lib/postgresql/14/bin/pg_config --pgxs 346s ok 3 - /usr/lib/postgresql/14/bin/pg_config --libdir 346s ok 4 - correct output of /usr/lib/postgresql/14/bin/pg_config --libdir 346s ok 5 - /usr/lib/postgresql/14/bin/pg_config --pkglibdir 346s ok 6 - correct output of /usr/lib/postgresql/14/bin/pg_config --pkglibdir 346s ok 7 - /usr/lib/postgresql/14/bin/pg_config --bindir 346s ok 8 - correct output of /usr/lib/postgresql/14/bin/pg_config --bindir 346s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/14/lib/pgxs/src/Makefile.global 346s # checking pg_config output (should behave like version 14) 346s ok 15 - pg_config 346s ok 16 - correct output of pg_config 346s ok 17 - pg_config --help 346s ok 18 - correct output of pg_config --help 346s ok 19 - pg_config --pgxs 346s ok 20 - correct output of pg_config --pgxs 346s ok 21 - pg_config --libdir 346s ok 22 - correct output of pg_config --libdir 346s ok 23 - pg_config --pkglibdir 346s ok 24 - correct output of pg_config --pkglibdir 346s ok 25 - pg_config --bindir 346s ok 26 - correct output of pg_config --bindir 346s # checking pg_config.libpq-dev output (should behave like version 14) 346s ok 27 - pg_config.libpq-dev 346s ok 28 - correct output of pg_config.libpq-dev 346s ok 29 - pg_config.libpq-dev --help 346s ok 30 - correct output of pg_config.libpq-dev --help 346s ok 31 - pg_config.libpq-dev --pgxs 346s ok 32 - correct output of pg_config.libpq-dev --pgxs 346s ok 33 - pg_config.libpq-dev --libdir 346s ok 34 - correct output of pg_config.libpq-dev --libdir 346s ok 35 - pg_config.libpq-dev --pkglibdir 346s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 346s ok 37 - pg_config.libpq-dev --bindir 346s ok 38 - correct output of pg_config.libpq-dev --bindir 346s === Running test 150_tsearch_stemming.t ... === 346s 1..37 346s ok 1 - pg_updatedicts succeeded 346s ok 2 - pg_updatedicts created en_us.affix 346s ok 3 - pg_updatedicts created en_us.dict 346s ok 4 - pg_updatedicts created 14 en_us.affix symlink 346s ok 5 - pg_updatedicts created 14 en_us.dict symlink 350s ok 6 - pg_createcluster 14 main 350s ok 7 - createdb fts 350s ok 8 - correct output of createdb fts 350s ok 9 - creating en_US full text search configuration 350s ok 10 - creating data table and search index 350s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 350s ok 12 - stem search of correct word 350s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 350s ok 14 - stem search of correct word 350s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 350s ok 16 - stem search of unknown word 350s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 350s ok 18 - full text search, exact word 350s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 350s ok 20 - full text search for word stem 350s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 350s ok 22 - full text search for word substring fails 350s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 350s ok 24 - full text search, exact unicode word 350s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 350s ok 26 - full text search for unicode word stem 350s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 350s ok 28 - full text search for unicode word substring fails 352s ok 29 352s # Cleanup 352s ok 30 - Cleanup: No clusters left behind 352s ok 31 - No postgres processes left behind 352s ok 32 - No files in /etc/postgresql left behind 352s ok 33 - No files in /var/lib/postgresql left behind 352s ok 34 - No files in /var/run/postgresql left behind 352s ok 35 - No files in /var/log/postgresql left behind 352s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 352s ok 37 - PostgreSQL TCP ports are closed 352s === Running test 160_alternate_confroot.t ... === 352s 1..28 355s ok 1 355s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 355s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 355s ok 4 - pg_lsclusters -h 355s ok 5 - correct output of pg_lsclusters -h 355s ok 6 - psql -Atl 355s ok 7 - correct output of psql -Atl 355s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 355s ok 9 - ... 355s ok 10 - ... 355s ok 11 - ... 355s ok 12 - ... 355s ok 13 - ... 355s ok 14 - ... 355s ok 15 - pg_dropcluster 14 test --stop 355s ok 16 - correct output of pg_dropcluster 14 test --stop 355s ok 17 - pg_lsclusters -h 355s ok 18 - correct output of pg_lsclusters -h 355s ok 19 - No files in root/data left behind 355s ok 20 - No cruft in root dir left behind 355s # Cleanup 355s ok 21 - Cleanup: No clusters left behind 355s ok 22 - No postgres processes left behind 355s ok 23 - No files in /etc/postgresql left behind 355s ok 24 - No files in /var/lib/postgresql left behind 355s ok 25 - No files in /var/run/postgresql left behind 355s ok 26 - No files in /var/log/postgresql left behind 355s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 355s ok 28 - PostgreSQL TCP ports are closed 355s === Running test 170_extensions.t ... === 355s # Running tests for 14 358s ok 1 - pg_createcluster 14 main 358s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 358s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 358s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 358s ok 5 - extension adminpack installs without error 358s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 358s ok 7 - extension adminpack removes without error 358s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 358s ok 9 - extension amcheck installs without error 358s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 358s ok 11 - extension amcheck removes without error 358s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 358s ok 13 - extension autoinc installs without error 358s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 358s ok 15 - extension autoinc removes without error 358s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 358s ok 17 - extension bloom installs without error 358s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 358s ok 19 - extension bloom removes without error 358s ok 20 - psql -qc 'CREATE EXTENSION plperl' 358s ok 21 - bool_plperl dependency plperl installs without error 359s ok 22 - psql -qc 'CREATE EXTENSION "bool_plperl"' 359s ok 23 - extension bool_plperl installs without error 359s ok 24 - psql -qc 'DROP EXTENSION "bool_plperl"' 359s ok 25 - extension bool_plperl removes without error 359s ok 26 - psql -qc 'DROP EXTENSION plperl' 359s ok 27 - bool_plperl dependency extension plperl removes without error 359s ok 28 - psql -qc 'CREATE EXTENSION plperlu' 359s ok 29 - bool_plperlu dependency plperlu installs without error 359s ok 30 - psql -qc 'CREATE EXTENSION "bool_plperlu"' 359s ok 31 - extension bool_plperlu installs without error 359s ok 32 - psql -qc 'DROP EXTENSION "bool_plperlu"' 359s ok 33 - extension bool_plperlu removes without error 359s ok 34 - psql -qc 'DROP EXTENSION plperlu' 359s ok 35 - bool_plperlu dependency extension plperlu removes without error 359s ok 36 - psql -qc 'CREATE EXTENSION "btree_gin"' 359s ok 37 - extension btree_gin installs without error 359s ok 38 - psql -qc 'DROP EXTENSION "btree_gin"' 359s ok 39 - extension btree_gin removes without error 359s ok 40 - psql -qc 'CREATE EXTENSION "btree_gist"' 359s ok 41 - extension btree_gist installs without error 359s ok 42 - psql -qc 'DROP EXTENSION "btree_gist"' 359s ok 43 - extension btree_gist removes without error 359s ok 44 - psql -qc 'CREATE EXTENSION "citext"' 359s ok 45 - extension citext installs without error 359s ok 46 - psql -qc 'DROP EXTENSION "citext"' 359s ok 47 - extension citext removes without error 359s ok 48 - psql -qc 'CREATE EXTENSION "cube"' 359s ok 49 - extension cube installs without error 359s ok 50 - psql -qc 'DROP EXTENSION "cube"' 359s ok 51 - extension cube removes without error 359s ok 52 - psql -qc 'CREATE EXTENSION "dblink"' 359s ok 53 - extension dblink installs without error 359s ok 54 - psql -qc 'DROP EXTENSION "dblink"' 359s ok 55 - extension dblink removes without error 359s ok 56 - psql -qc 'CREATE EXTENSION "dict_int"' 359s ok 57 - extension dict_int installs without error 359s ok 58 - psql -qc 'DROP EXTENSION "dict_int"' 359s ok 59 - extension dict_int removes without error 359s ok 60 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 359s ok 61 - extension dict_xsyn installs without error 359s ok 62 - psql -qc 'DROP EXTENSION "dict_xsyn"' 359s ok 63 - extension dict_xsyn removes without error 359s ok 64 - psql -qc 'CREATE EXTENSION cube' 359s ok 65 - earthdistance dependency cube installs without error 359s ok 66 - psql -qc 'CREATE EXTENSION "earthdistance"' 359s ok 67 - extension earthdistance installs without error 359s ok 68 - psql -qc 'DROP EXTENSION "earthdistance"' 359s ok 69 - extension earthdistance removes without error 360s ok 70 - psql -qc 'DROP EXTENSION cube' 360s ok 71 - earthdistance dependency extension cube removes without error 360s ok 72 - psql -qc 'CREATE EXTENSION "file_fdw"' 360s ok 73 - extension file_fdw installs without error 360s ok 74 - psql -qc 'DROP EXTENSION "file_fdw"' 360s ok 75 - extension file_fdw removes without error 360s ok 76 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 360s ok 77 - extension fuzzystrmatch installs without error 360s ok 78 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 360s ok 79 - extension fuzzystrmatch removes without error 360s ok 80 - psql -qc 'CREATE EXTENSION "hstore"' 360s ok 81 - extension hstore installs without error 360s ok 82 - psql -qc 'DROP EXTENSION "hstore"' 360s ok 83 - extension hstore removes without error 360s ok 84 - psql -qc 'CREATE EXTENSION hstore' 360s ok 85 - hstore_plperl dependency hstore installs without error 360s ok 86 - psql -qc 'CREATE EXTENSION plperl' 360s ok 87 - hstore_plperl dependency plperl installs without error 360s ok 88 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 360s ok 89 - extension hstore_plperl installs without error 360s ok 90 - psql -qc 'DROP EXTENSION "hstore_plperl"' 360s ok 91 - extension hstore_plperl removes without error 360s ok 92 - psql -qc 'DROP EXTENSION hstore' 360s ok 93 - hstore_plperl dependency extension hstore removes without error 360s ok 94 - psql -qc 'DROP EXTENSION plperl' 360s ok 95 - hstore_plperl dependency extension plperl removes without error 360s ok 96 - psql -qc 'CREATE EXTENSION hstore' 360s ok 97 - hstore_plperlu dependency hstore installs without error 360s ok 98 - psql -qc 'CREATE EXTENSION plperlu' 360s ok 99 - hstore_plperlu dependency plperlu installs without error 360s ok 100 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 360s ok 101 - extension hstore_plperlu installs without error 360s ok 102 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 360s ok 103 - extension hstore_plperlu removes without error 360s ok 104 - psql -qc 'DROP EXTENSION hstore' 360s ok 105 - hstore_plperlu dependency extension hstore removes without error 360s ok 106 - psql -qc 'DROP EXTENSION plperlu' 360s ok 107 - hstore_plperlu dependency extension plperlu removes without error 360s ok 108 - psql -qc 'CREATE EXTENSION hstore' 360s ok 109 - hstore_plpython3u dependency hstore installs without error 360s ok 110 - psql -qc 'CREATE EXTENSION plpython3u' 360s ok 111 - hstore_plpython3u dependency plpython3u installs without error 360s ok 112 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 360s ok 113 - extension hstore_plpython3u installs without error 360s ok 114 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 360s ok 115 - extension hstore_plpython3u removes without error 360s ok 116 - psql -qc 'DROP EXTENSION hstore' 360s ok 117 - hstore_plpython3u dependency extension hstore removes without error 361s ok 118 - psql -qc 'DROP EXTENSION plpython3u' 361s ok 119 - hstore_plpython3u dependency extension plpython3u removes without error 361s ok 120 - psql -qc 'CREATE EXTENSION "insert_username"' 361s ok 121 - extension insert_username installs without error 361s ok 122 - psql -qc 'DROP EXTENSION "insert_username"' 361s ok 123 - extension insert_username removes without error 361s ok 124 - psql -qc 'CREATE EXTENSION "intagg"' 361s ok 125 - extension intagg installs without error 361s ok 126 - psql -qc 'DROP EXTENSION "intagg"' 361s ok 127 - extension intagg removes without error 361s ok 128 - psql -qc 'CREATE EXTENSION "intarray"' 361s ok 129 - extension intarray installs without error 361s ok 130 - psql -qc 'DROP EXTENSION "intarray"' 361s ok 131 - extension intarray removes without error 361s ok 132 - psql -qc 'CREATE EXTENSION "isn"' 361s ok 133 - extension isn installs without error 361s ok 134 - psql -qc 'DROP EXTENSION "isn"' 361s ok 135 - extension isn removes without error 361s ok 136 - psql -qc 'CREATE EXTENSION plperl' 361s ok 137 - jsonb_plperl dependency plperl installs without error 361s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 361s ok 139 - extension jsonb_plperl installs without error 361s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 361s ok 141 - extension jsonb_plperl removes without error 361s ok 142 - psql -qc 'DROP EXTENSION plperl' 361s ok 143 - jsonb_plperl dependency extension plperl removes without error 361s ok 144 - psql -qc 'CREATE EXTENSION plperlu' 361s ok 145 - jsonb_plperlu dependency plperlu installs without error 361s ok 146 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 361s ok 147 - extension jsonb_plperlu installs without error 361s ok 148 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 361s ok 149 - extension jsonb_plperlu removes without error 361s ok 150 - psql -qc 'DROP EXTENSION plperlu' 361s ok 151 - jsonb_plperlu dependency extension plperlu removes without error 361s ok 152 - psql -qc 'CREATE EXTENSION plpython3u' 361s ok 153 - jsonb_plpython3u dependency plpython3u installs without error 361s ok 154 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 361s ok 155 - extension jsonb_plpython3u installs without error 361s ok 156 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 361s ok 157 - extension jsonb_plpython3u removes without error 361s ok 158 - psql -qc 'DROP EXTENSION plpython3u' 361s ok 159 - jsonb_plpython3u dependency extension plpython3u removes without error 361s ok 160 - psql -qc 'CREATE EXTENSION "lo"' 361s ok 161 - extension lo installs without error 361s ok 162 - psql -qc 'DROP EXTENSION "lo"' 361s ok 163 - extension lo removes without error 361s ok 164 - psql -qc 'CREATE EXTENSION "ltree"' 361s ok 165 - extension ltree installs without error 361s ok 166 - psql -qc 'DROP EXTENSION "ltree"' 361s ok 167 - extension ltree removes without error 362s ok 168 - psql -qc 'CREATE EXTENSION ltree' 362s ok 169 - ltree_plpython3u dependency ltree installs without error 362s ok 170 - psql -qc 'CREATE EXTENSION plpython3u' 362s ok 171 - ltree_plpython3u dependency plpython3u installs without error 362s ok 172 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 362s ok 173 - extension ltree_plpython3u installs without error 362s ok 174 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 362s ok 175 - extension ltree_plpython3u removes without error 362s ok 176 - psql -qc 'DROP EXTENSION ltree' 362s ok 177 - ltree_plpython3u dependency extension ltree removes without error 362s ok 178 - psql -qc 'DROP EXTENSION plpython3u' 362s ok 179 - ltree_plpython3u dependency extension plpython3u removes without error 362s ok 180 - psql -qc 'CREATE EXTENSION "moddatetime"' 362s ok 181 - extension moddatetime installs without error 362s ok 182 - psql -qc 'DROP EXTENSION "moddatetime"' 362s ok 183 - extension moddatetime removes without error 362s ok 184 - psql -qc 'CREATE EXTENSION "old_snapshot"' 362s ok 185 - extension old_snapshot installs without error 362s ok 186 - psql -qc 'DROP EXTENSION "old_snapshot"' 362s ok 187 - extension old_snapshot removes without error 362s ok 188 - psql -qc 'CREATE EXTENSION "pageinspect"' 362s ok 189 - extension pageinspect installs without error 362s ok 190 - psql -qc 'DROP EXTENSION "pageinspect"' 362s ok 191 - extension pageinspect removes without error 362s ok 192 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 362s ok 193 - extension pg_buffercache installs without error 362s ok 194 - psql -qc 'DROP EXTENSION "pg_buffercache"' 362s ok 195 - extension pg_buffercache removes without error 362s ok 196 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 362s ok 197 - extension pg_freespacemap installs without error 362s ok 198 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 362s ok 199 - extension pg_freespacemap removes without error 362s ok 200 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 362s ok 201 - extension pg_prewarm installs without error 362s ok 202 - psql -qc 'DROP EXTENSION "pg_prewarm"' 362s ok 203 - extension pg_prewarm removes without error 362s ok 204 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 362s ok 205 - extension pg_stat_statements installs without error 362s ok 206 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 362s ok 207 - extension pg_stat_statements removes without error 362s ok 208 - psql -qc 'CREATE EXTENSION "pg_surgery"' 362s ok 209 - extension pg_surgery installs without error 362s ok 210 - psql -qc 'DROP EXTENSION "pg_surgery"' 362s ok 211 - extension pg_surgery removes without error 362s ok 212 - psql -qc 'CREATE EXTENSION "pg_trgm"' 362s ok 213 - extension pg_trgm installs without error 362s ok 214 - psql -qc 'DROP EXTENSION "pg_trgm"' 362s ok 215 - extension pg_trgm removes without error 362s ok 216 - psql -qc 'CREATE EXTENSION "pg_visibility"' 362s ok 217 - extension pg_visibility installs without error 362s ok 218 - psql -qc 'DROP EXTENSION "pg_visibility"' 362s ok 219 - extension pg_visibility removes without error 363s ok 220 - psql -qc 'CREATE EXTENSION "pgcrypto"' 363s ok 221 - extension pgcrypto installs without error 363s ok 222 - psql -qc 'DROP EXTENSION "pgcrypto"' 363s ok 223 - extension pgcrypto removes without error 363s ok 224 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 363s ok 225 - extension pgrowlocks installs without error 363s ok 226 - psql -qc 'DROP EXTENSION "pgrowlocks"' 363s ok 227 - extension pgrowlocks removes without error 363s ok 228 - psql -qc 'CREATE EXTENSION "pgstattuple"' 363s ok 229 - extension pgstattuple installs without error 363s ok 230 - psql -qc 'DROP EXTENSION "pgstattuple"' 363s ok 231 - extension pgstattuple removes without error 363s ok 232 - psql -qc 'CREATE EXTENSION "plperl"' 363s ok 233 - extension plperl installs without error 363s ok 234 - psql -qc 'DROP EXTENSION "plperl"' 363s ok 235 - extension plperl removes without error 363s ok 236 - psql -qc 'CREATE EXTENSION "plperlu"' 363s ok 237 - extension plperlu installs without error 363s ok 238 - psql -qc 'DROP EXTENSION "plperlu"' 363s ok 239 - extension plperlu removes without error 363s ok 240 - psql -qc 'CREATE EXTENSION "plpython3u"' 363s ok 241 - extension plpython3u installs without error 363s ok 242 - psql -qc 'DROP EXTENSION "plpython3u"' 363s ok 243 - extension plpython3u removes without error 363s ok 244 - psql -qc 'CREATE EXTENSION "pltcl"' 363s ok 245 - extension pltcl installs without error 363s ok 246 - psql -qc 'DROP EXTENSION "pltcl"' 363s ok 247 - extension pltcl removes without error 363s ok 248 - psql -qc 'CREATE EXTENSION "pltclu"' 363s ok 249 - extension pltclu installs without error 363s ok 250 - psql -qc 'DROP EXTENSION "pltclu"' 363s ok 251 - extension pltclu removes without error 363s ok 252 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 363s ok 253 - extension postgres_fdw installs without error 363s ok 254 - psql -qc 'DROP EXTENSION "postgres_fdw"' 363s ok 255 - extension postgres_fdw removes without error 363s ok 256 - psql -qc 'CREATE EXTENSION "refint"' 363s ok 257 - extension refint installs without error 363s ok 258 - psql -qc 'DROP EXTENSION "refint"' 363s ok 259 - extension refint removes without error 363s ok 260 - psql -qc 'CREATE EXTENSION "seg"' 363s ok 261 - extension seg installs without error 363s ok 262 - psql -qc 'DROP EXTENSION "seg"' 363s ok 263 - extension seg removes without error 363s ok 264 - psql -qc 'CREATE EXTENSION "sslinfo"' 363s ok 265 - extension sslinfo installs without error 363s ok 266 - psql -qc 'DROP EXTENSION "sslinfo"' 363s ok 267 - extension sslinfo removes without error 363s ok 268 - psql -qc 'CREATE EXTENSION "tablefunc"' 363s ok 269 - extension tablefunc installs without error 363s ok 270 - psql -qc 'DROP EXTENSION "tablefunc"' 363s ok 271 - extension tablefunc removes without error 364s ok 272 - psql -qc 'CREATE EXTENSION "tcn"' 364s ok 273 - extension tcn installs without error 364s ok 274 - psql -qc 'DROP EXTENSION "tcn"' 364s ok 275 - extension tcn removes without error 364s ok 276 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 364s ok 277 - extension tsm_system_rows installs without error 364s ok 278 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 364s ok 279 - extension tsm_system_rows removes without error 364s ok 280 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 364s ok 281 - extension tsm_system_time installs without error 364s ok 282 - psql -qc 'DROP EXTENSION "tsm_system_time"' 364s ok 283 - extension tsm_system_time removes without error 364s ok 284 - psql -qc 'CREATE EXTENSION "unaccent"' 364s ok 285 - extension unaccent installs without error 364s ok 286 - psql -qc 'DROP EXTENSION "unaccent"' 364s ok 287 - extension unaccent removes without error 364s ok 288 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 364s ok 289 - extension uuid-ossp installs without error 364s ok 290 - psql -qc 'DROP EXTENSION "uuid-ossp"' 364s ok 291 - extension uuid-ossp removes without error 364s ok 292 - psql -qc 'CREATE EXTENSION "xml2"' 364s ok 293 - extension xml2 installs without error 364s ok 294 - psql -qc 'DROP EXTENSION "xml2"' 364s ok 295 - extension xml2 removes without error 365s ok 296 - pg_dropcluster 14 main 365s # Cleanup 365s ok 297 - Cleanup: No clusters left behind 365s ok 298 - No postgres processes left behind 365s ok 299 - No files in /etc/postgresql left behind 365s ok 300 - No files in /var/lib/postgresql left behind 365s ok 301 - No files in /var/run/postgresql left behind 365s ok 302 - No files in /var/log/postgresql left behind 365s ok 303 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 365s ok 304 - PostgreSQL TCP ports are closed 365s 1..304 365s === Running test 180_ecpg.t ... === 365s 1..14 365s ok 1 - ecpg test.pgc 365s ok 2 - ecpg processing 365s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 365s ok 4 - compiling ecpg output 372s ok 5 - pg_virtualenv /tmp/tmp.q8gDAQvBOa/test 372s ok 6 - test program runs and gives correct output 372s # Cleanup 372s ok 7 - Cleanup: No clusters left behind 372s ok 8 - No postgres processes left behind 372s ok 9 - No files in /etc/postgresql left behind 372s ok 10 - No files in /var/lib/postgresql left behind 372s ok 11 - No files in /var/run/postgresql left behind 372s ok 12 - No files in /var/log/postgresql left behind 372s ok 13 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 372s ok 14 - PostgreSQL TCP ports are closed 372s === Running test 190_pg_buildext.t ... === 372s ok 1 - Skipping pg_buildext tests, /usr/bin/dh_make_pgxs is not installed 372s 1..1 373s autopkgtest [13:31:05]: test run-testsuite: -----------------------] 373s run-testsuite PASS 373s autopkgtest [13:31:05]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 373s autopkgtest [13:31:05]: test installcheck: preparing testbed 433s autopkgtest [13:32:05]: testbed dpkg architecture: amd64 433s autopkgtest [13:32:05]: testbed apt version: 2.4.13 433s autopkgtest [13:32:05]: @@@@@@@@@@@@@@@@@@@@ test bed setup 433s autopkgtest [13:32:05]: testbed release detected to be: jammy 434s autopkgtest [13:32:06]: updating testbed package index (apt update) 434s Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease 434s Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease 434s Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease 434s Get:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [279 kB] 434s Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [29.0 kB] 434s Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [6192 B] 434s Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [19.2 kB] 434s Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [102 kB] 434s Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 Packages [329 kB] 434s Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main i386 Packages [97.6 kB] 434s Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 c-n-f Metadata [1740 B] 434s Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 Packages [479 kB] 434s Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/restricted i386 Packages [4732 B] 434s Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 c-n-f Metadata [420 B] 434s Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/universe i386 Packages [33.4 kB] 434s Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 Packages [90.4 kB] 434s Get:17 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 c-n-f Metadata [1344 B] 434s Get:18 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse i386 Packages [2464 B] 434s Get:19 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 Packages [9488 B] 434s Get:20 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 c-n-f Metadata [208 B] 439s Fetched 1486 kB in 1s (2403 kB/s) 440s Reading package lists... 441s Reading package lists... 441s Building dependency tree... 441s Reading state information... 442s Calculating upgrade... 442s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 442s Reading package lists... 442s Building dependency tree... 442s Reading state information... 443s 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. 443s autopkgtest [13:32:15]: upgrading testbed (apt dist-upgrade and autopurge) 443s Reading package lists... 444s Building dependency tree... 444s Reading state information... 444s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 444s Starting 2 pkgProblemResolver with broken count: 0 444s Done 445s Entering ResolveByKeep 445s 445s The following packages will be upgraded: 445s tzdata 445s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 445s Need to get 347 kB of archives. 445s After this operation, 4096 B of additional disk space will be used. 445s Get:1 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 tzdata all 2025a-0ubuntu0.22.04 [347 kB] 446s Preconfiguring packages ... 446s Fetched 347 kB in 0s (9827 kB/s) 446s (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 ... 67962 files and directories currently installed.) 446s Preparing to unpack .../tzdata_2025a-0ubuntu0.22.04_all.deb ... 446s Unpacking tzdata (2025a-0ubuntu0.22.04) over (2024b-0ubuntu0.22.04.1) ... 446s Setting up tzdata (2025a-0ubuntu0.22.04) ... 446s 446s Current default time zone: 'Etc/UTC' 446s Local time is now: Wed Feb 26 13:32:18 UTC 2025. 446s Universal Time is now: Wed Feb 26 13:32:18 UTC 2025. 446s Run 'dpkg-reconfigure tzdata' if you wish to change it. 446s 447s Reading package lists... 447s Building dependency tree... 447s Reading state information... 447s Starting pkgProblemResolver with broken count: 0 447s Starting 2 pkgProblemResolver with broken count: 0 447s Done 448s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 449s Reading package lists... 449s Building dependency tree... 449s Reading state information... 450s Starting pkgProblemResolver with broken count: 0 450s Starting 2 pkgProblemResolver with broken count: 0 450s Done 450s The following NEW packages will be installed: 450s build-essential clang-14 cpp cpp-11 g++ g++-11 gcc gcc-11 gcc-11-base 450s icu-devtools lib32gcc-s1 lib32stdc++6 libasan6 libatomic1 libc-dev-bin 450s libc6-dev libc6-i386 libcc1-0 libclang-common-14-dev libclang-cpp14 450s libclang1-14 libcrypt-dev libecpg-compat3 libecpg-dev libecpg6 libffi-dev 450s libgc1 libgcc-11-dev libgomp1 libicu-dev libisl23 libitm1 libjson-perl 450s libllvm14 liblsan0 libmpc3 libncurses-dev libnsl-dev libobjc-11-dev libobjc4 450s libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.10 libquadmath0 libssl-dev 450s libstdc++-11-dev libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev 450s libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-14 llvm-14-dev 450s llvm-14-linker-tools llvm-14-runtime llvm-14-tools postgresql-14 450s postgresql-client-14 postgresql-client-common postgresql-common 450s postgresql-doc-14 postgresql-plperl-14 postgresql-plpython3-14 450s postgresql-pltcl-14 postgresql-server-dev-14 python3-pygments rpcsvc-proto 450s ssl-cert 450s 0 upgraded, 74 newly installed, 0 to remove and 0 not upgraded. 450s Need to get 210 MB of archives. 450s After this operation, 992 MB of additional disk space will be used. 450s Get:1 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc-dev-bin amd64 2.35-0ubuntu3.9 [20.3 kB] 450s Get:2 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 linux-libc-dev amd64 5.15.0-133.144 [1298 kB] 450s Get:3 http://ftpmaster.internal/ubuntu jammy/main amd64 libcrypt-dev amd64 1:4.4.27-1 [112 kB] 450s Get:4 http://ftpmaster.internal/ubuntu jammy/main amd64 rpcsvc-proto amd64 1.4.2-0ubuntu6 [68.5 kB] 450s Get:5 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtirpc-dev amd64 1.3.2-2ubuntu0.1 [192 kB] 450s Get:6 http://ftpmaster.internal/ubuntu jammy/main amd64 libnsl-dev amd64 1.3.0-2build2 [71.3 kB] 450s Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-dev amd64 2.35-0ubuntu3.9 [2100 kB] 450s Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 gcc-11-base amd64 11.4.0-1ubuntu1~22.04 [20.2 kB] 450s Get:9 http://ftpmaster.internal/ubuntu jammy/main amd64 libisl23 amd64 0.24-2build1 [727 kB] 450s Get:10 http://ftpmaster.internal/ubuntu jammy/main amd64 libmpc3 amd64 1.2.1-2build1 [46.9 kB] 450s Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 cpp-11 amd64 11.4.0-1ubuntu1~22.04 [10.0 MB] 450s Get:12 http://ftpmaster.internal/ubuntu jammy/main amd64 cpp amd64 4:11.2.0-1ubuntu1 [27.7 kB] 450s Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libcc1-0 amd64 12.3.0-1ubuntu1~22.04 [48.3 kB] 450s Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgomp1 amd64 12.3.0-1ubuntu1~22.04 [126 kB] 450s Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libitm1 amd64 12.3.0-1ubuntu1~22.04 [30.2 kB] 450s Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libatomic1 amd64 12.3.0-1ubuntu1~22.04 [10.4 kB] 450s Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libasan6 amd64 11.4.0-1ubuntu1~22.04 [2282 kB] 450s Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 liblsan0 amd64 12.3.0-1ubuntu1~22.04 [1069 kB] 450s Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtsan0 amd64 11.4.0-1ubuntu1~22.04 [2260 kB] 450s Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libubsan1 amd64 12.3.0-1ubuntu1~22.04 [976 kB] 450s Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libquadmath0 amd64 12.3.0-1ubuntu1~22.04 [154 kB] 450s Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgcc-11-dev amd64 11.4.0-1ubuntu1~22.04 [2517 kB] 450s Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 gcc-11 amd64 11.4.0-1ubuntu1~22.04 [20.1 MB] 451s Get:24 http://ftpmaster.internal/ubuntu jammy/main amd64 gcc amd64 4:11.2.0-1ubuntu1 [5112 B] 451s Get:25 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libstdc++-11-dev amd64 11.4.0-1ubuntu1~22.04 [2101 kB] 451s Get:26 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 g++-11 amd64 11.4.0-1ubuntu1~22.04 [11.4 MB] 451s Get:27 http://ftpmaster.internal/ubuntu jammy/main amd64 g++ amd64 4:11.2.0-1ubuntu1 [1412 B] 451s Get:28 http://ftpmaster.internal/ubuntu jammy/main amd64 build-essential amd64 12.9ubuntu3 [4744 B] 451s Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libllvm14 amd64 1:14.0.0-1ubuntu1.1 [24.0 MB] 451s Get:30 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang-cpp14 amd64 1:14.0.0-1ubuntu1.1 [12.1 MB] 451s Get:31 http://ftpmaster.internal/ubuntu jammy/main amd64 libgc1 amd64 1:8.0.6-1.1build1 [96.8 kB] 451s Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc4 amd64 12.3.0-1ubuntu1~22.04 [48.6 kB] 451s Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc-11-dev amd64 11.4.0-1ubuntu1~22.04 [196 kB] 451s Get:34 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-i386 amd64 2.35-0ubuntu3.9 [2838 kB] 451s Get:35 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32gcc-s1 amd64 12.3.0-1ubuntu1~22.04 [63.9 kB] 451s Get:36 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32stdc++6 amd64 12.3.0-1ubuntu1~22.04 [740 kB] 451s Get:37 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang-common-14-dev amd64 1:14.0.0-1ubuntu1.1 [5975 kB] 452s Get:38 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-linker-tools amd64 1:14.0.0-1ubuntu1.1 [1355 kB] 452s Get:39 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libclang1-14 amd64 1:14.0.0-1ubuntu1.1 [6792 kB] 452s Get:40 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 clang-14 amd64 1:14.0.0-1ubuntu1.1 [81.2 kB] 452s Get:41 http://ftpmaster.internal/ubuntu jammy/main amd64 icu-devtools amd64 70.1-2 [197 kB] 452s Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpgtypes3 amd64 14.15-0ubuntu0.22.04.1 [47.1 kB] 452s Get:43 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq5 amd64 14.15-0ubuntu0.22.04.1 [150 kB] 452s Get:44 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg6 amd64 14.15-0ubuntu0.22.04.1 [45.1 kB] 452s Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg-compat3 amd64 14.15-0ubuntu0.22.04.1 [13.6 kB] 452s Get:46 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libssl-dev amd64 3.0.2-0ubuntu1.19 [2376 kB] 452s Get:47 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq-dev amd64 14.15-0ubuntu0.22.04.1 [147 kB] 452s Get:48 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libecpg-dev amd64 14.15-0ubuntu0.22.04.1 [265 kB] 452s Get:49 http://ftpmaster.internal/ubuntu jammy/main amd64 libicu-dev amd64 70.1-2 [11.6 MB] 452s Get:50 http://ftpmaster.internal/ubuntu jammy/main amd64 libjson-perl all 4.04000-1 [81.8 kB] 452s Get:51 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libncurses-dev amd64 6.3-2ubuntu0.1 [381 kB] 452s Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpython3.10 amd64 3.10.12-1~22.04.9 [1949 kB] 452s Get:53 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtinfo-dev amd64 6.3-2ubuntu0.1 [780 B] 452s Get:54 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxml2-dev amd64 2.9.13+dfsg-1ubuntu0.6 [804 kB] 452s Get:55 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.22.04.1 [164 kB] 452s Get:56 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-runtime amd64 1:14.0.0-1ubuntu1.1 [484 kB] 452s Get:57 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpfm4 amd64 4.11.1+git32-gd0b85fb-1ubuntu0.1 [345 kB] 452s Get:58 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14 amd64 1:14.0.0-1ubuntu1.1 [12.7 MB] 452s Get:59 http://ftpmaster.internal/ubuntu jammy/main amd64 libffi-dev amd64 3.4.2-4 [63.7 kB] 452s Get:60 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 python3-pygments all 2.11.2+dfsg-2ubuntu0.1 [750 kB] 452s Get:61 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-tools amd64 1:14.0.0-1ubuntu1.1 [404 kB] 452s Get:62 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-4 amd64 4.8.12-1 [5766 kB] 452s Get:63 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-dev amd64 4.8.12-1 [72.2 kB] 452s Get:64 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 llvm-14-dev amd64 1:14.0.0-1ubuntu1.1 [37.8 MB] 452s Get:65 http://ftpmaster.internal/ubuntu jammy/main amd64 postgresql-client-common all 238 [29.6 kB] 452s Get:66 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-client-14 amd64 14.15-0ubuntu0.22.04.1 [1225 kB] 453s Get:67 http://ftpmaster.internal/ubuntu jammy/main amd64 ssl-cert all 1.1.2 [17.4 kB] 453s Get:68 http://ftpmaster.internal/ubuntu jammy/main amd64 postgresql-common all 238 [169 kB] 453s Get:69 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-14 amd64 14.15-0ubuntu0.22.04.1 [16.2 MB] 453s Get:70 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-doc-14 all 14.15-0ubuntu0.22.04.1 [2056 kB] 453s Get:71 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-plperl-14 amd64 14.15-0ubuntu0.22.04.1 [75.4 kB] 453s Get:72 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-plpython3-14 amd64 14.15-0ubuntu0.22.04.1 [84.6 kB] 453s Get:73 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-pltcl-14 amd64 14.15-0ubuntu0.22.04.1 [35.7 kB] 453s Get:74 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 postgresql-server-dev-14 amd64 14.15-0ubuntu0.22.04.1 [1181 kB] 453s Preconfiguring packages ... 453s Fetched 210 MB in 2s (84.0 MB/s) 453s Selecting previously unselected package libc-dev-bin. 453s (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 ... 67963 files and directories currently installed.) 453s Preparing to unpack .../00-libc-dev-bin_2.35-0ubuntu3.9_amd64.deb ... 453s Unpacking libc-dev-bin (2.35-0ubuntu3.9) ... 453s Selecting previously unselected package linux-libc-dev:amd64. 453s Preparing to unpack .../01-linux-libc-dev_5.15.0-133.144_amd64.deb ... 453s Unpacking linux-libc-dev:amd64 (5.15.0-133.144) ... 453s Selecting previously unselected package libcrypt-dev:amd64. 453s Preparing to unpack .../02-libcrypt-dev_1%3a4.4.27-1_amd64.deb ... 453s Unpacking libcrypt-dev:amd64 (1:4.4.27-1) ... 453s Selecting previously unselected package rpcsvc-proto. 453s Preparing to unpack .../03-rpcsvc-proto_1.4.2-0ubuntu6_amd64.deb ... 453s Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... 453s Selecting previously unselected package libtirpc-dev:amd64. 453s Preparing to unpack .../04-libtirpc-dev_1.3.2-2ubuntu0.1_amd64.deb ... 453s Unpacking libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... 453s Selecting previously unselected package libnsl-dev:amd64. 453s Preparing to unpack .../05-libnsl-dev_1.3.0-2build2_amd64.deb ... 453s Unpacking libnsl-dev:amd64 (1.3.0-2build2) ... 453s Selecting previously unselected package libc6-dev:amd64. 454s Preparing to unpack .../06-libc6-dev_2.35-0ubuntu3.9_amd64.deb ... 454s Unpacking libc6-dev:amd64 (2.35-0ubuntu3.9) ... 454s Selecting previously unselected package gcc-11-base:amd64. 454s Preparing to unpack .../07-gcc-11-base_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking gcc-11-base:amd64 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libisl23:amd64. 454s Preparing to unpack .../08-libisl23_0.24-2build1_amd64.deb ... 454s Unpacking libisl23:amd64 (0.24-2build1) ... 454s Selecting previously unselected package libmpc3:amd64. 454s Preparing to unpack .../09-libmpc3_1.2.1-2build1_amd64.deb ... 454s Unpacking libmpc3:amd64 (1.2.1-2build1) ... 454s Selecting previously unselected package cpp-11. 454s Preparing to unpack .../10-cpp-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking cpp-11 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package cpp. 454s Preparing to unpack .../11-cpp_4%3a11.2.0-1ubuntu1_amd64.deb ... 454s Unpacking cpp (4:11.2.0-1ubuntu1) ... 454s Selecting previously unselected package libcc1-0:amd64. 454s Preparing to unpack .../12-libcc1-0_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libcc1-0:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libgomp1:amd64. 454s Preparing to unpack .../13-libgomp1_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libgomp1:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libitm1:amd64. 454s Preparing to unpack .../14-libitm1_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libitm1:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libatomic1:amd64. 454s Preparing to unpack .../15-libatomic1_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libatomic1:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libasan6:amd64. 454s Preparing to unpack .../16-libasan6_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libasan6:amd64 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package liblsan0:amd64. 454s Preparing to unpack .../17-liblsan0_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking liblsan0:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libtsan0:amd64. 454s Preparing to unpack .../18-libtsan0_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libtsan0:amd64 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libubsan1:amd64. 454s Preparing to unpack .../19-libubsan1_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libubsan1:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libquadmath0:amd64. 454s Preparing to unpack .../20-libquadmath0_12.3.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libquadmath0:amd64 (12.3.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package libgcc-11-dev:amd64. 454s Preparing to unpack .../21-libgcc-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libgcc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package gcc-11. 454s Preparing to unpack .../22-gcc-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking gcc-11 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package gcc. 454s Preparing to unpack .../23-gcc_4%3a11.2.0-1ubuntu1_amd64.deb ... 454s Unpacking gcc (4:11.2.0-1ubuntu1) ... 454s Selecting previously unselected package libstdc++-11-dev:amd64. 454s Preparing to unpack .../24-libstdc++-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking libstdc++-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 454s Selecting previously unselected package g++-11. 454s Preparing to unpack .../25-g++-11_11.4.0-1ubuntu1~22.04_amd64.deb ... 454s Unpacking g++-11 (11.4.0-1ubuntu1~22.04) ... 455s Selecting previously unselected package g++. 455s Preparing to unpack .../26-g++_4%3a11.2.0-1ubuntu1_amd64.deb ... 455s Unpacking g++ (4:11.2.0-1ubuntu1) ... 455s Selecting previously unselected package build-essential. 455s Preparing to unpack .../27-build-essential_12.9ubuntu3_amd64.deb ... 455s Unpacking build-essential (12.9ubuntu3) ... 455s Selecting previously unselected package libllvm14:amd64. 455s Preparing to unpack .../28-libllvm14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 455s Unpacking libllvm14:amd64 (1:14.0.0-1ubuntu1.1) ... 455s Selecting previously unselected package libclang-cpp14. 455s Preparing to unpack .../29-libclang-cpp14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 455s Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 455s Selecting previously unselected package libgc1:amd64. 455s Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_amd64.deb ... 455s Unpacking libgc1:amd64 (1:8.0.6-1.1build1) ... 455s Selecting previously unselected package libobjc4:amd64. 455s Preparing to unpack .../31-libobjc4_12.3.0-1ubuntu1~22.04_amd64.deb ... 455s Unpacking libobjc4:amd64 (12.3.0-1ubuntu1~22.04) ... 455s Selecting previously unselected package libobjc-11-dev:amd64. 455s Preparing to unpack .../32-libobjc-11-dev_11.4.0-1ubuntu1~22.04_amd64.deb ... 455s Unpacking libobjc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 455s Selecting previously unselected package libc6-i386. 455s Preparing to unpack .../33-libc6-i386_2.35-0ubuntu3.9_amd64.deb ... 455s Unpacking libc6-i386 (2.35-0ubuntu3.9) ... 455s Selecting previously unselected package lib32gcc-s1. 455s Preparing to unpack .../34-lib32gcc-s1_12.3.0-1ubuntu1~22.04_amd64.deb ... 455s Unpacking lib32gcc-s1 (12.3.0-1ubuntu1~22.04) ... 455s Selecting previously unselected package lib32stdc++6. 455s Preparing to unpack .../35-lib32stdc++6_12.3.0-1ubuntu1~22.04_amd64.deb ... 455s Unpacking lib32stdc++6 (12.3.0-1ubuntu1~22.04) ... 455s Selecting previously unselected package libclang-common-14-dev. 455s Preparing to unpack .../36-libclang-common-14-dev_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 455s Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 456s Selecting previously unselected package llvm-14-linker-tools. 456s Preparing to unpack .../37-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 456s Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 456s Selecting previously unselected package libclang1-14. 456s Preparing to unpack .../38-libclang1-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 456s Unpacking libclang1-14 (1:14.0.0-1ubuntu1.1) ... 456s Selecting previously unselected package clang-14. 456s Preparing to unpack .../39-clang-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 456s Unpacking clang-14 (1:14.0.0-1ubuntu1.1) ... 456s Selecting previously unselected package icu-devtools. 456s Preparing to unpack .../40-icu-devtools_70.1-2_amd64.deb ... 456s Unpacking icu-devtools (70.1-2) ... 456s Selecting previously unselected package libpgtypes3:amd64. 456s Preparing to unpack .../41-libpgtypes3_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libpgtypes3:amd64 (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libpq5:amd64. 456s Preparing to unpack .../42-libpq5_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libpq5:amd64 (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libecpg6:amd64. 456s Preparing to unpack .../43-libecpg6_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libecpg6:amd64 (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libecpg-compat3:amd64. 456s Preparing to unpack .../44-libecpg-compat3_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libecpg-compat3:amd64 (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libssl-dev:amd64. 456s Preparing to unpack .../45-libssl-dev_3.0.2-0ubuntu1.19_amd64.deb ... 456s Unpacking libssl-dev:amd64 (3.0.2-0ubuntu1.19) ... 456s Selecting previously unselected package libpq-dev. 456s Preparing to unpack .../46-libpq-dev_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libpq-dev (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libecpg-dev. 456s Preparing to unpack .../47-libecpg-dev_14.15-0ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libecpg-dev (14.15-0ubuntu0.22.04.1) ... 456s Selecting previously unselected package libicu-dev:amd64. 456s Preparing to unpack .../48-libicu-dev_70.1-2_amd64.deb ... 456s Unpacking libicu-dev:amd64 (70.1-2) ... 456s Selecting previously unselected package libjson-perl. 456s Preparing to unpack .../49-libjson-perl_4.04000-1_all.deb ... 456s Unpacking libjson-perl (4.04000-1) ... 456s Selecting previously unselected package libncurses-dev:amd64. 456s Preparing to unpack .../50-libncurses-dev_6.3-2ubuntu0.1_amd64.deb ... 456s Unpacking libncurses-dev:amd64 (6.3-2ubuntu0.1) ... 456s Selecting previously unselected package libpython3.10:amd64. 456s Preparing to unpack .../51-libpython3.10_3.10.12-1~22.04.9_amd64.deb ... 456s Unpacking libpython3.10:amd64 (3.10.12-1~22.04.9) ... 456s Selecting previously unselected package libtinfo-dev:amd64. 456s Preparing to unpack .../52-libtinfo-dev_6.3-2ubuntu0.1_amd64.deb ... 456s Unpacking libtinfo-dev:amd64 (6.3-2ubuntu0.1) ... 456s Selecting previously unselected package libxml2-dev:amd64. 456s Preparing to unpack .../53-libxml2-dev_2.9.13+dfsg-1ubuntu0.6_amd64.deb ... 456s Unpacking libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.6) ... 456s Selecting previously unselected package libxslt1.1:amd64. 456s Preparing to unpack .../54-libxslt1.1_1.1.34-4ubuntu0.22.04.1_amd64.deb ... 456s Unpacking libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ... 456s Selecting previously unselected package llvm-14-runtime. 456s Preparing to unpack .../55-llvm-14-runtime_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 456s Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 456s Selecting previously unselected package libpfm4:amd64. 456s Preparing to unpack .../56-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_amd64.deb ... 456s Unpacking libpfm4:amd64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 456s Selecting previously unselected package llvm-14. 456s Preparing to unpack .../57-llvm-14_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 456s Unpacking llvm-14 (1:14.0.0-1ubuntu1.1) ... 457s Selecting previously unselected package libffi-dev:amd64. 457s Preparing to unpack .../58-libffi-dev_3.4.2-4_amd64.deb ... 457s Unpacking libffi-dev:amd64 (3.4.2-4) ... 457s Selecting previously unselected package python3-pygments. 457s Preparing to unpack .../59-python3-pygments_2.11.2+dfsg-2ubuntu0.1_all.deb ... 457s Unpacking python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 457s Selecting previously unselected package llvm-14-tools. 457s Preparing to unpack .../60-llvm-14-tools_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 457s Unpacking llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 457s Selecting previously unselected package libz3-4:amd64. 457s Preparing to unpack .../61-libz3-4_4.8.12-1_amd64.deb ... 457s Unpacking libz3-4:amd64 (4.8.12-1) ... 457s Selecting previously unselected package libz3-dev:amd64. 457s Preparing to unpack .../62-libz3-dev_4.8.12-1_amd64.deb ... 457s Unpacking libz3-dev:amd64 (4.8.12-1) ... 457s Selecting previously unselected package llvm-14-dev. 457s Preparing to unpack .../63-llvm-14-dev_1%3a14.0.0-1ubuntu1.1_amd64.deb ... 457s Unpacking llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 458s Selecting previously unselected package postgresql-client-common. 458s Preparing to unpack .../64-postgresql-client-common_238_all.deb ... 458s Unpacking postgresql-client-common (238) ... 458s Selecting previously unselected package postgresql-client-14. 458s Preparing to unpack .../65-postgresql-client-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 458s Unpacking postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package ssl-cert. 458s Preparing to unpack .../66-ssl-cert_1.1.2_all.deb ... 458s Unpacking ssl-cert (1.1.2) ... 458s Selecting previously unselected package postgresql-common. 458s Preparing to unpack .../67-postgresql-common_238_all.deb ... 458s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 458s Unpacking postgresql-common (238) ... 458s Selecting previously unselected package postgresql-14. 458s Preparing to unpack .../68-postgresql-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 458s Unpacking postgresql-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package postgresql-doc-14. 458s Preparing to unpack .../69-postgresql-doc-14_14.15-0ubuntu0.22.04.1_all.deb ... 458s Unpacking postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package postgresql-plperl-14. 458s Preparing to unpack .../70-postgresql-plperl-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 458s Unpacking postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package postgresql-plpython3-14. 458s Preparing to unpack .../71-postgresql-plpython3-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 458s Unpacking postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package postgresql-pltcl-14. 458s Preparing to unpack .../72-postgresql-pltcl-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 458s Unpacking postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 458s Selecting previously unselected package postgresql-server-dev-14. 459s Preparing to unpack .../73-postgresql-server-dev-14_14.15-0ubuntu0.22.04.1_amd64.deb ... 459s Unpacking postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 459s Setting up postgresql-client-common (238) ... 459s Setting up libpgtypes3:amd64 (14.15-0ubuntu0.22.04.1) ... 459s Setting up gcc-11-base:amd64 (11.4.0-1ubuntu1~22.04) ... 459s Setting up libpython3.10:amd64 (3.10.12-1~22.04.9) ... 459s Setting up libpq5:amd64 (14.15-0ubuntu0.22.04.1) ... 459s Setting up linux-libc-dev:amd64 (5.15.0-133.144) ... 459s Setting up postgresql-doc-14 (14.15-0ubuntu0.22.04.1) ... 459s 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 459s Setting up libgomp1:amd64 (12.3.0-1ubuntu1~22.04) ... 459s Setting up postgresql-client-14 (14.15-0ubuntu0.22.04.1) ... 459s 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 459s Setting up libffi-dev:amd64 (3.4.2-4) ... 459s Setting up libasan6:amd64 (11.4.0-1ubuntu1~22.04) ... 459s Setting up python3-pygments (2.11.2+dfsg-2ubuntu0.1) ... 460s Setting up libz3-4:amd64 (4.8.12-1) ... 460s Setting up libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... 460s Setting up libpfm4:amd64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... 460s Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... 460s Setting up ssl-cert (1.1.2) ... 460s Setting up libquadmath0:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up libssl-dev:amd64 (3.0.2-0ubuntu1.19) ... 460s Setting up libmpc3:amd64 (1.2.1-2build1) ... 460s Setting up libatomic1:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up icu-devtools (70.1-2) ... 460s Setting up libgc1:amd64 (1:8.0.6-1.1build1) ... 460s Setting up libubsan1:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up libllvm14:amd64 (1:14.0.0-1ubuntu1.1) ... 460s Setting up libnsl-dev:amd64 (1.3.0-2build2) ... 460s Setting up libcrypt-dev:amd64 (1:4.4.27-1) ... 460s Setting up libjson-perl (4.04000-1) ... 460s Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ... 460s Setting up libecpg6:amd64 (14.15-0ubuntu0.22.04.1) ... 460s Setting up libc6-i386 (2.35-0ubuntu3.9) ... 460s Setting up libisl23:amd64 (0.24-2build1) ... 460s Setting up libc-dev-bin (2.35-0ubuntu3.9) ... 460s Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1.1) ... 460s Setting up libcc1-0:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up liblsan0:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up libitm1:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up libtsan0:amd64 (11.4.0-1ubuntu1~22.04) ... 460s Setting up llvm-14-tools (1:14.0.0-1ubuntu1.1) ... 460s Setting up cpp-11 (11.4.0-1ubuntu1~22.04) ... 460s Setting up libz3-dev:amd64 (4.8.12-1) ... 460s Setting up libecpg-compat3:amd64 (14.15-0ubuntu0.22.04.1) ... 460s Setting up libclang1-14 (1:14.0.0-1ubuntu1.1) ... 460s Setting up libpq-dev (14.15-0ubuntu0.22.04.1) ... 460s Setting up libobjc4:amd64 (12.3.0-1ubuntu1~22.04) ... 460s Setting up libecpg-dev (14.15-0ubuntu0.22.04.1) ... 460s Setting up llvm-14-runtime (1:14.0.0-1ubuntu1.1) ... 460s Setting up lib32gcc-s1 (12.3.0-1ubuntu1~22.04) ... 460s Setting up lib32stdc++6 (12.3.0-1ubuntu1~22.04) ... 460s Setting up postgresql-common (238) ... 460s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 460s Adding user postgres to group ssl-cert 460s 460s Creating config file /etc/postgresql-common/createcluster.conf with new version 460s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 460s Removing obsolete dictionary files: 461s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 461s Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1.1) ... 461s Setting up libclang-cpp14 (1:14.0.0-1ubuntu1.1) ... 461s Setting up libgcc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 461s Setting up gcc-11 (11.4.0-1ubuntu1~22.04) ... 461s Setting up cpp (4:11.2.0-1ubuntu1) ... 461s Setting up libc6-dev:amd64 (2.35-0ubuntu3.9) ... 461s Setting up libicu-dev:amd64 (70.1-2) ... 461s Setting up llvm-14 (1:14.0.0-1ubuntu1.1) ... 461s Setting up postgresql-14 (14.15-0ubuntu0.22.04.1) ... 461s Creating new PostgreSQL cluster 14/main ... 461s /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions 461s The files belonging to this database system will be owned by user "postgres". 461s This user must also own the server process. 461s 461s The database cluster will be initialized with locale "C.UTF-8". 461s The default database encoding has accordingly been set to "UTF8". 461s The default text search configuration will be set to "english". 461s 461s Data page checksums are disabled. 461s 461s fixing permissions on existing directory /var/lib/postgresql/14/main ... ok 461s creating subdirectories ... ok 461s selecting dynamic shared memory implementation ... posix 461s selecting default max_connections ... 100 461s selecting default shared_buffers ... 128MB 461s selecting default time zone ... Etc/UTC 461s creating configuration files ... ok 461s running bootstrap script ... ok 462s performing post-bootstrap initialization ... ok 462s syncing data to disk ... ok 462s 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 465s Setting up libncurses-dev:amd64 (6.3-2ubuntu0.1) ... 465s Setting up postgresql-pltcl-14 (14.15-0ubuntu0.22.04.1) ... 465s Setting up libobjc-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 465s Setting up gcc (4:11.2.0-1ubuntu1) ... 465s Setting up libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.6) ... 465s Setting up postgresql-plperl-14 (14.15-0ubuntu0.22.04.1) ... 465s Setting up libstdc++-11-dev:amd64 (11.4.0-1ubuntu1~22.04) ... 465s Setting up postgresql-plpython3-14 (14.15-0ubuntu0.22.04.1) ... 465s Setting up llvm-14-dev (1:14.0.0-1ubuntu1.1) ... 465s Setting up libtinfo-dev:amd64 (6.3-2ubuntu0.1) ... 465s Setting up clang-14 (1:14.0.0-1ubuntu1.1) ... 465s Setting up g++-11 (11.4.0-1ubuntu1~22.04) ... 465s Setting up postgresql-server-dev-14 (14.15-0ubuntu0.22.04.1) ... 465s Setting up g++ (4:11.2.0-1ubuntu1) ... 465s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 465s Setting up build-essential (12.9ubuntu3) ... 465s Processing triggers for libc-bin (2.35-0ubuntu3.9) ... 465s Processing triggers for man-db (2.10.2-1) ... 465s Processing triggers for install-info (6.8-4build1) ... 488s autopkgtest [13:33:00]: test installcheck: [----------------------- 488s + dpkg-parsechangelog -SSource 488s + SOURCE=postgresql-14 488s + MAJOR=14 488s + top_srcdir=/tmp/autopkgtest.FVKTmM/build.1Wp/src 488s + cd src/test/regress 488s + make -f /tmp/autopkgtest.FVKTmM/build.1Wp/src/debian/tests/Makefile.regress PG_CONFIG=/usr/lib/postgresql/14/bin/pg_config with_llvm=no 489s 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 -g -g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I. -I/tmp/autopkgtest.FVKTmM/build.1Wp/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 489s 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 -g -g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -shared -o regress.so regress.o -L/usr/lib/x86_64-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 489s + sed -i -e s:@libdir@/regress:/tmp/autopkgtest.FVKTmM/build.1Wp/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 489s + id -u 489s + [ 1000 = 0 ] 489s + SU=sh 489s + sh 489s + mktemp -d /tmp/regress.XXXXXX 489s + OUTPUT=/tmp/regress.vbq3jw 489s + trap rm -rf /tmp/regress.vbq3jw EXIT 489s + pg_virtualenv -v 14 /usr/lib/postgresql/14/lib/pgxs/src/test/regress/pg_regress --schedule=parallel_schedule --make-testtablespace-dir --outputdir=/tmp/regress.vbq3jw --temp-config=/usr/share/postgresql-common/server/test-with-jit.conf 489s Creating new PostgreSQL cluster 14/regress ... 492s (using postmaster on localhost, port 5433) 492s ============== dropping database "regression" ============== 492s NOTICE: database "regression" does not exist, skipping 492s DROP DATABASE 492s ============== creating database "regression" ============== 492s CREATE DATABASE 492s ALTER DATABASE 492s ============== running regression test queries ============== 492s test tablespace ... ok 189 ms 493s parallel group (20 tests): oid varchar float4 regproc int2 uuid name pg_lsn enum char text int4 boolean int8 txid money bit float8 numeric rangetypes 493s boolean ... ok 398 ms 493s char ... ok 370 ms 493s name ... ok 247 ms 493s varchar ... ok 88 ms 493s text ... ok 374 ms 493s int2 ... ok 164 ms 493s int4 ... ok 375 ms 493s int8 ... ok 404 ms 493s oid ... ok 86 ms 493s float4 ... ok 104 ms 493s float8 ... ok 448 ms 493s bit ... ok 426 ms 493s numeric ... ok 567 ms 493s txid ... ok 416 ms 493s uuid ... ok 164 ms 493s enum ... ok 354 ms 493s money ... ok 420 ms 493s rangetypes ... ok 607 ms 493s pg_lsn ... ok 326 ms 493s regproc ... ok 104 ms 494s parallel group (20 tests): strings create_function_0 circle line time timetz macaddr path macaddr8 lseg inet interval date numerology point timestamp timestamptz multirangetypes polygon box 494s strings ... ok 193 ms 494s numerology ... ok 465 ms 494s point ... ok 532 ms 494s lseg ... ok 343 ms 494s line ... ok 260 ms 494s box ... ok 924 ms 494s path ... ok 312 ms 494s polygon ... ok 894 ms 494s circle ... ok 238 ms 494s date ... ok 429 ms 494s time ... ok 263 ms 494s timetz ... ok 276 ms 494s timestamp ... ok 546 ms 494s timestamptz ... FAILED 607 ms 494s interval ... ok 409 ms 494s inet ... ok 368 ms 494s macaddr ... ok 279 ms 494s macaddr8 ... ok 322 ms 494s multirangetypes ... ok 830 ms 494s create_function_0 ... ok 235 ms 495s parallel group (13 tests): misc_sanity mvcc unicode comments expressions xid tstypes database type_sanity geometry opr_sanity regex horology 495s geometry ... ok 339 ms 495s horology ... ok 580 ms 495s tstypes ... ok 289 ms 495s regex ... ok 499 ms 495s type_sanity ... ok 301 ms 495s opr_sanity ... ok 484 ms 495s misc_sanity ... ok 146 ms 495s comments ... ok 203 ms 495s expressions ... ok 240 ms 495s unicode ... ok 194 ms 495s xid ... ok 252 ms 495s mvcc ... ok 168 ms 495s database ... ok 292 ms 495s test create_function_1 ... ok 16 ms 495s test create_type ... ok 27 ms 495s test create_table ... ok 206 ms 495s test create_function_2 ... ok 21 ms 495s parallel group (5 tests): copydml copyselect insert_conflict insert copy 495s copy ... ok 314 ms 495s copyselect ... ok 86 ms 495s copydml ... ok 66 ms 495s insert ... ok 281 ms 495s insert_conflict ... ok 211 ms 495s parallel group (4 tests): create_schema create_operator create_procedure create_misc 495s create_misc ... ok 89 ms 495s create_operator ... ok 56 ms 495s create_procedure ... ok 69 ms 495s create_schema ... ok 51 ms 496s parallel group (5 tests): index_including create_view index_including_gist create_index_spgist create_index 496s create_index ... ok 1062 ms 496s create_index_spgist ... ok 929 ms 496s create_view ... ok 348 ms 496s index_including ... ok 225 ms 496s index_including_gist ... ok 352 ms 497s parallel group (16 tests): hash_func select create_cast create_aggregate drop_if_exists roleattributes typed_table errors create_am create_function_3 infinite_recurse constraints vacuum updatable_views inherit triggers 497s create_aggregate ... ok 190 ms 497s create_function_3 ... ok 438 ms 497s create_cast ... ok 179 ms 497s constraints ... ok 539 ms 497s triggers ... ok 976 ms 497s select ... ok 152 ms 497s inherit ... ok 934 ms 497s typed_table ... ok 283 ms 497s vacuum ... ok 640 ms 497s drop_if_exists ... ok 195 ms 497s updatable_views ... ok 840 ms 497s roleattributes ... ok 212 ms 497s create_am ... ok 366 ms 497s hash_func ... ok 125 ms 497s errors ... ok 305 ms 497s infinite_recurse ... ok 499 ms 497s test sanity_check ... ok 85 ms 499s parallel group (20 tests): delete select_into select_implicit namespace select_having prepared_xacts subselect select_distinct_on random case portals select_distinct transactions union hash_index arrays update aggregates join btree_index 499s select_into ... ok 132 ms 499s select_distinct ... ok 547 ms 499s select_distinct_on ... ok 301 ms 499s select_implicit ... ok 142 ms 499s select_having ... ok 151 ms 499s subselect ... ok 239 ms 499s union ... ok 687 ms 499s case ... ok 446 ms 499s join ... ok 1451 ms 499s aggregates ... ok 1276 ms 499s transactions ... ok 575 ms 499s random ... ok 381 ms 499s portals ... ok 535 ms 499s arrays ... ok 779 ms 499s btree_index ... ok 1558 ms 499s hash_index ... ok 701 ms 499s update ... ok 1000 ms 499s delete ... ok 44 ms 499s namespace ... ok 146 ms 499s prepared_xacts ... ok 228 ms 505s parallel group (20 tests): drop_operator tablesample object_address lock init_privs security_label replica_identity spgist identity password matview generated collate rowsecurity gist groupingsets gin join_hash brin privileges 505s brin ... ok 5313 ms 505s gin ... ok 2215 ms 505s gist ... ok 1758 ms 505s spgist ... ok 657 ms 505s privileges ... ok 5582 ms 505s init_privs ... ok 547 ms 505s security_label ... ok 547 ms 505s collate ... ok 1472 ms 505s matview ... ok 1217 ms 505s lock ... ok 494 ms 505s replica_identity ... ok 586 ms 505s rowsecurity ... ok 1487 ms 505s object_address ... ok 488 ms 505s tablesample ... ok 427 ms 505s groupingsets ... ok 2030 ms 505s drop_operator ... ok 340 ms 505s password ... ok 923 ms 505s identity ... ok 870 ms 505s generated ... ok 1228 ms 505s join_hash ... ok 5309 ms 505s parallel group (2 tests): brin_bloom brin_multi 505s brin_bloom ... ok 54 ms 505s brin_multi ... ok 125 ms 506s parallel group (14 tests): dbsize alter_generic tidscan async tid tsrf alter_operator sysviews misc_functions tidrangescan create_table_like incremental_sort collate.icu.utf8 misc 506s create_table_like ... ok 545 ms 506s alter_generic ... ok 81 ms 506s alter_operator ... ok 232 ms 506s misc ... ok 809 ms 506s async ... ok 166 ms 506s dbsize ... ok 48 ms 506s misc_functions ... ok 323 ms 506s sysviews ... ok 319 ms 506s tsrf ... ok 224 ms 506s tid ... ok 194 ms 506s tidscan ... ok 108 ms 506s tidrangescan ... ok 501 ms 506s collate.icu.utf8 ... ok 708 ms 506s incremental_sort ... ok 587 ms 507s parallel group (6 tests): amutils collate.linux.utf8 psql_crosstab rules psql stats_ext 507s rules ... ok 230 ms 507s psql ... ok 301 ms 507s psql_crosstab ... ok 62 ms 507s amutils ... ok 45 ms 507s stats_ext ... ok 979 ms 507s collate.linux.utf8 ... ok 58 ms 509s test select_parallel ... ok 2539 ms 509s test write_parallel ... ok 102 ms 509s test vacuum_parallel ... ok 84 ms 509s parallel group (2 tests): subscription publication 509s publication ... ok 62 ms 509s subscription ... ok 36 ms 511s parallel group (17 tests): select_views combocid functional_deps guc advisory_lock dependency portals_p2 xmlmap equivclass tsdicts window cluster bitmapops indirect_toast foreign_data foreign_key tsearch 511s select_views ... ok 123 ms 511s portals_p2 ... ok 315 ms 511s foreign_key ... ok 1130 ms 511s cluster ... ok 653 ms 511s dependency ... ok 301 ms 511s guc ... ok 234 ms 511s bitmapops ... ok 691 ms 511s combocid ... ok 191 ms 511s tsearch ... ok 1154 ms 511s tsdicts ... ok 343 ms 511s foreign_data ... ok 894 ms 511s window ... ok 450 ms 511s xmlmap ... ok 323 ms 511s functional_deps ... ok 200 ms 511s advisory_lock ... ok 283 ms 511s indirect_toast ... ok 850 ms 511s equivclass ... ok 334 ms 511s parallel group (6 tests): jsonpath json_encoding jsonpath_encoding jsonb_jsonpath json jsonb 511s json ... ok 155 ms 511s jsonb ... ok 231 ms 511s json_encoding ... ok 79 ms 511s jsonpath ... ok 42 ms 511s jsonpath_encoding ... ok 79 ms 511s jsonb_jsonpath ... ok 142 ms 512s parallel group (18 tests): plancache prepare conversion returning limit copy2 truncate sequence domain rowtypes polymorphism temp with largeobject rangefuncs plpgsql xml alter_table 512s plancache ... ok 190 ms 512s limit ... ok 321 ms 512s plpgsql ... ok 1007 ms 512s copy2 ... ok 486 ms 512s temp ... ok 714 ms 512s domain ... ok 599 ms 512s rangefuncs ... ok 954 ms 512s prepare ... ok 233 ms 512s conversion ... ok 242 ms 512s truncate ... ok 583 ms 512s alter_table ... ok 1358 ms 512s sequence ... ok 598 ms 512s polymorphism ... ok 683 ms 512s rowtypes ... ok 632 ms 512s returning ... ok 288 ms 512s largeobject ... ok 792 ms 512s with ... ok 744 ms 512s xml ... ok 1042 ms 514s parallel group (11 tests): hash_part partition_info reloptions explain compression memoize partition_join indexing partition_aggregate tuplesort partition_prune 514s partition_join ... ok 1185 ms 514s partition_prune ... ok 1561 ms 514s reloptions ... ok 220 ms 514s hash_part ... ok 132 ms 514s indexing ... ok 1201 ms 514s partition_aggregate ... ok 1233 ms 514s partition_info ... ok 162 ms 514s tuplesort ... ok 1485 ms 514s explain ... ok 227 ms 514s compression ... ok 348 ms 514s memoize ... ok 1040 ms 514s parallel group (2 tests): event_trigger oidjoins 514s event_trigger ... ok 72 ms 514s oidjoins ... ok 166 ms 514s test fast_default ... ok 80 ms 515s test stats ... ok 575 ms 515s 515s ======================== 515s 1 of 212 tests failed. 515s ======================== 515s 515s The differences that caused some tests to fail can be viewed in the 515s file "/tmp/regress.vbq3jw/regression.diffs". A copy of the test summary that you see 515s above is saved in the file "/tmp/regress.vbq3jw/regression.out". 515s 515s *** /tmp/pg_virtualenv.aFeiGf/log/postgresql-14-regress.log (last 100 lines) *** 515s 2025-02-26 13:33:25.799 UTC [5817] ubuntu@regression DETAIL: Key (a)=(3) already exists. 515s 2025-02-26 13:33:25.799 UTC [5817] ubuntu@regression STATEMENT: insert into covidxpart values (3, 1); 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression ERROR: duplicate key value violates unique constraint "covidxpart4_a_b_idx" 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression DETAIL: Key (a)=(4) already exists. 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression STATEMENT: insert into covidxpart values (4, 1); 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression ERROR: unique constraint on partitioned table must include all partitioning columns 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression DETAIL: UNIQUE constraint on table "covidxpart" lacks column "a" which is part of the partition key. 515s 2025-02-26 13:33:25.800 UTC [5817] ubuntu@regression STATEMENT: create unique index on covidxpart (b) include (a); 515s 2025-02-26 13:33:25.802 UTC [5817] ubuntu@regression ERROR: cannot drop inherited constraint "parted_pk_detach_test1_pkey" of relation "parted_pk_detach_test1" 515s 2025-02-26 13:33:25.802 UTC [5817] ubuntu@regression STATEMENT: alter table parted_pk_detach_test1 drop constraint parted_pk_detach_test1_pkey; 515s 2025-02-26 13:33:25.808 UTC [5817] ubuntu@regression ERROR: cannot drop inherited constraint "parted_uniq_detach_test1_a_key" of relation "parted_uniq_detach_test1" 515s 2025-02-26 13:33:25.808 UTC [5817] ubuntu@regression STATEMENT: alter table parted_uniq_detach_test1 drop constraint parted_uniq_detach_test1_a_key; 515s 2025-02-26 13:33:25.876 UTC [5817] ubuntu@regression ERROR: division by zero 515s 2025-02-26 13:33:25.876 UTC [5817] ubuntu@regression STATEMENT: create index concurrently parted_isvalid_idx_11 on parted_isvalid_tab_11 ((a/b)); 515s 2025-02-26 13:33:26.290 UTC [5906] ubuntu@regression ERROR: function pg_backend_pid must return type event_trigger 515s 2025-02-26 13:33:26.290 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger 515s on ddl_command_start 515s execute procedure pg_backend_pid(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: trigger functions can only be called as triggers 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger" near line 1 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: SELECT test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: event trigger functions cannot have declared arguments 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression CONTEXT: compilation of PL/pgSQL function "test_event_trigger_arg" near line 1 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create function test_event_trigger_arg(name text) 515s returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql; 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: SQL functions cannot return type event_trigger 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$ 515s SELECT 1 $$ language sql; 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: unrecognized event name "elephant_bootstrap" 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: unrecognized filter variable "food" 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when food in ('sandwich') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: filter value "sandwich" not recognized for filter variable "tag" 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('sandwich') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: filter value "create skunkcabbage" not recognized for filter variable "tag" 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('create table', 'create skunkcabbage') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: event triggers are not supported for DROP EVENT TRIGGER 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('DROP EVENT TRIGGER') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression ERROR: event triggers are not supported for CREATE ROLE 515s 2025-02-26 13:33:26.292 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('CREATE ROLE') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression ERROR: event triggers are not supported for CREATE DATABASE 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('CREATE DATABASE') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression ERROR: event triggers are not supported for CREATE TABLESPACE 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('CREATE TABLESPACE') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression ERROR: filter variable "tag" specified more than once 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s when tag in ('create table') and tag in ('CREATE FUNCTION') 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression ERROR: syntax error at or near "'argument not allowed'" at character 106 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start 515s execute procedure test_event_trigger('argument not allowed'); 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression ERROR: permission denied to create event trigger "regress_event_trigger_noperms" 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression HINT: Must be superuser to create an event trigger. 515s 2025-02-26 13:33:26.293 UTC [5906] ubuntu@regression STATEMENT: create event trigger regress_event_trigger_noperms on ddl_command_start 515s execute procedure test_event_trigger(); 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression ERROR: permission denied to change owner of event trigger "regress_event_trigger" 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression HINT: The owner of an event trigger must be a superuser. 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user; 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression ERROR: event trigger "regress_event_trigger2" already exists 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression STATEMENT: alter event trigger regress_event_trigger rename to regress_event_trigger2; 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression ERROR: event trigger "regress_event_trigger" does not exist 515s 2025-02-26 13:33:26.301 UTC [5906] ubuntu@regression STATEMENT: drop event trigger regress_event_trigger; 515s 2025-02-26 13:33:26.302 UTC [5906] ubuntu@regression ERROR: role "regress_evt_user" cannot be dropped because some objects depend on it 515s 2025-02-26 13:33:26.302 UTC [5906] ubuntu@regression DETAIL: owner of event trigger regress_event_trigger3 515s owner of user mapping for regress_evt_user on server useless_server 515s owner of default privileges on new relations belonging to role regress_evt_user 515s 2025-02-26 13:33:26.302 UTC [5906] ubuntu@regression STATEMENT: drop role regress_evt_user; 515s 2025-02-26 13:33:26.311 UTC [5906] ubuntu@regression ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped 515s 2025-02-26 13:33:26.311 UTC [5906] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 515s SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three" 515s PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE 515s 2025-02-26 13:33:26.311 UTC [5906] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 515s 2025-02-26 13:33:26.313 UTC [5906] ubuntu@regression ERROR: object schema_one.table_three of type table cannot be dropped 515s 2025-02-26 13:33:26.313 UTC [5906] ubuntu@regression CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE 515s 2025-02-26 13:33:26.313 UTC [5906] ubuntu@regression STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE; 515s 2025-02-26 13:33:26.331 UTC [5906] ubuntu@regression ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a table_rewrite event trigger function 515s 2025-02-26 13:33:26.331 UTC [5906] ubuntu@regression STATEMENT: select pg_event_trigger_table_rewrite_oid(); 515s 2025-02-26 13:33:26.334 UTC [5906] ubuntu@regression ERROR: rewrites not allowed 515s 2025-02-26 13:33:26.334 UTC [5906] ubuntu@regression CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE 515s 2025-02-26 13:33:26.334 UTC [5906] ubuntu@regression STATEMENT: alter table rewriteme alter column foo type numeric; 515s 2025-02-26 13:33:26.343 UTC [5906] ubuntu@regression ERROR: cannot alter type "rewritetype" because column "rewritemetoo3.a" uses it 515s 2025-02-26 13:33:26.343 UTC [5906] ubuntu@regression STATEMENT: alter type rewritetype alter attribute a type varchar cascade; 515s 2025-02-26 13:33:27.093 UTC [5918] ubuntu@regression LOG: wait_for_stats delayed 0.520012 seconds 515s 2025-02-26 13:33:27.093 UTC [5918] ubuntu@regression CONTEXT: PL/pgSQL function wait_for_stats() line 48 at RAISE 515s 2025-02-26 13:33:27.093 UTC [5918] ubuntu@regression STATEMENT: SELECT wait_for_stats(); 515s Dropping cluster 14/regress ... 515s + head -100 /tmp/regress.vbq3jw/regression.diffs 515s diff -U3 /tmp/autopkgtest.FVKTmM/build.1Wp/src/src/test/regress/expected/timestamptz.out /tmp/regress.vbq3jw/results/timestamptz.out 515s --- /tmp/autopkgtest.FVKTmM/build.1Wp/src/src/test/regress/expected/timestamptz.out 2024-11-18 20:37:40.000000000 +0000 515s +++ /tmp/regress.vbq3jw/results/timestamptz.out 2025-02-26 13:33:06.198840364 +0000 515s @@ -2280,7 +2280,7 @@ 515s SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC'; 515s timezone 515s -------------------------- 515s - Wed Dec 09 15:56:00 1846 515s + Wed Dec 09 15:56:08 1846 515s (1 row) 515s 515s SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC'; 515s + exit 1 515s + rm -rf /tmp/regress.vbq3jw 515s autopkgtest [13:33:27]: test installcheck: -----------------------] 515s autopkgtest [13:33:27]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 515s installcheck FAIL non-zero exit status 1 516s autopkgtest [13:33:28]: @@@@@@@@@@@@@@@@@@@@ summary 516s run-testsuite PASS 516s installcheck FAIL non-zero exit status 1 532s nova [W] Skipping flock for amd64 532s Creating nova instance adt-jammy-amd64-postgresql-14-20250226-132452-juju-7f2275-prod-proposed-migration-environment-2-37f698ee-520a-4590-948d-b64ebb1fc37f from image adt/ubuntu-jammy-amd64-server-20250226.img (UUID 5a47d7a7-7b0c-426e-bf0f-f0e9b51f07c3)... 532s nova [W] Timed out waiting for e5a2f0dd-5e3f-48cf-ba96-656fe8438a72 to get deleted. 532s nova [W] Skipping flock for amd64 532s Creating nova instance adt-jammy-amd64-postgresql-14-20250226-132452-juju-7f2275-prod-proposed-migration-environment-2-37f698ee-520a-4590-948d-b64ebb1fc37f from image adt/ubuntu-jammy-amd64-server-20250226.img (UUID 5a47d7a7-7b0c-426e-bf0f-f0e9b51f07c3)... 532s nova [W] Timed out waiting for 3ed92ba2-9bcd-476c-9ce9-8df1184b8950 to get deleted.