Re: Major upgrade of PostgreSQL and MySQL

Merlin Moncure wrote on 12.09.2013 18:37:
>>> By the way, for in-place major version upgrade (not dumping DB and
>>> import again), MySQL is doing a better job in here.
>>
>> http://www.postgresql.org/docs/9.3/static/pgupgrade.html
>
> pgupgrade has nothing to do with this: that's just a tool that does in
> place binary upgrades of the database (basically optimizing the
> dump/reload process).

The link was posted as a response to the part:

   By the way, for in-place major version upgrade
   (not dumping DB and import again), MySQL is doing a better job in here

and for that pg_upgrade *is* a valid alternative.