Python - Django-ORM：是否有从 postgresql 迁移到 tbase 的方案

[ryanycheng]

应用：Python - Django-ORM
问题：是否有从 postgresql 迁移到 tbase 的完整方案。

[ryanycheng]

问题：创建的表格携带unique标识字段，如何创建shard表
现象：
执行下面sql时，将创建一个 Distribute By: REPLICATION 的表

CREATE TABLE "django_celery_beat_periodictask" ("id" serial NOT NULL PRIMARY KEY, "name" varchar(200) NOT NULL UNIQUE,
"task" varchar(200) NOT NULL, "args" text NOT NULL, "kwargs" text NOT NULL, "queue" varchar(200) NULL,
"exchange" varchar(200) NULL, "routing_key" varchar(200) NULL, "expires" timestamp with time zone NULL,
"enabled" boolean NOT NULL, "last_run_at" timestamp with time zone NULL,
"total_run_count" integer NOT NULL CHECK ("total_run_count" >= 0), "date_changed" timestamp with time zone NOT NULL,
"description" text NOT NULL, "crontab_id" integer NULL, "interval_id" integer NULL)

我在单独指定id的为shard字段的情况下

CREATE TABLE "django_celery_beat_periodictask" ("id" serial NOT NULL PRIMARY KEY, "name" varchar(200) NOT NULL UNIQUE, "task" varchar(200) NOT NULL, "args" text NOT NULL, "kwargs" text NOT NULL, "queue" varchar(200) NULL, "exchange" varchar(200) NULL, "routing_key" varchar(200) NULL, "expires" timestamp with time zone NULL, "enabled" boolean NOT NULL, "last_run_at" timestamp with time zone NULL, "total_run_count" integer NOT NULL CHECK ("total_run_count" >= 0), "date_changed" timestamp with time zone NOT NULL, "description" text NOT NULL, "crontab_id" integer NULL, "interval_id" integer NULL) DISTRIBUTE BY SHARD ("id");

ERROR: Unique index of partitioned table must contain the hash distribution column.

我在加上name字段的情况下

CREATE TABLE "django_celery_beat_periodictask" ("id" serial NOT NULL PRIMARY KEY, "name" varchar(200) NOT NULL UNIQUE, "task" varchar(200) NOT NULL, "args" text NOT NULL, "kwargs" text NOT NULL, "queue" varchar(200) NULL, "exchange" varchar(200) NULL, "routing_key" varchar(200) NULL, "expires" timestamp with time zone NULL, "enabled" boolean NOT NULL, "last_run_at" timestamp with time zone NULL, "total_run_count" integer NOT NULL CHECK ("total_run_count" >= 0), "date_changed" timestamp with time zone NOT NULL, "description" text NOT NULL, "crontab_id" integer NULL, "interval_id" integer NULL) DISTRIBUTE BY SHARD ("id", "name");

依然存在异常，ERROR: Unique index of partitioned table must contain the hash distribution column.

缘由：
后续需要使用 django_celery_beat_periodictask 关联到其他表，

ALTER TABLE "django_celery_beat_periodictask" ADD CONSTRAINT "django_celery_beat_p_crontab_id_d3cba168_fk_django_ce" FOREIGN KEY ("crontab_id") REFERENCES "django_celery_beat_crontabschedule" ("id") DEFERRABLE INITIALLY DEFERRED;

ERROR: Hash/Modulo distribution column does not refer to hash/modulo distribution column in referenced table.