pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedValidation of db post minor upgradation
6+ messages / 3 participants
[nested] [flat]
* Validation of db post minor upgradation
@ 2024-03-20 06:11 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rajesh Kumar @ 2024-03-20 06:11 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Validation of db post minor upgradation
@ 2024-03-20 06:49 vignesh kumar <vigneshkumar.venugopal@outlook.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: vignesh kumar @ 2024-03-20 06:49 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Validation of db post minor upgradation
@ 2024-03-20 07:08 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: vignesh kumar <vigneshkumar.venugopal@outlook.com>
1 sibling, 1 reply; 6+ messages in thread
From: Rajesh Kumar @ 2024-03-20 07:08 UTC (permalink / raw)
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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.
>
> Get Outlook for Android <https://aka.ms/AAb9ysg;
> ------------------------------
> *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.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Validation of db post minor upgradation
@ 2024-03-20 07:14 vignesh kumar <vigneshkumar.venugopal@outlook.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: vignesh kumar @ 2024-03-20 07:14 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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..
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
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<mailto: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.
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Rajesh Kumar <rajeshkumar.dba09@gmail.com<mailto:rajeshkumar.dba09@gmail.com>>
Sent: Wednesday, March 20, 2024 11:41:28 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org<mailto: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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Validation of db post minor upgradation
@ 2024-03-20 09:46 Michael Banck <mbanck@gmx.net>
parent: vignesh kumar <vigneshkumar.venugopal@outlook.com>
1 sibling, 1 reply; 6+ messages in thread
From: Michael Banck @ 2024-03-20 09:46 UTC (permalink / raw)
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>; +Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi,
On Wed, Mar 20, 2024 at 06:49:47AM +0000, vignesh kumar wrote:
> 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.
pg_upgrade is for major upgrades. This thread is about minor/maintenance
upgrades if I understood correctly.
Michael
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Validation of db post minor upgradation
@ 2024-03-21 10:34 vignesh kumar <vigneshkumar.venugopal@outlook.com>
parent: Michael Banck <mbanck@gmx.net>
0 siblings, 0 replies; 6+ messages in thread
From: vignesh kumar @ 2024-03-21 10:34 UTC (permalink / raw)
To: Michael Banck <mbanck@gmx.net>; +Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Ok i see your concern. Minor upgrade just need replacing binaries with newer ones. Which changing the image tag will do the work for you. Eventually you need to know what are all the changes that went through from previous minor build version to new ones so that you can test that particular component
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: Michael Banck <mbanck@gmail.com> on behalf of Michael Banck <mbanck@gmx.net>
Sent: Wednesday, March 20, 2024 3:16:00 PM
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>
Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Validation of db post minor upgradation
Hi,
On Wed, Mar 20, 2024 at 06:49:47AM +0000, vignesh kumar wrote:
> 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.
pg_upgrade is for major upgrades. This thread is about minor/maintenance
upgrades if I understood correctly.
Michael
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-03-21 10:34 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-20 06:11 Validation of db post minor upgradation Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-03-20 06:49 ` vignesh kumar <vigneshkumar.venugopal@outlook.com>
2024-03-20 07:08 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-03-20 07:14 ` vignesh kumar <vigneshkumar.venugopal@outlook.com>
2024-03-20 09:46 ` Michael Banck <mbanck@gmx.net>
2024-03-21 10:34 ` vignesh kumar <vigneshkumar.venugopal@outlook.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox