Hey,<div><br></div><div>I got a new problem now,</div><div><br></div><div>When I was trying to create the database template with the .sh, I got the error message:</div><div>"/usr/share/postlbs/routing_core.sql: No such file or directory"</div>
<div><br></div><div>I found that "postlbs" folder did not exist in my disk. According to some archived emails, this is because "pgrouting" was not installed successfully. But I think I have correctly compiled and installed it.</div>
<div><br></div><div>In addition, I found the ".sql" files located in my "usr/share/pgrouting" folder. So for creating the database template, I can change the path in the ".sh" file and use these ".sql", but I am not sure if this will ruin the later steps.</div>
<div><br></div><div>Thanks,</div><div>Jinfu</div><div><br></div><div><br><div class="gmail_quote">On Thu, May 24, 2012 at 10:24 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"><div class="HOEnZb"><div class="h5">On 5/24/2012 10:11 AM, Jinfu Leng wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hey all,<br>
<br>
I am trying to use postgresql to build the network database, but got a<br>
problem when I ran "createdb -U postgres -T template_routing 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 used<br>
"trust" to replace "md5" in pg_hba file.<br>
</blockquote>
<br></div></div>
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>
______________________________<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>
</blockquote></div><br></div>