Thu Mar 10 20:57:09 PST 2005
- Previous message: [Slony1-general] RE: slow replication since upgrade to 1.0.5
- Next message: [Slony1-general] RE: slow replication since upgrade to 1.0.5
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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;
- Previous message: [Slony1-general] RE: slow replication since upgrade to 1.0.5
- Next message: [Slony1-general] RE: slow replication since upgrade to 1.0.5
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list