Hi,

We are using slony to synchronise two postgres databases of two machines.

Generally slony creates 6 connections with the database - 4 with local db
and 2 with remote db.

But some problem is being observed on the machine having master db. Various
slony remote connections are seen with the database.
The limit of postgres connections is 100 and slony is consuming maximum
connections due to which the db fails to respond after sometime. It was
observed that connection reached to 104 out of which slony connections
(which remote has created with db) were 74.
We have to restart slony to clean all the connections.

Ideally there should only be 2 connections from the remote - one created by
listener and another by worker thread.

There is no connectivity issue between the two machines.

Could anyone please suggest what could be the reason for this weired
behaviour of slony?
Also, please tell if slony creates new connections without removing the
older ones?

-- 
*Neha Sharma*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20130501/de5e108c/attachment.htm