Re: pg_upgrade on windows vs. linux

From: Brian Ghidinelli <brian(at)pukkasoft(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: Re: pg_upgrade on windows vs. linux
Date: 2014-01-08 04:15:36
Message-ID: 52CCD0E8.7010109@pukkasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug


On 1/7/2014 7:57 PM, David Fetter wrote:
> Can you get a spare machine to do the dumping/reloading on? If you
> have uptime requirements, you could use logical (slony or skytools,
> e.g.) replication to do the upgrade, round-robin.

We can live with a bit of downtime so if worse comes to worst, we'll do
a dump/reload, but was hoping to try this newfangled pg_upgrade.

I'll give some of these ideas a try, thanks!

Brian

In response to

Browse sfpug by date

  From Date Subject
Next Message Brian Ghidinelli 2014-01-08 22:23:03 Slow 1st queries and RAM size
Previous Message Steve Atkins 2014-01-08 04:01:13 Re: pg_upgrade on windows vs. linux