Share via

How to enable extensions for Postgres Flexible Server without using psql client

Koh, Hong D. (MBLQ 91) 0 Reputation points
2023-03-15T07:44:27.1966667+00:00

Currently, enabling an extension for Postgres Flexible Server is done through several steps, of which we need to run the SQL command CREATE EXTENSION <EXTENSION_NAME> after server is started with a psql client.

We are thinking of automating the whole process such that we can enable an extension without having to do any additional step of spinning up a container instance or virtual machine, connect through AAD with a service principal just to run the command.

Would Azure ever support this use case of running some SQL commands on startup without having to spin up other resources?

Azure Database for PostgreSQL

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.