For Azure Database for PostgreSQL Single Server ...The migration process needs to be performed to move it to the Flexible Server service. Supported network scenarios for migration are discussed here... https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service For a Single Server configured with a public "postgres.database.azure.com" (FQDN) address, What migration path to select for a Flexible Server that would also end up needing a public "postgres.database.azure.com" (FQDN) address? The options provided in the link above only seem to support Flexible Server with VNet or private endpoint.

Any feedback regarding my last comment regarding which network scenario applies to my deployment?

Azure DB Single Server Public IP migration options

Vision Intelligence 60

For Azure Database for PostgreSQL Single Server...The migration process needs to be performed to move it to the Flexible Server service. Supported network scenarios for migration are discussed here...
https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service User's image

For a Single Server configured with a public "postgres.database.azure.com" (FQDN) address, What migration path to select for a Flexible Server that would also end up needing a public "postgres.database.azure.com" (FQDN) address? The options provided in the link above only seem to support Flexible Server with VNet or private endpoint.

Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-07T23:40:47.92+00:00

@Vision Intelligence Thank you for reaching out.

To facilitate connectivity between an instance of Azure Database for PostgreSQL - Single Server that has public access and a VNet-integrated flexible server, configure the single server to allow connections from the subnet where the flexible server is deployed.

This is the right doc to follow https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-single-to-flexible?tabs=portal%2Coffline

Single server public access to VNET Integration

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/quickstart-create-server?tabs=portal-create-flexible%2Cportal-get-connection%2Cportal-delete-resources
Vision Intelligence 60 Reputation points

2025-01-08T11:01:59.9866667+00:00

The Single server instance has a public "postgres.database.azure.com" (FQDN) address.

The Flexible server must also have a public "postgres.database.azure.com" (FQDN) address.

This is not mentioned by the document. How to handle this?
Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-09T19:30:36.3533333+00:00

Vision Intelligence

Is it for an on-premises server or managed Azure PostgreSQL single server?
Vision Intelligence 60 Reputation points

2025-01-09T19:37:09.9866667+00:00

Both are managed services (Azure Database for PostgreSQL Single Server migrate to Azure Database for PostgreSQL Flexible Server). Both would have public "postgres.database.azure.com" (FQDN) address. This is not mentioned by the networking document. How to handle this?
Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-10T20:19:18.53+00:00

Vision Intelligence Thank you for responding.

Please confirm the below first.

What option did you choose for the single server?

I have successfully migrated my managed single server with public access to a flexible server configured as public access.

This is the doc I have follow https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-single-to-flexible?tabs=portal%2Coffline

Please let me know by commenting below if it is helpful.

Regards,

Oury
Vision Intelligence 60 Reputation points

2025-01-10T21:06:20.68+00:00

I have those same settings.

This section of the doc you mentions Network setup is crucial, and provides link to the Network guide.

So I navigate to the network guide and I see these supported scenarios...

Which one of these above applies to my setup that I have mentioned a few times now?
As I mentioned previously...My scenario is Migrate my existing Azure Database for PostgreSQL Single Server to Azure Database for PostgreSQL Flexible Server. Both would have public "postgres.database.azure.com" (FQDN) address. This is not mentioned by the networking document. How to handle this?
Vision Intelligence 60 Reputation points

2025-01-18T11:24:01.0233333+00:00

Checking in...Any more feedback regarding my last comment?
Vision Intelligence 60 Reputation points

2025-01-21T18:20:03.2133333+00:00

OK, thank you. Recommend adding this to the network scenarios
Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-21T18:49:54.6+00:00

@Vision Intelligence Noted and thank you for your feedback.

I will work internally with our team to add that.

Regards,

Oury

Accepted answer

Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-21T18:09:40.71+00:00

Vision Intelligence

Issue: For a Single Server configured with a public "postgres.database.azure.com" (FQDN) address, what migration path to select for a Flexible Server that would also end up needing a public "postgres.database.azure.com" (FQDN) address?

Answer: If both are publicly accessed as you mentioned, so no further action needed at networking level.

Hope that answers your questions.

Regards,

Oury
Please sign in to rate this answer.

1 person found this answer helpful.
Oury Ba-MSFT 20,176 Reputation points Microsoft Employee

2025-01-21T18:52:20.1533333+00:00

Vision Intelligence

Thank you for your prompt response. Please don't forget to mark as accept answer if the reply above answers your query.

Regards,

Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Vision Intelligence 60 Reputation points

2025-01-16T10:24:03.5333333+00:00

Any feedback regarding my last comment regarding which network scenario applies to my deployment?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure DB Single Server Public IP migration options

1 additional answer

Your answer