Melvin Davidson <mdavidson at trenstar.com> writes:
> 		   :v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word"
> 				   xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
>
> 							When I start slony, I see two processes which I expect.:p>
>
> 										  ie;:p>
>
>      postgres 17090     1  0 10:30 pts/0    00:00:00 slon -d1 -pslon_fsasset_1.pid fsasset_rep dbname=FSAssetMgmt20080310 user=slony host=tsdbdev01.corp.trenstar.net
> 									       port=5432:p>
>
>      postgres 17091 17090  0 10:30 pts/0    00:00:00 slon -d1 -pslon_fsasset_1.pid fsasset_rep dbname=FSAssetMgmt20080310 user=slony host=tsdbdev01.corp.trenstar.net
> 									       port=5432:p>
>
> 										   :p> 
>
> 						     However, what I don't expect, is 5 extra processes as below.:p>
>
> 			       postgres 17095 25256  0 10:30 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.36(60353) idle:p>
>
> 			       postgres 17097 25256  0 10:30 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.36(60354) idle:p>
>
> 			       postgres 17100 25256  0 10:30 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.36(60355) idle:p>
>
> 			       postgres 17102 25256  0 10:30 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.36(60356) idle:p>
>
> 			       postgres 17106 25256  0 10:30 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.12(44119) idle:p>
>
> 			       postgres 17167 25256  0 10:37 ?        00:00:00 postgres: slony FSAssetMgmt20080310 10.2.0.12(60806) idle:p>
>
> 										   :p> 
>
> 								 Previously I was using version 1.1.2:p>
>
> 										   :p> 
>
> 							      Is this something new for version 1.2.13 ?:p>

No, that shouldn't be new...

For a given slon (and you have 2 of them), there will be:

a) A connection for the worker thread for the node being managed;

b) A connection apiece for each listener thread needed by this node,
   which will, in a 2 node cluster, where there are necessarily 2
   nodes to listen for, means 2 such connections.

That adds up to 3 connections, for each slon, and if you multiply by 2
slons, you get 6 connections, which is what we see in that process
list.

This is therefore perfectly normal.
-- 
let name="cbbrowne" and tld="linuxfinances.info" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/rdbms.html
"It   can be   shown   that for any  nutty  theory,  beyond-the-fringe
political view or  strange religion there  exists  a proponent  on the
Net. The proof is left as an exercise for your kill-file."
-- Bertil Jonell