Feedback-ID: i76984098:Fastmail
Message-ID: <a04878d9-c137-4791-a1a7-034776b893ba@aklaver.com>
Date: Wed, 9 Oct 2024 08:15:54 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pg_dump throwing segfault error during backup
To: Cassandra Thrift <cssndrthrift@gmail.com>, pgsql-general@postgresql.org
References: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CA+dsfFT-vC-0ZBf-SECQsXhhcHnkv-AF-rDEb=C7f8XudsZm4g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/a04878d9-c137-4791-a1a7-034776b893ba%40aklaver.com>
Precedence: bulk

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