Re: perpetual dump/restore problem

On Jul 5, 2007, at 2:49 AM, Richard Huxton wrote:

> wu_zhong_min@vrane.com wrote:
>> Dear List,
>> As many of you know every time one wants to upgrade to a major server
>> version, as I want to do now, there is a need for pg_dumpall and
>> restore.  This is a huge undertaking and requires lots of testing and
>> planning.  I do hope that in the future this requirement will be
>> dropped.
>
> There is currently some discussion about an upgrade tool, but there
> has been discussion before. It's not a simple problem, and it won't
> reduce the need for testing, just the dump/restore.

One shot at that would be the pg_migrator tool that Enterprise DB has
put up on pgfoundry (http://pgfoundry.org/frs/?
group_id=1000235&release_id=763).   It does have it's caveats,
though, so make sure to carefully read the documentation in the
download.

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com