1
/
of
1
Situs Slot
postgresql pg_replication_slots - PostgreSQL: Documentation: 17: 29.2. Subscription new 888 slot
postgresql pg_replication_slots - PostgreSQL: Documentation: 17: 29.2. Subscription new 888 slot
Regular price
VND4336.11 IDR
Regular price
VND100.000,00 IDR
Sale price
VND4336.11 IDR
Unit price
/
per
Couldn't load pickup availability
postgresql pg_replication_slots: PostgreSQL: Documentation: 17: 29.2. Subscription. PostgreSQL Replication Monitoring | Scaling PostgreSQL. Using PostgreSQL Replication Slots.
Share
PostgreSQL: Documentation: 17: 29.2. Subscription
Identify the replication slot created by AWS DMS using the following command: SELECT * FROM pg_replication_slots;.
PostgreSQL Replication Monitoring | Scaling PostgreSQL
Learn how to monitor native PostgreSQL replication using the system views and functions PostgreSQL provides. Specific queries are also provided.
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 .
