Skip to content

Latest commit

 

History

History
36 lines (33 loc) · 2.75 KB

SPOCK.md

File metadata and controls

36 lines (33 loc) · 2.75 KB

CLI for Spock Logical and Multi-Master PostgreSQL node configuration

Synopsis

./pgedge spock <command> [parameters] [options] 

node-create - Name this spock node
node-drop - Drop this spock node from the cluster
node-alter-location - Set location details for spock node
node-list - Display node table
node-add-interface - Add a new node interface
node-drop-interface - Delete a node interface
repset-create - Define a replication set
repset-alter - Modify a replication set
repset-drop - Drop a replication set
repset-add-table - Add table(s) to a replication set
repset-remove-table - remove table(s) from a replication set
repset-add-partition - Add partition(s) to a replication set
repset-remove-partition - remove partition(s) from a replication set
repset-list-tables - List the tables in a replication set
sub-create - Create a subscription
sub-drop - Remove a subscription
sub-alter-interface Modify an interface to a subscription
sub-enable - Enable a subscription
sub-disable - Disable a subscription
sub-add-repset - Add replication set to a subscription
sub-show-status - Display the status of the subcription
sub-show-table - Display subscription table(s)
sub-resync-table - Resynchronize a table
sub-wait-for-sync - Pause until subscription is synchronized
table-wait-for-sync - Pause until a table finishes synchronizing
replicate-ddl - Replicate a DDL statement
sequence-convert - Convert sequences to snowflake
health-check - Check if PG is accepting connections
metrics-check - Retrieve advanced DB & OS metrics