Re: Best Current Pratice Postgres upgrade 6.5-->7.2
On Thu, 20 Nov 2003 at 02:50 GMT, Henry Hollenberg penned:
> I have a database running on potato using postgres 6.5 that I'd like
> to upgrade to Woody running postgres 7.2.
> The docs seem to imply that upgrading with this big a jump from 6.5 to
> 7.2 is dangerous.....even if I do it by hand like so:
> pg_dump mydatabase > dump.mydatabase destroydb mydatabase upgrade the
> database system to 7.2 createdb mydatabase psql < dump.mydatabase
> Can this large jump be made safely?
> If not, I don't see any other versions of postgres available for
> debian...so how should it be done in smaller increments?
> Do my steps above look reasonable?
> Thanks, Henry Hollenberg email@example.com
I believe the install notes say, somewhere, that it's best to do
incremental jumps, so rather than doing 6.5->7.2 you would do every step
in between. But my memory may be faulty ...
A few weeks ago, I tried to convert my source install of 7.0 to 7.2, and
even that seemed fraught with difficulty. To be honest, as I don't have
an immediate need for a database, I ended up putting the conversion
project on the back burner.
PLEASE don't CC me. Please. Pretty please with sugar on top.
Whatever it takes, just don't CC me! I'm already subscribed!!