Search Postgresql Archives

Re: pg_restore out of memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Francisco Reyes <lists@xxxxxxxxxxxxxxxx> writes:
> Tried a pg_dump without -Fc to see if I could get that one table loaded.
> Still failed.

> psql:message-attachments-2007-06-15.sql:2840177: ERROR:  out of memory
> DETAIL:  Failed on request of size 88885765.
> CONTEXT:  COPY message_attachments, line 60660: "2720290        7225017 
> research/crew holds.sit sit     88885753        t       1               
> U3R1ZmZJdCAoYykxOTk3LTIwMDIgQWxhZGRpbiBTeX..."

> Looked at the record in question and the length of the long column in that 
> row is 88885753 (84MB). 

If that actually is the length of the line, the only answer is to raise
the memory ulimit setting the postmaster runs under.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux