PostgreSQL data diff
- by skanatek
Note: this question is not about syncing database schema/structure
Problem
In my web application I have a PostgreSQL database server (PGS) and a (separate machine) business logic server (BLS) which regularly (every minute or two) queries 'SELECT ALL' against PGS.
The problem is that the 'SELECT ALL' query can easily return 50-200 MB each time.…