Christopher Browne cbbrowne
Thu Mar 10 20:57:09 PST 2005
Michel.Diotte at hydro.com wrote:

>The vacuum has been done. But to make sure i did it again and the slave is
>still several minutes behind ...
>This is the log file of the slave if it can help ...
>  
>
It kind of doesn't look like it's behind, from the logs.

1.  What options are you passing to the slon daemon?

You can probably find this via "ps -auxww | grep slon | [perhaps another 
grep to exclude other processes]"

2.  Can you show the output of the query, on the origin:

select * from _replication.sl_status ;

That should give some statistics on the "behindness."

Also...

vacuum analyze verbose _replication.sl_log_1;
vacuum analyze verbose _replication.sl_seqlog;
vacuum analyze verbose pg_listener;


More information about the Slony1-general mailing list