[postgis-users] Possible problems with the upgrade doco.

[Steven Bowden]

I have just tried to follow the upgrading doco at
http://postgis.refractions.net/docs/ch02.html#upgrading
and noticed a few things that I think need updated.

Where it mentions
pg_dump -Fc olddb olddb.dump
I think it should be 
pg_dump -Fc olddb > olddb.dump
If I didn't do this pg_dump complained about too many arguments

And at the end where
$ psql newdb
newdb=> drop table spatial_ref_sys;
DROP
newdb=> \i spatial_ref_sys.sql

I had to
$ psql newdb
newdb=> delete from spatial_ref_sys;
newdb=> \i spatial_ref_sys.sql

This is because the spatial_ref_sys.sql doesn't contain any statement to 
create the table after it has been dropped.  It assumes that the table has 
already been created.

This is for when I upgraded from postgis1.0.0-rc3 to postgis1.0.0 on 
PostgreSQL 7.3.4

Regards
Steve