On Tue, Jan 12, 2016 at 3:25 PM, John R Pierce <pie...@hogranch.com> wrote:
> 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> > 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 > > Thanks everyone for your quick comments, appreciate it ! Yes nothing specifically mentioned for 9.3.4 to 9.3.10 Regards...