Conference Schedule - PGConf.EU 2022

PostgreSQL on Linux, up and running

Date: 2022-10-25
Time: 09:00 - 17:00
Room: Zurich 2
Level: Intermediate

PostgreSQL database on Linux operating system has been and remains the industry default open-source ecosystem for many years.This setup has proven itself as a very reliable combo, and with correct planning, appropriate configuration and proper everyday operation performs really well.In this training, I will talk participants though the full installation and configuration circle of the ecosystem, share best practices and will review a real-life aspect of the ecosystem with use cases and planning.

Starting with planning – we will review which Linux distribution to choose, pros, and cons related to PostgreSQL. We will then consider kernel version, filesystem choice and configuration.

In addition to taking you through the standard Linux for PostgreSQL tuning process using systemctl parameters checklist, I will also share several practices that our DBA, at Data Egret, use when configuring a new server. We will take a closer look at these practices and review why they have proven themselves as beneficial for increased performance and data safety.

We will then move onto the planning part when we go through the everyday operations cycle and discuss how to install PostgreSQL-related packages, which additional packages are required or could be helpful, how to upgrade them, and how to install and configure PostgreSQL itself.

This final part will include review of Linux tools and utilities, which are essential part of PostgreSQL DBA everyday life.At the end of this workshop you will be able to make more calculated decisions in the process of Postgres on Linux installation, its configuration, upgrade processes and overall management of the cluster. If you are already working with Postgres and would like a more systematical review with real life examples this workshop is for you


Ilya Kosmodemiansky