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
