Connect to Azure PostgreSQL using Azure Data Studio with SSL enabled
When i try to connect to Azure PostgreSQL with SSL enabled using Azure Data Studio , with SSL Mode=Verfiy-full, i get below error
root certificate file "C:\Users\mstechie\AppData\Roaming/postgresql/root.crt" does not exist Either provide the file or change sslmode to disable server certificate verification.
i dont want to disable SSL mode , but want to use SSL.
Please help
In case of database being Azure PostgreSQL PaaS and if we choose SSL mode = disable , it throws an error saying SSL required , since SSL is enabled by default on server. Of course we can disable it , but not recommended.
if we choose the SSL mode = Allow ,(instead of Verify-full) , it does not ask for certificate.
if we choose SSL mode = Require or SSL mode = Prefer , then also it does not ask for certificate and connects properly.
if we choose SSL mode = Verify-CA or SSL mode = Verify-full , then it requires certificate and we have to give the path of the certificate as shown below
- psql: /usr/pgsql-11/lib/libpq.so.5: no version information available
- How to fix 'type abstime does not exist' error when upgrading PostgreSQL from 11.20 to 12.15?
- How to reload PostgreSQL configuration
- PostgreSQL 11 Shared Memory Error: could not open shared memory segment "/PostgreSQL.XXXXXXXX": No such file or directory
- Test HASH function for Postgres table partitioning
- What happens with the old primary after a "pg_ctl promote" on a replica?
- postgresql 11 - create database with ICU locale
- Is there a way to update 2 values each time calculating data on each row?
- CREATE DATABASE WITH TEMPLATE Postgres 11 -> 15 Performance
- searching in multiple random named sub keys in json object in postgres
- In PostgreSQL , can certificate authentication and basic authentication(username/password authentication) co-exist at one time?
- Function not found in PostgreSQL
- I am encountering an issue when running a PostgreSQL query using a script
- Postgres 11 not enforcing foreign key constraint?
- Fetch limit in Postgres cursor
- FATAL: password authentication failed for user "postgres" (postgresql 11 with pgAdmin 4)
- JPA Model Class for field TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP in Postgres?
- How to get cosine distance between two vectors in postgres?
- Is there a way to make postgresql listen on different ports?
- In Geoserver 2.15.1 Postgis datastore not visible even i created postgis datastore previously
- How to access Azure AD integrated Postgres DB using Spring Data JPA?
- How to pass an array of tuples as parameter for a bulk UPSERT?
- Why is this syntax invalid in postgresql?
- Bulk Inserts/Updates Are Slow Using On Conflict with JSONB
- How can I filter differences of datasets in a table
- Convert from JS timestamp to Postgresql Timestamp with time zone
- How to return result set from PostgreSQL stored procedure?
- Unable to locate package postgresql-server-dev-11
- Win 10 Postgresql 11 database cluster initialisation failed
- How to send a NULL argument through a DirectFunctionCall?