Re: Validation of db post minor upgradation

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: vignesh kumar <vigneshkumar(dot)venugopal(at)outlook(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Validation of db post minor upgradation
Date: 2024-03-20 07:08:53
Message-ID: CAJk5AtZs6kwi6ZmG-1kpb-3tU9GFU3wjfNmNHeZje5KNbzEqdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I think it's not possible to perform pg_upgrade check in operator platform
like openshift.

We are simply changing the image tags in yaml and applying it.

On Wed, 20 Mar 2024, 12:19 vignesh kumar, <
vigneshkumar(dot)venugopal(at)outlook(dot)com> wrote:

> Just you need to go through the release notes of both the versions and
> validate them accordingly. Upon my experience that's the best known method
> to validate things. Again it depends whether you wanted to do a data
> validation of the admin level validation ( considering only the file system
> level changes or binary upgrades if any). Pg_upgrade should infact take
> care of the upgrade. That's why it's better to do a pg_upgrade check before
> doing actual upgrade.. hope this helps.
>
> Get Outlook for Android <https://aka.ms/AAb9ysg>
> ------------------------------
> *From:* Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> *Sent:* Wednesday, March 20, 2024 11:41:28 AM
> *To:* Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Validation of db post minor upgradation
>
> Hi all,
>
> Is there any validation to be performed in database after upgrading
> postgres version from 15.2 to 15.6 ?
>
> I am using openshift env.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vignesh kumar 2024-03-20 07:14:55 Re: Validation of db post minor upgradation
Previous Message vignesh kumar 2024-03-20 06:57:05 Re: Log file retention