# Running: pg_createsubscriber --help
[02:39:54.198](0.147s) ok 1 - pg_createsubscriber --help exit code 0
[02:39:54.198](0.000s) ok 2 - pg_createsubscriber --help goes to stdout
[02:39:54.199](0.000s) ok 3 - pg_createsubscriber --help nothing to stderr
[02:39:54.199](0.000s) ok 4 - pg_createsubscriber --help maximum line length
# Running: pg_createsubscriber --version
[02:39:54.270](0.071s) ok 5 - pg_createsubscriber --version exit code 0
[02:39:54.271](0.000s) ok 6 - pg_createsubscriber --version goes to stdout
[02:39:54.271](0.000s) ok 7 - pg_createsubscriber --version nothing to stderr
# Running: pg_createsubscriber --not-a-valid-option
[02:39:54.450](0.179s) ok 8 - pg_createsubscriber with invalid option nonzero exit code
[02:39:54.451](0.001s) ok 9 - pg_createsubscriber with invalid option prints error message
# Running: pg_createsubscriber
pg_createsubscriber: error: no subscriber data directory specified
pg_createsubscriber: hint: Try "pg_createsubscriber --help" for more information.
[02:39:54.544](0.093s) ok 10 - no subscriber data directory specified
# Running: pg_createsubscriber --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J
pg_createsubscriber: error: no publisher connection string specified
pg_createsubscriber: hint: Try "pg_createsubscriber --help" for more information.
[02:39:54.665](0.121s) ok 11 - no publisher connection string specified
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432
pg_createsubscriber: validating connection string on publisher
pg_createsubscriber: validating connection string on subscriber
pg_createsubscriber: no database was specified
pg_createsubscriber: error: no database name specified
pg_createsubscriber: hint: Try "pg_createsubscriber --help" for more information.
[02:39:54.800](0.135s) ok 12 - no database name specified
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432 --database pg1 --database pg1
pg_createsubscriber: error: duplicate database "pg1"
[02:39:54.972](0.172s) ok 13 - duplicate database name
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432 --publication foo1 --publication foo1 --database pg1 --database pg2
pg_createsubscriber: error: duplicate publication "foo1"
[02:39:55.328](0.356s) ok 14 - duplicate publication name
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432 --publication foo1 --database pg1 --database pg2
pg_createsubscriber: validating connection string on publisher
pg_createsubscriber: validating connection string on subscriber
pg_createsubscriber: error: wrong number of publication names
pg_createsubscriber: hint: Number of publication names (1) must match number of database names (2).
[02:39:55.491](0.163s) ok 15 - wrong number of publication names
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432 --publication foo1 --publication foo2 --subscription bar1 --database pg1 --database pg2
pg_createsubscriber: validating connection string on publisher
pg_createsubscriber: validating connection string on subscriber
pg_createsubscriber: error: wrong number of subscription names
pg_createsubscriber: hint: Number of subscription names (1) must match number of database names (2).
[02:39:55.696](0.205s) ok 16 - wrong number of subscription names
# Running: pg_createsubscriber --verbose --pgdata C:\cirrus\build\testrun\pg_basebackup\040_pg_createsubscriber\data\tmp_test_mi1J --publisher-server port=5432 --publication foo1 --publication foo2 --subscription bar1 --subscription bar2 --replication-slot baz1 --database pg1 --database pg2
pg_createsubscriber: validating connection string on publisher
pg_createsubscriber: validating connection string on subscriber
pg_createsubscriber: error: wrong number of replication slot names
pg_createsubscriber: hint: Number of replication slot names (1) must match number of database names (2).
[02:39:55.839](0.142s) ok 17 - wrong number of replication slot names
# Checking port 58925
# Found port 58925
Name: node_p
Data directory: C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/pgdata
Backup directory: C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/backup
Archive directory: C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/archives
Connection string: port=58925 host=C:/Windows/TEMP/M7203UzEq8
Log file: C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\log/040_pg_createsubscriber_node_p.log
[02:39:55.947](0.108s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/pgdata

# Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/pgdata
### Starting node "node_p"
# Running: pg_ctl -w -D C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\data/t_040_pg_createsubscriber_node_p_data/pgdata -l C:\cirrus\build/testrun/pg_basebackup/040_pg_createsubscriber\log/040_pg_createsubscriber_node_p.log -o --cluster-name=node_p start
waiting for server to start...... stopped waiting
pg_ctl: could not start server
Examine the log output.
# pg_ctl start failed; logfile:
2024-03-31 02:39:58.250 GMT [4708][postmaster] LOG:  starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit
2024-03-31 02:39:58.256 GMT [4708][postmaster] LOG:  listening on Unix socket "C:/Windows/TEMP/M7203UzEq8/.s.PGSQL.58925"
2024-03-31 02:39:58.384 GMT [3820][startup] LOG:  database system was shut down at 2024-03-31 02:38:27 GMT
2024-03-31 02:40:00.575 GMT [4708][postmaster] LOG:  startup process (PID 3820) was terminated by exception 0xC0000354
2024-03-31 02:40:00.575 GMT [4708][postmaster] HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
2024-03-31 02:40:00.578 GMT [4708][postmaster] LOG:  aborting startup due to startup process failure
2024-03-31 02:40:00.580 GMT [4708][postmaster] LOG:  database system is shut down
# No postmaster PID for node "node_p"
[02:40:00.665](4.718s) Bail out!  pg_ctl start failed
# No postmaster PID for node "node_p"