No title
Hello ,
I know this is not the right place to post following query... but any
help offered will help me a lot :)
Can anyone tell me how to stop slony.... (its a postgres replication
system )
I tried slon_kill but it says
bash-3.2$ /usr/bin/slon_kill
slon_kill.pl... Killing all slon and slon_watchdog instances for the
cluster replication
1. Kill slon watchdogs
No watchdogs found
2. Kill slon processes
No slon processes found
I have started the replication daemons on master & slave by using
following command
On master run
/usr/local/pgsql/bin/slon $CLUSTERNAME "dbname=$MASTERDBNAME
user=$MASTERDBA host=$MASTERHOST port=$MASTERPORT" > slon.log &
On slave run
/usr/local/pgsql/bin/slon $CLUSTERNAME "dbname=$SLAVEDBNAME user=$SLAVEDBA
host=$SLAVEHOST port=$SLAVEPORT" > slon.log &
Now I dont know how to stop it ... :(
Regards ,
Sweta.
Hello ,
You can use "kill <pid> " command to kill the slon daemons,
find
the pid's of the cluster and kill.
But that is not totally right :P . If there is no other way we will
use it.. But I want to stop slony properly using slony command. :)
Regards ,
Sweta.
Import Notes
Reply to msg id not found: bb2cdf790908040250xa7dbac2w18a6fd0e29b7f520@mail.gmail.com
From: sweta@opspl.com <sweta@opspl.com>
Subject: Re: [GENERAL]
To: pgsql-general@postgresql.org
Date: Tuesday, 4 August, 2009, 11:03 AMHello ,
You can use "kill <pid> " command to
kill the slon daemons,find
the pid's of the cluster and kill.But that is not totally right :P .
If there is no other way we will
use it.. But I want to stop slony properly using slony
command. :)
Maybe you should send this to the slony list.
Anyway, that's just sending a sigterm and AFAIK the the correct way to stop a slon...
sweta@opspl.com writes:
You can use "kill <pid> " command to kill the slon daemons,
find
the pid's of the cluster and kill.But that is not totally right :P . If there is no other way we will
use it.. But I want to stop slony properly using slony command. :)
There is no such "slony command."
Here are all the commands; there isn't one there to do what you want.
http://slony.info/documentation/cmds.html
Use kill on the appropriate pids.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/lsf.html
Rules of the Evil Overlord #88. "If a group of henchmen fail miserably
at a task, I will not berate them for incompetence then send the same
group out to try the task again." <http://www.eviloverlord.com/>