Bug #792: pg_dump uses all available RAM and swap

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #792: pg_dump uses all available RAM and swap
Дата
Msg-id 20021001183751.291104767FB@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #792: pg_dump uses all available RAM and swap  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Steve Riley (stepa@openskysoftware.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dump uses all available RAM and swap

Long Description
We noticed that doing a pg_dump was taking longer and longer to perform when doing data backup. For this and other
reasons,we began doing backup by stopping the server and tarring the data directory. Now, we are trying to upgrade to
7.2.1and we find that we must do a pg_dump of our data to restore properly, but running pg_dump now causes all
availableresources to be used up with no output until the system locks up. 

We run postgresql 7.1 on RedHat Linux 7.3

The total size of the data directory is 38 Mb

Command is: pg_dump buildit > buildit.pgdump

Memory monitor begins to fill up, then swap use begins to fill up, then if not halted by hand, the system locks up.



Sample Code


No file was uploaded with this report

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.3b2 initdb fails with semaphore error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug #792: pg_dump uses all available RAM and swap