Problem setting up a user and a Db...

On 06/10/11 12:50 AM, Bruno Boettcher wrote:

Hello,

seems a stupid problem, but somehow i am not able to solve it....

i want to set up an environment identical to one on another server, thus i need a user and db
which match the ones on the production server and the whole thing with password identification...

so i tried the following:
createuser -d -l -P -R -S rahhar
createdb -O rahhar -U rahhar -W m4rr6

in the pg_hba i have a line
host all all 127.0.0.1/32 md5

the creatuser passes fine, asks me for the password, but the createdb fails
with an ident error....

and now i am clueless about what's going wrong...

if you don't specify -h localhost, postgres tools use the unix domain
socket, which is represented in pg_hba.conf by the `local` line(s). I'm
guessing this line currently reads...

local all all ident

....

--
john r pierce N 37, W 122
santa cruz ca mid-left coast