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@matrix.gatewaynet.com
<mailto:achill@matrix.gatewaynet.com>>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
servershas 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),
butthose 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
hasits own data specific for this vessel.
>
>
>
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
