Jacques Caron jc at oxado.com
Wed Mar 26 10:32:46 PDT 2008
At 18:14 26/03/2008, Melvin Davidson wrote:
>I must disagree with that answer. I can understand 1 backend, but 5 ?
>I only have 1 slave, so 5 processes is excessive.

The slon process (the one that is really active) actually has several 
threads performing various tasks. Each of these threads connects to a 
local or remote postgres backend to do its work. There are worker, 
listener, cleanups threads and more that I forget, so you have many 
threads (check out with ps -axlH or the equivalent for your OS), and 
hence many backends.

>Finally, as stated before, this did not occur when I was using Slony 1.1.2
>There were no extra processes at all then.

You may not have seen them (because you weren't using user "slony" 
and it didn't show up in "ps -axl | grep slon" maybe?), but they were 
most definitely there. It is totally impossible slony could be 
performing any kind of replication without any connections to postgres!

Jacques.



More information about the Slony1-general mailing list