On 12/22/21 8:40 AM, Tom Lane wrote:
Paulo Silva <paulojjs@xxxxxxxxx> 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.
