PostgreSQL Sync A simple and easy database synchronization tool
Download

PostgreSQL Sync Ranking & Summary

PostgreSQL Sync Tags

synchronization PostgreSQL sync database synchronizer database synchronization synchronization tool PostgreSQL Synchronization

PostgreSQL Sync Description

The PostgreSQL Sync application was developed to be a simple and easy database synchronization tool.As I'm using rsync on a regular base I thought why isn't there a tool for databases that simply does nothing more than synchronizing two databases on demand - no sophisticated triggers or additional changes of the database. psync is a simple application synchronizes two PostgreSQL databases. The concept can be adapted or even encapsulated that also other databases can be used.The idea of psync is to use two database connections and update the tables and their content like this: - fetch all tables of source and destination databases - for each table in source do: create table if not exist on destination sync content of table - foreach table in destination do: delete table if not exists on source Although the algorithm looks simple there are many problems to overcome. - Duplicating tables - Handling of special columns, e.g. oid for large objects - Constraints on tables - Special structures of extensions

PostgreSQL Sync Related Software