Index

Index

Symbols

adding a table to replication , Adding a table to replication
adding columns to a replicated table , How to add columns to a replicated table
altperl script example , Using the altperl scripts
Apache-style profiles for FreeBSD
FreeBSD , slon.in-profiles
automated listen path generation , Automated Listen Path Generation
bare metal Slony-I functions , Not Using Slonik - Bare Metal Slony-I Functions
building Slony-I documentation , Building Documentation: Admin Guide
database encodings, Database Encoding
duplicating nodes , duplicate-node.sh
embedding slonik in shell scripts , Embedding Slonik in Shell Scripts
generate slonik scripts for a cluster , Generating slonik scripts using configure-replication.sh
generating Wiki documentation of a cluster , Building MediaWiki Cluster Summary
grouping tables into replication sets , Grouping tables into sets
installation: short version , Short Version
introduction to Slony-I , Introduction to Slony-I
listening breakage , How listening can break
network connectivity, Network Connectivity
platforms where Slony-I runs , System Requirements
search Slony-I logs using search-logs.sh , search-logs.sh
software dependancies , Slony-I Software Dependancies
testing DDL changes , Testing DDL Changes
time synchronization, Time Synchronization
trigger deactivation , find-triggers-to-deactivate.sh

A

adding objects to replication, A Task-Oriented View of Slony-I
administration scripts for Slony-I, Slony-I Administration Scripts
altperl scripts for Slony-I, altperl Scripts
archive_dir configuration parameter, Archive Logging Options
automating failover, Automating FAIL OVER
autovacuum interaction, Interaction with PostgreSQL autovacuum

B

best practices for Slony-I usage, Slony-I Best Practices

C

cleanup_deletelogs configuration parameter, Event Tuning
cleanup_interval configuration parameter, Event Tuning
cluster, Cluster
cluster definition, Defining Slony-I Clusters
cluster.set1 - replication set configuration for Perl tools, Set configuration - cluster.set1, cluster.set2
cluster_name configuration parameter, Connection settings
command_on_logarchive configuration parameter, Archive Logging Options
communication paths, Slony-I Path Communications
concepts and terminology, Slony-I Concepts
configuration
of the slon daemon,
configuration instructions, Configuration
conn_info configuration parameter, Connection settings
controlled switchover, Controlled Switchover

D

DDL changes
database schema changes, Database Schema Changes (DDL)
defining replication sets, Defining Slony-I Replication Sets
desired_sync_time configuration parameter, Event Tuning
downloading Slony-I sources, Getting Slony-I Source
dropping a node from replication, Dropping A Whole Node
dropping a sequence from replication, Dropping A Sequence From Replication
dropping a set from replication, Dropping An Entire Set
dropping a table from replication, Dropping A Table From Replication
dropping objects from replication, Dropping things from Slony-I Replication

F

failover
switchover, Doing switchover and failover with Slony-I
failover due to system failure, Failover
Frequently Asked Questions about Slony-I,

G

generate SYNCs, Parallel to Watchdog: generate_syncs.sh
generating slon.conf files for Slony-I, mkslonconf.sh

H

help - how to get more assistance, More Slony-I Help

I

installation instructions, Slony-I Installation
installing Slony-I on Windows, Installing the Slony-I service on Windows

L

lag_interval configuration parameter, Event Tuning
launching Slony-I cluster using slon.conf files, launch_clusters.sh
limitations to Slony-I, Current Limitations
listen paths, Slony-I listen paths
locking issues, Locking Issues
Log analysis, Log Analysis
log files, Log Files
log shipping, Log Shipping - Slony-I with Files
log_level configuration parameter, Logging
log_pid configuration parameter, Logging
log_timestamp configuration parameter, Logging
log_timestamp_format configuration parameter, Logging

M

maintaining Slony-I, Slony-I Maintenance
mkservice for BSD , mkservice
monitoring Slony-I, Monitoring
MRTG for monitoring replication, Monitoring Slony-I using MRTG
Multiple Cluster support for the altperl tools, Support for Multiple Clusters

N

Nagios for monitoring replication, Nagios Replication Checks
node, Node

P

partitioning, Partitioning Support
pid_file configuration parameter, Logging
primary key requirement, Primary Keys
provider node, Origin, Providers and Subscribers

Q

quit_sync_finalsync configuration parameter, Event Tuning
quit_sync_provider configuration parameter, Event Tuning

R

race conditions, Race Conditions and Slony-I
reading and understanding Slony-I logs, How to read Slony-I logs
rebuilding after failover, After Failover, Reconfiguring Former Origin
release checklist, Release Checklist
remote_listen_timeout configuration parameter, Event Tuning
replicating your first database, Replicating Your First Database
replication models, Replication Models
replication set, Replication Set
reshaping replication, Reshaping a Cluster
running slon, Slon daemons

S

script - slony-cluster-analysis, slony-cluster-analysis
script - slony1_extract_schema.sh, slony1_extract_schema.sh
script test_slony_state to test replication state, test_slony_state
sequence pathology, The Pathology of Sequences
slon, slon
slon daemon, slon Daemon
slonik, slonik
slonik configuration processor, slonik Configuration Processor
slonik_build_env, slonik_build_env
sql_on_connection configuration parameter, Connection settings
subscriber node, Origin, Providers and Subscribers
subscribing nodes, Subscribing Nodes
sync_group_maxsize configuration parameter, Event Tuning
sync_interval configuration parameter, Event Tuning
sync_interval_timeout configuration parameter, Event Tuning
sync_max_largemem configuration parameter, Event Tuning
sync_max_rowsize configuration parameter, Event Tuning
syslog configuration parameter, Logging
syslog_facility configuration parameter, Logging
syslog_ident configuration parameter, Logging

T

test bed framework, Slony-I Test Bed Framework
testing cluster status, Testing Slony-I State
testing replication, Other Replication Tests
trigger handling, Slony-I Trigger Handling

U

unsubscribing a node from a set, Unsubscribing One Node From One Set
upgrading Slony-I to a newer version, Slony-I Upgrade
using slonik, Using Slonik

V

vac_frequency configuration parameter, Event Tuning
version upgrades for PostgreSQL using Slony-I, Using Slony-I for PostgreSQL Upgrades

W

watchdogs to keep slon daemons running, Watchdogs: Keeping Slons Running