This is a useful script that I used in https://gitlab.com/gitlab-org/gitlab/-/issues/346427#note_745612725. I would modify it to use replication slots, since using `-R` with `pg_basebackup` from the secondary will automatically keep both primary and secondary in sync.