pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ferdinand Smit <ferdinand@telegraafnet.nl>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump error
Date: Tue, 01 Oct 2002 13:10:55 -0400
Message-ID: <5835.1033492255@sss.pgh.pa.us> (raw)
In-Reply-To: <200210011752.49941.ferdinand@telegraafnet.nl>
References: <200210011752.49941.ferdinand@telegraafnet.nl>

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



view thread (40+ messages)  latest in thread

Message-ID: <5835.1033492255@sss.pgh.pa.us>
Permalink:  ../5835.1033492255@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/5835.1033492255@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ferdinand@telegraafnet.nl
  Subject: Re: pg_dump error
  In-Reply-To: <5835.1033492255@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox