"Pavel Zaitsev" <pz(at)mail(dot)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