Heine Ferreira wrote:
> Hi
>
> When you install a newer version of Postgres how do you upgrade your
> database to the new format?
> Apparantly you can't just backup the old database and restore it on
> the new software.
> How do you do this on Windows?
you pg_dump >dumpfile.sql the old one, psql -f dumpfile.sql to the new.
Typically, you only need to do this between major upgrades, like 8.2.x
to 8.3.y ... 8.3.x to 8.3.y doesn't require a dump/restore unless the
release notes state otherwise (this has only happened a few times, I
think there was a 8.0.1->8.0.N that required it due to a minor change
required by a bugfix)
