[pgrouting-dev] postgresql problems

[Jinfu Leng]

Hey Steve,

Thanks, I restarted my computer, and then it worked.

Jinfu

On Thu, May 24, 2012 at 10:24 PM, Stephen Woodbridge <
woodbri at swoodbridge.com> wrote:

> On 5/24/2012 10:11 AM, Jinfu Leng wrote:
>
>> Hey all,
>>
>> I am trying to use postgresql to build the network database, but got a
>> problem when I ran "createdb -U postgres -T template_routing routing".
>> Error message:
>> "createdb: could not connect to database postgres: FATAL:  password
>> authentication failed for user "postgres""
>>
>> I already used "passwd" to change the password of "postgres" and used
>> "trust" to replace "md5" in pg_hba file.
>>
>
> 1. you have to restart postgresql after changing the pg_hba file.
> 2. you might try adding -h localhost to you command.
>
> -Steve
> ______________________________**_________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/pgrouting-dev<http://lists.osgeo.org/mailman/listinfo/pgrouting-dev>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120525/bce3e92d/attachment.html