Hi.

Problem solved.

Cause: slonik_init_cluster is not generating the "STORE PATH" commands. Ej:
store path (server =3D 1, client =3D 2, conninfo=3D'dbname=3Dromero
host=3D192.168.xxx.194 user=3Dpostgres');

Solution: create a new missingCommand.sh script as follow:

#!/bin/sh

slonik <<_EOF_

cluster name =3D romeroCLT;
 node 1 admin conninfo=3D'host=3D192.168.xxx.194 dbname=3Dromero user=3Dpos=
tgres
port=3D5432';
 node 2 admin conninfo=3D'host=3D192.168.xxx.195 dbname=3Dromero user=3Dpos=
tgres
port=3D5432';
 node 3 admin conninfo=3D'host=3D192.168.xxx.196 dbname=3Dromero user=3Dpos=
tgres
port=3D5432';

# STORE PATH
  echo 'Next: configure paths for each node/origin';

  store path (server =3D 1, client =3D 2, conninfo=3D'dbname=3Dromero
host=3D192.168.xxx.194 user=3Dpostgres');
  store path (server =3D 1, client =3D 3, conninfo=3D'dbname=3Dromero
host=3D192.168.xxx.194 user=3Dpostgres');

  echo 'Replication nodes prepared';
  echo 'Please start a slon replication daemon for each node';

_EOF_

-- =

Regards,
Daniel Romero P.
NICLabs (www.niclabs.cl)

2008/11/14 Jennifer Spencer <jennifer.spencer at stanford.edu>

> It appears that you are only doing for "select" statements.  Are you
> expecting "select" to be done on your replicas?
>
> Slony replicates data, not queries that only display existing data.
>
> If you are doing inserts, updates or deletes of data on your main node, y=
ou
> should expect to see those changes on nodes 2 & 3.  Are you seeing any
> insert/update/delete activity done on node 1 showing up on nodes 2 & 3?
>
> -Jennifer Spencer
>
> Daniel Romero wrote:
>
>> Hi.
>>
>> I have 3 nodes, 1 main and 2 direct replicas.
>>
>> I can see my querys in the main node log, but node 2 and 3 are not
>> receiving
>> any querys, only synch or "slony internal" querys.
>>
>>
>> Any ideas?
>>
>>
>> NODE 2 LOG EXAMPLE
>> LOG:  statement: start transaction;set transaction isolation level
>> serializable;select last_value from "_romeroCLT".sl_action_seq;
>> LOG:  statement: rollback transaction;
>> LOG:  statement: start transaction; set transaction isolation level
>> serializable;
>> LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid,
>> ev_maxxid,
>> ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
>> ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
>> "_romeroCLT".sl_event where  ev_origin =3D '2'        and ev_seqno > '33'
>> order by ev_seqno
>> LOG:  statement: commit transaction
>> LOG:  statement: start transaction; set transaction isolation level
>> serializable;
>> LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid,
>> ev_maxxid,
>> ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
>> ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
>> "_romeroCLT".sl_event where  ev_origin =3D '2'        and ev_seqno > '34'
>> order by ev_seqno
>> LOG:  statement: rollback transaction;
>> LOG:  statement: start transaction;set transaction isolation level
>> serializable;select last_value from "_romeroCLT".sl_action_seq;
>> LOG:  statement: rollback transaction;
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081117/=
e474aa40/attachment.htm