logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

RESUBSCRIBE NODE - Change the provider of a replication set

Description

The RESUBSCRIBE NODE command will change the provider used to receive data from for all of the replica‐ tion sets originating on a given node. If a subscriber node is receiving a number of replication sets with a particular node as an origin then the RESUBSCRIBE NODE command will change the provider node used by that subscriber node for all of the replication sets originating on the given origin. ORIGIN = ival ID of the set origin for all subscriptions to change RECEIVER = ival Node ID of the subscriber PROVIDER = ival Node ID of the provider

Example

RESUBSCRIBE NODE ( ORIGIN = 1, PROVIDER = 2, RECEIVER = 3 );

Locking Behaviour

None

Name

RESUBSCRIBE NODE - Change the provider of a replication set

Slonik Event Confirmation Behaviour

Slonik waits for the command submitted to the previous event node to be confirmed on the specified event node before submitting this command.

Synopsis

RESUBSCRIBENODE(options);

Version Information

This command was introduced in Slony-I 2.2 19 September 2024 SLONIKRESUBSCRIBENODE(7)

See Also