Book Image

PostgreSQL 13 Cookbook

By : Vallarapu Naga Avinash Kumar
Book Image

PostgreSQL 13 Cookbook

By: Vallarapu Naga Avinash Kumar

Overview of this book

PostgreSQL has become the most advanced open source database on the market. This book follows a step-by-step approach, guiding you effectively in deploying PostgreSQL in production environments. The book starts with an introduction to PostgreSQL and its architecture. You’ll cover common and not-so-common challenges faced while designing and managing the database. Next, the book focuses on backup and recovery strategies to ensure your database is steady and achieves optimal performance. Throughout the book, you’ll address key challenges such as maintaining reliability, data integrity, a fault-tolerant environment, a robust feature set, extensibility, consistency, and authentication. Moving ahead, you’ll learn how to manage a PostgreSQL cluster and explore replication features for high availability. Later chapters will assist you in building a secure PostgreSQL server, along with covering recipes for encrypting data in motion and data at rest. Finally, you’ll not only discover how to tune your database for optimal performance but also understand ways to monitor and manage maintenance activities, before learning how to perform PostgreSQL upgrades during downtime. By the end of this book, you’ll be well-versed with the essential PostgreSQL 13 features to build enterprise relational databases.
Table of Contents (14 chapters)
12
About Packt

Starting Patroni as a service using systemd

A server crash or a restart requires that we start Patroni manually. This may cause additional downtime for the application. For this purpose, a systemd service that auto-starts Patroni upon a crash or restart is needed. In this recipe, we shall look at the Patroni service file that can be enabled to manage Patroni using services.

Getting ready...

The systemd service we will be discussing in this recipe works for almost all the latest Linux operating systems where systemd works. Creating or managing services requires root access.

How to do it...

We will start Patroni using systemd. Let's get started:

  1. Create a patroni.service file in the usual systemd service files location with the following text:
# vi /usr/lib/systemd/system/patroni.service
  • Append the following text to the preceding file:
# This is an example systemd config file for Patroni
# You can copy it to "/usr/lib/systemd/system/patroni.service"
[Unit]
Description=Runners...