Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 602906326EF for ; Tue, 2 Mar 2010 07:11:00 -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 66477-04 for ; Tue, 2 Mar 2010 11:10:49 +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 4B739632416 for ; Tue, 2 Mar 2010 07:10:49 -0400 (AST) Received: by wwa36 with SMTP id 36so59677wwa.19 for ; Tue, 02 Mar 2010 03:10:47 -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:cc:content-type; bh=m6Ga+rlTmnqCWZ6I4QZ0/N8OqgLTPQSoRBH+r4RgHeg=; b=C0XzJ4rKgIajmat6z5F0qWuLyVHFy6IVtTvM5hpOw8BsjBrqZ/jaoER8eSOZYFshLJ In77qiJYWKDJHttyMth+jmO3aRZ2auhhDO2ULIzFhkD2BvUqQyZUEah4pSoO55NLb4Yi a+10O4wNS/HgDpzHk+07CgaCP5LIsamj1Ec70= 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 :cc:content-type; b=xe9CrhnS+g8PtrLYUKiPV0/g8YH67j58WluSXLjDq1PRFGtCPzTThbJWGoQ5/6e1WD se6My+XIroUu4jDm7bbqmn7YFNl40tKJU5AoAnwRSRrqpvT/hBpdoZ2VXO1ZcEKVPmy7 kU6uFEBD/rMIzpn6XPRaPU85dH+45RW/fglGE= MIME-Version: 1.0 Received: by 10.216.90.202 with SMTP id e52mr3918891wef.150.1267528247245; Tue, 02 Mar 2010 03:10:47 -0800 (PST) In-Reply-To: <1267527741.2942.113.camel@deimos> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003020233oa934b97xb478f577f0606969@mail.gmail.com> <1267527741.2942.113.camel@deimos> Date: Tue, 2 Mar 2010 16:40:47 +0530 Message-ID: <375c2da1003020310s230b28a3g8c4b5e6d3e264490@mail.gmail.com> Subject: Re: password authentication failed for user postgres From: Major Services To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0016e6d7ee57eb7e250480cf6ade X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.597 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201003/8 X-Sequence-Number: 33807 --0016e6d7ee57eb7e250480cf6ade Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable But the server restart has failed; I am yet to make the changes suggested b= y you in the first instance. On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo 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 > > > *To*: I=F1igo 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=F1igo 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 goin= t > 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 > > > > > > > > > --0016e6d7ee57eb7e250480cf6ade Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable But the server restart has failed; I am yet to make the changes suggested b= y you in the first instance.




= On Tue, Mar 2, 2010 at 4:32 PM, I=F1igo Martinez Lasala &= lt;imartinez@vectorsf.com>= wrote:
=20 =20
Try with these parameters in pg_hba.conf. Perhaps your postgres-redhat comp= ilation does not have ident enabled...

local all postgres trust



-----Original Message-----
From: Major Services <services.major@gmail.com>= ;
To: I=F1igo Martinez Lasala = <imartinez@vectorsf.= com>
Subject: Re: [ADMIN] password authentication failed for user postgre= s
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=F1igo Martinez Lasala <imartinez@vectorsf.com>= wrote:
> In order to lauch createuser you don't need to modify listen_addre= ss 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=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=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 user.
>
>
> -----Original Message-----
> From: Major Services <services.major@gmail.com>
> To: pg= sql-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 =A0listen_addresses =3D '*' ; in =A0postgresql= .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 all =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 createuser I get the following message =A0:
> 'createuser: could not connect to database postgres: =A0FATAL : > 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 appreciate= d.
>
> Thanks
> Viv
>
>
>



--0016e6d7ee57eb7e250480cf6ade--