• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..03-May-2022-

MakefileH A D05-Dec-20201.9 KiB7055

READMEH A D05-Dec-20202.3 KiB8149

ToDoH A D05-Dec-20201.4 KiB3526

altperl_init.sampleH A D05-Dec-20201.7 KiB8942

old-apache-rotatelogs.patchH A D05-Dec-2020950 2120

slon-tools.pmH A D05-Dec-202010.9 KiB354274

slon_kill.plH A D05-Dec-20202.5 KiB11679

slon_node.conf.sampleH A D05-Dec-20206.7 KiB177135

slon_start.plH A D05-Dec-20201.8 KiB7854

slon_status.plH A D05-Dec-2020964 5230

slon_tools.conf-sampleH A D05-Dec-20205.8 KiB198162

slon_watchdog.plH A D05-Dec-20202.5 KiB9362

slon_watchdog2.plH A D05-Dec-20203.9 KiB13590

slonik_add_node.plH A D05-Dec-20201.8 KiB7449

slonik_build_env.plH A D05-Dec-20204.7 KiB150119

slonik_create_set.plH A D05-Dec-20203.2 KiB11479

slonik_drop_node.plH A D05-Dec-20201.8 KiB7046

slonik_drop_sequence.plH A D05-Dec-20201.4 KiB6135

slonik_drop_set.plH A D05-Dec-20201.5 KiB5837

slonik_drop_table.plH A D05-Dec-20201.3 KiB5834

slonik_execute_script.plH A D05-Dec-20202.1 KiB9160

slonik_failover.plH A D05-Dec-20201.2 KiB5939

slonik_init_cluster.plH A D05-Dec-20202 KiB7350

slonik_merge_sets.plH A D05-Dec-20201.3 KiB5533

slonik_move_set.plH A D05-Dec-20201.5 KiB6442

slonik_print_preamble.plH A D05-Dec-2020840 3921

slonik_restart_node.plH A D03-May-2022941 5738

slonik_store_node.plH A D05-Dec-20201.9 KiB7851

slonik_subscribe_set.plH A D05-Dec-20201.2 KiB6544

slonik_uninstall_nodes.plH A D05-Dec-20201.3 KiB4930

slonik_unsubscribe_set.plH A D05-Dec-20201.1 KiB5435

slonik_update_nodes.plH A D05-Dec-2020661 3821

slony_show_configuration.plH A D05-Dec-20203.2 KiB11282

README

1README
2
3
4Christopher Browne, Afilias Canada
5Steve Simms, Technically Sound
6
7The altperl scripts provide an alternate method of managing Slony-I,
8generating slonik scripts and monitoring slon daemons.  They support
9an arbitrary number of Slony-I nodes in clusters of various shapes and
10sizes.
11
12To install the scripts, run "make" and "make install" in this
13directory.  The files will be installed under the --prefix you passed
14to configure.
15
16Enter a complete description of your cluster configuration (both nodes
17and sets) in slon_tools.conf.  The provided slon_tools.conf-sample
18contains documentation about each of the available options.
19
20If you want to support multiple clusters, you can create multiple
21slon_tools.conf files and specify which one to use in any of the
22scripts by passing the --config option.
23
24
25For the impatient: Steps to get started
26---------------------------------------
27
281. From the top-level source directory:
29
30   ./configure --prefix=/usr/local/slony --with-perltools
31   make
32   make install
33
342. Dump the schema from one database to another:
35
36   pg_dump --schema-only --host=server1 source_db | psql --host=server2 dest_db
37
383. Modify /usr/local/slony/etc/slon_tools.conf to reflect your setup.
39
404. Initialize the Slony-I cluster:
41
42   /usr/local/slony/bin/slonik_init_cluster
43
44   Verify that the output looks reasonable, then run:
45
46   /usr/local/slony/bin/slonik_init_cluster | /usr/local/pgsql/bin/slonik
47
485. Start up slon daemons for both servers:
49
50   /usr/local/slony/bin/slon_start node1
51   /usr/local/slony/bin/slon_start node2
52
536. Set up set 1 on the "master" node:
54
55   /usr/local/slony/bin/slonik_create_set set1
56
577. Subscribe node 2 to set 1:
58
59   /usr/local/slony/bin/slonik_subscribe_set set1 node2
60
61After some period of time (from a few seconds to a few days depending
62on the size of the set), you should have a working replica of the
63tables in set 1 on node 2.
64
65
66Alternate Configuration Method
67------------------------------
68
69The slon_tools.conf file is interpreted by Perl, so you could modify
70it to query a database to determine the configuration.  (Beware of
71chicken-and-egg scenarios in doing this, however!)
72
73
74For More Information
75--------------------
76
77There are numerous other scripts for maintaining a Slony cluster.  To
78learn more about any of them, run "tool_name --help".
79
80See also the Slony-I administration guide in the doc directory.
81