Re: Managing major PostgreSQL upgrades

2021-11-16 Thread Saul Perdomo
Thanks. My first instinct might be to simply maintain your own list of missing packages, and ensure they all get installed prior to the pg_upgrade run (something which ansible can handily do). Now, depending on the level of homogeneity of the server farm under your purview, this might pose its own

Re: Managing major PostgreSQL upgrades

2021-11-16 Thread Tiffany Thang
On Mon, Nov 15, 2021 at 8:48 PM Saul Perdomo wrote: > Hey Tiff, > > We're in a similar boat. We currently lean on (mostly custom) ansible > scripting to automate all the repeatable tasks we can, but automation of > major PG version upgrades is something we are yet to tackle -- although we > plan

Re: Managing major PostgreSQL upgrades

2021-11-15 Thread Saul Perdomo
Hey Tiff, We're in a similar boat. We currently lean on (mostly custom) ansible scripting to automate all the repeatable tasks we can, but automation of major PG version upgrades is something we are yet to tackle -- although we plan to start this effort in the short term. Would you mind sharing a