Re: PostgreSQL broken by upgrade to F24

2016-11-30 Thread Patrick O'Callaghan
On Wed, 2016-11-30 at 09:22 -0800, Gordon Messmer wrote: > On 11/28/2016 10:08 PM, Stephen Davies wrote: > > My databases were off the air for 24 hours. > > > On the up side, you've learned a couple of important lessons about > operating production services. The first of them is this: Set up a

Re: PostgreSQL broken by upgrade to F24

2016-11-30 Thread Gordon Messmer
On 11/28/2016 10:08 PM, Stephen Davies wrote: My databases were off the air for 24 hours. On the up side, you've learned a couple of important lessons about operating production services. The first of them is this: Set up a test environment and actually test your changes there, first. Inc

Re: PostgreSQL broken by upgrade to F24

2016-11-29 Thread Max Pyziur
On Mon, 28 Nov 2016, Raman Gupta wrote: On 11/27/2016 10:27 PM, Stephen Davies wrote: Install postgresql-upgrade. If you have any databases that use postgis, postgresql-upgrade fails spectacularly. You do have to take some manual steps to get the binaries for the older version, so that the u

Re: PostgreSQL broken by upgrade to F24

2016-11-28 Thread Stephen Davies
On 28/11/16 17:45, Raman Gupta wrote: On 11/27/2016 10:27 PM, Stephen Davies wrote: Install postgresql-upgrade. If you have any databases that use postgis, postgresql-upgrade fails spectacularly. You do have to take some manual steps to get the binaries for the older version, so that the upgr

Re: PostgreSQL broken by upgrade to F24

2016-11-27 Thread Raman Gupta
> On 11/27/2016 10:27 PM, Stephen Davies wrote: > Install postgresql-upgrade. If you have any databases that use postgis, postgresql-upgrade fails spectacularly. You do have to take some manual steps to get the binaries for the older version, so that the upgrade completes. This blog post was hel

Re: PostgreSQL broken by upgrade to F24

2016-11-27 Thread Samuel Sieb
On 11/27/2016 10:27 PM, Stephen Davies wrote: In it's infinite wisdom, the upgrade from F23 to F24 updates PostgreSQL from 9.4 to 9.5.5 making existing databases unusable. What else could it do? Never upgrade PostgreSQL? I suppose that there is a warning about this somewhere but it certainly

PostgreSQL broken by upgrade to F24

2016-11-27 Thread Stephen Davies
In it's infinite wisdom, the upgrade from F23 to F24 updates PostgreSQL from 9.4 to 9.5.5 making existing databases unusable. I suppose that there is a warning about this somewhere but it certainly isn't part of the upgrade process. I know that I can use pg_upgrade to migrate my databases but