search

michaelsogos / pg-diff

PostgreSQL schema and data comparing tool
MIT License
158 stars 15 forks source link

SSL options #52

Open shayneoneill opened 9 months ago

shayneoneill commented 9 months ago

So I'm having a problem with this. While migrating data from Azure postgres to AWS RDS, I've discovered both services now require SSL enabled. I dont seem to have a way to tell the script to do that and it returns complaining about the lack of SSL in our connection.

I've worked around it by temporarily disabling SSL on both sides (Easy on Azure, and in typical fashion a little trickier in AWS [create a custom parameter group, set rds.ssl_enable [or whatever its called again] to 0 , then apply it, then reboot]) but its a pretty shady way of doing things. Thankfully I've been able to re-enable afterwards to correct the temporary lowering of security, but its the kind of move that'd give most security consultants an aneurism.

Any chance of letting us set those settings in the config? I figure this'll be a fairly common problem.

michaelsogos commented 4 weeks ago

Hi @shayneoneill ,

Of course, let me implement it; give me some days and it should be done.