public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Ram Pratap Maurya <[email protected]>
To: '[email protected]' <[email protected]>
Subject: Re: After DB upgrade from PG13 to PG15 showing error
Date: Tue, 27 Aug 2024 09:13:43 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <KL1PR0601MB4433A16CA91281FA92612A70F0942@KL1PR0601MB4433.apcprd06.prod.outlook.com>
References: <KL1PR0601MB4433D6A72DE1CA03D9D6F75DF0F39@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<[email protected]>
<KL1PR0601MB443325E8306395D5428BAC04F0F29@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<KL1PR0601MB44331424CA913E84AAEB9087F0F29@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<KL1PR0601MB44337E6BE959E78CEB3D1D0BF03FA@KL1PR0601MB4433.apcprd06.prod.outlook.com>
<KL1PR0601MB4433A16CA91281FA92612A70F0942@KL1PR0601MB4433.apcprd06.prod.outlook.com>
On 8/27/24 01:50, Ram Pratap Maurya wrote:
> Dear Team,
>
> We have upgraded PostgreSQL DB from version 13 to 15 version .
>
> We are facing issue in PG15 we not enable any parameter related to
> AUTOVACUUM , but still running on PG15 data base.
You need to provide more detail about the above.
What parameters are you trying to change?
Do you get an error?
Did you reload/restart the server after the changes?
What user did you do the changes as?
> *2024-08-26 00:00:36.783 IST [702937] WARNING: oldest xmin is far in
> the past*
>
> *2024-08-26 00:00:36.783 IST [702937] HINT: Close open transactions
> soon to avoid wraparound problems.*
>
> * You might also need to commit or roll back old prepared
> transactions, or drop stale replication slots.*
I would say the above is pointing you at possible solutions.
To understand why this is important:
https://www.postgresql.org/docs/16/routine-vacuuming.html
Read the following sections:
25.1.5. Preventing Transaction ID Wraparound Failures
25.1.6. The Autovacuum Daemon
>
> Regards,
>
> Ram Pratap.
>
--
Adrian Klaver
[email protected]
view thread (3+ messages)
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: After DB upgrade from PG13 to PG15 showing error
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