GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SLONIK_UPDATE_FUNCTIONS (7)

NAME

UPDATE FUNCTIONS - Reload stored functions

CONTENTS

Synopsis

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 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 informative; 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.

Search for    or go to Top of page |  Section 7 |  Main Index


SLONIK UPDATE FUNCTIONS (7) 18 January 2015

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.