Client Authentication - Mailing list pgsql-general

From Stefan Sturm
Subject Client Authentication
Date
Msg-id 6316bee0804172341l81dde8auabd33a6edbf6ac8a@mail.gmail.com
Whole thread Raw
Responses Re: Client Authentication  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Client Authentication  (Klint Gore <kgore4@une.edu.au>)
List pgsql-general
Hello,

I set up a PostgreSQL 8.3.1 Server on my Webserver( located somewhere in the web ).
On my local Server I use the trust method to access the server. But on my Webserver I want to use an user with password to access the Server.
So I did the following:

I created a user( as superuser ) with:
createuser -P username


Then I add a new line to the pg_hba.conf file:
host    all         username      0.0.0.0               md5

I want to access all databases from all IP-Adresses with this user.

But this fails :-(

WHere is my Error? I hope some can help me.

Thanks and greetings,
Stefan Sturm

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: In the belly of the beast (MySQLCon)
Next
From: "A. Kretschmer"
Date:
Subject: Re: Client Authentication