Once, I got pulled into a fintech company who done synchronization of remote psql databases by dump to csv -> send over ftp or email -> verify in Excel -> import back to centralized psql. No wonders, they have been missing some transactions...