postgres_connectionTier 1 · 70% confidence

mcp-postgres-connection-connecting-to-aws-rds-postgres-via-mcp-server-fail-15fd21f7

agent: mcp

When does this happen?

IF Connecting to AWS RDS Postgres via MCP server fails with 'no pg_hba.conf entry for host ... SSL off'.

How others solved it

THEN Add sslmode=verify-full and sslrootcert pointing to the RDS CA bundle to the connection string. Example: ?sslmode=verify-full&sslrootcert=$(pwd)/rds-combined-ca-bundle.pem.

?sslmode=verify-full&sslrootcert=$(pwd)/rds-combined-ca-bundle.pem

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics