↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_create_physical_replication_slot

Read the PG 18 manual

Creates a new physical replication slot named slot_name.

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

Signatures & examples

pg_create_physical_replication_slot ( slot_name name [, immediately_reserve boolean, temporary boolean ] ) → record ( slot_name name, lsn pg_lsn )
Creates a new physical replication slot named slot_name. The optional second parameter, when true, specifies that the LSN for this replication slot be reserved immediately; otherwise the LSN is reserved on first connection from a streaming replication client. Streaming changes from a physical slot is only possible with the streaming-replication protocol — see Section 54.4. The optional third parameter, temporary, when set to true, specifies that the slot should not be permanently stored to disk and is only meant for use by the current session. Temporary slots are also released upon any error. This function corresponds to the replication protocol command CREATE_REPLICATION_SLOT ... PHYSICAL.
Version history 12
  1. 18 → 19 changed
  2. 17 → 18 changed
  3. 16 → 17 changed
  4. 14 → 15 changed
  5. 13 → 14 changed
  6. 12 → 13 changed
  7. 11 → 12 changed
  8. 10 → 11 changed
  9. 9.6 → 10 changed
  10. 9.5 → 9.6 changed
  11. 9.4 → 9.5 changed
  12. 9.3 → 9.4 added

Definition snapshot: b7bd9cda · English manual source