[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