[fredthestair]

Snowflake sounds like nominative determinism. I was just looking at this thing today, totally puzzled as to how to update it and postgres itself without rolling dice that it destroys everything on the cluster that uses postgres. Perhaps someone with k8s experience could explain to me why CRDs are not Singleton hell? The LLMs just run me in circles..

[antibios]

I run a two service cluster in the home lab for fun. I use PVC mapped to a NFS share for the actual data so you could always run a local postgres binary against it. In a production environment I would map these to local disk partitions like you would normally do for a db.

The upgrade process is actually quite nice when it works but it is "another" thing to learn and troubleshoot.

I think of CRDs as a troubleshooting flowchart that someone with more experience than me has put together. When it's right it's great and when it's wrong it makes trouble shooting harder. That is until you remember that the whole point of k8s is ephemeral containers. When one breaks just delete it and let pgcluster CRD resync the data.