Re: pg_upgrade

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Brian Hirt <bhirt(at)me(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_upgrade
Date: 2010-09-29 02:41:38
Message-ID: 201009290241.o8T2fc721668@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brian Hirt wrote:
> Bruce,
>
> The applied patch has the same behavior on i686 Ubuntu 10.04. It
> looks like atol() is just a macro for strtol() in stdio.h. I think
> you want strtoul() instead of strtol()

Yes, thanks. I have now applied that fix in HEAD and 9.0.X.

> when i change str2uint() to use strtoul() pg_upgrade completes without
> a problem (I still haven't tested the upgrade database, but I expect
> that will be just fine).

Yep.

> I think it's pretty uncommon for the OID to be that big which is why
> nobody stumbled onto this. This particular installation has pretty
> much been reloading development databases non stop for the last year.
> Also, people tend to initdb a lot when testing and doing development
> which will keep resetting the oid low.

Yes, seems > 2^31 oids are rarer than I thought.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Wizon 2010-09-29 04:32:30 Fwd: Restore problem from 8.4 backup to 9.0
Previous Message Darren Duncan 2010-09-29 02:18:27 Re: How to handle results with column names clash