[postgis-users] Postgis upgrade instrucitons

[strk at refractions.net]

On Tue, Oct 12, 2004 at 01:30:07PM -0600, Ethan Alpert wrote:
> 
> 
> 
> 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??

:)
Not *really*.
In postgis-0.9.x there is a postgis_restore.pl script
which should make life easier.
- pg_dump -Fc olddb
- postgis_restore.pl
.. read synopsis ..
--strk;

PS: let me know how it went.

> 
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users