[postgis-users] Postgis upgrade instrucitons

[Ethan Alpert]

Ack!! Are you kidding me? I have a 100 million tuple DB I've built It
took 20+hours to ingest. Is this really the ONLY way??

UPGRADING:

Upgrading PostGIS can be tricky, because the underlying C libraries
which 
support the object types and geometries may have changed between
versions.
To avoid problems when upgrading, you will have to dump all the tables
in your database, destroy the database, create a new one, add the
PL/pgSQL
language, upload the new postgis.sql file, then upload your database
dump:

  pg_dump -t "*" -f dumpfile.sql yourdatabase
  dropdb yourdatabase
  createdb yourdatabase
  createlang plpgsql yourdatabase
  psql -f postgis.sql -d yourdatabase
  psql -f dumpfile.sql -d yourdatabase
  vacuumdb -z yourdatabase