Jump to ratings and reviews
Rate this book

PostgreSQL Replication

Rate this book
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. "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.

252 pages, Kindle Edition

First published July 26, 2013

1 person is currently reading
11 people want to read

About the author

Zoltán Böszörményi

34 books2 followers
Zoltan Biszormenyi is a Romanian-Hungarian poet, writer and editor.

His early poetic efforts were published in Napsugár, a children's magazine while he was still in school, but his career as a poet got started in Kolozsvár under the mentorship of poets Aladár Lászlóffy, Sándor Kányádi, Tibor Bálint és Sándor Fodor. His early poems and reports appeared on the pages of Ifjúmunkás, Előre, Korunk, Utunk, Művelődés, all Hungarian language publications in Romania. In Toronto he produced and broadcast a weekly one-hour Hungarian radio program. For two years he was a correspondent for CBC (Canadian Broadcasting Corporation).

His first volume of poem, Örvényszárnyon, came out in 1979 and the second, Címjavaslatok, in 1981, both in Bucharest.

Presently he is the proprietor of Nyugati Jelen, a daily Hungarian paper published in Arad for the Hungarian minority population of five counties in Romania. In addition, he is the editor-in-chief of Irodalmi Jelen , an electronic and print literary review designed to connect Hungarian minorities in diaspora with Hungary. He is also the founder (2001) of a publishing house of the same name.

Since the turn of the century his poetry books have been coming out with increased frequency and he has expanded into prose as well, producing several novels and short story collections. His prose works have been translated into several languages, including English, French, German, Russian, Polish, and Romanian.

His literary activities were rewarded with József Attila Prize in 2012.

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
9 (75%)
4 stars
2 (16%)
3 stars
0 (0%)
2 stars
1 (8%)
1 star
0 (0%)
Displaying 1 of 1 review
2 reviews
January 7, 2014
This is a really wonderful book for all people who want to learn the concepts of replication in PostgreSQL as well as differente ways to take it just. You can also learn some concepts and tools to provide high availability.
Displaying 1 of 1 review

Can't find what you're looking for?

Get help and learn more about the design.