I get an error when I do the glue connection test. I don't know if it's a JDBC error or what kind of error it is.

Heyy, It looks like your Glue connection to the PostgreSQL RDS is failing, and the CloudWatch logs are showing errors related to logging configuration rather than connection specifics. Here’s a quick checklist to diagnose the issue:

1. Endpoint & Credentials: Double-check that the RDS endpoint, username, and password are correct.

2. Network Configuration: Ensure that your Glue job has access to the RDS instance. Verify that the security groups and VPC settings allow communication between Glue and RDS.

3. JDBC URL: Make sure the JDBC URL is correctly formatted for PostgreSQL. It should look something like jdbc:postgresql://<endpoint>:<port>/<database>.

4. Timeout Issues: Check if there are any network issues or firewall rules that might be causing a timeout.

5. CloudWatch Errors: The errors in CloudWatch (Unrecognized format specifier) are related to logging configuration and might not be the root cause of your connection issue. Ensure your logging configuration is correct and compatible with your Glue setup.

check this for reference dox https://github.com/aws-samples/aws-glue-samples https://docs.aws.amazon.com/glue/latest/dg/what-is-glue.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html

I am getting the exact same error when trying to connect to RDS PostgreSQL from Glue.

Go to cloudwatch logs, you will see the output logs in /aws-glue/testconnection/output/<connection_name>. The error logs you shared show that glue connection was able to connect to the db.

I saw that same error and went to output logs and turned out this was the issue https://repost.aws/knowledge-center/glue-resolve-connection-error. Changing the parameter password_encryption to encrypt with md5 worked.