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 datalondiste
: An easy-to-use tool used to replicate individual tables and entire databases on a logical levelwalmgr
: A toolkit used to manage transaction logging
In this chapter, we will discuss pgq
and londiste
in detail.
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.