pg_upgrade on windows vs. linux

I'm preparing to do a 9.0 -> 9.3 upgrade and I'd like to try pg_upgrade.
If I test pg_upgrade on Windows, can I expect it to behave the same on
Linux?

Brian

Windows and Linux are different enough from a PostgreSQL perspective
that you should not. Are you really, really short on space?

Cheers,
David.
On Tue, Jan 07, 2014 at 06:31:59PM -0800, Brian Ghidinelli wrote:
>
> I'm preparing to do a 9.0 -> 9.3 upgrade and I'd like to try
> pg_upgrade. If I test pg_upgrade on Windows, can I expect it to
> behave the same on Linux?
>
>
> Brian

--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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?

Brian

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.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

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

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