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