Re: pg_dump error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump error
Date: 2002-10-01 17:10:55
Message-ID: 5835.1033492255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl> writes:
> What does this mean ?!? Is this a corrupt database, a bug or has the pg_dump
> not enough memory ?

> $ pg_dump login | gzip > login.dump.gz
> pg_dump: ERROR: MemoryContextAlloc: invalid request size 4294967293
> pg_dump: lost synchronization with server, resetting connection
> pg_dump: SQL command to dump the contents of table "postcodereeks" failed:
> PQendcopy() failed.

First guess is a corrupted data value in table postcodereeks. Possibly
you can narrow down which row(s) have bad data and remove 'em.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message roco 2002-10-01 18:08:52 Fwd: Fwd: FATAL 1: Database dialup does not exist in pg_database
Previous Message Bruce Momjian 2002-10-01 16:56:30 Re: Extent size