Re: tiny patch to make vacuumdb -a's database order match pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: tiny patch to make vacuumdb -a's database order match pg_dumpall
Дата
Msg-id 23862.1158520141@sss.pgh.pa.us
обсуждение исходный текст
Ответ на tiny patch to make vacuumdb -a's database order match pg_dumpall  ("Dan Thomas" <godders@gmail.com>)
Ответы Re: tiny patch to make vacuumdb -a's database order match pg_dumpall  ("Dan Thomas" <godders@gmail.com>)
Список pgsql-patches
"Dan Thomas" <godders@gmail.com> writes:
> I've been having trouble running vacuumdb -a and pg_dumpall
> concurrently because they run through the databases in a different
> order (so dumpall was getting stuck behind vacuum's lock, and my
> firewall was rather unhelpfully closing the idle connection).

Um, whaddya mean "dumpall was getting stuck behind vacuum's lock"?
A plain vacuum doesn't take any locks that would block pg_dump.

While the proposed patch looks harmless enough, I'm unconvinced that
it will solve your problem, or even quite what the problem is.

            regards, tom lane

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

Предыдущее
От: Joachim Wieland
Дата:
Сообщение: Re: [HACKERS] Timezone List
Следующее
От: "Dan Thomas"
Дата:
Сообщение: Re: tiny patch to make vacuumdb -a's database order match pg_dumpall