Re: Postgresql crashing during pg_dump

On 12/22/21 8:40 AM, Tom Lane wrote:
> Paulo Silva <paulojjs(at)gmail(dot)com> writes:
>> I have a huge table with 141456059 records on a PostgreSQL 10.18 database.
>> When I try to do a pg_dump on that table, postgresql gives a segfault,
>> displaying this message:
>> 2021-12-22 14:08:03.437 UTC [15267] LOG: server process (PID 25854) was
>> terminated by signal 11: Segmentation fault
> What this sounds like is corrupt data somewhere in that table.
>
> There's some advice about dealing with such cases here:
>
> https://wiki.postgresql.org/wiki/Corruption
>
> If this is extremely valuable data, you might prefer to hire somebody
> who specializes in data recovery, rather than trying to handle it
> yourself. I'd still follow the wiki page's "first response" advice,
> ie take a physical backup ASAP.

COPY the table in PK ranges to narrow down the offending record?

--
Angular momentum makes the world go 'round.