K8SPG-254: Fix major upgrade on Openshift

[egegunes]

CHANGE DESCRIPTION

Problem:

create PGUpgrade: pgupgrades.postgres-operator.crunchydata.com "12-to-13" is forbidden: cannot set blockOwnerDeletion if an ownerReference refers to a resource you can't set finalizers on: , <nil>

Cause: Operator needs to permission to upgrade PerconaPGUpgrade finalizers.

Solution: Add permission.

CHECKLIST

Jira

• [x] Is the Jira ticket created and referenced properly?
• [x] Does the Jira ticket have the proper statuses for documentation (Needs Doc) and QA (Needs QA)?
• [x] Does the Jira ticket link to the proper milestone (Fix Version field)?

Tests

• [x] Is an E2E test/test case added for the new feature/change?
• [x] Are unit tests added where appropriate?

Config/Logging/Testability

• [x] Are all needed new/changed options added to default YAML files?
• [x] Did we add proper logging messages for operator actions?
• [x] Did we ensure compatibility with the previous version or cluster upgrade process?
• [x] Does the change support oldest and newest supported PG version?
• [x] Does the change support oldest and newest supported Kubernetes version?

[JNKPercona]

Test name	Status
custom-extensions	passed
demand-backup	passed
init-deploy	passed
major-upgrade	passed
monitoring	passed
one-pod	passed
operator-self-healing	passed
pitr	passed
scaling	passed
scheduled-backup	passed
self-healing	passed
start-from-backup	passed
tablespaces	passed
telemetry-transfer	passed
upgrade-consistency	passed
upgrade-minor	passed
users	passed
We run 17 out of 17

commit: https://github.com/percona/percona-postgresql-operator/pull/826/commits/b9a3ccd5e91989eaf85bc2be23be2f93f8835bf2 image: perconalab/percona-postgresql-operator:PR-826-b9a3ccd5e