From: | Major Services <services(dot)major(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, imartinez(at)vectorsf(dot)com |
Subject: | Fwd: password authentication failed for user postgres |
Date: | 2010-03-02 11:00:29 |
Message-ID: | 375c2da1003020300v119849bfo174747328a1b877@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you for your message. But am in another problem now.
In between I also tried to restart the server with 'service postgresql
restart'
It stopped the server, but then *server start failed*.
Had restarted earlier also, without a problem.
What should I do?
On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala <
imartinez(at)vectorsf(dot)com> wrote:
> In order to lauch createuser you don't need to modify listen_address since
> you can use unix sockets. But anyway it's a requirement if you are goint
to
> access remotely.
>
> Add this line in first place to your pg_hba.conf
> local all postgres ident sameuser
>
>
> Reload postgresql and launch createuser as postgres user.
>
>
> -----Original Message-----
> From: Major Services <services(dot)major(at)gmail(dot)com>
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] password authentication failed for user postgres
> Date: Tue, 2 Mar 2010 14:13:10 +0530
>
> Hi,
>
> 1. I have added listen_addresses = '*' ; in postgresql.conf
>
> 2. And have made the following changes to pg_hba.conf
>
> local DATABASE USER METHOD
> local samegroup all password
> host DATABASE USER CIDR-ADDRESS METHOD [OPTION]
> host all all 0.0.0.0/0 md5
> hostssl all all 0.0.0.0/0 md5
>
> 3. Have restarted the server
>
> 4. I can login to the server as user postgres.
>
> But while trying to createuser I get the following message :
> 'createuser: could not connect to database postgres: FATAL :
> password authentication failed for user "postgres"
>
> This is on Redhat running Plesk also.
>
> I am new to Linux as well as PostgreSQL. Help would be much appreciated.
>
> Thanks
> Viv
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Major Services | 2010-03-02 11:10:47 | Re: password authentication failed for user postgres |
Previous Message | Iñigo Martinez Lasala | 2010-03-02 09:14:13 | Re: password authentication failed for user postgres |