Database Administration & Monitoring temBoard on SLES15 – 1 – The WebUI 01.04.2021 by Daniel Westermann During our last SwissPUG online meeting there was a presentation about monitoring PostgreSQL with temBoard. A question that came up afterwards was: How to install that on SLES 15 as there(…)
Database Administration & Monitoring PostgreSQL 14: LZ4 compression for TOAST 22.03.2021 by Daniel Westermann In PostgreSQL a row or tuple can not span multiple pages (a page is typically 8kB), but of course you can store larger rows and PostgreSQL brakes and compresses these rows into smaller chunks by using a technique called(…)
Database Administration & Monitoring Getting started with the Zalando Operator for PostgreSQL 13.03.2021 by Daniel Westermann In the previous posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes, Rancher, up and running, on(…)
AWS, Cloud, DevOps, Docker, Kubernetes Deploying a Kubernetes cluster on EC2 with Rancher 12.03.2021 by Daniel Westermann Once Rancher is up and running, it makes the deployment and management of Kubernetes clusters quite easy. In this post we'll deploy a brand new cluster on top of EC2. If you want to have a simple(…)
Database Administration & Monitoring, DevOps, Docker, Kubernetes Rancher on SLES 15 as a demo environment 10.03.2021 by Daniel Westermann If you followed the last posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes and Rancher,(…)
AWS, DevOps, Docker, Kubernetes Rancher, up and running, on EC2 – 3 – Rancher setup 10.03.2021 by Daniel Westermann The is the next post in this little Rancher series. After we installed a single node RKE cluster and extended this configurtation to three nodes we will finally install Rancher in this post.
AWS, Database Administration & Monitoring, Docker, Kubernetes Rancher, up and running, on EC2 – 2 – Three nodes 09.03.2021 by Daniel Westermann In the last post we've brought up a RKE Kubernetes cluster on a single node. While that is cool for demonstration purposes or testing, this is nothing for a real life setup. Running the control pane, the(…)
AWS, DevOps, Kubernetes Rancher, up and running, on EC2 – 1 – One node 07.03.2021 by Daniel Westermann If you want to play with Rancher you have several options, as outlined in the documentation. There are quick starts for the major public cloud providers (using Terraform), you can install(…)
Database Administration & Monitoring Be careful with prepared transactions in PostgreSQL 26.02.2021 by Daniel Westermann PostgreSQL gives you the possibility for two-phase commit. You'll might need that if you want an atomic distributed commit. If you check the PostgreSQL documentation there is a clear warning about using these kind(…)
Database Administration & Monitoring [Data]nymizer – Data anonymizer for PostgreSQL 25.02.2021 by Daniel Westermann Often there is the requirement to populate a test or development database with data from production, but this comes with a risk: Do you really want, that developers or testers have access to sensitive data? In a lot of companies(…)