Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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 de-
	      signed 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.  Ex-
	      isting  slon  processes may need to be restarted in order	to be-
	      come 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

				  30 May 2016	      SLONIK ADMIN CONNINFO(7)

NAME | SYNOPSIS | DESCRIPTION | EXAMPLE | VERSION INFORMATION

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SLONIK_ADMIN_CONNINFO&sektion=7&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help