[pgrouting-dev] postgresql problems

[Jinfu Leng]

Hey,

I got a new problem now,

When I was trying to create the database template with the .sh, I got the
error message:
"/usr/share/postlbs/routing_core.sql: No such file or directory"

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.

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.

Thanks,
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/438c855d/attachment.html