Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
515 questions
How to enable extensions for Postgres Flexible Server without using psql client
Koh, Hong D. (MBLQ 91)
0
Reputation points
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?
{count} votes
-
ShaktiSingh-MSFT 5,871 Reputation points Microsoft Employee2023-03-16T06:20:26.6433333+00:00 Hi @Koh, Hong D. (MBLQ 91,
Welcome to Microsoft Q&A forum.
Regarding the question, I am checking on the possibility and will update you the status.
Thanks for the patience.
Sign in to comment
Hi @Koh, Hong D. (MBLQ 91,
Thanks for your patience.
Could you please share with us the steps you are following to enable extension?
Hi @Koh, Hong D. (MBLQ 91,
We have not heard back from you.
Could you please share the steps so that we can help. Thanks