Update to Patroni 3.0.2

[ruifung]

**What is the motivation or use case for the change? **
Patroni 3.0.0 adds the DCS failsafe mode that allows for the postgres cluster to be able to function during temporary controlplane outages.

Describe the solution you'd like
Update to patroni 3.0.2 (latest at the time of writing)

Please tell us about your environment:

• Operating System: Talos Linux v1.4.5
• Where is this running ( Local, Cloud Provider): Local & Cloud
• Storage being used (NFS, Hostpath, Gluster, etc): Ceph & Cloud block device
• Container Image Tag: ubi8-14.7-3.3-0
• PostgreSQL Version: 14.7
• Platform (Docker, Kubernetes, OpenShift): Kubernetes
• Platform Version: 1.26.5

Additional context
I personally run modified versions of the images to add additional packages such as updated TimescaleDB w/ toolkit (2.11.0), as well as (currently) an updated patroni version (3.0.2).

By modified, I specifically mean I'm building a new image, using the existing one as a base, and running additional commands and pushing it to my own harbor instance.