Help with db scenario

From: Ricardo Oliveira <ricardojoliveira(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Help with db scenario
Date: 2015-07-07 18:59:00
Message-ID: CADsRysLgQ5hBw4a_F0Mhqamtf=MGRvu6KvWB_q8L65_yH6itYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, I would like to request some help from the community understanding what
would be the best solution for my problem.

I have been presented with the following db scenario:

(Using PostgreSQL 9.4)

Customer A has DB A;
Customer B has DB B;
Customer C has DB C;

All the databases should "see" changes between them. For example: DB A
should be updated with changes in DB B and DB C, DB B should be updated
with changes in DB A and DB C, etc..

All the databases are hosted in windows servers and should be updated as
quick as possible. Also the servers are connected via Internet and can at
times be disconnected (not accessible).

- What would be my best choices for data replication between these
databases? Windows solutions would be preferable but Linux solutions are
not excluded.
- What would be your main advice regarding a complex scenario like this?
What should I be looking for?

Any help and hints are appreciated.

Thank you in advance,

*Ricardo Oliveira*

Browse pgsql-novice by date

  From Date Subject
Next Message Ricardo Oliveira 2015-07-08 10:30:29 Replication DB scenario
Previous Message Hans Ginzel 2015-07-01 13:01:16 Re: view without definition in information_schema.Views