Re: Problem setting up a user and a Db... - Mailing list pgsql-general

From John R Pierce
Subject Re: Problem setting up a user and a Db...
Date
Msg-id 4DF1CE51.7000705@hogranch.com
Whole thread Raw
In response to Problem setting up a user and a Db...  (Bruno Boettcher <bboett@free.fr>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Bruno Boettcher
Date:
Subject: Problem setting up a user and a Db...
Next
From: Vikram A
Date:
Subject: PGP encrypt/decrypt - Prereqistes