Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump error - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump error
Date
Msg-id 5835.1033492255@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump error  (Ferdinand Smit <ferdinand@telegraafnet.nl>)
List pgsql-admin
Tree view 
Ferdinand Smit <ferdinand@telegraafnet.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

pgsql-admin by date:

Previous
From: roco
Date:
Subject: Fwd: Fwd: FATAL 1: Database dialup does not exist in pg_database
Next
From: Peter Eisentraut
Date:
Subject: Re: libreadline.so.3