On 7/28/2015 1:29 PM, Joshua D. Drake wrote:
I need to upgrade Postgresql database from 8.4 to latest stable version
(9.4). The db size is almost 2.5 TB.
Is pg_upgrade in-place is a good idea for it?
With quite a bit of testing, yes.
yeah, that was my thought to... clone the database to a test/staging
machine, and practice running pg_upgrade on it til you get it right.
frankly, I'd want to use a new machine for the final upgrade, too,
stopping your applications, taking a fresh clone, and doing the upgrade,
then swapping it into place, and restarting your applications.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
