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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general