trying to connect to Azure PostgreSQL with SSL enabled using Azure Data Studio or pgAdmin4 with SSL Mode=Verfiy-full, i get below error
root certificate file does not exist Either provide the file or change sslmode to disable server certificate verification and went to use SSL. enter image description here
Suggest me the configuration.
Azure PostgreSQL using Azure Data Studio / pgAdmin4 with SSL enabled
CodePudding user response：
In both the cases Azure Data Studio / PgAdmin4 it will through error because, Azure PostgreSQL server enable SSL default on server Solution and basic steps to avoid the errors while connecting Postgres database via pgAdmin4 or Data Studio.
Keep SSL mode = Allow, no more fields to be filed.
If we are using Azure AD login, make sure we are enabling Azure AD admin on portal
Allow Internal Ip address into firewall and allow inbound traffic with 5432 default port.
