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