Search results for postgres install source code

Install a single node Kubernetes cluster with SUSE RKE2 and deploy your own YaK instance

I bought a mini PC last year and I use it as a home lab to test things and play around.So I thought, why not install a RKE2 Kubernetes cluster and deploy my own YaK instance on it? Let’s dive-in.

Using dlt to get data from Db2 to PostgreSQL

For a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is usually(…)

PostgreSQL 17-18 major upgrade – blue-green migration with minimal downtime

As PostgreSQL 18 Beta 1 has been released (link) and is packed with lots of cool features like improved IO on reads for example, I wanted to test out the new pg_createsubscriber and pg_upgrade options and how they are(…)

YaK Core – The Holy Grail for Deploying Ansible Code Everywhere

YaK core Multi-Platform open source Automation Tool simplifies the deployment of Ansible playbooks through a clean UI and API. It offers an intuitive interface where users can upload playbooks, configure parameters, and deploy them seamlessly across various platforms, and(…)

Offloading PostgreSQL Backups to Azure Blob Storage Using PGBackRest, Managed Identity, and SAS Tokens

Introduction One of the nice things with cloud providers is the low costs of their storage. Whenever you want to optimize your long-term backups and push them on Azure, you might face a wall of questions on how to do(…)

PostgreSQL: Maybe we should give ZFS a chance (1) – baseline

Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different.

PostgreSQL Conference Europe 2024 – Day 2

Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next day of(…)

Enhancing PostgreSQL Performance with Index Advisor and HypoPG

In database management, query performance is critical for efficient data retrieval. PostgreSQL, a powerful open-source database, offers various extensions to optimize and tune query performance. Two such extensions are Index Advisor and HypoPG. These tools help database administrators (DBAs) identify(…)

PostgreSQL: pg_dump and extension ownership

While pg_dump must not be considered a backup tool (please use physical backups for this), it is widely used to dump and reload data. One of the main advantages is, that you can do this across major versions of(…)

Getting started with Greenplum – 1 – Installation

Because PostgreSQL is fully open source there are many forks of it. One of them is called Greenplum which describes itself as “an advanced, fully featured, open source data warehouse, based on PostgreSQL”. Sounds interesting, so(…)