How to Sync Data Between Computers (PostgreSQL)

Jes Sie

I need to synchronize data between databases from different computers using postgresql. I am not refering to database replication.

This is the scenario, we deployed a desktop application (C# using postgresql). We have a user of 5 field staffs. Everytime they go out from the office, they bring their laptop (desktop application installed with postgre). Once they are back to the office, they need to synchronize their (5 staffs) data to the main server (postgresql)

How can I do that? New to pg-sql. Thanks for any help or can point me to a right path.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie6y ago
Hi Mangesh, it is not possible since each area of the field staff has no internet connection. They should have PostgreSQL install in their machines and sync all data when they return to the office.
Laxmidhar Sahoo6y ago
hi

1 -When you want to migrate from local to server in the row level define a column as isupload of boolean type
2-Define two connection one is local and another is server from application
3-From local fire select statement where isupload is false which is bydefault false.
4-send the data to server and isupload update to true

Thanks and Regards
Mangesh G6y ago
Why dont you make one database for all of them centralised database in short then no need to do any manual sync afterwards