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
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) |