I have been informed that the manual is not complete for Clustering 2 Viewpoint Servers. This is my amended list of instructions from what I have been told. Can anyone please check the following and correct/change where required:-
1) Must have two VP servers
2) Must be the same VP release
3) Must be the same time and zone
4) Hosts - NOT IN THE MANUAL
Change /etc/hosts file on both systems to each know the other one
On the Teradata Viewpoint Server - 6700 Alpha
Add "10.239.193.14 VP6700CL"
On the Teradata Viewpoint Server - 6700 Omega
Add "10.239.192.142 VP6700BL"
Test each with 'ping'
Restart the network?
Run: /etc/inet.d/network boot
5) Keytab on the primary server - NOT IN THE MANUAL
Primary = VP6700BL
Secondary = VP6700CL
Generate a key pair:-
/usr/bin/ssh-keygen -t rsa
... accept the defaults
Copy the key to the alternate server:-
scp /var/lib/pgsql/.ssh/id_rsa.pubroot@vp6700CL :var/lib/pgsql/.ssh/authorized_keys
... accept the alternate server's authenticity - type 'yes' and press ENTER
Type the root password to the alternate server
Test the public key
... should connect without a password
Exit the ssh by typing 'exit'
6) From the primary VP server:-
... and answer the questions
If your hosts aren't using DNS and you don't want to use IP addresses (which is the recommendation) then I guess step 4 would be necessary.
Step 5 definitely is not necessary. The cluster setup script configures password-less ssh between the nodes for exchange of files for PostgreSQL clustering.