Melvin Davidson melvin6925 at yahoo.com
Thu Jul 16 20:40:45 PDT 2009
roctaiwan,

What you want to do is place the commands in a script that sends the output to background.
make sure you have defined the environment variables referenced also.

eg: the following script starts slon for node 1 

script name: start_node_1_db.sh
contents:
------------------------------------------------------------
slon -d1 -pslon_node_1.pid $SLONY_REP_SCHEMA "dbname=$MASTERDBNAME user=$REPLICATIONUSER host=$MASTERHOST port=$PGPORT" > slon1.log &


Melvin Davidson 
Folk Alley - All Folk - 24 Hours a day 
www.folkalley.com



--- On Thu, 7/16/09, roctaiwan <nettreeinc at gmail.com> wrote:

From: roctaiwan <nettreeinc at gmail.com>
Subject: [Slony1-general] Need some commands to monitoring/managing the slony clustering status
To: slony1-general at lists.slony.info
Date: Thursday, July 16, 2009, 10:32 PM


I had following instructions of a forum on how to start replicating my first
DBs. But it has not teach me how to do submit some general commands. I have
few that I would wants to know. 

Instruction says: 
% slon sql_cluster "dbname=contactdb user=postgres" &
% slon sql_cluster "dbname=contactdb_slave user=postgres" &

Questions: 
should I type this one by one and press ENTER after the "&"?

I start from the first cluster, once it started it looks like is showning
the status log of the slony in the window
http://www.nabble.com/file/p24528069/slony_Ma_start.jpg , it just keeps
rolling and rolling, I had wait for about a min but it don't seem will stop.
For me to start my second cluster engine, I had ignore it and continue type
my second command even it would moving my lines to different line, and press
enter. But I am not sure if I had started it or not. 

How can I put these status in the back ground so I can continue doing my
thing. Also how could I put it back to screen front if I want to see it
again?
I was trying to do ctrl+c, I am not sure if I did that will I stoped the
replication process?
what is the command to see the status of all my clusters (cluster1,
cluster2, cluster3) status if its "stoped" or "started" ? 
Also whats the command to show me the detail status of clustering on every
cluster to identify if there is any problems during replicating process ?
How do I stop, start and restart the slon replication engine ? 

If I would wants to know more useful commands like those I asked, could you
referral me some places? I know www.slony.info is one place, but the
information up there is just kinda hard to absorb. 


-- 
View this message in context: http://www.nabble.com/Need-some-commands-to-monitoring-managing-the-slony-clustering-status-tp24528069p24528069.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090716/cc8c4b65/attachment.html


More information about the Slony1-general mailing list