I am running PostgreSQL 11 on my Windows Laptop and would like to sync with our production database on a (semi) regular basis and then test a number of queries and view creation without running the risk of damaging the master data. The master data set is pretty big and I work at remote offices over a WAN so a simple one-way compare and replace if necessary option would work best. Most of the utilities I have found are *nix based, so not good for me. Need some form of 'add in' to PGSQL or a Windows application. Any help appreciated. Cheers Bill

  • The easiest way is probably pg_dump and pg_restore - however that is not a "delta" load. It's a flush & fill and would require copying the whole dump over the network. I don't know if that is feasible with your WAN connection – a_horse_with_no_name Jan 31 at 10:20
  • The ideal way would be to restore from an existing backup, or hook into streaming replication. – CL. Jan 31 at 10:23
  • Navicat for PostgreSQL (commercial version) navicat.com/en/products/navicat-for-postgresql might help. – Vebbie Jan 31 at 10:58
  • Is the master server also on Windows? – jjanes Jan 31 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.