<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/">error</a>.<br><br></div><div>How can I solve this?<br><br></div><div>Thanks<br></div><div>Maruf<br></div><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 class="HOEnZb"><font color="#888888">
<div><br></div><div>Daniel</div></font></span><div class="HOEnZb"><div class="h5"><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">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>