Re: BUG #4095: Out of memory when restore db

"Pavel Zaitsev" <pz@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs