[GeoNode-users] Import shape file to server

[Jeffrey Johnson]

Ok, then this indicates that postgis is not installed. You need to install it.

On Thu, Jul 30, 2015 at 2:25 PM, GGC Garcia <gacoge at gmail.com> wrote:
> Hello Jeffrey
>
> Thank you for your answer, I try with your recommendations, but I can´t.
>
>
> This is the message when I try to create postgis extension.
>
>
> exampletable=# create extension postgis;
>
> ERROR:  could not open extension control file
> "/usr/share/postgresql/9.1/extensi
> on/postgis.control": No such file or directory
> exampletable=#
>
> Gerardo
>
>
> 2015-07-30 15:57 GMT-05:00 Jeffrey Johnson <ortelius at gmail.com>:
>>
>> This is really a postgres/postgis question, but it looks you need to
>> enable the postgis extension in your database. Try this in the sql
>> console in pgadmin3 while connected to your database.
>>
>> create extension postgis;
>>
>> On Thu, Jul 30, 2015 at 1:54 PM, GGC Garcia <gacoge at gmail.com> wrote:
>> > Hello I have a problem when I try to import one shape file to server
>> > with
>> > pgAdmin3.
>> >
>> > I hope you can help me please.
>> >
>> > This is the message when I do this.
>> >
>> > ______________________________________________________________
>> >
>> > Connecting:  host=192.68.1.1 port=5432 user=root password='************'
>> > dbname=exampletable
>> >
>> > ==============================
>> > Importing with configuration: limite_estatal, public, geom,
>> > C:\Users\Joan\Desktop\DESK\shapes\limite_estatal.shp, mode=c, dump=1,
>> > simple=0, geography=0, index=1, shape=1, srid=0
>> > Shapefile type: Arc
>> > PostGIS type: MULTILINESTRING[2]
>> > Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
>> > SET STANDARD_CONFORMING_STRINGS TO ON;
>> > BEGIN;
>> > CREATE TABLE "public"."limite_estatal" (gid serial,
>> > "left_fid" int4,
>> > "right_fid" int4);
>> > ALTER TABLE "public"."limite_estatal" ADD PRIMARY KEY (gid);
>> > SELECT AddGeometryColumn('publi"
>> > Failed in pgui_exec(): ERROR:  AddGeometryColumns() - invalid SRID
>> > CONTEXT:  SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6)"
>> > PL/pgSQL function "addgeometrycolumn" line 5 at SQL statement
>> >
>> > Shapefile import failed.
>> >
>> >
>> >
>> > Regards
>> >
>> > Gerardo
>> >
>> >
>> >
>> > _______________________________________________
>> > geonode-users mailing list
>> > geonode-users at lists.osgeo.org
>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>> >
>
>