pg_replication_slots
pg_replication_slots - Logical replication of tables in schema in PostgreSQL 15 slot jago 888
pg_replication_slots - Logical replication of tables in schema in PostgreSQL 15 slot jago 888
Regular price
VND2704.40 IDR
Regular price
Sale price
VND2704.40 IDR
Unit price
per
Couldn't load pickup availability
pg_replication_slots: Logical replication of tables in schema in PostgreSQL 15. Inside logical replication in PostgreSQL: How it works. Using PostgreSQL Replication Slots.
Logical replication of tables in schema in PostgreSQL 15
postgres=# d pg_replication_slots View 'pg_catalog.pg_replication_slots' Column | Type | Collation | Nullable | Default .
Inside logical replication in PostgreSQL: How it works
postgres=# SELECT * FROM pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn .
Using PostgreSQL Replication Slots
postgres=# SELECT redo_lsn, slot_name,restart_lsn, round((redo_lsn-restart_lsn) / 1024 / 1024 / 1024, 2) AS GB_behind FROM pg_control_checkpoint(), pg_replication_slots; redo_lsn | slot_name | restart_lsn | gb_behind .