| Slony-I 2.0.4 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Fast Forward | Next | |
Slonik is a command line utility designed specifically to setup and modify configurations of the Slony-I replication system.
The slonik commandline utility is supposed to be used embedded into shell scripts and reads commands from files or stdin (via here documents for example). Nearly all of the real configuration work is done by calling stored procedures after loading the Slony-I support base into a database. You may find documentationme, v_seq_nspname, p_set_id, p_seq_comment); -- ---- -- On the set origin, fake a sl_seqlog row for the last sync event -- ---- if v_set_origin = v_local_node_id then for v_sync_row in select coalesce (max(ev_seqno), 0) as ev_seqno from sl_event where ev_origin = v_local_node_id and ev_type = 'SYNC' loop insert into sl_seqlog (seql_seqid, seql_origin, seql_ev_seqno, seql_last_value) values (p_seq_id, v_local_node_id, v_sync_row.ev_seqno, sequenceLastValue(p_fqname)); end loop; end if; return p_seq_id; end;