On 13-02-22 04:20 PM, Mike James wrote:

See http://www.slony.info/documentation/2.1/stmtupdatefunctions.html

You need to use the UPDATE FUNCTIONS  command for each node in your cluster


> Hi, I’m used the pgdg92 (PostgreSQL 9.2.6 – x86_64) repo to install
> postgesql 9.2 and slony1-92 on a Centos 6 machine. After running yum
> update recently, my slony1 was updated to slony1-92-2.1.3-1.rhel6.x86_64.
>
> Now when I run slony1, I get the following entries created in
> slond-system.log, which terminate with an error:
>
> 2013-02-22 16:02:20 EST CONFIG main: slon version 2.1.3 starting up
>
> 2013-02-22 16:02:20 EST INFO   slon: watchdog process started
>
> 2013-02-22 16:02:20 EST CONFIG slon: watchdog ready - pid = 8097
>
> 2013-02-22 16:02:20 EST CONFIG slon: worker process created - pid = 8098
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option vac_frequency = 3
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option log_level = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option sync_interval = 2000
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option
> sync_interval_timeout = 10000
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option sync_group_maxsize = 20
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option desired_sync_time =
> 60000
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option syslog = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option quit_sync_provider = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option sync_max_rowsize = 8192
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option sync_max_largemem =
> 5242880
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option
> remote_listen_timeout = 300
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option monitor_interval = 500
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option explain_interval = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option tcp_keepalive_idle = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option
> tcp_keepalive_interval = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Integer option tcp_keepalive_count = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Boolean option log_pid = 0
>
> 2013-02-22 16:02:20 EST CONFIG main: Boolean option log_timestamp = 1
>
> 2013-02-22 16:02:20 EST CONFIG main: Boolean option tcp_keepalive = 1
>
> 2013-02-22 16:02:20 EST CONFIG main: Boolean option monitor_threads = 1
>
> 2013-02-22 16:02:20 EST CONFIG main: Real option real_placeholder = 0.000000
>
> 2013-02-22 16:02:20 EST CONFIG main: String option cluster_name =
> sys_cluster
>
> 2013-02-22 16:02:20 EST CONFIG main: String option conn_info = dbname=system
>
> user=slonyusr host=192.168.1.1 password=amessofit
>
> 2013-02-22 16:02:20 EST CONFIG main: String option pid_file = [NULL]
>
> 2013-02-22 16:02:20 EST CONFIG main: String option log_timestamp_format
> = %Y-%m-%d %H:%M:%S %Z
>
> 2013-02-22 16:02:20 EST CONFIG main: String option archive_dir = [NULL]
>
> 2013-02-22 16:02:20 EST CONFIG main: String option sql_on_connection =
> [NULL]
>
> 2013-02-22 16:02:20 EST CONFIG main: String option lag_interval = [NULL]
>
> 2013-02-22 16:02:20 EST CONFIG main: String option command_on_logarchive
> = [NULL]
>
> 2013-02-22 16:02:20 EST CONFIG main: String option syslog_facility = LOCAL0
>
> 2013-02-22 16:02:20 EST CONFIG main: String option syslog_ident = slon
>
> 2013-02-22 16:02:20 EST CONFIG main: String option cleanup_interval = 10
> minutes
>
> 2013-02-22 16:02:20 EST ERROR  Slony-I schema version is 2.1.2
>
> 2013-02-22 16:02:20 EST ERROR  please upgrade Slony-I schema to version
> 2.1.3
>
> 2013-02-22 16:02:20 EST FATAL  main: Node has wrong Slony-I schema or
> module version loaded
>
> 2013-02-22 16:02:20 EST CONFIG slon: child terminated signal: 9; pid:
> 8098, current worker pid: 8098
>
> 2013-02-22 16:02:20 EST INFO   slon: done
>
> 2013-02-22 16:02:20 EST INFO   slon: exit(0)
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>