Re: [PATCHES] tiny patch to make vacuumdb -a's database order match pg_dumpall
В списке pgsql-hackers по дате отправления:
| От | Dan Thomas |
|---|---|
| Тема | Re: [PATCHES] tiny patch to make vacuumdb -a's database order match pg_dumpall |
| Дата | |
| Msg-id | b9aff96f0609171252i4e166dacs14c068d3e30e7cc6@mail.gmail.com обсуждение |
| Ответ на | Re: [PATCHES] tiny patch to make vacuumdb -a's database order match pg_dumpall (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-hackers |
> Um, whaddya mean "dumpall was getting stuck behind vacuum's lock"? > A plain vacuum doesn't take any locks that would block pg_dump. Dammit, just looked and the setup I originally encountered the problem on and tracked it down to the vacuum process, and it is indeed set up to perform a full vacuum.. I've incorrectly assumed the problem I'm having now (with a normal vac) was for the same reason. > While the proposed patch looks harmless enough, I'm unconvinced that > it will solve your problem, or even quite what the problem is. Yes, sorry about that, it does indeed appear that whatever is causing my dumpall process to die isn't PG's fault. Though I still think it makes a *bit* of sense to have vacuumdb use the same order as pg_dumpall (clusterdb too now I think about it), it's obviously not as much of an issue as I originally thought, and not the source of my problem, which is a shame :) Dan
В списке pgsql-hackers по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера