Re: pg_restore out of memory

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: pg_restore out of memory
Дата
Msg-id cone.1181907996.308015.90473.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Ответы Re: pg_restore out of memory  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Tom Lane writes:

> The memory dump only comes out on stderr (I think because of paranoia
> about running out of memory while trying to report we're out of memory).
> Can you get the postmaster's stderr output?

From stderr

pg_restore: restoring data for table "message_attachments"
pg_restore: [archiver (db)] Error from TOC entry 2146; 0 988154 TABLE DATA
message_attachments pgsql
pg_restore: [archiver (db)] COPY failed: ERROR:  out of memory
DETAIL:  Failed on request of size 134217728.
CONTEXT:  COPY message_attachments, line 60490: "2720290        7225017
research/crew holds.sit sit     88885753        t
1U3R1ZmZJdCAoYykxOTk3LTIwMDIgQWxhZGRpbiBTeX..."


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: DeadLocks..., DeadLocks...
Следующее
От: Francisco Reyes
Дата:
Сообщение: Re: pg_restore out of memory