Re: Out of memory on pg_dump

Chris-

did you look at Zdenek Kotala's pgcheck ?
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgcheck/pgcheck/src/

download 3 source files and run makefile

anyone know of a PG integrity checker
?
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

> Subject: Re: [GENERAL] Out of memory on pg_dump
> Date: Fri, 21 Aug 2009 11:29:48 -0400
> From: chopkins@cra.com
> To: tgl@sss.pgh.pa.us
> CC: pgsql-general@postgresql.org
>
> Thanks Tom. Next question (and sorry if this is an ignorant one)...how
> would I go about doing that?
>
> - Chris
>
>
>
>
>
>
> THIS MESSAGE IS INTENDED FOR THE USE OF THE PERSON TO WHOM IT IS ADDRESSED. IT MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message and notify the sender so that we may correct our records.
>
> -----Original Message-----
>
>
>
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, August 21, 2009 11:07 AM
> To: Chris Hopkins
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Out of memory on pg_dump
>
> "Chris Hopkins" <chopkins@cra.com> writes:
> > 2009-08-19 22:35:42 ERROR: out of memory
> > 2009-08-19 22:35:42 DETAIL: Failed on request of size 536870912.
>
> > Is there an easy way to give pg_dump more memory?
>
> That isn't pg_dump that's out of memory --- it's a backend-side message.
> Unless you've got extremely wide fields in this table, I would bet on
> this really being a corrupted-data situation --- that is, there's some
> datum in the table whose length word has been corrupted into a very
> large value. You can try to isolate and delete the corrupted row(s).
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

---

With Windows Live, you can organize, edit, and share your photos. Click here.