Re: out of memory error with loading pg_dumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: out of memory error with loading pg_dumpall
Date
Msg-id 6027.1324484031@sss.pgh.pa.us
Whole thread Raw
In response to Re: out of memory error with loading pg_dumpall  ("Dara Olson" <dolson@glifwc.org>)
List pgsql-general
"Dara Olson" <dolson@glifwc.org> writes:
> This is the first 1/3 of the errors, so hopefully this will help diagnose where my problem may be. Any help would be
greatlyappreciated.  

Well, you didn't show us the error that caused a COPY to fail, but it's
pretty obvious that you're attempting to load the dump into a database
that's already populated.  This suggests that the actual problem could
be something like a COPY command that matches the name but not the
column set of an existing table.  I'd suggest dropping and recreating
the target database first.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: can not use the column after rename
Next
From: "Andrus"
Date:
Subject: How to create database with default system locale is set to et_EE.UTF-8