Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4095: Out of memory when restore db - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4095: Out of memory when restore db
Date
Msg-id 29379.1207495014@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4095: Out of memory when restore db  ("Pavel Zaitsev" <pz@mail.ru>)
List pgsql-bugs
Tree view 
"Pavel Zaitsev" <pz@mail.ru> writes:
> I made the backup of database named avtopzipbuh:
> pg_dump -f%DRIVETO%\Backup\%DIRNAME%\%FILENAME% -Upostgres avtozipbuh
> then, I tried to restore it:
> psql  -davtozipbuh -Upostgres -fF:\Backup\avtozipbuh
> -oF:\Backup\logrestore.txt
> but I had an error
> "psql:F:/Backup/avtozipbuh:214116: ERROR:  out of memory
> DETAIL:  Failed on request of size 536870912.

Is it true that you've got any extremely wide lines (100MB or more)
in that COPY data?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Meskes
Date:
Subject: Re: BUG #4090: ECPG Selecting table with NULL values
Next
From: Joe Conway
Date:
Subject: Re: BUG #3983: pgxs files still missing in win32 install (8.3.1)