postgresql - How to limit WAL size when using Postgres Logical ...
postgres=# select * from pg_replication_slots; -[ RECORD 1 . slot_name | main_slot plugin | slot_type | physical datoid | database | active | t active_pid | 16297 xmin | catalog_xmin | restart_lsn | 2/F4000108 confirmed_flush_lsn | -[ RECORD 2 .
Giới thiệu về chức năng Replication(đồng bộ dữ liệu) của ...
... câu lệnh SQL sau để kiểm tra: sql Copy. SELECT slot_name, plugin, slot_type FROM pg_replication_slots;. sql Copy. SELECT * FROM pg_stat_replication;. sql Copy.
Best practices for Amazon RDS PostgreSQL replication | AWS Database ...
postgres=# SELECT slot_name, slot_type, active FROM pg_replication_slots; slot_name | slot_type | active . slot1 | physical | f (1 row).