• PostgreSQL SingleDB:

  • Database Server VM Name: singledb
  • Software Profile: POSTGRES_10.4_OOB
  • Computer Profile: DEFAULT_OOB_SMALL_COMPUTE
  • Network Profile: DEFAULT_OOB_POSTGRESQL_NETWORK
  • password: nutanix/4u
  • SSH Public Key for Node Acces: TEXT
    • ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCiP/vQvOPLQFQJ+zIrWaaIiCT1HankwTN4HRzt/uUeoVjUnm3/1rhrnOqgE7IQHTuxYdj4K5FcZYnYkQjD6yCLpcvg7ba3hMUQ0Sda4k8dFlToeQ4AbeM5BxmXh0wWWJxZMtleD/C4EFph/y3/nI8/KekHzC2HBzJlbuf8it+wg2tg/M/TohWJBtG48Z2/oOJH6jAtktNK/SWFeGltasgH+GRGIlY6tPHN3ppSVE1vFkJtf77h6vQIrcmKb9KHj0fqL9ZVsHXeNPAQ2QDgPCjH8P0j72COiLD2GHwMVzriPJd0ktWhjq7JUXuIkNUWSi2h6/na4OKefnHh1AT+llBr [email protected]

• PostgreSQL Instance Name

  

  

• Make sure PostgreSQL Cluster configured based on configuration as stated above:

  

  

• Make sure 2 postgreSQL DB Created, one PGSQLCluster 3 Nodes and one SingleDB PGCluster

  

  

  

• Klik PG_Cluster, make sure you can access the HAPRoxy statistics (see statistic)

  

  

5️⃣ Restore app_landon and singledb from app_landon.sql and singledb.sql using pgadmin4

• app_landon —> app_landon.sql

  app_landon.sql

  • From PGAdmin4 Console, connect to PGDBCluster Virtual IP Address

  • Explore database to app_landon and select restore

    

  • Change the format to sql and select app_landon.sql

    

  • Click Restore

    

  • Please IGNORE the failed exit code:1 and proceed to next step

    

  • Explore the app_landon database - schemas - Tables - clients, right click and select view/edit data all rows

    

  • Make sure there is a single row data shown as below

    

• singledb —> singledb.sql

  singledb.sql

  • From PGAdmin4 Console, connect to SingleDB IP Address

  • Restore singleDB database with the same procedure as above with singledb.sql

  • After restore make sure to view/edit data - all rows and one record show as below:

    

6️⃣ Change ha_proxy config settings

• From ERA Console, browse to Database Server VMs - List

• Expand the PGSQLDB CLuster

• Click the Cluster_HAProxy1

  

• Go to Node and click “see description” link in connect via SSH

  

• Click copy in sample ssh command as shown below

  

• Download privateKeyFile.txt below to a folder on your computer

  privateKeyFile.txt

• open your shell console and go to that folder

• copy paste here and change the path as shown below (delete the ‘path/’ before privateKeyFile.txt

  

• execute sudo vi /etc/haproxy/haproxy.cfg

  

• Remarked all last 8 lines with ‘#’

  

• and then save it with :wq command

• and then execute command “sudo systemctl restart haproxy”