I have PostgreSQL 8.4 installed on a headless Ubuntu 10.04 server. Sometimes the server is not available. I would like to continue working on the database, so I thought of installing PostgreSQL onto my laptop. I'm familiar with PostgreSQL, but not with replication. Would I setup replication so that the two databases are kept synchronized when the server becomes available again? This does not need to be automated. What is the easiest and simplest approach? The database is not used extensively by others at this stage and is small, so a simple, lightweight solution would be adequate.
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.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
For reference, one of these may be suitable:
A general discussion of replication and clustering in PostgreSQL is here.