cbbrowne at ca.afilias.info cbbrowne
Sat Apr 23 14:48:48 PDT 2005
> I did all what the documentation said. Altough all the example based on
> master and slave on the same machine, I would like to have the syncron
> between local and remote. Based on the logs all seems to be perfect, but
> when an update on the master happens, the query does return the old
> value on the slave. After running the init script I got no errors at the
> shell prompt, but I got some strange messages in the attached
> psql.log file, although I do not know what that means, maybe important.
> I run out of ideas Im trying to get this done three days by now. Maybe
> something is missing here, or something wrong ...

None of the messages seem strange in the psql log; all I see there is
pretty normal for when a subscriber is set up.

The one thing that seems odd is that you only listed about 2 SYNCs worth
of logs where things appeared to be working fine, and the overall scope of
time only gave time for 20 SYNCs, which means Slony-I was only running for
a few seconds.

The logs you show seem consistent with everything running properly.

The one thought I have is that you might turn archiving on using the "-a"
option, which will put a series of SQL scripts in the directory you
specify.

One or another of those SQL scripts should contain the updates you do on
the master node.

That may help trace better what is going on.



More information about the Slony1-general mailing list