Docs

Connection Issues

Troubleshooting database connection problems.

Common Connection Errors

Connection refused

text
Error: connect ECONNREFUSED 10.0.0.1:5432
  • -PostgreSQL is not running on the specified host/port
  • -Firewall is blocking the connection
  • -Security group (AWS/GCP/Azure) does not allow inbound on port 5432
  • -PostgreSQL is listening only on localhost (check listen_addresses in postgresql.conf)

Authentication failed

text
FATAL: password authentication failed for user "dbabrain_monitor"
  • -Incorrect password
  • -User does not exist (run CREATE USER first)
  • -pg_hba.conf does not allow the connection method from the source IP

SSL required

text
FATAL: no pg_hba.conf entry for host "x.x.x.x", user "dbabrain_monitor", database "mydb", no encryption

Your PostgreSQL requires SSL. Set SSL Mode to "require" in dbaBrain connection settings.

Connection timeout

text
Error: Connection timed out after 30000ms
  • -Network path is blocked (check traceroute)
  • -DNS resolution failing (try IP address directly)
  • -VPN required but not connected
  • -Database is behind a NAT/private network (use dbaBrain agent instead)