From: Neha Sharma <[email protected]> >To: [email protected] >Sent: Wednesday, 1 May 2013, 7:41 >Subject: [Slony1-general] Slony multiple connections with database > > > >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
Can you post the logs for both PostgreSQL and the slon daemons? _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
