[postgis-users] postgis-1.4.so for pg_upgrade PostgreSQL 8.4.1 to9.0.4

[Paragon Corporation]

 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-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Stephen Davies
> Sent: Thursday, October 20, 2011 8:37 PM
> To: postgis-users at 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 at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>