SLONIK ADMIN CONNINFO(7) Slonik Preamble Commands SLONIK ADMIN CONNINFO(7)NAME
ADMIN CONNINFO - preamble - identifying PostgreSQL database
SYNOPSIS
NODE ival ADMIN CONNINFO = 'DSN'; [ ival; ] [ 'conninfo' ]
DESCRIPTION
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 con‐
ninfo 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.
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 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.
EXAMPLE
NODE 1 ADMIN CONNINFO = 'dbname=testdb host=server1 user=slony';
VERSION INFORMATION
This command was introduced in Slony-I 1.0
18 January 2015 SLONIK ADMIN CONNINFO(7)
