Re: Postgresql crashing during pg_dump

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.

regards, tom lane