Re: Restoring a pg_dump fails with

On Thu, Apr 26, 2001 at 05:35:02PM +0200, Reiner Dassing wrote:
> By upgrading von PostgreSQL 6.5.3 to 7.1.0 I restored a dump file by
> psql dbname <dbname.dump
>
> After some time I get the following message:
> ERROR:  copy: line 1638280, Memory exhausted in AllocSetAlloc(56)
> PQendcopy: resetting connection
>
> The total number of lines is about 10 Millions!
>
> Can anybody help me or explain what to do?
> May be, I have to convert to INSERT-statements?

It's probably easier to cut the command into several smaller COPY
commands. All it takes is a small
awk/perl/python/your_favourite_scripting_language_here thing.


--
Ragnar Kjørstad