[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