Strapi project, Switching DB between 2 cloud providers, both postgresql

Questions and Answers Database-SQL
1

Hello, I was wondering is it possible to switch DB after initial config? Both DBs are PostgreSQL v11, one is on Azure, other GCP.
I have dumped out the content of the Azure DB and restored the data to the GCP DB. So the data should be the same. The idea is to make the backend switchable from either cloud provider.

2

Ive managed to update the config/database.js by commenting out the the Azure DB connection and switching it out with the GCP one… However SSL must be disabled for the GCP DB.

Is there a way to get SSL working with the GCP DB? Thanks