Getting Back Into Kubernetes

Things that used to be

I used to run my own OpenShift Kubernetes cluster that hosted most of my Homelab. I dabbled with the technology for quite some time, trying different installation methods like manual setups, kubespray, Ansible playbooks, and the Ansible-based OpenShift 3.x installer. I experimented with various Kubernetes distributions, including Vanilla K8s, OpenShift, and RKE/Rancher, on different host OSs like Rancher OS, Fedora Atomic, CoreOS, and Fedora 24ish. However, most of these options are no longer maintained.

Recently while browsing some forums i stumbled across a forum post about how usable the AMD Instinct MI25 is for Stable Diffusion thanks to its 16GB of HBM2 Memory and affordable price of at the time ~90 USD. So needless to say i wanted one of these cards as this seemed like a fun Weekend project. Thanks to German ebays ludicrously insane prices (899€ for used MI25 cards… 🤦) i imported 2 cards from the US via ebay, 2 cards just in case i managed to break one *foreshadowing intensifies*.

One thing i regularly look up is how to create a new Postgres User & DB. So here are the two ways to create a User and Database.

The CLI Way

Postgres has many helpful Utilities for some common operations.

Like for creating a User (the -P will Prompt for a Password):

1sudo -u postgres createuser -P gitea

And creating a Database with assigned permissions:

1sudo -u postgres createdb --owner gitea gitea_db

You can add --echo to those commands to see the actual SQL that is send to the Database.