Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links



Does DMS migrate PostgreSQL geospatial data types ?

30 January,2023 by Rambler

Question: we're researching using the AWS Database Migration Service (DMS) to migrate a homogenous migration between on-premises PostgreSQL to Aurora PostgreSQL. 

Within the database there are various data types used  which we're identifying if they may cause an issue. The data types are related to PostGIS spatial data types. Are these supported for a homogenous PostgreSQL to PostgreSQL migrations?   What is the AWS recommendation for homogenous migrations?


Answer:   The general recommendation by AWS for a homogenous migration such as PostgreSQL to Aurora PostgreSQL is to use use the PostgreSQL migration tools under the following circumstances:

1) It is a homogenous migration - relational to relational (similar db ) or NoSQL to NoSQL. Example PostgreSQL to RDS PostgreSQL

2) Entire database is being migrated 

3) The PostgreSQL tools support a migration within the acceptable downtime 


The decision whether you use something like pg_dump\pg_restore or AWS DMS will  depend on a number of factors such as acceptable downtime 



For PostgreSQL to PostgreSQL homogeneous migrations, AWS DMS supports the migration of PostGIS geometric and geographic (geodetic coordinates) data object types and subtypes such as the following:








Read more on  Using a PostgreSQL database as an AWS DMS source


Read more on AWS DMS 

AWS DMS rollback

AWS DMS Schema Conversion announcement


Author: Rambler (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Does DMS migrate PostgreSQL geospatial data types ?