[postgis-users] Dump and Restore PostGIS Tables - What when dealing with different PostGIS/PostGres Versions?

[Stefan Schwarzer]

Hi there

I have the impression that there are two methods for re-inserting a  
(postgres/postgis) dump:

	1) pg_restore
	2) postgis_restore.pl lwpostgis.sql newdb olddb.dump -E=UNICODE >  
restore.log

If my postgis functions are already installed in the database, then I  
would go for the first solution, no?

But how to handle different versions of Postgis? And eventually  
PostGres? Does it play a role? How do I upgrade?

Thanks for any advice.

Stef