[postgis-users] Schema support in loader/dumper
strk
strk at keybit.net
Fri Mar 19 10:42:12 PST 2004
On Fri, Mar 19, 2004 at 10:27:19AM -0800, David Blasby wrote:
> > Not so easy. Your best bet is a (data-only)dump/restore.
>
> I still use the same database I used with one of the original postgis
> version (0.3 - like 2 years ago). I just overwrite the libpostgis the
> database is pointing to. MAKE SURE YOU BACK IT UP BEFORE YOU OVERWRITE
> IT. There are a few risks with doing this, but its a lot easier than a
> full dump-and-restore.
>
> I'd still recommend the dump-and-restore, but if you want to live with a
> little bit of risk, you should be able to just overwrite libpostgis.so
> with a new version.
>
> dave
When plpgsql functions are changed this is not enough.
The problem found is about AddGeometryColumn/DropGeometryColumn changes.
Maybe we should provide a postgis_update-<from_ver>-<to_ver>.sql file.
--strk;
More information about the postgis-users
mailing list