Re: unable to dump database, toast errors - Mailing list pgsql-general

From Tom Lane
Subject Re: unable to dump database, toast errors
Date
Msg-id 28140.1049430082@sss.pgh.pa.us
Whole thread Raw
In response to Re: unable to dump database, toast errors  (Lonni Friedman <lfriedman@vasoftware.com>)
Responses Re: unable to dump database, toast errors  (Lonni Friedman <lfriedman@vasoftware.com>)
List pgsql-general
Lonni Friedman <lfriedman@vasoftware.com> writes:
> however, if i attempt to select just bin_data (which holds a 6MB M$-Word
> doc) it attempts to dump it to screen for a few hundred lines, and then
> segfaults.

Wait a second.  Which side is segfaulting here?  I've been assuming that
you were talking about a backend segfault, but maybe I misunderstood
completely.  If it's psql dumping core then we have quite a different
issue.

> i'm honestly not sure how to do this.  the segfault is not producing a
> core file that i can find.  perhaps i'd need to tinker with ulimit?

Probably.  "ulimit -c 0" is a common default these days.  Try "ulimit -c
unlimited" before starting the postmaster (resp. psql).

            regards, tom lane


pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Converting from dbase
Next
From: Lonni Friedman
Date:
Subject: Re: unable to dump database, toast errors