Connect to AWS RDS - Githubissues

michaelsogos / pg-diff

PostgreSQL schema and data comparing tool

MIT License

166 stars 17 forks source link

Connect to AWS RDS #56

Open wakatanka opened 8 months ago

wakatanka commented 8 months ago

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 commented 3 months ago

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.