Re: Error when running PG_DUMP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: idris khanafi <idris(dot)khanafi(at)detik(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Error when running PG_DUMP
Date: 2009-10-18 02:23:19
Message-ID: 28460.1255832599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

idris khanafi <idris(dot)khanafi(at)detik(dot)com> writes:
> When I running pg_dump i have error
> pg_dump: Error message from server: ERROR: MemoryContextAlloc: invalid
> request size 4294967293
> pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor

Looks like a corrupted-data problem to me. You might try not using
the -d/-D switch as the easiest way to find out which table contains
the corrupt data --- then you'll see the error on a COPY command instead
of a cursor fetch.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Palaniappan Thiyagarajan 2009-10-18 03:17:53 Re: Urgent Help required
Previous Message Jan-Peter Seifert 2009-10-17 17:15:05 Re: LIKE - bug or expected behaviour?