PostgreSQL Replication und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr

Loggen Sie sich ein, um 1-Click® einzuschalten.
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Jetzt eintauschen
und EUR 8,77 Gutschein erhalten
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

Beginnen Sie mit dem Lesen von PostgreSQL Replication auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

PostgreSQL Replication [Englisch] [Taschenbuch]

Zoltan Böszörmenyi , Hans-Jürgen Schönig
4.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
Preis: EUR 41,72 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Auf Lager.
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Montag, 1. September: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 17,30  
Taschenbuch EUR 41,72  


26. August 2013

Replication is an advanced subject but this tutorial makes it so simple to assimilate thanks to a carefully structured approach based on examples and screenshots. As a PostrgreSQL administrator it will expand your horizons.


  • Explains the new replication features introduced in PostgreSQL 9
  • Contains easy to understand explanations and lots of screenshots that simplify an advanced topic like replication
  • Teaches PostgreSQL administrators how to maintain consistency between redundant resources and to improve reliability, fault-tolerance, and accessibility

In Detail

PostgreSQL offers a comprehensive set of replication related features, which can be used to make your database servers more robust and way more scalable. Unleashing the power of PostgreSQL provides the user with countless opportunities and a competitive advantage over other database systems. To make things more powerful, PostgreSQL can be used in conjunction with a handful of sophisticated tools serving various different needs such as queuing, logical replication, or simplified transaction log handling.

"PostgreSQL Replication" is a practical, hands-on guide to PostgreSQL replication. It will provide you with the theoretical background as well as simple examples showing you how to make replication work on your system. A broad toolchain will be presented along with mature PostgreSQL-core technology.

"PostgreSQL Replication" starts with an introduction to replication concepts as well as the physical limitations of different replication solutions. You will be guided through various techniques such as Point-In-Time-Recovery, transaction-log-based replication and you will be introduced to a set of replication-related tools. In the final chapter you will learn to scale PostgreSQL to many different servers using PL/Proxy.

You will learn how to reset PostgreSQL to a certain point in time and figure out how to replicate data in many ways. You will deal with both synchronous as well as asynchronous replication. In addition to that, the book covers important topics, such as Slony, and upgrades with virtually no downtime. We will also cover important performance-related topics to make sure your database setups will provide you with high speed AND high availability.

"PostgreSQL Replication" contains all the information you need to design and operate replicated setups. You will learn everything you need to know for your daily work and a lot more.

What you will learn from this book

  • Recover a PostgreSQL database to a certain point in time
  • Set up asynchronous and synchronous streaming replication
  • Handle transaction log files efficiently
  • Learn about Linux High Availability
  • Get to grips with Slony replication
  • Get PL/Proxy to scale infinitely
  • Understand pgpool and pgbouncer to improve speed and reliability
  • Perform fast on-the-fly backups
  • Increase reliability and throughput
  • Improve data security and geographically distribute data


This book has a chapter dedicated to each aspect of replication. The new features of PostgreSQL 9 are introduced and there are lots of practical examples and screenshots.

Wird oft zusammen gekauft

PostgreSQL Replication + PostgreSQL 9.0 High Performance
Preis für beide: EUR 78,92

Die ausgewählten Artikel zusammen kaufen
  • PostgreSQL 9.0 High Performance EUR 37,20

Kunden, die diesen Artikel gekauft haben, kauften auch


  • Taschenbuch: 250 Seiten
  • Verlag: Packt Publishing (26. August 2013)
  • Sprache: Englisch
  • ISBN-10: 1849516723
  • ISBN-13: 978-1849516723
  • Größe und/oder Gewicht: 1,3 x 18,8 x 23,1 cm
  • Durchschnittliche Kundenbewertung: 4.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)
  • Amazon Bestseller-Rang: Nr. 128.810 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)


Über den Autor und weitere Mitwirkende

Zoltan Böszörmenyi

Zoltan Böszörmenyi has over 15 years experience in the software development and IT industry. He started working with PostgreSQL in 1995 and has since been working exclusively developing and implementing solutions using it. Among many other things, he has extended ECPG, the embedded SQL-in-C flavor in PostgreSQL. He has also developed unique solutions for POS hardware. He also occasionally does training on PostgreSQL. He has held senior-level positions but now serves as the CTO of Cybertec Schönig & Schönig GmbH.

Hans-Jürgen Schönig

Hans-Jürgen Schönig has 15 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called "Cybertec Schönig & Schönig GmbH" (, which has successfully served countless customers around the globe.

Before founding Cybertec Schönig & Schönig GmbH in the year 2000, he worked as database developer at a private research company focusing on the Austrian labor market where he was primarily focusing on data mining and forecast models.

He has written several books dealing with PostgreSQL already.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Rückseite
Hier reinlesen und suchen:


4 Sterne
2 Sterne
1 Sterne
4.0 von 5 Sternen
4.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Short Review 9. Dezember 2013
The book starts out by taking a cursory look at the theoretical foundations of database replication like the impact of communication delays caused by physical distance among other things. This is followed by a detailed introduction of the different types of replication, in particular of synchronous and asynchronous replication and sharding.

Continuing on with an in depth look into the technical intrinsics of PostgreSQL, the author explains clearly the technology behind WAL and thus the technical foundation of the replication solutions that already come with PostgreSQL, namely PITR and streaming replication.

Hands on guides to aide in the actual setup of the various solutions coupled with solutions to common setup problems round off the topic.
Monitoring and high availability aspects, so important for real life applications, are also covered.

The final chapters cover additional systems for replication and sharding that are not themselves part of the PostgreSQL software distribution, such as pgbounce, pgpool, Slony, Skytools and PL/Proxy.

The book is suitable both beginners wanting to start out with a well explained in-depth look into the workings of WAL/PostgreSQL as well as experienced database administrators looking to verify their existing setups and to get pointers for further optimizations.
War diese Rezension für Sie hilfreich?
3.0 von 5 Sternen A good Textbook 18. März 2014
Format:Kindle Edition|Verifizierter Kauf
After I've had some experience with replication in a broader manner, and a bit more with various other relational Database Management systems, I got a job on my favourite DBMS, PostgreSQL. I bought this book not as a layman and my expectations were accordingly. This book is not a complete documentation about all configuration options, I did not expect. It is also not a complete survey of all possible products available on the topic, this I think rather impossible within open source products. But something I was not expected is, that this book reviews the most essential theoretical basics, everyone should know on replication. Further, the book is guiding through a series of rather practical configuration schemes, all with working examples. At that point, I found it much like a textbook for some university lectures, written in a clear and understandable style, giving the necessary theoretical background to the practical, working example.
On the other hand, authors describe some 3rd party products, e. g. pgPool2, and how to utilise them in PostgreSQL replication, but the description is limited to the most basic configuration cases without any practical point of view for large scale installations. Also, I was missing a summary of the examples, which could provide a view to the complete setup. The Kindle edition, which I've bought, suffers from some layout issues with tables and code snippets, nevertheless, it is still good readable.

All in all, I would recommend this book to all, to those who will have a first touch with replication as well, as to those who have already experiences on the topic. This book could be a good entry and will help understand the many other configuration options.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf (beta) 3.7 von 5 Sternen  7 Rezensionen
2 von 2 Kunden fanden die folgende Rezension hilfreich
1.0 von 5 Sternen Highly recommend that you stick to the postgresql manual 20. Januar 2014
Von Anu Menon - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
This book to me, acts as a good index of all the material to read to understand replication. Nothing more than that. The book is absolutely not meant to guide you through an actual production implementation.

A good portion of the book is a copy of the postgresql manual. If I knew this before hand, I would have just stayed with reading the official manuals.
1 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Broad coverage of PG replication topics 12. November 2013
Von J. Lawson - Veröffentlicht auf
Format:Kindle Edition
"PostgreSQL Replication" is a great book to introduce you to the variety of replication techniques available to modern PG 9.0+ deployments, including coverage of their major strengths and weaknesses. After introducing the basic replication and logging concepts, the remaining chapters cover native streaming replication in synchronous and asynchronous mode, Linux HA, pgbouncer, pgpool, Slony, Skytools, Postgres-XC, and PL/Proxy. Each chapter walks you through deploying a fresh install of one of the replication methods, the basic configuration parameters available, and how to verify the proper operation of that particular technique. Some coverage of the scalability and performance limitations of each method is provided, allowing you to choose the one that balances the capabilities, flexibility, and complexity that is appropriate for your deployment.

Although the book does try to provide wide coverage of the diverse topics involved, it also suffers because it is unable to cover any of them very deeply, rendering it useful for only superficial introduction to each method. Longer-term operational tips, advanced features, troubleshooting, and performance tuning information that would be needed for any serious users is very minimal, so you will need to be prepared to consult other references. Generally the book assumes you are already familiar with installing and using PostgreSQL from the command-line, and are comfortable compiling and editing configuration files for programs distributed in tarballs. Most of the text is pretty OS agnostic, but it is clear that sometimes Mac OS X and sometimes Linux were used to create the examples in the book (the Linux-HA chapter is mostly Linux specific, and Debian-specific install commands are sometimes also offered for convenience).

However, keeping in mind those technical limitations of the book, it still does a very admirable attempt to give the reader enough information to be aware of what is possible with PostgreSQL replication and make a selection appropriate for your project. It's definitely worth the read if you're unsure which technique you should be using for your replication needs.
1 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Nice introductory book 25. Oktober 2013
Von Igor A. Polishchuk - Veröffentlicht auf
This book covers a variety of different replication solutions. It also very briefly covers some concepts not directly related to replication, but nice to know, such as CAP theorem, speed of light problem, or Linux HA. However, given the limited size of the book, all topics are discussed fairly briefly. In case of Linux HA, it actually made the explanation less than clear. I personally would exclude Linux HA from the book to save some space for more replication topics. The book gives short introductions into a few replication solutions, enough to understand how to set up a minimal replication configuration. However, this book may only be a starting point in your study of the Postgresql replication. It won't make you proficient enough to support each replication solution in production. It would be nice to see more information on some less known tricks, troubleshooting, and monitoring. Unfortunately, the authors left out Buccardo, probably the third most popular trigger based replication solutions, but they sure have the first two most popular - Slony and Londiste. It was curious to read about Postgres-XC; though, it is not very practical, because the product is not quite mature yet to be widely used in production.
In conclusion, this is a great book for a novice Postgresql administrator who wants to get an idea about wide range of different replication solutions. It also may be nice for an experienced user who is not familiar with a particular replication solution and would like to get a general idea about it.
Overall, it was a nice reading, simple language, mostly very clear.
3.0 von 5 Sternen Reasonable overview of PostregSQL replication and availability 1. Februar 2014
Von Anon - Veröffentlicht auf
Format:Kindle Edition|Verifizierter Kauf
This is more of an overview of the approaches available. Lacks depth from a technical or operational perspective. Worth buying on kindle if you need an introduction to this topic. It's an easy read and will provide the basics.
5.0 von 5 Sternen Great and interesting book. 8. Dezember 2013
Von Nabil Servais - Veröffentlicht auf
The authors explore all solutions to replicate your postgresql installation, explain the advantages and the inconvenient of each solutions.
All possibilities are explored and detailled.
The "how to" are well documentated. If you have to make replications even if you are an expert, this book can help you.

This is the reference
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden

Ihr Kommentar