From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL upgrade 9.3.4 -> 9.3.10 |
Date: | 2016-01-12 15:06:30 |
Message-ID: | 56951676.2010204@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/12/2016 01:37 AM, Shulgin, Oleksandr wrote:
> On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com
> <mailto:devdas(dot)kumkar(at)gmail(dot)com>> wrote:
> >
> > Hello,
> >
> >
> > 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?
>
> Hello,
>
> You don't need pg_upgrade for minor version upgrades. Please refer to
> the documentation: http://www.postgresql.org/docs/9.3/static/upgrading.html
>
> "Minor releases never change the internal storage format and are always
> compatible with earlier and later minor releases of the same major
> version number, e.g., 8.4.2 is compatible with 8.4, 8.4.1 and 8.4.6. To
> update between compatible versions, you simply replace the executables
> while the server is down and restart the server. The data directory
> remains unchanged — minor upgrades are that simple."
While that is the rule, there have been exceptions, one I could find:
http://www.postgresql.org/docs/9.1/interactive/release-8-0-3.html
Per another post down thread, the prudent thing to do is to read the
Release Notes for each release.
>
> --
> Alex
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-01-12 15:29:22 | Re: Giving error for function |
Previous Message | James Keener | 2016-01-12 15:00:30 | Re: WIP: CoC |