Closed Bug 1060113 Opened 10 years ago Closed 10 years ago

Upgrade psql to 9.2 on crashanalysis.dmz.phx1

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
major

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: kairo, Assigned: selenamarie)

Details

(Whiteboard: [data: upgrade]) 

The reason I see bug 898072 when doing queries with pqsl on crashanalysis.dmz.phx1 seems to be because that machine has PostgreSQL 9.0 installed but the Socorro servers we're accessing have PostgreSQL 9.2 nowadays. Can we get psql upgraded to 9.2 on that machine, please?
Given that this has been lying around without any action for a month and it blocks me from running custom reports e.g. for media plugins (which are an important new feature), I'm raising the severity here.
Severity: normal → major
Might be more a DBops bug
Severity: major → normal
Yeah, this is a dbops bug (selena might have been able to do it but she's out for a few more weeks).
Assignee: server-ops-webops → server-ops-database
Component: WebOps: Socorro → Server Operations: Database
Product: Infrastructure & Operations → mozilla.org
QA Contact: nmaul → scabral
Product: mozilla.org → Data & BI Services Team
Whiteboard: [data: upgrade]
(In reply to Robert Kaiser (:kairo@mozilla.com) from comment #1)
> Given that this has been lying around without any action for a month and it
> blocks me from running custom reports e.g. for media plugins (which are an
> important new feature), I'm raising the severity here.

And as it's still not getting any action but starting to block even more analysis of mine (like getting stats of graphics hardware), I'm raising severity again.
Severity: normal → major
Assignee: server-ops-database → mpressman
Can selena upgrade the machine?
(In reply to Sheeri Cabral [:sheeri] from comment #5)
> Can selena upgrade the machine?

I don't have access to this system, but will get it and have a look around. I imagine it is a simple upgrade, will give an update if not.
Assignee: mpressman → sdeckelmann
[root@crashanalysis.dmz.phx1 ~]# rpm -ivh http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
Retrieving http://yum.postgresql.org/9.2/redhat/rhel-6-x86_64/pgdg-redhat92-9.2-7.noarch.rpm
warning: /var/tmp/rpm-tmp.P2F7bI: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing...                ########################################### [100%]
   1:pgdg-redhat92          ########################################### [100%]
[root@crashanalysis.dmz.phx1 ~]# yum install postgresql92-client
Loaded plugins: downloadonly, rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
Setting up Install Process
pgdg92                                                                                                                                                                                                                                                       | 3.7 kB     00:00     
pgdg92/primary_db                                                                                                                                                                                                                                            | 130 kB     00:00     
No package postgresql92-client available.
Error: Nothing to do
[root@crashanalysis.dmz.phx1 ~]# yum install postgresql92
Loaded plugins: downloadonly, rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package postgresql92.x86_64 0:9.2.9-1PGDG.rhel6 will be installed
--> Processing Dependency: postgresql92-libs = 9.2.9-1PGDG.rhel6 for package: postgresql92-9.2.9-1PGDG.rhel6.x86_64
--> Running transaction check
---> Package postgresql92-libs.x86_64 0:9.2.9-1PGDG.rhel6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================================================================================================================================
 Package                                                                 Arch                                                         Version                                                                    Repository                                                    Size
====================================================================================================================================================================================================================================================================================
Installing:
 postgresql92                                                            x86_64                                                       9.2.9-1PGDG.rhel6                                                          pgdg92                                                       976 k
Installing for dependencies:
 postgresql92-libs                                                       x86_64                                                       9.2.9-1PGDG.rhel6                                                          pgdg92                                                       188 k

Transaction Summary
====================================================================================================================================================================================================================================================================================
Install       2 Package(s)

Total download size: 1.1 M
Installed size: 5.6 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): postgresql92-9.2.9-1PGDG.rhel6.x86_64.rpm                                                                                                                                                                                                             | 976 kB     00:00     
(2/2): postgresql92-libs-9.2.9-1PGDG.rhel6.x86_64.rpm                                                                                                                                                                                                        | 188 kB     00:00     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                                                               2.3 MB/s | 1.1 MB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
  Installing : postgresql92-libs-9.2.9-1PGDG.rhel6.x86_64                                                                                                                                                                                                                       1/2 
  Installing : postgresql92-9.2.9-1PGDG.rhel6.x86_64                                                                                                                                                                                                                            2/2 
  Verifying  : postgresql92-9.2.9-1PGDG.rhel6.x86_64                                                                                                                                                                                                                            1/2 
  Verifying  : postgresql92-libs-9.2.9-1PGDG.rhel6.x86_64                                                                                                                                                                                                                       2/2 

Installed:
  postgresql92.x86_64 0:9.2.9-1PGDG.rhel6                                                                                                                                                                                                                                           

Dependency Installed:
  postgresql92-libs.x86_64 0:9.2.9-1PGDG.rhel6                                                                                                                                                                                                                                      

Complete!
[root@crashanalysis.dmz.phx1 ~]# psql --version
psql (PostgreSQL) 9.2.9
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Thanks!

Unfortunately, it didn't help my bug 898072 problem at all :(
You need to log in before you can comment on or make changes to this bug.