Re: Postgresql + containerization possible use case

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql + containerization possible use case
Date: 2021-12-10 12:01:43
Message-ID: 4932d882-0d13-21d6-30ff-b99531232c3d@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/12/21 1:24 μ.μ., o1bigtenor wrote:
>
>
> On Fri, Dec 10, 2021 at 3: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), and in each one of them we run:
> - jboss
> - postgresql
> - uucp (not as a daemon)
> - gpsd
> - samba
> - and possibly some other services
>
> Hardware and software upgrades are very hard since there is no physical access to those servers by trained personnel, and also there is a diversity of software versions.
>
> The idea for future upgrades is to containerize certain aspects of the software. The questions are (I am not skilled in docker, only minimal contact with lxd) :
> - is this a valid use case for containerization?
> - are there any gotchas around postgersql, the reliability of the system ?
> - since we are talking about 4+ basic services (pgsqk, jboss, uucp, samba), is docker a good fit or should we be looking into lxd as well?
> - are there any success stories of other after following a similar path?
>
>
Thanks
> My experience with LXD is that upon install you are now on a regular update plan that is impossible to change.
Ehhmmm we are running some old versions there already (jboss, pgsql), LXD would not differ in this regard.
What do you mean? that the updates for LXD are huge? short spaced/very regular?
Can you pls elaborate some more on that?
> This means that your very expensive data connection will be preempted for updates at the whim of the
> canonical crew. Suggest not using such (most using such on wireless connections seem to have found
> the resultant issues less than wonderful - - cost (on the data connection) being #1 and the inability to achieve
> solid reliability crowding it for #2).
Crew has their own paid service. Business connection is for business not crew.
What I am interested is, could docker be of any use in the above scenario? Containerization in general?
The guys (admins/mgmt) here seem to be dead set on docker, but I have to guarantee some basic data safety requirements.
>
> IMO     HTH

--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message o1bigtenor 2021-12-10 14:02:33 Re: Postgresql + containerization possible use case
Previous Message o1bigtenor 2021-12-10 11:24:26 Re: Postgresql + containerization possible use case