Enable managed identity for postgres vectore store with pgvector

[asindarov]

Hi,

How can I use Azure managed Identity to connect to postgres pg vector when doing the embedding ? I have the following chunk of code:

            PostgresConfig postgresConfig = new()
            {
                ConnectionString = configuration.GetConnectionString("DefaultConnection")
            };
            
            var memory = new KernelMemoryBuilder()
                .WithAzureOpenAITextGeneration(chatConfig)
                .WithAzureOpenAITextEmbeddingGeneration(embeddingConfig)
                .WithAzureBlobsDocumentStorage(azureBlobsConfig)
                .WithAzureAIDocIntel(azureAIDocIntelConfig)
                .WithPostgresMemoryDb(postgresConfig)
                .Build<MemoryServerless>();

I was able to use managed identity ith ef core but it seems semantic kernel postgres configuration does not support managed identity out of the box, or am I wrong there ? Please let me know if there is any better way of enabling managed identity without rolling my own IMemoryStore implementation.

Thanks