Re: Out of memory error on pg_restore

Nik wrote:
> I am running PostgreSQL 8.1.3 on Windows 2003 Server.
>
> I am trying to transfer the data from a table in db1on one machine to a
> table in db2 on a different machine. The table size is about 22Gb
> (about 280 million rows).
>
> I was trying to do it by generating a backup file of the table in db1
> and restoring it to db2. First, I created a plain 22Gb SQL dump and
> tried inserting it via psql. After some time it failed with the
> following error:
>
> psql: ERROR: out of memory
> DETAIL: Failed on request of size 32.

And were you out of memory or not?
If nothing else, task-manager should show how much memory everything is
using.

--
   Richard Huxton
   Archonet Ltd