About this task
It is assumed that:
- There is an existing replication setup with a replication set, primary and replica node or
nodes.
- The Netezza Replication Services software is installed on the new replica that you intend to add
to the existing setup.
Run all the commands in the following procedure from the primary Netezza Performance Server node.
Procedure
- Log in to the host pod and run the nzsql command to connect to the
SYSTEM database.
- Make sure no replicated transactions are in progress.
select * from _v_pg_transaction where replicated;
- Run the following command for each replica node:
CREATE REPLICATION NODE replset.<replicaname> ROLE
SUBORDINATE
where
<replicaname> is the node name that you set
while installing NRS on the replica.
- On the primary node, issue the following command to
determine which databases were added for replication:
nzreplanalyze -recoveryfile recoveryfile> -set replset
- Create a set of synchronized backups by issuing
the following command:
nzreplbackup -recoveryfile <recoveryfile> backup-destination>
What to do next
When you completed the procedure, initialize the replica node. Follow the instructions that
are described in Initializing a replica node.