Remove PVCs during MajorVersion Upgrade if PostgreSQL has more than one instance
As I spoke on Slack with Matheo: https://stackgres.slack.com/archives/C014UGLAD9R/p1746621217138469
Problem is repreducible and straightforward:
- Create PostgreSQL with 3 instances
- Scale to 1 instance
- Perform MajorVersion Upgrade
- Scale back to 3 instances
- Enjoy broken instances
The resolution is pretty simple - removing PVCs belonging to additional instances. Could You please add such funtionality to MajorVersionUpgrade process, so it detecs additional PVCs and cleans them up?