Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Dissecting SkyTools


SkyTools is not just a single script but a collection of various tools serving different purposes. Once we have installed SkyTools, it makes sense to inspect these components in more detail:

  • pgq: A generic queuing interface used to flexibly dispatch and distribute data

  • londiste: An easy-to-use tool used to replicate individual tables and entire databases on a logical level

  • walmgr: A toolkit used to manage transaction logging

In this chapter, we will discuss pgq and londiste in detail.