Trying to deploy postgresql database to Azure from pgadmin and get SSL Certificate_Verify_Failed error
I'm trying to deploy my postgresql v16 database to Azure via pgadmin v4.83. I start the Register -> Deploy Cloud Instance wizard and enter my tenantid and then press the "Click here to Authenticate yourself to Microsoft Azure" button. After a few seconds it returns with the following error:
I tried downloading the SSL public certificate from Azure and setting the server parameters in pgadmin as below but still had the error. Please help.
Azure Postgresql Networking Instructions for cert download:
The learn more link: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-tls-ssl
PgAdmin server Parameters:
Thanks for all your help. I managed to get a solution with the help of @PratikLad who pointed me in the right direction. In case it helps anyone else, all I did was install the Azure Cli SDK and then I was able to run the wizard using the Azure Cli option.
- How to enforce uniqueness across two columns within the scope of a third?
- pg_dump and pg_restore across different major versions of PostgreSQL
- hasMany called with something that's not an instance of Sequelize.Model
- PostgreSQL unterminated quoted identifier
- Multi-row insert with pg-promise
- SQL getting the data by timestamp interval
- Insert inserted id to another table
- docker compose psql: error: FATAL: role "postgres" does not exist
- Counting business hours between timestamps
- "row is too big (...) maximum size 8160" when running "grant connect on database"
- How to cast type bytea to double precision
- Transform timestamp to local time for a given timezone during 'COPY .. TO ..'
- Better way than multiple SELECT statements?
- How to call a stored procedure(PostgreSQL) with Spring JPA?
- Why does 'now()'::timestamp return the current timestamp in PostgreSQL?
- Get TZ abbrev for given timestamp and TZ name
- Avoid checks for each row, replace query by function?
- Get average for "last month" only
- Select values in given sequential numbers
- Sum time differences across multiple timezones in PostgreSQL
- Unexpected results from SQL query with BETWEEN timestamps
- Disadvantages of using date_trunc
- Will changing column from timestamp to timestamptz lock the table?
- Subtract hours from the now() function
- Postgresql 8.4 update query syntax error in plpgsql function
- Return rows based on timestamp respective to their time zone
- time zone confusion in relational databases
- Default timestamp format and fractional seconds
- SQL in postgres convert datetime for recurring event to future datetime
- Query on a time range ignoring the date of timestamps