[postgis-users] postgis-1.4.so for pg_upgrade PostgreSQL 8.4.1 to 9.0.4

[Stephen Davies]

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