# Checking port 60010
# Found port 60010
Name: oldpub
Data directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata
Backup directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/backup
Archive directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/archives
Connection string: port=60010 host=127.0.0.1
Log file: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_oldpub.log
[10:20:15.576](0.142s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP D:/project/repo/pg_meson2/postgres/build/tmp_install/initdb-template D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata

# Running: D:\project\repo\pg_meson2\postgres\build\src/test\regress\pg_regress.exe --config-auth D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata
# Checking port 60011
# Found port 60011
Name: newpub
Data directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata
Backup directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/backup
Archive directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/archives
Connection string: port=60011 host=127.0.0.1
Log file: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_newpub.log
[10:20:21.943](6.367s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP D:/project/repo/pg_meson2/postgres/build/tmp_install/initdb-template D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata

# Running: D:\project\repo\pg_meson2\postgres\build\src/test\regress\pg_regress.exe --config-auth D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata
### Starting node "oldpub"
# Running: pg_ctl -w -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -l D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start
waiting for server to start.... done
server started
# Postmaster PID for node "oldpub" is 27060
### Stopping node "oldpub" using mode fast
# Running: pg_ctl -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "oldpub"
# Running: pg_upgrade --no-sync -d D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata -b D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -B D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -s 127.0.0.1 -p 60010 -P 60011 --copy
[10:20:33.501](11.558s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1)
[10:20:33.501](0.001s) not ok 2 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stdout /(?^:max_replication_slots \(1\) must be greater than or equal to the number of logical replication slots \(2\) on the old cluster)/
[10:20:33.502](0.000s) #   Failed test 'run of pg_upgrade where the new cluster has insufficient max_replication_slots stdout /(?^:max_replication_slots \(1\) must be greater than or equal to the number of logical replication slots \(2\) on the old cluster)/'
#   at D:/project/repo/pg_meson2/postgres/src/bin/pg_upgrade/t/003_logical_slots.pl line 62.
[10:20:33.502](0.000s) #                   'Performing Consistency Checks
# -----------------------------
# Checking cluster versions                                     ok
# 
# The target cluster lacks cluster state information:
# Failure, exiting
# '
#     doesn't match '(?^:max_replication_slots \(1\) must be greater than or equal to the number of logical replication slots \(2\) on the old cluster)'
[10:20:33.503](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/
[10:20:33.503](0.000s) ok 4 - pg_upgrade_output.d/ not removed after pg_upgrade failure
### Starting node "oldpub"
# Running: pg_ctl -w -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -l D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start
waiting for server to start......... done
server started
# Postmaster PID for node "oldpub" is 38960
### Stopping node "oldpub" using mode fast
# Running: pg_ctl -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "oldpub"
# Running: pg_upgrade --no-sync -d D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata -b D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -B D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -s 127.0.0.1 -p 60010 -P 60011 --copy
[10:20:46.128](12.625s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1)
[10:20:46.129](0.001s) ok 6 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stdout /(?^:Your installation contains logical replication slots that can't be upgraded.)/
[10:20:46.129](0.000s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/
[10:20:46.134](0.005s) ok 8 - the previous test failed due to unconsumed WALs
[10:20:46.135](0.001s) ok 9 - the previous test failed due to unconsumed WALs
### Starting node "oldpub"
# Running: pg_ctl -w -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -l D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start
waiting for server to start.... done
server started
# Postmaster PID for node "oldpub" is 14828
# Checking port 60012
# Found port 60012
Name: sub
Data directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/pgdata
Backup directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/backup
Archive directory: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/archives
Connection string: port=60012 host=127.0.0.1
Log file: D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_sub.log
[10:20:47.399](1.263s) # initializing database system by copying initdb template
# Running: robocopy /E /NJS /NJH /NFL /NDL /NP D:/project/repo/pg_meson2/postgres/build/tmp_install/initdb-template D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/pgdata

# Running: D:\project\repo\pg_meson2\postgres\build\src/test\regress\pg_regress.exe --config-auth D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/pgdata
### Starting node "sub"
# Running: pg_ctl -w -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/pgdata -l D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_sub.log -o --cluster-name=sub start
waiting for server to start......... done
server started
# Postmaster PID for node "sub" is 42200
#### Begin standard error
psql:<stdin>:3: NOTICE:  created replication slot "regress_sub" on publisher
#### End standard error
Waiting for all subscriptions in "sub" to synchronize data
Waiting for replication conn regress_sub's replay_lsn to pass 0/1526548 on oldpub
done
done
### Stopping node "oldpub" using mode fast
# Running: pg_ctl -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "oldpub"
# Running: pg_upgrade --no-sync -d D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_oldpub_data/pgdata -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata -b D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -B D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin -s 127.0.0.1 -p 60010 -P 60011 --copy
Performing Consistency Checks
-----------------------------
Checking cluster versions                                     ok
Checking database user is the install user                    ok
Checking database connection settings                         ok
Checking for prepared transactions                            ok
Checking for system-defined composite types in user tables    ok
Checking for reg* data types in user tables                   ok
Checking for contrib/isn with bigint-passing mismatch         ok
Checking for valid logical replication slots                  ok
Creating dump of global objects                               ok
Creating dump of database schemas                             ok
Checking for presence of required libraries                   ok
Checking database user is the install user                    ok
Checking for prepared transactions                            ok
Checking for new cluster tablespace directories               ok
Checking for new cluster logical replication slots            ok

If pg_upgrade fails after this point, you must re-initdb the
new cluster before continuing.

Performing Upgrade
------------------
Setting locale and encoding for new cluster                   ok
Analyzing all rows in the new cluster                         ok
Freezing all rows in the new cluster                          ok
Deleting files from new pg_xact                               ok
Copying old pg_xact to new server                             ok
Setting oldest XID for new cluster                            ok
Setting next transaction ID and epoch for new cluster         ok
Deleting files from new pg_multixact/offsets                  ok
Copying old pg_multixact/offsets to new server                ok
Deleting files from new pg_multixact/members                  ok
Copying old pg_multixact/members to new server                ok
Setting next multixact ID and offset for new cluster          ok
Resetting WAL archives                                        ok
Setting frozenxid and minmxid counters in new cluster         ok
Restoring global objects in the new cluster                   ok
Restoring database schemas in the new cluster                 ok
Copying user relation files                                   ok
Setting next OID for new cluster                              ok
Restoring logical replication slots in the new cluster        ok
Creating script to delete old cluster                         ok
Checking for extension updates                                ok

Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade.
Once you start the new server, consider running:
    D:/project/repo/pg_meson2/postgres/build/tmp_install/project/pg_meson_master_patch_v1/bin/vacuumdb --all --analyze-in-stages
Running this script will delete the old cluster's data files:
    delete_old_cluster.bat
[10:21:40.188](52.790s) ok 10 - run of pg_upgrade of old cluster
### Starting node "newpub"
# Running: pg_ctl -w -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata -l D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\log/003_logical_slots_newpub.log -o --cluster-name=newpub start
waiting for server to start......... done
server started
# Postmaster PID for node "newpub" is 6484
[10:21:46.187](5.998s) ok 11 - check the slot exists on new cluster
Waiting for replication conn regress_sub's replay_lsn to pass 0/80025E0 on newpub
done
[10:21:47.933](1.746s) ok 12 - check changes are replicated to the sub
### Stopping node "sub" using mode fast
# Running: pg_ctl -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_sub_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "sub"
### Stopping node "newpub" using mode fast
# Running: pg_ctl -D D:\project\repo\pg_meson2\postgres\build/testrun/pg_upgrade/003_logical_slots\data/t_003_logical_slots_newpub_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "newpub"
[10:21:53.317](5.384s) 1..12
[10:21:53.329](0.012s) # Looks like you failed 1 test of 12.
