pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDowngrade from 9.2.10 to 9.2.6
2+ messages / 2 participants
[nested] [flat]
* Downgrade from 9.2.10 to 9.2.6
@ 2015-03-11 16:15 CS DBA <cs_dba@consistentstate.com>
0 siblings, 1 reply; 2+ messages in thread
From: CS DBA @ 2015-03-11 16:15 UTC (permalink / raw)
To: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Downgrade from 9.2.10 to 9.2.6
@ 2015-03-11 16:29 Devrim Gündüz <devrim@gunduz.org>
parent: CS DBA <cs_dba@consistentstate.com>
0 siblings, 0 replies; 2+ messages in thread
From: Devrim Gündüz @ 2015-03-11 16:29 UTC (permalink / raw)
To: CS DBA <cs_dba@consistentstate.com>; +Cc: pgsql-admin
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=1ee8ee29792...
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-03-11 16:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-03-11 16:15 Downgrade from 9.2.10 to 9.2.6 CS DBA <cs_dba@consistentstate.com>
2015-03-11 16:29 ` Devrim Gündüz <devrim@gunduz.org>
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