Logical and Multi-Active PostgreSQL Node Configuration Commands
Commands in the spock module include:
| Command | Description |
|---|---|
| health-check | Check to see if the PostgreSQL instance is accepting connections. |
| metrics-check | Retrieve advanced database and operating system metrics. |
| node-add-interface | Add a new node interface. |
| node-alter-location | Set location details for a spock node. |
| node-create | Define a node for spock. |
| node-drop | Remove a spock node. |
| node-drop-interface | Delete a node interface. |
| node-list | Display a table listing the current nodes. |
| replicate-ddl | Enable DDL replication. |
| repset-add-partition | Add a partition to a replication set. |
| repset-add-seq | Add a sequence to a replication set. |
| repset-add-table | Add table(s) to replication set. |
| repset-alter | Modify a replication set. |
| repset-create | Define a replication set. |
| repset-drop | Remove a replication set. |
| repset-list-tables | List tables in replication sets. |
| repset-remove-partition | Remove a partition from the replication set that the parent table is a part of. |
| repset-remove-seq | Remove a sequence from a replication set. |
| repset-remove-table | Remove table from replication set. |
| sequence-convert | Convert sequence(s) to snowflake sequences. |
| set-readonly | Turn PostgreSQL read-only mode 'on' or 'off'. |
| sub-add-repset | Add a replication set to a subscription. |
| sub-alter-interface | Modify an interface to a subscription. |
| sub-create | Create a subscription. |
| sub-disable | Put a subscription on hold and disconnect from provider. |
| sub-drop | Delete a subscription. |
| sub-enable | Make a subscription live. |
| sub-remove-repset | Drop a replication set from a subscription. |
| sub-resync-table | Resynchronize a table. |
| sub-show-status | Display the status of the subcription. |
| sub-show-table | Show subscription tables. |
| sub-wait-for-sync | Pause until the subscription is synchronized. |
| table-wait-for-sync | Pause until a table finishes synchronizing. |