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

[Stephen Davies]

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-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

-- 
=============================================================================
Stephen Davies Consulting P/L                             Voice: 08-8177 1595
Adelaide, South Australia.                                Fax  : 08-8177 0133
Records & Collections Management.                         Mobile:040 304 0583