Man Linux: Main Page and Category List


       ADMIN CONNINFO - preamble - identifying PostgreSQL database


       NODE ival ADMIN CONNINFO =DSN; [ ival;] [ conninfo]


       Describes  how  the  slonik  utility can reach a node’s database in the
       cluster from where it  is  run  (likely  the  DBA’s  workstation).  The
       conninfo string is the string agrument given to the PQconnectdb() libpq
       function. The user used to connect  must  be  the  special  replication
       superuser,   as  some  of  the  actions  performed  later  may  include
       operations that  are  strictly  reserved  for  database  superusers  by

       The  slonik  utility will not try to connect to a given database unless
       some subsequent command requires the connection.

              As mentioned in the original documents, Slony-I is  designed  as
              an  enterprise  replication system for data centers. It has been
              assumed throughout the  entire  development  that  the  database
              servers  and administrative workstations involved in replication
              and/or  setup  and  configuration  activities  can  use   simple
              authentication  schemes  like  ‘trust’. Alternatively, libpq can
              read passwords from .pgpass .

              If you need to change the DSN information for a node,  as  would
              happen  if  the  IP  address for a host were to change, you must
              submit the  new  information  using  the  SLONIK  STORE  PATH(7)
              command,  and  that  configuration  will be propagated. Existing
              slon processes may need to be restarted in order to become aware
              of the configuration change.

       For  more  details  on  the  distinction  between this and SLONIK STORE
       PATH(7), see “ Slony-I Path Communications” [not  available  as  a  man


            NODE 1 ADMIN CONNINFO = ’dbname=testdb host=server1 user=slony’;


       This command was introduced in Slony-I 1.0

                                  12 May 2010         SLONIK ADMIN CONNINFO(7)