[pgrouting-dev] postgresql problems

[Stephen Woodbridge]

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