Provided by: slony1-2-doc_2.2.7-2_all bug


       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  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.


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


       This command was introduced in Slony-I 1.0

                                         13 October 2018                 SLONIK ADMIN CONNINFO(7)