4

I am using the AWS DMS service to migrate my Postgres database to Aurora Postgres but I got in some tables that error

Value of column 'ColumnName' in table 'TableName' was truncated to 32768 bytes, actual length: 110644 bytes

column type could be text or jsonb

I can fix it by changing include LOB option to be Full LOB mode instead of Limited one but that breaks other tables

enter image description here

any hint on how I can customize that option to these specific tables only

Mina Fawzy
  • 20,852
  • 17
  • 133
  • 156

1 Answers1

5

I fixed it by creating a new Database migration task and set include LOB option to Full LOB mode

Mina Fawzy
  • 20,852
  • 17
  • 133
  • 156