# Running: pg_ctl --help [21:43:03.668](0.075s) ok 1 - pg_ctl --help exit code 0 [21:43:03.668](0.000s) ok 2 - pg_ctl --help goes to stdout [21:43:03.669](0.000s) ok 3 - pg_ctl --help nothing to stderr [21:43:03.669](0.000s) ok 4 - pg_ctl --help maximum line length # Running: pg_ctl --version [21:43:03.697](0.028s) ok 5 - pg_ctl --version exit code 0 [21:43:03.697](0.000s) ok 6 - pg_ctl --version goes to stdout [21:43:03.697](0.000s) ok 7 - pg_ctl --version nothing to stderr # Running: pg_ctl --not-a-valid-option [21:43:03.728](0.030s) ok 8 - pg_ctl with invalid option nonzero exit code [21:43:03.728](0.001s) ok 9 - pg_ctl with invalid option prints error message # Running: pg_ctl start -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/nonexistent pg_ctl: directory "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/nonexistent" does not exist [21:43:03.755](0.027s) ok 10 - pg_ctl start with nonexistent directory # Running: pg_ctl initdb -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data -o -N The files belonging to this database system will be owned by user "SYSTEM". This user must also own the server process. The database cluster will be initialized with locale "English_United States.1252". The default database encoding has accordingly been set to "WIN1252". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... windows selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Atlantic/Reykjavik creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: ^"C^:^\cirrus^\build^\tmp^_install^\usr^\local^\pgsql^\bin^\pg^_ctl^" -D C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data -l logfile start [21:43:08.677](4.922s) ok 11 - pg_ctl initdb # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data [21:43:08.724](0.047s) ok 12 - configure authentication # Checking port 57992 # Found port 57992 # Running: pg_ctl start -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data -l C:\cirrus\build/testrun/pg_ctl/001_start_stop\log/001_start_stop_server.log [21:43:11.290](2.566s) not ok 13 - pg_ctl start: exit code 0 [21:43:11.290](0.000s) # Failed test 'pg_ctl start: exit code 0' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 47. [21:43:11.291](0.000s) not ok 14 - pg_ctl start: no stderr [21:43:11.291](0.000s) # Failed test 'pg_ctl start: no stderr' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 47. [21:43:11.291](0.000s) # got: 'pg_ctl: could not start server # Examine the log output. # ' # expected: '' [21:43:11.291](0.000s) not ok 15 - pg_ctl start: matches [21:43:11.291](0.000s) # Failed test 'pg_ctl start: matches' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 47. [21:43:11.291](0.000s) # 'waiting for server to start..... stopped waiting # ' # doesn't match '(?^s:done.*server started)' # Running: pg_ctl start -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data waiting for server to start....2024-04-02 21:43:14.459 GMT [2568][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-04-02 21:43:14.461 GMT [2568][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/CThImJ1yo9/.s.PGSQL.57992" 2024-04-02 21:43:14.487 GMT [5552][startup] LOG: database system was interrupted; last known up at 2024-04-02 21:43:09 GMT 2024-04-02 21:43:14.488 GMT [5552][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-04-02 21:43:14.490 GMT [5552][startup] LOG: redo starts at 0/14F9920 2024-04-02 21:43:14.490 GMT [5552][startup] LOG: invalid record length at 0/14F9958: expected at least 24, got 0 2024-04-02 21:43:14.490 GMT [5552][startup] LOG: redo done at 0/14F9920 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-04-02 21:43:14.509 GMT [4996][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-04-02 21:43:14.514 GMT [4996][checkpointer] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/14F9958, redo lsn=0/14F9958 .2024-04-02 21:43:16.759 GMT [2568][postmaster] LOG: startup process (PID 5552) was terminated by exception 0xC0000354 2024-04-02 21:43:16.759 GMT [2568][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-04-02 21:43:16.759 GMT [2568][postmaster] LOG: terminating any other active server processes 2024-04-02 21:43:16.784 GMT [2568][postmaster] LOG: shutting down due to startup process failure 2024-04-02 21:43:16.786 GMT [2568][postmaster] LOG: database system is shut down stopped waiting pg_ctl: could not start server Examine the log output. [21:43:16.894](5.603s) ok 16 - second pg_ctl start fails # Running: pg_ctl stop -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data pg_ctl: PID file "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data/postmaster.pid" does not exist Is server running? [21:43:16.947](0.053s) not ok 17 - pg_ctl stop [21:43:16.948](0.001s) # Failed test 'pg_ctl stop' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 56. # Running: pg_ctl stop -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data pg_ctl: PID file "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data/postmaster.pid" does not exist Is server running? [21:43:17.054](0.107s) ok 18 - second pg_ctl stop fails # Running: pg_ctl restart -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data -l C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data/perm-test-600.log pg_ctl: PID file "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data/postmaster.pid" does not exist Is server running? trying to start server anyway waiting for server to start..... stopped waiting pg_ctl: could not start server Examine the log output. [21:43:19.626](2.571s) not ok 19 - pg_ctl restart with server not running [21:43:19.629](0.003s) # Failed test 'pg_ctl restart with server not running' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 64. [21:43:19.629](0.000s) ok 20 # skip unix-style permissions not supported on Windows [21:43:19.631](0.001s) ok 21 # skip unix-style permissions not supported on Windows [21:43:19.631](0.000s) ok 22 # skip group access not supported on Windows [21:43:19.631](0.000s) ok 23 # skip group access not supported on Windows [21:43:19.632](0.000s) ok 24 # skip group access not supported on Windows # Running: pg_ctl restart -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data pg_ctl: PID file "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data/postmaster.pid" does not exist Is server running? trying to start server anyway waiting for server to start....2024-04-02 21:43:20.134 GMT [3092][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-04-02 21:43:20.135 GMT [3092][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/CThImJ1yo9/.s.PGSQL.57992" 2024-04-02 21:43:20.270 GMT [3904][startup] LOG: database system was interrupted; last known up at 2024-04-02 21:43:17 GMT 2024-04-02 21:43:20.271 GMT [3904][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-04-02 21:43:20.279 GMT [3904][startup] LOG: invalid record length at 0/14F9A48: expected at least 24, got 0 2024-04-02 21:43:20.279 GMT [3904][startup] LOG: redo is not required 2024-04-02 21:43:20.281 GMT [1836][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-04-02 21:43:20.284 GMT [1836][checkpointer] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/14F9A48, redo lsn=0/14F9A48 .2024-04-02 21:43:21.830 GMT [3092][postmaster] LOG: startup process (PID 3904) was terminated by exception 0xC0000354 2024-04-02 21:43:21.830 GMT [3092][postmaster] HINT: See C include file "ntstatus.h" for a description of the hexadecimal value. 2024-04-02 21:43:21.830 GMT [3092][postmaster] LOG: terminating any other active server processes 2024-04-02 21:43:21.913 GMT [3092][postmaster] LOG: shutting down due to startup process failure 2024-04-02 21:43:21.915 GMT [3092][postmaster] LOG: database system is shut down stopped waiting pg_ctl: could not start server Examine the log output. [21:43:22.193](2.561s) not ok 25 - pg_ctl restart with server running [21:43:22.194](0.001s) # Failed test 'pg_ctl restart with server running' # at C:/cirrus/src/bin/pg_ctl/t/001_start_stop.pl line 98. # Running: pg_ctl stop -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data pg_ctl: PID file "C:/cirrus/build/testrun/pg_ctl/001_start_stop/data/tmp_test_4t0b/data/postmaster.pid" does not exist Is server running? [21:43:22.252](0.059s) Bail out! command "pg_ctl stop -D C:\cirrus\build\testrun\pg_ctl\001_start_stop\data\tmp_test_4t0b/data" exited with value 1