[postgis-users] Postgis upgrade instrucitons

[Ethan Alpert]

Well in this case the medicine is worse than the illness. I'm going to
have to schedule downtime, send notices to users, and all that BS so I
guess I'll have to figure a way to filter these geometries that cause
the problems. The .sql text file for this database is going to be about
30 GB. I'm betting it takes several hours just to dump. I'm going to
have to wait for a long weekend and the cloesest one is Thanksgiving :(

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Tuesday, October 12, 2004 1:38 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgis upgrade instrucitons


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