PostgreSQL Replication, Second Edition
Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast
Published on 7. October 2025
322 pages
978-1-78398-854-9 (ISBN)
Description
Key Features
Book DescriptionThis book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.What you will learn
Use Pointintime Recovery to perform data recovery as well as replication
Set up synchronous as well as asynchronous streaming replication
Get familiarized with the transaction log, the core component of most replication setups and its purpose
Improve speed and reliability with an understanding of pgpool and PgBouncer
Increase your data security and geographically distribute data
Make your systems more available and secure with Linux High Availability
Scale out with PL/Proxy and PostgresXC
Detect, investigate, and solve replicationrelated problems
Who this book is forThis book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.
Book DescriptionThis book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.What you will learn
Use Pointintime Recovery to perform data recovery as well as replication
Set up synchronous as well as asynchronous streaming replication
Get familiarized with the transaction log, the core component of most replication setups and its purpose
Improve speed and reliability with an understanding of pgpool and PgBouncer
Increase your data security and geographically distribute data
Make your systems more available and secure with Linux High Availability
Scale out with PL/Proxy and PostgresXC
Detect, investigate, and solve replicationrelated problems
Who this book is forThis book is ideal for PostgreSQL administrators who want to set up and understand replication. By the end of the book, you will be able to make your databases more robust and secure by getting to grips with PostgreSQL replication.
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Digital original
File size
2,99 MB
ISBN-13
978-1-78398-854-9 (9781783988549)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Hans-Jürgen Schönig
PostgreSQL Replication - Second Edition
Book
07/2015
Packt Publishing
€56.30
Shipment within 3-4 weeks
Person
Hans-Juergen Schoenig has 25 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called CYBERTEC PostgreSQL International GmbH, which has successfully served countless customers around the globe. Before founding CYBERTEC PostgreSQL International GmbH in 2000, he worked as a database developer at a private research company that focused on the Austrian labor market, where he primarily worked on data mining and forecast models. He has also written several books about PostgreSQL.
Content
Table of Contents
Understanding Replication Concepts
Understanding the PostgreSQL Transaction Log
Understanding Point-In-Time-Recovery
Setting up Asynchronous Replication
Setting up Synchronous Replication
Monitoring Your Setup
Understanding Linux High Availability
Working with pgbouncer
Working with pgpool
Configuring Slony
Using Skytools
Working with Postgres-XC
Scaling with PL/Proxy
Working with BDR
Working with Walbouncer
Understanding Replication Concepts
Understanding the PostgreSQL Transaction Log
Understanding Point-In-Time-Recovery
Setting up Asynchronous Replication
Setting up Synchronous Replication
Monitoring Your Setup
Understanding Linux High Availability
Working with pgbouncer
Working with pgpool
Configuring Slony
Using Skytools
Working with Postgres-XC
Scaling with PL/Proxy
Working with BDR
Working with Walbouncer
