Re: PostgreSQL upgrade 9.3.4 -> 9.3.10

Dev Kumkar <devdas.kumkar@xxxxxxxxx> · Tue, 12 Jan 2016 18:58:35 +0530

On Tue, Jan 12, 2016 at 3:25 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:

    On 1/12/2016 1:28 AM, Dev Kumkar wrote:

      I
        want to upgrade my database from version 9.3.4 to 9.3.10.

      For
        this task, do I need to upgrade database using pg_upgrade
        utility?
      http://www.postgresql.org/docs/9.3/static/pgupgrade.html

      From
        the details it looks like for minor version upgrade pg_upgrade
        utility is not required.
      "pg_upgrade (formerly
          called pg_migrator)
          allows data stored in PostgreSQL data
          files to be upgraded to a later PostgreSQL major

          version without the data dump/reload typically required for
          major version upgrades, e.g. from 8.4.7 to the current major
          release of PostgreSQL.
          It is not required for minor version upgrades, e.g. from 9.0.1
          to 9.0.4."

      Can
        someone please provide more details here and also what steps
        needs to be done to upgrade to 9.3.10 level?

    you can do an inplace upgrade of the software, as others said,
    pg_upgrade is for upgrading from 9.X to 9.Y where Y>X

    however, its always a good idea to check the release notes of the
    version you're upgrading to, and seeing if there are any special
    issues, for instance, sometimes there's a potential bug in an
    obscure feature in said A.B.C version, and upgrading to A.B.D might
    require a reindex or something.   
    http://www.postgresql.org/docs/current/static/release-9-3-10.html

    I don't see anything specifically for 9.3.4 to 9.3.10 but read it
    for yourself, following the links to the applicable intermediate
    release notes.

    .

    -- 
john r pierce, recycling bits in santa cruz

Thanks everyone for your quick comments, appreciate it !

Yes nothing specifically mentioned for 9.3.4 to 9.3.10 

Regards...