Chris Browne <[EMAIL PROTECTED]> writes:
> We have discovered an interesting locking scenario with Slony-I that
> is pointing to a use for the ability to exclude certain schemas from
> pg_dump.

> The situation is that when a "full" pg_dump kicks off, a Slony-I
> "create sync" event, which expects to "LOCK slony_schema.sl_event;",
> is blocked from getting the exclusive lock that it desires.

Perhaps this should be seen as a Slony bug.  Does it really need an
AccessExclusive lock, or would an Exclusive lock do?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to