Postgresql ma'lumotlar bazasidan aws dms uchun manba sifatida foydalanish

PostgreSQL manba versiyasi
AWS DMS ishlatiladigan versiyasi
9.x	Mavjud bo'lgan DMS versiyasidan foydalaning.
10.x	Agar 3.3.0 dan oldin DMS versiyasini ishlatsangiz, PostgreSQL Version 10.x-da AWS DMS-ning manbai sifatida foydalanish-da tavsiflangan o'rash funktsiyalari yordamida PostgreSQL manbasini tayyorlang . Agar DMS 3.3.0 yoki undan keyingi versiyasidan foydalansangiz, ushbu funktsiyani yaratmang. PostgreSQL manbasini hech qanday qo'shimcha tayyorgarliksiz ishlatishingiz mumkin.
11.x	DMS 3.3.0 versiyasidan foydalaning.

PostgreSQL tugatish nuqtasi va replikatsiya nusxasi o'rtasidagi aloqalarni shifrlash uchun SSL-dan foydalanishingiz mumkin. PostgreSQL so'nggi nuqtasi bilan SSL-dan foydalanish haqida ko'proq ma'lumot olish uchun SSL- dan AWS ma'lumotlar bazasini Migratsiya xizmati bilan foydalanish- ga qarang .

PostgreSQL ma'lumotlar bazasidan PostgreSQL ma'lumotlar bazasiga AWS-da bir hil ko'chish uchun quyidagilar to'g'ri bo'ladi.

• JSONB columns on the source are migrated to JSONB columns on the target.

  
  

• JSON columns are migrated as JSON columns on the target.

  
  

• HSTORE columns are migrated as HSTORE columns on the target.

  
  

For a heterogeneous migration with PostgreSQL as the source and a different database engine as the target, the situation is different. In this case, JSONB, JSON, and HSTORE columns are converted to the AWS DMS intermediate type of NCLOB and then translated to the corresponding NCLOB column type on the target. In this case, AWS DMS treats JSONB data as if it were a LOB column. During the full load phase of a migration, the target column must be nullable.

AWS DMS supports change data capture (CDC) for PostgreSQL tables with primary keys. If a table doesn't have a primary key, the write-ahead logs (WAL) don't include a before image of the database row and AWS DMS can't update the table.

DW nusxasi mantiqiy replikatsiyadan foydalanishga sozlanganda AWS DMS Amazon RDS PostgreSQL ma'lumotlar bazasida CDC-ni qo'llab-quvvatlaydi. Amazon RDS PostgreSQL DB 9.4.9 va undan yuqori versiyalari, 9.5.4 va undan yuqori versiyalari uchun mantiqiy replikatsiyani qo'llab-quvvatlaydi. Amazon RDS, shuningdek, PostgreSQL 10.6 muvofiqligi bilan 2.2.0 va 2.2.1 versiyalari yordamida Amazon Aurora DB nusxasi uchun mantiqiy replikatsiyani qo'llab-quvvatlaydi.

PostgreSQL ma'lumotlar bazalari va AWS DMS bilan ishlash bo'yicha qo'shimcha ma'lumotlar uchun quyidagi bo'limlarga qarang.