commands.sh

pg_recvlogical

all

Control PostgreSQL logical decoding streams.

More info →

Options (5)

-d, --dbnameboolean

Create a new logical replication slot

Example: pg_recvlogical {{[-d|--dbname]}} {{dbname}} {{[-S|--slot]}} {{slot_name}} --create-slot
-S, --slotboolean

Create a new logical replication slot

Example: pg_recvlogical {{[-d|--dbname]}} {{dbname}} {{[-S|--slot]}} {{slot_name}} --create-slot
-f, --fileboolean

Start streaming changes from a logical replication slot to a file

Example: pg_recvlogical {{[-d|--dbname]}} {{dbname}} {{[-S|--slot]}} {{slot_name}} --start {{[-f|--file]}} {{filename}}
-t, --enable-two-phaseboolean

Create a slot with two-phase commit enabled

Example: pg_recvlogical {{[-d|--dbname]}} {{dbname}} {{[-S|--slot]}} {{slot_name}} --create-slot {{[-t|--enable-two-phase]}}
--helpboolean

Display help

Example: pg_recvlogical {{[-?|--help]}}

Examples (5)

Create a new logical replication slot

pg_recvlogical [-d|--dbname] dbname [-S|--slot] slot_name --create-slot

Start streaming changes from a logical replication slot to a file

pg_recvlogical [-d|--dbname] dbname [-S|--slot] slot_name --start [-f|--file] filename

Drop a logical replication slot

pg_recvlogical [-d|--dbname] dbname [-S|--slot] slot_name --drop-slot

Create a slot with two-phase commit enabled

pg_recvlogical [-d|--dbname] dbname [-S|--slot] slot_name --create-slot [-t|--enable-two-phase]

Display help

pg_recvlogical [-?|--help]
made by @shridhargupta | data from tldr-pages