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*
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 |