Hey Steve,<div><br></div><div>Thanks, I restarted my computer, and then it worked.</div><div><br></div><div>Jinfu<br><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>