Connect to AWS RDS

[wakatanka]

Hello, i'm trying to connect to two RSD dababases to have a migration, but when i run the tool i've got this message:

no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "postgres", database "mydb", no encryption

with RDS databases i cannot modify postgres conf files.

I can connect to these databases without problems with many tools from this ip (navicat, pgadmin, and so on).

[michaelsogos]

Hi @wakatanka ,

This command tool also doesn't need to connect to pg_hba.conf neither any server file.
That error for sure comes from the driver while connecting to RedShift or RDS.
If you are able to supply me a connection to RDS to make some test I can figure out what happening.