Getting the same issue while pulling data from RDS using glue 2.0 but working fine in glue 3, 4
So below is workaround for glue 2
First downloaded the jar file of postgres from https://jdbc.postgresql.org/download/
After Adding below parameter it is working fine
--extra-jars -> path/to/s3/postgresql-42.6.2.jar
--user-jars-first -> true