Use logical replication for tables in RDS for PostgreSQL

PostgreSQL and later come with a feature called “replication slots” They can be used to make WAL archiving and streaming replication

The application_name field of pg_stat_activity will reflect if this replication activity comes from a follower or a standby Heroku Postgres databases that are

start 77 slot Setup using CDC​ · Provide additional REPLICATION permissions to read-only user · Enable logical replication on your Postgres database · Create a replication slot

start replication slot postgres The WAL location at which the slot became consistent This is the earliest location from which streaming can start on this replication slot snapshot_name