SLONIK_UPDATE_FUNCTIONS(7) - Linux manual page online | Overview, conventions, and miscellany
Reload stored functions.
21 September 2017
SLONIK UPDATE FUNCTIONS(7) Slony-I 2.2.6 Documentation SLONIK UPDATE FUNCTIONS(7)
21 September 2017 SLONIK UPDATE FUNCTIONS(7)
NAMEUPDATE FUNCTIONS - Reload stored functions
SYNOPSISUPDATE FUNCTIONS (options);
DESCRIPTIONReloads stored functions for a node. Reloads all stored procedure and function definitions in the Slony-I schema for the speci‐ fied node. This command is usually part of the Slony-I software upgrade procedure. ID = ival The node to refresh.
EXAMPLEUPDATE FUNCTIONS ( ID = 3 # Update functions on node 3 );
LOCKING BEHAVIOURNo application-visible locking should take place.
SLONIK EVENT CONFIRMATION BEHAVIOURSlonik does not wait for event confirmations before performing this command.
VERSION INFORMATIONThis command was introduced in Slony-I 1.0
ODDITIESAny mismatch between slonik(1) and the C libraries ‘living’ in the PostgreSQL installation will result in this failing to do what is expected, 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 version 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 informa‐ tive; what you'd find, in PostgreSQL logs, is some error message about being unable to load some stored function that happens 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.
|This manual||Reference||Other manuals|