Re: Validation of db post minor upgradation

Поиск
Список
Период
Сортировка
От vignesh kumar
Тема Re: Validation of db post minor upgradation
Дата
Msg-id MN0PR20MB49124081DCE860A83228DAC387332@MN0PR20MB4912.namprd20.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Validation of db post minor upgradation  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Список pgsql-admin
End of the day it's the postgres image that matters from which version you are upgrading.. OCI will just be a top layer to keep container operating..



From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Sent: Wednesday, March 20, 2024 12:38:53 PM
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Validation of db post minor upgradation
 
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.venugopal@outlook.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.


From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Sent: Wednesday, March 20, 2024 11:41:28 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Re: Validation of db post minor upgradation
Следующее
От: M Sarwar
Дата:
Сообщение: RE: Aws RDS official certification