33 lines
1.5 KiB
Plaintext
33 lines
1.5 KiB
Plaintext
SELECT * FROM spock.node;
|
|
output
|
|
node_id | node_name | location | country | info
|
|
---------+-----------+----------+---------+------
|
|
30830 | node1 | | |
|
|
|
|
|
|
SELECT * FROM spock.node_interface;
|
|
output
|
|
|
|
if_id | if_name | if_nodeid | if_dsn
|
|
------------+---------+-----------+------------------------------------------------------------------------------
|
|
2198842153 | node3 | 57454 | host=172.16.10.178 port=5444 dbname=postgres user=postgres password=postgres
|
|
2256866226 | node1 | 30830 | host=172.16.10.123 port=5444 dbname=postgres user=postgres password=postgres
|
|
(2 rows)
|
|
|
|
SELECT * FROM spock.sub_show_status();
|
|
output
|
|
| Field | Value |
|
|
| --------------------- | ------------------------------------ |
|
|
| **Subscription Name** | `sub_node2_from_node1` |
|
|
| **Status** | `replicating` |
|
|
| **Provider Node** | `node1` |
|
|
| **Provider Host** | `172.16.10.123` |
|
|
| **Provider Port** | `5444` |
|
|
| **Database** | `postgres` |
|
|
| **User** | `postgres` |
|
|
| **Password** | `postgres` |
|
|
| **Slot Name** | `spk_postgres_node1_sub_nodedd485a4` |
|
|
| **Replication Sets** | `{default}` |
|
|
| **Forward Origins** | empty |
|
|
|