Christopher Browne cbbrowne at afilias.info
Tue Oct 11 08:16:43 PDT 2011
On Tue, Oct 11, 2011 at 10:00 AM, francescoboccacci at libero.it
<francescoboccacci at libero.it> wrote:
> Hi everyone,
> i have i dubt (just one??). My  slony replica is working fine between 2 server
> (Master - Slave). I read some slony documentation about slony functionality and
> i saw thatt all slony exaplem in cluster script have 2 store path (one master -
> salve and the other slave-master). In my cluster script i have just one:
>
>    store path (server = 1, client = 2, conninfo = 'dbname=$DB1  host=$H1
> user=$U');
>
> dbname etc .. belong to master.
> What does it mean? Why is my replica working fine with just one store path?

In the absence of a return path, you'll have the problem that the slon
managing the origin node isn't receiving any events from the
subscriber node, with several ill effects:

a) Confirmations won't be getting back to the origin
b) Since confirmations don't make it, the origin never knows that it
can trim old data from log tables, and you can expect to see bloating
of such tables as:
 - sl_event
 - sl_confirm
 - sl_log_1
 - sl_log_2
 - sl_seqlog


More information about the Slony1-general mailing list