CMake scripts in master branch should install the .sql files into /usr/share/pgrouting.<div>But "official" versions install the files in /usr/share/postlbs. The latter was decided in the early days of pgRouting, but "pgrouting" as directory name made more sense. </div>
<div><br></div><div>Daniel</div><div><br><br><div class="gmail_quote">On Fri, May 25, 2012 at 12:36 PM, Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">You can search for files on your systems with the command locate like:<br>
<br>
locate routing_core.sql<br>
<br>
If you compiled and installed pgrouting then it might have been install under /usr/local/share/postlbs/ check and see if it is there.<br>
<br>
-Steve<div class="im"><br>
<br>
On 5/24/2012 11:13 PM, Jinfu Leng wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Hey,<br>
<br>
I got a new problem now,<br>
<br>
When I was trying to create the database template with the .sh, I got<br>
the error message:<br>
"/usr/share/postlbs/routing_<u></u>core.sql: No such file or directory"<br>
<br>
I found that "postlbs" folder did not exist in my disk. According to<br>
some archived emails, this is because "pgrouting" was not installed<br>
successfully. But I think I have correctly compiled and installed it.<br>
<br>
In addition, I found the ".sql" files located in my<br>
"usr/share/pgrouting" folder. So for creating the database template, I<br>
can change the path in the ".sh" file and use these ".sql", but I am not<br>
sure if this will ruin the later steps.<br>
<br>
Thanks,<br>
Jinfu<br>
<br>
<br>
On Thu, May 24, 2012 at 10:24 PM, Stephen Woodbridge<br></div><div class="im">
<<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a> <mailto:<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.<u></u>com</a>>> wrote:<br>
<br>
On 5/24/2012 10:11 AM, Jinfu Leng wrote:<br>
<br>
Hey all,<br>
<br>
I am trying to use postgresql to build the network database, but<br>
got a<br>
problem when I ran "createdb -U postgres -T template_routing<br>
routing".<br>
Error message:<br>
"createdb: could not connect to database postgres: FATAL: password<br>
authentication failed for user "postgres""<br>
<br>
I already used "passwd" to change the password of "postgres" and<br>
used<br>
"trust" to replace "md5" in pg_hba file.<br>
<br>
<br>
1. you have to restart postgresql after changing the pg_hba file.<br>
2. you might try adding -h localhost to you command.<br>
<br>
-Steve<br>
______________________________ _________________<br>
pgrouting-dev mailing list<br></div>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a> <mailto:<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.<u></u>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/" target="_blank">http://lists.osgeo.org/</a> mailman/listinfo/pgrouting-dev<br>
<<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><u></u>><div class="im"><br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org" target="_blank">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-dev</a><br>
</div></div></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><br>
</div>