[pgrouting-dev] postgresql problems

pgRouting pgrouting-dev
1

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.

Any ideas?

Thanks,
Jinfu

2

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

3

Hey Steve,

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

Jinfu

On Thu, May 24, 2012 at 10:24 PM, Stephen Woodbridge <woodbri@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

4

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

5

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@swoodbridge.com <mailto:woodbri@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@lists.osgeo.org <mailto:pgrouting-dev@lists.osgeo.org>
    http://lists.osgeo.org/ mailman/listinfo/pgrouting-dev
    <http://lists.osgeo.org/mailman/listinfo/pgrouting-dev&gt;

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

6

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@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@swoodbridge.com mailto:[woodbri@swoodbridge.com](mailto:woodbri@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@lists.osgeo.org mailto:[pgrouting-dev@lists.osgeo.org](mailto:pgrouting-dev@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de