[postgis-users] Early Special: 1.0.0 Released

[strk at refractions.net]

On Wed, Apr 20, 2005 at 01:49:09PM -0400, Stephen Woodbridge wrote:
> Awesome job guys!
> 
> I have a question on upgrading because I have never done that before. 
> I'm on FreeBSD and use the portsupgrade utility so it just pretty much 
> happens. The problem with this is I don't have access to an of the new 
> info until after the upgrade (I should browse CVS I guess).
> 
> My question is do I need to do the dump before the upgrade? or is the 
> dump utility smart enough to dump the old format also. And if so, what 
> is the command I should use to do the dump the  tables?

The online manual show be clear enough, and fixed if is not.
http://postgis.refractions.net/docs/ch02.html#upgrading

Actually.. there's probably an important note missing, which
is that the dump phase (first step) must be done *before*
the new postgis is installed.

The 'make install' command must be given after the dump has
been produced and *before* the postgis_restore.pl script
is invoked. Running postgis_restore.pl *before* the new
postgis library is installed might result in unresolved
references but since you have the dump you can restore
again after installing the new one.

VERY IMPORTANT: make your dumps BEFORE installing the
new postgis !

--strk;

> 
> Thanks,
>   -Steve W.
> 
> Paul Ramsey wrote:
> >Just for you list'ers an early announcement of 1.0.0:
> >
> >After a long series of release candidates, the much anticipated 1.0.0 
> >version of PostGIS has been released. The 1.0.0 version includes 
> >substantial changes over the original 0.X series, most importantly a new 
> >on-disk format which is both more compact and faster to access. The 
> >1.0.0 version is compatible with PostgreSQL 7.2 and higher, but is most 
> >tighhtly integrated with the PostgreSQL 8.0 and higher releases.
> >
> >New features in 1.0.0 include:
> >
> >    * Smaller and faster on-disk formats
> >    * Improved selectivity estimates, including support for join 
> >selectivity and sub-selects
> >    * Hex-based canonical format, for driftless dump and restore
> >    * 4-D geometries
> >    * New functions:
> >          o Polygonize
> >          o AsGML
> >          o ForceRHR
> >          o SnapToGrid
> >          o Geometry Constructors
> >    * Improved JDBC interface with jdbc2 support
> >    * 64-bit platform support
> >    * Performance improvements for common boolean operators
> >
> >Current users of PostGIS will want to read the README file on upgrading 
> >with particular attention to the use of the utils/postgis_restore.pl 
> >script.
> >_______________________________________________
> >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