PostgreSQL

Creating your private cloud using OpenStack – (6) – The Networking service

We’ve finished the last post with a working Compute (Nova) service on the controller and compute node. While only the compute(s) actually run compute resources, Nova is also running on the controller for the management tasks, while libvirt is only(…)

Creating your private cloud using OpenStack – (5) – The Compute service

We’re now coming closer to the final setup of the OpenStack test environment. Again, looking at the minimum services we need, there are only three of them left: Keystone: Identity service (done)(…)

Creating your private cloud using OpenStack – (4) – The Image and Placement services

By the end of the last post we finally got the first OpenStack service up and running: Keystone, the Identity Service. Going back to the list of services we need at a(…)

Creating your private cloud using OpenStack – (3) – Keystone, the Identity Service

By the end of the last post, we finished with preparing the controller and compute node for being ready to deploy the first OpenStack service: Keystone, the Identity Service. Before we dive into the details lets(…)

Creating your private cloud using OpenStack – (2) – Preparing the nodes

In the introduction post we’ve briefly looked at some options you have available when you want to build your own private cloud. In this post we’re going to start our journey into OpenStack by preparing the(…)

Creating your private cloud using OpenStack – (1) – Introduction

While public clouds are a trend since several years now, some companies are also looking into self hosted solutions to build a private cloud. Some do this because of costs, others do this because they don’t want to be dependent(…)

JSON in PostgreSQL : a query tuning case

Over the years, ORMs have industrialized query generation, allowing developers to focus on optimizing the few queries that truly need it. However, they can sometimes produce overly complex SQL with excessive joins and business logic, making tuning a nightmare. It(…)

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 Security with Builtin Roles and functions.

Introduction As PostgreSQL continues to gain traction in enterprise-grade applications, I am increasingly tasked and asked about implementing robust security policies. And, as most current DBA positions are multi-systems nowadays, I wanted to make a quick summary on roles and(…)

PostgreSQL Conference Europe 2024 – Last day

As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community spirit,(…)