PostGIS升级2.2.1-> 2.5.0数据库导入错误 [英] PostGIS upgrade 2.2.1 -> 2.5.0 Database Import Errors
本文介绍了PostGIS升级2.2.1-> 2.5.0数据库导入错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我要将数据库从PostGIS 2.2.1迁移到2.5.0(PG 9.6).我pg_dumping旧数据库,并正在使用pg_restore导入它.
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
);
和..
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
);
推荐答案
显然,pgis_abs
列是虚拟列,根据此提交:
#4035,从聚合/收集例程中删除伪pgis_abs类型
#4035, remove dummy pgis_abs type from aggregate/collect routines
听起来像您应该能够在执行升级之前删除pgis_abs
列
Sounds like you should be able to drop the pgis_abs
column before performing the upgrade
披露:我为 EnterpriseDB(EDB)
这篇关于PostGIS升级2.2.1-> 2.5.0数据库导入错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文