[Bucardo-general] Bucardo add sync failed

Greg Sabino Mullane greg at endpoint.com
Wed Jun 7 16:30:29 UTC 2017


On Tue, Jun 06, 2017 at 10:23:58AM +0800, 张远 wrote:
>        In my postgresql log I can see “CREATE TRIGGER "bucardo_note_trunc_liyan" 
>                   AFTER TRUNCATE ON "public"."bookmark"
>                   FOR EACH STATEMENT EXECUTE PROCEDURE bucardo.bucardo_note_truncation('liyan’)”  this sql is blocked by a select sql.

Postgres requires a heavy lock on a table to add triggers, but your regular 
database activity is blocking that. You could try creating that trigger 
in a standalone session by simply running the SQL above. As long as the function 
already exists, it can be created at any time.

-- 
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/20170607/ccdbc37f/attachment.sig>


More information about the Bucardo-general mailing list