Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 10BB1B5DC10 for ; Thu, 21 Jul 2011 11:11:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55774-07 for ; Thu, 21 Jul 2011 14:11:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.sun.ac.za (mail1.sun.ac.za [146.232.64.12]) by mail.postgresql.org (Postfix) with ESMTP id ABE6AB5DC02 for ; Thu, 21 Jul 2011 11:11:08 -0300 (ADT) Received: from artikel.sun.ac.za ([146.232.82.145] helo=artikel) by mail1.sun.ac.za with esmtp (Exim 4.69) (envelope-from ) id 1Qjtxt-0002tk-Pd for pgsql-admin@postgresql.org; Thu, 21 Jul 2011 16:11:02 +0200 Received: from js by artikel with local (Exim 4.76) (envelope-from ) id 1Qjtxt-0006V1-Gp for pgsql-admin@postgresql.org; Thu, 21 Jul 2011 16:11:01 +0200 Date: Thu, 21 Jul 2011 16:11:01 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Out of memory Message-ID: <20110721141101.GA23173@sun.ac.za> Mail-Followup-To: Johann Spies , pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-3.093 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-1.193 X-Spam-Level: X-Archive-Number: 201107/151 X-Sequence-Number: 37930 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