Single Server to Flexible Server PostGIS raster bug

WHS One 1

We are trying to migrate an Azure Single Server PostgreSQL 9.6 database to Azure Database for PostgreSQL Flexible Server v14 using the Migration tool.

The migration keeps failing with no detailed error message, just:

Error while processing. Please reference MigrationId

GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-03-09T18:24:20.12+00:00

@WHS One Thanks for posting your question in the Microsoft Q&A forum

How are you migrating? please share the steps and any screenshots of the error.

Please find the reference document https://video2.skills-academy.com/en-us/azure/postgresql/migrate/how-to-migrate-single-to-flexible-portal

Using Pgdump and restore https://video2.skills-academy.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore

Regards

Geetha
WHS One 1 Reputation point

2023-03-10T06:30:22.1766667+00:00

@GeethaThatipatri-MSFT We are using the Migration tool in the portal and following the steps in https://video2.skills-academy.com/en-us/azure/postgresql/migrate/how-to-migrate-single-to-flexible-portal
WHS One 1 Reputation point

2023-03-10T06:42:10+00:00

The original question I posted seems to have been edited/truncated, the original message I posted contained extra information about the migration and the potential cause, this has now disappeared.

I suspect the issue is to do with the postgis raster extension, the source database is using an older version of PostGIS where the raster extension was included with the postgis extension, but in later versions of PostGIS a separate postgis_raster extension is required. Maybe the migration tool does not take this into account and is not installing the postgis_raster extension.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-03-10T14:36:28.3233333+00:00

@WHS One Have you tried adding postgres raster extension

Regards

Geetha
WHS One 1 Reputation point

2023-03-13T09:33:33.23+00:00

Yes I did add the extension.
As I understand this just enables the extension for the cluster but doesn't actually install the extension in any databases.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-03-14T16:07:15.3566667+00:00

WHS One Can you please send an email with the below details

Thread URL: Link to this thread.

Your Azure Subscription ID:

Email Subject : Attn Geetha

Please let me know once you have done the same
WHS One 1 Reputation point

2023-03-16T08:44:30.7566667+00:00

@GeethaThatipatri-MSFT I have sent the email as requested.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-03-17T20:35:14.2166667+00:00

@WHS One I dont see your email, did you mention Email Subject : Attn Geetha
WHS One 1 Reputation point

2023-03-20T07:22:31.05+00:00

@GeethaThatipatri-MSFT yes I used the subject "Attn Geetha" as requested, I will send the email again.

1 answer

GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-03-29T14:58:15.68+00:00

@WHS One You are absolutely right and apologies for the delay in my response.

Currently, you cannot use the migration tool for your server migration. Reason is

You are trying to migrate from SSPG 9.6(postgis 2.3) to FSPG 14 (postgis 3.0+)

Postgis has done a major change from 2 to 3 versions. In version 2, there is a raster feature that you are using. From 3 versions the raster feature is a new extension and is not included in the PostGIS extension anymore. This is currently not supported by the migration tool

As a workaround you can perform a manual migration using DMS - Tutorial: Migrate PostgreSQL to Azure Database for PostgreSQL online via the Azure portal - Azure Database Migration Service | Microsoft Learn

A quick short summary on the pre-req for using the DMS tool- Before using this tool, you first need to create a target database manually. Next, you need to create all the required extensions including the postgis_raster extension on target db. Then they need to manually pg_dump and pg_restore your schema onto the target database. (I would recommend to go through the tutorial as well.)

I hope this information is helpful

Regards

Geetha
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

Single Server to Flexible Server PostGIS raster bug

1 answer

Your answer