700839 - Update PostgreSQL servers to version 9.0.6

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[[:jberkus] Josh Berkus]

While PostgreSQL 9.0.5 does not have any critical fixes in it which affect our application, it's a good idea to keep up with the latest patches.  As such, I'd like to schedule an update of our production servers as soon as convenient.

Comment 1

[[:jberkus] Josh Berkus]

Postponing this, because it looks like 9.0.6 will come out on Dec. 5th or 6th.

Comment 2

[[:jberkus] Josh Berkus]

Jason,

9.0.6 is available as of last week.  The release contains a bug fix for an issue which could cause production to fail to fail over properly in the event of an emergency failover, so it's important to get it installed soon.

When can we reasonably schedule an update?  This requires around 5min of downtime.

Comment 3

[[:jberkus] Josh Berkus]

assigned to mpressman by request.

"yum update postgresql90" was tested on stage, and worked with no further steps required.

Normally we look on postgres updates as a time to test failover as well, failing over to master02 and back to master01 to make sure that's still working.  However, given IT resources after last week's outages, this might be a bad idea in case there *are* issues.

Comment 4

[Jason Thomas [:jason]]

As this will cause a Socorro production outage for ~5 min we plan to do this later in the day on Thursday Dec 15 @ 6PM PST.

@laura: Does this date and time work for you?

Comment 5

[Matt Pressman [:mpressman]]

tp-socorro01-master01 and tp-socorro01-master02 have been upgraded to postgresql 9.0.6. The upgrade went smooth with the exception of the processors which did not automatically reconnect and needed to be manually restarted