ADMIN CONNINFO — preamble - identifying PostgreSQL database
NODE ival ADMIN CONNINFO = 'DSN';
[ ival;
] [ 'conninfo'
]
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.
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 STORE PATH 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, see Section 10, “ Slony-I Path Communications”.