> pid | backend_start | wait_event_type | wait_event | backend_type > -------+-------------------------------+-----------------+---------------------+--------------> 21237 | 2021-06-29 21:27:51.806746+00 | LWLock | replication_slot_io | checkpointer> (1 row)
> dbname=# select pg_current_wal_lsn();> pg_current_wal_lsn> --------------------> 2B0/75042DE0> dbname=# select * from pg_replication_slots ;> slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn> ---------------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+--------------+---------------------> repmgr_slot_5 | | physical | | | f | t | 4285 | | | 2B0/75042DE0 |> repmgr_slot_1 | | physical | | | f | t | 3402 | | | 2B0/75042DE0 |
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных