From: | moataz Elmasry <moataz(dot)elmasry(at)iais(dot)fraunhofer(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" |
Date: | 2010-03-30 13:55:34 |
Message-ID: | 4BB202D6.9090503@iais.fraunhofer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi List
This question has already been asked many times, but I didn't find the
answer I'm looking for, so here goes
I use postgresql 8.3 on suse 11.2
I already installed postgresql many times wit postgis support on
debian/ubuntu machines. Never had problems, now I'm installing it for
the first time on suse linux. After installing, I changed the following
in postgresql.conf for a production environment
shared_buffers=128MB
checkpoint_segments=20
maintenance_work_mem=256MB
autovacum=off
And then I restarted postgresql and switched to postgres user, and then:
"createuser gisuser"
After typing password the console gives the error message "createuser:
could not connect to database postgres: FATAL: password authentication
failed for user "postgres"
So I change the user postgres password using the command passwd as root
and I give in the same password and I repeat the createuser command (or
createdb whatever), only to get the same error message
Can someone see what the problem might be?
Best regards
Moataz
From | Date | Subject | |
---|---|---|---|
Next Message | moataz Elmasry | 2010-03-30 13:58:49 | createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" |
Previous Message | Marc Cousin | 2010-03-30 12:22:25 | different behaviour between select and delete when constraint_exclusion = partition |