- Mais recentes
- Mais votos
- Mais comentários
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:
-
Endpoint & Credentials: Double-check that the RDS endpoint, username, and password are correct.
-
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.
-
JDBC URL: Make sure the JDBC URL is correctly formatted for PostgreSQL. It should look something like jdbc:postgresql://<endpoint>:<port>/<database>.
-
Timeout Issues: Check if there are any network issues or firewall rules that might be causing a timeout.
-
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.
Conteúdo relevante
AWS OFICIALAtualizada há 7 meses- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 10 meses
Thank you for your answer. But I haven't solved it yet.
Accessed via pgAdmin4 from outside. DB access information is correct.
How do I check if security group and VPC settings allow communication between Glue and RDS?
The connection URL is automatically entered based on the RDS instance I selected.
Public access is also allowed for RDS, and it is a VPC, AZ such as the blue connection.
I don't know the cause of the error.