Re: PostgreSQL upgrade 9.3.4 -> 9.3.10

On Tue, Jan 12, 2016 at 10:28 AM, Dev Kumkar <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."

--
Alex