Implementing the PostgreSQL database reconciliation asynchronous replication process.
CIVIC & SOCIAL ORGANIZATIONS
October 2020 – November 2020 (2 months)
Beirut, Lebanon
Synchronizing PostgreSQL databases between distant offices without reliable network access.
- Development and implementation of the asynchronous database reconciliation replication process.
- Document the tasks and steps for managing/resolving conflicts in Bucardo
- A Bucardo implementation with synchronization of the local office “nodes” (all tables, in delta push)
- A complete documentation that details the “from scratch” implementation (dependencies, installation, configuration, ssh connection) of Bucardo on a server, with the command lines and an explanation
- Documentation specifying the procedure to follow to add/remove a table from the synchronization, during an update and a new deployment of the software.
- Documentation specifying the process to move a Bucardo server + database to a new server, without losing the data