Re: PostgreSQL upgrade 9.3.4 -> 9.3.10

[John R Pierce <pierce@xxxxxxxxxxxx>]

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