mirror of
https://github.com/EnterpriseDB/repmgr.git
synced 2026-03-22 22:56:29 +00:00
4d4ed3bcd6
The BDR 2.x support was conceptual only and was never used in production. As BDR 2.x will be EOL'd shortly, there is no risk it will be needed.
83 lines
2.5 KiB
Plaintext
83 lines
2.5 KiB
Plaintext
-- minimal SQL tests
|
|
--
|
|
-- comprehensive tests will require a working replication cluster
|
|
-- set up using the "repmgr" binary and with "repmgrd" running
|
|
-- extension
|
|
CREATE EXTENSION repmgr;
|
|
-- tables
|
|
SELECT * FROM repmgr.nodes;
|
|
node_id | upstream_node_id | active | node_name | type | location | priority | conninfo | repluser | slot_name | config_file
|
|
---------+------------------+--------+-----------+------+----------+----------+----------+----------+-----------+-------------
|
|
(0 rows)
|
|
|
|
SELECT * FROM repmgr.events;
|
|
node_id | event | successful | event_timestamp | details
|
|
---------+-------+------------+-----------------+---------
|
|
(0 rows)
|
|
|
|
SELECT * FROM repmgr.monitoring_history;
|
|
primary_node_id | standby_node_id | last_monitor_time | last_apply_time | last_wal_primary_location | last_wal_standby_location | replication_lag | apply_lag
|
|
-----------------+-----------------+-------------------+-----------------+---------------------------+---------------------------+-----------------+-----------
|
|
(0 rows)
|
|
|
|
-- views
|
|
SELECT * FROM repmgr.replication_status;
|
|
primary_node_id | standby_node_id | standby_name | node_type | active | last_monitor_time | last_wal_primary_location | last_wal_standby_location | replication_lag | replication_time_lag | apply_lag | communication_time_lag
|
|
-----------------+-----------------+--------------+-----------+--------+-------------------+---------------------------+---------------------------+-----------------+----------------------+-----------+------------------------
|
|
(0 rows)
|
|
|
|
SELECT * FROM repmgr.show_nodes;
|
|
node_id | node_name | active | upstream_node_id | upstream_node_name | type | priority | conninfo
|
|
---------+-----------+--------+------------------+--------------------+------+----------+----------
|
|
(0 rows)
|
|
|
|
-- functions
|
|
SELECT repmgr.get_new_primary();
|
|
get_new_primary
|
|
-----------------
|
|
-1
|
|
(1 row)
|
|
|
|
SELECT repmgr.notify_follow_primary(-1);
|
|
notify_follow_primary
|
|
-----------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.notify_follow_primary(NULL);
|
|
notify_follow_primary
|
|
-----------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.reset_voting_status();
|
|
reset_voting_status
|
|
---------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.set_local_node_id(-1);
|
|
set_local_node_id
|
|
-------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.set_local_node_id(NULL);
|
|
set_local_node_id
|
|
-------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.standby_get_last_updated();
|
|
standby_get_last_updated
|
|
--------------------------
|
|
|
|
(1 row)
|
|
|
|
SELECT repmgr.standby_set_last_updated();
|
|
standby_set_last_updated
|
|
--------------------------
|
|
|
|
(1 row)
|
|
|