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

Greg Sabino Mullane greg at endpoint.com
Tue May 23 14:15:47 UTC 2017

On Tue, May 23, 2017 at 04:17:28PM +0600, Пацев Антон wrote:
> 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?

Well, I don't know how you setup your other database: I presume it has an 
identical schema. If not, you will need to add the trigger so that the 
inherited tables are populated. It should have the ame trigger and supporting 
function as the source database: the only change will be to set it to 'always' 

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170523/0008d5fb/attachment.sig>

More information about the Bucardo-general mailing list