- Create a backup of the corrupted file before making any changes on the node with the corrupted cert:
mv /storage/db/root.crt /storage/db/root.crt.BAK
- Once complete use SCP to move a copy of an un-corrupted certificate from one of the other nodes to the effected node and set the proper permissions and ownership. Run the following commands on the node with the corrupted certificate
scp root@<fqdn-of-good-node>:/storage/db/root.crt /storage/db/root.crt
chown postgres:users /storage/db/root.crt
chmod 644 /storage/db/root.crt
- Restart the Postgres service so it can pick up the correct certificate
service vpostgres restart
- Review the vcac-config.log for an entry similar to the one below confirming that the database node in question is repairing:
current node is repairing ...Already performing a failover or repair operation, repairing (true), clusterDataOperator repairing (true)!
- Confirm the errors are now gone within the cluster tab of the VAMI