In weniger als einer Minute können Sie mit dem Lesen von PostgreSQL Replication auf Ihrem Kindle beginnen. Sie haben noch keinen Kindle? Hier kaufen oder mit einer unserer kostenlosen Kindle Lese-Apps sofort zu lesen anfangen.

An Ihren Kindle oder ein anderes Gerät senden


Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

PostgreSQL Replication [Kindle Edition]

Zoltan Boszormenyi , Hans-Jurgen Schonig
4.0 von 5 Sternen  Alle Rezensionen anzeigen (2 Kundenrezensionen)

Kindle-Preis: EUR 28,55 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Kostenlose Kindle-Leseanwendung Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.

Geben Sie Ihre E-Mail-Adresse oder Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 28,55  
Taschenbuch EUR 41,72  

Kunden, die diesen Artikel gekauft haben, kauften auch

Seite von Zum Anfang
Diese Einkaufsfunktion wird weiterhin Artikel laden. Um aus diesem Karussell zu navigieren, benutzen Sie bitte Ihre Überschrift-Tastenkombination, um zur nächsten oder vorherigen Überschrift zu navigieren.



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.


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.

Who this book is for

"PostgreSQL Replication" is ideal for PostgreSQL administrators who want to set up and understand replication. If you want to make your databases more robust, more secure, faster, and more scalable, you will find all the information you need in this single book focusing exclusively on PostgreSQL replication. It is assumed that you already have some basic experience with PostgreSQL.

Ü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.


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

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


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
4 von 5 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 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.
1 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Broad coverage of PG replication topics 12. November 2013
Von Jeff L - 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.
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
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.
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