Re: PG 12.2 ERROR: cannot freeze committed xmax

[bruno vieira da silva]

Thanks Ron.

I did find one bug fix commit mentioning this error but it was saying that
was due to the interaction of two other commits that at least the first one
was after the cut of pg 12.2. so I have dismissed that as my deployment
issue.

I was looking for more evidence to push for a pg minor upgrade, the issue
is for my context any upgrades requires a big test effort. so I was looking
for more solid evidence.


On Thu, May 23, 2024 at 7:17 PM Ron Johnson  wrote:

> On Thu, May 23, 2024 at 9:41 AM bruno da silva 
> wrote:
>
>> Hello,
>> I have a deployment with PG 12.2 reporting ERROR: cannot freeze
>> committed xmax
>> using Red Hat Enterprise Linux 8.9.
>>
>> What is the recommended to find any bug fixes that the version 12.2 had
>> that could have caused this error.
>>
>
> https://www.postgresql.org/docs/release/
>
> You're missing *four years* of bug fixes.
>
> Could this error be caused by OS/Hardware related issues?
>>
>
>  Four years of bug fixes is more likely the answer.
>
>

-- 
Bruno Vieira da Silva

how to tell if a pg version supports a linux distribution

[bruno vieira da silva]

Hello, if a pg version has been tested on the buildfarm but the pg yum
repository doesn't have packages for a linux distribution that means that
distribution isn't supported by pg? how can I find if linux distributions
for a pg version have regression tests executed against.

e.g. : postgresql 16 doesn't have packages on yum for centos 7 but I can
find tests on the buildfarm for it.

https://buildfarm.postgresql.org/index.html

Thanks

-- 
Bruno Vieira da Silva

data checksums

[bruno vieira da silva]

Hello.
I've been dealing with some database corruption events, so i've been
wondering to enable data checksums on my deployments.

so my question is why data checksums aren't enabled by default on pg? the
pg doc
mentions a considerable performance penality, how considerable it is?

Thanks
-- 
Bruno Vieira da Silva