Top
Enterprise Postgres 17 SP1 Userlog Operation Guide

3.3 When to Incorporate Standby

To incorporate a standby database, before starting the instance, initialize the extraction start position by executing the pgx_userlog_control command in set mode with the --follow-primary option specified.

Do not initialize with the -l option. This is because the -l option assumes that no transaction is currently running. --follow-primary has the effect of instructing the extraction daemon to wait for all such transactions to end before starting the extraction.

For information about the pgx_userlog_control command, refer to "Appendix C pgx_userlog_control Command".