Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

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:

  • POINT

  • LINESTRING

  • POLYGON

  • MULTIPOINT

  • MULTILINESTRING

  • MULTIPOLYGON

  • GEOMETRYCOLLECTION

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 (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

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


dba-ninja.com