Unable to log into the Postgres db …
RDS PostgreSQL instance is reachable at the network level, but PostgreSQL itself is crashing during the connection handshake.
Here is the reason:
I have tried to connect to the instance
aws rds describe-db-parameters
–db-parameter-group-name default.postgres17
–query “Parameters[?ParameterName==‘rds.force_ssl’]”
{
“ParameterName”: “rds.force_ssl”,
“ParameterValue”: “1”,
“Description”: “Force SSL connections.”,
“Source”: “system”,
“ApplyType”: “dynamic”,
“DataType”: “boolean”,
“AllowedValues”: “0,1”,
“IsModifiable”: true,
“ApplyMethod”: “pending-reboot”
}