Re: PG_dump a large database fails - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: PG_dump a large database fails
Date
Msg-id 4C076CB70200002500031E3F@gw.wicourts.gov
Whole thread Raw
In response to PG_dump a large database fails  (fida aljounaidi <fida.aljounaidi@gmail.com>)
List pgsql-admin
fida aljounaidi <fida.aljounaidi@gmail.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

pgsql-admin by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: graceful reload
Next
From: Kevin Kempter
Date:
Subject: default isolation level per user?