[09:29:00.075](0.021s) # setting up data directory
# Checking port 63591
# Found port 63591
Name: primary
Data directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/backup
Archive directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/archives
Connection string: port=63591 host=/tmp/JBfMI1lJbP
Log file: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log
[09:29:00.078](0.003s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build-32/tmp_install/initdb-template /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata
# Running: /tmp/cirrus-ci-build/build-32/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 92171
### Restarting node "primary"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log restart
waiting for server to shut down.... done
server stopped
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
# pg_ctl restart failed; logfile:
2024-04-05 09:29:00.257 UTC [92171][postmaster] LOG:  starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit
2024-04-05 09:29:00.257 UTC [92171][postmaster] LOG:  listening on Unix socket "/tmp/JBfMI1lJbP/.s.PGSQL.63591"
2024-04-05 09:29:00.259 UTC [92184][startup] LOG:  database system was shut down at 2024-04-05 09:26:37 UTC
2024-04-05 09:29:00.261 UTC [92171][postmaster] LOG:  database system is ready to accept connections
2024-04-05 09:29:00.343 UTC [92209][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.343 UTC [92209][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.343 UTC [92209][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.349 UTC [92209][client backend] [003_sslinfo.pl][0/2:0] LOG:  statement: CREATE USER ssltestuser
2024-04-05 09:29:00.350 UTC [92209][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.386 UTC [92232][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.386 UTC [92232][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.386 UTC [92232][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.387 UTC [92232][client backend] [003_sslinfo.pl][1/2:0] LOG:  statement: CREATE USER md5testuser
2024-04-05 09:29:00.388 UTC [92232][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.428 UTC [92243][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.429 UTC [92243][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.429 UTC [92243][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.430 UTC [92243][client backend] [003_sslinfo.pl][2/2:0] LOG:  statement: CREATE USER anotheruser
2024-04-05 09:29:00.430 UTC [92243][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.491 UTC [92253][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.491 UTC [92253][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.491 UTC [92253][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.502 UTC [92253][client backend] [003_sslinfo.pl][3/2:0] LOG:  statement: CREATE USER yetanotheruser
2024-04-05 09:29:00.503 UTC [92253][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.532 UTC [92265][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.532 UTC [92265][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.532 UTC [92265][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.533 UTC [92265][client backend] [003_sslinfo.pl][4/2:0] LOG:  statement: CREATE DATABASE trustdb
2024-04-05 09:29:00.565 UTC [92265][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.572 UTC [92272][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.573 UTC [92272][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.573 UTC [92272][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.574 UTC [92272][client backend] [003_sslinfo.pl][5/2:0] LOG:  statement: CREATE DATABASE certdb
2024-04-05 09:29:00.614 UTC [92272][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.041 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.696 UTC [92309][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.696 UTC [92309][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.696 UTC [92309][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.697 UTC [92309][client backend] [003_sslinfo.pl][6/2:0] LOG:  statement: CREATE DATABASE certdb_dn
2024-04-05 09:29:00.723 UTC [92309][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.755 UTC [92324][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.755 UTC [92324][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.755 UTC [92324][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.756 UTC [92324][client backend] [003_sslinfo.pl][7/2:0] LOG:  statement: CREATE DATABASE certdb_dn_re
2024-04-05 09:29:00.799 UTC [92324][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.044 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.865 UTC [92363][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.866 UTC [92363][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.866 UTC [92363][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.867 UTC [92363][client backend] [003_sslinfo.pl][8/2:0] LOG:  statement: CREATE DATABASE certdb_cn
2024-04-05 09:29:00.891 UTC [92363][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.025 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.909 UTC [92372][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.909 UTC [92372][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.909 UTC [92372][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl
2024-04-05 09:29:00.910 UTC [92372][client backend] [003_sslinfo.pl][9/2:0] LOG:  statement: CREATE DATABASE verifydb
2024-04-05 09:29:00.936 UTC [92372][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local]
2024-04-05 09:29:00.950 UTC [92381][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.950 UTC [92381][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.950 UTC [92381][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=trustdb application_name=003_sslinfo.pl
2024-04-05 09:29:00.955 UTC [92381][client backend] [003_sslinfo.pl][10/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:00.977 UTC [92381][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.027 user=postgres database=trustdb host=[local]
2024-04-05 09:29:00.992 UTC [92389][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:00.992 UTC [92389][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:00.992 UTC [92389][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=certdb application_name=003_sslinfo.pl
2024-04-05 09:29:00.997 UTC [92389][client backend] [003_sslinfo.pl][11/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:00.999 UTC [92389][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=certdb host=[local]
2024-04-05 09:29:01.035 UTC [92401][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:01.035 UTC [92401][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:01.035 UTC [92401][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=certdb_dn application_name=003_sslinfo.pl
2024-04-05 09:29:01.040 UTC [92401][client backend] [003_sslinfo.pl][12/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:01.042 UTC [92401][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=certdb_dn host=[local]
2024-04-05 09:29:01.076 UTC [92408][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:01.077 UTC [92408][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:01.077 UTC [92408][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=certdb_dn_re application_name=003_sslinfo.pl
2024-04-05 09:29:01.082 UTC [92408][client backend] [003_sslinfo.pl][13/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:01.084 UTC [92408][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=certdb_dn_re host=[local]
2024-04-05 09:29:01.119 UTC [92422][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:01.120 UTC [92422][client backend] [[unknown]][14/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:01.120 UTC [92422][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=postgres database=certdb_cn application_name=003_sslinfo.pl
2024-04-05 09:29:01.124 UTC [92422][client backend] [003_sslinfo.pl][14/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:01.126 UTC [92422][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=certdb_cn host=[local]
2024-04-05 09:29:01.161 UTC [92426][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-04-05 09:29:01.162 UTC [92426][client backend] [[unknown]][15/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117)
2024-04-05 09:29:01.162 UTC [92426][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=postgres database=verifydb application_name=003_sslinfo.pl
2024-04-05 09:29:01.166 UTC [92426][client backend] [003_sslinfo.pl][15/2:0] LOG:  statement: CREATE EXTENSION sslinfo CASCADE;
2024-04-05 09:29:01.168 UTC [92426][client backend] [003_sslinfo.pl][:0] LOG:  disconnection: session time: 0:00:00.007 user=postgres database=verifydb host=[local]
2024-04-05 09:29:01.204 UTC [92171][postmaster] LOG:  received fast shutdown request
2024-04-05 09:29:01.205 UTC [92171][postmaster] LOG:  aborting any active transactions
2024-04-05 09:29:01.206 UTC [92171][postmaster] LOG:  background worker "logical replication launcher" (PID 92187) exited with exit code 1
2024-04-05 09:29:01.207 UTC [92182][checkpointer] LOG:  shutting down
2024-04-05 09:29:01.207 UTC [92182][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-04-05 09:29:01.243 UTC [92182][checkpointer] LOG:  checkpoint complete: wrote 5476 buffers (33.4%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.036 s, sync=0.001 s, total=0.036 s; sync files=0, longest=0.000 s, average=0.000 s; distance=44101 kB, estimate=44101 kB; lsn=0/400BA34, redo lsn=0/400BA34
2024-04-05 09:29:01.251 UTC [92171][postmaster] LOG:  database system is shut down
2024-04-05 09:29:01.319 UTC [92441][postmaster] LOG:  starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit
2024-04-05 09:29:01.319 UTC [92441][postmaster] LOG:  could not bind IPv4 address "127.0.0.1": Address already in use
2024-04-05 09:29:01.319 UTC [92441][postmaster] HINT:  Is another postmaster already running on port 63591? If not, wait a few seconds and retry.
2024-04-05 09:29:01.319 UTC [92441][postmaster] WARNING:  could not create listen socket for "127.0.0.1"
2024-04-05 09:29:01.319 UTC [92441][postmaster] FATAL:  could not create any TCP/IP sockets
2024-04-05 09:29:01.320 UTC [92441][postmaster] LOG:  database system is shut down
# No postmaster PID for node "primary"
[09:29:01.405](1.328s) Bail out!  pg_ctl restart failed
# No postmaster PID for node "primary"