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