Post Upgrade Steps for enabling Vector Extension

Enable Vector Extension for Azure Database PostgreSQL - Flexible Server

By default, the Vector extension is enabled for Postgres. However, it is not enabled with Azure Postgres SQL Database. If this extension is not enabled, tables depending on this extension will not be created. Due to these missing tables in the Azure SQL Database, an exception occurs while deleting the semantic model. You will not be able to use the semantic model to create chat sessions.

To enable the Vector extension in Azure PostgreSQL:

1. Go to Azure Database for PostgreSQL - Flexible Server.

2. Select the Server that you want to upgrade.

3. Navigate to Server parameters.

4. Search for azure.extensions

5. Select the Vector option.

6. Save this configuration.

After enabling the extension, perform the following steps.

• Connect to Postgres SQL via terminal and execute the following command:

  CREATE EXTENSION IF NOT EXISTS vector;

  For example, ./pgconnect.sh 5432 postgres <XYZ.postgres.database.azure.com> delverepo;