Postgres Learner postgres.learner
Tue Feb 8 12:41:18 PST 2005
Hi all!
I am a relatively new user to slony, though I do have some experience
with postgres. I need to set slony up in a special production
environment. Basically our production database remains idle for most
of the day and does some extremely heavy processing in batches for
around 30 mins/day.

We need to set up a replicated database to failover in case something
goes wrong. So I was thinking about using slony. Since we need to
process our batches REALLY REALLY fast, I was thinking of stopping the
slony daemon while we process the batches and restart after we are
done. This works fine - I set it up and slony seems to continue
replication from where it left off when I shut the daemons. -Please
tell me if this is wrong.

Now the problem is that I can't figure out how to measure the time
taken to replicate/resync after slony daemon restarts. Basically I
want to know the window after which one server can safely go down
without causing problems. I looked into the documentation and even
searched on the net, but couldn't find anything. Please point me in
the right direction.

thanks a lot!
paraM


More information about the Slony1-general mailing list