I have run the postgis_upgrade_14_to_15.sql against the 8.4.1 database and installed postgis-1.5.3 into the 9.0.4 database.
Is anything else required before running pg_upgrade? Cheers and thanks, Stephen On Friday 21 October 2011 11:16:47 Paragon Corporation wrote: > Steve, > > Haven't tried myself. Off-hand I don't see why there would be an issue > since the on disk structure didn't change between 1.4 and 1.5. > > At anyrate, probably the first thing you want to do is run the postgis > 1.4-1_5 upgrade > > > -----Original Message----- > > From: postgis-users-boun...@postgis.refractions.net > > [mailto:postgis-users-boun...@postgis.refractions.net] On > > Behalf Of Stephen Davies > > Sent: Thursday, October 20, 2011 8:37 PM > > To: postgis-users@postgis.refractions.net > > Subject: [postgis-users] postgis-1.4.so for pg_upgrade > > PostgreSQL 8.4.1 to9.0.4 > > > > I do not have enough disk space to use dump/reload to migrate > > an 8.4.1 spatial database to 9.0.4 so hope to use pg_upgrade. > > > > However, to do that, it seems that I need to have a 9.0.4 version of > > > > postgis-1.4.so: > > | Your installation references loadable libraries that are > > > > missing from > > > > | the new installation. You can add these libraries to the new > > | installation, or remove the functions using them from the old > > | installation. A list of the problem libraries is in the file > > | "/home/postgres/loadable_libraries.txt". > > > > [postgres@mustang ~]$ cat loadable_libraries.txt Failed to > > load library: > > $libdir/postgis-1.4 > > ERROR: could not access file "$libdir/postgis-1.4": No such > > file or directory > > > > If I try to create a 9.0.4 version of postgis-1.4.so, I get: > > > > make[1]: Entering directory `/var/sources/postgis-1.4.0/postgis' > > gcc -E -traditional-cpp postgis.sql.in.c | grep -v '^#' > > > postgis.sql.in sed 's,MODULE_PATHNAME,$libdir/postgis-1.4,g' > > postgis.sql.in >postgis.sql gcc -E -traditional-cpp > > uninstall_postgis.sql.in.c | grep -v '^#' > > > uninstall_postgis.sql.in sed > > 's,MODULE_PATHNAME,$libdir/uninstall_postgis-1.4,g' > > uninstall_postgis.sql.in >uninstall_postgis.sql > > "/usr/bin/perl" ../utils/postgis_proc_upgrade.pl postgis.sql > > > > > postgis_upgrade.sql gcc -O2 -Wall -Wmissing-prototypes > > > > -Wpointer-arith -Wdeclaration-after- statement -Wendif-labels > > -fno-strict-aliasing -fwrapv -fpic -I/usr/include - > > I../liblwgeom -I. -I. -I/usr/local/pgsql904/include/server - > > I/usr/local/pgsql904/include/internal -D_GNU_SOURCE -c -o > > lwgeom_pg.o > > lwgeom_pg.c > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after- statement -Wendif-labels > > -fno-strict-aliasing -fwrapv -fpic -I/usr/include - > > I../liblwgeom -I. -I. -I/usr/local/pgsql904/include/server - > > I/usr/local/pgsql904/include/internal -D_GNU_SOURCE -c -o > > lwgeom_debug.o > > lwgeom_debug.c > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith > > -Wdeclaration-after- statement -Wendif-labels > > -fno-strict-aliasing -fwrapv -fpic -I/usr/include - > > I../liblwgeom -I. -I. -I/usr/local/pgsql904/include/server - > > I/usr/local/pgsql904/include/internal -D_GNU_SOURCE -c -o > > lwgeom_accum.o > > lwgeom_accum.c > > lwgeom_accum.c: In function 'pgis_geometry_accum_transfn': > > lwgeom_accum.c:110: error: 'WindowAggState' has no member > > named 'wincontext' > > make[1]: *** [lwgeom_accum.o] Error 1 > > make[1]: Leaving directory `/var/sources/postgis-1.4.0/postgis' > > make: *** [postgis] Error 2 > > > > So I then made a symlink from my 9.0.4 postgis-1.5.so to > > postgis-1.4.so and pg_upgrade was happy: > > > > *Clusters are compatible* > > > > Is it safe to proceed with this setup? > > > > Cheers and thanks, > > Stephen > > -- > > ============================================================== > > =============== > > Stephen Davies Consulting P/L > > Voice: 08-8177 1595 > > Adelaide, South Australia. Fax > > > > : 08-8177 0133 > > > > Records & Collections Management. > > Mobile:040 304 0583 > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users -- ============================================================================= Stephen Davies Consulting P/L Voice: 08-8177 1595 Adelaide, South Australia. Fax : 08-8177 0133 Records & Collections Management. Mobile:040 304 0583 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
