Some functions are just plain Dropped between versions, and actually the ones you cited looked like losers to me. The best bet is to put a dump against a clean newly installed PostGIS database.
P. On Tue, Sep 27, 2011 at 1:55 PM, Greg Allensworth <[email protected]> wrote: > On 9/27/2011 1:41 PM, Paul Ramsey wrote: >> >> Create a new database >> Load PostGIS 1.5 into that blank database >> Load your dump file into that PostGIS 1.5 database >> Watch a lot of errors go by > > Yeah, we got that. Aside from these functions, the process still basically > worked. Still, I'd like for these functions to work. > > >> I think it's possible you've created a new database in PgSQL 9.1 but >> still linked all your functions to the old PostGIS library, which is >> not what you're trying to acheive. >>> >>> ERROR: could not load library "/usr/lib/liblwgeom.so.1.3": >>> /usr/lib/liblwgeom.so.1.3: undefined symbol: DirectFunctionCall2 > > Hey, you're right: I thought the -1.3 looked fishy. I see now that it > created /usr/lib/postgresql/postgis-1.5.so And if I manually run those > commands with the correct .so file specified, it works. Great! > > So, next questions would be: what went wrong that it was using the old .so > in the upgrade output, and how do I correct it? > > I suppose one approach is to take the .dump.ascii file, snip out the CREATE > OR REPLACE FUNCTION paragraphs, substitute the correct .so, and run those. > Does that sound like a good approach, or a Really Bad Idea? > > -- > Greg Allensworth, Web GIS Developer > BS A+ Network+ Security+ Linux+ Server+ ZCE-PHP > GreenInfo Network - Information and Mapping in the Public Interest > 564 Market Street, Suite 510 San Francisco CA 94104 > PH: 415-979-0343 x302 FX: 415-979-0371 email: [email protected] > Web: www.GreenInfo.org www.MapsPortal.org > > Subscribe to MapLines, our e-newsletter, at www.GreenInfo.org > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
