Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2DCF8632245 for ; Tue, 2 Mar 2010 07:00:45 -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 65637-02 for ; Tue, 2 Mar 2010 11:00:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f46.google.com (mail-ww0-f46.google.com [74.125.82.46]) by mail.postgresql.org (Postfix) with ESMTP id 76C5E6326EF for ; Tue, 2 Mar 2010 07:00:34 -0400 (AST) Received: by wwa36 with SMTP id 36so55205wwa.19 for ; Tue, 02 Mar 2010 03:00:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=/jabAcWh2mrT7kXfyyW1movG7ks2CDFqKGsMtkSWsl4=; b=IZCCjgigYz4Kj0c5jPP+prKiJtjRFsSmeK+BkloWhXFdaquvXoriJalyONQtInDE9B 9W3JmXYsexl+9Qb6Cj2FiGcz0UFrCBstAXUU3pkiNM6P1rJQe+u58GZLel0rWooXra6Y uZkN1ilFmOFUBFHd+v88W+CM+YqNAlsOPO520= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=DNFGwIEqfDkBcaiYpej43la2DVp0sz/j8Sd0K1tmQZ27JL1O8BAuiaiO0N+SdSq2Wn tgh5Xdeks0oi9zLsRiPS/n+Hd+7Q7BN3/rctNu8G3lckhB8044ZzBq/oqeNPSuryuv97 CaS+6Aak9mPP1zfHqDiOhqrWXMMbLP6jjY+iQ= MIME-Version: 1.0 Received: by 10.216.174.133 with SMTP id x5mr2267357wel.55.1267527629503; Tue, 02 Mar 2010 03:00:29 -0800 (PST) In-Reply-To: <375c2da1003020233oa934b97xb478f577f0606969@mail.gmail.com> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003020233oa934b97xb478f577f0606969@mail.gmail.com> Date: Tue, 2 Mar 2010 16:30:29 +0530 Message-ID: <375c2da1003020300v119849bfo174747328a1b877@mail.gmail.com> Subject: Fwd: password authentication failed for user postgres From: Major Services To: pgsql-admin@postgresql.org, imartinez@vectorsf.com Content-Type: multipart/alternative; boundary=0016e649849a197da20480cf4674 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/7 X-Sequence-Number: 33806 --0016e649849a197da20480cf4674 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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=F1igo Martinez Lasala < imartinez@vectorsf.com> wrote: > In order to lauch createuser you don't need to modify listen_address sinc= e > 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 =3D '*' ; 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 > > > --0016e649849a197da20480cf4674 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Thank you for your message. But am in another pr= oblem now.
In between I also tried to restart the server with 'servi= ce postgresql restart'
It stopped the server, but then server sta= rt failed.
Had restarted earlier also, without a problem.

What should I do?


On Tue, Mar = 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala <imartinez@vectorsf.com> wrote:
&= gt; In order to lauch createuser you don't need to modify listen_addres= s since
> you can use unix sockets. But anyway it's a requirement if you are= goint to
> access remotely.
>
> Add this line in first p= lace to your pg_hba.conf
> local=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 po= stgres=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0 ident sameuser
>
>
> Reload postgresql and launch createuser as postgres us= er.
>
>
> -----Original Message-----
> From: Major = Services <= services.major@gmail.com>
> To: pg= sql-admin@postgresql.org
> Subject: [ADMIN] password authenticati= on failed for user postgres
> Date: Tue, 2 Mar 2010 14:13:10 +0530 >
> Hi,
>
> 1. I have added =A0listen_addresses =3D '*' ; in =A0po= stgresql.conf
>
> 2. And have made the following changes to pg_= hba.conf
>
> local =A0 DATABASE =A0 =A0USER =A0 METHOD
> = local =A0 =A0samegroup =A0 =A0 =A0all =A0 =A0 =A0password
> host =A0 =A0DATABASE =A0 =A0USER =A0 =A0CIDR-ADDRESS =A0METHOD =A0[OPT= ION]
> host =A0 =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 al= l =A0 =A0 =A0 0.0.0.0/0 = =A0 =A0 =A0 =A0 =A0 =A0 md5
> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 all =A0 =A0 =A0 0.0.0.0/0 =A0 =A0 =A0 =A0 =A0 =A0md5
>
> 3. Have restarted the server
>
> 4. I can login to= the server as user postgres.
>
> But =A0while trying to create= user I get the following message =A0:
> 'createuser: could not co= nnect to database postgres: =A0FATAL :
> password authentication failed for user "postgres"
>> This is on Redhat running Plesk also.
>
> I am new to Li= nux as well as PostgreSQL. Help would be much appreciated.
>
> Thanks
> Viv
>
>
>


--0016e649849a197da20480cf4674--