alter table tablename replica identity full; 操作步骤 说明若源库为本云RDS for PostgreSQL,可以使用root用户创建相关对象,如果执行时报“Must be superuser to create an event trigger”错误,可以通过工单申请处理。本云RDS for PostgreSQL的root用户权限请参见RDS用户指南。 步骤 1 使用拥有创建事件触发器权限的用户连接要同步的数据库。
of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'
(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'); CREATE TABLE teledb=#
(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'); CREATE TABLE teledb=#
(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'); CREATE TABLE teledb=#
(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'); CREATE TABLE teledb=#
(f1,f2,f3,f4,f5) for values from ('2017-01-01') to ('2017-02-01'); CREATE TABLE teledb=# create table t_native_mul_list_gd_201702 partition of t_native_mul_list_gd(f1,f2,f3,f4,f5) for values from ('2017-02-01') to ('2017-03-01'); CREATE TABLE teledb=#