[postgis-users] Windows installer and 8.1-dev1

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Darryl Watson
> Sent: 13 September 2005 17:09
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Windows installer and 8.1-dev1
> 
> 
> This newbie is unclear about the upgrade procedure from
> PostGIS 1.0.3 to 
> 1.0.4.
> 
> Do we 1.0.4 over the existing version, or do we need to uninstall
> 1.0.3?  I assume a database dump would be prudent also! 


Hi Darryl,

The rule of thumb is that minor upgrades (e.g. 1.0.3 to 1.0.4) do not
require a database dump/restore; however there may be a few rare cases where
it is necessary to dump/restore or execute SQL commands in the database
depending upon the nature of any bugs - the release notes will contain more
information on this.

At the moment, I must confess that I just recreate a new database and reload
any SQL/shape files into the new version directly. However, when I have had
to upgrade I tend to pg_dump the whole database and then use pg_restore with
the -L option to restore just the geometry_columns table data, plus any
tables and indices I have created. It's defintely an area that could be
improved, especially under Win32 which can't natively run any of the PERL
update scripts :(


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk