public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Cassandra Thrift <[email protected]>
To: [email protected]
Subject: Re: pg_dump throwing segfault error during backup
Date: Wed, 9 Oct 2024 08:15:54 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
References: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>

On 10/7/24 22:42, Cassandra Thrift wrote:
> Hello Team,
> 
> We are facing a segfault issue while initiating backup with pg_dump.
> This is for Postgresql community version 12.5 and rhel 7.4 (PostgreSQL 
> 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red 
> Hat 4.8.5-39), 64-bit)

FYI, Postgres 12 goes EOL in one month.

What repo are you getting the Postgres package from, RH's or 
community(PGDG).

If community see:

https://yum.postgresql.org/news/rhel7-end-of-life/


> 

> We fond the timing which shows database backup is getting invoked at the 
> time. So we had to stop backup (pg_backup)

I am not familiar with pg_backup, is that an actual program or our you 
using it as alias for something else?

> 
> we are manually taking table data currently.

Show the exact command/process you are using to do above.

> 
> Core dump also generated however RedHat refused to analyze this saying 
> it is third party product.
> 
> Kindly let us know if this is a bug for the version as it is too old and 
> if the core dump can be analyzed somehow as it is in binary.

The most recent minor version of Postgres 12 is .20. It would not be a 
bad idea to upgrade to that for immediate needs and then start testing 
newer Postgres versions for a change in major version to get to a 
version that will be community supported for some time.

> 
> Regards
> Somraj Chakrabarty

-- 
Adrian Klaver
[email protected]







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: pg_dump throwing segfault error during backup
  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