syn-postgres-replication

name	syn-postgres-replication
description	PostgreSQL operations skill. Primary capability: streaming replication between a primary and standby. It sits among neighboring PostgreSQL areas — related skills cover logical backup and point-in-time restore and index design and query plan optimization — so confirm the task is about streaming replication between a primary and standby specifically.

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.