[postgis-users] Unable to import shapefile using Shapefile toPostGIS Importer

[Smaran Harihar]

Hi,

Ok so should I run

SELECT postgis_full_version();

in terminal or PSQL console? When I run it in the PSQL console I am getting
no error but in the terminal I get this error,

-su: syntax error near unexpected token `('

Also, I forgot to add this in the previous mail, but I created a datasource
testdb in pgadmin3 and then created PostGIS database shpRepo. These were
the parameters,

Datasource name: testdb
database: shpRepo
schema: public

These are the parameters set in the Geoserver.

Thanks & Regards,
Smaran Harihar


On Thu, May 17, 2012 at 4:19 PM, Paragon Corporation <lr at pcorp.us> wrote:

> **
> Smaran,
>
> This error usually happens for one of 2 reasons
> 1) You are trying to import into a database that is not PostGIS enabled
> 2) You installed PostGIS in a schema other than public and did not add
> that schema to your search_path.
> (this you can fix by adding the schema to your database search path --
> pgAdmin has it under variables, or you can run something like
>
> ALTER DATABASE set search_path=public,the_schema_you_installed_postgis_in
>
> To verify one of these is the issue run this command:
>
> SELECT postgis_full_version();
>
> If it fails one of the above is usually the reason.
> Couple of comments to answer your questions
> 1) You shouldn't have postgis installed in your postgres database.
> 2) You can install postgis in as many databases as you want
>
>
> If you are on PostgreSQL 9.1 and are running PostGIS 2.0 just run the SQL
> statement
>
> CREATE EXTENSION postgis;
>
> in the database you want to install it in.
>
> If you are in a lower database or lower PostGIS
> you can create a new database and use template_postgis or
> template_postgis20 as your template.
>
>
> Hope that helps,
> Regina
> http://www.postgis.us
>
>
>
>  ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Smaran
> Harihar
> *Sent:* Thursday, May 17, 2012 3:08 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Unable to import shapefile using Shapefile
> toPostGIS Importer
>
> Hi I am trying to import shapefile into the Postgres database that I
> created in PGAdmin3 using the Shapefile to PostGIS Importer and despite the
> connection being successful I am receiving the following error,
>
>  Connection: host=localhost port=5432 user=admin dbname=shpRepo
> password='**********'
> Destination: public.AllQuebecSpecies
> Source File:
> /home/smaranh/development/Biodiversity/biodiversity/shapefile/AllQuebecSpecies
> Shapefile type: Point
> Postgis type: POINT[2]
> Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
> SET STANDARD_CONFORMING_STRINGS TO ON;
> BEGIN;
> CREATE TABLE "public"."AllQuebecSpecies" (gid serial PRIMARY KEY,
> "family" varchar(50),
> "species" varchar(50));
> SELECT AddGeometryColumn('public','AllQuebecSpecies','the_geom','-1"
> Failed in pgui_exec(): ERROR:  function addgeometrycolumn(unknown,
> unknown, unknown, unknown, unknown, integer) does not exist
> LINE 7: SELECT AddGeometryColumn('public','AllQuebecSpecies','the_ge...
>                ^
> HINT:  No function matches the given name and argument types. You might
> need to add explicit type casts.
>
> Shapefile import failed.
>
> Also I am new to PostGIS and Postgres so this might sound very dumb
> question but if I create a new database in pgadmin3, is it postgres
> database or postgis db? If it is postgres db then probably that is why
> shape file is not able to be imported since it can only be imported into
> PostGIS db (i think). So how can i convert a Postgres db to PostGIS?
>
> --
> Thanks & Regards
> Smaran Harihar
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Thanks & Regards
Smaran Harihar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120518/6280423b/attachment.html>