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