Provided by: slony1-doc_1.2.13-1_all bug

NAME

       ADMIN CONNINFO - preamble - identifying PostgreSQL database

SYNOPSIS

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

DESCRIPTION

       Describes  how  the  slonik  utility  can reach a nodes 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
       PostgreSQL.

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

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

              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 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 STORE PATH(7), see
       “ Slony-I Path Communications” [not available as a man page].

EXAMPLE

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

VERSION INFORMATION

       This command was introduced in Slony-I 1.0

                                 28 March 2008               ADMIN CONNINFO(7)