pg-diff icon indicating copy to clipboard operation
pg-diff copied to clipboard

Published 20 hours ago • verified publisher icon michaelsogos

Connect to AWS RDS

Open wakatanka opened this issue 1 year ago • 1 comments

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).

wakatanka avatar Jan 03 '24 08:01 wakatanka

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.

michaelsogos avatar Jun 06 '24 12:06 michaelsogos