From: | Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> |
---|---|
To: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
Cc: | "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 08:52:34 |
Message-ID: | CAAPsdhdBx+c1-9k+sOvjc4TuZsLEgPnfHOsnipb_E-M3=8E76A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi
On Tue, Aug 27, 2024 at 1:50 PM Ram Pratap Maurya <
ram(dot)maurya(at)lavainternational(dot)in> 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.
>
>
>
> Below process showing :
>
>
>
> *2313192 | 02:10:01.283176 | | myLava | active |
> autovacuum: VACUUM ANALYZE public.tstock_movement (to prevent wraparound)*
>
>
>
> And one more issue we are facing after upgrade lot of alert is coming in
> DB log file , please suggest this is bug in Postgresql-15 version.
>
>
>
> *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.*
>
> *2024-08-26 00:00:36.784 IST [702937] WARNING: oldest xmin is far in the
> past*
>
> *2024-08-26 00:00:36.784 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.*
>
These are warnings not error, can you please share the error you are
getting.
Thanks
Kashif Zeeshan
>
>
> *DB OS -RHEL8.*
>
>
>
>
>
> Regards,
>
> Ram Pratap.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Domen Šetar | 2024-08-27 09:12:06 | RE: Unexpected authentication behaviour |
Previous Message | Ram Pratap Maurya | 2024-08-27 08:50:36 | After DB upgrade from PG13 to PG15 showing error |
From | Date | Subject | |
---|---|---|---|
Next Message | Shyam Duraiswami | 2024-08-27 09:36:30 | Analytics on PostgresQL Advisory |
Previous Message | Ram Pratap Maurya | 2024-08-27 08:50:36 | After DB upgrade from PG13 to PG15 showing error |