Can't add PostgreSQL credentials to Azure Migrate appliance, they don't seem to be available.

Question

Can't add PostgreSQL credentials to Azure Migrate appliance, they don't seem to be available.

Andre Matos 20 Microsoft Employee

Can't add PostgreSQL credentials to Azure Migrate appliance, they don't seem to be available. I can only see Domain, Linux, Windows, SQL Server and MySQL Server.

2026-04-13 15 23 39

Its clear on the documentation that it should be available PostgreSQL.

I clearly have a PostgreSQL database on one of the VMs, and one of the recommendation is to provide the credentials.

2026-04-13 18 45 22

Thank you!

Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-13T19:03:22.1333333+00:00

Hello Andre Matos,

Thank you for reaching out to the Microsoft Q&A forum.

When investigated we see that although the documentation mentions PostgreSQL discovery, the current Azure Migrate appliance does not support adding PostgreSQL credentials explicitly. Only Domain, Linux/Windows (OS-level), SQL Server, and MySQL credential types are available in the appliance UI.

Because PostgreSQL credentials cannot be added directly:

Azure Migrate performs limited PostgreSQL discovery

Object‑level assessment (schemas, objects, permissions) cannot be fully evaluated

Recommendations are therefore VM-level and marked “Ready with conditions”

Warnings appear for insufficient permissions, even when PostgreSQL exists on the VM

For PostgreSQL, Azure Migrate currently relies on OS-level discovery, not database credential–based discovery (unlike SQL Server or MySQL). This is a platform limitation, not a configuration issue.

For detailed PostgreSQL migration readiness (object-level analysis), Microsoft recommends using Azure Database Migration Service (DMS) or manual PostgreSQL assessment scripts instead of Azure Migrate appliance credentials.

Let us know if you have further queries?

References:

Assessing On-Premises PostgreSQL for Migration to Azure Flexible Server - Azure Migrate | Microsoft Learn

PostgreSQL Assessment Rules to Detect Blockers and Compatibility Issues - Azure Migrate | Microsoft Learn

Review PostgreSQL assessment properties - Azure Migrate | Microsoft Learn

Azure Migrate appliance - Azure Migrate | Microsoft Learn
Andre Matos 20 Reputation points Microsoft Employee

2026-04-14T08:26:52.25+00:00

Hi @Siva shunmugam Nadessin , good morning!

Unfortunately. I can't relate your answer with my challenge. Its clearly stated in multiple documents that there is a need to provide PostgreSQL credentials for Azure Migrate appliance to further evaluate the database.

Here: https://learn.microsoft.com/en-us/azure/migrate/tutorial-review-postgresql-report?view=migrate#review-readiness

"If PostgreSQL credentials aren't provided or if the Azure Migrate appliance can't connect to the PostgreSQL instance, SKU recommendations are based on virtual machine-level configuration. In this case, the readiness status is marked as Ready with Conditions. To validate all assessment rules—including extensions, collations, data types, and other database-specific configurations—and to ensure optimal SKU sizing, provide PostgreSQL credentials with sufficient permissions."

Here: https://learn.microsoft.com/en-us/previous-versions/azure/migrate/how-to-discover-applications?view=migrate#add-credentials-and-initiate-discovery

Here: https://learn.microsoft.com/en-us/previous-versions/azure/migrate/how-to-discover-applications?view=migrate#discover-postgresql-instances-and-databases-preview

"If you haven't provided Windows or Linux authentication and PostgreSQL instance authentication credentials on the appliance configuration manager, then add the credentials so that the appliance can use them to connect to respective PostgreSQL instances."

Could you please double check?

Thank you,

André
Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-15T02:09:26.75+00:00
Hello Andre Matos,

When investigating further Azure Migrate requires PostgreSQL database credentials for in‑depth database discovery and accurate assessment.

If PostgreSQL credentials are not provided, Azure Migrate:

Assesses the workload only at the VM level

Marks readiness as “Ready with Conditions”

Cannot validate database‑specific rules (extensions, collations, data types, version compatibility)

Generates generic SKU recommendations, which may not be optimal

To get full, accurate PostgreSQL assessments and right‑sized SKU recommendations, database credentials must be added.

What needs to be done

Add PostgreSQL credentials in the Azure Migrate appliance configuration manager

Credential type: Database‑specific user (PostgreSQL)

Ensure the PostgreSQL user has minimum required permissions:

CONNECT

SELECT

pg_read_all_settings

pg_read_all_stats

pg_monitor

Whitelist the Azure Migrate appliance IP in pg_hba.conf on the PostgreSQL server.

Re-run discovery from the appliance after adding credentials.

Hope this helps! Let us know if any queries?
Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-15T20:23:40.4666667+00:00

Hello Andre Matos,

Just checking in to see if the solution shared above help you to resolve your issue. please reach out to us If you have any further questions.

Thanks
Andre Matos 20 Reputation points Microsoft Employee

2026-04-16T07:20:51.61+00:00

Hi @Siva shunmugam Nadessin , good morning

If you go back to my original post, you can double check that I already tried to add "Database‑specific user (PostgreSQL)", but that is not showing on the drop down for adding the credentials, and that is actually why I'm raising this request.

Thank you,

André

Answer accepted by question author

1 additional answer

Your answer

Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-13T19:03:22.1333333+00:00

Hello Andre Matos,

Thank you for reaching out to the Microsoft Q&A forum.

When investigated we see that although the documentation mentions PostgreSQL discovery, the current Azure Migrate appliance does not support adding PostgreSQL credentials explicitly. Only Domain, Linux/Windows (OS-level), SQL Server, and MySQL credential types are available in the appliance UI.

Because PostgreSQL credentials cannot be added directly:

Azure Migrate performs limited PostgreSQL discovery

Object‑level assessment (schemas, objects, permissions) cannot be fully evaluated

Recommendations are therefore VM-level and marked “Ready with conditions”

Warnings appear for insufficient permissions, even when PostgreSQL exists on the VM

For PostgreSQL, Azure Migrate currently relies on OS-level discovery, not database credential–based discovery (unlike SQL Server or MySQL). This is a platform limitation, not a configuration issue.

For detailed PostgreSQL migration readiness (object-level analysis), Microsoft recommends using Azure Database Migration Service (DMS) or manual PostgreSQL assessment scripts instead of Azure Migrate appliance credentials.

Let us know if you have further queries?

References:

Assessing On-Premises PostgreSQL for Migration to Azure Flexible Server - Azure Migrate | Microsoft Learn

PostgreSQL Assessment Rules to Detect Blockers and Compatibility Issues - Azure Migrate | Microsoft Learn

Review PostgreSQL assessment properties - Azure Migrate | Microsoft Learn

Azure Migrate appliance - Azure Migrate | Microsoft Learn
Andre Matos 20 Reputation points Microsoft Employee

2026-04-14T08:26:52.25+00:00

Hi @Siva shunmugam Nadessin , good morning!

Unfortunately. I can't relate your answer with my challenge. Its clearly stated in multiple documents that there is a need to provide PostgreSQL credentials for Azure Migrate appliance to further evaluate the database.

Here: https://learn.microsoft.com/en-us/azure/migrate/tutorial-review-postgresql-report?view=migrate#review-readiness

"If PostgreSQL credentials aren't provided or if the Azure Migrate appliance can't connect to the PostgreSQL instance, SKU recommendations are based on virtual machine-level configuration. In this case, the readiness status is marked as Ready with Conditions. To validate all assessment rules—including extensions, collations, data types, and other database-specific configurations—and to ensure optimal SKU sizing, provide PostgreSQL credentials with sufficient permissions."

Here: https://learn.microsoft.com/en-us/previous-versions/azure/migrate/how-to-discover-applications?view=migrate#add-credentials-and-initiate-discovery

Here: https://learn.microsoft.com/en-us/previous-versions/azure/migrate/how-to-discover-applications?view=migrate#discover-postgresql-instances-and-databases-preview

"If you haven't provided Windows or Linux authentication and PostgreSQL instance authentication credentials on the appliance configuration manager, then add the credentials so that the appliance can use them to connect to respective PostgreSQL instances."

Could you please double check?

Thank you,

André
Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-15T02:09:26.75+00:00

Hello Andre Matos,

When investigating further Azure Migrate requires PostgreSQL database credentials for in‑depth database discovery and accurate assessment.

If PostgreSQL credentials are not provided, Azure Migrate:

Assesses the workload only at the VM level

Marks readiness as “Ready with Conditions”

Cannot validate database‑specific rules (extensions, collations, data types, version compatibility)

Generates generic SKU recommendations, which may not be optimal

To get full, accurate PostgreSQL assessments and right‑sized SKU recommendations, database credentials must be added.

What needs to be done

Add PostgreSQL credentials in the Azure Migrate appliance configuration manager

Credential type: Database‑specific user (PostgreSQL)

Ensure the PostgreSQL user has minimum required permissions:

CONNECT

SELECT

pg_read_all_settings

pg_read_all_stats

pg_monitor

Whitelist the Azure Migrate appliance IP in pg_hba.conf on the PostgreSQL server.

Re-run discovery from the appliance after adding credentials.

Hope this helps! Let us know if any queries?
Siva shunmugam Nadessin 9,625 Reputation points Microsoft External Staff Moderator

2026-04-15T20:23:40.4666667+00:00

Hello Andre Matos,

Just checking in to see if the solution shared above help you to resolve your issue. please reach out to us If you have any further questions.

Thanks
Andre Matos 20 Reputation points Microsoft Employee

2026-04-16T07:20:51.61+00:00

Hi @Siva shunmugam Nadessin , good morning

If you go back to my original post, you can double check that I already tried to add "Database‑specific user (PostgreSQL)", but that is not showing on the drop down for adding the credentials, and that is actually why I'm raising this request.

Thank you,

André

Answer 1

Siva shunmugam Nadessin 9,625 Microsoft External Staff Moderator

To address the issue, the customer downloaded the PostgreSQL appliance components from the official source (https://aka.ms/latestapplianceservices), installed the PostgreSQL Agent, and completed the required configuration.

However, despite successful setup, the appliance was still unable to establish communication with the agent.

As a resolution step, the customer removed the existing appliance and deployed a new one. After the fresh deployment, the issue was resolved — PostgreSQL credentials could be added successfully out of the box without any further errors.

The customer has confirmed this behavior and shared a screenshot for validation.

Azure Migrate had the bottleneck, special thanks to Andre Matos for this troubleshooting approach. Kindly User's image & up-vote this can be beneficial to other community members.

Andre Matos 20 Reputation points Microsoft Employee

2026-04-22T11:25:21.7033333+00:00

Hi,

After some investigation, I was working with a faulty Azure Migrate Appliance that refused to properly integrate with the PostgreSQL Agent, resulting in not having displayed the PostgreSQL credentials.

@Siva shunmugam Nadessin, please review your documentation and update it, as this was thread not valuable and provided wrong information, misguiding from the real challenge.

I was able to download the faulty PostgreSQL from https://aka.ms/latestapplianceservices, installed the PostgreSQL Agent and configure it:

But, even after configuration, the Appliance did not communicate with the Agent.

After removing the appliance and add a new one, out of the box I was able to add PostgreSQL credentials:

Hope this helps anyone that can face the same issue.

Thank you,

André

Answer 2

Andre Matos hi,

UI is correct, PostgreSQL creds are not added there, warning is about limited assessment depth )))) yeah this is expected, nothing broken really. PostgreSQL creds are just handled differently in Azure Migrate

what u see in UI is correct, appliance only shows creds it can use for deep discovery (SQL Server, MySQL, OS), PostgreSQL is not exposed there even if docs wording is confusing.

what the warning means, “insufficient permissions” is about limited metadata access, not missing UI creds, appliance could not read full system catalogs

Andddd as usually u have 2 options :) ignore and continue (migration still works, just less detailed assessment) or provide proper PostgreSQL user later during migration (DMS) with access to pg_catalog and information_schema.

PostgreSQL discovery is mostly VM/config based, not login-driven like SQL Server, so UI does not include it.

rgds,

Alex

&

pls if it helps accept my answer and mark it as an answer

Share via

Can't add PostgreSQL credentials to Azure Migrate appliance, they don't seem to be available.

1 additional answer

Your answer