Re: pg_dump throwing segfault error during backup - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump throwing segfault error during backup
Date
Msg-id a04878d9-c137-4791-a1a7-034776b893ba@aklaver.com
Whole thread Raw
In response to pg_dump throwing segfault error during backup  (Cassandra Thrift <cssndrthrift@gmail.com>)
List pgsql-general
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
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Questions about document "Concurrenry control" section
Next
From: Adrian Klaver
Date:
Subject: Re: Disk is filling up with large files. How can I clean?