Re: pg_upgrade on windows vs. linux

On Jan 7, 2014, at 7:57 PM, David Fetter <david(at)fetter(dot)org> wrote:

> On Tue, Jan 07, 2014 at 07:31:52PM -0800, Brian Ghidinelli wrote:
>>
>> On 1/7/2014 7:24 PM, David Fetter wrote:
>>> Windows and Linux are different enough from a PostgreSQL perspective
>>> that you should not. Are you really, really short on space?
>>
>> Thanks. And no - but short on non-production machines with which to
>> test. Production is RHEL managed with yum so I'm not sure how to
>> install 9.3 alongside 9.0 without screwing up dependencies/etc?
>
> 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.

Or a VM. Spin up a CentOS VM on your Windows machine (VMWare
if you have any budget at all, VirtualBox otherwise). Performance
won’t be the same, but everything else can be near identical to
production.

Cheers,
Steve