RE: Framework for 0 downtime deploys

2021-06-01 Thread Zahir Lalani
Confidential Thank you Nik That’s very useful and will be checking out the migration test tool! Z From: Nikolay Samokhvalov Sent: 22 May 2021 13:32 To: Zahir Lalani Cc: pgsql-general@lists.postgresql.org Subject: Re: Framework for 0 downtime deploys No silver bullets exist (yet). A couple

Re: Framework for 0 downtime deploys

2021-05-22 Thread Bruce Momjian
On Sat, May 22, 2021 at 11:11:46AM +, Zahir Lalani wrote: > > Confidential > > > Hello All > > > > I wonder if I could garner some of the wealth of experience on this group: > > > > Our current application deployments

Re: Framework for 0 downtime deploys

2021-05-22 Thread Nikolay Samokhvalov
No silver bullets exist (yet). A couple of things I can recommend: 1. GitLab's experience of changing schema without downtime and maintaining backward compatibility – they have open documentation and a lot of things solved and documented - start here: https://docs.gitlab.com/ee/development/mig

Framework for 0 downtime deploys

2021-05-22 Thread Zahir Lalani
Confidential Hello All I wonder if I could garner some of the wealth of experience on this group: Our current application deployments (every 3 weeks) require about 30min downtime. We are now tasked of making this 0 downtime. >From all the reading I have done, we have solutions for the infrastru