vasiliev vasya vasyvasilie at yandex.ru
Fri Aug 21 08:09:59 PDT 2009
Hi, all.

We have good working replication scheme with one master and several slave servers, created and worked now no slony1-1* version and planned to migrate on slony1-2* version. Now we have some problems with big changes on master database, and that's why our replicas late from master for considerable time. I started to tune some slony settings, but unfortuanally, i didn't found configuration of slony that's works well in this case (possible, i should tune postgresql with slony, but how?). I'm interested in two ways:
1. The configuration when the replication system have max priority and master/slaves servers preffered works firstefull to sync data, not to responce to sql queries from our programs.
2. The configuration when responce of queries sould be preffered than replication, replication can late some.

Is it possible to tune slony (any vesion) and postgresql (last version) for theese two ways?

~vasya


More information about the Slony1-general mailing list