pg_createsubscriber
converts a physical standby to logical replication subscriber
TLDR
Create subscriber from standby
$ pg_createsubscriber -d [dbname] -D [data_dir] -P [conninfo]
SYNOPSIS
pg_createsubscriber [options]
DESCRIPTION
pg_createsubscriber converts a physical standby to logical replication subscriber. Transforms streaming replication to logical replication. Part of PostgreSQL 17+.
PARAMETERS
-d, --database name
Database name.-D, --pgdata dir
Data directory.-P, --publisher-server conninfo
Publisher connection string.-n, --dry-run
Show what would be done.