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)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general