Tue Jan 4 10:54:32 PST 2011
- Previous message: [Slony1-general] How do I go about restarting slony?
- Next message: [Slony1-general] ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey" error - bugzilla # 132
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Thanks for the help Scott. This should get me started. Scott Marlowe-2 wrote: > > On Tue, Jan 4, 2011 at 11:37 AM, sharadov <sreddy at spark.net> wrote: >> >> >> Thanks Scott. >> What is the command to stop/start slony? > > Depends on your platform and how you installed it. For my Ubuntu and > Centos boxen it's: > > sudo /etc/init.d/slony stop > sudo /etc/init.d/slony start > >> And commands to drop a node and recreate it. > > You'll need to write some simple slonik scripts. The one we use is > something like this: > > ------------------------------------------ drop_node2.slnk > --------------------------------- > > cluster name = slony_www; > node 1 admin conninfo='host=db1 dbname=www user=slony port=5432'; > node 2 admin conninfo='host=db2 dbname=www user=slony port=5432'; > > try { > drop node( id=2, event node=1); > } on error { > exit 1; > } > echo 'Dropped node 2'; > > ------------------------------------------------------------------------------------------------- > > And you'd run it like: > > slonik < drop_node2.slnk > > You really need to familiarize yourself with slony administration. Look > here: > > http://www.slony.info/adminguide/slony1-1.2.22/doc/adminguide/index.html > > Sadly, there aren't a lot of shortcuts for understanding how slony works. > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > > -- View this message in context: http://old.nabble.com/How-do-I-go-about-restarting-slony--tp30588795p30589596.html Sent from the Slony-I -- General mailing list archive at Nabble.com.
- Previous message: [Slony1-general] How do I go about restarting slony?
- Next message: [Slony1-general] ERROR: duplicate key value violates unique constraint "sl_nodelock-pkey" error - bugzilla # 132
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list