From: CS DBA <cs_dba@consistentstate.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Downgrade from 9.2.10 to 9.2.6
Date: Wed, 11 Mar 2015 10:15:44 -0600
Message-ID: <55006A30.8090600@consistentstate.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com
Subject: Re: Downgrade from 9.2.10 to 9.2.6
In-Reply-To: <55006A30.8090600@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox