But what I read, in-place upgrade has smaller outage, compared to dump/restore. But so many articles on having bugs afterwards.
Do you think it is a good idea to use pg_upgrade for critical database application?
Or any other tool should I consider? For example - slony?
Thanks for advice.
Regards.
On Tue, Jul 28, 2015 at 1:29 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
On 07/28/2015 01:12 PM, AI Rumman wrote:
Hi,
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.
But keep in mind, it is still an outage.
JD
Thanks for advice.
Regards.
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
