The only real way to do that is to use Postgres locally and restore it manually on the cloud.
Keeping the data of two applications in sync is hard work. You could create a webservice to exchange the data but what to do if the data has been changed on both sides? Which one should win. If you just want to create snapshots of your data use Marc's sollution and install postgres locally. Since the cloud also uses postgres you can backup and restore on both sides and thus make the data the same on both sides.