Getting Back Into Kubernetes
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.
Stable Diffusion with a AMD Instinct MI25
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*.
Postgres Creating new User & Database
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.