Thread: PostgreSQL Upgrade from 9.1.8 to 9.1.9

PostgreSQL Upgrade from 9.1.8 to 9.1.9

From
Ascot Moss
Date:
Hi,

I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu 12.04 machine and I found 9.1.9 was released last week, can someone advise me how to upgrade pg from 9.1.8 to 9.1.9?

or, are the following commands correct for this upgrade?
apt-get update
apt-get upgrade
(os Ubuntu 12.04 64-bit, current Postgresql version is 9.1.8, target version 9.1.9) 

regards 

Re: PostgreSQL Upgrade from 9.1.8 to 9.1.9

From
Joshua Berry
Date:
Hi Ascot,

I am new to Postgresql, I have installed the Postgresql 9.1.8 in my ubuntu 12.04 machine and I found 9.1.9 was released last week, can someone advise me how to upgrade pg from 9.1.8 to 9.1.9? 

or, are the following commands correct for this upgrade?
apt-get update
apt-get upgrade
(os Ubuntu 12.04 64-bit, current Postgresql version is 9.1.8, target version 9.1.9) 

For minor updates (ie 9.1.8 to 9.1.9), that is all that's required. On my RHEL systems the update process will invoke a "fast shutdown request" on postgresql which will cause the database to restart. Depending on you application, you'll probably want to perform the update during a scheduled maintenance period.

HTH,
-Joshua