Hello Greg! Thank for answer! i write way for used bucardo. Copy db using pg_dump from 9.3 to 9.5. Added db of bucardo. Added sync db of bucardo. Run sql query on 9.5 ALTER TABLE table ENABLE ALWAYS TRIGGER trigger_create_table_partition_and_insert_function; And get error: ERROR: trigger "trigger_create_table_partition_and_insert_function" for table "table" does not exist
May be wrong order? 2017-05-22 21:29 GMT+06:00 Greg Sabino Mullane <[email protected]>: > On Mon, May 22, 2017 at 11:14:53AM +0600, Пацев Антон wrote: > > Triggers: > > bucardo_delta AFTER INSERT OR DELETE OR UPDATE ON table FOR EACH > > ROW EXECUTE PROCEDURE bucardo.delta_public_table() > ... > > > trigger_create_table_partition_and_insert_function BEFORE INSERT > > ON table FOR EACH ROW EXECUTE PROCEDURE > > create_table_partition_and_insert_function() > ... > > На 9.3 > > SELECT count(*) from table; > > 499401 > > > > На 9.5 > > SELECT count(*) from table; > > 641335 > > If this means you are going *from* 9.3 *to* 9.5, then your partition > trigger is not firing on 9.5 during the replication (which is the > expected behavior - Bucardo disables all rules and triggers while > copying data into a table.) To enable the partitioning on the remote > databases, you will need to set the trigger to 'replica' (which means > it will *only* happen during replication) or to 'always' (which means > that it happens all the time). So try this on the 9.5 server: > > ALTER TABLE mytable ENABLE ALWAYS TRIGGER trigger_create_table_ > partition_and_insert_function; > > -- > Greg Sabino Mullane [email protected] > End Point Corporation > PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 > -- С уважением, Антон Пацев. Best regards, Anton Patsev.
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
