Обсуждение: Downgrade from 9.2.10 to 9.2.6

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

Hi,

On Wed, 2015-03-11 at 10:15 -0600, CS DBA wrote:
> I assume the above approach requires the 9.2.6 packages to still be
> available at yum.postgresql.org? Is this so?

We have only 9.2.9 and 9.2.10 ATM. However, you can build 9.2.6 RPMs
using the spec files and patches at:

http://git.postgresql.org/gitweb/?p=pgrpms.git;a=tree;f=rpm/redhat/9.2/postgresql/EL-6;h=1ee8ee297928c4fe817dff94480ed8336466e393;hb=2dbfcee99db43bc7061185edc102f8bdfdb8ea08

and using this tarball:

ftp://ftp-archives.postgresql.org/pub/source/v9.2.6/postgresql-9.2.6.tar.bz2

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR