793795 - Need to update PostgreSQL servers

Status: RESOLVED FIXED

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

Description

[[:jberkus] Josh Berkus]

Ops,

http://www.postgresql.org/about/news/1416/

This is a non-critical update release for servers running PostgreSQL 9.0 and earlier.  The Socorro database servers run 9.0, so they should apply this update, but can wait for a reasonable downtime window to do so.

If any Mozilla services are running 9.1 or 9.2, they need to apply this update TONIGHT, and may need additional cleanup as described on the linked page.

Comment 1

[Sheeri Cabral [:sheeri]]

Other than Socorro, only the intranet cluster is using Postgres. Matt says it's running 9.0.9.

Comment 2

[[:jberkus] Josh Berkus]

Ok, so this is a non-critical update for all of those.  As long as we update in the next 2 weeks, we're good.

Comment 3

[Matt Pressman [:mpressman]]

socorro stage has been updated to 9.0.10

Comment 4

[Matt Pressman [:mpressman]]

socorro devdb/csd and pgslave instances have been updated to 9.0.10

Comment 5

[Matt Pressman [:mpressman]]

will run prod update today, 9/25/2012 at 5:30 PT

Comment 6

[Matt Pressman [:mpressman]]

production has been updated to 9.0.10

Comment 7

[Matt Pressman [:mpressman]]

confluence stage has been updated to 9.0.10 - will get sign off before updating production.

Comment 8

[Sheeri Cabral [:sheeri]]

What is the status of the machines that need to be upgraded, still? Just confluence production? (is that intranet?)

Comment 9

[Dumitru Gherman [:dumitru]]

Confluence production postgresql was also upgraded.

Comment 10

[Matt Pressman [:mpressman]]

this is good to be closed.