Re: PG_dump a large database fails

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "fida aljounaidi" <fida(dot)aljounaidi(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PG_dump a large database fails
Date: 2010-06-03 13:49:59
Message-ID: 4C076CB70200002500031E3F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

fida aljounaidi <fida(dot)aljounaidi(at)gmail(dot)com> wrote:

> For migration purpose (from 8.2 to 8.4)

8.2.what? to 8.4.what?

> (this is my dump command "pg_dump mydb | gzip > /var/dump/db.gz"

Using pg_dump from which version?

> It fails whith this error message:
> pg_dump: la commande SQL a échoué
> pg_dump: Message d'erreur du serveur : ERREUR: invalid memory
> alloc request size 1510382321
> pg_dump: La commande était : COPY public.attach_data (id, thedata)
> TO stdout;

Did you (or can you) get a core file and get a backtrace?

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Kempter 2010-06-03 15:17:09 default isolation level per user?
Previous Message Gnanakumar 2010-06-03 13:37:07 PITR Recovery Question