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

FreeBSD Manual Pages

  
 
  

home | help
SLONIK UPDATE FUNCTIONSConfiguration and Action	commSLONIK UPDATE FUNCTIONS(7)

NAME
       UPDATE FUNCTIONS	- Reload stored	functions

SYNOPSIS
       UPDATE FUNCTIONS	(options);

DESCRIPTION
       Reloads stored functions	for a node.

       Reloads	all  stored  procedure and function definitions	in the Slony-I
       schema for the specified	node. This command  is	usually	 part  of  the
       Slony-I software	upgrade	procedure.

	ID = ival
	      The node to refresh.

EXAMPLE
       UPDATE FUNCTIONS	(
	   ID =	3	 # Update functions on node 3
       );

LOCKING	BEHAVIOUR
       No application-visible locking should take place.

SLONIK EVENT CONFIRMATION BEHAVIOUR
       Slonik  does  not  wait	for event confirmations	before performing this
       command.

VERSION	INFORMATION
       This command was	introduced in Slony-I 1.0

ODDITIES
       Any mismatch between slonik(1) and the C	libraries  ``living''  in  the
       PostgreSQL  installation	 will result in	this failing to	do what	is ex-
       pected, and, more than likely, failing to run at	all.   You  may	 think
       you  are	 upgrading  to version 1.1.5, but if you are running slonik(1)
       from version 1.1.2, or if you didn't restart the	database with  a  ver-
       sion  that  has	1.1.5  libraries, and instead are referencing C	stored
       functions from version 1.1.1, the attempt to upgrade will fail, because
       the sets	of C functions have regularly changed between major versions.

       Before  Slony-I	1.2, the error messages	that would result would	be not
       terribly	informative; what you'd	find, in PostgreSQL logs, is some  er-
       ror  message  about being unable	to load	some stored function that hap-
       pens to be implemented in C.  As	of 1.2,	one of the first  things  done
       is to load a stored function to verify version numbers; it complains in
       a much more direct fashion if you have some versioning mismatch.

				  30 May 2016	    SLONIK UPDATE FUNCTIONS(7)

NAME | SYNOPSIS | DESCRIPTION | EXAMPLE | LOCKING BEHAVIOUR | SLONIK EVENT CONFIRMATION BEHAVIOUR | VERSION INFORMATION | ODDITIES

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

home | help