0s autopkgtest [04:04:51]: starting date and time: 2025-03-26 04:04:51+0000 0s autopkgtest [04:04:51]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [04:04:51]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ln8lwyah/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-12 --apt-upgrade postgresql-common --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-12/12.22-0ubuntu0.20.04.3 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-40.secgroup --name adt-focal-arm64-postgresql-common-20250326-033156-juju-7f2275-prod-proposed-migration-environment-15-35df8041-d29e-4ed0-a270-8da500f48fd8 --image adt/ubuntu-focal-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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/ 75s autopkgtest [04:06:06]: testbed dpkg architecture: arm64 75s autopkgtest [04:06:06]: testbed apt version: 2.0.10 76s autopkgtest [04:06:07]: @@@@@@@@@@@@@@@@@@@@ test bed setup 76s autopkgtest [04:06:07]: testbed release detected to be: None 77s autopkgtest [04:06:08]: updating testbed package index (apt update) 77s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 77s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 77s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 77s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 78s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 78s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 78s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 78s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 Packages [296 kB] 78s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 c-n-f Metadata [1580 B] 78s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 Packages [2936 B] 78s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 c-n-f Metadata [116 B] 78s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 Packages [52.7 kB] 78s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 c-n-f Metadata [1844 B] 78s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 Packages [1020 B] 78s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 c-n-f Metadata [116 B] 80s Fetched 716 kB in 1s (644 kB/s) 81s Reading package lists... 82s autopkgtest [04:06:13]: upgrading testbed (apt dist-upgrade and autopurge) 82s Reading package lists... 82s Building dependency tree... 82s Reading state information... 83s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 83s Starting 2 pkgProblemResolver with broken count: 0 83s Done 83s 84s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 84s Reading package lists... 84s Building dependency tree... 84s Reading state information... 84s Starting pkgProblemResolver with broken count: 0 84s Starting 2 pkgProblemResolver with broken count: 0 84s Done 85s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 87s autopkgtest [04:06:18]: testbed running kernel: Linux 5.4.0-211-generic #231-Ubuntu SMP Tue Mar 11 17:09:29 UTC 2025 87s autopkgtest [04:06:18]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-common 95s Get:1 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (dsc) [2534 B] 95s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main postgresql-common 214ubuntu0.1 (tar) [216 kB] 95s gpgv: Signature made Mon Aug 24 15:04:29 2020 UTC 95s gpgv: using RSA key 50C4A0DDCF31E452CEB19B516569D855A744BE93 95s gpgv: Can't check signature: No public key 95s dpkg-source: warning: failed to verify signature on ./postgresql-common_214ubuntu0.1.dsc 95s autopkgtest [04:06:26]: testing package postgresql-common version 214ubuntu0.1 96s autopkgtest [04:06:27]: build not needed 96s autopkgtest [04:06:27]: test default-psql: preparing testbed 96s Reading package lists... 97s Building dependency tree... 97s Reading state information... 97s Starting pkgProblemResolver with broken count: 0 97s Starting 2 pkgProblemResolver with broken count: 0 97s Done 98s The following NEW packages will be installed: 98s libllvm10 libpq5 libxslt1.1 postgresql postgresql-12 postgresql-client-12 98s postgresql-client-common postgresql-common ssl-cert 98s 0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded. 98s Need to get 27.3 MB of archives. 98s After this operation, 111 MB of additional disk space will be used. 98s Get:1 http://ftpmaster.internal/ubuntu focal/main arm64 libllvm10 arm64 1:10.0.0-4ubuntu1 [12.7 MB] 99s Get:2 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libpq5 arm64 12.22-0ubuntu0.20.04.3 [111 kB] 99s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.20.04.3 [141 kB] 99s Get:4 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 99s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 postgresql-client-12 arm64 12.22-0ubuntu0.20.04.3 [1036 kB] 99s Get:6 http://ftpmaster.internal/ubuntu focal/main arm64 ssl-cert all 1.0.39 [17.0 kB] 99s Get:7 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-common all 214ubuntu0.1 [169 kB] 99s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 postgresql-12 arm64 12.22-0ubuntu0.20.04.3 [13.1 MB] 99s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql all 12+214ubuntu0.1 [3924 B] 99s Preconfiguring packages ... 100s Fetched 27.3 MB in 1s (20.1 MB/s) 100s Selecting previously unselected package libllvm10:arm64. 100s (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 ... 100156 files and directories currently installed.) 100s Preparing to unpack .../0-libllvm10_1%3a10.0.0-4ubuntu1_arm64.deb ... 100s Unpacking libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 101s Selecting previously unselected package libpq5:arm64. 101s Preparing to unpack .../1-libpq5_12.22-0ubuntu0.20.04.3_arm64.deb ... 101s Unpacking libpq5:arm64 (12.22-0ubuntu0.20.04.3) ... 101s Selecting previously unselected package libxslt1.1:arm64. 101s Preparing to unpack .../2-libxslt1.1_1.1.34-4ubuntu0.20.04.3_arm64.deb ... 101s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.3) ... 101s Selecting previously unselected package postgresql-client-common. 101s Preparing to unpack .../3-postgresql-client-common_214ubuntu0.1_all.deb ... 101s Unpacking postgresql-client-common (214ubuntu0.1) ... 101s Selecting previously unselected package postgresql-client-12. 101s Preparing to unpack .../4-postgresql-client-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 101s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 101s Selecting previously unselected package ssl-cert. 101s Preparing to unpack .../5-ssl-cert_1.0.39_all.deb ... 101s Unpacking ssl-cert (1.0.39) ... 101s Selecting previously unselected package postgresql-common. 101s Preparing to unpack .../6-postgresql-common_214ubuntu0.1_all.deb ... 101s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 101s Unpacking postgresql-common (214ubuntu0.1) ... 101s Selecting previously unselected package postgresql-12. 101s Preparing to unpack .../7-postgresql-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 101s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 102s Selecting previously unselected package postgresql. 102s Preparing to unpack .../8-postgresql_12+214ubuntu0.1_all.deb ... 102s Unpacking postgresql (12+214ubuntu0.1) ... 102s Setting up postgresql-client-common (214ubuntu0.1) ... 102s Setting up libpq5:arm64 (12.22-0ubuntu0.20.04.3) ... 102s Setting up libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 102s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 103s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 103s Setting up ssl-cert (1.0.39) ... 104s Setting up postgresql-common (214ubuntu0.1) ... 104s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 104s Adding user postgres to group ssl-cert 104s 104s Creating config file /etc/postgresql-common/createcluster.conf with new version 104s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 104s Removing obsolete dictionary files: 105s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 106s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.3) ... 106s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 106s Creating new PostgreSQL cluster 12/main ... 106s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 106s The files belonging to this database system will be owned by user "postgres". 106s This user must also own the server process. 106s 106s The database cluster will be initialized with locale "C.UTF-8". 106s The default database encoding has accordingly been set to "UTF8". 106s The default text search configuration will be set to "english". 106s 106s Data page checksums are disabled. 106s 106s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 106s creating subdirectories ... ok 106s selecting dynamic shared memory implementation ... posix 106s selecting default max_connections ... 100 106s selecting default shared_buffers ... 128MB 106s selecting default time zone ... Etc/UTC 106s creating configuration files ... ok 106s running bootstrap script ... ok 107s performing post-bootstrap initialization ... ok 107s syncing data to disk ... ok 107s 107s Success. You can now start the database server using: 107s 107s pg_ctlcluster 12 main start 107s 107s Ver Cluster Port Status Owner Data directory Log file 107s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 107s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 110s Setting up postgresql (12+214ubuntu0.1) ... 110s Processing triggers for systemd (245.4-4ubuntu3.24) ... 110s Processing triggers for man-db (2.9.1-1) ... 112s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 113s autopkgtest [04:06:44]: test default-psql: [----------------------- 114s autopkgtest [04:06:45]: test default-psql: -----------------------] 114s autopkgtest [04:06:45]: test default-psql: - - - - - - - - - - results - - - - - - - - - - 114s default-psql PASS 115s autopkgtest [04:06:46]: test run-testsuite: preparing testbed 220s autopkgtest [04:08:31]: testbed dpkg architecture: arm64 220s autopkgtest [04:08:31]: testbed apt version: 2.0.10 220s autopkgtest [04:08:31]: @@@@@@@@@@@@@@@@@@@@ test bed setup 221s autopkgtest [04:08:32]: testbed release detected to be: focal 221s autopkgtest [04:08:32]: updating testbed package index (apt update) 222s Hit:1 http://ftpmaster.internal/ubuntu focal InRelease 222s Hit:2 http://ftpmaster.internal/ubuntu focal-updates InRelease 222s Hit:3 http://ftpmaster.internal/ubuntu focal-security InRelease 222s Get:4 http://ftpmaster.internal/ubuntu focal-proposed InRelease [277 kB] 223s Get:5 http://ftpmaster.internal/ubuntu focal-proposed/restricted Sources [15.7 kB] 223s Get:6 http://ftpmaster.internal/ubuntu focal-proposed/main Sources [59.1 kB] 223s Get:7 http://ftpmaster.internal/ubuntu focal-proposed/universe Sources [8816 B] 223s Get:8 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 Packages [296 kB] 223s Get:9 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 c-n-f Metadata [1580 B] 223s Get:10 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 Packages [2936 B] 223s Get:11 http://ftpmaster.internal/ubuntu focal-proposed/restricted arm64 c-n-f Metadata [116 B] 223s Get:12 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 Packages [52.7 kB] 223s Get:13 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 c-n-f Metadata [1844 B] 223s Get:14 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 Packages [1020 B] 223s Get:15 http://ftpmaster.internal/ubuntu focal-proposed/multiverse arm64 c-n-f Metadata [116 B] 225s Fetched 716 kB in 2s (439 kB/s) 227s Reading package lists... 227s autopkgtest [04:08:38]: upgrading testbed (apt dist-upgrade and autopurge) 228s Reading package lists... 228s Building dependency tree... 228s Reading state information... 228s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 229s Starting 2 pkgProblemResolver with broken count: 0 229s Done 229s 229s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 229s Reading package lists... 230s Building dependency tree... 230s Reading state information... 230s Starting pkgProblemResolver with broken count: 0 230s Starting 2 pkgProblemResolver with broken count: 0 230s Done 231s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 234s Reading package lists... 234s Building dependency tree... 234s Reading state information... 234s Starting pkgProblemResolver with broken count: 0 236s Starting 2 pkgProblemResolver with broken count: 0 236s Done 236s The following NEW packages will be installed: 236s binfmt-support build-essential clang-10 cpp cpp-9 dictionaries-common 236s emacsen-common fakeroot g++ g++-9 gcc gcc-9 gcc-9-base hunspell-en-us 236s libasan5 libatomic1 libc-dev-bin libc6-dev libcc1-0 libclang-common-10-dev 236s libclang-cpp10 libclang1-10 libcrypt-dev libecpg-compat3 libecpg-dev 236s libecpg6 libfakeroot libffi-dev libgc1c2 libgcc-9-dev libgomp1 libisl22 236s libitm1 libllvm10 liblsan0 libmpc3 libncurses-dev libobjc-9-dev libobjc4 236s libpfm4 libpgtypes3 libpq-dev libpq5 libpython3.8 libstdc++-9-dev libtcl8.6 236s libtinfo-dev libtsan0 libubsan1 libxslt1.1 libz3-4 libz3-dev linux-libc-dev 236s llvm-10 llvm-10-dev llvm-10-runtime llvm-10-tools net-tools postgresql-12 236s postgresql-all postgresql-client-12 postgresql-client-common 236s postgresql-common postgresql-plperl-12 postgresql-plpython3-12 236s postgresql-pltcl-12 postgresql-server-dev-12 postgresql-server-dev-all 236s python3-pygments ssl-cert 236s 0 upgraded, 70 newly installed, 0 to remove and 0 not upgraded. 236s Need to get 117 MB of archives. 236s After this operation, 632 MB of additional disk space will be used. 236s Get:1 http://ftpmaster.internal/ubuntu focal/universe arm64 binfmt-support arm64 2.2.0-2 [55.5 kB] 236s Get:2 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc-dev-bin arm64 2.31-0ubuntu9.17 [64.2 kB] 236s Get:3 http://ftpmaster.internal/ubuntu focal-updates/main arm64 linux-libc-dev arm64 5.4.0-211.231 [1097 kB] 236s Get:4 http://ftpmaster.internal/ubuntu focal/main arm64 libcrypt-dev arm64 1:4.4.10-10ubuntu4 [111 kB] 236s Get:5 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libc6-dev arm64 2.31-0ubuntu9.17 [2069 kB] 236s Get:6 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9-base arm64 9.4.0-1ubuntu1~20.04.2 [18.9 kB] 236s Get:7 http://ftpmaster.internal/ubuntu focal/main arm64 libisl22 arm64 0.22.1-1 [537 kB] 236s Get:8 http://ftpmaster.internal/ubuntu focal/main arm64 libmpc3 arm64 1.1.0-1 [37.2 kB] 236s Get:9 http://ftpmaster.internal/ubuntu focal-updates/main arm64 cpp-9 arm64 9.4.0-1ubuntu1~20.04.2 [5985 kB] 236s Get:10 http://ftpmaster.internal/ubuntu focal/main arm64 cpp arm64 4:9.3.0-1ubuntu2 [27.6 kB] 236s Get:11 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libcc1-0 arm64 10.5.0-1ubuntu1~20.04 [46.2 kB] 236s Get:12 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgomp1 arm64 10.5.0-1ubuntu1~20.04 [93.5 kB] 236s Get:13 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libitm1 arm64 10.5.0-1ubuntu1~20.04 [24.1 kB] 236s Get:14 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libatomic1 arm64 10.5.0-1ubuntu1~20.04 [9808 B] 236s Get:15 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libasan5 arm64 9.4.0-1ubuntu1~20.04.2 [2690 kB] 236s Get:16 http://ftpmaster.internal/ubuntu focal-updates/main arm64 liblsan0 arm64 10.5.0-1ubuntu1~20.04 [800 kB] 236s Get:17 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtsan0 arm64 10.5.0-1ubuntu1~20.04 [1972 kB] 236s Get:18 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libubsan1 arm64 10.5.0-1ubuntu1~20.04 [765 kB] 236s Get:19 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libgcc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [920 kB] 236s Get:20 http://ftpmaster.internal/ubuntu focal-updates/main arm64 gcc-9 arm64 9.4.0-1ubuntu1~20.04.2 [6736 kB] 236s Get:21 http://ftpmaster.internal/ubuntu focal/main arm64 gcc arm64 4:9.3.0-1ubuntu2 [5228 B] 236s Get:22 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libstdc++-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [1687 kB] 236s Get:23 http://ftpmaster.internal/ubuntu focal-updates/main arm64 g++-9 arm64 9.4.0-1ubuntu1~20.04.2 [6843 kB] 236s Get:24 http://ftpmaster.internal/ubuntu focal/main arm64 g++ arm64 4:9.3.0-1ubuntu2 [1592 B] 236s Get:25 http://ftpmaster.internal/ubuntu focal-updates/main arm64 build-essential arm64 12.8ubuntu1.1 [4664 B] 236s Get:26 http://ftpmaster.internal/ubuntu focal/main arm64 libllvm10 arm64 1:10.0.0-4ubuntu1 [12.7 MB] 237s Get:27 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-cpp10 arm64 1:10.0.0-4ubuntu1 [8123 kB] 237s Get:28 http://ftpmaster.internal/ubuntu focal/main arm64 libgc1c2 arm64 1:7.6.4-0.4ubuntu1 [74.0 kB] 237s Get:29 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc4 arm64 10.5.0-1ubuntu1~20.04 [39.5 kB] 237s Get:30 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 libobjc-9-dev arm64 9.4.0-1ubuntu1~20.04.2 [211 kB] 237s Get:31 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang-common-10-dev arm64 1:10.0.0-4ubuntu1 [3267 kB] 237s Get:32 http://ftpmaster.internal/ubuntu focal/universe arm64 libclang1-10 arm64 1:10.0.0-4ubuntu1 [6176 kB] 237s Get:33 http://ftpmaster.internal/ubuntu focal/universe arm64 clang-10 arm64 1:10.0.0-4ubuntu1 [61.9 kB] 237s Get:34 http://ftpmaster.internal/ubuntu focal/main arm64 emacsen-common all 3.0.4 [14.9 kB] 237s Get:35 http://ftpmaster.internal/ubuntu focal/main arm64 dictionaries-common all 1.28.1 [178 kB] 237s Get:36 http://ftpmaster.internal/ubuntu focal/main arm64 libfakeroot arm64 1.24-1 [26.0 kB] 237s Get:37 http://ftpmaster.internal/ubuntu focal/main arm64 fakeroot arm64 1.24-1 [61.9 kB] 237s Get:38 http://ftpmaster.internal/ubuntu focal/main arm64 hunspell-en-us all 1:2018.04.16-1 [170 kB] 237s Get:39 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libpgtypes3 arm64 12.22-0ubuntu0.20.04.3 [43.2 kB] 237s Get:40 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libpq5 arm64 12.22-0ubuntu0.20.04.3 [111 kB] 237s Get:41 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libecpg6 arm64 12.22-0ubuntu0.20.04.3 [40.5 kB] 237s Get:42 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libecpg-compat3 arm64 12.22-0ubuntu0.20.04.3 [12.0 kB] 237s Get:43 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libpq-dev arm64 12.22-0ubuntu0.20.04.3 [134 kB] 237s Get:44 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 libecpg-dev arm64 12.22-0ubuntu0.20.04.3 [224 kB] 237s Get:45 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libncurses-dev arm64 6.2-0ubuntu2.1 [327 kB] 237s Get:46 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libpython3.8 arm64 3.8.10-0ubuntu1~20.04.18 [1492 kB] 237s Get:47 http://ftpmaster.internal/ubuntu focal/main arm64 libtcl8.6 arm64 8.6.10+dfsg-1 [849 kB] 237s Get:48 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libtinfo-dev arm64 6.2-0ubuntu2.1 [972 B] 237s Get:49 http://ftpmaster.internal/ubuntu focal-updates/main arm64 libxslt1.1 arm64 1.1.34-4ubuntu0.20.04.3 [141 kB] 237s Get:50 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-runtime arm64 1:10.0.0-4ubuntu1 [148 kB] 237s Get:51 http://ftpmaster.internal/ubuntu focal/main arm64 libpfm4 arm64 4.10.1+git20-g7700f49-2 [33.1 kB] 237s Get:52 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10 arm64 1:10.0.0-4ubuntu1 [4076 kB] 238s Get:53 http://ftpmaster.internal/ubuntu focal/main arm64 libffi-dev arm64 3.3-4 [53.5 kB] 238s Get:54 http://ftpmaster.internal/ubuntu focal-updates/main arm64 python3-pygments all 2.3.1+dfsg-1ubuntu2.2 [579 kB] 238s Get:55 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-tools arm64 1:10.0.0-4ubuntu1 [276 kB] 238s Get:56 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-4 arm64 4.8.7-4build1 [5860 kB] 238s Get:57 http://ftpmaster.internal/ubuntu focal/universe arm64 libz3-dev arm64 4.8.7-4build1 [67.5 kB] 238s Get:58 http://ftpmaster.internal/ubuntu focal/universe arm64 llvm-10-dev arm64 1:10.0.0-4ubuntu1 [23.0 MB] 238s Get:59 http://ftpmaster.internal/ubuntu focal/main arm64 net-tools arm64 1.60+git20180626.aebd88e-1ubuntu1 [194 kB] 238s Get:60 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-client-common all 214ubuntu0.1 [28.2 kB] 238s Get:61 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 postgresql-client-12 arm64 12.22-0ubuntu0.20.04.3 [1036 kB] 238s Get:62 http://ftpmaster.internal/ubuntu focal/main arm64 ssl-cert all 1.0.39 [17.0 kB] 238s Get:63 http://ftpmaster.internal/ubuntu focal-updates/main arm64 postgresql-common all 214ubuntu0.1 [169 kB] 238s Get:64 http://ftpmaster.internal/ubuntu focal-proposed/main arm64 postgresql-12 arm64 12.22-0ubuntu0.20.04.3 [13.1 MB] 239s Get:65 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 postgresql-server-dev-12 arm64 12.22-0ubuntu0.20.04.3 [991 kB] 239s Get:66 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-server-dev-all all 214ubuntu0.1 [7652 B] 239s Get:67 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 postgresql-plperl-12 arm64 12.22-0ubuntu0.20.04.3 [64.6 kB] 239s Get:68 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 postgresql-plpython3-12 arm64 12.22-0ubuntu0.20.04.3 [72.3 kB] 239s Get:69 http://ftpmaster.internal/ubuntu focal-proposed/universe arm64 postgresql-pltcl-12 arm64 12.22-0ubuntu0.20.04.3 [30.1 kB] 239s Get:70 http://ftpmaster.internal/ubuntu focal-updates/universe arm64 postgresql-all all 12+214ubuntu0.1 [1924 B] 240s Preconfiguring packages ... 240s Fetched 117 MB in 4s (30.8 MB/s) 240s Selecting previously unselected package binfmt-support. 240s (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 ... 100156 files and directories currently installed.) 240s Preparing to unpack .../00-binfmt-support_2.2.0-2_arm64.deb ... 240s Unpacking binfmt-support (2.2.0-2) ... 240s Selecting previously unselected package libc-dev-bin. 240s Preparing to unpack .../01-libc-dev-bin_2.31-0ubuntu9.17_arm64.deb ... 240s Unpacking libc-dev-bin (2.31-0ubuntu9.17) ... 240s Selecting previously unselected package linux-libc-dev:arm64. 240s Preparing to unpack .../02-linux-libc-dev_5.4.0-211.231_arm64.deb ... 240s Unpacking linux-libc-dev:arm64 (5.4.0-211.231) ... 240s Selecting previously unselected package libcrypt-dev:arm64. 240s Preparing to unpack .../03-libcrypt-dev_1%3a4.4.10-10ubuntu4_arm64.deb ... 240s Unpacking libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 240s Selecting previously unselected package libc6-dev:arm64. 240s Preparing to unpack .../04-libc6-dev_2.31-0ubuntu9.17_arm64.deb ... 240s Unpacking libc6-dev:arm64 (2.31-0ubuntu9.17) ... 241s Selecting previously unselected package gcc-9-base:arm64. 241s Preparing to unpack .../05-gcc-9-base_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 241s Unpacking gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 241s Selecting previously unselected package libisl22:arm64. 241s Preparing to unpack .../06-libisl22_0.22.1-1_arm64.deb ... 241s Unpacking libisl22:arm64 (0.22.1-1) ... 241s Selecting previously unselected package libmpc3:arm64. 241s Preparing to unpack .../07-libmpc3_1.1.0-1_arm64.deb ... 241s Unpacking libmpc3:arm64 (1.1.0-1) ... 241s Selecting previously unselected package cpp-9. 241s Preparing to unpack .../08-cpp-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 241s Unpacking cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 241s Selecting previously unselected package cpp. 241s Preparing to unpack .../09-cpp_4%3a9.3.0-1ubuntu2_arm64.deb ... 241s Unpacking cpp (4:9.3.0-1ubuntu2) ... 241s Selecting previously unselected package libcc1-0:arm64. 241s Preparing to unpack .../10-libcc1-0_10.5.0-1ubuntu1~20.04_arm64.deb ... 241s Unpacking libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 241s Selecting previously unselected package libgomp1:arm64. 241s Preparing to unpack .../11-libgomp1_10.5.0-1ubuntu1~20.04_arm64.deb ... 241s Unpacking libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 241s Selecting previously unselected package libitm1:arm64. 241s Preparing to unpack .../12-libitm1_10.5.0-1ubuntu1~20.04_arm64.deb ... 241s Unpacking libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 242s Selecting previously unselected package libatomic1:arm64. 242s Preparing to unpack .../13-libatomic1_10.5.0-1ubuntu1~20.04_arm64.deb ... 242s Unpacking libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 242s Selecting previously unselected package libasan5:arm64. 242s Preparing to unpack .../14-libasan5_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 242s Unpacking libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 242s Selecting previously unselected package liblsan0:arm64. 242s Preparing to unpack .../15-liblsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 242s Unpacking liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 242s Selecting previously unselected package libtsan0:arm64. 242s Preparing to unpack .../16-libtsan0_10.5.0-1ubuntu1~20.04_arm64.deb ... 242s Unpacking libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 242s Selecting previously unselected package libubsan1:arm64. 242s Preparing to unpack .../17-libubsan1_10.5.0-1ubuntu1~20.04_arm64.deb ... 242s Unpacking libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 242s Selecting previously unselected package libgcc-9-dev:arm64. 242s Preparing to unpack .../18-libgcc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 242s Unpacking libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 242s Selecting previously unselected package gcc-9. 242s Preparing to unpack .../19-gcc-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 242s Unpacking gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 243s Selecting previously unselected package gcc. 243s Preparing to unpack .../20-gcc_4%3a9.3.0-1ubuntu2_arm64.deb ... 243s Unpacking gcc (4:9.3.0-1ubuntu2) ... 243s Selecting previously unselected package libstdc++-9-dev:arm64. 243s Preparing to unpack .../21-libstdc++-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 243s Unpacking libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 243s Selecting previously unselected package g++-9. 243s Preparing to unpack .../22-g++-9_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 243s Unpacking g++-9 (9.4.0-1ubuntu1~20.04.2) ... 244s Selecting previously unselected package g++. 244s Preparing to unpack .../23-g++_4%3a9.3.0-1ubuntu2_arm64.deb ... 244s Unpacking g++ (4:9.3.0-1ubuntu2) ... 244s Selecting previously unselected package build-essential. 244s Preparing to unpack .../24-build-essential_12.8ubuntu1.1_arm64.deb ... 244s Unpacking build-essential (12.8ubuntu1.1) ... 244s Selecting previously unselected package libllvm10:arm64. 244s Preparing to unpack .../25-libllvm10_1%3a10.0.0-4ubuntu1_arm64.deb ... 244s Unpacking libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 245s Selecting previously unselected package libclang-cpp10. 245s Preparing to unpack .../26-libclang-cpp10_1%3a10.0.0-4ubuntu1_arm64.deb ... 245s Unpacking libclang-cpp10 (1:10.0.0-4ubuntu1) ... 246s Selecting previously unselected package libgc1c2:arm64. 246s Preparing to unpack .../27-libgc1c2_1%3a7.6.4-0.4ubuntu1_arm64.deb ... 246s Unpacking libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 246s Selecting previously unselected package libobjc4:arm64. 246s Preparing to unpack .../28-libobjc4_10.5.0-1ubuntu1~20.04_arm64.deb ... 246s Unpacking libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 246s Selecting previously unselected package libobjc-9-dev:arm64. 246s Preparing to unpack .../29-libobjc-9-dev_9.4.0-1ubuntu1~20.04.2_arm64.deb ... 246s Unpacking libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 246s Selecting previously unselected package libclang-common-10-dev. 246s Preparing to unpack .../30-libclang-common-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 246s Unpacking libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 246s Selecting previously unselected package libclang1-10. 246s Preparing to unpack .../31-libclang1-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 246s Unpacking libclang1-10 (1:10.0.0-4ubuntu1) ... 247s Selecting previously unselected package clang-10. 247s Preparing to unpack .../32-clang-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 247s Unpacking clang-10 (1:10.0.0-4ubuntu1) ... 247s Selecting previously unselected package emacsen-common. 247s Preparing to unpack .../33-emacsen-common_3.0.4_all.deb ... 247s Unpacking emacsen-common (3.0.4) ... 247s Selecting previously unselected package dictionaries-common. 247s Preparing to unpack .../34-dictionaries-common_1.28.1_all.deb ... 247s Adding 'diversion of /usr/share/dict/words to /usr/share/dict/words.pre-dictionaries-common by dictionaries-common' 247s Unpacking dictionaries-common (1.28.1) ... 247s Selecting previously unselected package libfakeroot:arm64. 247s Preparing to unpack .../35-libfakeroot_1.24-1_arm64.deb ... 247s Unpacking libfakeroot:arm64 (1.24-1) ... 247s Selecting previously unselected package fakeroot. 247s Preparing to unpack .../36-fakeroot_1.24-1_arm64.deb ... 247s Unpacking fakeroot (1.24-1) ... 247s Selecting previously unselected package hunspell-en-us. 247s Preparing to unpack .../37-hunspell-en-us_1%3a2018.04.16-1_all.deb ... 247s Unpacking hunspell-en-us (1:2018.04.16-1) ... 247s Selecting previously unselected package libpgtypes3:arm64. 247s Preparing to unpack .../38-libpgtypes3_12.22-0ubuntu0.20.04.3_arm64.deb ... 247s Unpacking libpgtypes3:arm64 (12.22-0ubuntu0.20.04.3) ... 247s Selecting previously unselected package libpq5:arm64. 247s Preparing to unpack .../39-libpq5_12.22-0ubuntu0.20.04.3_arm64.deb ... 247s Unpacking libpq5:arm64 (12.22-0ubuntu0.20.04.3) ... 247s Selecting previously unselected package libecpg6:arm64. 247s Preparing to unpack .../40-libecpg6_12.22-0ubuntu0.20.04.3_arm64.deb ... 247s Unpacking libecpg6:arm64 (12.22-0ubuntu0.20.04.3) ... 247s Selecting previously unselected package libecpg-compat3:arm64. 247s Preparing to unpack .../41-libecpg-compat3_12.22-0ubuntu0.20.04.3_arm64.deb ... 247s Unpacking libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.3) ... 248s Selecting previously unselected package libpq-dev. 248s Preparing to unpack .../42-libpq-dev_12.22-0ubuntu0.20.04.3_arm64.deb ... 248s Unpacking libpq-dev (12.22-0ubuntu0.20.04.3) ... 248s Selecting previously unselected package libecpg-dev. 248s Preparing to unpack .../43-libecpg-dev_12.22-0ubuntu0.20.04.3_arm64.deb ... 248s Unpacking libecpg-dev (12.22-0ubuntu0.20.04.3) ... 248s Selecting previously unselected package libncurses-dev:arm64. 248s Preparing to unpack .../44-libncurses-dev_6.2-0ubuntu2.1_arm64.deb ... 248s Unpacking libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 248s Selecting previously unselected package libpython3.8:arm64. 248s Preparing to unpack .../45-libpython3.8_3.8.10-0ubuntu1~20.04.18_arm64.deb ... 248s Unpacking libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.18) ... 248s Selecting previously unselected package libtcl8.6:arm64. 248s Preparing to unpack .../46-libtcl8.6_8.6.10+dfsg-1_arm64.deb ... 248s Unpacking libtcl8.6:arm64 (8.6.10+dfsg-1) ... 248s Selecting previously unselected package libtinfo-dev:arm64. 248s Preparing to unpack .../47-libtinfo-dev_6.2-0ubuntu2.1_arm64.deb ... 248s Unpacking libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 248s Selecting previously unselected package libxslt1.1:arm64. 248s Preparing to unpack .../48-libxslt1.1_1.1.34-4ubuntu0.20.04.3_arm64.deb ... 248s Unpacking libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.3) ... 248s Selecting previously unselected package llvm-10-runtime. 248s Preparing to unpack .../49-llvm-10-runtime_1%3a10.0.0-4ubuntu1_arm64.deb ... 248s Unpacking llvm-10-runtime (1:10.0.0-4ubuntu1) ... 248s Selecting previously unselected package libpfm4:arm64. 248s Preparing to unpack .../50-libpfm4_4.10.1+git20-g7700f49-2_arm64.deb ... 248s Unpacking libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 248s Selecting previously unselected package llvm-10. 248s Preparing to unpack .../51-llvm-10_1%3a10.0.0-4ubuntu1_arm64.deb ... 248s Unpacking llvm-10 (1:10.0.0-4ubuntu1) ... 249s Selecting previously unselected package libffi-dev:arm64. 249s Preparing to unpack .../52-libffi-dev_3.3-4_arm64.deb ... 249s Unpacking libffi-dev:arm64 (3.3-4) ... 249s Selecting previously unselected package python3-pygments. 249s Preparing to unpack .../53-python3-pygments_2.3.1+dfsg-1ubuntu2.2_all.deb ... 249s Unpacking python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 249s Selecting previously unselected package llvm-10-tools. 249s Preparing to unpack .../54-llvm-10-tools_1%3a10.0.0-4ubuntu1_arm64.deb ... 249s Unpacking llvm-10-tools (1:10.0.0-4ubuntu1) ... 249s Selecting previously unselected package libz3-4:arm64. 249s Preparing to unpack .../55-libz3-4_4.8.7-4build1_arm64.deb ... 249s Unpacking libz3-4:arm64 (4.8.7-4build1) ... 249s Selecting previously unselected package libz3-dev:arm64. 249s Preparing to unpack .../56-libz3-dev_4.8.7-4build1_arm64.deb ... 249s Unpacking libz3-dev:arm64 (4.8.7-4build1) ... 249s Selecting previously unselected package llvm-10-dev. 249s Preparing to unpack .../57-llvm-10-dev_1%3a10.0.0-4ubuntu1_arm64.deb ... 249s Unpacking llvm-10-dev (1:10.0.0-4ubuntu1) ... 252s Selecting previously unselected package net-tools. 252s Preparing to unpack .../58-net-tools_1.60+git20180626.aebd88e-1ubuntu1_arm64.deb ... 252s Unpacking net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 252s Selecting previously unselected package postgresql-client-common. 252s Preparing to unpack .../59-postgresql-client-common_214ubuntu0.1_all.deb ... 252s Unpacking postgresql-client-common (214ubuntu0.1) ... 252s Selecting previously unselected package postgresql-client-12. 252s Preparing to unpack .../60-postgresql-client-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 252s Unpacking postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 252s Selecting previously unselected package ssl-cert. 252s Preparing to unpack .../61-ssl-cert_1.0.39_all.deb ... 252s Unpacking ssl-cert (1.0.39) ... 252s Selecting previously unselected package postgresql-common. 252s Preparing to unpack .../62-postgresql-common_214ubuntu0.1_all.deb ... 252s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 252s Unpacking postgresql-common (214ubuntu0.1) ... 252s Selecting previously unselected package postgresql-12. 252s Preparing to unpack .../63-postgresql-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 252s Unpacking postgresql-12 (12.22-0ubuntu0.20.04.3) ... 253s Selecting previously unselected package postgresql-server-dev-12. 253s Preparing to unpack .../64-postgresql-server-dev-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 253s Unpacking postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 253s Selecting previously unselected package postgresql-server-dev-all. 253s Preparing to unpack .../65-postgresql-server-dev-all_214ubuntu0.1_all.deb ... 253s Unpacking postgresql-server-dev-all (214ubuntu0.1) ... 253s Selecting previously unselected package postgresql-plperl-12. 253s Preparing to unpack .../66-postgresql-plperl-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 253s Unpacking postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 253s Selecting previously unselected package postgresql-plpython3-12. 253s Preparing to unpack .../67-postgresql-plpython3-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 253s Unpacking postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 253s Selecting previously unselected package postgresql-pltcl-12. 253s Preparing to unpack .../68-postgresql-pltcl-12_12.22-0ubuntu0.20.04.3_arm64.deb ... 253s Unpacking postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 253s Selecting previously unselected package postgresql-all. 253s Preparing to unpack .../69-postgresql-all_12+214ubuntu0.1_all.deb ... 253s Unpacking postgresql-all (12+214ubuntu0.1) ... 253s Setting up postgresql-client-common (214ubuntu0.1) ... 253s Setting up libpgtypes3:arm64 (12.22-0ubuntu0.20.04.3) ... 253s Setting up net-tools (1.60+git20180626.aebd88e-1ubuntu1) ... 253s Setting up libgc1c2:arm64 (1:7.6.4-0.4ubuntu1) ... 253s Setting up libpq5:arm64 (12.22-0ubuntu0.20.04.3) ... 253s Setting up linux-libc-dev:arm64 (5.4.0-211.231) ... 253s Setting up libpq-dev (12.22-0ubuntu0.20.04.3) ... 253s Setting up libobjc4:arm64 (10.5.0-1ubuntu1~20.04) ... 253s Setting up libgomp1:arm64 (10.5.0-1ubuntu1~20.04) ... 253s Setting up libffi-dev:arm64 (3.3-4) ... 253s Setting up libfakeroot:arm64 (1.24-1) ... 253s Setting up libllvm10:arm64 (1:10.0.0-4ubuntu1) ... 253s Setting up fakeroot (1.24-1) ... 253s update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode 253s Setting up python3-pygments (2.3.1+dfsg-1ubuntu2.2) ... 254s Setting up libz3-4:arm64 (4.8.7-4build1) ... 254s Setting up postgresql-client-12 (12.22-0ubuntu0.20.04.3) ... 255s update-alternatives: using /usr/share/postgresql/12/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 255s Setting up libpfm4:arm64 (4.10.1+git20-g7700f49-2) ... 255s Setting up emacsen-common (3.0.4) ... 255s Setting up ssl-cert (1.0.39) ... 256s Setting up libclang1-10 (1:10.0.0-4ubuntu1) ... 256s Setting up libpython3.8:arm64 (3.8.10-0ubuntu1~20.04.18) ... 256s Setting up postgresql-common (214ubuntu0.1) ... 256s ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. 256s Adding user postgres to group ssl-cert 256s 256s Creating config file /etc/postgresql-common/createcluster.conf with new version 257s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 257s en_us 257s Removing obsolete dictionary files: 257s Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. 258s Setting up libmpc3:arm64 (1.1.0-1) ... 258s Setting up libatomic1:arm64 (10.5.0-1ubuntu1~20.04) ... 258s Setting up libtcl8.6:arm64 (8.6.10+dfsg-1) ... 258s Setting up binfmt-support (2.2.0-2) ... 258s Created symlink /etc/systemd/system/multi-user.target.wants/binfmt-support.service → /lib/systemd/system/binfmt-support.service. 259s Setting up libubsan1:arm64 (10.5.0-1ubuntu1~20.04) ... 259s Setting up libcrypt-dev:arm64 (1:4.4.10-10ubuntu4) ... 259s Setting up libxslt1.1:arm64 (1.1.34-4ubuntu0.20.04.3) ... 259s Setting up libecpg6:arm64 (12.22-0ubuntu0.20.04.3) ... 259s Setting up libisl22:arm64 (0.22.1-1) ... 259s Setting up postgresql-12 (12.22-0ubuntu0.20.04.3) ... 259s Creating new PostgreSQL cluster 12/main ... 259s /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main --auth-local peer --auth-host md5 259s The files belonging to this database system will be owned by user "postgres". 259s This user must also own the server process. 259s 259s The database cluster will be initialized with locale "C.UTF-8". 259s The default database encoding has accordingly been set to "UTF8". 259s The default text search configuration will be set to "english". 259s 259s Data page checksums are disabled. 259s 259s fixing permissions on existing directory /var/lib/postgresql/12/main ... ok 259s creating subdirectories ... ok 259s selecting dynamic shared memory implementation ... posix 259s selecting default max_connections ... 100 259s selecting default shared_buffers ... 128MB 259s selecting default time zone ... Etc/UTC 259s creating configuration files ... ok 259s running bootstrap script ... ok 260s performing post-bootstrap initialization ... ok 260s syncing data to disk ... ok 260s 260s Success. You can now start the database server using: 260s 260s pg_ctlcluster 12 main start 260s 260s Ver Cluster Port Status Owner Data directory Log file 260s 12 main 5432 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 261s update-alternatives: using /usr/share/postgresql/12/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode 263s Setting up libc-dev-bin (2.31-0ubuntu9.17) ... 266s Setting up libcc1-0:arm64 (10.5.0-1ubuntu1~20.04) ... 266s Setting up liblsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 266s Setting up libitm1:arm64 (10.5.0-1ubuntu1~20.04) ... 266s Setting up gcc-9-base:arm64 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up libtsan0:arm64 (10.5.0-1ubuntu1~20.04) ... 266s Setting up postgresql-plpython3-12 (12.22-0ubuntu0.20.04.3) ... 266s Setting up libz3-dev:arm64 (4.8.7-4build1) ... 266s Setting up llvm-10-tools (1:10.0.0-4ubuntu1) ... 266s Setting up libecpg-compat3:arm64 (12.22-0ubuntu0.20.04.3) ... 266s Setting up dictionaries-common (1.28.1) ... 266s Setting up libclang-common-10-dev (1:10.0.0-4ubuntu1) ... 266s Setting up postgresql-pltcl-12 (12.22-0ubuntu0.20.04.3) ... 266s Setting up libclang-cpp10 (1:10.0.0-4ubuntu1) ... 266s Setting up libecpg-dev (12.22-0ubuntu0.20.04.3) ... 266s Setting up llvm-10-runtime (1:10.0.0-4ubuntu1) ... 266s Setting up libasan5:arm64 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up postgresql-plperl-12 (12.22-0ubuntu0.20.04.3) ... 266s Setting up hunspell-en-us (1:2018.04.16-1) ... 266s Setting up cpp-9 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up libc6-dev:arm64 (2.31-0ubuntu9.17) ... 266s Setting up libncurses-dev:arm64 (6.2-0ubuntu2.1) ... 266s Setting up llvm-10 (1:10.0.0-4ubuntu1) ... 266s Setting up libgcc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up llvm-10-dev (1:10.0.0-4ubuntu1) ... 266s Setting up libobjc-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up cpp (4:9.3.0-1ubuntu2) ... 266s Setting up libtinfo-dev:arm64 (6.2-0ubuntu2.1) ... 266s Setting up gcc-9 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up libstdc++-9-dev:arm64 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up gcc (4:9.3.0-1ubuntu2) ... 266s Setting up g++-9 (9.4.0-1ubuntu1~20.04.2) ... 266s Setting up g++ (4:9.3.0-1ubuntu2) ... 266s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 266s Setting up build-essential (12.8ubuntu1.1) ... 266s Setting up clang-10 (1:10.0.0-4ubuntu1) ... 266s Setting up postgresql-server-dev-12 (12.22-0ubuntu0.20.04.3) ... 266s Setting up postgresql-server-dev-all (214ubuntu0.1) ... 266s Setting up postgresql-all (12+214ubuntu0.1) ... 266s Processing triggers for install-info (6.7.0.dfsg.2-5) ... 266s Processing triggers for libc-bin (2.31-0ubuntu9.17) ... 266s Processing triggers for systemd (245.4-4ubuntu3.24) ... 266s Processing triggers for man-db (2.9.1-1) ... 267s Processing triggers for dictionaries-common (1.28.1) ... 269s autopkgtest [04:09:20]: test run-testsuite: [----------------------- 270s Generating locales (this might take a while)... 272s en_US.UTF-8... done 272s ru_RU.ISO-8859-5... done 274s ru_RU.UTF-8... done 274s Generation complete. 274s ====== Running all tests with umask 077 ======= 274s === Running test 001_packages.t ... === 275s 1..18 275s # PostgreSQL versions installed: 12 275s ok 1 - postgresql-12 installed 275s ok 2 # skip No python2 support 275s ok 3 - postgresql-plpython3-12 installed 275s ok 4 - postgresql-plperl-12 installed 275s ok 5 - postgresql-pltcl-12 installed 275s ok 6 - postgresql-server-dev-12 installed 275s ok 7 # skip No postgresql-contrib-12 package for version 12 275s ok 8 - libecpg-dev installed 275s ok 9 - procps installed 275s ok 10 - netcat-openbsd installed 275s ok 11 - hunspell-en-us installed 275s ok 12 - system has a default UTF-8 locale 275s ok 13 - locale ru_RU exists 275s ok 14 - locale ru_RU.UTF-8 exists 275s ok 15 - user postgres in the UNIX group ssl-cert 275s ok 16 - /etc/ssl/private/ssl-cert-snakeoil.key exists 275s ok 17 - /etc/ssl/private/ssl-cert-snakeoil.key is readable for postgres 275s ok 18 - /etc/ssl/certs/ssl-cert-snakeoil.pem exists 275s === Running test 002_existing_clusters.t ... === 275s 1..8 275s ok 1 - Cleanup: No clusters left behind 275s ok 2 - No postgres processes left behind 275s ok 3 - No files in /etc/postgresql left behind 275s ok 4 - No files in /var/lib/postgresql left behind 275s ok 5 - No files in /var/run/postgresql left behind 275s ok 6 - No files in /var/log/postgresql left behind 275s ok 7 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 275s ok 8 - PostgreSQL TCP ports are closed 275s === Running test 003_package_checks.t ... === 275s 1..4 275s ok 1 - ldd /usr/lib/postgresql/12/bin/psql 275s ok 2 - psql is linked against libedit 275s ok 3 - ldd /usr/lib/postgresql/12/bin/psql 275s ok 4 - psql is not linked against libreadline 275s === Running test 005_PgCommon.t ... === 275s 1..24 275s ok 1 - correctly parsed line 'local all postgres ident sameuser' 275s ok 2 - correctly parsed line 'local foo nobody trust' 275s ok 3 - correctly parsed line 'local foo nobody crypt' 275s ok 4 - correctly parsed line 'local foo nobody,joe krb5' 275s ok 5 - correctly parsed line 'local foo,bar nobody ident' 275s ok 6 - correctly parsed line 'local all +foogrp password' 275s ok 7 - correctly parsed line 'host @inc all 127.0.0.1/32 md5' 275s ok 8 - correctly parsed line 'hostssl all @inc 192.168.0.0 255.255.0.0 pam' 275s ok 9 - correctly parsed line 'hostnossl all all 192.168.0.0 255.255.0.0 reject' 275s ok 10 - @expected_records has correct number of entries 275s ok 11 - returned read_pg_hba array has correct number of records 275s ok 12 - line 'foo all all md5' parsed as invalid 275s ok 13 - line 'local all all foo' parsed as invalid 275s ok 14 - line 'host all all foo' parsed as invalid 275s ok 15 - line 'host all all 127.0.0.1/32 foo' parsed as invalid 275s ok 16 - line 'host all all md5' parsed as invalid 275s ok 17 - line 'host all all 127.0.0.1/32 0.0.0.0 md5' parsed as invalid 275s ok 18 - line 'host all all 127.0.0.1 md5' parsed as invalid 275s ok 19 - read_conf_file returns empty dict for nonexisting file 275s ok 20 - read_conf_file() parsing 275s ok 21 - read_conf_file() parsing with include directives 275s ok 22 - set_conf_value 275s ok 23 - disable_conf_value 275s ok 24 - replace_conf_value 275s === Running test 006_next_free_port.t ... === 275s 1..5 275s ok 1 - next_free_port is 5432 276s ok 2 - next_free_port detects localhost ipv4 socket 276s ok 3 - next_free_port detects wildcard ipv4 socket 277s ok 4 - next_free_port detects localhost ipv6 socket 277s ok 5 - next_free_port detects wildcard ipv6 socket 277s === Running test 007_pg_conftool.t ... === 278s 1..41 278s # test without cluster 278s ok 1 - pg_conftool show all 278s ok 2 - correct output of pg_conftool show all 278s ok 3 - pg_conftool foo.conf show all 278s ok 4 - correct output of pg_conftool foo.conf show all 278s ok 5 - pg_conftool /tmp/v0Upb2K_p2/different.conf show all 278s ok 6 - correct output of pg_conftool /tmp/v0Upb2K_p2/different.conf show all 278s ok 7 - pg_conftool 9.7 main show all 278s ok 8 - correct output of pg_conftool 9.7 main show all 278s # test show 278s ok 9 - pg_conftool show all 278s ok 10 - correct output of pg_conftool show all 278s ok 11 - pg_conftool other.conf show all 278s ok 12 - correct output of pg_conftool other.conf show all 278s ok 13 - pg_conftool /tmp/v0Upb2K_p2/different.conf show all 278s ok 14 - correct output of pg_conftool /tmp/v0Upb2K_p2/different.conf show all 278s ok 15 - pg_conftool 12 main show all 278s ok 16 - correct output of pg_conftool 12 main show all 278s ok 17 - pg_conftool 12 main other.conf show all 278s ok 18 - correct output of pg_conftool 12 main other.conf show all 278s ok 19 - pg_conftool show a 278s ok 20 - correct output of pg_conftool show a 278s ok 21 - pg_conftool -s show a 278s ok 22 - correct output of pg_conftool -s show a 278s # test set 278s ok 23 - pg_conftool set c 7 278s ok 24 - correct output of pg_conftool set c 7 278s ok 25 - file contains new setting 278s ok 26 - pg_conftool set a 8 278s ok 27 - correct output of pg_conftool set a 8 278s ok 28 - file contains updated setting 278s ok 29 - pg_conftool /tmp/v0Upb2K_p2/different.conf set a 9 278s ok 30 - correct output of pg_conftool /tmp/v0Upb2K_p2/different.conf set a 9 278s ok 31 - file with path contains updated setting 278s # test remove 278s ok 32 - pg_conftool remove a 278s ok 33 - correct output of pg_conftool remove a 278s ok 34 - setting removed from file 278s ok 35 - pg_conftool /tmp/v0Upb2K_p2/different.conf remove a 278s ok 36 - correct output of pg_conftool /tmp/v0Upb2K_p2/different.conf remove a 278s ok 37 - setting removed from file with path 278s # test edit 278s ok 38 - pg_conftool edit 278s ok 39 - correct output of pg_conftool edit 278s ok 40 - pg_conftool /tmp/v0Upb2K_p2/different.conf edit 278s ok 41 - correct output of pg_conftool /tmp/v0Upb2K_p2/different.conf edit 278s === Running test 010_defaultport_cluster.t ... === 278s 1..14 278s ok 1 - psql --version 278s ok 2 - pg_wrapper selects highest available version number 278s ok 3 - env LC_MESSAGES=C psql -h 127.0.0.1 -l 278s ok 4 - connecting to localhost fails with no clusters 278s ok 5 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -l 278s ok 6 - pg_wrapper uses host and port from PGCLUSTER 278s ok 7 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --cluster 12/127.0.0.3:5430 -l 278s ok 8 - pg_wrapper uses --cluster from the command line 278s ok 9 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql -h 127.0.0.3 -l 278s ok 10 - pg_wrapper ignores PGCLUSTER with -h on the command line 278s ok 11 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 psql --host 127.0.0.3 -l 278s ok 12 - pg_wrapper ignores PGCLUSTER with --host on the command line 278s ok 13 - env LC_MESSAGES=C PGCLUSTER=12/127.0.0.2:5431 PGHOST=127.0.0.3 psql -l 278s ok 14 - pg_wrapper ignores PGCLUSTER if PGHOST is set 278s === Running test 015_start_stop.t ... === 279s 1..71 279s # We are running systemd 279s # Running tests for 12 279s # Cluster does not exist yet 279s ok 1 - cluster 12 main does not exist 279s ok 2 - service postgresql@12-main does not exist 279s ok 3 - systemctl start postgresql 279s ok 4 - cluster 12 main does not exist 279s ok 5 - service postgresql@12-main does not exist 279s ok 6 - systemctl start postgresql@12-main 279s ok 7 - cluster 12 main does not exist 279s ok 8 - service postgresql@12-main does not exist 279s # Start/stop postgresql using system tools 280s ok 9 - pg_createcluster 12 main 280s ok 10 - cluster 12 main is stopped 280s ok 11 - service postgresql@12-main is stopped 282s ok 12 - systemctl start postgresql 282s ok 13 - cluster 12 main is running 282s ok 14 - service postgresql@12-main is running 282s ok 15 - systemctl start postgresql 282s ok 16 - cluster 12 main is already running 282s ok 17 - service postgresql@12-main is already running 282s ok 18 - systemctl stop postgresql 288s ok 19 - cluster 12 main is stopped 288s ok 20 - service postgresql@12-main is stopped 288s ok 21 - systemctl stop postgresql 288s ok 22 - cluster 12 main is already stopped 288s ok 23 - service postgresql@12-main is already stopped 288s # Start/stop specific cluster using system tools 290s ok 24 - systemctl start postgresql@12-main 290s ok 25 - cluster 12 main is running 290s ok 26 - service postgresql@12-main is running 290s ok 27 - systemctl start postgresql@12-main 290s ok 28 - cluster 12 main is running 290s ok 29 - service postgresql@12-main is running 293s ok 30 - systemctl restart postgresql@12-main 293s ok 31 - cluster 12 main is running 293s ok 32 - service postgresql@12-main is running 293s ok 33 - systemctl stop postgresql@12-main 293s ok 34 - cluster 12 main is stopped 293s ok 35 - service postgresql@12-main is stopped 293s ok 36 - systemctl stop postgresql@12-main 293s ok 37 - cluster 12 main is already stopped 293s ok 38 - service postgresql@12-main is already stopped 293s ok 39 - pg_dropcluster 12 main 293s ok 40 - cluster 12 main does not exist 293s ok 41 - service postgresql@12-main does not exist 293s # Start/stop specific cluster using pg_*cluster 293s ok 42 - pg_ctlcluster start 12 main 293s ok 43 - cluster 12 main does not exist 293s ok 44 - service postgresql@12-main does not exist 296s ok 45 - pg_createcluster 12 main --start 296s ok 46 - cluster 12 main is running 296s ok 47 - service postgresql@12-main is running 296s ok 48 - pg_ctlcluster 12 main start 296s ok 49 - cluster 12 main is already running 296s ok 50 - service postgresql@12-main is already running 299s ok 51 - pg_ctlcluster 12-main restart 301s ok 52 - cluster 12 main is running 301s ok 53 - service postgresql@12-main is running 301s ok 54 - pg_ctlcluster 12 main stop 301s ok 55 - cluster 12 main is stopped 301s ok 56 - service postgresql@12-main is stopped 301s ok 57 - pg_ctlcluster 12 main stop 301s ok 58 - cluster 12 main is already stopped 301s ok 59 - service postgresql@12-main is already stopped 301s ok 60 - pg_ctlcluster start 12-main 302s ok 61 - cluster 12 main is running 302s ok 62 - service postgresql@12-main is running 302s ok 63 - pg_dropcluster 12 main --stop 302s ok 64 - Cleanup: No clusters left behind 302s ok 65 - No postgres processes left behind 302s ok 66 - No files in /etc/postgresql left behind 302s ok 67 - No files in /var/lib/postgresql left behind 302s ok 68 - No files in /var/run/postgresql left behind 302s ok 69 - No files in /var/log/postgresql left behind 302s ok 70 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 302s ok 71 - PostgreSQL TCP ports are closed 302s === Running test 020_create_sql_remove.t ... === 302s 1..144 302s # Running tests for 12 305s ok 1 - pg_createcluster 12 main --start -- -X /tmp/12.xlog.7HjVJ1 305s ok 2 - pg_createcluster 12 main 305s ok 3 - Socket and pid file are in /var/run/postgresql/ 305s ok 4 - xlog/wal directory /tmp/12.xlog.7HjVJ1 was created 305s ok 5 - Exactly one postgres master process running 307s ok 6 - pg_ctlcluster 12 main restart 307s ok 7 - cluster restarts with new environment file 307s ok 8 - Exactly one postgres master process running 307s ok 9 - correct value of PGEXTRAVAR1 in environment 307s ok 10 - correct value of PGEXTRAVAR2 in environment 307s ok 11 - Socket and stats dir, but not PID file in /var/run/postgresql/ 307s ok 12 - createdb --version 307s ok 13 - pg_wrapper selects version number of cluster 307s ok 14 - psql --version 307s ok 15 - pg_wrapper selects version number of cluster 307s ok 16 - pg_lscluster reports online cluster on port 5432 307s ok 17 - log file is actually used 307s ok 18 - /etc/postgresql is owned by user "postgres" 307s ok 19 - version configuration directory file is owned by user "postgres" 307s ok 20 - configuration directory file is owned by user "postgres" 307s ok 21 - version data directory file is owned by user "postgres" 307s ok 22 - data directory file is owned by user "postgres" 307s ok 23 - log file has 0640 permissions 307s ok 24 - log file is owned by user "postgres" 307s ok 25 - log file is owned by group "adm" 307s ok 26 - no log symlink by default 307s ok 27 - /var/log/postgresql/postgresql-12-main.log is the default log if log symlink is missing 308s ok 28 - pg_lsclusters -h 308s ok 29 - correct output of pg_lsclusters -h 308s ok 30 - stopping cluster 310s ok 31 - restarting cluster with nondefault log symlink 310s ok 32 - log target is used as log file 310s ok 33 - default log is not used 310s ok 34 - pg_lsclusters -h 310s ok 35 - correct output of pg_lsclusters -h 310s ok 36 - stopping cluster 312s ok 37 - restarting cluster with explicitly configured log file 312s ok 38 - default log is not used 312s ok 39 - log symlink target is used for startup message 312s ok 40 - exactly one log file 312s ok 41 - custom log is actually used 312s ok 42 - pg_lsclusters -h 312s ok 43 - correct output of pg_lsclusters -h 312s ok 44 - stopping cluster 312s ok 45 - starting cluster with rouge /var/log/postgresql symlink fails 312s ok 46 - /etc/postgres-hack was not created 315s ok 47 - restarting cluster 315s ok 48 - ps -o tty -U postgres h 315s ok 49 - postgres processes do not have an associated terminal 315s ok 50 - SSL is enabled 315s ok 51 - psql -l fails for nobody 315s ok 52 - createuser nobody 315s ok 53 - createdb nobodydb 315s ok 54 - psql -ltA succeeds for nobody 315s ok 55 - psql -ltA output 315s ok 56 - SQL command: create table 315s ok 57 - SQL command: insert into table values 315s ok 58 - SQL command: insert into table values 315s ok 59 - primary key violation 315s ok 60 - psql -tAc "select * from phone order by name" nobodydb 315s ok 61 - SQL command output: select -tA 315s ok 62 - psql -txc "select * from phone where name = 'Alice'" nobodydb 315s ok 63 - SQL command output: select -tx 315s ok 64 - psql -tAxc "select * from phone where name = 'Alice'" nobodydb 315s ok 65 - SQL command output: select -tAx 315s ok 66 - CREATE EXTENSION plperlu fails for user nobody 315s ok 67 - psql -qc 'CREATE EXTENSION plperlu' nobodydb 315s ok 68 - CREATE EXTENSION plperlu succeeds for user postgres 315s ok 69 - creating PL/PerlU function as user nobody fails 315s ok 70 - creating unsafe PL/Perl function as user postgres fails 316s ok 71 - psql nobodydb -qc "CREATE FUNCTION read_file() RETURNS text AS 'open F, \"/etc/passwd\"; \$buf = ; close F; return \$buf;' LANGUAGE plperlu;" 316s ok 72 - creating PL/PerlU function as user postgres succeeds 316s ok 73 - psql nobodydb -Atc "select read_file()" 316s ok 74 - calling PL/PerlU function 316s ok 75 - psql -qc 'CREATE EXTENSION plperl' nobodydb 316s ok 76 - CREATE EXTENSION plperl succeeds for user nobody 316s ok 77 - creating unsafe PL/Perl function as user nobody fails 316s ok 78 - psql nobodydb -qc "CREATE FUNCTION remove_vowels(text) RETURNS text AS '\$_[0] =~ s/[aeiou]/_/ig; return \$_[0];' LANGUAGE plperl;" 316s ok 79 - creating PL/Perl function as user nobody succeeds 316s ok 80 - psql nobodydb -Atc "select remove_vowels('foobArish')" 316s ok 81 - calling PL/Perl function 316s ok 82 # skip No python2 support 316s ok 83 # skip No python2 support 316s ok 84 # skip No python2 support 316s ok 85 # skip No python2 support 316s ok 86 # skip No python2 support 316s ok 87 # skip No python2 support 316s ok 88 - psql -qc 'CREATE EXTENSION plpython3u' nobodydb 316s ok 89 - CREATE EXTENSION plpython3u succeeds for user postgres 316s ok 90 - psql nobodydb -qc "CREATE FUNCTION capitalize3(text) RETURNS text AS 'import sys; return args[0].capitalize() + sys.version[0]' LANGUAGE plpython3u;" 316s ok 91 - creating PL/Python3 function as user postgres succeeds 316s ok 92 - psql nobodydb -Atc "select capitalize3('foo')" 316s ok 93 - calling PL/Python function 316s ok 94 - psql -qc 'CREATE EXTENSION pltcl' nobodydb 316s ok 95 - CREATE EXTENSION pltcl succeeds for user postgres 316s ok 96 - psql -qc 'CREATE EXTENSION pltclu' nobodydb 316s ok 97 - CREATE EXTENSION pltclu succeeds for user postgres 316s ok 98 - psql nobodydb -qc "CREATE FUNCTION tcl_max(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltcl STRICT;" 316s ok 99 - creating PL/Tcl function as user nobody succeeds 316s ok 100 - psql nobodydb -qc "CREATE FUNCTION tcl_max_u(integer, integer) RETURNS integer AS 'if {\$1 > \$2} {return \$1}; return \$2' LANGUAGE pltclu STRICT;" 316s ok 101 - creating PL/TclU function as user postgres succeeds 316s ok 102 - psql nobodydb -Atc "select tcl_max(3,4)" 316s ok 103 - calling PL/Tcl function 316s ok 104 - psql nobodydb -Atc "select tcl_max_u(5,4)" 316s ok 105 - calling PL/TclU function 316s ok 106 - stopping cluster 316s ok 107 - pg_ctlcluster 12 main start 316s ok 108 - cluster fails to start with invalid data_directory and valid pgdata symlink 319s ok 109 - pg_ctlcluster 12 main start 319s ok 110 - cluster restarts with pgdata symlink 319s ok 111 - postgres master has OOM killer protection 319s ok 112 - postgres client backend has no OOM adjustment 319s ok 113 - ps h 7166 319s ok 114 - process title is idle 320s ok 115 - ps h 7166 320s ok 116 - process title is idle in transaction 320s ok 117 - ps h 7166 320s ok 118 - process title is SELECT 322s ok 119 - dropdb nobodydb 322s ok 120 - dropuser nobody 322s ok 121 - stopping cluster 325s ok 122 - starting cluster as postgres works without a log file 325s ok 123 - log file got recreated and used 325s ok 124 - creating a directory in spc2 325s ok 125 - psql -qc "CREATE TABLESPACE spc1 LOCATION '/tmp/12.spc1.frjkgl'" 325s ok 126 - creating tablespace spc1 325s ok 127 - psql -qc 'CREATE TABLE tbl1 (x int) TABLESPACE spc1' 325s ok 128 - creating a table in spc1 325s ok 129 - psql -qc "CREATE TABLESPACE spc2 LOCATION '/tmp/12.spc2.uz2Evf'" 325s ok 130 - creating tablespace spc2 325s ok 131 - psql -qc 'CREATE TABLE tbl2 (x int) TABLESPACE spc2' 325s ok 132 - creating a table in spc2 325s ok 133 - pg_dropcluster removes cluster 325s ok 134 - xlog/wal directory /tmp/12.xlog.7HjVJ1 was deleted 325s ok 135 - tablespace spc1 was emptied 325s ok 136 - tablespace spc2 was emptied 325s ok 137 - Cleanup: No clusters left behind 325s ok 138 - No postgres processes left behind 325s ok 139 - No files in /etc/postgresql left behind 325s ok 140 - No files in /var/lib/postgresql left behind 325s ok 141 - No files in /var/run/postgresql left behind 325s ok 142 - No files in /var/log/postgresql left behind 325s ok 143 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 325s ok 144 - PostgreSQL TCP ports are closed 325s === Running test 021_pg_renamecluster.t ... === 325s 1..20 328s ok 1 - pg_createcluster 12 main 331s ok 2 - pg_renamecluster 12 main donau 331s ok 3 - psql -tAc "show data_directory" 331s ok 4 - cluster is running and data_directory was moved 331s ok 5 - pg_hba.conf location updated 331s ok 6 - pg_ident.conf location updated 331s ok 7 - external_pid_file location updated 331s ok 8 - external_pid_file exists 331s ok 9 - stats_temp_directory location updated 331s ok 10 - stats_temp_directory exists 331s ok 11 - cluster_name is updated 331s ok 12 - pg_dropcluster removes cluster 332s ok 13 - Cleanup: No clusters left behind 332s ok 14 - No postgres processes left behind 332s ok 15 - No files in /etc/postgresql left behind 332s ok 16 - No files in /var/lib/postgresql left behind 332s ok 17 - No files in /var/run/postgresql left behind 332s ok 18 - No files in /var/log/postgresql left behind 332s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 332s ok 20 - PostgreSQL TCP ports are closed 332s === Running test 022_recovery.t ... === 332s 1..17 332s # Running tests for 12 335s ok 1 - pg_createcluster 12 main --start >/dev/null 335s ok 2 - pg_ctlcluster 12 main stop -m i 337s ok 3 - pg_ctlcluster 12 main start 338s ok 4 - psql -c '' 338s ok 5 - pg_ctlcluster 12 main stop -m i 338s ok 6 - create write-protected file in data directory 340s ok 7 - pg_ctlcluster 12 main start 340s ok 8 - psql -c '' 340s ok 9 - pg_dropcluster removes cluster 340s ok 10 - Cleanup: No clusters left behind 340s ok 11 - No postgres processes left behind 340s ok 12 - No files in /etc/postgresql left behind 340s ok 13 - No files in /var/lib/postgresql left behind 340s ok 14 - No files in /var/run/postgresql left behind 340s ok 15 - No files in /var/log/postgresql left behind 340s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 340s ok 17 - PostgreSQL TCP ports are closed 340s === Running test 025_logging.t ... === 340s 1..55 341s # Logging to /var/log/syslog works 341s # Running tests for 12 344s ok 1 - pg_createcluster 12 main 344s ok 2 - pg_lscluster reports logfile /var/log/postgresql/postgresql-12-main.log 344s ok 3 - psql -qc "'foobar_12_7795'" 344s ok 4 - log an error 344s ok 5 - grep --binary-files=text foobar_12_7795 /var/log/postgresql/postgresql-12-main.log 344s ok 6 - error appears in logfile 344s ok 7 - pg_conftool 12 main set log_destination syslog 344s ok 8 - set log_destination syslog 344s ok 9 - pg_ctlcluster 12 main reload 344s ok 10 - 12 main reload 344s ok 11 - psql -Atc "show log_destination" 344s ok 12 - log_destination is syslog 344s ok 13 - pg_lscluster reports syslog 345s ok 14 - grep --binary-files=text 'postgres.*parameter "log_destination" changed to "syslog"' /var/log/syslog 345s ok 15 - error appears in /var/log/syslog 345s ok 16 - pg_conftool 12 main set logging_collector on 345s ok 17 - set logging_collector on 345s ok 18 - pg_conftool 12 main set log_destination csvlog 345s ok 19 - set log_destination csvlog 347s ok 20 - pg_ctlcluster 12 main restart 347s ok 21 - 12 main restart 347s ok 22 - psql -Atc "show logging_collector" 347s ok 23 - logging_collector is on 347s ok 24 - psql -Atc "show log_destination" 347s ok 25 - log_destination is csvlog 347s ok 26 - pg_lscluster reports csvlog 347s ok 27 - psql -qc "'barbaz_12_7795'" 347s ok 28 - log an error 347s ok 29 - grep --binary-files=text barbaz_12_7795 /var/lib/postgresql/12/main/log/*.csv 347s ok 30 - error appears in log/*.csv 347s ok 31 - pg_conftool 12 main set log_destination stderr,syslog,csvlog 347s ok 32 - set log_destination stderr,syslog,csvlog 347s ok 33 - pg_ctlcluster 12 main reload 347s ok 34 - 12 main reload 347s ok 35 - psql -Atc "show log_destination" 347s ok 36 - log_destination is stderr,syslog,csvlog 347s ok 37 - pg_lscluster reports stderr,syslog,csvlog 348s ok 38 - psql -qc "'moo_12_7795'" 348s ok 39 - log an error 348s ok 40 - grep --binary-files=text moo_12_7795 /var/lib/postgresql/12/main/log/*.log 348s ok 41 - error appears in log/*.log 348s ok 42 - grep --binary-files=text 'postgres.*moo_12_7795' /var/log/syslog 348s ok 43 - error appears in /var/log/syslog 348s ok 44 - grep --binary-files=text moo_12_7795 /var/lib/postgresql/12/main/log/*.csv 348s ok 45 - error appears in log/*.csv 348s ok 46 - pg_dropcluster 12 main --stop 348s ok 47 - pg_dropcluster removes cluster 348s ok 48 - Cleanup: No clusters left behind 348s ok 49 - No postgres processes left behind 348s ok 50 - No files in /etc/postgresql left behind 348s ok 51 - No files in /var/lib/postgresql left behind 348s ok 52 - No files in /var/run/postgresql left behind 348s ok 53 - No files in /var/log/postgresql left behind 349s ok 54 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 349s ok 55 - PostgreSQL TCP ports are closed 349s === Running test 030_errors.t ... === 349s 1..149 349s ok 1 - pg_lscluster reports cluster without binaries 349s ok 2 - pg_dropcluster 6.3 main 349s ok 3 - pg_createcluster --socketdir 350s ok 4 - pg_lsclusters -h 350s ok 5 - cluster was created 350s ok 6 - Port of created cluster is 5432 350s ok 7 - pg_createcluster --socketdir '/tmp/postgresql-testsuite/' 12 main 350s ok 8 - pg_createcluster on existing cluster 350s ok 9 - pg_lsclusters -h 350s ok 10 - original cluster still exists 350s ok 11 - pg_createcluster 12 test -p foo 350s ok 12 - pg_createcluster -p checks that port option is numeric 350s ok 13 - pg_createcluster 12 test -p 42 350s ok 14 - pg_createcluster -p checks valid port range 350s ok 15 - pg_ctlcluster fails on invalid cluster owner uid 350s ok 16 - pg_ctlcluster as root fails on invalid cluster owner gid 350s ok 17 - pg_ctlcluster as postgres fails on invalid cluster owner gid 352s ok 18 - pg_ctlcluster succeeds on valid cluster owner uid/gid 352s ok 19 - No sockets in /var/run/postgresql 352s ok 20 - Socket is in /tmp/postgresql-testsuite/ 352s ok 21 - cluster stops with custom unix_socket_dir 352s ok 22 - No sockets in /tmp/postgresql-testsuite/ after stopping cluster 354s ok 23 - cluster starts after removing unix_socket_dir 354s ok 24 - Socket is in default dir /var/run/postgresql 354s ok 25 - No sockets in /tmp/postgresql-testsuite/ 354s ok 26 - pg_ctlcluster 12 main stop 354s ok 27 - pg_ctlcluster fails with corrupted PID file 355s ok 28 - pg_lsclusters -h 355s ok 29 - cluster is still online 355s ok 30 - pg_ctlcluster succeeds with restored PID file 355s ok 31 - pg_lsclusters -h 355s ok 32 - cluster is down 355s ok 33 - pg_ctlcluster 12 main stop 355s ok 34 - pg_ctlcluster stop fails on stopped cluster 357s ok 35 - pg_ctlcluster 12 main start 357s ok 36 - pg_ctlcluster succeeds with already existing PID file 357s ok 37 - pg_lsclusters -h 357s ok 38 - cluster is online 357s ok 39 - pg_ctlcluster stop succeeds 357s ok 40 - pg_lsclusters -h 357s ok 41 - cluster is down 357s ok 42 - no pid file left 357s ok 43 - pg_ctlcluster 12 main stop 357s ok 44 - pg_ctlcluster stop succeeds with corrupted PID file 357s ok 45 - pid file was cleaned up 357s ok 46 - pg_ctlcluster --force 12 main stop 357s ok 47 - pg_ctlcluster --force stop succeeds with corrupted PID file 357s ok 48 - pid file was cleaned up 357s ok 49 - pg_ctlcluster 12 main stop 357s ok 50 - pg_ctlcluster stop succeeds with stale PID file 357s ok 51 - pid file was cleaned up 357s ok 52 - pg_ctlcluster --force 12 main stop 357s ok 53 - pg_ctlcluster --force stop succeeds with stale PID file 357s ok 54 - pid file was cleaned up 357s ok 55 - pg_ctlcluster --force 12 main stop 357s ok 56 - pg_ctlcluster stop succeeds with empty PID file 357s ok 57 - pid file was cleaned up 360s ok 58 - pg_ctlcluster 12 main start 360s ok 59 - pg_ctlcluster succeeds with corrupted PID file 360s ok 60 - pg_lsclusters -h 360s ok 61 - cluster is online 360s ok 62 - pg_ctlcluster 12 main start 360s ok 63 - pg_ctlcluster start fails on running cluster 360s ok 64 - pg_ctlcluster stop 360s ok 65 - pg_ctlcluster 12 main start 360s ok 66 - pg_ctlcluster start fails on invalid pg_hba.conf 360s ok 67 - pg_ctlcluster 12 main stop 360s ok 68 - stopping cluster 366s ok 69 - pg_ctlcluster 12 main start 366s ok 70 - pg_ctlcluster start warns about absence of passwordless superuser connection 367s ok 71 - pg_ctlcluster 12 main stop 367s ok 72 - stopping cluster 367s ok 73 - leftover /etc/postgresql/postgresql.conf is not regarded as a cluster 367s ok 74 - pg_dropcluster 12 main 367s ok 75 - pg_dropcluster works as user postgres 367s ok 76 - pg_createcluster succeeds 367s ok 77 - pg_ctlcluster fails on nonexisting /var/lib/postgresql 367s ok 78 - proper error message for nonexisting /var/lib/postgresql 370s ok 79 - pg_ctlcluster 12 main start 370s ok 80 - pg_ctlcluster start succeeds again with reappeared /var/lib/postgresql 370s ok 81 - pg_ctlcluster 12 main stop 370s ok 82 - stopping cluster 371s ok 83 - pg_createcluster other 373s ok 84 - pg_ctlcluster: main cluster on conflicting port starts 375s ok 85 - pg_ctlcluster: other cluster starts on conflicting port, but different socket dirs 375s ok 86 375s ok 87 - pg_ctlcluster 12 other start 375s ok 88 - pg_ctlcluster other cluster fails on conflicting port and same socket dir 375s ok 89 - pg_ctlcluster 12 main stop 375s ok 90 - stopping main cluster 378s ok 91 - pg_ctlcluster: other cluster on conflicting port starts after main is down 378s ok 92 - pg_dropcluster other 378s ok 93 - pg_dropcluster 378s ok 94 - No sockets any more 378s ok 95 - 'pg_lsclusters 4.5 foo' fails 378s ok 96 - pg_lsclusters 4.5 foo gives error message about nonexisting cluster 378s ok 97 - pg_lsclusters 4.5 foo does not print 'invalid symbolic link' gibberish 378s ok 98 - 'psql --cluster 4.5/foo' fails 378s ok 99 - psql --cluster 4.5/foo gives error message about nonexisting cluster 378s ok 100 - psql --cluster 4.5/foo does not print 'invalid symbolic link' gibberish 378s ok 101 - 'psql --cluster 12/foo' fails 378s ok 102 - psql --cluster 12/foo gives error message about nonexisting cluster 378s ok 103 - psql --cluster 12/foo does not print 'invalid symbolic link' gibberish 378s ok 104 - 'pg_dropcluster 4.5 foo' fails 378s ok 105 - pg_dropcluster 4.5 foo gives error message about nonexisting cluster 378s ok 106 - pg_dropcluster 4.5 foo does not print 'invalid symbolic link' gibberish 378s ok 107 - 'pg_dropcluster 12 foo' fails 378s ok 108 - pg_dropcluster 12 foo gives error message about nonexisting cluster 378s ok 109 - pg_dropcluster 12 foo does not print 'invalid symbolic link' gibberish 378s ok 110 - 'pg_upgradecluster 4.5 foo' fails 378s ok 111 - pg_upgradecluster 4.5 foo gives error message about nonexisting cluster 378s ok 112 - pg_upgradecluster 4.5 foo does not print 'invalid symbolic link' gibberish 378s ok 113 - 'pg_upgradecluster 12 foo' fails 378s ok 114 - pg_upgradecluster 12 foo gives error message about nonexisting cluster 378s ok 115 - pg_upgradecluster 12 foo does not print 'invalid symbolic link' gibberish 378s ok 116 - 'pg_ctlcluster 4.5 foo stop' fails 378s ok 117 - pg_ctlcluster 4.5 foo stop gives error message about nonexisting cluster 378s ok 118 - pg_ctlcluster 4.5 foo stop does not print 'invalid symbolic link' gibberish 378s ok 119 - 'pg_ctlcluster 12 foo stop' fails 378s ok 120 - pg_ctlcluster 12 foo stop gives error message about nonexisting cluster 378s ok 121 - pg_ctlcluster 12 foo stop does not print 'invalid symbolic link' gibberish 379s ok 122 - Cleanup: No clusters left behind 379s ok 123 - No postgres processes left behind 379s ok 124 - No files in /etc/postgresql left behind 379s ok 125 - No files in /var/lib/postgresql left behind 379s ok 126 - No files in /var/run/postgresql left behind 379s ok 127 - No files in /var/log/postgresql left behind 379s ok 128 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 379s ok 129 - PostgreSQL TCP ports are closed 379s ok 130 - pg_dropcluster 12 broken 379s ok 131 - pg_dropcluster cleans up broken cluster configuration (only /etc with pgdata) 379s ok 132 - Cleanup: No clusters left behind 379s ok 133 - No postgres processes left behind 379s ok 134 - No files in /etc/postgresql left behind 379s ok 135 - No files in /var/lib/postgresql left behind 379s ok 136 - No files in /var/run/postgresql left behind 379s ok 137 - No files in /var/log/postgresql left behind 379s ok 138 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 379s ok 139 - PostgreSQL TCP ports are closed 379s ok 140 - pg_dropcluster 12 broken 379s ok 141 - pg_dropcluster cleans up broken cluster configuration (/etc with pgdata and postgresql.conf and partial /var) 379s ok 142 - Cleanup: No clusters left behind 379s ok 143 - No postgres processes left behind 379s ok 144 - No files in /etc/postgresql left behind 379s ok 145 - No files in /var/lib/postgresql left behind 379s ok 146 - No files in /var/run/postgresql left behind 379s ok 147 - No files in /var/log/postgresql left behind 379s ok 148 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 379s ok 149 - PostgreSQL TCP ports are closed 379s === Running test 031_errors_disk_full.t ... === 379s 1..22 379s # check that a failed pg_createcluster leaves no cruft behind: try creating a cluster on a 10 MB tmpfs 379s ok 1 - script failed 379s ok 2 - pg_createcluster fails due to insufficient disk space 379s ok 3 - does not leave files behind 379s ok 4 - Cleanup: No clusters left behind 379s ok 5 - No postgres processes left behind 379s ok 6 - No files in /etc/postgresql left behind 379s ok 7 - No files in /var/lib/postgresql left behind 379s ok 8 - No files in /var/run/postgresql left behind 379s ok 9 - No files in /var/log/postgresql left behind 379s ok 10 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 379s ok 11 - PostgreSQL TCP ports are closed 379s # check disk full conditions on startup 380s ok 12 - script failed 380s ok 13 - pg_ctlcluster prints error message 380s ok 14 - log file has error message 380s ok 15 - Cleanup: No clusters left behind 380s ok 16 - No postgres processes left behind 380s ok 17 - No files in /etc/postgresql left behind 380s ok 18 - No files in /var/lib/postgresql left behind 380s ok 19 - No files in /var/run/postgresql left behind 380s ok 20 - No files in /var/log/postgresql left behind 380s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 380s ok 22 - PostgreSQL TCP ports are closed 380s === Running test 032_ssl_key_permissions.t ... === 381s 1..22 381s ok 1 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 381s ok 2 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 381s ok 3 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 381s # 12 (12.22-0ubuntu0.20.04.3) 381s ok 4 - pg_createcluster 12 main 382s ok 5 - pg_ctlcluster 12 main start 382s ok 6 - ssl key owned by nobody refused 382s ok 7 - pg_ctlcluster 12 main start 382s ok 8 - ssl key with permissions root:root 0644 refused 382s ok 9 - pg_ctlcluster 12 main start 382s ok 10 - ssl key with permissions postgres:postgres 0640 refused 382s ok 11 - pg_dropcluster 12 main --stop 382s ok 12 - /etc/ssl/private/ssl-cert-snakeoil.key is owned by root 382s ok 13 - /etc/ssl/private/ssl-cert-snakeoil.key group is ssl-cert 382s ok 14 - /etc/ssl/private/ssl-cert-snakeoil.key mode is 0640 382s ok 15 - Cleanup: No clusters left behind 382s ok 16 - No postgres processes left behind 382s ok 17 - No files in /etc/postgresql left behind 382s ok 18 - No files in /var/lib/postgresql left behind 382s ok 19 - No files in /var/run/postgresql left behind 382s ok 20 - No files in /var/log/postgresql left behind 382s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 382s ok 22 - PostgreSQL TCP ports are closed 382s === Running test 040_upgrade.t ... === 382s 1..1 382s ok 1 - only one major version installed, skipping upgrade tests 382s === Running test 041_upgrade_custompaths.t ... === 382s 1..1 382s ok 1 - only one major version installed, skipping upgrade tests 382s === Running test 043_upgrade_ssl_cert.t ... === 382s 1..1 382s ok 1 - only one major version installed, skipping upgrade tests 382s === Running test 050_encodings.t ... === 382s 1..60 382s # Checking 12 ru_RU 385s ok 1 - pg_createcluster version 12 for ru_RU without --encoding succeeded 387s ok 2 - psql -l succeeds 387s ok 3 - template1 is not UTF-8 encoded 387s ok 4 - creating test database 387s ok 5 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 387s # create table t (x varchar); copy t from stdin" test 387s ok 6 - creating table with ISO-8859-5 characters 387s ok 7 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 387s ok 8 - correct string in UTF-8 387s ok 9 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 387s ok 10 - correct string in ISO-8859-5 387s ok 11 - printf 'для' | psql -qc "set client_encoding='utf8'; 387s # delete from t; copy t from stdin" test 387s ok 12 - creating table with UTF-8 characters 387s ok 13 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 387s ok 14 - correct string in UTF-8 387s ok 15 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 387s ok 16 - correct string in ISO-8859-1 387s ok 17 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 387s ok 18 - Server error message has correct language and encoding 389s ok 19 - pg_ctlcluster 12 ru_RU restart 389s ok 20 - cluster starts correctly with nonmatching lc_messages and client_encoding 390s ok 21 - Dropping cluster 390s # Checking 12 ru_RU.UTF-8 393s ok 22 - pg_createcluster version 12 for ru_RU.UTF-8 without --encoding succeeded 394s ok 23 - psql -l succeeds 394s ok 24 - template1 is UTF-8 encoded 394s ok 25 - creating test database 394s ok 26 - printf '' | psql -qc "set client_encoding='iso-8859-5'; 394s # create table t (x varchar); copy t from stdin" test 394s ok 27 - creating table with ISO-8859-5 characters 394s ok 28 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 394s ok 29 - correct string in UTF-8 394s ok 30 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 394s ok 31 - correct string in ISO-8859-5 394s ok 32 - printf 'для' | psql -qc "set client_encoding='utf8'; 394s # delete from t; copy t from stdin" test 394s ok 33 - creating table with UTF-8 characters 394s ok 34 - echo "set client_encoding='utf8'; select * from t" | psql -Atq test 394s ok 35 - correct string in UTF-8 394s ok 36 - echo "set client_encoding='iso-8859-5'; select * from t" | psql -Atq test 394s ok 37 - correct string in ISO-8859-1 394s ok 38 - psql test -c "set client_encoding = 'UTF-8'; select sqrt(-1)" 394s ok 39 - Server error message has correct language and encoding 397s ok 40 - pg_ctlcluster 12 ru_RU.UTF8 restart 397s ok 41 - cluster starts correctly with nonmatching lc_messages and client_encoding 397s ok 42 - printf "set client_encoding='UTF-8'; select '\310\\'a'" | psql -Atq template1 397s ok 43 - Server rejects incorrect encoding (CVE-2006-2313) 397s ok 44 - printf "set client_encoding='SJIS'; select '\\\'a'" | psql -Atq template1 397s ok 45 - Server rejects \' escaping in unsafe client encoding (CVE-2006-2314) 397s ok 46 - printf "set client_encoding='UTF-8'; set escape_string_warning='off'; select '\\\'a'" | psql -Atq template1 397s ok 47 - Server rejects obsolete \' escaping in unsafe client encoding (CVE-2006-2314) 397s ok 48 - Dropping cluster 397s # Check 12 locale environment variables 400s ok 49 - pg_createcluster: LC_ALL dominates LANG 400s ok 50 - psql -Atl --cluster 12/main 400s ok 51 - template1 is ASCII encoded 401s ok 52 - Dropping cluster 401s ok 53 - Cleanup: No clusters left behind 401s ok 54 - No postgres processes left behind 401s ok 55 - No files in /etc/postgresql left behind 401s ok 56 - No files in /var/lib/postgresql left behind 401s ok 57 - No files in /var/run/postgresql left behind 401s ok 58 - No files in /var/log/postgresql left behind 401s ok 59 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 401s ok 60 - PostgreSQL TCP ports are closed 401s === Running test 052_upgrade_encodings.t ... === 401s 1..1 401s ok 1 - only one major version installed, skipping upgrade tests 401s === Running test 060_obsolete_confparams.t ... === 401s 1..1 401s ok 1 - only one major version installed, skipping upgrade tests 401s === Running test 070_non_postgres_clusters.t ... === 401s 1..40 402s ok 1 - pg_createcluster 12 main for owner nobody 402s ok 2 - pg_ctlcluster 12 main start 402s ok 3 - start refused when config and data owners mismatch 404s ok 4 - pg_ctlcluster succeeds with owner nobody 404s ok 5 - pg_lsclusters -h 404s ok 6 - pg_lsclusters shows running cluster 404s ok 7 - postgres is running as user nobody 404s ok 8 - ls /tmp/.s.PGSQL.* 404s ok 9 - socket is in /tmp 404s ok 10 - /var/run/postgresql is empty 404s ok 11 - conf dir is owned by user 404s ok 12 - conf dir is owned by user's primary group 404s ok 13 - files are owned by user 404s ok 14 - files are owned by user's primary group 404s ok 15 - log file has 0640 permissions 404s ok 16 - log file is owned by user 404s ok 17 - log file is owned by user's primary group 404s ok 18 - only one major version installed, skipping upgrade test 404s ok 19 - ... 404s ok 20 - ... 404s ok 21 - ... 404s ok 22 - ... 404s ok 23 - ... 404s ok 24 - ... 404s ok 25 - ... 404s ok 26 - ... 404s ok 27 - ... 404s ok 28 - ... 404s ok 29 - pg_dropcluster 405s ok 30 - pg_lsclusters -h 405s ok 31 - No clusters left 405s ok 32 - No postgres processes left 405s ok 33 - Cleanup: No clusters left behind 405s ok 34 - No postgres processes left behind 405s ok 35 - No files in /etc/postgresql left behind 405s ok 36 - No files in /var/lib/postgresql left behind 405s ok 37 - No files in /var/run/postgresql left behind 405s ok 38 - No files in /var/log/postgresql left behind 405s ok 39 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 405s ok 40 - PostgreSQL TCP ports are closed 405s === Running test 080_start.conf.t ... === 405s 1..73 405s ok 1 - pg_createcluster 12 main 405s # start.conf auto 405s ok 2 - get_cluster_start_conf returns auto 405s ok 3 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 405s ok 4 - start.conf contains auto 405s ok 5 - systemd generator links cluster 405s ok 6 - systemd generator links correct service file 408s ok 7 - /etc/init.d/postgresql start 12 408s ok 8 - correct output of /etc/init.d/postgresql start 12 408s ok 9 - pg_lsclusters -h 408s ok 10 - cluster is online 408s ok 11 - /etc/init.d/postgresql stop 12 408s ok 12 - correct output of /etc/init.d/postgresql stop 12 411s ok 13 - pg_lsclusters -h 411s ok 14 - cluster is down 411s # start.conf manual 411s ok 15 - get_cluster_start_conf returns manual 411s ok 16 - grep '^[^\\s\#]' /etc/postgresql/12/main/start.conf 411s ok 17 - start.conf contains manual 411s ok 18 - systemd generator doesn't link cluster 411s ok 19 - /etc/init.d/postgresql start 12 411s ok 20 - correct output of /etc/init.d/postgresql start 12 411s ok 21 - pg_lsclusters -h 411s ok 22 - cluster is down 413s ok 23 - pg_ctlcluster 12 main start 413s ok 24 - correct output of pg_ctlcluster 12 main start 413s ok 25 - pg_lsclusters -h 413s ok 26 - cluster is online 413s ok 27 - pg_ctlcluster 12 main stop 413s ok 28 - correct output of pg_ctlcluster 12 main stop 413s ok 29 - pg_lsclusters -h 413s ok 30 - cluster is down 413s # start.conf disabled 413s ok 31 - get_cluster_start_conf returns disabled 414s ok 32 - systemd generator doesn't link cluster 414s ok 33 - /etc/init.d/postgresql start 12 414s ok 34 - correct output of /etc/init.d/postgresql start 12 414s ok 35 - pg_lsclusters -h 414s ok 36 - cluster is down 414s ok 37 - pg_ctlcluster 12 main start 414s ok 38 - correct output of pg_ctlcluster 12 main start 414s ok 39 - pg_lsclusters -h 414s ok 40 - cluster is down 416s ok 41 - pg_ctlcluster 12 main start 416s ok 42 - correct output of pg_ctlcluster 12 main start 416s ok 43 - pg_lsclusters -h 416s ok 44 - cluster is online 416s ok 45 - pg_ctlcluster 12 main stop 416s ok 46 - correct output of pg_ctlcluster 12 main stop 416s ok 47 - pg_lsclusters -h 416s ok 48 - cluster is down 418s ok 49 - pg_ctlcluster 12 main start 418s ok 50 - correct output of pg_ctlcluster 12 main start 418s ok 51 - pg_lsclusters -h 418s ok 52 - cluster is online 418s # test upgrade 418s ok 53 - only one major version installed, skipping upgrade test 418s ok 54 - ... 418s ok 55 - get_cluster_start_conf for old cluster returns manual 418s ok 56 - get_cluster_start_conf for new cluster returns manual 418s ok 57 - ... 419s ok 58 - dropping upgraded cluster 419s ok 59 - pg_lsclusters -h 419s ok 60 - no clusters any more 419s ok 61 - pg_createcluster 12 main --start-conf foo 419s ok 62 - pg_createcluster checks --start-conf validity 419s ok 63 - pg_createcluster checks --start-conf manual 419s ok 64 - get_cluster_start_conf returns manual 419s ok 65 - dropping cluster 419s ok 66 - Cleanup: No clusters left behind 419s ok 67 - No postgres processes left behind 419s ok 68 - No files in /etc/postgresql left behind 419s ok 69 - No files in /var/lib/postgresql left behind 419s ok 70 - No files in /var/run/postgresql left behind 419s ok 71 - No files in /var/log/postgresql left behind 419s ok 72 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 419s ok 73 - PostgreSQL TCP ports are closed 419s === Running test 085_pg_ctl.conf.t ... === 419s 1..29 420s ok 1 - pg_createcluster 12 main 420s ok 2 - /etc/postgresql/12/main/pg_ctl.conf exists 423s ok 3 - pg_ctlcluster 12 main start 423s ok 4 - starting cluster 423s ok 5 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 423s ok 6 - soft core size is 0 423s ok 7 - set pg_ctl default option to -c 425s ok 8 - pg_ctlcluster 12 main restart 425s ok 9 - restarting cluster 425s ok 10 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 425s ok 11 - soft core size is unlimited 425s ok 12 - restored pg_ctl default option 427s ok 13 - pg_ctlcluster 12 main restart 427s ok 14 - restarting cluster 427s ok 15 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 427s ok 16 - soft core size is 0 429s ok 17 - pg_ctlcluster 12 main restart -- -c 429s ok 18 - restarting cluster with -c on the command line 429s ok 19 - xargs -i awk '/core/ {print $5}' /proc/{}/limits < /var/run/postgresql/12-main.pid 429s ok 20 - soft core size is unlimited 430s ok 21 - dropping cluster 430s ok 22 - Cleanup: No clusters left behind 430s ok 23 - No postgres processes left behind 430s ok 24 - No files in /etc/postgresql left behind 430s ok 25 - No files in /var/lib/postgresql left behind 430s ok 26 - No files in /var/run/postgresql left behind 430s ok 27 - No files in /var/log/postgresql left behind 430s ok 28 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 430s ok 29 - PostgreSQL TCP ports are closed 430s === Running test 090_multicluster.t ... === 430s 1..125 431s ok 1 - pg_createcluster 12 old 432s ok 2 - pg_createcluster 12 new1 432s ok 3 - pg_createcluster 12 new2 435s ok 4 - starting cluster 12/old 437s ok 5 - starting cluster 12/new1 439s ok 6 - starting cluster 12/new2 439s ok 7 - pg_lsclusters -h | sort -k3 439s ok 8 - clusters have the correct ports, skipping used 5433 439s ok 9 - Temporarily moving away /etc/postgresql-common/user_clusters 439s ok 10 - createdb --version 439s ok 11 - pg_wrapper selects port 5432 as default cluster 439s ok 12 - createdb --cluster 12/new1 --version 439s ok 13 - pg_wrapper --cluster works 439s ok 14 - createdb --cluster 12/foo --version 439s ok 15 - pg_wrapper --cluster errors out for invalid cluster 439s ok 16 - createdb --cluster 12/new1 test 439s ok 17 - correct output of createdb --cluster 12/new1 test 439s ok 18 - psql -Atl --cluster 12/new1 439s ok 19 - test db appears in cluster new1 439s ok 20 - psql -Atl --cluster 12/new2 439s ok 21 - test db does not appear in cluster new2 439s ok 22 - psql -Atl 439s ok 23 - test db does not appear in default cluster 440s ok 24 - psql --cluster 12/127.0.0.1: -Atc 'show port' template1 440s ok 25 - psql --cluster 12/127.0.0.1: defaults to port 5432 440s ok 26 - createdb --cluster 12/127.0.0.1:5432 --version 440s ok 27 - createdb --cluster 12/127.0.0.1:5432 uses latest client version 440s ok 28 - psql -Atl --cluster 12/localhost:5434 440s ok 29 - test db appears in cluster 12/localhost:5434 440s ok 30 - psql -Atl --cluster 12/localhost:5440 440s ok 31 - test db does not appear in cluster 12/localhost:5440 440s ok 32 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:5435 440s ok 33 - psql --cluster 12/localhost:5435 fails due to nonexisting port 440s ok 34 - LC_MESSAGES=C psql -Atl --cluster 12/localhost:a 440s ok 35 - psql --cluster 12/localhost:a fails due to invalid syntax 440s ok 36 - LC_MESSAGES=C psql -Atl --cluster 12/doesnotexi.st 440s ok 37 - psql --cluster 12/doesnotexi.st fails due to invalid syntax 440s ok 38 - psql -Atl --cluster 6.4/localhost: 440s ok 39 - psql --cluster 6.4/localhost: fails due to invalid version 440s ok 40 - psql -Atl 440s ok 41 - PGCLUSTER selection (1) 440s ok 42 - psql -Atl 440s ok 43 - PGCLUSTER selection (2) 440s ok 44 - psql -l 440s ok 45 - invalid PGCLUSTER value 440s ok 46 - createdb --version 440s ok 47 - PGCLUSTER network cluster selection (1) 440s ok 48 - psql -Atl 440s ok 49 - PGCLUSTER network cluster selection (2) 440s ok 50 - psql -Atl 440s ok 51 - PGCLUSTER network cluster selection (3) 440s ok 52 - LC_MESSAGES=C psql -Atl 440s ok 53 - psql --cluster 12/localhost:5435 fails due to nonexisting port 440s ok 54 - psql -Atc "show port" template1 440s ok 55 - PGPORT selection (1) 440s ok 56 - psql -Atc "show port" template1 440s ok 57 - PGPORT selection (2) 440s ok 58 - createdb --version 440s ok 59 - PGPORT+PGCLUSTER, PGCLUSTER selects version 440s ok 60 - psql -Atc "show port" template1 440s ok 61 - PGPORT+PGCLUSTER, PGPORT selects port 440s ok 62 - psql --cluster 12/new1 -Atc 'select current_database()' 440s ok 63 - PGDATABASE environment variable works 440s ok 64 - createdb --version 440s ok 65 - pg_wrapper selects port 5432 as default cluster with empty user_clusters 440s ok 66 - createdb --cluster 12/new1 --version 440s ok 67 - pg_wrapper --cluster works with empty user_clusters 440s ok 68 - createdb --version 440s ok 69 - pg_wrapper selects correct cluster with user_clusters '* * 12 new1 *' 440s ok 70 - psql -Atc "select current_database()" 440s ok 71 - pg_wrapper selects correct database with user_clusters '* * 12 new1 test' 440s ok 72 - psql -Atc 'select current_database()' 440s ok 73 - PGDATABASE environment variable is not overridden by user_clusters 440s ok 74 - createdb --version 440s ok 75 - pg_wrapper selects correct cluster with per-user user_clusters 441s ok 76 - createdb --version 441s ok 77 - pg_wrapper selects correct cluster with per-user user_clusters 441s ok 78 - createdb --version 441s ok 79 - pg_wrapper warning for invalid per-user user_clusters line 441s ok 80 - createdb --version 441s ok 81 - pg_wrapper selects correct version with per-user user_clusters 441s ok 82 - createdb --version 441s ok 83 - pg_wrapper selects correct version with per-user user_clusters 441s ok 84 - createdb --version 441s ok 85 - pg_wrapper warning for invalid per-user user_clusters line 441s ok 86 - psql -Atl 441s ok 87 - $PGHOST overrides user_clusters 441s ok 88 - psql --cluster 12/localhost:5434 -Atc 'select current_database()' test 441s ok 89 - --cluster overrides $PGHOST 441s ok 90 - createdb --version 441s ok 91 - pg_wrapper ignores invalid lines in user_clusters 441s ok 92 - psql -Atc 'select current_database()' 441s ok 93 - pg_service conf selection 1 441s ok 94 - psql -Atc 'select current_database()' 441s ok 95 - pg_service conf selection 2 441s ok 96 - psql -Atc 'select current_database()' 441s ok 97 - pg_service conf selection 3 441s ok 98 - stopping cluster 12/old 443s ok 99 - restarting cluster 12/old 443s ok 100 - pg_lsclusters -h | sort -k3 443s ok 101 - port of first cluster was successfully changed 443s ok 102 - psql -l 443s ok 103 - proper pg_wrapper warning and psql error if no cluster is suitable as default target 443s ok 104 - psql -Atl --cluster 12/new1 443s ok 105 - --cluster selects appropriate cluster 444s ok 106 - psql -Atl -p 5434 444s ok 107 - -p selects appropriate cluster 444s ok 108 - psql -Atlp 5434 444s ok 109 - -Atlp selects appropriate cluster 444s ok 110 - psql -Atl --port 5434 444s ok 111 - --port selects appropriate cluster 444s ok 112 - env PGPORT=5434 psql -Atl 444s ok 113 - $PGPORT selects appropriate cluster 444s ok 114 - Restoring original /etc/postgresql-common/user_clusters 444s ok 115 - dropping 12/new1 445s ok 116 - dropping 12/new2 445s ok 117 - dropping 12/old 445s ok 118 - Cleanup: No clusters left behind 445s ok 119 - No postgres processes left behind 445s ok 120 - No files in /etc/postgresql left behind 445s ok 121 - No files in /var/lib/postgresql left behind 445s ok 122 - No files in /var/run/postgresql left behind 445s ok 123 - No files in /var/log/postgresql left behind 445s ok 124 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 445s ok 125 - PostgreSQL TCP ports are closed 445s === Running test 100_upgrade_scripts.t ... === 445s 1..27 448s ok 1 - pg_createcluster 12 main 448s ok 2 - createdb --cluster 12/main db1 448s ok 3 - correct output of createdb --cluster 12/main db1 448s ok 4 - createdb --cluster 12/main db2 448s ok 5 - correct output of createdb --cluster 12/main db2 448s ok 6 - psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 448s ok 7 - correct output of psql -q --cluster 12/main db1 -c 'CREATE TABLE log (str varchar)' 448s ok 8 - get_cluster_databases() works 448s ok 9 - /usr/share/postgresql-common/upgrade-scripts has no scripts (for the test) 450s ok 10 - run-upgrade-scripts succeeds 450s ok 11 - correct run-upgrade-script output 450s ok 12 - psql --cluster 12/main db1 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 450s ok 13 - check SQL scripts results in 12/main db1 450s ok 14 - psql --cluster 12/main db2 -Atc "select tablename from pg_tables where schemaname = 'public' order by tablename" 450s ok 15 - check SQL scripts results in 12/main db2 450s ok 16 - psql --cluster 12/main db1 -Atc 'select * from log order by str' 450s ok 17 - check shell scripts results in $v/main 450s ok 18 - /usr/share/postgresql-common/upgrade-scripts has no test suite scripts any more 451s ok 19 - pg_dropcluster 12 main 451s ok 20 - Cleanup: No clusters left behind 451s ok 21 - No postgres processes left behind 451s ok 22 - No files in /etc/postgresql left behind 451s ok 23 - No files in /var/lib/postgresql left behind 451s ok 24 - No files in /var/run/postgresql left behind 451s ok 25 - No files in /var/log/postgresql left behind 451s ok 26 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 451s ok 27 - PostgreSQL TCP ports are closed 451s === Running test 110_integrate_cluster.t ... === 451s 1..32 452s ok 1 - /usr/lib/postgresql/12/bin/initdb /tmp/pAbDjJVPAn/c/postgres 452s ok 2 - creating raw initdb cluster for user postgres 452s ok 3 - pg_createcluster 12 postgres -d /tmp/pAbDjJVPAn/c/postgres 452s ok 4 - integrating postgres cluster 452s ok 5 - pg_lsclusters 452s ok 6 - correct pg_lsclusters output 454s ok 7 - pg_ctlcluster 12 postgres start 454s ok 8 - starting cluster postgres 454s ok 9 - pg_lsclusters 454s ok 10 - correct pg_lsclusters output 454s ok 11 - dropping cluster postgres 454s ok 12 - No files in temporary cluster dir left behind 455s ok 13 - /usr/lib/postgresql/12/bin/initdb /tmp/pAbDjJVPAn/c/nobody 455s ok 14 - creating raw initdb cluster for user nobody 455s ok 15 - pg_createcluster 12 nobody -d /tmp/pAbDjJVPAn/c/nobody 455s ok 16 - integrating nobody cluster 455s ok 17 - pg_lsclusters 455s ok 18 - correct pg_lsclusters output 458s ok 19 - pg_ctlcluster 12 nobody start 458s ok 20 - starting cluster nobody 458s ok 21 - pg_lsclusters 458s ok 22 - correct pg_lsclusters output 458s ok 23 - dropping cluster nobody 458s ok 24 - No files in temporary cluster dir left behind 458s ok 25 - Cleanup: No clusters left behind 458s ok 26 - No postgres processes left behind 458s ok 27 - No files in /etc/postgresql left behind 458s ok 28 - No files in /var/lib/postgresql left behind 458s ok 29 - No files in /var/run/postgresql left behind 458s ok 30 - No files in /var/log/postgresql left behind 458s ok 31 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 458s ok 32 - PostgreSQL TCP ports are closed 458s === Running test 120_pg_upgradecluster_scripts.t ... === 458s 1..1 458s ok 1 - only one major version installed, skipping upgrade tests 458s === Running test 130_nonroot_admin.t ... === 458s 1..22 461s ok 1 - pg_createcluster succeeds as user postgres with appropriate owner permissions 461s ok 2 - pg_lsclusters -h 461s ok 3 - correct output of pg_lsclusters -h 461s ok 4 - psql -Atl 461s ok 5 - correct output of psql -Atl 461s ok 6 - pg_dropcluster succeeds as user postgres with appropriate directory owner permissions 461s ok 7 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 8 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 9 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 10 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 11 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 12 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 13 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 14 # skip Only one major version installed, skipping pg_upgradecluster tests 461s ok 15 - Cleanup: No clusters left behind 461s ok 16 - No postgres processes left behind 461s ok 17 - No files in /etc/postgresql left behind 461s ok 18 - No files in /var/lib/postgresql left behind 461s ok 19 - No files in /var/run/postgresql left behind 461s ok 20 - No files in /var/log/postgresql left behind 461s ok 21 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 461s ok 22 - PostgreSQL TCP ports are closed 461s === Running test 135_pg_virtualenv.t ... === 461s 1..20 465s ok 1 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 465s ok 2 - running pg_virtualenv as root 468s ok 3 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 468s ok 4 - running pg_virtualenv as postgres 471s ok 5 - pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 471s ok 6 - running pg_virtualenv as nobody 475s ok 7 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 475s ok 8 - running fakeroot pg_virtualenv as root 478s ok 9 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 478s ok 10 - running fakeroot pg_virtualenv as postgres 481s ok 11 - fakeroot pg_virtualenv -v 12 sh -c 'echo "id|$(id -un)"; psql -AtXxc "SELECT current_user"' 481s ok 12 - running fakeroot pg_virtualenv as nobody 481s ok 13 - Cleanup: No clusters left behind 481s ok 14 - No postgres processes left behind 481s ok 15 - No files in /etc/postgresql left behind 481s ok 16 - No files in /var/lib/postgresql left behind 481s ok 17 - No files in /var/run/postgresql left behind 481s ok 18 - No files in /var/log/postgresql left behind 481s ok 19 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 481s ok 20 - PostgreSQL TCP ports are closed 481s === Running test 140_pg_config.t ... === 481s 1..38 481s # Multiarch is enabled 481s # checking version specific output for 12 481s ok 1 - /usr/lib/postgresql/12/bin/pg_config --pgxs 481s ok 2 - correct output of /usr/lib/postgresql/12/bin/pg_config --pgxs 481s ok 3 - /usr/lib/postgresql/12/bin/pg_config --libdir 481s ok 4 - correct output of /usr/lib/postgresql/12/bin/pg_config --libdir 481s ok 5 - /usr/lib/postgresql/12/bin/pg_config --pkglibdir 481s ok 6 - correct output of /usr/lib/postgresql/12/bin/pg_config --pkglibdir 481s ok 7 - /usr/lib/postgresql/12/bin/pg_config --bindir 481s ok 8 - correct output of /usr/lib/postgresql/12/bin/pg_config --bindir 481s ok 9 - grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s ok 10 - correct output of grep ^MKDIR_P /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s ok 11 - grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s ok 12 - correct output of grep ^abs_top_builddir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s ok 13 - grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s ok 14 - correct output of grep ^abs_top_srcdir /usr/lib/postgresql/12/lib/pgxs/src/Makefile.global 481s # checking pg_config output (should behave like version 12) 481s ok 15 - pg_config 481s ok 16 - correct output of pg_config 481s ok 17 - pg_config --help 481s ok 18 - correct output of pg_config --help 481s ok 19 - pg_config --pgxs 481s ok 20 - correct output of pg_config --pgxs 481s ok 21 - pg_config --libdir 481s ok 22 - correct output of pg_config --libdir 481s ok 23 - pg_config --pkglibdir 481s ok 24 - correct output of pg_config --pkglibdir 481s ok 25 - pg_config --bindir 481s ok 26 - correct output of pg_config --bindir 481s # checking pg_config.libpq-dev output (should behave like version 12) 481s ok 27 - pg_config.libpq-dev 481s ok 28 - correct output of pg_config.libpq-dev 481s ok 29 - pg_config.libpq-dev --help 481s ok 30 - correct output of pg_config.libpq-dev --help 481s ok 31 - pg_config.libpq-dev --pgxs 481s ok 32 - correct output of pg_config.libpq-dev --pgxs 481s ok 33 - pg_config.libpq-dev --libdir 481s ok 34 - correct output of pg_config.libpq-dev --libdir 481s ok 35 - pg_config.libpq-dev --pkglibdir 481s ok 36 - correct output of pg_config.libpq-dev --pkglibdir 481s ok 37 - pg_config.libpq-dev --bindir 481s ok 38 - correct output of pg_config.libpq-dev --bindir 481s === Running test 150_tsearch_stemming.t ... === 481s 1..37 481s ok 1 - pg_updatedicts succeeded 481s ok 2 - pg_updatedicts created en_us.affix 481s ok 3 - pg_updatedicts created en_us.dict 481s ok 4 - pg_updatedicts created 12 en_us.affix symlink 481s ok 5 - pg_updatedicts created 12 en_us.dict symlink 484s ok 6 - pg_createcluster 12 main 484s ok 7 - createdb fts 484s ok 8 - correct output of createdb fts 485s ok 9 - creating en_US full text search configuration 485s ok 10 - creating data table and search index 485s ok 11 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'friendliest')" 485s ok 12 - stem search of correct word 485s ok 13 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'father''s')" 485s ok 14 - stem search of correct word 485s ok 15 - psql -Atd fts -c "SELECT dictionary, lexemes FROM ts_debug('public.sc_english', 'duffles')" 485s ok 16 - stem search of unknown word 485s ok 17 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rocks') query WHERE query @@ to_tsvector(text)" 485s ok 18 - full text search, exact word 485s ok 19 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('rock') query WHERE query @@ to_tsvector(text)" 485s ok 20 - full text search for word stem 485s ok 21 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('roc') query WHERE query @@ to_tsvector(text)" 485s ok 22 - full text search for word substring fails 485s ok 23 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('cafés') query WHERE query @@ to_tsvector(text)" 485s ok 24 - full text search, exact unicode word 485s ok 25 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('café') query WHERE query @@ to_tsvector(text)" 485s ok 26 - full text search for unicode word stem 485s ok 27 - psql -Atd fts -c "SELECT text FROM stuff, to_tsquery('afé') query WHERE query @@ to_tsvector(text)" 485s ok 28 - full text search for unicode word substring fails 486s ok 29 486s ok 30 - Cleanup: No clusters left behind 486s ok 31 - No postgres processes left behind 486s ok 32 - No files in /etc/postgresql left behind 486s ok 33 - No files in /var/lib/postgresql left behind 486s ok 34 - No files in /var/run/postgresql left behind 486s ok 35 - No files in /var/log/postgresql left behind 486s ok 36 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 486s ok 37 - PostgreSQL TCP ports are closed 486s === Running test 160_alternate_confroot.t ... === 486s 1..28 489s ok 1 489s ok 2 - env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 489s ok 3 - correct output of env -u PG_CLUSTER_CONF_ROOT pg_lsclusters -h 489s ok 4 - pg_lsclusters -h 489s ok 5 - correct output of pg_lsclusters -h 489s ok 6 - psql -Atl 489s ok 7 - correct output of psql -Atl 489s ok 8 - Only one major version installed, skipping pg_upgradecluster tests 489s ok 9 - ... 489s ok 10 - ... 489s ok 11 - ... 489s ok 12 - ... 489s ok 13 - ... 489s ok 14 - ... 489s ok 15 - pg_dropcluster 12 test --stop 489s ok 16 - correct output of pg_dropcluster 12 test --stop 489s ok 17 - pg_lsclusters -h 489s ok 18 - correct output of pg_lsclusters -h 489s ok 19 - No files in root/data left behind 489s ok 20 - No cruft in root dir left behind 489s ok 21 - Cleanup: No clusters left behind 489s ok 22 - No postgres processes left behind 489s ok 23 - No files in /etc/postgresql left behind 489s ok 24 - No files in /var/lib/postgresql left behind 489s ok 25 - No files in /var/run/postgresql left behind 489s ok 26 - No files in /var/log/postgresql left behind 489s ok 27 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 489s ok 28 - PostgreSQL TCP ports are closed 489s === Running test 170_extensions.t ... === 489s # Running tests for 12 492s ok 1 - pg_createcluster 12 main 492s ok 2 - psql -Atc 'SELECT extname FROM pg_extension' 492s ok 3 - correct output of psql -Atc 'SELECT extname FROM pg_extension' 492s ok 4 - psql -qc 'CREATE EXTENSION "adminpack"' 492s ok 5 - extension adminpack installs without error 492s ok 6 - psql -qc 'DROP EXTENSION "adminpack"' 492s ok 7 - extension adminpack removes without error 492s ok 8 - psql -qc 'CREATE EXTENSION "amcheck"' 492s ok 9 - extension amcheck installs without error 492s ok 10 - psql -qc 'DROP EXTENSION "amcheck"' 492s ok 11 - extension amcheck removes without error 493s ok 12 - psql -qc 'CREATE EXTENSION "autoinc"' 493s ok 13 - extension autoinc installs without error 493s ok 14 - psql -qc 'DROP EXTENSION "autoinc"' 493s ok 15 - extension autoinc removes without error 493s ok 16 - psql -qc 'CREATE EXTENSION "bloom"' 493s ok 17 - extension bloom installs without error 493s ok 18 - psql -qc 'DROP EXTENSION "bloom"' 493s ok 19 - extension bloom removes without error 493s ok 20 - psql -qc 'CREATE EXTENSION "btree_gin"' 493s ok 21 - extension btree_gin installs without error 493s ok 22 - psql -qc 'DROP EXTENSION "btree_gin"' 493s ok 23 - extension btree_gin removes without error 493s ok 24 - psql -qc 'CREATE EXTENSION "btree_gist"' 493s ok 25 - extension btree_gist installs without error 493s ok 26 - psql -qc 'DROP EXTENSION "btree_gist"' 493s ok 27 - extension btree_gist removes without error 493s ok 28 - psql -qc 'CREATE EXTENSION "citext"' 493s ok 29 - extension citext installs without error 493s ok 30 - psql -qc 'DROP EXTENSION "citext"' 493s ok 31 - extension citext removes without error 493s ok 32 - psql -qc 'CREATE EXTENSION "cube"' 493s ok 33 - extension cube installs without error 493s ok 34 - psql -qc 'DROP EXTENSION "cube"' 493s ok 35 - extension cube removes without error 493s ok 36 - psql -qc 'CREATE EXTENSION "dblink"' 493s ok 37 - extension dblink installs without error 493s ok 38 - psql -qc 'DROP EXTENSION "dblink"' 493s ok 39 - extension dblink removes without error 493s ok 40 - psql -qc 'CREATE EXTENSION "dict_int"' 493s ok 41 - extension dict_int installs without error 493s ok 42 - psql -qc 'DROP EXTENSION "dict_int"' 493s ok 43 - extension dict_int removes without error 493s ok 44 - psql -qc 'CREATE EXTENSION "dict_xsyn"' 493s ok 45 - extension dict_xsyn installs without error 493s ok 46 - psql -qc 'DROP EXTENSION "dict_xsyn"' 493s ok 47 - extension dict_xsyn removes without error 494s ok 48 - psql -qc 'CREATE EXTENSION cube' 494s ok 49 - earthdistance dependency cube installs without error 494s ok 50 - psql -qc 'CREATE EXTENSION "earthdistance"' 494s ok 51 - extension earthdistance installs without error 494s ok 52 - psql -qc 'DROP EXTENSION "earthdistance"' 494s ok 53 - extension earthdistance removes without error 494s ok 54 - psql -qc 'DROP EXTENSION cube' 494s ok 55 - earthdistance dependency extension cube removes without error 494s ok 56 - psql -qc 'CREATE EXTENSION "file_fdw"' 494s ok 57 - extension file_fdw installs without error 494s ok 58 - psql -qc 'DROP EXTENSION "file_fdw"' 494s ok 59 - extension file_fdw removes without error 494s ok 60 - psql -qc 'CREATE EXTENSION "fuzzystrmatch"' 494s ok 61 - extension fuzzystrmatch installs without error 494s ok 62 - psql -qc 'DROP EXTENSION "fuzzystrmatch"' 494s ok 63 - extension fuzzystrmatch removes without error 494s ok 64 - psql -qc 'CREATE EXTENSION "hstore"' 494s ok 65 - extension hstore installs without error 494s ok 66 - psql -qc 'DROP EXTENSION "hstore"' 494s ok 67 - extension hstore removes without error 494s ok 68 - psql -qc 'CREATE EXTENSION hstore' 494s ok 69 - hstore_plperl dependency hstore installs without error 494s ok 70 - psql -qc 'CREATE EXTENSION plperl' 494s ok 71 - hstore_plperl dependency plperl installs without error 494s ok 72 - psql -qc 'CREATE EXTENSION "hstore_plperl"' 494s ok 73 - extension hstore_plperl installs without error 494s ok 74 - psql -qc 'DROP EXTENSION "hstore_plperl"' 494s ok 75 - extension hstore_plperl removes without error 494s ok 76 - psql -qc 'DROP EXTENSION hstore' 494s ok 77 - hstore_plperl dependency extension hstore removes without error 494s ok 78 - psql -qc 'DROP EXTENSION plperl' 494s ok 79 - hstore_plperl dependency extension plperl removes without error 494s ok 80 - psql -qc 'CREATE EXTENSION hstore' 494s ok 81 - hstore_plperlu dependency hstore installs without error 495s ok 82 - psql -qc 'CREATE EXTENSION plperlu' 495s ok 83 - hstore_plperlu dependency plperlu installs without error 495s ok 84 - psql -qc 'CREATE EXTENSION "hstore_plperlu"' 495s ok 85 - extension hstore_plperlu installs without error 495s ok 86 - psql -qc 'DROP EXTENSION "hstore_plperlu"' 495s ok 87 - extension hstore_plperlu removes without error 495s ok 88 - psql -qc 'DROP EXTENSION hstore' 495s ok 89 - hstore_plperlu dependency extension hstore removes without error 495s ok 90 - psql -qc 'DROP EXTENSION plperlu' 495s ok 91 - hstore_plperlu dependency extension plperlu removes without error 495s ok 92 - psql -qc 'CREATE EXTENSION hstore' 495s ok 93 - hstore_plpython3u dependency hstore installs without error 495s ok 94 - psql -qc 'CREATE EXTENSION plpython3u' 495s ok 95 - hstore_plpython3u dependency plpython3u installs without error 495s ok 96 - psql -qc 'CREATE EXTENSION "hstore_plpython3u"' 495s ok 97 - extension hstore_plpython3u installs without error 495s ok 98 - psql -qc 'DROP EXTENSION "hstore_plpython3u"' 495s ok 99 - extension hstore_plpython3u removes without error 495s ok 100 - psql -qc 'DROP EXTENSION hstore' 495s ok 101 - hstore_plpython3u dependency extension hstore removes without error 495s ok 102 - psql -qc 'DROP EXTENSION plpython3u' 495s ok 103 - hstore_plpython3u dependency extension plpython3u removes without error 495s ok 104 - psql -qc 'CREATE EXTENSION "insert_username"' 495s ok 105 - extension insert_username installs without error 495s ok 106 - psql -qc 'DROP EXTENSION "insert_username"' 495s ok 107 - extension insert_username removes without error 495s ok 108 - psql -qc 'CREATE EXTENSION "intagg"' 495s ok 109 - extension intagg installs without error 495s ok 110 - psql -qc 'DROP EXTENSION "intagg"' 495s ok 111 - extension intagg removes without error 495s ok 112 - psql -qc 'CREATE EXTENSION "intarray"' 495s ok 113 - extension intarray installs without error 495s ok 114 - psql -qc 'DROP EXTENSION "intarray"' 495s ok 115 - extension intarray removes without error 495s ok 116 - psql -qc 'CREATE EXTENSION "isn"' 495s ok 117 - extension isn installs without error 496s ok 118 - psql -qc 'DROP EXTENSION "isn"' 496s ok 119 - extension isn removes without error 496s ok 120 - psql -qc 'CREATE EXTENSION plperl' 496s ok 121 - jsonb_plperl dependency plperl installs without error 496s ok 122 - psql -qc 'CREATE EXTENSION "jsonb_plperl"' 496s ok 123 - extension jsonb_plperl installs without error 496s ok 124 - psql -qc 'DROP EXTENSION "jsonb_plperl"' 496s ok 125 - extension jsonb_plperl removes without error 496s ok 126 - psql -qc 'DROP EXTENSION plperl' 496s ok 127 - jsonb_plperl dependency extension plperl removes without error 496s ok 128 - psql -qc 'CREATE EXTENSION plperlu' 496s ok 129 - jsonb_plperlu dependency plperlu installs without error 496s ok 130 - psql -qc 'CREATE EXTENSION "jsonb_plperlu"' 496s ok 131 - extension jsonb_plperlu installs without error 496s ok 132 - psql -qc 'DROP EXTENSION "jsonb_plperlu"' 496s ok 133 - extension jsonb_plperlu removes without error 496s ok 134 - psql -qc 'DROP EXTENSION plperlu' 496s ok 135 - jsonb_plperlu dependency extension plperlu removes without error 496s ok 136 - psql -qc 'CREATE EXTENSION plpython3u' 496s ok 137 - jsonb_plpython3u dependency plpython3u installs without error 496s ok 138 - psql -qc 'CREATE EXTENSION "jsonb_plpython3u"' 496s ok 139 - extension jsonb_plpython3u installs without error 496s ok 140 - psql -qc 'DROP EXTENSION "jsonb_plpython3u"' 496s ok 141 - extension jsonb_plpython3u removes without error 496s ok 142 - psql -qc 'DROP EXTENSION plpython3u' 496s ok 143 - jsonb_plpython3u dependency extension plpython3u removes without error 496s ok 144 - psql -qc 'CREATE EXTENSION "lo"' 496s ok 145 - extension lo installs without error 496s ok 146 - psql -qc 'DROP EXTENSION "lo"' 496s ok 147 - extension lo removes without error 496s ok 148 - psql -qc 'CREATE EXTENSION "ltree"' 496s ok 149 - extension ltree installs without error 496s ok 150 - psql -qc 'DROP EXTENSION "ltree"' 496s ok 151 - extension ltree removes without error 496s ok 152 - psql -qc 'CREATE EXTENSION ltree' 496s ok 153 - ltree_plpython3u dependency ltree installs without error 496s ok 154 - psql -qc 'CREATE EXTENSION plpython3u' 496s ok 155 - ltree_plpython3u dependency plpython3u installs without error 496s ok 156 - psql -qc 'CREATE EXTENSION "ltree_plpython3u"' 496s ok 157 - extension ltree_plpython3u installs without error 497s ok 158 - psql -qc 'DROP EXTENSION "ltree_plpython3u"' 497s ok 159 - extension ltree_plpython3u removes without error 497s ok 160 - psql -qc 'DROP EXTENSION ltree' 497s ok 161 - ltree_plpython3u dependency extension ltree removes without error 497s ok 162 - psql -qc 'DROP EXTENSION plpython3u' 497s ok 163 - ltree_plpython3u dependency extension plpython3u removes without error 497s ok 164 - psql -qc 'CREATE EXTENSION "moddatetime"' 497s ok 165 - extension moddatetime installs without error 497s ok 166 - psql -qc 'DROP EXTENSION "moddatetime"' 497s ok 167 - extension moddatetime removes without error 497s ok 168 - psql -qc 'CREATE EXTENSION "pageinspect"' 497s ok 169 - extension pageinspect installs without error 497s ok 170 - psql -qc 'DROP EXTENSION "pageinspect"' 497s ok 171 - extension pageinspect removes without error 497s ok 172 - psql -qc 'CREATE EXTENSION "pg_buffercache"' 497s ok 173 - extension pg_buffercache installs without error 497s ok 174 - psql -qc 'DROP EXTENSION "pg_buffercache"' 497s ok 175 - extension pg_buffercache removes without error 497s ok 176 - psql -qc 'CREATE EXTENSION "pg_freespacemap"' 497s ok 177 - extension pg_freespacemap installs without error 497s ok 178 - psql -qc 'DROP EXTENSION "pg_freespacemap"' 497s ok 179 - extension pg_freespacemap removes without error 497s ok 180 - psql -qc 'CREATE EXTENSION "pg_prewarm"' 497s ok 181 - extension pg_prewarm installs without error 497s ok 182 - psql -qc 'DROP EXTENSION "pg_prewarm"' 497s ok 183 - extension pg_prewarm removes without error 497s ok 184 - psql -qc 'CREATE EXTENSION "pg_stat_statements"' 497s ok 185 - extension pg_stat_statements installs without error 497s ok 186 - psql -qc 'DROP EXTENSION "pg_stat_statements"' 497s ok 187 - extension pg_stat_statements removes without error 497s ok 188 - psql -qc 'CREATE EXTENSION "pg_trgm"' 497s ok 189 - extension pg_trgm installs without error 497s ok 190 - psql -qc 'DROP EXTENSION "pg_trgm"' 497s ok 191 - extension pg_trgm removes without error 497s ok 192 - psql -qc 'CREATE EXTENSION "pg_visibility"' 497s ok 193 - extension pg_visibility installs without error 497s ok 194 - psql -qc 'DROP EXTENSION "pg_visibility"' 497s ok 195 - extension pg_visibility removes without error 497s ok 196 - psql -qc 'CREATE EXTENSION "pgcrypto"' 497s ok 197 - extension pgcrypto installs without error 497s ok 198 - psql -qc 'DROP EXTENSION "pgcrypto"' 497s ok 199 - extension pgcrypto removes without error 498s ok 200 - psql -qc 'CREATE EXTENSION "pgrowlocks"' 498s ok 201 - extension pgrowlocks installs without error 498s ok 202 - psql -qc 'DROP EXTENSION "pgrowlocks"' 498s ok 203 - extension pgrowlocks removes without error 498s ok 204 - psql -qc 'CREATE EXTENSION "pgstattuple"' 498s ok 205 - extension pgstattuple installs without error 498s ok 206 - psql -qc 'DROP EXTENSION "pgstattuple"' 498s ok 207 - extension pgstattuple removes without error 498s ok 208 - psql -qc 'CREATE EXTENSION "plperl"' 498s ok 209 - extension plperl installs without error 498s ok 210 - psql -qc 'DROP EXTENSION "plperl"' 498s ok 211 - extension plperl removes without error 498s ok 212 - psql -qc 'CREATE EXTENSION "plperlu"' 498s ok 213 - extension plperlu installs without error 498s ok 214 - psql -qc 'DROP EXTENSION "plperlu"' 498s ok 215 - extension plperlu removes without error 498s ok 216 - psql -qc 'CREATE EXTENSION "plpython3u"' 498s ok 217 - extension plpython3u installs without error 498s ok 218 - psql -qc 'DROP EXTENSION "plpython3u"' 498s ok 219 - extension plpython3u removes without error 498s ok 220 - psql -qc 'CREATE EXTENSION "pltcl"' 498s ok 221 - extension pltcl installs without error 498s ok 222 - psql -qc 'DROP EXTENSION "pltcl"' 498s ok 223 - extension pltcl removes without error 498s ok 224 - psql -qc 'CREATE EXTENSION "pltclu"' 498s ok 225 - extension pltclu installs without error 498s ok 226 - psql -qc 'DROP EXTENSION "pltclu"' 498s ok 227 - extension pltclu removes without error 498s ok 228 - psql -qc 'CREATE EXTENSION "postgres_fdw"' 498s ok 229 - extension postgres_fdw installs without error 498s ok 230 - psql -qc 'DROP EXTENSION "postgres_fdw"' 498s ok 231 - extension postgres_fdw removes without error 498s ok 232 - psql -qc 'CREATE EXTENSION "refint"' 498s ok 233 - extension refint installs without error 498s ok 234 - psql -qc 'DROP EXTENSION "refint"' 498s ok 235 - extension refint removes without error 498s ok 236 - psql -qc 'CREATE EXTENSION "seg"' 498s ok 237 - extension seg installs without error 498s ok 238 - psql -qc 'DROP EXTENSION "seg"' 498s ok 239 - extension seg removes without error 499s ok 240 - psql -qc 'CREATE EXTENSION "sslinfo"' 499s ok 241 - extension sslinfo installs without error 499s ok 242 - psql -qc 'DROP EXTENSION "sslinfo"' 499s ok 243 - extension sslinfo removes without error 499s ok 244 - psql -qc 'CREATE EXTENSION "tablefunc"' 499s ok 245 - extension tablefunc installs without error 499s ok 246 - psql -qc 'DROP EXTENSION "tablefunc"' 499s ok 247 - extension tablefunc removes without error 499s ok 248 - psql -qc 'CREATE EXTENSION "tcn"' 499s ok 249 - extension tcn installs without error 499s ok 250 - psql -qc 'DROP EXTENSION "tcn"' 499s ok 251 - extension tcn removes without error 499s ok 252 - psql -qc 'CREATE EXTENSION "tsm_system_rows"' 499s ok 253 - extension tsm_system_rows installs without error 499s ok 254 - psql -qc 'DROP EXTENSION "tsm_system_rows"' 499s ok 255 - extension tsm_system_rows removes without error 499s ok 256 - psql -qc 'CREATE EXTENSION "tsm_system_time"' 499s ok 257 - extension tsm_system_time installs without error 499s ok 258 - psql -qc 'DROP EXTENSION "tsm_system_time"' 499s ok 259 - extension tsm_system_time removes without error 499s ok 260 - psql -qc 'CREATE EXTENSION "unaccent"' 499s ok 261 - extension unaccent installs without error 499s ok 262 - psql -qc 'DROP EXTENSION "unaccent"' 499s ok 263 - extension unaccent removes without error 499s ok 264 - psql -qc 'CREATE EXTENSION "uuid-ossp"' 499s ok 265 - extension uuid-ossp installs without error 499s ok 266 - psql -qc 'DROP EXTENSION "uuid-ossp"' 499s ok 267 - extension uuid-ossp removes without error 499s ok 268 - psql -qc 'CREATE EXTENSION "xml2"' 499s ok 269 - extension xml2 installs without error 499s ok 270 - psql -qc 'DROP EXTENSION "xml2"' 499s ok 271 - extension xml2 removes without error 500s ok 272 - pg_dropcluster 12 main 500s ok 273 - Cleanup: No clusters left behind 500s ok 274 - No postgres processes left behind 500s ok 275 - No files in /etc/postgresql left behind 500s ok 276 - No files in /var/lib/postgresql left behind 500s ok 277 - No files in /var/run/postgresql left behind 500s ok 278 - No files in /var/log/postgresql left behind 500s ok 279 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 500s ok 280 - PostgreSQL TCP ports are closed 500s 1..280 500s === Running test 180_ecpg.t ... === 500s 1..17 500s ok 1 - ecpg test.pgc 500s ok 2 - ecpg processing 500s ok 3 - cc -I$(pg_config --includedir) -L$(pg_config --libdir) -o test test.c -lecpg 500s ok 4 - compiling ecpg output 503s ok 5 - pg_createcluster 12 main 503s ok 6 - createuser nobody 503s ok 7 - /tmp/tmp.PPwc2qGXDa/test 503s ok 8 - runs and gives correct output 504s ok 9 - pg_dropcluster 12 main 504s ok 10 - Cleanup: No clusters left behind 504s ok 11 - No postgres processes left behind 504s ok 12 - No files in /etc/postgresql left behind 504s ok 13 - No files in /var/lib/postgresql left behind 504s ok 14 - No files in /var/run/postgresql left behind 504s ok 15 - No files in /var/log/postgresql left behind 504s ok 16 - netstat -avptn 2>/dev/null | grep ":543[2-9]\b.*LISTEN" 504s ok 17 - PostgreSQL TCP ports are closed 504s autopkgtest [04:13:15]: test run-testsuite: -----------------------] 505s autopkgtest [04:13:16]: test run-testsuite: - - - - - - - - - - results - - - - - - - - - - 505s run-testsuite PASS 505s autopkgtest [04:13:16]: @@@@@@@@@@@@@@@@@@@@ summary 505s default-psql PASS 505s run-testsuite PASS 522s nova [W] Using flock in prodstack6-arm64 522s Creating nova instance adt-focal-arm64-postgresql-common-20250326-033156-juju-7f2275-prod-proposed-migration-environment-15-35df8041-d29e-4ed0-a270-8da500f48fd8 from image adt/ubuntu-focal-arm64-server-20250325.img (UUID c4e4a3b7-abbe-4e49-be70-7ae4c6b4317d)... 522s nova [W] Timed out waiting for 7a72f844-6d6e-437d-9850-90f329ff8e99 to get deleted. 522s nova [W] Using flock in prodstack6-arm64 522s Creating nova instance adt-focal-arm64-postgresql-common-20250326-033156-juju-7f2275-prod-proposed-migration-environment-15-35df8041-d29e-4ed0-a270-8da500f48fd8 from image adt/ubuntu-focal-arm64-server-20250325.img (UUID c4e4a3b7-abbe-4e49-be70-7ae4c6b4317d)... 522s nova [W] Timed out waiting for cf14570e-ac91-46d3-b252-8264421c0b08 to get deleted.