PostgreSQL replication

• https://www.postgresql.org/docs/current/runtime-config-replication.html

postgres=# \du
                                      List of roles
   Role name    |                         Attributes                         | Member of
----------------+------------------------------------------------------------+-----------
 YOUR_USER      | Create DB                                                  | {}
 postgres       | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Related

• START_REPLICATION SLOT
• Amazon RDS Read Replicas
• select * from pg_replication_slots;
• \du+
• CREATE SUBSCRIPTION
• CREATE ROLE
• Terraform resource: postgresql role

See also

• PostgreSQL replication, Amazon RDS Read Replicas, WAL, pg_replication_slots, START_REPLICATION, CREATE SUBSCRIPTION
• Replication, PostgreSQL replication