Requirements
Before you can create a replication cluster, you must install Slony on every computer that will host a node. You can find Slony at the PostgreSQL's gborg web site (http://gborg.postgresql.org) or at http://slony.info. Currently, you must compile Slony yourself (at the time we are writing this, binary distributions are not available). To build Slony, you must have the following PostgreSQL components on each system:
PostgreSQL C header files (typically found in /usr/include, you can locate these files with the command pg_config —includedir)
PostgreSQL Server C header files (typically found in /usr/include/pgsql/server, you can locates these files with the command pg_config —includedir-server)
PostgreSQL client libraries (typically found ...
Get PostgreSQL, 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.