Re: pg_upgrade project status

On Tue, 27 Jan 2009, Peter Eisentraut wrote:

> On Tuesday 27 January 2009 21:36:01 Dave Page wrote:
>> If it's been around for a year, why hasn't it been
>> submitted long ago so we could have rewritten and reviewed etc. in
>> plenty of time?
>
> It's in the commit fest listing, and the discussion about which programming
> language to port it to happened weeks ago.

But as Robert Haas pointed out upthread that didn't show up there until
after the start of the main commitfest, and I will admit being the culprit
who snuck it onto there. The script was brought up repeatedly going back
to April, but Zdenek didn't explicitly submit it as part of his final set
for the commitfest. It was obvious to me you needed it all
along--Zdenek's other CF submissions implicitly depended on it if your
goal was to upgrade from 8.3 to 8.4 in-place--which is why I nudged him to
do that and then added the result to the page. I'm not sure what arguing
over the exact sequence here accomplishes anyway. It's come up a bunch of
times before, nobody ran with it, and Zdenek was more concerned about
space reservation.

Anyway, I see multiple people who seem excited by playing with a Perl
port. I found a shell->Perl conversion tool recently:
http://search.cpan.org/~clive/App-sh2p-0.04/

If you comment out all the calls to create_mapping which it chokes on for
some reason, it produces a non-functional but helpful conversion into
Perl. But since the primary dirty job here is to review whether the
original script works as expected on the database problems it tries to
solve rather than play with programming languages, I didn't think
reporting progress just on that front was particularly exciting.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD