Month: May 2023

Enterprise PostgreSQL Solutions

Introduction Recently I had an opportunity to look into deploying PostgreSQL and pgpool on Kubernetes. The deployment is straightforward, but I also need to obtain the metrics information such as CPU and memory usages that each deployed pod is using. There are several ways to do this, but today I

1. Overview This blog describes a very experimental load balance using pgpool and neon compute nodes which are based on Postgres. There are many load balance discussions using different Postgres distributions, but they are mainly based on shared-nothing. The load balance setup discussed here is based on shared-storage using neon

Introduction This blog is aimed at beginners trying to learn the basics of PostgreSQL but already have some experience under their belt. For this tutorial, we will assume you have PostgreSQL correctly installed on Ubuntu. All of these steps were done using PostgreSQL 16 (development version) and Ubuntu 22.10. We’ll