NAME

       slonik - Slony-I command processor

SYNOPSIS

       slonik [options] [filename]

OPTIONS

       -w     Suppress slonik's behaviour of automatically waiting for event confirmations before
              submitting events to a different node. If this option  is  specified,  your  slonik
              script  may  require  explicit SLONIK WAIT FOR EVENT(7) commands in order to behave
              properly, as was the behaviour of slonik prior to version 2.1.

DESCRIPTION

       slonik  is  the  command  processor  application  that  is  used  to  set  up  and  modify
       configurations of Slony-I replication clusters.

OUTLINE

       The  slonik  command  line  utility is supposed to be used embedded into shell scripts; it
       reads commands from files or stdin.

       It reads a set of Slonik statements, which are written in a scripting language with syntax
       similar  to  that of SQL, and performs the set of configuration changes on the slony nodes
       specified in the script.

       Nearly all of the real configuration work is actually done by  calling  stored  procedures
       after  loading the Slony-I support base into a database.  Slonik was created because these
       stored procedures have special  requirements  as  to  on  which  particular  node  in  the
       replication  system they are called. The absence of named parameters for stored procedures
       makes it rather hard to do this from the psql  prompt,  and  psql  lacks  the  ability  to
       maintain multiple connections with open transactions to multiple databases.

       The  format  of  the  Slonik  ‘language’ is very similar to that of SQL, and the parser is
       based on a similar set of formatting rules for such things as numbers  and  strings.  Note
       that slonik is declarative, using literal values throughout. It is anticipated that Slonik
       scripts will typically be generated by scripts, such as Bash or Perl, and these  sorts  of
       scripting  languages  already  have  perfectly  good  ways  of  managing  variables, doing
       iteration, and such.

       See also Slonik Command Language reference [“Slonik Command Summary” [not available  as  a
       man page]].

ENVIRONMENT VARIABLES

       SLONY_SHARE_DIR
              Sets  the  path  to  the directory containing the slony .sql scripts.  When this is
              unset Slonik will try to determine the path of the postgresql share files based  on
              the compiled in defaults or based on the location of the slonik binary. Usually the
              share directory under the Postgresql installation.

EXIT STATUS

       slonik returns 0 to the shell if it finished normally. Scripts may specify return codes.