Re: pg_dump --exclude-schema=foo

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump --exclude-schema=foo
Дата
Msg-id 29042.1095357394@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump --exclude-schema=foo  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-hackers
Chris Browne <cbbrowne@acm.org> 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: subtransaction assert failure
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problems with SPI memory management