Connection issue from Lambda to RDS PostgreSQL 15

Question

In RDS PotgreSQL 12, I can connect to DB using psycopg2 from local and also from Lambda function.
But when I upgrade to RDS PotgreSQL 15, I cannot connect to DB from Lambda anymore (I still can connect from local though).
The error that Lambda gives is:

FATAL:  no pg_hba.conf entry for host ***, user ***, database ***, no encryption

This is how I connect:

import psycopg2
connection_psql = psycopg2.connect(user=***
                                    , password=***
                                    , port="5432"
                                    , database=***
                                    , host=***)

Perhaps you need to enable ssl in the connection: [How to connect to a remote PostgreSQL database through SSL with Python](https://stackoverflow.com/a/28228609/174777) — John Rotenstein, Jun 22 '23 at 23:25

score 2 · Accepted Answer · answered Jun 23 '23 at 00:44

2

The issue was that in Lambda I was using a version of psycopg2 without ssl (from this repo). Apparently in recent versions of Postgres, ssl is required. The same repo has versions with ssl as well. Using those resolved the issue.

answered Jun 23 '23 at 00:44

LoMaPh

1,476
2
20
33

Connection issue from Lambda to RDS PostgreSQL 15

1 Answers1