public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Ishan Arunkumar Joshi <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: postgres server crash with "Segmentation fault"
Date: Fri, 17 Oct 2025 08:49:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Thu, 2025-10-16 at 11:07 +0000, Ishan Arunkumar Joshi wrote:
> We are using PG16.9 in Patroni Postgres setup in production. Last night we have face
> an issue [various data corruption errors]
>
> We had to drop the table “impacted_table” from database once the database is up.
> 
> however we are not able to identify exact root cause behind “segmentation fault”
> error for this table and need expert advice to find the root case and also need
> suggestions to prevention steps.

By dropping the table, you have probably destroyed the evidence needed for that.
If you have a file system backup of the corrupted state, an expert might be able
to identify probable causes.

One prevention step would have been to run the latest minor release (currently 16.10).

Other than that, make sure that you have a good backup that is occasionally tested
and make sure that the backup is monitored (I have seen cases where the backup was a
daily pg_dump, and only when the corruption surfaced, people realized that the pg_dump
had been failing for the exact same reason...).

Yours,
Laurenz Albe

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: postgres server crash with "Segmentation fault"
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox