[pgrouting-dev] postgresql problems

[Daniel Kastl]

CMake scripts in master branch should install the .sql files into
/usr/share/pgrouting.
But "official" versions install the files in /usr/share/postlbs. The latter
was decided in the early days of pgRouting, but "pgrouting" as directory
name made more sense.

Daniel


On Fri, May 25, 2012 at 12:36 PM, Stephen Woodbridge <
woodbri at swoodbridge.com> wrote:

> 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<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<pgrouting-dev at lists.osgeo.org>
>> >
>>    http://lists.osgeo.org/ mailman/listinfo/pgrouting-dev
>>    <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<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<http://lists.osgeo.org/mailman/listinfo/pgrouting-dev>
>



-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120526/0223bb87/attachment.html