[postgis-users] PostGIS upgrade 2.2.1 -> 2.5.0 Database Import Errors

Patrick Stout pstout at prevagroup.com
Mon Oct 29 07:45:12 PDT 2018


I'm moving a database from PostGIS 2.2.1 to 2.5.0 (PG 9.6). I pg_dumped the
old database and am using pg_restore to import it.

Everything appears to go fine but I'm getting these two errors. Is this
something I need to worry about or can just ignore them?

pg_restore: creating AGGREGATE "public.accum(geometry)"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4925; 1255 348862
AGGREGATE accum(geometry) aed
pg_restore: [archiver (db)] could not execute query: ERROR:  type
"pgis_abs" does not exist
Command was: CREATE AGGREGATE accum(geometry) (
    SFUNC = public.pgis_geometry_accum_transfn,
    STYPE = pgis_abs,
    FINALFUNC = pgis_geometry_accum_finalfn
);

and...

pg_restore: creating AGGREGATE "public.makeline(geometry)"
pg_restore: [archiver (db)] Error from TOC entry 4927; 1255 348864
AGGREGATE makeline(geometry) aed
pg_restore: [archiver (db)] could not execute query: ERROR:  type
"pgis_abs" does not exist
Command was: CREATE AGGREGATE makeline(geometry) (
    SFUNC = public.pgis_geometry_accum_transfn,
    STYPE = pgis_abs,
    FINALFUNC = pgis_geometry_makeline_finalfn
);

Thanks,
Patrick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181029/70c06c58/attachment.html>


More information about the postgis-users mailing list