[Bucardo-general] Bucardo add sync failed

[张远]

what is  "a standalone session" , connect db with a different ip ?

2017-06-08 0:30 GMT+08:00 Greg Sabino Mullane <greg at endpoint.com>:

> 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 --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170609/e4ebf68f/attachment.html>