Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using Slony to replicate a Postgres database.

If my slony daemon exits for whatever reason, and doesn't start up hypothetically until 1 month later, will all the data that has accumulated in the master be replicated eventually to the slave? Of course, it might take a long time for that to happen, but will any data be lost as a result?

share|improve this question
    
Argh, migrating to Stack Exchange is like sending someone to purgatory.. you'll never hear anything back. –  Henley Chiu Nov 23 '13 at 17:45
add comment

migrated from stackoverflow.com Nov 23 '13 at 15:15

This question came from our site for professional and enthusiast programmers.

1 Answer

This is a fairly expert-level question and I could be wrong, but I think you are going to have a lot of issues in the scenario you suggest.

The basic issue is that while Slony is designed to handle periods of inactivity, you have a lot of stuff that is going to be queued for replication. If you make any DDL queries in the mean time, those can't get queued, and slonyk will not work to replicate them, so you will have a significant number of problems here.

My recommendation is not to use Slony for things where you expect long periods of inactivity (say, more than a couple of days). The limitations you will run into keeping this running are significant.

So yes, your data will eventually get replicated, maybe.... It depends on whether other problems surface in the mean time. I wouldn't recommend it in that case.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.