Cluster management

[lovehxl]

Hello, I used cluster for cluster installation, but now I want to add or delete a node in the installed cluster. How can I implement this function

[luss]

This is a great question. There is no high level commands to do this automagically at the moment, but, we are hard at hard implementing a CLI to handle these two common situations with minimal pause to the DB's. Dropping a node is actually pretty darn east. Because the cluster is active-active (multi-master) you can simply unplug the node and then remove it from the replication sets of the nodes that are active. We'll be providing tutorials for this stuff in the near future that serve as a step be step guide for the the big red "Easy" CLI's are goin to do under the covers.

…

On Sun, Mar 3, 2024 at 9:45 PM lovehxl ***@***.***> wrote: Hello, I used cluster for cluster installation, but now I want to add or delete a node in the installed cluster. How can I implement this function — Reply to this email directly, view it on GitHub <#1>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAMWOHSSW5MMUZ7XU57EZYLYWPN4TAVCNFSM6AAAAABEEPTSCSVHI2DSMVQWIX3LMV43ERDJONRXK43TNFXW4OZWGMYTOMRYGA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[lovehxl]

Hello, I need two more questions:

1. When I copy ddl through a replica set, I cannot specify a default password when creating a user. My execution command is as follows:
   {./pgedge spock replicate ddl default "create user test5 With PASSWORD 'test123456'" postgres}
   The error is as follows:
   Syntax error at or near "test123456"
   INE 1:_ Ddl (command:='create user test5 With PASSWORD 'test123456...)
   But when I was using {./pagedge spock replicate ddl default "create user test5" postgres}, the replication set successfully replicated ddl.
   2.How can the newly created table be automatically added to the cluster for automatic synchronization.