Set up logical replication to Aiven for PostgreSQL

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

Enable hot_standby_feedback = on · Use a physical replication slot to replicate from upstream to the standby · Run pg_log_standby_snapshot() on

start replication slot postgres Replication slots were introduced with PostgreSQL and are designed to ensure that any standby connected to the primary using a replication slot will always

start slot Creating a Replication Slot To create a physical replication slot, you use the pg_create_physical_replication_slot function Here's how: SELECT * FROM