slony1v2 - PostgreSQL master to multiple replicas replication system
||FreeBSD Ports Quarterly i386
Slony-I is enterprise-level "master to multiple slaves"
replication system with cascading and failover.
The big picture for the development of Slony-I is to build
a master-slave system that includes all features and
capabilities needed to replicate large databases to a
reasonably limited number of slave systems.
Slony-I is developed as a system for data centers and backup
sites, where the normal mode of operation is that all nodes
Differences from 1.2 stream
- Removal of TABLE ADD KEY
- It drops all support for databases prior to PostgreSQL version 8.3.
- DOCS: on
- PERLTOOLS: off
Please read the docs on configuring and running slony-1.
Unless you did not specify the DOCS options, they are in the
The script /usr/local/sbin/slon-mkservice can be used to create a control
directory to run and monitor the slon daemon under svscan from daemontools.
If you use this, be sure not to set slon_enable="YES" in /etc/rc.conf.
If you prefer to use the standard startup script in /usr/local/etc/rc.d then
set slon_enable="YES" in /etc/rc.conf to enable the slon.sh script.
To use either of the above startup configurations, you will need to set up a
/usr/local/etc/slon.conf file to tell slon what to replicate. This file
is documented in /usr/local/share/doc/slony1/adminguide/runtime-config.html
If you are upgrading from a prior version of slony, please read the UPGRADING
file in the above docs directory.
Install slony1v2 txz package:
# pkg install slony1v2