DB postgresql Backup

shell
shell.set --enabled true
chsh -s /bin/bash root
chsh -s /bin/appliancesh root
chmod 700 /tmp/backup_lin.py
chmod 700 /tmp/restore_lin.py

python /tmp/backup_lin.py -f /tmp/backup_VCDB.bak

python /tmp/restore_lin.py -f /tmp/backup_VCDB.bak

service-control --stop vmware-vpxd
service-control --stop vmware-content-library
python /tmp/restore_lin.py -f /tmp/backup_VCDB.bak
ls

service-control --status vmware-vpxd
service-control --status vmware-content-library


service-control --start vmware-vpxd
service-control --start vmware-content-library

VCSA Upgrade

/dev/cdrom /mnt/cdrom
software-packages stage --iso
software-packages list --staged
software-packages install --staged

File Zilla Server

ftp://10.10.xx.xx:21/c$/TFTP
vcsabackupuser
Passwxx

shell.set --enabled true

Access the postgres database by running this command:

/opt/vmware/vpostgres/current/bin/psql -U postgres -d VCDB

Re-index the affected table by running these commands:

Note: Select the table to be re-indexed from the postgres log error.

reindex index pk_fle_snap_disk_unit;

reindex index vpx_vm_fle_snap_disk_unit_m1;

Start the vmware-vpxd service by running this command:

service-control --start vmware-vpxd