Search Postgresql Archives

Re: PostgreSQL upgrade 9.3.4 -> 9.3.10

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/12/2016 01:37 AM, Shulgin, Oleksandr wrote:
On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar <devdas.kumkar@xxxxxxxxx
<mailto:devdas.kumkar@xxxxxxxxx>> 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.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux