My company has two locations: Head Quarters (HQ) and a sub location (SL).

Both locations (HQ and SL) has separate PostgreSQL databases with the same schema and they will do transactions (insert/delete/update) in off-line. When both comes on line, both databases need to be synchronized (ie, come in the same state). Is it possible?

  • 1
    It’s probably possible. Have you looked into logical replication? – Colin 't Hart Aug 4 '18 at 9:38
  • Please tag for the version of Postgres you are using. – Colin 't Hart Aug 4 '18 at 9:40
  • 1
    Are they generally online except for brief interruptions? Or generally offline? – jjanes Aug 4 '18 at 20:51
  • Generally Online,but interrupts are very common – Renjith KR Aug 6 '18 at 5:19
  • postgres version is 9.6 – Renjith KR Aug 6 '18 at 7:29

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.