From: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Out of memory
Date: Fri, 22 Jul 2011 10:55:51 +0200
Message-ID: <20110722085551.GA6524@sun.ac.za> (raw)
In-Reply-To: <25415.1311259016@sss.pgh.pa.us>
References: <20110721141101.GA23173@sun.ac.za>
<25415.1311259016@sss.pgh.pa.us>
On Thu, Jul 21, 2011 at 04:36:56PM +0200, Tom Lane wrote:
>
> Almost always, when you get a cascade of error messages, the thing to
> look at is the *first* error, or first few errors. Not the last ones.
>
> In this case I'd guess that a COPY command failed and psql is now trying
> to process the COPY data as SQL commands, but you'll never be able to
> tell any more than that without seeing the error message that the COPY
> reported.
>
Thanks Tom. That is something that makes a lot of sense.
I have done two things and one or both of them made a difference:
moved the database to a partition with more free space and I deleted and
recreated the database.
I could successfully import the data now.
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jspies@sun.ac.za
Subject: Re: Out of memory
In-Reply-To: <20110722085551.GA6524@sun.ac.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox