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