Search Postgresql Archives

Re: Major upgrade of PostgreSQL and MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Sep 13, 2013 at 11:13 AM, Stephen Frost <sfrost@xxxxxxxxxxx> wrote:
> Patrick,
>
>
> On Friday, September 13, 2013, Patrick Dung wrote:
>>
>> >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.
>
>
> And I'm telling you that pg_upgrade does NOT require that. It has a mode
> which allows an in-place upgrade (using hard links) that only requires a bit
> of extra disk space- certainly no where near double on a database of any
> size.

Yeah that was one of the major reasons FOR pg upgrade was that it
could upgrade in place and not require a complete copy of the db.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux