我在试图恢复postgres数据库。
此数据库包括postgis数据。但是,在还原sql转储时,我遇到了以下错误:
psql:postgis_db_dump.sql:2174: ERROR: type "public.pgis_abs" does not exist
正在运行的系统已经安装了postgresql-10-postgis-2.4,而我试图将其还原到的新系统也安装了postgresql-11-postgis-2.5
关于旧系统dT \dT给出:
Schema | Name | Description
--------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
public | addbandarg | postgis raster type: A composite type used as input into the ST_AddBand function defining the attributes and initial value of the new band.
public | agg_count |
public | agg_samealignment |
public | box2d | postgis type: A box composed of x min, ymin, xmax, ymax. Often used to return the 2d enclosing box of a geometry.
public | box2df |
public | box3d | postgis type: A box composed of x min, ymin, zmin, xmax, ymax, zmax. Often used to return the 3d extent of a geometry or collection of geometries.
public | box3d_extent |
public | chip |
public | geography | postgis type: Ellipsoidal spatial data type.
public | geometry | postgis type: Planar spatial data type.
public | geometry_dump | postgis type: A spatial datatype with two fields - geom (holding a geometry object) and path[] (a 1-d array holding the position of the geometry within the dumped object.)
public | geomval | postgis raster type: A spatial datatype with two fields - geom (holding a geometry object) and val (holding a double precision pixel value from a raster band).
public | gidx |
public | pgis_abs |
public | rastbandarg | postgis raster type: A composite type for use when needing to express a raster and a band index of that raster.
public | raster | postgis raster type: raster spatial data type.
public | reclassarg | postgis raster type: A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
public | spheroid |
public | summarystats | postgis raster type: A composite type returned by the ST_SummaryStats and ST_SummaryStatsAgg functions.
public | unionarg | postgis raster type: A composite type used as input into the ST_Union function defining the bands to be processed and behavior of the UNION operation.
public | valid_detail |
(21 rows)
但在新的系统里:
Schema | Name | Description
--------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
public | addbandarg | postgis raster type: A composite type used as input into the ST_AddBand function defining the attributes and initial value of the new band.
public | agg_count |
public | agg_samealignment |
public | box2d | postgis type: A box composed of x min, ymin, xmax, ymax. Often used to return the 2d enclosing box of a geometry.
public | box2df |
public | box3d | postgis type: A box composed of x min, ymin, zmin, xmax, ymax, zmax. Often used to return the 3d extent of a geometry or collection of geometries.
public | geography | postgis type: Ellipsoidal spatial data type.
public | geometry | postgis type: Planar spatial data type.
public | geometry_dump | postgis type: A spatial datatype with two fields - geom (holding a geometry object) and path[] (a 1-d array holding the position of the geometry within the dumped object.)
public | geomval | postgis raster type: A spatial datatype with two fields - geom (holding a geometry object) and val (holding a double precision pixel value from a raster band).
public | gidx |
public | rastbandarg | postgis raster type: A composite type for use when needing to express a raster and a band index of that raster.
public | raster | postgis raster type: raster spatial data type.
public | reclassarg | postgis raster type: A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
public | spheroid |
public | summarystats | postgis raster type: A composite type returned by the ST_SummaryStats and ST_SummaryStatsAgg functions.
public | tablefunc_crosstab_2 |
public | tablefunc_crosstab_3 |
public | tablefunc_crosstab_4 |
public | textual_identity |
public | unionarg | postgis raster type: A composite type used as input into the ST_Union function defining the bands to be processed and behavior of the UNION operation.
public | valid_detail |
(22 rows)
数据类型似乎不再存在。有人知道处理这件事的最佳方法吗?
https://stackoverflow.com/questions/59296323
复制相似问题