Tue Feb 8 12:41:18 PST 2005
- Previous message: [Slony1-general] execute script needed for function update?
- Next message: [Slony1-general] Figuring out replication is finished / replicas are same
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] execute script needed for function update?
- Next message: [Slony1-general] Figuring out replication is finished / replicas are same
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list