From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: After DB upgrade from PG13 to PG15 showing error |
Date: | 2024-08-27 16:13:43 |
Message-ID: | fa535950-669c-46c3-af0c-8169912e11aa@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | manish yadav | 2024-08-27 16:30:05 | Re: Error while starting EFM |
Previous Message | Joe Conway | 2024-08-27 15:58:45 | Re: Error while starting EFM |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-08-27 16:15:41 | Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables. |
Previous Message | Greg Sabino Mullane | 2024-08-27 15:53:03 | Re: Using PQsocketPoll() for PIPELINE mode |