[12:09:52.442](0.016s) # setting up data directory
# Checking port 60157
# Found port 60157
Name: primary
Data directory: /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
Backup directory: /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/backup
Archive directory: /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/archives
Connection string: port=60157 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/ZWA_bRh_4Z
Log file: /Users/admin/pgsql/build/testrun/ssl/002_scram/log/002_scram_primary.log
[12:09:52.452](0.010s) # initializing database system by copying initdb template
# Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
# Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /Users/admin/pgsql/build/testrun/ssl/002_scram/log/002_scram_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 40156
d41d8cd98f00b204e9800998ecf8427e
### Restarting node "primary"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /Users/admin/pgsql/build/testrun/ssl/002_scram/log/002_scram_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-03-08 12:09:52.734 UTC [40156][postmaster] LOG:  starting PostgreSQL 17devel on aarch64-darwin, compiled by clang-14.0.3, 64-bit
2024-03-08 12:09:52.734 UTC [40156][postmaster] LOG:  listening on Unix socket "/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/ZWA_bRh_4Z/.s.PGSQL.60157"
2024-03-08 12:09:52.745 UTC [40173][startup] LOG:  database system was shut down at 2024-03-08 12:05:34 UTC
2024-03-08 12:09:52.779 UTC [40156][postmaster] LOG:  database system is ready to accept connections
2024-03-08 12:09:52.861 UTC [40191][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:52.861 UTC [40191][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:52.861 UTC [40191][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:52.864 UTC [40191][client backend] [002_scram.pl][0/2:0] LOG:  statement: select md5('')
2024-03-08 12:09:52.864 UTC [40191][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=admin database=postgres host=[local]
2024-03-08 12:09:52.903 UTC [40201][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:52.921 UTC [40201][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:52.921 UTC [40201][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:52.922 UTC [40201][client backend] [002_scram.pl][1/2:0] LOG:  statement: CREATE USER ssltestuser
2024-03-08 12:09:52.922 UTC [40201][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.018 user=admin database=postgres host=[local]
2024-03-08 12:09:52.955 UTC [40212][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:52.955 UTC [40212][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:52.955 UTC [40212][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:52.956 UTC [40212][client backend] [002_scram.pl][2/2:0] LOG:  statement: CREATE USER md5testuser
2024-03-08 12:09:52.956 UTC [40212][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.000 user=admin database=postgres host=[local]
2024-03-08 12:09:53.007 UTC [40218][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.007 UTC [40218][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.007 UTC [40218][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.007 UTC [40218][client backend] [002_scram.pl][3/2:0] LOG:  statement: CREATE USER anotheruser
2024-03-08 12:09:53.008 UTC [40218][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.001 user=admin database=postgres host=[local]
2024-03-08 12:09:53.052 UTC [40228][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.052 UTC [40228][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.052 UTC [40228][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.053 UTC [40228][client backend] [002_scram.pl][4/2:0] LOG:  statement: CREATE USER yetanotheruser
2024-03-08 12:09:53.065 UTC [40228][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.013 user=admin database=postgres host=[local]
2024-03-08 12:09:53.102 UTC [40246][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.102 UTC [40246][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.102 UTC [40246][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.103 UTC [40246][client backend] [002_scram.pl][5/2:0] LOG:  statement: CREATE DATABASE trustdb
2024-03-08 12:09:53.139 UTC [40246][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.037 user=admin database=postgres host=[local]
2024-03-08 12:09:53.155 UTC [40259][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.155 UTC [40259][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.155 UTC [40259][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.156 UTC [40259][client backend] [002_scram.pl][6/2:0] LOG:  statement: CREATE DATABASE certdb
2024-03-08 12:09:53.378 UTC [40259][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.222 user=admin database=postgres host=[local]
2024-03-08 12:09:53.464 UTC [40299][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.464 UTC [40299][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.464 UTC [40299][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.464 UTC [40299][client backend] [002_scram.pl][7/2:0] LOG:  statement: CREATE DATABASE certdb_dn
2024-03-08 12:09:53.493 UTC [40299][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.029 user=admin database=postgres host=[local]
2024-03-08 12:09:53.516 UTC [40304][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:53.516 UTC [40304][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:53.516 UTC [40304][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:53.517 UTC [40304][client backend] [002_scram.pl][8/2:0] LOG:  statement: CREATE DATABASE certdb_dn_re
2024-03-08 12:09:54.062 UTC [40304][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.545 user=admin database=postgres host=[local]
2024-03-08 12:09:54.172 UTC [40329][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:54.172 UTC [40329][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:54.172 UTC [40329][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:54.173 UTC [40329][client backend] [002_scram.pl][9/2:0] LOG:  statement: CREATE DATABASE certdb_cn
2024-03-08 12:09:54.209 UTC [40329][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.036 user=admin database=postgres host=[local]
2024-03-08 12:09:54.310 UTC [40363][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:54.310 UTC [40363][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:54.310 UTC [40363][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:54.311 UTC [40363][client backend] [002_scram.pl][10/2:0] LOG:  statement: CREATE DATABASE verifydb
2024-03-08 12:09:54.654 UTC [40363][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.344 user=admin database=postgres host=[local]
2024-03-08 12:09:54.933 UTC [40387][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:54.933 UTC [40387][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:54.933 UTC [40387][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:54.934 UTC [40387][client backend] [002_scram.pl][11/2:0] LOG:  statement: SET password_encryption='scram-sha-256';
2024-03-08 12:09:54.934 UTC [40387][client backend] [002_scram.pl][11/3:0] LOG:  statement: ALTER USER ssltestuser PASSWORD 'pass';
2024-03-08 12:09:54.936 UTC [40387][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=admin database=postgres host=[local]
2024-03-08 12:09:54.978 UTC [40391][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:54.978 UTC [40391][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:54.978 UTC [40391][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:54.978 UTC [40391][client backend] [002_scram.pl][12/2:0] LOG:  statement: SET password_encryption='md5';
2024-03-08 12:09:54.978 UTC [40391][client backend] [002_scram.pl][12/3:0] LOG:  statement: ALTER USER md5testuser PASSWORD 'pass';
2024-03-08 12:09:54.979 UTC [40391][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.001 user=admin database=postgres host=[local]
2024-03-08 12:09:55.024 UTC [40401][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 12:09:55.025 UTC [40401][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="admin" method=trust (/Users/admin/pgsql/build/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 12:09:55.025 UTC [40401][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=admin database=postgres application_name=002_scram.pl
2024-03-08 12:09:55.025 UTC [40401][client backend] [002_scram.pl][13/2:0] LOG:  statement: SET password_encryption='scram-sha-256';
2024-03-08 12:09:55.025 UTC [40401][client backend] [002_scram.pl][13/3:0] LOG:  statement: ALTER USER anotheruser PASSWORD 'pass';
2024-03-08 12:09:55.028 UTC [40401][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=admin database=postgres host=[local]
2024-03-08 12:09:55.077 UTC [40156][postmaster] LOG:  received fast shutdown request
2024-03-08 12:09:55.077 UTC [40156][postmaster] LOG:  aborting any active transactions
2024-03-08 12:09:55.078 UTC [40156][postmaster] LOG:  background worker "logical replication launcher" (PID 40179) exited with exit code 1
2024-03-08 12:09:55.079 UTC [40168][checkpointer] LOG:  shutting down
2024-03-08 12:09:55.079 UTC [40168][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-03-08 12:09:57.622 UTC [40168][checkpointer] LOG:  checkpoint complete: wrote 5590 buffers (34.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=2.543 s, sync=0.001 s, total=2.544 s; sync files=0, longest=0.000 s, average=0.000 s; distance=44997 kB, estimate=44997 kB; lsn=0/4104C60, redo lsn=0/4104C60
2024-03-08 12:09:57.640 UTC [40156][postmaster] LOG:  database system is shut down
2024-03-08 12:09:58.451 UTC [40645][postmaster] LOG:  starting PostgreSQL 17devel on aarch64-darwin, compiled by clang-14.0.3, 64-bit
2024-03-08 12:09:58.452 UTC [40645][postmaster] LOG:  could not bind IPv4 address "127.0.0.1": Address already in use
2024-03-08 12:09:58.452 UTC [40645][postmaster] HINT:  Is another postmaster already running on port 60157? If not, wait a few seconds and retry.
2024-03-08 12:09:58.452 UTC [40645][postmaster] WARNING:  could not create listen socket for "127.0.0.1"
2024-03-08 12:09:58.452 UTC [40645][postmaster] FATAL:  could not create any TCP/IP sockets
2024-03-08 12:09:58.452 UTC [40645][postmaster] LOG:  database system is shut down
# No postmaster PID for node "primary"
[12:09:58.559](6.107s) Bail out!  pg_ctl restart failed
# No postmaster PID for node "primary"