Помогите устранить ошибку в shp2pgsql

[Protectr]

При переконвертации Shape файла в SQL программа выдает ошибку :


Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Вот в общем весь лог:

Connecting: host=localhost port=5432 user=postgres dbname=postgres password='******'
Connection succeeded.
Connection: host=localhost port=5432 user=postgres dbname=postgres password='******'
Destination: public.ukraine-water-a
Source File: D:\Program Files\PostgreSQL\9.0\bin\ukraine-water-a
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."ukraine-water-a" (gid serial PRIMARY KEY,
"osm_id" float8,
"name" varchar(61),
"waterway" varchar(10),
"landuse" varchar(9),
"source" varchar(20));
SELECT A"
Failed in pgui_exec(): ERROR: function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 10: SELECT AddGeometryColumn('public','ukraine-water-a','the_geo...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Shapefile import failed.


В чем причина??

[Denis Rykov]

Похоже, что у вас просто в целевой базе данных отсутствуют PostGIS-функции.
http://gis-lab.info/qa/postgis-install.html#03