Hi Maruf,<div><br></div><div>Looking at the Gist, there is no need anymore to compile PostGIS 2.0, because it already has packages in the UbuntuGIS unstable repository.</div><div>It furthermore installs pgRouting as packages as well as osm2pgrouting, which is good.</div>
<div><br></div><div>I don't know, why it doesn't work in your case and why you're missing tables. Well, there is a t least one issue with osm2pgrouting when using PostGIS 2.0, which requires some hack. And you may have to load "legacy.sql".</div>
<div>Just a few days ago I updated the pgRouting installer for the new OSGeo Live DVD and that it is working has been confirmed by several people:</div><div><a href="http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh">http://trac.osgeo.org/osgeo/browser/livedvd/gisvm/branches/osgeolive_6_5/bin/install_pgrouting.sh</a></div>
<div><br></div><div>So maybe this OSGeo Live install script is more up-to-date. Because pgRouting/osm2pgrouting still may have issues with PostGIS 2.0, you either need to fix some wrapper SQL functions or load legacy.sql to your database (see line #97).</div>
<div>And the hack for osm2pgrouting is from line #138. </div><div><br></div><div>Daniel<br><br><div class="gmail_quote">On Fri, Feb 22, 2013 at 12:31 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>OS: Ubuntu 12.04<br></div><div>I have installed pgrouting dependencies using this url <a href="https://gist.github.com/djq/2846196" target="_blank">https://gist.github.com/djq/2846196</a><br>
</div><div>
and pgrouting using this tutorial <a href="http://pgrouting.org/docs/1.x/install.html" target="_blank">http://pgrouting.org/docs/1.x/install.html</a><br>
</div><div>and didn't use LiveDVD.<br></div><div><br></div><div>Please let me know if any more info is needed.<span class="HOEnZb"><font color="#888888"><br></font></span></div><span class="HOEnZb"><font color="#888888"><div class="gmail_extra">
<br></div><div class="gmail_extra">Maruf<br></div></font></span><div><div class="h5"><div class="gmail_extra">
<br><div class="gmail_quote">On Thu, Feb 21, 2013 at 8:59 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>Can you provide more information?</div><div>Like which OS you use, how you installed pgRouting, etc..</div><div>Do you use the OSGeo LiveDVD?</div><div><br></div><div>Daniel</div><div><br><br>
<div class="gmail_quote"><div><div>
On Thu, Feb 21, 2013 at 11:38 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"><div><div>Hi<br></div>I am trying to use pgrouting following this <a href="http://workshop.pgrouting.org/index.html" target="_blank">tutorial</a>. Currently I am in section<a href="http://workshop.pgrouting.org/chapters/osm2pgrouting.html" target="_blank"> 4.2</a>. However when I try to execute the command of section 4.2, it only creates 3 tables name <i>classes, nodes</i> and <i>types</i>. But the document says, it should create 8 tables.<br>
<br></div>Where is the problem? How can I solve this?<br><div><br><br clear="all"><div><div>Thanks<span><font color="#888888"><br>Maruf</font></span></div></div></div></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></blockquote></div></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>
</div>