From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
---|---|
To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Downgrade from 9.2.10 to 9.2.6 |
Date: | 2015-03-11 16:15:44 |
Message-ID: | 55006A30.8090600@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
All;
We have a client that rolled out several changes including an upgrade
(via the PGDG repos i.e: yum.postgresql.org) from 9.2.6 to 9.2.10
Nw we are seeing major locking issues, it comes in spikes and we see
hundreds of locks, and thousands of waiting queries when the spikes
occur. I have a hunch their issue is the in house software they
upgraded but the client thinks it's the postgres upgrade.
Question: how do we safely roll back to 9.2.6?
Can I use "yum downgrade"?
i.e.:
yum downgrade postgresql92-server-9.2.6-1PGDG.rhel6.x86_64
postgresql92-9.2.6-1PGDG.rhel6.x86_64
postgresql92-contrib-9.2.6-1PGDG.rhel6.x86_64
I assume the above approach requires the 9.2.6 packages to still be
available at yum.postgresql.org? Is this so? Is there a better method?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim Gündüz | 2015-03-11 16:29:32 | Re: Downgrade from 9.2.10 to 9.2.6 |
Previous Message | Rossi, Maria | 2015-03-11 01:02:53 | Relocated Postgres |