Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
Thank you Rainer, I'll have to play a little bit myself, and read some serious docs about it, in order to fully comprehend your thoughts. I'll revisit your positions I hope. On 13/12/21 5:11 μ.μ., Rainer Duffner wrote: Am 13.12.2021 um 12:41 schrieb Achilleas Mantzios mailto:ach...@matrix.ga

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
On 13/12/21 5:55 μ.μ., Adrian Klaver wrote: On 12/13/21 03:41, Achilleas Mantzios wrote: Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: So Docker is NOT free? Please share your thoughts? I am a complete noob. Take a look here: https://www.docker.com/pricing Thank you Adrian!

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
Hi On 13/12/21 6:11 μ.μ., Benedict Holland wrote: Check out rolling updates with kubernetis and yes, a containerized postgresql environment is likely the best option. The really nice bit about containers is that you don't actually care about underlying hardware. You need a docker daemon. K8 manag

Re: Postgresql + containerization possible use case

2021-12-13 Thread Benedict Holland
Check out rolling updates with kubernetis and yes, a containerized postgresql environment is likely the best option. The really nice bit about containers is that you don't actually care about underlying hardware. You need a docker daemon. K8 manages clusters and it sounds like your use case would b

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
Hi Berto, On 13/12/21 3:03 μ.μ., Bèrto ëd Sèra wrote: On Mon, 13 Dec 2021 at 12:41, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hmm, I don't know about that. The hardware is given (existing) and limited. You are like the 2nd person who warned about comms as being an

Re: Postgresql + containerization possible use case

2021-12-13 Thread Adrian Klaver
On 12/13/21 03:41, Achilleas Mantzios wrote: Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: So Docker is NOT free? Please share your thoughts? I am a complete noob. Take a look here: https://www.docker.com/pricing Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tanker

Re: Postgresql + containerization possible use case

2021-12-13 Thread Rainer Duffner
> Am 13.12.2021 um 12:41 schrieb Achilleas Mantzios > : > > Our setup has been open source since forever. So licenses for something that > used to be free for ages would be hard to introduce. That ist totally understandable. 140x800 for the RHEL license alone is over 100k/year. Though you mi

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: Am 10.12.2021 um 13:01 schrieb Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>: On 10/12/21 1:24 μ.μ., o1bigtenor wrote: On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: H

Re: Postgresql + containerization possible use case

2021-12-13 Thread Rainer Duffner
> Am 10.12.2021 um 13:01 schrieb Achilleas Mantzios > : > > On 10/12/21 1:24 μ.μ., o1bigtenor wrote: >> >> >> On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios >> mailto:ach...@matrix.gatewaynet.com>> wrote: >> Hi >> we are running some 140 remote servers (in the 7 seas via satellite >> co

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
On 11/12/21 6:31 μ.μ., Michael Lewis wrote: Interesting. I'm not sure that moving an image for a VM with Postgres is compatible with the goal of minimizing time/data but if upgrades are yearly or something, perhaps that is reasonable. It has been 9+ years since that post as well. But the full dat

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
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 mailto:ach...@matrix.gatewaynet.com>> wrote:     Hi     we are running some 140 remote servers (in the 7 seas via satellite     connections)

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
Hi Adrian On 10/12/21 6:01 μ.μ., Adrian Klaver wrote: On 12/10/21 01:24, Achilleas Mantzios wrote: Hi 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

Re: Postgresql + containerization possible use case

2021-12-13 Thread Achilleas Mantzios
On 10/12/21 4:02 μ.μ., o1bigtenor wrote: The 'book' says everything is wonderful - - - - if it were me - - - no guarantees until 'I' am sure. If they want it - - - - and want you to guarantee it - - - - I wouldn't touch it myself!! (That's my opinion and worth all of what you paid for it. I ha

Re: Postgresql + containerization possible use case

2021-12-11 Thread Michael Lewis
Interesting. I'm not sure that moving an image for a VM with Postgres is compatible with the goal of minimizing time/data but if upgrades are yearly or something, perhaps that is reasonable. It has been 9+ years since that post as well. But the full data will need to be included in the image if the

Re: Postgresql + containerization possible use case

2021-12-10 Thread Adrian Klaver
On 12/10/21 12:06, Michael Lewis wrote: On Fri, Dec 10, 2021, 2:24 AM Achilleas Mantzios mailto:ach...@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 th

Re: Postgresql + containerization possible use case

2021-12-10 Thread Michael Lewis
On Fri, Dec 10, 2021, 2:24 AM Achilleas Mantzios < ach...@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? >

Re: Postgresql + containerization possible use case

2021-12-10 Thread Adrian Klaver
On 12/10/21 01:24, Achilleas Mantzios wrote: Hi 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 p

Re: Postgresql + containerization possible use case

2021-12-10 Thread o1bigtenor
On Fri, Dec 10, 2021 at 6:02 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 10/12/21 1:24 μ.μ., o1bigtenor wrote: > > > > On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> Hi >> we are running some 140 remote servers (in the 7 seas

Re: Postgresql + containerization possible use case

2021-12-10 Thread Achilleas Mantzios
On 10/12/21 1:24 μ.μ., o1bigtenor wrote: On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.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

Re: Postgresql + containerization possible use case

2021-12-10 Thread o1bigtenor
On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios < ach...@matrix.gatewaynet.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 possib

Postgresql + containerization possible use case

2021-12-10 Thread Achilleas Mantzios
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