[Bucardo-general] Miscellaneous number of rows with bucardo 5.4.1 logical replication in the table where there are child tables

Пацев Антон patsev.anton at gmail.com
Tue May 23 10:17:28 UTC 2017


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 <greg at endpoint.com>:

> 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 greg at endpoint.com
> End Point Corporation
> PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
>



-- 
С уважением, Антон Пацев.
Best regards, Anton Patsev.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170523/9c447923/attachment.html>


More information about the Bucardo-general mailing list