Reader small image

You're reading from  PostgreSQL 16 Administration Cookbook

Product typeBook
Published inDec 2023
PublisherPackt
ISBN-139781835460580
Edition1st Edition
Right arrow
Authors (5):
Gianni Ciolli
Gianni Ciolli
author image
Gianni Ciolli

Gianni Ciolli is Vice President and Field CTO at EDB; he was Global Head of Professional Services at 2ndQuadrant until it was acquired by EDB. Gianni has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over more than 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and Open-Source software since the 1990s and is active in the community. He lives between Frankfurt and London and plays the piano in his spare time
Read more about Gianni Ciolli

Boriss Mejías
Boriss Mejías
author image
Boriss Mejías

Boriss Mejias is a Senior Solutions Architect at EDB, building on his experience as PostgreSQL consultant and trainer at 2ndQuadrant. He has been working with open source software since the beginning of the century contributing to several projects both with code and community work. He has a PhD in Computer Science from the Université catholique de Louvain, and an Engineering degree from Universidad de Chile.Complementary to his role as Solutions Architect, he gives PostgreSQL training and is a regular speaker at PostgreSQL conferences. He loves spending time with his family and playing air guitar
Read more about Boriss Mejías

Jimmy Angelakos
Jimmy Angelakos
author image
Jimmy Angelakos

Jimmy Angelakos is a Systems and Database Architect and recognized PostgreSQL expert. He studied Computer Science at the University of Aberdeen, has worked with Open-Source tools for 25+ years, is an active member of PostgreSQL Europe and occasional contributor to the PostgreSQL project. He also speaks frequently at database and Free & Open-Source Software conferences
Read more about Jimmy Angelakos

Vibhor Kumar
Vibhor Kumar
author image
Vibhor Kumar

Vibhor Kumar, Global VP at EDB, is a pioneering data tech leader. He manages a global team of engineers, optimizing clients' Postgres databases for peak performance and scalability. He advises Fortune 500 clients, including many Financial Institutes, in innovating and transforming their data platforms. His past experience spans IBM, BMC Software, and CMC Ltd. He holds a BSc in Computer Science from the University of Lucknow and a Master's from the Army Institute of Management. As a certified expert in numerous technologies, he often shares his insights on DevOps, cloud, and database optimization through blogging and speaking at events
Read more about Vibhor Kumar

Simon Riggs
Simon Riggs
author image
Simon Riggs

Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions
Read more about Simon Riggs

View More author details
Right arrow

Setting up replication with CloudNativePG

This will probably be one of the simplest recipes in this book, and it is because the automation achieved through the cloud-native operator is such that setting up replication is reduced to increase the value of the integer that describes how many instances you want to deploy in your cluster.

Getting ready

We assume for this recipe that you already have a Kubernetes environment with the CloudNativePG operator, as described in the PostgreSQL in Kubernetes recipe in Chapter 1, First Steps. In that recipe, we wrote our first manifest to deploy a single instance. In this recipe, we will increase the number of instances of the same manifest.

How to do it…

Adding more instances is as simple as editing the number of instances in the spec section of the manifest file, cluster-example.yaml. In this case, we will have 3 instances, meaning 1 primary node and 2 replicas:

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
PostgreSQL 16 Administration Cookbook
Published in: Dec 2023Publisher: PacktISBN-13: 9781835460580

Authors (5)

author image
Gianni Ciolli

Gianni Ciolli is Vice President and Field CTO at EDB; he was Global Head of Professional Services at 2ndQuadrant until it was acquired by EDB. Gianni has been a PostgreSQL consultant, trainer, and speaker at many PostgreSQL conferences in Europe and abroad over more than 10 years. He has a PhD in Mathematics from the University of Florence. He has worked with free and Open-Source software since the 1990s and is active in the community. He lives between Frankfurt and London and plays the piano in his spare time
Read more about Gianni Ciolli

author image
Boriss Mejías

Boriss Mejias is a Senior Solutions Architect at EDB, building on his experience as PostgreSQL consultant and trainer at 2ndQuadrant. He has been working with open source software since the beginning of the century contributing to several projects both with code and community work. He has a PhD in Computer Science from the Université catholique de Louvain, and an Engineering degree from Universidad de Chile.Complementary to his role as Solutions Architect, he gives PostgreSQL training and is a regular speaker at PostgreSQL conferences. He loves spending time with his family and playing air guitar
Read more about Boriss Mejías

author image
Jimmy Angelakos

Jimmy Angelakos is a Systems and Database Architect and recognized PostgreSQL expert. He studied Computer Science at the University of Aberdeen, has worked with Open-Source tools for 25+ years, is an active member of PostgreSQL Europe and occasional contributor to the PostgreSQL project. He also speaks frequently at database and Free & Open-Source Software conferences
Read more about Jimmy Angelakos

author image
Vibhor Kumar

Vibhor Kumar, Global VP at EDB, is a pioneering data tech leader. He manages a global team of engineers, optimizing clients' Postgres databases for peak performance and scalability. He advises Fortune 500 clients, including many Financial Institutes, in innovating and transforming their data platforms. His past experience spans IBM, BMC Software, and CMC Ltd. He holds a BSc in Computer Science from the University of Lucknow and a Master's from the Army Institute of Management. As a certified expert in numerous technologies, he often shares his insights on DevOps, cloud, and database optimization through blogging and speaking at events
Read more about Vibhor Kumar

author image
Simon Riggs

Simon Riggs is a Major Developer of PostgreSQL since 2004. Formerly, Simon was the Founder and CEO of 2ndQuadrant, acquired by EDB in 2020. Simon has contributed widely to PostgreSQL, initiating new projects, contributing ideas, committing many important features as well and working directly with database architects and users on advanced solutions
Read more about Simon Riggs