<br><br><div class="gmail_quote">On Sun, Mar 10, 2013 at 5:38 AM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div>Hi Daniel<br><br></div>I have reinstalled everything and started from scratch. However when i execute this command <i><b><br>psql -d routing -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql</b><br>
</i></div>it generates this <a href="http://paste.ubuntu.com/5600036/" target="_blank">error</a>.<br></div></div></blockquote><div><br></div><div>You look at the first error and it already tells you the problem:</div><div>
<pre>psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sql:59: ERROR: type "spheroid" already exists</pre></div><div>So you already have PostGIS added to your database.</div><div>Also it seems you're using PostGIS 2.0 and PostgreSQL 9.1, so you can install PostGIS much easier with "CREATE EXTENSION postgis".</div>
<div>Be aware that the workshop was written when no PostGIS 2.0 was available yet. So simple copy & paste might not work every time.</div><div>Furthermore the sample data in dump files (such as notopo.sql) where created with an older version of PostgreSQL.</div>
<div>This can be a reason why things don't work. </div><div><br></div><div>Daniel</div><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><br></div><div>How can I solve this?<br><br></div><div>Thanks<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div>Maruf<br></div></font></span><div>
<div class="h5"><div><br><div><div><div><br></div></div></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Mar 9, 2013 at 9:32 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Maruf,<div><br></div><div>In your first email you wrote, that you created a database first. But the database creation is actually part of SQL dump file already.</div>
<div>You can also just login to some other database and then run "\i path/to/sampledata_notopo.sql"</div>
<div><br></div><div>Inside this file it creates the database like this:</div><div><div>CREATE DATABASE "pgrouting-workshop" WITH TEMPLATE = template_routing ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';</div>
</div><div><br></div><div>So it is looking for a "template_routing" template database, that was mentioned in a previous chapter.</div><div>The errors you posted you need to debug from top. So first it complains about already existing database and second about missing "geometry" things. When using the template database it should work.</div>
<span><font color="#888888">
<div><br></div><div>Daniel</div></font></span><div><div><div><br></div><div><br></div><div><br><br><div class="gmail_quote">On Sun, Mar 10, 2013 at 12:22 AM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Here is the original sampledata_notopo.sql file.<br><a href="https://docs.google.com/file/d/0B3djwV2dbCYZVV9QVjg3TngzUzg/edit?usp=sharing" target="_blank">https://docs.google.com/file/d/0B3djwV2dbCYZVV9QVjg3TngzUzg/edit?usp=sharing</a><br>
</div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Mar 9, 2013 at 9:18 PM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Hi<br></div>The problem still occurs. Here is the <a href="http://paste.ubuntu.com/5599146/" target="_blank">output</a>.<br>
</div>Previously i replaced all '\N', so it wasn't in error list. Now I have run the command in original file.<br>
<br></div>Thanks<span><font color="#888888"><br></font></span></div><span><font color="#888888">Maruf</font></span><div><div><br><div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Sat, Mar 9, 2013 at 8:46 PM, Daniel Kastl <span dir="ltr"><<a href="mailto:daniel@georepublic.de" target="_blank">daniel@georepublic.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Maruf,<div><br></div><div>Could be that this version of the workshop is outdated as it's the one from FOSS4G 2010.</div>
<div>Can you try the workshop FOSS4G 2011 instead?</div><div>The most up-to-date content is always the online version: <a href="http://workshop.pgrouting.org/" target="_blank">http://workshop.pgrouting.org/</a></div>
<div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote"><div><div>On Sat, Mar 9, 2013 at 11:28 PM, maruf rahman <span dir="ltr"><<a href="mailto:maruf.csdu@gmail.com" target="_blank">maruf.csdu@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hi<br><div class="gmail_quote"><div dir="ltr"><div><div><div><br></div>
I am trying to install and use pgrouting using the attached document. Currently I am in step 5.1(Load network data). It says to create a database and load data in it using the following two commands.<br>
<br><i>createdb -U postgres pgrouting-workshop<br><br>psql -U postgres -d pgrouting-workshop \<br>-f ~/Desktop/pgrouting-workshop/data/sampledata_notopo.sql</i><br><br></div>The first one goes well. When I execute the second command I get some errors. Please check <a href="http://paste.ubuntu.com/5598943/" target="_blank">here</a>. <br>
<a href="https://docs.google.com/file/d/0B3djwV2dbCYZMk1kZS1mQmdYVTg/edit?usp=sharing" target="_blank">Here</a> is the sampledata_notopo.sql file.<br>
<br></div><div>How can I solve this problem?<br><br></div><div>Thanks<span><font color="#888888"><span><font color="#888888"><br></font></span></font></span></div><span><font color="#888888"><span><font color="#888888"><div>
Maruf<br></div><div><div><br></div></div>
</font></span></font></span></div>
</div><br></div>
<br></div></div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>
eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</font></span></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br></div></div></div></div></div>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>
</div>
</div></div><br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>
Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span>