From: Stephen Frost <sfrost@xxxxxxxxxxx>
To: Patrick Dung <patrick_dkt@xxxxxxxxxxxx>
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>; Ivan Voras <ivoras@xxxxxxxxxxx>; Tom Lane <tgl@xxxxxxxxxxxxx>
Sent: Saturday, September 14, 2013 12:43 AM
Subject: Re: Major upgrade of PostgreSQL and MySQL
* Patrick Dung (patrick_dkt@xxxxxxxxxxxx) wrote:
>> The problem of pg_upgrade is that it needed to hold two set of databases data in the server.
>What? That's absolutely *not* required for pg_upgrade to work. In
>general, I would recommend that you make a copy of the database, but
>it's certainly not required.
I mean the old version and new version would need to take up disk space on the server.
Thus roughly doubled the disk space used.
Thanks,
Patrick