Hi,<div><br></div><div>Ok so should I run</div><div><br></div><div><span style="color:rgb(0,0,255);font-family:Arial;text-align:-webkit-left">SELECT postgis_full_version();</span></div><div><span style="color:rgb(0,0,255);font-family:Arial;text-align:-webkit-left"><br>
</span></div><div><span style="font-family:Arial;text-align:-webkit-left">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,</span></div><div><span style="font-family:Arial;text-align:-webkit-left"><br>
</span></div><div><span style="text-align:-webkit-left"><font face="Arial" color="#ff0000">-su: syntax error near unexpected token `('</font></span></div><div><br></div><div>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,</div>
<div><br></div><div>Datasource name: testdb</div><div>database: shpRepo</div><div>schema: public</div><div><br></div><div>These are the parameters set in the Geoserver.</div><div><br></div><div>Thanks & Regards,</div>
<div>Smaran Harihar</div><div> <br><br><div class="gmail_quote">On Thu, May 17, 2012 at 4:19 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Smaran,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">This error usually happens for one of 2
reasons</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">1) You are trying to import into a database that is not
PostGIS enabled</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">2) You installed PostGIS in a schema other than public and did
not add that schema to your search_path. </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">(this you can fix by adding the schema to your database search
path -- pgAdmin has it under variables, or you can run something
like</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">ALTER DATABASE set
search_path=public,the_schema_you_installed_postgis_in</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">To verify one of these is the issue run this
command:</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">SELECT postgis_full_version();</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">If it fails one of the above is usually the
reason.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Couple of comments to answer your
questions</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">1) You shouldn't have postgis installed in your postgres
database.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">2) You can install postgis in as many databases as you
want </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">If you are on PostgreSQL 9.1 and are running PostGIS 2.0 just
run the SQL statement</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">CREATE EXTENSION postgis;</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">in the database you want to install it in.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">If you are in a lower database or lower
PostGIS</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">you can create a new database and use template_postgis or
template_postgis20 as your template.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div><font color="#0000ff" face="Arial"></font><br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px" dir="ltr">
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Smaran Harihar<br><b>Sent:</b> Thursday, May 17, 2012 3:08
PM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> [postgis-users]
Unable to import shapefile using Shapefile toPostGIS
Importer<br></font><br></div><div><div class="h5">
<div></div>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,
<div><br></div>
<div>
<div><font color="#ff0000">Connection: host=localhost port=5432 user=admin
dbname=shpRepo password='**********' </font></div>
<div><font color="#ff0000">Destination: public.AllQuebecSpecies</font></div>
<div><font color="#ff0000">Source File:
/home/smaranh/development/Biodiversity/biodiversity/shapefile/AllQuebecSpecies</font></div>
<div><font color="#ff0000">Shapefile type: Point</font></div>
<div><font color="#ff0000">Postgis type: POINT[2]</font></div>
<div><font color="#ff0000">Failed SQL begins: "SET CLIENT_ENCODING TO
UTF8;</font></div>
<div><font color="#ff0000">SET STANDARD_CONFORMING_STRINGS TO ON;</font></div>
<div><font color="#ff0000">BEGIN;</font></div>
<div><font color="#ff0000">CREATE TABLE "public"."AllQuebecSpecies" (gid serial
PRIMARY KEY,</font></div>
<div><font color="#ff0000">"family" varchar(50),</font></div>
<div><font color="#ff0000">"species" varchar(50));</font></div>
<div><font color="#ff0000">SELECT
AddGeometryColumn('public','AllQuebecSpecies','the_geom','-1"</font></div>
<div><font color="#ff0000">Failed in pgui_exec(): ERROR: function
addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does
not exist</font></div>
<div><font color="#ff0000">LINE 7: SELECT
AddGeometryColumn('public','AllQuebecSpecies','the_ge...</font></div>
<div><font color="#ff0000">
^</font></div>
<div><font color="#ff0000">HINT: No function matches the given name and
argument types. You might need to add explicit type casts.</font></div>
<div><font color="#ff0000"><br></font></div>
<div><font color="#ff0000">Shapefile import failed.</font></div>
<div><br></div>
<div>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?</div>
<div><br></div>-- <br>Thanks & Regards
<div>Smaran Harihar</div><br></div></div></div></blockquote></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & Regards<div>Smaran Harihar</div><br>
</div>