Hi Michael, Adrian
On 10/12/21 11:28 μ.μ., Adrian Klaver wrote:
On 12/10/21 12:06, Michael Lewis wrote:
On Fri, Dec 10, 2021, 2:24 AM Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx <mailto:achill@xxxxxxxxxxxxxxxxxxxxx>> wrote:
Hi
we are running some 140 remote servers (in the 7 seas via satellite
connections)
How are they used? What is in Postgres? Should that all have the exact same read only data at all times?
A previous explanation from Achilleas Mantzios , not sure if this is still exactly how it works:
https://www.postgresql.org/message-id/3124961.tmAbAIay6W%40smadev.internal.net
Thank you Adrian, the situation is the similar with the one you posted above (in 2012), albeit sizes/number of remote servers has increased.
In order to respond to Michael,
Remote pgsql servers are masters. A large majority of tables is read-only (by software, not enforced by other means), but those servers they have their very important write functions as well. And the
data are individual for any of those 100+ servers. There are no two identical DBs in the whole topology. Every server has its own data specific for this vessel.
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
