Hi Chris

I'm familiar with the perl slonik scripts (slonik_init_cluster,
slonik_create_set, etc) but not the native action commands like STORE PATH.
Reading the doc I know I need to preface any action command like 
  STORE PATH with a preamble but am getting syntax errors when I try to
  Run it.  This is what I've coded (dataset called store_path):
  These are existing nodes,dbs, users, etc.
  
#!/bin/sh
cluster name = replication;
 node 1 admin conninfo='host=192.168.1.222 dbname=mavmail user=slony
port=5432 password=elephant1234';
 node 2 admin conninfo='host=192.168.1.221 dbname=mavmail user=slony
port=5432 password=elephant1234';
store path ( server = 1, client = 2, conninfo = 'host=192.168.1.222
dbname=mavmail user=slony port=5433 password=elephant1234' );
 

and I get the following syntax errors:


./store_path | ./bin/slonik
./store_path: line 4: cluster: command not found
./store_path: line 5: node: command not found
./store_path: line 6: node: command not found
./store_path: line 9: syntax error near unexpected token `('
./store_path: line 9: `store path ( server = 1, client = 2, conninfo =
'host=192.168.1.222 dbname=mavmail user=slony port=5433
password=elephant1234' );'

Something very obvious I'm sure - just not familiar enough with the slony
Language.  Any help appreciated.  Thank you

Mark Steben
Database Administrator
@utoRevenue  |  Autobase  |  AVV
The CRM division of Dominion Dealer Solutions
95D Ashley Avenue
West Springfield,  MA  01089
t: 413.327.3045
f: 413.732.1824
w: www.autorevenue.com


-----Original Message-----
From: Christopher Browne [mailto:cbbrowne at ca.afilias.info] 
Sent: Tuesday, February 15, 2011 3:07 PM
To: Mark Steben
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] change the listening port on master node

"Mark Steben" <msteben at autorevenue.com> writes:
> I would like to change the port on node1 from 5432 to 5433.  Do I need
> to ‘start from scratch’
>
> And recreate the node and the entire set or is there an ‘update’
> function I can use?

There is no need to recreate nodes or such.

You should only need to do two sets of changes:

 a) Reconfigure the slons to connect to port 5433.

    This is controlled where ever you store the configuration used to
    start up slon processes.

 b) Change all STORE PATH configuration to connect to port 5433.

    This will involve running a slonik script consisting of a series of
    STORE PATH commands, one for each path you have in your cluster.

    See table "_MySlonySchema".sl_path on any of your nodes for a census
    of all the STORE PATH requests that need to be submitted.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@"
[name;tld];;
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"