From: Stephen Frost <sfrost@snowman.net> To: Patrick Dung <patrick_dkt@yahoo.com.hk> Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>; Ivan Voras <ivoras@freebsd.org>; Tom Lane <tgl@sss.pgh.pa.us> Sent: Saturday, September 14, 2013 12:43 AM Subject: Re: [GENERAL] Major upgrade of PostgreSQL and MySQL
* Patrick Dung (patrick_dkt@yahoo.com.hk) 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.