[postgis-users] Postgis upgrade instrucitons

[strk at refractions.net]

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

You need a downtime only if users have to write to the db.
As an alternative, you can just upgrade the library, and stay
with old scripts. I think many people do this.
--strk;

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