Finally getting around to upgrading to 7.4.2 from 7.3.6. I thought I read
somewhere that for this upgrade, it would be advantageous to use pg_dumpall
from the 7.4..x version versus using the version for 7.3.x.. Is that
correct?

TIA
Patrick Hatcher



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

"Patrick Hatcher" <PHatcher@macys.com> writes:[color=blue]
> Finally getting around to upgrading to 7.4.2 from 7.3.6. I thought I read
> somewhere that for this upgrade, it would be advantageous to use pg_dumpall
> from the 7.4..x version versus using the version for 7.3.x.. Is that
> correct?[/color]

In any upgrade (since 7.0, or whenever it was that we started making
pg_dump able to cope with prior versions), it's considered good practice
to use the later pg_dump if you conveniently can. The idea is that this
gets you the benefit of any bug fixes that have appeared in the newer
pg_dump version.

I don't recall at this late hour whether there are any specific bugs
that would make this consideration important for 7.3.6 versus 7.4.2.
But on general principles, I'd recommend doing it that way.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html