Restore Troubleshooting

PostgreSQL Restore Issues

Problem: Connection timeout during restore Solution: Increase timeout by setting environment variable:

RESTORE_TIMEOUT=7200 ./pgsql-restore.sh backup.sql.gz

Problem: "Permission denied" errors Solution: Ensure the script is using the postgres superuser (check output for "Using superuser: postgres")

Elasticsearch Restore Issues:

Problem: Port-forward connection fails Solution: Check if Elasticsearch service is running:

kubectl get svc gv-es-http
kubectl get pods -l app=elasticsearch

Problem: Cluster health shows "yellow" or "red" Solution: Wait for cluster to stabilize, check replica settings:

curl -u elastic:<password> http://localhost:9200/_cluster/health?wait_for_status=green&timeout=300s

Consul Restore Issues:

Problem: HTTP 500 error during restore Solution: Verify Consul service is healthy:

kubectl get pods -l app=consul
kubectl logs <consul-pod>

Problem: Restore completes but data is missing Solution: Verify snapshot file integrity, try creating a fresh backup and restore again