Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9F91363294D for ; Tue, 2 Mar 2010 08:25:57 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 78576-03 for ; Tue, 2 Mar 2010 12:25:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id A662E632261 for ; Tue, 2 Mar 2010 08:25:46 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 2AEA311C0216; Tue, 2 Mar 2010 13:25:42 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id l0VodF0zc7sJ; Tue, 2 Mar 2010 13:25:37 +0100 (CET) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTP id 7BD5A11C0012; Tue, 2 Mar 2010 13:25:37 +0100 (CET) Subject: Re: password authentication failed for user postgres From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: Major Services Cc: pgsql-admin@postgresql.org In-Reply-To: <375c2da1003020310s230b28a3g8c4b5e6d3e264490@mail.gmail.com> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003020233oa934b97xb478f577f0606969@mail.gmail.com> <1267527741.2942.113.camel@deimos> <375c2da1003020310s230b28a3g8c4b5e6d3e264490@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-dTZDZLY/Fv7J2lQjQOKG" Date: Tue, 02 Mar 2010 13:25:38 +0100 Message-ID: <1267532738.2942.116.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.28.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.738 tagged_above=-10 required=5 tests=BAYES_20=-0.74, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201003/9 X-Sequence-Number: 33808 --=-dTZDZLY/Fv7J2lQjQOKG Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit Ah... ok. In /var/lib/pgsql you will find a file called pgstartup.log Could you post here last lines of this file ? -----Original Message----- From: Major Services To: Iñigo Martinez Lasala Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] password authentication failed for user postgres Date: Tue, 2 Mar 2010 16:40:47 +0530 But the server restart has failed; I am yet to make the changes suggested by you in the first instance. On Tue, Mar 2, 2010 at 4:32 PM, Iñigo Martinez Lasala wrote: Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat compilation does not have ident enabled... local all postgres trust -----Original Message----- From: Major Services To: Iñigo Martinez Lasala Subject: Re: [ADMIN] password authentication failed for user postgres Date: Tue, 2 Mar 2010 16:03:59 +0530 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 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 > To: pgsql-admin@postgresql.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 > > > --=-dTZDZLY/Fv7J2lQjQOKG Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit Ah... ok.
In /var/lib/pgsql you will find a file called pgstartup.log
Could you post here last lines of this file ?


-----Original Message-----
From: Major Services <services.major@gmail.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Tue, 2 Mar 2010 16:40:47 +0530

But the server restart has failed; I am yet to make the changes suggested by you in the first instance.




On Tue, Mar 2, 2010 at 4:32 PM, Iñigo Martinez Lasala <imartinez@vectorsf.com> wrote:
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat compilation does not have ident enabled...

local all postgres trust



-----Original Message-----
From: Major Services <services.major@gmail.com>


To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Subject: Re: [ADMIN] password authentication failed for user postgres
Date: Tue, 2 Mar 2010 16:03:59 +0530

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@vectorsf.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.major@gmail.com>
> To: pgsql-admin@postgresql.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
>
>
>





--=-dTZDZLY/Fv7J2lQjQOKG--