[postgis-users] Schema support in loader/dumper

David Blasby dblasby at refractions.net
Fri Mar 19 10:44:06 PST 2004

strk wrote:

> 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.
> 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.

This sounds like a lot of work.  Perhaps we should just change all the 
should work well for everything but the GiST support stuff...


More information about the postgis-users mailing list