Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,153 questions
Azure DB Single Server Public IP migration options
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 51%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVI%3C/text%3E%3C/svg%3E)
Vision Intelligence
20
Reputation points
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.
{count} votes
-
Oury Ba-MSFT 19,991 Reputation points Microsoft Employee2025-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
-
Vision Intelligence 20 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 19,991 Reputation points Microsoft Employee
2025-01-09T19:30:36.3533333+00:00 -
Vision Intelligence 20 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 19,991 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 20 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?
Sign in to comment
Sign in to answer