Out of memory

From: Johann Spies <jspies(at)sun(dot)ac(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: Out of memory
Date: 2011-07-21 14:11:01
Message-ID: 20110721141101.GA23173@sun.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On a computer with 2G Ram running Debian Squeeze and Postgresql 8.4.8-0squeeze2
I made a dump using 'pg_dump kb > kb.sql'.

I copied the file to another computer with 8G RAM running Debian
wheezy/sid/Postgresql 8.4.8-2 and tried to load that data by running
'psql -f kb.sql' - a process which produced a lot of errors ending with

psql:kb.sql:4189263: invalid command \N
psql:kb.sql:4189277: invalid command \N
psql:kb.sql:4189278: invalid command \N
psql:kb.sql:4189279: invalid command \nMost
psql:kb.sql:4189280: invalid command \N
psql:kb.sql:4189281: invalid command \N
psql:kb.sql:4189282: invalid command \N
psql:kb.sql:4189283: invalid command \N
psql:kb.sql:4189284: invalid command \N
psql:kb.sql:7991569: ERROR: out of memory
DETAIL: Cannot enlarge string buffer containing 0 bytes by 1311240426 more bytes.

What is causing the 'invalid command' lines?
And the memory problem?

There are several foreign keys in the database.

Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

"Children, obey your parents in the Lord: for this is
right." Ephesians 6:1

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-07-21 14:36:56 Re: Out of memory
Previous Message Steve Crawford 2011-07-20 21:16:32 Re: How frequently to defrag(cluster)