Thread: Problem setting up a user and a Db...

Problem setting up a user and a Db...

From
Bruno Boettcher
Date:
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...

--
ciao bboett
==============================================================
bboett@adlp.org
http://bboett.free.fr

Re: Problem setting up a user and a Db...

From
John R Pierce
Date:
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