Re: pg_dump throwing segfault error during backup

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(dot)klaver(at)aklaver(dot)com