Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a current use case in which remote computers query a central PostgreSQL database over a internet connection (read-only). We would like to implement a "stand-alone" system for these terminals so that they will still be usable when internet connection is not available. Replication will have to be done over a slow (~10 Mbps) link.

It is only important that the data can be accessed read-only, it is not a problem if the data is somewhat outdated.

My current solution would be to install a PostgreSQL database on the remote computer which replicate the master server over the internet. The software will then query the local database. Based on the information from postgreSQL (especially this presentation) Slony seems to be the best solution. Is this true or are there other, better/simpler solution like streaming replication?

share|improve this question

Your Answer


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

Browse other questions tagged or ask your own question.