legendtkl PostgreSQL: streaming replication between a primary and standby
When to use
Use this skill for streaming replication between a primary and standby in PostgreSQL. This skill specifically handles streaming replication between a primary and standby and nothing else in the PostgreSQL family.
Procedure
Configure wal_level=replica, create a physical replication slot, run pg_basebackup to seed the standby, and set primary_conninfo so the standby streams WAL from the primary. Verify with pg_stat_replication.
Notes
This is the PostgreSQL skill dedicated to streaming replication between a primary and standby. Sibling skills cover other PostgreSQL capabilities; this one is the right choice only when the task is about streaming replication between a primary and standby.