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.