<div id="RTEContent">thanks every body, <br> <br> i actually have already loaded all the shape files in the folder where the shp2pgsql exists.<br> <br> so i considered the hint to include the myschema thing...<br> <br> <span style="font-weight: bold;"> ./shp2pgsql -s 26911 River.shp River myschema.myRiverdb > River.sql</span><br> <br> but still it returns >> bash: River.sql: Permission denied<br> <br> it looks like there is a brain cracking challenge at every step of this code...well atleast<br> <br> it doesnot say this time that the shape files cannot be opened! Any idea why I am not <br> <br> allowed to create the river.sql --- i am thankful for the explanation as always! <br> <br> henok<br> <br><br><b><i>Barend Köbben <kobben@itc.nl></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Hi Henok,<br> <br>possible solutions:<br> <br>1) you do not
include the [schema.]database in the paramters. Not sure if it is required, but it might be, so uit would be:<br>./shp2pgsql -s 26911 River.shp River [mySchema.]myDB> River.sql<br> <br>2) you have only copied the *.shp file to the loader directory, but not the other associated (and needed fiel). These include at least *.dbf and *.shx , in many cases also *.sbn, *.prj or *.sbx<br> <br>keep trying ;-)<br>____________________________ <br>Barend Köbben <br>International Institute for Geo-information Sciences and Earth Observation (ITC) <br>PO Box 6, 7500AA Enschede (The Netherlands) <br>ph: +31-(0)534874253; fax: +31-(0)534874335 <br>_____________________________ <br><br>________________________________<br><br>From: postgis-users-bounces@postgis.refractions.net on behalf of henok tadesse<br>Sent: Wed 28.12.2005 14:37<br>To: PostGIS Users Discussion<br>Subject: RE: [postgis-users] problem with shp2pgsql<br><br><br>Thanks for the hint... but i now have corrected the path problems
but i continue to have problems. i am actually working in linux and the shapefile is in the same folder as the shp2pgsql. <br> <br> ./shp2pgsql -s 26911 River.shp River > River.sql<br><br>or i have also tried this one...<br><br> /shp2pgsql -s 26911 River.shp River | psql myRiverdb.sql<br><br>I am using the shapefile and tutorial from carto.net just to first test if it works but in<br>both cases, it returns River.shp: shape (.shp) or index files (.shx) can not be opened.<br><br>I really do understand this. why it cannot be opened? <br><br>with thanks in advance,<br><br><br>Barend Köbben <kobben @itc.nl=""> wrote: <br><br> What they mean is: If the shapefile is in the "loader directory" (ie the directory the shp2pgsql executable is in) you only need to specify the shapefiles name, otherwise make sure you state the full path:<br> <br> eg. for windows: <br> shp2pgsql.exe C:\mydirectory\asubdirectory\myshapefile.shp mytable myDB<br> <br> ____________________________
<br> Barend Köbben <br> International Institute for Geo-information Sciences and Earth Observation (ITC) <br> PO Box 6, 7500AA Enschede (The Netherlands) <br> ph: +31-(0)534874253; fax: +31-(0)534874335 <br> _____________________________ <br> <br> ________________________________<br> <br> From: postgis-users-bounces@postgis.refractions.net on behalf of henok tadesse<br> Sent: Tue 27.12.2005 20:15<br> To: postgis-users@postgis.refractions.net<br> Subject: [postgis-users] problem with shp2pgsql<br> <br> <br> hello,<br> <br> I was trying to load a shape file into my postgis database. Some body in this forum once said the shapefile should be put in the loader directory. But i could not really find out where the loader directory is although i used this command to load the dumper!<br> <br> <br> <br> # cd postgis-1.1.0/loader <br> # make<br> # make install<br> <br> Should the shape file necessarily be in the loader dirctory to be used in shp2pgsql? if yes, where can i find it?<br> <br>
thanks in advance,<br> <br> henok<br> <br> <br> ________________________________<br> <br> Yahoo! Photos - NEW, now offering a quality print service from just 8p a photo.<br> _______________________________________________<br> postgis-users mailing list<br> postgis-users@postgis.refractions.net<br> http://postgis.refractions.net/mailman/listinfo/postgis-users<br> <br><br><br>________________________________<br><br>To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre <http:> .<br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></http:></kobben></blockquote><br></div><p>
<hr size=1><font face="Arial" size="2"><a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Yahoo! Photos</b></a> – <font color="red">NEW</font>, now offering a <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/">quality print service</a> from just 8p a photo.</font>