Pgrouting for PostgreSql Azure flexible server does not appear as extension to allow even when is recently supported by Azure

Luna Marinelli, Mario 6 Reputation points
2022-07-13T09:44:58.137+00:00

I have running a Postgres 13.6 Azure flexible server database.
We have tried to have pgrouting extension working in combination with postgis.

Early this year the extension was not supported by Azure to be installed in our database however has been recently released the support for Postgres 13 /14 as mentioned in the docs.
However, when I go to server parameters and look for the pgrouting extension it does not appear in the list to be enable to install in my postgres database

Could you please advise what is happening and Why we can have this working in our database even this being officially supported.

Kind regards

Azure Database for PostgreSQL
{count} vote

2 answers

Sort by: Most helpful
  1. Anurag Sharma 17,571 Reputation points
    2022-07-13T16:12:57.507+00:00

    Hi @Luna Marinelli, Mario , thanks for your patience.

    Pgrouting extension is available under azure.extensions for server parameters as shown in the below screenshot:

    220465-image.png

    I would request you to please go through below article for more details on the same:

    Introducing support for Pgrouting and PLV8 extensions in PostgreSQL Flexible Server

    Please let us know if this helps or else we can discuss further on the same.

    ----------

    If answer helps, you can mark it 'Accept Answer'

    0 comments No comments

  2. Luna Marinelli, Mario 6 Reputation points
    2022-07-15T10:59:32.54+00:00

    Thanks for your reply @AnuragSharma-MSFT but pgrouting is not listed in my extension list for my postgres 13.6 felxible server.

    221040-image.png

    Is that a problem, with my postgres server configuration. I have a look and everything is fine on my side.