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.
PostgreSQL Replication for small, low-usage database
postgresqlreplication
Related Question
- Mysql – Is MySQL Replication appropriate for keeping a laptop in sync
- Postgresql – Taking a backup of a streaming WAL slave
- Postgresql – Which Postgresql Replication Solution to Use? (Asynchronous Multimaster / Bucardo?)
- Postgresql – postgres: Database replica with some schemas writable
- PostgreSQL Recovery – Restore Database to New Version from Files
- PostgreSQL 10 – secure remote logical replication (SSH?)
Best Answer
For reference, one of these may be suitable:
A general discussion of replication and clustering in PostgreSQL is here.
There are also many questions on StackOverflow and this useful one on ServerFault.