From: | Andy Colson <andy(at)squeakycode(dot)net> |
---|---|
To: | moataz Elmasry <moataz(dot)elmasry(at)iais(dot)fraunhofer(dot)de>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" |
Date: | 2010-03-30 14:47:59 |
Message-ID: | 4BB20F1F.3010202@squeakycode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 3/30/2010 8:55 AM, moataz Elmasry wrote:
> 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
>
It could be the pg_hba file. Default has local set to trust... maybe
suse changed to it md5 or something... ya know.. to be "secure" :-)
-Andy
From | Date | Subject | |
---|---|---|---|
Next Message | moataz Elmasry | 2010-03-30 14:57:34 | Re: createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres" |
Previous Message | Tom Lane | 2010-03-30 14:34:28 | Re: different behaviour between select and delete when constraint_exclusion = partition |