[postgis-users] moving from PostgreSQL 8.0.1 to 8.1.1

[Michael Fuhr]

On Tue, Jan 17, 2006 at 03:36:23PM -0800, Ken-ichi wrote:
> Hi all.  I'm trying to move a PostGIS database from one machine running 
> PostgreSQL 8.0.1 / PostGIS 1.1 to another running PostgreSQL 8.1.1 / 
> PostGIS 1.1 using the "hard upgrade" procedure in the online 
> documentation.  When I run postgis_restore.pl, it successfully makes the 
> new database, creates plpgsql, and creates all the functions, but it 
> doesn't load my old schema or the old data, nor does it give me any 
> useful error messages.  It just . . . stops, I hit enter, and I'm back 
> at the command prompt.

There's an "oops" in postgis_restore.pl -- a couple of lines were
uncommented during testing that should be commented out.

http://postgis.refractions.net/pipermail/postgis-users/2006-January/010703.html

-- 
Michael Fuhr