Skip to main content

Database Troubleshooting

Connection Issues​

Connection Refused​

Firewall blocking access.

Solution: Add your IP to firewall rules.

Authentication Failed​

Wrong credentials.

Solution: Fetch credentials via API, verify username/password.

Performance Issues​

Slow Queries​

Solutions:

  1. Add indexes
  2. Optimize queries
  3. Check EXPLAIN ANALYZE
  4. Consider read replicas

Connection Pool Exhausted​

Too many connections.

Solution: Increase max_connections or use connection pooling.

Backup/Restore Issues​

Restore Failed​

Snapshot corrupted or incompatible.

Solution: Try older snapshot, contact support.