Re: Postgresql + containerization possible use case

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(at)matrix(dot)gatewaynet(dot)com <mailto:achill(at)matrix(dot)gatewaynet(dot)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 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