Assuming 64-bit OS editions on each and only one copy of PostgreSQL running at a time, can I host my PostgreSQL database files in Dropbox and expect binary compatibility on all three platforms?
I've hosted my development environment in Dropbox for years, switching between a MacBook Pro and a cheap Linux netbook seamlessly. I've now added a Windows netbook to the mix and it all works great, but the next change is an unknown:
I'm moving my development from SQLite to PostgreSQL (to match the production db). I could run PostgreSQL independently on all three, but keeping data in sync is a pain. What if I hosted PostgreSQL's database files directly in Dropbox? Has anyone tried this before? Does it work?