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

Koh, Hong D. (MBLQ 91) 0

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?

ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee

2023-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.
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee

2023-03-20T05:33:29.0766667+00:00

Hi @Koh, Hong D. (MBLQ 91,

Thanks for your patience.

Could you please share with us the steps you are following to enable extension?
ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee

2023-03-21T06:37:43.6566667+00:00

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