I installed my postgreSQL and slony using one-click installer download on
EnterpriseDB.com website. This should be straight forward during the
installation and just simple following the steps. I have successfully
installed on my Master machine but not other two slaves. I forgot how I make
my master work, but I believe I didn't do anything unique, since it's just a
one-click installer~ (.bin file)

First Q, are my server successfully started or not? someone on forum taught
me to find out I can do pg_ctl status, or ps -ef | gres postgres or ps -ef |
gres slon . But please look the logs at below, I couldn't tell which command
is telling me the truth...

(copied from my DB1 slave server)
login as: root
root at 172.22.4.221's password:
Last login: Fri Jul 24 12:52:19 2009 from 172.20.80.47
[root at Slave-DB1-Slony-I ~]# su - postgres
-bash-3.2$ pg_ctl status
pg_ctl: neither postmaster nor postgres running -------------------->This
line showing there is nothing is running?
-bash-3.2$ ps -ef | grep postgres   ---------------------------> is This
showing my postgres is running?
postgres  4142     1  0 13:10 ?        00:00:00
/opt/PostgresPlus/8.3/bin/postgres.bin -D /opt/PostgresPlus/8.3/data
postgres  4174  4142  0 13:10 ?        00:00:00 postgres: writer process        
postgres  4175  4142  0 13:10 ?        00:00:00 postgres: wal writer process    
postgres  4176  4142  0 13:10 ?        00:00:00 postgres: autovacuum
launcher process
postgres  4177  4142  0 13:10 ?        00:00:00 postgres: stats collector
process
root      4362  4330  0 13:15 pts/0    00:00:00 su - postgres
postgres  4363  4362  0 13:15 pts/0    00:00:00 -bash
postgres  4518  4363  0 13:17 pts/0    00:00:00 ps -ef
postgres  4519  4363  0 13:17 pts/0    00:00:00 grep postgres
-bash-3.2$ ps -ef | grep postgresql
postgres  4523  4363  0 13:17 pts/0    00:00:00 grep postgresql
-bash-3.2$ ps -ef | grep slon
postgres  4604  4363  0 13:20 pts/0    00:00:00 grep slon
-bash-3.2$

(copied from my DB2 slave server)

login as: root
root at 172.22.4.222's password:
Last login: Fri Jul 24 12:34:37 2009 from 172.20.80.47
[root at Slave-DB2-Slony-I ~]# su - postgres
-bash-3.2$ pg_ctl status
pg_ctl: no server running
-bash-3.2$ ps -ef | grep postgresql
postgres  5507  5224  0 13:22 pts/0    00:00:00 grep postgresql
-bash-3.2$ ps -ef | grep postgres
postgres  4220     1  0 12:50 ?        00:00:00
/opt/PostgresPlus/8.3/bin/postgres.bin -D /opt/PostgresPlus/8.3/data
postgres  4252  4220  0 12:50 ?        00:00:00 postgres: writer process        
postgres  4253  4220  0 12:50 ?        00:00:00 postgres: wal writer process    
postgres  4254  4220  0 12:50 ?        00:00:00 postgres: autovacuum
launcher process
postgres  4255  4220  0 12:50 ?        00:00:00 postgres: stats collector
process
root      5223  5164  0 13:15 pts/0    00:00:00 su - postgres
postgres  5224  5223  0 13:15 pts/0    00:00:00 -bash
postgres  5547  5224  0 13:22 pts/0    00:00:00 ps -ef
postgres  5548  5224  0 13:22 pts/0    00:00:00 grep postgres
-bash-3.2$ ps -ef | grep slon
postgres  5550  5224  0 13:22 pts/0    00:00:00 grep slon
-bash-3.2$

Q2, I have setup one succeed machine that run both slony and postgresql
correctly. But the above two are not. if I want to start slon on these two
slaves it will say:

-bash-3.2$ slon sql_cluster "dbname=contactdb user=postgres"
-bash: slon: command not found

This happen on both of above machines.  Why is that? Many other times error
has something to do with postmaster.pid that it can not find. and I have no
clude about it... isn't it just a one-click installer?
-- 
View this message in context: http://www.nabble.com/postgres-and-slon-is-started-or-not%21---Slon-command-not-known-by-system-tp24639114p24639114.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.