[pgrouting-dev] postgresql problems

[Stephen Woodbridge]

You can search for files on your systems with the command locate like:

locate routing_core.sql

If you compiled and installed pgrouting then it might have been install 
under /usr/local/share/postlbs/ check and see if it is there.

-Steve

On 5/24/2012 11:13 PM, Jinfu Leng wrote:
> 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 <mailto: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 <mailto:pgrouting-dev at lists.osgeo.org>
>     http://lists.osgeo.org/ mailman/listinfo/pgrouting-dev
>     <http://lists.osgeo.org/mailman/listinfo/pgrouting-dev>
>
>
>
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev