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
building Slony-I documentation , Building Documentation: Admin Guide
duplicating nodes , duplicate-node.sh
generate slonik scripts for a cluster , Generating slonik scripts using configure-replication.sh
generating Wiki documentation of a cluster , Building MediaWiki Cluster Summary
installation: short version , Short Version
listening breakage , How Listening Can Break
log shipping - trigger deactivation , find-triggers-to-deactivate.sh
search Slony-I logs using search-logs.sh , search-logs.sh
slonik, embedded in shell scripts , Embedding Slonik in Shell Scripts

A

adding a node, How to remove replication for a node
adding a node to replication, Adding a Replication Node
adding objects to replication, Adding a Table To Replication
administration scripts for Slony-I, Slony-I Administration Scripts
altperl configuration dump, slonikconfdump.sh
altperl create set, slonik_create_set
altperl drop node, slonik_drop_node
altperl drop set, slonik_drop_set
altperl drop table, slonik_drop_table
altperl execute script, slonik_execute_script
altperl failover, slonik_failover
altperl init cluster, slonik_init_cluster
altperl kill slon, slon_kill
altperl merge sets, slonik_merge_sets
altperl move set, slonik_move_set
altperl print preamble, slonik_print_preamble
altperl replication test, replication_test
altperl restart node, slonik_restart_node
altperl restart nodes, slonik_restart_nodes
altperl scripts for Slony-I, altperl Scripts
altperl show configuration, slony_show_configuration
altperl slon watchdog, slon_watchdog
altperl slon watchdog 2, slon_watchdog2
altperl start slon, slon_start
altperl store node, slonik_store_node
altperl subscribe set, slonik_subscribe_set
altperl unsubscribe nodes, slonik_uninstall_nodes
altperl unsubscribe set, slonik_unsubscribe_set
altperl update nodes, slonik_update_nodes
analysis of a SYNC, Analysis of a SYNC
archive_dir configuration parameter, Archive Logging Options
automating failover, Automating FAIL OVER

B

Bucardo monitoring, Bucardo-related Monitoring

C

cleanup_deletelogs configuration parameter, Event Tuning
cleanup_interval configuration parameter, Event Tuning
cluster, Cluster
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)
desired_sync_time configuration parameter, Event Tuning
downloading Slony-I sources, Getting Slony-I Source

E

events and confirmations, Events & Confirmations
explain_interval configuration parameter, Logging

F

failover
switchover, Doing switchover and failover with Slony-I
failover due to system failure, Failover
failover with complex node set, Failover With Complex Node Set
Frequently Asked Questions about Slony-I, Frequently Asked Questions

G

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

H

help - finding more assistance, More Slony-I Help

I

incompatibilities between versions, Incompatibilties between 2.0 and 2.1, Incompatibilities between 1.2 and 2.0
installation instructions, Slony-I Building & Installation
installing Slony-I on Windows, Installing the Slony-I service on Windows
Introduction To Slony-I , Introduction to Slony-I

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
logrep - multilog filters, logrep-mkservice.sh
Logs: adding objects' messages, Log Entries - Adding Objects to Sets
Logs: CONFIG level, CONFIG notices
Logs: DDL messages, Log Messages - DDL scripts
Logs: DEBUG level, DEBUG Notices
Logs: dropping objects' messages, Issues with Dropping Objects
Logs: INFO level, INFO notices
Logs: log shipping messages, Log Messages Associated with Log Shipping
Logs: log switching, Log Switching
Logs: MERGE SET messages, Log Entries Associated with MERGE SET
Logs: messages for MOVE SET, FAILOVER, DROP NODE, Issues with MOVE SET, FAILOVER, DROP NODE
Logs: miscellaneous, Miscellanea
Logs: moving objects' messages, Logging When Moving Objects Between Sets
logs: reading and understanding Slony-I logs, How to read Slony-I logs
Logs: routine SYNC messages, Log Entries Associated With Normal SYNC activity
Logs: subscription messages, Log Entries At Subscription Time
Logs: thread name, Thread name
Logs: threading messages, Threading Issues
logshipping: slony_logshipper tool, slony_logshipper Tool
log_level configuration parameter, Logging
log_pid configuration parameter, Logging
log_timestamp configuration parameter, Logging
log_timestamp_format configuration parameter, Logging

M

mkservice for BSD , mkservice
monitoring Slony-I, Cluster Monitoring
monitor_interval configuration parameter, Logging
monitor_threads configuration parameter, Logging
moving master, Moving The Master From One Node To Another
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
partitioning: dynamic addition of partitions, Support for Dynamic Partition Addition
pgbench setup, Creating the pgbench User
pid_file configuration parameter, Logging
provider node, Origin, Providers and Subscribers

Q

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

R

rebuilding after failover, After Failover, Reconfiguring Former Origin
release checklist, Release Checklist
remote_listen_timeout configuration parameter, Event Tuning
removing replication for a node, How to remove replication for a node
replicating your first database, Replicating Your First Database
replication set, Replication Set
reshaping subscriptions, Changing a Nodes Provider
RPMs for Slony-I, Installing Slony-I from RPMs

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
slon, slon
slon configuration: connections, Connection settings
slon configuration: event tuning, Event Tuning
slon configuration: log shipping, Archive Logging Options
slon configuration: logging, Logging
slon daemon, slon Daemon
slonik, slonik
slonik configuration processor, slonik Configuration Processor
slonik, usage, Using Slonik
slonik_build_env, slonik_build_env
sql_on_connection configuration parameter, Connection settings
starting & stopping slon, Starting & Stopping Replication
subscriber node, Origin, Providers and Subscribers
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

tcp_keepalive, Connection settings
tcp_keepalive_count, Connection settings
tcp_keepalive_idle, Connection settings
tcp_keepalive_interval, Connection settings
test bed framework, Slony-I Test Bed Framework
test scripts, Replication Test Scripts
testing cluster status, test_slony_state
testing replication, Other Replication Tests
trigger handling, Slony-I Trigger Handling

U

Upgrading between minor slony versions, Slony-I Upgrade
upgrading to Slony-I version 2, Upgrading to Slony-I version 2.1 from version 1.2 or earlier

V

vac_frequency configuration parameter, Event Tuning

W

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