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@gregsmith.com http://www.gregsmith.com Baltimore, MD