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

strk at refractions.net strk at refractions.net
Tue May 10 01:15:39 PDT 2005


Documentation updated. Thanks for pointing out.
--strk;

On Tue, May 10, 2005 at 10:10:40AM +1000, Steven Bowden wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list