Re: PostgreSQL Upgrade from 9.1.8 to 9.1.9

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