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