Collecting and providing databases to Support in certain scenarios assists in faster resolution.
The steps provided in this article will assist you in collecting a specific database. ("catalog_db" in this example)
VCF Automation 9.x
SSH into one of the nodes (it does not matter which node you use):
ssh vmware-system-user@<node ip>Set the shell specified by the SHELL environment variable:
sudo su -Set KUBECONFIG and retrieve the credentials. First, get the username.
export KUBECONFIG=/etc/kubernetes/admin.confIdentify the primary pod:
export PRIMARY_POD=$(kubectl get pods -n prelude -l application=spilo,spilo-role=master -n prelude -o jsonpath='{.items[0].metadata.name}')
echo "Using primary pod: $PRIMARY_POD"Generate a dump of a specific database (for example, catalog_db):
kubectl exec $PRIMARY_POD -n prelude -c postgres -- \
pg_dump -U postgres -d catalog_db --format=custom --compress=9 \
> /tmp/catalog_db_backup_$(date +%Y%m%d_%H%M%S).dumpFor Step 5 ONLY, substitute catalog-db (or catalog_db) with one of these example VCFA databases:
| abx_db |
| approval_db |
| catalog_db |
| cluster_service_db |
| ebs_db |
| form_db |
| identity_db |
| project_db |
| provisioning_db |
| relocation_db |
| resource_manager_db |
| tango_blueprint_db |
| tenantmanager |
terraform_db |