Re: Major upgrade of PostgreSQL and MySQL

Patrick Dung wrote on 13.09.2013 18:17:
>> The problem of pg_upgrade is that it needed to hold two set of databases data in the server.
>> This is not be desirable (very slow) or possible (space limitation) for database with huge data.
>>
>> For example, if the old version is already using over 50% of the mount point.
>> The new database may not have enough disk space for the upgrading.

> I think if you use the --link parameter, you don't need additional disk space (or only little).

Thanks for pointing out.

For small or medium sized database, I think file based snapshot (like ZFS) could create backup of the old database quickly.
Also it can rollback quickly.

Thanks,
Patrick