Wed Feb 16 07:44:09 PST 2011
- Previous message: [Slony1-general] change the listening port on master node
- Next message: [Slony1-general] Blocking situation with "MOVE SET" command
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Got this to work - just had to put fully qualified slonik program As the first line in the shell script, then preamble, then STORE PATH Command, etc, etc, etc 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: Mark Steben [mailto:msteben at autorevenue.com] Sent: Tuesday, February 15, 2011 4:47 PM To: 'Christopher Browne' Cc: 'slony1-general at lists.slony.info' Subject: RE: [Slony1-general] change the listening port on master node 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"
- Previous message: [Slony1-general] change the listening port on master node
- Next message: [Slony1-general] Blocking situation with "MOVE SET" command
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list